Google Doc info for calculating Contribution Value

I made a very basic google doc to calculate Contribution Value accurately for this site, here's the info on how to make one for your own.

It can be used to play around with how much a bundle or non-bundle game will add to your contribution value if you are interested in seeing those scenarios.

Create a new spreadsheet, with the following columns:

"Game", "Price", "Bundle Price", "Quantity"

Enter your giveaways with either a Price (non-bundle game) or Bundle Price (bundle game) and a Quantity.

Assuming 19 rows for this example, on row 20 :

• make a Total label in the Game column
• where the entry in the Price column =(25 + SUMPRODUCT(B2:B19,D2:D19))
• the entry in the Bundle Price column =min(B20*.20, SUMPRODUCT(C2:C19,D2:D19) - 25)
• and in the Quantity column or the next column =B20+C20

These calculations assume you have given away at least $25 worth of bundle games, if you haven't done that, you don't need a spreadsheet to figure out your contribution value.

Lastly remember that prices on Steam are not round numbers, so its $4.99 not $5.00 for a 5P giveaway... Whereas prices for say a full bundle giveaway are round (like $1.00 or $6.00)

Pro Tip: Always leave the line (19 in this example) before the Total blank, and use "insert 1 above" to add new games - this way the calculations auto-adjust.