tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 861676d1709557215-copy-formula-down-a-column-only-changing-column-ref-test-example
Sheet: Data

Test Col1 | test [NAME] | test Col3 | test [NAME] | Test Col 5
A | 122 | 1111111 | Jon | 1900-01-01 00:00:00
B |  | 222222 | Jo | 1910-01-01 00:00:00
C |  | 3333333333333 | Julie | 1920-01-01 00:00:00
D | 4444 | 444444444 |  | 1930-01-01 00:00:00
E | 532554 | 5555555555555 |  | 1940-01-01 00:00:00
F | 676577657 | 666666666 | adam | 1950-01-01 00:00:00
G | 78768687 | 7777777777 | sue | 1960-01-01 00:00:00
H |  | 8888888888 |  | 1970-01-01 00:00:00
I |  | 999999999 |  | 1980-01-01 00:00:00
J |  | 2222224444 |  | 1990-01-01 00:00:00
K |  | 45435354345 |  | 2000-01-01 00:00:00
L |  | 6856567765 |  | 2010-01-01 00:00:00
M | 656456465 | 78687 |  | 2020-01-01 00:00:00
N |  | 43345534534 |  | 2030-01-01 00:00:00
O |  | 11121434334 | [NAME] | 2040-01-01 00:00:00
P |  | 67567567 |  | 2050-01-01 00:00:00
Q |  | 567567567576 |  | 2060-01-01 00:00:00
R |  | 676576 |  | 2070-01-01 00:00:00
S | 22222 | 9999999999 |  | 2080-01-01 00:00:00
T
Spreadsheet: 795287d1662603327-returning-data-based-on-first-cell-being-greater-than-zero-example-2
Sheet: Sheet3

 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-09-05 00:00:00 |  |  |  | 2022-09-06 00:00:00 |  |  |  | 2022-09-08 00:00:00
FC No. | Job Description | X | X | X | X | X | X | X | X | X | Task Start Date | Task Finish Date | X | Friday | Hrs per day | Check | Roll Over | Monday | Hrs per day | Check | Roll Over | Tuesday | Hrs per day | Check | Roll Over
FC10001 | Forecast trial 1 |  |  |  |  |  |  |  |  |  | 2022-09-05 00:00:00 | 2022-09-05 00:00:00 |  | 5 | 8 | 8 | 8 | 0 | 8 | 8 | 8 | 0 | 8 | 8 | 8
FC10001 | Forecast trial 1 |  |  |  |  |  |  |  |  |  | 2022-09-05 00:00:00 | 2022-09-05 00:00:00 |  | 5 | 8 | 8 | 8 | 0 | 8 | 8 | 8 | 0 | 8 | 8 | 8
FC10001 | Forecast trial 1 |  |  |  |  |  |  |  |  |  | 2022-09-05 00:00:00 | 2022-09-05 00:00:00 |  | 5 | 8 | 8 | 8 | 0 | 8 | 8 | 8 | 0 | 8 | 8 | 8
FC10001 | Forecast trial 1 |  |  |  |  |  |  |  |  |  | 2022-09-06 00:00:00 | 2022-09-06 00:00:00 |  | 0 | 8 | 8 | 8 | 5 | 8 | 8 | 8 | 0 | 8 | 8 | 8
FC10001 | Forecast trial 1 |  |  |  |  |  |  |  |  |  | 2022-09-06 00:00:00 | 2022-09-08 00:00:00 |  | 0 | 8 | 8 | 8 | 5 | 8 | 8 | 8 | 5 | 8 | 8 | 8
FC10001 | Forecast trial 1 |  |  |  |  |  |  |  |  |  | 2022-09-08 00:00:00 | 2022-09-08 00:00:00 |  | 0 | 8 | 8 | 8 | 0 | 8 | 8 | 8 | 5 | 8 | 8 | 8
FC10001 | Forecast trial 1 |  |  |  |  |  |  |  |  |  | 2022-09-08 00:00:00 | 2022-09-08 00:00:00 |  | 0 | 8 | 8 | 8 | 0 | 8 | 8 | 8 | 5 | 8 | 8 | 8
Spreadsheet: 153234d1335814914-need-help-consolidating-data-across-multiple-sheets-warehouse-store-order-list-4-30-12
Sheet: Snacks

