Architect Archive

Thread: NEW Lot Management Spreadsheet!

Shadow-Light
Mon Nov 03, 2003 9:00 am
#53

Just want to thank everyone for the wonderful feedback I've received. I'm already working on v2.1 to help improve on some of the issues that I've heard about. Check out swg.medievalweapons.net for future updates. Once v2.1 is released, I'll post about it here.


I'm amazed at how many of you took the time to download this spreadsheet, so I thought I'd let you see the numbers:



  • 10 lots - 1168

  • 25 lots - 239

  • 50 lots - 124

  • 100 lots - 125

  • Total - 1656

Those numbers are from Oct 30th until about 4am on Nov 3rd! Thanks again all!





Need a great lot management tool? v2.1 is at http://swg.medievalweapons.net
Shadow-Light
Mon Nov 03, 2003 9:01 am
#54

Just want to thank everyone here for the wonderful feedback I've received. I'm already working on v2.1 to help improve on some of the issues that I've heard about. Check out swg.medievalweapons.net for future updates. Once v2.1 is released, I'll post about it here.


I'm amazed at how many of you took the time to download this spreadsheet, so I thought I'd let you see the numbers:



  • 10 lots - 1168

  • 25 lots - 239

  • 50 lots - 124

  • 100 lots - 125

  • Total - 1656

Those numbers are from Oct 30th until about 4am on Nov 3rd! Thanks again all!





Need a great lot management tool? v2.1 is at http://swg.medievalweapons.net
MrThallid
Mon Nov 03, 2003 9:40 am
#55

/cheer







. : | MrThallid ~ Colonel of the Rebel Alliance ~ {HoM} | : .
. : | Bounty Hunter | : .
. : | Azan Okrattea ~ Medic ~ Elder Jedi | : .
. : | . ! | : .
Xader_Vartec
Mon Nov 03, 2003 10:29 am
#56

I got one for you...although it's complex enough to be for version 3 (or 5 or 10):


Add the ability to select a schematic and show how long before you have the resources








Beta Tester : Master Architect : Master Artisan : Master Medic : Master Marksman



Xader_Vartec
Mon Nov 03, 2003 10:45 am
#57

HOLY CRAP!!!


I just got done looking over this and it is really nice!







Beta Tester : Master Architect : Master Artisan : Master Medic : Master Marksman



Dayln
Mon Nov 03, 2003 10:53 am
#58

While you are at it, it would also be nice ( but a whole lot of work ) to show the total extraction of each specific material we are extracting.


I know, I am asking for a lot.

Shadow-Light
Mon Nov 03, 2003 11:07 am
#59

On the Eff IV issue, that fix is coming in v2.1




Need a great lot management tool? v2.1 is at http://swg.medievalweapons.net
Jaron
Mon Nov 03, 2003 2:59 pm
#60

Why the hell would someone give this a 1 rating? This is an absolutely marvelous program to have.
Rolassk
Fri Nov 07, 2003 5:54 pm
#61

Great job on the ease of use, and the lack of clutter given the formula lengths and multiple sheet ranges that are needed. Believe me I know what it's like, I created a harvesting spreadsheet similar to this, but it's a lot more hectic to enter the data.


However, I have a suggestion for v2.1
Remove




GalacTech Drive Systems & Resources
Starships, Components, Ordinance & Resources at 460 -5340, Coronet, Corellia
Blayr Charker *Master Shipwright *Galactic Miner *Retired MD *Kettemoor


All warfare is based on deception -Sun Tzu
Rolassk
Fri Nov 07, 2003 6:06 pm
#62

Arggh stupid forums, WHEN CAN WE GET AN EDIT BUTTON like all the other forums have,since way back in 1995? Anyways


Great job on the ease of use, and the lack of clutter given the formula lengths and multiple sheet ranges that are needed. Believe me I know what it's like, I created a harvesting spreadsheet similar to this, but it's a lot more hectic to enter the data.


However, I have a suggestion for v2.1
Remove the 1/7th redeed cost from the final Cost per Unit and Cost per Unit w/Energy calculations. I would think very few playersredeed there harvesters every 7 days. I know myself I have never redeeded exactly 7 days after placing a harvester. The reason for my suggestion? I try to sell enough resources to break even. Therefore, if I have a harvester on X resource for 11 days, you can imagine how much it unbalances the break even cost if I use medium or heavy harvesters.
If a player wants to figure out how much Cost per Unit a resource is costing them with redeed costs added they can still enter it in the 'Other Cost' Column. Just put a little note on the 'instruction sheet' to remind them to divide the redeed cost by the amount of days the harvester was on X resource, if they want to add this to the other costs.




GalacTech Drive Systems & Resources
Starships, Components, Ordinance & Resources at 460 -5340, Coronet, Corellia
Blayr Charker *Master Shipwright *Galactic Miner *Retired MD *Kettemoor


All warfare is based on deception -Sun Tzu
Raduk
Mon Nov 24, 2003 8:47 am
#63

Hey any updates on this??


I have a small app I wrote for my pda using this...but I like this spreadsheet also...


Crapgame
Tue Nov 25, 2003 7:55 am
#64

I just go this today mostly to handle my civic buildings as a mayor.

Unfortunately, I can't add a tax rate to the calculations so my time is off.

I'd love to see that included in a new version!!

Thanks!



-CeeGee, Imperial Governor of Port Valorum
3300, 2250 Naboo, 1400m from Keren

http://www.ghostsoldiers.org
http://www.swgcenter.com/
Draznar
Tue Nov 25, 2003 7:57 am
#65

Actually you can change the maint to include the tax rate.


Feature I want. Vendor Maint.




~ ECLIPSE Power k DRAZNAR'S Resources ~
______________________________________________________________________________
Powering the Eclipse Galaxy at 1.5 credits per unit of harvester power from 6 Locations!
u Isle of Misfits, Dantooine 3529, 5761 u Xanadu Bay, Naboo -70, 5222 u Coronet, Corellia 172, -5444 u
u Bestine, Tatooine -970, -4350 u In Caliga, Rori -2710, -2460 u TBA, Lok xxxx, xxxx u
Resources available from Eclipse Resource Corporation at the Isle of Misfits & Cornet Branches

Page 5 of 6