{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["School Invoice","Personnel Detail","Non-Personnel Detail"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":1,"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":"School Invoice","index":0,"n_rows":41,"n_cols":17,"rows_kept":41,"cut":false,"hidden":false,"merged":[[9,0,9,3],[9,6,9,7],[9,8,9,9],[4,0,4,2],[4,4,4,6],[4,8,4,9],[5,0,5,2],[5,4,5,6],[7,0,7,3],[10,0,10,3],[10,6,10,7],[10,8,10,9],[18,0,18,2],[18,3,18,4],[18,5,18,9],[13,2,14,9],[19,0,19,2],[19,3,19,4],[19,5,19,9],[23,0,23,9],[40,0,40,5],[40,6,40,9],[21,0,21,2],[21,3,21,4],[21,5,21,9],[22,0,22,2],[22,3,22,4],[22,5,22,9],[9,10,10,13],[4,10,4,13],[5,10,5,13],[6,10,6,13],[20,0,20,2],[20,3,20,4],[20,5,20,9],[11,0,11,3],[11,6,11,7],[11,8,11,9],[16,0,16,2],[16,3,16,4],[16,5,16,9],[17,0,17,2],[17,3,17,4],[17,5,17,9],[2,16,4,16],[8,10,8,14],[0,10,3,13],[7,10,7,13],[8,0,8,3],[8,6,8,7],[8,8,8,9],[6,4,6,6],[7,4,7,9],[0,0,0,2],[0,3,0,9],[1,0,1,2],[1,3,2,9],[2,0,2,1],[3,0,3,9],[6,0,6,2]]}
["School Name(s):"]
["Fiduciary Name:"]
["Same as school?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Updated after new billing #?"]
[]
["Prime Contract #:",null,null,"2012-0730","Billing # (first billing will be 1, etc.):",null,null,null,null,null,"<= Update FIRST for each billing"]
["Job #:",null,null,116005,"Billing Period (beginning to end dates):",null,null,null,"-",null,{"$f":"IF(Q6<>\"yes\", \"Update both dates for each billing\",\"\")","v":"Update both dates for each billing"}]
["Authorization #:",null,null,6,"Cumulative % of Award Activities Completed:",null,null,null,null,null,{"$f":"IF(Q7<>\"yes\", \"Update total percent complete for each billing\",\"\")","v":"Update total percent complete for each billing"}]
["Found on subagreement/award summary\nEnter for 1st billing, same for all others"]
["BUDGET CATEGORIES\n(from award summary)",null,null,null,"TOTAL\nBUDGET","EXPENDED\nTHIS PERIOD","CUMULATIVE EXPENDITURES",null,"REMAINING BALANCE",null,"CUMULATIVE EXPENDITURES must be updated for each billing, enter zero if none to date"]
["Personnel Expense\n(attach detail)",null,null,null,null,{"$f":"'Personnel Detail'!K126","v":0},null,null,{"$f":"SUM(E10-G10)","v":0},null,"TOTAL BUDGET can be updated as needed\n\nEXPENDED THIS PERIOD will autofill from Personnel and Non-Personnel Details\n\nREMAINING BALANCE and GRAND TOTALS will calculate automatically"]
["Non-personnel Expense\n(attach detail)",null,null,null,null,{"$f":"'Non-Personnel Detail'!F42","v":0},null,null,{"$f":"SUM(E11-G11)","v":0}]
["GRAND TOTAL",null,null,null,{"$f":"SUM(E10:E11)","v":0},{"$f":"SUM(F10:F11)","v":0},0,null,{"$f":"SUM(I10:J11)","v":0}]
[]
[null,null,"Mark this box to acknowledge that documentation of all expenses, including timesheets and other payroll documents, must be kept until the final MDOT audit."]
[]
[]
["Check Payable To:",null,null,null,null,"Questions and invoice submission:"]
["Address:",null,null,null,null,"April Morrison-Harke, SR2S Contracts Coordinator"]
["City, State, Zip:",null,null,null,null,"Michigan Fitness Foundation"]
[null,null,null,null,null,"P.O. Box 27187, Lansing, MI  48909"]
["Invoice Completed by:",null,null,null,null,"Phone: 517.908.3832"]
["Contact Phone:",null,null,null,null,"Fax:  517.347.8145"]
["Contact Email:",null,null,null,null,"Email: amorrison-harke@michiganfitness.org"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["MFF OFFICE USE ONLY: CONFIRMATION OF JOB #__________________________",null,null,null,null,null,"GL #74000-200-260"]

{"sheet":"Personnel Detail","index":1,"n_rows":128,"n_cols":29,"rows_kept":128,"cut":false,"hidden":false,"merged":[[0,0,0,2],[0,3,0,12],[1,0,1,2],[1,3,1,12],[2,0,2,12],[3,0,3,2],[3,3,3,5],[3,11,3,12],[6,0,8,6],[6,7,6,9],[7,7,8,12],[7,13,8,13],[4,0,4,2],[4,3,4,5],[3,6,3,9],[5,0,5,2],[5,3,5,5],[4,6,4,9],[13,0,13,2],[13,3,14,5],[13,6,14,6],[13,7,14,7],[13,8,14,8],[13,9,14,9],[13,10,14,10],[13,11,14,12],[14,0,14,2],[18,11,18,12],[19,0,19,2],[19,11,19,12],[20,3,20,5],[20,11,20,12],[21,3,21,5],[21,11,21,12],[15,11,15,12],[16,11,16,12],[17,11,17,12],[26,11,26,12],[27,11,27,12],[28,11,28,12],[24,0,24,2],[24,3,25,5],[24,6,25,6],[24,7,25,7],[24,8,25,8],[24,9,25,9],[24,10,25,10],[24,11,25,12],[26,0,26,1],[51,11,51,12],[52,0,52,2],[52,11,52,12],[53,3,53,5],[53,11,53,12],[54,3,54,5],[54,11,54,12],[53,0,54,1],[47,0,47,2],[48,11,48,12],[49,11,49,12],[50,11,50,12],[46,3,47,5],[46,6,47,6],[46,7,47,7],[46,8,47,8],[46,9,47,9],[46,10,47,10],[46,11,47,12],[46,0,46,2],[48,0,48,1],[58,0,58,2],[59,11,59,12],[60,11,60,12],[61,11,61,12],[57,0,57,2],[57,3,58,5],[57,6,58,6],[57,7,58,7],[57,8,58,8],[57,9,58,9],[57,10,58,10],[57,11,58,12],[59,0,59,1],[68,0,68,2],[68,3,69,5],[68,6,69,6],[68,7,69,7],[68,8,69,8],[68,9,69,9],[68,10,69,10],[68,11,69,12],[62,11,62,12],[63,0,63,2],[63,11,63,12],[64,3,64,5],[64,11,64,12],[65,3,65,5],[65,11,65,12],[64,0,65,1],[73,11,73,12],[74,0,74,2],[74,11,74,12],[75,3,75,5],[75,11,75,12],[76,3,76,5],[76,11,76,12],[75,0,76,1],[69,0,69,2],[70,11,70,12],[71,11,71,12],[72,11,72,12],[70,0,70,1],[80,0,80,2],[81,11,81,12],[82,11,82,12],[83,11,83,12],[79,0,79,2],[79,3,80,5],[79,6,80,6],[79,7,80,7],[79,8,80,8],[79,9,80,9],[79,10,80,10],[79,11,80,12],[81,0,81,1],[90,7,91,7],[90,8,91,8],[90,9,91,9],[90,10,91,10],[90,11,91,12],[84,11,84,12],[85,0,85,2],[85,11,85,12],[86,3,86,5],[86,11,86,12],[87,3,87,5],[87,11,87,12],[86,0,87,1],[102,0,102,2],[103,11,103,12],[104,11,104,12],[105,11,105,12],[101,0,101,2],[101,3,102,5],[101,6,102,6],[101,7,102,7],[101,8,102,8],[101,9,102,9],[101,10,102,10],[101,11,102,12],[112,0,112,2],[112,3,113,5],[112,6,113,6],[112,7,113,7],[112,8,113,8],[112,9,113,9],[112,10,113,10],[112,11,113,12],[106,11,106,12],[107,0,107,2],[107,11,107,12],[108,3,108,5],[108,11,108,12],[109,3,109,5],[109,11,109,12],[108,0,109,1],[122,0,125,2],[122,5,122,6],[122,7,122,8],[122,9,122,10],[123,5,123,6],[123,7,123,8],[123,9,123,10],[125,5,125,9],[125,10,125,12],[117,11,117,12],[118,0,118,2],[118,11,118,12],[119,3,119,5],[119,11,119,12],[120,3,120,5],[120,11,120,12],[113,0,113,2],[114,11,114,12],[115,11,115,12],[116,11,116,12],[119,0,120,1],[101,28,101,30],[90,28,90,30],[91,28,91,30],[92,28,92,30],[93,28,93,30],[0,28,5,30],[12,0,12,2],[12,11,12,12],[11,0,11,2],[95,11,95,12],[96,0,96,2],[96,11,96,12],[97,3,97,5],[97,11,97,12],[98,3,98,5],[98,11,98,12],[97,0,98,1],[91,0,91,2],[92,11,92,12],[93,11,93,12],[94,11,94,12],[90,0,90,2],[90,3,91,5],[90,6,91,6],[114,28,114,30],[113,28,113,30],[115,28,115,30],[122,28,123,30],[116,28,116,30],[117,28,117,30],[118,28,118,30],[102,28,102,30],[103,28,103,30],[104,28,104,30],[105,28,105,30],[106,28,106,30],[107,28,107,30],[112,28,112,30],[94,28,94,30],[95,28,95,30],[96,28,96,30],[79,28,79,30],[80,28,80,30],[81,28,81,30],[82,28,82,30],[83,28,83,30],[84,28,84,30],[85,28,85,30],[69,28,69,30],[70,28,70,30],[71,28,71,30],[72,28,72,30],[73,28,73,30],[74,28,74,30],[57,28,57,30],[58,28,58,30],[59,28,59,30],[60,28,60,30],[61,28,61,30],[62,28,62,30],[63,28,63,30],[39,28,39,30],[40,28,40,30],[41,28,41,30],[49,28,49,30],[50,28,50,30],[46,28,46,30],[47,28,47,30],[48,28,48,30],[68,28,68,30],[12,28,12,30],[15,0,15,1],[29,28,29,30],[30,28,30,30],[20,0,21,1],[31,0,32,1],[36,0,36,2],[37,11,37,12],[38,11,38,12],[35,0,35,2],[35,3,36,5],[35,6,36,6],[35,7,36,7],[35,8,36,8],[35,9,36,9],[35,28,35,30],[36,28,36,30],[37,28,37,30],[38,28,38,30],[31,3,31,5],[31,11,31,12],[32,3,32,5],[32,11,32,12],[25,0,25,2],[127,0,127,12],[9,7,9,10],[6,28,10,30],[7,16,11,16],[7,19,11,19],[7,20,11,20],[7,21,11,21],[7,22,11,22],[7,23,11,23],[7,24,11,24],[7,25,11,25],[7,26,11,26],[7,27,11,27],[1,16,6,24],[7,17,11,17],[7,18,11,18],[37,0,37,1],[35,10,36,10],[35,11,36,12],[29,11,29,12],[30,0,30,2],[30,11,30,12],[24,28,24,30],[25,28,25,30],[92,0,92,1],[103,0,103,1],[114,0,114,1],[13,28,13,30],[14,28,14,30],[15,28,15,30],[16,28,16,30],[17,28,17,30],[18,28,18,30],[19,28,19,30],[26,28,26,30],[27,28,27,30],[28,28,28,30],[40,11,40,12],[41,0,41,2],[41,11,41,12],[42,3,42,5],[42,11,42,12],[43,3,43,5],[43,11,43,12],[42,0,43,1],[39,11,39,12],[51,28,51,30],[52,28,52,30]]}
["School Name(s):",null,null,{"$f":"IF('School Invoice'!D1<>\"\",'School Invoice'!D1,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"To show based on # emp only","Show inc with \"data to clear\" error","Remove hours for employee not to be shown on this billing?  (Based on # of employees entered at the top)",null,null,null,null,null,null,null,null,"Start date overlaps previously billed through date","Start date overlaps line above","End date prior to start date","Information entered on School Invoice tab will autofill here"]
["Fiduciary Name:",null,null,{"$f":"IF('School Invoice'!D2<>\"\",'School Invoice'!D2,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,"y","y","When changing location of any of these, need to update references in macros:\nColumn $P:$P - used many times for the unfilter, make change, refilter\nRow $13:$13 - target for adding rows copy\nFor when the billing # changes:\n   L10 (check box) and K7 (# emp entry) on this tab\n   F9 (check box) and A12 (expense entry) on Non-Personnel tab\n   H6 (billing #) on School Invoice tab\n"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"y","y"]
["Prime Contract #:",null,null,"2012-0730",null,null,"Billing #:",null,null,null,{"$f":"IF('School Invoice'!H5<>\"\",'School Invoice'!H5,\"\")","v":""},null,null,null,"y","y"]
["Job #:",null,null,{"$f":"IF('School Invoice'!D6<>\"\",'School Invoice'!D6,\"\")","v":116005},null,null,"Billing Period:",null,null,null,{"$f":"IF('School Invoice'!H6<>\"\",'School Invoice'!H6,\"\")","v":""},"-",{"$f":"IF('School Invoice'!J6<>\"\",'School Invoice'!J6,\"\")","v":""},null,"y","y"]
["Authorization #:",null,null,{"$f":"IF('School Invoice'!D7<>\"\",'School Invoice'!D7,\"\")","v":6},null,null,null,null,null,null,null,null,null,null,"y","y"]
[null,null,null,null,null,null,null,"# of employees this billing:",null,null,null,null,null,null,"y","y",null,null,null,null,null,null,null,null,null,null,null,null,"Enter # you need (up to 10)* - then click UPDATE button\n   Sections for requested # of employees will show below\n   Can change # and filter again at any time\n   *Contact MFF if you need sections for more than 10 employees"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Employee","y","y","Form Complete?","# decimals hours","max # decimals hours","# decimals hourly $","# decimals fringe %","Row\nAbove","Column with Prior End Date","Cell with Prior End Date","Prior\nEnd Date","Start Date Overlaps Previously Billed","Start Date Overlaps Line Above","End Date Prior to Start Date"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"y","y"]
[null,null,null,null,null,null,null,{"$f":"\"Mark when personnel complete for Billing \"&K4","v":"Mark when personnel complete for Billing "},null,null,null,null,null,null,"y","y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"y","y"]
["Row 13 is for macro copy",null,null,null,null,null,null,null,null,null,null,null,null,null,"n","n"]
[null,null,null,null,"-",null,null,{"$f":"IF(INDIRECT(ADDRESS($V13,8))<>\"\",INDIRECT(ADDRESS($V13,8)),\"\")","v":""},{"$f":"IF(H13<>\"\",ROUND(G13*H13,2),0)","v":0},{"$f":"IF(INDIRECT(ADDRESS($V13,10))<>\"\",INDIRECT(ADDRESS($V13,10)),\"\")","v":""},{"$f":"IF(J13<>\"\",ROUND(I13*J13,2),0)","v":0},{"$f":"I13+K13","v":0},null,{"$f":"INDIRECT(ADDRESS($V13,14))","v":0},{"$f":"IF($V13>10,INDIRECT(ADDRESS($V13,15)),\"n\")","v":"n"},{"$f":"IF(O13=\"y\",\"y\",INDIRECT(ADDRESS($V13,16)))","v":"n"},{"$f":"INDIRECT(ADDRESS($V13,17))","v":0},{"$f":"IFERROR(LEN(RIGHT(G13,LEN(G13)-FIND(\".\",G13))),0)","v":0},{"$f":"INDIRECT(ADDRESS($V13,19))","v":0},{"$f":"IFERROR(LEN(RIGHT(H13,LEN(H13)-FIND(\".\",H13))),0)","v":0},{"$f":"IFERROR(LEN(RIGHT(J13,LEN(J13)-FIND(\".\",J13))),0)","v":0},{"$f":"ROW(F13)-1","v":12},{"$f":"COLUMN(F13)","v":6},{"$f":"ADDRESS(V13,W13,4)","v":"F12"},{"$f":"INDIRECT(X13)","v":0},null,{"$f":"IF(D13=\"\",\"n\",IF(F12=\"\",\"n\",IF(D13<=F12,\"y\",\"n\")))","v":"n"},{"$f":"IF(F13=\"\",\"n\",IF(D13=\"\",\"n\",IF(F13<D13,\"y\",\"n\")))","v":"n"},{"$f":"IF(AA13=\"y\",IF(AB13=\"y\",$AA$1&\" AND \"&$AB$1,$AA$1),IF(AB13=\"y\",$AB$1,\"\"))","v":""}]
["Employee Name",null,null,"WORK\nPERIOD",null,null,"HOURS","HOURLY RATE ($)\ncan overwrite formulas if needed","SALARY SUBTOTAL (Hours x Hourly Rate)","FRINGE\nRATE (%)\ncan overwrite formulas if needed","FRINGE\nSUBTOTAL\n(Salary Subtotal x Fringe Rate)","DIRECT LABOR\n(Salary + Fringe)",null,1,"y","y",{"$f":"IF($L$10<>\"\",\"y\",\"n\")","v":"n"},{"$f":"IFERROR(LEN(RIGHT(G14,LEN(G14)-FIND(\".\",G14))),0)","v":0},{"$f":"MAX(R14:R24)","v":0},0,0,13,6,{"$f":"ADDRESS(V14,W14,4)","v":"F13"},{"$f":"INDIRECT(X14)","v":0},null,null,null,{"$f":"\"Employee #\"&N14","v":"Employee #1"}]
["Title",null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"INDIRECT(ADDRESS($V15,15))","v":"y"},{"$f":"INDIRECT(ADDRESS($V15,16))","v":"y"},{"$f":"INDIRECT(ADDRESS($V15,17))","v":"n"},0,{"$f":"INDIRECT(ADDRESS($V15,19))","v":0},0,0,14,6,{"$f":"ADDRESS(V15,W15,4)","v":"F14"},{"$f":"INDIRECT(X15)","v":0},null,null,null,{"$f":"IF(P15<>O15,$Q$1,\"\")","v":""}]
["Previously billed through:",null,null,null,"-",null,null,null,{"$f":"ROUND(G16*H16,2)","v":0},null,{"$f":"ROUND(I16*J16,2)","v":0},{"$f":"I16+K16","v":0},null,1,"y","y","n",0,{"$f":"INDIRECT(ADDRESS($V16,19))","v":0},0,0,15,6,"F15",0,{"$f":"IF(D16=\"\",\"n\",IF(C16=\"\",\"n\",IF(C16=\"NA\",\"n\",IF(C16=\"N/A\",\"n\",IF(D16<=C16,\"y\",\"n\")))))","v":"n"},null,{"$f":"IF(F16=\"\",\"n\",IF(D16=\"\",\"n\",IF(F16<D16,\"y\",\"n\")))","v":"n"},{"$f":"IF(Z16=\"y\",IF(AB16=\"y\",$Z$1&\" AND \"&$AB$1,$Z$1),IF(AB16=\"y\",$AB$1,\"\"))","v":""}]
[null,null,"Date or NA",null,"-",null,null,{"$f":"IF(H16<>\"\",H16,\"\")","v":""},{"$f":"IF(H17<>\"\",ROUND(G17*H17,2),0)","v":0},{"$f":"IF(J16<>\"\",J16,\"\")","v":""},{"$f":"IF(J17<>\"\",ROUND(I17*J17,2),0)","v":0},0,null,1,"y","y","n",0,0,0,0,16,6,"F16",0,null,{"$f":"IF(D17=\"\",\"n\",IF(F16=\"\",\"n\",IF(D17<=F16,\"y\",\"n\")))","v":"n"},{"$f":"IF(F17=\"\",\"n\",IF(D17=\"\",\"n\",IF(F17<D17,\"y\",\"n\")))","v":"n"},{"$f":"IF(AA17=\"y\",IF(AB17=\"y\",$AA$1&\" AND \"&$AB$1,$AA$1),IF(AB17=\"y\",$AB$1,\"\"))","v":""}]
[null,null,null,null,"-",null,null,{"$f":"IF(H17<>\"\",H17,\"\")","v":""},0,{"$f":"IF(J17<>\"\",J17,\"\")","v":""},0,0,null,1,"y","y","n",0,0,0,0,17,6,"F17",0,null,{"$f":"IF(D18=\"\",\"n\",IF(F17=\"\",\"n\",IF(D18<=F17,\"y\",\"n\")))","v":"n"},{"$f":"IF(F18=\"\",\"n\",IF(D18=\"\",\"n\",IF(F18<D18,\"y\",\"n\")))","v":"n"},{"$f":"IF(AA18=\"y\",IF(AB18=\"y\",$AA$1&\" AND \"&$AB$1,$AA$1),IF(AB18=\"y\",$AB$1,\"\"))","v":""}]
[null,null,null,null,"-",null,null,"",0,"",0,0,null,1,"y","y","n",0,0,0,0,18,6,"F18",0,null,{"$f":"IF(D19=\"\",\"n\",IF(F18=\"\",\"n\",IF(D19<=F18,\"y\",\"n\")))","v":"n"},{"$f":"IF(F19=\"\",\"n\",IF(D19=\"\",\"n\",IF(F19<D19,\"y\",\"n\")))","v":"n"},""]
[null,null,null,null,"-",null,null,"",0,"",0,0,null,1,"y","y","n",0,0,0,0,19,6,"F19",0,null,{"$f":"IF(D20=\"\",\"n\",IF(F19=\"\",\"n\",IF(D20<=F19,\"y\",\"n\")))","v":"n"},{"$f":"IF(F20=\"\",\"n\",IF(D20=\"\",\"n\",IF(F20<D20,\"y\",\"n\")))","v":"n"},""]
["Add/remove rows: see cell in last row with",null,null,"x",null,null,"x","x","x","x","x","x",null,1,"y","y","n",0,0,0,0,20,6,"F20",0]
[null,null,"{","INDIVIDUAL TOTALS",null,null,{"$f":"SUM(G14:G21)","v":0},"x",{"$f":"SUM(I14:I21)","v":0},"x",{"$f":"SUM(K14:K21)","v":0},{"$f":"SUM(L14:L21)","v":0},{"$f":"SUM(M14:M21)","v":0},1,"y","y","n",0,0,0,0,21,6,"F21",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($V23,14))+1","v":2},{"$f":"IF($K$7<N23,\"n\",\"y\")","v":"n"},{"$f":"IF(O23=\"y\",\"y\",IF((G33+I33+K33+L33)<>0,\"y\",\"n\"))","v":"n"},"n",0,0,0,0,22,6,"F22",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($V24,14))","v":2},{"$f":"INDIRECT(ADDRESS($V24,15))","v":"n"},{"$f":"INDIRECT(ADDRESS($V24,16))","v":"n"},"n",0,0,0,0,23,6,"F23",0]
["Employee Name",null,null,"WORK\nPERIOD",null,null,"HOURS","HOURLY RATE ($)\ncan overwrite formulas if needed","SALARY SUBTOTAL (Hours x Hourly Rate)","FRINGE\nRATE (%)\ncan overwrite formulas if needed","FRINGE\nSUBTOTAL\n(Salary Subtotal x Fringe Rate)","DIRECT LABOR\n(Salary + Fringe)",null,2,"n","n","n",0,{"$f":"MAX(R25:R35)","v":0},0,0,24,6,"F24",0,null,null,null,{"$f":"\"Employee #\"&N25","v":"Employee #2"}]
["Title",null,null,null,null,null,null,null,null,null,null,null,null,2,"n","n","n",0,{"$f":"INDIRECT(ADDRESS($V26,19))","v":0},0,0,25,6,"F25",0,null,null,null,{"$f":"IF(P26<>O26,$Q$1,\"\")","v":""}]
["Previously billed through:",null,null,null,"-",null,null,null,{"$f":"ROUND(G27*H27,2)","v":0},null,{"$f":"ROUND(I27*J27,2)","v":0},{"$f":"I27+K27","v":0},null,2,"n","n","n",0,{"$f":"INDIRECT(ADDRESS($V27,19))","v":0},0,0,26,6,"F26",0,{"$f":"IF(D27=\"\",\"n\",IF(C27=\"\",\"n\",IF(C27=\"NA\",\"n\",IF(C27=\"N/A\",\"n\",IF(D27<=C27,\"y\",\"n\")))))","v":"n"},null,{"$f":"IF(F27=\"\",\"n\",IF(D27=\"\",\"n\",IF(F27<D27,\"y\",\"n\")))","v":"n"},{"$f":"IF(Z27=\"y\",IF(AB27=\"y\",$Z$1&\" AND \"&$AB$1,$Z$1),IF(AB27=\"y\",$AB$1,\"\"))","v":""}]
[null,null,"Date or NA",null,"-",null,null,{"$f":"IF(H27<>\"\",H27,\"\")","v":""},{"$f":"IF(H28<>\"\",ROUND(G28*H28,2),0)","v":0},{"$f":"IF(J27<>\"\",J27,\"\")","v":""},{"$f":"IF(J28<>\"\",ROUND(I28*J28,2),0)","v":0},{"$f":"I28+K28","v":0},null,2,"n","n","n",0,0,0,0,27,6,"F27",0,null,{"$f":"IF(D28=\"\",\"n\",IF(F27=\"\",\"n\",IF(D28<=F27,\"y\",\"n\")))","v":"n"},{"$f":"IF(F28=\"\",\"n\",IF(D28=\"\",\"n\",IF(F28<D28,\"y\",\"n\")))","v":"n"},{"$f":"IF(AA28=\"y\",IF(AB28=\"y\",$AA$1&\" AND \"&$AB$1,$AA$1),IF(AB28=\"y\",$AB$1,\"\"))","v":""}]
[null,null,null,null,"-",null,null,{"$f":"IF(H28<>\"\",H28,\"\")","v":""},0,{"$f":"IF(J28<>\"\",J28,\"\")","v":""},0,{"$f":"I29+K29","v":0},null,2,"n","n","n",0,0,0,0,28,6,"F28",0,null,{"$f":"IF(D29=\"\",\"n\",IF(F28=\"\",\"n\",IF(D29<=F28,\"y\",\"n\")))","v":"n"},{"$f":"IF(F29=\"\",\"n\",IF(D29=\"\",\"n\",IF(F29<D29,\"y\",\"n\")))","v":"n"},{"$f":"IF(AA29=\"y\",IF(AB29=\"y\",$AA$1&\" AND \"&$AB$1,$AA$1),IF(AB29=\"y\",$AB$1,\"\"))","v":""}]
[null,null,null,null,"-",null,null,"",0,"",0,{"$f":"I30+K30","v":0},null,2,"n","n","n",0,0,0,0,29,6,"F29",0,null,{"$f":"IF(D30=\"\",\"n\",IF(F29=\"\",\"n\",IF(D30<=F29,\"y\",\"n\")))","v":"n"},{"$f":"IF(F30=\"\",\"n\",IF(D30=\"\",\"n\",IF(F30<D30,\"y\",\"n\")))","v":"n"},""]
[null,null,null,null,"-",null,null,"",0,"",0,{"$f":"I31+K31","v":0},null,2,"n","n","n",0,0,0,0,30,6,"F30",0,null,{"$f":"IF(D31=\"\",\"n\",IF(F30=\"\",\"n\",IF(D31<=F30,\"y\",\"n\")))","v":"n"},{"$f":"IF(F31=\"\",\"n\",IF(D31=\"\",\"n\",IF(F31<D31,\"y\",\"n\")))","v":"n"},""]
["Add/remove rows: see cell in last row with",null,null,"x",null,null,"x","x","x","x","x","x",null,2,"n","n","n",0,0,0,0,31,6,"F31",0]
[null,null,"{","INDIVIDUAL TOTALS",null,null,{"$f":"SUM(G25:G32)","v":0},"x",{"$f":"SUM(I25:I32)","v":0},"x",{"$f":"SUM(K25:K32)","v":0},{"$f":"SUM(L25:L32)","v":0},{"$f":"SUM(M25:M32)","v":0},2,"n","n","n",0,0,0,0,32,6,"F32",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($V34,14))+1","v":3},{"$f":"IF($K$7<N34,\"n\",\"y\")","v":"n"},{"$f":"IF(O34=\"y\",\"y\",IF((G44+I44+K44+L44)<>0,\"y\",\"n\"))","v":"n"},"n",0,0,0,0,33,6,"F33",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($V35,14))","v":3},{"$f":"INDIRECT(ADDRESS($V35,15))","v":"n"},{"$f":"INDIRECT(ADDRESS($V35,16))","v":"n"},"n",0,0,0,0,34,6,"F34",0]
["Employee Name",null,null,"WORK\nPERIOD",null,null,"HOURS","HOURLY RATE ($)\ncan overwrite formulas if needed","SALARY SUBTOTAL (Hours x Hourly Rate)","FRINGE\nRATE (%)\ncan overwrite formulas if needed","FRINGE\nSUBTOTAL\n(Salary Subtotal x Fringe Rate)","DIRECT LABOR\n(Salary + Fringe)",null,3,"n","n","n",0,{"$f":"MAX(R36:R46)","v":0},0,0,35,6,"F35",0,null,null,null,{"$f":"\"Employee #\"&N36","v":"Employee #3"}]
["Title",null,null,null,null,null,null,null,null,null,null,null,null,3,"n","n","n",0,{"$f":"INDIRECT(ADDRESS($V37,19))","v":0},0,0,36,6,"F36",0,null,null,null,{"$f":"IF(P37<>O37,$Q$1,\"\")","v":""}]
["Previously billed through:",null,null,null,"-",null,null,null,{"$f":"ROUND(G38*H38,2)","v":0},null,{"$f":"ROUND(I38*J38,2)","v":0},{"$f":"I38+K38","v":0},null,3,"n","n","n",0,{"$f":"INDIRECT(ADDRESS($V38,19))","v":0},0,0,37,6,"F37",0,{"$f":"IF(D38=\"\",\"n\",IF(C38=\"\",\"n\",IF(C38=\"NA\",\"n\",IF(C38=\"N/A\",\"n\",IF(D38<=C38,\"y\",\"n\")))))","v":"n"},null,{"$f":"IF(F38=\"\",\"n\",IF(D38=\"\",\"n\",IF(F38<D38,\"y\",\"n\")))","v":"n"},{"$f":"IF(Z38=\"y\",IF(AB38=\"y\",$Z$1&\" AND \"&$AB$1,$Z$1),IF(AB38=\"y\",$AB$1,\"\"))","v":""}]
[null,null,"Date or NA",null,"-",null,null,{"$f":"IF(H38<>\"\",H38,\"\")","v":""},{"$f":"IF(H39<>\"\",ROUND(G39*H39,2),0)","v":0},{"$f":"IF(J38<>\"\",J38,\"\")","v":""},{"$f":"IF(J39<>\"\",ROUND(I39*J39,2),0)","v":0},{"$f":"I39+K39","v":0},null,3,"n","n","n",0,0,0,0,38,6,"F38",0,null,{"$f":"IF(D39=\"\",\"n\",IF(F38=\"\",\"n\",IF(D39<=F38,\"y\",\"n\")))","v":"n"},{"$f":"IF(F39=\"\",\"n\",IF(D39=\"\",\"n\",IF(F39<D39,\"y\",\"n\")))","v":"n"},{"$f":"IF(AA39=\"y\",IF(AB39=\"y\",$AA$1&\" AND \"&$AB$1,$AA$1),IF(AB39=\"y\",$AB$1,\"\"))","v":""}]
[null,null,null,null,"-",null,null,{"$f":"IF(H39<>\"\",H39,\"\")","v":""},0,{"$f":"IF(J39<>\"\",J39,\"\")","v":""},0,{"$f":"I40+K40","v":0},null,3,"n","n","n",0,0,0,0,39,6,"F39",0,null,{"$f":"IF(D40=\"\",\"n\",IF(F39=\"\",\"n\",IF(D40<=F39,\"y\",\"n\")))","v":"n"},{"$f":"IF(F40=\"\",\"n\",IF(D40=\"\",\"n\",IF(F40<D40,\"y\",\"n\")))","v":"n"},{"$f":"IF(AA40=\"y\",IF(AB40=\"y\",$AA$1&\" AND \"&$AB$1,$AA$1),IF(AB40=\"y\",$AB$1,\"\"))","v":""}]
[null,null,null,null,"-",null,null,"",0,"",0,{"$f":"I41+K41","v":0},null,3,"n","n","n",0,0,0,0,40,6,"F40",0,null,{"$f":"IF(D41=\"\",\"n\",IF(F40=\"\",\"n\",IF(D41<=F40,\"y\",\"n\")))","v":"n"},{"$f":"IF(F41=\"\",\"n\",IF(D41=\"\",\"n\",IF(F41<D41,\"y\",\"n\")))","v":"n"},""]
[null,null,null,null,"-",null,null,"",0,"",0,{"$f":"I42+K42","v":0},null,3,"n","n","n",0,0,0,0,41,6,"F41",0,null,{"$f":"IF(D42=\"\",\"n\",IF(F41=\"\",\"n\",IF(D42<=F41,\"y\",\"n\")))","v":"n"},{"$f":"IF(F42=\"\",\"n\",IF(D42=\"\",\"n\",IF(F42<D42,\"y\",\"n\")))","v":"n"},""]
["Add/remove rows: see cell in last row with",null,null,"x",null,null,"x","x","x","x","x","x",null,3,"n","n","n",0,0,0,0,42,6,"F42",0]
[null,null,"{","INDIVIDUAL TOTALS",null,null,{"$f":"SUM(G36:G43)","v":0},"x",{"$f":"SUM(I36:I43)","v":0},"x",{"$f":"SUM(K36:K43)","v":0},{"$f":"SUM(L36:L43)","v":0},{"$f":"SUM(M36:M43)","v":0},3,"n","n","n",0,0,0,0,43,6,"F43",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($V45,14))+1","v":4},{"$f":"IF($K$7<N45,\"n\",\"y\")","v":"n"},{"$f":"IF(O45=\"y\",\"y\",IF((G55+I55+K55+L55)<>0,\"y\",\"n\"))","v":"n"},"n",0,0,{"$f":"IFERROR(LEN(RIGHT(H45,LEN(H45)-FIND(\".\",H45))),0)","v":0},{"$f":"IFERROR(LEN(RIGHT(J45,LEN(J45)-FIND(\".\",J45))),0)","v":0},{"$f":"ROW(F45)-1","v":44},{"$f":"COLUMN(F45)","v":6},"F44",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($V46,14))","v":4},{"$f":"INDIRECT(ADDRESS($V46,15))","v":"n"},{"$f":"INDIRECT(ADDRESS($V46,16))","v":"n"},"n",0,0,0,0,45,6,"F45",0]
["Employee Name",null,null,"WORK\nPERIOD",null,null,"HOURS","HOURLY RATE ($)\ncan overwrite formulas if needed","SALARY SUBTOTAL (Hours x Hourly Rate)","FRINGE\nRATE (%)\ncan overwrite formulas if needed","FRINGE\nSUBTOTAL\n(Salary Subtotal x Fringe Rate)","DIRECT LABOR\n(Salary + Fringe)",null,4,"n","n",{"$f":"INDIRECT(ADDRESS($V47,17))","v":"n"},0,{"$f":"MAX(R47:R57)","v":0},0,0,46,6,"F46",0,null,null,null,{"$f":"\"Employee #\"&N47","v":"Employee #4"}]
["Title",null,null,null,null,null,null,null,null,null,null,null,null,4,"n","n","n",0,{"$f":"INDIRECT(ADDRESS($V48,19))","v":0},0,0,47,6,"F47",0,null,null,null,{"$f":"IF(P48<>O48,$Q$1,\"\")","v":""}]
["Previously billed through:",null,null,null,"-",null,null,null,{"$f":"ROUND(G49*H49,2)","v":0},null,{"$f":"ROUND(I49*J49,2)","v":0},{"$f":"I49+K49","v":0},null,4,"n","n","n",0,{"$f":"INDIRECT(ADDRESS($V49,19))","v":0},0,0,48,6,"F48",0,{"$f":"IF(D49=\"\",\"n\",IF(C49=\"\",\"n\",IF(C49=\"NA\",\"n\",IF(C49=\"N/A\",\"n\",IF(D49<=C49,\"y\",\"n\")))))","v":"n"},null,{"$f":"IF(F49=\"\",\"n\",IF(D49=\"\",\"n\",IF(F49<D49,\"y\",\"n\")))","v":"n"},{"$f":"IF(Z49=\"y\",IF(AB49=\"y\",$Z$1&\" AND \"&$AB$1,$Z$1),IF(AB49=\"y\",$AB$1,\"\"))","v":""}]
[null,null,"Date or NA",null,"-",null,null,{"$f":"IF(H49<>\"\",H49,\"\")","v":""},{"$f":"IF(H50<>\"\",ROUND(G50*H50,2),0)","v":0},{"$f":"IF(J49<>\"\",J49,\"\")","v":""},{"$f":"IF(J50<>\"\",ROUND(I50*J50,2),0)","v":0},{"$f":"I50+K50","v":0},null,4,"n","n","n",0,0,0,0,49,6,"F49",0,null,{"$f":"IF(D50=\"\",\"n\",IF(F49=\"\",\"n\",IF(D50<=F49,\"y\",\"n\")))","v":"n"},{"$f":"IF(F50=\"\",\"n\",IF(D50=\"\",\"n\",IF(F50<D50,\"y\",\"n\")))","v":"n"},{"$f":"IF(AA50=\"y\",IF(AB50=\"y\",$AA$1&\" AND \"&$AB$1,$AA$1),IF(AB50=\"y\",$AB$1,\"\"))","v":""}]
[null,null,null,null,"-",null,null,{"$f":"IF(H50<>\"\",H50,\"\")","v":""},0,{"$f":"IF(J50<>\"\",J50,\"\")","v":""},0,{"$f":"I51+K51","v":0},null,4,"n","n","n",0,0,0,0,50,6,"F50",0,null,{"$f":"IF(D51=\"\",\"n\",IF(F50=\"\",\"n\",IF(D51<=F50,\"y\",\"n\")))","v":"n"},{"$f":"IF(F51=\"\",\"n\",IF(D51=\"\",\"n\",IF(F51<D51,\"y\",\"n\")))","v":"n"},{"$f":"IF(AA51=\"y\",IF(AB51=\"y\",$AA$1&\" AND \"&$AB$1,$AA$1),IF(AB51=\"y\",$AB$1,\"\"))","v":""}]
[null,null,null,null,"-",null,null,"",0,"",0,{"$f":"I52+K52","v":0},null,4,"n","n","n",0,0,0,0,51,6,"F51",0,null,{"$f":"IF(D52=\"\",\"n\",IF(F51=\"\",\"n\",IF(D52<=F51,\"y\",\"n\")))","v":"n"},{"$f":"IF(F52=\"\",\"n\",IF(D52=\"\",\"n\",IF(F52<D52,\"y\",\"n\")))","v":"n"},""]
[null,null,null,null,"-",null,null,"",0,"",0,{"$f":"I53+K53","v":0},null,4,"n","n","n",0,0,0,0,52,6,"F52",0,null,{"$f":"IF(D53=\"\",\"n\",IF(F52=\"\",\"n\",IF(D53<=F52,\"y\",\"n\")))","v":"n"},{"$f":"IF(F53=\"\",\"n\",IF(D53=\"\",\"n\",IF(F53<D53,\"y\",\"n\")))","v":"n"},""]
["Add/remove rows: see cell in last row with",null,null,"x",null,null,"x","x","x","x","x","x",null,4,"n","n","n",0,0,0,0,53,6,"F53",0]
[null,null,"{","INDIVIDUAL TOTALS",null,null,{"$f":"SUM(G47:G54)","v":0},"x",{"$f":"SUM(I47:I54)","v":0},"x",{"$f":"SUM(K47:K54)","v":0},{"$f":"SUM(L47:L54)","v":0},{"$f":"SUM(M47:M54)","v":0},4,"n","n","n",0,0,0,0,54,6,"F54",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($V56,14))+1","v":5},{"$f":"IF($K$7<N56,\"n\",\"y\")","v":"n"},{"$f":"IF(O56=\"y\",\"y\",IF((G66+I66+K66+L66)<>0,\"y\",\"n\"))","v":"n"},"n",0,0,0,0,55,6,"F55",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($V57,14))","v":5},{"$f":"INDIRECT(ADDRESS($V57,15))","v":"n"},{"$f":"INDIRECT(ADDRESS($V57,16))","v":"n"},"n",0,0,0,0,56,6,"F56",0]
["Employee Name",null,null,"WORK\nPERIOD",null,null,"HOURS","HOURLY RATE ($)\ncan overwrite formulas if needed","SALARY SUBTOTAL (Hours x Hourly Rate)","FRINGE\nRATE (%)\ncan overwrite formulas if needed","FRINGE\nSUBTOTAL\n(Salary Subtotal x Fringe Rate)","DIRECT LABOR\n(Salary + Fringe)",null,5,"n","n","n",0,{"$f":"MAX(R58:R68)","v":0},0,0,57,6,"F57",0,null,null,null,{"$f":"\"Employee #\"&N58","v":"Employee #5"}]
["Title",null,null,null,null,null,null,null,null,null,null,null,null,5,"n","n","n",0,{"$f":"INDIRECT(ADDRESS($V59,19))","v":0},0,0,58,6,"F58",0,null,null,null,{"$f":"IF(P59<>O59,$Q$1,\"\")","v":""}]
["Previously billed through:",null,null,null,"-",null,null,null,{"$f":"ROUND(G60*H60,2)","v":0},null,{"$f":"ROUND(I60*J60,2)","v":0},{"$f":"I60+K60","v":0},null,5,"n","n","n",0,{"$f":"INDIRECT(ADDRESS($V60,19))","v":0},0,0,59,6,"F59",0,{"$f":"IF(D60=\"\",\"n\",IF(C60=\"\",\"n\",IF(C60=\"NA\",\"n\",IF(C60=\"N/A\",\"n\",IF(D60<=C60,\"y\",\"n\")))))","v":"n"},null,{"$f":"IF(F60=\"\",\"n\",IF(D60=\"\",\"n\",IF(F60<D60,\"y\",\"n\")))","v":"n"},{"$f":"IF(Z60=\"y\",IF(AB60=\"y\",$Z$1&\" AND \"&$AB$1,$Z$1),IF(AB60=\"y\",$AB$1,\"\"))","v":""}]
[null,null,"Date or NA",null,"-",null,null,{"$f":"IF(H60<>\"\",H60,\"\")","v":""},{"$f":"IF(H61<>\"\",ROUND(G61*H61,2),0)","v":0},{"$f":"IF(J60<>\"\",J60,\"\")","v":""},{"$f":"IF(J61<>\"\",ROUND(I61*J61,2),0)","v":0},{"$f":"I61+K61","v":0},null,5,"n","n","n",0,0,0,0,60,6,"F60",0,null,{"$f":"IF(D61=\"\",\"n\",IF(F60=\"\",\"n\",IF(D61<=F60,\"y\",\"n\")))","v":"n"},{"$f":"IF(F61=\"\",\"n\",IF(D61=\"\",\"n\",IF(F61<D61,\"y\",\"n\")))","v":"n"},{"$f":"IF(AA61=\"y\",IF(AB61=\"y\",$AA$1&\" AND \"&$AB$1,$AA$1),IF(AB61=\"y\",$AB$1,\"\"))","v":""}]
[null,null,null,null,"-",null,null,{"$f":"IF(H61<>\"\",H61,\"\")","v":""},0,{"$f":"IF(J61<>\"\",J61,\"\")","v":""},0,{"$f":"I62+K62","v":0},null,5,"n","n","n",0,0,0,0,61,6,"F61",0,null,{"$f":"IF(D62=\"\",\"n\",IF(F61=\"\",\"n\",IF(D62<=F61,\"y\",\"n\")))","v":"n"},{"$f":"IF(F62=\"\",\"n\",IF(D62=\"\",\"n\",IF(F62<D62,\"y\",\"n\")))","v":"n"},{"$f":"IF(AA62=\"y\",IF(AB62=\"y\",$AA$1&\" AND \"&$AB$1,$AA$1),IF(AB62=\"y\",$AB$1,\"\"))","v":""}]
[null,null,null,null,"-",null,null,"",0,"",0,{"$f":"I63+K63","v":0},null,5,"n","n","n",0,0,0,0,62,6,"F62",0,null,{"$f":"IF(D63=\"\",\"n\",IF(F62=\"\",\"n\",IF(D63<=F62,\"y\",\"n\")))","v":"n"},{"$f":"IF(F63=\"\",\"n\",IF(D63=\"\",\"n\",IF(F63<D63,\"y\",\"n\")))","v":"n"},""]
[null,null,null,null,"-",null,null,"",0,"",0,{"$f":"I64+K64","v":0},null,5,"n","n","n",0,0,0,0,63,6,"F63",0,null,{"$f":"IF(D64=\"\",\"n\",IF(F63=\"\",\"n\",IF(D64<=F63,\"y\",\"n\")))","v":"n"},{"$f":"IF(F64=\"\",\"n\",IF(D64=\"\",\"n\",IF(F64<D64,\"y\",\"n\")))","v":"n"},""]
["Add/remove rows: see cell in last row with",null,null,"x",null,null,"x","x","x","x","x","x",null,5,"n","n","n",0,0,0,0,64,6,"F64",0]
[null,null,"{","INDIVIDUAL TOTALS",null,null,{"$f":"SUM(G58:G65)","v":0},"x",{"$f":"SUM(I58:I65)","v":0},"x",{"$f":"SUM(K58:K65)","v":0},{"$f":"SUM(L58:L65)","v":0},{"$f":"SUM(M58:M65)","v":0},5,"n","n","n",0,0,0,0,65,6,"F65",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($V67,14))+1","v":6},{"$f":"IF($K$7<N67,\"n\",\"y\")","v":"n"},{"$f":"IF(O67=\"y\",\"y\",IF((G77+I77+K77+L77)<>0,\"y\",\"n\"))","v":"n"},"n",0,0,0,0,66,6,"F66",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($V68,14))","v":6},{"$f":"INDIRECT(ADDRESS($V68,15))","v":"n"},{"$f":"INDIRECT(ADDRESS($V68,16))","v":"n"},"n",0,0,0,0,67,6,"F67",0]
["Employee Name",null,null,"WORK\nPERIOD",null,null,"HOURS","HOURLY RATE ($)\ncan overwrite formulas if needed","SALARY SUBTOTAL (Hours x Hourly Rate)","FRINGE\nRATE (%)\ncan overwrite formulas if needed","FRINGE\nSUBTOTAL\n(Salary Subtotal x Fringe Rate)","DIRECT LABOR\n(Salary + Fringe)",null,6,"n","n","n",0,{"$f":"MAX(R69:R79)","v":0},0,0,68,6,"F68",0,null,null,null,{"$f":"\"Employee #\"&N69","v":"Employee #6"}]
["Title",null,null,null,null,null,null,null,null,null,null,null,null,6,"n","n","n",0,{"$f":"INDIRECT(ADDRESS($V70,19))","v":0},0,0,69,6,"F69",0,null,null,null,{"$f":"IF(P70<>O70,$Q$1,\"\")","v":""}]
["Previously billed through:",null,null,null,"-",null,null,null,{"$f":"ROUND(G71*H71,2)","v":0},null,{"$f":"ROUND(I71*J71,2)","v":0},{"$f":"I71+K71","v":0},null,6,"n","n","n",0,{"$f":"INDIRECT(ADDRESS($V71,19))","v":0},0,0,70,6,"F70",0,{"$f":"IF(D71=\"\",\"n\",IF(C71=\"\",\"n\",IF(C71=\"NA\",\"n\",IF(C71=\"N/A\",\"n\",IF(D71<=C71,\"y\",\"n\")))))","v":"n"},null,{"$f":"IF(F71=\"\",\"n\",IF(D71=\"\",\"n\",IF(F71<D71,\"y\",\"n\")))","v":"n"},{"$f":"IF(Z71=\"y\",IF(AB71=\"y\",$Z$1&\" AND \"&$AB$1,$Z$1),IF(AB71=\"y\",$AB$1,\"\"))","v":""}]
[null,null,"Date or NA",null,"-",null,null,{"$f":"IF(H71<>\"\",H71,\"\")","v":""},{"$f":"IF(H72<>\"\",ROUND(G72*H72,2),0)","v":0},{"$f":"IF(J71<>\"\",J71,\"\")","v":""},{"$f":"IF(J72<>\"\",ROUND(I72*J72,2),0)","v":0},{"$f":"I72+K72","v":0},null,6,"n","n","n",0,0,0,0,71,6,"F71",0,null,{"$f":"IF(D72=\"\",\"n\",IF(F71=\"\",\"n\",IF(D72<=F71,\"y\",\"n\")))","v":"n"},{"$f":"IF(F72=\"\",\"n\",IF(D72=\"\",\"n\",IF(F72<D72,\"y\",\"n\")))","v":"n"},{"$f":"IF(AA72=\"y\",IF(AB72=\"y\",$AA$1&\" AND \"&$AB$1,$AA$1),IF(AB72=\"y\",$AB$1,\"\"))","v":""}]
[null,null,null,null,"-",null,null,{"$f":"IF(H72<>\"\",H72,\"\")","v":""},0,{"$f":"IF(J72<>\"\",J72,\"\")","v":""},0,{"$f":"I73+K73","v":0},null,6,"n","n","n",0,0,0,0,72,6,"F72",0,null,{"$f":"IF(D73=\"\",\"n\",IF(F72=\"\",\"n\",IF(D73<=F72,\"y\",\"n\")))","v":"n"},{"$f":"IF(F73=\"\",\"n\",IF(D73=\"\",\"n\",IF(F73<D73,\"y\",\"n\")))","v":"n"},{"$f":"IF(AA73=\"y\",IF(AB73=\"y\",$AA$1&\" AND \"&$AB$1,$AA$1),IF(AB73=\"y\",$AB$1,\"\"))","v":""}]
[null,null,null,null,"-",null,null,"",0,"",0,{"$f":"I74+K74","v":0},null,6,"n","n","n",0,0,0,0,73,6,"F73",0,null,{"$f":"IF(D74=\"\",\"n\",IF(F73=\"\",\"n\",IF(D74<=F73,\"y\",\"n\")))","v":"n"},{"$f":"IF(F74=\"\",\"n\",IF(D74=\"\",\"n\",IF(F74<D74,\"y\",\"n\")))","v":"n"},""]
[null,null,null,null,"-",null,null,"",0,"",0,{"$f":"I75+K75","v":0},null,6,"n","n","n",0,0,0,0,74,6,"F74",0,null,{"$f":"IF(D75=\"\",\"n\",IF(F74=\"\",\"n\",IF(D75<=F74,\"y\",\"n\")))","v":"n"},{"$f":"IF(F75=\"\",\"n\",IF(D75=\"\",\"n\",IF(F75<D75,\"y\",\"n\")))","v":"n"},""]
["Add/remove rows: see cell in last row with",null,null,"x",null,null,"x","x","x","x","x","x",null,6,"n","n","n",0,0,0,0,75,6,"F75",0]
[null,null,"{","INDIVIDUAL TOTALS",null,null,{"$f":"SUM(G69:G76)","v":0},"x",{"$f":"SUM(I69:I76)","v":0},"x",{"$f":"SUM(K69:K76)","v":0},{"$f":"SUM(L69:L76)","v":0},{"$f":"SUM(M69:M76)","v":0},6,"n","n","n",0,0,{"$f":"IFERROR(LEN(RIGHT(H77,LEN(H77)-FIND(\".\",H77))),0)","v":0},{"$f":"IFERROR(LEN(RIGHT(J77,LEN(J77)-FIND(\".\",J77))),0)","v":0},{"$f":"ROW(F77)-1","v":76},{"$f":"COLUMN(F77)","v":6},"F76",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($V78,14))+1","v":7},{"$f":"IF($K$7<N78,\"n\",\"y\")","v":"n"},{"$f":"IF(O78=\"y\",\"y\",IF((G88+I88+K88+L88)<>0,\"y\",\"n\"))","v":"n"},"n",{"$f":"IFERROR(LEN(RIGHT(G78,LEN(G78)-FIND(\".\",G78))),0)","v":0},0,0,0,77,6,"F77",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($V79,14))","v":7},{"$f":"INDIRECT(ADDRESS($V79,15))","v":"n"},{"$f":"INDIRECT(ADDRESS($V79,16))","v":"n"},{"$f":"INDIRECT(ADDRESS($V79,17))","v":"n"},0,0,0,0,78,6,{"$f":"ADDRESS(V79,W79,4)","v":"F78"},{"$f":"INDIRECT(X79)","v":0}]
["Employee Name",null,null,"WORK\nPERIOD",null,null,"HOURS","HOURLY RATE ($)\ncan overwrite formulas if needed","SALARY SUBTOTAL (Hours x Hourly Rate)","FRINGE\nRATE (%)\ncan overwrite formulas if needed","FRINGE\nSUBTOTAL\n(Salary Subtotal x Fringe Rate)","DIRECT LABOR\n(Salary + Fringe)",null,7,"n","n","n",0,{"$f":"MAX(R80:R90)","v":0},0,0,79,6,"F79",0,null,null,null,{"$f":"\"Employee #\"&N80","v":"Employee #7"}]
["Title",null,null,null,null,null,null,null,null,null,null,null,null,7,"n","n","n",0,{"$f":"INDIRECT(ADDRESS($V81,19))","v":0},0,0,80,6,"F80",0,null,null,null,{"$f":"IF(P81<>O81,$Q$1,\"\")","v":""}]
["Previously billed through:",null,null,null,"-",null,null,null,{"$f":"ROUND(G82*H82,2)","v":0},null,{"$f":"ROUND(I82*J82,2)","v":0},{"$f":"I82+K82","v":0},null,7,"n","n","n",0,{"$f":"INDIRECT(ADDRESS($V82,19))","v":0},0,0,81,6,"F81",0,{"$f":"IF(D82=\"\",\"n\",IF(C82=\"\",\"n\",IF(C82=\"NA\",\"n\",IF(C82=\"N/A\",\"n\",IF(D82<=C82,\"y\",\"n\")))))","v":"n"},null,{"$f":"IF(F82=\"\",\"n\",IF(D82=\"\",\"n\",IF(F82<D82,\"y\",\"n\")))","v":"n"},{"$f":"IF(Z82=\"y\",IF(AB82=\"y\",$Z$1&\" AND \"&$AB$1,$Z$1),IF(AB82=\"y\",$AB$1,\"\"))","v":""}]
[null,null,"Date or NA",null,"-",null,null,{"$f":"IF(H82<>\"\",H82,\"\")","v":""},{"$f":"IF(H83<>\"\",ROUND(G83*H83,2),0)","v":0},{"$f":"IF(J82<>\"\",J82,\"\")","v":""},{"$f":"IF(J83<>\"\",ROUND(I83*J83,2),0)","v":0},{"$f":"I83+K83","v":0},null,7,"n","n","n",0,0,0,0,82,6,"F82",0,null,{"$f":"IF(D83=\"\",\"n\",IF(F82=\"\",\"n\",IF(D83<=F82,\"y\",\"n\")))","v":"n"},{"$f":"IF(F83=\"\",\"n\",IF(D83=\"\",\"n\",IF(F83<D83,\"y\",\"n\")))","v":"n"},{"$f":"IF(AA83=\"y\",IF(AB83=\"y\",$AA$1&\" AND \"&$AB$1,$AA$1),IF(AB83=\"y\",$AB$1,\"\"))","v":""}]
[null,null,null,null,"-",null,null,{"$f":"IF(H83<>\"\",H83,\"\")","v":""},0,{"$f":"IF(J83<>\"\",J83,\"\")","v":""},0,{"$f":"I84+K84","v":0},null,7,"n","n","n",0,0,0,0,83,6,"F83",0,null,{"$f":"IF(D84=\"\",\"n\",IF(F83=\"\",\"n\",IF(D84<=F83,\"y\",\"n\")))","v":"n"},{"$f":"IF(F84=\"\",\"n\",IF(D84=\"\",\"n\",IF(F84<D84,\"y\",\"n\")))","v":"n"},{"$f":"IF(AA84=\"y\",IF(AB84=\"y\",$AA$1&\" AND \"&$AB$1,$AA$1),IF(AB84=\"y\",$AB$1,\"\"))","v":""}]
[null,null,null,null,"-",null,null,"",0,"",0,{"$f":"I85+K85","v":0},null,7,"n","n","n",0,0,0,0,84,6,"F84",0,null,{"$f":"IF(D85=\"\",\"n\",IF(F84=\"\",\"n\",IF(D85<=F84,\"y\",\"n\")))","v":"n"},{"$f":"IF(F85=\"\",\"n\",IF(D85=\"\",\"n\",IF(F85<D85,\"y\",\"n\")))","v":"n"},""]
[null,null,null,null,"-",null,null,"",0,"",0,{"$f":"I86+K86","v":0},null,7,"n","n","n",0,0,0,0,85,6,"F85",0,null,{"$f":"IF(D86=\"\",\"n\",IF(F85=\"\",\"n\",IF(D86<=F85,\"y\",\"n\")))","v":"n"},{"$f":"IF(F86=\"\",\"n\",IF(D86=\"\",\"n\",IF(F86<D86,\"y\",\"n\")))","v":"n"},""]
["Add/remove rows: see cell in last row with",null,null,"x",null,null,"x","x","x","x","x","x",null,7,"n","n","n",0,0,0,0,86,6,"F86",0]
[null,null,"{","INDIVIDUAL TOTALS",null,null,{"$f":"SUM(G80:G87)","v":0},"x",{"$f":"SUM(I80:I87)","v":0},"x",{"$f":"SUM(K80:K87)","v":0},{"$f":"SUM(L80:L87)","v":0},{"$f":"SUM(M80:M87)","v":0},7,"n","n","n",0,0,0,0,87,6,"F87",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($V89,14))+1","v":8},{"$f":"IF($K$7<N89,\"n\",\"y\")","v":"n"},{"$f":"IF(O89=\"y\",\"y\",IF((G99+I99+K99+L99)<>0,\"y\",\"n\"))","v":"n"},"n",0,0,0,0,88,6,"F88",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($V90,14))","v":8},{"$f":"INDIRECT(ADDRESS($V90,15))","v":"n"},{"$f":"INDIRECT(ADDRESS($V90,16))","v":"n"},"n",0,0,0,0,89,6,"F89",0]
["Employee Name",null,null,"WORK\nPERIOD",null,null,"HOURS","HOURLY RATE ($)\ncan overwrite formulas if needed","SALARY SUBTOTAL (Hours x Hourly Rate)","FRINGE\nRATE (%)\ncan overwrite formulas if needed","FRINGE\nSUBTOTAL\n(Salary Subtotal x Fringe Rate)","DIRECT LABOR\n(Salary + Fringe)",null,8,"n","n","n",0,{"$f":"MAX(R91:R101)","v":0},0,0,90,6,"F90",0,null,null,null,{"$f":"\"Employee #\"&N91","v":"Employee #8"}]
["Title",null,null,null,null,null,null,null,null,null,null,null,null,8,"n","n","n",0,{"$f":"INDIRECT(ADDRESS($V92,19))","v":0},0,0,91,6,"F91",0,null,null,null,{"$f":"IF(P92<>O92,$Q$1,\"\")","v":""}]
["Previously billed through:",null,null,null,"-",null,null,null,{"$f":"ROUND(G93*H93,2)","v":0},null,{"$f":"ROUND(I93*J93,2)","v":0},{"$f":"I93+K93","v":0},null,8,"n","n","n",0,{"$f":"INDIRECT(ADDRESS($V93,19))","v":0},0,0,92,6,"F92",0,{"$f":"IF(D93=\"\",\"n\",IF(C93=\"\",\"n\",IF(C93=\"NA\",\"n\",IF(C93=\"N/A\",\"n\",IF(D93<=C93,\"y\",\"n\")))))","v":"n"},null,{"$f":"IF(F93=\"\",\"n\",IF(D93=\"\",\"n\",IF(F93<D93,\"y\",\"n\")))","v":"n"},{"$f":"IF(Z93=\"y\",IF(AB93=\"y\",$Z$1&\" AND \"&$AB$1,$Z$1),IF(AB93=\"y\",$AB$1,\"\"))","v":""}]
[null,null,"Date or NA",null,"-",null,null,{"$f":"IF(H93<>\"\",H93,\"\")","v":""},{"$f":"IF(H94<>\"\",ROUND(G94*H94,2),0)","v":0},{"$f":"IF(J93<>\"\",J93,\"\")","v":""},{"$f":"IF(J94<>\"\",ROUND(I94*J94,2),0)","v":0},{"$f":"I94+K94","v":0},null,8,"n","n","n",0,0,0,0,93,6,"F93",0,null,{"$f":"IF(D94=\"\",\"n\",IF(F93=\"\",\"n\",IF(D94<=F93,\"y\",\"n\")))","v":"n"},{"$f":"IF(F94=\"\",\"n\",IF(D94=\"\",\"n\",IF(F94<D94,\"y\",\"n\")))","v":"n"},{"$f":"IF(AA94=\"y\",IF(AB94=\"y\",$AA$1&\" AND \"&$AB$1,$AA$1),IF(AB94=\"y\",$AB$1,\"\"))","v":""}]
[null,null,null,null,"-",null,null,{"$f":"IF(H94<>\"\",H94,\"\")","v":""},0,{"$f":"IF(J94<>\"\",J94,\"\")","v":""},0,{"$f":"I95+K95","v":0},null,8,"n","n","n",0,0,0,0,94,6,"F94",0,null,{"$f":"IF(D95=\"\",\"n\",IF(F94=\"\",\"n\",IF(D95<=F94,\"y\",\"n\")))","v":"n"},{"$f":"IF(F95=\"\",\"n\",IF(D95=\"\",\"n\",IF(F95<D95,\"y\",\"n\")))","v":"n"},{"$f":"IF(AA95=\"y\",IF(AB95=\"y\",$AA$1&\" AND \"&$AB$1,$AA$1),IF(AB95=\"y\",$AB$1,\"\"))","v":""}]
[null,null,null,null,"-",null,null,"",0,"",0,{"$f":"I96+K96","v":0},null,8,"n","n","n",0,0,0,0,95,6,"F95",0,null,{"$f":"IF(D96=\"\",\"n\",IF(F95=\"\",\"n\",IF(D96<=F95,\"y\",\"n\")))","v":"n"},{"$f":"IF(F96=\"\",\"n\",IF(D96=\"\",\"n\",IF(F96<D96,\"y\",\"n\")))","v":"n"},""]
[null,null,null,null,"-",null,null,"",0,"",0,{"$f":"I97+K97","v":0},null,8,"n","n","n",0,0,0,0,96,6,"F96",0,null,{"$f":"IF(D97=\"\",\"n\",IF(F96=\"\",\"n\",IF(D97<=F96,\"y\",\"n\")))","v":"n"},{"$f":"IF(F97=\"\",\"n\",IF(D97=\"\",\"n\",IF(F97<D97,\"y\",\"n\")))","v":"n"},""]
["Add/remove rows: see cell in last row with",null,null,"x",null,null,"x","x","x","x","x","x",null,8,"n","n","n",0,0,0,0,97,6,"F97",0]
[null,null,"{","INDIVIDUAL TOTALS",null,null,{"$f":"SUM(G91:G98)","v":0},"x",{"$f":"SUM(I91:I98)","v":0},"x",{"$f":"SUM(K91:K98)","v":0},{"$f":"SUM(L91:L98)","v":0},{"$f":"SUM(M91:M98)","v":0},8,"n","n","n",0,0,0,0,98,6,"F98",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($V100,14))+1","v":9},{"$f":"IF($K$7<N100,\"n\",\"y\")","v":"n"},{"$f":"IF(O100=\"y\",\"y\",IF((G110+I110+K110+L110)<>0,\"y\",\"n\"))","v":"n"},"n",0,0,0,0,99,6,"F99",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($V101,14))","v":9},{"$f":"INDIRECT(ADDRESS($V101,15))","v":"n"},{"$f":"INDIRECT(ADDRESS($V101,16))","v":"n"},"n",0,0,0,0,100,6,"F100",0]
["Employee Name",null,null,"WORK\nPERIOD",null,null,"HOURS","HOURLY RATE ($)\ncan overwrite formulas if needed","SALARY SUBTOTAL (Hours x Hourly Rate)","FRINGE\nRATE (%)\ncan overwrite formulas if needed","FRINGE\nSUBTOTAL\n(Salary Subtotal x Fringe Rate)","DIRECT LABOR\n(Salary + Fringe)",null,9,"n","n","n",0,{"$f":"MAX(R102:R112)","v":0},0,0,101,6,"F101",0,null,null,null,{"$f":"\"Employee #\"&N102","v":"Employee #9"}]
["Title",null,null,null,null,null,null,null,null,null,null,null,null,9,"n","n","n",0,{"$f":"INDIRECT(ADDRESS($V103,19))","v":0},0,0,102,6,"F102",0,null,null,null,{"$f":"IF(P103<>O103,$Q$1,\"\")","v":""}]
["Previously billed through:",null,null,null,"-",null,null,null,{"$f":"ROUND(G104*H104,2)","v":0},null,{"$f":"ROUND(I104*J104,2)","v":0},{"$f":"I104+K104","v":0},null,9,"n","n","n",0,{"$f":"INDIRECT(ADDRESS($V104,19))","v":0},0,0,103,6,"F103",0,{"$f":"IF(D104=\"\",\"n\",IF(C104=\"\",\"n\",IF(C104=\"NA\",\"n\",IF(C104=\"N/A\",\"n\",IF(D104<=C104,\"y\",\"n\")))))","v":"n"},null,{"$f":"IF(F104=\"\",\"n\",IF(D104=\"\",\"n\",IF(F104<D104,\"y\",\"n\")))","v":"n"},{"$f":"IF(Z104=\"y\",IF(AB104=\"y\",$Z$1&\" AND \"&$AB$1,$Z$1),IF(AB104=\"y\",$AB$1,\"\"))","v":""}]
[null,null,"Date or NA",null,"-",null,null,{"$f":"IF(H104<>\"\",H104,\"\")","v":""},{"$f":"IF(H105<>\"\",ROUND(G105*H105,2),0)","v":0},{"$f":"IF(J104<>\"\",J104,\"\")","v":""},{"$f":"IF(J105<>\"\",ROUND(I105*J105,2),0)","v":0},{"$f":"I105+K105","v":0},null,9,"n","n","n",0,0,0,0,104,6,"F104",0,null,{"$f":"IF(D105=\"\",\"n\",IF(F104=\"\",\"n\",IF(D105<=F104,\"y\",\"n\")))","v":"n"},{"$f":"IF(F105=\"\",\"n\",IF(D105=\"\",\"n\",IF(F105<D105,\"y\",\"n\")))","v":"n"},{"$f":"IF(AA105=\"y\",IF(AB105=\"y\",$AA$1&\" AND \"&$AB$1,$AA$1),IF(AB105=\"y\",$AB$1,\"\"))","v":""}]
[null,null,null,null,"-",null,null,{"$f":"IF(H105<>\"\",H105,\"\")","v":""},0,{"$f":"IF(J105<>\"\",J105,\"\")","v":""},0,{"$f":"I106+K106","v":0},null,9,"n","n","n",0,0,0,0,105,6,"F105",0,null,{"$f":"IF(D106=\"\",\"n\",IF(F105=\"\",\"n\",IF(D106<=F105,\"y\",\"n\")))","v":"n"},{"$f":"IF(F106=\"\",\"n\",IF(D106=\"\",\"n\",IF(F106<D106,\"y\",\"n\")))","v":"n"},{"$f":"IF(AA106=\"y\",IF(AB106=\"y\",$AA$1&\" AND \"&$AB$1,$AA$1),IF(AB106=\"y\",$AB$1,\"\"))","v":""}]
[null,null,null,null,"-",null,null,"",0,"",0,{"$f":"I107+K107","v":0},null,9,"n","n","n",0,0,0,0,106,6,"F106",0,null,{"$f":"IF(D107=\"\",\"n\",IF(F106=\"\",\"n\",IF(D107<=F106,\"y\",\"n\")))","v":"n"},{"$f":"IF(F107=\"\",\"n\",IF(D107=\"\",\"n\",IF(F107<D107,\"y\",\"n\")))","v":"n"},""]
[null,null,null,null,"-",null,null,"",0,"",0,{"$f":"I108+K108","v":0},null,9,"n","n","n",0,0,0,0,107,6,"F107",0,null,{"$f":"IF(D108=\"\",\"n\",IF(F107=\"\",\"n\",IF(D108<=F107,\"y\",\"n\")))","v":"n"},{"$f":"IF(F108=\"\",\"n\",IF(D108=\"\",\"n\",IF(F108<D108,\"y\",\"n\")))","v":"n"},""]
["Add/remove rows: see cell in last row with",null,null,"x",null,null,"x","x","x","x","x","x",null,9,"n","n","n",0,0,{"$f":"IFERROR(LEN(RIGHT(H109,LEN(H109)-FIND(\".\",H109))),0)","v":0},{"$f":"IFERROR(LEN(RIGHT(J109,LEN(J109)-FIND(\".\",J109))),0)","v":0},{"$f":"ROW(F109)-1","v":108},{"$f":"COLUMN(F109)","v":6},"F108",0]
[null,null,"{","INDIVIDUAL TOTALS",null,null,{"$f":"SUM(G102:G109)","v":0},"x",{"$f":"SUM(I102:I109)","v":0},"x",{"$f":"SUM(K102:K109)","v":0},{"$f":"SUM(L102:L109)","v":0},{"$f":"SUM(M102:M109)","v":0},9,"n","n","n",0,0,0,0,109,6,"F109",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($V111,14))+1","v":10},{"$f":"IF($K$7<N111,\"n\",\"y\")","v":"n"},{"$f":"IF(O111=\"y\",\"y\",IF((G121+I121+K121+L121)<>0,\"y\",\"n\"))","v":"n"},{"$f":"INDIRECT(ADDRESS($V111,17))","v":"n"},0,0,0,0,110,6,"F110",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($V112,14))","v":10},{"$f":"INDIRECT(ADDRESS($V112,15))","v":"n"},{"$f":"INDIRECT(ADDRESS($V112,16))","v":"n"},"n",0,0,0,0,111,6,"F111",0]
["Employee Name",null,null,"WORK\nPERIOD",null,null,"HOURS","HOURLY RATE ($)\ncan overwrite formulas if needed","SALARY SUBTOTAL (Hours x Hourly Rate)","FRINGE\nRATE (%)\ncan overwrite formulas if needed","FRINGE\nSUBTOTAL\n(Salary Subtotal x Fringe Rate)","DIRECT LABOR\n(Salary + Fringe)",null,10,"n","n","n",0,{"$f":"MAX(R113:R123)","v":0},0,0,112,6,"F112",0,null,null,null,{"$f":"\"Employee #\"&N113","v":"Employee #10"}]
["Title",null,null,null,null,null,null,null,null,null,null,null,null,10,"n","n","n",0,{"$f":"INDIRECT(ADDRESS($V114,19))","v":0},0,0,113,6,"F113",0,null,null,null,{"$f":"IF(P114<>O114,$Q$1,\"\")","v":""}]
["Previously billed through:",null,null,null,"-",null,null,null,{"$f":"ROUND(G115*H115,2)","v":0},null,{"$f":"ROUND(I115*J115,2)","v":0},{"$f":"I115+K115","v":0},null,10,"n","n","n",0,{"$f":"INDIRECT(ADDRESS($V115,19))","v":0},0,0,114,6,"F114",0,{"$f":"IF(D115=\"\",\"n\",IF(C115=\"\",\"n\",IF(C115=\"NA\",\"n\",IF(C115=\"N/A\",\"n\",IF(D115<=C115,\"y\",\"n\")))))","v":"n"},null,{"$f":"IF(F115=\"\",\"n\",IF(D115=\"\",\"n\",IF(F115<D115,\"y\",\"n\")))","v":"n"},{"$f":"IF(Z115=\"y\",IF(AB115=\"y\",$Z$1&\" AND \"&$AB$1,$Z$1),IF(AB115=\"y\",$AB$1,\"\"))","v":""}]
[null,null,"Date or NA",null,"-",null,null,{"$f":"IF(H115<>\"\",H115,\"\")","v":""},{"$f":"IF(H116<>\"\",ROUND(G116*H116,2),0)","v":0},{"$f":"IF(J115<>\"\",J115,\"\")","v":""},{"$f":"IF(J116<>\"\",ROUND(I116*J116,2),0)","v":0},{"$f":"I116+K116","v":0},null,10,"n","n","n",0,0,0,0,115,6,"F115",0,null,{"$f":"IF(D116=\"\",\"n\",IF(F115=\"\",\"n\",IF(D116<=F115,\"y\",\"n\")))","v":"n"},{"$f":"IF(F116=\"\",\"n\",IF(D116=\"\",\"n\",IF(F116<D116,\"y\",\"n\")))","v":"n"},{"$f":"IF(AA116=\"y\",IF(AB116=\"y\",$AA$1&\" AND \"&$AB$1,$AA$1),IF(AB116=\"y\",$AB$1,\"\"))","v":""}]
[null,null,null,null,"-",null,null,{"$f":"IF(H116<>\"\",H116,\"\")","v":""},0,{"$f":"IF(J116<>\"\",J116,\"\")","v":""},0,{"$f":"I117+K117","v":0},null,10,"n","n","n",0,0,0,0,116,6,"F116",0,null,{"$f":"IF(D117=\"\",\"n\",IF(F116=\"\",\"n\",IF(D117<=F116,\"y\",\"n\")))","v":"n"},{"$f":"IF(F117=\"\",\"n\",IF(D117=\"\",\"n\",IF(F117<D117,\"y\",\"n\")))","v":"n"},{"$f":"IF(AA117=\"y\",IF(AB117=\"y\",$AA$1&\" AND \"&$AB$1,$AA$1),IF(AB117=\"y\",$AB$1,\"\"))","v":""}]
[null,null,null,null,"-",null,null,"",0,"",0,{"$f":"I118+K118","v":0},null,10,"n","n","n",0,0,0,0,117,6,"F117",0,null,{"$f":"IF(D118=\"\",\"n\",IF(F117=\"\",\"n\",IF(D118<=F117,\"y\",\"n\")))","v":"n"},{"$f":"IF(F118=\"\",\"n\",IF(D118=\"\",\"n\",IF(F118<D118,\"y\",\"n\")))","v":"n"},""]
[null,null,null,null,"-",null,null,"",0,"",0,{"$f":"I119+K119","v":0},null,10,"n","n","n",0,0,0,0,118,6,"F118",0,null,{"$f":"IF(D119=\"\",\"n\",IF(F118=\"\",\"n\",IF(D119<=F118,\"y\",\"n\")))","v":"n"},{"$f":"IF(F119=\"\",\"n\",IF(D119=\"\",\"n\",IF(F119<D119,\"y\",\"n\")))","v":"n"},""]
["Add/remove rows: see cell in last row with",null,null,"x",null,null,"x","x","x","x","x","x",null,10,"n","n","n",0,0,0,0,119,6,"F119",0]
[null,null,"{","INDIVIDUAL TOTALS",null,null,{"$f":"SUM(G113:G120)","v":0},"x",{"$f":"SUM(I113:I120)","v":0},"x",{"$f":"SUM(K113:K120)","v":0},{"$f":"SUM(L113:L120)","v":0},{"$f":"SUM(M113:M120)","v":0},10,"n","n","n",0,0,0,0,120,6,"F120",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"y","y"]
["GRAND TOTALS",null,null,null,null,"TOTAL HOURS",null,"TOTAL SALARIES",null,"TOTAL FRINGES",null,null,null,null,"y","y",null,null,null,null,null,null,null,null,null,null,null,null,"*Contact Michigan Fitness Foundation of you need sections for\n  additional employees"]
[null,null,null,null,null,{"$f":"G22+G33+G44+G55+G66+G77+G88+G99+G110+G121","v":0},null,{"$f":"I22+I33+I44+I55+I66+I77+I88+I99+I110+I121","v":0},null,{"$f":"K22+K33+K44+K55+K66+K77+K88+K99+K110+K121","v":0},null,null,null,null,"y","y"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"y","y"]
[null,null,null,null,null,"TOTAL PERSONNEL:",null,null,null,null,{"$f":"H124+J124","v":0},null,null,null,"y","y"]
[]
["Print Preview before printing recommended in case page breaks need to be adjusted to prevent splitting an employee's data between pages."]

