“Ediciones Micromango” introduces on March 2007 its first publication; “El Mango de Pascua y otros cuentos”
por CheoChinPun. Visit CheoChinPun’ website and learn more about this fantastic children’s book.
Operation’s Trending System RDBS

Problem: The operations supervisor needs a tool that allows
him to over impose different data sets with a minimal programming interaction.
Data sets are constantly gather and saved by more than 50 sensors through out the plant. It is necessary to be able to visualize how this data set relates to each other under a time domain.
Solution: Build a database that will import flat tables into its RDBMS and create pre-defined queries that are flexible enough for the operator to add or remove data sets.
Result: The operator supervisor discovered different ongoing equipment malfunctions and vibrations out of range as well as inaccurate set points. Therefore, improving efficiency and predicting and preventing equipment malfunctions.
Utilities Management System

Problem: Management, Administrators, Supervisors need a way
to consistently access data that is been updated by different departments.
The data collects important information related to the Utilities Department essential functions and employees spend a lot of time asking colleagues for document latest versions, contact’s phone numbers, safety and building issues and location of project drawings.
Solution: To effectively manage all of these data and documents
from any console from any department, a comprehensive user interface is necessary to provide point-and-click connectivity and enforce strong access and control.
A good centralized management platform easily provides a solid return on investment in many ways. It lets you control, update, relate, edit and analyze most information required by employees. Also, all information is centralized and backed up every day. The information is maintained by all employees and always reflects the latest changes.
Result: The overall efficiency and productivity of the Utilities
department increased. Any CAD drawing can be found by any revision,
project name, title, draftsmen, manufacturer, etc. All safety and
building work orders are been addressed and account for. All contacts,
manufacturer, vendors, and consultant’s information is up to date
and easily accessible from any department.
AutoCAD/MS Access Frontends with SQL Backend Integration
AutoCAD/MS Access Frontends with SQL Backend Integration
Problem: Each Sub-Department at the Utilities Department of the University of Colorado at Boulder have specific requirements for spatial and spatial data and often, there is an overlap of information crucial to these sub-departments; operations, maintenance, management,
etc. Equipment data is stored and maintained in an SQL database with a frontend designed in MS Access. All spatial data is stored in vector based (AutoCAD) drawings. Supervisors and management want to use a frontend interface to access and analyzed spatial and spatial data
easily.
Solution: Design, create, implement and maintain a stable application database that can generate queries based on vector and spatial (text, number date) data. All graphical data are linked with attribute (spatial) data which are managed by a RDBMS. A solution needs to be developed using AutoCAD Map as a frontend with an SQL backend.
Result: Increased in cooperation and communication among departments.
Eliminated redundant spatial and aspatial data. Cleaner PID for all different systems of the Co-Generation plant. A substantial reduction of time used to track parts, quipment manufacturer, model, part number.
Enabled access to information across multiple departments apart from bringing in greater efficiency, speedy decision-making and transparency in the functioning.
Letter of Recommendation
Capacity Factor Estimator


Capacity Factor Estimator
Problem: Management needs to determine whether to buy electricity
or gas, when gas prices are low. An Xcel Energy contract establishes several parameters under which electricity will be bought from Utilities plant. There is no tool to perform a Cost-Benefit analysis into the
future.
Solution: This computer program evaluates the cost/benefit of selling electricity to public service vs. producing it. It is based on several intrinsic equations (from contract) that consider 12 month rolling calculations projected to the future.
Result: A simulation through June 05, using zero as capacity factor for one out of six months rolling average of 35%, shows another inconsistency in contract to be reviewed by Xcel energy.
Recognition Award
Dearator Tank
This invention is directed to a unique segmented plate and associated plate assembly technique, adapted for use where access is limited to an area/chamber within which the plate is to be secured and employed for use in connection with an enclosure.
Patent Application No. 10/643,358
Problem: Management needs to determine whether to buy electricity or gas, when gas prices are low. An Xcel Energy contract establishes several parameters under which electricity will be bought from Utilities
plant. There is no tool to perform a Cost-Benefit analysis into the future.
Solution: This computer program evaluates the cost/benefit of selling electricity to public service vs. producing it. It is based on several intrinsic equations (from contract) that consider 12 month rolling calculations projected to the future.
Result: A simulation through June 05, using zero as capacity factor for one out of six months rolling average of 35%, shows another inconsistency in contract to be reviewed by Xcel energy.
Launch Grapnel Hook
The main objective of this project was to increase production and finish a military contract within three months of operations. An even more important goal was to complete the task maintaining; a safe environment (no injuries reported), quality standards and reducing material waste.



