tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 877949d1724881400-how-to-merge-two-files-into-one-sample
Sheet: Sheet2

id | shipping_length | shipping_width | shipping_height | shipping_weight
10001 | 6 in | 6 in | 6 in | 2 lb
10002c | 14 in | 12 in | 9 in | 6 lb
10003 | 6 in | 6 in | 6 in | 2 lb
10003p | 6 in | 6 in | 6 in | 2 lb
10004 | 6 in | 6 in | 6 in | 2 lb
10004p | 9 in | 6 in | 6 in | 2 lb
10005 | 6 in | 6 in | 6 in | 2 lb
10005p | 9 in | 6 in | 6 in | 2 lb
10006 | 6 in | 6 in | 6 in | 2 lb
10006p | 10 in | 7 in | 6 in | 2 lb
10007 | 6 in | 6 in | 6 in | 2 lb
10007b | 11 in | 7 in | 6 in | 2 lb
10007cb | 9 in | 6 in | 6 in | 2 lb
10008 | 6 in | 6 in | 6 in | 2 lb
10010 | 14 in | 12 in | 9 in | 6 lb
10010p | 6 in | 6 in | 6 in | 2 lb
10011 | 6 in | 6 in | 6 in | 2 lb
10011b | 7 in | 6 in | 6 in | 2 lb
10011cb | 12 in | 9 in | 6 in | 2 lb
10013 | 6 in | 6 in | 6 in | 2 lb
10013b | 14 in | 7 in | 12 in | 6 lb
10013cb | 13 in | 6 in | 6 in | 2 lb
10018 | 6 in | 6 in | 6 in | 2 lb
10020 | 14 in | 12 in | 9 in | 9 lb
10021s40 | 6 in | 6 in | 6 in | 2 lb
10023 | 6 in | 6 in | 6 in | 2 lb
10025 | 7 in | 6 in | 6 in | 2 lb
10026 | 6 in | 6 in | 6 in | 2 lb
10031 | 6 in | 6 in | 6 in | 2 lb
10032c | 6 in | 6 in | 6 in | 2 lb
10034b | 6 in | 6 in | 6 in | 2 lb
10034cb | 6 in | 6 in | 6 in | 2 lb
10038 | 6 in | 6 in | 6 in | 2 lb
10039 | 14 in | 12 in | 10 in | 9 lb
10041 | 6 in | 6 in | 6 in | 2 lb
10043 | 6 in | 6 in | 6 in | 2 lb
10043p | 6 in | 6 in | 6 in | 2 lb
10045 | 6 in | 6 in | 6 in | 2 lb
10045b | 10 in | 7 in | 6 in | 2 lb
10045cb | 14 in | 7 in | 6 in | 2 lb
10046 | 6 in | 6 in | 6 in | 2 lb
10046b | 13 in | 12 in | 7 in | 4 lb
10047 | 15 in | 6 in | 6 in | 2 lb
10047b | 6 in | 6 in | 6 in | 2 lb
10047cb | 13 in | 10 in | 6 in | 2 lb
10048 | 6 in | 6 in | 6 in | 2 lb
10049 | 12 in | 11 in | 8 in | 4 lb
10049b | 6 in | 6 in | 6 in | 2 lb
10049cb | 11 in | 6 in | 6 in | 2 lb
10057 | 6 in | 6 in | 6 in | 2 lb
10057b | 14 in | 12 in | 7 in | 4 lb
Spreadsheet: dan_hyvl__4823__Dynegy Marketing & Trade HPL
Sheet: AMASTPSA 

MASTER FIRM PURCHASE/SALE AGREEMENT INFORMATION SHEET
ENA Entity: | Houston Pipe Line Company | ATTORNEY: | [NAME]
DATE: |  | HPL CONTACT:
COUNTERPARTY: | Dynegy Marketing and Trade | CONTACT: | [NAME]
ADDRESS: | 1000 Louisiana | TITLE: | Contracts
 | Suite 5800 | PHONE: | [PHONE]
 | Houston, TX 77002 | FAX: | [PHONE]
