tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: sally_beck__36204__MgmtSum-Q201-Global-0525
Sheet: GrossMargin

PLAN2000
[NAME] | ENRON GLOBAL MARKETS
2000-12-01 00:00:00 | 2nd QUARTER 2001 DETAIL OF GROSS MARGIN
M.QTD
ENA
 |  |  |  |  |  | Accrual / |  | Actual | Deals | Forecast | Total | Margin
 | Business Team |  | DPR(1) | MPR | Accruals | Other | FTA | Margin | Identified | Margin | Margin | Plan | [NAME]
 | Crude & Products |  | -72938 | 0 | 0 | 0 | 0 |  |  | 0 |  | 32500
COAL | Coal / Emissions |  | -2775 | 232.47763 | 0 | -73.57058 | 0 |  |  | 0
 | Vessel Trading |  | -2622 | 0 | 0 | 0 | 0 |  |  | 0 |  | 2500
SO2 | Emissions |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
WEATHER | Weather |  | 1576 | 0 | 0 | 0 | 0 |  |  | 0
INSURANCE | Global Risk Markets |  | 907 | 0 | 0 | 0 | 0 |  |  | 0 |  | 11875
ECT_INV_IRFX | Equity Trading |  | -7355 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
ECT_INV_IRFX | Convertible Trading |  | 3624 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | FX / Int Rate Trading |  | -994 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Soft Commodities Trading |  | -22 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Grain Trading |  | -27 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Meat Trading |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Financial Trading |  |  |  |  |  |  |  |  |  |  | 27500
 | Freight Markets |  | 84 | 20.37132 | 0 | 0 | 0 |  |  | 0
 | LNG |  | 412 | 0 | 0 | 38 | 0 |  |  | 0 |  | 5000
 | Puerto Rico |  | 0 | 0 | 0 | -1445 | 0 |  |  | 0
 | Finance and Structuring |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Office of the Chairman |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | Overview |  | 0 | 0 | 0 | 0 | 0 |  |  | 0
 | Subtotal Gross Margin
 | Other Interest Related Charges |  | 0 | 0 | 0 | 0 | 0 |  |  | 0 |  | 0
 | EGM Gross Margin
 | (1) Excludes Cap. Charge & Operating Costs
Spreadsheet: 842860d1694850004-sum-up-columns-based-on-specific-dates-amoi42-ans
Sheet: Sheet1

