tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 787357d1657738371-help-with-text-if-function-coupled-with-vlookup-to-display-a-text-as-the-last-argument-sample
Sheet: LILO

Unique ID | DOMAINNAME | Last Name | Shift | [NAME]
589656 | Employee1 | Emp1 | 09:00-18:00 | 9:15:00
660876 | Employee2 | Emp2 | 09:00-18:00 | 8:58:00
716772 | Employee3 | Emp3 | 09:00-18:00 | 9:03:00
644227 | Employee4 | Emp4 | 09:00-18:00 | 8:50:00
675302 | Employee5 | Emp5 | OFF
695523 | Employee6 | Emp6 | 09:00-18:00 | 8:40:00
731912 | Employee7 | Emp7 | PTO
695528 | Employee8 | [NAME] | 09:00-18:00 | 8:56:00
705102 | Employee9 | Emp9 | 09:00-18:00 | 8:59:00
720550 | Employee10 | Emp10 | 09:00-18:00 | 8:10:00
712011 | Employee11 | Emp11 | 09:00-18:00 | 8:32:00
668448 | Employee12 | Emp12 | MATO
669219 | Employee13 | Emp13 | 09:00-18:00 | 8:12:00
721431 | Employee14 | Emp14 | 09:00-18:00 | 9:01:00
Spreadsheet: 780826d1652804528-sum-record-on-multiple-criteria-in-table-17052022-sample-for-excel-forum
Sheet: Sheet1

Table 1 |  | For 1st 100 basic | Next DA |  |  |  |  | Result Table
Designation | Basic | DA Slabs | % add DA | Basic | [NAME] |  |  | Name | Designation | Basic | DA Amt | [NAME]
1 | >0 | 5000 | 4.5 | >1700 | 12.6 |  |  | ABC | 1 | 1695 |  | 0
2 | >0 | 4400 | 4.3 | >1700 | 12.1 |  |  | CDS | 1 | 1805
2 | >1800 | 4600 | 4.4 |  |  |  |  | ACD | 5 | 505
3 | >0 | 4100 | 4 | >1500 | 11.55 |  |  | SFDR | 4 | 1490 |  | 0
4 | >0 | 3900 | 3.8 | >1500 | 10.7 |  |  | QSS | 8 | 1705
5 | >0 | 3700 | 3.6 | >1500 | 9.5 |  |  | DCR | 5 | 910 |  | 0
5 | >900 | 3700 | 3.6 |  |  |  |  | DRC | 2 | 1995
5 | >1200 | 3800 | 3.6 |  |  |  |  | ACQ | 2 | 1780 |  | 0
6 | >0 | 3500 | 3.5 | >1500 | 9
7 | >0 | 3500 | 3.5 | >1500 | 9
8 | >0 | 3300 | 3.3 | >1500 | 9
9 | >0 | 3300 | 3.3 | >1500 | 9
Spreadsheet: 272754d1382484679-need-conditional-formula-to-average-the-data-depending-on-2-conditions-example
Sheet: Sheet1

Email #1 |  | Characters | Exclamation Point
[NAME] | [NAME] | 54 | 0
Type | Coupons
Sub Type | Holiday
Date | 2013-10-14 09:30:00
# Sent | 5438
# Open | 1055
Open Rate | 0.194
# Clicked | 58
Click Through Rate | 0.0107
CTOR | 0.055
Unsubscribe | 0
Spam | 0
Position | Merchant | Clicks | Percentage
1 | XXXX | 21 | 0.3281
2 | XXXX | 4 | 0.0625
3 | XXXX | 5 | 0.0781
4 | XXXX | 4 | 0.0625
5 | XXXX | 4 | 0.0625
6 | XXXX | 2 | 0.0313
7 | XXXX | 1 | 0.0156
8 | XXXX | 3 | 0.0469
9 | XXXX | 10 | 0.1563
10 | XXXX | 10 | 0.1563
 |  | 64 | 1
Email #2 |  | Characters | Exclamation Point
[NAME] | Save up to 50% and Give Back to Your School | 43 | 0
Type | Coupons
Sub Type | Top 10 Deals
Date | 2013-10-09 09:30:00
# Sent | 5368
# Open | 931
Open Rate | 0.1734
# Clicked | 72
Click Through Rate | 0.0134
CTOR | 0.0773
Unsubscribe | 0
Spam | 1
Position | Merchant | Clicks | Percentage
1 | XXXX | 17 | 0.2267
2 | XXXX | 3 | 0.04
3 | XXXX | 9 | 0.12
4 | XXXX | 3 | 0.04
5 | XXXX | 3 | 0.04
6 | XXXX | 14 | 0.1867
7 | XXXX | 8 | 0.1067
8 | XXXX | 7 | 0.0933
9 | XXXX | 5 | 0.0667
10 | XXXX | 6 | 0.08
 |  | 75 | 1
