tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: benjamin_rogers__1049__Consolidated 6 Peaker-051800-PE
Sheet: Brownsville

INCOME STATEMENT - BROWNSVILLE
('000 $) | 2001
Revenue
Fixed Price Period: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Demand Payment
Energy Payment
Start Charge
Amortization of Power Contract
Merchant Period:
Demand Payment | 0 | 0 | 0
Variable Revenue | 0 | 0 | 0
Interest Income
Total Revenue
Expense
Fixed O&M
Variable O&M
Major [NAME]
O&M Management Fee
Owner's Expense
Property Taxes Liability | 325 | 375 | 375 | 375 | 375 | 375 | 375 | 375 | 375 | 375 | 375 | 375 | 375 | 375 | 427.6483011796236 | 436.201267203216 | 444.9252925472804 | 453.823798398226 | 462.9002743661905
Franchise Tax
Total Expense
EBITDA
Depreciation & Amortization
EBIT
Interest Expense
EBT
Book State Tax Benefit / (Expense)
Shareholder Fed. Tax Benefit / (Expense)
After Tax Book Income
CASH FLOW - BROWNSVILLE
('000 $) | 2001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Check
EBITDA less Amortization of Power Contract
Plus Property Tax Liability
Less Property Tax Expense | -250
Debt Service
Pre Tax Cash Flow
State Cash Taxes Benefit (Expense)
Federal Cash Taxes Benefit (Expense)
After Tax Cash Flow
STATE TAX & FRANCHISE TAX - BROWNSVILLE
 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22
('000 $) | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020
FRANCHISE TAX
Book Value of Assets
Paid-In-Capital
[NAME] (less Amortization of Power Contract)
Outstanding Debt
Total Capitalization
Greater of Book Value or Capitalization
State Franchise Tax Rate
State Franchise Tax Liability | 448.5278257099937 | 434.6558311004063 | 420.7838364908189 | 406.9118418812315 | 393.039847271644 | 379.1678526620566 | 365.2958580524692 | 351.4238634428818 | 337.5518688332943 | 323.6798742237069 | 309.8078796141195 | 295.9358850045321 | 282.0638903949447 | 268.1918957853572 | 254.3199011757698 | 240.4479065661824 | 226.575911956595 | 212.7039173470076 | 198.8319227374202 | 184.9599281278328
STATE TAXES
Pretax Book Income less Amortization of Power Contract
Plus Book Depreciation & Amortization
Less Tax Depreciation
State Taxable Income
State Income Tax Rate
Current State Income Tax Expense (Benefit)
Beginning NOL's | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
New NOL's
Expired NOL's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NOL Utilization
Ending NOL's
Total State Taxes Utilizing NOLs
Spreadsheet: 552238d1513376841-sumif-for-a-specific-item-code-edit-power-query
Sheet: Sheet1

Posted Dt. | Memo / Description | TO Number | Customer Name | Item | Department | Department | Customer | Business Segment | Project | Internal Client ID | Customer Location | Sub Location | Country | Debit (USD) | Credit (USD)
4424-9999 - Revenue-Null (Balance Forward As of 11/01/2017)
2017-11-27 00:00:00 | Invoice - Iowa, University of: 300dpi, RADJW2 - TO605 | TO605 | Iowa, University of | PPRI0008 | 0 | 0 | 14 | 0 |  | 14 | 0 | 22 | 0 |  | 7568
2017-11-27 00:00:00 | Invoice - Iowa, University of: TO605 | TO605 | Iowa, University of | PCAB0010 | 0 | 0 | 14 | 0 |  | 14 | 0 | 22 | 0 |  | 52
2017-11-27 00:00:00 | Invoice - Whole Food Markets, Inc.: TO606 | TO606 | Whole Food Markets, Inc. | PPRI0009 | 0 | 0 | 244 | 0 |  | 244 | 0 | 22 | 0 |  | 1688
2017-11-27 00:00:00 | Invoice - Arizona, University of: TO607 | TO607 | Arizona, University of | PACC0194 | 0 | 0 | 44 | 0 |  | 44 | 0 | 22 | 0 |  | 620
2017-11-27 00:00:00 | Invoice - Alabama, University of: TO608 | TO608 | Alabama, University of | PACC0157 | 0 | 0 | 78 | 0 |  | 78 | 0 | 22 | 0 |  | 1700
2017-11-27 00:00:00 | Invoice - Alabama, University of: TO608 | TO608 | Alabama, University of | DISC | 0 | 0 | 78 | 0 |  | 78 | 0 | 22 | 0 | 1700
3647-5874 - Fees (Balance Forward As of 11/01/2017) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
2017-11-20 00:00:00 | Invoice - Memphis, University of | FS-20-006 | Memphis, University of | C_Fees | 0 | 0 | 20 | 0 |  | 20 | 0 | 22 | 0 |  | 6000
2017-11-20 00:00:00 | Invoice - Michigan State University | FS-86-013 | Michigan State University | C_Fees | 0 | 0 | 86 | 0 |  | 86 | 0 | 22 | 0 |  | 3000
2017-11-20 00:00:00 | Invoice - Metrotix | FS-467-001 | [NAME] | C_Fees | 0 | 0 | 467 | 0 |  | 467 | 0 | 22 | 0 |  | 5000
2017-11-20 00:00:00 | Invoice - Colorado State University | FS-103-006 | Colorado State University | C_Fees | 0 | 0 | 103 | 0 |  | 103 | 0 | 22 | 0 |  | 1600
2017-11-20 00:00:00 | Invoice - Colorado State University | FS-103-006 | Colorado State University | C_Fees | 0 | 0 | 103 | 0 |  | 103 | 0 | 22 | 0 | 1000
5746-0000 - Software
2017-11-30 00:00:00 | Cust 100 baseball | 100-19-844-ST | Ole Miss Athletics Foundation |  | 0 | 0 | 100 | 0 |  | 100 | 0 | 22 | 0 |  | 14564.05
2017-11-30 00:00:00 | Pittsburgh, University of Software | 132-04 ST | Pittsburgh, University of |  | 0 | 0 | 132 | 0 |  | 132 | 0 | 22 | 0 | 1000 | 1026
2017-11-30 00:00:00 | [NAME] | 143-11 ST | Virginia Polytechnic Institute |  | 0 | 0 | 143 | 0 |  | 143 | 0 | 22 | 0 |  | 8735
2017-11-30 00:00:00 | Georgia Tech | 25-07 ST | Cincinnati Arts Association |  | 0 | 0 | 397 | 0 |  | 397 | 0 | 22 | 0 |  | 7876
Spreadsheet: 850883d1701194584-need-to-have-7-different-formulas-in-the-same-cell-all-with-different-outcomes-problem
Sheet: Sheet1

ID | Ordered By | Code | Added Cost | Weight | [NAME] | Aisle | Row | Price/lb | Income From Sale | Cost 1 | Total Cost | Total
2 | [NAME] | K.5 |  | 341 | [NAME] | 1 | 4 |  |  |  | 1099.39
3 | [NAME] | K1 |  | 341 | [NAME] | 2 | 7 |  |  |  | 2198.78
5 | [NAME] | K.5 | 1 | 777 | [NAME] | 1 | 12 |  |  | 807.22 | 1906.61
6 | Dwayne | K1 | 1 | 409 | [NAME] | 2 | 38 |  |  | 336.52 | 2535.3
7 | Adam | S.5 | 1 | 409 | [NAME] | 1 | 55 |  |  | 336.52 | 1435.91
44 | [NAME] | S1 | 1 | 801 | [NAME] | 1 | 10 |  |  | 825.23 | 3024.1
 |  |  |  |  |  | Cost of unit | 2198.775890077821 | Selling Price | 5.5
I need a formula that will have 7 options and 7 different outcomes. I need to have in [NAME] (L3) a formula that will look at column (C) and match the Code and Added Cost and give me a value. So if (C3) shows "K.5" and (D3) shows Blank then it will calculate (H14)/2. Or if (C3) shows "K1" and (D3) Shows Blank then it will return (H14). Or if (C3) shows "K.5" and (D3) shows 1 then it will calculate (H14)/2+(K3). Or if (C3) shows "K1" and (D3) shows 1 then it will calculate (H14)+(K3). Or if (C3) shows "S.5" and (D3) shows 1 it will calculate (H14)/2+(K3). Or if (C3) shows "S1" and (D3) shows 1 then it will calculate (H14)+(K3). And to top it all off if (A3) is Blank then leave (L3) Blank
Spreadsheet: 786031d1656942068-excel-function-use-to-extract-between-range-data-without-array-formula-04072022-sample-file-for-excel-forum
Sheet: Sheet1

Bth | Bthno | From no. | To No. |  |  | RESULT
GK | 1 | 1 | 1000 |  |  | Nos. | Bth | [NAME]
 | 2 |  |  |  |  | 15712
 | 3 |  |  |  |  | 1
 | 4 |  |  |  |  | 8901
 | 5 |  |  |  |  | 7484
 | 6 |  |  |  |  | 23948
 | 7 |  |  |  |  | 21910
 | 8 |  |  |  |  | 13213
 | 9 |  |  |  |  | 13212
 | 10
 | 11
 | 12
 | 13 |  | 13212
JG | 1 | 13213 | 14212
 | 2
 | 3
 | 4
 | 5
 | 6 |  | 19525
BY | 1 | 19526 | 20582
BR | 1 | 20583 | 21910
BH | 1 | 21911 | 22910
 | 2
 | 3
 | 4
 | 5 |  | 27472
GT | 1 | 27473 | 28472
 | 2 |  | 29487
TH | 1 | 29488 | 30487
 | 2 |  | 31445
VS | 1 | 31446 | 32445
 | 2
 | 3
 | 4
 | 5 |  | 36599
PNV | 1 | 36600 | 37305
PN | 1 | 37306 | 37617
PCN | 1 | 37618 | 38617
 | 2 |  | 39960
WA | 1 | 39961 | 41498
MD | 1 | 41499 | 42498
 | 2
 | 3 |  | 44425
ST | 1 | 44426 | 45337
SH | 1 | 45338 | 45592
KD | 1 | 45593 | 46676
Spreadsheet: 11a54233-509f-4969-a760-3c92566810bc
Sheet: Sheet1

Rochester Season Schedule | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Date | Game Number | Visiting Team | Visiting Score | Home Team | Home Score | Game Time/Status | Venue
2014-04-25 | 1 | Chicago | 4 | Rochester | 3 | Final OT | Blue Cross [NAME], NY
2014-04-26 | 2 | Chicago | 2 | Rochester | 3 | Final | Blue Cross [NAME], NY
2014-05-01 | 3 | Rochester | 0 | Chicago | 4 | Final | Allstate [NAME], IL
2014-05-02 | 4 | Rochester | 7 | Chicago | 2 | Final | Allstate [NAME], IL
2014-05-04 | 5 | Rochester | 2 | Chicago | 4 | Final | Allstate [NAME], IL
Spreadsheet: 143899d1330620807-grabbing-data-from-multiple-pages-and-having-it-on-one-total-excel-tab-goldriskslide
Sheet: PL

P&L matrix of portfolio 'GOLD'
calculated 09:34 01 Mar 2012
GC
GC Apr Future:1721.40
p&l in USD
v \ p | p:-40% | p:-10% | p:-3% | p:-1% | p:+0% | p:+1% | [NAME] | p:+10% | p:+40%
v:-40pts | 3305088 | 826272 | 247882 | 82627 | 0 | -82627 | -247882 | -826272 | -3305088
v:-10pts | 3305088 | 826272 | 247882 | 82627 | 0 | -82627 | -247882 | -826272 | -3305088
v:-3pts | 3305088 | 826272 | 247882 | 82627 | 0 | -82627 | -247882 | -826272 | -3305088
v:-1pts | 3305088 | 826272 | 247882 | 82627 | 0 | -82627 | -247882 | -826272 | -3305088
v:+0pts | 3305088 | 826272 | 247882 | 82627 | 0 | -82627 | -247882 | -826272 | -3305088
v:+1pts | 3305088 | 826272 | 247882 | 82627 | 0 | -82627 | -247882 | -826272 | -3305088
v:+3pts | 3305088 | 826272 | 247882 | 82627 | 0 | -82627 | -247882 | -826272 | -3305088
v:+10pts | 3305088 | 826272 | 247882 | 82627 | 0 | -82627 | -247882 | -826272 | -3305088
v:+40pts | 3305088 | 826272 | 247882 | 82627 | 0 | -82627 | -247882 | -826272 | -3305088
GLD
GLD Spot:167.17
p&l in USD
v \ p | p:-40% | p:-10% | p:-3% | p:-1% | p:+0% | p:+1% | [NAME] | p:+10% | p:+40%
v:-40pts | -4287652 | -1104847 | -175093 | -6694 | 105161 | 233726 | 269960 | -348397 | -8209217
v:-10pts | -4287652 | -1092271 | -192947 | 4908 | 96610 | 170348 | 224835 | -402826 | -8209258
v:-3pts | -4287652 | -1063143 | -214673 | -34630 | 35839 | 88404 | 128247 | -526010 | -8210065
v:-1pts | -4287652 | -1054924 | -224803 | -52944 | 12556 | 60480 | 93311 | -567591 | -8210725
v:+0pts | -4287652 | -1051059 | -230730 | -63063 | 0 | 45642 | 74820 | -589127 | -8211229
v:+1pts | -4287652 | -1047399 | -237166 | -73861 | -13159 | 30217 | 55652 | -611123 | -8211827
v:+3pts | -4287652 | -1040856 | -251770 | -97253 | -41234 | -2271 | 15604 | -656294 | -8213392
v:+10pts | -4287268 | -1028193 | -320266 | -196630 | -155930 | -131601 | -138697 | -824448 | -8223284
v:+40pts | -4251791 | -1202693 | -835280 | -810683 | -815412 | -832546 | -908149 | -1625641 | -8391839
OG
GC Apr Future:1721.35, GC Jun Future:1724.10
p&l in USD
v \ p | p:-40% | p:-10% | p:-3% | p:-1% | p:+0% | p:+1% | [NAME] | p:+10% | p:+40%
v:-40pts | 999949 | -50130 | 108041 | -216036 | -405598 | -426790 | -243330 | 1296712 | 11128619
v:-10pts | 999949 | -16317 | 28099 | -166913 | -237314 | -258509 | -134303 | 1313535 | 11128260
v:-3pts | 999987 | 23160 | -11475 | -67201 | -71466 | -49459 | 89149 | 1428677 | 11125928
v:-1pts | 999747 | 28450 | -5083 | -32817 | -24005 | 8156 | 156123 | 1475905 | 11125798
v:+0pts | 999567 | 30859 | 744 | -14520 | 136 | 36930 | 189714 | 1501283 | 11125922
v:+1pts | 999359 | 33302 | 8179 | 4517 | 24612 | 65762 | 223350 | 1527644 | 11126225
v:+3pts | 998741 | 38864 | 27556 | 44723 | 74608 | 123802 | 290715 | 1582936 | 11127495
v:+10pts | 993938 | 73239 | 133636 | 205997 | 261804 | 332939 | 528214 | 1796266 | 11141019
v:+40pts | 948781 | 541843 | 920489 | 1102155 | 1207647 | 1322530 | 1581621 | 2839990 | 11431436
Spreadsheet: 206329d1358161850-comparing-two-work-sheets-test
Sheet: Utilization

Sr.Nos | ASSET LIST | ACTIVITY DATE | Q1 | Q2 | Q3 | Q4
1 | 201 |  |  | STDBY | STDBY
2 | 202 |  |  | STDBY | STDBY
3 | 203 |  |  | Rig58 | Rig58 | Rig58
4 | 204 |  |  | Rig04 | Rig04
5 | 205 |  |  | Rig04 | Rig04
6 | 206 |  |  | Rig58 | Rig58 | Rig58
7 | 207 |  |  | Rig04 | Rig04
8 | 208 |  |  | Rig58 | Rig58 | Rig58
9 | 209 |  |  | STDBY | STDBY
10 | 210 |  |  | Rig58 | Rig58 | Rig58
11 | 211 |  |  | Rig04 | Rig04
12 | 212 |  |  | STDBY | STDBY
13 | 213 |  |  | Rig58 | Rig58 | Rig58
14 | 214 |  |  | Rig58 | Rig58 | Rig58
15 | 215 |  |  | Rig04 | Rig04
16 | 216 |  |  | Rig58 | Rig58 | Rig58
17 | 217 |  |  | Rig58 | Rig58 | Rig58
18 | 218 |  |  | Rig58 | Rig58 | Rig58
19 | 219 |  |  | Rig04 | Rig04
20 | 220 |  |  | Rig58 | Rig58 | Rig58
21 | 221 |  |  | Rig58 | Rig58 | Rig58
22 | 222 |  |  | Rig58 | Rig58 | Rig58
23 | 223 |  |  | Rig04 | Rig04
24 | 224 |  |  | Rig04 | Rig04
25 | 225 |  |  | Rig58 | Rig58 | Rig58
26 | 226 |  |  | Rig04 | Rig04
27 | 227 |  |  | Rig58 | Rig58 | Rig58
28 | 228 |  |  | Rig04 | Rig04
29 | 229 |  |  | Rig04 | Rig04
30 | 230 |  |  | Rig58 | Rig58 | Rig58
31 | 231 |  |  | Rig58 | Rig58 | Rig58
32 | 232 |  |  | Rig58 | Rig58 | Rig58
33 | 233 |  |  | Rig04 | Rig04
34 | 234 |  |  | Rig04 | Rig04
35 | 235 |  |  | Rig58 | Rig58 | Rig58
36 | 236 |  |  | Rig58 | Rig58 | Rig58
37 | 237 |  |  | Rig04 | Rig04
38 | 238 |  |  | CARGO | CARGO
39 | 239 |  |  | CARGO | CARGO
40 | 240 |  |  | CARGO | CARGO
41 | 241 |  |  | STDBY | STDBY
42 | 242 |  |  | CARGO | CARGO
43 | 243 |  |  | CARGO | CARGO
Spreadsheet: 218118d1362359799-when-dragging-a-formula-horizontally-how-to-change-row-instead-of-column-test-comparison
Sheet: Plan1

2 | 3 | 5 | 6 |  | 8 |  | 8 | 9 | 4
1 | 0 | 5 | 8 | 9 | 5 | 9 | 5 | 7 | 9
4 | 8 | 4 | 2 | 0 | 6 | 0 | 6 | 8 | 6
 | 3 | 2 | 6 | 2 | 6 | 2 | 6 | 4 | 2
2 | 8 | 9 | 0 | 4 | 3 | 4 | 3 | 4 | 3
6 | 7 | 8 | 5 | 3 | 3 | 3 | 3 | 3 | 3
2 | 3 | 5 | 2 | 6 | 7 | 6 | 7 | 7 | 7
2 | 0 | 6 | 8 | 3 | 5 | 3 | 5 | 6
6 | 2 | 6 | 4 | 0 | 5 | 0 | 5 | 8 | 9
0 | 4 | 3 | 7 | 8 | 4 | 8 | 4 | 2 | 0
Spreadsheet: 151388d1334880610-pulling-data-from-one-sheet-to-another-that-meets-certain-criteria-camp-sign-up-spreadsheet-1-
Sheet: Entry Sheet

 | Name | First Child? (Y/N) | Extreme Week 1 | [NAME] Trip Week 1 | Archery Week | Choice Week | Water Week 1 | Road Trip Week 2 | Aero Space week | Extreme Week 2 | Water Week 2 | Last Week
1 | [NAME] | y |  | 10 | 10 |  | 10
2 | [NAME] | n |  | 10 | 10 |  | 10
3 | Stephen | y |  | 65 |  | 10 | 10 |  | 10
4 | Emily | y | 65 |  |  |  | 10 |  | 10
5 | Jake | n | 65 | 10 |  |  |  |  |  | 10
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
36
Spreadsheet: dc6e65de-c508-457c-b944-f7fc8b419660
Sheet: Sheet1

GENERAL | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | 120566 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
 | Brief Title |  | Approval Deadline |  | Reason
Tobacco Use Prevention Programs |  |  |  |  | To accept contract amendments from the Missouri Department of
(Region A) includes Clay, [NAME], [NAME], [NAME], and Lafayette counties. |  |  |  |  | Health and Senior Services
(Region D) includes Cass, Bates, [NAME], and [NAME] counties.
Details |  |  |  |  | Positions/Recommendations
 | Reason for Legislation |  |  |  | Sponsor |  |  |  | Health Department
 |  |  |  |  |  |  |  |  | [NAME], MD, MPH - Director
 |  |  |  |  | Programs,
 |  |  |  |  | Departments, |  |  |  | Health  Department
 |  |  |  |  | or Groups
 |  |  |  |  | Affected
 |  |  |  |  | Applicants / |  | Applicant
 |  |  |  |  | Proponents
 |  |  |  |  |  |  |  |  | _________ Department
 |  |  |  |  |  |  | City Department
 |  |  |  |  |  |  |  |  | _________ Department
 |  |  |  |  |  |  |  |  | _________ Department
 |  |  |  |  |  |  | Other
 |  |  |  |  | Opponents |  | Groups or Individuals
 |  |  |  |  |  |  |  |  | None Known
 |  |  |  |  |  |  | Basis of opposition
 |  |  |  |  | Staff
 |  |  |  |  | Recommendation |  | X |  | For
 |  |  |  |  |  |  |  |  | Against
 |  |  |  |  |  |  | Reason Against
 |  |  |  |  | Board or
 |  |  |  |  | Commission |  | By
 |  |  |  |  | Recommendation
 |  |  |  |  |  |  |  |  | For |  |  |  | Against |  | No action taken
 |  |  |  |  |  |  |  |  | For, with revisions or conditions
 |  |  |  |  |  |  |  |  | (see details column for conditions)
 |  |  |  |  | Council
 |  |  |  |  | Committee |  |  |  | Do pass
 |  |  |  |  | Actions
 |  |  |  |  |  |  |  |  | Do pass (as amended)
 |  |  |  |  |  |  |  |  | Committee Sub.
 |  |  |  |  |  |  |  |  | Without Recommendation
 |  |  |  |  |  |  |  |  | Hold
 |  |  |  |  |  |  |  |  | Do not pass
 |  |  |  |  |  |  |  |  |  |  |  | (Continued on reverse side)
Details |  |  |  |  | Policy/Program Impact
 |  |  |  |  | Policy or Program
 |  |  |  |  | Change |  | X |  | No |  |  |  | Yes
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Finances
 |  |  |  |  | Cost & Revenue
 |  |  |  |  | Projections --
 |  |  |  |  | Including Indirect
 |  |  |  |  | Costs
 |  |  |  |  | Financial Impact
 |  |  |  |  | Fund Source (s) |  | 19__ Budget, Page ___
 |  |  |  |  | and Appropriation |  | Unbudgeted, Appropriation
 |  |  |  |  | Account Codes |  | ________________ Fund
 |  |  |  |  |  |  | 00-000-00-0000-A0000
 |  |  |  |  | (Use this space for further discussion, if necessary)
Applicable Dates:
Fact Sheet Prepared by:
 | [NAME] |  | Date: 06-14-12
 | Title: Administrative Officer
Reviewed by:
 | Name |  | Date
 | Title
Reference Numbers
Spreadsheet: 202262d1356454994-dynamic-formule-kalenderglenn
Sheet: feestdagen

DAG | [NAME] | Maand | Dag | Naam |  |  |  | januari | 1 |  |  | verzuim
 |  | januari | 1 | Nieuwjaar |  |  |  | februari | 2 |  |  | z
 |  |  |  | Paaszondag |  |  |  | [NAME] | 3 |  |  | v
 |  |  |  | Paasmaandag |  |  |  | april | 4 |  |  | [NAME]
 |  | mei | 1 | Dag v/d Arbeid |  |  |  | mei | 5 |  |  | kd
 |  |  |  | Hemelvaartsdag |  |  |  | juni | 6 |  |  | f
 |  |  |  | Pinksterzondag |  |  |  | [NAME] | 7
 |  |  |  | Pinkstermaandag |  |  |  | augustus | 8
 |  | [NAME] | 11 | [NAME] |  |  |  | september | 9
 |  | [NAME] | 21 | Nationale Feestdag |  |  |  | oktober | 10
 |  | augustus | 15 | [NAME] |  |  |  | november | 11
 |  | november | 1 | Allerheiligen |  |  |  | december | 12
 |  | november | 2 | Allerzielen
 |  | november | 11 | Wapenstilstand 1918
 |  | november | 15 | Feest v/d Dynastie
 |  | december | 25 | Kerstmis
 |  | december | 25 | 2de Kerstdag
(E23:E32<>0)-(E23:E32="z")-(E23:E32="v")-(E23:E32="cv")-(E23:E32="kd")-(E23:E32="f")))
Spreadsheet: 270659d1381577485-discount-calculation-wideearp_discount
Sheet: Sheet1

 |  |  |  |  |  | Full Price | Discount
Cost | [NAME] | Sale Price | Gross Profit |  | 1
100 | 0.5 |  |  |  | 2
 |  |  |  |  | 3
 | Discount | Sale Price | Gross Profit |  | 4
 | 0.08 |  |  |  | 5
 |  |  |  |  | 6
 | Qty Sale | Gross Profit |  |  | 7
 | 20 |  |  |  | 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
Spreadsheet: darrell_schoolcraft__7725__TW 2002 Integrity $$
Sheet: Sheet1

Transwestern Pipeline Company
2002 Pipeline Integrity Program
CAPITAL
Project Description | 2002 | Plan | Estimate
Reallocation from O&M |  | 900000
Install pig traps on 30" San Juan Lateral | [NAME] | 0 | 2500000
Replace 24" Panhandle River Crossing | [NAME] | 885558 | 885558
Install McLean Pig Receiver | [NAME] | 181272 | 181272
Smartpig Crawford Lateral (See O&M) |  | 175312 | 0
TW MAOP Upgrade Project |  | 150000 | 0
Placeholder for TW Smartpig Project |  | 1270660 | 0
O&M
Project Description | 2002 | Plan | Estimate
Pipeline Integrity Program |  | 4000000
Reallocation to Capital |  | -900000
Smartpig/caliper 24" Panhandle Lat. P2-P3 | Mid-Nov | 0 | 225000
Smartpig/caliper  30" ML  Sta1-Needles | Late-Jun | 0 | 250000
Smartpig/caliper 30" Loopline 1-Needles | Late Jun | 0 | 250000
Smartpig/caliper 16" Crawford Lateral | Mid-Nov | 0 | 200000
CI Survey | 3rd/4th [NAME] | 0 | 100000
Pipeline recoat - Albuquerque | [NAME] | 0 | 50000
Repairs on 30" Mainline Sta 1-Needles -smartpig | Sept | 0 | 350000
Repairs on 30" [NAME] | Sept | 0 | 300000
Repairs on 30" ML 7-6 (Main) | 2nd - New | 0 | 350000
Repairs on 30" ML 8-7 (Main) | 2nd - New | 0 | 275000
Repairs on 30" ML 5-4 (Loop) | 2nd - New | 0 | 450000
Repairs on 30" ML 5-4 (Main) | 2nd - New | 0 | 300000
 |  | 0
Spreadsheet: 743957d1628840598-sum-positive-and-negative-nos-separately-sum-positive-and-negative-nos-separately
Sheet: Sheet1

Rate | Answer
114.3999999999996
66.60000000000036
-53.25
-8.899999999999636
209.8999999999996
137.5
78.70000000000073
1.399999999999636
30.75
-161.8999999999996
-152.4000000000015 | -314.2
239.8500000000004
123.5500000000011 | 363.4
-54.35000000000036
-218.4500000000007
-133
-271.3999999999996
-149.9500000000007
-182.9499999999989 | -1010.1
646.6000000000004
366.6499999999996
142.1000000000004
105.6999999999989
28.60000000000036
191.5499999999993 | 1481.2
-6.5
-2.799999999999272 | -9.3
66.79999999999927 | 66.8
-10 | -10
151.4000000000015 | 151.4
-1.25
-104.5500000000011
-89.94999999999891
-137.2000000000007
-306.0499999999993 | -639
32.09999999999854
274.2000000000007
115.3500000000004
-568.2000000000007
232.3999999999996
157.5500000000011
326.5
-164.8500000000004
-142.6499999999996
18.10000000000036
142.1999999999989
76.39999999999964
-143.8499999999985
-101.4500000000007
-19.04999999999927
-189.1500000000015
-163.4499999999989
186.1499999999996
-7.600000000000364
78.35000000000036
-265.3500000000004
-224.5
182.3999999999996
337.8000000000011
-154.3999999999996
176.6499999999996
-229.5500000000011
45.70000000000073
135.5499999999993
54.75
-38.94999999999891
-524.0500000000011
194
76.65000000000146
36.39999999999964
-258.3999999999996
-63.05000000000109
109.75
-64.79999999999927
143.6499999999996
168.0499999999993
211.5
30.35000000000036
-263.7999999999993
3.049999999999272
-137.6499999999996
121.3500000000004
106.9499999999989
98.35000000000036
119.2000000000007
-91.60000000000036
-154.25
-18.70000000000073
245.3500000000004
184.9500000000007
-77.95000000000073
-124.1000000000004
269.25
22.40000000000146
10.75
93
36.39999999999964
97.79999999999927
147.1499999999996
-7.949999999998909
1.350000000000364
114.1499999999996
-20.10000000000036
81.39999999999964
-11.54999999999927
-104.75
102.3999999999996
61.60000000000036
12.5
57.39999999999964
-101.7000000000007
-76.14999999999964
-8.049999999999272
63.14999999999964
26.25
-85.79999999999927
103.5
69.89999999999964
-45.64999999999964
-66.25
-26.95000000000073
-41.5
42.20000000000073
112.1499999999996
-16.10000000000036
61.39999999999964
-151.75
-38.10000000000036
2.800000000001091
119.75
41.60000000000036
70.25
-0.8000000000010914
-171
-120.2999999999993
191.9499999999989
32
-31.59999999999854
-78
-37.05000000000109
69.05000000000109
-15.40000000000146
122.1000000000004
245.6000000000004
128.0499999999993
35.80000000000109
-56.39999999999964
20.04999999999927
21.85000000000036
2.149999999999636
82.14999999999964