Spreadsheet: 87858d1287717590-drop-down-menu-result-fills-cell-on-other-sheet-copy-of-test-1
Sheet: Sheet1

ID | Date | VIN | OID | BL # | Company | PU City | PU ST | DEL City | DEL ST | [NAME] | Hub Fee | Price Base | Total | Insurance | Total (After Insurance) | 25% Profit | 30% Profit | Money to Make Move @ 25% | Money to Make Move @ 30% | LABOR HOURS (Driver & Chase) | TOTAL | LABOR (Per Mile) | TRANSPORT | FUEL (Not first service, chase car only) | HOTEL | [NAME] | TOTAL EXPENSES | LOCAL EXPENSE PROFIT (OR LOSS) @ 25% | LOCAL EXPENSE PROFIT (OR LOSS) @ 30% | FINAL PROFIT (OR LOSS) | Driver Name | Per Mile | Per [NAME] | Labor Hours | Hourly Pay | Total [NAME] | TYPE | FIRST FUEL Date | FIRST FUEL City, State | FIRST FUEL Cost | FIRST FUEL Comments | TYPE | Date | City, State | Cost | Comments | TYPE | Date | City, State | Cost | Comments | TYPE | Date | City, State | Cost | Comments | TYPE | Date | City, State | Cost | Comments | TYPE | Date | City, State | Cost | Comments | TYPE | Date | City, State | Cost | Comments | TYPE | Date | City, State | Cost | Comments | TYPE | Date | City, State | Cost | Comments | TYPE | Date | City, State | Cost | Comments | TYPE | Date | City, State | Cost | Comments | TYPE | Date | City, State | Cost | Comments | TYPE | Date | City, State | Cost | Comments | TYPE | Date | City, State | Cost | Comments | TYPE | Date | City, State | Cost | Comments | TYPE | Date | City, State | Cost | Comments | TYPE | Date | City, State | Cost | Comments | TYPE | Date | City, State | Cost | Comments | TYPE | Date | City, State | Cost | Comments | TYPE | Date | City, State | Cost | Comments | TYPE | Date | City, State | Cost | Comments | TYPE | Date | City, State | Cost | Comments | TYPE | Date | City, State | Cost | Comments | TYPE | Date | City, State | Cost | Comments | TYPE | Date | City, State | Cost | Comments | IN TRANSIT TAG? | DMV WORK? | TOTAL REIMBURSABLE EXPENSES | TRANS. EXPENSES FOR FINAL PW
10-99999 | 2010-01-02 00:00:00 | [NAME] | 99999 | 03-99999 | ABC Company | Citytown | PA | Townville | NJ | 99 | 25 | 299 | 324 | 12.87 | 311.13 | 77.7825 | 93.339 | 233.3475 | 217.791 | 11 | 88 | 24.75 | 42 | 43 | 44 | 45 | 286.75 | -53.4025 | -68.959 | 24.38 | [NAME] | 0.25 | 24.75 | 11 | 88 | 112.75 | FUEL | 2014-01-02 00:00:00 | Cityville, PA | 46 | First Service | FUEL | 2014-01-03 00:00:00 | Cityopolis, NJ | 47 | Customer fuel | FUEL | 2014-01-04 00:00:00 | Towntown, PA | 48 | Customer fuel again | FUEL | 2014-01-05 00:00:00 | Metropolis, DE | 49 | More customer fuel | FUEL | 2014-01-06 00:00:00 | [NAME], ME | 50 | Trip Test | RENTAL | 2014-03-05 00:00:00 | Frederick, MD | 51 | First House | TOLLS | 2014-02-04 00:00:00 | Grover, OH | 52 | [NAME] | FUEL | 2014-06-15 00:00:00 | Trevose, DE | 53 | [NAME] | FUEL | 2014-12-13 00:00:00 | Outer Banks, NC | 54 | Your Sign Here | FUEL | 2014-11-10 00:00:00 | Mound, MN | 55 | [NAME] | FUEL | 2014-09-25 00:00:00 | Reading, PA | 56 | War Time | FUEL | 2014-05-18 00:00:00 | Queensland, WA | 57 | Poetry Time | FLIGHT | 2014-03-24 00:00:00 | Nantucket, MA | 58 | Swear Off Sweets | RENTAL | 2014-06-21 00:00:00 | Greenville, PA | 59 | Your Ad Here | MISC | 2014-11-12 00:00:00 | Village, NY | 60 | Deer Bump | MISC | 2014-05-01 00:00:00 | Virginia City, MD | 67 | Group Discount | MISC | 2014-12-20 00:00:00 | Phoenix, AZ | 68 | Long trip home | MISC | 2014-11-10 00:00:00 | Reston, VA | 69 | Deal with it | MISC | 2014-05-22 00:00:00 | Las Vegas, NV | 70 | When does it work | MISC | 2014-04-27 00:00:00 | [NAME], SD | 71 | House broken | MISC | 2014-09-01 00:00:00 | Voodoo, LA | 72 | Kick the ball | MISC | 2014-12-29 00:00:00 | Green Lane, PA | 73 | Freedom | FLIGHT | 2014-11-19 00:00:00 | Britainville, MO | 74 | Dead end road | MISC | 2014-12-13 00:00:00 | Frost bitten mirror | 75 | Count the tires | MISC | 2014-11-30 00:00:00 | Kiln, MS | 76 | As the world turns | No | No | #N/A | #N/A