tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 128636d1321129929-vlookup-in-different-coumns-hooves-world-racing-syndicate-updated
Sheet: TOTALS

GROUP MEMBERS | WEEK 1 TOTAL | TUE WK1 | THU WK1 | SAT WK1 |  | WEEK 2 TOTAL | TUE WK2 | [NAME] | SAT WK2 |  | WEEK 3 TOTAL | TUE WK3 | THU WK3 | SAT WK3 |  | WK3 FINAL
[NAME]
[NAME]
[NAME]
Anne-Rita le Riche
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Carola Larsson
[NAME]
Chezza Goodgirl
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Dante Love Dancel Lara
[NAME]
[NAME]
Deb Mclean
[NAME]
Doreen Laws Hart
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
J T Patryck Voie
[NAME]
[NAME]
Jane-Marie Nash
[NAME]
[NAME]
[NAME]
Jen Rayoso
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME] [NAME]
[NAME]
[NAME]
[NAME]
[NAME] Condely
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 0f05b788-4497-4e9e-a8d7-71ed8a579a37
Sheet: 11d

Product | 0-3** | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120+ | TOTAL
Basis* |  | <100 | <100 | <100 | <100 | 126 | 136 | 262
FRA | 3608 | 2714 | 1578 | 2204 | <100 |  |  | 10104
IRS- [NAME] | <100 | <100 | 114 | 1710 | 5662 | 7642 | 9959 | 25087
OIS | 176 | 134 | 190 | 636 | 114 |  |  | 1250
VNS |  |  |  |  |  | <100 |  | <100
Zero Coupon | <100 | <100 |  | <100 | <100 | <100 | <100 | <100
TOTAL | 3784 | 2848 | 1882 | 4550 | 5776 | 7768 | 10095 | 36703
Estimated swap transaction volumes, week ending November 30, by product type and tenor (in number of transactions), all participant types and currencies.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**See Data Dictionary for tenor bucket descriptions.
***N/A indicates that data are not currently available.
Note: Transaction volumes currently include house and client trades by FCMs in the interest rate asset class.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 114515d1310228903-list-multiple-values-in-same-cell-questions-per-category
Sheet: Summary

Question Category | Questions in this Category | Finding Density | Finding Volume | Finding Mass | Finding Density | Finding Volume | Finding Mass | Finding Density | Finding Volume | Finding Mass
Finding Density | 1,3,7,10 | 2 |  |  | 1 | 2 | 5 | 1, | 2, | 5, | <- single row formula
Finding Volume | 2,4,9 |  | 3 |  | 3 | 4 | 6 | 1,3, | 2,4, | 5,6, | <- fill down this formula
Finding Mass | 5,6,8 | 4 |  |  | 7 | 9 | 8 | 1,3,7, | 2,4,9 | 5,6,8
 |  |  | 5 |  | 10 |  |  | 1,3,7,10
 |  |  |  | 6
 |  |  |  | 7
 |  | 8
 |  |  |  | 9
 |  |  | 10
 |  | 11
Spreadsheet: 9f4c79b0-46a0-4f4f-9868-1e384cb5df8a
Sheet: FTSE Summary

Average Total Expenditure per Full-Time Student Equivalent (FTSE)
Institution | Annual State Funded Semester Credit Hours | Total FTSE | Total Expenditure | Average Expenditure per FTSE
Alamo | 755848
Alvin | 86684
Amarillo | 159508
Angelina | 87427
[NAME] | 505853
Blinn | 274592
Brazosport | 64571
Central Texas | 183283
Cisco | 58526
[NAME] | 19047
Coastal Bend | 66866
College Of The Mainland | 67691
Collin | 228863
Dallas | 921503
Del Mar | 199527
El Paso | 379521
[NAME] | 24249
Galveston | 41768
[NAME] | 69996
Hill | 46121
Houston | 695696
[NAME] | 42149
Kilgore | 90864
Laredo | 150357
[NAME] | 121913
Lonestar | 443865
[NAME] | 125304
Midland | 93566
Navarro | 88663
North Central Texas | 90137
Northeast Texas | 44263
Odessa | 90708
Panola | 38591
Paris | 60225
Ranger | 19780
San Jacinto | 395703
South Plains | 151995
South Texas | 236466
Southwest Texas | 75189
Tarrant | 510550
Temple | 66039
Texarkana | 74867
Texas Southmost | 154789
Trinity Valley | 105136
Tyler | 187230
Vernon | 47784
Victoria | 78535
Weatherford | 61276
Western Texas | 26236
[NAME] | 97120
TSTC-Harlingen | 94256
TSTC-West Texas | 43568
TSTC-Marshall | 15547
TSTC-Waco | 121985
Lamar-IOT | 52039
[NAME] | 34115
[NAME] | 51810
Total for Instutions Reporting Expense
Spreadsheet: 104770d1302224896-question-about-linking-formulas-from-one-page-to-another-new-accts-payable-2011
Sheet: May

