tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 653763eb-604d-4d2e-b686-17eeb9425a43
Sheet: Concerns

What happened in AY 2003?
Rept/EP | Low at 12 and 24 month valuations
 | Exposures | Check exposure growth
 |  |  | 7.7% increase in exposures.
 | Paid & Rept | Lower paid and reported at these periods is strange.
 | Counts |  | Change in systems processing?
 | Counts & Avgs |  | Unusually good loss experience?
 |  |  |  | Both down 25% from prior AY
What happened in AY 2004?
Rept/EP | Large after 24 months
 | Premium | Check premium growth
 | Premium | Spike in earned premium (and exposures)
 | Paid | Larger spike in paid losses
 | Reported | Huge spike in reported losses
 |  |  | What is driving this?
 | Severity |  |  | Large loss activity?
 | Counts |  |  | More claim counts?
 | Rsv/Open |  |  | Change in reserve adequacy at [NAME] valuation?
 | Rept'd Count |  | Reported count change 03 to 04 at 12:
 |  |  | Closed count change 03 to 04 at 12:
 |  |  | Reported claim change 03 to 04 at 12:
 |  |  | Reported count change 03 to 04 at 24: |  |  |  |  |  | Why are claims increasing so much more
 |  |  | Closed count change 03 to 04 at 24: |  |  |  |  |  | than the number of claims?  Could it be
 |  |  | Reported claim change 03 to 04 at 24: |  |  |  |  |  | due to large losses?
What happened in AY 2005 and 2006?
 | Reported losses are unusually high at 12 months.
 | Exposures also increasing between 2004 and 2005
 |  | 2004-2005 | 2004-2006
 | Exposures
 | Reported
 |  | Tort Reform?
 | Reported |  | Observe 24 month valuation
 | Paid |  | Higher reported and paid
 | Dropping levels of exposures, reported, and paids after 2005.
Spreadsheet: 21ac86b7-65e0-4e71-bfd1-b4199f3b705c
Sheet: form Request For Funds

 |  | Texas Science, Technology, Engineering, and
 |  | Mathematics (T-STEM) Challenge Scholarship Program
 |  | 2013
 |  | Request for Funds
 | Prior to receiving the full award amount, by October 1, 2013, Awarded Applicant for T-STEM 2013 shall submit to Texas Higher Education Coordinating Board (THECB) an updated list of number of scholarship recipients for fall 2013, together with an updated budget (Request for Application, bullet 14, “Payment for Services”).
 | Name of Institution:
 | T-STEM Program Director
 | Name:
 | Title:
 | Phone:
 | [NAME]:
 | Individual certifying and submitting the Request for Funds information
 | Name:
 | Title:
 | Department:
 | Phone:
 | [NAME]:
 | NOTE: | The spread sheet is populated with example data.
 |  | Please overwrite example data with institution's data.
 |  | Cells containing formulas are shaded grey and should not be changed.
 | Number of students that received a T-STEM Scholarship in fall 2013:
 | CIP Code | Instructional Program Name |  | Number of Students
 | 11 | Computer and Information Sciences and Support Services |  | 30
 | 14 | Engineering |  | 50
 | 15 | Engineering Technologies/Technicians |  | 60
 | 26 | Biological Sciences
 | 27 | Mathematics and Statics
 | 40 | Physical Sciences
 | 30.01 | Multi/Interdisciplinary Studies, Biological and Physical Sciences
 | 51 | Health Services/Allied health/Health Sciences, General
 | 51.06 | Dental Support Services and Allied Professions
 | 51.08 | Allied health and Medical Assisting Services |  | 20
 | 51.09 | Allied Health Diagnostic, Intervention, and Treatment Professions |  | 10
 | 51.1 | Clinical/Medical laboratory Science/Research and Allied Health Professions
 | 51.11 | Health/Medical Preparatory Programs
 | 51.18 | Ophthalmic and Optometric Support Services and Allied Professions
 | 51.23 | Rehabilitation and Therapeutic Professions
 |  |  | sum:
 | Budget:
 |  | Institution's T-STEM 2013 [NAME] (total): |  | 500000
 | n
 |  | Administration for T-STEM 2013: |  | 24000
 |  | additional line itmes as necessary
 |  | additional line itmes as necessary
 |  | Scholarship Funds Accrued for Fall 2013: |  | 212500
 | 175 | Scholarship Funds Estimated Spring 2014: |  | 218750
 | 35 | Scholarship Funds Estimated Summer 2014: |  | 43750
 |  |  | sum:
 |  | Subtract Fist Installment of Funds Received:
 |  | Requested Funds for 2nd Installment: | sum:
 |  | Expected Total Expenditures:
 | Budget Justification:
 | (Describe issues that may have caused the budget to be off-target.)
 | Matching funds:
 | (List any matching funds the institution expended on this project.)
 |  | additional line itmes as necessary
 |  | additional line itmes as necessary
 |  | additional line itmes as necessary
 |  |  | sum:
