tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 151591d1334997075-excel-2007-vlookup-with-option-to-pull-additional-value-if-blank-wip2
Sheet: SKU Transactions

VLResult | Warehouse | Number | Expected Date | Physical Date | Quantity | Currency | Location | Financial Data | Unit Price | Account Number | Reference | Project | Receipt | Issue | In/Out
 | Q1 |  | 2011-11-18 00:00:00 |  | -1 |  |  |  |  | C10001 | Transaction
 | Q1 |  | 2012-04-17 00:00:00 |  | -1 |  |  |  |  | C10002 | Transaction
 |  |  | 2010-01-26 00:00:00 |  | -1 |  |  |  |  | C10003 | Transaction
 | W1 |  | 2011-11-18 00:00:00 |  | 2 |  |  |  |  | C10004 | Transaction
 | W1 |  | 2011-11-19 00:00:00 |  | -1 |  |  |  |  |  | Transaction
 | Q1 |  | 2011-11-20 00:00:00 |  | -1 |  |  |  |  | C10005 | Transaction
 | W1 |  | 2011-11-21 00:00:00 |  | -3 |  |  |  |  | C10006 | Transaction
 | Q1 |  | 2011-11-22 00:00:00 |  | -3 |  |  |  |  | C10007 | Transaction
 |  |  | 2011-11-23 00:00:00 |  | -1 |  |  |  |  | C10008 | Purchase
 |  |  | 2011-11-24 00:00:00 |  | -1 |  |  |  |  | C10009 | Purchase
 |  |  | 2011-11-25 00:00:00 |  | -2 |  |  |  |  | C10010 | Purchase
 |  |  | 2010-01-26 00:00:00 |  | -2 |  |  |  |  |  | Purchase
 |  |  | 2010-01-27 00:00:00 |  | 4 |  |  |  |  | C10000 | Purchase
 |  |  | 2010-01-28 00:00:00 |  | 4 |  |  |  |  | C10001 | [NAME]
 |  |  | 2010-01-29 00:00:00 |  | -2 |  |  |  |  | C10002 | [NAME]
 |  |  | 2010-01-30 00:00:00 |  | -3 |  |  |  |  | C10003 | [NAME]
 |  |  | 2010-01-31 00:00:00 |  | -3 |  |  |  |  | C10004 | [NAME]
 |  |  | 2010-02-01 00:00:00 |  | 4 |  |  |  |  | C10005 | [NAME]
 | Q1 |  | 2012-04-17 00:00:00 |  | 3 |  |  |  |  | C10006 | [NAME]
 | Q1 |  | 2012-04-18 00:00:00 |  | -2 |  |  |  |  | C10007 | [NAME]
 | V1 |  | 2012-04-19 00:00:00 |  | -2 |  |  |  |  | C10008 | Production Line
 | W1 |  | 2012-04-20 00:00:00 |  | -2 |  |  |  |  | C10009 | Production Line
 | V1 |  | 2012-04-21 00:00:00 |  | 4 |  |  |  |  | C10010 | Production Line
 | V1 |  | 2012-04-22 00:00:00 |  | -2 |  |  |  |  | C10011 | Production Line
 | V1 |  | 2012-04-23 00:00:00 |  | -2 |  |  |  |  | C10000 | Production Line
 | V1 |  | 2012-04-24 00:00:00 |  | 4 |  |  |  |  | C10001 | [NAME]
 | N1 |  | 2012-04-25 00:00:00 |  | -2 |  |  |  |  | C10002 | [NAME]
 | N1 |  | 2012-04-26 00:00:00 |  | 4 |  |  |  |  | C10003 | [NAME]
 | N1 |  | 2012-04-27 00:00:00 |  | 3 |  |  |  |  | C10004 | [NAME]
Spreadsheet: 871283d1717670535-help-with-lookup-functions-lookup-2-aligw
Sheet: Sheet1

[NAME]
 | part1 | part2 | part4 | part5 | part6 | part7 | part3
dim3 | 2 | 5 | 3 | 5 | 4 | 8 | 2
dim2 | 2 | 8 | 8 | 5 | 4 | 2 | 9
dim1 | 5 | 6 | 8 | 9 | 6 | 2 | 2
dim4 | 5 | 7 | 6 | 8 | 5 | 1 | 1
DATA2
 | part3 | part7 | part1 | part2 | part5 | part4 | part6
