GroupAssignment2_Instr - OPIM101 Spring 2008 Group...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
1 OPIM101 Spring 2008 Group Assignment 2: VBA – Asset Allocation Due: Thursday, April 10, 5PM This Group Assignment builds directly from Part 3 of Group Assignment 1. You have built the foundation of the problem by hand. Now imagine that your boss has given you a new list of stocks and a different number of trial points that need to be completed…and she needs it in the next five minutes! In order to avoid this situation in the future, you decide that you want to automate the process this time. With a click of the button, your portfolio will be created. This assignment will help you to do just that. Instructions: GA2 must be completed in groups of 2-3. Your solutions should be submitted as an Excel file. Do not turn Excel’s Auto Update OFF for this project! Make sure you have the Solver add-in installed in both Excel and VBA Please follow the same naming convention as that used in Group Assignment 1: List your team members on the Coversheet sheet of your excel file. Names should be listed in alphabetical order by last name . Please use the names printed on your PENNID card. Include the corresponding PennID numbers for each group member. Your PennID numbers are the middle eight digits on your PennCard. Note that your assumptions in the assignment are unique to these PennID numbers. Therefore, different groups will start out with different assumptions and inevitably have different answers. Your file should be named “GA2”(no white space between the initials GA and the number 2 . Then, separating each word by an underscore “_”, list the members of your team in alphabetical order by last name. For the example list in the template file, the filename should be: GA2_Leno_Jay_Letterman_David_Winfrey_Oprah. 5 points will be deducted straight away if this naming convention is not followed. Turn in your solution to Group Assignment 2 by sending the Excel file as an attachment to . In the Subject line of your email message, you should type the name of your file attachment (e.g. if you and your teammates were named Jay Leno, David Letterman and Oprah Winfrey, your Subject line should read: “GA2_Leno_Jay_Letterman_David_Winfrey_Oprah”. Be sure to cc yourself and your group members on the email to ensure that your mail has been sent properly. Check the message that you cc to yourself to ensure that the template is attached and that the attached file is the correct version of your file. Save your copy of the message with the attached assignment in the event of problems in processing your email.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2 Read through the entire assignment before beginning (More detailed instructions are listed below). After you finish reading but before you start programming, you should open the template for Group Assignment 2 and review the different subroutines and ‘outlines’ that have been provided. Your entire assignment should run by using only the subroutines that are defined in Module 1 of the assignment template. You should not
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 12

GroupAssignment2_Instr - OPIM101 Spring 2008 Group...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online