CoCulator calculator

Moderators: Vis Bellica, Laffe

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

CoCulator calculator

Post by Magpie » Sun Oct 09, 2016 10:32 am

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
Last edited by Magpie on Wed Oct 12, 2016 11:05 am, edited 1 time in total.
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
Arlequín
Posts: 1290
Joined: Thu Sep 05, 2013 11:29 pm
Location: King's Vale Royal

Re: CoCulator calculator

Post by Arlequín » Sun Oct 09, 2016 1:47 pm

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.

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

Re: CoCulator calculator

Post by Magpie » Sun Oct 09, 2016 11:35 pm

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 ?
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
Arlequín
Posts: 1290
Joined: Thu Sep 05, 2013 11:29 pm
Location: King's Vale Royal

Re: CoCulator calculator

Post by Arlequín » Mon Oct 10, 2016 7:45 am

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.

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

Re: CoCulator calculator

Post by Magpie » Mon Oct 10, 2016 9:04 am

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.
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
Arlequín
Posts: 1290
Joined: Thu Sep 05, 2013 11:29 pm
Location: King's Vale Royal

Re: CoCulator calculator

Post by Arlequín » Mon Oct 10, 2016 9:40 am

Excellent, thanks!

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

Re: CoCulator calculator

Post by Magpie » Mon Oct 10, 2016 9:44 am

Put some drop down lists in too
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

Groupe_Franc
Posts: 73
Joined: Wed Aug 19, 2015 11:48 pm

Re: CoCulator calculator

Post by Groupe_Franc » Tue Oct 11, 2016 5:41 pm

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

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

Re: CoCulator calculator

Post by Seret » Tue Oct 11, 2016 8:31 pm

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?

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

Re: CoCulator calculator

Post by Magpie » Tue Oct 11, 2016 11:10 pm

Oops, I've not copied the new version back to drop box.
I'll get it back up tonight.
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

Post Reply