{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["INPUT HOURS & CALC FRINGES","TRADES_RATES","TOTALS and CERTIFY"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"INPUT HOURS & CALC FRINGES","index":0,"n_rows":107,"n_cols":28,"rows_kept":107,"cut":false,"hidden":false,"merged":[[103,19,103,26],[5,1,5,3],[9,0,9,5],[9,6,9,7],[5,5,5,6],[6,5,6,6],[7,5,7,6],[9,10,9,11],[5,7,5,11],[6,7,6,11],[7,7,7,11],[9,14,9,26],[9,8,9,9],[103,13,104,13],[106,6,106,10],[103,6,103,10],[2,7,2,11],[3,7,3,11],[4,7,4,11],[2,5,2,6],[3,5,3,6],[4,5,4,6],[0,0,0,11],[103,12,104,12],[104,6,104,10],[105,6,105,10],[1,0,1,4],[3,1,3,3],[4,1,4,3],[103,0,103,4]]}
["Fringe Benefit Remittance Form to PIPE TRADES SERVICES MN"]
["On Behalf of EMPLOYEES WORKING UNDER JURISDICTION OF Sprinklersfitters Local 417"]
["For Payroll Periods: May 1, 2015-April 30, 2016",null,null,null,null,"Employer Tax ID:"]
["Last Payroll Date Paid:",null,null,null,null,"Employer Name:"]
["Report for the Month of:",null,null,null,null,"Office Address:"]
[null,null,null,null,null,"City, State  Zip: "]
["Check here if there will be no hours to report next month",null,null,null,null,"Phone #"]
[null,null,null,null,null,"Fax #"]
[]
["Enter Monthly Reporting",null,null,null,null,null,"Total Hours",null,"Dues Calc",null,"PYRAMID FRINGES",null,null,null,"NON PYRAMID FRINGES"]
["NAME OF EMPLOYEE                 (in alphabetical order by lastname, firstname)","SOC. SEC. #    (123-45-6789)","TRADE CODE","REGULAR     TIME","TIME            & 1/2","DOUBLE     TIME","TOTAL HOURS WORKED","TOTAL HOURS that PYRAMID","Gross Wages","Dues","H&W Rate","Total H&W Paid","Total Non Pyramid Fringes","Total Fringe to PTSMN","Supplement Pension Rate","Total Supplement Pension","Apprenticeship Rate","Total Apprenticeship","Industry Promotion Rate","Total Industry Promotion","Building Fund Rate","Total Building Fund","UA Training Rate","Total for UA Training","Vacation Rate","Total for Vacation","Total Non Pyramid Fringes","Total Fringe to PTSMN"]
[null,null,null,null,null,null,{"$f":"SUM(D12:F12)","v":0},{"$f":"D12+(E12*1.5)+(F12*2)","v":0},null,{"$f":"IF(I12 <> 0, ROUND(I12*0.04,2),0)","v":0},{"$f":"IF($H12 <> 0, (VLOOKUP($C12,TRADE_RATES,3,FALSE)),0)","v":0},{"$f":"ROUND($H12*$K12,2)","v":0},{"$f":"P12+R12+T12+V12+X12+Z12","v":0},{"$f":"SUM(L12,P12,R12,T12,V12,X12,Z12)","v":0},{"$f":"IF($G12 <> 0, (VLOOKUP($C12,TRADE_RATES,5,FALSE)),0)","v":0},{"$f":"ROUND($G12*$O12,2)","v":0},{"$f":"IF($G12 <> 0, (VLOOKUP($C12,TRADE_RATES,6,FALSE)),0)","v":0},{"$f":"ROUND($G12*$Q12,2)","v":0},{"$f":"IF($G12 <> 0, (VLOOKUP($C12,TRADE_RATES,7,FALSE)),0)","v":0},{"$f":"ROUND($G12*$S12,2)","v":0},{"$f":"IF($G12 <> 0, (VLOOKUP($C12,TRADE_RATES,8,FALSE)),0)","v":0},{"$f":"ROUND($G12*$U12,2)","v":0},{"$f":"IF($G12 <> 0, (VLOOKUP($C12,TRADE_RATES,9,FALSE)),0)","v":0},{"$f":"ROUND($G12*$W12,2)","v":0},{"$f":"IF($G12 <> 0, (VLOOKUP($C12,TRADE_RATES,10,FALSE)),0)","v":0},{"$f":"ROUND($G12*$Y12,2)","v":0},{"$f":"P12+R12+T12+V12+X12+Z12","v":0},{"$f":"SUM(L12,P12,R12,T12,V12,X12,Z12)","v":0}]
[null,null,null,null,null,null,0,0,null,{"$f":"IF(I13 <> 0, ROUND(I13*0.04,2),0)","v":0},0,{"$f":"ROUND($H13*$K13,2)","v":0},{"$f":"P13+R13+T13+V13+X13+Z13","v":0},{"$f":"SUM(L13,P13,R13,T13,V13,X13,Z13)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P13+R13+T13+V13+X13+Z13","v":0},{"$f":"SUM(L13,P13,R13,T13,V13,X13,Z13)","v":0}]
[null,null,null,null,null,null,0,{"$f":"D14+(E14*1.5)+(F14*2)","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,{"$f":"D15+(E15*1.5)+(F15*2)","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,{"$f":"SUM(D43:F43)","v":0},{"$f":"D43+(E43*1.5)+(F43*2)","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(L43,P43,R43,T43,V43,X43,Z43)","v":0}]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,{"$f":"IF($G44 <> 0, (VLOOKUP($C44,TRADE_RATES,5,FALSE)),0)","v":0},0,{"$f":"IF($G44 <> 0, (VLOOKUP($C44,TRADE_RATES,6,FALSE)),0)","v":0},0,{"$f":"IF($G44 <> 0, (VLOOKUP($C44,TRADE_RATES,7,FALSE)),0)","v":0},0,{"$f":"IF($G44 <> 0, (VLOOKUP($C44,TRADE_RATES,8,FALSE)),0)","v":0},0,{"$f":"IF($G44 <> 0, (VLOOKUP($C44,TRADE_RATES,9,FALSE)),0)","v":0},0,{"$f":"IF($G44 <> 0, (VLOOKUP($C44,TRADE_RATES,10,FALSE)),0)","v":0},0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,{"$f":"IF($H76 <> 0, (VLOOKUP($C76,TRADE_RATES,3,FALSE)),0)","v":0},0,0,0,{"$f":"IF($G76 <> 0, (VLOOKUP($C76,TRADE_RATES,5,FALSE)),0)","v":0},{"$f":"ROUND($G76*$O76,2)","v":0},{"$f":"IF($G76 <> 0, (VLOOKUP($C76,TRADE_RATES,6,FALSE)),0)","v":0},{"$f":"ROUND($G76*$Q76,2)","v":0},{"$f":"IF($G76 <> 0, (VLOOKUP($C76,TRADE_RATES,7,FALSE)),0)","v":0},{"$f":"ROUND($G76*$S76,2)","v":0},{"$f":"IF($G76 <> 0, (VLOOKUP($C76,TRADE_RATES,8,FALSE)),0)","v":0},{"$f":"ROUND($G76*$U76,2)","v":0},{"$f":"IF($G76 <> 0, (VLOOKUP($C76,TRADE_RATES,9,FALSE)),0)","v":0},{"$f":"ROUND($G76*$W76,2)","v":0},{"$f":"IF($G76 <> 0, (VLOOKUP($C76,TRADE_RATES,10,FALSE)),0)","v":0},{"$f":"ROUND($G76*$Y76,2)","v":0},0,0]
[null,null,null,null,null,null,0,0,null,{"$f":"IF(I77 <> 0, ROUND(I77*0.04,2),0)","v":0},0,{"$f":"ROUND($H77*$K77,2)","v":0},{"$f":"P77+R77+T77+V77+X77+Z77","v":0},{"$f":"SUM(L77,P77,R77,T77,V77,X77,Z77)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"P77+R77+T77+V77+X77+Z77","v":0},0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,{"$f":"SUM(D91:F91)","v":0},{"$f":"D91+(E91*1.5)+(F91*2)","v":0},null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(L91,P91,R91,T91,V91,X91,Z91)","v":0}]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[" "]
[null,"Total Hours:",null,{"$f":"SUM(D12:D100)","v":0},{"$f":"SUM(E12:E100)","v":0},{"$f":"SUM(F12:F100)","v":0},{"$f":"SUM(G12:G100)","v":0},{"$f":"SUM(H12:H100)","v":0},null,{"$f":"SUM(J12:J100)","v":0},null,{"$f":"SUM(L12:L100)","v":0},null,{"$f":"SUM(AB12:AB100)","v":0},null,{"$f":"SUM(P12:P100)","v":0},null,{"$f":"SUM(R12:R100)","v":0},null,{"$f":"SUM(T12:T100)","v":0},null,{"$f":"SUM(V12:V100)","v":0},null,{"$f":"SUM(X12:X100)","v":0},null,{"$f":"SUM(Z12:Z100)","v":0},{"$f":"SUM(AA12:AA100)","v":0},{"$f":"SUM(AB12:AB100)","v":0}]
[]
["Mail 1 copy (use \"Print for PTSMN\" button above) with a check before the 15th of the month to:",null,null,null,null,null,"Mail one copy (use \"Print for PTSMN\" button above) with a check for Dues only to: ",null,null,null,null,null,"GRAND TOTAL TO PTSMN:",{"$f":"AB102","v":0},null,null,null,null,null,"GRAND TOTAL FRINGES TO REMIT TO PTSMN with copy of this sheet: ",null,null,null,null,null,null,null,{"$f":"AB102","v":0}]
["PIPE TRADES SERVICES MN",null,null,null,null,null,"Sprinkler Fitters Local 417"]
["700 TRANSFER ROAD",null,null,null,null,null,"1404 Central Avenue NE"]
["ST PAUL, MN  55114",null,null,null,null,null,"Minneapolis, MN 55413"]

{"sheet":"TRADES_RATES","index":1,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,0,1,8],[0,0,0,11]]}
["TRADE RATES GRID"]
["NON TAXABLE FRINGE",null,null,null,null,null,null,null,null,"TAXABLE"]
["Trade Code","Trade Description","Health & Welfare",null,"Supplement Pension","Apprenticeship","Industry Promotion","Building Fund","UA Training Fund","Credit Union","TOTAL WORKED FRINGE","Total Fringe to PTSMN"]
[null,null,"PD",null,"WRK","WRK","WRK","WRK","WRK","WRK"]
["S","Journeyman-Sprinklerfitter",9.11,null,7.25,0.59,0.44,0.1,0.1,1,{"$f":"SUM(E5:J5)","v":9.4799999999999986},{"$f":"C5+K5","v":18.589999999999996}]
["S3","Apprentice at Journeyman Fringe",9.11,null,7.25,0.59,0.44,0.1,0.1,1,{"$f":"SUM(E6:J6)","v":9.4799999999999986},{"$f":"C6+K6","v":18.589999999999996}]
["S2","Apprentice at Lower Fringe",9.11,null,0,0.59,0.44,0.1,0.1,1,{"$f":"SUM(E7:J7)","v":2.2300000000000004},11.34]
["SC","City Journeyman",9.11,null,7.25,0.59,null,0.1,0.1,1,{"$f":"SUM(E8:J8)","v":9.0399999999999991},18.149999999999999]
["SS","School Journeyman",9.11,null,7.25,0.59,0.44,0.1,0.1,null,{"$f":"SUM(E9:J9)","v":8.4799999999999986},17.589999999999996]

