Find User here you can look for a user

Excel Sheet

6y
#1
Hi everybody,
here is an excel sheet to help you building Your Colony.
Sheet Version updated for game version v0.48.

Features:
-Race selection to display only corresponding buildings / resources.
-Load/Save Templates function to switch between different colonies.
-Hide/Display function for "Premium" structures.
-Hide/Display Results section for Better view of Entries.
-Included Tech Trees pictures.

LINK:https://drive.google.com/uc?export=download&id=0B3hNN_j8PwVabEZqNkx4Q2VlSnM
Join one of my commonwealths:
[FFF] PINOY H Core (UE): uiCGj6Te
[FFF] PINOY L Core (LIS): cCV9wGK4
[FFF] PINOY Z Core (ZP): mm8aAqbT
6y
#2
Hey couple of suggestions:
1) could you separate the results and building listing into separate tabs? The results section is now taking up so much space that on my small monitor (yes only a 14") I have to actually go full screen for the excel sheet just to see the section to scroll thru the buildings and its only about 6 lines that I can see. I know its quite a bit of work because of having to change all the formulas from just cell to page/cell references but it would look a lot better and give you more room for a better looking results tab if you wanted.

2) Also, could you post a share link instead of a download link? This is mostly because not everyone has a program to open spreadsheets installed and it makes it easier if they just want it on the google drive anyway as they can either download or save a copy for themselves if they want to.
6y
#3
I think it also would be useful for result part to have 'Use 1000 separators enabled' :)
6y
#4
misteddawn said:Hey couple of suggestions:
1) could you separate the results and building listing into separate tabs? The results section is now taking up so much space that on my small monitor (yes only a 14") I have to actually go full screen for the excel sheet just to see the section to scroll thru the buildings and its only about 6 lines that I can see. I know its quite a bit of work because of having to change all the formulas from just cell to page/cell references but it would look a lot better and give you more room for a better looking results tab if you wanted.

2) Also, could you post a share link instead of a download link? This is mostly because not everyone has a program to open spreadsheets installed and it makes it easier if they just want it on the google drive anyway as they can either download or save a copy for themselves if they want to.


Sorry just saw you message,
1) It's not really a big deal changing that, but on my side i like having both entries and results on the same page. I can add a button that will hide the result section. Is that alternative can make it for you?

2)Unfortunately Google docs is not compatible with my document formulas and macros. And the main reason i don't want to make it sharable is any wrong edition can break the results without even knowing it. Calculation would be wrong for the next user...
Join one of my commonwealths:
[FFF] PINOY H Core (UE): uiCGj6Te
[FFF] PINOY L Core (LIS): cCV9wGK4
[FFF] PINOY Z Core (ZP): mm8aAqbT
6y
#5
banginis said: I think it also would be useful for result part to have 'Use 1000 separators enabled' :)

Yes i planned to do that for the next 0.44 update, the file is ready, just need the ref page to be updated as i need some confirmations about the trashes generation ratios.
Join one of my commonwealths:
[FFF] PINOY H Core (UE): uiCGj6Te
[FFF] PINOY L Core (LIS): cCV9wGK4
[FFF] PINOY Z Core (ZP): mm8aAqbT
6y
#6
I don't like that you make it a downlodable file. you should click "Share Link" and put that there. I never like downloading things from internet.
I love to give feedback and suggest new things!
6y
#7
BestColony11 said:I don't like that you make it a downlodable file. you should click "Share Link" and put that there. I never like downloading things from internet.

If I do that, it will automatically open online with Google Sheets, and it is not compatible with my sheet....
I made it downloadable specially because of that reason...
Join one of my commonwealths:
[FFF] PINOY H Core (UE): uiCGj6Te
[FFF] PINOY L Core (LIS): cCV9wGK4
[FFF] PINOY Z Core (ZP): mm8aAqbT
6y
#8
Updated first post with the sheet for game version 0.44...
Join one of my commonwealths:
[FFF] PINOY H Core (UE): uiCGj6Te
[FFF] PINOY L Core (LIS): cCV9wGK4
[FFF] PINOY Z Core (ZP): mm8aAqbT
6y
#9
You use MS Excel for the spreadsheet then? I usually use google docs due to not really needing to download/install a full blown office program. I have installed OpenOffice (I'm cheap, sue me) so I will try that and see if some of those other functions you mentioned work - google docs only has the tech trees and none of the other features you mention in your first post. I'll post back if OpenOffice supports those for you and others information.

Edit: OpenOffice actually shows those functions you mention but they don't work :(. Not sure if they are dependent on something so I can figure an equivalent in OpenOffice so they work.

Side question - did you figure out the waste management stuff as I don't see the resource page updated yet?
6y
#10
misteddawn said:You use MS Excel for the spreadsheet then? I usually use google docs due to not really needing to download/install a full blown office program. I have installed OpenOffice (I'm cheap, sue me) so I will try that and see if some of those other functions you mentioned work - google docs only has the tech trees and none of the other features you mention in your first post. I'll post back if OpenOffice supports those for you and others information.

Edit: OpenOffice actually shows those functions you mention but they don't work :(. Not sure if they are dependent on something so I can figure an equivalent in OpenOffice so they work.

Side question - did you figure out the waste management stuff as I don't see the resource page updated yet?


Sorry i should have told you that i tried my sheet on open office and noticed the macros and forms (buttons) are not working well...
About trash, yes i added trash in ressources tendances. The reference page has not been updated yet but i added it in my sheet as i understood the definitions inside the "game.js" file. For your information only houses except sheet farm are generating trashes.
What about the "HIDE Results" button ? Did it fullfilled your need?
Join one of my commonwealths:
[FFF] PINOY H Core (UE): uiCGj6Te
[FFF] PINOY L Core (LIS): cCV9wGK4
[FFF] PINOY Z Core (ZP): mm8aAqbT

Linkback References

My Colony





Welcome
Ape Apps, LLC is an independent software development company founded in 2010 by Brandon Stecklein. Over the years, Ape Apps has published over 400 apps and games across various platforms. You can get in touch with Brandon on Twitter or by leaving a post on his wall @bastecklein
App of the Day