INCORPORATION STATE: |  | S&P RATING:
STRUCTURE | COUNTERPARTY | ECT ENTITY
COLLATERAL
THRESHOLD  in $ | $5MM | $5MM
COMMITTED VOLUMES
THRESHOLD in $[NAME] | N/A | N/A
COLLATERAL REQUIRED FOR:
ALL TRADES
OTHER | N/A | N/A
COLLATERAL TYPE
Letter of Credit | OK | OK
COLLATERAL  MULTIPLE | $250MM | $250MM
GUARANTOR (RATING) | Dynegy, Inc. (BBB+) | Enron Corp. (BBB+)
LIMIT in $[NAME] | OPEN | $15MM
Incorporation State: | Delaware | Oregon
MATERIAL ADVERSE CHANGE TRIGGERS  APPLY TO:
-Counterparty
-Guarantor | X | X
Debt Ratings Change | X | X
-Below = | BBB-/Baa3 | BBB-/Baa3 | S&P/Moodys
Financial Covenants
-Funded Debt/Net Worth
-Minimum Net worth
-Cash Flow/CMLTD
-Current Ratio
Non-Specific
-Unilateral
Ownership Change
-Less than 51% owned by:
Non-Standard Definitions
-Funded Debt
-Net Worth
-Cash Flow
EVENTS OF DEFAULT
3rd party debt
-Counterparty
-Guarantor ($[NAME]) | $50MM | $100MM
FIN'L STATEMENTS
-Standard | X | X | Upon request
CREDIT DECISION: | APPROVED:  X | DECLINED:
OUTSTANDING PHYSICAL TRADES: |  | YES: X | NO:
ALL TRADES TO ROLL UP UNDER NEW MASTER: |  | YES: X | NO:
OTHER COMMENTS | Current Guaranties from both Guaranors at this time.  Enron would have to amend the
Guaranty issued 1/27/92 to include HPL as a beneficiary.  HPL already covered in Guaranty issued by Dynegy, Inc.
on 2/11/98.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | Phone: x6-6002
Spreadsheet: 600722d1543931928-sum-with-multiple-criteria-thannys-example
Sheet: Sheet2

 | 49 | 50 | 51 | 52
Briefing | 8
Meetings | 26 | 12
Breakdown | 6 | 5
Quality Issue | 2 | 55
Spreadsheet: 3f190b49-f3c1-4ce6-a860-fed9c2e0a7bd
Sheet: 8a

Product1 | Cleared2 | Uncleared | TOTAL
Basis | 66 | 191 | 257
Cap/Floor | - | 161 | 161
Debt Option | - | - | -
Exotic | - | - | -
Fixed-Fixed | - | 7 | 7
Fixed-Float | 13114 | 3635 | 16749
FRA | 1311 | 196 | 1507
Inflation | - | 585 | 585
OIS | 156 | 432 | 588
Swaption | - | 1405 | 1405
TOTAL | 14647 | 6612 | 21259
Spreadsheet: 154841d1336579622-rotational-listings-w
Sheet: Schedule

 | Period Start Date : | 2012-06-03 00:00:00
 |  | 2012-06-03 00:00:00 | 2012-06-04 00:00:00 | 2012-06-05 00:00:00 | 2012-06-06 00:00:00 | 2012-06-07 00:00:00 | 2012-06-08 00:00:00 | 2012-06-09 00:00:00
 | Staff | 2012-06-03 00:00:00 | 2012-06-04 00:00:00 | 2012-06-05 00:00:00 | 2012-06-06 00:00:00 | 2012-06-07 00:00:00 | 2012-06-08 00:00:00 | 2012-06-09 00:00:00
1 | PARKER | R | R | E | M | M | M1 | WM1
2 | POWELL | WM | M | R | L | M | M1 | R
3 | SHORT | R | E | M | M | M | R | WM
4 |  | WM1 | E | R | L | A | M1 | R
5 | WILLS | R | M | A | M | E | R | WM
6 | ENDEAN | WM | M | M | R | L | M3 | R
7 |  | R | R | L | M | M | M3 | WM
8 | [NAME] | WM1 | E | R | L | A | M3 | R
9 | ALLISON | R | M | E | A | E | R | WM
10 | DUTTON | WM | M | E | R | A | M3 | R
11 | KIRK | R | R | A | E | L | M3 | WM1
12 | BEAL | WM | M | M | E | R | M3 | R
13 | [NAME] | R | M | A | M | E | R | WM
14 | BENTLEY | WM | M | A | R | L | E1 | R
15 | LEWIS | R | R | L | M | M | M3 | WM
16 |  | WM | M | M | E | R | M3 | R
17 | GILBERT | R | M | E | A | E | R | WM
18 | LLOYD | WM | M | M | E | R | M3 | R
19 | MCMORROW | R | R | E | M | M | M3 | WM
20 | STILL | WM | E | M | A | E | R | R
2
Spreadsheet: 820160d1677892052-calculate-balance-qty-start-with-restock-qty-sample
Sheet: Sheet1

