{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Contribution Report","Rate Lookup"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"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":"Contribution Report","index":0,"n_rows":221,"n_cols":9,"rows_kept":221,"cut":false,"hidden":false,"merged":[[193,0,193,1],[194,0,194,1],[217,0,217,1],[218,0,218,1],[219,0,219,1],[220,0,220,1],[208,0,208,1],[209,0,209,1],[210,0,210,1],[211,0,211,1],[212,0,212,1],[213,0,213,1],[214,0,214,1],[215,0,215,1],[216,0,216,1],[206,0,206,1],[207,0,207,1],[195,0,195,1],[196,0,196,1],[197,0,197,1],[198,0,198,1],[199,0,199,1],[200,0,200,1],[102,0,102,1],[103,0,103,1],[104,0,104,1],[105,0,105,1],[106,0,106,1],[107,0,107,1],[108,0,108,1],[109,0,109,1],[110,0,110,1],[93,0,93,1],[94,0,94,1],[95,0,95,1],[96,0,96,1],[97,0,97,1],[98,0,98,1],[99,0,99,1],[167,0,167,1],[168,0,168,1],[140,0,140,1],[141,0,141,1],[142,0,142,1],[143,0,143,1],[144,0,144,1],[145,0,145,1],[146,0,146,1],[147,0,147,1],[148,0,148,1],[136,0,136,1],[137,0,137,1],[138,0,138,1],[139,0,139,1],[118,0,118,1],[119,0,119,1],[170,0,170,1],[201,0,201,1],[202,0,202,1],[203,0,203,1],[204,0,204,1],[205,0,205,1],[177,0,177,1],[178,0,178,1],[179,0,179,1],[180,0,180,1],[181,0,181,1],[182,0,182,1],[183,0,183,1],[184,0,184,1],[185,0,185,1],[186,0,186,1],[187,0,187,1],[188,0,188,1],[189,0,189,1],[190,0,190,1],[191,0,191,1],[171,0,171,1],[172,0,172,1],[192,0,192,1],[128,0,128,1],[173,0,173,1],[174,0,174,1],[175,0,175,1],[176,0,176,1],[149,0,149,1],[150,0,150,1],[151,0,151,1],[152,0,152,1],[153,0,153,1],[154,0,154,1],[155,0,155,1],[156,0,156,1],[157,0,157,1],[158,0,158,1],[159,0,159,1],[160,0,160,1],[161,0,161,1],[162,0,162,1],[163,0,163,1],[164,0,164,1],[165,0,165,1],[166,0,166,1],[169,0,169,1],[85,0,85,1],[86,0,86,1],[129,0,129,1],[130,0,130,1],[131,0,131,1],[132,0,132,1],[133,0,133,1],[134,0,134,1],[135,0,135,1],[111,0,111,1],[112,0,112,1],[113,0,113,1],[114,0,114,1],[115,0,115,1],[116,0,116,1],[117,0,117,1],[120,0,120,1],[121,0,121,1],[122,0,122,1],[123,0,123,1],[124,0,124,1],[125,0,125,1],[126,0,126,1],[127,0,127,1],[87,0,87,1],[88,0,88,1],[89,0,89,1],[90,0,90,1],[91,0,91,1],[92,0,92,1],[100,0,100,1],[101,0,101,1],[69,0,69,1],[70,0,70,1],[71,0,71,1],[72,0,72,1],[73,0,73,1],[74,0,74,1],[75,0,75,1],[76,0,76,1],[77,0,77,1],[78,0,78,1],[79,0,79,1],[80,0,80,1],[81,0,81,1],[82,0,82,1],[83,0,83,1],[84,0,84,1],[60,0,60,1],[61,0,61,1],[62,0,62,1],[63,0,63,1],[64,0,64,1],[65,0,65,1],[66,0,66,1],[67,0,67,1],[68,0,68,1],[51,0,51,1],[52,0,52,1],[53,0,53,1],[54,0,54,1],[55,0,55,1],[56,0,56,1],[57,0,57,1],[58,0,58,1],[59,0,59,1],[50,0,50,1],[6,1,7,3],[8,1,9,3],[10,1,12,3],[13,1,14,3],[15,1,16,3],[38,0,38,1],[39,0,39,1],[40,0,40,1],[37,0,37,1],[36,1,36,3],[35,1,35,3],[17,1,18,3],[41,0,41,1],[42,0,42,1],[43,0,43,1],[44,0,44,1],[45,0,45,1],[46,0,46,1],[47,0,47,1],[48,0,48,1],[49,0,49,1],[4,0,4,8],[0,0,0,8],[1,0,1,8],[2,0,2,8],[6,4,6,8],[15,4,16,8],[26,0,32,3],[21,0,22,3],[33,1,33,3]]}
["EMPLOYERS COMBINED REPORT OF CONTRIBUTIONS FOR"]
["LISTED FUNDS OF LABORERS LOCAL 100 & 397"]
["Fund Office (314) 367-6555"]
[]
["CONTRIBUTIONS REMITTED AFTER THE 15TH OF THE MONTH ARE DELINQUENT.  PAYMENTS RECEIVED AFTER THE 20TH OF THE MONTH WILL BE SUBJECT TO A LIQUIDATED DAMAGES ASSESSMENT OF 10 PERCENT (10%) OF TOTAL CONTRIBUTIONS."]
[]
[null,null,null,null,{"$f":"IF(OR(ISBLANK(A25),ISBLANK(B25),ISBLANK(C25),ISBLANK(D25)),\"Invalid - Complete Reporting Data\",IF(A25=\"SIBA\",(\"SIBA \"&VLOOKUP(D25,'Rate Lookup'!$AF:$AG,2,FALSE)),IF(A25=\"Non-SIBA\",(\"Non-SIBA \"&VLOOKUP(D25,'Rate Lookup'!$AF:$AG,2,FALSE)),IF(A25=\"Masonry\",(\"Masonry \"&VLOOKUP(D25,'Rate Lookup'!$AF:$AG,2,FALSE)),IF(A25=\"National Distribution\",(\"NDA \"&VLOOKUP(D25,'Rate Lookup'!$AF:$AG,2,FALSE)),\"Invalid - Complete Reporting Data\")))))","v":"SIBA Rates Effective 8/1/2023"}]
["Employer:",null,null,null,null,"ST","TH","DT"]
[null,null,null,null,"Welfare",{"$f":"VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,3,FALSE)","v":8.6999999999999993},{"$f":"VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,4,FALSE)","v":13.049999999999999},{"$f":"VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,5,FALSE)","v":17.399999999999999}]
["Contact Name:",null,null,null,"Pension",{"$f":"VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,7,FALSE)","v":11.4},{"$f":"VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,8,FALSE)","v":17.100000000000001},{"$f":"VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,9,FALSE)","v":22.8}]
[null,null,null,null,"Annuity",{"$f":"VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,11,FALSE)","v":7.5},{"$f":"VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,12,FALSE)","v":11.25},{"$f":"VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,13,FALSE)","v":15}]
[null,null,null,null,"Training",{"$f":"VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,15,FALSE)","v":0.8},{"$f":"VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,15,FALSE)","v":0.8},{"$f":"VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$106,15,FALSE)","v":0.8}]
["Address:",null,null,null,"LECET Funds",{"$f":"VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,17,FALSE)","v":2.0099999999999998},{"$f":"VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,17,FALSE)","v":2.0099999999999998},{"$f":"VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$106,17,FALSE)","v":2.0099999999999998}]
[null,null,null,null,"Supp. Dues",{"$f":"IF(B25=\"No\",0,IF(C25=100,VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,19,FALSE),IF(A25=\"Non-SIBA\",VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,23,FALSE),VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,21,FALSE))))","v":0.6},{"$f":"IF(B25=\"No\",0,IF(C25=100,VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,19,FALSE),IF(A25=\"Non-SIBA\",VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,23,FALSE),VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,21,FALSE))))","v":0.6},{"$f":"IF(B25=\"No\",0,IF(C25=100,VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,19,FALSE),IF(A25=\"Non-SIBA\",VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,23,FALSE),VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,21,FALSE))))","v":0.6}]
[null,null,null,null,"Total",{"$f":"SUM(F9:F14)","v":31.010000000000005},{"$f":"SUM(G9:G14)","v":44.809999999999995},{"$f":"SUM(H9:H14)","v":58.61}]
[null,null,null,null,"Monthly Contribution Report Summary"]
["Phone Number:"]
[null,null,null,null,null,"ST","TH","DT"]
["Email:",null,null,null,"Total Hours",{"$f":"SUM(E39:E226)","v":0},{"$f":"SUM(F39:F226)","v":0},{"$f":"SUM(G39:G226)","v":0}]
[null,null,null,null," x Rate",{"$f":"F15","v":31.010000000000005},{"$f":"G15","v":44.809999999999995},{"$f":"H15","v":58.61}]
[null,null,null,null,"Total",{"$f":"ROUND(F19*F20,2)","v":0},{"$f":"ROUND(G19*G20,2)","v":0},{"$f":"ROUND(H19*H20,2)","v":0}]
["Reporting Data",null,null,null,null,null,null,"Subtotal:",{"$f":"SUM(F21:H21)","v":0}]
[null,null,null,null,null,null,null,"Liquidated Damages:"]
["Agreement Type","Supplement Dues","Work Jurisdiction","Reporting Period",null,null,null,"Adjustment:"]
["SIBA","Yes",397,"August, 2023",null,null,null,"Total Contribution Due:",{"$f":"+I24+I23+I22","v":0}]
[null,null,"(100 / 397)","(Month, Year)","Submit form electronically through:"]
["The undersigned employer, if not already a signator, hereby becomes a signatory party to the currently applicable collective bargaining agreement with Laborers Locals 100 & 397 covering the type and area of work of the below employees and also to each agreement and Declaration of Trust, and amendments, establishing the funds for which payment is made herewith.",null,null,null,null,"https://www.ekonbenefits.com/securesend"]
[null,null,null,null,"Payment Remittance"]
[null,null,null,null,"Option 1) ","By Automatic Transfer:"]
[null,null,null,null,null,"Select this option upon uploading form"]
[null,null,null,null,null,"Note: ACH Debit Authorization must be on file"]
[null,null,null,null,"Option 2)","By Check: "]
[null,null,null,null,null,"Pay to: Employers & Laborers Locals 100 & 397 Funds"]
["Print Name:",null,null,null,null,"Mail to: Ekon Benefits"]
[null,null,null,null,null,"4940 Washington Blvd."]
["Date: ",null,null,null,null,"St. Louis, MO  63108"]
[null,null,null,null,"Call Ekon Benefits at (314) 367-6555 with questions"]
["Name",null,"SSN","Home Local #  100/397","Straight Time Hours","Time & One-Half Hours","Double Time Hours","LPL (Withheld)","Checkoff (Withheld)"]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E39=\"\",$F39=\"\",$G39=\"\"),\"\",(ROUND(SUM(E39:G39)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E39=\"\",$F39=\"\",$G39=\"\"),\"\",(ROUND(SUM(E39:G39)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E40=\"\",$F40=\"\",$G40=\"\"),\"\",(ROUND(SUM(E40:G40)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E40=\"\",$F40=\"\",$G40=\"\"),\"\",(ROUND(SUM(E40:G40)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E41=\"\",$F41=\"\",$G41=\"\"),\"\",(ROUND(SUM(E41:G41)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E41=\"\",$F41=\"\",$G41=\"\"),\"\",(ROUND(SUM(E41:G41)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E42=\"\",$F42=\"\",$G42=\"\"),\"\",(ROUND(SUM(E42:G42)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E42=\"\",$F42=\"\",$G42=\"\"),\"\",(ROUND(SUM(E42:G42)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E43=\"\",$F43=\"\",$G43=\"\"),\"\",(ROUND(SUM(E43:G43)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E43=\"\",$F43=\"\",$G43=\"\"),\"\",(ROUND(SUM(E43:G43)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E44=\"\",$F44=\"\",$G44=\"\"),\"\",(ROUND(SUM(E44:G44)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E44=\"\",$F44=\"\",$G44=\"\"),\"\",(ROUND(SUM(E44:G44)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E45=\"\",$F45=\"\",$G45=\"\"),\"\",(ROUND(SUM(E45:G45)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E45=\"\",$F45=\"\",$G45=\"\"),\"\",(ROUND(SUM(E45:G45)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E46=\"\",$F46=\"\",$G46=\"\"),\"\",(ROUND(SUM(E46:G46)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E46=\"\",$F46=\"\",$G46=\"\"),\"\",(ROUND(SUM(E46:G46)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E47=\"\",$F47=\"\",$G47=\"\"),\"\",(ROUND(SUM(E47:G47)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E47=\"\",$F47=\"\",$G47=\"\"),\"\",(ROUND(SUM(E47:G47)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E48=\"\",$F48=\"\",$G48=\"\"),\"\",(ROUND(SUM(E48:G48)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E48=\"\",$F48=\"\",$G48=\"\"),\"\",(ROUND(SUM(E48:G48)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E49=\"\",$F49=\"\",$G49=\"\"),\"\",(ROUND(SUM(E49:G49)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E49=\"\",$F49=\"\",$G49=\"\"),\"\",(ROUND(SUM(E49:G49)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E50=\"\",$F50=\"\",$G50=\"\"),\"\",(ROUND(SUM(E50:G50)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E50=\"\",$F50=\"\",$G50=\"\"),\"\",(ROUND(SUM(E50:G50)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E51=\"\",$F51=\"\",$G51=\"\"),\"\",(ROUND(SUM(E51:G51)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E51=\"\",$F51=\"\",$G51=\"\"),\"\",(ROUND(SUM(E51:G51)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E52=\"\",$F52=\"\",$G52=\"\"),\"\",(ROUND(SUM(E52:G52)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E52=\"\",$F52=\"\",$G52=\"\"),\"\",(ROUND(SUM(E52:G52)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E53=\"\",$F53=\"\",$G53=\"\"),\"\",(ROUND(SUM(E53:G53)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E53=\"\",$F53=\"\",$G53=\"\"),\"\",(ROUND(SUM(E53:G53)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E54=\"\",$F54=\"\",$G54=\"\"),\"\",(ROUND(SUM(E54:G54)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E54=\"\",$F54=\"\",$G54=\"\"),\"\",(ROUND(SUM(E54:G54)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E55=\"\",$F55=\"\",$G55=\"\"),\"\",(ROUND(SUM(E55:G55)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E55=\"\",$F55=\"\",$G55=\"\"),\"\",(ROUND(SUM(E55:G55)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E56=\"\",$F56=\"\",$G56=\"\"),\"\",(ROUND(SUM(E56:G56)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E56=\"\",$F56=\"\",$G56=\"\"),\"\",(ROUND(SUM(E56:G56)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E57=\"\",$F57=\"\",$G57=\"\"),\"\",(ROUND(SUM(E57:G57)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E57=\"\",$F57=\"\",$G57=\"\"),\"\",(ROUND(SUM(E57:G57)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E58=\"\",$F58=\"\",$G58=\"\"),\"\",(ROUND(SUM(E58:G58)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E58=\"\",$F58=\"\",$G58=\"\"),\"\",(ROUND(SUM(E58:G58)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E59=\"\",$F59=\"\",$G59=\"\"),\"\",(ROUND(SUM(E59:G59)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E59=\"\",$F59=\"\",$G59=\"\"),\"\",(ROUND(SUM(E59:G59)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E60=\"\",$F60=\"\",$G60=\"\"),\"\",(ROUND(SUM(E60:G60)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E60=\"\",$F60=\"\",$G60=\"\"),\"\",(ROUND(SUM(E60:G60)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E61=\"\",$F61=\"\",$G61=\"\"),\"\",(ROUND(SUM(E61:G61)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E61=\"\",$F61=\"\",$G61=\"\"),\"\",(ROUND(SUM(E61:G61)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E62=\"\",$F62=\"\",$G62=\"\"),\"\",(ROUND(SUM(E62:G62)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E62=\"\",$F62=\"\",$G62=\"\"),\"\",(ROUND(SUM(E62:G62)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E63=\"\",$F63=\"\",$G63=\"\"),\"\",(ROUND(SUM(E63:G63)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E63=\"\",$F63=\"\",$G63=\"\"),\"\",(ROUND(SUM(E63:G63)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E64=\"\",$F64=\"\",$G64=\"\"),\"\",(ROUND(SUM(E64:G64)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E64=\"\",$F64=\"\",$G64=\"\"),\"\",(ROUND(SUM(E64:G64)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E65=\"\",$F65=\"\",$G65=\"\"),\"\",(ROUND(SUM(E65:G65)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E65=\"\",$F65=\"\",$G65=\"\"),\"\",(ROUND(SUM(E65:G65)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E66=\"\",$F66=\"\",$G66=\"\"),\"\",(ROUND(SUM(E66:G66)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E66=\"\",$F66=\"\",$G66=\"\"),\"\",(ROUND(SUM(E66:G66)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E67=\"\",$F67=\"\",$G67=\"\"),\"\",(ROUND(SUM(E67:G67)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E67=\"\",$F67=\"\",$G67=\"\"),\"\",(ROUND(SUM(E67:G67)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E68=\"\",$F68=\"\",$G68=\"\"),\"\",(ROUND(SUM(E68:G68)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E68=\"\",$F68=\"\",$G68=\"\"),\"\",(ROUND(SUM(E68:G68)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E69=\"\",$F69=\"\",$G69=\"\"),\"\",(ROUND(SUM(E69:G69)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E69=\"\",$F69=\"\",$G69=\"\"),\"\",(ROUND(SUM(E69:G69)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E70=\"\",$F70=\"\",$G70=\"\"),\"\",(ROUND(SUM(E70:G70)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E70=\"\",$F70=\"\",$G70=\"\"),\"\",(ROUND(SUM(E70:G70)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E71=\"\",$F71=\"\",$G71=\"\"),\"\",(ROUND(SUM(E71:G71)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E71=\"\",$F71=\"\",$G71=\"\"),\"\",(ROUND(SUM(E71:G71)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E72=\"\",$F72=\"\",$G72=\"\"),\"\",(ROUND(SUM(E72:G72)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E72=\"\",$F72=\"\",$G72=\"\"),\"\",(ROUND(SUM(E72:G72)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E73=\"\",$F73=\"\",$G73=\"\"),\"\",(ROUND(SUM(E73:G73)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E73=\"\",$F73=\"\",$G73=\"\"),\"\",(ROUND(SUM(E73:G73)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E74=\"\",$F74=\"\",$G74=\"\"),\"\",(ROUND(SUM(E74:G74)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E74=\"\",$F74=\"\",$G74=\"\"),\"\",(ROUND(SUM(E74:G74)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E75=\"\",$F75=\"\",$G75=\"\"),\"\",(ROUND(SUM(E75:G75)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E75=\"\",$F75=\"\",$G75=\"\"),\"\",(ROUND(SUM(E75:G75)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E76=\"\",$F76=\"\",$G76=\"\"),\"\",(ROUND(SUM(E76:G76)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E76=\"\",$F76=\"\",$G76=\"\"),\"\",(ROUND(SUM(E76:G76)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E77=\"\",$F77=\"\",$G77=\"\"),\"\",(ROUND(SUM(E77:G77)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E77=\"\",$F77=\"\",$G77=\"\"),\"\",(ROUND(SUM(E77:G77)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E78=\"\",$F78=\"\",$G78=\"\"),\"\",(ROUND(SUM(E78:G78)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E78=\"\",$F78=\"\",$G78=\"\"),\"\",(ROUND(SUM(E78:G78)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E79=\"\",$F79=\"\",$G79=\"\"),\"\",(ROUND(SUM(E79:G79)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E79=\"\",$F79=\"\",$G79=\"\"),\"\",(ROUND(SUM(E79:G79)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E80=\"\",$F80=\"\",$G80=\"\"),\"\",(ROUND(SUM(E80:G80)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E80=\"\",$F80=\"\",$G80=\"\"),\"\",(ROUND(SUM(E80:G80)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E81=\"\",$F81=\"\",$G81=\"\"),\"\",(ROUND(SUM(E81:G81)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E81=\"\",$F81=\"\",$G81=\"\"),\"\",(ROUND(SUM(E81:G81)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E82=\"\",$F82=\"\",$G82=\"\"),\"\",(ROUND(SUM(E82:G82)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E82=\"\",$F82=\"\",$G82=\"\"),\"\",(ROUND(SUM(E82:G82)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E83=\"\",$F83=\"\",$G83=\"\"),\"\",(ROUND(SUM(E83:G83)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E83=\"\",$F83=\"\",$G83=\"\"),\"\",(ROUND(SUM(E83:G83)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E84=\"\",$F84=\"\",$G84=\"\"),\"\",(ROUND(SUM(E84:G84)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E84=\"\",$F84=\"\",$G84=\"\"),\"\",(ROUND(SUM(E84:G84)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E85=\"\",$F85=\"\",$G85=\"\"),\"\",(ROUND(SUM(E85:G85)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E85=\"\",$F85=\"\",$G85=\"\"),\"\",(ROUND(SUM(E85:G85)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E86=\"\",$F86=\"\",$G86=\"\"),\"\",(ROUND(SUM(E86:G86)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E86=\"\",$F86=\"\",$G86=\"\"),\"\",(ROUND(SUM(E86:G86)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E87=\"\",$F87=\"\",$G87=\"\"),\"\",(ROUND(SUM(E87:G87)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E87=\"\",$F87=\"\",$G87=\"\"),\"\",(ROUND(SUM(E87:G87)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E88=\"\",$F88=\"\",$G88=\"\"),\"\",(ROUND(SUM(E88:G88)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E88=\"\",$F88=\"\",$G88=\"\"),\"\",(ROUND(SUM(E88:G88)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E89=\"\",$F89=\"\",$G89=\"\"),\"\",(ROUND(SUM(E89:G89)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E89=\"\",$F89=\"\",$G89=\"\"),\"\",(ROUND(SUM(E89:G89)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E90=\"\",$F90=\"\",$G90=\"\"),\"\",(ROUND(SUM(E90:G90)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E90=\"\",$F90=\"\",$G90=\"\"),\"\",(ROUND(SUM(E90:G90)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E91=\"\",$F91=\"\",$G91=\"\"),\"\",(ROUND(SUM(E91:G91)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E91=\"\",$F91=\"\",$G91=\"\"),\"\",(ROUND(SUM(E91:G91)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E92=\"\",$F92=\"\",$G92=\"\"),\"\",(ROUND(SUM(E92:G92)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E92=\"\",$F92=\"\",$G92=\"\"),\"\",(ROUND(SUM(E92:G92)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E93=\"\",$F93=\"\",$G93=\"\"),\"\",(ROUND(SUM(E93:G93)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E93=\"\",$F93=\"\",$G93=\"\"),\"\",(ROUND(SUM(E93:G93)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E94=\"\",$F94=\"\",$G94=\"\"),\"\",(ROUND(SUM(E94:G94)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E94=\"\",$F94=\"\",$G94=\"\"),\"\",(ROUND(SUM(E94:G94)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E95=\"\",$F95=\"\",$G95=\"\"),\"\",(ROUND(SUM(E95:G95)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E95=\"\",$F95=\"\",$G95=\"\"),\"\",(ROUND(SUM(E95:G95)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E96=\"\",$F96=\"\",$G96=\"\"),\"\",(ROUND(SUM(E96:G96)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E96=\"\",$F96=\"\",$G96=\"\"),\"\",(ROUND(SUM(E96:G96)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E97=\"\",$F97=\"\",$G97=\"\"),\"\",(ROUND(SUM(E97:G97)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E97=\"\",$F97=\"\",$G97=\"\"),\"\",(ROUND(SUM(E97:G97)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E98=\"\",$F98=\"\",$G98=\"\"),\"\",(ROUND(SUM(E98:G98)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E98=\"\",$F98=\"\",$G98=\"\"),\"\",(ROUND(SUM(E98:G98)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E99=\"\",$F99=\"\",$G99=\"\"),\"\",(ROUND(SUM(E99:G99)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E99=\"\",$F99=\"\",$G99=\"\"),\"\",(ROUND(SUM(E99:G99)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E100=\"\",$F100=\"\",$G100=\"\"),\"\",(ROUND(SUM(E100:G100)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E100=\"\",$F100=\"\",$G100=\"\"),\"\",(ROUND(SUM(E100:G100)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E101=\"\",$F101=\"\",$G101=\"\"),\"\",(ROUND(SUM(E101:G101)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E101=\"\",$F101=\"\",$G101=\"\"),\"\",(ROUND(SUM(E101:G101)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E102=\"\",$F102=\"\",$G102=\"\"),\"\",(ROUND(SUM(E102:G102)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E102=\"\",$F102=\"\",$G102=\"\"),\"\",(ROUND(SUM(E102:G102)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E103=\"\",$F103=\"\",$G103=\"\"),\"\",(ROUND(SUM(E103:G103)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E103=\"\",$F103=\"\",$G103=\"\"),\"\",(ROUND(SUM(E103:G103)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E104=\"\",$F104=\"\",$G104=\"\"),\"\",(ROUND(SUM(E104:G104)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E104=\"\",$F104=\"\",$G104=\"\"),\"\",(ROUND(SUM(E104:G104)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E105=\"\",$F105=\"\",$G105=\"\"),\"\",(ROUND(SUM(E105:G105)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E105=\"\",$F105=\"\",$G105=\"\"),\"\",(ROUND(SUM(E105:G105)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E106=\"\",$F106=\"\",$G106=\"\"),\"\",(ROUND(SUM(E106:G106)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E106=\"\",$F106=\"\",$G106=\"\"),\"\",(ROUND(SUM(E106:G106)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E107=\"\",$F107=\"\",$G107=\"\"),\"\",(ROUND(SUM(E107:G107)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E107=\"\",$F107=\"\",$G107=\"\"),\"\",(ROUND(SUM(E107:G107)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E108=\"\",$F108=\"\",$G108=\"\"),\"\",(ROUND(SUM(E108:G108)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E108=\"\",$F108=\"\",$G108=\"\"),\"\",(ROUND(SUM(E108:G108)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E109=\"\",$F109=\"\",$G109=\"\"),\"\",(ROUND(SUM(E109:G109)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E109=\"\",$F109=\"\",$G109=\"\"),\"\",(ROUND(SUM(E109:G109)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E110=\"\",$F110=\"\",$G110=\"\"),\"\",(ROUND(SUM(E110:G110)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E110=\"\",$F110=\"\",$G110=\"\"),\"\",(ROUND(SUM(E110:G110)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E111=\"\",$F111=\"\",$G111=\"\"),\"\",(ROUND(SUM(E111:G111)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E111=\"\",$F111=\"\",$G111=\"\"),\"\",(ROUND(SUM(E111:G111)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E112=\"\",$F112=\"\",$G112=\"\"),\"\",(ROUND(SUM(E112:G112)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E112=\"\",$F112=\"\",$G112=\"\"),\"\",(ROUND(SUM(E112:G112)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E113=\"\",$F113=\"\",$G113=\"\"),\"\",(ROUND(SUM(E113:G113)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E113=\"\",$F113=\"\",$G113=\"\"),\"\",(ROUND(SUM(E113:G113)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E114=\"\",$F114=\"\",$G114=\"\"),\"\",(ROUND(SUM(E114:G114)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E114=\"\",$F114=\"\",$G114=\"\"),\"\",(ROUND(SUM(E114:G114)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E115=\"\",$F115=\"\",$G115=\"\"),\"\",(ROUND(SUM(E115:G115)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E115=\"\",$F115=\"\",$G115=\"\"),\"\",(ROUND(SUM(E115:G115)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E116=\"\",$F116=\"\",$G116=\"\"),\"\",(ROUND(SUM(E116:G116)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E116=\"\",$F116=\"\",$G116=\"\"),\"\",(ROUND(SUM(E116:G116)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E117=\"\",$F117=\"\",$G117=\"\"),\"\",(ROUND(SUM(E117:G117)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E117=\"\",$F117=\"\",$G117=\"\"),\"\",(ROUND(SUM(E117:G117)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E118=\"\",$F118=\"\",$G118=\"\"),\"\",(ROUND(SUM(E118:G118)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E118=\"\",$F118=\"\",$G118=\"\"),\"\",(ROUND(SUM(E118:G118)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E119=\"\",$F119=\"\",$G119=\"\"),\"\",(ROUND(SUM(E119:G119)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E119=\"\",$F119=\"\",$G119=\"\"),\"\",(ROUND(SUM(E119:G119)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E120=\"\",$F120=\"\",$G120=\"\"),\"\",(ROUND(SUM(E120:G120)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E120=\"\",$F120=\"\",$G120=\"\"),\"\",(ROUND(SUM(E120:G120)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E121=\"\",$F121=\"\",$G121=\"\"),\"\",(ROUND(SUM(E121:G121)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E121=\"\",$F121=\"\",$G121=\"\"),\"\",(ROUND(SUM(E121:G121)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E122=\"\",$F122=\"\",$G122=\"\"),\"\",(ROUND(SUM(E122:G122)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E122=\"\",$F122=\"\",$G122=\"\"),\"\",(ROUND(SUM(E122:G122)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E123=\"\",$F123=\"\",$G123=\"\"),\"\",(ROUND(SUM(E123:G123)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E123=\"\",$F123=\"\",$G123=\"\"),\"\",(ROUND(SUM(E123:G123)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E124=\"\",$F124=\"\",$G124=\"\"),\"\",(ROUND(SUM(E124:G124)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E124=\"\",$F124=\"\",$G124=\"\"),\"\",(ROUND(SUM(E124:G124)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E125=\"\",$F125=\"\",$G125=\"\"),\"\",(ROUND(SUM(E125:G125)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E125=\"\",$F125=\"\",$G125=\"\"),\"\",(ROUND(SUM(E125:G125)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E126=\"\",$F126=\"\",$G126=\"\"),\"\",(ROUND(SUM(E126:G126)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E126=\"\",$F126=\"\",$G126=\"\"),\"\",(ROUND(SUM(E126:G126)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E127=\"\",$F127=\"\",$G127=\"\"),\"\",(ROUND(SUM(E127:G127)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E127=\"\",$F127=\"\",$G127=\"\"),\"\",(ROUND(SUM(E127:G127)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E128=\"\",$F128=\"\",$G128=\"\"),\"\",(ROUND(SUM(E128:G128)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E128=\"\",$F128=\"\",$G128=\"\"),\"\",(ROUND(SUM(E128:G128)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E129=\"\",$F129=\"\",$G129=\"\"),\"\",(ROUND(SUM(E129:G129)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E129=\"\",$F129=\"\",$G129=\"\"),\"\",(ROUND(SUM(E129:G129)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E130=\"\",$F130=\"\",$G130=\"\"),\"\",(ROUND(SUM(E130:G130)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E130=\"\",$F130=\"\",$G130=\"\"),\"\",(ROUND(SUM(E130:G130)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E131=\"\",$F131=\"\",$G131=\"\"),\"\",(ROUND(SUM(E131:G131)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E131=\"\",$F131=\"\",$G131=\"\"),\"\",(ROUND(SUM(E131:G131)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E132=\"\",$F132=\"\",$G132=\"\"),\"\",(ROUND(SUM(E132:G132)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E132=\"\",$F132=\"\",$G132=\"\"),\"\",(ROUND(SUM(E132:G132)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E133=\"\",$F133=\"\",$G133=\"\"),\"\",(ROUND(SUM(E133:G133)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E133=\"\",$F133=\"\",$G133=\"\"),\"\",(ROUND(SUM(E133:G133)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E134=\"\",$F134=\"\",$G134=\"\"),\"\",(ROUND(SUM(E134:G134)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E134=\"\",$F134=\"\",$G134=\"\"),\"\",(ROUND(SUM(E134:G134)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E135=\"\",$F135=\"\",$G135=\"\"),\"\",(ROUND(SUM(E135:G135)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E135=\"\",$F135=\"\",$G135=\"\"),\"\",(ROUND(SUM(E135:G135)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E136=\"\",$F136=\"\",$G136=\"\"),\"\",(ROUND(SUM(E136:G136)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E136=\"\",$F136=\"\",$G136=\"\"),\"\",(ROUND(SUM(E136:G136)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E137=\"\",$F137=\"\",$G137=\"\"),\"\",(ROUND(SUM(E137:G137)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E137=\"\",$F137=\"\",$G137=\"\"),\"\",(ROUND(SUM(E137:G137)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E138=\"\",$F138=\"\",$G138=\"\"),\"\",(ROUND(SUM(E138:G138)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E138=\"\",$F138=\"\",$G138=\"\"),\"\",(ROUND(SUM(E138:G138)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E139=\"\",$F139=\"\",$G139=\"\"),\"\",(ROUND(SUM(E139:G139)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E139=\"\",$F139=\"\",$G139=\"\"),\"\",(ROUND(SUM(E139:G139)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E140=\"\",$F140=\"\",$G140=\"\"),\"\",(ROUND(SUM(E140:G140)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E140=\"\",$F140=\"\",$G140=\"\"),\"\",(ROUND(SUM(E140:G140)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E141=\"\",$F141=\"\",$G141=\"\"),\"\",(ROUND(SUM(E141:G141)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E141=\"\",$F141=\"\",$G141=\"\"),\"\",(ROUND(SUM(E141:G141)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E142=\"\",$F142=\"\",$G142=\"\"),\"\",(ROUND(SUM(E142:G142)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E142=\"\",$F142=\"\",$G142=\"\"),\"\",(ROUND(SUM(E142:G142)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E143=\"\",$F143=\"\",$G143=\"\"),\"\",(ROUND(SUM(E143:G143)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E143=\"\",$F143=\"\",$G143=\"\"),\"\",(ROUND(SUM(E143:G143)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E144=\"\",$F144=\"\",$G144=\"\"),\"\",(ROUND(SUM(E144:G144)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E144=\"\",$F144=\"\",$G144=\"\"),\"\",(ROUND(SUM(E144:G144)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E145=\"\",$F145=\"\",$G145=\"\"),\"\",(ROUND(SUM(E145:G145)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E145=\"\",$F145=\"\",$G145=\"\"),\"\",(ROUND(SUM(E145:G145)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E146=\"\",$F146=\"\",$G146=\"\"),\"\",(ROUND(SUM(E146:G146)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E146=\"\",$F146=\"\",$G146=\"\"),\"\",(ROUND(SUM(E146:G146)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E147=\"\",$F147=\"\",$G147=\"\"),\"\",(ROUND(SUM(E147:G147)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E147=\"\",$F147=\"\",$G147=\"\"),\"\",(ROUND(SUM(E147:G147)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E148=\"\",$F148=\"\",$G148=\"\"),\"\",(ROUND(SUM(E148:G148)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E148=\"\",$F148=\"\",$G148=\"\"),\"\",(ROUND(SUM(E148:G148)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E149=\"\",$F149=\"\",$G149=\"\"),\"\",(ROUND(SUM(E149:G149)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E149=\"\",$F149=\"\",$G149=\"\"),\"\",(ROUND(SUM(E149:G149)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E150=\"\",$F150=\"\",$G150=\"\"),\"\",(ROUND(SUM(E150:G150)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E150=\"\",$F150=\"\",$G150=\"\"),\"\",(ROUND(SUM(E150:G150)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E151=\"\",$F151=\"\",$G151=\"\"),\"\",(ROUND(SUM(E151:G151)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E151=\"\",$F151=\"\",$G151=\"\"),\"\",(ROUND(SUM(E151:G151)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E152=\"\",$F152=\"\",$G152=\"\"),\"\",(ROUND(SUM(E152:G152)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E152=\"\",$F152=\"\",$G152=\"\"),\"\",(ROUND(SUM(E152:G152)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E153=\"\",$F153=\"\",$G153=\"\"),\"\",(ROUND(SUM(E153:G153)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E153=\"\",$F153=\"\",$G153=\"\"),\"\",(ROUND(SUM(E153:G153)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E154=\"\",$F154=\"\",$G154=\"\"),\"\",(ROUND(SUM(E154:G154)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E154=\"\",$F154=\"\",$G154=\"\"),\"\",(ROUND(SUM(E154:G154)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E155=\"\",$F155=\"\",$G155=\"\"),\"\",(ROUND(SUM(E155:G155)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E155=\"\",$F155=\"\",$G155=\"\"),\"\",(ROUND(SUM(E155:G155)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E156=\"\",$F156=\"\",$G156=\"\"),\"\",(ROUND(SUM(E156:G156)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E156=\"\",$F156=\"\",$G156=\"\"),\"\",(ROUND(SUM(E156:G156)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E157=\"\",$F157=\"\",$G157=\"\"),\"\",(ROUND(SUM(E157:G157)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E157=\"\",$F157=\"\",$G157=\"\"),\"\",(ROUND(SUM(E157:G157)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E158=\"\",$F158=\"\",$G158=\"\"),\"\",(ROUND(SUM(E158:G158)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E158=\"\",$F158=\"\",$G158=\"\"),\"\",(ROUND(SUM(E158:G158)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E159=\"\",$F159=\"\",$G159=\"\"),\"\",(ROUND(SUM(E159:G159)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E159=\"\",$F159=\"\",$G159=\"\"),\"\",(ROUND(SUM(E159:G159)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E160=\"\",$F160=\"\",$G160=\"\"),\"\",(ROUND(SUM(E160:G160)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E160=\"\",$F160=\"\",$G160=\"\"),\"\",(ROUND(SUM(E160:G160)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E161=\"\",$F161=\"\",$G161=\"\"),\"\",(ROUND(SUM(E161:G161)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E161=\"\",$F161=\"\",$G161=\"\"),\"\",(ROUND(SUM(E161:G161)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E162=\"\",$F162=\"\",$G162=\"\"),\"\",(ROUND(SUM(E162:G162)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E162=\"\",$F162=\"\",$G162=\"\"),\"\",(ROUND(SUM(E162:G162)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E163=\"\",$F163=\"\",$G163=\"\"),\"\",(ROUND(SUM(E163:G163)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E163=\"\",$F163=\"\",$G163=\"\"),\"\",(ROUND(SUM(E163:G163)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E164=\"\",$F164=\"\",$G164=\"\"),\"\",(ROUND(SUM(E164:G164)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E164=\"\",$F164=\"\",$G164=\"\"),\"\",(ROUND(SUM(E164:G164)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E165=\"\",$F165=\"\",$G165=\"\"),\"\",(ROUND(SUM(E165:G165)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E165=\"\",$F165=\"\",$G165=\"\"),\"\",(ROUND(SUM(E165:G165)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E166=\"\",$F166=\"\",$G166=\"\"),\"\",(ROUND(SUM(E166:G166)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E166=\"\",$F166=\"\",$G166=\"\"),\"\",(ROUND(SUM(E166:G166)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E167=\"\",$F167=\"\",$G167=\"\"),\"\",(ROUND(SUM(E167:G167)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E167=\"\",$F167=\"\",$G167=\"\"),\"\",(ROUND(SUM(E167:G167)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E168=\"\",$F168=\"\",$G168=\"\"),\"\",(ROUND(SUM(E168:G168)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E168=\"\",$F168=\"\",$G168=\"\"),\"\",(ROUND(SUM(E168:G168)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E169=\"\",$F169=\"\",$G169=\"\"),\"\",(ROUND(SUM(E169:G169)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E169=\"\",$F169=\"\",$G169=\"\"),\"\",(ROUND(SUM(E169:G169)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E170=\"\",$F170=\"\",$G170=\"\"),\"\",(ROUND(SUM(E170:G170)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E170=\"\",$F170=\"\",$G170=\"\"),\"\",(ROUND(SUM(E170:G170)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E171=\"\",$F171=\"\",$G171=\"\"),\"\",(ROUND(SUM(E171:G171)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E171=\"\",$F171=\"\",$G171=\"\"),\"\",(ROUND(SUM(E171:G171)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E172=\"\",$F172=\"\",$G172=\"\"),\"\",(ROUND(SUM(E172:G172)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E172=\"\",$F172=\"\",$G172=\"\"),\"\",(ROUND(SUM(E172:G172)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E173=\"\",$F173=\"\",$G173=\"\"),\"\",(ROUND(SUM(E173:G173)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E173=\"\",$F173=\"\",$G173=\"\"),\"\",(ROUND(SUM(E173:G173)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E174=\"\",$F174=\"\",$G174=\"\"),\"\",(ROUND(SUM(E174:G174)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E174=\"\",$F174=\"\",$G174=\"\"),\"\",(ROUND(SUM(E174:G174)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E175=\"\",$F175=\"\",$G175=\"\"),\"\",(ROUND(SUM(E175:G175)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E175=\"\",$F175=\"\",$G175=\"\"),\"\",(ROUND(SUM(E175:G175)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E176=\"\",$F176=\"\",$G176=\"\"),\"\",(ROUND(SUM(E176:G176)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E176=\"\",$F176=\"\",$G176=\"\"),\"\",(ROUND(SUM(E176:G176)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E177=\"\",$F177=\"\",$G177=\"\"),\"\",(ROUND(SUM(E177:G177)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E177=\"\",$F177=\"\",$G177=\"\"),\"\",(ROUND(SUM(E177:G177)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E178=\"\",$F178=\"\",$G178=\"\"),\"\",(ROUND(SUM(E178:G178)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E178=\"\",$F178=\"\",$G178=\"\"),\"\",(ROUND(SUM(E178:G178)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E179=\"\",$F179=\"\",$G179=\"\"),\"\",(ROUND(SUM(E179:G179)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E179=\"\",$F179=\"\",$G179=\"\"),\"\",(ROUND(SUM(E179:G179)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E180=\"\",$F180=\"\",$G180=\"\"),\"\",(ROUND(SUM(E180:G180)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E180=\"\",$F180=\"\",$G180=\"\"),\"\",(ROUND(SUM(E180:G180)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E181=\"\",$F181=\"\",$G181=\"\"),\"\",(ROUND(SUM(E181:G181)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E181=\"\",$F181=\"\",$G181=\"\"),\"\",(ROUND(SUM(E181:G181)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E182=\"\",$F182=\"\",$G182=\"\"),\"\",(ROUND(SUM(E182:G182)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E182=\"\",$F182=\"\",$G182=\"\"),\"\",(ROUND(SUM(E182:G182)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E183=\"\",$F183=\"\",$G183=\"\"),\"\",(ROUND(SUM(E183:G183)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E183=\"\",$F183=\"\",$G183=\"\"),\"\",(ROUND(SUM(E183:G183)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E184=\"\",$F184=\"\",$G184=\"\"),\"\",(ROUND(SUM(E184:G184)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E184=\"\",$F184=\"\",$G184=\"\"),\"\",(ROUND(SUM(E184:G184)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E185=\"\",$F185=\"\",$G185=\"\"),\"\",(ROUND(SUM(E185:G185)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E185=\"\",$F185=\"\",$G185=\"\"),\"\",(ROUND(SUM(E185:G185)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E186=\"\",$F186=\"\",$G186=\"\"),\"\",(ROUND(SUM(E186:G186)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E186=\"\",$F186=\"\",$G186=\"\"),\"\",(ROUND(SUM(E186:G186)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E187=\"\",$F187=\"\",$G187=\"\"),\"\",(ROUND(SUM(E187:G187)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E187=\"\",$F187=\"\",$G187=\"\"),\"\",(ROUND(SUM(E187:G187)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E188=\"\",$F188=\"\",$G188=\"\"),\"\",(ROUND(SUM(E188:G188)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E188=\"\",$F188=\"\",$G188=\"\"),\"\",(ROUND(SUM(E188:G188)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E189=\"\",$F189=\"\",$G189=\"\"),\"\",(ROUND(SUM(E189:G189)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E189=\"\",$F189=\"\",$G189=\"\"),\"\",(ROUND(SUM(E189:G189)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E190=\"\",$F190=\"\",$G190=\"\"),\"\",(ROUND(SUM(E190:G190)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E190=\"\",$F190=\"\",$G190=\"\"),\"\",(ROUND(SUM(E190:G190)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E191=\"\",$F191=\"\",$G191=\"\"),\"\",(ROUND(SUM(E191:G191)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E191=\"\",$F191=\"\",$G191=\"\"),\"\",(ROUND(SUM(E191:G191)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E192=\"\",$F192=\"\",$G192=\"\"),\"\",(ROUND(SUM(E192:G192)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E192=\"\",$F192=\"\",$G192=\"\"),\"\",(ROUND(SUM(E192:G192)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E193=\"\",$F193=\"\",$G193=\"\"),\"\",(ROUND(SUM(E193:G193)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E193=\"\",$F193=\"\",$G193=\"\"),\"\",(ROUND(SUM(E193:G193)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E194=\"\",$F194=\"\",$G194=\"\"),\"\",(ROUND(SUM(E194:G194)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E194=\"\",$F194=\"\",$G194=\"\"),\"\",(ROUND(SUM(E194:G194)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E195=\"\",$F195=\"\",$G195=\"\"),\"\",(ROUND(SUM(E195:G195)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E195=\"\",$F195=\"\",$G195=\"\"),\"\",(ROUND(SUM(E195:G195)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E196=\"\",$F196=\"\",$G196=\"\"),\"\",(ROUND(SUM(E196:G196)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E196=\"\",$F196=\"\",$G196=\"\"),\"\",(ROUND(SUM(E196:G196)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E197=\"\",$F197=\"\",$G197=\"\"),\"\",(ROUND(SUM(E197:G197)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E197=\"\",$F197=\"\",$G197=\"\"),\"\",(ROUND(SUM(E197:G197)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E198=\"\",$F198=\"\",$G198=\"\"),\"\",(ROUND(SUM(E198:G198)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E198=\"\",$F198=\"\",$G198=\"\"),\"\",(ROUND(SUM(E198:G198)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E199=\"\",$F199=\"\",$G199=\"\"),\"\",(ROUND(SUM(E199:G199)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E199=\"\",$F199=\"\",$G199=\"\"),\"\",(ROUND(SUM(E199:G199)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E200=\"\",$F200=\"\",$G200=\"\"),\"\",(ROUND(SUM(E200:G200)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E200=\"\",$F200=\"\",$G200=\"\"),\"\",(ROUND(SUM(E200:G200)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E201=\"\",$F201=\"\",$G201=\"\"),\"\",(ROUND(SUM(E201:G201)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E201=\"\",$F201=\"\",$G201=\"\"),\"\",(ROUND(SUM(E201:G201)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E202=\"\",$F202=\"\",$G202=\"\"),\"\",(ROUND(SUM(E202:G202)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E202=\"\",$F202=\"\",$G202=\"\"),\"\",(ROUND(SUM(E202:G202)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E203=\"\",$F203=\"\",$G203=\"\"),\"\",(ROUND(SUM(E203:G203)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E203=\"\",$F203=\"\",$G203=\"\"),\"\",(ROUND(SUM(E203:G203)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E204=\"\",$F204=\"\",$G204=\"\"),\"\",(ROUND(SUM(E204:G204)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E204=\"\",$F204=\"\",$G204=\"\"),\"\",(ROUND(SUM(E204:G204)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E205=\"\",$F205=\"\",$G205=\"\"),\"\",(ROUND(SUM(E205:G205)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E205=\"\",$F205=\"\",$G205=\"\"),\"\",(ROUND(SUM(E205:G205)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E206=\"\",$F206=\"\",$G206=\"\"),\"\",(ROUND(SUM(E206:G206)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E206=\"\",$F206=\"\",$G206=\"\"),\"\",(ROUND(SUM(E206:G206)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E207=\"\",$F207=\"\",$G207=\"\"),\"\",(ROUND(SUM(E207:G207)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E207=\"\",$F207=\"\",$G207=\"\"),\"\",(ROUND(SUM(E207:G207)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E208=\"\",$F208=\"\",$G208=\"\"),\"\",(ROUND(SUM(E208:G208)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E208=\"\",$F208=\"\",$G208=\"\"),\"\",(ROUND(SUM(E208:G208)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E209=\"\",$F209=\"\",$G209=\"\"),\"\",(ROUND(SUM(E209:G209)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E209=\"\",$F209=\"\",$G209=\"\"),\"\",(ROUND(SUM(E209:G209)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E210=\"\",$F210=\"\",$G210=\"\"),\"\",(ROUND(SUM(E210:G210)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E210=\"\",$F210=\"\",$G210=\"\"),\"\",(ROUND(SUM(E210:G210)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E211=\"\",$F211=\"\",$G211=\"\"),\"\",(ROUND(SUM(E211:G211)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E211=\"\",$F211=\"\",$G211=\"\"),\"\",(ROUND(SUM(E211:G211)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E212=\"\",$F212=\"\",$G212=\"\"),\"\",(ROUND(SUM(E212:G212)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E212=\"\",$F212=\"\",$G212=\"\"),\"\",(ROUND(SUM(E212:G212)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E213=\"\",$F213=\"\",$G213=\"\"),\"\",(ROUND(SUM(E213:G213)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E213=\"\",$F213=\"\",$G213=\"\"),\"\",(ROUND(SUM(E213:G213)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E214=\"\",$F214=\"\",$G214=\"\"),\"\",(ROUND(SUM(E214:G214)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E214=\"\",$F214=\"\",$G214=\"\"),\"\",(ROUND(SUM(E214:G214)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E215=\"\",$F215=\"\",$G215=\"\"),\"\",(ROUND(SUM(E215:G215)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E215=\"\",$F215=\"\",$G215=\"\"),\"\",(ROUND(SUM(E215:G215)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E216=\"\",$F216=\"\",$G216=\"\"),\"\",(ROUND(SUM(E216:G216)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E216=\"\",$F216=\"\",$G216=\"\"),\"\",(ROUND(SUM(E216:G216)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E217=\"\",$F217=\"\",$G217=\"\"),\"\",(ROUND(SUM(E217:G217)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E217=\"\",$F217=\"\",$G217=\"\"),\"\",(ROUND(SUM(E217:G217)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E218=\"\",$F218=\"\",$G218=\"\"),\"\",(ROUND(SUM(E218:G218)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E218=\"\",$F218=\"\",$G218=\"\"),\"\",(ROUND(SUM(E218:G218)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E219=\"\",$F219=\"\",$G219=\"\"),\"\",(ROUND(SUM(E219:G219)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E219=\"\",$F219=\"\",$G219=\"\"),\"\",(ROUND(SUM(E219:G219)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E220=\"\",$F220=\"\",$G220=\"\"),\"\",(ROUND(SUM(E220:G220)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E220=\"\",$F220=\"\",$G220=\"\"),\"\",(ROUND(SUM(E220:G220)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(AND($E221=\"\",$F221=\"\",$G221=\"\"),\"\",(ROUND(SUM(E221:G221)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,25,FALSE),2)))","v":""},{"$f":"IF(AND($E221=\"\",$F221=\"\",$G221=\"\"),\"\",(ROUND(SUM(E221:G221)*VLOOKUP($E$7,'Rate Lookup'!$A$3:$AD$50,27,FALSE),2)))","v":""}]

