tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 763936d1642474058-need-alternative-non-volatile-formula-insted-of-given-one-non-volatile-help-
Sheet: SeatPlan

 | Room No | 1
 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
 |  |  |  |  |  |  |  |  | Name of Source Sheet | source
 |  |  |  |  |  |  |  |  | First Cell | A2
 |  |  |  |  |  |  |  |  | Reference
 | Room No | 2
 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10
Spreadsheet: 62438d1263390787-excel-2007-calculating-a-certain-time-range-between-2-hours-shiftunsocial
Sheet: Unsocial Hrs

MONDAY | U/S Hrs | TUESDAY | U/S Hrs | WEDNESDAY | U/S Hrs | THURSDAY | U/S Hrs | FRIDAY | U/S Hrs | SATURDAY | U/S Hrs | SUNDAY | U/S Hrs | Total Shift Hours | Total Unsocial Hours
Total [NAME] | Tot Per/SH |  | Tot Per/SH |  | Tot Per/SH |  | Tot Per/SH |  | Tot Per/SH |  | Tot Per/SH |  | Tot Per/SH
 | 1 |  |  |  | 8 |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | Total [NAME]
Spreadsheet: 880392d1728053334-sumifs-vertical-and-horizontal-criteria-shop-example
Sheet: Sheet1

Week Ending | 2023-01-07 00:00:00
Year
Month
Shop A | 200
Shop B | 160
Shop C | 125
 | 2023 | 2023
 | January | February
Spreadsheet: stephanie_panus__39290__American Commercial Barge Line LLC annex b 11-19-01
Sheet: ANEWSWP2

[NAME]
 |  | ATTORNEY:
DEAL DATE: | 2001-11-16 00:00:00 | DEAL MAKER:
COUNTERPARTY: | American Commercial Barge Line LLC | CONTACT:
ADDRESS: | 1701 E. Market St. | TITLE:
 | Jeffersonville, IN | PHONE:
 |  | FAX:
Incorporation State |  | S&P Rating
STRUCTURE | COUNTERPARTY | ENA
GUARANTOR (RATING)
LIMIT $ MILLIONS | N/A
Incorporation State
ELEGIBLE SWAP PARTICIPANT
Counterparty | X
Guarantor
COLLATERAL  THRESHOLD MATRIX
based on S & P and
Moody's ratings | 250000
Independent Amount
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit | X
Cash | X
Treasuries/Maturity limit
MINIMUM TRANSFER $ | 0
COLLATERAL ROUNDING
Delivery Amount | 100000
Return Amount | 100000
HOLDING and USE OF COLLATERAL
Permitted | X
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - if Matrix not applicable
APPLY TO:
-Counterparty | X
-Guarantor
Debt Ratings Change
-Below = S&P/Moody's
Financial Covenants
-Funded Debt to Worth
-Minimum Net Worth
-EBITDA/Interest Expense
-Funded Debt / EBITDA
Non-Specific | X
-Unilateral | X
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt
-Counterparty ($[NAME])
-Guarantor ($[NAME])
Change in ownership
SPECIFIED ENTITY
FINANCIAL STATEMENTS
-Standard
- Request financials on:
CREDIT DECISION: | APPROVED :  X | DECLINED:
OUTSTANDING SWAP TRANSACTIONS: |  | YES: | NO:
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES: | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES: | NO:
OTHER COMMENTS:
GLOBAL CREDIT:  Please complete the attached form below if the following conditions exist:
A)  No previous guidance limit exists or .....
B)  The proposed contractual limits exceed the existing guidance limits.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | Date: 11/19/01
Spreadsheet: 1cd11b2c-12a7-4b11-ae84-d5354438c094
Sheet: 13a

 |  | Dealers** |  | Buyside |  | TOTAL
