{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Commission Tracker","Commission Earned vs. Paid YTD"],"not_rendered":{"charts":2,"defined_names":16},"unopened":[{"sheet":"Commission Earned vs. Paid YTD","index":1,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900"}

{"sheet":"Commission Tracker","index":0,"n_rows":30,"n_cols":14,"rows_kept":30,"merged":[[0,1,0,3],[1,1,1,3],[2,1,2,2],[4,1,4,5],[5,1,5,5],[6,1,6,5],[7,1,7,2],[7,3,7,4],[8,1,8,2],[28,8,28,12],[29,8,29,12]]}
[null,"[Company name]"]
[null,"Commission Tracker"]
[null,"[Date]"]
[]
[null,"Model key:                                                                                                                                                                                                                                             "]
[null,"White cells with text are fields you can edit."]
[null,"Gray cells contain formulas that should not be changed."]
[null,"Annual sales target",null,{"v":2000000,"d":"$2,000,000"}]
[null,"Commission payout %",null,{"v":0.1,"d":"10%"}]
[]
[null,"Jan","Feb","Mar","Apr","May","June","July","Aug","Sep","Oct","Nov","Dec","Totals"]
[null,"Holdbacks"]
[null,{"v":2000,"d":"$2,000"},null,null,{"v":5000,"d":"$5,000"},{"$nulls":8},{"$f":"SUM(B13:M13)","v":{"v":7000,"d":"$7,000"}}]
[null,"Advances"]
[null,{"v":100,"d":"$100"},null,null,{"v":1000,"d":"$1,000"},{"$nulls":8},{"$f":"SUM(B15:M15)","v":{"v":1100,"d":"$1,100"}}]
[]
[null,"Jan","Feb","Mar","Apr","May","June","July","Aug","Sep","Oct","Nov","Dec","Totals"]
[null,"Expected sales"]
[null,{"$f":"$D$8/12","v":{"v":166666.66666666666,"d":"$166,667"}},{"v":166666.66666666666,"d":"$166,667"},{"v":166666.66666666666,"d":"$166,667"},{"v":166666.66666666666,"d":"$166,667"},{"v":166666.66666666666,"d":"$166,667"},{"v":166666.66666666666,"d":"$166,667"},{"v":166666.66666666666,"d":"$166,667"},{"v":166666.66666666666,"d":"$166,667"},{"v":166666.66666666666,"d":"$166,667"},{"v":166666.66666666666,"d":"$166,667"},{"v":166666.66666666666,"d":"$166,667"},{"v":166666.66666666666,"d":"$166,667"},{"$f":"SUM(B19:M19)","v":{"v":2000000.0000000002,"d":"$2,000,000"}}]
[null,"Actual sales"]
[null,{"v":65000,"d":"$65,000"},{"v":32000,"d":"$32,000"},{"v":78000,"d":"$78,000"},{"v":116000,"d":"$116,000"},{"v":250000,"d":"$250,000"},{"v":130000,"d":"$130,000"},{"v":600000,"d":"$600,000"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":150000,"d":"$150,000"},{"$f":"SUM(B21:M21)","v":{"v":1421000,"d":"$1,421,000"}}]
[null,"Anticipated commission"]
[null,{"$f":"B19*$D$9","v":{"v":16666.666666666668,"d":"16,667"}},{"v":16666.666666666668,"d":"16,667"},{"v":16666.666666666668,"d":"16,667"},{"v":16666.666666666668,"d":"16,667"},{"v":16666.666666666668,"d":"16,667"},{"v":16666.666666666668,"d":"16,667"},{"v":16666.666666666668,"d":"16,667"},{"v":16666.666666666668,"d":"16,667"},{"v":16666.666666666668,"d":"16,667"},{"v":16666.666666666668,"d":"16,667"},{"v":16666.666666666668,"d":"16,667"},{"v":16666.666666666668,"d":"16,667"},{"$f":"SUM(B23:M23)","v":{"v":199999.99999999997,"d":"$200,000"}}]
[null,"Commission earned"]
[null,{"$f":"B21*$D$9","v":{"v":6500,"d":"6,500"}},{"v":3200,"d":"3,200"},{"v":7800,"d":"7,800"},{"v":11600,"d":"11,600"},{"v":25000,"d":"25,000"},{"v":13000,"d":"13,000"},{"v":60000,"d":"60,000"},0,0,0,0,{"v":15000,"d":"15,000"},{"$f":"SUM(B25:M25)","v":{"v":142100,"d":"$142,100"}}]
[null,"Commission received"]
[null,{"$f":"B25-B13+B15","v":{"v":4600,"d":"4,600"}},{"$f":"C25-C13+C15","v":{"v":3200,"d":"3,200"}},{"$f":"D25-D13+D15","v":{"v":7800,"d":"7,800"}},{"$f":"E25-E13+E15","v":{"v":7600,"d":"7,600"}},{"$f":"F25-F13+F15","v":{"v":25000,"d":"25,000"}},{"$f":"G25-G13+G15","v":{"v":13000,"d":"13,000"}},{"$f":"H25-H13+H15","v":{"v":60000,"d":"60,000"}},{"$f":"I25-I13+I15","v":0},{"$f":"J25-J13+J15","v":0},{"$f":"K25-K13+K15","v":0},{"$f":"L25-L13+L15","v":0},{"$f":"M25-M13+M15","v":{"v":15000,"d":"15,000"}},{"$f":"SUM(B27:M27)","v":{"v":136200,"d":"$136,200"}}]
[]
[{"$nulls":8},"Commission earned YTD",{"$nulls":4},{"$f":"N25","v":{"v":142100,"d":"$142,100"}}]
[{"$nulls":8},"Commission received YTD",{"$nulls":4},{"$f":"N27","v":{"v":136200,"d":"$136,200"}}]