Services We Offer
Spreadsheet Alchemy promotes, designs, creates, and supports a wide range of automated solutions using Microsoft Excel. We customize our deliverables to your specific needs and desires. Even if you have simply an abstract or conceptual idea of what your vision is for your organization’s solution, we can help. Spreadsheet Alchemy can assist in defining and proposing several options and alternatives that meet your overall specifications. One of our strengths is our ability to see beyond the immediate identified expressed need. Many institution’s processes and existing systems are heavily linked; our custom applications and specialized training will likewise be constructed to allow such integration.
Training
If your desire is to simply understand the power of Excel to be able to create your own custom applications, Spreadsheet Alchemy also offers hands-on training. Our focus is instruction in the intermediate to advanced capabilities of Excel and VBA (its embedded programming language). We can provide training sessions geared toward your audience’s current knowledge/background and targeted directly to their job responsibilities on a topic-by-topic basis.
Our Excel training sessions are flexible given your employees’ schedules and can range from a half-day to multiple days, spread over several weeks if desired. Every training session is crafted specifically to our clients’ needs and will include only those topics of interest. Our training materials and approach are compiled individually for each customer. Because learning Excel is ideally an immersive experience, all our training sessions should be conducted in a computer classroom on-site at your facility. Participants are encouraged to bring their own ideas to work on during the workshop so that following the training, they have a workable, tangible result to share with others.
Please visit our Training page on this website for more information.
Custom Solutions
If you wish to engage Spreadsheet Alchemy to collaborate on development of a custom-based solution, we are committed to assisting you with both the design and implementation of your vision. The list of topics below may be helpful to show the numerous potential avenues for exploration. All of these topics represent real applications that have previously been developed by the founder for past employers or clients using Microsoft Excel.
Engineering and Financial Tools
- Aircraft Thermal Management Systems and Environmental Control Evaluation
- System-Level Architecture Reliability Assessment
- Mission Analysis and Penalty Evaluation of Subsystem Options
- Aircraft Life Cycle Costing & Cost Of Ownership
- Uncertainty Analysis and Probability Distribution for Decision-Making
- Chemical Engineering / Thermodynamics / Heat Transfer Algorithms
- Neural Network Analysis of Product Characteristics
Educational and Administrative Tools
- Scheduling Analysis by Faculty, Classroom, Course, and Time of Day
- Enrollment Prediction Analysis by Course and Section
- Faculty Load Analysis – Class Assignments and College Service Tasks
- Instructional Minutes Evaluation by Course Schedule
- Adjunct Faculty Workload Calculator
- Historical Course Schedules by Academic Year for Curriculum Discussions
- Academic Assessment Data Collection and Reporting
- Individual Student Guided Pathway Creation for Advising Support