tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 456869d1461093697-lookup-data-in-multiple-columns-to-sum-values-in-corresponding-cells-ak-excel-froum-help-example-data
Sheet: Result

Order Number | Line Number | Qty | Price | Total
Spreadsheet: 200047d1355400614-match-single-data-with-multiple-data-book1
Sheet: Sheet1

data |  | rma | rma | rma
 |  | 1 | 2 | 3
120900934 |  | OK4KCU | OK4KI0 | OJYE36
120901010 |  | OK60ZD | OK62AP | OK1RZX
120901084 |  | OK6TA5 | OK6TBP | OK46Q3
120901139 |  | OK7V0T | OK7WC4 | OK4LZ7
120901164 |  | FOC | OK4827 | OK62VV
121000187 |  | OKIA9L | OKIAEC | OK6VW2
 |  | rma | data
 |  | FOC | #N/A
 |  | OJYE36 | #N/A
 |  | OK1RZX | #N/A
 |  | OK46Q3 | #N/A
 |  | OK4827 | #N/A
 |  | OK4KCU | 120900934
 |  | OK4KI0 | 120900934
 |  | OK4LZ7 | 120900934
 |  | OK60ZD | 120901010
 |  | OK62AP | 120901010
 |  | OK62VV | 120901010
 |  | OK6TA5 | 120901084
 |  | OK6TBP | 120901164
 |  | OK6VW2 | 120901164
 |  | OK7V0T | 120901164
 |  | OK7WC4 | 120901164
 |  | OKIA9L | 121000187
 |  | OKIAEC | 121000187
Spreadsheet: 4236583e-055a-49be-abd4-f42b1b25ba28
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
2916 | 10402 | Martin | Flinta | SWE | 6 | 00:13:52 | 00:00:00 | 00:21:40 | 00:00:00 | 00:19:31 | 1 | 00:55:05
2916 | 15596 | Francesco | Dutto | ITA | 5 | 00:13:37 | 00:00:00 | 00:23:00 | 00:00:00 | 00:20:34 | 2 | 00:57:12
2916 | 5988 | [NAME] | Rieglthalner | AUT | 4 | 00:14:56 | 00:00:00 | [NAME] | 00:00:00 | [NAME] | 3 | 01:00:23
Spreadsheet: 862708d1710352330-sort-filter-multiple-columns-table-to-sort-and-filter-aligw
Sheet: Sheet1

 | Department | Manager | Coordinator | Contractor |  | All Names Sorted |  | Billing
 | Billing | [NAME] | [NAME] | Stephen
 | Billing | [NAME] | [NAME] | Gene |  | [NAME]
 | HR | [NAME] | Jennie | Sophia |  | Gene
 | HR |  | [NAME] |  |  | [NAME]
 | HR |  | [NAME] |  |  | [NAME]
 | Outreach | Yulia | [NAME] | [NAME] |  | Stephen
 | Outreach |  |  | [NAME]
Spreadsheet: louise_kitchen__23038__E-Next equipment balances 11-05-01
Sheet: E-Next Equipment Balances

Equipment in E-Next Generation LLC
 | as of | 2001-10-28 00:00:00
 | PROJECT NAME | EQUIPMENT | Last Payment Date | PAID TO DATE | COMMITTED TO PAY | TOTAL
 | Ft. Pierce | 1 HRSG |  | 506000 | 0
 | Columbia/Longview | 1 7FA turbine | 2002-10-01 00:00:00 | 13328000
 |  | 1 Steam turbine | 2002-10-01 00:00:00 | 909160
 |  | 1 HRSG | 2002-10-01 00:00:00 | 1480000
 |  | Cascade Transportation Agreement | 2003-03-01 00:00:00 | 0 | 950000
 | Interest and Financing Fees
 | Total
Spreadsheet: eric_saibi__9835__100301R
Sheet: Dresden 02

Owner Name |  | [NAME]
Station Name |  | Dresden Nuclear Power Station
Unit Name |  | Dresden 02
NERC Region |  | MAIN
State |  | IL
Fuel Type |  | Nuclear
Capacity |  | 828 MW
Start Date |  | 2001-10-20 00:00:00
End Date |  | 2001-11-20 00:00:00
Prv. Start Date |  | 2001-10-20 00:00:00
Prv. End Date |  | 2001-11-16 00:00:00
Comments |  | Refuel/ Transformer repair
SIC |  | 4931
Plant ID |  | 1009265
Unit ID |  | 1007231
Outage ID |  | 8100
Spreadsheet: 50732d1250191043-find-combo-of-numbers-in-a-column-that-specific-value-sumfromrange
Sheet: Sheet2

 | a | b | c | d | e
