Page 3 of 4

Re: CoCulator calculator

Posted: Thu Oct 13, 2016 2:00 pm
by Seret
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.

Re: CoCulator calculator

Posted: Fri Oct 14, 2016 1:25 am
by Magpie
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.

Re: CoCulator calculator

Posted: Fri Oct 14, 2016 1:46 am
by powermonger
Great Job Magpie. I've just used it to design tonight's scenario.
Thanks!

Re: CoCulator calculator

Posted: Sat Oct 15, 2016 10:51 pm
by Magpie
Uploaded to Google Sheets

I think this should link to it

https://docs.google.com/spreadsheets/d/ ... Mo/pubhtml

Re: CoCulator calculator

Posted: Tue Oct 18, 2016 10:25 am
by Seret
That's a static version of the page, Magpie.

Re: CoCulator calculator

Posted: Tue Oct 18, 2016 10:28 am
by Magpie
You Wot ?

Re: CoCulator calculator

Posted: Tue Oct 18, 2016 5:04 pm
by Emilio
It is only an image, not a working xcell page.

Re: CoCulator calculator

Posted: Tue Nov 01, 2016 2:30 am
by Magpie
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

Re: CoCulator calculator

Posted: Wed Apr 19, 2017 5:09 am
by Steve McG
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? :?:

Re: CoCulator calculator

Posted: Sun Jun 25, 2017 5:33 am
by Truscott Trotter
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