Product |  | Cleared*** | Uncleared | Cleared | Uncleared | Cleared | Uncleared
Single - Name* | Corporate | 522187 | 8257828 | 522187 | 800314 | 1044374 | 9058142
 | Loans |  | 28589 |  | 1127 |  | 29716
 | Municipal |  | 3308 |  | 114 |  | 3422
 | Recovery
 | Sovereign | 33002 | 2637046 | 33002 | 248290 | 66003 | 2885337
Index Tranche | Asia |  | <1,000 |  | <100 |  | <1,000
 | Europe |  | 787910 |  | 86537 |  | 874447
 | North America |  | 1220097 |  | 39272 |  | 1259369
Index | Asia | 1240 | 318406 | 1535 | 48418 | 2774 | 366824
 | Europe | 283361 | 2527018 | 283361 | 377731 | 566721 | 2904749
 | North America | 509787 | 1611944 | 528212 | 313213 | 1037998 | 1925157
Other | Exotic
 | Swaptions
 | Total Return Swap
TOTAL* |  | 1349576 | 17392146 | 1368296 | 1915017 | 2717871 | 19307163
Estimated gross notional amount outstanding, November 16 weekly snapshot, by product type (millions of USD), all participant types, tenors and currencies. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for participant type descriptions.
***See Explanatory Notes for cleared and uncleared descriptions.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 031613d2-8d05-4ce0-93a2-c17c1ca02560
Sheet: Internal Factors

Internal Factors | Weight | Rating | Weighted Score | comment
[NAME]
Microsystemic Weaknesses
[NAME]
Macrosystemic Weaknesses
Total scores
Spreadsheet: 651621d1574803917-shopping-list-help-with-filtering-formulas-shopping_list
Sheet: List

Avocado
Bananas
Beans
Blueberries
Bread
Bread
Carrots
[NAME]
[NAME]
[NAME]
[NAME]
Ginger
[NAME]
Mushrooms
Mushrooms
Mushrooms
Oat milk
Onion
Onion
Potatoes
Seaweed sheets
Squash
Strawberries
Sushi rice
Sweet potatoes
Tomato
Tomatoes
Vegan cheese
Spreadsheet: 274022d1382986559-make-2-dependent-drop-down-lists-dynamic-equipment-and-cost-estimate-updated
Sheet: Reference

Size | Description | Price | Price | Price | Price | Price |  | cost | =OFFSET('Piping and Fitting'!$C$3,0,0,COUNTA('Piping and Fitting'!$C$3:$C$1000))
 |  |  |  |  |  |  |  | description
 |  |  |  |  |  |  |  | material_description | =OFFSET('Piping and Fitting'!$B$3,0,0,COUNTA('Piping and Fitting'!$B$3:$B$3:'Piping and Fitting'!$B$1000))
 |  |  |  |  |  |  |  | size
 |  |  |  |  |  |  |  | unique_description | =OFFSET(Reference!$B$2, 0, 0, COUNT(IF(Reference!$B$2:$B$1000="", "", 1)), 1)
Spreadsheet: 246d3e9c-b78b-47d1-8bdd-b473e322fcf2
Sheet: 11a

Product1 | Cleared2 | Uncleared | TOTAL
Cross-Currency Basis | - | 1092 | 1092
Cross-Currency Fixed-Fixed | - | 22 | 22
Cross-Currency Fixed-Float | - | 368 | 368
TOTAL | - | 1482 | 1482
Spreadsheet: 777761d1650594259-auto-populating-cells-on-multiple-tabs-based-on-the-date-entered-in-a-log-2022-trading-journal
Sheet: September 

Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Weekly Totals
 |  |  |  |  |  |  |  | 2022-09-01 00:00:00 |  | 2022-09-02 00:00:00 |  | 2022-09-03 00:00:00
Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
2022-09-04 00:00:00 |  | 2022-09-05 00:00:00 |  | 2022-09-06 00:00:00 |  | 2022-09-07 00:00:00 |  | 2022-09-08 00:00:00 |  | 2022-09-09 00:00:00 |  | 2022-09-10 00:00:00
Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
2022-09-11 00:00:00 |  | 2022-09-12 00:00:00 |  | 2022-09-13 00:00:00 |  | 2022-09-14 00:00:00 |  | 2022-09-15 00:00:00 |  | 2022-09-16 00:00:00 |  | 2022-09-17 00:00:00
Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
2022-09-18 00:00:00 |  | 2022-09-19 00:00:00 |  | 2022-09-20 00:00:00 |  | 2022-09-21 00:00:00 |  | 2022-09-22 00:00:00 |  | 2022-09-23 00:00:00 |  | 2022-09-24 00:00:00
Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
2022-09-25 00:00:00 |  | 2022-09-26 00:00:00 |  | 2022-09-27 00:00:00 |  | 2022-09-28 00:00:00 |  | 2022-09-29 00:00:00 |  | 2022-09-30 00:00:00
Spreadsheet: 707420d1607261797-using-a-list-to-reduce-worksheets-midshires-master-ans
Sheet: master

