tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: larry_campbell__21590__Winter_icap_auction_monthly_offer_form_09-27-01_20_00
Sheet: Strip Award

If you change the size of the table, MAKE SURE that you copy the contents of range B17:F17 to area B18:F (bottom)
Offer# | PTID# | Minimum Price Offered [($/kW- 6 month) express to nearest $.01] | Amount (MW) [expressed to nearest 0.1 MW] | [NAME]. | Amount (MW) Sold | Market Clearing Price | Sold Amount $ | NYC Mitigated
1
 |  | Period Purchased: |  |  | Total Value Sold
Spreadsheet: 481361d1474416878-working-out-numbers-based-on-postcodes-example
Sheet: Sheet2

# | Region | Territory
510 | SUNNYBANK HILLS QLD 4109 | ?
504 | SOUTHPORT QLD 4215
495 | CAIRNS QLD 4870
495 | EARLVILLE QLD 4870
490 | WATERFORD QLD 4133
489 | IPSWICH QLD 4305
486 | PALM BEACH QLD 4221
486 | BERSERKER QLD 4701
483 | TOOWONG QLD 4066
479 | SMITHFIELD QLD 4878
479 | TOWNSVILLE CITY QLD 4810
478 | SPRINGFIELD QLD 4300
476 | YEPPOON QLD 4703
474 | EAST BRISBANE QLD 4169
472 | TRINITY BEACH QLD 4879
471 | MACKAY QLD 4740
471 | TOOWOOMBA QLD 4350
470 | [NAME] 4570
463 | SPRINGFIELD QLD 4300
463 | ROBINA QLD 4226
462 | MERMAID BEACH QLD 4218
461 | PADDINGTON QLD 4064
460 | COORPAROO QLD 4151
460 | COORPAROO QLD 4151
457 | [NAME] 4741
455 | GOODNA QLD 4300
455 | LIVERPOOL NSW 2170
449 | RED HILL QLD 4059
447 | HAWTHORNE QLD 4171
442 | MURRUMBA DOWNS QLD 4503
441 | REDCLIFFE QLD 4020
440 | PARADISE POINT QLD 4216
439 | REDBANK PLAINS QLD 4301
439 | MILSONS POINT NSW 2061
436 | CARRUM DOWNS VIC 3201
433 | PADDINGTON QLD 4064
431 | NEWMARKET QLD 4051
431 | WILSTON QLD 4051
430 | WINDSOR QLD 4030
Spreadsheet: 162386d1339841356-excel-2007-offset-function-help-needed-order-quiz
Sheet: ORDER

CATEGORY | [NAME] | PRODUCT | QUANT
FITTINGS | [NAME] | OTVOD | 531
 |  | PIPE  PVC | 110
 |  | VENT | 862
 |  | VENT | 126
 |  | PIPE STAL | 765
 |  | [NAME] | 678
 |  | OTVOD | 173
 |  | PIPE  PVC | 511
VENT | KANAL | VENT | 180
 |  | VENT | 181
 |  | PIPE STAL | 118
 |  | [NAME] | 86
 |  | OTVOD | 26
 |  | PIPE  PVC | 24
 |  | VENT | 18
 |  | VENT | 6
 |  | PIPE STAL | 20
 |  | [NAME] | 12
 |  | OTVOD | 13
 |  | PIPE  PVC | 16
 |  | VENT | 16
 |  | VENT | 4
 |  | PIPE STAL | 7
 |  | [NAME] | 1
 |  | OTVOD | 3
 |  | PIPE  PVC | 5
 |  | VENT | 9
 |  | VENT | 4
 |  | PIPE STAL | 3
 |  | [NAME] | 8
 |  | OTVOD | 2
 |  | PIPE  PVC | 1
 |  | VENT | 1
 |  | VENT | 12
 |  | PIPE STAL | 13
 |  | [NAME] | 16
 |  | OTVOD | 16
 |  | PIPE  PVC | 4
 |  | VENT | 25
 |  | VENT | 5
 |  | PIPE STAL | 1
 |  | [NAME] | 6
 |  | OTVOD | 6
 |  | PIPE  PVC | 2
 |  | VENT | 1
 |  | VENT | 1
