tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: tracy_geaccone__40401__GPM 101021  101073 Recalculation
Sheet: Jan 2000

KN Processing |  | GPM Agency Agreement |  |  | Prepared by [NAME]
Bushton Plant |  | TFDV Volume & Dollar Calculation
 |  | For
 |  | 2000-01-01 00:00:00
Contract #101021 |  |  | NNG Numbers |  |  | Oneok Numbers |  |  | Difference
 | Total Deliveries |  |  | 3527521 |  |  | 3535230
 |  | Deliveries to Inlet | 3389025 |  |  | 3389025
 |  | Deliveries to PVR
 |  | Non-Fuel Deliveries
 |  | Fuel Retention
 | Total Receipts |  | 3534474 |  |  | 3534387
 |  | [NAME] | 0.0445 |  |  | 0.0445
 |  | Less Fuel Retained
Transport Revenue [NAME]
Contract #101073
 | Total Deliveries |  |  | 1304727 |  |  | 1287034
 |  | Deliveries to Inlet | 0
 |  | Deliveries to PVR | 1250521 |  |  | 1233543
 |  | Non-Fuel Deliveries
 |  | Fuel Retention
 | Total Receipts |  |  |  |  | 1337630
 |  | [NAME] | 0.0445 |  |  | 0.0445
 |  | Less Fuel Retained
Transport Revenue [NAME]
 |  | Total Both Contracts
 |  | Index |  | 2.308 |  |  | 2.3135
 |  | Total Revenue Due
Total Revenue Billed |  | 101021
 |  | 101073
 |  |  |  |  |  |  | 39583.05
 |  | Amount Due NNG (GPM)
Charge given by NNG on prior reconciliation
 |  | Amount Due NNG (GPM)
Spreadsheet: 709406d1608290068-how-summing-between-ranges-ask-question
Sheet: Sheet1

Name | Location | Duration |  | Criteria
Ady | Bath | 10 |  | Ady
Ady | Watch | 13 |  | Play2
Ady | Eat | 23 |  | Play3
Ady | Play1 | 12
Ady | Study | 15
Ady | Eat | 23
Ady | Play2 | 12
Ady | Rest | 16
Ady | Pray | 40
Ady | Eat | 34
Ady | Go Out | 16
Ady | Eat | 34
Ady | Bath | 23
Ady | Play3 | 50
Ady | Sleep | 23
Spreadsheet: 776067d1649486174-moved-data-from-column-on-matching-identifier-daf-cardholders-with-access-levels-working-doc-aligw
Sheet: ACMACCGRP

LAST_NAME | FIRST_NAME | LOOP_NAME | NAME | EMPLOYEE_ID | Expr1 |  |  |  |  |  |  |  | LAST_NAME | FIRST_NAME | NAME | EMPLOYEE_ID | Expr1
- 1 | COACH | School 1 | Fitness 1 | 199 | 199 |  |  |  |  |  |  |  |  | COACH |  |  | 199
- 1 | COACH | School 2 | Fitnesss 2 | 199 | 199 |  |  |  |  |  |  |  | 1 | B |  | 200 | 200
1 | B | School 1 | Fitness 3 | 200 | 200
1 | B | School 2 | Fitnesss 4 | 200 | 200
Workman | [NAME] | Ovid-Elsie Middle School | OEMS Maintenance | 34 | 34
Wregglesworth | [NAME] | Bus Garage | Bus Garage Unlimited Access | 420 | 420
Wyn | [NAME] | [NAME] | [NAME] and Staff | 110 | 110
[NAME] | [NAME] | [NAME] | EEK Teachers and Staff | 542 | 542
[NAME] | [NAME] | [NAME] | [NAME] and Staff | 542 | 542
[NAME] | [NAME] | Bus Garage | Bus Garage Unlimited Access | 50 | 50
[NAME] | [NAME] | [NAME] | ** NO ACCESS GROUP ** | 50 | 50
[NAME] | [NAME] | [NAME] | [NAME] | 126 | 126
Spreadsheet: 767745d1644602275-counting-text-cells-with-duplicates-based-on-multi-base-criteria-count-distinct-dates-associated-with-distinct-conditions-tmains-
Sheet: Sample1

 | System | Date |  |  | System | Total Calendar Days Count
 | CLNC 1 | 2020-10-23 00:00:00
 | CLNC 1 | 2020-10-26 00:00:00
 | CLNC 1 | 2020-10-27 00:00:00
 | CLNC 1 | 2020-10-27 00:00:00
 | CLNC 1 | 2020-10-28 00:00:00
 | CLNC 1 | 2020-10-28 00:00:00
 | CLNC 1 | 2020-10-29 00:00:00
 | CLNC 2 | 2020-10-06 00:00:00
 | CLNC 2 | 2020-10-06 00:00:00
 | CLNC 2 | 2020-10-07 00:00:00
 | CLNC 2 | 2020-10-07 00:00:00
 | CLNC 2 | 2020-10-08 00:00:00
 | CLNC 2 | 2020-10-14 00:00:00
 | CLNC 2 | 2020-10-15 00:00:00
 | CLNC 2 | 2020-10-20 00:00:00
 | CLNC 2 | 2020-10-27 00:00:00
 | CLNC 2 | 2020-10-27 00:00:00
 | CLNC 2 | 2020-10-27 00:00:00
 | CLNC 2 | 2020-10-27 00:00:00
 | CLNC 3 | 2020-10-27 00:00:00
