[Year 12 IT Apps] Just an oldie! But can we please identify ourselves?

Mon Oct 15 19:06:58 EST 2007

Whoops, sorry!

Selina Dennis, IT/English

Strathmore Secondary College

From: itapps-bounces at edulists.com.au [mailto:itapps-bounces at edulists.com.au]
On Behalf Of Robert Hind
Sent: Monday, 15 October 2007 6:27 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: [Year 12 IT Apps] Just an oldie! But can we please identify
ourselves?

Hi Selina,

A good contribution to the list.

But

Could you please identify yourself more clearly/fully  J

Robert Hind (Semi-retired)
Ex Traralgon and Ashwood

----- Original Message ----- 

From: "Selina Dennis" < <mailto:selina at dennis.net.au> selina at dennis.net.au>

To: "'Year 12 IT Applications Teachers' Mailing List'" <
<mailto:itapps at edulists.com.au> itapps at edulists.com.au>

Sent: Monday, October 15, 2007 5:59 PM

Subject: RE: [Year 12 IT Apps] Bad, Excel. Bad!

> =SUM($A$1:$A$5) also fixes the problem, if you wish to retain the
> "built-in-I-know-better" error correction.
> 
> Regards,
> 
> Selina
> 
> -----Original Message-----
> From:  <mailto:itapps-bounces at edulists.com.au>
itapps-bounces at edulists.com.au [mailto:itapps-bounces at edulists.com.au]
> On Behalf Of Mark Kelly
> Sent: Monday, 15 October 2007 4:33 PM
> To: Year 12 IT Applications Teachers' Mailing List
> Subject: Re: [Year 12 IT Apps] Bad, Excel. Bad!
> 
> Sorry for the confusion all.  The formula was originally sum(a1:a5) - as 
> it should have been - but I forgot to undo Excel's botched "correction" 
> before saving and posting it.
> 
> It started as sum(a1:a5)!
> 
> The problem is as Alex notes - after filling in A1:A5, Excel starts 
> changing the formula!  That's why it _ended up_ as SUM(A1:A10) - and 
> that's where you entered the story :-)
> 
> Cheers
> Mark
> 
> Geoff Moss wrote:
>> Hi Mark
>> 
>> The formula in A11 is:  =SUM(A1:A10)
>> Hence you are doubling the numbers A6:A10 by including them in the 
>> sub-total for Total B
>> 
>> Just a bad formula!
>> Cheers
>> 
>> Geoff Moss
>> RMIT
>> 
>> ----- Original Message ----- From: "Mark Kelly"
> < <mailto:kel at mckinnonsc.vic.edu.au> kel at mckinnonsc.vic.edu.au>
>> To: "Year 12 IT Applications Teachers' Mailing List" 
>> < <mailto:itapps at edulists.com.au> itapps at edulists.com.au>
>> Sent: Monday, October 15, 2007 2:50 PM
>> Subject: [Year 12 IT Apps] Bad, Excel. Bad!
>> 
>> 
>>> A curious problem with Excel.  Please play with the attached file.
>>>
>>> It seems Excel thinks it knows better than I do about what formulas
>>> should be, and I can't work how how to stop it.  Something to do with
>>> its 'advanced formula error' fixing, I guess.  Very annoying!
>>>
>>> To try it out, just put "1" into each of the shaded cells and watch what
>>> happens to the formula for the total of section A!
>>>
>>> Any ideas for fixes?
>>>
>>> TIA
>>> Mark
>>>
>>> -- 
>>> Mark Kelly
>>> Manager - Information Systems
>>> McKinnon Secondary College
>>> McKinnon Rd McKinnon 3204, Victoria, Australia
>>> Direct line / Voicemail: 8520 9085
>>> School Phone +613 8520 9000
>>> School Fax +613 95789253
>>> kel AT mckinnonsc.vic.edu.au
>>>
>>> Webmaster -  <http://www.mckinnonsc.vic.edu.au>
http://www.mckinnonsc.vic.edu.au
>>> IT Lecture notes:  <http://vceit.com> http://vceit.com
>>> Moderator: IT Applications Mailing List
>>>
>>> You'll know when we are officially a civilised race: our schools have
>>> all the money they need and the Air Force has to run a chook raffle to
>>> buy a new bomber.
>>> _______________________________________________
>>>  <http://www.edulists.com.au> http://www.edulists.com.au - FAQ,
resources, subscribe, unsubscribe
>>> IT Applications Mailing List kindly supported by
>>>  <http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html>
http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html 
>>> - Victorian Curriculum and Assessment Authority and
>>>  <http://www.vitta.org.au> http://www.vitta.org.au  - VITTA Victorian
Information Technology 
>>> Teachers Association Inc
>> 
>> 
>>
>
----------------------------------------------------------------------------
> ---- 
>> 
>> 
>> 
>> No virus found in this incoming message.
>> Checked by AVG Free Edition.
>> Version: 7.5.488 / Virus Database: 269.14.10/1070 - Release Date: 
>> 14/10/2007 9:22 AM
>> 
>> _______________________________________________
>>  <http://www.edulists.com.au> http://www.edulists.com.au - FAQ,
resources, subscribe, unsubscribe
>> IT Applications Mailing List kindly supported by
>>  <http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html>
http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html - 
>> Victorian Curriculum and Assessment Authority and
>>  <http://www.vitta.org.au> http://www.vitta.org.au  - VITTA Victorian
Information Technology 
>> Teachers Association Inc
>> 
>> 
> 
> -- 
> Mark Kelly
> Manager - Information Systems
> McKinnon Secondary College
> McKinnon Rd, McKinnon 3204, Victoria, Australia
> Direct line / Voicemail: 8520 9085
> School Phone +613 8520 9000, Fax +613 95789253
> kel AT mckinnonsc.vic.edu.au
> 
> Webmaster -  <http://www.mckinnonsc.vic.edu.au>
http://www.mckinnonsc.vic.edu.au
> IT Lecture notes:  <http://vceit.com> http://vceit.com
> Moderator: IT Applications Mailing List
> 
> 1. Education is an admirable thing, but remember that nothing that is 
> worth knowing can be taught - Oscar Wilde
> 2. I make trouble.  You want some?
> 
> _______________________________________________
>  <http://www.edulists.com.au> http://www.edulists.com.au - FAQ, resources,
subscribe, unsubscribe
> IT Applications Mailing List kindly supported by
>  <http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html>
http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html -
> Victorian Curriculum and Assessment Authority and
>  <http://www.vitta.org.au> http://www.vitta.org.au  - VITTA Victorian
Information Technology Teachers
> Association Inc
> 
> _______________________________________________
>  <http://www.edulists.com.au> http://www.edulists.com.au - FAQ, resources,
subscribe, unsubscribe
> IT Applications Mailing List kindly supported by
>  <http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html>
http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html -
Victorian Curriculum and Assessment Authority and
>  <http://www.vitta.org.au> http://www.vitta.org.au  - VITTA Victorian
Information Technology Teachers Association Inc
> 
>_______________________________________________ 
http://www.edulists.com.au  <http://www.edulists.com.au> - FAQ, resources,
subscribe, unsubscribe 
IT Applications Mailing List kindly supported by 
http://www.vcaa.vic.edu.auvce/studies/infotech/infotechindex.html
<http://www.vcaa.vic.edu.auvce/studies/infotech/itapplications3-4.html%20>
- Victorian Curriculum and Assessment Authority and 
http://www.vitta.org.au  <http://www.vitta.org.au> - VITTA Victorian
Information Technology Teachers Association Inc

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20071015/9b21aaae/attachment-0001.html