{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Coversheet and instructions","1. Booked hire trips","2. Rank and hail trips","TSA (to be hidden)"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":13,"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":28,"n_cols":5,"rows_kept":28,"cut":false,"hidden":false,"merged":[[13,0,13,4],[14,0,14,4],[27,0,27,4],[17,0,17,4],[18,0,18,4],[23,0,23,4],[24,0,24,4],[22,0,22,4],[25,0,25,4],[26,0,26,4],[19,0,19,4],[15,0,15,4],[16,0,16,4],[20,0,20,4],[21,0,21,4],[11,0,11,4],[12,0,12,4],[0,1,0,4],[2,0,2,4],[3,0,3,4],[1,0,1,4],[10,0,10,4],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,1]]}
[null,"Authorised booking entities and taxi service operators annual report"]
["Form F5232 CFD   V01 September 2018"]
["Authorised booking entities and taxi service operators are required to use this form to report information for each financial year to the Department of Transport and Main Roads (the department) under the Transport Operations (Passenger Transport) Regulation 2018.  "]
["Authorised booking entities and taxi service operators are required to provide their completed form electronically to the department by 28 July each year."]
[null,null,{"$f":"MID(CELL(\"filename\"),SEARCH(\"[\",CELL(\"filename\"))+1, SEARCH(\"]\",CELL(\"filename\"))-SEARCH(\"[\",CELL(\"filename\"))-1)","v":"Annual reporting form web v80.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/ Taxi Service Operator name:"]
["Trading Name:"]
["Booking Entity Authority Number:"]
["Annual Period:                                                                                            From:",null,"2019-07-01","                     To:","2020-06-30"]
[null,null,"(dd/mm/yyyy)",null,"(dd/mm/yyyy)"]
[]
["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.  "]
["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 completed 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.  "]
["Taxi service operator"]
["A taxi service operator is a person carrying on the business of providing rank and hail services. In some cases, an authorised booking entity that arranges booked hire trips for taxis will also be a taxi service operator and will be able to provide the required information about rank and hail services. "]
["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/Operator specific information will not be disclosed to any other third party without your consent unless authorised or required to do so by law."]

{"sheet":"1. Booked hire trips","index":1,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[[11,0,11,1],[10,0,10,1],[0,0,0,1],[5,0,5,1],[2,0,2,1],[8,0,8,1],[9,0,9,1],[1,0,1,1],[3,0,3,1],[7,0,7,1]]}
["1. Booked hire trips"]
[]
["Authorised booking entities are required to report information about the number of booked hire trips they arrange bookings for in each financial year broken down by the postcode of the location where the trip started."]
[]
["Booked hire trips"]
["Information is required about all booked hire trips provided using a taxi, limousine or booked hire vehicle."]
["Postcodes "]
["Postcodes only need to be included in the report once, regardless of the number of trips that start in the postcode. For example, the 4001 postcode is to be reported once whether 1 or 1,000 trips start in the postcode during the reporting period."]
["Please use separate rows for each postcode and the number of trips."]
["Postcodes for suburbs, towns and cities can be searched for at: "]
["http://auspost.com.au/postcode"]
[]
["Postcode in which trips started","Number of booked hire trips"]

{"sheet":"2. Rank and hail trips","index":2,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,2],[2,0,2,2],[4,0,4,2],[5,0,5,2],[8,0,8,2],[6,0,6,2],[9,0,9,2],[10,0,10,2],[1,0,1,2],[3,0,3,2],[11,0,11,2],[7,0,7,2]]}
["2. Rank and Hail trips"]
[]
["Taxi service operators are required to report information about the number of rank and hail trips provided in a taxi for each financial year, broken down by the taxi service area in which the trip started."]
[]
["Taxi Service areas"]
["Regions and taxi service areas can be chosen from the drop down menus in the table below."]
["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."]
["Where necessary, additional rows can be inserted into the table by selecting a row/s from the table and right-clicking the selected cells and then clicking 'Insert'. "]
["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 "]
[]
["Region","Taxi Service Area","Number of rank and hail trips"]

{"sheet":"TSA (to be hidden)","index":3,"n_rows":32,"n_cols":10,"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,{"$f":"30*5","v":150}]
[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"]