{"sheet":"Non-Personnel Detail","index":2,"n_rows":48,"n_cols":8,"rows_kept":48,"cut":false,"hidden":false,"merged":[[42,0,42,6],[43,0,43,6],[44,0,44,6],[31,1,31,2],[31,3,31,4],[31,5,31,6],[32,1,32,2],[32,3,32,4],[32,5,32,6],[39,1,39,2],[39,3,39,4],[39,5,39,6],[38,1,38,2],[38,3,38,4],[38,5,38,6],[41,0,41,4],[29,1,29,2],[29,3,29,4],[29,5,29,6],[30,1,30,2],[37,1,37,2],[37,3,37,4],[37,5,37,6],[35,1,35,2],[35,3,35,4],[35,5,35,6],[36,1,36,2],[36,3,36,4],[36,5,36,6],[33,1,33,2],[33,3,33,4],[33,5,33,6],[34,1,34,2],[34,3,34,4],[34,5,34,6],[30,3,30,4],[30,5,30,6],[27,3,27,4],[27,5,27,6],[24,1,24,2],[24,3,24,4],[24,5,24,6],[25,1,25,2],[25,3,25,4],[25,5,25,6],[28,1,28,2],[28,3,28,4],[28,5,28,6],[0,1,0,6],[1,1,2,6],[4,5,4,6],[15,1,15,2],[15,3,15,4],[15,5,15,6],[22,1,22,2],[22,3,22,4],[22,5,22,6],[14,5,14,6],[17,5,17,6],[18,1,18,2],[18,5,18,6],[19,1,19,2],[19,5,19,6],[20,1,20,2],[20,5,20,6],[8,2,8,4],[0,7,6,10],[42,7,42,11],[40,3,40,4],[40,5,40,6],[41,5,41,6],[40,1,40,2],[12,1,12,2],[10,3,10,4],[10,5,10,6],[10,7,10,11],[11,3,11,4],[11,5,11,6],[16,1,16,2],[16,3,16,4],[16,5,16,6],[12,3,12,4],[12,5,12,6],[13,1,13,2],[13,3,13,4],[13,5,13,6],[14,1,14,2],[14,3,14,4],[10,1,10,2],[11,1,11,2],[45,0,45,6],[46,0,46,6],[47,0,47,6],[7,0,7,6],[8,0,8,1],[9,0,9,6],[1,0,2,0],[20,3,20,4],[21,3,21,4],[21,1,21,2],[21,5,21,6],[18,3,18,4],[19,3,19,4],[17,1,17,2],[17,3,17,4],[4,2,4,3],[5,2,5,3],[23,1,23,2],[23,3,23,4],[23,5,23,6],[26,1,26,2],[26,3,26,4],[26,5,26,6],[27,1,27,2]]}
["School Name(s):",{"$f":"IF('School Invoice'!D1<>\"\",'School Invoice'!D1,\"\")","v":""},null,null,null,null,null,"Information entered on School Invoice tab will autofill here"]
["Fiduciary Name:",{"$f":"IF('School Invoice'!D2<>\"\",'School Invoice'!D2,\"\")","v":""}]
[null,{"$f":"IF('School Invoice'!D3<>\"\",'School Invoice'!D3,\"\")","v":""}]
[]
["Prime Contract #:","2012-0730","Billing #:",null,{"$f":"IF('School Invoice'!H5<>\"\",'School Invoice'!H5,\"\")","v":""}]
["Job #:",{"$f":"IF('School Invoice'!D6<>\"\",'School Invoice'!D6,\"\")","v":116005},"Billing Period:",null,{"$f":"IF('School Invoice'!H6<>\"\",'School Invoice'!H6,\"\")","v":""},"-",{"$f":"IF('School Invoice'!J6<>\"\",'School Invoice'!J6,\"\")","v":""}]
["Authorization #:",{"$f":"IF('School Invoice'!D7<>\"\",'School Invoice'!D7,\"\")","v":6}]
[]
[null,null,{"$f":"\"Mark when done entering expenses for Billing \"&E5","v":"Mark when done entering expenses for Billing "}]
[]
["BUDGET LINE ITEM\n(from award summary)","DESCRIPTION OF ITEMS/PURPOSE",null,"STORE/VENDOR NAME",null,"AMOUNT"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["TOTAL EXPENSES",null,null,null,null,{"$f":"SUM(F12:G41)","v":0}]
[]
["Notes"]
["1)  Copies of receipts/invoices for all expenses must be attached to this document."]
["2)  Travel expenses, including mileage - Travel Summary Form(s) must be attached."]
["3)  Copy/printing expenses - must indicate the number of copies and the cost per copy in the description."]
["4)  Refreshment or other food/beverage expenses - completed Meeting Summary Form(s) must be attached."]