In Progress

VBA Programming

i need help on simple VBA i just dont have the time to do it

Part 1 Algorithm design

a. Design an algorithm that will calculate the volume of a sphere. Select appropriate units

for the radius.

b. Design an algorithm that will convert a EIGHT digit BINARY number to decimal.

c. Design an algorithm that will randomly generate six different numbers. (Numbers should

be range from 1-49). You will need to check the numbers to see if they don’t repeat

themselves in the sequence. You will only discover this when you write the program. If

this is true you must then re-define your algorithm). Use the randomizing function in

VBA.

d. Design an algorithm that will count the number of vowels in a sentence. The sentence should be constructed from a maximum of no more than 10 words, ending with a full stop.

Part 2 Program structure and design.

a. Convert the algorithms in Part 1, to VBA computer programs . ALL outputs should be

shown in the correct units. Make the programs ‘user friendly’.

b. Ensure the program structure and design makes the program readable and makes the

process of debugging much easier.

c. Where possible use suitable comments to help in the understanding of the program

function.

Part 3 Program test and debug.

a. Use suitable test data to check the functionality of algorithms in Part 1 and the programs

in Part 2.

b. Comment on whether the programs work correctly and how you would change them if

any shortcomings have been identified.

Part 4 Overall content and structure

a. Completeness of report, including page numbers, contents page, correct use of headings

etc. All work referenced and conclusions provided where required. ALL sections

attempted.

Skills: Visual Basic

See more: visual programming c++, visual basic in programming, visual basic algorithm, vba work, vba with, use of data structure in programming, use of binary, use of algorithms in programming, use of algorithms, use of algorithm in programming, understanding programming, understanding computer programming, understanding algorithms, test algorithms, test algorithm, simple words computer programming, simple computer programming, simple binary, simple algorithms in c, see programming, report programming, programs 4 computer, programming words, programming with data, programming with algorithms

About the Employer:
( 0 reviews ) birmingham, United Kingdom

Project ID: #249680

Awarded to:

tpb261

This is more like an assignment than a project. The programs can be done in a matter of hours - with comments. The report might take 2-3 hrs more. So the whole thing can be done in less than half-a-day.

$30 USD in 0 days
(0 Reviews)
0.0

12 freelancers are bidding on average $142 for this job

FreedomOwl

Hi, I know how to do this task - let's begin

$200 USD in 5 days
(0 Reviews)
0.0
vtomljan

Hi, I can do this for you! Please contact me via PM if you are interested! Best regards, Vedran

$120 USD in 2 days
(0 Reviews)
0.0
segeyplus

Hello. The task is quite simple. I could do it easily. Sergey S.

$100 USD in 1 day
(0 Reviews)
0.0
trivial123

This looks quite easy.

$50 USD in 3 days
(0 Reviews)
0.0
maxidev

this can be done for you. regards (maxdev)

$195 USD in 7 days
(0 Reviews)
0.0
sm0701

Renu Tec, works towards achieving customer satisfaction. Our ability to deliver what we promise takes us closer to that milestone. Our project management experience helps us achieve a thorough understanding of the proj More

$250 USD in 15 days
(0 Reviews)
0.0
programmerofweb

I have many VBA develop experiences, I think I can go a great job for you,I can get it done with rapidly response and lower bid.

$110 USD in 5 days
(0 Reviews)
0.0
jinendraspatil

Dear Sir, I have already worked on similar projects. Also I have developed logic to generate numbers randomly. With simple Random function every time you run program, sequence of random number is repeated. Thanks and More

$100 USD in 10 days
(0 Reviews)
0.0
pujie

choose me, I 'll do this job

$50 USD in 3 days
(0 Reviews)
0.0
dolinujung

dear sir, i can give and made to you for your solution for this one.

$250 USD in 15 days
(0 Reviews)
0.0
darkholds

Hi, i am an IT educator..an experienced VBA developer..i could surely help you about this matter..

$250 USD in 15 days
(0 Reviews)
0.0