tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 2c411ba6-c4c5-45d1-9bd5-1f0d731b06e9
Sheet: Sheet1

SCHOOL DISTRICT NAME | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | DAILY ROUTE SHEET | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16
Vehicle PreTrip Inspection Report
Revised 7/11/06
BUS # _____  FOR WEEK ENDING ___________________  DRIVER SIGNATURE _______________________________
Directions:
Place a         in box if item is okay |  |  | MONDAY |  |  | TUESDAY |  |  | WEDNESDAY |  |  | THURSDAY |  |  | FRIDAY
Place a "X" in box for deficient item |  |  | AM | PM |  | AM | PM |  | AM | PM |  | AM | PM |  | AM | PM
Under Hood | 1) | Coolant Level
 | 2) | Crankcase Oil Level
 | 3) | Belts & Hoses (tight / no leaks)
 | 4) | Check For Fluid Leaks
Inside | 5) | Driver's Seat & Seat Belt
 | 6) | Passenger Seats
 | 7) | Instrument Panel Gauges
 | 8) | Indicators - High/Low Beam
 | 9) | Indicators - Turn Signals
 | 10) | Horn
 | 11) | Service Brakes
 | 12) | Parking Brakes
 | 13) | Low Air Pressure Warnings
 | 14) | Windshield Wipers & Washers
 | 15) | Heaters & Defrosters
 | 16) | Dome, Stepwell & Dash Lights
 | 17) | [NAME] / Pressure
 | 18) | Triangles & First Aid Kit
 | 19) | Body Fluids [NAME]
 | 20) | Seat Belt Webbing Cutter
 | 21) | Two Way Communication Sys
 | 22) | Emergency Exits & Alarms
 | 23) | Service Door
 | 24) | Overhead Mirror
Outside | 25) | Mirrors - Crossover & Side
 | 26) | Crossing Gate
 | 27) | Front Tires & Wheels (left & right)
 | 28) | Front Turn Signals (left & right)
 | 29) | Headlights (high & low beams)
 | 30) | Amber Warning Lights (front & rear)
 | 31) | Red Warning Lights (front & rear)
 | 32) | Stop Arm & Lights
 | 33) | Strobe Light
 | 34) | [NAME] (front & rear)
 | 35) | ID Lights (left & right)
 | 36) | Rear Tires & Wheels (left & right)
 | 37) | Rear Turn Signals (left & right)
 | 38) | Tail & Brake Lights (left & right)
 | 39) | [NAME] (left & right)
 | 40) | Windshield & Windows
 | 41) | Exhaust System
 | 42) | Mud Flaps
Other | 43) | Engine Operating Properly
 | 44) | Miscellaneous
Post-Trip | 45) | Post-Trip / No Child Left Behind
Weekly |  | ODOMETER READINGS | Daily
 |  | RETURN
 |  | DEPARTURE
 |  | TOTAL [NAME]
 |  | LESS ACTIVITY MILES
 |  | LESS SPECIAL NEEDS MILES
 |  | TOTAL [NAME]
 |  | FUEL (gallons)
COMMENTS:
Spreadsheet: 58541d1258761036-one-cell-depending-on-a-lot-of-variables-acquisition
Sheet: Year 2

Total provision paid so far: |  |  | 0
Turnover | 2500 | 3000 | 3500 | 4000 | 4500 | 5000 | 5500 | 6000 | 6500 | 7000
Employees | -300 | -300 | -300 | -300 | -300 | -300 | -300 | -300 | -300 | -300
Provision | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
End result
Spreadsheet: michelle_lokay__26750__imball0112
Sheet: Amoco Abo

 | [NAME] |  | Amoco Abo fuel del
