Hey guys. I wanted to say thank you for all the laughs and fun. I made this for you guys as a thank you. Its OC...

Question

Hey guys. I wanted to say thank you for all the laughs and fun. I made this for you guys as a thank you. Its OC...

Alexander Scott

Hey guys. I wanted to say thank you for all the laughs and fun. I made this for you guys as a thank you. Its OC. This is the first time its been posted on the internet.

I made it with Google Sheets. You guys can make a copy and make your own roll sheets. I also put in a script that will randomly displays a spaceship based on a random number that get generated. Google sheets also have formulas that can create the same affect. I am also making a choose your own adventure game based entirely in Google Sheets.

BTW, there was a small update to Google Sheets recently. Images can be placed directly into a cell rather than floating on top of the spreadsheet.

What do guys think?

Attached: public spaceship roll game-1.png (2200x1700, 444K)

April 8, 2019 - 01:42

Other urls found in this thread:

docs.google.com/spreadsheets/d/1C5QbNg_eOBqtSRzIaP5nwvDAQCghcJomLU2SZhl6t6w/edit#gid=317938084
twitter.com/NSFWRedditGif

Samuel Lopez

I hope at least one person is interested. I spent a long time to make it.

Attached: crying.jpg (800x450, 50K)

April 8, 2019 - 01:53

Thomas Allen

Here is a direct link if anyone wants to see it.

docs.google.com/spreadsheets/d/1C5QbNg_eOBqtSRzIaP5nwvDAQCghcJomLU2SZhl6t6w/edit#gid=317938084

April 8, 2019 - 02:03

Oliver Clark

I saw two anonymous users opened it up! Thank you lurkers! At least I know someone saw it.

April 8, 2019 - 02:10

Ryan Phillips

youre cute and now i feel bad i wish i had time to play it right now :(

April 8, 2019 - 02:14

Evan Evans

Thank you. Its public for everyone, so you can check it out anytime you want.

April 8, 2019 - 02:16

Wyatt Morales

Wanna try it but I can't get it to work on mobile.

April 8, 2019 - 02:17

Grayson Stewart

Can I not just roll in this thread? Rolling.

April 8, 2019 - 02:19

Andrew Scott

This is the first OC Yea Forums has had since 2005 (excluding log posters)

April 8, 2019 - 02:20

Bentley Morris

I never tested it on mobile. Looking into it now.

You absolutely can. But if you want to make your own its available.

April 8, 2019 - 02:21

Jace Adams

I think I just can’t wait to run some scripts that were posted here. Fuck off.

April 8, 2019 - 02:21

Elijah Sullivan

>2
no because it needs to be a number between 1-99

April 8, 2019 - 02:22

Christian King

>no Moya
kys

April 8, 2019 - 02:24

Henry Gomez

That's very sweet, OP. It's nice to see something wholesome here for once.

April 8, 2019 - 02:24

Jason Lewis

I tested it on mobile. I have a android and use chrome browser. If you have the spreadsheet open in chrome, and opened it as a desktop site it does work.

April 8, 2019 - 02:26

Colton Walker

Aww

April 8, 2019 - 02:27

Zachary Rivera

You can play with your post number. If you get 00 thats doubles.

What is moya?

Thanks.

Your welcome. I really worked hard on it.

April 8, 2019 - 02:29

Luis King

>Hey guys. I wanted to say thank you for all the laughs and fun.

I thought this was another Imma-commit-suicide thread lol. Sweet work, OP.

April 8, 2019 - 02:30

Austin Nelson

Heyy OP,how does this work?I have never seen anything like it,but it seems interesting

Attached: A3B72FE9-DA91-4992-AD58-4024FAFEDCD0.jpg (478x478, 66K)

April 8, 2019 - 02:31

Leo King

You make a copy and press the picture of the dice. Then you set permission for it to run.

Spreadsheets have scripting capabilities that can do lots of things. I wrote a script in Google Appscript that generates a random number from 0 to 100, based on what number is generated you get a spaceship in the spreadsheet.

To see the code make a copy and go to Tools -> Script Editor.

I will post the code in sections.

April 8, 2019 - 02:36

Kayden Young

function play_game() {
ss = SpreadsheetApp.getActive().getSheetByName("Sheet1")
ss.getRange("F1").setValue(Math.floor(Math.random() * 100) )
ss.getRange("F2").setValue(ss.getRange("F2").getValue() + 1)
randnum = ss.getRange("F1").getValue()

if(randnum == 1|| randnum == 2||randnum == 3){ss.getRange('B5').copyTo(ss.getRange("F5"));}
else if(randnum == 4|| randnum == 5||randnum == 6){ss.getRange('C5').copyTo(ss.getRange("F5"));}
else if(randnum == 7|| randnum == 8||randnum == 9){ss.getRange('D5').copyTo(ss.getRange("F5"));}
else if(randnum == 10|| randnum == 12||randnum == 13){ss.getRange('B7').copyTo(ss.getRange("F5"));}
else if(randnum == 14|| randnum == 15||randnum == 16){ss.getRange('C7').copyTo(ss.getRange("F5"));}
else if(randnum == 17|| randnum == 18||randnum == 19){ss.getRange('D7').copyTo(ss.getRange("F5"));}
else if(randnum == 20|| randnum == 21||randnum == 23){ss.getRange('B9').copyTo(ss.getRange("F5"));}
else if(randnum == 24|| randnum == 25||randnum == 26){ss.getRange('C9').copyTo(ss.getRange("F5"));}
else if(randnum == 27|| randnum == 28||randnum == 29){ss.getRange('D9').copyTo(ss.getRange("F5"));}
else if(randnum == 30|| randnum == 31||randnum == 32){ss.getRange('B11').copyTo(ss.getRange("F5"));}
else if(randnum == 34|| randnum == 35||randnum == 36){ss.getRange('C11').copyTo(ss.getRange("F5"));}
else if(randnum == 37|| randnum == 38||randnum == 39){ss.getRange('D11').copyTo(ss.getRange("F5"));}
else if(randnum == 40|| randnum == 41||randnum == 42){ss.getRange('B13').copyTo(ss.getRange("F5"));}
else if(randnum == 43|| randnum == 45||randnum == 46){ss.getRange('C13').copyTo(ss.getRange("F5"));}
else if(randnum == 47|| randnum == 48||randnum == 49){ss.getRange('D13').copyTo(ss.getRange("F5"));}
else if(randnum == 50|| randnum == 51||randnum == 52){ss.getRange('B15').copyTo(ss.getRange("F5"));}

April 8, 2019 - 02:37

Ryan Cooper

else if(randnum == 53|| randnum == 54||randnum == 56){ss.getRange('C15').copyTo(ss.getRange("F5"));}
else if(randnum == 57|| randnum == 58||randnum == 59){ss.getRange('D15').copyTo(ss.getRange("F5"));}
else if(randnum == 60|| randnum == 61||randnum == 62){ss.getRange('B17').copyTo(ss.getRange("F5"));}
else if(randnum == 63|| randnum == 64||randnum == 65){ss.getRange('C17').copyTo(ss.getRange("F5"));}
else if(randnum == 67|| randnum == 68||randnum == 69){ss.getRange('D17').copyTo(ss.getRange("F5"));}
else if(randnum == 70|| randnum == 71||randnum == 72){ss.getRange('B19').copyTo(ss.getRange("F5"));}
else if(randnum == 73|| randnum == 74||randnum == 75){ss.getRange('C19').copyTo(ss.getRange("F5"));}
else if(randnum == 76|| randnum == 77||randnum == 78){ss.getRange('D19').copyTo(ss.getRange("F5"));}
else if(randnum == 80|| randnum == 81||randnum == 82){ss.getRange('B21').copyTo(ss.getRange("F5"));}
else if(randnum == 83|| randnum == 84||randnum == 85){ss.getRange('C21').copyTo(ss.getRange("F5"));}
else if(randnum == 86|| randnum == 87||randnum == 89){ss.getRange('D21').copyTo(ss.getRange("F5"));}
else if(randnum == 90|| randnum == 91||randnum == 92){ss.getRange('B23').copyTo(ss.getRange("F5"));}
else if(randnum == 93|| randnum == 94||randnum == 95){ss.getRange('C23').copyTo(ss.getRange("F5"));}
else if(randnum == 96|| randnum == 97||randnum == 98){ss.getRange('D23').copyTo(ss.getRange("F5"));}
else{ss.getRange('A1').copyTo(ss.getRange("F5"));}
ss.getRange('F5:I9').merge();

April 8, 2019 - 02:38

Alexander Clark

if(randnum == 1|| randnum == 2||randnum == 3){ss.getRange('B4').copyTo(ss.getRange("F4"));}
else if(randnum == 4|| randnum == 5||randnum == 6){ss.getRange('C4').copyTo(ss.getRange("F4"));}
else if(randnum == 7|| randnum == 8||randnum == 9){ss.getRange('D4').copyTo(ss.getRange("F4"));}
else if(randnum == 10|| randnum == 12||randnum == 13){ss.getRange('B6').copyTo(ss.getRange("F4"));}
else if(randnum == 14|| randnum == 15||randnum == 16){ss.getRange('C6').copyTo(ss.getRange("F4"));}
else if(randnum == 17|| randnum == 18||randnum == 19){ss.getRange('D6').copyTo(ss.getRange("F4"));}
else if(randnum == 20|| randnum == 21||randnum == 23){ss.getRange('B8').copyTo(ss.getRange("F4"));}
else if(randnum == 24|| randnum == 25||randnum == 26){ss.getRange('C8').copyTo(ss.getRange("F4"));}
else if(randnum == 27|| randnum == 28||randnum == 29){ss.getRange('D8').copyTo(ss.getRange("F4"));}
else if(randnum == 30|| randnum == 31||randnum == 32){ss.getRange('B10').copyTo(ss.getRange("F4"));}
else if(randnum == 34|| randnum == 35||randnum == 36){ss.getRange('C10').copyTo(ss.getRange("F4"));}
else if(randnum == 37|| randnum == 38||randnum == 39){ss.getRange('D10').copyTo(ss.getRange("F4"));}
else if(randnum == 40|| randnum == 41||randnum == 42){ss.getRange('B12').copyTo(ss.getRange("F4"));}
else if(randnum == 43|| randnum == 45||randnum == 46){ss.getRange('C12').copyTo(ss.getRange("F4"));}
else if(randnum == 47|| randnum == 48||randnum == 49){ss.getRange('D12').copyTo(ss.getRange("F4"));}

April 8, 2019 - 02:39

Levi Lewis

else if(randnum == 50|| randnum == 51||randnum == 52){ss.getRange('B14').copyTo(ss.getRange("F4"));}
else if(randnum == 53|| randnum == 54||randnum == 56){ss.getRange('C14').copyTo(ss.getRange("F4"));}
else if(randnum == 57|| randnum == 58||randnum == 59){ss.getRange('D14').copyTo(ss.getRange("F4"));}
else if(randnum == 60|| randnum == 61||randnum == 62){ss.getRange('B16').copyTo(ss.getRange("F4"));}
else if(randnum == 63|| randnum == 64||randnum == 65){ss.getRange('C16').copyTo(ss.getRange("F4"));}
else if(randnum == 67|| randnum == 68||randnum == 69){ss.getRange('D16').copyTo(ss.getRange("F4"));}
else if(randnum == 70|| randnum == 71||randnum == 72){ss.getRange('B18').copyTo(ss.getRange("F4"));}
else if(randnum == 73|| randnum == 74||randnum == 75){ss.getRange('C18').copyTo(ss.getRange("F4"));}
else if(randnum == 76|| randnum == 77||randnum == 78){ss.getRange('D18').copyTo(ss.getRange("F4"));}
else if(randnum == 80|| randnum == 81||randnum == 82){ss.getRange('B20').copyTo(ss.getRange("F4"));}
else if(randnum == 83|| randnum == 84||randnum == 85){ss.getRange('C20').copyTo(ss.getRange("F4"));}
else if(randnum == 86|| randnum == 87||randnum == 89){ss.getRange('D20').copyTo(ss.getRange("F4"));}
else if(randnum == 90|| randnum == 91||randnum == 92){ss.getRange('B22').copyTo(ss.getRange("F4"));}
else if(randnum == 93|| randnum == 94||randnum == 95){ss.getRange('C22').copyTo(ss.getRange("F4"));}
else if(randnum == 96|| randnum == 97||randnum == 98){ss.getRange('D22').copyTo(ss.getRange("F4"));}
else{ss.getRange("F4").setValue("Armada!!");}
ss.getRange('F4:I4').merge();
ss.getRange('D1').activate();
}

Thats all of the code.

April 8, 2019 - 02:40

Charles Bell

Thanks man.

April 8, 2019 - 02:40

Easton Reed

OK cool ty

April 8, 2019 - 02:45

Asher Scott

I will improve and simplify the code probably by next week guys. Looking at it now I realize I don't need to check the randnum variable twice.

April 8, 2019 - 02:52

1 2 3 Next

Hey guys. I wanted to say thank you for all the laughs and fun. I made this for you guys as a thank you. Its OC...

Last threads