NEED HELP WITH SPREADSHEET WITH BETTING AMOUNT PER UNIT...ANYBODY with SUGGESTIONS???

I want to bet 3% (60.00) of my bankroll (2,000.00) per unit. If I win or lose, my unit size should increase or decrease. Example shown below:

Starting Bankroll ~ 2,000.00  Total  0.00 unit

1 bet ~ 1u 60.00 WIN    60.00
2 bet ~ 1u 60.00 LOSE (66.00)
3 bet ~ 1u 60.00 LOSE (66.00)
4 bet ~ 1u 60.00 LOSE (66.00)
Total ~ -2.3 unit lost  for  -138.00  (for the day)

Ending Bankroll ~ 1,862.00  Total  -2.3 unit

So my next betting unit will be 55.86 (3% of 1862.00)

But now when I multiply my betting amount to my total unit size (55.86 x -2.3u = -128.48), it does not equal what I have lost which is suppose to be -138.00. Eventhough it is a small difference, in the long run, the discrepancy will be far apart. Can somebody tell me what I am doing wrong. I want to be able to see if I am up or down to the exact amount with my unit total to lose/win total. Any suggestions is greatly appreciated. Thanks.

should say 25% change

Jack,
But the fact is I lost 60 plus juice. That has to reflect in my bankroll. I can't say I lost 18.00 when I lost 198.00. Where would I keep tabs on the -18.00 juice I lost. This is only for a line of -1.10. What happens when I lay heavier chalk?? I want to maximize but hot streaks by upping my unit amount and minimizing when I'm cold...still haven't figured it out...Thanks for the input.

I can't say I lost 18.00 when I lost 198.00.

That should say 180.00 when I lost 198.00.

Jack,
After reading your post and using your example in my spreadsheet, it all totals up to the exact amount. Thank you for the pointer. It's greatly appreciated.