tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 142069d1329619249-excel-2010-data-pulling-resident-roster-feb-7-2012
Sheet: Snack Stickers

AM | 2012-02-11 00:00:00 |  |  | 0 | 2012-02-11 00:00:00 |  |  | 0 | 2012-02-11 00:00:00
[NAME] | [NAME] |  |  | 125ml Orange Drink | AM |  |  | 0 | 0
102E | 125ml Orange Drink |  |  | Regular | 0 |  |  | 0 | 0
Regular | Regular |  |  | 0 | 0 |  |  | 0 | 0
AM | 2012-02-11 00:00:00 |  |  | 0 | 2012-02-11 00:00:00 |  |  | 0 | 2012-02-11 00:00:00
[NAME] | [NAME] |  |  | 0 | AM |  |  | 0 | 0
106B | 0 |  |  | Minced | 0 |  |  | 0 | 0
Modified Diabetic | Minced |  |  | 0 | 0 |  |  | 0 | 0
AM | 2012-02-11 00:00:00 |  |  | 0 | 2012-02-11 00:00:00 |  |  | 0 | 2012-02-11 00:00:00
[NAME] | [NAME] |  |  | 0 | AM |  |  | 0 | 0
110A | 0 |  |  | Minced | 0 |  |  | 0 | 0
Regular | Minced |  |  | 0 | 0 |  |  | 0 | 0
AM | 2012-02-11 00:00:00 |  |  | 0 | 2012-02-11 00:00:00 |  |  | 0 | 2012-02-11 00:00:00
[NAME] | [NAME] |  |  | 0 | AM |  |  | 0 | 0
114 | 0 |  |  | Regular | 0 |  |  | 0 | 0
Modified Diabetic | Regular |  |  | 0 | 0 |  |  | 0 | 0
AM | 2012-02-11 00:00:00 |  |  | 0 | 2012-02-11 00:00:00 |  |  | 0 | 2012-02-11 00:00:00
[NAME] | [NAME] |  |  | 0 | AM |  |  | 0 | 0
118B | 0 |  |  | Regular | 0 |  |  | 0 | 0
Modified Diabetic | Regular |  |  | 0 | 0 |  |  | 0 | 0
AM | 2012-02-11 00:00:00 |  |  | 0 | 2012-02-11 00:00:00 |  |  | 0 | 2012-02-11 00:00:00
[NAME] | Sandra Price |  |  | 125ml [NAME] | AM |  |  | 0 | 0
122A | 125ml [NAME] |  |  | Regular | 0 |  |  | 0 | 0
Energy Control | Regular |  |  | 0 | 0 |  |  | 0 | 0
AM | 2012-02-11 00:00:00 |  |  | 0 | 2012-02-11 00:00:00 |  |  | 0 | 2012-02-11 00:00:00
[NAME] | [NAME] |  |  | 0 | AM |  |  | 0 | 0
125B | 0 |  |  | Regular | 0 |  |  | 0 | 0
Regular | Regular |  |  | 0 | 0 |  |  | 0 | 0
AM | 2012-02-11 00:00:00 |  |  | 0 | 2012-02-11 00:00:00 |  |  | 0 | 2012-02-11 00:00:00
Mayfair | [NAME] |  |  | 0 | AM |  |  | 0 | 0
153 | 0 |  |  | Minced | 0 |  |  | 0 | 0
[NAME] | Minced |  |  | 0 | 0 |  |  | 0 | 0
AM | 2012-02-11 00:00:00 |  |  | 0 | 2012-02-11 00:00:00 |  |  | 0 | 2012-02-11 00:00:00
Mayfair | [NAME] |  |  | 0 | AM |  |  | 0 | 0
158 | 0 |  |  | Minced | 0 |  |  | 0 | 0
Regular | Minced |  |  | 0 | 0 |  |  | 0 | 0
AM | 2012-02-11 00:00:00 |  |  | 0 | 2012-02-11 00:00:00 |  |  | 0 | 2012-02-11 00:00:00
Mayfair | [NAME] |  |  | 0 | AM |  |  | 0 | 0
162 | 0 |  |  | Regular | 0 |  |  | 0 | 0
Regular | Regular |  |  | 0 | 0 |  |  | 0 | 0
Spreadsheet: 826694d1682170652-count-sort-data-in-arrays-spill-aligw
Sheet: Sheet1

 | 1. Make a selection in B4 |  |  | 2. Desired Output - sorted by frequency
 |  |  |  | ↓ | ↓
 |  |  |  | ↓ | ↓