Email #3 |  | Characters | Exclamation Point
[NAME] | Save Big on our Top Merchants | 29 | 0
Type | Merchants
Sub Type | Holiday
Date | 2013-09-25 09:30:00
# Sent | 5275
# Open | 1103
Open Rate | 0.2091
# Clicked | 83
Click Through Rate | 0.0157
CTOR | 0.0752
Unsubscribe | 0
Spam
Position | Merchant | Clicks | Percentage
1 | XXXX | 28 | 0.3146
2 | XXXX | 18 | 0.2022
3 | XXXX | 7 | 0.0787
4 | XXXX | 1 | 0.0112
5 | XXXX | 25 | 0.2809
6 | XXXX | 10 | 0.1124
 |  | 89 | 1
Email #4 |  | Characters | Exclamation Point
[NAME] | It’s No Trick – Treat Yourself to Savings Up to 30% | 51 | 0
Type | Coupons
Sub Type | Holiday
Date | 2013-10-07 09:30:00
# Sent | 5347
# Open | 1203
Open Rate | 0.225
# Clicked | 63
Click Through Rate | 0.0118
CTOR | 0.0524
Unsubscribe | 1
Spam | 0
Position | Merchant | Clicks | Percentage
1 | XXXX | 27 | 0.3803
2 | XXXX | 11 | 0.1549
3 | XXXX | 3 | 0.0423
4 | XXXX | 5 | 0.0704
5 | XXXX | 2 | 0.0282
6 | XXXX | 1 | 0.0141
7 | XXXX | 2 | 0.0282
8 | XXXX | 10 | 0.1408
9 | XXXX | 3 | 0.0423
10 | XXXX | 7 | 0.0986
 |  | 71 | 1
Spreadsheet: 849001d1699567697-pivot-table-how-to-add-an-extra-grand-total-column-for-min-and-max-excel-pivot-min-max_3solution
Sheet: PowerQuery

Product | Red | Blue | White | Pink | Min | [NAME] | Min_Store | Max_Store
Product 1 MAX | 139 | 144 | 149 | 154 | 139 | 154 | Red | Pink
Product 1 MIN | 124 | 129 | 134 | 139 | 124 | 139 | Red | Pink
Product 2 MAX | 140 | 202 | 150 | 155 | 140 | 202 | Red | Blue
Product 2 MIN | 125 | 130 | 135 | 140 | 125 | 140 | Red | Pink
Product 3 MAX | 141 | 146 | 151 | 156 | 141 | 156 | Red | Pink
Product 3 MIN | 126 | 131 | 136 | 141 | 126 | 141 | Red | Pink
Product 4 MAX | 192 | 147 | 114 | 157 | 114 | 192 | White | Red
Product 4 MIN | 177 | 132 | 99 | 142 | 99 | 177 | White | Red
Product 5 MAX | 143 | 148 | 153 | 158 | 143 | 158 | Red | Pink
Product 5 MIN | 128 | 133 | 138 | 143 | 128 | 143 | Red | Pink
Spreadsheet: 09253d18-87c9-4a5a-8b17-c0bda9279e85
Sheet: ADN Prop Data

ADN Data
 | Isp (sec.) | Density (kg/m^3) | Ivsp (Ns/dm^3) | Operating Temp (Celcius)
GREEN LMP-101X | 247 | 1380 | 3340 | 1700
GREEN LMP-102 | 218 | 1390 | 2970 | 1280
GREEN LMP-103X | 257 | 1300 | 3280 | 1800
GREEN ADN/Methanol, 26% water | 253 | 1300 | 3230 | 1730
GREEN HAN/Methanol, 26% water | 239 | 13200 | 3090 | 1500
GREEN HAN/Glycine, 26% water | 204 | 1330 | 2660 | 1100
[NAME], 60% Amm. Diss. | 238 | 1000 | 2330 | 900
Spreadsheet: 739593d1625809144-index-and-match-from-2-rows-main
Sheet: index_match

Name | Time | TEMP
Mr.[NAME] | 2021-07-01 22:39:19
Mr.[NAME] | 2021-07-01 22:30:07
Mr.[NAME] | 2021-07-01 22:30:06
Mr.[NAME] | 2021-07-01 22:19:51
Mr.[NAME] | 2021-07-01 22:16:26
Mr.[NAME] | 2021-07-01 22:07:13
Mr.[NAME] | 2021-07-01 22:01:34
Mr.[NAME] | 2021-07-01 22:00:08
Mr.[NAME] | 2021-07-01 21:59:11
Spreadsheet: 821933d1678996249-time-by-name-drop-down-list-example-2_k7
Sheet: Sheet1

 | AA
