tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 845521d1697015254-calculating-annualized-return-for-stocks-sample_xirr
Sheet: Sheet1

Date | Cashflow/market value | Comments
2023-01-01 00:00:00 | -1000 | Investment
2023-02-02 00:00:00 | -1000 | Investment
2023-03-01 00:00:00 | -1000 | Investment
2023-04-10 00:00:00 | -1000 | Investment
2023-05-02 00:00:00 | -1000 | Investment
2023-05-27 00:00:00 | -1000 | Investment
2023-06-01 00:00:00 | 100 | Dividends
2023-07-06 00:00:00 | -1000 | Investment
2023-08-09 00:00:00 | -1000 | Investment
2023-09-03 00:00:00 | -1000 | Investment
2023-10-01 00:00:00 | -1000 | Investment
2023-10-11 00:00:00 | 10200 | Current market value
XIRR
Spreadsheet: 124325d1318337558-merging-columns-example
Sheet: Sheet1

[NAME] | Wayne | [NAME] |  | [NAME]
[NAME] | [NAME] | Samantha |  | [NAME]
Smith | [NAME] | [NAME] |  | Smith
Fred | [NAME] | [NAME] |  | Fred
[NAME] |  | Lucas |  | [NAME]
 |  | [NAME] |  | Wayne
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | Samantha
 |  |  |  | [NAME]
 |  |  |  | Lucas
 |  |  |  | [NAME]
Spreadsheet: 777865d1650643701-retrieving-average-data-cells-from-sheets-using-lists-test-data
Sheet: Analysis

