Excel

[wizardofmann]

I have been corresponding with Neil (God help him) to set up a bot for me but need some more info from you seasoned pro's.

After nearly a year of using BA, I am looking to advance into Excel and I am dot com. Firstly, do I need to have Excel installed on my computer to start logging markets. Secondly, if I do, do I need to use Microsoft Excel or can I install OpenOffice?

I have looked at the demo video on how to set up Excel logging but I am still none the wiser I know what a worksheet is but not clear where to get a workbook

Green or what.....please help

[wizardofmann]

That was meant to read:what is a workbook

[Captain Sensible]

Yes you need Microsoft excel it can't link to openoffice.

A workbook can contain more than one worksheet, so you can have separate sheets all logging different data or doing separate calculations to keep things nice and tidy.

Just think of it like a normal book that contains lots of pages (sheets)

If you look at the picture below you'll see a open workbook, look at the bottom and you'll see that workbook has separate tabs that can be selected they are the worksheets, Sheet1, Sheet2 and Sheet3



Don't worry, once you get started things do fall into place alot quicker

[Captain Sensible]

Maybe this picture will show. At the top you can see it's called Book 1 and contains 3 Sheets

[wizardofmann]

Thanks a lot Captain Sensible. Most helpful of you