tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 709593d1608427649-compare-to-cells-bouwcenter-poule-f1-2021-v1
Sheet: Uitstlagen

[NAME] F1 2021
Race 1: 21-03 Australia GP, Melbourne |  |  |  |  | Actual | Race 2: 28-03 Bahrain GP, Sakhir |  |  |  |  | Race 3: 11-04 ChinaGP, Shanghai |  |  |  |  | Race 4: 25-04, TBC
58 Laps |  |  |  |  |  | 57 Laps |  |  |  |  | 56 Laps |  |  |  |  | xx Laps
Pole Position | 44 - [NAME], Mercedes |  |  |  |  | Pole Position |  |  |  |  | Pole Position |  |  |  |  | Pole Position
Snelste ronden | 44 - [NAME], Mercedes |  |  |  |  | Snelste ronden |  |  |  |  | Snelste ronden |  |  |  |  | Snelste ronden
Snelste Pitstop | 55 - [NAME], Ferrari |  |  |  |  | Snelste Pitstop |  |  |  |  | Snelste Pitstop |  |  |  |  | Snelste Pitstop
Eerste uitvaller | 11 - Sergio Perez, Red Bull-Honda |  |  |  |  | Eerste uitvaller |  |  |  |  | Eerste uitvaller |  |  |  |  | Eerste uitvaller
Best of the rest | 4 - Lando Norris, [NAME] |  |  |  |  | Best of the rest |  |  |  |  | Best of the rest |  |  |  |  | Best of the rest
1 | 16 - [NAME], Ferrari |  |  |  |  | 1 |  |  |  |  | 1 |  |  |  |  | 1
2 | 55 - [NAME], Ferrari |  |  |  |  | 2 |  |  |  |  | 2 |  |  |  |  | 2
3 | 77 - Valtteri Bottas, Mercedes |  |  |  |  | 3 |  |  |  |  | 3 |  |  |  |  | 3
4 | 33 - Max Verstappen, Red Bull-Honda |  |  |  |  | 4 |  |  |  |  | 4 |  |  |  |  | 4
5 | 44 - [NAME], Mercedes |  |  |  |  | 5 |  |  |  |  | 5 |  |  |  |  | 5
6 | 14 - Fernado Alonso, [NAME] |  |  |  |  | 6 |  |  |  |  | 6 |  |  |  |  | 6
7 | 18 - Lance Stroll, [NAME] |  |  |  |  | 7 |  |  |  |  | 7 |  |  |  |  | 7
8 | 5 - Sebastian Vettel, [NAME] |  |  |  |  | 8 |  |  |  |  | 8 |  |  |  |  | 8
9 | 63 - [NAME], Williams-Mercedes |  |  |  |  | 9 |  |  |  |  | 9 |  |  |  |  | 9
10 | 31 - Esteban Ocon, Alpine-Renault |  |  |  |  | 10 |  |  |  |  | 10 |  |  |  |  | 10
Spreadsheet: 48d1d5f6-4487-40ee-9e29-6d7131e84bb0
Sheet: Table 5.1

Monthly Statistical Bulletin
5.1 Business interest rates
Month | 2008–09 | 2009–10 | 2010–11 | 2011–12 | 2012–13
Large business interest rate (a) (b) – per cent
September | 8.1 | 5.45 | 6.4 | 6.45 | 5.65
December | 6.300000000000001 | 6 | 6.65 | 6.25 | 5.3
March | 5.350000000000001 | 6.2 | 6.600000000000001 | 6.2 | 5.15
June | 5.350000000000001 | 6.4 | 6.550000000000001 | 5.7 | 4.95
Annual average | 6.275 | 6.012499999999999 | 6.550000000000001 | 6.149999999999999 | 5.2625
Small business interest rate (a) (c) – per cent
September | 10.1 | 7.100000000000001 | 8.25 | 8.5 | 7.7
December | 8.4 | 7.7 | 8.6 | 8.15 | 7.2
March | 7.2 | 8.05 | 8.55 | 8.2 | 7.15
June | 7.15 | 8.25 | 8.55 | 7.75 | 7.050000000000001
Annual average | 8.2125 | 7.775 | 8.4875 | 8.149999999999999 | 7.275
(a) The data are weighted average rates, which are calculated from outstanding credit
facilities held by businesses at different interest rates with different maturities.
(b) A large business loan is defined as being $2 million or more.
(c) A small business loan is defined as being less than $2 million.
Source: RBA website statistical table F5 | http://www.rba.gov.au/PublicationsAndResearch/Bulletin/2008/index.html
 |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | 2014-01-02 00:00:00
