tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 857851d1706720079-sum-hours-based-on-date-range-and-id-and-then-summarize-on-a-separate-tab-eot-sample-v2
Sheet: COSTA

Name | ID |  |  |  |  | CHARGE MONTH: |  |  |  | PAYROLL WORKSHEET
COSTA |  |  |  |  |  | 2023-11-01 00:00:00 |  |  |  | Schedule: | Weekly |  |  | Mo. [NAME]: |  |  |  | Hrly [NAME].: |  |  |  | Position: | Officer
 |  |  |  |  |  |  |  |  |  | Shift: | Swing |  |  | Stipends/UA |  |  |  | Bi-Wk Equiv.: |  |  |  | Union: | R08
LEAVE USAGE
TYPE | V | S | SF | CTO | HC | IH | PH |  |  |  |  |  | Hours Worked
DATE |  |  |  |  |  |  |  |  |  | Period # | Start | End | Regular | Holiday | Overtime | CTO | Total | Swing | S Due | Grave | G Due | Total Comp | OT Rate
 |  |  |  |  |  |  |  |  |  | 1 | 2023-10-22 00:00:00 | 2023-11-04 00:00:00 | 80
 |  |  |  |  |  |  |  |  |  | 2 | 2023-11-05 00:00:00 | 2023-11-18 00:00:00 | 80
 |  |  |  |  |  |  |  |  |  | 3 | 2023-11-19 00:00:00 | 2023-12-02 00:00:00 | 80
 |  | NO TIME TAKEN |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  | Total All OT Worked:
TOTAL |  |  |  |  |  |  |  |  |  |  |  |  | OT Reported by Dept:
 |  |  |  |  |  |  |  |  |  |  |  |  | Less Holiday RDO:
OVERTIME AUTHORIZED
REASON | DATE | FROM | TO | HOURS | EARN ID | PAY CODE | SWING | GRAVE |  |  |  |  |  | Difference:
FOOTBALL VS BOISE | 2023-11-04 00:00:00 | 1500 | 2330 | 8.5 | OTPR | 871-425P |  | 1.5
BOARD OF TRUSTEE MEETINGS | 2023-11-06 00:00:00 | 900 | 1330 | 4.5 | OTPR | 213-425P
BOARD OF TRUSTEE MEETINGS | 2023-11-07 00:00:00 | 700 | 2000 | 13 | CTO | 213-425P | 20
BOARD OF TRUSTEE MEETINGS | 2023-11-08 00:00:00 | 700 | 1700 | 10 | HOL(W) | 213-425P
VETERANS DAY - REG SHIFT | 2023-11-10 00:00:00 |  |  | 12 | HG6 | 213-425HP
FOOTBALL VS NEW MEXICO | 2023-11-18 00:00:00 | 1600 | 2345 | 7.8 | OTPR | 871-425P |  | 1.75
THANKSGIVING DAY - REG SHIFT | 2023-11-23 00:00:00 |  |  | 12 | HG6 | 213-425HP
Total
 |  |  |  | Regular Shift Differential Hours: |  |  |  | 180
 |  |  |  | Total Shift Differential Hours to Pay:
Spreadsheet: 046ca1c8-baed-4ed5-9cb4-34e701dca7a9
Sheet: Sheet1

WORLD SENIOR BADMINTON CHAMPIONSHIPS 2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
09-14 SEPTEMBER 2013, ANKARA-TURKEY
PRACTICE PROGRAMME
 | 08.09.2013  SUNDAY
 |  | Main Hall
 | Time | Court 1 | Court 2 | Court 3 | Court 4 | Court 5 | Court 6
1 | 09.00-10.00
2 | 10.00-11.00
3 | 11.00-12.00
4 | 12.00-13.00
5 | 13.00-14.00
6 | 14.00-15.00
7 | 15.00-16.00
8 | 16.00-17.00
9 | 17.00-18.00
10 | 18.00-19.00
11 | 19.00-20.00
12 | 20.00-21.00
13 | 21.00-22.00
 | 08.09.2013  SUNDAY
 |  | Main Hall
 | Time | Court 7 | Court 8 | Court 9 | Court 10 | Court 11 | Court 12