Restock Date | Part A | Part B | Part C |  | S/No | Name | Date Issues | Part Number | Request Qty | Balance | Expected Result
2022-12-01 00:00:00 | 100 | 100 | 100 |  | 1 | [NAME] | 2023-01-01 00:00:00 | Part B | 50 | 50 | 100-50=50
2023-02-01 00:00:00 | 200 | 200 | 200 |  | 2 | [NAME] | 2023-01-01 00:00:00 | Part A | 80 | 20 | 100-80=20
 |  |  |  |  | 3 | [NAME] | 2023-01-18 00:00:00 | Part A | 18 | 2 | 20-18=2
 |  |  |  |  | 4 | [NAME] | 2023-02-11 00:00:00 | Part A | 100 | 102 | 2+200-100=102 (Restock date 1/2/23)
 |  |  |  |  | 5 | [NAME] | 2023-03-04 00:00:00 | Part C | 100 | 200 | 200+100-100=200 (Restock date 1/2/23)
 |  |  |  |  | 6 | Zoe | 2023-03-04 00:00:00 | Part B | 150 | 100 | 50+200-150=100 (Restock date 1/2/23)
Spreadsheet: eric_saibi__9864__Market briefs
Sheet: Sheet1

Market Briefs | Friday, October 12
Stocks | Close | Change | % Change
DJIA | 9344.16 | -66.29000000000087 | -0.00704429650016746
DJ 15 Util. | 316.18 | -0.4800000000000182 | -0.001515821385713441
NASDAQ | 1703.4 | 1.930000000000064 | 0.001134313270289846
S&P 500 | 1090.84 | -5.779999999999973 | -0.005270741004176445
Market Vols | Close | Change | % Change
AMEX (000) | 191654 | -8460 | -0.0422759027354408
NASDAQ (000) | 2182024 | -287687 | -0.1164860989808119
NYSE (000) | 1338082 | -328307 | -0.1970170230360378
Commodities | Close | Change | % Change
Crude Oil (Nov) | 22.5 | -0.8500000000000014 | -0.03640256959314781
Heating Oil (Nov) | 0.6384 | -0.02710000000000001 | -0.04072126220886554
Nat. Gas (Henry) | 2.43 | -0.1039999999999996 | -0.04104183109707958
Propane (Nov) | 40.75 | 0 | 0
Palo Verde (Nov) | 34 | 0 | 0
COB (Nov) | 31.5 | 0 | 0
PJM (Nov) | 28.9 | 0 | 0
Dollar US $ | Close | Change | % Change
Australia $ | 1.985 | -0.0109999999999999 | -0.005511022044088125
Canada $ | 1.567 | -0.001000000000000112 | -0.0006377551020408877
Germany Dmark | 2.15 | -0.0169999999999999 | -0.007844946931241303
Euro | 0.9102 | 0.007900000000000018 | 0.008755402859359435
Japan ¥en | 121.4 | 0 | 0
Mexico NP | 9.31 | -0.03999999999999915 | -0.004278074866310069
[NAME] | 0.6892 | -0.003699999999999926 | -0.005339875883965833
Foreign Indices | Close | Change | % Change
Arg MerVal | 232.97 | 0.1599999999999966 | 0.0006872557020746384
[NAME]. | 3159 | 25.90000000000009 | 0.00826657304267342
[NAME] | 10784.72 | 0 | 0
Can TSE 300 | 7031 | -29.10000000000036 | -0.004121754649367624
Germany DAX | 4625.13 | -93.32999999999993 | -0.01977975865006801
[NAME] | 10274.13 | -248.4800000000014 | -0.02361391327816971
Japan Nikkei 225 | 10632.35 | 285.34 | 0.02757704882859881
[NAME] | 5671.1 | -137.12 | -0.0236079211875583
UK FTSE 100 | 5145.5 | -19.39999999999964 | -0.003756123061433839
Source:  Yahoo! & TradingDay.com
Spreadsheet: 109891d1306710424-monthly-rollup-of-data-5-27-11
Sheet: Title V

