tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 708730d1607990735-looking-to-extract-various-data-points-from-a-string-of-text-to-make-a-schedule-submission
Sheet: Sheet3

 |  |  |  | 2020-01-05 00:00:00 | 2020-01-06 00:00:00 | 2020-01-07 00:00:00 | 2020-01-08 00:00:00 | 2020-01-09 00:00:00
[NAME] |  |  |  | 1515_Bridge_Base_Fit_05
[NAME] |  |  |  | 1515_Bridge_Railing_Weld_02
1 | 1515
1.1 | Bridge
1.1.1 | Base
1.1.2 | Support
1.1.3 | Mesh
1.2 | Railing
1.2.1 | Corner
1.2.2 | Straight
Spreadsheet: 152787d1335527625-excel-2007-counting-with-a-pivot-table-groups-not-individual-rows-forum
Sheet: Arkusz1

Part | Customer | [NAME] | data2
abc | [NAME]
abc | [NAME]
abc | [NAME]
abc | [NAME]
abc | [NAME]
abc | [NAME]
 |  |  |  |  |  | Etykiety wierszy | Suma z data2
 |  |  |  |  |  | abc | 3
 |  |  |  |  |  | Suma końcowa | 3
Spreadsheet: b06549fd-daf7-477b-a131-d98b5b207caf
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1
 | Centraal Bureau voor de Statistiek     •    Statistics Netherlands
 | [NAME] Economische Statistieken
Onderwerp | Informatie voor derden (Iv3)
 | [NAME], september 2011
 | [NAME] heer / mevrouw,
 | De begrotingen 2012 betreffen gegevens in de [NAME] Iv3-matrix, zoals bepaald in het Besluit begroting en verantwoording provincies en gemeenten (BBV) en de Ministeriële regeling informatie voor derden (Iv3). Voor de begroting is slechts een beperkte invulling [NAME] matrix vereist. Het betreft de lasten en baten volgens de functionele indeling, [NAME] gespecificeerd naar economische categorie. Naast de financiële gegevens is een separate verklaring van het college vereist over [NAME] gegevens.
 | De begrotingsgegevens moeten vóór 15 november 2011 door het CBS zijn ontvangen. [NAME] deze wettelijk vastgestelde deadline voor u niet haalbaar is, kunt u een verzoek tot uitstel indienen bij de staatssecretaris [NAME], conform de procedure beschreven in de BZK-circulaire Informatie voor derden van 29 juni 2009.
 | Indien mogelijk verzoeken wij u om de gegevens [NAME] begroting.
 | U wordt verzocht de gegevens te verstrekken in eXtensible Business Reporting Language (XBRL). Hiervoor heeft het CBS een zogenaamde taxonomie ontwikkeld die op de website [NAME] Kredo van het CBS te vinden is. Mocht XBRL voor u nu nog niet [NAME], [NAME] voorlopig aanleveren door [NAME] die u vindt in dit bestand. Wij verzoeken u het ingevulde bestand naar het CBS te sturen. De bijgesloten spreadsheets zijn conform het BBV.
 | Het model 2012 van de Iv3-matrix is niet veranderd ten opzichte van het model 2011.
 | In het model voor het begrotingsjaar 2012 zijn ten opzichte [NAME] geen nieuwe functies
 | [NAME] functies vervallen.
 | Ik verzoek u geen wijzigingen in (de opmaak van) dit bestand aan te brengen in verband met de automatische verwerking, en dus geen tabbladen toe te voegen of [NAME] tabbladen te wijzigen.
 | Voor vragen en/of opmerkingen over inhoudelijke Iv3-zaken kunt u contact opnemen met:
 | Centraal Bureau voor de Statistiek
 | Bureau Kredo
 | tel. (070) 337 47 08
 | www.cbs.nl/kredo
 | [EMAIL]
 | Ten slotte wijs ik u op het [NAME] gegevensverstrekking. Door de ministeries wordt de Iv3-matrix voor steeds meer beleidsdoeleinden gebruikt. [NAME] gegevens [NAME] [NAME] toe. In dit kader [NAME] het CBS lasten en baten per [NAME] gemeenten in StatLine, de internet-databank van het CBS. Het is [NAME] gemeente helder en correct [NAME] worden. Ter bevordering van de kwaliteit en [NAME] cijfers zal het CBS contact met u opnemen bij twijfel aan het correct [NAME] indeling.
 | Met vriendelijke groet,
 | [NAME] sector [NAME]
 | [NAME]. drs. [NAME]
