tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 102065d1300123025-matching-data-and-expanding-results-links
Sheet: Sheet1

CUBE: | [NAME]:Revenue
[NAME]:Year | 2011
[NAME]:Service type | All service types
[NAME]:Job period | All years
[NAME]:Cost centre | 1612
[NAME]:Terms | All terms of sale
[NAME]:Corporate Product | All Product Lines
[NAME]:Month | YTD Dec
[NAME]:Country | Focus
 | Revenue | Profit | Jobs
Total customers | 649929.84 | 111142.96 | 333
Other-c | 490542.93 | 83350.26 | 233
Past Times-c | 43225.94 | 5708.71 | 23
[NAME] | 16011.86 | 5288.14 | 5
Waymade-c | 14704.71 | 1227.58 | 2
Dr Reddys-c | 13232 | 372.85 | 7
Alpharma-c | 11833.82 | 3043.58 | 4
[NAME]-c | 10252.54 | 166.5 | 1
[NAME] | 8646.81 | 1204.23 | 5
India Shop-c | 7766.26 | 2245.66 | 8
[NAME]-c | 7059.4 | 889.68 | 7
Vygon-c | 4839.21 | 915.33 | 2
Vortok-c | 4680.13 | 568.14 | 2
Fine Tubes-c | 2987.13 | 1587.4 | 3
[NAME]c | 2721.31 | 423.73 | 0
Alder Sportswear-c | 1838.67 | 324.41 | 1
[NAME] | 1803.28 | 304.73 | 1
[NAME] | 1546.26 | 254.56 | 4
Kemfast Aerospace-c | 1425.41 | 330.83 | 5
Amnitec-c | 1184.94 | 466.99 | 2
[NAME] | 535.46 | 152.33 | 2
Llexeter-c | 519 | 1282.14 | 0
Powerflow Exhausts-c | 487.3 | 204.43 | 1
Louis Stone Optical-c | 377.18 | 215.26 | 1
[NAME] | 372.72 | 135.91 | 3
Rolls Royce-c | 343.39 | 238.62 | 3
Silver Telecom-c | 328.06 | 142.05 | 2
Loudspeaker Technology-c | 251.24 | 75.74 | 1
Norgine-c | 165.15 | 62.86 | 1
Associated Dental Products-c | 107.21 | 31.29 | 1
[NAME] | 105.52 | 26.15 | 0
G E Caledonian-c | 35 | 30.45 | 1
[NAME] | 0 | -22.38 | 1
Tyco-c | 0 | -99.59 | 0
BHC Components-c | 0 | 75.83 | 0
Parker Hannifin-c | 0 | -11.13 | 0
Powerball-c | 0 | -70.31 | 1
Spreadsheet: 122592d1317012068-sum-by-month-week-etc-to-date-in-a-log-calories-1-
Sheet: Log

DATE | [NAME] | CAL
2011-09-23 00:00:00 | tuna | 400
2011-09-23 00:00:00 | turkey | 500
2011-09-22 00:00:00 | oatmeal | 250
2011-09-22 00:00:00 | salad | 111
2011-09-22 00:00:00 | tuna | 400
2011-09-20 00:00:00 | turkey | 500
2011-09-20 00:00:00 | oatmeal | 250
2011-09-18 00:00:00 | tuna | 400
2011-09-17 00:00:00 | oatmeal | 250
2011-09-17 00:00:00 | turkey | 500
2011-09-17 00:00:00 | salad | 111
2011-09-16 00:00:00 | oatmeal | 250
2011-09-15 00:00:00 | tuna | 400
2011-09-15 00:00:00 | turkey | 500
2011-09-14 00:00:00 | salad | 111
2011-09-10 00:00:00 | tuna | 400
2011-09-08 00:00:00 | turkey | 500
2011-09-03 00:00:00 | salad | 111
2011-09-03 00:00:00 | oatmeal | 250
2011-08-24 00:00:00 | salad | 111
2011-08-22 00:00:00 | tuna | 400
2011-08-22 00:00:00 | turkey | 500
2011-08-17 00:00:00 | oatmeal | 250
Spreadsheet: 858000d1706808414-formula-to-place-worksheet-name-in-cell-on-another-worksheet-sample-sheet
Sheet: Sup 3

 | Claim Rep | Number of Promoters | Number of Detractors | Total Survey Count | Overall Score
 |  |  |  | Team Score
 |  |  |  | Updated 12/27/23
Spreadsheet: 763833d1642424088-need-alternative-non-volatile-formula-insted-of-given-one-non-volatile-help
Sheet: SeatPlan

Room No |  | 1
5 |  | 4 |  | 7 |  | 2 |  | 6 |  | 5 |  | 8 |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name of Source Sheet | source |  |  |  |  |  |  | =IFERROR(INDEX($R$6:$R$15,MATCH(0,INDEX(COUNTIF($U$5:U5,$R$6:$R$15),0,0),0))," ")
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | First Cell | A2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reference
Spreadsheet: 36965d1234907874-modifying-cells-after-subtotaling-example
Sheet: Subtotaled

Employee | Item | Sales
Fred | Gloves | 10
Fred | Socks | 15
Fred Total |  | 25
[NAME] | Gloves | 5
[NAME] | Socks | 30
Alice Total |  | 35
[NAME] | Socks | 16
[NAME] |  | 16
Grand Total |  | 76
Spreadsheet: 135923d1326307974-auto-populate-work-order-forms-from-different-sheet-example
Sheet: New Work order

Date Called: |  |  |  |  |  |  | Time: |  |  |  |  | Designated Employee: |  |  |  |  | Report Provided: (circle one)                                       YES - Attach Copy           NO - Fill In Scope of Work |  |  |  |  |  | Date Called | Time | Employee | Report Provided | Return Call by | Appt Req'd | Service Date | Time | Company | Hours of operation | Days of Operation | Contact | Acct Number | Acct Status | PO Req'd | Address
2011-12-01 00:00:00 |  |  |  |  |  |  | 09:00:00 |  |  |  |  | DP |  |  |  |  | NO |  |  |  |  |  | 40878 | 0.375 | DP | NO | . | . | . | . | . | . | . | . | . | . | . | .
Return Call By: |  |  |  |  |  |  |  |  |  |  |  | Appt. [NAME]?:           YES    NO |  |  | Service Date: |  |  |  |  | Time: |  |  | PO # | Payment Type | City | Province | Postal Code | Card Number | Exp | Phone | Cell | Job Number | Fax | [NAME] | Jobsite Address | Alternate Contact | Phone | Information
. |  |  |  |  |  |  |  |  |  |  |  | . |  |  | . |  |  |  |  | . |  |  | . | . | . | . | . | . | . | . | . | . | . | . | . | . | . | .
Company: |  |  |  |  |  |  |  |  |  |  |  | Hours of Operation: |  |  |  |  |  | Days of Operation: |  |  |  |  | Last Service | Service Due | City Section
. |  |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  |  | . |  |  |  |  | . | . | NE9 | NE10
Contact: |  |  |  |  |  |  |  |  |  |  |  | Acct# |  |  |  |  | Acct. Status: CHARGE     COD |  |  | PO# [NAME]?           YES - Fill In PO#   NO
. |  |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  | . |  |  | .
[NAME]: |  |  |  |  |  |  |  |  |  |  |  | PO# |  |  |  |  |  |  | Payment Type:                                           VISA   M/C   CASH   CHEQ
. |  |  |  |  |  |  |  |  |  |  |  | . |  |  |  |  |  |  | .
City: |  |  |  |  |  | Province: |  |  | Postal: |  |  | Card Number: |  |  |  |  |  |  |  | EXP:
. |  |  |  |  |  | . |  |  | . |  |  | . |  |  |  |  |  |  |  | .
Phone: |  |  |  |  |  | Cell: |  |  |  |  |  | Job Number (If [NAME]):
. |  |  |  |  |  | . |  |  |  |  |  | .
Fax: |  |  |  |  |  | E-Mail: |  |  |  |  |  | Jobsite Address (if different from billing address):
. |  |  |  |  |  | . |  |  |  |  |  | .
Alternate Contact: |  |  |  |  |  | Phone: |  |  |  |  |  | City Section
. |  |  |  |  |  | . |  |  |  |  |  | SE1
Information/Message/Scope of Work:
.
Spreadsheet: 209663d1359151215-delete-columns-based-on-fill-color-rick-test
Sheet: Sheet1

1 | a | x | 5 | c | a | 10 | z | 10 | z | q
3 | d | u | 10 | d | b | 15 | e | 5 | w | e
2 |  |  | 15 | a | z | a | s | 74 | a | t
4 |  | z | 12 | s | s | d | t | 85 | b
6 | s | s | 14 | t | e | 4 | y | 65 | c
5 | e | e | 12 | h | j | q |  | 55 |  | a
7 | t | h | 11 | u | u |  |  | 45 |  | e
6 |  | l | 14 | g | o | 17 | s | 25 | s | t
4 | s | t | 18 | s | t | 14 | t | 36 | z
9 | t | y | 20 | t | s | a | u | 22 | o | z
Spreadsheet: darrell_schoolcraft__7775__imbalsumm0106
Sheet: Calpine

 | Calpine So. Point Power Del
 | 78113
Day | Measured | Scheduled
1 | -52917 | -37500
2 | -38872 | -40000
3 | -34322 | -40000
4 | -44422 | -29550
5 | -41682 | -45983
6 | -60431 | -68633
7 | -62347 | -50000
8 | -65929 | -79625
9 | -52330 | -64819
10 | -42397 | -50000
11 | -61555 | -49841
12 | -55007 | -65300
13 | -63094 | -65300
14 | -61350 | -65241
15 | -43564 | -40000
16 | -41480 | -40000
17 | -41244 | -40001
18 | -53603 | -50000
19 | -70811 | -65199
20 | -68739 | -65286
21 | -66650 | -65300
22 | -67968 | -65300
23 | -60475 | -50000
24 | -40827 | -50000
25
26
27
28
29
30
31
2001-05-31 00:00:00 |  |  | -357096.85
2001-06-24 00:00:00
Spreadsheet: 58750d1259015868-excel-2007-sort-and-group-numbers-into-lists-book1
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | list
 |  |  |  |  |  |  |  |  |  |  |  | 11.77
 |  |  |  |  |  |  |  |  |  |  |  | 11.69
 |  |  |  |  |  |  |  |  |  |  |  | 10.28
 |  |  |  |  |  |  |  |  |  |  |  | 10.98
 |  |  |  |  |  |  |  |  |  |  |  | 10.58
 |  |  |  |  |  |  |  |  |  |  |  | 5.850000000000001
 |  |  |  |  |  |  |  |  |  |  |  | 9.53
 |  |  |  |  |  |  |  |  |  |  |  | 9.63
 |  |  |  |  |  |  |  |  |  |  |  | 4.2
 |  |  |  |  |  |  |  |  |  |  |  | 8.75
 |  |  |  |  |  |  |  |  |  |  |  | 8.55
 |  |  |  |  |  |  |  |  |  |  |  | 1.7
 |  |  |  |  |  |  |  |  |  |  |  | 8.32
 |  |  |  |  |  |  |  |  |  |  |  | 9.74
 |  |  |  |  |  |  |  |  |  |  |  | 1.39
 |  |  |  |  |  |  |  |  |  |  |  | 2.48
 |  |  |  |  |  |  |  |  |  |  |  | 11.39
 |  |  |  |  |  |  |  |  |  |  |  | 1.19
 |  |  |  |  |  |  |  |  |  |  |  | 4.83
Spreadsheet: 869714d1716301441-rota-generator-rota-test
Sheet: Sheet1

 | Week 1
 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
Early
Late
[NAME] | 18 | 18 | 18 | 18 | 18 | 18 | 18
Spreadsheet: 472037d1469422257-error-and-or-in-excel-excel-help-forum
Sheet: IO Count

# | EQUIPMENT | Description | QTY | DO | DI | AI | AO | Total Points
1 | Input | Inputs | 1 | 7 | 2 | 6 | 2
 |  | Controller | 1
3 |  | WITH SPARE | 0
Spreadsheet: 59624d1260217146-excel-2007-checking-a-range-of-dates-with-if-or-select-case-example1
Sheet: TA2009-17

FLEXIBLE SCHEDULE CERTIFICATION FORM
NAME: |  |  |  |  |  |  |  |  |  |  |  | Established Hours:
 |  |  |  |  |  |  |  |  |  |  |  | M |  |  | M:
ORG: |  |  |  |  |  |  |  |  |  |  |  | T: |  |  | T:
 |  |  |  |  |  |  |  |  |  |  |  | W |  |  | W:
PP Ending: |  |  |  |  |  |  |  |  |  |  |  | T: |  |  | T:
 |  | PP | 09-17 |  |  |  |  |  |  |  |  | F: |  |  | F:
 |  | Working Hours |  | Time in Duty Status |  |  |  | *Telework Hours |  | Credit Hours |  |  | [NAME]
Date |  | Arrive | [NAME] | Regular | Overtime | Comp | Holiday | Worked | Code | Earned | Used | Balance | Annual | Sick | Comp | LWOP | Other | Remarks
Previous Balance
S
M
T
W
T
F
S
S
M
T
W
T
F
S
Ending Balance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL PAYABLE HRS.
Totals
 | Employee Signature: |  |  |  |  |  |  |  |  |  | Supervisor Signature:
 |  |  |  |  |  |  |  |  |  |  |  | *Telework Indicator Codes
 |  |  |  |  |  |  |  |  |  |  |  | Code |  | "Fixed" Telework Agreement
 |  |  |  |  |  |  |  |  |  |  |  | C | 3 or more days per week at alternate work site
 |  |  |  |  |  |  |  |  |  |  |  | F | 2 or fewer days per week at alternate work site
 |  |  |  |  |  |  |  |  |  |  |  | Code |  | “As Needed” Telework Agreement
 |  |  |  |  |  |  |  |  |  |  |  | I | Work performed at alternate work site
 |  |  |  |  |  |  |  |  |  |  |  | The Telework columns are to be left blank for those employees who did not work at an alternate worksite during the Pay Period.
MOST EMPLOYEES SHOULD HAVE NO BALANCE IN LWOP.
Spreadsheet: 267537d1380106128-how-to-get-list-of-names-by-typing-one-name-test-3-
Sheet: Sheet2

Agent Name | Supervisor
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] Iqbal | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
Anum Salahuddin | [NAME]
Sadaf [NAME] | [NAME]
[NAME] | [NAME]
Malahat Naz | Duke
[NAME] | Duke
Sidra Tul Muntaha | Duke
Ravi Kumar | Duke
[NAME] | Duke
Ayesha | Duke
Ambreen [NAME] | Duke
[NAME] | Duke
Spreadsheet: 00d65f66-e446-4fd9-8573-3bba2426ebfd
Sheet: Sheet1

Note: P=Permanent | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
[NAME] of Professional Studies
Record Series | In Office | Archives | Total Retention Period | Notes
Accreditation Final Report | One accreditation cycle | P | P
Accreditation background files | One accreditation cycle |  | One accreditation cycle
Adjunct faculty files | Termination+one accreditation cycle |  | termination+one accreditation cycle
Association files | Current |  | Current
[NAME]'s project/program files | 3 years | P | P | Archives will weed
Faculty files | Termination+one accreditation cycle |  | Termination+one accreditation cycle
Faculty publications | Send to Archives | P | P
Newsletters | 3 years | P | P | Print out 2 copies for Archives
Partners in Corporate Education (former program) files | Send to Archives | P | P
Printed material:  Brochures, programs, etc. | 3 years | P | P
Student advisory Files | Graduation/termination+5 years |  | Graduation/termination+5 years
Spreadsheet: 870302d1716841036-can-anyone-tell-what-mistake-i-am-doing-in-my-formulas-given-in-the-sample-file-sample-file
Sheet: Table 30

कार्यक्रम PROGRAM |  |  | एसएमई [NAME] कौिल सिंर्धयन UPSKILLING OF SME SULABH HEADS | PROG CODE
 |  |  |  | IT 1752
तर्षर् समूह/SUBJECT GROUP |  |  | CREDIT
उद्देश्य/OBJECTIVE |  |  | EQUIPPING TRAINEES ABOUT SME CREDIT MARKET AND RELEVANT TOOLS AND STARTEGIES
लतक्षि समूह/TARGET GROUP |  |  | [NAME]
अर्तध/DURATION |  |  | 5 DAYS
DAY | SESSION | CONTENTS
Day 1 | I | Inauguration /Entry Test/ Roles and responsibilities of SME Sulabh Heads/SME Products
 | II | Indian economy vis-à-vis challenges and opportunities available for MSMEs
 | III | MSME Policy, Risk Rating, Delegation of Power, Rating agency reports, Industry outlook, CRILC, CIBIL, Probe 42, CEIB reports
 | IV | Fundamentals of Accounting Principle/ Financial Statements Mandatory Requirements, UDIN, MCA Portal for Balance Sheet verification, Inter firm comparison as key ratios
Day 2 | I | Ratio Analysis – Advantages & uses Limitations
 | II | Cash Flow & Fund Flow Analysis
 | III | Assessment of Working Capital / Financing of NFB credit requirements
 | IV | Term [NAME] / Case study on Term Loan Assessment
Day 3 | I | Nuances of Project & Infrastructural Finance
 | II | Rehabilitation mechanism for MSMEs
 | III | Legal Aspects of Mortgage, Valuation & Important Aspect of Documentation
 | IV | Marketing of MSME products and boosting MSME portfolio
Day 4 | I | Group Discussion- How to augment MSME portfolio
 | II | Important aspects of BULC, HAM Projects, LRD & Big Ticket Proposals.
 | III | Awareness on Fraud, Cyber Security and preventive vigilance
 | IV | Nurturing Customer Relationships
Day 5 | I | Leadership, Motivation and Team Building
 | II | Ethics and Value System
 | III | Implementation of OL, Prevention of Sexual Harassment at Workplace, Valediction
 | IV | Exit Test, Feedback & Valediction
Spreadsheet: 154066d1336171298-return-yes-no-late-from-multiple-tick-or-cross-sample2
Sheet: one

 | in a hidden data sheet |  |  |  | Arrears options
 |  | data |  |  | YES
 |  | a |  |  | NO
 |  | r |  |  | ARREARS
 |  | s
 | this is on a different sheet within the same work book
 |  |  | Monthly rent |  | Arrears | Amount
 | Property 1 |  | 850 |  | NO | 0
 | Property 2 |  | 475 |  | LATE | 475
 | Property 3 |  | 1300 |  | NO | 0
 | Property 4
 | etc |  | 850 |  | NO | 0
 | etc |  | 800 |  | NO | 0
Spreadsheet: 875715d1722333666-countif-function-doesnt-show-right-amount-maartenro-countif-ip-adresses-tms
Sheet: vergelijking IP-adressen