Task | Lead | Start Date | End Date | Start Time | End Time | Total Time | Helper 1 | Pipe Time Tracking |  |  | Start Date | End Date | Start Time | End Time | Total Time
10" 90° Elbows | [NAME] |  |  |  |  |  |  | 60" - 20' Pipe |  |  | 2023-02-17 00:00:00 | 2023-03-13 00:00:00 | 10:00:00 | 10:40:00
 |  | 2023-02-01 00:00:00 | 2023-02-01 00:00:00 | 07:40:00 | 10:00:00
 |  | 2023-02-01 00:00:00 | 2023-02-01 00:00:00 | 12:50:00 | 16:05:00
 |  | 2023-02-02 00:00:00 | 2023-02-02 00:00:00 | 07:42:00 | 13:25:00 |  |  |  |  | Helper 2
 |  | 2023-02-07 00:00:00 | 2023-02-07 00:00:00 | 10:45:00 | 16:20:00 |  |  |  |  |  | [NAME]
 |  | 2023-02-08 00:00:00 | 2023-02-08 00:00:00 | 06:35:00 | 16:30:00 |  |  |  |  | [NAME]
 |  | 2023-02-09 00:00:00 | 2023-02-09 00:00:00 | 06:42:00 | 16:30:00
 |  | 2023-02-10 00:00:00 | 2023-02-10 00:00:00 | 06:30:00 | 15:30:00
 |  | 2023-02-13 00:00:00 | 2023-02-13 00:00:00 | 06:40:00 | 15:10:00
 |  | 2023-02-14 00:00:00 | 2023-02-14 00:00:00 | 15:00:00 | 16:30:00
 |  | 2023-02-15 00:00:00 | 2023-02-15 00:00:00 | 06:30:00 | 11:00:00
 |  | 2023-02-21 00:00:00 | 2023-02-21 00:00:00 | 15:25:00 | 16:30:00
 |  | 2023-02-22 00:00:00 | 2023-02-22 00:00:00 | 06:40:00 | 13:45:00
6" 90° Elbows | [NAME]
 |  | 2023-02-07 00:00:00 | 2023-02-07 00:00:00 | 13:50:00 | 14:50:00
4" 90° Elbows | [NAME]
 |  | 2023-02-07 00:00:00 | 2023-02-07 00:00:00 | 14:50:00 | 15:45:00
60" Elbows | [NAME]
 |  | 2023-03-02 00:00:00 | 2023-03-02 00:00:00 | 09:50:00 | 15:20:00
 |  | 2023-03-06 00:00:00 | 2023-03-06 00:00:00 | 14:30:00 | 16:30:00
 |  | 2023-03-07 00:00:00 | 2023-03-07 00:00:00 | 07:30:00 | 15:50:00
 |  | 2023-03-08 00:00:00 | 2023-03-08 00:00:00 | 07:30:00 | 14:10:00
Welding | [NAME]
 |  | 2023-02-24 00:00:00 | 2023-02-24 00:00:00 | 08:30:00 | 10:30:00
 |  | 2023-02-24 00:00:00 | 2023-02-24 00:00:00 | 12:30:00 | 15:00:00
 |  | 2023-03-02 00:00:00 | 2023-03-02 00:00:00 | 08:10:00 | 08:20:00
 |  | 2023-03-02 00:00:00 | 2023-03-02 00:00:00 | 09:45:00 | 16:10:00
 |  | 2023-03-06 00:00:00 | 2023-03-06 00:00:00 | 08:10:00 | 16:25:00
 |  | 2023-03-07 00:00:00 | 2023-03-07 00:00:00 | 08:10:00 | 16:30:00
 |  | 2023-02-09 00:00:00 | 2023-02-09 00:00:00 | 09:00:00 | 15:00:00
 |  | 2023-02-10 00:00:00 | 2023-02-10 00:00:00 | 08:20:00 | 11:50:00
Spreadsheet: 867305d1714135934-redistribute-percentages-redistribute-percentages-
Sheet: Sheet1

 | Percentage | New Balance
A | 0.11
B | 0.27
C | 0.24
D | 0.04
E | 0.01
F | 0.06
G
H | 0.04
Total
Spreadsheet: 765480d1643353192-i-need-to-make-a-formula-in-excel-that-takes-a-symbol-and-makes-it-equal-to-amount-and-dou-symbol-and-makes-it-equal-to-amount
Sheet: Sheet1

 | Monday
 | Stars | Value | With $
GM($50) | ***
Toyota($40) | **
s($30) | *
[NAME]) | ***
asdsa($250) | *
Total
Spreadsheet: 61643d1262593055-matching-prices-for-shopping-items-example
Sheet: What I'm trying to do

