{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["INTRO","Função","Dispersão","Categorias","Circular","Extra"],"read":"whole","date_system":"1900"}

{"sheet":"INTRO","index":0,"n_rows":19,"n_cols":2,"rows_kept":19}
[]
[]
[null,"Ora viva!"]
[]
[null,"Esta é uma INTRODUÇÃO à representação gráfica no Excel!"]
[]
[null,"O que podemos representar graficamente?"]
[]
[null,"Eis alguns exemplos:"]
[]
[null,"   - uma função"]
[]
[null,"   - um conjunto de pontos (bom para vermos se há, ou não, relação entre duas variáveis!)"]
[]
[null,"   - um gráfico em que as abcissas são categorias (p.ex., os meses do ano)"]
[]
[null,"   - um gráfico de distribuição circular"]
[]
[null,"   - um gráfico com um eixo principal e um eixo secundário nas ordenadas"]

{"sheet":"Função","index":1,"n_rows":211,"n_cols":5,"rows_kept":211}
[]
[{"$nulls":4},"     2x2     ; x >= 0"]
[{"$nulls":3},"Considere a função f(x) =  "]
[{"$nulls":3},"         ","   - 2x2     ; x < 0"]
[]
[null,"Represente graficamente f(x) no domínio [-10; 10]."]
[]
[]
[null,null,"x","f(x)"]
[]
[null,null,{"$f":"-10","v":-10},{"$f":"IF(C11<0,-2*C11^2,2*C11^2)","v":{"v":-200,"d":"-200.00"}}]
[null,null,{"$f":"C11+0.1","v":-9.9},{"$f":"IF(C12<0,-2*C12^2,2*C12^2)","v":-196.02}]
[null,null,{"$f":"C12+0.1","v":-9.8},{"$f":"IF(C13<0,-2*C13^2,2*C13^2)","v":{"v":-192.08000000000004,"d":"-192.08"}}]
[null,null,-9.700000000000001,{"v":-188.18000000000004,"d":"-188.18"}]
[null,null,-9.600000000000001,{"v":-184.32000000000005,"d":"-184.32"}]
[null,null,-9.500000000000002,{"v":-180.50000000000006,"d":"-180.50"}]
[null,null,-9.400000000000002,{"v":-176.72000000000008,"d":"-176.72"}]
[null,null,-9.300000000000002,{"v":-172.9800000000001,"d":"-172.98"}]
[null,null,-9.200000000000003,{"v":-169.28000000000011,"d":"-169.28"}]
[null,null,-9.100000000000003,{"v":-165.62000000000012,"d":"-165.62"}]
[null,null,-9.000000000000004,{"v":-162.0000000000001,"d":"-162.00"}]
[null,null,-8.900000000000004,{"v":-158.42000000000013,"d":"-158.42"}]
[null,null,-8.800000000000004,{"v":-154.88000000000014,"d":"-154.88"}]
[null,null,-8.700000000000005,{"v":-151.38000000000017,"d":"-151.38"}]
[null,null,-8.600000000000005,{"v":-147.92000000000016,"d":"-147.92"}]
[null,null,-8.500000000000005,{"v":-144.50000000000017,"d":"-144.50"}]
[null,null,-8.400000000000006,{"v":-141.1200000000002,"d":"-141.12"}]
[null,null,-8.300000000000006,{"v":-137.7800000000002,"d":"-137.78"}]
[null,null,-8.200000000000006,{"v":-134.48000000000022,"d":"-134.48"}]
[null,null,-8.100000000000007,{"v":-131.22000000000023,"d":"-131.22"}]
[null,null,-8.000000000000007,{"v":-128.00000000000023,"d":"-128.00"}]
[null,null,-7.9000000000000075,{"v":-124.82000000000023,"d":"-124.82"}]
[null,null,-7.800000000000008,{"v":-121.68000000000025,"d":"-121.68"}]
[null,null,-7.700000000000008,{"v":-118.58000000000025,"d":"-118.58"}]
[null,null,-7.6000000000000085,{"v":-115.52000000000027,"d":"-115.52"}]
[null,null,-7.500000000000009,{"v":-112.50000000000027,"d":"-112.50"}]
[null,null,-7.400000000000009,{"v":-109.52000000000028,"d":"-109.52"}]
[null,null,-7.30000000000001,{"v":-106.58000000000028,"d":"-106.58"}]
[null,null,-7.20000000000001,{"v":-103.68000000000029,"d":"-103.68"}]
[null,null,-7.10000000000001,{"v":-100.82000000000029,"d":"-100.82"}]
[null,null,-7.000000000000011,{"v":-98.0000000000003,"d":"-98.00"}]
[null,null,-6.900000000000011,{"v":-95.2200000000003,"d":"-95.22"}]
[null,null,-6.800000000000011,{"v":-92.4800000000003,"d":"-92.48"}]
[null,null,-6.700000000000012,{"v":-89.78000000000031,"d":"-89.78"}]
[null,null,-6.600000000000012,{"v":-87.12000000000032,"d":"-87.12"}]
[null,null,-6.500000000000012,{"v":-84.50000000000033,"d":"-84.50"}]
[null,null,-6.400000000000013,{"v":-81.92000000000033,"d":"-81.92"}]
[null,null,-6.300000000000013,{"v":-79.38000000000034,"d":"-79.38"}]
[null,null,-6.2000000000000135,{"v":-76.88000000000034,"d":"-76.88"}]
[null,null,-6.100000000000014,{"v":-74.42000000000034,"d":"-74.42"}]
[null,null,-6.000000000000014,{"v":-72.00000000000034,"d":"-72.00"}]
[null,null,-5.900000000000015,{"v":-69.62000000000035,"d":"-69.62"}]
[null,null,-5.800000000000015,{"v":-67.28000000000034,"d":"-67.28"}]
[null,null,-5.700000000000015,{"v":-64.98000000000035,"d":"-64.98"}]
[null,null,-5.600000000000016,{"v":-62.72000000000035,"d":"-62.72"}]
[null,null,-5.500000000000016,{"v":-60.500000000000355,"d":"-60.50"}]
[null,null,-5.400000000000016,{"v":-58.320000000000356,"d":"-58.32"}]
[null,null,-5.300000000000017,{"v":-56.180000000000355,"d":"-56.18"}]
[null,null,-5.200000000000017,{"v":-54.080000000000354,"d":"-54.08"}]
[null,null,-5.100000000000017,{"v":-52.02000000000036,"d":"-52.02"}]
[null,null,-5.000000000000018,{"v":-50.000000000000355,"d":"-50.00"}]
[null,null,-4.900000000000018,{"v":-48.02000000000036,"d":"-48.02"}]
[null,null,-4.8000000000000185,{"v":-46.080000000000354,"d":"-46.08"}]
[null,null,-4.700000000000019,{"v":-44.180000000000355,"d":"-44.18"}]
[null,null,-4.600000000000019,{"v":-42.320000000000356,"d":"-42.32"}]
[null,null,-4.5000000000000195,{"v":-40.500000000000355,"d":"-40.50"}]
[null,null,-4.40000000000002,{"v":-38.72000000000035,"d":"-38.72"}]
[null,null,-4.30000000000002,{"v":-36.980000000000345,"d":"-36.98"}]
[null,null,-4.200000000000021,{"v":-35.28000000000035,"d":"-35.28"}]
[null,null,-4.100000000000021,{"v":-33.620000000000346,"d":"-33.62"}]
[null,null,-4.000000000000021,{"v":-32.00000000000034,"d":"-32.00"}]
[null,null,-3.9000000000000212,{"v":-30.420000000000332,"d":"-30.42"}]
[null,null,-3.800000000000021,{"v":-28.880000000000322,"d":"-28.88"}]
[null,null,-3.700000000000021,{"v":-27.38000000000031,"d":"-27.38"}]
[null,null,-3.600000000000021,{"v":-25.9200000000003,"d":"-25.92"}]
[null,null,-3.500000000000021,{"v":-24.50000000000029,"d":"-24.50"}]
[null,null,{"$f":"C76+0.1","v":-3.400000000000021},{"$f":"IF(C77<0,-2*C77^2,2*C77^2)","v":{"v":-23.12000000000028,"d":"-23.12"}}]
[null,null,-3.3000000000000207,{"v":-21.780000000000275,"d":"-21.78"}]
[null,null,-3.2000000000000206,{"v":-20.480000000000263,"d":"-20.48"}]
[null,null,-3.1000000000000205,{"v":-19.220000000000255,"d":"-19.22"}]
[null,null,-3.0000000000000204,{"v":-18.000000000000245,"d":"-18.00"}]
[null,null,-2.9000000000000203,{"v":-16.820000000000235,"d":"-16.82"}]
[null,null,-2.8000000000000203,{"v":-15.680000000000227,"d":"-15.68"}]
[null,null,-2.70000000000002,{"v":-14.580000000000219,"d":"-14.58"}]
[null,null,-2.60000000000002,{"v":-13.52000000000021,"d":"-13.52"}]
[null,null,-2.50000000000002,{"v":-12.500000000000199,"d":"-12.50"}]
[null,null,-2.40000000000002,{"v":-11.520000000000191,"d":"-11.52"}]
[null,null,-2.30000000000002,{"v":-10.580000000000183,"d":"-10.58"}]
[null,null,-2.2000000000000197,{"v":-9.680000000000174,"d":"-9.68"}]
[null,null,-2.1000000000000196,{"v":-8.820000000000165,"d":"-8.82"}]
[null,null,-2.0000000000000195,{"v":-8.000000000000156,"d":"-8.00"}]
[null,null,-1.9000000000000195,{"v":-7.220000000000148,"d":"-7.22"}]
[null,null,-1.8000000000000194,{"v":-6.480000000000139,"d":"-6.48"}]
[null,null,-1.7000000000000193,{"v":-5.780000000000131,"d":"-5.78"}]
[null,null,-1.6000000000000192,{"v":-5.120000000000123,"d":"-5.12"}]
[null,null,-1.500000000000019,{"v":-4.500000000000115,"d":"-4.50"}]
[null,null,-1.400000000000019,{"v":-3.9200000000001065,"d":"-3.92"}]
[null,null,-1.300000000000019,{"v":-3.3800000000000985,"d":"-3.38"}]
[null,null,-1.2000000000000188,{"v":-2.8800000000000905,"d":"-2.88"}]
[null,null,-1.1000000000000187,{"v":-2.4200000000000825,"d":"-2.42"}]
[null,null,-1.0000000000000187,{"v":-2.0000000000000746,"d":"-2.00"}]
[null,null,-0.9000000000000187,{"v":-1.6200000000000672,"d":"-1.62"}]
[null,null,-0.8000000000000187,{"v":-1.2800000000000598,"d":"-1.28"}]
[null,null,-0.7000000000000187,{"v":-0.9800000000000524,"d":"-0.98"}]
[null,null,-0.6000000000000187,{"v":-0.7200000000000449,"d":"-0.72"}]
[null,null,-0.5000000000000188,{"v":-0.5000000000000375,"d":"-0.50"}]
[null,null,-0.4000000000000188,{"v":-0.32000000000003004,"d":"-0.32"}]
[null,null,-0.3000000000000188,{"v":-0.18000000000002256,"d":"-0.18"}]
[null,null,-0.2000000000000188,{"v":-0.08000000000001505,"d":"-0.08"}]
[null,null,-0.1000000000000188,{"v":-0.02000000000000752,"d":"-0.02"}]
[null,null,{"v":-1.8790524691780774E-14,"d":"-0.0"},{"v":-7.061676363848459e-28,"d":"-0.00"}]
[null,null,0.09999999999998122,{"v":0.019999999999992486,"d":"0.02"}]
[null,null,0.19999999999998122,{"v":0.07999999999998497,"d":"0.08"}]
[null,null,0.2999999999999812,{"v":0.17999999999997748,"d":"0.18"}]
[null,null,0.39999999999998126,{"v":0.31999999999997003,"d":"0.32"}]
[null,null,0.49999999999998124,{"v":0.4999999999999625,"d":"0.50"}]
[null,null,0.5999999999999812,{"v":0.7199999999999549,"d":"0.72"}]
[null,null,0.6999999999999812,{"v":0.9799999999999474,"d":"0.98"}]
[null,null,0.7999999999999812,{"v":1.2799999999999399,"d":"1.28"}]
[null,null,0.8999999999999811,{"v":1.6199999999999322,"d":"1.62"}]
[null,null,0.9999999999999811,{"v":1.9999999999999245,"d":"2.00"}]
[null,null,1.0999999999999812,{"v":2.4199999999999173,"d":"2.42"}]
[null,null,1.1999999999999813,{"v":2.87999999999991,"d":"2.88"}]
[null,null,1.2999999999999814,{"v":3.379999999999903,"d":"3.38"}]
[null,null,1.3999999999999815,{"v":3.9199999999998965,"d":"3.92"}]
[null,null,1.4999999999999816,{"v":4.49999999999989,"d":"4.50"}]
[null,null,1.5999999999999817,{"v":5.119999999999883,"d":"5.12"}]
[null,null,1.6999999999999817,{"v":5.779999999999876,"d":"5.78"}]
[null,null,1.7999999999999818,{"v":6.479999999999869,"d":"6.48"}]
[null,null,1.899999999999982,{"v":7.219999999999863,"d":"7.22"}]
[null,null,1.999999999999982,{"v":7.999999999999856,"d":"8.00"}]
[null,null,2.099999999999982,{"v":8.819999999999848,"d":"8.82"}]
[null,null,2.199999999999982,{"v":9.679999999999842,"d":"9.68"}]
[null,null,2.299999999999982,{"v":10.579999999999835,"d":"10.58"}]
[null,null,2.399999999999982,{"v":11.519999999999829,"d":"11.52"}]
[null,null,2.4999999999999822,{"v":12.499999999999822,"d":"12.50"}]
[null,null,2.5999999999999823,{"v":13.519999999999817,"d":"13.52"}]
[null,null,2.6999999999999824,{"v":14.57999999999981,"d":"14.58"}]
[null,null,2.7999999999999825,{"v":15.679999999999804,"d":"15.68"}]
[null,null,2.8999999999999826,{"v":16.819999999999798,"d":"16.82"}]
[null,null,{"$f":"C140+0.1","v":2.9999999999999827},{"$f":"IF(C141<0,-2*C141^2,2*C141^2)","v":{"v":17.999999999999794,"d":"18.00"}}]
[null,null,3.0999999999999828,{"v":19.219999999999786,"d":"19.22"}]
[null,null,3.199999999999983,{"v":20.47999999999978,"d":"20.48"}]
[null,null,3.299999999999983,{"v":21.779999999999774,"d":"21.78"}]
[null,null,3.399999999999983,{"v":23.11999999999977,"d":"23.12"}]
[null,null,3.499999999999983,{"v":24.499999999999766,"d":"24.50"}]
[null,null,3.599999999999983,{"v":25.919999999999757,"d":"25.92"}]
[null,null,3.6999999999999833,{"v":27.379999999999754,"d":"27.38"}]
[null,null,3.7999999999999834,{"v":28.879999999999747,"d":"28.88"}]
[null,null,3.8999999999999835,{"v":30.419999999999742,"d":"30.42"}]
[null,null,3.9999999999999836,{"v":31.999999999999737,"d":"32.00"}]
[null,null,4.099999999999984,{"v":33.619999999999735,"d":"33.62"}]
[null,null,4.199999999999983,{"v":35.27999999999972,"d":"35.28"}]
[null,null,4.299999999999983,{"v":36.979999999999706,"d":"36.98"}]
[null,null,4.399999999999983,{"v":38.71999999999969,"d":"38.72"}]
[null,null,4.499999999999982,{"v":40.49999999999968,"d":"40.50"}]
[null,null,4.599999999999982,{"v":42.319999999999666,"d":"42.32"}]
[null,null,4.6999999999999815,{"v":44.17999999999965,"d":"44.18"}]
[null,null,4.799999999999981,{"v":46.079999999999636,"d":"46.08"}]
[null,null,4.899999999999981,{"v":48.01999999999963,"d":"48.02"}]
[null,null,4.9999999999999805,{"v":49.99999999999961,"d":"50.00"}]
[null,null,5.09999999999998,{"v":52.01999999999959,"d":"52.02"}]
[null,null,5.19999999999998,{"v":54.07999999999958,"d":"54.08"}]
[null,null,5.299999999999979,{"v":56.179999999999566,"d":"56.18"}]
[null,null,5.399999999999979,{"v":58.319999999999546,"d":"58.32"}]
[null,null,5.499999999999979,{"v":60.49999999999953,"d":"60.50"}]
[null,null,5.599999999999978,{"v":62.719999999999516,"d":"62.72"}]
[null,null,5.699999999999978,{"v":64.97999999999949,"d":"64.98"}]
[null,null,5.799999999999978,{"v":67.27999999999948,"d":"67.28"}]
[null,null,5.899999999999977,{"v":69.61999999999946,"d":"69.62"}]
[null,null,5.999999999999977,{"v":71.99999999999945,"d":"72.00"}]
[null,null,6.0999999999999766,{"v":74.41999999999943,"d":"74.42"}]
[null,null,6.199999999999976,{"v":76.87999999999941,"d":"76.88"}]
[null,null,6.299999999999976,{"v":79.37999999999938,"d":"79.38"}]
[null,null,6.3999999999999755,{"v":81.91999999999938,"d":"81.92"}]
[null,null,6.499999999999975,{"v":84.49999999999935,"d":"84.50"}]
[null,null,6.599999999999975,{"v":87.11999999999934,"d":"87.12"}]
[null,null,6.699999999999974,{"v":89.77999999999932,"d":"89.78"}]
[null,null,6.799999999999974,{"v":92.4799999999993,"d":"92.48"}]
[null,null,6.899999999999974,{"v":95.21999999999927,"d":"95.22"}]
[null,null,6.999999999999973,{"v":97.99999999999926,"d":"98.00"}]
[null,null,7.099999999999973,{"v":100.81999999999924,"d":"100.82"}]
[null,null,7.199999999999973,{"v":103.67999999999921,"d":"103.68"}]
[null,null,7.299999999999972,{"v":106.57999999999919,"d":"106.58"}]
[null,null,7.399999999999972,{"v":109.51999999999917,"d":"109.52"}]
[null,null,7.499999999999972,{"v":112.49999999999915,"d":"112.50"}]
[null,null,7.599999999999971,{"v":115.51999999999913,"d":"115.52"}]
[null,null,7.699999999999971,{"v":118.5799999999991,"d":"118.58"}]
[null,null,7.7999999999999705,{"v":121.67999999999908,"d":"121.68"}]
[null,null,7.89999999999997,{"v":124.81999999999906,"d":"124.82"}]
[null,null,7.99999999999997,{"v":127.99999999999903,"d":"128.00"}]
[null,null,8.09999999999997,{"v":131.219999999999,"d":"131.22"}]
[null,null,8.199999999999969,{"v":134.479999999999,"d":"134.48"}]
[null,null,8.299999999999969,{"v":137.77999999999895,"d":"137.78"}]
[null,null,8.399999999999968,{"v":141.11999999999892,"d":"141.12"}]
[null,null,8.499999999999968,{"v":144.49999999999892,"d":"144.50"}]
[null,null,8.599999999999968,{"v":147.91999999999888,"d":"147.92"}]
[null,null,8.699999999999967,{"v":151.37999999999886,"d":"151.38"}]
[null,null,8.799999999999967,{"v":154.87999999999883,"d":"154.88"}]
[null,null,8.899999999999967,{"v":158.41999999999882,"d":"158.42"}]
[null,null,8.999999999999966,{"v":161.99999999999878,"d":"162.00"}]
[null,null,9.099999999999966,{"v":165.61999999999875,"d":"165.62"}]
[null,null,9.199999999999966,{"v":169.27999999999872,"d":"169.28"}]
[null,null,9.299999999999965,{"v":172.9799999999987,"d":"172.98"}]
[null,null,{"$f":"C204+0.1","v":9.399999999999965},{"$f":"IF(C205<0,-2*C205^2,2*C205^2)","v":{"v":176.7199999999987,"d":"176.72"}}]
[null,null,9.499999999999964,{"v":180.49999999999864,"d":"180.50"}]
[null,null,9.599999999999964,{"v":184.31999999999863,"d":"184.32"}]
[null,null,9.699999999999964,{"v":188.17999999999859,"d":"188.18"}]
[null,null,9.799999999999963,{"v":192.07999999999856,"d":"192.08"}]
[null,null,9.899999999999963,{"v":196.01999999999853,"d":"196.02"}]
[null,null,9.999999999999963,{"v":199.99999999999852,"d":"200.00"}]

