CITYWAY

PlanMaker

The best free alternative to Microsoft Excel

Create complex calculations, worksheets and charts with ease: With the powerful spreadsheet application CITYWAY PlanMaker, the best free alternative to Microsoft Excel, you can create simple timetables as conveniently as the complete financial planning of your company.

Thanks to numerous design features, CITYWAY PlanMaker lets you create presentation-quality worksheets: Not only can you insert pictures, drawings, text frames or impressive charts in 2D or 3D, but you can also choose from a large catalog of attractive cell styles that are compatible with Microsoft Excel 2021 and Excel 365.

More than 430 calculation functions and a wide variety of analysis features help you get the most out of your data. As CITYWAY PlanMaker supports huge worksheets with up to 1 million rows and 16,384 columns, pivot tables are a useful tool for quickly summarizing and analyzing your data.

CITYWAY PlanMaker opens and saves all Microsoft Excel XLS and XLSX files. You can also export your worksheets to PDF or print them exactly the way you want: tailored to fit on a specified number of pages, with a specific print range or with repeating headers.

Features

Files and printing

Worksheets can be losslessly exchanged between any version of PlanMaker on any operating system.
Open and save XLS and XLSX files from Microsoft Excel in an identical format to the original files, including password-protected files.
Open OpenDocument Calc in an identical format to the original files
Import and export assistant for text files and dBASE databases
Create PDF files directly in CITYWAY PlanMaker
PDFs with tags and bookmarks
Scale the printout so that it fits on a specified number of pages (five different scaling methods)
Print 2, 4, 8 or 16 pages on one sheet of paper (only in Windows)
Document preview directly in the file dialog

Extensive calculation capabilities

More than 430 calculation functions
Worksheets with 1 million rows and 16,384 columns
Calculation with complex numbers and array functions
Numbers can be formatted as currency units, with fixed decimal places and thousands separators, as percentages or fractions, as dates and times, etc.
Perpetual time format (20:00 + 5:00 is 25:00 and not 1:00) which also allows negative times
AutoSum, AutoProduct, etc.
AutoFill: intelligent filling of cell areas with values and rows of values
External references (calculations that access data in other files)

Editing worksheets

Freeze rows and columns
Syntax highlighting
AutoComplete for cells
Select and format multiple worksheets simultaneously
Sheet, workbook and document protection with encryption

Analyzing data

With pivot tables, you can display data in a targeted manner according to your individual specifications, or summarize it, sort it into categories, compare, evaluate or group it.
Goal seeker
Create database ranges within worksheets
Data grouping (outline view)
Sort by up to 64 columns
AutoFilter and special filters
Database functions for totals, averages, variance, etc.

Creating attractive worksheets

Cell styles as in Microsoft Excel 2021 and Excel 365
Conditional formatting as in Microsoft Excel 2021 and Excel 365
Borders, shading and fill patterns
Rotate and merge cells
Center across columns
Headers and footers (split into left, center and right sections)
Colored tabs for worksheets
Set the size of the tabs in the worksheet register

Pictures and drawings

Comprehensive drawing and picture functions: Draw and design directly in the worksheet with Excel-compatible AutoShapes
Insert pictures in a range of file formats
Change brightness, contrast and gamma of pictures directly in CITYWAY PlanMaker
Fill drawings with colors, patterns, pictures and gradients
Contour wrap
Connector lines between objects
Large symbol library for flowcharts and organizational charts
TextArt feature for font effects

Presenting and visualizing data

Powerful Excel-compatible chart module for impressive charts
Insert more than 80 different types of charts, for example, bar charts, histograms and pie charts
Each chart element can be individually formatted with any fill pattern or color gradient.
Impressive effects on charts: soft shadows, beveled edges, transparencies, lighting sources, etc.
Charts can be rotated in 3D space.

Extras

Fully Unicode-enabled, including Arabic
CITYWAY PlanMaker for Windows is an OLE server and can insert its worksheets and charts into any other program.
You can zoom and scroll with your fingers on touchscreens.
Spell-check in 85 languages with Hunspell dictionaries.
Automatic hyphenation in 35 languages