tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: darrell_schoolcraft__7802__imbalsumm0108
Sheet: NW

 | LaPlata Recpt |  | LaPlata Delivery
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly |  | Monthly
Day | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56419 | 500516 | 500535 | 500539 | [NAME] | Index | Dollars
1 | 199740 | 206461 |  | -6136 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-02-01 00:00:00 |  |  |  |  |  | 1.57
2 | 124221 | 140424 |  | -16997 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-03-01 00:00:00 |  |  |  |  |  | 1.84
3 | 208560 | 226875 |  | -13759 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-04-01 00:00:00 |  |  |  |  |  | 1.91
4 | 174497 | 201790 |  | -27623 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-05-01 00:00:00 |  |  |  |  |  | 2.21
5 | 170484 | 195304 |  | -25217 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-06-01 00:00:00 |  |  |  |  |  | 1.67
6 | 171739 | 196507 |  | -26132 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-07-01 00:00:00 |  |  |  |  |  | 1.8
7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-08-01 00:00:00 |  |  |  |  |  | 1.88
8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-09-01 00:00:00 |  |  |  |  |  | 2.02
9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-10-01 00:00:00 |  |  |  |  |  | 1.81
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-11-01 00:00:00 |  |  |  |  |  | 1.79
11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-12-01 00:00:00 |  |  |  |  |  | 2.28
12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-01-01 00:00:00 |  |  |  |  |  | 1.94
13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-02-01 00:00:00 |  |  |  |  |  | 2.2
14
15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-04-01 00:00:00 |  |  |  |  |  | 1.74
16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-05-01 00:00:00 |  |  |  |  |  | 1.58
17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-06-01 00:00:00 |  |  |  |  |  | 1.6
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2001-07-31 00:00:00 |  |  |  | 4995
 | 2001-08-06 00:00:00
 | CBS Dollars
 |  |  |  | -488068
Spreadsheet: 782043d1653732554-vlook-up-second-and-third-value-vlook-up-index-aligw
Sheet: Sheet1

# | code | from | to |  | search
 | 11 | 2022-02-01 00:00:00 | 2022-02-01 00:00:00 |  | code | 11
 | 22 | 2022-01-01 00:00:00 | 2022-01-01 00:00:00 |  | FIRST
 | 11 | 2022-01-01 00:00:00 | 2022-01-01 00:00:00 |  | from | to
 | 22 | 2022-01-01 00:00:00 | 2022-01-01 00:00:00
 | 11 | 2022-01-01 00:00:00 | 2022-01-01 00:00:00 |  | SECOND
 | 55 | 2022-01-01 00:00:00 | 2022-01-01 00:00:00 |  | from | to
 | 33 | 2022-01-01 00:00:00 | 2022-01-01 00:00:00
 |  |  |  |  | THIRD
 |  |  |  |  | from | to
Spreadsheet: 768477d1644993628-incorrect-conditional-formatting-for-entire-row-condititonal_formatting_highlites_even_when_passed
Sheet: New

Value | Status
80 |  |  | =AND($A2<60,$B2="Failed")
85
90
90
90
80
65
70
80
90
70
80
85
80
85
90
90
85
90
80
85
90
90
85
85
90
90
90
90
85
85
85
85
60
90
80
85
90
90
90
90
90
85
90
85
85
85
80
80
85
85
80
85
55
85
90
75
80
85
90
75
80
85
85
85
60
55
85
75
80
90
90
85
75
75
75
90
70
90
85
90
85
60
80
70
85
60
75
70
90
85
55
80
90
55
55
60
80
85
75
40
70
60
70
85
60
0
70
85
35
90
80
90
80
85
85
70
90
65
75
85
60
90
85
90
85
80
90
75
85
90
75
85
75
90
80
90
85
90
70
80
85
85
90
90
85
85
90
85
85
85
90
75
85
70
80
85
90
80
90
80
85
85
80
90
80
90
70
90
90
80
70
90
90
75
85
Spreadsheet: 854534d1704374846-look-for-two-conditions-in-two-columns-within-a-table-test
Sheet: Sheet1

 |  |  | Name | Date | Output
 |  |  | [NAME] | 2022-04-15 21:02:11 | x
 |  |  | [NAME] | 2021-08-10 21:03:34
 |  |  | Anna | 2023-04-16 21:02:22 | x
 |  |  | [NAME] | 2019-09-16 21:02:12
 |  |  | Anna | 2023-05-01 21:02:35 | x
 |  |  | Anna | 2022-08-01 14:35:53 | x
 |  |  | [NAME] | 2018-08-01 14:32:20
 |  |  | [NAME] | 2020-06-15 21:36:16
 |  |  | [NAME] | 2020-06-15 21:36:17 | x
 |  |  | Anna | 2022-08-09 21:02:16 | x