{"sheet":"Dispersão","index":2,"n_rows":35,"n_cols":5,"rows_kept":35}
[]
[]
[null,"Scatter Plot - Diagrama de Dispersão"]
[]
[]
[null,"X","Y",null,"Haverá relação entre X e Y, ou serão independentes?"]
[null,4.54,5.61]
[null,1.7,1.29]
[null,1.48,1.27]
[null,8.06,16.8]
[null,2.46,3]
[null,3.86,5.02]
[null,1.1,0.72]
[null,7.97,16.27]
[null,1.68,1.42]
[null,1.57,1.5]
[null,7.75,15.57]
[null,0.43,0.28]
[null,5.46,8.43]
[null,0.04,0.08]
[null,4.38,6.37]
[null,9.42,18.24]
[null,3.05,3.25]
[null,4.66,7.2]
[null,8.25,15.34]
[null,9.01,15.75]
[null,8.21,14.99]
[null,6.73,11.31]
[null,2.9,3.66]
[null,5.78,8.91]
[null,3.93,5.76]
[null,0.79,0.51]
[null,5.77,10.39]
[null,7.25,12.28]
[null,0.76,0.53]

{"sheet":"Categorias","index":3,"n_rows":7,"n_cols":4,"rows_kept":7}
[]
[]
[{"$nulls":3},"Vendas"]
[null,null,"Primavera",20435]
[null,null,"Verão",22571]
[null,null,"Outono",17936]
[null,null,"Inverno",16821]