CHUNCHULA COMPRESSOR ENGINE EMISSIONS
 | 2011-05-29 00:00:00
 |  | EAST NRU |  |  |  | WEST NRU
 |  | [NAME] 2912 |  |  |  | [NAME] 2909
 |  | Fuel (Mcf) |  |  |  | Fuel (Mcf)
 |  | 173 |  |  |  | 104
 |  | Operating Hours |  |  |  | Operating Hours
 |  | 24 |  |  |  | 24
 |  | Fuel Gas - BTU |  |  |  | Fuel Gas - BTU
 |  | 1118 |  |  |  | 1118
 |  | Mmbtu |  |  |  | Mmbtu
 |  | 193.414 |  |  |  | 116.272
 |  | Emissions Factor |  |  |  | Emissions Factor
 |  | (lb/MMBtu) |  |  |  | (lb/MMBtu)
 | CO | 0.015 |  |  | CO | 0.011
 | NOx | 0.263 |  |  | NOx | 0.307
 | VOC | 0.241 |  |  | VOC | 0.028
 |  | Engine Emissions |  |  |  | Engine Emissions
 |  | (Lbs/Hr) |  |  |  | (Lbs/Hr)
 | CO | 0.12088375 | 3.05 |  | CO | 0.05329133333333333 | 3.05
 | NOx | 2.119495083333333 | 3.92 |  | NOx | 1.487312666666667 | 3.92
 | VOC | 1.942198916666666 | 2.48 |  | VOC | 0.1356506666666667 | 2.48
 |  | 7.208333333333333 | Mcf/hr |  |  | 4.333333333333333 | Mcf/hr
 |  | NECS 806 |  |  |  | NECS 807
 |  | [NAME] 2910 |  |  |  | [NAME]
 |  | Fuel (Mcf) |  |  |  | Fuel (Mcf)
 |  | 0 |  |  |  | 131
 |  | Operating Hours |  |  |  | Operating Hours
 |  | 24 |  |  |  | 24
 |  | Fuel Gas - BTU |  |  |  | Fuel Gas - BTU
 |  | 896.9 |  |  |  | 896.9
 |  | Mmbtu |  |  |  | Mmbtu
 |  | 0 |  |  |  | 117.4939
 |  | Emissions Factor |  |  |  | Emissions Factor
 |  | (lb/MMBtu) |  |  |  | (lb/MMBtu)
 | CO | 0.1 |  |  | CO | 0.54
 | NOx | 0.3 |  |  | NOx | 0.7
 | VOC | 0 |  |  | VOC | 0.02
 |  | Engine Emissions |  |  |  | Engine Emissions
 |  | (Lbs/Hr) |  |  |  | (Lbs/Hr)
 | CO | 0 | 7.5 |  | CO | 2.64361275 | 7.5
 | NOx | 0 | 9 |  | NOx | 3.426905416666667 | 9
 | VOC | 0 |  |  | VOC | 0.09791158333333333
 |  | 0 | Mcf/hr |  |  | 5.458333333333333 | Mcf/hr
Spreadsheet: 77443d1277912394-extract-room-number-and-student-id-and-put-them-in-other-cells-studenthousing-3-
Sheet: 3717

