Visual Basic Program (Math Calculator) Needs Modification
$30-500 USD
Kiszállításkor fizetve
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**
Projektazonosító: #3401101