Selection: | Mon |  |  | ↓ | ↓
 |  |  |  | ↓ | ↓
Colors | Days |  |  | Color | Frequency
Red | Mon |  |  |  | 3
Red | Tue |  |  | Red | 2
Blue | Wed |  |  | Blue | 1
Green | Thu
Green | Fri
Green | Sat
Red | Sun
Red | Mon
Blue | Tue
Green | Wed
Green | Thu
Green | Fri
Red | Sat
Red | Sun
Blue | Mon
Green | Tue
Green | Wed
Green | Thu
Red | Fri
Red | Sat
Blue | Sun
Green | Mon
Green | Tue
Green | Wed
Red | Thu
Red | Fri
Blue | Sat
Green | Sun
Green | Mon
Green | Tue
Blue | Wed
Green | Thu
Green | Fri
Green | Sat
Blue | Sun
Green | Mon
Spreadsheet: 795232d1662568453-if-a-cell-is-empty-or-blank-or-zero-get-value-error-test-formula
Sheet: Dabigatran AF

Serum creatinine value
97 umol/L
97 umol/L
121 umol/L
0 umol/L
72 umol/L
81 umol/L
86 umol/L
105 umol/L
72 umol/L
79 umol/L
57 umol/L
88 umol/L
97 umol/L
80 umol/L
177 umol/L
Spreadsheet: 124243d1318267411-vlookup-help-billablehrsedit
Sheet: Sheet1

O'Donovan & Sullivan Law Associates
BILLING SUMMARY
OCTOBER 8 TO 12, 2012
File | Client | Date | Attorney Code | Billable Hours | [NAME] | Legal Fees | Billing Statistics
FL-325 | 10104 | 2012-10-08 00:00:00 | 1 | 26.75 |  |  | Total Legal Fees Billed by Attorney
EP-652 | 10106 | 2012-10-08 00:00:00 | 1 | 12.1 |  |  | 1 | [NAME]
CL-412 | 10125 | 2012-10-08 00:00:00 | 2 | 33.25 |  |  | 2 | [NAME]
IN-745 | 10210 | 2012-10-09 00:00:00 | 3 | 24.25 |  |  | 3 | [NAME]
EL-632 | 10225 | 2012-10-09 00:00:00 | 3 | 12.11 |  |  | 4 | [NAME]
RE-475 | 10285 | 2012-10-09 00:00:00 | 4 | 42.3 |  |  |  | TOTAL
CL-501 | 10341 | 2012-10-10 00:00:00 | 2 | 15.25
CL-521 | 10334 | 2012-10-10 00:00:00 | 2 | 20.25 |  |  | Average Billable Hours by Attorney
PL-348 | 10420 | 2012-10-10 00:00:00 | 3 | 25 |  |  | 1 | [NAME]
RE-492 | 10425 | 2012-10-10 00:00:00 | 4 | 22.7 |  |  | 2 | [NAME]
EL-632 | 10225 | 2012-10-11 00:00:00 | 3 | 23 |  |  | 3 | [NAME]
PL-512 | 10290 | 2012-10-11 00:00:00 | 3 | 16.2 |  |  | 4 | [NAME]
IN-745 | 10210 | 2012-10-11 00:00:00 | 3 | 14.5
FL-385 | 10278 | 2012-10-11 00:00:00 | 1 | 24 |  |  | Attorney Code Table
CL-412 | 10125 | 2012-10-12 00:00:00 | 2 | 15.25 |  |  | Code | Attorney | [NAME]
CL-450 | 10358 | 2012-10-12 00:00:00 | 2 | 23.5 |  |  | 1 | [NAME] | 85
IN-801 | 10346 | 2012-10-12 00:00:00 | 3 | 14.25 |  |  | 2 | [NAME] | 75
EP-685 | 10495 | 2012-10-12 00:00:00 | 3 | 23.75 |  |  | 3 | [NAME] | 100
RE-501 | 10384 | 2012-10-12 00:00:00 | 4 | 13.75 |  |  | 4 | [NAME] | 90
 |  |  | TOTAL |  | TOTAL