Building No:- 3717 | Mr. [NAME] | Mr. [NAME] | Mr. [NAME] | Mr. [NAME] | Mr. [NAME] | Mr. [NAME] | Mr. [NAME] | Mr. [NAME] | Mr. [NAME] | Mr. [NAME] | Mr. [NAME] | Mr. [NAME] | Mr. [NAME]
Date | RoomNo | RoomNo | RoomNo | RoomNo | RoomNo | RoomNo | RoomNo | RoomNo | RoomNo | RoomNo | RoomNo | RoomNo | RoomNo
2010-06-30 00:00:00 | 115 | 124 | 207 | 314 | 314 | 101A | 119B | 121A | 121B | 122B | 218A | 218B | 223A
OUTSTANDING
SATISFACTORY
UNSATISFACTORY
DOOR UNLOCKED
WINDOW UNLOCKED
LOCKER UNLOCKED
CARPET Not SWEPT
DUST
BEDS UNMADE
MESSY
MICROWAVE DIRTY
FREEZER DIRTY
REFRIGERATOR DIRTY
LIGHTS / APPLIANCES ON
CEILING FAN ON
OPEN FOOD NOT STORED
TRASH IN ROOM / HEAD
MIRROR / SHELF DIRTY
SINK / BRIGHTWORK DIRTY
FLOOR IN BATH DIRTY
TUB / SHOWER DIRTY
SHOWER CURTAIN DIRTY
TOILET DIRTY
ODOR
Dirty TILE
Spreadsheet: 683203d1592555358-lookup-if-cell-contains-targeted-text-lookup-if-contains-date
Sheet: Sheet1

Criteria1 | Criteria2 |  |  |  |  |  |  | Criteria1 | Criteria2
2019-01-01 00:00:00 | Text1 | Name1, Surname1, Middlename1 |  |  |  | Name1, Surname1 | Value1 | 2019-01-01 00:00:00 | Text1
2019-01-02 00:00:00 | Text2 | [NAME], Surname2 |  |  |  | [NAME], Surname2 | Value2 | 2019-01-10 00:00:00 | Text1
2019-01-03 00:00:00 | Text3 | Name3, Surname3, Middlename3 |  |  |  | Name3, Surname3 | Value3 | 2020-02-03 00:00:00 | Text3
2019-01-04 00:00:00 | Text4 | Name4, Surname4 |  |  |  | Name4, Surname4 | Value4 | 2019-01-01 00:00:00 | Text4
2019-01-05 00:00:00 | Text5 | Name5, Surname5, Middlename5 |  |  |  | Name5, Surname5 | Value5 | 2020-01-05 00:00:00 | Text5
 |  | Find with condition if A:A is +/- 30 as H:H
 |  | And has same "Criteria2"
Spreadsheet: 145875d1331790808-transfer-data-from-one-sheet-to-another-when-specific-value-entered-in-first-sheet-example_2012_file
Sheet: July

Reporter | Date Rec. | Date Comp. | Witness | Description | Pages Rec | Pages Rtn | Job Type | Rate | Total | Tithe Amount | Tithed | Invoice # | Invoice Date | Date Paid | Monthly Tithe | Tithed MTD | Left to Tithe | Total | Amount Received | Total By Reporter | Amount Due | Amount Received
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jeanne
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Karisa
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 750455d1633459002-auto-populate-table-columns-matching-criteria-wip-ef-hr-recruitment-tracker
Sheet: Landing Page

 | HR Recruitment Tracker - October 2021
 | LA |  |  |  |  |  |  |  |  | SF
 | Recruitment Pipeline / Targets |  |  |  |  |  |  |  |  | Recruitment Pipeline / Targets
 | Selection Phase
 | Offered | Background Check | Drug Test | Scheduled for Orientation | Hired |  |  |  |  | Offered | Background Check | Drug Test | Scheduled for Orientation | Hired
 | Driver - Gwyn Belvin | Driver - Clarita Kaczmarek | Driver - Roman Leishman | Driver - Lavonda Petrillo | Driver - Lorelei Gapinski
 | Driver - Bert Outman | Driver - Julene Shah | Merch - Janyce Rubio | Warehouse - Amparo Bettcher
 | Warehouse - Syreeta Fain | Driver - Maud Fleck | Merch - Kennith Holladay | Warehouse - Glennie Schow
 | ** These are examples manually typed in! | Driver - Dorathy Rusnak
 |  | Warehouse - Leatha Acedo
 | Check in LA!"Order" for "1", then auto-populate the "MergedNamePosn" (C2) in this column with each name that matches "1" | Check in LA!"Order" for "2", then auto-populate in this column with each name that matches "2" | And so forth | As their "Order" changes, their names will update to reflect on this chart