may expenses
total
advertising
date | po# | suppplier.description | amount
subtotal
x
educational
date | po# | suppplier.description | amount
subtotal
x
supplies. blanks
date | po# | suppplier.description | amount
subtotal
x
supplies. designs
date | po# | suppplier.description | amount
subtotal
s
supplies. notions
date | po# | suppplier.description | amount
subtotal
supplies. machinery
date | po# | suppplier.description | amount
subtotal
supplies. office
date | po# | suppplier.description | amount
subtotal
etsy maintenance
date | po# | suppplier.description | amount
subtotal
website maintenance
date | po# | suppplier.description | amount
subtotal
shipping
date | po# | suppplier.description | amount
subtotal
utilities
date | po# | suppplier.description | amount
subtotal
Spreadsheet: 695742d1600369064-query-attendance-roster-for-classes-attended-attendance-query-sample
Sheet: Sheet1

Training Date | Training Title | Name | Name | Name | Name | Name | Name
2020-01-01 00:00:00 | Timesheet | [NAME] | Billy | [NAME] | Bonita | [NAME] | Barb
2020-01-06 00:00:00 | Windows | Twila | Adam | [NAME] | [NAME]
2020-02-04 00:00:00 | Mechanics | Billy
2020-04-18 00:00:00 | Popcorn | [NAME] | Barb | Twila
2020-04-21 00:00:00 | Rock Climbing | [NAME] | [NAME] | Vern | [NAME] | [NAME] | [NAME]
2020-05-06 00:00:00 | Horticulture | [NAME] | Twila | [NAME] | [NAME] | Fred
2020-05-17 00:00:00 | Sky diving | [NAME] | [NAME] | Duke | [NAME] | [NAME] | Uri
2020-06-30 00:00:00 | Blueprints | [NAME] | Wilma | Bonita | [NAME]
2020-07-01 00:00:00 | [NAME] | [NAME] | [NAME] | [NAME] | Fred | [NAME] | [NAME]
Spreadsheet: 683564d1592830381-consolidating-sheets-text-not-consolidating-consolidation
Sheet: Consolidated

 |  | 0 |  | 0 | 0
 |  | 25 |  | 1 | 25
 |  | 35 |  | 5.87 | 205.45
 |  | 45 |  | 10.87 | 246.75
 |  | 20 |  | 25.54 | 510.8
 |  | 1221 |  | 13.36 | 14428.56
 |  | 30 |  | 3.3 | 99
 |  | 31 |  | 1.5 | 46.5
 |  | 32 |  | 2.5 | 80
 |  | 36 |  | 3 | 108
 |  | 90 |  | 6 | 540
 |  | 90 |  | 72 | 6480
 |  | 90 |  | 32 | 2880
 |  | 1176 |  | 34.11 | 26722.15
 |  | 210 |  | 12 | 2520
 |  | 1270 |  | 35.56 | 13622
 |  | 30 |  | 35 | 1050
 |  | 0 |  | 32 | 0
 |  | 10111 |  | 4.21 | 42567.31
 |  | 0 |  | 0 | 0
 |  | 12569 |  | 3.2 | 40220.8
 |  | 0 |  | 0 | 0
 |  |  |  |  | 0
 |  | 2503 |  | 9.8 | 24529.4
 |  | 98 |  | 9.8 | 960.4000000000001
 |  | 4 |  | 4.2 | 16.8
