tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 44739d1243507391-too-many-arguments-error-help-need-to-clean-up-formula-calendartest
Sheet: Enquiry Sheet

Enquiry Date | Status | Name | First Name | Surname | [NAME] | Home/Work Phone | phone | Adults | Children | Breakfast | [NAME] | Departure | Nights | Estimated Cost | Discount % | Surcharge/Discount $ | Total Price | [NAME] Type
2009-05-28 20:41:40 |  | [NAME] | [NAME] | Bingemann | [NAME] | 5456788 | sdasdsa | 2 | 0 | No | 2009-08-11 00:00:00 | 2009-08-14 00:00:00 | 3 | 540 |  |  | 540 | Reminder |  | Send to Library | Delete
- |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | Reminder
- |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | Quote
- |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | Quote
- |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | Reminder
- |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
- |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
- |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
- |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
- |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
- |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
- |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
- |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
- |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
- |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
- |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
- |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
- |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
- |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
- |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
- |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
- |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
- |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | booked | Quote
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Awaiting Reply | Reminder
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Awaiting confirmation | Unavailable
Spreadsheet: 2cf43e12-2539-4fbb-bea6-52c357472f16
Sheet: Sheet1

Table 2--Soybean meal:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | Supply |  |  |  |  | Disappearance
Year beginning | Beginning |  |  |  |  |  |  |  | Ending
October 1 | stocks | Production | Imports | Total |  | Domestic | Exports | Total | stocks
 | 1,000 short tons
2011/12 | 350 | 41025 | 215.916 | 41590.916 |  | 31550.062 | 9740.854 | 41290.916 | 300
2012/131 | 300 | 38950 | 350 | 39600 |  | 29400 | 9900 | 39300 | 300
2013/142 | 300 | 40235 | 165 | 40700 |  | 30200 | 10200 | 40400 | 300
1 Estimated.  2 Forecast.
Source: USDA, World Agricultural Outlook Board, World Agricultural Supply and Demand Estimates.
Last update: | 2013-05-14 11:04:41.780000
Spreadsheet: jim_schwieger__14332__HPL Transition Contact List
Sheet: Sheet1

