tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 117689d1312966734-using-excel-to-manage-worked-houres-staff-manager
Sheet: Staff manager

Name | 24/072011 |  |  | 25/072011 |  |  | 26/072011 |  |  | 27/072011
 | IN | OUT | Total Time | IN | OUT | Total Time | IN | OUT | Total Time | IN | OUT | Total Time
[NAME] |  |  | 1900-01-01 00:00:00 |  |  | 1900-01-01 00:00:00 |  |  | 1900-01-01 00:00:00 |  |  | 1900-01-01 00:00:00
[NAME] |  |  | 1900-01-01 00:00:00 |  |  | 1900-01-01 00:00:00 |  |  | 1900-01-01 00:00:00 |  |  | 1900-01-01 00:00:00
[NAME] |  |  | 1900-01-01 00:00:00 |  |  | 1900-01-01 00:00:00 |  |  | 1900-01-01 00:00:00 |  |  | 1900-01-01 00:00:00
[NAME] |  |  | 1900-01-01 00:00:00 |  |  | 1900-01-01 00:00:00 |  |  | 1900-01-01 00:00:00 |  |  | 1900-01-01 00:00:00
[NAME] |  |  | 1900-01-01 00:00:00 |  |  | 1900-01-01 00:00:00 |  |  | 1900-01-01 00:00:00 |  |  | 1900-01-01 00:00:00
Here is who the table should look like after AUTO DATA EXTRACT
Name | 24/072011 |  |  | 25/072011 |  |  | 26/072011 |  |  | 27/072011
 | IN | OUT | Total Time | IN | OUT | Total Time | IN | OUT | Total Time | IN | OUT | Total Time
[NAME] | 06:35:00 | 15:00:00 | 08:25:00 | 15:25:00 |  | 1900-01-01 00:00:00 | 07:10:00 | 15:30:00 | 08:20:00 |  |  | 1900-01-01 00:00:00
[NAME] | 22:40:00 | 06:30:00 | 07:50:00 |  |  | 1900-01-01 00:00:00 |  |  | 1900-01-01 00:00:00 |  |  | 1900-01-01 00:00:00
[NAME] |  |  | 1900-01-01 00:00:00 | 23:43:00 | 08:30:00 | 08:47:00 |  |  | 1900-01-01 00:00:00 |  |  | 1900-01-01 00:00:00
[NAME] |  | 14:30:00 | 1900-01-01 00:00:00 |  |  | 1900-01-01 00:00:00 |  |  | 1900-01-01 00:00:00 |  |  | 1900-01-01 00:00:00
[NAME] |  |  | 1900-01-01 00:00:00 |  | 23:00:00 | 1900-01-01 00:00:00 |  |  | 1900-01-01 00:00:00 |  |  | 1900-01-01 00:00:00
Spreadsheet: 890362d1741786727-spill-error-master-project-list-test
Sheet: Search

 | Search your job name below
Searcy by Job Name: |  | Job Number |  | Status
Delete job name above to search for job number instead
Search by Job Number: |  | Job Number |  | Status
Address:
01 - PROJECT EXECUTIVE
02 - SR. PROJECT MANAGER
03 - PROJECT MANAGER
04 - ASST. PROJECT MANAGER
05 - MECH SUPERINTENDENT
06 - ELECTRICAL SUPERINTENDENT
07 - SR PROJECT ENGINEER
08 - PROJECT ENGINEER
11 - SR. PROJECT ACCT
12 - PROJECT ACCT
13 - ASST PROJECT ACCT
14 - FPA TEAM LEAD
15 - PROJECT ADMIN
Spreadsheet: 0a3892f4-fbde-4a70-a31d-37a3f9c2bad9
Sheet: Sheet1

 | 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
 | Fri | Sat | Sun | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun | Mon | [NAME] | Wed | Thurs | Fri | Sat | Sun | Mon | [NAME] | Wed | Thurs
