PDA

View Full Version : All LTB Sheet up!!!



BrisingrBoss
12-19-2014, 03:01 PM
All the LTBs already included in this one.

https://docs.google.com/spreadsheets/d/1NABccJYLgeqyMlHJ6yUyO0GCCvS6YBnuiW61BczRvtc/edit#gid=0


Prices have changed , and it seems upgrades for buildings we already had, have also been changed. it also seems we can buy another 2 of the LTB's that we already had!!! will try to get the other buildings asap, as they are available to purchase now for gold!!!!

Theater of War added to the sheet.

Bubseg
12-19-2014, 04:28 PM
Is it just me but its only showing the current ltb

BrisingrBoss
12-19-2014, 04:31 PM
there is a dropdown when you click the Building name

Kefa
12-19-2014, 04:57 PM
almost all the LTBs already included in this one, the new Black Sea Tower is here already.



https://docs.google.com/spreadsheets/d/1NABccJYLgeqyMlHJ6yUyO0GCCvS6YBnuiW61BczRvtc/edit#gid=0


will try to get the other buildings asap, as they are available to purchase now for gold!!!!

Fantastic! Thank you

rainman875
12-19-2014, 05:48 PM
Absolutely fantastic work...awesome

BrisingrBoss
12-19-2014, 06:47 PM
just putting the last few buildings in... GREE HAS CHANGED THE PRICES ON BUILDINGS!!!!!!

buildings you already had now may cost 2-3 times more to upgrade, or 1/10th of the price

Blood Fortress, for example, Cost me 9.5 million to buy, now to upgrade to level 2 is only costing 261k
Amstel Hotel Got originally released fro 55 million. now it costs 110 million to build, and im assuming upgrades will follow, since Blood fortress got changed on the building i had, im assuming all upgrades will follow that purchase price and got changed on the buildings I had as well

bam bam.
12-19-2014, 07:58 PM
I wonder the total cost to buy all gold buildings including the 120 gold need for the extra days to buy 4 of each LE building in the time allocated. Then the cost counting all cash buildings.

Also cost vs iph comparison would be cool. Any awesomely nerdy statisticians out there who can weigh in?

Jetwit
12-19-2014, 08:28 PM
thank you for all the work.

I was looking at the Anniversary Center and noticed the base price of level 1 is set at 20M but in the game it is level 1 base price is only 2M

Kefa
12-19-2014, 08:35 PM
I wonder the total cost to buy all gold buildings including the 120 gold need for the extra days to buy 4 of each LE building in the time allocated. Then the cost counting all cash buildings.

Also cost vs iph comparison would be cool. Any awesomely nerdy statisticians out there who can weigh in?

11,400

6,120 for all 68 gold LE buildings, and 5,280 for the 44 days worth of speed up ;)

bam bam.
12-19-2014, 08:42 PM
11,400

6,120 for all 68 gold LE buildings, and 5,280 for the 44 days worth of speed up ;)

Thanks nerd :)

BrisingrBoss
12-19-2014, 08:50 PM
thank you for all the work.

I was looking at the Anniversary Center and noticed the base price of level 1 is set at 20M but in the game it is level 1 base price is only 2M

my bad.. i see what you mean.. the base output was supposed to be 2 million, not 20 million. fixed!!!
the base price i got from previous incarnation of it, not sure what it will be, really since it is gold

Kefa
12-19-2014, 09:13 PM
So, if the new old buildings cost more to level up, does that mean the old ones sitting on our bases that haven't yet been fully leveled will now cost more to level up? I guess it must.

alexto
12-20-2014, 09:46 AM
Thanks, man!

BrisingrBoss
12-20-2014, 05:38 PM
Added Prize for completing Black sea to level 10. also updated sheet to make buildings list Alphabetical

BrisingrBoss
12-20-2014, 07:09 PM
Completing level 2 also gives a Tower Key!!!

RAMNUTS
12-20-2014, 10:10 PM
All the LTBs already included in this one, the new Black Sea Tower is here already.