Spreadsheet: 862460d1710180838-sumproduct-property-tax-calculations-property-tax-calculator
Sheet: Sheet1

Stamp Duty Calculations
Purchase Price | 1100000 | Property purchase price
Breakdown
Band start | Band end | 1st home rate | 2nd home rate |  | Amount in band | 1st home stamp duty | 2nd home stamp duty
0 | 145000 | 0 | 0.06
145000 | 250000 | 0.02 | 0.08
250000 | 325000 | 0.05 | 0.11
325000 | 750000 | 0.1 | 0.16
750000 |  | 0.12 | 0.18
Total Stamp Duty
Single cell formula
 | 1st home | 2nd home
Total Stamp Duty
Spreadsheet: 174700d1345149836-sumif-by-ignoring-duplicate-entries-in-a-different-column-dupli
Sheet: Sheet1

Code, | Qtr, | Country, | Count | helper | Q2 | India
209575164 | Q1 | India | 105 | 209575164Q1India | 79
209575164 | Q1 | China | 105 | 209575164Q1China
209575164 | Q1 | India | 105 | 209575164Q1India
NZNQK8TWBQ7 | Q1 | India | 22 | NZNQK8TWBQ7Q1India
204561345 | Q1 | India | 147 | 204561345Q1India
204561345 | Q1 | India | 147 | 204561345Q1India
204561345 | Q1 | India | 147 | 204561345Q1India
FHN5CQ2PCK4 | Q2 | India | 22 | FHN5CQ2PCK4Q2India
FHN5CQ2PCK4 | Q2 | India | 22 | FHN5CQ2PCK4Q2India
FHN5CQ2PCK4 | Q2 | India | 22 | FHN5CQ2PCK4Q2India
FHN5CQ2PCK4 | Q2 | USA | 22 | FHN5CQ2PCK4Q2USA
FHN5CQ2PCK4 | Q2 | India | 22 | FHN5CQ2PCK4Q2India
202450605 | Q2 | India | 57 | 202450605Q2India
202450605 | Q2 | India | 57 | 202450605Q2India
202450605 | Q2 | India | 57 | 202450605Q2India
Spreadsheet: 814314d1674273596-sumif-with-deduction-from-previous-months-totals-maybe-fleet-management-diff-from-previous-pt
Sheet: Running Totals

Vehicle # | 2
Year Starting Mileage | 19000
 | January | February | March | April | May | June | July | August | September | October | November | December
 | 4000 | 4000
Vehicle # | 3
Year Starting Mileage | 50000
 | January | February | March | April | May | June | July | August | September | October | November | December
 | 4000 | 4000
Spreadsheet: 154169d1336270457-count-from-table-with-multiple-criteria-count-in-counts-tab-from-table-in-table-of-values-tab
Sheet: Table of Values

Color | Day
Green | Tuesday
Green | Monday
Green | Monday
Green | Wednesday
Green | Tuesday
Green | Friday
Blue | Monday
Blue | Monday
Blue | Tuesday
Blue | Wednesday
Blue | Wednesday
Blue | Tuesday
Yellow | Tuesday
Yellow | Tuesday
Yellow | Wednesday
Yellow | Wednesday
Yellow | Tuesday
Yellow | Tuesday
Yellow | Tuesday
Yellow | Tuesday
Yellow | Tuesday
Yellow | Tuesday
Yellow | Friday
Spreadsheet: 470400d1468458763-need-a-formula-that-tracks-our-students-absences-csdb-attendance
Sheet: Referrals