Spreadsheet: 38294d1236386386-creating-a-formula-to-add-lbs-ozs-drams-a-wee-dramm
Sheet: Sheet1

 | lb | oz | drm
 | 1 | 8 | 11
 | 1 | 9 | 7
 | 3 | 6 | 12
 | 1 | 1 | 1
 | 2 | 14 | 3
total | 10 | 8 | 2
Spreadsheet: 79366d1279642197-storing-text-entered-in-one-cell-to-another-sheet-storing-text-entered-in-one-cell-to-another-sheet
Sheet: FS Feedback

Consultant | Total
ACHMAR, [NAME] | 0
[NAME], [NAME] | 0
Auckburally, [NAME] | 0
Borkovic, [NAME] | 3
Brooks, [NAME] | 2
[NAME], [NAME] | 0
[NAME], [NAME] | 0
Cadiz, [NAME] | 4
Chaseling, Alexandra | 0
Cochrane-Burgess, James | 2
Cogin, Narelle | 0
Davies, [NAME] | 1
Dennis, Tristan | 1
Dibley, [NAME] | 0
DUTTON, ALISON | 0
Eaton,[NAME] | 4
Ellis, [NAME] | 4
[NAME], [NAME] | 0
Giardina, [NAME] | 0
[NAME], [NAME] | 1
[NAME], Scott | 0
Halinan, [NAME] | 0
Heskey, Alana | 0
[NAME], [NAME] | 2
Indrajaja, Angelica | 0
Jessup, [NAME] | 0
[NAME], San | 0
Karam, Lina | 3
[NAME], Ioulia | 1
Layman, [NAME] | 0
McCormack, [NAME] | 0
[NAME], [NAME] | 0
McNulty, [NAME] | 3
[NAME] | 0
[NAME], [NAME] | 0
[NAME], Tara | 2
Nguyen, Van | 0
O'Reilly, Sean | 0
Patwa, Jimish | 0
Pixton, Penelope | 0
Reuter, [NAME] | 3
[NAME], Sandeep | 4
Sharma, Anshika | 0
Singh, [NAME] | 0
Todorovski, [NAME] | 3
[NAME], April | 0
[NAME], [NAME] | 0
[NAME], [NAME] | 0
[NAME], [NAME] | 0
Spreadsheet: 839237d1691763725-need-help-on-sumifs-and-indirect-function-combined-sample-file-5-
Sheet: Summary 2

