PDA

View Full Version : "All-In-One" 4.0 release



white frog
06-04-2012, 06:24 PM
I've come up with some awesome upgrades and new tools for the spreadsheet, which is currently in beta testing mode. I will have the release for it very soon!

What I need from all of you is ideas, suggestions, etc., of stuff that you would personally like to see on this new release. Let me know, and if I can I will try to integrate as many ideas as possible!

Let's have it...

Spartacus
06-04-2012, 06:29 PM
Thanks for inviting me to beta test! I will look at it tomorrow or Wednesday! Great work as always, white frog.

joaquim
06-04-2012, 06:31 PM
I have a quick question about the spreadsheet. For the 4.0 version, do you have to start a new spreadsheet or does it update the current one? Sorry, I'm new to spreadsheets.

white frog
06-04-2012, 06:50 PM
I have a quick question about the spreadsheet. For the 4.0 version, do you have to start a new spreadsheet or does it update the current one? Sorry, I'm new to spreadsheets.
There's no way that I know of to push an update to excel files, so unfortunately you'll have to input all your info into the new one!

kykboxr
06-04-2012, 07:46 PM
Looking forward to it Frog!

beaux
06-04-2012, 09:13 PM
It just keeps getting better and better cant wait!

McLovin
06-04-2012, 09:39 PM
Frog, great sheet and thanks heaps for your effort.

One suggestion is to make it more Tycoon/Goodfella-friendly. It's not that difficult to add in the 10% extra to collections but it would be nice if this was built-in. It would also make the goal calculator easier to use - I had to change all the values manually.

Also with the goal calculator, some event items have changed the time (Loaded Dice) and cost (Striker Minigun) for upgrades. Having functionality for these items built into the goal calculator would also help those with them in their inventory. To dat I have just made a new column on Lars' spreadsheet and then imported the data for myself but this is quite tedious.

white frog
06-04-2012, 10:58 PM
Goal calculator upgrades are 1 thing that's gonna have to wait! I have multiple businesses to run, and I've been working on this update for the past 2 days solid!
With that being said, there are some updates that you're absolutely going to love!!!

Vicious...
06-05-2012, 12:13 AM
I love you, White Frog.

Two thoughts: Is it possible to make additions to the equipment tabs more user friendly? And also, can you extend the available space in the goal calculator section?

mnju_03
06-05-2012, 12:19 AM
White... you never cease to amaze me. :)

Primal
06-05-2012, 12:57 AM
I want I want I want!!!! :)

I've done a few of my own, just for my inventory though, would love to see some other stuff though and play with it :)

white frog
06-05-2012, 08:57 AM
I love you, White Frog.

Two thoughts: Is it possible to make additions to the equipment tabs more user friendly? And also, can you extend the available space in the goal calculator section?
Do you have any suggestions on the equipment tabs?? I'm not really sure what I can do above getting them in alphabetical order. The only thing better than this is by item #, and that would require a data dump from the plist files, which wouldn't even accomplish everything because a lot of the new event items are server side!
The extension of the goal calculator... now that I can do!

You guys are all too kind with your comments! Truth be told, I don't really know Excel all that well, and I'm creating and updating this so I can teach myself the intricacies of the program. So I guess, in a sense, I'm doing it for selfish reasons as well!
I learned something new last night that I had to go a little overboard with, but it's really awesome and you guys are gonna love it! Not telling what it is yet though.

Dreno33
06-05-2012, 10:05 AM
lol, you're awesome white frog. you deserve every and any compliment you hear. this whooooole spreadsheet it amazing. Thank you for everything, looking much forward to the release!!


Here's my suggested inputs
(some old, most new)

1) On summary page, a Tycoon option for the building in other pages.

2) Fix the little errors i mentioned about the Sq. #s in money building pages (if you forgot) (:

3) Rearrange the buildings in level order (Laundry Mat to Casino)
~ Some are mixed up and go into the 30s than back to 20s than 40 than like high 30s. You'll see.

4) I feel stupid asking, but, could you explain the Goal Calculator more to me please. I still don't understand how to use it...
~ Maybe a few others don't, too. Maybe just more instructions for us slower people? lmaoo