Spreadsheet: 456567d1460954429-add-employee-name-to-schedule-based-on-shift-and-date-schedule24
Sheet: Schedule Roll-up

 | Monday |  |  |  | Tuesday |  |  |  | Wednesday |  |  |  | Thursday |  |  |  | Friday |  |  |  | Saturday |  |  |  | Sunday
 | Employee | Dept | Employee | Dept | Employee | Dept | Employee | Dept | Employee | Dept | Employee | Dept | Employee | Dept | Employee | Dept | Employee | Dept | Employee | Dept | Employee | Dept | Employee | Dept | Employee | Dept | Employee | Dept
1st | Fred | 13000 |  |  | Fred | 13000 |  |  | Fred | 13000 |  |  | Fred | 13000
2nd | [NAME] | 13700 |  |  | [NAME] | 13700 |  |  | [NAME] | 13700
 | Marcelo | 13700 |  |  | Marcelo | 13700 |  |  | Marcelo | 13700 |  |  | Marcelo | 13700
 |  |  |  |  |  |  |  |  | [NAME] | 12000 |  |  | [NAME] | 12000
3rd
 |  |  |  |  |  |  |  |  | Damon | 14000 |  |  | Damon | 14000
Sick
Personal
Spreadsheet: 868973d1715676453-shrinking-dropdown-list-book2
Sheet: Sheet1

List
REG101 |  |  | REG101
REG102 |  |  | REG101 | EMP-2
REG103 |  |  | REG101 | EMP-3
REG201 |  |  | REG101 | EMP-4
REG202 |  |  | REG103 | EMP-1
REG203 |  |  | REG103 | EMP-2
 |  |  | REG103 | EMP-3
 |  |  | REG103 | EMP-4
 |  |  | REG103 | EMP-5
 |  |  | REG202 | EMP-1
 |  |  | REG202 | EMP-2
 |  |  | REG202 | EMP-3
 |  |  | REG202 | EMP-4
 |  |  | REG202 | EMP-5
 |  |  | REG202 | [NAME]
 |  |  | REG201 | EMP-1
Spreadsheet: 782582d1654145624-conditional-formatting-for-highlighting-values-falling-in-range-sample
Sheet: Sheet1

A | B | C | D | E | F | G | H | I | J | K | L | M |  | Range
86 | 93 | 99 | 79 | 57 | 56 | 95 | 73 | 68 | 65 | 72 | 62 | 72 |  | 2
86 | 68 | 74 | 84 | 74 | 90 | 63 | 74 | 66 | 78 | 83 | 53 | 57
80 | 57 | 84 | 82 | 54 | 80 | 86 | 97 | 77 | 59 | 78 | 65 | 62
93 | 83 | 91 | 82 | 86 | 61 | 82 | 50 | 87 | 79 | 69 | 80 | 84
81 | 82 | 87 | 79 | 56 | 80 | 96 | 76 | 99 | 98 | 91 | 92 | 82
[NAME]: | AND(SUMPRODUCT(--(ABS($A3:$M3-A2)<=$O$2)),SUMPRODUCT(--(ABS($A4:$M4-A2)<=$O$2)),SUMPRODUCT(--(ABS($A5:$M5-A2)<=$O$2)),SUMPRODUCT(--(ABS($A6:$M6-A2)<=$O$2)))
Spreadsheet: 0a5ebd41-29c2-45c9-9186-24373991f956
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 49. OPERATING LEASE FINANCE COMMITMENTS: By Purpose: State (ACT), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1. . . [NAME] ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413727L | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413728R | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413729T | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413730A | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413731C | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413732F | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | A2413733J | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413734K | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413735L | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413736R | 1985-01-01 00:00:00 | 2009-02-01 00:00:00 | 290 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2009
Spreadsheet: 011bcb5b-5871-4b3e-a57a-907b151716ab
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Jugendfeuerwehr
[NAME]
2011
 | Platz | Jugendfeuerwehr | Punkte
 | 1 | Beckeln | 3980
 | 2 | Neerstedt | 3900
 | 3 | Pri-Ho-Kle-He | 3890
 | 4 | Wildeshausen | 3860
 | 5 | Bookholzberg | 3790
 | 6 | Colnrade | 3760
 | 7 | Harpstedt | 3750
 | 8 | Sandhatten | 3720
 | 9 | Wardenburg | 3710
 | 10 | Kirch+Klosterseelte | 3650
 | 11 | Oldenburg-Ofenerdiek | 3640
 | 12 | Ganderkesee | 3640
 | 13 | Sandkrug | 3600
 | 14 | [NAME] | 3510
 | 15 | [NAME] | 3460
 | 16 | Delmenhorst | 3450
 | 17 | Schierbrok-Schönemoor | 3360
 | 18 | OL-Eversten | 3340
