Alejandro's Weapon & Gear Planner

Don't know how something works? Here you will find some useful links. And if you have a question, feel free to ask.
Locked
Alex
Legendary Scribe
Posts: 791
Joined: Sun Mar 18, 2012 11:31 pm
Location: Washington, DC

Alejandro's Weapon & Gear Planner

Post by Alex »

Dear Shardies,

Some of you may already be using my older version weapon and gear planner. I am currently working on a greatly revised version of both. I am looking for a few individuals to beta test each of them for errors and possible improvements (probably this weekend). Please [pm Alejandro if you have time in the next 2 weeks to test them out. Greatly appreciate it.

Also, I am looking for an experienced person in Microsoft Excel since these planners are based on excel. I need help and want to exchange ideas on reference and lookup functions especially vlookup functions. Thanks.

Alex
Alex
Legendary Scribe
Posts: 791
Joined: Sun Mar 18, 2012 11:31 pm
Location: Washington, DC

Re: Alejandro's Weapon & Gear Planner

Post by Alex »

Dear all,

please find enclosed the link to download my "WEAPON PLANNER". It runs on Microsoft Excel so make sure you have that in order to use the planner properly (someone said "google drive" may work, but I can't confirm that). Please note that this is the first version, so I would greatly appreciate any comments and suggestions for future releases. [PM Alejandro

Stay tuned for the upcoming gear planner.

https://www.dropbox.com/s/4k07i0poul7xk ... .xlsx?dl=0
timthree
Expert Scribe
Posts: 33
Joined: Mon Mar 29, 2010 3:56 am

Re: Alejandro's Weapon & Gear Planner

Post by timthree »

Opens and works fine in Open Office Calc
Awesome job Alejandro, I can't wait to play with it. Thanks so much!
User avatar
tiggerjlk
Elder Scribe
Posts: 109
Joined: Sun Jan 06, 2013 5:42 pm

Re: Alejandro's Weapon & Gear Planner

Post by tiggerjlk »

Love it! thanks!!!
Soylentgreen
User avatar
Sailor Jerry
Elder Scribe
Posts: 114
Joined: Sun Sep 06, 2015 7:31 pm
Location: WA USA
Contact:

Re: Alejandro's Weapon & Gear Planner

Post by Sailor Jerry »

Nicely done Alex! Looks and works great!
Full throttle, half-bottle, fun lovin, script huggin gamer nerd...
a Napa Valley 1 Percenter
Alex
Legendary Scribe
Posts: 791
Joined: Sun Mar 18, 2012 11:31 pm
Location: Washington, DC

Re: Alejandro's Weapon & Gear Planner

Post by Alex »

Dear all,

Thank you for sending me your comments and suggestions. I will be releasing v1.1 soon with some improvements.
Alex
Legendary Scribe
Posts: 791
Joined: Sun Mar 18, 2012 11:31 pm
Location: Washington, DC

Re: Alejandro's Weapon & Gear Planner

Post by Alex »

Dear all,

please find enclosed the link to download v1.1 of the weapon planner. Thanks to those that sent me their comments and suggestions. v1.1 includes some minor improvements:

- Fix of the dropdown menu to select looted and crafted, now working properly
- Fix on the display of stats on the outpage tab
- Included "total points spent" and "total points available" on the data tab for easier viewing and planning

If you have any further comments or suggestions, please dont forget to [PM Alejandro

https://www.dropbox.com/s/dbhgwk2tht16z ... .xlsx?dl=0
Last edited by Alex on Sun Nov 22, 2015 11:36 am, edited 1 time in total.
User avatar
mojo519
Master Scribe
Posts: 55
Joined: Sun Oct 10, 2010 1:43 am
Location: Sweetwater, TX

Re: Alejandro's Weapon & Gear Planner

Post by mojo519 »

Thanks for making this. It works great!
aka Primal Scream
Locked