This is a PHP script that records data from Internet of Things (IoT) devices in a CSV spreadsheet that can be opened from Excel. If you also need a web view for the log, check the CSV Viewer for Web Browsers.
Create a Pivot table that displays text data or number values that are not summarized (count, sum, etc...). This solution does not require macros or long search/replace functions, just the Microsoft Power Query tool that comes with Excel 2016 or can be installed for free as an add-on in previous versions.
This spreadsheet calculates and keep track of the fuel consumption of vehicles. The result can be displayed in several ways including averages, statistics, graphics and multiple units. The main advantage of this spreadsheet compared to others is the ability to handle partial tank fills.
Last, the spreadsheet is not password protected so you can customize-it as you like.
This spreadsheet allows the determination of the water ionic balance based on it´s constituents. The ionic balance is required for Reverse Osmosis and Ion Exchange plant designs.
The functionality of this spreadsheet is available on an improved version in the Plutocalc Water application.
This spreadsheet allows the design of slow sand filters. This water treatment technology does not require expensive equipment or chemicals (coagulants, polymers, limestone, etc...) and can be used in small communities and villages.
All calculations and rates are following the Brazilian Standard NBR 12216/92. The spreadsheet is in Portuguese and in English.
This application will convert all data submitted by an HTML form to a CSV table located in the same folder as the script.
The generated CSV file follows the RFC4180 standards.