tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 883408d1732029145-dynamic-drop-down-using-tables-testworkbook-alexhen-
Sheet: Job Summary

Job Number | Customer Number | Description | Cost Type | [NAME] | Fixed Price | Date | Invoiced | Invoice Date | Paid | Part Payment | Payment Date | Confirmation Email | Invoice Status | Materials | Labour | Total Estimate | Final Labour Cost | Final Invoice | Completion Status | Job Number with Details | Job Number Copy | Customer ID | Invoiceable
 | 100001 - Fred Head | Repair & Gravel Drive, Install Gates, [NAME] and Poly Tunnel. [NAME] | Estimate | Daily |  | 2024-10-05 00:00:00
 | 100002 - [NAME] | [NAME] and Install Shower | Quote | Fixed | 1500 | 2024-10-05 00:00:00 | Yes | 2024-10-15 00:00:00 |  |  |  | Sent
 | 100003 - Jim Thing | Fix mouse hole and repair small section of roof lining in car port. Remove and install customer supplied fence and gate | Estimate | Daily |  | 2024-10-10 00:00:00 | Yes | 2024-10-24 00:00:00 |  |  |  | Sent
 | 100004 - Jason Station | General [NAME] and fixes | Estimate | Daily |  | 2024-10-22 00:00:00 | Yes | 2024-10-31 00:00:00 |  |  |  | Sent
 | 100004 - Jason Station | General [NAME] and fixes | Estimate | Daily |  | 2024-11-01 00:00:00 | Yes | 2024-11-10 00:00:00
 | 100004 - Jason Station | General [NAME] and fixes | Estimate | Daily |  | 2024-11-11 00:00:00
Spreadsheet: 861539d1709411330-tracking-last-30-days-blood-readings
Sheet: Sheet3

Last 30 days |  |  |  |  |  |  |  |  |  | Correct values | Last 30 days
date | day | time | Sys | [NAME] | Pul | Sugar |  | Sheet to use | Days to subtract |  | date | day | time | Sys | [NAME] | Pul | Sugar
 |  |  |  |  |  |  |  |  | 29
 |  |  |  |  |  |  |  |  | 28
 |  |  |  |  |  |  |  |  | 27
 |  |  |  |  |  |  |  |  | 26
 |  |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  |  | 22
 |  |  |  |  |  |  |  |  | 21
 |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  | 19
 |  |  |  |  |  |  |  |  | 18
 |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  | 15
 |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | 0
Spreadsheet: 436cf0bd-bbfd-4313-9f30-1f5b3f661b8c
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
ACHS | Test | ACHS | Acetylcholinesterase, [NAME] | [NAME], RBC | Spectrophotometric-Thiocholine Production | EDTA (lavender-top) tube: EDTA |  |  | 4 | mL | [NAME] must arrive within 72 hours of draw.   Container/Tube: Lavender top (EDTA) [NAME]: 4 mL Additional Information: Date of draw is required. | 2.5 mL | Hemolysis	Mild reject; Gross reject Thawing	Warm reject; Cold reject Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | 31.2-61.3 U/g of hemoglobin | Tuesday, Friday; 10 a.m. | 4 days | 6 days | 1 | 82482 |  |  |  |  | Rochester
ACHS | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Refrigerated
ACHS | Result | ACHSR | [NAME], RBC | [NAME], RBC | Numeric |  |  |  |  | U/g Hb |  |  |  |  |  |  |  |  |  | 49230-6
Spreadsheet: 37420d1235436137-automatically-place-player-based-results-and-player-ranking-tree1
Sheet: Sheet1

Rank |  | Score | Rank
-1 | Sandra | 89 |  |  |  | Result Should be
 |  |  | -1 | Sandra |  | Sandra
-32 | [NAME] | 72
-2 | [NAME] | 63
 |  |  | -2 | [NAME] |  | [NAME]
-31 | [NAME] | -28
-3 | Martin | 57
 |  |  | -4 | Corinne |  | [NAME]
-30 | [NAME] | 68
-4 | Corinne | 70
 |  |  | -30 | [NAME] |  | Corinne
-29 | Stuart | -42
Spreadsheet: 810483d1671802026-autonumber-with-concatenate-issue-with-filter-ef_examp-1-
Sheet: Incoming Shipments

Status | Transport # | HOW IT SHOULD STAY | Supplier | CRD | CRDYEAR | ETD | ETA
 |  | USB-I2023-1 | ASM | 2023-01-30 00:00:00 |  |  | 2023-01-15 00:00:00