IP-adressen X | IP-adressen Z | Times Z in X | =SUBSTITUTE(A2,CHAR(160),"") | =SUBSTITUTE(B2,CHAR(160),"") | =TRIM(D2) | =TRIM(E2)
81.82.72.66 | 185.177.124.191
2a02:1810:1437:bb00:6c92:366a:c61e:4faa | 81.82.72.66
84.195.11.116 | 169.154.218.66
84.195.11.116 | 185.483.34.36
84.195.11.116 | 37.14.205.148
84.195.11.116 | 185.143.34.168
2a02:1810:1437:bb00:7cac:d196:61c2:6858 | 84.195.11.116
Spreadsheet: kate_symes__18447__NP 15 pages
Sheet: DJ NP15

 |  |  | Firm | Volume | Firm | Volume | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-01-10 00:00:00 |  | 176.02 | 12720 | 158.32 | 3800
 | 2001-01-09 00:00:00 |  | 171.72 | 13856 | 156.09 | 2200
 | 2001-01-08 00:00:00 |  | 159.12 | 13120 | 151.13 | 1600
 | 2001-01-07 00:00:00 |  |  |  |  |  | 150 | 4200
 | 2001-01-06 00:00:00
 | 2001-01-05 00:00:00 |  | 152.46 | 10720 | 150.55 | 1520
 | 2001-01-04 00:00:00 |  | 161.59 | 12320 | 155.14 | 2920
 | 2001-01-03 00:00:00 |  | 175.15 | 2720 | 170 | 1000
 | 2001-01-02 00:00:00 |  | 165.38 | 4240 | 155.83 | 720
 | 2001-01-01 00:00:00 |  |  |  |  |  | 162.7 | 3336
 | 2000-12-31 00:00:00 |  |  |  |  |  | 167.91 | 3792
 | 2000-12-30 00:00:00 |  | 173.81 | 8400 | 167.91 | 1264
 | 2000-12-29 00:00:00 |  | 226.67 | 2400 | 190 | 264
 | 2000-12-28 00:00:00 |  | 226.67 | 2400 | 190 | 264
 | 2000-12-27 00:00:00 |  | 343.33 | 1200 | 257.69 | 864
 | 2000-12-26 00:00:00 |  | 355.32 | 1488 | 326.47 | 3400
 | 2000-12-25 00:00:00 |  |  |  |  |  | 374 | 3000
 | 2000-12-24 00:00:00 |  |  |  |  |  | 374 | 3000
 | 2000-12-23 00:00:00 |  | 420.71 | 2800 | 374.17 | 1200
 | 2000-12-22 00:00:00 |  | 420.71 | 2800 | 374.17 | 1200
 | 2000-12-21 00:00:00 |  | 420.71 | 2800 | 374.17 | 1200
 | 2000-12-20 00:00:00 |  | 450 | 400 | 400 | 400
 | 2000-12-19 00:00:00 |  | 410.63 | 3200 | 325 | 400
 | 2000-12-18 00:00:00 |  | 339.29 | 2800 | 295 | 600
 | 2000-12-17 00:00:00 |  |  |  |  |  | 294.67 | 1800
 | 2000-12-16 00:00:00 |  | 280 | 400 | 260 | 400
 | 2000-12-15 00:00:00 |  | 280 | 400 | 260 | 400
Spreadsheet: 105230d1302649827-hlookup-using-data-in-multiple-columns-hockeystats
Sheet: Sheet1

SMITH |  |  |  | JONES |  |  |  | BROWN
GP | G | A | PIM | GP | G | A | PIM | GP | G | A | PIM
1 |  | 2 | 2 | 1 |  | 2 | 6 | 1 | 1 |  | 2
1 | 1 | 1 |  | 1 |  |  |  | 1 |  | 1
1 |  |  | 4 | 1 |  |  | 8
1 | 2 |  |  | 1 |  | 2 | 5
1 | 1 | 1 |  | 1 | 1 | 1 |  | 1 | 1 | 1 | 2
1 |  |  |  | 1 |  |  |  | 1
1 |  | 2 | 4 | 1 |  |  | 9
 |  |  |  | 1 |  | 1 |  | 1 | 1 | 2
 |  |  |  | 1 | 1 |  |  | 1
1 | 1 |  | 2 | 1 |  | 2 | 2 | 1 | 1 |  | 2
1 |  | 3 |  | 1 |  |  |  | 1 |  | 2
 |  | GP | G | A | Pts | PIM
