ProScheduler-2ed Help Document
Contents
1. T Y i T 1 1 1 1 1 T f T T T T T 8 9 10 11 12 13 20 21 22 23 24 25 26 27 28 29 34 35 36 38 39 40 42 43 44 45 46 47 4 vont ret war Mar varf wer ma E m 2 oa nor now nov no n Required Worker Indicator Row i See erica iKIEIEIE DERRY BEE E 42 A 44 45 46 27 g Page 16 of 20 The Master Schedule Chart the Growing Season Performance Period Indicator Row and Required Worker Indicator Row provides a complete visual of your schedule results and quickly point out to you where your schedule has assigned more tasks than there are available workers and when you have workers available in certain weeks e The follow items are described below o Master Schedule Chart the bars in the chart are the number of staffing required by the schedule expressed in number of worker or hours or minutes The red line in the chart represents the number of workers available in number of worker or hours or minutes You can quickly see where tasks need to be shifted to achieve a more balance schedule Week Indicator Row The color code for this row provides another visual of the level of balance of your schedule Red means more tasks are scheduled than there are available workers Yellow means that there are still available workers to assign more work to Green means that the tasks scheduled is2. HE SPHBRAS G R BATaHS ow EBU O fl we Be A Week 13 Mar 31 2014 Click here to return to Scheduled Weeks List Clic ur heduled Weeks Lis Days per Week tS Avail Workers Productive Hrs Per Days 6l Required Workers Workers got Crew Hrs per Day BSF e a Rs m E a m a m a u m L1GOWisi IHQOLOI Mi HowerBedi 99 32 SE FB Weed No Mulch 60l 1 00 O40 010 uss 2 130 Wis 1040 01 01 Mr Flower Bed osisr cue No Mulch 30 1 0 05 oos ois 3 180 Wis 1080 01 01 M1 Flower ed o9 325 FB Potce byhand is 1 oo oo ary 4 2 30 Wis 1040 01 01 wi Flower Bed _ 105 7 st _ FB Weed NoMulch 60 _ 1 onj Od oas 2 30 Wis 2040 03 01 M2 lower Bed 575r r8 Cultivate No Much 30 i oos 005 os Page 19 of 20 u Exported Chart NU a E x ds E Home Insert Pagelayout Formulas Data Review View Developer o09 c qg pex E va Calibri 8 An V Wrap Text Custom E P Comma 3 L e ar E M Ay A opy be Pas eb fe ee E z y Conditional Format Neutral Calculation Insert Delete Format Sort amp Find amp te gp rormat citer P 7 EE IR A LR de m egea centes gt ca 2 Conditional Formatas Good p Dm osc Oo eked Clipboard fa fa Alignment fa Number fa Styles Cells Editing QOdgdidi9 ec 3 a umHu a a kamaa EBCT eB Month re ele e elm i s e t w m lo S Ta RIS TU TVTWI X NT a
3. HEGS SCH xls Do not type this extension it will be added automatically Load Schedule button launch the Load Schedule menu which allows you to 1 create a master schedule from the Time to Perform report in memory or 2 load a Master Schedule from the disk Print Export button launch the Print Export menu which allows you to 1 export the Master Schedule Chart to Excel or 2 create Weekly Schedules and send them to Excel Help button opens this help document which is stored in the C GroundsOpsStaff Program Files folder Close button Closes the ProScheduler interface You can reopen the ProScheduler interface by clicking the embedded Show Hide ProScheduler Tool button found in the first column below the Panel in the Master Schedule worksheet Pin button allow you to pin the ProScheduler Interface to its current location in the screen Current Column Week textbox indicates week number of the year and the date of the currently select column in the Master Schedule worksheet The date given is always the Monday of the week The above screenshot indicates that the insertion point is now in the columns for Week 32 which is the week of Monday August 9 Page 7 of 20 Setting the Season Performance Start week a Display Different 39 Current Row Wks in 30 d Set Seasons start week rowina Season gt i n gt Print Export Help Cose Din urrent Column Week Wk 12 Mar 22
4. Workload Balance Least Loaded Most Loaded To First Wk 14 Apr 05 Wk 13 Mar 29 To Prev To Next Go To Go To Least Assigned Most Assigned Avg Assigned 55 Wkrs 2 31 Wkrs 65 Wkrs Total Tasks in Schedule Tasks Not Scheduled 645 0 The Workload Balance Group is used to help you create a balanced schedule This group provides you with information you need to make fine adjustments to your schedule to ensure tasks are scheduled in a balance way e The follow items are described below o Least Loaded textbox indicates the week that is least loaded and therefore requires the least Staffing in the currently selected growing season or performance period Least Loaded Go To button move to the Least Loaded Week in the worksheet Most Loaded textbox indicates the week that is most loaded and therefore requires the most staffing in the currently selected growing season or performance period Least Loaded Go To button move to the Most Loaded Week in the worksheet in the currently selected growing season or performance period To First button go to the first unscheduled task in the Master Schedule To Prev button go to the previous unscheduled task in the Master Schedule To Next button go to the next unscheduled task in the Master Schedule Least Assigned textbox the number of workers hours or minutes assigned to the Least Loaded Week in the currently selected growing season or performance period Most Ass
5. 16b All Summer Tasks for Entire Schedule button Click anywhere inside the Master Schedule worksheet Then click this button If the Prompt is on checkbox is check then click Yes All Summer Tasks in the entire schedule for the entire year will be scheduled e 17a Fall Tasks In Selected Rows button Select the cells in the Master Schedule worksheet for which you wish to schedule Fall tasks Then click this button If the Prompt is on checkbox is check then click Yes All Fall Tasks scheduled for the selected rows e 17b All Fall Tasks for Entire Schedule button Click anywhere inside the Master Schedule worksheet Then click this button If the Prompt is on checkbox is check then click Yes All Fall Tasks in the entire schedule for the entire year will be scheduled Page 13 of 20 Automatic Scheduling Command Set Auto 4 Tab Auto 1 Auto 2 Auto 3 Auto 4 18a Al Season Tasks In Selected Rows The Auto 4 Tab contains command buttons to allow you to automatically schedule task in the Master Schedule worksheet To use these command buttons you would first select rows in the Master Schedule worksheet then click the desired command button e The following will occur o The number 1 will be place in the cell for all the scheduled weeks o The background will become green in the scheduled weeks o The Master Schedule Chart will reflect the required staffing for the appropriate weeks o The Week Number Indicator Row will reflect
6. Formatting Table lipboar E Ar a EERE amp t 37 Bow i ac OY Note Click the number or week name to go to the weekly schedule Once in the weekly schedules click the first cell to return to this list 1 1 If you wish to retain this weekly schedule file use the normal Excel save features to save this workbook 2 Week 13 Mar 31 2014 2 Use Excel normal print feature to print worksheets in this workbook 3 Week14Apr72014 4 Week 15 Apr 14 2014 oon Oo uv 5 VN x l Bookl Microsoft Excel Home Insert Page Layout Formulas Data Review View Developer RE I E o FTT pp ca I pum X AutoSum d Cut Calibri a Wrap Text General E y Neui u Calculation Ch ell Em EK m utoSu 5 Ba Copy 7 g Fill 2 Paste B 2 i EH Merge amp Center 9 398 Conditional Formatas Explanatory T Followed Hyp Hyperlink Insert Delete Format Clear Sol M F Format Painter Formatting Table z M z Filt Clipboard p i Alignment a Number i Styles Cells Editing tE ir i eE er r Ez PEER ERR RSE FATU do g EEC d f Week 12 Mar 24 2014 Click here to return to Scheduled Weeks List 2 Days per Week 3 Productive Hrs Per Days 4 Tot Crew Hrs Per Day a 5 z ix 1 ETETETT A A T BA 9077078 RR REN RR UNS NR T E T SS RR RR 2 211 30 Wis 1040 01 01 Mi Flower Bed 99325r _ FB Cultivate No Mulch 80 1 oof oos ost 1 30 Wks 1040 01
7. Hm Top Fit f Btm FRt Next Gmd Area Man 1 Man 2 Balancing Actions 1 1 Sch Tasks in Selected Cells Save Schedule Load Schedule Auto 1 Auto 2 Auto 3 Auto 4 10a Weekly Tasks In Selected Rows s woan n 6e 2 UnSch Tasks in Selected Cells 3 UnSch Tasks In Selected Rows Go To Least Asagned Most Assigned 4 03 wars 5 10 wkrs 4 UnSchedule Al Tasks In Entre Schedule Total Tasks in Schedule r Tasks Not Schedulec Light green indicate beginning of currently active growing season performance period Available Staffing Line RES Week number indicator row Red overloaded week required workers greater than available workers Green required workers equal available workers Yellow required workers less than available workers Show Hide Proscheduler Tool ANR 5 ciEEETEI 11 Workers d Leet C Required workers Indicator row C Required workers Indicator row Indicator row S an a hh A EDD em a 2 13 EF 1 50 Wks 14 TM Push mow 6 15 TM Mow 30 power 4 16 TM Ferilizer 3 17 TM Edging 2 18 TM Insecticide 1 19 TM Weed Control 1 120 TM Pest Control 1 21 Scheduled Tasks Status Column Red some occurrance of this task remains to be scheduled Green all occurrance of this task are scheduled Yellow more occurrances of this task are scheduled than prescribed GroundsOpsStaff P
8. Set Growing Season Start Week Avail Worker In Week Winter Wks In Season starts Wk 1 Jan 04 24 1 O Spring Wks In Season starts Wk 11 Mar 15 TOM Summer Wks In Season starts Wk 25 Jun 21 a Fal Wks In Season starts Wk 38 Sep 20 C Mins Hrs Workers 52 Wks In Season starts Wk 1 Jan 04 30 Wks In Season starts Wk 13 Mar 29 Days Wk Hrs Day Find to First Find to Prev Find to Next Growing Season Wk 13 Mar 29 30 wks Set Growing Season Start Week 4 Hide 1 Marthe san sn E d 9 2 3 4 5 6 7 g aer je reb reb reb Feb mer wo bera ajnaj o oe u m n w ua a n J gt I ojo o ojo o 9 10 week al 2 a a s e 7 e 9 10 lela 3 E D Recall from the user manual that you are allowed to have multiple growing seasons or performance periods in your grounds inventory For example for your green space grounds asset your growing season may be 30 weeks and the season may start the third week in March Your grounds organization might also be responsible for landscape with a performance period of 52 weeks with the start week the first week of January You might also have grounds tasks that you want to ensure are scheduled in a particular season of the year such as winter spring summer and fall Since there are slight variations on when people consider these seasons to start you can set the start week for each season The number of weeks in each season defa
9. abe ex Eevp ed re bc oe pu LO cad ot Ure Pea rh o paa Se pit Ead 14 The Auto 4 Tab contains command buttons to allow you to automatically schedule task in the sssse 14 o 18a All Season Tasks In Selected Rows button iorns E E T A N NOA 14 o 18b All All Season Tasks for Entire Schedule button neesenecseresssresseressereseeresseressiresseruesssresesresssresesresesresseresssresseresereresre 14 198 All Season Tasks IN Selected ROWS DUTTON 4 aor ERE een Cle OUR ra a AAEE p Re Ee ias e n ra top PUR REDI 14 e 19b All All Season Tasks for Entire Schedule button elseeessseeeseeenneen nennen nennen nsns 14 e 203 AM Tasks In Selected ROWS DULtOTI uice 9E vo dao itr an Ie a cele E eA Serve RR AE d NEP ve erede 14 e 205 AIL Tasks Tor Entire Schedule DUTON iiecees ds atu ede BEC E EE oe RE nn e idum dodo Su eva dp ER SE Ee env S et Lrm vend aav ut ER vr ds 14 Aborting Auto Scheduling PROCESS ue vet oneederti ei idu pbiau es hte en e ec cts dee youu mese wate eL ca e mde ic e d CE Lam em oS 15 Ma Meis dierie zi siu eismod lem E DT TELE 15 The Workload Balance Group is used to help you create a balanced schedule eeeeeeeeenn me 15 Productivity GO UD ETT 16 ThE Productivity GroUDrorsans M Sauces 16 Using the Master Schedule Chart and Color Coding ccccccsssccccssseccesc
10. e Exporting the Master Schedule Chart follow the below steps o Click the Print Export button Click the Send Chart to Excel button Click Yes to confirm The Chart will be sent to a temporary Excel workbook GroundsOpsExportTempX xls X is a number The temporary workbook will might appear on the screen depending on what other programs you have running If not activate it by clicking on it in the task bar or using the ALT TAB key combination When you are finished viewing and or editing the temporary workbook 1 you can close it without saving it 2 save it under a different name and close it 3 leave it open for later viewing during this session without saving it or 4 save it under a different name and leave it open Recall that all workbooks with a file name beginning with GroundsOpsExportTemp will be delete the next time your start up GroundsOpssStaff e Creating and Exporting the Weekly Schedules follow below steps Week Selector o Click the Print Export button o Click the Export Weekly Schedules to Excel button o Click Yes to confirm o Select the Week or Weeks from the Week Selector box as show in the screenshot to the left Click the Accept button Week 13 Mar 29 2010 The first worksheet in the Weekly Schedule workbook will Week 16 Apr 19 2010 look like the below screenshot and there will be a C Week 17 Apr 26 2010 jJ IL Week 18 May 3 2010 A Week 19 May 10 2010 _ worksheet for each week you selecte
11. in this week e 10a Weekly Tasks In Selected Rows button Select the cells in the Master Schedule worksheet for which you wish to schedule any weekly tasks Then click this button If the Prompt is on checkbox is check then click Yes All Weekly Tasks for the selected rows will be scheduled e 10b All Weekly Tasks for Entire Schedule button Click anywhere inside the Master Schedule worksheet Then click this button If the Prompt is on checkbox is check then click Yes All Weekly Task in the entire year for the entire year will be scheduled e iia Bi Weekly Tasks In Selected Rows button Select the cells in the Master Schedule worksheet for which you wish to schedule BI Weekly tasks Then click this button If the Prompt is on checkbox is check then click Yes All Bi Weekly Tasks scheduled for the selected rows e 11b All Bi Weekly Tasks for Entire Schedule button Click anywhere inside the Master Schedule worksheet Then click this button If the Prompt is on checkbox is check then click Yes All Bi Weekly Tasks in the entire schedule for the entire year will be scheduled e iia Monthly Tasks In Selected Rows button Select the cells in the Master Schedule worksheet for which you wish to schedule Monthly tasks Then click this button If the Prompt is on checkbox is check then click Yes All Monthly Tasks scheduled for the selected rows e 11b All Monthly Tasks for Entire Schedule button Click anywhere inside the Master Schedule wo
12. like to shift then click this button One occurrence frequency of the task will be shifted one week to the right 9a Shift Selected Tasks all 1 week Left Select the cells of the tasks you would like to shift then click this button All occurrences frequencies of the task will be shifted one week to the left 9b Shift Selected Tasks all 1 week Right Select the cells of the tasks you would like to shift then click this button All occurrences frequencies of the task will be shifted one week to the right Man i Man 2 Balancing Actons 1 D Temm Delete all Closed Temporary Files The Actions 1 Tab contains miscellaneous commands for appearance of the chart and temporary file management Chart Data Labels button Hide or show the data label on the Master Schedule Chart Chart Minor Grids button Hide or show the minor grid lines on the Master Schedule Chart Delete all Closed Temporary Files button delete all the temporary files that GroundsOpsStaff create when you export to Excel These files are not intended for permanent storage of information If you want to retain any information that you export to Excel you should use Excel Save As command to save the file under a different name All temporary file created by the GroundsOpsStaff Export to Excel feature will have Page 10 of 20 the name GroundsOpsExportTempX xls where X is a number that s incremented each time you export to Excel GroundsOpsStaff deletes all of th
13. of available workers in the Avail Workers In Week Input Box You can click the blue button to the left of the input box to set the number of available workers to the number computed from the Time To Perform Report You can also use the six up down arrows to adjust the number of available workers a Toallow ProScheduler suggest what a balanced number might be for a balance schedule select the main season from the Display Different Growing Season gt dropdown list for example select 30 b Lookin the Workload Balance section of the ProScheduler Tool and find the number in the Avg Assigned box Click the green button to the right of the Avail Workers In Week Input box to make the number of available workers equal to the number in the Avg Assigned box 13 Click Balancing Tab Then 9d Balance All Red Week Shift Right button This will reduce the task in Red Weeks weeks where the required workers are greater than the available workers by shifting tasks from the over scheduled week to a later week 14 If there are still red weeks in the schedule then click Balancing Tab Then click 9f Balance All Red Week Shift Left button 15 If there are still red weeks in the schedule then repeat steps 13 and 14 until there are no more red weeks or no Page 5 of 20 UJ O CON DD UW change in the schedule There are rare situations where the schedule cannot be perfectly balanced due to large number of recurring and or seasonal tasks that must be perf
14. this manual Display Different Growing Season Dropdown button allows you to select which growing season or performance period will be displayed on the Growing Season Performance Period Indicator Row The season is indicated by the green background in the indicator row The start week and the ending week are indicated by a different background See the indicator row in the screenshot above in the GroundsOpsStaff Page 6 of 20 ProScheduler Concept and General Steps section Note that the currently select Growing Season Performance Period starts with Week 11 and end with Week 23 of the year or the third week of March and the first week of June Current Row Wks in Growing Season Textbox indicates the number of week in the growing season or performance for the currently selected row of the Master Schedule worksheet This textbox keeps you informed of the number of week in the growing season for each task in the Master Schedule ProScheduler Interface Commands and Display Group Continued SOME h Hide Panel P nr u Display ara 3 Current Row Wks in 30 To Inventory Hide Panel Set Seasons Start Week Crowina VHS 30 fef ine Save Schedule Load Schedule Print Export Help Chose P n Current Column Week gt gt Wk 32 Aug 09 Save Schedule button Save the Master Schedule worksheet that is in memory to disk The default save location is the C GroundsOpsStaff Data folder The file name you enter will be appended with
15. 01 Wi aa 99 32SF FB Police by hand 15 14 002 oo on S O 4 a E E i ea E 98 s 2 5 2 30 Wis 1040 01 01 M1 Flower Bed _ 105 7 F_ F8 Cultivate NoMulch 30 _ _4 _0 05 _o 05 _0 33 2 30 Wks 1040 01 01 Mi Flower Bed 105 7SF FB Policebyhand 15 14 003 003 036 SC O 7 715 0 Wis 1040 01 01 Mi Fower Bod O a seed No mulch O i em am 4 8 owners ss fra cae Nowa af nol sm Re 9 6 30 Wks 1020 01 01 M1 Flower Bed 83 36SF FB Polieebyhand 15 14 oo 002 050 10 8 30 Wks 1040 01 01 M1 Flower Bed 146 74SF FB Weed NoMulch 60 4 oss sts O65 OO ie a E 12 8 30 Wks 1040 01 01 rare Flower Bed 146 74 SF FB Police by hand 15 1 0 04 0 04 0 76 13 12 30 Wks 1040 01 01 M1 Flower Bed 150 65SF FB Weed No Mulch 60 Exported Weekly Schedule Incomplete due to stop button en i Page 20 of 20 Words 8 031 x 00 _ e Home Insert Page Layout Formulas Data iev View Developer amp Cut Calibri e Wrap Text Generi H 4 Ne tral Calculation ida Copy X Paste B xe P m E j 9 8 398 Conditional Formatas Explanatory T Followed Hyp Hyperlink x Format Painter Formatting Table Clipboard m Alignment E Number Styles
16. A aa aon ara DAT aaa Wo aca a Ln BB BC Days per week 500 Exec mers m e S Least Required Workers per Week 12 45 Productive Hrs Per Da 600 Avail Workers 6 00 Most Required Workers per Week 1320 Most Loaded Week Wk28Juli4 Most Loaded Week Wk28Jul14 Avg Required Workers 1294 A 1 2 3 4 5 6 8 S 10 11 12 13 i IB Eaj 1 8 8 9 3 8 E ei n i si Lal hal La Lal Aja Week Page 20 of 20
17. CANSU I EF OSS RE CEP Dea ree REN EUR P DUUM OHNE LU EUR 6 e FAV I ES A EIEEE E m es 6 e eedem 6 o OEO ara A E EA E A AE A E E AAA E AE AE IA EA E E AA 6 e Vertical SPI OUR fold ERI Eme 6 o kel g74e aves lies o OO O e E E o RS 6 ProScheduler Interface Commands and Display Group csssecccccssssecceceeseeccecaeeececcueseceesauseecessaeaeceeesaeeeeeeeseeeecessuaeeeessueaeseessagagees 6 TOVE O O e E T E 6 e mile s Dow Chart DUTO CR NTu 6 mile SINE Pane Oa E E EE H 6 e SU is OM Se A ic RN x m 6 e Display Different Growing Season Dropdown DUttON cccccccsssssecccceesececccaeeccecsueeceessuaeceesseuseceeseauseceeseueecesseaaeeeesaaasses 6 e Current Row Wks in Growing Season TeXxtbDOX cccccssccccssscccceeecccseneecceuecceseecesseeecessaeceeseaecessaeseeseaecessauseesaussesseeeessaeseesees 7 ProScheduler Interface Commands and Display Group Continued ccccceessssseececeeceeeesececceeceueeseeccceeeeauanseceeeeeesueasseeeeeeeesagneeeeeeas 7 e Save schesdule DHELODI au eeu det npa MIDI On scent dtu De bina OMM DNI a DRM MM ESI DNdUM MUN GM 7 e Eerie go sge et Eisin ie a PNE I mE er ee ene ee ne eee ee eee eT 7 e POG deles RI Tm 7 e HeD O O ea E oceauuaiecebnsacucscmvaareseoyect sanisawarsinsacteaeunaaresepuacveceas
18. GroundsOpsStaff ProScheduler Help Updated 5 1 2014 Recommend you print this file Contents GroundsOpsStaff ProScheduler Help Updated 5 1 2014 cccccccceeeeseeeseeeeeeeeeeeeeeeeeceeeeeeeeeeeeeeeeeeeeeeeeeeeeeeceeeeeeeeeeceeeceeeeeeeeeeeeeeeeeeeeeeeees 1 GroundsOpsStatf ProScheduler Coll c eDE euis cusan snesaencusevsaitoawe lesa ttt uni rated edited Cie il san actus Ru vi iE iE id catre Exc RM EU pru a E NEUE 3 Task Designations Based on Performance Frequency sscccccccssseccccsesecccssusseccecsenseceeseeeseceesaeaeceesaesseceesaeaseceessaasecessuuaecessuaaseessaganses 3 PREC UII SAM E TIT E 3 are cre Tg ES ER ETT ETE m 3 Non Recurring Taskers 3 GroundsOpsStaff ProScheduler Concept and General Steps cccccccsssssccccceseccecseeseceescueeceeseaeseceesseeseceesseeseceeseuaeceesauaeessaaaeeeesseees 4 GroundsOpsStaff ProScheduler Express Scheduling and Balancing ccccssssscccccsseccccceseccecseeseccesaeeseceeseeeeceeseeesecesssuaseeessauaeeeseees 5 ProScheduler Interface Navigation Gi OUS consadstinnsmasieidnncneatiannnsiie ses POI Dead aV denas VI Cn Sx dai dnecacsenonnasn Ar oas Cankan iri CEDNA E aani o aara Niinan eis 6 e siste E Sollte ds i9 s MTS NN m eet 6 e Blue Widi Size of id r8 RN 6 e Green Width Size DUttOTr ssscisooss s pvo Iva PN IRREN WERE Sag edd vELET ba V hos Ue PEFNI a S RUE SUCUS S VR FU MESE VWER
19. Qe v EP vaa Gt cy gu eaE E voe eU tcv ax c Ud pan n tp ena EO vedi SEES 10 83 Shift S l cted Tasks 1 Fg 1 week Defbo cios iienaa E E ed Ub de qus A E A EE Ib SE o E Seu UE 10 8b Shift Selected Tasks 1 Fq 1 week Right ccccccccccccsssssseccceeecseeeseecccceeesaesseeeccesssueeeseeeceeesseeesseeeeeeseuannseeeeeeeeaaganseess 10 E 9a shirt Selected Wasi ball T Wee EBBEL o rs poire riim ro th one Rh sona e Qon dut coxa t oe edis a a tUi Dosis remate Er novI i eds 10 E Sb Shift Selected Tasks fall 1 weele RISE odeur eet Bevor raie ied bula vespere Gu NR UE esa ripe Race A Bea Fer vx ex e Det c vase roe cis 10 Manual Scheduling Command Set Actions 1 Tab i rr i iter ea eo Sap b Ru eS Ve rra Yo cao a SEE Saa YF ebo ot EL s vo aasdansab aeaviadsaysessabesevanedessevaaneanys 10 The Actions 1 Tab contains miscellaneous commands for appearance of the chart and temporary file management 10 e Chart Data PADIS DUCE OD Locus tesa dad secuti ret nt sema ino edu cose Dato Se cosa buses ra Meno Seide os iwsp tb desu duse et ioa irsovt tud dE 10 e Chart Minor Grids DUTON tene deer be e vesushicc pei Da epa aub Ud c Be eeu aut loess naan rU ERR A aut ooo Desc Von esu ue TRE M Usate ad can oae eT 10 e Delete all Closed Temporary Files DUELO er oe e E t E Ree met OE a tva dI wen m E UE eU ici ta me 10 e GAY ATE de EET 11 Automatic scheduling Command Set tAuto 1 Tab rinon mss t te en Eae pe eaa co Ted eoe odb i a oet Euros se Sero e UL Er
20. a White Red or Yellow for the appropriate week White means that now tasks have been scheduled for this week Red means that the required staffing has exceed the available staffing for this week Yellow means that tasks have been scheduled for this week and the required staffing does not exceed the available staffing in other words there is still available staffing to schedule more tasks in this week e 18a All Season Tasks In Selected Rows button Select the cells in the Master Schedule worksheet for which you wish to schedule A Season tasks Then click this button If the Prompt is on checkbox is check then click Yes All All Season Tasks scheduled for the selected rows e 18b All All Season Tasks for Entire Schedule button Click anywhere inside the Master Schedule worksheet Then click this button If the Prompt is on checkbox is check then click Yes All All Season Tasks in the entire schedule for the entire year will be scheduled e 19a All Season Tasks In Selected Rows button Select the cells in the Master Schedule worksheet for which you wish to schedule A Season tasks Then click this button If the Prompt is on checkbox is check then click Yes All All Season Tasks scheduled for the selected rows e 19b All All Season Tasks for Entire Schedule button Click anywhere inside the Master Schedule worksheet Then click this button If the Prompt is on checkbox is check then click Yes All All Season Tasks in the entire schedule
21. al 2 Tab contains command to adjust the weeks the tasks are scheduled in to help achieve balance in the schedule e 6 Shift All Tasks in Row 1 week Left button Select the rows in the Master Schedule worksheet for which you wish shift the schedule to the left by one week then click this button If there is not room in the growing season or performance period to shift the schedule you will receive a message informing you that the shift was not successfully You cannot shift tasks outside of their designated growing season or performance if the Scheduling Outside Season Allowed Scheduling Outside Season not Allowed checkbox is not checked 7 Shift All Tasks in Row 1 week Right button Select the rows in the Master Schedule worksheet for which you wish shift the schedule to the right by one week then click this button If there is not room in the growing season or performance period to shift the schedule you will receive a message informing you that the shift was not successfully You cannot shift tasks outside of their designated growing season or performance period if the Scheduling Outside Season Allowed Scheduling Outside Season not Allowed checkbox is not checked 8a Shift Selected Tasks 1 Fq 1 week Left Select the cells of the tasks you would like to shift then click this button One occurrence frequency of the task will be shifted one week to the left 8b Shift Selected Tasks 1 Fq 1 week Right Select the cells of the tasks you would
22. ccceeeceessseececeesesueseecceeeesuaaseececeeeesuennseceeeeessuensseeeeeeesaugeseceeeeeesuageseceeesaugggseess 19 Exported Weekly Schedule Incomplete due to stop button sssssseeeeesssseeeeenene nennen nennen nennen nn ness nnns 19 PPO ed BRNO D E E 20 GroundsOpsStaff ProScheduler Concept GroundsOpsStaff ProScheduler is an upgrade that allows you to optimally schedule grounds maintenance tasks to weeks in the growing season or performance period You can manually schedule maintenance tasks or use the automatic scheduling feature The manual and automatic scheduling features allow you to create a balanced weekly schedule for your grounds maintenance tasks based on availability of workers and the Least Loaded Week Most Loaded Week protocol GroundsOpsStaff ProScheduler uses a Dynamic Least Most Loaded Week protocol to assist you in creating balanced weekly schedules The manual and automatic scheduling features are explained later in this document GroundsOpsStaff ProScheduler uses the Time to Perform Report to create a master schedule The tasks in the master scheduler are then designated in the master schedule based on the frequency at which they are to be performed within the designated growing season or performance period and the number of weeks in the season or performance period The task designations are described in the below table Task Designations Based on Performance Frequency These are task that are required to be per
23. ceseecccsenseecausseessececseeceseaeceseaecceseseesaesseeseueseeseaecesseasessaes 16 The Master Schedule Chart the Growing Season Performance Period Indicator ROW ccccccccccccccccessesseeeeseceeececessssseeeuuauaeeeeeeees 17 O Master Schedule CHA r eaaa a a uL dM I CM a E 17 Page 2 of 20 O VVC AICO qo die ETE TTE 17 Schedule Balancing Tab Final Schedule Balancing cccccccccccssssseecccceceeeessecceceeeeeeeseeecceeeeaeeesececeeeseueeseceeeeeeuaeeseeeeeesesuaasseeeeeeeeaggees 17 Once the Master Schedule has been completed either manually or automatically there may be a need to further balance the EE a T k E E E E A EE 17 Using Print Export to Export the Chart and the Weekly Schedules to Excel for Printing cccccccccccccsssceeeesseesseceeeeeeeeesseeeeeeeeeuenens 18 The Print Export menu is used to send the Master Schedule and the Master Schedule Chart to Excel Once 18 e Exporting the Master Schedule Chart unii eerta Ir EE oe REN es REMR C eE en 9 Pes OUR ER Y LEAN nM REN eb suu Ip Vo Ou aA Ust tee a aaa e EUM eM stews 18 e Creating and Exporting the Weekly Schedules llsssessesessseeseeeeeene E N E nns nni anne sa annes anrea 18 e Stopping the Weekly Schedules Processing ccccccssscccsssscccssseccsasecccseecccseneceseeeecessuecessauecessuseeseaecessescessaeseeseeeessanseess 18 Exported Weekly Schedule complete ccccccccccecsessee
24. d ff E Week 19 May 10 2010 Week 20 May 17 2010 Week 21 May 24 2010 The List of Scheduled Weeks cells contain hyperlinks you C Week 22 May 31 2010 make it easier for you to navigate to the various weekly schedule worksheets week 26 bn 28 2010 e Stopping the Weekly Schedules Processing the weekly scheduling einige process might take a long time to process depending on how many Week 31 Aug 2 2010 weeks areas and tasks are involved in the processing If you select many weeks to export and change your mind because you do not aaa o H wish to wait for all the weeks to be process you can click the Stop Select All Unselect All Method Processing Weekly Schedules and Export Now button to stop the processing The week in process at the time you click the stop Week 32 Aug 9 2010 button will be incomplete and will contain the note in cell Week 33 Aug 16 2010 A5 Week 1 Jan 4 2010 Week 2 Jan 11 2010 Week 3 Jan 18 2010 Week 4 Jan 25 2010 Week 5 Feb 1 2010 Week 6 Feb 8 2010 Week 7 Feb 15 2010 Week 8 Feb 22 2010 Week 9 Mar 1 2010 Week 10 Mar 8 2010 Week 11 Mar 15 2010 Week 12 Mar 22 2010 DIEIEIBBEDDBBUDDBBELDO Week 34 Aug 23 2010 HIEIFIEIEIEIEIEIEIETETETER Page 18 of 20 Page Layout Formulas Data Review View Developer Calibri N r ay Wrap Text ES d B fa v gt ij S Merge amp Center Conditional Format as F Format Painter n
25. e Red or Yellow for the appropriate week White means that now tasks have been scheduled for this week Red means that the required staffing has exceed the available staffing for this week Yellow means that tasks have been scheduled for this week and the required staffing does not exceed the available staffing in other words there is still available staffing to schedule more tasks in this week e ia Sch Task in Selected Cells Plus Sign button Schedule the selected task s to be performed one more time in the selected week The number already in the cell will be increased by one and the Master Schedule Chart will reflect the increased staffing for the appropriate week e 2 UnSch Task in Selected Cells Plus Sign button Un Schedule the selected task s in the selected weeks The number already in the cell will become blank the cell background will become white and the Master Schedule Chart will reflect the decrease staffing for the appropriate week e 2a UnSch Task in Selected Cells Minus Sign button Schedule the selected task s to be performed one less time in the selected week s The number already in the cell will be decreased by one and the Master Schedule Chart will reflect the decrease staffing for the appropriate week e 3 UnSch Task in Selected Rows button unscheduled all tasks in entire row s for year e 4 UnSch All Tasks in Entire Schedule button unscheduled all tasks in the entire schedule You will always be prompted
26. e files each time it start up However during the session you may have cause many temporary files to be created via your export activity Use this button to delete them during your session You must close any open temporary file before you can delete it e Gray Area reserved for future features based on user feedback Automatic Scheduling Command Set Auto 1 Tab Auto 1 Jauto2 Auto 3 Auto 4 10a Weekly Tasks In Selected Rows Lib All Bi Weekly Tasks For Entire Schedule 12a Monthly Tasks In Selected Rows The Auto 1 Tab contains command buttons to allow you to automatically schedule task in the Master Schedule worksheet To use these command buttons you would first select rows in the Master Schedule worksheet then click the desired command button e The following will occur o The number 1 will be place in the cell for all the scheduled weeks o The background will become green in the scheduled weeks o The Master Schedule Chart will reflect the required staffing for the appropriate weeks o The Week Number Indicator Row will reflect a White Red or Yellow for the appropriate week White means that now tasks have been scheduled for this week Red means that the required staffing has exceed the available staffing for this week Yellow means that tasks have been scheduled for this week and the required staffing does not exceed the available staffing in other words there is still available staffing to schedule more tasks
27. eaeseeariectens 7 o dose DOTT O enaA eee 7 e P POM CE OI r setae tom eateso den telecine Suet ct cts deca E vateuindtna daeciod Sune eee cie sSerleaibeas aelaiuautns became anne capamgean aneeeeuaeeaae tier aae 7 5 Cutrent Eom ANCER teXEDON Gemeente nen eee enn ar E See meen ae teen eee NL r ERI MER Esa EUER NODE ee ae ee eee 7 Setting the Season Performance Start week asccssrnmitcquentYatunntu E ctuctea rue tac cIU tun UM IS IIS TIS INN DEP EMI i stc te tae tateniaaaeaedsiaaiaediastieaede 8 Recall from the user manual that you are allowed to have multiple growing seasons or performance periods in your grounds la dise A w 8 Manual Scheduling Command Set Manual 1 Tab cccccccsseccccceessecceceeeecceeueeeeceeseueeeccsseueeecseseueeecesseueeeeessaueeecessueeeceessuuneesetsaggesss 9 The Manual 1 Tab Man 1 contains command buttons to allow you to manually schedule task in the 9 e TSW ASK an Selected CONUS DUTT OD seceaispdte ai vU SOPORE ERYRA PERI E Sin KU dI bs Xd nO rObOnESI dT inp dite abd d EO CUInE ODER 9 9 la Sch Task in Selected Cells Plus Sign button ia eiecisuas mresibtbs d eiit seu px Ua bPK Rr dukk oi ruo E UR E Ha dn P VIT Sua nt FOL MES np E RR Seu YO Ed EU Fue PRUET 9 e 2 UnSch Task in Selected Cells Plus Sign button cccccsseccccssecccesecccesecccseueecssaseessuececseecessaseessuecesseaeeeseueeessaeeessa
28. f you apply GroundsOpsStaff ProScheduler to only a single crew or zone or other logical subset of your inventory GroundsOpsStaff ProScheduler Concept and General Steps Below are the general steps for using the ProScheduler 1 Open a grounds inventory file into in memory or enter grounds inventory data in the Inventory and Macro Staffing worksheet From the Main Menu click the Inventory and Macro Staffing button Select the grounds areas within the Inventory and Macro Staffing worksheet for which you wish to create a master schedule On the Main Tool click the Reports button Click the Time to Perform by Area and by Task for Selected Levels button After the Time to Perform report is complete click to the ProScheduler button This will activate the Master Schedule worksheet and launch the GroundsOpsStaff ProScheduler Tool as shown in the screenshot below Click the Load Schedule button Click the Create from Time to Perform Report button and click Yes 10 After the Master Schedule has been created read the message on the screen and click OK 11 Click Set Season Start Week button to confirm and or set the Start Week for each of the growing seasons or performance periods in your master schedule how to set the Start Week is explained later in the instructions 12 Use the buttons in the Man 1 Man 2 Actions 1 Auto 1 Auto 2 Auto 3 Auto 4 and Balancing tabs to manually and or automatically schedule the tasks click in a blan
29. for the entire year will be scheduled e 20a All Tasks In Selected Rows button Select the cells in the Master Schedule worksheet for which you wish to schedule All tasks Then click this button If the Prompt is on checkbox is check then click Yes All All Tasks scheduled for the selected rows e 20b All Tasks for Entire Schedule button Click anywhere inside the Master Schedule worksheet Then click this button If the Prompt is on checkbox is check then click Yes All Tasks in the entire schedule for the entire year will be scheduled Page 14 of 20 Aborting Auto Scheduling Process If you change your mind about f th t GroundsOpsStaff Proscheduler LEX comp eung one o e auto Hm Top Rit Hide Panel Set Seasons Start Week Hooded H eee EN scheduling processes you have f em ree BH vse Pn curentcotumn week gt wer zanos sta rted you can abo rt the Man 1 wan 2 Balancing Actions 1 l Eh Avail Workers In Week Le PEE E 7 Click to abort auto scheduling if process by clicking the red nnd you change you mind about 2 UnSch Tasks in Selected Cells completing the automatic C Mins C Hrs Workers ABORT AUTO SCHEDULING o d i eae raten saei seneduling process qv um YU 5 M button f EN a 3s AN Tasks i Scie Howe Total Tasks in Schedule Tasks Not Scheduled Growing A You might want to do this if ent Bie the process is taking longer than you expected Workload Balance Group
30. formed on a recurring basis for the entire season or performance Recurring period See the below examples Task A task that is required to be performed 20 times during a 20 week growing season or performance aSKS period is a Weekly task because the task is required to be performed once per week e Weekly A task that is required to be performed 10 times during a 20 week growing season or performance period is a Biweekly task because it is required to be performed once every two weeks A task that is required to be performed 5 times during a 20 week growing season or performance e Monthly period is a Monthly task because it is required to be performed once per month A task that is required to be performed 15 times during a 30 week growing season or performance period is a biweekly task because it is required to be performed once every two weeks These are tasks that are required to be performed during a specific season If the words Winter Spring Seasonal Tasks Summer or Fall appears in the title of the task then the task is a Seasonal task See the below example e Atasktitle Winter planting is a seasonal task because it has the word Winter in its name Winter e Atasktitle Spring Preparation 200 is a seasonal task because it has the word Spring in its name Spring e A task title Summer fertilizer is a seasonal task because it has the word Summer in its name e Atask title Fall Cleanup is a seasonal task because it has the word Fall in its name NOTE w
31. he first corresponding task e Find Previous button find the previous grounds area with the currently selected growing season If the selected growing season is Winter Spring Summer or Fall this will find the previous corresponding task e Find Next button find the next grounds area with the currently selected growing season If the selected growing season is Winter Spring Summer or Fall this will find the next corresponding task e Right and Left Arrow button shift the start week of the growing season or performance period left or right 8 9 10 32 wu m 3 5 u t i Page 8 of 20 Man 2 Balancing Actions 1 1 Sch Tasks in Selected Cells 2 UnSch Tasks in Selected Cells 3 UnSch Tasks In Selected Rows 4 UnSchedule All Tasks In Entire Schedule The Manual 1 Tab Man 1 contains dor ally schedule task in the Master Schedule worksheet To use these command buttons you would first select cells in the Master Schedule worksheet then click the desired command button e 1 Sch Task in Selected Cells button Select the cells in the Master Schedule worksheet for which you wish to schedule a task Then click this button If the Prompt is on checkbox is check then click Yes The following will occur o The number 1 will be place in the cell o The background will become green o The Master Schedule Chart will reflect the required staffing for the appropriate week o The Week Number Indicator Row will reflect a Whit
32. hen you create your own local matrices you should keep the above designation in mind if you wish Fall ProScheduler to force performance of certain tasks to specific seasons of the year These are tasks that to not recur on a regular basis and are not seasonal See example below Non Recurring e Atask that is required to be performed 6 times during a 20 week growing season or performance Task period and does not have one of the seasons in its title is a Non Recurring task because the task is not as required to be performed each week of the growing season or performance period e Snow Removal to be performed 12 times in a 20 week performance period and does not have one of the seasons in its title is a Non Recurring task because the task is not required to be performed each week of the growing season or performance period e Biweekly Summer IMPORTANT NOTE The Dynamic Least Most Loaded Week protocol involves many recursive calculations and can take a bit of time when applied to large numbers of grounds areas at once While you can apply GroundsOpsStaff ProScheduler to your entire inventory at once it would take at bit of time and might not be Page 3 of 20 the best way to use the tool to produce schedules for your crews to use It is not recommended that you apply ProScheduler to your entire inventory at once except when you are interested in an overall view of the entire schedule for the entire grounds inventory You will achieve better results i
33. ide the worksheet on a week with a red background in the week indicator row Then click this button Non recurring tasks starting from the top will be shifted to the left to an available week until the week is no longer over loaded 9f Balance All Red Weeks Shift Left Non recurring tasks starting from the top will be shifted to the left to an available week until the week is no longer over loaded for all red weeks The process can be aborted by click this button again if you decide not to process remaining red weeks e NOTE After you complete balancing your schedule you must check to be sure ProScheduler did not shift tasks into periods your do not want them for operational reasons or for other special considerations that you have about the tasks Page 17 of 20 Using Print Export to Export the Chart and the Weekly Schedules to Excel for Printing Display Different sprin Set Seasons Start Week Gronna Season ERR Current C Send Chart to Excel Export Weekly Schedules to Excel The Print Export menu is used to send the Master Schedule and the Master Schedule Chart to Excel Once these two items are exported to Excel you may use all of the Excel features to edit the output add notes change format and send to the printer By exporting these two item to Excel you gain all the power and flexibility of Excel to act on the output including printing sending as an attachment in an email converting to acrobat format and so on
34. igned textbox the number of workers hours or minutes assigned to the Most Loaded Week in the currently selected growing season or performance period Avg Assigned textbox the average number of workers hours or minutes assigned for the currently selected growing season or performance period Total Tasks in Schedule the total number of grounds tasks in the Master Schedule Tasks Not Scheduled the number of grounds tasks in the Master Schedule that have not been scheduled yet Page 15 of 20 Productivity Group Avail Workers In Week Wee Mp splay Mode C Mins C Hrs e Workers Hrs Day MS ae The Productivity Group e The follow items are described below o Avail Workers In Week textbox indicates number of worker available per week You will enter this number and or use the up down arrow to adjust this value You can use the Blue button to set number of worker available per week to the number computed by the Time To Perform report You can use the Green button to set number of worker available per week to the number from the Avg Assigned box in the Workload Balance section of the ProScheduler tool The Avg Assigned number represents the average number of workers required for the season currently displayed in the Display Different Growing Season gt box Display Mode Frame Allows you to switch to displaying staffing in Minutes Hours or number of workers Days Wk frame indicates the number
35. ing tasks Weekly Bi Weekly and Monthly Then click this button If the Prompt is on checkbox is check then click Yes All Recurring tasks for the selected rows will be scheduled 13b All Weekly Bi Weekly and Monthly Tasks for Entire Schedule button Click anywhere inside the Master Schedule worksheet Then click this button If the Prompt is on checkbox is check then click Yes All Recurring Task in the entire year for the entire year will be scheduled 14a Winter Tasks In Selected Rows button Select the cells in the Master Schedule worksheet for which you wish to schedule Winter tasks Then click this button If the Prompt is on checkbox is check then click Yes All Winter Tasks scheduled for the selected rows 14b All Winter Tasks for Entire Schedule button Click anywhere inside the Master Schedule worksheet Then click this button If the Prompt is on checkbox is check then click Yes All Winter Tasks in the entire schedule for the entire year will be scheduled Page 12 of 20 Automatic Scheduling Command Set Auto 3 Tab Auto 1 Auto 2 C Auto 3 5 Auto 4 15a Spring Tasks In Selected Rows 17a Fal Tasks In Selected Rows atyjech dule task in the Master Schedule The Auto 3 Tab contains command buttnsite allexelvepde aupemeaticay worksheet To use these commane buttenssyouswould Hiest seleet rows in the Master Schedule worksheet then click the desired command button e The following will occur o The
36. k a space in the ProScheduler Tool and click the Tabs then pause your mouse pointer over the buttons in the Tabs to read a screentip about the scheduling options available to you Use the Print Export button to create Weekly Schedules and send to excel or to send the Master Schedule Chart to excel The Weekly Schedules are plain English schedules listing all tasks to be performed during the week s you select to send to the Excel spreadsheet Note It will take a bit of time to send all 52 weeks to the same Excel spreadsheet For quick output send a few weeks maybe a month to the spreadsheet at a time If you wish to send many weeks at a time you can do so and work on other thing while ProScheduler completes the process Use Excel normal printing feature to send the Weekly Schedules and the Master Schedule Chart to the printer You can freely edit the Weekly Schedules and the Master Schedule Chart spreadsheets since they are not connected to GroundsOpsStaff after they have been created Page 4 of 20 x GroundsOpsStaff GroundsOpsStaff V1xis Compatibility Mode o ProScheduler Interface or ProScheduler Tool gt Master Schedule Chart Growing Season Performance Period Indicator row a Embedded Show Hide button Show Hide the ProSchedule Tool Grounds sOpsStaff Proscheduler Pr Prev Grnd Area Prev Grnd Area Area Available Staffing Input Box To Inventory Hide Chart Set Seasons Start Week
37. ng point to the top left cell in the Master Schedule worksheet Top button move inserting point to the top row in the Master Schedule worksheet Flt button move inserting point to the far left column in the Master Schedule worksheet Vertical Spin button move inserting point to the next and previous row in the Master Schedule worksheet Horizontal Spin button move inserting point to the next and previous column in the Master Schedule worksheet ProScheduler Interface Commands and Display Group NN 3 Hide Panel um mum eee Different Current Row Wks in 35 To Inventory Hide Chart Hide Pane Set Seasons Start Week PNEU caa 30 a Save Schedule Load Schedule Print Export Help Chose P n Current Column Week gt gt Wk 32 Aug 09 To Inventory button Deactivate the Master Schedule worksheet close the ProScheduler Interface and return to the Inventory and Macro Staffing worksheet Hide Show Chart button hide or show the Master Schedule Chart to see more or less of the Master Schedule worksheet data Hide Show Panel button hide or show the Master Schedule Panel tall gray area at the top of the worksheet to see more or less of the Master Schedule worksheet data Set Season Start Week launch the Set Season Start Week menu to allow you to set the start week for each of the growing season or performance periods contained in your master schedule Use of this feature is explained later in
38. nseeseas 9 e 2a UnsSch Task in Selected Cells MINUS Sign DUTTON sic scio to tos Qo epa tar Rb aot RR IR S ETEUUE na tw TY RIT Hr FoU Up SR E TUNE Ea 9 e 3 UnSch Task in Selected Rows button cccccssssccccseecceeececceseccseueeessaeceeseaeeessueeeseaeeeesauseeseauseessueessaueeesaausesseaesessaneessees 9 o 4 UnSch All Tasks in Entire Schedule button ccccceseccccccssseececseeseceeeceeseceeeaeasececessaseceessseneceeseaasecesssaeaseeessagueceessagaeeeeees 9 Prompt is on Prompt is off checkbox ccccceeeseeeeeeesseeeseeeseeeeeseeeeseeeeeeeeseseeeeeeeseeeeeseseseeeeeeeeeeeeeeeeeseeeseeeeeseeeeeseeeeeeeeeeeess 9 Page 1 of 20 e Season Auto Scroll is on Season Auto Scroll is off checkbox eee eccecccsecccceccccececcececsececeecccaececsecccuucecaucecaecenseeecsncecaueees 9 e Scheduling Outside Season Allowed Scheduling Outside Season not Allowed checkbox eere 9 Manual Schedulingcommand SetiMatiual 2 T3bD sets tiber tio Ue qus bel Qe ev Cabe nats Duo iweststte ieslanh ace entro Spe tutes pale eros do Os bee eoo as ds 10 The Manual 2 Tab contains command to adjust the weeks the tasks are scheduled in to help achieve balance in the schedule 10 e 6 Shift All Tasks in Row 1 week Left button ccc ceccccesseccceseccceesececsuececceeececseeceseueccesenecesseseceseuecessenecessuecesenecetsenecets 10 e Z Shift All Tasksin Row 1week Right DULEtOT sd oos enkv tuba Ee patentes eua b vk x SER
39. number 1 will be place in the cell for all the scheduled weeks o The background will become green in the scheduled weeks o The Master Schedule Chart will reflect the required staffing for the appropriate weeks o The Week Number Indicator Row will reflect a White Red or Yellow for the appropriate week White means that now tasks have been scheduled for this week Red means that the required staffing has exceed the available staffing for this week Yellow means that tasks have been scheduled for this week and the required staffing does not exceed the available staffing in other words there is still available staffing to schedule more tasks in this week e 15a Spring Tasks In Selected Rows button Select the cells in the Master Schedule worksheet for which you wish to schedule Spring tasks Then click this button If the Prompt is on checkbox is check then click Yes All Spring Tasks scheduled for the selected rows e 15b All Spring Tasks for Entire Schedule button Click anywhere inside the Master Schedule worksheet Then click this button If the Prompt is on checkbox is check then click Yes All Spring Tasks in the entire schedule for the entire year will be scheduled e 16a Summer Tasks In Selected Rows button Select the cells in the Master Schedule worksheet for which you wish to schedule Summer tasks Then click this button If the Prompt is on checkbox is check then click Yes All Summer Tasks scheduled for the selected rows e
40. oe VR Cre PER tabe cepa RU 11 The Auto 1 Tab contains command buttons to allow you to automatically schedule task in the sseesssse 11 e 10a Weekly Tasks In Selected Rows button csinos orot nn ENN a a E 11 e 10b All Weekly Tasks for Entire Schedule button lseeeessssseeeeeseeeeennneennnn nennen nennen nennen nnns nares nnns nnns 11 e l13 BI Weekly Tasks In Selected ROWS DUTTON oie e Ete er oe ora NO noctes ata vE a nde aav oen AEN Esc ra oa ux ERR DE VU SEE EV E SeE 11 e 11b All Bi Weekly Tasks for Entire Schedule button ssseeesssserssssseessssecressrecesssreressseeresssecressrecesssrerosssreressseceessreresseeresese 11 e tta Monthly Tasks In Selected ROWS DUEEOL eins ta RS RENE OC Pete EUR ds ERE E C YXRB ee ERE tu Ra icd YER una GRE Qu VUA laws 11 e 11b All Monthly Tasks Tor Entire Schedule DU EtOTD eio oerte terio Pep eaae beso te De o Yeu vo eo Pe pud Ero seb ee epe Ie ta Ee p obra e Io SONS 11 Automatic Scheduling command Set Auto 2 Tab uidi cse terii eri heu da NER CE ann Miet s vata dU epa o Peta S e rev bue ere au Corde Ra ue LN Ed P PEN EO Pee ERE OUS 12 The Auto 2 Tab contains command buttons to allow you to automatically schedule task in the sssse 12 e 13a Weekly Bi Weekly and Monthly for Entire Season for Selected Rows button essssssessseserreserrrssrrrssrresserrsserreseeees 12 e 13b All Weekly Bi Weekly and Monthly Tasks for En
41. of days per week being used by ProScheduler to create the Master Schedule Click the Blue button to set to the number in your configuration form Hrs Day frame indicates the number of productive hours per day for the grounds workers Click the Blue button to set to the number in your configuration form Using the Master Schedule Chart and Color Coding GroundsOpsStaff Proscheduler X d Hm To F Display Different 39 Current Row Wks in 39 p Rit Prev Grnd Area To Inventory Hide Chart Hide Panel Secs d Growing Seaon gt gt Bm Fre Next Grnd Area Save Schedule Load Schedule Print Export Hep cose n n Current Column Week gt Wk 7 Feb 15 Manual 1 Manuak 2 Actions 1 Auto 1 Auto 2 Auto 3 Auto 4 er Pie M um Avail Worker In Week ea oa Most o First 0 54 1 Sch Tasks in Selected Cels 18a All Season Tasks In Selected Rows Wk 14 Apr 05 Wk 13 Mar 29 ETE H Display Mode trt Tacks in Selected Cells Go To To Next C Mins C Hrs Workers Growing Season Performance In Selected Rows 19a Non Recurring Tasks In Selected Rows e Hrs Day 53Wks E 2 26 T 62 Wkrs MS li asks In Entire Schedule v Season Auto Scrollis OF 20a All Tasks In Selected Rows Total Tasks in Schedule Tasks Not Scheduled Growing Season 645 105 Wk 1 Jan 04 30 wks mmm wo N Period Indicator Row Growing Season Performance Period Indicator Row
42. ormed during specific weeks You can also use the manual commands in Tabs 15 Use the Print Export button to create Weekly Schedules and send to excel or to send the Master Schedule Chart to excel The Weekly Schedules are plain English schedules listing all tasks to be performed during the week Note It will take a bit of time to send all 52 weeks to the same Excel spreadsheet For quick output send a few weeks maybe a month to the spreadsheet at a time If you wish to send many weeks at a time you can do so and work on other thing while ProScheduler completes the process 16 Use Excel normal printing feature to send the Weekly Schedules and the Master Schedule Chart to the printer You can freely edit the Weekly Schedules and the Master Schedule Chart spreadsheets since they are not connected to GroundsOpsStaff after they have been created ProScheduler Interface Navigation Group Prev Grnd Area Next Grnd Area Red Collapse Expand use this button to expand and contract the width and length of the ProScheduler interface so you can see more or less of the Master Schedule worksheet Blue Width Size button use this button to expand and contract the width of the ProScheduler interface SO you can see more or less of the Master Schedule worksheet Green Width Size button use this button to expand and contract the height of the ProScheduler interface so you can see more or less of the Master Schedule worksheet Hm button move inserti
43. rksheet Then click this button If the Prompt is on checkbox is check then click Yes All Monthly Tasks in the entire schedule for the entire year will be scheduled Page 11 of 20 Automatic Scheduling Command Set Auto 2 Tab auto 1CAuto 2 autos Auto 4 13a Weekly Bi Weekly and Monthly Tasks for Entire Season for Selected Rows The Auto 2 Tab contains command buttons to allow you to automatically schedule task in the Master Schedule worksheet To use these command buttons you would first select rows in the Master Schedule worksheet then click the desired command button e The following will occur o The number 1 will be place in the cell for all the scheduled weeks o The background will become green in the scheduled weeks o The Master Schedule Chart will reflect the required staffing for the appropriate weeks O The Week Number Indicator Row will reflect a White Red or Yellow for the appropriate week White means that now tasks have been scheduled for this week Red means that the required staffing has exceed the available staffing for this week Yellow means that tasks have been scheduled for this week and the required staffing does not exceed the available staffing in other words there is still available staffing to schedule more tasks in this week 13a Weekly Bi Weekly and Monthly for Entire Season for Selected Rows button Select the rows in the Master Schedule worksheet for which you wish to schedule all recurr
44. roScheduler Express Scheduling and Balancing Below are steps for using the ProScheduler to quickly generate a balanced schedule with minimum manual effort 1 Open a grounds inventory file into in memory or use the inventory data already loaded into memory or enter grounds inventory data in the nventory and Macro Staffing worksheet 2 From the Main Menu click the Inventory and Macro Staffing button Select the grounds areas within the Inventory and Macro Staffing worksheet for which you wish to create a master schedule On the Main Tool click the Reports button Click the Time to Perform by Area and by Task for Selected Levels button After the Time to Perform report is complete click to the ProScheduler button Click the Load Schedule button Click the Create from Time to Perform Report button and click Yes Read the message on the screen and click OK 10 Click Set Season Start Week button to confirm and or set the Start Week for each of the growing seasons or performance periods in your master schedule how to set the Start Week is explained later in the instructions 11 Click Auto 4 Tab Then click 20b All Task For Entire Schedule button This will automatically schedule all tasks in the schedule You may notice that in the Week row in the worksheet some of the cells are eg Over scheduled for the week Yellow Under scheduled for the week or Green exactly scheduled for the week 12 Enter or verify the number
45. roughly equal to the number of workers available White means that no tasks have been scheduled for the week i iii T j 9c Balance Selected Red Week Shift Right 7 9d Balance All Red Weeks Shift Right 1 Red Weeks More tasks 12 13 14 15 16 gta pene a 9e Balance Selected Red Week Shift Left available workers 9f Balance All Red Weeks Shift Left Once the Master Schedule has been completed either manually or automatically there may be a need to further balance the schedule Some weeks may have more tasks assigned to them than there are available workers When this occurs the week number indicator cell will have a red background Use button 9c 9d 9e and 9f to automatically shift non recurring tasks to the right or left e Use the following technique to balance the schedule o 9c Balance Selected Red Week Shift Right click inside the worksheet on a week with a red background in the week indicator row Then click this button Non recurring tasks starting from the top will be shifted to the right to an available week until the week is no longer over loaded 9d Balance All Red Weeks Shift Right Non recurring tasks starting from the top will be shifted to the right to an available week until the week is no longer over loaded for all red weeks The process can be aborted by click this button again if you decide not to process remaining red weeks 9e Balance Selected Red Week Shift Left click ins
46. tire Schedule DUttON cccccccsssseceeceeeeceeeeeeeceeeeeaseceesauaeeessees 12 e t4a Winter Tasks n Selected ROWS DUTON S aseo nci er aeter en Oo cumes te lotos tuba tete ox tue atdsev tat co tutes ou Eu cu oS eR p VE OU IUE 12 e 14b All Winter Tasks for Entire Schedule button cccccccssrescsssscucusuceceusrencavsscneueuceccustencacsseneusuceseusteneuesencuscesensrencaces 12 Automatic Scheduling Command Set AuUto 3 T3D isvsntessidetevsa usas pU O saut s cv e st nectare eran rust lb E cec uu uds 13 The Auto 3 Tab contains command buttons to allow you to automatically schedule task in the sssse 13 e 158 Spring Tasksn Selected ROWS DUTTON qe deret a rei on edes T a oad ic dace lad O Re HUE EE RE 13 e 155 AILSptribig Tasks ftor Entire Schedule DUELO wietse e scaduta o tete dete ee iSt eene tede tents Pots Put atu a Detur E e 13 e 16a SUMMER Tasks In Selected ROWS DUTTON e iscuen cua IR T eto E Cun EE v ha aan eR tvm S Ca rp ner rd s ct di 13 e 16b All Summer Tasks for Entire Schedule button eeesseeeesseeeeeeeneeene nennen nnnm nest 13 e Tas ball Tasksdm selected ROWS DUTTON itio eo br D uin T ee mated dip UL MEE 13 e IZbcAILFall Tasks dorntire Schedule DULtOss oisi ecu e eodo tun idit eos edo u qu eua ap otcen i idvea a vidt edipi dues bet oB zal bistro e e detus ce dip dibus ds 13 Automatic Scheduling Command Set Auto 4 Tab ihe etii eee rae dedi o aer uuo E up ek a vau
47. to confirm this action since it unscheduled the all tasks for the entire schedule and there is no undo feature e Prompt is on Prompt is off checkbox turns on or turns off prompting before execution e Season Auto Scroll is on Season Auto Scroll is off checkbox turns on or turns off season auto scroll When season auto scroll is on the Master Schedule worksheet will scroll the start week of the select task s growing season to the first column of the worksheet This is intend to help you keep a good visual of the growing season for each task by observing the background color of the Growing Season Performance Period Indicator Row e Scheduling Outside Season Allowed Scheduling Outside Season not Allowed checkbox turns on or off scheduling outside the growing season or performance When off you cannot schedule a task outside of its designated season or performance period this is the default is the mode that you would most likely use until you are ready to make minor manual adjustments to your schedule that require moving tasks outside of their designated season or performance period Page 9 of 20 Manual Scheduling Command Set Manual 2 Tab CMan 2 Balancing Actions 1 6 Shift All Tasks in Row 1 week Left 7 Shift All Tasks in Rows 1 week Right 8a Shift Selected Tasks 1 Fq 1 week Left 8b Shift Selected Tasks 1 Fq 1 week Right 9a Shift Selected Tasks all 1 week Left 9b Shift Selected Tasks all 1 week Right The Manu
48. ults to 13 weeks and cannot be changed in the current release of GroundsOpsStaff e Steps for setting the start week for growing seasons or performance period o Click the Set Seasons Start Week button to launch the Set Growing Season Start Week menu o Inthe Set Growing Season Start Week menu click desired growing season or performance period o Observe the Growing Season textbox that displays the currently selected growing season or performance period o Observe the Current Column Week textbox that displays the week of the currently selected column in the worksheet o Click inside of the worksheet on the week you want to designate as the start week for the desired growing season or performance period o Click the Set Growing Season Start Week button o Observe the green highlighted cells in the Month gt row of the worksheet This gives you a visual representation of the growing season or performance period o Repeat for all growing season and performance period o Save the Master Schedule to disk to preserve the start week settings The Start Week settings will be preserved in the saved Master Schedule file and you do not have to set them each time you load the Master Schedule o You can now use the Tab Commands to manually and or automatically schedule tasks e Find First button find the first grounds area with the currently selected growing season If the selected growing season is Winter Spring Summer or Fall this will find t
Download Pdf Manuals
Related Search