CoCulator calculator

Moderators: Laffe, Vis Bellica

User avatar
Seret
Posts: 4031
Joined: Sat Jul 05, 2014 7:45 pm
Location: Kent UK
Contact:

Re: CoCulator calculator

Post by Seret » Thu Oct 13, 2016 2:00 pm

Arlequín wrote:there isn't and we have to live with that.
Indeed.

Moving on then: good job on this spreadsheet Magpie. Should be a handy tool for people. Have you considered moving it over to a collaborative platform like Google Docs so that people can suggest tweaks to it right on the sheet? Worked a charm for creating the Arsenal.

Magpie
Posts: 558
Joined: Fri Jan 16, 2015 12:29 pm
Location: Cairns, Australia

Re: CoCulator calculator

Post by Magpie » Fri Oct 14, 2016 1:25 am

Yep Google Docs for sure, especially with the HE compilation which needs work and I am thinking of adding in a AP value listing as well.

Just wanted to get the "coarse grind" done first.
CoC Calculator (Excel spreadsheet to calc platoon and list levels)
https://www.dropbox.com/s/uvpypn0mi75y7 ... .xlsx?dl=0

Post additions/corrections to the CoC Calcualtor
viewtopic.php?f=35&t=4423

powermonger
Posts: 94
Joined: Sun Aug 14, 2016 1:16 am

Re: CoCulator calculator

Post by powermonger » Fri Oct 14, 2016 1:46 am

Great Job Magpie. I've just used it to design tonight's scenario.
Thanks!

Magpie
Posts: 558
Joined: Fri Jan 16, 2015 12:29 pm
Location: Cairns, Australia

Re: CoCulator calculator

Post by Magpie » Sat Oct 15, 2016 10:51 pm

Uploaded to Google Sheets

I think this should link to it

https://docs.google.com/spreadsheets/d/ ... Mo/pubhtml
CoC Calculator (Excel spreadsheet to calc platoon and list levels)
https://www.dropbox.com/s/uvpypn0mi75y7 ... .xlsx?dl=0

Post additions/corrections to the CoC Calcualtor
viewtopic.php?f=35&t=4423

User avatar
Seret
Posts: 4031
Joined: Sat Jul 05, 2014 7:45 pm
Location: Kent UK
Contact:

Re: CoCulator calculator

Post by Seret » Tue Oct 18, 2016 10:25 am

That's a static version of the page, Magpie.

Magpie
Posts: 558
Joined: Fri Jan 16, 2015 12:29 pm
Location: Cairns, Australia

Re: CoCulator calculator

Post by Magpie » Tue Oct 18, 2016 10:28 am

You Wot ?
CoC Calculator (Excel spreadsheet to calc platoon and list levels)
https://www.dropbox.com/s/uvpypn0mi75y7 ... .xlsx?dl=0

Post additions/corrections to the CoC Calcualtor
viewtopic.php?f=35&t=4423

User avatar
Emilio
Posts: 573
Joined: Tue Sep 03, 2013 8:43 pm
Location: Cee, Galicia, Northwest Spain
Contact:

Re: CoCulator calculator

Post by Emilio » Tue Oct 18, 2016 5:04 pm

It is only an image, not a working xcell page.

Magpie
Posts: 558
Joined: Fri Jan 16, 2015 12:29 pm
Location: Cairns, Australia

Re: CoCulator calculator

Post by Magpie » Tue Nov 01, 2016 2:30 am

I'm not happy with how it's coming up in Google Sheet, it doesn't seem to do the vlookups correctly and won't hide all the messy data bits so maybe best to stick with the Dropbox link and post any addition recommendations here
CoC Calculator (Excel spreadsheet to calc platoon and list levels)
https://www.dropbox.com/s/uvpypn0mi75y7 ... .xlsx?dl=0

Post additions/corrections to the CoC Calcualtor
viewtopic.php?f=35&t=4423

User avatar
Steve McG
Posts: 133
Joined: Sat Apr 09, 2016 3:15 am
Location: Sydney ... and not too far from Manly Beach

Re: CoCulator calculator

Post by Steve McG » Wed Apr 19, 2017 5:09 am

Firstly, great job on the calculator. It has proved very useful and saved a great deal of time.

I am now expanding my force and want to see where/how these pieces will fit on the Lists. I have noticed that on the Consolidated Arsenal the Sherman is now a List 8 Tank. I was wondering why and used the Calculator to check. This has prompted a couple of questions on the Calculator and then how it links to the Consolidated Arsenal.

Is this the best place/method to ask such a question? If not where? :?:
There's a fundamental truth to our nature. Man must explore. ... Neil Armstrong

User avatar
Truscott Trotter
Posts: 7201
Joined: Mon Sep 09, 2013 11:11 pm
Location: Tasmania the Southernmost CoC in the world

Re: CoCulator calculator

Post by Truscott Trotter » Sun Jun 25, 2017 5:33 am

Hi Guys
Finally started using this but there is a mistake on one of the formulas but I cannot alter it as I do not have the password
The total on the infantry sheet multiplies by the C4 cell but the totals it uses are already multiplied by C4 so you double count for elite
Cheers
TT

Post Reply