STUDENT | REFERRED | BFC DATE | DID THEY REGISTER? | BONUS CLASSES | $100 COUPON # | C ISSUED | C EXPIRES ON | DATE USED | ADD'L NOTES
Amiri, Adam | [NAME] | 2016-06-11 00:00:00 | No | Added 2 on 6/15/16/ CB | not eligible | - | -
Amiri, Adam | [NAME] | 2016-06-18 00:00:00 | Yes | Added 2 on 6/21/2016 | #1010 | 2016-06-21 00:00:00 | 2016-09-21 00:00:00
Baghoomian, Alec | [NAME] | 2016-05-14 00:00:00 | Yes | Added 2 on 5/27/16. CB | #1008 | 2016-05-28 00:00:00 | 2016-08-28 00:00:00
Barsom, Zachary | Aiden & Emi Wong | 2016-03-26 00:00:00 | Yes | Added 2 on 3/29/16. CB | #1001 | 2016-03-29 00:00:00 | 2016-06-29 00:00:00
[NAME], Mychal-Bella | [NAME] | 2016-06-11 00:00:00 | No | Added 2 on 6/15/16/ CB | not eligible | - | -
Gonzalez-Baird, Violet | Mariah Watkins | 2016-04-30 00:00:00 | No | Added 1 on 5/27/16. CB | not eligible | - | -
[NAME], [NAME] | [NAME] | 2016-01-30 00:00:00 | Yes | Added 2 on 4/6/16. CB | #1003 | 2016-04-06 00:00:00 | 2016-07-06 00:00:00
[NAME], [NAME] | [NAME] | 2016-01-30 00:00:00 | Yes | Added 2 on 4/6/16. CB | Will issue when | - | - | -
[NAME], [NAME] | [NAME] | 2015-10-10 00:00:00 | Yes | Corrected on 4/16/16. CB | previous coupon is redeemed | - | - | -
[NAME][NAME]) | Belle & Beau Boren | 2016-04-06 00:00:00 | Yes | inactive |  | - | - | -
[NAME], Tiger | Zachary | 2016-04-16 00:00:00 | No | Added 1 on 4/20/16. CB | not eligible
Luczak, Megan | [NAME] | 2016-05-28 00:00:00 | No | Added 1 on 5/28/16. CB | not eligible
Martin, [NAME] | [NAME] | 2016-05-07 00:00:00 | Yes | Added 2 6/15/16. CB | #1009 | 2016-06-15 00:00:00 | 2016-09-15 00:00:00
[NAME], [NAME] | [NAME] | 2016-06-18 00:00:00 | No | Added 1 on 6/21/16. CB | not eligible | - | - | -
[NAME], [NAME] | [NAME] | 2016-03-01 00:00:00 | Yes | Added on 3/1/16. CB | #1002 | 2016-03-19 00:00:00 | 2016-06-19 00:00:00
Thach, Celine | [NAME] | 2016-05-07 00:00:00 | No | Added 1 on 5/11/16. CB | not eligible | - | - | -
Toliver, [NAME] | River West | 2016-03-26 00:00:00 | Yes | Added 2 on 3/29/16. CB | #1005 | 2016-04-16 00:00:00 | 2016-07-16 00:00:00
Trotter, [NAME] | Soloman [NAME] | 2016-06-11 00:00:00 | No | Added 1 on 6/15/16. CB | not eligible | - | - | -
Santos, Trinity | [NAME] | 2016-04-20 00:00:00 | Yes | Added 2 on 5/27/16. CB | #1007 | 2016-05-28 00:00:00 | 2016-08-28 00:00:00
Smith, Sophie + Naomi | Destiny Toliver | 2016-03-12 00:00:00 | Yes | inactive | inactive | - | - | -
Spirko Mom | [NAME] | 2016-03-12 00:00:00 | Yes | Added 2 on 4/13/16. CB | #1004 | 2016-04-12 00:00:00 | 2016-07-12 00:00:00
Winn, [NAME] | Quinn Pickett | 2016-04-09 00:00:00 | Yes | Added 2 on 4/20/16. CB | #1006 | 2016-04-20 00:00:00 | 2016-07-20 00:00:00
Yanez, [NAME] | [NAME] | 2016-04-09 00:00:00 | No | Added 1 on 4/9/16. CB | not eligible
Yanez, [NAME] | [NAME] | 2016-04-09 00:00:00 | No | Added 1 on 4/9/16. CB | not eligible
Zhang, [NAME] | [NAME] | 2016-03-26 00:00:00 | No | Added 1 on 3/29/16. CB | not eligible
Zimmerman, [NAME] | [NAME] | 2016-05-28 00:00:00 | Yes | inactive
Spreadsheet: 117653d1312939509-excel-2007-merge-duplicate-address-with-account-info-aftermergeexample
Sheet: Sheet1

