Quick script needed 3 schoool!

Verrou · 21-06-2007, 07:33 AM

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

Thread: Quick script needed 3 schoool!

Thread Tools

Quick script needed 3 schoool!

Posting Permissions