{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Summary","Payroll","Other Expenses","Additional Covered Expenses"],"not_rendered":{"images":1,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":29,"n_cols":9,"rows_kept":29,"merged":[[5,4,5,8],[11,1,11,3],[11,4,11,6]]}
[]
["Bank of Hawaii Paycheck Protection Program Loan Forgiveness Application Worksheet"]
[]
[null,"For detailed guidance on applying for SBA PPP Loan Forgiveness, please refer this SBA site:",{"$nulls":6},"SBA PPP Site"]
[]
[null,"Input PPP Borrower Name:"]
[null,"Input SBA PPP # Number:"]
[null,"Input SBA Loan Amount:",null,null,{"v":0,"d":"$0.00"}]
[null,"Covered Period:",null,"From","00:00:00","To:","00:00:00",{"$f":"+(G9-E9)/7","v":0},"Est # of Weeks"]
[null,"Note: Covered Period can range between 8 to 24 week period"]
[]
[null,"Payment Categories",null,null,"Sub-Categories",null,null,"Total Cost"]
[null,"Payroll Related:",null,null,"Payroll Payments",null,null,{"$f":"+Payroll!E7","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"Taxes",null,null,{"$f":"+Payroll!E8","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"Employer Paid Health Insurance - Primary",null,null,{"$f":"+Payroll!E9","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"Employer Paid Health Insurance - Secondary",null,null,{"$f":"+Payroll!E10","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"Employer Paid Retirement Benefits - Primary",null,null,{"$f":"+Payroll!E11","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"Employer Paid Retirement Benefits - Secondary",null,null,{"$f":"+Payroll!E12","v":{"v":0,"d":"$0.00"}}]
[null,"Other Expenses:",null,null,"Business Mortgage Interest Payment",null,null,{"$f":"+'Other Expenses'!F5","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"Business Rent or Lease Payments",null,null,{"$f":"+'Other Expenses'!F6","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"Total Utilities Payments",null,null,{"$f":"SUM('Other Expenses'!F7,'Other Expenses'!F8,'Other Expenses'!L5,'Other Expenses'!L6,'Other Expenses'!L7,'Other Expenses'!L8)","v":{"v":0,"d":"$0.00"}}]
[null,"Additional Covered Expenses:",null,null,"Business Software or Cloud Computing Services",null,null,{"$f":"+'Additional Covered Expenses'!F5","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"Covered Property Damage",null,null,{"$f":"+'Additional Covered Expenses'!F6","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"Covered Supplier Cost",null,null,{"$f":"+'Additional Covered Expenses'!F7","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":4},"Worker Protection Expenditure",null,null,{"$f":"+'Additional Covered Expenses'!F8","v":{"v":0,"d":"$0.00"}}]
[null,"Total Costs",{"$nulls":5},{"$f":"SUM(H13:H25)","v":{"v":0,"d":"$0.00"}}]
[]
[null,"Total Payroll Related Payments",{"$nulls":5},{"$f":"SUM(H13:H17)","v":{"v":0,"d":"$0.00"}}]
[null,"Total Other Payment",{"$nulls":5},{"$f":"SUM(H19:H25)","v":{"v":0,"d":"$0.00"}}]

{"sheet":"Payroll","index":1,"n_rows":124,"n_cols":16,"rows_kept":124,"merged":[[2,0,2,11],[3,4,3,7],[5,4,5,8],[14,5,14,6],[14,9,14,11],[15,7,15,8],[16,7,16,8],[16,14,17,19],[17,7,17,8],[18,7,18,8],[19,7,19,8],[19,14,25,19],[20,7,20,8],[21,7,21,8],[22,7,22,8],[23,7,23,8],[24,7,24,8],[25,7,25,8],[26,7,26,8],[26,14,29,19],[27,7,27,8],[28,7,28,8],[29,7,29,8],[30,7,30,8],[30,14,32,19],[31,7,31,8],[32,7,32,8],[33,7,33,8],[33,15,34,19],[34,7,34,8],[35,7,35,8],[35,15,36,19],[36,7,36,8],[37,7,37,8],[37,15,38,19],[38,7,38,8],[39,7,39,8],[43,1,43,5],[44,4,44,5],[45,4,45,5],[46,4,46,5],[47,4,47,5],[48,4,48,5],[49,4,49,5],[50,4,50,5],[51,4,51,5],[52,4,52,5],[53,4,53,5],[54,4,54,5],[55,4,55,5],[56,4,56,5],[57,4,57,5],[58,4,58,5],[59,4,59,5],[60,4,60,5],[61,4,61,5],[62,4,62,5],[63,4,63,5],[64,4,64,5],[65,4,65,5],[66,4,66,5],[67,4,67,5],[68,4,68,5],[71,1,71,5],[71,7,71,11],[72,4,72,5],[72,10,72,11],[73,4,73,5],[73,10,73,11],[74,4,74,5],[74,10,74,11],[75,4,75,5],[75,10,75,11],[76,4,76,5],[76,10,76,11],[77,4,77,5],[77,10,77,11],[78,4,78,5],[78,10,78,11],[79,4,79,5],[79,10,79,11],[80,4,80,5],[80,10,80,11],[81,4,81,5],[81,10,81,11],[82,4,82,5],[82,10,82,11],[83,4,83,5],[83,10,83,11],[84,4,84,5],[84,10,84,11],[85,4,85,5],[85,10,85,11],[86,4,86,5],[86,10,86,11],[87,4,87,5],[87,10,87,11],[88,4,88,5],[88,10,88,11],[89,4,89,5],[89,10,89,11],[90,4,90,5],[90,10,90,11],[91,4,91,5],[91,10,91,11],[92,4,92,5],[92,10,92,11],[93,4,93,5],[93,10,93,11],[94,4,94,5],[94,10,94,11],[95,4,95,5],[95,10,95,11],[96,4,96,5],[96,10,96,11],[98,1,98,5],[98,7,98,11],[99,4,99,5],[99,10,99,11],[100,4,100,5],[100,10,100,11],[101,4,101,5],[101,10,101,11],[102,4,102,5],[102,10,102,11],[103,4,103,5],[103,10,103,11],[104,4,104,5],[104,10,104,11],[105,4,105,5],[105,10,105,11],[106,4,106,5],[106,10,106,11],[107,4,107,5],[107,10,107,11],[108,4,108,5],[108,10,108,11],[109,4,109,5],[109,10,109,11],[110,4,110,5],[110,10,110,11],[111,4,111,5],[111,10,111,11],[112,4,112,5],[112,10,112,11],[113,4,113,5],[113,10,113,11],[114,4,114,5],[114,10,114,11],[115,4,115,5],[115,10,115,11],[116,4,116,5],[116,10,116,11],[117,4,117,5],[117,10,117,11],[118,4,118,5],[118,10,118,11],[119,4,119,5],[119,10,119,11],[120,4,120,5],[120,10,120,11],[121,4,121,5],[121,10,121,11],[122,4,122,5],[122,10,122,11],[123,4,123,5],[123,10,123,11]]}
[]
[]
["Payroll Related Expenses"]
[null,"Borrower Name:",null,null,{"$f":"IF(Summary!E6=\"\",\"\",Summary!E6)","v":""},{"$nulls":3},"SBA #:",{"$f":"IF(Summary!E7=\"\",\"\",Summary!E7)","v":""}]
[]
[null,"Name of Payroll Service Provider if applicable:"]
[null,"Qualified Payroll Payments:",null,null,{"$f":"SUM(L17:L40)","v":{"v":0,"d":"$0.00"}}]
[null,"Payroll Taxes",null,null,{"$f":"SUM(D46:D69)","v":{"v":0,"d":"$0.00"}}]
[null,"Employer Paid Health Insurance - Primary",null,null,{"$f":"SUM(D74:D97)","v":{"v":0,"d":"$0.00"}}]
[null,"Employer Paid Health Insurance - Secondary",null,null,{"$f":"SUM(J74:J97)","v":{"v":0,"d":"$0.00"}}]
[null,"Employer Paid Retirement Benefits - Primary",null,null,{"$f":"SUM(D101:D124)","v":{"v":0,"d":"$0.00"}}]
[null,"Employer Paid Retirement Benefits - Secondary",null,null,{"$f":"SUM(J101:J124)","v":{"v":0,"d":"$0.00"}}]
[]
[null,"Payroll Payment"]
[{"$nulls":5},"Sub-Total of Employees Paid >$100,000 per year (1)",{"$nulls":3},"Bank Calculated Field"]
["#","From","To","Total # of Employees","Total Payroll Expenses","# of Employees >$100K/year","Employee Compensation (2)","Name of PDF Document (3)",null,">$100K Employee -Adj Compensation","Estimated Payroll Weeks","Qualified Payroll Expense (4)",null,"Additional Guidance:"]
[1,"00:00:00","00:00:00",0,{"v":0,"d":"$0.00"},0,{"v":0,"d":"$0.00"},null,null,{"$f":"IF(F17=0,0,(100000/52)*((C17-B17+1)/7))","v":{"v":0,"d":"$0.00"}},{"$f":"+(C17-B17)/7","v":0},{"$f":"IF(E17=0,0,IF(AND(G17>0,F17<=0),\"ERROR-See Guidance\",IF(AND(F17>0,G17<=0),\"ERROR-See Guidance\",IF(AND(E17>0,D17<=0),\"ERROR-See Guidance\",IF(AND(D17>0,E17<=0),\"ERROR-See Guidance\",(IF(D17>=F17,IF(E17>=G17,(IF(((E17-G17)/IF(D17-F17=0,D17,(D17-F17)))>((C17-B17+1)/7)*100000/52,\"ERROR-See Guidance\",IF(F17>0,(IF(((G17/(F17+0.1))<((C17-B17+1)/7)*100000/52),\"ERROR-See Guidance\",(E17-G17)+(F17*J17))),E17))),\"ERROR-See Guidance\"),\"ERROR-See Guidance\")))))))","v":{"v":0,"d":"$0.00"}},null,"(1)","Please list total number of employees receiving more than $100,000 in annual compensation during the payroll period."]
[{"$f":"+A17+1","v":2},{"$nulls":8},{"v":0,"d":"$0.00"},{"$f":"+(C18-B18)/7","v":0},{"$f":"IF(E18=0,0,IF(AND(G18>0,F18<=0),\"ERROR-See Guidance\",IF(AND(F18>0,G18<=0),\"ERROR-See Guidance\",IF(AND(E18>0,D18<=0),\"ERROR-See Guidance\",IF(AND(D18>0,E18<=0),\"ERROR-See Guidance\",(IF(D18>=F18,IF(E18>=G18,(IF(((E18-G18)/IF(D18-F18=0,D18,(D18-F18)))>((C18-B18+1)/7)*100000/52,\"ERROR-See Guidance\",IF(F18>0,(IF(((G18/(F18+0.1))<((C18-B18+1)/7)*100000/52),\"ERROR-See Guidance\",(E18-G18)+(F18*J18))),E18))),\"ERROR-See Guidance\"),\"ERROR-See Guidance\")))))))","v":{"v":0,"d":"$0.00"}}]
[{"$f":"+A18+1","v":3},{"$nulls":8},{"v":0,"d":"$0.00"},0,{"v":0,"d":"$0.00"}]
[4,{"$nulls":8},{"v":0,"d":"$0.00"},0,{"v":0,"d":"$0.00"},null,"(2)","Please input total compensation paid to employees during this pay period that is receiving more than $100,000 in annual compensation in this box. \nFor example, if you have one employees receiving more than $100,000 in annual compensation and his/her pay during this period was $4,000, then please input $4,000 in \"column G\"."]
[5,{"$nulls":8},{"v":0,"d":"$0.00"},0,{"v":0,"d":"$0.00"}]
[6,{"$nulls":8},{"v":0,"d":"$0.00"},0,{"v":0,"d":"$0.00"}]
[7,{"$nulls":8},{"v":0,"d":"$0.00"},0,{"v":0,"d":"$0.00"}]
[8,{"$nulls":8},{"v":0,"d":"$0.00"},0,{"v":0,"d":"$0.00"}]
[9,{"$nulls":8},{"v":0,"d":"$0.00"},0,{"v":0,"d":"$0.00"}]
[10,{"$nulls":8},{"v":0,"d":"$0.00"},0,{"v":0,"d":"$0.00"}]
[11,{"$nulls":8},{"v":0,"d":"$0.00"},0,{"v":0,"d":"$0.00"},null,"(3)","Please input name of the supporting document associated with this expense item.  This is an important step to expedite your forgiveness review."]
[12,{"$nulls":8},{"v":0,"d":"$0.00"},0,{"v":0,"d":"$0.00"}]
[13,{"$nulls":8},{"v":0,"d":"$0.00"},0,{"v":0,"d":"$0.00"}]
[14,{"$nulls":8},{"v":0,"d":"$0.00"},0,{"v":0,"d":"$0.00"}]
[15,{"$nulls":8},{"v":0,"d":"$0.00"},0,{"v":0,"d":"$0.00"},null,"(4)","Represent estimated elgible payroll expense.  \"Error-See Guidance\" message could be present due to the following:"]
[16,{"$nulls":8},{"v":0,"d":"$0.00"},0,{"v":0,"d":"$0.00"}]
[17,{"$nulls":8},{"v":0,"d":"$0.00"},0,{"v":0,"d":"$0.00"}]
[18,{"$nulls":8},{"v":0,"d":"$0.00"},0,{"v":0,"d":"$0.00"},null,null,"-","Double check total number of employees for the payroll period"]
[19,{"$nulls":8},{"v":0,"d":"$0.00"},0,{"v":0,"d":"$0.00"}]
[20,{"$nulls":8},{"v":0,"d":"$0.00"},0,{"v":0,"d":"$0.00"},null,null,"-","Double check total payroll expense for the payroll period"]
[21,{"$nulls":8},{"v":0,"d":"$0.00"},0,{"v":0,"d":"$0.00"}]
[22,{"$nulls":8},{"v":0,"d":"$0.00"},0,{"v":0,"d":"$0.00"},null,null,"-","Make to include # of employees making over $100,000/year and their respective pay for this payroll period."]
[23,{"$nulls":8},{"v":0,"d":"$0.00"},0,{"v":0,"d":"$0.00"}]
[24,{"$nulls":8},{"v":0,"d":"$0.00"},0,{"v":0,"d":"$0.00"}]
[]
[]
[]
[null,"Payroll Taxes - If not Included in Payroll Cost"]
["#","From","To","Payroll Taxes","Name of PDF Document"]
[1,{"$nulls":6},"Note:"]
[{"$f":"+A46+1","v":2},{"$nulls":6},"Please include only include State Unemployment and E&T Assessment Taxes"]
[{"$f":"+A47+1","v":3}]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[]
[]
[null,"Employer Paid Health Insurance - Primary",{"$nulls":5},"Employer Paid Health Insurance - Secondary"]
["#","From","To","Ins Payment","Name of PDF Document",null,"#","From","To","Ins Payment","Name of PDF Document"]
[1,"00:00:00","00:00:00",{"v":0,"d":"$0.00"},null,null,1,"00:00:00","00:00:00",{"v":0,"d":"$0.00"}]
[{"$f":"+A74+1","v":2},{"$nulls":5},{"$f":"+G74+1","v":2}]
[{"$f":"+A75+1","v":3},{"$nulls":5},{"$f":"+G75+1","v":3}]
[4,{"$nulls":5},4]
[5,{"$nulls":5},5]
[6,{"$nulls":5},6]
[7,{"$nulls":5},7]
[8,{"$nulls":5},8]
[9,{"$nulls":5},9]
[10,{"$nulls":5},10]
[11,{"$nulls":5},11]
[12,{"$nulls":5},12]
[13,{"$nulls":5},13]
[14,{"$nulls":5},14]
[15,{"$nulls":5},15]
[16,{"$nulls":5},16]
[17,{"$nulls":5},17]
[18,{"$nulls":5},18]
[19,{"$nulls":5},19]
[20,{"$nulls":5},20]
[21,{"$nulls":5},21]
[22,{"$nulls":5},22]
[23,{"$nulls":5},23]
[24,{"$nulls":5},24]
[]
[null,"Employer Paid Retirement Benefits - Primary",{"$nulls":5},"Employer Paid Retirement Benefits - Secondary"]
["#","From","To","Payment","Name of PDF Document",null,"#","From","To","Payment","Name of PDF Document"]
[1,"00:00:00","00:00:00",{"v":0,"d":"$0.00"},null,null,1,"00:00:00","00:00:00",{"v":0,"d":"$0.00"}]
[{"$f":"+A101+1","v":2},{"$nulls":5},{"$f":"+G101+1","v":2}]
[{"$f":"+A102+1","v":3},{"$nulls":5},{"$f":"+G102+1","v":3}]
[4,{"$nulls":5},4]
[5,{"$nulls":5},5]
[6,{"$nulls":5},6]
[7,{"$nulls":5},7]
[8,{"$nulls":5},8]
[9,{"$nulls":5},9]
[10,{"$nulls":5},10]
[11,{"$nulls":5},11]
[12,{"$nulls":5},12]
[13,{"$nulls":5},13]
[14,{"$nulls":5},14]
[15,{"$nulls":5},15]
[16,{"$nulls":5},16]
[17,{"$nulls":5},17]
[18,{"$nulls":5},18]
[19,{"$nulls":5},19]
[20,{"$nulls":5},20]
[21,{"$nulls":5},21]
[22,{"$nulls":5},22]
[23,{"$nulls":5},23]
[24,{"$nulls":5},24]

{"sheet":"Other Expenses","index":2,"n_rows":125,"n_cols":12,"rows_kept":125,"merged":[[1,1,1,11],[2,4,2,6],[4,9,4,10],[5,9,5,10],[6,3,6,4],[6,9,6,10],[7,3,7,4],[7,9,7,10],[9,1,9,11],[40,4,40,5],[40,10,40,11],[41,4,41,5],[41,10,41,11],[69,4,69,5],[69,10,69,11],[70,4,70,5],[70,10,70,11],[98,4,98,5],[98,10,98,11],[99,4,99,5],[99,10,99,11]]}
[]
[null,"Other Qualified Expense Summary"]
[null,"Borrower Name:",null,null,{"$f":"IF(Summary!E6=\"\",\"\",Summary!E6)","v":""},{"$nulls":4},"SBA #:",{"$f":"IF(Summary!E7=\"\",\"\",Summary!E7)","v":""}]
[]
[null,"Business Mortgage Interest Payment:",{"$nulls":3},{"$f":"SUM(E15:E38)","v":{"v":0,"d":"$0.00"}},null,"Utility 3 Payments:",null,{"$f":"IF(E70=\"\",\"\",E70)","v":""},null,{"$f":"SUM(E73:E96)","v":{"v":0,"d":"$0.00"}}]
[null,"Business Rent or Lease Payments:",{"$nulls":3},{"$f":"SUM(K15:K38)","v":{"v":0,"d":"$0.00"}},null,"Utility 4 Payments:",null,{"$f":"IF(K70=\"\",\"\",K70)","v":""},null,{"$f":"SUM(K73:K96)","v":{"v":0,"d":"$0.00"}}]
[null,"Utility 1 Payments:",null,{"$f":"IF(E41=\"\",\"\",E41)","v":""},null,{"$f":"SUM(E44:E67)","v":{"v":0,"d":"$0.00"}},null,"Utility 5 Payments:",null,{"$f":"IF(E99=\"\",\"\",E99)","v":""},null,{"$f":"SUM(E102:E125)","v":{"v":0,"d":"$0.00"}}]
[null,"Utility 2 Payments:",null,{"$f":"IF(K41=\"\",\"\",K41)","v":""},null,{"$f":"SUM(K44:K67)","v":{"v":0,"d":"$0.00"}},null,"Utility 6 Payments:",null,{"$f":"IF(K99=\"\",\"\",K99)","v":""},null,{"$f":"SUM(K102:K125)","v":{"v":0,"d":"$0.00"}}]
[]
[null,"Please Input Section for Other Qualified Expenses"]
[]
[null,null,"Business Mortgage Interest Payments",{"$nulls":5},"Business Rent or Lease Payments"]
[]
[null,"#","From","To","Interest Payments","Name of PDF Document",null,"#","From","To","Rent/Lease Payments","Name of PDF Document"]
[null,1,{"$nulls":5},1]
[null,{"$f":"+B15+1","v":2},{"$nulls":5},{"$f":"+H15+1","v":2}]
[null,{"$f":"+B16+1","v":3},{"$nulls":5},{"$f":"+H16+1","v":3}]
[null,4,{"$nulls":5},4]
[null,5,{"$nulls":5},5]
[null,6,{"$nulls":5},6]
[null,7,{"$nulls":5},7]
[null,8,{"$nulls":5},8]
[null,9,{"$nulls":5},9]
[null,10,{"$nulls":5},10]
[null,11,{"$nulls":5},11]
[null,12,{"$nulls":5},12]
[null,13,{"$nulls":5},13]
[null,14,{"$nulls":5},14]
[null,15,{"$nulls":5},15]
[null,16,{"$nulls":5},16]
[null,17,{"$nulls":5},17]
[null,18,{"$nulls":5},18]
[null,19,{"$nulls":5},19]
[null,20,{"$nulls":5},20]
[null,21,{"$nulls":5},21]
[null,22,{"$nulls":5},22]
[null,23,{"$nulls":5},23]
[null,24,{"$nulls":5},24]
[]
[]
[null,null,"Utility 1 Type:",{"$nulls":5},"Utility 2 Type:"]
[{"$nulls":4},"Please Input Name Above",{"$nulls":5},"Please Input Name Above"]
[null,"#","From","To","Total Payments","Name of PDF Document",null,"#","From","To","Total Payments","Name of PDF Document"]
[null,1,{"$nulls":5},1]
[null,{"$f":"+B44+1","v":2},{"$nulls":5},{"$f":"+H44+1","v":2}]
[null,{"$f":"+B45+1","v":3},{"$nulls":5},{"$f":"+H45+1","v":3}]
[null,4,{"$nulls":5},4]
[null,5,{"$nulls":5},5]
[null,6,{"$nulls":5},6]
[null,7,{"$nulls":5},7]
[null,8,{"$nulls":5},8]
[null,9,{"$nulls":5},9]
[null,10,{"$nulls":5},10]
[null,11,{"$nulls":5},11]
[null,12,{"$nulls":5},12]
[null,13,{"$nulls":5},13]
[null,14,{"$nulls":5},14]
[null,15,{"$nulls":5},15]
[null,16,{"$nulls":5},16]
[null,17,{"$nulls":5},17]
[null,18,{"$nulls":5},18]
[null,19,{"$nulls":5},19]
[null,20,{"$nulls":5},20]
[null,21,{"$nulls":5},21]
[null,22,{"$nulls":5},22]
[null,23,{"$nulls":5},23]
[null,24,{"$nulls":5},24]
[]
[]
[null,null,"Utility 3 Type:",{"$nulls":5},"Utility 4 Type:"]
[{"$nulls":4},"Please Input Name Above",{"$nulls":5},"Please Input Name Above"]
[null,"#","From","To","Total Payments","Name of PDF Document",null,"#","From","To","Total Payments","Name of PDF Document"]
[null,1,{"$nulls":5},1]
[null,{"$f":"+B73+1","v":2},{"$nulls":5},{"$f":"+H73+1","v":2}]
[null,{"$f":"+B74+1","v":3},{"$nulls":5},{"$f":"+H74+1","v":3}]
[null,4,{"$nulls":5},4]
[null,5,{"$nulls":5},5]
[null,6,{"$nulls":5},6]
[null,7,{"$nulls":5},7]
[null,8,{"$nulls":5},8]
[null,9,{"$nulls":5},9]
[null,10,{"$nulls":5},10]
[null,11,{"$nulls":5},11]
[null,12,{"$nulls":5},12]
[null,13,{"$nulls":5},13]
[null,14,{"$nulls":5},14]
[null,15,{"$nulls":5},15]
[null,16,{"$nulls":5},16]
[null,17,{"$nulls":5},17]
[null,18,{"$nulls":5},18]
[null,19,{"$nulls":5},19]
[null,20,{"$nulls":5},20]
[null,21,{"$nulls":5},21]
[null,22,{"$nulls":5},22]
[null,23,{"$nulls":5},23]
[null,24,{"$nulls":5},24]
[]
[]
[null,null,"Utility 5 Type:",{"$nulls":5},"Utility 6 Type:"]
[{"$nulls":4},"Please Input Name Above",{"$nulls":5},"Please Input Name Above"]
[null,"#","From","To","Total Payments","Name of PDF Document",null,"#","From","To","Total Payments","Name of PDF Document"]
[null,1,{"$nulls":5},1]
[null,{"$f":"+B102+1","v":2},{"$nulls":5},{"$f":"+H102+1","v":2}]
[null,{"$f":"+B103+1","v":3},{"$nulls":5},{"$f":"+H103+1","v":3}]
[null,4,{"$nulls":5},4]
[null,5,{"$nulls":5},5]
[null,6,{"$nulls":5},6]
[null,7,{"$nulls":5},7]
[null,8,{"$nulls":5},8]
[null,9,{"$nulls":5},9]
[null,10,{"$nulls":5},10]
[null,11,{"$nulls":5},11]
[null,12,{"$nulls":5},12]
[null,13,{"$nulls":5},13]
[null,14,{"$nulls":5},14]
[null,15,{"$nulls":5},15]
[null,16,{"$nulls":5},16]
[null,17,{"$nulls":5},17]
[null,18,{"$nulls":5},18]
[null,19,{"$nulls":5},19]
[null,20,{"$nulls":5},20]
[null,21,{"$nulls":5},21]
[null,22,{"$nulls":5},22]
[null,23,{"$nulls":5},23]
[null,24,{"$nulls":5},24]

{"sheet":"Additional Covered Expenses","index":3,"n_rows":41,"n_cols":10,"rows_kept":41,"merged":[[1,1,1,9],[2,4,2,6],[4,5,4,6],[5,5,5,6],[6,5,6,6],[7,5,7,6],[9,1,9,9],[12,2,12,4],[12,7,12,9],[29,2,29,4],[29,7,29,9]]}
[]
[null,"Additional Covered Expenses Summary"]
[null,"Borrower Name:",null,null,{"$f":"IF(Summary!E6=\"\",\"\",Summary!E6)","v":""},{"$nulls":3},"SBA #:",{"$f":"IF(Summary!E7=\"\",\"\",Summary!E7)","v":""}]
[]
[null,"Business Software or Cloud Computing Services",{"$nulls":3},{"$f":"SUM(D15:D24)","v":{"v":0,"d":"$0.00"}}]
[null,"Covered Property Damage",{"$nulls":3},{"$f":"SUM(I15:I24)","v":{"v":0,"d":"$0.00"}}]
[null,"Covered Supplier Cost",{"$nulls":3},{"$f":"SUM(D32:D41)","v":{"v":0,"d":"$0.00"}}]
[null,"Worker Protection Expenditure",{"$nulls":3},{"$f":"SUM(I32:I41)","v":{"v":0,"d":"$0.00"}}]
[]
[null,"Please Input Section for Other Qualified Expenses"]
[]
[null,null,"Payment for Business Software or Cloud Computing Services",{"$nulls":4},"Covered Property Damage"]
[null,null,"Business software or cloud computing service for business operations, such as payroll, sales, billing and bookkeeping.  Refer to SBA for expanded guidance.",{"$nulls":4},"Property damage cost/vandalism/looting during 2020 not covered by insurance"]
[null,"#","Date","Cost","Name of PDF Document",null,"#","Date","Rent/Lease Payments","Name of PDF Document"]
[null,1,{"$nulls":4},1]
[null,{"$f":"+B15+1","v":2},{"$nulls":4},{"$f":"+G15+1","v":2}]
[null,{"$f":"+B16+1","v":3},{"$nulls":4},{"$f":"+G16+1","v":3}]
[null,4,{"$nulls":4},4]
[null,5,{"$nulls":4},5]
[null,6,{"$nulls":4},6]
[null,7,{"$nulls":4},7]
[null,8,{"$nulls":4},8]
[null,9,{"$nulls":4},9]
[null,10,{"$nulls":4},10]
[]
[]
[]
[]
[null,null,"Covered Supplier Cost",{"$nulls":4},"Worker Protection Expenditure"]
[null,null,"Any purchase order or order of goods made prior to receipt of the PPP loan or during the covered period that is essential to operations.",{"$nulls":4},"Any personal protection equipment or property improvements to remain COVID compliance from 3/1/20."]
[null,"#","Date","Cost","Name of PDF Document",null,"#","Date","Cost","Name of PDF Document"]
[null,1,{"$nulls":4},1]
[null,{"$f":"+B32+1","v":2},{"$nulls":4},{"$f":"+G32+1","v":2}]
[null,{"$f":"+B33+1","v":3},{"$nulls":4},{"$f":"+G33+1","v":3}]
[null,4,{"$nulls":4},4]
[null,5,{"$nulls":4},5]
[null,6,{"$nulls":4},6]
[null,7,{"$nulls":4},7]
[null,8,{"$nulls":4},8]
[null,9,{"$nulls":4},9]
[null,10,{"$nulls":4},10]