Equipment Code | WO Number | WO Description | WO Priority | WO Status | Odometer | Start Date | Finish date | Total Downtime |  |  | Start Date | Finish Date | Highest Dowtime | WO Description | Expected result
VL1 |  | SAFETY INSPECTION | P3 | Not Shown |  | 2022-04-11 00:00:00 | 2022-04-11 00:00:00 | 0 |  | VL1 | 2022-04-12 00:00:00 | 2022-04-18 00:00:00 | 1 |  | DOOR REPLACE
VL1 |  | DOOR REPLACE | P3 | Completed | 72294 | 2022-04-12 07:30:00 | 2022-04-12 08:30:00 | 0.9999999999417923 |  |  | 2022-05-09 00:00:00 | 2022-05-23 00:00:00 | 3 |  | AC REPAIRS
VL1 |  | HEADLIGHT (BULB) REPLACED | P1 | Completed | 72477 | 2022-04-18 07:20:00 | 2022-04-18 07:50:00 | 0.5000000000582077 |  |  | 2023-01-01 00:00:00 | 2023-09-12 00:00:00 | 6120 |  | ACCIDENT DAMAGE
VL1 |  | SAFETY INSPECTION | P3 | Completed | 72790 | 2022-04-26 07:45:00 | 2022-04-26 09:45:00 | 2
VL1 |  | SAFETY INSPECTION | P3 | Completed | 73223 | 2022-05-09 08:01:00 | 2022-05-09 09:01:00 | 1.000000000116415 |  |  |  |  |  | Results in cell O4 and O5 are not correct.
VL1 |  | AC REPAIRS | P3 | Completed | 73641 | 2022-05-23 13:35:29 | 2022-05-23 16:35:54 | 3
VL1 |  | ACCIDENT DAMAGE | P1 | Waiting Parts |  | 2022-06-05 10:00:00 |  | 10708.77714444447 |  |  | [NAME] used | INDEX($C$2:$C$8, MATCH(MAXIFS($I$2:$I$8,$G$2:$G$8,">=" &L2,$H$2:$H$8,"<=" &M2,$A$2:$A$8,$K$2),$I$2:$I$8, 0))
Spreadsheet: 87b11e61-c2a8-40ed-ad07-4071dda721a8
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
El presente formato para presentación de informes técnico final, apoyar el proceso de evaluación de los compromisos adquiridos en la carta de aprobación del proyecto.    NOTA: Los soportes de los productos que se relacionen en los numerales 2, 3, 4 y 5 de la presente ficha  del informe final deben ser entregados en medio magnético numerados . Los soportes pueden ser:  o Copias de las publicaciones de los resultados de generación de nuevo conocimiento (en revistas científicas, libros o [NAME]) o [NAME] cualquier etapa del proceso de sometimiento a revistas científicas (incluyendo cartas de recepción y/o aceptación por parte de los editores o comités editoriales), los cuales deben estar directamente relacionados con los objetivos del proyecto.  o Copias de registros, patentes o normas, o certificaciones de que éstas están en proceso de solicitud o evaluación.  o Copias de certificaciones de la existencia y calidad de productos o procesos tecnológicos obtenidos como resultado del proyecto. o Copias de los certificados o resúmenes de las ponencias presentadas en eventos. o Copias de otro material divulgativo que se haya producido sobre los resultados [NAME]. o Cualquier otro material que soporte los resultados obtenidos.  NOTA: todos estos productos deberán incluir los créditos respectivos a la Universidad CES.
[NAME] final
Título del proyecto
Código del proyecto
1.  OBJETIVOS
Objetivo específico |  | % de cumplimiento |  | Observaciones
2.  FORMACIÓN DE RECURSO HUMANO
Nombre del estudiante | Programa académico | Actividades realizadas |  | Productos | Observaciones | N° de anexo
3.  PRODUCTOS
Tipo de producto | Estado | [NAME] |  |  |  | N° de anexo
4.  DIVULGACIÓN
Tipo de evento | Nombre del evento | Nombre de la ponencia |  | Lugar | Fecha | N° de anexo
5.  OTROS RESULTADOS
[NAME] |  |  |  |  |  | N° de anexo
Nombre responsable |  |  | Firma responsable
Spreadsheet: 124584d1318485223-list-count-multiply-dummy
Sheet: Template

Name: |  |  |  |  | Month:
Date | Start | End | Hours | Activity
 |  |  | 5.5 | Category 1
 |  |  | 3 | Category 3
 |  |  | 1 | Category 3
 |  |  | 1 | Category 5
 |  |  | 1 | Category 5
 |  |  | 3 | Category 4
 |  |  | 3 | Category 4
 |  |  | 1.5 | Category 1
Total Hours |  |  | 19
 |  |  | Category: | Category | Occurances | Total Hours
 |  |  | 1 | Category 1 | 2
 |  |  | 2 | Category 2 | 0
 |  |  | 3 | Category 3 | 2
 |  |  | 4 | Category 4 | 2
 |  |  | 5 | Category 5 | 2
 |  |  | 6 | Category 6 | 0
 |  |  | 7 | Category 7 | 0
 |  |  | 8 | Category 8 | 0
 |  |  | 9 | Category 9 | 0
 |  |  | 10 | Category 10 | 0
 |  |  | 11 | Category 11 | 0
 |  |  | 12 | Category 12 | 0
 |  |  | 13 | Category 13 | 0
 |  |  | 14 | Category 14 | 0
