tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 794013d1661852522-sum-cells-in-a-row-containing-0-then-stop-after-summing-52-cells-0-test-workbook
Sheet: Master

 | 2023 - 1st Quarter |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023 - 2nd Quarter |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023 - 2nd Quarter |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023 - 4th Quarter
 | Week 1 |  | Week 2 |  | Week 3 |  | Week 4 |  | Week 5 |  | Week 6 |  | Week 7 |  | Week 8 |  | Week 9 |  | Week 10 |  | Week 11 |  | Week 12 |  | Week 13 |  |  | week 14 |  | week 15 |  | week 16 |  | week 17 |  | week 18 |  | week 19 |  | week 20 |  | week 21 |  | week 22 |  | week 23 |  | week 24 |  | week 25 |  | week 26 |  |  | Week 27 |  | Week 28 |  | Week 29 |  | Week 30 |  | Week 31 |  | Week 32 |  | Week 33 |  | Week 34 |  | Week 35 |  | Week 36 |  | Week 37 |  | Week 38 |  | Week 39 |  |  | Week 40 |  | Week 41 |  | Week 42 |  | Week 43 |  | Week 44 |  | Week 45 |  | Week 46 |  | Week 47 |  | Week 48 |  | Week 49 |  | Week 50 |  | Week 51 |  | Week 52
 | 2022-01-03 00:00:00
Hours Worked | 2 |  | 2 |  | 0 |  | 2 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | 4 |  | 0 |  | 0 |  | 0 |  | 0 |  | 12 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 11 |  | 0 |  |  | 0 |  | 14 |  | 12 |  | 15 |  | 0 |  | 11 |  | 0 |  | 13 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | 22 |  | 0 |  | 19.5 |  | 0 |  | 0 |  | 16.5 |  | 0 |  | 12 |  | 0 |  | 0 |  | 14 |  | 0 |  | 15
Gross Pay
Holiday  Hours Taken | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Holiday Pay
Total Pay
[NAME] | 10
Spreadsheet: 17e95948-b4f1-4ae9-916d-1d84d8cce06a
Sheet: Subject Totals

MSJC Dual Total by Subject | Withdraw Rate
[To view course data click on Subject Name below] | AY11-12 |  |  | AY12-13
Subject | SU11 | FA11 | SP12 | SU12 | FA12 | SP13
American Sign Language |  |  |  |  | 0.04166666666666666 | 0
Business Administration |  |  |  |  |  | 0
Biology |  |  |  |  |  | 0
English |  | 0.03448275862068965 | 0.008928571428571428 |  | 0.03 | 0.046875
Environment Science |  |  |  |  | 0
Guidance |  |  |  |  | 0
History |  | 0.03846153846153846 | 0.04 |  | 0.01587301587301587 | 0.01587301587301587
Health Science |  |  |  |  | 0 | 0.09523809523809523
Mathematics |  | 0.05911330049261083 | 0.0223463687150838 |  | 0.0273972602739726 | 0.03819444444444445
Multimedia |  |  |  |  | 0 | 0
Music |  |  |  |  | 0.06666666666666667 | 0
Political Science |  |  |  |  | 0
Psychology |  | 0 | 0.125 |  | 0.02631578947368421 | 0.04
Spanish |  | 0.02105263157894737 | 0.0108695652173913 |  | 0 | 0
Term Dual Enrollment Average Withdraw Rate |  | 0.03257328990228013 | 0.01863354037267081 |  | 0.0227 | 0.0274
AY Dual Enrollment Average Withdraw Rate
Withdraw rate = # of “W” grades divided by (the # of all grades) “A, B, C, CR, P, D, F, NC, NP, I and W”
Spreadsheet: 487808d1478264438-auto-populate-weekdays-and-dates-in-the-specific-cells-workbook
Sheet: Sheet1

Month: October 2016
Monthly Report
Total Buses |  |  |  | Total Spare Buses |  |  | Total Buses |  | Work Days Current Month
 |  |  |  |  |  |  |  |  | 22
Date | WeekDay | Heading Sample |  |  |  |  | # | # | total | #
 |  | A | B | C | D | Total
1 | A
2 | B
3 | C
4 | D
5 | E
6 | F
7 | G
8 | A
9 | B
10 | C
11 | D
12 | E
13 | F
14 | G
15 | A
16 | B
17 | C
18 | D
19 | E
20 | F
21 | G
22 | A
23 | B
24 | C
25 | D
26 | E
27 | F
28 | G
29 | A
30 | B
31 | C
##
####
Spreadsheet: 748752d1632323639-if-formula-showing-as-incorrect-when-it-is-correct-account
Sheet: Track

Date | Reference | Category | Amount | Income | Expenditure
2021-01-18 00:00:00 |  | track | -63.75
2021-01-18 00:00:00 |  | track | -63.75
2021-03-08 00:00:00 |  | track | 14
2021-04-16 00:00:00 |  | track | 78
2021-05-11 00:00:00 |  | track | 71
2021-06-01 00:00:00 |  | track | -191.25
2021-06-08 00:00:00 |  | track | 73.7
2021-06-21 00:00:00 |  | track | -127.5
2021-07-07 00:00:00 |  | track | -127.5
2021-08-03 00:00:00 |  | track | 32
2021-08-09 00:00:00 |  | track | -127.5
2021-08-17 00:00:00 |  | track | 137.2
2021-09-08 00:00:00 |  | track | -127.5
Spreadsheet: 865154d1712206908-formula-that-will-pick-up-a-change-only-for-that-row-test3-ans
Sheet: Current

 | Manual Entry |  | uses lookups |  | Assigns the Zone value in column D to each room that belongs to the same zone | Concats with column J to form column I. Needed this to be able to create a unique instance in case I had rooms with identical names |  | Concatenated result. | uses lookups
 |  | Contains formulas | Contains formulas |  | Contains formulas | Contains formulas | Contains formulas | Contains formulas | Contains formulas
 | Number | Autofill | Layout |  | Helper Column | Helper Column | Helper Column | Helper Column | Rooms
 | ABC-DD- | Tag | Zone |  | 1 | 2 | 3 | 4
Group | 1 |  | A1 |  |  |  |  |  | Restroom 1
Group | 2 |  | A3 |  |  |  |  |  | Bed 1
Group | 3 |  | A9 |  |  |  |  |  | Bed 1
 |  |  |  |  |  |  |  |  | Bed 2
 |  |  |  |  |  |  |  |  | Bed 3
 |  |  |  |  |  |  |  |  | Bed 3
Group | 8 |  | A6 |  |  |  |  |  | Kitchen
 |  |  |  |  |  |  |  |  | Dining
Group | 5 |  | A4 |  |  |  |  |  | Living 1
Group | 6 |  | A2 |  |  |  |  |  | Study
 |  |  |  |  |  |  |  |  | Lounge
 |  |  |  |  |  |  |  |  | Powder
 |  |  |  |  |  |  |  |  | Study 2
 |  |  |  |  |  |  | Final result
Spreadsheet: 771655d1646771932-max-quartile-ifs-multiple-criteria-ef-help
Sheet: Sheet1

 |  |  | Select Roles to Include: |  |  | Include Employee? | Employee | Role | Sales |  | [NAME]
 |  |  | SM1 | Yes |  | Yes | Team Member 1 | SM1 | 500 |  | 75th Quartile
 |  |  | SM2 | Yes |  | Yes | Team Member 2 | SM2 | 200 |  | 50th Quartile
 |  |  | SM3 | Yes |  | Yes | Team Member 3 | SM1 | 300 |  | 25th Quartile
 |  |  | SM4 | Yes |  | Yes | Team Member 4 | SM5 | 400 |  | Min Value
 |  |  | SM5 | Yes |  | Yes | Team Member 5 | SM3 | 200
 |  |  | NSM | Yes |  | Yes | Team Member 6 | SM5 | 100
 |  | >>blank |  | Yes |  | Yes | Team Member 7 | SM4 | 432
 |  |  |  |  |  | Yes | Team Member 8 | SM2 | 24
 |  |  |  |  |  | Yes | Team Member 9 | SM1 | 553
 |  |  |  |  |  | Yes | Team Member 10 | SM4 | 9329
 |  |  |  |  |  | Yes | Team Member 11 | SM2 | 43
 |  |  |  |  |  | Yes | Team Member 12 | SM4 | 234
 |  |  |  |  |  | Yes | Team Member 13 | SM3 | 2343
 |  |  |  |  |  | Yes | Team Member 14 | SM5 | 2
 |  |  |  |  |  | Yes | Team Member 15 | NSM | 2434
 |  |  |  |  |  | Yes | Team Member 16 |  | 434
 |  |  |  |  |  | Yes | Team Member 17 | SM2 | 525
 |  |  |  |  |  | Yes | Team Member 18 | SM3 | 62
 |  |  |  |  |  | Yes | Team Member 19 |  | 562
 |  |  |  |  |  | Yes | Team Member 20 | NSM | 2
 |  |  |  |  |  | Yes | Team Member 21 | NSM | 546
 |  |  |  |  |  | Yes | Team Member 22 | SM1 | 456
 |  |  |  |  |  | Yes | Team Member 23 | SM5 | 2452
 |  |  |  |  |  | Yes | Team Member 24 |  | 2456
 |  |  |  |  |  | Yes | Team Member 25 | SM3 | 7575
 |  |  |  |  |  | Yes | Team Member 26 | SM2 | 756
 |  |  |  |  |  | Yes | Team Member 27 | SM5 | 6452
 |  |  |  |  |  | Yes | Team Member 28 | SM1 | 65
 |  |  |  |  |  | Yes | Team Member 29 | SM1 | 654
 |  |  |  |  |  | Yes | Team Member 30 | SM4 | 4562
 |  |  |  |  |  | Yes | Team Member 31 | SM2 | 7766
 |  |  |  |  |  | Yes | Team Member 32 | NSM | 7567
 |  |  |  |  |  | Yes | Team Member 33 |  | 3
 |  |  |  |  |  | Yes | Team Member 34 |  | 35
 |  |  |  |  |  | Yes | Team Member 35 | SM3 | 567
 |  |  |  |  |  | Yes | Team Member 36 | SM2 | 3563
 |  |  |  |  |  | Yes | Team Member 37 | SM1 | 34
 |  |  |  |  |  | Yes | Team Member 38 | SM4 | 545
 |  |  |  |  |  | Yes | Team Member 39 |  | 5453
 |  |  |  |  |  | Yes | Team Member 40 | NSM | 34
 |  |  |  |  |  | x
Spreadsheet: 04659957-8f7d-45eb-8053-bfecc4508e50
Sheet: Sheet1

Season Schedule | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Date | Game Number | Visiting Team | Visiting Score | Home Team | Home Score | Game Time/Status | Venue
2013-04-27 | 1 | Rochester | 3 | Toronto | 6 | Final | Ricoh Coliseum Toronto, ON
2013-04-28 | 2 | Rochester | 0 | Toronto | 2 | Final | Ricoh Coliseum Toronto, ON
2013-05-01 | 3 | Toronto | 3 | Rochester | 2 | Final OT | Blue Cross [NAME], NY
Spreadsheet: 871200d1717593982-show-chart-based-on-a-cell-value-indirect-formula-sample
Sheet: 17-21 June

Description | Goal | Actual | Maintenance |  |  | Date | Incident | Reason | *RCA/5-WHY* |  | Personnel
[NAME] | >80% | 0.83 |  |  |  |  |  |  | Break ins Hi do to DT down day worked
Vibration Route | 1 | 1
Oil Analysis Route | 1 | 1
Lube Grease Route | 1 | 1
PM Executed On Time | >95% | 0.97
PM/PD Follow Up 100 Days | >85% | 0.85 | HTH | KVI
Break Ins | 5 |  | 5 | 4
Break-In W/O % | <20% | 0.2 |  |  |  | Date | Weekly Recognition
Break-In W/O HR'S | 5 |  | 3 | 4 |  | 2024-02-15 00:00:00 | [NAME] vector & hot fan
EDT | 0.02 | 0.05
RSCH WO | 5 |  | 4 | 4
Hourly KPI's | >60% |  | 0.04 | 0.04
Number of Call Ins | 2 |  | 4 | 4
Planner KPI | >60% | 0.61
Warehouse KPI
#Stock Out Parts | >60% | 0.75
Safety Audits | 4 |  | 2 | 4
DENT | Equipment | Corrective Action |  |  |  |  |  | Due Date
Spreadsheet: 597532fe-c256-4fd6-b0f2-8c9b00f8c8a9
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | Housing Opportunity Index: 2nd Quarter 2014
 |  | Areas with Population of 500,000 or more in 2013
 |  | 10 Most Affordable Metro Areas |  |  |  | 10 Least Affordable Metro Areas
 | 1 | Youngstown-Warren-Boardman, OH-PA |  |  | 1 | San Francisco-San Mateo-Redwood City, CA ^^^
 | 2 | Indianapolis-Carmel, IN |  |  | 2 | Santa Ana-Anaheim-Irvine, CA ^^^
 | 3 | Syracuse, NY |  |  | 3 | Los Angeles-Long Beach-Glendale, CA ^^^
 | 4 | Harrisburg-Carlisle, PA |  |  | 4 | San Jose-Sunnyvale-Santa Clara, CA
 | 5 | Scranton--Wilkes-Barre, PA |  |  | 5 | New York-White Plains-Wayne, NY-NJ ^^^
 | 6 | Dayton, OH |  |  | 6 | San Diego-Carlsbad-San Marcos, CA
 | 7 | Grand Rapids-Wyoming, MI |  |  | 7 | Oakland-Fremont-Hayward, CA ^^^
 | 8 | Toledo, OH |  |  | 8 | Oxnard-Thousand Oaks-Ventura, CA
 | 8 | Lakeland-Winter Haven, FL |  |  | 9 | Honolulu, HI
 | 10 | Wichita, KS |  |  | 10 | Bridgeport-Stamford-Norwalk, CT
 |  | Areas with Population under 500,000 in 2013
 |  | 10 Most Affordable Metro Areas |  |  |  | 10 Least Affordable Metro Areas
 | 1 | Cumberland, MD-WV |  |  | 1 | Santa Cruz-Watsonville, CA
 | 2 | Kokomo, IN |  |  | 2 | Napa, CA
 | 3 | Davenport-Moline-Rock Island, IA-IL |  |  | 3 | Salinas, CA
 | 4 | [NAME], MI |  |  | 4 | [NAME], CA
 | 5 | Lima, OH |  |  | 5 | [NAME], CA
 | 6 | Springfield, OH |  |  | 6 | Santa Barbara-Santa Maria-Goleta, CA
 | 7 | Wheeling, WV-OH |  |  | 7 | Ocean City, NJ
 | 8 | Pueblo, CO |  |  | 8 | Laredo, TX
 | 9 | Elmira, NY |  |  | 9 | Barnstable Town, MA
 | 9 | Mansfield, OH |  |  | 10 | [NAME], OR
 |  | Sales Transaction Data:  Core Logic
 |  | Interest Rates: Federal Housing Finance Agency
 |  | Median Household Income: Housing & Urban Development Department (HUD)
 |  | Property Taxes & Insurance:  Bureau of the Census
 |  | Population:  Bureau of the Census
 |  | ^^^  Indicate Metropolitan Divisions.  All others are Metropolitan Statistical Areas.
Spreadsheet: 153342d1335878922-calculation-of-text-and-numbers-claims
Sheet: EL

Policy Year | Wages | Settled Claims (see notes 1&3) |  | Outstanding Claims (see notes 2&3)
 | £ | No | Amount £ | No | Amount £
 |  | 0 | Nil | 0 | Nil
 |  | 0 | Nil | 0 | Nil
 |  | 0 | Nil | 0 | Nil
 |  | 0 | Nil | 0 | Nil
 | Not Insured
Notes:
1 | Claims terminated 'nil payment' are excluded
2 | Estimates are included only for accidents or diseases where a reserve has been created,
Spreadsheet: 1bc7cb44-a2bc-44fe-abe3-a4e6300003f0
Sheet: Sheet1

APPLICATION AND CERTIFICATE FOR PAYMENT | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Project Address: |  | Project Address |  |  |  | Building Permit Number: |  | #
Owner: |  | Developer Name |  |  |  | Application Number: |  | #
Contractor: |  | [NAME] |  |  |  | Date: |  | 00/00/13
Construction Manager: |  | Construction Manager Name |  |  |  | Construction Period |  | From/To: | 00/00/13-00/00/13
CONTRACTOR’S APPLICATION FOR PAYMENT
 | 1.  Original Contract Sum |  |  |  |  |  | 0
 | 2.  Net Change from authorized [NAME]. |  |  |  |  |  | 0
 | 3.  Adjusted Contract Sum with Change Orders (Line 1 plus Line 2) |  |  |  |  |  | 0
 | 4.  Total Completed to Date (incl. this application, Col. D+E on Continuation Sheet) |  |  |  |  |  | 0
 | 5.  Retainage |  |  |  |  |  | 0
 | 6.  Total Completed Less Retainage (Line 4 less Line 5) |  |  |  |  |  | 0
 | 7.  Less Previous Applications for Payment (Line 6 from prior certificate)
 | 8.  Current Payment Due (Line 6 less line 7) |  |  |  |  |  | 0
 | 9.  Balance to Finish, Including Retainage (Line 3 less Line 6) |  |  |  |  |  | 0
REQUIRED ATTACHMENTS TO APPLICATION: |  |  |  |  |  | CHANGE ORDER SUMMARY
 |  |  |  |  |  | CO #1
 | Lien Waivers & Material Receipts |  |  |  |  | CO #2
 |  |  |  |  |  | CO #3
 | Minority Employment Utilization (MEU) Report |  |  |  |  | CO #4
 |  |  |  |  |  | CO #5
 | Current/Updated ID of Prime & Subcontractor Form |  |  |  |  | CO #
 |  |  |  |  |  | CO #
SPECIAL INSTRUCTIONS (Attach additional page if needed) |  |  |  |  |  | CO #
 |  |  |  |  |  | CO #
 |  |  | AMOUNT TO DISBURSE TO CONTRACTOR | 0 |  | CO #
 |  |  | AMOUNT TO SUBCONTRACTOR, <sub name here> | 0 |  | CO #
 |  |  | ESCROW AMOUNT | 0
 |  |  | TOTAL | 0 |  | Total Sum to Date |  | 0
The undersigned Contractor certifies that the Continuation Sheet of this Application and Certificate for Payment contains names of all parties having contracts or subcontracts for specific portions of the work on said property and building or material entering into the construction thereof, and the amounts already paid thereto, that the items mentioned include all labor and material required to complete said building according to the plans and specifications; that there are no other contracts outstanding; and that there is nothing due or to become due to any person for material, labor, or other work of any kind done upon said building other than as stated.
 |  |  |  |  | Date:
Contractor
OWNER’S AND CONSTRUCTION MANAGER’S CERTIFICATE FOR PAYMENT
Based on on-site observations and the information on this pay application, the Owner and CDC Housing Agent certify to the Housing and Redevelopment Authority of the City of St. Paul and the City of Saint Paul that to the best of the Owner’s and CDC Housing Agent's knowledge, the Work has progressed as indicated, the quality of Work is in accordance with the Contract Documents and the Contractor is entitled to payment of the amount certified below.
By: |  |  |  |  | Date:
 | Owner
By: |  |  |  |  | Date:
 | Construction Manager
Spreadsheet: 13c3c679-8719-4acd-8655-2f1b642f2aa1
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
8927 | 68687 | Sirje | Lepik | EST | 273 | 00:19:26 | 00:00:40 | 00:30:45 | 00:01:27 | 00:22:04 | 1 | 01:14:23
8927 | 68688 | [NAME] | Lang | EST | 272 | [NAME] | 00:00:43 | 00:32:57 | 00:00:47 | 00:22:49 | 2 | 01:16:44
8927 | 68689 | Liisa-Lotta | Veikner | EST | 274 | 00:19:27 | 00:00:41 | 00:38:23 | 00:01:07 | 00:22:53 | 3 | 01:22:32
Spreadsheet: 857047d1706129979-help-using-a-lookup-function-with-mutiple-criteria-job-schedule-dataset-ws-pq-solution
Sheet: Sheet4

 |  |  |  | Job # | Bay # | Phase 60 | Phase 65 | Phase 70 | Phase 80 | Phase 90 |  | Bay # | Date
 |  |  |  | 8000 | 25 | 2023-01-31 00:00:00 | 2023-02-02 00:00:00 | 2023-02-12 00:00:00 | 2023-02-28 00:00:00 | 2023-03-14 00:00:00 |  | 25 | 2023-01-31 00:00:00
 |  |  |  | 7999 | 24
 |  |  |  | 7998 | 5
 |  |  |  | 7997 | 4 |  |  |  |  |  |  | Job # | Bay # | Attribute | Value
 |  |  |  | 7996 | 3 |  |  |  |  |  |  | 8000 | 25 | Phase 60 | 2023-01-31 00:00:00
Spreadsheet: 151549d1334961266-excel-2007-offset-formula-offset-problem
Sheet: Sheet1

2 | B | C | D | E | F | G | H | I | J
2
3
4
5
6
7
8
9
Spreadsheet: 787115d1657637059-if-cell-content-equals-content-of-address-in-another-cell-return-x-dummy-data
Sheet: Sheet1

event id | id site
1 | a100
2 | [NAME]
3 | a102
4 | a103
5 | a104
6 | a105
7 | a106
8 | a107
9 | a108
10 | a109
11 | a110
12 | a111
13 | a112
14 | a113
15 | a114
16 | [NAME]
17 | a116
18 | a117
19 | a118
20 | a119
Spreadsheet: louise_kitchen__24099__Non Commercial
Sheet: Sheet1

CANADA - Non-Commercial
 | Risk | Documentation | Volume Mgmt | Logistics | [NAME] | IT | HR | Accounting | Gov Affairs | Legal | [NAME] | Credit | Toronto | Totals | % Totals
1 | [NAME] | Seib | Punja | Prior |  | Rondeau |  | Scott |  | Keohane | [NAME] |  | Marryott
 | Reeves | [NAME] |  | Ripley |  | Martin |  | Dawes |  | Johnston | O'Neil |  | [NAME]
 | Bardel | Moscoso |  | Tackney |  | [NAME] |  | Hanslip |  | [NAME] | McCullough
 | Unger | Liknes |  | [NAME] |  |  |  | Donlevy-Lee/Panchuk |  |  | Crawford
 | Luc |  |  |  |  |  |  | Quon
 |  |  |  |  |  |  |  | [NAME]
2 | [NAME] | [NAME] | Dupuy | Heal | Koulikov |  | Doucet | Ta | [NAME] |  | McIsaac | Otto | Crouch
 | Cooper | Pernul | [NAME] | Webner | Wiebe |  | [NAME] | [NAME] | Stubbings |  | Gawiuk |  | [NAME]
 |  | Boulanger |  | Nicholson | McKeel |  |  | Jessop |  |  | Scott |  | [NAME]
 |  |  |  | Langfeldt |  |  |  | [NAME] |  |  |  |  | Hanley
 |  |  |  |  |  |  |  |  |  |  |  |  | Rojo
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | Chaudhry
3 | Rogers | Dey |  | Herring | Bingham | Maskwa | Wells | Lawrick | [NAME] | [NAME] | [NAME] |  | Tong
 | Rennebeerg | [NAME] |  |  | [NAME] | [NAME] |  | Vallejo |  | Sietzema
 | Rothtock | Gilkes |  |  |  |  |  | Morgan
 |  | Machado
 |  | [NAME]