Spreadsheet: 181444d1348046858-sumif-help-please-sample
Sheet: Table

 | 2013
Description | 2011-01-31 00:00:00 | 2011-02-28 00:00:00 | 2011-03-31 00:00:00 | 2011-04-30 00:00:00 | 2011-05-31 00:00:00 | 2011-06-30 00:00:00 | 2011-07-31 00:00:00 | 2011-08-31 00:00:00 | 2011-09-30 00:00:00 | 2011-10-31 00:00:00 | 2011-11-30 00:00:00 | 2011-12-31 00:00:00 | Total
Digita Software Sales |  |  |  |  |  |  |  |  |  |  |  |  | 0
L Other Online |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] | 0
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Margeret
Johnm
Spreadsheet: 218022d1362304354-referencing-cells-from-a-master-sheet-master-schedule-test-nhopkins-oeldere-
Sheet: TimeSheetsWk1

FOH TIME SHEET
Employee
 | Scheduled |  | Worked - if different |  | Hours |  | Comments | Manager
Employee
 | Scheduled |  | Worked - if different |  | Hours |  | Comments | Manager
PLEASE NOTE ANY AND ALL CHANGES IN SCHEDULED HOURS MUST BE MANAGER [NAME] AND [NAME]
FOH TIME SHEET
Employee
 | Scheduled |  | Worked - if different |  | Hours |  | Comments | Manager
Employee
 | Scheduled |  | Worked - if different |  | Hours |  | Comments | Manager
PLEASE NOTE ANY AND ALL CHANGES IN SCHEDULED HOURS MUST BE MANAGER [NAME] AND [NAME]
FOH TIME SHEET
Employee
 | Scheduled |  | Worked - if different |  | Hours |  | Comments | Manager
Employee
 | Scheduled |  | Worked - if different |  | Hours |  | Comments | Manager
PLEASE NOTE ANY AND ALL CHANGES IN SCHEDULED HOURS MUST BE MANAGER [NAME] AND [NAME]
FOH TIME SHEET
Employee
 | Scheduled |  | Worked - if different |  | Hours |  | Comments | Manager
PLEASE NOTE ANY AND ALL CHANGES IN SCHEDULED HOURS MUST BE MANAGER [NAME] AND [NAME]
Spreadsheet: 266206d1379528251-excel-formula-needed-to-select-last-four-fields-excelforum
Sheet: Sheet1

3Q12 |  | 4Q12 |  | 1Q13 |  | 2Q13 |  | Sums/Avg of Last Four Qtrs
4 | 5 | 5 | 5 | 6 | 9 | 2 | 15
formulas:
=A2/B2 |  | =C2/D2 |  | =E2/F2 |  | =G2/H2 |  | =I2/J2
4 | 5 | 5 | 5 | 6 | 9 | 2 | 15 | =sum(A3,C3,E3,G3) | =sum(B3,D3,F3,H3)
Spreadsheet: 735919d1623257589-merge-workbooks-based-on-both-column-and-row-merge-sample-data
Sheet: Sheet1

Workbook 1
 | col1 | [NAME] | col4
row1 | x |  | x
row2 |  | x
row3 |  |  | x
WorkBook2
 | col1 | [NAME] | col3
row1 |  | x | x
row2 |  | x | x
Workbook3
 | col1 | [NAME] | col3 | col4
