{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Commission Report"],"not_rendered":{"images":1,"defined_names":21,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Commission Report","index":0,"n_rows":39,"n_cols":8,"rows_kept":39,"merged":[[41,1,41,7]]}
[]
[]
[null,"Commission Report"]
[]
[{"$nulls":6},"From:  ","2008-01-03"]
[null,"Name:",{"$nulls":4},"To:  ","2008-01-08"]
[]
[null,"Order Date","Order Number","Account","Invoice Amount","Commission Rate",null,"Amount "]
[null,"2008-01-03",1001,11200,{"v":101,"d":"$101.00"},{"v":0.05,"d":"5.00%"},null,{"$f":"IF(AND(E9<>0,F9),ROUND(E9*F9,2),\"\")","v":{"v":5.05,"d":"$5.05"}}]
[null,"2008-01-04",1202,11300,{"v":3000,"d":"3,000.00"},{"v":0.05,"d":"5.00%"},null,{"v":150,"d":"150.00"}]
[null,"2008-01-05",1303,11455,{"v":400,"d":"400.00"},{"v":0.05,"d":"5.00%"},null,{"v":20,"d":"20.00"}]
[null,"2008-01-08",1404,11344,{"v":2300,"d":"2,300.00"},{"v":0.06,"d":"6.00%"},null,{"v":138,"d":"138.00"}]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":7},""]
[{"$nulls":3},"Total Sales",{"$f":"IF(SUM(E9:E30),SUM(E9:E30),\"\")","v":{"v":5801,"d":"$5,801.00"}}]
[]
[{"$nulls":6},"Total Commission Earned   ",{"$f":"IF(SUM(H9:H30),SUM(H9:H30),\"\")","v":{"v":313.05,"d":"$313.05"}}]
[{"$nulls":6},"Less Advance   ",{"v":200,"d":"$200.00"}]
[{"$nulls":6},"Commission Payable   ",{"$f":"IF(OR(SUM(H33)<>0,H34),MAX(H33-H34,0),\"\")","v":{"v":113.05000000000001,"d":"$113.05"}}]
[]
[]
[]
[null,"SIGNED",{"$nulls":5},"DATE"]