Citadel5 GS-Calc Reviews and Details

Is Citadel5 GS-Calc good?

Social recommendations and mentions

• Any good beginner friendly books on Monte Carlo simulation?

  If some practical demonstration can be helpful, you can take a look at MC in GS-Calc, a 12 million row spreadsheet. Source: almost 2 years ago

• Moving away from massive spreadsheet?

  GS-Calc (a spreadsheet with 12 million rows) - a workbook with hundreds of millions of cells will be loaded in seconds (with e.g. 16GB RAM). Regarding lookups and filtering:. Source: over 2 years ago

• has their ever been a time where excel ended up being the best reporting tool for a particular task?

  Re: "a tool like Excel", the performance of GS-Calc can be helpful with some ad hoc very large data set transfers, filtering, etl etc. Some examples:. Source: over 2 years ago

• Software that sorts and can handle large amount of data?

  Another option: GS-Calc (a spreadsheet with 12 million rows). 12 million fast VLOOKUP's executed at once for 12 million row table will be executed in seconds. Same as the filtering. Source: over 2 years ago

• Which do you prefer vlookup or xlookup?

  You can compare this one in GS-Calc ( https://citadel5.com/gs-calc.htm ) 12 million fast binary lookup's within 12 million rows. Users don't have to bother with sorting - it's done internally, without any changes to the actual random row order in the worksheet. Source: over 2 years ago

• Large (1.4GB) Dataset causing slows/crashes. Is SQL the answer?

  Re: large data sets, if you're willing to try out another spreadsheet, perhaps GS-Calc could be helpful? It'll easily load multi-GB workbooks. Source: over 2 years ago

• Find all possible numbers that sum to a certain product

  If "something else", then you can use GS-Calc and Monte Carlo simulations. Source: over 2 years ago

• Fastest Lookups? XLookup, Index/Match or Filter??

  I tried this out in GS-Calc. The filtering function has slightly different syntax - each column has its own filtering expression:. Source: over 2 years ago

• How to build a database for Excel? Any free ones?

  Loading a GS-Calc *.gsc over 4GB file with over 500 million cells with random floating-point numbers and text strings (8 worksheets, ~12 million rows each) should take around 10-30s on a computer with 16GB RAM or more. Loading csv files and other file formats will be a bit slower. Filtering (regex/operators/formulas/duplicates) a few million rows should take a few seconds at most. Source: over 2 years ago

• Power Users: How big are your .xslx files?

  Around 1GB xlsx files, only as data tables, in GS-Calc / GS-Base (I mean, my customers do). Source: over 2 years ago

• How to replace sumifs?

  You can also consider GS-Calc. It has no limits re: references to other files, open or not, for any formulas/functions. Source: almost 3 years ago

• Looking for a Database Management Solution

  Re: a spreadsheet and thousands of worksheets, you can also take a look At GS-Calc. You can easily create/duplicate/copy/paste/edit/organize thousands of worksheets in subfolders in a given workbook. It's saved/loaded more or less instantly. Source: almost 3 years ago

• How to find and replace different values simultaneously

  Find & Replace with "Paul|John" (or "Paul|John|Fred|Jill" or "not Paul" etc.). However, you need to use some add-on for Excel that uses regular expressions or do this processing using another spreadsheet first: https://citadel5.com/gs-calc.htm. Source: almost 3 years ago

• User with large and growing excel file.

  Someone suggested a database, but to stay in the realm of spreadsheets I would also suggest GS-Calc ( https://citadel5.com/gs-calc.htm ). Source: almost 3 years ago

• CSV import - pulling in negative time spans

  Actually, btw, as you mentioned "of the user's choice", may I also suggest adding GS-Calc to the list? Aside from the above it also accepts period strings (like: P10Y11M10DT23H17M12.95S) for the date arithmetic. Source: about 3 years ago