I will have an Excel sheet prepared with formulas

Preferable skills:

excel

Expected budget:

Proposed by freelancer

Published: Status: closed

Job description

I will order a sheet in Excel with formulas, which will provide us with the information we need based on the entered data.

The data is entered into the spreadsheet by our employees: travel time to the customer, working time, return time, order number, respectively for the following days of the month.

We need to get the following data from it:

- travel costs (based on the number of kilometers traveled and a constant value)

- labor cost for a given order (based on time and a proportional share in the cost of the day's work)

The sheet must easily provide us with data from the entire month, all costs assigned to a given order number, and for one order number, costs may be included in different cells (travel cost, labor cost) and on different days of the month.

The sheet must work properly under OpenOffice.

Place or location:

The job in figures:

The result of the work is to be a universal spreadsheet, which we will copy as the next months of the year. The sheet must work properly under the OpenOffice package.

Submitted offers (12)
fmarta 1 deal
  • ad publishing
  • allegro
  • data analysis
  • ... (+6)
added on 2021-05-18
SergD 1 deal
  • data analysis
  • databases
  • excel
  • ... (+2)
added on 2021-05-17
Polinna
  • databases
  • django
  • git
  • ... (+5)
added on 2021-05-17
Tobiasz__ 2 deals
  • advertisement photography
  • advertising photography
  • blog
  • ... (+13)
added on 2021-05-17
Weronika Jezewska
  • data analysis
  • databases
  • dodawanie produktów
  • ... (+3)
added on 2021-05-17
CAT24
  • adobe photoshop
  • advertisement
  • advertising texts
  • ... (+23)
added on 2021-05-17
rolfdbc
  • article
  • background music
  • buzzmarketing
  • ... (+9)
added on 2021-05-17
Krystynka
Unfilled profile
added on 2021-05-17
Karolina Klemba 1 deal
  • blog
  • buzzmarketing
  • copywriting
  • ... (+5)
added on 2021-05-17
irdos22
  • data analysis
  • dodawanie produktów
  • typing
  • ... (+1)
added on 2021-05-17
BartoszL
  • article
  • blog
  • copywriting
  • ... (+10)
added on 2021-05-16
Michał Adamus
  • 3D modeling
  • arduino
  • camera operator
  • ... (+5)
added on 2021-05-16