App-SocialCalc-Multiplayer
view release on metacpan or search on metacpan
socialcalc/SocialCalcServersideUtilities.pm view on Meta::CPAN
subRenderSheet {my($context,$options) =@_;my$sheet=$context->{sheet};CalculateCellSkipData($context,$options);PrecomputeSheetFontsAndLayouts($context,$options);CalculateColWidthData($context,$options);# Make a reasonable guess about the size of our rendered sheet, then# pre-extend that SV. This is *critical* for mod_perl performance,# as malloc there is much slower there than the command line.my$outstr= ("\x00"x ($context->{maxrow} *$context->{maxcol} * 100));$outstr='';$outstr.= RenderTableTag($context,$options);# start with table tag$outstr.= RenderColGroup($context,$options);# then colgroup section$outstr.= RenderSizingRow($context,$options);# add tiny row so all cols have something despite spans
socialcalc/formula1.js view on Meta::CPAN
}SocialCalc.Formula.FunctionList["SYD"] = [SocialCalc.Formula.SYDFunction, 4,"cslp","","financial"];/*## FV(rate, n, payment, [pv, [paytype]])# NPER(rate, payment, pv, [fv, [paytype]])# PMT(rate, n, pv, [fv, [paytype]])# PV(rate, n, payment, [fv, [paytype]])# RATE(n, payment, pv, [fv, [paytype, [guess]]])## Following the Open Document Format formula specification:## PV = - Fv - (Payment * Nper) [if rate equals 0]# Pv*(1+Rate)^Nper + Payment * (1 + Rate*PaymentType) * ( (1+Rate)^nper -1)/Rate + Fv = 0## For each function, the formulas are solved for the appropriate value (transformed using# basic algebra).#*/SocialCalc.Formula.InterestFunctions = function(fname, operand, foperand, sheet) {var resulttype, result, dval,eval, fval;var pv, fv, rate, n, payment, paytype, guess, part1, part2, part3, part4, part5;var olddelta, maxloop, tries, deltaepsilon, rate, oldrate, m;var scf = SocialCalc.Formula;var aval = scf.OperandAsNumber(sheet, foperand);var bval = scf.OperandAsNumber(sheet, foperand);var cval = scf.OperandAsNumber(sheet, foperand);resulttype = scf.LookupResultType(aval.type, bval.type, scf.TypeLookupTable.twoargnumeric);resulttype = scf.LookupResultType(resulttype, cval.type, scf.TypeLookupTable.twoargnumeric);
socialcalc/formula1.js view on Meta::CPAN
elseif(rate == 0) { // simple calculationifnointerestpv = -fv - (payment * n);}else{pv = (-fv - payment * (1 + rate*paytype) * ( Math.pow(1+rate,n) -1)/rate)/(Math.pow(1+rate,n));}result = pv;resulttype ='n$';break;case"RATE": // RATE(n, payment, pv, [fv, [paytype, [guess]]])n = aval.value;payment = bval.value;pv = cval.value;fv = dval!=null ? dval.value : 0;paytype =eval!=null ? (eval.value ? 1 : 0) : 0;guess = fval!=null ? fval.value : 0.1;// rate is calculated by repeated approximations// The deltas are used to calculate new guessesmaxloop = 100;tries = 0;delta = 1;epsilon = 0.0000001; // this iscloseenoughrate = guess || 0.00000001; // zero is not allowedwhile((delta >= 0 ? delta : -delta) > epsilon && (rate != oldrate)) {delta = fv + pv*Math.pow(1+rate,n) + payment * (1 + rate*paytype) * ( Math.pow(1+rate,n) -1)/rate;if(olddelta!=null) {m = (delta - olddelta)/(rate - oldrate) || .001; // get slope (not zero)oldrate = rate;rate = rate - delta / m; // lookforzero crossingolddelta = delta;}else{ // firsttime-nooldvaluesoldrate = rate;
socialcalc/formula1.js view on Meta::CPAN
scf.PushOperand(operand, resulttypenpv, sum);return;}SocialCalc.Formula.FunctionList["NPV"] = [SocialCalc.Formula.NPVFunction, -2,"npv","","financial"];/*## IRR(c1:c2,[guess])#*/SocialCalc.Formula.IRRFunction = function(fname, operand, foperand, sheet) {var value1, guess, oldsum, maxloop, tries, epsilon, rate, oldrate, m, sum, factor, i;var rangeoperand = [];var cashflows = [];var scf = SocialCalc.Formula;rangeoperand.push(foperand.pop()); // first operand is a rangewhile(rangeoperand.length) { // getvaluesfrom range so we candoiterative approximationsvalue1 = scf.OperandValueAndType(sheet, rangeoperand);if(value1.type.charAt(0) =="n") {
socialcalc/formula1.js view on Meta::CPAN
scf.PushOperand(operand,"e#VALUE!", 0);return;}}if(!cashflows.length) {scf.PushOperand(operand,"e#NUM!", 0);return;}guess = {value: 0};if(foperand.length) { // guess is providedguess = scf.OperandAsNumber(sheet, foperand);if(guess.type.charAt(0) !="n"&& guess.type.charAt(0) !="b") {scf.PushOperand(operand,"e#VALUE!", 0);return;}if(foperand.length) { // should benomore argsscf.FunctionArgsError(fname, operand);return;}}guess.value = guess.value || 0.1;// rate is calculated by repeated approximations// The deltas are used to calculate new guessesmaxloop = 20;tries = 0;epsilon = 0.0000001; // this iscloseenoughrate = guess.value;sum = 1;while((sum >= 0 ? sum : -sum) > epsilon && (rate != oldrate)) {sum = 0;factor = 1;for(i=0; i<cashflows.length; i++) {factor *= (1 + rate);if(factor == 0) {scf.PushOperand(operand,"e#DIV/0!", 0);return;
socialcalc/socialcalc2demo-0-8-1.html view on Meta::CPAN
'range and return the corresponding value in the cell specified by the row offset. '+'If rangelookup is 1 (the default) and not 0, match if within numeric brackets (match<=value) instead of exact match. '+'<dt>HOUR(value)<dd>Returns the hour portion of a time or date/time value. '+'<dt>IF(logical-expression, true-value, false-value)<dd>Results in true-value if logical-expression is TRUE or non-zero, '+'otherwise results in false-value. '+'<dt>INDEX(range, rownum, colnum)<dd>Returns a cell or range reference for the specified row and column in the range. '+'If range is 1-dimensional, then only one of rownum or colnum are needed. '+'If range is 2-dimensional and rownum or colnum are zero, a reference to the range of just the specified column or row is returned. '+'You can use the returned reference value in a range, e.g., sum(A1:INDEX(A2:A10,4)). '+'<dt>INT(value)<dd>Returns the value rounded down to the nearest integer (towards -infinity). '+'<dt>IRR(range, [guess])<dd>Returns the interest rate at which the cash flows in the range '+'have a net present value of zero. Uses an iterative process that will return '+'#NUM! error if it does not converge. '+'There may be more than one possible solution. '+'Providing the optional guess value may help in certain situations '+'where it does not converge or finds an inappropriate solution (the default guess is 10%). '+'<dt>ISBLANK(value)<dd>Returns "true" if the value is a reference to a blank cell. '+'<dt>ISERR(value)<dd>Returns "true" if the value is of type "Error" but not "NA". '+'<dt>ISERROR(value)<dd>Returns "true" if the value is of type "Error". '+'<dt>ISLOGICAL(value)<dd>Returns "true" if the value is of type "Logical" (true/false). '+'<dt>ISNA(value)<dd>Returns "true" if the value is the error type "NA". '+'<dt>ISNONTEXT(value)<dd>Returns "true" if the value is not of type "Text". '+'<dt>ISNUMBER(value)<dd>Returns "true" if the value is of type "Number" (including logical values). '+'<dt>ISTEXT(value)<dd>Returns "true" if the value is of type "Text". '+'<dt>LEFT(text, count)<dd>Returns the specified number of characters from the text value. '+'If count is omitted, 1 is assumed. '+
socialcalc/socialcalc2demo-0-8-1.html view on Meta::CPAN
'and payment type (default 0 = at end of period, 1 = beginning of period). '+'<dt>POWER(value1, value2)<dd>Returns the first value raised to the second value power. '+'<dt>PRODUCT(value1, value2, ...)<dd>Returns the result of multiplying the numeric values. '+'<dt>PROPER(value)<dd>Returns the text value with the first letter of each word '+'converted to uppercase and the others to lowercase. '+'<dt>PV(rate, n, payment, [fv, [paytype]])<dd>Returns the present value of '+'the given number of payments each invested at the given rate, '+'with optional future value (default 0) '+'and payment type (default 0 = at end of period, 1 = beginning of period). '+'<dt>RADIANS(value)<dd>Converts value in degrees into radians. '+'<dt>RATE(n, payment, pv, [fv, [paytype, [guess]]])<dd>Returns the rate at which '+'the given number of payments each invested at the given rate has the '+'specified present value, with optional future value (default 0) '+'and payment type (default 0 = at end of period, 1 = beginning of period). '+'Uses an iterative process that will return #NUM! error if it does not converge. '+'There may be more than one possible solution. '+'Providing the optional guess value may help in certain situations '+'where it does not converge or finds an inappropriate solution (the default guess is 10%). '+'<dt>REPLACE(text1, start, length, text2)<dd>Returns text1 with the specified number of characters '+'starting from the specified position replaced by text2. '+'<dt>REPT(text, count)<dd>Returns the text repeated the specified number of times. '+'<dt>RIGHT(text, count)<dd>Returns the specified number of characters from the text value '+'starting from the end. '+'If count is omitted, 1 is assumed. '+'<dt>ROUND(value, [precision])<dd>Rounds the value to the specified number of decimal places. '+'If precision is negative, then round to powers of 10. '+'The default precision is 0 (round to integer). '+'<dt>ROWS(range)<dd>Returns the number of rows in the range. '+
socialcalc/socialcalc2demo10.html view on Meta::CPAN
'range and return the corresponding value in the cell specified by the row offset. '+'If rangelookup is 1 (the default) and not 0, match if within numeric brackets (match<=value) instead of exact match. '+'<dt>HOUR(value)<dd>Returns the hour portion of a time or date/time value. '+'<dt>IF(logical-expression, true-value, false-value)<dd>Results in true-value if logical-expression is TRUE or non-zero, '+'otherwise results in false-value. '+'<dt>INDEX(range, rownum, colnum)<dd>Returns a cell or range reference for the specified row and column in the range. '+'If range is 1-dimensional, then only one of rownum or colnum are needed. '+'If range is 2-dimensional and rownum or colnum are zero, a reference to the range of just the specified column or row is returned. '+'You can use the returned reference value in a range, e.g., sum(A1:INDEX(A2:A10,4)). '+'<dt>INT(value)<dd>Returns the value rounded down to the nearest integer (towards -infinity). '+'<dt>IRR(range, [guess])<dd>Returns the interest rate at which the cash flows in the range '+'have a net present value of zero. Uses an iterative process that will return '+'#NUM! error if it does not converge. '+'There may be more than one possible solution. '+'Providing the optional guess value may help in certain situations '+'where it does not converge or finds an inappropriate solution (the default guess is 10%). '+'<dt>ISBLANK(value)<dd>Returns "true" if the value is a reference to a blank cell. '+'<dt>ISERR(value)<dd>Returns "true" if the value is of type "Error" but not "NA". '+'<dt>ISERROR(value)<dd>Returns "true" if the value is of type "Error". '+'<dt>ISLOGICAL(value)<dd>Returns "true" if the value is of type "Logical" (true/false). '+'<dt>ISNA(value)<dd>Returns "true" if the value is the error type "NA". '+'<dt>ISNONTEXT(value)<dd>Returns "true" if the value is not of type "Text". '+'<dt>ISNUMBER(value)<dd>Returns "true" if the value is of type "Number" (including logical values). '+'<dt>ISTEXT(value)<dd>Returns "true" if the value is of type "Text". '+'<dt>LEFT(text, count)<dd>Returns the specified number of characters from the text value. '+'If count is omitted, 1 is assumed. '+
socialcalc/socialcalc2demo10.html view on Meta::CPAN
'and payment type (default 0 = at end of period, 1 = beginning of period). '+'<dt>POWER(value1, value2)<dd>Returns the first value raised to the second value power. '+'<dt>PRODUCT(value1, value2, ...)<dd>Returns the result of multiplying the numeric values. '+'<dt>PROPER(value)<dd>Returns the text value with the first letter of each word '+'converted to uppercase and the others to lowercase. '+'<dt>PV(rate, n, payment, [fv, [paytype]])<dd>Returns the present value of '+'the given number of payments each invested at the given rate, '+'with optional future value (default 0) '+'and payment type (default 0 = at end of period, 1 = beginning of period). '+'<dt>RADIANS(value)<dd>Converts value in degrees into radians. '+'<dt>RATE(n, payment, pv, [fv, [paytype, [guess]]])<dd>Returns the rate at which '+'the given number of payments each invested at the given rate has the '+'specified present value, with optional future value (default 0) '+'and payment type (default 0 = at end of period, 1 = beginning of period). '+'Uses an iterative process that will return #NUM! error if it does not converge. '+'There may be more than one possible solution. '+'Providing the optional guess value may help in certain situations '+'where it does not converge or finds an inappropriate solution (the default guess is 10%). '+'<dt>REPLACE(text1, start, length, text2)<dd>Returns text1 with the specified number of characters '+'starting from the specified position replaced by text2. '+'<dt>REPT(text, count)<dd>Returns the text repeated the specified number of times. '+'<dt>RIGHT(text, count)<dd>Returns the specified number of characters from the text value '+'starting from the end. '+'If count is omitted, 1 is assumed. '+'<dt>ROUND(value, [precision])<dd>Rounds the value to the specified number of decimal places. '+'If precision is negative, then round to powers of 10. '+'The default precision is 0 (round to integer). '+'<dt>ROWS(range)<dd>Returns the number of rows in the range. '+
socialcalc/socialcalcconstants.js view on Meta::CPAN
s_escUnknownSetCoordCmd:"Unknown set coord command: ",s_escUnknownCmd:"Unknown command: ",//*** SocialCalc.CheckAndCalcCells_caccCircRef:"Circular reference to ", // circular reference found during recalc//*** SocialCalc.RenderContextdefaultRowNameWidth:"30", // used to set minimum width of the row header column - a string in pixelsdefaultAssumedRowHeight: 15, // usedwhenguessing row heights - numberdefaultCellIDPrefix:"cell_", //ifnon-null,eachcell will renderwithan ID startingwiththis// Default sheet displayvaluesdefaultCellLayout:"padding:2px 2px 1px 2px;vertical-align:top;",defaultCellFontStyle:"normal normal",defaultCellFontSize:"small",defaultCellFontFamily:"Verdana,Arial,Helvetica,sans-serif",defaultPaneDividerWidth:"2", // a string
socialcalc/socialcalcconstants.js view on Meta::CPAN
s_fdef_EXP:'Returns e raised to the value power. ',s_fdef_FACT:'Returns factorial of the value. ',s_fdef_FALSE:'Returns the logical value "false". ',s_fdef_FIND:'Returns the starting position within string2 of the first occurrence of string1 at or after "start". If start is omitted, 1 is assumed. ',s_fdef_FV:'Returns the future value of repeated payments of money invested at the given rate for the specified number of periods, with optional present value (default 0) and payment type (default 0 = at end of period, 1 = beginning of period). ',s_fdef_HLOOKUP: 'Lookforthe matching valueforthegivenvalue in the range andreturnthe corresponding value in the cell specified by the row offset. If rangelookup is 1 (thedefault) and not 0, matchifwithin numeric brackets (match<=value) ...s_fdef_HOUR:'Returns the hour portion of a time or date/time value. ',s_fdef_IF:'Results in true-value if logical-expression is TRUE or non-zero, otherwise results in false-value. ',s_fdef_INDEX: 'Returns a cell or range referenceforthe specified row and column in the range. If range is 1-dimensional, then only one of rownum or colnum are needed. If range is 2-dimensional and rownum or colnum are zero, a reference to the ra...s_fdef_INT:'Returns the value rounded down to the nearest integer (towards -infinity). ',s_fdef_IRR: 'Returns the interest rate at which the cash flows in the range have a net present value of zero. Uses an iterative process that willreturn#NUM! error if it does not converge. There may be more than one possible solution. Providing t...s_fdef_ISBLANK:'Returns "true" if the value is a reference to a blank cell. ',s_fdef_ISERR:'Returns "true" if the value is of type "Error" but not "NA". ',s_fdef_ISERROR:'Returns "true" if the value is of type "Error". ',s_fdef_ISLOGICAL:'Returns "true" if the value is of type "Logical" (true/false). ',s_fdef_ISNA:'Returns "true" if the value is the error type "NA". ',s_fdef_ISNONTEXT:'Returns "true" if the value is not of type "Text". ',s_fdef_ISNUMBER:'Returns "true" if the value is of type "Number" (including logical values). ',s_fdef_ISTEXT:'Returns "true" if the value is of type "Text". ',s_fdef_LEFT:'Returns the specified number of characters from the text value. If count is omitted, 1 is assumed. ',s_fdef_LEN:'Returns the number of characters in the text value. ',
socialcalc/socialcalcconstants.js view on Meta::CPAN
s_fdef_NPV:'Returns the net present value of cash flows (which may be individual values and/or ranges) at the given rate. The flows are positive if income, negative if paid out, and are assumed at the end of each period. ',s_fdef_ODD:'Rounds the value up in magnitude to the nearest odd integer. ',s_fdef_OR:'True if any argument is true ',s_fdef_PI:'The value 3.1415926... ',s_fdef_PMT: 'Returns the amount ofeachpayment that must be invested at thegivenrateforthe specified number of periods to have the specified present value,withoptional future value (default0) and payment type (default0 = at end of period,...s_fdef_POWER:'Returns the first value raised to the second value power. ',s_fdef_PRODUCT:'Returns the result of multiplying the numeric values. ',s_fdef_PROPER:'Returns the text value with the first letter of each word converted to uppercase and the others to lowercase. ',s_fdef_PV:'Returns the present value of the given number of payments each invested at the given rate, with optional future value (default 0) and payment type (default 0 = at end of period, 1 = beginning of period). ',s_fdef_RADIANS:'Converts value in degrees into radians. ',s_fdef_RATE: 'Returns the rate at which thegivennumber of paymentseachinvested at thegivenratehasthe specified present value,withoptional future value (default0) and payment type (default0 = at end of period, 1 = beginning of period). ...s_fdef_REPLACE:'Returns text1 with the specified number of characters starting from the specified position replaced by text2. ',s_fdef_REPT:'Returns the text repeated the specified number of times. ',s_fdef_RIGHT:'Returns the specified number of characters from the text value starting from the end. If count is omitted, 1 is assumed. ',s_fdef_ROUND:'Rounds the value to the specified number of decimal places. If precision is negative, then round to powers of 10. The default precision is 0 (round to integer). ',s_fdef_ROWS:'Returns the number of rows in the range. ',s_fdef_SECOND:'Returns the second portion of a time or date/time value (truncated to an integer). ',s_fdef_SIN:'Trigonometric sine function (value is in radians) ',s_fdef_SLN:'Returns the amount of depreciation at each period of time using the straight-line method. ',s_fdef_SQRT:'Square root of the value ',s_fdef_STDEV:'Returns the sample standard deviation of the numeric values. ',
socialcalc/socialcalcconstants.js view on Meta::CPAN
s_farg_range:"range",s_farg_rangec:"range, criteria",s_farg_date:"year, month, day",s_farg_dfunc:"databaserange, fieldname, criteriarange",s_farg_ddb:"cost, salvage, lifetime, period [, factor]",s_farg_find:"string1, string2 [, start]",s_farg_fv:"rate, n, payment, [pv, [paytype]]",s_farg_hlookup:"value, range, row, [rangelookup]",s_farg_iffunc:"logical-expression, true-value, false-value",s_farg_index:"range, rownum, colnum",s_farg_irr:"range, [guess]",s_farg_tc:"text, count",s_farg_log:"value, base",s_farg_match:"value, range, [rangelookup]",s_farg_mid:"text, start, length",s_farg_nper:"rate, payment, pv, [fv, [paytype]]",s_farg_npv:"rate, value1, value2, ...",s_farg_pmt:"rate, n, pv, [fv, [paytype]]",s_farg_pv:"rate, n, payment, [fv, [paytype]]",s_farg_rate:"n, payment, pv, [fv, [paytype, [guess]]]",s_farg_replace:"text1, start, length, text2",s_farg_vp:"value, [precision]",s_farg_valpre:"value, precision",s_farg_csl:"cost, salvage, lifetime",s_farg_cslp:"cost, salvage, lifetime, period",s_farg_subs:"text1, oldtext, newtext [, occurrence]",s_farg_sumif:"range1, criteria [, range2]",s_farg_hms:"hour, minute, second",s_farg_txt:"text",s_farg_vlookup:"value, range, col, [rangelookup]",
socialcalc/third-party/hippie/Stream.js view on Meta::CPAN
}else{//No//Grab from the start of the start flag to the end of the chunkthis.currentStream += packet.substr(startFlag);//Leave this.currentStream set andwaitforanother packet}}else{//WTF? Noopenstream andnostart flag means someone fucked up the output//...OR maybe they're sending garbage in front of their first payload. Weird.//I guess just ignore itfornow?}//Else we have anopenstream}else{//Is there an end flag?if(endFlag > -1) {//Yes//Use the end flag to grab the rest of the payloadvar chunk = packet.substring(0, endFlag);this.currentStream += chunk;
( run in 0.299 second using v1.01-cache-2.11-cpan-26ccb49234f )