What I am trying to do |  |  |  |  |  | Data output (which I am hoping to automate)
 | Worksheet 1 - List of shopping items |  |  |  |  |  |  | Worksheet 2 - list of prices for different quantities
 |  | Item Name | Quantity |  | Price (based on closest matching quantity with pricing sheet) |  |  | Item Name | 10 | 20 | 30 | 40 | 50 | Quantities
 |  | B | 23 |  | 1.12 |  |  | A | 1 | 0.86 | 0.8 | 0.77 | 0.74 | Price
 |  | A | 13 |  | 1
 |  | A | 42 |  | 0.77 |  |  |  | 20 | 40 | 60 | 80 | 100 | Quantities
 |  | C | 88 |  | 2.3 |  |  | B | 1.12 | 1 | 0.9 | 0.8 | 0.9 | Price
 |  | B | 63 |  | 0.8
 |  | D | 2 |  | 12 |  |  |  | 100 | 200 | 300 | 400 | 500 | Quantities
 |  | A | 35 |  | 0.77 |  |  | C | 2.3 | 2.25 | 2 | 1.9 | 1.86 | Price
 |  | D | 22 |  | 10.2
 |  | D | 33 |  | 9.6 |  |  |  | 5 | 10 | 15 | 20 | 30 | Quantities
 |  |  |  |  |  |  |  | D | 12 | 11.2 | 10.3 | 10.2 | 9.6 | Price
 | Logic:
 | 1) | Identify the item in the shopping list (worksheet 1) from the list of prices (worksheet 2)
 | 2) | Find quantity in the prices worksheet that is closest to the quantity in the shopping list
 | 3) | Pull the price for this "closest quantity"
Spreadsheet: 71321d1271983141-sequentially-numbering-specific-cells-template
Sheet: Sheet2

 |  | PO# |  | 94316 |  |  |  | DEPT# |  |  |  | WT. |  | 22 | lbs | CTN. |  | 1 | /15
 |  | STYLE |  |  | COLOR |  |  |  | SIZE |  |  |  |  |  |  | CTN. |  | QTY
 |  | RT1845BO |  |  | WHITE |  |  |  | S(8) M(8) L(8) |  |  |  |  |  |  | 1 |  | 96
 |  |  |  |  | BLACK |  |  |  | S(8) M(8) L(8)
 |  |  |  |  | MAGENTA |  |  |  | S(4) M(4) L(4)
 |  |  |  |  | TEAL |  |  |  | S(4) M(4) L(4)
 |  |  |  |  | YELLOW |  |  |  | S(4) M(4) L(4)
 |  |  |  |  | PURPLE |  |  |  | S(4) M(4) L(4)
Spreadsheet: 722238d1615129662-increasing-decrease-a-cells-value-by-a-specific-rate-based-on-another-cells-value-attach
Sheet: Sheet1

 | Cheese Type | Cost Per Kilo in Euros (€) | Cost Per Kilo in Pounds (£) | Average monthly sales | Sales Price | Sales Margin/Profit | Old Price | Old Sales | Exchange Rate (from Euros € to Pounds £) | 0.7
 | [NAME] | 28 |  |  |  |  | 27.44 | 900 | Sales Margin | 0.4
 | Emmental | 32 |  |  |  |  | 31.36 | 850
 | Gruyere | 35 |  |  |  |  | 34.3 | 875 | Note:
 | Edam | 29 |  |  |  |  | 28.41999999999999 | 825 | Sales Price = Cost per Kilo * 1.4
 | Gouda | 31 |  |  |  |  | 30.38 | 700 | or
 |  |  |  |  |  |  |  |  | Sales Price = Cost per Kilo + Sales Margin (which is just 0.4% of Cost)
Spreadsheet: 790861d1660034882-quartile-calculation-with-multi-condition-questions3
Sheet: 2

precessed data(all "#n/a" are manually removed) |  |  |  |  |  | Calculation
distance(m) | line a | line b | line c | line d |  | distance(start)(m) | distance(end)(m) | expected result
1 |  | 0.1 |  |  |  | 0 | 5
2 | 2 |  |  |  |  | 5 | 10
3 |  | 1 |  | 0.5 |  | 10 | 15
4 |  |  |  | 0 |  | 15 | 20
5 |  | 0 |  | 1
6 |  | 4 |  | 1
7 |  |  |  | 1
8 |  | 6 |  | 2
9 |  | 1 | 2
10 | 1 | 4
11 | 0 | 1 |  | 0
12 | 0 | 1 | 5
13 | 0 | 5 | 7
14 | 0 | 2 | 8
15 | 0 | 2
16 | 0 | 2 |  | 11.2938559702951
17 |  | 2 |  | 8
18 | 0 | 5 |  | 6
19 | 0.2 | 0.2
20 | 8 | 9
Spreadsheet: 546148d1509895862-having-issue-with-drop-down-that-can-retreive-data-data-validation-punch-in-punch-out
Sheet: raw