dim4 | 2 | 2 | 5 | 5 | 4 | 8 | 2
dim2 | 5 | 8 | 6 | 7 | 4 | 2 | 7
dim1 | 3 | 8 | 8 | 6 | 6 | 2 | 6
dim3 | 5 | 5 | 9 | 8 | 5 | 1 | 2
[NAME]
 | part1 | part2 | part3 | part4 | part5 | part5 | part6
dim1
dim2
dim3
dim4
Spreadsheet: 772911d1647523749-value-error-when-linked-source-is-closed-in-and-out-trial
Sheet: Sheet1

 |  | QTY
Date Processed | Item Code | PC | KGS
2022-01-01 00:00:00 | BS-67 | 110 | 226.6
2022-01-01 00:00:00 | BS-67 | 140 | 288.4
2022-01-01 00:00:00 | BR-10 | 310 | 21.7
2022-01-01 00:00:00 | TR-46 | 82 | 164
2022-01-01 00:00:00 | SB-150 | 149 | 366.54
2022-01-02 00:00:00 | SB-126 | 46 | 48.3
2022-01-03 00:00:00 | SB-147 | 85 | 22.95
2022-01-04 00:00:00 | [NAME] | 207 | 26.91
2022-01-05 00:00:00 | SB-126 | 29 | 30.45
2022-01-06 00:00:00 | SB-130 | 120 | 79.2
2022-01-07 00:00:00 | SB-130 | 120 | 79.2
2022-01-08 00:00:00 | SB-130 | 120 | 79.2
2022-01-09 00:00:00 | SB-155 | 18 | 64.8
2022-01-10 00:00:00 | BS-36 | 1 | 219.6363636363637
2022-01-11 00:00:00 | SB-130 | 300 | 198
2022-01-12 00:00:00 | SB-130 | 300 | 198
2022-01-13 00:00:00 | [NAME] | 168 | 21.84
2022-01-14 00:00:00 | SB-147 | 28 | 7.56
2022-01-15 00:00:00 | BR-13 | 16 | 8
2022-01-16 00:00:00 | SB-151/152 | 1 | 528.24
2022-01-17 00:00:00 | SB-151/152 | 1 | 528.24
2022-01-18 00:00:00 | BR-14 | 49 | 55.37
2022-01-19 00:00:00 | SB-141/142 | 302 | 132.88
2022-01-20 00:00:00 | BR-1 | 36 | 28.08
2022-01-21 00:00:00 | SB-133/134 | 600 | 54
2022-01-22 00:00:00 | SB-129 | 34 | 20.74
2022-01-23 00:00:00 | TR-44 | 500 | 75
2022-01-24 00:00:00 | SB-123/124 | 511 | 761.39
2022-01-25 00:00:00 | SB-123/124 | 89 | 132.61
2022-01-26 00:00:00 | SB-133/134 | 600 | 54
2022-01-27 00:00:00 | SB-133/134 | 600 | 54
2022-01-28 00:00:00 | SB-133/134 | 600 | 54
2022-01-29 00:00:00 | SB-133/134 | 600 | 54
2022-01-30 00:00:00 | SB-133/134 | 600 | 54
2022-01-31 00:00:00 | SB-133/134 | 600 | 54
2022-01-01 00:00:00 | SB-133/134 | 600 | 54
2022-01-02 00:00:00 | SB-133/134 | 600 | 54
2022-01-03 00:00:00 | SB-133/134 | 600 | 54
2022-01-04 00:00:00 | SB-133/134 | 600 | 54
2022-01-05 00:00:00 | SB-133/134 | 600 | 54
2022-01-06 00:00:00 | SB-133/134 | 600 | 54
2022-01-07 00:00:00 | SB-133/134 | 600 | 54
2022-01-08 00:00:00 | SB-133/134 | 600 | 54
2022-01-09 00:00:00 | SB-133/134 | 600 | 54
2022-01-10 00:00:00 | SB-133/134 | 600 | 54
2022-01-11 00:00:00 | SB-133/134 | 600 | 54
2022-01-12 00:00:00 | SB-133/134 | 600 | 54
2022-01-13 00:00:00 | SB-133/134 | 600 | 54
2022-01-14 00:00:00 | SB-133/134 | 20 | 1.8
2022-01-15 00:00:00 | SB-133/134 | 600 | 54
2022-01-16 00:00:00 | SB-133/134 | 600 | 54
2022-01-17 00:00:00 | SB-133/134 | 600 | 54
2022-01-18 00:00:00 | SB-133/134 | 600 | 54
2022-01-19 00:00:00 | SB-133/134 | 600 | 54
Spreadsheet: 691392d1597675113-rank-by-3-position-rank-by-points
Sheet: rank by max 10 points

