tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 167766d1342098570-phrase-clustering-using-excel-phrase-clustering
Sheet: Sheet1

 | S.No. | Input Statement | Output Statement
 | 1 | sgkndlk34j0934tnrlkgf | 16 MB
 | 2 | 16 MB | only 8 mb smart media card included
 | 3 | fngjdnfg4545y | only 32 mb card
 | 4 | [NAME] | only a 6 mb card
 | 5 | dfgjnfdjljnljpr | sgkndlk34j0934tnrlkgf
 | 6 | only 8 mb smart media card included | fngjdnfg4545y
 | 7 | vnlkdgtd456knkfdjgkdf | [NAME]
 | 8 | only 32 mb card | dfgjnfdjljnljpr
 | 9 | fnglfdkgkm;m6456 | vnlkdgtd456knkfdjgkdf
 | 10 | only a 6 mb card | fnglfdkgkm;m6456
Spreadsheet: 258793d1376854846-adult-baseball-league-schedule-2013fall-schedule-1-
Sheet: ALLTEAMS

 | REDWINGS |  |  |  |  | MUDCATS |  |  |  |  | SEADOGS |  |  |  |  | KEYS
week | Visitors | Home | Field |  | week | Visitors | Home | Field |  | week | Visitors | Home | Field |  | week | Visitors | Home | Field
 | BAYSOX |  |  |  |  | SENATORS |  |  |  |  | TIGERS
week | Visitors | Home | Field |  | week | Visitors | Home | Field |  | week | Visitors | Home | Field |  | week | Visitors | Home | Field
Spreadsheet: 463310d1464420261-data-validation-list-updating-data-validation-list
Sheet: Sheet1 (2)

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name |  |  |  |  | Name | Asc Order
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ram
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hari
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | fdf
Spreadsheet: 03d36890-5f87-48ab-a75d-6d9c12c38088
Sheet: MIS_Internships-1

Job ID | Organization Name | Job Title
48603 | LoanSifter | Content Management Specialist
48613 | Jewelers Mutual Insurance Company | Project Coordinator Intern
48496 | Maverick Software Consulting | Part-time Software Engineer
48316 | Greenpeace USA | Exciting Summer Internships with Greenpeace USA! (Various positions and locations)
48307 | Bemis Company, Inc. | HR/IT Intern - Summer 2013
48167 | UW Oshkosh Business Success Center | Education IT Internship
47964 | Verizon | Engineering Internship Opportunities (Dec 2013 or later graduates)
47400 | Footlocker.com/Eastbay | IT Operations Intern
47885 | Footlocker.com/Eastbay | Technical Services Internship
46931 | Oshkosh Corporation | IT Intern - SQL/Database
42811 | Humana | IT Summer Intern
Spreadsheet: f190e0ce-d471-428d-b2f9-0a79706a22ca
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
CA153 | Test | CA153 | [NAME] 15-3 (CA 15-3), Serum | [NAME] 15-3, (CA 15-3), S | Electrochemiluminescence Immunoassay | Plain, Red-Top Tube: Red |  |  | 0.5 | mL | Collection Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.45 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK  Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Males: <30 U/mL (use not defined) Females: <30 U/mL | Monday through Friday; 5 a.m.-12 a.m. Saturday; 6 a.m.-6 p.m. | 1 day | 3 days | 1 | 86300 |  |  |  |  | Rochester
CA153 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
CA153 | Result | CA153 | [NAME] 15-3, (CA 15-3), S | [NAME] 15-3, (CA 15-3), S | Numeric |  |  |  |  | U/mL |  |  |  |  |  |  |  |  |  | 6875-9
Spreadsheet: 848769d1699401304-list-of-all-worksheet-names-in-same-workbook-cash_test1
Sheet: Oct 22-Nov 04

 | Date | Total | Cash Paid in Payroll | Net Balance C - D | Cash Paid to Employee | Item #
 | 2023-10-22 00:00:00 | 0 |  |  |  | -
 | 2023-10-23 00:00:00 | 240 |  |  |  | 225, 229, 277
 | 2023-10-24 00:00:00 | 170 |  |  |  | 243, 269
 | 2023-10-25 00:00:00 | 485 | 100 |  | [NAME] | 234, 237, 239, 256, 275, 278
 | 2023-10-26 00:00:00 | 180 | 120 |  | Jassi | 223, 237
 | 2023-10-27 00:00:00 | 500 |  |  |  | 220, 236, 266
 | 2023-10-28 00:00:00 | 460 |  |  |  | 223, 259,274, 276
 | 2023-10-29 00:00:00 | 235 |  |  |  | 228, 235, 261
 | 2023-10-30 00:00:00 | 75 |  |  |  | 260
 | 2023-10-31 00:00:00 | 200 |  |  |  | 222, 231
 | 2023-11-01 00:00:00 | 170 |  |  |  | 220, 228
 | 2023-11-02 00:00:00 | 175 |  |  |  | 220, 229
 | 2023-11-03 00:00:00 | 592.75 |  |  |  | 232, 234, 242, 256, 257, 258, 265
 | 2023-11-04 00:00:00 | 440 |  |  |  | 232, 244, 256, 272, 278
