{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Painel de Controle KPI","Dados KPI"],"not_rendered":{"charts":6,"images":1,"macros":0,"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":"Painel de Controle KPI","index":0,"n_rows":81,"n_cols":1,"rows_kept":81,"cut":false,"hidden":false,"merged":[[0,0,0,8],[80,0,86,21]]}
["PAINEL DE CONTROLE KPI "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Learn More About Dashboards in Smartsheet"]

{"sheet":"Dados KPI","index":1,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[[1,10,1,11],[0,0,0,9],[1,5,1,6],[16,2,16,4],[1,0,1,1],[1,7,1,9],[1,2,1,4]]}
["DADOS KPI "]
["PRODUTOS",null,"ORÇAMENTO",null,null,"DESPESA LÍQUIDA",null,"RENDA",null,null,"MARGENS DE LUCRO"]
["NO.","NOME","OBJETIVO","ATUAL","RESIDUAL","ADICIONAL","TOTAL","OBJETIVO","ATUAL","RESIDUAL","BRUTO","LÍQUIDO"]
[1,"ITEM 1",129868,256513,{"$f":"(C4-D4)","v":-126645},24283,{"$f":"F4+D4","v":280796},1100916,1073357,{"$f":"I4-H4","v":-27559},{"$f":"(I4-D4)/I4","v":0.76101800239808381},{"$f":"(I4-G4)/I4","v":0.73839458819386283}]
[2,"ITEM 2",237605,85618,{"$f":"(C5-D5)","v":151987},10598,{"$f":"F5+D5","v":96216},215534,878162,{"$f":"I5-H5","v":662628},{"$f":"(I5-D5)/I5","v":0.90250318278404218},{"$f":"(I5-G5)/I5","v":0.89043479449122143}]
[3,"ITEM 3",249420,264259,-14839,10527,274786,820719,1193784,373065,0.77863750896309547,0.76981933080021181]
[4,"ITEM 4",226538,293368,-66830,20592,313960,620242,420345,-199897,0.30207805493106854,0.25308972391725842]
[5,"ITEM 5",109478,174003,-64525,20392,194395,821177,1175811,354634,0.85201448191928808,0.83467155860933429]
[6,"ITEM 6",129160,249567,-120407,14490,264057,901263,1015766,114503,0.75430660211111611,0.74004150562235793]
[7,"ITEM 7",213785,79255,134530,15582,94837,878528,733751,-144777,0.89198651858736822,0.87075043168595345]
[8,"ITEM 8",128283,122300,5983,21606,143906,838380,955983,117603,0.87206885478089047,0.84946803447341634]
[9,"ITEM 9",175438,119943,55495,20667,140610,1073157,924095,-149062,0.87020490317553933,0.84784031944767579]
[10,"ITEM 10",253755,255187,-1432,12347,267534,1141047,1061074,-79973,0.75950122234641504,0.7478648991493525]
[null,null,{"$f":"SUM(C4:C13)","v":1853330},{"$f":"SUM(D4:D13)","v":1900013},-46683,{"$f":"SUM(F4:F13)","v":171084},{"$f":"SUM(G4:G13)","v":2071097},8410963,9432128,1021165,{"$f":"SUM(K4:K13)/10","v":0.77443193319969061},{"$f":"SUM(L4:L13)/10","v":0.75423751863906441}]
[]
[]
[null,null,"COEFICIENTE DÍVIDA-PATRIMÔNIO"]
[null,null,"CALENDÁRIO","DÍVIDA","PATRIMÔNIO"]
[null,null,2007,3613439,3293202]
[null,null,2008,3508776,3441854]
[null,null,2009,3719457,3531844]
[null,null,2010,3310212,3354051]
[null,null,2011,3945202,3476155]
[null,null,2012,3938152,3538468]
[null,null,2013,3733706,3727037]
[null,null,2014,3526698,3425405]
[null,null,2015,3632971,3734041]
[null,null,2016,3206487,3677074]