Spreadsheet: 170662d1343342941-help-with-exporting-and-collating-data-newby-question-test-data-sample-copy2
Sheet: Sheet2 - Table 1

Bldg | Barcode | Owner | AssetCategory | RoomNo | RoomName | Item | Qty. | Maint. Cycle | Maint Code | Maint Actions | RoomName | RoomBcode | PlantRef | Make | Model | School | AssetGroup | AssetType | ItemType | Building | RoomNo | BatchNo | [NAME]
LRC | 108139 | UGL | Furniture | 901 | Room 1 | Chair Adult Swivel | 1 | Six Monthly | UGL005 | Test all functions | Room 1 | RM0901 |  |  |  | Point Cook College | FF&E | Chair | CHAIR07 | Learning Centre | 901 | Rm901C | 1
LRC | 137118 | UGL | Furniture | 901 | Room 1 | Chair Moulded Very Small (Black dot) | 24 | Annual | UGL002 | Inspect for condition | Room 1 | RM0901 |  |  |  | Point Cook College | FF&E | Chair | CHAIR01 | Learning Centre | 901 | Rm901C | 1
LRC | 104699 | UGL | Furniture | 901 | Room 1 | [NAME] | 1 | Six Monthly | UGL002 | Inspect for condition | Room 1 | RM0901 |  |  |  | Point Cook College | FF&E | Chair | CHAIR09 | Learning Centre | 901 | Rm901C | 1
LRC | 137117 | UGL | Equipment | 901 | Room 1 | Clock | 1 | Annual | UGL004 | [NAME] | Room 1 | RM0901 |  |  |  | Point Cook College | FF&E | General | SUND03 | Learning Centre | 901 | Rm901C | 1
LRC |  | UGL | Plant | 901 | Room 1 | Fan Ceiling Sweep | 2 | Annual | UGL003 | Operate at all speeds, check noise and vibration | Room 1 | RM0901 | CSF15 | Airflow | ACES48 | Point Cook College | FF&E | HVAC | SUND01 | Learning Centre | 901 | RM918C | 1
LRC | 137934 | UGL | Furniture | 901 | Room 1 | Filing Cabinet 4 Drawer | 1 | Annual | UGL008 | Test lock function | Room 1 | RM0901 |  |  |  | Point Cook College | FF&E | Cupboard | CUPBD04 | Learning Centre | 901 | Rm901C | 1
LRC | 137915 | UGL | Equipment | 901 | Room 1 | Gas Bench-top Stove | 2 | Six Monthly | UGL007 | Test light all jets | Room 1 | RM0901 |  |  |  | Point Cook College | FF&E | Kitchen | APPL20 | Learning Centre | 901 | Rm901C | 1
LRC | 136360 | UGL | Plant | 901 | Room 1 | Heater Gas Convection | 1 | Six Monthly | UGL009 | Undertake manufacturers recommended routine | Room 1 | RM0901 | GH3 | Rinnai | 1004FDT | Point Cook College | FF&E | HVAC | SUND9 | Learning Centre | 901 | Rm901C | 1
LRC | 137096 | UGL | Furniture | 901 | Room 1 | [NAME] | 1 | Annual | UGL002 | Inspect for condition | Room 1 | RM0901 |  |  |  | Point Cook College | FF&E | Rack | RACK04 | Learning Centre | 901 | Rm901C | 1
LRC | 137933 | UGL | Furniture | 901 | Room 1 | Open Lockers | 4 | Annual | UGL002 | Inspect for condition | Room 1 | RM0901 |  |  |  | Point Cook College | FF&E | Rack | [NAME] | Learning Centre | 901 | Rm901C | 1
LRC | 137104 | UGL | Furniture | 901 | Room 1 | Reading Writing Centre | 1 | Annual | UGL002 | Inspect for condition | Room 1 | RM0901 |  |  |  | Point Cook College | FF&E | Rack | RACK01 | Learning Centre | 901 | Rm901C | 1
LRC | 137932 | UGL | Furniture | 901 | Room 1 | Stepped Shelving | 1 | Annual | UGL006 | Test castor function | Room 1 | RM0901 |  |  |  | Point Cook College | FF&E | Rack | RACK09 | Learning Centre | 901 | Rm901C | 1
LRC | 104513 | UGL | Furniture | 901 | Room 1 | Table Byte | 12 | Annual | UGL002 | Inspect for condition | Room 1 | RM0901 |  |  |  | Point Cook College | FF&E | Table | TABLE02 | Learning Centre | 901 | Rm901C | 1
LRC | 137103 | UGL | Furniture | 901 | Room 1 | Table Student Adjustable | 1 | Annual | UGL002 | Inspect for condition | Room 1 | RM0901 |  |  |  | Point Cook College | FF&E | Table | TABLE03 | Learning Centre | 901 | Rm901C | 1
LRC | 137116 | UGL | Furniture | 901 | Room 1 | Two door short lockable Cupboard | 1 | Annual | UGL008 | Test lock function | Room 1 | RM0901 |  |  |  | Point Cook College | FF&E | Cupboard | CUPBD09 | Learning Centre | 901 | Rm901C | 1
LRC | 137102 | UGL | Equipment | 901 | Room 1 | Waste Paper Bin | 1 | Annual | UGL002 | Inspect for condition | Room 1 | RM0901 |  |  |  | Point Cook College | FF&E | Bin | BIN04 | Learning Centre | 901 | Rm901C | 1
LRC | 137530 | UGL | Equipment | 901 | Room 1 | [NAME] | 1 | Annual | UGL001 | Confirm surface condition | Room 1 | RM0901 |  |  |  | Point Cook College | FF&E | Whiteboard | WHTBD01 | Learning Centre | 901 | Rm901C | 1
Bldg | Barcode | Owner | AssetCategory | RoomNo | RoomName | Item | Qty. | Maint. Cycle | Maint Code | Maint Actions | RoomName | RoomBcode | PlantRef | Make | Model | School | AssetGroup | AssetType | ItemType | Building | RoomNo | BatchNo | [NAME]
LRC | 137849 | UGL | Furniture | 902 | Room 2 | Chair Adult Swivel | 1 | Six Monthly | UGL005 | Test all functions | Room 2 | RM0902 |  |  |  | Point Cook College | FF&E | Chair | CHAIR07 | Learning Centre | 902 | Rm902c | 1
LRC | 108213 | UGL | Furniture | 902 | Room 2 | Chair Moulded Small      (Red dot) | 19 | Annual | UGL002 | Inspect for condition | Room 2 | RM0902 |  |  |  | Point Cook College | FF&E | Chair | CHAIR02 | Learning Centre | 902 | Rm902c | 1
LRC | 104697 | UGL | Furniture | 902 | Room 2 | [NAME] | 1 | Six Monthly | UGL002 | Inspect for condition | Room 2 | RM0902 |  |  |  | Point Cook College | FF&E | Chair | CHAIR09 | Learning Centre | 902 | Rm902c | 1
LRC | 137100 | UGL | Equipment | 902 | Room 2 | Clock | 1 | Annual | UGL004 | [NAME] | Room 2 | RM0902 |  |  |  | Point Cook College | FF&E | General | SUND03 | Learning Centre | 902 | Rm902c | 1
LRC | 137544 | UGL | Furniture | 902 | Room 2 | Filing Cabinet 4 Drawer | 1 | Annual | UGL008 | Test lock function | Room 2 | RM0902 |  |  |  | Point Cook College | FF&E | Cupboard | CUPBD04 | Learning Centre | 902 | Rm902c | 1
LRC | 137097 | UGL | Furniture | 902 | Room 2 | [NAME] | 1 | Annual | UGL002 | Inspect for condition | Room 2 | RM0902 |  |  |  | Point Cook College | FF&E | Rack | RACK04 | Learning Centre | 902 | Rm902c | 1
LRC | 137529 | UGL | Furniture | 902 | Room 2 | Open Lockers | 4 | Annual | UGL002 | Inspect for condition | Room 2 | RM0902 |  |  |  | Point Cook College | FF&E | Rack | [NAME] | Learning Centre | 902 | Rm902c | 1
LRC | 137111 | UGL | Equipment | 902 | Room 2 | Pinboard    (All colours) | 2 | Annual | UGL001 | Confirm surface condition | Room 2 | RM0902 |  |  |  | Point Cook College | FF&E | Display | PINBD01 | Learning Centre | 902 | Rm902c | 1
LRC | 137101 | UGL | Equipment | 902 | Room 2 | Reading Writing Centre | 1 | Annual | UGL002 | Inspect for condition | Room 2 | RM0902 |  |  |  | Point Cook College | FF&E | Rack | RACK02 | Learning Centre | 902 | Rm902c | 1
LRC | 108870 | UGL | Furniture | 902 | Room 2 | [NAME] | 1 | Annual | UGL002 | Inspect for deterioration | Room 2 | RM0902 |  |  |  | Point Cook College | FF&E | Seat | SEAT03 | Learning Centre | 902 | Rm902c | 1
LRC | 137114 | UGL | Furniture | 902 | Room 2 | Stepped Shelving | 1 | Annual | UGL006 | Test castor function | Room 2 | RM0902 |  |  |  | Point Cook College | FF&E | Rack | RACK09 | Learning Centre | 902 | Rm902c | 1
LRC | 108376 | UGL | Furniture | 902 | Room 2 | Table Byte | 14 | Annual | UGL002 | Inspect for condition | Room 2 | RM0902 |  |  |  | Point Cook College | FF&E | Table | TABLE02 | Learning Centre | 902 | Rm902c | 1
LRC | 136359 | UGL | Equipment | 902 | Room 2 | Waste Paper Bin | 1 | Annual | UGL002 | Inspect for condition | Room 2 | RM0902 |  |  |  | Point Cook College | FF&E | Bin | BIN04 | Learning Centre | 902 | Rm902c | 1
LRC | 137545 | UGL | Equipment | 902 | Room 2 | [NAME] | 1 | Annual | UGL001 | Confirm surface condition | Room 2 | RM0902 |  |  |  | Point Cook College | FF&E | Whiteboard | WHTBD01 | Learning Centre | 902 | Rm902c | 1