New |  | USB-I2023-7 | AZT | 2023-02-20 00:00:00 |  |  | 2023-01-15 00:00:00
 |  | USB-I2023-2 | CFI | 2023-02-01 00:00:00 |  |  | 2023-01-16 00:00:00
New |  | USB-I2023-3 | CHIY | 2023-02-06 00:00:00 |  |  | 2023-01-17 00:00:00
 |  | USB-I2023-4 | CFI | 2023-02-06 00:00:00 |  |  | 2023-01-17 00:00:00
 |  | USB-I2023-5 | COAL | 2023-02-10 00:00:00 |  |  | 2023-01-18 00:00:00
New |  | USB-I2023-6 | [NAME] | 2023-02-17 00:00:00 |  |  | 2023-01-20 00:00:00
New |  | USB-I2023-8 | [NAME] | 2023-02-28 00:00:00
 |  | USB-I2023-9 | SPA3 | 2023-03-06 00:00:00
 |  | USB-I2023-10 | SPA4 | 2023-03-06 00:00:00
 |  | USB-I2023-11 | [NAME] | 2023-03-06 00:00:00
 |  | USB-I2023-12 | [NAME] | 2023-03-10 00:00:00
New |  | USB-I2023-13 | SPA3 | 2023-03-15 00:00:00
New |  | USB-I2023-14 | CR_ | 2023-03-20 00:00:00
 |  |  |  | 2024-01-01 00:00:00
 |  |  |  | 2024-02-01 00:00:00
Spreadsheet: 49560d1248907779-help-with-conditional-formatting-of-a-spreadsheet-golf
Sheet: Sheet1

handicap |  |  | Hole | Name | white Yards | Par | [NAME] | Stroke index
6 |  |  | 1 | KILMARNOCK | 506 | 5 | 501 | 13
 |  |  | 2 | DUNCANS PRIDE | 394 | 4 | 376 | 5
 |  |  | 3 | AUCHENGATE | 425 | 4 | 365 | 3
 |  |  | 4 | ARRAN | 159 | 3 | 149 | 15
 |  |  | 5 | RAILWAY | 366 | 4 | 336 | 11
 |  |  | 6 | HILLHOUSE | 154 | 3 | 143 | 17
 |  |  | 7 | WESTERN | 439 | 4 | 427 | 1
 |  |  | 8 | DUNDONALD | 539 | 5 | 519 | 7
 |  |  | 9 | GAILES | 383 | 4 | 371 | 9
 |  |  |  | OUT | 3363 | 36 | 3187
 |  |  | 10 | NEWMOOR | 357 | 4 | 346 | 16
 |  |  | 11 | BRODICK | 396 | 4 | 383 | 8
 |  |  | 12 | BARASSIE | 439 | 4 | 387 | 2
 |  |  | 13 | BUTCHARTS | 377 | 4 | 355 | 14
 |  |  | 14 | CORRIE | 185 | 3 | 170 | 18
 |  |  | 15 | ADAMS GATE | 428 | 4 | 413 | 4
 |  |  | 16 | THE GAP | 490 | 5 | 475 | 12
 |  |  | 17 | WESTWARD | 406 | 4 | 401 | 6
 |  |  | 18 | FULLARTON | 370 | 4 | 365 | 10
 |  |  |  | IN | 3454 | 36 | 3297
 |  |  |  | TOTAL | 6817 | 72 | 6484
Spreadsheet: john_arnold__15179__SSDSTF Datatables 97 June 00
Sheet: Table 25

