World Lookup Tool for Pirates of Drinax

Discuss the Traveller RPG and its many settings
DickNervous
Stoat
Posts: 97
Joined: Sun Feb 15, 2015 5:49 pm
Location: Seaford, NY, Solomani Rim
Contact:

World Lookup Tool for Pirates of Drinax

Postby DickNervous » Tue May 12, 2015 5:52 pm

Hello everyone! I made this pretty cool spreadhseet that has all the system info for the Pirates of Drinax campaign in it for easy lookup and reference. I also included all the basic planetary info that you can get off TravellerMap.com along with descriptions of the UWP values, the ability to add personal notes, edit the campaign-related info, and much more.

Here is a rundown of the features:

Current Available Features
  • Comes pre-populated with all the basic planetary data from TravellerMap.com[3] for both the Trojan Reach and Spinward Marches sectors.
  • Also has the relevant data for planets from the Pirates of Drinax[4] campaign by Mongoose Publishing which includes descriptions of the planets, lists of patrons, missions, and rewards, and the planets "attitude" towards the player group.
  • Includes descriptions of each value in the UWP for each planet you look up to make it easy to know what is going on.
  • Includes breakdowns of the Bases, Nobility, and Trade codes into plain English
  • Will render a sub-sector map and Jump 1, 2, and 3 neighborhood maps for the selected planet via integration with TravellerMap.com.
  • Provides the user the ability to edit and save changes to the "System Notes" section for each planet right on the main page.
  • (PoD Specific) Central location to keep track of the groups Standing with the Aslan and Imperium
  • (PoD Specific) Central location to keep track of the attitude that each system has with the group.
Features Locked During Testing
NOTE: These are only locked so that people don't accidently mess somehting up and report a bug to me that I can't fix. This will all by unlocked once it is "released"
  • Edit all the lookup tables that fill in the World Data page
  • Create and add more sectors, custom sectors, and edit all the planetary info
  • Editing of the Subsector background text
  • Including Jump 4 and Jump 5 maps
  • Reformatting to your hearts content
Enhancement Ideas
  • Convert as much of the formulas as possible to VBA code for speed and efficiency
  • Code a routine to parse/format the Raw Sector Data from TravellerMap.com into the format used for the spreadsheet
  • Investigate feasibility/impact of moving back end data from the spreadsheets to a database. I think that unless someone wants to add data for more then 5-6 sectors that there is no real benefit for doing this.
The file is an Excel 2013 spreadsheet with macros and VBA. It should work with Excel 2007 or later (with the exception of some conditional formatting for color coding) but I have no way of testing that. It will NOT work with the web-based version of Excel. Since it is an XLSM file I can't attach it to this post. So here is a link to my Dropbox for everyone to grab it:
--->GET FILE HERE<---

One question I expect immediately it this:
Why is the file "protected" with a password? What are you trying to hide??!!!
The file is currently protected with a password but that is only so people can't make changes to it while it is still in testing. The last thing I need is for someone to accidentally change something then tell me a feature doesn't work and I spend days trying to figure it out. Once it is fully baked the password will be removed. If this is really a big issue for you, contact me directly.
I welcome any constructive criticism, feedback, suggestions, and ideas. You can reach me by replying to this thread here, over on the COTI forums, via reddit, or the email address that is on the intro page of the file. If you just want to scream at me that my choice of colors sucks, please step through that door over there. The one that says "Air Lock" and I will be right with you.....

Thanks!
----------------------------
Rich 'DickNervous' Neves
Baron of Ishala - VLAN 2113 Ishala C866651-9
Baron of Enaaka - DENE 0203 Enaaka B777786-6
Knight of Deneb - SPIN 1721 ARBA C200200-C
Nervoused.com
Solomani666
Lesser Spotted Mongoose
Posts: 782
Joined: Sun Mar 07, 2010 3:07 am

Re: World Lookup Tool for Pirates of Drinax

Postby Solomani666 » Wed May 13, 2015 12:19 am

DickNervous wrote:Hello everyone! I made this pretty cool spreadhseet that has all the system info for the Pirates of Drinax campaign in it for easy lookup and reference. I also included all the basic planetary info that you can get off TravellerMap.com along with descriptions of the UWP values, the ability to add personal notes, edit the campaign-related info, and much more.

Here is a rundown of the features:

Current Available Features
  • Comes pre-populated with all the basic planetary data from TravellerMap.com[3] for both the Trojan Reach and Spinward Marches sectors.
  • Also has the relevant data for planets from the Pirates of Drinax[4] campaign by Mongoose Publishing which includes descriptions of the planets, lists of patrons, missions, and rewards, and the planets "attitude" towards the player group.
  • Includes descriptions of each value in the UWP for each planet you look up to make it easy to know what is going on.
  • Includes breakdowns of the Bases, Nobility, and Trade codes into plain English
  • Will render a sub-sector map and Jump 1, 2, and 3 neighborhood maps for the selected planet via integration with TravellerMap.com.
  • Provides the user the ability to edit and save changes to the "System Notes" section for each planet right on the main page.
  • (PoD Specific) Central location to keep track of the groups Standing with the Aslan and Imperium
  • (PoD Specific) Central location to keep track of the attitude that each system has with the group.
