tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 168224d1342325634-can-excel-read-a-number-from-one-field-and-copy-information-into-the-same-number-of-rows-ideal-template
Sheet: Sheet1

Name | [NAME] | [NAME] | [NAME] | [NAME] | Total Hours
Hours | 35 | 30 |  | 35
Volume |  |  |  |  |  |  | [NAME],[NAME],[NAME],[NAME],[NAME], |  | [NAME],[NAME],[NAME],[NAME],[NAME],[NAME],
1st piece of work |  |  | [NAME]
2nd piece of work |  |  | [NAME]
3rd piece of work |  |  | [NAME]
4th piece of work |  |  | [NAME]
5th piece of work |  |  | [NAME]
6th piece of work |  |  | [NAME]
7th piece of work |  |  | [NAME]
8th piece of work |  |  | [NAME]
9th piece of work |  |  | [NAME]
10th piece of work |  |  | [NAME]
11th piece of work |  |  | [NAME]
12th piece of work |  |  | [NAME]
13th piece of work |  |  | [NAME]
14th piece of work |  |  | [NAME]
15th piece of work |  |  | [NAME]
16th piece of work |  |  | [NAME]
17th piece of work |  |  | [NAME]
Total Work Volume
Spreadsheet: daren_farmer__5242__BMSPT051
Sheet: BMSPT066

BAMMEL STORAGE ACTIVITY
VOLUME SPLIT BY Counterparties
2001-05-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | SWING CONTRACT VOLUMES |  |  |  |  | ECT LONG/(SHORT) |  |  |  | LONG/(SHORT)
 |  | HPL INDEX |  |  | HPL FIXED PRICE |  |  |  |  | TOTAL | HL&P | CP&L | TUFCO | TOTAL |  | ECT FIRST OF THE MONTH | TUFCO/ HL&P/ CP&L SWING VOLUME | ECT LONG OR (SHORT) |  | ECT TOTAL | HPLC Excluding 3rd Party | Net LONG/ (SHORT)
 |  | MTD Adjustment | CURRENT DAY | Total | MTD Adjustment | CURRENT DAY | Total | 3rd Party | HPLC Total |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  | Reinject Fees
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Injected Volume | Value
Beginning Balance
1 | Scheduled |  |  |  |  |  |  |  |  |  | 0 | 0
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Scheduled
 | Estimated
 | Estimated
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Index: | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fuel: | 0.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fuel Rate:
Ending Balance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prod.[NAME]:
Variances:
Total Projected
April 28 thru May 4
May 5 thru May 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Previous Position: |  | 3645.999999999825
May 12 thru May 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]:
May 19 thru May 25
Spreadsheet: 110443d1307101081-show-difference-between-2-dates-as-yrs-and-months-yrs-and-months
Sheet: Sheet1

 | Difference between 2 dates shown as Yrs & Months
 | Star Date |  | End Date |  |  |  |  | Required results
Date Format | DD/MM/YYYY |  | DD/MM/YYYY |  | Days | Yrs
 | 2010-05-01 00:00:00 |  | 2011-06-01 00:00:00 |  | 396 | 1.084931506849315 |  | 1 | Yrs | 1 | Mths
 | 1988-11-18 00:00:00 |  | 2011-06-01 00:00:00 |  | 8230 | 22.54794520547945 |  | 22 | Yrs | 7 | Mths
 | 2004-08-10 00:00:00 |  | 2011-06-01 00:00:00 |  | 2486 | 6.810958904109589 |  | 6 | Yrs | 10 | Mths
 | 2001-02-13 00:00:00 |  | 2011-06-01 00:00:00 |  | 3760 | 10.3013698630137 |  | 10 | Yrs | 4 | Mths
Spreadsheet: 771156d1646455574-truncating-text-in-a-cell-but-only-whole-words-copy-of-truncating-names-within-excel-example-workbook
Sheet: Test

Number of Characters
Number of Characters
 | FULL NAME | NAME - Part 1 (35 Characters Limitation) | NAME - Part 2 (35 Characters Limitation)
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
Spreadsheet: 329056d1404187901-trying-to-get-a-lookup-function-to-retrieve-multiple-results-proving-hard-pokemon2
Sheet: Defence&Attack