Spreadsheet: 10eee736-1fc7-4fb2-90cc-75eb512fe485
Sheet: Sheet1

Table 3--U.S. fiber supply | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | Apr. | May | June | June
Item | 2012 | 2012 | 2012 | 2011
 | 1,000 480-lb. [NAME]
Cotton:
Ginnings | 0 | 0 | 0 | 0
Imports since August 1 | 13.9 | 14.1 | 18.2 | 8.8
Stocks, beginning | 8719 | 7201 | 5621 | 4883
At mills |  |  |  | 134
Public storage |  |  |  | 3552
CCC stocks | 2392 | 1872 | 1456 | 1352
 | Million pounds
Manmade:
Production | 535.9 | 521.8 | 500.9 | 460.5
Noncellulosic | 544.7 | 521.8 | 500.9 | 460.5
Cellulosic
Total since January 1 | 2013.7 | 2535.5 | 3036.4 | 3064.8
 | Mar. | Apr. | May | May
 | 2012 | 2012 | 2012 | 2011
 | Million pounds
Raw fiber imports: | 161.9 | 163.5 | 172 | 164.5
Noncellulosic | 144.8 | 149.7 | 157.7 | 150.3
Cellulosic | 17.1 | 13.8 | 14.3 | 14.2
Total since January 1 | 450.5 | 614 | 786 | 745.3
 | 1,000 pounds
Wool and mohair:
Raw wool imports, clean | 1018.9 | 880.7 | 919.9 | 698.5
48s-and-finer | 333.5 | 499.8 | 469.5 | 332.5
Not-finer-than-46s | 685.4 | 380.9 | 450.3 | 366
Total since January 1 | 2698.6 | 3579.3 | 4499.2 | 3252.5
Wool top imports | 243.3 | 214 | 200.7 | 129.5
Total since January 1 | 887.6 | 1101.6 | 1302.3 | 1347.8
Mohair imports, clean | 0 | 0 | 0 | 0
Total since January 1 | 0 | 0 | 0 | 2.3
NA = Not available.
Last update:  08/13/12.
Sources: USDA, National Agricultural Statistics Service; USDC,
U.S. Census Bureau; and [NAME].
Spreadsheet: 712890d1610466789-formula-depending-on-the-selection-from-drop-down-menu-untitled-spreadsheet
Sheet: Sheet1

Data | [NAME] | [NAME] | Metrai | Savikaina | Apmokėta
 |  | Veliuras | 5 |  |  |  |  | Pasirinkti
 |  | Veliuras |  |  |  |  | 15 | [NAME]
 |  | Veliuras |  |  |  |  | 14 | Veliuras
 |  | Veliuras |  |  |  |  | 13 | Veliuras(AR01403)
 |  | Veliuras |  |  |  |  | 12 | Kapronas
 |  | Veliuras |  |  |  |  | 11 | Tinklelis(Brangus)
 |  | Veliuras |  |  |  |  | 10 | Tinklelis(Pigus)
 |  | Veliuras |  |  |  |  | 7 | Šilkas
 |  | Veliuras |  |  |  |  | 4 | Linas
 |  | Veliuras |  |  |  |  | 20 | Blackout