Ordered | Item | Description | Retail | Heat Level | Category
 | [NAME] | Chili Crescents, 12 oz. | 6.95 | 1 | Snacks
 | D2105 | [NAME], 12 oz. | 6.95 | 1 | Snacks
 | R114 | Pistachio & Roasted Pepper Dip, 12 oz. | 9.95 | 1 | Snacks
 | R16 | Queso [NAME], 16 oz. | 6.95 | 5 | Snacks
 | R14 | Queso [NAME], 16 oz. | 6.95 | 1 | Snacks
 | R12 | Queso [NAME], 16 oz. | 6.95 | 3 | Snacks
 | R28 | [NAME], 12 oz. | 8.95 | 1 | Snacks
 | R210 | [NAME] [NAME], 12 oz. | 8.95 | 1 | Snacks
 | WS7774 | Tasty Dead Cow Cajun Beef Jerky | 7.95 |  | Snacks
 | WS7772 | Tasty Dead Cow Ghost Pepper Beef Jerky | 8.95 | 8 | Snacks
 | WS7712 | Tasty Dead Cow Original Beef Jerky | 7.95 | 7 | Snacks
 | WS7710 | Tasty Dead Cow Teriyaki Beef Jerky | 7.95 | 2 | Snacks
 | Q192 | [NAME], 12 oz. | 6.95 | 6 | Snacks
 | Q194 | Wasabi Peas, 12 oz. | 6.95 | 6 | Snacks
Spreadsheet: john_griffith__15646__Book1
Sheet: Sheet1

 |  |  | Natural Gas Straddles
 | Month | Strike | Bid | Offer | Mid-Pt. Vol | Net Change
 | M | 4.2 | 0.39 | 0.43 | 0.5635999999999918 | 0.02369999999999739
 | N | 4.25 | 0.66 | 0.7 | 0.551599999999995 | 0.01379999999999848
 | Q | 4.35 | 0.87 | 0.93 | 0.5655999999999946 | 0.02519999999999722
 | U | 4.35 | 1.03 | 1.07 | 0.5556999999999964 | 0.01139999999999874
 | V | 4.4 | 1.19 | 1.23 | 0.5702999999999954 | 0.01679999999999815
 | X | 4.6 | 1.395 | 1.4 | 0.5741999999999963 | 0.02009999999999779
 | Z | 4.75 | 1.57 | 1.63 | 0.5875999999999949 | 0.02069999999999772
 | F | 4.85 | 1.745 | 1.79 | 0.596599999999995 | 0.02519999999999722
 | G | 4.7 | 1.78 | 1.8 | 0.5881999999999963 | 0.01949999999999785
 | H | 4.55 | 1.61 | 1.65 | 0.5266999999999967 | 0.01229999999999865
 | J | 4.2 | 1.24 | 1.28 | 0.4198999999999963 | 0.01589999999999825
 | K | 4.15 | 1.1 | 1.22 | 0.3799999999999986 | 0.01229999999999865
 |  |  | 2001-05-09 10:48:59.810000
Spreadsheet: 139539d1328287721-ranking-formula-used-in-conjunction-with-a-selection-box-test-example-ranks
Sheet: Analysis

 |  |  |  |  | Select org | office  A
 |  |  |  |  | submit plan | Jan mon Act | Jan YTD actuals | delta plan to month act | delta plan to YTD act
 |  | Mission AA
 |  |  | Program 1
 |  |  | Program 2
 |  |  | Program 3
 |  |  | Program 4
 |  | Mission BB
 |  |  | Program 5
 |  |  | Program 6
 |  |  | Program 7
 |  |  | Program 8
 |  |  | Program 9
 |  |  | Program 10
 |  |  | Program 11
 |  |  | Program 12
 |  | Mission CC
 |  |  | Program 13
 |  |  | Program 14
 |  |  | Program 15
 |  |  | Program 16
 |  |  | Program 17
 |  |  | Program 18
 |  |  | Program 19
 |  | Mission DD
 |  |  | Program 20
 |  |  | Program 21
 |  |  | Program 22
 |  |  | Program 23
 |  | Mission EE
 |  |  | Program 24
 |  |  | Program 25
 |  |  | Program 26
 |  |  | REFERENCE |  |  |  | DELTA |  |  | YTD
 |  |  |  | Delta | YTD |  | Mission | Ranking |  | Mission | Ranking
 |  |  | Mission AA
 |  |  | Mission BB
 |  |  | Mission CC
 |  |  | Mission DD
 |  |  | Mission EE