Day | Measured | Scheduled | Measured | Scheduled | Imbal
1 | 12873 | 10932
2 | 13275 | 10932
3 | 15491 | 10932 | -1
4 | 14090 | 10932 | -2
5 | 14451 | 10932 | -6
6 | 13027 | 10932 | -56
7 | 11185 | 10932 | -97
8 | 10651 | 10866 | -111
9 | 10898 | 10932 | -36
10 | 11139 | 10932 | -13
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  |  |  | 392389.58
2001-12-10 00:00:00
CBS Volume
 |  |  | -260608
Spreadsheet: 782581d1654145568-how-do-i-do-this-filter-forlmula-with-multiple-criteria-test-budget-aligw
Sheet: Sheet1

CODE | Description | QTY | Units | Price Per Unit | Total | Allowance
800 | Demo | 1 | EA | 15 |  | Allowance
900 | Install | 2 | SF | 16 |  | Allowance
1100 | Decking | 3 | SF | 17 |  | 0
1500 | Fence | 4 | SF | 18 |  | Allowance
1800 | [NAME]. | 5 | SF | 19 |  | 0
1900 | lumber | 0 | LS | 20 |  | Allowance
2100 | forms | 0 | LS | 21 |  | 0
2200 | Concrete | 8 | CY | 22 |  | 0
GOAL(Allowance)
 | Description | Total | Allowance
 | Demo | 15 | Allowance
900 | Install | 32 | Allowance
1500 | Fence | 72 | Allowance
GOAL (General)
 | Description | Total | Allowance
 | Decking | 51 | 0
1800 | [NAME]. | 95 | 0
2200 | Concrete | 176 | 0
Spreadsheet: 85345d1285353167-sum-calculations-for-university-datah2
Sheet: T6

year | country | gold reserve
1970 | Belgium | 42.01
1970 | Canada | 22.59
1970 | France | 100.91
1970 | Italy | 82.48
1970 | Japan | 15.22
1970 | Netherlands | 51.06
1970 | Switzerland | 78.03
1970 | U.K. | 38.52
1970 | U.S.A. | 316.34
1975 | Belgium | 42.17
1975 | Canada | 21.95
1975 | France | 100.93
1975 | Italy | 82.48
1975 | Japan | 21.11
1975 | Netherlands | 54.33
1975 | Switzerland | 83.2
1975 | U.K. | 21.03
1975 | U.S.A. | 274.71
1980 | Belgium | 34.18
1980 | Canada | 20.98
1980 | France | 81.85
1980 | Italy | 66.67
1980 | Japan | 24.23
1980 | Netherlands | 43.94
1980 | Switzerland | 83.28
1980 | U.K. | 18.84
1980 | U.S.A. | 264.32
1985 | Belgium | 34.18
1985 | Canada | 20.11
1985 | France | 81.85
1985 | Italy | 66.67
1985 | Japan | 24.33
1985 | Netherlands | 43.94
1985 | Switzerland | 83.28
1985 | U.K. | 19.03
1985 | U.S.A. | 262.65
1990 | Belgium | 30.23
1990 | Canada | 14.76
1990 | France | 81.85
1990 | Italy | 66.67
1990 | Japan | 24.23
1990 | Netherlands | 43.94
1990 | Switzerland | 83.28
1990 | U.K. | 18.94
1990 | U.S.A. | 261.91
Spreadsheet: 848753d1699389253-count-matches-of-two-arrays-based-on-criteria-excel-help-forum-2-updated-
Sheet: Sheet1

ARRAY 1 |  |  | ARRAY 2
Date | Customer |  | Date | Customer
2019-01-02 00:00:00 | EFG |  | 2019-01-04 00:00:00 | ABC
2020-03-02 00:00:00 | CDE |  | 2022-05-02 00:00:00 | CDE
2019-01-01 00:00:00 | EFG |  | 2019-01-03 00:00:00 | EFG
2021-01-01 00:00:00 | ABC |  | 2020-04-03 00:00:00 | CDE
Desired output:
Year | Matches
2019 | 1
2020 | 1
2021 | 0
Spreadsheet: 75250d1275835945-excel-2007-circular-reference-develop-a-tournament-revisionjune2010
Sheet: Players

