{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Sales Commission Tracker","Month Lookup"],"not_rendered":{"charts":1,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Sales Commission Tracker","index":0,"n_rows":22,"n_cols":16,"rows_kept":22,"merged":[[3,3,3,5],[5,3,5,5],[7,3,7,5],[14,1,14,14],[18,1,18,14]]}
[]
[null,"SALES COMMISSION TRACKER"]
[]
[null,null,"Chart Period to View","YEAR"]
[]
[null,null,"Annual Sales Target",{"v":2000000,"d":"$2,000,000"}]
[]
[null,null,"Commission Percentage",{"v":0.1,"d":"10%"}]
[]
[]
[null,"ACTUAL","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","YEAR"]
[null,"SALES",{"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"},{"$nulls":6},{"$f":"SUM(Actual[[#This Row],[JAN]:[DEC]])","v":{"v":671000,"d":"$671,000"}}]
[null,"HOLDBACKS",{"v":2000,"d":"$2,000"},{"v":3000,"d":"$3,000"},{"v":6000,"d":"$6,000"},{"v":5000,"d":"$5,000"},{"v":10000,"d":"$10,000"},{"$nulls":7},{"$f":"SUM(Actual[[#This Row],[JAN]:[DEC]])","v":{"v":26000,"d":"$26,000"}}]
[null,"ADVANCES",{"v":100,"d":"$100"},null,null,{"v":1000,"d":"$1,000"},null,{"v":4000,"d":"$4,000"},{"$nulls":6},{"$f":"SUM(Actual[[#This Row],[JAN]:[DEC]])","v":{"v":5100,"d":"$5,100"}}]
[]
[null,"PROJECTED","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","YEAR"]
[null,"SALES",{"$f":"AnnualSalesTarget/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(Projected[[JAN]:[DEC]])","v":{"v":2199999.9999999995,"d":"$2,200,000"}}]
[null,"COMMISSION",{"$f":"CommissionPercent*C17","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(Projected[[#This Row],[JAN]:[DEC]])","v":{"v":199999.99999999997,"d":"$200,000"}}]
[]
[null,"COMMISSION","JAN","FEB","MAR","APR","MAY","JUN","JUL","AUG","SEP","OCT","NOV","DEC","YEAR","  "]
[null,"EARNED",{"$f":"CommissionPercent*C12","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":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"$f":"SUM(C21:N21)","v":{"v":67100,"d":"$67,100"}}]
[null,"PAID",{"$f":"C21-C13+C14","v":{"v":4600,"d":"$4,600"}},{"v":200,"d":"$200"},{"v":1800,"d":"$1,800"},{"v":7600,"d":"$7,600"},{"v":15000,"d":"$15,000"},{"v":17000,"d":"$17,000"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"$f":"SUM(C22:N22)","v":{"v":46200,"d":"$46,200"}}]

{"sheet":"Month Lookup","index":1,"n_rows":16,"n_cols":3,"rows_kept":16,"hidden":true}
[]
[null,"Month Lookup"]
[null,"This sheet should remain hidden"]
[null,"Month","Number"]
[null,"January",1]
[null,"February",2]
[null,"March",3]
[null,"April",4]
[null,"May",5]
[null,"June",6]
[null,"July",7]
[null,"August",8]
[null,"September",9]
[null,"October",10]
[null,"November",11]
[null,"December",12]