Smith |  |  |  |  | 0
Jones |  |  |  |  | 0
[NAME] |  |  |  |  | 0
Better for your data to look like below.
Name | Stat | Score
Smith | GP | 1
Smith | GP | 1 |  |  |  | Count of Score | Stat
Smith | GP | 1 |  |  |  | Name | A | G | GP | PIM | Grand Total
Smith | GP | 1 |  |  |  | [NAME] | 4 | 4 | 8 | 3 | 19
Smith | GP | 1 |  |  |  | Jones | 5 | 2 | 11 | 5 | 23
Smith | GP | 1 |  |  |  | Smith | 5 | 4 | 9 | 4 | 22
Smith | GP | 1 |  |  |  | Grand Total | 14 | 10 | 28 | 12 | 64
Smith | GP
Smith | GP
Smith | GP | 1
Smith | GP | 1
Jones | GP | 1
Jones | GP | 1
Jones | GP | 1
Jones | GP | 1
Jones | GP | 1
Jones | GP | 1
Jones | GP | 1
Jones | GP | 1
Jones | GP | 1
Jones | GP | 1
Jones | GP | 1
[NAME] | GP | 1
[NAME] | GP | 1
[NAME] | GP
[NAME] | GP
[NAME] | GP | 1
[NAME] | GP | 1
[NAME] | GP
[NAME] | GP | 1
[NAME] | GP | 1
[NAME] | GP | 1
[NAME] | GP | 1
Smith | G
Smith | G | 1
Smith | G
Smith | G | 2
Smith | G | 1
Smith | G
Smith | G
Smith | G
Smith | G
Smith | G | 1
Smith | G
Jones | G
Jones | G
Jones | G
Jones | G
Jones | G | 1
Jones | G
Jones | G
Jones | G
Jones | G | 1
Jones | G
Jones | G
[NAME] | G | 1
[NAME] | G
[NAME] | G
[NAME] | G
[NAME] | G | 1
[NAME] | G
[NAME] | G
[NAME] | G | 1
[NAME] | G
[NAME] | G | 1
[NAME] | G
Smith | A | 2
Smith | A | 1
Smith | A
Smith | A
Smith | A | 1
Smith | A
Smith | A | 2
Smith | A
Smith | A
Smith | A
Smith | A | 3
Jones | A | 2
Jones | A
Jones | A
Jones | A | 2
Jones | A | 1
Jones | A
Jones | A
Jones | A | 1
Jones | A
Jones | A | 2
Jones | A
[NAME] | A
[NAME] | A | 1
[NAME] | A
[NAME] | A
[NAME] | A | 1
[NAME] | A
[NAME] | A
[NAME] | A | 2
[NAME] | A
[NAME] | A
[NAME] | A | 2
Smith | PIM | 2
Smith | PIM
Smith | PIM | 4
Smith | PIM
Smith | PIM
Smith | PIM
Smith | PIM | 4
Smith | PIM
Smith | PIM
Smith | PIM | 2
Smith | PIM
Jones | PIM | 6
Jones | PIM
Jones | PIM | 8
Jones | PIM | 5
Jones | PIM
Jones | PIM
Jones | PIM | 9
Jones | PIM
Jones | PIM
Jones | PIM | 2
Jones | PIM
[NAME] | PIM | 2
[NAME] | PIM
[NAME] | PIM
[NAME] | PIM
[NAME] | PIM | 2
[NAME] | PIM
[NAME] | PIM
[NAME] | PIM
[NAME] | PIM
[NAME] | PIM | 2
[NAME] | PIM
Spreadsheet: 721468d1614716157-duplicated-a-product-list-to-a-store-list-example
Sheet: Sheet2

UPC | Name
81062803139 | Golden Road Hazy Roller  6/12C
85689500384 | Golden Road Mango Cart 6/12C
78615000014 | [NAME] 12/11B
78615000001 | [NAME] 6/11B
1820020208 | [NAME] 12/12C SC
1820020272 | [NAME] Pk 9/12C
1820020263 | Michelob Ultra Org Seltzer VtyPk 12/12C SC
1820000769 | [NAME] 12/12B
1820053047 | [NAME] 12/12C
1820053218 | [NAME] 18/12C
1820021986 | [NAME] 3/25C
1820000833 | [NAME] 6/12B
1820011047 | Budweiser 12/12C
1820011218 | Budweiser 18/12C
1820021985 | Budweiser 3/25C
1820005990 | Michelob Ultra 12/12B
1820006991 | Michelob Ultra 12/12C SC
1820096721 | Michelob Ultra 18/12C SC
1820024981 | Michelob Ultra 3/25C
1820005989 | Michelob Ultra 6/12B
Spreadsheet: 729453d1619099406-subtracting-extracted-numbers-from-a-string-of-test-3
Sheet: Sheet1