Grade | Player Name | Rank | [NAME] | Win % | Matches | Wins | Loses | Infractions | Win Points | [NAME] | Highest Points | Floor | Modifier | Team
 | Aether
 | Archideas
 | Armoxus
 | Ashkon
 | Atma1
 | Aveot
 | Bakuhatsu
 | Benji617
 | BerserkChip
 | BEYNd
 | Bloodsword83
 | CGInvasion
 | [NAME]
 | Demitel
 | Draec
 | EVA
 | Funky
 | g-regulate
 | Hallabaloo4
 | Hard_KAW
 | Haruhiist
 | icyie04
 | JMRV
 | Judah01
 | K´Genesis
 | Kiego
 | Kraid
 | Light_x_Darkness
 | Lindaru
 | Lycoris
 | Melveys
 | Meoark
 | Miller483
 | Moomba
 | [NAME]
 | Nexus
 | [NAME]
 | PaperMoonLily
 | Pinkanemone
 | Pokefan362
 | Prox1mately
 | RDF2050
 | Rebellion
 | Rei-N
 | [NAME]
 | rijerk
 | RoboDestroyer
 | Sd1ad
 | Shadow
 | [NAME]
 | Skyler246
 | Slayer0
 | Spyder
 | Squall
 | Stupid Aquarius
 | Suppi
 | taintedkey
 | the-clown
 | thelastalchemist
 | [NAME]
 | ValkyrieWing
 | Veysey
 | Vyse
 | Wedge
 | Weiss_Hikari
 | WhiteHowl
 | windragon122
 | xffixbmlx
Spreadsheet: 7cf1bb57-f5bb-4a8b-99e3-af77653a7fe6
Sheet: 1d. Questionnaire (cont)

ANNUAL REPORT FOR THE PERIOD ENDED: |  |  |  |  |  |  | p. 1d
QUESTIONNAIRE (continued)
25. | If the Company is writing direct worker's compensation business, please confirm it is only being assumed or written on a deductible reimbursement basis.
 | If no, please explain below:
26.1 | If the Captive has any loan-backs on their books, please provide the information for each loan-back in the table below*.  If the Captive has no loan-backs, check here and skip the remainder of question #26:
 | Amount |  | Type | Term | Interest Rate | Date Approved
 |  |  | --> This amount should tie to the assets page
 | *If additional space is needed, please attach on a separate sheet of paper.
26.2 | Have any payments been made on each loan during the year according to its terms?
 | Amount of Loan |  | Amount Paid Against Principal | Amount Paid Against Interest
26.3 | Was SCDOI approval received for each loanback shown above? |  |  |  |  | If no, please explain:
26.4 | For companies that have loan-backs, please indicate if the parent's financial statements are available online.                            If yes, please provide company's web address.  If they are not available online, please submit an electronic copy of the parent company's annual report when finalized.
27. | Is there any additional information not previously disclosed that could have a material impact on the
 | Company's financials?
 | If yes, please describe:
Spreadsheet: 726408d1617213275-power-pivot-measure-to-sum-unpivoted-values-inquiry1
Sheet: Data 1

Month | ID | Employee | Earnings | Bonus | Tax
January | 1 | Alp | 1000
January |  | Bet | 500
January |  | Cio | 750
January |  | Del | 250
January |  | Eps | 100
January |  | Fal | 360
January |  | Guy | 333
January |  | Hyz | 555
January |  | Isa | 666
January |  | [NAME] | 777
Spreadsheet: 586881d1534706474-basketball-table-and-best-second-places-womens-eb-qualifier-tables
Sheet: GroupC

GROUP C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GP | W | D | L | GF | GA | [NAME] | PTS | rank
Team name | Bonus/penalty points
Russia
Hungary
Lithuania
Albania
ROUND 1 |  |  |  |  |  |  | Table
 |  |  | :
 |  | 78 | : | 76 |  |  |  | GP | W | D | L | GF | GA | [NAME] | PTS
 |  | 148 | : | 35
 |  |  | :
 |  | 61 | : | 119
 |  | 137 | : | 48