Spreadsheet: 721807d1614870854-find-top-5-with-criteria-and-sum-error-sample
Sheet: Sheet2

Name | Workflow | Completed Cases |  |  |  |  | name | 1 | 2 | 3 | 4 | 5
[NAME] | workflow a | 56 |  |  |  |  | [NAME] |  | 289 | 122 | 50 | 0
[NAME] | workflow a | 500 |  |  |  |  | [NAME] |  | 0 | 0 | 0 | 0
[NAME] | workflow a | 5 |  |  |  |  | [NAME] |  | 0 | 0 | 0 | 0
[NAME] | workflow a | 78 |  |  |  |  | [NAME] |  | 0 | 0 | 0 | 0
[NAME] | workflow a | 21
[NAME] | workflow b | 200
[NAME] | workflow b | 34
[NAME] | workflow b | 55
[NAME] | workflow c | 100
[NAME] | workflow c | 22
[NAME] | workflow d | 50
Spreadsheet: 837427d1690178329-need-a-formula-that-adds-interval-to-last-visit-date-sample40
Sheet: Sheet1

 |  | Table 1 |  |  | Table 2
 |  | Last Visit | Category |  | Category | Interval | Interval2
 |  | 2023-06-17 00:00:00 | AB |  | AB | 2 | Month
 |  | 2023-07-09 00:00:00 | AVB |  | AVB | 3 | Month
 |  | 2023-07-13 00:00:00 | SYT |  | SYT | 1 | Year
 |  |  |  |  | Table 3
 |  |  |  |  | Due Date
 |  |  |  |  | Category | Due Date
 |  |  |  |  | AB | 2023-08-17 00:00:00
 |  |  |  |  | AVB | 2023-10-09 00:00:00
 |  |  |  |  | SYT | 2024-07-13 00:00:00
Spreadsheet: 866478d1713385698-looking-for-a-way-to-filter-a-text-variable-kansas-scheduler-v4-6-eba
Sheet: Press Date Calculation

Press Time Totals by Date |  |  |  |  |  |  |  |  |  |  |  |  | Kitting Totals by Date
↓Date↓ |  | ↓Tauro↓ | ↓3R↓ | ↓Canon↓ | ↓HP↓ | ↓HS↓ | ↓GS↓ | ↓Indigo↓ | ↓Cut Only↓ | ↓Fabrivue↓ | ↓TOTALS↓ |  | ↓Date↓ | ↓Kitting Jobs↓ | ↓# of Kits↓ | ↓Days to Kit↓
2024-04-17 00:00:00 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
 | →
Spreadsheet: 696268d1600736923-collating-multiple-tab-info-into-one-rj-projections_chrispq
Sheet: Supplier 2

Forecast Month | [NAME] (Product) | [NAME] (Number) | Container Number | Time to arrive (M) | Order Date | [NAME] | Container Cost (£) | Jan-20 | Feb-20 | Mar-20 | Apr-20 | May-20 | Jun-20 | [NAME] | Aug-20 | Sep-20 | Oct-20 | Nov-20 | Dec-20 | Jan-21 | Feb-21 | Mar-21 | Apr-21 | May-21 | [NAME] | [NAME] | Aug-21 | Sep-21 | Oct-21 | Nov-21 | Dec-21
2021-01-01 00:00:00 | Product B | 2000 | 1 | -3 |  |  | 10000
2021-03-01 00:00:00 | Product B | 2000 | 1 | -3 |  |  | 20000
2021-04-01 00:00:00 | Product B | 2000 | 1 | -3 |  |  | 50000
2021-04-01 00:00:00 | Product B | 2000 | 1 | -3 |  |  | 40000
Spreadsheet: 836248d1689209437-provide-last-user-ignoring-blanks-except-if-only-data-catz-example-hd
Sheet: Logins

