{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Coversheet and Instructions","1. Affiliated Drivers","2. Affiliated vehicles","3. Areas where trips provided","4. Wait times for trips","5. Wait times for WAT & TSS","TSA tables (to be hidden)"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":24,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Coversheet and Instructions","index":0,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[[19,0,19,4],[11,0,11,4],[12,0,12,4],[20,0,20,4],[17,0,17,4],[18,0,18,4],[16,0,16,4],[0,1,0,4],[2,0,2,4],[3,0,3,4],[15,0,15,4],[1,0,1,4],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[13,0,13,4],[10,0,10,4],[14,0,14,4],[25,0,25,4],[26,0,26,4],[29,0,29,4],[21,0,21,4],[22,0,22,4],[24,0,24,4],[28,0,28,4],[27,0,27,4],[23,0,23,4]]}
[null,"Authorised booking entity quarterly report"]
["Form F5231 CFD   V01 September 2018 "]
["Authorised booking entities are required to use this form to report their quarterly information to the Department of Transport and Main Roads as required under the Transport Operations (Passenger Transport) Regulation 2018.  "]
["Authorised booking entities are required to provide their completed form electronically to the department within 28 days of the end of each quarter of the financial year. The quarterly due dates are: 28 January, 28 April, 28 July and 28 October."]
[null,null,{"$f":"MID(CELL(\"filename\"),SEARCH(\"[\",CELL(\"filename\"))+1, SEARCH(\"]\",CELL(\"filename\"))-SEARCH(\"[\",CELL(\"filename\"))-1)","v":"Quarterly_reporting_form_WEB v98.xlsm"},{"$f":"SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LEFT(LOWER(C6), 5), \"a\", \"1\"), \"e\", \"2\"), \"i\", \"3\"), \"o\", \"4\"), \"u\", \"5\")","v":""}]
["Authorised Booking Entity name:"]
["Trading Name:"]
["Booking Entity Authority Number:"]
["Quarterly Period:                                                                 From:",null,"2019-07-01","           To:","2019-09-30"]
[null,null,"(dd/mm/yyyy)",null,"(dd/mm/yyyy)"]
[]
["Using the form"]
["You need Microsoft Excel 2007 or later to use this form. The form will not work properly on other software such as Apple Number, WPS Spreadsheets or Open Office Calc."]
["Completing the form"]
["Each time you open the form, please press the 'Enable Content' button at the top of the form. This will enable the macros in the form and make the form function properly."]
["Please complete the details in the grey box above and then fill in the required information on the worksheets in this report. Information can only be added to certain boxes in the report. To help you fill out the report, further information is provided on each worksheet.    "]
["If you are cutting and pasting information into the report from another source, you must ensure you do not alter the formatting in the report. This can be done by pasting the information using the right mouse button and selecting the 'Match Destination formatting' paste function."]
["Saving the report"]
["Press the 'Save to Desktop' button on the right to save this report to the Desktop on your computer.  You will be able to reopen the report to add or change information before sending the report to the Department.  "]
["If you have reports for a previous quarter saved on your Desktop, please move them to another location on your computer before using the 'Save to Desktop' button in this report. "]
["If you add to or change a report that is already saved on your Desktop and then use the 'Save to Desktop' button, you will be asked if you want to replace the existing file. Please click the 'Yes' button to replace the earlier version of the report and save the updated report."]
["Sending the completed report to the Department of Transport and Main Roads"]
["When you are ready to send the completed form to the Department, please press the 'E-mail and Save' on the right. This will attach the report to an e-mail from your usual e-mail address. The e-mail address of the Department will be automatically added to the e-mail. You will then need to press the send button on the e-mail to send the report to the Department. The form attached to the e-mail will be protected by a password, so that it can only be opened and viewed by the Department.          "]
["If you try to send a form to the Department that does not include all the required information, you will get an error message asking you to fill in the missing information. You will not be able to e-mail the form to the Department without adding the missing information.  "]
["Further information"]
["For further information or assistance with this form, please contact:"]
["personalised.transport@tmr.qld.gov.au"]
[]
["Privacy Statement"]
["The Department of Transport and Main Roads (TMR) is collecting information on this form under the authority of the Transport Operations (Passenger Transport) Act 1994 (TOPTA) and the Transport Operations (Passenger Transport) Regulation 2018 (TOPTR).  TMR is collecting the information for the purposes of: monitoring service performance, demand and changes in the personalised transport industry; undertaking evidence-based analysis of industry performance and sustainability; monitoring the effects of the personalised transport reform framework; and assisting the Chief Executive to comply with obligations relating to the development, operation and funding of public passenger transport. Aggregated industry information may be published on the department’s website. Some of this information may also be disclosed to relevant government agencies. Entity specific information will not be disclosed to any other third party without your consent unless the disclosure is authorised or required by law."]

{"sheet":"1. Affiliated Drivers","index":1,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[15,0,16,0],[12,0,12,2],[9,0,9,2],[0,0,0,2],[2,0,2,2],[5,0,5,2],[7,0,7,2],[11,0,11,2],[1,0,1,2],[3,0,3,2],[14,0,14,2],[6,0,6,2],[13,0,13,2]]}
["1. Affiliated Drivers"]
[]
["Authorised booking entities are required to report the details of all drivers who were affiliated with them during the quarter.      "]
[]
["Who is an affiliated driver"]
["An affiliated driver is a person who has an arrangement with an authorised booking entity under which the entity arranges bookings for the driver to provide booked hire services. "]
["This includes affiliated drivers that did not provide any services during the quarter and any drivers that an entity 'subcontracted' bookings to, for example, to meet demand for a large event. "]
["An affiliated driver is also a person who is an authorised booking entity and drives a vehicle to provide booked hire services."]
["Driver authorisation number"]
["A driver's driver authorisation number is printed on the driver's Industry Authority Card issued by the Department of Transport and Main Roads."]
["Start and end dates of affiliation"]
["The start date for each driver's affiliation must be provided in each quarterly report. If a driver is affiliated for a more than one quarter, the original start date should be provided in each quarterly report ."]
["If a driver's affiliation ends during a quarter, the end date must be reported. The driver's details do not then need to be included in subsequent reports, but the authorised booking entity must retain the driver's details for two years from the end date."]
["If a driver is affiliated throughout the reporting period, please do not include an end date in the column. It is not necessary to put the end date of the reporting period in the column if a driver is affiliated on an ongoing basis."]
[]
["Driver authorisation number","Start date of affiliation","End date of affiliation"]
[null,"(dd/mm/yyyy)","(dd/mm/yyyy)"]

