tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 72652d1273341216-search-multiple-worksheets-acme-schedules
Sheet: ADMINISTRATION

WORK CATEGORY CODES: |  |  |  |  | DIVISION/ [NAME]:
W – WORK           SA – SPECIAL ASSIGNMENT    SL – SICK LEAVE
DO – DAY OFF        HW – HOLIDAY WORKED        AV – ADVANCE |  |  |  |  | STORE 1811
AL – ANNUAL LEAVE   WT – WORK/TRAVEL
 |  | PERIOD COVERED |  |  | SHIFT:
 |  |  |  |  | ADMINISTRATION
 | NAME | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THRUSDAY | FRIDAY | SATURDAY
1 | B. WITFORD | DO | 9A-5P | 9A-5P | 9A-5P | 9A-5P | 9A-5P | DO | B. WITFORD | B. WITFORD | B. WITFORD | B. WITFORD | B. WITFORD | B. WITFORD | B. WITFORD
2 | [NAME] | DO | 9A-5P | 9A-5P | 9A-5P | 9A-5P | 9A-5P | DO | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
3 | A. GUYEN | DO | 9A-5P | 9A-5P | 9A-5P | 9A-5P | 9A-5P | DO | A. GUYEN | A. GUYEN | A. GUYEN | A. GUYEN | A. GUYEN | A. GUYEN | A. GUYEN
4 | [NAME] | DO | 9A-5P | 9A-5P | 9A-5P | 9A-5P | 9A-5P | DO | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
5 | P. MIDT | DO | 9A-5P | 9A-5P | 9A-5P | 9A-5P | 9A-5P | DO | P. MIDT | P. MIDT | P. MIDT | P. MIDT | P. MIDT | P. MIDT | P. MIDT
6 | [NAME] | DO | 9A-5P | 9A-5P | 9A-5P | 9A-5P | 9A-5P | DO | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
7 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
8 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
9 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
10 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
11 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
12 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
13 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
14 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
15 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | TOTAL SOT:
PREPARED BY |  |  |  |  | SIGNATURE
BRAD PITT |  |  |  |  | [NAME]
Spreadsheet: 3481741f-e229-4fa1-85f0-0d706a1d010d
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
MMLYP | Test | MMLYP | Antimicrobial Susceptibility Panel, Yeast | Susceptibility Panel, Yeast | Minimum Inhibitory Concentration (MIC) Antifungals included in the assay are: amphotericin B, anidulafungin, caspofungin fluconazole, 5-flucytosine, itraconazole, micafungin, posaconazole, and voriconazole. | Sabouraud dextrose agar slant: SaDex |  |  |  | Varies | [NAME]: Sabouraud's dextrose agar slant [NAME] yeast isolate Collection Instructions:  1. Organism must be in pure culture, actively growing.  2. Place specimen in a large infectious container (Supply T146) and label as an etiologic agent.  Additional Information: 1. Specimen source and suspected organism identification are required.  2. See Infectious Specimen Shipping Guide in Special Instructions. Forms: If not ordering electronically, submit a Microbiology Request Form (Supply T244) with the specimen. |  | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	Agar plate | Results reported in mcg/mL | Monday through Saturday; Varies | 3-5 days | 7 days | 1 | 87186 |  |  |  |  | Rochester
MMLYP | [NAME] | VARIES | Varies |  |  |  | Ambient
MMLYP | Order Question | Q00M0040 | [NAME]) and Organism Identification(Required unless concurrent identification test is ordered) |  | Plain Text
MMLYP | Result | MMLYP | Susceptibility Panel, Yeast | Susceptibility Panel, Yeast | Alphanumeric |  |  |  |  | mL |  |  |  |  |  |  |  |  |  | In Process
MMLYP | [NAME] | SYP | Susceptibility Yeast Panel | Susceptibility Yeast Panel |  |  |  |  |  |  | This test is for Billing Purposes Only. This is not an orderable test. |  |  |  |  |  |  | 1 | 87186 |  |  | Yes | No ([NAME] Only)
Spreadsheet: 863218d1710785660-sumif-by-account-and-date-excel-problem-sumif
Sheet: Detail

