Excel2Java / Low hanging fruit for java intermediates

we have a excel file with two sheets.

Your job is to implement the formulas behind the black and red rectanges in the Excel sheet. Take a look into the Excel:

To make it easier to understand take a look into the given Screenshot which shows only some parts of the Excel:

The black arrows point to black rectangles and the red arrows to the red rectangles (pretty easy, isn't it?)

Your implementation will look for example for Q4-area in the screenshot:

for black arrow:

public double debtPercentage(double q4a, double q4b) {

double result = q4a / q4b;

return result;

}

for blue arrow:

public double debtPercentage(double q4a, double q4b) {

double result = q4a / q4b;

return result;

}

public double debtRating(double deptPercentage) {

double result = -1;

if (deptPercentage <= 0.09) {

// range 0.00 to 0.09

result = 4;

} else if (deptPercentage <= 0.3) {

// range 0.09 to 0.3

result = 3;

} else if (deptPercentage <= 0.5) {

// range 0.30 to 0.50

result = 2;

} else {

// range 0.5 to unlimited

result = 1;

}

return result;

}

So you see it is a very low hanging fruit.

What we need from you:

- one class Quality, for the Excel-Sheet Sheet quality

- one class Price, for the Excel-Sheet price

- a unit test, which passes to your methods the values of the blue arrows as parameter and tests the results of the black and red arrows. As input values take the blue values from the Excel sheet

- implementation of all red and black rectangles in both sheets

Tietoa työnantajasta:
( 7 arvostelua ) Stuttgart, Germany

Projektin tunnus: #11493181

Myönnetty käyttäjälle:

krzysztofpanas

Hello I will do this job with pleasure. I'm kind of Excel passionate Also I can do one class Quality and one class Price for all Excel formulas. I'm using Eclipce for Java programming and I'm ready to strat immediatel Lisää

\$25 USD 1 päivässä
(0 Arvostelua)
0.0

3 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

ShahYasheshJ

I have an expereince of 6 yrs. I have worked on many technologies backend and frontend such as java, j2ee, oracle , MS access etc. I have worked on many such projects as well. Also, I have developed ms excel reader/wr Lisää

\$35 USD 1 päivässä
(1 arvostelu)
0.8
ahsanic

Dear Sir I have been in this industry for 5 years and such jobs are my daily practice. This is my second time on this site and hence you can see that I do not have many ratings/testimonials to show you. I can assure Lisää

\$20 USD 1 päivässä
(0 arvostelua)
0.0