Spreadsheet: 587929d1535387774-mark-duplicates-in-a-new-column-as-a-unique-value-forum-question
Sheet: After

Member | time stamp | duplicate's unique identifier
[NAME] doe | 2017-12-01 01:43:00 | duplicate 1
[NAME] | 2017-12-01 01:43:00 | duplicate 2
[NAME] erving | 2017-12-01 01:44:00 | duplicate 3
[NAME] | 2017-12-01 01:45:00 | duplicate 4
[NAME] | 2017-12-01 01:54:00 | duplicate 5
meredith hayes | 2017-12-01 02:02:00 | duplicate 6
[NAME] redding | 2017-12-01 03:19:00 | duplicate 7
haley barnes | 2017-12-01 03:31:00 | duplicate 8
[NAME] | 2017-12-01 03:31:00 | duplicate 9
[NAME] | 2017-12-01 03:33:00 | duplicate 9
[NAME] doe | 2017-12-01 03:34:00 | duplicate 1
haley barnes | 2017-12-01 05:39:00 | duplicate 8
[NAME] | 2017-12-01 07:02:00 | duplicate 5
[NAME] redding | 2017-12-01 07:51:00 | duplicate 7
[NAME] | 2017-12-01 07:52:00 | duplicate 2
[NAME] erving | 2017-12-01 07:58:00 | duplicate 3
[NAME] | 2017-12-01 07:59:00 | duplicate 10
[NAME] | 2017-12-01 08:11:00 | duplicate 2
meredith hayes | 2017-12-04 01:29:00 | duplicate 6
[NAME] redding | 2017-12-04 01:59:00 | duplicate 7
[NAME] | 2017-12-04 06:38:00 | duplicate 10
[NAME] doe | 2017-12-04 06:51:00 | duplicate 1
reed maze | 2017-12-04 07:00:00 | duplicate 11
reed maze | 2017-12-04 07:07:00 | duplicate 12
[NAME] | 2017-12-04 07:21:00 | duplicate 2
[NAME] erving | 2017-12-04 07:23:00 | duplicate 3
[NAME] redding | 2017-12-04 08:34:00 | duplicate 7
haley barnes | 2017-12-04 12:30:00 | duplicate 8
[NAME] | 2017-12-05 01:11:00 | duplicate 10
[NAME] | 2017-12-05 01:13:00 | duplicate 9
meredith hayes | 2017-12-05 01:14:00 | duplicate 6
[NAME] | 2017-12-05 01:54:00 | duplicate 4
[NAME] | 2017-12-06 01:54:00 | duplicate 13
[NAME] doe | 2017-12-07 01:54:00 | duplicate 1
Spreadsheet: 0cd51ed5-1eb7-4297-add7-0e2fbec4e6e8
Sheet: Sheet1

DiGiProg III full package | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
No | Description | Qty |  | Remarks
1 | [NAME] | 1
2 | [NAME] | 1
3 | [NAME] | 1
4 | [NAME] | 1
5 | [NAME] | 1
6 | [NAME] adapter21/2 | 1
7 | [NAME] | 1
8 | [NAME] | 1
9 | Digi P3 adapter27/2 | 1
10 | [NAME] | 1
11 | [NAME] | 1
12 | [NAME] | 1
13 | [NAME] | 1
14 | [NAME] | 1
15 | [NAME] | 1
16 | [NAME] | 1
17 | [NAME] | 1
18 | [NAME] | 1
19 | [NAME] | 1
20 | [NAME] | 1
21 | [NAME] | 1
22 | [NAME] | 1
23 | [NAME] | 1
24 | [NAME] | 1
25 | [NAME] | 1
26 | [NAME] | 1
27 | [NAME] | 1
28 | [NAME] | 1
29 | Digi P3 adapter55/2 | 1
30 | [NAME] | 1
31 | Digi P3 adapter79/2 | 1
32 | [NAME] | 1
33 | Digi P3 adapter43/2 | 1
34 | [NAME] | 1
35 | Digi P3 adapter45/2 | 1
36 | Digi P3 adapter BMW CAS | 1
37 | USB Cable | 1
38 | Car cigarette cord 12V | 1 |  | inside positive
39 | [NAME] | 1
40 | [NAME] | 1
41 | [NAME] | 1
42 | [NAME] | 1
43 | [NAME] adapter17/2 | 1
44 | [NAME] | 1
45 | Digi P3 adapter06/2 | 1
46 | 12V Power | 1
Spreadsheet: 98301d1297265525-vlookup-codes-based-type-of-contract-shop-codes
Sheet: Finance