Spreadsheet: 357530cb-6a4d-41e9-ad56-c0cd3ffe9ad6
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
44292392 | 2014-12-03 21:49:38 | AXIS | 1 | 6 | 0 | 901544 | manu76 | 12496 | eastern | 1942-07-23 | 1942-08-08 | Battle of Kalatch | Bataille de Kalatch
44292651 | 2014-12-03 22:08:05 | ALLIES | 1 | 6 | 4 | 901544 | manu76 | 12496 | eastern | 1942-07-23 | 1942-08-08 | Battle of Kalatch | Bataille de Kalatch
44459013 | 2014-12-15 21:10:55 | AXIS | 0 | 4 | 6 | 1007775 | [NAME] | 12502 | western | 1944-08-12 |  | Forêt d'Ecouves | La forêt d'Écouves
44459370 | 2014-12-15 21:29:32 | ALLIES | 1 | 6 | 2 | 1007775 | [NAME] | 12502 | western | 1944-08-12 |  | Forêt d'Ecouves | La forêt d'Écouves
44460749 | 2014-12-15 23:03:53 | AXIS | 0 | 4 | 6 | 1239735 | Vaillants | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
44461197 | 2014-12-15 23:31:13 | ALLIES | 1 | 6 | 5 | 1239735 | Vaillants | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
44486471 | 2014-12-17 20:55:12 | AXIS | 1 | 6 | 3 | 225841 | sacas | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
Spreadsheet: 51576d1251222355-data-validation-from-table-non-vb-dynamic-data-validation
Sheet: Admin

Department: | ADMIN
Project 1
Title
 | <-- | [NAME]
 | <-- | [NAME]
 | <-- | [NAME]
 | <-- | [NAME]
 | <-- | [NAME]
Project 2
Title
 | <-- | [NAME]
 | <-- | [NAME]
 | <-- | [NAME]
 | <-- | [NAME]
 | <-- | [NAME]
Spreadsheet: 675156d1588177901-a-copy-paste-formula-not-working-metraj
Sheet: Metrajlar