Spreadsheet: andy_zipper__243__Global_Prod 6-4-01 EM
Sheet: New on 6-4-01 - LTD

New Global Products made available on
that were not available Life to Date
Global Product Short Desc.
Ethylene Swap    ICIS FD NWE             Q3 2002         EUR/mt
EUR Plastic Swap HDPE F ICIS Ger         Oct01-Mar02     DEM/kg
EUR Plastic Swap HDPE F ICIS Ger         Oct01-Sep02     DEM/kg
EUR Plastic Swap LDPE F ICIS Ger         Oct01-Mar02     DEM/kg
EUR Plastic Swap LDPE F ICIS Ger         Oct01-Sep02     DEM/kg
EUR Plastic Swap LLDPE ICIS Ger          Oct01-Mar02     DEM/kg
EUR Plastic Swap LLDPE ICIS Ger          Oct01-Sep02     DEM/kg
EUR Plastic Swap PP Inj ICIS Ger         Oct01-Mar02     DEM/kg
EUR Plastic Swap PP Inj ICIS Ger         Oct01-Sep02     DEM/kg
EUR Plastic Swap PS GP ICIS Ger          Oct01-Mar02     DEM/kg
EUR Plastic Swap PS GP ICIS Ger          Oct01-Sep02     DEM/kg
For Curr Exch    Forward                 06Jun01         JPY/USD
For Curr Exch    Forward                 06Jun01         USD/EUR
For Curr Exch    Forward                 06Jun01         USD/GBP
For Curr LME     LME (Spot)              06Jun01         JPY/USD
For Curr LME     LME (Spot)              06Jun01         USD/EUR
For Curr LME     LME (Spot)              06Jun01         USD/GBP
Foreign Currency Reuters BOFC            04Jun01         CAD/USD
Foreign Currency Reuters BOFC            31Jul01         CAD/USD
[NAME]11-15Jun01      USD/mt
[NAME]                15Aug01v3Mth    USD/mt-L
[NAME]                18Jul01v15Aug01 USD/mt-L
[NAME]                18Jul01v3Mth    USD/mt-L
[NAME]                20Jun01v18Jul01 USD/mt-L
[NAME]                20Jun01v3Mth    USD/mt-L
[NAME]
[NAME]       USD/mt-L
Propane FOB Swap BPAP                    Jul01           USD/mt
Propane FOB Swap Sonatrach               Jul01           USD/mt
[NAME]   ICIS FD NWE             Q3 2002         EUR/mt
SG Dub Time Spd  Platts                  Q4 01 v Q1 02   USD/bl/m
SG Dubai Swap    Platts                  Q1 2002         USD/bl/m
SG E-W FO Diff   Platts                  01-30Jul01      USD/mt/m
SG E-W FO Diff   Platts                  Jul01           USD/mt/m
SG GO-Dub Crk    Platts                  01-30Jul01      USD/bbl
Spreadsheet: 599240d1542919278-conditional-formatting-for-gant-chart-based-on-start-date-end-date-status-book1-8-
Sheet: Macro Planning

