{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Bore Register","Dropdowns","Validation"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":21,"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":"Instructions","index":0,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,4,19,5],[5,13,12,13],[10,7,11,7],[9,9,12,9],[17,4,17,5],[18,4,18,5]]}
[]
[null,"BR Instructions/Guidelines"]
[null,"Version 0.1.1"]
[null,"Revision P, released 24 July 2023"]
[]
[]
[null,null,null,null,null,null,null,"DATA CHECKS",null,"GIS REQUIREMENTS (SPECIFIC)"]
[null,null,"Bore Register"]
[]
[null,null,null,"Enter monitoring bores, noting each row should contain a unique Bore ID",null,null,null,null,null,"Coordinates must be listed within this register, GIS layers are not required. "]
[null,null,null,null,null,null,null,{"$f":"bore_validate","v":"No Bore Records"}]
[null,null,null,"Check the table header for text character limits. "]
[null,null,null,"Mandatory fields are highlighted with a * and red text."]
[]
[]
[]
[null,null,null,"VICTRACK USE ONLY"]
[null,null,null,null,"Completed By (e.g., A. Smith)",null,"Completed Date (YYY-MM-DD)"]
[null,null,null,"DRAT Reviewed:"]
[null,null,null,"DRAT Endorsement:"]

{"sheet":"Bore Register","index":1,"n_rows":16,"n_cols":18,"rows_kept":16,"cut":false,"hidden":false,"merged":[[3,2,3,9],[3,10,3,11],[3,0,3,1],[3,12,3,17]]}
["source_supersede",null,null,"bore_type",null,"bore_status",null,"headworks",null,null,"railmap",null,null,null,"bore_crs"]
["record_type","bore_id","bore_name","bore_type","bore_owner","bore_status","license_id","headworks","screen_int","installed_year","site_desc","lot_desc","easting","northing","coordinate_system","TOC","ground_level","top_of_gatic"]
[{"$f":"VLOOKUP(A$2, validate_Bores[], 7, FALSE)","v":"Dropdown*"},{"$f":"VLOOKUP(B$2, validate_Bores[], 7, FALSE)","v":"Whole Number"},{"$f":"VLOOKUP(C$2, validate_Bores[], 7, FALSE)","v":"Free text (50 characters)*"},{"$f":"VLOOKUP(D$2, validate_Bores[], 7, FALSE)","v":"Dropdown*"},{"$f":"VLOOKUP(E$2, validate_Bores[], 7, FALSE)","v":"Free text (100 characters)*"},{"$f":"VLOOKUP(F$2, validate_Bores[], 7, FALSE)","v":"Dropdown*"},{"$f":"VLOOKUP(G$2, validate_Bores[], 7, FALSE)","v":"Free text (20 characters)"},{"$f":"VLOOKUP(H$2, validate_Bores[], 7, FALSE)","v":"Dropdown"},{"$f":"VLOOKUP(I$2, validate_Bores[], 7, FALSE)","v":"Free text (20 characters)"},{"$f":"VLOOKUP(J$2, validate_Bores[], 7, FALSE)","v":"Free text (20 characters)"},{"$f":"VLOOKUP(K$2, validate_Bores[], 7, FALSE)","v":"Dropdown*"},{"$f":"VLOOKUP(L$2, validate_Bores[], 7, FALSE)","v":"Free text (50 characters)"},{"$f":"VLOOKUP(M$2, validate_Bores[], 7, FALSE)","v":"Decimal Number*"},{"$f":"VLOOKUP(N$2, validate_Bores[], 7, FALSE)","v":"Decimal Number*"},{"$f":"VLOOKUP(O$2, validate_Bores[], 7, FALSE)","v":"Dropdown*"},{"$f":"VLOOKUP(P$2, validate_Bores[], 7, FALSE)","v":"Decimal Number*"},{"$f":"VLOOKUP(Q$2, validate_Bores[], 7, FALSE)","v":"Decimal Number"},{"$f":"VLOOKUP(R$2, validate_Bores[], 7, FALSE)","v":"Decimal Number"}]
["Supersede previous bore",null,"Bore Information",null,null,null,null,null,null,null,"VicTrack Location",null,"Survey Data"]
["Does this Bore record replace an existing Bore ID?","CHAMP BORE ID\n(if the record replaces an existing bore)","Unique Bore ID","Bore Type","Bore Owner","Bore Status","BCL ID","Headworks","Screen Interval (m bgL)","Installed Year","RailMap Site Location","RailMap Lot ID/RIL","Eastings ","Northings","Coordinate System","TOC","Ground Level","Top of gatic"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["*Note only one Bore Register per RailMap site location. VicTrack to provide if a register already exists for context, however, new register to be prefilled each deliverable."]

{"sheet":"Dropdowns","index":2,"n_rows":1026,"n_cols":6,"rows_kept":1026,"cut":false,"hidden":true,"merged":[]}
["railmap","bore_type","bore_crs","headworks","bore_status","source_supersede"]
["RailMap Location","Bore Type  Dropdown","Coordinate System","Bore Headworks (Surface Construction)","Bore Status","Register Supersedence"]
["ADELAIDE LEAD","VicTrack groundwater","AGD66 (lat long)","Standpipe","Active","Yes"]
["AIRCRAFT","Third-party groundwater","AGD84 (lat long)","Flush","Decomissioned","No - first entry"]
["AIRPORT WEST","VicTrack vapour/gas","GDA2020 (lat long)",null,"Lost/Destroyed","No - same as previous"]
["AIRPORT WEST SUBSTN","Third-party vapour/gas","GDA94 (lat long)"]
["ALAMEIN",null,"WGS (lat long)"]
["ALBACUTYA",null,"AMG66 z54"]
["ALBERT PARK",null,"AMG66 z55"]
["ALBION",null,"AMG84 z54"]
["ALEXANDRA",null,"AMG84 z55"]
["ALLANSFORD",null,"MGA2020 z54"]
["ALPHINGTON",null,"MGA2020 z55"]
["ALTONA",null,"MGA94 z54"]
["AMPHITHEATRE",null,"MGA94 z55"]
["ANNUELLO",null,"WGS84 z54"]
["ANSTEY",null,"WGS84 z55"]
["ANTWERP",null,"VicGrid"]
["APPLETON DOCK"]
["ARAPILES"]
["ARARAT"]
["ARCADIA"]
["ARDEER"]
["ARDEN STREET"]
["ARDEN STREET B SIDING"]
["ARDEN STREET C SIDING"]
["ARDEN STREET D SIDING"]
["ARKONA"]
["ARMADALE"]
["ARMSTRONG"]
["ARMYTAGE"]
["ARNOLD"]
["ASCOT VALE"]
["ASCOT VALE SUBSTN"]
["ASHBURTON"]
["ASHENS"]
["ASPENDALE"]
["AUBURN"]
["AVENEL"]
["AVOCA"]
["AVONMORE"]
["BACCHUS MARSH"]
["BADDAGINNIE"]
["BAGSHOT"]
["BAIRNSDALE"]
["BALACLAVA"]
["BALD HILLS"]
["BALLAN"]
["BALLARAT"]
["BALLARAT CATTLE YARDS RACE"]
["BALLARAT EAST"]
["BALMATTUM"]
["BALMORAL"]
["BALRANALD"]
["BAMBILL"]
["BANANA ALLEY"]
["BANDIANA"]
["BANNERTON"]
["BANNOCKBURN"]
["BANYENA"]
["BARNAWARTHA"]
["BARNES"]
["BARRAKEE"]
["BARRAPORT"]
["BARWO"]
["BARWON"]
["BATCHICA"]
["BATMAN"]
["BAXTER"]
["BAYSWATER"]
["BEACONSFIELD"]
["BEALIBA"]
["BEAUFORT"]
["BELGRAVE"]
["BELL"]
["BEN NEVIS"]
["BENA"]
["BENALLA"]
["BENARCA"]
["BENDIGO"]
["BENETOOK"]
["BENTLEIGH"]
["BERAMBONG"]
["BERRIWILLOCK"]
["BERRYBANK"]
["BERWICK"]
["BET BET"]
["BEULAH"]
["BEVERIDGE"]
["BINBINETTE"]
["BIRCHIP"]
["BIRREGURRA"]
["BITTERN"]
["BLACKBURN"]
["BOIGBEAT"]
["BOINKA"]
["BOLANGUM"]
["BOLTON"]
["BONBEACH"]
["BOONOONAR SIDING"]
["BOORCAN"]
["BOORHAMAN"]
["BOORT"]
["BORONIA"]
["BORUNG"]
["BOWSER"]
["BOX HILL"]
["BRADSHAW"]
["BRANXHOLME"]
["BREAKWATER"]
["BRIDGEWATER"]
["BRIGHTON BEACH"]
["BRIGHTON EAST SUBSTN"]
["BRIM"]
["BROADFORD"]
["BROADMEADOWS"]
["BRONZEWING"]
["BROOKLYN"]
["BROOMFIELD"]
["BRUNSWICK"]
["BRUNSWICK BLACK ST SUBSTN"]
["BRUNSWICK TRAM"]
["BRUNSWICK WEST DAWSON ST SUBSTN"]
["BRUNSWICK WEST MELVILLE RD SUBSTN"]
["BRUNSWICK WEST TRAM"]
["BUANGOR"]
["BUCKLEY"]
["BUCKRABANYULE"]
["BULLABUL"]
["BULLARTO"]
["BULOKE"]
["BUNDOORA CLEMENTS DR SUBSTN"]
["BUNDOORA PLENTY RD/GRIMSHAW SUBSTN"]
["BUNG BONG"]
["BUNGAREE"]
["BUNINYONG"]
["BUNNALOO"]
["BUNYIP"]
["BURNLEY"]
["BURRABOI"]
["BURROIN"]
["BURRUM"]
["BURRUMBEET"]
["BURWOOD"]
["BURWOOD SUBSTN"]
["BYLANDS"]
["BYRNESIDE"]
["CALDERMEADE"]
["CALDWELL"]
["CALIFORNIA GULLY"]
["CALVERT"]
["CAMBERWELL"]
["CAMBERWELL SUBSTN"]
["CAMBERWELL TRAM"]
["CAMPBELL"]
["CAMPBELLFIELD"]
["CAMPERDOWN"]
["CANNIE"]
["CANTERBURY"]
["CARAPOOEE"]
["CARDINIA ROAD"]
["CARINA"]
["CARISBROOK"]
["CARLSRUHE"]
["CARLTON SUBSTN & CONTROL CENTRE"]
["CARNEGIE"]
["CAROLINE SPRINGS"]
["CARPOLAC"]
["CARRUM"]
["CARWARP"]
["CASTERTON"]
["CASTLEMAINE"]
["CATHKIN"]
["CAULFIELD"]
["CAVENDISH"]
["CHARLTON"]
["CHATHAM"]
["CHELSEA"]
["CHELTENHAM"]
["CHESNEY"]
["CHEVIOT"]
["CHEWTON"]
["CHILLINGOLLAH"]
["CHILTERN"]
["CHINKAPOOK"]
["CLARKEFIELD"]
["CLAYTON"]
["CLIFTON HILL"]
["CLIFTON HILL SUBSTN"]
["CLUNES"]
["CLYDE"]
["COBRAM"]
["COBURG"]
["COBURG EAST"]
["COBURG NORTH SUBSTN"]
["COCAMBA"]
["COHUNA"]
["COLAC"]
["COLBINABBIN"]
["COLDSTREAM"]
["COLERAINE JUNCTION"]
["COLLINGWOOD"]
["CONDAH"]
["CONGUPNA"]
["COOLAROO"]
["COONIMUR"]
["COPE COPE"]
["CORIO"]
["COROMBY"]
["COSGROVE"]
["COWANGIE"]
["CRAIGIEBURN"]
["CRANBOURNE"]
["CREIGHTON"]
["CRESSY"]
["CRESWICK"]
["CRIB POINT"]
["CROWLANDS"]
["CROXTON"]
["CROYDON"]
["CUDGEE"]
["CULGOA"]
["CURYO"]
["DAHLEN"]
["DAISY HILL"]
["DALMORE"]
["DANDENONG"]
["DANYO"]
["DAREBIN"]
["DARLING"]
["DARNUM"]
["DARTMOOR"]
["DATTUCK"]
["DAYLESFORD"]
["DEEP LEAD"]
["DEEPDENE SUBSTN"]
["DEER PARK"]
["DENILIQUIN"]
["DENNINGTON"]
["DENNIS"]
["DERBY"]
["DERRINALLUM"]
["DETPA"]
["DEVENISH"]
["DHURAGOON"]
["DIAMOND CREEK"]
["DIAPUR"]
["DIGGERS REST"]
["DIGGORA WEST"]
["DIMBOOLA"]
["DINGEE"]
["DOBIE"]
["DOCKLANDS SUBSTN"]
["DONALD"]
["DONNYBROOK"]
["DONVALE BUS TERMINUS"]
["DOOEN"]
["DOOKIE"]
["DOROQ"]
["DROUIN"]
["DRYSDALE"]
["DUMOSA"]
["DUNKELD"]
["DUNNEWORTHY"]
["DUNNSTOWN"]
["DUNOLLY"]
["DUVERNEY"]
["DYNON"]
["EAGLEHAWK"]
["EAGLEMONT"]
["EAST BURWOOD"]
["EAST BURWOOD SUBSTN"]
["EAST CAMBERWELL"]
["EAST CAMBERWELL SUBST"]
["EAST KEW"]
["EAST MALVERN"]
["EAST NATIMUK"]
["EAST PRESTON SUBSTN"]
["EAST RICHMOND"]
["EBDEN"]
["ECHUCA"]
["ECHUCA RACECOURSE"]
["EDITHVALE"]
["EDWARD"]
["ELAINE"]
["ELLAM"]
["ELMHURST"]
["ELMORE"]
["ELPHINSTONE"]
["ELSTERNWICK"]
["ELTHAM"]
["EMERALD"]
["EMU"]
["ENGLEFIELD"]
["EPPING"]
["EPPING NORTH"]
["EPSOM"]
["ERWEN"]
["ESSENDON"]
["ESSENDON NORTH SUBSTN"]
["ESSENDON(ASCOT VALE) TRAM"]
["EUREKA"]
["EUROA"]
["EVERSLEY"]
["FAIRFIELD"]
["FAIRLEY"]
["FAIRVIEW"]
["FAWKNER"]
["FERN HILL"]
["FERNBANK"]
["FERNTREE GULLY"]
["FITZROY GEORGE ST SUBSTN"]
["FITZROY NORTH HOLDEN ST SUBSTN"]
["FITZROY TRAM (AVM)"]
["FITZROY YOUNG ST SUBSTN"]
["FLAGSTAFF"]
["FLEMINGTON BRIDGE"]
["FLEMINGTON RACECOURSE"]
["FLEMINGTON SHOW GROUNDS"]
["FLINDERS STREET"]
["FLINDERS STREET TIE SUBSTN"]
["FLYNN"]
["FOOTSCRAY"]
["FOOTSCRAY GOODS"]
["FRANKSTON"]
["FULHAM"]
["FYANSFORD"]
["GALAH"]
["GALAQUIL"]
["GALVIN"]
["GAMA"]
["GANNAWARRA"]
["GARDENVALE"]
["GARDINER"]
["GARFIELD"]
["GARVOC"]
["GATUM"]
["GEELONG"]
["GENERAL MOTORS"]
["GERANG GERUNG"]
["GHERINGHAP"]
["GINIFER"]
["GISBORNE"]
["GLEN IRIS"]
["GLEN THOMPSON"]
["GLEN WAVERLEY"]
["GLENALBYN"]
["GLENBERVIE"]
["GLENFERRIE"]
["GLENHUNTLY"]
["GLENHUNTLY SUBSTN"]
["GLENHUNTLY TRAM"]
["GLENLOTH"]
["GLENORCHY"]
["GLENROWAN"]
["GLENROY"]
["GNARKEET"]
["GOLDEN SQUARE"]
["GOLDSBOROUGH"]
["GOORAMBAT"]
["GOORNONG"]
["GORAE"]
["GORDON"]
["GOROKE"]
["GOWANFORD"]
["GOWRIE"]
["GOYURA"]
["GRAHAM"]
["GRANITE"]
["GRASSDALE"]
["GREAT WESTERN"]
["GREDGWIN"]
["GREENSBOROUGH"]
["GREENWALD"]
["GROVEDALE"]
["GUILDFORD"]
["GULPA"]
["GUNBOWER"]
["GYMBOWEN"]
["GYPSUM"]
["HALLAM"]
["HAMILTON"]
["HAMILTON STOCKYARDS"]
["HAMMOND"]
["HAMPTON"]
["HARCOURT"]
["HARTWELL"]
["HASTINGS"]
["HATTAH"]
["HAVELOCK"]
["HAWKESDALE"]
["HAWKSBURN"]
["HAWKSTOWE"]
["HAWTHORN"]
["HAWTHORN SUBSTN"]
["HAWTHORN TRAM"]
["HAZELWOOD SIDING"]
["HEALESVILLE"]
["HEATHCOTE JUNCTION"]
["HEATHERDALE"]
["HEATHMERE"]
["HEATHMONT"]
["HEIDELBERG"]
["HENDERSYDE"]
["HENTY"]
["HERNES OAK"]
["HEYINGTON"]
["HEYWOOD"]
["HIGHETT"]
["HILLSIDE"]
["HOLMESGLEN"]
["HOMEBUSH"]
["HOMEWOOD"]
["HOPETOUN"]
["HOPPERS CROSSING"]
["HORSHAM"]
["HUGHESDALE"]
["HUNTER"]
["HUNTINGDALE"]
["HUNTLY"]
["HURSTBRIDGE"]
["ILLOWA"]
["IMPIMI"]
["INGLEWOOD"]
["INGLISTON"]
["INVERLEIGH"]
["IRREWARRA"]
["IRYMPLE"]
["IVANHOE"]
["JACANA"]
["JACKSON"]
["JALLUMBA"]
["JEETHO"]
["JEFFRIES"]
["JEPARIT"]
["JEWELL"]
["JIMARINGLE"]
["JOLIMONT"]
["JORDANVILLE"]
["JOYCE S CREEK"]
["JUNG"]
["KANAGULK"]
["KANANOOK"]
["KANAWALLA"]
["KANGAROO FLAT"]
["KANIVA"]
["KANUMBRA"]
["KANYAPELLA"]
["KARAWINNA"]
["KARDELLA"]
["KAROOK"]
["KARYRIE"]
["KATAMATITE"]
["KATUNGA"]
["KEELY"]
["KEILOR EAST"]
["KEILOR PLAINS"]
["KENSINGTON"]
["KEON PARK"]
["KERANG"]
["KERRISDALE"]
["KEW EAST SUBSTN"]
["KEW SUBSTN"]
["KEW TRAM DEPOT"]
["KIAMAL"]
["KIATA"]
["KILMANY"]
["KILMORE"]
["KILMORE EAST"]
["KINGSTON"]
["KINNABULLA"]
["KOIMBO"]
["KOOLOONONG"]
["KOONDROOK"]
["KOONEDAH"]
["KOO-WEE-RUP"]
["KOOYONG"]
["KORIELLA"]
["KOROIT"]
["KORONG VALE"]
["KORUMBURRA"]
["KOTTA"]
["KOYUGA"]
["KULWIN"]
["KURTING"]
["KYABRAM"]
["KYNETON"]
["KYUP"]
["LABURNUM"]
["LAH"]
["LAKE BOGA"]
["LAKE CHARM"]
["LAL LAL"]
["LALBERT"]
["LALOR"]
["LANG LANG"]
["LANGI LOGAN"]
["LANGWARRIN"]
["LARA"]
["LARPENT"]
["LASCELLES"]
["LAURIE"]
["LAVERTON"]
["LEAWARRA"]
["LEICHARDT"]
["LEITCHVILLE"]
["LEITPAR"]
["LEONGATHA"]
["LETHBRIDGE"]
["LILLIMUR"]
["LILLIPUT"]
["LILYDALE"]
["LINDENOW"]
["LINGA"]
["LINTON JUNCTION"]
["LISMORE"]
["LITCHFIELD"]
["LITTLE RIVER"]
["LLANELLY"]
["LOCH"]
["LOCKINGTON"]
["LOCKSLEY"]
["LONGWARRY"]
["LONGWOOD"]
["LORQUON"]
["LOY YANG"]
["LUBECK"]
["LYNBROOK"]
["LYNDHURST"]
["LYONS"]
["LYONVILLE"]
["LYSAGHT-LONG ISLAND"]
["MACAULAY"]
["MACEDON"]
["MACLEOD"]
["MACORNA"]
["MADDINGLEY STABLING SIDINGS"]
["MAFFRA"]
["MALDON"]
["MALMSBURY"]
["MALVERN"]
["MALVERN GLENFERRIE RD SUBSTN"]
["MALVERN MALVERN RD SUBSTN"]
["MALVERN TRAM DEPOT"]
["MANANGATANG"]
["MANGALORE"]
["MANNERIM"]
["MANOR"]
["MARCUS"]
["MARGOOYA"]
["MARIBYRNONG SUBSTN"]
["MARMALAKE"]
["MARNOO"]
["MARONG"]
["MAROONA"]
["MARP"]
["MARSHALL"]
["MARYBOROUGH"]
["MASSEY"]
["MATHOURA"]
["MCCOLL"]
["MCKINNON"]
["MEATIAN"]
["MEDINA"]
["MELBOURNE"]
["MELBOURNE CENTRAL"]
["MELBOURNE CENTRAL SUBSTN"]
["MELBOURNE LITTLE BOURKE ST SUBSTN"]
["MELBOURNE MARKET"]
["MELBOURNE YARD"]
["MELLIS"]
["MELTON"]
["MENTONE"]
["MERBEIN"]
["MERBEIN WEST"]
["MEREDITH"]
["MERINDA PARK"]
["MERINGUR"]
["MERINO"]
["MERLYNSTON"]
["MERNDA"]
["MERRI"]
["MERRIGUM"]
["MERRINEE"]
["MERTON"]
["MIAKITE"]
["MIDDLE BRIGHTON"]
["MIDDLE BRIGHTON SUBSTN"]
["MIDDLE CREEK"]
["MIDDLE FOOTSCRAY"]
["MIDDLE PARK"]
["MILDURA"]
["MILLBROOK"]
["MILLTOWN"]
["MINCHA"]
["MINHAMITE"]
["MININERA"]
["MINYIP"]
["MIRALIE"]
["MIRAM"]
["MITCHAM"]
["MITIAMO"]
["MITRE"]
["MITTYACK"]
["MOAMA"]
["MOBILTOWN"]
["MOE"]
["MOE SOUTH"]
["MOIRA"]
["MOLESWORTH"]
["MOLOGA"]
["MONEA"]
["MONOMEITH"]
["MONT ALBERT"]
["MONTAGUE"]
["MONTGOMERY"]
["MONTMORENCY"]
["MOOLORT"]
["MOOLPA"]
["MOONDARRA"]
["MOONEE PONDS"]
["MOORABBIN"]
["MOORABOOL"]
["MOOROODUC"]
["MOOROOLBARK"]
["MOOROOPNA"]
["MORDIALLOC"]
["MORELAND"]
["MORELAND SUBSTN"]
["MORIAC"]
["MORRADOO"]
["MORTAT"]
["MORTLAKE"]
["MORTON PLAINS"]
["MORWELL"]
["MOULAMEIN"]
["MOUNT BLACKWOOD"]
["MOUNT DANDENONG"]
["MOUNT WAVERLEY"]
["MOUTAJUP"]
["MUCKLEFORD"]
["MULWALA"]
["MUNRO"]
["MURCHISON"]
["MURCHISON EAST"]
["MURGHEBOLUC"]
["MURRABIT"]
["MURRAYVILLE"]
["MURRUMBEENA"]
["MURTOA"]
["MUSK"]
["MYALL"]
["MYAMYN"]
["MYERS FLAT"]
["MYSIA"]
["MYSTIC PARK"]
["MYWEE"]
["NACURRIE"]
["NAGAMBIE"]
["NANDALY"]
["NAR-NAR-GOON"]
["NARRE WARREN"]
["NATHALIA"]
["NATIMUK"]
["NATYA"]
["NAVIGATOR"]
["NERRIN NERRIN"]
["NETHERBY"]
["NEWLYN"]
["NEWMARKET"]
["NEWPORT"]
["NEWPORT POWER HOUSE"]
["NEWPORT WORKSHOP"]
["NEWSTEAD"]
["NEWTOWN"]
["NHILL"]
["NIEMUR"]
["NILMA"]
["NINDA"]
["NOBLE PARK"]
["NOORAMUNGA"]
["NORADJUHA"]
["NORTH BALLARAT"]
["NORTH BENDIGO"]
["NORTH BRIGHTON"]
["NORTH CARLTON"]
["NORTH CRESWICK"]
["NORTH DYNON"]
["NORTH FITZROY"]
["NORTH FITZROY PARK ST SUBSTN"]
["NORTH GEELONG"]
["NORTH MELBOURNE"]
["NORTH PORT"]
["NORTH RICHMOND"]
["NORTH SHORE"]
["NORTH WILLIAMSTOWN"]
["NORTHCOTE"]
["NOWINGI"]
["NULLAN"]
["NULLAWIL"]
["NUMURKAH"]
["NUNAWADING"]
["NUNGA"]
["NYAH WEST"]
["NYARRIN"]
["NYORA"]
["OAK PARK"]
["OAKLANDS"]
["OAKLEIGH"]
["OAKVALE"]
["OFFICER"]
["ORMOND"]
["OUTTRIM"]
["OUYEN"]
["PAINSWICK"]
["PAISLEY"]
["PAKENHAM"]
["PANITYA"]
["PANMURE"]
["PARKDALE"]
["PARLIAMENT"]
["PARWAN"]
["PASCOE VALE"]
["PATCHEWOLLOCK"]
["PATHO"]
["PATTERSON"]
["PEECHELBA EAST"]
["PENSHURST"]
["PENTAL"]
["PEREKERTON"]
["PETTAVEL"]
["PIANGIL"]
["PICOLA"]
["PIER MILLAN"]
["PIMPINIO"]
["PINE LODGE"]
["PIRA"]
["PIRLTA"]
["PIRRON YALLOCK"]
["POLLARD"]
["POMBORNEIT"]
["POORNEET"]
["PORT MELBOURNE"]
["PORTLAND"]
["PRAHRAN"]
["PRAHRAN SUBSTN"]
["PRAIRIE"]
["PRESTON"]
["PRESTON EAST TRAM DEPOT"]
["PRESTON TRAM WORKSHOPS"]
["PRINCES BRIDGE"]
["PULLUT"]
["PURA PURA"]
["PURALKA"]
["PURDEET"]
["PYRAMID"]
["QUAMBATOOK"]
["QUANTONG"]
["QUEENSCLIFF"]
["RAINBOW"]
["RAVENSWOOD"]
["RAYWOOD"]
["REDCLIFFS"]
["REGENT"]
["REMLAW SIDING"]
["RENNICK"]
["RENNIE"]
["RESERVOIR"]
["RESERVOIR PLENTY RD SUBSTN"]
["RICHMOND"]
["RICHMOND BRIDGE RD SUBSTN"]
["RICHMOND SWAN ST SUBSTN"]
["RIDDELLS CREEK"]
["RINGWOOD"]
["RINGWOOD EAST"]
["RIPPONLEA"]
["RIVERSDALE"]
["ROBINVALE"]
["ROCHESTER"]
["ROCKBANK"]
["ROSANNA"]
["ROSEBERY"]
["ROSEDALE"]
["ROSLYNMEAD"]
["ROWSLEY"]
["ROYAL PARK"]
["RUBY"]
["RUPANYUP"]
["RUPERTSWOOD"]
["RUSHALL"]
["RUSHWORTH"]
["RUTHERGLEN"]
["RUTHVEN"]
["SALE"]
["SALISBURY"]
["SANDFORD"]
["SANDOWN PARK"]
["SANDRINGHAM"]
["SANGER"]
["SEA LAKE"]
["SEAFORD"]
["SEAHOLME"]
["SEBASTIAN"]
["SEDDON"]
["SERVICETON"]
["SEYMOUR"]
["SHEEP HILLS"]
["SHELBOURNE"]
["SHEPPARTON"]
["SHERWOOD PARK"]
["SIMSON"]
["SINCLAIR"]
["site"]
["SLOANE"]
["SMEATON"]
["SOMERTON"]
["SOMERVILLE"]
["SOUTH DYNON"]
["SOUTH GEELONG"]
["SOUTH KENSINGTON"]
["SOUTH KERANG"]
["SOUTH MELBOURNE"]
["SOUTH MELBOURNE HANCOCK ST SUBSTN"]
["SOUTH MELBOURNE KINGSWAY SUBSTN"]
["SOUTH MORANG"]
["SOUTH YARRA"]
["SOUTH YARRA SUBSTN"]
["SOUTHBANK TRAM"]
["SOUTHDOWN"]
["SOUTHERN CROSS"]
["SPEED"]
["SPENCER STREET"]
["SPENCER STREET COACH TERMINAL"]
["SPOTSWOOD"]
["SPRINGHURST"]
["SPRINGVALE"]
["ST ALBANS"]
["ST ARNAUD"]
["ST JAMES"]
["ST KILDA"]
["ST KILDA CHAPEL ST SUBSTN"]
["STANHOPE"]
["STAUGHTON'S SIDING"]
["STAVELY"]
["STAWELL"]
["STONEYFORD"]
["STONY POINT"]
["STRANGWAY"]
["STRATFORD"]
["STRATHALLAN"]
["STRATHKELLAR"]
["STRATHMERTON"]
["STRATHMORE"]
["STRATHMORE HEIGHTS"]
["SULKY"]
["SUNBURY"]
["SUNSHINE"]
["SUNSHINE NORTH"]
["SURREY HILLS"]
["SURREY HILLS SUBSTN"]
["SUTHERLAND"]
["SWAN HILL"]
["SWANWATER"]
["SYDENHAM"]
["SYNDAL"]
["TABILK"]
["TABOR"]
["TALBOT"]
["TALLAROOK"]
["TALLYGAROOPNA"]
["TANDARRA"]
["TANTONAN"]
["TARADALE"]
["TARNAGULLA"]
["TARNEIT"]
["TARRANGINNIE"]
["TARRANYURK"]
["TARRAWARRA"]
["TATURA"]
["TATYOON"]
["TECOMA"]
["TEDDYWADDY"]
["TELFORD"]
["TEMPY"]
["TERANG"]
["THOMASTOWN"]
["THORNBURY"]
["THORNBURY SUBSTN"]
["THURLA"]
["THYRA"]
["TIEGA"]
["TIMBOON JUNCTION"]
["TOCUMWAL"]
["TONGALA"]
["TOOLAMBA"]
["TOOLONDO"]
["TOORADIN"]
["TOORAK"]
["TOORONGA"]
["TORRITA"]
["TOTTENHAM"]
["TOURELLO"]
["TRAFALGAR"]
["TRAGOWEL"]
["TRARALGON"]
["TRAWALLA"]
["TRAWOOL"]
["TRENTHAM"]
["TRESCO"]
["TRINITA"]
["TULKARA"]
["TUNGAMAH"]
["TURRIFF"]
["TUTYE"]
["TYABB"]
["TYLDEN"]
["TYNONG"]
["ULTIMA"]
["UNDERBOOL"]
["UPFIELD"]
["UPPER FERNTREE GULLY"]
["UPWEY"]
["UPWEY SUBSTN"]
["URANGARA"]
["VASEY"]
["VECTIS"]
["VERMONT SOUTH SUBSTN"]
["VICTORIA PARK"]
["VIOLET TOWN"]
["VITE VITE"]
["WAAIA"]
["WAHGUNYAH"]
["WAHRING"]
["WAIL"]
["WAITCHIE"]
["WAKOOL"]
["WAL WAL"]
["WALLACE"]
["WALLAN"]
["WALPEUP"]
["WANALTA"]
["WANDONG"]
["WANGAMONG"]
["WANGARATTA"]
["WARANGA"]
["WARNCOORT"]
["WARNE"]
["WARRA YADIN"]
["WARRACKNABEAL"]
["WARRAGOON"]
["WARRAGUL"]
["WARRENHEIP"]
["WARRNAMBOOL"]
["WARRONG"]
["WATCHEM"]
["WATCHUPGA"]
["WATERGARDENS"]
["WATSONIA"]
["WATTLE GLEN"]
["WAUBRA JUNCTION"]
["WAURN PONDS"]
["WEBB DOCK"]
["WEDDERBURN"]
["WEDDERBURN JUNCTION"]
["WEERITE"]
["WELLSFORD"]
["WENDOUREE"]
["WERRIBEE"]
["WERRIMULL"]
["WEST FOOTSCRAY"]
["WEST RICHMOND"]
["WESTALL"]
["WESTBY"]
["WESTGARTH"]
["WESTMERE"]
["WESTONA"]
["WHITELAW"]
["WHITTLESEA"]
["WILLA"]
["WILLAURA"]
["WILLIAMS LANDING"]
["WILLIAMSTOWN"]
["WILLIAMSTOWN BEACH"]
["WILLISON"]
["WINCHELSEA"]
["WINDERMERE"]
["WINDSOR"]
["WINGEEL"]
["WINNAP"]
["WINTON"]
["WODONGA"]
["WOMBOOTA"]
["WONTHAGGI"]
["WOODEND"]
["WOODSIDE"]
["WOODVALE"]
["WOOLSTHORPE"]
["WOOMELANG"]
["WOORINEN"]
["WUNGHNU"]
["WYCHEPROOF"]
["WYCHITELLA"]
["WYNDHAM VALE"]
["YAAPEET"]
["YABBA NORTH"]
["YABBA SOUTH"]
["YALLAKOOL"]
["YAN YEAN"]
["YANAC"]
["YANGALAKE"]
["YARCK"]
["YARRA GLEN"]
["YARRAGON"]
["YARRAMAN"]
["YARRARA"]
["YARRAVILLE"]
["YARRAWONGA"]
["YARROWEYAH"]
["YARTO"]
["YATCHAW"]
["YATPOOL"]
["YEA"]
["YELTA"]
["YENDON"]
["YERING"]
["YOUANMITE"]

{"sheet":"Validation","index":3,"n_rows":47,"n_cols":24,"rows_kept":47,"cut":false,"hidden":true,"merged":[]}
["SOURCE_REGISTER",null,{"$f":"ROWS(INDIRECT(A1))-E1","v":{"$error":"#REF!"}},"total rows (minus blank)",{"$f":"COUNTIFS(INDIRECT($A$1&\"[\"&C3&\"]\"), \"=\", INDIRECT($A$1&\"[\"&C4&\"]\"), \"=\", INDIRECT($A$1&\"[\"&C5&\"]\"), \"=\", INDIRECT($A$1&\"[\"&C6&\"]\"), \"=\", INDIRECT($A$1&\"[\"&C7&\"]\"), \"=\", INDIRECT($A$1&\"[\"&C8&\"]\"), \"=\", INDIRECT($A$1&\"[\"&C9&\"]\"), \"=\", INDIRECT($A$1&\"[\"&C11&\"]\"), \"=\", INDIRECT($A$1&\"[\"&C12&\"]\"), \"=\", INDIRECT($A$1&\"[\"&C13&\"]\"), \"=\", INDIRECT($A$1&\"[\"&C14&\"]\"), \"=\", INDIRECT($A$1&\"[\"&C15&\"]\"), \"=\", INDIRECT($A$1&\"[\"&C16&\"]\"), \"=\", INDIRECT($A$1&\"[\"&C17&\"]\"), \"=\", INDIRECT($A$1&\"[\"&C18&\"]\"), \"=\", INDIRECT($A$1&\"[\"&C19&\"]\"), \"=\", INDIRECT($A$1&\"[\"&C20&\"]\"), \"=\", INDIRECT($A$1&\"[\"&C21&\"]\"), \"=\", INDIRECT($A$1&\"[\"&C22&\"]\"), \"=\")","v":{"$error":"#REF!"}},"blank rows",null,null,{"$f":"IF(src_blank=src_total, \"No Source/Impact Records\", IF(src_missing>0, \"Missing Mandatory Data\", IF(src_exceed>0, \"Text is too long\", \"Validation OK\")))","v":{"$error":"#REF!"}},null,null,null,"BORE_REGISTER",{"$f":"ROWS(INDIRECT(M1))-P1","v":0},"total rows (minus blank)",{"$f":"COUNTIFS(INDIRECT($M$1&\"[\"&O3&\"]\"), \"=\", INDIRECT($M$1&\"[\"&O4&\"]\"), \"=\", INDIRECT($M$1&\"[\"&O5&\"]\"), \"=\", INDIRECT($M$1&\"[\"&O6&\"]\"), \"=\", INDIRECT($M$1&\"[\"&O7&\"]\"), \"=\", INDIRECT($M$1&\"[\"&O8&\"]\"), \"=\", INDIRECT($M$1&\"[\"&O9&\"]\"), \"=\", INDIRECT($M$1&\"[\"&O10&\"]\"), \"=\", INDIRECT($M$1&\"[\"&O11&\"]\"), \"=\", INDIRECT($M$1&\"[\"&O12&\"]\"), \"=\", INDIRECT($M$1&\"[\"&O13&\"]\"), \"=\", INDIRECT($M$1&\"[\"&O14&\"]\"), \"=\", INDIRECT($M$1&\"[\"&O15&\"]\"), \"=\", INDIRECT($M$1&\"[\"&O16&\"]\"), \"=\", INDIRECT($M$1&\"[\"&O17&\"]\"), \"=\", INDIRECT($M$1&\"[\"&O18&\"]\"), \"=\", INDIRECT($M$1&\"[\"&O19&\"]\"), \"=\", INDIRECT($M$1&\"[\"&O20&\"]\"), \"=\")","v":9},"blank rows",null,null,null,{"$f":"IF(bore_blank=bore_total, \"No Bore Records\", IF(bore_missing>0, \"Missing Mandatory Data\", IF(bore_exceed>0, \"Text is too long\", IF(bore_text>0, \"Text in Number Column\",  \"Validation OK\"))))","v":"No Bore Records"}]
["field_name","id","title","type","length","mandatory","description","max_length","check_length","blank_rows","mandatory_check",null,"field_name","id","title","type","length","mandatory","description","max_length","check_length","blank_rows","mandatory_check","number fields with text"]
["record_type",1,{"$f":"INDEX(#REF!, validate_Source[[#This Row],[id]])","v":{"$error":"#REF!"}},"Dropdown",null,"Y",{"$f":"D3 & IF(ISBLANK(E3), \"\", \" (\" & E3 &\" characters)\") & IF(ISBLANK(validate_Source[[#This Row],[mandatory]]), \"\", \"*\")","v":"Dropdown*"},{"$f":"MAX(LEN(INDIRECT($A$1&\"[\"&validate_Source[[#This Row],[title]]&\"]\")))","v":{"$error":"#REF!"}},{"$f":"IF(OR(ISBLANK(validate_Source[[#This Row],[length]]), ISBLANK(validate_Source[[#This Row],[max_length]]),  validate_Source[[#This Row],[max_length]]<validate_Source[[#This Row],[length]]), 0, 1)","v":{"$error":"#REF!"}},{"$f":"COUNTBLANK(INDIRECT($A$1&\"[\"&C3&\"]\"))-$E$1","v":{"$error":"#REF!"}},{"$f":"IF(AND(validate_Source[[#This Row],[mandatory]]=\"Y\", validate_Source[[#This Row],[blank_rows]]<=$C$1, validate_Source[[#This Row],[blank_rows]]>0), 1, 0)","v":{"$error":"#REF!"}},null,"record_type",1,{"$f":"INDEX(BORE_REGISTER[#Headers], validate_Bores[[#This Row],[id]])","v":"Does this Bore record replace an existing Bore ID?"},"Dropdown",null,"Y",{"$f":"P3 & IF(ISBLANK(Q3), \"\", \" (\" & Q3 &\" characters)\") & IF(ISBLANK(validate_Bores[[#This Row],[mandatory]]), \"\", \"*\")","v":"Dropdown*"},{"$f":"MAX(LEN(INDIRECT($M$1&\"[\"&validate_Bores[[#This Row],[title]]&\"]\")))","v":0},{"$f":"IF(OR(ISBLANK(validate_Bores[[#This Row],[length]]), ISBLANK(validate_Bores[[#This Row],[max_length]]),  validate_Bores[[#This Row],[max_length]]<validate_Bores[[#This Row],[length]]), 0, 1)","v":0},{"$f":"COUNTBLANK(INDIRECT($M$1&\"[\"&O3&\"]\"))-$P$1","v":0},{"$f":"IF(AND(validate_Bores[[#This Row],[mandatory]]=\"Y\", validate_Bores[[#This Row],[blank_rows]]<=$N$1, validate_Bores[[#This Row],[blank_rows]]>0), 1, 0)","v":0}]
["source_id",2,{"$f":"INDEX(#REF!, validate_Source[[#This Row],[id]])","v":{"$error":"#REF!"}},"Whole Number",null,null,{"$f":"D4 & IF(ISBLANK(E4), \"\", \" (\" & E4 &\" characters)\") & IF(ISBLANK(validate_Source[[#This Row],[mandatory]]), \"\", \"*\")","v":"Whole Number"},{"$f":"MAX(LEN(INDIRECT($A$1&\"[\"&validate_Source[[#This Row],[title]]&\"]\")))","v":{"$error":"#REF!"}},{"$f":"IF(OR(ISBLANK(validate_Source[[#This Row],[length]]), ISBLANK(validate_Source[[#This Row],[max_length]]),  validate_Source[[#This Row],[max_length]]<validate_Source[[#This Row],[length]]), 0, 1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(AND(validate_Source[[#This Row],[mandatory]]=\"Y\", validate_Source[[#This Row],[blank_rows]]<=$C$1, validate_Source[[#This Row],[blank_rows]]>0), 1, 0)","v":{"$error":"#REF!"}},null,"bore_id",2,{"$f":"INDEX(BORE_REGISTER[#Headers], validate_Bores[[#This Row],[id]])","v":"CHAMP BORE ID\n(if the record replaces an existing bore)"},"Whole Number",null,null,{"$f":"P4 & IF(ISBLANK(Q4), \"\", \" (\" & Q4 &\" characters)\") & IF(ISBLANK(validate_Bores[[#This Row],[mandatory]]), \"\", \"*\")","v":"Whole Number"},{"$f":"MAX(LEN(INDIRECT($M$1&\"[\"&validate_Bores[[#This Row],[title]]&\"]\")))","v":0},{"$f":"IF(OR(ISBLANK(validate_Bores[[#This Row],[length]]), ISBLANK(validate_Bores[[#This Row],[max_length]]),  validate_Bores[[#This Row],[max_length]]<validate_Bores[[#This Row],[length]]), 0, 1)","v":0},0,{"$f":"IF(AND(validate_Bores[[#This Row],[mandatory]]=\"Y\", validate_Bores[[#This Row],[blank_rows]]<=$N$1, validate_Bores[[#This Row],[blank_rows]]>0), 1, 0)","v":0},{"$f":"IF(AND(validate_Bores[[#This Row],[blank_rows]]<>$V$22, ISNUMBER(AVERAGE(INDIRECT($M$1&\"[\"&validate_Bores[[#This Row],[title]]&\"]\")))=FALSE), 1, 0)","v":0}]
["site_desc",3,{"$f":"INDEX(#REF!, validate_Source[[#This Row],[id]])","v":{"$error":"#REF!"}},"Dropdown",null,"Y",{"$f":"D5 & IF(ISBLANK(E5), \"\", \" (\" & E5 &\" characters)\") & IF(ISBLANK(validate_Source[[#This Row],[mandatory]]), \"\", \"*\")","v":"Dropdown*"},{"$f":"MAX(LEN(INDIRECT($A$1&\"[\"&validate_Source[[#This Row],[title]]&\"]\")))","v":{"$error":"#REF!"}},{"$f":"IF(OR(ISBLANK(validate_Source[[#This Row],[length]]), ISBLANK(validate_Source[[#This Row],[max_length]]),  validate_Source[[#This Row],[max_length]]<validate_Source[[#This Row],[length]]), 0, 1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(AND(validate_Source[[#This Row],[mandatory]]=\"Y\", validate_Source[[#This Row],[blank_rows]]<=$C$1, validate_Source[[#This Row],[blank_rows]]>0), 1, 0)","v":{"$error":"#REF!"}},null,"bore_name",3,{"$f":"INDEX(BORE_REGISTER[#Headers], validate_Bores[[#This Row],[id]])","v":"Unique Bore ID"},"Free text",50,"Y",{"$f":"P5 & IF(ISBLANK(Q5), \"\", \" (\" & Q5 &\" characters)\") & IF(ISBLANK(validate_Bores[[#This Row],[mandatory]]), \"\", \"*\")","v":"Free text (50 characters)*"},{"$f":"MAX(LEN(INDIRECT($M$1&\"[\"&validate_Bores[[#This Row],[title]]&\"]\")))","v":0},{"$f":"IF(OR(ISBLANK(validate_Bores[[#This Row],[length]]), ISBLANK(validate_Bores[[#This Row],[max_length]]),  validate_Bores[[#This Row],[max_length]]<validate_Bores[[#This Row],[length]]), 0, 1)","v":0},0,{"$f":"IF(AND(validate_Bores[[#This Row],[mandatory]]=\"Y\", validate_Bores[[#This Row],[blank_rows]]<=$N$1, validate_Bores[[#This Row],[blank_rows]]>0), 1, 0)","v":0}]
["lot_desc",4,{"$f":"INDEX(#REF!, validate_Source[[#This Row],[id]])","v":{"$error":"#REF!"}},"Free text",1000,null,{"$f":"D6 & IF(ISBLANK(E6), \"\", \" (\" & E6 &\" characters)\") & IF(ISBLANK(validate_Source[[#This Row],[mandatory]]), \"\", \"*\")","v":"Free text (1000 characters)"},{"$f":"MAX(LEN(INDIRECT($A$1&\"[\"&validate_Source[[#This Row],[title]]&\"]\")))","v":{"$error":"#REF!"}},{"$f":"IF(OR(ISBLANK(validate_Source[[#This Row],[length]]), ISBLANK(validate_Source[[#This Row],[max_length]]),  validate_Source[[#This Row],[max_length]]<validate_Source[[#This Row],[length]]), 0, 1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(AND(validate_Source[[#This Row],[mandatory]]=\"Y\", validate_Source[[#This Row],[blank_rows]]<=$C$1, validate_Source[[#This Row],[blank_rows]]>0), 1, 0)","v":{"$error":"#REF!"}},null,"bore_type",4,{"$f":"INDEX(BORE_REGISTER[#Headers], validate_Bores[[#This Row],[id]])","v":"Bore Type"},"Dropdown",null,"Y",{"$f":"P6 & IF(ISBLANK(Q6), \"\", \" (\" & Q6 &\" characters)\") & IF(ISBLANK(validate_Bores[[#This Row],[mandatory]]), \"\", \"*\")","v":"Dropdown*"},{"$f":"MAX(LEN(INDIRECT($M$1&\"[\"&validate_Bores[[#This Row],[title]]&\"]\")))","v":0},{"$f":"IF(OR(ISBLANK(validate_Bores[[#This Row],[length]]), ISBLANK(validate_Bores[[#This Row],[max_length]]),  validate_Bores[[#This Row],[max_length]]<validate_Bores[[#This Row],[length]]), 0, 1)","v":0},0,{"$f":"IF(AND(validate_Bores[[#This Row],[mandatory]]=\"Y\", validate_Bores[[#This Row],[blank_rows]]<=$N$1, validate_Bores[[#This Row],[blank_rows]]>0), 1, 0)","v":0}]
["lease_status",5,{"$f":"INDEX(#REF!, validate_Source[[#This Row],[id]])","v":{"$error":"#REF!"}},"Dropdown",null,null,{"$f":"D7 & IF(ISBLANK(E7), \"\", \" (\" & E7 &\" characters)\") & IF(ISBLANK(validate_Source[[#This Row],[mandatory]]), \"\", \"*\")","v":"Dropdown"},{"$f":"MAX(LEN(INDIRECT($A$1&\"[\"&validate_Source[[#This Row],[title]]&\"]\")))","v":{"$error":"#REF!"}},{"$f":"IF(OR(ISBLANK(validate_Source[[#This Row],[length]]), ISBLANK(validate_Source[[#This Row],[max_length]]),  validate_Source[[#This Row],[max_length]]<validate_Source[[#This Row],[length]]), 0, 1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(AND(validate_Source[[#This Row],[mandatory]]=\"Y\", validate_Source[[#This Row],[blank_rows]]<=$C$1, validate_Source[[#This Row],[blank_rows]]>0), 1, 0)","v":{"$error":"#REF!"}},null,"bore_owner",5,{"$f":"INDEX(BORE_REGISTER[#Headers], validate_Bores[[#This Row],[id]])","v":"Bore Owner"},"Free text",100,"Y",{"$f":"P7 & IF(ISBLANK(Q7), \"\", \" (\" & Q7 &\" characters)\") & IF(ISBLANK(validate_Bores[[#This Row],[mandatory]]), \"\", \"*\")","v":"Free text (100 characters)*"},{"$f":"MAX(LEN(INDIRECT($M$1&\"[\"&validate_Bores[[#This Row],[title]]&\"]\")))","v":0},{"$f":"IF(OR(ISBLANK(validate_Bores[[#This Row],[length]]), ISBLANK(validate_Bores[[#This Row],[max_length]]),  validate_Bores[[#This Row],[max_length]]<validate_Bores[[#This Row],[length]]), 0, 1)","v":0},0,{"$f":"IF(AND(validate_Bores[[#This Row],[mandatory]]=\"Y\", validate_Bores[[#This Row],[blank_rows]]<=$N$1, validate_Bores[[#This Row],[blank_rows]]>0), 1, 0)","v":0}]
["alias_id",6,{"$f":"INDEX(#REF!, validate_Source[[#This Row],[id]])","v":{"$error":"#REF!"}},"Free text",100,"Y",{"$f":"D8 & IF(ISBLANK(E8), \"\", \" (\" & E8 &\" characters)\") & IF(ISBLANK(validate_Source[[#This Row],[mandatory]]), \"\", \"*\")","v":"Free text (100 characters)*"},{"$f":"MAX(LEN(INDIRECT($A$1&\"[\"&validate_Source[[#This Row],[title]]&\"]\")))","v":{"$error":"#REF!"}},{"$f":"IF(OR(ISBLANK(validate_Source[[#This Row],[length]]), ISBLANK(validate_Source[[#This Row],[max_length]]),  validate_Source[[#This Row],[max_length]]<validate_Source[[#This Row],[length]]), 0, 1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(AND(validate_Source[[#This Row],[mandatory]]=\"Y\", validate_Source[[#This Row],[blank_rows]]<=$C$1, validate_Source[[#This Row],[blank_rows]]>0), 1, 0)","v":{"$error":"#REF!"}},null,"bore_status",6,{"$f":"INDEX(BORE_REGISTER[#Headers], validate_Bores[[#This Row],[id]])","v":"Bore Status"},"Dropdown",null,"Y",{"$f":"P8 & IF(ISBLANK(Q8), \"\", \" (\" & Q8 &\" characters)\") & IF(ISBLANK(validate_Bores[[#This Row],[mandatory]]), \"\", \"*\")","v":"Dropdown*"},{"$f":"MAX(LEN(INDIRECT($M$1&\"[\"&validate_Bores[[#This Row],[title]]&\"]\")))","v":0},{"$f":"IF(OR(ISBLANK(validate_Bores[[#This Row],[length]]), ISBLANK(validate_Bores[[#This Row],[max_length]]),  validate_Bores[[#This Row],[max_length]]<validate_Bores[[#This Row],[length]]), 0, 1)","v":0},0,{"$f":"IF(AND(validate_Bores[[#This Row],[mandatory]]=\"Y\", validate_Bores[[#This Row],[blank_rows]]<=$N$1, validate_Bores[[#This Row],[blank_rows]]>0), 1, 0)","v":0}]
["label",7,{"$f":"INDEX(#REF!, validate_Source[[#This Row],[id]])","v":{"$error":"#REF!"}},"Free text",300,"Y",{"$f":"D9 & IF(ISBLANK(E9), \"\", \" (\" & E9 &\" characters)\") & IF(ISBLANK(validate_Source[[#This Row],[mandatory]]), \"\", \"*\")","v":"Free text (300 characters)*"},{"$f":"MAX(LEN(INDIRECT($A$1&\"[\"&validate_Source[[#This Row],[title]]&\"]\")))","v":{"$error":"#REF!"}},{"$f":"IF(OR(ISBLANK(validate_Source[[#This Row],[length]]), ISBLANK(validate_Source[[#This Row],[max_length]]),  validate_Source[[#This Row],[max_length]]<validate_Source[[#This Row],[length]]), 0, 1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(AND(validate_Source[[#This Row],[mandatory]]=\"Y\", validate_Source[[#This Row],[blank_rows]]<=$C$1, validate_Source[[#This Row],[blank_rows]]>0), 1, 0)","v":{"$error":"#REF!"}},null,"license_id",7,{"$f":"INDEX(BORE_REGISTER[#Headers], validate_Bores[[#This Row],[id]])","v":"BCL ID"},"Free text",20,null,{"$f":"P9 & IF(ISBLANK(Q9), \"\", \" (\" & Q9 &\" characters)\") & IF(ISBLANK(validate_Bores[[#This Row],[mandatory]]), \"\", \"*\")","v":"Free text (20 characters)"},{"$f":"MAX(LEN(INDIRECT($M$1&\"[\"&validate_Bores[[#This Row],[title]]&\"]\")))","v":0},{"$f":"IF(OR(ISBLANK(validate_Bores[[#This Row],[length]]), ISBLANK(validate_Bores[[#This Row],[max_length]]),  validate_Bores[[#This Row],[max_length]]<validate_Bores[[#This Row],[length]]), 0, 1)","v":0},0,{"$f":"IF(AND(validate_Bores[[#This Row],[mandatory]]=\"Y\", validate_Bores[[#This Row],[blank_rows]]<=$N$1, validate_Bores[[#This Row],[blank_rows]]>0), 1, 0)","v":0}]
["historical_name",8,{"$f":"INDEX(#REF!, validate_Source[[#This Row],[id]])","v":{"$error":"#REF!"}},"Free text",300,null,{"$f":"D10 & IF(ISBLANK(E10), \"\", \" (\" & E10 &\" characters)\") & IF(ISBLANK(validate_Source[[#This Row],[mandatory]]), \"\", \"*\")","v":"Free text (300 characters)"},{"$f":"MAX(LEN(INDIRECT($A$1&\"[\"&validate_Source[[#This Row],[title]]&\"]\")))","v":{"$error":"#REF!"}},{"$f":"IF(OR(ISBLANK(validate_Source[[#This Row],[length]]), ISBLANK(validate_Source[[#This Row],[max_length]]),  validate_Source[[#This Row],[max_length]]<validate_Source[[#This Row],[length]]), 0, 1)","v":{"$error":"#REF!"}},{"$f":"COUNTBLANK(INDIRECT($A$1&\"[\"&C10&\"]\"))-$E$1","v":{"$error":"#REF!"}},{"$f":"IF(AND(validate_Source[[#This Row],[mandatory]]=\"Y\", validate_Source[[#This Row],[blank_rows]]<=$C$1, validate_Source[[#This Row],[blank_rows]]>0), 1, 0)","v":{"$error":"#REF!"}},null,"headworks",8,{"$f":"INDEX(BORE_REGISTER[#Headers], validate_Bores[[#This Row],[id]])","v":"Headworks"},"Dropdown",null,null,{"$f":"P10 & IF(ISBLANK(Q10), \"\", \" (\" & Q10 &\" characters)\") & IF(ISBLANK(validate_Bores[[#This Row],[mandatory]]), \"\", \"*\")","v":"Dropdown"},{"$f":"MAX(LEN(INDIRECT($M$1&\"[\"&validate_Bores[[#This Row],[title]]&\"]\")))","v":0},{"$f":"IF(OR(ISBLANK(validate_Bores[[#This Row],[length]]), ISBLANK(validate_Bores[[#This Row],[max_length]]),  validate_Bores[[#This Row],[max_length]]<validate_Bores[[#This Row],[length]]), 0, 1)","v":0},0,{"$f":"IF(AND(validate_Bores[[#This Row],[mandatory]]=\"Y\", validate_Bores[[#This Row],[blank_rows]]<=$N$1, validate_Bores[[#This Row],[blank_rows]]>0), 1, 0)","v":0}]
["source_type",9,{"$f":"INDEX(#REF!, validate_Source[[#This Row],[id]])","v":{"$error":"#REF!"}},"Dropdown",null,"Y",{"$f":"D11 & IF(ISBLANK(E11), \"\", \" (\" & E11 &\" characters)\") & IF(ISBLANK(validate_Source[[#This Row],[mandatory]]), \"\", \"*\")","v":"Dropdown*"},{"$f":"MAX(LEN(INDIRECT($A$1&\"[\"&validate_Source[[#This Row],[title]]&\"]\")))","v":{"$error":"#REF!"}},{"$f":"IF(OR(ISBLANK(validate_Source[[#This Row],[length]]), ISBLANK(validate_Source[[#This Row],[max_length]]),  validate_Source[[#This Row],[max_length]]<validate_Source[[#This Row],[length]]), 0, 1)","v":{"$error":"#REF!"}},{"$f":"COUNTBLANK(INDIRECT($A$1&\"[\"&C11&\"]\"))-$E$1","v":{"$error":"#REF!"}},{"$f":"IF(AND(validate_Source[[#This Row],[mandatory]]=\"Y\", validate_Source[[#This Row],[blank_rows]]<=$C$1, validate_Source[[#This Row],[blank_rows]]>0), 1, 0)","v":{"$error":"#REF!"}},null,"screen_int",9,{"$f":"INDEX(BORE_REGISTER[#Headers], validate_Bores[[#This Row],[id]])","v":"Screen Interval (m bgL)"},"Free text",20,null,{"$f":"P11 & IF(ISBLANK(Q11), \"\", \" (\" & Q11 &\" characters)\") & IF(ISBLANK(validate_Bores[[#This Row],[mandatory]]), \"\", \"*\")","v":"Free text (20 characters)"},{"$f":"MAX(LEN(INDIRECT($M$1&\"[\"&validate_Bores[[#This Row],[title]]&\"]\")))","v":0},{"$f":"IF(OR(ISBLANK(validate_Bores[[#This Row],[length]]), ISBLANK(validate_Bores[[#This Row],[max_length]]),  validate_Bores[[#This Row],[max_length]]<validate_Bores[[#This Row],[length]]), 0, 1)","v":0},0,{"$f":"IF(AND(validate_Bores[[#This Row],[mandatory]]=\"Y\", validate_Bores[[#This Row],[blank_rows]]<=$N$1, validate_Bores[[#This Row],[blank_rows]]>0), 1, 0)","v":0}]
["source_desc",10,{"$f":"INDEX(#REF!, validate_Source[[#This Row],[id]])","v":{"$error":"#REF!"}},"Free text",1000,"Y",{"$f":"D12 & IF(ISBLANK(E12), \"\", \" (\" & E12 &\" characters)\") & IF(ISBLANK(validate_Source[[#This Row],[mandatory]]), \"\", \"*\")","v":"Free text (1000 characters)*"},{"$f":"MAX(LEN(INDIRECT($A$1&\"[\"&validate_Source[[#This Row],[title]]&\"]\")))","v":{"$error":"#REF!"}},{"$f":"IF(OR(ISBLANK(validate_Source[[#This Row],[length]]), ISBLANK(validate_Source[[#This Row],[max_length]]),  validate_Source[[#This Row],[max_length]]<validate_Source[[#This Row],[length]]), 0, 1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(AND(validate_Source[[#This Row],[mandatory]]=\"Y\", validate_Source[[#This Row],[blank_rows]]<=$C$1, validate_Source[[#This Row],[blank_rows]]>0), 1, 0)","v":{"$error":"#REF!"}},null,"installed_year",10,{"$f":"INDEX(BORE_REGISTER[#Headers], validate_Bores[[#This Row],[id]])","v":"Installed Year"},"Free text",20,null,{"$f":"P12 & IF(ISBLANK(Q12), \"\", \" (\" & Q12 &\" characters)\") & IF(ISBLANK(validate_Bores[[#This Row],[mandatory]]), \"\", \"*\")","v":"Free text (20 characters)"},{"$f":"MAX(LEN(INDIRECT($M$1&\"[\"&validate_Bores[[#This Row],[title]]&\"]\")))","v":0},{"$f":"IF(OR(ISBLANK(validate_Bores[[#This Row],[length]]), ISBLANK(validate_Bores[[#This Row],[max_length]]),  validate_Bores[[#This Row],[max_length]]<validate_Bores[[#This Row],[length]]), 0, 1)","v":0},0,{"$f":"IF(AND(validate_Bores[[#This Row],[mandatory]]=\"Y\", validate_Bores[[#This Row],[blank_rows]]<=$N$1, validate_Bores[[#This Row],[blank_rows]]>0), 1, 0)","v":0}]
["source_chem",11,{"$f":"INDEX(#REF!, validate_Source[[#This Row],[id]])","v":{"$error":"#REF!"}},"Free text",1000,null,{"$f":"D13 & IF(ISBLANK(E13), \"\", \" (\" & E13 &\" characters)\") & IF(ISBLANK(validate_Source[[#This Row],[mandatory]]), \"\", \"*\")","v":"Free text (1000 characters)"},{"$f":"MAX(LEN(INDIRECT($A$1&\"[\"&validate_Source[[#This Row],[title]]&\"]\")))","v":{"$error":"#REF!"}},{"$f":"IF(OR(ISBLANK(validate_Source[[#This Row],[length]]), ISBLANK(validate_Source[[#This Row],[max_length]]),  validate_Source[[#This Row],[max_length]]<validate_Source[[#This Row],[length]]), 0, 1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(AND(validate_Source[[#This Row],[mandatory]]=\"Y\", validate_Source[[#This Row],[blank_rows]]<=$C$1, validate_Source[[#This Row],[blank_rows]]>0), 1, 0)","v":{"$error":"#REF!"}},null,"site_desc",11,{"$f":"INDEX(BORE_REGISTER[#Headers], validate_Bores[[#This Row],[id]])","v":"RailMap Site Location"},"Dropdown",null,"Y",{"$f":"P13 & IF(ISBLANK(Q13), \"\", \" (\" & Q13 &\" characters)\") & IF(ISBLANK(validate_Bores[[#This Row],[mandatory]]), \"\", \"*\")","v":"Dropdown*"},{"$f":"MAX(LEN(INDIRECT($M$1&\"[\"&validate_Bores[[#This Row],[title]]&\"]\")))","v":0},{"$f":"IF(OR(ISBLANK(validate_Bores[[#This Row],[length]]), ISBLANK(validate_Bores[[#This Row],[max_length]]),  validate_Bores[[#This Row],[max_length]]<validate_Bores[[#This Row],[length]]), 0, 1)","v":0},0,{"$f":"IF(AND(validate_Bores[[#This Row],[mandatory]]=\"Y\", validate_Bores[[#This Row],[blank_rows]]<=$N$1, validate_Bores[[#This Row],[blank_rows]]>0), 1, 0)","v":0}]
["source_volume",12,{"$f":"INDEX(#REF!, validate_Source[[#This Row],[id]])","v":{"$error":"#REF!"}},"Free text",255,null,{"$f":"D14 & IF(ISBLANK(E14), \"\", \" (\" & E14 &\" characters)\") & IF(ISBLANK(validate_Source[[#This Row],[mandatory]]), \"\", \"*\")","v":"Free text (255 characters)"},{"$f":"MAX(LEN(INDIRECT($A$1&\"[\"&validate_Source[[#This Row],[title]]&\"]\")))","v":{"$error":"#REF!"}},{"$f":"IF(OR(ISBLANK(validate_Source[[#This Row],[length]]), ISBLANK(validate_Source[[#This Row],[max_length]]),  validate_Source[[#This Row],[max_length]]<validate_Source[[#This Row],[length]]), 0, 1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(AND(validate_Source[[#This Row],[mandatory]]=\"Y\", validate_Source[[#This Row],[blank_rows]]<=$C$1, validate_Source[[#This Row],[blank_rows]]>0), 1, 0)","v":{"$error":"#REF!"}},null,"lot_desc",12,{"$f":"INDEX(BORE_REGISTER[#Headers], validate_Bores[[#This Row],[id]])","v":"RailMap Lot ID/RIL"},"Free text",50,null,{"$f":"P14 & IF(ISBLANK(Q14), \"\", \" (\" & Q14 &\" characters)\") & IF(ISBLANK(validate_Bores[[#This Row],[mandatory]]), \"\", \"*\")","v":"Free text (50 characters)"},{"$f":"MAX(LEN(INDIRECT($M$1&\"[\"&validate_Bores[[#This Row],[title]]&\"]\")))","v":0},{"$f":"IF(OR(ISBLANK(validate_Bores[[#This Row],[length]]), ISBLANK(validate_Bores[[#This Row],[max_length]]),  validate_Bores[[#This Row],[max_length]]<validate_Bores[[#This Row],[length]]), 0, 1)","v":0},0,{"$f":"IF(AND(validate_Bores[[#This Row],[mandatory]]=\"Y\", validate_Bores[[#This Row],[blank_rows]]<=$N$1, validate_Bores[[#This Row],[blank_rows]]>0), 1, 0)","v":0}]
["source_risk",13,{"$f":"INDEX(#REF!, validate_Source[[#This Row],[id]])","v":{"$error":"#REF!"}},"Dropdown",null,"Y",{"$f":"D15 & IF(ISBLANK(E15), \"\", \" (\" & E15 &\" characters)\") & IF(ISBLANK(validate_Source[[#This Row],[mandatory]]), \"\", \"*\")","v":"Dropdown*"},{"$f":"MAX(LEN(INDIRECT($A$1&\"[\"&validate_Source[[#This Row],[title]]&\"]\")))","v":{"$error":"#REF!"}},{"$f":"IF(OR(ISBLANK(validate_Source[[#This Row],[length]]), ISBLANK(validate_Source[[#This Row],[max_length]]),  validate_Source[[#This Row],[max_length]]<validate_Source[[#This Row],[length]]), 0, 1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(AND(validate_Source[[#This Row],[mandatory]]=\"Y\", validate_Source[[#This Row],[blank_rows]]<=$C$1, validate_Source[[#This Row],[blank_rows]]>0), 1, 0)","v":{"$error":"#REF!"}},null,"easting",13,{"$f":"INDEX(BORE_REGISTER[#Headers], validate_Bores[[#This Row],[id]])","v":"Eastings "},"Decimal Number",null,"Y",{"$f":"P15 & IF(ISBLANK(Q15), \"\", \" (\" & Q15 &\" characters)\") & IF(ISBLANK(validate_Bores[[#This Row],[mandatory]]), \"\", \"*\")","v":"Decimal Number*"},{"$f":"MAX(LEN(INDIRECT($M$1&\"[\"&validate_Bores[[#This Row],[title]]&\"]\")))","v":0},{"$f":"IF(OR(ISBLANK(validate_Bores[[#This Row],[length]]), ISBLANK(validate_Bores[[#This Row],[max_length]]),  validate_Bores[[#This Row],[max_length]]<validate_Bores[[#This Row],[length]]), 0, 1)","v":0},0,{"$f":"IF(AND(validate_Bores[[#This Row],[mandatory]]=\"Y\", validate_Bores[[#This Row],[blank_rows]]<=$N$1, validate_Bores[[#This Row],[blank_rows]]>0), 1, 0)","v":0},{"$f":"IF(AND(validate_Bores[[#This Row],[blank_rows]]<>$V$22, ISNUMBER(AVERAGE(INDIRECT($M$1&\"[\"&validate_Bores[[#This Row],[title]]&\"]\")))=FALSE), 1, 0)","v":0}]
["source_age",14,{"$f":"INDEX(#REF!, validate_Source[[#This Row],[id]])","v":{"$error":"#REF!"}},"Free text",50,null,{"$f":"D16 & IF(ISBLANK(E16), \"\", \" (\" & E16 &\" characters)\") & IF(ISBLANK(validate_Source[[#This Row],[mandatory]]), \"\", \"*\")","v":"Free text (50 characters)"},{"$f":"MAX(LEN(INDIRECT($A$1&\"[\"&validate_Source[[#This Row],[title]]&\"]\")))","v":{"$error":"#REF!"}},{"$f":"IF(OR(ISBLANK(validate_Source[[#This Row],[length]]), ISBLANK(validate_Source[[#This Row],[max_length]]),  validate_Source[[#This Row],[max_length]]<validate_Source[[#This Row],[length]]), 0, 1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(AND(validate_Source[[#This Row],[mandatory]]=\"Y\", validate_Source[[#This Row],[blank_rows]]<=$C$1, validate_Source[[#This Row],[blank_rows]]>0), 1, 0)","v":{"$error":"#REF!"}},null,"northing",14,{"$f":"INDEX(BORE_REGISTER[#Headers], validate_Bores[[#This Row],[id]])","v":"Northings"},"Decimal Number",null,"Y",{"$f":"P16 & IF(ISBLANK(Q16), \"\", \" (\" & Q16 &\" characters)\") & IF(ISBLANK(validate_Bores[[#This Row],[mandatory]]), \"\", \"*\")","v":"Decimal Number*"},{"$f":"MAX(LEN(INDIRECT($M$1&\"[\"&validate_Bores[[#This Row],[title]]&\"]\")))","v":0},{"$f":"IF(OR(ISBLANK(validate_Bores[[#This Row],[length]]), ISBLANK(validate_Bores[[#This Row],[max_length]]),  validate_Bores[[#This Row],[max_length]]<validate_Bores[[#This Row],[length]]), 0, 1)","v":0},0,{"$f":"IF(AND(validate_Bores[[#This Row],[mandatory]]=\"Y\", validate_Bores[[#This Row],[blank_rows]]<=$N$1, validate_Bores[[#This Row],[blank_rows]]>0), 1, 0)","v":0},{"$f":"IF(AND(validate_Bores[[#This Row],[blank_rows]]<>$V$22, ISNUMBER(AVERAGE(INDIRECT($M$1&\"[\"&validate_Bores[[#This Row],[title]]&\"]\")))=FALSE), 1, 0)","v":0}]
["source_status",15,{"$f":"INDEX(#REF!, validate_Source[[#This Row],[id]])","v":{"$error":"#REF!"}},"Dropdown",null,null,{"$f":"D17 & IF(ISBLANK(E17), \"\", \" (\" & E17 &\" characters)\") & IF(ISBLANK(validate_Source[[#This Row],[mandatory]]), \"\", \"*\")","v":"Dropdown"},{"$f":"MAX(LEN(INDIRECT($A$1&\"[\"&validate_Source[[#This Row],[title]]&\"]\")))","v":{"$error":"#REF!"}},{"$f":"IF(OR(ISBLANK(validate_Source[[#This Row],[length]]), ISBLANK(validate_Source[[#This Row],[max_length]]),  validate_Source[[#This Row],[max_length]]<validate_Source[[#This Row],[length]]), 0, 1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(AND(validate_Source[[#This Row],[mandatory]]=\"Y\", validate_Source[[#This Row],[blank_rows]]<=$C$1, validate_Source[[#This Row],[blank_rows]]>0), 1, 0)","v":{"$error":"#REF!"}},null,"coordinate_system",15,{"$f":"INDEX(BORE_REGISTER[#Headers], validate_Bores[[#This Row],[id]])","v":"Coordinate System"},"Dropdown",null,"Y",{"$f":"P17 & IF(ISBLANK(Q17), \"\", \" (\" & Q17 &\" characters)\") & IF(ISBLANK(validate_Bores[[#This Row],[mandatory]]), \"\", \"*\")","v":"Dropdown*"},{"$f":"MAX(LEN(INDIRECT($M$1&\"[\"&validate_Bores[[#This Row],[title]]&\"]\")))","v":0},{"$f":"IF(OR(ISBLANK(validate_Bores[[#This Row],[length]]), ISBLANK(validate_Bores[[#This Row],[max_length]]),  validate_Bores[[#This Row],[max_length]]<validate_Bores[[#This Row],[length]]), 0, 1)","v":0},0,{"$f":"IF(AND(validate_Bores[[#This Row],[mandatory]]=\"Y\", validate_Bores[[#This Row],[blank_rows]]<=$N$1, validate_Bores[[#This Row],[blank_rows]]>0), 1, 0)","v":0}]
["source_responsibility",16,{"$f":"INDEX(#REF!, validate_Source[[#This Row],[id]])","v":{"$error":"#REF!"}},"Dropdown",null,null,{"$f":"D18 & IF(ISBLANK(E18), \"\", \" (\" & E18 &\" characters)\") & IF(ISBLANK(validate_Source[[#This Row],[mandatory]]), \"\", \"*\")","v":"Dropdown"},{"$f":"MAX(LEN(INDIRECT($A$1&\"[\"&validate_Source[[#This Row],[title]]&\"]\")))","v":{"$error":"#REF!"}},{"$f":"IF(OR(ISBLANK(validate_Source[[#This Row],[length]]), ISBLANK(validate_Source[[#This Row],[max_length]]),  validate_Source[[#This Row],[max_length]]<validate_Source[[#This Row],[length]]), 0, 1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(AND(validate_Source[[#This Row],[mandatory]]=\"Y\", validate_Source[[#This Row],[blank_rows]]<=$C$1, validate_Source[[#This Row],[blank_rows]]>0), 1, 0)","v":{"$error":"#REF!"}},null,"TOC",16,{"$f":"INDEX(BORE_REGISTER[#Headers], validate_Bores[[#This Row],[id]])","v":"TOC"},"Decimal Number",null,"Y",{"$f":"P18 & IF(ISBLANK(Q18), \"\", \" (\" & Q18 &\" characters)\") & IF(ISBLANK(validate_Bores[[#This Row],[mandatory]]), \"\", \"*\")","v":"Decimal Number*"},{"$f":"MAX(LEN(INDIRECT($M$1&\"[\"&validate_Bores[[#This Row],[title]]&\"]\")))","v":0},{"$f":"IF(OR(ISBLANK(validate_Bores[[#This Row],[length]]), ISBLANK(validate_Bores[[#This Row],[max_length]]),  validate_Bores[[#This Row],[max_length]]<validate_Bores[[#This Row],[length]]), 0, 1)","v":0},0,{"$f":"IF(AND(validate_Bores[[#This Row],[mandatory]]=\"Y\", validate_Bores[[#This Row],[blank_rows]]<=$N$1, validate_Bores[[#This Row],[blank_rows]]>0), 1, 0)","v":0},{"$f":"IF(AND(validate_Bores[[#This Row],[blank_rows]]<>$V$22, ISNUMBER(AVERAGE(INDIRECT($M$1&\"[\"&validate_Bores[[#This Row],[title]]&\"]\")))=FALSE), 1, 0)","v":0}]
["source_owner",17,{"$f":"INDEX(#REF!, validate_Source[[#This Row],[id]])","v":{"$error":"#REF!"}},"Free text",1000,null,{"$f":"D19 & IF(ISBLANK(E19), \"\", \" (\" & E19 &\" characters)\") & IF(ISBLANK(validate_Source[[#This Row],[mandatory]]), \"\", \"*\")","v":"Free text (1000 characters)"},{"$f":"MAX(LEN(INDIRECT($A$1&\"[\"&validate_Source[[#This Row],[title]]&\"]\")))","v":{"$error":"#REF!"}},{"$f":"IF(OR(ISBLANK(validate_Source[[#This Row],[length]]), ISBLANK(validate_Source[[#This Row],[max_length]]),  validate_Source[[#This Row],[max_length]]<validate_Source[[#This Row],[length]]), 0, 1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(AND(validate_Source[[#This Row],[mandatory]]=\"Y\", validate_Source[[#This Row],[blank_rows]]<=$C$1, validate_Source[[#This Row],[blank_rows]]>0), 1, 0)","v":{"$error":"#REF!"}},null,"ground_level",17,{"$f":"INDEX(BORE_REGISTER[#Headers], validate_Bores[[#This Row],[id]])","v":"Ground Level"},"Decimal Number",null,null,{"$f":"P19 & IF(ISBLANK(Q19), \"\", \" (\" & Q19 &\" characters)\") & IF(ISBLANK(validate_Bores[[#This Row],[mandatory]]), \"\", \"*\")","v":"Decimal Number"},{"$f":"MAX(LEN(INDIRECT($M$1&\"[\"&validate_Bores[[#This Row],[title]]&\"]\")))","v":0},{"$f":"IF(OR(ISBLANK(validate_Bores[[#This Row],[length]]), ISBLANK(validate_Bores[[#This Row],[max_length]]),  validate_Bores[[#This Row],[max_length]]<validate_Bores[[#This Row],[length]]), 0, 1)","v":0},0,{"$f":"IF(AND(validate_Bores[[#This Row],[mandatory]]=\"Y\", validate_Bores[[#This Row],[blank_rows]]<=$N$1, validate_Bores[[#This Row],[blank_rows]]>0), 1, 0)","v":0},{"$f":"IF(AND(validate_Bores[[#This Row],[blank_rows]]<>$V$22, ISNUMBER(AVERAGE(INDIRECT($M$1&\"[\"&validate_Bores[[#This Row],[title]]&\"]\")))=FALSE), 1, 0)","v":0}]
["source_accuracy",18,{"$f":"INDEX(#REF!, validate_Source[[#This Row],[id]])","v":{"$error":"#REF!"}},"Dropdown",null,null,{"$f":"D20 & IF(ISBLANK(E20), \"\", \" (\" & E20 &\" characters)\") & IF(ISBLANK(validate_Source[[#This Row],[mandatory]]), \"\", \"*\")","v":"Dropdown"},{"$f":"MAX(LEN(INDIRECT($A$1&\"[\"&validate_Source[[#This Row],[title]]&\"]\")))","v":{"$error":"#REF!"}},{"$f":"IF(OR(ISBLANK(validate_Source[[#This Row],[length]]), ISBLANK(validate_Source[[#This Row],[max_length]]),  validate_Source[[#This Row],[max_length]]<validate_Source[[#This Row],[length]]), 0, 1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(AND(validate_Source[[#This Row],[mandatory]]=\"Y\", validate_Source[[#This Row],[blank_rows]]<=$C$1, validate_Source[[#This Row],[blank_rows]]>0), 1, 0)","v":{"$error":"#REF!"}},null,"top_of_gatic",18,{"$f":"INDEX(BORE_REGISTER[#Headers], validate_Bores[[#This Row],[id]])","v":"Top of gatic"},"Decimal Number",null,null,{"$f":"P20 & IF(ISBLANK(Q20), \"\", \" (\" & Q20 &\" characters)\") & IF(ISBLANK(validate_Bores[[#This Row],[mandatory]]), \"\", \"*\")","v":"Decimal Number"},{"$f":"MAX(LEN(INDIRECT($M$1&\"[\"&validate_Bores[[#This Row],[title]]&\"]\")))","v":0},{"$f":"IF(OR(ISBLANK(validate_Bores[[#This Row],[length]]), ISBLANK(validate_Bores[[#This Row],[max_length]]),  validate_Bores[[#This Row],[max_length]]<validate_Bores[[#This Row],[length]]), 0, 1)","v":0},0,{"$f":"IF(AND(validate_Bores[[#This Row],[mandatory]]=\"Y\", validate_Bores[[#This Row],[blank_rows]]<=$N$1, validate_Bores[[#This Row],[blank_rows]]>0), 1, 0)","v":0},{"$f":"IF(AND(validate_Bores[[#This Row],[blank_rows]]<>$V$22, ISNUMBER(AVERAGE(INDIRECT($M$1&\"[\"&validate_Bores[[#This Row],[title]]&\"]\")))=FALSE), 1, 0)","v":0}]
["source_comments",19,{"$f":"INDEX(#REF!, validate_Source[[#This Row],[id]])","v":{"$error":"#REF!"}},"Free text",1000,null,{"$f":"D21 & IF(ISBLANK(E21), \"\", \" (\" & E21 &\" characters)\") & IF(ISBLANK(validate_Source[[#This Row],[mandatory]]), \"\", \"*\")","v":"Free text (1000 characters)"},{"$f":"MAX(LEN(INDIRECT($A$1&\"[\"&validate_Source[[#This Row],[title]]&\"]\")))","v":{"$error":"#REF!"}},{"$f":"IF(OR(ISBLANK(validate_Source[[#This Row],[length]]), ISBLANK(validate_Source[[#This Row],[max_length]]),  validate_Source[[#This Row],[max_length]]<validate_Source[[#This Row],[length]]), 0, 1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(AND(validate_Source[[#This Row],[mandatory]]=\"Y\", validate_Source[[#This Row],[blank_rows]]<=$C$1, validate_Source[[#This Row],[blank_rows]]>0), 1, 0)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,{"$f":"SUM(validate_Bores[check_length])","v":0},{"$f":"SUM(validate_Bores[blank_rows]/ROWS(validate_Bores[blank_rows]))","v":0},{"$f":"SUM(validate_Bores[mandatory_check])","v":0},{"$f":"SUM(validate_Bores[number fields with text])","v":0}]
["source_other",20,{"$f":"INDEX(#REF!, validate_Source[[#This Row],[id]])","v":{"$error":"#REF!"}},"Free text",1000,null,{"$f":"D22 & IF(ISBLANK(E22), \"\", \" (\" & E22 &\" characters)\") & IF(ISBLANK(validate_Source[[#This Row],[mandatory]]), \"\", \"*\")","v":"Free text (1000 characters)"},{"$f":"MAX(LEN(INDIRECT($A$1&\"[\"&validate_Source[[#This Row],[title]]&\"]\")))","v":{"$error":"#REF!"}},{"$f":"IF(OR(ISBLANK(validate_Source[[#This Row],[length]]), ISBLANK(validate_Source[[#This Row],[max_length]]),  validate_Source[[#This Row],[max_length]]<validate_Source[[#This Row],[length]]), 0, 1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(AND(validate_Source[[#This Row],[mandatory]]=\"Y\", validate_Source[[#This Row],[blank_rows]]<=$C$1, validate_Source[[#This Row],[blank_rows]]>0), 1, 0)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,"char limit exceeds",{"$f":"MAX(validate_Bores[blank_rows])","v":0},"mandatory missing"]
[null,null,null,null,null,null,null,null,{"$f":"SUM(validate_Source[check_length])","v":{"$error":"#REF!"}},{"$f":"SUM(validate_Source[blank_rows]/ROWS(validate_Source[blank_rows]))","v":{"$error":"#REF!"}},{"$f":"SUM(validate_Source[mandatory_check])","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,"char limit exceeds",{"$f":"MAX(validate_Source[blank_rows])","v":{"$error":"#REF!"}},"mandatory missing"]
["DRAT","Row count"]
["Answer Needed",{"$f":"COUNTIF(#REF!, A26)","v":{"$error":"#REF!"}}]
["Answer Detail Needed",{"$f":"COUNTIF(#REF!, A27)","v":{"$error":"#REF!"}}]
["Wrong Answer Format",{"$f":"COUNTIF(#REF!, A28)","v":{"$error":"#REF!"}}]
["Wrong Answer Selected",{"$f":"COUNTIF(#REF!, A29)","v":{"$error":"#REF!"}}]
[null,{"$f":"SUM(B26:B29)","v":{"$error":"#REF!"}},null,{"$f":"IF(drat_invalid>0, \"Check DRAT Validation\", \"Validation OK\")","v":{"$error":"#REF!"}}]
[]
[]
[]
["ACTIONS_REGISTER",null,{"$f":"ROWS(INDIRECT(A34))-E34","v":{"$error":"#REF!"}},"total rows (minus blank)",{"$f":"COUNTIFS(INDIRECT($A$34&\"[\"&C36&\"]\"), \"=\", INDIRECT($A$34&\"[\"&C37&\"]\"), \"=\", INDIRECT($A$34&\"[\"&C38&\"]\"), \"=\", INDIRECT($A$34&\"[\"&C39&\"]\"), \"=\", INDIRECT($A$34&\"[\"&C40&\"]\"), \"=\", INDIRECT($A$34&\"[\"&C41&\"]\"), \"=\", INDIRECT($A$34&\"[\"&C42&\"]\"), \"=\", INDIRECT($A$34&\"[\"&C43&\"]\"), \"=\", INDIRECT($A$34&\"[\"&C44&\"]\"), \"=\", INDIRECT($A$34&\"[\"&C45&\"]\"), \"=\")","v":{"$error":"#REF!"}},"blank rows",null,null,{"$f":"IF(action_blank=action_total, \"No Actions in Register\", IF(action_missing>0, \"Missing Mandatory Data\", IF(action_exceed>0, \"Text is too long\", \"Validation OK\")))","v":{"$error":"#REF!"}}]
["field_name","id","title","type","length","mandatory","description","max_length","check_length","blank_rows","mandatory_check"]
["record_type",1,"Is this an ammendment to an existing Action?","Dropdown",null,"Y",{"$f":"D36 & IF(ISBLANK(E36), \"\", \" (\" & E36 &\" characters)\") & IF(ISBLANK(validate_Actions[[#This Row],[mandatory]]), \"\", \"*\")","v":"Dropdown*"},{"$f":"MAX(LEN(INDIRECT($A$34&\"[\"&validate_Actions[[#This Row],[title]]&\"]\")))","v":{"$error":"#REF!"}},{"$f":"IF(OR(ISBLANK(validate_Actions[[#This Row],[length]]), ISBLANK(validate_Actions[[#This Row],[max_length]]),  validate_Actions[[#This Row],[max_length]]<validate_Actions[[#This Row],[length]]), 0, 1)","v":{"$error":"#REF!"}},{"$f":"COUNTBLANK(INDIRECT($A$34&\"[\"&C36&\"]\"))-$E$34","v":{"$error":"#REF!"}},{"$f":"IF(AND(validate_Actions[[#This Row],[mandatory]]=\"Y\", validate_Actions[[#This Row],[blank_rows]]<=$C$1, validate_Actions[[#This Row],[blank_rows]]>0), 1, 0)","v":{"$error":"#REF!"}}]
["action_id",2,"CHAMP Action ID (IF THE ACTION IS AN AMMENDMENT)","Whole Number",null,null,{"$f":"D37 & IF(ISBLANK(E37), \"\", \" (\" & E37 &\" characters)\") & IF(ISBLANK(validate_Actions[[#This Row],[mandatory]]), \"\", \"*\")","v":"Whole Number"},{"$f":"MAX(LEN(INDIRECT($A$34&\"[\"&validate_Actions[[#This Row],[title]]&\"]\")))","v":{"$error":"#REF!"}},{"$f":"IF(OR(ISBLANK(validate_Actions[[#This Row],[length]]), ISBLANK(validate_Actions[[#This Row],[max_length]]),  validate_Actions[[#This Row],[max_length]]<validate_Actions[[#This Row],[length]]), 0, 1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(AND(validate_Actions[[#This Row],[mandatory]]=\"Y\", validate_Actions[[#This Row],[blank_rows]]<=$C$1, validate_Actions[[#This Row],[blank_rows]]>0), 1, 0)","v":{"$error":"#REF!"}}]
["site_desc",3,"RailMap Site Location","Dropdown",null,"Y",{"$f":"D38 & IF(ISBLANK(E38), \"\", \" (\" & E38 &\" characters)\") & IF(ISBLANK(validate_Actions[[#This Row],[mandatory]]), \"\", \"*\")","v":"Dropdown*"},{"$f":"MAX(LEN(INDIRECT($A$34&\"[\"&validate_Actions[[#This Row],[title]]&\"]\")))","v":{"$error":"#REF!"}},{"$f":"IF(OR(ISBLANK(validate_Actions[[#This Row],[length]]), ISBLANK(validate_Actions[[#This Row],[max_length]]),  validate_Actions[[#This Row],[max_length]]<validate_Actions[[#This Row],[length]]), 0, 1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(AND(validate_Actions[[#This Row],[mandatory]]=\"Y\", validate_Actions[[#This Row],[blank_rows]]<=$C$1, validate_Actions[[#This Row],[blank_rows]]>0), 1, 0)","v":{"$error":"#REF!"}}]
["pa_owner",4,"Action Owner","Dropdown",null,"Y",{"$f":"D39 & IF(ISBLANK(E39), \"\", \" (\" & E39 &\" characters)\") & IF(ISBLANK(validate_Actions[[#This Row],[mandatory]]), \"\", \"*\")","v":"Dropdown*"},{"$f":"MAX(LEN(INDIRECT($A$34&\"[\"&validate_Actions[[#This Row],[title]]&\"]\")))","v":{"$error":"#REF!"}},{"$f":"IF(OR(ISBLANK(validate_Actions[[#This Row],[length]]), ISBLANK(validate_Actions[[#This Row],[max_length]]),  validate_Actions[[#This Row],[max_length]]<validate_Actions[[#This Row],[length]]), 0, 1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(AND(validate_Actions[[#This Row],[mandatory]]=\"Y\", validate_Actions[[#This Row],[blank_rows]]<=$C$1, validate_Actions[[#This Row],[blank_rows]]>0), 1, 0)","v":{"$error":"#REF!"}}]
["pa_desc",5,"Action Description","Free text",1000,"Y",{"$f":"D40 & IF(ISBLANK(E40), \"\", \" (\" & E40 &\" characters)\") & IF(ISBLANK(validate_Actions[[#This Row],[mandatory]]), \"\", \"*\")","v":"Free text (1000 characters)*"},{"$f":"MAX(LEN(INDIRECT($A$34&\"[\"&validate_Actions[[#This Row],[title]]&\"]\")))","v":{"$error":"#REF!"}},{"$f":"IF(OR(ISBLANK(validate_Actions[[#This Row],[length]]), ISBLANK(validate_Actions[[#This Row],[max_length]]),  validate_Actions[[#This Row],[max_length]]<validate_Actions[[#This Row],[length]]), 0, 1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(AND(validate_Actions[[#This Row],[mandatory]]=\"Y\", validate_Actions[[#This Row],[blank_rows]]<=$C$1, validate_Actions[[#This Row],[blank_rows]]>0), 1, 0)","v":{"$error":"#REF!"}}]
["pa_comments",6,"Action Comments","Free text",1000,"Y",{"$f":"D41 & IF(ISBLANK(E41), \"\", \" (\" & E41 &\" characters)\") & IF(ISBLANK(validate_Actions[[#This Row],[mandatory]]), \"\", \"*\")","v":"Free text (1000 characters)*"},{"$f":"MAX(LEN(INDIRECT($A$34&\"[\"&validate_Actions[[#This Row],[title]]&\"]\")))","v":{"$error":"#REF!"}},{"$f":"IF(OR(ISBLANK(validate_Actions[[#This Row],[length]]), ISBLANK(validate_Actions[[#This Row],[max_length]]),  validate_Actions[[#This Row],[max_length]]<validate_Actions[[#This Row],[length]]), 0, 1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(AND(validate_Actions[[#This Row],[mandatory]]=\"Y\", validate_Actions[[#This Row],[blank_rows]]<=$C$1, validate_Actions[[#This Row],[blank_rows]]>0), 1, 0)","v":{"$error":"#REF!"}}]
["pa_date",7,"Action Date (dd/mm/yyyy)","Date",null,"Y",{"$f":"D42 & IF(ISBLANK(E42), \"\", \" (\" & E42 &\" characters)\") & IF(ISBLANK(validate_Actions[[#This Row],[mandatory]]), \"\", \"*\")","v":"Date*"},{"$f":"MAX(LEN(INDIRECT($A$34&\"[\"&validate_Actions[[#This Row],[title]]&\"]\")))","v":{"$error":"#REF!"}},{"$f":"IF(OR(ISBLANK(validate_Actions[[#This Row],[length]]), ISBLANK(validate_Actions[[#This Row],[max_length]]),  validate_Actions[[#This Row],[max_length]]<validate_Actions[[#This Row],[length]]), 0, 1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(AND(validate_Actions[[#This Row],[mandatory]]=\"Y\", validate_Actions[[#This Row],[blank_rows]]<=$C$1, validate_Actions[[#This Row],[blank_rows]]>0), 1, 0)","v":{"$error":"#REF!"}}]
["pa_duedate",8,"Action Due Date (dd/mm/yyyy)","Date",null,null,{"$f":"D43 & IF(ISBLANK(E43), \"\", \" (\" & E43 &\" characters)\") & IF(ISBLANK(validate_Actions[[#This Row],[mandatory]]), \"\", \"*\")","v":"Date"},{"$f":"MAX(LEN(INDIRECT($A$34&\"[\"&validate_Actions[[#This Row],[title]]&\"]\")))","v":{"$error":"#REF!"}},{"$f":"IF(OR(ISBLANK(validate_Actions[[#This Row],[length]]), ISBLANK(validate_Actions[[#This Row],[max_length]]),  validate_Actions[[#This Row],[max_length]]<validate_Actions[[#This Row],[length]]), 0, 1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(AND(validate_Actions[[#This Row],[mandatory]]=\"Y\", validate_Actions[[#This Row],[blank_rows]]<=$C$1, validate_Actions[[#This Row],[blank_rows]]>0), 1, 0)","v":{"$error":"#REF!"}}]
["pa_status",9,"Action Status","Dropdown",null,"Y",{"$f":"D44 & IF(ISBLANK(E44), \"\", \" (\" & E44 &\" characters)\") & IF(ISBLANK(validate_Actions[[#This Row],[mandatory]]), \"\", \"*\")","v":"Dropdown*"},{"$f":"MAX(LEN(INDIRECT($A$34&\"[\"&validate_Actions[[#This Row],[title]]&\"]\")))","v":{"$error":"#REF!"}},{"$f":"IF(OR(ISBLANK(validate_Actions[[#This Row],[length]]), ISBLANK(validate_Actions[[#This Row],[max_length]]),  validate_Actions[[#This Row],[max_length]]<validate_Actions[[#This Row],[length]]), 0, 1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(AND(validate_Actions[[#This Row],[mandatory]]=\"Y\", validate_Actions[[#This Row],[blank_rows]]<=$C$1, validate_Actions[[#This Row],[blank_rows]]>0), 1, 0)","v":{"$error":"#REF!"}}]
["pa_priority",10,"Action Priority","Dropdown",null,null,{"$f":"D45 & IF(ISBLANK(E45), \"\", \" (\" & E45 &\" characters)\") & IF(ISBLANK(validate_Actions[[#This Row],[mandatory]]), \"\", \"*\")","v":"Dropdown"},{"$f":"MAX(LEN(INDIRECT($A$34&\"[\"&validate_Actions[[#This Row],[title]]&\"]\")))","v":{"$error":"#REF!"}},{"$f":"IF(OR(ISBLANK(validate_Actions[[#This Row],[length]]), ISBLANK(validate_Actions[[#This Row],[max_length]]),  validate_Actions[[#This Row],[max_length]]<validate_Actions[[#This Row],[length]]), 0, 1)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(AND(validate_Actions[[#This Row],[mandatory]]=\"Y\", validate_Actions[[#This Row],[blank_rows]]<=$C$1, validate_Actions[[#This Row],[blank_rows]]>0), 1, 0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,{"$f":"SUM(validate_Actions[check_length])","v":{"$error":"#REF!"}},{"$f":"SUM(validate_Actions[blank_rows]/ROWS(validate_Actions[blank_rows]))","v":{"$error":"#REF!"}},{"$f":"SUM(validate_Actions[mandatory_check])","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,"char limit exceeds",{"$f":"MAX(validate_Source[blank_rows])","v":{"$error":"#REF!"}},"mandatory missing"]