topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • Tuesday July 23, 2024, 11:18 pm
  • Proudly celebrating 15+ years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Topics - Citadel5 [ switch to compact view ]

Pages: [1]
1
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 ]



2
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)

3
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



4
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]

5
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



6
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)


Pages: [1]