Task Id Jira | Start Date | End Date | Status | 2018-11-22 00:00:00 | 2018-11-23 00:00:00 | 2018-11-24 00:00:00 | 2018-11-25 00:00:00 | 2018-11-26 00:00:00 | 2018-11-27 00:00:00 | 2018-11-28 00:00:00 | 2018-11-29 00:00:00 | 2018-11-30 00:00:00 | 2018-12-01 00:00:00 | 2018-12-02 00:00:00 | 2018-12-03 00:00:00 | 2018-12-04 00:00:00 | 2018-12-05 00:00:00 | 2018-12-06 00:00:00 | 2018-12-07 00:00:00 | 2018-12-08 00:00:00 | 2018-12-09 00:00:00 | 2018-12-10 00:00:00 | 2018-12-11 00:00:00 | 2018-12-12 00:00:00 | 2018-12-13 00:00:00 | 2018-12-14 00:00:00 | 2018-12-15 00:00:00 | 2018-12-16 00:00:00 | 2018-12-17 00:00:00 | 2018-12-18 00:00:00 | 2018-12-19 00:00:00 | 2018-12-20 00:00:00 | 2018-12-21 00:00:00 | 2018-12-22 00:00:00 | 2018-12-23 00:00:00 | 2018-12-24 00:00:00 | 2018-12-25 00:00:00 | 2018-12-26 00:00:00 | 2018-12-27 00:00:00 | 2018-12-28 00:00:00 | 2018-12-29 00:00:00 | 2018-12-30 00:00:00 | 2018-12-31 00:00:00 | 2019-01-01 00:00:00
 | 2018-11-25 00:00:00 | 2018-11-28 00:00:00 | Done
 | 2018-12-22 00:00:00 | 2018-12-24 00:00:00 | WIP
 | 2018-11-20 00:00:00 | 2018-11-24 00:00:00 | Not Started
 | 2018-11-22 00:00:00 | 2018-11-27 00:00:00 | Blocked
Task Id Jira | Start Date | End Date | Duration
Task Id Jira | Start Date | End Date | Duration
Task Id Jira | Start Date | End Date | Duration
Task Id Jira | Start Date | End Date | Duration
Task Id Jira | Start Date | End Date | Duration
Task Id Jira | Start Date | End Date | Duration
Task Id Jira | Start Date | End Date | Duration
Task Id Jira | Start Date | End Date | Duration
Task Id Jira | Start Date | End Date | Duration
Blocked | Done | WIP % | Blocked % | Done %
Spreadsheet: 827472d1682706171-count-only-dates-in-a-range-book1
Sheet: Sheet1

User:  [NAME] John
01/16/2023
01/17/2023
01/18/2023
01/19/2023
01/20/2023
01/23/2023
01/24/2023
01/25/2023
01/26/2023
01/27/2023
01/29/2023
01/30/2023
01/31/2023
02/03/2023
02/04/2023
02/05/2023
02/06/2023
02/07/2023
02/10/2023
02/11/2023
02/12/2023
02/13/2023
02/14/2023
02/17/2023
02/18/2023
02/19/2023
02/20/2023
02/21/2023
02/24/2023
02/25/2023
02/26/2023
Printed: 4/28/2023 1:32:34 PM
02/27/2023
03/01/2023
03/03/2023
03/04/2023
03/05/2023
03/06/2023
03/08/2023
03/09/2023
03/10/2023
03/12/2023
03/13/2023
03/15/2023
03/16/2023
03/17/2023
03/19/2023
03/20/2023
03/22/2023
03/23/2023
03/24/2023
03/26/2023
03/27/2023
03/29/2023
03/30/2023
03/31/2023
04/02/2023
04/03/2023
04/05/2023
04/06/2023
04/07/2023
04/09/2023
04/10/2023
04/11/2023
04/13/2023
04/14/2023
Printed: 4/28/2023 1:32:34 PM
04/16/2023
04/17/2023
04/18/2023
04/20/2023
04/21/2023
04/23/2023
04/25/2023
04/27/2023
04/28/2023
Subtotal:
Grand Total:
Printed: 4/28/2023 1:32:34 PM
Spreadsheet: 888653d1739222042-change-format-of-data-diabetes-27-apr-2017-to-23-april-2018
Sheet: Table 18

