Making a schedule template in excel

Closed job

Recent jobs from category Admin support

  • no avatar
    Maciej1018 4 deals
    Dzień dobry, poszukuje osoby/wykładowcy z doświadczeniem pedagogicznym, chętnej do przygotowania prezentacji przygotowujących uczniów do matury z matematyki, biologii, języka angielskiego i polskiego. Kolejnym krokiem będzie wyjaśnienie treści prezentacji w formie zrzutu ekranu. Finalnie prezentacje zostaną umieszczona jako kurs na naszej platformie E-Learning. Zapraszamy do kontaktu wyłącznie nauczycieli!
no avatar
Paweł
Employer
1 deal
Job category:
Data entry
Expected budget:

Negotiable

Published:
Finished

Job description

Please make a file based on the attached template, which will have the adopted percentages in columns "K" - "AI" relating to the values in column "J". The percentages should be more or less proportionally adopted as in the attached file.

Using the "schedule" file as an example

In field "J12" we have the sum of fields "J13" and "J14".

Ultimately, when entering a value in field "J12", I want proportional values to appear seeding fields "J13" and "J14".

Similarly, for example, in the "J13" field, I want the proportional values to appear in the columns on the right.

In the costing file, I would like each cell to be a percentage of the total.

The purpose of these operations is that I will need to prepare several variants for each of these documents based on different output values.

The job in figures:

Rebuilding 2 excel files

Place or location:

remote