row1 | book1 | book2 | book2 | book1
row2 |  | both | book2
row3 |  |  |  | book1
Spreadsheet: af9c239a-876c-4563-8375-219c8a9d72c5
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
HCYSP | Test | HCYSP | Homocysteine, Total, Plasma | Homocysteine, Total, P | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) Stable Isotope Dilution Analysis | EDTA (lavender-top) tube: EDTA OR |  |  | 0.4 | mL | Container/Tube: Lavender top (EDTA) or plasma gel (EDTA) [NAME]: 0.4 mL Collection Instructions:  1. Fasting (12 hours, preferred but not required) 2. Immediately place specimen on wet ice.  3. Spin down and separate plasma from cells within 4 hours of draw. 4. Alternatively, if blood is not immediately placed on ice, plasma must be removed from cells within 1 hour of draw. | 0.15 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm Reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	NA | Adults: < or =13 mcmol/L Reference values apply to fasting specimens only. | Monday through Friday; 2 p.m. | 2 days (not reported Sundays) | 5 days | 1 | 83090 |  |  |  |  | Rochester
HCYSP | [NAME] | PLEDTA | [NAME] |  |  |  | Refrigerated
HCYSP | Result | 80379 | Homocysteine, Total, P | Homocysteine, Total, P | Numeric |  |  |  |  | mcmol/L |  |  |  |  |  |  |  |  |  | 13965-9 | Homocysteine:SCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 834461d1687851854-formula-to-find-outhow-many-different-country-codes-do-i-have-per-customs-number-example_country_codes
Sheet: Tabelle1

 | 1
36069010 | 1
39241000 | 1
39269000 | 1
39269097 | 2
42021250 | 1
42022290 | 1
42023290 | 2
42029180 | 2
42029219 | 1
42029291 | 4
42029298 | 3
44199000 | 1
56075011 | 1
61091000 | 1
63079098 | 2
68043000 | 1
73158900 | 1
82032000 | 1
82055100 | 2
82079099 | 1
82111000 | 1
82119100 | 1
82119200 | 2
82119300 | 1
82130000 | 2
82142000 | 3
82159910 | 3
91021100 | 1
95030095 | 1
Spreadsheet: 0c103ab1-21be-4d98-b3a4-aeb738771fbd
Sheet: Sheet1

CLAIMANT: | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 |  | Unnamed: 8 | DATE: | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
ADDRESS:
TELEPHONE:
BIRTHDATE:
SS. NO:
SOURCES FROM ALL HOUSEHOLD INCOME:
1 |  |  |  |  |  |  | $
2 |  |  |  |  |  |  | $
3 |  |  |  |  |  |  | $
4 |  |  |  |  |  |  | $
 |  |  |  |  |  | GRAND TOTAL OF INCOME |  |  | $
REFUND QUALIFICATIONS |  | TOTAL INCOME FROM ALL SOURCES MUST BE LESS THAN $16,000  @ 62 YEARS OF AGE |  |  |  |  |  |  |  |  |  |  | LESS THAN $7,500 @ 65 YEARS OF AGE
MONTH/YR |  | GAS | ELECTRIC | CABLE | WATER | TELEPHONE | OTHER | OTHER | OTHER | OTHER | OTHER |  | SEWER FEES
2010-07-01 00:00:00
2010-08-01 00:00:00
2010-09-01 00:00:00
2010-10-01 00:00:00
2010-11-01 00:00:00
2010-12-01 00:00:00
2011-01-01 00:00:00
2011-02-01 00:00:00
2011-03-01 00:00:00
2011-04-01 00:00:00
2011-05-01 00:00:00
2011-06-01 00:00:00
COLUMN TOTALS
 |  |  |  |  |  |  |  |  |  |  | GRAND TOTAL OF REFUND CLAIM |  | $
I HEREBY DECLARE UNDER THE  PENALTY OF PERJURY THAT ALL INFORMATION SUBMITTED IS TRUE AND CORRECT.
SIGNATURE:
SIGNATURE:
Spreadsheet: 767290d1644397009-merge-two-sheets-in-a-third-one-multiple-sheets-combine-aligw
Sheet: A+B

title1 | title2 | title3 |  | what i need to have
b | 2 | green
c | 3 | yellow
d | 4 | blue
e | 5 | white
f | 6 | black
g | 7 | yellow
h | 8 | red
Spreadsheet: kimberly_watson__20556__imbalsumm0109
Sheet: NNG

NNG
 | Measured | Scheduled | Imbalance
1635 | -80014
3531 | -78768 | -37608
60667 | -20079
60749 | 94646 | -41449
61206
61334
62960
INDEX
2001-08-31 00:00:00 |  |  | 371897
2001-09-03 00:00:00
CBS Volume
 |  |  | -39871