1 | 09.00-10.00
2 | 10.00-11.00
3 | 11.00-12.00
4 | 12.00-13.00
5 | 13.00-14.00
6 | 14.00-15.00
7 | 15.00-16.00
8 | 16.00-17.00
9 | 17.00-18.00
10 | 18.00-19.00
11 | 19.00-20.00
12 | 20.00-21.00
13 | 21.00-22.00
Spreadsheet: 765411d1643306248-need-help-with-attendance-formula-in-an-excel-template-draft_at
Sheet: Calendar View

 | [NAME]
 | Select an Employee: | [NAME]
 | Fiscal Year:
 | Fiscal year starting month: | 5
 | Weekday/Month | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU  2 | FRI | SAT
 | May
 | June
 | July
 | August
 | September
 | October
 | November
 | December
 | January
 | February
 | March
 | April
 | [NAME]:
 |  |  |  |  |  |  | TOTAL DAYS OUT |  |  |  |  | Sick |  |  |  |  | [NAME] |  |  |  |  | Field |  |  |  |  | Activism |  |  |  |  | Leave of Absence |  |  |  |  | [NAME]
Spreadsheet: 48117d1247269732-excel-2007-populating-data-on-tertiary-tabs-fix-me
Sheet: Master list

Email/Media # | Correspondence # | Date Received | Status | Password | Confirmed? | First Name | Last Name | Address1 | Address2 | City | State | ZipCode | Country | Telephone | [NAME]
Media 001 | 1234134 | 2008-12-06 00:00:00 | single | n/a | yes | [NAME] | white | 123 firth ST |  | lewisville | ID | 83605 | USA | 2086627841
Email 001 | 1231345 | 2009-01-06 00:00:00 | single | n/a | no | ron | [NAME] | 96465 round lane |  | lewisville | ID | 83605 | USA | 2086627851
Email 002 | 1234150 | 2009-01-12 00:00:00 | married | n/a | yes | [NAME] | jones | 665 pickle road |  | lewisville | ID | 83605 | USA | 2086627861
Media 002 | 1234651 | 2009-01-14 00:00:00 | single | n/a | yes | mark | king | 126 lovins way |  | lewisville | ID | 83605 | USA | 2086627871
Email 003 | 1263550 | 2009-02-06 00:00:00 | married | n/a | yes | [NAME] | [NAME] | 127 serinity park |  | lewisville | ID | 83605 | USA | 2086627881
Media 003 | 1271223 | 2009-02-21 00:00:00 | married | n/a | yes | river | peters | 128 bronbridge |  | lewisville | ID | 83605 | USA | 2086627891
Media 004 | 1273442 | 2009-02-24 00:00:00 | single | n/a | yes | cameron | [NAME] | 129 stone wall |  | lewisville | ID | 83605 | USA | 2086627901
Media 005 | 1273641 | 2009-03-03 00:00:00 | single | n/a | yes | [NAME] | markis | 54 kings way |  | lewisville | ID | 83605 | USA | 2086627911
Email 004 | 1276114 | 2009-03-12 00:00:00 | single | n/a | yes | tarrie | whinters | 131 happy rd |  | lewisville | ID | 83605 | USA | 2086627921
Media 006 | 1284672 | 2009-03-14 00:00:00 | married | n/a | yes | ryan | crompton | 455 5th ave |  | lewisville | ID | 83605 | USA | 2086627931
Media 007 | 1286671 | 2009-03-16 00:00:00 | married | n/a | yes | [NAME] | [NAME] | 133 2nd ave |  | lewisville | ID | 83605 | USA | 2086627941
Email 005 | 1286755 | 2009-03-22 00:00:00 | single | n/a | no | [NAME] | dowers | 2668 south St |  | lewisville | ID | 83605 | USA | 2086627951
Media 008 | 1286812 | 2009-04-14 00:00:00 | married | n/a | yes | jill | cromby | 135 jefferson rd |  | lewisville | ID | 83605 | USA | 2086627961
Spreadsheet: 755628d1636997952-lookup-examples-from-arrays-lookup
Sheet: Sheet1

 |  | Example 1 |  |  |  |  |  | Example 2
 | Lookup |  | 4 | 8 |  |  | Lookup |  | 1 | 5
 |  | 1 | 5 | 9 |  |  |  |  | 2 | 6
 |  | 2 | 6 | 10 |  |  |  |  | 3 | 7
 |  | 3 | 7 | 11 |  |  |  |  | 4 | 8
 | Values |  | 2 | 9 |  |  | Values |  | 6 | 2
 |  | 6 | 3 | 5 |  |  |  |  | 8 | 5
 |  | 8 | 41 | 6 |  |  |  |  | 1 | 8
 |  | 7 | 3 | 1 |  |  |  |  | 20 | 3
 | Result | Lookup |  | Return |  |  | Result | Lookup |  | Return
 |  | 1 |  | 6 |  |  |  | 1 |  | 6 |  |  | =FILTERXML("<F><d>"&SUBSTITUTE(TEXTJOIN(";",,C6:C8,D5:D8,E5:[NAME]")
 | 2 | 2 |  | 8 | 8 |  | 2 | 2 |  | 8 | 8
 | 3 | 3 |  | 7 | 7 |  | 3 | 3 |  | 1 | 1
 | 4 | 4 |  | 2 | 2 |  | 4 | 4 |  | 20 | 20
 | 5 | 5 |  | 3 | 3 |  | 5 | 5 |  | 2 | 2
 | 6 | 6 |  | 41 | 41 |  | 6 | 6 |  | 5 | 5
 | 7 | 7 |  | 3 | 3 |  | 7 | 7 |  | 8 | 8
 | 8 | 8 |  | 9 | 9 |  | 8 | 8 |  | 3 | 3
 | 9 | 9 |  | 5 | 5
 | 10 | 10 |  | 6 | 6
 | 11 | 11 |  | 1 | 1
Spreadsheet: 87996d1287888121-help-with-running-7-day-count-goals-2
Sheet: Fuel

fuel | wednesday | thursday | friday | saturday | sunday | monday | tuesday | total | wkly variance |  | week | day | Sales
week 1 | 4788 | 6105 | 6658 | 5875 | 6608 | 8985 | 5445 | 44464 | -1806 |  | 1 | 1 | 4788
week 2 | 6802 | 6608 | 6698 | 8502 | 6610 | 7524 | 4878 | 47622 | 1352 |  | 1 | 2 | 6105
week 3 | 5895 | 5847 | 6608 | 6608 | 6610 | 5586 | 6689 | 43843 | -2427 |  | 1 | 3 | 6658
week 4 | 6745 | 6955 | 6612 |  |  |  |  | 20312 | 482 |  | 1 | 4 | 5875
week 5 |  |  |  |  |  |  |  | 0 | 0 |  | 1 | 5 | 6608
 |  |  |  |  | daily goal | 6610 | month total | 156241 |  |  | 1 | 6 | 8985
 |  |  |  |  | weekly goal | 46270 | actual mth goal | 158640 |  |  | 1 | 7 | 5445
 |  |  |  |  | monthly goal | 185080 | month variance | -2399 |  |  | 2 | 1 | 6802
 |  |  |  |  |  |  | 7 day total | 45801 |  |  | 2 | 2 | 6608
 |  |  |  |  |  |  | 7 day variance |  |  |  | 2 | 3 | 6698
 |  |  |  |  |  |  |  |  |  |  | 2 | 4 | 8502
 |  |  |  |  |  |  |  |  |  |  | 2 | 5 | 6610
 |  |  |  |  |  |  |  |  |  |  | 2 | 6 | 7524
 |  |  |  |  |  |  |  |  |  |  | 2 | 7 | 4878
 |  |  |  |  |  |  |  |  |  |  | 3 | 1 | 5895
 |  |  |  |  |  |  |  |  |  |  | 3 | 2 | 5847
 |  |  |  |  |  |  |  |  |  |  | 3 | 3 | 6608
 |  |  |  |  |  |  |  |  |  |  | 3 | 4 | 6608
 |  |  |  |  |  |  |  |  |  |  | 3 | 5 | 6610
 |  |  |  |  |  |  |  |  |  |  | 3 | 6 | 5586
 |  |  |  |  |  |  |  |  |  |  | 3 | 7 | 6689
 |  |  |  |  |  |  |  |  |  |  | 4 | 1 | 6745
 |  |  |  |  |  |  |  |  |  |  | 4 | 2 | 6955
 |  |  |  |  |  |  |  |  |  |  | 4 | 3 | 6612
 |  |  |  |  |  |  |  |  |  |  | 4 | 4
 |  |  |  |  |  |  |  |  |  |  | 4 | 5
 |  |  |  |  |  |  |  |  |  |  | 4 | 6
 |  |  |  |  |  |  |  |  |  |  | 4 | 7
 |  |  |  |  |  |  |  |  |  |  | 5 | 1
 |  |  |  |  |  |  |  |  |  |  | 5 | 2
 |  |  |  |  |  |  |  |  |  |  | 5 | 3
 |  |  |  |  |  |  |  |  |  |  | 5 | 4
 |  |  |  |  |  |  |  |  |  |  | 5 | 5
 |  |  |  |  |  |  |  |  |  |  | 5 | 6
 |  |  |  |  |  |  |  |  |  |  | 5 | 7
Spreadsheet: 83816d1283862817-formula-involving-hyperlinks-example
Sheet: Details

ITEM | CODE
TRUCK | 281
TEAM | 2
SOCCER | 571
SNAKE | 1571123
SMALL | 279
ROAD | 280
RAT | 278
RADIO | 282
PIRATE | 28571
PARROT | 2871
ORANGE | 157115
NATIONAL | 57105571
[NAME] | 157117
MONKEY | 157118
MEETING | 571052
MEDIUM | 5710771
LARGE | 5710571
KOREA | 571055
[NAME] | 235971
KING | 571072
JACK | 712385971
HOUSE | 571071
HORSE | 571075
GREEN | 5710723
GORILLA | 715871
GIRAFFE | 57107571
ELEPHANT | 712385
DONKEY | 64985
DOG | 45637
 | 45829
 | 46021
 | 46213
 | 46405
 | 46597
 | 46789
 | 46981
 | 47173
 | 47365
 | 47557
 | 47749
 | 47941
 | 48133
 | 48325
 | 48517
 | 48709
 | 48901
DIAMOND | 157118
DAMAN | 160215
CROCODILE | 163312
CRANBERRY | 166409
CAT | 169506
CAR | 172603
CANADA | 175700
BLUE | 178797
BIRD | 181894
BASEBALL | 184991
APPLE | 188088
ALLIGATOR | 191185
ACE | 194282
Spreadsheet: eric_saibi__9859__101101R
Sheet: North Anna 01

Owner Name |  | Dominion Virginia Power
Station Name |  | North Anna Nuclear Power Station
Unit Name |  | North Anna 01
NERC Region |  | SERC
State |  | VA
Fuel Type |  | Nuclear
Capacity |  | 980 MW
Start Date |  | 2001-09-08 00:00:00
End Date |  | 2001-10-11 00:00:00
Prv. Start Date |  | 2001-09-08 00:00:00
Prv. End Date |  | 2001-10-11 00:00:00
Comments |  | We have spoken to our contact at the plant. The unit went in to start up yesterday and they are online today at 50% and moving up.
SIC |  | 4911
Plant ID |  | 1012052
Unit ID |  | 1006140
Outage ID |  | 11071
Spreadsheet: 371220f9-8143-4f43-bc1a-1342b8f87dda
Sheet: Sheet1

TABLE 1 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
CONTINUING EDUCATION ENROLLMENT
UNIVERSITY OF HAWAI‘I, BY CAMPUS
SUMMER 2010
 | CAMPUS |  |  |  | TOTAL
 |  |  |  |  | No. | V%
 |  | TOTAL 1/ ......................................................................................... |  |  | 19356 | 99.99000000000001
 |  | UH Mānoa ................................................................................. |  |  | 7607 | 39.3
 |  |  | Outreach College………………. |  | 2838 | 14.66
 |  |  | Community Service ................................ |  | 3583 | 18.51
 |  |  | Public Events ................................................................................ |  | 1186 | 6.13
 |  | UH Hilo ....................................................................................... |  |  | 2725 | 14.08
 |  |  | Conference Center ............................. |  | 2158 | 11.15
 |  |  | Continuing Education .................................. |  | 488 | 2.52
 |  |  | Senior Programs ...................................... |  | 79 | 0.41
 |  | UH Community Colleges .................................................. |  |  | 9024 | 46.61
 |  |  | Hawai‘i ............................................................................... |  | 1451 | 7.5
 |  |  | Honolulu ....................................................................... |  | 835 | 4.31
 |  |  | Kapi‘olani ......................................................................... |  | 2141 | 11.06
 |  |  | Kaua‘i .................................................................................... |  | 594 | 3.07
 |  |  | Leeward ....................................................................................... |  | 1367 | 7.06
 |  |  | Maui ........................................................................................... |  | 1555 | 8.03
 |  |  | [NAME] .................................................................................. |  | 808 | 4.17
 |  |  | ETC ......................................................................................... |  | 273 | 1.41
 |  | 1/  Counts are registration counts, and may include multiple
 |  |  | counting of individuals.
Spreadsheet: 732529d1621006001-text-join-substitute-formula-assistance-textjoin-sub
Sheet: Sheet1

ACCT | 123 | (Always 3 digits)
 |  | Sometimes given as a string like this where Prog and [NAME] are already combined | (Always 4 digits) | (Always 2 digits, could start with 0, but would need to display as 2 digits (EXAMPLE: 2 = 02))
 | Acct-Prog-Loc | [NAME] | Prog | [NAME]
 | 123-1011-35|123-1011-90|123-1025-90..123-1045-90|123-1047-90..123-1076-90|123-1082-90..123-1085-90|123-1300-90..123-1301-90|123-4100-90 | 1011-35|1011-90|1025-90..1045-90|1047-90..1076-90|1082-90..1085-90|1300-90..1301-90|4100-90
 | 123-4014-90 |  | 4014 | 90
 | 123-4010-90|123-4012-90|123-4013-90|123-4015-90..123-4018-90|123-4950-90 |  | 4010|4012|4013|4015..4018|4950 | 90
 | 123-1079-90..123-1081-90 |  | 1079..1081 | 90
Spreadsheet: 70814d1271506736-names-to-numbers-mileagelog-2-
Sheet: Mileage Log and Reimbursement

Mileage Log and Reimbursement Form |  |  |  |  |  |  |  | http://www.hypermiler.co.uk/mpg-calculator.html
 |  |  |  |  |  |  |  | http://www.hmrc.gov.uk/cars/advisory_fuel_current.htm
Employee Name | [NAME] |  |  |  |  | Rate Per Mile |  |  | 0.12 |  | per lit | 1.09
Employee ID |  |  |  |  |  | For Period |  |  | From 25/10/09 to 27/10/09 |  | per gal | 4.9595
Vehicle Description | fiat 500 |  |  |  |  | Total Mileage |  |  | 1420 |  | per mile | 12p
Authorized By |  |  |  |  |  | Total Reimbursement |  |  | 170.4
Date |  | [NAME] 1 | [NAME] 2 | [NAME] 3 | [NAME] 4 | [NAME] 5 | [NAME] 6 | Hours | [NAME] | Odometer End | Mileage | Reimbursement
2009-10-25 00:00:00 |  | Bethan | Chenga | Chenga | [NAME] | Bethan | martin |  |  |  | 200 | 24
2009-10-27 00:00:00 |  | [NAME] | Mario | Marcol |  |  |  |  |  |  | 185 | 22.2
 |  | Chenga |  |  |  |  |  |  |  |  | 35 | 4.2
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  | fred |  |  |  |  | 1000 | 120
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 |  | Totals | 1420 | 170.4
Spreadsheet: tracy_geaccone__40271__AEL 06 01
Sheet: Acct. Rec.

Azurix Europe Ltd
Summary Accounts Receivable Aging
June 2001
(USD thousands)
exchange rate |  | 1.556
 |  |  |  |  |  | Overdue |  | Overdue |  | Overdue |  | Overdue |  | Overdue >
Customer/Type |  | Balance |  | Current |  | 1 to 6 mths |  | 7 to 12 mths |  | 1 to 2 yrs |  | 2 to 3 yrs |  | 3 yrs
Unmeasured - instalments |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Unmeasured - summonsed |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Unmeasured - other |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Trade effluent |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Miscellaneous debt |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Measured debt |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
TOTAL
Others (in total)
Total current month
Total prior month
Spreadsheet: 181488d1348058137-sumifs-not-working-quite-right-sumifs-of-dates
Sheet: Sheet1

Date | £
2012-08-12 00:00:00 | 18 |  | METHOD 1
2012-01-01 00:00:00 | 56 |  | Month | 2012-01-01 00:00:00
2012-01-02 00:00:00 | 22 |  | [NAME] |  | (Not working)
2012-03-05 00:00:00 | 35
2012-03-01 00:00:00 | 4 |  | METHOD 2
2012-06-06 00:00:00 | 33 |  | Month | 2012-01-01 00:00:00
 |  |  | Formula 2
Spreadsheet: 877993d1724943660-xlookup-columns-based-on-random-text-search-book1
Sheet: Sheet1

Invested In | STOCK_NO |  | Stock Name | I need to X ookup the Stock_No
HDFC Bank Ltd | 1 |  | HDFC Bank Ltd.
Reliance Industries Ltd | 2 |  | Reliance Industries Ltd.
ICICI Bank Ltd | 3 |  | ICICI Bank Ltd.
Infosys Ltd | 4 |  | Infosys Ltd.
Larsen & Toubro Ltd | 5 |  | Larsen & Toubro Ltd.
ITC Ltd | 6 |  | ITC Ltd.
Tata Consultancy Services Ltd | 7 |  | Tata Consultancy Services Ltd.
Bharti Airtel Ltd | 8 |  | Bharti Airtel Ltd.
Axis Bank Ltd | 9 |  | Axis Bank Ltd.
State Bank of India | 10 |  | State Bank of India
Spreadsheet: michelle_lokay__26556__imbalsumm0012
Sheet: mewborne

 | [NAME]
 | 500174 |  | 53888 |  | 78060 |  | 78062
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 8697 | 6399 | 114 |  | 1543 | 1323 | 322 | 298
2 | 8009 | 6399 | 122 |  | 1620 | 1323 | 176 | 298
3 | 7276 | 6399 | 180 | 179 | 1545 | 1323 | 41 | 298
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24 |  |  |  |  |  |  |  |  |  |  | 377
25 |  |  |  |  |  |  |  |  |  |  | 725
26
27
28
29
30
31
2000-11-30 00:00:00 |  |  |  |  |  |  |  |  | 509425
2000-12-03 00:00:00
Spreadsheet: 798577d1664557627-sumproduct-arrays-different-size-match-new
Sheet: match-2arrays

UNMATCH |  | (check existing grades) |  | =SUMPRODUCT((1*ISNA(MATCH(A4&A5:A1000,E5:E10&F5:F10,0))=1)*(A5:A1000<>"")*1)
grade | location |  |  | type | grade
A | US |  |  | location | MX
A | DE |  |  | grade | A
B | MX |  |  | grade | B
C | US |  |  | location | US
D | DE |  |  | location | NL
a | MX |  |  | grade | C
F | US
A | DE
A | MX
B | FR
B | DE
D | MX
A | FR
B | US
Spreadsheet: 768960d1645212755-data-validation-troubles-using-list-2022-timesheet-validation-example
Sheet: JAN

 |  |  |  | Official Timesheet
Employee Name: |  |  |  |  |  | Period: |  | January 2022
Title/Department:
Sick Leave Used This Month: |  |  |  |  |  | Holiday Hours Used This Month:
Overtime Hours for This Month's Payroll: |  |  |  |  |  | Vacation Hours Used This Month:
DAY | IN | OUT | IN | OUT | DAY OF WORK PERIOD | ABSENCE TIME/CODE |  | TOTAL | TIME +/- 8 HRS | REASON + / - 8 HRS
1 |  |  |  |  | 6
2 |  |  |  |  | 7
 |  |  |  |  |  |  |  | HOURS REPORTED:
 |  |  |  |  |  |  |  | REG HOURS SCHEDULED: |  | 16
3 |  |  |  |  | 1
4 |  |  |  |  | 2
5 |  |  |  |  | 3
6 |  |  |  |  | 4
7 |  |  |  |  | 5
8 |  |  |  |  | 6
9 |  |  |  |  | 7
 |  |  |  |  |  |  |  | HOURS REPORTED:
 |  |  |  |  |  |  |  | REG HOURS SCHEDULED: |  | 40
10 |  |  |  |  | 1
11 |  |  |  |  | 2
12 |  |  |  |  | 3
13 |  |  |  |  | 4
14 |  |  |  |  | 5
15 |  |  |  |  | 6
16 |  |  |  |  | 7
 |  |  |  |  |  |  |  | HOURS REPORTED:
 |  |  |  |  |  |  |  | REG HOURS SCHEDULED: |  | 40
17 |  |  |  |  | 1
18 |  |  |  |  | 2
19 |  |  |  |  | 3
20 |  |  |  |  | 4
21 |  |  |  |  | 5
22 |  |  |  |  | 6
23 |  |  |  |  | 7
 |  |  |  |  |  |  |  | HOURS REPORTED:
 |  |  |  |  |  |  |  | REG HOURS SCHEDULED: |  | 40
24 |  |  |  |  | 1
25 |  |  |  |  | 2
26 |  |  |  |  | 3
27 |  |  |  |  | 4
28 |  |  |  |  | 5
29 |  |  |  |  | 6
30 |  |  |  |  | 7
 |  |  |  |  |  |  |  | HOURS REPORTED:
 |  |  |  |  |  |  |  | REG HOURS SCHEDULED: |  | 40
31 |  |  |  |  | 1
 |  |  |  |  | Total Regular Hours: |  |  |  |  | Total OT
Remaining Sick Leave |  |  |  |  | Remaining Vacation Time
 |  |  |  |  | Remaining Holiday Hours
Absence Codes
RT = Rescheduled Time |  |  | V = Vacation |  |  | Employee Signature |  |  |  | Date
FL = Funeral Leave |  |  | H = Holiday
PL = Paid Leave |  |  | J = Jury Duty
X = Unpaid Leave |  |  | SL = Sick Leave |  |  | Department Head Signature |  |  |  | Date
Spreadsheet: 219368d1362738896-combining-multiple-worksheets-fame
Sheet: Consolidated

3.059 | 3.017 | 3.1 | TIC | 27581 | 0.31 | 12269 | 0.47 | 2.25 |  | RANI | 1;1
3.554 | 3.533 | 3.57 | TIC | 4193 | 0.05 | 3532 | 0.14 | 1.19 |  | SURESH | 1;2
3.707 | 3.653 | 3.75 | TIC | 56270 | 0.64 | 26225 | 1.01 | 2.15 |  | KUMAR | 1;3
3.753 | 3.75 | 3.773 | TIC | 1924 | 0.02 | 2576 | 0.1 | 0.75 | V | RAVI | 1;4
3.054 | 3.027 | 3.11 | TIC | 32725 | 0.66 | 16333 | 0.98 | 2 |  | [NAME] | 2;1
3.193 | 3.16 | 3.227 | TIC | 10302 | 0.21 | 4624 | 0.28 | 2.23 |  | RAJU | 2;2
3.26 | 3.237 | 3.28 | TIC | 5036 | 0.1 | 2811 | 0.17 | 1.79 |  | KUMARI | 2;3
3.703 | 3.663 | 3.753 | TIC | 60364 | 1.21 | 28826 | 1.72 | 2.09 |  | SRINU | 2;4
3.01 | 3.003 | 3.027 | TIC | 2200 | 0.02 | 1344 | 0.04 | 1.64 |  | RAVI | 3;1
3.06 | 3.027 | 3.09 | TIC | 21333 | 0.22 | 10042 | 0.3 | 2.12 | V | RAJU | 3;2
3.354 | 3.343 | 3.377 | TIC | 2908 | 0.03 | 3659 | 0.11 | 0.79 |  | RAMU | 3;3
3.607 | 3.587 | 3.67 | TIC | 8897 | 0.09 | 3049 | 0.09 | 2.92 |  | KRISHNA | 3;4
Spreadsheet: 851617d1701805977-seeking-help-need-guidance-on-creating-a-dynamic-calendar-in-excel-with-categorized-tasks-2024-event-calendar
Sheet: Week View

 | ASSIGNMENTS | MONTH VIEW
 | Select Month: | Enter Year: | Select Week #:
 | January | 2024 | Week 1
 | WEEK VIEW
 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY
Spreadsheet: 144637d1331069327-values-in-an-index-example
Sheet: Sheet1

 | 0.3 | 0.35 | 0.4 | 0.45 | 0.5 | 0.55 | 0.6 |  |  | A | 4
2 | 0.39 | 0.433 | 0.473 | 0.509 | 0.543 | 0.573 | 0.587 |  |  | H | 0.36
3 | 0.274 | 0.309 | 0.342 | 0.374 | 0.406 | 0.437 | 0.466
4 | 0.207 | 0.235 | 0.261 | 0.289 | 0.318 | 0.346 | 0.374
4.5 | 0.183 | 0.208 | 0.232 | 0.258 | 0.285 | 0.311 | 0.339
5 | 0.164 | 0.187 | 0.209 | 0.232 | 0.258 | 0.287 | 0.31
6 | 0.135 | 0.154 | 0.172 | 0.192 | 0.214 | 0.236 | 0.261
7 | 0.114 | 0.13 | 0.145 | 0.163 | 0.177 | 0.202 | 0.224
8 | 0.098 | 0.112 | 0.126 | 0.14 | 0.154 | 0.175 | 0.195
9 | 0.0859 | 0.0981 | 0.1106 | 0.1233 | 0.1357 | 0.1543 | 0.1723
10 | 0.0763 | 0.0873 | 0.0986 | 0.1096 | 0.1207 | 0.1375 | 0.154
11 | 0.0687 | 0.0786 | 0.0887 | 0.0988 | 0.1088 | 0.124 | 0.1385
Spreadsheet: 783745d1655117729-trying-to-filter-sheet-so-it-only-shows-the-column-codes-against-the-product-codes-test-data
Sheet: Sheet1

RAW DATA BELOW |  |  | Column Codes
Product Code | Grand Total |  | AA1 | BB2 | CC3 | DD4 | EE5 | FF6 | GG7 | HH8 | JJ9 | KK10 | LL11
11111 | 3 |  |  | 1 |  |  |  |  |  | 1 |  |  | 1
22222 | 2 |  |  |  |  | 1 |  |  | 1
33333 | 4 |  |  |  | 1 |  | 1 |  |  | 1 |  | 1
What I would like it to look like below
Product Code | Grand Total | Column Codes
11111 | 3 | BB2 | HH8 | LL11
22222 | 2 | DD4 | GG7
33333 | 4 | CC3 | EE5 | HH8 | KK10
Spreadsheet: 768909d1645197106-making-a-capacity-model-to-derive-lead-time-sre-delivery-schedule-test
Sheet: Sheet1

PROJECT QUEUE & COMMITMENT SCHEDULE
HOURS PER DAY | 8
EFFECTIVENESS FACTOR
LAST UPDATED
[NAME]? | PROJECT TITLE | EQUIPMENT | CUSTOMER | QUOTE EXPIRATION | TIME TO COMPLETE TASK | ACTIVE NRE | PROJECT START | INITIAL DELIVERY DATE | DAILY CAPACITY | REAL TIME TO COMPLETE TASK | FINAL DELIVERY DATE | Weeks to EC Release after PO | Column1 | NOTES
Yes | a | a | a | TBD | 378 |  | 2022-02-18 00:00:00
No | b | b | b | 2022-02-23 00:00:00 | 314 |  | 2022-02-18 00:00:00
No | c | c | c | TBD | 10 |  | 2022-02-18 00:00:00
No | d | d | d | 2022-04-14 00:00:00 | 24 |  | 2022-02-18 00:00:00
No | e | e | e | 2022-03-26 00:00:00 | 240 |  | 2022-02-18 00:00:00
No | f | f | f | 2022-03-07 00:00:00 | 2 |  | 2022-02-18 00:00:00