InCAS Academic Analysis July 2021
Subject 1 |  |  |  | Subject 2
Select Class | Percentage with an Age Difference of < 0 Years | Percentage with an Age Difference of > 3 Years |  | Select Class | Percentage with an Age Difference of < 0 Years | Percentage with an Age Difference of > 3 Years |  | Class
6 |  |  |  | 2 |  |  |  | 1
2 |  |  |  | 3 |  |  |  | 2
3 |  |  |  | 1 |  |  |  | 3
5 |  |  |  | 5 |  |  |  | 4
4 |  |  |  | 6 |  |  |  | 5
1 |  |  |  | 4 |  |  |  | 6
Subject 3 |  |  |  | Subject 4
Select Class | Percentage with an Age Difference of < 0 Years | Percentage with an Age Difference of > 3 Years |  | Select Class | Percentage with an Age Difference of < 0 Years | Percentage with an Age Difference of > 3 Years
1 |  |  |  | 1
2 |  |  |  | 2
3 |  |  |  | 3
4 |  |  |  | 4
5 |  |  |  | 5
6 |  |  |  | 6
[NAME]
Select Class | Average Standardised Score
1
2
3
4
5
6
Spreadsheet: d2af01af-d681-462b-bc0d-432ca76feb4e
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
AMYL | Test | AMYL | Amyloidosis, Transthyretin-Associated Familial, DNA Sequence, Blood | Familial Amyloidosis, DNA Sequence | Polymerase Chain Reaction (PCR) Amplification/DNA Sequencing (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | EDTA (lavender-top) tube: EDTA OR Yellow-Top (ACD) Tube: ACD OR |  |  | 3 | mL | [NAME] must arrive within 96 hours of draw.   [NAME] blood Container/Tube: Preferred: Lavender top (EDTA) or yellow top (ACD) Acceptable: Any anticoagulant [NAME]: 3 mL Collection Instructions: 1. Invert several times to mix blood. 2. Send specimen in original tube. Forms: 1. Molecular Genetics-Congenital Inherited Diseases Patient Information Sheet (Supply T521) in Special Instructions 2. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. 3. If not ordering electronically, submit a Molecular Genetics Request Form (Supply T245) with the specimen. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Thursday; 10 a.m. | 14 days | 20 days | 1 | 81404 |  |  |  |  | Rochester
AMYL | [NAME] | VARIES | Varies |  |  |  | Ambient
AMYL | Result | 22635 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2
AMYL | Result | 22636 | [NAME] | [NAME] | Alphanumeric
AMYL | Result | 22637 | Source | Source | Alphanumeric
AMYL | Result | 22638 | Order Date | Order Date | Alphanumeric
AMYL | Result | 22639 | Reason For Referral | Reason For Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1
AMYL | Result | 22640 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
AMYL | Result | 22641 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21674-7
AMYL | Result | 22642 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69047-9
AMYL | Result | 22643 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
AMYL | Result | 22644 | Reviewed By: | Reviewed By: | Alphanumeric
AMYL | Result | 22645 | Release Date | Release Date | Alphanumeric
Spreadsheet: 871918d1718299305-table-with-numbes-as-text-not-adding-up-help
Sheet: Query1

Name | SITE | DAY | Time | Customer | Work coach | Appointment type | Duration | Channel | Duration - Copy
 |  |  |  |  | [NAME] | Self-employment review |  |  | 30
 |  |  |  |  | [NAME] | Commitments review |  |  | 30
 |  |  |  |  | [NAME] | First Commitments |  |  | 30
 |  |  |  |  | [NAME] | Standard identity |  |  | 25
 |  |  |  |  | [NAME] | Commitments review |  |  | 30
 |  |  |  |  | [NAME] | Commitments review |  |  | 30
 |  |  |  |  | [NAME] | First Commitments |  |  | 30
 |  |  |  |  | [NAME] | Work Search Review |  |  | 10
 |  |  |  |  | [NAME] | First Commitments |  |  | 30
 |  |  |  |  | [NAME] | Commitments review |  |  | 30
 |  |  |  |  | [NAME] | Commitments review |  |  | 30
 |  |  |  |  | [NAME] | Gateway intervention |  |  | 60
 |  |  |  |  | [NAME] | Commitments review |  |  | 30
 |  |  |  |  | [NAME] | First Commitments |  |  | 30
 |  |  |  |  | [NAME] | Work Search Review |  |  | 10
 |  |  |  |  | [NAME] | Self-employment review |  |  | 30
 |  |  |  |  | [NAME] | First Commitments |  |  | 30
 |  |  |  |  | Hayley Amanda H | First Commitments |  |  | 30
Spreadsheet: 115900d1311349439-excel-2007-gridlines-turned-on-but-do-not-show-excel-problem-sample
Sheet: Office

 | Plan Year 12/31/2010 Office
 | Notes:  Rather then fill in compensation and defrral you may provide W-2's
 | Hours are:  0 - 500 (A); 501-999 (B); 1000+ (C)
 | Compensation should gross (including all pre-tax deferrals).
 | Social Security Number | Last Name | First Name | Gender | Birth Date | Hire Date | Compensation | Hours | Defferal | Termination
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
32
33
34
35
36
37
38
39
40
41
42
Spreadsheet: 56303988-b96b-416b-838c-7c7639ec930b
Sheet: Page 11

Permit No.: |  |  | WQ0028552 |  |  | Facility Name: |  | Briar Chapel Development |  |  |  |  |  | County: | Chatham |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | [NAME] |  | Field Name: |  |  |  | Field Name: |  | C-15B |  | Field Name: |  | C-15C
 |  |  |  |  |  | Area (acres): |  | 6.4 |  | Area (acres): |  |  |  | Area (acres): |  | 0.9 |  | Area (acres): |  | 1.3
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.1 |  | [NAME] (in): |  |  |  | [NAME] (in): |  | 0.1 |  | [NAME] (in): |  | 0.1
 |  |  |  |  |  | Annual Rate (in): |  | 37.31 |  | Annual Rate (in): |  |  |  | Annual Rate (in): |  | 19.95 |  | Annual Rate (in): |  | 37.31
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: 160473d1339090248-average-calculation-samplesheet
Sheet: Sheet1

 |  |  |  |  |  |  |  | Desired outcome
Code | Description | Score |  |  |  |  |  |  |  |  |  | Average of Score
1 | house |  |  |  |  |  |  | Code | Description | Score |  | Code | Description | Total
1.1 | garage | 1 |  |  |  |  |  | 1 | house |  |  | 1 | house
1.2 | kitchen | 2 |  |  |  |  |  | 1.1 | garage | 1 |  | 1.1 | garage | 1
1.3 | bedroom |  |  |  |  |  |  | 1.2 | kitchen | 2 |  | 1.2 | kitchen | 2
1.3.1 | masters | 2 |  |  |  |  |  | 1.3 | bedroom |  |  | 1.3 | bedroom
1.3.2 | kids |  |  |  |  |  |  | 1.3.1 | masters | 2 |  | 2 | car
2 | car |  |  |  |  |  |  | 1.3.2 | kids | NA |  | 2.1 | BMW
2.1 | BMW |  |  |  |  |  |  | 2 | car |  |  | 1.3.1 | masters | 2
2.1.1 | Three series | 2 |  |  |  |  |  | 2.1 | BMW |  |  | 1.3.2 | kids
 |  |  |  |  |  |  |  | 2.1.1 | Three series | 2 |  | 2.1.1 | Three series | 2
 |  |  |  |  |  |  |  |  |  |  |  | Grand Total |  | 1.75
 |  |  |  |  |  |  |  | 9 |  | 2
Spreadsheet: 725233d1616595570-dynamic-counta-example-21-ans
Sheet: Tariffs

New Rates Applicable from 01.09.2020
Per Additional Collection | 26.75
[NAME] | Per Pallet Rate | [NAME]
AB
AL
B
BA
BB
BD
BH
BL
BN
BR
BS
CA
CB
CF
CH
CM
CO
CR
CT
[NAME]
CW
DA
DE
DG
DH
DL
DN
DT
DY
E
EC
EH
EN
EX
FK
FY
G
GL
GU
HA
HD
HG
HP
HR
[NAME]
HX
IG
IP
KA
KT
KY
L
LA
LD
LE
LL
LN
LS
LU
M
ME
MK
ML
N
NE
NG
NN
NP
NR
NW
OL
OX
PA
PE
PL
PO
PR
RG
RH
RM
S
SA
SE
SG
SK
SL
SM
SN
SO
SP
SR
SS
ST
SW
SY
TA
TD
TF
TN
TQ
TR
TS
TW
UB
W
WA
WC
WD
WF
WN
WR
WS
WV
YO
Spreadsheet: 268357d1380587598-formula-for-how-many-from-each-of-the-three-departments-are-attending-draft-rsvp
Sheet: Sheet1

Function RSVP
Department | #'s
Marketing | 2
Ticketing | 2
Production | 2
Ticketing | 2 |  |  |  |  |  |  | Marketing
Marketing | 2 |  |  |  |  |  |  | Ticketing
Production | 1 |  |  |  |  |  |  | Production
Production | 3
Total Attending
Marketing
Ticketing
Production
Spreadsheet: 116639d1311962231-designing-a-survey-in-excel-and-vb-questionnaire-on-nat-testing-of-blood-donations
Sheet: 1. HIV

 |  | HIV screening |  |  |  |  | HIV screening
 |  |  |  |  |  |  | HIV screening
 |  |  |  |  |  |  | anti-HIV 1+2 | 0
 |  | Please note: Testing required or performed only by plasma fractionators should not be reported. |  |  |  |  | only 1st time donor | 0
 |  |  |  |  |  |  | every donation | 0
 |  | HIV screening |  |  |  |  | please specify supplier | 0
 |  |  |  |  |  |  | please specify test used | 0
 |  | anti-HIV 1+2 |  |  |  |  | HIV p24 Ag | 0
 |  |  |  |  |  |  | only 1st time donor | 0
 |  | only 1st time donor |  |  |  |  | every donation | 0
 |  |  |  |  |  |  | please specify supplier | 0
 |  | every donation |  |  |  |  | please specify test used | 0
 |  |  |  |  |  |  | HIV Combo test (antibody + antigen) | 0
 |  | please specify supplier |  |  |  |  | only 1st time donor | 0
 |  |  |  |  |  |  | every donation | 0
 |  | please specify test used |  |  |  |  | please specify supplier | 0
 |  |  |  |  |  |  | please specify test used | 0
 |  | HIV p24 Ag
 |  | only 1st time donor
 |  | every donation
 |  | please specify supplier
 |  | please specify test used
 |  | HIV Combo test (antibody + antigen)
 |  | only 1st time donor
 |  | every donation
 |  | please specify supplier
 |  | please specify test used
 |  |  |  | Page 4 of 34
Spreadsheet: 816176d1675418527-complex-unique-count-formula-count
Sheet: Monthly Summary

 | Month: | 2022-03-01 00:00:00 | Zone: | [NAME]
 | Customer | CustomerSalesAccount | Agency | No. of LatePymt
 |  | CAM123 | AG_567 | 1
 | Haxelnut ltd | CAM67 | AG_13789 | 2
 | Cubetronics | CAM123 | AG_13789 | 2
 | Foxtrotltd | CAMN459 | AG_389 | 1
 | Haxelnut ltd | CAM67 | AG_01 | 2
 | Decagon Ltd | [NAME] | AG_1987 | 3
Spreadsheet: 111837d1308119490-display-dropdown-from-vlookup-book1
Sheet: Phone Master Table

Locked from accidental editing. To unlock click Tool>Protection>Unprotect Sheet. No password is needed
Huawei | Unreleased | HTC | Desire | Kyocera | E1000 | LG | [NAME] | Motorola | WX404 | Nokia | 2125 | Pantech | CDM 8635 | RIM | 7130 | Samsung | A570 | UT Starcom | 7025 | Huawei
 |  |  | Merge |  | E1100 |  | UN430-Wine 2 |  | Crush |  | 6019 |  |  |  | 7250 |  | A645 |  |  | HTC
 |  |  | Pro |  | E2000 |  | UN510-Banter Touch |  | K1m-KRZR |  | 6235 |  |  |  | 8130 |  | A670 |  |  | Kyocera
 |  |  | Snap |  | K132-Velvet |  | UN610-Mystique |  | L7c-SLVR |  | 6585 |  |  |  | 8830 |  | A850 |  |  | LG
 |  |  | Touch |  | K312-Lightning |  | US670-Optimus U |  | QA30-Hint |  | 6165i |  |  |  | 8230-Pearl Flip |  | A870 |  |  | Motorola
 |  |  | Touch Pro 2 |  | KX1-SoHo |  | US740-Apex |  | V323 |  | 6255i |  |  |  | 8330-Curve |  | i100-Gem |  |  | Nokia
 |  |  |  |  | KX13-Dorado |  | [NAME] |  | V323i |  | 6265i |  |  |  | 8530-Curve 2 |  | i225-Exec |  |  | Pantech
 |  |  |  |  | KX16-Candid |  | UX210 |  | [NAME] |  |  |  |  |  | 8703e |  | i500-Mesmerize |  |  | RIM
 |  |  |  |  | KX160-Xcursion |  | [NAME] |  | V3m-Red |  |  |  |  |  | 9330-Curve 3 |  | R210-Spex |  |  | Samsung
 |  |  |  |  | KX21-Strobe |  | UX245 |  | V3m-Silver |  |  |  |  |  | 9630-Tour |  | R260-Chrono |  |  | UT Starcom
 |  |  |  |  | KX21-Koi |  | UX260-Black |  | V9m-RAZR2 |  |  |  |  |  | 9650-Bold |  | R311-Axle
 |  |  |  |  | Kx414-Phantom |  | UX260-White |  | VE20-Vegas |  |  |  |  |  |  |  | R330-Stride
 |  |  |  |  | KX444 |  | UX265-Banter |  | W315 |  |  |  |  |  |  |  | R351-Freeform
 |  |  |  |  | KX5-Slider Remix |  | UX280 |  | W385-Grey |  |  |  |  |  |  |  | R470-2 Step B
 |  |  |  |  | KX9-Milan |  | UX300 |  | W385-Plum |  |  |  |  |  |  |  | R470-2 Step O
 |  |  |  |  |  |  | UX310-Helix |  | W845-Quantico |  |  |  |  |  |  |  | R470-2 Step P
 |  |  |  |  |  |  | UX3300 |  | W845-Quantico Safron |  |  |  |  |  |  |  | R470-2 Step R
 |  |  |  |  |  |  | UX380 |  | Z6m-ROKR |  |  |  |  |  |  |  | R500
 |  |  |  |  |  |  | UX390 |  |  |  |  |  |  |  |  |  | R580-Profile
 |  |  |  |  |  |  | UX565 |  |  |  |  |  |  |  |  |  | R610
 |  |  |  |  |  |  | UX585 |  |  |  |  |  |  |  |  |  | R630-Messager
 |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | R800-Delve
 |  |  |  |  |  |  | UX830 |  |  |  |  |  |  |  |  |  | R850-Caliber
 |  |  |  |  |  |  | UX840-Tritan |  |  |  |  |  |  |  |  |  | R880-Acclaim
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | u340
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | u440-Gloss G
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | u440-Gloss P
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | u520
Spreadsheet: bfd71e09-b058-48b1-81db-fd648fe10922
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Wines offered in GBP per case of 12 bottles, 24 half-bottles or 6 magnums, unless otherwise indicated. 24 November 2014.  Wines lying in bond at London City Bond. E&O.E.  Prices exclude duty and VAT.  For all enquiries, please contact us at [EMAIL]
Region | Producer | Vintage | Wine | Condition | Cs | Bt | GBP Sell | Per | Size | Units | GBP/bt
Dry White Bordeaux | - | 2012 | Carbonnieux Blanc | - | 20 | - | 200 | CS | 75cl | 240 | 16.67
Dry White Bordeaux | - | 2010 | Carbonnieux Blanc | - | 2 | - | 240 | CS | 75cl | 24 | 20
Dry White Bordeaux | - | 2005 | Domaine de Chevalier Blanc | - | 1 | - | 580 | CS | 75cl | 12 | 48.33
Dry White Bordeaux | - | 1999 | Domaine de Chevalier Blanc | - | 1 | - | 450 | CS | 75cl | 12 | 37.5
Dry White Bordeaux | - | 2005 | Lynch Bages Blanc | - | 1 | - | 315 | CS | 75cl | 12 | 26.25
Dry White Bordeaux | - | 2005 | [NAME] | - | - | 6 | 450 | CS | 75cl | 6 | 37.5
Dry White Bordeaux | - | 2012 | Smith Haut Lafitte Blanc | - | 2 | - | 590 | CS | 75cl | 24 | 49.17
Dry White Bordeaux | - | 2006 | Smith Haut Lafitte Blanc | - | 1 | - | 475 | CS | 75cl | 12 | 39.58
Dry White Bordeaux | - | 2013 | Ygrec | - | 8 | - | 980 | CS | 75cl | 96 | 81.67
Spreadsheet: 102047d1300114999-data-filtering-advancedfilter20
Sheet: Sheet1

stuff
(6,1) | 1
(7,1) | 1
(9,1) | 1
(1,6)
(1,9)
(2,2) | 1
(2,2)
(2,2)
(8,1) | 1
(7,2) | 1
(1,8)
(1,6) | 0
(2,2) | 0
(1,15) | 1
(15,1) | 1
Spreadsheet: 492476d1481115053-spreadsheet-to-automatically-list-weather-extreme-dates-december-2016
Sheet: Summary

Month
Mn/Tot
[NAME]
Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | on this row, the formulas I have coloured blue are returning incorrect values
Min
Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | this row of formulas are returning expected values
 | Temperature |  |  | Rain |  | Wind |  |  |  |  |  | 0900 GMT
Date | [NAME] | Min | Mean | [NAME] | [NAME] | Mn Spd | Mx Mean | [NAME] | [NAME] | [NAME] |  |  |  | Wind
Period | 09-09 |  |  | 09-09 |  | 0-24 |  |  |  | 09-09 |  | Temp | Hum | Spd | Dir | Pres
Spreadsheet: 692527d1598414264-monthly-summary-help-summary-help
Sheet: Daily Sales

Delivery No | # | Customer | Date | Total
Delivery 1 | R 35734 | iCare | 2020-07-09 00:00:00 | 462.1
Delivery 2 | R 36146 | iCare | 2020-07-15 00:00:00 | 314.29
Delivery 4 | R 36154 | City Hotel | 2020-07-23 00:00:00 | 258.1
Delivery 5 | R36946 | iCare | 2020-07-28 00:00:00 | 465.75
Delivery 6 | R37423 | iCare | 2020-08-03 00:00:00 | 329.06
 | R37683 | iCare | 2020-08-03 00:00:00 | 305.68
 | R38162 | iCare | 2020-08-03 00:00:00 | 405
Delivery 7 | R38205 | iCare | 2020-08-04 00:00:00 | 598.7
 | R38184 | City Hotel | 2020-08-04 00:00:00 | 503.79
Delivery 8 | R38451 | iCare | 2020-08-07 00:00:00 | 2121.4
Delivery 9 | R25943 | iCare | 2020-08-11 00:00:00 | 5730
Delivery 10 | R38950 | iCare | 2020-08-11 00:00:00 | 640.87
 | R39408 | City Hotel | 2020-08-11 00:00:00 | 872.88
Delivery 11 | R 38953 | iCare | 2020-08-16 00:00:00 | 565.87
Delivery 12 | R39928 | iCare | 2020-08-17 00:00:00 | 320.5
Delivery 13 | R40070 | iCare | 2020-08-20 00:00:00 | 1061.83
 | R40175 | iCare | 2020-08-20 00:00:00 | 582.89
Delivery 14 | R40235 | City Hotel | 2020-08-22 00:00:00 | 432.25
 | R40472 | iCare | 2020-08-22 00:00:00 | 569.24
 | R40738 | iCare | 2020-08-22 00:00:00 | 439.65
Delivery 15 | R25955 | iCare | 2020-08-23 00:00:00 | 1250.71
Spreadsheet: 785091d1656143136-status-based-on-multiple-date-entries-test-book-statement-based-on-date-entry
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | This data to be based on date in A1
Status | Ref Number | Date received | Start Date | Completion Date |  |  |  |  | Cell Ref | data entered into cell | Status requirements in Cell A5
 |  |  |  |  |  |  |  |  | B5 | empty | empty
 |  |  |  |  |  |  |  |  | B5 | anything | Insert more data
 |  |  |  |  |  |  |  |  | C5 | date entry | Outstanding
 |  |  |  |  |  |  |  |  | D5 | date entry | In Progress
 |  |  |  |  |  |  |  |  | E5 | date entry | Completed
Spreadsheet: 732972d1621343733-extract-data-with-dependent-dropdown-from-multiple-tables-engine_workbook
Sheet: BOM-Searchbar

BOM-Search
 |  | Select engine type: | Engine_A
 |  | Select specific engine: | A144_Gas
Engine Type |  |  |  |  | level | type | components | description | quantity
A033_Diesel
A055_Diesel
A122_Gas
A144_Gas
A245_Fuel
A288_Fuel
A290_Fuel
A288_Fuel
A290_Fuel
A322_Electric
A366_Electric
Spreadsheet: 02e4e8cb-1d16-4c59-8b6b-45e4f184d7ce
Sheet: Sheet1

The City of Albuquerque Parks & Recreation Department | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
2013 Indoor Track & Field Season Schedule
Day | Date | Event Title | Start Time | End Time | Event Information
Friday | 2012-01-18 00:00:00 | Cherry & Silver Invitational | 3:00pm | 10:00pm | The University of New Mexico Official Athletic Site
Saturday | 2012-01-19 00:00:00 | Cherry & Silver Invitational | 9:00am | 6:00pm | The University of New Mexico Official Athletic Site
Saturday | 2012-01-19 00:00:00 | Open/Age Group | 6:00pm | 9:00pm | The University of New Mexico Official Athletic Site
Friday | 2012-01-25 00:00:00 | New Mexico Invitational | 3:00pm | 10:00pm | The University of New Mexico Official Athletic Site
Saturday | 2012-01-26 00:00:00 | New Mexico Invitational | 9:00am | 6:00pm | The University of New Mexico Official Athletic Site
Saturday | 2012-01-26 00:00:00 | Open/Age Group | 6:00pm | 9:00pm | The University of New Mexico Official Athletic Site
Friday | 2012-02-01 00:00:00 | New Mexico Classic and Combined Event (Heptathlon & Pentathlon) | 9:00am | 10:00pm | The University of New Mexico Official Athletic Site
Saturday | 2012-02-02 00:00:00 | New Mexico Classic and Combined Event (Heptathlon & Pentathlon) | 9:00am | 6:00pm | The University of New Mexico Official Athletic Site
Friday | 2012-02-08 00:00:00 | [NAME] | 3:00pm | 11:00pm | The University of New Mexico Official Athletic Site
Saturday | 2012-02-09 00:00:00 | [NAME] | 9:00am | 6:00pm | The University of New Mexico Official Athletic Site
Sunday | 2012-02-10 00:00:00 | 4th Annual Mayor's Invitational - New Mexico Special Olympics Championships | 10:00am | 2:00pm | Special Olympics NM - Special Olympics NM
Saturday | 2012-02-16 00:00:00 | Great Southwest T & F Corporate Cup | 8:00am | 3:00pm | Home | Great Southwest Track & Field Classic
Saturday | 2012-02-16 00:00:00 | Great Southwest High School Indoor Classic | 6:00pm | 10:00pm | Home | Great Southwest Track & Field Classic
Thursday | 2012-02-21 00:00:00 | Western Athletic Conference Championships | 11:00am | 6:00pm | http://www.wacsports.com/share/PollRecord.dbml
Friday | 2012-02-22 00:00:00 | Western Athletic Conference Championships | 11:00am | 6:00pm | http://www.wacsports.com/share/PollRecord.dbml
Saturday | 2012-02-23 00:00:00 | Western Athletic Conference Championships | 9:30am | 2:30pm | http://www.wacsports.com/share/PollRecord.dbml
Saturday | 2012-03-02 00:00:00 | USA Indoor Championships | 5:00pm | 9:00pm | USA Track & Field - Home
Sunday | 2012-03-03 00:00:00 | USA Indoor Championships | 10:00am | 5:00pm | USA Track & Field - Home
Spreadsheet: 5a661baf-4d33-4096-a904-6127d7a205d5
Sheet: Sheet1

Table S7.  General linear models of non-structural carbohydrate concentrations in a drier site, [NAME], and a wetter site, Santa Rosa, with site and season as fixed effects. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Fixed effects | DF | [NAME] | P-value
Main stems
Total Nonstructural Carbohydrates
Site | 1 | 0.08 | 0.78
Season | 2 | 2.37 | 0.11
Site × Season | 2 | 0.45 | 0.64
Starch
Site | 1 | 0.06 | 0.81
Season | 2 | 2.25 | 0.12
Site × Season | 2 | 2.95 | 0.06
Sucrose
Site | 1 | 0.98 | 0.33
Season | 2 | 3.75 | 0.04
Site × Season | 2 | 2.05 | 0.14
[NAME]
Total Nonstructural Carbohydrates
Site | 1 | 0.93 | 0.34
Season | 2 | 17.45 | 0.0001
Site × Season | 2 | 6.37 | 0.005
Starch
Site | 1 | 1.01 | 0.32
Season | 2 | 16.21 | 0.0001
Site × Season | 2 | 8.17 | 0.002
Sucrose
Site | 1 | 0.05 | 0.83
Season | 2 | 14.26 | 0.0001
Site × Season | 2 | 3.14 | 0.06
Significant effects are in bold; shaded lines indicate significant or marginally significant effects arising from late-dry-season differences in main stems and late-rainy/early-dry-season differences in twigs (see Table S6).
Spreadsheet: 152568d1335439822-vlook-ups-help-please-fte-2-
Sheet: Sheet1

Names | Dates | FTE
fffdf | 2009-01-02 00:00:00 | 37.5
ddd | 2009-12-01 00:00:00 | 37.5
fffdf | 2011-07-25 00:00:00 | 37.5 | I would like to have | 2011-10-03 00:00:00
ddfd | 2011-10-03 00:00:00 | 22
 | 2011-10-03 00:00:00 | 37.5
 | 2011-10-03 00:00:00 | 37.5
 | 2011-10-03 00:00:00 | 37.5
 | 2011-10-03 00:00:00 | 37.5
 | 2011-10-03 00:00:00 | 37.5
 | 2011-10-17 00:00:00 | 37.5
 | 2011-10-17 00:00:00 | 37.5
 | 2011-10-17 00:00:00 | 37.5
 | 2011-10-17 00:00:00 | 37.5
 | 2011-10-31 00:00:00 | 30.5
 | 2011-10-31 00:00:00 | 37.5
 | 2011-10-31 00:00:00 | 37.5
 | 2011-11-28 00:00:00 | 25.25
 | 2011-11-28 00:00:00 | 25.25
 | 2011-11-28 00:00:00 | 37.5
 | 2011-11-28 00:00:00 | 37.5
 | 2011-11-28 00:00:00 | 37.5
 | 2011-11-28 00:00:00 | 37.5
 | 2011-11-28 00:00:00 | 37.5
 | 2012-01-09 00:00:00 | 37.5
 | 2012-01-09 00:00:00 | 37.5
 | 2012-01-09 00:00:00 | 37.5
 | 2012-01-09 00:00:00 | 37.5
 | 2012-01-09 00:00:00 | 37.5