Title | First Name | Last Name | Street 1 | Street 2 | City | St./Prov. | Postal Code | Nation | Phone Number | E-Mail Address | Newsletter - Canadian | Newsletter - US | Newsletter - Foreign | Incarcerated | Allows Solicitation | AccountCreated Date | Last Modified Date | Appeal Category |  | Demo. Sub Cat.
Sir | Jon | Doe | 12345 East | Apt1 | Where | YY | 12345 | USA | [PHONE] | [EMAIL] | No | No | Yes | No | NO | 2001-01-01 00:00:00 | 7/7/2011 10:22:11 AM | CD1 | BOOK1 | WWW | COM
Ms | [NAME] | Doe | 54321 East |  | Somewhere | ZZ | 55442 | CANADA | [PHONE] | [EMAIL] | No | No | No | No | YES | 2005-05-05 00:00:00 | 7/29/2011 12:52:37 PM | Book2 | CD2
Spreadsheet: 839579d1692097215-paste-unique-distinct-value-and-the-value-of-a-corresponding-cell-in-a-new-worksheet-excelforum
Sheet: Sheet2

Report to Full Name | Report to Preferred Name | Report to Surname | Report to Work Email Address
[NAME], [NAME] | [NAME] | [NAME] | [EMAIL]
[NAME], [NAME] | [NAME] | [NAME] | [EMAIL]
[NAME], [NAME] | [NAME] | [NAME] | [EMAIL]
[NAME], [NAME] | [NAME] | [NAME] | [EMAIL]
[NAME], [NAME] | [NAME] | [NAME] | [EMAIL]
[NAME], [NAME] | [NAME] | [NAME] | [EMAIL]
[NAME], [NAME] | [NAME] | [NAME] | [EMAIL]
[NAME], [NAME] | [NAME] | [NAME] | [EMAIL]
[NAME], [NAME] | [NAME] | [NAME] | [EMAIL]
[NAME], [NAME] | [NAME] | [NAME] | [EMAIL]
[NAME], [NAME] | [NAME] | [NAME] | [EMAIL]
[NAME], [NAME] | [NAME] | [NAME] | [EMAIL]
[NAME], [NAME] | [NAME] | [NAME] | [EMAIL]
[NAME], [NAME] | [NAME] | [NAME] | [EMAIL]
Advt, [NAME] T | Jo | Advt | [EMAIL]
Advt, [NAME] T | Jo | Advt | [EMAIL]
Advt, [NAME] T | Jo | Advt | [EMAIL]
Advt, [NAME] T | Jo | Advt | [EMAIL]
Spreadsheet: daren_farmer__6673__Failed Deals
Sheet: Transaction Summary Report -1

EnronOnline | Transaction Summary Report -1 | Internals Excluded
[NAME] Id | Time | Customer | Product | Buy Volume | Sell Volume | Units | Price | Int User Id | Risk Book | Contract # | [NAME] ID | Begin Date | End Date
179886 | 2000-05-08 08:03:51 | Aquila Energy Marketing Corporation | US Gas Phy       Exxon Katy              09May00         USD/MM |  | 10000 | MMBtu | 3.035 | CMETZ | HPLC - IM HPLC |  | 18
179890 | 2000-05-08 08:04:31 | Aquila Energy Marketing Corporation | US Gas Phy       Exxon Katy              09May00         USD/MM |  | 10000 | MMBtu | 3.0425 | CMETZ | HPLC - IM HPLC |  | 18
179893 | 2000-05-08 08:05:51 | ONEOK Gas Marketing Company | US Gas Phy       Exxon Katy              09May00         USD/MM | 10000 |  | MMBtu | 3.04 | CMETZ | HPLC - IM HPLC |  | 2425
179895 | 2000-05-08 08:06:59 | Aquila Energy Marketing Corporation | US Gas Phy       Exxon Katy              09May00         USD/MM |  | 10000 | MMBtu | 3.045 | CMETZ | HPLC - IM HPLC |  | 18
179903 | 2000-05-08 08:10:02 | Aquila Energy Marketing Corporation | US Gas Phy       Exxon Katy              09May00         USD/MM |  | 10000 | MMBtu | 3.05 | CMETZ | HPLC - IM HPLC |  | 18
179958 | 2000-05-08 08:15:46 | Southern Company Energy Marketing, L.P. | US Gas Phy       Exxon Katy              09May00         USD/MM |  | 10000 | MMBtu | 3.065 | CMETZ | HPLC - IM HPLC | 96004590 | 56264
Spreadsheet: 6f42d98b-6657-445c-a066-3c3ea088557d
Sheet: Sheet1

