Architect Archive
Thread: NEW Lot Management Spreadsheet!
Hey I love this spreadsheet. I have one question. How are you calculating the Capacity % on the first page. You don't ask for hopper size until second page? Seems straight forward, just asking.
Great spreadsheet! Nice work.
If you want an idea to add to it, you could add inventory management too. I store resources around and it would be nice to have a page that shows my current inventory and then the expected inventory in a day/2days/week and so forth. Then you could calculate how much you can sell based on your expected inventory and how much you want to keep on hand.
I may tinker around with that as well. Let you all know if I get something working.
I just get it and it seems to be very usefull. Unfortunatly, i'm french and i tried to translate it or to modify script in order to have french date (dd//mm/yyyy) and a prompt for a password appeared 
If u want, i can send you french text. Tell me ...
Well, there isn't really an order to the pages since all of the pages are inter-related. If you fill out Maintenance page first the Capacity % will be based off the default hopper size. If you change the HopperCapacity on the Lot Info page, everything is recalculated at that time. The real trick is that if Hopper Capacity is left blank, I just use the default values. Hope that helps.
Bajor_Dit wrote:
Hey I love this spreadsheet. I have one question. How are you calculating the Capacity % on the first page. You don't ask for hopper size until second page? Seems straight forward, just asking.
Zeh wrote:
Indeed, a very good tool to manage your structures. The time to return a visit feature is great and helps a lot people who forget all the thing like me.
One sugestion is give a bit more space to enter the description or leavea field to enter planet and coordinates of the structure, just for our check.
Keep up the good work!!
The description field is unlimited in size, just drag the column out to be bigger. I'll look at adding planet and coordinates fields in v2.1. Thanks for the suggestion
awesome sheet...one thing I seem to be missing (maybe Im just looking in the wrong place?) - A place to put the coords of the harvs? I find it can be difficult to keep up with all locations since I use lots from other people. Also with the datapad bugging out so much Ive lost my harv wps before.
There should not be any passwords in my spreadsheet. If Excel is asking for a password, try a blank/empty one. Are you trying to modify the Date Stamp and Time Stamp scripts? I tried to make them as generic as possible so they would use the local time/date format.
Anobih wrote:
I just get it and it seems to be very usefull. Unfortunatly, i'm french and i tried to translate it or to modify script in order to have french date (dd//mm/yyyy) and a prompt for a password appeared
If u want, i can send you french text. Tell me ...
Nikii_Nightstrider wrote:
awesome sheet...one thing I seem to be missing (maybe Im just looking in the wrong place?) - A place to put the coords of the harvs? I find it can be difficult to keep up with all locations since I use lots from other people. Also with the datapad bugging out so much Ive lost my harv wps before.
The current solution is to add it to the description field and drag the description field out to be larger for now. The description field is more or less unlimited in size. I'm looking into adding planet and coord fields for v2.1.