Spreadsheet: 866575d1713484987-not-transferring-employee-names-to-main-sheets-employee-absence-schedule
Sheet: October

 | Employee absence schedule
 | October
 | Absence type key | V | Vacation |  |  | P | Personal |  |  | S | Sick |  |  | Custom 1 |  |  |  | Custom 2
 |  | Dates of absence
 | Employee name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | Total days
 | [NAME]
 | [NAME]
 | Asaf Karten
 | [NAME]
 | [NAME]
Spreadsheet: 471553d1469079477-bar-graph-colour-mismatch-with-the-data-1-dust-blend-up-2014-2016-
Sheet: Type 2.3

Lot No. | Dust % | Date
Lot 61 | 25 | 2015-12-04 00:00:00 |  |  |  |  |  | General Blend Up (25% Dust)
Lot 56 | 25 | 2015-11-23 00:00:00 |  |  |  |  |  | Blend Card |  |  |  | Average | 28.75
Lot 57 | 25 | 2015-10-26 00:00:00
Lot 56 | 40 | 2015-10-19 00:00:00
Lot 54 | 25 | 2015-10-06 00:00:00
Lot 44 | 25 | 2015-09-11 00:00:00
Lot 41 | 25 | 2015-07-27 00:00:00
Lot 34 | 25 | 2015-05-19 00:00:00
Lot 30 | 25 | 2015-01-19 00:00:00
Lot 84 | 25 | 2014-12-22 00:00:00
Lot 70 | 25 | 2014-07-14 00:00:00
Lot 49 | 10 | 2014-01-20 00:00:00
Lot 49 | 25 | 2014-01-16 00:00:00
Lot 49 | 30 | 2014-01-15 00:00:00
Lot 49 | 35 | 2014-01-15 00:00:00
Lot 73 | 25 | 2016-06-15 00:00:00
Lot 71 | 25 | 2016-04-14 00:00:00
Spreadsheet: jeff_dasovich__14105__Response to 10-12 Workshop Questions
Sheet: Q8

QUESTION 8
Q. What are the rate impacts of phasing in different amounts of Line 401 capacity into
on-system rates?
A.  Using the 2003 cost of service presented at the October 12 Workshop and Gas Accord I
rate design assumptions (other than the amount of Line 401 phase-in), the rates for
different levels of phase-in are:
 |  |  | Backbone Rate
 |  |  | (@100% contract usage)
 |  |  | Redwood |  |  | Baja | Silverado
 |  |  | Core | Noncore | Off-System
 | $ / Dth
2003 Preliminary Rates:
Phase-in 600 MMCf/d |  |  | 0.144 | 0.292 | 0.306 | 0.205 | 0.153
Phase-in 500 MMcf/d |  |  | 0.146 | 0.282 | 0.306 | 0.207 | 0.152
Phase-in 400 MMcf/d |  |  | 0.147 | 0.27 | 0.306 | 0.209 | 0.15
Note: The Baja and Silverado path rates change because the different amounts of phase-in
result in slightly different allocations of common backbone costs to the various paths.
Spreadsheet: 86991d1286913037-looking-for-a-sum-or-count-formula-job-group-analysis
Sheet: Job Group Analysis

 |  |  |  | Manual Totals from the Workforce Analysis tab, but would like a formula to count it for me
Job Group Name | Job Group # | Total | MALE |  |  |  |  |  |  |  | FEMALE
 |  |  | Total | WHT | BLK | ASN | AIAN | NHOPI | TWO+ | HISP | Total | WHT | BLK | ASN | AIAN | NHOPI | TWO+ | HISP
