Questions & Answers

Q: I was wondering if there is a possibility to have a customized version, or at least be able to set some of the other variables. I am looking to determine how many service points are needed (based on a single queue/multiple service points model) that meet the following KPI baseline - Average Waiting Time: 10 minutes - Zero Occurences where customers wait for more than 30 minutes - 95% of all customers are served in less than 15 minutes I also would like to maximize the utilization of the service points.

A: The other "variables" are all calculations based on the inputs provided so they are not really variables at all. If the model was redesigned the inputs could be swapped for some of the calculations ie input average waiting time etc however this would be a substantial rework and it would probably be best to simply develop a queuing formula structure to suit your specific needs. You could achieve a similar result by adjusting current variables ie manually change the Number of Service points to find the best Average Waiting time required (as service points are integers the actual waiting time possibilities may never closely approach your required value). The zero occurrences and 95% requirements do not fit within standard formulation theory (more thought required). Maximising utilisation can be calculated by simply setting the Cost of Waiting to 0, this will usually result in a decrease in Service Points but an unacceptable Customer Waiting time. If you wanted to explore the model functionality we do offer Commercial licenses providing an unprotected software version allowing you to to view the formula applied, access cell contents to enhance your knowledge of software operation (macros remain protected) and undertake minor refinements (ie headings etc). In this format application sheets are unprotected, the workbook itself and the Terms and Conditions and Instructions sheets remain protected to maintain licencing and intellectual property rights notification. You can upgrade from a Non-Commercial license to a Commercial license at https://bizpep.com/upgrade.html . To access the source code of our software including the visual basic code (macros) a Source License is required. This license allows you to modify and adapt all components of the software to meet your specific needs. Source licensing fees are 3 times Commercial licensing fees. Source Code License details are available at https://bizpep.com/SourceLic.html . Please note that Bizpep retain full copyright and intellectual property rights at all times. Hope this helps.

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

Q: Can my form report the search string that was used to find my site?

A: Yes, if you record the referrer as a cookie then this will be sent with the form data on submission if you set Include User cookies, see https://bizpep.com/form1/ . We use this method ourselves setting a cookie the first time a user comes to one of our sites with the referrer domain or a query value to track affiliates and promotion sources, this is then submitted with any further actions ie form submission/purchase etc. You can set your cookie using javascript or php. If you are unsure how to set a cookie a quick search for php $_SERVER['HTTP_REFERER'] or javascript set cookie will provide lots of resources. Using php would be preferable.

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

Q: Is there a way I can have more input tabs? I would like to have it so I can have a roster for team leaders, managers and so on. We will only need 1 of these to work the shift however we will need 5 other members during the shift.

A: The input template is not required with the newer version as all staff / shifts can be added directly to the roster matrix on the input sheet. To have a roster for team leaders simply save your roster file with a new name ie ShiftLeaders and you will have a template you can set up with team leaders instead of staff ie you will have 2 files one setup for staff and one setup for leaders.

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

Q: Is there any way to change the layout of the format print?

A: You cannot change the generated Format Print structure however the Format Print sheet is not protected and all formatting can be adjusted as required. You can also copy and save the Format Print sheet in a new Excel workbook or link parts of it to a new workbook. This allows you to freely adjust it to suit your needs.

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

Q: Firstly love the product... Think this will be what we will be using in our company, however I was hoping you might be able to help me with a few things. We have staff who cannot work some days. Is there anyway I can exclude days for staff members?

A: Thanks. To force a staff member to must not work input a "N" in the staff shift cell, to work a specific shift input a "Y" in the staff/shift cell. So you can just input a N for the days/shifts they cannot work on the Input sheet. Also the software version you are using has been superseded you can access and downland the current software version from https://bizpep.com/shiftscheduler.html the Help file for this version is at https://bizpep.com/shiftscheduler.html .

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

<< < Page 41 42 43 44 45 46 47 48 49 50 > >>