ROUND 2
 |  | 64 | : | 71
 |  | 70 | : | 73
 |  | 37 | : | 122
 |  | 64 | : | 62
 |  |  | :
 |  |  | :
ROUND 3
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
ROUND 4
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
Spreadsheet: 850212d1700582773-interval-staffing-formula-not-working-correctly-when-shifts-cross-midnight-interval-template-jadams169-
Sheet: Staff by Hour

 |  |  |  | Within a day | Over midnight
 |  |  |  | Staff | Pre midnight | Post midnight
 | 00:00:00
 | 01:00:00
 | 02:00:00
 | 03:00:00
 | 04:00:00
 | 05:00:00
 | 06:00:00
 | 07:00:00
 | 08:00:00
 | 09:00:00
 | 10:00:00
 | 11:00:00
 | 12:00:00
 | 13:00:00
 | 14:00:00
 | 15:00:00
 | 16:00:00
 | 17:00:00
 | 18:00:00
 | 19:00:00
 | 20:00:00
 | 21:00:00
 | 22:00:00
 | 23:00:00
Spreadsheet: 857049d1706131433-determining-the-number-of-working-days-in-a-week-book1
Sheet: Sheet1

Month | Week | Days | Holidays
2024-01-01 00:00:00 |  | 4 | 2023-12-25 00:00:00
 | 2 | 5 | 2023-12-26 00:00:00
 | 3 | 5 | 2024-01-01 00:00:00
 | 4 | 5 | 2024-12-25 00:00:00
 | 5 | 3 | 2024-12-26 00:00:00
 |  |  | 2025-01-01 00:00:00
Spreadsheet: 217649d1362141675-ranking-without-duplicates-forum-upload-2
Sheet: Sheet1

 | CUSTOMER |  | CATEGORY | TOTAL CATEGORY SALES 6m | PRODUCT GROUP | TOTAL GROUP SALES 6m
 | FD01 |  | CHAP | 8341.580000000002 | T-SHIRT | 59039.68999999997
 | RANK | PRODUCT CODE | [NAME] | [NAME] | COLOUR | SIZE | TOTAL UNITS SOLD | TOTAL SALES | % Of GROUP
 | 1 | CHR-JKT-0021 | [NAME] | Storm Cobra | Black | M | 11 | 939.78
 | 2 | CHR-HDY-0002 | [NAME] | Cobra 100% Merino Wool | Black | M | 10 | 850
 | 3 | CHR-JKT-0022 | [NAME] | Storm Cobra | Black | L | 6 | 534
 | 4 | CHR-JKT-0031 | [NAME] | [NAME] | Military Green | M | 7 | 392.8
 | 5 | CHR-JKT-0032 | [NAME] | [NAME] | Military Green | L | 8 | 472
 | 6 | CHR-JKT-0021 | [NAME] | Storm Cobra | Black | M | 11 | 939.78
 | 7 | CHR-HDY-0001 | [NAME] | Cobra 100% Merino Wool | Black | S | 6 | 510
 | 8 | CHR-HDY-0003 | [NAME] | Cobra 100% Merino Wool | Black | L | 7 | 589.9
 | 9 | CHR-JKT-0020 | [NAME] | Storm Cobra | Black | S | 6 | 538
 | 10 | CHR-JKT-0020 | [NAME] | Storm Cobra | Black | S | 6 | 538
 | 1 | THR-TEE-0152 | Skate [NAME] | 0 | Black | L | 147 | 1433.3
 | 2 | THR-TEE-0153 | Skate [NAME] | 0 | Black | XL | 52 | 509.3
 | 3 | THR-TEE-0157 | Skate [NAME] | 0 | White | L | 119 | 1148.14
 | 4 | THR-TEE-0158 | Skate [NAME] | 0 | White | XL | 48 | 469.4
 | 5 | REA-TEE-0190 | Real T Shirt | [NAME] | White | L | 90 | 934.3
 | 6 | REA-TEE-0194 | Real T Shirt | OFWGKTA Fergolfson | [NAME] | L | 49 | 523.66
 | 7 | THR-TEE-0151 | Skate [NAME] | 0 | Black | M | 152 | 1470.7
 | 8 | THR-TEE-0156 | Skate [NAME] | 0 | White | M | 138 | 1330.4
 | 9 | REA-TEE-0189 | Real T Shirt | [NAME] | White | M | 108 | 1083.12
 | 10 | THR-TEE-0418 | Skate [NAME] | 0 | Grey/Red | L | 51 | 490.2