{"sheet":"2. Affiliated vehicles","index":2,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,3],[5,0,5,3],[2,0,2,3],[15,0,16,0],[15,1,16,1],[10,0,10,1],[7,0,7,3],[11,0,11,3],[12,0,12,3],[3,0,3,3],[1,0,1,3],[14,0,14,3],[8,0,8,3],[9,0,9,3],[13,0,13,3]]}
["2. Available vehicles"]
[]
["Authorised booking entities are required to report the details of all vehicles that were available to be used to provide a booked hire service during each quarter.      "]
[]
["Available vehicles"]
["'Available vehicles' are taxis, limousines and booked hire vehicles that were available to be used during the quarter. This includes vehicles that were available but were not used to provide any services during the quarter. "]
["Vehicle service licence number"]
["The vehicle service licence number is the taxi service licence number, limousine licence number, special purpose limousine number or booked hire service licence number for a vehicle. "]
["The licence number is different to the vehicle registration number and can be found on the Taxi Service, Limousine or Booked Hire Service Licence for the vehicle."]
["For substitute taxis, which do not have licence numbers, please put ‘Substitute Taxi’ in the service licence column."]
["Start and end dates of availability"]
["A start date for each vehicle's availability must be provided."]
["If a vehicle's availability ends during a quarter, the end date must be provided in the report. The vehicle's details do not then need to be included in subsequent reports, but the authorised booking entity must retain the vehicle's details for two years from the end date."]
["If a vehicle is available throughout the reporting period, please do not include an end date in the column. It is not necessary to put the end date of the reporting period in the column if a vehicle is available on an ongoing basis."]
[]
["Vehicle registration number","Vehicle service licence number","Start date of availability","End date of availability"]
[null,null,"(dd/mm/yyyy)","(dd/mm/yyyy)"]