Spreadsheet: 30b067b0-c537-4557-a580-aaf53133b854
Sheet: Capital

CAPITAL PROJECT
Ordinance Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
Is this ordinance for the following: |  |  |  | X | Design Professional Services
 |  |  |  |  | New Construction
 |  |  |  |  | Replacement
 |  |  |  |  | Repair
Was this project programmed in the Five-Year Capital Improvement Plan? |  |  |  |  |  |  |  | No |  | X | Yes
 | If yes, please identify year in which this project was funded. |  |  |  |  |  |  | 2011
 | If no, please detail the reasons why this project was not included and need for present funding request.
Does this project leverage non-city funds for design/construction? |  |  |  |  |  |  | X | No |  |  | Yes
 | If yes, please identify source and amount.
 | Source of Funds:
 | Year Funded:
 | Amount of Non-City Funds:
 | If no, please identify source and amount of city funds.
 | Acct #:
 |  |  |  |  | AL-3010-808083-B-611040-89003370
 | Name of Fund: |  |  |  | Water & Sewer CD3
 | Year Funded: |  |  |  | 2011
 | Amount of City Funds: |  |  |  | 54190
If ordinance is for new construction or replacement of asset please provide the following information:
 | Total estimated costs (design through construction): |  |  |  | 1625000
 | Estimated lifespan of project in years |  |  |  | 75
 | Estimated annual operating and maintenance costs |  |  |  | None
 | (Please detail type of maintenance or operating costs needed, additional staffing, capital maintenance costs, utilities, etc.)
Are these O&M costs reflected in the current budget? |  |  |  |  |  |  | X | No |  |  | Yes
 | If yes, please please provide source of funds.
 | If no, please identify year in which additional operating and maintenance costs will be needed.
Reference Numbers: (Previously approved legislation):
Reviewed by:
 |  |  |  |  |  | OMB Approval Date
Spreadsheet: 763117d1641999026-consecutive-dates-to-from-and-to-sickness-report
Sheet: Sheet1

RAW DATA |  |  |  |  |  | Expected Data
Name | Shift | Date |  |  |  | Name | From | To
AAB | Sick | 09/12/2021 |  |  |  | AAB | 2021-12-09 00:00:00 | 2021-12-12 00:00:00
AAB | OffDay | 2021-12-10 00:00:00 |  |  |  | AAB | 2021-12-16 00:00:00 | 1900-01-17 00:00:00
AAB | OffDay | 2021-12-11 00:00:00 |  |  |  | AAB | 2021-12-20 00:00:00 | 2021-12-21 00:00:00
AAB | Sick | 2021-12-12 00:00:00 |  |  |  | AP | 2021-12-29 00:00:00 | 2021-12-29 00:00:00
AAB | Sick | 16/12/2021 |  |  |  | AP | 2021-12-15 00:00:00 | 2021-12-15 00:00:00
AAB | Sick | 17/12/2021 |  |  |  | AR | 2021-12-16 00:00:00 | 2021-12-18 00:00:00
AAB | WorkingDay | 18/12/2021 |  |  |  | AR | 2021-12-20 00:00:00 | 2021-12-21 00:00:00
AAB | WorkingDay | 19/12/2021 |  |  |  | AR | 2021-12-23 00:00:00 | 2021-12-23 00:00:00
AAB | Sick | 20/12/2021 |  |  |  | AR | 2021-12-25 00:00:00 | 2021-12-25 00:00:00
AAB | Sick | 21/12/2021 |  |  |  | AF | 2021-12-18 00:00:00 | 2021-12-19 00:00:00
AP | Sick | 29/12/2021 |  |  |  | AF | 2021-12-21 00:00:00 | 2021-12-24 00:00:00
AP | Sick | 15/12/2021 |  |  |  | AS | 2021-12-08 00:00:00 | 2021-12-11 00:00:00
AR | Sick | 16/12/2021 |  |  |  | AS | 2021-12-26 00:00:00 | 2021-12-26 00:00:00
AR | OffDay | 2021-12-17 00:00:00 |  |  |  | AS | 2021-12-28 00:00:00 | 2021-12-28 00:00:00
AR | Sick | 2021-12-18 00:00:00 |  |  |  | AS | 2021-12-12 00:00:00 | 2021-12-12 00:00:00
AR | Sick | 20/12/2021
AR | Sick | 21/12/2021
AR | Sick | 23/12/2021
AR | Sick | 25/12/2021
AF | Sick | 18/12/2021
AF | Sick | 19/12/2021
AF | WorkingDay | 20/12/2021
AF | Sick | 21/12/2021
AF | Sick | 22/12/2021
AF | Sick | 23/12/2021
AF | Sick | 24/12/2021
AS | Sick | 08/12/2021
AS | Sick | 09/12/2021
AS | OffDay | 2021-12-10 00:00:00
AS | Sick | 11/12/2021
AS | Sick | 26/12/2021
AS | Sick | 28/12/2021
AS | Sick | 12/12/2021
Spreadsheet: 696867d1601020109-fee-increase-by-a-certain-over-every-certain-years-fee-increase-by-a-certain-over-every-certain-years
Sheet: davsth

 | Fee increase by a certain % over every certain years
 | Year | 1 |  |  |  |  |  |  |  |  |  |  |  | Checksum
 | Assessment fee | 100
 | Increase every ? years
 | Increase %
 | Require a formula in cell D5 that I can drag across to cell N5 all the way, to show increase in assessment fee every 3 years by 5%
 | Also require a formula in cell O5 to check that the cell N5 is computed correctly
