calculating juice

[tbiala]

how would i go about calculating the average juice in my spreadsheet that tracks my bets to figure out the win % i would need for my average juice bet to be able to break even $ wise. Is it just a simple, sum of the column and - and + can be combined? for instance average of 110, 105, -110, -115. ? Im assuming one of Ganchs formulas do this but not sure which one or if even. Again im new to all this excel stuff. thanks

[suicidekings]

It should be calculated as a weighted average dependent on bet size, using the decimal odds rather than the american odds.

So if you had two bets:
3 units @ -110 (1.91)
1 unit at +170 (2.70)

The average odds bet would be (3*1.91 + 1*2.7)/4 = 2.108 = +111

Then, calculating the W% required to break even is simple.