https://docs.google.com/spreadsheets/d/1NABccJYLgeqyMlHJ6yUyO0GCCvS6YBnuiW61BczRvtc/edit#gid=0


Prices have changed , and it seems upgrades for buildings we already had, have also been changed. it also seems we can buy another 2 of the LTB's that we already had!!! will try to get the other buildings asap, as they are available to purchase now for gold!!!!

You are the man! This rocks!

RAMNUTS
12-20-2014, 10:21 PM
Don't knoow if this matters as I am not very verse with these docs but i can't seem to find the other buildings. Do I need to download it first? Btw- I use a nook if that makes a difference. Thx

BrisingrBoss
12-20-2014, 11:12 PM
it does make a difference, try a different browser. usually all you need to do is click on the building name and choose from dropdown. but ive been told people cant seem to be able to do that from mobile

Sharky259
12-21-2014, 11:38 PM
I keep getting an error when I try to open the file after downloading it as an Excel spreadsheet. There seems to be a problem with the data validation and the drop down menu doesn't work.

Cuombajj
12-22-2014, 12:12 AM
What does the bonus "+5% building upgrade" mean? Upgrade time, cost or output?

HypeTonic
12-22-2014, 12:19 AM
I cant get the drop down to work... It was working the first day you posted it

Pidgeot
12-22-2014, 12:45 AM
What does the bonus "+5% building upgrade" mean? Upgrade time, cost or output?

I believe its building output.

Kope
12-22-2014, 05:49 AM
I cant get the drop down to work... It was working the first day you posted it

No luck here either.

-Commando-
12-22-2014, 09:50 AM
I cant get the drop down to work... It was working the first day you posted it

I thought it was just me. I'm using chrome on my desktop and google docs, but the drop down doesn't work.
I've got about 420 gold. What's the best buildings to invest in for output?

Pidgeot
12-22-2014, 11:47 AM
I thought it was just me. I'm using chrome on my desktop and google docs, but the drop down doesn't work.
I've got about 420 gold. What's the best buildings to invest in for output?

I would start with the AC or AMR, then go with the other 24 hour buildings.

DeathByStorm
12-22-2014, 02:56 PM
Thanks for doing this! Much appreciated!

I am also having a problem getting the drop-down to work (after saving it as an Excel file).

And the prize for upgrading the Black Sea Tower to level 4 is a Black Sea Eagle (a) unit, with 17705 att / 14485 def.

Does anyone know what level gives you the 3rd Tower Key, (for the temp +1 building upgrade bonus)?

Sharky259
12-22-2014, 03:54 PM
It has started the same as Gree HQ with token items at level 1 & 2 so I think the 3rd Tower Key will probably be on level 6.

Namshilah
12-23-2014, 11:47 PM
would be great if you could fix the drop down menu so that we can look at more than just the Hidden Gem.
someone seems to have tweaked the A2 cell
thanks

BrisingrBoss
12-24-2014, 03:57 AM
fixed


reason it stops working is people start messing around with it. google wont allow me to completely protect it from that. either it is completely read only in which case you guys cant change your info there, or it isn't and you guys can mess with it enough to break it

HA3
12-27-2014, 05:25 AM
Lvl 5 gives the 3rd key.

MoM - Krypt
01-02-2015, 08:24 AM
The price inflation as far as cash purchase and upgrade is most likely due to the recycle glitch which caused many players to generate 100's of billions in just a couple hours before Gree could create and push the fix. Basically trying to level the playing field by getting these people to spend billions to upgrade these buildings at the top levels. As for the gold buildings that's just Gree trying to make more money. To be honest I hate giving my money to Gree(dy) but this is one circumstance I don't really mind.

Highland Cam
01-03-2015, 03:19 PM
The upgrade costs are unchanged from original release (based on comparison to earlier data), however the initial purchase price has been changed.

Cat09
01-04-2015, 09:46 AM
thanks for the info!

sborgnanera
01-08-2015, 04:35 AM
This event (all old buildings are available) is permanent or it will finish very soon ?
At what day and time will it finished ?

