{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Ноябрь"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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":"Ноябрь","index":0,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[[16,0,16,4],[17,0,17,4],[18,0,18,4],[13,0,13,4],[14,0,14,4],[19,0,19,4],[20,0,20,5],[1,0,1,4],[5,0,5,4],[0,0,0,5],[8,0,8,4],[9,0,9,4],[10,0,10,4],[11,0,11,4],[12,0,12,4],[2,0,2,4],[3,0,3,4],[4,0,4,4],[6,0,6,4],[7,0,7,4],[15,0,15,4]]}
["Калькулятор для расчёта премии отдела продаж"]
["Ссылка на сделку и комментарии:",null,null,null,null,"Чек сделки с наценкой отдела продаж:"]
["выфвыфвыфв",null,null,null,null,525000]
["выфвыфвф",null,null,null,null,525000]
["Сделка 3..",null,null,null,null,1030500,{"$f":"F5*100/105","v":981428.57142857148}]
["Сделка 4..",null,null,null,null,10000]
["Сделка 5..",null,null,null,null,2000000]
["Сделка 6..",null,null,null,null,33000]
["Сделка 7..",null,null,null,null,580000]
["Сделка 8..",null,null,null,null,35000]
["Сделка 9..",null,null,null,null,45900]
["Сделка 10..",null,null,null,null,79000]
["Сделка 11..",null,null,null,null,1000000]
["Сделка 12..",null,null,null,null,900000]
["Сделка 13..",null,null,null,null,100000]
["Сделка 14..",null,null,null,null,40000]
["Сделка 15..",null,null,null,null,"Сумма сделки без НДС.."]
["* Сумма наценки:",null,null,null,null,{"$f":"SUM(F3:F17)-SUM(F3:F17)*100/105","v":328733.33333333302}]
["Чистая прибыль компании:                                                                                (за вычетом страховки и подоходного налога)",null,null,null,null,{"$f":"F18*0.57","v":187377.9999999998}]
["На отдел продаж:",null,null,null,null,{"$f":"F19/5*3","v":112426.79999999989}]
["   * - при условии наценки 5% на сделку"]