Spreadsheet: 166686d1341721147-seeking-guidance-to-find-max-and-min-from-a-table-summary-sheet-tafe-test
Sheet: Summary

 | Rathdowney Park Sporting Association
 | First Name | Last Name | Status | Level | [NAME] | Hotel Rate Type | Airfare Type | Airfare Return ($) | Bus Rental | Spending Money | Registration Fees | Accomodation(max) | Accomodation (min) | Adv Total Trip Max | Adv Total Trip Min | Trip Total(max) | Total Trip (Min)
 | Peta | Smith | Player | Masters | Y | Discount | [NAME] |  |  | 400
 | [NAME] | [NAME] | Player | Masters | Y | Discount | [NAME] |  |  | 400
 | Alana | [NAME] | Player | Masters | Y | Discount | [NAME] |  |  | 400
 | [NAME] | Salmon | Player | Masters | Y | Discount | [NAME] |  |  | 400
 | [NAME] | Brink | Player | Masters | N | Standard | Normal |  |  | 400
 | Lesley | Perers | Player | Masters | N | Standard | Normal |  |  | 400
 | [NAME] | Choi | Player | Masters | Y | Discount | [NAME] |  |  | 400
 | [NAME] | Orman | Player | Masters | Y | Discount | [NAME] |  |  | 400
 | [NAME] | Mason | Player | Masters | Y | Discount | [NAME] |  |  | 400
 | [NAME] | Strong | Player | Masters | N | Standard | Normal |  |  | 400
 | Mikaela | Gallagher | Player | Masters | N | Standard | Normal |  |  | 400
 | Samantha | Brooke | Player | Masters | Y | Discount | [NAME] |  |  | 400
 | Rachel | [NAME] | Player | Masters | Y | Discount | [NAME] |  |  | 400
 | [NAME] | [NAME] | Player | Masters | Y | Discount | [NAME] |  |  | 400
 | [NAME] | Richards | Player | Masters | Y | Discount | [NAME] |  |  | 400
 | [NAME] | Orman | Player | Masters | Y | Discount | [NAME] |  |  | 400
 | Philipa | [NAME] | Player | Masters | N | Standard | Normal |  |  | 400
 | Jade | Falcon | Player | Masters | N | Standard | Normal |  |  | 400
 | [NAME] | Daly | Player | Masters | Y | Discount | [NAME] |  |  | 400
 | [NAME] | Plum | Player | Masters | N | Standard | Normal |  |  | 400
 | Louia | March | Player | Masters | Y | Discount | [NAME] |  |  | 400
 | [NAME] | [NAME] | Medical Staff | Masters | Y | Discount | [NAME] |  |  | 400
 | Mitra | McMoan | Medical Staff | Masters | N | Standard | Normal |  |  | 400
 | Bradley | Moonie | Medical Staff | Masters | Y | Discount | [NAME] |  |  | 400
 | [NAME] | Franklin | Coach | Masters | Y | Discount | [NAME] |  |  | 400
 | Julie | Moore | Coach | Masters | Y | Discount | [NAME] |  |  | 400
 | [NAME] | Smith | Accom Person | Masters | Y | Discount | [NAME] |  |  | 400
 | Harvey | Jones | Accom Person | Masters | Y | Discount | [NAME] |  |  | 400
 | [NAME] | Place | Accom Person | Masters | Y | Discount | [NAME] |  |  | 400
 | [NAME] | Way | Accom Person | Masters | N | Standard | Normal |  |  | 400
 | [NAME] | Pearce | Accom Person | Masters | N | Standard | Normal |  |  | 400
 | [NAME] | Betts | Accom Person | Masters | N | Standard | Normal |  |  | 400
 | [NAME] | Bow | Accom Person | Masters | Y | Discount | [NAME] |  |  | 400
 | Flight Fare totals |  |  | Hotel | Standard Rate |  | Discount | Discount Rate |  | Participant Totals |  |  | Financial Assistance for Players
 | [NAME] | Normal |  | Best Western | 75 |  | 0.05 | 71.25 |  | Players | Non Players |  | First Name | Last Name | Status | [NAME] | Min Trip Cost
 | 300 | 450 |  | Hilton | 80 |  | N/A | 80
 |  |  |  | Holiday Inn | 100 |  | 0.05 | 95
 |  |  |  | Hyatt | 120 |  | 0.15 | 102
 |  |  |  | Marriott | 100 |  | 0.2 | 80
 |  |  |  | Ramada Inn | 115 |  | 0.1 | 103.5
 |  |  |  | Sheraton | 95 |  | N/A | 95