Rounding in QUIZ
Robert Mills
robert.mills@windsong-services.co.uk
Mon, 4 Aug 2003 17:15:01 +0100
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C35AA3.8E5F86A0
Content-Type: text/plain;
charset="iso-8859-1"
Nick,
Jeff (Davis) says 'thanks for the answer'. He also said something else but I
refuse to pass that on <G>.
regards,
Robert W.Mills
Systems Development Manager
Windsong Services
(01689) 870622 x3005
-----Original Message-----
From: Butland, Nick [mailto:nick.butland@acco-uk.co.uk]
Sent: 04 August 2003 17:01
To: 'Robert Mills'; PowerHouse Mail List (E-mail)
Subject: RE: Rounding in QUIZ
Try this:
Def d_1 = 6
Def d_2 = 8
Def d_1_rnd = 5 * round(d_1/5)
Def d_2_rnd = 5 * round(d_2/5)
Cheers,
Nick Butland
IT Project Leader, ACCO UK
Telephone 01296-732150
Fax 01296-732151
-----Original Message-----
From: Robert Mills [mailto:robert.mills@windsong-services.co.uk]
Sent: Monday, August 04, 2003 4:43 PM
To: PowerHouse Mail List (E-mail)
Subject: Rounding in QUIZ
Have just been asked if there is a way to make Quiz 'Round' an item to the
nearest 5 (five).
Any suggestions?
regards,
Robert W.Mills
Systems Development Manager
Windsong Services
(01689) 870622 x3005
------_=_NextPart_001_01C35AA3.8E5F86A0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns=3D"http://www.w3.org/TR/REC-html40" xmlns:o =3D=20
"urn:schemas-microsoft-com:office:office" xmlns:w =3D=20
"urn:schemas-microsoft-com:office:word"><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<TITLE>Rounding in QUIZ</TITLE>
<META content=3DWord.Document name=3DProgId>
<META content=3D"MSHTML 6.00.2800.1141" name=3DGENERATOR>
<META content=3D"Microsoft Word 9" name=3DOriginator><LINK=20
href=3D"cid:filelist.xml@01C35AA9.BA440A60" rel=3DFile-List><!--[if gte =
mso 9]><xml>
<o:OfficeDocumentSettings>
<o:DoNotRelyOnCSS/>
</o:OfficeDocumentSettings>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:Zoom>0</w:Zoom>
<w:DocumentKind>DocumentEmail</w:DocumentKind>
<w:EnvelopeVis/>
<w:Compatibility>
<w:ForgetLastTabAlignment/>
<w:DoNotUseHTMLParagraphAutoSpacing/>
</w:Compatibility>
</w:WordDocument>
</xml><![endif]-->
<STYLE>@font-face {
font-family: Garamond;
}
@font-face {
font-family: Tahoma;
}
@page Section1 {size: 595.3pt 841.9pt; margin: 72.0pt 90.0pt 72.0pt =
90.0pt; mso-header-margin: 36.0pt; mso-footer-margin: 36.0pt; =
mso-paper-source: 0; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; =
mso-style-parent: ""; mso-pagination: widow-orphan; =
mso-fareast-font-family: "Times New Roman"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; =
mso-style-parent: ""; mso-pagination: widow-orphan; =
mso-fareast-font-family: "Times New Roman"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; =
mso-style-parent: ""; mso-pagination: widow-orphan; =
mso-fareast-font-family: "Times New Roman"
}
P.MsoAutoSig {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; =
mso-pagination: widow-orphan; mso-fareast-font-family: "Times New =
Roman"
}
LI.MsoAutoSig {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; =
mso-pagination: widow-orphan; mso-fareast-font-family: "Times New =
Roman"
}
DIV.MsoAutoSig {
FONT-SIZE: 12pt; MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Times New Roman"; =
mso-pagination: widow-orphan; mso-fareast-font-family: "Times New =
Roman"
}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0cm; MARGIN-RIGHT: 0cm; FONT-FAMILY: =
"Times New Roman"; mso-pagination: widow-orphan; =
mso-fareast-font-family: "Times New Roman"; mso-margin-top-alt: auto; =
mso-margin-bottom-alt: auto
}
SPAN.EmailStyle16 {
FONT-WEIGHT: normal; COLOR: navy; FONT-STYLE: normal; mso-style-type: =
personal-reply; mso-ansi-font-size: 12.0pt; mso-ascii-font-family: =
Garamond; mso-hansi-font-family: Garamond; mso-bidi-font-family: Arial
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=3DEN-GB style=3D"tab-interval: 36.0pt">
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D695290916-04082003>Nick,=20
</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D695290916-04082003></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D695290916-04082003></SPAN></FONT><FONT face=3DArial =
color=3D#0000ff=20
size=3D2><SPAN class=3D695290916-04082003>Jeff (Davis) says 'thanks for =
the answer'.=20
He also said something else but I refuse to pass that on=20
<G>.</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D695290916-04082003></SPAN></FONT><FONT face=3DArial =
color=3D#0000ff=20
size=3D2><SPAN class=3D695290916-04082003></SPAN></FONT> </DIV>
<DIV><FONT face=3D"Comic Sans MS" size=3D2>regards,</FONT></DIV>
<DIV><FONT face=3D"Comic Sans MS" size=3D2></FONT> </DIV>
<DIV><FONT face=3D"Comic Sans MS" size=3D2>Robert W.Mills</FONT></DIV>
<DIV><FONT face=3D"Comic Sans MS" size=3D2>Systems Development =
Manager</FONT></DIV>
<DIV><FONT face=3D"Comic Sans MS" size=3D2>Windsong Services</FONT></DIV=
>
<DIV><FONT face=3D"Comic Sans MS" size=3D2>(01689) 870622 =
x3005</FONT></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
size=3D2>-----Original Message-----<BR><B>From:</B> Butland, Nick=20
[mailto:nick.butland@acco-uk.co.uk]<BR><B>Sent:</B> 04 August 2003=20
17:01<BR><B>To:</B> 'Robert Mills'; PowerHouse Mail List=20
(E-mail)<BR><B>Subject:</B> RE: Rounding in QUIZ<BR><BR></FONT></DIV>
<DIV class=3DSection1>
<P class=3DMsoNormal><SPAN class=3DEmailStyle16><FONT face=3DGaramond =
color=3Dnavy=20
size=3D3><SPAN style=3D"FONT-SIZE: 12pt; FONT-FAMILY: Garamond">Try=20
this:<o:p></o:p></SPAN></FONT></SPAN></P>
<P class=3DMsoNormal><SPAN class=3DEmailStyle16><FONT face=3DGaramond =
color=3Dnavy=20
size=3D3><SPAN style=3D"FONT-SIZE: 12pt; FONT-FAMILY: Garamond"><![if =
!supportEmptyParas]><![endif]> <o:p></o:p></SPAN></FONT></SPAN></P>=
<P class=3DMsoNormal><SPAN class=3DEmailStyle16><FONT face=3DGaramond =
color=3Dnavy=20
size=3D3><SPAN style=3D"FONT-SIZE: 12pt; FONT-FAMILY: Garamond">Def =
d_1 =3D=20
6<o:p></o:p></SPAN></FONT></SPAN></P>
<P class=3DMsoNormal><SPAN class=3DEmailStyle16><FONT face=3DGaramond =
color=3Dnavy=20
size=3D3><SPAN style=3D"FONT-SIZE: 12pt; FONT-FAMILY: Garamond">Def =
d_2 =3D=20
8<o:p></o:p></SPAN></FONT></SPAN></P>
<P class=3DMsoNormal><SPAN class=3DEmailStyle16><FONT face=3DGaramond =
color=3Dnavy=20
size=3D3><SPAN style=3D"FONT-SIZE: 12pt; FONT-FAMILY: Garamond"><![if =
!supportEmptyParas]><![endif]> <o:p></o:p></SPAN></FONT></SPAN></P>=
<P class=3DMsoNormal><SPAN class=3DEmailStyle16><FONT face=3DGaramond =
color=3Dnavy=20
size=3D3><SPAN style=3D"FONT-SIZE: 12pt; FONT-FAMILY: Garamond">Def =
d_1_rnd =3D 5 *=20
round(d_1/5)<o:p></o:p></SPAN></FONT></SPAN></P>
<P class=3DMsoNormal><SPAN class=3DEmailStyle16><FONT face=3DGaramond =
color=3Dnavy=20
size=3D3><SPAN style=3D"FONT-SIZE: 12pt; FONT-FAMILY: Garamond">Def =
d_2_rnd =3D 5 *=20
round(d_2/5)<o:p></o:p></SPAN></FONT></SPAN></P>
<P class=3DMsoNormal><SPAN class=3DEmailStyle16><FONT face=3DGaramond =
color=3Dnavy=20
size=3D3><SPAN style=3D"FONT-SIZE: 12pt; FONT-FAMILY: Garamond"><![if =
!supportEmptyParas]><![endif]> <o:p></o:p></SPAN></FONT></SPAN></P>=
<P class=3DMsoNormal><!--[if supportFields]><span =
class=3DEmailStyle16><font=20
color=3Dnavy face=3DGaramond><span style=3D'font-family:Garamond'><span =
style=3D'mso-element:field-begin'></span><span style=3D"mso-spacerun:=20
yes"> </span>AUTOTEXTLIST \s "E-mail Signature" <span=20
style=3D'mso-element:field-separator'></span></span></font></span><![end=
if]--><FONT=20
face=3DGaramond color=3Dnavy><SPAN=20
style=3D"LAYOUT-GRID-MODE: line; COLOR: navy; FONT-FAMILY: Garamond; =
mso-color-alt: windowtext"><o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DGaramond color=3Dnavy =
size=3D5><SPAN=20
style=3D"FONT-SIZE: 16pt; LAYOUT-GRID-MODE: line; COLOR: navy; =
FONT-FAMILY: Garamond; mso-bidi-font-size: =
12.0pt">Cheers,</SPAN></FONT><FONT=20
face=3DGaramond color=3Dnavy size=3D5><SPAN=20
style=3D"FONT-SIZE: 16pt; LAYOUT-GRID-MODE: line; COLOR: navy; =
FONT-FAMILY: Garamond; mso-color-alt: windowtext; mso-bidi-font-size: =
12.0pt"><o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DGaramond color=3Dnavy =
size=3D5><SPAN=20
style=3D"FONT-SIZE: 16pt; LAYOUT-GRID-MODE: line; COLOR: navy; =
FONT-FAMILY: Garamond; mso-bidi-font-size: 12.0pt">Nick=20
Butland</SPAN></FONT><FONT face=3DGaramond color=3Dnavy =
size=3D4><SPAN=20
style=3D"FONT-SIZE: 14pt; LAYOUT-GRID-MODE: line; COLOR: navy; =
FONT-FAMILY: Garamond; mso-color-alt: windowtext; mso-bidi-font-size: =
12.0pt"><o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DGaramond color=3Dnavy =
size=3D4><SPAN=20
style=3D"FONT-SIZE: 14pt; LAYOUT-GRID-MODE: line; COLOR: navy; =
FONT-FAMILY: Garamond; mso-bidi-font-size: 12.0pt">IT=20
Project Leader, ACCO UK</SPAN></FONT><FONT face=3DGaramond =
color=3Dnavy=20
size=3D4><SPAN=20
style=3D"FONT-SIZE: 14pt; LAYOUT-GRID-MODE: line; COLOR: navy; =
FONT-FAMILY: Garamond; mso-color-alt: windowtext; mso-bidi-font-size: =
12.0pt"><o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DGaramond color=3Dnavy =
size=3D4><SPAN=20
style=3D"FONT-SIZE: 14pt; LAYOUT-GRID-MODE: line; COLOR: navy; =
FONT-FAMILY: Garamond; mso-bidi-font-size: 12.0pt"><![if =
!supportEmptyParas]><![endif]> </SPAN></FONT><FONT=20
face=3DGaramond color=3Dnavy size=3D4><SPAN=20
style=3D"FONT-SIZE: 14pt; LAYOUT-GRID-MODE: line; COLOR: navy; =
FONT-FAMILY: Garamond; mso-color-alt: windowtext; mso-bidi-font-size: =
12.0pt"><o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DGaramond color=3Dnavy =
size=3D4><SPAN=20
style=3D"FONT-SIZE: 14pt; LAYOUT-GRID-MODE: line; COLOR: navy; =
FONT-FAMILY: Garamond; mso-bidi-font-size: 12.0pt">Telephone=20
01296-732150</SPAN></FONT><FONT face=3DGaramond color=3Dnavy =
size=3D4><SPAN=20
style=3D"FONT-SIZE: 14pt; LAYOUT-GRID-MODE: line; COLOR: navy; =
FONT-FAMILY: Garamond; mso-color-alt: windowtext; mso-bidi-font-size: =
12.0pt"><o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><FONT face=3DGaramond color=3Dnavy =
size=3D4><SPAN=20
style=3D"FONT-SIZE: 14pt; LAYOUT-GRID-MODE: line; COLOR: navy; =
FONT-FAMILY: Garamond; mso-bidi-font-size: 12.0pt">Fax<SPAN=20
style=3D"mso-tab-count: =
2"> &nb=
sp; =20
</SPAN>01296-732151</SPAN></FONT><FONT face=3DGaramond color=3Dnavy =
size=3D4><SPAN=20
style=3D"FONT-SIZE: 14pt; LAYOUT-GRID-MODE: line; COLOR: navy; =
FONT-FAMILY: Garamond; mso-color-alt: windowtext; mso-bidi-font-size: =
12.0pt"><o:p></o:p></SPAN></FONT></P>
<P class=3DMsoNormal><!--[if supportFields]><span =
class=3DEmailStyle16><font=20
color=3Dnavy face=3DGaramond><span style=3D'font-family:Garamond'><span =
style=3D'mso-element:field-end'></span></span></font></span><![endif]-->=
<SPAN=20
class=3DEmailStyle16><FONT face=3DGaramond color=3Dnavy><SPAN=20
style=3D"FONT-FAMILY: Garamond"><![if =
!supportEmptyParas]><![endif]> <o:p></o:p></SPAN></FONT></SPAN></P>=
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 36pt"><FONT face=3DTahoma =
color=3Dblack=20
size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: =
Tahoma">-----Original=20
Message-----<BR><B><SPAN style=3D"FONT-WEIGHT: bold">From:</SPAN></B> =
Robert=20
Mills [mailto:robert.mills@windsong-services.co.uk]<BR><B><SPAN=20
style=3D"FONT-WEIGHT: bold">Sent:</SPAN></B> Monday, August 04, 2003 =
4:43=20
PM<BR><B><SPAN style=3D"FONT-WEIGHT: bold">To:</SPAN></B> PowerHouse =
Mail List=20
(E-mail)<BR><B><SPAN style=3D"FONT-WEIGHT: bold">Subject:</SPAN></B> =
Rounding in=20
QUIZ</SPAN></FONT></P>
<P class=3DMsoNormal style=3D"MARGIN-LEFT: 36pt"><FONT face=3D"Times =
New Roman"=20
size=3D3><SPAN=20
style=3D"FONT-SIZE: 12pt"><![if =
!supportEmptyParas]><![endif]> <o:p></o:p></SPAN></FONT></P>
<P style=3D"MARGIN-LEFT: 36pt"><FONT face=3D"Times New Roman" =
color=3Dblack=20
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; COLOR: black">Have just been =
asked if=20
there is a way to make Quiz 'Round' an item to the nearest 5=20
(five).</SPAN></FONT><FONT color=3Dblack><SPAN style=3D"COLOR: =
black">=20
</SPAN></FONT><FONT color=3Dblack><SPAN=20
style=3D"COLOR: black; mso-color-alt: =
windowtext"><o:p></o:p></SPAN></FONT></P>
<P style=3D"MARGIN-LEFT: 36pt"><FONT face=3D"Times New Roman" =
color=3Dblack=20
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; COLOR: black">Any=20
suggestions?</SPAN></FONT><FONT color=3Dblack><SPAN style=3D"COLOR: =
black">=20
</SPAN></FONT><FONT color=3Dblack><SPAN=20
style=3D"COLOR: black; mso-color-alt: =
windowtext"><o:p></o:p></SPAN></FONT></P>
<P style=3D"MARGIN-LEFT: 36pt"><FONT face=3D"Times New Roman" =
color=3Dblack=20
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; COLOR: =
black">regards,</SPAN></FONT><FONT=20
color=3Dblack><SPAN style=3D"COLOR: black"> </SPAN></FONT><FONT =
color=3Dblack><SPAN=20
style=3D"COLOR: black; mso-color-alt: =
windowtext"><o:p></o:p></SPAN></FONT></P>
<P style=3D"MARGIN-LEFT: 36pt"><FONT face=3D"Times New Roman" =
color=3Dblack=20
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; COLOR: black">Robert=20
W.Mills</SPAN></FONT><FONT color=3Dblack><SPAN style=3D"COLOR: =
black">=20
<BR></SPAN></FONT><FONT color=3Dblack size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: black">Systems Development=20
Manager</SPAN></FONT><FONT color=3Dblack><SPAN style=3D"COLOR: =
black">=20
<BR></SPAN></FONT><FONT color=3Dblack size=3D2><SPAN=20
style=3D"FONT-SIZE: 10pt; COLOR: black">Windsong =
Services</SPAN></FONT><FONT=20
color=3Dblack><SPAN style=3D"COLOR: black"> <BR></SPAN></FONT><FONT =
color=3Dblack=20
size=3D2><SPAN style=3D"FONT-SIZE: 10pt; COLOR: black">(01689) 870622 =
x3005</SPAN></FONT><FONT color=3Dblack><SPAN style=3D"COLOR: black">=20
</SPAN></FONT><FONT color=3Dblack><SPAN=20
style=3D"COLOR: black; mso-color-alt: =
windowtext"><o:p></o:p></SPAN></FONT></P></DIV></BLOCKQUOTE></BODY></HTM=
L>
------_=_NextPart_001_01C35AA3.8E5F86A0--