00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
 |  |  |  |  | 7.1 |  | 6.3
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Sat 9 Sep Glucose mmol/L
 |  |  |  |  | 6.3
Sun 10 Sep Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Mon 11 Sep Glucose mmol/L
 |  |  |  |  | 6.9
Tue 12 Sep Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Wed 13 Sep Glucose mmol/L
 |  |  |  |  |  | 6.1
Thu 14 Sep Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Fri 15 Sep Glucose mmol/L
 |  |  |  |  | 5.9
Legend          High Glucose (>13.3)            Low Glucose (<3.9)
Sat 16 Sep Glucose mmol/L
Spreadsheet: 870825d1717263687-how-do-i-calculate-data-from-various-excel-sheets-sample-data1
Sheet: table_2

TABLE 2
Nr | Data col.1 | Data col.2 | Data col.3 | Data col.4
1 |  | 2001 | 10.2 | x1
2 | s | 2002 | 10.5 | s2
3 |  | 2003 | 10.8 | x2
4 | dd | 2004 | 11.1 | s3
5 | d | 2005 | 11.4 | [NAME]
6 | d | 2006 | 11.7 | s4
7 |  | 2007 | 12 | x4
8 | d | 2008 | 12.3 | s5
9 | aas | 2009 | 12.6 | x5
10 |  | 2010 | 12.9 | s6
11 | mbn | 2011 | 13.2 | x6
12 | nbbnc | 2012 | 13.5 | s7
13 |  | 2013 | 13.8 | x7
14 |  | 2014 | 14.1 | s8
15 | hh | 2015 | 14.4 | [NAME]
16 | j | 2016 | 14.7 | s9
17 | f | 2017 | 15 | x9
18 |  | 2018 | 15.3 | s10
19 | s | 2019 | 15.6 | x10
20 | u | 2020 | 15.9 | s11
21 | u | 2021 | 16.2 | x11
22 | j | 2022 | 16.5 | s12
23 | sadas | 2023 | 16.8 | x12
24 |  | 2024 | 17.1 | s13
25 | fjhdfh | 2025 | 17.4
26 | fghdf | 2026 | 17.7
27 | dasd | 2027 | 18
28 | fh | 2028 | 18.3
29 | lj | 2029 | 18.6
30 | k | 2030 | 18.9
Spreadsheet: 788444d1658480852-calculating-a-total-referencing-data-in-different-worksheets-cl-geodata-v3-1-
Sheet: Project2Data

Name | First name | Surname | Nickname / other name | Phone | Mobile | [NAME] | Website | Address line 1 | Postcode | LSOA
 |  |  |  |  |  |  |  | Flat 2, Building 137-145 | BS15 1BH
 |  |  |  |  |  |  |  | 17a Crown Road | BS15 1PP
 |  |  |  |  |  |  |  | 73 Downend Road | BS15 1SN
 |  |  |  |  |  |  |  | 72 Downend Road | BS15 1SP
 |  |  |  |  |  |  |  | 72 Downend Road | BS15 1SP
 |  |  |  |  |  |  |  |  | BS15 1SW
 |  |  |  |  |  |  |  |  | BS15 1UE
 |  |  |  |  |  |  |  | 16 [NAME] | BS15 1UQ
 |  |  |  |  |  |  |  | 16 [NAME] | BS15 1UQ
 |  |  |  |  |  |  |  | 14 North Park | BS15 1UW
 |  |  |  |  |  |  |  |  | BS15 1XX
 |  |  |  |  |  |  |  | 23 Henderson Road | BS15 3AB
 |  |  |  |  |  |  |  | 62 [NAME] | BS15 3BT
 |  |  |  |  |  |  |  | 10 [NAME] | BS15 3FN
 |  |  |  |  |  |  |  | 75 Kingswood High Street | BS15 4AD
 |  |  |  |  |  |  |  | 71A Hollyguest Road | BS15 9NQ
 |  |  |  |  |  |  |  | 21 Bredon Close | BS15 9PG
 |  |  |  |  |  |  |  |  | BS15 9PZ
 |  |  |  |  |  |  |  | 71 Bellevue Road | BS15 9QQ
 |  |  |  |  |  |  |  | 44 Glanville Gardens | BS15 9WU
 |  |  |  |  |  |  |  |  | BS30 5DT
 |  |  |  |  |  |  |  | 21 Kennilworth Drive | BS30 6DZ
 |  |  |  |  |  |  |  | 21 Kenilworth Drive | BS30 6DZ
 |  |  |  |  |  |  |  | 122b Bath Road | BS30 6HS
 |  |  |  |  |  |  |  |  | BS30 6JR
 |  |  |  |  |  |  |  | East Barn | BS30 6NY
 |  |  |  |  |  |  |  | 12 Stibbs Court | BS30 7DH
 |  |  |  |  |  |  |  | 2 Isleys Court | BS30 7DR
 |  |  |  |  |  |  |  | 6 Tanner Close | BS30 7XF
 |  |  |  |  |  |  |  | 12 Worles Close | BS30 8XD