HPL TRANSITION TEAM CONTACT LIST
NAME | DEPARTMENT | NUMBER | CELL/PAGER | [NAME]
BAUMBACH, [NAME] | ENERGY OPS | 3.5384 | (713)707-6510 | EB3250
BRABAND, SANDI | [NAME] | 3.5465 | ([PHONE] | EB3856
BRASHER, BARNEY | FIELD OPERATIONS | 3.6828 | [PHONE] | EB3960
BRAZAITIS, GREG | HPL MARKETING | 3.1923 |  | EB3527B
CARRIERE, MOLLY | ENGINEERING | 3.3154 | [PHONE] | EB3513
COCAVESSIS, NICK | ENGINEERING | 5.8273 | (713)515-7347 | EB3504
COFFEY, JIM | ENA BAR | 3.5346 | (713)825-7240 | EB2438
DALLMAN, LARRY | CORP ACCOUNTS PAYABLE | 3.7222 | N/A | JF6 0568
DENETSOSIE, TROY | ENA UPSTREAM CTG | 3.5966 |  | EB3562
DUTT, RANABIR | GLOBAL FINANCE | 3.5274 | (713)417-6200 | EB2881
GOTTLOB, ED | HPL TRANSPORT | 3.6035 | (713)417-5056 | EB3212B
GRAVES, MELISSA | GAS ASSETS | 3.9173 | [PHONE] | EB3523C
GRAY, BARBARA | [NAME] | 3.6832 | (713)859-8020 | EB3873
HALL, BOB | ENERGY OPS | 3.6956 | [PHONE] | EB3260
[NAME], RHETT | TAX | 3.4718 |  | EB1716
KAASE, [NAME] | HPL ASSET MGMT | 3.6806 | (281)744-3953 | EB3520A
KEOHLER, ANNE | [NAME] | 3.3448 | (281)782-3840 | EB3839
KOKAS, KATHY |  | 5.615 |  | 2AC1256
[NAME], [NAME] | CORP RISK MGMT(INSURANCE) | 3.6847 | N/A | EB2150
MARTIN, TOM | HPL TRADING | 3.3079 | (713)417-7994 | EB3211C
MAYES, FRAN | ENA HUMAN RESOURCES | 3.7211 | [PHONE] | EB2997A
MCKAY, JIM | GAS CONTROL | 3.6448 | (713)202-7839 | EB3211A
NEAL, KATHY | ENA HUMAN RESOURCES | 5.7803 | (713)819-6766 | EB2998A
ORSAK, SUSIE | ENA BAR | 3.1797 |  | EB3507F
POND, JIM | BAR TRADE ACCTS | 5.8378 | (713)508-1947 | EB2473
PRIBBLE, DAN | VP OPS | 5.7162 | [PHONE] | EB3963
REDMOND, [NAME] | HPL EXECUTIVE | 3.1839 | (713)705-4591 | EB3566
SCHIELD, ELAINE | CORP ACCOUNTING | 3.5476 |  | EB1974
SCHNEIDER, STEVE | HPL EXECUTIVE | 3.6718 | [PHONE] | EB3530
SCHWIEGER, JIM | HPL STORAGE | 3.7705 | (713)553-8169 | EB3211B
SHAHI, PUSHKAR | CURRENCY TRADING | 3.9199 | (713)854-4342 | EB3075D
SHELTON, TOM | HPL REGULATORY | 3.6417 | (713)504-9992 | EB3522B
SONNEBORN, CHRIS | ENGINEERING | 3.653 |  | EB3514B
STOWERS, KATIE |  | 3.3339 |  | EB2870
TERRY, ED | ENA | 3.7452 | [PHONE] | EB3296B
WADE, PATRICK | ENRON CORP | 3.6396 | N/A | EB3627
WEISSMAN, GEORGE | PRODUCER SERVICES | 3.6992 | (713)990-5064 | EB3537B
WHITING, GREG | CORP ACCOUNTING | 3.5399 | (713)545-7504 | EB2488
WYNNE, RITA | GAS ASSETS VOLUME MGMT | 3.7694 | (713)762-6855 | EB3704
YANOWSKI, TOMMY | INFORMATION TECHNOLOGY | 3.6858 | (713)539-7094 | EB1829
[NAME], JILL | PRODUCER SERVICES | 3.1791 | (713)628-0543 | EB3537
Spreadsheet: 849052d1699615614-need-help-with-attendance-formula-in-an-excel-template-employee-attendance-record1
Sheet: Employee Leave Tracker

 | Employee leave tracker
 | Employee name | Start date | End date | Type of leave | Days
 | MOHAMMAD FIROZ |  |  | Sick leave
 | MD KHUSHAL |  |  | Other
 | [NAME] |  |  | Other
 | SALIH |  |  | Bereavement
 | HARISHALI |  |  | Sick leave
 | BIBEK PUDASAINI |  |  | Vacation
 | MANPREET |  |  | Sick leave
 | GANESH |  |  | Other
 | [NAME] |  |  | Other
 | CHRISTY |  |  | Sick leave
 | AJAY KUMAR |  |  | Sick leave
 | MUHAMMED SHAFI |  |  | Bereavement
 | NASSIMUDEEN |  |  | Bereavement
 | AKBARSHA |  |  | Vacation
 | AMIR CHAND |  |  | Bereavement
 | MAHADEV PARIYAR |  |  | Other
 | SATINDERPAL SINGH |  |  | Vacation
 | MAN BAHADUR THAPA |  |  | Bereavement
 | GOURAKHA BAHADUR RAI |  |  | Vacation
 | BHUWAN SINGH RAI |  |  | Bereavement
 | ROSHAN RAI |  |  | Sick leave
 | PURNA DANGI |  |  | Vacation
 | SAILALO |  |  | Vacation
 | DILIP BAHADUR
 | YASIR
 | M.USMAN
 | RAMESH JOGI
 | ARJUN NEPALI
 | PARVAIS
 | ATIF NAWAZ
 | RAHUL P
 | HARIS FAJRI
 | VISHNU CHANDRAN
 | DHIQUIR
 | NIYAS
 | RAM GURUNG
 | IMRAN [NAME]
 | MOHAMAD SALMAN
 | AMAL
 | FAROOQ
 | RAHUL C.M
 | YASWANTH
 | NISHAD
 | ABDUL NABI
 | YADAV GAJWREL
 | HARI NARAYAN
 | THOUFEEQ
 | N.SELVAM
 | N.AYYAPPAN
 | SAIDUL HAQUE
 | C.SENTHIL
 | JIWAN BHAIYA
 | BISHOK
 | ABINASH
 | [NAME]
 | VINOD KUMAR
Spreadsheet: 806338d1669239716-counting-occurrences-after-gathering-unique-values-book1
Sheet: Sheet1

Person | Date | Account Number | Amount
[NAME] | 2022-01-01 00:00:00 | 111 | 600
[NAME] | 2022-01-01 00:00:00 | 111 | 255
[NAME] | 2022-01-01 00:00:00 | 111 | 150
[NAME] | 2022-01-02 00:00:00 | 222 | 900
[NAME] | 2022-01-02 00:00:00 | 222 | 580
[NAME] | 2022-01-02 00:00:00 | 222 | 170
[NAME] | 2022-01-03 00:00:00 | 333 | 875
[NAME] | 2022-01-03 00:00:00 | 333 | 335
[NAME] | 2022-01-03 00:00:00 | 333 | 690
[NAME] | 2022-01-03 00:00:00 | 333 | 400
Spreadsheet: 849977d1700352324-index-function-doesnt-work-in-a-copy-template-2_11_2022_b
Sheet: Calendar Month Format

 | October
 | Sun | Mon | Tue | Wed | Thu | Fri | Sat
 |  |  |  |  |  |  | 2022-10-01 00:00:00
D
D2
S
N
N2
 | 2022-10-02 00:00:00 | 2022-10-03 00:00:00 | 2022-10-04 00:00:00 | 2022-10-05 00:00:00 | 2022-10-06 00:00:00 | 2022-10-07 00:00:00 | 2022-10-08 00:00:00
D
D2
S
N
N2
 | 2022-10-09 00:00:00 | 2022-10-10 00:00:00 | 2022-10-11 00:00:00 | 2022-10-12 00:00:00 | 2022-10-13 00:00:00 | 2022-10-14 00:00:00 | 2022-10-15 00:00:00
D
D2
S
N
N2
 | 2022-10-16 00:00:00 | 2022-10-17 00:00:00 | 2022-10-18 00:00:00 | 2022-10-19 00:00:00 | 2022-10-20 00:00:00 | 2022-10-21 00:00:00 | 2022-10-22 00:00:00
D
D2
S
N
N2
 | 2022-10-23 00:00:00 | 2022-10-24 00:00:00 | 2022-10-25 00:00:00 | 2022-10-26 00:00:00 | 2022-10-27 00:00:00 | 2022-10-28 00:00:00 | 2022-10-29 00:00:00
D
D2
S
N
N2
 | 2022-10-30 00:00:00 | 2022-10-31 00:00:00
D
D2
S
N
N2
Spreadsheet: 874194d1720758478-find-match-and-return-column-header-sick-stigma-book1-340-aligw
Sheet: Sheet1

[NAME] |  |  |  | Team 1 | Team 2 | Team 3 |  | Team 1 | London | [NAME] | Scott | Doug | [NAME] |  | Team 1 | Team 2 | Team 3
 |  | Paris |  | [NAME] | [NAME] | [NAME] |  | Team 2 | New York | [NAME] | [NAME] | [NAME] | [NAME] |  | London | New York | Paris
 |  | Paris |  | Scott | [NAME] | [NAME] |  | Team 3 | Paris | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME] | [NAME] | [NAME]
 |  |  |  | Doug | [NAME] | [NAME] |  |  |  |  |  |  |  |  | Scott | [NAME] | [NAME]
 |  |  |  | [NAME] | [NAME] | [NAME] |  |  |  |  |  |  |  |  | Doug | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME]
