| View previous topic :: View next topic |
| Author |
Message |
fathead
Kreetle
Joined: Jan 06, 2008
Posts: 14
|
 Posted: Thu Sep 04, 2008 9:02 pm Post subject: The Complete Ranger/Scout List of SWG Creature Resources |
 |
|
Ready for Download:
http://www.swgrangers.com/modules.php?name=Downloads&d_op=getit&lid=6
The Complete Ranger/Scout List of SWG Creature Resources
A spreadsheet to use to look up what animal you need to hunt for a particular type of resource on each particular planet and other important information about said creature, if they are aggressive, social, ranged or melee attack etc. lots of which are very helpful for the solo unbuffed Ranger (because REAL Rangers hunt unbuffed  )
The Goods
A main "Creature Resource" spreadsheet with embedded hyperlinks to a separate spreadsheet for each planet so you can write down and keep a record of all the creature resources for each creature resource on each planet.
I will be releasing the spreadsheet in 2 forms, 1 will be the Creature Spreadsheet only with no hyperlinks to the external resource list spreadsheets(in both openoffice and excel formats), so it will be a single spreadsheet, for those people that don't want to keep a running record of resources.
The second will be a zip file of the full set of spreadsheets, the Creature Spreadsheet with hyperlinks (openoffice format only) to a spreadsheet for each planet to list resources past and present, with each planets spreadsheet having a page for each resource, so it will be a pack of 12 spreadsheets.
I have done this spreadsheet using openoffice, the single spreadsheet in excel format is a courtesy only, the full spreadsheet pack will not be provided in excel format as all the hyperlinks would need to be redone.
Openoffice is a free download (127MB) and a very good program, I urge you to download and use it, even if you only use it for this spreadsheet.
http://download.openoffice.org/index.html
Pretty much everything is done now, I am just checking and tidying it up before letting it loose!
Updated 05/09/2008
Screenshots
Index page
Price calculation page (this is my own price calc that I had back in the day and only for hide and meat)
Corellia creatures list page with filters (you can filter for meat, meat & hide etc)
The rest of Corellia page
Corellia resource page for entering resources (only really for if you want to keep track of resource trends)
Dantooine creatures page
Last edited by fathead on Tue Aug 18, 2009 4:47 pm; edited 1 time in total |
|
| Back to top |
|
 |
Myerscod
Kreetle
Joined: Sep 05, 2008
Posts: 7
|
| Posted: Fri Sep 05, 2008 7:14 am Post subject: |
|
|
This looks freaking awesome man! Hope you get it on here for download as soon as  |
|
| Back to top |
|
|
YT-2000
Scout
Joined: Jul 25, 2008
Posts: 81
Location: Lancashire, UK
|
| Posted: Fri Sep 05, 2008 7:48 am Post subject: |
|
|
That is simply brilliant  . My Ranger hat off to you!
Also, I started using OpenOffice a few weeks ago and I have to say I prefer it to Microsoft Office (especially since it's free!).
_________________
Hebi Aepam
Retired Hunter / Creature Expert (Eclipse) |
|
| Back to top |
|
|
kefkah
Foramu Otaku
Joined: Jan 05, 2008
Posts: 1034
|
| Posted: Fri Sep 05, 2008 8:47 am Post subject: |
|
|
Arguably one of the greatest tools to our profession and efforts since the inception of ranger.
Hats off to fathead!
_________________
|
|
| Back to top |
|
|
fathead
Kreetle
Joined: Jan 06, 2008
Posts: 14
|
| Posted: Mon Sep 08, 2008 6:30 am Post subject: |
|
|
OK, I added in egg, fish, and crustacean meat to the spreadsheet today and it is all ready to go, I am just waiting for some confirmation of it being hosted then I will post a link to the download!  |
|
| Back to top |
|
|
Bilos
Scout
Joined: Apr 30, 2008
Posts: 63
|
| Posted: Mon Sep 08, 2008 9:10 am Post subject: |
|
|
*Tosses fathead a bottle of whiskey*
Excellent find! |
|
| Back to top |
|
|
kefkah
Foramu Otaku
Joined: Jan 05, 2008
Posts: 1034
|
| Posted: Mon Sep 08, 2008 7:24 pm Post subject: |
|
|
Link added!
_________________
|
|
| Back to top |
|
|
fathead
Kreetle
Joined: Jan 06, 2008
Posts: 14
|
| Posted: Tue Sep 09, 2008 6:36 am Post subject: |
|
|
Here is a new addition to the spreadsheet (posted on TG)
| Quote: | And just when you thought it couldn't get any better.......
I am now in the process of adding in tabulation pages on each planets resource list spreadsheet that will tabulate the newest entered resource for each resource type and present it in such a manner that you can cut and paste it into the TGCraft resource entry box to enter multiple resources at once!
Here we have in column J the conversion of the resource into a space delimited format
If there is no number in the first resource stat column then column J returns a zero (which is hidden by default)
And on the new TGCraft tabulation page we have the last entry for each resource listed for easy cut and pasting
Be aware though that in the resource list spreadsheet it picks the first row with a zero in the fisrt stat column so if you delete resources before the last entry it will break the way it picks the latest resource and lists it on the tabulation page |
|
|
| Back to top |
|
|
fathead
Kreetle
Joined: Jan 06, 2008
Posts: 14
|
| Posted: Tue Aug 18, 2009 4:48 pm Post subject: |
|
|
Updated image links to ones that work in OP
_________________
Former Valcyn server Master Ranger |
|
| Back to top |
|
|
|
Private Messages