Spreadsheet: 679214d1590257815-help-need-on-date-function-date-function
Sheet: Sheet1

 |  |  | Target Month | 2020-09-01 00:00:00
 |  |  |  | As Is
 | Sr.No | Task Name | Frequency | To be Started by | To be completed by | Status |  |  |  | Holiday Calendar
 | 1 | Task 1 | Monthly | 1st business day of every month | 5th Business day of every month | Completed
 | 2 | Task 2 | Monthly | 8th busness day before the end of month | 8th busness day before the end of month | In Progress |  |  |  | 2020-04-17 00:00:00
 | 3 | Task 3 | Quarterly | 3 biz days before end of Mar/Jun/Sep/Dec | Last biz day of Mar/Jun/Sep/Dec | Not Required |  |  |  | 2020-04-27 00:00:00
 | 4 | Task 4 | Quarterly | 1st biz day of Jan/April/July/Oct | 15th biz day of Jan/April/July/Oct | Not Required |  |  |  | 2020-05-04 00:00:00
 | 5 | Task 5 | Half-Yearly | 1st biz day of Feb/Aug | Last biz day of Feb/Aug | Not Started |  |  |  | 2020-05-05 00:00:00
 | 6 | Task 6 | Half-Yearly | 10th biz day of May/Aug | End of June/Sept | Not Started |  |  |  | 2020-05-29 00:00:00
 | 7 | Task 7 | Yearly | 10th biz day of Oct | End of Nov | Not Started |  |  |  | 2020-06-15 00:00:00
 |  |  |  |  |  |  |  |  |  | 2020-07-28 00:00:00
 |  |  |  | To be |  |  |  |  |  | 2020-08-15 00:00:00
 | Sr.No | Task Name | Frequency | Start Date | End Date | Status |  |  |  | 2020-08-17 00:00:00
 | 1 | Task 1 | Monthly |  |  | Completed
 | 2 | Task 2 | Monthly |  |  | In Progress
 | 3 | Task 3 | Quarterly |  |  | Not Required
 | 4 | Task 4 | Quarterly |  |  | Not Required |  |  |  | Calendar
 | 5 | Task 5 | Half-Yearly |  |  | Not Started |  |  |  | QSet1 | QSet2
 | 6 | Task 6 | Half-Yearly |  |  | Not Started |  |  |  | 1 | 3
 | 7 | Task 7 | Yearly |  |  | Not Started |  |  |  | 4 | 6
 | Example 1 |  |  |  |  |  |  |  |  | 7 | 9
 |  |  |  |  |  |  |  |  |  | 10 | 12
 | Target Month |  | 2020-05-23 00:00:00 |  |  |  |  |  |  | HSet1
 | 6 | Task 6 | Half-Yearly |  |  | In Progress |  |  |  | 5
 |  |  |  |  |  |  |  |  |  | 8
 | Target Month |  | 2020-06-01 00:00:00
 | 6 | Task 6 | Half-Yearly |  |  | In Progress
 | Target Month |  | 2020-05-23 00:00:00
 | 6 | Task 6 | Half-Yearly | 2020-05-18 00:00:00 | 2020-06-30 00:00:00 | In progress
 | Target Month |  | 2020-06-01 00:00:00
 | 6 | Task 6 | Half-Yearly | 2020-05-18 00:00:00 | 2020-06-30 00:00:00 | In progress
Spreadsheet: kay_mann__19195__Asset Schedule
Sheet: Asset Schedule

CPU UNITS
 |  | Unit 9 | Unit 8/6 | Unit 7
Unit Type |  | STAG Combined Cycle | Simple Cycle/CC | Conventional 400lb Steam
Min Capacity |  | 12 | 5/8 | 4
[NAME] |  | 22 | 12.7/6.8 | 7.5
Min Heat Rate |  | 12500 | 21,000/13,100
[NAME] |  | 11500 | 17,300/11,900 | 19500
Preferred Min Run Time |  | 16 | 16 | 120
Acceptable Min Run Time |  | 12 | 12 | 60
Min Off Time
Cold Start Time |  | 2 | 3 | 12
Warm Start Time |  | 1 | 2 | 8
Hot Start Time |  | 0.5 | 1 | 2
[NAME]/min |  | 2 | 1.5 | 0.5
Weekly Starts |  | 7 | 5 | 1
Monthly Starts |  | 28 | 20 | 4
Yearly Starts |  | 96 | 48 | 20
Start Costs
VOM |  | 2 | 2 | 2
Dual Fuel? |  | Yes | Yes | No
2nd Fuel |  | LS #2 | LS #2 | --
Dual Fuel Heat Rate |  |  |  | --
Dual Fuel VOM |  | 2 | 2 | --
Yazoo City UNITS
 |  | Unit # CT1 | Unit # ST2 | Unit # ST3 | Unit # [NAME] | TOTAL
