Mic plot spreadsheet template

[gregrs]

I've been lurking for a while, but thought I'd share this OpenOffice Calc template for preparing mic plots:

 

http://db.tt/ITK7erav

 

The formulae allow you to view your mic allocations by character or mic and to make sure you haven't allocated a mic to more than one character at a time. Instructions can be found on the second sheet of the spreadsheet (see tabs at the bottom of the OpenOffice window).

 

Please let me know if you use this template successfully for a show or if you'd like a bit more detail about how the formulae work.

 

Thanks,

Greg.

[gregrs]

I've had a PM about adding more columns, so I thought I'd post the solution here...

 

If you'd like more columns for characters:

1. Right-click the column header for one of the character columns and select Insert Columns.
2. This will add a column to the left with the same conditional formatting as the other character columns.

If you'd like more columns for mics:

1. Right-click the column header for one of the mic columns and select Insert Columns. This will add a column to the left but the column will not contain the necessary formulae. To add the formulae:
2. Copy one of the cells containing a formula from the mics table.
3. Select all the cells in the new column except the header cells.
4. Click the Edit menu and click Paste Special...
5. Untick Paste all and then untick Formats then click OK. (This prevents the cell border settings from being pasted and keeps the tables looking tidy.)
6. Repeat the process for the far right-hand table, copying a cell from that table instead for step 2.

Hope that helps.

[callumb]

Are you able to export this as an XLS file? http://www.blue-room.org.uk/public/style_emoticons/default/biggrin.gif

[the kid]

It might just be me but there are NO formulas when I open it in Excel. Or is that the compatibility issue with MS v's Open office.

[TonyMitchell]

It might just be me but there are NO formulas when I open it in Excel. Or is that the compatibility issue with MS v's Open office.

 

 

same here

[Gerry]

I think you will find that Microsoft, in their wisdom (?)wrote Excel such that it will only read/ write documents in xls format.

The creators of Open Office are more forward thinking and will read and write a spreadsheet any any format you require.

I'm sure the OP can post it in xls format for those who like to use restrictive software. :D

Cheers

Gerry

[themadhippy]

or you could download open office or libreoffice (its free|) and move away from restrictive licencing/try the conversion yourself

[ojc123]

I've tried saving it as .xls file and a .xml file from the .ods file and Excel will have nothing to do with it. I opened the ods file in Libre Office in Ubuntu. I tried the xml and xls files in Excel 2003 win XP.

 

Thanks for sharing this. It looks interesting but not needed for my simple requirements.

[gregrs]

I have exported as an XLS using OpenOffice 3.3.0 on a Mac - try this file in Excel:

 

http://db.tt/jV5FUA6w

 

It seems to open okay in an old Mac version of Excel, although it comes up with some odd warnings about formulae referring to empty cells when they actually don't...

 

Alternatively you can download OpenOffice for free here: http://www.openoffice.org/download/

 

Thanks.

[mervaka]

Get Libreoffice.

From http://www.techsuppo...ice-623394.html

The short answer is libreoffice. Openoffice was a java open source project. When oracle bought sun the developers forked the openoffice project and created libreoffice. While oracle did not kill the open office project it has been stagnant and many now consider libreoffice to be it's replacement

[paulears]

Office on my mac refused to accept the file type, so opened it on a pc with open office on it and then saved as xls - and got the same warning.

 

I can confirm there is some interesting forumii - and some of it I've not used or even seen before - so when I get time, my excel skills will get a jump. Sp thanks to the OP for increasing my excel knowledge. I've always found seeing the maths implemented in context works so much better than just the forumula rules!

 

I found the headings a little confusing - is there a version with data filled in? That would be easier to evaluate?