1 | PLAYER | Playing Handicap | Official Handicap | Exact handicap | HOLE | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | Total | Par 3 | Adjusted stableford points | Official [NAME] points | Handicap Alteration (Official) | Handicap Alteration (Unofficial) |  |  |  |  |  | Stroke Index
1 |  |  |  |  | PAR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Adjusted H'Caps |  |  | Official H'Caps
1 |  |  |  |  | S/I |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | New H'Cap |  |  |  |  | S/I 1 | S/I 2 | S/I 3 | S/I 1 | S/1 2 | S/1 3
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | Neville Ankers
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
0 | [NAME]
 | Number of Players |  |  |  | HOLE | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | Total
 |  |  |  |  | PAR
 | Average Score |  |  |  | S/I
 | PARS
 | BIRDIES
 | Total Score
Spreadsheet: 784812d1655967012-vlookup-partial-string-match-ask-formula-aligw-1-
Sheet: Sheet1

 | AliGW | Result in colomn B should be :
[NAME] |  | A
billy Loki |  | B
[NAME] |  | C
Bina oiko |  | D
Bina ljk |  | D
zena 89 |  | C
billy89 |  | B
[NAME] |  | A
Noko kl |  | B
dsasd adam |  | A
[NAME] |  | B
[NAME] |  | C
[NAME] |  | D
dsaddsadam |  | A
[NAME] |  | B
dsa Noko |  | A
Asdf |  | others
Spreadsheet: 84011d1284018673-cell-function-detecting-color-format-returncolourindex
Sheet: Sum By Colour

Colour to Sum | ColorIndex |  | Column to sum | ColorIndex
 | 33 |  | 1 | 3
 |  |  | 2 | 0
 | 6 |  | 3 | 33
 |  |  | 4 | 0
 | 3 |  | 5 | 6
 |  |  | 6 | 0
 | 43 |  | 7 | 33
 |  |  | 8 | 43
 |  |  | 9 | 3
 |  |  | 10 | 3
 | Sum |  | 10 | 2 | Count
 | Sum |  | 5 | 1 | Count
 | Sum |  | 20 | 3 | Count
 | Sum |  | 8 | 1 | Count
Spreadsheet: 105642d1302944054-excel-2007-extracting-values-from-specific-row-and-column-with-criteria-book1_meslija
Sheet: Sheet2