TABLE 25
USE A SEPARATE SHEET FOR METRO & COUNTY
EXISTING INDUSTRIAL SITE PROFILE
Identity | Name | Street | City | County | State | Zip
Building
Owner/Broker
Company
Contact
Site Characteristics Surrounding the Building
Zoning Classification
Acreage
Total Usable/Subdividable Acres
No. of [NAME] for Expansion
Soil Type
Soil Load Bearing Capacity (lbs. Per Sq. In.)
Topography
Elevation (Mean Ft. Above Sea Level)
Water table (Ft. Below Ground)
100 Year Floodplain (Yes or No)
% of Site in Wetlands
Phase One Environment Audit Complete (Yes or No)
Selling Price Per Acre
Transportation
[NAME]
Name
Two or Four Lane
Distance to Four Lane Highway
Internal Site Access
Mass Transit Service
Light Rail (Miles from Site)
Bus (Miles from Site)
Distance to Nearest Airport (Miles from Site)
Nearest Mass Transit Stop to Site
Rail Service (if applicable)
Carrier
Main or Branch Line
Spur Yes or No (If No, Distance to Rail Line)
Barge Facilities at Site if Applicable
Name of River, Lake, etc.
Channel Depth
Turning Basin
Storage Capabilities
Effective Property Tax Rate per $100 | Tax Rate ($)
Real Property Tax
City
County
School
Special District
Total
Personal Property Tax (Rate per $100)
City
County
School
Special District
Total
Water
Provider
Water Main
Size
Distance to Site
Static Pressure
Residual Pressure
Flow per Minute
Treatment Plant
Rated Capacity (mgd)
Peak Demand (mgd)
Booster Pump Required
On-site Storage
Elevated
Capacity in Gallons
Sewer
Provider
Sewer Main
Size
Distance from Site in Ft.
Use of Lift Required (Yes or No)
Treatment Plant
Type
Rated Capacity (mgd)
Peak Demand (mgd)
Storm Drainage System
Protective Services
Fire Insurance Class Rating
Fire Station Volunteer or Full-Time
Distance to Nearest Station
Fire
Police
24 Hour Police Patrol Provided
Electric Power
Service Provider
Service Voltage to Site/Building
Transmission Voltage
Distribution Voltage
Secondary Voltage
Power Quality
Total interruptions per year
Number of instantaneous delays
Total outage duration (hours/year)
Dual Feed Available from 1 Substation
Dual Feed Available from 2 Substations
Natural Gas
Provider
Gas Main
Size
Distance in Feet From Site
Gas Pressure
Heat Valve (BTU per Cubic Foot)
Telecommunications Service
Local Exchange Carrier
Nearest Central Office (C.O.)
Location
Distance in Miles
Switch
ADSL Available from C.O.
DSL Available from C.O.
Type (e.g., Analog or Digital)
C.O. on a Fiber Ring (Yes or No)
Dual Service Provided from Two Central Offices
Fiber Available (Yes or No)
ISDN Available from C.O.
Competitive Local Exchange Carrier Allowed to Serve Site
Points of Presence (POPs)
List All Major Long Distance Carriers
Closest Major [NAME] POPs
Location
Distance in Miles
Location of Building in a Classified Zone (Yes or No)
State Enterprise Zone
Enterprise Community
Empowerment Zone
Foreign Trade Zone
Specialized Local Zones
Summarize statutory incentives that could apply to a new occupant
Provide the following: still photograph, aerial photograph, building blueprint, topographic map, & a highway map for the site
Spreadsheet: 088698fb-d9c4-408d-915b-171fac99891b
Sheet: State 2014

Math
Level | Growth Percentile 14 |  |  | Catch-Up 14 |  | Keep-Up 14 |  | Move-Up 14
 | Total N | MGP | AGP | Total N | % | Total N | % | Total N | %
Total | 410244 | 50 | 61 | 160187 | 0.112 | 250057 | 0.624 | 141262 | 0.165
Elementary | 132992 | 50 | 48 | 36817 | 0.2016731401254855 | 96175 | 0.6396152846373798 | 55835 | 0.251
Middle | 166518 | 50 | 66 | 64614 | 0.1230383508218033 | 101904 | 0.5716753022452504 | 55302 | 0.155
High | 110734 | 50 | 87 | 58756 | 0.04271904145959562 | 51978 | 0.6957943745430759 | 30125 | 0.024
Reading
Level | Growth Percentile 14 |  |  | Catch-Up 14 |  | Keep-Up 14 |  | Move-Up 14
 | Total N | MGP | AGP | Total N | % | Total N | % | Total N | %
Total | 407549 | 50 | 27 | 119151 | 0.309 | 288398 | 0.807 | 257564 | 0.137
Elementary | 131441 | 51 | 31 | 37499 | 0.348649297314595 | 93942 | 0.7738924016946627 | 85974 | 0.202
Middle | 165726 | 50 | 28 | 47811 | 0.3126268013637029 | 117915 | 0.7793664928126192 | 101794 | 0.118
High | 110382 | 50 | 15 | 33841 | 0.2592417481752903 | 76541 | 0.8904639343619759 | 69796 | 0.084
Writing
Level | Growth Percentile 14 |  |  | Catch-Up 14 |  | Keep-Up 14 |  | Move-Up 14
 | Total N | MGP | AGP | Total N | % | Total N | % | Total N | %