Device SN | User | Date/time |  |  | DESIRED RESULTS: Unique SN | DESIRED RESULTS: Last user | DESIRED RESULTS: Last login time
sn1 |  | 2023-06-25 00:00:00 |  | [NAME] of Glenn |  | u1 | 2023-06-24 00:00:00
sn1 | u1 | 2023-06-24 00:00:00 |  |  | sn2 | u3 | 2023-06-21 15:13:00
sn1 | u1 | 2023-06-23 13:42:00 |  |  | sn3 | u2 | 2023-06-16 00:00:00
sn1 | u2 | 2023-06-22 00:00:00 |  |  | sn4 | No User ID | 2023-06-25 00:00:00
sn2 | u3 | 2023-06-21 15:13:00 |  |  | sn5 | u5 | 2023-06-21 13:05:00
sn2 | u3 | 2023-06-20 04:20:00 |  |  | sn6 | u6 | 2023-06-20 00:00:00
sn2 | u3 | 2023-06-19 05:15:00 |  |  | sn7 | u7 | 2023-07-02 20:00:00
sn2 | u3 | 2023-06-18 08:37:00
sn2 | u3 | 2023-06-17 16:01:00 |  | Expected results | sn1 | u1 | 06/24/2023 00:00
sn3 |  | 2023-06-16 00:00:00 |  |  | sn2 | u3 | 06/21/2023 15:13
sn3 | u2 | 2023-06-16 00:00:00 |  |  | sn3 | u2 | 06/16/2023 00:00
sn3 | u3 | 2023-06-14 12:14:00 |  |  | sn4 | no user information available | 06/13/2023 11:57
sn4 |  | 2023-06-13 11:57:00 |  |  | sn5 | u4 | 06/22/2023 13:20
sn4 |  | 2023-06-22 13:20:00 |  |  | sn6 | u6 | 06/20/2023 00:00
sn5 | u5 | 2023-06-21 13:05:00 |  |  | sn7 | u7 | 2023-02-07 20:00:00
sn5 | u4 | 2023-06-12 14:00:00
sn6 | u6 | 2023-06-20 00:00:00 |  | [NAME] HD |  | u1 | 2023-06-24 00:00:00
sn7 | u7 | 2023-07-02 20:00:00 |  |  | sn2 | u3 | 2023-06-21 15:13:00
sn7 |  | 2023-07-02 19:59:00 |  |  | sn3 | u2 | 2023-06-16 00:00:00
 |  |  |  |  | sn4 | No User ID | 2023-06-22 13:20:00
 |  |  |  |  | sn5 | u5 | 2023-06-21 13:05:00
 |  |  |  |  | sn6 | u6 | 2023-06-20 00:00:00
 |  |  |  |  | sn7 | u7 | 2023-07-02 20:00:00
Spreadsheet: 779736d1652077093-populate-calendars-based-on-office-location-office-scheduling-draft
Sheet: AP

Month: | May
Year: | 2022
Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
Spreadsheet: 797744d1664119538-changing-index-reference-based-upon-a-certain-value-book1
Sheet: Sheet1

500 | 1 |  |  |  |  |  | 0.23 |  | 500
500 | 2 |  |  |  |  |  | 0.38 |  | 600
500 | 3 |  |  |  |  |  | 0.57 |  | 700
500 | 4 |  |  |  |  |  | 0.63
500 | 5 |  |  |  |  |  | 0.78
500 | 6 |  |  |  |  |  | 0.88
500 | 8 |  |  |  |  |  | 1
600 | 1 |  |  |  |  |  | 0.06
600 | 2 |  |  |  |  |  | 0.31
600 | 5 |  |  |  |  |  | 0.63
600 | 6 |  |  |  |  |  | 1
700 | 1 |  |  |  |  |  | 0.5
700 | 2 |  |  |  |  |  | 0.9
700 | 3 |  |  |  |  |  | 1
Spreadsheet: benjamin_rogers__1150__Criteriapollutant
Sheet: 1999