Emp name | Experience(Months) | Designation | Total Exp in Month | Billing | Per Month ctc in rs. | Per Month CTC in GBP
aakash | 35 | Sr exexcutive | 50 | 874.32 | 32000
[NAME] | 28 | Sr exexcutive | 25 | 1290.19 | 40000
prajakta | 3 | Trainee | 22 | 1312 | 23000
ratan | 14 | Sr exexcutive | 24 | 600 | 33000
suresh | 6 | Trainee | 4 | 1100 | 17000
mahes | 7 | Trainee | 5 | 120 | 15000
[NAME] | 2 | Trainee | 4 | 120 | 13500
neena | 3 | Sr exexcutive | 3 | 120 | 50000
kapil | 5 | Sr exexcutive | 2 | 120 | 30000
Spreadsheet: richard_ring__31562__FETZERCAPS2001
Sheet: Sheet3

 | 8/28/2001 4:32:29 PM | 77A601 | A  1 | 1010802837 | 8/6/2001 | 2726 | 34.075
FNX5423805
 | 8/28/2001 4:32:29 PM | 4K4275 | A  1 | 1010802838 | 8/6/2001 | 545 | 6.8125
FNXT125601
 | 8/28/2001 4:32:29 PM | C21747 | A 10 | 1010802842 | 8/6/2001 | 23814 | 297.675
FNXT154001
 | 8/28/2001 4:32:29 PM | C21748 | AG 4B | 1010802839 | 8/6/2001 | 9887 | 123.5875
HNX7029203
 | 8/28/2001 4:32:29 PM | D28210 | A  1 | 1010802846 | 8/8/2001 | 1188 | 14.85
 | 8/28/2001 4:32:29 PM | D28210 | A  1 | 1010802846 | 7/10/2001 | 177 | 2.2125
HNX7029401
 | 8/28/2001 4:32:29 PM | 0525R5 | A  6 P | 1010802847 | 2/7/2001 | 4720 | 59
 | 8/28/2001 4:32:29 PM | 0525R5 | A  6 P | 1010802847 | 3/9/2001 | 19600 | 245
HNX7029602
 | 8/28/2001 4:32:29 PM | R05897 | AG 4B | 1010802854 | 8/8/2001 | 0 | 0
HNX7030601
 | 8/28/2001 4:32:29 PM | 71T460 | AG 1A | 1010802850 | 8/8/2001 | 0 | 0
HNX7030801
 | 8/28/2001 4:32:29 PM | 667R57 | AG 1A | 1010802851 | 8/8/2001 | 0 | 0
HNX7031401
 | 8/28/2001 4:32:29 PM | 7G4012 | A  1 | 1010802852 | 8/8/2001 | 30 | 0.375
 | 8/28/2001 4:32:29 PM | 7G4012 | A  1 | 1010802852 | 7/10/2001 | 23 | 0.2875
HNXT127805
 | 8/28/2001 4:32:29 PM | C22320 | AG 1A | 1010802843 | 8/7/2001 | 2243 | 28.0375
HNXT128401
 | 8/28/2001 4:32:29 PM | C22319 | A 10 | 1010802844 | 8/7/2001 | 30633 | 382.9125
HNXT129802
 | 8/28/2001 4:32:29 PM | C22321 | AG 4B | 1010802848 | 7/10/2001 | 3459 | 43.2375
HNXT461701
 | 8/28/2001 4:32:29 PM | C21087 | SE19S | 1010802853 | 8/7/2001 | 221809 | 2772.6125
 | 8/28/2001 4:32:29 PM | C21087 | SE19S | 1010802853 | 7/10/2001 | 243042 | 3038.025
Spreadsheet: kate_symes__18321__Deal Correction 4-20
Sheet: 3-19

Date of Inquiry | Adjustment date | Date of applied calc | Deal Date | Desk Involved | Reason | Correction located by: | Broker | Change | Details of reason | Deal # | Delivery | Term | Hours p/op/rtc | MW | Price | Counterparty
 | 2001-03-19 00:00:00 | 2001-03-19 00:00:00 | 2001-03-14 00:00:00 | LTNW | Credit | Houston | Amerex | Killed deal due to pending credit |  | 550427 | Mid-C | J-01 | On [NAME] | 25 | 281 | Puget
 |  |  |  | Grand Count
Spreadsheet: 702614d1604431523-unique-list-with-criteria-and-ranking-book1
Sheet: Sheet1