Total | 407878 | 50 | 45 | 175228 | 0.26 | 232650 | 0.724 | 193037 | 0.181
Elementary | 131463 | 51 | 43 | 61224 | 0.3528028224225794 | 70239 | 0.7357308617719499 | 59498 | 0.272
Middle | 165945 | 50 | 47 | 66992 | 0.2494178409362312 | 98953 | 0.6851030287106 | 80309 | 0.173
High | 110470 | 50 | 47 | 47012 | 0.1527695056581298 | 63458 | 0.7719751646758486 | 53230 | 0.09
Spreadsheet: 846514d1697688357-excel-model-problem-using-if-and-and-sumifs-statements-rqd
Sheet: Sheet1

 | Fracture Start | Fracture End | Fracture length |  |  | CORE RUN START | CORE RUN END | RQD (%)
 | 7 | 7.08 | 0.02 |  |  | 7 | 8.4
 | 7.08 | 7.15 | 0.07 |  |  | 8.4 | 9.94
 | 7.15 | 7.22 | 0.07 |  |  | 9.94 | 11.46
 | 7.22 | 7.32 | 0.1 |  |  | 11.46 | 13
 | 7.32 | 7.36 | 0.04 |  |  | 13 | 14.41
 | 7.36 | 7.52 | 0.16 |  |  | 14.41 | 15.57
 | 7.52 | 7.8 | 0.28
 | 7.8 | 7.93 | 0.13
 | 7.93 | 8 | 0.07
 | 8 | 8.17 | 0.17
 | 8.17 | 8.4 | 0.23
 | 8.4 | 8.47 | 0.07
 | 8.47 | 8.54 | 0.07
 | 8.54 | 8.66 | 0.12
 | 8.66 | 8.81 | 0.15
 | 8.81 | 8.84 | 0.03
 | 8.84 | 9.06 | 0.22
 | 9.06 | 9.08 | 0.02
 | 9.08 | 9.32 | 0.24
 | 9.32 | 9.53 | 0.21
 | 9.53 | 9.56 | 0.02
 | 9.56 | 9.64 | 0.08
 | 9.64 | 9.68 | 0.04
 | 9.68 | 9.8 | 0.12
 | 9.8 | 10.07 | 0.27
 | 10.07 | 10.46 | 0.29
 | 10.46 | 10.63 | 0.17
 | 10.63 | 10.68 | 0.05
 | 10.68 | 10.77 | 0.05
 | 10.77 | 10.86 | 0.09
 | 10.86 | 10.9 | 0.04
 | 10.9 | 11.3 | 0.01
 | 11.3 | 11.35 | 0.02
 | 11.35 | 11.39 | 0.04
 | 11.39 | 11.42 | 0.03
 | 11.42 | 11.46 | 0.04
 | 11.46 | 11.56 | 0.1
 | 11.56 | 11.58 | 0.02
 | 11.58 | 11.63 | 0.05
 | 11.63 | 11.64 | 0.01
 | 11.64 | 11.66 | 0.02
 | 11.66 | 11.78 | 0.08
 | 11.78 | 11.8 | 0.02
 | 11.8 | 11.85 | 0.05
 | 11.85 | 11.91 | 0.06
 | 11.91 | 12.02 | 0.11
 | 12.02 | 12.045 | 0.03
 | 12.05 | 12.1 | 0.05
 | 12.1 | 12.12 | 0.02
 | 12.12 | 12.21 | 0.09
 | 12.21 | 12.28 | 0.07
 | 12.28 | 12.37 | 0.09
 | 12.37 | 12.45 | 0.08
 | 12.45 | 12.49 | 0.04
 | 12.49 | 12.52 | 0.03
 | 12.52 | 12.55 | 0.03
 | 12.55 | 12.58 | 0.03
 | 12.58 | 12.64 | 0.06
 | 12.64 | 12.68 | 0.04
 | 12.68 | 12.72 | 0.04
 | 12.72 | 12.74 | 0.02
 | 12.74 | 12.76 | 0.02
 | 12.76 | 12.81 | 0.05
 | 12.81 | 12.84 | 0.03
 | 12.84 | 12.88 | 0.04
 | 12.88 | 12.9 | 0.02
 | 12.9 | 12.95 | 0.05
 | 12.95 | 13.04 | 0.09
 | 13.04 | 13.09 | 0.05
 | 13.09 | 13.18 | 0.09
 | 13.18 | 13.19 | 0.01
 | 13.19 | 13.22 | 0.03
 | 13.22 | 13.24 | 0.01
 | 13.24 | 13.3 | 0.06
 | 13.3 | 13.41 | 0.11
 | 13.41 | 13.52 | 0.11
 | 13.52 | 13.61 | 0.09
 | 13.61 | 13.66 | 0.05
 | 13.66 | 13.7 | 0.04
 | 13.7 | 13.75 | 0.01
 | 13.75 | 13.79 | 0.04
 | 13.79 | 13.81 | 0.02
 | 13.81 | 13.91 | 0.02
 | 13.91 | 13.95 | 0.04
 | 13.95 | 13.97 | 0.02
 | 13.97 | 14.04 | 0.02
 | 14.04 | 14.14 | 0.1
 | 14.14 | 14.2 | 0.1
 | 14.2 | 14.41 | 0.21
 | 14.41 | 14.48 | 0.08
 | 14.48 | 14.54 | 0.06
 | 14.54 | 15 | 0.01
 | 15 | 15.07 | 0.01
 | 15.07 | 15.19 | 0.12
 | 15.19 | 15.22 | 0.03
 | 15.22 | 15.45 | 0.23
 | 15.45 | 15.57 | 0.12