07:00:00
07:15:00
07:30:00
07:45:00
08:00:00
08:15:00
08:30:00
08:45:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CLOSED | FOR | SEASON | SEE | YOU | IN | OCTOBER!
09:00:00
09:15:00
09:30:00
09:45:00
10:00:00 |  | [NAME]
10:15:00 |  | PeeWee
10:30:00 |  | League
10:45:00 |  | Game
11:00:00 |  | 10-11:15 am
11:15:00
11:30:00 |  | [NAME]
11:45:00 |  | PeeWee
12:00:00 |  | League
12:15:00 |  | Game
12:30:00 |  | 11:30-12:45 pm
12:45:00
01:00:00 | Public Skate | Public Skate | Public Skate |  |  |  |  | Public Skate | Public | Public |  |  |  |  | Public Skate | Public Skate | Public Skate
01:15:00 | Session #1 | Session #1 | Session #1 |  |  |  |  | Session #1 | Skate | Skate |  |  |  |  | Session #1 | Session #1 | Session #1
01:30:00 | 1:00 - 2:30 pm |  |  |  |  |  |  | 1:00 - 2:30 pm | Session #1 | Session #1 |  |  |  |  | 1:00 - 2:30 pm | 1:00 - 2:30 pm | 1:00 - 2:30 pm
01:45:00
02:00:00
02:15:00
02:30:00
02:45:00 | Public | Public Skate | Public |  |  |  |  | Public | Public | Public |  |  |  |  | Public | Public | Public
03:00:00 | Skate | Session #2 | Skate | Public | Public | Public | Public | Skate | Skate | Skate | Public | Public | Public | Public | Skate | Skate | Skate
03:15:00 | Session #2 |  | Session #2 | Skate | Skate | Skate | Skate | Session #2 | Session #2 | Session #2 | Skate | Skate | Skate | Skate | Session #2 | Session #2 | Session #2
03:30:00 | 2:45-4:15 pm |  |  | 3:00-4:30 pm |  |  |  | 2:45-4:15 pm |  |  | 3:00-4:30 pm |  |  |  | 2:45-4:15 pm | 2:45-4:15 pm | 2:45-4:15 pm
03:45:00
04:00:00
04:15:00
04:30:00
04:45:00
05:00:00
05:15:00
05:30:00
05:45:00
06:00:00 |  |  | Co-Ed |  |  |  |  |  |  | Co-Ed |  |  |  |  |  |  | Co-Ed
06:15:00 |  |  | League |  |  |  |  |  |  | League |  |  |  |  |  |  | League
06:30:00 |  |  | Practice |  |  |  |  |  |  | Practice |  |  |  |  |  |  | Practice
06:45:00 |  |  | 6-7 pm |  |  |  |  |  |  | 6-7 pm |  |  |  |  |  |  | 6-7 pm
07:00:00
07:15:00
07:30:00
07:45:00
08:00:00
08:15:00
08:30:00
08:45:00
09:00:00
09:15:00
09:30:00
09:45:00
10:00:00
10:15:00
10:30:00
10:45:00
11:00:00
11:15:00
11:30:00
11:45:00
12:00:00
Spreadsheet: 124658d1318527692-excel-problem-interval-book3
Sheet: Sheet1

4 | 20
1 | 20 |  |  |  | 0 | 20
6 | 50 |  |  |  | 5 | 50
7 | 50 |  |  |  | 20 | 200
15 | 50
21 | 200
5 | 50
20 | 200
40 | 200
Spreadsheet: 08c9541f-1705-472d-9fcf-d6e553fd67de
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 | Unnamed: 12
 |  |  |  |  |  | University of Idaho 4-H Youth Development
 |  |  |  |  |  | Centennial 4-H Club Service to Community Challenge
Club Name: |  |  |  |  |  |  | County:
Name of Club Leader: |  |  |  |  |  |  | # of Club Members:
Mailing Address: |  |  |  |  |  |  | # of volunteer leaders:
City, State, Zip: |  |  |  |  |  |  | Percentage of total club members participating in service: |  |  |  |  | %
Name of Service Project:
Purpose/Description of Service Project:
Demographic Information |  |  |  |  |  |  |  | Return by September 15, 2012 to:
 | Number of Youth and Adults by Age |  |  |  |  |  |  |  | Mailing Address:
Cloverbuds | 8-13 Years | 14-18 Years | Volunteers | Parents | TOTAL | Number of Hours |  |  | University of Idaho 4-H Youth Development
 |  |  |  |  |  |  |  |  | Attn: Centennial 4-H Club Service to Community Challenge
 |  |  |  |  |  |  |  |  | P.O. Box 443015
 |  |  |  |  |  |  |  |  | Moscow, ID  83844-3015
 |  |  |  |  |  |  |  |  | Email: cstark@uidaho; Fax: [PHONE]