(1) Administrative Staff | 1 | 13 | 2 | 1 |  |  |  |  |  | 1 | 11 | 6 |  |  |  |  |  | 5
(2) Administrative Managers | 2 | 3 | 1 |  |  |  |  |  | 1 |  | 2 | 1 |  |  |  |  |  | 1
(3) Administrative Directors | 3 | 0 | 0 |  |  |  |  |  |  |  | 0
(4) Client Service Interns | 4 | 3 | 1 | 1 |  |  |  |  |  |  | 2 | 1 |  |  |  |  |  | 1
(5) Client Service Staff | 5 | 22 | 8 | 5 |  |  |  |  |  | 3 | 14 | 8 |  |  |  |  | 1 | 5
(6) Client Service Seniors | 6 | 20 | 5 | 4 |  |  |  |  |  | 1 | 15 | 7 |  | 1 | 1 |  | 2 | 4
(7) Client Service Managers | 7 | 12 | 5 | 3 |  | 1 |  |  |  | 1 | 7 | 3 |  | 1 |  |  |  | 3
(8) Client Service Senior Mgrs. & VPs | 8 | 12 | 7 | 5 |  |  |  |  |  | 2 | 5 | 4 |  |  |  |  | 1
Total |  | 85 | 29 | 19 | 0 | 1 | 0 | 0 | 1 | 8 | 56 | 30 | 0 | 2 | 1 | 0 | 4 | 19
Spreadsheet: 655edd9a-978d-459c-8129-4c1a6cc69462
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
8049 | 50580 | [NAME] | [NAME] | GBR | 5473 | 00:00:00 | 00:00:00 | [NAME] | 00:01:08 | 00:23:00 | 1 | 00:28:41
8049 | 41159 | Charlotte | Ellis | GBR | 5472 | 00:00:00 | 00:00:00 | 00:05:16 | 00:01:26 | 00:23:04 | 2 | 00:29:47
8049 | 40701 | [NAME] | Rodriguez | ESP | 5471 | 00:00:00 | 00:00:00 | 00:04:57 | 00:01:47 | 00:23:16 | 3 | 00:30:01
8049 | 30439 | Joleen | Hakker B1 | NED | 5474 | 00:00:00 | 00:00:00 | [NAME] | 00:01:54 | 00:24:36 | 4 | 00:32:50
Spreadsheet: d5cecd03-58c5-4248-b4b5-1ddbb6b5fff0
Sheet: Pg25

Permit No.: |  |  | WQ0023693 |  |  | Facility Name: |  | West Brunswick Regional WWTF |  |  |  |  |  | County: | Brunswick |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | BNFH |  | Field Name: |  | BNFL |  | Field Name: |  | BNTH |  | Field Name: |  | BNTL
 |  |  |  |  |  | Area (acres): |  | 28.5 |  | Area (acres): |  | 13.7 |  | Area (acres): |  | 6.25 |  | Area (acres): |  | 2.53
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.2 |  | [NAME] (in): |  | 0.1 |  | [NAME] (in): |  | 0.2 |  | [NAME] (in): |  | 0.1
 |  |  |  |  |  | Annual Rate (in): |  | 83.2 |  | Annual Rate (in): |  | 41.6 |  | Annual Rate (in): |  | 83.2 |  | Annual Rate (in): |  | 41.6
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: michelle_lokay__26791__mojaveoba
Sheet: Sheet1

[NAME]
Mojave OBA
Monthly summary
 | Imbalance
