tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 279294d1385059410-tweaking-a-excel-schedule-dockschedule_reply
Sheet: Data Entry

 | DATA ENTRY
 | TIME | DOOR | TRUCK NUMBER
 | 08:00:00 | 3 | DS00012
 | 09:00:00 | 3 | DS00012
 | 10:00:00 | 3 | DS00012
 | 11:00:00 | 6 | DS00015
 | 12:00:00 | 7 | DS00016
 | 13:00:00 | 8 | DS00017
 | 14:00:00 | 9 | DS00018
 | 15:00:00 | 10 | DS00019
 | 16:00:00 | 11 | DS00020
 | 17:00:00 | 12 | DS00021
 | 18:00:00 | 13 | DS00022
 | 19:00:00 | 14 | DS00023
 | 09:00:00 | 15 | DS00024
 | 21:00:00 | 16 | DS00025
 | 22:00:00 | 3 | DS00026
 | 23:00:00 | 5 | DS00027
Spreadsheet: a28d82ae-dec8-4c26-a1bf-7034ffa91078
Sheet: Elementi

Record | Appoggio1 | Appoggio2
mente
1
1
demente
mente
asso
mentecatto
a
mente geniale
malamente
d
r
ecc
Spreadsheet: kate_symes__18659__Palo
Sheet: DJ Palo Verde Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-02-16 00:00:00 |  | 407.5 | 9600 | 255.33 | 3000
 | 2001-02-15 00:00:00 |  | 407.5 | 9600 | 255.33 | 3000 | 429.36 | 8631 | 185.81 | 1490
 | 2001-02-14 00:00:00 |  | 260.6 | 15392 | 165.16 | 6200 | 368.89 | 6205 | 216.82 | 1085
 | 2001-02-13 00:00:00 |  | 204.61 | 28464 | 127.5 | 7152 | 213.1 | 4017 | 117.86 | 910
 | 2001-02-12 00:00:00 |  | 194.93 | 17552 | 141 | 4752 | 165.13 | 3805 | 115.9 | 481
 | 2001-02-11 00:00:00 |  | 153.75 | 112 | 150 | 56 | 134.71 | 1414 | 82.08 | 149 |  | 141.16 | 14856
 | 2001-02-10 00:00:00 |  | 150.49 | 27080 | 104.14 | 5240 | 140.81 | 430 | 173.37 | 178
 | 2001-02-09 00:00:00 |  | 150.65 | 32480 | 104.14 | 5240 | 171.89 | 2860 | 131.06 | 362
 | 2001-02-08 00:00:00 |  | 182.53 | 10624 | 115.29 | 7280 | 188.98 | 1327 | 99.67 | 694
 | 2001-02-07 00:00:00 |  | 165.65 | 16640 | 113.79 | 6040 | 170.48 | 1096 | 90.98 | 1046
 | 2001-02-06 00:00:00 |  | 156.9 | 18000 | 117.37 | 6400 | 125.6 | 1999 | 88.75 | 1161
 | 2001-02-05 00:00:00 |  | 151.48 | 12400 | 128.84 | 4400 | 113.86 | 1196 | 83.59 | 982
 | 2001-02-04 00:00:00 |  | 145 | 0 | 120 | 0 | 99.69 | 4662 | 101.68 | 220 |  | 128.84 | 13200
 | 2001-02-03 00:00:00 |  | 168.58 | 13568 | 128.08 | 4200 | 117.03 | 3689 | 99.69 | 1202
 | 2001-02-02 00:00:00 |  | 178.98 | 11968 | 128.08 | 4200 | 152.67 | 7590 | 120.57 | 710
 | 2001-02-01 00:00:00 |  | 239.7 | 15792 | 151.12 | 4208 | 156.7 | 4400 | 127.04 | 2339
 | 2001-01-31 00:00:00 |  | 258.52 | 12800 | 158.13 | 5192 | 175.35 | 3038 | 132 | 1931
 | 2001-01-30 00:00:00 |  | 244.66 | 12560 | 140.9 | 5400 | 178.19 | 3125 | 120.98 | 1446
 | 2001-01-29 00:00:00 |  | 252.84 | 13440 | 177.78 | 5400 | 183 | 4553 | 122.38 | 2433
 | 2001-01-28 00:00:00 |  | 207.5 | 800 | 185 | 200 | 150.26 | 3312 | 132.26 | 2111 |  | 177.78 | 16200
 | 2001-01-27 00:00:00 |  | 225.83 | 13200 | 141.8 | 2840 | 152.11 | 781 | 114.82 | 728
 | 2001-01-26 00:00:00 |  | 225.83 | 13200 | 141.75 | 2800 | 223.17 | 1850 | 161.11 | 180
 | 2001-01-25 00:00:00 |  | 231.78 | 13440 | 144.28 | 3040 | 153.9 | 2315 | 108.66 | 1079
 | 2001-01-24 00:00:00 |  | 222.84 | 13360 | 131.11 | 2880 | 136.45 | 2624 | 93.82 | 933
 | 2001-01-23 00:00:00 |  | 254.26 | 9200 | 143.99 | 4256 | 148.73 | 2079 | 105.08 | 1209
 | 2001-01-22 00:00:00 |  | 324.8 | 9200 | 164 | 2000 | 172.56 | 2925 | 139.79 | 2097
 | 2001-01-21 00:00:00 |  | 177.5 | 2400 | 124.55 | 2200 | 152.69 | 3900 | 141.53 | 2132 |  | 168.33 | 1800
 | 2001-01-20 00:00:00 |  | 452.36 | 4400 | 226.5 | 2000 | 232.31 | 2573 | 148.33 | 1359
 | 2001-01-19 00:00:00 |  | 452.36 | 4400 | 226.5 | 2000 | 273.28 | 6682 | 128.74 | 2093
 | 2001-01-18 00:00:00 |  | 379.51 | 8960 | 214.86 | 2800 | 279.1 | 6115 | 157.96 | 2108
 | 2001-01-17 00:00:00 |  | 220.81 | 12080 | 122 | 3800 | 232.88 | 4018 | 186.65 | 824