Date | Name | Duration between punch in and punch out | Punch In | Punch out
2017-10-23 00:00:00 | [NAME] | 00:06:00 | 10:00:00 | 10:06:00
2017-10-23 00:00:00 | [NAME] | 00:21:00 | 11:00:00 | 11:21:00
2017-10-23 00:00:00 | [NAME] | 00:15:00 | 13:16:00 | 13:31:00
2017-10-23 00:00:00 | [NAME] | 00:16:00 | 16:00:00 | 16:16:00
2017-10-23 00:00:00 | [NAME] | 00:06:00 | 16:30:00 | 07:00:00
2017-10-23 00:00:00 | [NAME] | 00:06:00 | 10:00:00 | 10:06:00
2017-10-23 00:00:00 | [NAME] | 00:21:00 | 11:00:00 | 11:21:00
2017-10-23 00:00:00 | [NAME] | 00:15:00 | 13:16:00 | 13:31:00
2017-10-23 00:00:00 | [NAME] | 00:16:00 | 16:00:00 | 16:16:00
2017-10-24 00:00:00 | [NAME] | 00:06:00 | 10:00:00 | 10:06:00
2017-10-24 00:00:00 | [NAME] | 00:06:00 | 10:00:00 | 10:06:00
2017-10-24 00:00:00 | [NAME] | 00:21:00 | 11:00:00 | 11:21:00
2017-10-24 00:00:00 | [NAME] | 00:15:00 | 13:16:00 | 13:31:00
2017-10-24 00:00:00 | [NAME] | 00:16:00 | 16:00:00 | 16:16:00
Spreadsheet: 876630d1723360629-how-to-link-or-import-data-between-two-excel-workbooks-with-very-different-formats-daily-sheets
Sheet: 06.18.24

 | AM SHIFT REPORT
 |  |  |  | 2024-06-18 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN's | RN PD | Travel | RN OT | RN Sick | Tech | N.A. | Comments
 | 3RD FL | 13 | 7 | 10 | 0 | 2 | 0 | 1 | 0 | 1 | 1 | 0
 | 4TH FL | 38 | 22 | 23 | 0 | 4 | 0 | 1 | 0 | 0 | 2 | 0
 | 5TH FL | 34 | 20 | 22 | 0 | 4 | 1 | 1 | 0 | 0 | 2 | 0
 | ABC | 27 | 18 | 16 | 0 | 5 | 1 | 1 | 0 | 0 | 2 | 0
 | MNO | 12 | 6 | 3 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 1 | 2 | 4 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds AM | N/A | N/A | 1 | 0 | 5 | 2 | 0 | 0 | 0 | 2 | 0 | ABC
 | Total Holds MID |  |  | 0 | 0 | 5 | 1 | 0 | 0 | 0 | 1 | 0
 | Total House Census
 | PM SHIFT REPORT
 |  |  |  | 2024-06-18 00:00:00
 | UNIT | Bed Capacity | Bud. Beds | Census | Census Pending | RN's | RN PD | Travel | RN OT | RN Sick | Tech | N.A. | Comments
 | 3RD FL | 13 | 7 | 9 | 0 | 2 | 1 | 0 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 22 | 0 | 4 | 1 | 0 | 0 | 2 | 2 | 0
 | 5TH FL | 34 | 20 | 21 | 0 | 4 | 2 | 1 | 0 | 0 | 2 | 0
 | ABC | 27 | 18 | 9 | 0 | 4 | 0 | 2 | 0 | 0 | 1 | 0
 | MNO | 12 | 6 | 3 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 2 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0
 | DEF | 10 | 4 | 3 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0
 | GHI | N/A | N/A | 2 | 0 | 3 | 0 | 2 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds PM | N/A | N/A | 1 | 0 | 5 | 2 | 0 | 0 | 0 | 2 | 0 | 1 to admit
 | Total House Census
Spreadsheet: michelle_lokay__26617__imbalsumm0102
Sheet: PG&E

56698
Day | Scheduled | Measured
1 | 286091 | 288372
2 | 252470 | 254859
3 | 293473 | 277718
4 | 289096 | 286772
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-01-31 00:00:00 |  |  | 59915
2001-02-04 00:00:00
Spreadsheet: 719996d1613965512-how-to-use-vlookup-true-to-extract-values-test-4-
Sheet: Sheet1

