Messages

1

Found Deals and Discounts / GS-Calc 50% discount [2025-05-20 - 2025-05-22]

« on: May 20, 2025, 02:09 PM »

GS-Calc - A modern spreadsheet with Python integration - https://citadel5.com/gs-calc.htm

• 4GB+ workbook files, up to 500GB data size in RAM.
• 32 million rows x 16,384 columns.
• Organizing worksheets in a tree form, multiple windows, up to 100 panes in a window.
• Efficient memory usage to quickly load and save huge files.
• Fast pivot tables (25 data functions vs 11 in Excel), no limit for variables in the solver functions.
• Using up to 64 processor cores during calculations with almost 500 built-in functions.
• UDF Python functions can also be used as "spilling" formulas and can return to GS-Calc, for example, images/charts or entire loaded CSV files.
• Built-in functions can be replaced by user-written equally fast C++/C functions and retain the same "spilling"/array and multicore functionality.
• All functions can refer to any number closed workbooks.
• Unlimited hyperlinks, conditional formatting.
• "Sparklines" available as a formatting style or the Google SPARKLINE() function and can be use without any limitations.
• Fast loading text/CSV files with up to 1 million columns and 32 million rows (or any number of rows with automatic splitting).
• Each sheet can be split into up to 100 panes synch. by columns or/and rows.
• GS-Calc can be installed on any portable storage device and used without performing any registry modifications.

Rebate code: dcod551

2

Found Deals and Discounts / GS-Calc, GS-Base 50% discount [ 31/12/2024 - 1/1/2025 ]

« on: December 30, 2024, 03:32 PM »

GS-Calc - https://citadel5.com/gs-calc.htm
A spreadsheet with unique capabilities for processing big data sets (4GB+ workbook files, up to 500GB data size in RAM).

• 32 million rows x 16,384 columns.
• A unique feature of organizing worksheets in a tree form.
• Efficient memory usage to quickly load and save huge files.
• Fast pivot tables (25 data functions vs 11 in Excel), no limit for variables in the solver functions.
• Using up to 64 processor cores during calculations with 450 built-in functions.
• Built-in functions can be replaced by user-written functions and retain the same "spilling"/array and multicore functionality.
• All functions can refer to closed workbooks.
• Unlimited hyperlinks, conditional formatting.
• Fast loading text/CSV files with up to 1 million columns and 32 million rows (or any number of rows with automatic splitting).
• Each sheet can be split into up to 100 panes synch. by columns or/and rows.
• GS-Calc can be installed on any portable storage device and used without performing any registry modifications.

Code: hz6q11s

GS-Base - https://citadel5.com/gs-base.htm
A database that lets you store any type of data: text and numeric fields, dates, long text memo fields, files, images, code snippets with syntax highlighting for 16 programming languages.

GS-Base can be useful for both simple applications like organizing your photo collections and extracting EXIF tags from photos or analyzing/monitoring your disk contents and to rapidly clean, transform using regex, analyze, perform merges and joins for multi-GB data sets with up to 256 million rows.
You can:

• perform both simple and complex record filtering, searching for duplicates, for unique values and frequencies, full-text searches, find-as-you-type, fuzzy searches, searching quartiles, random searches and one-click statistical breakdown analysis. You can use unlimited in-cell charts to spot trends;
• find file/photo/mp3/mp4 duplicates, manage listings of all disk files and monitor their changes; play found mp3's in any order;
• mass copy/rename/move files from filtered disk listings;
• analyze very large data sets using pivot tables with up to 256 million rows and 16,384 columns. You can use around 300 built-in calculation function in calculated fields, for data validation and conversion. GS-Base can use from 1 to 100 processor cores when updating calculated fields and pivot tables;
• use GS-Base files as encrypted containers for any type of data/files in their original formats.

Code: Tp62371

3

Found Deals and Discounts / GS-Calc 20.7 50% discount [ 5/15/2024 - 5/17/2024 ]

« on: May 14, 2024, 08:32 PM »

A spreadsheet with unique capabilities for processing big data sets. You can edit large CSV files with millions of rows, XLSX files that are automatically split and merged, build complex data models e.g. with millions of look-up formulas that are opened/updated almost instantly and clean, transform, publish multi-gigabyte data sets.

* 32 million rows x 16,384 columns - the number of worksheets and subfolders is unlimited. No limit for the file size (4GB+). Large text, CSV files exceeding the 32M/16K limits are automatically split into multiple sheets and saved (then load/read/edited) together in one zip.

* Up to 500GB of data per worksheet.

* Pivot tables with 256 million rows and numerous data functions (e.g. 2x more than in Excel).

* Monte Carlo Simulations to easily estimate risk in business, costs, future pensions or simply to reverse-calculate formulas etc.

* Charts easily handling millions of data points.

* Fastest lookup functions using binary algorithms.

* Up to 64 cores used when updating worksheets and pivot tables.

* Around 450 built-in functions, solver functions with no strict limits of variables.

* All functions can access data from any number of closed workbooks.

* All functions can be redefined/rewritten by a user, and you can add any number of new functions (having the same properties as the built-in ones: automatic full multicore calculation support, "spilling"/array usage etc.).

One-time fee payment ($19.50), no subscriptions. Free new versions for 12 months. GS-Calc can be installed on any portable storage device and used without performing any registry modifications. No internet connection needed. Not tied to your hardware.

Sample videos:

• Using a 2.37GB workbook with i5, 16GB RAM & HDD: 32 million formulas and 300 million random number/text cells.
• Using the FILTER() function to filter 3.3 million rows.
• Creating a script in GS-Calc to mass-import tables from CSV/text/xBase/xlsx files
• Using MonteCarlo simulations to find sets of 100 numbers that add up to a give value.
• MonteCarlo simulations in GS-Calc to find linear programming solutions.
• 12 million fast binary VLOOKUP's in GS-Calc.

Home page: https://citadel5.com/gs-calc.htm

Ordering: https://citadel5.com/ordering.htm

Discount code:  dc39f21    [ 5/15/2024 - 5/17/2024 ]

4

Found Deals and Discounts / GS-Base 20.3 50% discount [ 4/26/2024 - 4/27/2024 ]

« on: April 25, 2024, 03:19 PM »

GS-Base is a database that lets you store any type of data: text and numeric fields, dates, long text memo fields, files, images, code snippets with syntax highlighting for 16 programming languages.

GS-Base can be useful for both simple applications like organizing your photo collections and extracting any EXIF tags from photos to find photo duplicates or similar photos, playing filtered/random mp3 files, or listing all your disk files, monitoring file changes and adding any type of metadata to files, to clean data, transform using regex, analyze multi-GB data sets with up to 256 million rows.

You can perform both simple and complex record filtering, searching for duplicates, for unique values and frequencies, full-text searches, find-as-you-type, fuzzy searches, searching quartiles, random searches and one-click statistical breakdown analysis. You can use unlimited in-cell charts to spot trends.

You can also analyze very large data sets using pivot tables with up to 256 million rows and 16,384 columns. You can use around 300 built-in calculation function in calculated fields, for data validation, cleaning and conversion. GS-Base can use from 1 to 100 processor cores when updating calculated fields and pivot tables (e.g. Excel: 11 data functions, 1 million rows; GS-Base: 25 functions, 256 million rows, full regex filtering).

GS-Base can filter text/CSV files of any size regardless of the installed RAM. With GS-Base things like performing tables joins, normalizing (splitting) tables, merging records are easy and fast, even for millions of records.

GS-Base can be installed on any portable storage device and used without performing any registry modifications. It requires around 10MB of free space and it's fully offline - no internet connection needed.

Home page (details, screenshots, videos, online html help):
https://citadel5.com/gs-base.htm

Ordering:
https://citadel5.com/ordering.htm
Discount code:  dc49824     valid: 4/26/2024 - 4/27/2024 (GMT)

5

Found Deals and Discounts / Re: GS-Calc 18.7 50%off for 24h

« on: March 26, 2023, 01:45 PM »

Thanks. As this was one day only and around the weekend, in case someone overlooked it and still would like to use this offer (or has any questions), please feel free to email me (for the code) on Monday 3/27 as well.

6

Found Deals and Discounts / GS-Calc 18.7 50%off for 24h

« on: March 24, 2023, 09:18 AM »

GS-Calc is a full featured spreadsheet that can be used for editing huge files and to build complex data models with millions of formulas and GBs of data.
Worksheets and pivot tables can use 12 million rows. No limitations for using cell references to external closed workbooks.
No limitations for the number of hyperlinks. Users can add their own DLL libraries with new functions or functions replacing the default ones, with the same performance, dynamic array ("spilling") functionality and multi-core calculations. Extensive use of regular expressions in the built-in functions (Filter(), Find(), lookups) and Find&Replace functions. Automatic use of binary searching in lookup functions with any number of ranges sorted in the background.

Opening an over 4GB workbook with over 500 million cells with random floating-point numbers and text strings (8 worksheets, ~12 million rows each) should take around 30s on a low-end office pc with 16GB RAM.
Filtering (regex/operators/formulas/duplicates) a few million rows should take a few seconds (and the result can include millions of rows as well).
GS-Calc can be installed on any portable storage device and used without performing any registry modifications.

https://citadel5.com/gs-calc.htm

dcode3Gq7  50%off $9.95 [for 24 hours]  incl. free new versions for one year

12 million fast binary VLOOKUP's in GS-Calc
https://www.youtube..../watch?v=EoRQghsNZUI

Saving/loading workbooks with 12 million rows and 100 million cells
https://www.youtube..../watch?v=-_pn8rbfrNg

Creating a script in GS-Calc to mass-import tables from CSV/text/xBase/xlsx/MySQL files
https://www.youtube..../watch?v=kmE1-IMInbY

7

Found Deals and Discounts / GS-Base 18.5 50%off for 24h

« on: March 15, 2023, 05:39 PM »

GS-Base - a database with spreadsheet functions and up to 256 million rows.
Pivot tables (with the same max number of rows), around 300 functions in calculated fields. Filtering (regex), searching for duplicates, for unique values, search-as-you-type, full-text searches, fuzzy searches and so on. GS-Base uses up to 100 processor cores to perform field and pivot table calculations.
Opening an over 0.5GB csv text file with 20 columns and around 3.5 million rows can take several seconds on a low end pc. Loading about 12GB MySql *.sql file with over 10 million records and Long Text (Memo) fields can take around 2 minutes. Filling a field in a 150 million record set with some 1...n sequence will take a few seconds. Same as filtering a field using regular expressions. 150 million records with four text field containing up to several characters each with calculated fields and formulas can use around 15GB of RAM.

https://citadel5.com/gs-base.htm

dcode2e08  | 50% off [for 24 hours]

8

Mini-Reviews by Members / Re: GS-Base Mini-Review

« on: August 02, 2016, 08:14 PM »

Hi,

For what it's worth, my two cents to this discussion:

1. The website and every other docs clearly state that you can log on to the download page to download the latest versions for 12 months for free. And it's clear that the page always displays the latest versions only.
(I do what I can to educate users that the license doesn't "expire".)

2. Almost all old versions are still on the website. For the full versions, it's sufficient to e-mail the support, which (un)surprisingly some users do.
Trial versions dating back I guess 10 years are free downloads all the time.

3. It's ca 2MB. Not 2TB...

4. Hope that the respective modifications to the download page will be implemented rather sooner than later. It was requested by other users and it's surely is going to be helpful.

5. IMHO captcha is easy(?). An easier registration method means verifying (addresses, IPs) 10-20 spambot submissions a day. (Unless this can be done automatically for the phpBB forum.)

Thanks,
Citadel5

9

Found Deals and Discounts / Re: GS-Calc (spreadsheet, 32- & 64-bit) 50% off till May 14.

« on: May 10, 2014, 11:03 AM »

Thanks for the discount, took advantage of the offer. I actually had a use for an earlier version a couple years ago, the row limit in Excel was too small for what I needed even though the calculations were fairly simple.

Excel 2013 still has a column advantage (16k over 4k, which is also Libre Office's limit) but Excel and Libre Office are both stuck at 1 million rows.

-x16wda (May 09, 2014, 07:36 PM)

Thanks.
Rebuilding would be sufficient to increase that limit to 16K (or to 64K max, without changing the code) in GS-Calc, but verifying that there are no performance issues for various functions/actions might take much more time.

Anyway, further increasing these (row and column) limits for both GS-Calc and GS-Base is on the todo list.

(If you would like to, please feel free to e-mail me something more about the type/size of data you're
using. Just curious.)

Best regards
Citadel5, www.citadel5.com

10

Found Deals and Discounts / GS-Calc (spreadsheet, 32- & 64-bit) 50% off till May 14.

« on: May 09, 2014, 09:46 AM »

Hi,

GS-Calc is a spreadsheet for Windows. Both 32- and 64-bit are available. 50% off till May 14.

Btw, any comments and suggestions (via e-mail, support forums or this forum) concerning the current functionality, possible improvements, other OS support etc. will be appreciated.

Main features:

• 12 million rows x 4,096 columns.
• Organizing worksheets in a tree form.
• Efficient memory usage to quickly load and save the largest files.
• Fast pivot tables, optimization and other advanced statistical functions.
• Using up to 16 processor cores during calculations.
• Working in up to 100 synchronized panes.
• GS-Calc can be installed on any portable device and used without performing any registry modifications.
• Free new versions for 12 months from the date of purchase.

Home page:  http://www.citadel5.com/gs-calc.htm
Trial version 64-bit:  http://www.citadel5.com/gscalc11.6_x64.exe
Trial version 32-bit:  http://www.citadel5.com/gscalc11.6_x32.exe
Ordering form:  http://www.citadel5.com/ordering.htm

Thanks!
Citadel5, www.citadel5.com

11

Found Deals and Discounts / Re: GS-Base - 50% off

« on: April 02, 2014, 04:35 PM »

Thanks. Yes, it's as the nick suggests - I'm the author of GS-Base.

Re: the default file format, this is a native/private ("partially binary") file format. Nevertheless it should be quite safe as all the data is stored in the zip file in its original format. That is, tables with records as plain utf-8 text files, memo files as *.txt or *.rtf files etc.
To clarify this better I just uploaded a page from the help file:

http://www.citadel5.com/help/gsbase/file_format.htm
(Just one page at this time.)

The supported file formats are listed on the homepage: dBase, Clipper, FoxPro, text, XML, Excel XML, HTML, PDF. (XML, PDF - export only.)

The coupon is valid for GS-Base licenses only.

12

Found Deals and Discounts / GS-Base - 50% off

« on: April 01, 2014, 04:44 PM »

A database with some spreadsheet features. 50% off till April, 8.

• 12 mln records in one table; 2,047 fields in one record; any number of tables in one file.
• Versatile record filtering methods, searching for duplicates, full-text searches and quick statistical breakdown analysis.
• Printing serial forms, letters/reports and any type of mailing labels.
• Sending serial personalized e-mail messages with customized attachments.
• Creating and editing text, dBase, Clipper and FoxPro files.
• Pivot tables with up to 12 mln rows.
• Around 300 built-in calculation function used for calculated fields and data validation.
• GS-Base can be installed on any portable device and used without performing any registry modifications.

Homepage: http://citadel5.com/gs-base.htm
Sample screen: http://citadel5.com/images/gsb12_scr1.png
Trial version: http://citadel5.com/gsbase12.exe  (1.85MB)