Month | Mmbtus
1993-02-01 00:00:00 | 5003
1993-03-01 00:00:00 | -11986
1993-04-01 00:00:00 | 7118
1993-05-01 00:00:00 | 2940
1993-06-01 00:00:00 | 2806
1993-07-01 00:00:00 | 61
1993-08-01 00:00:00 | 21740
1993-09-01 00:00:00 | 14084
1993-10-01 00:00:00 | 8436
1993-11-01 00:00:00 | -49484
1993-12-01 00:00:00 | 7244
1994-01-01 00:00:00 | -29620
1994-02-01 00:00:00 | 1638
1994-03-01 00:00:00 | -24487
1994-04-01 00:00:00 | 46122
1994-05-01 00:00:00 | -2788
1994-06-01 00:00:00 | -6198
1994-07-01 00:00:00 | 8175
1994-08-01 00:00:00 | 2483
1994-09-01 00:00:00 | -3074
1994-10-01 00:00:00 | -4868
1994-11-01 00:00:00 | 73220
1994-12-01 00:00:00 | -67791
1995-01-01 00:00:00 | -9797
1995-02-01 00:00:00 | 17696
1995-03-01 00:00:00 | -11820
1995-04-01 00:00:00 | -10520
1995-05-01 00:00:00 | 34787
1995-06-01 00:00:00 | 42754
1995-07-01 00:00:00 | -62914
1995-08-01 00:00:00 | 8229
1995-09-01 00:00:00 | -56378
1995-10-01 00:00:00 | 20229
1995-11-01 00:00:00 | 27631
1995-12-01 00:00:00 | 93759
1996-01-01 00:00:00 | -39709
1996-02-01 00:00:00 | -27284
1996-03-01 00:00:00 | -20897
1996-04-01 00:00:00 | -77564
1996-05-01 00:00:00 | 74425
1996-06-01 00:00:00 | 0
1996-07-01 00:00:00 | 1080
1996-08-01 00:00:00 | 5068
1996-09-01 00:00:00 | 30907
1996-10-01 00:00:00 | -32490
1996-11-01 00:00:00 | -12217
1996-12-01 00:00:00 | -13092
1997-01-01 00:00:00 | 23116
1997-02-01 00:00:00 | 904
1997-03-01 00:00:00 | 576
1997-04-01 00:00:00 | -16392
1997-05-01 00:00:00 | 771
1997-06-01 00:00:00 | -8105
1997-07-01 00:00:00 | -18702
1997-08-01 00:00:00 | 35246
1997-09-01 00:00:00 | -44386
1997-10-01 00:00:00 | 3943
1997-11-01 00:00:00 | 3059
1997-12-01 00:00:00 | 7853
1998-01-01 00:00:00 | 27023
1998-02-01 00:00:00 | 18558
1998-03-01 00:00:00 | 15573
1998-04-01 00:00:00 | -24954
1998-05-01 00:00:00 | -24795
1998-06-01 00:00:00 | 11104
1998-07-01 00:00:00 | -29197
1998-08-01 00:00:00 | 1102
1998-09-01 00:00:00 | 16006
1998-10-01 00:00:00 | -13373
1998-11-01 00:00:00 | 8831
1998-12-01 00:00:00 | 16717
1999-01-01 00:00:00 | 1713
1999-02-01 00:00:00 | 6045
1999-03-01 00:00:00 | 8926
1999-04-01 00:00:00 | 5510
1999-05-01 00:00:00 | 18450
1999-06-01 00:00:00 | 9604
1999-07-01 00:00:00 | -3412
1999-08-01 00:00:00 | 78
1999-09-01 00:00:00 | -2264
1999-10-01 00:00:00 | 9573
1999-11-01 00:00:00 | 18935
1999-12-01 00:00:00 | 17437
2000-01-01 00:00:00 | 10941
2000-02-01 00:00:00 | 20159
2000-03-01 00:00:00 | -30858
2000-04-01 00:00:00 | -65851
2000-05-01 00:00:00 | 8857
2000-06-01 00:00:00 | 11352
2000-07-01 00:00:00 | 121001
2000-08-01 00:00:00 | -5183
2000-09-01 00:00:00 | -11379
2000-10-01 00:00:00 | -70839
2000-11-01 00:00:00 | 12086
2000-12-01 00:00:00 | -8357
2001-01-01 00:00:00 | -12266
2001-02-01 00:00:00 | -22341
2001-03-01 00:00:00 | -37223
2001-04-01 00:00:00 | 22653
2001-05-01 00:00:00 | -22533
2001-06-01 00:00:00 | 129146
2001-07-01 00:00:00 | 2708
2001-08-01 00:00:00 | 15661
2001-09-01 00:00:00 | 4989
2001-10-01 00:00:00 | 11013
2001-11-01 00:00:00 | 9468
2001-12-01 00:00:00 | 9889
Spreadsheet: 769005d1645244889-30-day-moving-total-starting-with-today-2022-02-18-dashboard_tracking_export
Sheet: Report2_summary

 |  |  |  |  |  | Date:
 |  |  |  |  |  | Last Data Date:
 |  |  |  |  |  | Week #:
