{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Input","Ref","Categories","Output","ExhibitTemplate"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":16,"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":"Input","index":0,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["EXCEL-BASED DATA EXCHANGE"]
["Data Table Creator"]
[]
[null,"Company Name"]
[null,"Program Name"]
[]
[]
[]
[null,"New Table Name"]
[]
[null,"New Table Comments"]
[]
[]
[]
[]
[]
[]
[]
[null,"New Table"]

{"sheet":"Ref","index":1,"n_rows":332,"n_cols":49,"rows_kept":332,"cut":false,"hidden":true,"merged":[]}
["REFERENCE TAB"]
[]
[]
[null,null,null,null,"RefSelProcedure"]
[null,null,null,null,"Procedure Name","Select Start","Select Count","Select Table","Select Tab","Current Rows","Row Start","Row Count","Procedure Start","Procedure End"]
[null,null,null,null,"Add/Remove Records",5,-2,{"$f":"INDEX(RefProcedures[Select Table],MATCH(RefSelProcedure[Procedure Name],RefProcedures[Procedure Name],0))","v":"NewTable"},{"$f":"INDEX(RefProcedures[Select Tab],MATCH(RefSelProcedure[Procedure Name],RefProcedures[Procedure Name],0))","v":"Input"},{"$f":"INDEX(RefProcedures[Current Rows],MATCH(RefSelProcedure[Procedure Name],RefProcedures[Procedure Name],0))","v":1},{"$f":"IF(AND(RefSelProcedure[Select Start]=1,RefSelProcedure[Select Count]+RefSelProcedure[Current Rows]<=0),2,RefSelProcedure[Select Start]+(RefSelProcedure[Select Count]>0))","v":5},{"$f":"MAX(RefSelProcedure[Select Count],RefSelProcedure[Row Start]-RefSelProcedure[Current Rows]-1)","v":3},{"$f":"MATCH(RefSelProcedure[Procedure Name],RefProcedureTables[Procedure Name],0)","v":10},{"$f":"COUNTIF(RefProcedureTables[Procedure Name],RefSelProcedure[Procedure Name])+RefSelProcedure[Procedure Start]-1","v":16}]
[]
[null,null,null,null,"RefProcedures"]
[null,null,null,null,"Count Index","Procedure Name","Select Table","Select Tab","Current Rows"]
[null,null,null,null,{"$f":"ROW()-ROW(RefProcedures[#Headers])","v":1},"Add/Remove Fields","NewFields",{"$f":"MID(CELL(\"filename\",Input!$A$1),FIND(\"]\",CELL(\"filename\",Input!$A$1))+1,100)","v":"Input"},{"$f":"ROWS(Input!tabNewFields)","v":{"$error":"#NAME?"}}]
[null,null,null,null,{"$f":"ROW()-ROW(RefProcedures[#Headers])","v":2},"Add/Remove Records","NewTable",{"$f":"MID(CELL(\"filename\",Input!$A$1),FIND(\"]\",CELL(\"filename\",Input!$A$1))+1,100)","v":"Input"},{"$f":"ROWS(Input!tabNewTable)","v":1}]
[]
[]
[null,null,null,null,"RefProcedureTables"]
[null,null,null,null,"Count Index","Procedure Name","Macro Name","Table Name","Tab Name","Table Type"]
[null,null,null,null,{"$f":"ROW()-ROW(RefProcedureTables[#Headers])","v":1},"Add/Remove Fields","AdjTableRows","RefNewFields",{"$f":"MID(CELL(\"filename\",$A$1),FIND(\"]\",CELL(\"filename\",$A$1))+1,100)","v":"Ref"},"ListObject"]
[null,null,null,null,{"$f":"ROW()-ROW(RefProcedureTables[#Headers])","v":2},"Add/Remove Fields","AdjTableRows","NewFields",{"$f":"MID(CELL(\"filename\",Input!$A$1),FIND(\"]\",CELL(\"filename\",Input!$A$1))+1,100)","v":"Input"},"Excel"]
[null,null,null,null,{"$f":"ROW()-ROW(RefProcedureTables[#Headers])","v":3},"Add/Remove Fields","AdjTableCols","RefNewTable",{"$f":"$I$16","v":"Ref"},"ListObject"]
[null,null,null,null,{"$f":"ROW()-ROW(RefProcedureTables[#Headers])","v":4},"Add/Remove Fields","AdjTableCols","RefCheckCellType","Ref","ListObject"]
[null,null,null,null,{"$f":"ROW()-ROW(RefProcedureTables[#Headers])","v":5},"Add/Remove Fields","AdjTableCols","RefCategoryRef","Ref","ListObject"]
[null,null,null,null,{"$f":"ROW()-ROW(RefProcedureTables[#Headers])","v":6},"Add/Remove Fields","AdjTableCols","RefCheckCategory","Ref","ListObject"]
[null,null,null,null,{"$f":"ROW()-ROW(RefProcedureTables[#Headers])","v":7},"Add/Remove Fields","AdjTableCols","RefCheckNewTable",{"$f":"$I$16","v":"Ref"},"ListObject"]
[null,null,null,null,{"$f":"ROW()-ROW(RefProcedureTables[#Headers])","v":8},"Add/Remove Fields","AdjTableCols","RefNewTableErrors","Ref","ListObject"]
[null,null,null,null,{"$f":"ROW()-ROW(RefProcedureTables[#Headers])","v":9},"Add/Remove Fields","AdjTableCols","NewTable",{"$f":"MID(CELL(\"filename\",Input!$A$1),FIND(\"]\",CELL(\"filename\",Input!$A$1))+1,100)","v":"Input"},"Excel"]
[null,null,null,null,{"$f":"ROW()-ROW(RefProcedureTables[#Headers])","v":10},"Add/Remove Records","AdjTableRows","RefNewTable","Ref","ListObject"]
[null,null,null,null,{"$f":"ROW()-ROW(RefProcedureTables[#Headers])","v":11},"Add/Remove Records","AdjTableRows","RefCheckCellType","Ref","ListObject"]
[null,null,null,null,{"$f":"ROW()-ROW(RefProcedureTables[#Headers])","v":12},"Add/Remove Records","AdjTableRows","RefCategoryRef","Ref","ListObject"]
[null,null,null,null,{"$f":"ROW()-ROW(RefProcedureTables[#Headers])","v":13},"Add/Remove Records","AdjTableRows","RefCheckCategory","Ref","ListObject"]
[null,null,null,null,{"$f":"ROW()-ROW(RefProcedureTables[#Headers])","v":14},"Add/Remove Records","AdjTableRows","RefCheckNewTable",{"$f":"$I$16","v":"Ref"},"ListObject"]
[null,null,null,null,{"$f":"ROW()-ROW(RefProcedureTables[#Headers])","v":15},"Add/Remove Records","AdjTableRows","RefNewTableErrors","Ref","ListObject"]
[null,null,null,null,{"$f":"ROW()-ROW(RefProcedureTables[#Headers])","v":16},"Add/Remove Records","AdjTableRows","NewTable",{"$f":"MID(CELL(\"filename\",Input!$A$1),FIND(\"]\",CELL(\"filename\",Input!$A$1))+1,100)","v":"Input"},"Excel"]
[]
[]
[]
[]
[null,null,null,null,"RefStdFields",null,null,null,"RefDataTypes",null,null,null,null,null,"RefDataCategories",null,null,null,null,null,"RefManualFields",null,null,null,"RefManualTables",null,null,"RefDynamicTables"]
[null,null,null,null,"Count Index","Field Name","Data Type",null,"Count Index","Data Type","Data Format","Header Align","Cell Type",null,"Count Index","Field Name","Reference Table","Reference Field","Category Ref",null,"Count Index","Table Name","Field Name",null,"Count Index","Table Name",null,"Count Index","Table Name"]
[null,null,null,null,{"$f":"ROW()-ROW(RefStdFields[#Headers])","v":1},"Earned Premium","Number",null,{"$f":"ROW()-ROW(RefDataTypes[#Headers])","v":1},"Number","#,##0_);[Red](#,##0)",-4152,"v",null,{"$f":"ROW()-ROW(RefDataCategories[#Headers])","v":1},"ISO GL Category","RefISOGeneralLiab","ISO GL Category",{"$f":"RefDataCategories[[#This Row],[Reference Table]]&\"[\"&RefDataCategories[[#This Row],[Reference Field]]&\"]\"","v":"RefISOGeneralLiab[ISO GL Category]"},null,{"$f":"ROW()-ROW(RefManualFields[#Headers])","v":1},"NewFields","Field Name",null,{"$f":"ROW()-ROW(RefManualTables[#Headers])","v":1},"NewTable",null,{"$f":"ROW()-ROW(RefDynamicTables[#Headers])","v":1},"RefNewTable"]
[null,null,null,null,{"$f":"ROW()-ROW(RefStdFields[#Headers])","v":2},"Written Premium","Number",null,{"$f":"ROW()-ROW(RefDataTypes[#Headers])","v":2},"Date","m/d/yyyy",-4152,"v",null,{"$f":"ROW()-ROW(RefDataCategories[#Headers])","v":2},"ISO AL Category","RefISOAutoLiab","ISO AL Category",{"$f":"RefDataCategories[[#This Row],[Reference Table]]&\"[\"&RefDataCategories[[#This Row],[Reference Field]]&\"]\"","v":"RefISOAutoLiab[ISO AL Category]"},null,{"$f":"ROW()-ROW(RefManualFields[#Headers])","v":2},"NewFields","Data Type",null,null,null,null,{"$f":"ROW()-ROW(RefDynamicTables[#Headers])","v":2},"RefCheckCellType"]
[null,null,null,null,{"$f":"ROW()-ROW(RefStdFields[#Headers])","v":3},"Accident Date","Date",null,{"$f":"ROW()-ROW(RefDataTypes[#Headers])","v":3},"Text","General",1,"l",null,{"$f":"ROW()-ROW(RefDataCategories[#Headers])","v":3},"State / Province Abr","RefLocations","State / Province Abr",{"$f":"RefDataCategories[[#This Row],[Reference Table]]&\"[\"&RefDataCategories[[#This Row],[Reference Field]]&\"]\"","v":"RefLocations[State / Province Abr]"},null,{"$f":"ROW()-ROW(RefManualFields[#Headers])","v":3},null,null,null,null,null,null,{"$f":"ROW()-ROW(RefDynamicTables[#Headers])","v":3},"RefCategoryRef"]
[null,null,null,null,{"$f":"ROW()-ROW(RefStdFields[#Headers])","v":4},"Effective Date","Date",null,{"$f":"ROW()-ROW(RefDataTypes[#Headers])","v":4},"Percent","0.00%",-4152,"v",null,{"$f":"ROW()-ROW(RefDataCategories[#Headers])","v":4},"State / Province Name","RefLocations","State / Province Name",{"$f":"RefDataCategories[[#This Row],[Reference Table]]&\"[\"&RefDataCategories[[#This Row],[Reference Field]]&\"]\"","v":"RefLocations[State / Province Name]"},null,{"$f":"ROW()-ROW(RefManualFields[#Headers])","v":4},null,null,null,null,null,null,{"$f":"ROW()-ROW(RefDynamicTables[#Headers])","v":4},"RefCheckCategory"]
[null,null,null,null,{"$f":"ROW()-ROW(RefStdFields[#Headers])","v":5},"Report Date","Date",null,{"$f":"ROW()-ROW(RefDataTypes[#Headers])","v":5},"One Decimal","#,##0.0_);[Red](#,##0.0)",-4152,"v",null,{"$f":"ROW()-ROW(RefDataCategories[#Headers])","v":5},"Building Type","RefISOBuildingType","Building Type",{"$f":"RefDataCategories[[#This Row],[Reference Table]]&\"[\"&RefDataCategories[[#This Row],[Reference Field]]&\"]\"","v":"RefISOBuildingType[Building Type]"},null,null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefDynamicTables[#Headers])","v":5},"RefCheckNewTable"]
[null,null,null,null,{"$f":"ROW()-ROW(RefStdFields[#Headers])","v":6},"Reported Loss","Number",null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefDataCategories[#Headers])","v":6},"Occupancy","RefISOOccupancyType","Occupancy",{"$f":"RefDataCategories[[#This Row],[Reference Table]]&\"[\"&RefDataCategories[[#This Row],[Reference Field]]&\"]\"","v":"RefISOOccupancyType[Occupancy]"},null,null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefDynamicTables[#Headers])","v":6},"RefNewTableErrors"]
[null,null,null,null,{"$f":"ROW()-ROW(RefStdFields[#Headers])","v":7},"Reported ALAE","Number",null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefDataCategories[#Headers])","v":7},"Hazard Group","RefWCHazardGroup","Hazard Group",{"$f":"RefDataCategories[[#This Row],[Reference Table]]&\"[\"&RefDataCategories[[#This Row],[Reference Field]]&\"]\"","v":"RefWCHazardGroup[Hazard Group]"}]
[null,null,null,null,{"$f":"ROW()-ROW(RefStdFields[#Headers])","v":8},"Paid Loss","Number",null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefDataCategories[#Headers])","v":8},"AS LOB Num","RefASLinesOfBusiness","AS LOB Num",{"$f":"RefDataCategories[[#This Row],[Reference Table]]&\"[\"&RefDataCategories[[#This Row],[Reference Field]]&\"]\"","v":"RefASLinesOfBusiness[AS LOB Num]"}]
[null,null,null,null,{"$f":"ROW()-ROW(RefStdFields[#Headers])","v":9},"Paid ALAE","Number",null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefDataCategories[#Headers])","v":9},"AS LOB Name","RefASLinesOfBusiness","AS LOB Name",{"$f":"RefDataCategories[[#This Row],[Reference Table]]&\"[\"&RefDataCategories[[#This Row],[Reference Field]]&\"]\"","v":"RefASLinesOfBusiness[AS LOB Name]"}]
[null,null,null,null,{"$f":"ROW()-ROW(RefStdFields[#Headers])","v":10},"Loss Reserves","Number"]
[null,null,null,null,{"$f":"ROW()-ROW(RefStdFields[#Headers])","v":11},"ALAE Reserves","Number"]
[null,null,null,null,{"$f":"ROW()-ROW(RefStdFields[#Headers])","v":12},"ISO GL Category","Text"]
[null,null,null,null,{"$f":"ROW()-ROW(RefStdFields[#Headers])","v":13},"ISO AL Category","Text"]
[null,null,null,null,{"$f":"ROW()-ROW(RefStdFields[#Headers])","v":14},"Rate Change","Percent"]
[null,null,null,null,{"$f":"ROW()-ROW(RefStdFields[#Headers])","v":15},"State / Province Abr","Text"]
[null,null,null,null,{"$f":"ROW()-ROW(RefStdFields[#Headers])","v":16},"State / Province Name","Text"]
[null,null,null,null,{"$f":"ROW()-ROW(RefStdFields[#Headers])","v":17},"Building Type","Text"]
[null,null,null,null,{"$f":"ROW()-ROW(RefStdFields[#Headers])","v":18},"Occupancy","Text"]
[null,null,null,null,{"$f":"ROW()-ROW(RefStdFields[#Headers])","v":19},"Hazard Group","Text"]
[null,null,null,null,{"$f":"ROW()-ROW(RefStdFields[#Headers])","v":20},"AS LOB Num","One Decimal"]
[null,null,null,null,{"$f":"ROW()-ROW(RefStdFields[#Headers])","v":21},"AS LOB Name","Text"]
[]
[]
[null,null,null,null,"RefTableInfo"]
[null,null,null,null,"Table Name","Table Description","Current Date","New Table Rows","New Table Fields","Out Tab","Next Start Cell","Table Process Type","Table Name Error","Process Type","Error Exist?","All Errors"]
[null,null,null,null,{"$f":"Input!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(LEN(Input!#REF!)=0,\"\",Input!#REF!)","v":{"$error":"#REF!"}},{"$f":"TODAY()","v":"2013-07-30"},{"$f":"ROWS(RefNewTable[])","v":5},{"$f":"ROWS(RefNewFields[])","v":4},{"$f":"MID(CELL(\"filename\",Output!$A$1),FIND(\"]\",CELL(\"filename\",Output!$A$1))+1,100)","v":"Output"},{"$f":"ADDRESS(INDEX(RefAddedTables[End Row],ROWS(RefAddedTables[]))+4,INDEX(RefAddedTables[Start Column],ROWS(RefAddedTables[])))","v":{"$error":"#REF!"}},"Create Table",{"$f":"OR(I81,I82)","v":false},"Create Table",{"$f":"COUNTIFS(RefErrors[Process Type],RefTableInfo[Process Type],RefErrors[Error Exist?],TRUE)>0","v":false},{"$f":"INDEX(RefErrors[All Errors],MATCH(RefTableInfo[Process Type],RefErrors[Process Type],0)+COUNTIF(RefErrors[Process Type],RefTableInfo[Process Type])-1)","v":""}]
[]
[null,null,null,null,"RefInvalidChars"]
[null,null,null,null,"Count Index","Character Name","Invalid Character","Character Found","Character Message"]
[null,null,null,null,{"$f":"ROW()-ROW(RefInvalidChars[#Headers])","v":1},"Space"," ",{"$f":"NOT(ISERROR(FIND(RefInvalidChars[[#This Row],[Invalid Character]],RefTableInfo[Table Name])))","v":false},{"$f":"IF(RefInvalidChars[[#This Row],[Count Index]]=1,\"\",INDEX(RefInvalidChars[Character Message],RefInvalidChars[[#This Row],[Count Index]]-1))&IF(RefInvalidChars[[#This Row],[Character Found]],\"\n\"&RefInvalidChars[[#This Row],[Character Name]],\"\")","v":""}]
[null,null,null,null,{"$f":"ROW()-ROW(RefInvalidChars[#Headers])","v":2},"Question mark","?",{"$f":"NOT(ISERROR(FIND(RefInvalidChars[[#This Row],[Invalid Character]],RefTableInfo[Table Name])))","v":false},{"$f":"IF(RefInvalidChars[[#This Row],[Count Index]]=1,\"\",INDEX(RefInvalidChars[Character Message],RefInvalidChars[[#This Row],[Count Index]]-1))&IF(RefInvalidChars[[#This Row],[Character Found]],\"\n\"&RefInvalidChars[[#This Row],[Character Name]],\"\")","v":""}]
[null,null,null,null,{"$f":"ROW()-ROW(RefInvalidChars[#Headers])","v":3},"Exclamation point","!",{"$f":"NOT(ISERROR(FIND(RefInvalidChars[[#This Row],[Invalid Character]],RefTableInfo[Table Name])))","v":false},{"$f":"IF(RefInvalidChars[[#This Row],[Count Index]]=1,\"\",INDEX(RefInvalidChars[Character Message],RefInvalidChars[[#This Row],[Count Index]]-1))&IF(RefInvalidChars[[#This Row],[Character Found]],\"\n\"&RefInvalidChars[[#This Row],[Character Name]],\"\")","v":""}]
[null,null,null,null,{"$f":"ROW()-ROW(RefInvalidChars[#Headers])","v":4},"Comma",",",{"$f":"NOT(ISERROR(FIND(RefInvalidChars[[#This Row],[Invalid Character]],RefTableInfo[Table Name])))","v":false},{"$f":"IF(RefInvalidChars[[#This Row],[Count Index]]=1,\"\",INDEX(RefInvalidChars[Character Message],RefInvalidChars[[#This Row],[Count Index]]-1))&IF(RefInvalidChars[[#This Row],[Character Found]],\"\n\"&RefInvalidChars[[#This Row],[Character Name]],\"\")","v":""}]
[null,null,null,null,{"$f":"ROW()-ROW(RefInvalidChars[#Headers])","v":5},"Period",".",{"$f":"NOT(ISERROR(FIND(RefInvalidChars[[#This Row],[Invalid Character]],RefTableInfo[Table Name])))","v":false},{"$f":"IF(RefInvalidChars[[#This Row],[Count Index]]=1,\"\",INDEX(RefInvalidChars[Character Message],RefInvalidChars[[#This Row],[Count Index]]-1))&IF(RefInvalidChars[[#This Row],[Character Found]],\"\n\"&RefInvalidChars[[#This Row],[Character Name]],\"\")","v":""}]
[null,null,null,null,{"$f":"ROW()-ROW(RefInvalidChars[#Headers])","v":6},"Backslash","\\",{"$f":"NOT(ISERROR(FIND(RefInvalidChars[[#This Row],[Invalid Character]],RefTableInfo[Table Name])))","v":false},{"$f":"IF(RefInvalidChars[[#This Row],[Count Index]]=1,\"\",INDEX(RefInvalidChars[Character Message],RefInvalidChars[[#This Row],[Count Index]]-1))&IF(RefInvalidChars[[#This Row],[Character Found]],\"\n\"&RefInvalidChars[[#This Row],[Character Name]],\"\")","v":""}]
[null,null,null,null,{"$f":"ROW()-ROW(RefInvalidChars[#Headers])","v":7},"Quote","'",{"$f":"NOT(ISERROR(FIND(RefInvalidChars[[#This Row],[Invalid Character]],RefTableInfo[Table Name])))","v":false},{"$f":"IF(RefInvalidChars[[#This Row],[Count Index]]=1,\"\",INDEX(RefInvalidChars[Character Message],RefInvalidChars[[#This Row],[Count Index]]-1))&IF(RefInvalidChars[[#This Row],[Character Found]],\"\n\"&RefInvalidChars[[#This Row],[Character Name]],\"\")","v":""}]
[null,null,null,null,{"$f":"ROW()-ROW(RefInvalidChars[#Headers])","v":8},"Double quote","\"",{"$f":"NOT(ISERROR(FIND(RefInvalidChars[[#This Row],[Invalid Character]],RefTableInfo[Table Name])))","v":false},{"$f":"IF(RefInvalidChars[[#This Row],[Count Index]]=1,\"\",INDEX(RefInvalidChars[Character Message],RefInvalidChars[[#This Row],[Count Index]]-1))&IF(RefInvalidChars[[#This Row],[Character Found]],\"\n\"&RefInvalidChars[[#This Row],[Character Name]],\"\")","v":""}]
[]
[null,null,null,null,"RefErrors"]
[null,null,null,null,"Count Index","Process Type","Error Type","Instances","Error Exist?","Error Message","All Errors"]
[null,null,null,null,{"$f":"ROW()-ROW(RefErrors[#Headers])","v":1},"Update Fields","Missing Field Name for following rows",{"$f":"INDEX(RefNewFields[Missing Field Name Message],ROWS(RefNewFields[]))","v":{"$error":"#NAME?"}},{"$f":"LEN(RefErrors[[#This Row],[Instances]])>0","v":{"$error":"#NAME?"}},{"$f":"IF(RefErrors[[#This Row],[Error Exist?]],RefErrors[[#This Row],[Error Type]]&\"\n\"&RefErrors[[#This Row],[Instances]],\"\")","v":{"$error":"#NAME?"}},{"$f":"IF(RefErrors[[#This Row],[Count Index]]=1,\"\",IF(RefErrors[[#This Row],[Process Type]]=INDEX(RefErrors[Process Type],RefErrors[[#This Row],[Count Index]]-1),INDEX(RefErrors[All Errors],RefErrors[[#This Row],[Count Index]]-1),\"\"))&IF(RefErrors[[#This Row],[Error Exist?]],\"\n\"&RefErrors[[#This Row],[Error Message]],\"\")","v":{"$error":"#NAME?"}},null,{"$f":"\"\n\"","v":"\n"}]
[null,null,null,null,{"$f":"ROW()-ROW(RefErrors[#Headers])","v":2},"Update Fields","Repeating Field Names",{"$f":"INDEX(RefNewFields[Repeating Field Name Message],ROWS(RefNewFields[]))","v":{"$error":"#NAME?"}},{"$f":"LEN(RefErrors[[#This Row],[Instances]])>0","v":{"$error":"#NAME?"}},{"$f":"IF(RefErrors[[#This Row],[Error Exist?]],RefErrors[[#This Row],[Error Type]]&\"\n\"&RefErrors[[#This Row],[Instances]],\"\")","v":{"$error":"#NAME?"}},{"$f":"IF(RefErrors[[#This Row],[Count Index]]=1,\"\",IF(RefErrors[[#This Row],[Process Type]]=INDEX(RefErrors[Process Type],RefErrors[[#This Row],[Count Index]]-1),INDEX(RefErrors[All Errors],RefErrors[[#This Row],[Count Index]]-1),\"\"))&IF(RefErrors[[#This Row],[Error Exist?]],\"\n\"&RefErrors[[#This Row],[Error Message]],\"\")","v":{"$error":"#NAME?"}}]
[null,null,null,null,{"$f":"ROW()-ROW(RefErrors[#Headers])","v":3},"Update Fields","Field Names require Data Type",{"$f":"INDEX(RefNewFields[Missing Data Type Message],ROWS(RefNewFields[]))","v":{"$error":"#NAME?"}},{"$f":"LEN(RefErrors[[#This Row],[Instances]])>0","v":{"$error":"#NAME?"}},{"$f":"IF(RefErrors[[#This Row],[Error Exist?]],RefErrors[[#This Row],[Error Type]]&\"\n\"&RefErrors[[#This Row],[Instances]],\"\")","v":{"$error":"#NAME?"}},{"$f":"IF(RefErrors[[#This Row],[Count Index]]=1,\"\",IF(RefErrors[[#This Row],[Process Type]]=INDEX(RefErrors[Process Type],RefErrors[[#This Row],[Count Index]]-1),INDEX(RefErrors[All Errors],RefErrors[[#This Row],[Count Index]]-1),\"\"))&IF(RefErrors[[#This Row],[Error Exist?]],\"\n\"&RefErrors[[#This Row],[Error Message]],\"\")","v":{"$error":"#NAME?"}}]
[null,null,null,null,{"$f":"ROW()-ROW(RefErrors[#Headers])","v":4},"Create Table","Table Name already exists",null,{"$f":"COUNTIF(RefAddedTables[Table Name],RefTableInfo[Table Name])>0","v":false},{"$f":"IF(RefErrors[[#This Row],[Error Exist?]],RefErrors[[#This Row],[Error Type]]&\"\n\"&RefErrors[[#This Row],[Instances]],\"\")","v":""},{"$f":"IF(RefErrors[[#This Row],[Count Index]]=1,\"\",IF(RefErrors[[#This Row],[Process Type]]=INDEX(RefErrors[Process Type],RefErrors[[#This Row],[Count Index]]-1),INDEX(RefErrors[All Errors],RefErrors[[#This Row],[Count Index]]-1),\"\"))&IF(RefErrors[[#This Row],[Error Exist?]],\"\n\"&RefErrors[[#This Row],[Error Message]],\"\")","v":""}]
[null,null,null,null,{"$f":"ROW()-ROW(RefErrors[#Headers])","v":5},"Create Table","Table Name inclues invalid characters",{"$f":"INDEX(RefInvalidChars[Character Message],ROWS(RefInvalidChars[]))","v":""},{"$f":"COUNTIF(RefInvalidChars[Character Found],TRUE)>0","v":false},{"$f":"IF(RefErrors[[#This Row],[Error Exist?]],RefErrors[[#This Row],[Error Type]]&\"\n\"&RefErrors[[#This Row],[Instances]],\"\")","v":""},{"$f":"IF(RefErrors[[#This Row],[Count Index]]=1,\"\",IF(RefErrors[[#This Row],[Process Type]]=INDEX(RefErrors[Process Type],RefErrors[[#This Row],[Count Index]]-1),INDEX(RefErrors[All Errors],RefErrors[[#This Row],[Count Index]]-1),\"\"))&IF(RefErrors[[#This Row],[Error Exist?]],\"\n\"&RefErrors[[#This Row],[Error Message]],\"\")","v":""}]
[null,null,null,null,{"$f":"ROW()-ROW(RefErrors[#Headers])","v":6},"Create Table","Entries in the following Table Fields are invalid",{"$f":"INDEX(RefNewFields[Entry Error Messages],ROWS(RefNewFields[]))","v":""},{"$f":"COUNTIF(RefNewFields[Any Entry Errors?],TRUE)>0","v":false},{"$f":"IF(RefErrors[[#This Row],[Error Exist?]],RefErrors[[#This Row],[Error Type]]&\"\n\"&RefErrors[[#This Row],[Instances]],\"\")","v":""},{"$f":"IF(RefErrors[[#This Row],[Count Index]]=1,\"\",IF(RefErrors[[#This Row],[Process Type]]=INDEX(RefErrors[Process Type],RefErrors[[#This Row],[Count Index]]-1),INDEX(RefErrors[All Errors],RefErrors[[#This Row],[Count Index]]-1),\"\"))&IF(RefErrors[[#This Row],[Error Exist?]],\"\n\"&RefErrors[[#This Row],[Error Message]],\"\")","v":""}]
[]
[]
[null,null,null,null,"RefConditionalFields"]
[null,null,null,null,"Count Index","Target Table","Target Tab","Target Field","Ref Table","RefField","Conditional Format Type","Condition Ref (Excel 2010)","Condition Ref","Font Style","Interior Pattern","Interior Color","Font Color","Theme Color"]
[null,null,null,null,{"$f":"ROW()-ROW(RefConditionalFields[#Headers])","v":1},"NewFields",{"$f":"$I$17","v":"Input"},"Field Name","RefNewFields","Field Name Check","Red Field",{"$f":"\"='\"&$I$16&\"'!\"&ADDRESS(ROW(INDIRECT(RefConditionalFields[[#This Row],[Ref Table]])),COLUMN(INDIRECT(RefConditionalFields[[#This Row],[Ref Table]]&\"[[#Headers],[\"&RefConditionalFields[[#This Row],[RefField]]&\"]]\")),4)","v":"='Ref'!K110"},{"$f":"\"=INDEX(INDIRECT(\"\"\"&RefConditionalFields[[#This Row],[Ref Table]]&\"[\"&RefConditionalFields[[#This Row],[RefField]]&\"]\"\"),ROW()-ROW(hdrNewFields))\"","v":"=INDEX(INDIRECT(\"RefNewFields[Field Name Check]\"),ROW()-ROW(hdrNewFields))"},{"$f":"INDEX(RefConditionalFormats[Font Style],MATCH(RefConditionalFields[[#This Row],[Conditional Format Type]],RefConditionalFormats[Conditional Format Type],0))","v":"Bold"},{"$f":"INDEX(RefConditionalFormats[Interior Pattern],MATCH(RefConditionalFields[[#This Row],[Conditional Format Type]],RefConditionalFormats[Conditional Format Type],0))","v":1},{"$f":"INDEX(RefConditionalFormats[Interior Color],MATCH(RefConditionalFields[[#This Row],[Conditional Format Type]],RefConditionalFormats[Conditional Format Type],0))","v":255},{"$f":"INDEX(RefConditionalFormats[Font Color],MATCH(RefConditionalFields[[#This Row],[Conditional Format Type]],RefConditionalFormats[Conditional Format Type],0))","v":0},{"$f":"INDEX(RefConditionalFormats[Theme Color],MATCH(RefConditionalFields[[#This Row],[Conditional Format Type]],RefConditionalFormats[Conditional Format Type],0))","v":0}]
[null,null,null,null,{"$f":"ROW()-ROW(RefConditionalFields[#Headers])","v":2},"NewFields","Input","Data Type","RefNewFields","Standard Field?","Blank Field",{"$f":"\"='\"&$I$16&\"'!\"&ADDRESS(ROW(INDIRECT(RefConditionalFields[[#This Row],[Ref Table]])),COLUMN(INDIRECT(RefConditionalFields[[#This Row],[Ref Table]]&\"[[#Headers],[\"&RefConditionalFields[[#This Row],[RefField]]&\"]]\")),4)","v":"='Ref'!N110"},{"$f":"\"=INDEX(INDIRECT(\"\"\"&RefConditionalFields[[#This Row],[Ref Table]]&\"[\"&RefConditionalFields[[#This Row],[RefField]]&\"]\"\"),ROW()-ROW(hdrNewFields))\"","v":"=INDEX(INDIRECT(\"RefNewFields[Standard Field?]\"),ROW()-ROW(hdrNewFields))"},{"$f":"INDEX(RefConditionalFormats[Font Style],MATCH(RefConditionalFields[[#This Row],[Conditional Format Type]],RefConditionalFormats[Conditional Format Type],0))","v":"Regular"},{"$f":"INDEX(RefConditionalFormats[Interior Pattern],MATCH(RefConditionalFields[[#This Row],[Conditional Format Type]],RefConditionalFormats[Conditional Format Type],0))","v":-4142},{"$f":"INDEX(RefConditionalFormats[Interior Color],MATCH(RefConditionalFields[[#This Row],[Conditional Format Type]],RefConditionalFormats[Conditional Format Type],0))","v":0},{"$f":"INDEX(RefConditionalFormats[Font Color],MATCH(RefConditionalFields[[#This Row],[Conditional Format Type]],RefConditionalFormats[Conditional Format Type],0))","v":0},{"$f":"INDEX(RefConditionalFormats[Theme Color],MATCH(RefConditionalFields[[#This Row],[Conditional Format Type]],RefConditionalFormats[Conditional Format Type],0))","v":1}]
[null,null,null,null,{"$f":"ROW()-ROW(RefConditionalFields[#Headers])","v":3},"NewFields",{"$f":"$I$17","v":"Input"},"Data Type","RefNewFields","Missing Data Type?","Red Field",{"$f":"\"='\"&$I$16&\"'!\"&ADDRESS(ROW(INDIRECT(RefConditionalFields[[#This Row],[Ref Table]])),COLUMN(INDIRECT(RefConditionalFields[[#This Row],[Ref Table]]&\"[[#Headers],[\"&RefConditionalFields[[#This Row],[RefField]]&\"]]\")),4)","v":"='Ref'!Q110"},{"$f":"\"=INDEX(INDIRECT(\"\"\"&RefConditionalFields[[#This Row],[Ref Table]]&\"[\"&RefConditionalFields[[#This Row],[RefField]]&\"]\"\"),ROW()-ROW(hdrNewFields))\"","v":"=INDEX(INDIRECT(\"RefNewFields[Missing Data Type?]\"),ROW()-ROW(hdrNewFields))"},{"$f":"INDEX(RefConditionalFormats[Font Style],MATCH(RefConditionalFields[[#This Row],[Conditional Format Type]],RefConditionalFormats[Conditional Format Type],0))","v":"Bold"},{"$f":"INDEX(RefConditionalFormats[Interior Pattern],MATCH(RefConditionalFields[[#This Row],[Conditional Format Type]],RefConditionalFormats[Conditional Format Type],0))","v":1},{"$f":"INDEX(RefConditionalFormats[Interior Color],MATCH(RefConditionalFields[[#This Row],[Conditional Format Type]],RefConditionalFormats[Conditional Format Type],0))","v":255},{"$f":"INDEX(RefConditionalFormats[Font Color],MATCH(RefConditionalFields[[#This Row],[Conditional Format Type]],RefConditionalFormats[Conditional Format Type],0))","v":0},{"$f":"INDEX(RefConditionalFormats[Theme Color],MATCH(RefConditionalFields[[#This Row],[Conditional Format Type]],RefConditionalFormats[Conditional Format Type],0))","v":0}]
[null,null,null,null,{"$f":"ROW()-ROW(RefConditionalFields[#Headers])","v":4},"NewFields","Input","Field Status","RefNewFields","Needs Updating?","Red Text",{"$f":"\"='\"&$I$16&\"'!\"&ADDRESS(ROW(INDIRECT(RefConditionalFields[[#This Row],[Ref Table]])),COLUMN(INDIRECT(RefConditionalFields[[#This Row],[Ref Table]]&\"[[#Headers],[\"&RefConditionalFields[[#This Row],[RefField]]&\"]]\")),4)","v":"='Ref'!Y110"},{"$f":"\"=INDEX(INDIRECT(\"\"\"&RefConditionalFields[[#This Row],[Ref Table]]&\"[\"&RefConditionalFields[[#This Row],[RefField]]&\"]\"\"),ROW()-ROW(hdrNewFields))\"","v":"=INDEX(INDIRECT(\"RefNewFields[Needs Updating?]\"),ROW()-ROW(hdrNewFields))"},{"$f":"INDEX(RefConditionalFormats[Font Style],MATCH(RefConditionalFields[[#This Row],[Conditional Format Type]],RefConditionalFormats[Conditional Format Type],0))","v":"Bold"},{"$f":"INDEX(RefConditionalFormats[Interior Pattern],MATCH(RefConditionalFields[[#This Row],[Conditional Format Type]],RefConditionalFormats[Conditional Format Type],0))","v":-4142},{"$f":"INDEX(RefConditionalFormats[Interior Color],MATCH(RefConditionalFields[[#This Row],[Conditional Format Type]],RefConditionalFormats[Conditional Format Type],0))","v":0},{"$f":"INDEX(RefConditionalFormats[Font Color],MATCH(RefConditionalFields[[#This Row],[Conditional Format Type]],RefConditionalFormats[Conditional Format Type],0))","v":255},{"$f":"INDEX(RefConditionalFormats[Theme Color],MATCH(RefConditionalFields[[#This Row],[Conditional Format Type]],RefConditionalFormats[Conditional Format Type],0))","v":0}]
[]
[]
[null,null,null,null,"RefConditionalFormats"]
[null,null,null,null,"Count Index","Conditional Format Type","Font Style","Interior Pattern","Interior Color","Font Color","Theme Color"]
[null,null,null,null,{"$f":"ROW()-ROW(RefConditionalFormats[#Headers])","v":1},"Red Field","Bold",1,255]
[null,null,null,null,{"$f":"ROW()-ROW(RefConditionalFormats[#Headers])","v":2},"Blank Field","Regular",-4142,null,null,1]
[null,null,null,null,{"$f":"ROW()-ROW(RefConditionalFormats[#Headers])","v":3},"Red Text","Bold",-4142,null,255]
[]
[]
[null,null,null,null,"RefAddedTables"]
[null,null,null,null,"Count Index","Table Name","Table Description","Table Rows","Start Row","End Row","Start Column"]
[null,null,null,null,{"$f":"ROW()-ROW(RefAddedTables[#Headers])","v":1},"Tab123","D1",{"$f":"ROWS(INDIRECT(\"Output!tab\"&RefAddedTables[[#This Row],[Table Name]]))","v":{"$error":"#REF!"}},{"$f":"ROW(INDIRECT(\"Output!tab\"&RefAddedTables[[#This Row],[Table Name]]))","v":{"$error":"#REF!"}},{"$f":"RefAddedTables[[#This Row],[Start Row]]+RefAddedTables[[#This Row],[Table Rows]]-1","v":{"$error":"#REF!"}},{"$f":"COLUMN(INDIRECT(\"Output!tab\"&RefAddedTables[[#This Row],[Table Name]]))","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"ROW()-ROW(RefAddedTables[#Headers])","v":2},"TestTable","Desc 123",{"$f":"ROWS(INDIRECT(\"Output!tab\"&RefAddedTables[[#This Row],[Table Name]]))","v":{"$error":"#REF!"}},{"$f":"ROW(INDIRECT(\"Output!tab\"&RefAddedTables[[#This Row],[Table Name]]))","v":{"$error":"#REF!"}},{"$f":"RefAddedTables[[#This Row],[Start Row]]+RefAddedTables[[#This Row],[Table Rows]]-1","v":{"$error":"#REF!"}},{"$f":"COLUMN(INDIRECT(\"Output!tab\"&RefAddedTables[[#This Row],[Table Name]]))","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"ROW()-ROW(RefAddedTables[#Headers])","v":3},"TestTable123","Description TEST",{"$f":"ROWS(INDIRECT(\"Output!tab\"&RefAddedTables[[#This Row],[Table Name]]))","v":{"$error":"#REF!"}},{"$f":"ROW(INDIRECT(\"Output!tab\"&RefAddedTables[[#This Row],[Table Name]]))","v":{"$error":"#REF!"}},{"$f":"RefAddedTables[[#This Row],[Start Row]]+RefAddedTables[[#This Row],[Table Rows]]-1","v":{"$error":"#REF!"}},{"$f":"COLUMN(INDIRECT(\"Output!tab\"&RefAddedTables[[#This Row],[Table Name]]))","v":{"$error":"#REF!"}}]
[]
[]
[null,null,null,null,"RefNewFields"]
[null,null,null,null,"Count Index","New Field Name","Missing Field Name?","Missing Field Name Message","Repeating Field Name? ","Repeating Field Name Message","Field Name Check","Field Name","Selected Data Type","Standard Field?","Indicated Data Type","Data Type","Missing Data Type?","Missing Data Type Message","Data Format","Header Align","Cell Type","Data Category?","Category Ref","Category Ref Formula","Needs Updating?","Update Message","Conditional Format Type","Condition Ref (Excel 2010)","Condition Ref","Font Style","Interior Pattern","Interior Color","Font Color","Theme Color","Any Entry Errors?","Entry Error Instances","Entry Error Messages"]
[null,null,null,null,{"$f":"ROW()-ROW(RefNewFields[#Headers])","v":1},{"$f":"INDEX(Input!tabNewFields,RefNewFields[[#This Row],[Count Index]],MATCH(RefNewFields[[#Headers],[Field Name]],Input!hdrNewFields,0))","v":{"$error":"#NAME?"}},{"$f":"RefNewFields[[#This Row],[New Field Name]]=0","v":{"$error":"#NAME?"}},{"$f":"IF(RefNewFields[[#This Row],[Count Index]]=1,\"\",INDEX(RefNewFields[Missing Field Name Message],RefNewFields[[#This Row],[Count Index]]-1))&IF(RefNewFields[[#This Row],[Missing Field Name?]],\"\n\"&RefNewFields[[#This Row],[Count Index]],\"\")","v":{"$error":"#NAME?"}},{"$f":"COUNTIF(RefNewFields[New Field Name],RefNewFields[[#This Row],[New Field Name]])>1","v":true},{"$f":"IF(RefNewFields[[#This Row],[Count Index]]=1,\"\",INDEX(RefNewFields[Repeating Field Name Message],RefNewFields[[#This Row],[Count Index]]-1))&IF(RefNewFields[[#This Row],[Repeating Field Name? ]],\"\n\"&RefNewFields[[#This Row],[New Field Name]],\"\")","v":{"$error":"#NAME?"}},{"$f":"OR(RefNewFields[[#This Row],[Missing Field Name?]],RefNewFields[[#This Row],[Repeating Field Name? ]])","v":{"$error":"#NAME?"}},"Written Premium",{"$f":"INDEX(Input!tabNewFields,RefNewFields[[#This Row],[Count Index]],MATCH(RefNewFields[[#Headers],[Data Type]],Input!hdrNewFields,0))","v":{"$error":"#NAME?"}},{"$f":"COUNTIF(RefStdFields[Field Name],RefNewFields[[#This Row],[New Field Name]])>0","v":false},{"$f":"IF(RefNewFields[[#This Row],[Standard Field?]],INDEX(RefStdFields[Data Type],MATCH(RefNewFields[[#This Row],[New Field Name]],RefStdFields[Field Name],0)),RefNewFields[[#This Row],[Selected Data Type]])","v":{"$error":"#NAME?"}},"Number",{"$f":"RefNewFields[[#This Row],[Indicated Data Type]]=0","v":{"$error":"#NAME?"}},{"$f":"IF(RefNewFields[[#This Row],[Count Index]]=1,\"\",INDEX(RefNewFields[Missing Data Type Message],RefNewFields[[#This Row],[Count Index]]-1))&IF(RefNewFields[[#This Row],[Missing Data Type?]],\"\n\"&RefNewFields[[#This Row],[New Field Name]],\"\")","v":{"$error":"#NAME?"}},{"$f":"INDEX(RefDataTypes[Data Format],MATCH(RefNewFields[[#This Row],[Indicated Data Type]],RefDataTypes[Data Type],0))","v":{"$error":"#NAME?"}},{"$f":"INDEX(RefDataTypes[Header Align],MATCH(RefNewFields[[#This Row],[Indicated Data Type]],RefDataTypes[Data Type],0))","v":{"$error":"#NAME?"}},{"$f":"INDEX(RefDataTypes[Cell Type],MATCH(RefNewFields[[#This Row],[Data Type]],RefDataTypes[Data Type],0))","v":"v"},{"$f":"COUNTIF(RefDataCategories[Field Name],RefNewFields[[#This Row],[Field Name]])>0","v":false},{"$f":"IF(RefNewFields[[#This Row],[Data Category?]],INDEX(RefDataCategories[Category Ref],MATCH(RefNewFields[[#This Row],[Field Name]],RefDataCategories[Field Name],0)),\"\")","v":""},{"$f":"IF(RefNewFields[[#This Row],[Data Category?]],\"=INDIRECT(\"\"\"&RefNewFields[[#This Row],[Category Ref]]&\"\"\")\",\"\")","v":""},{"$f":"OR(RefNewFields[[#This Row],[New Field Name]]=0,NOT(AND(RefNewFields[[#This Row],[New Field Name]]=RefNewFields[[#This Row],[Field Name]],RefNewFields[[#This Row],[Indicated Data Type]]=RefNewFields[[#This Row],[Data Type]])))","v":{"$error":"#NAME?"}},{"$f":"IF(RefNewFields[[#This Row],[Needs Updating?]],\"Needs to be updated\",\"OK\")","v":{"$error":"#NAME?"}},{"$f":"\"Red Field\"","v":"Red Field"},null,{"$f":"\"=INDEX(INDIRECT(\"\"RefCheckNewTable[\"&RefNewFields[[#This Row],[Field Name]]&\"]\"\"),ROW()-ROW(hdrNewTable))\"","v":"=INDEX(INDIRECT(\"RefCheckNewTable[Written Premium]\"),ROW()-ROW(hdrNewTable))"},{"$f":"INDEX(RefConditionalFormats[Font Style],MATCH(RefNewFields[[#This Row],[Conditional Format Type]],RefConditionalFormats[Conditional Format Type],0))","v":"Bold"},{"$f":"INDEX(RefConditionalFormats[Interior Pattern],MATCH(RefNewFields[[#This Row],[Conditional Format Type]],RefConditionalFormats[Conditional Format Type],0))","v":1},{"$f":"INDEX(RefConditionalFormats[Interior Color],MATCH(RefNewFields[[#This Row],[Conditional Format Type]],RefConditionalFormats[Conditional Format Type],0))","v":255},{"$f":"INDEX(RefConditionalFormats[Font Color],MATCH(RefNewFields[[#This Row],[Conditional Format Type]],RefConditionalFormats[Conditional Format Type],0))","v":0},{"$f":"INDEX(RefConditionalFormats[Theme Color],MATCH(RefNewFields[[#This Row],[Conditional Format Type]],RefConditionalFormats[Conditional Format Type],0))","v":0},{"$f":"COUNTIF(INDIRECT(\"RefCheckNewTable[\"&RefNewFields[[#This Row],[Field Name]]&\"]\"),TRUE)>0","v":false},{"$f":"INDEX(INDIRECT(\"RefNewTableErrors[\"&RefNewFields[[#This Row],[Field Name]]&\"]\"),ROWS(RefNewTableErrors[]))","v":{"$error":"#N/A"}},{"$f":"IF(RefNewFields[[#This Row],[Count Index]]=1,\"\",INDEX(RefNewFields[Entry Error Messages],RefNewFields[[#This Row],[Count Index]]-1))&IF(RefNewFields[[#This Row],[Any Entry Errors?]],\"\n\n\"&RefNewFields[[#This Row],[Field Name]]&RefNewFields[[#This Row],[Entry Error Instances]],\"\")","v":""}]
[null,null,null,null,{"$f":"ROW()-ROW(RefNewFields[#Headers])","v":2},{"$f":"INDEX(Input!tabNewFields,RefNewFields[[#This Row],[Count Index]],MATCH(RefNewFields[[#Headers],[Field Name]],Input!hdrNewFields,0))","v":{"$error":"#NAME?"}},{"$f":"RefNewFields[[#This Row],[New Field Name]]=0","v":{"$error":"#NAME?"}},{"$f":"IF(RefNewFields[[#This Row],[Count Index]]=1,\"\",INDEX(RefNewFields[Missing Field Name Message],RefNewFields[[#This Row],[Count Index]]-1))&IF(RefNewFields[[#This Row],[Missing Field Name?]],\"\n\"&RefNewFields[[#This Row],[Count Index]],\"\")","v":{"$error":"#NAME?"}},{"$f":"COUNTIF(RefNewFields[New Field Name],RefNewFields[[#This Row],[New Field Name]])>1","v":true},{"$f":"IF(RefNewFields[[#This Row],[Count Index]]=1,\"\",INDEX(RefNewFields[Repeating Field Name Message],RefNewFields[[#This Row],[Count Index]]-1))&IF(RefNewFields[[#This Row],[Repeating Field Name? ]],\"\n\"&RefNewFields[[#This Row],[New Field Name]],\"\")","v":{"$error":"#NAME?"}},{"$f":"OR(RefNewFields[[#This Row],[Missing Field Name?]],RefNewFields[[#This Row],[Repeating Field Name? ]])","v":{"$error":"#NAME?"}},"Accident Date",{"$f":"INDEX(Input!tabNewFields,RefNewFields[[#This Row],[Count Index]],MATCH(RefNewFields[[#Headers],[Data Type]],Input!hdrNewFields,0))","v":{"$error":"#NAME?"}},{"$f":"COUNTIF(RefStdFields[Field Name],RefNewFields[[#This Row],[New Field Name]])>0","v":false},{"$f":"IF(RefNewFields[[#This Row],[Standard Field?]],INDEX(RefStdFields[Data Type],MATCH(RefNewFields[[#This Row],[New Field Name]],RefStdFields[Field Name],0)),RefNewFields[[#This Row],[Selected Data Type]])","v":{"$error":"#NAME?"}},"Date",{"$f":"RefNewFields[[#This Row],[Indicated Data Type]]=0","v":{"$error":"#NAME?"}},{"$f":"IF(RefNewFields[[#This Row],[Count Index]]=1,\"\",INDEX(RefNewFields[Missing Data Type Message],RefNewFields[[#This Row],[Count Index]]-1))&IF(RefNewFields[[#This Row],[Missing Data Type?]],\"\n\"&RefNewFields[[#This Row],[New Field Name]],\"\")","v":{"$error":"#NAME?"}},{"$f":"INDEX(RefDataTypes[Data Format],MATCH(RefNewFields[[#This Row],[Indicated Data Type]],RefDataTypes[Data Type],0))","v":{"$error":"#NAME?"}},{"$f":"INDEX(RefDataTypes[Header Align],MATCH(RefNewFields[[#This Row],[Indicated Data Type]],RefDataTypes[Data Type],0))","v":{"$error":"#NAME?"}},{"$f":"INDEX(RefDataTypes[Cell Type],MATCH(RefNewFields[[#This Row],[Data Type]],RefDataTypes[Data Type],0))","v":"v"},{"$f":"COUNTIF(RefDataCategories[Field Name],RefNewFields[[#This Row],[Field Name]])>0","v":false},{"$f":"IF(RefNewFields[[#This Row],[Data Category?]],INDEX(RefDataCategories[Category Ref],MATCH(RefNewFields[[#This Row],[Field Name]],RefDataCategories[Field Name],0)),\"\")","v":""},{"$f":"IF(RefNewFields[[#This Row],[Data Category?]],\"=INDIRECT(\"\"\"&RefNewFields[[#This Row],[Category Ref]]&\"\"\")\",\"\")","v":""},{"$f":"OR(RefNewFields[[#This Row],[New Field Name]]=0,NOT(AND(RefNewFields[[#This Row],[New Field Name]]=RefNewFields[[#This Row],[Field Name]],RefNewFields[[#This Row],[Indicated Data Type]]=RefNewFields[[#This Row],[Data Type]])))","v":{"$error":"#NAME?"}},{"$f":"IF(RefNewFields[[#This Row],[Needs Updating?]],\"Needs to be updated\",\"OK\")","v":{"$error":"#NAME?"}},{"$f":"\"Red Field\"","v":"Red Field"},{"$f":"\"=INDEX(INDIRECT(\"\"RefCheckNewTable[\"&RefNewFields[[#This Row],[Field Name]]&\"]\"\"),ROW()-ROW(hdrNewFields))\"","v":"=INDEX(INDIRECT(\"RefCheckNewTable[Accident Date]\"),ROW()-ROW(hdrNewFields))"},{"$f":"\"=INDEX(INDIRECT(\"\"RefCheckNewTable[\"&RefNewFields[[#This Row],[Field Name]]&\"]\"\"),ROW()-ROW(hdrNewTable))\"","v":"=INDEX(INDIRECT(\"RefCheckNewTable[Accident Date]\"),ROW()-ROW(hdrNewTable))"},{"$f":"INDEX(RefConditionalFormats[Font Style],MATCH(RefNewFields[[#This Row],[Conditional Format Type]],RefConditionalFormats[Conditional Format Type],0))","v":"Bold"},{"$f":"INDEX(RefConditionalFormats[Interior Pattern],MATCH(RefNewFields[[#This Row],[Conditional Format Type]],RefConditionalFormats[Conditional Format Type],0))","v":1},{"$f":"INDEX(RefConditionalFormats[Interior Color],MATCH(RefNewFields[[#This Row],[Conditional Format Type]],RefConditionalFormats[Conditional Format Type],0))","v":255},{"$f":"INDEX(RefConditionalFormats[Font Color],MATCH(RefNewFields[[#This Row],[Conditional Format Type]],RefConditionalFormats[Conditional Format Type],0))","v":0},{"$f":"INDEX(RefConditionalFormats[Theme Color],MATCH(RefNewFields[[#This Row],[Conditional Format Type]],RefConditionalFormats[Conditional Format Type],0))","v":0},{"$f":"COUNTIF(INDIRECT(\"RefCheckNewTable[\"&RefNewFields[[#This Row],[Field Name]]&\"]\"),TRUE)>0","v":false},{"$f":"INDEX(INDIRECT(\"RefNewTableErrors[\"&RefNewFields[[#This Row],[Field Name]]&\"]\"),ROWS(RefNewTableErrors[]))","v":{"$error":"#N/A"}},{"$f":"IF(RefNewFields[[#This Row],[Count Index]]=1,\"\",INDEX(RefNewFields[Entry Error Messages],RefNewFields[[#This Row],[Count Index]]-1))&IF(RefNewFields[[#This Row],[Any Entry Errors?]],\"\n\n\"&RefNewFields[[#This Row],[Field Name]]&RefNewFields[[#This Row],[Entry Error Instances]],\"\")","v":""}]
[null,null,null,null,{"$f":"ROW()-ROW(RefNewFields[#Headers])","v":3},{"$f":"INDEX(Input!tabNewFields,RefNewFields[[#This Row],[Count Index]],MATCH(RefNewFields[[#Headers],[Field Name]],Input!hdrNewFields,0))","v":{"$error":"#NAME?"}},{"$f":"RefNewFields[[#This Row],[New Field Name]]=0","v":{"$error":"#NAME?"}},{"$f":"IF(RefNewFields[[#This Row],[Count Index]]=1,\"\",INDEX(RefNewFields[Missing Field Name Message],RefNewFields[[#This Row],[Count Index]]-1))&IF(RefNewFields[[#This Row],[Missing Field Name?]],\"\n\"&RefNewFields[[#This Row],[Count Index]],\"\")","v":{"$error":"#NAME?"}},{"$f":"COUNTIF(RefNewFields[New Field Name],RefNewFields[[#This Row],[New Field Name]])>1","v":true},{"$f":"IF(RefNewFields[[#This Row],[Count Index]]=1,\"\",INDEX(RefNewFields[Repeating Field Name Message],RefNewFields[[#This Row],[Count Index]]-1))&IF(RefNewFields[[#This Row],[Repeating Field Name? ]],\"\n\"&RefNewFields[[#This Row],[New Field Name]],\"\")","v":{"$error":"#NAME?"}},{"$f":"OR(RefNewFields[[#This Row],[Missing Field Name?]],RefNewFields[[#This Row],[Repeating Field Name? ]])","v":{"$error":"#NAME?"}},"AS LOB Name",{"$f":"INDEX(Input!tabNewFields,RefNewFields[[#This Row],[Count Index]],MATCH(RefNewFields[[#Headers],[Data Type]],Input!hdrNewFields,0))","v":{"$error":"#NAME?"}},{"$f":"COUNTIF(RefStdFields[Field Name],RefNewFields[[#This Row],[New Field Name]])>0","v":false},{"$f":"IF(RefNewFields[[#This Row],[Standard Field?]],INDEX(RefStdFields[Data Type],MATCH(RefNewFields[[#This Row],[New Field Name]],RefStdFields[Field Name],0)),RefNewFields[[#This Row],[Selected Data Type]])","v":{"$error":"#NAME?"}},"Text",{"$f":"RefNewFields[[#This Row],[Indicated Data Type]]=0","v":{"$error":"#NAME?"}},{"$f":"IF(RefNewFields[[#This Row],[Count Index]]=1,\"\",INDEX(RefNewFields[Missing Data Type Message],RefNewFields[[#This Row],[Count Index]]-1))&IF(RefNewFields[[#This Row],[Missing Data Type?]],\"\n\"&RefNewFields[[#This Row],[New Field Name]],\"\")","v":{"$error":"#NAME?"}},{"$f":"INDEX(RefDataTypes[Data Format],MATCH(RefNewFields[[#This Row],[Indicated Data Type]],RefDataTypes[Data Type],0))","v":{"$error":"#NAME?"}},{"$f":"INDEX(RefDataTypes[Header Align],MATCH(RefNewFields[[#This Row],[Indicated Data Type]],RefDataTypes[Data Type],0))","v":{"$error":"#NAME?"}},{"$f":"INDEX(RefDataTypes[Cell Type],MATCH(RefNewFields[[#This Row],[Data Type]],RefDataTypes[Data Type],0))","v":"l"},{"$f":"COUNTIF(RefDataCategories[Field Name],RefNewFields[[#This Row],[Field Name]])>0","v":true},{"$f":"IF(RefNewFields[[#This Row],[Data Category?]],INDEX(RefDataCategories[Category Ref],MATCH(RefNewFields[[#This Row],[Field Name]],RefDataCategories[Field Name],0)),\"\")","v":"RefASLinesOfBusiness[AS LOB Name]"},{"$f":"IF(RefNewFields[[#This Row],[Data Category?]],\"=INDIRECT(\"\"\"&RefNewFields[[#This Row],[Category Ref]]&\"\"\")\",\"\")","v":"=INDIRECT(\"RefASLinesOfBusiness[AS LOB Name]\")"},{"$f":"OR(RefNewFields[[#This Row],[New Field Name]]=0,NOT(AND(RefNewFields[[#This Row],[New Field Name]]=RefNewFields[[#This Row],[Field Name]],RefNewFields[[#This Row],[Indicated Data Type]]=RefNewFields[[#This Row],[Data Type]])))","v":{"$error":"#NAME?"}},{"$f":"IF(RefNewFields[[#This Row],[Needs Updating?]],\"Needs to be updated\",\"OK\")","v":{"$error":"#NAME?"}},"Red Field",{"$f":"\"=INDEX(INDIRECT(\"\"RefCheckNewTable[\"&RefNewFields[[#This Row],[Field Name]]&\"]\"\"),ROW()-ROW(hdrNewFields))\"","v":"=INDEX(INDIRECT(\"RefCheckNewTable[AS LOB Name]\"),ROW()-ROW(hdrNewFields))"},{"$f":"\"=INDEX(INDIRECT(\"\"RefCheckNewTable[\"&RefNewFields[[#This Row],[Field Name]]&\"]\"\"),ROW()-ROW(hdrNewTable))\"","v":"=INDEX(INDIRECT(\"RefCheckNewTable[AS LOB Name]\"),ROW()-ROW(hdrNewTable))"},{"$f":"INDEX(RefConditionalFormats[Font Style],MATCH(RefNewFields[[#This Row],[Conditional Format Type]],RefConditionalFormats[Conditional Format Type],0))","v":"Bold"},{"$f":"INDEX(RefConditionalFormats[Interior Pattern],MATCH(RefNewFields[[#This Row],[Conditional Format Type]],RefConditionalFormats[Conditional Format Type],0))","v":1},{"$f":"INDEX(RefConditionalFormats[Interior Color],MATCH(RefNewFields[[#This Row],[Conditional Format Type]],RefConditionalFormats[Conditional Format Type],0))","v":255},{"$f":"INDEX(RefConditionalFormats[Font Color],MATCH(RefNewFields[[#This Row],[Conditional Format Type]],RefConditionalFormats[Conditional Format Type],0))","v":0},{"$f":"INDEX(RefConditionalFormats[Theme Color],MATCH(RefNewFields[[#This Row],[Conditional Format Type]],RefConditionalFormats[Conditional Format Type],0))","v":0},{"$f":"COUNTIF(INDIRECT(\"RefCheckNewTable[\"&RefNewFields[[#This Row],[Field Name]]&\"]\"),TRUE)>0","v":false},{"$f":"INDEX(INDIRECT(\"RefNewTableErrors[\"&RefNewFields[[#This Row],[Field Name]]&\"]\"),ROWS(RefNewTableErrors[]))","v":{"$error":"#N/A"}},{"$f":"IF(RefNewFields[[#This Row],[Count Index]]=1,\"\",INDEX(RefNewFields[Entry Error Messages],RefNewFields[[#This Row],[Count Index]]-1))&IF(RefNewFields[[#This Row],[Any Entry Errors?]],\"\n\n\"&RefNewFields[[#This Row],[Field Name]]&RefNewFields[[#This Row],[Entry Error Instances]],\"\")","v":""}]
[null,null,null,null,{"$f":"ROW()-ROW(RefNewFields[#Headers])","v":4},{"$f":"INDEX(Input!tabNewFields,RefNewFields[[#This Row],[Count Index]],MATCH(RefNewFields[[#Headers],[Field Name]],Input!hdrNewFields,0))","v":{"$error":"#NAME?"}},{"$f":"RefNewFields[[#This Row],[New Field Name]]=0","v":{"$error":"#NAME?"}},{"$f":"IF(RefNewFields[[#This Row],[Count Index]]=1,\"\",INDEX(RefNewFields[Missing Field Name Message],RefNewFields[[#This Row],[Count Index]]-1))&IF(RefNewFields[[#This Row],[Missing Field Name?]],\"\n\"&RefNewFields[[#This Row],[Count Index]],\"\")","v":{"$error":"#NAME?"}},{"$f":"COUNTIF(RefNewFields[New Field Name],RefNewFields[[#This Row],[New Field Name]])>1","v":true},{"$f":"IF(RefNewFields[[#This Row],[Count Index]]=1,\"\",INDEX(RefNewFields[Repeating Field Name Message],RefNewFields[[#This Row],[Count Index]]-1))&IF(RefNewFields[[#This Row],[Repeating Field Name? ]],\"\n\"&RefNewFields[[#This Row],[New Field Name]],\"\")","v":{"$error":"#NAME?"}},{"$f":"OR(RefNewFields[[#This Row],[Missing Field Name?]],RefNewFields[[#This Row],[Repeating Field Name? ]])","v":{"$error":"#NAME?"}},"MGA",{"$f":"INDEX(Input!tabNewFields,RefNewFields[[#This Row],[Count Index]],MATCH(RefNewFields[[#Headers],[Data Type]],Input!hdrNewFields,0))","v":{"$error":"#NAME?"}},{"$f":"COUNTIF(RefStdFields[Field Name],RefNewFields[[#This Row],[New Field Name]])>0","v":false},{"$f":"IF(RefNewFields[[#This Row],[Standard Field?]],INDEX(RefStdFields[Data Type],MATCH(RefNewFields[[#This Row],[New Field Name]],RefStdFields[Field Name],0)),RefNewFields[[#This Row],[Selected Data Type]])","v":{"$error":"#NAME?"}},"Text",{"$f":"RefNewFields[[#This Row],[Indicated Data Type]]=0","v":{"$error":"#NAME?"}},{"$f":"IF(RefNewFields[[#This Row],[Count Index]]=1,\"\",INDEX(RefNewFields[Missing Data Type Message],RefNewFields[[#This Row],[Count Index]]-1))&IF(RefNewFields[[#This Row],[Missing Data Type?]],\"\n\"&RefNewFields[[#This Row],[New Field Name]],\"\")","v":{"$error":"#NAME?"}},{"$f":"INDEX(RefDataTypes[Data Format],MATCH(RefNewFields[[#This Row],[Indicated Data Type]],RefDataTypes[Data Type],0))","v":{"$error":"#NAME?"}},{"$f":"INDEX(RefDataTypes[Header Align],MATCH(RefNewFields[[#This Row],[Indicated Data Type]],RefDataTypes[Data Type],0))","v":{"$error":"#NAME?"}},{"$f":"INDEX(RefDataTypes[Cell Type],MATCH(RefNewFields[[#This Row],[Data Type]],RefDataTypes[Data Type],0))","v":"l"},{"$f":"COUNTIF(RefDataCategories[Field Name],RefNewFields[[#This Row],[Field Name]])>0","v":false},{"$f":"IF(RefNewFields[[#This Row],[Data Category?]],INDEX(RefDataCategories[Category Ref],MATCH(RefNewFields[[#This Row],[Field Name]],RefDataCategories[Field Name],0)),\"\")","v":""},{"$f":"IF(RefNewFields[[#This Row],[Data Category?]],\"=INDIRECT(\"\"\"&RefNewFields[[#This Row],[Category Ref]]&\"\"\")\",\"\")","v":""},{"$f":"OR(RefNewFields[[#This Row],[New Field Name]]=0,NOT(AND(RefNewFields[[#This Row],[New Field Name]]=RefNewFields[[#This Row],[Field Name]],RefNewFields[[#This Row],[Indicated Data Type]]=RefNewFields[[#This Row],[Data Type]])))","v":{"$error":"#NAME?"}},{"$f":"IF(RefNewFields[[#This Row],[Needs Updating?]],\"Needs to be updated\",\"OK\")","v":{"$error":"#NAME?"}},{"$f":"\"Red Field\"","v":"Red Field"},{"$f":"\"=INDEX(INDIRECT(\"\"RefCheckNewTable[\"&RefNewFields[[#This Row],[Field Name]]&\"]\"\"),ROW()-ROW(hdrNewFields))\"","v":"=INDEX(INDIRECT(\"RefCheckNewTable[MGA]\"),ROW()-ROW(hdrNewFields))"},{"$f":"\"=INDEX(INDIRECT(\"\"RefCheckNewTable[\"&RefNewFields[[#This Row],[Field Name]]&\"]\"\"),ROW()-ROW(hdrNewTable))\"","v":"=INDEX(INDIRECT(\"RefCheckNewTable[MGA]\"),ROW()-ROW(hdrNewTable))"},{"$f":"INDEX(RefConditionalFormats[Font Style],MATCH(RefNewFields[[#This Row],[Conditional Format Type]],RefConditionalFormats[Conditional Format Type],0))","v":"Bold"},{"$f":"INDEX(RefConditionalFormats[Interior Pattern],MATCH(RefNewFields[[#This Row],[Conditional Format Type]],RefConditionalFormats[Conditional Format Type],0))","v":1},{"$f":"INDEX(RefConditionalFormats[Interior Color],MATCH(RefNewFields[[#This Row],[Conditional Format Type]],RefConditionalFormats[Conditional Format Type],0))","v":255},{"$f":"INDEX(RefConditionalFormats[Font Color],MATCH(RefNewFields[[#This Row],[Conditional Format Type]],RefConditionalFormats[Conditional Format Type],0))","v":0},{"$f":"INDEX(RefConditionalFormats[Theme Color],MATCH(RefNewFields[[#This Row],[Conditional Format Type]],RefConditionalFormats[Conditional Format Type],0))","v":0},{"$f":"COUNTIF(INDIRECT(\"RefCheckNewTable[\"&RefNewFields[[#This Row],[Field Name]]&\"]\"),TRUE)>0","v":false},{"$f":"INDEX(INDIRECT(\"RefNewTableErrors[\"&RefNewFields[[#This Row],[Field Name]]&\"]\"),ROWS(RefNewTableErrors[]))","v":{"$error":"#N/A"}},{"$f":"IF(RefNewFields[[#This Row],[Count Index]]=1,\"\",INDEX(RefNewFields[Entry Error Messages],RefNewFields[[#This Row],[Count Index]]-1))&IF(RefNewFields[[#This Row],[Any Entry Errors?]],\"\n\n\"&RefNewFields[[#This Row],[Field Name]]&RefNewFields[[#This Row],[Entry Error Instances]],\"\")","v":""}]
[]
[]
[]
[null,null,null,null,"RefNewTable"]
[null,null,null,null,"Count Index","Written Premium","Accident Date","AS LOB Name","MGA"]
[null,null,null,null,{"$f":"ROW()-ROW(RefNewTable[#Headers])","v":1},{"$f":"IF(LEN(INDEX(Input!tabNewTable,RefNewTable[[#This Row],[Count Index]],MATCH(F$118,Input!hdrNewTable,0)))=0,\"\",INDEX(Input!tabNewTable,RefNewTable[[#This Row],[Count Index]],MATCH(F$118,Input!hdrNewTable,0)))","v":{"$error":"#N/A"}},{"$f":"IF(LEN(INDEX(Input!tabNewTable,RefNewTable[[#This Row],[Count Index]],MATCH(G$118,Input!hdrNewTable,0)))=0,\"\",INDEX(Input!tabNewTable,RefNewTable[[#This Row],[Count Index]],MATCH(G$118,Input!hdrNewTable,0)))","v":{"$error":"#N/A"}},{"$f":"IF(LEN(INDEX(Input!tabNewTable,RefNewTable[[#This Row],[Count Index]],MATCH(H$118,Input!hdrNewTable,0)))=0,\"\",INDEX(Input!tabNewTable,RefNewTable[[#This Row],[Count Index]],MATCH(H$118,Input!hdrNewTable,0)))","v":{"$error":"#N/A"}},{"$f":"IF(LEN(INDEX(Input!tabNewTable,RefNewTable[[#This Row],[Count Index]],MATCH(I$118,Input!hdrNewTable,0)))=0,\"\",INDEX(Input!tabNewTable,RefNewTable[[#This Row],[Count Index]],MATCH(I$118,Input!hdrNewTable,0)))","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"ROW()-ROW(RefNewTable[#Headers])","v":2},{"$f":"IF(LEN(INDEX(Input!tabNewTable,RefNewTable[[#This Row],[Count Index]],MATCH(F$118,Input!hdrNewTable,0)))=0,\"\",INDEX(Input!tabNewTable,RefNewTable[[#This Row],[Count Index]],MATCH(F$118,Input!hdrNewTable,0)))","v":{"$error":"#N/A"}},{"$f":"IF(LEN(INDEX(Input!tabNewTable,RefNewTable[[#This Row],[Count Index]],MATCH(G$118,Input!hdrNewTable,0)))=0,\"\",INDEX(Input!tabNewTable,RefNewTable[[#This Row],[Count Index]],MATCH(G$118,Input!hdrNewTable,0)))","v":{"$error":"#N/A"}},{"$f":"IF(LEN(INDEX(Input!tabNewTable,RefNewTable[[#This Row],[Count Index]],MATCH(H$118,Input!hdrNewTable,0)))=0,\"\",INDEX(Input!tabNewTable,RefNewTable[[#This Row],[Count Index]],MATCH(H$118,Input!hdrNewTable,0)))","v":{"$error":"#N/A"}},{"$f":"IF(LEN(INDEX(Input!tabNewTable,RefNewTable[[#This Row],[Count Index]],MATCH(I$118,Input!hdrNewTable,0)))=0,\"\",INDEX(Input!tabNewTable,RefNewTable[[#This Row],[Count Index]],MATCH(I$118,Input!hdrNewTable,0)))","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"ROW()-ROW(RefNewTable[#Headers])","v":3},{"$f":"IF(LEN(INDEX(Input!tabNewTable,RefNewTable[[#This Row],[Count Index]],MATCH(F$118,Input!hdrNewTable,0)))=0,\"\",INDEX(Input!tabNewTable,RefNewTable[[#This Row],[Count Index]],MATCH(F$118,Input!hdrNewTable,0)))","v":{"$error":"#N/A"}},{"$f":"IF(LEN(INDEX(Input!tabNewTable,RefNewTable[[#This Row],[Count Index]],MATCH(G$118,Input!hdrNewTable,0)))=0,\"\",INDEX(Input!tabNewTable,RefNewTable[[#This Row],[Count Index]],MATCH(G$118,Input!hdrNewTable,0)))","v":{"$error":"#N/A"}},{"$f":"IF(LEN(INDEX(Input!tabNewTable,RefNewTable[[#This Row],[Count Index]],MATCH(H$118,Input!hdrNewTable,0)))=0,\"\",INDEX(Input!tabNewTable,RefNewTable[[#This Row],[Count Index]],MATCH(H$118,Input!hdrNewTable,0)))","v":{"$error":"#N/A"}},{"$f":"IF(LEN(INDEX(Input!tabNewTable,RefNewTable[[#This Row],[Count Index]],MATCH(I$118,Input!hdrNewTable,0)))=0,\"\",INDEX(Input!tabNewTable,RefNewTable[[#This Row],[Count Index]],MATCH(I$118,Input!hdrNewTable,0)))","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"ROW()-ROW(RefNewTable[#Headers])","v":4},{"$f":"IF(LEN(INDEX(Input!tabNewTable,RefNewTable[[#This Row],[Count Index]],MATCH(F$118,Input!hdrNewTable,0)))=0,\"\",INDEX(Input!tabNewTable,RefNewTable[[#This Row],[Count Index]],MATCH(F$118,Input!hdrNewTable,0)))","v":{"$error":"#N/A"}},{"$f":"IF(LEN(INDEX(Input!tabNewTable,RefNewTable[[#This Row],[Count Index]],MATCH(G$118,Input!hdrNewTable,0)))=0,\"\",INDEX(Input!tabNewTable,RefNewTable[[#This Row],[Count Index]],MATCH(G$118,Input!hdrNewTable,0)))","v":{"$error":"#N/A"}},{"$f":"IF(LEN(INDEX(Input!tabNewTable,RefNewTable[[#This Row],[Count Index]],MATCH(H$118,Input!hdrNewTable,0)))=0,\"\",INDEX(Input!tabNewTable,RefNewTable[[#This Row],[Count Index]],MATCH(H$118,Input!hdrNewTable,0)))","v":{"$error":"#N/A"}},{"$f":"IF(LEN(INDEX(Input!tabNewTable,RefNewTable[[#This Row],[Count Index]],MATCH(I$118,Input!hdrNewTable,0)))=0,\"\",INDEX(Input!tabNewTable,RefNewTable[[#This Row],[Count Index]],MATCH(I$118,Input!hdrNewTable,0)))","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"ROW()-ROW(RefNewTable[#Headers])","v":5},{"$f":"IF(LEN(INDEX(Input!tabNewTable,RefNewTable[[#This Row],[Count Index]],MATCH(F$118,Input!hdrNewTable,0)))=0,\"\",INDEX(Input!tabNewTable,RefNewTable[[#This Row],[Count Index]],MATCH(F$118,Input!hdrNewTable,0)))","v":{"$error":"#N/A"}},{"$f":"IF(LEN(INDEX(Input!tabNewTable,RefNewTable[[#This Row],[Count Index]],MATCH(G$118,Input!hdrNewTable,0)))=0,\"\",INDEX(Input!tabNewTable,RefNewTable[[#This Row],[Count Index]],MATCH(G$118,Input!hdrNewTable,0)))","v":{"$error":"#N/A"}},{"$f":"IF(LEN(INDEX(Input!tabNewTable,RefNewTable[[#This Row],[Count Index]],MATCH(H$118,Input!hdrNewTable,0)))=0,\"\",INDEX(Input!tabNewTable,RefNewTable[[#This Row],[Count Index]],MATCH(H$118,Input!hdrNewTable,0)))","v":{"$error":"#N/A"}},{"$f":"IF(LEN(INDEX(Input!tabNewTable,RefNewTable[[#This Row],[Count Index]],MATCH(I$118,Input!hdrNewTable,0)))=0,\"\",INDEX(Input!tabNewTable,RefNewTable[[#This Row],[Count Index]],MATCH(I$118,Input!hdrNewTable,0)))","v":{"$error":"#N/A"}}]
[]
[]
[null,null,null,null,"RefCheckCellType"]
[null,null,null,null,"Count Index","Written Premium","Accident Date","AS LOB Name","MGA"]
[null,null,null,null,{"$f":"ROW()-ROW(RefCheckCellType[#Headers])","v":1},{"$f":"AND(LEN(F119)>0,CELL(\"type\",F119)<>INDEX(RefNewFields[Cell Type],MATCH(F$127,RefNewFields[Field Name],0)))","v":{"$error":"#N/A"}},{"$f":"AND(LEN(G119)>0,CELL(\"type\",G119)<>INDEX(RefNewFields[Cell Type],MATCH(G$127,RefNewFields[Field Name],0)))","v":{"$error":"#N/A"}},{"$f":"AND(LEN(H119)>0,CELL(\"type\",H119)<>INDEX(RefNewFields[Cell Type],MATCH(H$127,RefNewFields[Field Name],0)))","v":{"$error":"#N/A"}},{"$f":"AND(LEN(I119)>0,CELL(\"type\",I119)<>INDEX(RefNewFields[Cell Type],MATCH(I$127,RefNewFields[Field Name],0)))","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"ROW()-ROW(RefCheckCellType[#Headers])","v":2},{"$f":"AND(LEN(F120)>0,CELL(\"type\",F120)<>INDEX(RefNewFields[Cell Type],MATCH(F$127,RefNewFields[Field Name],0)))","v":{"$error":"#N/A"}},{"$f":"AND(LEN(G120)>0,CELL(\"type\",G120)<>INDEX(RefNewFields[Cell Type],MATCH(G$127,RefNewFields[Field Name],0)))","v":{"$error":"#N/A"}},{"$f":"AND(LEN(H120)>0,CELL(\"type\",H120)<>INDEX(RefNewFields[Cell Type],MATCH(H$127,RefNewFields[Field Name],0)))","v":{"$error":"#N/A"}},{"$f":"AND(LEN(I120)>0,CELL(\"type\",I120)<>INDEX(RefNewFields[Cell Type],MATCH(I$127,RefNewFields[Field Name],0)))","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"ROW()-ROW(RefCheckCellType[#Headers])","v":3},{"$f":"AND(LEN(F121)>0,CELL(\"type\",F121)<>INDEX(RefNewFields[Cell Type],MATCH(F$127,RefNewFields[Field Name],0)))","v":{"$error":"#N/A"}},{"$f":"AND(LEN(G121)>0,CELL(\"type\",G121)<>INDEX(RefNewFields[Cell Type],MATCH(G$127,RefNewFields[Field Name],0)))","v":{"$error":"#N/A"}},{"$f":"AND(LEN(H121)>0,CELL(\"type\",H121)<>INDEX(RefNewFields[Cell Type],MATCH(H$127,RefNewFields[Field Name],0)))","v":{"$error":"#N/A"}},{"$f":"AND(LEN(I121)>0,CELL(\"type\",I121)<>INDEX(RefNewFields[Cell Type],MATCH(I$127,RefNewFields[Field Name],0)))","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"ROW()-ROW(RefCheckCellType[#Headers])","v":4},{"$f":"AND(LEN(F122)>0,CELL(\"type\",F122)<>INDEX(RefNewFields[Cell Type],MATCH(F$127,RefNewFields[Field Name],0)))","v":{"$error":"#N/A"}},{"$f":"AND(LEN(G122)>0,CELL(\"type\",G122)<>INDEX(RefNewFields[Cell Type],MATCH(G$127,RefNewFields[Field Name],0)))","v":{"$error":"#N/A"}},{"$f":"AND(LEN(H122)>0,CELL(\"type\",H122)<>INDEX(RefNewFields[Cell Type],MATCH(H$127,RefNewFields[Field Name],0)))","v":{"$error":"#N/A"}},{"$f":"AND(LEN(I122)>0,CELL(\"type\",I122)<>INDEX(RefNewFields[Cell Type],MATCH(I$127,RefNewFields[Field Name],0)))","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"ROW()-ROW(RefCheckCellType[#Headers])","v":5},{"$f":"AND(LEN(F123)>0,CELL(\"type\",F123)<>INDEX(RefNewFields[Cell Type],MATCH(F$127,RefNewFields[Field Name],0)))","v":{"$error":"#N/A"}},{"$f":"AND(LEN(G123)>0,CELL(\"type\",G123)<>INDEX(RefNewFields[Cell Type],MATCH(G$127,RefNewFields[Field Name],0)))","v":{"$error":"#N/A"}},{"$f":"AND(LEN(H123)>0,CELL(\"type\",H123)<>INDEX(RefNewFields[Cell Type],MATCH(H$127,RefNewFields[Field Name],0)))","v":{"$error":"#N/A"}},{"$f":"AND(LEN(I123)>0,CELL(\"type\",I123)<>INDEX(RefNewFields[Cell Type],MATCH(I$127,RefNewFields[Field Name],0)))","v":{"$error":"#N/A"}}]
[]
[]
[null,null,null,null,"RefCategoryRef"]
[null,null,null,null,"Count Index","Written Premium","Accident Date","AS LOB Name","MGA"]
[null,null,null,null,{"$f":"ROW()-ROW(RefCategoryRef[#Headers])","v":1},{"$f":"INDEX(RefNewFields[Category Ref],MATCH(F$136,RefNewFields[Field Name],0))","v":""},{"$f":"INDEX(RefNewFields[Category Ref],MATCH(G$136,RefNewFields[Field Name],0))","v":""},{"$f":"INDEX(RefNewFields[Category Ref],MATCH(H$136,RefNewFields[Field Name],0))","v":"RefASLinesOfBusiness[AS LOB Name]"},{"$f":"INDEX(RefNewFields[Category Ref],MATCH(I$136,RefNewFields[Field Name],0))","v":""}]
[null,null,null,null,{"$f":"ROW()-ROW(RefCategoryRef[#Headers])","v":2},{"$f":"INDEX(RefNewFields[Category Ref],MATCH(F$136,RefNewFields[Field Name],0))","v":""},{"$f":"INDEX(RefNewFields[Category Ref],MATCH(G$136,RefNewFields[Field Name],0))","v":""},{"$f":"INDEX(RefNewFields[Category Ref],MATCH(H$136,RefNewFields[Field Name],0))","v":"RefASLinesOfBusiness[AS LOB Name]"},{"$f":"INDEX(RefNewFields[Category Ref],MATCH(I$136,RefNewFields[Field Name],0))","v":""}]
[null,null,null,null,{"$f":"ROW()-ROW(RefCategoryRef[#Headers])","v":3},{"$f":"INDEX(RefNewFields[Category Ref],MATCH(F$136,RefNewFields[Field Name],0))","v":""},{"$f":"INDEX(RefNewFields[Category Ref],MATCH(G$136,RefNewFields[Field Name],0))","v":""},{"$f":"INDEX(RefNewFields[Category Ref],MATCH(H$136,RefNewFields[Field Name],0))","v":"RefASLinesOfBusiness[AS LOB Name]"},{"$f":"INDEX(RefNewFields[Category Ref],MATCH(I$136,RefNewFields[Field Name],0))","v":""}]
[null,null,null,null,{"$f":"ROW()-ROW(RefCategoryRef[#Headers])","v":4},{"$f":"INDEX(RefNewFields[Category Ref],MATCH(F$136,RefNewFields[Field Name],0))","v":""},{"$f":"INDEX(RefNewFields[Category Ref],MATCH(G$136,RefNewFields[Field Name],0))","v":""},{"$f":"INDEX(RefNewFields[Category Ref],MATCH(H$136,RefNewFields[Field Name],0))","v":"RefASLinesOfBusiness[AS LOB Name]"},{"$f":"INDEX(RefNewFields[Category Ref],MATCH(I$136,RefNewFields[Field Name],0))","v":""}]
[null,null,null,null,{"$f":"ROW()-ROW(RefCategoryRef[#Headers])","v":5},{"$f":"INDEX(RefNewFields[Category Ref],MATCH(F$136,RefNewFields[Field Name],0))","v":""},{"$f":"INDEX(RefNewFields[Category Ref],MATCH(G$136,RefNewFields[Field Name],0))","v":""},{"$f":"INDEX(RefNewFields[Category Ref],MATCH(H$136,RefNewFields[Field Name],0))","v":"RefASLinesOfBusiness[AS LOB Name]"},{"$f":"INDEX(RefNewFields[Category Ref],MATCH(I$136,RefNewFields[Field Name],0))","v":""}]
[]
[]
[null,null,null,null,"RefCheckCategory"]
[null,null,null,null,"Count Index","Written Premium","Accident Date","AS LOB Name","MGA"]
[null,null,null,null,{"$f":"ROW()-ROW(RefCheckCategory[#Headers])","v":1},{"$f":"IF(AND(LEN(F119)>0,LEN(F137)>0),COUNTIF(INDIRECT(F137),F119)=0)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"ROW()-ROW(RefCheckCategory[#Headers])","v":2},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"ROW()-ROW(RefCheckCategory[#Headers])","v":3},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"ROW()-ROW(RefCheckCategory[#Headers])","v":4},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"ROW()-ROW(RefCheckCategory[#Headers])","v":5},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[]
[null,null,null,null,"RefCheckNewTable"]
[null,null,null,null,"Count Index","Written Premium","Accident Date","AS LOB Name","MGA"]
[null,null,null,null,{"$f":"ROW()-ROW(RefCheckNewTable[#Headers])","v":1},{"$f":"OR(F146,F128)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"ROW()-ROW(RefCheckNewTable[#Headers])","v":2},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"ROW()-ROW(RefCheckNewTable[#Headers])","v":3},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"ROW()-ROW(RefCheckNewTable[#Headers])","v":4},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,null,null,{"$f":"ROW()-ROW(RefCheckNewTable[#Headers])","v":5},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[]
[null,null,null,null,"RefNewTableErrors"]
[null,null,null,null,"Count Index","Written Premium","Accident Date","AS LOB Name","MGA"]
[null,null,null,null,{"$f":"ROW()-ROW(RefNewTableErrors[#Headers])","v":1},{"$f":"IF(RefNewTableErrors[[#This Row],[Count Index]]=1,\"\",INDEX(RefNewTableErrors[],RefNewTableErrors[[#This Row],[Count Index]]-1,MATCH(F$163,RefNewTableErrors[#Headers],0)))&IF(F155,\"\n\"&RefNewTableErrors[[#This Row],[Count Index]]&\"     \"&F119,\"\")","v":{"$error":"#N/A"}},{"$f":"IF(RefNewTableErrors[[#This Row],[Count Index]]=1,\"\",INDEX(RefNewTableErrors[],RefNewTableErrors[[#This Row],[Count Index]]-1,MATCH(G$163,RefNewTableErrors[#Headers],0)))&IF(G155,\"\n\"&RefNewTableErrors[[#This Row],[Count Index]]&\"     \"&G119,\"\")","v":{"$error":"#N/A"}},{"$f":"IF(RefNewTableErrors[[#This Row],[Count Index]]=1,\"\",INDEX(RefNewTableErrors[],RefNewTableErrors[[#This Row],[Count Index]]-1,MATCH(H$163,RefNewTableErrors[#Headers],0)))&IF(H155,\"\n\"&RefNewTableErrors[[#This Row],[Count Index]]&\"     \"&H119,\"\")","v":{"$error":"#N/A"}},{"$f":"IF(RefNewTableErrors[[#This Row],[Count Index]]=1,\"\",INDEX(RefNewTableErrors[],RefNewTableErrors[[#This Row],[Count Index]]-1,MATCH(I$163,RefNewTableErrors[#Headers],0)))&IF(I155,\"\n\"&RefNewTableErrors[[#This Row],[Count Index]]&\"     \"&I119,\"\")","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"ROW()-ROW(RefNewTableErrors[#Headers])","v":2},{"$f":"IF(RefNewTableErrors[[#This Row],[Count Index]]=1,\"\",INDEX(RefNewTableErrors[],RefNewTableErrors[[#This Row],[Count Index]]-1,MATCH(F$163,RefNewTableErrors[#Headers],0)))&IF(F156,\"\n\"&RefNewTableErrors[[#This Row],[Count Index]]&\"     \"&F120,\"\")","v":{"$error":"#N/A"}},{"$f":"IF(RefNewTableErrors[[#This Row],[Count Index]]=1,\"\",INDEX(RefNewTableErrors[],RefNewTableErrors[[#This Row],[Count Index]]-1,MATCH(G$163,RefNewTableErrors[#Headers],0)))&IF(G156,\"\n\"&RefNewTableErrors[[#This Row],[Count Index]]&\"     \"&G120,\"\")","v":{"$error":"#N/A"}},{"$f":"IF(RefNewTableErrors[[#This Row],[Count Index]]=1,\"\",INDEX(RefNewTableErrors[],RefNewTableErrors[[#This Row],[Count Index]]-1,MATCH(H$163,RefNewTableErrors[#Headers],0)))&IF(H156,\"\n\"&RefNewTableErrors[[#This Row],[Count Index]]&\"     \"&H120,\"\")","v":{"$error":"#N/A"}},{"$f":"IF(RefNewTableErrors[[#This Row],[Count Index]]=1,\"\",INDEX(RefNewTableErrors[],RefNewTableErrors[[#This Row],[Count Index]]-1,MATCH(I$163,RefNewTableErrors[#Headers],0)))&IF(I156,\"\n\"&RefNewTableErrors[[#This Row],[Count Index]]&\"     \"&I120,\"\")","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"ROW()-ROW(RefNewTableErrors[#Headers])","v":3},{"$f":"IF(RefNewTableErrors[[#This Row],[Count Index]]=1,\"\",INDEX(RefNewTableErrors[],RefNewTableErrors[[#This Row],[Count Index]]-1,MATCH(F$163,RefNewTableErrors[#Headers],0)))&IF(F157,\"\n\"&RefNewTableErrors[[#This Row],[Count Index]]&\"     \"&F121,\"\")","v":{"$error":"#N/A"}},{"$f":"IF(RefNewTableErrors[[#This Row],[Count Index]]=1,\"\",INDEX(RefNewTableErrors[],RefNewTableErrors[[#This Row],[Count Index]]-1,MATCH(G$163,RefNewTableErrors[#Headers],0)))&IF(G157,\"\n\"&RefNewTableErrors[[#This Row],[Count Index]]&\"     \"&G121,\"\")","v":{"$error":"#N/A"}},{"$f":"IF(RefNewTableErrors[[#This Row],[Count Index]]=1,\"\",INDEX(RefNewTableErrors[],RefNewTableErrors[[#This Row],[Count Index]]-1,MATCH(H$163,RefNewTableErrors[#Headers],0)))&IF(H157,\"\n\"&RefNewTableErrors[[#This Row],[Count Index]]&\"     \"&H121,\"\")","v":{"$error":"#N/A"}},{"$f":"IF(RefNewTableErrors[[#This Row],[Count Index]]=1,\"\",INDEX(RefNewTableErrors[],RefNewTableErrors[[#This Row],[Count Index]]-1,MATCH(I$163,RefNewTableErrors[#Headers],0)))&IF(I157,\"\n\"&RefNewTableErrors[[#This Row],[Count Index]]&\"     \"&I121,\"\")","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"ROW()-ROW(RefNewTableErrors[#Headers])","v":4},{"$f":"IF(RefNewTableErrors[[#This Row],[Count Index]]=1,\"\",INDEX(RefNewTableErrors[],RefNewTableErrors[[#This Row],[Count Index]]-1,MATCH(F$163,RefNewTableErrors[#Headers],0)))&IF(F158,\"\n\"&RefNewTableErrors[[#This Row],[Count Index]]&\"     \"&F122,\"\")","v":{"$error":"#N/A"}},{"$f":"IF(RefNewTableErrors[[#This Row],[Count Index]]=1,\"\",INDEX(RefNewTableErrors[],RefNewTableErrors[[#This Row],[Count Index]]-1,MATCH(G$163,RefNewTableErrors[#Headers],0)))&IF(G158,\"\n\"&RefNewTableErrors[[#This Row],[Count Index]]&\"     \"&G122,\"\")","v":{"$error":"#N/A"}},{"$f":"IF(RefNewTableErrors[[#This Row],[Count Index]]=1,\"\",INDEX(RefNewTableErrors[],RefNewTableErrors[[#This Row],[Count Index]]-1,MATCH(H$163,RefNewTableErrors[#Headers],0)))&IF(H158,\"\n\"&RefNewTableErrors[[#This Row],[Count Index]]&\"     \"&H122,\"\")","v":{"$error":"#N/A"}},{"$f":"IF(RefNewTableErrors[[#This Row],[Count Index]]=1,\"\",INDEX(RefNewTableErrors[],RefNewTableErrors[[#This Row],[Count Index]]-1,MATCH(I$163,RefNewTableErrors[#Headers],0)))&IF(I158,\"\n\"&RefNewTableErrors[[#This Row],[Count Index]]&\"     \"&I122,\"\")","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"ROW()-ROW(RefNewTableErrors[#Headers])","v":5},{"$f":"IF(RefNewTableErrors[[#This Row],[Count Index]]=1,\"\",INDEX(RefNewTableErrors[],RefNewTableErrors[[#This Row],[Count Index]]-1,MATCH(F$163,RefNewTableErrors[#Headers],0)))&IF(F159,\"\n\"&RefNewTableErrors[[#This Row],[Count Index]]&\"     \"&F123,\"\")","v":{"$error":"#N/A"}},{"$f":"IF(RefNewTableErrors[[#This Row],[Count Index]]=1,\"\",INDEX(RefNewTableErrors[],RefNewTableErrors[[#This Row],[Count Index]]-1,MATCH(G$163,RefNewTableErrors[#Headers],0)))&IF(G159,\"\n\"&RefNewTableErrors[[#This Row],[Count Index]]&\"     \"&G123,\"\")","v":{"$error":"#N/A"}},{"$f":"IF(RefNewTableErrors[[#This Row],[Count Index]]=1,\"\",INDEX(RefNewTableErrors[],RefNewTableErrors[[#This Row],[Count Index]]-1,MATCH(H$163,RefNewTableErrors[#Headers],0)))&IF(H159,\"\n\"&RefNewTableErrors[[#This Row],[Count Index]]&\"     \"&H123,\"\")","v":{"$error":"#N/A"}},{"$f":"IF(RefNewTableErrors[[#This Row],[Count Index]]=1,\"\",INDEX(RefNewTableErrors[],RefNewTableErrors[[#This Row],[Count Index]]-1,MATCH(I$163,RefNewTableErrors[#Headers],0)))&IF(I159,\"\n\"&RefNewTableErrors[[#This Row],[Count Index]]&\"     \"&I123,\"\")","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[]
[null,null,null,null,"RefListObjects"]
[null,null,null,null,"Table Name","Current Rows","Target Rows","Rows Adjust","Current Columns","Target Columns","Columns Adjust","Column Header Sheet Ref","Column Header Ref"]
[null,null,null,null,"RefHeaders",{"$f":"ROWS(RefHeaders[])","v":1},{"$f":"COLUMNS(Input!hdrNewTable)","v":1},{"$f":"$G176-$F176","v":0}]
[null,null,null,null,"RefValues",{"$f":"ROWS(RefValues[])","v":1},{"$f":"ROWS(Input!tabNewTable)","v":1},0,{"$f":"COLUMNS(RefValues[])","v":2},{"$f":"COLUMNS(Input!tabNewTable)+1","v":2},{"$f":"$J177-$I177","v":0},{"$f":"$E$192","v":"Input"},{"$f":"RefNewTableData[Column Header Ref]","v":"$B$20:$B$20"}]
[null,null,null,null,"RefBlanks",{"$f":"ROWS(RefBlanks[])","v":3},{"$f":"ROWS(Input!tabNewTable)","v":1},-2,{"$f":"COLUMNS(RefBlanks[])","v":3},{"$f":"COLUMNS(Input!tabNewTable)+1","v":2},-1,"Input",{"$f":"RefNewTableData[Column Header Ref]","v":"$B$20:$B$20"}]
[null,null,null,null,"RefCellTypes",{"$f":"ROWS(RefCellTypes[])","v":3},{"$f":"ROWS(Input!tabNewTable)","v":1},-2,{"$f":"COLUMNS(RefCellTypes[])","v":3},{"$f":"COLUMNS(Input!tabNewTable)+1","v":2},-1,"Input",{"$f":"RefNewTableData[Column Header Ref]","v":"$B$20:$B$20"}]
[null,null,null,null,"RefTargetCellType",{"$f":"ROWS(RefTargetCellType[])","v":3},{"$f":"ROWS(Input!tabNewTable)","v":1},-2,{"$f":"COLUMNS(RefTargetCellType[])","v":3},{"$f":"COLUMNS(Input!tabNewTable)+1","v":2},-1,"Input",{"$f":"RefNewTableData[Column Header Ref]","v":"$B$20:$B$20"}]
[null,null,null,null,"RefWrongCellType",{"$f":"ROWS(RefWrongCellType[])","v":3},{"$f":"ROWS(Input!tabNewTable)","v":1},-2,{"$f":"COLUMNS(RefWrongCellType[])","v":3},{"$f":"COLUMNS(Input!tabNewTable)+1","v":2},-1,"Input",{"$f":"RefNewTableData[Column Header Ref]","v":"$B$20:$B$20"}]
[null,null,null,null,"RefConstrainedRef",{"$f":"ROWS(RefConstrainedRef[])","v":3},{"$f":"ROWS(Input!tabNewTable)","v":1},-2,{"$f":"COLUMNS(RefConstrainedRef[])","v":3},{"$f":"COLUMNS(Input!tabNewTable)+1","v":2},-1,"Input",{"$f":"RefNewTableData[Column Header Ref]","v":"$B$20:$B$20"}]
[null,null,null,null,"RefConstraintError",{"$f":"ROWS(RefConstraintError[])","v":3},{"$f":"ROWS(Input!tabNewTable)","v":1},-2,{"$f":"COLUMNS(RefConstraintError[])","v":3},{"$f":"COLUMNS(Input!tabNewTable)+1","v":2},-1,"Input",{"$f":"RefNewTableData[Column Header Ref]","v":"$B$20:$B$20"}]
[null,null,null,null,"RefEntryError",{"$f":"ROWS(RefEntryError[])","v":3},{"$f":"ROWS(Input!tabNewTable)","v":1},-2,{"$f":"COLUMNS(RefEntryError[])","v":3},{"$f":"COLUMNS(Input!tabNewTable)+1","v":2},-1,"Input",{"$f":"RefNewTableData[Column Header Ref]","v":"$B$20:$B$20"}]
[null,null,null,null,"RefEntryErrorMessage",{"$f":"ROWS(RefEntryErrorMessage[])","v":3},{"$f":"ROWS(Input!tabNewTable)","v":1},{"$f":"$G185-$F185","v":-2},{"$f":"COLUMNS(RefEntryErrorMessage[])","v":3},{"$f":"COLUMNS(Input!tabNewTable)+1","v":2},{"$f":"$J185-$I185","v":-1},"Input",{"$f":"RefNewTableData[Column Header Ref]","v":"$B$20:$B$20"}]
[null,null,null,null,"RefSelStdTableFields",{"$f":"ROWS(RefSelStdTableFields[])","v":1},{"$f":"RefNewTableData[Field Count]","v":1},{"$f":"$G186-$F186","v":0}]
[]
[]
[null,null,null,null,"RefExcelTables"]
[null,null,null,null,"Sheet Name","Table Name","Current Rows","Target Rows","Rows Adjust","First Hide Cell","Last Hide Cell","Hide Range Ref","Hide Range?"]
[null,null,null,null,{"$f":"MID(CELL(\"filename\",Output!$A$1),FIND(\"]\",CELL(\"filename\",Output!$A$1))+1,100)","v":"Output"},"AddedTables",{"$f":"ROWS(Output!tabAddedTables)","v":3},{"$f":"MAX(1,ROWS(RefEBDExTables[]))","v":3},{"$f":"H191-G191","v":0}]
[null,null,null,null,{"$f":"MID(CELL(\"filename\",Input!$A$1),FIND(\"]\",CELL(\"filename\",Input!$A$1))+1,100)","v":"Input"},"StdFields",{"$f":"ROWS(Input!tabStdFields)","v":{"$error":"#NAME?"}},{"$f":"MAX(1,RefNewTableData[Field Count])","v":1},{"$f":"H192-G192","v":{"$error":"#NAME?"}},{"$f":"ADDRESS(ROW(Input!tabStdFields)-3,1)","v":{"$error":"#NAME?"}},{"$f":"ADDRESS(ROW(Input!tabStdFields)+ROWS(Input!tabStdFields),1)","v":{"$error":"#NAME?"}},{"$f":"RefExcelTables[First Hide Cell]&\":\"&RefExcelTables[Last Hide Cell]","v":":"},{"$f":"RefNewTableData[Table Type]=0","v":{"$error":"#REF!"}}]
[]
[]
[null,null,null,null,"RefNewTableData"]
[null,null,null,null,"Company Name","Program Name","Company Program Name","Table Name","Table Type","Table Description","Repeating Table Name Check","No Table Name Check","Invalid Table Name","Table Name Check","Standard Table Row","Field Group Count","Valid Standard Table?","Field Count","Field Start","Validation Formula","Conditional Format Formula","Column Header Validation","Input Sheet","Column Header First Cell","Column Header Last Cell","Column Header Ref","Valid Table?","Combined Error Message","Output Sheet","Output First Row","Output Title Ref","Output Headers Ref","Output Data Ref","Input Data Ref","No Tables?","Table Comments","Field Index","Format Index","Ref Sheet Name","Format Index Address","Next Format Index","Data Format","Header Align","Input Start Row","Input Rows","Input Start Col","Input Sheet Name","Input Column Address","Input Header Address"]
[null,null,null,null,{"$f":"Input!C4","v":0},{"$f":"Input!C5","v":0},{"$f":"IF(E197=0,\"\",$E$197)&IF(F197=0,\"\",\" - \"&$F$197)","v":""},{"$f":"Input!C9","v":0},{"$f":"Input!#REF!","v":{"$error":"#REF!"}},{"$f":"Input!#REF!","v":{"$error":"#REF!"}},{"$f":"COUNTIF(RefEBDExTables[Table Name],RefNewTableData[Table Name])>0","v":false},{"$f":"RefNewTableData[Table Name]=0","v":true},false,{"$f":"OR($K197,$L197,$M197)","v":true},{"$f":"MATCH($I197,RefStdTables[Table Type],0)","v":{"$error":"#REF!"}},{"$f":"INDEX(RefStdTables[Field Group Count],$O197)","v":{"$error":"#REF!"}},{"$f":"IF($I197=0,\"\",INDEX(RefStdTables[Valid Table?],$O197))","v":{"$error":"#REF!"}},{"$f":"MAX(1,COUNTIF(RefStdTableFields[Table Name],$I197))","v":1},{"$f":"MATCH($I197,RefStdTableFields[Table Name],0)","v":{"$error":"#REF!"}},"=INDIRECT(INDEX(INDIRECT(\"RefHeaders[Constrained Entries Ref]\"),COLUMN()-COLUMN(tabNewTable)+1))","=INDEX(INDIRECT(\"RefEntryError\"),ROW()-ROW(hdrNewTable),COLUMN()-COLUMN(tabNewTable)+2)","=INDIRECT(\"RefStdFields[Field Name]\")",{"$f":"$E$192","v":"Input"},{"$f":"ADDRESS(ROW(Input!hdrNewTable),COLUMN(Input!hdrNewTable))","v":"$B$20"},{"$f":"ADDRESS(ROW(Input!hdrNewTable),COLUMN(Input!hdrNewTable)+COLUMNS(Input!hdrNewTable)-1)","v":"$B$20"},{"$f":"RefNewTableData[Column Header First Cell]&\":\"&RefNewTableData[Column Header Last Cell]","v":"$B$20:$B$20"},{"$f":"COUNTIF(RefTableErrors[Error Exists?],TRUE)=0","v":false},{"$f":"INDEX(RefTableErrors[Combined Error Message],ROWS(RefTableErrors[]))","v":"\n\nNo Table Name\n\nMissing Field Name\n"},{"$f":"$E$191","v":"Output"},{"$f":"IF(INDEX(RefEBDExTables[Table Name],1)=0,ROW(Output!tabAddedTables)+ROWS(Output!tabAddedTables)+2,INDEX(RefEBDExTables[Last Row],ROWS(RefEBDExTables[]))+3)","v":49},{"$f":"ADDRESS($AD197,2)","v":"$B$49"},{"$f":"ADDRESS(AD197+1,2)&\":\"&ADDRESS(AD197+1,2+ROWS(RefHeaders[])-1)","v":"$B$50:$B$50"},{"$f":"ADDRESS(AD197+2,2)&\":\"&ADDRESS(AD197+2+ROWS(Input!tabNewTable)-1,2+COLUMNS(Input!tabNewTable)-1)","v":"$B$51:$B$51"},{"$f":"ADDRESS(ROW(Input!tabNewTable),COLUMN(Input!tabNewTable))&\":\"&ADDRESS(ROW(Input!tabNewTable)+ROWS(Input!tabNewTable)-1,COLUMN(Input!tabNewTable)+COLUMNS(Input!tabNewTable)-1)","v":"$B$21:$B$21"},{"$f":"AND(ROWS(RefEBDExTables[])=1,LEN(INDEX(RefEBDExTables[Table Name],1))=0)","v":false},"Rate Change table | As of 1/1/2009 | Other comments here",2,{"$f":"INDEX(RefHeaders[Format Index],AK197)","v":{"$error":"#REF!"}},{"$f":"MID(CELL(\"filename\",$A$1),FIND(\"]\",CELL(\"filename\",$A$1))+1,100)","v":"Ref"},{"$f":"\"'\"&$AM$197&\"'!\"&ADDRESS(ROW(RefHeaders[])+$AK197-1,COLUMN(RefHeaders[Format Index]))","v":"'Ref'!$U$272"},{"$f":"IF($AL197= ROWS(RefDataTypes[]),1,$AL197+1)","v":{"$error":"#REF!"}},{"$f":"INDEX(RefDataTypes[Data Format],$AL$197)","v":{"$error":"#REF!"}},{"$f":"INDEX(RefDataTypes[Header Align],$AL$197)","v":{"$error":"#REF!"}},{"$f":"ROW(Input!tabNewTable)","v":21},{"$f":"ROWS(Input!tabNewTable)","v":1},{"$f":"COLUMN(Input!tabNewTable)","v":2},{"$f":"MID(CELL(\"filename\",Input!$A$1),FIND(\"]\",CELL(\"filename\",Input!$A$1))+1,100)","v":"Input"},{"$f":"\"'\"&$AU$197&\"'!\"&ADDRESS($AR$197,$AT$197+$AK$197-1)&\":\"&ADDRESS($AR$197+$AS$197-1,$AT$197+$AK$197-1)","v":"'Input'!$C$21:$C$21"},{"$f":"\"'\"&$AU$197&\"'!\"&ADDRESS($AR$197-1,$AT$197+$AK$197-1)","v":"'Input'!$C$20"}]
[]
[]
[null,null,null,null,"RefExhibit"]
[null,null,null,null,"Company Name","Program Name","Company Program Name","Table Count","Table Index","Table Name","Table Comments","Table Comments Lines","Output Shee Name","Table Address"]
[null,null,null,null,"Cedant Company ABC","Reinsurance Program XYZ",{"$f":"$E$197&\" - \"&$F$197","v":"0 - 0"},{"$f":"ROWS(RefEBDExTables[])","v":3},1,{"$f":"INDEX(RefEBDExTables[Table Name],$I$202)","v":"Experience"},{"$f":"INDEX(RefEBDExTables[Table Comments],$I$202)","v":"SAMPLE TABLE | Company loss experience"},1,"Output",{"$f":"INDEX(RefEBDExTables[Table Address],$I$202)","v":"'Output'!$B$14:$G$22"}]
[]
[]
[null,null,null,null,"RefExhibitTables"]
[null,null,null,null,"Count Index","Table Name","Target Rows","Table Rows","Adjust Rows"]
[null,null,null,null,{"$f":"ROW()-ROW($E$206)","v":1},"Subtitles",{"$f":"RefExhibit[Table Comments Lines]","v":1},{"$f":"ROWS(ExhibitTemplate!tabSubtitles)","v":1},{"$f":"MAX(1,G207)-H207","v":0}]
[null,null,null,null,2,"Exhibit",{"$f":"INDEX(RefEBDExTables[Table Rows],$I$202)","v":8},{"$f":"ROWS(ExhibitTemplate!tabExhibit)","v":13},-5]
[]
[]
[null,null,null,null,"RefTableErrors"]
[null,null,null,null,"Count Index","Error Description","Error Exists?","Error Message","Combined Error Message"]
[null,null,null,null,{"$f":"ROW()-ROW(RefTableErrors[#Headers])","v":1},"No Table Name",{"$f":"RefNewTableData[No Table Name Check]","v":true},{"$f":"\"\n\"&RefTableErrors[[#This Row],[Error Description]]","v":"\nNo Table Name"},{"$f":"IF($E213=1,\"\",INDEX(RefTableErrors[Combined Error Message],$E213-1))&IF($G213,\"\n\"&$H213,\"\")","v":"\n\nNo Table Name"}]
[null,null,null,null,{"$f":"ROW()-ROW(RefTableErrors[#Headers])","v":2},"Table Name already Exists",{"$f":"RefNewTableData[Repeating Table Name Check]","v":false},{"$f":"\"\n\"&RefTableErrors[[#This Row],[Error Description]]","v":"\nTable Name already Exists"},{"$f":"IF($E214=1,\"\",INDEX(RefTableErrors[Combined Error Message],$E214-1))&IF($G214,\"\n\"&$H214,\"\")","v":"\n\nNo Table Name"}]
[null,null,null,null,{"$f":"ROW()-ROW(RefTableErrors[#Headers])","v":3},"Invalid Table Name",{"$f":"RefNewTableData[Invalid Table Name]","v":false},{"$f":"\"\n\"&RefTableErrors[[#This Row],[Error Description]]","v":"\nInvalid Table Name"},{"$f":"IF($E215=1,\"\",INDEX(RefTableErrors[Combined Error Message],$E215-1))&IF($G215,\"\n\"&$H215,\"\")","v":"\n\nNo Table Name"}]
[null,null,null,null,{"$f":"ROW()-ROW(RefTableErrors[#Headers])","v":4},"Missing Field Name",{"$f":"COUNTIF(RefHeaders[Current Header],0)>0","v":true},{"$f":"\"\n\"&F216&\"\n\"&INDEX(RefHeaders[Repeating Header Message],ROWS(RefHeaders[]))","v":"\nMissing Field Name\n"},{"$f":"IF($E216=1,\"\",INDEX(RefTableErrors[Combined Error Message],$E216-1))&IF($G216,\"\n\"&$H216,\"\")","v":"\n\nNo Table Name\n\nMissing Field Name\n"}]
[null,null,null,null,{"$f":"ROW()-ROW(RefTableErrors[#Headers])","v":5},"Repeating Field Name",{"$f":"COUNTIF(RefHeaders[Repeating Header?],TRUE)>0","v":false},{"$f":"\"\n\"&F217&\"\n\"&INDEX(RefHeaders[Repeating Header Message],ROWS(RefHeaders[]))","v":"\nRepeating Field Name\n"},{"$f":"IF($E217=1,\"\",INDEX(RefTableErrors[Combined Error Message],$E217-1))&IF($G217,\"\n\"&$H217,\"\")","v":"\n\nNo Table Name\n\nMissing Field Name\n"}]
[null,null,null,null,{"$f":"ROW()-ROW(RefTableErrors[#Headers])","v":6},"Required Field Names missing for Standard Table",{"$f":"IF(I197=0,FALSE,NOT(Q197))","v":{"$error":"#REF!"}},{"$f":"\"\n\"&RefTableErrors[[#This Row],[Error Description]]","v":{"$error":"#VALUE!"}},{"$f":"IF($E218=1,\"\",INDEX(RefTableErrors[Combined Error Message],$E218-1))&IF($G218,\"\n\"&$H218,\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"ROW()-ROW(RefTableErrors[#Headers])","v":7},"Entry errors",{"$f":"COUNTIF(RefEntryError[],TRUE)>0","v":false},{"$f":"\"\n\"&F219&\"\n\"&INDEX(RefHeaders[Entry Error Message],ROWS(RefHeaders[]))","v":"\nEntry errors\n"},{"$f":"IF($E219=1,\"\",INDEX(RefTableErrors[Combined Error Message],$E219-1))&IF($G219,\"\n\"&$H219,\"\")","v":{"$error":"#REF!"}}]
[]
[]
[]
[null,null,null,null,"RefFieldNames"]
[null,null,null,null,"Count index","Source Table","Source Field","Source Row","Target Table","Target Field","Target Row"]
[null,null,null,null,{"$f":"ROW()-ROW(RefFieldNames[#Headers])","v":1},"RefNewTableData","Table Name",1,"RefEBDExTables","Table Name",{"$f":"ROWS(RefEBDExTables[])","v":3}]
[null,null,null,null,{"$f":"ROW()-ROW(RefFieldNames[#Headers])","v":2},"RefNewTableData","Table Comments",1,"RefEBDExTables","Table Comments",{"$f":"ROWS(RefEBDExTables[])","v":3}]
[]
[]
[null,null,null,null,"RefEBDExTables"]
[null,null,null,null,"Count Index","Table Name","Table Comments","Last Row","Table Rows","First Table Row","Table Columns","First Column","Table Address"]
[null,null,null,null,{"$f":"ROW()-ROW(RefEBDExTables[#Headers])","v":1},"Experience","SAMPLE TABLE | Company loss experience",{"$f":"ROW(INDIRECT(\"Output!tab\"&$F231))+ROWS(INDIRECT(\"Output!tab\"&$F231))-1","v":22},{"$f":"ROWS(INDIRECT(\"Output!tab\"&$F231))","v":8},{"$f":"ROW(INDIRECT(\"Output!tab\"&$F231))","v":15},{"$f":"COLUMNS(INDIRECT(\"Output!tab\"&$F231))","v":6},{"$f":"COLUMN(INDIRECT(\"Output!tab\"&$F231))","v":2},{"$f":"\"'\"&$M$202&\"'!\"&ADDRESS(J231-1,L231)&\":\"&ADDRESS(J231+I231-1,L231+K231-1)","v":"'Output'!$B$14:$G$22"}]
[null,null,null,null,{"$f":"ROW()-ROW(RefEBDExTables[#Headers])","v":2},"LargeLoss","SAMPLE TABLE | Large Loss Listing",{"$f":"ROW(INDIRECT(\"Output!tab\"&$F232))+ROWS(INDIRECT(\"Output!tab\"&$F232))-1","v":34},{"$f":"ROWS(INDIRECT(\"Output!tab\"&$F232))","v":8},{"$f":"ROW(INDIRECT(\"Output!tab\"&$F232))","v":27},{"$f":"COLUMNS(INDIRECT(\"Output!tab\"&$F232))","v":7},{"$f":"COLUMN(INDIRECT(\"Output!tab\"&$F232))","v":2},{"$f":"\"'\"&$M$202&\"'!\"&ADDRESS(J232-1,L232)&\":\"&ADDRESS(J232+I232-1,L232+K232-1)","v":"'Output'!$B$26:$H$34"}]
[null,null,null,null,{"$f":"ROW()-ROW(RefEBDExTables[#Headers])","v":3},"LossTriangle","SAMPLE TABLE | Loss triangle",{"$f":"ROW(INDIRECT(\"Output!tab\"&$F233))+ROWS(INDIRECT(\"Output!tab\"&$F233))-1","v":46},{"$f":"ROWS(INDIRECT(\"Output!tab\"&$F233))","v":8},{"$f":"ROW(INDIRECT(\"Output!tab\"&$F233))","v":39},{"$f":"COLUMNS(INDIRECT(\"Output!tab\"&$F233))","v":9},{"$f":"COLUMN(INDIRECT(\"Output!tab\"&$F233))","v":2},{"$f":"\"'\"&$M$202&\"'!\"&ADDRESS(J233-1,L233)&\":\"&ADDRESS(J233+I233-1,L233+K233-1)","v":"'Output'!$B$38:$J$46"}]
[]
[]
[null,null,null,null,"RefSelStdTableFields"]
[null,null,null,null,"Count Index","Field Row","Table Name","Field Group","Field Name","Field Included?"]
[null,null,null,null,{"$f":"ROW()-ROW(RefSelStdTableFields[#Headers])","v":1},{"$f":"$E238+RefNewTableData[Field Start]-1","v":{"$error":"#REF!"}},{"$f":"INDEX(RefStdTableFields[Table Name],$F238)","v":{"$error":"#REF!"}},{"$f":"INDEX(RefStdTableFields[Field Group],$F238)","v":{"$error":"#REF!"}},{"$f":"INDEX(RefStdTableFields[Field Name],$F238)","v":{"$error":"#REF!"}},{"$f":"INDEX(RefStdTableFields[Field Included?],$F238)","v":{"$error":"#REF!"}}]
[]
[]
[null,null,null,null,"RefStdTables"]
[null,null,null,null,"Count Index","Table Type","Field Group Count","Valid Table?"]
[null,null,null,null,{"$f":"ROW()-ROW(RefStdTables[#Headers])","v":1},"Historic Rate Change",{"$f":"COUNTIFS(Table42[Table Name],$F243)","v":2},{"$f":"COUNTIFS(Table42[Table Name],$F243,Table42[Field Group Included?],TRUE)=$G243","v":false}]
[null,null,null,null,{"$f":"ROW()-ROW(RefStdTables[#Headers])","v":2},"Large Loss Listing",{"$f":"COUNTIFS(Table42[Table Name],$F244)","v":2},{"$f":"COUNTIFS(Table42[Table Name],$F244,Table42[Field Group Included?],TRUE)=$G244","v":false}]
[]
[]
[null,null,null,null,"RefStdTableCategories"]
[null,null,null,null,"Count Index","Table Name","Field Group","Field Group Included?"]
[null,null,null,null,{"$f":"ROW()-ROW(Table42[#Headers])","v":1},"Historic Rate Change",1,{"$f":"COUNTIFS(RefStdTableFields[Table Name],$F249,RefStdTableFields[Field Group],$G249,RefStdTableFields[Field Included?],TRUE)>0","v":false}]
[null,null,null,null,{"$f":"ROW()-ROW(Table42[#Headers])","v":2},"Historic Rate Change",2,{"$f":"COUNTIFS(RefStdTableFields[Table Name],$F250,RefStdTableFields[Field Group],$G250,RefStdTableFields[Field Included?],TRUE)>0","v":false}]
[null,null,null,null,{"$f":"ROW()-ROW(Table42[#Headers])","v":3},"Large Loss Listing",1,{"$f":"COUNTIFS(RefStdTableFields[Table Name],$F251,RefStdTableFields[Field Group],$G251,RefStdTableFields[Field Included?],TRUE)>0","v":false}]
[null,null,null,null,{"$f":"ROW()-ROW(Table42[#Headers])","v":4},"Large Loss Listing",2,{"$f":"COUNTIFS(RefStdTableFields[Table Name],$F252,RefStdTableFields[Field Group],$G252,RefStdTableFields[Field Included?],TRUE)>0","v":false}]
[]
[]
[]
[null,null,null,null,"RefStdTableFields"]
[null,null,null,null,"Count Index","Table Name","Field Group","Field Name","Field Included?"]
[null,null,null,null,{"$f":"ROW()-ROW(RefStdTableFields[#Headers])","v":1},"Historic Rate Change",1,"Effective Date",{"$f":"COUNTIF(RefHeaders[Current Header],$H258)>0","v":false}]
[null,null,null,null,{"$f":"ROW()-ROW(RefStdTableFields[#Headers])","v":2},"Historic Rate Change",2,"Rate Change",{"$f":"COUNTIF(RefHeaders[Current Header],$H259)>0","v":false}]
[null,null,null,null,{"$f":"ROW()-ROW(RefStdTableFields[#Headers])","v":3},"Large Loss Listing",1,"Accident Date",{"$f":"COUNTIF(RefHeaders[Current Header],$H260)>0","v":false}]
[null,null,null,null,{"$f":"ROW()-ROW(RefStdTableFields[#Headers])","v":4},"Large Loss Listing",1,"Effective Date",{"$f":"COUNTIF(RefHeaders[Current Header],$H261)>0","v":false}]
[null,null,null,null,{"$f":"ROW()-ROW(RefStdTableFields[#Headers])","v":5},"Large Loss Listing",1,"Report Date",{"$f":"COUNTIF(RefHeaders[Current Header],$H262)>0","v":false}]
[null,null,null,null,{"$f":"ROW()-ROW(RefStdTableFields[#Headers])","v":6},"Large Loss Listing",2,"Reported Loss",{"$f":"COUNTIF(RefHeaders[Current Header],$H263)>0","v":false}]
[null,null,null,null,{"$f":"ROW()-ROW(RefStdTableFields[#Headers])","v":7},"Large Loss Listing",2,"Paid Loss",{"$f":"COUNTIF(RefHeaders[Current Header],$H264)>0","v":false}]
[]
[]
[]
[]
[null,null,null,null,"RefHeaders"]
[null,null,null,null,"Count Index","Current Header","Missing Header?","Repeating Header?","Repeating Header Message","Header Check","Standard Header?","Data Type","Data Format","Header Align","Cell Type","Constrained Entries?","Constrained Entries Ref","Entry Errors?","Error Messages","Entry Error Message","Format Index","Output Format","Output Align"]
[null,null,null,null,{"$f":"ROW()-ROW(RefHeaders[#Headers])","v":1},{"$f":"INDEX(Input!hdrNewTable,$E271)","v":0},{"$f":"LEN(INDEX(Input!hdrNewTable,$E271))=0","v":true},{"$f":"COUNTIF(RefHeaders[Current Header],$F271)>1","v":false},{"$f":"IF(E271=1,\"\",INDEX(RefHeaders[Repeating Header Message],E271-1))&IF($H271,\"\n\"&F271,\"\")","v":""},{"$f":"OR(G271,H271)","v":true},{"$f":"COUNTIF(RefStdFields[Field Name],$F271)>0","v":false},{"$f":"IF($K271,INDEX(RefStdFields[Data Type],MATCH($F271,RefStdFields[Field Name],0)),\"\")","v":""},{"$f":"IF($K271,INDEX(RefDataTypes[Data Format],MATCH($L271,RefDataTypes[Data Type],0)),\"General\")","v":"General"},{"$f":"IF($K271,INDEX(RefDataTypes[Header Align],MATCH($L271,RefDataTypes[Data Type],0)),1)","v":1},{"$f":"IF($K271,INDEX(RefDataTypes[Cell Type],MATCH($L271,RefDataTypes[Data Type],0)),\"\")","v":""},{"$f":"COUNTIF(RefDataCategories[Field Name],$F271)>0","v":false},{"$f":"IF($P271,INDEX(RefDataCategories[Category Ref],MATCH($F271,RefDataCategories[Field Name],0)),\"\")","v":""},{"$f":"COUNTIF(INDEX(RefEntryError[],,$E271+1),TRUE)>0","v":false},{"$f":"IF($R271,\"\n\"&$F271&\"\n\"&INDEX(RefEntryErrorMessage[],ROWS(RefEntryErrorMessage[]),$E271+1),\"\")","v":""},{"$f":"IF($E271=1,\"\",INDEX(RefHeaders[Entry Error Message],$E271-1))&IF($R271,\"\n\"&$S271,\"\")","v":""},2,{"$f":"IF($U271=0,\"General\",INDEX(RefDataTypes[Data Format],$U271))","v":"m/d/yyyy"},{"$f":"IF($U271=0,1,INDEX(RefDataTypes[Header Align],$U271))","v":-4152}]
[]
[]
[null,null,null,null,"RefValues"]
[null,null,null,null,"Count Index","Column1"]
[null,null,null,null,{"$f":"ROW()-ROW(RefValues[#Headers])","v":1},{"$f":"INDEX(Input!tabNewTable,$E276,COLUMN()-COLUMN($E276))","v":0}]
[]
[]
[null,null,null,null,"RefBlanks"]
[null,null,null,null,"Count Index","Column1","Column2"]
[null,null,null,null,{"$f":"ROW()-ROW(RefBlanks[#Headers])","v":1},{"$f":"LEN(INDEX(Input!tabNewTable,$E281,COLUMN()-COLUMN($E281)))=0","v":true},{"$f":"LEN(INDEX(Input!tabNewTable,$E281,COLUMN()-COLUMN($E281)))=0","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"ROW()-ROW(RefBlanks[#Headers])","v":2},{"$f":"LEN(INDEX(Input!tabNewTable,$E282,COLUMN()-COLUMN($E282)))=0","v":{"$error":"#REF!"}},{"$f":"LEN(INDEX(Input!tabNewTable,$E282,COLUMN()-COLUMN($E282)))=0","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"ROW()-ROW(RefBlanks[#Headers])","v":3},{"$f":"LEN(INDEX(Input!tabNewTable,$E283,COLUMN()-COLUMN($E283)))=0","v":{"$error":"#REF!"}},{"$f":"LEN(INDEX(Input!tabNewTable,$E283,COLUMN()-COLUMN($E283)))=0","v":{"$error":"#REF!"}}]
[]
[]
[null,null,null,null,"RefCellTypes"]
[null,null,null,null,"Count Index","Column1","Column2"]
[null,null,null,null,{"$f":"ROW()-ROW(RefCellTypes[#Headers])","v":1},{"$f":"CELL(\"type\",INDEX(Input!tabNewTable,$E288,COLUMN()-COLUMN($E288)))","v":"b"},{"$f":"CELL(\"type\",INDEX(Input!tabNewTable,$E288,COLUMN()-COLUMN($E288)))","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"ROW()-ROW(RefCellTypes[#Headers])","v":2},{"$f":"CELL(\"type\",INDEX(Input!tabNewTable,$E289,COLUMN()-COLUMN($E289)))","v":{"$error":"#REF!"}},{"$f":"CELL(\"type\",INDEX(Input!tabNewTable,$E289,COLUMN()-COLUMN($E289)))","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"ROW()-ROW(RefCellTypes[#Headers])","v":3},{"$f":"CELL(\"type\",INDEX(Input!tabNewTable,$E290,COLUMN()-COLUMN($E290)))","v":{"$error":"#REF!"}},{"$f":"CELL(\"type\",INDEX(Input!tabNewTable,$E290,COLUMN()-COLUMN($E290)))","v":{"$error":"#REF!"}}]
[]
[]
[null,null,null,null,"RefTargetCellType"]
[null,null,null,null,"Count Index","Column1","Column2"]
[null,null,null,null,{"$f":"ROW()-ROW(RefTargetCellType[#Headers])","v":1},{"$f":"INDEX(RefHeaders[Cell Type],COLUMN()-COLUMN($E295))","v":""},{"$f":"INDEX(RefHeaders[Cell Type],COLUMN()-COLUMN($E295))","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"ROW()-ROW(RefTargetCellType[#Headers])","v":2},{"$f":"INDEX(RefHeaders[Cell Type],COLUMN()-COLUMN($E296))","v":""},{"$f":"INDEX(RefHeaders[Cell Type],COLUMN()-COLUMN($E296))","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"ROW()-ROW(RefTargetCellType[#Headers])","v":3},{"$f":"INDEX(RefHeaders[Cell Type],COLUMN()-COLUMN($E297))","v":""},{"$f":"INDEX(RefHeaders[Cell Type],COLUMN()-COLUMN($E297))","v":{"$error":"#REF!"}}]
[]
[]
[null,null,null,null,"RefWrongCellType"]
[null,null,null,null,"Count Index","Column1","Column2"]
[null,null,null,null,{"$f":"ROW()-ROW(RefWrongCellType[#Headers])","v":1},{"$f":"IF(LEN(F295)=0,FALSE,IF(F281,FALSE,F295<>F288))","v":false},{"$error":"#REF!"}]
[null,null,null,null,{"$f":"ROW()-ROW(RefWrongCellType[#Headers])","v":2},{"$f":"IF(LEN(F296)=0,FALSE,IF(F282,FALSE,F296<>F289))","v":false},{"$f":"IF(LEN(G296)=0,FALSE,IF(G282,FALSE,G296<>G289))","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"ROW()-ROW(RefWrongCellType[#Headers])","v":3},{"$f":"IF(LEN(F297)=0,FALSE,IF(F283,FALSE,F297<>F290))","v":false},{"$f":"IF(LEN(G297)=0,FALSE,IF(G283,FALSE,G297<>G290))","v":{"$error":"#REF!"}}]
[]
[]
[null,null,null,null,"RefConstrainedRef"]
[null,null,null,null,"Count Index","Column1","Column2"]
[null,null,null,null,{"$f":"ROW()-ROW(RefConstrainedRef[#Headers])","v":1},{"$f":"INDEX(RefHeaders[Constrained Entries Ref],COLUMN()-COLUMN($E309))","v":""},{"$f":"INDEX(RefHeaders[Constrained Entries Ref],COLUMN()-COLUMN($E309))","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"ROW()-ROW(RefConstrainedRef[#Headers])","v":2},{"$f":"INDEX(RefHeaders[Constrained Entries Ref],COLUMN()-COLUMN($E310))","v":""},{"$f":"INDEX(RefHeaders[Constrained Entries Ref],COLUMN()-COLUMN($E310))","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"ROW()-ROW(RefConstrainedRef[#Headers])","v":3},{"$f":"INDEX(RefHeaders[Constrained Entries Ref],COLUMN()-COLUMN($E311))","v":""},{"$f":"INDEX(RefHeaders[Constrained Entries Ref],COLUMN()-COLUMN($E311))","v":{"$error":"#REF!"}}]
[]
[]
[null,null,null,null,"RefConstraintError"]
[null,null,null,null,"Count Index","Column1","Column2"]
[null,null,null,null,{"$f":"ROW()-ROW(RefConstraintError[#Headers])","v":1},{"$f":"IF(LEN(F309)=0,FALSE,IF(F281,FALSE,COUNTIF(INDIRECT(F309),F276)=0))","v":false},{"$f":"IF(LEN(G309)=0,FALSE,IF(G281,FALSE,COUNTIF(INDIRECT(G309),#REF!)=0))","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"ROW()-ROW(RefConstraintError[#Headers])","v":2},{"$f":"IF(LEN(F310)=0,FALSE,IF(F282,FALSE,COUNTIF(INDIRECT(F310),#REF!)=0))","v":false},{"$f":"IF(LEN(G310)=0,FALSE,IF(G282,FALSE,COUNTIF(INDIRECT(G310),#REF!)=0))","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"ROW()-ROW(RefConstraintError[#Headers])","v":3},{"$f":"IF(LEN(F311)=0,FALSE,IF(F283,FALSE,COUNTIF(INDIRECT(F311),#REF!)=0))","v":false},{"$f":"IF(LEN(G311)=0,FALSE,IF(G283,FALSE,COUNTIF(INDIRECT(G311),#REF!)=0))","v":{"$error":"#REF!"}}]
[]
[]
[null,null,null,null,"RefEntryError"]
[null,null,null,null,"Count Index","Column1","Column2"]
[null,null,null,null,{"$f":"ROW()-ROW(RefEntryError[#Headers])","v":1},{"$f":"OR(F302,F316)","v":false},{"$error":"#REF!"}]
[null,null,null,null,{"$f":"ROW()-ROW(RefEntryError[#Headers])","v":2},{"$f":"OR(F303,F317)","v":false},{"$f":"OR(G303,G317)","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"ROW()-ROW(RefEntryError[#Headers])","v":3},{"$f":"OR(F304,F318)","v":false},{"$f":"OR(G304,G318)","v":{"$error":"#REF!"}}]
[]
[]
[null,null,null,null,"RefEntryErrorMessage"]
[null,null,null,null,"Count Index","Column1","Column2"]
[null,null,null,null,{"$f":"ROW()-ROW(RefEntryErrorMessage[#Headers])","v":1},{"$f":"IF($E330=1,\"\",INDEX(RefEntryErrorMessage[],$E330-1,COLUMN(Ref!F$329)-COLUMN(Ref!$E$329)+1))&IF(F323,\"\n\"&$E330&\"          \"&INDEX(Input!tabNewTable,$E330,COLUMN(Ref!F$329)-COLUMN(Ref!$E$329)),\"\")","v":""},{"$f":"IF($E330=1,\"\",INDEX(RefEntryErrorMessage[],$E330-1,COLUMN(Ref!G$329)-COLUMN(Ref!$E$329)+1))&IF(G323,\"\n\"&$E330&\"          \"&INDEX(Input!tabNewTable,$E330,COLUMN(Ref!G$329)-COLUMN(Ref!$E$329)),\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"ROW()-ROW(RefEntryErrorMessage[#Headers])","v":2},{"$f":"IF($E331=1,\"\",INDEX(RefEntryErrorMessage[],$E331-1,COLUMN(Ref!F$329)-COLUMN(Ref!$E$329)+1))&IF(F324,\"\n\"&$E331&\"          \"&INDEX(Input!tabNewTable,$E331,COLUMN(Ref!F$329)-COLUMN(Ref!$E$329)),\"\")","v":""},{"$f":"IF($E331=1,\"\",INDEX(RefEntryErrorMessage[],$E331-1,COLUMN(Ref!G$329)-COLUMN(Ref!$E$329)+1))&IF(G324,\"\n\"&$E331&\"          \"&INDEX(Input!tabNewTable,$E331,COLUMN(Ref!G$329)-COLUMN(Ref!$E$329)),\"\")","v":{"$error":"#REF!"}}]
[null,null,null,null,{"$f":"ROW()-ROW(RefEntryErrorMessage[#Headers])","v":3},{"$f":"IF($E332=1,\"\",INDEX(RefEntryErrorMessage[],$E332-1,COLUMN(Ref!F$329)-COLUMN(Ref!$E$329)+1))&IF(F325,\"\n\"&$E332&\"          \"&INDEX(Input!tabNewTable,$E332,COLUMN(Ref!F$329)-COLUMN(Ref!$E$329)),\"\")","v":""},{"$f":"IF($E332=1,\"\",INDEX(RefEntryErrorMessage[],$E332-1,COLUMN(Ref!G$329)-COLUMN(Ref!$E$329)+1))&IF(G325,\"\n\"&$E332&\"          \"&INDEX(Input!tabNewTable,$E332,COLUMN(Ref!G$329)-COLUMN(Ref!$E$329)),\"\")","v":{"$error":"#REF!"}}]

{"sheet":"Categories","index":2,"n_rows":72,"n_cols":23,"rows_kept":72,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[null,"RefISOGeneralLiab",null,null,"RefISOAutoLiab",null,null,"RefLocations",null,null,null,"RefISOBuildingType",null,null,"RefISOOccupancyType",null,null,"RefWCHazardGroup",null,null,"RefASLinesOfBusiness"]
[null,"Count Index","ISO GL Category",null,"Count Index","ISO AL Category",null,"Count Index","State / Province Abr","State / Province Name",null,"Count Index","Building Type",null,"Count Index","Occupancy",null,"Count Index","Hazard Group",null,"Count Index","AS LOB Num","AS LOB Name"]
[null,{"$f":"ROW()-ROW(RefISOGeneralLiab[#Headers])","v":1},"Prem/Ops 1",null,1,"Light & Medium",null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":1},"AL","Alabama",null,{"$f":"ROW()-ROW(RefISOBuildingType[#Headers])","v":1},"Brick Protected",null,{"$f":"ROW()-ROW(RefISOOccupancyType[#Headers])","v":1},"Apartments<10",null,{"$f":"ROW()-ROW(RefWCHazardGroup[#Headers])","v":1},"A",null,{"$f":"ROW()-ROW(RefASLinesOfBusiness[#Headers])","v":1},1,"Fire"]
[null,{"$f":"ROW()-ROW(RefISOGeneralLiab[#Headers])","v":2},"Prem/Ops 2",null,2,"Heavy",null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":2},"AK","Alaska",null,{"$f":"ROW()-ROW(RefISOBuildingType[#Headers])","v":2},"Brick Unprotected",null,{"$f":"ROW()-ROW(RefISOOccupancyType[#Headers])","v":2},"Apartments>10",null,{"$f":"ROW()-ROW(RefWCHazardGroup[#Headers])","v":2},"B",null,{"$f":"ROW()-ROW(RefASLinesOfBusiness[#Headers])","v":2},2.1,"Allied Lines"]
[null,{"$f":"ROW()-ROW(RefISOGeneralLiab[#Headers])","v":3},"Prem/Ops 3",null,3,"Extra Heavy",null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":3},"AZ","Arizona",null,{"$f":"ROW()-ROW(RefISOBuildingType[#Headers])","v":3},"Frame Protected",null,{"$f":"ROW()-ROW(RefISOOccupancyType[#Headers])","v":3},"Dwelling",null,{"$f":"ROW()-ROW(RefWCHazardGroup[#Headers])","v":3},"C",null,{"$f":"ROW()-ROW(RefASLinesOfBusiness[#Headers])","v":3},2.2000000000000002,"Multiple Peril Crop"]
[null,{"$f":"ROW()-ROW(RefISOGeneralLiab[#Headers])","v":4},"Products A",null,4,"Other",null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":4},"AR","Arkansas",null,{"$f":"ROW()-ROW(RefISOBuildingType[#Headers])","v":4},"Frame Unprotected",null,{"$f":"ROW()-ROW(RefISOOccupancyType[#Headers])","v":4},"Group Institutional Housing",null,{"$f":"ROW()-ROW(RefWCHazardGroup[#Headers])","v":4},"D",null,{"$f":"ROW()-ROW(RefASLinesOfBusiness[#Headers])","v":4},2.2999999999999998,"Federal flood"]
[null,{"$f":"ROW()-ROW(RefISOGeneralLiab[#Headers])","v":5},"Products B",null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":5},"CA","California",null,null,null,null,{"$f":"ROW()-ROW(RefISOOccupancyType[#Headers])","v":5},"Hospitals & Nursing Homes",null,{"$f":"ROW()-ROW(RefWCHazardGroup[#Headers])","v":5},"E",null,{"$f":"ROW()-ROW(RefASLinesOfBusiness[#Headers])","v":5},3,"Farmowners multiple peril"]
[null,{"$f":"ROW()-ROW(RefISOGeneralLiab[#Headers])","v":6},"Products C",null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":6},"CO","Colorado",null,null,null,null,{"$f":"ROW()-ROW(RefISOOccupancyType[#Headers])","v":6},"Hotels & Motels - with restaurant",null,{"$f":"ROW()-ROW(RefWCHazardGroup[#Headers])","v":6},"F",null,{"$f":"ROW()-ROW(RefASLinesOfBusiness[#Headers])","v":6},4,"Homeowners Multiple Peril"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":7},"CT","Connecticut",null,null,null,null,{"$f":"ROW()-ROW(RefISOOccupancyType[#Headers])","v":7},"Hotels & Motels - Other",null,{"$f":"ROW()-ROW(RefWCHazardGroup[#Headers])","v":7},"G",null,{"$f":"ROW()-ROW(RefASLinesOfBusiness[#Headers])","v":7},5.0999999999999996,"Commercial multiple peril (non-liability portion)"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":8},"DE","Delaware",null,null,null,null,{"$f":"ROW()-ROW(RefISOOccupancyType[#Headers])","v":8},"Entertainment & Recreation",null,null,null,null,{"$f":"ROW()-ROW(RefASLinesOfBusiness[#Headers])","v":8},5.2,"Commercial multiple peril (liability portion)"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":9},"DC","District of Columbia",null,null,null,null,{"$f":"ROW()-ROW(RefISOOccupancyType[#Headers])","v":9},"Restaurants & Bars",null,null,null,null,{"$f":"ROW()-ROW(RefASLinesOfBusiness[#Headers])","v":9},6,"Mortgage guaranty"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":10},"FL","Florida",null,null,null,null,{"$f":"ROW()-ROW(RefISOOccupancyType[#Headers])","v":10},"Emergency Services",null,null,null,null,{"$f":"ROW()-ROW(RefASLinesOfBusiness[#Headers])","v":10},8,"Ocean marine"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":11},"GA","Georgia",null,null,null,null,{"$f":"ROW()-ROW(RefISOOccupancyType[#Headers])","v":11},"Government Services",null,null,null,null,{"$f":"ROW()-ROW(RefASLinesOfBusiness[#Headers])","v":11},9,"Inland marine"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":12},"HI","Hawaii",null,null,null,null,{"$f":"ROW()-ROW(RefISOOccupancyType[#Headers])","v":12},"Churches",null,null,null,null,{"$f":"ROW()-ROW(RefASLinesOfBusiness[#Headers])","v":12},10,"Financial guaranty"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":13},"ID","Idaho",null,null,null,null,{"$f":"ROW()-ROW(RefISOOccupancyType[#Headers])","v":13},"Schools",null,null,null,null,{"$f":"ROW()-ROW(RefASLinesOfBusiness[#Headers])","v":13},11,"Medical malpractice"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":14},"IL","Illinois",null,null,null,null,{"$f":"ROW()-ROW(RefISOOccupancyType[#Headers])","v":14},"Offices & Banks",null,null,null,null,{"$f":"ROW()-ROW(RefASLinesOfBusiness[#Headers])","v":14},12,"Earthquake"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":15},"IN","Indiana",null,null,null,null,{"$f":"ROW()-ROW(RefISOOccupancyType[#Headers])","v":15},"Other Mercantiles - Retail/Wholesale",null,null,null,null,{"$f":"ROW()-ROW(RefASLinesOfBusiness[#Headers])","v":15},13,"Group accident and health"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":16},"IA","Iowa",null,null,null,null,{"$f":"ROW()-ROW(RefISOOccupancyType[#Headers])","v":16},"Other Mercantiles - Other",null,null,null,null,{"$f":"ROW()-ROW(RefASLinesOfBusiness[#Headers])","v":16},14,"Credit A & H (Group and Individual)"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":17},"KS","Kansas",null,null,null,null,{"$f":"ROW()-ROW(RefISOOccupancyType[#Headers])","v":17},"Gasoline Stations",null,null,null,null,{"$f":"ROW()-ROW(RefASLinesOfBusiness[#Headers])","v":17},15.1,"Collectively renewable A & H"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":18},"KY","Kentucky",null,null,null,null,{"$f":"ROW()-ROW(RefISOOccupancyType[#Headers])","v":18},"Auto Repair",null,null,null,null,{"$f":"ROW()-ROW(RefASLinesOfBusiness[#Headers])","v":18},15.2,"Non-cancelable A & H"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":19},"LA","Louisiana",null,null,null,null,{"$f":"ROW()-ROW(RefISOOccupancyType[#Headers])","v":19},"Parking",null,null,null,null,{"$f":"ROW()-ROW(RefASLinesOfBusiness[#Headers])","v":19},15.3,"Guaranteed renewable A & H"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":20},"ME","Maine",null,null,null,null,{"$f":"ROW()-ROW(RefISOOccupancyType[#Headers])","v":20},"BillBoards",null,null,null,null,{"$f":"ROW()-ROW(RefASLinesOfBusiness[#Headers])","v":20},15.4,"Non-renewable for states reasons only"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":21},"MD","Maryland",null,null,null,null,{"$f":"ROW()-ROW(RefISOOccupancyType[#Headers])","v":21},"Personal & Repair Services",null,null,null,null,{"$f":"ROW()-ROW(RefASLinesOfBusiness[#Headers])","v":21},15.5,"Other accident only"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":22},"MA","Massachusetts",null,null,null,null,{"$f":"ROW()-ROW(RefISOOccupancyType[#Headers])","v":22},"Buildings Under Construction",null,null,null,null,{"$f":"ROW()-ROW(RefASLinesOfBusiness[#Headers])","v":22},15.6,"Medicare Title XVIII exempt from State taxes or fees"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":23},"MI","Michigan",null,null,null,null,{"$f":"ROW()-ROW(RefISOOccupancyType[#Headers])","v":23},"Airplane Risks",null,null,null,null,{"$f":"ROW()-ROW(RefASLinesOfBusiness[#Headers])","v":23},15.7,"All other A & H"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":24},"MN","Minnesota",null,null,null,null,{"$f":"ROW()-ROW(RefISOOccupancyType[#Headers])","v":24},"Storage",null,null,null,null,{"$f":"ROW()-ROW(RefASLinesOfBusiness[#Headers])","v":24},16,"Workers' compensation"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":25},"MS","Mississippi",null,null,null,null,{"$f":"ROW()-ROW(RefISOOccupancyType[#Headers])","v":25},"Agricultural - Greenhouses",null,null,null,null,{"$f":"ROW()-ROW(RefASLinesOfBusiness[#Headers])","v":25},17.100000000000001,"Other liability"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":26},"MO","Missouri",null,null,null,null,{"$f":"ROW()-ROW(RefISOOccupancyType[#Headers])","v":26},"Agricultural - Grain Elevators",null,null,null,null,{"$f":"ROW()-ROW(RefASLinesOfBusiness[#Headers])","v":26},17.3,"Excess Workers' Compensation"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":27},"MT","Montana",null,null,null,null,{"$f":"ROW()-ROW(RefISOOccupancyType[#Headers])","v":27},"Food Processing - Other",null,null,null,null,{"$f":"ROW()-ROW(RefASLinesOfBusiness[#Headers])","v":27},18,"Products liability"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":28},"NE","Nebraska",null,null,null,null,{"$f":"ROW()-ROW(RefISOOccupancyType[#Headers])","v":28},"Food Processing - Severe",null,null,null,null,{"$f":"ROW()-ROW(RefASLinesOfBusiness[#Headers])","v":28},19.100000000000001,"Private passenger auto no-fault (personal injury protection)"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":29},"NV","Nevada",null,null,null,null,{"$f":"ROW()-ROW(RefISOOccupancyType[#Headers])","v":29},"General Indu/Metal Manufacturing",null,null,null,null,{"$f":"ROW()-ROW(RefASLinesOfBusiness[#Headers])","v":29},19.2,"Other private passenger auto liability"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":30},"NH","New Hampshire",null,null,null,null,{"$f":"ROW()-ROW(RefISOOccupancyType[#Headers])","v":30},"Chemical Manufacturing",null,null,null,null,{"$f":"ROW()-ROW(RefASLinesOfBusiness[#Headers])","v":30},19.3,"Commercial auto no-fault (personal injury protection)"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":31},"NJ","New Jersey",null,null,null,null,{"$f":"ROW()-ROW(RefISOOccupancyType[#Headers])","v":31},"Light Manufacturing - Printing",null,null,null,null,{"$f":"ROW()-ROW(RefASLinesOfBusiness[#Headers])","v":31},19.399999999999999,"Other commercial auto liability"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":32},"NM","New Mexico",null,null,null,null,{"$f":"ROW()-ROW(RefISOOccupancyType[#Headers])","v":32},"Light Manufacturing - Other",null,null,null,null,{"$f":"ROW()-ROW(RefASLinesOfBusiness[#Headers])","v":32},21,"Auto physical damage"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":33},"NY","New York",null,null,null,null,{"$f":"ROW()-ROW(RefISOOccupancyType[#Headers])","v":33},"Heavy Manufacturing - Wood",null,null,null,null,{"$f":"ROW()-ROW(RefASLinesOfBusiness[#Headers])","v":33},22,"Aircraft (all perils)"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":34},"NC","North Carolina",null,null,null,null,{"$f":"ROW()-ROW(RefISOOccupancyType[#Headers])","v":34},"Heavy Manufacturing - Other",null,null,null,null,{"$f":"ROW()-ROW(RefASLinesOfBusiness[#Headers])","v":34},23,"Fidelity"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":35},"ND","North Dakota",null,null,null,null,{"$f":"ROW()-ROW(RefISOOccupancyType[#Headers])","v":35},"Severe Manufacturing/Petroleum",null,null,null,null,{"$f":"ROW()-ROW(RefASLinesOfBusiness[#Headers])","v":35},24,"Surety"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":36},"OH","Ohio",null,null,null,null,{"$f":"ROW()-ROW(RefISOOccupancyType[#Headers])","v":36},"Highly Protected Risks - Low",null,null,null,null,{"$f":"ROW()-ROW(RefASLinesOfBusiness[#Headers])","v":36},26,"Burglary and theft"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":37},"OK","Oklahoma",null,null,null,null,{"$f":"ROW()-ROW(RefISOOccupancyType[#Headers])","v":37},"Highly Protected Risks - Medium",null,null,null,null,{"$f":"ROW()-ROW(RefASLinesOfBusiness[#Headers])","v":37},27,"Boiler and machinery"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":38},"OR","Oregon",null,null,null,null,{"$f":"ROW()-ROW(RefISOOccupancyType[#Headers])","v":38},"Highly Protected Risks - Heavy",null,null,null,null,{"$f":"ROW()-ROW(RefASLinesOfBusiness[#Headers])","v":38},28,"Credit"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":39},"PA","Pennsylvania",null,null,null,null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefASLinesOfBusiness[#Headers])","v":39},30,"Warranty"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":40},"RI","Rhode Island"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":41},"SC","South Carolina"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":42},"SD","South Dakota"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":43},"TN","Tennessee"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":44},"TX","Texas"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":45},"UT","Utah"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":46},"VT","Vermont"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":47},"VA","Virginia"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":48},"WA","Washington"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":49},"WV","West Virginia"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":50},"WI","Wisconsin"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":51},"WY","Wyoming"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":52},"PR","Puerto Rico"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":53},"AB","Alberta"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":54},"BC","British Columbia"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":55},"MB","Manitoba"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":56},"NB","New Brunswick"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":57},"NL","Newfoundland and Labrador"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":58},"NS","Nova Scotia"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":59},"ON","Ontario"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":60},"PE","Prince Edward Island"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":61},"QC","Quebec"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":62},"SK","Saskatchewan"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":63},"NT","Northwest Territories"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":64},"NU","Nunavut"]
[null,null,null,null,null,null,null,{"$f":"ROW()-ROW(RefLocations[#Headers])","v":65},"YT","Yukon"]

{"sheet":"Output","index":3,"n_rows":46,"n_cols":10,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["EBDEx TABLES"]
[{"$f":"RefNewTableData[Company Program Name]","v":""}]
[]
[]
[]
[null,"Table List"]
[null,"Table Name","Table Comments"]
[null,{"$f":"Ref!F231","v":"Experience"},{"$f":"Ref!G231","v":"SAMPLE TABLE | Company loss experience"}]
[null,{"$f":"Ref!F232","v":"LargeLoss"},{"$f":"Ref!G232","v":"SAMPLE TABLE | Large Loss Listing"}]
[null,{"$f":"Ref!F233","v":"LossTriangle"},{"$f":"Ref!G233","v":"SAMPLE TABLE | Loss triangle"}]
[]
[]
[null,"Experience"]
[null,"Period Start","Period End","Written Premium","Earned Premium","Reported Loss Ratio","Reported Loss"]
[null,"2005-01-01","2005-12-31",9160210.7735555861,4580105.3867777931,0.36528085211414174,1673024.7984547629]
[null,"2006-01-01","2006-12-31",9135547.9853439145,9135547.9853439145,0.37004559974686768,3380569.3332528775]
[null,"2007-01-01","2007-12-31",9284561.1181102078,9284561.1181102078,0.53885909284907252,5003070.1816066373]
[null,"2008-01-01","2008-12-31",9338511.841999704,9338511.841999704,0.593211653145161,5539714.0477083074]
[null,"2009-01-01","2009-12-31",9590833.9939249028,9590833.9939249028,0.51417110039994018,4931329.6684095208]
[null,"2010-01-01","2010-12-31",9086781.6958643459,9086781.6958643459,0.39395529623453657,3579785.7748128031]
[null,"2011-01-01","2011-12-31",9192596.3088024333,8043521.7702021291,0.34182597304281198,2749484.6557903844]
[null,"2012-01-01","2012-06-30",4605638.8085001819,2302819.4042500909,0.43082348765480216,992108.68717817788]
[]
[]
[null,"LargeLoss"]
[null,"Accident Date","Report Date","Line of Business","Paid Loss","Paid ALAE","Loss Reserves","ALAE Reserves"]
[null,"2005-03-01","2005-03-10T03:13:20","Prof Liab",339200,16422.875847479347,628793.39908715955,3284.5751694958694]
[null,"2005-11-11","2005-11-23T16:23:31","Prof Liab",868400,145115.32081022658,13245.935204193744,29023.064162045317]
[null,"2006-05-22","2006-05-22T11:07:09","Prof Liab",1000000,49651.805426531027,0,9930.3610853062055]
[null,"2007-03-02","2007-03-10T14:09:42","GL",805000,78609.374205699118,26135.024807331818,15721.874841139825]
[null,"2007-12-05","2007-12-14T05:13:26","Prof Liab",584300,35539.693992467917,244651.30243699878,7107.9387984935838]
[null,"2008-07-28","2008-08-14T00:42:00","GL",120800,8790.5017295567795,701221.40364721208,1758.100345911356]
[null,"2009-03-24","2009-04-06T12:55:09","GL",421700,2348.0848538398204,23938.960667656222,469.61697076796412]
[null,"2010-01-07","2010-01-26T06:14:23","GL",960700,139187.43998510187,29116.515888290032,27837.487997020376]
[]
[]
[null,"LossTriangle"]
[null,"Accident Year",12,24,36,48,60,72,84,96]
[null,2000,1171171,2342342,3045044.6,3501801.29,3676891.3545000004,3676891.3545000004,3676891.3545000004,3676891.3545000004]
[null,2001,942500.56306781992,2318905.3707697769,3466740.5786516699,3343366.1193566956,3986657.1971168066,4386765.6162584964,4386765.6162584964]
[null,2002,975071.84767104988,2112031.7004306656,2893005.6028115028,3723781.0024309149,4490675.5705105606,5247623.0075215334]
[null,2003,1130353.6470538413,1694267.7648980974,2612999.6150503969,3014685.7380324868,4513268.3516684379]
[null,2004,1025751.3694472624,1387534.8817689265,2687251.5941075487,2822534.5029975651]
[null,2005,967402.85731452121,1281789.9585786345,2469227.7592860875]
[null,2006,803165.72704903944,1355912.8076811922]
[null,2007,859629.01195471163]

{"sheet":"ExhibitTemplate","index":4,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[{"$f":"UPPER(RefNewTableData[Company Program Name])","v":""}]
[0]