Login

Welcome, Guest. Please login or register.

October 22, 2025, 12:35:02 am

Author Topic: Play the B12 Spreadsheet game  (Read 1489 times)  Share 

0 Members and 1 Guest are viewing this topic.

excal

  • VN Security
  • Victorian
  • ATAR Notes Legend
  • *******
  • Posts: 3490
  • Über-Geek
Play the B12 Spreadsheet game
« on: November 26, 2009, 12:31:14 pm »
From the bottom of: http://www.mckinnonsc.vic.edu.au/vceit/postmortems/2009ita/index.htm

Quote
Play the B12 spreadsheet game!

Fun for the whole family

The challenge is to create the delivery docket spreadsheet exactly as described in the ITA exam question B12e

without using mail merge!

And since the question says for you to "automatically create a delivery slip for each customer",
it means each customer, not just one.
And it should be automatic, not manual.

Best of luck.

A spreadsheet starting point is available for anyone who wants to play. It's the best I could manage. Ignore it if you prefer.
Remember: there should be no blank lines in the list of items on the delivery slip.

Let me know how you go.
excal (VCE 05/06) BBIS(IBL) GradCertSc(Statistics) MBBS(Hons) GCertClinUS -- current Master of Medicine candidate
Former Global Moderator

excal

  • VN Security
  • Victorian
  • ATAR Notes Legend
  • *******
  • Posts: 3490
  • Über-Geek
Re: Play the B12 Spreadsheet game
« Reply #1 on: November 26, 2009, 12:32:42 pm »
I have a solution in mind, except it's one that you wouldn't be able to use in the exam room...
excal (VCE 05/06) BBIS(IBL) GradCertSc(Statistics) MBBS(Hons) GCertClinUS -- current Master of Medicine candidate
Former Global Moderator