Account | Date | Cash | Check | Interest Paid | Taxes | Interest Paid | Fees | Distributions
Account A | 2023-03-06 00:00:00 | 877661 | 0 | 96 | 118 | 68 | 19 | 119
Account A | 2023-05-11 00:00:00 | 366 | 297744 | 145 | 57 | 34 | 33 | 121
Account A | 2023-11-04 00:00:00 | 0 | 982286 | 13 | 41 | 82 | 66 | 21
Account B | 2023-07-31 00:00:00 | 337327 | 376570 | 85 | 100 | 96 | 71 | 76
Account B | 2023-09-24 00:00:00 | 530096 | 0 | 89 | 65 | 42 | 29 | 143
Account B | 2024-02-24 00:00:00 | 838421 | 920205 | 64 | 140 | 89 | 107 | 97
Account C | 2023-01-25 00:00:00 | 0 | 107071 | 6 | 49 | 15 | 130 | 87
Account C | 2023-06-25 00:00:00 | 486118 | 645464 | 39 | 92 | 87 | 54 | 53
Account C | 2024-01-08 00:00:00 | 474345 | 0 | 97 | 20 | 44 | 133 | 104
Account D | 2023-05-06 00:00:00 | 144929 | 697479 | 32 | 15 | 88 | 60 | 113
Account D | 2023-08-24 00:00:00 | 0 | 839727 | 52 | 72 | 18 | 62 | 6
Account D | 2024-02-18 00:00:00 | 0 | 452704 | 49 | 46 | 81 | 25 | 77
Account E | 2023-05-29 00:00:00 | 828481 | 478773 | 28 | 133 | 59 | 11 | 53
Account E | 2023-08-13 00:00:00 | 357807 | 0 | 145 | 137 | 56 | 93 | 32
Account E | 2023-11-06 00:00:00 | 586870 | 0 | 108 | 33 | 70 | 6 | 30
Account F | 2023-01-23 00:00:00 | 0 | 77637 | 78 | 51 | 49 | 63 | 33
Account F | 2023-05-19 00:00:00 | 0 | 733778 | 34 | 120 | 65 | 59 | 34
Account F | 2023-11-10 00:00:00 | 63054 | 865803 | 135 | 115 | 86 | 140 | 32
Account F | 2023-12-24 00:00:00 | 189797 | 0 | 122 | 124 | 70 | 109 | 44
Account G | 2023-03-30 00:00:00 | 901639 | 273996 | 42 | 80 | 18 | 72 | 34
Account G | 2023-09-09 00:00:00 | 0 | 7419 | 90 | 106 | 54 | 106 | 149
Account G | 2024-02-06 00:00:00 | 145499 | 509083 | 78 | 51 | 29 | 30 | 115
Spreadsheet: 215104d1361266941-i-need-help-again-with-tabs-and-a-formula-transnet-downtime-report-inland-temp-
Sheet: BLOEMFONTEIN

 |  |  |  |  |  |  | Transnet Downtime Report |  |  |  | 2013-02-19 00:00:00
Transnet Downtime Report
RC Number | Pre Inspection Form Number | Branch | Job card Ref | Depot | Cost Centre | Reg No. | Vin Number | Engine No. | [NAME] | Hour [NAME] | [NAME] | [NAME] | Vehicle Type | Department | Date Vehicle Booked In | Date quote sent to TFR | Quote Number | Date Order/Authorization Received | Authorization Number | Planned Completion Date | Date Job Completed | Date Vehicle Collected | Brief Job Description | Remarks/ Comments | Amount Excl. | Licence expire date
381531 | 81325 | BLOEMFONTEIN | U10514 | BURGERSDORP | 415122 | CVV898EC | ADNT5100000003418 | [NAME] | 212604 |  | Nissan | UD60 | RRV | TRANSNET | 2013-01-16 00:00:00 | 2013-01-24 00:00:00 | U3217 | 2013-01-24 00:00:00 | 4501831039 |  |  |  | Zagro tentioners,sweepers,clutch beacon light | WORK IN PROGRESS , WAITING PART | 25406.7 | 2013-05-31 00:00:00
382436 | BFN10002 | BLOEMFONTEIN | U10522 | BURGERSDORP | 415122 | CVP448EC | ADNT5100000003494 | FE620393813 | 234890 |  | Nissan | UD60 | RRV | TRANSNET | 2013-01-23 00:00:00 | 2013-01-25 00:00:00 | U9623 |  |  |  |  |  | Radiator fan & Cowling Service Zagro unit | QUOTE IN PROGRESS | 16183.73 | 2013-03-31 00:00:00
385807 | BFN1004 | BLOEMFONTEIN | U10556 | KROONSTAD | BLOEMFONTEIN | CXB930FS | AHHFC4JHKXXX12272 | J05CB16594 | 104536 |  | Toyota | HINO | RRV | TRANSNET | 2013-02-18 00:00:00 |  |  |  |  |  |  |  | Repair leveling cylinder on crane | WORK IN PROGRESS
386385 | BFN1006 | BLOEMFONTEIN | U10593 | BLOEMFONTEIN | BLOEMFONTEIN | CMH202FS | FDA16010401 | 01019SA074984W | 64791 |  | Toyota | HINO | RRV | TRANSNET | 2013-02-12 00:00:00 | 2013-02-12 00:00:00 | U3279 |  |  |  |  |  | TOP UP OIL | TOP UP HYDROLIC OIL | 802.4 | 2013-05-31 00:00:00
 |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 150415d1334516333-lookup-values-in-multiple-cells-folder_example
