Really love using this! :D
TOPIC | [TOOL] Mega Projects Spreadsheet
I absolutely love this! I have tried a bunch of different spreadsheet trackers, but this one is my new favorite!
One question: Would it break it if I create more tabs to track other things, as long as I don't delete the existing ones?
One question: Would it break it if I create more tabs to track other things, as long as I don't delete the existing ones?
I absolutely love this! I have tried a bunch of different spreadsheet trackers, but this one is my new favorite!
One question: Would it break it if I create more tabs to track other things, as long as I don't delete the existing ones?
One question: Would it break it if I create more tabs to track other things, as long as I don't delete the existing ones?
@Ethuiliel "One question: Would it break it if I create more tabs to track other things, as long as I don't delete the existing ones?" Sorry it took so long for me to get back to you, I presume you've already tested by now but just in case not - Yep, it should be perfectly safe!
The Apparel Data sheet has been updated once again! The Gene Data sheet is typically kept very up-to-date, so that one has been accurate for a while still and is good to go.
There's a whole lot of different variables that go into the Apparel Data, so that sheet is starting to get a little "heavy", so I will have to eventually go through it and see about splitting the apparel up into groups. Though that's for a later time...
The Apparel Data sheet has been updated once again! The Gene Data sheet is typically kept very up-to-date, so that one has been accurate for a while still and is good to go.
There's a whole lot of different variables that go into the Apparel Data, so that sheet is starting to get a little "heavy", so I will have to eventually go through it and see about splitting the apparel up into groups. Though that's for a later time...
@Ethuiliel "One question: Would it break it if I create more tabs to track other things, as long as I don't delete the existing ones?" Sorry it took so long for me to get back to you, I presume you've already tested by now but just in case not - Yep, it should be perfectly safe!
The Apparel Data sheet has been updated once again! The Gene Data sheet is typically kept very up-to-date, so that one has been accurate for a while still and is good to go.
There's a whole lot of different variables that go into the Apparel Data, so that sheet is starting to get a little "heavy", so I will have to eventually go through it and see about splitting the apparel up into groups. Though that's for a later time...
The Apparel Data sheet has been updated once again! The Gene Data sheet is typically kept very up-to-date, so that one has been accurate for a while still and is good to go.
There's a whole lot of different variables that go into the Apparel Data, so that sheet is starting to get a little "heavy", so I will have to eventually go through it and see about splitting the apparel up into groups. Though that's for a later time...
*~*~*~*~*
Previously Morichinatsu *~*~*~*~* |
I
polar bears and s |
The new Harvest apparel has been added~
The new Harvest apparel has been added~
*~*~*~*~*
Previously Morichinatsu *~*~*~*~* |
I
polar bears and s |
Hi i just started using this and im loving all the features but im having problem with the dragon input, like my in the 14 row, the sec gene and tert gene, its only showing me primary genes
Hi i just started using this and im loving all the features but im having problem with the dragon input, like my in the 14 row, the sec gene and tert gene, its only showing me primary genes
> Fr+16 |
@OatCrunch Hello! Unfortunately I'm not experiencing this issue on the template spreadsheet to know what might've happened with yours.
On the spaces that are having issues, you should be able to right-click the space and find "Data validation" at the bottom of the list of options. For the Secondary gene, the Data validation range should say ='Gene Import'!$AS$4:$AS$1001, most notably the AS parts. For the Tertiary gene, it should be AT instead of AS. If these are wrong, you can update the Data validation, and then copy the cell itself to more easily update any other ones that are similarly broken.
Hopefully this fixes it, and if not, we can keep looking! If anything was confusing feel free to give me a holler and I'll do my best to rephrase it!
On the spaces that are having issues, you should be able to right-click the space and find "Data validation" at the bottom of the list of options. For the Secondary gene, the Data validation range should say ='Gene Import'!$AS$4:$AS$1001, most notably the AS parts. For the Tertiary gene, it should be AT instead of AS. If these are wrong, you can update the Data validation, and then copy the cell itself to more easily update any other ones that are similarly broken.
Hopefully this fixes it, and if not, we can keep looking! If anything was confusing feel free to give me a holler and I'll do my best to rephrase it!
@OatCrunch Hello! Unfortunately I'm not experiencing this issue on the template spreadsheet to know what might've happened with yours.
On the spaces that are having issues, you should be able to right-click the space and find "Data validation" at the bottom of the list of options. For the Secondary gene, the Data validation range should say ='Gene Import'!$AS$4:$AS$1001, most notably the AS parts. For the Tertiary gene, it should be AT instead of AS. If these are wrong, you can update the Data validation, and then copy the cell itself to more easily update any other ones that are similarly broken.
Hopefully this fixes it, and if not, we can keep looking! If anything was confusing feel free to give me a holler and I'll do my best to rephrase it!
On the spaces that are having issues, you should be able to right-click the space and find "Data validation" at the bottom of the list of options. For the Secondary gene, the Data validation range should say ='Gene Import'!$AS$4:$AS$1001, most notably the AS parts. For the Tertiary gene, it should be AT instead of AS. If these are wrong, you can update the Data validation, and then copy the cell itself to more easily update any other ones that are similarly broken.
Hopefully this fixes it, and if not, we can keep looking! If anything was confusing feel free to give me a holler and I'll do my best to rephrase it!
*~*~*~*~*
Previously Morichinatsu *~*~*~*~* |
I
polar bears and s |
The spreadsheets have been updated and should now be caught up to the latest gene release!
The spreadsheets have been updated and should now be caught up to the latest gene release!
*~*~*~*~*
Previously Morichinatsu *~*~*~*~* |
I
polar bears and s |
The Gene Data spreadsheet has been updated for Aberrations! Please note that Hex does not currently have data for it due to an error on FR's end - Hex was not added to the Treasure Market stock. I've reported the issue and will update the spreadsheet once it has been added. Apologies for any confusion this may cause!
The Gene Data spreadsheet has been updated for Aberrations! Please note that Hex does not currently have data for it due to an error on FR's end - Hex was not added to the Treasure Market stock. I've reported the issue and will update the spreadsheet once it has been added. Apologies for any confusion this may cause!
*~*~*~*~*
Previously Morichinatsu *~*~*~*~* |
I
polar bears and s |
@Galaxtea
Just wanted to make a note that with the Abby update, I had to move everything to a new copy I made. The existing copy would show the addition of the Aberrations and the genes and such, but when I added a new scry preview that included any of that, it would make those new additions no longer show up and would break the gene projects page. It all works fine now that I'm on a new copy but I thought I'd mention it in case it was something unusual with existing copies made before the update.
Just wanted to make a note that with the Abby update, I had to move everything to a new copy I made. The existing copy would show the addition of the Aberrations and the genes and such, but when I added a new scry preview that included any of that, it would make those new additions no longer show up and would break the gene projects page. It all works fine now that I'm on a new copy but I thought I'd mention it in case it was something unusual with existing copies made before the update.
@Galaxtea
Just wanted to make a note that with the Abby update, I had to move everything to a new copy I made. The existing copy would show the addition of the Aberrations and the genes and such, but when I added a new scry preview that included any of that, it would make those new additions no longer show up and would break the gene projects page. It all works fine now that I'm on a new copy but I thought I'd mention it in case it was something unusual with existing copies made before the update.
Just wanted to make a note that with the Abby update, I had to move everything to a new copy I made. The existing copy would show the addition of the Aberrations and the genes and such, but when I added a new scry preview that included any of that, it would make those new additions no longer show up and would break the gene projects page. It all works fine now that I'm on a new copy but I thought I'd mention it in case it was something unusual with existing copies made before the update.
@raggirare Thanks for sharing your experience; I was debating whether it was worth trying to update my copy myself to avoid moving over all my projects, or use an updated master sheet, and I think you solved that debate for me. <3
@raggirare Thanks for sharing your experience; I was debating whether it was worth trying to update my copy myself to avoid moving over all my projects, or use an updated master sheet, and I think you solved that debate for me. <3