mickymacirl
06-14-2012, 01:17 AM
Hello all,
Having looked at Enjoys spreadsheet as well as WP's I find that no one has produced a spreadsheet that calculates gold vs cash units etc with unit density etc.
I am currently working on an excel sheet that reads from your iPhone profile and automatically populates the spreadsheet with gold and cash units that you have, plus other information like number of allies and gold balance/cash etc.
This only works for a jailbroken iDevice at the moment but I plan on making it autoread from any device.
Does anyone have any suggestions on what they would like included on the spreadsheet?
Currently I have the following:
First Sheet:
Total Alliance Attack and Defense / Total Allies / Total Units Brought to Battle (allies by 4) / Lowest Unit Attack and Defense / Average of all Gold and Cash Units Attack and Defense/ Highest Unit Attack and Defense / Army Density (units brought to battle */* alliance attack and/or defense)
Gold Units------> Total of Gold Air Units-------> Average Gold Air Unit Attack and Defense. -> Number of Gold Air Units.
Gold Units------> Total of Gold Sea Units------> Average Gold Sea Attack and Defense. -> Number of Gold Sea Units.
Gold Units------> Total of Gold Infantry Units--> Average Gold Infantry Attack and Defense. -> Number of Gold Infantry Units.
Gold Units------> Total of Gold Ground Units--> Average Gold Ground Attack and Defense. -> Number of Gold Ground Units.
Second Sheet:
Cash Units------> Total of Cash Air Units-------> Average Cash Air Unit Attack and Defense. -> Number of Cash Air Units.
Cash Units------> Total of Cash Sea Units------> Average Cash Sea Attack and Defense. -> Number of Cash Sea Units.
Cash Units------> Total of Cash Infantry Units--> Average Cash Infantry Attack and Defense. -> Number of Cash Infantry Units.
Cash Units------> Total of Cash Ground Units--> Average Cash Ground Attack and Defense. -> Number of Cash Ground Units.
Last sheet uses Enjoy's building and information sections.
Anything to include would be very good!
Thanks
Micky
Having looked at Enjoys spreadsheet as well as WP's I find that no one has produced a spreadsheet that calculates gold vs cash units etc with unit density etc.
I am currently working on an excel sheet that reads from your iPhone profile and automatically populates the spreadsheet with gold and cash units that you have, plus other information like number of allies and gold balance/cash etc.
This only works for a jailbroken iDevice at the moment but I plan on making it autoread from any device.
Does anyone have any suggestions on what they would like included on the spreadsheet?
Currently I have the following:
First Sheet:
Total Alliance Attack and Defense / Total Allies / Total Units Brought to Battle (allies by 4) / Lowest Unit Attack and Defense / Average of all Gold and Cash Units Attack and Defense/ Highest Unit Attack and Defense / Army Density (units brought to battle */* alliance attack and/or defense)
Gold Units------> Total of Gold Air Units-------> Average Gold Air Unit Attack and Defense. -> Number of Gold Air Units.
Gold Units------> Total of Gold Sea Units------> Average Gold Sea Attack and Defense. -> Number of Gold Sea Units.
Gold Units------> Total of Gold Infantry Units--> Average Gold Infantry Attack and Defense. -> Number of Gold Infantry Units.
Gold Units------> Total of Gold Ground Units--> Average Gold Ground Attack and Defense. -> Number of Gold Ground Units.
Second Sheet:
Cash Units------> Total of Cash Air Units-------> Average Cash Air Unit Attack and Defense. -> Number of Cash Air Units.
Cash Units------> Total of Cash Sea Units------> Average Cash Sea Attack and Defense. -> Number of Cash Sea Units.
Cash Units------> Total of Cash Infantry Units--> Average Cash Infantry Attack and Defense. -> Number of Cash Infantry Units.
Cash Units------> Total of Cash Ground Units--> Average Cash Ground Attack and Defense. -> Number of Cash Ground Units.
Last sheet uses Enjoy's building and information sections.
Anything to include would be very good!
Thanks
Micky