{"sheet":"Circular","index":4,"n_rows":8,"n_cols":4,"rows_kept":8}
[]
[]
[]
[{"$nulls":3},"Vendas"]
[null,null,"Primavera",20435]
[null,null,"Verão",22571]
[null,null,"Outono",17936]
[null,null,"Inverno",16821]

{"sheet":"Extra","index":5,"n_rows":48,"n_cols":5,"rows_kept":48,"merged":[[21,3,22,3],[21,4,22,4]]}
[]
[]
[null,null,"Tempo (h)","Espessura do biofilme (mm)"]
[null,null,0,0]
[null,null,36,0.2]
[null,null,48,0.5]
[null,null,72,0.6]
[null,null,96,0.8]
[]
[null,null,"Represente um gráfico de dispersão."]
[null,null,"Para facilitar a interpretação, una os pontos com uma linha."]
[]
[null,null,"Para inserir um título no eixo xx:"]
[null,null,"1) Clique no gráfico"]
[null,null,"2) Separador Ferramentas de Gráfico"]
[null,null,"3) Estrutura > Adicionar Elemento de Gráfico"]
[null,null,"4) Título dos eixos"]
[]
[]
[]
[]
[null,null,"X:             Tempo ","Y1: Espessura do biofilme (mm)","Y2: Capacidade Elétrica        (pF)"]
[null,null,"(h)"]
[null,null,0,0,2.4]
[null,null,36,0.2,2.2]
[null,null,48,0.5,2]
[null,null,72,0.6,1.8]
[null,null,96,0.8,1.6]
[]
[]
[]
[null,null,"Para inserir a 2ª série de dados no 1º gráfico:"]
[null,null,"1) Clique no 1º gráfico com o botão do lado direito do rato"]
[null,null,"2) Escolha Selecionar Dados"]
[null,null,"3) Adicionar"]
[null,null,"4) Indicar o nome da nova série, as abcissas e as ordenadas"]
[]
[null,null,"Para inserir um eixo secundário das ordenadas, associado à série Y2:"]
[null,null,"1) Clique num ponto da série."]
[null,null,"2) Separador Ferramentas de Gráfico"]
[null,null,"3) Formatar > Formatar Seleção"]
[null,null,"4) Selecionar Eixo Secundário"]
[]
[null,null,"Para inserir títulos nos 3 eixos:"]
[null,null,"1) Clique no gráfico"]
[null,null,"2) Separador Ferramentas de Gráfico"]
[null,null,"3) Estrutura > Adicionar Elemento de Gráfico"]
[null,null,"4) Título dos eixos"]