Spreadsheet: 107036d1304191668-spellnumber-formula-example-sheet
Sheet: Summary

EMERGENCY LODGING CENTER PROJECT, SHUMAISI
EXTERNAL WORKS - ROAD PROJECTS
Storm Drainage System
Summary of Pipe Installation
Date : 31/03/2011
S. No. | Item No. | RCC Pipe Dia | Unit | Unit Price |  | Previous            Qty | Previous   Amount |  | This-Qty | This-Amount |  | To Date-Qty | To Date-Amount
1 |  | RCC Dia 2000 | LM |  |  |  |  |  | 0 | 0 |  | 0 | 0
2 |  | RCC Dia 1800 | LM |  |  |  |  |  | 0 | 0 |  | 0 | 0
3 |  | RCC Dia 1600 | LM |  |  |  |  |  | 0 | 0 |  | 0 | 0
3 |  | RCC Dia 1400 | LM |  |  |  |  |  | 0 | 0 |  | 0 | 0
4 |  | RCC Dia 1000 | LM | 1770 |  |  |  |  | 1512.5 | 2677125 |  | 1512.5 | 2677125
5 |  | RCC Dia 900 | LM | 1465 |  |  |  |  | 400 | 586000 |  | 400 | 586000
6 |  | RCC Dia 800 | LM | 1103 |  |  |  |  | 615 | 678345 |  | 615 | 678345
7 |  | RCC Dia 700 | LM | 961 |  |  |  |  | 613 | 589093 |  | 613 | 589093
8 |  | RCC Dia 600 | LM | 852 |  |  |  |  | 705 | 600660 |  | 705 | 600660
9 |  | RCC Dia 500 | LM | 689 |  |  |  |  | 688.95 | 474686.55 |  | 688.95 | 474686.55
10 |  | RCC Dia 400 | LM | 579 |  |  |  |  | 412.5 | 238837.5 |  | 412.5 | 238837.5
11 |  | RCC Dia 300 | LM |  |  |  |  |  | 0 | 0 |  |  | 0
 |  |  |  |  |  |  |  |  | Grand Total | 5844747.05
Amount in Words : |  |  |  |  |  | Five Million Eight Hundred Forty Four Thousand Seven Hundred Forty Seven SaudiRiyal and Five Halalas
Spreadsheet: 70441d1271184590-compressing-data-into-one-row-forum-questions-1
Sheet: Sheet1