Spreadsheet: 701651d1603875217-how-to-add-sumifs-formula-to-express-time-value-example
Sheet: Costs - Estimated Summary

ESTIMATED SECURITY STAFF COSTS |  | AS AT
EVENT ID
EVENT
EVENT DATE
EVENT AREA | Ground Level, Level 1 and 4
POSITION | LEVEL | NUMBER | EST. HOURS | HOURLY/ DAILY | RATE | VALUE
Manager | External Doors - Arena Plaza |  | 38 | D
 | External Doors - Main Foyer |  |  | D
 | Arena Floor |  |  | D
 | Level 1 |  |  | D
 | Level 4 |  |  | D
 | Total
Supervisor | External Doors - Arena Plaza |  |  | H
 | External Doors - Main Foyer |  |  | H
 | Arena Floor |  |  | H
 | Level 1 |  |  | H
 | Level 4 |  |  | H
 | Total
Security Guard | External Doors - Arena Plaza |  |  | H
 | External Doors - Main Foyer |  |  | H
 | Arena Floor |  |  | H
 | Level 1 |  |  | H
 | Level 4 |  |  | H
 | Total
Control Room | Level 1 |  |  | H
ESTIMATED COST - PROMOTER  (on rostered hours)
ESTIMATED SECURITY COSTS - Level 2 & 3 |  | AS AT
EVENT
EVENT DATE
EVENT AREA | Level 2 and 3 Suites
POSITION | LEVEL | NUMBER | EST. HOURS | HOURLY/ DAILY | HOURLY RATE | VALUE
Manager | Level 2 |  |  | D
 | Level 3 |  |  | D
 | Total
Supervisor | Level 2 |  |  | H
 | Level 3 |  |  | H
 | Total
Security Guard | Level 2 |  |  | H
 | Level 3 |  |  | H
 | Total
ESTIMATED COST - ARENA  (on rostered hours)
ESTIMATED SECURITY COSTS - F&B |  | AS AT
EVENT
EVENT DATE
EVENT AREA | Ground Level, Level 1 and 4
POSITION | LEVEL | NUMBER | EST. HOURS | HOURLY/ DAILY | RATE | VALUE
Security Guard | Arena Floor |  |  | H
 | External Doors - Main Foyer |  |  | H
 | Level 1 |  |  | H
 | Level 4 |  |  | H
 | Total
ESTIMATED COST - ARENA (on rostered hours)
Spreadsheet: 68905d1269440390-excel-2007-index-and-match-question-lookup-sample-data
Sheet: Transfer