5) Here's a screen shot of my Summary Page (on the bottom of it) And I will PM you with the numbers to incorporate however you wish for us or just put it in like I did for others' convenience.
http://i47.tinypic.com/6r52zt.png
SOURCE: Old thread back in February. So far (lvl 9), 100% accurate! lol

6) IDK if you have filled it out more, but would like to see if the Respect Farming Page has more data? That would be MOST useful!

7) Also, could you please insert another column in money/gold buildings pages before "Collect/Day" (Column U) and have it be editable just like the "Owned" column (X). Let us type in the amount of times we collect this building.
~ For instance, i can collect the LMs many more times than you inputted. Sometimes for the 3 hour buildings, too.
~ Secondly, this will allow others to input a decimal number to account for robberies. Which would be most-likely used for 18 hour buildings(:

8) For the Hood Layout and the one of your own buildings, trees, etc. at Default Download, allow us to edit it to our own hood b/c there are no instructions or options for that. Just curious if possible(:

9) In regards to #8, maybe have the OUTER line of hood automatically moved out 4 squares when you add a new expansion to the page "Hood Expansion"
~ I realize obviously this seems very complicated (maybe, idk. it is to me) but know you would at least have to create TWO NEW Columns (SW & SE) in "Hood Expansion" to add whether you went SW or SE in expanding for each expansion.
~ In doing this, the Hood Layout would automatically expand in the SW or SE expansion 4 squares. IDK, just an idea if it is possible.


That is all I can think of for now, check your Inbox for the data on the Level Experience.
THANKS A BILLION, White Frog(:

white frog
06-05-2012, 10:29 AM
lol, you're awesome white frog. you deserve every and any compliment you hear. this whooooole spreadsheet it amazing. Thank you for everything, looking much forward to the release!!


Here's my suggested inputs
(some old, most new)

1) On summary page, a Tycoon option for the building in other pages.

2) Fix the little errors i mentioned about the Sq. #s in money building pages (if you forgot) (:Done!

3) Rearrange the buildings in level order (Laundry Mat to Casino)
~ Some are mixed up and go into the 30s than back to 20s than 40 than like high 30s. You'll see.This is actually not possible anymore! I know it kinda sucks, but all the data is being pulled from another sheet, so it's not just as easy as copy, paste to a different location. I would have to change so many formulas! Sorry!

4) I feel stupid asking, but, could you explain the Goal Calculator more to me please. I still don't understand how to use it...
~ Maybe a few others don't, too. Maybe just more instructions for us slower people? lmaoo

5) Here's a screen shot of my Summary Page (on the bottom of it) And I will PM you with the numbers to incorporate however you wish for us or just put it in like I did for others' convenience.
SOURCE: Old thread back in February. So far (lvl 9), 100% accurate! lol

6) IDK if you have filled it out more, but would like to see if the Respect Farming Page has more data? That would be MOST useful!I have a little bit more filled out, but the problem is that I'm lvl 44 and don't see a lot of people that I can rob to get more of this info. If anyone wants to help compile this data, that would be great. Also, it appears that some of this data may have just been changed by the devs.

7) Also, could you please insert another column in money/gold buildings pages before "Collect/Day" (Column U) and have it be editable just like the "Owned" column (X). Let us type in the amount of times we collect this building.It's already there Edward.. been there all along. On the Gold Building sheet, it's column G labeled "C.p.D."
~ For instance, i can collect the LMs many more times than you inputted. Sometimes for the 3 hour buildings, too.
~ Secondly, this will allow others to input a decimal number to account for robberies. Which would be most-likely used for 18 hour buildings(:

8) For the Hood Layout and the one of your own buildings, trees, etc. at Default Download, allow us to edit it to our own hood b/c there are no instructions or options for that. Just curious if possible(:Totally confused by what you mean here!

9) In regards to #8, maybe have the OUTER line of hood automatically moved out 4 squares when you add a new expansion to the page "Hood Expansion"This isn't really possible because the outer border of the hood is simply a border. There's no formula that I can write that will automatically adjust this.
~ I realize obviously this seems very complicated (maybe, idk. it is to me) but know you would at least have to create TWO NEW Columns (SW & SE) in "Hood Expansion" to add whether you went SW or SE in expanding for each expansion.
~ In doing this, the Hood Layout would automatically expand in the SW or SE expansion 4 squares. IDK, just an idea if it is possible.