Overall Cummulative Stats
 | This Week |  | Last Week |  | This Month |  | 30day [NAME] |  | This Quarter |  | Last Quarter |  | YTD |  | Last Year |  | 2 Years Ago |  | Total
 |  | % |  | % |  | % |  | % |  | % |  | % |  | % |  | % |  | % |  | %
Average
High
Low
Performance Over Time :  # of REPORTs/# of Days Person was [NAME]
 | This Week |  | Last Week |  | This Month |  | 30day [NAME] |  | This Quarter |  | Last Quarter |  | YTD |  | Last Year |  | 2 Years Ago |  | Total
 | # Reports | % | # Reports | % | # Reports | % | # Reports | % | # Reports | % | # Reports | % | # Reports | % | # Reports | % | # Reports | % | # Reports | %
Spreadsheet: 810476d1671796056-autonumber-with-concatenate-issue-with-filter-ef_examp
Sheet: Suppliers

Supplier | Port | Country | INCO | brands
AH | Yantian | CN | FOB | UA/NS
ASM | Istanbul | TR | FCA | SPA
AZT | Torreon | MX | FOB | Pi
CFI | Ningbo or Jiangyi | CN | FOB | NS textiles
CHIY | Shanghai? | CN | FOB | NS
COAL | Seattle, WA | US | FOB | Pi
CR_ | Taichung | TW | FOB | MD/SD
CR2 | Shanghai | CN | FOB | MD
DA | ? | US | FOB | Pi
DEY | HCM | VN | FOB | SD/MD/NS
DISP | GORDONA | IT | EXW | MD
EON | Hong Kong | CN | FOB | Pi
FLT | 0 |  | FOB | Pi
HYING | Dalian | CN | FOB | SPA
HYD |  | CN | EXW
HYU | Haiphong | VN | FOB | Pi
IMA | Puebla | MX | FOB | NS/MD
J&K | Kurunegala | LK | FOB | Pi
JIO | Taipei | TW | FOB | SPA
KOL |  | TR | DDP | SPA
KT CN | Shanghai | CN | FOB | KT
KT UK | Middlesex | GB | FOB | KT
KT US |  |  |  | KT
KTMJ | [NAME] | MY | FOB | NS
KWL | HCM | VN | FOB | NS
LIS | Ningbo | CN | FOB | UA
LWH | HCM | VN | FOB | MD
LOOP | Portland, OR | US | FOB | Pi
MERL | Santo Tomás de Castilla, Guatemala. | SV | FOB | Pi
NHS | Ningbo | VN | FOB | UA
ORG | Yantian | CN |  | NS
HERO | Kaohsiung | TW | FOB | NS
PUNKG | Semarange | ID | FOB | NS
PUNKGH | HCM | VN | FOB | NS
RCO | Shanghai | CN | FOB | MD
RELI | Tainan | TW | FOB | SD
RENFROO | Mount Airy, NC | US | EXW | Pi
SCC | Phnom Penh | KH | FOB | Pi
SEAOT | Shanghai | CN | FOB | NS
SEESS | Haiphong | VN | FOB | Pi
SHAMAM | Chittagong | BD | FOB | SPA
SHDRAG | Shanghai | China | FOB | Pi
SDUS | Long Beach | US | EXW | NS/UA/SD
SLLCC | Qingdao | CN | FOB | Pi
[NAME] | HCM | VN | FOB | SPA
[NAME] | Shanghai | CN | FOB | SPA
SPA3 | Xiamen | CN | FOB | SPA
SPA4 | Shanghai | CN | FOB | SPA
SPA5 | HCM | VN | FOB | SPA
SPA6 | Bangkok | TH | FOB | SPA
SPA7 | Haiphong | VN | FOB | SPA
SPECI | Morgan Hill, CA | US | FOB | Pi
SPL | Taichung | TW | FOB | MD
TASTAS | Jakarta | ID | FOB | SPA
TOPCO | Shanghai | CN | FOB | NS
UAS | Guangzhou | CN | EXW | Pi
UASMY | [NAME] (East) Township | MM | FOB | Pi
WGYO | Yantian | CN | FOB | NS
Y1 | Haiphong | VN | FOB | Pi
PLA | Stuttgart | DE | FOB | PI
Spreadsheet: 110013d1306824862-excel-2007-create-new-column-based-on-the-existing-rows-insfilename
Sheet: Sheet1