smart tiger
01-08-2015, 05:14 AM
This event (all old buildings are available) is permanent or it will finish very soon ?
At what day and time will it finished ?

Jan 13th is the last day of sale for these buildings..

sborgnanera
01-08-2015, 08:10 AM
Thx ! And do you know at what time (PST, GMT...) exactly ?

smart tiger
01-08-2015, 11:56 AM
Not sure about that.. They didn't seem to mention. However you can check this thread:
http://forums.gree.net/showthread.php?103261-Limited-Buildings-Back-For-a-Limited-Time!&highlight=buildings+back+limited+time

BrisingrBoss
01-13-2015, 03:19 PM
island POW Camp added to the sheet. Please don't Mess around with it!!! People keep creating blank sheets in there!!!

GI Janers
01-13-2015, 04:04 PM
Thanks for everything!

Chimera
01-13-2015, 04:59 PM
http://i1069.photobucket.com/albums/u476/Chimera-gene/BlackSeaTower.jpg

CC1
01-13-2015, 05:35 PM
Thanks Brisngrboss. I noticed the spreadsheet has the collect time at 18hrs but the store shows it as 4hrs

BrisingrBoss
01-13-2015, 05:39 PM
oops. I'll fix it. i was updating the sheet on my iPad as i hadn't left work yet.

BrisingrBoss
01-13-2015, 05:51 PM
http://i1069.photobucket.com/albums/u476/Chimera-gene/BlackSeaTower.jpg

Thanks for that info. last LTB i was concentrated on buying all of the LTBs i missed.

BrisingrBoss
01-13-2015, 05:57 PM
http://i1069.photobucket.com/albums/u476/Chimera-gene/BlackSeaTower.jpg

did gree by any chance change the upgrade times on LTB's? i noticed you put first upgrade at 24 hours instead of 30

BrisingrBoss
01-13-2015, 06:08 PM
Arctic Mining rig, Anniversary Center and Alexandria villa have a non standard Upgrade time. its shorter!!!! im updating info on sheets. if anyone knows of another buildings with non standard time let me know so i can update

Chimera
01-13-2015, 08:54 PM
did gree by any chance change the upgrade times on LTB's?
For the Black Sea Tower, they changed the upgrade time on several levels so the total time was only 456 hrs. (not 510 hrs.).
The cost and output percentage increases also changed.
So the next LTB? We'll see.

BrisingrBoss
01-14-2015, 09:14 AM
I milked the LTB Palooza all i could so I'm starting this a day late. il still finish it, but im only now starting to build level one. I catch up quick though.

BrisingrBoss
01-15-2015, 12:07 PM
Updates the sheet, now it has pix of each building. also changed the whole coding as to protect it.

Chimera
01-16-2015, 09:56 PM
I milked the LTB Palooza all i could...

Without calculating the LTB Palooza…

Most LTBs take 21.25 days to complete and are usually released 20 days before the ending date.
This means 1.25 days need to be removed with the purchase of 150 gold (one hour of upgrade costs 5 gold).
At a minimum, every player who begins upgrading the new LTB on the 1st day and hour and completes it without any delay (excluding bonuses & discounts) yields a profit of $15. Every hour of delay increases profit 50˘.

