Architect Archive

That clears up the Fusion issue, thanks. Why is it that I keep pointing out crap that isn't broken

Message Edited by gjhancock on 06-12-2004 10:55 PM

---

gjhancock wrote:

That clears up the Fusion issue, thanks. Why is it that I keep pointing out crap that isn't broken

The MM issue is not related to the Fusions though... this is on the Crafting & Factories page. Input a total for the MM in B17 and it spits out the total resources including those needed for a Gen Turbine, but in the component list below and to the right(N52 and Q17), no Turbine is listed.

Message Edited by gjhancock on 06-12-2004 10:55 PM

---

Ahsee now that is a problem The fix has been implemented and uploaded. Thanks GJ.

Message Edited by CandaVespin on 06-14-2004 09:18 AM

---

CandaVespin wrote:

Furniture House and Civic Tab - Anything that uses Structural Modules.

Your formula says (In this case for a small house, planet specific):

=IF($B$3="Y",IF($B$10=0,"",($B$10+1)*10),$B$10*10)

In order to have this accurately reflect your "+1 for schematic" if it is checked, it should read

=IF($B$3="Y",IF($B$10=0,"",($B$10*10)+1),$B$10*10)

The way it currently is you are adding one (making the count 2) then multiplying by 10. This makes the quantity necessary 20, instead of 11.

Also, if you're up to it, would it be possible to provide another column with individual item prices? I would like to use this to create myself a price list to go by when stocking furniture, but I do not want to have to go through and change my item quantities each time. If you're not up to it I can go ahead and do it. Perhaps we can collaborate and figure something out.

Message Edited by CandaVespin on 06-14-2004 09:18 AM

---

Wow that's a big error Thanks I'm fixing it now. There's a page called Price List that allows you to enter a cpu cost and it kicks back the costs of all the items.

---

VelRahn wrote:

---

CandaVespin wrote:

Furniture House and Civic Tab - Anything that uses Structural Modules.

Your formula says (In this case for a small house, planet specific):

=IF($B$3="Y",IF($B$10=0,"",($B$10+1)*10),$B$10*10)

In order to have this accurately reflect your "+1 for schematic" if it is checked, it should read

=IF($B$3="Y",IF($B$10=0,"",($B$10*10)+1),$B$10*10)

The way it currently is you are adding one (making the count 2) then multiplying by 10. This makes the quantity necessary 20, instead of 11.

Also, if you're up to it, would it be possible to provide another column with individual item prices? I would like to use this to create myself a price list to go by when stocking furniture, but I do not want to have to go through and change my item quantities each time. If you're not up to it I can go ahead and do it. Perhaps we can collaborate and figure something out.

Message Edited by CandaVespin on 06-14-2004 09:18 AM

---

Wow that's a big error Thanks I'm fixing it now. There's a page called Price List that allows you to enter a cpu cost and it kicks back the costs of all the items.

---

---

VelRahn wrote:

---

VelRahn wrote:

---

CandaVespin wrote:

Furniture House and Civic Tab - Anything that uses Structural Modules.

Your formula says (In this case for a small house, planet specific):

=IF($B$3="Y",IF($B$10=0,"",($B$10+1)*10),$B$10*10)

In order to have this accurately reflect your "+1 for schematic" if it is checked, it should read

=IF($B$3="Y",IF($B$10=0,"",($B$10*10)+1),$B$10*10)

The way it currently is you are adding one (making the count 2) then multiplying by 10. This makes the quantity necessary 20, instead of 11.

Also, if you're up to it, would it be possible to provide another column with individual item prices? I would like to use this to create myself a price list to go by when stocking furniture, but I do not want to have to go through and change my item quantities each time. If you're not up to it I can go ahead and do it. Perhaps we can collaborate and figure something out.

Message Edited by CandaVespin on 06-14-2004 09:18 AM

---

Wow that's a big error Thanks I'm fixing it now. There's a page called Price List that allows you to enter a cpu cost and it kicks back the costs of all the items.

---

Ok fixed. Version 2.4 is ready for download.

Version 2.4

---

So I'm sitting here thinking about this, and this can't be right. Using your example, a small, planet-specific house requires 10 Structural Modules. If you want to make a schematic to make 1 small house, you'd need 10 Structural Modules to make the schematic, and another 10 to make the item in the factory. So it should be 20 and not 11.

I'm in process of finding an old copy in my Recycle Bin, and I'll upload the old copy. So this will go back to v. 2.3.

Message Edited by VelRahn on 06-15-2004 03:37 PM

Ok I found an old copy that I'm uploading to my d/l server. If you downloaded 2.4 throw it out and get this one. Sorry about the confusion everyone

Message Edited by VelRahn on 06-15-2004 04:01 PM

---

irasha wrote:

Not sure if this has come up yet or if I'm out of my mind, but here goes.

On the Furniture, Housing & Civic tab. If you are to put in 1 Hospital, it does not list the Energy Distributors or Power Distributors that are needed to make the Power Cores, which are listed. As I'm looking at the new one, it doesn't even have a row for the Energy Distributors or Power Distributors.

---

Thanks Irasha!

The updated v 2.3 has this error fixed and is on my d/l server as of now

---

VelRahn wrote:

Thanks Irasha!

The updated v 2.3 has this error fixed and is on my d/l server as of now

fixed 2.3

---

Thank you! This Excel sheet is freakin' awesome! If I see anything more I'll be sure to post it. I'll be using it later tonight.