Club Leader Signature:
Spreadsheet: 05ca953f-b3ea-4042-8198-41b95b822c34
Sheet: Sheet1

Table 4--Cottonseed:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | Supply |  |  |  |  | Disappearance
Year beginning | Beginning |  |  |  |  |  |  |  |  | Ending
August 1 | stocks | Production | Imports | Total |  | Crush | Exports | Other | Total | stocks
 | 1,000 short tons
2010/11 | 341.601 | 0 | 6098.1 | 6439.701 |  | 2562.55107 | 275.111 | 2984.47593 | 5822.138 | 617.563
2011/121 | 617.563 | 71.601 | 5370 | 6059.164 |  | 2400 | 132.58 | 3096.584 | 5629.164 | 430
2012/132 | 430 | 100 | 5759 | 6289 |  | 2500 | 225 | 3072 | 5797 | 492
1 Estimated.  2 Forecast.
Sources: USDA, National Agricultural Statistics Service, Crop Production and U.S. Department of Commerce,
U.S. Census Bureau, Foreign Trade Statistics.
Last update: | 2013-04-12 11:56:50.930000
Spreadsheet: 04df2fac-5b0e-464d-b0fe-6c7422b47c6b
Sheet: org

Dist_Cnty | IRN
Please Select a District
Akron City (Summit) | 043489
Alliance City ([NAME]) | 043497
Ashtabula Area City (Ashtabula) | 043513
Cambridge City (Guernsey) | 043695
Canton City ([NAME]) | 043711
Cincinnati City ([NAME]) | 043752
Cleveland Heights-University Heights City (Cuyahoga) | 043794
Cleveland Municipal (Cuyahoga) | 043786
Columbus City School District (Franklin) | 043802
Dayton City (Montgomery) | 043844
East Cleveland City School District (Cuyahoga) | 043901
East Liverpool City ([NAME]) | 043919
Elyria City Schools (Lorain) | 043943
Euclid City (Cuyahoga) | 043950
[NAME] Schools (Cuyahoga) | 044040
Geneva Area City (Ashtabula) | 044057
[NAME] (Franklin) | 046979
Jefferson Township Local (Montgomery) | 048686
Liberty Local (Trumbull) | 050195
Lima City ([NAME]) | 044222
Lorain City (Lorain) | 044263
Mansfield City (Richland) | 044297
Maple Heights City (Cuyahoga) | 044305
Marion City (Marion) | 044339
Middletown City (Butler) | 044404
Mt Healthy City ([NAME]) | 044412
Painesville City Local (Lake) | 044628
Portsmouth City (Scioto) | 044669
Preble Shawnee Local (Preble) | 049288
Princeton City ([NAME]) | 044677
Sandusky City (Erie) | 044743
Scioto Valley Local (Pike) | 049130
South-Western City (Franklin) | 044800
Springfield City ([NAME]) | 044818
Toledo City (Lucas) | 044909
Trotwood-Madison City (Montgomery) | 048694
Warren City (Trumbull) | 044990
Warrensville Heights City (Cuyahoga) | 045005
Whitehall City (Franklin) | 045070
Youngstown City Schools (Mahoning) | 045161
Zanesville City (Muskingum) | 045179
Spreadsheet: 122046d1316583995-copying-a-sum-function-drawing-from-the-same-column-sample
Sheet: Sheet1

 |  |  |  | 9 | 36 | Sheet2!K9:K36 | 280
 |  |  |  | 37 | 64 | Sheet2!K37:K64 | 280
 |  |  |  | 65 | 92 | Sheet2!K65:K92 | 280
 |  |  |  | 93 | 120 | Sheet2!K93:K120 | 280
 |  |  |  | 121 | 148 | Sheet2!K121:K148 | 280
 |  |  |  | 149 | 176 | Sheet2!K149:K176 | 280
 |  |  |  | 177 | 204 | Sheet2!K177:K204 | 280
 |  |  |  | 205 | 232 | Sheet2!K205:K232 | 280
 |  |  |  | 233 | 260 | Sheet2!K233:K260 | 280
 |  |  |  | 261 | 288 | Sheet2!K261:K288 | 280