Permit No.: | Unnamed: 1 | Unnamed: 2 | WQ0000884 | Unnamed: 4 | Unnamed: 5 | Facility Name: | Unnamed: 7 | Mt. Olive Turkey Processing Facility | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | County: | Duplin | Unnamed: 16 | Month: | Unnamed: 18 | Unnamed: 19 | Year: | Unnamed: 21
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | 01A |  | Field Name: |  | 01B |  | Field Name: |  | 01C |  | Field Name: |  | 02A
 |  |  |  |  |  | Area (acres): |  | 26.75 |  | Area (acres): |  | 74.59 |  | Area (acres): |  | 11.48 |  | Area (acres): |  | 18.61
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  |  |  | [NAME] (in): |  |  |  | [NAME] (in): |  |  |  | [NAME] (in):
 |  |  |  |  |  | Annual Rate (in): |  | 50 |  | Annual Rate (in): |  | 50 |  | Annual Rate (in): |  | 50 |  | Annual Rate (in): |  | 50
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
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
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 142738d1329993852-how-to-split-some-qty-with-respect-to-a-particular-constant-copy-of-capacity-check
Sheet: Result Template

Model
AAAAAAAAAA | 300 | 300 | 300 | 100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
BBBBBBBBBB | 0 | 150 | 150 | 150 | 50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CCCCCCCCC | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DDDDDDDDD | 0 | 0 | 0 | 0 | 0 | 0 | 60 | 40 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
EEEEEEEEEEE | 0 | 0 | 0 | 0 | 0 | 0 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 3000 | 2000
FFFFFFFFFFF | 0 | 810 | 810 | 810 | 810 | 810 | 810 | 140 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 08813b03-06c0-4103-b7fd-2299e5258cc7
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 9. FINANCE COMMITMENTS, For Motor Vehicles: Australia, Original ($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
Personal Finance - New motor cars and station wagons ; |  |  | Original | A2414166T | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Personal Finance - Used motor cars and station wagons ; |  |  | Original | A2414167V | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Personal Finance - Motor cycles ; |  |  | Original | A2414168W | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Personal Finance - Other motor vehicles ; |  |  | Original | A2414169X | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Personal Finance - Total ; |  |  | Original | A2414170J | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Commercial Finance ; |  |  | Original | A2414171K | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
Value of Lease Finance Commitments ; |  |  | Original | A2414172L | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Original | A2414173R | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | DERIVED | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: cf3021ec-adf7-43f7-9bec-b150c9955ed8
Sheet: Sheet1

GENERAL | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | 120137 | 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
 | Use of 3-Traic CID funds for |  |  |  | Authorize the Director of Public Works to execute
 | construction of pedestrian bridge |  |  |  | Cooperative Agreements to receive CID funds |  |  |  |  |  |  |  | expend |  | CID funds
Details |  |  |  |  | Positions/Recommendations
 | Reason for Legislation |  |  |  | Sponsor |  |  |  | City Engineer
 |  |  |  |  | Programs,
 |  |  |  |  | Departments, |  |  |  | Public Works Department
 |  |  |  |  | or Groups
 |  |  |  |  | Affected
 |  |  |  |  | Applicants / |  | Applicant
 |  |  |  |  | Proponents
 |  |  |  |  |  |  |  |  | _________ Department
 |  |  |  |  |  |  | City Department
 |  |  |  |  |  |  |  |  | _________ Department
 |  |  |  |  |  |  |  |  | _________ Department
 |  |  |  |  |  |  | Other
 |  |  |  |  | Opponents |  | Groups or Individuals
 | Discussion
 |  |  |  |  |  |  |  |  | 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)
 |  |  |  |  | and Appropriation
 |  |  |  |  | Account Codes |  |  |  | 11
 |  |  |  |  | (Use this space for further discussion, if necessary)
Applicable Dates:
Fact Sheet Prepared by:
 | Masood Alemifar |  | 2012-02-06 00:00:00
 | [NAME]
Reviewed by:
 | [NAME] |  | 2012-02-06 00:00:00
 | Manager, Program Management
Reference Numbers
Spreadsheet: 275969d1383701379-vlookup-with-concatenated-unique-identifier-vlookupsampleworkbook-with-indirect-and-match
Sheet: Sheet2

Start WeekDay | Start Date | Start Time | End Date | End Time | Origin (Place) | Number Dialled | Provider / Network | Rate | Duration | Volume | Excl GST $ | Incl GST $ | Match | Last | First
Day | Date | Time | Date | 12:00AM | Suburb | 1111111111 |  |  | 0 | 1 | monies | monies
Day | Date | Time | Date | 12:00AM | Suburb | 4444444444 |  |  | 0 | 1 | monies | monies
Day | Date | Time | Date | 12:00AM | Suburb | 7777777777 |  |  | 0 | 1 | monies | monies
Day | Date | Time | Date | 12:00AM | Suburb | 3333333333 |  |  | 0 | 1 | monies | monies
Day | Date | Time | Date | 12:00AM | Suburb | 5555555555 |  |  | 0 | 1 | monies | monies
Spreadsheet: david_delainey__8183__2001PROFORMA
Sheet: HP&L

 |  |  |  | Houston PipeLine
 |  |  |  |  |  | Full Year Estimate | Jan-July | July - Dec | Total
 |  |  |  | Originations |  | 0 |  | 0
 |  |  |  | Trading |  | 0 |  | 0
 |  |  |  | FV-Investments |  | 0 |  | 0
 |  |  |  | Accrual |  | 30000000 |  | 0
 |  |  |  | Lease |  | 0
 |  |  |  | Net Income
 |  |  |  | Operating Expenses |  | 75867000 |  | 0
 |  |  |  | Condor Credit |  | 5600000 |  | 0
 |  |  |  | Monetizations |  | 0 |  | 0
 |  |  |  | Extraordinary NoOp Exp |  | 0 |  | 0
 |  |  |  | Fixed Pmts (FAS 125 - Operating/Financing) |  | 43233000 |  | 0
 |  |  |  | Net
 |  |  |  | Total Margin
 |  |  |  | People |  | 9257000 |  | 0
 |  |  |  | Travel & Entertainment |  | 704000 |  | 0
 |  |  |  | Consulting |  | 1464000 |  | 0
 |  |  |  | Office |  | 1546000 |  | 0
 |  |  |  | Controllable Infrastructure |  | 884000 |  | 0
 |  |  |  | Insurance |  | 842000 |  | 0
 |  |  |  | Systems Development |  | 283000 |  | 0
 |  |  |  | Other Expenses |  | 17000 |  | 0
 |  |  |  | Outside Legal |  | 2438000 |  | 0
 |  |  |  | Outside Tax |  | 108000 |  | 0
 |  |  |  | Total Direct Expenses
 |  |  |  | EBIT
 |  |  |  | Capital Charge
 |  |  |  | DDA |  | 19400000
 |  |  |  | [NAME] |  | 12800000
 |  |  |  | Balance Sheet
 |  |  |  |  |  | Jan - July | Capital Charge | July - Dec | Capital Charge
 |  |  |  |  | HPL PP&E |  |  | 443000000
 |  |  |  |  | MEGS PP&E |  |  | 0
 |  |  |  |  | HPLR PP&E |  |  | 0
 |  |  |  |  | Enron Texoma PP&E |  |  | 0
 |  |  |  |  | MAC PP&E |  |  | 0
 |  |  |  |  | [NAME] |  | 0 | 0
 |  |  |  |  | MAC equity investment |  |  | 0
 |  |  |  |  | HMS investment |  |  | 0
 |  |  |  |  | Other Investments |  |  | 0
 |  |  |  |  | Bammell Gas Trust |  |  | 0
 |  |  |  |  | [NAME] |  |  | 0
 |  |  |  |  | Mid Texas |  |  | 0
 |  |  |  |  | Total