Names | Year | Rank
[NAME] | 2020 | 1 |  |  |  | 2020
[NAME] | 2021 | 5
[NAME] | 2022 | 4
[NAME] | 2021 | 3
Spreadsheet: 870134d1716675388-dynamically-copy-filter-rows-to-another-sheet-based-on-multiple-criteria-dynamically-copyfilter-rows-to-another-sheet-based-on-multiple-criteria2-copy
Sheet: Hanging

 | FLOOR | RC | UNIT TYPE | TOT SF CEILING | TOT SF | 12 C | 12X | 10X | 9X | 9MR | 8TILE | 8SOFF | UNIT | FINISHER $/SF | FINISHER | FINISHER PAY | FINISHER PAID
Building # 2 (24) | 2 FLOOR | 0 | A2 | 702 | 2878 | 15 | 0 | 0 | 50 | 6 | 3 | 2 | 2205 | 0.15 | [NAME] | 432 | Green
Building # 2 (24) | 3 FLOOR | 1 | A4 | 766 | 2942 | 16 | 0 | 0 | 50 | 6 | 3 | 2 | 2303 | 0.15 | [NAME] | 441 | Green
Building # 2 (24) | 1 FLOOR | 1 | B1 | 1090 | 4550 | 23 | 0 | 0 | 80 | 9 | 6 | 2 | 2101 | 0.15 | [NAME] | 683 | Green
Spreadsheet: jonathan_mckay__16926__Area Managers
Sheet: East Twin

Enron Direct Deal Sheet |  |  |  |  |  |  |  |  |  |  |  |  | 1 | January
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | February
Counterparty Name: | East Calgary Twin Arena Society |  |  |  | Deal Date: | 2001-05-23 00:00:00 |  |  |  |  |  |  | 3 | March
Originator: | Greg Frers |  |  |  | Deal ID #: |  |  |  |  |  |  |  | 4 | April
 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | May
Deal Start Date: | 2001-08-01 00:00:00 |  |  |  | Unit of Measure: | GJ |  |  |  |  |  |  | 6 | June
Deal End Date: | 2002-07-31 00:00:00 |  |  |  | Volume (Monthly/Daily): | Monthly |  |  |  |  |  |  | 7 | July
Term Duration (months): |  |  |  |  |  |  |  |  |  |  |  |  | 8 | August
 |  |  |  |  | Price: |  |  |  |  |  |  |  | 9 | September
Fuel Rate %: | 0.01561 |  |  |  | Buy/Sell: | Buy |  |  |  |  |  |  | 10 | October
 |  |  |  |  |  |  |  |  |  |  |  |  | 11 | November
 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | December
 | Month | Rate 11 Volume | Rate 13 Volume | Combined Volume | Fuel | Total
 | January | 916
 | February | 880
 | March | 542.3
 | April | 538.4
 | May | 381.6
 | June | 288.5
 | July | 188.9
 | August | 339.1
 | September | 389.7
 | October | 500.4
 | November | 872.6
 | December | 900.5
 | TOTAL:
Spreadsheet: 0b0750cf-012d-4cd1-9430-226946c0ecf3
Sheet: Table 5.2

Monthly Statistical Bulletin
5.2 Housing and cash interest rates
Month | 2010–11 | 2011–12 | 2012–13 | 2013–14 | 2014-15
Banks' housing interest rate – per cent
July | 7.4 | 7.8 | 6.850000000000001 | 6.2 | 5.95
August | 7.4 | 7.8 | 6.850000000000001 | 5.95
September | 7.4 | 7.8 | 6.850000000000001 | 5.95
October | 7.4 | 7.8 | 6.65 | 5.95
November | 7.8 | 7.55 | 6.65 | 5.95
December | 7.8 | 7.3 | 6.45 | 5.95
January | 7.8 | 7.3 | 6.45 | 5.95
February | 7.8 | 7.4 | 6.45 | 5.95
March | 7.8 | 7.4 | 6.45 | 5.95
April | 7.8 | 7.4 | 6.45 | 5.95
May | 7.8 | 7.05 | 6.2 | 5.95
June | 7.8 | 6.850000000000001 | 6.2 | 5.95
Cash market interest rate – per cent
July | 4.5 | 4.75 | 3.5 | 2.75 | 2.5
August | 4.5 | 4.75 | 3.5 | 2.55 | 2.5
September | 4.5 | 4.75 | 3.5 | 2.5
October | 4.5 | 4.75 | 3.2725 | 2.5
November | 4.73 | 4.51 | 3.25 | 2.5
December | 4.75 | 4.3 | 3.0275 | 2.5
January | 4.75 | 4.25 | 3 | 2.5
February | 4.75 | 4.25 | 3 | 2.5
March | 4.75 | 4.25 | 3 | 2.5
April | 4.75 | 4.25 | 3 | 2.5
May | 4.75 | 3.77 | 2.805 | 2.5
June | 4.75 | 3.5375 | 2.75 | 2.5
Source: RBA website, statistical tables F1 and F5
 |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | 5 September for housing
 |  |  |  |  |  |  |  | 1 October for cash rate