{"sheet":"Rate Lookup","index":1,"n_rows":116,"n_cols":35,"rows_kept":116,"cut":false,"hidden":true,"merged":[[0,1,0,8]]}
["Data Needs entered","<<<<<<<      \"All Time\" entries are paid on hours worked     >>>>>>>"]
[null,null,"Straight Time","Time &   One-Half","Double Time",null,"Straight Time","Time &   One-Half","Double Time",null,"Straight Time","Time &   One-Half","Double Time",null,"All Time",null,"All Time",null,"All Time",null,"All Time",null,"All Time",null,"All Time",null,"All Time",null,null,null,null,"January, 2015","Rates Effective 8/1/2014",null,"Column1"]
["SIBA Rates Effective 8/1/2014","Welfare",7.1,{"$f":"ROUND(C3*1.5,2)","v":10.65},{"$f":"C3*2","v":14.2},"Pension",8.85,{"$f":"(G3*1.5)","v":13.274999999999999},{"$f":"G3*2","v":17.7},"Annuity",2.5499999999999998,{"$f":"ROUND(K3*1.5,2)","v":3.83},{"$f":"K3*2","v":5.0999999999999996},"Training",0.8,"LECET",1.22,"Dues 100",0.3,"Dues 397",0.2,"Dues 397 Non-SIBA","N/A","MW LPL",0.02,"Check-Off",0.5,null,null,null,null,"February, 2015","Rates Effective 8/1/2014",null,100]
["SIBA Rates Effective 8/1/2015","Welfare",7.4,{"$f":"ROUND(C4*1.5,2)","v":11.1},14.8,"Pension",9,13.5,18,"Annuity",2.8,{"$f":"ROUND(K4*1.5,2)","v":4.2},5.6,"Training",0.8,"LECET",1.22,"Dues 100",0.3,"Dues 397",0.2,"Dues 397 Non-SIBA","N/A","MW LPL",0.02,"Check-Off",0.5,null,null,null,null,"March, 2015","Rates Effective 8/1/2014",null,397]
["SIBA Rates Effective 8/1/2016","Welfare",8,{"$f":"ROUND(C5*1.5,2)","v":12},16,"Pension",9.25,13.875,18.5,"Annuity",3,{"$f":"ROUND(K5*1.5,2)","v":4.5},6,"Training",0.8,"LECET",1.28,"Dues 100",0.3,"Dues 397",0.2,"Dues 397 Non-SIBA","N/A","MW LPL",0.02,"Check-Off",0.55000000000000004,null,null,null,null,"April, 2015","Rates Effective 8/1/2014"]
["SIBA Rates Effective 8/1/2017","Welfare",8.25,{"$f":"(C6*1.5)","v":12.375},16.5,"Pension",9.75,14.625,19.5,"Annuity",3.65,{"$f":"(K6*1.5)","v":5.4749999999999996},7.3,"Training",0.8,"LECET",1.28,"Dues 100",0.3,"Dues 397",0.2,"Dues 397 Non-SIBA","N/A","MW LPL",0.02,"Check-Off",0.55000000000000004,null,null,null,null,"May, 2015","Rates Effective 8/1/2014",null,"Column1"]
["SIBA Rates Effective 8/1/2018","Welfare",8.25,12.375,16.5,"Pension",9.9,14.850000000000001,19.8,"Annuity",4.1500000000000004,6.2250000000000005,8.3000000000000007,"Training",0.8,"LECET",1.43,"Dues 100",0.3,"Dues 397",0.3,"Dues 397 Non-SIBA","N/A","MW LPL",0.02,"Check-Off",0.6,null,null,null,null,"June, 2015","Rates Effective 8/1/2014",null,"SIBA"]
["SIBA Rates Effective 8/1/2019","Welfare",8.3000000000000007,12.450000000000001,16.600000000000001,"Pension",10.4,15.600000000000001,20.8,"Annuity",4.5,6.75,9,"Training",0.8,"LECET",1.55,"Dues 100",0.3,"Dues 397",0.3,"Dues 397 Non-SIBA","N/A","MW LPL",0.02,"Check-Off",0.7,null,null,null,null,"July, 2015","Rates Effective 8/1/2014",null,"Non-SIBA"]
["SIBA Rates Effective 8/1/2020","Welfare",8.4499999999999993,12.674999999999999,{"$f":"C9*2","v":16.899999999999999},"Pension",10.9,{"$f":"(G9*1.5)","v":16.350000000000001},{"$f":"G9*2","v":21.8},"Annuity",5,7.5,{"$f":"K9*2","v":10},"Training",0.8,"LECET",1.55,"Dues 100",0.3,"Dues 397",0.5,"Dues 397 Non-SIBA","N/A","MW LPL",0.02,"Check-Off",0.7,null,null,null,null,"August, 2015","Rates Effective 8/1/2015",null,"Masonry"]
["SIBA Rates Effective 8/1/2021","Welfare",8.5500000000000007,12.825000000000001,{"$f":"C10*2","v":17.100000000000001},"Pension",11.4,{"$f":"(G10*1.5)","v":17.100000000000001},{"$f":"G10*2","v":22.8},"Annuity",5.5,8.25,{"$f":"K10*2","v":11},"Training",0.8,"LECET",1.65,"Dues 100",0.3,"Dues 397",0.6,"Dues 397 Non-SIBA","N/A","MW LPL",0.02,"Check-Off",0.72,null,null,null,null,"September, 2015","Rates Effective 8/1/2015"]
["SIBA Rates Effective 8/1/2022","Welfare",8.6,12.899999999999999,{"$f":"C11*2","v":17.2},"Pension",11.4,{"$f":"(G11*1.5)","v":17.100000000000001},{"$f":"G11*2","v":22.8},"Annuity",6.5,9.75,{"$f":"K11*2","v":13},"Training",0.8,"LECET",1.9,"Dues 100",0.3,"Dues 397",0.6,"Dues 397 Non-SIBA","N/A","MW LPL",0.02,"Check-Off",0.89,null,null,null,null,"October, 2015","Rates Effective 8/1/2015"]
["SIBA Rates Effective 8/1/2023","Welfare",8.6999999999999993,{"$f":"(C12*1.5)","v":13.049999999999999},{"$f":"C12*2","v":17.399999999999999},"Pension",11.4,{"$f":"(G12*1.5)","v":17.100000000000001},{"$f":"G12*2","v":22.8},"Annuity",7.5,{"$f":"(K12*1.5)","v":11.25},{"$f":"K12*2","v":15},"Training",0.8,"LECET",2.0099999999999998,"Dues 100",0.3,"Dues 397",0.6,"Dues 397 Non-SIBA","N/A","MW LPL",0.05,"Check-Off",0.92,null,null,null,null,"November, 2015","Rates Effective 8/1/2015"]
["Non-SIBA Rates Effective 8/1/2014","Welfare",{"$f":"C3","v":7.1},{"$f":"ROUND(C13*1.5,2)","v":10.65},14.2,"Pension",{"$f":"G3","v":8.85},13.274999999999999,17.7,"Annuity",{"$f":"K3","v":2.5499999999999998},{"$f":"ROUND(K13*1.5,2)","v":3.83},5.0999999999999996,"Training",{"$f":"O3","v":0.8},"LECET",1.1200000000000001,"Dues 100",{"$f":"S3","v":0.3},"Dues 397","N/A","Dues 397 Non-SIBA",0.3,"MW LPL",{"$f":"Y3","v":0.02},"Check-Off",0.5,null,null,null,null,"December, 2015","Rates Effective 8/1/2015",null,"Yes"]
["Non-SIBA Rates Effective 8/1/2015","Welfare",7.4,{"$f":"ROUND(C14*1.5,2)","v":11.1},14.8,"Pension",9,13.5,18,"Annuity",2.8,{"$f":"ROUND(K14*1.5,2)","v":4.2},5.6,"Training",0.8,"LECET",1.1200000000000001,"Dues 100",0.3,"Dues 397","N/A","Dues 397 Non-SIBA",0.3,"MW LPL",0.02,"Check-Off",0.5,null,null,null,null,"January, 2016","Rates Effective 8/1/2015",null,"No"]
["Non-SIBA Rates Effective 8/1/2016","Welfare",8,{"$f":"ROUND(C15*1.5,2)","v":12},16,"Pension",9.25,13.875,18.5,"Annuity",3,{"$f":"ROUND(K15*1.5,2)","v":4.5},6,"Training",0.8,"LECET",1.18,"Dues 100",0.3,"Dues 397","N/A","Dues 397 Non-SIBA",0.3,"MW LPL",0.02,"Check-Off",0.55000000000000004,null,null,null,null,"February, 2016","Rates Effective 8/1/2015"]
["Non-SIBA Rates Effective 8/1/2017","Welfare",8.25,{"$f":"(C16*1.5)","v":12.375},16.5,"Pension",9.75,14.625,19.5,"Annuity",3.65,{"$f":"(K16*1.5)","v":5.4749999999999996},7.3,"Training",0.8,"LECET",1.18,"Dues 100",0.3,"Dues 397","N/A","Dues 397 Non-SIBA",0.3,"MW LPL",0.02,"Check-Off",0.55000000000000004,null,null,null,null,"March, 2016","Rates Effective 8/1/2015"]
["Non-SIBA Rates Effective 8/1/2018","Welfare",8.25,12.375,16.5,"Pension",9.9,14.850000000000001,19.8,"Annuity",4.1500000000000004,6.2250000000000005,8.3000000000000007,"Training",0.8,"LECET",1.33,"Dues 100",0.3,"Dues 397","N/A","Dues 397 Non-SIBA",0.4,"MW LPL",0.02,"Check-Off",0.6,null,null,null,null,"April, 2016","Rates Effective 8/1/2015"]
["Non-SIBA Rates Effective 8/1/2019","Welfare",8.3000000000000007,12.450000000000001,16.600000000000001,"Pension",10.4,15.600000000000001,20.8,"Annuity",4.5,6.75,9,"Training",0.8,"LECET",1.45,"Dues 100",0.3,"Dues 397","N/A","Dues 397 Non-SIBA",0.4,"MW LPL",0.02,"Check-Off",0.7,null,null,null,null,"May, 2016","Rates Effective 8/1/2015"]
["Non-SIBA Rates Effective 8/1/2020","Welfare",8.4499999999999993,12.674999999999999,16.899999999999999,"Pension",10.9,16.350000000000001,21.8,"Annuity",5,7.5,10,"Training",0.8,"LECET",1.45,"Dues 100",0.3,"Dues 397","N/A","Dues 397 Non-SIBA",0.6,"MW LPL",0.02,"Check-Off",0.7,null,null,null,null,"June, 2016","Rates Effective 8/1/2015"]
["Non-SIBA Rates Effective 8/1/2021","Welfare",8.5500000000000007,12.825000000000001,17.100000000000001,"Pension",11.4,17.100000000000001,22.8,"Annuity",5.5,8.25,11,"Training",0.8,"LECET",1.55,"Dues 100",0.3,"Dues 397","N/A","Dues 397 Non-SIBA",0.7,"MW LPL",0.02,"Check-Off",0.72,null,null,null,null,"July, 2016","Rates Effective 8/1/2015"]
["Non-SIBA Rates Effective 8/1/2022","Welfare",8.6,12.899999999999999,17.2,"Pension",11.4,17.100000000000001,22.8,"Annuity",6.5,9.75,13,"Training",0.8,"LECET",1.75,"Dues 100",0.3,"Dues 397","N/A","Dues 397 Non-SIBA",0.75,"MW LPL",0.02,"Check-Off",0.89,null,null,null,null,"August, 2016","Rates Effective 8/1/2016"]
["Non-SIBA Rates Effective 8/1/2023","Welfare",8.6999999999999993,13.049999999999999,{"$f":"C22*2","v":17.399999999999999},"Pension",11.4,{"$f":"(G22*1.5)","v":17.100000000000001},{"$f":"G22*2","v":22.8},"Annuity",7.5,11.25,{"$f":"K22*2","v":15},"Training",0.8,"LECET",1.86,"Dues 100",0.3,"Dues 397","N/A","Dues 397 Non-SIBA",0.75,"MW LPL",0.05,"Check-Off",0.92,null,null,null,null,"September, 2016","Rates Effective 8/1/2016"]
["Masonry Rates Effective 8/1/2014","Welfare",{"$f":"C3","v":7.1},{"$f":"ROUND(C23*1.5,2)","v":10.65},14.2,"Pension",{"$f":"G3","v":8.85},13.274999999999999,17.7,"Annuity",{"$f":"K3","v":2.5499999999999998},{"$f":"ROUND(K23*1.5,2)","v":3.83},5.0999999999999996,"Training",{"$f":"O3","v":0.8},"LECET",1.17,"Dues 100",{"$f":"S3","v":0.3},"Dues 397",{"$f":"U3","v":0.2},"Dues 397 Non-SIBA","N/A","MW LPL",{"$f":"Y3","v":0.02},"Check-Off",0.5,null,null,null,null,"October, 2016","Rates Effective 8/1/2016"]
["Masonry Rates Effective 8/1/2015","Welfare",7.4,{"$f":"ROUND(C24*1.5,2)","v":11.1},14.8,"Pension",9,13.5,18,"Annuity",2.8,{"$f":"ROUND(K24*1.5,2)","v":4.2},5.6,"Training",0.8,"LECET",1.17,"Dues 100",0.3,"Dues 397",0.2,"Dues 397 Non-SIBA","N/A","MW LPL",0.02,"Check-Off",0.5,null,null,null,null,"November, 2016","Rates Effective 8/1/2016"]
["Masonry Rates Effective 8/1/2016","Welfare",8,{"$f":"ROUND(C25*1.5,2)","v":12},16,"Pension",9.25,13.875,18.5,"Annuity",3,{"$f":"ROUND(K25*1.5,2)","v":4.5},6,"Training",0.8,"LECET",1.33,"Dues 100",0.3,"Dues 397",0.2,"Dues 397 Non-SIBA","N/A","MW LPL",0.02,"Check-Off",0.55000000000000004,null,null,null,null,"December, 2016","Rates Effective 8/1/2016"]
["Masonry Rates Effective 8/1/2017","Welfare",8.25,{"$f":"(C26*1.5)","v":12.375},16.5,"Pension",9.75,14.625,19.5,"Annuity",3.65,{"$f":"(K26*1.5)","v":5.4749999999999996},7.3,"Training",0.8,"LECET",1.33,"Dues 100",0.3,"Dues 397",0.2,"Dues 397 Non-SIBA","N/A","MW LPL",0.02,"Check-Off",0.55000000000000004,null,null,null,null,"January, 2017","Rates Effective 8/1/2016"]
["Masonry Rates Effective 8/1/2018","Welfare",8.25,12.375,16.5,"Pension",9.9,14.850000000000001,19.8,"Annuity",4.1500000000000004,6.2250000000000005,8.3000000000000007,"Training",0.8,"LECET",1.48,"Dues 100",0.3,"Dues 397",0.3,"Dues 397 Non-SIBA","N/A","MW LPL",0.02,"Check-Off",0.6,null,null,null,null,"February, 2017","Rates Effective 8/1/2016"]
["Masonry Rates Effective 8/1/2019","Welfare",8.3000000000000007,12.450000000000001,16.600000000000001,"Pension",10.4,15.600000000000001,20.8,"Annuity",4.5,6.75,9,"Training",0.8,"LECET",1.6,"Dues 100",0.3,"Dues 397",0.3,"Dues 397 Non-SIBA","N/A","MW LPL",0.02,"Check-Off",0.7,null,null,null,null,"March, 2017","Rates Effective 8/1/2016"]
["Masonry Rates Effective 8/1/2020","Welfare",8.4499999999999993,12.674999999999999,16.899999999999999,"Pension",10.9,16.350000000000001,21.8,"Annuity",5,7.5,10,"Training",0.8,"LECET",1.6,"Dues 100",0.3,"Dues 397",0.5,"Dues 397 Non-SIBA","N/A","MW LPL",0.02,"Check-Off",0.7,null,null,null,null,"April, 2017","Rates Effective 8/1/2016"]
["Masonry Rates Effective 8/1/2021","Welfare",8.5500000000000007,12.825000000000001,17.100000000000001,"Pension",11.4,17.100000000000001,22.8,"Annuity",5.5,8.25,11,"Training",0.8,"LECET",1.7,"Dues 100",0.3,"Dues 397",0.6,"Dues 397 Non-SIBA","N/A","MW LPL",0.02,"Check-Off",0.72,null,null,null,null,"May, 2017","Rates Effective 8/1/2016"]
["Masonry Rates Effective 8/1/2022","Welfare",8.6,12.899999999999999,17.2,"Pension",11.4,17.100000000000001,22.8,"Annuity",6.5,9.75,13,"Training",0.8,"LECET",1.9,"Dues 100",0.3,"Dues 397",0.6,"Dues 397 Non-SIBA","N/A","MW LPL",0.02,"Check-Off",0.89,null,null,null,null,"June, 2017","Rates Effective 8/1/2016"]
["Masonry Rates Effective 8/1/2023","Welfare",8.6999999999999993,13.049999999999999,17.399999999999999,"Pension",11.4,17.100000000000001,22.8,"Annuity",7.5,11.25,15,"Training",0.8,"LECET",2.0099999999999998,"Dues 100",0.3,"Dues 397",0.6,"Dues 397 Non-SIBA","N/A","MW LPL",0.05,"Check-Off",0.92,null,null,null,null,"July, 2017","Rates Effective 8/1/2016"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"October, 2016","Rates Effective 8/1/2016"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"November, 2016","Rates Effective 8/1/2016"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"December, 2016","Rates Effective 8/1/2016"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"January, 2017","Rates Effective 8/1/2016"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"February, 2017","Rates Effective 8/1/2016"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"March, 2017","Rates Effective 8/1/2016"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"April, 2017","Rates Effective 8/1/2016"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"May, 2017","Rates Effective 8/1/2016"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"June, 2017","Rates Effective 8/1/2016"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"July, 2017","Rates Effective 8/1/2016"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"June, 2018","Rates Effective 8/1/2017"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"July, 2018","Rates Effective 8/1/2017"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"August, 2018","Rates Effective 8/1/2018"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"September, 2018","Rates Effective 8/1/2018"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"October, 2018","Rates Effective 8/1/2018"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"November, 2018","Rates Effective 8/1/2018"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"December, 2018","Rates Effective 8/1/2018"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"January, 2019","Rates Effective 8/1/2018"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"February, 2019","Rates Effective 8/1/2018"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"March, 2019","Rates Effective 8/1/2018"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"April, 2019","Rates Effective 8/1/2018"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"May, 2019","Rates Effective 8/1/2018"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"June, 2019","Rates Effective 8/1/2018"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"July, 2019","Rates Effective 8/1/2018"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"August, 2019","Rates Effective 8/1/2019"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"September, 2019","Rates Effective 8/1/2019"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"October, 2019","Rates Effective 8/1/2019"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"November, 2019","Rates Effective 8/1/2019"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"December, 2019","Rates Effective 8/1/2019"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"January, 2020","Rates Effective 8/1/2019"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"February, 2020","Rates Effective 8/1/2019"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"March, 2020","Rates Effective 8/1/2019"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"April, 2020","Rates Effective 8/1/2019"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"May, 2020","Rates Effective 8/1/2019"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"June, 2020","Rates Effective 8/1/2019"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"July, 2020","Rates Effective 8/1/2019"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"August, 2020","Rates Effective 8/1/2020"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"September, 2020","Rates Effective 8/1/2020"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"October, 2020","Rates Effective 8/1/2020"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"November, 2020","Rates Effective 8/1/2020"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"December, 2020","Rates Effective 8/1/2020"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"January, 2021","Rates Effective 8/1/2020"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"February, 2021","Rates Effective 8/1/2020"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"March, 2021","Rates Effective 8/1/2020"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"April, 2021","Rates Effective 8/1/2020"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"May, 2021","Rates Effective 8/1/2020"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"June, 2021","Rates Effective 8/1/2020"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"July, 2021","Rates Effective 8/1/2020"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"August, 2021","Rates Effective 8/1/2021"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"September, 2021","Rates Effective 8/1/2021"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"October, 2021","Rates Effective 8/1/2021"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"November, 2021","Rates Effective 8/1/2021"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"December, 2021","Rates Effective 8/1/2021"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"January, 2022","Rates Effective 8/1/2021"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"February, 2022","Rates Effective 8/1/2021"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"March, 2022","Rates Effective 8/1/2021"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"April, 2022","Rates Effective 8/1/2021"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"May, 2022","Rates Effective 8/1/2021"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"June, 2022","Rates Effective 8/1/2021"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"July, 2022","Rates Effective 8/1/2021"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"August, 2022","Rates Effective 8/1/2022"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"September, 2022","Rates Effective 8/1/2022"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"October, 2022","Rates Effective 8/1/2022"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"November, 2022","Rates Effective 8/1/2022"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"December, 2022","Rates Effective 8/1/2022"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"January, 2023","Rates Effective 8/1/2022"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"February, 2023","Rates Effective 8/1/2022"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"March, 2023","Rates Effective 8/1/2022"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"April, 2023","Rates Effective 8/1/2022"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"May, 2023","Rates Effective 8/1/2022"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"June, 2023","Rates Effective 8/1/2022"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"July, 2023","Rates Effective 8/1/2022"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"August, 2023","Rates Effective 8/1/2023"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"September, 2023","Rates Effective 8/1/2023"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"October, 2023","Rates Effective 8/1/2023"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"November, 2023","Rates Effective 8/1/2023"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"December, 2023","Rates Effective 8/1/2023"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"January, 2024","Rates Effective 8/1/2023"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"February, 2024","Rates Effective 8/1/2023"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"March, 2024","Rates Effective 8/1/2023"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"April, 2024","Rates Effective 8/1/2023"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"May, 2024","Rates Effective 8/1/2023"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"June, 2024","Rates Effective 8/1/2023"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"July, 2024","Rates Effective 8/1/2023"]