Spreadsheet: jason_wolfe__13342__Gas_Settlements_Metrics
Sheet: Metrics Form

User Name:
Date:
UNIFY Sybase Metrics (Gas Settlements)
 |  |  |  |  |  | Sybase |  | User Test 1 |  | Variance (Sybase - User Test 1)
Area / Process | Entity | Pipeline | Time | Window(s) Involved | Filter Criteria Used | Time to Retrieve Filter | Time to Run Process / Report | Time to Retrieve Filter | Time to Run Process / Report | Time to Retrieve Filter | Time to Run Process / Report | Concurrent Processes Running | Comments
Settlements
Draft / Approval / Final - Sales | ENA
Notification Process (Manual) - Create | ENA
Notification Process (Manual) - Draft | ENA
Notification Process (Manual) - Close | ENA
Statement Group Assignment - Create | ENA
Statement Group Assignment - Attach | ENA
List [NAME] | ENA
List Screens - Supply | ENA
Reconciliation Reports | ENA | ALL
Accounting transactions by G/L Month | ENA | ALL
Suspend Line Item Detail | ENA
SAP Upload | ENA | Accrual Upload
Pre-UNIFY PMAs - Enter | ENA
Pre-UNIFY PMAs - Draft | ENA
Run Accruals | ENA | ALL
Spreadsheet: 691546d1597755132-linear-extrapolation-linear-extrapolation-example
Sheet: Sheet3

