Project #1

Due: Monday, 6 April, 2009

Create an EXCEL 2007 model for the crane you were assigned in class. The interaction with the model will be through a dialog box.

 The dialog Box should appear automatically when the file is opened and should contain at least:

 Input Output Navigation controls to
Height of building Distance from crane to building Display geometry of lifting
Height of payload Radius of lifting View of crane
Depth of lift Length of boom Table of allowable payloads
Safety clearance Maximum allowable payload Main Dialog Box (on each user accessible sheet, not on the dialog box)
Payload Indication if the lift is possible or not  
Rigging

 

Grading: 0-100

 

  • Requirements for dialog box:
  • 30 p. (2p/req.)
  • Lock access of user to workbook:
  • 5 p.
  • All variables named (range name) and marked (à ):
  • 10 p. (1p./variable)
  • Drawings & tables
  • 5 p.
  • Correctness of model
  • 20 p. (-5p./mistake)
  • Correctness of macros
  • 20 p. (5p./macro)
  • Completeness of solution
  • 10 p.

 

Submission: DropBox. Link Name: 9:15 Project 1, 10:40 Project1 or 3:15 Project1, as appropriate. File name: As stated in the file-name convention. Name ends with "_P1" for "Project 1".

Deadline: 1 minute prior to lecture time on Wednesday, 1 April, 2009.

Bonus: up to 20 points for exceptional additions to your model. To qualify you have to bring the additions to the attention of the instructor through an accompanying note to your submission.