Unit Type |  | SIMPLE CYCLE | 400 LB STEAM | 600 LB STEAM | COMBINED CYCLE | SYSTEM
Min Capacity |  | 3 | 2 | 6 | 15
[NAME] |  | 14.5 | 5 | 12 | 23 | 32
Min Heat Rate |  | ? | ? | ? | 12000
[NAME] |  | 17000 | 16000 | 15000 | 10700 | 12000
Preferred Min Run Time |  |  | 16 | 120 | 16
Acceptable Min Run Time |  |  | 12 | 60 | 12
Min Off Time
Cold Start Time |  | 0.17 | 1 | 6 | .17/2.00
Warm Start Time |  | 0.17 | 0.5 | 1 | .17/.50
Hot Start Time |  | 0.17 | 0.1 | 0.5 | .17/.10
[NAME]/min |  | 2 | 1 | 1 | 2.00/1.00
Weekly Starts |  | 14 | 7 | 1 | 7
Monthly Starts |  | 31 | 31 | 4 | 31
Yearly Starts
Start Costs
VOM |  | 2 | 2 | 2 | 2
Dual Fuel? |  | YES | NO | NO | YES
2nd Fuel |  | LS #2 |  |  | LS #2
Dual Fuel Heat Rate
Dual Fuel VOM |  | 2 |  |  | 2
HRSG is rated at 95,000 lbs./hr and conventional boiler is rated at 120,000 lbs./hr. The two steam turbines are supplied from a common header
off these two boilers. ST2 can not be operated by its self.
Spreadsheet: eric_saibi__9736__011102
Sheet: Moss Landing 06

Owner Name | Duke Energy Moss Landing LLC
Station Name | Moss Landing
Unit Name | Unit 06
NERC Region | WSCC
State | CA
Fuel Type | Natural Gas
Capacity | 750 MW
Start Date | 2002-01-11 00:00:00
End Date | 2002-01-13 00:00:00
Comments | Turbine Problems
SIC | 4931
Plant ID | 1011212
Unit ID | 1005366
Outage ID | 19452
Spreadsheet: 811271d1672389328-sumif-formula-lookup-two-dimensions-and-sumif-based-on-date-range-example-movers
Sheet: Sheet1

RAW DATA | Date of Sale | SKU | Colour | Units Sold |  | WEEK OUTPUT NEEDED |  |  | SKU | Colour | Units Sold
 | 2022-01-01 00:00:00 | SKU030 |  | 5 |  | 2022-01-03 00:00:00 | 2022-01-09 00:00:00 |  |  | Red
 | 2022-01-02 00:00:00 | SKU019 |  | 6 |  |  |  |  |  | White
 | 2022-01-03 00:00:00 | SKU042 |  | 9 |  |  |  |  |  | Black
 | 2022-01-04 00:00:00 | SKU035 |  | 3 |  |  |  |  |  | Black
 | 2022-01-05 00:00:00 | SKU036 |  | 2 |  |  |  |  |  | Black
 | 2022-01-06 00:00:00 | SKU030 |  | 1
 | 2022-01-07 00:00:00 | SKU019 |  | 19
 | 2022-01-08 00:00:00 | SKU042 |  | 4
 | 2022-01-09 00:00:00 | SKU035 |  | 2
 | 2022-01-10 00:00:00 | SKU036 |  | 0
 | 2022-01-11 00:00:00 | SKU030 |  | 2
 | 2022-01-12 00:00:00 | SKU019 |  | 1
 | 2022-01-13 00:00:00 | SKU042 |  | 4
 | 2022-01-14 00:00:00 | SKU035 |  | 5
 | 2022-01-15 00:00:00 | SKU036 |  | 6
Spreadsheet: 027a8cf1-a07d-463f-aefd-8e46d5e80600
Sheet: Sheet1