Proje [NAME]
 | Çap(m) | KazıkBoy(m) | [NAME] | Miktar(m) | Beton(m³) | Ø12 | [NAME] |  | Ø14 | Montaj [NAME] |  | Ø22 | Fretaj |  | Ø18 | Z Donatı |  |  | Çap(m) | KazıkBoy(m) | [NAME] | Miktar(m) | Beton(m³) | Ø12 | [NAME] |  | Ø14 | Montaj [NAME] |  | Ø22 | Fretaj |  | Ø18 | Z Donatı
 |  |  |  |  |  | [NAME] | Boy(m) | Demir(ton) | Boy(m) | Aralık(m) | Demir(ton) | Aralık(m) | Çap | [NAME] | Boy | [NAME] | Demir(ton) |  |  |  |  |  |  | [NAME] | Boy(m) | Demir(ton) | Boy(m) | Aralık(m) | Demir(ton) | Aralık(m) | Çap | [NAME] | Boy | [NAME] | Demir(ton)
 | 0.65 | 2 | 2 |  |  | 222 | 2 |  | 222 | 2 |  | 22 | 2 |  | 222 | 22 |  |  | 0.65 | 2 | 2 |  |  | 222 | 2 |  | 222 | 2 |  | 22 | 2 |  | 222 | 22
 |  | Toplam= |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Toplam=
 | Ø | [NAME] 1 |  |  | Ø | [NAME] 2 |  |  | Ø | [NAME] 3 |  |  | Ø | [NAME] 4 |  |  | Başlık Kirişi |  |  |  |  |  | Ankraj
 | Boy(m) | [NAME] | Miktar |  | Boy(m) | [NAME] | Miktar |  | Boy(m) | [NAME] | Miktar |  | Boy(m) | [NAME] | Miktar |  | Boy(m) | Yükseklik(m) | En(m) | [NAME] (m²) | Beton (m³)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Boy(m) | [NAME] | Miktar(m)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ø | [NAME] | Ø | Etriye
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Demir(ton) | Aralık(m) | Boy(m) | [NAME]/ton)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Boy(m) | Yükseklik(m) | En(m) | [NAME] (m²) | Beton (m³)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ø | [NAME] | Ø | Etriye
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Demir(ton) | Aralık(m) | Boy(m) | [NAME]/ton)
 | Toplam |  |  |  | Toplam |  |  |  | Toplam |  |  |  | Toplam
 | [NAME]) |  |  |  | [NAME]) |  |  |  | [NAME]) |  |  |  | [NAME]) |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Boy(m) | Yükseklik(m) | En(m) | [NAME] (m²) | Beton (m³)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ø | [NAME] | Ø | Etriye
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Demir(ton) | Aralık(m) | Boy(m) | [NAME]/ton)
Ø |  |  | FK [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Toplam=
Ø8 | 0.395 |  | FK Montaj Çemberi
Ø10 | 0.617 |  | FK Fretaj
Ø12 | 0.888 |  | FK Z Donatı
Ø14 | 1.21 |  | FK [NAME]
Ø16 | 1.58 |  | FK Montaj Çemberi
Ø18 | 2 |  | FK Fretaj
Ø20 | 2.47 |  | FK Z Donatı
Ø22 | 2.98 |  | [NAME]
Ø24 | 3.551 |  | BK Etriye
[NAME] | 3.85 |  | [NAME]
Ø26 | 4.168 |  | KK Etriye
Ø28 | 4.83 |  | [NAME]
Ø30 | 5.55 |  | KK Etriye 2
Ø32 | 6.31 |  | ZÇ 1
 |  |  | ZÇ 2
 |  |  | ZÇ 3
 |  |  | ZÇ 4
Spreadsheet: 139707d1328399723-random-list-generation-with-criterea-randomlist_daddy
Sheet: Sheet1

Inputs | ODD | EVEN |  | Outputs
1 |  |  |  | 2x ODD |  | 2x EVEN
2
4
6
9
10
11
15
30 |  |  |  | Example of satisfactory result
31 |  |  |  | 9 | 11 | 2 | 4
32 |  |  |  | 1 | 15 | 6 | 10
33 |  |  |  | 31 | 33 | 10 | 30
 |  |  |  | 1 | 31 | 30 | 32
 |  |  |  | 9 | 15 | 4 | 10
Spreadsheet: 142069d1329619249-excel-2010-data-pulling-resident-roster-feb-7-2012
Sheet: Roster Card

Resident Name | [NAME]
Admission Date | 2009-11-03 00:00:00
Diet | Energy Control
Texture | Puree
[NAME] | Nectar
Portion [NAME] | Regular
Nutrition Risk | Moderate
Home Area | Stonehaven
Room # | 261A
Table # | 8
Height(CM) | 155cm
GWR(KG) | 53-67kg
Method of Choice | Visual/Verbal
Interventions | None
Supplements | Prosource 15ml TID
Allergies | NKA
Intolerances | None
Assisted Devices | None
Special Notes | BLUE DOTTED
Breakfast Specials | None
Breakfast Fluids | [NAME]
Lunch Specials | None
[NAME] | Skim
Dinner Specials | None
Dinner Fluids | Skim
Dislikes | None
Spreadsheet: 776314d1649684109-conditional-formating-based-on-cell-value-test-1-etaf
Sheet: CLIENTS

CID | DENOMINATION | PHONE | VAT | FIRST NAME | LAST NAME | ADDRESS | POST | CITY | COUNTRY | [NAME] | WEBSITE | STATUS | LAST BILLED
9
8
7
6
5
4
3
2
1
Spreadsheet: 141457d1329282025-help-i-need-to-add-together-cells-with-a-matching-data-validation-sample
Sheet: Sheet1

Date | Type | Description | Value | Category | Balance
2010-01-04 00:00:00 | POS | '2029 02JAN10 0000 , PAYPAL *ROBERTSCHE, [PHONE] | -185 | Cash Withdrawls | 2659.1
2010-01-04 00:00:00 | D/D | 'HALIFAX | -392.06 | Mortgage | 2267.04
2010-01-04 00:00:00 | D/D | 'O2 | -37.19 | Insurances | 2229.85
2010-01-04 00:00:00 | D/D | 'O2 | -36.83 | Insurances | 2193.02
2010-01-04 00:00:00 | D/D | 'ABBEY MORTGAGE | -804.27 | Mortgage | 1388.75
2010-01-04 00:00:00 | D/D | 'SCOTTISHPOWER GAS | -21 |  | 1367.75
2010-01-04 00:00:00 | D/D | 'GLASGOW-CTAX | -196 |  | 1171.75
2010-01-04 00:00:00 | D/D | 'RBS PERSONAL LOAN | -308.96 | Insurances | 862.79
2010-01-04 00:00:00 | D/D | 'SCGAS-ELECTRICITY | -28 |  | 834.79 |  |  | Total Insurance Costs | ?
2010-01-04 00:00:00 | D/D | 'RBI HOME INSURANCE | -44.54 |  | 790.25 |  |  | Total Mortgage costs | ?
 |  | Need to add the categories together in the boxes to the right
 |  | any help appreciated!
Spreadsheet: 489468d1479277266-database-help-from-database-list-to-nice-looking-list-example-file
Sheet: Sheet1

100 Category | 01 Subcategory | A [NAME] name | Data | Data | Data ...
100 Category | 01 Subcategory | B [NAME] name | Data | Data | Data ...
100 Category | 01 Subcategory | C Item name | Data | Data | Data ...
100 Category | 01 Subcategory | D Item name | Data | Data | Data ...
100 Category | 02 Subcategory | A [NAME] name | Data | Data | Data ...
100 Category | 02 Subcategory | B [NAME] name | Data | Data | Data ...
100 Category | 03 Subcategory | A [NAME] name | Data | Data | Data ...
100 Category | 03 Subcategory | B [NAME] name | Data | Data | Data ...
100 Category | 03 Subcategory | C Item name | Data | Data | Data ...
200 Category | 01 Subcategory | A [NAME] name | Data | Data | Data ...
200 Category | 01 Subcategory | B [NAME] name | Data | Data | Data ...
200 Category | 01 Subcategory | C Item name | Data | Data | Data ...
200 Category | 01 Subcategory | D Item name | Data | Data | Data ...
200 Category | 02 Subcategory | A [NAME] name | Data | Data | Data ...
200 Category | 02 Subcategory | B [NAME] name | Data | Data | Data ...
200 Category | 03 Subcategory | A [NAME] name | Data | Data | Data ...
200 Category | 03 Subcategory | B [NAME] name | Data | Data | Data ...
200 Category | 03 Subcategory | C Item name | Data | Data | Data ...
Spreadsheet: 520a973c-dde0-4ad8-a55c-c5bcc920a9b1
Sheet: Sheet1

Table 8--Wheat: U.S. exports and imports for last 6 months (1,000 bushels), 2/12/2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Item |  | Jun | Jul | Aug | Sep | Oct | Nov
 |  | 2012 | 2012 | 2012 | 2012 | 2012 | 2012
Exports | All wheat grain | 89731.37261877392 | 70377.77155656241 | 97248.6689412 | 92915.3483382789 | 51750.87508381141 | 46512.0493887
 | All wheat flour 1/ | 1263.825520116423 | 1883.098685740204 | 1615.886072095429 | 1790.48626972765 | 1236.396968887244 | 1020.540156181214
 | All wheat products 2/ | 617.8757592016249 | 1064.223300294469 | 630.5064939102352 | 545.6232307236927 | 644.7809153039524 | 641.8423426731335
 | Total all wheat | 91613.07389809197 | 73325.09354259708 | 99495.06150720567 | 95251.45783873025 | 53632.0529680026 | 48174.43188755435
Imports | All wheat grain | 4726.423628526601 | 3406.263346521001 | 10035.1178733687 | 8477.141599059 | 9056.6771613213 | 8179.758924936902
 | All wheat flour 1/ | 793.2286682783292 | 737.023655046667 | 841.0864013899777 | 793.5219590358629 | 881.3723790348241 | 830.5642066315149
 | All wheat products 2/ | 1397.121265980523 | 1580.670109451776 | 1521.875549865195 | 1278.41436829258 | 1614.102198101326 | 1633.713467199341
 | Total all wheat | 6916.773562785454 | 5723.957111019444 | 12398.07982462387 | 10549.07792638744 | 11552.15173845745 | 10644.03659876776
Totals may not add due to rounding. [NAME] in grain-equivalent bushels. Includes meal, groats, and durum. 2/ Expressed in grain-equivalent bushels. Includes bulgur, couscous, and selected categories of pasta. Source: U.S. Department of Commerce, U.S. Census Bureau, Foreign Trade Statistics; and ERS calculations using Census trade statistics.
Date run: 2/11/2013
Spreadsheet: 539642d1506315455-populate-error-message-collection-schedule
Sheet: Schedule

 | # | Organisation Name | Acr Numbers | Day | Time | Duration | Finish | Location | Desk |  |  |  | A
 | 1 | Alpha |  | 1 | 10:00:00 | 06:00:00 |  | A | 2 |  |  |  | October
 | 2 | Delta |  | 1 | 10:00:00 | 03:00:00 |  | A | 1 |  |  |  | Day | 1 |  |  |  | 2 |  |  |  | 3 |  |  |  | 4 |  |  |  | 5
 | 3 | Beta |  | 1 | 10:00:00 | 05:00:00 |  | B | 3 |  |  |  | Desk | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4
 | 4 | Charly |  | 1 | 10:00:00 | 05:00:00 |  | A | 1 |  |  |  | 10:00:00
 | 5 |  |  |  |  |  |  |  |  |  |  |  | 10:30:00
 | 6 |  |  |  |  |  |  |  |  |  |  |  | 11:00:00
 | 7 |  |  |  |  |  |  |  |  |  |  |  | 11:30:00
 | 8 |  |  |  |  |  |  |  |  |  |  |  | 12:00:00
 | 9 |  |  |  |  |  |  |  |  |  |  |  | 12:30:00
 | 10 |  |  |  |  |  |  |  |  |  |  |  | 13:00:00
 | 11 |  |  |  |  |  |  |  |  |  |  |  | 13:30:00
 | 12 |  |  |  |  |  |  |  |  |  |  |  | 14:00:00
 | 13 |  |  |  |  |  |  |  |  |  |  |  | 14:30:00
 | 14 |  |  |  |  |  |  |  |  |  |  |  | 15:00:00
 | 15 |  |  |  |  |  |  |  |  |  |  |  | 15:30:00
 | 16 |  |  |  |  |  |  |  |  |  |  |  | 16:00:00
 | 17 |  |  |  |  |  |  |  |  |  |  |  | 16:30:00
 | 18 |  |  |  |  |  |  |  |  |  |  |  | 17:00:00
 | 19
 | 20
 | 21 |  |  |  |  |  |  |  |  |  |  |  | B
 | 22 |  |  |  |  |  |  |  |  |  |  |  | October
 | 23 |  |  |  |  |  |  |  |  |  |  |  | Day | 1 |  |  |  | 2 |  |  |  | 3 |  |  |  | 4 |  |  |  | 5
 | 24 |  |  |  |  |  |  |  |  |  |  |  | Desk | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4
 | 25 |  |  |  |  |  |  |  |  |  |  |  | 10:00:00
 | 26 |  |  |  |  |  |  |  |  |  |  |  | 10:30:00
 | 27 |  |  |  |  |  |  |  |  |  |  |  | 11:00:00
 | 28 |  |  |  |  |  |  |  |  |  |  |  | 11:30:00
 | 29 |  |  |  |  |  |  |  |  |  |  |  | 12:00:00
 | 30 |  |  |  |  |  |  |  |  |  |  |  | 12:30:00
 | 31 |  |  |  |  |  |  |  |  |  |  |  | 13:00:00
 | 32 |  |  |  |  |  |  |  |  |  |  |  | 13:30:00
 | 33 |  |  |  |  |  |  |  |  |  |  |  | 14:00:00
 | 34 |  |  |  |  |  |  |  |  |  |  |  | 14:30:00
 | 35 |  |  |  |  |  |  |  |  |  |  |  | 15:00:00
 | 36 |  |  |  |  |  |  |  |  |  |  |  | 15:30:00
 | 37 |  |  |  |  |  |  |  |  |  |  |  | 16:00:00
 | 38 |  |  |  |  |  |  |  |  |  |  |  | 16:30:00
 | 39 |  |  |  |  |  |  |  |  |  |  |  | 17:00:00
 | 40
 | 41
 | 42
 | 43
 | 44
 | 45
 | 46
 | 47
 | 48
 | 49
 | 50
 | 51
 | 52
 | 53
 | 54
 | 55
 | 56
 | 57
 | 58
 | 59
 | 60
 | 61
 | 62
 | 63
 | 64
Spreadsheet: john_zufferli__16727__HedgeSummary
Sheet: Sheet1

 | CONFIDENTIAL:  PPA - POWER AND GAS POSITIONS:
 |  |  |  |  |  |  |  |  | Current to | Hedgeable | Current |  | AECO
 |  |  |  |  | Power Price | Aeco Gas Price | Heat Rate | Jan 11/2001 | Beg. Year | Volume | Gas Hedges |  | Hedge
 |  | Power (MWh) | Discount Days | Power (MW) | ($/MWh) | ($[NAME]) | (GJ/MWh) | Heat Rates | HR Delta | (cont/day) | (cont/day) | % Hedged | (cont/day)
2002-01-01 00:00:00 | Cal 2002 |  |  |  |  |  |  | 14.25
2003-01-01 00:00:00 | Cal 2003 |  |  |  |  |  |  | 12.03
2004-01-01 00:00:00 | Cal 2004 |  |  |  |  |  |  | 8.9
2005-01-01 00:00:00 | Cal 2005 |  |  |  |  |  |  | 9.06
2006-01-01 00:00:00 | Cal 2006 |  |  |  |  |  |  | 7.5
2007-01-01 00:00:00 | Cal 2007 |  |  |  |  |  |  | 7.02
2008-01-01 00:00:00 | Cal 2008 |  |  |  |  |  |  | 7.09
2009-01-01 00:00:00 | Cal 2009 |  |  |  |  |  |  | 7.1
2010-01-01 00:00:00 | Cal 2010 |  |  |  |  |  |  | 7.14
2011-01-01 00:00:00 | Cal 2011 |  |  |  |  |  |  | 7.11
2012-01-01 00:00:00 | Cal 2012 |  |  |  |  |  |  | 7.08
2013-01-01 00:00:00 | Cal 2013 |  |  |  |  |  |  | 7.04
2014-01-01 00:00:00 | Cal 2014 |  |  |  |  |  |  | 7.03
2015-01-01 00:00:00 | Cal 2015 |  |  |  |  |  |  | 7
2016-01-01 00:00:00 | Cal 2016 |  |  |  |  |  |  | 7
2017-01-01 00:00:00 | Cal 2017 |  |  |  |  |  |  | 7
2018-01-01 00:00:00 | Cal 2018 |  |  |  |  |  |  | 7
2019-01-01 00:00:00 | Cal 2019 |  |  |  |  |  |  | 7
2020-01-01 00:00:00 | Cal 2020 |  |  |  |  |  |  | 7
 | Total
 | Note: Power position is 710MW * Availability factor (of 81-87%) - 9% transmission losses - hedges
Spreadsheet: 696424d1600802108-three-letter-combination-into-1-to-10-characters-combinabcfx
Sheet: Sheet1

N |  | 1 |  | N |  | Count
A |  | A |  | 10
AA |  | B
AAA |  | C
AAAA
AAAAA
AAAAAA
AAAAAAA
AAAAAAAA
AAAAAAAAA
AAAAAAAAAA
AAAAAAAAAB
AAAAAAAAAC
AAAAAAAAB
AAAAAAAABB
AAAAAAAABC
[NAME]
AAAAAAAACC
AAAAAAAB
AAAAAAABB
AAAAAAABBB
AAAAAAABBC
AAAAAAABC
AAAAAAABCC
AAAAAAAC
[NAME]
AAAAAAACCC
AAAAAAB
AAAAAABB
AAAAAABBB
AAAAAABBBB
[NAME]
AAAAAABBC
AAAAAABBCC
AAAAAABC
AAAAAABCC
AAAAAABCCC
AAAAAAC
AAAAAACC
AAAAAACCC
AAAAAACCCC
AAAAAB
AAAAABB
AAAAABBB
AAAAABBBB
AAAAABBBBB
AAAAABBBBC
AAAAABBBC
AAAAABBBCC
AAAAABBC
AAAAABBCC
AAAAABBCCC
AAAAABC
AAAAABCC
AAAAABCCC
AAAAABCCCC
AAAAAC
AAAAACC
AAAAACCC
AAAAACCCC
AAAAACCCCC
AAAAB
AAAABB
AAAABBB
AAAABBBB
AAAABBBBB
AAAABBBBBB
AAAABBBBBC
AAAABBBBC
AAAABBBBCC
AAAABBBC
AAAABBBCC
AAAABBBCCC
AAAABBC
AAAABBCC
AAAABBCCC
AAAABBCCCC
AAAABC
AAAABCC
AAAABCCC
AAAABCCCC
AAAABCCCCC
AAAAC
AAAACC
AAAACCC
AAAACCCC
AAAACCCCC
AAAACCCCCC
AAAB
AAABB
AAABBB
AAABBBB
AAABBBBB
AAABBBBBB
AAABBBBBBB
AAABBBBBBC
AAABBBBBC
AAABBBBBCC
AAABBBBC
AAABBBBCC
AAABBBBCCC
AAABBBC
AAABBBCC
AAABBBCCC
AAABBBCCCC
AAABBC
AAABBCC
AAABBCCC
AAABBCCCC
AAABBCCCCC
AAABC
AAABCC
AAABCCC
AAABCCCC
AAABCCCCC
AAABCCCCCC
AAAC
AAACC
AAACCC
AAACCCC
AAACCCCC
AAACCCCCC
AAACCCCCCC
AAB
AABB
AABBB
AABBBB
AABBBBB
AABBBBBB
AABBBBBBB
AABBBBBBBB
[NAME]
AABBBBBBC
AABBBBBBCC
AABBBBBC
AABBBBBCC
AABBBBBCCC
AABBBBC
AABBBBCC
AABBBBCCC
AABBBBCCCC
AABBBC
AABBBCC
AABBBCCC
AABBBCCCC
AABBBCCCCC
AABBC
AABBCC
AABBCCC
AABBCCCC
AABBCCCCC
AABBCCCCCC
AABC
AABCC
AABCCC
AABCCCC
AABCCCCC
AABCCCCCC
AABCCCCCCC
AAC
AACC
AACCC
AACCCC
AACCCCC
AACCCCCC
AACCCCCCC
AACCCCCCCC
AB
ABB
ABBB
[NAME]
ABBBBB
ABBBBBB
ABBBBBBB
ABBBBBBBB
ABBBBBBBBB
ABBBBBBBBC
ABBBBBBBC
ABBBBBBBCC
ABBBBBBC
ABBBBBBCC
ABBBBBBCCC
ABBBBBC
ABBBBBCC
ABBBBBCCC
ABBBBBCCCC
ABBBBC
ABBBBCC
ABBBBCCC
ABBBBCCCC
[NAME]
ABBBC
ABBBCC
ABBBCCC
ABBBCCCC
ABBBCCCCC
ABBBCCCCCC
ABBC
ABBCC
ABBCCC
ABBCCCC
ABBCCCCC
ABBCCCCCC
ABBCCCCCCC
ABC
ABCC
ABCCC
ABCCCC
ABCCCCC
ABCCCCCC
ABCCCCCCC
ABCCCCCCCC
AC
ACC
[NAME]
ACCCC
ACCCCC
ACCCCCC
ACCCCCCC
ACCCCCCCC
ACCCCCCCCC
B
BB
BBB
BBBB
BBBBB
BBBBBB
BBBBBBB
BBBBBBBB
BBBBBBBBB
BBBBBBBBBB
BBBBBBBBBC
BBBBBBBBC
BBBBBBBBCC
BBBBBBBC
BBBBBBBCC
BBBBBBBCCC
BBBBBBC
BBBBBBCC
BBBBBBCCC
BBBBBBCCCC
BBBBBC
BBBBBCC
BBBBBCCC
BBBBBCCCC
BBBBBCCCCC
BBBBC
BBBBCC
BBBBCCC
BBBBCCCC
BBBBCCCCC
BBBBCCCCCC
BBBC
BBBCC
BBBCCC
BBBCCCC
BBBCCCCC
BBBCCCCCC
BBBCCCCCCC
BBC
BBCC
BBCCC
[NAME]
BBCCCCC
BBCCCCCC
BBCCCCCCC
BBCCCCCCCC
BC
BCC
BCCC
BCCCC
BCCCCC
BCCCCCC
BCCCCCCC
BCCCCCCCC
BCCCCCCCCC
C
CC
CCC
CCCC
CCCCC
CCCCCC
CCCCCCC
CCCCCCCC
CCCCCCCCC
CCCCCCCCCC