Visual Basic Program (Math Calculator) Needs Modification

Completato Pubblicato Jun 23, 2011 Pagato alla consegna
Completato Pagato alla consegna

Source code is included! See attachments

Modifiactions needed

1. I need the program to make up to 14 new reports per batch and it needs to be done in Excel. It needs to make all 14 reports at a time, not one at a time. It's ok if the program takes a while to run, but it shouldn't crash.

2. The program does NOT need to display the combination files that pop up inside the Batch Math Calculator . This should make it run faster and smoother. All I need is the results in one excel file.

3. I have attached 4 excel batch files that were used to generate the reports as I need them to be done.

4. Let's say there are 181 results inside each of the 4 batch excel files. Let's call it 180 results since the first line contains header info and is not an actual result.

5. I need the program to run the batch just like before but I need a new batch report for each multiple of 10 from 180 results per file down to 50 results per file.

## Deliverables

Visual Basic Program (Math Calculator) Needs Modification

Source code is included! See attachments

Here's how to run the existing Visual Basic "Math Batch Calculator" program.

1. Open bach math calculator

2. Go to "File" then "Import"

3. Find the path and select ALL 4 excel files called qpoll.

4. Go To "File" then "Combinations"

5. Wait until all 15 files are created and then go to "File" then "Results".

This is the current report that is in .jpg format

Modifiactions needed

1. I need the program to make up to 14 new reports per batch and it needs to be done in Excel. It needs to make all 14 reports at a time, not one at a time. It's ok if the program takes a while to run, but it shouldn't crash.

2. The program does NOT need to display the combination files that pop up inside the Batch Math Calculator . This should make it run faster and smoother. All I need is the results in one excel file.

3. I have attached 4 excel batch files that were used to generate the reports as I need them to be done.

4. Let's say there are 181 results inside each of the 4 batch excel files. Let's call it 180 results since the first line contains header info and is not an actual result.

5. I need the program to run the batch just like before but I need a new batch report for each multiple of 10 from 180 results per file down to 50 results per file.

180 results

170 results

160 etc etc

150

140

130

120

110

100

90

80

70

60

50

If there are only 100 results in each of the 4 excel files, then the program will still work, but will only generate 6 reports.

100

90

80

70

60

50

The program will always start at the highest multiple of 10 and work its way down the last report at 50 results per file.

There will be a maximum of 14 generated reports displayed in Excel. I need all 14 reports to go into one excel file like in the example.

The attached report that I did manually will show exactly how to create it.

6. There are only 8 numbers to worry about inside the newly created excel report. 1 2 3 4 5 6 7 8

There is a relationship between the 8 numbers. They are paired for coloring.

14 Blue

72 Green

38 Yellow

65 Orange

The report is exactly the same as before, but it is just displayed differently.

There are 8 rows and 8 columns. Only numbers that have data will show up in the report (largest results to lowest / left to right) so there will usually be a lot less numbers in each report than the full 8x8 or 64 number results.

All results now need to be rounded down to one decimal so no more 1.833333 would now become 1.8

There are two numbers in each grid. The first number should be BOLD (font size 10) and is the 1-8 numbers. the 2nd number should be non bold (font size 8) 3 spaces to the right and corresponds to the number of times the left number shows up.

Just compare the existing jpg report and the new excel report I made and it should make sense.

***It may have to be opened in Excel 2007 or later to show the different text sizes**

Installazione Script Script di Shell Windows Desktop

Rif. progetto: #3401101

Info sul progetto

5 proposte Progetto a distanza Attivo Jun 24, 2011

Assegnato a:

twinbridges

See private message.

$255 USD in 5 giorni
(27 valutazioni)
4.7

5 freelance hanno fatto un'offerta media di $319 per questo lavoro

muzammaljanjua86

See private message.

$255 USD in 5 giorni
(36 valutazioni)
4.1
TheProgMaster

See private message.

$425 USD in 5 giorni
(2 valutazioni)
2.0
bhalodiasamir

See private message.

$297.5 USD in 5 giorni
(1 Recensione)
1.3
rupooninfosoft

See private message.

$361.25 USD in 5 giorni
(0 valutazioni)
0.0