Elevi | 800m (sec) | Săritura în lungime (cm) | Săritura în înălțime (cm) |  | min($B$2:$B$31)*10/B2 | C2*10/max($C$2:$C$31) | D2*10/max($D$2:$D$31) |  | average | final rank |  | Elevi | final rank (asc) | 800m (sec) | Săritura în lungime (cm) | Săritura în înălțime (cm)
[NAME] | 2.14 | 253 | 145 |  |  |  |  |  |  |  |  | [NAME] | 1
N.N. | 2.09 | 251 | 140 |  |  |  |  |  |  |  | 2 | N.N. | 2
P.I. | 2.18 | 240 | 145 |  |  |  |  |  |  |  | 3 | P.I. | 3
A.P. | 2.19 | 235 | 140 |  |  |  |  |  |  |  | 5 | C.G. | 4
C.G. | 2.23 | 245 | 140 |  |  |  |  |  |  |  | 4 | A.P. | 5
R.N. | 2.2 | 240 | 135 |  |  |  |  |  |  |  | 8 | A.R. | 6
B.G. | 2.11 | 230 | 130 |  |  |  |  |  |  |  | 11 | A.C. | 7
N.V. | 2.19 | 235 | 135 |  |  |  |  |  |  |  | 9 | R.N. | 8
A.C. | 2.19 | 240 | 135 |  |  |  |  |  |  |  | 7 | N.V. | 9
A.R. | 2.25 | 240 | 140 |  |  |  |  |  |  |  | 6 | S.V. | 10
V.V. | 2.21 | 240 | 130 |  |  |  |  |  |  |  | 12 | B.G. | 11
P.E. | 2.17 | 235 | 125 |  |  |  |  |  |  |  | 15 | V.V. | 12
S.V. | 2.31 | 235 | 140 |  |  |  |  |  |  |  | 10 | P.M. | 13
P.M. | 2.29 | 230 | 140 |  |  |  |  |  |  |  | 13 | [NAME] | 14
[NAME] | 2.3 | 235 | 135 |  |  |  |  |  |  |  | 14 | P.E. | 15
T.C. | 2.2 | 220 | 135 |  |  |  |  |  |  |  | 16 | T.C. | 16
G.M. | 2.3 | 237 | 125 |  |  |  |  |  |  |  | 19 | D.J. | 17
S.I. | 2.27 | 220 | 135 |  |  |  |  |  |  |  | 18 | S.I. | 18
T.E. | 2.2 | 225 | 125 |  |  |  |  |  |  |  | 20 | G.M. | 19
C.J. | 2.21 | 235 | 115 |  |  |  |  |  |  |  | 23 | T.E. | 20
F.G. | 2.25 | 217 | 130 |  |  |  |  |  |  |  | 22 | M.V. | 21
M.V. | 2.29 | 230 | 125 |  |  |  |  |  |  |  | 21 | F.G. | 22
D.J. | 2.27 | 230 | 130 |  |  |  |  |  |  |  | 17 | C.J. | 23
D.E. | 2.31 | 234 | 120 |  |  |  |  |  |  |  | 24 | D.E. | 24
O.G. | 2.35 | 223 | 125 |  |  |  |  |  |  |  | 25 | O.G. | 25
E.I. | 2.37 | 215 | 130 |  |  |  |  |  |  |  | 26 | E.I. | 26
G.N. | 2.41 | 220 | 115 |  |  |  |  |  |  |  | 27 | G.N. | 27
I.D. | 2.35 | 215 | 105 |  |  |  |  |  |  |  | 29 | B.I. | 28
S.D. | 2.47 | 205 | 110 |  |  |  |  |  |  |  | 30 | I.D. | 29
B.I. | 2.29 | 205 | 110 |  |  |  |  |  |  |  | 28 | S.D. | 30
Spreadsheet: louise_kitchen__22672__2002 Plan Worksheet Texas Orig
Sheet: Assumptions (2)

