HDS TBalanceInventoryComp by HC120831001657


									                                                                                                                                                  TOTAL BALANCE                                                                                            8/30/2012
                                                                                                                                         PROJECT SUSTAINABILITY INVENTORY

         Phil Henshaw            The sample project is a dance class center in Greenpoint Brooklyn to serve NYC schools, to be built on a site formerly occupied by
      eco@synapse9.com           small brownstones and a storefront. See DollarShadow.htm for references, discussion of the method and using photo voltaic panel
                                 equivalence (pv Footprint) to represent a project's energy use.

          Spreadwheet:          www.synapse9.com/design/HDS-TBalanceInventoryComp.xls
          Reference             www.synapse9.com/design/dollarshadow.htm

          part of New Use captured =                100%                             100%                                                                  6.1%                    0.1%                        1%

                                                   ESTIMATES FOR TOTAL EMBODIED IN BUILDING & USE
                                 EST.        TOTAL                     EST.             TOTAL                                                Energy Star Est.            BUILD CARBON                                 E-Quest-6 (update
                                       ENERGY                                     CO2                          PV FOOTPRINT                    Source btu                  NEUTRAL               UK Footprinter            of DOE2)              ATHENA
    PRIOR USE            [1970 Brownstones]
                                                    Annual              Cost/yr         Annual            PV area            PV ht                        Annual
                                Cost/yr (1995$)     mbtu's              (1995$)         MTons             MultSites       /SiteWidth          Cost        MTons          Cost      Acres        Cost   Annual MTons     Cost      Acres     Cost      Acres
    15yr AMORT.DEVL.                   $.16 m         1,879m             $.16 m            156.6              1.4xSite
         OPERATIONS                    $.47 m         5,638m             $.47 m            469.8              4.3xSite
                total                  $.63 m         7,517m             $.63 m            626.4              5.7xSite           626ft

    2030 50% TARGET [one target choice could be to aim or compensate for meeting for the world's 2050 target for a project of this size]

                 total                                    2,200
    NEW USE              [2010 Dance Studios]

    15yr AMORT.DEVL.                  $5.1 m        32,853m              $5.1 m          2,926.0               37xSite                                                                  116
         OPERATIONS                   $12. m        76,800m              $12. m          6,840.0               87xSite
                total                $17.1 m       109,653m             $17.1 m          9,766.0              125xSite        2.60mi                           6,644                                           92.3

                                  Then the contributions of high or low impact parts of the development or operating costs, and for compensations having effects
    ADJUSTMENTS                   beyond the project, are listed.
                                       EST. ENERGY                           EST. CO2                          FOOTPRINT A                     FOOTPRINT B                FOOTPRINT B            FOOTPRINT B             FOOTPRINT B         FOOTPRINT B
                                Cost              btu's              Cost          btu's                 Cost            btu's            Cost         btu's           Cost     btu's         Cost     btu's          Cost     btu's      Cost     btu's



                                Then the first estimates are adjusted by factoring in the non-average parts

                                   Then the adjusted totals are compared to the target
                                  EST. ENERGY                                EST. CO2                          FOOTPRINT A                     FOOTPRINT B                FOOTPRINT B            FOOTPRINT B             FOOTPRINT B         FOOTPRINT B
     NEW USE
735d39f7-12f5-4839-88c6-72297047403d.xls                                                                                                                        pfh                                                                                        8/30/2012
inputs             outputs

Constants                                                                               Inflation
1970btu/$                       12,000    2007 pv/$       0.10                          2007->1995
2010btu/$                        8,000    sf/acre       43,560                          1970->1995
                                          CO2-MT/k$ 2006 0.57                           1970->2006
                                          CO2-MT/k$ 1970     1                          devl amortizatoin

                                          inflated to 1995 for btu data, inflated to
Prior Use                        1970$    2006 for pv data                              New Building
brownstones, 14 @18'x30' + corner store                                                 Dance Studio 5 story

site width                          100                                                 site width

site area                        11000                                                  site area

Occ sf                           33000                                                  Occ sf
                                          a guess for small Greenpoint rental in 1970
Unit Rent                         $250                                                  Cost/sf
                                          for 14 units + a storefront
Annual Rent                    $54,000
                                          estimating building cost as 10 times rent
Est Devel                    $810,000                                                   Est Devel
                                          construction cost amortized in 20 yr
Est Devl/yr                    $54,000                                                  Devl/yr
                                          adj to 1995$
Infl Devl/yr                 $156,600                                                   defl. Devl/yr
                                          estimating tenant incomes as 4 times rent &
Est Oper/yr                  $162,000     rent Devl cost                                Est Oper mil
                                          adj to 1995$
Infl. Oper/yr                $469,800                                                   defl Oper

Combined                     $626,400                                                   Combined

                                          using 1995 rate
devl btu                       1,879m                                                   devl btu
                                          using 1995 rate
oper btu                       5,638m                                                   oper btu
                                          using 1070 rate
co2 devl MT                       156.6                                                 co2 devl MT
                                          using 1070 rate
co2 oper MT                       469.8                                                 co2 oper MT

devl sf pv                      15,660                                                  devl sf pv
                                          based on $shadow method
oper sf pv                      46,980                                                  oper sf pv

dev pv ftprint                 1.4xSite                                                 dev pv ftprint

oper pv ftprint                4.3xSite                                                 oper pv ftprint
tot ht pv in ft    626    tot ht pv in ft

ht pv in mi       .12mi   ht pv in mi

pv in acres       0.014   pv in acres
                        0.80      to adj 1995 btu&c02 data
                                                                              When viewing two windows side by side, drag the res
                        2.90      to adj 1995 btu&c02 data                    from work areas on Sheet 2 or 3 to the summary shee
                        4.20      to adj 2006pv data                          highlight the input variable and explain the steps
                       15.00 yr

                                  deflated to 1995 for btu data, used as is
                      2007$       for pv data
Studio 5 story





                                  construction cost amortized in 20 yr
                                  adj to 1995$

                                  adj to 1995$
                                  adj to 1995$

                                  using 1995 rate
                                  using 1995 rate
                                  using 06 rate
                                  using 06 rate

                                  based on $shadow method

                                  based on $shadow method

         based on $shadow method
         based on $shadow method

wo windows side by side, drag the results of calculations
 on Sheet 2 or 3 to the summary sheet. In the work areas
ut variable and explain the steps
input              output
from http://www.architecture2030.org/2030_challenge/targets.html
2030 challenge target
buillding type     kbtu/sf avg site EUI   Target
self storage                         4  1
church/distrib ctr                  40  2
clinic/school                       80  3        50%
store/hosp         250+                 4

building area                 11,000
floors                             5
avg 2003                       4,400 mbtu
target 2030                    2,200 mbtu

BuildCarbonNeutral Estimate
total carbon                    1,744 MT
amortized 15yr                    116

Energy Star
tot source energy/yr
50% target                    3,322.0 mbtu
100% est                        6,644 mbtu
55000 sf school, steel, nyc, 350 student
, 40 hr/wk, 12mo/yr

EnvironFootprint EF

office area                   40000    sf
staff                            300
avg utilities                   66.4   T/dy
avg transport                   25.9   T/dy
total                           92.3   t/yr
from posts on COTE forum

The idea for ADJUSTMENTS is to start from comprehensive estimates, and then refine them with
hard numbers for particualr processes or components which have separate published ebodied
CO2 or energy uses. That way as your refine your estimate of the total it will increase or
decrease if the measured components have a higher or lower than average embodied content.

To make it possible to use 'hard' measures the way I'm suggesting, combining 'hard' numbers for
individual contributions with the 'soft' numbers of a comprehensive estimate you'd need both the
hard measures of impacts AND the $ value added by it. Like with concrete, say, there are several
steps in the delivery of it to your site for which the energy use and CO2 production are measurable
as a predictable btu/yard and CO2/yard basis. That needs to be converted to a btu/$ units.

The snag is that there are also lots of things done to produce any product for which direct
measures are not available, like the company's car insurance or the accounting department's costs,
and the office Christmas party, etc,... or all the upstream energy & CO2 costs of their materials.
The usual thing has been to simply leave all that out... That effectively destroys the validity of your
modeling assumption, though, that controlling the use will control impacts in a predictable way.
The measures either need to be for the value added by the energy or CO2 content, or, to include a
separate estimate for all the unmeasurable content. Then it would be possible to combine the
figures to inform a total content estimate the way I was proposing.

The way to do it, I think, is to swap out the direct measures for pollution according to the value
added from the particular polluting processes. You'd start with a global share estimate giving
you Total$=Xmetric tons on average. Then you'd measure a ValueAdded$=Ymetric tons for a
particular contributing process. To adjust the estimate of X with the measurement Y you'd subtract
the portion of tons from X for the average attributable to the ValueAdded$ and then add Y. That
way you'd get an adjusted total. I'm just getting to working up an Excel template.

Examples of non-average contributors to the embodied CO2 of a product or service are the high
value but low embodied energy of an artist's signature or the unusual high embodied energy of
concrete and steel. It's tricky, though, since you need to account for the unusual energy use of
those products along with their share of average energy uses, doing that by using the 'value added'
of the special use rather than the total cost of the product. When you do the content of the special
high or low contributors can be factored in to replace their value in the project total with their actual
CO2 contribution, replacing the average amounts initially used.
                     How to use this template: Layout the calculations for each estimate on Sheet 2 or 3. When
                     viewing two windows side by side, drag the results to the summary sheet. In the work areas
fine them with       highlight the input variable and explain the steps. From the custom View menu you can see the
ed ebodied           variable names for each cell so the results can be queried from elsewhere

 ' numbers for
eed both the
here are several
are measurable

 artment's costs,
 ir materials.
e validity of your
ctable way.
  or, to include a
combine the

c tons for a
Y you'd subtract

 are the high
d energy of
nergy use of
he 'value added'
nt of the special
with their actual
can see the

To top