Contract | Description | Subjective
AMS | Office Expenses | H2334
 | Rent | H3546
 | PAYE | H6754
MGS | Office Expenses | X6543
 | Rent | R4567
 | PAYE | N4567
CDL | Office Expenses | C5673
 | Rent | C2345
 | PAYE | C1233
Spreadsheet: 455146d1460129864-clean-up-if-then-formula-adding-in-isblank-range-oversize-1
Sheet: Sheet1

 |  | Actual  Weight | L | W | H | [NAME] | Billable Weight | Additional Handling | Oversize
 |  | 2 | 69 | 15 | 25 | 156 | 156
 |  | 25 | 16 | 17 |  | 0 | 25
 |  | 4.5 | 15 | 31 | 34 | 96 | Letter
 |  | 7.6 |  |  |  | 0 | 8
 |  | 5 | 15 | 10 | 6 | 6 | 6
 |  | 6.2 |  |  |  | 0 | 7
 |  | 7.6 |  |  |  | 0 | 8
 |  | 8 |  |  |  | 0 | 8
Spreadsheet: 709826d1608571455-help-me-to-use-another-cell-value-as-the-range-value-of-correl-or-similar-function-book3-excelforum-correlation
Sheet: Sheet2

2 | 200
2.5 | 245
2.8 | 146
3.5 | 185
3.8 | 158
4.3 | 131
4.76 | 104
5.22 | 77
5.68 | 50
6.14 | 366
6.6 | 290
7.06 | 80
7.52 | 50
7.98 | 165
7.6 | 125
7.2 | 85
6.8 | 45 |  | 16
6.4 | 5 |  | 15
6 | 25 |  | 8
5.6 | 166 |  | 4
5.2 | 185 |  | 2
4.8 | 217.5 |  | 2
4.4 | 261.6 |  | 4
4 | 305.7 |  | 6
3.6 | 349.8 |  | 8
3.2 | 393.9 |  | 10
2.80000000000001 | 438 |  | 12
2.40000000000001 | 482.1 |  | 15
Spreadsheet: 842166d1694225608-sum-of-times-a-person-does-a-task-with-a-date-filter-no-pivot-table-excel-formula-09-07-2023
Sheet: Sheet1

 | Phases Only
 | Accout Clean Ups |  | Imp |  | Light Imp
Team Member | Account Cleanup | % of Account Set ups | Implementation | % of Full Imp | Light Implementation | % of Light Imp
Zachary
Laurel
[NAME]
[NAME]
Total
Goal: To Sum the total of Account Clean Up, Implementation, and Light Implementation for each Team Member based on date selected in Sheet2.
Spreadsheet: 76502d1277060544-dates-format-in-excel-file-test
Sheet: Sheet1

Deal Assumption |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | List
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Department
Department | Order type | Cycle time to revenue | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Push Pro | Small
Push Pro | Small | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | StoreFront | Medium
Push Pro | Medium | 60 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AirMail | Large
Push Pro | Large | 90
StoreFront | Small | 30
StoreFront | Medium | 90
StoreFront | Large | 120
AirMail | Small | 30
AirMail | Medium | 90
AirMail | Large | 120
 |  |  | # Prospects Closed |  |  | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00
 |  |  | Media | Department | Order Type
 |  |  | X-Small Customer | Push Pro | Small | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
 |  |  | S -Medium Customer | Push Pro | Medium | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
 |  |  | StoreFront-Sm | StoreFront | Small | 2 | 2 | 2 | 6 | 8 | 6 | 8 | 6
 |  |  | StoreFront-Med | StoreFront | Medium | 1 | 1 | 1 | 3 | 3 | 3 | 3 | 3
 |  |  | StoreFront-Large | StoreFront | Large | 1 | 1 | 1 | 2 | 2 | 2 | 1 | 2
 |  |  | Z-Small | AirMail | Small | 0 | 3 | 3 | 10 | 10 | 10 | 10 | 10
 |  |  | Z-Medium | AirMail | Medium | 0 | 2 | 2 | 6 | 8 | 6 | 8 | 6
 |  |  | Z-Large | AirMail | Large | 0 | 0 | 1 | 1 | 1 | 2 | 2 | 2
 |  |  | Prospects Become Revenue |  |  | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00
 |  |  | Media | Department | Order Type
 |  |  | X-Small Customer | Push Pro | Small |  | 4
 |  |  | S -Medium Customer | Push Pro | Medium
 |  |  | StoreFront-Sm | StoreFront | Small
 |  |  | StoreFront-Med | StoreFront | Medium
 |  |  | StoreFront-Large | StoreFront | Large
 |  |  | Z-Small | AirMail | Small
 |  |  | Z-Medium | AirMail | Medium
 |  |  | Z-Large | AirMail | Large
Spreadsheet: 726049d1617028515-pulling-data-at-the-end-of-a-business-day-sample2
Sheet: RECURRING TABLE

 | OLD VALUES |  |  | NEW VALUES
Resignations | Last Week | This Week |  | Last Week | This Week
Campus | 2021-03-26 00:00:00 | 2021-04-02 00:00:00 |  | 2021-04-02 00:00:00 | 2021-04-09 00:00:00
 | # of Resignations | # of Resignations |  | # of Resignations | # of Resignations |  | Premise: I have to compile a chart that denotes values from last week to this week. Every Saturday, the sheet should pull the transfer the this week column to last week column and pull info for the new week. It all needs to be done in a single chart (not two) as I want to have a line graph auto-updating every week. [NAME] is pulled from the first table under Maria.
School 1 | 2 | 1 |  | 1 | 5
School 2 | 5 | 2 |  | 2 | 3
School 3 | 3 | 2 |  | 2 | 4
School 4 | 6 | 9 |  | 9 | 8
School 5 | 8 | 2 |  | 2 | 5
School 6 | 1 | 3 |  | 3 | 2
School 7 | 9 | 4 |  | 4 | 3
School 8 | 2
School 9 | 3 | 8 |  | 8 | 2
School 10 | 4 | 6 |  | 6 | 5
School 11 | 6 | 1 |  | 1 | 3
School 12 | 8 | 6 |  | 6 | 7
School 13 | 6 | 2 |  | 2 | 4
School 14 | 1 | 2 |  | 2 | 5
School 15 | 6 | 6 |  | 6 | 3
School 16 | 2 | 5 |  | 5 | 1
School 17 | 2 | 9 |  | 9 | 2
School 18 | 6 | 4 |  | 4 | 4
School 19 | 5 | 1 |  | 1 | 3
School 20 | 9 | 1 |  | 1 | 2
School 21 | 4 | 3 |  | 3 | 4
School 22 | 1 | 5 |  | 5 | 5
School 23 | 1 | 8 |  | 8 | 9
TOTAL
Spreadsheet: 878287d1725362674-date-validation-issue-exampleworkbook_dependentdv
Sheet: Sheet1

M2_MaterialCategories |  | M2_Materials
catCategories |  | matCategory | matMaterials
↓ |  | ↓ | ↓
Categories |  | Category | Materials | Rate
[NAME] |  | [NAME] | 3mm Clear | 40.45
Bulkheads |  | [NAME] | 4mm Clear | 51.75
Other |  | [NAME] | 4mm Clear Tough | 133.75
 |  | [NAME] | 5mm Clear | 65.7
 |  | Other | CFC | 142.75
 |  | Other | Compact | 82.9
 |  | Bulkheads | MDF | 40
 |  | Bulkheads | Colour | 60
 |  | Bulkheads | Shadow | 30
Spreadsheet: 0a8791de-84e4-4eb4-bfac-22483612972b
Sheet: Mining Tech Cert 1

MINING TECHNOLOGY
Certificates
Student Name:
ID #
Underground Operator | Semester | Grade
___ MNG 160 (3) Elements of Underground Mining
___ MNG 161 (1-3) Elements of Underground Mining Lab
___ EFM 100 (3) Personal Financial Management
OR ___ [NAME] (3) Personal Finance
___ WPP 200 (3) Workplace Principles
Underground Mechanic/Electrician
___ CIT 105 (3) Introduction to Computers OR ___ IC3 Computer Literacy Exam
___ Blueprint Reading Course (2-3)
___ MNG 123 (4) Mining Electricity I
___ MNG 125 (1) Mining Electricity I Lab
___ IMT 100 (3) Welding for Maintenance
___ IMT 101 (2) Welding for [NAME]
___ ET/ELT 244 (4) Electrical Machinery and Controls
OR ___ IMT 110 (3) Industrial Maintenance Electrical Principles
AND ___ IMT 111 (2) Industrial Maintenance Electrical Principles Lab
___ET/ELT 250 (4) Programmable Logic Controllers
___ ET/ELT 265 (3) Applied Fluid Power
OR ___ FPX 100 (3) Fluid Power
AND ___ FPX 101 (2) Fluid Power Lab
___ IMT 150 (3) Maintaining Industrial Equipment I
___ IMT 151 (2) Maintaining industrial Equipment I Lab
Underground Supervisor
___ MNG 150 (3) Mining Laws
___ MNG 274 (3) Mine Safety
___ MNG 190 (3) Mine Emergency Technician
OR ___ KHP 190 (2) First Aid and Emergency Care
___ [NAME] (3) Introduction to Business
___ MNG 286 (3) [NAME] and Ventilation
___ CIT 105 (3) Introduction to Computers OR ___ IC3 Computer Literacy Exam
___ Blueprint Reading course (2-3)
Southeast Kentucky Community & Technical College | Updated Spring 2013
Spreadsheet: tracy_geaccone__40442__OM EST - OSS - 2001 - 2002 REVISED FORMAT
Sheet: Gross

GROSS  O & M COSTS
(including Benefits & Payroll Taxes)
OPERATIONS SUPPORT SERVICES (Included in Finance & Accounting)
( $ In Thousands)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Original
 |  | Gross |  | Gross |  | Gross |  | Gross |  | Gross |  | Gross |  | Gross |  | Gross |  | Gross |  | Gross |  | Gross |  | Gross |  | Gross |  | Gross |  | Gross |  | Gross O&M |  | Gross |  |  |  | Gross
 |  | Oct |  | Avg |  | 2001 |  | 2001 |  | 2002 |  | 2002 |  | 2002 |  | 2002 |  | 2002 |  | 2002 |  | 2002 |  | 2002 |  | 2002 |  | 2002 |  | 2002 |  | % O(U) |  | 2002 |  | 2002 |  | 2002
Department |  | YTD |  | Spend |  | Nov |  | Dec |  | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | 2000 Plan |  | Dec |  | Total |  | Total |  | Savings
NNG
TW
Citrus
Northern Border Partners
EOTT (Co 1195) **
[NAME]
GCO/HPL |  |  |  |  |  | 94 |  | 94
EAMR |  |  |  |  |  | 73 |  | 58 |  | 312.71 |  | 307.863 |  | 314.823 |  | 315.848 |  | 313.273 |  | 314.018 |  | 307.573 |  | 307.718 |  | 316.353 |  | 322.623 |  | 308.363 |  |  |  | 312.383
ETS
Other * |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  | 0
Total
Total Original 2002 Plan
Savings from Original 2002 Plan
* For companies outside of ETS
**  Exclude Co. 1195
NOTE:  For Nov. 2001 through Dec. 2002 provide your best guess of minimum spend required
Spreadsheet: darrell_schoolcraft__7827__imbalsumm0110
Sheet: volvalue

VOLUMETRIC IMBALANCES
Operator | 2000-12-01 00:00:00 | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 2001-10-01 00:00:00
Mojave Pipeline | 75659 | 63393 | 41052 | 3829 | 26482 | 3949 | 133095 | 135803 | 151464
SoCal | -42847 | -2392 | -1948 | 47976 | 39224 | -21565 | 123192 | 145102 | 151133
PG&E Topock | 147492 | 59676 | 69410 | 93592 | 38770 | -10045 | -12760 | 24900 | 43542
El Paso - Window Rock | -7121 | -7121 | -7121 | 23739 | 47545 | 47545 | 50521 | 64269 | 64269
NGPL - Winkler | -32074 | -32074 | -25783 | -25783 | 19880 | 37616 | 72277 | 30271 | 12393
NGPL - Gray | 81654 | 79650 | 30618 | 43969 | 37185 | 54911 | 120061 | 120061 | 127284
Panhandle Eastern | 11018 | 12567 | 19121 | 30904 | 33216 | 27926 | 95102 | 76325 | 48988
Oasis | 70928 | 24533 | 29886 | 22591 | 45729 | 1307 | 28278 | 34979 | 47553
Lonestar | -7752 | 3487 | 3487 | 6729 | 54217 | 61895 | 69314 | 36339 | 73003
TW average index |  | 8.21 | 5.62 | 4.98 | 4.87 | 3.82 | 3.2 | 2.77 | 2.77 | 1.88
[NAME] | -70145 | -44467 | -9747 | 30129 | 121747 | 278779 | 286331 | 310267 | 275390
Amoco-Florida Plant | -55807 | -32211 | -38475 | -32230 | 82528 | 94855 | 59179 | 54883 | 87070
El Paso - Blanco | 268892 | 198073 | 173680 | 168646 | 255346 | 300960 | 170528 | 27596 | -65974
Northwest | -119838 | -60187 | 6957 | -37371 | -18982 | -386 | 11234 | 5110 | 70754
TW San Juan Blanco |  | 8.1 | 5.61 | 4.87 | 4.62 | 3.44 | 2.58 | 2.45 | 2.61 | 1.73
 |  |  |  |  |  |  |  |  |  | 2037075.88
Red Cedar | 3246 | 30877 | 40063 | 48379 | 80516 | 96175 | 140689 | 147133 | 143078
Spreadsheet: 168650d1342535082-vlookup-using-multiple-table_array-vlookup400
Sheet: Sheet1

Code | Descript |  | Code | Descript
 |  |  |  | #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
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
V | V | V | V | V | V | V | V
Spreadsheet: 128727d1321238048-problem-with-conditional-formatting-modified-ranking-report
Sheet: Ranking Report

 |  | Ranking Report
SEOT | Keyword | URL |  |  |  | 2011-10-20 00:00:00 | 2011-10-21 00:00:00 | 2011-10-23 00:00:00 | 2011-10-24 00:00:00 | 2011-10-25 00:00:00 | 2011-10-26 00:00:00
 | cosmetics | http://faceofaustralia.com.au
 |  | http://faceofaustralia.com.au/cosmetics
 | makeup | http://faceofaustralia.com.au
 |  | http://faceofaustralia.com.au/makeup
 | mascara | http://faceofaustralia.com.au
 |  | http://faceofaustralia.com.au/mascara
 | eyeliner | http://faceofaustralia.com.au
 |  | http://faceofaustralia.com.au/eyeliner
 | primer | http://faceofaustralia.com.au
 |  | http://faceofaustralia.com.au/primer
 | [NAME] | http://faceofaustralia.com.au
 |  | http://faceofaustralia.com.au/blush
Spreadsheet: 159315d1338576457-vlookup-help-copy_sample
Sheet: Sheet3

Project Name | Type | Vendor | Amount
Project Number 1 | Outsourced | Vendor 1 | -5411 |  | Project Name | Outsourced | Inhouse | Revenue
 |  | Vendor 2 | -541 |  | Project Number 1
 | Inhouse | Costs | -571 |  | Project Number 2
 |  |  | -4413
 |  |  | -541
 | Revenue | Coustomer 1 | 6584 |  | Sum of Amount | Column Labels
 |  | Customer 2 | 1532 |  | Row Labels | Outsourced | Inhouse | Revenue | Grand Total
Project Number 2 | Outsourced | Vendor 2 | -26 |  | Project Number 1 | -5952 | -5525 | 8116 | -3361
 | Inhouse | Costs | -52 |  | Project Number 2 | -26 | -20402 | 57160 | 36732
 |  |  | -5412 |  | Grand Total | -5978 | -25927 | 65276 | 33371
 |  |  | -252
 |  |  | -14563
 |  |  | -123
 | Revenue | Coustomer 1 | 56516
 |  | Customer 2 | 123
 |  | Customer 3 | 521
Spreadsheet: 96625d1295981666-looking-for-formula-that-will-catch-special-rule-abuse-for-the-same-id-book1
Sheet: Sheet3

