tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 762021d1641357703-forecast-with-vlookup-landing-distance-update-2-
Sheet: Sheet3

 | LDG weight | 59400 |  | Weight Correction |  |  | kgs
 | elevation | 3000 |  |  |  |  | meters |  |  |  |  |  | Manual | Conf 3 | Dry | Yes
 | Temp | 30 |  |  |  |  |  |  |  |  |  |  | AB MED | Full | Good | No
 | LDG CONF | Full |  |  |  |  |  |  |  |  |  |  | AB LOW
 | Brake mode | Manual |  |  |  | Safety Factor
 | Slope | -0.7 |  |  |  | 1.15
 | RWY COND | Dry
 | Both Rev working | Yes
 | Vapp Correction
 | 5 KT | 1/3 headwind (excluding gust) [NAME] = 15 kt |  |  |  | Required Landing Distance
 | Whichever is Higher
 | 5 | 3
 | ISA DEV
 |  | Dry
 |  | Corrections on Landing Distance |  |  | Weight | [NAME] | Altitude | Temp | Slope | Reversers
 |  | [NAME] | LDG CONF | Ref Dist (m) for 66T | Per 1T below 66T | Per 5kt | Per 1000ft above SL | Per 10°C above ISA | Per 1% Down Slope | Per Reverser Working
 |  | Manual | Conf 3 | 1130 | -10 | 80 | 50 | 40 | 20 | -20
 |  | Manual | Full | 1080 | -10 | 60 | 40 | 30 | 20 | -20
 |  | AB MED | Conf 3 | 1420 | -10 | 100 | 50 | 50 | 10 | 0
 |  | AB MED | Full | 1360 | -10 | 90 | 50 | 40 | 10 | 0
 |  | AB LOW | Conf 3 | 2030 | -10 | 150 | 80 | 70 | 30 | -10
 |  | AB LOW | Full | 1930 | -10 | 130 | 80 | 60 | 20 | -10
 |  | Braking Mode | LDG CONF | Ref Dist (m) for 66T | Per 1T below 66T | Per 5kt | Per 1000ft above SL | Per 10°C above ISA | Per 1% Down Slope | Per Thrust Reverser Ops |  | Final
 |  |  |  |  |  |  |  |  |  |  |  | result
 |  |  |  |  |  |  |  |  | 20
 |  | Good
 |  | Corrections on Landing Distance |  |  | Weight | [NAME] | Altitude | Temp | Slope | Reversers
 |  | [NAME] | LDG CONF | Ref Dist (m) for 66T | Per 1T below 66T | Per 5kt | Per 1000ft above SL | Per 10°C above ISA | Per 1% Down Slope | Per Reverser Working
 |  | Manual | Conf 3 | 1480 | -20 | 120 | 80 | 70 | 60 | -60
 |  | Manual | Full | 1370 | -10 | 100 | 70 | 60 | 40 | -50
 |  | AB MED | Conf 3 | 1540 | -20 | 120 | 80 | 70 | 60 | -30
 |  | AB MED | Full | 1420 | -10 | 110 | 70 | 60 | 40 | -10
 |  | AB LOW | Conf 3 | 2030 | -20 | 150 | 80 | 70 | 30 | -10
 |  | AB LOW | Full | 1930 | -10 | 130 | 80 | 60 | 20 | -10
 |  | Braking Mode | LDG CONF | Ref Dist (m) for 66T | Per 1T below 66T | Per 5kt | Per 1000ft above SL | Per 10°C above ISA | Per 1% Down Slope | Per Thrust Reverser Ops |  | Final
 |  |  |  |  |  |  |  |  |  |  |  | result
 |  |  |  |  |  |  |  |  | 40
 |  |  | Braking Mode
 |  | DRY | Manual |  | AB MED |  | AB LOW
 |  |  | Conf 3 | Full | Conf 3 | Full | Conf 3 | Full
 | Corrections on Landing Distance | Ref Dist (m) for 66T | 1130 | 1080 | 1420 | 1360 | 2030 | 1930
 |  | Per 1T below 66T | -10 | -10 | -10 | -10 | -10 | -10
 |  | Vapp speed Per 5kt | 80 | 60 | 100 | 90 | 150 | 130
 |  | Per 1000ft | 50 | 40 | 50 | 50 | 80 | 80
 |  | Per 10°C above ISA | 40 | 30 | 50 | 40 | 70 | 60
 |  | Per 1% Down Slope | 20 | 20 | 10 | 10 | 30 | 20
 |  | Per Reverser Working | -20 | -20 | 0 | 0 | -10 | -10
