Architect Archive
Thread: NEW Lot Management Spreadsheet!
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!
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!
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
HOLY CRAP!!!
I just got done looking over this and it is really nice!
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.
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
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.
Hey any updates on this??
I have a small app I wrote for my pda using this...but I like this spreadsheet also...
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!
Actually you can change the maint to include the tax rate.
Feature I want. Vendor Maint.