how to interact interactive html excel cell in javascript

Discussion in 'Javascript' started by nivas.meda@gmail.com, Oct 22, 2005.

  1. Guest

    Hi,

    I have an excel sheet with a graph and cells.If i change the value in
    the excel cells the graph will reflect.Now i am going to implement this
    functionality in html page.I successfully saved this as interactive
    html page.Now my requirement changes a bit.The excell cells will not
    visible to others.i have a text box,If i change the value in text box
    the excel template cell value need to change.

    I did the follwing steps for creating interactive html page

    1.go to and click save as webpage link

    2.selected selection:sheet option button .

    3.click the publish button.

    Please tell me how to interact the cells in this html page through
    javascript.

    Thanks,
    Srinivas.Meda
    , Oct 22, 2005
    #1
    1. Advertising

  2. mscir Guest

    wrote:

    > Hi,
    >
    > I have an excel sheet with a graph and cells.If i change the value in
    > the excel cells the graph will reflect.Now i am going to implement this
    > functionality in html page.I successfully saved this as interactive
    > html page.Now my requirement changes a bit.The excell cells will not
    > visible to others.i have a text box,If i change the value in text box
    > the excel template cell value need to change.
    >
    > I did the follwing steps for creating interactive html page
    >
    > 1.go to and click save as webpage link
    >
    > 2.selected selection:sheet option button .
    >
    > 3.click the publish button.
    >
    > Please tell me how to interact the cells in this html page through
    > javascript.
    >
    > Thanks,
    > Srinivas.Meda


    Post the html shoing the cells you want to interact with. I'm wondering
    if you can give them unique ID's then in the textbox onblur event call a
    function that uses the id to change the innerHTML.

    Mike
    mscir, Oct 22, 2005
    #2
    1. Advertising

  3. Evertjan. Guest

    wrote on 22 okt 2005 in comp.lang.javascript:

    > Please tell me how to interact the cells in this html page through
    > javascript.
    >


    Please do not multipost, crossposting is preferred if on topic.

    --
    Evertjan.
    The Netherlands.
    (Replace all crosses with dots in my emailaddress)
    Evertjan., Oct 22, 2005
    #3
  4. srinivas Guest

    the object loos like

    <object id="Copy of Chart for Website_23902_WebCalc"
    codebase="file:msowc.cab#version=9,0,0,6430"
    classid="CLSID:0002E510-0000-0000-C000-000000000046" VIEWASTEXT>
    <param name="DisplayTitleBar" value="false">
    <param name="DataType" value="HTMLData">
    <param name="HTMLData" value="&lt;html
    xmlns:v=&quot;urn:schemas-microsoft-com:vml&quot;
    xmlns:eek:=&quot;urn:schemas-microsoft-com:eek:ffice:eek:ffice&quot;
    xmlns:x=&quot;urn:schemas-microsoft-com:eek:ffice:excel&quot;
    xmlns=&quot;http://www.w3.org/TR/REC-html40&quot;&gt; &lt;head&gt; &lt;style
    id=&quot;Copy of Chart for
    Website_23902_Styles&quot;&gt;
    &lt;!--table
    {mso-displayed-decimal-separator:&quot;\.&quot;;
    mso-displayed-thousand-separator:&quot;\,&quot;;}
    tr
    {mso-height-source:auto;}
    col
    {mso-width-source:auto;}
    br
    {mso-data-placement:same-cell;}
    .xl15
    {mso-style-parent:style0;
    color:windowtext;
    font-size:10.0pt;
    font-weight:400;
    font-style:normal;
    text-decoration:none;
    font-family:Arial;
    mso-generic-font-family:auto;
    mso-font-charset:0;
    mso-number-format:General;
    text-align:general;
    vertical-align:bottom;
    border:none;
    mso-background-source:auto;
    mso-pattern:auto;
    mso-protection:locked
    visible;
    white-space:nowrap;
    mso-rotate:0;}
    .xl22
    {mso-style-parent:style0;
    color:windowtext;
    font-size:10.0pt;
    font-weight:400;
    font-style:normal;
    text-decoration:none;
    font-family:Arial;
    mso-generic-font-family:auto;
    mso-font-charset:0;
    mso-number-format:&quot;\0022$\0022\#\,\#\#0_\)\;\[Red\]\\\(\0022$\0022\#\,\#\#0\\\)&quot;;
    text-align:general;
    vertical-align:bottom;
    border:none;
    mso-background-source:auto;
    mso-pattern:auto;
    mso-protection:locked
    visible;
    white-space:nowrap;
    mso-rotate:0;}
    .xl23
    {mso-style-parent:style0;
    color:windowtext;
    font-size:10.0pt;
    font-weight:400;
    font-style:normal;
    text-decoration:none;
    font-family:Arial;
    mso-generic-font-family:auto;
    mso-font-charset:0;
    mso-number-format:&quot;\0022$\0022\#\,\#\#0\.00_\)\;\[Red\]\\\(\0022$\0022\#\,\#\#0\.00\\\)&quot;;
    text-align:general;
    vertical-align:bottom;
    border:none;
    mso-background-source:auto;
    mso-pattern:auto;
    mso-protection:locked
    visible;
    white-space:nowrap;
    mso-rotate:0;}
    .xl24
    {mso-style-parent:style0;
    color:windowtext;
    font-size:10.0pt;
    font-weight:400;
    font-style:normal;
    text-decoration:none;
    font-family:Arial;
    mso-generic-font-family:auto;
    mso-font-charset:0;
    mso-number-format:0%;
    text-align:general;
    vertical-align:bottom;
    border:none;
    mso-background-source:auto;
    mso-pattern:auto;
    mso-protection:locked
    visible;
    white-space:nowrap;
    mso-rotate:0;}
    .xl25
    {mso-style-parent:style0;
    color:windowtext;
    font-size:10.0pt;
    font-weight:400;
    font-style:normal;
    text-decoration:none;
    font-family:Arial;
    mso-generic-font-family:auto;
    mso-font-charset:0;
    mso-number-format:&quot;_\(\0022$\0022*
    \#\,\#\#0\.00_\)\;_\(\0022$\0022*
    \\\(\#\,\#\#0\.00\\\)\;_\(\0022$\0022*
    \0022-\0022??_\)\;_\(\@_\)&quot;;
    text-align:general;
    vertical-align:bottom;
    border:none;
    mso-background-source:auto;
    mso-pattern:auto;
    mso-protection:locked
    visible;
    white-space:nowrap;
    mso-rotate:0;}
    .xl26
    {mso-style-parent:style0;
    color:windowtext;
    font-size:10.0pt;
    font-weight:400;
    font-style:normal;
    text-decoration:underline;
    text-underline-style:single;
    font-family:Arial;
    mso-generic-font-family:auto;
    mso-font-charset:0;
    mso-number-format:General;
    text-align:general;
    vertical-align:bottom;
    border:none;
    mso-background-source:auto;
    mso-pattern:auto;
    mso-protection:locked
    visible;
    white-space:nowrap;
    mso-rotate:0;}
    .xl27
    {mso-style-parent:style0;
    color:windowtext;
    font-size:10.0pt;
    font-weight:400;
    font-style:normal;
    text-decoration:none;
    font-family:Arial;
    mso-generic-font-family:auto;
    mso-font-charset:0;
    mso-number-format:0;
    text-align:general;
    vertical-align:bottom;
    border:none;
    mso-background-source:auto;
    mso-pattern:auto;
    mso-protection:locked
    visible;
    white-space:nowrap;
    mso-rotate:0;}
    .xl28
    {mso-style-parent:style0;
    color:windowtext;
    font-size:10.0pt;
    font-weight:400;
    font-style:normal;
    text-decoration:none;
    font-family:Arial;
    mso-generic-font-family:auto;
    mso-font-charset:0;
    mso-number-format:&quot;_\(\0022$\0022*
    \#\,\#\#0_\)\;_\(\0022$\0022* \\\(\#\,\#\#0\\\)\;_\(\0022$\0022*
    \0022-\0022_\)\;_\(\@_\)&quot;;
    text-align:general;
    vertical-align:bottom;
    border:none;
    mso-background-source:auto;
    mso-pattern:auto;
    mso-protection:locked
    visible;
    white-space:nowrap;
    mso-rotate:0;}
    .xl29
    {mso-style-parent:style0;
    color:windowtext;
    font-size:10.0pt;
    font-weight:400;
    font-style:normal;
    text-decoration:none;
    font-family:Arial;
    mso-generic-font-family:auto;
    mso-font-charset:0;
    mso-number-format:&quot;\#\,\#\#0\.000_\)\;\\\(\#\,\#\#0\.000\\\)&quot;;
    text-align:general;
    vertical-align:bottom;
    border:none;
    mso-background-source:auto;
    mso-pattern:auto;
    mso-protection:locked
    visible;
    white-space:nowrap;
    mso-rotate:0;}
    .xl30
    {mso-style-parent:style0;
    color:windowtext;
    font-size:10.0pt;
    font-weight:400;
    font-style:normal;
    text-decoration:none;
    font-family:Arial;
    mso-generic-font-family:auto;
    mso-font-charset:0;
    mso-number-format:General;
    text-align:general;
    vertical-align:bottom;
    border:none;
    mso-background-source:auto;
    mso-pattern:auto;
    mso-protection:locked
    visible;
    white-space:normal;
    mso-rotate:0;}
    --&gt;
    &lt;/style&gt;
    &lt;/head&gt;

    &lt;body&gt;
    &lt;!--[if
    gte mso 9]&gt;&lt;xml&gt;
    &lt;x:ExcelWorkbook&gt;

    &lt;x:SpreadsheetAutoFit/&gt;

    &lt;x:MaxHeight&gt;80%&lt;/x:MaxHeight&gt;

    &lt;x:MaxWidth&gt;80%&lt;/x:MaxWidth&gt;

    &lt;x:ExcelWorksheets&gt;

    &lt;x:ExcelWorksheet&gt;

    &lt;x:WorksheetOptions&gt;

    &lt;x:TopRowVisible&gt;0&lt;/x:TopRowVisible&gt;

    &lt;x:LeftColumnVisible&gt;0&lt;/x:LeftColumnVisible&gt;

    &lt;x:protectContents&gt;False&lt;/x:protectContents&gt;

    &lt;x:protectObjects&gt;False&lt;/x:protectObjects&gt;

    &lt;x:protectScenarios&gt;False&lt;/x:protectScenarios&gt;

    &lt;/x:WorksheetOptions&gt;

    &lt;/x:ExcelWorksheet&gt;

    &lt;/x:ExcelWorksheets&gt;

    &lt;/x:ExcelWorkbook&gt;
    &lt;/xml&gt;&lt;![endif]--&gt;

    &lt;table
    x:str border=0 cellpadding=0 cellspacing=0 width=629
    style='border-collapse:

    collapse;table-layout:fixed;width:472pt'&gt;
    &lt;col
    width=255
    style='mso-width-source:userset;mso-width-alt:9325;width:191pt'&gt;

    &lt;col width=79
    style='mso-width-source:userset;mso-width-alt:2889;width:59pt'&gt;

    &lt;col width=64 span=2 style='width:48pt'&gt;
    &lt;col
    width=93
    style='mso-width-source:userset;mso-width-alt:3401;width:70pt'&gt;

    &lt;col width=74
    style='mso-width-source:userset;mso-width-alt:2706;width:56pt'&gt;

    &lt;tr height=51 style='height:38.25pt'&gt;
    &lt;td
    class=xl26 width=255 style='width:191pt' x:str=&quot;Input
    &quot;&gt;Input &lt;/td&gt;
    &lt;td class=xl15 width=79
    style='width:59pt'&gt;&lt;/td&gt;
    &lt;td class=xl15 width=64
    style='width:48pt'&gt;&lt;/td&gt;
    &lt;td class=xl15 width=64
    style='width:48pt'&gt;Year&lt;/td&gt;
    &lt;td class=xl15
    width=93 style='width:70pt'&gt;Electricty Cost&lt;/td&gt;

    &lt;td class=xl30 width=74 style='width:56pt'&gt;After Tax Loan
    Payment&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr height=17
    style='height:12.75pt'&gt;
    &lt;td class=xl15&gt;Average
    Monthly Electric Bill&lt;/td&gt;
    &lt;td class=xl22
    x:num=&quot;200&quot;&gt;&lt;/td&gt;
    &lt;td height=17
    class=xl15 style='height:12.75pt'&gt;&lt;/td&gt;
    &lt;td
    class=xl15 x:num=&quot;2006&quot;&gt;&lt;/td&gt;
    &lt;td
    class=xl23 x:num=&quot;250&quot;
    x:fmla=&quot;=B2*1.25&quot;&gt;&lt;/td&gt;
    &lt;td class=xl28
    x:num=&quot;216.9382700907907&quot;

    x:fmla=&quot;=IF((D2-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D2-2005),$B$7,$B$18)/12*$B$13,
    0)&quot;&gt;&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr
    height=17 style='height:12.75pt'&gt;
    &lt;td height=17
    class=xl15 style='height:12.75pt'&gt;&lt;/td&gt;
    &lt;td
    class=xl22&gt;&lt;/td&gt;
    &lt;td
    class=xl15&gt;&lt;/td&gt;
    &lt;td class=xl15
    x:num=&quot;2007&quot;
    x:fmla=&quot;=D2+1&quot;&gt;&lt;/td&gt;
    &lt;td class=xl25
    x:num=&quot;265&quot;
    x:fmla=&quot;=E2*(1+$B$10)&quot;&gt;&lt;/td&gt;
    &lt;td
    class=xl28 x:num=&quot;218.80947376269731&quot;

    x:fmla=&quot;=IF((D3-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D3-2005),$B$7,$B$18)/12*$B$13,
    0)&quot;&gt;&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr
    height=17 style='height:12.75pt'&gt;
    &lt;td
    class=xl26&gt;Constants&lt;/td&gt;
    &lt;td height=17
    colspan=2 class=xl15
    style='height:12.75pt;mso-ignore:colspan'&gt;&lt;/td&gt;

    &lt;td class=xl15 x:num=&quot;2008&quot;
    x:fmla=&quot;=D3+1&quot;&gt;&lt;/td&gt;
    &lt;td class=xl25
    x:num=&quot;280.9&quot;
    x:fmla=&quot;=E3*(1+$B$10)&quot;&gt;&lt;/td&gt;
    &lt;td
    class=xl28 x:num=&quot;220.79294965491829&quot;

    x:fmla=&quot;=IF((D4-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D4-2005),$B$7,$B$18)/12*$B$13,
    0)&quot;&gt;&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr
    height=17 style='height:12.75pt'&gt;
    &lt;td
    class=xl15&gt;Price of Electicity&lt;/td&gt;
    &lt;td
    class=xl23 x:num=&quot;00.2&quot;&gt;&lt;/td&gt;
    &lt;td
    height=17 class=xl15 style='height:12.75pt'&gt;&lt;/td&gt;

    &lt;td class=xl15 x:num=&quot;2009&quot;
    x:fmla=&quot;=D4+1&quot;&gt;&lt;/td&gt;
    &lt;td class=xl25
    x:num=&quot;297.75400000000008&quot;
    x:fmla=&quot;=E4*(1+$B$10)&quot;&gt;&lt;/td&gt;
    &lt;td
    class=xl28 x:num=&quot;222.89543410067256&quot;

    x:fmla=&quot;=IF((D5-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D5-2005),$B$7,$B$18)/12*$B$13,
    0)&quot;&gt;&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr
    height=17 style='height:12.75pt'&gt;
    &lt;td
    class=xl15&gt;Interest Rate&lt;/td&gt;
    &lt;td class=xl24
    x:num=&quot;00.06&quot;&gt;&lt;/td&gt;
    &lt;td height=17
    class=xl15 style='height:12.75pt'&gt;&lt;/td&gt;
    &lt;td
    class=xl15 x:num=&quot;2010&quot;
    x:fmla=&quot;=D5+1&quot;&gt;&lt;/td&gt;
    &lt;td class=xl25
    x:num=&quot;315.6192400000001&quot;
    x:fmla=&quot;=E5*(1+$B$10)&quot;&gt;&lt;/td&gt;
    &lt;td
    class=xl28 x:num=&quot;225.12406761317209&quot;

    x:fmla=&quot;=IF((D6-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D6-2005),$B$7,$B$18)/12*$B$13,
    0)&quot;&gt;&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr
    height=17 style='height:12.75pt'&gt;
    &lt;td
    class=xl15&gt;Term (years)&lt;/td&gt;
    &lt;td class=xl15
    x:num=&quot;20&quot;&gt;&lt;/td&gt;
    &lt;td height=17
    class=xl15 style='height:12.75pt'&gt;&lt;/td&gt;
    &lt;td
    class=xl15 x:num=&quot;2011&quot;
    x:fmla=&quot;=D6+1&quot;&gt;&lt;/td&gt;
    &lt;td class=xl25
    x:num=&quot;334.5563944000001&quot;
    x:fmla=&quot;=E6*(1+$B$10)&quot;&gt;&lt;/td&gt;
    &lt;td
    class=xl28 x:num=&quot;227.48641913642157&quot;

    x:fmla=&quot;=IF((D7-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D7-2005),$B$7,$B$18)/12*$B$13,
    0)&quot;&gt;&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr
    height=17 style='height:12.75pt'&gt;
    &lt;td
    class=xl15&gt;System Cost (/W AC)&lt;/td&gt;
    &lt;td
    class=xl25 x:num=&quot;9&quot;&gt;&lt;/td&gt;
    &lt;td
    height=17 class=xl15 style='height:12.75pt'&gt;&lt;/td&gt;

    &lt;td class=xl15 x:num=&quot;2012&quot;
    x:fmla=&quot;=D7+1&quot;&gt;&lt;/td&gt;
    &lt;td class=xl25
    x:num=&quot;354.62977806400011&quot;
    x:fmla=&quot;=E7*(1+$B$10)&quot;&gt;&lt;/td&gt;
    &lt;td
    class=xl28 x:num=&quot;229.99051175106604&quot;

    x:fmla=&quot;=IF((D8-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D8-2005),$B$7,$B$18)/12*$B$13,
    0)&quot;&gt;&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr
    height=17 style='height:12.75pt'&gt;
    &lt;td
    class=xl15&gt;Production (kWh / W AC)&lt;/td&gt;
    &lt;td
    class=xl29 x:num=&quot;1.8&quot;&gt;&lt;/td&gt;
    &lt;td
    height=17 class=xl15 style='height:12.75pt'&gt;&lt;/td&gt;

    &lt;td class=xl15 x:num=&quot;2013&quot;
    x:fmla=&quot;=D8+1&quot;&gt;&lt;/td&gt;
    &lt;td class=xl25
    x:num=&quot;375.90756474784013&quot;
    x:fmla=&quot;=E8*(1+$B$10)&quot;&gt;&lt;/td&gt;
    &lt;td
    class=xl28 x:num=&quot;232.64484992258917&quot;

    x:fmla=&quot;=IF((D9-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D9-2005),$B$7,$B$18)/12*$B$13,
    0)&quot;&gt;&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr
    height=17 style='height:12.75pt'&gt;
    &lt;td
    class=xl15&gt;Electricity Price Inflation&lt;/td&gt;
    &lt;td
    class=xl24 x:num=&quot;00.06&quot;&gt;&lt;/td&gt;
    &lt;td
    height=17 class=xl15 style='height:12.75pt'&gt;&lt;/td&gt;

    &lt;td class=xl15 x:num=&quot;2014&quot;
    x:fmla=&quot;=D9+1&quot;&gt;&lt;/td&gt;
    &lt;td class=xl25
    x:num=&quot;398.46201863271057&quot;
    x:fmla=&quot;=E9*(1+$B$10)&quot;&gt;&lt;/td&gt;
    &lt;td
    class=xl28 x:num=&quot;235.45844838440368&quot;

    x:fmla=&quot;=IF((D10-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D10-2005),$B$7,$B$18)/12*$B$13,
    0)&quot;&gt;&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr
    height=17 style='height:12.75pt'&gt;
    &lt;td
    class=xl15&gt;Rebate&lt;/td&gt;
    &lt;td class=xl25
    x:num=&quot;2.8&quot;&gt;&lt;/td&gt;
    &lt;td height=17
    class=xl15 style='height:12.75pt'&gt;&lt;/td&gt;
    &lt;td
    class=xl15 x:num=&quot;2015&quot;
    x:fmla=&quot;=D10+1&quot;&gt;&lt;/td&gt;
    &lt;td class=xl25
    x:num=&quot;422.3697397506732&quot;
    x:fmla=&quot;=E10*(1+$B$10)&quot;&gt;&lt;/td&gt;
    &lt;td
    class=xl28 x:num=&quot;238.44086275392706&quot;

    x:fmla=&quot;=IF((D11-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D11-2005),$B$7,$B$18)/12*$B$13,
    0)&quot;&gt;&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr
    height=17 style='height:12.75pt'&gt;
    &lt;td
    class=xl15&gt;Tax Credit&lt;/td&gt;
    &lt;td class=xl28
    x:num=&quot;2000&quot;&gt;&lt;/td&gt;
    &lt;td height=17
    class=xl15 style='height:12.75pt'&gt;&lt;/td&gt;
    &lt;td
    class=xl15 x:num=&quot;2016&quot;
    x:fmla=&quot;=D11+1&quot;&gt;&lt;/td&gt;
    &lt;td class=xl25
    x:num=&quot;447.71192413571362&quot;
    x:fmla=&quot;=E11*(1+$B$10)&quot;&gt;&lt;/td&gt;
    &lt;td
    class=xl28 x:num=&quot;241.60222198562184&quot;

    x:fmla=&quot;=IF((D12-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D12-2005),$B$7,$B$18)/12*$B$13,
    0)&quot;&gt;&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr
    height=17 style='height:12.75pt'&gt;
    &lt;td
    class=xl15&gt;Marginal Tax Rate&lt;/td&gt;
    &lt;td class=xl24
    x:num=&quot;00.35&quot;&gt;&lt;/td&gt;
    &lt;td height=17
    class=xl15 style='height:12.75pt'&gt;&lt;/td&gt;
    &lt;td
    class=xl15 x:num=&quot;2017&quot;
    x:fmla=&quot;=D12+1&quot;&gt;&lt;/td&gt;
    &lt;td class=xl25
    x:num=&quot;474.57463958385648&quot;
    x:fmla=&quot;=E12*(1+$B$10)&quot;&gt;&lt;/td&gt;
    &lt;td
    class=xl28 x:num=&quot;244.95326277121833&quot;

    x:fmla=&quot;=IF((D13-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D13-2005),$B$7,$B$18)/12*$B$13,
    0)&quot;&gt;&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr
    height=17 style='height:12.75pt'&gt;
    &lt;td height=17
    colspan=3 class=xl15
    style='height:12.75pt;mso-ignore:colspan'&gt;&lt;/td&gt;

    &lt;td class=xl15 x:num=&quot;2018&quot;
    x:fmla=&quot;=D13+1&quot;&gt;&lt;/td&gt;
    &lt;td class=xl25
    x:num=&quot;503.0491179588879&quot;
    x:fmla=&quot;=E13*(1+$B$10)&quot;&gt;&lt;/td&gt;
    &lt;td
    class=xl28 x:num=&quot;248.5053660039506&quot;

    x:fmla=&quot;=IF((D14-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D14-2005),$B$7,$B$18)/12*$B$13,
    0)&quot;&gt;&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr
    height=17 style='height:12.75pt'&gt;
    &lt;td
    class=xl26&gt;Intermediate Calculations&lt;/td&gt;
    &lt;td
    height=17 colspan=2 class=xl15
    style='height:12.75pt;mso-ignore:colspan'&gt;&lt;/td&gt;

    &lt;td class=xl15 x:num=&quot;2019&quot;
    x:fmla=&quot;=D14+1&quot;&gt;&lt;/td&gt;
    &lt;td class=xl25
    x:num=&quot;533.2320650364212&quot;
    x:fmla=&quot;=E14*(1+$B$10)&quot;&gt;&lt;/td&gt;
    &lt;td
    class=xl28 x:num=&quot;252.27059543064684&quot;

    x:fmla=&quot;=IF((D15-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D15-2005),$B$7,$B$18)/12*$B$13,
    0)&quot;&gt;&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr
    height=17 style='height:12.75pt'&gt;
    &lt;td
    class=xl15&gt;Requried System Size (W AC)&lt;/td&gt;
    &lt;td
    class=xl27 x:num=&quot;6666.6666666666661&quot;
    x:fmla=&quot;=$B$2/$B$5*12/$B$9&quot;&gt;&lt;/td&gt;
    &lt;td
    height=17 class=xl15 style='height:12.75pt'&gt;&lt;/td&gt;

    &lt;td class=xl15 x:num=&quot;2020&quot;
    x:fmla=&quot;=D15+1&quot;&gt;&lt;/td&gt;
    &lt;td class=xl25
    x:num=&quot;565.22598893860652&quot;
    x:fmla=&quot;=E15*(1+$B$10)&quot;&gt;&lt;/td&gt;
    &lt;td
    class=xl28 x:num=&quot;256.26173862294479&quot;

    x:fmla=&quot;=IF((D16-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D16-2005),$B$7,$B$18)/12*$B$13,
    0)&quot;&gt;&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr
    height=17 style='height:12.75pt'&gt;
    &lt;td
    class=xl15&gt;System Cost&lt;/td&gt;
    &lt;td class=xl28
    x:num=&quot;60000&quot;
    x:fmla=&quot;=$B$16*$B$8&quot;&gt;&lt;/td&gt;
    &lt;td
    height=17 class=xl15 style='height:12.75pt'&gt;&lt;/td&gt;

    &lt;td class=xl15 x:num=&quot;2021&quot;
    x:fmla=&quot;=D16+1&quot;&gt;&lt;/td&gt;
    &lt;td class=xl25
    x:num=&quot;599.13954827492296&quot;
    x:fmla=&quot;=E16*(1+$B$10)&quot;&gt;&lt;/td&gt;
    &lt;td
    class=xl28 x:num=&quot;260.49235040678064&quot;

    x:fmla=&quot;=IF((D17-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D17-2005),$B$7,$B$18)/12*$B$13,
    0)&quot;&gt;&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr
    height=17 style='height:12.75pt'&gt;
    &lt;td
    class=xl15&gt;System Cost After Rebate and Tax
    Credit&lt;/td&gt;
    &lt;td class=xl28
    x:num=&quot;39333.333333333328&quot;
    x:fmla=&quot;=$B$17-$B$11*$B$16-$B$12&quot;&gt;&lt;/td&gt;

    &lt;td height=17 class=xl15
    style='height:12.75pt'&gt;&lt;/td&gt;
    &lt;td class=xl15
    x:num=&quot;2022&quot;
    x:fmla=&quot;=D17+1&quot;&gt;&lt;/td&gt;
    &lt;td class=xl25
    x:num=&quot;635.08792117141832&quot;
    x:fmla=&quot;=E17*(1+$B$10)&quot;&gt;&lt;/td&gt;
    &lt;td
    class=xl28 x:num=&quot;264.97679889764663&quot;

    x:fmla=&quot;=IF((D18-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D18-2005),$B$7,$B$18)/12*$B$13,
    0)&quot;&gt;&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr
    height=17 style='height:12.75pt'&gt;
    &lt;td
    class=xl15&gt;Monthly Payment&lt;/td&gt;
    &lt;td class=xl28
    x:num=&quot;285.77160342412401&quot;
    x:fmla=&quot;=-PMT($B$6,$B$7,$B$18)/12&quot;&gt;&lt;/td&gt;

    &lt;td height=17 class=xl15
    style='height:12.75pt'&gt;&lt;/td&gt;
    &lt;td class=xl15
    x:num=&quot;2023&quot;
    x:fmla=&quot;=D18+1&quot;&gt;&lt;/td&gt;
    &lt;td class=xl25
    x:num=&quot;673.19319644170344&quot;
    x:fmla=&quot;=E18*(1+$B$10)&quot;&gt;&lt;/td&gt;
    &lt;td
    class=xl28 x:num=&quot;269.73031429796458&quot;

    x:fmla=&quot;=IF((D19-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D19-2005),$B$7,$B$18)/12*$B$13,
    0)&quot;&gt;&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr
    height=17 style='height:12.75pt'&gt;
    &lt;td
    class=xl15&gt;After Tax Monthly Payment (Year 1)&lt;/td&gt;

    &lt;td class=xl28 x:num=&quot;216.9382700907907&quot;

    x:fmla=&quot;=$B$19+IPMT($B$10,1,$B$7,$B$18)*$B$13/12&quot;&gt;&lt;/td&gt;

    &lt;td height=17 class=xl15
    style='height:12.75pt'&gt;&lt;/td&gt;
    &lt;td class=xl15
    x:num=&quot;2024&quot;
    x:fmla=&quot;=D19+1&quot;&gt;&lt;/td&gt;
    &lt;td class=xl25
    x:num=&quot;713.58478822820564&quot;
    x:fmla=&quot;=E19*(1+$B$10)&quot;&gt;&lt;/td&gt;
    &lt;td
    class=xl28 x:num=&quot;274.76904062230165&quot;

    x:fmla=&quot;=IF((D20-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D20-2005),$B$7,$B$18)/12*$B$13,
    0)&quot;&gt;&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr
    height=17 style='height:12.75pt'&gt;
    &lt;td height=17
    colspan=3 class=xl15
    style='height:12.75pt;mso-ignore:colspan'&gt;&lt;/td&gt;

    &lt;td class=xl15 x:num=&quot;2025&quot;
    x:fmla=&quot;=D20+1&quot;&gt;&lt;/td&gt;
    &lt;td class=xl25
    x:num=&quot;756.39987552189802&quot;
    x:fmla=&quot;=E20*(1+$B$10)&quot;&gt;&lt;/td&gt;
    &lt;td
    class=xl28 x:num=&quot;280.11009052609887&quot;

    x:fmla=&quot;=IF((D21-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D21-2005),$B$7,$B$18)/12*$B$13,
    0)&quot;&gt;&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr
    height=17 style='height:12.75pt'&gt;
    &lt;td height=17
    colspan=3 class=xl15
    style='height:12.75pt;mso-ignore:colspan'&gt;&lt;/td&gt;

    &lt;td class=xl15 x:num=&quot;2026&quot;
    x:fmla=&quot;=D21+1&quot;&gt;&lt;/td&gt;
    &lt;td class=xl25
    x:num=&quot;801.7838680532119&quot;
    x:fmla=&quot;=E21*(1+$B$10)&quot;&gt;&lt;/td&gt;
    &lt;td
    class=xl28 x:num=&quot;0&quot;

    x:fmla=&quot;=IF((D22-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D22-2005),$B$7,$B$18)/12*$B$13,
    0)&quot;&gt;&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr
    height=17 style='height:12.75pt'&gt;
    &lt;td height=17
    colspan=3 class=xl15
    style='height:12.75pt;mso-ignore:colspan'&gt;&lt;/td&gt;

    &lt;td class=xl15 x:num=&quot;2027&quot;
    x:fmla=&quot;=D22+1&quot;&gt;&lt;/td&gt;
    &lt;td class=xl25
    x:num=&quot;849.89090013640464&quot;
    x:fmla=&quot;=E22*(1+$B$10)&quot;&gt;&lt;/td&gt;
    &lt;td
    class=xl28 x:num=&quot;0&quot;

    x:fmla=&quot;=IF((D23-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D23-2005),$B$7,$B$18)/12*$B$13,
    0)&quot;&gt;&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr
    height=17 style='height:12.75pt'&gt;
    &lt;td height=17
    colspan=3 class=xl15
    style='height:12.75pt;mso-ignore:colspan'&gt;&lt;/td&gt;

    &lt;td class=xl15 x:num=&quot;2028&quot;
    x:fmla=&quot;=D23+1&quot;&gt;&lt;/td&gt;
    &lt;td class=xl25
    x:num=&quot;900.884354144589&quot;
    x:fmla=&quot;=E23*(1+$B$10)&quot;&gt;&lt;/td&gt;
    &lt;td
    class=xl28 x:num=&quot;0&quot;

    x:fmla=&quot;=IF((D24-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D24-2005),$B$7,$B$18)/12*$B$13,
    0)&quot;&gt;&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr
    height=17 style='height:12.75pt'&gt;
    &lt;td height=17
    colspan=3 class=xl15
    style='height:12.75pt;mso-ignore:colspan'&gt;&lt;/td&gt;

    &lt;td class=xl15 x:num=&quot;2029&quot;
    x:fmla=&quot;=D24+1&quot;&gt;&lt;/td&gt;
    &lt;td class=xl25
    x:num=&quot;954.93741539326436&quot;
    x:fmla=&quot;=E24*(1+$B$10)&quot;&gt;&lt;/td&gt;
    &lt;td
    class=xl28 x:num=&quot;0&quot;

    x:fmla=&quot;=IF((D25-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D25-2005),$B$7,$B$18)/12*$B$13,
    0)&quot;&gt;&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr
    height=17 style='height:12.75pt'&gt;
    &lt;td height=17
    colspan=3 class=xl15
    style='height:12.75pt;mso-ignore:colspan'&gt;&lt;/td&gt;

    &lt;td class=xl15 x:num=&quot;2030&quot;
    x:fmla=&quot;=D25+1&quot;&gt;&lt;/td&gt;
    &lt;td class=xl25
    x:num=&quot;1012.2336603168603&quot;
    x:fmla=&quot;=E25*(1+$B$10)&quot;&gt;&lt;/td&gt;
    &lt;td
    class=xl28 x:num=&quot;0&quot;

    x:fmla=&quot;=IF((D26-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D26-2005),$B$7,$B$18)/12*$B$13,
    0)&quot;&gt;&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr
    height=17 style='height:12.75pt'&gt;
    &lt;td height=17
    colspan=3 class=xl15
    style='height:12.75pt;mso-ignore:colspan'&gt;&lt;/td&gt;

    &lt;td class=xl15 x:num=&quot;2031&quot;
    x:fmla=&quot;=D26+1&quot;&gt;&lt;/td&gt;
    &lt;td class=xl25
    x:num=&quot;1072.967679935872&quot;
    x:fmla=&quot;=E26*(1+$B$10)&quot;&gt;&lt;/td&gt;
    &lt;td
    class=xl28 x:num=&quot;0&quot;

    x:fmla=&quot;=IF((D27-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D27-2005),$B$7,$B$18)/12*$B$13,
    0)&quot;&gt;&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr
    height=17 style='height:12.75pt'&gt;
    &lt;td height=17
    colspan=3 class=xl15
    style='height:12.75pt;mso-ignore:colspan'&gt;&lt;/td&gt;

    &lt;td class=xl15 x:num=&quot;2032&quot;
    x:fmla=&quot;=D27+1&quot;&gt;&lt;/td&gt;
    &lt;td class=xl25
    x:num=&quot;1137.3457407320243&quot;
    x:fmla=&quot;=E27*(1+$B$10)&quot;&gt;&lt;/td&gt;
    &lt;td
    class=xl28 x:num=&quot;0&quot;

    x:fmla=&quot;=IF((D28-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D28-2005),$B$7,$B$18)/12*$B$13,
    0)&quot;&gt;&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr
    height=17 style='height:12.75pt'&gt;
    &lt;td height=17
    colspan=3 class=xl15
    style='height:12.75pt;mso-ignore:colspan'&gt;&lt;/td&gt;

    &lt;td class=xl15 x:num=&quot;2033&quot;
    x:fmla=&quot;=D28+1&quot;&gt;&lt;/td&gt;
    &lt;td class=xl25
    x:num=&quot;1205.5864851759459&quot;
    x:fmla=&quot;=E28*(1+$B$10)&quot;&gt;&lt;/td&gt;
    &lt;td
    class=xl28 x:num=&quot;0&quot;

    x:fmla=&quot;=IF((D29-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D29-2005),$B$7,$B$18)/12*$B$13,
    0)&quot;&gt;&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr
    height=17 style='height:12.75pt'&gt;
    &lt;td height=17
    colspan=3 class=xl15
    style='height:12.75pt;mso-ignore:colspan'&gt;&lt;/td&gt;

    &lt;td class=xl15 x:num=&quot;2034&quot;
    x:fmla=&quot;=D29+1&quot;&gt;&lt;/td&gt;
    &lt;td class=xl25
    x:num=&quot;1277.9216742865026&quot;
    x:fmla=&quot;=E29*(1+$B$10)&quot;&gt;&lt;/td&gt;
    &lt;td
    class=xl28 x:num=&quot;0&quot;

    x:fmla=&quot;=IF((D30-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D30-2005),$B$7,$B$18)/12*$B$13,
    0)&quot;&gt;&lt;/td&gt;
    &lt;/tr&gt;
    &lt;tr
    height=17 style='height:12.75pt'&gt;
    &lt;td height=17
    colspan=3 class=xl15
    style='height:12.75pt;mso-ignore:colspan'&gt;&lt;/td&gt;

    &lt;td class=xl15 x:num=&quot;2035&quot;
    x:fmla=&quot;=D30+1&quot;&gt;&lt;/td&gt;
    &lt;td class=xl25
    x:num=&quot;1354.5969747436927&quot;
    x:fmla=&quot;=E30*(1+$B$10)&quot;&gt;&lt;/td&gt;
    &lt;td
    class=xl28 x:num=&quot;0&quot;

    x:fmla=&quot;=IF((D31-2006)&amp;lt;$B$7,$B$19+IPMT($B$6,(D31-2005),$B$7,$B$18)/12*$B$13,
    0)&quot;&gt;&lt;/td&gt;

    &lt;/tr&gt;
    &lt;/table&gt;

    &lt;/body&gt;

    &lt;/html&gt;
    ">
    </object>

    my requirement is how to change a cell value in this object through
    javascript.Please send me the javascript code to change the cell value

    Thanks,
    Srinivas.M
    srinivas, Oct 22, 2005
    #4
  5. srinivas Guest

    Hi,

    Evertjan thanks for responding i posted the object code and what i
    required.Please tell me how to access that interactive html excel
    object through javascript.

    Thanks,
    Srinivas
    srinivas, Oct 22, 2005
    #5
  6. srinivas Guest

    Hi mscir,

    Thanks for responding for my question.the requirement
    is how to access the interactive html workbook object from javascript.

    Thanks,
    Srinivas
    srinivas, Oct 22, 2005
    #6
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. =?Utf-8?B?RGljazIwMDQ=?=

    how does the freetextbox interact with other html elements??

    =?Utf-8?B?RGljazIwMDQ=?=, Nov 3, 2004, in forum: ASP .Net
    Replies:
    0
    Views:
    349
    =?Utf-8?B?RGljazIwMDQ=?=
    Nov 3, 2004
  2. WJ
    Replies:
    2
    Views:
    477
  3. =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=

    Problem with Excel reports ::::Excel 2003 Migration To Excel 2007

    =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=, Oct 5, 2007, in forum: ASP .Net
    Replies:
    15
    Views:
    1,486
    =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=
    Oct 24, 2007
  4. McKirahan

    HTML table in Excel with line feed in cell

    McKirahan, Nov 26, 2006, in forum: ASP General
    Replies:
    6
    Views:
    208
    McKirahan
    Dec 4, 2006
  5. Replies:
    1
    Views:
    83
    srinivas
    Oct 24, 2005
Loading...

Share This Page