Spreadsheet: 34208d1231351214-linking-data-temp_excel_forum
Sheet: Trip Calculator

 | SHASTA
 |  |  |  |  |  | MARK WITH BED NUMBER |  |  |  |  |  |  |  | MARK "X" |  |  |  |  |  | MARK "X" |  | ENTER DATE / AMOUNT |  |  |  |  |  |  |  | PAYMENT 1 |  | PAYMENT 2 |  | PAYMENT 3 |  | PAYMENT 4
 | BOAT RENTAL | 9000 |  |  | GUEST NAME | SA 8/15 | SU 8/16 | MO 8/17 | TU 8/18 | WE 8/19 | TH 8/20 | FR 8/21 | DAYS | TOW | OVFL | COMP | TTL | PAID | DUE | PYMT PLAN | INV DATE | DATE | AMT | DATE | AMT | DATE | AMT | DATE | AMT | AMT | DATE / CK # | AMT | DATE / CK# | AMT | DATE / CK# | AMT | DATE / CK#
 | EST FUEL COST | 2000 |  | 1 | [NAME] | 1A | 1A | 1A | 1A | 1A | 1A | 1A | 7 |  |  |  | 700 | 0 | 700
 | EST FOOD COST | 2500 |  | 2 | [NAME] | 2A | 2A | 2A | 2A | 2A | 2A | 2A | 7 |  |  |  | 700 | 0 | 700
 | TOTAL TRIP COST | 13500 |  | 3 | [NAME] | 6A | 6A | 6A | 6A |  |  |  | 4 |  |  |  | 400 | 0 | 400
 | TOTAL BILLING NIGHTS | 7 |  | 4 | [NAME] | 9A | 9A | 9A | 9A |  |  |  | 4 |  |  |  | 400 | 0 | 400
 | TOTAL SLEEP AREAS | 20 |  | 5 | Sandy Hope |  |  |  |  | 9A | 9A | 9A | 3 |  |  |  | 300 | 0 | 300
 | TOTAL BILLING UNITS | 140 |  | 6 | [NAME] |  |  |  |  | 9B | 9B | 9B | 3 |  |  |  | 300 | 0 | 300
 | MINIMUM GUEST COST / NIGHT | 96.42857142857143 |  | 7 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0 | 0
 |  |  |  | 8 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0 | 0
 | COMITTED GUESTS | 2800 |  | 9 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0 | 0
 | OVERALL DEFICIT | 10700 |  | 10 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0 | 0
 | ACTUAL RECEIVED | 0 |  | 11 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0 | 0
 | BALANCE DUE | 10700 |  | 12 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0 | 0
 |  |  |  | 13 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0 | 0
 |  |  |  | 14 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0 | 0
 |  | 1 |  | 15 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0 | 0
 | TRIP GOAL | 0.2074074074074074 | 0.7925925925925926 | 16 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0 | 0
 | MONEY RECEIVED GOAL | 0 | 1 | 17 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0 | 0
 |  |  |  | 18 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0 | 0
 |  |  |  | 19 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0 | 0
 |  |  |  | 20 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0 | 0
 |  |  |  | 21 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0 | 0
 |  |  |  | 22 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0 | 0
 |  |  |  | 23 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0 | 0
 |  |  |  | 24 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0 | 0
 |  |  |  | 25 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0 | 0
 |  |  |  | 26 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0 | 0
 |  |  |  | 27 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0 | 0
 |  |  |  | 28 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0 | 0
 |  |  |  | 29 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0 | 0
 |  |  |  | 30 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0 | 0
 |  |  |  | 31 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0 | 0
 |  |  |  | 32 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0 | 0
 |  |  |  | 33 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0 | 0
 |  |  |  | 34 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0 | 0
 |  |  |  | 35 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0 | 0
 |  |  |  | 36 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0 | 0
 |  |  |  | 37 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0 | 0
 |  |  |  | 38 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0 | 0
 |  |  |  | 39 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0 | 0
 |  |  |  | 40 |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 | 0 | 0