Spreadsheet: 7b04996a-a8eb-4f11-ab60-278c6c365acd
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
CUCRU | Test | CUCRU | Copper/Creatinine Ratio, Random, [NAME] | Copper/Creat Ratio, Random, U | CUCR: Dynamic Reaction Cell-Inductively Coupled Plasma-Mass Spectrometry (DRC-ICP-MS) CDCR: Enzymatic Colorimetric Assay | Plastic urine container with no metal cap or glued insert |  |  | 3 | mL | Collection Container/Tube: Clean, plastic urine collection container Submission Container/Tube: Plastic, 10-mL urine tube (Supply T068) or a clean, plastic aliquot container with no metal cap or glued insert [NAME]: 3 mL Collection Instructions:  1. Collect a random urine specimen. 2. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. Additional Information: High concentrations of barium are known to interfere with most metals tests. If barium-containing contrast media has been administered, a specimen should not be collected for 96 hours. | 0.7 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | > or =16 years: 15-60 mcg/g Creatinine Reference values have not been established for patients that are <16 years of age. | Monday, Wednesday, Friday; 8 a.m.-11 a.m. | 1 day | 4 days |  | Profile |  |  |  |  | Rochester
CUCRU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
CUCRU | Component | CUCR | Copper/Creatinine Ratio, [NAME] | Copper/Creat Ratio, U | Only orderable as part of a profile. For further information see #60427 Copper/Creatinine Ratio, [NAME] |  |  |  |  |  | Only orderable as part of a profile. For further information see #60427 Copper/Creatinine Ratio, [NAME] |  |  | Only orderable as part of a profile. For further information see #60427 Copper/Creatinine Ratio, [NAME] |  |  |  | 1 | 82525 |  |  | Yes | No
CUCR | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
CUCR | Result | 32872 | Copper/Creat Ratio, U | Copper/Creat Ratio, U | Numeric |  |  |  |  | mcg/g |  |  |  |  |  |  |  |  |  | In Process
CUCR | Result | 32887 | Cu Concentration | Cu Concentration | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | In Process
CUCRU | Component | CDCR | [NAME] | [NAME] | Only orderable as part of a profile. For further information see CTU / Creatinine, [NAME]. |  |  |  | 5 | mL | Only orderable as part of a profile. For further information see CTU / Creatinine, [NAME]. |  |  |  |  |  |  |  |  |  |  | Yes | No
CDCR | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 30 days
CDCR | Result | CDCR | [NAME] | [NAME] | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 35674-1 | Creatinine:MCnc:XXX:[NAME]:Qn:
Spreadsheet: 834871d1688127299-function-that-gives-the-substring-between-spaces-before-the-last-space-in-the-string-s666-pq-function-that-gives-the-substring-between-spaces-before-the-last-space-in-the-string
Sheet: before