Features Locked During Testing
NOTE: These are only locked so that people don't accidently mess somehting up and report a bug to me that I can't fix. This will all by unlocked once it is "released"
  • Edit all the lookup tables that fill in the World Data page
  • Create and add more sectors, custom sectors, and edit all the planetary info
  • Editing of the Subsector background text
  • Including Jump 4 and Jump 5 maps
  • Reformatting to your hearts content
Enhancement Ideas
  • Convert as much of the formulas as possible to VBA code for speed and efficiency
  • Code a routine to parse/format the Raw Sector Data from TravellerMap.com into the format used for the spreadsheet
  • Investigate feasibility/impact of moving back end data from the spreadsheets to a database. I think that unless someone wants to add data for more then 5-6 sectors that there is no real benefit for doing this.
The file is an Excel 2013 spreadsheet with macros and VBA. It should work with Excel 2007 or later (with the exception of some conditional formatting for color coding) but I have no way of testing that. It will NOT work with the web-based version of Excel. Since it is an XLSM file I can't attach it to this post. So here is a link to my Dropbox for everyone to grab it:
--->GET FILE HERE<---

One question I expect immediately it this:
Why is the file "protected" with a password? What are you trying to hide??!!!
The file is currently protected with a password but that is only so people can't make changes to it while it is still in testing. The last thing I need is for someone to accidentally change something then tell me a feature doesn't work and I spend days trying to figure it out. Once it is fully baked the password will be removed. If this is really a big issue for you, contact me directly.
I welcome any constructive criticism, feedback, suggestions, and ideas. You can reach me by replying to this thread here, over on the COTI forums, via reddit, or the email address that is on the intro page of the file. If you just want to scream at me that my choice of colors sucks, please step through that door over there. The one that says "Air Lock" and I will be right with you.....

Thanks!

Pretty good so far!
DaveT
Shrew
Posts: 13
Joined: Mon May 11, 2015 10:52 pm

Re: World Lookup Tool for Pirates of Drinax

Postby DaveT » Thu May 14, 2015 10:37 am

Wow. Only had a brief look over so far but very impressed. Thanks for sharing.
DickNervous
Stoat
Posts: 97
Joined: Sun Feb 15, 2015 5:49 pm
Location: Seaford, NY, Solomani Rim
Contact:

Re: World Lookup Tool for Pirates of Drinax

Postby DickNervous » Thu May 14, 2015 12:32 pm

Thanks folks! I have been making some refinements to it still, though most of them are behind-the-scenes to make it more efficient and easier to update.

Please let me know if there are any features you would like to see added!
----------------------------
Rich 'DickNervous' Neves
Baron of Ishala - VLAN 2113 Ishala C866651-9
Baron of Enaaka - DENE 0203 Enaaka B777786-6
Knight of Deneb - SPIN 1721 ARBA C200200-C
Nervoused.com
peelseel2
Weasel
Posts: 34
Joined: Sat Aug 09, 2008 5:49 pm

Re: World Lookup Tool for Pirates of Drinax

Postby peelseel2 » Sun Feb 24, 2019 4:36 pm

Amy chance of getting a copy of this?
DickNervous
Stoat
Posts: 97
Joined: Sun Feb 15, 2015 5:49 pm
Location: Seaford, NY, Solomani Rim
Contact:

Re: World Lookup Tool for Pirates of Drinax

Postby DickNervous » Tue Feb 26, 2019 5:37 pm

peelseel2 wrote:
Sun Feb 24, 2019 4:36 pm
Amy chance of getting a copy of this?
Sure thing, this link should take you to the file.
----------------------------
Rich 'DickNervous' Neves
Baron of Ishala - VLAN 2113 Ishala C866651-9
Baron of Enaaka - DENE 0203 Enaaka B777786-6
Knight of Deneb - SPIN 1721 ARBA C200200-C
Nervoused.com
peelseel2
Weasel
Posts: 34
Joined: Sat Aug 09, 2008 5:49 pm

Re: World Lookup Tool for Pirates of Drinax

Postby peelseel2 » Wed Feb 27, 2019 1:35 am

I get an error with this link saying xml maps not supported. I have tried it edge, ie, firefox, chrome.
DickNervous
Stoat
Posts: 97
Joined: Sun Feb 15, 2015 5:49 pm
Location: Seaford, NY, Solomani Rim
Contact:

Re: World Lookup Tool for Pirates of Drinax

Postby DickNervous » Sun Mar 03, 2019 8:50 pm

Hmm, it is trying to launch Excel Online, which it won't work in due to macros.
Let's try Google Drive.... https://drive.google.com/open?id=0B4H5M ... m9fWURGQmc

Try that. Just download and run in Excel.
----------------------------
Rich 'DickNervous' Neves
Baron of Ishala - VLAN 2113 Ishala C866651-9
Baron of Enaaka - DENE 0203 Enaaka B777786-6
Knight of Deneb - SPIN 1721 ARBA C200200-C
Nervoused.com
peelseel2
Weasel
Posts: 34
Joined: Sat Aug 09, 2008 5:49 pm

Re: World Lookup Tool for Pirates of Drinax

Postby peelseel2 » Wed Mar 06, 2019 1:59 am

Wow!! That is awesome! Thank you!!

Who is online

Users browsing this forum: Google [Bot], PFarrell, PsiTraveller and 28 guests