Hi everyone! I'm submitting an Architect Calculator, based off of one I found on SWGCraft.com's forums.  The original was made by Eilla and Holti Kalvascian.  This new file has all the Architect-craftable items in it through Publish 8, including furniture   There's also some interesting new features included. Download it, check it out, and let me know if you find any mistakes.

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.

---

---

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.

---

Ok I got it working.  I somehow managed to delete the formulas that should have been in Column B for the subcomponents 

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.

---

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.

---

Hmmm.  My sheet will allow you to change the cpu cost at the top.  Are you 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. 

---

VelRahn wrote:

.....  Are you 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.

---

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    It's corrected.

b) hmmmm.  Hadn't noticed this.  Lemme look at it now, thanks for the catch.  v. 1.3?  Hope not 

---

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    It's corrected.

 

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 

/free bump

I haven't downloaded your sheet yet so don't know if this is there, but in the Origional version, I extended the capability to include a shopping list based on the quantities you have to make. i.e. This will produce a complete list of resources needed (and quantities) for what ever you enter a quantity in.  Very useful for planning out factory runs of harvesters and furniture.

I'll look yours over and see if you need this, if so I'll send you the script used to create the list (it uses a VB macro)

this is uber

thx!