I would agree that redemptions should be an entirely separate sheet (or tab). I also love it because I will actually go back and read about our previous trips and it will remind me of them, lol (kinda pathetic, I know haha!)
I'll copy and paste the text from one of my vacations on my spreadsheet (You'll just have to imagine the columns and grid-lines, lol!). I do both a line item detail and summary section
DETAILS:
Flights There (19,500pts) $347.92
Flights Home (20,840pts) $367.92
(less) Southwest Points (40,340 pts total) $ (671.04)
Hotel - Beach Club (3 nights) $ 1,355.79
Hotel - Polynesian (4 nights) $ 2,157.43
(less) Hotel Discount (Agency Excl.) $ (1,030.56)
Tickets $ 1,746.60
(less) Ticket Discount (Agency Excl.) $ (174.66)
Dining Plan Cost $ 607.44
Dining Tips $ 107.98
Dining Table Service OOP $ 320.02
Dining Quick Service OOP $ 86.26
Dining Snacks & Misc OOP $ 45.30
Souven'ears $ 235.47
Other MISC Costs $ 55.84
(less) Gas Savings To Date $ (316.00)
(less) Target Savings $ (160.00)
(less) Misc Gas Savings $ (125.00)
(less) Credit Card Signup Bonuses & Referrals $ (4,956.71)
DETAIL TOTAL $ 0.00
SUMMARY:
Flights $ 715.84
Hotel/Tickets $ 5,259.82
Dining $ 1,152.80
Other $ 305.51
GROSS COST $ 7,433.97
(less) Disney Discounts $ (1,205.22)
(less) Flight Points & Discounts $ (671.04)
(less) Hotel Points Redeemed $ -
(less) Credit Card Related Discounts $ (4,956.71)
(less) Oither/Misc Discounts $ (601.00)
TOTAL AMOUNT EXPENSED $ 0