Spreadsheet: 274514d1383139740-unknown-check-digit-calculation-15th-digit-calculation-worksheet-wip-
Sheet: Sheet1

 |  | 14 digit number to convert |  |  | Doubled
 |  | 99000185792376 | 1
 |  |  | 2
 |  |  | 3
 |  |  | 4
 |  |  | 5
 |  |  | 6 |  |  |  |  |  |  |  |  |  | 15 Digit # Result
 |  |  | 7
 |  |  | 8
 |  |  | 9
 |  |  | 10
 |  |  | 11
 |  |  | 12
 |  |  | 13
 |  |  | 14
Spreadsheet: 153250d1335826525-auto-sort-values-drawn-from-a-vlookup-table-into-ascending-order-sortingexample1
Sheet: Sort

 | X | Y
NJ
Hou
[NAME]
Chi
Cha
NJ
Ind
Phi
Mil
SA
[NAME]
NO
Tor
Orl
LAL
[NAME]
Por
Chi
NY
Spreadsheet: adc087fc-3285-4f17-ac19-c22fd6a803b6
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 |  | U.S. Census Bureau
 |  | Source: Quarterly Summary of State & Local Taxes
 |  | Table 1 - Latest National Totals of State and Local Tax Revenue: U.S. Total
 |  | Not Seasonally Adjusted Total Taxes [Millions of Dollars]
 |  | Period: 1992 to 2012
 |  | Data Extracted on: December 9, 2013 (10:25 am)
Period | Value
Q1-1992 | 135822
Q2-1992 | 144154
Q3-1992 | 130322
Q4-1992 | 158733
Q1-1993 | 144699
Q2-1993 | 150412
Q3-1993 | 139186
Q4-1993 | 159318
Q1-1994 | 154049
Q2-1994 | 151821
Q3-1994 | 142333
Q4-1994 | 167533
Q1-1995 | 157896
Q2-1995 | 161701
Q3-1995 | 149534
Q4-1995 | 178442
Q1-1996 | 170544
Q2-1996 | 175449
Q3-1996 | 161924
Q4-1996 | 188453
Q1-1997 | 180444
Q2-1997 | 186031
Q3-1997 | 170327
Q4-1997 | 197603
Q1-1998 | 190315
Q2-1998 | 202369
Q3-1998 | 174161
Q4-1998 | 207206
Q1-1999 | 196889
Q2-1999 | 208627
Q3-1999 | 183337
Q4-1999 | 223852
Q1-2000 | 215048
Q2-2000 | 230440
Q3-2000 | 192487
Q4-2000 | 237412
Q1-2001 | 222853
Q2-2001 | 235918
Q3-2001 | 195374
Q4-2001 | 240101
Q1-2002 | 221818
Q2-2002 | 230568
Q3-2002 | 200908
Q4-2002 | 250397
Q1-2003 | 227915
Q2-2003 | 229583
Q3-2003 | 218266
Q4-2003 | 268473
Q1-2004 | 245894
Q2-2004 | 253143
Q3-2004 | 230688
Q4-2004 | 295676
Q1-2005 | 268565
Q2-2005 | 289080
Q3-2005 | 251878
Q4-2005 | 320314
Q1-2006 | 289134
Q2-2006 | 316468
Q3-2006 | 263937
Q4-2006 | 340479
Q1-2007 | 305855
Q2-2007 | 336925
Q3-2007 | 273650
Q4-2007 | 358394
Q1-2008 | 311635
Q2-2008 | 351774
Q3-2008 | 285686
Q4-2008 | 370456
Q1-2009 | 305960
Q2-2009 | 314608
Q3-2009 | 271984
Q4-2009 | 372468
Q1-2010 | 306065
Q2-2010 | 321866
Q3-2010 | 283595
Q4-2010 | 377885
Q1-2011 | 321058
Q2-2011 | 344093
Q3-2011 | 283865
Q4-2011 | 386260
Q1-2012 | 327726
Q2-2012 | 356703
Q3-2012 | 300257
Q4-2012 | 398510
Spreadsheet: darrell_schoolcraft__7825__imbalsumm0109
Sheet: Conoco

 | Maljamar |  | Zia |  |  |  |  |  |  |  |  | Avg
