ComputerScienceGroup.com© Home Page
Featured Now |  Upgrade Texas Emission Inventory Export/Import Macro Spreadsheet - version 1.0.9 (02/23/2010 18:33) | | This macro spreadsheet contains the latest excel macros used when exporting Texas Emission Inventory data to Excel. If you have already exported to Excel, download this macro and update your spreadsheet. You can upgrade any spreadsheet for any table. See the Step-by-step guide for detailed instructions. |  | Texas Emission Inventory Step-by-Step Guide - Updated 02/23/2010 | | This is a step guide covering the steps necessary to use ComputerScienceGroup.com to prepare the annual Texas Emission Inventory report in the electronic format compatible with STEERS. It covers everything from logging in to the FTP site to copy extract files to the server to creating a delta file. 02/22/2010 - Updated to include instructions on setting Excel macro security. 02/23/2010 - Updated to show how to enable FTP and upgrade a Texas emission inventory macro spreadsheet. |  | Texas Emission Inventory Data Tools | | Use these tools to QC FIN/EPN data, remove blank FIN/EPN Characteristics, QC Emissions and much more. ComputerScienceGroup.com was tested repeatedly against a TCEQ provided list of common validation errors so that validation to STEERS is bullet proof. | | Texas Emission Inventory Reports | | These reports provide certification summaries, analysis, system table data and much more. All reports are created and displayed in a scrollable grid with filtering. Reports are available for download to Excel spreadsheets for registered users. | | State Wide Texas Emission Inventory Statistics by Contaminant | | This report shows a summary of state wide statistics from historical Texas Emission Inventory data for at least ten years. The sum, average, standard deviation, variance, min, max, and count are provided for each contaminant reported over the historical period. This report is available for download to Excel spreadsheets for registered users. |  | Interactive Charting of Texas Emission Inventory Emissions | | This spreadsheet interactively charts for trending annual emissions over a ten year period. Simply click on a column to select a contaminant and the data in that column will be charted. Licensed users can download historical emissions data for any number of accounts using the Excel export feature. |  | Interactive Calendar Spreadsheet | | The Interactive Calendar spreadsheet uses calendar data to create printable calendars when a year and month is selected from a drop down list. Licensed users can download calendar data for account and user tasks, account and user events, and reminders. |  | Texas Deviation Reports and Texas Annual Compliance Certification Reports | | The Texas Deviation Reports page allows you to enter deviation report data which is saved to our secure SQL Server database. Deviation report data can be downloaded to interactive Excel spreadsheets to create the printable Texas Deviation Reports and Texas Annual Compliance Certification reports. Licensed users can create interactive spreadsheet reports on demand. | | Microsoft® Excel Resources | | ComputerScienceGroup.com© has integrated the latest web technologies with Microsoft® Excel so that data sharing with our secure Microsoft® SQL Server can easily be done with your spreadsheets. We have developed hundreds of Excel macro spreadsheets that illustrate techniques for sharing Excel spreadsheet data with databases, sending email from Excel, creating Word documents from Excel spreadsheets, and much more. Licensed users can download hundreds of Excel macro spreadsheet examples from our Excel macro spreadsheet library. |
Delete InsertSelect Update
Copyright © 2010 Computer Science Group, LLC
Version 3.0.1.5 Last Revision: 3/9/2010 8:44 PM
|