Reviews                                                                                       [<--]

PlanMaker

 Information
Author: SoftMaker Software GmbH
Company Web Site: http://www.softmaker.de/pmh_en.htm
Email: support@softmaker.com
Version tested: Evaluation version desktop and HPC Beta 5 (rev 259)
Price: $49.95 (including the desktop version)
Category
: Spreadsheet
 
 Tested on
Desktop: Pentium III - Windows 98SE (but works on all 32 bit Windows version)
PDA: Jornada 720 US machine (but works also on PocketPC)
 
 Description
PlanMaker is the most powerful spreadsheet package developed for Windows CE – in fact, it is by far the most full-featured spreadsheet for any PDA.
Imagine that: Calculate and visualize on your mobile device just like with Microsoft Excel on the desktop!
PlanMaker offers the feature set and ease-of-use of a modern high-end spreadsheet application - not only under Windows, but also under Linux and on Pocket PCs and Windows CE-based Handheld PCs. This means that PlanMaker is the only spreadsheet worldwide that is available for four different popular operating systems and offers the same feature set on all of them.
 
 Features
- More than 320 calculation functions, covering maths, financial mathematics, date and time
  calculations, data analysis etc.
-
Supports complex numbers, matrix (array) calculations and a vast range of statistics
  functions
-
Authentic conversion (back and forth) of Microsoft Excel files (Excel 5.0, 95, 97, 2000,
  XP, and 2003)
-
Powerful charting engine that renders high-quality charts in 2D and 3D (70 different chart
  types)
-
AutoShapes-compatible drawing directly in your worksheets (drawing, designing,
  flow-charting, magic connectors etc.)
-
AutoFormat, hierarchical cell and character styles, conditional formatting
-
Data grouping (outliner)
-
Spell-checking in 16 languages
-
... and much more!
 
 Documentation and help
A help file is provided with the desktop and the HPC version.
 
 Some definitions
In the description above, we have seen that PlanMaker is the most powerful spreadsheet package developed for Windows CE, but what is a spreadsheet?

A spreadsheet is a sheet of paper that shows accounting or other data in rows and columns; a spreadsheet is also a computer application program that simulates a physical spreadsheet by capturing, displaying, and manipulating data arranged in rows and columns.

And let's go with few more...
Cell: The intersection of a row and a column on a spreadsheet in which data can be entered. Cells are designated by their column letter and row number (eg: A1).
Column: The vertical divisions of a spreadsheet that intersect the horizontal divisions (rows) to form cells in which data can be entered. columns are labeled alphabetically (A,B,C,...AB,AC,AD...).
Formula: A type of information that can be entered into a spreadsheet cell. It is a mathematical equation consisting of numbers, other cell designators, and symbols for mathematical operations. the result of the formula is displayed in the cell that holds the formula.
Label: A type of data that can be entered into a spreadsheet cell. It consists of words that usually label a column or row of numbers.
Row: The horizontal divisions of a spreadsheet that intersect the vertical divisions (columns) to form cells in which data can be entered. Rows are labeled numerically (1,2,3,4,...).
Value: One type of data that can be entered into a spreadsheet cell. It consists of numbers that can be added, subtracted, etc.
 
 Working with the software
My God, what a chunk, this is very impressive. HPC community knows about SoftMaker thanks to their great TextMaker software. TextMaker is unique in the sense that no other exist for Windows CE, but for PlanMaker it's a little bit different, because other spreadsheet software already exist (SpreadCE, PTab, PocketGraph). I won't make any comparison between them and this review will be more an overview, else a book will be necessary to describe all the functionalities of PlanMaker.
Since revision 261, VBA (Visual Basic) macros contained in Excel workbooks are no longer discarded but kept around until you save again and then automatically stored in the new workbook. This mean that PlanMaker cannot execute the macros but stores them temporarily so they get not lost when opening (and storing) xls files. SoftMaker inform me that they will develop a macro editor able to execute VBA macros soon, but there is no release date yet.
The package includes a desktop part and a device part, so let's go.
 
 The desktop part
As for TextMaker, the interface of the desktop version is similar to the device version, except that you may have some more functionalities like editing and running scripts or launching DataMaker or TextMaker for Windows.
I won't review the desktop version, this is just a presentation.

 
 The device part
The program installed on your machine is completly independent of the desktop, there is no need to use both of them. You will need approximatively 8Mb of free space in order to install it (the installation on a Storage Card is recommended). You copy and synchonize your files as usual with ActiveSync.
Again I repeat myself, but I won't review all the functions and I will more just describe some of the functionalities of this application.


Already seen this interface? Well, not surprinsing... and almost all what you can find in Microsoft Excel is there. People familiar with it will use PlanMaker with no difficulties.


Windows CE users and particularly HPC users have now access to a powerful charting engine in 2D and 3D and with 70 different chart types.




PlanMaker allows also to change the columns type...


... and to select every part of the object.


The "Object properties" window offers all what you need in order to customize your chart.

Drawing:
You can also add drawing objects and use connectors


A lot of autoshapes are available and ready to use.

Pictures:
Among other, you can add text and picture frames.


15 different formats of pictures are recognized by PlanMaker. But do not use animated GIFs, the "preview" window display it, but if you try to insert one then the program becomes instable and you may be forced to kill it.

Insert:
This menu has some cool functions like inserting comments, symbols, page breaks, header and footer...


... a great ease for inserting "functions"


and as in TextMaker, pre-defined pieces of text called "SmartText".

Tools:
Alll what has been described above is more related with the functions you can use to create your document, but some good tools are also available.


A "Search and Replace" function.
 

A "File Manager" that allows to search for files and to add them to a list. A preview is also offered, great to see what the file looks like.


A "Preferences" window related to the interface.


A "Keyboard Mapping" to change the shortcuts of the menus.


And a "sheets properties" in which you can protect your document.
 
 Missing functionalities
A lot of things are missing in my review, but nothing is missing in this very good application. Apart for the VBA macros, but as mentioned above SoftMaker intend to do something for that, so...
 
 Conclusion
PlanMaker is a "spread" that can be devoured without moderation. As for TextMaker, it contribute to be more independent of your desktop PC and offers a great compatibility with Excel documents.
 
 Rating
JJJJJ 5 "J" on 5 and what to say more...