1999-06-01 00:00:00
[NAME] | NOX | SO2 | VOC | TSP | CO
Unit ID
AA-001 | 3.69 | 3.96 | 17.87 | 25.79 | 113.15
AA-002 | 645.86 | 15.29 | 68.37 | 98.7 | 432.7
AA-003 | 1003.91 | 23.48 | 105.66 | 234.78 | 669.15
AA-004 | 1689.74 | 34.82 | 156.61 | 348.01 | 991.85
AA-005
Monthly Plant Total (lbs)
1999-07-01 00:00:00
[NAME] | NOX | SO2 | VOC | TSP | CO
Unit ID
AA-001 | 3928.77 | 233.69 | 1051.64 | 1519.01 | 6660.32
AA-002 | 7256.71 | 324.91 | 1461.79 | 2111.43 | 9257.84
AA-003 | 12127.45 | 342.09 | 1539.4 | 3420.88 | 9749.51
AA-004 | 13292.12 | 356.74 | 1605.29 | 3567.32 | 10166.93
AA-005
Monthly Plant Total (lbs)
1999-08-01 00:00:00
[NAME] | NOX | SO2 | VOC | TSP | CO
Unit ID
AA-001 | 9860.3 | 373.5 | 1680.76 | 2427.76 | 10664.81
AA-002 | 12476.85 | 389.8 | 1754.09 | 2533.68 | 11109.22
AA-003 | 18067.98 | 447.08 | 2011.84 | 4470.76 | 12741.66
AA-004 | 21822.42 | 535.96 | 2411.81 | 5359.54 | 15274.82
AA-005
Monthly Plant Total (lbs)
1999-09-01 00:00:00
[NAME] | NOX | SO2 | VOC | TSP | CO
Unit ID
AA-001 | 1409.49 | 49.2 | 221.4 | 319.8 | 1402.18
AA-002 | 218.99 | 2.61 | 11.72 | 16.94 | 74.26
AA-003 | 2907.44 | 75.79 | 341.04 | 757.87 | 2159.92
AA-004 | 2761.91 | 69.76 | 313.94 | 697.64 | 1988.27
AA-005
Monthly Plant Total (lbs)
1999-10-01 00:00:00
[NAME] | NOX | SO2 | VOC | TSP | CO
Unit ID
AA-001 | 0 | 0 | 0 | 0 | 0
AA-002 | 0 | 0 | 0 | 0 | 0
AA-003 | 1.19 | 0.06 | 0.26 | 0.57 | 1.62
AA-004 | 771.74 | 18.94 | 85.21 | 189.36 | 539.68
AA-005
Monthly Plant Total (lbs)
1999-11-01 00:00:00
[NAME] | NOX | SO2 | VOC | TSP | CO
Unit ID
AA-001 | 15.02 | 1.24 | 5.59 | 8.08 | 35.43
AA-002 | 8.61 | 3.82 | 17.18 | 24.82 | 108.82
AA-003 | 12.3 | 1.79 | 8.04 | 17.88 | 50.95
AA-004 | 450.58 | 12.17 | 54.78 | 121.74 | 346.95
AA-005
Monthly Plant Total (lbs)
1999-12-01 00:00:00
[NAME] | NOX | SO2 | VOC | TSP | CO
Unit ID
AA-001 | 55.09 | 0.82 | 3.68 | 5.32 | 23.32
AA-002 | 237.64 | 2.73 | 12.28 | 17.73 | 77.76
AA-003 | 7 | 0.11 | 0.48 | 1.07 | 3.05
AA-004 | 8.89 | 0.13 | 0.58 | 1.3 | 3.7
AA-005
Monthly Plant Total (lbs)
YTD UNIT TOTALS (lbs)
[NAME] | NOX | SO2 | VOC | TSP | CO
Unit ID
AA-001
AA-002
AA-003
AA-004
AA-005
 | Year To Date TOTALS ([NAME])
 | NOX | SO2 | VOC | TSP | CO
PERMIT LIMITS | 249 TONS | 10 TONS | 35 TONS | 55 TONS | 225 TONS
Spreadsheet: 328394d1403885548-want-to-select-filter-results-from-another-sheet-test-values
Sheet: Summary