Spreadsheet: 787882d1658133548-help-separate-text-cell-of-terms-into-pairs-pairs-sample
Sheet: Sheet1

 | apple,orange,banana,coconut,dragon fruit,papaya
 | apple,orange | apple,banana | apple,coconut | apple,dragon fruit | apple,papaya | orange,banana | orange,coconut | orange,dragon fruit, | orange,papaya | banana,coconut, | banana,dragon fruit | banana,papaya | coconut,dragon fruit | ,coconut,papaya | dragonfruit,papaya
Spreadsheet: 385785d1427417148-trying-to-get-cell-to-fill-with-shift-working-by-the-date-and-time-entered-in-a-cell-solution
Sheet: Sheet1

2014-03-28 06:00:00 | 2014-03-28 17:58:59.995000 | 1-Shift |  | 2015-03-28 11:44:01
2014-03-28 18:00:00 | 2014-03-29 05:58:59.995000 | 2-Shift
2014-03-29 06:00:00 | 2014-03-29 17:58:59.995000 | 1-Shift
2014-03-29 18:00:00 | 2014-03-30 05:58:59.995000 | 2-Shift
2014-03-30 06:00:00 | 2014-03-30 17:58:59.995000 | 3-Shift
2014-03-30 18:00:00 | 2014-03-31 05:58:59.995000 | 4-Shift
2014-03-31 06:00:00 | 2014-03-31 17:58:59.995000 | 3-Shift
2014-03-31 18:00:00 | 2014-04-01 05:58:59.995000 | 4-Shift
2014-04-01 06:00:00 | 2014-04-01 17:58:59.995000 | 1-Shift
2014-04-01 18:00:00 | 2014-04-02 05:58:59.995000 | 2-Shift
2014-04-02 06:00:00 | 2014-04-02 17:58:59.995000 | 1-Shift
2014-04-02 18:00:00 | 2014-04-03 05:58:59.995000 | 2-Shift
2014-04-03 06:00:00 | 2014-04-03 17:58:59.995000 | 1-Shift
2014-04-03 18:00:00 | 2014-04-04 05:58:59.995000 | 2-Shift
Spreadsheet: 139157d1328108023-multiple-vlookups-with-a-match-and-isna-component-or-not-multiple-lookups-with-one-using-a-string-match
Sheet: Sheet1

The table to be filled |  |  | The table for a single word match |  |  | The list of exact business names to match
Business | [NAME] |  | Name Match | [NAME] |  | Business Match | [NAME]
Pharmacy on Main | 44611 |  | Pharmacy | 44611 |  | Vacant | 9999
Doug's Pharmacy | 44611 |  | Convenience | 44512 |  | Convenience Supercenter | 44512
Corner Convenience | 44512
Convenience Supercenter | 44512 | 44512
Vacant | 9999 | 9999
What I am used to so far
Business | [NAME]
Pharmacy on Main | #N/A | The problem: while each of these have the word Pharmacy OR Convenience, they are not an exact match for VLOOKUP.  What I would like to do is match the string "Pharmacy" or "Convenience" to return the respective NAICS codes in Col2 of the Name Match table.  Likely this will be in the terms if IF(ISNA) such that if the Business match doesnt provide an exact match it will return #N/A directing Excel to perform the alternative search.
Doug's Pharmacy | #N/A
Corner Convenience | #N/A
Convenience Supercenter | 44512
Vacant | 9999
 |  | THANK YOU FOR GIVING THIS A LOOK!!!