Spreadsheet: benjamin_rogers__1308__site_visit_schedule for Dave Kristich
Sheet: Confirm - Duke

 |  | Company | Duke Energy
 |  | Company Contact & Number | [NAME](713) 627-6579
 |  | Site or Sites | [NAME]
 |  | Site Visit Date | Tuesday October 17th
 |  | Directions to Hotels/Site | See DealBench - Due Diligence List/Plant Pictures Section
 |  | Meeting Time/Place | Tuesday Morning
 |  |  | Gleason Plant
 |  |  | 1166 [NAME].
 |  |  | Gleason, TN 38229
 |  | Enron Site Visit Coordinator | [NAME]
 |  |  | Work: (713) 853-7626 / Cell: (713) 515-9477
 |  |  | [NAME] Manager
 |  |  | Work: (901) 648-2190
 |  | Duke Site Visit Team | [NAME]: (713) 882-6871
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME], Director - Technical Services
 |  |  | [NAME]
 |  |  | [NAME]
Spreadsheet: 735172d1622734399-how-to-get-a-formula-to-jump-every-second-row-book3
Sheet: Sheet1

Data | [NAME] | What I want
Data 1 |  | Data 1
 |  | Data 2
Data 2 |  | Data 3
Data 3
Spreadsheet: 094844dd-bbf4-43c5-876e-5585c79f9aa0
Sheet: Sheet1

Unnamed: 0 | BALLOTS CAST/SUMMARY BY COUNTIES | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Feb. 1, 2000 | Republican |  |  |  | Democratic
 | Regular | Absentee | Total |  | Regular | Absentee | Total
Belknap | 12237 | 939 | 13176 |  | 5670 | 379 | 6049
Carroll | 10456 | 1082 | 11538 |  | 4117 | 283 | 4400
Cheshire | 12243 | 605 | 12848 |  | 9578 | 382 | 9960
Coos | 4857 | 324 | 5181 |  | 4125 | 186 | 4311
[NAME] | 14587 | 862 | 15449 |  | 9109 | 531 | 9640
Hillsborough | 66843 | 3260 | 70103 |  | 46703 | 2233 | 48936
Merrimack | 28399 | 1649 | 30048 |  | 17607 | 861 | 18468
Rockingham | 53276 | 2814 | 56090 |  | 32954 | 1361 | 34315
[NAME] | 16573 | 868 | 17441 |  | 15133 | 658 | 15791
[NAME] | 7198 | 451 | 7649 |  | 4764 | 228 | 4992
TOTALS | 226669 | 12854 | 239523 |  | 149760 | 7102 | 156862
Spreadsheet: 1e5efcc8-c89e-4b7c-af86-57761416f958
Sheet: Feuil1

 | NOMINATION FORM FOR TECHNICAL OFFICIALS FOR IWF EVENTS IN 2014
 | RETURN TO IWF: |  | BY EMAIL: |  | [EMAIL] |  |  |  | Deadline: 20 FEBRUARY 2014!
 |  | Mr. / Ms. | Family Name | Given Name(s) |  | TO Card Number | Work in 2010-2013 in WCh, OG, Cont. / Reg. Games, Cont. / [NAME]. Champs  Year / Event* | 2014 JWC Kazan | 2014 YOG Nanjing | 2014 WC Almaty | 2014 WUC  ChiangMai
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | Doctor on Duty
 | Doctor on Duty
 |  |  |  |  |  |  |  | Propose maximum 2 TOs /DoD per Event!
 | Country code: |  |  |  |  | Date: |  | Signature:
 | *Please use these abbreviations:
 | OG | Olympic Games |  | WC | World Championships
 | YOG | Youth Olympic Games |  | JWC | Junior World Championships
 | CG | Continental Games |  | YWC | Youth World Championships
 | RG | Regional Games |  | WUC | World University Championships
 | U | Universiade |  | CC | Continental Championships
 |  |  |  | RC | Regional Championships
 | Please use computer to complete Form. Also available at http://www.iwf.net/downloads
Spreadsheet: 745905d1630356601-help-with-sumproduct-formula-that-contains-text-and-numbers-over-multiple-tables-t3
Sheet: STAFF ROOMS