{"sheet":"3. Areas where trips provided","index":3,"n_rows":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":false,"merged":[[14,0,14,1],[15,0,15,1],[9,0,9,1],[10,0,10,1],[16,0,16,1],[13,0,13,1],[0,0,0,1],[2,0,2,1],[7,0,7,1],[12,0,12,1],[4,0,4,1],[3,0,3,1],[1,0,1,1],[5,0,5,1],[11,0,11,1],[6,0,6,1],[8,0,8,1]]}
["3. Taxi service areas where booked hire service trips are provided"]
[]
["For each quarter, all authorised booking entities are required to report the areas in which booked hire trips they arrange are provided."]
["Booked hire trips include those provided using taxis, limousines and booked hire vehicles."]
["The areas are the relevant taxi service area in which a trip starts. "]
[]
["Completing the worksheet"]
["Regions and taxi service areas can be chosen from the drop down menus in the table below."]
["Please select a region and a taxi service area. For example, if you select the South East Queensland region, you also have to select a taxi service area in that region. You cannot select just the South East Queensland region.  "]
["Taxi service areas only need to be included in the report once, regardless of the number of trips that start in the area. For example, the Brisbane taxi service area is to be reported once whether 1 or 1,000 trips start in the area during the reporting period.    "]
["Taxi service areas that are included more than once will be highlighted in red. Please remove any duplicates before sending the form to the Department of Transport and Main Roads.  "]
["Taxi Service areas"]
["Taxi service area maps and descriptions are provided on the Transport and Main Roads website at: "]
["https://www.tmr.qld.gov.au/business-industry/Taxi-and-limousine/Industry-information/Taxi/Taxi-fares-service-areas-and-maps "]
["A list of the suburbs in each taxi service area is also available on the data keeping and reporting webpage at:"]
["https://personalisedtransport.tmr.qld.gov.au/data-requirements"]
[]
["Region","Taxi Service Area"]

{"sheet":"4. Wait times for trips","index":4,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,1],[2,0,2,1],[5,0,5,1],[8,0,8,1],[9,0,9,1],[7,0,7,1],[13,0,13,1],[1,0,1,1],[3,0,3,1],[11,0,11,1],[12,0,12,1],[10,0,10,1]]}
["4. Wait times for trips"]
[]
["All authorised booking entities are required to report summary information about the wait times for the booked hire trips they arrange. This includes trips provided in taxis, limousines and booked hire vehicles."]
[]
["Relevant trips"]
["The information reported in this worksheet is for all trips that are not provided to members of the Taxi Subsidy Scheme (TSS) or provided to a passenger using a wheelchair. Wait time information for these trips is to be reported separately in worksheet 5."]
["Calculating wait times"]
["The wait time is the time that a passenger waits for a booked vehicle to arrive."]
["Authorised booking entities are required to keep information about the days and times bookings are made and the days and times journeys start. This information is used to calculate the wait time information that is reported. "]
["Wait times for trips are determined by the nature of the booking:"]
["- If a booking is made for an immediate pick-up, the wait time is the time between when the booking is made and the time the trip starts"]
["- If a booking is made for the vehicle to arrive at a certain time, the wait time is the difference between the booked time and the time the trip starts."]
["- The information for each trip is used to calculate the average wait time and percentage of trips with a wait time of more than 20 minutes."]
[]
[null,"Time/ Percentage"]
["Average wait time (in minutes)"]
["Percentage of trips with a wait time of more than 20 minutes (%)"]

