Transcript Click to add Title

Techniques Used in DoD Projects
(applicable to any project)
•Gantt charts
•WIP tracking
•Database Connectivity
•Tanks
Ship Design
Newport News, Va.
USS Monitor
ProModel – USS Monitor (not really)
Gantt charts
• Write to Excel
– Start/Stop times
– Attribute data
– Other stuff
• Use ProModel tools to generate Gantt Chart
Gantt charts
WIP tracking
• Write a Log file (.CSV) of Entries & Exits
• Use Excel to:
– Filter for a Time Snapshot
– Create a Pivot Table…
Use Pivot Table Wizard to compare Entry vs. Exit
– Plot as needed
WIP tracking
WIP tracking
WIP – Quantity of Widgets in Storage Locations
Database Connectivity
• Array Import – Already Available
–
–
–
–
XLS
Worksheet
Range
Good… But must Open/Close XLS each time
• Array Import – Database (NEW!!)
– Connection String
• Standard protocol
• www.connectionstrings.com
– Query or Store Procedure
• SQL
• Excel range
• (other spec)
– Better… Does not need to open XLS
Database – Connection Strings
Database - Query or Store Procedure
Connection String
Query or Store Procedure
Tanks
• Subroutines
• Very Powerful & Flexible
• Requires programming skills
Tanks