Spreadsheet: chris_germany__1791__Exhibit1
Sheet: Other Strg

VIRGINIA NATURAL GAS
INTERSTATE PIPELINE CAPACITY CONTRACTS
LNG STORAGE SERVICES
PIPELINE |  | SERVICE | MDQ | MDWQ | Contract | [NAME]. | Delivery Pt | Expiration | Comments
 |  |  | dth/day | dth |  |  |  | Date
CNGT |  | LNG | 100000 | 10000 | FPS-10 | CNG STRG | VNG City Gate | 2001-10-31 00:00:00 | Available Dec, Jan and Feb of each year/demand accessed accordingly
COLUMBIA GAS |  | LNG X-133 | 778500 | 52090 |  | STRG | VNG City Gate | 2004-03-31 00:00:00
Company Owned Propane
Northern Division
Southern Division
Spreadsheet: 724854d1616421323-calculating-sales-lift-only-for-cells-based-on-effective-date-pbg-chain-activity-program-template-test
Sheet: TEMPLATE

 | Brand |  | SKU
 | Size |  | CHAIN |  |  |  |  | CHAIN EVENT
 | Event Type |  | Event Length |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Comments
 |  |  |  |  |  |  |  | 4.28571428571428 | 4 | 4.42857142857142 | 4.28571428571428 | 4.42857142857142 | 4.28571428571428 | 4.42857142857142 | 4.42857142857142 | 4.28571428571428 | 4.42857142857142 | 4.28571428571428 | 4.42857142857142 | weeks
 | State | PODs |  | CPSPW |  | EFFECTIVE DATE |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | TOTAL
 | ALABAMA | Current | 100 | Current | 0.5
 |  | Change (+/-) | 50 | Upper | 0.8
 |  | New |  | Lower | 0.4 | APR
 | ALASKA | Current | 100 | Current | 0.2
 |  | Change (+/-) | 50 | Upper | 2
 |  | New |  | Lower | 0.5 | MAY
 | ARIZONA | Current | 100 | Current | 1
 |  | Change (+/-) | 50 | Upper | 3
 |  | New |  | Lower | 1.5 | JUN
 | ARKANSAS | Current | 100 | Current | 0.2
 |  | Change (+/-) | 50 | Upper | 1
 |  | New |  | Lower | 0.5 | JUL
 | CALIFORNIA | Current | 100 | Current | 1
 |  | Change (+/-) | 50 | Upper | 2
 |  | New |  | Lower | 1 | AUG
 | TOTAL | Current |  | Current
 |  | Change (+/-) |  | Upper
 |  | New |  | Lower
Spreadsheet: 767221d1644341819-sorting-in-several-tables-book1123
Sheet: Sheet1

 |  | nr | score |  | nr | score |  | nr | score
 |  | 473 | 4 |  | 283 | -9 |  | 142 | 168.4
 |  | 163 | 3 |  | 371 | -8.5 |  | 283 | 162.3
 |  | 508 | 4 |  | 214 | -8 |  | 371 | 156.2
 |  | 534 | 3 |  | 405 | -7.5 |  | 214 | 150.1
 |  | 568 | 3 |  | 354 | -7 |  | 405 | 144
 |  | 84 | 2.8 |  | 314 | -6.5 |  | 354 | 137.9
 |  | 406 | 2.6 |  | 50 | -6 |  | 314 | 131.8
 |  | 576 | 2.4 |  | 538 | -5.5 |  | 50 | 125.7
 |  | 428 | 2.2 |  | 582 | -5 |  | 538 | 119.6
 |  | 124 | 2 |  | 326 | -4.5 |  | 582 | 113.5
 |  | 339 | 1.8 |  | 75 | -4 |  | 326 | 107.4
 |  | 135 | 1.6 |  | 288 | -3.5 |  | 75 | 101.3
 |  | 183 | 1.4 |  | 453 | -3 |  | 288 | 95.2
 |  | 404 | 1.2 |  | 206 | -2.5 |  | 453 | 89.1
 |  | 206 | 1 |  | 404 | -2 |  | 206 | 83
 |  | 453 | 0.8 |  | 183 | -1.5 |  | 404 | 76.9
 |  | 288 | 0.6 |  | 135 | -1 |  | 183 | 70.8
 |  | 75 | 0.4 |  | 339 | -0.5 |  | 135 | 64.7
 |  | 326 | 0.2 |  | 124 | 0 |  | 339 | 58.6
 |  | 582 | 0 |  | 428 | 0.5 |  | 124 | 52.5
 |  | 538 | -0.2 |  | 576 | 1 |  | 428 | 46.4
 |  | 50 | -0.4 |  | 406 | 1.5 |  | 576 | 40.3
 |  | 314 | -0.600000000000001 |  | 142 | 2 |  | 406 | 34.2
 |  | 354 | -0.8 |  | 84 | 2 |  | 568 | 34
 |  | 405 | -1 |  | 568 | 2.5 |  | 84 | 28.1
 |  | 214 | -1.2 |  | 163 | 3 |  | 473 | 4
 |  | 371 | -1.4 |  | 534 | 3 |  | 508 | 4
 |  | 283 | -1.6 |  | 508 | 4 |  | 534 | 4
 |  | 142 | -1.8 |  | 473 | 5 |  | 163 | 3