ID | Expected Result | Wrong Result |  |  |  | Target ID | Value
55B_1_3000 |  |  |  |  |  | 55B_1_0 | A
232_3_4000 |  |  |  |  |  | 55B_1_2000 | B
208_1_3500 | M |  |  |  |  | 55B_1_3200 | C
3064_1_2600 | V |  |  |  |  | 55B_1_4000 | D
 |  |  |  |  |  | 55B_1_5100 | E
 |  |  |  |  |  | 232_2_0 | F
 |  |  |  |  |  | 232_3_2000 | G
 |  |  |  |  |  | 232_3_4200 | H
 |  |  |  |  |  | 208_1_0 | I
 |  |  |  |  |  | 208_1_15243 | J
 |  |  |  |  |  | 208_1_23133 | K
 |  |  |  |  |  | 208_1_30370 | L
 |  |  |  |  |  | 208_1_3532 | M
 |  |  |  |  |  | 208_1_3533 | N
 |  |  |  |  |  | 208_1_5230 | O
 |  |  |  |  |  | 208_1_5230 | P
 |  |  |  |  |  | 208_1_5420 | Q
 |  |  |  |  |  | 208_1_5420 | R
 |  |  |  |  |  | 208_1_6393 | S
 |  |  |  |  |  | 3064_1_0 | T
 |  |  |  |  |  | 3064_1_2370 | U
 |  |  |  |  |  | 3064_1_2630 | V | (V or W, but strictly speaking it should be the first match which is "V")
 |  |  |  |  |  | 3064_1_2630 | W
 |  |  |  |  |  | 3064_1_2680 | X
 |  |  |  |  |  | 3064_1_2687 | Y
 |  |  |  |  |  | 3064_1_2687 | Z
 |  |  |  |  |  | 3064_1_3730 | AB
 |  |  |  |  |  | 3064_1_420 | AC
 |  |  |  |  |  | 3064_1_420 | AD
Spreadsheet: 164856d1340909530-excel-2007-need-to-copy-another-spreadsheet-automatically-sweet-cherries
Sheet: Sweet Cherries Worksheet

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Original
Date | Time | Receiver # | Receiving Station | Paper Load # | Excel # | Grower # | [NAME] | State | # of Boxes | Variety | Block | Weight | Comments | Location | Room | Avg. [NAME]. | Samp. Size | Decay | Soft | Cracks | Under Color | Undersize | Hail | Attached Stem | [NAME] | Shrivel | [NAME] | [NAME] | Other | Grader | Total | Grade %
 |  | 110020 | Rocky | N/A | N/A | 1 | [NAME] | NY | 1 |  | [NAME] | 120 |  |  | 18 |  | 500 |  | 1 | 9 |  |  |  |  |  |  | 7 |  | 3 | CG
 |  | 110073 |  | N/A | N/A |  |  |  | 2 |  | SW05 | 920 |  |  |  |  | 500 | 3 |  | 1 |  | 35 |  |  |  |  | 4 |  |  | TG
 |  | 110086 |  | N/A | N/A |  |  |  | 2 |  | 98 | 1060 |  |  |  |  | 500 | 2 | 1 | 3 |  |  |  |  | 1 |  |  |  |  | TG
 |  | 110097 |  | N/A | N/A |  |  |  | 29 |  | [NAME] | 16030 |  |  |  |  | 1000 | 4 | 3 | 5 |  | 3 |  |  |  |  |  |  |  | TG |  | 94
 |  | 34259 |  | N/A | N/A |  |  |  | 12 |  |  | 6600 |  |  |  |  | 1000 |  |  | 3 |  |  |  |  |  |  | 1 |  |  | CK |  | 96
 |  | 34258 |  | N/A | N/A |  |  |  | 14 |  |  | 7834 |  |  |  |  | 1000 |  |  | 2 |  |  |  |  |  |  | 2 |  |  | CK |  | 96
 |  | 34260 |  | N/A | N/A |  |  |  | 18 |  |  | 10726 |  |  |  |  | 1000 |  |  |  |  |  |  |  |  |  | 2 |  |  | Ck |  | 97
 |  | 34154 |  | N/A | N/A |  |  |  | 10 |  |  | 5572 |  |  |  |  | 1000 |  |  |  |  |  |  |  |  |  | 4 |  |  | Ck |  | 96
Spreadsheet: 240443d1370328359-create-subtotal-lines-excel_tablecopy
Sheet: DataFromDB

customer | oder | description | doc ID | requestor | hours | type
A | 1 | desc 1 | 1 | User 1 | 6 | 1
A | 2 | desc 2 | 1 | User 1 | 5 | 1
A | 3 | desc 3 | 1 | User 2 | 1 | 1
A | 1 | desc 4 | 3 | User 4 | 4 | 1
A | 1 | df | 6 | vc | 3 | 1
B | 1 | desc 3 | 2 | User 3 | 3 | 2
C | 1 | xyz | 4 | User 5 | 2 | 2
C | 1 | [NAME] | 5 | cxv | 1 | 1
Spreadsheet: 537300d1504936302-combining-2-rows-into-1-final-invoice-1-
Sheet: page 23

