Architect Archive
Thread: Architect Calculator
There's also some interesting new features included. Download it, check it out, and let me know if you find any mistakes.Version 2.3
Message Edited by VelRahn on 06-08-2004 04:36 PM
I ran virus scan and it came out clean.
The formulas for the harvesters don't seem to work out. I put in 1 for Automated flora farm and it comes out with total quantity of resources = 750 and item cost of 2250. The components list section appears to be blank. I do have macros enabled.
The housing and furniture sheet seems to be working fine though.
Pawlin wrote:
I ran virus scan and it came out clean.
The formulas for the harvesters don't seem to work out. I put in 1 for Automated flora farm and it comes out with total quantity of resources = 750 and item cost of 2250. The components list section appears to be blank. I do have macros enabled.
The housing and furniture sheet seems to be working fine though.
Thanks Pawlin I'll check it out right now.
VelRahn wrote:
Pawlin wrote:
I ran virus scan and it came out clean.
The formulas for the harvesters don't seem to work out. I put in 1 for Automated flora farm and it comes out with total quantity of resources = 750 and item cost of 2250. The components list section appears to be blank. I do have macros enabled.
The housing and furniture sheet seems to be working fine though.
Thanks Pawlin I'll check it out right now.
Yep, I downloaded again and it is indeed fixed.
Its a nice sheet.
Does anyone have a sheet that will spit put a complete price list if a cpu # is entered? That would be a good addition to this.
VelRahn wrote:
..... Areyou wanting a sheet where you just enter the cpu you want to charge and it will tell you the price for every item all at once? I'll see what I can do. Shouldn't be too hard to implement.
Yes thats what I was thinking.
Something that people could take and thwo in a base cpu + % profit margin and then have it spit out an entire price list that they could print out and use as their base prices. I think a lot of us have done something like this, more or less but probably not anything flexible.
Just a couple of quick observations after a preliminary runthrough:
a) the line freezing is positioned wrongly, scroll down hides the reset button, only a minor thing and easily fixed to drop the freeze by one line (this is on both pages)
b) the 'include schematics' button does not seem to work, i.e. no change to resource requirements etc when toggled between 'y' and 'n'.
But it is looking good, much better than what I had, I think mine was too complex as I had tried to include a sheet with all the different resources used and individual prices for each of these, that got far too big when you had the possibility of 4 different types of metals of differing qualities (eg HQ_steel_1, HQ_steel_2, HQ_Metal, LQ_Metal_1, LQ_Metal_2)all priced according to how much you 'paid' for them.
Pawlin wrote:
Yep, I downloaded again and it is indeed fixed.
Its a nice sheet.
Does anyone have a sheet that will spit put a complete price list if a cpu # is entered? That would be a good addition to this.
Bandola wrote:
Just a couple of quick observations after a preliminary runthrough:
a) the line freezing is positioned wrongly, scroll down hides the reset button, only a minor thing and easily fixed to drop the freeze by one line (this is on both pages)
b) the 'include schematics' button does not seem to work, i.e. no change to resource requirements etc when toggled between 'y' and 'n'.
But it is looking good, much better than what I had, I think mine was too complex as I had tried to include a sheet with all the different resources used and individual prices for each of these, that got far too big when you had the possibility of 4 different types of metals of differing qualities (eg HQ_steel_1, HQ_steel_2, HQ_Metal, LQ_Metal_1, LQ_Metal_2)all priced according to how much you 'paid' for them.
). It's corrected.
VelRahn wrote:
Bandola wrote:
Just a couple of quick observations after a preliminary runthrough:
a) the line freezing is positioned wrongly, scroll down hides the reset button, only a minor thing and easily fixed to drop the freeze by one line (this is on both pages)
b) the 'include schematics' button does not seem to work, i.e. no change to resource requirements etc when toggled between 'y' and 'n'.
But it is looking good, much better than what I had, I think mine was too complex as I had tried to include a sheet with all the different resources used and individual prices for each of these, that got far too big when you had the possibility of 4 different types of metals of differing qualities (eg HQ_steel_1, HQ_steel_2, HQ_Metal, LQ_Metal_1, LQ_Metal_2)all priced according to how much you 'paid' for them.
A new version is up to correct some of the problems that I found, as well as including a Pricing Sheet (thanks for the idea Pawlin
a) Yeah I noticed that last nite
b) hmmmm. Hadn't noticed this. Lemme look at it now, thanks for the catch. v. 1.3? Hope not
OK my copy is working as I intended I think what you're thinking about is that it should increase everything by 1 if you set to Y. This line is set up so that it only increases the required number of subcomponents by 1 if the schematic requires identical subcomponents.
So if you make 1 Automated Flora Farm, the Y and N values give the same resource amounts and cost, since none of the items need to be "identical" (ie: no need for factory runs).
If you make 1 High Capacity Flora Farm, the Y and N values DO give different results, because for the HCFF you need 2 IDENTICAL Heavy Harvesting Mechanisms. Putting in the Y effectively charges your customer for 1 more HHM since you MUST make IDENTICAL items in a factory.
Hope this clears things up. If you think this is a bit cumbersome, or you'd rather see it written a different way, please shoot me an email (address is on the instruction sheet) or post here