Attack | Super | Not Very | No Effect | ∑ Attack |  | Defence | Double | Half Damage | No Effect | ∑ Defence
Normal |  |  |  |  |  | Normal
Fighting |  |  |  |  |  | Fighting
Flying |  |  |  |  |  | Flying
Poison |  |  |  |  |  | Poison
Ground |  |  |  |  |  | Ground
Rock |  |  |  |  |  | Rock
Bug |  |  |  |  |  | Bug
Ghost |  |  |  |  |  | Ghost
Steel |  |  |  |  |  | Steel
Fire |  |  |  |  |  | Fire
Water |  |  |  |  |  | Water
Grass |  |  |  |  |  | Grass
Electric |  |  |  |  |  | Electric
Psychic |  |  |  |  |  | Psychic
Ice |  |  |  |  |  | Ice
Dragon |  |  |  |  |  | Dragon
Dark |  |  |  |  |  | Dark
Fairy |  |  |  |  |  | Fairy
Spreadsheet: 862787d1710408229-sum-sumifs-with-multiple-criteria-for-same-column-sample
Sheet: Target

 |  | Calculation
 | Project Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | Total
 | SMART 4DD XL |  |  |  |  |  |  |  |  |  |  |  |  |  | Result should be 280
Spreadsheet: 771613d1646756978-how-will-index-match-work-with-name-range-over-12-sheets-or-with-a-vba-test-greatinfoteam-
Sheet: Jul

July |  |  | Total Profit |  |  |  | Revenue of the Month |  | Total Revenue
Loft Commercial Ltd. |  |  | Tax Rate@ | 0.045 |  |  | Labour of the Month |  | Total Labour
Ethnic by [NAME] |  |  | Tax |  |  |  | Piece of the Month |  | Total No. of Piece
Inv. # | PO No. | Style No. | Qty. | Unit Price | Total | Lab. Rate | Total Labour | Debit Pc's | Debit Cost | Remarks
 | 4600001008 | WTC381287 | 813 | 63 |  | 25
 | 4600001011 | WTB381309 | 300 | 51.5 |  | 25
 | 4600001012 | WTB381309 | 500 | 51.5 |  | 25
 | 4600001013 | WTB381309 | 464 | 51.5 |  | 25
 | 4600001022 | WTR381056 | 500 | 33.9 |  | 15
 | 4600001023 | WTR381056 | 316 | 33.9 |  | 15
 | 4600001043 | [NAME] | 300 | 141.78 |  | 40
 | 4600001044 | [NAME] | 678 | 141.78 |  | 40
Spreadsheet: richard_ring__31525__PECO_Accts_12102001
Sheet: Sheet3

PECO ICAP and TRX Obligations
 | acct | eff_date | strata | icap load | trx load |  | Account No. | [NAME] Obl. | Trx Obl. |  | [NAME] | [NAME]
 | 211661100811 | 2000-01-01 00:00:00 | 1 | 4.98 | 5.44 |  | 211661100811 | 5 | 5
 | 220274106610 | 2000-01-01 00:00:00 | 6 | 80.83 | 88.32 |  | 220274106610 | 76.1 | 76.1
 | 220998040012 | 2000-01-01 00:00:00 | 51 | 2340.26 | 2557.24 |  | 220998040012 | 3259.1 | 3259.1
 | 231172239726 | 2000-01-01 00:00:00 | 6 | 45.64 | 49.87 |  | 231172239726 | 27.3 | 27.3
 | 270258200244 | 2000-01-01 00:00:00 | 5 | 27.29 | 29.82 |  | 270258200244 | 23 | 23
 | 400113041547 | 2000-01-01 00:00:00 | 6 | 64.84 | 70.85 |  | 400113041547 | 51.1 | 51.1
 | 400113042065 | 2000-01-01 00:00:00 | 6 | 42.1 | 46.01 |  | 400113042065 | 44.9 | 44.9
 | 400113240032 | 2000-01-01 00:00:00 | 5 | 27.54 | 30.1 |  | 400113240032 | 24.4 | 24.4
 | 400370048730 | 2000-01-01 00:00:00 | 6 | 354.46 | 387.32 |  | 400370048730 | 260 | 260
 | 400406234528 | 2000-01-01 00:00:00 | 6 | 49.84 | 54.47 |  | 400406234528 | 49.6 | 49.6
 | 400708742517 | 2000-01-01 00:00:00 | 4 | 18.82 | 20.56 |  | 400708742517 | 13 | 13
 | 401493052013 | 2000-01-01 00:00:00 | 6 | 1675.67 | 1831.03 |  | 401493052013 | 1828.8 | 1828.8
 | 401593050016 | 2000-01-01 00:00:00 | 53 | 1890.36 | 2065.62 |  | 401593050016 | 2021.6 | 2021.6
 | 401793200015 | 2000-01-01 00:00:00 | 55 | 737.91 | 806.33 |  | 401793200015 | 769.2 | 769.2
 | 401807426010 | 2000-01-01 00:00:00 | 57 | 484.18 | 529.07 |  | 401807426010 | 415.4 | 415.4
 | 401807426416 | 2000-01-01 00:00:00 | 9 | 2.99 | 3.26 |  | 401807426416 | 2 | 2
 | 401807861018 | 2000-01-01 00:00:00 | 9 | 2.99 | 3.26 |  | 401807861018 | 2 | 2
 | 402195120017 | 2000-01-01 00:00:00 | 53 | 25211.5 | 27549 |  | 402195120017 | 26235 | 26235
 | 451038591512 | 2000-01-01 00:00:00 | 6 | 348.5 | 380.81 |  | 451038591512 | 356 | 356
 | 501012683212 | 2000-01-01 00:00:00 | 3 | 10.34 | 11.3 |  | 501012683212 | 9 | 9
 | 502011678526 | 2000-01-01 00:00:00 | 5 | 17.29 | 18.9 |  | 502011678526 | 19 | 19