COURSE TITLE | NO | PROFESSOR | EXAM DATE | EXAM TIME | EXAM ROOM
REAL ESTATE TRANSACTIONS | 760 | BARROS | 2013-07-17 00:00:00 | 6:00 - 9:00PM | L204
PROFESSIONAL RESPONSIBILITY | 702 | ROBINETTE | 2014-07-17 00:00:00 | 6:00 - 9:00PM | L202
CONFLICTS | 700 | SEALING | 2014-07-21 00:00:00 | 6:00 - 9:00PM | A170
OPT OUT OF EXAMSOFT DEADLINE - July 9th
DEFERRED EXAM / SPECIAL ACCOMMODATION REQUEST DEADLINE  - July 9th
Spreadsheet: 131199d1322783323-conditional-sumif-across-multiple-pages-with-page-list-dummy-book
Sheet: Sheet1

Name | Travel Team | Home Team | total Bouts | Times at Jammer
Skater 1 | A Team | Home 1 |  | 6
Skater 2 | A Team | Home 2 |  | 10
Skater 3 | B Team | Home 3 |  | 6
Skater 4 | B Team | Home 2 |  | 0
Skater 5 | C Team | Home 1 |  | 2
Spreadsheet: 113667d1309506412-how-to-sort-grouped-data-in-excel-multilevelsort2003
Sheet: Sheet1

Delivery Date | Project | Task | helper
2011-07-02 00:00:00 | Project 9 | Task 49 | 40726Project 9
2011-08-18 00:00:00 | Project 9 | Task 9 | 40726Project 9
2011-09-24 00:00:00 | Project 9 | Task 39 | 40726Project 9
2011-09-28 00:00:00 | Project 9 | Task 29 | 40726Project 9
2011-11-19 00:00:00 | Project 9 | Task 19 | 40726Project 9
2011-07-04 00:00:00 | Project 6 | Task 36 | 40728Project 6
2011-08-13 00:00:00 | Project 6 | Task 16 | 40728Project 6
2011-08-29 00:00:00 | Project 6 | Task 6 | 40728Project 6
2011-10-17 00:00:00 | Project 6 | Task 46 | 40728Project 6
2011-12-12 00:00:00 | Project 6 | Task 26 | 40728Project 6
2011-07-09 00:00:00 | Project 7 | Task 37 | 40733Project 7
2011-09-24 00:00:00 | Project 7 | Task 27 | 40733Project 7
2011-11-24 00:00:00 | Project 7 | Task 47 | 40733Project 7
2011-12-31 00:00:00 | Project 7 | Task 7 | 40733Project 7
2012-01-01 00:00:00 | Project 7 | Task 17 | 40733Project 7
2011-07-15 00:00:00 | Project 8 | Task 48 | 40739Project 8
2011-08-11 00:00:00 | Project 8 | Task 28 | 40739Project 8
2011-08-28 00:00:00 | Project 8 | Task 18 | 40739Project 8
2011-09-16 00:00:00 | Project 8 | Task 8 | 40739Project 8
2012-01-01 00:00:00 | Project 8 | Task 38 | 40739Project 8
2011-07-24 00:00:00 | Project 10 | Task 40 | 40748Project 10
2011-09-04 00:00:00 | Project 10 | Task 10 | 40748Project 10
2011-09-09 00:00:00 | Project 10 | Task 20 | 40748Project 10
2011-10-07 00:00:00 | Project 10 | Task 50 | 40748Project 10
2011-12-19 00:00:00 | Project 10 | Task 30 | 40748Project 10
2011-07-25 00:00:00 | Project 3 | Task 13 | 40749Project 3
2011-07-30 00:00:00 | Project 3 | Task 43 | 40749Project 3
2011-09-30 00:00:00 | Project 3 | Task 3 | 40749Project 3
2011-12-27 00:00:00 | Project 3 | Task 33 | 40749Project 3
2012-01-07 00:00:00 | Project 3 | Task 23 | 40749Project 3
2011-08-30 00:00:00 | Project 2 | Task 12 | 40785Project 2
2011-09-20 00:00:00 | Project 2 | Task 32 | 40785Project 2
2011-09-23 00:00:00 | Project 2 | Task 22 | 40785Project 2
2011-10-31 00:00:00 | Project 2 | Task 2 | 40785Project 2
2011-11-15 00:00:00 | Project 2 | Task 42 | 40785Project 2
2011-09-06 00:00:00 | Project 4 | Task 24 | 40792Project 4
2011-11-05 00:00:00 | Project 4 | Task 44 | 40792Project 4
2011-11-25 00:00:00 | Project 4 | Task 4 | 40792Project 4
2011-12-25 00:00:00 | Project 4 | Task 14 | 40792Project 4
2012-01-07 00:00:00 | Project 4 | Task 34 | 40792Project 4
2011-09-12 00:00:00 | Project 1 | Task 41 | 40798Project 1
2011-10-03 00:00:00 | Project 1 | Task 11 | 40798Project 1
2011-10-29 00:00:00 | Project 1 | Task 21 | 40798Project 1
2011-11-06 00:00:00 | Project 1 | Task 31 | 40798Project 1
2011-11-29 00:00:00 | Project 1 | Task 1 | 40798Project 1
2011-10-14 00:00:00 | Project 5 | Task 45 | 40830Project 5
2011-10-19 00:00:00 | Project 5 | Task 15 | 40830Project 5
2011-10-28 00:00:00 | Project 5 | Task 5 | 40830Project 5
2011-11-20 00:00:00 | Project 5 | Task 35 | 40830Project 5
2012-01-09 00:00:00 | Project 5 | Task 25 | 40830Project 5
Spreadsheet: 793667d1661621868-generate-a-list-of-a-filtered-dataset-generatelists-aligw
Sheet: GenerateLists