Example 1
 |  |  |  |  |  |  | [NAME]
Angle | 14.48 |  |  |  |  |  |  | Length/Height
Range | 0.35 |  |  |  |  |  | Opening angle | <0.5 | 0.5-1 | 1-<2 | >=2
Result |  |  |  |  |  |  | 10 | 0.34 | 0.24 | 0.17 | 0.1
 |  |  |  |  |  |  | 20 | 0.52 | 0.39 | 0.3 | 0.23
 |  |  |  |  |  |  | 30 | 0.6 | 0.5 | 0.43 | 0.36
Manual Cal Result |  | Cv different between fixed angles |  |  |  |  | 45 | 0.65 | 0.58 | 0.54 | 0.5
 |  | difference in degrees between fixed values |  |  |  |  | 60 | 0.67 | 0.63 | 0.6 | 0.58
 |  | Chosen Angle above nearest fixed value |  |  |  |  | 90 | 0.68 | 0.65 | 0.65 | 0.64
 |  | Cv value for 10 degree
 |  | Cv value for 1 degree
 |  | angle to increase by additional
 |  | new result
Example 2
 |  |  |  |  |  |  | [NAME]
Angle | 23.38 |  |  |  |  |  |  | Length/Height
Range | 1.5 |  |  |  |  |  | Opening angle | <0.5 | 0.5-1 | 1-<2 | >=2
Result |  |  |  |  |  |  | 10 | 0.34 | 0.24 | 0.17 | 0.1
 |  |  |  |  |  |  | 20 | 0.52 | 0.39 | 0.3 | 0.23
 |  |  |  |  |  |  | 30 | 0.6 | 0.5 | 0.43 | 0.36
Manual Cal Result |  | Cv different between fixed angles |  |  |  |  | 45 | 0.65 | 0.58 | 0.54 | 0.5
 |  | difference in degrees between 10 and 20 |  |  |  |  | 60 | 0.67 | 0.63 | 0.6 | 0.58
 |  | Chosen Angle above nearest fixed value |  |  |  |  | 90 | 0.68 | 0.65 | 0.65 | 0.64
 |  | Cv value for 10 degree
 |  | Cv value for 1 degree
 |  | angle to increase by additional
 |  | new result
Spreadsheet: 109139d1306071230-counting-of-specific-range-of-blank-cells-counting-blank-cells_abousetta_v2
Sheet: Sheet1

Numbers only |  |  |  |  |  | Total |  | Numbers or Text |  |  |  |  |  | Total
1 |  | 1 |  |  |  |  | abousetta | One |  | 1
 | 1 |  | 1 |  |  |  | abousetta |  | One |  | 1
1 |  |  |  |  | 1 |  | abousetta | One |  |  |  |  | 1
 |  |  |  |  |  |  | abousetta
1 |  | 1 |  |  |  |  | abousetta | One |  | 1
 | 1 |  | 1 |  |  |  | abousetta |  | One |  | 1
1 |  |  |  |  | 1 |  | abousetta | One |  |  |  |  | 1
 |  |  |  |  |  |  | abousetta
1 |  | 1 |  |  |  |  | marcol | One |  | 1
 | 1 |  | 1 |  |  |  | marcol |  | One |  | 1
1 |  |  |  |  | 1 |  | marcol | One |  |  |  |  | 1
 |  |  |  |  |  |  | marcol
Spreadsheet: d9dae836-451a-4a78-959d-4f5717a80ccd
Sheet: Table 1.8