I do not remember an LTB thread ever being closed or redirected and multiple threads have always been allowed. Views of LTB threads number into the 1,000s.
Do Gree employees do the LTB Palooza happy dance (https://www.youtube.com/watch?v=DY_DF2Af3LM) when an LTB is released?

Viktor85
01-17-2015, 04:16 AM
I'm not in a top team, but already have -36% upgrade time. Means i finish several days before goal ends.. upgrading this LTB now to lvl 10 gives you another 5%. So if you don't have any boosts, try to get it! Then you'll be able to finish in time with any gold anymore.

BrisingrBoss
02-03-2015, 08:49 PM
Sorry For delay in posting this, heres the info. im assuming building type B. will know for sure tomorrow.

-Commando-
02-04-2015, 11:18 AM
Thanks for sharing this. I refer to this frequently. Can you explain the building types? Can you save a less memory intensive version? My Iphone can't load the spreadsheet any more. (Not complaining)

Annihilator2
02-04-2015, 12:01 PM
Great work! Thank you very-very much!

BrisingrBoss
02-04-2015, 10:18 PM
Thanks for sharing this. I refer to this frequently. Can you explain the building types? Can you save a less memory intensive version? My Iphone can't load the spreadsheet any more. (Not complaining)

building types determine the output increase per level. there is a type that multiplies first and subsequent outputs by 1.67 times the previous one. other types have a multiplier based on the first output, like 3x 5x 8x and so on. the cost is never exact. we can approximate, but the exact cost is not the same every time. there is always some rounding up or down so its hard to use a formula based on building cost. we have a formulae but it is never 100% correct. and as far as getting a light version, i would really like to do that. my original sheet was lighter, but people messing around with it, and with the protections and extra features, speed suffered. mainly its best viewed on a PC. I have every intention of making a web version of it, but as of right now i have too many projects going on. The web version would be the ultimate version, because everyone would have individual access to their own data, nobody would have to wait for anyone else to be done looking . and hopefully i would be able to cache their bonuses info on their browser so they can easily refer to it later without having to input anything except for changes.

-Commando-
02-05-2015, 09:08 AM
Thanks. Personally I only use the projected cost and build times. Is the extra overhead related to all the historic buildings?

BrisingrBoss
02-05-2015, 04:52 PM
Mainly related to the fact that the sheet sends data back and forth between documents. had to do it because of people meddling with the data. they cant break this one, they used to break the sheet for kicks

BrisingrBoss
02-24-2015, 09:58 PM
Just Updated sheet to support building levels up to 20, still working the formulas for time and getting info about upgrade costs/output past 10. will input data as i get it.

& The Horse U Rode In On
03-18-2015, 09:58 AM
Interceptor Tower level 20 prize is Interceptor Viper (A) 782345/766854 +15% Air Attack
Level 10 prize is ?? unit +10% defense boost
Level 5 completes the temp boost bonus for +1 building upgrade

BrisingrBoss
03-18-2015, 06:21 PM
Interceptor Tower added!!! Fixed time to finish calculation to new level 20!!! Thanks for the Info. Added to the Sheet!! Ill update the other buildings cost/ output info

pelle plutt
03-19-2015, 03:46 AM
any intel on the financial center?

BrisingrBoss
03-19-2015, 03:30 PM
it is not an LTB so i didnt bother with it. i can add the info though

BrisingrBoss
03-19-2015, 03:44 PM
having a hard time with the info. i dont have these buildings yet. ill have to build to get info

& The Horse U Rode In On
04-07-2015, 04:22 PM
new LTB Ancient Castle lvl 16 is Ancient Stealth Sub 104,157,463/92,366,051

Rolinz
04-07-2015, 07:45 PM
new LTB Ancient Castle lvl 16 is Ancient Stealth Sub 104,157,463/92,366,051

You are at level 16 already?

LarryJackson
04-07-2015, 09:58 PM
http://i.groupme.com/720x405.jpeg.d4076aaab21244a1a7c90c13ae8923fb.larg e

http://i.groupme.com/720x405.jpeg.3be59ceca8a34444b4c678822363836b.larg e

http://i.groupme.com/720x405.jpeg.381afa1ec6d149c186d171591b94de7c.larg e

http://i.groupme.com/720x405.jpeg.25e38a2fea564645a9bf077672be6aab.larg e

BrisingrBoss
04-07-2015, 11:31 PM
Thanks for the info!!! Building added to sheet!!!

& The Horse U Rode In On
04-08-2015, 02:40 AM
You are at level 16 already?

No but we have a SUPer with his mini in our faction he posts SS of some levels. I just steal ;)

groovy shags
04-08-2015, 04:45 AM
Wow...level 20 already. Serious heroine addict! Good work gold buyers!

BrisingrBoss
04-29-2015, 02:00 AM
Theater of war added. any ss from prizes are welcome