Spreadsheet: 697772d1601516588-calculate-the-aggregate-value-of-cells-using-the-value-of-another-cell-sample2
Sheet: Sheet5

ID: | Field1 | Field2 | Expected Value 1: | Expected Value 2:
1003708 | 43743 | 28736 | 43743 | 28736
1004092 | 375371936 | 193374884 | 2627603552 | 1353974736
1004092 | 375371936 | 193462492 | 2627603552 | 1353974736
1004092 | 375371936 | 193462492 | 2627603552 | 1353974736
1004092 | 375371936 | 193462492 | 2627603552 | 1353974736
1004092 | 375371936 | 193462492 | 2627603552 | 1353974736
1004092 | 375371936 | 193374942 | 2627603552 | 1353974736
1004092 | 375371936 | 193374942 | 2627603552 | 1353974736
1004093 | 371603877 | 136204080 | 743207754 | 272408160
1004093 | 371603877 | 136204080 | 743207754 | 272408160
1004374 | 370611192 | 183387533 | 370611192 | 183387533
1005044 | 282 | 265 | 564 | 530
1005044 | 282 | 265 | 564 | 530
Spreadsheet: 835713d1688745703-find-multiple-occurrence-of-id-within-ranked-list-return-unique-id-unique-rank-example-v3
Sheet: Sheet1

ID | Rank | Child ID |  | Example Result: | ID | Rank
1001 | 1 | 1002 |  |  | 1001 | 1
1001 | 1 | 1005 |  |  | 1003 | 3
1001 | 1 | 1007 |  |  | 1008 | 8
1002 |  | 1008 |  |  | 1010 | 10
1002 | 2 | 1009
1003 |  | 1004
1003 | 3 | 1006
1003 | 3 | 1007
1004 |  | 1009
1004 | 4 | 1010
1005 |  | 1009
1005 | 5 | 1010
1006 |  | 1007
1006 | 6 | 1008
1007 |  | 1008
1007 | 7 | 1009
1007 | 7 | 1010
1008 | 8 | 1009
1008 | 8 | 1009
1009 | 9 | 1010
1010 | 10 | 1020
1010 | 10 | 1030
Spreadsheet: 721304d1614631756-index-match-increase-column-reference-by-1-as-formula-extended-index-match-example
Sheet: Sheet1

NAME | transport | weight | location | food | height
[NAME]
[NAME]
Todd
[NAME]
[NAME]
[NAME]
NOTES
I have locked column A for match, but not the number, this will work for producing values in column B when draggging down
However, I need the formula to work ACROSS columns C to G as well, and the formula is not flexible for giving column updates (i.e increase by 1) - I have ordered the columns to line up to allow for something as easy as this
Spreadsheet: 800241d1665557639-index-and-match-ref-error-cash-budget-template
Sheet: project_data

 | PROJECT DATA