Spreadsheet: 187416d1350453517-help-with-look-up-functions-example17th
Sheet: Sheet3

Number | Box Number
190 | 534
8 | 65
234 | 391
613 | 862
702 | 324
97 | 831
659 | 869
273 | 937
305 | 961
639 | 28
756 | 25
575 | 65
191 | 47
94 | 250
908 | 65
771 | 361
814 | 590
182 | 203
9 | 472
205 | 843
402 | 688
435 | 364
184 | 160
658 | 312
694 | 73
363 | 996
594 | 694
865 | 831
674 | 619
Spreadsheet: 144800d1331141511-vlookup-not-returning-the-correct-value-in-cell-paycheck-calculator-b
Sheet: FEGLI

Enter your annual rate of basic pay. | 59294
If not an even thousand, round up to the next even thousand | 60000
Add $2,000 | 2000
Add the amounts in Lines 2 and 3 | 62000
Enter the Age Multiplication Factor* | 2
Multiply the amount in line 4 times the amount in line 6. This is the total amount of Basic you have at your present age. | 124000
Divide the amount in line 4 by $1,000 | 62
This is how much you pay for Basic each pay period | 9.299999999999999
OPTION A
$10,000 Flat. Cost: $0.30/2-weeks | 0.3
OPTION B
Enter the Amount from Line 2 | 60000
Enter the number of multiples you elect (1,2,3,4, or 5) | 5
Multiply the amount in line 17 by the amount in line 18. This is the amount of your Option B Coverage | 300000
Divide the amount in line 19 by $1,000 | 300
Enter the Option B cost for your age group from Rate Page | 0.02
Multiply the amount in line 20 by the amount in line 21 | 6
OPTION C
Enter the Option C cost for your age group from Rate Page | 0.22
Enter the number of multiples you want (from 1 to 5) | 5
 | 1.1
Total Cost for Optional Insurance (A,B, & C) | 7.4
Total Employee Insurance Coverage (Self) | 424000
Spreadsheet: 221213d1363417396-formula-for-data-input-values-new-microsoft-office-excel-worksheet-2-
Sheet: Sheet1

 |  |  | 2 | - | 2 | 2 | 3 | 3 | 4
 |  |  | 6 | 4 | - | - | 1 | 1 | 2
 |  |  | 1 | 1 | U | U | 3 | - | 2
 |  |  | 2 | 1 | - | - | 9 | 4 | 3 |  | Position | Value
 |  |  | 6 | - | 2 | 2 | 2 | 3 | 3 |  | 1 | 5
 |  |  | 3 | F | 6 | 6 | / | 4 | P |  | 2 | 4
 |  |  | 0 | 6 | 7 | 7 | F | 8 |  |  | 3 | 3
 |  |  | 0 | 3 | - | - | 0 | 4 | 3 |  | 4 | 2
 |  |  | F | 5 | 0 | 0 | - | 1 | 0 |  | 5 | 1
 |  |  | 7 | - | 1 | 1 | 0 | 1 | 1
 |  |  | 1 | 2 | 1 | 1 | 1 | 3 | 2
 |  |  | F | 1 | 1 | 1 | - | 0 | 2
 |  |  | 1 | 9 | 0 | 0 | / | 6 | 0
 |  |  | 1 | 1 | 1 | 1 | 4 | 4 | 2
 |  |  | 2 | 1 | 8 | 8 | - | 2 | P
 |  |  | 0 | - | 2 | 2 | 1 | 0
 |  |  | 1 | - | 6 | 6 | 2 | 6 | 8
 |  |  | 1 | 2 | 0 | 0 | 7 | - | 0
 |  |  | 3 | - | P | P | 3 | 3 | 3
 |  |  | 3 | 8 | - | - | 4 | 0 | 5
 |  |  | 1 | 1 | 9 | 9 | 1
 |  |  | 7 | 3 | 7 | 7 | 3 | / | 0
 |  |  | 5 | 1 | 1 | 1 | - | 3 | 0
 |  |  | 1 | 9 | 2 | 2 | 3
 |  |  | 6 | 2 | - | - | 1 | 3 | 8
 |  |  | F | 2 | 2 | 2 | 2 | U
 |  |  | 1 | 1 | 2 | 2 | 1
 |  |  | F | 1 | 3 | 3 | 3 | 2 | P
