Open and closing price

Hi,

I'd like to gauge what the approx. opening and closing price will be. I've read the info here:

http://www.asx.com.au/investor/education/basics/open_Close.htm

...and was wondering if anyone had a spreadsheet that could calculate it please? Maybe by cutting and pasting the prices into it.

SB