Mowgli's Excel Adventure Tracker




What's on your mind?

+ Log in or register to post
Results 1 to 6 of 6
  1. #1
    Na Bith Mo Riocht T! COPPER SUBSCRIBER
    Lama (Lvl 13)

    Mowgli's Avatar

    Join Date
    Mar 2005
    Location
    Jonesboro, AR
    Posts
    12,275

    Ignore Mowgli
    My communities:

    Mowgli's Excel Adventure Tracker

    This is the Spreadsheet Adventure Tracker I developed to keep up with encounter and time based XP and GP through the course of LPF adventures.

    I think enough folks are using it now that it warrants a sticky so it doesn't get lost in the morass of posts in the General Discussion thread, or shoved to a back page.

    There's an instruction tab on the sheet that will (hopefully) answer any questions, but it's sketchy. My e-mail is listed on that tab as well, so if you find anything wrong with the sheet or have questions, just get in touch!

    It is an Excel 2010 file, and won't work correctly on earlier versions.
    Attached Files Attached Files
    Last edited by Mowgli; Tuesday, 15th October, 2013 at 02:03 PM.
    "Every normal man must be tempted, at times, to spit on his hands, hoist the black flag, and begin slitting throats."
    -- H.L. Mencken



    Legacy of Fire
    OOC IC

 

  • #2
    Na Bith Mo Riocht T! COPPER SUBSCRIBER
    Lama (Lvl 13)

    Mowgli's Avatar

    Join Date
    Mar 2005
    Location
    Jonesboro, AR
    Posts
    12,275

    Ignore Mowgli
    My communities:

    Thought it worth mentioning that the best way I've found to handle a changing cast is to separate the adventure into "acts," ending one act and starting the next on the day of the last post by the exiting cast member.

    I then use a separate tracking file for each act.
    "Every normal man must be tempted, at times, to spit on his hands, hoist the black flag, and begin slitting throats."
    -- H.L. Mencken



    Legacy of Fire
    OOC IC

  • #3
    Registered User
    Myrmidon (Lvl 10)



    Join Date
    Feb 2002
    Location
    Florida
    Posts
    8,877

    Ignore jkason
    My communities:

    I installed an xlsx converter at some point to my earlier version of Excel, and the resulting xls file actually seems to calculate right in Excel and even OpenOffice so far as I've been able to determine (Google Docs doesn't support the multi-sheet references in the formulas, at least not so I've found).

    The formatting is a bit odd (there are 'ghosts' of values in some of the calculating fields, for example), but the basic functionality seems to be there. The converter is on my work computer, but I can try to run it next week and attach the xls version if anyone else wants it?

    ETA: Down-converted to an xls file. As I said, the calculation functionality seems to be fine for me in Excel 2003 and the OpenOffice spreadsheet program.
    Attached Files Attached Files
    Last edited by jkason; Tuesday, 5th June, 2012 at 09:51 PM.
    **My most recent fiction is in Viridian Legacy: The Wasting of Duny Slough**

  • #4
    Na Bith Mo Riocht T! COPPER SUBSCRIBER
    Lama (Lvl 13)

    Mowgli's Avatar

    Join Date
    Mar 2005
    Location
    Jonesboro, AR
    Posts
    12,275

    Ignore Mowgli
    My communities:

    I got a report that the calculator was using 27 rather than 28 TXP for level 5 characters. I didn't look at the previous version posted, but the one I have on my hard drive seems correct so I just posted it as version 1.1 in the OP.

    Should be correct - let me know if you find other bugs. It's been a LONG time since I put together the file and the formulas and cell references are a hot mess of convoluted circular knots, but I'll try to remember the logic I used when putting it together and fix anything that goes wrong
    Last edited by Mowgli; Saturday, 2nd February, 2013 at 03:48 PM.
    "Every normal man must be tempted, at times, to spit on his hands, hoist the black flag, and begin slitting throats."
    -- H.L. Mencken



    Legacy of Fire
    OOC IC

  • #5
    Na Bith Mo Riocht T! COPPER SUBSCRIBER
    Lama (Lvl 13)

    Mowgli's Avatar

    Join Date
    Mar 2005
    Location
    Jonesboro, AR
    Posts
    12,275

    Ignore Mowgli
    My communities:

    Just made a minor modification to the Adventure Tracker - one of the little things that popped into my head and made me wonder why I'd never thought of it before. The latest version (1.3) takes time based gold into account when calculating the "Trsr +/-" box, making it easier for the GM to see how much he needs to fiddle with awarded treasure as the adventure progresses and those pesky TBG numbers pile up.

    I added a "Encounter Notes" tab in a previous version as well - just a place for the GM to drop in any random thoughts or notations about awarded treasure or any other thing that needs to be remembered about each encounter.

    Latest incarnation is now available in the first post.

    As always, if you run across errors (for any aspect, but especially for the recent changes) drop me a PM or an e-mail and let me know!

    Hope this continues to make your GMing lives a little easier!
    "Every normal man must be tempted, at times, to spit on his hands, hoist the black flag, and begin slitting throats."
    -- H.L. Mencken



    Legacy of Fire
    OOC IC

  • #6
    Na Bith Mo Riocht T! COPPER SUBSCRIBER
    Lama (Lvl 13)

    Mowgli's Avatar

    Join Date
    Mar 2005
    Location
    Jonesboro, AR
    Posts
    12,275

    Ignore Mowgli
    My communities:

    Minor fix - TXP at Level 8 now corrected to 89/Day.

    For now, don't forget to set your start date one day early. The way the Tracker counts days it doesn't use the Start Date as an active adventuring day. One day I might get 'round to fixing that . . .
    "Every normal man must be tempted, at times, to spit on his hands, hoist the black flag, and begin slitting throats."
    -- H.L. Mencken



    Legacy of Fire
    OOC IC

  • + Log in or register to post

    Similar Threads

    1. My Excel combat, inventory and exp tracker
      By Ghalleon in forum Older D&D Editions and OSR Gaming
      Replies: 4
      Last Post: Sunday, 18th March, 2012, 12:58 AM
    2. Simple Excel Combat tracker
      By Ghalleon in forum General RPG Discussion
      Replies: 0
      Last Post: Monday, 21st February, 2011, 04:06 AM
    3. Living Forgotten Realms Adventure Log (Excel, autocalculating)
      By thadwilliams in forum Older D&D Editions and OSR Gaming
      Replies: 0
      Last Post: Thursday, 4th June, 2009, 05:55 PM
    4. Magus' Excel 2007 Initiative Tracker DM Tool
      By Magus Coeruleus in forum Older D&D Editions and OSR Gaming
      Replies: 10
      Last Post: Wednesday, 3rd September, 2008, 03:28 PM
    5. Excel-based purchasing tracker / inventory manager?
      By Hyperlexic in forum Miscellaneous Geek Talk & Media Lounge
      Replies: 0
      Last Post: Friday, 16th February, 2007, 03:41 AM

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •