tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 82388e58-68eb-417c-a244-3db163f0074f
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
FAPKM | Test | FAPKM | Familial Adenomatous Polyposis (FAP) Known Mutation | FAP Known Mutation | DNA Sequencing or Dosage Analysis by [NAME] (MLPA) (Test is used for detecting the presence of a specific mutation previously identified in an affected family member.) (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | Varies: Var |  |  | 3 | mL | This test can only be performed if a mutation has previously been identified in a family member of this individual.   [NAME] must arrive within 96 hours of draw.   Container/Tube: Preferred: Lavender top (EDTA) or yellow top (ACD) Acceptable: Any anticoagulant	 [NAME]: 3 mL Collection Instructions:	 1. Invert several times to mix blood. 2. Send specimen in original tube.	 Forms: 1. [NAME] (Supply T519) in Special Instructions 2. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. 3. If not ordering electronically, submit a Molecular Genetics Request Form (Supply T245) with the specimen. | 1 mL | No specimen should be rejected. If specimen not received at appropriate temperature or in wrong anticoagulant, include note to laboratory. If questions, contact laboratory. | An interpretive report will be provided. | Thursday; 10 a.m. | 10 days | 16 days | 1 | 81202 |  |  |  |  | Rochester
FAPKM | [NAME] | VARIES | Varies |  |  |  | Ambient
FAPKM | Result | 17247 | [NAME] | [NAME] | Alphanumeric
FAPKM | Result | 17248 | [NAME] | [NAME] | Alphanumeric
FAPKM | Result | 17249 | Source | Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
FAPKM | Result | 17250 | Order Date | Order Date | Alphanumeric
FAPKM | Result | 17251 | Reason For Referral | Reason For Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1 | Reason for referral:Find:Pt:^Patient:Nar:
FAPKM | Result | 17252 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49549-9
FAPKM | Result | 17253 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FAPKM | Result | 17254 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69047-9 | Service comment 01:Imp:Pt:[NAME]:Nom:
FAPKM | Result | 17255 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FAPKM | Result | 17256 | Reviewed By: | Reviewed By: | Alphanumeric
FAPKM | Result | 17257 | Release Date | Release Date | Alphanumeric
Spreadsheet: 0213f225-22e0-4343-865e-ce6636cd55fa
Sheet: Sheet1

EPA TEMPORARY EMPLOYEE TIMESHEET / INVOICE | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16
HOURLY RATE CONTRACT
PAYROLL INVOICE - REQUEST FOR PAYMENT
Social Security #:
Employee Name:
Dept Name or Projects (for which work is being performed):
Period Being Billed for | From: |  |  |  |  |  |  | To:
Rate Per Hour |  |  |  |  |  |  | Amount Due: | 0
Total Hours Worked: | 0
Source (FRS account #): |  |  |  |  | (e.g. 5-99999)
In accordance with contract effective (date) and ending (date), I request payment for the following period worked.  List dates and number of hours worked for each work day.
Date | Hours Worked |  |  | Date |  |  |  | Hours Worked
Totals | 0 |  |  | Totals |  |  |  | 0
Employee Signature:
Date Signed
Supervisor Signature of Approval:
Date Approved
Accounting Use Only
Effective Date | Dept 01 Number | F/P | Birth Date | Cit | S | R | Spec Pay Amt | Cyc | Fed | State | FIC | Ret | CH Payroll Acct | Object | Rate | Payroll Number
 |  | P |  |  |  |  |  | B | Y | Y | Y | N
 |  | P |  |  |  |  |  | B | Y | Y | Y | N
Spreadsheet: 888894d1739516938-dynamic-array-corkscrew-calculation-balance-opening-closing-and-circular-references-corkscrew_amortize_variable_apr
Sheet: Sheet1

Period | Rate | Payment | Interest | Principal | Balance
 |  |  |  |  | 50000
1 | 0.03125 | 2151.826240691421 | 130.2083333333333 | 2021.617907358088 | 47978.38209264191 |  | [NAME] (Years) | 2
2 | 0.03125 | 2151.826240691421 | 124.943703366255 | 2026.882537325166 | 45951.49955531675 |  | Payments Per Year | 12
3 | 0.03125 | 2151.826240691421 | 119.665363425304 | 2032.160877266117 | 43919.33867805063 |  | Loan Amount | 50000
4 | 0.03125 | 2151.826240691421 | 114.3732778074235 | 2037.452962883997 | 41881.88571516663
5 | 0.03125 | 2151.826240691421 | 109.0674107165798 | 2042.758829974841 | 39839.12688519179 |  | Annual Interest Rate Table
6 | 0.03125 | 2151.826240691421 | 103.7477262635203 | 2048.078514427901 | 37791.04837076389 |  | Period | Rate
7 | 0.0475 | 2179.33636043242 | 149.5895664676071 | 2029.746793964813 | 35761.30157679908 |  | 1 | 0.03125
8 | 0.0475 | 2179.33636043242 | 141.5551520748297 | 2037.781208357591 | 33723.52036844149 |  | 7 | 0.0475
9 | 0.0475 | 2179.33636043242 | 133.4889347917476 | 2045.847425640673 | 31677.67294280081 |  | 23 | 0.0375
10 | 0.0475 | 2179.33636043242 | 125.3907887319199 | 2053.9455717005 | 29623.72737110031
11 | 0.0475 | 2179.33636043242 | 117.2605875106054 | 2062.075772921814 | 27561.6515981785
12 | 0.0475 | 2179.33636043242 | 109.0982042427899 | 2070.23815618963 | 25491.41344198887
13 | 0.0475 | 2179.33636043242 | 100.903511541206 | 2078.432848891214 | 23412.98059309766
14 | 0.0475 | 2179.33636043242 | 92.67638151434491 | 2086.659978918075 | 21326.32061417958
15 | 0.0475 | 2179.33636043242 | 84.41668576446085 | 2094.919674667959 | 19231.40093951162
16 | 0.0475 | 2179.33636043242 | 76.12429538556685 | 2103.212065046853 | 17128.18887446477
17 | 0.0475 | 2179.33636043242 | 67.79908096142306 | 2111.537279470997 | 15016.65159499377
18 | 0.0475 | 2179.33636043242 | 59.44091256351702 | 2119.895447868903 | 12896.75614712487
19 | 0.0475 | 2179.33636043242 | 51.04965974903595 | 2128.286700683384 | 10768.46944644149
20 | 0.0475 | 2179.33636043242 | 42.62519155883088 | 2136.711168873589 | 8631.758277567897
21 | 0.0475 | 2179.33636043242 | 34.16737651537293 | 2145.168983917047 | 6486.58929365085
22 | 0.0475 | 2179.33636043242 | 25.67608262070128 | 2153.660277811719 | 4332.92901583913
23 | 0.0375 | 2176.625091268915 | 13.54040317449728 | 2163.084688094418 | 2169.844327744713
24 | 0.0375 | 2176.625091268915 | 6.780763524202227 | 2169.844327744713 | 0
Spreadsheet: 709404d1608289181-count-how-many-have-error-in-one-column-and-value-in-the-other-sample1
Sheet: Sample

User full name | 1. Resco Architecture DATE | 2. Woodford, App Project and Application DATE | 3. Backend DATE | 4. Other tools DATE | 1st book view | 1st quiz attempt | Users that attempted the quiz without reading any book
[NAME] |  |  |  |  | 2020-03-07 00:00:00 |  | IF(AND(IFNA(F2;1);IFNA(G2;0));1;0) | (this doesn't work)
[NAME] |  |  |  |  | 2020-03-09 00:00:00
[NAME] |  |  |  |  | 2020-03-09 00:00:00
[NAME] |  |  |  |  | 2020-03-09 00:00:00
Ab Slem |  |  |  |  | #N/A
[NAME] |  |  |  |  | 2020-03-10 00:00:00
[NAME] |  |  |  |  | #N/A
Imran Faroqui |  |  |  |  | 2020-03-12 00:00:00
Padmaja Gollapudi |  |  |  |  | 2020-03-12 00:00:00
[NAME] |  |  |  |  | 2020-03-13 00:00:00
Spreadsheet: 817747d1676425718-need-to-calculate-and-group-lengths-based-on-a-given-maximum-in-the-order-listed-takeoff-run-length-calc-test
Sheet: Sheet1

 |  |  | [NAME]: | 96
 |  |  | WATTAGE | MRL
 |  |  | 7.5
 |  |  | RUNS (INCHES) | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  |  | INDIVIDUAL RUNS (FEET)
 |  |  |  | 335 | 108 | 100 | 205 | 48 | 185 | 135 | 175
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 069ab0b2-3d58-4703-85d6-e37118a59432
Sheet: Sheet1

Table 1--Soybeans:  Annual U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
 | Area |  | Yield | Supply |  |  |  |  | Use
Year beginning | Planted | Harvested |  | Beginning |  |  |  |  | Crush | Seed, feed |  |  | Ending
September 1 |  |  |  | stocks | Production | Imports | Total |  |  | & residual | Exports | Total | stocks
 | Million acres |  | Bu./acre |  |  |  |  |  | --------------------------------------------------Million bushels--------------------------------------------------
2011/12 | 75.046 | 73.776 | 41.93130557362828 | 215.013 | 3093.524 | 16.1352383836245 | 3324.672238383625 |  | 1703 | 90.4538823855737 | 1361.848355998051 | 3155.302238383625 | 169.37
2012/131 | 77.198 | 76.104 | 39.61681383370125 | 169.37 | 3014.998 | 20 | 3204.368 |  | 1635 | 94.36799999999994 | 1350 | 3079.368 | 125
2013/142 | 77.126 | 76.2 | 44.48818897637795 | 125 | 3390 | 15 | 3530 |  | 1695 | 120 | 1450 | 3265 | 265
Soybeans:  Quarterly U.S. supply and disappearance
 |  |  |  | Supply |  |  |  |  | Use
 |  |  |  | Beginning |  |  |  |  | Crush, seed |  |  |  | Ending
 |  |  |  | stocks | Production | Imports | Total |  | & residual |  | Exports | Total | stocks
2011/12 |  |  |  |  |  |  |  |  | --------------------------------------------------Million bushels--------------------------------------------------
September-November |  |  |  | 215.013 | 3093.524 | 2.8441205983722 | 3311.381120598372 |  | 516.5955746809718 |  | 424.9005459174001 | 941.4961205983718 | 2369.885
December-February |  |  |  | 2369.885 | --- | 3.1416916574442 | 2373.026691657445 |  | 523.9961548514923 |  | 474.5425368059524 | 998.5386916574446 | 1374.488
March-May |  |  |  | 1374.488 | --- | 5.3307780169035 | 1379.818778016903 |  | 453.9034791290034 |  | 258.4502988879 | 712.3537780169034 | 667.465
June-August |  |  |  | 667.465 | --- | 4.818648110904601 | 672.2836481109047 |  | 298.958673724106 |  | 203.9549743867986 | 502.9136481109047 | 169.37
Total |  |  |  |  | 3093.524 | 16.1352383836245 | 3324.672238383625 |  | 1793.453882385574 |  | 1361.848355998051 | 3155.302238383624
2012/13
September-November |  |  |  | 169.37 | 3014.998 | 4.2863493307698 | 3188.65434933077 |  | 602.9483867095553 |  | 619.5449626212146 | 1222.49334933077 | 1966.161
December-February |  |  |  | 1966.161 | --- | 4.7181036423045 | 1970.879103642304 |  | 440.6512322404433 |  | 530.9478714018612 | 971.5991036423045 | 999.28
Total to date |  |  |  |  | 3014.998 | 9.004452973074299 | 3193.372452973074 |  | 1043.599618949999 |  | 1150.492834023076 | 2194.092452973075
1 Estimated. 2 Forecast.
Sources: USDA, National Agricultural Statistics Service, Crop Production and Grain Stocks and U.S. Department of Commerce, U.S. Census Bureau,
Foreign Trade Statistics.
Last update: | 2013-05-14 11:04:17.360000
Spreadsheet: 83275d1283281370-evaluate-multiple-data-points-against-single-criteria-excel-help
Sheet: Sheet1

 | If any of the values below are greater than I5 then show text "Warning"
a | 0 | 0 | 0 | 0 | 0 |  |  | 0.05
b | -0.4118352450469239 | -0.4122060470324748 | -0.4117142857142857 | -0.3876791958041959 | -0.3802842329551482
c | -0.1481751824817519 | -0.1487122060470323 | -0.1479999999999999 | -0.1131905594405594 | -0.1399850994017896
d | -0.1481751824817519 | -0.1487122060470323 | -0.1479999999999999 | -0.1131905594405594 | -0.1141922374422324
e | 0.4197080291970803 | 0.4188129899216129 | 0.4200000000000002 | 0.4780157342657343 | 0.4376243426330335
Spreadsheet: 86272d1286290664-sumif-with-multiple-conditions-active-cc
Sheet: Monthly Totals

 | Bills | Groceries | Gas | Misc | Dining | Medical | Home Expense | Kids Expense | [NAME] | Gifts | Taxes | Big Purchase | Total | Credit Cards | Mortgage
2010-08-01 00:00:00
2010-09-01 00:00:00
2010-10-01 00:00:00
2010-11-01 00:00:00
2010-12-01 00:00:00
2011-01-01 00:00:00
2011-02-01 00:00:00
2011-03-01 00:00:00
2011-04-01 00:00:00
2011-05-01 00:00:00
2011-06-01 00:00:00
2011-07-01 00:00:00
2011-08-01 00:00:00
2011-09-01 00:00:00
2011-10-01 00:00:00
2011-11-01 00:00:00
2011-12-01 00:00:00
2012-01-01 00:00:00
2012-02-01 00:00:00
2012-03-01 00:00:00
2012-04-01 00:00:00
Spreadsheet: 541943d1507640893-data-separation-sample-workbook-1-
Sheet: Before

data example
[NAME] es traspasado de Paddymar a futmondo por 323.565 €
Munir es traspasado de Paddymar a quiquebustillo por 1.400.000 €
[NAME] es traspasado de [NAME] a quiquebustillo por 1.150.000 €
Mula es traspasado de quiquebustillo a [NAME] por 1.000.000 €
Laporte es traspasado de quiquebustillo a futmondo por 4.645.935 €
Digne es traspasado de Pablo Raventos Simic a futmondo por 213.322 €
Jozabed es traspasado de Pablo Raventos Simic a futmondo por 1.648.326 €
Hernán es traspasado de Pablo Raventos Simic a futmondo por 237.360 €
Sergio Sánchez es traspasado de Pablo Raventos Simic a futmondo por 230.573 €
[NAME] es traspasado de Pablo Raventos Simic a futmondo por 204.825 €
[NAME] es traspasado de Pablo Raventos Simic a futmondo por 209.967 €
Pichu Cuéllar es traspasado de Pablo Raventos Simic a futmondo por 3.029.317 €
Gorosabel es traspasado de futmondo a [NAME] por 200.000 €
[NAME] es traspasado de futmondo a [NAME] por 200.000 €
Rubén Pardo es traspasado de futmondo a [NAME] por 200.000 €
Koné es traspasado de futmondo a [NAME] por 200.000 €
[NAME] es traspasado de futmondo a [NAME] por 200.000 €
[NAME] es traspasado de futmondo a sergio alegre por 7.156.500 €
[NAME] es traspasado de futmondo a [NAME] por 201.000 €
[NAME] es traspasado de futmondo a Lobox FC por 845.000 €
Spreadsheet: andy_zipper__764__10_24_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL Z1 | 21.5 | 240 | 248 | 58.5 | 60.4 | 0.8 | 2001-10-24 10:47:00
 | CL F2 | 22 | 350 | 365 | 53.7 | 56 | 0.76 | 2001-10-24 10:47:00
 | CL G2 | 22 | 435 | 550 | 52.2 | 66.2 | 0.82 | 2001-10-24 10:47:00
 | CL H2 | 22 | 485 | 505 | 50.4 | 52.5 | 0.71 | 2001-10-24 10:47:00
 | CL J2 | 22 | 510 | 530 | 47.5 | 49.4 | 0.67 | 2001-10-24 10:47:00
 | CL K2 | 22 | 535 | 555 | 45.1 | 46.8 | 0.64 | 2001-10-24 10:47:00
 | CL M2 | 22 | 538 | 558 | 42.1 | 43.7 | 0.59 | 2001-10-24 10:47:00
 | CL N2 | 22 | 555 | 570 | 40.6 | 41.7 | 0.57 | 2001-10-24 10:47:00
 | CL Q2 | 22 | 555 | 565 | 38.3 | 39 | 0.53 | 2001-10-24 10:47:00
 | CL U2 | 22 | 550 | 570 | 36.3 | 37.6 | 0.51 | 2001-10-24 10:47:00
 | [NAME] | 22 | 550 | 570 | 34.5 | 35.8 | 0.49 | 2001-10-24 10:47:00
 | CL X2 | 22 | 555 | 575 | 33.5 | 34.7 | 0.47 | 2001-10-24 10:47:00
 | [NAME] | 21.5 | 560 | 585 | 33.4 | 34.9 | 0.46 | 2001-10-24 10:47:00
 | CL M3 | 21.5 | 555 | 585 | 28.1 | 29.6 | 0.39 | 2001-10-24 10:47:00
 | CL Z3 | 21.5 | 555 | 585 | 25 | 26.4 | 0.35 | 2001-10-24 10:47:00
Spreadsheet: 01313998-c300-4c11-bc14-94b9a13807b1
Sheet: Sheet1

 |  | Comprehensive Needs Assessment
 | School Data For General Education Including FRL | English Language Learner (ELL) Data | Special Education Data
 | Nevada School Performance Framework (NSPF) | Nevada School Performance Framework (NSPF) | Nevada School Performance Framework (NSPF)
 | Statewide Assessments | Achievement Gap Data | Achievement Gap Data
 | Formative Assessment Practice | AMAOs/ELPA Analysis | Nevada Alternate Assessment (NAA)
 | Interim Assessments | Comparison of ELPA with other Assessments | Individualized Educational Programs (IEP)
 | Summative Assessments | ELL Program Policies and Procedures | Service Delivery Model
 | SAT/ACT Assessments | Placement (Proficiency Levels) | Special Education Procedures- Whole School
 | Fiscal Resources | Service Delivery Models | IEP Team Membership/Attendance
 | Teacher/Administrator Observation Data | Content/ESL Staffing and Professional Development | IEP Compliance
 | Stakeholder Information | Time in ELL Program/Projected Time to Proficiency | Approaches to Testing Accommodations
 | NCCAT | Family Engagement Data | Special Ed Staffing and Professional Development
 | Stakeholder Survey Information | Teacher/Administrator Observation Data | Availability of Curriculum for IEP Students
 | Family Engagement Data |  | Special Ed Policies and Procedures
 | Coordination of Services for FRL, ELL, IEP Students |  | Family Engagement Data
 |  |  | Teacher/Administrator Observation Data
Spreadsheet: 707922d1607537206-if-a-match-then-enter-corresponding-value-sumif-etaf
Sheet: Sheet2

CUST | Sales
CUST1 | 1
CUST1 | 2
CUST1 | 3
CUST1 | 4
CUST1 | 5
CUST1 | 6
CUST2 | 7
CUST2 | 8
CUST2 | 9
CUST2 | 10
CUST3 | 11
CUST4 | 12
Spreadsheet: 221150d1363380731-sorting-data-into-multiple-columns-based-on-a-single-column-example
Sheet: Sheet1

Current format of data:
(the colouring is purely to show that some employees will have more lines on the payroll than others)
Emp No | Cost Centre | Description | Amount
X00100 | C900 | salaries | 1000
X00100 | C900 | Salaries - NI | 500
X00100 | C900 | Salaries - PPE | 96
X00278 | C350 | salaries | 1500
X00278 | C350 | Salaries - NI | 800
X00278 | C350 | Salaries - PPE | 180
X00278 | C350 | Salaries - Overtime x1 | 200
X00278 | C350 | Salaries - Overtime x2 | 350
I want to try and split it into individual columns - preferably into a new worksheet, based on the description field so that it looks like this:
Emp No | Cost Centre | Salaries | Salaries - NI | Salaries - PPE | Salaries - Overtime x1 | Salaries - Overtime x2
X00100 | C900
X00278 | C350
Spreadsheet: 67231d1267811506-please-help-needing-to-showing-more-than-4-quarters-in-a-pivot-table-chart-q1-4-workbook
Sheet: Completion Sheet

Name | Chore | Completion Date
[NAME] | Sweep | 2010-03-19 00:00:00 |  |  | Row Labels | Count of Name
[NAME] | Mop | 2010-04-07 00:00:00 |  |  | 2010
[NAME] | Dust | 2010-04-08 00:00:00 |  |  | Qtr1
[NAME] | Mop | 2010-04-09 00:00:00 |  |  | Jan
[NAME] | Mop | 2010-04-10 00:00:00 |  |  | Feb
[NAME] | Sweep | 2010-04-11 00:00:00 |  |  | Mar | 1
[NAME] | Dust | 2010-04-12 00:00:00 |  |  | Qtr2
[NAME] | Mop | 2010-04-13 00:00:00 |  |  | Apr | 11
[NAME] | Sweep | 2010-04-14 00:00:00 |  |  | May | 2
[NAME] | Dust | 2010-04-15 00:00:00 |  |  | Jun
[NAME] | Dust | 2010-04-16 00:00:00 |  |  | Qtr3
[NAME] | Mop | 2010-04-17 00:00:00 |  |  | Jul | 1
[NAME] | Sweep | 2010-05-18 00:00:00 |  |  | Aug | 1
[NAME] | Dust | 2010-05-23 00:00:00 |  |  | Sep | 2
[NAME] | Mop | 2010-07-03 00:00:00 |  |  | Qtr4
[NAME] | Sweep | 2010-08-24 00:00:00 |  |  | Oct | 1
[NAME] | Mop | 2010-09-04 00:00:00 |  |  | Nov | 1
[NAME] | Sweep | 2010-09-11 00:00:00 |  |  | Dec | 1
[NAME] | Mop | 2010-10-31 00:00:00 |  |  | 2011
[NAME] | Sweep | 2010-11-08 00:00:00 |  |  | Qtr1
Dirk | Dust | 2010-12-06 00:00:00 |  |  | Jan | 1
[NAME] | Lawn | 2011-01-01 00:00:00 |  |  | Feb | 1
Todd | Lawn | 2011-02-24 00:00:00 |  |  | Mar
[NAME] | Mop | 2011-06-02 00:00:00 |  |  | Qtr2
Eddie | Dust | 2011-06-08 00:00:00 |  |  | Apr
Samanta | Mop | 2011-07-08 00:00:00 |  |  | May
[NAME] | Sweep | 2011-09-08 00:00:00 |  |  | Jun | 2
 |  |  |  |  | Qtr3
 |  |  |  |  | Jul | 1
 |  |  |  |  | Aug
 |  |  |  |  | Sep | 1
 |  |  |  |  | Qtr4
 |  |  |  |  | Oct
 |  |  |  |  | Nov
 |  |  |  |  | Dec
 |  |  |  |  | Grand Total | 27
Spreadsheet: 869433d1716000914-trying-to-sum-non-contiguous-cells-based-on-criteria-in-another-row-a-course-completion-sample-2024-05-17-aligw
Sheet: TrainingMatrix

Name | Level 3 Course A | Level 1 Course B | Level 3 Course C | Level 2 Course D | Level 1 Course E Retired | Level 3 Course F | Level 3 Course G | Level 1 Course H | Level 1 Course I | Level 2 Course J | Level 3 Course K | Level 2 Course L | Level 3 Course M | Level 1 Course N | Level 3 Course O | Level 2 Course P | Level 3 Course Q | Level 1 Course R | Level 1 Course S Retired | Level 2 Course T Retired | Level 1 Course U | Level 2 Course V | Level 3 Course W | Total Courses Completed | Total Hours Completed | Level 1 Courses Completed | Level 1 Hours Completed | Level 2 Courses Completed | Level 2 Hours Completed | Level 3 Courses Completed | Level 3 Hours Completed
 | 1.25 | 0.5 | 1 | 1 | 2.5 | 0.6 | 1 | 0.25 | 1 | 2 | 0.5 | 0.5 | 0.25 | 0.5 | 0.25 | 1.25 | 0.5 | 1 | 0.5 | 1 | 0.5 | 0.5 | 1
Employee 1 | 2023-06-16 00:00:00 | 2023-02-07 00:00:00 |  | 2023-05-02 00:00:00 | 2022-12-12 00:00:00 | 2023-06-04 00:00:00 | 2023-06-16 00:00:00 | 2022-12-19 00:00:00 | 2022-12-12 00:00:00 | 2023-05-01 00:00:00 | 2023-06-16 00:00:00 | 2023-05-19 00:00:00 | 2023-07-01 00:00:00 | 2022-12-19 00:00:00 |  | 2023-05-09 00:00:00 | 2023-07-01 00:00:00 |  | 2023-07-24 00:00:00 | 2022-12-26 00:00:00 | 2023-07-03 00:00:00 | 2023-05-16 00:00:00
Employee 2 | 2023-06-15 00:00:00 | 2022-11-12 00:00:00 | 2023-06-14 00:00:00 | 2023-01-31 00:00:00 | 2022-11-19 00:00:00 | 2023-05-23 00:00:00 | 2023-05-06 00:00:00 | 2022-11-13 00:00:00 | 2022-10-29 00:00:00 | 2023-01-16 00:00:00 | 2023-05-20 00:00:00 | 2023-02-20 00:00:00 | 2023-06-08 00:00:00 | 2022-11-13 00:00:00 | 2023-06-08 00:00:00 | 2023-01-31 00:00:00 | 2023-06-06 00:00:00 | 2022-11-15 00:00:00 | 2022-11-12 00:00:00 | 2022-11-15 00:00:00 | 2023-06-06 00:00:00 | 2023-02-22 00:00:00 | 2023-06-07 00:00:00
Employee 3 |  | 2022-10-29 00:00:00 |  |  | 2022-10-21 00:00:00 |  |  | 2022-10-14 00:00:00 | 2022-11-12 00:00:00 | 2023-01-20 00:00:00 |  | 2023-02-10 00:00:00 |  | 2022-11-05 00:00:00 |  | 2023-01-21 00:00:00 |  |  | 2022-11-04 00:00:00 | 2022-10-29 00:00:00 | 2023-04-07 00:00:00 | 2023-02-04 00:00:00
Employee 4 | 2023-03-14 00:00:00 | 2022-11-01 00:00:00 |  | 2023-01-22 00:00:00 | 2022-10-14 00:00:00 | 2023-05-14 00:00:00 | 2023-03-06 00:00:00 | 2022-10-26 00:00:00 | 2022-11-07 00:00:00 | 2023-01-20 00:00:00 | 2023-02-16 00:00:00 | 2023-02-03 00:00:00 | 2023-02-14 00:00:00 | 2022-11-06 00:00:00 |  | 2023-01-30 00:00:00 | 2023-02-20 00:00:00 | 2022-11-01 00:00:00 | 2022-11-01 00:00:00 | 2022-10-24 00:00:00 | 2023-04-25 00:00:00 | 2023-02-02 00:00:00
Employee 5 |  | 2024-01-19 00:00:00 |  |  | 2024-01-17 00:00:00 |  |  | 2024-01-18 00:00:00 | 2024-01-16 00:00:00 |  |  |  |  | 2024-01-19 00:00:00 |  |  |  |  |  |  | 2024-01-19 00:00:00
Spreadsheet: 676030d1588614723-if-a-cells-value-is-included-in-a-list-then-cell-should-be-zero-example
Sheet: Sheet1

Pin | Code |  | Budget | Rate | Total
1234 | UNK |  | 120 | 10
1235 | ABC |  | 150 | 10
1236 | ABC |  | 170 | 10
1237 | UNK |  | 40 | 10
1238 | DEF |  | 80 | 10
1239 | ABC |  | 100 | 10
List
1236
1239