Questions & Answers

Q: I would just like a few cells unprotected near the top of the Calculation Summary so I can factor in some percentages for taxes etc. to give me a more accurate picture.

A: To add some additional formula etc it may be best to link to a new workbook as the calculator is dynamic in structure and adds/removes/hides rows/columns as part of its processing. To add your own formula simply open a new workbook and then click on the cell where you want the data to be displayed, type in = and then click the source data cell in the calculator. This allows you to add any data from the caluclator in any order/arrangment you like and then add formula to provide additional information as required. Because the data is linked to the calcualtor when the calcualtor data changes the new workbook data will change efficivly making it as dynamic as the calcualtor.

Question and Answer Item 73 - Browse All Question and Answer Items

Q: I would like the password to unprotect the workbook. I want to add some of my own info. I will save the origional, (protected) so there will be no issuses.

A: With our standard Non-Commercial license all non-input cells and Visual Basic code are protected to ensure integrity and protect source code. We do offer Commercial licenses for the use of software for inter-business support, advice, or consulting and upon request with a Commercial license can provide an unprotected software version allowing you to view the formula applied to enhance your knowledge of software operation (macros remain protected). You can upgrade from a Non-Commercial license to a Commercial license at https://bizpep.com/upgrade.html . Depending on what you are trying to do you can always link from cells in the Wage Calculator to a new workbook and arrange the data/display any way you like. That may provide what you require.

Question and Answer Item 74 - Browse All Question and Answer Items

Q: I am looking for a scheduler that would be suitable for nursing staff. In our case the shifts are (1) 07:30-15:30, (2) 13:30-21:30 and (3)21:00-08:00. There is a 0.5 hour handover time for the 1st and 3rd shift and a 2 hour overlap on the 2nd shift. Is there any way I can do this with your normal scheduler that I have just downloaded? This seems to be a common need in many hospital and hospice wards where continuous cover of nursing staff is required. Any help would be most welcome.

A: Yes, you can have overlapping shifts by simply setting the shift start time and duration. By default these roll on from the previous shift however you can overwrite them (yellow cells). The main requirement is that the shifts are arranged in chronological order.

Question and Answer Item 59 - Browse All Question and Answer Items

Q: I love the software, I would like to understand is it possible to have more than one department? I am looking at the staffing levels of Small to Medium sized hotels, so would need to create rotas for 2 bars, 2 kitchens, cleaning team and GA. Can this software be altered to achieve this with ease

A: Thanks for the feedback. If the departments are completely separate (ie the same staff do not work in both departments) then you can simply run 2 separate shift schedules ie save the file with a different name and have a separate file for each department. Alternatively you can setup separate shifts for each department within the same scheduler ie treat each department as a different shift even of it is the same time as other departments. With this method any staff maybe allocated to any shift (department).

Question and Answer Item 60 - Browse All Question and Answer Items

Q: When I 'Show Details' for each staff member, there appeared to be some weird dates in the 'Next Initiation' column, about 12 month into the future and various flags were set. I tried using a Clear Roster, but that didn't do anything. I then tried Clear Next. This seemed to clear all cells in that column and I was able to create a new roster. Did I miss something or have I uncovered an undocumented feature?

A: When Next Roster is clicked it sets values in the hidden Next Initiation column (displayed with Show Details). This rolls existing details over into a new shift period allowing you to build rolling shifts while remembering what has happened in the past. As you found Clear Next will reset these values. Details on this are included under Next Roster in the Help file.

Question and Answer Item 61 - Browse All Question and Answer Items

<< < Page 281 282 283 284 285 286 287 288 289 290 > >>