JAVA Apache Poi Excel

Job ID: 32793178

Budget: €30 – €250 EUR

We have created a small JAVA program using Apache Poi that takes some data from tables of a database and adds them to an excel file. It works fine and the data showing correctly.

Right now we have 4 columns:
A First name,
B last name,
C activity and
D total hours.

What we need after the data importation is to add a new cell in specific rows for example:
if last name (B) = something and activity (C) = admin then E cell (the new one) in the same row of course must have the formula = D*14
if activity = teaching then E cell must have the formula = D*10

So another example:
Surname: Jackson (Cell B)
Activity: Teaching (Cell C)
Total hours: 128 (Cell D)

Surname: Peters (Cell B)
Activity: Admin (Cell C)
Total hours: 13 (Cell D)

So code must check surname and activity.
For surname jackson and activity admin it should add a cell (E column) in same row and multiply 128*14
For surname peters and activit admin it should add a cell (E column) in the same row 13*12

We dont need the whole code for all the ifs. We need the basic code that does the checking and adds the cell and we will manually add all the cases because we have like 100 surnames and 40 activities.

More or less depends on last name and activity we need to multiply the hours with a different number.
The code of course needs to be in Java to be added in the already existing program. We didn't use maven, we added the references/libraries with jar files.