abcde | 10 | 3 | 27 | 8 | 9 | 57
abcd | 10 | 3 | 27 | 8 |  | 48
abce | 10 | 3 | 27 |  | 9 | 49
[NAME] | 10 | 3 |  | 8 | 9 | 30
acde | 10 |  | 27 | 8 | 9 | 54
bcde |  | 3 | 27 | 8 | 9 | 47
abc | 10 | 3 | 27 |  |  | 40
[NAME] | 10 | 3 |  | 8 |  | 21
[NAME] | 10 | 3 |  |  | 9 | 22
[NAME] | 10 |  | 27 | 8 |  | 45
ace | 10 |  | 27 |  | 9 | 46
ade | 10 |  |  | 8 | 9 | 27
bcd |  | 3 | 27 | 8 |  | 38
bce |  | 3 | 27 |  | 9 | 39
bde |  | 3 |  | 8 | 9 | 20
cde |  |  | 27 | 8 | 9 | 44
ab | 10 | 3 |  |  |  | 13
ac | 10 |  | 27 |  |  | 37
ad | 10 |  |  | 8 |  | 18
ae | 10 |  |  |  | 9 | 19
bc |  | 3 | 27 |  |  | 30
bd |  | 3 |  | 8 |  | 11
be |  | 3 |  |  | 9 | 12
cd |  |  | 27 | 8 |  | 35
ce |  |  | 27 |  | 9 | 36
de |  |  |  | 8 | 9 | 17
a | 10 |  |  |  |  | 10
b |  | 3 |  |  |  | 3
c |  |  | 27 |  |  | 27
d |  |  |  | 8 |  | 8
e |  |  |  |  | 9 | 9
Spreadsheet: 794506d1662085154-need-to-create-a-list-based-on-a-value-in-specific-column-tip-worksheeet
Sheet: Data Formatting

[NAME] | Stock | Make | Model | Year | Deal Rating | New Deal Rating | Price | New Price | Price Change | Age | Condition | Condition Identifier | Price [NAME] | DOL Identifier | Identifier Sum
Spreadsheet: 599875d1543343598-summing-numbers-based-on-multiple-conditions-across-a-range-automated-ioc-sheet-desensitized
Sheet: TIA Matrix

[NAME] | # of questions | Team 1 | High Missed | Team 2 | High Missed | Team 3 | High Missed | Team 4 | High Missed | Team 5 | High Missed | Team 6 | High Missed | Team 7 | High Missed
Sickcall and Med Documentation
Infection, Asepsis, & Sterile Techniques |  |  | 1
Medication Administration
Injections
Pharmacology
Venipuncture
EENT Primary Care
Respiratory Primary Care
Abdominal Primary Care
Orthopedic Primary Care
Basic Wound Primary Care
Skin Disease Primary Care
Primary Care Exam | [NAME] | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] | [NAME]
Intro to Battlefield Medicine |  |  |  |  | 1
Battlefield Communication/ Documentation
Casualty Movement
Combat Medical Aid Bag
Combat Casualty Assessment
Control Bleeding
Airway Management
[NAME] Trauma
Shock
Vascular Access
Field Craft Exam | [NAME] | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] | [NAME]
Head Injuries with Traumatic Brain Injuries |  |  |  |  |  |  | 1
Ocular Injuries
Burns
[NAME]
Musculoskeletal Trauma
Field Craft 2 Exam | [NAME] | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] | [NAME]
[NAME] Training |  |  |  |  |  |  |  |  | 1
Casualty Triage
Suicide Prevention
[NAME] and Geneva Conv.
Environmental Threat
Spreadsheet: 546449d1510059114-vlookup-with-random-gaps-in-rows-hard-to-explain-see-attached-sheet-loolup1
Sheet: Sheet1

Part A | Part B | Length | Quantity |  |  |  |  |  | Part A | Part B | Length | Quantity
8 | 9 | 21 | 2 |  |  |  |  |  | 8 | 9 | 21 | 2
9 | 10 | 22 | 1 |  |  |  |  |  | 9 | 10 | 22 | 1
 |  |  |  |  |  |  |  |  | 13 | 14 | 15 | 2
 |  |  |  |  |  |  |  |  | 19 | 20 | 21 | 2
13 | 14 | 15 | 2 |  |  |  |  |  | 20 | 21 | 21 | 4
 |  |  |  |  |  |  |  |  | 21 | 22 | 21 | 1
 |  |  |  |  |  |  |  |  | 22 | 23 | 21 | 2
 |  |  |  |  |  |  |  |  | 29 | 30 | 26 | 3
19 | 20 | 21 | 2 |  |  |  |  |  | 36 | 43 | 27 | 4
20 | 21 | 21 | 4 |  |  |  |  |  | 43 | 44 | 29 | 4
21 | 22 | 21 | 1
22 | 23 | 21 | 2 |  |  |  |  |  | 37 | 38 | 15 | 1
 |  |  |  |  |  |  |  |  | 38 | 39 | 17 | 3
29 | 30 | 26 | 3 |  |  |  |  |  | 66 | 68 | 22 | 1
 |  |  |  |  |  |  |  |  | 68 | 69 | 22 | 1
 |  |  |  |  |  |  |  |  | 69 | 70 | 22 | 2
 |  |  |  |  |  |  |  |  | 71 | 72 | 30 | 4
36 | 43 | 27 | 4
43 | 44 | 29 | 4
37 | 38 | 15 | 1
38 | 39 | 17 | 3
66 | 68 | 22 | 1
68 | 69 | 22 | 1
69 | 70 | 22 | 2
71 | 72 | 30 | 4
Spreadsheet: 872070d1718431352-advanced-sorting-matching-book1
Sheet: Sheet1

a | t | high | low
c | m | low | high
f | g | medium | medium
d | l
g |  |  |  |  |  |  | g
i
h
j
l |  |  |  |  |  |  | l
m |  |  |  |  |  |  | m
n
q
r
v
t |  |  |  |  |  |  | t
Spreadsheet: ea0e1537-7950-4894-a2a8-faf41c263509
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
T4TF | Test | T4TF | T4 (Thyroxine), Total and Free | T4 (Thyroxine), Total and Free | FRT4: Chemiluminometric Immunoassay T4: Immunoenzymatic Assay | Plain, Red-Top Tube: Red |  |  | 1 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 1 mL | 0.6 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | T4 (THYROXINE), TOTAL ONLY > or =12 months: 5.0-12.5 mcg/dL Reference values have not been established for patients that are <12 months of age.  [NAME] (THYROXINE), FREE 0.8-1.8 ng/dL Elevated values are seen in patients on thyroxine therapy. | Monday through Friday, Sunday; 6 a.m.-3 p.m. | 1 day | 2 days |  | Profile |  |  |  |  | Rochester
T4TF | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
T4TF | Component | T4 | T4 (Thyroxine), Total Only, Serum | T4 (Thyroxine), Total Only, S | Immunoenzymatic Assay | Plain, Red-Top Tube: Red Serum Gel Tube: SGT |  |  | 0.6 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.6 mL | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK  Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | > or =12 months: 5.0-12.5 mcg/dL Reference values have not been established for patients that are <12 months of age. | Monday through Friday 5 a.m. - 12 a.m., Saturday 6 a.m. - 6 p.m. | Same day/1 day | 3 days | 1 | 84436 |  |  | Yes | Yes
T4 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
T4 | Result | T4 | T4 (Thyroxine), Total Only, S | T4 (Thyroxine), Total Only, S | Numeric |  |  |  |  | mcg/dL |  |  |  |  |  |  |  |  |  | 3026-2 | Thyroxine:MCnc:Pt:Ser/Plas:Qn:
T4TF | Component | FRT4 | T4 (Thyroxine), Free, Serum | T4 (Thyroxine), Free, S | Chemiluminometric Immunoassay | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 0.3 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | 0.8-1.8 ng/dL Elevated values are seen in patients on thyroxine therapy. | Monday through Friday, Sunday; 6 a.m.-3 p.m. | Same day/1 day | 2 days | 1 | 84439 |  |  | Yes | Yes
FRT4 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
FRT4 | Result | FRT4 | T4 (Thyroxine), Free, S | T4 (Thyroxine), Free, S | Numeric |  |  |  |  | ng/dL |  |  |  |  |  |  |  |  |  | 3024-7 | Thyroxine.free:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 544695d1509005224-target-increase-spreadsheet-example
Sheet: Sheet1