name |  |  |  | name | Result
Hello [NAME] | 8-9 2017 |  |  | Hello [NAME] | 8-9 2017
Hello [NAME] | 1-3 2017 |  |  | Hello [NAME] | 1-3 2017
Hello Inkoopfacturen 6-7 2017 | 6-7 2017 |  |  | Hello Inkoopfacturen 6-7 2017 | 6-7 2017
Hello Inkoopfacturen 10-12 2017 | etc. |  |  | Hello Inkoopfacturen 10-12 2017 | 10-12 2017
Hello Inkoopfacturen 10-12 2017 | etc. |  |  | Hello Inkoopfacturen 10-12 2017 | 10-12 2017
Hello Verkoopfacturen 3-4 2017 | etc. |  |  | Hello Verkoopfacturen 3-4 2017 | 3-4 2017
Hello Verkoopfacturen 3-4 2017 | etc. |  |  | Hello Verkoopfacturen 3-4 2017 | 3-4 2017
Hello Verkoopfacturen 8-9 2017 | etc. |  |  | Hello Verkoopfacturen 8-9 2017 | 8-9 2017
Hello Verkoopfacturen 8-9 2017 | etc. |  |  | Hello Verkoopfacturen 8-9 2017 | 8-9 2017
Hello [NAME] | etc. |  |  | Hello [NAME] | 1-2 2017
Hello [NAME] | etc. |  |  | Hello [NAME] | 1-2 2017
Hello Verkoopfacturen 6-7 2017 | etc. |  |  | Hello Verkoopfacturen 6-7 2017 | 6-7 2017
Hello Verkoopfacturen 6-7 2017 | etc. |  |  | Hello Verkoopfacturen 6-7 2017 | 6-7 2017
Spreadsheet: 9ce633d9-f0f4-4404-b501-30444dbbfe2d
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
260462 | 50838 | [NAME] | [NAME] | KOR | 101 | 00:17:11 | 00:00:00 | 00:31:30 | 00:00:00 | [NAME] | 1 | 01:21:34
Spreadsheet: 859618d1707940223-colour-coded-cells-with-formulas-formatting-dj
Sheet: All Data

XXXXX Details |  |  |  |  |  |  | assessment 1 |  |  | Assessment 2 |  |  | Assessment 3 |  |  | Assessment 4 |  |  | Assessment 5 |  |  |  | 2024-04-01 00:00:00 | 2025-03-31 00:00:00 | Fiscal Year
Ref3 | Name | Age | Sex | Ref4 | Ref5 | Status | Code ID | Date | Code Term | Code ID | Date | Code Term | Code ID | Date | Code Term | Code ID | Date | Code Term | Code ID | Date | Code Term
0001 | Name1 | 25 | M | unknow1 | Ref5 |  | AAAA | 2024-04-01 00:00:00 | asdasd | AAAA | 2024-04-01 00:00:00 | asdasd | AAAA | 2024-04-01 00:00:00 | asdasd | AAAA | 2024-04-01 00:00:00 | asdasd | AAAA | 2024-04-01 00:00:00 | asdasd
0002 | [NAME] | 26 | M | unknow2 | Ref5 |  | BBB | 2024-02-02 00:00:00 | sdfsdfgdgdf | BBB | 2024-05-02 00:00:00 | sdfsdfgdgdf | BBB | 2024-02-02 00:00:00 | sdfsdfgdgdf | BBB | 2024-02-02 00:00:00 | sdfsdfgdgdf | BBB | 2024-02-02 00:00:00 | sdfsdfgdgdf
0003 | Name3 | 27 | M | unknow3 | Ref5
0004 | Name4 | 28 | M | unknow4 | Ref5 |  |  |  |  | DDDDD | 2024-08-08 00:00:00 | dsfsdgdfghfgh | DDDDD | 2024-08-08 00:00:00 | dsfsdgdfghfgh | DDDDD | 2024-08-08 00:00:00 | dsfsdgdfghfgh | DDDDD | 2024-08-08 00:00:00 | dsfsdgdfghfgh
0005 | Name5 | 29 | M | unknow5 | Ref5 |  | EEEEE | 2024-07-09 00:00:00 | ffdgdfgsdfgsdfg | EEEEE | 2024-07-09 00:00:00 | ffdgdfgsdfgsdfg | EEEEE | 2024-07-09 00:00:00 | ffdgdfgsdfgsdfg | EEEEE | 2024-07-09 00:00:00 | ffdgdfgsdfgsdfg | EEEEE | 2024-07-09 00:00:00 | ffdgdfgsdfgsdfg
0006 | Name6 | 30 | M | unknow6 | Ref5 |  |  |  |  |  |  |  |  |  |  |  |  | rwerwr | rwer |  | rwer
0007 | Name7 | 31 | M | unknow7 | Ref5
0008 | Name8 | 32 | M | unknow8 | Ref5
0009 | Name9 | 33 | M | unknow9 | Ref5
0010 | Name10 | 34 | M | unknow10 | Ref5
Spreadsheet: richard_shapiro__32125__TRAssumptions&SIRESERatesCase
Sheet: NewCaseKeyRatios