Spreadsheet: kate_symes__18211__EESSales_dailymarch
Sheet: 3-5

NP15 | 2001-03-05 00:00:00 |  |  |  |  |  | SP15 |  |  |  |  |  |  | ZP26
Fixed Peak | 311.59 | Fixed Off Peak | 211.5 |  |  |  | Fixed Peak | 298.77 |  | Fixed Off Peak | 209.29 |  |  | Fixed Peak |  |  | Fixed Off Peak
Index Peak |  | Index [NAME] |  |  |  |  | Index Peak |  |  | Index [NAME] |  |  |  | Index Peak |  |  | Index [NAME]
HE | Fixed | Other | DJ Index | Load | var |  | HE | Fixed | Other | DJ Index | Load | var |  | HE | Fixed | Other | DJ Index | Load | var
1 | -4.94 | 0 | 0 | -4.94 |  |  | 1 | -21.77 | 0 |  | -11.77 |  |  | 1 | -1.97 | 0 | 0 | -1.97
2 | -4.17 | 0 | 0 | -4.17 |  |  | 2 | -22.01 | 0 |  | -9.01 |  |  | 2 | -1.95 | 0 | 0 | -1.95
3 | -3.79 | 0 | 0 | -3.79 | 0 |  | 3 | -22.62 | 0 |  | -8.620000000000012 |  |  | 3 | -1.93 | 0 | 0 | -1.93
4 | -3.66 | 0 | 0 | -3.66 |  |  | 4 | -23.09 | 0 |  | -10.09 |  |  | 4 | -1.92 | 0 | 0 | -1.92
5 | -3.9 | 0 | 0 | -3.9 |  |  | 5 | -22.67 | 0 |  | -15.67 |  |  | 5 | -1.94 | 0 | 0 | -1.94
6 | -5.84 | 0 | 0 | -5.84 |  |  | 6 | -20.94 | 0 |  | -13.94 |  |  | 6 | -2.01 | 0 | 0 | -2.01
7 | -9.19 | 0 | 0 | -9.19 |  |  | 7 | -42.55 | 0 |  | -26.55 |  |  | 7 | -2.15 | 0 | 0 | -2.15
8 | -11.72 | 0 | 0 | -11.72 |  |  | 8 | -39.52 | 0 |  | -38.52 |  |  | 8 | -2.26 | 0 | 0 | -2.26
9 | -12.82 | 0 | 0 | -12.82 |  |  | 9 | -38.5 | 0 |  | -48.5 |  |  | 9 | -2.3 | 0 | 0 | -2.3
10 | -12.68 | 0 | 0 | -12.68 |  |  | 10 | -38.37 | 0 |  | -54.37 |  |  | 10 | -2.3 | 0 | 0 | -2.3
11 | -13.09 | 0 | 0 | -13.09 |  |  | 11 | -37.96 | 0 |  | -57.96 |  |  | 11 | -2.32 | 0 | 0 | -2.32
12 | -14.33 | 0 | 0 | -14.33 |  |  | 12 | -36.56 | 0 |  | -59.56 |  |  | 12 | -2.36 | 0 | 0 | -2.36
13 | -14.14 | 0 | 0 | -14.14 |  |  | 13 | -36.72 | 0 |  | -60.72 |  |  | 13 | -2.36 | 0 | 0 | -2.36
14 | -13.88 | 0 | 0 | -13.88 |  |  | 14 | -37.31 | 0 |  | -61.31 |  |  | 14 | -2.35 | 0 | 0 | -2.35
15 | -13.46 | 0 | 0 | -13.46 |  |  | 15 | -38.02 | 0 |  | -60.02 |  |  | 15 | -2.33 | 0 | 0 | -2.33
16 | -13.31 | 0 | 0 | -13.31 |  |  | 16 | -37.79 | 0 |  | -56.79 |  |  | 16 | -2.33 | 0 | 0 | -2.33
17 | -13.67 | 0 | 0 | -13.67 |  |  | 17 | -37.25 | 0 |  | -53.25 |  |  | 17 | -2.34 | 0 | 0 | -2.34
18 | -15.27 | 0 | 0 | -15.27 |  |  | 18 | -35.8 | 0 |  | -54.8 |  |  | 18 | -2.41 | 0 | 0 | -2.41
19 | -17.42 | 0 | 0 | -17.42 |  |  | 19 | -33.84 | 0 |  | -52.84 |  |  | 19 | -2.5 | 0 | 0 | -2.5
20 | -15.66 | 0 | 0 | -15.66 |  |  | 20 | -35.73 | 0 |  | -48.73 |  |  | 20 | -2.43 | 0 | 0 | -2.43
21 | -13.72 | 0 | 0 | -13.72 |  |  | 21 | -37.63 | 0 |  | -43.63 |  |  | 21 | -2.35 | 0 | 0 | -2.35
22 | -11.96 | 0 | 0 | -11.96 |  |  | 22 | -39.13 | 0 |  | -35.13 |  |  | 22 | -2.27 | 0 | 0 | -2.27
23 | -9.55 | 0 | 0 | -9.55 |  |  | 23 | -16.95 | 0 |  | -25.95 |  |  | 23 | -2.17 | 0 | 0 | -2.17
24 | -7.04 | 0 | 0 | -7.04 |  |  | 24 | -19.77 | 0 |  | -8.77000000000001 |  |  | 24 | -2.07 | 0 | 0 | -2.07
Spreadsheet: 109626d1306427492-array-max-if-and-max-if-and
Sheet: Sheet1

 | 20 | 30 | 70 | 90