Week | LTD Total Result | Volume | Average LTD Result |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Home Page
'2014 wk01'!A1
'2014 wk02'!A1
'2014 wk03'!A1
'2014 wk04'!A1
'2014 wk05'!A1
'2014 wk06'!A1
'2014 wk07'!A1
'2014 wk08'!A1
'2014 wk09'!A1
'2014 wk10'!A1
'2014 wk11'!A1
2014 wk12 | N/A | N/A | N/A
'2014 wk13'!A1
'2014 wk14'!A1
'2014 wk15'!A1
2014 wk16 | N/A | N/A | N/A
'2014 wk17'!A1
'2014 wk18'!A1
'2014 wk19'!A1
2014 wk20 | N/A | N/A | N/A
'2014 wk21'!A1
'2014 wk22'!A1
'2014 wk23'!A1
'2014 wk24'!A1
Spreadsheet: 165917d1341397533-convert-multiple-row-data-to-single-row-with-multiple-columns-convertrowtocolumn
Sheet: Sheet1

Acc No. | Name |  | Count
1 | Alvin Ltd
1 | [NAME]
1 | Terabase td
2 | [NAME]
2 | Get Ltd
3 | Wonder Ltd
3 | Vase SDH
3 | Growth Ltd
4 | Vege SDH
Spreadsheet: michelle_lokay__26710__TW Open Season 012002
Sheet: Sheet1

Transwestern Open Season (01/22/2002)
Shipper | Bid | Term | Receipt | Delivery
PG&E Energy Trading | 0.205 | Feb-Oct 2002 | San Juan | Needles 10000, Topock 10000
Sempra Energy Trading | 0.181 | Feb-Oct 2002 | San Juan | Needles 10000, Topock/Calpine/SWGas 10000
BPAmoco | 0.18 | Feb-Oct 2002 | San Juan | Needles 10000, Topock 10000
Reliant | 0.151 | Feb-Oct 2002 | San Juan | Needles 10000, Topock 10000
Duke Energy Trading & Marketing | 0.151 | Feb-Oct 2002 | San Juan | Needles 10000
[NAME] (USGT) | 0.1126 | Feb-Oct 2002 | San Juan | Needles 10000, Topock 10000
Conoco Inc. | 0.11 | Feb-Oct 2002 | San Juan | Needles 10000
Western Gas Resources, Inc. | 0.095 | Feb-Oct 2002 | San Juan | Needles 10000, Topock 10000
Astra Power LLC | 0.0756 | Feb-Oct 2002 | San Juan | Needles 10000, Topock 10000
Conoco Inc. | * | Feb-Oct 2002 | San Juan | Needles 10000
*NGI SoCal minus .01 less IF El Paso SJ less fuel
Spreadsheet: 43074d1241674320-inserting-and-removing-select-rows-pivot
Sheet: Gear

