PHP - CSV Viewer for Web Browsers
Description
This PHP script opens and parses a CSV table file to an HTML view. It can be used together with the Internet of Things Web Logger Logger script.
Excel
PHP - Internet of Things Web Logger
Description
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.
Excel - Pivot tables with text values or numbers without calculations
Objectives
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.
Fuel consumption spreadsheet
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.
Spreadsheet for the Water Ionic Balance
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.
Spreadsheet for Brazil import tax calculations
This spreadsheet calculates the importation taxes to Brasil based on the regulations from 2012 to 2020 (still valid)
Spreadsheet - Slow sand filter design
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.
Swimming distance, speed and time conversion table
This spreadsheet put together paces, speeds and time for swimming.
PHP - Form2CSVTable
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.
Requirements
- Read/Write permissions of the script folder or destination file (safer).
- PHP version > 4.0
License
GNU/GPL
