Quick script needed 3 schoool!
ok so i coded this thing in excel using autosum things and now i just need some boxes where they can enter a number so it autosums and gives an answer.
Here is script:
HTML Code:
<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
<meta name=ProgId content=Excel.Sheet>
<meta name=Generator content="Microsoft Excel 11">
<link rel=File-List href="bath_files/filelist.xml">
<link rel=Edit-Time-Data href="bath_files/editdata.mso">
<link rel=OLE-Object-Data href="bath_files/oledata.mso">
<!--[if gte mso 9]><xml>
<o:DocumentProperties>
<o:Author>André Hamon</o:Author>
<o:LastAuthor>André Hamon</o:LastAuthor>
<o:LastPrinted>2007-06-21T07:00:17Z</o:LastPrinted>
<o:Created>2007-06-21T04:34:38Z</o:Created>
<o:LastSaved>2007-06-21T07:04:47Z</o:LastSaved>
<o:Company>Home Computer</o:Company>
<o:Version>11.8132</o:Version>
</o:DocumentProperties>
</xml><![endif]-->
<style>
<!--table
{mso-displayed-decimal-separator:"\.";
mso-displayed-thousand-separator:"\,";}
@page
{margin:1.0in .75in 1.0in 2.76in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-page-orientation:landscape;}
tr
{mso-height-source:auto;}
col
{mso-width-source:auto;}
br
{mso-data-placement:same-cell;}
.style0
{mso-number-format:General;
text-align:general;
vertical-align:bottom;
white-space:nowrap;
mso-rotate:0;
mso-background-source:auto;
mso-pattern:auto;
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;
border:none;
mso-protection:locked visible;
mso-style-name:Normal;
mso-style-id:0;}
td
{mso-style-parent:style0;
padding-top:1px;
padding-right:1px;
padding-left:1px;
mso-ignore:padding;
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;}
.xl24
{mso-style-parent:style0;
font-size:18.0pt;
font-weight:700;
font-family:Verdana, sans-serif;
mso-font-charset:0;
text-align:center;}
.xl25
{mso-style-parent:style0;
font-family:Verdana, sans-serif;
mso-font-charset:0;}
.xl26
{mso-style-parent:style0;
font-family:Verdana, sans-serif;
mso-font-charset:0;
text-align:right;}
.xl27
{mso-style-parent:style0;
font-family:Verdana, sans-serif;
mso-font-charset:0;
mso-number-format:"\#\,\#\#0";
text-align:left;}
.xl28
{mso-style-parent:style0;
font-family:Verdana, sans-serif;
mso-font-charset:0;
mso-number-format:"\#\,\#\#0";
text-align:center;}
.xl29
{mso-style-parent:style0;
font-family:Verdana, sans-serif;
mso-font-charset:0;
mso-number-format:"\#\,\#\#0";}
.xl30
{mso-style-parent:style0;
font-family:Verdana, sans-serif;
mso-font-charset:0;
text-align:center;}
.xl31
{mso-style-parent:style0;
font-family:Verdana, sans-serif;
mso-font-charset:0;
mso-number-format:"\#\,\#\#0";
text-align:right;}
.xl32
{mso-style-parent:style0;
font-family:Verdana, sans-serif;
mso-font-charset:0;
mso-number-format:Fixed;}
.xl33
{mso-style-parent:style0;
font-family:Verdana, sans-serif;
mso-font-charset:0;
mso-number-format:Fixed;
text-align:right;}
.xl34
{mso-style-parent:style0;
font-family:Verdana, sans-serif;
mso-font-charset:0;
text-align:left;}
.xl35
{mso-style-parent:style0;
font-family:Verdana, sans-serif;
mso-font-charset:0;
mso-number-format:"\#\,\#\#0\.0";
text-align:center;}
-->
</style>
<!--[if gte mso 9]><xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:Name>Sheet1</x:Name>
<x:WorksheetOptions>
<x:Print>
<x:ValidPrinterInfo/>
<x:PaperSizeIndex>9</x:PaperSizeIndex>
<x:HorizontalResolution>200</x:HorizontalResolution>
<x:VerticalResolution>200</x:VerticalResolution>
<x:NumberofCopies>0</x:NumberofCopies>
</x:Print>
<x:PageBreakZoom>100</x:PageBreakZoom>
<x:Selected/>
<x:Panes>
<x:Pane>
<x:Number>3</x:Number>
<x:ActiveRow>6</x:ActiveRow>
<x:ActiveCol>4</x:ActiveCol>
</x:Pane>
</x:Panes>
<x:ProtectContents>False</x:ProtectContents>
<x:ProtectObjects>False</x:ProtectObjects>
<x:ProtectScenarios>False</x:ProtectScenarios>
</x:WorksheetOptions>
</x:ExcelWorksheet>
<x:ExcelWorksheet>
<x:Name>Sheet2</x:Name>
<x:WorksheetOptions>
<x:ProtectContents>False</x:ProtectContents>
<x:ProtectObjects>False</x:ProtectObjects>
<x:ProtectScenarios>False</x:ProtectScenarios>
</x:WorksheetOptions>
</x:ExcelWorksheet>
<x:ExcelWorksheet>
<x:Name>Sheet3</x:Name>
<x:WorksheetOptions>
<x:ProtectContents>False</x:ProtectContents>
<x:ProtectObjects>False</x:ProtectObjects>
<x:ProtectScenarios>False</x:ProtectScenarios>
</x:WorksheetOptions>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
<x:WindowHeight>9210</x:WindowHeight>
<x:WindowWidth>11355</x:WindowWidth>
<x:WindowTopX>480</x:WindowTopX>
<x:WindowTopY>30</x:WindowTopY>
<x:ProtectStructure>False</x:ProtectStructure>
<x:ProtectWindows>False</x:ProtectWindows>
</x:ExcelWorkbook>
</xml><![endif]-->
</head>
<body link=blue vlink=purple class=xl25>
<table x:str border=0 cellpadding=0 cellspacing=0 width=627 style='border-collapse:
collapse;table-layout:fixed;width:470pt'>
<col class=xl25 width=151 style='mso-width-source:userset;mso-width-alt:5522;
width:113pt'>
<col class=xl25 width=92 style='mso-width-source:userset;mso-width-alt:3364;
width:69pt'>
<col class=xl25 width=64 span=6 style='width:48pt'>
<tr height=30 style='height:22.5pt'>
<td colspan=7 height=30 class=xl24 width=563 style='height:22.5pt;width:422pt'>~Filling
the bath!~</td>
<td class=xl25 width=64 style='width:48pt'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=8 class=xl25 style='height:12.75pt;mso-ignore:colspan'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl25 style='height:12.75pt'>Bathroom Size:</td>
<td colspan=7 class=xl25 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl25 style='height:12.75pt'></td>
<td class=xl26>Height:</td>
<td class=xl34 x:num>0</td>
<td colspan=5 class=xl25 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl25 style='height:12.75pt'></td>
<td class=xl26>Length:</td>
<td class=xl34 x:num>0</td>
<td colspan=5 class=xl25 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl25 style='height:12.75pt'></td>
<td class=xl26>Width:</td>
<td class=xl34 x:num>0</td>
<td colspan=5 class=xl25 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=8 class=xl25 style='height:12.75pt;mso-ignore:colspan'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl25 style='height:12.75pt'>Total room size: (m³)</td>
<td class=xl25></td>
<td class=xl25 align=right x:num x:fmla="=C6*C5*C4">0</td>
<td class=xl25>m³</td>
<td colspan=4 class=xl25 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=8 class=xl25 style='height:12.75pt;mso-ignore:colspan'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl25 colspan=3 style='height:12.75pt;mso-ignore:colspan'>There
is 1,000 litres in a cubic metre.</td>
<td colspan=5 class=xl25 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=8 class=xl25 style='height:12.75pt;mso-ignore:colspan'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl26 style='height:12.75pt'>So:</td>
<td class=xl25 align=right x:num x:fmla="=C8">0</td>
<td class=xl25>x 1,000 =</td>
<td class=xl27 x:num x:fmla="=B12*1000">0</td>
<td colspan=4 class=xl25 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl26 style='height:12.75pt'></td>
<td colspan=7 class=xl25 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl26 style='height:12.75pt'>My bathroom holds:</td>
<td class=xl28 x:num x:fmla="=D12">0</td>
<td class=xl25 colspan=2 style='mso-ignore:colspan'>Litres of water!</td>
<td colspan=4 class=xl25 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=8 class=xl25 style='height:12.75pt;mso-ignore:colspan'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl26 style='height:12.75pt'>It takes</td>
<td class=xl25 align=right x:num>1.5</td>
<td class=xl25 colspan=3 style='mso-ignore:colspan'>seconds to fill 1 litre.</td>
<td colspan=3 class=xl25 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=8 class=xl25 style='height:12.75pt;mso-ignore:colspan'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl26 style='height:12.75pt'>So:</td>
<td class=xl29 align=right x:num x:fmla="=B14">0</td>
<td class=xl30>x</td>
<td class=xl35 x:num x:fmla="=B16">1.5</td>
<td class=xl30><span style='mso-spacerun:yes'> </span>=</td>
<td class=xl25 align=right x:num x:fmla="=B18*D18">0</td>
<td colspan=2 class=xl25 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=8 class=xl25 style='height:12.75pt;mso-ignore:colspan'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl26 style='height:12.75pt'>It takes:</td>
<td class=xl29 align=right x:num x:fmla="=F18">0</td>
<td class=xl25 colspan=4 style='mso-ignore:colspan'>seconds to fill my
bathroom!</td>
<td colspan=2 class=xl25 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=8 class=xl25 style='height:12.75pt;mso-ignore:colspan'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl25 colspan=7 style='height:12.75pt;mso-ignore:colspan'>To
find how long it takes in hours we divide it by 60 and then by 60 again.</td>
<td class=xl25></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=8 class=xl25 style='height:12.75pt;mso-ignore:colspan'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl26 style='height:12.75pt'>So:</td>
<td class=xl31 x:num x:fmla="=B20">0</td>
<td class=xl25>÷ 60 =</td>
<td class=xl29 align=right x:num x:fmla="=B24/60">0</td>
<td class=xl25>÷ 60 =</td>
<td class=xl32 align=right x:num x:fmla="=D24/60">0.00</td>
<td colspan=2 class=xl25 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl25 style='height:12.75pt'></td>
<td class=xl30></td>
<td colspan=6 class=xl25 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl26 style='height:12.75pt'>It takes approximately:</td>
<td class=xl33 x:num x:fmla="=F24">0.00</td>
<td class=xl25 colspan=3 style='mso-ignore:colspan'>hours to fill my
bathroom!</td>
<td colspan=3 class=xl25 style='mso-ignore:colspan'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 colspan=8 class=xl25 style='height:12.75pt;mso-ignore:colspan'></td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl25 colspan=2 style='height:12.75pt;mso-ignore:colspan'>So,
in conclusion it would take arou<span style='display:none'>nd</span></td>
<td class=xl33 x:num x:fmla="=B26">0.00</td>
<td class=xl25 colspan=5 style='mso-ignore:colspan'>hours to fill my
bathroom, which holds</td>
</tr>
<tr height=17 style='height:12.75pt'>
<td height=17 class=xl25 style='height:12.75pt'></td>
<td class=xl26>about</td>
<td class=xl28 x:num x:fmla="=B14">0</td>
<td class=xl25>litres!</td>
<td colspan=4 class=xl25 style='mso-ignore:colspan'></td>
</tr>
<![if supportMisalignedColumns]>
<tr height=0 style='display:none'>
<td width=151 style='width:113pt'></td>
<td width=92 style='width:69pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
<td width=64 style='width:48pt'></td>
</tr>
<![endif]>
</table>
</body>
</html>
The things in bold red need to be made into a text area where they can enter their own numbers.
Then they push submit and it comes up like this:
~Filling the bath!~
Bathroom Size:
Height: 0
Length: 0
Width: 0
Total room size: (m³)
0 m³
There is 1,000 litres in a cubic metre.
So: 0 x 1,000 = 0
My bathroom holds: 0 Litres of water!
It takes 1.5 seconds to fill 1 litre.
So: 0 x 1.5 = 0
It takes: 0 seconds to fill my bathroom!
To find how long it takes in hours we divide it by 60 and then by 60 again.
So: 0 ÷ 60 = 0 ÷ 60 = 0.00
It takes approximately: 0.00 hours to fill my bathroom!
So, in conclusion it would take aroundnd 0.00 hours to fill my bathroom, which holds
about 0 litres!
And where the 0's are is the proper numbers that it's worked out using autosum
Ok so it isn't a quick script but whoever can do this for me wont be left unrewarded ;)