[NAME] | Punct (m) | FX (kN) | MY (kNm) | MZ (kNm) |  |  |  |  |  |  |  |  |  | Validation Lists > |  | [NAME] | Punct (m)
1 | x= 0.0 | 7243.41 | 128.22 | 76.16 |  |  |  |  |  |  |  |  |  |  |  | 1 | x= 0.0
1 | x= 0.0 | 3596.11 | -133.26 | 63.21 |  |  | For | Bar number: |  | 1 |  |  |  |  |  | 2 | x=3.50
1 | x= 0.0 | 6556.04 | 248.17 | 44.61 |  |  |  | Section: |  | x= 0.0
1 | x= 0.0 | 4817.86 | -306.33 | 108.8
1 | x= 0.0 | 5732.85 | 77.51 | 198.53 |  |  | Nmax= |  | Myaf= |  | Mzaf=
1 | x= 0.0 | 5717.27 | 81.92 | -183.5 |  |  | Nmin= |  | Myaf= |  | Mzaf=
1 | x=3.50 | 7186.62 | -208.55 | -174.21 |  |  | Naf= |  | Mymax= |  | Mzaf=
1 | x=3.50 | 3554.04 | -40.02 | -93.06 |  |  | Naf= |  | Mymin= |  | Mzaf=
1 | x=3.50 | 6015.06 | -10.85 | -162.1 |  |  | Naf= |  | Myaf= |  | [NAME]
1 | x=3.50 | 7122.87 | -237.66 | -168.92 |  |  | Naf= |  | Myaf= |  | Mzmin=
1 | x=3.50 | 5660.48 | -160.44 | -16.62
1 | x=3.50 | 5971.98 | -159.85 | -234.92
2 | x= 0.0 | 7457.98 | -1.5 | -149.45
2 | x= 0.0 | 3872.74 | -3.57 | -16.27 |  |  | I have the data in column  A:E. I need a formula or a vba code to sort like above. I give the bar number and the section. From the first find to the last .If i get the values from column C with a vlookup i could get the others.I just couldnt find a solution.
2 | x= 0.0 | 5989.54 | 140.46 | -124.25
2 | x= 0.0 | 5988.74 | -341.22 | -124.32
2 | x= 0.0 | 6099.51 | -2.09 | 38.41
2 | x= 0.0 | 5917.84 | -3.86 | -383.15
2 | x=3.50 | 7401.19 | 2.01 | 233.14
2 | x=3.50 | 3830.67 | 5.16 | 154.74
2 | x=3.50 | 5931.95 | 268.47 | 226.57
2 | x=3.50 | 6491.57 | -164.41 | 236.87
2 | x=3.50 | 6088.05 | 6.57 | 363.92
2 | x=3.50 | 4682.43 | 2.15 | 111.3
Spreadsheet: 79459d1279722490-numerical-date-and-time-scratch
Sheet: Data

 | Time Allowance | 15
Consignee Code | Appointment ID | Scheduled Start Time | Gate In Time | [NAME] | Late Truck
8L | 2821464 | 2010-06-01 08:00:00 | 2010-06-01 08:15:00 | 15 | 1
8L | 2823934 | 2010-06-03 06:00:00 | 2010-06-03 05:12:00 | -48 | 0
8L | 2813096 | 2010-06-04 14:00:00 | 2010-06-07 09:21:00 | 4041 | 1
8L | 2837796 | 2010-06-06 10:00:00 | 2010-06-07 09:20:00 | 1400 | 1
8L | 2837804 | 2010-06-06 10:00:00 | 2010-06-07 09:20:00 | 1400 | 1
8L | 2837810 | 2010-06-06 10:00:00 | 2010-06-07 09:19:00 | 1399 | 1
8L | 2788852 | 2010-06-07 06:00:00 | 2010-06-08 12:52:00 | 1852 | 1
8L | 2788852 | 2010-06-07 06:00:00 | 2010-06-08 12:52:00 | 1852 | 1
8L | 2795328 | 2010-06-07 06:00:00 | 2010-06-08 12:53:00 | 1853 | 1
8L | 2805321 | 2010-06-07 06:00:00 | 2010-06-07 06:14:00 | 14 | 0
8L | 2806544 | 2010-06-07 06:00:00 | 2010-06-07 06:09:00 | 9 | 0
8L | 2808466 | 2010-06-07 06:00:00 | 2010-06-07 08:18:00 | 138 | 1
8L | 2816435 | 2010-06-07 06:00:00 | 2010-06-08 12:55:00 | 1855 | 1
Spreadsheet: 714952d1611478194-formula-for-closing-balance-copie-de-forum-excel-23-jan-2021
Sheet: Épargnes Inv.