Client | 2001 | 2002 | 2003 | 2004 | 2005
[NAME] | x
[NAME] |  | x
[NAME] |  |  |  | x
[NAME] | x
[NAME] |  | x
[NAME] |  |  | x
[NAME] |  |  |  | x
fred doe |  |  |  |  | x
Client | 2001 | 2002 | 2003 | 2004 | 2005
[NAME] | x | x |  | x
[NAME] | x | x | x | x | x
Client
[NAME] | x | x |  | x
[NAME] | x | x | x | x
fred doe |  |  |  |  | x
Spreadsheet: 784439d1655735427-formula-for-2nd-half-points-scored-footy-scores-aligw
Sheet: Sheet2

Name | [NAME] | How Many games a second half point scored by either home or away
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Bethany
[NAME]
[NAME]
Nicki
Spreadsheet: 881673d1729793397-conditional-formatting-with-different-date-help-cond-frmt-etaf
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | AND( $J5<>"", $j5<TODAY()-30)
 |  |  |  |  |  |  |  |  | 2024-09-01 00:00:00
 |  |  |  |  |  |  |  |  | 2024-09-01 00:00:00
Spreadsheet: 0e5a94e5-8fd5-4c3c-ba33-2a4de1a07ac6
Sheet: Sheet1

State of New Hampshire - Primary Election | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
State Representatives - CHESHIRE County - Democratic
District No. 1 (4) | Berch, d | Butynski, d | Sad, d | Weber, d | Smith, r | Aldrich, r | [NAME], r | Moore, Jr., r | [NAME]
Chesterfield | 210 | 224 | 213 | 216 |  |  |  |  | 2
Hinsdale | 127 | 163 | 116 | 127
Walpole | 232 | 233 | 337 | 318 |  | 1 |  | 2 | 2
Westmoreland | 164 | 146 | 151 | 153 |  |  | 1 | 6
TOTALS | 733 | 766 | 817 | 814 |  | 1 | 1 | 8 | 4
District No. 2 (1) | Mann, d | Cartwright, r | [NAME]
Alstead | 178
Marlow | 59
[NAME] | 70
TOTALS | 307
District No. 3 (1) | Eaton, d | Ward, r | [NAME]
Gilsum | 41 |  | 1
[NAME] | 95
Stoddard | 96
[NAME] | 57
TOTALS | 289 |  | 1
District No. 4 (1) | [NAME], d | [NAME]
[NAME] | 148 | 1
District No. 5 (1) | Phillips, d | Chaffee, r | [NAME]
[NAME] | 358 |  | 1
District No. 6 (1) | Robertson, d | Carlsen, r | [NAME]
[NAME] 3* | 319 |  | 1
District No. 7 (1) | [NAME], d | [NAME]
[NAME] | 343 | 2
District No. 8 (1) | Chase, d | [NAME], r | [NAME]
[NAME] | 408
District No. 9 (2) | Ley, d | Ames, d | Moore, r | [NAME]
Dublin | 145 | 181
Harrisville | 158 | 164
[NAME] | 263 | 315
Roxbury | 16 | 25
TOTALS | 582 | 685
District No. 10 (1) | [NAME], d | Hopkins, r | [NAME], r | Walsh, r | [NAME]
Marlborough | 224 | 1
Troy | 95 |  | 2 | 1
TOTALS | 319 | 1 | 2 | 1
District No. 11 (2) | Jackman, r | Dwinell, r | Emerson, r | [NAME], r | [NAME]
[NAME] | 2 | 18 | 15 | 6 | 9
Rindge | 12 | 3 | 14 | 8 | 17
TOTALS | 14 | 21 | 29 | 14 | 26
District No. 12 (2) | Faulkner, d | [NAME], r | Lerandeau, d | [NAME]
Richmond | 63 | 1 | 72 | 2
Swanzey | 260 |  | 320
TOTALS | 323 | 1 | 392 | 2
District No. 13 (1) | Parkhurst, d | [NAME]
Winchester | 210 | 3
District No. 14 (1) FL | Young, d | [NAME], r | McKenzie, r | Sterling, Jr., r | [NAME]
Dublin | 165
[NAME] | 150 |  |  |  | 2
Harrisville | 190
[NAME] | 333 | 2 |  | 1
Rindge | 184
Roxbury | 27
TOTALS | 1049 | 2 |  | 1 | 2
District No. 15 (1) FL | Tatro, d | [NAME], r |  | [NAME]
Marlborough | 191 | 1 |  | 1
Richmond | 91 | 1 |  | 2
Swanzey | 370
Troy | 93 | 2
Winchester | 193
TOTALS | 938 | 4 |  | 3
District No. 16 (2) FL | Burridge, d | Weed, d |  | [NAME]
[NAME] | 79 | 140 |  | 2
[NAME] | 196 | 353 |  | 6
[NAME] 3 | 175 | 295 |  | 4
[NAME] | 189 | 349 |  | 4
[NAME] | 241 | 389
TOTALS | 880 | 1526 |  | 16
*correction received from city clerk 9/24/12
Spreadsheet: 107756d1304916358-string-a-set-of-formulas-to-merge-scenarios-query
Sheet: Sheet1

