{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["FORM 104-NRRA","FORM 104A-NRRA","FORM 104B-NRRA","FORM 104C-NRRA"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":0,"defined_names":4,"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":"FORM 104-NRRA","index":0,"n_rows":62,"n_cols":11,"rows_kept":62,"cut":false,"hidden":false,"merged":[[54,0,54,6],[59,9,59,10],[57,9,57,10],[22,6,22,7],[40,8,40,10],[42,0,44,9],[47,1,47,2],[47,4,47,6],[47,8,47,10],[40,1,40,2],[40,4,40,6],[0,8,0,10],[17,0,17,10],[35,2,35,4],[35,9,35,10],[38,2,38,5],[38,8,38,10],[31,2,31,10],[33,2,33,4],[33,9,33,10],[29,6,29,10]]}
["STATE OF HAWAII",null,null,null,null,null,null,null,"Do Not Write in This Area"]
["DEPARTMENT OF COMMERCE AND CONSUMER AFFAIRS"]
["INSURANCE DIVISION"]
["FORM 104-NRRA SURPLUS LINES PREMIUM TAX STATEMENT AND PAYMENT"]
[]
["INSTRUCTIONS FOR ALL POLICIES SUBJECT TO THE SURPLUS LINES TAX:"]
["1.  Who should file:"]
["2.  Complete Form 104C-NRRA, then complete Form 104-NRRA."]
["3.  Submit completed Forms 104-NRRA, 104A-NRRA, 104B-NRRA and 104C-NRRA."]
["4.  Refer to Act 68, Memorandum 2011-4E and §431:8, Hawaii Revised Statutes ('HRS\") "]
["     for information on the federal Nonadmitted and Reinsurance Reform Act (\"NRRA\") in Hawaii."]
["5.  Supporting documents must be submitted for return premiums, refer to Memorandum 2013-1E  "]
["     and 1/16/2014 email for details."]
[]
[]
[]
[]
["DO NOT FILE THIS FORM IF YOU HAVE NO PREMIUMS OR NO RETURN PREMIUMS TO REPORT."]
[]
["CHECK IF APPLICABLE",null,null,null,"TYPE OF BUSINESS (Check One Box Only)"]
["      100% of risk in Hawaii",null,null,null,"      Surplus Lines Broker (SLB)",null,null,null,null,null,"  Independently Procured (IP) - No SLB involved"]
[]
["REPORTING PERIOD (Check One Box Only)",null,null,null,null,null,"Due Date",null,null,null,"Office Use Only"]
[]
[false,"  January 1, 2017 - March 31, 2017",null,null,null,null,"2017-05-15",null,null,null,3]
[false,"  April 1, 2017 - June 30, 2017",null,null,null,null,"2017-08-15",null,null,null,6]
[false,"  July 1, 2017 - September 30, 2017",null,null,null,null,"2017-11-15",null,null,null,9]
[false,"  October 1, 2017 - December 31, 2017",null,null,null,null,"2018-02-15",null,null,null,12]
[]
["Name of SLB or IP Insured, as applicable:",null,null,null,null,null,{"$f":"IF('FORM 104C-NRRA'!G7=\"\",\"Enter NAME in Form 104C-NRRA\",'FORM 104C-NRRA'!G7)","v":"Enter NAME in Form 104C-NRRA"}]
[]
["Address:"]
[]
[null,"City:",null,null,null,"State:",null,null,"Zip Code:"]
[]
["SLB HI Lic #:",null,{"$f":"IF('FORM 104C-NRRA'!F9=\"\",\"If applicable, enter in Form 104C-NRRA\",'FORM 104C-NRRA'!F9)","v":"If applicable, enter in Form 104C-NRRA"},null,null,"NPN  ",null,null,"State of Domicile:"]
["                      (Not applicable for IP Insured)",null,null,null,null,"     (Not applicable for IP Insured)"]
[]
["Contact Person:",null,null,null,null,null,null,"Title: "]
[]
["Phone:",null,null,"Email:",null,null,null,null,"Check box if email has changed."]
[null,null,null,null,"(As required by HAR 16-171-318)"]
["The undersigned certifies that this is a true and correct statement of all surplus lines business or independently procured insurance transacted where Hawaii is the Home State as defined in Act 68, Session Laws of Hawaii 2011 amendment to  Chapter 431, Article 8, HRS."]
[]
[]
[]
[]
["Date:"]
[null,null,null,null,"Signature of SLB, IP Insured or ",null,null,null,"Print Name of SLB, IP Insured or"]
[null,null,null,null,"Designated Representative",null,null,null,"Designated Representative"]
[]
["Failure to report transactions or remit taxes is a violation subject to sanctions. (HRS §§ 431:8-316 or 431:8-205, as applicable)"]
[]
["Make Checks Payable To: "]
[" DCCA, STATE OF HAWAII ",null,null,null,null,null,null,null,null,"TAXES DUE:"]
[]
["Mailing Address:",null,null,null,null,"Contacts:"]
["State of Hawaii - Insurance Division",null,null,null,null,"InsExamSLB@dcca.hawaii.gov;",null,null,"$",{"$f":"IF('FORM 104C-NRRA'!K60=\"ERROR\",\"ERROR, CHECK FORM 104C-NRRA COL G, H, I OR J\",'FORM 104A-NRRA'!E74)","v":0}]
["335 Merchant Street, Room 213",null,null,null,null,"Gale Miyazaki (808) 587-6741"]
["Honolulu, HI  96813",null,null,null,null,null,null,null,null,"(From Form 104A-NRRA, Line 56, Col D)"]
[]
["Form 104-NRRA (Feb 2017)",null,null,null,null,null,null,null,null,null,"IO2"]

{"sheet":"FORM 104A-NRRA","index":1,"n_rows":74,"n_cols":5,"rows_kept":74,"cut":false,"hidden":false,"merged":[[3,0,3,5],[7,1,7,4],[9,2,9,4],[6,2,6,5],[4,2,4,5]]}
["STATE OF HAWAII"]
["DEPARTMENT OF COMMERCE AND CONSUMER AFFAIRS"]
["INSURANCE DIVISION"]
["FORM 104A-NRRA SURPLUS LINES TAX STATEMENT AND PAYMENT - PREMIUMS WRITTEN BY STATE"]
[null,"Reporting Period:",{"$f":"IF('FORM 104-NRRA'!$A$25=TRUE,'FORM 104-NRRA'!$B$25,IF('FORM 104-NRRA'!$A$26=TRUE,'FORM 104-NRRA'!$B$26,IF('FORM 104-NRRA'!$A$27=TRUE,'FORM 104-NRRA'!$B$27,IF('FORM 104-NRRA'!$A$28=TRUE,'FORM 104-NRRA'!$B$28,\"Select applicable reporting period box on Form 104-NRRA\"))))","v":"Select applicable reporting period box on Form 104-NRRA"}]
[]
["Name of Surplus Lines Broker (SLB) or Independently Procured (IP) Insured:",null,{"$f":"IF('FORM 104C-NRRA'!G7=\"\",\"Enter NAME in Form 104C-NRRA\",'FORM 104C-NRRA'!G7)","v":"Enter NAME in Form 104C-NRRA"}]
[]
[]
["SLB Hawaii License # (not applicable for IP Insured)",null,{"$f":"IF('FORM 104C-NRRA'!F9=\"\",\"If applicable, Enter in Form 104C-NRRA\",'FORM 104C-NRRA'!F9)","v":"If applicable, Enter in Form 104C-NRRA"}]
[]
[null,"Col A","Col B","Col C","Col D"]
[null,"Jurisdiction","Net Premiums Written","Tax Rate","Premium Tax\n(Col B x Col C)"]
[]
[1,"Hawaii",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B15,'FORM 104C-NRRA'!K:K)","v":0},4.6800000000000001E-2,{"$f":"ROUND(C15*D15,2)","v":0}]
[null,"Other States:"]
[{"$f":"A15+1","v":2},"Alabama",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B17,'FORM 104C-NRRA'!K:K)","v":0},0.06,{"$f":"ROUND(C17*D17,2)","v":0}]
[{"$f":"A17+1","v":3},"Alaska",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B18,'FORM 104C-NRRA'!K:K)","v":0},2.7E-2,{"$f":"C18*D18","v":0}]
[4,"American Samoa",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B19,'FORM 104C-NRRA'!K:K)","v":0},null,0]
[5,"Arizona",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B20,'FORM 104C-NRRA'!K:K)","v":0},0.03,0]
[6,"Arkansas",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B21,'FORM 104C-NRRA'!K:K)","v":0},0.04,0]
[7,"California",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B22,'FORM 104C-NRRA'!K:K)","v":0},0.03,0]
[8,"Colorado",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B23,'FORM 104C-NRRA'!K:K)","v":0},0.03,0]
[9,"Connecticut",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B24,'FORM 104C-NRRA'!K:K)","v":0},0.04,0]
[{"$f":"A24+1","v":10},"Delaware",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B25,'FORM 104C-NRRA'!K:K)","v":0},0.02,{"$f":"ROUND(C25*D25,2)","v":0}]
[{"$f":"A25+1","v":11},"District of Columbia",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B26,'FORM 104C-NRRA'!K:K)","v":0},0.02,{"$f":"ROUND(C26*D26,2)","v":0}]
[12,"Florida",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B27,'FORM 104C-NRRA'!K:K)","v":0},0.05,{"$f":"ROUND(C27*D27,2)","v":0}]
[13,"Georgia",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B28,'FORM 104C-NRRA'!K:K)","v":0},0.04,0]
[14,"Guam",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B29,'FORM 104C-NRRA'!K:K)","v":0},0.04,0]
[15,"Idaho",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B30,'FORM 104C-NRRA'!K:K)","v":0},1.4999999999999999E-2,0]
[{"$f":"A30+1","v":16},"Illinois",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B31,'FORM 104C-NRRA'!K:K)","v":0},3.5000000000000003E-2,0]
[{"$f":"A30+1","v":16},"Indiana",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B32,'FORM 104C-NRRA'!K:K)","v":0},2.5000000000000001E-2,0]
[17,"Iowa",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B33,'FORM 104C-NRRA'!K:K)","v":0},0.01,0]
[18,"Kansas",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B34,'FORM 104C-NRRA'!K:K)","v":0},0.06,0]
[19,"Kentucky",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B35,'FORM 104C-NRRA'!K:K)","v":0},0.03,0]
[20,"Louisiana",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B36,'FORM 104C-NRRA'!K:K)","v":0},4.8500000000000001E-2,0]
[21,"Maine",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B37,'FORM 104C-NRRA'!K:K)","v":0},0.03,0]
[22,"Maryland",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B38,'FORM 104C-NRRA'!K:K)","v":0},0.03,0]
[23,"Massachusetts",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B39,'FORM 104C-NRRA'!K:K)","v":0},0.04,0]
[24,"Michigan",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B40,'FORM 104C-NRRA'!K:K)","v":0},0.02,0]
[25,"Minnesota",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B41,'FORM 104C-NRRA'!K:K)","v":0},0.03,0]
[26,"Mississippi",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B42,'FORM 104C-NRRA'!K:K)","v":0},0.04,0]
[27,"Missouri",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B43,'FORM 104C-NRRA'!K:K)","v":0},0.05,0]
[28,"Montana - All P&C other than Fire",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B44,'FORM 104C-NRRA'!K:K)","v":0},2.75E-2,0]
[29,"Montana - Fire",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B45,'FORM 104C-NRRA'!K:K)","v":0},{"$f":"2.75%+2.5%","v":5.2500000000000005E-2},0]
[30,"Nebraska",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B46,'FORM 104C-NRRA'!K:K)","v":0},0.03,0]
[31,"Nevada",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B47,'FORM 104C-NRRA'!K:K)","v":0},3.5000000000000003E-2,0]
[{"$f":"A46+1","v":31},"New Hampshire",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B48,'FORM 104C-NRRA'!K:K)","v":0},0.03,0]
[32,"New Jersey",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B49,'FORM 104C-NRRA'!K:K)","v":0},0.05,0]
[33,"New Mexico",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B50,'FORM 104C-NRRA'!K:K)","v":0},3.0030000000000001E-2,0]
[34,"New York",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B51,'FORM 104C-NRRA'!K:K)","v":0},3.5999999999999997E-2,0]
[{"$f":"A50+1","v":34},"North Carolina",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B52,'FORM 104C-NRRA'!K:K)","v":0},0.05,0]
[35,"North Dakota",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B53,'FORM 104C-NRRA'!K:K)","v":0},1.7500000000000002E-2,0]
[36,"Northern Mariana Islands",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B54,'FORM 104C-NRRA'!K:K)","v":0},null,0]
[37,"Ohio",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B55,'FORM 104C-NRRA'!K:K)","v":0},0.05,0]
[38,"Oklahoma",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B56,'FORM 104C-NRRA'!K:K)","v":0},0.06,0]
[39,"Oregon",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B57,'FORM 104C-NRRA'!K:K)","v":0},2.3E-2,0]
[40,"Pennsylvania",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B58,'FORM 104C-NRRA'!K:K)","v":0},0.03,0]
[41,"Puerto Rico",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B59,'FORM 104C-NRRA'!K:K)","v":0},0.09,0]
[42,"Rhode Island",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B60,'FORM 104C-NRRA'!K:K)","v":0},0.04,0]
[43,"South Carolina",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B61,'FORM 104C-NRRA'!K:K)","v":0},0.06,0]
[44,"South Dakota",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B62,'FORM 104C-NRRA'!K:K)","v":0},2.5000000000000001E-2,0]
[45,"Tennessee",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B63,'FORM 104C-NRRA'!K:K)","v":0},0.05,0]
[46,"Texas",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B64,'FORM 104C-NRRA'!K:K)","v":0},4.8500000000000001E-2,0]
[47,"Utah",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B65,'FORM 104C-NRRA'!K:K)","v":0},4.2500000000000003E-2,0]
[48,"Vermont",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B66,'FORM 104C-NRRA'!K:K)","v":0},0.03,0]
[49,"Virgin Islands",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B67,'FORM 104C-NRRA'!K:K)","v":0},0.05,0]
[50,"Virginia",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B68,'FORM 104C-NRRA'!K:K)","v":0},2.2499999999999999E-2,0]
[51,"Washington",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B69,'FORM 104C-NRRA'!K:K)","v":0},0.02,0]
[52,"West Virginia",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B70,'FORM 104C-NRRA'!K:K)","v":0},4.5499999999999999E-2,0]
[53,"Wisconsin - All P&C other than Marine",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B71,'FORM 104C-NRRA'!K:K)","v":0},0.03,0]
[54,"Wisconsin - Marine",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B72,'FORM 104C-NRRA'!K:K)","v":0},5.0000000000000001E-3,0]
[55,"Wyoming",{"$f":"SUMIF('FORM 104C-NRRA'!H:H,B73,'FORM 104C-NRRA'!K:K)","v":0},0.03,0]
[56,"TOTALS",{"$f":"SUM(C14:C73)","v":0},null,{"$f":"SUM(E14:E73)","v":0}]

{"sheet":"FORM 104B-NRRA","index":2,"n_rows":55,"n_cols":6,"rows_kept":55,"cut":false,"hidden":false,"merged":[[8,1,8,5],[10,2,10,5],[5,2,5,5]]}
[null,"STATE OF HAWAII"]
[null,"DEPARTMENT OF COMMERCE AND CONSUMER AFFAIRS"]
[null,"INSURANCE DIVISION"]
[null,"FORM 104B-NRRA SURPLUS LINES TAX STATEMENT AND PAYMENT - PREMIUMS BY INSURANCE COMPANY"]
[]
[null,"Reporting Period:",{"$f":"IF('FORM 104-NRRA'!$A$25=TRUE,'FORM 104-NRRA'!$B$25,IF('FORM 104-NRRA'!$A$26=TRUE,'FORM 104-NRRA'!$B$26,IF('FORM 104-NRRA'!$A$27=TRUE,'FORM 104-NRRA'!$B$27,IF('FORM 104-NRRA'!$A$28=TRUE,'FORM 104-NRRA'!$B$28,\"Select applicable reporting period box on Form 104-NRRA\"))))","v":"Select applicable reporting period box on Form 104-NRRA"}]
[]
[null,"Name of Surplus Lines Broker (SLB) or Independently Procured (IP) Insured:"]
[null,{"$f":"IF('FORM 104C-NRRA'!G7=\"\",\"Enter NAME in Form 104C-NRRA\",'FORM 104C-NRRA'!G7)","v":"Enter NAME in Form 104C-NRRA"}]
[]
[null,"SLB Hawaii License # (not applicable for IP Insured):",{"$f":"IF('FORM 104C-NRRA'!F9=\"\",\"If applicable, Enter in Form 104C-NRRA\",'FORM 104C-NRRA'!F9)","v":"If applicable, Enter in Form 104C-NRRA"}]
[]
["FORMULA COLUMN","Col A","Col B","Col C","Col D","Col E"]
["Name of Insurance Company (Insurer)","Name of Insurance Company (Insurer)","Insurer      NAIC     CoCode","Gross Premiums Written","Return Premiums","Net Premiums Written"]
[]
[{"$f":"INDEX('FORM 104C-NRRA'!$F$14:$F$58,MATCH(0,IF(ISBLANK('FORM 104C-NRRA'!$F$14:$F$58),\"\",COUNTIF($A$15:A15,'FORM 104C-NRRA'!$F$14:$F$58)),0))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(A16)=TRUE,\"\",T(A16))","v":""},{"$f":"IF($B16=\"\",\"\",VLOOKUP($B16,'FORM 104C-NRRA'!$F:$K,2,FALSE))","v":""},{"$f":"IF($B16=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B16,'FORM 104C-NRRA'!I$14:I$58))","v":""},{"$f":"IF($B16=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B16,'FORM 104C-NRRA'!J$14:J$58))","v":""},{"$f":"IF($B16=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B16,'FORM 104C-NRRA'!K$14:K$58))","v":""}]
[{"$f":"INDEX('FORM 104C-NRRA'!$F$14:$F$58,MATCH(0,IF(ISBLANK('FORM 104C-NRRA'!$F$14:$F$58),\"\",COUNTIF($A$15:A16,'FORM 104C-NRRA'!$F$14:$F$58)),0))","v":{"$error":"#N/A"}},"",{"$f":"IF($B17=\"\",\"\",VLOOKUP($B17,'FORM 104C-NRRA'!$F:$K,2,FALSE))","v":""},{"$f":"IF($B17=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B17,'FORM 104C-NRRA'!I$14:I$58))","v":""},{"$f":"IF($B17=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B17,'FORM 104C-NRRA'!J$14:J$58))","v":""},{"$f":"IF($B17=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B17,'FORM 104C-NRRA'!K$14:K$58))","v":""}]
[{"$f":"INDEX('FORM 104C-NRRA'!$F$14:$F$58,MATCH(0,IF(ISBLANK('FORM 104C-NRRA'!$F$14:$F$58),\"\",COUNTIF($A$15:A17,'FORM 104C-NRRA'!$F$14:$F$58)),0))","v":{"$error":"#N/A"}},"",{"$f":"IF($B18=\"\",\"\",VLOOKUP($B18,'FORM 104C-NRRA'!$F:$K,2,FALSE))","v":""},{"$f":"IF($B18=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B18,'FORM 104C-NRRA'!I$14:I$58))","v":""},{"$f":"IF($B18=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B18,'FORM 104C-NRRA'!J$14:J$58))","v":""},{"$f":"IF($B18=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B18,'FORM 104C-NRRA'!K$14:K$58))","v":""}]
[{"$f":"INDEX('FORM 104C-NRRA'!$F$14:$F$58,MATCH(0,IF(ISBLANK('FORM 104C-NRRA'!$F$14:$F$58),\"\",COUNTIF($A$15:A18,'FORM 104C-NRRA'!$F$14:$F$58)),0))","v":{"$error":"#N/A"}},"",{"$f":"IF($B19=\"\",\"\",VLOOKUP($B19,'FORM 104C-NRRA'!$F:$K,2,FALSE))","v":""},{"$f":"IF($B19=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B19,'FORM 104C-NRRA'!I$14:I$58))","v":""},{"$f":"IF($B19=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B19,'FORM 104C-NRRA'!J$14:J$58))","v":""},{"$f":"IF($B19=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B19,'FORM 104C-NRRA'!K$14:K$58))","v":""}]
[{"$f":"INDEX('FORM 104C-NRRA'!$F$14:$F$58,MATCH(0,IF(ISBLANK('FORM 104C-NRRA'!$F$14:$F$58),\"\",COUNTIF($A$15:A19,'FORM 104C-NRRA'!$F$14:$F$58)),0))","v":{"$error":"#N/A"}},"",{"$f":"IF($B20=\"\",\"\",VLOOKUP($B20,'FORM 104C-NRRA'!$F:$K,2,FALSE))","v":""},{"$f":"IF($B20=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B20,'FORM 104C-NRRA'!I$14:I$58))","v":""},{"$f":"IF($B20=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B20,'FORM 104C-NRRA'!J$14:J$58))","v":""},{"$f":"IF($B20=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B20,'FORM 104C-NRRA'!K$14:K$58))","v":""}]
[{"$f":"INDEX('FORM 104C-NRRA'!$F$14:$F$58,MATCH(0,IF(ISBLANK('FORM 104C-NRRA'!$F$14:$F$58),\"\",COUNTIF($A$15:A20,'FORM 104C-NRRA'!$F$14:$F$58)),0))","v":{"$error":"#N/A"}},"",{"$f":"IF($B21=\"\",\"\",VLOOKUP($B21,'FORM 104C-NRRA'!$F:$K,2,FALSE))","v":""},{"$f":"IF($B21=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B21,'FORM 104C-NRRA'!I$14:I$58))","v":""},{"$f":"IF($B21=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B21,'FORM 104C-NRRA'!J$14:J$58))","v":""},{"$f":"IF($B21=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B21,'FORM 104C-NRRA'!K$14:K$58))","v":""}]
[{"$f":"INDEX('FORM 104C-NRRA'!$F$14:$F$58,MATCH(0,IF(ISBLANK('FORM 104C-NRRA'!$F$14:$F$58),\"\",COUNTIF($A$15:A21,'FORM 104C-NRRA'!$F$14:$F$58)),0))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(A22)=TRUE,\"\",T(A22))","v":""},{"$f":"IF($B22=\"\",\"\",VLOOKUP($B22,'FORM 104C-NRRA'!$F:$K,2,FALSE))","v":""},{"$f":"IF($B22=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B22,'FORM 104C-NRRA'!I$14:I$58))","v":""},{"$f":"IF($B22=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B22,'FORM 104C-NRRA'!J$14:J$58))","v":""},{"$f":"IF($B22=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B22,'FORM 104C-NRRA'!K$14:K$58))","v":""}]
[{"$f":"INDEX('FORM 104C-NRRA'!$F$14:$F$58,MATCH(0,IF(ISBLANK('FORM 104C-NRRA'!$F$14:$F$58),\"\",COUNTIF($A$15:A22,'FORM 104C-NRRA'!$F$14:$F$58)),0))","v":{"$error":"#N/A"}},"",{"$f":"IF($B23=\"\",\"\",VLOOKUP($B23,'FORM 104C-NRRA'!$F:$K,2,FALSE))","v":""},{"$f":"IF($B23=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B23,'FORM 104C-NRRA'!I$14:I$58))","v":""},{"$f":"IF($B23=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B23,'FORM 104C-NRRA'!J$14:J$58))","v":""},{"$f":"IF($B23=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B23,'FORM 104C-NRRA'!K$14:K$58))","v":""}]
[{"$f":"INDEX('FORM 104C-NRRA'!$F$14:$F$58,MATCH(0,IF(ISBLANK('FORM 104C-NRRA'!$F$14:$F$58),\"\",COUNTIF($A$15:A23,'FORM 104C-NRRA'!$F$14:$F$58)),0))","v":{"$error":"#N/A"}},"",{"$f":"IF($B24=\"\",\"\",VLOOKUP($B24,'FORM 104C-NRRA'!$F:$K,2,FALSE))","v":""},{"$f":"IF($B24=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B24,'FORM 104C-NRRA'!I$14:I$58))","v":""},{"$f":"IF($B24=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B24,'FORM 104C-NRRA'!J$14:J$58))","v":""},{"$f":"IF($B24=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B24,'FORM 104C-NRRA'!K$14:K$58))","v":""}]
[{"$f":"INDEX('FORM 104C-NRRA'!$F$14:$F$58,MATCH(0,IF(ISBLANK('FORM 104C-NRRA'!$F$14:$F$58),\"\",COUNTIF($A$15:A24,'FORM 104C-NRRA'!$F$14:$F$58)),0))","v":{"$error":"#N/A"}},"",{"$f":"IF($B25=\"\",\"\",VLOOKUP($B25,'FORM 104C-NRRA'!$F:$K,2,FALSE))","v":""},{"$f":"IF($B25=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B25,'FORM 104C-NRRA'!I$14:I$58))","v":""},{"$f":"IF($B25=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B25,'FORM 104C-NRRA'!J$14:J$58))","v":""},{"$f":"IF($B25=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B25,'FORM 104C-NRRA'!K$14:K$58))","v":""}]
[{"$f":"INDEX('FORM 104C-NRRA'!$F$14:$F$58,MATCH(0,IF(ISBLANK('FORM 104C-NRRA'!$F$14:$F$58),\"\",COUNTIF($A$15:A25,'FORM 104C-NRRA'!$F$14:$F$58)),0))","v":{"$error":"#N/A"}},"",{"$f":"IF($B26=\"\",\"\",VLOOKUP($B26,'FORM 104C-NRRA'!$F:$K,2,FALSE))","v":""},{"$f":"IF($B26=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B26,'FORM 104C-NRRA'!I$14:I$58))","v":""},{"$f":"IF($B26=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B26,'FORM 104C-NRRA'!J$14:J$58))","v":""},{"$f":"IF($B26=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B26,'FORM 104C-NRRA'!K$14:K$58))","v":""}]
[{"$f":"INDEX('FORM 104C-NRRA'!$F$14:$F$58,MATCH(0,IF(ISBLANK('FORM 104C-NRRA'!$F$14:$F$58),\"\",COUNTIF($A$15:A26,'FORM 104C-NRRA'!$F$14:$F$58)),0))","v":{"$error":"#N/A"}},"",{"$f":"IF($B27=\"\",\"\",VLOOKUP($B27,'FORM 104C-NRRA'!$F:$K,2,FALSE))","v":""},{"$f":"IF($B27=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B27,'FORM 104C-NRRA'!I$14:I$58))","v":""},{"$f":"IF($B27=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B27,'FORM 104C-NRRA'!J$14:J$58))","v":""},{"$f":"IF($B27=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B27,'FORM 104C-NRRA'!K$14:K$58))","v":""}]
[{"$f":"INDEX('FORM 104C-NRRA'!$F$14:$F$58,MATCH(0,IF(ISBLANK('FORM 104C-NRRA'!$F$14:$F$58),\"\",COUNTIF($A$15:A27,'FORM 104C-NRRA'!$F$14:$F$58)),0))","v":{"$error":"#N/A"}},"",{"$f":"IF($B28=\"\",\"\",VLOOKUP($B28,'FORM 104C-NRRA'!$F:$K,2,FALSE))","v":""},{"$f":"IF($B28=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B28,'FORM 104C-NRRA'!I$14:I$58))","v":""},{"$f":"IF($B28=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B28,'FORM 104C-NRRA'!J$14:J$58))","v":""},{"$f":"IF($B28=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B28,'FORM 104C-NRRA'!K$14:K$58))","v":""}]
[{"$f":"INDEX('FORM 104C-NRRA'!$F$14:$F$58,MATCH(0,IF(ISBLANK('FORM 104C-NRRA'!$F$14:$F$58),\"\",COUNTIF($A$15:A28,'FORM 104C-NRRA'!$F$14:$F$58)),0))","v":{"$error":"#N/A"}},"",{"$f":"IF($B29=\"\",\"\",VLOOKUP($B29,'FORM 104C-NRRA'!$F:$K,2,FALSE))","v":""},{"$f":"IF($B29=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B29,'FORM 104C-NRRA'!I$14:I$58))","v":""},{"$f":"IF($B29=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B29,'FORM 104C-NRRA'!J$14:J$58))","v":""},{"$f":"IF($B29=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B29,'FORM 104C-NRRA'!K$14:K$58))","v":""}]
[{"$f":"INDEX('FORM 104C-NRRA'!$F$14:$F$58,MATCH(0,IF(ISBLANK('FORM 104C-NRRA'!$F$14:$F$58),\"\",COUNTIF($A$15:A29,'FORM 104C-NRRA'!$F$14:$F$58)),0))","v":{"$error":"#N/A"}},"",{"$f":"IF($B30=\"\",\"\",VLOOKUP($B30,'FORM 104C-NRRA'!$F:$K,2,FALSE))","v":""},{"$f":"IF($B30=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B30,'FORM 104C-NRRA'!I$14:I$58))","v":""},{"$f":"IF($B30=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B30,'FORM 104C-NRRA'!J$14:J$58))","v":""},{"$f":"IF($B30=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B30,'FORM 104C-NRRA'!K$14:K$58))","v":""}]
[{"$f":"INDEX('FORM 104C-NRRA'!$F$14:$F$58,MATCH(0,IF(ISBLANK('FORM 104C-NRRA'!$F$14:$F$58),\"\",COUNTIF($A$15:A30,'FORM 104C-NRRA'!$F$14:$F$58)),0))","v":{"$error":"#N/A"}},"",{"$f":"IF($B31=\"\",\"\",VLOOKUP($B31,'FORM 104C-NRRA'!$F:$K,2,FALSE))","v":""},{"$f":"IF($B31=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B31,'FORM 104C-NRRA'!I$14:I$58))","v":""},{"$f":"IF($B31=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B31,'FORM 104C-NRRA'!J$14:J$58))","v":""},{"$f":"IF($B31=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B31,'FORM 104C-NRRA'!K$14:K$58))","v":""}]
[{"$f":"INDEX('FORM 104C-NRRA'!$F$14:$F$58,MATCH(0,IF(ISBLANK('FORM 104C-NRRA'!$F$14:$F$58),\"\",COUNTIF($A$15:A31,'FORM 104C-NRRA'!$F$14:$F$58)),0))","v":{"$error":"#N/A"}},"",{"$f":"IF($B32=\"\",\"\",VLOOKUP($B32,'FORM 104C-NRRA'!$F:$K,2,FALSE))","v":""},{"$f":"IF($B32=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B32,'FORM 104C-NRRA'!I$14:I$58))","v":""},{"$f":"IF($B32=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B32,'FORM 104C-NRRA'!J$14:J$58))","v":""},{"$f":"IF($B32=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B32,'FORM 104C-NRRA'!K$14:K$58))","v":""}]
[{"$f":"INDEX('FORM 104C-NRRA'!$F$14:$F$58,MATCH(0,IF(ISBLANK('FORM 104C-NRRA'!$F$14:$F$58),\"\",COUNTIF($A$15:A32,'FORM 104C-NRRA'!$F$14:$F$58)),0))","v":{"$error":"#N/A"}},"",{"$f":"IF($B33=\"\",\"\",VLOOKUP($B33,'FORM 104C-NRRA'!$F:$K,2,FALSE))","v":""},{"$f":"IF($B33=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B33,'FORM 104C-NRRA'!I$14:I$58))","v":""},{"$f":"IF($B33=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B33,'FORM 104C-NRRA'!J$14:J$58))","v":""},{"$f":"IF($B33=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B33,'FORM 104C-NRRA'!K$14:K$58))","v":""}]
[{"$f":"INDEX('FORM 104C-NRRA'!$F$14:$F$58,MATCH(0,IF(ISBLANK('FORM 104C-NRRA'!$F$14:$F$58),\"\",COUNTIF($A$15:A33,'FORM 104C-NRRA'!$F$14:$F$58)),0))","v":{"$error":"#N/A"}},"",{"$f":"IF($B34=\"\",\"\",VLOOKUP($B34,'FORM 104C-NRRA'!$F:$K,2,FALSE))","v":""},{"$f":"IF($B34=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B34,'FORM 104C-NRRA'!I$14:I$58))","v":""},{"$f":"IF($B34=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B34,'FORM 104C-NRRA'!J$14:J$58))","v":""},{"$f":"IF($B34=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B34,'FORM 104C-NRRA'!K$14:K$58))","v":""}]
[{"$f":"INDEX('FORM 104C-NRRA'!$F$14:$F$58,MATCH(0,IF(ISBLANK('FORM 104C-NRRA'!$F$14:$F$58),\"\",COUNTIF($A$15:A34,'FORM 104C-NRRA'!$F$14:$F$58)),0))","v":{"$error":"#N/A"}},"",{"$f":"IF($B35=\"\",\"\",VLOOKUP($B35,'FORM 104C-NRRA'!$F:$K,2,FALSE))","v":""},{"$f":"IF($B35=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B35,'FORM 104C-NRRA'!I$14:I$58))","v":""},{"$f":"IF($B35=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B35,'FORM 104C-NRRA'!J$14:J$58))","v":""},{"$f":"IF($B35=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B35,'FORM 104C-NRRA'!K$14:K$58))","v":""}]
[{"$f":"INDEX('FORM 104C-NRRA'!$F$14:$F$58,MATCH(0,IF(ISBLANK('FORM 104C-NRRA'!$F$14:$F$58),\"\",COUNTIF($A$15:A35,'FORM 104C-NRRA'!$F$14:$F$58)),0))","v":{"$error":"#N/A"}},"",{"$f":"IF($B36=\"\",\"\",VLOOKUP($B36,'FORM 104C-NRRA'!$F:$K,2,FALSE))","v":""},{"$f":"IF($B36=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B36,'FORM 104C-NRRA'!I$14:I$58))","v":""},{"$f":"IF($B36=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B36,'FORM 104C-NRRA'!J$14:J$58))","v":""},{"$f":"IF($B36=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B36,'FORM 104C-NRRA'!K$14:K$58))","v":""}]
[{"$f":"INDEX('FORM 104C-NRRA'!$F$14:$F$58,MATCH(0,IF(ISBLANK('FORM 104C-NRRA'!$F$14:$F$58),\"\",COUNTIF($A$15:A36,'FORM 104C-NRRA'!$F$14:$F$58)),0))","v":{"$error":"#N/A"}},"",{"$f":"IF($B37=\"\",\"\",VLOOKUP($B37,'FORM 104C-NRRA'!$F:$K,2,FALSE))","v":""},{"$f":"IF($B37=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B37,'FORM 104C-NRRA'!I$14:I$58))","v":""},{"$f":"IF($B37=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B37,'FORM 104C-NRRA'!J$14:J$58))","v":""},{"$f":"IF($B37=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B37,'FORM 104C-NRRA'!K$14:K$58))","v":""}]
[{"$f":"INDEX('FORM 104C-NRRA'!$F$14:$F$58,MATCH(0,IF(ISBLANK('FORM 104C-NRRA'!$F$14:$F$58),\"\",COUNTIF($A$15:A37,'FORM 104C-NRRA'!$F$14:$F$58)),0))","v":{"$error":"#N/A"}},"",{"$f":"IF($B38=\"\",\"\",VLOOKUP($B38,'FORM 104C-NRRA'!$F:$K,2,FALSE))","v":""},{"$f":"IF($B38=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B38,'FORM 104C-NRRA'!I$14:I$58))","v":""},{"$f":"IF($B38=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B38,'FORM 104C-NRRA'!J$14:J$58))","v":""},{"$f":"IF($B38=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B38,'FORM 104C-NRRA'!K$14:K$58))","v":""}]
[{"$f":"INDEX('FORM 104C-NRRA'!$F$14:$F$58,MATCH(0,IF(ISBLANK('FORM 104C-NRRA'!$F$14:$F$58),\"\",COUNTIF($A$15:A38,'FORM 104C-NRRA'!$F$14:$F$58)),0))","v":{"$error":"#N/A"}},"",{"$f":"IF($B39=\"\",\"\",VLOOKUP($B39,'FORM 104C-NRRA'!$F:$K,2,FALSE))","v":""},{"$f":"IF($B39=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B39,'FORM 104C-NRRA'!I$14:I$58))","v":""},{"$f":"IF($B39=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B39,'FORM 104C-NRRA'!J$14:J$58))","v":""},{"$f":"IF($B39=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B39,'FORM 104C-NRRA'!K$14:K$58))","v":""}]
[{"$f":"INDEX('FORM 104C-NRRA'!$F$14:$F$58,MATCH(0,IF(ISBLANK('FORM 104C-NRRA'!$F$14:$F$58),\"\",COUNTIF($A$15:A39,'FORM 104C-NRRA'!$F$14:$F$58)),0))","v":{"$error":"#N/A"}},"",{"$f":"IF($B40=\"\",\"\",VLOOKUP($B40,'FORM 104C-NRRA'!$F:$K,2,FALSE))","v":""},{"$f":"IF($B40=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B40,'FORM 104C-NRRA'!I$14:I$58))","v":""},{"$f":"IF($B40=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B40,'FORM 104C-NRRA'!J$14:J$58))","v":""},{"$f":"IF($B40=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B40,'FORM 104C-NRRA'!K$14:K$58))","v":""}]
[{"$f":"INDEX('FORM 104C-NRRA'!$F$14:$F$58,MATCH(0,IF(ISBLANK('FORM 104C-NRRA'!$F$14:$F$58),\"\",COUNTIF($A$15:A40,'FORM 104C-NRRA'!$F$14:$F$58)),0))","v":{"$error":"#N/A"}},"",{"$f":"IF($B41=\"\",\"\",VLOOKUP($B41,'FORM 104C-NRRA'!$F:$K,2,FALSE))","v":""},{"$f":"IF($B41=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B41,'FORM 104C-NRRA'!I$14:I$58))","v":""},{"$f":"IF($B41=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B41,'FORM 104C-NRRA'!J$14:J$58))","v":""},{"$f":"IF($B41=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B41,'FORM 104C-NRRA'!K$14:K$58))","v":""}]
[{"$f":"INDEX('FORM 104C-NRRA'!$F$14:$F$58,MATCH(0,IF(ISBLANK('FORM 104C-NRRA'!$F$14:$F$58),\"\",COUNTIF($A$15:A41,'FORM 104C-NRRA'!$F$14:$F$58)),0))","v":{"$error":"#N/A"}},"",{"$f":"IF($B42=\"\",\"\",VLOOKUP($B42,'FORM 104C-NRRA'!$F:$K,2,FALSE))","v":""},{"$f":"IF($B42=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B42,'FORM 104C-NRRA'!I$14:I$58))","v":""},{"$f":"IF($B42=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B42,'FORM 104C-NRRA'!J$14:J$58))","v":""},{"$f":"IF($B42=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B42,'FORM 104C-NRRA'!K$14:K$58))","v":""}]
[{"$f":"INDEX('FORM 104C-NRRA'!$F$14:$F$58,MATCH(0,IF(ISBLANK('FORM 104C-NRRA'!$F$14:$F$58),\"\",COUNTIF($A$15:A42,'FORM 104C-NRRA'!$F$14:$F$58)),0))","v":{"$error":"#N/A"}},"",{"$f":"IF($B43=\"\",\"\",VLOOKUP($B43,'FORM 104C-NRRA'!$F:$K,2,FALSE))","v":""},{"$f":"IF($B43=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B43,'FORM 104C-NRRA'!I$14:I$58))","v":""},{"$f":"IF($B43=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B43,'FORM 104C-NRRA'!J$14:J$58))","v":""},{"$f":"IF($B43=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B43,'FORM 104C-NRRA'!K$14:K$58))","v":""}]
[{"$f":"INDEX('FORM 104C-NRRA'!$F$14:$F$58,MATCH(0,IF(ISBLANK('FORM 104C-NRRA'!$F$14:$F$58),\"\",COUNTIF($A$15:A43,'FORM 104C-NRRA'!$F$14:$F$58)),0))","v":{"$error":"#N/A"}},"",{"$f":"IF($B44=\"\",\"\",VLOOKUP($B44,'FORM 104C-NRRA'!$F:$K,2,FALSE))","v":""},{"$f":"IF($B44=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B44,'FORM 104C-NRRA'!I$14:I$58))","v":""},{"$f":"IF($B44=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B44,'FORM 104C-NRRA'!J$14:J$58))","v":""},{"$f":"IF($B44=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B44,'FORM 104C-NRRA'!K$14:K$58))","v":""}]
[{"$f":"INDEX('FORM 104C-NRRA'!$F$14:$F$58,MATCH(0,IF(ISBLANK('FORM 104C-NRRA'!$F$14:$F$58),\"\",COUNTIF($A$15:A44,'FORM 104C-NRRA'!$F$14:$F$58)),0))","v":{"$error":"#N/A"}},"",{"$f":"IF($B45=\"\",\"\",VLOOKUP($B45,'FORM 104C-NRRA'!$F:$K,2,FALSE))","v":""},{"$f":"IF($B45=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B45,'FORM 104C-NRRA'!I$14:I$58))","v":""},{"$f":"IF($B45=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B45,'FORM 104C-NRRA'!J$14:J$58))","v":""},{"$f":"IF($B45=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B45,'FORM 104C-NRRA'!K$14:K$58))","v":""}]
[{"$f":"INDEX('FORM 104C-NRRA'!$F$14:$F$58,MATCH(0,IF(ISBLANK('FORM 104C-NRRA'!$F$14:$F$58),\"\",COUNTIF($A$15:A45,'FORM 104C-NRRA'!$F$14:$F$58)),0))","v":{"$error":"#N/A"}},"",{"$f":"IF($B46=\"\",\"\",VLOOKUP($B46,'FORM 104C-NRRA'!$F:$K,2,FALSE))","v":""},{"$f":"IF($B46=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B46,'FORM 104C-NRRA'!I$14:I$58))","v":""},{"$f":"IF($B46=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B46,'FORM 104C-NRRA'!J$14:J$58))","v":""},{"$f":"IF($B46=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B46,'FORM 104C-NRRA'!K$14:K$58))","v":""}]
[{"$f":"INDEX('FORM 104C-NRRA'!$F$14:$F$58,MATCH(0,IF(ISBLANK('FORM 104C-NRRA'!$F$14:$F$58),\"\",COUNTIF($A$15:A46,'FORM 104C-NRRA'!$F$14:$F$58)),0))","v":{"$error":"#N/A"}},"",{"$f":"IF($B47=\"\",\"\",VLOOKUP($B47,'FORM 104C-NRRA'!$F:$K,2,FALSE))","v":""},{"$f":"IF($B47=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B47,'FORM 104C-NRRA'!I$14:I$58))","v":""},{"$f":"IF($B47=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B47,'FORM 104C-NRRA'!J$14:J$58))","v":""},{"$f":"IF($B47=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B47,'FORM 104C-NRRA'!K$14:K$58))","v":""}]
[{"$f":"INDEX('FORM 104C-NRRA'!$F$14:$F$58,MATCH(0,IF(ISBLANK('FORM 104C-NRRA'!$F$14:$F$58),\"\",COUNTIF($A$15:A47,'FORM 104C-NRRA'!$F$14:$F$58)),0))","v":{"$error":"#N/A"}},"",{"$f":"IF($B48=\"\",\"\",VLOOKUP($B48,'FORM 104C-NRRA'!$F:$K,2,FALSE))","v":""},{"$f":"IF($B48=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B48,'FORM 104C-NRRA'!I$14:I$58))","v":""},{"$f":"IF($B48=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B48,'FORM 104C-NRRA'!J$14:J$58))","v":""},{"$f":"IF($B48=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B48,'FORM 104C-NRRA'!K$14:K$58))","v":""}]
[{"$f":"INDEX('FORM 104C-NRRA'!$F$14:$F$58,MATCH(0,IF(ISBLANK('FORM 104C-NRRA'!$F$14:$F$58),\"\",COUNTIF($A$15:A48,'FORM 104C-NRRA'!$F$14:$F$58)),0))","v":{"$error":"#N/A"}},"",{"$f":"IF($B49=\"\",\"\",VLOOKUP($B49,'FORM 104C-NRRA'!$F:$K,2,FALSE))","v":""},{"$f":"IF($B49=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B49,'FORM 104C-NRRA'!I$14:I$58))","v":""},{"$f":"IF($B49=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B49,'FORM 104C-NRRA'!J$14:J$58))","v":""},{"$f":"IF($B49=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B49,'FORM 104C-NRRA'!K$14:K$58))","v":""}]
[{"$f":"INDEX('FORM 104C-NRRA'!$F$14:$F$58,MATCH(0,IF(ISBLANK('FORM 104C-NRRA'!$F$14:$F$58),\"\",COUNTIF($A$15:A49,'FORM 104C-NRRA'!$F$14:$F$58)),0))","v":{"$error":"#N/A"}},"",{"$f":"IF($B50=\"\",\"\",VLOOKUP($B50,'FORM 104C-NRRA'!$F:$K,2,FALSE))","v":""},{"$f":"IF($B50=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B50,'FORM 104C-NRRA'!I$14:I$58))","v":""},{"$f":"IF($B50=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B50,'FORM 104C-NRRA'!J$14:J$58))","v":""},{"$f":"IF($B50=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B50,'FORM 104C-NRRA'!K$14:K$58))","v":""}]
[{"$f":"INDEX('FORM 104C-NRRA'!$F$14:$F$58,MATCH(0,IF(ISBLANK('FORM 104C-NRRA'!$F$14:$F$58),\"\",COUNTIF($A$15:A50,'FORM 104C-NRRA'!$F$14:$F$58)),0))","v":{"$error":"#N/A"}},"",{"$f":"IF($B51=\"\",\"\",VLOOKUP($B51,'FORM 104C-NRRA'!$F:$K,2,FALSE))","v":""},{"$f":"IF($B51=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B51,'FORM 104C-NRRA'!I$14:I$58))","v":""},{"$f":"IF($B51=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B51,'FORM 104C-NRRA'!J$14:J$58))","v":""},{"$f":"IF($B51=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B51,'FORM 104C-NRRA'!K$14:K$58))","v":""}]
[{"$f":"INDEX('FORM 104C-NRRA'!$F$14:$F$58,MATCH(0,IF(ISBLANK('FORM 104C-NRRA'!$F$14:$F$58),\"\",COUNTIF($A$15:A51,'FORM 104C-NRRA'!$F$14:$F$58)),0))","v":{"$error":"#N/A"}},"",{"$f":"IF($B52=\"\",\"\",VLOOKUP($B52,'FORM 104C-NRRA'!$F:$K,2,FALSE))","v":""},{"$f":"IF($B52=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B52,'FORM 104C-NRRA'!I$14:I$58))","v":""},{"$f":"IF($B52=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B52,'FORM 104C-NRRA'!J$14:J$58))","v":""},{"$f":"IF($B52=\"\",\"\",SUMIF('FORM 104C-NRRA'!$F$14:$F$58,$B52,'FORM 104C-NRRA'!K$14:K$58))","v":""}]
[]
[]
[null,null,null,{"$f":"SUM(D15:D54)","v":0},{"$f":"SUM(E15:E54)","v":0},{"$f":"SUM(F15:F54)","v":0}]

{"sheet":"FORM 104C-NRRA","index":3,"n_rows":120,"n_cols":11,"rows_kept":120,"cut":false,"hidden":false,"merged":[[6,6,6,10],[4,8,4,10]]}
["STATE OF HAWAII"]
["DEPARTMENT OF COMMERCE AND CONSUMER AFFAIRS"]
["INSURANCE DIVISION"]
["FORM 104C-NRRA SURPLUS LINES TAX STATEMENT AND PAYMENT - PREMIUMS WRITTEN BY POLICY"]
[null,null,null,null,null,null,null,"Reporting Period:",{"$f":"IF('FORM 104-NRRA'!$A$25=TRUE,'FORM 104-NRRA'!$B$25,IF('FORM 104-NRRA'!$A$26=TRUE,'FORM 104-NRRA'!$B$26,IF('FORM 104-NRRA'!$A$27=TRUE,'FORM 104-NRRA'!$B$27,IF('FORM 104-NRRA'!$A$28=TRUE,'FORM 104-NRRA'!$B$28,\"Select applicable reporting period box on Form 104-NRRA\"))))","v":"Select applicable reporting period box on Form 104-NRRA"}]
[]
["Name of Surplus Lines Broker (SLB) or Independently Procured (IP) Insured:"]
[]
["SLB Hawaii License # (not applicable for IP Insured):"]
[]
["Col A","Col B","Col C",null,"Col D","Col E","Col F","Col G","Col H","Col I","Col J"]
["Effective Date of Policy (MM/DD/YYYY)","Policy Number","Transaction\nType","Effective Date of Cancellation, Endorsement, Audit (MM/DD/YYYY)","Name of Insured","Name of Insurance Company (Insurer)","Insurer\nNAICCoCode ","State Where Risk is Located","Gross Premiums Written\n(Enter as Positive)","Return Premiums (Enter as Negative)","Net Premiums Written"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H13=\"\",0,IF((I13<0),\"ERROR, COL H\",IF((J13>0),\"ERROR, COL I\",I13+J13)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H14=\"\",0,IF((I14<0),\"ERROR, COL H\",IF((J14>0),\"ERROR, COL I\",I14+J14)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H15=\"\",0,IF((I15<0),\"ERROR, COL H\",IF((J15>0),\"ERROR, COL I\",I15+J15)))","v":0}]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
["If necessary, insert addtional rows above and copy formula in Column J."]
[]
[null,null,null,null,null,null,null,"TOTALS",{"$f":"SUM(I13:I59)","v":0},{"$f":"SUM(J13:J59)","v":0},{"$f":"IF(I60+J60=SUM(K13:K59),SUM(K13:K59),\"ERROR\")","v":0}]
[]
[]
[null,null,"N - New",null,null,null,null,"Alabama"]
[null,null,"R - Renewal",null,null,null,null,"Alaska"]
[null,null,"C - Cancelled",null,null,null,null,"American Samoa"]
[null,null,"E - Endorsement",null,null,null,null,"Arizona"]
[null,null,"A - Audit",null,null,null,null,"Arkansas"]
[null,null,null,null,null,null,null,"California"]
[null,null,null,null,null,null,null,"Colorado"]
[null,null,null,null,null,null,null,"Connecticut"]
[null,null,null,null,null,null,null,"Delaware"]
[null,null,null,null,null,null,null,"District of Columbia"]
[null,null,null,null,null,null,null,"Florida"]
[null,null,null,null,null,null,null,"Georgia"]
[null,null,null,null,null,null,null,"Guam"]
[null,null,null,null,null,null,null,"Hawaii"]
[null,null,null,null,null,null,null,"Idaho"]
[null,null,null,null,null,null,null,"Illinois"]
[null,null,null,null,null,null,null,"Indiana"]
[null,null,null,null,null,null,null,"Iowa"]
[null,null,null,null,null,null,null,"Kansas"]
[null,null,null,null,null,null,null,"Kentucky"]
[null,null,null,null,null,null,null,"Louisiana"]
[null,null,null,null,null,null,null,"Maine"]
[null,null,null,null,null,null,null,"Maryland"]
[null,null,null,null,null,null,null,"Massachusetts"]
[null,null,null,null,null,null,null,"Michigan"]
[null,null,null,null,null,null,null,"Minnesota"]
[null,null,null,null,null,null,null,"Mississippi"]
[null,null,null,null,null,null,null,"Missouri"]
[null,null,null,null,null,null,null,"Montana - All P&C other than Fire"]
[null,null,null,null,null,null,null,"Montana - Fire"]
[null,null,null,null,null,null,null,"Nebraska"]
[null,null,null,null,null,null,null,"Nevada"]
[null,null,null,null,null,null,null,"New Hampshire"]
[null,null,null,null,null,null,null,"New Jersey"]
[null,null,null,null,null,null,null,"New Mexico"]
[null,null,null,null,null,null,null,"New York"]
[null,null,null,null,null,null,null,"North Carolina"]
[null,null,null,null,null,null,null,"North Dakota"]
[null,null,null,null,null,null,null,"Northern Mariana Islands"]
[null,null,null,null,null,null,null,"Ohio"]
[null,null,null,null,null,null,null,"Oklahoma"]
[null,null,null,null,null,null,null,"Oregon"]
[null,null,null,null,null,null,null,"Pennsylvania"]
[null,null,null,null,null,null,null,"Puerto Rico"]
[null,null,null,null,null,null,null,"Rhode Island"]
[null,null,null,null,null,null,null,"South Carolina"]
[null,null,null,null,null,null,null,"South Dakota"]
[null,null,null,null,null,null,null,"Tennessee"]
[null,null,null,null,null,null,null,"Texas"]
[null,null,null,null,null,null,null,"Utah"]
[null,null,null,null,null,null,null,"Vermont"]
[null,null,null,null,null,null,null,"Virgin Islands"]
[null,null,null,null,null,null,null,"Virginia"]
[null,null,null,null,null,null,null,"Washington"]
[null,null,null,null,null,null,null,"West Virginia"]
[null,null,null,null,null,null,null,"Wisconsin - All P&C other than Marine"]
[null,null,null,null,null,null,null,"Wisconsin - Marine"]
[null,null,null,null,null,null,null,"Wyoming"]