Spreadsheet: 883378d1732008293-formula-to-update-clients-clients-update-2
Sheet: Sheet1

 | I am kindly requesting for a formula that list the names that do not appear in both tables. Thank you.
 |  |  |  |  |  |  |  |  |  | Desired Solution
 | Date | Name | I.D Number |  | Date | Name | I.D Number |  |  | Name | I.D Number
 | 2024-01-05 00:00:00 | [NAME] | CT 461 |  | 2024-01-01 00:00:00 | [NAME] | CT 275 |  |  | [NAME] | CT 275
 | 2024-01-05 00:00:00 | [NAME] | CT 432 |  | 2024-01-01 00:00:00 | ADAROSE | CT 408 |  |  | ADAROSE | CT 408
 | 2024-01-05 00:00:00 | SIDRA | CT 449 |  | 2024-01-01 00:00:00 | ADONIS | CT 233 |  |  | ADONIS | CT 233
 | 2024-01-05 00:00:00 | TEBOGO | CT 442 |  | 2024-01-01 00:00:00 | AGAPE | CT 249 |  |  | AGAPE | CT 249
 | 2024-01-05 00:00:00 | ANENYASHA | CT 486 |  | 2024-01-01 00:00:00 | ALEX | CT 002 |  |  | ALEX | CT 002
 | 2024-01-05 00:00:00 | [NAME] | CT 4860 |  | 2024-01-01 00:00:00 | AMAL | CT 003 |  |  | AMAL | CT 003
 | 2024-01-05 00:00:00 | MARY | CT 4861 |  | 2024-01-01 00:00:00 | AMBER | CT 420 |  |  | AMBER | CT 420
 |  |  |  |  | 2024-01-01 00:00:00 | ANDILE | CT 004 |  |  | ANDILE | CT 004
 |  |  |  |  | 2024-01-01 00:00:00 | [NAME] | CT 461 |  |  | [NAME] | CT 4860
 |  |  |  |  | 2024-01-01 00:00:00 | [NAME] | CT 432 |  |  | MARY | CT 4861
 |  |  |  |  | 2024-01-01 00:00:00 | SIDRA | CT 449
 |  |  |  |  | 2024-01-01 00:00:00 | TEBOGO | CT 442
 |  |  |  |  | 2024-01-01 00:00:00 | ANENYASHA | CT 486
Spreadsheet: 8edf88d2-b8c9-4047-9203-e2228a7e5886
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
MTDNS | Test | MTDNS | Methadone, Serum | Methadone, S | Gas Chromatography-Mass Spectrometry (GC-MS) | Plain, Red-Top Tube: Red |  |  | 4.5 | mL | Container/Tube: Red top [NAME]: 4.5 mL | 2.1 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Serum gel tube | Single dose: 30-90 ng/mL Maintenance dose: 400-1,000 ng/mL | Monday through Thursday, Sunday | 2 days | 5 days | 1 | 83840 |  |  |  |  | Rochester
MTDNS | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
MTDNS | Result | 83131 | Methadone, S | Methadone, S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 3772-1 | Methadone:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 817789d1676445864-formula-to-sum-up-qty-each-month-by-given-date-book4
Sheet: Sheet1

X |  |  |  |  |  | Y
Activity | Start | Finish | Qty |  |  | Month | Qty
A | 2015-01-01 00:00:00 | 2015-02-05 00:00:00 | 500 |  |  | 2015-01-31 00:00:00 | 430.5556
B | 2015-05-10 00:00:00 | 2015-08-10 00:00:00 | 1000 |  |  |  | 500
C
D
E |  |  |  |  |  |  | A | Value
F |  |  |  |  |  |  | B | Value
G |  |  |  |  |  |  | C | Value
H |  |  |  |  |  |  | D | Value
Spreadsheet: 735953d1623272300-data-from-one-tab-to-another-based-on-date-draft-tracker
Sheet: BACK OFFICE

Priority |  | Done
High |  | Y
Low |  | N
Medium
Status
Not Started
In Progress
On Hold
Complete
Percentage
0.1
0.2
0.3
0.4
0.5
0.6
0.7
0.8
0.9
1
Spreadsheet: 05468dfc-19fc-4ad7-a2e0-fac0b8e7c049
Sheet: LW_Temp_Ozone_Data

 | Daily Ozone Maximum (ppb) | TMAX (F) - Surface Obs | LW Up Allsky radiation (w/m2) | LW - Temperature (C) | LW - Temperature (F)