Client | ID No | Client No | Expected Outcome
Client 1 | AAB517731 | AAA311406 | AAA517731
Client 2 | AAB407918 | AAA295588 | AAA407918
Client 3 | AAA000050 | AAA000030 | AAA000030
Client 4 | [NAME] | AAA000014 | AAA000014
Spreadsheet: 538424d1505599932-multi-page-order-sheet-with-summary-page-lbm-order-sheet-sample
Sheet: Shims and stakes

Item # | [NAME] | Description
0175-0001 |  | SHIMS CEDAR [NAME]) BUNDLE
0175-0003 |  | SHIMS HORSESHOE;1/16"x 2" BLUE 100pk #16
0175-0004 |  | SHIMS CEDAR 8" x 1-1/2";
0175-0006 |  | SHIMS PLASTIC SNAP-OFF;14pak
0175-0007 |  | SHIMS CEDAR 12" MINI;42pk
0175-0008 |  | SHIMS CEDAR MINI PACK;NELSON PRO-LINE
0175-0009 |  | SHIMS SHIMCO HARDWOOD;4" 14pk GS-1040-04
0175-0010 |  | SHIMS SHIMCO HARDWOOD;6" 12pk YS-1540-06
0176-0002 |  | PICKETS 1X4X48" CLEAR;POINTED
0176-0004 |  | STAKES 1 X 2 X 18" 25PC;CENTRE POINT
0176-0005 |  | STAKES 1 X 2 X 24" 25PC;CENTRE POINT
0176-0006 |  | STAKES 1 X 2 X 48" 25PC;CENTRE POINT
0176-0007 |  | STAKES 2 X 2 X 18" 12PC;CENTER POINT
0176-0008 |  | STAKES 2 X 2 X 24" 12PC;CENTRE POINT
0176-0013 |  | STAKES 2 X 2 X 48" 12PC;CENTRE POINT
Spreadsheet: 218572d1362501033-conditional-formatting-tasks
Sheet: Sheet1

 | Needed by | Completed date
TASK 1
TASK 2a
TASK 2b
TASK 3a
TASK 3b
TASK 4a
TASK 4b
TASK 4c
 |  |  |  |  |  |  |  |  | All tasks complete date | 2013-07-15 00:00:00
Spreadsheet: 110090d1306865654-a-formula-in-this-worksheet-contains-one-or-more-invalid-how-to-fix-getting_error_in_excel
Sheet: Summary_Indexing