Spreadsheet: mary_fischer__25634__31Q
Sheet: E18YTD.XLS

ENRON CORP AND CONSOLIDTED SUBSIDIARIES
COMPANY #  031Q
COMPANY NAME    Limbach Constructors
ANALYSIS OF RESERVE ITEMS
FOR THE YEAR ENDED 12-31-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-18
 |  | 12-31-2000 Balance |  | ADDITIONS  DR (CR) |  |  |  | DEDUCTIONS  DR (CR)
 |  | DR. (CR) |  | RECORDED TO |  | RECORDED TO |  | RECORDED TO |  | RECORDED TO |  | DR. (CR)
[NAME] |  | BEGINNING BALANCE |  | INCOME STATEMENT |  | OTHER ACCOUNTS |  | INCOME STATEMENT |  | OTHER ACCOUNTS |  | ENDING BALANCE |  | COMMENTS/EXPLANATIONS
Allowance for Doubtful Accounts
(MUST TIE TO HYPERION LINE 0065)
Asset/Expense Accts:  DR/(CR)  Same signs as Hyperion
Reserve for Regulatory Issues - Current
(MUST TIE TO HYPERION LINE 0641)
Income Accts:  DR/(CR)  Reverse signs from Hyperion
Reserve for Regulatory Issues - Long Term
(MUST TIE TO HYPERION LINE 0815)
Income Accts: DR/(CR)  Reverse signs from Hyperion
Other Reserves - Other
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
(MUST TIE TO HYPERION LINE 0840)
Income Accts: DR/(CR)  Reverse signs from Hyperion
Hyperion Line #   and Description of Other Reserves   (not listed above)
Total Other Reserves  DR/(CR)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-18
Spreadsheet: 0dece6ba-9cbb-4708-b791-ffc172b18493
Sheet: October

 | SUNDAY
 |  | 2014-09-29 00:00:00 | 2014-09-30 00:00:00 | 2014-10-01 00:00:00 | 2014-10-02 00:00:00 | 2014-10-03 00:00:00 | 2014-10-04 00:00:00
 |  | 2014-10-06 00:00:00 | 2014-10-07 00:00:00 | 2014-10-08 00:00:00 | 2014-10-09 00:00:00 | 2014-10-10 00:00:00 | 2014-10-11 00:00:00
 |  | 2014-10-13 00:00:00 | 2014-10-14 00:00:00 | 2014-10-15 00:00:00 | 2014-10-16 00:00:00 | 2014-10-17 00:00:00 | 2014-10-18 00:00:00
 |  | Columbus Day Bank Holiday
 |  | 2014-10-20 00:00:00 | 2014-10-21 00:00:00 | 2014-10-22 00:00:00 | 2014-10-23 00:00:00 | 2014-10-24 00:00:00 | 2014-10-25 00:00:00
 |  | 2014-10-27 00:00:00 | 2014-10-28 00:00:00 | 2014-10-29 00:00:00 | 2014-10-30 00:00:00 | 2014-10-31 00:00:00 | 2014-11-01 00:00:00
 |  | Campus files to CO by noon | Delete Deadline 5pm | ACH File to Treasury |  | Pay Day
 |  | 2014-11-03 00:00:00 | NOTES
Spreadsheet: 45249d1244035013-counting-by-2-or-more-criteria-example
Sheet: Summary

Date | Cathy |  |  |  | [NAME] |  |  |  | Dawn |  |  |  | [NAME] |  |  |  | [NAME]
 | S Jobs Opened | W Jobs Opened | s Jobs Closed | W Jobs Closed | S Jobs Opened | W Jobs Opened | S Jobs Closed | W Jobs Closed | S Jobs Opened | W Jobs Opened | S Jobs Closed | W Jobs Closed | S Jobs Opened | W Jobs Opened | S Jobs Closed | W Jobs Closed | S Jobs Opened | W Jobs Opened | S Jobs Closed | W Jobs Closed