HOUSE | TYPE | ROOM | PRICE |  |  |  |  | House | Type | Basement | Ground | 3 | 4 | 5
Compston | Single | 3 |  |  |  |  |  | Compston | Single | 70 | 80 | 90 | 100 | 110
 |  |  |  |  |  |  |  | Compston | Double | 75 | 76 | 77 | 78 | 79
 |  |  |  |  |  |  |  | House | Type | 1 | 2 | 3 | 4 | 5
 |  |  |  |  |  |  |  | Kirkwood | Single | 70 | 80 | 90 | 100 | 110
 |  |  |  |  |  |  |  | Compston | Double | 75 | 76 | 77 | 78 | 79
 |  |  |  |  |  |  |  | House | Type | 1 | 2 | 3 | 4 | 5
 |  |  |  |  |  |  |  | Brinwood | Single | 70 | 80 | 90 | 100 | 110
 |  |  |  |  |  |  |  | Compston | Double | 80 | 90 | 91 | 92 | 93
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Compston | Kirkwood | Brinwood
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Basement | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ground | 2 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 3 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 4 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 5 | 5
Spreadsheet: 725838d1616922356-lookup-first-instance-w-criteria-sample-vlookup-w-criteria
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CIM |  | Result
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FLAT | Desired Result is in Row 46
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Flat |  |  |  | Agnc
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I would like to find the first instance of "Flat" That Matches the Symbol Criteria. In my Case would Be Symbol CIM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Basically Asking formula to:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Open |  |  |  | NLY |  | Look up Symboly CIM in Column AA then if [NAME] in Column W = "Flat" then result should be "Flat" orelse 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | And the formula will eventually be copied down In column AD With last Row Locked
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Flat |  |  |  | CIM |  | In Cell AG39 is the actual formula I am currently using
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thank you:)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Closed |  |  |  | CIM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Flat |  |  |  | FSK
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Open |  |  |  | CIM
Spreadsheet: 709627d1608457742-formulas-required-for-different-options-selected-formula-group-help
Sheet: Sheet1

Sno. | Description |  | Qty |  | Price | Value |  | Sub Option a |  | Sub Option b |  | Sub Option c
1.0 | Item 1 |  | 12345 | sqm
1.1 | Standard Option |  |  | pcs. | 1.16 |  |  | Not Selected |  | Not Selected |  | Not Selected
1.1a | Sub Option a |  |  | pcs. | 1.3 | Not Selected |  |  |  | Not Selected |  | Not Selected
1.1b | Sub Option b |  |  | pcs. | 2.69 | Not Selected |  | Not Selected |  |  |  | Not Selected
1.1c | Sub Option c |  |  | pcs. | 3.69 | Not Selected |  | Not Selected |  | Not Selected
1.2 | [NAME] |  | 1234 | pcs. | 1.17
1.3 | [NAME] |  | 12 | pcs. | 2.2
1.4 | [NAME] |  | 113 | pcs. | 1.89
1.5 | [NAME] |  | 123 | pcs. | 2.81
1.6 | [NAME] |  | 234 | pcs. | 2.93
1.7 | [NAME] |  | 345 | pcs. | 3.35
1.8 | [NAME] |  | 456 | pcs. | 1.12 |  |  |  |  |  |  |  | [NAME]
 |  | Standard |  |  |  |  |  |  |  |  |  |  | If [NAME] is selected then the values will be calculated for G14 i.e =(G3+SUM(Addons))/D2
 |  | Sub Option a |  |  |  |  |  |  |  |  |  |  | If F4 is selected then the values will be calculated for [NAME] i.e =(G4+SUM(Addons))/D2
 |  | Sub Option b |  |  |  |  |  |  |  |  |  |  | If F5 is selected then the values will be calculated for G16 i.e =(G5+SUM(Addons))/D2
 |  | Sub Option c |  |  |  |  |  |  |  |  |  |  | If F6 is selected then the values will be calculated for G17 i.e =(G6+SUM(Addons))/D2
 | Standard Size | 1.12
Spreadsheet: louise_kitchen__22500__Turbine Position Report 071601
Sheet: Summary by Status

Turbine Position Report |  |  |  |  |  |  | CONFIDENTIAL
Summary by Status
($ MMs)
 |  |  |  |  |  | Financial Data as of
