UBmatrix Calculation Trace Report
Line Concept Weight Decimals Precision Reported Calculated Source Message
1 Extended Link [ http://sherwin.com/role/StatementConsolidatedBalanceSheets ]
2 Context Dec31_2008 [ 2008-12-31 - ]
c-equal
3 Unit USD
u-equal
us-gaap:PropertyPlantAndEquipmentNet -3 [6] 860125000 860,125,000 Instance OK
us-gaap:PropertyPlantAndEquipmentGross 1.0 -3 [7] 2256482000 2,256,482,000 Instance OK
us-gaap:Land 1.0 -3 [5] 85485000 85,485,000 Instance
us-gaap:BuildingsAndImprovementsGross 1.0 -3 [6] 580216000 580,216,000 Instance
shw:MachineryEquipment 1.0 -3 [7] 1564221000 1,564,221,000 Instance
us-gaap:ConstructionInProgressGross 1.0 -3 [5] 26560000 26,560,000 Instance
us-gaap:AccumulatedDepreciationDepletionAndAmortizationPropertyPlantAndEquipment -1.0 -3 [7] 1396357000 1,396,357,000 Instance
us-gaap:Assets -3 [7] 4415759000 1,909,205,000 Instance Inconsistency found, calculated value is 1,909,205,000
us-gaap:AssetsCurrent 1.0 -3 [7] 1909205000 1,113,008,000 Instance Inconsistency found, calculated value is 1,113,008,000
us-gaap:InventoryNet 1.0 -3 [6] 864200000 864,200,000 Instance OK
us-gaap:InventoryFinishedGoods 1.0 -3 [6] 749405000 749,405,000 Instance
shw:WorkInProcessRawMaterials 1.0 -3 [6] 114795000 114,795,000 Instance
us-gaap:DeferredTaxAssetsNetCurrent 1.0 -3 [5] 97568000 97,568,000 Instance
us-gaap:OtherAssetsCurrent 1.0 -3 [6] 151240000 151,240,000 Instance
us-gaap:LiabilitiesCurrent -3 [7] 1936736000 415,338,000 Instance Inconsistency found, calculated value is 415,338,000
us-gaap:OtherLiabilitiesCurrent 1.0 -3 [6] 415338000 415,338,000 Instance
us-gaap:LiabilitiesAndStockholdersEquity -3 [7] 4415759000 1,605,648,000 Instance Inconsistency found, calculated value is 1,605,648,000
us-gaap:StockholdersEquity 1.0 -3 [7] 1605648000 8,983,922,000 Instance Inconsistency found, calculated value is 8,983,922,000
us-gaap:PreferredStockValue 1.0 -3 [6] 216753000 216,753,000 Instance
us-gaap:OtherAdditionalCapital 1.0 -3 [7] 1016362000 1,016,362,000 Instance
us-gaap:UnearnedESOPShares -1.0 -3 [6] -216753000 -216,753,000 Instance
us-gaap:CommonStockValue 1.0 -3 [6] 227147000 227,147,000 Instance
us-gaap:TreasuryStockValue -1.0 -3 [7] -3472384000 -3,472,384,000 Instance
us-gaap:AccumulatedOtherComprehensiveIncomeLossNetOfTax 1.0 -3 [6] -410618000 -410,618,000 Instance
us-gaap:RetainedEarningsAccumulatedDeficit 1.0 -3 [7] 4245141000 4,245,141,000 Instance
2 Context SixMonthsEndedJune30_2008 [ 2008-06-30 - ]
c-equal
3 Unit USD
u-equal
us-gaap:PropertyPlantAndEquipmentNet -3 [6] 904819000 904,819,000 Instance OK
us-gaap:PropertyPlantAndEquipmentGross 1.0 -3 [7] 2296060000 2,296,060,000 Instance OK
us-gaap:Land 1.0 -3 [5] 84189000 84,189,000 Instance
us-gaap:BuildingsAndImprovementsGross 1.0 -3 [6] 578634000 578,634,000 Instance
shw:MachineryEquipment 1.0 -3 [7] 1570915000 1,570,915,000 Instance
us-gaap:ConstructionInProgressGross 1.0 -3 [5] 62322000 62,322,000 Instance
us-gaap:AccumulatedDepreciationDepletionAndAmortizationPropertyPlantAndEquipment -1.0 -3 [7] 1391241000 1,391,241,000 Instance
us-gaap:Assets -3 [7] 5165777000 2,367,629,000 Instance Inconsistency found, calculated value is 2,367,629,000
us-gaap:AssetsCurrent 1.0 -3 [7] 2367629000 1,229,749,000 Instance Inconsistency found, calculated value is 1,229,749,000
us-gaap:InventoryNet 1.0 -3 [6] 920638000 920,638,000 Instance OK
us-gaap:InventoryFinishedGoods 1.0 -3 [6] 799043000 799,043,000 Instance
shw:WorkInProcessRawMaterials 1.0 -3 [6] 121595000 121,595,000 Instance
us-gaap:DeferredTaxAssetsNetCurrent 1.0 -3 [6] 105138000 105,138,000 Instance
us-gaap:OtherAssetsCurrent 1.0 -3 [6] 203973000 203,973,000 Instance
us-gaap:LiabilitiesCurrent -3 [7] 2570110000 403,503,000 Instance Inconsistency found, calculated value is 403,503,000
us-gaap:OtherLiabilitiesCurrent 1.0 -3 [6] 403503000 403,503,000 Instance
us-gaap:LiabilitiesAndStockholdersEquity -3 [7] 5165777000 1,665,529,000 Instance Inconsistency found, calculated value is 1,665,529,000
us-gaap:StockholdersEquity 1.0 -3 [7] 1665529000 8,933,931,000 Instance Inconsistency found, calculated value is 8,933,931,000
us-gaap:PreferredStockValue 1.0 -3 [6] 216753000 216,753,000 Instance
us-gaap:OtherAdditionalCapital 1.0 -3 [6] 939499000 939,499,000 Instance
us-gaap:UnearnedESOPShares -1.0 -3 [6] -216753000 -216,753,000 Instance
us-gaap:CommonStockValue 1.0 -3 [6] 226526000 226,526,000 Instance
us-gaap:TreasuryStockValue -1.0 -3 [7] -3417448000 -3,417,448,000 Instance
us-gaap:AccumulatedOtherComprehensiveIncomeLossNetOfTax 1.0 -3 [6] -182879000 -182,879,000 Instance
us-gaap:RetainedEarningsAccumulatedDeficit 1.0 -3 [7] 4099831000 4,099,831,000 Instance
2 Context SixMonthsEndedJune30_20092 [ 2009-06-30 - ]
c-equal
3 Unit USD
u-equal
us-gaap:PropertyPlantAndEquipmentNet -3 [6] 842303000 842,303,000 Instance OK
us-gaap:PropertyPlantAndEquipmentGross 1.0 -3 [7] 2219392000 2,218,852,000 Instance Inconsistency found, calculated value is 2,218,852,000
us-gaap:Land 1.0 -3 [5] 86714000 86,714,000 Instance
us-gaap:BuildingsAndImprovementsGross 1.0 -3 [6] 593022000 593,022,000 Instance
shw:MachineryEquipment 1.0 -3 [7] 1522054000 1,522,054,000 Instance
us-gaap:ConstructionInProgressGross 1.0 -3 [5] 17062000 17,062,000 Instance
us-gaap:AccumulatedDepreciationDepletionAndAmortizationPropertyPlantAndEquipment -1.0 -3 [7] 1377089000 1,377,089,000 Instance
us-gaap:Assets -3 [7] 4502110000 1,977,771,000 Instance Inconsistency found, calculated value is 1,977,771,000
us-gaap:AssetsCurrent 1.0 -3 [7] 1977771000 1,019,852,000 Instance Inconsistency found, calculated value is 1,019,852,000
us-gaap:InventoryNet 1.0 -3 [6] 769992000 769,992,000 Instance OK
us-gaap:InventoryFinishedGoods 1.0 -3 [6] 681418000 681,418,000 Instance
shw:WorkInProcessRawMaterials 1.0 -3 [5] 88574000 88,574,000 Instance
us-gaap:DeferredTaxAssetsNetCurrent 1.0 -3 [5] 98848000 98,848,000 Instance
us-gaap:OtherAssetsCurrent 1.0 -3 [6] 151012000 151,012,000 Instance
us-gaap:LiabilitiesCurrent -3 [7] 1903730000 398,943,000 Instance Inconsistency found, calculated value is 398,943,000
us-gaap:OtherLiabilitiesCurrent 1.0 -3 [6] 398943000 398,943,000 Instance
us-gaap:LiabilitiesAndStockholdersEquity -3 [7] 4502110000 1,733,998,000 Instance Inconsistency found, calculated value is 1,733,998,000
us-gaap:StockholdersEquity 1.0 -3 [7] 1733998000 9,219,882,000 Instance Inconsistency found, calculated value is 9,219,882,000
us-gaap:PreferredStockValue 1.0 -3 [6] 216753000 216,753,000 Instance
us-gaap:OtherAdditionalCapital 1.0 -3 [7] 1042120000 1,042,120,000 Instance
us-gaap:UnearnedESOPShares -1.0 -3 [6] -216753000 -216,753,000 Instance
us-gaap:CommonStockValue 1.0 -3 [6] 227964000 227,964,000 Instance
us-gaap:TreasuryStockValue -1.0 -3 [7] -3526189000 -3,526,189,000 Instance
us-gaap:AccumulatedOtherComprehensiveIncomeLossNetOfTax 1.0 -3 [6] -368066000 -368,066,000 Instance
us-gaap:RetainedEarningsAccumulatedDeficit 1.0 -3 [7] 4358169000 4,358,169,000 Instance


1 Extended Link [ http://sherwin.com/role/StatementCondensedStatementsOfCashFlows ]
2 Context SixMonthsEndedJune30_20082 [ 2008-01-01 - 2008-06-30 ]
c-equal
3 Unit USD
u-equal
us-gaap:CashAndCashEquivalentsPeriodIncreaseDecrease -3 [5] 18249000 18,249,000 Instance OK
us-gaap:NetCashProvidedByUsedInOperatingActivities 1.0 -3 [6] 262800000 456,788,000 Instance Inconsistency found, calculated value is 456,788,000
us-gaap:NetIncomeLoss 1.0 -3 [6] 249629000 249,629,000 Instance
us-gaap:Depreciation 1.0 -3 [5] 71148000 71,148,000 Instance
shw:AmortizationIntangibleAssets 1.0 -3 [5] 10674000 10,674,000 Instance
shw:ImpairmentTrademarksGoodwillCF 1.0 -3 [5] 23912000 23,912,000 Instance
us-gaap:ShareBasedCompensation 1.0 -3 [5] 18303000 18,303,000 Instance
us-gaap:OtherIncreaseDecreaseInProvisionForRestructuring 1.0 -3 [0] 0 0 Instance
us-gaap:EnvironmentalRemediationExpense 1.0 -3 [3] 711000 711,000 Instance
shw:DefinedBenefitPensionPlansNetCredit 1.0 -3 [4] -3968000 -3,968,000 Instance
us-gaap:OtherPostretirementBenefitExpense 1.0 -3 [4] 1502000 1,502,000 Instance
us-gaap:OtherAdjustmentsForNoncashItemsIncludedInIncomeLossFromContinuingOperations 1.0 -3 [3] -429000 -429,000 Instance
us-gaap:IncreaseDecreaseInOperatingCapital -1.0 -3 [5] -96994000 -96,994,000 Instance
us-gaap:PaymentsForEnvironmentalLiabilities 1.0 -3 [4] -6470000 -6,470,000 Instance
us-gaap:BusinessExitCosts 1.0 -3 [4] -2600000 -2,600,000 Instance
us-gaap:IncreaseDecreaseInOtherOperatingCapitalNet 1.0 -3 [4] -2618000 -2,618,000 Instance
us-gaap:NetCashProvidedByUsedInInvestingActivities 1.0 -3 [6] -105248000 112,610,000 Instance Inconsistency found, calculated value is 112,610,000
us-gaap:PaymentsToAcquirePropertyPlantAndEquipment -1.0 -3 [5] -70885000 -70,885,000 Instance
us-gaap:PaymentsToAcquireBusinessesNetOfCashAcquired -1.0 -3 [5] -14677000 -14,677,000 Instance
us-gaap:ProceedsFromSaleOfProductiveAssets 1.0 -3 [4] 3681000 3,681,000 Instance
us-gaap:PaymentsForProceedsFromOtherInvestingActivities -1.0 -3 [5] -23367000 -23,367,000 Instance
us-gaap:NetCashProvidedByUsedInFinancingActivities 1.0 -3 [6] -131298000 711,020,000 Instance Inconsistency found, calculated value is 711,020,000
us-gaap:ProceedsFromRepaymentsOfShortTermDebt 1.0 -3 [6] 273255000 273,255,000 Instance
us-gaap:ProceedsFromRepaymentsOfLongTermDebtAndCapitalSecurities 1.0 -3 [4] -2842000 -2,842,000 Instance
us-gaap:PaymentsOfOrdinaryDividends -1.0 -3 [5] -83175000 -83,175,000 Instance
us-gaap:ProceedsFromStockOptionsExercised 1.0 -3 [5] 17942000 17,942,000 Instance
us-gaap:ExcessTaxBenefitFromShareBasedCompensationFinancingActivities 1.0 -3 [4] 6505000 6,505,000 Instance
us-gaap:PaymentsForRepurchaseOfEquity -1.0 -3 [6] -337984000 -337,984,000 Instance
us-gaap:ProceedsFromPaymentsForOtherFinancingActivities 1.0 -3 [4] -4999000 -4,999,000 Instance
us-gaap:EffectOfExchangeRateOnCashAndCashEquivalents 1.0 -3 [4] -8005000 -8,005,000 Instance
2 Context SixMonthsEndedJune30_2009 [ 2009-01-01 - 2009-06-30 ]
c-equal
3 Unit USD
u-equal
us-gaap:CashAndCashEquivalentsPeriodIncreaseDecrease -3 [5] 23047000 23,047,000 Instance OK
us-gaap:NetCashProvidedByUsedInOperatingActivities 1.0 -3 [6] 266424000 345,792,000 Instance Inconsistency found, calculated value is 345,792,000
us-gaap:NetIncomeLoss 1.0 -3 [6] 195302000 195,302,000 Instance
us-gaap:Depreciation 1.0 -3 [5] 73200000 73,200,000 Instance
shw:AmortizationIntangibleAssets 1.0 -3 [5] 12196000 12,196,000 Instance
shw:ImpairmentTrademarksGoodwillCF 1.0 -3 [0] 0 0 Instance
us-gaap:ShareBasedCompensation 1.0 -3 [5] 11247000 11,247,000 Instance
us-gaap:OtherIncreaseDecreaseInProvisionForRestructuring 1.0 -3 [4] 9668000 9,668,000 Instance
us-gaap:EnvironmentalRemediationExpense 1.0 -3 [4] 9151000 9,151,000 Instance
shw:DefinedBenefitPensionPlansNetCredit 1.0 -3 [5] 16482000 16,482,000 Instance
us-gaap:OtherPostretirementBenefitExpense 1.0 -3 [4] 1300000 1,300,000 Instance
us-gaap:OtherAdjustmentsForNoncashItemsIncludedInIncomeLossFromContinuingOperations 1.0 -3 [4] 4175000 4,175,000 Instance
us-gaap:IncreaseDecreaseInOperatingCapital -1.0 -3 [5] -39684000 -39,684,000 Instance
us-gaap:PaymentsForEnvironmentalLiabilities 1.0 -3 [5] -14797000 -14,797,000 Instance
us-gaap:BusinessExitCosts 1.0 -3 [4] -4041000 -4,041,000 Instance
us-gaap:IncreaseDecreaseInOtherOperatingCapitalNet 1.0 -3 [4] -7775000 -7,775,000 Instance
us-gaap:NetCashProvidedByUsedInInvestingActivities 1.0 -3 [5] -91868000 94,876,000 Instance Inconsistency found, calculated value is 94,876,000
us-gaap:PaymentsToAcquirePropertyPlantAndEquipment -1.0 -3 [5] -40896000 -40,896,000 Instance
us-gaap:PaymentsToAcquireBusinessesNetOfCashAcquired -1.0 -3 [5] -14058000 -14,058,000 Instance
us-gaap:ProceedsFromSaleOfProductiveAssets 1.0 -3 [4] 1504000 1,504,000 Instance
us-gaap:PaymentsForProceedsFromOtherInvestingActivities -1.0 -3 [5] -38418000 -38,418,000 Instance
us-gaap:NetCashProvidedByUsedInFinancingActivities 1.0 -3 [6] -158893000 106,221,000 Instance Inconsistency found, calculated value is 106,221,000
us-gaap:ProceedsFromRepaymentsOfShortTermDebt 1.0 -3 [5] -17680000 -17,680,000 Instance
us-gaap:ProceedsFromRepaymentsOfLongTermDebtAndCapitalSecurities 1.0 -3 [5] -19581000 -19,581,000 Instance
us-gaap:PaymentsOfOrdinaryDividends -1.0 -3 [5] -83190000 -83,190,000 Instance
us-gaap:ProceedsFromStockOptionsExercised 1.0 -3 [5] 12337000 12,337,000 Instance
us-gaap:ExcessTaxBenefitFromShareBasedCompensationFinancingActivities 1.0 -3 [4] 2847000 2,847,000 Instance
us-gaap:PaymentsForRepurchaseOfEquity -1.0 -3 [5] -49367000 -49,367,000 Instance
us-gaap:ProceedsFromPaymentsForOtherFinancingActivities 1.0 -3 [4] -4259000 -4,259,000 Instance
us-gaap:EffectOfExchangeRateOnCashAndCashEquivalents 1.0 -3 [4] 7384000 7,384,000 Instance


1 Extended Link [ http://sherwin.com/role/StatementStatementsOfConsolidatedIncome ]
2 Context ThreeMonthsEndedJune30_2009 [ 2009-04-01 - 2009-06-30 ]
c-equal
3 Unit USD
u-equal
us-gaap:GrossProfit -3 [6] 895342000 895,342,000 Instance OK
us-gaap:Revenues 1.0 -3 [7] 1947827000 1,947,827,000 Instance
us-gaap:CostOfRevenue -1.0 -3 [7] 1052485000 1,052,485,000 Instance
us-gaap:IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments -3 [6] 232123000 -12,886,000 Instance Inconsistency found, calculated value is -12,886,000
us-gaap:NonoperatingIncomeExpense 1.0 -3 [4] -2530000 -2,530,000 Instance
us-gaap:InterestAndDebtExpense -1.0 -3 [5] 10356000 10,356,000 Instance
2 Context ThreeMonthsEndedJune30_2008 [ 2008-04-01 - 2008-06-30 ]
c-equal
3 Unit USD
u-equal
us-gaap:GrossProfit -3 [6] 972903000 972,903,000 Instance OK
us-gaap:Revenues 1.0 -3 [7] 2229545000 2,229,545,000 Instance
us-gaap:CostOfRevenue -1.0 -3 [7] 1256642000 1,256,642,000 Instance
us-gaap:IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments -3 [6] 256172000 -20,833,000 Instance Inconsistency found, calculated value is -20,833,000
us-gaap:NonoperatingIncomeExpense 1.0 -3 [4] -2700000 -2,700,000 Instance
us-gaap:InterestAndDebtExpense -1.0 -3 [5] 18133000 18,133,000 Instance
2 Context SixMonthsEndedJune30_20082 [ 2008-01-01 - 2008-06-30 ]
c-equal
3 Unit USD
u-equal
us-gaap:GrossProfit -3 [7] 1753411000 1,753,411,000 Instance OK
us-gaap:Revenues 1.0 -3 [7] 4011227000 4,011,227,000 Instance
us-gaap:CostOfRevenue -1.0 -3 [7] 2257816000 2,257,816,000 Instance
us-gaap:IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments -3 [6] 369201000 -40,006,000 Instance Inconsistency found, calculated value is -40,006,000
us-gaap:NonoperatingIncomeExpense 1.0 -3 [4] -4200000 -4,200,000 Instance
us-gaap:InterestAndDebtExpense -1.0 -3 [5] 35806000 35,806,000 Instance
2 Context SixMonthsEndedJune30_2009 [ 2009-01-01 - 2009-06-30 ]
c-equal
3 Unit USD
u-equal
us-gaap:GrossProfit -3 [7] 1575948000 1,575,948,000 Instance OK
us-gaap:Revenues 1.0 -3 [7] 3498504000 3,498,504,000 Instance
us-gaap:CostOfRevenue -1.0 -3 [7] 1922556000 1,922,556,000 Instance
us-gaap:IncomeLossFromContinuingOperationsBeforeIncomeTaxesMinorityInterestAndIncomeLossFromEquityMethodInvestments -3 [6] 283016000 -26,194,000 Instance Inconsistency found, calculated value is -26,194,000
us-gaap:NonoperatingIncomeExpense 1.0 -3 [4] -3636000 -3,636,000 Instance
us-gaap:InterestAndDebtExpense -1.0 -3 [5] 22558000 22,558,000 Instance


Copyright (c) UBmatrix, Inc. 2009