BENEFITS
 | 4800 |  | Annual flex dollars per US employee
 | 0.0375 |  | Cash Balance & SERP
 | 0.0125 |  | FAS 106
 | 0.03 |  | Savings Plan
 | 0.011 |  | Other
 |  |  | percent of annualized payroll for non-regulated companies
PAYROLL TAXES
 | 84500 |  | Annual FICA base earnings level
 | 0.062 |  | Tax rate for budgeted base salaries less than annual FICA base earnings level
 | 0.0145 |  | Tax rate for Medicare
Analyst & Associate - Billed at a flat rate.
 | 8700 |  | Third Year Analyst cost per month.(per headcount)
 | 7800 |  | Analyst cost per month.(per headcount)
 | 3900 |  | Summer Analyst cost per month.(per headcount)
 | 2400 |  | Tax Analyst cost per month.(per headcount)
 | 12000 |  | Associate cost per month.(per headcount)
 | 6900 |  | Summer Associate cost per month.(per headcount)
COMPENSATION
 | 0.0425 |  | Merit increase rate
Spreadsheet: 35236d1232770602-percentage-question-qc-sheet-master
Sheet: Monday

 |  |  |  |  |  |  |  | Monday
 | Technician |  |  |  |  | Jobs Routed | [NAME] | Jobs Not Completed | Jobs taken to QC | Total QC Completed | Pass | Fail | QC Failure %
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | Totals
Spreadsheet: 173472d1344566824-conditional-formatting-highlight-entire-row-using-input-cell-test
Sheet: Data

Type serach below Search
Item | Colour | Type | Description | Sheen | Litres | Bay
Interior | Sable Brush | Enamel | Ultraproof | [NAME] | 1 | 2
Interior | 1/4 akaroa |  | Ultraproof | Low Sheen | 4 | 2
Interior | Apache | Enamel | [NAME] |  | 1.5 | 2
Interior | Supernova | Enamel | Spacecoat | Low Sheen | 4 | 2
Interior | Midnight Express | Enamel | Spacecoat | Low Sheen | 1.5 | 2
Interior | Triple spanish white | Enamel | Ultraproof | [NAME] |  | 2
Interior | Cantabury Clay | Enamel | Spacecoat | Low Sheen | 0.5 | 2
Interior | Kabul | Enamel | [NAME] |  | 1 | 2
 | 1
Spreadsheet: 787218d1657696103-arrange-the-rows-values-into-columns-service-utilization
Sheet: Sheet2

Name | Appointments
Spreadsheet: 890087d1741267801-forecasting-formula-excel-forum-example
Sheet: Sheet1

 |  |  |  |  |  | 2025-01-06 00:00:00 | 2025-01-13 00:00:00 | 2025-01-20 00:00:00 | 2025-01-27 00:00:00 | 2025-02-03 00:00:00 | 2025-02-10 00:00:00 | 2025-02-17 00:00:00 | 2025-02-24 00:00:00 | 2025-03-03 00:00:00
 | Start Date | Finish Date | Hours Available | Duration In Weeks
 | 2025-01-10 00:00:00 | 2025-02-14 00:00:00 | 60 | 5
 | 2025-01-10 00:00:00 | 2025-02-17 00:00:00 | 60 | 5
Spreadsheet: 453772d1459439377-can-i-use-vlookup-to-do-this-copy-of-sample-file-1
Sheet: Result