1) | [NAME] for latest balance (cells D6 to D9) |  |  |  |  | Thanks again for taking the time:) !! I appreciate it!
2) | [NAME] to update CLOSING BALANCE after each deposit/withdrawal and ANNUAL REPORT (Column G)
3) | [NAME] to know profit loss on the "ANNUAL REPORT" (Column F)
 | Solde actuel des comptes: | RED | [NAME]??
 |  | BLUE
 |  | YELLOW
 |  | GREEN
DATE | Description | ACCOUNT | AMOUNT | BALANCE REPORT | PROFIT/ LOSS | CLOSING BALANCE | Column1
2020-01-10 00:00:00 | Deposit | AR | 200
2020-01-21 00:00:00 | Deposit | AR | 200
2020-01-30 00:00:00 | Deposit | AR | 200
2020-03-01 00:00:00 | Deposit | FT | 300
2020-03-01 00:00:00 | Deposit | AR | 25
2020-03-05 00:00:00 | Withdrawal | AR | -30
2020-03-11 00:00:00 | Withdrawal | FT | -45
2020-03-13 00:00:00 | Withdrawal | AR | 20
2020-03-01 00:00:00 | Deposit | PL | 60
2020-03-01 00:00:00 | Deposit | UR | 80
2020-05-01 00:00:00 | Annual report (balance now at 230$) | AR | 0 | 230
2020-05-01 00:00:00 | Annual report (balance now at 280$) | FT | 0 | 320
2020-05-01 00:00:00 | Annual report (balance now at 55$) | PL | 0 | 55
2020-05-01 00:00:00 | Annual report (balance now at 77$) | UR | 0 | 77
2020-06-15 00:00:00 | Withdrawal | AR | -50
2020-06-15 00:00:00 | Withdrawal | FT | -60
2020-06-15 00:00:00 | Withdrawal | PL | -40
2020-06-15 00:00:00 | Withdrawal | UR | -70
2021-01-01 00:00:00 | Deposit | AR | 120
2021-01-01 00:00:00 | Deposit | FT | 100
2021-01-01 00:00:00 | Deposit | PL | 90
2021-01-01 00:00:00 | Deposit | UR | 80
Spreadsheet: 167827d1342111573-1st-time-user-of-excel-solver-function-can-some-one-double-check-my-work-for-accuracy-efficient-frontier-calc-7-11-12
Sheet: S&P 500_Barclays Agr E.F Ca (2

 | Efficient Frontier Calculation
 |  |  | Deviation |  |  |  |  | Deviation
 |  |  | about |  |  |  |  | about
 | Fixed Income |  | the mean | [NAME] |  | Equities |  | the mean | [NAME]
 | 2012-03-01 00:00:00 | 0.003 |  |  |  | 2012-03-01 00:00:00 | 0.1266
 | 2011-12-01 00:00:00 | 0.0784 |  |  |  | 2011-12-01 00:00:00 | 0.0223
 | 2011-09-01 00:00:00 | 0.0665 |  |  |  | 2011-09-01 00:00:00 | -0.0851
 | 2011-06-01 00:00:00 | 0.0272 |  |  |  | 2011-06-01 00:00:00 | 0.0619
 | sum |  |  |  |  | sum
 | count |  |  |  |  | count
 | avg mean |  |  |  |  | avg
 | [NAME] |  |  |  |  | [NAME]
 | Standard Deviation |  |  |  |  | Standard Deviation
 | Fixed Income Allocation |  |  | 0.865778828166929
 | Equities Allocation |  |  | 0.1342211718330713
 | Total Weight
 | [NAME]
 | Start Date
 | End Date
 | F_I_Average Return
 | [NAME]. Return
 | F_I_Standard Deviation
 | [NAME] Deviation
 | Portfolio Average Return
 | Portfolio Standard Deviation
 | Slope
 | Covariance
 | [NAME]
 | [NAME]
Spreadsheet: 841730d1693906509-data-validation-based-on-index-match-temp_2023
Sheet: Invoice Detail

 |  | Invoice Detail
 |  | Date | Inv. No. | PO/SO No. | Style No. | Qty. | Unit Price | Total
 |  | 07.25.2022 | 327 | 4900032870 | W383124030 | 390 | 10 | 3900
 |  | 07.25.2023 | 327 | 4900032870 | W373124080 | 195 | 10 | 1950
 |  | 07.25.2024 | 328 | 4900032947 | W353128133 | 720 | 40 | 28800
 |  | 07.25.2025 | 328 | 4900032947 | W353128133 | 720 | 15 | 10800
 |  | 07.25.2026 | 329 | 4900033009 | [NAME] | 800 | 22 | 17600
 |  | 07.25.2027 | 329 | 4900033009 | A352124116 | 1000 | 35 | 35000
 |  | 07.25.2028 | 330 | 4900032920 | A352126066 | 1150 | 35 | 40250
 |  | 07.25.2029 | 330 | 4900032920 | [NAME] | 1000 | 45 | 83250
 |  |  | 331 | 4900032920 | [NAME]
Spreadsheet: 62848d1263850839-drop-down-reference-book100
Sheet: Sheet2

PRO NUMBER | BOL NUMBER | PO NUMBER | SHIP DATE | PICKUP TIME | DELIVERY DATE | DELIVERY TIME | SHIPPER NAME | SHIPPER CITY | SHIPPER STATE | SHIPPER ZIP | CONSIGNEE NAME | CONSIGNEE CITY | CONSIGNEE STATE | CONSIGNEE ZIP | PIECES | WEIGHT | STATUS | DELIVERY SIGNATURE | NET CHARGES | DISCOUNT AMOUNT | TERMS
TOL-246721 | VG450ELGB (LG) | 5241722 | 2010-01-11 00:00:00 | 14:47:00 | 2010-01-19 (ETA) |  | NORTHLINE EXPRESS | ROSCOMMON | MI | 48653 | CARROLL PITTMAN | MEADVIEW | AZ | 86444 | 1 | 230 | TRLR 2300117 AT KNG |  | 163.57 | 611.18 | Prepaid
TOL-246724 | TR008 | 5239017 | 2010-01-11 00:00:00 | 14:40:00 | 2010-01-18 (ETA) |  | NORTHLINE EXPRESS | ROSCOMMON | MI | 48653 | [NAME] | SEATTLE | WA | 98133 | 1 | 352 | HANDED OFF |  | 136.46 | 509.85 | Prepaid
TOL-251403 | VG820E | 5243783 | 2010-01-15 00:00:00 | 15:49:00 | 2010-01-25 (ETA) |  | NORTHLINE EXPRESS | ROSCOMMON | MI | 48653 | ROBYN HOLLENBECK | [NAME] | OR | 97918 | 1 | 420 | TRLR P7083 AT CGT |  | 183.78 | 625.44 | Prepaid
TOL-251404 | SR57E | 5243915 | 2010-01-18 00:00:00 | 11:03:00 | 2010-01-26 (ETA) |  | NORTHLINE EXPRESS | ROSCOMMON | MI | 48653 | CHRISTINA HYDE | [NAME] | OR | 97497 | 1 | 190 | AT ORIG GLR |  | 119.38 | 443.73 | Prepaid
2005392340 | 3780001 | 5240562 | 2010-01-12 00:00:00 | 17:18:00 | 2010-01-18 00:00:00 | 12:08:00 | NORTHLINE EXPRESS | ROSCOMMON | MI | 48653 | THOMAS FITZPATRICK | CHRISTIANA | TN | 37037 | 1 | 315 | DELIVERED | T FITZPATRICK | 74.17 | 227.41 | Prepaid
2005554751 | PIPE | 5234193 | 2010-01-15 00:00:00 | 15:50:00 | 2010-01-19 (ETA) |  | NORTHLINE EXPRESS | ROSCOMMON | MI | 48653 | BRUCE HARRINGTON | BLOUNTVILLE | TN | 37617 | 1 | 305 | TRLR P17132 TO CLT |  | 90.06 | 218.13 | Prepaid
2005555241 | 6041I | 5243730 | 2010-01-15 00:00:00 | 15:47:00 | 2010-01-19 (ETA) |  | NORTHLINE EXPRESS | ROSCOMMON | MI | 48653 | METAL FORMING | MC KENZIE | TN | 38201 | 1 | 460 | TRLR P13648 [NAME] |  | 103.78 | 328.13 | Prepaid
2005555650 | BX26E (LG) | 5241661 | 2010-01-15 00:00:00 | 15:46:00 | 2010-01-19 (ETA) |  | NORTHLINE EXPRESS | ROSCOMMON | MI | 48653 | [NAME] | CEYLON | MN | 56121 | 1 | 166 | TRLR P25384 TO MAU |  | 74.56 | 257.92 | Prepaid
2005556055 | VG650ELG | 5243391 | 2010-01-15 00:00:00 | 15:45:00 | 2010-01-19 (ETA) |  | NORTHLINE EXPRESS | ROSCOMMON | MI | 48653 | CHARLIE FARMER | WILLIFORD | AR | 72482 | 1 | 455 | [NAME] |  | 109.81 | 350.53 | Prepaid
2005556475 | VG650ELG (LG) |  | 2010-01-15 00:00:00 | 15:46:00 | 2010-01-19 (ETA) |  | NORTHLINE EXPRESS | ROSCOMMON | MI | 48653 | [NAME] | SPRING HILL | KS | 66083 | 1 | 460 | TRLR P9094 TO INCD |  | 94.36 | 293.1 | Prepaid
2005556781 | BX26E | 5242206 | 2010-01-15 00:00:00 | 15:44:00 | 2010-01-19 (ETA) |  | NORTHLINE EXPRESS | ROSCOMMON | MI | 48653 | HUMPHREY CONSTRUCTION | SANTA FE | TN | 38482 | 1 | 285 | TRLR 2518819 TO NAS |  | 90.06 | 213.1 | Prepaid
Spreadsheet: 07296c68-386c-439e-ae6d-c17a93d8cce3
Sheet: 34

THE ALLSTATE CORPORATION
HISTORICAL PROPERTY-LIABILITY LOSS RESERVES
($ in millions)
 |  |  |  |  | Twelve months ended December 31,
 |  |  |  |  | 2012 |  |  | 2011 |  |  | 2010 |  |  | 2009 |  |  | 2008
(net of reinsurance)
Net reserve for claims and claims expense,
beginning of year |  |  |  | $ | 17787 |  | $ | 17396 |  | $ | 17028 |  | $ | 17182 |  | $ | 16660
Acquisitions |  |  |  |  | -13 |  |  | 425 |  |  | 0 |  |  | 0 |  |  | 0
Claims and claims expense
 | Provision attributable to the current year |  |  |  | 19149 |  |  | 20496 |  |  | 19110 |  |  | 18858 |  |  | 19894
 | Change in provision attributable
 | to prior years (1) |  |  |  | -665 |  |  | -335 |  |  | -159 |  |  | -112 |  |  | 170
 |  | Total claims and claims expense |  |  | 18484 |  |  | 20161 |  |  | 18951 |  |  | 18746 |  |  | 20064
Payments
 | Claims and claims expense attributable
 | to current year |  |  |  | -12545 |  |  | -13893 |  |  | -12012 |  |  | -11906 |  |  | -12658
 | Claims and claims expense attributable
 | to prior years |  |  |  | -6435 |  |  | -6302 |  |  | -6571 |  |  | -6994 |  |  | -6884
 |  | Total payments |  |  | -18980 |  |  | -20195 |  |  | -18583 |  |  | -18900 |  |  | -19542
Net reserve for claims and claims expense,
end of year (2) |  |  |  | $ | 17278 |  | $ | 17787 |  | $ | 17396 |  | $ | 17028 |  | $ | 17182
Percent change in loss reserves |  |  |  |  | -2.861640523978186 | % |  | 2.247643136353184 | % |  | 2.161146347192859 | % |  | -0.8962868117797695 | % |  | 3.133253301320528 | %
(1) | Reserve reestimates due to:
 | Asbestos and environmental claims |  |  | $ | 48 |  | $ | 26 |  | $ | 23 |  | $ | 5 |  | $ | 8
 | All other property-liability claims |  |  |  | -713 |  |  | -361 |  |  | -182 |  |  | -117 |  |  | 162
 | Change in pre-tax reserve |  |  | $ | -665 |  | $ | -335 |  | $ | -159 |  | $ | -112 |  | $ | 170
(2) | Net reserves for claims and claims expense are net of expected reinsurance recoveries of $4.01 billion, $2.59 billion, $2.07 billion, $2.14 billion and $2.27 billion at December 31, 2012, 2011, 2010, 2009 and 2008, respectively.
Spreadsheet: paul_lucci__28366__Collar & Swap10_25_01
Sheet: SmryApr_Oct

Kennedy Oil
 | Curve Date | [NAME] |  | Bid | Offer
 | 2001-10-24 00:00:00 | 2001-10-24 00:00:00 | NYMEX | 0 | 0 | 3.248236983707693
 |  |  | Basis | 0 | 0
Basis Location | IF-CIG/RKYMTN
Index Location | none
[NAME] | IF-CIG/RKYMTN
Daily Volume | 10000
SWAP Value
Start | 2002-04-01 00:00:00 | Origination | 0 | 0
End | 2002-10-31 00:00:00
Offer | Swap price = | 2.645736983707693
COSTLESS COLLAR TRANSACTION
 |  | CALL |  |  |  | PUT
Origination | 0 | Call Offer | 0 | Phy1 Fin2 | 2 | [NAME] | 0 | Phy1 Fin2 | 2
Daily Volume | 10000 | [NAME] | 0 | Buy1 Sell2 | 1 | Vol Bid | 0 | Buy1 Sell2 | 2
Start | 2002-04-01 00:00:00
End | 2002-10-31 00:00:00
 | STRIKE | PREMIUM | VALUE
PUT VALUATION | 2.345736983707693 | 0.2487104140762971 | 532240.2861232759
CALL VALUATION | 3.101652138283051 | 0.2487104140759532 | -532240.2861225398
 |  | Total = | 7.360940799117088e-07
PARTICIPATING COSTLESS COLLAR TRANSACTION
 |  | CALL |  |  |  | PUT
Origination | 0 | Call Offer | 0 | Phy1 Fin2 | 2 | [NAME] | 0 | Phy1 Fin2 | 2
End | 37560 | [NAME] | 0 | Buy1 Sell2 | 1 | Vol Bid | 0 | Buy1 Sell2 | 2
Start | 2002-04-01 00:00:00 | Call Volume | 5000
End | 2002-10-31 00:00:00
 | STRIKE | PREMIUM | VALUE
PUT VALUATION | 2 | 0.1202366444393071 | 257306.4191001171
CALL VALUATION | 3.133113033485145 | 0.2404732888601118 | -257306.4190803196
 |  | Total = | 1.979750231839716e-05
PUT VALUE
PUT
[NAME] | 0 | Phy1 Fin2 | 2
Vol Bid | 0 | Buy1 Sell2 | 2
 | STRIKE | PREMIUM | VALUE
PUT VALUATION | 2 | 0.1202366444393071 | 257306.4191001171
BASIS SWAP
Basis Location | IF-CIG/RKYMTN |  | Basis Location | NGI-SOCAL
Cost | 0.7483027046959345
Total Cost | 1575851.502942565