Færdiggjort

Spreadsheet Calculator

There are 2 CSV files. These represent Quinella and Exacta dividends, imported and saved by a 3rd party program JMP. I need both files to be imported into Excel 97, and some simple calculations done with both files. Either a Macro or VB programming can be used. The result should be output in an Excel file as well.

## Deliverables

There are 2 CSV files. One is a Q sheet ([url removed, login to view]), the other the E sheet ([url removed, login to view]) These represent Quinella and Exacta dividends, imported and saved by a 3rd party program JMP. I need both files to be imported into Excel 97, and some simple calculations done with both files. Either a Macro or VB programming can be used. The result should be output in an Excel file as well. Both files have variables of combinations and dividends. However, the E sheet has nearly double the combinations. Q sheet may have a combination of 1+2, the equivalent in the E sheet is combo 1+2 and 2+1. So a Q sheet combination 3+4 is equal to E sheet 3+4 and 4+3. And so on. Specifics: 1--Read in [url removed, login to view] 2--Read in [url removed, login to view] 3--apply a formula: (q/e1) +(q/e2) The q value in the formula is the dividend on the Q sheet at the first combination ie 1+2. So it would be 1+2 = 14.40 on supplied Q sheet The e1 and e2 values in above formula are as follows. If the first combo on Q sheet is 1+2, take 1+2 PLUS 2+1 (opposite combo) on the E sheet and use both these values. One value is e1 in the formula and one value is e2. take that combination and the opposite combination on the E sheet and use those values. So Q sheet combo 1+2 dividend is q in formula. E sheet combo 1+2 is e1 in above formula, 2+1 is e2 in above formula. So e1 for above above formula is 57.90 (1+2 on E sheet) and e2 for formula is 51.40 (2+1 on E sheet) taken from supplied E sheet. Applying the formula example above: Combo 1+2 ([url removed, login to view])+([url removed, login to view]) If this formula output is equal or bigger than 1, create a new coloumn and variable on the Q sheet and put down the word "quinella" at that combination. If the formula output is less than 1, put the word "exacta" next to this commbination on the Q sheet. The above formula outputs 0.5288 at combo 1+2, this is less than 1 so "exacta" is put on the Q sheet at combination 1+2. next combination on Q sheet is 1+3 : ([url removed, login to view])+(27.9/66.20) =.7828 which is less than 1 so "exacta" is put on Q sheet at combination 1+3. Next Step Every combination on the Q sheet that has "quinella" next to it for example combo 2+10 which is ([url removed, login to view])+([url removed, login to view])=1.222 which is bigger than 1..... That combination (and the opposite combo) is DELETED in E sheet -- so above example of combo 2+10 which has "quinella" on Q sheet, read in E sheet and DELETE combo 2+10 AND combo 10+2 on E sheet. Saying it differently, for every combo on the Q sheet which has "quinella" next to it, delete BOTH combinations on E sheet. Last bit On the Q sheet add up ALL dividends with the word "quinella" next to it in this manner: 1/dividend + 1/ dividend....so on. This will create a total less than 1. On the E sheet, add up all the dividends that have the word "exacta" next to it in this manner: 1/dividend + 1/dividend etc. This is less than 1 too. Now sum these 2 results for the final number which is saved to E sheet as "Total Overround" Done. Note: the files supplied are exactly as I need them read in. In other words, the columns with spaces on the Q sheet need to be parsed like this. The blank columns come from a 3rd party program. Please make the program parse in the columns as they are. Also please make the program able to deal with several hundred combinations. ------------------------------------------------------

Evner: Script Installering, Shell Script, Software Arkitektur, Visual Basic, Visual Basic for Apps

Se mere: spreadsheet overround calculator, macro programming in excel, excel macro to word, calculator programming, q-bit, excel spreadsheet formula, excel sheet formula, csv spreadsheet, create macro in word, macro e, excel calculator, create spreadsheet, visual basic simple calculator, excel macro combination, excel formula spreadsheet spreadsheet, combinations macro, macro script file, spreadsheet csv, excel macro add, combination program visual basic

Om arbejdsgiveren:
( 6 bedømmelser ) Australia

Projekt ID: #3321289

Tildelt til:

quickprogexpert

See private message.

$63.75 USD in 14 dage
(141 bedømmelser)
6.2

3 freelancere byder i gennemsnit $75 på dette job

mobiletech1604

See private message.

$76.5 USD in 14 dage
(47 bedømmelser)
6.0
bolbols

See private message.

$84.15 USD in 14 dage
(44 bedømmelser)
5.5