Spreadsheet: 529891d1501058086-statutory-redundancy-pay-out-uk-statutory-redundancy-payout
Sheet: Sheet2

 | STATUTORY REDUNDANCY PAYOUT
 | Name | Date of Birth | [NAME] | In Service | Annual Pay | Stat Weekly Rate | Redundancy Effective Date | Location Redundancy  Payment | Completed Year of Service | Qualification Based on Min. Year of Service | Subject to [NAME]. [NAME] |  | Weeks' Pay Entitlement | Computed Payout | Actual Entitlement |  | Minimum Year of Service |  |  | [NAME] |  |  |  |  | Week's Pay Entitlement
 |  |  |  |  |  |  |  |  |  |  | Year of Service | Weekly Pay |  |  |  |  | Location | Year of Service |  | Location | Year of Service | Weekly Pay | Payout |  | Age Group | Age Factor | Week's Pay
 | O | 1960-02-18 00:00:00 | 57 | 32 | 22260 | 428 | 2016-12-31 00:00:00 | England |  |  |  |  |  |  |  |  | England | 2 |  | England | 20 | 489 | 14670 |  | Under 22 | 0 | 0.5
 | P | 1956-05-24 00:00:00 | 61 | 27 | 22382 | 430 | 2016-12-31 00:00:00 | Northern Ireland |  |  |  |  |  |  |  |  | Northern Ireland | 2 |  | Northern Ireland | 20 | 500 | 15000 |  | 22 to 40 | 22 | 1
 | Q | 1962-12-21 00:00:00 | 54 | 27 | 22740 | 437 | 2016-12-31 00:00:00 | Northern Ireland |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41 or older | 41 | 1.5
 | R | 1964-08-19 00:00:00 | 52 | 32 | 23090 | 444 | 2016-12-31 00:00:00 | Northern Ireland
 | S | 1959-10-27 00:00:00 | 57 | 32 | 23304 | 448 | 2016-12-31 00:00:00 | England
 | T | 1963-05-30 00:00:00 | 54 | 38 | 29740 | 572 | 2016-12-31 00:00:00 | England |  |  |  |  |  |  |  |  | https://www.gov.uk/redundant-your-rights/redundancy-pay |  |  | https://www.gov.uk/redundant-your-rights/redundancy-pay
 | U | 1963-11-08 00:00:00 | 53 | 30 | 30000 | 577 | 2016-12-31 00:00:00 | England
 | V | 1959-02-03 00:00:00 | 58 | 37 | 30210 | 581 | 2016-12-31 00:00:00 | England
 | W | 1962-03-03 00:00:00 | 55 | 32 | 30220 | 581 | 2016-12-31 00:00:00 | England
 | X | 1963-07-14 00:00:00 | 53 | 35 | 30250 | 582 | 2016-12-31 00:00:00 | England
 | Y | 1969-05-10 00:00:00 | 48 | 27 | 31270 | 601 | 2016-12-31 00:00:00 | England
 | Z | 1968-11-27 00:00:00 | 48 | 30 | 31290 | 602 | 2016-12-31 00:00:00 | Northern Ireland
