{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["PROJETO","ATRIBUTOS","SEGMENTOS","USUARIOS","PERFIL","APL_3_NOTA","APL_2_NOTA","APL_1_NOTA","APL_3_SAT","APL_2_SAT","APL_1_SAT","APL_3_INSAT","APL_2_INSAT","APL_1_INSAT","APL_3_FIDEL","APL_2_FIDEL","APL_1_FIDEL","COMENTARIOS"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":18,"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":"PROJETO","index":0,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["ID_Projeto",50340]
["Projeto","Pesquisa de Satisfação dos Franqueados no Relacionamento com a Rede Alpha"]
["Data","2024-03-07"]

{"sheet":"ATRIBUTOS","index":1,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["ID_Atributo","Atributo","Grupo","Área / Dimensão","Impacto","Importância"]
[1,"Produtos atrativos e inovadores para o consumidor final","Qualidade percebida","Produtos",0.59]
[2,"Qualidade dos produtos","Qualidade percebida","Produtos",0.3]
[3,"Sistemática de compras (planejamento, clareza, duração)","Qualidade percebida","Planejamento de compras",0.42]
[4,"Assessoria do consultor de franquia no planejamento de compras","Qualidade percebida","Planejamento de compras",0.45]
[5,"Entrega em conformidade com o pedido original (itens e quantidades)","Qualidade percebida","Logística de entega",0.35]
[6,"Entrega do pedido no prazo acordado","Qualidade percebida","Logística de entega",0.41]
[7,"Eficácia das campanhas promocionais (calendário, vigência, direcionamento, atratividade).","Qualidade percebida","Apoio a vendas",0.51]
[8,"Eficácia do material de ponto de venda  (em tempo hábil, qualidade, quantidade, atratividade)","Qualidade percebida","Apoio a vendas",0.39]
[9,"Adequação dos treinamentos oferecidos em termos de frequência, conteúdo e praticidade","Qualidade percebida","Suporte operacional",0.45]
[10,"Eficácia das visitas do consultor de franquia (frequência, objetividade, conhecimento, assessoria, solução de problemas)","Qualidade percebida","Suporte operacional",0.4]
[11,"Eficácia do sistema de relatórios estatísticos e indicadores de desempenho","Qualidade percebida","Informação e gestão",0.41]
[12,"Eficácia do sistema de gestão da loja","Qualidade percebida","Informação e gestão",0.37]
[13,"Qualidade dos fornecedores","Qualidade percebida","Fornecedores",0.6]
[14,"Prazo dos fornecedores","Qualidade percebida","Fornecedores",0.27]
[15,"Canais de comunicação adequados (para solicitar, para se relacionar, para resolver problemas).","Qualidade percebida","Relacionamento",0.45]
[16,"Atuação do Conselho de Franqueados (agrega valor, representa de fato os franqueados, é de fácil acesso).","Qualidade percebida","Relacionamento",0.38]
[17,"Empresa ética (séria, honesta, transparente).","Qualidade percebida","Imagem corporativa",0.62]
[18,"Empresa que pratica responsabilidade social e ambiental.","Qualidade percebida","Imagem corporativa",0.5]
[19,"Relação custo x benefício do investimento realizado na franquia.","Condições comerciais","Condições comerciais",0.74]
[20,"Rentabilidade do negócio em relação ao projetado.","Condições comerciais","Condições comerciais",0.7]

{"sheet":"SEGMENTOS","index":2,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["ID_Segmento","Segmento","Comparativo"]
[2900,"Mercado"]
[50340,"Todos os Franqueados",2900]
[50341,"Franqueados da Região Norte",50340]
[50342,"Franqueados da Região Nordeste",50340]
[50343,"Franqueados da Região Centro-oeste",50340]
[50344,"Franqueados da Região Sudeste",50340]
[50345,"Franqueados da Região Sul",50340]
[50346,"Franqueados de Porte A",50340]
[50347,"Franqueados de Porte B",50340]
[50348,"Franqueados de Porte C",50340]
[50349,"Franqueados A da Região Sudeste",50344]
[50350,"Franqueados B da Região Sudeste",50344]
[50351,"Franqueados C da Região Sudeste",50344]

{"sheet":"USUARIOS","index":3,"n_rows":7,"n_cols":53,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["ID_Usuario","Segmento","senha","Visualiza01","Visualiza02","Visualiza03","Visualiza04","Visualiza05","Visualiza06","Visualiza07","Visualiza08","Visualiza09","Visualiza10","Visualiza11","Visualiza12","Visualiza13","Visualiza14","Visualiza15","Visualiza16","Visualiza17","Visualiza18","Visualiza19","Visualiza20","Visualiza21","Visualiza22","Visualiza23","Visualiza24","Visualiza25","Visualiza26","Visualiza27","Visualiza28","Visualiza29","Visualiza30","Visualiza31","Visualiza32","Visualiza33","Visualiza34","Visualiza35","Visualiza36","Visualiza37","Visualiza38","Visualiza39","Visualiza40","Visualiza41","Visualiza42","Visualiza43","Visualiza44","Visualiza45","Visualiza46","Visualiza47","Visualiza48","Visualiza49","Visualiza50"]
[50340,"Todos os franqueados",1234,2900,50340,50341,50342,50343,50344,50345,50346,50347,50348,50349,50350,50351]
[50341,"Franqueados da Região Norte",1478,2900,50340,50341]
[50342,"Franqueados da Região Nordeste",1458,2900,50340,50342]
[50343,"Franqueados da Região Centro-oeste",1469,2900,50340,50343]
[50344,"Franqueados da Região Sudeste",1432,2900,50340,50344,50349,50350,50351]
[50345,"Franqueados da Região Sul",1455,2900,50340,50345]

{"sheet":"PERFIL","index":4,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["ID_SEGMENTO","SEGMENTO_NOME","DATA","Qtd. de respondentes","Importancia estatégica","Importancia estatégica","Importancia estatégica","Região","Região","Região","Região","Região"]
["-","-","-","-","Franqueados A","Franqueados B","Franqueados C","Região Norte","Região Nordeste","Região Centro-Oeste","Região Sudeste","Região Sul"]
[50340,"Todos os Franqueados","2024-03-07",174,12,29,133,17,43,23,70,21]
[50341,"Franqueados da Região Norte","2024-03-07",13,3,4,6]
[50342,"Franqueados da Região Nordeste","2024-03-07",31,6,9,16]
[50343,"Franqueados da Região Centro-oeste","2024-03-07",14,3,4,7]
[50344,"Franqueados da Região Sudeste","2024-03-07",88,18,26,44]
[50345,"Franqueados da Região Sul","2024-03-07",28,6,8,14]
[50346,"Franqueados de Porte A","2024-03-07",12,null,null,null,2,3,2,4,1]
[50347,"Franqueados de Porte B","2024-03-07",29,null,null,null,3,7,4,12,3]
[50348,"Franqueados de Porte C","2024-03-07",133,null,null,null,13,33,17,53,17]
[50349,"Franqueados A da Região Sudeste","2024-03-07",18]
[50350,"Franqueados B da Região Sudeste","2024-03-07",26]
[50351,"Franqueados C da Região Sudeste","2024-03-07",44]

{"sheet":"APL_3_NOTA","index":5,"n_rows":14,"n_cols":25,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["ID_Segmento","Segmento","Data",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,"IQP","I$P"]
[2900,"Mercado","2024-03-07",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.1,7.6]
[50340,"Todos os Franqueados","2024-03-07",6.7991266375545854,6.0482456140350873,7.2555066079295152,6.8034934497816595,6.4890829694323147,6.2719298245614032,7.5807860262008733,7.2017543859649127,7.2663755458515285,6.5921052631578947,6.2751091703056767,7.5589519650655026,6.90625,6.0044052863436121,6.5133928571428568,7.2882096069868991,7.4912280701754383,7.9868421052631575,6.0964912280701755,7.2522123893805297,7.0296975416386962,5.9098732938586398]
[50341,"Franqueados da Região Norte","2024-03-07",6.8235294117647056,5.882352941176471,7.5882352941176467,6.4705882352941178,7.117647058823529,6.1764705882352944,8.0588235294117645,7.4117647058823533,7.4705882352941178,5.8235294117647056,6,7.0588235294117645,7.5,5.882352941176471,6.4117647058823533,7.5882352941176467,8,8.2941176470588243,7.4117647058823533,7.3529411764705896,7.0342437418505046,6.0917019540442503]
[50342,"Franqueados da Região Nordeste","2024-03-07",7.3658536585365857,7,7.8048780487804876,7.1463414634146343,6.9512195121951219,6.4634146341463419,8.0487804878048781,7.6829268292682924,7.1463414634146343,7.1951219512195124,6.4146341463414638,7.2439024390243905,7.5128205128205128,6.3250000000000002,6.6749999999999998,7.5,7.8461538461538458,8.3076923076923084,6.1282051282051286,7.4102564102564097,7.2595748152985706,6.0872229177980497]
[50343,"Franqueados da Região Centro-oeste","2024-03-07",7.1052631578947372,6.4210526315789478,7.2631578947368425,6.8421052631578947,6.7368421052631575,6.4210526315789478,6.9473684210526319,6.7368421052631575,7.5263157894736841,7.0526315789473681,6.3684210526315788,7.9473684210526319,7.833333333333333,6.6315789473684212,6.7368421052631575,7.7894736842105265,7.833333333333333,8,6,7.3333333333333304,7.2773205953242996,5.9675160863262198]
[50344,"Franqueados da Região Sudeste","2024-03-07",6.7068965517241379,5.9565217391304346,7.1754385964912277,6.75,6.4137931034482758,6.0782608695652174,7.5948275862068968,7.2260869565217387,7.4827586206896548,6.6465517241379306,6.4102564102564106,7.8965517241379306,6.7327586206896548,6.1130434782608694,6.7142857142857144,7.2327586206896548,7.3675213675213671,7.9741379310344831,6,7.2260869565217396,7.0426301649512766,6.0158803050698202]
[50345,"Franqueados da Região Sul","2024-03-07",6.2777777777777777,5.1388888888888893,6.7222222222222223,6.7222222222222223,5.7777777777777777,6.6388888888888893,7.1111111111111107,6.7222222222222223,6.4722222222222223,5.8285714285714283,5.7428571428571429,6.8611111111111107,6.0571428571428569,5.0277777777777777,5.6388888888888893,6.8378378378378377,7.1081081081081079,7.5405405405405403,5.8108108108108105,7.0810810810810798,6.5920414262916145,5.2818353724961504]
[50346,"Franqueados de Porte A","2024-03-07",7.1428571428571432,6.5,7.5714285714285712,6.8571428571428568,7.0714285714285712,6.4285714285714288,7.9285714285714288,8.0714285714285712,6.8571428571428568,7,5.4285714285714288,7.9285714285714288,6.3076923076923075,6.2142857142857144,7.2142857142857144,7.9285714285714288,7.1538461538461542,7.7142857142857144,6.2307692307692308,7.3076923076923102,7.0775463100822291,5.4341124668715404]
[50347,"Franqueados de Porte B","2024-03-07",6.3947368421052628,5.756756756756757,6.9210526315789478,6.4736842105263159,6.3421052631578947,5.9736842105263159,7.1578947368421053,7.2162162162162158,6.7631578947368425,6.6923076923076925,6.1794871794871797,7.6578947368421053,6.2894736842105265,5.2894736842105265,6.0769230769230766,6.7692307692307692,7,7.5384615384615383,5.8717948717948714,6.7105263157894699,6.6329582717770323,5.3706185582202899]
[50348,"Franqueados de Porte C","2024-03-07",6.8587570621468927,6.0734463276836159,7.3028571428571425,6.870056497175141,6.4745762711864403,6.3238636363636367,7.6440677966101696,7.129943502824859,7.406779661016949,6.5371428571428574,6.3636363636363633,7.5084745762711869,7.0867052023121389,6.1428571428571432,6.5555555555555554,7.3522727272727275,7.6214689265536721,8.1085714285714285,6.1363636363636367,7.3657142857142901,7.1088207865436779,6.0670637399362004]
[50349,"Franqueados A da Região Sudeste","2024-03-07",5.5,5.5,6.833333333333333,5.333333333333333,7.166666666666667,5.833333333333333,8,7.5,6.166666666666667,6.833333333333333,5.5,7.833333333333333,6.6,6.666666666666667,6.666666666666667,7.833333333333333,6.166666666666667,7.166666666666667,6,6.6666666666666696,6.7787847706079996,4.7467231264708003]
[50350,"Franqueados B da Região Sudeste","2024-03-07",5.8636363636363633,5.3636363636363633,6.7727272727272725,6.3181818181818183,6,5.8181818181818183,7.0454545454545459,7.1363636363636367,6.5454545454545459,6.4347826086956523,6.1304347826086953,7.5454545454545459,6.4347826086956523,4.9090909090909092,5.6956521739130439,6.7826086956521738,7,7.5652173913043477,6,6.5909090909090899,6.5870714448763392,5.6064160879796798]
[50351,"Franqueados C da Região Sudeste","2024-03-07",6.9078014184397167,5.9645390070921982,7.4316546762589928,6.8581560283687946,6.2836879432624118,6.4642857142857144,7.7375886524822697,7.1276595744680851,7.4964539007092199,6.4604316546762588,6.3428571428571425,7.5602836879432624,7.2043795620437958,6.2142857142857144,6.5514705882352944,7.371428571428571,7.6808510638297873,8.1428571428571423,6.2142857142857144,7.4316546762589901,7.1587524023216442,6.1994129024627798]

{"sheet":"APL_2_NOTA","index":6,"n_rows":14,"n_cols":25,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["ID_Segmento","Segmento","Data",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,"IQP","I$P"]
[2900,"Mercado","2023-03-02"]
[50340,"Todos os Franqueados","2023-03-02",7.020833333333333,6.447916666666667,7.385416666666667,7.0932642487046635,7.015625,7.005235602094241,7.905263157894737,7.4136125654450264,7.2368421052631575,7.072916666666667,6.9682539682539684,7.8341968911917101,8.027322404371585,6.6789473684210527,7.2275132275132279,7.693121693121693,7.9421052631578943,8.3263157894736839,5.3809523809523814,6.6473684210526311,7.1580248037052741,6.4220514233630794]
[50341,"Franqueados da Região Norte","2023-03-02",7.416666666666667,6.833333333333333,8.0833333333333339,7.333333333333333,8.25,7.75,8.3333333333333339,8.1666666666666661,6.166666666666667,8.25,7.416666666666667,7.916666666666667,8.6666666666666661,7.5,8.0833333333333339,7.666666666666667,8.8333333333333339,9.25,7.75,7.75,7.7167791867595454,7.2540792540792536]
[50342,"Franqueados da Região Nordeste","2023-03-02",7.5769230769230766,7.115384615384615,7.8076923076923075,6.9615384615384617,6.9615384615384617,7.16,8.2799999999999994,7.64,5.8,7.3461538461538458,7.2,6.9230769230769234,7.6111111111111107,6.68,6.8,7.458333333333333,8.08,8.1199999999999992,5.416666666666667,6.7307692307692308,7.1610954549372394,6.6230769230769235]
[50343,"Franqueados da Região Centro-oeste","2023-03-02",7.45,7.4,7.95,7.65,7.35,7.25,7.9,7.75,7.5263157894736841,6.85,7.5263157894736841,8,8.1578947368421044,7.4736842105263159,7.8,7.75,8.4,8.5500000000000007,5.4,6.6842105263157894,7.4568200726995073,6.5076923076923086]
[50344,"Franqueados da Região Sudeste","2023-03-02",6.6930693069306928,6.0495049504950495,7.0594059405940595,6.8725490196078427,6.9306930693069306,6.9108910891089108,7.76,7.217821782178218,7.6930693069306928,6.9019607843137258,6.92,7.9019607843137258,8.0294117647058822,6.4313725490196081,7.12,7.7524752475247523,7.7920792079207919,8.2376237623762378,5.0198019801980198,6.4851485148514856,6.9986552090484961,6.2695324283559586]
[50345,"Franqueados da Região Sul","2023-03-02",7.1818181818181817,6.4242424242424239,7.4545454545454541,7.4545454545454541,6.666666666666667,6.7575757575757578,7.9090909090909092,7.3636363636363633,7.1515151515151514,7.09375,6.4545454545454541,8.2121212121212128,7.9375,6.6875,7.21875,7.65625,7.6875,8.28125,5.59375,6.65625,7.2462541295651484,6.3935483870967742]
[50346,"Franqueados de Porte A","2023-03-02",6.4,6,7.0714285714285712,6.25,7.2,6.9375,7.8,7.0625,7.1875,7.3125,6.8,7.875,8,6.4375,6.875,7.375,7.5625,7.875,4.8125,6.1875,6.9680957778305554,5.5211538461538465]
[50347,"Franqueados de Porte B","2023-03-02",6.4761904761904763,5.9761904761904763,6.7380952380952381,6.5952380952380949,7.2682926829268295,5.9285714285714288,7.5238095238095237,7.3095238095238093,6.333333333333333,6.7073170731707314,6.8,7.7804878048780486,7.2105263157894735,6.2195121951219514,6.7435897435897436,7.3414634146341466,7.5365853658536581,7.7073170731707314,5.0487804878048781,5.8780487804878048,6.6636123175187247,5.7588461538461528]
[50348,"Franqueados de Porte C","2023-03-02",7.2592592592592595,6.6444444444444448,7.617647058823529,7.3481481481481481,6.9191176470588234,7.3533834586466167,8.0375939849624061,7.488721804511278,7.5303030303030303,7.1555555555555559,7.0373134328358207,7.8455882352941178,8.2713178294573648,6.8496240601503757,7.41044776119403,7.8409090909090908,8.1127819548872182,8.5714285714285712,5.5530303030303028,6.9398496240601499,7.3317391433467325,6.72673045031254]
[50349,"Franqueados A da Região Sudeste","2023-03-02",5.8,5,7,5.5,8,7.166666666666667,8.3333333333333339,6.333333333333333,7.333333333333333,6.166666666666667,5,7.833333333333333,8.1666666666666661,6.666666666666667,6.833333333333333,7.166666666666667,6.833333333333333,7.666666666666667,5.833333333333333,5.666666666666667,6.871332232314896,4.3897435897435901]
[50350,"Franqueados B da Região Sudeste","2023-03-02",6.0384615384615383,5.384615384615385,6.2307692307692308,6.0384615384615383,6.8,5.5384615384615383,7.615384615384615,7.3076923076923075,6.9230769230769234,6.68,6.125,7.52,6.916666666666667,6.28,6.5,6.96,7.28,7.8,5.52,5.84,6.5474454315437107,5.4570512820512818]
[50351,"Franqueados C da Região Sudeste","2023-03-02",7.2522522522522523,6.5625,7.7857142857142856,7.3873873873873874,6.8125,7.669724770642202,8.2293577981651378,7.7522935779816518,7.7064220183486238,7.1711711711711708,7.127272727272727,7.9910714285714288,8.3584905660377355,7.0909090909090908,7.5363636363636362,8.1203703703703702,8.238532110091743,8.6972477064220186,5.833333333333333,7.3027522935779814,7.5738180336372505,7.0717948717948715]

{"sheet":"APL_1_NOTA","index":7,"n_rows":14,"n_cols":25,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["ID_Segmento","Segmento","Data",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,"IQP","I$P"]
[2900,"Mercado","2022-03-03"]
[50340,"Todos os Franqueados","2022-03-03",6.9823529411764707,5.7514792899408285,7.3941176470588239,7.2807017543859649,6.7719298245614032,7.1360946745562126,7.1627906976744189,6.6976744186046515,7.5906432748538011,6.4825581395348841,6.0231213872832372,7.1569767441860463,8.0238095238095237,7.6300578034682083,7.4244186046511631,7.6802325581395348,7.9710982658959537,8.2716763005780347,6.0751445086705198,7.052941176470588,7.2769250918740935,6.840257668221934]
[50341,"Franqueados da Região Norte","2022-03-03",7.7777777777777777,6.7777777777777777,8,7.333333333333333,7.333333333333333,8.25,7.7777777777777777,6.666666666666667,7.875,7,6.2222222222222223,7.625,9,8.5555555555555554,8,7.666666666666667,8.5555555555555554,9.5555555555555554,6.5555555555555554,8.875,7.9270802568761534,8.0583869904711953]
[50342,"Franqueados da Região Nordeste","2022-03-03",7.68,5.88,7.833333333333333,7.92,6.8,7.32,7.16,6.96,7.68,5.56,5.36,5.48,7.4545454545454541,7.2,7.6,7.88,8.24,7.96,6.08,7.4,7.3352848051052311,6.8752431893417265]
[50343,"Franqueados da Região Centro-oeste","2022-03-03",7.2941176470588234,6.125,7.6470588235294121,8.117647058823529,7.2941176470588234,7.2941176470588234,7.5294117647058822,7.0588235294117645,8.235294117647058,6.9411764705882355,6.7058823529411766,6.9411764705882355,8.875,8.0588235294117645,8.117647058823529,8.0588235294117645,8.235294117647058,8.7058823529411757,6.6470588235294121,7.2352941176470589,7.814490364090406,6.937179150707335]
[50344,"Franqueados da Região Sudeste","2022-03-03",6.7127659574468082,5.5,7.242105263157895,6.9684210526315793,6.8631578947368421,7.075268817204301,7.0210526315789474,6.6526315789473687,7.5263157894736841,6.635416666666667,6.145833333333333,7.40625,7.96875,7.65625,7.3368421052631581,7.5789473684210522,7.854166666666667,8.2395833333333339,6.041666666666667,6.8315789473684214,7.1236292537020915,6.6710017985009742]
[50345,"Franqueados da Região Sul","2022-03-03",6.8,5.96,7.16,7.24,5.84,6.7307692307692308,7.2307692307692308,6.384615384615385,7.2307692307692308,6.32,5.6923076923076925,7.8461538461538458,7.884615384615385,7.3461538461538458,6.9230769230769234,7.615384615384615,7.7692307692307692,7.9615384615384617,5.6538461538461542,6.84,7.1996539016889018,6.940020764106599]
[50346,"Franqueados de Porte A","2022-03-03",6.3636363636363633,4.4545454545454541,6.8181818181818183,5.9090909090909092,7.1818181818181817,6.4545454545454541,7.4545454545454541,6.5454545454545459,5.1818181818181817,6.7272727272727275,6.2727272727272725,7.5454545454545459,8.1818181818181817,6.1818181818181817,6.2727272727272725,7,6.7272727272727275,7.9090909090909092,5.9090909090909092,7,6.7942720781771637,5.5346436121402887]
[50347,"Franqueados de Porte B","2022-03-03",6.7666666666666666,5.7666666666666666,7.0333333333333332,7.5,6.7666666666666666,6.833333333333333,7.2333333333333334,6.9,7.2333333333333334,6.4666666666666668,6.0333333333333332,7.2,7.6785714285714288,7.333333333333333,6.9666666666666668,7.3,7.833333333333333,7.8666666666666663,5.833333333333333,6.2666666666666666,6.9787442244500255,6.0116761451658141]
[50348,"Franqueados de Porte C","2022-03-03",7.0852713178294575,5.859375,7.5271317829457365,7.3461538461538458,6.7384615384615385,7.265625,7.1221374045801529,6.66412213740458,7.8769230769230774,6.4656488549618318,6,7.114503816793893,8.0852713178294575,7.8181818181818183,7.6259541984732824,7.8244274809160306,8.1060606060606055,8.3939393939393945,6.1439393939393936,7.2403100775193803,7.3836029749571104,7.1310956893244013]
[50349,"Franqueados A da Região Sudeste","2022-03-03",5.875,3.75,7,6,6.875,6.625,7.75,6.625,5.125,6.875,6.25,7.875,8.5,6.75,6.875,7.5,6.625,8.375,6.125,7.25,7.0292786060540617,5.9236967547862616]
[50350,"Franqueados B da Região Sudeste","2022-03-03",6.5909090909090908,5.3636363636363633,7.2272727272727275,7.2272727272727275,6.2272727272727275,6.8181818181818183,7.0454545454545459,6.6818181818181817,7.6363636363636367,6.2727272727272725,5.7727272727272725,7.1363636363636367,7.8636363636363633,7.5,6.8636363636363633,7.2272727272727275,7.6363636363636367,7.8636363636363633,6.4545454545454541,6.8181818181818183,7.0425956111068437,5.9467180825496744]
[50351,"Franqueados C da Região Sudeste","2022-03-03",6.9528301886792452,5.5333333333333332,7.5714285714285712,7.3018867924528301,6.5377358490566042,7.5673076923076925,7.1308411214953269,6.6822429906542054,8.1037735849056602,6.5233644859813085,6.0648148148148149,7.2056074766355138,8.1714285714285708,8.0462962962962958,7.7314814814814818,7.962616822429907,8.1388888888888893,8.4629629629629637,6.1574074074074074,7.3619047619047615,7.4502195207830821,7.4329829580285773]

{"sheet":"APL_3_SAT","index":8,"n_rows":14,"n_cols":25,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["ID_Segmento","Segmento","Data",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,"ISQP","IS$P"]
[2900,"Mercado","2024-03-07",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.79200000000000004,0.77200000000000002]
[50340,"Todos os Franqueados","2024-03-07",0.64628820960698685,0.49561403508771934,0.74889867841409696,0.63318777292576423,0.59825327510917026,0.53508771929824561,0.79039301310043664,0.67105263157894735,0.72052401746724892,0.59649122807017541,0.52838427947598254,0.78165938864628826,0.6607142857142857,0.48458149779735682,0.59375,0.73362445414847177,0.78508771929824561,0.86403508771929827,0.46491228070175439,0.7168141592920354,0.68566635603129877,0.44035540756673813]
[50341,"Franqueados da Região Norte","2024-03-07",0.64705882352941169,0.47058823529411759,0.88235294117647056,0.58823529411764708,0.76470588235294112,0.47058823529411759,0.76470588235294112,0.64705882352941169,0.70588235294117652,0.47058823529411759,0.41176470588235292,0.64705882352941169,0.75,0.52941176470588236,0.58823529411764708,0.82352941176470584,0.82352941176470584,0.82352941176470584,0.76470588235294112,0.64705882352941169,0.67995065240788743,0.53165960919115041]
[50342,"Franqueados da Região Nordeste","2024-03-07",0.85365853658536583,0.75609756097560976,0.80487804878048796,0.73170731707317072,0.70731707317073178,0.56097560975609762,0.92682926829268297,0.73170731707317072,0.73170731707317072,0.73170731707317072,0.58536585365853655,0.73170731707317072,0.76923076923076938,0.55000000000000004,0.625,0.75,0.84615384615384615,0.84615384615384615,0.41025641025641024,0.69230769230769229,0.72774719791592513,0.46120237194572283]
[50343,"Franqueados da Região Centro-oeste","2024-03-07",0.68421052631578949,0.57894736842105265,0.78947368421052633,0.63157894736842102,0.68421052631578949,0.57894736842105265,0.63157894736842102,0.52631578947368418,0.73684210526315785,0.68421052631578949,0.52631578947368418,0.84210526315789469,0.88888888888888884,0.63157894736842102,0.63157894736842102,0.73684210526315785,0.83333333333333348,0.84210526315789469,0.5,0.7777777777777779,0.72998959977115774,0.5411273025455674]
[50344,"Franqueados da Região Sudeste","2024-03-07",0.56896551724137934,0.41739130434782612,0.72807017543859653,0.62068965517241381,0.57758620689655171,0.5043478260869565,0.78448275862068972,0.70434782608695656,0.72413793103448265,0.60344827586206895,0.54700854700854706,0.83620689655172409,0.59482758620689657,0.47826086956521741,0.6339285714285714,0.74137931034482762,0.76068376068376065,0.89655172413793105,0.44444444444444442,0.73043478260869565,0.67633201959404743,0.41610408087283707]
[50345,"Franqueados da Região Sul","2024-03-07",0.63888888888888884,0.41666666666666674,0.66666666666666652,0.58333333333333337,0.41666666666666674,0.61111111111111116,0.75,0.58333333333333337,0.69444444444444442,0.42857142857142855,0.45714285714285713,0.69444444444444442,0.6,0.33333333333333326,0.41666666666666674,0.64864864864864868,0.7567567567567568,0.81081081081081086,0.4324324324324324,0.70270270270270274,0.64531449233795302,0.40540540540540543]
[50346,"Franqueados de Porte A","2024-03-07",0.6428571428571429,0.5714285714285714,0.7857142857142857,0.5,0.7142857142857143,0.42857142857142855,0.8571428571428571,0.8571428571428571,0.6428571428571429,0.5714285714285714,0.35714285714285715,0.8571428571428571,0.53846153846153844,0.5,0.7142857142857143,0.8571428571428571,0.69230769230769229,0.7857142857142857,0.46153846153846151,0.84615384615384615,0.65448026187232156,0.21891598939889134]
[50347,"Franqueados de Porte B","2024-03-07",0.63157894736842102,0.48648648648648651,0.68421052631578949,0.60526315789473684,0.60526315789473684,0.44736842105263158,0.68421052631578949,0.6216216216216216,0.52631578947368418,0.61538461538461542,0.53846153846153844,0.81578947368421051,0.55263157894736847,0.36842105263157893,0.53846153846153844,0.61538461538461542,0.71052631578947367,0.79487179487179493,0.4358974358974359,0.55263157894736847,0.61896291580843621,0.3080283972850465]
[50348,"Franqueados de Porte C","2024-03-07",0.64971751412429379,0.49152542372881358,0.76,0.64971751412429379,0.58757062146892658,0.5625,0.80790960451977401,0.66666666666666652,0.76836158192090398,0.59428571428571431,0.53977272727272729,0.76836158192090398,0.69364161849710981,0.50857142857142856,0.59649122807017541,0.75,0.80790960451977401,0.88571428571428568,0.47159090909090912,0.74285714285714288,0.70217855314742406,0.48691563738357585]
[50349,"Franqueados A da Região Sudeste","2024-03-07",0.33333333333333326,0.33333333333333326,0.66666666666666652,0.33333333333333326,0.66666666666666652,0.5,0.83333333333333348,0.83333333333333348,0.5,0.5,0.16666666666666663,0.83333333333333348,0.6,0.5,0.66666666666666652,0.83333333333333348,0.5,0.66666666666666652,0.5,0.83333333333333348,0.60670728833201071,0.24890770882359881]
[50350,"Franqueados B da Região Sudeste","2024-03-07",0.5,0.40909090909090912,0.59090909090909094,0.54545454545454541,0.54545454545454541,0.40909090909090912,0.59090909090909094,0.54545454545454541,0.5,0.52173913043478259,0.47826086956521741,0.72727272727272729,0.60869565217391308,0.27272727272727271,0.47826086956521741,0.60869565217391308,0.65217391304347827,0.78260869565217395,0.39130434782608697,0.5,0.59678409721102998,0.43478260869565216]
[50351,"Franqueados C da Região Sudeste","2024-03-07",0.63829787234042556,0.46808510638297873,0.79136690647482011,0.62411347517730498,0.54609929078014185,0.61428571428571432,0.82269503546099287,0.65957446808510634,0.79432624113475181,0.5611510791366906,0.52142857142857146,0.76595744680851074,0.7153284671532848,0.51428571428571423,0.58088235294117652,0.74285714285714288,0.80141843971631199,0.88571428571428568,0.5,0.75539568345323749,0.70686913977642563,0.52321136079318808]

{"sheet":"APL_2_SAT","index":9,"n_rows":14,"n_cols":25,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["ID_Segmento","Segmento","Data",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,"ISQP","IS$P"]
[2900,"Mercado","2023-03-02"]
[50340,"Todos os Franqueados","2023-03-02",0.703125,0.546875,0.75520833333333348,0.69948186528497414,0.71354166666666652,0.7120418848167539,0.85263157894736841,0.74345549738219896,0.70526315789473681,0.671875,0.66137566137566139,0.81865284974093266,0.8306010928961749,0.62105263157894741,0.70899470899470896,0.81481481481481477,0.86842105263157909,0.93157894736842106,0.35978835978835977,0.6,0.70436451463059169,0.55746232274201413]
[50341,"Franqueados da Região Norte","2023-03-02",0.83333333333333348,0.66666666666666652,0.83333333333333348,0.75,0.83333333333333348,0.83333333333333348,0.83333333333333348,0.91666666666666652,0.5,0.83333333333333348,0.66666666666666652,0.83333333333333348,0.83333333333333348,0.66666666666666652,0.83333333333333348,0.66666666666666652,0.91666666666666652,1,0.58333333333333337,0.75,0.7477698398523549,0.69055944055944052]
[50342,"Franqueados da Região Nordeste","2023-03-02",0.88461538461538458,0.76923076923076938,0.84615384615384615,0.76923076923076938,0.69230769230769229,0.76,0.96,0.8,0.44,0.73076923076923062,0.76,0.69230769230769229,0.83333333333333348,0.76,0.68,0.75,0.92,0.92,0.33333333333333326,0.65384615384615385,0.74305821290609975,0.59526627218934913]
[50343,"Franqueados da Região Centro-oeste","2023-03-02",0.7,0.7,0.85,0.75,0.85,0.7,0.8,0.75,0.73684210526315785,0.6,0.78947368421052633,0.8,0.89473684210526316,0.84210526315789469,0.8,0.8,0.9,0.9,0.35,0.63157894736842102,0.73556847637707989,0.57153846153846144]
[50344,"Franqueados da Região Sudeste","2023-03-02",0.6534653465346536,0.46534653465346537,0.70297029702970293,0.65686274509803921,0.70297029702970293,0.70297029702970293,0.85,0.71287128712871284,0.79207920792079212,0.64705882352941169,0.67,0.85294117647058831,0.82352941176470584,0.56862745098039214,0.71,0.84158415841584155,0.85148514851485146,0.93069306930693074,0.33663366336633666,0.57425742574257421,0.68243435186159518,0.55791855203619911]
[50345,"Franqueados da Região Sul","2023-03-02",0.66666666666666652,0.48484848484848486,0.75757575757575746,0.72727272727272729,0.63636363636363635,0.66666666666666652,0.81818181818181823,0.72727272727272729,0.69696969696969702,0.6875,0.48484848484848486,0.81818181818181823,0.8125,0.53125,0.625,0.84375,0.84375,0.9375,0.375,0.5625,0.70505930239830317,0.46550868486352359]
[50346,"Franqueados de Porte A","2023-03-02",0.53333333333333333,0.33333333333333326,0.7857142857142857,0.4375,0.73333333333333328,0.875,0.8,0.625,0.75,0.625,0.46666666666666662,0.75,0.8125,0.5625,0.6875,0.6875,0.875,0.9375,0.3125,0.375,0.68193917902660561,0.49711538461538463]
[50347,"Franqueados de Porte B","2023-03-02",0.52380952380952384,0.42857142857142855,0.5714285714285714,0.59523809523809523,0.78048780487804881,0.47619047619047611,0.83333333333333348,0.7142857142857143,0.54761904761904767,0.68292682926829273,0.6,0.80487804878048796,0.73684210526315785,0.46341463414634149,0.5641025641025641,0.73170731707317072,0.85365853658536583,0.78048780487804881,0.29268292682926828,0.41463414634146339,0.60607003795338865,0.42153846153846153]
[50348,"Franqueados de Porte C","2023-03-02",0.7777777777777779,0.6074074074074074,0.80882352941176483,0.76296296296296295,0.69117647058823517,0.76691729323308266,0.86466165413533824,0.76691729323308266,0.75,0.67407407407407405,0.70149253731343297,0.83088235294117652,0.86046511627906985,0.67669172932330823,0.75373134328358204,0.85606060606060608,0.8721804511278195,0.97744360902255634,0.38636363636363635,0.68421052631578949,0.7405110615735333,0.60513330781987495]
[50349,"Franqueados A da Região Sudeste","2023-03-02",0.4,0,1,0.33333333333333326,1,1,0.83333333333333348,0.5,0.83333333333333348,0.33333333333333326,0,0.83333333333333348,0.83333333333333348,0.66666666666666652,0.66666666666666652,0.66666666666666652,0.83333333333333348,1,0.5,0.33333333333333326,0.68228048444811473,0.4128205128205128]
[50350,"Franqueados B da Região Sudeste","2023-03-02",0.42307692307692307,0.30769230769230771,0.46153846153846151,0.46153846153846151,0.68,0.46153846153846151,0.80769230769230771,0.69230769230769229,0.61538461538461542,0.68,0.41666666666666674,0.76,0.70833333333333348,0.44,0.5,0.64,0.8,0.8,0.32,0.36,0.57994324575289735,0.34935897435897428]
[50351,"Franqueados C da Região Sudeste","2023-03-02",0.78378378378378377,0.5982142857142857,0.8392857142857143,0.7567567567567568,0.6875,0.8165137614678899,0.88990825688073405,0.80733944954128445,0.77064220183486243,0.68468468468468469,0.73636363636363622,0.8571428571428571,0.87735849056603787,0.70909090909090911,0.76363636363636378,0.90740740740740744,0.8807339449541286,0.98165137614678899,0.42592592592592593,0.77064220183486243,0.7736753177351442,0.67013167013167008]

{"sheet":"APL_1_SAT","index":10,"n_rows":14,"n_cols":25,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["ID_Segmento","Segmento","Data",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,"ISQP","IS$P"]
[2900,"Mercado","2022-03-03"]
[50340,"Todos os Franqueados","2022-03-03",0.65882352941176459,0.35502958579881655,0.72941176470588232,0.7192982456140351,0.64327485380116955,0.69230769230769229,0.70348837209302328,0.57558139534883723,0.7777777777777779,0.56395348837209303,0.46242774566473988,0.70930232558139539,0.8928571428571429,0.76878612716763006,0.73837209302325579,0.81976744186046513,0.87283236994219648,0.86705202312138718,0.45664739884393063,0.69411764705882351,0.7160102045160861,0.65047139379966967]
[50341,"Franqueados da Região Norte","2022-03-03",0.88888888888888884,0.55555555555555558,0.88888888888888884,0.7777777777777779,0.55555555555555558,0.75,0.7777777777777779,0.55555555555555558,0.75,0.44444444444444442,0.33333333333333326,0.75,1,0.88888888888888884,0.88888888888888884,0.7777777777777779,0.88888888888888884,1,0.44444444444444442,1,0.81497860281443313,0.88888888888888884]
[50342,"Franqueados da Região Nordeste","2022-03-03",0.8,0.32,0.91666666666666652,0.88,0.68,0.72,0.72,0.68,0.8,0.28000000000000003,0.32,0.32,0.77272727272727271,0.64,0.76,0.88,0.92,0.88,0.48,0.76,0.71463556886044188,0.65898068343037008]
[50343,"Franqueados da Região Centro-oeste","2022-03-03",0.70588235294117652,0.5625,0.76470588235294112,0.88235294117647056,0.82352941176470584,0.70588235294117652,0.76470588235294112,0.52941176470588236,0.88235294117647056,0.70588235294117652,0.58823529411764708,0.64705882352941169,1,0.76470588235294112,0.88235294117647056,0.82352941176470584,0.88235294117647056,0.88235294117647056,0.58823529411764708,0.70588235294117652,0.80507590736897827,0.61714739383841677]
[50344,"Franqueados da Região Sudeste","2022-03-03",0.58510638297872342,0.2978723404255319,0.6947368421052631,0.66315789473684206,0.67368421052631577,0.69892473118279563,0.67368421052631577,0.56842105263157894,0.8,0.625,0.48958333333333326,0.79166666666666652,0.90625,0.80208333333333348,0.72631578947368425,0.83157894736842108,0.86458333333333348,0.88541666666666652,0.44791666666666674,0.66315789473684206,0.69934414101736087,0.6203373217055228]
[50345,"Franqueados da Região Sul","2022-03-03",0.68,0.4,0.6,0.64,0.4,0.61538461538461542,0.73076923076923062,0.53846153846153844,0.61538461538461542,0.56000000000000005,0.46153846153846151,0.80769230769230771,0.84615384615384615,0.73076923076923062,0.61538461538461542,0.73076923076923062,0.84615384615384615,0.73076923076923062,0.38461538461538469,0.64,0.68360619892970997,0.69165428425023723]
[50346,"Franqueados de Porte A","2022-03-03",0.45454545454545453,9.0909090909090912E-2,0.63636363636363635,0.45454545454545453,0.72727272727272729,0.63636363636363635,0.90909090909090906,0.45454545454545453,0.45454545454545453,0.54545454545454541,0.45454545454545453,0.72727272727272729,0.81818181818181823,0.36363636363636365,0.54545454545454541,0.72727272727272729,0.72727272727272729,0.81818181818181823,0.36363636363636365,0.63636363636363635,0.63112551510948578,0.36209194459146971]
[50347,"Franqueados de Porte B","2022-03-03",0.6,0.33333333333333326,0.6,0.8,0.6333333333333333,0.56666666666666665,0.66666666666666652,0.53333333333333333,0.7,0.6333333333333333,0.46666666666666662,0.7,0.8571428571428571,0.76666666666666672,0.6333333333333333,0.76666666666666672,0.9,0.8,0.46666666666666662,0.53333333333333333,0.66441317421948809,0.49794965057833052]
[50348,"Franqueados de Porte C","2022-03-03",0.68992248062015504,0.3828125,0.76744186046511631,0.72307692307692306,0.63846153846153841,0.7265625,0.69465648854961837,0.59541984732824427,0.82307692307692304,0.54961832061068705,0.4621212121212121,0.70992366412213737,0.90697674418604646,0.80303030303030298,0.77862595419847325,0.83969465648854968,0.87878787878787878,0.88636363636363635,0.4621212121212121,0.73643410852713176,0.73470085987929179,0.70801157936564718]
[50349,"Franqueados A da Região Sudeste","2022-03-03",0.25,0,0.75,0.5,0.625,0.625,1,0.5,0.5,0.625,0.5,0.875,0.875,0.5,0.75,1,0.75,0.875,0.5,0.75,0.69428657596633836,0.49787642381327096]
[50350,"Franqueados B da Região Sudeste","2022-03-03",0.54545454545454541,0.18181818181818182,0.63636363636363635,0.72727272727272729,0.5,0.54545454545454541,0.63636363636363635,0.5,0.81818181818181823,0.59090909090909094,0.45454545454545453,0.68181818181818177,0.90909090909090906,0.81818181818181823,0.59090909090909094,0.72727272727272729,0.86363636363636365,0.77272727272727271,0.59090909090909094,0.63636363636363635,0.66688283176432694,0.52219156100058728]
[50351,"Franqueados C da Região Sudeste","2022-03-03",0.66981132075471694,0.31428571428571428,0.79047619047619055,0.69811320754716977,0.59433962264150941,0.79807692307692302,0.69158878504672894,0.59813084112149528,0.87735849056603787,0.57009345794392519,0.49074074074074076,0.73831775700934577,0.90476190476190477,0.86111111111111116,0.80555555555555558,0.86915887850467288,0.88888888888888884,0.90740740740740744,0.45370370370370372,0.76190476190476186,0.74868108291199631,0.74026883492146756]

{"sheet":"APL_3_INSAT","index":11,"n_rows":14,"n_cols":25,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["ID_Segmento","Segmento","Data",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,"IIQP","II$P"]
[2900,"Mercado","2024-03-07",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5.8000000000000003E-2,9.1999999999999998E-2]
[50340,"Todos os Franqueados","2024-03-07",0.13100436681222707,0.26315789473684209,8.3700440528634359E-2,0.14410480349344978,0.18777292576419213,0.25877192982456143,9.1703056768558971E-2,0.13157894736842105,0.13100436681222707,0.20614035087719298,0.24017467248908297,6.5502183406113537E-2,0.17857142857142858,0.27753303964757708,0.19642857142857142,9.1703056768558971E-2,8.3333333333333315E-2,3.5087719298245612E-2,0.22368421052631579,6.637168141592921E-2,0.13858205628778347,0.27787949323656774]
[50341,"Franqueados da Região Norte","2024-03-07",0.17647058823529413,0.35294117647058826,5.8823529411764698E-2,0.17647058823529413,0.17647058823529413,0.17647058823529413,5.8823529411764698E-2,0.1176470588235294,0.17647058823529413,0.29411764705882354,0.35294117647058826,0.17647058823529413,0.1875,0.35294117647058826,0.23529411764705879,5.8823529411764698E-2,0,0,0.1176470588235294,5.8823529411764698E-2,0.1554187960673839,0.28165960919115046]
[50342,"Franqueados da Região Nordeste","2024-03-07",9.7560975609756101E-2,0.12195121951219512,4.878048780487805E-2,9.7560975609756101E-2,7.3170731707317069E-2,0.24390243902439024,2.4390243902439025E-2,2.4390243902439025E-2,0.17073170731707318,9.7560975609756101E-2,0.14634146341463414,7.3170731707317069E-2,7.6923076923076927E-2,0.27500000000000002,0.2,7.4999999999999997E-2,5.128205128205128E-2,0,0.23076923076923075,0.10256410256410256,0.12762261203640743,0.25674634600299517]
[50343,"Franqueados da Região Centro-oeste","2024-03-07",0.21052631578947367,0.26315789473684209,0.15789473684210525,0.21052631578947367,0.26315789473684209,0.26315789473684209,0.15789473684210525,0.21052631578947367,0.15789473684210525,0.15789473684210525,0.26315789473684209,0,0,0.21052631578947367,0.26315789473684209,0,0.1111111111111111,5.2631578947368418E-2,0.27777777777777779,0.1111111111111111,0.14030923293509912,0.29870552610936185]
[50344,"Franqueados da Região Sudeste","2024-03-07",9.4827586206896547E-2,0.23478260869565218,5.2631578947368418E-2,0.13793103448275862,0.18103448275862066,0.29565217391304349,8.6206896551724144E-2,0.13043478260869565,9.4827586206896547E-2,0.20689655172413793,0.23931623931623933,4.3103448275862072E-2,0.20689655172413793,0.23478260869565218,0.13392857142857142,0.11206896551724138,9.4017094017094016E-2,4.3103448275862072E-2,0.22222222222222221,6.0869565217391307E-2,0.12773430832551239,0.25339848379924107]
[50345,"Franqueados da Região Sul","2024-03-07",0.22222222222222221,0.47222222222222221,0.19444444444444448,0.16666666666666663,0.30555555555555558,0.19444444444444448,0.16666666666666663,0.22222222222222221,0.16666666666666663,0.31428571428571428,0.2857142857142857,0.1111111111111111,0.2857142857142857,0.41666666666666674,0.33333333333333326,0.1081081081081081,0.1081081081081081,5.405405405405405E-2,0.24324324324324326,2.7027027027027025E-2,0.18312244808544023,0.36539624976149249]
[50346,"Franqueados de Porte A","2024-03-07",0.14285714285714285,0.14285714285714285,7.1428571428571425E-2,0.21428571428571427,7.1428571428571425E-2,0.21428571428571427,0.14285714285714285,0.14285714285714285,0.14285714285714285,0.14285714285714285,0.42857142857142855,0,0.23076923076923075,0.14285714285714285,0,0,0.15384615384615385,7.1428571428571425E-2,0.15384615384615385,7.6923076923076927E-2,0.12129915364261346,0.26160117417578527]
[50347,"Franqueados de Porte B","2024-03-07",0.21052631578947367,0.27027027027027029,0.13157894736842105,0.23684210526315788,0.18421052631578946,0.31578947368421051,0.10526315789473684,8.1081081081081086E-2,0.13157894736842105,0.15384615384615385,0.25641025641025639,2.6315789473684209E-2,0.21052631578947367,0.44736842105263158,0.28205128205128205,0.15384615384615385,0.15789473684210525,7.6923076923076927E-2,0.23076923076923075,0.13157894736842105,0.17935879094944998,0.34665798054295444]
[50348,"Franqueados de Porte C","2024-03-07",0.11299435028248589,0.2711864406779661,7.4285714285714288E-2,0.11864406779661017,0.19774011299435026,0.25,8.4745762711864389E-2,0.14124293785310735,0.12994350282485875,0.22285714285714284,0.22159090909090909,7.909604519774012E-2,0.16763005780346821,0.25142857142857145,0.19298245614035087,8.5227272727272721E-2,6.2146892655367235E-2,2.2857142857142857E-2,0.22727272727272727,5.1428571428571421E-2,0.13142276796898109,0.26383735824396876]
[50349,"Franqueados A da Região Sudeste","2024-03-07",0.33333333333333326,0.33333333333333326,0.16666666666666663,0.5,0,0.33333333333333326,0.16666666666666663,0.16666666666666663,0.16666666666666663,0,0.33333333333333326,0,0.2,0,0,0,0.33333333333333326,0.16666666666666663,0.16666666666666663,0.16666666666666663,0.13845057216974563,0.5]
[50350,"Franqueados B da Região Sudeste","2024-03-07",0.31818181818181818,0.36363636363636365,0.13636363636363635,0.27272727272727271,0.22727272727272727,0.31818181818181818,0.13636363636363635,0.13636363636363635,0.13636363636363635,0.21739130434782608,0.2608695652173913,4.5454545454545456E-2,0.13043478260869565,0.5,0.34782608695652173,0.17391304347826086,0.17391304347826086,8.6956521739130432E-2,0.17391304347826086,0.13636363636363635,0.18609705488813738,0.32694179309457488]
[50351,"Franqueados C da Região Sudeste","2024-03-07",9.9290780141843976E-2,0.29078014184397161,5.7553956834532377E-2,0.1276595744680851,0.24113475177304963,0.22857142857142856,8.5106382978723402E-2,0.14184397163120568,0.12056737588652482,0.23741007194244601,0.22142857142857142,6.3829787234042548E-2,0.13868613138686131,0.22857142857142856,0.19117647058823528,7.857142857142857E-2,4.9645390070921988E-2,1.4285714285714285E-2,0.21428571428571427,4.3165467625899276E-2,0.12604452955457573,0.24747405623328494]

{"sheet":"APL_2_INSAT","index":12,"n_rows":14,"n_cols":25,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["ID_Segmento","Segmento","Data",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,"IIQP","II$P"]
[2900,"Mercado","2023-03-02"]
[50340,"Todos os Franqueados","2023-03-02",0.11458333333333331,0.19791666666666663,6.25E-2,0.10880829015544041,0.11979166666666669,0.13612565445026178,4.2105263157894736E-2,0.1099476439790576,0.15789473684210525,0.15625,0.19047619047619047,6.2176165803108807E-2,4.3715846994535526E-2,0.18421052631578946,0.10052910052910052,4.2328042328042326E-2,5.7894736842105263E-2,2.1052631578947368E-2,0.38095238095238093,0.15789473684210525,0.13886939016304622,0.20852788435042499]
[50341,"Franqueados da Região Norte","2023-03-02",8.3333333333333315E-2,0.16666666666666663,0,0,0,8.3333333333333315E-2,0,8.3333333333333315E-2,0.33333333333333326,0,0.33333333333333326,0.16666666666666663,0,8.3333333333333315E-2,8.3333333333333315E-2,8.3333333333333315E-2,0,0,0,0.16666666666666663,0.11956450556647026,8.7296037296037299E-2]
[50342,"Franqueados da Região Nordeste","2023-03-02",7.6923076923076927E-2,7.6923076923076927E-2,0,0.15384615384615385,0.11538461538461538,0.2,0,0.16,0.4,0.11538461538461538,0.16,7.6923076923076927E-2,5.5555555555555552E-2,0.12,0.2,4.1666666666666657E-2,0.04,0.04,0.41666666666666674,0.11538461538461538,0.14819795198010349,0.17573964497041419]
[50343,"Franqueados da Região Centro-oeste","2023-03-02",0.1,0.15,0.05,0.05,0.1,0.1,0,0.05,0.10526315789473684,0.1,0.15789473684210525,0.05,5.2631578947368418E-2,0.10526315789473684,0.1,0.1,0.05,0,0.35,0.15789473684210525,0.11007831149078179,0.17615384615384616]
[50344,"Franqueados da Região Sudeste","2023-03-02",0.13861386138613863,0.21782178217821785,7.9207920792079209E-2,0.1176470588235294,0.10891089108910892,0.12871287128712872,0.05,0.10891089108910892,6.9306930693069313E-2,0.22549019607843138,0.18,4.9019607843137261E-2,3.9215686274509803E-2,0.21568627450980393,0.08,9.9009900990099011E-3,5.9405940594059403E-2,9.9009900990099011E-3,0.4356435643564357,0.15841584158415842,0.14490642370396728,0.24132730015082957]
[50345,"Franqueados da Região Sul","2023-03-02",9.0909090909090912E-2,0.27272727272727271,9.0909090909090912E-2,0.12121212121212122,0.2121212121212121,0.15151515151515152,9.0909090909090912E-2,0.12121212121212122,0.2121212121212121,6.25E-2,0.2121212121212121,6.0606060606060608E-2,6.25E-2,0.21875,9.375E-2,9.375E-2,9.375E-2,6.25E-2,0.34375,0.1875,0.14091095952234181,0.19354838709677419]
[50346,"Franqueados de Porte A","2023-03-02",0.2,0.2,7.1428571428571425E-2,0.1875,0,6.25E-2,0,6.25E-2,6.25E-2,6.25E-2,0.13333333333333333,0,0,0.125,6.25E-2,0,6.25E-2,0,0.4375,0.1875,0.12293979432486311,0.34519230769230769]
[50347,"Franqueados de Porte B","2023-03-02",0.19047619047619047,0.30952380952380953,0.16666666666666663,0.21428571428571427,9.7560975609756101E-2,0.2857142857142857,4.7619047619047616E-2,9.5238095238095233E-2,0.26190476190476192,0.1951219512195122,0.2,0,7.8947368421052627E-2,0.31707317073170732,0.17948717948717949,4.878048780487805E-2,9.7560975609756101E-2,4.878048780487805E-2,0.4390243902439025,0.26829268292682928,0.19425742545326583,0.26538461538461539]
[50348,"Franqueados de Porte C","2023-03-02",8.1481481481481488E-2,0.16296296296296298,2.9411764705882349E-2,6.6666666666666666E-2,0.13970588235294118,9.7744360902255634E-2,4.5112781954887209E-2,0.12030075187969924,0.13636363636363635,0.15555555555555556,0.19402985074626866,8.8235294117647065E-2,3.875968992248062E-2,0.15037593984962405,8.2089552238805971E-2,4.5454545454545456E-2,4.5112781954887209E-2,1.5037593984962405E-2,0.35606060606060608,0.12030075187969924,0.12474365284864536,0.17530977590679087]
[50349,"Franqueados A da Região Sudeste","2023-03-02",0.2,0.2,0,0.33333333333333326,0,0,0,0.16666666666666663,0,0.16666666666666663,0.4,0,0,0,0,0,0.16666666666666663,0,0.33333333333333326,0.33333333333333326,0.11894439856867609,0.5871794871794872]
[50350,"Franqueados B da Região Sudeste","2023-03-02",0.23076923076923075,0.42307692307692307,0.19230769230769235,0.30769230769230771,0.16,0.34615384615384615,3.8461538461538464E-2,7.6923076923076927E-2,0.15384615384615385,0.16,0.25,0,0.125,0.28000000000000003,0.16666666666666663,0.08,0.12,0.04,0.32,0.28000000000000003,0.19876855136210178,0.29551282051282057]
[50351,"Franqueados C da Região Sudeste","2023-03-02",8.1081081081081086E-2,0.16964285714285715,8.9285714285714281E-3,6.3063063063063057E-2,0.15178571428571427,5.5045871559633038E-2,3.669724770642202E-2,0.10091743119266056,0.11926605504587157,0.17117117117117117,0.19090909090909094,7.1428571428571425E-2,2.8301886792452834E-2,0.10909090909090909,6.363636363636363E-2,1.8518518518518517E-2,3.669724770642202E-2,9.1743119266055051E-3,0.29629629629629628,6.4220183486238536E-2,9.2770719830832904E-2,0.12224532224532224]

{"sheet":"APL_1_INSAT","index":13,"n_rows":14,"n_cols":25,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["ID_Segmento","Segmento","Data",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,"IIQP","II$P"]
[2900,"Mercado","2022-03-03"]
[50340,"Todos os Franqueados","2022-03-03",0.14117647058823529,0.33136094674556221,7.0588235294117646E-2,0.10526315789473684,0.16374269005847952,0.12426035502958581,0.15697674418604651,0.19186046511627908,8.1871345029239762E-2,0.22093023255813954,0.2947976878612717,0.13372093023255813,2.3809523809523808E-2,7.5144508670520235E-2,6.9767441860465115E-2,5.232558139534884E-2,4.0462427745664747E-2,2.3121387283236993E-2,0.27167630057803466,0.12352941176470589,0.11771508353177197,0.14278755891411873]
[50341,"Franqueados da Região Norte","2022-03-03",0.1111111111111111,0.22222222222222221,0.1111111111111111,0.1111111111111111,0.1111111111111111,0,0,0.1111111111111111,0,0.1111111111111111,0.22222222222222221,0.125,0,0,0,0.1111111111111111,0,0,0.22222222222222221,0,5.0730479601495196E-2,0]
[50342,"Franqueados da Região Nordeste","2022-03-03",0.08,0.28000000000000003,8.3333333333333315E-2,0.04,0.12,0,0.2,0.2,0.08,0.32,0.32,0.32,4.5454545454545456E-2,0.16,0.08,0.04,0,0.04,0.24,0.04,0.11381144042851413,0.12067954437975333]
[50343,"Franqueados da Região Centro-oeste","2022-03-03",0.1176470588235294,0.3125,5.8823529411764698E-2,5.8823529411764698E-2,5.8823529411764698E-2,0.29411764705882354,0.1176470588235294,0.17647058823529413,0,0.23529411764705879,0.17647058823529413,0.1176470588235294,0,5.8823529411764698E-2,0,5.8823529411764698E-2,5.8823529411764698E-2,5.8823529411764698E-2,0.23529411764705879,0.1176470588235294,8.2987397841292443E-2,8.8734959102759789E-2]
[50344,"Franqueados da Região Sudeste","2022-03-03",0.1702127659574468,0.36170212765957449,4.2105263157894736E-2,0.1368421052631579,0.15789473684210525,0.12903225806451613,0.15789473684210525,0.17894736842105263,0.10526315789473684,0.17708333333333337,0.29166666666666669,0.10416666666666669,2.0833333333333329E-2,7.2916666666666671E-2,6.3157894736842107E-2,5.2631578947368418E-2,4.1666666666666657E-2,2.0833333333333329E-2,0.28125,0.1368421052631579,0.12720481528226629,0.18447876751832368]
[50345,"Franqueados da Região Sul","2022-03-03",0.12,0.32,0.16,0.08,0.32,0.15384615384615385,0.19230769230769235,0.26923076923076922,7.6923076923076927E-2,0.32,0.38461538461538469,7.6923076923076927E-2,3.8461538461538464E-2,3.8461538461538464E-2,0.15384615384615385,3.8461538461538464E-2,7.6923076923076927E-2,0,0.30769230769230771,0.2,0.13294791418055124,9.6480550182573732E-2]
[50346,"Franqueados de Porte A","2022-03-03",0.18181818181818182,0.45454545454545453,0,0.36363636363636365,9.0909090909090912E-2,0.18181818181818182,0,9.0909090909090912E-2,0.36363636363636365,0.18181818181818182,0.18181818181818182,0,0,0.18181818181818182,9.0909090909090912E-2,0,9.0909090909090912E-2,0,0.27272727272727271,9.0909090909090912E-2,0.15035772809265219,0.31895402770426512]
[50347,"Franqueados de Porte B","2022-03-03",0.13333333333333333,0.36666666666666664,0.13333333333333333,3.3333333333333333E-2,0.13333333333333333,0.1,0.1,0.1,6.6666666666666666E-2,0.13333333333333333,0.2,3.3333333333333333E-2,3.5714285714285712E-2,6.6666666666666666E-2,3.3333333333333333E-2,6.6666666666666666E-2,3.3333333333333333E-2,0,0.33333333333333326,0.16666666666666663,0.1178308875057086,0.2419651244653046]
[50348,"Franqueados de Porte C","2022-03-03",0.13953488372093023,0.3125,6.2015503875968998E-2,0.1,0.17692307692307693,0.125,0.18320610687022898,0.22137404580152673,6.1538461538461542E-2,0.24427480916030533,0.3257575757575758,0.16793893129770993,2.3255813953488372E-2,6.8181818181818177E-2,7.6335877862595422E-2,5.3435114503816793E-2,3.787878787878788E-2,3.0303030303030304E-2,0.25757575757575757,0.11627906976744186,0.11530322824913408,0.10631800923475505]
[50349,"Franqueados A da Região Sudeste","2022-03-03",0.25,0.625,0,0.375,0.125,0.125,0,0.125,0.375,0.25,0.25,0,0,0.125,0,0,0.125,0,0.25,0.125,0.12698731437810018,0.3135617880933646]
[50350,"Franqueados B da Região Sudeste","2022-03-03",9.0909090909090912E-2,0.40909090909090912,9.0909090909090912E-2,4.5454545454545456E-2,0.18181818181818182,0.13636363636363635,9.0909090909090912E-2,0.13636363636363635,0,0.18181818181818182,0.27272727272727271,4.5454545454545456E-2,4.5454545454545456E-2,4.5454545454545456E-2,4.5454545454545456E-2,4.5454545454545456E-2,4.5454545454545456E-2,0,0.22727272727272727,9.0909090909090912E-2,0.1026063339178447,0.28652326711875387]
[50351,"Franqueados C da Região Sudeste","2022-03-03",0.15094339622641509,0.35238095238095241,5.7142857142857141E-2,9.4339622641509441E-2,0.20754716981132076,8.6538461538461536E-2,0.18691588785046728,0.22429906542056074,2.8301886792452834E-2,0.26168224299065418,0.32407407407407407,0.14953271028037382,1.9047619047619049E-2,4.6296296296296301E-2,7.407407407407407E-2,4.6728971962616821E-2,2.7777777777777776E-2,2.7777777777777776E-2,0.25925925925925924,8.5714285714285715E-2,0.10822344732344255,7.4388677953589499E-2]

{"sheet":"APL_3_FIDEL","index":14,"n_rows":16,"n_cols":24,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["ID_Segmento","Segmento","Data","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha"]
["-","-","-","Satisfação geral","Satisfação geral","Satisfação geral","Satisfação geral","Satisfação geral","Abriria outra loja da marca","Abriria outra loja da marca","Abriria outra loja da marca","Abriria outra loja da marca","Abriria outra loja da marca","Recomendaria a franquia","Recomendaria a franquia","Recomendaria a franquia","Recomendaria a franquia","Recomendaria a franquia","Fidelidade","Fidelidade","Fidelidade","Fidelidade","Fidelidade","IFC"]
["-","-","-","Muito satisfeito","Satisfeito","Nem satisfeito nem insatisfeito","Insatisfeito","Muito insatisfeito","Definitivamente sim","Provavalmente sim","Talvez sim talvez não","Provavelmente não","Definitivamente não","Definitivamente sim","Provavalmente sim","Talvez sim talvez não","Provavelmente não","Definitivamente não","Clientes Prime","Clientes Favoráveis","Clientes Vulneráveis","Clientes Insatisfeitos","Clientes de Alto Risco","IFC"]
[2900,"Mercado","2024-03-07",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.85]
[50340,"Todos os Franqueados","2024-03-07",0.18502202643171806,0.4933920704845815,0.1762114537444934,0.1277533039647577,1.7621145374449341E-2,0.22666666666666666,0.32,0.23555555555555555,0.17333333333333337,4.4444444444444446E-2,0.3125,0.38839285714285715,0.14285714285714285,0.11607142857142858,4.0178571428571432E-2,0.22421524663677134,0.43946188340807174,0.19282511210762332,0.11210762331838567,3.1390134529147982E-2,0.52017937219730936]
[50341,"Franqueados da Região Norte","2024-03-07",0.25,0.4375,1.0000000000000001E-5,0.3125,1.0000000000000001E-5,0.1875,0.4375,6.25E-2,0.3125,1.0000000000000001E-5,0.375,0.25,0.25,0.125,1.0000000000000001E-5,0.25,0.375,0.125,0.25,0,0.375]
[50342,"Franqueados da Região Nordeste","2024-03-07",0.20512820512820512,0.53846153846153844,7.6923076923076927E-2,0.12820512820512819,5.128205128205128E-2,0.27027027027027029,0.2162162162162162,0.2162162162162162,0.24324324324324326,5.405405405405405E-2,0.34210526315789475,0.44736842105263158,7.8947368421052627E-2,7.8947368421052627E-2,5.2631578947368418E-2,0.27027027027027029,0.4324324324324324,0.13513513513513514,0.1081081081081081,5.405405405405405E-2,0.54054054054054057]
[50343,"Franqueados da Região Centro-oeste","2024-03-07",0.16666666666666663,0.61111111111111116,5.5555555555555552E-2,0.16666666666666663,1.0000000000000001E-5,0.33333333333333326,0.38888888888888895,0.22222222222222221,5.5555555555555552E-2,1.0000000000000001E-5,0.38888888888888895,0.33333333333333326,0.22222222222222221,5.5555555555555552E-2,1.0000000000000001E-5,0.27777777777777779,0.44444444444444442,0.22222222222222221,5.5555555555555552E-2,0,0.66666666666666674]
[50344,"Franqueados da Região Sudeste","2024-03-07",0.22222222222222221,0.46153846153846151,0.23076923076923075,8.5470085470085472E-2,1.0000000000000001E-5,0.25641025641025639,0.31623931623931623,0.23931623931623933,0.15384615384615385,3.4188034188034191E-2,0.31304347826086959,0.41739130434782612,0.12173913043478261,0.12173913043478261,2.6086956521739132E-2,0.25217391304347825,0.45217391304347826,0.19130434782608696,9.5652173913043481E-2,8.6956521739130436E-3,0.6]
[50345,"Franqueados da Região Sul","2024-03-07",2.7027027027027025E-2,0.51351351351351349,0.24324324324324326,0.16216216216216217,5.405405405405405E-2,5.405405405405405E-2,0.35135135135135137,0.32432432432432434,0.16216216216216217,0.1081081081081081,0.2162162162162162,0.32432432432432434,0.1891891891891892,0.16216216216216217,0.1081081081081081,5.405405405405405E-2,0.4324324324324324,0.27027027027027029,0.13513513513513514,0.1081081081081081,0.24324324324324323]
[50346,"Franqueados de Porte A","2024-03-07",0.21428571428571427,0.35714285714285715,0.2857142857142857,0.14285714285714285,1.0000000000000001E-5,0.21428571428571427,0.2857142857142857,0.21428571428571427,0.2857142857142857,1.0000000000000001E-5,0.35714285714285715,0.14285714285714285,0.14285714285714285,0.35714285714285715,1.0000000000000001E-5,0.2857142857142857,0.21428571428571427,0.35714285714285715,0.14285714285714285,0,0.35714285714285715]
[50347,"Franqueados de Porte B","2024-03-07",7.8947368421052627E-2,0.47368421052631576,0.26315789473684209,0.18421052631578946,1.0000000000000001E-5,5.2631578947368418E-2,0.28947368421052633,0.36842105263157893,0.26315789473684209,2.6315789473684209E-2,0.13513513513513514,0.4324324324324324,0.27027027027027029,0.1081081081081081,5.405405405405405E-2,8.1081081081081086E-2,0.4324324324324324,0.32432432432432434,0.13513513513513514,2.7027027027027025E-2,0.35135135135135137]
[50348,"Franqueados de Porte C","2024-03-07",0.20571428571428568,0.50857142857142856,0.14857142857142858,0.11428571428571428,2.2857142857142857E-2,0.26589595375722541,0.32947976878612711,0.20809248554913296,0.14450867052023122,5.2023121387283239E-2,0.34682080924855491,0.39884393063583817,0.11560693641618497,9.8265895953757218E-2,4.0462427745664747E-2,0.25,0.45930232558139539,0.15116279069767441,0.10465116279069768,3.4883720930232558E-2,0.56976744186046513]
[50349,"Franqueados A da Região Sudeste","2024-03-07",0.16666666666666663,0.16666666666666663,0.33333333333333326,0.33333333333333326,1.0000000000000001E-5,0.16666666666666663,0.16666666666666663,0.16666666666666663,0.5,1.0000000000000001E-5,0.33333333333333326,0,0.16666666666666663,0.5,1.0000000000000001E-5,0.16666666666666663,0.16666666666666663,0.33333333333333326,0.33333333333333326,0,0]
[50350,"Franqueados B da Região Sudeste","2024-03-07",0.13043478260869565,0.34782608695652173,0.30434782608695654,0.21739130434782608,1.0000000000000001E-5,8.6956521739130432E-2,0.34782608695652173,0.39130434782608697,0.13043478260869565,4.3478260869565216E-2,0.18181818181818182,0.40909090909090912,0.22727272727272727,9.0909090909090912E-2,9.0909090909090912E-2,0.13636363636363635,0.45454545454545453,0.22727272727272727,0.13636363636363635,4.5454545454545456E-2,0.40909090909090906]
[50351,"Franqueados C da Região Sudeste","2024-03-07",0.20714285714285716,0.55000000000000004,0.12142857142857143,0.10714285714285714,1.4285714285714285E-2,0.29710144927536231,0.36231884057971014,0.16666666666666663,0.13768115942028986,3.6231884057971016E-2,0.38405797101449274,0.40579710144927539,0.10869565217391304,7.9710144927536225E-2,2.1739130434782608E-2,0.28467153284671531,0.4598540145985402,0.13138686131386862,0.10218978102189782,2.1897810218978103E-2,0.62043795620437947]

{"sheet":"APL_2_FIDEL","index":15,"n_rows":16,"n_cols":24,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["ID_Segmento","Segmento","Data","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha"]
["-","-","-","Satisfação geral","Satisfação geral","Satisfação geral","Satisfação geral","Satisfação geral","Abriria outra loja da marca","Abriria outra loja da marca","Abriria outra loja da marca","Abriria outra loja da marca","Abriria outra loja da marca","Recomendaria a franquia","Recomendaria a franquia","Recomendaria a franquia","Recomendaria a franquia","Recomendaria a franquia","Fidelidade","Fidelidade","Fidelidade","Fidelidade","Fidelidade","IFC"]
["-","-","-","Muito satisfeito","Satisfeito","Nem satisfeito,\nnem insatisfeito","Inatisfeito","Muito insatisfeito","Definitivamente sim","Provavelmente sim","Talvez sim,\ntalvez não","Provavelmente não","Definitvamente não","Definitivamente sim","Provavelmente sim","Talvez sim,\ntalvez não","Provavelmente não","Definitvamente não","Clientes Primes","Clientes Favoráveis","Clientes Vulneráveis","Clientes Insatisfeitos","Clientes Alto Risco","IFC"]
[2900,"Mercado","2023-03-02",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.85]
[50340,"Todos os Franqueados","2023-03-02",0.28947368421052633,0.49473684210526314,0.16842105263157894,4.7368421052631587E-2,0,0.35789473684210527,0.31052631578947371,0.20526315789473684,7.8947368421052627E-2,4.7368421052631587E-2,0.41489361702127658,0.34042553191489361,0.1702127659574468,5.8510638297872342E-2,1.5957446808510637E-2,0.33689839572192509,0.39037433155080214,0.19786096256684493,7.4866310160427801E-2,0,{"$f":"+S5+T5-V5-W5","v":0.65240641711229952}]
[50341,"Franqueados da Região Norte","2023-03-02",0.66666666666666652,0.25,8.3333333333333315E-2,0,0,0.75,0.16666666666666663,0,0,8.3333333333333315E-2,0.75,0.16666666666666663,0,0,8.3333333333333315E-2,0.75,0.16666666666666663,0,8.3333333333333315E-2,0,{"$f":"+S6+T6-V6-W6","v":0.83333333333333326}]
[50342,"Franqueados da Região Nordeste","2023-03-02",0.26923076923076922,0.53846153846153844,0.19230769230769235,0,0,0.30769230769230771,0.38461538461538469,0.19230769230769235,0.11538461538461538,0,0.4,0.44,0.08,0.08,0,0.28000000000000003,0.52,0.16,0.04,0,0.76]
[50343,"Franqueados da Região Centro-oeste","2023-03-02",0.45,0.4,0,0.15,0,0.45,0.35,0.1,0.1,0,0.45,0.3,0.15,0.05,0.05,0.4,0.4,0.05,0.15,0,0.65]
[50344,"Franqueados da Região Sudeste","2023-03-02",0.25,0.51,0.19,0.05,0,0.3,0.28999999999999998,0.25,0.09,7.0000000000000007E-2,0.37373737373737376,0.32323232323232326,0.22222222222222221,8.0808080808080815E-2,0,0.29591836734693877,0.37755102040816324,0.24489795918367346,8.1632653061224497E-2,0,0.59183673469387754]
[50345,"Franqueados da Região Sul","2023-03-02",0.1875,0.5625,0.21875,3.125E-2,0,0.375,0.34375,0.21875,3.125E-2,3.125E-2,0.40625,0.40625,0.15625,0,3.125E-2,0.3125,0.40625,0.25,3.125E-2,0,0.6875]
[50346,"Franqueados de Porte A","2023-03-02",0.125,0.5625,0.125,0.1875,0,0.3125,0.25,0.125,0.25,6.25E-2,0.375,0.3125,6.25E-2,0.25,0,0.25,0.375,0.125,0.25,0,0.375]
[50347,"Franqueados de Porte B","2023-03-02",0.25,0.42499999999999999,0.2,0.125,0,0.26829268292682928,0.24390243902439024,0.29268292682926828,0.12195121951219512,7.3170731707317069E-2,0.3902439024390244,0.24390243902439024,0.31707317073170732,4.878048780487805E-2,0,0.27500000000000002,0.32500000000000001,0.3,0.1,0,0.50000000000000011]
[50348,"Franqueados de Porte C","2023-03-02",0.32089552238805974,0.5074626865671642,0.16417910447761194,7.4626865671641781E-3,0,0.39097744360902253,0.33834586466165412,0.18796992481203006,4.5112781954887209E-2,3.7593984962406013E-2,0.42748091603053434,0.37404580152671757,0.13740458015267176,3.8167938931297711E-2,2.2900763358778622E-2,0.36641221374045796,0.41221374045801523,0.17557251908396945,4.5801526717557245E-2,0,0.73282442748091603]
[50349,"Franqueados A da Região Sudeste","2023-03-02",0,0.5,0.16666666666666663,0.33333333333333326,0,0.16666666666666663,0.33333333333333326,0.16666666666666663,0.16666666666666663,0.16666666666666663,0.33333333333333326,0.16666666666666663,0,0.5,0,0,0.5,0,0.5,0,0]
[50350,"Franqueados B da Região Sudeste","2023-03-02",0.16,0.44,0.28000000000000003,0.12,0,0.28000000000000003,0.24,0.32,0.12,0.04,0.44,0.24,0.28000000000000003,0.04,0,0.24,0.36,0.28000000000000003,0.12,0,0.48]
[50351,"Franqueados C da Região Sudeste","2023-03-02",0.35454545454545455,0.52727272727272723,0.10909090909090909,9.0909090909090905E-3,0,0.4311926605504588,0.33944954128440374,0.16513761467889909,3.669724770642202E-2,2.7522935779816519E-2,0.47663551401869159,0.3644859813084112,0.11214953271028037,2.8037383177570093E-2,1.8691588785046728E-2,0.41121495327102797,0.41121495327102797,0.14953271028037382,2.8037383177570093E-2,0,0.79439252336448585]

{"sheet":"APL_1_FIDEL","index":16,"n_rows":16,"n_cols":24,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["ID_Segmento","Segmento","Data","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha","Rede Alpha"]
["-","-","-","Satisfação geral","Satisfação geral","Satisfação geral","Satisfação geral","Satisfação geral","Abriria outra loja da marca","Abriria outra loja da marca","Abriria outra loja da marca","Abriria outra loja da marca","Abriria outra loja da marca","Recomendaria a franquia","Recomendaria a franquia","Recomendaria a franquia","Recomendaria a franquia","Recomendaria a franquia","Fidelidade","Fidelidade","Fidelidade","Fidelidade","Fidelidade","IFC"]
["-","-","-","Muito satisfeito","Satisfeito","Nem satisfeito,\nnem insatisfeito","Inatisfeito","Muito insatisfeito","Definitivamente sim","Provavelmente sim","Talvez sim,\ntalvez não","Provavelmente não","Definitvamente não","Definitivamente sim","Provavelmente sim","Talvez sim,\ntalvez não","Provavelmente não","Definitvamente não","Clientes Primes","Clientes Favoráveis","Clientes Vulneráveis","Clientes Insatisfeitos","Clientes Alto Risco","IFC"]
[2900,"Mercado","2022-03-03",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.85]
[50340,"Todos os Franqueados","2022-03-03",0.40350877192982454,0.42690058479532161,0.12280701754385964,4.0935672514619881E-2,5.8479532163742687E-3,0.42690058479532161,0.34502923976608185,0.14035087719298245,5.2631578947368418E-2,3.5087719298245612E-2,0.52046783625730997,0.30994152046783624,0.13450292397660818,1.1695906432748537E-2,2.3391812865497075E-2,0.40350877192982454,0.42690058479532161,0.12280701754385964,4.0935672514619881E-2,5.8479532163742687E-3,0.78362573099415211]
[50341,"Franqueados da Região Norte","2022-03-03",0.44444444444444442,0.33333333333333326,0.22222222222222221,0,0,0.44444444444444442,0.33333333333333326,0.1111111111111111,0.1111111111111111,0,0.55555555555555558,0.1111111111111111,0.33333333333333326,0,0,0.44444444444444442,0.33333333333333326,0.22222222222222221,0,0,0.77777777777777768]
[50342,"Franqueados da Região Nordeste","2022-03-03",0.33333333333333326,0.58333333333333337,0,8.3333333333333315E-2,0,0.33333333333333326,0.45833333333333326,0.125,4.1666666666666657E-2,4.1666666666666657E-2,0.41666666666666674,0.41666666666666674,0.125,0,4.1666666666666657E-2,0.33333333333333326,0.58333333333333337,0,8.3333333333333315E-2,0,0.83333333333333326]
[50343,"Franqueados da Região Centro-oeste","2022-03-03",0.58823529411764708,0.23529411764705879,0.17647058823529413,0,0,0.58823529411764708,0.17647058823529413,0.23529411764705879,0,0,0.58823529411764708,0.1176470588235294,0.29411764705882354,0,0,0.58823529411764708,0.23529411764705879,0.17647058823529413,0,0,0.82352941176470584]
[50344,"Franqueados da Região Sudeste","2022-03-03",0.36842105263157893,0.44210526315789472,0.14736842105263157,3.1578947368421054E-2,1.0526315789473684E-2,0.3789473684210527,0.3789473684210527,0.1368421052631579,5.2631578947368418E-2,5.2631578947368418E-2,0.51578947368421058,0.32631578947368423,0.11578947368421053,1.0526315789473684E-2,3.1578947368421054E-2,0.36842105263157893,0.44210526315789472,0.14736842105263157,3.1578947368421054E-2,1.0526315789473684E-2,0.76842105263157889]
[50345,"Franqueados da Região Sul","2022-03-03",0.46153846153846151,0.38461538461538469,7.6923076923076927E-2,7.6923076923076927E-2,0,0.57692307692307687,0.23076923076923075,0.11538461538461538,7.6923076923076927E-2,0,0.57692307692307687,0.34615384615384615,3.8461538461538464E-2,3.8461538461538464E-2,0,0.46153846153846151,0.38461538461538469,7.6923076923076927E-2,7.6923076923076927E-2,0,0.76923076923076938]
[50346,"Franqueados de Porte A","2022-03-03",9.0909090909090912E-2,0.36363636363636365,0.45454545454545453,9.0909090909090912E-2,0,9.0909090909090912E-2,0.27272727272727271,0.27272727272727271,9.0909090909090912E-2,0.27272727272727271,0.36363636363636365,0.18181818181818182,0.36363636363636365,0,9.0909090909090912E-2,9.0909090909090912E-2,0.36363636363636365,0.45454545454545453,9.0909090909090912E-2,0,0.36363636363636365]
[50347,"Franqueados de Porte B","2022-03-03",0.16666666666666663,0.56666666666666665,0.2,6.6666666666666666E-2,0,0.2,0.5,0.23333333333333331,3.3333333333333333E-2,3.3333333333333333E-2,0.3,0.5,0.13333333333333333,3.3333333333333333E-2,3.3333333333333333E-2,0.16666666666666663,0.56666666666666665,0.2,6.6666666666666666E-2,0,0.66666666666666663]
[50348,"Franqueados de Porte C","2022-03-03",0.48461538461538461,0.4,7.6923076923076927E-2,3.0769230769230771E-2,7.6923076923076927E-3,0.50769230769230766,0.31538461538461537,0.1076923076923077,5.3846153846153849E-2,1.5384615384615385E-2,0.58461538461538465,0.27692307692307694,0.11538461538461538,7.6923076923076927E-3,1.5384615384615385E-2,0.48461538461538461,0.4,7.6923076923076927E-2,3.0769230769230771E-2,7.6923076923076927E-3,0.84615384615384615]
[50349,"Franqueados A da Região Sudeste","2022-03-03",0.125,0.5,0.375,0,0,0.125,0.375,0.25,0.125,0.125,0.5,0.125,0.375,0,0,0.125,0.5,0.375,0,0,0.625]
[50350,"Franqueados B da Região Sudeste","2022-03-03",0.22727272727272727,0.5,0.22727272727272727,4.5454545454545456E-2,0,0.27272727272727271,0.45454545454545453,0.22727272727272727,4.5454545454545456E-2,0,0.36363636363636365,0.45454545454545453,0.13636363636363635,4.5454545454545456E-2,0,0.22727272727272727,0.5,0.22727272727272727,4.5454545454545456E-2,0,0.68181818181818188]
[50351,"Franqueados C da Região Sudeste","2022-03-03",0.54716981132075471,0.3867924528301887,4.716981132075472E-2,1.8867924528301886E-2,0,0.59433962264150941,0.29245283018867924,7.5471698113207544E-2,3.7735849056603772E-2,0,0.660377358490566,0.25471698113207547,8.4905660377358499E-2,0,0,0.54716981132075471,0.3867924528301887,4.716981132075472E-2,1.8867924528301886E-2,0,0.91509433962264153]

{"sheet":"COMENTARIOS","index":17,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["AREA_DIMENSAO","COMENTARIO","CLASSIFICACAO","PORTE","REGIÃO","VISUALIZA01","VISUALIZA02"]
["Satisfação geral","Lolo lolo lolololo lo lolo lol lololo lolo lolololo lo lolo lololololo lolololo lo lolo lololo.",null,"Franqueados de Porte A","Franqueados da Região Norte",50340,50341]
["Satisfação geral","Popo popopopopo popopo",null,"Franqueados de Porte B","Franqueados da Região Nordeste",50340,50342]
["Satisfação geral","Gogo gogo gogogogo go gogo gogogo gogo gogogogo go gogo gogogo gogo gogogogo go gogo gogogo gogo gogogogo googo go gogo gogogo.",null,"Franqueados de Porte C","Franqueados da Região Centro-Oeste",50340,50343]
["Satisfação geral","Toto toto totototo to toto tototo toto totototo to toto tototo toto totototo to toto tototo toto totototo to toto tototo.",null,"Franqueados de Porte A","Franqueados da Região Sudeste",50340,50344]
["Satisfação geral","Vovo vovo vovovovo vo vovo vovovo vovo vovovovo vo vovo vovovo vovo vovovovo vo vovo vovovo vovo vovo vovo vovovo.",null,"Franqueados de Porte B","Franqueados da Região Sul",50340,50345]
["Satisfação geral","Fofo fofo fofofofo fo fofo fofofoofofofo fo fofo fofofo fofo fofofofo fo fofo fofofofofo fofofofo fo fofo fofofo.",null,"Franqueados de Porte C","Franqueados da Região Norte",50340,50341]
["Satisfação geral","Gogo gogo gogogogo go gogo gogogo gogo gogogogo go gogo gogogo gogo gogogogo go gog",null,"Franqueados de Porte A","Franqueados da Região Nordeste",50340,50342]
["Satisfação geral","Zozo zozo zo zozozozo zo zozo zozozo zozo zozozozo zo zozo zozozo zozo zozozozo zo zozo zozozozozo zozozozo zo zozo zozozo.",null,"Franqueados de Porte B","Franqueados da Região Centro-Oeste",50340,50343]
["Satisfação geral","Xoxo x xoxoxo xoxo xoxoxoxo xo xoxo xoxoxo xoxo xoxoxoxo xo xoxo xoxoxoxoxo xoxoxoxo xo xoxo xoxoxo.",null,"Franqueados de Porte C","Franqueados da Região Sudeste",50340,50344]
["Satisfação geral","Wowo wowo wowowoo wowowowo wo wowo wowowo wowo wowowowo wo wowo wowowowowo wowowowo wo wowo wowowo.",null,"Franqueados de Porte A","Franqueados da Região Sul",50340,50345]
["Satisfação geral","Dodo dodo ddodo dododo dodo dodododo do dodo dododo dodo dodododo do dodo dododododo dodododo do dodo dododo.",null,"Franqueados de Porte B","Franqueados da Região Sudeste",50340,50344]
["Satisfação geral","Dodo dodo dodododo do dodo dododo dodo dodododo do dodo dododo dodo dodo",null,"Franqueados de Porte C","Franqueados da Região Sul",50340,50345]