Ultra SJ22

My father is an actuary.... he does a lot of math and financial funtions in excel. He is asking me if exel in Docs to Go by Dataviz supports the same math and financial funtions of the excel in Windows, because he is thingking of switching from PPC to a Clie. He needs all of those advanced options that you need to create and edit excel files....

Can anyone help?


Thanks in advance....
Ultra SJ22

SiliGoose

No, there are a few functions not supported by Docs To Go. The only one I can think of off the top of my head (and it's not necessarily a financial function) is the RANK function. Docs To Go will display a spreadsheet containing an unsupported function but you won't be able to edit the spreadsheet in any way.

It's a major drawback to DTG, IMO. I don't know if other PalmOS spreadsheets have the same limitations.

vansouza

Have you asked at their web site, now that Docs2Go is in native mode it might be more useful to your dad.

Ultra SJ22

Well I installed the trial and tried some of the formuas my dad needs but they did not work on : Docs to go, and Quick ofiice.

anyone know of any other Office Apps for palm?

Duane

I am using version 6.005 of Docs to Go - which is one I had to pay the upgrade fee to get. There are is a full suite of functions available in that version. I have downloaded a number of spreadsheets down to my handheld and found very few functions that weren't available. For example, math functions supported are: abs, asin, atan, atan2, average, cos, exp, fact, log, log10, radians, sin, sqrt, sum, tan. In addition the lookup, financial, and string functions are available.

I do have things I have to rework where buttons with macros are built into the spreadsheet. These are not supported and you have to figure a different way of making it work.

Hope this helps.

Tixx

I have to e-mail Docs to Go because I have way too many spread sheets that are locked because it does not support all functions of excel. I'm finding it more and more uslelss as advanced sheets are produced I cannot use them and it is pissing me off actually.

__________________
Where I at?

Public Citizen... Alternet News... Amnesty International... Air America Radio...Lou Dobbs...Center for American Progress...Tricycle...

ngu3288

I think the only way to go is to get a notebook computer.

willgoss

It would help me to get DTG to release the functions supported. I use a lot of functions such as growth that I know will not be supported.

I suspect that they should make available for use all the functions they support. As an example I could not format the date function for "day" but haven't check if it supported it on import.

If I'm really going to use the D2G spreadsheet I need a lot more support information.

Tixx

Name (@) Returns Classification
Unary - Subtraction Negation Arithmetic Operator
+ Addition Arithmetic Operator
- Subtraction Arithmetic Operator
* Multiplication Arithmetic Operator
/ Division Arithmetic Operator
^ Exponentiation Arithmetic Operator
Unary Addition Arithmetic Operator
= Equal to Comparison Operator
<> Not Equal to Comparison Operator
<= Less than or equal to Comparison Operator
>= Greater than or equal to Comparison Operator
< Less than Comparison Operator
> Greater than Comparison Operator
& Connects, or concatenates, two values to produce one continuous text value Text Operator
DATE (yr, mon, day) The date number of yr, mon, day Date & Time
DAY(date number) the day number of date number Date & Time
HOUR(time number) the hour number of time number Date & Time
MINUTE(time number) the minute number of time number Date & Time
MONTH(date number) the month number of date number Date & Time
NOW() the serial number for the current date and time Date & Time
SECOND(time number) the second number of time number Date & Time
TIME(hr, min, sec) the time number of hr, min, sec Date & Time
TIMEVALUE(time_text) the year number of a date Date & Time
TODAY() The serial number for the current date Date & Time
WEEKDAY(date number, flags) the weekday number of date number (flags specifies what number gets mapped to what day) Date & Time
YEAR(date number) the year number of date number Date & Time
DDB(cost, salvage, life, period, factor) returns the depreciation of an asset for a specified period using the double-declining balance method or some other method you specify. Financial
FV(pmt, int, term) the future value of a series of equal payments, each of amount pmt, earning periodic interest rate int, over the number of payment periods in term Financial
IRR(range, guess) the internal rate of return for the series of cash flows in range, based on the approximate percentage guess of the IRR Financial
NPER(rate, pmt, pv, fv,type) the number of periods for an investment with interest rate per period, payment pmt for each period, present value pv, [and future value fv], base a constant rate, given the type (indicating payment due at the end (0) or beginning (1), default 0) Financial
NPV(int, range list) the present value of the series of future cash flows in range list, discounted at periodic interest rate int Financial
PMT(prin, int, term) the amount of the periodic payment needed to pay off principle prin, at periodic interest rate int, over the number of payment periods in term Financial
PV(pmt, int, term) the present value of a series of equal payments, each of amount pmt, discounted at periodic interest rate int, over the number of payment periods in term Financial
RATE(nper, pmt, pv, fv,type, guess) the interest rate per peroid for an annuity with nper total number of payment periods, pmt payment for each period, present value pv, [and future value fv], given the type (indicating payment due at the end (0) or beginning (1), default 0) Financial
SLN(cost, salvage, life) Returns the straight-line depreciation of an asset for one period. Financial
SYD(cost, salvage, life, per) Returns the sum-of-years' digits depreciation of an asset for a specific period. Financial
AND(list) Returns TRUE if all its arguments are TRUE; returns FALSE if one or more arguments is FALSE. Logical
OR(list) Returns TRUE is any argument is TRUE; returns FALSE if all arguments are FALSE. Logical
NOT(x) Reverses the value of its argument. Logical
TRUE() Returns the logical value TRUE. Logical
FALSE() Returns the logical value FALSE. Logical
IF(cond, x, y) Returns x if condition is TRUE, and y if FALSE Logical
CHOOSE(index, number, value1, value2, Ö) Returns a value from a list of values. Lookup & Reference
COLUMNS(array) returns the number of columns in a reference. Lookup & Reference
HLOOKUP(x, range, row number, exact match) the contents of the cell in row row number which lies directly below the cell in the top row of range that matches x. Row number is relative to the top of the table. The match to x may or may not have to be an exact match. Lookup & Reference
INDEX(reference, row_num, column_num area_num) Uses an index to choose a value from a reference. Lookup & Reference
MATCH(lookup_value, lookup_reference, match_type) looks up values in a reference Lookup & Reference
ROWS(array) Returns the number of rows in a reference Lookup & Reference
VLOOKUP(x, range, column number, exact match) the contents of the cell in column column number which lies directly across from the cell in the first column of range that matches x. Column number is relative to the left of the table. The match to x may or may not have to be an exact match. Lookup & Reference
ABS(x) the absolute value of x Math & Trig.
ACOS(x) the arc cosine of angle x Math & Trig
ASIN(x) the arc sine of angle x Math & Trig
ATAN(x) the arc tangent of angle x Math & Trig
ATAN2(x, y) the arc tangent of angle y/x Math & Trig
COS(x) the cosine of angle x Math & Trig.
COUNTIF(range, criteria) Counts the number of non-blank cells within a range that meet the given criteria Math & Trig.
DEGREES(x) x*180/p Math & Trig.
EVEN (number) Rounds a number to nearest even integer. Negative numbers are adjusted away from zero. Math & Trig.
EXP(x) the number e raised to the xth power Math & Trig.
FACT(number) returns the factorial of a number Math & Trig.
INT(x) rounds a number down to the nearest integer Math & Trig.
LN(x) the natural log of x Math & Trig.
LOG(number, base) returns the log of a number to a specified base. Math & Trig.
LOG10(x) the log (base 10) of x Math & Trig.
MOD(x, y) the remainder of x/y Math & Trig.
ODD (number) Rounds a number up to the nearest odd integer. Math & Trig.
PI() the number p Math & Trig.
POWER(number, power) Returns the result of a number raised to a power. Math & Trig.
PRODUCT(number1, number2, Ö) multiplies its arguments Math & Trig.
RADIANS(x) x*p/180 Math & Trig.
ROUND(x, n) x rounded to n places Math & Trig.
SIN(x) the sine of angle x Math & Trig.
SQRT(x) the positive square root of x Math & Trig.
SUM(list) the sum of the values in list Math & Trig.
SUMIF(range, criteria, sum_range) adds the cells specified by a given criteria Math & Trig.
TAN(x) the tangent of angle x Math & Trig.
TRUNC(number, num_digits) Truncates a number to an integer Math & Trig.
AVERAGE(list) the average of the values in list Statistical
COUNT(list) the number of non-blank entries in list Statistical
COUNTA(list) how many values are in the list of arguments Statistical
COUNTBLANK(range) Counts the number of blank cells in a range Statistical
MAX(list) the maximum value in list Statistical
MIN(list) the minimum value in list Statistical
STDEV(list) the sample standard deviation of the values in list Statistical
STDEVP(list) the population standard deviation of the values in list Statistical
VAR(list) the sample variance of the values in list Statistical
VARP(list) the population variance of the values in list Statistical
CONCATENATE(string) concatenates a list of strings or values together Text
EXACT(text1, text2) Checks to see if two text values are identical Text
FIND(find_text, within_text, start_num) finds one text value within another (case-sensitive) Text
LEFT(text, num_chars) Returns the leftmost characters from a text value Text
LEN(text) returns the number of characters in a string Text
LOWER(text) < Text
MID(text, start_num, num_chars) returns a specific number of characters from a text string Text

__________________
Where I at?

Public Citizen... Alternet News... Amnesty International... Air America Radio...Lou Dobbs...Center for American Progress...Tricycle...