CUSTOMER A | 1
CUSTOMER A |  |  |  |  |  | CUSTOMER A
CUSTOMER A |  |  |  |  |  | CUSTOMER B
CUSTOMER A |  |  |  |  |  | CUSTOMER C
CUSTOMER A |  |  |  |  |  | CUSTOMER D
CUSTOMER A |  |  |  |  |  | CUSTOMER E
CUSTOMER A
CUSTOMER B
CUSTOMER B
CUSTOMER B
CUSTOMER C |  |  |  |  |  | What I want the above table to look like:
CUSTOMER C
CUSTOMER C |  |  |  |  |  | CUSTOMER A
CUSTOMER C |  |  |  |  |  | CUSTOMER B
CUSTOMER C |  |  |  |  |  | CUSTOMER C
CUSTOMER C |  |  |  |  |  | CUSTOMER D
CUSTOMER D |  |  |  |  |  | CUSTOMER E
CUSTOMER D
CUSTOMER D
CUSTOMER E
CUSTOMER E
CUSTOMER E
CUSTOMER E
CUSTOMER E
CUSTOMER E
Spreadsheet: 141542d1329322292-creating-a-list-using-data-validation-can-i-create-a-subcategory-list-sonepar-technology-team-pos-and-invoices-2012
Sheet: Branch City & ID