Spreadsheet: acc39e1d-2806-4f65-bb20-c84d1af89679
Sheet: 7

 | Jun 28 | Jul 5 | Jul 12 | Jul 19 | Jul 26
Total Interest Rate* | N/A*** | N/A | N/A | N/A | N/A
Cleared** | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Credit | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | N/A | N/A | N/A | N/A | N/A
Weekly total, estimated swap dollar volumes by asset class and cleared status (value of all trades in millions of USD), all products, tenors, and participant types.
Estimates of weekly event volumes are derived from data published in the 2012 ISDA Operations Benchmarking Survey, which defines an "event" as a new trade, confirmable amendment, partial or full termination, increase, decrease, or novation.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: ea3d8d8e-46f6-440d-b01c-f40e63d065a6
Sheet: Flight 3

 | SINGLES | FLIGHT "3"
 |  |  | [NAME]          ([NAME])
 |  |  |  | [NAME] (SH)
 |  |  | BYE
 | Molina (Hart) |  | [NAME] (Boston) |  | Lemire (BU)
 |  |  |  |  | 6-3, 6-1
 |  | Molina (Hart) |  | Lemire (Hart)
 |  |  | [NAME] (Hartford) | 6-2, 6-2
Barnhart (M) |  |  |  |  |  | Ambrosio (QU)
2013-08-02 00:00:00 |  |  | [NAME] (UCONN) |  |  | 6-2, 6-0
 |  | Toner (UC) |  | Templeman (Bry)
 |  |  | [NAME] (Bryant | 6-4, 4-6, 12-10
 | Barnhart (M) |  | [NAME] (Quinnipiac) |  | Ambrosio (QU)
 | 2013-08-01 00:00:00 |  |  |  | 6-1, 6-2
 |  | Barnhart (M) |  | Ambrosio (QU)
 |  |  | [NAME] (Merrimack) | 6-3, 4-1 ret.
 | Sunday 9:00am | Saturday 1:00pm | Friday 2:30pm | Saturday 1:00pm | Sunday 9:00am
 | UCONN | UCONN | UCONN | UCONN | UCONN
 |  |  | Quarter Finals | Finals | Finals
Spreadsheet: 274928d1383265647-extract-certain-data-from-a-column-dependent-on-another-column-to-another-sheet-drafting-report-beta-1-
Sheet: LISTS

 | DESIGNERS & DRAFTERS |  | DEVELOPERS | SUBURB | ESTATES |  | STANDARD MODELS |  | PROJECT |  | Column1
 |  |  |  |  | BRIGHTON |  | RODEO |  | P170
 | ALEX C |  | SATTERLEY | BALDIVIS | CHIMES |  |  |  | P450 |  | y
 | [NAME] |  | LWP | BALGA | LEXIA |  |  |  | P500-1 |  | n
 | BGC CONST |  | PEET | [NAME] | VILLAGE |  |  |  | P500-2
 | BSI |  | STOCKLAND | BERTRAM | WHITEMAN EDGE |  |  |  | P500-3
 | GUISEPPE N |  |  | BRABHAM |  |  |  |  | SPEC
 | HOMESTART |  |  | BROOKDALE
 | PUNAH P |  |  | CLARKSON |  |  |  |  | PLANNING REQUIRED
 | RYAN S |  |  | EGLINTON |  |  |  |  | YES
 | SHAILAN P |  |  | ELLENBROOK |  |  |  |  | NO
 | SUE A |  |  | HARRISDALE
 | CALLAN C |  |  | HILBERT |  |  |  |  | [NAME]
 | UNALLOCATED |  |  | INNALOO |  |  |  |  | SINGLE
 | DONE |  |  | LOCKRIDGE |  |  |  |  | DUPLEX
 | KYLIE J |  |  | MANDURAH |  |  |  |  | TRIPLEX
 | CHAN P |  |  | NOLLAMARA |  |  |  |  | GROUP
 | [NAME] |  |  | QUEENS PARK |  |  |  |  | MASONETTE
 |  |  |  | WELLARD
Spreadsheet: 873930d1720531917-get-the-date-of-each-row-in-one-shot-lso
Sheet: Jo

 | Method 1 | Method 2
Apple
Guava
Orange
Pears
Papaya
Grapes
Spreadsheet: 5dd26890-3eb2-45fa-bf34-80c1717a332a
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
PLHBB | Test | PLHBB | [NAME], Plasma | [NAME], P | Spectrophotometry (SP) | EDTA (lavender-top) tube: EDTA |  |  | 2 | mL | Container/Tube: Lavender top (EDTA)  [NAME]: 2 mL Collection Instructions: Spin down within 2 hours of draw. Forms: If not ordering electronically, please submit a Hematopathology/Molecular Oncology Request Form (Supply T241) with the specimen. | 1.5 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK  Lipemia	Mild OK; [NAME] OK Icterus	NA Other	Serum | TOTAL HEMOGLOBIN > or =12 months: 0.0-15.2 mg/dL Reference values have not been established for patients who are less than 12 months of age.  OXYHEMOGLOBIN > or =12 months: 0.0-12.4 mg/dL Reference values have not been established for patients who are less than 12 months of age. | Monday through Saturday | 1 day | 3 days | 1 | 83051 |  |  |  |  | Rochester
PLHBB | [NAME] | PLEDTA | [NAME] |  |  |  | Refrigerated | 7 days
PLHBB | Result | 31970 | Total Hemoglobin | Total Hemoglobin | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 721-1
PLHBB | Result | 31971 | [NAME] | [NAME] | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 76189d1276722847-breaking-up-data-across-multiple-worksheets-np-transactions_5-29-10_1test
Sheet: CARMICM

56000002 | RS | 5008 | 33462
56000002 | RS | 5008 | 23166
56100002 | RS | 5009 | 4176
56100002 | RS | 5009 | 8816
68670150 | PR | 348177 | 4500
68670253 | PR | 348176 | 2500
68670257 | PR | 348176 | 1500
68670323 | PR | 348177 | 3500
68670327 | PR | 348177 | 5500
68670428 | PR | 348176 | 1500
68670429 | PR | 348176 | 1500
68670515 | PR | 348177 | 3000
68670618 | PR | 348177 | 3500
00B00002 | PR | 348040 | 3888
00B00002 | PR | 348040 | 5184
Spreadsheet: 855688d1705190617-updating-a-calendar-from-dates-test-calendar-v2-taflorida-
Sheet: January

 |  |  | JANUARY
 |  |  | SUNDAY |  | MONDAY |  | TUESDAY |  | WEDNESDAY |  | THURSDAY |  | FRIDAY |  | SATURDAY
1
-1
2
Spreadsheet: 707515d1607331307-using-a-list-to-reduce-worksheets-midshires-master
Sheet: DMox

 |  |  |  | ADJUSTED HANDICAP |  |  |  |  |  | OFFICIAL HANDICAP |  |  |  |  | HANDICAPPING ALTERATIONS
hole | par | S/I | SHOTS | CALC | points | PAR 3 | SI/1 | SI/2 | S1/3 | SI/1 | S1/2 | S1/3 | CALC | points | EXACT | catagory | BUFFER | css | Nett | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAP |  | ZONE |  | Differential
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out |  |  |  |  |  | TOTAL
total
Spreadsheet: 215034d1361231658-sum-of-aleatory-numbers-in-aleatory-positions-test
Sheet: Feuil1

 |  | 0
1 | 50000
2 | 20000
3 | 15000
4 | 10000
5 | 7000
5 | 4000
10 | 2000
10 | 1000
Spreadsheet: 793659d1661617158-formula-to-find-starting-and-ending-row-numbers-book1-26-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Expected Results
 |  |  |  |  |  |  |  |  |  | Starting Row Number | Ending Row Number
 |  |  |  | 2022-08-01 00:00:00 | 1 |  |  |  |  | 4 | 7 | 2022-08-01 00:00:00
 |  |  |  | 2022-08-01 00:00:00 | 1 |  |  |  |  | 8 | 9 | 2022-08-01 00:00:00
 |  |  |  | 2022-08-01 00:00:00 | 1 |  |  |  |  | 10 | 12 | 2022-08-01 00:00:00
 |  |  |  | 2022-08-01 00:00:00 | 1 |  |  |  |  | 13 | 13 | 2022-08-02 00:00:00
 |  |  |  | 2022-08-01 00:00:00 | -1 |  |  |  |  | 14 | 18 | 2022-08-02 00:00:00
 |  |  |  | 2022-08-01 00:00:00 | -1 |  |  |  |  | 19 | 22 | 2022-08-02 00:00:00
 |  |  |  | 2022-08-01 00:00:00 | 1 |  |  |  |  | 23 | 23 | 2022-08-03 00:00:00
 |  |  |  | 2022-08-01 00:00:00 | 1 |  |  |  |  | 24 | 27 | 2022-08-03 00:00:00
 |  |  |  | 2022-08-01 00:00:00 | 1
 |  |  |  | 2022-08-02 00:00:00 | -1
 |  |  |  | 2022-08-02 00:00:00 | 1
 |  |  |  | 2022-08-02 00:00:00 | 1
 |  |  |  | 2022-08-02 00:00:00 | 1
 |  |  |  | 2022-08-02 00:00:00 | 1
 |  |  |  | 2022-08-02 00:00:00 | 1
 |  |  |  | 2022-08-02 00:00:00 | -1
 |  |  |  | 2022-08-02 00:00:00 | -1
 |  |  |  | 2022-08-02 00:00:00 | -1
 |  |  |  | 2022-08-02 00:00:00 | -1
 |  |  |  | 2022-08-03 00:00:00 | 1
 |  |  |  | 2022-08-03 00:00:00 | -1
 |  |  |  | 2022-08-03 00:00:00 | -1
 |  |  |  | 2022-08-03 00:00:00 | -1
 |  |  |  | 2022-08-03 00:00:00 | -1
Spreadsheet: 157061d1337607785-indexing-with-merged-cells-in-the-array-sampleproblem-indexing
Sheet: fill in sheet

A, B.
FY 2012 |  | ID # | DAYS WORKED | JJJJ | AAAA |  | BBBB | CCCC | DDDD | EEEE | FFFF | GGGG | HHHH | IIII
July 2011
August
September
October
November
December
January 2012
February
March
April
May
June
Spreadsheet: 845109d1696638005-show-a-list-of-values-from-one-column-with-a-value-match-in-another-column-show-a-list-of-values-from-one-column-with-a-value-match-in-another-column-v4
Sheet: Sheet1

Store | Apple | Pear | Orange | [NAME] | Lemon | Kiwi | Duran
Wal-Mart | Yes | No | No | Yes | Yes | No | No
Target | Yes | Yes | Yes | No | No | No | No
Kroger | No | No | Yes | No | Yes | Yes | Yes
Aldi | Yes | No | Yes | Yes | Yes | Yes | No
[NAME]'s | Yes | Yes | No | Yes | No | No | Yes
Item | Kiwi | Orange | Lemon
Store
 | Aldi | Kroger | Kroger
 |  | Aldi | Aldi
Spreadsheet: 474452d1470758504-time-conversion-from-decimal-time-format-time-conversion
Sheet: What I have

Time In | Time Out | [NAME] (as Numeric) |  | Real Time | Lunch | Total Hours |  | Time In | Time Out | [NAME] (as Numeric) |  | Real Time | Lunch | Total Hours
06:08 AM | 06:16 PM | 11.63333333333333 |  |  | 30 minutes |  |  | 06:08 AM | 06:16 PM | 11.63333333333333 |  | 11:38:00 | 30 minutes | 12:11:00 | Add 30 minutes with lunch.
05:51 AM | 04:33 PM | 10.2 |  |  |  |  |  | 05:51 AM | 04:33 PM | 10.2 |  | 10:12:00 | 30 minutes | 10:42:00
06:01 AM | 06:47 PM | 12.26666666666667 |  |  |  |  |  | 06:01 AM | 06:47 PM | 12.26666666666667 |  | 12:16:00 | 30 minutes | 12:46:00
06:06 AM | 06:19 PM | 11.71666666666667
06:16 AM | 03:05 PM | 8.316666666666666
06:10 AM | 04:50 PM | 10.16666666666667 |  |  |  |  |  |  |  |  |  |  | End Result
 |  | Time Duration is in decimal minutes |  |  |  |  |  |  |  |  |  | I want normal time
 |  |  |  |  |  |  |  |  |  |  |  |  | 30 minutes for [NAME]
Spreadsheet: 0675e5fe-ba8c-45de-95f4-487e365b6a28
Sheet: Master Mix Sheet

Ice Cream Production Master Sheet
 | Gallons
Vanilla Ice Cream
Finished Ice Cream
Ice Cream Remaining
Chocolate Ice Cream
Finished Ice Cream
Ice Cream Remaining
No Sugar Ice Cream
Finished Ice Cream
Ice Cream Remaining
[NAME]
Finished [NAME]
[NAME] Remaining
Sherbet
Finished Sherbet
Sherbet Remaining
Notes:
Spreadsheet: 693868d1599192446-summing-multiple-arrays-with-multiple-criteria-inventory_tracker_example
Sheet: Depletion Sheet

 | Product | Current Inventory | Total Weekly Depletions | End of Week Inventory
 | Grain - Silo 1 | 55000
 | Grain - Silo 2 | 36000
 | Grain - Bags | 4000
 | Grain 3 | 2200
 | Grain 4 | 1100
 | Grain 5 | 500
 | Grain 6 | 250
 | Grain 7 | 1150
 | Grain 8 | 55
Spreadsheet: d164cf25-aecd-4169-bc3f-744d3288f380
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
FCLON | Test | FCLON | Clonidine (Catapres) | Clonidine (Catapres) | Liquid Chromatography/Tandem Mass Spectrometry (LC/MS/MS) | Green-Top Tube (Sodium Heparin): GrnNaHp OR Plain, Red-Top Tube: Red OR |  |  | 5 | mL | Submit only 1 of the following specimens:   Plasma Draw blood in a green-top (sodium heparin) tube(s), plasma gel tube is not acceptable. Spin down and send 5 mL sodium heparin plasma refrigerated in a plastic vial.   Serum Draw blood in a plain red-top tube(s), serum gel tube is not acceptable. Spin down and send 5 mL of serum refrigerated in a plastic vial. | 1.2 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | [NAME]: 1.00 - 2.00 ng/mL   Sedation has been associated with serum clonidine concentrations greater than 1.5 ng/mL   Toxic concentration has not been established.   Test Performed by: Medtox Laboratories, Inc.                              402 W. County Road D                              St. Paul, MN 55112 | Monday through Sunday | 5 days | 7 - 9 days | 1 | 82542 |  |  |  |  | Medtox Laboratories, Inc.
FCLON | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 7 days
FCLON | Result | Z1184 | Clonidine | Clonidine | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 813736d1673964294-match-and-extract-data-from-two-possible-sources-and-enter-in-to-cell-match-data-from-different-sources
Sheet: Desired output

First Name | Surname | Employee Number | [NAME]
User | 1 | 38035694 | [EMAIL]
User | 2 | 38032228 | [EMAIL]
User | 3 | REVIEW | [EMAIL]
User | 4 | 38031516 | [EMAIL]
User | 5 | EXUK7686 | [EMAIL]
User | 6 |  | [EMAIL]
User | 7 | 38037607 | [EMAIL]
User | 8 | EXUK7658 | [EMAIL]
User | 9 | 38040487 | [EMAIL]
User | 10 | EXIE701F | [EMAIL]
User | 11 | 38037721 | [EMAIL]
User | 25 | REVIEW | [EMAIL]
User | 28 | REVIEW | [EMAIL]
User | 32 | REVIEW | [EMAIL]