Yet Another
Dragon Project Tracker :D
=========================
I know there's probably tons of those out there but I recently revamped the one I was using so I felt like sharing because it kinda looks cool I guess.
>> [ THE LINK ] <<
Go to 'File > Make a Copy' so you can use it ^^
Quote:
Instructions
(these are also included inside the sheet if you need to check back)
• Enter the info in its respective places or select from the dropdown in each cell, the prices will be automatically added, according to the Price Data tab. To remove it, simply clear the cell and the price will go away too.
• You can freely create new rows or delete rows. Nothing should seriously break as long as you don't touch the headers (which are protected by a warning anyway).
• If #REF! shows up on the cells where things are calculated, that means you typed something into the price columns. Should be easy to correct because all cells will go blank except where the mistake is. Clearing the cell should get things back to normal.
• When new genes are released, add them to the Price Data tab with their respective prices. (They don't have to be alphabetically sorted to work, but if you'd like to keep your sheet more organized you can easily do it. Select all content cells in all three columns of a scroll type, then Right Click > Sort range... > A -- Z > Sort.)
(these are also included inside the sheet if you need to check back)
• Enter the info in its respective places or select from the dropdown in each cell, the prices will be automatically added, according to the Price Data tab. To remove it, simply clear the cell and the price will go away too.
• You can freely create new rows or delete rows. Nothing should seriously break as long as you don't touch the headers (which are protected by a warning anyway).
• If #REF! shows up on the cells where things are calculated, that means you typed something into the price columns. Should be easy to correct because all cells will go blank except where the mistake is. Clearing the cell should get things back to normal.
• When new genes are released, add them to the Price Data tab with their respective prices. (They don't have to be alphabetically sorted to work, but if you'd like to keep your sheet more organized you can easily do it. Select all content cells in all three columns of a scroll type, then Right Click > Sort range... > A -- Z > Sort.)
Credit
This sheet was made by me (@Shenzai) based on the one by @/isosDuke (which is apparently no longer updated). The basic formulas are mostly theirs, but I added a lot of things like colors/icons, missing genes, the eye tab, dropdowns, protected ranges (to avoid accidental edits that break the formulas) and the instructions tab. The original link is here: [Link]
If you have any questions or if anything is broken, feel free to leave a comment in this thread!
♥
.....
.....