Calculating the EV of shoving

Being all slick in Excel:

Select the cell A1
write "Fold Equity" (w/o quotes) or whatever you want to remind you what B1 is.
Select the cell B1
Enter the value 0.87 and press Enter
re-select cell B1
in the top left corner, where it tells you the cell name (B1), click there and type "F" (w/o quotes) and press Enter

repeat this process for cells B2, B3, B4, but with the appropriate values and letters, labeling them in column A so you know what they are.
1.3 -> P
0.42 -> E
9 -> S


Then just copy the following line and paste it anywhere in your spreadsheet. You need the equals sign at the beginning.

=F*P+(1-F)*(E*(P+S)-(1-E)*S)

Now you can change any of the numbers in your column B and the solution automatically updates.


EDIT: It helps readability of the sheet if you change the format of the equity cells (B1,B3) to %-ages and the other cells to currency.