Sheet: Sheet1

D:\ | Data | Shared | Accounts | Holidays
D:\ | People | Test | Foreign | House
D:\ | America | Time | Italy | Baby
D:\ | Italy | Chest | Arsenal | Minister
D:\ | Cyprus | Fortress | People | England
Spreadsheet: 163153d1340206681-select-the-total-best-score-to-summarize-book1
Sheet: Sheet1

 |  |  | PLAYER 1 | vs | PLAYER 2 | Best score
 |  |  | [NAME] |  | Isildur | 100
 |  |  | Merkovitz |  | Mariot | 500
 |  |  | Merkovitz |  | Isildur | 56
 |  |  | [NAME] |  | Mariot | 932
 |  |  | Merkovitz |  | Isildur | 18
 |  |  | [NAME] |  | Honniro | 2300
 |  |  | [NAME] |  | Isildur | 92
 |  |  | [NAME] |  | Che | 396
 |  |  | Merkovitz |  | Che | 235
 |  |  | Merkovitz |  | [NAME] | 157
 |  |  | Select: |  | Select: | TOTAL SCORE:
 |  |  | Merkovitz | vs | Isildur |  | <---------- | Here, let's say if you select Merkovitz vs Isildur
 |  |  |  |  |  |  |  | it should be shown as Total Score 74 which is 56+18
 |  |  |  |  |  |  |  | because Merkovitz played with Isildur two times
 |  |  |  |  |  |  |  | and the best score was 56 and 18. |  |  |  | How to do this ?
 |  |  |  |  |  |  |  | On the other hand I want the posbility to select multiple players,
 |  |  |  |  |  |  |  | not only versus a single one.
 |  |  |  |  |  |  |  | If you check more deeper you will see that there is a list box control for
 |  |  |  |  |  |  |  | each player so you can select only one at a time.
 |  |  |  |  |  |  |  | I need another type of control or something/method in order to
 |  |  |  |  |  |  |  | do the following:
 |  |  |  |  |  |  |  | Let's say you want to select Merkovitz vs Isildur and vs [NAME],
 |  |  |  |  |  |  |  | all at the same time.
 |  |  |  |  |  |  |  | The Total Score should be in this case equal to 574 which is 56+18 (scores
 |  |  |  |  |  |  |  | against Isildur and + 500 which is against [NAME].
 |  |  |  |  |  |  |  | How you can do this ?
 |  |  |  |  |  |  |  | Thank you so much !
Spreadsheet: 86351d1286355861-excel-2008-solved-column-chart-conditional-formatting-748236
Sheet: Sheet1

 |  |  | Data | Highlight
A | 1700 | D | 1750
B | 1600 | A | 1700
C | 1500 | B | 1600
D | 1400 | C | 1500
 |  |  |  |  | The third column was coloured orange before the data was sorted and as you can see it is the position that retains the formatting. I'd like, in this example for the C column to always be coloured not matter where it appears on the x-axis.
Spreadsheet: 724025d1615991655-last-10-results-last-10
Sheet: Foglio1

date |  |  |  | IG |  | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1
2021-03-16 06:30:00 |  |  |  | 330
2021-03-16 08:00:00 |  |  |  | 320
2021-03-16 09:00:00 |  |  |  | 330
2021-03-16 09:00:00 |  |  |  | 340
2021-03-16 09:30:00 |  |  |  | 350
2021-03-16 09:45:00 |  |  |  | 320
2021-03-16 10:00:00 |  |  |  | 330
2021-03-16 10:00:00 |  |  |  | 330
2021-03-16 10:00:00 |  |  |  | 350
2021-03-16 10:00:00 |  |  |  | 350
2021-03-16 10:00:00 |  |  |  | 320
2021-03-16 10:00:00 |  |  |  | 330
2021-03-16 10:00:00 |  |  |  | 330
2021-03-16 10:00:00 |  |  |  | 350
2021-03-16 10:00:00 |  |  |  | 340
2021-03-16 10:00:00 |  |  |  | 320
2021-03-16 10:00:00 |  |  |  | 350
Spreadsheet: 546150d1509896524-lowest-price-against-each-product-code-grading-of-price-against-each-product-code-sample-data-price-grading
Sheet: PIVOT Table

 |  | Count of Selling Unit Price in $
 |  | Product Code | Description | Selling Unit Price in $ | Total
 |  | 020-0222 | SB Ajwain Seed | 2 | 2
 |  |  |  | 3.5 | 3
 |  |  |  | 4 | 4
 |  | 020-0223 | [NAME] | 25 | 2
 |  |  |  | 35 | 3
 |  |  |  | 42 | 4
 |  | 020-0225 | Flax seeds | 5 | 2
 |  |  |  | 8 | 3
 |  |  |  | 9 | 4
 |  |  |  | 25 | 5
 |  |  |  | 39 | 6
 |  | (blank) | (blank) | (blank) | 0
 |  | Grand Total
Spreadsheet: 39280781-b1bd-4587-91d9-dc10355c5cf9
Sheet: Region Data

Idaho Department of Health and Welfare Division of Behavioral Health
Mental Health Public Dashboard for August, 2014
* means on report is that count is less then 5, for details please contact  Idaho Department of Health and Welfare Central Office.
Report Run Date: 9/15/2014
 |  | Mental Health Dashboard |  | Region 1 | Region 2 | Region 3 | Region 4 | Region 5 | Region 6 | Region 7 | State Wide
Admission / Discharge | Monthly | Adult Mental Health | AMH Admission | 13 | * | 22 | 21 | 9 | 13 | 15 | 97
 |  |  | AMH Discharge | 24 | 11 | 16 | 26 | 18 | * | 31 | 129
 |  | Children Mental Health | CMH Admission | 6 | 5 | 8 | 9 | 9 | 6 | 9 | 52
 |  |  | CMH Discharge | 10 | 9 | 7 | 13 | 5 | 5 | 6 | 55
 | SFY 2015 | Adult Mental Health | AMH Admission | 28 | 12 | 43 | 62 | 23 | 25 | 36 | 229
 |  |  | AMH Discharge | 42 | 20 | 32 | 68 | 24 | 11 | 45 | 242
 |  | Children Mental Health | CMH Admission | 16 | 15 | 13 | 22 | 26 | 13 | 18 | 123
 |  |  | CMH Discharge | 21 | 23 | 13 | 34 | 10 | 18 | 26 | 145
Adult Mental Health | Number of adult served this Month |  |  | 356 | 166 | 583 | 703 | 220 | 207 | 522 | 2757
 | Number of adults served SFY 2015 |  |  | 485 | 229 | 842 | 1047 | 315 | 287 | 664 | 3869
Children's Mental Health | Number of children served this Month |  |  | 67 | 57 | 79 | 132 | 99 | 37 | 141 | 612
 | Number of children served SFY 2015 |  |  | 80 | 71 | 103 | 167 | 131 | 55 | 191 | 798
Pre-Sentence Investigation Reports  (I.C. 19-2524) | Monthly |  |  | 28 | 12 | 73 | 76 | 42 | 28 | 20 | 279
 | SFY 2015 |  |  | 72 | 30 | 138 | 150 | 90 | 53 | 70 | 603
Spreadsheet: 865880d1712845380-making-a-login-page-for-forum
Sheet: Sheet1

Id | Start time | Completion time | [NAME] | Name | Playstation Alias | First name | Email address | Country ( If America's state Time Zone) | Time Zone
12 | 2024-03-31 22:16:45 | 2024-03-31 22:18:19 | anonymous |  | bailymaus | [NAME] | [EMAIL] | Germany | GMT+1
13 | 2024-03-31 22:23:57 | 2024-03-31 22:24:58 | anonymous |  | marktallman59 | Mark | [EMAIL] | Germany | GMT+1
14 | 2024-03-31 22:29:12 | 2024-03-31 22:30:45 | anonymous |  | Crisis899 | [NAME] | [EMAIL] | England | GMT
15 | 2024-03-31 22:32:05 | 2024-03-31 22:35:42 | anonymous |  | [NAME] | [NAME] | [EMAIL] | England | GMT
16 | 2024-04-01 15:43:57 | 2024-04-01 15:49:51 | anonymous |  | CLoudNo_nine | [NAME] | [EMAIL] | England | England
18 | 2024-04-03 19:59:49 | 2024-04-03 20:03:54 | anonymous |  | Darth_Thumbs | Mark | [EMAIL] | UK | GMT +1
19 | 2024-04-04 00:17:23 | 2024-04-04 00:18:34 | anonymous |  | Night-Fall38 | Rodna | Rodnaduncan@gmail | USA | Eastern
21 | 2024-04-06 20:24:33 | 2024-04-06 20:28:44 | anonymous |  | Mljohn5.mj | Mark | [EMAIL] | USA | Central
22 | 2024-04-06 20:30:10 | 2024-04-06 20:31:27 | anonymous |  | criv34 | Clint | [EMAIL] | USA | Pacific
Spreadsheet: 818504d1676888566-allocate-amount-by-matching-month-s-with-percentages-distribution-by-month-by-percentage-ans
Sheet: Sheet1

 |  |  | At Month | 2 Months After | 4 Months After | 8 Months After
 |  |  | 0.1 | 0.2 | 0.3 | 0.4
 | Amount | Start |  | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00
 |  | 2023-01-31 00:00:00
 | 130 | 2023-04-30 00:00:00
 | 1000 | 2023-02-28 00:00:00
 | 398 | 2023-06-30 00:00:00
 |  | 2023-01-31 00:00:00
 | 130 | 2023-04-30 00:00:00
 | 1000 | 2023-02-28 00:00:00
 | 398 | 2023-06-30 00:00:00
Spreadsheet: 834743e1-6217-4edd-a90f-524732fc3aa7
Sheet: Sheet1

Securities | % of Assets
Alimentatn Couche-Tard B | 4.43%
Dollarama Inc. | 4.26%
Metro Inc. | 4.16%
Fairfax Financial Holding | 3.82%
BCE Inc. | 3.67%
Empire Company Cl A NVS | 3.56%
Keyera Corp | 3.11%
TransCanada Corp. | 2.87%
Rogers Communications Inc | 2.80%
TELUS Corp. | 2.78%
Canadian REIT | 2.78%
Pembina Pipeline Inc | 2.75%
RioCan REIT | 2.70%
Weston(George) Ltd. | 2.69%
Intact Financial Corp | 2.64%
Loblaw Companies Ltd. | 2.58%
Enbridge Inc. | 2.57%
Cdn Utilities Cl A NVS | 2.54%
Emera Inc. | 2.51%
Inter Pipeline Ltd. | 2.47%
Tim Hortons Inc. | 2.47%
Shaw Communicatn Cl B Nvs | 2.38%
Open Text Corp. | 2.27%
AltaGas Ltd | 2.08%
Fortis Inc. | 2.08%
Catamaran Corporation | 2.05%
Valeant Pharmaceuticals | 2.04%
Canadian Tire Corp Cl A | 2.03%
Thomson Reuters Corp | 1.99%
ATCO Ltd Class I | 1.94%
CGI Group Inc Cl A | 1.92%
West Fraser Timber Co Ltd | 1.91%
Franco-Nevada Corp | 1.88%
Saputo Inc. | 1.80%
CI Financial Corp | 1.75%
H&R REIT | 1.71%
National Bank of Canada | 1.65%
TransAlta Corp. | 1.49%
IGM Financial Inc. | 1.44%
CAE Inc. | 1.35%
Cash | 0.10%
Total Holdings in Portfolio | 41
Spreadsheet: 491364d1480438204-is-my-excel-sheet-affected-by-invisible-formatting-properties-representative-
Sheet: Mortgage

 | London and Country: 'Home buyers who put down a 15% deposit can find some great deals. Anyone who has 25% will get the lowest possible rates of interest.  Few first time buyers can afford as much as this so the government has introduced a temporary scheme for struggling buyers called Help to Buy.'
 | guide here
 | Loan to value calculator
 |  | depost | property | depost as a %
 |  | 70000 | 210000
Spreadsheet: 707034d1607009968-sum-if-excel-function-excel-problem
Sheet: Data

 |  |  | Number of Products
Category |  | Price | 2019-11 | 2019-12 | 2020 11 | 2020 12 | 2020-03 | 2020-04 | 2020-05 | 2020-06 | 2020-07 | 2020-08 | 2020-09 | 2020-10
Items | Orange | 5 | 2 | 1
Items | Orange | 3 |  |  | 3 | 3 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Items | Blue | 2 | 5 | 4 | 1
Items | Blue | 4 |  |  | 2 | 1
Spreadsheet: 870983d1717450126-how-to-calcualte-the-weighted-average-weighted-average
Sheet: Sheet1

 | Time taken | User |  |  |  |  | User
10/16/2023 | 00:14:00 | CC |  |  | 10/16/2022 | Day | RR
10/16/2023 | 00:06:00 | CC |  |  | 10/16/2022 | Night | CC
10/16/2023 | 00:12:00 | CQ |  |  | 10/16/2022 | Night | CQ
10/16/2023 | 01:06:00 | RR |  |  | 10/17/2023 | Day | FR
10/16/2023 | 00:08:00 | CC |  |  | 10/17/2023 | Night | AD
10/16/2023 | 00:13:00 | CQ |  |  | 10/17/2023 | Night | DS
10/16/2023 | 01:26:00 | RR |  |  | 10/18/2023 | Day | AF
10/16/2023 | 00:23:00 | CC |  |  | 10/18/2023 | Night | BS
10/17/2023 | 00:28:00 | DS |  |  | 10/18/2023 | Night | ER
10/17/2023 | 01:05:00 | AD |  |  | 10/19/2023 | Day | AF
10/17/2023 | 01:06:00 | AD |  |  | 10/19/2023 | Night | RR
10/17/2023 | 01:05:00 | FR |  |  | 10/19/2023 | Night | CQ
10/17/2023 | 00:32:00 | DS
10/17/2023 | 00:22:00 | DS
10/18/2024 | 00:26:00 | BS
10/18/2024 | 00:24:00 | AF
10/18/2024 | 00:26:00 | BS
10/18/2024 | 00:50:00 | ER
10/18/2024 | 00:50:00 | ER
10/18/2024 | 00:50:00 | ER
10/18/2024 | 00:50:00 | ER
10/18/2024 | 00:26:00 | BS
10/19/2024 | 00:24:00 | AF
10/19/2024 | 00:26:00 | BS
10/19/2024 | 00:50:00 | RR
10/19/2024 | 00:50:00 | RR
10/19/2024 | 00:50:00 | CQ
10/19/2024 | 00:50:00 | CQ
Spreadsheet: 232385d1367416274-how-to-use-buttons-to-lookup-data-then-calculate-output-sheet-metal-analysis
Sheet: Stainless

Material | Gage | Length (ft) | width (ft) | Lbs per Sq. ft. | thickness | tolerance | sheet weight (lb) | Price per 100 weight (lbs) (cwt) | nominal wieght (esitimated pounds ordered)/amount purchased | amount shipped (lbs) | date paid | date invoiced | total estimated price | invoice amount | total price paid or cost | Invoice # | actual cost per sheet | cost per sqft | number of sheets on hand | lbs on hand | total area onhand (ftsq) | dollar amount on hand | total cost/lb on hand actual | cost/sqft on hand | Vendor
Stainless | 26 | 8 | 4 | 0.7476 | 0.0178 |  | 23.9232
Stainless | 26 | 10 | 4 | 0.7476 | 0.0178 |  | 29.904
Stainless | 24 | 8 | 4 | 0.987 | 0.0235 |  | 31.584
Stainless | 24 | 10 | 4 | 0.987 | 0.0235 |  | 39.48
Stainless | 22 | 8 | 4 | 1.231 | 0.0293 |  | 39.392
Stainless | 22 | 10 | 4 | 1.231 | 0.0293 |  | 49.24
Stainless | 20 | 8 | 4 | 1.491 | 0.0355 |  | 47.712
Stainless | 20 | 10 | 4 | 1.491 | 0.0355 |  | 59.64
Stainless | 18 | 8 | 4 | 2.016 | 0.048 |  | 64.512
Stainless | 18 | 10 | 4 | 2.016 | 0.048 |  | 80.64
Stainless | 16 | 8 | 4 | 2.499 | 0.0595 |  | 79.968
Stainless | 16 | 10 | 4 | 2.499 | 0.0595 |  | 99.96000000000001
Stainless | 14 | 8 | 4 | 3.154 | 0.0751 |  | 100.928
Stainless | 14 | 10 | 4 | 3.154 | 0.0751 |  | 126.16
Stainless | 12 | 8 | 4 | 4.427 | 0.1054 |  | 141.664
Stainless | 12 | 10 | 4 | 4.427 | 0.1054 |  | 177.08
Material | Gage | Length (ft) | width (ft) | Lbs per Sq. ft. | thickness | tolerance | sheet weight (lb) | est weight order | price/pound | Qty Sheets received | Price for all sheets | Date Ordered
Stainless | 26 | 8 | 4 | 0.7476 | 0.0178 |  | 23.9232
Stainless | 26 | 10 | 4 | 0.7476 | 0.0178 |  | 29.904
Stainless | 24 | 8 | 4 | 0.987 | 0.0235 |  | 31.584
Stainless | 24 | 10 | 4 | 0.987 | 0.0235 |  | 39.48
Stainless | 22 | 8 | 4 | 1.231 | 0.0293 |  | 39.392
Stainless | 22 | 10 | 4 | 1.231 | 0.0293 |  | 49.24
Stainless | 20 | 8 | 4 | 1.491 | 0.0355 |  | 47.712
Stainless | 20 | 10 | 4 | 1.491 | 0.0355 |  | 59.64
Stainless | 18 | 8 | 4 | 2.016 | 0.048 |  | 64.512
Stainless | 18 | 10 | 4 | 2.016 | 0.048 |  | 80.64
Stainless | 16 | 8 | 4 | 2.499 | 0.0595 |  | 79.968 | 479.808 | 1.87 | 6 | 897.24 | 2012-07-20 00:00:00
Stainless | 16 | 10 | 4 | 2.499 | 0.0595 |  | 99.96000000000001 |  |  |  |  | 2012-07-21 00:00:00
Stainless | 14 | 8 | 4 | 3.154 | 0.0751 |  | 100.928 | 403.712 | 1.87 | 4 | 754.9414400000001 | 2012-07-20 00:00:00
Stainless | 14 | 10 | 4 | 3.154 | 0.0751 |  | 126.16
Stainless | 12 | 8 | 4 | 4.427 | 0.1054 |  | 141.664 | 283.328 | 1.87 | 2 | 529.82336 | 2012-07-20 00:00:00
Stainless | 12 | 10 | 4 | 4.427 | 0.1054 |  | 177.08
Spreadsheet: 9498cabc-eb73-4213-bc18-f77ed0143e38
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
LINS | Test | LINS | Linseed, IgE | Linseed, 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
LINS | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
LINS | Result | LINS | Linseed, IgE | Linseed, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 7312-2 | [NAME] usitatissimum [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 82027d1282091663-creating-a-summary-worksheet-with-all-data-from-all-sheets-summary-20sheet-20example-1-
Sheet: B

Sheet B
 | M | N | O | P | Q
001 | 68 | 6 | 275 | 146 | 232
002 | 148 | 32 | 152 | 303 | 322
003 | 310 | 118 | 34 | 37 | 37
004 | 132 | 287 | 154 | 216 | 99
005 | 99 | 25 | 179 | 154 | 55
006 | 252 | 123 | 221 | 170 | 207
Spreadsheet: 829868d1684505976-concatenate-within-xlookup-ntc-ef
Sheet: Order report

Value | Name | Checker | Check 2
PO001044LU16440 | Supplier 1
PO000726HU1023 | Supplier 1
PO000726HU1024 | Supplier 2
PO000726HU1025 | Supplier 1
PO000726HU1026 | Supplier 2
PO000726HU1027 | Supplier 1
PO000726HU1028 | Supplier 2
PO000726HU1029 | Supplier 1
PO000726HU1030 | Supplier 2
PO000726HU1031 | Supplier 1
PO000726HU1032 | Supplier 2
PO000726HU1033 | Supplier 2
PO000726HU1034 | Supplier 2
Spreadsheet: 223011d1363991464-creating-a-list-of-just-unique-values-cf-washout-answer-2
Sheet: Sheet1

Field 1 | Field 2 | Field 1 Unique | Field 2 Unique
10 | 10 | 16 | 15
11 | 11
12 | 12
13 | 13
14 | 14
16 | 15
17 | 17
18 | 18
19 | 19
20 | 20
4 | 18
20 | 31
20 | 10