Save
Share... Copy spreadsheet Delete spreadsheet View for printing View as a web page Export as tab delimited text Export as CSV Export as HTML table Export email addresses Publish as RSS feed  Publish to my blog Publish to del.icio.us 
|
|
||||||||||||
|
|
|||||||||||||
Without too much trouble I was able to put in the functions below into 'spreadsheet engine.js' ( added to standardfunctions: ) using a local copy of NumSum. And I have hardly any JavaScript experience... How can such become a permanent addition? ahab /* AHB: */ EXP : function(v) { return theMath.exp(eng.standardFunctions.N(v)); }, /* AHB: */ ACOS : function(v) { return theMath.acos(eng.standardFunctions.N(v)); }, /* AHB: */ ASIN : function(v) { return theMath.asin(eng.standardFunctions.N(v)); }, /* AHB: */ ATAN : function(v) { return theMath.atan(eng.standardFunctions.N(v)); }, /* AHB: */ COS : function(v) { return theMath.cos(eng.standardFunctions.N(v)); }, /* AHB: */ SIN : function(v) { return theMath.sin(eng.standardFunctions.N(v)); }, /* AHB: */ TAN : function(v) { return theMath.tan(eng.standardFunctions.N(v)); }, /* AHB: */ SQRT : function(v) { return theMath.sqrt(eng.standardFunctions.N(v)); }, /* AHB: */ LN : function(v) { return theMath.log(eng.standardFunctions.N(v)); }, /* AHB: */ STR : function(v) { return theParseInt(v,10).toString(16).toUpperCase();}, /* AHB: */ INTHEX : function(v) { return theParseInt(v,10).toString(16).toUpperCase();}, /* AHB: */ HEXINT : function(v) { return theParseInt(v, 16).toString(10).toUpperCase(); }, /* AHB: */ ATANXY : function(x,y) { return theMath.atan2(x,y); }, /* AHB: */ pi : theMath.PI , /* AHB: */ e : theMath.E ,
1895 days ago
I need to be able to be able to figure square roots of numbers. I have tried numerous vriations of sqrt to no avail. Can you add this to the list of formulas?
2058 days ago
Is Date functionality in the works? When can we expect it?
2142 days ago
It would be nice to also know what each of the functions does. There's an assumption that people using this service already use Excel, but this online service could be an entry into the spreadsheet world, as it is for me. So a beginner's guide would be nice.
2154 days ago
As much as I agree a lot of functions are totally unnecessary I can't do any of my work without slope() y-int() and correl(). Okay, well I could write out the formulas manually but that is kind of riduculous unless there's a way to write our own reusable formulas...
2162 days ago
Great help, but is too hard to find when you need. What abot put this help in the main menu? []'s
2178 days ago
good list
2342 days ago