OpCo | Cooper Electric | NorthEast Electric | Friedman Electric | World Electric | Capital Tristate | Crawford (CESCO) | [NAME]
Brook | *NEW | *NEW | *NEW | *NEW | *NEW | *NEW | *NEW
Capital Tristate
Cooper Electric
Crawford CESCO
[NAME]
Essco
Friedman Electric
Hagemeyer USA
Irby
NorthEast Electric
Sonepar USA (Corporate)
Sonepar USA ([NAME])
Sonepar USA (Maitland)
Viking Electric
[NAME]
World Electric
Spreadsheet: jay_reitmeyer__13532__ENRON2001
Sheet: 10-01 #7010

 | MPC October 2001 Gas Transportation Invoice
Enron Gas Marketing, Inc
1200 17th Street - Suite 2750
Denver, CO  80202
Attention: [NAME]
Customer ID # 7010
Account # | 100737-6
Interruptible Transportation Charges
 |  | Quantity | Rate | Charge
Commodity Charge |  | 165379 | 0.2
Interruptible Storage Charges
Commodity Charges |  | Quantity | Rate | Charge
Injection Charge |  | 165379 |  | 3355.59
Withdrawal Charge |  | 0 | 0.02
Capacity Charge |  | 1028278 |  | 20532.39
Canadian Montana Pipeline Charge
 |  | Quantity | Rate | Charge
 |  | 0 | 0.008
Total Transportation Invoice
Entered:______________ |  |  | Approved:_______________
Spreadsheet: 741547d1627122994-total-quantity-to-be-calculated-of-the-quantities-of-part-in-the-assembly-total-quantity-to-be-calculated-of-the-quantities-of-part-in-the-assembly-amended-
Sheet: josephteh

https://www.excelforum.com/excel-formulas-and-functions/1355174-total-quantity-to-be-calculated-of-the-quantities-of-part-in-the-assembly.html |  |  |  |  |  |  |  |  |  | Workings
 |  |  |  |  |  |  |  |  |  |  |  |  | Qty | Qty |  | Total | Combined
ITEM.NO | QTY | SAMPLE TOTAL QTY CALC | TOTAL QTY | [NAME] | LENGTH | MATERIAL | PART CATEGORY | PART NUMBER |  | Level 2 | Level 3 | Level 4 | Level 2 | Level 3 | Level 4 | All Level | [NAME]
1 | 1 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 1
1.1 | 1
1.1.1 | 1
1.1.2 | 2
1.1.3 | 2
1.1.4 | 1
1.1.5 | 1
1.2 | 2
1.2.1 | 1
1.2.2 | 1
1.2.3 | 1
1.2.4 | 1
1.3 | 4
1.3.1 | 2
1.3.1.1 | 1
1.3.1.2 | 1
1.3.1.3 | 1
1.3.2 | 1
1.3.3 | 1
1.4 | 2
1.4.1 | 6
1.4.1.1 | 3
1.4.1.2 | 3
1.4.1.3 | 2
1.4.1.4 | 2
1.4.2 | 1
1.4.2.1 | 2
1.4.2.2 | 2
1.4.3 | 4
Spreadsheet: 150735d1334671687-nested-if-statements-multiple-if-example
Sheet: CURRENT (3)

 | Value1 | Value2 |  |  |  |  | Calculation |  |  |  |  |  |  | Cat
 | YYY | Cat |  | 1.53 |  | 200 |  | 0
 | YYY | Cat |  | 1.52 |  | 120 |  | 0 |  |  |  |  | QQQ | 2
 | YYY | Cat |  | 1.6 |  | 2 |  | 0 |  |  |  |  | YYY | 3
 | Cat | QQQ |  | 79.25 | 22 |  |  | 0 |  |  |  |  | Cat | 4
 | Cat | QQQ |  | 79 | 11 |  |  | 0 |  |  |  |  | LLL | 5
 | Cat | QQQ |  | 78.95 | 44 |  |  | 0
 | LLL | YYY |  | 7.65 | 22 |  |  | 0
 | LLL | YYY |  | 7.5905 | 11 | 99 |  | 0 |  |  |  |  | S | 2
 | LLL | YYY |  | 7.45 | 44 | 33 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 1 | S | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | S | 4
Spreadsheet: 179109d1347030505-problem-with-formula-that-displays-contents-from-some-cells-but-not-others-pilotlog-and-techlogtest
Sheet: Tech Log