2007-08-01 00:00:00 | 62 | 96.98 | 467
2007-08-02 00:00:00 | 62 | 98.06 | 477.5
2007-08-03 00:00:00 | 67 | 96.98 | 470.8
2007-08-04 00:00:00 | 66 | 96.98 | 472.1
2007-08-05 00:00:00 | 56 | 95 | 472.2
2007-08-06 00:00:00 | 55 | 96.08 | 473.2
2007-08-07 00:00:00 | 31 | 96.08 | 495.8
2007-08-08 00:00:00 | 42 | 96.98 | 487
2007-08-09 00:00:00 | 58 | 98.96 | 505.9
2007-08-10 00:00:00 | 63 | 102.02 | 506.9
2007-08-11 00:00:00 | 64 | 102.02 | 491.9
2007-08-12 00:00:00 | 65 | 102.92 | 498.9
2007-08-13 00:00:00 | 72 | 105.08 | 515.9
2007-08-14 00:00:00 | 71 | 104 | 506.4
2007-08-15 00:00:00 | 89 | 105.98 | 503.8
2007-08-16 00:00:00 | 81 | 105.08 | 473.4
2007-08-17 00:00:00 | 68 | 102.02 | 507.4
2007-08-18 00:00:00 | 82 | 100.94 | 484.2
2007-08-19 00:00:00 | 62 | 95 | 475.7
2007-08-20 00:00:00 | 57 | 95 | 466.4
2007-08-21 00:00:00 | 60 | 96.98 | 477.3
2007-08-22 00:00:00 | 59 | 100.04 | 493.2
2007-08-23 00:00:00 | 68 | 100.04 | 491.3
2007-08-24 00:00:00 | 64 | 100.04 | 502.5
2007-08-25 00:00:00 | 58 | 96.98 | 496.4
2007-08-26 00:00:00 | 55 | 96.08 | 471.8
2007-08-27 00:00:00 | 66 | 100.94 | 489.8
2007-08-28 00:00:00 | 64 | 93.02000000000001 | 471.2
2007-08-29 00:00:00 | 68 | 98.96 | 451.9
2007-08-30 00:00:00 | 76 | 96.08 | 465.6
2007-08-31 00:00:00 | 64 | 93.92 | 473.3
Spreadsheet: 1c69c01d-6fb5-43c1-b5ba-2543db93d91f
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
VDSF | Test | VDSF | VDRL, Spinal Fluid | VDRL, CSF | Floculation/Agglutination | Plastic vial: PlV |  |  | 0.5 | mL | Collection Container/Tube: Sterile vial Submission Container/Tube: Plastic vial	 [NAME]: 0.5 mL | 0.2 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | Negative Positive results will be titered. | Monday through Friday 12 p.m. | 1 day | 3 days | 1 | 86592 |  |  |  |  | Rochester
VDSF | [NAME] | CSF | CSF |  |  |  | Frozen | 14 days
VDSF | Result | 9028 | VDRL, CSF | VDRL, CSF | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31146-4 | Reagin Ab:Titr:Pt:CSF:Qn:VDRL
Spreadsheet: 2bade9c8-9c19-48f4-9fc8-2d924ae8db90
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
8305 | 18494 | Bente | [NAME] | DEN | 0 | 01:20:38 | 00:06:05 | 06:43:04 | 00:03:13 | 04:28:28 | 1 | 12:41:29
Spreadsheet: 219356d1362734181-work-out-percentage-for-pass-fail-pass-rate-new
Sheet: Sheet1

date/ name
01/04/12 Mark | fail
12/04/12 [NAME] | pass
4/4/2012 lewis | pass
4/4/2012 dec | pass
01/06/2012 [NAME] | fail
7/06/2012 [NAME] | fail
20/06/2012 alex | pass
25/06/2012 charlotte | pass
7/07/2012 elle mae | pass
30/07/201 lewis | pass
6/8/2012 [NAME] | pass
12/8/2012 [NAME] | pass
13/08/2012 azhar | pass
24/08/20121 claire | pass
leanne | fail
23/09/2012 leanne | pass
8/10/2012 muntahinah | pass
charlotte | fail
25/10/2012 charlotte | pass
1/11/2012 sian | pass
[NAME] berniece | pass
sadiqa | fail
sadiqa | fail
sadiqa | fail
sadiqa | pass
16/01/2013 nat | pass
jess 1/03/2013 | pass
luke | fail
luke | fail
luke | pass
Spreadsheet: 52426d1252110567-simple-if-equals-function-not-working-jodapo_ifformula
Sheet: Sheet1