Week No | Sales 2017 | Actual sales 2018 | Running Target | Up / Down
1 | 1000 | 1200
2 | 1200
3 | 1300
4 | 1100
5 | 1200
6 | 1000
7 | 1300
8 | 1500
9 | 2000
10 | 2100
11 | 750
12 | 1000
13 | 200
14 | 1700
15 | 1600
16 | 1300
17 | 1000
18 | 1200
19 | 1300
20 | 1100
21 | 1200
22 | 1000
23 | 1300
24 | 1500
25 | 2000
26 | 2100
27 | 750
28 | 1000
29 | 200
30 | 1700
31 | 1600
32 | 1300
33 | 1000
34 | 1200
35 | 1300
36 | 1100
37 | 1200
38 | 1000
39 | 1300
40 | 1500
41 | 2000
42 | 2100
43 | 750
44 | 1000
45 | 200
46 | 1700
47 | 1600
48 | 1300
49 | 200
50 | 1700
51 | 1600
52 | 1300
Spreadsheet: 152167d1335276586-basic-conditional-formatting-ga-exp-savings-week-of-4-8-11
Sheet: EXP CUSTOMERS

 | [NAME] | VENDOR | PARTS/ EQUIPMENT | BILLS DUE | PARTS                   (Marked up 12%) | LABOR  LOGGED | BALANCE IN  SAVINGS | TRANSFER FROM SAVINGS | BALANCE  AFTER TRANSFER
1 | DAN BEAVER |  |  | TOTALS |  |  | 16000
2 | [NAME] |  |  | TOTALS |  |  | 17.5
3 | KEVIN COZIAK |  |  | TOTALS |  |  | 3200
4 | [NAME] |  |  | TOTALS |  |  | 871.5
5 | WILLIAM DeLACEY |  |  | TOTALS |  |  | 7000
6 | DOC RICKETTS/WILLIAM FORD |  |  | TOTALS |  |  | 0
7 | [NAME] |  |  | TOTALS |  |  | 1000
8 | P. KELLY |  |  | TOTALS |  |  | 37683.28
9 | [NAME] |  |  | TOTALS |  |  | 1000
10 | PETE KLINE |  |  | TOTALS |  |  | 19320.07
11 | [NAME] |  |  | TOTALS |  |  | 722.62
12 | [NAME] MARCUM |  |  | TOTALS |  |  | 6879.85
13 | [NAME] PIERPONT |  |  | TOTALS |  |  | 3489.39
14 | PIZZUTI / AERONATIONAL |  |  | TOTALS |  |  | 17949.73
15 | SKIP POPIAK |  |  | TOTALS |  |  | 3902.87
16 | [NAME] RODGERS |  |  | TOTALS |  |  | 0
17 | ROBERT SCHAEBERLE |  |  | TOTALS |  |  | 0
18 | [NAME] |  |  | TOTALS |  |  | 2373.28
19 | [NAME] |  |  | TOTALS |  |  | 11500
20 | PAULO [NAME] |  |  | TOTALS |  |  | 32070.3
21
Spreadsheet: 704836d1605771500-complicated-look-up-with-spaces-in-search-table-error
Sheet: TR -2 latest