Day | Measured | Scheduled | Measured | Scheduled |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
1 | 28554 | 33234 | 33359 | 35317
2 | 15625 | 16488 | 35760 | 37983 |  |  | 2001-03-01 00:00:00 |  |  |  | 4.98
3 | 28573 | 29845 | 33221 | 34952 |  |  | 2001-04-01 00:00:00 |  |  |  | 4.87
4 | 25755 | 30000 | 32149 | 33000 |  |  | 2001-05-01 00:00:00 |  |  |  | 3.82
5 | 28748 | 27000 | 29943 | 29000 |  |  | 2001-06-01 00:00:00 |  |  |  | 3.2
6 | 29619 | 28499 | 29027 | 27500 |  |  | 2001-07-01 00:00:00 |  |  |  | 2.77
7 | 30828 | 25000 | 31950 | 30999
8 | 30687 | 23000 | 32614 | 32999
9 | 29910 | 23000 | 32422 | 32999
10 | 27830 | 23000 | 31900 | 32999
11 | 29936 | 23000 | 31208 | 32999
12 | 31245 | 23000 | 33726 | 32999
13 | 30688 | 26000 | 30941 | 29999
14 | 29277 | 25889 | 32687 | 29870
15 | 30223 | 26000 | 34303 | 29999
16 | 30657 | 26000 | 33809 | 29999
17 | 30100 | 26000 | 33967 | 29999
18 | 30272 | 26000 | 35296 | 29999
19 | 31177 | 26000 | 33887 | 29999
20 | 27639 | 20000 | 32416 | 35999
21 | 27837 | 28000 | 31306 | 35000
22 | 29096 | 28000 | 32998 | 35000
23 | 24426 | 28000 | 31774 | 35000
24
25
26
27
28
29
30
31
2001-08-31 00:00:00 |  | 441786.89 |  | 100794.76
2001-09-23 00:00:00
CBS Volume
Spreadsheet: 32987d1229183071-get-a-second-large-second-large-1
Sheet: Sheet1

 |  | Mark | Group |  | This allows you to enter a Group filter in G6. You can copy down the red formulas forever.
 |  | 13 | C
 |  | 14 | B |  |  | Group | Rank
 |  | 22 | A |  |  | A | 26 | [NAME]
 |  | 21 | A |  |  |  | 22 | 2nd
 |  | 26 | A |  |  |  | 21 | 3rd
 |  | 16 | B |  |  |  | 0 | 4th
 |  | 24 | B |  |  |  | 0 | 5th
 |  | 18 | B
 |  | 11 | C
 |  | 26 | A
Spreadsheet: 45649d1244464241-grabbing-data-from-a-cell-on-another-worksheet-if-workbook_fault_example-1-
Sheet: Day 2