ID | Company | Quarter | Amount |  |  |  |  | Quarter | Amount
1 | Google | 1 | 1000
1 | Google | 2 | 2000
1 | Google | 3 | 3000
1 | Google | 4 | 4000
2 | Yahoo | 1 | 1000
2 | Yahoo | 2 | 2000
2 | Yahoo | 3 | 3000
2 | Yahoo | 4 | 4000
3 | AOL | 1 | 1000
3 | AOL | 2 | 2000
3 | AOL | 3 | 3000
3 | AOL | 4 | 4000
4 | Microsoft | 1 | 1000
4 | Microsoft | 2 | 2000
4 | Microsoft | 3 | 3000
4 | Microsoft | 4 | 4000
5 | Sony | 1 | 1000
5 | Sony | 2 | 2000
5 | Sony | 3 | 3000
5 | Sony | 4 | 4000
Spreadsheet: 837017d1689786973-sumif-look-up-test
Sheet: Date

Employee # | 2023-07-16 00:00:00 | 2023-07-17 00:00:00 | 2023-07-18 00:00:00 | 2023-07-19 00:00:00 | 2023-07-20 00:00:00 | 2023-07-21 00:00:00 | 2023-07-22 00:00:00 | 2023-07-23 00:00:00 | 2023-07-24 00:00:00 | 2023-07-25 00:00:00 | 2023-07-26 00:00:00 | 2023-07-27 00:00:00 | 2023-07-28 00:00:00 | 2023-07-29 00:00:00 | 2023-07-30 00:00:00 | 2023-07-31 00:00:00
2106 |  |  | 8.06 |  | 4 | 8 |  |  | 8
2007 |  |  | 9.23
1804 |  | 10 | 11.61
1517
Spreadsheet: 726863d1617551845-copy-data-from-one-workbook-to-another-as-value-ef-workbook-b
Sheet: Sheet1

 |  |  |  |  | Product Name | xxxxx | xxxxx | Units | Value | xxxxx | xxxxx | xxxxx |  |  |  | NORTH | SOUTH | EAST | WEST
 |  |  |  |  | 1
 |  |  |  |  | 2
 |  |  |  |  | 3
 |  |  |  |  | 4
 |  |  |  |  | 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
 |  |  |  |  | 32
 |  |  |  |  | 33
 |  |  |  |  | 34
 |  |  |  |  | 35
 |  |  |  |  | Product Name | xxxxx | xxxxx | Units | Value | xxxxx | xxxxx | xxxxx |  |  |  | NORTH | SOUTH | EAST | WEST
 |  |  |  |  | 1
 |  |  |  |  | 2
 |  |  |  |  | 3
 |  |  |  |  | 4
 |  |  |  |  | 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
 |  |  |  |  | 32
 |  |  |  |  | 33
 |  |  |  |  | 34
 |  |  |  |  | 35
Spreadsheet: 456354d1460768566-for-excel-to-automatically-add-in-a-line-if-customer-places-bigger-order-jontopley2
Sheet: Sheet2

COFFEE | BASE | BASE SINK | WALL | LAZY SUSAN | PANTRY | CROWNS
 | B09 | SB30 | W09 | LAZY1 | PC18 | TOP
 | B12 | SB33 | W12 | LAZY2 | PC24 | BOTTOM
 | B15 | SB36 | W15
 | B18 |  | W18
 | B24 |  | W24
 | B30 |  | W30
 | B33 |  | W33
 | B36 |  | W36
WHITE | BASE | BASE SINK | WALL | LAZY SUSAN | PANTRY | CROWNS
 | B09 | SB30 | W09 | LAZY1 | PC18 | TOP
 | B12 | SB33 | W12 | LAZY2 | PC24 | BOTTOM
 | B15 | SB36 | W15
 | B18 |  | W18
 | B24 |  | W24
 | B30 |  | W30
 | B33 |  | W33
 | B36 |  | W36
HONEY | BASE | BASE SINK | WALL | LAZY SUSAN | PANTRY | CROWNS
 | B09 | SB30 | W09 | LAZY1 | PC18 | TOP
 | B12 | SB33 | W12 | LAZY2 | PC24 | BOTTOM
 | B15 | SB36 | W15
 | B18 |  | W18
 | B24 |  | W24
 | B30 |  | W30
 | B33 |  | W33
 | B36 |  | W36
