VBA Assignment 3

This project received 1 bids from talented freelancers with an average bid price of $50 AUD.

Get free quotes for a project like this
Employer working
Project Budget
Total Bids
Project Description

I have an assignment I would like to be done to check with my answers. It requires Visual Basic knowledge and is to be done in Visual Basic through excel.

I will send the entire details of the assignment to those who apply through PM. Please PM if you are an expert in Visual Basic and able to do a simple programming job like this.

I require 100% correct answers which can be checked in the excel spreadsheet as you work on it.


Budget is $40 - Willing to pay $10 bonus if project is completed in less than 12 hours.

The assignment requires the following knowledge:


Implementing a simple dynamic mathematical model for a physical system in VBA;

Using drawing objects and animation (though a basic graphics library is provided);

Designing a well-presented and functional form; and

Working with a partner (if applicable)

Testing and Assessment

The provisional allocation of marks (out of 40 so every category is integral) is

6 Animation of the wheel over at least one cycle

10 Accurate display of the bar, spring and weight over multiple cycles

6 Accurate calculation and use of amplitude/phase using spring properties (Part B)

3 Validation of the amplitude and phase (both must be numbers, both non-negative and phase also not greater than 180)

5 Ability to start/stop/resume/reset the animation

4 Appearance and usability of the form, including correctly displaying the current angle

6 Style mark (as awarded by AssessStyle)

40 Total mark (rescaled to 5% of the overall assessment)

3 Bonus features or enhanced information

You are not assessed on the smoothness of the animation, as the VM used in the labs doesn't always give a full share of the processor to Excel.

Up to 3 bonus marks may be awarded if the submission provides additional functionality to the user or useful information about the system. These include (but are not limited to)

Remembering the previous parameters when the form is activated.

Displaying sinusoidal motion derived from the animation using charts or other methods

Displaying velocity and/or acceleration components.

Fancy graphics or form embellishments (don't get too carried away though, or it will detract from the motion).

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online