Holding | Sort | Security | Price
10000 | 1 | UNITED KINGDOM(GOVERNMENT OF) 4% STK 07/03/2009 GBP100 | 100
2000 | 2 | ELECTRIC & GENERAL INV TST PLC ORD GBP0.05 | 350
350 | 3 | MONKS INVESTMENT TRUST ORD GBP0.05 | 25
4000 | 6 | Pearson PLC | 400
5000 | 1 | UNITED KINGDOM(GOVERNMENT OF) 4% STK 07/03/2009 GBP100 | 2000
1000 | 2 | ELECTRIC & GENERAL INV TST PLC ORD GBP0.05 | 550
Spreadsheet: 18f4d953-0744-4f98-a8b5-4f020db9520b
Sheet: Sheet1

MLVA-Marker | Unit [NAME] | Code-No. | Expected Fragment Length (bp) | Observed Fragment Length (bp) | Unnamed: 5 | MLVA-Marker.1 | Unit Length Size.1 | Code-No..1 | Expected Fragment Length (bp).1 | Observed Fragment Length (bp).1
bams1 | 21 | 8 | 317 | 321 |  | bams34 | 39 | 6 | 386 | 392
 |  | 10 | 359 | 363 |  |  |  | 7 | 425 | 431
 |  | 11 | 380 | 384 |  |  |  | 9 | 503 | 513
 |  | 13 | 422 | 426 |  | bams44 | 39 | 2 | 183 | 187
 |  | 16 | 485 | 493 |  |  |  | 7 | 378 | 382
bams3 | 15 | 18 | 429 | 431 |  |  |  | 8 | 417 | 422
 |  | 28 | 579 | 585 |  | bams51 | 45 | 9 | 493 | 500
 |  | 30 | 609 | 615 |  | bams53 | 12 | 6 | 212 | 210-213
bams5 | 39 | 3 | 229 | 227 |  |  |  | 8 | 236 | 237
 |  | 5 | 307 | 304 |  | CG3 | 5 | 1 | 153 | 152
 |  | 6 | 346 | 343 |  |  |  | 2 | 158 | 157
 |  | 7 | 385 | 382 |  | pX01 | 3 | 6 | 126 | 123
bams13 | 9 | 30 | 454 | 457 |  |  |  | 7 | 129 | 126
 |  | 33 | 481 | 486 |  |  |  | 8 | 132 | 129
 |  | 38 | 526 | 530 |  |  |  | 9 | 135 | 132
 |  | 41 | 553 | 559 |  |  |  | 10 | 138 | 135
 |  | 42 | 562 | 568 |  | pX02 | 2 | 0 | 0 | 0
 |  | 43 | 571 | 576 |  |  |  | 6 | 135 | 134
 |  | 44 | 580 | 585 |  |  |  | 7 | 137 | 136
 |  | 45 | 589 | 596 |  |  |  | 8 | 139 | 138
 |  | 70 | 814 | 826 |  |  |  | 9 | 141 | 140
 |  | 73 | 841 | 853 |  |  |  | 10 | 143 | 142
 |  | 76 | 868 | 880 |  |  |  | 11 | 145 | 144
bams15 | 9 | 44 | 598 | 597 |  |  |  | 12 | 147 | 146
 |  | 45 | 607 | 606 |  |  |  | 13 | 149 | 148
 |  | 46 | 616 | 615 |  | vrrA | 12 | 2 | 290 | 288
[NAME] | 45 | 8 | 631 | 626 |  |  |  | 4 | 314 | 312
 |  | 9 | 676 | 672 |  |  |  | 5 | 326 | 324
bams22 | 36 | 10 | 627 | 623 |  | vrrB1 | 9 | 13 | 193 | 192
 |  | 11 | 663 | 659 |  |  |  | 17 | 229 | 228
 |  | 12 | 699 | 694 |  | vrrB2 | 9 | 14 | 162 | 160
 |  | 13 | 735 | 727-729
bams23 | 42 | 8 | 567 | 564 |  | vrrC1 | 9 | 49 | 544 | 552
 |  | 9 | 609 | 605-607 |  |  |  | 53 | 580 | 587-590
 |  | 9.7 | 639 | 635 |  |  |  | 57 | 616 | 621-630
 |  | 10 | 651 | 644-646 |  | vrrC2 | 18 | 15 | 532 | 533