That is all I can think of for now, check your Inbox for the data on the Level Experience.
THANKS A BILLION, White Frog(:

Dreno33
06-05-2012, 10:46 AM
lol, you're awesome white frog. you deserve every and any compliment you hear. this whooooole spreadsheet it amazing. Thank you for everything, looking much forward to the release!!


Here's my suggested inputs
(some old, most new)

1) On summary page, a Tycoon option for the building in other pages.

2) Fix the little errors i mentioned about the Sq. #s in money building pages (if you forgot) (:Done!

3) Rearrange the buildings in level order (Laundry Mat to Casino)
~ Some are mixed up and go into the 30s than back to 20s than 40 than like high 30s. You'll see.This is actually not possible anymore! I know it kinda sucks, but all the data is being pulled from another sheet, so it's not just as easy as copy, paste to a different location. I would have to change so many formulas! Sorry! Sh!t, Sorry to hear that... No problem.

4) I feel stupid asking, but, could you explain the Goal Calculator more to me please. I still don't understand how to use it...
~ Maybe a few others don't, too. Maybe just more instructions for us slower people? lmaoo

5) Here's a screen shot of my Summary Page (on the bottom of it) And I will PM you with the numbers to incorporate however you wish for us or just put it in like I did for others' convenience.
SOURCE: Old thread back in February. So far (lvl 9), 100% accurate! lol

6) IDK if you have filled it out more, but would like to see if the Respect Farming Page has more data? That would be MOST useful!I have a little bit more filled out, but the problem is that I'm lvl 44 and don't see a lot of people that I can rob to get more of this info. If anyone wants to help compile this data, that would be great. Also, it appears that some of this data may have just been changed by the devs. Try PMing other Senior members that are reliable and ask them politely to write down the numbers when they come across those certain buildings? I'm sure they would NOT mind helping YOU out.

7) Also, could you please insert another column in money/gold buildings pages before "Collect/Day" (Column U) and have it be editable just like the "Owned" column (X). Let us type in the amount of times we collect this building.It's already there Edward.. been there all along. On the Gold Building sheet, it's column G labeled "C.p.D." WOW... I feel retarded.. I remembering looking into all those blue columns... must've skimmed too fast o.0
~ For instance, i can collect the LMs many more times than you inputted. Sometimes for the 3 hour buildings, too.
~ Secondly, this will allow others to input a decimal number to account for robberies. Which would be most-likely used for 18 hour buildings(:

8) For the Hood Layout and the one of your own buildings, trees, etc. at Default Download, allow us to edit it to our own hood b/c there are no instructions or options for that. Just curious if possible(:Totally confused by what you mean here! I deleted the Page on my current version, but you did have a Page called like "My Hood" and it was YOUR HOOD with YOUR LAYOUT. I really liked it and wanted to know how I could edit it into my own hood. Is this possible??? There were no instructions. Just a Key box saying what color meant what, etc. So, is this (or can this be) possible to edit?

9) In regards to #8, maybe have the OUTER line of hood automatically moved out 4 squares when you add a new expansion to the page "Hood Expansion"This isn't really possible because the outer border of the hood is simply a border. There's no formula that I can write that will automatically adjust this. O ok, NP. So, how can we delete that border and make out own? For that page and the "My Hood"?
~ I realize obviously this seems very complicated (maybe, idk. it is to me) but know you would at least have to create TWO NEW Columns (SW & SE) in "Hood Expansion" to add whether you went SW or SE in expanding for each expansion.
~ In doing this, the Hood Layout would automatically expand in the SW or SE expansion 4 squares. IDK, just an idea if it is possible.