{"sheet":"TOTALS and CERTIFY","index":2,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[7,11,11,11],[6,5,6,10],[8,5,8,10],[10,5,10,10],[1,0,1,3],[6,0,8,3],[0,0,0,3],[2,0,2,3],[3,0,3,3],[4,0,4,3],[5,0,5,3]]}
["NOTICE!",null,null,null,"I certify this is a true and complete report of hours worked and that the contributions reflected "]
["Mail 1 copy with a check before the 15th of the month to:",null,null,null,"herein are made in conformity with the provisions dealing with contributions to the Funds in the "]
["PIPE TRADES SERVICES MN",null,null,null,"Collective Bargaining Agreement between the Union and Employers who executed the agreement and "]
["700 TRANSFER ROAD",null,null,null,"the Declaration of Trust establishing the Funds."]
["ST PAUL, MN  55114"]
["With check payable to: Pipe Trades Services MN"]
["This Fringe Benefit Report is DUE BY THE 15th of each month. Payments and reports RECEIVED AFTER THE 20th will be assessed liquidated damages at the following rates:",null,null,null,"Prepared By:"]
[]
[null,null,null,null,"Phone:"]
["1-10 days late = 3% of total fringes payable"]
["11 or more days late = 10% of total fringes payable",null,null,null,"Email:"]
[]
[]
["Total H&W Paid","Total Supplement Pension","Total Apprenticeship","Total Industry Promotion","Total Building Fund","Total for UA Training","Total for Vacation","Total Non Pyramid Fringes",null,"TOTAL FRINGE TO PTSMN"]
[{"$f":"'INPUT HOURS & CALC FRINGES'!L102","v":0},{"$f":"'INPUT HOURS & CALC FRINGES'!P102","v":0},{"$f":"'INPUT HOURS & CALC FRINGES'!R102","v":0},{"$f":"'INPUT HOURS & CALC FRINGES'!T102","v":0},{"$f":"'INPUT HOURS & CALC FRINGES'!V102","v":0},{"$f":"'INPUT HOURS & CALC FRINGES'!X102","v":0},{"$f":"'INPUT HOURS & CALC FRINGES'!Z102","v":0},{"$f":"'INPUT HOURS & CALC FRINGES'!AA102","v":0},null,{"$f":"'INPUT HOURS & CALC FRINGES'!AB102","v":0}]