Author Topic: FORMS: Interesting request for performance reports...  (Read 18666 times)

0 Members and 1 Guest are viewing this topic.

Balletdork

  • Permanent Resident
  • *****
  • Posts: 210
  • Gender: Female
    • View Profile
  • Affiliations: AEA
  • Current Gig: PSM, The Human Race Theatre Company
  • Experience: Professional
Re: Interesting request for performance reports...
« Reply #15 on: Dec 13, 2006, 03:46 pm »
My report is:

Tuning:
Curtain Speech:
Act I:                                Act I:
Intermission:                       Intermission:
Act II:                               Act II:
Curtain:
Bows:

with the second column being for total length of time.

 :)

OldeWolf

  • New to Town
  • **
  • Posts: 36
  • Gender: Male
    • View Profile
  • Affiliations: USITT, SMA
Re: Interesting request for performance reports...
« Reply #16 on: Dec 29, 2006, 02:52 pm »
This is standard on the performance report form I use. Keeps me aware of the tempo of the show, if we're hitting the mark consistently, if we had to hold the curtain for one thing or another.

Owen
All the world's a Stage...

Didaskalos

  • Contributor
  • ***
  • Posts: 71
    • View Profile
Re: Interesting request for performance reports...
« Reply #17 on: Jan 02, 2007, 08:51 pm »

"I don't know how to do this, but I know a stage manager who can get Excel to add times. I'm sure it wouldn't be hard to look up..."


When using Excel, to insert the current date and/or time in a cell:

Current date:  Select a cell and press CTRL+;
Current time:  Select a cell and press CTRL+SHIFT+;

« Last Edit: Jan 02, 2007, 08:53 pm by Didaskalos »
Do it right the first time;  do it right every time.

cuelight

  • New to Town
  • **
  • Posts: 33
  • Gender: Female
    • View Profile
  • Affiliations: SMA (UK)
Re: Interesting request for performance reports...
« Reply #18 on: Jan 04, 2007, 10:16 am »
Quote
I don't know how to do this, but I know a stage manager who can get Excel to add times. I'm sure it wouldn't be hard to look up...

If you mean to add the times together. If you select all of them, at the bottom of Excel on the status bar it will tell you how much it all is added together. I use this when I'm doing my expenses spreadsheets as well so that I know when I've gone over my balance. It's easier than inputting 40 different sums into the calculator!

If you want me to I'll put up an example.

ChaCha

  • Permanent Resident
  • *****
  • Posts: 245
  • Gender: Female
    • View Profile
    • http://www.performinglineswa.org.au
  • Affiliations: Media, Entertainment & Arts Alliance
  • Experience: Former SM
Re: Interesting request for performance reports...
« Reply #19 on: Jan 05, 2007, 08:35 am »
yes please cuelight!
ChaCha

dwj0772

  • New to Town
  • **
  • Posts: 19
  • Gender: Male
    • View Profile
  • Experience: Community Theatre
Re: Interesting request for performance reports...
« Reply #20 on: Jan 05, 2007, 08:44 am »
Depending on how your report is set up in Excel, you can also put in formulas that will calculate the time difference between two times and then another one to add them all up.  PM me if you want more specifics (a copy of your report would be helpful so I can see exactly what you want.)

ljh007

  • Permanent Resident
  • *****
  • Posts: 340
    • View Profile
  • Affiliations: SMA
Re: Interesting request for performance reports...
« Reply #21 on: Jan 05, 2007, 12:27 pm »
This isn't a formula you can imbed in Excel, but you can use this simple but handy website to calculate time for you:
http://www.onlineconversion.com/advanced_time_calculator.htm

It doesnt' exactly rock my world, but it's useful.

KC_SM_0807

  • SM Expert
  • ****
  • Posts: 118
    • View Profile
    • http://
Re: Interesting request for performance reports...
« Reply #22 on: Jan 31, 2007, 03:24 pm »
For time, I do the following:

House Open: Time
Curtain Speech: Start Time/End Time
Act I: Start Time/End Time
Act I: Scene Shifts (Total Time)
Intermission: Start Time/End Time
Act II: Start Time/End Time
Act II: Scene Shifts (Total Time)
Curtain Call: Start Time/End Time

Then, at the end I do this:
Curtain Speech Run Time
Act I: Run Time without scene shifts
Act I: Run Time with Scene Shifts
Intermission Run Time
Act II: Run Time without scene shifts
Act II: Run Time with Scene Shifts
Curtain Call Run Time
Total Show Run Time without shifts, intermission, ect.
Total Show Run Time with scene shifts, intermission, etc.

I kinda go overboard because I am completely neurotic about time.  I guess its all in how much detail you prefer.  However, I do think run time on a performance report is completely appropriate.
"Perhaps, therefore, Stage Managers not only need to be calm and meticulous professionals who know their craft, but masochists who feel pride in rising above impossible odds."

lauria

  • Link Checker Supreme!
  • Contributor
  • ***
  • Posts: 63
  • Gender: Female
    • View Profile
  • Affiliations: AEA
  • Experience: Professional