Spreadsheet: 0b405207-99c7-4a3a-bc47-07e0b78c73c5
Sheet: 7d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Fixed-Float | 211000000 | 90440002 | 19048674 | 45210801
FRA | 90124298 | 8019527 | 8378375 | 3944608
OIS | 46902755 | 10001802 | 6485940 | 3972553
OTHER* | 10137933 | 64587218 | 1106436 | 20772240
TOTAL
*OTHER variable includes the following products: Basis, Swaption, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, and Inflation.
Spreadsheet: d9999c85-cb72-4c8e-99ba-502549205a18
Sheet: Sheet1

[NAME] AND SUBSIDIARIES | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
(condensed consolidated financial statements -
dollars in millions, except per share data)
Statement of Earnings
 |  |  | Three Months ended |  |  |  |  |  | Six Months ended
 |  |  | June 30 |  |  |  |  |  | June 30
 |  |  | 2004 |  |  | 2003 |  |  | 2004 |  |  | 2003
Electrical Products |  | $ | 227.7 |  | $ | 227.6 |  | $ | 451.3 |  | $ | 440.7
Water Systems |  |  | 209.6 |  |  | 190 |  |  | 402.5 |  |  | 364.8
Net sales |  |  | 437.3 |  |  | 417.6 |  |  | 853.8 |  |  | 805.5
Cost of products sold |  |  | 348.9 |  |  | 333.8 |  |  | 687.2 |  |  | 643.5
Gross profit |  |  | 88.4 |  |  | 83.8 |  |  | 166.6 |  |  | 162
Selling, general and administrative |  |  | 58.9 |  |  | 51.7 |  |  | 117.6 |  |  | 105.7
Interest expense |  |  | 3.2 |  |  | 3 |  |  | 6.4 |  |  | 5.9
Other (income) / expense |  |  | 0.3 |  |  | -0.1 |  |  | 0.5 |  |  | 0.3
 |  |  | 26 |  |  | 29.2 |  |  | 42.09999999999991 |  |  | 50.1
