my profile | my password | search | faq & rules | forum home

» Film-Tech Forum ARCHIVE   » Operations   » Film Handlers' Forum   » Projectionist Roster in Excel

Author Topic: Projectionist Roster in Excel Bill Langfield Master Film Handler Posts: 280 From: Prospect, NSW, Australia Registered: Apr 2001 posted 08-15-2004 01:25 PM                        What I'm after is a PROJECTIONIST ROSTER using MS excel. Could not find anything searching on FT. Before you say anything, All those so called freeware programs are NOT what Im after, Just want a spreadsheet. If anyone is using exel to create ANY type of staff roster let me know what you've got (But it needs to just the WEEKS SHIFTS, not the STAFF ROSTER with how old they are, the payrates, how many upsizes sold that week. JUST THE WEEKS SHIFT!! (well 4 week rotating would be nice) What Im after is something that knows NOT to allow rostering someone on Monday night, who has a perm n/a, or has a n/a entered due to working at another location. I was going to send screen capture of one I made a few years ago but just remembered (after searching all my HDD's) I deleted the folder named 'hoyts', a about a year ago, where most of my blood, sweat and tears were stored. (Just forgot to save the good stuff - Damn it) What ever you've got, send it to me (or create a link for everyone to use), and you and I can from there to create a PROJECTIONIST ROSTER that works. Im sure there are many of you that would like an easy to create roster - or is there one already there? Ok I admit it (Brett) the pen and paper one works fine.  |  IP: Logged Bill Langfield Master Film Handler Posts: 280 From: Prospect, NSW, Australia Registered: Apr 2001 posted 08-29-2004 12:36 PM                        Kicking this to the top, because... COME ON, someone must have something. At least tell me HOW do you do your roster??  |  IP: Logged Daryl C. W. O'Shea Film God Posts: 3977 From: Midland Ontario Canada (where Panavision & IMAX lenses come from) Registered: Jun 2002 posted 08-29-2004 02:59 PM                        Pen and paper, or the simple, I'll work this week you work next week method.  |  IP: Logged Brad Miller Administrator Posts: 17775 From: Plano, TX (36.2 miles NW of Rockwall) Registered: May 99 posted 08-29-2004 03:54 PM                     You don't need anything fancy for a schedule. Just open up Excel and fill in some boxes. It's not like you have a staff of 30 in the booth anyway.  |  IP: Logged Bill Langfield Master Film Handler Posts: 280 From: Prospect, NSW, Australia Registered: Apr 2001 posted 08-30-2004 03:50 AM                        ROFL, love Daryl's sleep breaks! I work at 3 cinemas, and mostly end up doing seven days a week including a double on sat or sun, sometimes both. Believe me when I overlay all three rosters it is not unlike your 'Daryl' roster. I'll try and knock something up in Excell like you suggest Brad.  |  IP: Logged Matthew Peters Expert Film Handler Posts: 179 From: Glen Waverley, Melbourne, Australia Registered: Nov 2002 posted 09-02-2004 09:55 AM                     quote: Bill Langfield What Im after is something that knows NOT to allow rostering someone on Monday night, who has a perm n/a, or has a n/a entered due to working at another location. If you want it to have that sort of intelligence with respect to given restraints (eg can't work Mondays) use Integer Linear Programming. In other words put in your Decision variables (shifts) Your constraints (can/can’t work min/max hours) Then use the built in Excel solver ---------------- EDIT: Now that I think about it, if you only have a few staff and you want something really simple… use Excel’s Validation ONLY Brad can work Sunday Morning Anyone can work Sunday Arvo ---------  |  IP: Logged Bill Langfield Master Film Handler Posts: 280 From: Prospect, NSW, Australia Registered: Apr 2001 posted 09-02-2004 12:01 PM                        Matthew, that looks interesting. Yes the bio roster is completely seperate to down stairs, the only concern is when a projectionist is rostered as manager. Or even worse, this one pisses me off the most, I need a day off, but can't get it, then I come in and see a projectionist selling tickets/candy/floor, I go what the hell is this, and they say short of staff, AND IM THINKING any fu*kwit can print a ticket, pour a coke, or tear a ticket. And they have a projectiomist doing it when I needed a shift off. Could you please email that speadsheet to me? Or is it just a mock up like Brads?  |  IP: Logged Brad Miller Administrator Posts: 17775 From: Plano, TX (36.2 miles NW of Rockwall) Registered: May 99 posted 09-02-2004 03:03 PM                     Matthew's spreadsheet is flawed. You would never catch me working a morning shift on any sort of regular basis!  |  IP: Logged Matthew Peters Expert Film Handler Posts: 179 From: Glen Waverley, Melbourne, Australia Registered: Nov 2002 posted 09-02-2004 07:19 PM                     Click Here for the Excel File (Pictured Above) That’s a lot easier than my one of my Excel scheduling problems this week....  |  IP: Logged

All times are Central (GMT -6:00)

Printer-friendly view of this topic

Hop To: Select a Forum: Category: Operations -------------------- Digital Cinema Forum Film Handlers' Forum Large Format Forum Ground Level Feature Info, Trailer Attachments & REAL Credit Offsets Category: Community -------------------- Film-Yak Film Handlers' Movie Reviews The Afterlife Bob Maar's Joke-A-Thon Category: Classified -------------------- Equipment and Supplies Wanted/For Sale Help Wanted/Seeking Employment Category: System -------------------- Software Beta Testing Forum

The Film-Tech Forums are designed for various members related to the cinema industry to express their opinions, viewpoints and testimonials on various products, services and events based upon speculation, personal knowledge and factual information through use, therefore all views represented here allow no liability upon the publishers of this web site and the owners of said views assume no liability for any ill will resulting from these postings. The posts made here are for educational as well as entertainment purposes and as such anyone viewing this portion of the website must accept these views as statements of the author of that opinion and agrees to release the authors from any and all liability.