G-BSGL |  |  |  |  |  |  |  |  | TECHNICAL LOG
 |  |  |  |  |  |  |  |  | [NAME] |  |  |  | Running Total
Date | Pilot | P.O.B. | Nature | Brakes | Take | Landing | Brakes | Flight | Total | Engine
 |  |  | of Flight | Off | Off |  | ON | Time | Time | 2 days, 1:15:00 | Remarks |  | Fuel Uptake
 |  |  |  |  |  |  |  |  |  |  |  |  | 34.15
 |  |  |  |  |  |  |  |  |  |  |  |  | Fuel Uptake
 |  |  |  |  |  |  |  |  |  |  |  |  | Fuel Uptake
 |  |  |  |  |  |  |  |  |  |  |  |  | Fuel Uptake
 |  |  |  |  |  |  |  |  |  |  |  |  | Fuel Uptake
G-BSGL |  |  |  |  |  |  |  |  | TECHNICAL LOG
 |  |  |  |  |  |  |  |  | [NAME]
Date | Pilot | P.O.B. | Nature | Brakes | Take | Landing | Brakes | Flight | Total | Engine |  |  | Fuel Uptake
 |  |  | of Flight | Off | Off |  | ON | Time | Time |  | Remarks
G-BSGL |  |  |  |  |  |  |  |  | TECHNICAL LOG
 |  |  |  |  |  |  |  |  | [NAME]
Date | Pilot | P.O.B. | Nature | Brakes | Take | Landing | Brakes | Flight | Total | Engine |  |  | Fuel Uptake
 |  |  | of Flight | Off | Off |  | ON | Time | Time |  | Remarks
G-BSGL |  |  |  |  |  |  |  |  | TECHNICAL LOG
 |  |  |  |  |  |  |  |  | [NAME]
Date | Pilot | P.O.B. | Nature | Brakes | Take | Landing | Brakes | Flight | Total | Engine |  |  | Fuel Uptake
 |  |  | of Flight | Off | Off |  | ON | Time | Time |  | Remarks
G-BSGL |  |  |  |  |  |  |  |  | TECHNICAL LOG
 |  |  |  |  |  |  |  |  | [NAME]
Date | Pilot | P.O.B. | Nature | Brakes | Take | Landing | Brakes | Flight | Total | Engine |  |  | Fuel Uptake
 |  |  | of Flight | Off | Off |  | ON | Time | Time |  | Remarks
G-BSGL |  |  |  |  |  |  |  |  | TECHNICAL LOG
 |  |  |  |  |  |  |  |  | [NAME]
Date | Pilot | P.O.B. | Nature | Brakes | Take | Landing | Brakes | Flight | Total | Engine |  |  | Fuel Uptake
 |  |  | of Flight | Off | Off |  | ON | Time | Time |  | Remarks
G-BSGL |  |  |  |  |  |  |  |  | TECHNICAL LOG
 |  |  |  |  |  |  |  |  | [NAME]
Date | Pilot | P.O.B. | Nature | Brakes | Take | Landing | Brakes | Flight | Total | Engine |  |  | Fuel Uptake
 |  |  | of Flight | Off | Off |  | ON | Time | Time |  | Remarks
G-BSGL |  |  |  |  |  |  |  |  | TECHNICAL LOG
 |  |  |  |  |  |  |  |  | [NAME]
Date | Pilot | P.O.B. | Nature | Brakes | Take | Landing | Brakes | Flight | Total | Engine |  |  | Fuel Uptake
 |  |  | of Flight | Off | Off |  | ON | Time | Time |  | Remarks
Spreadsheet: 5a9ffc6c-3668-465e-9cc0-9a40ec7c639e
Sheet: Dev Unpaid

U.S. Industry Auto
Exhibit I (Sheet 8)
Projection of Ultimate Claims Using Reported and Paid Claims ($000) |  |  |  |  |  | Unpaid Claim Estimate at 12/31/08
 |  |  |  |  |  | IBNR - Based on |  | Total - Based on
 | Claims at 12/31/07 |  | Development Method |  | Case O/S | Dev. Method with |  | Dev. Method with
