{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["DATOS","GRAFICA","DO_HT"],"not_rendered":{"charts":1,"macros":1,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"DATOS","index":0,"n_rows":18,"n_cols":6,"rows_kept":18}
[null,"Punto de equilibrio • cálculo de costo fijo y variable"]
[null,"MOS Expert CPC Martín Cruz • +51 998 401 784 | Excel No Convencional"]
[]
[]
[]
[null,"Periodo","Cantidad","Ingresos","Costo Venta + Operativo","Utilidad Operativa"]
[null,{"$f":"EOMONTH(TODAY(),-12-MONTH(TODAY())+ROWS(B$7:B7)-1)+1","v":"2019-01-01"},{"v":12800,"d":"12,800"},{"v":131840,"d":"131,840"},{"v":101965.056,"d":"101,965"},{"$f":"D7-E7","v":{"v":29874.944000000003,"d":"29,875"}}]
[null,{"$f":"EOMONTH(TODAY(),-12-MONTH(TODAY())+ROWS(B$7:B8)-1)+1","v":"2019-02-01"},{"v":10400,"d":"10,400"},{"v":108160,"d":"108,160"},{"v":83650.944,"d":"83,651"},{"v":24509.055999999997,"d":"24,509"}]
[null,{"$f":"EOMONTH(TODAY(),-12-MONTH(TODAY())+ROWS(B$7:B9)-1)+1","v":"2019-03-01"},{"v":15600,"d":"15,600"},{"v":157560,"d":"157,560"},{"v":121856.904,"d":"121,857"},{"v":35703.096000000005,"d":"35,703"}]
[null,{"$f":"EOMONTH(TODAY(),-12-MONTH(TODAY())+ROWS(B$7:B10)-1)+1","v":"2019-04-01"},{"v":14200,"d":"14,200"},{"v":150520,"d":"150,520"},{"v":116412.16799999999,"d":"116,412"},{"v":34107.83200000001,"d":"34,108"}]
[null,{"$f":"EOMONTH(TODAY(),-12-MONTH(TODAY())+ROWS(B$7:B11)-1)+1","v":"2019-05-01"},{"v":17700,"d":"17,700"},{"v":178770,"d":"178,770"},{"v":138260.718,"d":"138,261"},{"v":40509.28200000001,"d":"40,509"}]
[null,{"$f":"EOMONTH(TODAY(),-12-MONTH(TODAY())+ROWS(B$7:B12)-1)+1","v":"2019-06-01"},{"v":9800,"d":"9,800"},{"v":119560,"d":"119,560"},{"v":92467.704,"d":"92,468"},{"v":27092.296000000002,"d":"27,092"}]
[null,{"$f":"EOMONTH(TODAY(),-12-MONTH(TODAY())+ROWS(B$7:B13)-1)+1","v":"2019-07-01"},{"v":10600,"d":"10,600"},{"v":124019.99999999999,"d":"124,020"},{"v":95917.06799999998,"d":"95,917"},{"v":28102.932,"d":"28,103"}]
[null,{"$f":"EOMONTH(TODAY(),-12-MONTH(TODAY())+ROWS(B$7:B14)-1)+1","v":"2019-08-01"},{"v":12500,"d":"12,500"},{"v":130000,"d":"130,000"},{"v":100542,"d":"100,542"},{"v":29458,"d":"29,458"}]
[null,{"$f":"EOMONTH(TODAY(),-12-MONTH(TODAY())+ROWS(B$7:B15)-1)+1","v":"2019-09-01"},{"v":11200,"d":"11,200"},{"v":131039.99999999999,"d":"131,040"},{"v":101346.33599999998,"d":"101,346"},{"v":29693.664000000004,"d":"29,694"}]
[null,{"$f":"EOMONTH(TODAY(),-12-MONTH(TODAY())+ROWS(B$7:B16)-1)+1","v":"2019-10-01"},{"v":9700,"d":"9,700"},{"v":125130,"d":"125,130"},{"v":96775.542,"d":"96,776"},{"v":28354.458,"d":"28,354"}]
[null,{"$f":"EOMONTH(TODAY(),-12-MONTH(TODAY())+ROWS(B$7:B17)-1)+1","v":"2019-11-01"},{"v":14500,"d":"14,500"},{"v":172550,"d":"172,550"},{"v":133450.16999999998,"d":"133,450"},{"v":39099.830000000016,"d":"39,100"}]
[null,{"$f":"EOMONTH(TODAY(),-12-MONTH(TODAY())+ROWS(B$7:B18)-1)+1","v":"2019-12-01"},{"v":9000,"d":"9,000"},{"v":90900,"d":"90,900"},{"v":70302.06,"d":"70,302"},{"v":20597.940000000002,"d":"20,598"}]

{"sheet":"GRAFICA","index":1,"n_rows":17,"n_cols":3,"rows_kept":17}
[null,"Punto de equilibrio • cálculo de costo fijo y variable"]
[null,"MOS Expert CPC Martín Cruz • +51 998 401 784 | Excel No Convencional"]
[]
[]
[]
[]
[]
[]
[null,"Determinación de:"]
[]
[null,"Precio Unitario",{"$f":"Precio","v":{"v":10.946283783783784,"d":"10.95"}}]
[]
[null,"Costo Variable",{"$f":"Costo","v":{"v":6.774456127881904,"d":"6.77"}}]
[]
[null,"Costo Fijo",{"$f":"Fijo","v":{"v":20860.59692278983,"d":"20,860.60"}}]
[]
[null,"Punto de Equilibrio",{"$f":"C15/(C11-C13)","v":{"v":5000.349641308497,"d":"5,000"}}]

{"sheet":"DO_HT","index":2,"n_rows":18,"n_cols":11,"rows_kept":18,"hidden":true}
[]
[]
[]
[null,null,"Ver","Leyenda","Filtro"]
[null,null,{"$f":"SUBTOTAL(3,t.filtro[[#This Row],[Filtro]])=1","v":true},"01. Ingresos",{"$f":"MID(t.filtro[[#This Row],[Leyenda]],5,100)","v":"Ingresos"}]
[null,null,{"$f":"SUBTOTAL(3,t.filtro[[#This Row],[Filtro]])=1","v":false},"02. C.Total",{"$f":"MID(t.filtro[[#This Row],[Leyenda]],5,100)","v":"C.Total"}]
[null,null,{"$f":"SUBTOTAL(3,t.filtro[[#This Row],[Filtro]])=1","v":false},"03. Costo Fijo",{"$f":"MID(t.filtro[[#This Row],[Leyenda]],5,100)","v":"Costo Fijo"}]
[null,null,{"$f":"SUBTOTAL(3,t.filtro[[#This Row],[Filtro]])=1","v":false},"04. Equilibrio",{"$f":"MID(t.filtro[[#This Row],[Leyenda]],5,100)","v":"Equilibrio"}]
[]
[]
[]
[null,null,"Cantidad","Ingresos","C.Total","Costo Fijo","Equilibrio",{"$f":"VLOOKUP(TRUE,t.filtro[],3,0)","v":"Ingresos"},null,null,{"$f":"SUM(DATOS!$D$7:$D$18)/SUM(DATOS!$C$7:$C$18)","v":{"v":10.946283783783784,"d":"10.95"}}]
[null,null,0,{"$f":"C13*DO_HT!$K$12","v":0},{"$f":"C13*DO_HT!$K$14+DO_HT!$K$16","v":{"v":20860.59692278983,"d":"20,861"}},{"$f":"DO_HT!$K$16","v":{"v":20860.59692278983,"d":"20,861"}},null,{"$f":"IF(OFFSET(C13,0,MATCH(H$12,$D$12:$G$12,0))=\"\",NA(),OFFSET(C13,0,MATCH(H$12,$D$12:$G$12,0)))","v":0}]
[null,null,{"$f":"AVERAGE(DATOS!C7:C18)","v":{"v":12333.333333333334,"d":"12,333"}},{"$f":"C14*DO_HT!$K$12","v":{"v":135004.1666666667,"d":"135,004"}},{"$f":"C14*DO_HT!$K$14+DO_HT!$K$16","v":{"v":104412.22249999999,"d":"104,412"}},{"$f":"DO_HT!$K$16","v":{"v":20860.59692278983,"d":"20,861"}},null,{"v":135004.1666666667,"d":"135,004"},null,null,{"$f":"SLOPE(DATOS!$E$7:$E$18,DATOS!$C$7:$C$18)","v":{"v":6.774456127881904,"d":"6.77"}}]
[null,null,{"$f":"DO_HT!$K$18","v":{"v":5000.349641308497,"d":"5,000"}},{"$nulls":3},0,{"$error":"#N/A"}]
[null,null,{"$f":"DO_HT!$K$18","v":{"v":5000.349641308497,"d":"5,000"}},{"$nulls":3},{"$f":"C16*DO_HT!K12","v":{"v":54735.24619190426,"d":"54,735"}},{"$error":"#N/A"},null,null,{"$f":"INTERCEPT(DATOS!$E$7:$E$18,DATOS!$C$7:$C$18)","v":{"v":20860.59692278983,"d":"20,860.60"}}]
[null,null,0,{"$nulls":3},{"$f":"G16","v":{"v":54735.24619190426,"d":"54,735"}},{"$error":"#N/A"}]
[null,null,{"$f":"DO_HT!$K$18","v":{"v":5000.349641308497,"d":"5,000"}},{"$nulls":3},{"$f":"G17","v":{"v":54735.24619190426,"d":"54,735"}},{"$error":"#N/A"},null,null,{"$f":"K16/(K12-K14)","v":{"v":5000.349641308497,"d":"5,000"}}]