Look for the thread started by neggs and you may find your answer.
Printable View
Nevermind! :)
http://clashofclansbuilder.com
Love it!
Hard work.. needs to be rewarded :)
For update/next versions:
Try to include decorations?
Great layout planner, works verygood i must say. I never even saw there was also a wall counter in the sheet. What i did was is just fill in the layers for walls with different colors for the different wall types. The only problem i had, was the range for the defenses didnt match with the original ones after i replaced them a couple of times. But im pretty impressed with ur work man, keep it up! :D
You cannot replace the original objects in the sheets or even make duplicates of them without manually going in to change the coding for the range indicators to work. I use Invisible ovals which are grouped with the defenses and call them by their exact name. Copying and pasting an object will create new ovals which are not included in the coding.
The code looks like this for making the oval appear:
If you want the range indicators to work you should download the original excel sheet again, or modify the coding to accommodate your new objects. This can be done by going to the Developer Tab > Macros > Edit. Then use the "selection pane" to find the object name.Code:ActiveSheet.Shapes.Range(Array("Oval 146")).Visible = msoTrue
Curious to see if this spreadsheet would work in numbers for Ipad? That would be something I would use weekly!
Bump. Is the OP still here though? When I try to copy and paste buildings, the macros get messed up, resulting on the removation of the ranges of the defenses. Any one knows how?
Looks good.