CALC | Legal Entity / Trading Name | Account Number / Site Code | Lease Number / CADD Code | Lease Name | Building / Land | Floor / Parcel | Site Description
 | AIRSERVICES AUSTRALIA | DP60355001 | CV512 | AIRSERVICES MAIN LEASE
 | AIR SERVICES AUSTRALIA | 01-AS-001004 |  |  | RUNWAYS AND TAXIWAYS | ASA FACILITIES | OTHER
 | AIR SERVICES AUSTRALIA | 01-AS-001016 |  |  | RUNWAYS AND TAXIWAYS | ASA FACILITIES | OTHER
 | ASIANA AIRLINES INC | DP914178 | OZ006 | ASIANA AIRLINES LVL3 T1
 | ASIANA AIRLINES | T1-L3-031004 | 3-1004 |  | TERMINAL 1 | LEVEL 3 | OFFICE
 | ASIANA AIRLINES | T1-L3-031004 | 3-1004 |  | TERMINAL 1 | LEVEL 3 | OFFICE
 | ASIANA AIRLINES | T1-L3-031004 | 3-1004 |  | TERMINAL 1 | LEVEL 3 | OFFICE
 | ATTORNEY GENERALS DEPARTMENT | DP100548 | [NAME] | ATTORNEY GENERALS DEPT OFFICES T1
 | ATTORNEY GENERALS DEPT | T1-L1-0B1008 | B1-008 |  | TERMINAL 1 | LEVEL 1 | GOVERNMENT
 | ATTORNEY GENERALS DEPT | T1-L1-0C1002 | C1-002 |  | TERMINAL 1 | LEVEL 1 | OFFICE
 | ATTORNEY GENERALS DEPT | T1-L1-0C1002 | C1-002 |  | TERMINAL 1 | LEVEL 1 | OFFICE
 | ATTORNEY GENERALS DEPT | T1-L1-0C1002 | C1-002 |  | TERMINAL 1 | LEVEL 1 | OFFICE
 | ATTORNEY GENERALS DEPT | T1-M-01M012 | 1M-012 |  | TERMINAL 1 | MEZZANINE | GOVERNMENT
 | GM CABS PTY LIMITED | DP914181 | [NAME] | GM CABS BLDG 246/128 OFFICE L3
 | GM CABS | 10-DO-010048 |  |  | DOMESTIC SPINE | OTHER | CAR PARK
 | GM CABS | 128-1-010071 |  |  | BUILDING 128 | SINGLE LEVEL | OFFICE
 | GM CABS | 246-3-0F3010 |  |  | BUILDING 246 | LEVEL 3 | OFFICE
 | GM CABS PTY LIMITED | DP914181 | GG505 | GM CABS OVERFLOW
 | GM CABS PTY LIMITED | DP914181 | GM504 | GM CABS - FAC OFFICE
 | GM CABS | 10-DO-010048 |  |  | DOMESTIC SPINE | OTHER | CAR PARK
 | GM CABS | 10-DO-010048 |  |  | DOMESTIC SPINE | OTHER | CAR PARK
 | GM CABS | 246-1-0F1006 |  |  | BUILDING 246 | LEVEL 1 | OFFICE
 | GM CABS | 246-1-0F1006 |  |  | BUILDING 246 | LEVEL 1 | OFFICE
 | WALKER MASCOT PTY LTD | DP960605 | WM501 | WALKER  - HANGAR 3
 | WALKER - HANGAR 3 | H3-1-010047 |  |  | HANGAR 3 | ALL LEVELS | OTHER
 | WCC NSW Pty Ltd | DP914338 | EP513 | ENTERPRISE RAC - 2015 CONTRACT
Spreadsheet: 869139d1715781351-x-and-y-axis-choices-results-via-a-drop-down-menu-test_02
Sheet: Sheet1

 |  | Thickness | 6mm | 9mm | 9mm | 9mm | 9mm | 20mm
 | Finish | Size | 2780 x 1200 | 1200 x 1200 | 900 x 900 | 600 x 600 | 300 x 600 | 3200 x 1600
Material 1 | Luc |  | YES | YES | NO | NO | NO | NO
Material 1 | SP |  | NO | NO | NO | NO | NO | NO
Material 1 | Nat |  | YES | NO | NO | NO | NO | YES
Material 1 | Slk |  | YES | NO | NO | NO | NO | NO
Material 2 | Luc |  | YES | NO | NO | NO | NO | NO
Material 2 | SP |  | NO | NO | NO | NO | NO | NO
Material 2 | Nat |  | YES | NO | NO | NO | NO | YES
Material 2 | Slk |  | YES | NO | NO | NO | NO | NO
 |  |  | Material
 |  |  | Finish
 |  |  | Thickness
 |  |  | Size
 |  |  |  | **RESULT**
Spreadsheet: 839376d1691909774-return-different-matches-that-contains-part-of-the-searched-text-excel-formula-help-ans2
Sheet: Sheet1

apple |  | apple1 |  | apple1
melon |  | apple2 |  | melon1
pear |  | [NAME] |  | pear1
apple |  | apple4 |  | apple2
melon |  | apple5 |  | [NAME]
melon |  | pear1 |  | #N/A
melon |  | pear2 |  | #N/A
pear |  | pear3 |  | pear2
apple |  | melon1 |  | [NAME]
 |  | [NAME]
 |  | apple6
 |  | [NAME]
Spreadsheet: 782817d1654284218-updated-splitting-a-lookup-value-among-several-rows-and-conditional-formatting-based-sold-data-example-2
Sheet: AR Query