Month | # | Target | TAT%
2010-04-01 00:00:00 | 29897 | 0.95 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] from scratch(2) file which works
2010-05-01 00:00:00 | 35192 | 0.95 | 0.9721546961325966 |  |  |  |  |  |  |  |  |  |  |  | chrtindex |  | INDEX(Summary_Indexing!$A:$A, MATCH(9E+307, Summary_Indexing!$A:$A)):INDEX(Summary_Indexing!$E:$E, MATCH(9E+307, [NAME])
2010-06-01 00:00:00 | 35365 | 0.95 | 0.98
2010-07-01 00:00:00 | 28803 | 0.95 | 0.98 |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | INDEX(Summary_Indexing!chrtindex,0,2)
2010-08-01 00:00:00 | 28013 | 0.95 | 0.98
2010-09-01 00:00:00 | 27343 | 0.95 | 0.97 |  |  |  |  |  |  |  |  |  |  |  | tblindex3 |  | INDEX(Summary_Indexing!chrtindex, 0, 3)
2010-10-01 00:00:00 | 30088 | 0.95 | 0.97
2010-11-01 00:00:00 | 28295 | 0.95 | 0.97 |  |  |  |  |  |  |  |  |  |  |  | tblindex4 |  | INDEX(Summary_Indexing!chrtindex,0,4)
2010-12-01 00:00:00 | 32194 | 0.95 | 0.95
2011-01-01 00:00:00 | 31690 | 0.95 | 0.98 |  |  |  |  |  |  |  |  |  |  |  | tblindexMonth |  | INDEX(Summary_Indexing!chrtindex,0,1)
2011-02-01 00:00:00 | 28039 | 0.95 | 0.98
2011-03-01 00:00:00 | 33277 | 0.95 | 0.92
2011-04-01 00:00:00 | 31114 | 0.95 | 0.9788198238734974
2011-04-01 00:00:00 | 30455 | 0.95 | 0.9788198238734974
2011-05-01 00:00:00 | 15 | 0.15 | 0.84
 |  |  |  |  |  | SERIES(Summary_Indexing!$B$1,Summary_Indexing!tblindexMonth,Summary_Indexing!tblindex2,1)
 |  |  |  |  |  | when I try to paste the above into series 1 I get an error and it wont let me do it.
Spreadsheet: b6d44279-e49d-4cfe-a45c-543f2aeda255
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
AMKPK | Test | AMKPK | Amikacin, [NAME], Serum | Amikacin, Peak, S | Enzyme-Multiplied Immunoassay Technique (EMIT) | Plain, Red-Top Tube: Red OR |  |  | 1 | mL | Collection Container/Tube: Red top Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions: Spin down within 2 hours of draw. | 0.25 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm Reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Serum gel tube | Therapeutic concentration: 20.0-35.0 mcg/mL | Monday through Sunday; Varies | Same day/1 day | 2 days | 1 | 80150 |  |  |  |  | Rochester
AMKPK | [NAME] | SRED | Serum Red |  |  |  | Frozen | 14 days
AMKPK | Result | 6773 | Amikacin, Peak, S | Amikacin, Peak, S | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 3319-1 | Amikacin^peak:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 809299d1671013690-calculation-of-a-cumulative-penalty-with-2-different-penalty-rates-penalty-calculations-logic
Sheet: Sheet2

Month | Principal Due | Amount Paid | [NAME] | Months late as at (st july 2023) | Penalty | 0.2 | 0.1 | Months late | Cumulative % | Penalty due |  |  | From date | Percentage
2022-05-01 00:00:00 | 100 |  |  |  |  | 140%(7 months late) | 70%(7months late) | 14 | 2.1 |  |  |  | >1/01/2023 | 0.1
2022-06-01 00:00:00 | 100 |  |  |  |  | 120%(6 month late) | 70%(7months late) | 13 | 1.9 |  |  |  | <31/12/2022 | 0.2
2022-07-01 00:00:00 | 100 |  |  |  |  | 100%(5 months late) | 70%(7months late) | 12 | 1.7
2022-08-01 00:00:00 | 100 |  |  |  |  | 80%(4 months late) | 70%(7months late) | 11 | 1.5
2022-09-01 00:00:00 | 100 |  |  |  |  | 60%(3 months late) | 70%(7months late) | 10 | 1.3
2022-10-01 00:00:00 | 100 |  |  |  |  | 40%(2 months late) | 70%(7months late) | 9 | 1.1
2022-11-01 00:00:00 | 100 |  |  |  |  | 20%(1 months late) | 70%(7months late) | 8 | 0.9
2022-12-01 00:00:00 | 100 |  |  |  |  | 0%(0 months late) | 70%(7months late) | 7 | 0.7
2023-01-01 00:00:00 | 100 |  |  |  |  |  | 60%(6months late) | 6 | 0.6
2023-02-01 00:00:00 | 100 |  |  |  |  |  | 50%(5months late) | 5 | 0.5
2023-03-01 00:00:00 | 100 |  |  |  |  |  | 40%(4months late) | 4 | 0.4
2023-04-01 00:00:00 | 100 |  |  |  |  |  | 30%(3months late) | 3 | 0.3
2023-05-01 00:00:00 | 100 |  |  |  |  |  | 20%(2months late) | 2 | 0.2
2023-06-01 00:00:00 | 100 |  |  | 1 |  |  | 10%(1months late) | 1 | 0.1
2023-07-01 00:00:00 | 100
Spreadsheet: 762864d1641879126-copy-1-column-to-another-based-on-text-in-a-different-cell-2022-pre-call-planning-calender-eba-3
Sheet: Sheet1

Week #1 |  |  |  | January |  |  |  |  |  |  |  |  |  |  |  |  | 2022 |  |  |  | Pre Call Plan
 | 2022-01-03 00:00:00
Sgmnt | Monday | Type | Time | Sgmnt | Tuesday | Type | Time | Sgmnt | Wednesday | Type | Time | Sgmnt | Thursday | Type | Time | Sgmnt | Friday | Type | Time |  | Time | Type | Sgmnt | Meeting | Comments
1 | Village at Cook Springs | FU | 10:30:00 | 1 | [NAME] | CI | 10:15:00 |  | Fast Start Meeting | Trng | 12:00:00 |  | Fast Start Meeting | Trng | 08:00:00 | non | [NAME] | Call | 08:00:00 |  |  |  |  |  | Follow up on Previous Identified Residents
1 | Meadowview | FU | 11:00:00 | non | [NAME] | Call |  |  |  |  |  |  |  |  |  | 4 | [NAME] | Call | 11:30:00
 | Pre-Call |  |  | yes | Pre-Call |  |  |  | Pre-Call |  |  |  | Pre-Call |  |  |  | Pre-Call
Week #2 |  |  |  | January |  |  |  |  |  |  |  |  |  |  |  |  | 2022 |  |  |  | Pre Call Plan
Sgmnt | Monday | Type | Time | Sgmnt | Tuesday | Type | Time | Sgmnt | Wednesday | Type | Time | Sgmnt | Thursday | Type | Time | Sgmnt | Friday | Type | Time |  | Time | Type | Sgmnt | Meeting | Comments
2 | Park Manor | IV | 08:45:00
Yes | Pre-Call |  |  |  | Pre-Call |  |  |  | Pre-Call |  |  |  | Pre-Call |  |  |  | Pre-Call
Week #3 |  |  |  | January |  |  |  |  |  |  |  |  |  |  |  |  | 2022 |  |  |  | Pre Call Plan
Sgmnt | Monday | Type | Time | Sgmnt | Tuesday | Type | Time | Sgmnt | Wednesday | Type | Time | Sgmnt | Thursday | Type | Time | Sgmnt | Friday | Type | Time |  | Time | Type | Sgmnt | Meeting | Comments
Yes | Pre-Call |  |  |  | Pre-Call |  |  |  | Pre-Call |  |  |  | Pre-Call |  |  |  | Pre-Call
Week #4 |  |  |  | January |  |  |  |  |  |  |  |  |  |  |  |  | 2022 |  |  |  | Pre Call Plan
Sgmnt | Monday | Type | Time | Sgmnt | Tuesday | Type | Time | Sgmnt | Wednesday | Type | Time | Sgmnt | Thursday | Type | Time | Sgmnt | Friday | Type | Time |  | Time | Type | Sgmnt | Meeting | Comments
Yes | Pre-Call |  |  |  | Pre-Call |  |  |  | Pre-Call |  |  |  | Pre-Call |  |  |  | Pre-Call