Spreadsheet: 834561d1687899314-countifs-gets-wrong-results-sample
Sheet: Sheet1

Name | Error? |  | Name | Error Found
[NAME] |  |  | [NAME]
[NAME] |  |  | [NAME]
[NAME] |  |  | [NAME]
[NAME] |  |  | [NAME] | Yes
[NAME] |  |  | [NAME]
[NAME]
Spreadsheet: 216915d1361919541-sum-if-array-formula-book1
Sheet: AP

 | Simplified Claims Payables Projection
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WE/hol | DoW |  | 0 | 1 | 2 | 3 | 4 | 5 | 6 | WE/hol |  | 0 | 1 | 2 | 3 | 4 | 5 | 6 | WE/hol
..
.. |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  | X
..
..
.. |  |  |  |  |  |  |  |  |  |  | _
.. |  |  |  |  |  |  |  |  |  |  | _
.. |  |  |  |  |  |  |  |  |  |  | _
.. |  |  |  |  |  |  |  |  |  |  | _
.. |  |  |  |  |  |  |  |  |  |  | _
 |  |  |  |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | text paste preview value:
 |  |  |  | Total invoices selected for payment here:
Spreadsheet: 61846d1262766677-sumproduct-formula-pack-usage
Sheet: Master

101734 | ARGX17L | ARGX17LN | ARGX21H | ARGX21HN | ARGX21L | ARGX21LN | ULP14L | ULP17L | [NAME] | ULP21L | ULX17H | ULX19H | ULX21H | HHGP24S | HHGP21L | HHGX21H | HHGP21H
102056 | [NAME] | [NAME] | [NAME] | ULP17H/1K | ULP17L/1K | ULP21H/1K | ULP21H/1K HF | ULP21L/1K | ULX19H/1K | ULX21H/1K | ULX21H/1K HF | HHGX21H/1K
102057 | ULP14L
5000384 | [NAME] | ARGX17L | ARGX17LN | ARGX21H | [NAME] | ARGX21HN | [NAME] | ARGX21L | ARGX21LN | ULP14L | ULP17H/1K | ULP17L | ULP17L/1K | ULP21H | ULP21H/1K | ULP21H/1K HF | ULP21L | ULP21L/1K | ULX17H | ULX19H | ULX19H/1K | ULX21H | ULX21H/1K | ULX21H/1K HF
5307311 | HHNX21H/1K DC | HHNX21H DC
5309309 | BCX21H | BCX21HN | BCX15H | SVNX15H | SVNX21H | HHNX21H | HHNX13H | HHNP24S | HHNP21L | HHNX19H | HHNBP
8394189 | TCX21H HF | TCX21H/1K HF | ULP21H/1K HF | ULX21H/1K HF
1N50140501 | HHGP24S | HHNP24S
1N50405801 | [NAME] | [NAME] | ULP17L | ULP17L/1K
1N50415801 | TCP21L | TCP21L S | TCP21L/1K | ULP21L | ULP21L/1K | HHGP21L | HHNP21L
1N50430801 | ULP17H/1K
1N50435801 | ULP21H | ULP21H/1K | ULP21H/1K HF | HHGP21H
207275G | ARGX17LN | ARGX21HN | [NAME] | ARGX21LN | BCX21HN
500000A | TCBP/1K | TCP21L/1K | TCX21H/1K | TCX21H/1K HF | HHNX21H/1K DC
500750A | BCX21H | BCX21HN | BCX15H | SVNX15H | SVNX21H | TCBP | [NAME] | TCP21L | TCX13H | TCX19H | TCX21H | TCX21H HF | [NAME] | TCP21L S | HHNX21H | HHNX13H | HHNP24S | HHNP21L | HHNX21H DC | HHNX19H | HHNBP
6084AF | DP001
AV05JAB | SVNX15H | SVNX21H | HHNX21H | HHNX21H/1K DC | HHNX13H | HHNP24S | HHNP21L | HHNX21H DC | HHNX19H | HHNBP
AV05JASNB
BD300910 | DP001
BD300912 | DP001
BD304432 | DP001
BL110SN | [NAME] | TCP21L S
BL200B | TCX21H HF | TCX21H/1K HF | ULP21H/1K HF | ULX21H/1K HF
BL225 | [NAME] | ARGX17L | ARGX17LN | ARGX21H | [NAME] | ARGX21HN | [NAME] | ARGX21L | ARGX21LN | TCBP | TCBP/1K | [NAME] | TCP21L | TCP21L/1K | TCX13H | TCX19H | TCX21H | TCX21H/1K | ULP14L | ULP17H/1K | ULP17L | ULP17L/1K | ULP21H | ULP21H/1K | ULP21L | ULP21L/1K | ULX17H | ULX19H | ULX19H/1K | ULX21H | ULX21H/1K | HHGP24S | HHGP21L | HHGX21H | HHGX21H/1K | HHGP21H
EMC3320M | BCX21H | BCX21HN | BCX15H | [NAME] | TCP21L S | HHNX21H | HHNX21H/1K DC | HHNX13H | HHP24S | HHNP21L | HHNX21H DC | HHNX19H | HHNBP
K402 | BCX21H | BCX21HN | BCX15H | [NAME] | TCP21L S | HHNX21H | HHNX21H/1K DC | HHNX13H | HHP24S | HHNP21L | HHNX21H DC | HHNX19H | HHNBP
K405 | BCX21H | BCX21HN | BCX15H | SVNX15H | SVNX21H | HHNX21H | HHNX21H/1K DC | HHNX13H | HHP24S | HHNP21L | HHNX21H DC | HHNX19H | HHNBP
R5M3303G | BCX21H | BCX21HN | BCX15H
[NAME] | TCX13H | HHNX13H
[NAME] | [NAME] | BCX21HN | SVNX15H
R5M6403 | ULX17H
R5M6404 | TCX19H | ULX19H | ULX19H/1K | HHNX19H
R5M6405 | ARGX21H | [NAME] | ARGX21HN | [NAME] | BCX21H | BCX21HN | SVNX21H | TCX21H | TCX21H/1K | TCX21H HF | TCX21H/1K HF | ULX21H | ULX21H/1K | ULX21H/1K HF | HHNX21H | HHNX21H/1K DC | HHGX21H | HHGX21H/1K | HHNX21H DC
R5M6409LF | ARGX17L | ARGX17LN
R5M6411LF | ARGX21L | ARGX21LN
Spreadsheet: 778585d1651161121-excel-solver-to-change-net-margin-in-column-c-without-changing-values-in-column-b-excel-solver
Sheet: Sheet1