1 | Project name | Project ABC
2 | Profit center | JO # 2888
3 | Client name | ABC Company | (let's think if it would be useful to assigned client codes)
4 | Contract amount | 1000000000
5 | Margin | 150000000
6 | Start date | 2022-01-01 00:00:00
7 | End date | 2022-12-31 00:00:00
8 | Advance payment
 | Percentage | 0.15 | of contract
 | Billing period | 5 | days
 | Collection period | 15 | days
9 | Progress
 | Billing period | 30 | days
 | Collection period | 30 | days
10 | Retention
 | Percentage | 0.1 | of contract
 | Billing period | 60 | days
 | Collection period | 30 | days
12 | VAT | 0.12
 | Withholding | 0.02
Spreadsheet: 46010d1244793305-how-to-embedd-harvey-ball-symbol-in-a-cell-687312-how-to-embedd-harvey-ball-symbol-in-a-cell
Sheet: Sheet1

UNICODE | DECIMAL | [NAME] |  | Test
25CB | 9675 | ○ |  | ◔
25CF | 9679 | ●
25D0 | 9680 | ◐
25D1 | 9681 | ◑
25D2 | 9682 | ◒
25D3 | 9683 | ◓
25D4 | 9684 | ◔
25D5 | 9685 | ◕
Spreadsheet: 267725d1380150474-index-match-closest-value-excel-help2
Sheet: Geographic Adjustments

Location | 20000 | 30000 | 40000 | 50000 | 60000 | 70000 | 80000 | 90000
Atlanta | 0.043 | 0.033 | 0.038 | 0.053 | 0.046 | 0.045 | 0.044 | 0.01
[NAME] | 0.085 | 0.044 | 0.056 | 0.05 | -0.038 | -0.04 | -0.042 | -0.041
Spreadsheet: 93409d1292986305-how-do-i-sum-up-all-cells-in-different-sheets-to-a-cell-in-sheet1-timesheet-1-
Sheet: Sheet2

COMPANY NAME |  |  |  |  |  |  |  | EMPLOYEE TIME SHEET |  |  |  |  |  |  |  |  | Year 2010
DEPT.: |  | ENGINEERING |  |  |  |  |  |  | EMPLOYEE: |  |  | Employee Name |  |  |  |  |  | WEEK ENDING: |  |  |  | March 2 2010
 | WED |  | THUR |  | FRI |  | SAT |  | SUN |  | MON |  | TUE |  |  | TOTAL |  |  |  | JOB
 | REG | O.T. | REG | O.T. | REG | O.T. | REG | O.T. | REG | O.T. | REG | O.T. | REG | O.T. |  | REG | O.T. |  |  | NUMBER |  | PHASE |  | TYPE |  | JOB NAME
1 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 00Gen |  |  |  |  | 00Gen |  | 100 |  | OTH
 |  |  | 4 |  | 8 |  |  |  |  |  |  |  |  |  | 9038 |  |  |  |  | 9038
 | 4 |  |  |  |  |  |  |  |  |  | 8 |  | 4 |  | 9046 |  |  |  |  | 9046
 |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  | 10025 |  |  |  |  | 10025
 |  | 1 | 4 | 2 |  |  |  |  |  |  |  |  |  |  | 10010 |  |  |  |  | 10010
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10033 |  |  |  |  | 10033
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00Holiday |  |  |  |  | 00Holiday
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00Sick |  |  |  |  | 00Sick
TOT
In |  | am |  | am |  | am |  | am |  | am |  | am |  | am
Out |  | pm |  | pm |  | am |  | am |  | am |  | pm |  | am
Hrs
EMPLOYEE SIGNATURE:____________________________
SUPERVISOR SIGNATURE:__________________________
Spreadsheet: 694124d1599375451-countif-with-matching-criteria-row-and-column-book1
Sheet: Sheet1

 | 2020-09-01 00:00:00 | 2020-09-02 00:00:00 | 2020-09-03 00:00:00 | 2020-09-04 00:00:00 | 2020-09-05 00:00:00 | 2020-09-06 00:00:00 | 2020-09-07 00:00:00 | 2020-09-08 00:00:00
EMP1 | AL | MC | P | P | P | P | P | P
EMP2 | P | P | P | P | AL | P | P | P
EMP3 | MC | MC | MC | P | P | MC | MC | MC
Name | EMP1
Start Date | 2020-09-01 00:00:00
End Date | 2020-09-05 00:00:00
Count AL | 1
Count MC | 1
Count P | 3
Spreadsheet: 204613d1357586724-help-with-conditional-format-or-time-formula-master-plan-tracker-sample-1-
Sheet: Implementation Plan

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Initial Issue: |  |  |  |  |  |  |  | 1 |  | Updated: |  |  |  |  | 2013-01-07 00:00:00
 | [NAME] AND STATUS |  |  |  |  |  | JANUARY |  |  |  | FEBRUARY |  |  |  | [NAME] |  |  |  |  | APRIL |  |  |  |  | MAY |  |  |  | [NAME] |  |  |  | JULY |  |  |  |  | AUGUST |  |  |  | SEPTEMBER |  |  |  |  | OCTOBER |  |  |  | NOVEMBER |  |  |  | DECEMBER |  |  |  | JANUARY |  |  |  | FEBRUARY |  |  |  | [NAME]
No. | Section | Ref. | OWNER | SUPPORTING | DUE | STATUS | 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 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
0 | ANALYSIS OF REQUIREMENTS
 |  | 0 |  |  | 2013-01-15 00:00:00 | On Time
 |  | 0.1 |  |  | 2013-01-10 00:00:00 | Due
 |  | 0.2 |  |  | 2013-01-25 00:00:00 | On Time
 |  | 0.3 |  |  | 2013-01-05 00:00:00 | Late
1 | Machines
 |  | 1
 |  | 1.1
 |  | 1.2
 |  | 1.3
 |  | 1.4
 |  | 1.5
 |  | 1.6
 |  | 1.7
2 | Tooling
 |  | 2
 |  | 2.1
 |  | 2.2
 |  | 2.3
 |  | 2.4
 |  | 2.5
 |  | 2.6
 |  | 2.7
 |  | 2.8
 |  | 2.9
 |  | 2.91
 |  | 2.92
 |  | 2.93
 |  | 2.94
3 | Fixtures
 |  | 3
 |  | 3.1
 |  | 3.2
 |  | 3.3
 |  | 3.4
 |  | 3.5
 |  | 3.6
 |  | 3.7
 |  | 3.8
 |  | 3.9
 |  | 3.91
 |  | 3.92
 |  | 3.93
 | Review Output milestone | 3.94
4 | Programming
 |  | 4
 |  | 4.1
 |  | 4.2
 |  | 4.3
 |  | 4.4
 |  | 4.5
 |  | 4.6
 |  | 4.7
 |  | 4.8
 |  | 4.9
 |  | 4.91
 |  | 4.92
 |  | 4.93
 |  | 4.94
 |  | 4.95
 |  | 4.96
 |  | 4.97
 |  | 4.98
 | Review Output milestone
5 | RESOURCE MANAGEMENT
 |  | 5
 |  | 5.1
 |  | 5.2
 |  | 5.3
 |  | 5.4
 |  | 5.5
6 | MEASUREMENT, ANALYSIS AND IMP.
 |  | 6
 |  | 6.1
 |  | 6.2
 |  | 6.3
 |  | 6.4
 |  | 6.5
 |  | 6.6
 |  | 6.7
 |  | 6.8
 |  | 6.9
 |  | 6.91
 |  | 6.92
 |  | 6.93
 |  | 6.94
Spreadsheet: 801930d1666486461-how-can-i-return-an-array-of-if-function-results-if-test
Sheet: detail

 |  |  |  |  |  |  |  |  |  |  |  | Range | Num of 'deletes' |  | Matches in range | Count of opposite value in all of column C. | Matches in range excluding final row in range
 |  |  |  |  |  |  |  |  |  |  |  | C2:C2 | 0 |  | 0 | 4 | 0
 | [NAME] | -272.1 | 0101017 |  |  | If the formula in F31 worked it would have a total of |  |  |  |  |  | C2:C3 | 0 |  | 0 | 4 | 0
 | [NAME] | 272.09 | 0101017 |  |  | 27 'deletes'. |  |  |  |  |  | C2:C4 | 1 |  | 1 | 4 | 0
 | [NAME] | 272.09 | 0101017 |  |  |  |  |  |  |  |  | C2:C5 | 1 |  | 2 | 4 | 1
 | [NAME] | -272.09 | 0101017 |  |  |  |  |  |  |  |  | C2:C6 | 1 |  | 2 | 4 | 2
 | [NAME] | -272.09 | 0101017 |  |  |  |  |  |  |  |  | C2:C7 | 1 |  | 2 | 4 | 2
 | [NAME] | -272.09 | 0101017 |  |  |  |  |  |  |  |  | C2:C8 | 1 |  | 2 | 4 | 2
 | [NAME] | -230 | 0101017 |  |  |  |  |  |  |  |  | C2:C9 | 1 |  | 2 | 4 | 2
 | [NAME] | -224.54 | 0101017 |  |  |  |  |  |  |  |  | C2:C10 | 1 |  | 2 | 4 | 2
 | [NAME] | -191.94 | 0101017 |  |  |  |  |  |  |  |  | C2:C11 | 1 |  | 2 | 4 | 2
 | [NAME] | -173.27 | 0101017 |  |  |  |  |  |  |  |  | C2:C12 | 1 |  | 2 | 4 | 2
 | [NAME] | -139 | 0101017 |  |  |  |  |  |  |  |  | C2:C13 | 1 |  | 2 | 4 | 2
 | [NAME] | -124.8 | 0101017 |  |  |  |  |  |  |  |  | C2:C14 | 1 |  | 2 | 4 | 2
 | [NAME] | -88.3 | 0101017 |  |  |  |  |  |  |  |  | C2:C15 | 1 |  | 2 | 4 | 2
 | [NAME] | -68.62 | 0101017 |  |  |  |  |  |  |  |  | C2:C16 | 1 |  | 2 | 4 | 2
 | [NAME] | -42.83 | 0101017 |  |  |  |  |  |  |  |  | C2:C17 | 1 |  | 2 | 4 | 2
 | [NAME] | -40.31 | 0101017 |  |  |  |  |  |  |  |  | C2:C18 | 1 |  | 2 | 4 | 2
 | [NAME] | -38.88 | 0101017 |  |  |  |  |  |  |  |  | C2:C19 | 1 |  | 2 | 4 | 2
 | [NAME] | -32.39 | 0101017 |  |  |  |  |  |  |  |  | C2:C20 | 1 |  | 2 | 4 | 2
 | [NAME] | -32.1 | 0101017 |  |  |  |  |  |  |  |  | C2:C21 | 1 |  | 2 | 4 | 2
 | [NAME] | -19.61 | 0101017 |  |  |  |  |  |  |  |  | C2:C22 | 1 |  | 2 | 4 | 2
 | [NAME] | -5.77 | 0101017 |  |  |  |  |  |  |  |  | C2:C23 | 1 |  | 2 | 4 | 2
 | [NAME] | -5.2 | 0101017 |  |  |  |  |  |  |  |  | C2:C24 | 1 |  | 2 | 4 | 2
 | [NAME] | 0.02 | 0101017 |  |  |  |  |  |  |  |  | C2:C25 | 1 |  | 2 | 4 | 2
 | [NAME] | 0.02 | 0101017 |  |  |  |  |  |  |  |  | C2:C26 | 1 |  | 2 | 4 | 2
 | [NAME] | 0.03 | 0101017 |  |  |  |  |  |  |  |  | C2:C27 | 1 |  | 2 | 4 | 2
 | [NAME] | 0.06 | 0101017 |  |  |  |  |  |  |  |  | C2:C28 | 1 |  | 2 | 4 | 2
 | [NAME] | 0.07 | 0101017 |  |  |  |  |  |  |  |  | C2:C29 | 1 |  | 2 | 4 | 2
 | [NAME] | 0.08 | 0101017 |  |  |  |  |  |  |  |  | C2:C30 | 1 |  | 2 | 4 | 2
 | [NAME] | 272.09 | 0101017 |  |  |  |  |  |  |  |  | C2:C31 | 0 |  | 3 | 4 | 2
 | [NAME] | 272.09 | 0101017 |  |  |  |  |  |  |  |  |  |  |  |  | 4
 | [NAME] | -272.09 | 0101017
Spreadsheet: 736307d1623488725-evaluating-a-specified-array-for-2-or-more-criteria-and-returning-a-value-example-data
Sheet: Sheet1

Svc_Date | Clinic ID | Patient ID | Provider ID | Procedure Code ID | Procedure Category ID
2021-04-01 00:00:00 | Denver | 1234 | [NAME] | 26 | Non-Covid
2021-04-01 00:00:00 | Denver | 1234 | [NAME] | 27 | Non-Covid
2021-04-01 00:00:00 | Denver | 1234 | [NAME] | 28 | Non-Covid
2021-04-02 00:00:00 | Colorado Springs | 2234 | [NAME] | 02 | Office Visit
2021-04-02 00:00:00 | Colorado Springs | 2234 | [NAME] | 02 | Office Visit
2021-04-02 00:00:00 | Colorado Springs | 2234 | [NAME] | 29 | [NAME]
2021-04-03 00:00:00 | [NAME] | 5545 | Grant | 09 | [NAME]
2021-04-03 00:00:00 | [NAME] | 5545 | Grant | 30 | Office Visit
2021-04-03 00:00:00 | [NAME] | 5545 | Grant | 31 | Office Visit
2021-04-04 00:00:00 | Parker | 2234 | [NAME] | 02 | Office Visit
2021-04-04 00:00:00 | Parker | 2234 | [NAME] | 07 | Office Visit
2021-04-04 00:00:00 | Parker | 2234 | [NAME] | 32 | Office Visit
2021-04-04 00:00:00 | Denver | 5545 | [NAME] | 49 | [NAME]
2021-04-04 00:00:00 | Denver | 5545 | [NAME] | 50 | Office Visit
2021-04-05 00:00:00 | Denver | 1234 | [NAME] | 40 | [NAME]
Spreadsheet: 854238d1704194998-results-from-grid-grid-lookup-etaf
Sheet: Sheet1

 | Activity Band | Designated Site | Activity Location distance to non agricultural building in flood plain | Band Result
Band Lookup | In Channel Works | Non Designated Site | Activity greater 100m
 | Activity greater 100m | Activity greater 100m | Activity  within 100m | Activity  within 100m
Activity for charging | Designated Site | Non Designated Site | Designated Site | Non Designated Site
In channel works | M | L | M | M
Riverbank Works | M | L | M | M
Works to new and exisiting flood risk management assets | M | L | H | M
Flood Plain Works | M | L | M | M
Outfalls | L | L | L | L
Planning Permission | L | L | L | L
Spreadsheet: 459619f5-ffd5-4a5a-afbe-a07d7eab3a3c
Sheet: Sheet1

Release: Job Openings and Labor Turnover | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=192
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2013-05-21 1:05 PM CDT
 | Real-Time | Period
Name: | Start | End
Job Openings and Labor Turnover | 2010-08-11 00:00:00 | Current
Link:
http://www.bls.gov/jlt/ | 2010-08-11 00:00:00 | Current
Source:
U.S. Department of Labor: Bureau of Labor Statistics | 2010-08-11 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2010-08-11 00:00:00
2010-09-08 00:00:00
2010-10-07 00:00:00
2010-11-09 00:00:00
2010-12-07 00:00:00
2011-01-11 00:00:00
2011-02-08 00:00:00
2011-03-11 00:00:00
2011-04-13 00:00:00
2011-05-11 00:00:00
2011-06-07 00:00:00
2011-07-12 00:00:00
2011-08-10 00:00:00
2011-09-07 00:00:00
2011-10-12 00:00:00
2011-11-08 00:00:00
2011-12-13 00:00:00
2012-01-10 00:00:00
2012-02-07 00:00:00
2012-03-13 00:00:00
2012-04-10 00:00:00
2012-05-08 00:00:00
2012-06-19 00:00:00
2012-07-10 00:00:00
2012-08-07 00:00:00
2012-09-11 00:00:00
2012-10-10 00:00:00
2012-11-06 00:00:00
2012-12-11 00:00:00
2013-01-10 00:00:00
2013-02-12 00:00:00
2013-03-12 00:00:00
2013-04-09 00:00:00
2013-05-07 00:00:00