UNITS | MODEL | CONTROLLED BY | PROJECT(S) | DASH APPROVAL DATE / STATUS | CONTRACT COST | SCHEDULED CONTRACT PYMTS TO DATE | CANCELLATION COST TO DATE | STATUS
COMMITTED - turbines committed to deals which have been DASHed and financing is in process.
2 | 7EA |  |  |  |  |  |  | Committed
 |  |  | Total Committed
TENTATIVE - turbines tentatively committed to ONE deal which has not yet been DASHed, but is likely to be.
1 | MHI 501F simple cycle |  |  |  |  |  |  | Tentative
1 | 7FA |  |  |  |  |  |  | Tentative
2 | MHI 501F simple cycle |  |  |  |  |  |  | Tentative
 |  |  | Total Tentative
AVAILABLE - turbines which may be potential matches with SEVERAL deals, none of which have been approved to date.
1 | MHI 501F simple cycle |  |  |  |  |  |  | Available
1 | 501D5A simple cycle |  |  |  |  |  |  | Available
3 | 9FA STAG power islands |  |  |  |  |  |  | Available
2 | 11N1 |  |  |  |  |  |  | Available
2 | Fr 6B 60hz power barges (BV=0) |  |  |  |  |  |  | Available
1 | LM6000 |  |  |  |  |  |  | Available
1 | Steam Turbine (BV = 0) |  |  |  |  |  |  | Available
 |  |  | Total Available
NEGOTIATING - turbines for which the purchase is currently being negotiated, but Enron does not yet have control of these turbines.
 |  |  | Total Negotiating
 | UNITS - TOTAL |  | GRAND TOTALS
SCHEDULED VS CANCELLATION PAYMENTS
($ MMs)
*  Total Cancellation Payments = Total Enron Exposure
Spreadsheet: 148131d1333145726-display-the-occurrence-number-of-a-value-in-a-range-that-occurs-on-multiple-sheets-occurences
Sheet: Jan

 | [NAME] |  |  | Notes: I have a named range called MySheets which incorporates column range B1:B30 on all the sheets.
 | [NAME] |  |  | I'm pretty certain that the INDIRECT formula shown below will be in the final formula and copied down in columns C1:C30 on all sheets.
 | [NAME] |  |  | (INDIRECT("'"&MySheets&"'!B1:B30"),B1)
 | [NAME]
 | [NAME] |  |  | Looking for a formula to get the occurrence # of each value in Column B with the result in column C.
 | [NAME]
 | [NAME] |  |  | Notice how the occurrence numbers keep increasing from Jan to Feb. This is what I would like to achieve.
 | [NAME]
 | [NAME] |  |  | Months Mar thru Dec are left blank for simplicity.
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
Spreadsheet: 878602d1725725797-only-show-row-with-the-first-cell-number-in-a-column-example
Sheet: Ark1

Agent ID | Name | In
1 | [NAME] | 07:59:01
1 | [NAME] | 09:27:35
1 | [NAME] | 10:47:32
1 | [NAME] | 12:33:12
2 | [NAME] | 07:58:11
2 | [NAME] | 12:01:21
3 | [NAME] | 07:59:23
3 | [NAME] | 09:15:26
3 | [NAME] | 12:04:43
3 | [NAME] | 14:56:42
4 | Lucas Westh | 08:12:21
4 | Lucas Westh | 12:38:53
Agent ID | Name | In
1 | [NAME] | 07:59:01
2 | [NAME] | 07:58:11
3 | [NAME] | 07:59:23
4 | Lucas Westh | 08:12:21
Spreadsheet: 114951d1310610389-vlookup-in-two-or-more-columns-sampleedit
Sheet: Sheet1

SKU | BarCode | Description | store Cost | Retail Price |  |  | Search | Description | Store Cost | Retail Price
A12345 | 4011K00005 | Product A | 33 | 63 |  | SKU | A12345
AA2255 | 40W3850005 | Product B | 24 | 54 |  | BarCode | 40W3850005
BSE3548 | 40U7400005 | Produc C | 22 | 52
ASS55887 | [PHONE] | Product D | 34 | 64
Spreadsheet: f60ab0be-5db2-40ea-ad8a-7fc60e1a5b5c
Sheet: Sheet1

Release: House Price Index | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=171
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-07-28 5:54 PM CDT
 | Real-Time | Period