Spreadsheet: 5311ea95-11f7-4c83-a707-b67f765d2ea1
Sheet: Mandate Summary

AFV MANDATE SUMMARY
Energy Independence and Security Act of 2007 |  |  |  |  | Energy Policy Act 1992/2005 (EPAct)
Acquire only low-GHG-emitting vehicles (with certain exceptions) |  |  |  |  | Acquire 75 percent of light-duty vehicles (LDVs) as [NAME] (AFVs) in metropolitan statistical areas (MSAs)
Low GHG vehicles qualify as an AFV when the alternative fuel is unavailable
 |  |  |  |  | Use alternative fuels when available and reasonably priced
The Grams Per Mile (GPM) level will be set so that [approx.] 25% of cars and LD trucks will be considered low GHG emitting each model year. This applies to all cars, LD trucks, and Medium Duty Passenger Vehicles. |  |  |  |  | o    The alternative fuel required for use in the vehicle is not reasonably available (within a 5 mile or 15 minute drive of the vehicles' garaged location) as certified to the Secretary by the head of the agency
 |  |  |  | 21FA
 |  |  |  | 21FA | o    The cost of the alternative fuel required for use in the vehicle is unreasonably more expensive compared to a gallon of gasoline as certified to the Secretary by the head of the agency
Medium Duty Passenger Vehicles (MDPVs) are defined as:
GVWR greater than 8,500 lbs. but less than 10,000 lbs
Designed to transport less than 12 passengers or less than 9 passengers rearward of the driver’s seat |  |  |  |  | Executive Order 13423
 |  |  |  |  | Increase alternative fuel consumption by 159.4 percent (10 percent annually over the previous year) by 2015, from a 2005 baseline
Not equipped with an open cargo area of 72 inches in interior length or more
 |  |  |  |  | Use plug-in hybrids when commercially available at a lifecycle cost reasonably comparable to non plug-in hybrid vehicles
MY 2013 EISA 141 Compliance Thresholds
(maximum grams/mile CO2 emissions)
Passenger Cars | 330 g/mile |  |  |  | Executive Order 13514
Light-Duty Trucks, MDPVs | 415 g/mile
FFV Passenger Cars* | 375 g/mile on E85 |  |  |  | Reduce petroleum consumption by 30 percent (2 percent annually) by 2020, from a 2005 baseline
FFV Light-Duty Trucks* | 460 g/mile on E85
Presidential Memorandum – Federal Fleet Performance |  |  |  |  | Optimize number of vehicles in fleet
By December 31st 2015 all new light duty vehicles leased or purchased by agencies must be alternative fueled vehicles.
Agency alternative fueled vehicles must, as soon as practicable, be located in proximity to an alternative fuel source and use the designated alternative fuel.
Executive fleets are required to be comprised of midsize or smaller sedans (unless larger sedans are mission essential) and limit engine size and additional options to only what is mission essential.
Spreadsheet: 212520d1360157717-need-help-auto-generate-columns-stafprofile
Sheet: sex

Name | Sex
Spreadsheet: 848204d1698975630-formula-to-determine-if-a-text-ar-to-be-added-sample-1
Sheet: Sheet1

 |  |  | S/No | Date | CAR Number | Expected Result | [NAME] |  | S/No | Imp Date | CAR Number
 |  |  | 1 | 2023-10-01 00:00:00 | 7 | 07 |  |  | 1 | 2023-11-03 00:00:00 | 9
 |  |  | 2 | 2023-10-02 00:00:00 | T7 | 07 |  |  | 2 | 2023-11-03 00:00:00 | 7
 |  |  | 3 | 2023-10-15 00:00:00 | 7 | 07 |  |  | 2 | 2023-11-03 00:00:00 | T7
 |  |  | 4 | 2023-11-03 00:00:00 | 7 | 07 AR |  |  | 1 | 2023-11-03 00:00:00 | T9
 |  |  | 5 | 2023-11-03 00:00:00 | T7 | 07 AR
 |  |  | 6 | 2023-10-07 00:00:00 | 9 | 09
 |  |  | 7 | 2023-10-04 00:00:00 | T9 | 09
 |  |  | 8 | 2023-11-05 00:00:00 | T10 | 10
Spreadsheet: 154172d1336272214-time-calculations-with-tagged-wording-time-calc-table
Sheet: Sheet1

 |  | CW
 | Name | Hours |  | CW | CC | DP | CP |  |  |  |  |  |  | All Times Ordered Highest to Lowest.
 | [NAME] | 08:45:56 |  | 1900-01-01 00:00:00 | 00:00:05 | 00:00:10 | 00:00:15 |  | CW | CC | DP | CP
 |  | 07:56:34 |  |  |  |  |  |  | 08:45:56 | 08:45:39 | 08:23:42 | 08:25:27
 |  |  |  |  |  |  |  |  | 07:56:34 | 06:35:01 | 07:12:33 | 00:00:15
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 00:00:05 | 00:00:10 | 00:00:15
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 00:00:05 | 00:00:10 | 00:00:15
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 00:00:05 | 00:00:10 | 00:00:15
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 00:00:05 | 00:00:10 | 00:00:15
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 00:00:05 | 00:00:10 | 00:00:15
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 00:00:05 | 00:00:10 | 00:00:15
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 00:00:05 | 00:00:10 | 00:00:15
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 00:00:05 | 00:00:10 | 00:00:15
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 00:00:05 | 00:00:10 | 00:00:15
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 00:00:05 | 00:00:10 | 00:00:15
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 00:00:05 | 00:00:10 | 00:00:15
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 00:00:05 | 00:00:10 | 00:00:15
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 00:00:05 | 00:00:10 | 00:00:15
 |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 00:00:05 | 00:00:10 | 00:00:15
 |  | CC
 |  | 08:45:34
 |  | 06:34:56
 |  | DP
 |  | 08:23:32
 |  | 07:12:23
 |  | CP
 |  | 08:25:12
Spreadsheet: 0712472e-267f-479b-a916-9373f1d9ec37
Sheet: Sheet1

1908 - 3rd Coupe Aéronautique [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Starting Point: Schmargendorf, Berlin, Germany |  |  |  |  |  |  | 1908-10-11 00:00:00
 |  | Pilots Name |  | Co-Pilots Name
Rank | Country | Last | First | Last | First | BalloonName | LandingPlace | Distance km | Time
1 | SUI | Schaeck | Col. Theodor | Messner | Emil | Helvetia | Bergset/Norway | 1190 | 1900-01-03 01:01:00
2 | GBR | Dunville | [NAME] | Pollock | C.F. | Banshee | Hviddig/Hadersleben/ Germany | 428.75 | 1900-01-01 12:53:00
3 | BEL | Geerts | Georges | Peeters |  | Belgica | Wiegboldsburg/Aurich/ Germany | 413 | 1900-01-01 10:34:00
4 | FRA | Faure | [NAME] | Dubonnet | Emile | Le Condor | Laurup/Tondern/Denmark | 379 | 1900-01-01 12:16:00
5 | FRA | Carton | Emile | Baraloux | Marcel | [NAME] | Garding/Garlstedt | 361.75 | 1900-01-01 13:12:00
6 | FRA | Leblanc | Alfred | Delebecque | J. | Ile de France | [NAME] station | 361.25 | 1900-01-01 10:18:00
7 | ITA | Cianetti | Ettore | [NAME] | Giovanni | Aetos | Osternburg/Oldenburg/ Germany | 348 | 1900-01-01 06:59:00
8 | SUI | Beauclair | [NAME] | Biehly | H. | Cognac | Kappel-Neufelde/Lehe/Germany | 347.64 | 1900-01-01 05:24:00
9 | GER | Erbslöh | [NAME] | Sticker | (Ref.) J. | Berlin | Kappel-Neufelde/Lehe/Germany | 347.5 | 1900-01-01 09:34:00
10 | GER | Abercron | Capt. [NAME] | Goltzheim | Stach von | [NAME] | Mulsum/Germany | 341 | 1900-01-01 06:24:00
11 | ITA | [NAME] | Celestino | Borsalino | Mario | Ruwenzori | Sandstedt/Oldenburg/ Germany | 334 | 1900-01-01 05:25:00
12 | BEL | Broukere | [NAME] | Bussche | [NAME] | L'Utopie | Edendorf/North-Sea-Coast/ Germany | 333 | 1900-01-01 05:09:00
13 | SPA | [NAME] | Capt. [NAME] | Horga | [NAME] | [NAME] | Bremen-Parade ground/Germany | 310 | 1900-01-01 04:12:00
14 | ITA | Frassinetti | Capt. Romeo | Cobianchi | [NAME] | Basiliola | Nord-Zeven/Bremervörde/ Germany | 293 | 22:30:00
15 | GBR | Brewer | Griffith | McClean | [NAME] | Britannia | Ahausen/Hannover/ Germany | 275 | 1900-01-01 05:01:00
16 | USA | McCoy | [NAME] | Fogmann | (Lt.) | America II | [NAME] | 205.5 | 1900-01-01 07:58:00
17 | SPA | Herrera y Sotolongo |  |  |  | Montanes | Meitzendorf/Saxony/ Germany | 121.5 | 1900-01-01 06:43:00
18 | GBR | Huntingdon | Prof. [NAME] | Brabazon | Lt. Claude | Zephyr | Schricke/Germany | 118 | 20:10:00
19 | BEL | Everarts |  | Jacobs | (Adv.) | Ville de Bruxelles | Golzow/Zauch/Germany | 52.5 | 10:13:00
20 | GER | Niemeyer | Dr. [NAME] | [NAME] | Hans | Busley | North Sea | no res. | 1900-01-01 13:49:00
21 | SPA | Montojo | Juan | Romero de Vejade | [NAME] | Castilla | North Sea | no res. | [NAME]
22 | USA | [NAME] | [NAME] | [NAME] | [NAME] | St.Louis | North Sea | no res. | ~30:00
23 | USA | Forbes | [NAME] | Post | Augustus | Conqueror | burst and fallen after launch | no res. | 00:05:00
Spreadsheet: 229223d1366329378-make-unique-list-from-a-list-without-duplicates-but-hold-cell-and-pull-corresponding-dates-unique-list
Sheet: Setup (Expected Results)

ID |  | Dates | Notes
[NAME] | sum of all jack entries | 2011-03-02 00:00:00 | sick
 |  | 2011-03-08 00:00:00 | suspension
 |  | 2013-03-14 00:00:00 | fighting
 |  | 2013-04-13 00:00:00 | hitting
 |  | 2013-04-13 00:00:00 | spitting
 |  | 2013-02-14 00:00:00 | talking back
 |  | 2012-12-25 00:00:00 | sick
 |  | 2013-04-20 00:00:00 | no car
[NAME] | sum of jill | 2011-03-04 00:00:00 | funeral
 |  | 2011-03-08 00:00:00 | detention
 |  | 2013-01-01 00:00:00 | doctors appointment
 |  | 2013-04-02 00:00:00 | sick
[NAME] | 1 | 2011-03-07 00:00:00 | nurse
[NAME] | 2 | 2011-03-07 00:00:00 | late
 |  | 2012-03-09 00:00:00 | lunch group
Bee | 2 | 2011-03-08 00:00:00 | no homework
 |  | 2013-02-14 00:00:00 | no homework
[NAME] |  | 2012-03-09 00:00:00 | loss of recess
Nicole |  | 2012-03-09 00:00:00 | quiet space
Amanda |  | 2012-03-09 00:00:00 | rough housing