Data Type
[NAME] | String |  |  | [NAME]
Starting Gate | Removed Starting Gate |  |  | New Starting Gate | Comment
4 | 1 | 2 | 3 | 1 | All three gates are subtracted
4 | 3 | 7 | 8 | 3 | only 1 gate is subtracted
4 | 7 | 8 | 9 | 4 | 0 gates are subtracted
Spreadsheet: 865704d1712727847-get-value-from-upper-and-lower-cell-based-on-values-09042024-resolved-sample-file
Sheet: Sheet1

 | Sample File |  |  |  |  |  | Result | Product | 9601
 | Date | BranchCode | ProductCode | Amount |  |  | Date | Branch | Debit | Credit
 | 2023-09-30 00:00:00 | 12 | 9601 | 0 |  |  | 2023-09-30 00:00:00 | 12
 | 2023-09-30 00:00:00 | 14 | 9601 | 1160 |  |  | 2023-09-30 00:00:00 | 14
 | 2023-09-30 00:00:00 | 18 | 9601 | 2090 |  |  | 2023-09-30 00:00:00 | 18
 | 2023-09-30 00:00:00 | 23 | 9601 | 0 |  |  | 2023-09-30 00:00:00 | 23
 | 2023-09-30 00:00:00 | 45 | 9601 | 1800 |  |  | 2023-09-30 00:00:00 | 45
 | 2023-09-30 00:00:00 | 12 | 9045 | 245
 | 2023-09-30 00:00:00 | 14 | 9045 | 345 |  |  |  |  | =IFERROR(INDEX($E$3:$E$17, MATCH(1, ($B$3:$B$17=$H$3)*($C$3:$C$17=I3)*(ISNUMBER($E$3:$E$17)), 0)), "-")
 | 2023-09-30 00:00:00 | 18 | 9045 | 360 |  |  |  |  |  | =IFERROR(IF(J3<>0,0,INDEX($E$3:$E$17, MATCH(1, ($B$3:$B$17=$H$3)*($C$3:$C$17=I3)*($D$3:$D$17=$J$1)*($E$3:$E$17>0), 0))), "-")
 | 2023-09-30 00:00:00 | 23 | 9045 | 860
 | 2023-09-30 00:00:00 | 45 | 9045 | 510
 | 2023-09-30 00:00:00 | 12 | 9601 | 1625
 | 2023-09-30 00:00:00 | 14 | 9601 | 0
 | 2023-09-30 00:00:00 | 18 | 9601 | 0
 | 2023-09-30 00:00:00 | 23 | 9601 | 1445
 | 2023-09-30 00:00:00 | 45 | 9601 | 0
Spreadsheet: 707cbd3c-caaf-4579-92e5-74fa4e7480ee
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
GLURA | Test | GLURA | Glucose, [NAME], Serum | Glucose, Random, S | Photometric, [NAME] | Plain, Red-Top Tube: Red |  |  | 0.5 | mL | Container/Tube:  Preferred: Serum gel Acceptable: Red top [NAME]: 0.5 mL | 0.25 mL | Hemolysis	Mild reject; Gross reject Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | 0-11 months: not established > or =1 year: 70-140 mg/dL | Monday through Sunday; Continuously | Same day/1 day | 2 days | 1 | 82947 |  |  |  |  | Rochester
GLURA | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
GLURA | Result | GLURA | Glucose, Random, S | Glucose, Random, S | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 2345-7 | Glucose:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 775910d1649372136-count-values-on-sheet2-based-on-condition-involving-data-from-sheet1-test20
Sheet: Sheet1

User ID | Surname | First Name | Count of Requests Expected | Count of Requests Formula
123 | Town | [NAME] | 1
345 | Smith | [NAME] | 2
789 | [NAME] | Julie | 1
101 | [NAME] | Gillian | 0
431 | [NAME] | [NAME] | 1