GD_PRIME | GD_PERIOD_DATE | GD_REFERENCE_2 | GD_REFERENCE_1 | GD_AMOUNT | GD_REFERENCE_3 | GD_POST_DATE | GD_COMMENTS | GD_LEDGER | GD_DESC_CODE | Receivable | [NAME]
11000 | 2022-05-10 00:00:00 | M09426 | 172370 | -5830 | 05102022 | 2022-05-11 00:00:00 | AURORA AUTO WORKS LLC | A/R | P3
11000 | 2022-05-10 00:00:00 | M09465 | 5262 | -15995 | 13598 | 2022-05-11 00:00:00 | PACKAGING PRODUCTS | A/R | P3
11000 | 2022-05-10 00:00:00 | M09546 | 392780 | -106 | VI051022 | 2022-05-11 00:00:00 | FROM ME 2 YOU, LLC | A/R | V3
11000 | 2022-05-10 00:00:00 | M09465 | 5262 | -2500 | 050585MP | 2022-05-11 00:00:00 | PACKAGING PRODUCTS | A/R | WD
11000 | 2022-05-13 00:00:00 | M09539 | 130815 | -2120 | 20829 | 2022-05-16 00:00:00 | EUREKA ROAD FARM MARKET | A/R | P3
11000 | 2022-05-19 00:00:00 | H04434 | 382580 | -66988 | 95113268 | 2022-05-20 00:00:00 | FERROUS PROCESSING & TRADING | A/R | P3
11000 | 2022-05-19 00:00:00 | H04433 | 382580 | -66988 | 95113268 | 2022-05-20 00:00:00 | FERROUS PROCESSING & TRADING | A/R | P3
11000 | 2022-05-19 00:00:00 | [NAME] | 365885 | -10912.7 | 1958553 | 2022-05-20 00:00:00 | PRAIRIE [NAME] DAIRY | A/R | P3
11000 | 2022-05-20 00:00:00 | M09534 | 785880 | -26494.7 | 73020640 | 2022-05-23 00:00:00 | SYNVENTIVE MOLDING SOLUTIONS | A/R | P3
11000 | 2022-05-20 00:00:00 | [NAME] | 365885 | 2697.7 | 051085MP | 2022-05-23 00:00:00 | PRAIRIE [NAME] DAIRY | A/R | WD
11000 | 2022-05-23 00:00:00 | T00272 | 429509 | -14804.49 | 7753 | 2022-05-24 00:00:00 | HEARN INDUSTRIAL | A/R | P3
11000 | 2022-05-24 00:00:00 | M09558 | 829655 | -11995 | 208166 | 2022-05-25 00:00:00 | WASHTENAW INTERMEDIATE | A/R | P3
11000 | 2022-05-24 00:00:00 | H04554 | 6641 | -23850 | 42126 | 2022-05-25 00:00:00 | VALUE WORLD | A/R | P3
11000 | 2022-05-26 00:00:00 | [NAME] | 382440 | -14102.28 | AC052622 | 2022-05-27 00:00:00 | FERNCO - 300234 | A/R | P3
11000 | 2022-05-26 00:00:00 | H04560 | 782330 | -42750 | 302563 | 2022-05-27 00:00:00 | SUPERIOR MATERIALS | A/R | P3
11000 | 2022-05-26 00:00:00 | M09547 | 216890 | -10594.7 | 1035 | 2022-05-27 00:00:00 | BOMBSHELL TRUCKING | A/R | P3
Spreadsheet: 329675d1404381641-counting-no-of-unique-columns-test-of-column-comparison-2
Sheet: Sheet1

Market 1 | Market 2 | Market 3 | Market 4 | Market 5 | Market 6 | Market 7 | Market 8
H1 | H1 | H1 | H1 | H1 | H1 | H1 | H1 | No. Of unique columns
H5 | H5 | H5 | H5 | H5 | H5 | H5 | H5 | 5
I7 | I6 | I7 | I6 | I6 | I7 | I6 | I7
I9 | I7 | I9 | I7 | I7 | I9 | I7 | I9
 | I9 |  | I9 | I9 |  | I9 | K2
 |  |  |  | K2 |  | K2 | K3
 |  |  |  | K3 |  | K3 | K5
 |  |  |  | K6 |  | K5 | K6
 |  |  |  | M7 |  | K6 | M7
 |  |  |  | O1 |  | M7 | O1
 |  |  |  |  |  | O1