Description of Goods |  |  |  |  | Quantity | Cost | Total
Item # | Color | UPC Code | Country Origin | HS Code
Party Craft: Mini Cupcake Liners x100 [NAME] |  |  |  |  | 36 | 0.3 | 10.8
[NAME] | K) Singing Birds | 775749173970 | CHINA | 4823.90.0099
Party Craft: Decorative Cake Topper Straw/Pennant Banner Set |  |  |  |  | 24 | 0.3 | 7.2
PC256A | A) Bleep-Blorp | 775749187519 | CHINA | 4823.90.0099
Party Craft: Decorative Cake Topper Straw/Pennant Banner Set |  |  |  |  | 24 | 0.3 | 7.2
PC256B | B) Blooming Garden | 775749187717 | CHINA | 4823.90.0099
Party Craft: Decorative Cake Topper Straw/Pennant Banner Set |  |  |  |  | 24 | 0.3 | 7.2
PC256E | E) Outer Space | 775749187748 | CHINA | 4823.90.0099
Scrapbook Stickers: 1 3/16" Alpha x126 (2sht) |  |  |  |  | 24 | 0.68 | 16.32
PC570A | A) Black | 775749152920 | CHINA | 4911.99.0090
Scrapbook Stickers: 1 3/16" Alpha x126 (2sht) |  |  |  |  | 24 | 0.68 | 16.32
PC570B | B) Blue | 775749152937 | CHINA | 4911.99.0090
Scrapbook Stickers: 1 3/16" Alpha x126 (2sht) |  |  |  |  | 24 | 0.68 | 16.32
PC570C | C) Gold | 775749152944 | CHINA | 4911.99.0090
Scrapbook Stickers: 1 3/16" Alpha x126 (2sht) |  |  |  |  | 24 | 0.68 | 16.32
PC570F | F) White | 775749152975 | CHINA | 4911.99.0090
Scrapbook Stickers: 1 3/16" Alpha x126 (2sht) |  |  |  |  | 24 | 0.68 | 16.32
PC570G | G) Silver | 775749153064 | CHINA | 4911.99.0090
WMSKU-Bling Tape Roll 2MM CRYSTAL |  |  |  |  | 48 | 0.98 | 47.04
SE 302A | - | 775749199550 | CHINA | 3926.90.1000
WMSKU-Bling Tape Roll 3MM CRYSTAL |  |  |  |  | 48 | 0.98 | 47.04
SE 302B | - | 775749199567 | CHINA | 3926.90.1000
WMSKU-Bling Tape Roll 4MM CRYSTAL |  |  |  |  | 48 | 0.98 | 47.04
SE 302C | - | 775749199574 | CHINA | 3926.90.1000
WMSKU-Bling Tape Roll 3MM PEARL |  |  |  |  | 48 | 0.98 | 47.04
SE 302D | - | 775749199581 | CHINA | 3926.90.1000
Paper Craft Emb: [NAME] Accents |  |  |  |  | 12 | 0.65 | 7.8
SE125F | F) Printed Blue Daisy 9pc | 775749190731 | INDIA | 4811.90.0090
Paper Craft Emb: 24+42mm 3D Handmade B-flies x9 w/Beads&Pearls Self-Stick |  |  |  |  | 12 | 0.3 | 3.6
SE126G | G) Gentle | 775749182583 | INDIA | 4802.10.0000
Paper Craft Emb: 24+42mm 3D Handmade B-flies x9 w/Beads&Pearls Self-Stick |  |  |  |  | 12 | 0.3 | 3.6
SE126H | H) [NAME] | 775749182590 | INDIA | 4802.10.0000
Paper Craft Emb: Felt-Fad Die Cuts Self-Stick |  |  |  |  | 36 | 0.75 | 27
SE136A | A) [NAME] | 775749221145 | CHINA | 5602.90.9000
Paper Craft Emb: Felt-Fad Die Cuts Self-Stick |  |  |  |  | 36 | 0.75 | 27
SE136B | B) Sea Life | 775749221152 | CHINA | 5602.90.9000
Paper Craft Emb: Felt-Fad Die Cuts Self-Stick |  |  |  |  | 36 | 0.75 | 27
SE136C | C) Chickadee | 775749221169 | CHINA | 5602.90.9000
Paper Craft Emb: Felt-Fad Die Cuts Self-Stick |  |  |  |  | 36 | 0.75 | 27
SE136D | D) Snails | 775749221176 | CHINA | 5602.90.9000
Paper Craft Emb: Felt-Fad Die Cuts Self-Stick |  |  |  |  | 36 | 0.75 | 27
SE136E | E) Boho Flowers | 775749221183 | CHINA | 5602.90.9000
Spreadsheet: 268472d1380650106-weekly-rolling-averages-copy
Sheet: Data

 |  | Overall |  |  |  |  | 0000-0400 |  |  |  |  | 0400-0600 |  |  |  |  | 0600-0800 |  |  |  |  | 0800-1000 |  |  |  |  | 1000-1200 |  |  |  |  | 1200-1400 |  |  |  |  | 1400-1600 |  |  |  |  | 1600-1800 |  |  |  |  | 1800-2000 |  |  |  |  | 2000-2400