filename:today.txt | filename:today.txt today.txt | 1
a yes | a yes today.txt | 1
b no | b no today.txt | 1
c yes | c yes today.txt | 1
filename:tom.txt | filename:tom.txt tom.txt | 5
x yes | x yes tom.txt | 5
y no | y no tom.txt | 5
Spreadsheet: darrell_schoolcraft__7324__imball0202
Sheet: KN_Westar

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract 8289 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
[NAME] | 12353 | WestarCarson | 500168 | Westar Ward |  | 10187-01 | 9089-01 | 10522
 | Measured | Scheduled | Measured | Scheduled |  |  | Del | recpt
1 |  |  | -38899 | -39350
2 |  |  | -3677 | -1850
3 |  |  |  | -3350
4 |  |  |  | -350
5 |  |  |  | -850
6 |  |  |  | -850
7 |  |  |  | -850
8 |  |  | -13262 | -12350
9 |  |  | -33942 | -32042
10 |  |  | -33351 | -32042
11 |  |  | -33738 | -32042
12 |  |  | -33590 | -33350
13 |  |  | -5050 | -850
14 |  |  | -18827 | -23049
15 |  |  | -29265 | -30349
16 |  |  | -19595 | -19850
17 |  |  | -19651 | -19850
18 |  |  | -19767 | -19850
19 |  |  | -16946 | -19850
20
21
22
23
24
25
26
27
28
29
30
31
index
2002-01-31 00:00:00 |  |  |  |  | 329520.2
2002-02-19 00:00:00
CBS Volume
 |  |  | -36982
Spreadsheet: 116566d1311914314-selective-columns-handicapscorecards-master2
Sheet: Historic Data

Player | Course | Tee | Date | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | handicap | stableford | new handicap | par 3 | Index 1 | Index 2 | Index 3
Spreadsheet: 116785d1312170131-pivot-table-sample
Sheet: Sheet1

 |  | AP01 |  | AP02 |  | AP03 |  | AP04 |  | AP05 |  | AP06 |  | AP07 |  | AP08 |  | AP09 |  | AP10 |  | AP11 |  | AP12
Customer | Station | Input | Output | Input | Output | Input | Output | Input | Output | Input | Output | Input | Output | Input | Output | Input | Output | Input | Output | Input | Output | Input | Output | Input | Output
AAA | CR | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1
AAA | 1RF | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AAA | 2RF | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AAA | MF | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
AAA | LS | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0
BBB | CR | 1 | 0 | 0 | 0 | 2 | 1 | 0 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
BBB | 1RF | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
BBB | 2RF | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
BBB | MF | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
BBB | LS | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CCC | CR | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CCC | 1RF | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CCC | 2RF | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CCC | MF | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CCC | LS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 119529d1314501381-no-in-age-range-if-age-in-years-and-months-countagey-and-m
Sheet: Sheet1

Date1 | Date of birth | Age at Date1 | Group
2011-07-05 00:00:00 | 1991-02-12 00:00:00 |  | 1
2011-07-05 00:00:00 | 1996-02-18 00:00:00 |  | 1
2011-08-12 00:00:00 | 2005-07-04 00:00:00 |  | 2
2011-07-02 00:00:00 | 2003-08-09 00:00:00 |  | 1
2011-01-11 00:00:00 | 2010-08-25 00:00:00 |  | 3
2011-05-28 00:00:00 | 2001-01-22 00:00:00 |  | 2
2011-11-03 00:00:00 | 2000-12-22 00:00:00 |  | 3
Spreadsheet: 790420d1659701136-10-day-rolling-values-on-chart-allanwalking-202
Sheet: HRVroll