Monthly Statistical Bulletin
1.8 Jobseekers receiving allowances
Month | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013–14
Newstart Allowance and Youth Allowance (other) recipients (a) – '000
July | 427.537 | 338.799 | 314.636 | 339.267 | 411.513
August | 399.572 | 319.562 | 303.978 | 330.774 | 393.998
September | 387.861 | 310.168 | 299.463 | 330.406 | 384.521
October | 375.957 | 302.88 | 297.779 | 332.902 | 383.962
November | 366.179 | 297.995 | 296.112 | 335.427 | 385.236
December | 377.862 | 318.512 | 317.239 | 349.782 | 406.703
January | 389.037 | 336.31 | 335.704 | 404.566 | 428.16
February | 380.181 | 340.795 | 339.475 | 405.688
March | 364.938 | 324.928 | 332.933 | 385.105
April | 354.598 | 319.681 | 332.39 | 394.889
May | 346.173 | 317.719 | 330.686 | 400.5
June | 340.825 | 315.567 | 332.022 | 406.759
Annual average | 375.8933333333333 | 320.243 | 319.3680833333333 | 368.0054166666667
Annual change – per cent
July | 45.47963291264151 | -20.75563050683333 | -7.131957296213966 | .. | 21.29473246734872
August | 38.74461354695113 | -20.02392560039242 | -4.876674948836221 | .. | 19.11395696155078
September | 36.66509281053122 | -20.03114517829841 | -3.451355394495881 | .. | 16.37833453387651
October | 32.08992980163163 | -19.43759525690438 | -1.684165346011621 | .. | 15.33784717424347
November | 27.07577093122521 | -18.6204014976282 | -0.6318897968086651 | .. | 14.84943072561242
December | 19.05139983742604 | -15.70679242686484 | -0.3996709700105567 | .. | 16.27327878507184
January | 10.76764070280935 | -13.55320959188971 | -0.1801908953049254 | .. | 5.831928535764265
February | 3.33111367805938 | -10.3598023046917 | -0.3873296263149381 | ..
March | -1.430712925574304 | -10.96350612980835 | 2.463622710261964 | ..
April | -6.473563994492824 | -9.846925250565437 | 3.975525602084579 | ..
May | -11.60193765688561 | -8.219589627151743 | 4.081279369505753 | ..
June | -15.95110330745632 | -7.410841340864074 | 5.214423561399 | ..
Annual average | 12.16550300063209 | -14.80482051645856 | -0.2732039940503461 | 15.22924045060859
(a) Includes jobseekers receiving Youth Allowance (other).
Source: Department of Social Services, Labour market and related payments: |  |  |  |  |  |  |  | Update
a monthly profile | http://www.deewr.gov.au/Employment/LMI/Pages/LMRP.aspx | http://www.deewr.gov.au/Employment/LMI/Pages/LMRP.aspx | http://www.deewr.gov.au/Employment/LMI/Pages/LMRP.aspx | http://www.deewr.gov.au/Employment/LMI/Pages/LMRP.aspx | http://www.deewr.gov.au/Employment/LMI/Pages/LMRP.aspx |  |  | 2014-03-26 00:00:00
Spreadsheet: 765124d1643186309-working-time-with-varied-day-lengths-excluding-weekends-and-holidays-elapsed-day-and-time
Sheet: Sheet1

Start Date | Start Time | End Date | End Time | Elapsed time (days, hours, minutes)
2021-01-01 00:00:00 | 09:14:00 | 2021-02-28 00:00:00 | 17:23:00
2021-03-03 00:00:00 | 06:21:00 | 2021-04-16 00:00:00 | 19:37:00
2021-08-06 00:00:00 | 08:03:00 | 2021-09-15 00:00:00 | 21:32:00
Holidays
Christmas day | 2021-12-25 00:00:00
Boxing day | 2021-12-26 00:00:00
New years day | 2022-01-01 00:00:00
Spreadsheet: 0c2536b3-8913-4593-b438-3e274431e7e9
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
ALFA | Test | ALFA | Alpha-Lactoalbumin, IgE | Alpha-Lactoalbumin, 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
ALFA | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
ALFA | Result | ALFA | Alpha-Lactoalbumin, IgE | Alpha-Lactoalbumin, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 7445-0
Spreadsheet: 879810d1727367684-conditional-formatting-based-on-dates-conform
Sheet: Sheet1