Re: Interesting request for performance reports...
« Reply #23 on: May 07, 2007, 12:49 am »
For the show I just finished working on, I made an Excel Spreadsheet because I did not want to do the math for the timing.

All I insert is the show start time and then the running time of Act I, Intermission, and Act II and it figures out what time all that stuff happened. I set it up so that it's exactly what I have in my Performance Report (which i stole from my PSM) and so I just copy and paste the cells into my report. Very easy. I'm better at hitting my stopwatch button than I am at looking at the clock, so I find this to be easy.

It can be modified to add times in a different way, though. The most important thing is figuring out how to format each cell. Some are formatted HH:MM:SS and some are formated HH:MM AM/PM. After you figure that out, then you just add things together like you would any another formula.

smejs

  • Permanent Resident
  • *****
  • Posts: 475
  • Gender: Female
    • View Profile
  • Affiliations: AEA, AGMA, SMA, USITT
  • Current Gig: Freelance SM in Denver
  • Experience: Professional
Re: Interesting request for performance reports...
« Reply #24 on: May 07, 2007, 10:03 am »
I'm about 4 weeks into a run using a performance report in Word with an imbedded Excel sheet to do calculations for me.  I'm finding it a great combination.  (Stole it fair and square from another stage manager, and this is the first show I've used it on.)

Then I cut and paste the entire thing into an email (I do have to copy the excel part separately, Entourage doesn't like it all together), and also attach the original Word doc file.

Erin

BeckyGG

  • SM Expert
  • ****
  • Posts: 130
  • Gender: Female
    • View Profile
  • Affiliations: AEA, SMA
  • Experience: Professional
Re: Interesting request for performance reports...
« Reply #25 on: May 07, 2007, 01:34 pm »
I'm about 4 weeks into a run using a performance report in Word with an imbedded Excel sheet to do calculations for me.  I'm finding it a great combination.  (Stole it fair and square from another stage manager, and this is the first show I've used it on.)

Then I cut and paste the entire thing into an email (I do have to copy the excel part separately, Entourage doesn't like it all together), and also attach the original Word doc file.

Erin

That sounds intriguing.  I've never embedded an Excel file into word...how do you do that?
CHAOS: Where Brilliant Dreams Are Born
Before the beginning of great brilliance, there must be Chaos
Before a brilliant person begins something great, they must look foolish to the crowd.

smejs

  • Permanent Resident
  • *****
  • Posts: 475
  • Gender: Female
    • View Profile
  • Affiliations: AEA, AGMA, SMA, USITT
  • Current Gig: Freelance SM in Denver
  • Experience: Professional
Re: Interesting request for performance reports...
« Reply #26 on: May 07, 2007, 03:57 pm »
Quote
That sounds intriguing.  I've never embedded an Excel file into word...how do you do that?

Easiest answer is open the Office Assistant Helper and type "insert Excel" and go to the help topic it suggests for inserting an entire worksheet.  It's in the Insert Menu, then Object.  The program will open up Excel separately for you, and when you're finished with the changes, you just close out of that "sheet" and it saves it into Word (you double-click it from the Word document to open it again).  The only thing I haven't figured out is how to automatically size it to only show the cells I want....so I click on the "object" and then crop it in each side until I only see the cells I want.

Erin

Mac Calder

  • Forum Moderators
  • *****
  • Posts: 977
  • Plan for the future, live for the now
    • View Profile
  • Affiliations: Live Performance Australia / Media Arts and Entertainment Alliance
  • Current Gig: Technical Director
  • Experience: Former SM
Re: Interesting request for performance reports...
« Reply #27 on: May 07, 2007, 06:40 pm »
On the OP:

I generally don't list durations on my show reports, I list all the times though, and I do maintain a spreadsheet on my PC which has all the times and calculates run times. Now that I work corporate, I was told my show reports were "too detailed" because in the "Timing" box, I wrote "doors: 19:01, start: 19:46, mains: 20:32, formalities end: 23:34, House LX Full: 00:15" - apparently that was far more detailed than they wanted. What they wanted was "Doors on time, Event ran 15 minutes late".

You win some, you loose some. That said, you can never have too much information.

jspeaker

  • SM Expert
  • ****
  • Posts: 113
    • View Profile
  • Experience: Professional
Re: Interesting request for performance reports...
« Reply #28 on: May 07, 2007, 07:53 pm »
Generally I do the times of House Open, Show up, Show down and then note the timings of each act and intermission.
Jess W. Speaker, III
Equity Stage Manager
DC Area AEA Liaison
(301) 335-1498
 
http://q5go.blogspot.com/

LisaEllis

  • Guest
Re: Interesting request for performance reports...
« Reply #29 on: May 07, 2007, 10:15 pm »
The only thing I haven't figured out is how to automatically size it to only show the cells I want....so I click on the "object" and then crop it in each side until I only see the cells I want.

When you double click to edit the spreadsheet, you can manipulate the size of the viewing window (like cropping).  Whatever is in the window when you go back to Word is what will be displayed...so if you scroll down to empty cells and close it, you'll only get empty cells.

 ;)

 

riotous