Name | Put/Call | Strike | Amount
A29 | P | 700 | 4
AEX | P | 725 | -10
A29 | P | 713 | -1
A29 | P | 718 | 3
A29 | C | 722 | -3
A29 | C | 718 | 8
A29 | C | 720 | 3
A29 | C | 716 | -5
A29 | P | 712 | 1
A29 | P | 717 | -3
A29 | P | 716 | -5
AEX | P | 710 | -4
AEX | C | 700 | -2
AEX | P | 700 | 3
AEX | C | 715 | 4
AEX | C | 710 | -4
AEX | P | 705 | 4
AEX | P | 700 | 4
AEX | C | 730 | 5
AEX | P | 720 | 1
AEX | C | 755 | 2
Unique names (extrcted by UNIQUE; there could be more)
AEX
Sorted array on Strike with Amount > 0 for P of each unique name (how can I loop through all and create the following?)
 | P | 718 | 3
A29 | P | 712 | 1
A29 | P | 700 | 4
 | P | 720 | 1
AEX | P | 705 | 4
AEX | P | 700 | 3
AEX | P | 700 | 4
Sorted array on Strike with Amount < 0 for P of each unique name
 | P | 717 | -3
A29 | P | 716 | -5
A29 | P | 713 | -1 |  | Remark: October
 |  |  |  |  | Remark: November
 | P | 725 | -10
AEX | P | 710 | -4
Hoe can I do this?
list to generate for each unique name
A29 | P | 718 |  | 717
A29 | P | 718 |  | 717
A29 | P | 718 |  | 717
A29 | P | 712 |  | 715
A29 | P | 700 |  | 715
A29 | P | 700 |  | 715
A29 | P | 700 |  | 715
A29 | P | 700 |  | 715
A29 | P |  |  | 713
AEX | P | 720 |  | 725
AEX | P | 705 |  | 725
AEX | P | 705 |  | 725
AEX | P | 705 |  | 725
AEX | P | 705 |  | 725
AEX | P | 700 |  | 725
AEX | P | 700 |  | 725
AEX | P | 700 |  | 725
AEX | P | 700 |  | 725
AEX | P | 700 |  | 725
AEX | P | 700 |  | 710
AEX | P |  |  | 710
AEX | P |  |  | 710
Spreadsheet: 1160b714-2cae-4a30-83cf-e6aa682598c6
Sheet: Kec. S Loban