Spreadsheet: michelle_lokay__26560__1200ind
Sheet: 1100

 |  | Transwestern  Pipeline  Company |  |  |  |  | 2000-12-01 00:00:00
 |  | Permian Basin Area |  |  | [NAME] |  |  | *N MEX SAN JUAN BASIN
 |  |  |  | DAILY |  |  | DAILY |  |  |  | DAILY | MTD |  | Count
DAY |  | LOW | HIGH | AVG | LOW | HIGH | AVG | LOW | HIGH | DAILY AVG | AVG | AVG |  | Entries
1 |  | 6.18 | 6.24 |  | 6.18 | 6.24 |  | 6.15 | 6.17
2 |  | 6.5 | 6.56 |  | 6.5 | 6.56 |  | 6.38 | 6.4
3 |  | 6.5 | 6.56 |  | 6.5 | 6.56 |  | 6.38 | 6.4
4 | 2.46 | 6.5 | 6.56 |  | 6.5 | 6.56 |  | 6.38 | 6.4
5 |  | 7.18 | 7.37 |  | 7.18 | 7.37 |  | 6.38 | 6.4
6 | 2.56 | 8.22 | 8.29 |  | 8.22 | 8.29 |  | 6.38 | 6.4 |  |  |  |  |  |  |  |  | 49361.37
7 |  | 9.08 | 9.31 |  | 9.08 | 9.31 |  | 6.38 | 6.4 |  |  |  |  |  |  |  |  | -43937.51
8 | 2.3 | 8.3 | 8.45 |  | 8.3 | 8.45 |  | 8.97 | 8.99
9 | 1.75 | 7.47 | 8.09 |  | 7.47 | 8.09 |  | 8.97 | 8.99
10 | 1.57 | 7.47 | 8.09 |  | 7.47 | 8.09 |  | 8.97 | 8.99
11 | 1.72 | 7.47 | 8.09 |  | 7.47 | 8.09 |  | 8.97 | 8.99
12 | 1.72
13
14
15
16
17
18 | 4.82
19 | 1.69
20 | 1.65
21 | 1.65
22 | 1.68
23
24
25 | 2.09
26
27
28
29
30
31
Spreadsheet: louise_kitchen__24242__JulYTD Orig w notes
Sheet: Development

Development
Originator |  | Commodity |  | Team |  | Total |  | %Total
Booth |  | Power |  | Development |  | 6000000
[NAME] |  | Power |  | Development
Mitro |  | Power |  | Development |  | 3350000
Tapscott |  | Power |  | Development |  | 1600000
Total
Spreadsheet: 848843d1699468896-a-cumulative-formula-is-needed-for-tracking-positive-and-negative-times-for-a-flexi-balanc-flexi-tracker-v2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | (hh:[NAME]) | (hh:[NAME]) | (hh:[NAME])
 | Date | IN | Out | IN | OUT | Any breaks | paid business leave | Contracted to work | total worked today | total worked today | Daily credit or debit | expected running flexi balance
Monday |  | 08:28:00 | 11:48:00 | 13:01:00 | 16:19:00 | 00:00:00 | 00:00:00 | 07:00:00 |  |  |  | -1 day, 23:38:00
Tuesday |  | 08:37:00 | 11:53:00 | 13:00:00 | 17:39:00 | 00:00:00 | 00:00:00 | 07:00:00 |  |  |  | 00:33:00
Wednesday |  | 08:57:00 | 11:50:00 | 12:58:00 | 16:00:00 | 00:00:00 | 00:00:00 | 07:00:00 |  |  |  | -1 day, 23:28:00
Thursday |  | 08:50:00 | 11:51:00 | 12:57:00 | 18:37:00 | 00:00:00 | 00:00:00 | 07:00:00 |  |  |  | 01:09:00
Friday |  | 08:54:00 | 11:51:00 | 12:58:00 | 16:03:00 | 00:00:00 | 00:00:00 | 07:00:00 |  |  |  | 00:11:00
Spreadsheet: louise_kitchen__22771__grouphr
Sheet: HR

HR
Rahaim | [NAME] | Comp. Benefits, Payroll, Reporting
Jarrot | [NAME] | Comp. Benefits, Payroll, Reporting
[NAME] | [NAME] | Comp. Benefits, Payroll, Reporting
Philpott | [NAME] | Comp. Benefits, Payroll, Reporting
Davies | [NAME] | Recruiting
Buckley | [NAME] | Recruiting
Curless | Mandy | Recruiting
Yeverino | Norma | Recruiting
Slone | [NAME] | Generalists
Fitzpatrick | [NAME] | Generalists
Cashion | Tana | Generalists
[NAME] | [NAME] | Generalists
[NAME] | S. | Generalists
Labbe | A. | Generalists
Doucet | Dawn | Calgary
Kearney | Julie | Portland
Cash | Michelle
[NAME] | [NAME]
Clyatt | Julie
Spreadsheet: 126486d1319721053-how-do-i-display-the-name-of-an-occassion-between-two-dates-part-of-formula-include-special-days
Sheet: Date