Tax provision |  |  | 8.7 |  |  | 9.4 |  |  | 14.1 |  |  | 16.6
Net Earnings |  | $ | 17.3 |  | $ | 19.8 |  | $ | 27.99999999999991 |  | $ | 33.5
Net Earnings Per Share of Common Stock (Diluted) |  | $ | 0.578337116315528 |  | $ | 0.6676623152843082 |  | $ | 0.9360464953015115 |  | $ | 1.132165330745372
 | Average Common Shares Outstanding  (000's omitted) |  | 29913.349 |  |  | 29655.71 |  |  | 29913.044 |  |  | 29589.318
Spreadsheet: 62651d1263558114-vlookup-with-mutliple-criteria-customer
Sheet: Sheet1

Custmer code | Product code | Available contract | Required Contract
1 | 1 | this the value to be picked from pending contracts file on the basis of customer code and product code | Picked by vlookup from 3rd sheet
2 | 2
3 | 3
4 | 4
5 | 5
6 | 6
7 | 7
8 | 8
9 | 9
10 | 10
11 | 11
Spreadsheet: 11ecf49a-3032-4086-b7c1-8cd6f135e10c
Sheet: NICC - West Dubuque Auto&Diesel

North East Iowa Community College
2012-2013 West Dubuque Auto & Diesel Consortium
Cascade, West Dubuque
Course Number | Course Title | Schedule |  | College Credit Hours | Contact Minutes | SCED Code           Replace 'uu' with sequencing | Comments
Auto  (13.5 credits)
2012 Fall Semester
AU110 | Auto Shop Practices | M-Thr 1:40-3:30pm | 8-22-12/ 9-5-12 | 0.5 | 960 | 20106C013uu
AUT503 | Auto Brakes | M-Thr 1:40-3:30pm | 9-6-12/12-14-12 | 3 | 5830 | 20105C081uu
COM723 | Workplace Communication | F 1:40-3:15 Hybrid | 8-22-12/12-14-12 | 3 | 2880 | 12009C040uu | Class is hybrid, 1520 face to face and 1360 online minutes = 2880.
2013 Spring Semester
AUT404 | Suspension & Steering | M-Thr 1:40-3:30pm | 1-14-13/5-10-13 | 4 | 6820 | 20105C095uu
BCA212 | [NAME] to Comp Bus Apps | F 1:40-3:15 Hybrid | 2-25-13/5-15-13 | 3 | 4800 | 10005C067uu | Class is hybrid, 1650 face to face and 3150 online
 |  |  | Program Total:
Diesel (14 credits)
2012 Fall Semester
DSL632 | Diesel Brakes | M-Thr 1:30-3:30pm | 8-22-12/ 10-17-12 | 2 | 3840 | 20108C053uu
[NAME] | Auto Transmission | M-Thr 1:30-3:30pm | 10-18-12/12-14-12 | 2 | 3480 | 20105C048uu
COM723 | Workplace Communication | F 1:40-3:15 Hybrid | 8-22-12/12-14-12 | 3 | 2880 | 12009C040uu | Class is hybrid, 1520 face to face and 1360 online minutes = 2880.
2013 Spring Semester
DSL353 | Diesel Engine Principles | M-Thr 1:40-3:30pm | 1-14-13/5-10-13 | 4 | 6820 | 20107C095uu
BCA212 | [NAME] to Comp Bus Apps | F 1:40-3:15 Hybrid | 2-25-13/5-15-13 | 3 | 4800 | 10005C067uu | Class is hybrid, 1650 face to face and 3150 online
 |  |  | Program Total:
Spreadsheet: 81481d1281637287-sum-values-from-a-certain-date-onwards-test
Sheet: Sheet3

 | SALES
 | 2010-04-01 00:00:00 | 2010-04-02 00:00:00 | 2010-04-03 00:00:00 | 2010-04-04 00:00:00 | 2010-04-05 00:00:00 | 2010-04-06 00:00:00 | 2010-04-07 00:00:00 | 2010-04-08 00:00:00 | 2010-04-09 00:00:00 | 2010-04-10 00:00:00 | 2010-04-11 00:00:00 | 2010-04-12 00:00:00 | 2010-04-13 00:00:00 | 2010-04-14 00:00:00 | 2010-04-15 00:00:00 | 2010-04-16 00:00:00 | 2010-04-17 00:00:00 | 2010-04-18 00:00:00 | 2010-04-19 00:00:00 | 2010-04-20 00:00:00 | 2010-04-21 00:00:00 | 2010-04-22 00:00:00 | 2010-04-23 00:00:00 | 2010-04-24 00:00:00 | 2010-04-25 00:00:00 | 2010-04-26 00:00:00 | 2010-04-27 00:00:00 | 2010-04-28 00:00:00 | 2010-04-29 00:00:00 | 2010-04-30 00:00:00 | [NAME] on Date | Promo Qty | Unit Sold after Promo
C055816 | 2 | 0 | 3 | 1 | 23 | 200 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 7 | 0 | 0 | 0 | 7 | 6 | 0 | 3 | 4 | 5 | 2 | 0 | 7 | 0 |  | 200
B055821 | 2 | 200 | 0 | 0 | 4 | 0 | 2 | 0 | 0 | 3 | 7 | 6 | 0 | 0 | 0 | 0 | 0 | 7 | 0 | 8 | 0 | 2 | 5 | 0 | 0 | 0 | 8 | 0 | 7 | 0
B558260 | 2 | 2 | 0 | 4 | 0 | 56 | 0 | 2 | 0 | 300 | 0 | 7 | 6 | 0 | 6 | 0 | 7 | 0 | 6 | 2 | 0 | 0 | 0 | 5 | 6 | 0 | 7 | 8 | 7 | 0 |  | 300
A005831 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 6 | 0 | 67 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 2 | 0 | 100 | 7 | 0 | 0 | 7 | 8 | 7 | 9 |  | 100
B105584 | 0 | 2 | 0 | 0 | 5 | 4 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 8 | 300 | 0 | 0 | 0 | 2 | 3 | 0 | 8 | 0 | 0 | 8 | 7 | 0 |  | 300
Spreadsheet: michelle_lokay__26806__sharris0800wk3
Sheet: Actuals V. Plan

Transwestern Pipeline Company
($[NAME])
 |  |  |  |  |  | 2000-08-17 16:41:45.570000
 |  | August, 2000
 |  | Plan | Estmate | [NAME] |  | Comments
West Demand Revenues |  | 9.8464 | 10.15766454 | 0.311264539999998 |  | Prices in excess of $0.12/mmbtu on 63/day.
West Commodity Revenues |  | 0.7731999999999999 | 0.8114932207 | 0.03829322070000007 |  | Higher volumes than in plan.
East Demand Revenues |  | 1.1254 | 0.9970535704 | -0.1283464296000002 |  | Burlington 24216--($53k), [NAME])
East Commodity Revenues |  | 0.1709 | 0.196034578804 | 0.025134578804 |  | Higher east volumes
[NAME] |  | 0.6644000000000001 | 0.65624675 | -0.008153250000000112
[NAME] Revenues |  | 0.05890000000000001 | 0.1874834944 | 0.1285834944 |  | higher IT volumes than in plan
 |  | ------------- | ------------- | -------------
