<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-AU link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Whoops, sorry!<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Selina Dennis, IT/English<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Strathmore Secondary College<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:
"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'> itapps-bounces@edulists.com.au
[mailto:itapps-bounces@edulists.com.au] <b>On Behalf Of </b>Robert Hind<br>
<b>Sent:</b> Monday, 15 October 2007 6:27 PM<br>
<b>To:</b> Year 12 IT Applications Teachers' Mailing List<br>
<b>Subject:</b> [Year 12 IT Apps] Just an oldie! But can we please identify
ourselves?<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<div>
<p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>Hi Selina,</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>A good
contribution to the list.</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>But</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>Could you
please identify yourself more clearly/fully </span><strong><span
style='font-size:36.0pt;font-family:Wingdings'>J</span></strong><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>Robert Hind
(Semi-retired)<br>
Ex Traralgon and Ashwood</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-family:"Arial","sans-serif"'><br>
<o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>-----
Original Message ----- </span><o:p></o:p></p>
<div>
<p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>From:
"Selina Dennis" <</span><a href="mailto:selina@dennis.net.au"><span
style='font-family:"Arial","sans-serif"'>selina@dennis.net.au</span></a><span
style='font-family:"Arial","sans-serif"'>></span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>To:
"'Year 12 IT Applications Teachers' Mailing List'" <</span><a
href="mailto:itapps@edulists.com.au"><span style='font-family:"Arial","sans-serif"'>itapps@edulists.com.au</span></a><span
style='font-family:"Arial","sans-serif"'>></span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>Sent: Monday,
October 15, 2007 5:59 PM</span><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>Subject: RE:
[Year 12 IT Apps] Bad, Excel. Bad!</span><o:p></o:p></p>
</div>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<p class=MsoNormal><span style='font-family:"Arial","sans-serif"'>>
=SUM($A$1:$A$5) also fixes the problem, if you wish to retain the<br>
> "built-in-I-know-better" error correction.<br>
> <br>
> Regards,<br>
> <br>
> Selina<br>
> <br>
> -----Original Message-----<br>
> From: </span><a href="mailto:itapps-bounces@edulists.com.au"><span
style='font-family:"Arial","sans-serif"'>itapps-bounces@edulists.com.au</span></a><span
style='font-family:"Arial","sans-serif"'>
[mailto:itapps-bounces@edulists.com.au]<br>
> On Behalf Of Mark Kelly<br>
> Sent: Monday, 15 October 2007 4:33 PM<br>
> To: Year 12 IT Applications Teachers' Mailing List<br>
> Subject: Re: [Year 12 IT Apps] Bad, Excel. Bad!<br>
> <br>
> Sorry for the confusion all. The formula was originally sum(a1:a5) -
as <br>
> it should have been - but I forgot to undo Excel's botched
"correction" <br>
> before saving and posting it.<br>
> <br>
> It started as sum(a1:a5)!<br>
> <br>
> The problem is as Alex notes - after filling in A1:A5, Excel starts <br>
> changing the formula! That's why it _ended up_ as SUM(A1:A10) - and <br>
> that's where you entered the story :-)<br>
> <br>
> Cheers<br>
> Mark<br>
> <br>
> Geoff Moss wrote:<br>
>> Hi Mark<br>
>> <br>
>> The formula in A11 is: =SUM(A1:A10)<br>
>> Hence you are doubling the numbers A6:A10 by including them in the <br>
>> sub-total for Total B<br>
>> <br>
>> Just a bad formula!<br>
>> Cheers<br>
>> <br>
>> Geoff Moss<br>
>> RMIT<br>
>> <br>
>> ----- Original Message ----- From: "Mark Kelly"<br>
> <</span><a href="mailto:kel@mckinnonsc.vic.edu.au"><span
style='font-family:"Arial","sans-serif"'>kel@mckinnonsc.vic.edu.au</span></a><span
style='font-family:"Arial","sans-serif"'>><br>
>> To: "Year 12 IT Applications Teachers' Mailing List" <br>
>> <</span><a href="mailto:itapps@edulists.com.au"><span
style='font-family:"Arial","sans-serif"'>itapps@edulists.com.au</span></a><span
style='font-family:"Arial","sans-serif"'>><br>
>> Sent: Monday, October 15, 2007 2:50 PM<br>
>> Subject: [Year 12 IT Apps] Bad, Excel. Bad!<br>
>> <br>
>> <br>
>>> A curious problem with Excel. Please play with the attached
file.<br>
>>><br>
>>> It seems Excel thinks it knows better than I do about what
formulas<br>
>>> should be, and I can't work how how to stop it. Something to
do with<br>
>>> its 'advanced formula error' fixing, I guess. Very annoying!<br>
>>><br>
>>> To try it out, just put "1" into each of the shaded
cells and watch what<br>
>>> happens to the formula for the total of section A!<br>
>>><br>
>>> Any ideas for fixes?<br>
>>><br>
>>> TIA<br>
>>> Mark<br>
>>><br>
>>> -- <br>
>>> Mark Kelly<br>
>>> Manager - Information Systems<br>
>>> McKinnon Secondary College<br>
>>> McKinnon Rd McKinnon 3204, Victoria, Australia<br>
>>> Direct line / Voicemail: 8520 9085<br>
>>> School Phone +613 8520 9000<br>
>>> School Fax +613 95789253<br>
>>> kel AT mckinnonsc.vic.edu.au<br>
>>><br>
>>> Webmaster - </span><a href="http://www.mckinnonsc.vic.edu.au"><span
style='font-family:"Arial","sans-serif"'>http://www.mckinnonsc.vic.edu.au</span></a><br>
<span style='font-family:"Arial","sans-serif"'>>>> IT Lecture notes: </span><a
href="http://vceit.com"><span style='font-family:"Arial","sans-serif"'>http://vceit.com</span></a><br>
<span style='font-family:"Arial","sans-serif"'>>>> Moderator: IT
Applications Mailing List<br>
>>><br>
>>> You'll know when we are officially a civilised race: our schools
have<br>
>>> all the money they need and the Air Force has to run a chook
raffle to<br>
>>> buy a new bomber.<br>
>>> _______________________________________________<br>
>>> </span><a href="http://www.edulists.com.au"><span
style='font-family:"Arial","sans-serif"'>http://www.edulists.com.au</span></a><span
style='font-family:"Arial","sans-serif"'> - FAQ, resources, subscribe, unsubscribe<br>
>>> IT Applications Mailing List kindly supported by<br>
>>> </span><a
href="http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html"><span
style='font-family:"Arial","sans-serif"'>http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html</span></a><span
style='font-family:"Arial","sans-serif"'> <br>
>>> - Victorian Curriculum and Assessment Authority and<br>
>>> </span><a href="http://www.vitta.org.au"><span style='font-family:
"Arial","sans-serif"'>http://www.vitta.org.au</span></a><span style='font-family:
"Arial","sans-serif"'> - VITTA Victorian Information Technology <br>
>>> Teachers Association Inc<br>
>> <br>
>> <br>
>><br>
>
----------------------------------------------------------------------------<br>
> ---- <br>
>> <br>
>> <br>
>> <br>
>> No virus found in this incoming message.<br>
>> Checked by AVG Free Edition.<br>
>> Version: 7.5.488 / Virus Database: 269.14.10/1070 - Release Date: <br>
>> 14/10/2007 9:22 AM<br>
>> <br>
>> _______________________________________________<br>
>> </span><a href="http://www.edulists.com.au"><span style='font-family:
"Arial","sans-serif"'>http://www.edulists.com.au</span></a><span
style='font-family:"Arial","sans-serif"'> - FAQ, resources, subscribe,
unsubscribe<br>
>> IT Applications Mailing List kindly supported by<br>
>> </span><a
href="http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html"><span
style='font-family:"Arial","sans-serif"'>http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html</span></a><span
style='font-family:"Arial","sans-serif"'> - <br>
>> Victorian Curriculum and Assessment Authority and<br>
>> </span><a href="http://www.vitta.org.au"><span style='font-family:
"Arial","sans-serif"'>http://www.vitta.org.au</span></a><span style='font-family:
"Arial","sans-serif"'> - VITTA Victorian Information Technology <br>
>> Teachers Association Inc<br>
>> <br>
>> <br>
> <br>
> -- <br>
> Mark Kelly<br>
> Manager - Information Systems<br>
> McKinnon Secondary College<br>
> McKinnon Rd, McKinnon 3204, Victoria, Australia<br>
> Direct line / Voicemail: 8520 9085<br>
> School Phone +613 8520 9000, Fax +613 95789253<br>
> kel AT mckinnonsc.vic.edu.au<br>
> <br>
> Webmaster - </span><a href="http://www.mckinnonsc.vic.edu.au"><span
style='font-family:"Arial","sans-serif"'>http://www.mckinnonsc.vic.edu.au</span></a><br>
<span style='font-family:"Arial","sans-serif"'>> IT Lecture notes: </span><a
href="http://vceit.com"><span style='font-family:"Arial","sans-serif"'>http://vceit.com</span></a><br>
<span style='font-family:"Arial","sans-serif"'>> Moderator: IT Applications
Mailing List<br>
> <br>
> 1. Education is an admirable thing, but remember that nothing that is <br>
> worth knowing can be taught - Oscar Wilde<br>
> 2. I make trouble. You want some?<br>
> <br>
> _______________________________________________<br>
> </span><a href="http://www.edulists.com.au"><span style='font-family:"Arial","sans-serif"'>http://www.edulists.com.au</span></a><span
style='font-family:"Arial","sans-serif"'> - FAQ, resources, subscribe, unsubscribe<br>
> IT Applications Mailing List kindly supported by<br>
> </span><a
href="http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html"><span
style='font-family:"Arial","sans-serif"'>http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html</span></a><span
style='font-family:"Arial","sans-serif"'> -<br>
> Victorian Curriculum and Assessment Authority and<br>
> </span><a href="http://www.vitta.org.au"><span style='font-family:"Arial","sans-serif"'>http://www.vitta.org.au</span></a><span
style='font-family:"Arial","sans-serif"'> - VITTA Victorian Information
Technology Teachers<br>
> Association Inc<br>
> <br>
> _______________________________________________<br>
> </span><a href="http://www.edulists.com.au"><span style='font-family:"Arial","sans-serif"'>http://www.edulists.com.au</span></a><span
style='font-family:"Arial","sans-serif"'> - FAQ, resources, subscribe,
unsubscribe<br>
> IT Applications Mailing List kindly supported by<br>
> </span><a
href="http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html"><span
style='font-family:"Arial","sans-serif"'>http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html</span></a><span
style='font-family:"Arial","sans-serif"'> - Victorian Curriculum and Assessment
Authority and<br>
> </span><a href="http://www.vitta.org.au"><span style='font-family:"Arial","sans-serif"'>http://www.vitta.org.au</span></a><span
style='font-family:"Arial","sans-serif"'> - VITTA Victorian Information
Technology Teachers Association Inc<br>
> <br>
></span>_______________________________________________ <br>
<a href="http://www.edulists.com.au">http://www.edulists.com.au </a>- FAQ,
resources, subscribe, unsubscribe <br>
IT Applications Mailing List kindly supported by <br>
<a href="http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html%20">http://www.vcaa.vic.edu.auvce/studies/infotech/infotechindex.html
</a>- Victorian Curriculum and Assessment Authority and <br>
<a href="http://www.vitta.org.au">http://www.vitta.org.au </a>- VITTA Victorian
Information Technology Teachers Association Inc<o:p></o:p></p>
</div>
</body>
</html>