bams24 | 42 | 9 | 595 | 603 |  |  |  | 19 | 604 | 604
bams25 | 15 | 4 | 391 | 395 |  | VNTR12 | 2 | 6 | 115 | 114
[NAME] | 24 |  |  |  |  |  |  | 7 | 117 | 116
 |  | 14 | 493 | 501 |  | VNTR16 | 8 | 0 | 0 | 0
bams30 | 9 | 48 | 646 | 654 |  |  |  | 8 | 273 | 271
 |  | 51 | 673 | 683 |  |  |  | 9 | 281 | 279
 |  | 53 | 691 | 703 |  | VNTR17 | 8 | 0 | 0 | 0
 |  | 54 | 700 | 711 |  |  |  | 3 | 378 | 379
 |  | 57 | 727 | 738 |  |  |  | 4 | 386 | 387
 |  | 60 | 754 | 765 |  | VNTR19 | 3 | 4 | 96 | 93
 |  | 69 | 835 | 850 |  |  |  | 5 | 99 | 96
 |  | 75 | 889 | 904 |  | VNTR23 | 12 | 3 | 185 | 184
bams31 | 9 | 56 | 700 | 705 |  |  |  | 4 | 197 | 196
 |  | 59 | 727 | 731 |  |  |  | 5 | 209 | 208
 |  | 63 | 763 | 768 |  | VNTR35 | 6 | 3 | 109 | 109
 |  | 64 | 772 | 777 |  |  |  | 4 | 116 | 116
 |  | 65 | 781 | 786
Spreadsheet: 117522d1312843506-return-multiple-values-excel-tracker-v1
Sheet: Sheet1

 | Baseline | February | July |  |  | 1c | 1b | 1a | 2c | 2b | 2a | 3c | 3b | 3a | 4c | 4b | 4a | 5c | 5b | 5a
[NAME] | 1c | 1a | 2c |  | Baseline
[NAME] | 1c | 1b | 2c |  | February
[NAME] | 1a | 2c | 2b |  | July
[NAME] | 2b | 2a | 3c
[NAME] | 2a | 2b | 3c
[NAME] | 2c | 1a | 2b
[NAME] | 2c | 2b | 2a
[NAME] | 1b | 2a | 3c
Spreadsheet: darrell_schoolcraft__7735__imball0203
Sheet: Continental

 | Contintental
 | 500204 |  | 500205
Day | Measured | Scheduled | Measured | Scheduled
1 |  |  |  | 812
2
3
4
5
6 |  |  |  | 2
7
8
9
10
11
12
13 |  |  |  | 812
14 |  |  |  | 812
15 |  |  |  | 812
16 |  |  |  | 812
17 |  |  |  | 812
18 |  |  |  | 812
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-02-28 00:00:00 |  |  |  |  | 57421.18
2002-03-18 00:00:00
CBS Volume
 |  |  | 7844
Spreadsheet: e6fe4acf-70fe-45e3-84be-429cb39347f8
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
6952 | 21885 | [NAME] | Poole | ITU | 3 | [NAME] | 00:00:00 | 01:02:53 | 00:00:00 | 00:18:37 | 1 | 01:56:21
6952 | 25507 | [NAME] | Mchale | NZL | 5 | [NAME] | 00:00:00 | 01:06:56 | 00:00:00 | [NAME] | 2 | [NAME]
6952 | 41950 | [NAME] | O'Connor | NZL | 4 | 00:37:09 | 00:00:00 | 01:09:27 | 00:00:00 | [NAME] | 3 | 02:06:11
6952 | 31421 | Cameron | [NAME] | NZL | 6 | 00:34:46 | 00:00:00 | 01:13:36 | 00:00:00 | 00:18:53 | 4 | 02:07:16
6952 | 21895 | [NAME] | Harrop | NZL | 8 | 00:00:01 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 94172d1294054535-establish-ramp-up-point-lookup
Sheet: Ark1

#N/A |  |  |  |  | X
#N/A
#N/A | 200
#N/A | 100
#N/A | 50
#N/A | 50
#N/A | 100
#N/A | 150
#N/A | 200
 | 500 | 1000
Wanted result
 | 200
 | 100
 | 50
X | 50
 | 100
 | 150
 | 200
 | 500 | 1000