PDA

View Full Version : Saga spreadsheet



peng
06-16-2017, 09:33 AM
I've been meaning to post this for a while now. EllisDee37's https://www.ddo.com/forums/showthread.php/487330-Compendium-Lite and the talk of adding a saga planner to it is what finally got me moving. I already don't know how I ever got along without it :).

https://docs.google.com/spreadsheets/d/1K3X__Cag_r3UdAuLjtkOJnOsi6NFlgmGV0fOEoR1_0Y

That link is view only. To get your own editable version, once you open the link, just click File > Make a copy... to, well, make a copy.

The only cells that you should need to change are the ones with the little down arrows. 0 or blank for not run, 1 for normal/casual, 2 for hard, 3 for elite.
The top row keeps a running total of how many points you have in each saga, 2nd row keeps a running total of how many quests you've run in each saga, followed by how many points are needed for normal/hard/elite/true elite saga completion. Also, each cell in the top row will change background color if you qualify for a saga reward. Blue for normal, green for hard, orange for elite, red for true elite. If you forget which color is which, just scroll down to the bottom.

The heroic sagas are green, the epics are red. All the quest and saga names should link to their respective wiki pages, as well as the Quests \ Sagas cell linking to the general saga page.

I recommend leaving the master sheet alone, and duplicating it for each toon you want to track. Just click the sheet name at the bottom, and click duplicate. I already made a duplicate that you can rename.

Cordovan
06-16-2017, 10:26 AM
Thanks for sharing this.

Niminae
06-23-2017, 06:26 AM
This is really nice. I've long used a similar spreadsheet, but it was just a cut'n'paste from the wiki with one new column where I broke out the quest levels since the wiki lists both the heroic and/or epic quests levels in the same column. Yours has a lot of other nice functionality, but I didn't see quest level anywhere, and using my spreadsheet I found it handy to sort by that column and then run the quests by level regardless of which Saga(s) they were a member of. And I would just note completion with a 'Y,' and clear it when I turned in or TRed. I probably should have made a drop down for tracking completion with N/H/E or a blank field (or 'None' or something similar for ones I hadn't run yet) instead of just using 'Y' or blank, but I pretty much just run Elite so it wasn't an issue for me. But it might be a good idea for your spreadsheet if you're interested in making that change.


That link is view only. To get your own editable version, once you open the link, just click File > Make a copy... to, well, make a copy.


When I did this it looks like it parked it in my OneDrive, or something. Selecting 'File -> Download as -> Microsoft XL' gave me a more familiar file folder view to park the spreadsheet where I wanted it.

JOTMON
06-23-2017, 09:14 AM
Thanks for sharing this.

challenge: figure out how to integrate this into the game instead of using outside apps...

peng
09-13-2017, 04:35 PM
This is really nice. I've long used a similar spreadsheet, but it was just a cut'n'paste from the wiki with one new column where I broke out the quest levels since the wiki lists both the heroic and/or epic quests levels in the same column. Yours has a lot of other nice functionality, but I didn't see quest level anywhere, and using my spreadsheet I found it handy to sort by that column and then run the quests by level regardless of which Saga(s) they were a member of. And I would just note completion with a 'Y,' and clear it when I turned in or TRed. I probably should have made a drop down for tracking completion with N/H/E or a blank field (or 'None' or something similar for ones I hadn't run yet) instead of just using 'Y' or blank, but I pretty much just run Elite so it wasn't an issue for me. But it might be a good idea for your spreadsheet if you're interested in making that change.



When I did this it looks like it parked it in my OneDrive, or something. Selecting 'File -> Download as -> Microsoft XL' gave me a more familiar file folder view to park the spreadsheet where I wanted it.

Sorry it took me so long to reply.

Just added levels.

If you're signed in to a google account you can go to File>Make a copy... to add a copy to your account.

Not sure what it looks like in excel, but in google sheets, the only allowed values are 0, 1, 2, 3 (or blank) for not run, normal, hard, elite. It also has a dropdown of those values. I guess I could set it to n/h/e, but it's much simpler with numbers.