Company | Last payment made | [NAME] date |  | Today
A | 2024-07-29 00:00:00 |  |  | Today - 31
B | 2023-06-13 00:00:00
C | 2022-12-20 00:00:00
D | 2022-10-28 00:00:00
E | 2022-06-10 00:00:00
F | 2023-09-01 00:00:00
G | 2022-03-22 00:00:00
H | 2022-03-18 00:00:00
I | 2022-02-24 00:00:00
J | 2022-02-18 00:00:00
Spreadsheet: 693255d1598885642-fomula-to-consolidate-month-total-grosstotal
Sheet: Store2

 |  |  |  |  |  |  | Gross
 |  |  |  |  |  | 2020-01-05 00:00:00 | 739.0799999999999
 |  |  |  |  |  | 2020-01-12 00:00:00 | 785.73
 |  |  |  |  |  | 2020-01-19 00:00:00 | 809.83
 |  |  |  |  |  | 2020-01-24 00:00:00 | 338.4
 |  |  |  |  |  | 2020-01-26 00:00:00 | 677.13
 |  |  |  |  |  | 2020-02-02 00:00:00 | 1119.66
 |  |  |  |  |  | 2020-02-09 00:00:00 | 767.1899999999999
 |  |  |  |  |  | 2020-02-16 00:00:00 | 1652.49
 |  |  |  |  |  | 2020-02-23 00:00:00 | 770.86
 |  |  |  |  |  | 2020-03-01 00:00:00 | 1097.66
 |  |  |  |  |  | 2020-03-08 00:00:00 | 830.0799999999999
 |  |  |  |  |  | 2020-03-15 00:00:00 | 780.31
 |  |  |  |  |  | 2020-03-22 00:00:00 | 586.65
 |  |  |  |  |  | 2020-03-29 00:00:00 | 973.49
 |  |  |  |  |  | 2020-04-05 00:00:00 | 690.99
 |  |  |  |  |  | 2020-04-12 00:00:00 | 809.6700000000001
 |  |  |  |  |  | 2020-04-19 00:00:00 | 660.1700000000001
 |  |  |  |  |  | 2020-04-26 00:00:00 | 1060.66
 |  |  |  |  |  | 2020-05-03 00:00:00 | 1001.96
 |  |  |  |  |  | 2020-05-10 00:00:00 | 1685.52
 |  |  |  |  |  | 2020-05-17 00:00:00 | 830.26
 |  |  |  |  |  | 2020-05-24 00:00:00 | 1014.05
 |  |  |  |  |  | 2020-05-31 00:00:00 | 719.34
 |  |  |  |  |  | 2020-06-07 00:00:00 | 931.4399999999999
 |  |  |  |  |  | 2020-06-21 00:00:00 | 1172.29
 |  |  |  |  |  | 2020-07-05 00:00:00 | 751.97
 |  |  |  |  |  | 2020-07-19 00:00:00 | 798.19
 |  |  |  |  |  | 2020-08-02 00:00:00 | 1439.86
 |  |  |  |  |  | 2020-08-16 00:00:00 | 1429.24
 |  |  |  |  |  | 2020-08-30 00:00:00 | 0
 |  |  |  |  |  | 2020-09-13 00:00:00 | 0
 |  |  |  |  |  | 2020-09-27 00:00:00 | 0
 |  |  |  |  |  | 2020-10-11 00:00:00 | 0
 |  |  |  |  |  | 2020-10-25 00:00:00 | 0
 |  |  |  |  |  | 2020-11-08 00:00:00 | 0
 |  |  |  |  |  | 2020-11-22 00:00:00 | 0
 |  |  |  |  |  | 2020-12-06 00:00:00 | 0
 |  |  |  |  |  | 2020-12-20 00:00:00 | 0
Spreadsheet: 174464d1345064588-need-help-returning-column-names-for-cells-with-specified-values-in-selected-row-sample-excel-chart
Sheet: Sheet2

 | Method 1 | Method 2 | Method 3 | Method 4 | Overview