GuestLink | Asset Type Name | Asset Date | Itinerary Date Time | Itinerary Date Time To | jmcgallan | contaminated | romperstomper
3579 | Transfer - hotel to stadium | 2010-07-06 00:00:00 | 2010-07-06 00:00:00 | 2010-07-06 00:00:00
3579 | Transfer - hotel to stadium | 2010-07-07 00:00:00 | 2010-07-07 00:00:00 | 2010-07-07 00:00:00
3579 | Transfer - hotel to stadium | 2010-07-07 00:00:00 | 2010-07-07 00:00:00 | 2010-07-07 00:00:00
3579 | Transfer - hotel to stadium | 2010-07-11 00:00:00 | 2010-07-11 00:00:00 | 2010-07-11 00:00:00
3582 | Transfer - hotel to stadium | 2010-07-07 00:00:00 | 2010-07-07 00:00:00 | 2010-07-07 00:00:00
3582 | Transfer - hotel to stadium | 2010-07-11 00:00:00 | 2010-07-11 00:00:00 | 2010-07-11 00:00:00
4290 | Transfer - hotel to stadium | 2010-07-07 00:00:00 | 2010-07-07 00:00:00 | 2010-07-07 00:00:00
4290 | Transfer - hotel to stadium | 2010-07-11 00:00:00 | 2010-07-11 00:00:00 | 2010-07-11 00:00:00
12814 | Transfer - hotel to stadium | 2010-07-07 00:00:00 | 2010-07-07 00:00:00 | 2010-07-07 00:00:00
12814 | Transfer - hotel to stadium | 2010-07-11 00:00:00 | 2010-07-11 00:00:00 | 2010-07-11 00:00:00
12815 | Transfer - hotel to stadium | 2010-07-07 00:00:00 | 2010-07-07 00:00:00 | 2010-07-07 00:00:00
12815 | Transfer - hotel to stadium | 2010-07-11 00:00:00 | 2010-07-11 00:00:00 | 2010-07-11 00:00:00
12818 | Transfer - hotel to stadium | 2010-07-06 00:00:00 | 2010-07-06 00:00:00 | 2010-07-06 00:00:00
12818 | Transfer - hotel to stadium | 2010-07-07 00:00:00 | 2010-07-07 00:00:00 | 2010-07-07 00:00:00
12818 | Transfer - hotel to stadium | 2010-07-07 00:00:00 | 2010-07-07 00:00:00 | 2010-07-07 00:00:00
12818 | Transfer - hotel to stadium | 2010-07-11 00:00:00 | 2010-07-11 00:00:00 | 2010-07-11 00:00:00
12886 | Transfer - hotel to stadium | 2010-07-06 00:00:00 | 2010-07-06 00:00:00 | 2010-07-06 00:00:00
12886 | Transfer - hotel to stadium | 2010-07-07 00:00:00 | 2010-07-07 00:00:00 | 2010-07-07 00:00:00
12886 | Transfer - hotel to stadium | 2010-07-07 00:00:00 | 2010-07-07 00:00:00 | 2010-07-07 00:00:00
12886 | Transfer - hotel to stadium | 2010-07-11 00:00:00 | 2010-07-11 00:00:00 | 2010-07-11 00:00:00
12887 | Transfer - hotel to stadium | 2010-07-06 00:00:00 | 2010-07-06 00:00:00 | 2010-07-06 00:00:00
12887 | Transfer - hotel to stadium | 2010-07-07 00:00:00 | 2010-07-07 00:00:00 | 2010-07-07 00:00:00
12887 | Transfer - hotel to stadium | 2010-07-07 00:00:00 | 2010-07-07 00:00:00 | 2010-07-07 00:00:00
12887 | Transfer - hotel to stadium | 2010-07-11 00:00:00 | 2010-07-11 00:00:00 | 2010-07-11 00:00:00
12888 | Transfer - hotel to stadium | 2010-07-06 00:00:00 | 2010-07-06 00:00:00 | 2010-07-06 00:00:00
12889 | Transfer - hotel to stadium | 2010-07-06 00:00:00 | 2010-07-06 00:00:00 | 2010-07-06 00:00:00
Spreadsheet: 703816d1605186539-allocation-of-amount-between-dates-excel-forum-file-haroonkhurshid-
Sheet: Sheet2

 | Fund | A | B | C | D | E | F | G | H |  | Date Dif. | A | B | C | D | E | F | G | H
 | Total Shares Granted | 8000 | 8000 | 8000 | 8000 | 3000 | 3000 | 3000 | 3000
 | 2020-08-10 00:00:00
 | 2020-09-16 00:00:00 |  |  |  |  | 750 | 750 | 750 | 750
 | 2020-12-16 00:00:00 |  |  |  |  | 750 | 750 | 750 | 750
 | 2021-02-10 00:00:00 | 2000 | 2000 | 2000 | 2000
 | 2021-06-16 00:00:00 |  |  |  |  | 1500 | 1500 | 1500 | 1500
 | 2021-08-10 00:00:00 | 2000 | 2000 | 2000 | 2000
 | 2022-02-10 00:00:00 | 2000 | 2000 | 2000 | 2000
 | 2022-08-10 00:00:00 | 2000 | 2000 | 2000 | 2000
 | Months
Spreadsheet: 62976f90-eb1e-471c-831c-58d45a11eea2
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
24318378 | 2011-07-11 19:28:09 | ALLIES | 0 | 2 | 5 | 242664 | Nygaard | 8086 | western | 1944-08-09 |  | Battle of Mairy | [NAME]
24318601 | 2011-07-11 19:41:58 | AXIS | 0 | 1 | 5 | 242664 | Nygaard | 8086 | western | 1944-08-09 |  | Battle of Mairy | [NAME]
24318809 | 2011-07-11 19:57:17 | AXIS | 0 | 2 | 6 | 242664 | Nygaard | 8143 | pacific | 1938-03-12 | 1938-03-23 | Linyi Online | Linyi Online
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
24597078 | 2011-07-27 20:08:47 | AXIS | 0 | 4 | 7 | 242664 | Nygaard | 8163 | pacific | 1937-08-13 |  | [NAME] last charge Online | La dernière charge [NAME] Online
Spreadsheet: cd57ac3e-df17-4f4e-8e5c-d85378310dbf
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
3347 | 17339 | Wayne | E. | USA | 0 | 00:12:56 | 00:00:56 | 00:21:15 | 00:01:17 | 00:13:08 | 1 | 00:49:32
3347 | 8093 | [NAME] | [NAME] | USA | 0 | 00:17:21 | 00:02:12 | 00:00:02 | 00:00:00 | 00:42:48 | 2 | 01:02:23
Spreadsheet: 876737d1723474833-duplicating-same-times-to-different-sheet-schedule-making-weekly_employee_schedule_template-b1gjohn99-
Sheet: Cashiers Solo

SCHEDULE
NAME:
 | Start | Breaks | End | Hours
Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
TOTAL HOURS
Spreadsheet: 267233d1380023494-data-validation-of-a-formatted-cell-blank-stab-grid
Sheet: Stability

 |  |  |  | PLEASE COMPLETE BOOKCHECKING BEFORE STARTING MORE ANALYSIS
Product & Code(s) | Trial Number | Time Point & Condition | Date Off Test | Date Required | Days Overdue | Customer | Standard Times | Analyst | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | Date Testing Completed | Date Checked | Comments | Analyst Hours Req'd in Week | Week No | Year | 30-Day Notification Required? | 30-Day Notification Number | 30-Day Notification Completed? | Reason for Analysis being Overdue
Tablet 1 - 123 | EG1 | 1 week | 2013-09-24 00:00:00 | 2013-10-24 00:00:00 |  | Customer 1 | 12 |  | App | Weight | Dis | Hard | Id | Assay | Imps (LC) | Diss | Breakability | N/A | N/A | N/A | N/A | N/A | N/A |  |  |  | #N/A | #N/A | 2013 | N | 2013-06-06 00:00:00 | Y
Tablet 2 - 456 | EG2 | 2 weeks | 2013-09-24 00:00:00 | 2013-10-24 00:00:00 |  | Customer 2 | 12 |  | App | Weight | Dis | Hard | Id | Assay | Imps (LC) | Diss | Breakability | N/A | N/A | N/A | N/A | N/A | N/A |  |  |  | #N/A | #N/A | 2013 | N | 2013-06-06 00:00:00 | Y
Tablet 3 - 789 | EG3 | 3 weeks | 2013-08-24 00:00:00 | 2013-09-23 00:00:00 | 1 | Customer 1 | 12 |  | App | Moisture | Assay & Imps | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A |  |  |  | #N/A | #N/A | 2013 | N | 2013-06-06 00:00:00 | Y
 |  |  |  |  |  |  |  |  |  |  |  |  | The plan is to change the above cells (J3:X5) so that the test name is formatted automatically, and only the suffix will change. This will mean I only need one named range instead of several.
Spreadsheet: 235657d1368558355-cross-street-in-two-columns-sometimes-the-same-cross-streets-are-in-different-columns-street-name-counting
Sheet: Sheet1

STREET 1 | STREET 2
1st St | [NAME]
1st St | Broadway
1st St | [NAME]
1st St | [NAME]
1st St | [NAME]
1st St | [NAME]
2nd St | [NAME]
2nd St | Broadway
2nd St | [NAME]
2nd St | [NAME]
[NAME] | 1st St
Broadway | 1st St
[NAME] | 1st St
[NAME] | 1st St
[NAME] | 1st St
Broadway | 2nd St
[NAME] | 2nd St
Broadway | 2nd St
[NAME] | 2nd St
[NAME] | 2nd St
[NAME] | 2nd St
Broadway | 2nd St
[NAME] | 2nd St
Spreadsheet: 79722d1279906876-excel-2007-making-values-in-a-flexible-table-always-equal-a-certain-value-construction-cost-distribution
Sheet: Sheet1

 | INPUTS |  |  | Construction Cost Distribution
 | Periods | 7 |  | Period | Percentage | Output
 | Total Construction Cost | 8830021 |  | 0 | 0
 |  |  |  | 1 | 0.05
 |  |  |  | 2 | 0.15
 |  |  |  | 3 | 0.2
 |  |  |  | 4 | 0.15
 |  |  |  | 5 | 0.1
 |  |  |  | 6 | 0.15
 |  |  |  | 7 | 0.2
 |  |  |  | TOTAL