RENCANA UMUM PENGADAAN BARANG/JASA PEMERINTAH
PA/KPA |  | : [NAME], S.Sos
K/L/D/I |  | : Pemerintah [NAME]
SATKER/SKPD |  | : Kantor Camat [NAME]
PPK |  | :
[NAME] |  | : 2012
NO | KEGIATAN |  | SUB KEGIATAN/ PEKERJAAN | NAMA PAKET PEKERJAAN | VOLUME | LOKASI PEKERJAAN (PROVINSI/KAB/KOTA) | RENCANA PENGANGGARAN |  |  | CARA PENGADAAN | PERKIRAAN WAKTU MULAI PELAKSANAAN PENGADAAN ￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼￼ | WAKTU PELAKSANAAN (BULAN) | [NAME]
 |  |  |  |  |  |  | PERKIRAAN BIAYA (RP,-) | [NAME] (APBN/APBD) | RENCANA PEMBIAYAAN
(1) | (2) |  | (3) | (4) | (5) | (6) | (7) | (8) | (9) | (10) | (11) | (12) | (13)
1 | Penyediaan alat tulis kantor |  | Belanja alat tulis kantor | ATK | 26 jenis | [NAME]. [NAME] | 11037700 | APBD |  | Swakelola | 12 Bulan | 12 bulan
2 | Penyediaan barang cetakan dan penggandaan |  | Belanja penggandaan | Fotocopy | 24.000 lbr | [NAME]. [NAME] | 6000000 | APBD |  | Swakelola | 12 Bulan | 12 bulan
3 | Penyediaan peralatan [NAME] kantor |  | Belanja modal mesin sidik [NAME] | Mesin sidik [NAME] | 1 unit | [NAME]. [NAME] | 10000000 | APBD |  | Swakelola | Januari 2012 | 15 hari
4 | Penyediaan peralatan [NAME] kantor |  | Belanja komputer PC | PC | 2 unit | [NAME]. [NAME] | 15000000 | APBD |  | Swakelola | Pebruari 2012 | 15 hari
5 | Penyediaan peralatan [NAME] kantor |  | Belanja modal pengadaan GPS | GPS | 1 unit | [NAME]. [NAME] | 10000000 | APBD |  | Swakelola | Maret 2012 | 15 hari
6 | Penyediaan peralatan [NAME] kantor |  | Belanja modal pengadaan printer | Printer | 2 unit | [NAME]. [NAME] | 1700000 | APBD |  | Swakelola | Maret 2012 | 15 hari
Spreadsheet: holden_salisbury__12289__Deals_Jan
Sheet: Jan 15-21

CounterParty | P.O.D. | MW | Delivery Pattern | Term | $ | Tariff | Currently Delivering? | Enpower Deal #
Nevada Power | Mead 230 | 50 | HLH | thru 4/6/02 | 150 |  | YES | 528030
Nevada Power | Palo Verde | 50 | HLH | thru 4/6/02 | 88.5 |  | YES | 559065
Nevada Power | Palo Verde | 25 | HLH | thru 4/6/02 | 147 |  | YES | 515363
Sierra Pacific | Palo Verde | 25 | HLH | thru 4/6/02 | 101 |  | YES | 498108
Sierra Pacific | Palo Verde | 25 | HLH | thru 4/6/02 | 136 |  | YES | 548872
Sierra Pacific | Palo Verde | 25 | HLH | thru 4/6/02 | 147 |  | YES | 514866
El Paso Electric | Palo Verde | 50 | HLH | thru 4/6/02 | 121 |  | YES | 502431
CRC | Palo Verde | 25 | HLH | thru 4/6/02 | 69 |  | YES | 399966
CRC | Palo Verde | 25 | HLH | thru 4/6/02 | 70 |  | YES | 501436
CRC | Palo Verde | 25 | HLH | thru 4/6/02 | 110 |  | YES | 618755
Nevada Power | Palo Verde | 25 | LLH | thru 4/6/02 | 70 |  | YES | 503214
Nevada Power | Palo Verde | 50 | LLH | thru 4/6/02 | 88.5 |  | YES | 559065
WALC | Pinnacle Peak | 25 | RTC | thru 4/6/02 | 45 |  | YES | 705583
 |  |  |  | BOM $ Requirement |  | Market Price | 1 Week $ Requirement
In the Money Totals | Palo Verde | 150 | HLH |  |  | 23
 | Palo Verde | 125 | HLH |  |  | 23.5
 | Mead 230 | 25 | HLH |  |  | 24
 | Palo Verde | 75 | LLH |  |  | 16
 | Total |  |  |  |  |  |  | Payable to PNM