Category | Item | Weight (g) | Problem 1 | What I want is an option off to the side to delete specific categories from this worksheet completely.  For example, when YES is selected next to 'Backpacks - Frameless' in H24, rows 12:19 would then be  deleted. |  |  |  |  | YES
Backpacks - Accessories | Arc'Teryx Pack Cover | 150.25
Backpacks - Accessories | Arc'Teryx Accessory Pocket
Backpacks - Accessories | Arc'Teryx Axe Keeper |  |  | Also, what I want is for the Categories to automatically Delete themselves if no items remain in them.  Example: Row 29, [NAME], I have just deleted the last remaining item in this category. I would like my worksheet to recognize there are (0) items in this category and remove the rows for me. Rows 29:32.
Backpacks - Accessories | Osprey Packs Backpack Raincover - Large | 200
Backpacks - Accessories | [NAME] with Dongle | 158.7
Backpacks - Accessories | Osprey Airporter LZ Pack Duffel (x2) | 368.54
Backpacks - Frameless | Arc'Teryx Arro 22L | 1110.16 | Problem 2 | I want to insert Category rows into there alphabetically correct location down the worksheet when a visibility option is triggered. Example: Changing J29 to YES would insert the Category (including the 3 rows below it) onto the worksheet between [NAME] and Bear Protection. (In effect, inserting my example rows 65:68 into its proper place)
Backpacks - Frameless | [NAME] 21L | 1140.21
Backpacks - Frameless | [NAME] | 1000.17
Backpacks - Frameless | Dynafit RC20 Race | 430.06
Backpacks - Internal Frame | Arc'Teryx Bora 80L | 3231.84
Backpacks - Internal Frame | [NAME] | 2239.61 |  |  |  |  | Remove | Visible | Visible
Backpacks - Internal Frame | Arc'Teryx Naos 55L | 2126.21 |  |  |  | Backpacks - Accessories | NO | NO | YES
Backpacks - Internal Frame | [NAME] 75 + 20L | 2749.9 |  |  |  | Backpacks - Fameless | YES | YES | YES
Backpacks - Internal Frame | Osprey Crescent 110L | 3401.94 |  |  |  | Backpacks - Internal Frame | NO | YES | YES
[NAME] Sacks | MSR Packshower | 581.6
[NAME] Sacks | Sea to Summit Ultra-Sil - 1L - 6 x 9 - Green | 20
[NAME] Sacks | Sea to Summit Ultra-Sil - 8L - 6.5 x 18 - Blue | 30
[NAME] Sacks | Sea to Summit Ultra-Sil - 13L - 8.5 x 21 - Green | 40
[NAME] Sacks | Sea to Summit Ultra-Sil - 20L - 10 x 24 - Blue | 50
[NAME] Sacks | REI [NAME] x 16.5
[NAME] Sacks | Cactus Creek ProLite 3 - Short | 22.1126218622191
[NAME] Sacks | Therm-a-Rest ProLite 3 - Short | 21.26213640597991
[NAME] Sacks | Therm-a-Rest ProLite 4 - Reg | 25.51456368717588
Bear Protection | Ursack S29 Bear Resistant Food Bag | 167.2621397270419
Batteries | INSERT NEW ITEM HERE |  |  | <<<<JUST THERE FOR EXAMPLE OF WHAT'S TO BE INSERTED
Spreadsheet: bcaa233d-1030-48e1-9a75-087058be4799
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Atlantic-Elektra | 75678997914 | Needtobreathe | Heat, The | 2007-08-28 | Compact Disc | Rock | 7.99 | Y | Available
Atlantic-Elektra | 75678959721 | Needtobreathe | Outsiders, The | 2009-08-25 | Compact Disc | Rock | 13.99 | Y | Available
Merch | 679143015792 | Needtobreathe | Unisex Band [NAME] | 2009-01-06 | T-Shirt | Na | 18.99 | N | Available
Merch | 679143015808 | Needtobreathe | Unisex Band Logo Size Medium | 2009-01-06 | T-Shirt | Na | 18.99 | N | Available
Merch | 679143015815 | Needtobreathe | Unisex Band [NAME] Large | 2009-01-06 | T-Shirt | Na | 18.99 | N | Available
Merch | 679143015822 | Needtobreathe | Unisex Band [NAME] Xlarge | 2009-01-06 | T-Shirt | Na | 18.99 | N | Available
Atlantic-Elektra | 75678826214 | Needtobreathe | Reckoning, The | 2011-09-20 | Compact Disc | Alt | 13.99 | Y | Available
Atlantic-Elektra | 75678696046 | Needtobreathe | Natural Splice Xlarge Unisex | 2014-04-22 | T-Shirt | Na | 18.99 | Y | NYP
Atlantic-Elektra | 75678696060 | Needtobreathe | Natural Splice Large Unisex | 2014-04-22 | T-Shirt | Na | 18.99 | Y | NYP
Atlantic-Elektra | 75678696053 | Needtobreathe | Natural Splice Medium Unisex | 2014-04-22 | T-Shirt | Na | 18.99 | Y | NYP
Atlantic-Elektra | 75678695957 | Needtobreathe | Black Scribble Stack Xlarge Unisex | 2014-04-22 | T-Shirt | Na | 18.99 | Y | NYP
Atlantic-Elektra | 75678695964 | Needtobreathe | Black Scribble Stack Large Unisex | 2014-04-22 | T-Shirt | Na | 18.99 | Y | NYP
Atlantic-Elektra | 75678695971 | Needtobreathe | Black Scribble Stack Medium Unisex | 2014-04-22 | T-Shirt | Na | 18.99 | Y | NYP
Atlantic-Elektra | 75678676925 | Needtobreathe | Rivers In The Wasteland | 2014-04-15 | Compact Disc | Ac | 13.99 | Y | NYP