# Formulas/Spreadsheets

**URL:** <https://forum.vassalengine.org/t/formulas-spreadsheets/4250>\
**Category:** Module Design\
**Created:** [September 9, 2011, 12:53am UTC](https://forum.vassalengine.org/t/formulas-spreadsheets/4250 "2011-09-09T00:53:35Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![chrono280](https://forum.vassalengine.org/letter_avatar_proxy/v4/letter/c/47e85d/32.png) [@chrono280](https://forum.vassalengine.org/u/chrono280)\
**Post date:** [September 9, 2011, 12:53am UTC](https://forum.vassalengine.org/t/formulas-spreadsheets/4250/1 "2011-09-09T00:53:35Z")

</div>

Is there a way to implement simple formula execution like in a spreadsheet?

Alternatively, is there a way to have one of the Private Window buttons display something like the Spreadsheet piece property that can be private and unique for a given player?

Is there a way to count up all of the pieces of a given type on the board?

Thanks, I know I’m a total noob. 😃

---

<div class="post-metadata">

**Author:** ![DrNostromo](https://forum.vassalengine.org/user_avatar/forum.vassalengine.org/drnostromo/32/12593_2.png) [@DrNostromo](https://forum.vassalengine.org/u/DrNostromo)\
**Post date:** [September 9, 2011, 2:38am UTC](https://forum.vassalengine.org/t/formulas-spreadsheets/4250/2 "2011-09-09T02:38:56Z")

</div>

> [@](#):
>
> Is there a way to implement simple formula execution like in a spreadsheet?

You can increase / decrease the value of a property but you can’t do much as far as formula’s beyond that as Vassal does not have a math engine at this time. Newer versions of Vassal should have a math engine in it.

> [@](#):
>
> Alternatively, is there a way to have one of the Private Window buttons display something like the Spreadsheet piece property that can be private and unique for a given player?

Yes. This would probably involve the use of Global Properties and/or Dynamic Properties to track values. You can then set up something in a private window to display those values.

> [@](#):
>
> Is there a way to count up all of the pieces of a given type on the board?

Yes. You can have all the pieces you want counted to have the same Marker Trait. Something like UnitType = Army. You can then send a command to all pieces with UnitType = Army and have them all increase a Global Property being used for keeping track of the unit count. (something like ArmyCount)
