Spreadsheet: 40060d1238381358-excel-2007-formatting-rows-sampleworkbook
Sheet: Formatted Sample

Lic No | Trading Name | Area | Officer | Inspection Date | Inspection Result | Tob - Liquor | Tob - Premise | Tob -  Dining | Tob - Vend
2P-3 | ST THERESA CONVENIENCE STORE | RACECOURSE | NADINEM | 2008-01-09 00:00:00 | No Sale | No | Yes | No | No
2P-3 | ST THERESA CONVENIENCE STORE | RACECOURSE | NADINEM | 2007-02-12 00:00:00 | Satisfactory | No | Yes | No | No
2P-6 | ASCOT LOTTO & NEWS | SOUTH | GREGT | 2001-02-21 00:00:00 | No Sale | No | Yes | No | No
2P-6 | ASCOT LOTTO & NEWS | SOUTH | GREGT | 2008-04-02 00:00:00 | No Sale | No | Yes | No | No
2-7 | OZ MILK BAR | SOUTH | GREGT | 2008-10-02 00:00:00 | No Sale | No | Yes | No | No
2-7 | OZ MILK BAR | SOUTH | GREGT | 2001-02-21 00:00:00 | No Sale | No | Yes | No | No
2P-44 | RICHARD'S MILK BAR | QUARRY | NIKIS | 2008-01-18 00:00:00 | No Sale | No | Yes | No | No
2P-44 | RICHARD'S MILK BAR | QUARRY | NIKIS | 2001-02-15 00:00:00 |  | No | Yes | No | No
2P-46 | MAYLEE MILK BAR | QUARRY | NIKIS | 2008-10-03 00:00:00 | No Sale | No | Yes | No | No
2P-46 | MAYLEE MILK BAR | QUARRY | NIKIS | 2008-12-03 00:00:00 | No Sale | No | Yes | No | No
2-49 | 7 ELEVEN P/L | SOUTH | GREGT | 2008-10-02 00:00:00 | No Sale | No | Yes | No | No
2-49 | 7 ELEVEN P/L | SOUTH | GREGT | 2008-04-02 00:00:00 | Sale | No | Yes | No | No
2-49 | 7 ELEVEN P/L | SOUTH | GREGT | 2001-07-03 00:00:00 | No Sale | No | Yes | No | No
2-49 | 7 ELEVEN P/L | SOUTH | GREGT | 2008-01-09 00:00:00 | Sale | No | Yes | No | No
2-51 | [NAME] | SOUTH | GREGT | 2006-06-22 00:00:00 | Sale | No | Yes | Yes | No
2-51 | [NAME] | SOUTH | GREGT | 2001-07-03 00:00:00 | No Sale | No | Yes | Yes | No
2-55 | CALTEX ASCOT VALE | SOUTH | GREGT | 2001-07-03 00:00:00 | No Sale | No | Yes | No | No
2P-64 | ESSENDON ROUNDABOUT NEWSAGENCY | RACECOURSE | NADINEM | 2008-04-02 00:00:00 | No Sale | No | Yes | No | No
2P-64 | ESSENDON ROUNDABOUT NEWSAGENCY | RACECOURSE | NADINEM | 2001-12-17 00:00:00 | No Sale | No | Yes | No | No
2-72 | HAMPTON ROAD MILK BAR | QUARRY | NIKIS | 2001-09-11 00:00:00 | No Sale | No | Yes | No | No
2-72 | HAMPTON ROAD MILK BAR | QUARRY | NIKIS | 2006-06-22 00:00:00 | No Sale | No | Yes | No | No
2-72 | HAMPTON ROAD MILK BAR | QUARRY | NIKIS | 2003-10-09 00:00:00 |  | No | Yes | No | No
2-72 | HAMPTON ROAD MILK BAR | QUARRY | NIKIS | 2008-10-02 00:00:00 | No Sale | No | Yes | No | No
2-72 | HAMPTON ROAD MILK BAR | QUARRY | NIKIS | 2006-10-05 00:00:00 | Satisfactory | No | Yes | No | No
2P-78 | HOFFMANS ROAD MILK BAR | QUARRY | NIKIS | 2006-06-22 00:00:00 | Sale | No | Yes | No | No
2P-78 | HOFFMANS ROAD MILK BAR | QUARRY | NIKIS | 2001-05-09 00:00:00 | No Sale | No | Yes | No | No
2P-78 | HOFFMANS ROAD MILK BAR | QUARRY | NIKIS | 2006-12-19 00:00:00 | Satisfactory | No | Yes | No | No
X-81 | HOFFMANS CELLARS | QUARRY |  | 2001-05-09 00:00:00 | No Sale | Yes | Yes | No | No
2P-90 | COLES EXPRESS ESSENDON | QUARRY | NIKIS | 2001-02-22 00:00:00 | No Sale | No | Yes | No | No
2P-90 | COLES EXPRESS ESSENDON | QUARRY | NIKIS | 2008-10-03 00:00:00 | No Sale | No | Yes | No | No
Z-105 | BP NIDDRIE |  |  | 2001-12-14 00:00:00 | No Sale | No | Yes | No | No
Z-105 | BP NIDDRIE |  |  | 2003-10-09 00:00:00 |  | No | Yes | No | No
2-106 | 7 ELEVEN P/L | QUARRY | NIKIS | 2006-06-22 00:00:00 | Sale | No | Yes | No | No
2-106 | 7 ELEVEN P/L | QUARRY | NIKIS | 2001-05-02 00:00:00 | No Sale | No | Yes | No | No
2-121 | NOT QUITE RIGHT | QUARRY | NIKIS |  |  | Yes | Yes | No | No
2-125 | ASCOT MARKET | SOUTH | GREGT | 2008-04-02 00:00:00 | No Sale | No | Yes | No | No
2P-136 | M-1 ZERVOS | QUARRY | NIKIS | 2008-01-18 00:00:00 | No Sale | No | Yes | Yes | No
2P-136 | M-1 ZERVOS | QUARRY | NIKIS | 2001-07-03 00:00:00 | No Sale | No | Yes | Yes | No
2P-136 | M-1 ZERVOS | QUARRY | NIKIS | 2003-09-26 00:00:00 |  | No | Yes | Yes | No
2P-136 | M-1 ZERVOS | QUARRY | NIKIS | 2001-09-14 00:00:00 | No Sale | No | Yes | Yes | No
2-159 | MILK BAR | SOUTH | GREGT | 2003-10-09 00:00:00 |  | No | Yes | No | No
2-159 | MILK BAR | SOUTH | GREGT | 2006-06-22 00:00:00 | No Sale | No | Yes | No | No
2-159 | MILK BAR | SOUTH | GREGT | 2008-10-02 00:00:00 | No Sale | No | Yes | No | No
2-166 | MASCOMA LIC FOODSTORE | AIRPORT | SARAHC | 2008-10-02 00:00:00 | No Sale | Yes | Yes | No | No
2-166 | MASCOMA LIC FOODSTORE | AIRPORT | SARAHC | 2001-03-21 00:00:00 | No Sale | Yes | Yes | No | No
2P-176 | AVONDALE HEIGHTS NEWS & LOTTERIES | QUARRY | NIKIS | 2006-06-22 00:00:00 | Sale | No | Yes | No | No
2P-176 | AVONDALE HEIGHTS NEWS & LOTTERIES | QUARRY | NIKIS | 2007-07-11 00:00:00 | No Sale | No | Yes | No | No
2P-176 | AVONDALE HEIGHTS NEWS & LOTTERIES | QUARRY | NIKIS | 2002-01-07 00:00:00 | No Sale | No | Yes | No | No
X-179 | YOUR CANTINA WINES | QUARRY | NIKIS |  |  | Yes | Yes | No | No
2P-205 | MORONEYS SERVICE STATION | AIRPORT | SARAHC | 2001-12-17 00:00:00 | No Sale | No | Yes | No | No
2P-205 | MORONEYS SERVICE STATION | AIRPORT | SARAHC | 2003-10-09 00:00:00 |  | No | Yes | No | No
2P-205 | MORONEYS SERVICE STATION | AIRPORT | SARAHC | 2007-07-12 00:00:00 | Sale | No | Yes | No | No
2P-205 | MORONEYS SERVICE STATION | AIRPORT | SARAHC | 2008-01-18 00:00:00 | No Sale | No | Yes | No | No
2-207 | 7 ELEVEN P/L | AIRPORT | SARAHC | 2008-10-03 00:00:00 | No Sale | No | Yes | No | No
2-207 | 7 ELEVEN P/L | AIRPORT | SARAHC | 2007-07-12 00:00:00 | No Sale | No | Yes | No | No
2-225 | STRATHMORE VILLAGE MILK BAR | AIRPORT | SARAHC | 2008-10-03 00:00:00 | No Sale | No | Yes | No | No
2-225 | STRATHMORE VILLAGE MILK BAR | AIRPORT | SARAHC | 2001-03-21 00:00:00 | No Sale | No | Yes | No | No
X-230 | STRATHMORE CELLARS | AIRPORT | SARAHC | 2001-03-21 00:00:00 | No Sale | Yes | Yes | No | No
X-230 | STRATHMORE CELLARS | AIRPORT | SARAHC | 2002-12-17 00:00:00 | Sale | Yes | Yes | No | No
2P-237 | MILK BAR | QUARRY | NIKIS | 2002-01-07 00:00:00 | Sale | No | Yes | No | No
2-239 | PARER ROAD MILKBAR & TAKEAWAY | AIRPORT | SARAHC | 2001-12-14 00:00:00 | No Sale | No | Yes | No | No
2-239 | PARER ROAD MILKBAR & TAKEAWAY | AIRPORT | SARAHC | 2007-07-11 00:00:00 | No Sale | No | Yes | No | No
X-242 | NIDDRIE NEWSAGENCY | QUARRY | NIKIS |  |  | No | Yes | No | No
2P-259 | [NAME] | SOUTH | GREGT | 2007-07-12 00:00:00 | Sale | No | Yes | No | No
2P-259 | [NAME] | SOUTH | GREGT | 2002-12-17 00:00:00 | Sale | No | Yes | No | No
2P-259 | [NAME] | SOUTH | GREGT | 2008-01-18 00:00:00 | No Sale | No | Yes | No | No
X-269 | NEWMARKET AUTHORISED NEWSAGENCY | SOUTH | GREGT | 2001-06-19 00:00:00 | No Sale | No | Yes | No | No
X-269 | NEWMARKET AUTHORISED NEWSAGENCY | SOUTH | GREGT | 2007-07-11 00:00:00 | No Sale | No | Yes | No | No
2-270 | FOODWORKS NEWMARKET | SOUTH | GREGT | 2001-06-19 00:00:00 | No Sale | No | Yes | No | No
2-270 | FOODWORKS NEWMARKET | SOUTH | GREGT | 2007-01-15 00:00:00 | Satisfactory | No | Yes | No | No
2-270 | FOODWORKS NEWMARKET | SOUTH | GREGT | 2007-07-11 00:00:00 | No Sale | No | Yes | No | No
2-280 | FLAT SHOP | SOUTH | GREGT | 2008-10-02 00:00:00 | No Sale | No | Yes | No | No
2-280 | FLAT SHOP | SOUTH | GREGT | 2002-12-17 00:00:00 | Sale | No | Yes | No | No
2-290 | UNIJOY P/L | SOUTH | GREGT | 2008-01-18 00:00:00 | No Sale | Yes | Yes | No | No
2-300 | RIVIERA MILK BAR | QUARRY | NIKIS | 2008-10-02 00:00:00 | No Sale | No | Yes | No | No
2-300 | RIVIERA MILK BAR | QUARRY | NIKIS | 2002-01-07 00:00:00 | No Sale | No | Yes | No | No
2P-302 | THE CORNER DELI | AIRPORT | SARAHC | 2003-09-26 00:00:00 |  | No | Yes | Yes | No
2P-302 | THE CORNER DELI | AIRPORT | SARAHC | 2002-11-04 00:00:00 | Sale | No | Yes | Yes | No
2P-302 | THE CORNER DELI | AIRPORT | SARAHC | 2008-10-03 00:00:00 | No Sale | No | Yes | Yes | No
2P-302 | THE CORNER DELI | AIRPORT | SARAHC | 2001-08-29 00:00:00 | No Sale | No | Yes | Yes | No
2-303 | FRIENDLY GROCER IGA | AIRPORT | SARAHC | 2006-11-29 00:00:00 | Satisfactory | No | Yes | No | No
2-303 | FRIENDLY GROCER IGA | AIRPORT | SARAHC | 2007-07-12 00:00:00 | No Sale | No | Yes | No | No
2-303 | FRIENDLY GROCER IGA | AIRPORT | SARAHC | 2006-11-29 00:00:00 | No Result | No | Yes | No | No
[NAME] | ESSENDON NEWSAGENCY | AIRPORT | SARAHC | 2008-01-09 00:00:00 | No Sale | No | Yes | No | No
2-319 | CENTREWAY CELLARS | QUARRY | NIKIS | 2008-01-18 00:00:00 | No Sale | Yes | Yes | No | No
2-319 | CENTREWAY CELLARS | QUARRY | NIKIS | 2007-02-02 00:00:00 | Satisfactory | Yes | Yes | No | No
2-319 | CENTREWAY CELLARS | QUARRY | NIKIS | 2001-05-09 00:00:00 | No Sale | Yes | Yes | No | No
2P-329 | TILBA MILK BAR | QUARRY | NIKIS | 2003-10-09 00:00:00 |  | No | Yes | No | No
2-339 | FOODWORKS ASCOT VALE | SOUTH | GREGT | 2008-01-18 00:00:00 | No Sale | Yes | Yes | No | No
X-343 | ASCOT VALE NEWSAGENCY | SOUTH | GREGT |  |  | No | Yes | No | No
2-351 | WEBB ROAD TAKE AWAY | AIRPORT | SARAHC |  |  | No | Yes | Yes | No
2P-358 | KEILOR EAST MILK BAR & POST OFFICE | QUARRY | NIKIS | 2001-02-22 00:00:00 | No Sale | No | Yes | No | No
2P-358 | KEILOR EAST MILK BAR & POST OFFICE | QUARRY | NIKIS | 2001-09-11 00:00:00 | Sale | No | Yes | No | No
2P-358 | KEILOR EAST MILK BAR & POST OFFICE | QUARRY | NIKIS | 2008-10-03 00:00:00 | No Sale | No | Yes | No | No
2P-358 | KEILOR EAST MILK BAR & POST OFFICE | QUARRY | NIKIS | 2003-09-26 00:00:00 |  | No | Yes | No | No
2-361 | WOODLAND STREET CELLARS | AIRPORT | SARAHC | 2008-01-09 00:00:00 | No Sale | Yes | Yes | No | No
2-361 | WOODLAND STREET CELLARS | AIRPORT | SARAHC | 2006-12-05 00:00:00 | Unsatisfactory | Yes | Yes | No | No
X-363 | STRATHMORE NEWSAGENCY | AIRPORT | SARAHC | 2008-10-03 00:00:00 | No Sale | No | Yes | No | No
X-363 | STRATHMORE NEWSAGENCY | AIRPORT | SARAHC | 2001-05-02 00:00:00 | No Sale | No | Yes | No | No
X-363 | STRATHMORE NEWSAGENCY | AIRPORT | SARAHC | 2007-07-11 00:00:00 | No Sale | No | Yes | No | No