{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Chart","HELP"],"not_rendered":{"charts":1,"images":2,"macros":0,"external_links":0,"defined_names":7,"comments":2,"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":"Chart","index":0,"n_rows":8,"n_cols":11,"rows_kept":8,"cut":false,"hidden":false,"merged":[[4,5,5,8],[3,5,3,8],[1,1,1,10],[3,10,7,10],[7,1,7,2],[7,5,7,8]]}
[]
[null,"Enter the values we will use to plot the Chart, I mean the FORMULA!  "]
[]
[null,"From",-10,null,null,"Write the desired formula: ",null,null,null,null,{"$f":"IF(wFormula=\"\",\"Escriba una Formula, Ver celda en VERDE\",\"F(x) = \" & SUBSTITUTE(wFormula,\"*\",\"\"))","v":"F(x) = sin(X)"}]
[null,"Until",10,null,null,"sin(X)"]
[null,"Nº of Points",50]
[]
[null,"www.ExcelStars.com",null,null,null,{"$f":"IF(SUM(Y)=0,0,1)","v":1}]

{"sheet":"HELP","index":1,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":false,"merged":[[2,3,3,9],[1,1,5,1],[20,6,21,9],[39,1,39,5]]}
[]
[]
[null,null,null,"www.ExcelStars.com"]
[]
[]
[]
[]
[null,"This template was not created by us, its author is:",null,null,null,null,"Stephen Bullen,  Stephen@oaltd.co.uk"]
[null,null,null,null,null,null,"http://www.oaltd.co.uk/MVP/Default.htm"]
[]
[null,"But we have considered that it is worth it and much to add it in this web.",null,null,null,null,"We have just adapted it!"]
[null,"This template is ready to draw any function you write."]
[null,"As long as, inside the Sheet:",null,{"$f":"MID(CELL(\"filename\",Chart!D4),FIND(\"]\",CELL(\"filename\",Chart!D4))+1,31)","v":"Chart"}]
[null,"Remember the abscissa that is the horizontal coordinate that is usually represented by the letter X "]
[null,"From",0]
[null,"Until",6,"These values are mandatory and numeric."]
[null,"Nº of points",50]
[]
[null,"Put the FUNCTION you want to appear drawn on the Chart, as follows:"]
[null,null,null,"Function","Write",null,"Write the desired Formula in:"]
[null,null,null,"Y = X2 + 3X +6","X^2+3*x+6",null,"Formula"]
[null,null,null,"Y = (4X2 + 3X +7)/4X","(4*X^2+3*X+8)/(4*X)"]
[null,null,null,"Y = SIN X","SIN(X)"]
[null,null,null,"Fibonnaci","'((((1+Sqrt(5))/2)^x)-(((1-Sqrt(5))/2)^x))/Sqrt(5)"]
[null,null,null,"Y = COS(X)+4x+3","COS(X)+4*x+3"]
[]
[null,"The reason x that this book has been saved enabled for macros is to avoid the error that arises when using the EVALUATE function."]
[null,"This error can be avoided by saving this same book in Excel 5.0/95."]
[null,"But in this excel version we lost the conditional formats, merged cells..."]
[]
[null,"The equation I have given as an example is that of Fibonacci obtained through the so-called: Gold number, Phi and/or the Divine Proportion."]
[null,"But this equation can only be drawn correctly if the number of points is equal to:"]
[null,"Being From and To integers!",null,null,"Number of Points = (To-From+1)"]
[]
[null,"I have considered that put to put a beautiful Equation, it is not possible to find a better one!"]
[]
[null,"If instead of putting Nº of points you prefer to put the increase between the points, you can adapt the formulas!"]
[null,null,"As well as to change the type of graph etc..."]
[]
[null,"It is important to remember that the formula entered will only be drawn if it is in the same language as Excel."]
[null,null,"In English Seno es Sin, Raiz es Sqrt..."]
[]
[null,"I hope that as an idea of what could be your final template, you find it useful."]
[null,null,"Yours sincerely!"]