Name: | Start | End
House Price Index | 2008-05-22 00:00:00 | Current
Link:
http://www.fhfa.gov/DataTools/Downloads/Pages/House-Price-Index.aspx | 2008-05-22 00:00:00 | Current
Source:
Federal Housing Finance Agency | 2008-05-22 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2008-05-22 00:00:00
2008-08-26 00:00:00
2008-11-25 00:00:00
2009-02-24 00:00:00
2009-05-27 00:00:00
2009-08-25 00:00:00
2009-11-24 00:00:00
2010-02-25 00:00:00
2010-05-25 00:00:00
2010-08-25 00:00:00
2010-11-24 00:00:00
2011-02-24 00:00:00
2011-05-25 00:00:00
2011-08-24 00:00:00
2011-11-29 00:00:00
2012-02-23 00:00:00
2012-05-23 00:00:00
2012-06-21 00:00:00
2012-07-24 00:00:00
2012-08-23 00:00:00
2012-09-25 00:00:00
2012-10-24 00:00:00
2012-11-27 00:00:00
2012-12-20 00:00:00
2013-01-23 00:00:00
2013-02-26 00:00:00
2013-03-21 00:00:00
2013-04-23 00:00:00
2013-05-23 00:00:00
2013-06-25 00:00:00
2013-07-23 00:00:00
2013-08-22 00:00:00
2013-09-24 00:00:00
2013-10-23 00:00:00
2013-11-26 00:00:00
2013-12-24 00:00:00
2014-01-23 00:00:00
2014-02-25 00:00:00
2014-03-25 00:00:00
2014-04-22 00:00:00
2014-05-27 00:00:00
2014-06-24 00:00:00
2014-07-22 00:00:00
Spreadsheet: 717576d1612748658-formula-to-sum-between-two-values-samplea
Sheet: Sheet1

a | b | c
6 | 6 | 5006 | Reset
6 | 12 | 5012 | Reset
6 | 18 | 5018 | Reset
6 | 24 | 5024 | Reset
6 | 30 | 5030 | Reset
-2.790697674418605 | 27.20930232558139 | 5027.209302325581 |  |  | 1 | <--- need to sum col A between all of the "Reset" values, so here there is only one
8.790697674418604 | 36 | 5036 | Reset
6 | 42 | 5042 | Reset
-1.621621621621621 | 40.37837837837838 | 5040.378378378378 |  |  | 1 | <--- need to sum col A between all of the "Reset" values, so here there is only one
7.621621621621621 | 48 | 5048 | Reset
-1.578947368421053 | 46.42105263157895 | 5046.421052631579
-1.848523748395379 | 44.57252888318357 | 5044.572528883184 |  |  | 2 | <--- need to sum col A between all of the "Reset" values, so here there are two
9.427471116816433 | 54 | 5054 | Reset
-5.88235294117647 | 48.11764705882353 | 5048.117647058823
-3.394957983193277 | 44.72268907563025 | 5044.72268907563
-10.32250738133091 | 34.40018169429933 | 5034.400181694299 |  |  | 3 | <--- need to sum col A between all of the "Reset" values, so here there are three
25.59981830570066 | 59.99999999999999 | 5060 | Reset
6 | 66 | 5066 | Reset
-2.857142857142857 | 63.14285714285715 | 5063.142857142857 |  |  | 1 | <--- need to sum col A between all of the "Reset" values, so here there is only one
8.857142857142858 | 72 | 5072 | Reset
6 | 78 | 5078 | Reset
-1.621621621621621 | 76.37837837837837 | 5076.378378378378
-4.330466830466831 | 72.04791154791154 | 5072.047911547911
-7.114338364338363 | 64.93357318357317 | 5064.933573183573
-3.891107513556493 | 61.04246567001668 | 5061.042465670016
-5.101674295551846 | 55.94079137446484 | 5055.940791374464
-7.384002269877672 | 48.55678910458717 | 5048.556789104587
-16.48521436995945 | 32.07157473462772 | 5032.071574734628 |  |  | 7 | <--- need to sum col A between all of the "Reset" values, so here there are seven
51.92842526537228 | 84 | 5084 | Reset
-1.714285714285714 | 82.28571428571429 | 5082.285714285715 |  |  | 1 | <--- need to sum col A between all of the "Reset" values, so here there is only one
7.714285714285714 | 90 | 5090 | Reset