Account 1 | Allowed | Allowed | Allowed | Allowed
Account 2 | Restricted | Allowed | Restricted | Allowed
Account 3 | Disallowed | Disallowed | Allowed | Allowed
Spreadsheet: d99266e9-4d8c-4cba-8242-61243e19920e
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
ASRU | Test | ASRU | Arsenic, Random, [NAME] | Arsenic, Random, U | Inductively Coupled Plasma-Mass Spectrometry (ICP-MS) | Plastic urine container with no metal cap or glued insert |  |  | 2 | mL | Collection Container/Tube: Clean, plastic urine collection container Submission Container/Tube: Plastic, 6-mL tube (Supply T465) or a clean, plastic aliquot container with no metal cap or glued insert  [NAME]: 2 mL Collection Instructions:  1. Collect a random urine specimen. 2. Patient should not eat seafood for a 48-hour period prior to start of collection. 3. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. Additional Information: High concentrations of gadolinium and iodine are known to interfere with most metals tests. If either gadolinium- or iodine-containing contrast media has been administered, a specimen should not be collected for 96 hours. | 2 mL | Hemolysis	NA Thawing	Cold, OK; [NAME], OK Lipemia	NA Icterus	NA Other	NA | 0-35 mcg/L Reference values apply to all ages. | Monday through Friday; 3 p.m. - 9 p.m.; Saturday; 8 a.m. - 3 p.m./Continuously | 1 day | 3 days | 1 | 82175 |  |  |  |  | Rochester
ASRU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
ASRU | Result | 89889 | Arsenic, Random, U | Arsenic, Random, U | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | 5586-3 | Arsenic:MCnc:Pt:[NAME]:Qn:
Spreadsheet: 769168d1645361080-iferror-index-and-match-return-0-xlsx-test-2
Sheet: Sheet2

 | [NAME]
Product | ATR 1 | ATR 1 Value | ATR 2 Value
Product1 | Component1
Product2 | Component2
Product3 | Component3
Product4 | Component4
Product5 | Component5
Product1 | Component1
Product7 | Component7
Product8 | Component8
Product2 | Component2
Product10 | Component10
Product11 | Component11
Product1 | Component1
Product13 | Component13
Product2 | Component2
Product2 | Component2
Spreadsheet: 584475d1533210793-matching-3-data-and-getting-result-in-f-column-which-is-a-running-balance-test-match
Sheet: Sheet1

 |  | Data 1 | Data 2 | Data 3 | Data 4 | Data 5
 |  | XL0123 | ABC | 35000 |  | 4500
 |  | AB1261 | DWKING | 45600 |  | 25000
 |  | XL0123 | ABC | 35000 |  | 15800 |  | Matching should be done for Data 1,Data2 & Data 3
 |  | AB1261 | DWKING | 45600 |  | 20600
 |  | XL0123 | ABC | 35000 |  | 14700
Added |  | XL0123 | NBC | 4800 |  | 3000
Added |  | XL0123 | ABC | 15000 |  | 4500
Spreadsheet: 848437d1699174900-rebate-calculation-with-condition-simulation-of-rebate-with-conditions-aligw
Sheet: Sheet1

Simulation of rebate
 |  | Min. top up should be reached to get rebate | 1000000
 |  | Rebate % | 0.25
 |  | [NAME]. top up allowed | 2000000
 |  | Timeline | 2023-11-06 00:00:00 | 2023-11-07 00:00:00 | 2023-11-08 00:00:00 | 2023-11-09 00:00:00 | 2023-11-10 00:00:00 | 2023-11-11 00:00:00 | 2023-11-12 00:00:00 | 2023-11-12 00:00:00
 |  | Top up done by user | 300000 | 700000 | 0 | 500000 | 300000 | 0 | 200000 | 1000000
 |  | Cumulative top up
 |  | Rebate (25% of top up)
 | Need formula for this >>> | Rebate user actually get
 |  | Remarks | not get [NAME] because not yet reach Min. top up (cell D2) | get [NAME] for the first time because alr. reached Min. top up |  |  |  |  |  | not get rebate anymore because alr. exceed [NAME]. top up (cell D4)
Spreadsheet: 66394d1267052183-looking-up-values-book1
Sheet: Sheet2

Name | B | W10 | W20 | W30
0
[NAME] | 1a
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Megan Mason
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
zzz zzz
zzz zzz
zzz zzz
zzz zzz
zzz zzz