{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Planilha1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Planilha1","index":0,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[5,1,7,1],[8,1,10,1],[12,9,12,13],[1,1,1,13]]}
[]
[null,"CÁLCULO DA CONTRAPARTIDA FINANCEIRA     . \n  PROJETO ARRUMANDO A CASA     ."]
[]
[null,"TIPOLOGIA",null,"FAIXA DE METRAGEM A SER REGULARIZADA",null,"VALOR DO M² DA ÁREA A SER REGULARIZADA",null,"ÁREA IRREGULAR:",null,"VALOR DA CONTRAPARTIDA",null,"*NÚMERO DE PARCELAS DESEJADAS:",null,"VALOR DE CADA PARCELA"]
[]
[null,"RESIDENCIAL UNIFAMILIAR",null,"ATÉ 100,00 m²",null,9.5,null,null,null,{"$f":"H6*F6","v":0},null,{"$f":"IF(J6<200,,IF(AND(J6>200,J6<300),2,IF(AND(J6>300,J6<400),3,IF(AND(J6>400,J6<500),4,IF(AND(J6>500,J6<600),5,IF(AND(J6>600,J6<700),6,IF(AND(J6>700,J6<800),7,IF(AND(J6>800,J6<900),8,IF(AND(J6>900,J6<1000),9,)))))))))","v":0},null,{"$f":"IF(H6>100,\"X\",IF(J6/L6>100,J6/L6,\"X\"))","v":{"$error":"#DIV/0!"}}]
[null,null,null,"de 100,01m² até 200,00m²",null,14.24,null,null,null,{"$f":"H7*F7","v":0},null,{"$f":"IF(J7<200,,IF(AND(J7>200,J7<300),2,IF(AND(J7>300,J7<400),3,IF(AND(J7>400,J7<500),4,IF(AND(J7>500,J7<600),5,IF(AND(J7>600,J7<700),6,IF(AND(J7>700,J7<800),7,IF(AND(J7>800,J7<900),8,IF(AND(J7>900,J7<1000),9,IF(AND(J7>1000,J7<1100),10,IF(AND(J7>1100,J7<1200),11,IF(J7>1200,12))))))))))))","v":0},null,{"$f":"IF(H7<100.01,\"X\",IF(H7>200,\"X\",IF(J7/L7>100,J7/L7,\"X\")))","v":"X"}]
[null,null,null,"acima de 200,01m²",null,21.37,null,null,null,0,null,0,null,{"$f":"IF(H8<200.01,\"X\",IF(J8/L8>100,J8/L8,\"X\"))","v":"X"}]
[null,"RESIDENCIAL MULTIFAMILIAR E NÃO RESIDENCIAL",null,"ATÉ 100,00m²",null,13.62,null,null,null,0,null,0,null,{"$f":"IF(H9>100,\"X\",IF(J9/L9>100,J9/L9,\"X\"))","v":{"$error":"#DIV/0!"}}]
[null,null,null,"de 100,01m² até 150,00m²",null,21.37,null,null,null,0,null,0,null,{"$f":"IF(H10<100.01,\"X\",IF(H10>150,\"X\",IF(J10/L10>100,J10/L10,\"X\")))","v":"X"}]
[null,null,null,"Acima de 150,01m²",null,32.049999999999997,null,null,null,0,null,0,null,{"$f":"IF(H11<150.01,\"X\",IF(J11/L11>100,J11/L11,\"X\"))","v":"X"}]
[]
[null,null,null,"PREENCHA OS CAMPOS EM AZUL",null,null,null,null,null,"*ALERTAMOS QUE CONFOME A LEGISLAÇÃO O A QUANTIDADE MÁXIMA DE PARCELAS SÃO 12 E O VALOR MÍNIMO SÃO R$ 100,00"]