2022-01-01 00:00:00 | 45 |  | Enter date | 2022-02-03 00:00:00 |  |  | 10 day rolling values on chart
 | 66 |  | Last ? Days | 7 |  |  | https://www.excelforum.com/excel-formulas-and-functions/1384334-10-day-rolling-values-on-chart.html
 | 36
 | 27 |  |  |  |  |  | Date = INDEX($A$1:$A$365,MATCH($E$1-$E$2+1,$A$1:$A$365,0)):INDEX($A$1:$A$365,MATCH($E$1,$A$1:$A$365,0))
 | 11 |  |  |  |  |  | Value = INDEX($B$1:$B$365,MATCH($E$1-$E$2+1,$A$1:$A$365,0)):INDEX($B$1:$B$365,MATCH($E$1,$A$1:$A$365,0))
 | 63
 | 51
 | 34
 | 55
 | 45
 | 43
 | 36
 | 27
 | 54
 | 63
 | 51
 | 34
 | 55
 | 45
 | 43
 | 36
 | 27
 | 54
 | 63
 | 51
 | 34
 | 55
 | 44
 | 34
 | 62
 | 21
 | 43
 | 28
 | 46
 | 23
 | 45
 | 66
 | 36
 | 27
 | 11
 | 63
 | 51
 | 34
 | 55
 | 45
 | 43
 | 36
 | 27
 | 54
 | 63
 | 51
 | 34
 | 55
 | 45
 | 43
 | 36
 | 27
 | 54
 | 63
 | 51
 | 34
 | 55
 | 44
 | 34
 | 62
 | 21
 | 43
 | 28
 | 46
 | 23
 | 45
 | 66
 | 36
 | 27
 | 11
 | 63
 | 51
 | 34
 | 55
 | 45
 | 43
 | 36
 | 27
 | 54
 | 63
 | 51
 | 34
 | 55
 | 45
 | 43
 | 36
 | 27
 | 54
 | 63
 | 51
 | 34
 | 55
 | 44
 | 34
 | 62
 | 21
 | 43
 | 28
 | 46
 | 23
 | 45
 | 66
 | 36
 | 27
 | 11
 | 63
 | 51
 | 34
 | 55
 | 45
 | 43
 | 36
 | 27
 | 54
 | 63
 | 51
 | 34
 | 55
 | 45
 | 43
 | 36
 | 27
 | 54
 | 63
 | 51
 | 34
 | 55
 | 44
 | 34
 | 62
 | 21
 | 43
 | 28
 | 46
 | 23
 | 45
 | 66
 | 36
 | 27
 | 11
 | 63
 | 51
 | 34
 | 55
 | 45
 | 43
 | 36
 | 27
 | 54
 | 63
 | 51
 | 34
 | 55
 | 45
 | 43
 | 36
 | 27
 | 54
 | 63
 | 51
 | 34
 | 55
 | 44
 | 34
 | 62
 | 21
 | 43
 | 28
 | 46
 | 23
 | 45
 | 66
 | 36
 | 27
 | 11
 | 63
 | 51
 | 34
 | 55
 | 45
 | 43
 | 36
 | 27
 | 54
 | 63
 | 51
 | 34
 | 55
 | 45
 | 43
 | 36
 | 27
 | 54
 | 63
 | 51
 | 34
 | 55
 | 44
 | 34
 | 62
 | 21
 | 43
 | 28
 | 46
 | 23
Spreadsheet: 70165d1270860117-excel-2007-formula-cell-references-example
Sheet: Sheet2

 |  | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 251 | 254 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Starts | Best Finish | Worst Finish | Average Finish | Wins | Win % | Top-5 | Top-5 % | Top-10 | Top-10 % | Top-15 | Top-15 % | Top-20 | Top-20 % | 20+ | 20+ % | Laps That Should've Been Run | [NAME] | Laps Run % | Laps Missed | Laps Missed % | Laps Led | Laps Led % | # of Times a Lap Down | # of Times a Lap Down % | DNF | DNF % | Best Start | Worst Start | Avg. Start | Pole | Pole % | Top-5 | Top-5 % | Top-10 | Top-10 % | Top-15 | Top-15 % | Top 20 | Top-20 % | 20+ | 20+ %
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Variable
 | Finish | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  | 5 Year
 | Start | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  | 10 Year
 | [NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Laps Led | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | DNFs | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 268270d1380542384-moving-sum-when-inserting-rows-skate1991_avg
Sheet: Sheet1

Dates | Values
2013-09-21 00:00:00 | 81
 | 94
 | 70
 | 49
 | 62
 | 14
 | 15
 | 71
 | 96
 | 47
 | 54
 | 1
 | 1