New Hood Planner with Chinese Pagoda

[itzkakarot]

Hi All,

My hood planner has been updated to include the new Chinese Pagoda building. This is a type A building that is well worth the cost even if you're not participating in the Pagoda Pandamonium event.

Thanks to dart and Beardy for the building data.

http://goo.gl/W5mKh

Enjoy!

-itz

[Bala82]

Thank you but someone told me this TYPE B building?

Level 2 pays out twice what Level 1 does. Type A should pay out three times as much for Level 2.

[bald zeemer]

Yup. IPH glitch has caused some confusion.

[Lonestoner]

Thanks for the update itz, much appreciated!

[MediumRawr]

itz,

Just a quick look at this, I noticed your build cost is showing 1.5 mil, add a 0 to the end

~MR

[zwiswoo]

Hi All,

My hood planner has been updated to include the new Chinese Pagoda building. This is a type A building that is well worth the cost even if you're not participating in the Pagoda Pandamonium event.

Thanks to dart and Beardy for the building data.

http://goo.gl/W5mKh

Enjoy!

-itz

Thanks Itz. I'm a big fan of your spreadsheet and use it a lot. My local copy has modifications and new columns, so I'm wondering if there's a good way of "importing" just the new material - like copy such and such rows in some sheet etc. I am not entirely clear where the times/costs for a new building come from, or if you're putting them in by hand. It'd be nice to not need to move to a new document, especially if there is going to be one of these every month.

[jeffrey25]

tHanks for the update....

[Justsimply]

Thanks for the update, wicked job!

[Lonestoner]

Thanks Itz. I'm a big fan of your spreadsheet and use it a lot. My local copy has modifications and new columns, so I'm wondering if there's a good way of "importing" just the new material - like copy such and such rows in some sheet etc. I am not entirely clear where the times/costs for a new building come from, or if you're putting them in by hand. It'd be nice to not need to move to a new document, especially if there is going to be one of these every month.

Under the readme tab of the hood planner, there are instructions on how to update with minimal effort from an older version.

Although, I don't think there are instructions in there for copying additional rows over, so you may still need details on that.

[itzkakarot]

Thank you but someone told me this TYPE B building?

Yup. IPH glitch has caused some confusion.

Hmm, so the table in Dart's thread must be off. My 1st Pagoda will be built tonight and I'll confirm the cost for Lvl 2 and update the sheet accordingly. BigMoney is correct that Type A lvl 2 is 3x the base income of Lvl 1.

itz,

Just a quick look at this, I noticed your build cost is showing 1.5 mil, add a 0 to the end

~MR

Thanks MR, I've fixed it.

Thanks Itz. I'm a big fan of your spreadsheet and use it a lot. My local copy has modifications and new columns, so I'm wondering if there's a good way of "importing" just the new material - like copy such and such rows in some sheet etc. I am not entirely clear where the times/costs for a new building come from, or if you're putting them in by hand. It'd be nice to not need to move to a new document, especially if there is going to be one of these every month.

Fairly easy since we're just adding one building:

1. Money Buildings tab - Copy/Paste the 10 rows for the Chinese Pagoda
2. My Hood tab - Insert the Chinese Pagoda into the building list on the right side
3. My Hood tab - Check the Data Validation of the cells in A10:AXX and ensure the Criteria field is set to 'My Hood'!I24:I103
4. Planning tab - Repeat Step 3 for Building column

[LongFingers]

Thanks ITZ !

[TRAZ]

I can tell you right now payout is NOT 18 mil.

Level 10 payout with a 35% bonus = 9,900,002 every 24 hours

10_pagoda.jpg

[MediumRawr]

Traz to the rescue, Bearer of BAD NEWS, and dispelling of Myths.

~MR

[D3V]

I can tell you right now payout is NOT 18 mil.

10_pagoda.jpg

So would that make it a type b building???

Or did they use a whole different algorithm here?

[zwiswoo]

Fairly easy since we're just adding one building:

1. Money Buildings tab - Copy/Paste the 10 rows for the Chinese Pagoda
2. My Hood tab - Insert the Chinese Pagoda into the building list on the right side
3. My Hood tab - Check the Data Validation of the cells in A10:AXX and ensure the Criteria field is set to 'My Hood'!I24:I103
4. Planning tab - Repeat Step 3 for Building column

Awesome. Many thanks.