Revenue Variance |  | 12.6382 | 13.005976154304 | 0.3677761543039963
[NAME] due to Price |  |  |  | 0.6461148927856243 |  | Current index price of $3.85
[NAME] due to net fuel retention. |  |  |  | -0.09865046147810108 |  | higher fuel use than in plan
Hedging Adjustment |  |  |  | 0.03720000000000005
Unaccounted for Variance |  |  |  | -0.134
 |  |  |  | -------------
Fuel Variance |  |  |  | 0.4506644313075232
 |  |  |  | -------------
TOTAL MONTH-TO-DATE VARIANCE |  |  |  | 0.8184405856115196
 |  |  |  | ========
[NAME]
 |  | Year-to-Date | Year-to-Date | Year-to-Date
 |  | Margin | Fuel & UAF | Total
Plan (through August) |  | 97.41619999999999 | 11.7072 | 109.1234
Actuals through June and July est. |  | 97.74287615430399 | 14.3025 | 112.045376154304
 |  | ------------- | ------------- | -------------
Variance from Plan |  | 0.3266761543039962 | 2.595299999999998 | 2.921976154303994
 |  | ------------- | ------------- | -------------
Spreadsheet: darrell_schoolcraft__7413__TW Jan02pnr
Sheet: Virginia Pw 500623

 | [NAME]
 | INVOICE DETAIL - JANUARY 2002
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Maximum Inventory Calculation
DAY | NAME | CONTRACT NUMBER | MONTH | POI # | type_poi | SCHEDULED INJECTION | SCHEDULED WITHDRAWAL | NET SCHEDULED QTY | Carryover GIP | NET GIP | DAILY INJECTION   PRICE                (Inj + MIC) | DAILY WITHDRAWAL  PRICE               (Wd + MIC) | INJECTION AMOUNT       (Inj + MIC) | WITHDRAWAL  AMOUNT          (Wd + MIC) | Positive Inventory | Negative Inventory | Positive Inventory Components | Negative Inventory Components
 | Virginia Power | 27719 | 2002-01-01 00:00:00 | 500623 | PnR |  |  |  | -4793
1 |  |  |  | Panhandle Pool |  |  |  |  |  |  | 0.1 | 0.08
2 | $0.08 Rate agreed to by Reyna |  |  |  |  |  |  |  |  |  | 0.1 | 0.08
3 | See December |  |  |  |  |  |  |  |  |  | 0.1 | 0.08
4 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.08
5 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.08
6 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.08
7 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.08
8 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.08
9 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.08
10 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.08
11 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.08
12 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.08
13 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.08
14 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.08
15 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.08
16 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.08
17 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.08
18 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.08
19 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.08
20 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.08
21 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.08
22 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.08
23 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.08
24 |  |  |  |  |  | 3997 |  |  |  |  | 0.1 | 0.08
25 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.08
26 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.08
27 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.08
28 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.08
29 |  |  |  |  |  | 796 |  |  |  |  | 0.1 | 0.08
30 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.08
31 |  |  |  |  |  |  |  |  |  |  | 0.1 | 0.08
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Absolute [NAME]
 |  |  |  | Total Injection |  |  |  |  |  |  |  | Total Invoice Amount
 |  |  |  | Total W/D