Sorry if this is the wrong place to post this, I'm new and just really need the help with this
So I have a pretty extensive question that might be asking a lot, but I've been studying the past few days on how to use google Spreadsheet and google script to try and attempt making a Breeding Roller for an ARPG game i'm working on.
My only issue is, is I keep hitting lots of snags with codes and can't find how to fix the codes and make them work properly.
I also have other things I want to attempt doing with the Roller to make it usable to people without me having to give them an editor link.
Basically, I want my breeding roller to run like this:
https://gyazo.com/e30f1946514287e84e215a5e26bd9f4b
Where it takes the options for the drop down menus, runs them by 50/50 (Choosing between male - female, as well as the breed) And also to take the Geno's from the parents and choose a select few of them to give to the offspring
So far this is my layout:
https://gyazo.com/cafacdb77f0d0f10d3c5a6da57b27f43
And I've been using =if to assist with most of the process, these are specific lines of code I've used and have worked:
=IF(RANDBETWEEN(1,100)<=50, F10,G10)
=IF(H6="Yes","Inbred","Healthy")
But I'm also having a hard time figuring out how to get several lines of code to work together??
Ok for example, the status depends on if the clutch(Eggs) has slugs(Broken or dead Eggs) in them, Now if the option "Yes" is selected, I want the =if to run a 50/50 chance on all the babies and choose either "Alive" or "Deceased" for them
But if the option says "No" then I want =if to make all of the babies "Alive"
I've been trying this text and using the "AND" method to try and apply further code, but it refuses to work:
=IF(RANDBETWEEN(1,100)<=50, "Alive","Dceased",AND(I6="Yes"))
I also want to know if there's a way I can translate all of the code into script and turn it into a button that people can press, and then it makes all the choices and autofills in the respective lines for each
As well as how to make the script choose genos between the mother and father to put together!
If anyone can help that would be awesome and I really appreciate it!
برچسب:
نویسنده: آیلین رضوانی
تاريخ: سه
شنبه
19 دی
1396 ساعت: 17:24