2009-05-01 00:00:00
2009-05-02 00:00:00
2009-05-03 00:00:00
2009-05-04 00:00:00
2009-05-05 00:00:00
2009-06-01 00:00:00
2009-06-02 00:00:00
2009-06-03 00:00:00
2009-06-04 00:00:00
2009-06-05 00:00:00
Spreadsheet: 32500d1228718652-autosum-or-update-of-another-worksheet-abc-co
Sheet: Nov'08

ABC Co., Ltd
Company Performance Summary Report (Nov'08)
2. Customer Sales
Customer | 1st Week | 2nd Week | 3rd Week | 4th Week | Total Month
Solectron | 0 | 128791.78 | 0 |  | 128791.78
Dage | 0 | 1486 | 0 |  | 1486
K&S | 0 | 2280 | 0 |  | 2280
Flextronic | 0 | 387.8 | 0 |  | 387.8
[NAME] | 0 | 0 | 6261.440000000001 |  | 6261.440000000001
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
Total | 0 | 132945.58 | 6261.440000000001 | 0 | 139207.02
Spreadsheet: 858128d1706885284-formula-for-weekly-from-daily-week-calendar-dj
Sheet: Weekly

 | Week1 | Week2 | Week3 | Week4 | Week5 | Week6 | Week7
 | 2024-01-05 00:00:00
Opening Balance
Receipts
Payments
Closing Balance
Spreadsheet: cfce2cb3-1d69-422f-9ecf-9aa63432b815
Sheet: Segments

Johnson & Johnson and Subsidiaries
Supplementary Sales Data
([NAME]; Dollars in Millions) |  |  |  |  | THIRD QUARTER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NINE MONTHS
 |  |  |  |  |  |  |  |  |  |  | Percent Change |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Percent Change
 |  |  | Pulls fm Rpt | Adj | 2010 |  | 2009 |  | Change $ |  | Total |  | Operations $ |  | Operations |  | Currency $ |  | Currency |  | Prior Q YTD | Pulls fm Rpt | Adj | 2010 |  | 2009 |  | Change $ |  | Total |  | Operations $ |  | Operations |  | Currency $ |  | Currency
Sales to customers by
segment of business
Consumer
U.S. |  | Great | 1277 |  | 1277 |  | 1691 |  | -414 |  | -24.5 | % | -414 |  | -24.5 |  | 0 |  | 0 |  | 3023 | 4300 |  | 4300 |  | 5125 |  | -825 |  | -16.1 | % | -825 |  | -16.1 |  | 0 |  | 0
International |  | -1 | 2291 | -1 | 2290 |  | 2298 |  | -8 |  | -0.3 |  | 8 |  | 0.4 |  | -16 |  | -0.7 |  | 4390 | 6680 |  | 6680 |  | 6429 |  | 251 |  | 3.9 |  | 32 |  | 0.5 |  | 219 |  | 3.4
 |  | Great |  |  | 3567 |  | 3989 |  | -422 |  | -10.6 |  | -406 |  | -10.2 |  | -16 |  | -0.4 |  | 7413 |  |  | 10980 |  | 11554 |  | -574 |  | -5 |  | -793 |  | -6.9 |  | 219 |  | 1.9
Pharmaceutical
U.S. |  | Great | 3054 |  | 3054 |  | 2857 |  | 197 |  | 6.9 |  | 197 |  | 6.9 |  | 0 |  | 0 |  | 6316 | 9370 |  | 9370 |  | 9703 |  | -333 |  | -3.4 |  | -333 |  | -3.4 |  | 0 |  | 0
International |  | Great | 2441 |  | 2441 |  | 2392 |  | 49 |  | 2 |  | 111 |  | 4.6 |  | -62 |  | -2.6 |  | 4875 | 7316 |  | 7316 |  | 6824 |  | 492 |  | 7.2 |  | 363 |  | 5.300000000000001 |  | 129 |  | 1.9
 |  | Great |  |  | 5495 |  | 5249 |  | 246 |  | 4.7 |  | 308 |  | 5.9 |  | -62 |  | -1.2 |  | 11191 |  |  | 16686 |  | 16527 |  | 159 |  | 1 |  | 30 |  | 0.2 |  | 129 |  | 0.8
Med Devices & Diagnostics
U.S. |  | Great | 2800 |  | 2800 |  | 2766 |  | 34 |  | 1.2 |  | 34 |  | 1.2 |  | 0 |  | 0 |  | 5751 | 8551 |  | 8551 |  | 8194 |  | 357 |  | 4.4 |  | 357 |  | 4.4 |  | 0 |  | 0
International |  | Great | 3120 |  | 3120 |  | 3077 |  | 43 |  | 1.4 |  | 79 |  | 2.6 |  | -36 |  | -1.2 |  | 6606 | 9726 |  | 9726 |  | 9071 |  | 655 |  | 7.2 |  | 414 |  | 4.5 |  | 241 |  | 2.7
 |  | Great |  |  | 5920 |  | 5843 |  | 77 |  | 1.3 |  | 113 |  | 1.9 |  | -36 |  | -0.6 |  | 12357 |  |  | 18277 |  | 17265 |  | 1012 |  | 5.9 |  | 771 |  | 4.5 |  | 241 |  | 1.4
U.S. |  | Great | 7131 |  | 7131 |  | 7314 |  | -183 |  | -2.5 |  | -183 |  | -2.5 |  | 0 |  | 0 |  | 15090 | 22221 |  | 22221 |  | 23022 |  | -801 |  | -3.5 |  | -801 |  | -3.5 |  | 0 |  | 0
International |  | Great | 7851 |  | 7851 |  | 7767 |  | 84 |  | 1.1 |  | 198 |  | 2.6 |  | -114 |  | -1.5 |  | 15871 | 23722 |  | 23722 |  | 22324 |  | 1398 |  | 6.3 |  | 809 |  | 3.7 |  | 589 |  | 2.6
Worldwide |  | Great |  |  | 14982 |  | 15081 |  | -99 |  | -0.7 | % | 15 |  | 0.1000000000000001 |  | -114 |  | -0.8 |  | 30961 | 45943 |  | 45943 |  | 45346 |  | 597 |  | 1.3 | % | 8 |  | 0.001278752009721051 |  | 589 |  | 1.298721247990279
Spreadsheet: 7df327b7-02b6-49b4-8b7b-d331ef254498
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
SCLAM | Test | SCLAM | Chlamydia Serology, Serum | Chlamydia Serology, S | Micro-Immunofluorescent Antibody (MIF) Assay Includes Chlamydophila pneumoniae, Chlamydophila psittaci, and Chlamydia trachomatis. | Serum Gel Tube: SGT |  |  | 0.2 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.2 mL | 0.15 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | Chlamydophila pneumoniae IgG: <1:64 IgM: <1:10  Chlamydophila psittaci IgG: <1:64 IgM: <1:10  Chlamydia trachomatis IgG: <1:64 IgM: <1:10 | Monday through Saturday; 9 a.m. | Same day/1 day | 3 days |  | Profile |  |  |  |  | Rochester
SCLAM | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
SCLAM | Result | 185 | C. pneumoniae IgG | C. pneumoniae IgG | Alphanumeric |  |  |  |  | titer |  |  |  |  |  |  |  |  |  | 6913-8
SCLAM | Result | 186 | C. pneumoniae IgM | C. pneumoniae IgM | Alphanumeric |  |  |  |  | titer |  |  |  |  |  |  |  |  |  | 6914-6
SCLAM | Result | 190 | C. trachomatis IgG | C. trachomatis IgG | Alphanumeric |  |  |  |  | titer |  |  |  |  |  |  |  |  |  | 6919-5
SCLAM | Result | 191 | C. trachomatis IgM | C. trachomatis IgM | Alphanumeric |  |  |  |  | titer |  |  |  |  |  |  |  |  |  | 6920-3
SCLAM | Result | 187 | C. psittaci IgG | C. psittaci IgG | Alphanumeric |  |  |  |  | titer |  |  |  |  |  |  |  |  |  | 6916-1
SCLAM | Result | 188 | C. psittaci IgM | C. psittaci IgM | Alphanumeric |  |  |  |  | titer |  |  |  |  |  |  |  |  |  | 6917-9
SCLAM | Billing Component | SCLAM |  | Chlamydia IgM |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 86632
SCLAM | Billing Component | SCLAM |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 86631
Spreadsheet: 453686d1459414181-highlighting-cells-in-a-column-hadden-hill-masters-mess-about
Sheet: Player Scores

Player |  | Round 1 | Round 2 | Round 3 | Round 4
[NAME] | 3
[NAME] | 4
[NAME] | 5
[NAME] | 6 | 65
[NAME] | 7
[NAME] | 8 | 72
[NAME] | 9
[NAME] | 10
[NAME] | 11
[NAME] | 12
[NAME] | 13
Branden Grace | 14
[NAME] | 15 | 72
[NAME] | 16
[NAME] | 17
[NAME] | 18
[NAME] | 19
[NAME] | 20
[NAME] | 21
[NAME] | 22
[NAME] | 23
J.B [NAME] | 24
Shane Lowry | 25
[NAME] | 26 | 71
[NAME] | 27
An [NAME] | 28
[NAME] | 29
[NAME] | 30
[NAME] | 31
[NAME] | 32
[NAME] | 33
[NAME] | 34
[NAME] | 35
[NAME] | 36
[NAME] | 37
[NAME] | 38
[NAME] | 39
[NAME] | 40
[NAME] | 41
[NAME] | 42 | 73
[NAME] | 43
[NAME] | 44 | 71
[NAME] | 45
[NAME] | 46
[NAME] | 47
[NAME] | 48
[NAME] | 49
[NAME] | 50
[NAME] | 51
[NAME] | 52
[NAME] | 53
[NAME] | 54
[NAME] | 55
[NAME] | 56
[NAME] | 57
[NAME] | 58
[NAME] | 59
[NAME] | 60
[NAME] Poulter | 61
Harris English | 62
[NAME] | 63
[NAME] | 64
[NAME] | 65 | 73
[NAME] | 66
[NAME] | 67
[NAME] | 68
[NAME] | 69
Troy Merritt | 70
[NAME] | 71
[NAME] | 72
[NAME] | 73
[NAME] | 74
[NAME] | 75
[NAME] | 76
Bernhard Langer | 77
[NAME] | 78
[NAME] | 79
[NAME] | 80
[NAME] | 81
[NAME] | 82
[NAME] | 83
[NAME] | 84
[NAME] | 85
[NAME] | 86
[NAME] | 87
[NAME] | 88
Romain Langasque | 89
[NAME] | 90
[NAME] | 91
[NAME] | 92
[NAME] | 93
Spreadsheet: 014c5f52-02c5-4038-9be5-c51f9ce04e00
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
HAVM | Test | HAVM | Hepatitis A IgM Antibody, Serum | Hepatitis A IgM Ab, S | Chemiluminescence Immunoassay | Serum Gel Tube: SGT |  |  | 2 | mL | Collection Container/Tube: Serum gel Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions: Spin down and remove serum from clot. Additional Information: Date of draw is required. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	NA | Negative  See Viral Hepatitis Serologic Profiles in Special Instructions. | Monday through Saturday; Varies | 1 day | 2 days | 1 | 86709 |  |  |  |  | Rochester
HAVM | [NAME] | SST | Serum SST |  |  |  | Frozen
HAVM | Result | HAVM | Hepatitis A IgM Ab, S | Hepatitis A IgM Ab, S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22314-9
Spreadsheet: 172956d1344382723-trying-to-figure-out-a-formula-to-get-minif-and-maxif-formulas-min-if-max-if-possibility-day92
Sheet: Sheet1

RoleNo | ResourceName | RollOn | RollOff | Roll on | Roll off
68 | Resource A | 2012-02-01 00:00:00 | 2012-04-27 00:00:00
 | Resource A | 2012-04-30 00:00:00 | 2013-01-31 00:00:00
 | Resource A | 2013-02-01 00:00:00 | 2013-04-19 00:00:00
 | Resource A | 2013-04-22 00:00:00 | 2013-12-27 00:00:00
79 | Resource B | 2012-02-01 00:00:00 | 2012-04-27 00:00:00
 | Resource B | 2012-04-30 00:00:00 | 2013-01-31 00:00:00
 | Resource B | 2013-02-01 00:00:00 | 2013-04-19 00:00:00
 | Resource B | 2013-04-22 00:00:00 | 2013-12-27 00:00:00
88 | Resource C | 2012-02-01 00:00:00 | 2012-04-27 00:00:00
 | Resource C | 2012-04-30 00:00:00 | 2012-08-24 00:00:00
 | Resource C | 2012-08-27 00:00:00 | 2013-01-31 00:00:00
 | Resource C | 2013-02-01 00:00:00 | 2013-04-19 00:00:00
 | Resource C | 2013-04-22 00:00:00 | 2013-11-22 00:00:00
Spreadsheet: 118192d1313514302-rating-system-build-example-1
Sheet: Sheet1

 | Covers
 | Cover
 | C.C | Sum insured | Excess
Company 1 | Optional | $500k | 50
Company 2 | Standard | $250k | 100
Company 3 | Standard enhanced | $200k | 200
Company 4 | Optional | $500k | 300
Company 5 | Optional | $400k | 400
Company 6 | Standard enhanced | $500k | 500
 | Points awarded
 | Cover
 | C.C | Sum insured | Excess
Company 1 | 1 | 2 | 5
Company 2 | 2 | 1 | 4
Company 3 | 3 | 1 | 3
Company 4 | 1 | 2 | 2
Company 5 | 1 | 1 | 1
Company 6 | 3 | 2 | 0
Spreadsheet: 870681d1717151063-summarise-multiple-tables-into-master-table-summary-formula-request-aligw
Sheet: StockC

 | Date | Stamp | FX | Comm |  | Year | Stamp | FX | Comm
 | 2019-03-29 00:00:00 | 25 |  | 4.95 |  | 2008
 | 2019-07-02 00:00:00 |  |  |  |  | 2009
 | 2019-12-06 00:00:00 |  |  |  |  | 2010
 | 2019-12-31 00:00:00 |  |  |  |  | 2011
 | 2020-06-04 00:00:00 | 50 |  | 9.95 |  | 2012
 | 2020-07-01 00:00:00 |  |  |  |  | 2013
 | 2020-07-02 00:00:00 | 39.99 |  | 4.95 |  | 2014
 | 2020-07-14 00:00:00 | 129.96 |  | 5.95 |  | 2015
 | 2020-07-14 00:00:00 |  |  | 5.95 |  | 2016
 | 2020-07-16 00:00:00 | 25 |  | 4.95 |  | 2017
 | 2020-07-21 00:00:00 | 9.99 |  | 4.95 |  | 2018
 | 2020-07-21 00:00:00 | 162.95 |  | 5.95 |  | 2019
 | 2020-07-21 00:00:00 |  |  | 5.95 |  | 2020
 | 2020-07-24 00:00:00 |  |  | 5.95 |  | 2021
 | 2020-08-07 00:00:00 | 49.97 |  | 4.95 |  | 2022
 | 2020-10-21 00:00:00 |  |  | 4.95 |  | 2023
 | 2020-10-21 00:00:00 |  |  | 4.95 |  | 2024
 | 2020-10-23 00:00:00 | 25.76 |  | 4.95 |  | 2025
 | 2020-10-23 00:00:00 | 49.82 |  | 4.95 |  | 2026
 | 2020-11-02 00:00:00 |  |  | 5.95 |  | 2027
 | 2020-11-16 00:00:00 | 75.37 |  | 5.95 |  | 2028
 | 2020-11-17 00:00:00 | 24.97 |  | 4.95 |  | 2029
 | 2020-12-04 00:00:00 |  |  |  |  | 2030
 | 2020-12-18 00:00:00 | 9.94 |  | 4.95 |  | 2031
 | 2020-12-21 00:00:00 |  |  | 5.95 |  | 2032
 | 2020-12-21 00:00:00 |  |  | 4.95 |  | 2033
 | 2020-12-21 00:00:00 | 9.68 |  | 4.95 |  | 2034
 | 2020-12-21 00:00:00 | 115.14 |  | 5.95 |  | 2035
 | 2020-12-23 00:00:00 |  |  | 5.95 |  | 2036
 | 2020-12-30 00:00:00 | 14.98 |  | 4.95 |  | 2037
 | 2020-12-30 00:00:00 | 14.98 |  | 4.95 |  | 2038
 | 2021-12-30 00:00:00 | 9.94 |  | 4.95 |  | 2039
 | 2020-12-31 00:00:00 | 24.95 |  | 4.95 |  | 2040
 | 2020-12-31 00:00:00 |  |  |  |  | 2041
 | 2022-01-05 00:00:00 | 9.95 |  | 4.95 |  | 2042
 | 2023-01-21 00:00:00 |  |  | 4.95 |  | 2043
 | 2023-02-23 00:00:00 | 9.96 |  | 4.95 |  | 2044