Loading
HomeOther Help › Information systems class.
Status: Completed
Information systems class.
Date Posted: 19/02/2021
Category: Other
Due Date: 21/02/2021
Instruction
Summary of the Project Assignments and Details: Create a flowchart for the process of completing an estimate for a single-tour. You are not required to create a flowchart for the Run Batch process. Upload this flowchart separately from your completed workbook in the file upload box below (to facilitate grading). Download the Olympus Tours Programming Project Worksheet below. Do not make your own workbook. Add VBA code to complete the project. Your VBA code should work with the cells that are already positioned on the [User Form] tab of the workbook. Do not change the cell locations or layout on the [User Form] tab within the workbook. In addition, do NOT add or delete any columns or rows. Use VBA to do all of the calculations. Do not use spreadsheet functions. Add your VBA code to the two existing sub routines that have been started in Module1 already within the workbook. Add your code to the sub routine named EstSingle() that will run when the user presses the Run Single Button. Add your code to the sub routine named EstBatch() that will run when the user presses the Run Batch Button. Connect the appropriate subroutine to the respective buttons, so that the correct sub routine will run when the button is pushed. In your code, use the Option Explicit setting for both subroutines. (This should already be set.) Verify this by ensuring that the first line of code says “Option Explicit.” Use Dim statements to declare all variables that you use in your code. Declare the variables as the data types shown on Column D of the [User Form] tab. Test your program with a variety of inputs to ensure it works properly before you turn in your assignment. You do not need to calculate PPBR or EHP. Rather, your sub should take whatever values of PPBR and EHP are provided by the user in the setup variables section in the single estimate user form. Upload your completed Excel workbook in the appropriate upload box below. Do not forget to handle user inputs that are invalid (i.e. 120 passengers) as indicated in the description above. Be sure your batch Sub can handle extra batches of data (same format as existing batches) added to the bottom of the batch input tab. Be sure your batch Sub can handle extra spaces (1 or more empty rows) between batches of data. Please comment your code so that it is easy for a grader to follow. Code without comments may be penalized. Partial credit is also much easier to grant if code is commented.
Bidders
paulk 5 years ago
Rated 9.77 earned 9672.34 around 332 assignments.
Hello friend
$60.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}
 
 
Respectwriter 5 years ago
Rated 9.03 earned 26253.25 around 814 assignments.
Hello, I am well conversant with this subject and at a position of delivering the best results on time. Kindly consider my bid and I will not disappoint. I am online ready to work.
$60.00
  • if you have Any questions please do not hesitate to ask
    User_27354 | Feb 20, 2021, 04:01 AM
  • I have uploaded your work and you may now release the payment.Thank you
    Respectwriter | Feb 21, 2021, 18:46 PM
  • Thank you
    Respectwriter | Feb 22, 2021, 01:36 AM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}
 
 
Masilela00 5 years ago
Rated 9.24 earned 19206.67 around 479 assignments.
Hello friend , I am available to start working on your assignment right away. I will deliver an excellent paper as per your instructions. Kindly consider my bid and hire me to help you, thanks in advance. Regards
$360.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}
 
 
drjim 5 years ago
Rated 9.55 earned 24203.41 around 648 assignments.
Hey. Are you the one who cancelled the project last time? Can I complete this one and you release the funds on the one you cancelled?
$150.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}
 
 
ExpertResearcher_d_649 5 years ago
Rated 1.0 earned 126.20 around 2 assignments.
helooo
$200.00
  • im willing and ready to help ,, kindly what's app me +254729828092 for help
    ExpertResearcher_d_649 | Feb 19, 2021, 16:50 PM
  • im willing and ready to help ,, kindly what's app me +254729828092 for help
    ExpertResearcher_d_649 | Feb 19, 2021, 16:50 PM
  • im willing and ready to help ,, kindly what's app me +254729828092 for help
    ExpertResearcher_d_649 | Feb 19, 2021, 16:50 PM
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}
 
 
kingz 5 years ago
Rated 9.4 earned 52183.12 around 1434 assignments.
Hello kindly assign this to me i can guarantee timely and an A grade work
$200.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}
 
 
firstclass 5 years ago
Rated 9.69 earned 32174.51 around 733 assignments.
Hello there, having been writing for the last 6 years, you can be sure enough that I will deliver on your project. Have read and understood all the instructions and I can guarantee you quality work with zero plagiarism and ultimate A + grade... Regards first class
$60.00
  • {$ item.message_content $}
    {$ item.sender_username $} | {$ item.date_entered $}