
-----------------------------------------------------------------------------------------

SpreadCE for H/PC MIPS CE2.0

Version 1.07
Date 20001213

Written for and tested on a Casio E-10, but should work on other P/PCs.

-----------------------------------------------------------------------------------------

Copyright 1999 by Bye Design Ltd. All rights reserved. The software is provided without any warranty, expressed or implied, including without limitiation warranties of merchantability or fitness for a particular purpose. In no case shall the above named company be liable for any loss of profits or any other commercial damage, including special, incidental, consequential or other damages occasioned by your use of this software.

For more information contact stephenbye@byedesign.freeserve.co.uk

-----------------------------------------------------------------------------------------

Features:
	256 columns x 65536 rows x 255 sheets
	supported operations: + - * / ^ % &
	316 worksheet functions (see below)
	29 macro functions for custom functions and commands
	array formulas
	undo, cut, copy, paste, fill, clear
	insert/delete cells, rows and columns
	hide/unhide rows and columns
	hide/show row and column headings
	find text in formula or result
	goto specified cell
	sort selected cells, rows, columns or whole sheet with multiple keys
	freeze panes
	sheet/column/row/cell formatting:
		column width
		row height
		number formats (general/fixed/currency/accounting/date/time/percent/fraction/scientific/text/custom)
		alignment (horizontal:general/left/center/right/fill/center across selection, vertical:top/center/bottom)
		font (bold, italic, underline, name, size, color)
		borders (top, left, bottom, right, style, color)
		zoom
		background (pattern, color)
	charts (column, bar, line, pie, scatter, area)
	named ranges
	import/export Excel 95/97 files
	import/export Pocket Excel 2.0 files
	import/export CSV files

-----------------------------------------------------------------------------------------

To install:
Using ActiveSync on your desktop PC open an explorer window on your P/PC.
If you don't have ActiveSync it is available (free) from www.microsoft.com .
Copy the spreadce.exe file and paste it into the \Windows\Start Menu directory on your P/PC.
Do not try to run the exe file on your desktop PC, it is not an installation program.

-----------------------------------------------------------------------------------------

The program can read and write Excel 95/97 files directly, but you may instead want to store them in Pocket Excel format on your P/PC.
The Pocket Excel format takes up less space, but it is not recommended as it has fewer functions and formatting options available.

