Open Source Spreadsheet Software - Page 5

The csvdatamix project aims to randomize CSV input data files in order to conceal the original state of the data. Similar to data masking or data transformation. Also has mapping abilities to translate back to the original state of the data.

Un programa de Excel que calcula aguinaldos, antigüedad, indemnización, salarios variables, horas extras y los gastos anuales de su salarios (analizado por departamento y tipo de remuneración).

Ratios are useful in analyzing the strength of business and molding the strategies in a way that would benefit as a whole. Ratio calculations may be a tedious job and may result in error even if there is a minor mistake. Moreover, arranging all the values and deriving out the ratio can’t be done easily by anyone but specialist in accounts or finance is required.

This is a simple utility to track the amount of time a PC is used. It can the used to determine 1. whether PCs are being used optimally, e.g. internet cafe's. 2. productivity (similar to punchcards). 3. sleep/wake cycles or bipolar cycles.

CppExcel is an unmanaged, stand-alone, platform-independent C++ library for reading and writing native Microsoft Excel 2007 XLSX and 97-2003 XLS files, without Excel needing to be installed. CppExcel is based on the PHPExcel library.

Disa is an ip based geo locator project. that uses data from http://www.hostip.info/

DocsFree is the first and only open source java-based Docs App Server. DocsFree is offered as an alternative to proprietary Docs solutions MS Office Online and Sharepoint, as well as to proprietary Docs SaaS offerings such as Google Docs.

We have develop data mining 'Plug and Play' WYSIWYG Tool on commercial ERP Baan IVc4 which uses Baan 4 GL as extract and transform engine and MS excel as load client . For more information about the tool and the company , please visit www.erpjewels.com

ErgoTabcalc is a general calculation and report system. Calculation sequences are stored in the database. These sequences are made from simple operations on data, eg, add two table columns, or sort a table. This is similar to relational algebra.

This open source library allows you to display System.Data.DataTable objects in Excel with titles, totals and number formating. It uses Reflection and late-binding, and is therefore compatible with multiple versions of Excel.

https://sourceforge.net/projects/in2sql Video for best usage https://rb.gy/tvl8lk This Excel Addin helps SQL analytic create an Excel report based on ODBC relational data. *Creates table base on data from a relational database *Generate a pivot report using the same external connection (1) *Some ad-hoc tools are available - like "keep only" and "remove only" *you can use the row limit option for exploring the largest dataset *The ODBC connection manager is available *auto-build query tool can create SQL select statement by using different database tables with matching them by column name * creating connections for PowerQuery news and updates -- change list -- v05 beta export tables and SQL to CSV files treat CSV like relational tables -- add Cloud ClickHouse Source resolve the problem with an untrusted source changed Sql Editor fixed behavior for "update rows"

Excel Quick Reports is a set of tools intended for quick WYSWIG prototiping and publishing of quality Excel reports (in Excel XML format). Reports are rendered using automatically generated XSLT and XML data extracted from database.

convert XML to Excel file tool. Use XSLT and Xpath in XLS file, convert xml file to XLS file. You can defined format in XLS file, and write xslt in XLS file.

FIX Agora is a peer-to-peer OTC trading network for financial institutions with an integrated order management system. The application can act as buy side and sell side. FIX Agora supports indicative quoting, multi inquiries and processing of order requests. It is equipped with multiuser spreadsheets for price calculations as market maker. FIX Agora ships with the option for exporting trade reports into Excel® sheets and SAP® Financial Supply Chain Management (requires SAP® JCO). The application is client/server based, modular and extensible. FIX Agora is working with the Financial Information eXchange ("FIX") protocol. The FIX protocol is an industry driven standard for the electronic communication of trade related messages, released and maintained by FIX Protocol, Ltd. FIX Agora is a 100% Java open source implementation running on Windows, Linux/UNIX and Mac OS (client only). It requires Oracle® JRE version of 1.6 or higher.

Desarrollo de un sencillo programa para facturación electrónica de acuerdo a la legislación mexicana

The FastForward framework allows fast development of 3-tier spreadsheet applications. The spreadsheet is used as a browser, which can send and receive data. The project implements a spreadsheet add-on and data manipulation library for the web server.

This is a finances manager that can help you control your finances.

Fiscal Calendar in Excel generates an elegant calendar based on the year you type into cell J1, with July 1 being the first day of the fiscal year. The fiscal month begins on the last Monday of the previous month with a full work week (5 days). For example, the Monday ten days before Thanksgiving will be the first week of fiscal month December (November 13 in 2017). Fiscal Calendar in Excel allows you highlight certain business days each month and it'll highlight holidays every year. If you don't like the automated dates, manually set them on the second sheet.

FlexiSheet is a multi-dimensional spreadsheet in the spirit of Lotus Improv. FlexiSheet runs on MacOS X.

Calendar for freelancers. You keep customers , incomes , outcomes , tasks also. Of course your secretary or parthners or anyone who has internet access and the password can use it too. Visit now WWW.VALID.GR for DEMO....

The application can be used for administrating all costs around your vehicle, you're able to add your tankfill and several special payments as insurance and motor vehicle tax. It will able to generate different statistics and reports.

This Perl utility script will allow you to quick strip the split or utility file and display transaction month and year information. It is intended simply to save time when uploading using that export in any spreadsheet tool to perform analysis.

gspread is a Python API for Google Sheets. A service account is a special type of Google account intended to represent a non-human user that needs to authenticate and be authorized to access data in Google APIs [sic]. Since it’s a separate account, by default it does not have access to any spreadsheet until you share it with this account. Just like any other Google account. To access spreadsheets via Google Sheets API you need to authenticate and authorize your application. Older versions of gspread have used oauth2client. Google has deprecated it in favor of google-auth. If you’re still using oauth2client credentials, the library will convert these to google-auth for you, but you can change your code to use the new credentials to make sure nothing breaks in the future. If you familiar with the Jupyter Notebook, Google Colaboratory is probably the easiest way to get started using gspread.

HSSFTemplates is a Servlet based template processor built around the Jakarta POI project. It has been moved to the Carbon Five Open Source project where its been renamed SST.

A tool to query arrays in memory using SQL. It groups the arrays in tables and returns arrays as result set. It can be used in spreadsheets, as a script language library and everywhere is needed an interactive tool to query data in memory.