Day | Date | Total Trips | [NAME] | Non-Emerg Trips | OTP | CAD UHU | Total Trips | [NAME] | Non-Emerg Trips | Units | OTP | Total Trips | [NAME] | Non-Emerg Trips | Units | OTP | Total Trips | [NAME] | Non-Emerg Trips | Units | OTP | Total Trips | [NAME] | Non-Emerg Trips | Units | OTP | Total Trips | [NAME] | Non-Emerg Trips | Units | OTP | Total Trips | [NAME] | Non-Emerg Trips | Units | OTP | Total Trips | [NAME] | Non-Emerg Trips | Units | OTP | Total Trips | [NAME] | Non-Emerg Trips | Units | OTP | Total Trips | [NAME] | Non-Emerg Trips | Units | OTP | Total Trips | [NAME] | Non-Emerg Trips | Units | OTP
Sunday | 2013-06-30 00:00:00 | 100 | 47 |  | 0.75 | 0.47 | 6 | 5 |  | 2 | N/A | 4 | 2 |  | 5 | N/A | 6 | 3 |  |  | N/A | 6 | 4 |  |  | N/A | 10 | 4 |  |  | 1 | 14 | 6 |  |  | 0.5 | 11 | 9 |  |  | N/A | 9 | 5 |  |  | N/A | 3 | 1 |  |  | 1 | 11 | 8 |  | 5 | N/A
Monday | 2013-07-01 00:00:00 | 333 | 41 |  | 0.85 | 0.56 | 5 | 4 |  | 3 | N/A | 22 | 2 |  | 15 | 1 | 10 | 0 |  |  | 0.8 | 44 | 7 |  |  | 0.81 | 59 | 2 |  |  | 0.84 | 44 | 1 |  |  | 0.97 | 62 | 5 |  |  | 0.91 | 30 | 3 |  |  | 0.71 | 27 | 8 |  |  | 0.79 | 27 | 9 |  | 9 | 0.4
Tuesday | 2013-07-02 00:00:00 | 200 | 47 |  | 0.78 | 0.56 | 7 | 5 |  | 2 | N/A | 17 | 3 |  | 16 | 0.94 | 11 | 2 |  |  | 0.78 | 47 | 8 |  |  | 0.82 | 54 | 5 |  |  | 0.56 | 35 | 9 |  |  | 1 | 62 | 2 |  |  | 0.79 | 18 | 4 |  |  | 0.86 | 18 | 3 |  |  | 0.89 | 13 | 6 |  | 5 | 0.33
Wednesday | 2013-07-03 00:00:00 | 400 | 58 |  | 0.87 | 0.55 | 8 | 6 |  | 3 | N/A | 26 | 1 |  | 17 | 0.96 | 9 | 1 |  |  | 1 | 50 | 9 |  |  | 0.97 | 74 | 6 |  |  | 0.84 | 58 | 9 |  |  | 1 | 60 | 6 |  |  | 0.67 | 35 | 5 |  |  | 0.73 | 24 | 3 |  |  | 0.94 | 27 | 12 |  | 9 | 0.25
Thursday | 2013-07-04 00:00:00 | 200 | 45 |  | 0.97 | 0.44 | 10 | 8 |  | 3 | N/A | 20 | 3 |  | 13 | 1 | 11 | 1 |  |  | 1 | 24 | 2 |  |  | 1 | 37 | 4 |  |  | 1 | 16 | 4 |  |  | 1 | 28 | 3 |  |  | 0.89 | 11 | 4 |  |  | 0.5 | 16 | 7 |  |  | 1 | 21 | 8 |  | 6 | 1
Friday | 2013-07-05 00:00:00 | 97 | 53 |  | 0.92 | 0.55 | 7 | 6 |  | 2 | N/A | 25 | 3 |  | 13 | 0.95 | 19 | 5 |  |  | 1 | 30 | 5 |  |  | 1 | 55 | 4 |  |  | 0.91 | 39 | 6 |  |  | 0.96 | 49 | 5 |  |  | 0.97 | 37 | 7 |  |  | 0.76 | 23 | 3 |  |  | 0.62 | 21 | 10 |  | 10 | 1
Saturday | 2013-07-06 00:00:00 | 50 | 53 |  | 0.69 | 0.56 | 7 | 6 |  | 4 | N/A | 19 | 1 |  | 10 | 0.93 | 7 | 1 |  |  | 1 | 27 | 5 |  |  | 0.9 | 39 | 4 |  |  | 0.61 | 22 | 5 |  |  | 0.83 | 36 | 7 |  |  | 0.48 | 13 | 4 |  |  | 0.2 | 12 | 4 |  |  | 0.4 | 22 | 15 |  | 8 | 1