That is all I can think of for now, check your Inbox for the data on the Level Experience.
THANKS A BILLION, White Frog(:

msjo
06-05-2012, 11:08 AM
Looking forward to the new release! I've been really happy with the 3.0 version I've been using.

Vicious...
06-05-2012, 01:53 PM
Do you have any suggestions on the equipment tabs?? I'm not really sure what I can do above getting them in alphabetical order.
Sorry, WF, what I meant was make it so it's simple to add items that are new from events or limited gold items, etc. Is it possible that, like the goal calculator, empty cells can be added and users can just type in the info without having to alter formula code?

Gaming Will
06-05-2012, 02:11 PM
Really nice job White Frog.

My brain hurts.

Swearengen
06-06-2012, 08:53 AM
It looks great so far. All of it is an A+, maybe some more detailed directions for those on the forum who are not computer/spreadsheet savvy. Might save on posts and PM's to you...

white frog
06-06-2012, 09:11 AM
It looks great so far. All of it is an A+, maybe some more detailed directions for those on the forum who are not computer/spreadsheet savvy. Might save on posts and PM's to you...
I will definitely do that... there's gonna be a lot of new features, and I really want everyone to know how to use them!

white frog
06-06-2012, 09:22 AM
Okay.. This is the last opportunity to get your input in! I am hoping to release the new version of the "All-in-One" by tomorrow, so if anyone has any suggestions as to additions or features that you would like to see, let me know! I will accept suggestions until 5 pm Central Time, and then it's time to get to work integrating all that I already have!

This is going to be the most important update yet! I'm really excited to get it out to all of you... think you're really gonna love it!

Swearengen
06-06-2012, 09:37 AM
Okay.. This is the last opportunity to get your input in! I am hoping to release the new version of the "All-in-One" by tomorrow, so if anyone has any suggestions as to additions or features that you would like to see, let me know! I will accept suggestions until 5 pm Central Time, and then it's time to get to work integrating all that I already have!

This is going to be the most important update yet! I'm really excited to get it out to all of you... think you're really gonna love it!

http://img6.imageshack.us/img6/1750/frogking1.jpg (http://imageshack.us/photo/my-images/6/frogking1.jpg/)

http://img84.imageshack.us/img84/6028/frogking2.jpg (http://imageshack.us/photo/my-images/84/frogking2.jpg/)

white frog
06-06-2012, 10:48 AM
Not a king.. A servant!

iteachem
06-16-2012, 08:09 AM
Want to give a shout out to the frog for making this. Spent a decent amount of time getting data into this yesterday and am only off by 100 defense points (not too bad ... now to find where I messed up)..

Its really a nice tool to figure out what to farm etc.

I am having trouble with figuring out how to use the goal calculator. I sent frog a pm about that but anyone else who could help me figure it out, I would be more than happy to have your help.

My question for the goal calculator is how when I put in a new building to put in the numbers for the
Upgrade Cost, Hourly Upgrade Upgrade Time, Saving Time etc. Those are formula fields so I can't just copy and paste numbers. Am I missing something?

Thanks

Swearengen
06-17-2012, 02:29 PM
Want to give a shout out to the frog for making this. Spent a decent amount of time getting data into this yesterday and am only off by 100 defense points (not too bad ... now to find where I messed up)..

Its really a nice tool to figure out what to farm etc.

I am having trouble with figuring out how to use the goal calculator. I sent frog a pm about that but anyone else who could help me figure it out, I would be more than happy to have your help.

My question for the goal calculator is how when I put in a new building to put in the numbers for the
Upgrade Cost, Hourly Upgrade Upgrade Time, Saving Time etc. Those are formula fields so I can't just copy and paste numbers. Am I missing something?

Thanks

good question - I was planning on asking him the exact same thing! I tried upprotecting and cut and pasting numbers but that F'ed it all up :(

As for stat calc's, it was pretty much on the money, think my econ was off by about $50-100 and my def stats by around 80 also but damn close and good enough for me.

white frog
06-17-2012, 03:08 PM
Goal Calculator:

***The formulas in the data entry cells can be removed so you can manually input the data***

Most efficient way of using:

1. On a particular cell (Upgrade Cost, Hourly Upgrade, Upgrade Time), use the "SUM" function, and go to the "Money Building" sheet to choose the appropriate cell. (This is the formula that is there currently)
2. Once you have this done for lvl. 1 on a particular building, then you can just click and drag the formula down through lvl. 10 of that respective building.

***Saving Time will be automatically generated once your income buildings are input, and the respective Upgrade Cost has been input***