If you want to use the Pocket Excel format, set up the file conversions as follows:
Make sure that you are using ActiveSync 3.0 (available free from Microsoft's web site) to connect your desktop PC to your P/PC.
Select the ActiveSync Tools -> Options menu option,
select the Rules tab,
press the Conversion Settings button,
select the Desktop to Device tab,
select Microsoft Excel Worksheet in the listbox,
press the Edit button,
select Pocket Excel 2.0 in the drop-down list box,
and press the OK button.
Then select the Device to Desktop tab,
select Pocket Excel Workbook in the listbox,
press the Edit button,
select Excel 95 or 97 or 2000 in the drop-down listbox,
and press the OK button.

Now when you drag & drop files from the desktop computer to/from the P/PC they will be converted automatically between the Excel and Pocket Excel formats.
You will need to store the files on the P/PC in the My Documents folder, either in the main memory or on the Compact Flash memory expansion card.

-----------------------------------------------------------------------------------------

Supported functions ( [ ] indicates optional parameters ) :

	Database
		DAVERAGE(database_range,field,criteria_range)
		DCOUNT(database_range,[field],criteria_range)
		DCOUNTA(database_range,[field],criteria_range)
		DGET(database_range,field,criteria_range)
		DMAX(database_range,field,criteria_range)
		DMIN(database_range,field,criteria_range)
		DPRODUCT(database_range,field,criteria_range)
		DSTDEV(database_range,field,criteria_range)
		DSTDEVP(database_range,field,criteria_range)
		DSUM(database_range,field,criteria_range)
		DVAR(database_range,field,criteria_range)
		DVARP(database_range,field,criteria_range)

	Date/time
		DATE(year,month,day)
		DATEDIF(date1,date2,units)
		DATEVALUE(date_text)
		DAY(serial_number)
		DAYS360(start_date,end_date,[method])
		EDATE(start_date,months)
		EOMONTH(start_date,months)
		HOUR(serial_number)
		MINUTE(serial_number)
		MONTH(serial_number)
		NETWORKDAYS(start_date,end_date,holidays)
		NOW()
		SECOND(serial_number)
		TIME(hour,minute,second)
		TIMEVALUE(time_text)
		TODAY()
		WEEKDAY(serial_number,[return_type])
		WEEKNUM(serial_number,[return_type])
		WORKDAY(start_date,number_days,holidays)
		YEAR(serial_number)
		YEARFRAC(start_date,end_date,[basis])

	Engineering
		BESSELI(x,n)
		BESSELJ(x,n)
		BESSELK(x,n)
		BESSELY(x,n)
		BIN2DEC(number)
		BIN2HEX(number,[places])
		BIN2OCT(number,[places])
		COMPLEX(real_num,imag_num,[suffix])
		CONVERT(number,from_unit,to_unit)
		DEC2BIN(number,[places])
		DEC2HEX(number,[places])
		DEC2OCT(number,[places])
		DELTA(number1,[number2])
		ERF(lower_limit,[upper_limit])
		ERFC(x)
		GESTEP(number,[step])
		HEX2BIN(number,[places])
		HEX2DEC(number)
		HEX2OCT(number,[places])
		IMABS(inumber)
		IMAGINARY(inumber)
		IMARGUMENT(inumber)
		IMCONJUGATE(inumber)
		IMCOS(inumber)
		IMDIV(inumber1,inumber2)
		IMEXP(inumber)
		IMLN(inumber)
		IMLOG10(inumber)
		IMLOG2(inumber)
		IMPOWER(inumber,number)
		IMPRODUCT(inumber1,[inumber2,...])
		IMREAL(inumber)
		IMSIN(inumber)
		IMSQRT(inumber)
		IMSUB(inumber1,inumber2)
		IMSUM(inumber1,[inumber2,...])
		OCT2BIN(number,[places])
		OCT2DEC(number)
		OCT2HEX(number,[places])

	Financial
		ACCRINT(issue_date,first_interest_date,settlement_date,rate,par,frequency,[basis])
		ACCRINTM(issue_date,maturity_date,rate,[par],[basis])
		AMORDEGRC(cost,purchase_date,first_period_date,salvage,period,rate,[basis])
		AMORLINC(cost,purchase_date,first_period_date,salvage,period,rate,[basis])
		COUPDAYBS(settlement_date,maturity_date,frequency,[basis])
		COUPDAYS(settlement_date,maturity_date,frequency,[basis])
		COUPDAYSNC(settlement_date,maturity_date,frequency,[basis])
		COUPNCD(settlement_date,maturity_date,frequency,[basis])
		COUPNUM(settlement_date,maturity_date,frequency,[basis])
		COUPPCD(settlement_date,maturity_date,frequency,[basis])
		CUMIPMT(rate,nper,pv,start_period,end_period,type)
		CUMPRINC(rate,nper,pv,start_period,end_period,type)
		DB(cost,salvage,life,period,[month])
		DDB(cost,salvage,life,period,[factor])
		DISC(settlement_date,maturity_date,pr,redemption,[basis])
		DOLLARDE(fractional_dollar,fraction)
		DOLLARFR(decimal_dollar,fraction)
		DURATION(settlement_date,maturity_date,coupon,yield,frequency,[basis])
		EFFECT(nominal_rate,npery)
		FV(rate,term,[payment],[pv],[type])
		FVSCHEDULE(principal,schedule_range)
		INTRATE(settlement_date,maturity_date,investment_amount,redemption_amount,[basis])
		IPMT(rate,period,term,pv,[fv],[type])
		IRR(values_range,[guess])
		MDURATION(settlement_date,maturity_date,coupon,yield,frequency,[basis])
		MIRR(values_range,finance_rate,reinvest_rate)
		NOMINAL(effect_rate,npery)
		NPER(rate,payment,pv,[fv],[type])
		NPV(rate,value1,[value2,...])
		PMT(rate,term,[pv],[fv],[type])
		PPMT(rate,period,term,pv,[fv],[type])
		PRICE(settlement_date,maturity_date,rate,yield,redemption,frequency,[basis])
		PRICEDISC(settlement_date,maturity_date,discount,redemption,[basis])
		PRICEMAT(settlement_date,maturity_date,issue_date,rate,yield,[basis])
		PV(rate,term,[payment],[fv],[type])
		RATE(term,payment,pv,[fv],[type],[guess])
		RECEIVED(settlement_date,maturity_date,investment,discount,[basis])
		SLN(cost,salvage,life)
		SYD(cost,salvage,life,period)
		TBILLEQ(settlement_date,maturity_date,discount)
		TBILLPRICE(settlement_date,maturity_date,discount)
		TBILLYIELD(settlement_date,maturity_date,price)
		VDB(cost,salvage,life,start_period,end_period,[factor],[no_switch])
		XIRR(values_range,dates_range,[guess])
		XNPV(rate,values_range,dates_range)
		YIELD(settlement_date,maturity_date,rate,price,redemption,frequency,[basis])
		YIELDDISC(settlement_date,maturity_date,price,redemption,[basis])
		YIELDMAT(settlement_date,maturity_date,issue_date,rate,price,[basis])

	Information
		CELL(info_type,reference)
		COUNTBLANK(range)
		ERROR.TYPE(error_val)
		INFO(type_text)
		ISBLANK(value)
		ISERR(value)
		ISERROR(value)
		ISEVEN(number)
		ISLOGICAL(value)
		ISNA(value)
		ISNONTEXT(value)
		ISNUMBER(value)
		ISODD(number)
		ISREF(value)
		ISTEXT(value)
		N(value)
		NA()
		TYPE(value)

	Logical
		AND(logical1,[logical2,...])
		FALSE()
		IF(logical_test,[value_if_true],[value_if_false])
		NOT(logical)
		OR(logical1,[logical2,...])
		TRUE()

	Lookup/reference
		ADDRESS(row_num,column_num,[abs_num],[a1],[sheet_text])
		CHOOSE(index_num,value1,[value2,...])
		COLUMN([reference])
		COLUMNS(range)
		HLOOKUP(lookup_value,table_range,row_index_num,[range_lookup])
		INDEX(reference, [row_num], [column_num], [area_num])
		INDIRECT(ref_text,[a1])
		LOOKUP(lookup_value,lookup_range,result_range)
		MATCH(lookup_value,lookup_range,[match_type])
		OFFSET(reference,rows,cols,[height],[width])
		ROW([reference])
		ROWS(range)
		TRANSPOSE(range)
		VLOOKUP(lookup_value,table_range,col_index_num,[range_lookup])

	Math/trigonometry
		ABS(number)
		ACOS(number)
		ACOSH(number)
		ASIN(number)
		ASINH(number)
		ATAN(number)
		ATAN2(x_num,y_num)
		ATANH(number)
		CEILING(number,significance)
		COMBIN(number,number_chosen)
		COS(number)
		COSH(number)
		COUNTIF(range,criteria)
		DEGREES(angle)
		EVEN(number)
		EXP(number)
		FACT(number)
		FACTDOUBLE(number)
		FLOOR(number,significance)
		GCD(number1,[number2,...])
		INT(number)
		LCM(number1,[number2,...])
		LN(number)
		LOG(number,[base])
		LOG10(number)
		MDETERM(range)
		MINVERSE(range)
		MMULT(range1,range2)
		MOD(number,divisor)
		MROUND(number,multiple)
		MULTINOMIAL(number1,[number2,...])
		ODD(number)
		PI()
		POWER(number,power)
		PRODUCT(number1,[number2,...])
		QUOTIENT(numerator,denominator)
		RADIANS(angle)
		RAND()
		RANDBETWEEN(smallest,largest)
		ROMAN(number,[form])
		ROUND(number,num_digits)
		ROUNDDOWN(number,[num_digits])
		ROUNDUP(number,[num_digits])
		SERIESSUM(x,n,m,coefficients)
		SIGN(number)
		SIN(number)
		SINH(number)
		SQRT(number)
		SQRTPI(number)
		SUBTOTAL(function_num,ref1,[ref2,...])
		SUM(number1,[number2,..])
		SUMIF(range,criteria,[sum_range])
		SUMPRODUCT(range1[,range2,...])
		SUMSQ(number1,[number2,...])
		SUMX2MY2(x_range,y_range)
		SUMX2PY2(x_range,y_range)
		SUMXMY2(x_range,y_range)
		TAN(number)
		TANH(number)
		TRUNC(number,[num_digits])

	Statistical
		AVEDEV(number1,[number2,...])
		AVERAGE(number1,[number2,...])
		AVERAGEA(value1,[value2,...])
		BETADIST(x,alpha,beta,[A],[B])
		BETAINV(probability,alpha,beta,[A],[B])
		BINOMDIST(number_successes,trials,probability,cumulative)
		CHIDIST(x,degrees_freedom)
		CHIINV(probability,degrees_freedom)
		CHITEST(actual_range,expected_range)
		CONFIDENCE(alpha,standard_deviation,size)
		CORREL(range1,range2)
		COUNT(value1,[value2,...])
		COUNTA(value1,[value2,...])
		COVAR(range1,range2)
		CRITBINOM(trials,probability_s,alpha)
		DEVSQ(number1,[number2,...])
		EXPONDIST(x,lambda,cumulative)
		FDIST(x,degrees_freedom1,degrees_freedom2)
		FINV(probability,degrees_freedom1,degrees_freedom2)
		FISHER(x)
		FISHERINV(y)
		FORECAST(x,y_range,x_range)
		FREQUENCY(data_array,bins_array)
		FTEST(range1,range2)
		GAMMADIST(x,alpha,beta,cumulative)
		GAMMAINV(probability,alpha,beta)
		GAMMALN(x)
		GEOMEAN(number1,[number2,...])
		HARMEAN(number1,[number2,...])
		HYPGEOMDIST(sample_s,number_sample,population_s,number_population)
		INTERCEPT(y_range,x_range)
		KURT(number1,[number2,...])
		LARGE(range,k)
		LOGINV(probability,mean,standard_dev)
		LOGNORMDIST(x,mean,standard_dev)
		MAX(number1,[number2,...])
		MAXA(value1,[value2,...])
		MEDIAN(number1,[number2,...])
		MIN(number1,[number2,...])
		MINA(value1,[value2,...])
		MODE(number1,[number2,...])
		NEGBINOMDIST(number_f,number_s,probability_s)
		NORMDIST(x,mean,standard_dev,cumulative)
		NORMINV(probability,mean,standard_dev)
		NORMSDIST(z)
		NORMSINV(probability)
		PEARSON(range1,range2)
		PERCENTILE(range,k)
		PERCENTRANK(range,x,[significance])
		PERMUT(number,number_chosen)
		POISSON(x,mean,cumulative)
		PROB(x_range,prob_range,lower_limit,[upper_limit])
		QUARTILE(range,quart)
		RANK(number,range,[order])
		RSQ(y_range,x_range)
		SKEW(number1,[number2,...])
		SLOPE(y_range,x_range)
		SMALL(range,k)
		STANDARDIZE(x,mean,standard_dev)
		STDEV(number1,[number2,...])
		STDEVA(value1,[value2,...])
		STDEVP(number1,[number2,...])
		STDEVPA(value1,[value2,...])
		STEYX(y_range,x_range)
		TDIST(x,degrees_freedom,tails)
		TINV(probability,degrees_freedom)
		TREND(known_ys,[known_xs],[new_xs],[const])
		TRIMMEAN(range,percent)
		TTEST(range1,range2,tails,type)
		VAR(number1,[number2,...])
		VARA(value1,[value2,...])
		VARP(number1,[number2,...])
		VARPA(value1,[value2,...])
		WEIBULL(x,alpha,beta,cumulative)
		ZTEST(range,x,[sigma])

	Text
		CHAR(number)
		CLEAN(text)
		CODE(text)
		CONCATENATE(text1,[text2,...])
		DOLLAR(number,[decimals])
		EXACT(text1,text2)
		FIND(find_text,within_text,[start_num])
		FIXED(number,[decimals],[no_commas])
		LEFT(text,[num_chars])
		LEN(text)
		LOWER(text)
		MID(text,start_num,num_chars)
		PROPER(text)
		REPLACE(old_text,start_num,num_chars,new_text)
		REPT(text,number_times)
		RIGHT(text,[num_chars])
		SEARCH(find_text,within_text,[start_num])
		SUBSTITUTE(text,old_text,new_text,[instance_num])
		T(value)
		TEXT(value,format_text)
		TRIM(text)
		UPPER(text)
		VALUE(text)

	Macro control
		ARGUMENT([name],[type],[reference])
		BREAK()
		ELSE()
		ELSE.IF(logical_test)
		END.IF()
		GOTO(reference)
		IF(logical_test)
		NEXT()
		RETURN([value])
		SET.NAME(name_text,[value])
		SET.VALUE(reference,values)
		WAIT(serial_number)
		WHILE(logical_test)

	Macro command
		ACTIVE.CELL()
		ALERT(message_text,[type_num],[help_ref])
		BEEP([tone_num])
		DEREF(reference)
		EDIT.DELETE([shift_num])
		EVALUATE(formula_text)
		FILL.DOWN()
		FILL.LEFT()
		FILL.RIGHT()
		FILL.UP()
		FORMAT.NUMBER(format_text)
		FORMULA(formula_text,[reference])
		INSERT([shift_num])
		SELECT([selection],[active_cell])
		SELECTION()
		WORKBOOK.ACTIVATE(sheet_name)
