You all Supply Chain guys.. you know you need it.
Have you ever wondered how many items you need to keep in your warehouse to keep your customers happy?
This is the tool you were looking for. By automatizing Solver (and fixing with a code a major bug) and by facilitating interface through the use of a couple of forms, I created this spreadsheet that will allow you to save a lot of money with a single click.
Try it!
Spreadsheet: here!
Paper: here!
These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience
Monday, April 12, 2010
Subscribe to:
Post Comments (Atom)
Blog Archive
-
▼
2010
(150)
-
▼
April
(71)
- Using Excel as a Music Player
- Experimental Design and Conjoint Analysis
- ITunes Playlist Comparer
- Comparable Company Automation Project
- Text file manipulation with VBA
- Bryce Newbold's VBA Project
- Calculating and Graphing the Efficient Frontier f...
- Gift Card Reconciliation
- Personal Budget Spreadsheet
- BLS PPI Database Query to Analyse Year-to-Year Cha...
- ReportFileExecutive SummaryThe purpose of my VBA p...
- Home Salon Management System
- New York City Apartment Complaint ListingExecutive...
- Personal Finance Tool
- Sales Agent Scorecard Generation for Integra Telecom
- The Matchmaker
- Numerical Heat Transfer Optimizations in VBA
- Web Table Converter
- CRM Data Entry Segmenation - Chris Brasher
- Report System for The Pendulum Court
- ScheduAll Report Automation - Karl Rosengren - Win...
- Farr Appraising Market Conditions Report
- Portfolio Tracker
- Luke's Automated SWA Boarder
- Sync Department Data
- A First Step Towards User-Defined Financial Ratios
- Business Charge Entry / Invoice Manager
- Awesome Adobe Automation
- Textbook List Price Aggregator by Adam Cuppett
- Money Allocator
- Minchin Timesheet v1.0.25059
- A more accurate bid
- Kingdom of Loathing Market Dashboard
- CALLING ALL CATTLE! AUTOMATING SWA’S ON-LINE RESE...
- Business Broker Searches
- Cowtail Biomechanics Analysis
- Crime in Cities data compilation
- Sudoku Solver
- Report Generator for a Legacy System
- Ward Directory Creator
- Fraud Analyzer
- Valuation of a company. Calculation of NPV and Pri...
- Daily Sales and Inventory Control for Costco Retai...
- Customer Relationship Management & Analysis Progra...
- JJ Webb - FDIC data generation
- Generating iTunes Related-Artist Playlists
- ZIltch!
- Byron Mackay - Mariner Add-ons
- Option Pricing
- Potential Project Portfolio by Erik Wenzel
- Appointment Reminders Program - Micah Lorenc
- US Army APFT score calculator and automated Counse...
- Martech Computers Invoice Scraper
- iSYB Budget - Dustin Skinner (Winter 2010)
- Tory Betts Final Project
- U.S. Treasury TARP Report Generator - Ryan Wood - ...
- Copy Report Automation - Shauna Call, Winter 2010
- Easycache - a time saving tool for Geocaching.com ...
- Inventory Optimizer - Andrea Cordani, Winter 2010
- Get a Room! - Mark Tuttle - Winter 2010
- MyData info parser - Jeff Baxter - Winter 2010
- Whisk Recipe Organizer - Brandon Anderson - Winter...
- http://files.gove.net/shares/files/10w/kdl22/VBA_...
- Day Planner - Howard Kuan - Winter 2010
- Carman Violin Studio - Jesse Carman - Winter 2010
- MyComfort Product Tracker and Serial Number Genera...
- Financial Markets Update Service - Jason Merrill, ...
- MemoSend - Danny Patterson, Winter 2010
- Cinema Data Aggregator - Adam Solter, Winter 2010
- AutoRegister - John Wilson - Winter 2010
- VDC Requests - Kevin Brinkerhoff - Winter 2010
-
▼
April
(71)
No comments:
Post a Comment