Page 1 of 4

CoCulator calculator

Posted: Sun Oct 09, 2016 10:32 am
by Magpie
Hello all

I have made a spreadsheet that allows you to calculate point and list levels for AFV and Infantry.
It also contains a listing of HE values for various weapons, let me know if there are any you wish to add.

The spreadsheet is locked and you can only enter the required data for the calculations.

Post any questions and feedback you might have.

https://www.dropbox.com/s/uvpypn0mi75y7 ... .xlsx?dl=0

Re: CoCulator calculator

Posted: Sun Oct 09, 2016 1:47 pm
by Arlequín
Well done and thanks! :)

For me the only thing missing is varying the values for units which are not 'regular'; although as it does everything else for you, I shouldn't complain.

Re: CoCulator calculator

Posted: Sun Oct 09, 2016 11:35 pm
by Magpie
Arlequín wrote:Well done and thanks! :)

For me the only thing missing is varying the values for units which are not 'regular'; although as it does everything else for you, I shouldn't complain.
Do you mean a troop quality multiplier ?

If so, by section or for the platoon as a whole ?

Re: CoCulator calculator

Posted: Mon Oct 10, 2016 7:45 am
by Arlequín
Yes and for the platoon as a whole. There's no need to do it section by section unless it's easier to do it that way on the sheet.

Re: CoCulator calculator

Posted: Mon Oct 10, 2016 9:04 am
by Magpie
OK Calulator is updated and allows you to put in an experience level rating.

I've added a list ranking for each section for if you are building support list sections, but note that they pick up the ELR of the main platoon too.

Re: CoCulator calculator

Posted: Mon Oct 10, 2016 9:40 am
by Arlequín
Excellent, thanks!

Re: CoCulator calculator

Posted: Mon Oct 10, 2016 9:44 am
by Magpie
Put some drop down lists in too

Re: CoCulator calculator

Posted: Tue Oct 11, 2016 5:41 pm
by Groupe_Franc
Thank you for the offering. I have a couple of suggestions. The "semi auto" row had a '1' in each of the points boxes which get included in the final total. Seems to me that this results in totals being 5 points too high. Could you add the option for a transport carrying value so that half tracks can be computed using the AFV calculator. TIA

Re: CoCulator calculator

Posted: Tue Oct 11, 2016 8:31 pm
by Seret
Magpie wrote:OK Calulator is updated and allows you to put in an experience level rating.
I'm not seeing it. Is the link above to an older version?

Re: CoCulator calculator

Posted: Tue Oct 11, 2016 11:10 pm
by Magpie
Oops, I've not copied the new version back to drop box.
I'll get it back up tonight.