TRSA Real Tariffs - $80MM Bond*
Key Financial Indicators
US$[NAME] |  |  |  | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010
Debt |  |  |  | 0.3345336203968394 | 0.3601307497871463 | 0.3989826595394888 | 0.4115765311007115 | 0.4044876968474757 | 0.3778138601995637 | 0.3511264102306355 | 0.3436308539876166 | 0.332355561270386 | 0.3166872849307137
Equity |  |  |  | 0.6654663796031606 | 0.6398692502128536 | 0.6010173404605111 | 0.5884234688992885 | 0.5955123031525242 | 0.6221861398004362 | 0.6488735897693646 | 0.6563691460123834 | 0.6676444387296139 | 0.6833127150692863
New Debt |  |  |  | 80 | 39.12108053431303 | 62.94323891508662 | 56.43986308281887 | 36.66702131694161 | 17.11953298713432 | 17.48964115019822 | 17.86815138178814 | 18.25526005195675 | 18.65116819555868
Cash Before Dividends |  |  |  | 15.95104450686665 | 36.47915734020663 | 48.50074318309623 | 60.03898275684143 | 86.3926362077212 | 100.8730715143503 | 99.72668417075536 | 105.0546446441682 | 102.9297052185482 | 98.95511914903659
Debt Service |  |  |  | 46.26208285247605 | 32.89882411531859 | 37.80271169245062 | 66.02418123355764 | 68.91685526621133 | 69.21201466267672 | 68.24405408367193 | 48.22741106441588 | 49.16727307940174 | 49.9990242492011
DCR |  |  |  | 0.9689591660270787 | 2.456412529515866 | 2.796456805639284 | 1.822508019718186 | 2.254468316609668 | 2.567183251636773 | 2.485841036116239 | 3.491588784552272 | 3.443352191227306 | 3.363042200509493
DSRA & Min Cash Balance |  |  |  | 10.17692836402567 | 13.9688745564149 | 29.33494013377354 | 33.26845826654254 | 34.9687414171384 | 34.60112129330072 | 24.70580872836538 | 25.29420496578428 | 25.82768687305953 | 26.30510637963235
Dividends & Cap Reductions |  |  |  | 5.774116142840982 | 22.51028278379174 | 19.16580304932269 | 26.77052449029889 | 51.42389479058279 | 66.27195022104961 | 75.02087544238998 | 79.76043967838393 | 77.10201834548869 | 72.65001276940423
EBITDA |  |  |  | 34.64914085538509 | 66.84420920679233 | 76.37871025019963 | 87.0611415269431 | 120.4021252609091 | 143.0788035607615 | 144.9380613837621 | 143.0960826147221 | 143.4725506215695 | 141.8437221547281
EBITDA/Interest |  |  |  | 2.641830046374477 | 3.964003835374356 | 3.889596518292898 | 3.738150385673113 | 4.840596008916822 | 5.892100199937205 | 6.709087608814828 | 7.216273221300576 | 7.558074886191073 | 7.88506503094086
Debt/EBITDA |  |  |  | 6.423680198275621 | 3.673773101336282 | 3.800415726977799 | 3.4914363199132 | 2.463278834820309 | 1.878452132981983 | 1.653171797805341 | 1.6008676772554 | 1.513519930346055 | 1.436719336531413
ROE |  |  |  | 0.02668829969977773 | 0.03684912278545663 | 0.04596933066715651 | 0.05543771493630342 | 0.1225134275717188 | 0.1631897501143453 | 0.1698404063251298 | 0.1703367233853546 | 0.173662793380076 | 0.1731827948107063
NIAT |  |  |  | 11.8163578972906 | 16.07808455591192 | 20.10039485604434 | 24.09201844925567 | 53.49544942609795 | 72.22885931401433 | 75.2035007587592 | 74.5328067353208 | 75.7540805529957 | 76.1510113439809
*Financing Assumption: Borrow for Capex