ID | date | SLED | check
22 | 2010-01-23 00:00:00 | 2012-01-09 00:00:00
22 | 2010-01-24 00:00:00 | 2012-01-14 00:00:00 | error
22 | 2010-01-25 00:00:00 | 2012-01-14 00:00:00 | error
22 | 2010-01-26 00:00:00 | 2012-01-10 00:00:00
22 | 2010-01-27 00:00:00 | 2012-01-12 00:00:00
22 | 2010-01-28 00:00:00 | 2012-01-14 00:00:00
22 | 2010-01-28 00:00:00 | 2012-01-15 00:00:00 | error
22 | 2010-01-29 00:00:00 | 2012-01-14 00:00:00
24 | 2010-01-23 00:00:00 | 2011-02-28 00:00:00 | error
24 | 2010-01-23 00:00:00 | 2011-02-28 00:00:00 | error
24 | 2010-01-23 00:00:00 | 2011-01-30 00:00:00
24 | 2010-01-24 00:00:00 | 2011-01-31 00:00:00
24 | 2010-01-24 00:00:00 | 2011-02-28 00:00:00
24 | 2010-01-25 00:00:00 | 2011-03-03 00:00:00 | error
24 | 2010-01-26 00:00:00 | 2011-03-01 00:00:00
24 | 2010-01-27 00:00:00 | 2011-03-02 00:00:00
Spreadsheet: nfl_pool_08
Sheet: Team - Wins PUBLIC

 |  |  |  |  | Wins
 |  |  |  |  | Week #
Team |  |  |  | Total Wins | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17
NFC | Arizona CARDINALS |  | ARI | 2 | W | W
 | Carolina PANTHERS |  | CAR | 2 | W | W
 | Dallas COWBOYS |  | DAL | 2 | W | W
 | Green Bay PACKERS |  | GB | 2 | W | W
 | New York GIANTS |  | NYG | 2 | W | W
 | Atlanta FALCONS |  | ATL | 1 | W
 | Chicago BEARS |  | CHI | 1 | W
 | New Orleans SAINTS |  | NO | 1 | W
 | Philadelphia EAGLES |  | PHI | 1 | W
 | San Francisco 49ERS |  | SF | 1 |  | W
 | Tampa Bay BUCCANEERS |  | TB | 1 |  | W
 | [NAME] |  | WAS | 1 |  | W
 | Detriot LIONS |  | DET | 0
 | Minnesota VIKINGS |  | MIN | 0
 | Seattle SEAHAWKS |  | SEA | 0
 | St. Louis RAMS |  | STL | 0
AFC | Buffalo BILLS |  | BUF | 2 | W | W
 | Denver BRONCOS |  | DEN | 2 | W | W
 | New England PATRIOTS |  | NE | 2 | W | W
 | Pittsburgh STEELERS |  | PIT | 2 | W | W
 | Tennessee TITANS |  | TEN | 2 | W | W
 | Baltimore RAVENS |  | BAL | 1 | W
 | Indianapolis COLTS |  | IND | 1 |  | W
 | New York JETS |  | NYJ | 1 | W
 | Oakland RAIDERS |  | OAK | 1 |  | W
 | Cincinnati BENGALS |  | CIN | 0
 | Cleveland BROWNS |  | CLE | 0
 | Houston TEXANS |  | HOU | 0
 | [NAME] |  | JAC | 0
 | Kansas City CHIEFS |  | KC | 0
 | Miami DOLPHINS |  | MAI | 0
 | San Diego CHARGERS |  | SD | 0
Spreadsheet: 141662d1329391488-list-several-unknown-number-data-from-database-within-a-tolerance-value-ef46_list-several-data-within-a-tolerance-value
Sheet: Sheet1

Need help for this! Trying to find the data inside the [NAME] diamter on the database that fall within the tolerance of A16 and C16. I used COUNTIF to show the total tools that are available. But now, I need to display the [NAME] number of those tools. What should I used?? Please help.
It doesn’t matter of the drawing are displayed in a single cell or multiple. The problem is to get the formula discard the previous row number and finding the next one, like a loop or something. And to search the row number base of toleranced value.
- | Nominal diameter needed | +
 | 192.5
Total dwgs in database :
List of dwg number: