tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 07f7f649-4107-42fe-bf81-8a7592abc3ee
Sheet: 4X2

LIGHT TRUCKS, LESS THAN 12,500 GVWR, 2-WHEEL DRIVE ([NAME])
 | Equip. | Federal | 2014 Monthly | 2014 Mileage
Vehicle Description | Code | Std. Item | Rate | Rate
[NAME], Cargo (Electric) | 4109 | 30E | 204 | 0.077
Van, Cargo | 4110 | 30 | 204 | 0.195
Van, Passenger | 4115 | 20, 20C, 20Z | 214 | 0.195
Compact Pickup, [NAME] | 4121 | 61C | 197 | 0.185
Compact Pickup, [NAME] | 4122 | 61E | 200 | 0.185
Standard Pickup, Regular Cab | 4150 | 41, 41Z | 197 | 0.185
Sport Utility | 4181 | 91 | 277 | 0.21
SUV, Crossover, 4-door | 4182 | 91B | 277 | 0.21
Sports Utility, 4-door | 4194 | 98, 98A | 188 | 0.185
Van, Cargo | 4210 | 31, 31Z | 222 | 0.23
Van, Passenger | 4215 | 21, 21J | 230 | 0.23
Sport Utility, Special Services | 4221 | 100L | 310 | 0.255
Standard Pickup, Regular Cab | 4250 | 41, 42, 42Z | 200 | 0.24
Standard Pickup, [NAME] | 4251 | 41C | 206 | 0.24
[NAME], [NAME] | 4252 | 50, 50Z | 225 | 0.24
[NAME], [NAME] Special Services | 4255 | 50C | 259 | 0.25
[NAME], 4-door, Special Services* | 4272 | 101C | 296 | 0.25
Sport Utility, 4-Door | 4275 | 100B, 100C | 287 | 0.24
Sport Utility, 4-Door | 4276 | 101 | 301 | 0.24
Sport Utility, 4-Door | 4279 | 100A, 104J | 267 | 0.24
Van, Cargo | 4310 | 32, 32Z, 34, 34N | 252 | 0.23
Van, Maint. Conversion | 4313 | 162 | 252 | 0.23
Van, Passenger | 4315 | 22, 24, 21J, 22J, 23J, 24J | 260 | 0.23
Pickup, Regular Cab | 4350 | 44, 44A, 44B | 238 | 0.25
Pickup, [NAME] | 4351 | 44C, 44D, 44E | 244 | 0.25
Pickup, [NAME] | 4352 | 51C, 52, 54 | 258 | 0.25
Service Utility | 4355 | 82, 83, 84 | 258 | 0.26
Service Utility, [NAME] | 4356 | 141, 142, 144 | 301 | 0.26
Service Utility, [NAME] | 4357 | 82C, 83C, 84C | 276 | 0.26
[NAME], [NAME] | 4360 | 52A | 265 | 0.26
Van, Cargo | 4364 | 95, 95Z | 276 | 0.22
Delivery Van, Cut-off Cab | 4365 | 92, 94 | 297 | 0.285
Multistop Van (FC) Truck | 4366 | 134 | 297 | 0.285
Chassis & Regular Cab | 4370 | 73, 74, 74A | 258 | 0.26
Chassis & Crew Cab | 4371 | 73E, 74E | 274 | 0.26
Chassis & Extended Cab | 4372 | 74C | 269 | 0.26
4x2 Flightline Van (Ford E350) | 4374 | 92F | 276 | 0.23
Chassis & Cutaway Cab | 4376 | 75 | 196 | 0.26
Stake, Regular Cab | 4380 | 122, 123, 124 | 258 | 0.26
Stake, [NAME] | 4381 | 122C, 122E, 123E, 124E | 287 | 0.26
Stake, [NAME] | 4382 | 123C, 124C | 274 | 0.26
Dump Truck | 4390 | 154, 154Q | 258 | 0.26
Spreadsheet: 811255d1672380383-vlookup-in-multiple-column-vlookup_multiplecolumns
Sheet: Data

Center | Area | Location
0001 | 0001 | 100
0001 | 0088 | 001
0001 | 0100 | 001
2000 | 0003 | 801
2000 | 0004 | 803
2048 | 0003 | 248
2048 | 0004 | 248
2048 | 0005 | 249
2048 | 0006 | 248
2048 | 0008 | 255
2048 | 0009 | 248
2048 | 0010 | 248
2048 | 0011 | 266
2048 | 0015 | 248
2048 | 0016 | 248
Spreadsheet: 29213d1224082141-sorting-a-table-by-numbers-pooldarts-league
Sheet: Fixtures & Results

Week 1 |  |  |  |  |  | Week 4 |  |  |  |  |  | Week 7 |  |  |  |  |  | Week 10
[NAME] | 4 | vs. | 2 | [NAME] |  | [NAME] | 3 | vs. | 3 | [NAME] |  | [NAME] | 3 | vs. | 3 | [NAME] |  | [NAME] | 3 | vs. | 3 | [NAME]
Macca | 4 | vs. | 2 | [NAME] |  | Macca | 3 | vs. | 3 | [NAME] |  | Macca | 3 | vs. | 3 | [NAME] |  | Macca | 3 | vs. | 3 | [NAME]
Week 2 |  |  |  |  |  | Week 5 |  |  |  |  |  | Week 8 |  |  |  |  |  | Week 11
[NAME] | 4 | vs. | 2 | [NAME] |  | [NAME] | 3 | vs. | 3 | [NAME] |  | [NAME] | 3 | vs. | 3 | [NAME] |  | [NAME] | 3 | vs. | 3 | [NAME]
Macca | 4 | vs. | 2 | [NAME] |  | Macca | 3 | vs. | 3 | [NAME] |  | Macca | 3 | vs. | 3 | [NAME] |  | Macca | 3 | vs. | 3 | [NAME]
Week 3 |  |  |  |  |  | Week 6 |  |  |  |  |  | Week 9 |  |  |  |  |  | Week 12
[NAME] | 4 | vs. | 2 | Macca |  | [NAME] | 3 | vs. | 3 | Macca |  | [NAME] | 3 | vs. | 3 | Macca |  | [NAME] | 3 | vs. | 3 | Macca
[NAME] | 4 | vs. | 2 | [NAME] |  | [NAME] | 3 | vs. | 3 | [NAME] |  | [NAME] | 3 | vs. | 3 | [NAME] |  | [NAME] | 3 | vs. | 3 | [NAME]
Spreadsheet: 871535d1717987099-skills-matrix-help-skills-matrix-help
Sheet: On Shift

List of employee logins. | Skill A | Skill B | Skill C | Skill D | Skill E | [NAME] | [NAME] | [NAME] | Skill I
Login2
Login10
Login15
Spreadsheet: mary_fischer__25617__37D
Sheet: E8.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 037D
COMPANY NAME     Artemis Fair Value
ANALYSIS OF OTHER DEFERRED CHARGES
FOR THE PERIOD ENDING 6-30-2001
PREPARED BY: [NAME]
EXTENSION: 52580 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  | 12-31-2000 Balance |  |  |  | Charged to |  | Transfer / Reclasses
[NAME] |  | DR. (CR.) |  | Cash Pd / (Rec'd) |  | Income Statement |  | Amount |  | Hyperion Acct. # |  | DR. (CR.)
 |  | BEGINNING BALANCE |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | to / from |  | ENDING BALANCE |  | COMMENTS
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Work in Progress:
 |  | 0
Total  (Hyperion Line 0343)
Asset/Expense Accts:  DR/(CR)
Other Deferred Charges:
[NAME] |  | 10489
Total (Hyperion line 360)
Asset/Expense Accts:  DR/(CR)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 818112d1676595740-formula-to-setup-biweekly-pay-period-in-excel-1910-pay-period-dates
Sheet: Holidays

The most common (Federal) holidays of the United States (USA) in 2023 are listed below.
Date | Holiday | Day | Days to go
2023-01-01 00:00:00 | New Year's Day | Sunday | -
2023-01-16 00:00:00 | [NAME] | Monday | -
2023-01-24 00:00:00 | Belly Laugh Day | Tuesday | -
2023-02-02 00:00:00 | Groundhog Day | Thursday | -
2023-02-12 00:00:00 | Lincoln's Birthday | Sunday | -
2023-02-14 00:00:00 | [NAME]'s Day | Tuesday | -
2023-02-20 00:00:00 | Presidents Day and Washington's Birthday | Monday | 5
2023-02-21 00:00:00 | [NAME] | Tuesday | 6
2023-03-12 00:00:00 | Daylight Saving | Sunday | 25
2023-03-17 00:00:00 | St. Patrick's Day | Friday | 30
2023-04-01 00:00:00 | April Fool's Day | Saturday | 45
2023-04-07 00:00:00 | Good Friday | Friday | 51
2023-04-09 00:00:00 | Easter | Sunday | 53
2023-04-10 00:00:00 | Easter Monday | Monday | 54
2023-04-22 00:00:00 | Earth Day | Saturday | 66
2023-05-05 00:00:00 | Cinco de Mayo | Friday | 79
2023-05-14 00:00:00 | Mother's Day | Sunday | 88
2023-05-20 00:00:00 | Armed Forces Day | Saturday | 94
2023-05-28 00:00:00 | Pentecost | Sunday | 102
2023-05-29 00:00:00 | Memorial Day | Monday | 103
2023-05-29 00:00:00 | Pentecost Monday | Monday | 103
2023-06-14 00:00:00 | Flag Day | Wednesday | 119
2023-06-18 00:00:00 | Father's Day | Sunday | 123
2023-07-04 00:00:00 | Independence Day | Tuesday | 139
2023-07-23 00:00:00 | Parents' Day | Sunday | 158
2023-09-04 00:00:00 | Labor Day | Monday | 201
2023-09-10 00:00:00 | Grandparents' Day | Sunday | 207
2023-09-11 00:00:00 | Patriot Day or September 11th | Monday | 208
2023-09-16 00:00:00 | Stepfamily Day | Saturday | 213
2023-09-17 00:00:00 | Citizenship Day | Sunday | 214
2023-09-22 00:00:00 | Native American Day | Friday | 219
2023-10-09 00:00:00 | Columbus Day | Monday | 236
2023-10-16 00:00:00 | Boss's Day | Monday | 243
2023-10-21 00:00:00 | Sweetest Day | Saturday | 248
2023-10-31 00:00:00 | Halloween | Tuesday | 258
2023-11-05 00:00:00 | Daylight Saving | Sunday | 263
2023-11-11 00:00:00 | Veterans' Day | Saturday | 269
2023-11-23 00:00:00 | Thanksgiving | Thursday | 281
2023-11-24 00:00:00 | Black Friday | Friday | 282
2023-11-27 00:00:00 | Cyber Monday | Monday | 285
2023-12-07 00:00:00 | Pearl Harbor Remembrance Day | Thursday | 295
2023-12-25 00:00:00 | Christmas Day | Monday | 313
2023-12-31 00:00:00 | New Year's Eve | Sunday | 319
Spreadsheet: phillip_platter__31372__ca0912epmib
Sheet: EES_Load

EES
NP15 | Total | 100 | 200 | 300 | 400 | 500 | 600 | 700 | 800 | 900 | 1000 | 1100 | 1200 | 1300 | 1400 | 1500 | 1600 | 1700 | 1800 | 1900 | 2000 | 2100 | 2200 | 2300 | 2400
Reported Load (-)
Enpower EESI
Enpower ENRONENEMA
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
Total
SP15 | Total | 100 | 200 | 300 | 400 | 500 | 600 | 700 | 800 | 900 | 1000 | 1100 | 1200 | 1300 | 1400 | 1500 | 1600 | 1700 | 1800 | 1900 | 2000 | 2100 | 2200 | 2300 | 2400
Reported Load (-)
Enpower EESI
Enpower ENRONENEMA
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
Total
ZP26 | Total | 100 | 200 | 300 | 400 | 500 | 600 | 700 | 800 | 900 | 1000 | 1100 | 1200 | 1300 | 1400 | 1500 | 1600 | 1700 | 1800 | 1900 | 2000 | 2100 | 2200 | 2300 | 2400
Reported Load (-)
Enpower EESI
Enpower PG&EENESER
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
SCTrade
Total
Spreadsheet: 31712d1227642693-data-in-columns-to-rows-not-transpose-whatiwanttodo
Sheet: Sheet1

THIS IS MY SOURCE DATA I NEED TO CLEAN UP
Jan 1 - Dec 31 2009 | [NAME] | Mon | Tue | Wed | Thu | Fri | Sat | Sun
Jan 7 - Jan 13 | 2009-01-07 00:00:00 | 49 | 50 | 54 | 54 | 40 | 41 | 36
Jan 14 - Jan 20 | 2009-01-14 00:00:00 | 49 | 61 | 56 | 47 | 34 | 42 | 42
Jan 21 - Jan 27 | 2009-01-21 00:00:00 | 40 | 60 | 56 | 58 | 71 | 64 | 31
Jan 28 - Feb 3 | 2009-01-28 00:00:00 | 39 | 42 | 51 | 73 | 83 | 82 | 45
Feb 4 - Feb 10 | 2009-02-04 00:00:00 | 62 | 97 | 78 | 70 | 55 | 70 | 51
Feb 11 - Feb 17 | 2009-02-11 00:00:00 | 45 | 62 | 79 | 72 | 82 | 79 | 50
Feb 18 - Feb 24 | 2009-02-18 00:00:00 | 59 | 68 | 57 | 63 | 71 | 64 | 42
Feb 25 - Mar 2 | 2009-02-25 00:00:00 | 44 | 52 | 64 | 70 | 73 | 64 | 50
[NAME] 9 | 2009-03-04 00:00:00 | 57 | 82 | 95 | 87 | 99 | 89 | 71
[NAME] 16 | 2009-03-11 00:00:00 | 83 | 91 | 103 | 104 | 102 | 109 | 100
[NAME] 23 | 2009-03-18 00:00:00 | 104 | 71 | 79 | 72 | 92 | 89 | 78
THIS IS HOW I WOULD WANT IT TO BE
2009-01-07 00:00:00 | 54
2009-01-08 00:00:00 | 54
2009-01-09 00:00:00 | 40
2009-01-10 00:00:00 | 41
2009-01-11 00:00:00 | 36
2009-01-12 00:00:00 | 49 |  |  | I do not need to convert the text format dates above into Excel date format, I can do this manually.
2009-01-13 00:00:00 | 50
2009-01-14 00:00:00 | 56
2009-01-15 00:00:00 | 47
2009-01-16 00:00:00 | 34
2009-01-17 00:00:00 | 42
2009-01-18 00:00:00 | 42
2009-01-19 00:00:00 | 49
2009-01-20 00:00:00 | 61
2009-01-21 00:00:00 | 56
2009-01-22 00:00:00 | 58
2009-01-23 00:00:00 | 71
2009-01-24 00:00:00 | 64
2009-01-25 00:00:00 | 31
2009-01-26 00:00:00 | 40
2009-01-27 00:00:00 | 60
2009-01-28 00:00:00 | 51
2009-01-29 00:00:00 | 73
2009-01-30 00:00:00 | 83
2009-01-31 00:00:00 | 82
2009-02-01 00:00:00 | 45
2009-02-02 00:00:00 | 39
2009-02-03 00:00:00 | 42
 | #N/A
 | #N/A
Spreadsheet: 883617d1732238425-need-monthly-totals-but-only-at-the-top-of-each-month-book1_r1
Sheet: The Haven

Payments |  |  |  | Paid Total |  | Invoices |  |  |  |  | Invoiced Total |  | Diff
Date | Amount | Bank | Monthly |  |  | Date | Amount | Invoice # | Period | Charged For
2024-11-05 00:00:00 | 1700 | VA |  |  |  | 2024-10-31 00:00:00 | 111.61 | 1272 | 10/31/24-10/31/24 | Rent - AL Private
2024-11-13 00:00:00 | 1871.61 | GEFCU |  |  |  | 2024-10-31 00:00:00 | 15.32 | 1273 | 10/31/24-10/31/24 | Care Fees - AL - Level 1
 |  |  |  |  |  | 2024-11-01 00:00:00 | 3460 | 1273 | 11/01/24-11/30/24 | Rent - AL Private
 |  |  |  |  |  | 2024-11-01 00:00:00 | 475 | 1273 | 11/01/24-11/30/24 | Care Fees - AL - Level 1
Spreadsheet: 0ee88061-a8d1-44a3-a2a5-44b56c5c79a5
Sheet: Sheet1

CONTACT:
[NAME]
PA Department of Education
Division of Data Services
333 Market Street
Harrisburg, PA  17126-0333
[NAME]:  [EMAIL]
Phone:  (717) 787-2644
Fax:  (717) 787-3148
Text Telephone TTY:  (717) 783-8445
This workbook contains 2006-07 enrollments for all publicly funded schools in Pennsylvania as reported by school districts, area vocational-technical schools, charter schools, special program jointures, and state-operated educational facilities.  Local education agencies were asked to report those students who were enrolled and attending as of October 1, 2006.  Additionally, counts of students attending education classes on a full-time basis outside their parents' district of residence were obtained from the Bureau of Special Education (PENNDATA 2006).  Data is in county order by local education agency, by school, and by grade.
NOTE:  AVTS Part-day enrollments are excluded from county and state totals
DEFINITIONS:
[NAME] (EUG) - Full-time elementary nongraded programs including ungraded special education.
K4 - The first year of a 2-year kindergarten program.  Students are generally 4 years old at the beginning of the school year.
K5 - The second year of a 2-year kindergarten program or the single year of a traditional 1-year kindergarten program.  Students are generally 5 years old at the beginning of the school year.
PRE-KINDERGARTEN (PREK) - A program enrolling students who are up to two years younger than the entrance age for the local education agency's kindergarten program.
SECONDARY UNGRADED (SUG) - Full-time secondary nongraded programs including ungraded special education.
ESPE 250A Public Enrollment by County by School by [NAME]
2007-07-12 00:00:00
Spreadsheet: 99250d1297953146-comparing-times-with-different-ranges-excel-help
Sheet: Sheet1

Time |  | Start Time | End Time
2010-12-01 23:22:43 |  | 2010-12-01 13:44:14 | 2010-12-01 13:56:09
2010-12-01 23:22:43 |  | 2010-12-01 14:07:04 | 2010-12-01 14:13:46
2010-12-02 00:09:28 |  | 2010-12-01 15:04:13 | 2010-12-01 15:35:49
2010-12-02 00:09:28 |  | 2010-12-01 17:28:59 | 2010-12-01 17:37:35
2010-12-02 00:41:05 |  | 2010-12-01 17:36:35 | 2010-12-01 17:43:07
2010-12-02 00:41:07 |  | 2010-12-01 18:11:30 | 2010-12-01 19:26:51
2010-12-02 00:41:07 |  | 2010-12-01 19:55:43 | 2010-12-02 00:00:29
2010-12-02 00:41:41 |  | 2010-12-02 16:29:17 | 2010-12-02 16:39:08
2010-12-02 00:41:41 |  | 2010-12-02 16:39:09 | 2010-12-02 16:45:41
2010-12-02 00:41:43 |  | 2010-12-02 16:47:50 | 2010-12-02 16:56:15
2010-12-02 01:15:49 |  | 2010-12-02 16:55:33 | 2010-12-02 17:07:20
2010-12-02 01:15:55 |  | 2010-12-02 20:59:53 | 2010-12-02 21:36:52
2010-12-02 01:16:09 |  | 2010-12-02 21:54:58 | 2010-12-03 13:31:23
Spreadsheet: 328431d1403895337-data-validation-and-lookup-problem-example-file-1-
Sheet: Sheet2

Data Validation Item Drop-Down List Table
 | ITEMS | Quantity | Unit | Group1 Price | Group2 Price | Group3 Price | Total |  |  | Pricing
1 | Item1 | 1 |  |  |  |  |  |  |  | ITEMS | Units | Group1 Price | Group2 Price | Group3 Price
2 | Item3 | 2 |  |  |  |  |  |  |  | Item1 | Each | 10
3 | Item2 | 3 |  |  |  |  |  |  |  | Item2 | lbs |  |  | 20
4 | [NAME] | 4 |  |  |  |  |  |  |  | Item3 | lbs |  |  | 5
5 | Item6 | 5 |  |  |  |  |  |  |  | Item4 | Hour |  | 30
6 | [NAME] Item2 | 6 |  |  |  |  |  |  |  | Item5 | Each | 4
7 |  | 7 |  |  |  |  |  |  |  | Item6 | Hour |  | 7
8 |  | 8
9 |  | 9
10 |  | 10
11 |  | 11
Spreadsheet: 852469d1702495859-averageifs-exclude-blanks-and-zeros-alice_jan-1-dec-12
Sheet: Counts

Never Activated | 76 |  |  | Customer | Period | % Efficiency |  |  |  |  |  | Q1
"Was" | 10 |  |  |  | Q1 |  | <-- need this to exclude any blanks or zeros |  |  | Coastal Chemical - Alice TX |  | Q2
Need to Review for Move | 4 |  |  | [NAME]: | Q2 |  |  |  |  | Hilcorp Energy (96890) - Alice |  | Q3
 |  |  |  |  | Q3 |  |  |  |  | JW Operating - Alice |  | Q4
Burck Hardt Compression - Alice |  |  |  |  | Q4 |  |  |  |  | K & R Energy - Alice
Hilcorp Energy (96890) - Alice |  |  |  |  |  |  |  |  |  | Marathon Oil Process/Lubes - Alice
JW Operating - Alice |  |  |  |  | Q1 |  |  |  |  | Stock units - Alice
K & R Energy - Alice |  |  |  | [NAME]: | Q2 |  |  |  |  | 0
Marathon Oil Process/Lubes - Alice |  |  |  |  | Q3
 |  |  |  |  | Q4
Total Units
 |  |  |  |  | Q1
 |  |  |  | [NAME]: | Q2
 |  |  |  |  | Q3
 |  |  |  |  | Q4
 |  |  |  |  | Q1 |  | should be 36
 |  |  |  | [NAME]: | Q2 |  | 57.2
 |  |  |  |  | Q3 |  | 55.5
 |  |  |  |  | Q4 |  | 50.1
 |  |  |  |  | Q1 |  | 36.5
 |  |  |  | [NAME]: | Q2 |  | 36.6
 |  |  |  |  | Q3 |  | 37.6
 |  |  |  |  | Q4 |  | 36.7
 |  |  |  |  | Q1 |  | 48.4
 |  |  |  | [NAME]: | Q2 |  | 51.6
 |  |  |  |  | Q3 |  | 44.5
 |  |  |  |  | Q4 |  | 41.4
 |  |  |  |  | Q1
 |  |  |  | [NAME]: | Q2
 |  |  |  |  | Q3
 |  |  |  |  | Q4
 |  |  |  |  | Q1
 |  |  |  | [NAME]: | Q2
 |  |  |  |  | Q3
 |  |  |  |  | Q4
 |  |  |  |  | Q1
 |  |  |  | [NAME]: | Q2
 |  |  |  |  | Q3
 |  |  |  |  | Q4
 |  |  |  |  | Q1
 |  |  |  | [NAME]: | Q2
 |  |  |  |  | Q3
 |  |  |  |  | Q4
 |  |  |  |  | Q1
 |  |  |  | [NAME]: | Q2
 |  |  |  |  | Q3
 |  |  |  |  | Q4
 |  |  |  |  | Q1
 |  |  |  | [NAME]: | Q2
 |  |  |  |  | Q3
 |  |  |  |  | Q4
Spreadsheet: 833485d1687005824-conditional-formatting-to-highlight-highest-product-name-and-entire-row-conditional_formatting
Sheet: Sheet1

Name | Name of IceCream | Unit | Price/Unit | Sale
[NAME] | Caramel | 61 | 13
Lone | Caramel | 95 | 10.55
[NAME] | Caramel | 100 | 9.99
Elmer | Caramel | 75 | 12.65
Elmer | Caramel | 68 | 12.65
[NAME] | Caramel | 85 | 11
[NAME] | Caramel | 23 | 16
Barlow | Caramel | 95 | 11
Barlow | Caramel | 80 | 11
 | [NAME]
 | Caramel Total
[NAME] | Coffee | 99 | 10
Lone | Coffee | 95 | 10.55
[NAME] | Coffee | 73 | 11.6
Elmer | Coffee | 75 | 11
[NAME] | Coffee | 52 | 12
[NAME] | Coffee | 70 | 11
Barlow | Coffee | 57 | 12.55
 | [NAME]
 | Coffee Total
[NAME] | Pistachio | 28 | 13.5
Lone | Pistachio | 110 | 10.9
Lone | Pistachio | 90 | 10.9
[NAME] | Pistachio | 81 | 10
Elmer | Pistachio | 86 | 10
[NAME] | Pistachio | 95 | 10.55
[NAME] | Pistachio | 90 | 10.55
[NAME] | Pistachio | 92 | 11.5
[NAME] | Pistachio | 52 | 13.6
Barlow | Pistachio | 85 | 11.5
 | [NAME]
 | Pistachio Total
[NAME] | [NAME] | 80 | 11.2
[NAME] | [NAME] | 80 | 11.2
[NAME] | [NAME] | 75 | 11.2
Lone | [NAME] | 95 | 10.55
[NAME] | [NAME] | 110 | 9.99
[NAME] | [NAME] | 90 | 9.99
[NAME] | [NAME] | 65 | 9.99
Elmer | [NAME] | 65 | 12.55
Elmer | [NAME] | 55 | 12.55
[NAME] | [NAME] | 62 | 11
[NAME] | [NAME] | 68 | 12.55
[NAME] | [NAME] | 65 | 12.55
[NAME] | [NAME] | 60 | 12.55
[NAME] | [NAME] | 56 | 12.55
Barlow | [NAME] | 95 | 11
Barlow | [NAME] | 80 | 11
 | [NAME]
 | [NAME]
 | [NAME]
 | Grand Total
Spreadsheet: 854420d1704301540-sum-with-index-match-holiday_test-sheet
Sheet: Mar

 | [NAME]
Area | Name | 2024-03-01 00:00:00 | 2024-03-02 00:00:00 | 2024-03-03 00:00:00 | 2024-03-04 00:00:00 | 2024-03-05 00:00:00 | 2024-03-06 00:00:00 | 2024-03-07 00:00:00 | 2024-03-08 00:00:00 | 2024-03-09 00:00:00 | 2024-03-10 00:00:00 | 2024-03-11 00:00:00 | 2024-03-12 00:00:00 | 2024-03-13 00:00:00 | 2024-03-14 00:00:00 | 2024-03-15 00:00:00 | 2024-03-16 00:00:00 | 2024-03-17 00:00:00 | 2024-03-18 00:00:00 | 2024-03-19 00:00:00 | 2024-03-20 00:00:00 | 2024-03-21 00:00:00 | 2024-03-22 00:00:00 | 2024-03-23 00:00:00 | 2024-03-24 00:00:00 | 2024-03-25 00:00:00 | 2024-03-26 00:00:00 | 2024-03-27 00:00:00 | 2024-03-28 00:00:00 | 2024-03-29 00:00:00 | 2024-03-30 00:00:00 | 2024-03-31 00:00:00 | Total A/L
1 | Adam |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | a/l | a/l | a/l | a/l | a/l |  |  |  |  |  |  | B/H
1 | [NAME] |  |  |  |  |  |  | a/l | a/l |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B/H
2 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B/H
2 | Debs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B/H
2 | Elaine |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B/H
3 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | a/l | a/l | a/l |  | B/H
3 | George |  |  |  | a/l | a/l | a/l |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B/H
3 | Helen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B/H
5 | Ian |  |  |  |  |  |  |  |  |  |  | a/l | a/l | a/l | a/l | a/l |  |  | a/l | a/l | a/l | a/l | a/l |  |  |  |  |  |  | B/H
Spreadsheet: 802055d1666618757-vlookup-of-shipping-rates-based-on-effective-date-rate-example
Sheet: Sheet1

 |  |  |  |  |  | Effective Date >> | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00
 |  |  |  |  |  | From China | 100 | 200 | 300 | 400 | 500 | 600
 |  |  |  |  |  | From Vietnam | 200 | 300 | 400 | 500 | 600 | 700
 |  |  |  |  |  | From Italy | 300 | 400 | 500 | 600 | 700 | 800
 |  |  |  |  |  | From Costa Rica | 400 | 500 | 600 | 700 | 800 | 900
 | I have a shipment from italy that arrives on 3/15/2022
 | Need the rate that would apply at that time (rates are applied based on arrival to port)
Spreadsheet: 4d225890-92b2-4797-8279-90f437a7cd5d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | U.S. Census Bureau
 |  | Source: Quarterly Services Survey
 |  | 51: Information: U.S. Total
 |  | Seasonally Adjusted Total Revenue [Millions of Dollars]
 |  | Period: 2003 to 2013
 |  | Data Extracted on: April 18, 2014 (9:49 pm)
Year | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter
2003 | X | X | X | 229371
2004 | 229646 | 233241 | 235336 | 237875
2005 | 242085 | 244136 | 247183 | 247443
2006 | 250954 | 254990 | 258328 | 262731
2007 | 263776 | 266272 | 270025 | 272054
2008 | 276019 | 278206 | 280691 | 273572
2009 | 267266 | 267665 | 268736 | 271174
2010 | 273058 | 275612 | 279685 | 281383
2011 | 283078 | 290271 | 293177 | 293795
2012 | 297910 | 301286 | 303811 | 309614
2013 | 312286 | 314808 | 320087 | 326018
Spreadsheet: 673090d1587150767-how-to-display-the-latest-20-dates-from-a-data-sheet-golf-handicap-index-calculation-golfhandicapindexcalculation
Sheet: DiffTable

Differential Lookup Table
 | Diff
Rounds | Used
5 | 1
6 | 1
7 | 2
8 | 2
9 | 3
10 | 3
11 | 4
12 | 4
13 | 5
14 | 5
15 | 6
16 | 6
17 | 7
18 | 8
19 | 9
20 | 10
Spreadsheet: 38411d1236598118-excel-2007-issue-with-using-formulas-to-pull-data-from-one-sheet-to-another-lwnnsalariesprojections
Sheet: Marlins

Florida [NAME] | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 |  | Florida [NAME] | 2009 | 2010 | 2011 | 2012 | 2013 | 2014
Actual |  |  |  |  |  |  |  | Operations
Budget | 90 | 90 | 90 | 90 | 90 | 90
Difference |  |  |  |  |  |  |  | Fan Base Factors
 |  |  |  |  |  |  |  | Record Reward
Cost of Goods
Personnel |  |  |  |  |  |  |  | Income
[NAME], Conor | ML | ML | ML | ML | ML | ML |  | From A's | -4.6 | -2.1
Hudson, [NAME] | ML | ML | ML | ML | ML | ML |  | From Diamondbacks |  | -3
Inoa, [NAME] | ML | ML | ML | ML | ML | ML |  | From Phillies |  | -3
[NAME], [NAME] | ML | ML | ML | ML | ML | ML
[NAME] | ML | ML | ML | ML | ML | ML |  | Expenses
[NAME], [NAME] | ML | ML | ML | ML | ML | ML |  | Aurilia, [NAME] | 0.1 | 0.1 | 0.1
Cunningham, [NAME] | ML | ML | ML | ML | ML | ML |  | Estrada, [NAME] | 0.8 | 0.8 | 0.8
[NAME], Alejandro | ML | ML | ML | ML | ML | ML |  | Pavano, [NAME] | 5.4 | 5.4
Dent, [NAME] | ML | ML | ML | ML | ML | ML |  | [NAME], [NAME] | 0.1 | 0.1 | 0.1
Escobar, Eduardo | ML | ML | ML | ML | ML | ML |  | To Diamondbacks | 6
Gaetti, [NAME] | ML | ML | ML | ML | ML | ML |  | To Phillies | 5.6
Haerther, [NAME] | ML | ML | ML | ML | ML | ML |  | To Royals | 0.6
Heether, [NAME] | ML | ML | ML | ML | ML | ML
Katin, [NAME] | ML | ML | ML | ML | ML | ML
Magnuson, Trystan | ML | ML | ML | ML | ML | ML
Maier, [NAME] | ML | ML | ML | ML | ML | ML
Mather, [NAME] | ML | ML | ML | ML | ML | ML
Moskos, [NAME] | ML | ML | ML | ML | ML | ML
Pena, Brayan | ML | ML | ML | ML | ML | ML
Perez, Sergio | ML | ML | ML | ML | ML | ML
[NAME], [NAME] | ML | ML | ML | ML | ML | ML
[NAME], [NAME] | ML | ML | ML | ML | ML | ML
Smolinski, Jake | ML | ML | ML | ML | ML | ML
Tippett, Bradley | ML | ML | ML | ML | ML | ML
[NAME], [NAME] | ML | ML | ML | ML | ML | ML
Wimberly, [NAME] | ML | ML | ML | ML | ML | ML
Escobar, Kelvim | 22.9 | 22.9 | 22.9
Furcal, Rafael | 12.6
Belliard, [NAME] | 7
Washburn, Jarrod | 6.3 | 6.3
Byrd, Marlon | 6.1
Moyer, [NAME] | 3.6 | 3.6
Marcum, Shaun | 3 | A2 | A3
Davies, [NAME] | 2.5 | A3
McPherson, Dallas | 2.2 | A3
Varitek, [NAME] | 1.5
[NAME] | 1.4 | A2 | A3
Keppinger, [NAME] | 1.4
Sanchez, Duaner | 1
[NAME], Cliff | 0.9 | 0.9 | 0.9
Cruz, [NAME] | 0.7 | A1 | A2 | A3
Hill, [NAME] | 0.7 | A1 | A2 | A3
Betemit, Wilson | 0.4
Bradford, Chad | 0.4
Sheffield, [NAME] | 0.3
Speier, Justin | 0.3
[NAME], [NAME] | 0.3
[NAME], [NAME] | 0.2