From | To |  | Special Day:
2011-10-31 00:00:00 | 2011-11-04 00:00:00
2011-11-07 00:00:00 | 2011-11-11 00:00:00
2011-11-14 00:00:00 | 2011-11-18 00:00:00 |  | Holiday
2011-11-21 00:00:00 | 2011-11-25 00:00:00 |  | Holiday
2011-11-28 00:00:00 | 2011-12-02 00:00:00
2011-12-05 00:00:00 | 2011-12-09 00:00:00 |  | Anniversary
2011-12-12 00:00:00 | 2011-12-16 00:00:00
Spreadsheet: 701424d1603754951-vlookup-not-returning-desired-value-from-another-sheet-based-on-multiple-criteria-client-outreach-individual-draft-michelle
Sheet: SA

 | DATE | CLIENT | TASK | DATE | SA NOTES | Y WHEN COMPLETED | RESULT
 |  |  |  |  | BUSINESS CARD
 |  |  |  |  | BUSINESS CARD
 |  |  |  |  | BUSINESS CARD
 |  |  |  |  | BUSINESS CARD
 |  |  |  |  | BUSINESS CARD
 |  |  |  |  | MENTION POA, WE, GC FOR NEXT YEAR
 |  |  |  |  | EMAILED
 |  |  |  |  | MAILED
 |  |  |  |  | EMAILED
 |  |  |  |  | MAILED
Spreadsheet: 664986d1582854253-cost-based-on-day-of-week-green-forum
Sheet: APRIL

Grean Clean Clean Record |  |  |  |  |  |  |  |  |  |  |  | First Day of Month | 2020-04-01 00:00:00
Date |  |  |  |  |  |  |  |  |  |  |  | Total | Savings
TOTALS
Spreadsheet: 854843d1704605970-lookup-and-find-the-in-between-days-and-return-number-of-days-20240105
Sheet: Sheet1

 |  | ID Number | Date From | Date To | Num Of Days | Days I Get | Actual Days Should Be
 |  | 26827 | 2020-06-01 00:00:00 |  |  |  | 302 | Cell D2 is without [NAME]
 |  | 26827
 |  | 26827
 |  | 26827
 |  | 26827
 |  | 26827
 |  | 26827
 |  | 30617 | 2021-10-03 00:00:00 |  |  |  | 195 | Cell D9 is without [NAME]
 |  | 30617
 |  | 30617
 |  | 30617
 |  | 30706 | 2021-09-27 00:00:00 |  |  |  | 253 | Cell D13 is without [NAME]
 |  | 30706
 |  | 30706
Spreadsheet: 267978d1380323719-having-trouble-with-vlookup-hlookup-francisco
Sheet: Stats-April 7-11

Customers and Revenue by Day |  |  |  | Revenue by [NAME]
 | Customers | Revenue |  | [NAME] | Revenue
Sunday |  |  |  | Small
Monday |  |  |  | Medium
Tuesday |  |  |  | Large
Wednesday |  |  |  | Commercial
Thursday |  |  |  | Total
Friday
Saturday
Totals
Anticipated Monthly Revenue:
(Based on a 4 week month)
Spreadsheet: 700026d1602907545-help-with-combining-the-if-iserror-find-functions-together-book1-5-
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  | Title | % student
 |  |  |  |  |  |  |  |  |  | Instructor |  |  |  |  |  |  | =FIND("student",K2)-1,IF("student",1,0)
 |  |  |  |  |  |  |  |  |  | Freshman student
 |  |  |  |  |  |  |  |  |  | Program Aide
 |  |  |  |  |  |  |  |  |  | ABC student
 |  |  |  |  |  |  |  |  |  | Elementary student
 |  |  |  |  |  |  |  |  |  | Custodian
 |  |  |  |  |  |  |  |  |  | Principal
 |  |  |  |  |  |  |  |  |  | Elementary student
 |  |  |  |  |  |  |  |  | one single formula without column L