instead of posting a new topic everytime a new version is released, I will now stick only to this 1 thread. All updates, versions information will be posted here and bump when there is a new released. Additionally, you can go to the below group for any new updates. My spreadsheet are released by Versions.
"Facebook Group: Castle Age Analysis Spreadsheet"
The spreadsheet is created with the idea as an all around spreadsheet you only need in castle age. It does a ton of calculation and helps you ease calculations in quite a number of stuffs for Castle Age. Due to the above mentioned, the file size is 904kb+ now so if you want to use the spreadsheet, you will need to scroll down for the download link.
The LATEST version released now is Version 1.8.131209
How to read the version?
My version starts from 1.0. Every released with at least 1 new feature will be upgraded by 0.1
If the released was only updates and correction of errors on existing version, the date when I start to work on the correction will be input at the back.
Eg. If version 1.0 was updated with only more loot info or correction of errors on 10 Nov 09, The new release version will read Version 1.0.101109
Date will always be in DD/MM/YY order.
Instructions - A tab with Instructions on how to use the spreadsheet.
Dashboard - The first tab you need to fill up in order for the spreadsheet to function properly. Opponent information can be filled in here too if you want some analysis on them. Quest xp/energy ratio and gold/energy ratio is located here too. You will need to choose which quest is unlock so that the calculation will take place.
Land - Automatic Calculation on which land to buy next and the amount to buy based on Return on Investment (ROI) if you are going to spend X amount of Gold now. One of the most visited tab if you use this spreadsheet
Combat Analysis - a listing of all your items. It tells you which unit is wasting your upkeep and not use in combat at all(auto highlight in light red). Other information like how many are use in atk/def, how many in total, the combat points they gives are avail for viewing.
Duel Analysis - Auto picks your best items that will be used in duel when attacking or defending. A table to equip your opponent with his gears to know his total atk and def values. Tells you which items are Game BEST for atk/def currently.
Army Optimizer *Beta & New* - Newly introduced in Version 1.7. It tells you which are the Game Best atk/def units, which are your best atk/def units when Invading. It also have an Optimized Button which helps you calculates how many of which units you can purchase to maximize your atk/def.
Epics Analysis*Beta & New* - Newly Introduced in Version 1.8. It tells you an estimated possibility if the respective target can be killed with the time remaining. This gives you a rough idea if you should engage and take part in the Hunt or to ignore and source for better more worthwhile Epics.
Summary - Gives a summary of your statistic. Upkeep % of income, your atk strength, your defend strength. Opponent atk/def analysis
Version Information - Includes all information on all the version released
Initial Version - Many missing items and some errors
Updated most of the database up to date. Working Condition
Land Tab introduced
Updated with rearrangment cells for dashboard - Data will not be mess if its cut and inserted
Duel Analysis added
Macro Enable to copy land updates to Dashboard
Only usable with 2007 office
Fixed Land Calculator Issues
Introduced Duel tab
Improvement on the Land Calculator - Detail instruction at the "Instructions Tab"
Added in New updates to database - New hero, gaunlets
Made Dashboard list easier to find. Ctrl+F can be used now
Restructred the Dashboard to make inputs of data easier.
Add in Macro buttons to navigate faster
Major reconstruction of the Combat Tab to correctly reflect the amount and items used.
Reformulated Duel Tab to pick the more likely choice of items to combat.
Fixed up Duel Tab - added new feature with drop list
Added a New Summary Tab - more information is interpreted for the Combat Analysis Tab
Added Quest Section to Dashboard
Added Opponent section to dashboard
Added New Feature - Opponent Analysis under Summary Tab
Due to the shortkey constraint, taken away a few Macros.
Corrected formulas in the choosing of items used in combat/duel - Thanks to karthikkrishna for pointing the formula out
Corrected some cells reference of combat tab - Thanks to Hels for pointing that out
Done minor touch up to appearance on Summary Tab
Army Optimization Tab Introduced *Beta*
Sword of redemption reclass from Weapon to shield - thx Traghan for pointing this out
Corrected Malestrom to Maelstrom - Thx Traghan for pointing this out
Quest updated from Wikis as listed in Instructions
Illusia's Bauble confirmed on both Wikis site that it is a Shield
Sylvanas, the Sorceress Queen - loot added
Introduced Epics Analysis Tab
Enchance Land Calculator
Fixed Cell reference on Army Optimization tab - Your Best Invade atk/def
Added loot - Enchanted Lantern
Added loot - Poseidon's Horn, Shadowmoon
Illusia's Bubble reclass to Amulet
Battle Rank Moved to Dashboard with drop down list
Quick fixed to land calculator and Enchanted Lantern
Amended method of choosing for Land ROI - Thx Jason Weiss for identifiying it
Enchance Land Tab so that you do not need to rekey left over Gold for the calculator to reformulate which is the next best land.
Simply just use the Macro and it will refresh automatically
*Work in Process* - Generals abilities, New Serpent Combat information, New loot
The spreadsheet is outdated in its data for now as there are many new features implmented recently. Although you can still use the information of the spreadsheet as a rough guide.
Fix the left over gold Macro, now it will correctly display the left over amount and update accordingly.
[SIZE="2"]Requirement: MS Office 2007. Macro Enabled
MS Office 2007 Free 60 days Trial d/l link: http://us20.trymicrosoftoffice.com/d...?culture=en-US
Download Link: http://www.mediafire.com/?kz1dndzjw20[/SIZE]
How to enable Macro
Hope you will like what I had done. Feel free to post any errors, feedbacks, comments, like/dislike, encouragement etc... in relation to the Spreadsheet.
I will try to improve it but there is also only that much knowledge I have and can do.
Cheers and Enjoy! ^^