excel upload spreadsheet template by lanyuehua

VIEWS: 9 PAGES: 13

									Instructions on the Upload Tool Excel Sheet
This Excel spreadsheet contains the format by which data for Premises are to be uploaded to the Register
You can upload multiple premises using this sheet.

Define your premises in the DATA tab of this spreadsheet.

There are some fields that require specific options from the drop down lists.
The values that can be accepted for each Premises is to the right ------->
These are:




You can have up to 12 Local Authorities allocated to a Premises (if you need more please advise us)
(A mobile premise can operate over one or more Local Authorities)



Once your data is in place, save your file
ready for uploading onto the online registration form
The system will allow the upload of an excel spreadsheet only, either .xls or .xlsx format.

One you have uploaded onto the Online Registration form,
you can check the contents of your upload in the View Premises tab of the Form
You can re-upload. It wil replace any previously uploaded Premises.

Example Data:
We have provided 3 example Premises. You will need to remove these
                                                                                                           L
                                                                                                           A
                                                                                                           A
                                                                                                           A
                                                                                                           A
                                                                                                           C
                                                                                                           D
                                                                                                           D
                                                                                                           E
                                                                                                           E
                                                                                                           E
                                                                                                           E
                                                                                                           E
                                                                                                           F
                                                                                                           F
G
H
Instructions on the Upload Tool Excel Sheet
This Excel spreadsheet contains the format by which data for Premises are to be uploaded to the Register
You can upload multiple premises using this sheet.

Define your premises in the DATA tab of this spreadsheet.

There are some fields that require specific options from the drop down lists.
The values that can be accepted for each Premises is to the right ------->



            Type of Premises
            Floor Areas
            Business Type at Premises
            Local Authorities

You can have up to 12 Local Authorities allocated to a Premises (if you need more please advise us)
(A mobile premise can operate over one or more Local Authorities)



Once your data is in place, save your file
ready for uploading onto the online registration form
The system will allow the upload of an excel spreadsheet only, either .xls or .xlsx format.

One you have uploaded onto the Online Registration form,
you can check the contents of your upload in the View Premises tab of the Form
You can re-upload. It wil replace any previously uploaded Premises.

Example Data:
We have provided 3 example Premises. You will need to remove these
                                                                                                           Local Authorities
                                                                                                           Aberdeen City
                                                                                                           Aberdeenshire
                                                                                                           Angus
                                                                                                           Argyll and Bute
                                                                                                           Clackmannanshire
                                                                                                           Dumfries and Gall
                                                                                                           Dundee City
                                                                                                           East Ayrshire
                                                                                                           East Dunbartonsh
                                                                                                           East Lothian
                                                                                                           East Renfrewshire
                                                                                                           Edinburgh City
                                                                                                           Falkirk
                                                                                                           Fife
Glasgow City
Highland
Type of Premises
Fixed
Mobile Vehicle
Mobile Moveable Structure
Vending Machine

Floor Areas
Over 280 squared metres
Under 280 squared metres

Business Type at Premises
Bulk suppliers (Airport Shops/wholesalers etc)
Convenience Store
CTN (Confectionery/Tobacconist/Newsagents)
Entertainment venue
Forecourt Garage
Hotel
Mobile trader
Nightclub

Off-licence

Other catering
Other retail
Private Club
Public House
Restaurant
Specialist tobacconists
Sports Club
Supermarket and other retail outlets (over 280 square metres)

Local Authorities
Aberdeen City                                                   Inverclyde
Aberdeenshire                                                   Midlothian
Angus                                                           Moray
Argyll and Bute                                                 North Ayrshire
Clackmannanshire                                                North Lanarkshire
Dumfries and Galloway                                           Orkney Islands
Dundee City                                                     Perth and Kinross
East Ayrshire                                                   Renfrewshire
East Dunbartonshire                                             Scottish Borders
East Lothian                                                    Shetland Islands
East Renfrewshire                                               South Ayrshire
Edinburgh City                                                  South Lanarkshire
Falkirk                                                         Stirling
Fife                                                            West Dunbartonshire
Glasgow City   West Lothian
Highland       Comhairle nan Eilean Siar
Premises Name*                       Type Of Premises* (choices)
Example Premises 1 (please remove)   Fixed
Example Premises 2 (please remove)   Mobile Moveable Structure
Example Premises 3 (please remove)   Mobile Vehicle
                                     Vending Machine
Mobile Vehicle Registration   Trailer Registration Number   Moveable Description

                              SG 354X                       Descrption here
SG 345G
Address 1*   Address 2   Town*   Postcode*
premises 1   address 1   town    G2 4SQ
premises 2   address 1   town    G2 4SQ
premises 3   address 1   town    G2 4SQ
Business Type* (choices)   Floor Area* (choices)
Nightclub                  Over 280 squared metres
Sports Club                Under 280 squared metres
Entertainment venue        Over 280 squared metres
Local Authority 1* (choices)   Local Authority 2   Local Authority 3   Local Authority 4
Dumfries and Galloway          Renfrewshire
Angus
East Lothian                                      Dundee City
                               Dumfries and Galloway
Local Authority 5   Local Authority 6   Local Authority 7   Local Authority 8   Local Authority 9
Local Authority 10   Local Authority 11   Local Authority 12

								
To top