RateOfReturn | NAV
-2.4 | 97.6
13.77 | 111.03952
10.98 | 123.231659296
-0.03 | 123.194689798211
12.55 | 138.655623367887
-0.14 | 138.461505495172
-3.35 | 133.823045061083
-10.39 | 119.918830679237
-3.73 | 115.445858294901
1.64 | 117.339170370938 |  |  |  | G5 to G29 should be displaying "OK" since the numbers are equal…..?!?!
3.97 | 121.997535434664
9.81 | 133.965493660804
9.83 | 147.134301687662
8.34 | 159.405302448412
10.46 | 176.079097084516
1.29 | 178.350517436907
4.51 | 186.394125773311
-6.23 | 174.781771737634
-1.27 | 172.562043236566
7.13 | 184.865716919333
-0.1 | 184.680851202414
1.53 | 187.506468225811
-5.98 | 176.293581425907
7.92 | 190.256033074839
5.33 | 200.396679637728
0.57 | 201.538940711663
-2.56 | 196.379543829444
-0.78 | 194.847783387575
-0.28 | 194.30220959409
-4.3 | 185.947214581544
4.5 | 194.314839237713
-1.89 | 190.64228877612
1.49 | 193.482858878885
1.47 | 196.327056904404
9.1 | 214.192819082705
0.84 | 215.992038763
0.61 | 217.309590199454
-5.7 | 204.922943558085
1.14 | 207.259065114647
-4.14 | 198.678539818901
7.13 | 212.844319707989
-0.25 | 212.312208908719
1.97 | 216.49475942422
10.89 | 240.071038725518
3.8 | 249.193738197088
Spreadsheet: 846561d1697721119-making-a-work-shift-schedule-days-2024
Sheet: JAN

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Room Occupancy
 |  |  | 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
 |  |  | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W
Team Lead | Flex 1 | [NAME]
 | [NAME] | [NAME] The builder
 | Flex 3 | Rainman
 | [NAME] | Spiderman
 | Flex 1 & 3 |  | ON |  |  |  |  | ON | ON | ON | ON |  |  |  |  | ON | ON | ON | ON |  |  |  |  | ON | ON | ON | ON |  |  |  |  | ON | ON
 | flex 2 & 4 |  |  | ON | ON | ON | ON |  |  |  |  | ON | ON | ON | ON |  |  |  |  | ON | ON | ON | ON |  |  |  |  | ON | ON | ON | ON
Spreadsheet: 756452d1637574020-order-two-columns-based-off-two-other-columns-order-test-with-match
Sheet: Sheet1

 | RAW DATA (UNORDERED) |  |  |  |  |  |  |  |  | ORDERED LIST
[NAME] | [NAME] | First Name | Last Name |  | [NAME] | [NAME] |  |  |  | First Name | Last Name
2131 | 5657 | Felix | [NAME] |  | 46887 | 62014 |  |  |  | Felix | [NAME]
5652 | 885 | [NAME] | Doe |  | 21329 | 8 |  |  |  | [NAME] | Doe
2123 | 2122 | [NAME] | Brew |  | 1365 | 12 |  |  |  | [NAME] | Brew
4656 | 645 | [NAME] | [NAME] |  | 46546 | 879 |  |  |  | [NAME] | [NAME]
4656 | 645 | [NAME] | [NAME] |  | 2313 | 8493 |  |  |  | Felix | Asdf
 |  | Felix | Bobsd |  |  |  |  |  |  | [NAME] | [NAME]
 |  | DESIRED RESULTS
[NAME] | [NAME] | First Name | Last Name |  | [NAME] | [NAME]
2131 | 5657 | Felix | [NAME] |  | 46887 | 62014
5652 | 885 | [NAME] | Doe |  | 21329 | 8
2123 | 2122 | [NAME] | Brew |  | 1365 | 12
4656 | 645 | [NAME] | [NAME] |  | 46546 | 879
4656 | 645 | [NAME] | [NAME] |  | 2313 | 8493