AY | Reported | Paid | Reported | Paid | @ 12/31/07 | Reported | Paid | Reported | Paid
1999
1999
Total
Spreadsheet: 807479d1669914757-help-with-formula-when-ref-a-data-table-in-a-different-column-help-1-
Sheet: Sheet1

Data  A | Data B | doubler | input | location
 |  |  | 1 | A
 |  |  | 2 | B
 |  |  | 3 | C
 |  | X | 4 | D
 |  |  | 5 | E
 |  |  | 6 | F
 |  |  | 7 | G
 |  | X | 8 | H
 |  | X | 9 | I
 |  |  | 10 | J
 |  |  | 11 | K
 |  |  | 12 | L
Spreadsheet: 181885d1348180301-help-with-setting-up-a-spreadsheet-to-calculate-personal-expenses-expenses
Sheet: Detail2

Date | Type | Sub-Type | Description | Debit Abs |  | Month | Year
2012-07-03 00:00:00 | Bills | Car_Payment | [NAME] | 11.23376645404027
2012-07-03 00:00:00 | Bills | Car_Payment | [NAME] | 8.879453730172113
2012-07-10 00:00:00 | Income | Payroll | [NAME] 3 | 9.204793871990507
2012-07-24 00:00:00 | Income | Payroll | [NAME] | 6.751783311107669
2012-07-24 00:00:00 | Utilities | Mortgage | [NAME] | 8.77752904523443
2012-07-24 00:00:00 | Utilities | Mortgage | [NAME] 6 | 9.117385388734526
2012-07-27 00:00:00 | Income | Payroll | [NAME] | 3.842419327612178
2012-07-15 00:00:00 | Bills | Home_Improvement | [NAME] 8 | 4.794301041319507
2012-07-25 00:00:00 | Utilities | Gas_Bill | [NAME] 9 | 9.952388957906205
2012-08-06 00:00:00 | Bills | Car_Payment | [NAME] 10 | 2.078182755919502
2012-08-06 00:00:00 | Bills | Car_Payment | [NAME] | 9.389931107707854
2012-08-07 00:00:00 | Utilities | Mortgage | [NAME] 12 | 9.170605112939755
2012-08-10 00:00:00 | Income | Payroll | [NAME] 13 | 3.906560928213104
2012-08-13 00:00:00 | Income | Supplemental | [NAME] 14 | 6.669411771083798
2012-08-16 00:00:00 | Bills | Car_Insurance | [NAME] 15 | 1.306668620221421
2012-08-18 00:00:00 | Utilities | Internet | [NAME] 16 | 7.818616249340898
2012-08-24 00:00:00 | Income | Payroll | [NAME] 17 | 0.02346733440217275
2012-08-24 00:00:00 | Restaurant | Food | [NAME] 18 | 8.758849409930981
2012-08-25 00:00:00 | Shopping/Entertainment | [NAME] | [NAME] 19 | 0.9088043313065652
2012-08-27 00:00:00 | Utilities | Gas_Bill | [NAME] 20 | 11.15574527736575
2012-08-30 00:00:00 | Income | Payroll | [NAME] 21 | 10.87350070274935
2012-08-31 00:00:00 | Shopping/Entertainment | Vacation | [NAME] 22 | 4.68570726156911
2012-08-31 00:00:00 | Shopping/Entertainment | Vacation | [NAME] 23 | 5.596410861399011
2012-08-31 00:00:00 | Groceries | Groceries | [NAME] 24 | 8.758432463911202
2012-09-04 00:00:00 | Shopping/Entertainment | Vacation | [NAME] 25 | 0.710290933158209
2012-09-07 00:00:00 | Groceries | Groceries | [NAME] 26 | 2.253215342757856
2012-09-07 00:00:00 | Restaurant | Food | [NAME] 27 | 3.392766366877552
2012-09-07 00:00:00 | Groceries | Groceries | [NAME] 28 | 1.719863932686714
Spreadsheet: kate_symes__18450__Cob
Sheet: DJ COB Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-01-11 00:00:00 |  | 176.75 | 9600 | 152.5 | 1680
 | 2001-01-10 00:00:00 |  | 168.05 | 8800 | 150 | 800 | 172.22 | 1360 | 166.03 | 696
 | 2001-01-09 00:00:00 |  | 165.55 | 8000 | 149.11 | 1080 | 175 | 75 | 150 | 65
 | 2001-01-08 00:00:00 |  | 154.06 | 12320 | 139.02 | 2440 | 170.92 | 1100 | 124.59 | 1220
 | 2001-01-07 00:00:00 |  |  |  |  |  |  |  | 120.71 | 2304 |  | 139.02 | 7320
 | 2001-01-06 00:00:00 |  | 146 | 9600 | 142.53 | 3000 | 119.57 | 1585 | 110.85 | 1970
 | 2001-01-05 00:00:00 |  | 146.36 | 10000 | 142.53 | 3000 | 168.87 | 1857 | 148.05 | 1001
 | 2001-01-04 00:00:00 |  | 154.8 | 8000 | 154.29 | 1400 | 172.79 | 3571 | 156.13 | 1435
 | 2001-01-03 00:00:00 |  | 180.29 | 4160 | 172.5 | 800 | 160.85 | 4323 | 147.25 | 922
 | 2001-01-02 00:00:00 |  | 185 | 800 | 176.58 | 584 | 149.75 | 2900 | 144.12 | 170
 | 2001-01-01 00:00:00 |  |  |  |  |  |  |  | 138.83 | 1790 |  | 175.74 | 2112
 | 2000-12-31 00:00:00 |  |  |  |  |  |  |  | 147.02 | 3015 |  | 150 | 600
 | 2000-12-30 00:00:00 |  | 165.5 | 4000 | 150 | 200 | 154.23 | 1750 | 155.43 | 460
 | 2000-12-29 00:00:00 |  | 219.29 | 5600 | 180 | 296 | 213.59 | 745 | 172.12 | 353
 | 2000-12-28 00:00:00 |  | 219.29 | 5600 | 180 | 296 | 205.42 | 300 | 181.32 | 285
 | 2000-12-27 00:00:00 |  | 396.43 | 2800 | 255 | 200 | 176.08 | 3130 | 186.7 | 684
 | 2000-12-26 00:00:00 |  | 461.25 | 1600 | 442.5 | 0 | 185 | 65 | 200 | 0
 | 2000-12-25 00:00:00 |  |  |  |  |  |  |  | 300 | 600
 | 2000-12-24 00:00:00 |  |  |  |  |  |  |  | 336.11 | 450
 | 2000-12-23 00:00:00 |  | 470.93 | 3440 | 311.96 | 1528 | 500 | 825 | 250 | 25
 | 2000-12-22 00:00:00 |  | 474.38 | 3200 | 290.77 | 1408 | 484.27 | 1335 | 300 | 25
 | 2000-12-21 00:00:00 |  | 476.11 | 3600 | 290.77 | 1408 | 500 | 1175 | 450 | 600
 | 2000-12-20 00:00:00 |  | 465.71 | 2800 | 375 | 200 | 529.93 | 2100 | 550 | 200
 | 2000-12-19 00:00:00 |  | 450 | 2400 | 346.89 | 1608 | 477.03 | 1720 | 210 | 697
 | 2000-12-18 00:00:00 |  | 377 | 2000 | 325 | 400 | 593.64 | 3048 | 423.21 | 1126
 | 2000-12-17 00:00:00 |  |  |  |  |  |  |  | 551.77 | 2065 |  | 325 | 600
 | 2000-12-16 00:00:00 |  | 306.88 | 3200 | 255.53 | 1808 | 587.5 | 1400 | 537.5 | 1200
 | 2000-12-15 00:00:00 |  | 306.88 | 3200 | 255.53 | 1808 | 571.38 | 3975 | 517.59 | 3375
 | 2000-12-14 00:00:00 |  | 484.61 | 5200 | 256.22 | 1608 | 654.11 | 730 | 437.04 | 1340
 | 2000-12-13 00:00:00 |  | 688.24 | 6800 | 500 | 200 | 454.83 | 6475 | 350 | 100
 | 2000-12-12 00:00:00 |  | 818.75 | 3200 | 300 | 200 | 800 | 0 | 600 | 0
 | Explanatory Notes
 | R = REVISED |  |  | S = SURVEYED DATA |  |  |  | N/Q - NO QUOTE
 | Index: Weighted average price of megawatthours sold at COB. The Index is quoted in $/Mwh.
 | For questions or comments please call Antoine Eustache (609)520-7058 or [NAME] (609) 520-7067.