Spreadsheet: benjamin_rogers__1066__NewCo-7-15-00
Sheet: FPLE_Debt

 | FPLE Debt Issuance - Merchant
 | ('000 $)
 | Treasury (%) |  |  | 0.065
 | Spread (%) |  |  | 0.03
 | All In Coupon Rate (%)
 | Coverage |  |  | 2.5
 | Tax Rate |  |  | 0.385
 |  |  |  | 2001
 | EBITDA from plants
 | Less: Existing Debt Service
 | Plus: Revenue to FPLE (Fees & Interests)
 | Base for DSCR
 | Coverage Ratio |  |  |  | 2.2 | 2.2 | 2.5 | 2.5 | 2.5 | 2.5 |  |  |  | 2.8 | 2.8
 | Annual Debt Service
 | Beginning Balance |  |  | 658933.0679990059
 | [NAME]
 | Ending Balance
 | Interest Expense
 | Aftertax Interest Expense
 | Cash Flow Available for Equity
 | Resultant Coverage
 | Interest Tax Shield
 | NPV @
 | FPLE Debt Issuance - Contract
 | Treasury (%) |  |  | 0.062
 | Spread (%) |  |  | 0.025
 | All In Coupon Rate (%)
 | Coverage |  |  | 1.75
 | Tax Rate |  |  | 0.385
 |  |  |  | 2001
 | EBITDA from plants
 | Less: Existing Debt Service
 | Plus: Revenue to FPLE (Fees & Interests)
 | Plus: [NAME] paid to FPLE
 | Base for DSCR
 | Coverage Ratio
 | Annual Debt Service
 | Beginning Balance |  |  | 874660.6112659347
 | [NAME]
 | Ending Balance
 | Interest Expense
 | Aftertax Interest Expense
 | Cash Flow Available for Equity
 | Resultant Coverage
 | Interest Tax Shield
 | NPV @
 | Total PV of Tax Shield |  |  |  |  | Average Life
 |  |  |  |  |  | Merchant Assets
 |  |  |  |  |  | Contract Assets
 | Time Factor
 |  |  |  |  |  | Check
 | Implied State Tax Rate |  |  | 0.05384615384615388
Spreadsheet: 783880d1655269947-for-saturday-and-sunday-i-want-no-change-in-values-book2-5-ans
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  | Expected Results
 |  |  |  |  |  | Monday | 100
 |  |  |  |  |  | Tuesday
 |  |  |  |  |  | Wednesday
 |  |  |  |  |  | Thursday
 |  |  |  |  |  | Friday
 |  |  |  |  |  | Saturday
 |  |  |  |  |  | Sunday
 |  |  |  |  |  | Monday
 |  |  |  |  |  | Tuesday
 |  |  |  |  |  | Wednesday
 |  |  |  |  |  | Thursday
 |  |  |  |  |  | Friday
 |  |  |  |  |  | Saturday
 |  |  |  |  |  | Sunday
 |  |  |  |  |  | Monday
 |  |  |  |  |  | Tuesday
 |  |  |  |  |  | Wednesday
 |  |  |  |  |  | Thursday
 |  |  |  |  |  | Friday
 |  |  |  |  |  | Saturday
 |  |  |  |  |  | Sunday
 |  |  |  |  |  | Monday
 |  |  |  |  |  | Tuesday
 |  |  |  |  |  | Wednesday
 |  |  |  |  |  | Thursday
 |  |  |  |  |  | Friday
 |  |  |  |  |  | Saturday
 |  |  |  |  |  | Sunday
 |  |  |  |  |  | Monday
 |  |  |  |  |  | Tuesday
 |  |  |  |  |  | Wednesday
 |  |  |  |  |  | Thursday
 |  |  |  |  |  | Friday
Spreadsheet: eric_saibi__9825__092701R
Sheet: Navajo 03

Owner Name | Salt River Project Agricultural Improvement
Station Name | Navajo Power Station
Unit Name | Navajo 03
NERC Region | WSCC
State | AZ
Fuel Type | Coal
Capacity | 803 MW
Start Date | 2001-09-23 00:00:00
End Date | 2001-09-27 00:00:00
Prv. Start Date | 2001-09-23 00:00:00
Prv. End Date | 2001-09-25 00:00:00
Comments | Boiler Tube Leak
SIC | 4911
Plant ID | 1015877
Unit ID | 1007206
Outage ID | 9526
Spreadsheet: 121093d1315842296-populating-a-new-grid-matrix-from-multiple-min-max-numbers-identifying-missing-values
Sheet: Sheet2

Category | From | To
 |  |  |  | Category | From | To | A | B | C | D | E | F | G
 |  |  |  | A | 1001 | 1010
 |  |  |  | A | 1011 | 1018
 |  |  |  | A | 1020 | 1034
 |  |  |  | A | 1040 | 1051
 |  |  |  | A | 1055 | 1078
 |  |  |  | A | 1081 | 1098
 |  |  |  | A | 1100 | 1149
 |  |  |  | A | 1150 | 1169
 |  |  |  | A | 1170 | 1184
 |  |  |  | B | 1005 | 1009
 |  |  |  | B | 1010 | 1029
 |  |  |  | B | 1030 | 1048
 |  |  |  | B | 1050 | 1068
 |  |  |  | B | 1070 | 1080
 |  |  |  | B | 1084 | 1100
 |  |  |  | B | 1108 | 1120
 |  |  |  | C | 1001 | 1020
 |  |  |  | C | 1022 | 1030
 |  |  |  | C | 1031 | 1040
 |  |  |  | C | 1044 | 1059
 |  |  |  | D | 1020 | 1038
 |  |  |  | D | 1041 | 1060
 |  |  |  | D | 1061 | 1080
 |  |  |  | E | 1001 | 1010
 |  |  |  | E | 1006 | 1021
 |  |  |  | E | 1025 | 1040
 |  |  |  | E | 1041 | 1067
 |  |  |  | E | 1070 | 1088
 |  |  |  | E | 1090 | 1110
 |  |  |  | E | 1111 | 1130
 |  |  |  | E | 1132 | 1150
 |  |  |  | F | 1000 | 1040
 |  |  |  | G | 1000 | 1019
 |  |  |  | G | 1020 | 1044
 |  |  |  | G | 1049 | 1061
 |  |  |  | G | 1064 | 1090
 |  |  |  | G | 1091 | 1100
Spreadsheet: 168325d1342402273-a-complicated-look-up-table-with-multiple-conditions-copy-of-complex-look-up-alternative
Sheet: LookUP Data

Month | XX | XX | XX | Brand Text | Product Text | XX | [NAME] | Net  Sales
1.2012 |  |  |  | Z9002 | XCVDG^ |  | TM72006 | 10
1.2012 |  |  |  | Z9002 | [NAME] |  | TM72006 | 50
1.2012 |  |  |  | [NAME] | XCVD^& |  | TM72001 | 40
1.2012 |  |  |  | [NAME] | XCC&^* |  | TM72001 | 45
1.2012 |  |  |  | X&^% | [NAME] |  | TM72004 | 26
1.2012 |  |  |  | X^&%$ | [NAME] |  | TM72004 | 27
1.2012 |  |  |  | ZA9003 | ZMA00 |  | TM72001 | 28
1.2012 |  |  |  | X&^%SS | ZMA00 |  | TM72001 | 35
1.2012 |  |  |  | Reusable Tips | X&^% |  | TM72006 | 31
1.2012 |  |  |  | Reusable Tips | X^&%$ |  | TM72006 | 33
1.2012 |  |  |  | Disposable Tips | ZA9003 |  | TM72006 | 38
1.2012 |  |  |  | Disposable Tips | X&^%SS |  | TM72006 | 36
1.2012 |  |  |  | Sovereign Accessories | XCVD^& |  | TM72001 | 34
1.2012 |  |  |  | WhiteStar Signature | XCC&^* |  | TM72001 | 32
2.2012 |  |  |  | Z9002 | XCVDG^ |  | TM72006 | 10
2.2012 |  |  |  | Z9002 | [NAME] |  | TM72006 | 50
2.2012 |  |  |  | [NAME] | XCVD^& |  | TM72001 | 40
2.2012 |  |  |  | [NAME] | XCC&^* |  | TM72001 | 45
2.2012 |  |  |  | X&^% | [NAME] |  | TM72004 | 29
2.2012 |  |  |  | X^&%$ | [NAME] |  | TM72004 | 27
2.2012 |  |  |  | ZA9003 | ZMA00 |  | TM72001 | 40
2.2012 |  |  |  | X&^%SS | ZMA00 |  | TM72001 | 35
2.2012 |  |  |  | Reusable Tips | X&^% |  | TM72006 | 31
2.2012 |  |  |  | Reusable Tips | X^&%$ |  | TM72006 | 33
2.2012 |  |  |  | Disposable Tips | ZA9003 |  | TM72006 | 40
2.2012 |  |  |  | Disposable Tips | X&^%SS |  | TM72006 | 36
2.2012 |  |  |  | Sovereign Accessories | XCVD^& |  | TM72001 | 34
2.2012 |  |  |  | WhiteStar Signature | XCC&^* |  | TM72001 | 32
Spreadsheet: 549762d1511900814-insert-new-row-before-sub-total-addrow
Sheet: Sheet1

Date | Item | Price | Sub Total
2017-11-03 00:00:00 | Widget | 125
2017-11-04 00:00:00 | Widget | 25
2017-11-05 00:00:00 | Widget | 458.2
2017-11-06 00:00:00 | Widget | 41.5
2017-11-07 00:00:00 | Widget | 62
2017-11-08 00:00:00 | Widget | 485
2017-11-09 00:00:00 | Widget | 120
2017-11-10 00:00:00 | Widget | 600
Spreadsheet: 87633d1287514211-data-sorting-grouping-function-sample-for-excel-forum
Sheet: Sheet2

A03 Learner Ref Number | A09 Learning Aim Ref | Learning_Aim_Title | A26 Framework Code | A15 Programme Type | A27 Learning Start Date | A28 Learning Planned End Date | A31 Learning Actual End Date | L09 | L10
4056761 | 10053098 | NVQ in Business and Administration | 102 | 3 | 2010-02-22 00:00:00 | 2010-09-30 00:00:00 | 2010-07-14 00:00:00 | Hoyle | Kerry
4056761 | 10002856 | Key Skills in Application of Number - level 1 | 102 | 3 | 2010-01-15 00:00:00 | 2010-09-30 00:00:00 |  | Hoyle | Kerry
4056761 | 10002881 | Key Skills in Communication - level 2 | 102 | 3 | 2010-01-15 00:00:00 | 2010-09-30 00:00:00 |  | Hoyle | Kerry
4056761 | 10052148 | Certificate in Business and Administration (Organisations and People) | 102 | 3 | 2010-01-15 00:00:00 | 2010-09-30 00:00:00 | 2010-02-11 00:00:00 | Hoyle | Kerry
4056761 | ZPROG001 | Generic code to identify ILR programme aims | 102 | 3 | 2010-01-15 00:00:00 | 2010-09-30 00:00:00 |  | Hoyle | Kerry
21022464 | 10053098 | NVQ in Business and Administration | 102 | 3 | 2010-02-09 00:00:00 | 2010-09-30 00:00:00 |  | [NAME] | Anne-Marie
21022464 | 10002856 | Key Skills in Application of Number - level 1 | 102 | 3 | 2009-12-15 00:00:00 | 2010-09-30 00:00:00 | 2010-09-02 00:00:00 | [NAME] | Anne-Marie
21022464 | 10002881 | Key Skills in Communication - level 2 | 102 | 3 | 2009-12-15 00:00:00 | 2010-09-30 00:00:00 | 2010-09-02 00:00:00 | [NAME] | Anne-Marie
21022464 | 10052148 | Certificate in Business and Administration (Organisations and People) | 102 | 3 | 2009-12-15 00:00:00 | 2010-09-30 00:00:00 | 2010-01-20 00:00:00 | [NAME] | Anne-Marie
21022464 | ZPROG001 | Generic code to identify ILR programme aims | 102 | 3 | 2009-12-15 00:00:00 | 2010-09-30 00:00:00 |  | [NAME] | Anne-Marie
21022945 | 10053098 | NVQ in Business and Administration | 102 | 3 | 2010-01-20 00:00:00 | 2010-09-30 00:00:00 | 2010-08-04 00:00:00 | Cobourn | [NAME]
21022945 | 10002832 | Key Skills in Application of Number - level 2 | 102 | 3 | 2009-09-14 00:00:00 | 2010-09-30 00:00:00 | 2010-09-02 00:00:00 | Cobourn | [NAME]
21022945 | 10002881 | Key Skills in Communication - level 2 | 102 | 3 | 2009-09-14 00:00:00 | 2010-09-30 00:00:00 | 2010-09-02 00:00:00 | Cobourn | [NAME]
21022945 | 10052148 | Certificate in Business and Administration (Organisations and People) | 102 | 3 | 2009-09-14 00:00:00 | 2010-09-30 00:00:00 | 2009-11-24 00:00:00 | Cobourn | [NAME]
21022945 | ZPROG001 | Generic code to identify ILR programme aims | 102 | 3 | 2009-09-14 00:00:00 | 2010-09-30 00:00:00 | 2010-08-04 00:00:00 | Cobourn | [NAME]
Spreadsheet: 159724d1338826935-eliminating-duplicates-from-count-pt-count-eliminating-duplicates
Sheet: Sheet1

 |  |  | EMLOYEE | DATES | HRS
 |  |  | GOULD | 2012-01-01 00:00:00 | 2 |  |  |  | Row Labels | Sum of HRS
 |  |  | GOULD | 2012-01-02 00:00:00 | 2 |  |  |  | CARROLL | 5
 |  |  | GOULD | 2012-01-03 00:00:00 | 2 |  |  |  | DOE | 6
 |  |  | SMITH | 2012-01-01 00:00:00 | 4 |  |  |  | GOULD | 6
 |  |  | SMITH | 2012-01-02 00:00:00 | 4 |  |  |  | SMITH | 14
 |  |  | SMITH | 2012-01-13 00:00:00 | 3 |  |  |  | Grand Total | 31
 |  |  | SMITH | 2012-01-04 00:00:00 | 2
 |  |  | SMITH | 2012-01-05 00:00:00 | 1
 |  |  | DOE | 2012-01-01 00:00:00 | 6
 |  |  | CARROLL | 2012-01-01 00:00:00 | 5
 |  |  | What I would like to see is
 |  |  | TOTAL EMPLOYEES W/O DUPLICATES |  |  |  | 4
 |  |  | TOTAL HOURS (COUNTS DUPLICATES) |  |  |  | 31
 |  |  | GOULD |  |  | 6
 |  |  | SMITH |  |  | 14
 |  |  | DOE |  |  | 6
 |  |  | CARROLL |  |  | 5