Spreadsheet: 1d3c072b-33c1-4414-a422-c9b9a70812c6
Sheet: Sheet1

Table 5--USDA-calculated world market rice prices (rough basis) 1/ | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
 | 2013/14 |  |  | 2012/13 |  |  | 2011/12
 |  | Medium/ |  |  | Medium/ |  |  | Medium/
Month | Long | short |  | Long | short |  | Long | short
 | $/cwt
August | 12.08 | 12.43 |  | 11.91 | 12.13 |  | 14.08 | 14.4
September | 11.87 | 12.22 |  | 12.57 | 12.81 |  | 15.09 | 15.44
October | 11.95 | 12.3 |  | 12.72 | 12.97 |  | 15.63 | 15.99
November | 11.78 | 12.13 |  | 12.92 | 13.17 |  | 14.93 | 15.28
December  2/ | 11.83 | 12.19 |  | 12.62 | 12.86 |  | 13.9 | 14.21
January |  |  |  | 12.35 | 12.59 |  | 12.61 | 12.88
February |  |  |  | 11.77 | 12.43 |  | 11.81 | 12.2
March |  |  |  | 12.16 | 12.84 |  | 11.52 | 11.92
April |  |  |  | 12.18 | 12.86 |  | 11.15 | 11.54
May |  |  |  | 12.08 | 12.75 |  | 11.42 | 11.82
June |  |  |  | 12.17 | 12.85 |  | 11.93 | 12.35
July |  |  |  | 12.18 | 12.86 |  | 11.97 | 12.4
Market-year
average 1/ | 11.902 | 12.254 |  | 12.3025 | 12.76 |  | 13.00333333333334 | 13.36916666666666
1/ Simple average of the U.S. Department of Agriculture's weekly adjusted world market price.  2/  Preliminary.
Source: [NAME] and Rice Weekly Prices (ftp://ftp.fsa.usda.gov/public/cotton/default.htm), Farm Service Agency, USDA.
Last updated December 10, 2013.
Spreadsheet: 71e21678-bea8-48cb-acc1-8b72a2dee93c
Sheet: Sheet1

Table 6--Wheat: National average prices received by farmers by class (dollars per bushel), 1/14/2014 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Month | Hard red winter |  | Soft red winter |  | Hard red spring |  | White
 | 2012/13 | 2013/14 | 2012/13 | 2013/14 | 2012/13 | 2013/14 | 2012/13 | 2013/14
June | 6.53 | 7.35 | 6.59 | 6.92 | 7.81 | 7.73 | 6.61 | 7.29
July | 7.74 | 7.04 | 7.84 | 6.55 | 8.41 | 7.29 | 7.76 | 7.19
August | 7.97 | 6.94 | 8.3 | 6.34 | 8.32 | 6.98 | 7.66 | 6.9
September | 8.36 | 6.92 | 8.38 | 6.19 | 8.42 | 6.72 | 7.99 | 6.71
October | 8.43 | 7.24 | 8.35 | 6.66 | 8.6 | 6.85 | 8.1 | 6.76
November | 8.49 | 7.1 | 8.34 | 6.63 | 8.69 | 6.7 | 8.14 | 6.76
December | 8.2 |  | 8.19 |  | 8.5 |  | 7.99
January | 8.02 |  | 7.9 |  | 8.38 |  | 8.03
February | 7.75 |  | 7.78 |  | 8.11 |  | 8.05
March | 7.5 |  | 7.46 |  | 7.94 |  | 8.05
April | 7.49 |  | 7.42 |  | 7.91 |  | 7.71
May | 7.56 |  | 7.31 |  | 7.86 |  | 7.42
Source: USDA, National Agricultural Statistics Service, Agricultural Prices.
Date run: 1/13/2014
Spreadsheet: 2a2748b5-d80d-4f64-9aaf-796d18f8db3f
Sheet: EPP Admission

Content | Addmitted 2.5 | Admitted 2.75 | Not Admitted | Retintion
4-8 Generalist | 13 | 11 | 2 | 0.84
Ag Science | 13 | 13 | 0 | 1
Art | 2 | 2 | 0 | 1
Chemistry | 3 | 2 | 1 | 0.66
Communication | 5 | 3 | 2 | 0.6
[NAME] | 113 | 82 | 31 | 0.72
English | 15 | 13 | 2 | 0.86
History | 29 | 13 | 16 | 0.44
Life Science | 1 | 1 | 0 | 1
Math | 13 | 10 | 3 | 0.76
Music | 9 | 8 | 1 | 0.88
Social Studies | 3 | 2 | 1 | 0.66
Spanish | 2 | 1 | 1 | 0.5
Theatre | 4 | 2 | 2 | 0.5
Total | 225 | 163 | 62 | 0.72
Spreadsheet: a731c7fa-88ff-495e-b6cc-c50cc319e3d5
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
SBWE | Test | SBWE | [NAME], IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
SBWE | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
SBWE | Result | SBWE | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 7147-2 | Beta [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: joe_parks__14551__Cornhusker contacts
Sheet: Sheet1

Apache |  |  |  |  | [NAME]
[NAME] |  | [PHONE] |  |  | EB 2483A |  | [PHONE] fax
 |  | [PHONE] fax
[NAME]) |  |  |  |  | Mirant (Agent for Brazos)
[NAME] |  | [PHONE] |  |  | [NAME] |  | [PHONE]
 |  | [PHONE] fax |  |  |  |  | [PHONE] pgr
 |  |  |  |  | [NAME] |  | [PHONE]
[NAME]
[NAME] |  | [PHONE]
[NAME] |  | [PHONE]
 |  | [PHONE] fax
[NAME] (Agent for Apache)
[NAME] |  | [PHONE]
 |  | 281-665-7521pgr
[NAME] |  | [PHONE]
 |  | [PHONE] fax
White Pine Energy
[NAME]--Director of Asset Mgmt
 |  | [PHONE]
 |  | [PHONE] fax
 |  | [PHONE] cell
[NAME]--Tenaska IV
[NAME] |  | [PHONE]
[NAME] |  | same
 |  | [PHONE] fax
Spreadsheet: 69853d1270541088-pulling-info-out-of-an-old-layout-oct-08
Sheet: 10-15-08 2nd

Daily Problem Report |  |  |  |  |  | 2nd shift |  | Date |  | 2008-10-15 00:00:00
 |  | Daily cases |  | Daily hours |  | Daily Avg Per Month |  | Note
ER |  | 4 |  | 1 |  | 3.82
PR |  | 1 |  |  |  | 2.09
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
PR |  | 5-2 | 57675/6-08010-00 |  | Problem: Strip folded |  |  | Station:prog |  | Ran:0           of       825 | 0.25
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause: | Misfeed |  |  | 11:30-11:45
 |  |  |  |  | Explain: | Pilot pin was stuck in the lower ,it could not be removed ,so this was pulled to the shop for repairs. |  |  |  |  | [NAME]
Stamping T/L: Adam D
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
ER / PR |  | Line # | Die # |  | Machine / Die Problem |  |  |  |  |  | Down time (hrs)
 |  |  |  |  | Problem: |  |  | Station: |  | Ran:
Human Problem |  |  | Last PM: |  | Machine | Die | Root Cause:
 |  |  |  |  | Explain:
Stamping T/L:
Misc.Notes:
Spreadsheet: 826833d1682316384-nested-if-to-pull-most-recent-dates-attendance-tracker-4-22-23-sample
Sheet: Occurrences

[NAME]
Associate: | [NAME], [NAME] |  | Date Prepared:
Total Points: |  | Level:
Last Accountability Issue Date: |  |  | Expiration Date:
 |  | 2023-08-03 00:00:00 |  | Stop - Final
Date | ID# | Employee ID | Associate Name | Occ. Type | WLB Hours | Age (Days old) | Points | Notes
2022-11-02 00:00:00 | 999999 |  |  | Absent - Failure to Report
2022-11-15 00:00:00 | 111115 |  |  | Absent - Failure to Report
2022-12-01 00:00:00 | 111111 |  |  | Absent - Failure to Report
2022-12-02 00:00:00 | 999999 |  |  | Absent - Failure to Report
2022-12-15 00:00:00 | 555555 |  |  | Early Quit - Worked LESS than 1/2 Scheduled Day
2022-12-15 00:00:00 | 111115 |  |  | Absent - Failure to Report
2023-01-01 00:00:00 | 111111 |  |  | Tardy
2023-01-15 00:00:00 | 777777 |  |  | WLBD | 2
2023-01-15 00:00:00 | 111115 |  |  | Absent
2023-01-17 00:00:00 | 777777 |  |  | WLBD2 | 2
2023-02-01 00:00:00 | 111111 |  |  | Tardy
2023-02-02 00:00:00 | 999999 |  |  | Absent
2023-02-03 00:00:00 | 111119 |  |  | Absent - Failure to Report
2023-02-04 00:00:00 | 111119 |  |  | Absent
2023-03-01 00:00:00 | 999999 |  |  | Absent
2023-03-01 00:00:00 | 777777 |  |  | Tardy
2023-03-20 00:00:00 | 111114 |  |  | WLBD | 6
2023-03-23 00:00:00 | 111111 |  |  | WLBD | 8
2023-03-29 00:00:00 | 111123 |  |  | WLBD | 8
Spreadsheet: 153225d1335808721-making-a-schedule-with-auto-time-format-and-adding-total-hours-se-schedule
Sheet: August 22

 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 | 2011-08-22 00:00:00 | 2011-08-23 00:00:00 | 2011-08-24 00:00:00 | 2011-08-25 00:00:00 | 2011-08-26 00:00:00 | 2011-08-27 00:00:00
[NAME] |  | 8:30-5:30 | 8:00-5:00 | 9:00-5:00 | 8:30-5:30 | 9:15-5:15
 | off | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00
[NAME] | 8:30-5:30 | 9:30-5:30 | 9:30-5:30 | 9:30-5:30 | 8:30-12:30 | off
 | 2:00-3:00 | 2:00-3:00 | 2:00-3:00 | 2:00-3:00 | n/l
Ray | 8:00-5:00 | 8:00-5:00 | 8:00-4:00 | 7:00-4:00 | off | 9:00-5:00
 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 |  | 1:00-2:00
Mark | 8:30-5:30 | 9:00-5:00 | 8:30-5:30 | 8:30-5:30 | 8:00-5:00
 | 1:00-2:00 | 1:00-2:00 | 1:00-2:00 | 1:00-2:00 | 1:00-2:00
[NAME] | 8:00-4:00 | off | 8:30-5:30 | 7:00-4:00-HOMER | 9:30-5:30-counter | 9:15-5:15
ctr 12-2 | 11:00-12:00 |  | 11:00-12:00 | 12:00-1:00 | 11:00-12:00 | 11:00-12:00
Kat |  |  | 8:00-5:00 |  |  | 9:15-5:15
 |  |  | 12:00-1:00 |  |  | 12:00-1:00
 |  |  | 12:00-1:00 |  |  | 12:00-1:00
 |  |  |  |  |  | total hours
Spreadsheet: 599890d1543349033-need-help-with-a-running-percentage-of-a-percentage-excel-q1
Sheet: Sheet1

 |  |  | Safety walks | Training Compliance (>90%) | HSNO compliance (Y/N) | Committee Compliance (Y/N) | Compliant (%) | YTD Accumulative (%)
 | Actual
June | Target |  | 2 | 0.9 | 1 | 1
 | Variants to target
YTD | Target |  | 2 | 0.9 | 1 | 1
 | Variants to target
 | Actual
July | Target |  | 2 | 0.9 | 1 | 1
 | Variants to target
YTD | Target |  | 4 | 0.9 | 2 | 2
 | Variants to target
 | Actual
August | Target |  | 2 | 0.9 | 1 | 1
 | Variants to target
YTD | Target |  | 6 | 0.9 | 3 | 3
 | Variants to target
 | Actual
September | Target |  | 2 | 0.9 | 1 | 1
 | Variants to target
YTD | Target |  | 8 | 0.9 | 4 | 4
 | Variants to target
 | Actual
October | Target |  | 2 | 0.9 | 1 | 1
 | Variants to target
YTD | Target |  | 10 | 0.9 | 5 | 5
 | Variants to target
 | Actual
November | Target |  | 2 | 0.9 | 1 | 1
 | Variants to target
YTD | Target |  | 12 | 0.9 | 6 | 6
 | Variants to target
 | Actual
December | Target |  | 2 | 0.9 | 1 | 1
 | Variants to target
YTD | Target |  | 14 | 0.9 | 7 | 7
 | Variants to target
Spreadsheet: 219082d1362663861-formula-for-changing-numbers-runningtotal
Sheet: Sheet1

Event | Item | Qty | Qty Used | Qty Left |  |  |  |  |  |  | Item | Stock | Left
1 | [NAME] |  | 10 |  |  |  |  |  |  |  | [NAME] | 100
2 | [NAME] |  | 30 |  |  |  |  |  |  |  | [NAME] | 500
3 | [NAME] |  | 100 |  |  |  |  |  |  |  | [NAME] | 300
4 | [NAME]
5 | [NAME]
6 | [NAME]
Spreadsheet: 783305d1654716046-hlookup-w-indirect-and-match-test3
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Year | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021
 | State Code
 | AK
 | AL
 | AR
 | AZ
 | CA
 | CO
 | CT
 | DE
 | DC
 | FL
 | GA
 | HI
 | IA
 | ID
 | IL
 | IN
 | KS
 | KY
 | LA
 | MA
 | MD
 | ME
 | MI
 | MN
 | MO
 | MS
 | MT
 | NC
 | ND
 | NE
 | NH
 | NJ
 | NM
 | NV
 | NY
 | OH
 | OK
 | OR
 | PA
 | RI
 | SC
 | SD
 | TN
 | TX
 | UT
 | VA
 | VT
 | WA
 | WI
 | WV
 | WY
Spreadsheet: 831267d1685531403-index-match-on-multiple-results-try1-ans
Sheet: Discount % Approved

[NAME] | Discount Type | % | Customer Name | Date Approved |  | Helper Column
Spreadsheet: 856804d1705997865-how-to-compare-2-lists-with-a-partial-matches-example-187-aligw
Sheet: גיליון1

Country name | Group name | Country |  | AliGW
Brazil | Bolivia
Fiji | Bolivia-Mobile
Gambia | Brazil | Brazil
Guam | Brazil-Mobile | Brazil
Haiti | Germany
India | Germany-Mobile
Indonesia | India | India
Maldives | India-Mobile | India
Mexico | Indonesia | Indonesia
 | Indonesia-Mobile | Indonesia
 | Maldives | Maldives
 | Maldives-Mobile | Maldives
 | Malta
 | Malta-Mobile
 | [NAME]
 | Mauritius-Mobile
 | Mexico | Mexico
 | Mexico-Mobile | Mexico
Spreadsheet: kate_symes__19020__NP 15 pages
Sheet: DJ NP15

 |  |  | Firm | Volume | Firm | Volume | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-04-04 00:00:00 |  | 278.5 | 35776 | 210.79 | 9432
 | 2001-04-03 00:00:00 |  | 245.99 | 21936 | 136.34 | 7512
 | 2001-04-02 00:00:00 |  | 228.71 | 17360 | 140.68 | 5000
 | 2001-04-01 00:00:00 |  |  |  |  |  | 142.24 | 15000
 | 2001-03-31 00:00:00 |  | 181.02 | 24000 | 93.46 | 3640
 | 2001-03-30 00:00:00 |  | 181.94 | 20800 | 93.46 | 3640
 | 2001-03-29 00:00:00 |  | 178.38 | 28864 | 87.16 | 10496
 | 2001-03-28 00:00:00 |  | 142.39 | 35120 | 78.18 | 4400
 | 2001-03-27 00:00:00 |  | 140.58 | 29520 | 76.2 | 4000
 | 2001-03-26 00:00:00 |  | 266.09 | 24560 | 155.06 | 6160
 | 2001-03-25 00:00:00 |  |  |  |  |  | 153.65 | 16680
 | 2001-03-24 00:00:00 |  | 270.02 | 21120 | 152.5 | 5840
 | 2001-03-23 00:00:00 |  | 270.02 | 21120 | 152.5 | 5840
 | 2001-03-22 00:00:00 |  | 294.15 | 12720 | 177.94 | 7200
 | 2001-03-21 00:00:00 |  | 406.47 | 10320 | 234.87 | 5400
 | 2001-03-20 00:00:00 |  | 391.63 | 25920 | 261.33 | 9000
 | 2001-03-19 00:00:00 |  | 362.59 | 19760 | 274.08 | 10440
 | 2001-03-18 00:00:00 |  |  |  |  |  | 262.23 | 32520
 | 2001-03-17 00:00:00 |  | 237.03 | 39120 | 176.44 | 8200
 | 2001-03-16 00:00:00 |  | 238.66 | 44720 | 176.44 | 8200
 | 2001-03-15 00:00:00 |  | 190.53 | 14720 | 144.42 | 7600
 | 2001-03-14 00:00:00 |  | 177.21 | 17120 | 139.11 | 8840
 | 2001-03-13 00:00:00 |  | 178.33 | 18000 | 141.6 | 9400
 | 2001-03-12 00:00:00 |  | 207.12 | 14000 | 167.55 | 6200
 | 2001-03-11 00:00:00 |  |  |  |  |  | 167.57 | 18000
 | 2001-03-10 00:00:00 |  | 189.97 | 30000 | 155.94 | 17200
 | 2001-03-09 00:00:00 |  | 189.87 | 30000 | 155.94 | 17200
 | 2001-03-08 00:00:00 |  | 229.83 | 26400 | 158.24 | 4200
 | 2001-03-07 00:00:00 |  | 340.07 | 30160 | 231.96 | 15000
 | 2001-03-06 00:00:00 |  | 362.98 | 29744 | 264.17 | 13200
 | 2001-03-05 00:00:00 |  | 340.79 | 20544 | 261.21 | 8664
Spreadsheet: 98700d1297545583-vlookup-or-other-formula-to-return-data-given-criteria-call
Sheet: Sheet1

Start | End | Date | No |  |  | 2011-02-01 00:00:00 | 2011-02-02 00:00:00
00:30:00 | 01:00:00 | 2011-02-01 00:00:00 | 15 | 00:30:00 | 01:00:00
01:30:00 | 02:00:00 | 2011-02-01 00:00:00 | 14 | 01:30:00 | 02:00:00
04:00:00 | 04:30:00 | 2011-02-01 00:00:00 | 15 | 04:00:00 | 04:30:00
05:00:00 | 05:30:00 | 2011-02-01 00:00:00 | 1 | 05:00:00 | 05:30:00
06:00:00 | 06:30:00 | 2011-02-01 00:00:00 | 8 | 06:00:00 | 06:30:00
06:30:00 | 07:00:00 | 2011-02-01 00:00:00 | 5 | 06:30:00 | 07:00:00
00:30:00 | 01:00:00 | 2011-02-02 00:00:00 | 5
01:30:00 | 02:00:00 | 2011-02-02 00:00:00 | 5
04:00:00 | 04:30:00 | 2011-02-02 00:00:00 | 4
05:00:00 | 05:30:00 | 2011-02-02 00:00:00 | 78
06:00:00 | 06:30:00 | 2011-02-02 00:00:00 | 112
06:30:00 | 07:00:00 | 2011-02-02 00:00:00 | 15
Need a formula to fill in values for table coloured in red, all the information is in the unhighlighted table on the left, the values we need are found in column titled No.  It is a must that in order for the value to be correct in the table coloured red, all fields start/end/date must match.
Spreadsheet: sally_beck__33762__Office Models
Sheet: Office Models

Key segregations of responsibility | Commercial |  |  |  |  |  |  |  |  |  |  |  |  | Commercial Support |  |  |  |  |  |  |  |  |  |  |  |  |  | Controls
 | Initiate commercial contact | Negotiate deal terms | Daily determine trading strategy | Daily decide on price range | Decide on price with in the daily set range | Commit the company to trades within specified price range | Commit the company to ancillary services (shipping, quality analysis etc) | Owns out of balance position | Sign-off on profit each day | Judged on profit of market position | Hedge out exposure taken though in house broker | Write deal ticket | Logistics: manage / organise shipping | Produce confirmations | Receive and reconcile confirmations | Receive, reconcile, and send logistics information | Prepare invoices | Receive and reconcile invoices | Cash management | Risk Management | Trade Accounting | Internal & external reporting | Global Funding | Credit | Market Risk | Underwriting |  | Recorded 'phone lines | Minimum frequency of visits by Risk Management | Regular Doorstep review
Trading Office | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y | Y |  | Y | N | Y
Agency Office | Y | Y | N | N | Y | Y | Y | N | N | N | Y | Y | Y | N | N | N | N | N | N | N | N | N | N | N | N | N |  | Y | B | Y
Origination Office | Y | Y | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N |  | N | Q | N
Logistics Office | N | N | N | N | N | N | Y | N | N | N | N | N | Y | N | N | N | N | N | N | N | N | N | N | N | N | N |  | N | N | N
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | Every other week
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q | Quarterly
Spreadsheet: 797022d1663674916-formula-for-finding-out-b2b-in-sports-schedule-schedexample-hd-1-
Sheet: Sheet1

07.10. 20:00 |  | Nashville Predators | San Jose Sharks
08.10. 20:00 |  | San Jose Sharks | Nashville Predators
12.10. 01:30 |  | New York Rangers | Tampa Bay Lightning
12.10. 04:00 |  | Los Angeles Kings | [NAME] Knights
13.10. 01:00 |  | Carolina Hurricanes | Columbus Blue Jackets
13.10. 01:00 |  | Montreal Canadiens | Toronto Maple Leafs
13.10. 01:00 |  | Washington Capitals | [NAME]
13.10. 03:30 |  | Colorado Avalanche | Chicago Blackhawks
13.10. 04:00 |  | Anaheim Ducks | [NAME]
13.10. 04:00 |  | Edmonton Oilers | [NAME]
14.10. 01:00 |  | Buffalo Sabres | Ottawa Senators
14.10. 01:00 |  | Philadelphia Flyers | New Jersey Devils
14.10. 01:00 |  | Pittsburgh Penguins | Arizona Coyotes
14.10. 01:30 |  | New York Islanders | Florida Panthers
14.10. 01:30 |  | Toronto Maple Leafs | Washington Capitals
14.10. 02:00 |  | Minnesota Wild | New York Rangers
14.10. 02:00 |  | Nashville Predators | Dallas Stars
14.10. 03:30 |  | Calgary Flames | Colorado Avalanche
14.10. 04:00 |  | [NAME] Knights | Chicago Blackhawks
14.10. 04:30 |  | Los Angeles Kings | [NAME]
15.10. 01:00 |  | Columbus Blue Jackets | Tampa Bay Lightning
15.10. 01:30 |  | Detroit Red Wings | Montreal Canadiens
15.10. 02:00 |  | Winnipeg Jets | New York Rangers
15.10. 04:30 |  | San Jose Sharks | Carolina Hurricanes
15.10. 19:00 |  | Buffalo Sabres | Florida Panthers
15.10. 22:00 |  | Philadelphia Flyers | [NAME]
16.10. 01:00 |  | [NAME] | Arizona Coyotes
16.10. 01:00 |  | New Jersey Devils | Detroit Red Wings
16.10. 01:00 |  | Pittsburgh Penguins | Tampa Bay Lightning
16.10. 01:00 |  | Toronto Maple Leafs | Ottawa Senators
16.10. 01:00 |  | Washington Capitals | Montreal Canadiens
16.10. 01:30 |  | New York Islanders | Anaheim Ducks
16.10. 02:00 |  | Dallas Stars | Nashville Predators
16.10. 02:00 |  | Minnesota Wild | Los Angeles Kings
16.10. 02:00 |  | St. Louis Blues | Columbus Blue Jackets
16.10. 04:00 |  | Edmonton Oilers | Calgary Flames
16.10. 04:00 |  | [NAME] | [NAME] Knights
16.10. 04:30 |  | San Jose Sharks | Chicago Blackhawks
Spreadsheet: 134355d1325247057-lookup-one-value-in-a-range-and-then-lookup-another-value-beneath-it-lookup-3-
Sheet: Sheet2

[NAME] | Car Type | Number Sold | Unit Price | Total Sales
Barnhill | Sedan | 5 | 2200 | 11000
 | Coupe | 4 | 1800 | 7200
Ingle | Sedan | 6 | 2300 | 13800
 | Coupe | 8 | 1700 | 13600
Jordan | Sedan | 3 | 2000 | 6000
 | Coupe | 1 | 1600 | 1600
Pica | Sedan | 9 | 2150 | 19350
 | Coupe | 5 | 1950 | 9750
Sanchez | Sedan | 6 | 2250 | 13500
 | Coupe | 8 | 2000 | 16000
 |  |  |  | #N/A