{"sheet":"5. Wait times for WAT & TSS","index":5,"n_rows":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":false,"merged":[[14,0,14,1],[7,0,7,1],[0,0,0,1],[2,0,2,1],[5,0,5,1],[6,0,6,1],[1,0,1,1],[3,0,3,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[8,0,8,1]]}
["5. Wait times for trips for passengers using wheelchairs and Taxi Subsidy Scheme members"]
[]
["Authorised booking entities that arrange bookings for booked hire services provided using a taxi must separately report summary information about wait times for certain trips. These are trips provided to passengers using wheelchairs and members of the Taxi Subsidy Scheme (TSS).  "]
[]
["Relevant trips"]
["The information reported in this worksheet must not include information about trips provided in a wheelchair accessible taxi (WAT) for passengers who do not use a wheelchair - for example, someone who simply requests a taxi. Information about other trips provided in a WAT is to be included in the information reported in worksheet 4."]
["The information reported in this workbook must include information about trips provided to TSS members in all types of taxis, including WATs."]
["Calculating wait times"]
["The wait time is the time that a passenger waits for a booked vehicle to arrive."]
["Authorised booking entities are required to keep information about the days and times bookings are made and the days and times journeys start. This information is used to calculate the wait time information that is reported. "]
["Wait times for trips are determined by the nature of the booking:"]
["- If a booking is made for an immediate pick-up, the wait time is the time between when the booking is made and the time the trip starts"]
["- If a booking is made for the vehicle to arrive at a certain time, the wait time is the difference between the booked time and the time the trip starts."]
["- The information for each trip is used to calculate the average wait time and percentage of trips with a wait time of more than 20 minutes."]
[]
[null,"Time/ Percentage"]
["Average wait time (in minutes)"]
["Percentage of trips with a wait time of more than 20 minutes (%)"]

{"sheet":"TSA tables (to be hidden)","index":6,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
[]
["Region",null,"Central Queensland Region","Gold Coast region","Northern Queensland Region","South East Queensland Region","Southern Queensland Region"]
["South_East_Queensland",null,"Barcaldine","Beaudesert","Atherton","Boonah","Bundaberg"]
["Gold_Coast",null,"Biloela","Gold Coast","Ayr","Bribie Island","Charleville"]
["Southern_Queensland",null,"Blackall","Macleay Island","Bamaga","Brisbane","Childers"]
["Central_Queensland",null,"Blackwater","North Stradbroke Island","Cairns","Gatton","Chinchilla"]
["Northern_Queensland",null,"Bowen","Russell Island","Cardwell","Glasshouse Beerwah","Crows Nest"]
[null,null,"Clermont","Tamborine Canungra","Charters Towers","Ipswich","Cunnamulla"]
[null,null,"Collinsville",null,"Cloncurry","Kilcoy","Dalby"]
[null,null,"Dysart",null,"Cooktown","Laidley","Fraser Island"]
[null,null,"Emerald",null,"Gordonvale Yarrabah","Lowood","Gayndah"]
[null,null,"Gladstone",null,"Horn Island","Maleny","Goondiwindi"]
[null,null,"Longreach",null,"Ingham","Moreton Island","Gympie"]
[null,null,"Mackay",null,"Innisfail","Redcliffe","Hervey Bay"]
[null,null,"Moranbah",null,"Karumba","Sunshine Coast","Kingaroy"]
[null,null,"Mt Morgan",null,"Kuranda","Toogoolawah","Maryborough"]
[null,null,"Moura",null,"Magnetic Island","Woodford","Mitchell"]
[null,null,"Rockhampton",null,"Mareeba",null,"Monto"]
[null,null,"Town of 1770 / Agnes Water",null,"Mission Beach",null,"Mundubbera"]
[null,null,"Winton",null,"Mossman",null,"Murgon"]
[null,null,"Yeppoon",null,"Mt Isa",null,"Nanango"]
[null,null,null,null,"Normanton",null,"Oakey"]
[null,null,null,null,"Port Douglas",null,"Pittsworth"]
[null,null,null,null,"Ravenshoe",null,"Rainbow Beach"]
[null,null,null,null,"Thursday Island",null,"Roma"]
[null,null,null,null,"Townsville Thuringowa",null,"St George"]
[null,null,null,null,"Tully",null,"Stanthorpe"]
[null,null,null,null,"Weipa",null,"Tara"]
[null,null,null,null,null,null,"Tin Can Bay"]
[null,null,null,null,null,null,"Toowoomba"]
[null,null,null,null,null,null,"Warwick"]
[null,null,null,null,null,null,"Wondai"]