Revenue
Sales | 10000
Incentives | -200 |  |  | MIN | MAX |  | Using [NAME]
Revenue Contingecy |  |  |  | -478 | -466
Tax Offset | -1200
Total Revenue
Expense
Sales Expense | 959
Marketing Expense | 1500
G&A Expense | 2152
Cost Contingency
Total Expense
 |  |  |  | Objective Net Margin
Net Margin |  |  |  | 0.4
Spreadsheet: 866195d1713171737-excel-formula-to-find-out-what-workday-of-a-month-is-a-particular-date-sample
Sheet: Sheet1

 |  | Date | What working day of the month |  |  |  |  | Holidays 2024
 |  | 2024-01-02 00:00:00 | 1 |  |  |  |  | 2024-01-01 00:00:00
 |  | 2024-01-15 00:00:00 | 10 |  |  |  |  | 2024-03-29 00:00:00
 |  | 2024-01-19 00:00:00 | 14 |  |  |  |  | 2024-04-01 00:00:00
 |  | 2024-01-23 00:00:00 | 16 |  |  |  |  | 2024-05-06 00:00:00
 |  | 2024-02-01 00:00:00 | 1 |  |  |  |  | 2024-05-27 00:00:00
 |  | 2024-02-14 00:00:00 | 10 |  |  |  |  | 2024-08-26 00:00:00
 |  | 2024-02-15 00:00:00 | 11 |  |  |  |  | 2024-12-25 00:00:00
 |  |  |  |  |  |  |  | 2024-12-26 00:00:00