Build an Excel interface using Pivot table

  • Stav: Closed
  • Odměna: €100
  • Přijatých návrhů: 33
  • Vítěz: mhgroup21

Instrukce k soutěži

We need an excel interface for us to visualize the data coming from the cash-flow software of our company.
We will provide a list of data to the table (find it attached to this project) with these characteristics:
-Data of the payment;
-Amount of the payment or of the income (income with +, payment with - );
-Type of classification of the payment (see below).

What we need to read from the pivot table is:
-Type of classification of the payment:
-Da pagare alla scadenza (to pay at the given data)
-Previsionale (prevision of income or previsional payment)
-Nuovo – da impostare (new, still to be set)
-Pagato (already payed)
-Pagamento sospeso (payment in stand-by)
-Annullato – da non pagare (cancel payment, not to pay)
-We need to select what data to view, we want to change the graph according to which one of the above are not selected (for example we want to know what would be the cash-flow without taking into consideration the payments in stand-by and the ones not to pay).

-We need to se a graph during the year to visualize when we will have less money “in the bank account” and to see when we will get the money.
-We need to visualize every week the result.
the data given by our software are divided by job, so the pivot table need to sum all the different data for the same day.

We will attach to this project:
-An example of a weekly cash-flow where the data are insert manually;
-An example of the data that will be provide by our software, that we will manually put into the pivot table you will make us to extract the data;
-This link: https://www.youtube.com/watch?v=2btS31AU3Iw&t=12s where you can see in the first moment the kind of interface we want;
-The logo of our company.

Doporučené dovednosti

Winner
Doporučená soutěž
Zadejte podobnou soutěž

Zpětná vazba od zaměstnavatele

“@mhgroup21 won the contest on 26 October 2021”

Profilový obrázek Marketing2212, Italy.

Nejlepší návrhy této soutěže

Zobrazit více příspěvků

Veřejná nástěnka k vyjasnění projektu

  • RazaMohannad
    RazaMohannad
    • Před 2 let

    Hi,
    Hope you are doing well.
    I have just checked this contest, attached files and entries. I understand your requirements for an interactive pivot table dashboards. I will be able to make one which will exhibit an overall view of the yearly cash flow with options to view status on a weekly basis. I am a bit unclear due to the Italian language in both the excel sheets. As, a few descriptions do not match with each other from both the files. However, I will be able to design an interactive dashboard as per your liking.
    I have just been acquainted with this contest and would like to request you to kindly extend it for a day, if your requirements are not matched with any other entries.
    #extended

    • Před 2 let
  • Monirulislam764
    Monirulislam764
    • Před 2 let

    please tell me. About more Detail's for your pivot table

    • Před 2 let

Jak začít se soutěžemi

  • Zadejte vaši soutěž

    Zveřejněte svou soutěž Rychlé a snadné

  • Získejte kupu návrhů

    Získejte spousty návrhů Z celého světa

  • Zvolte nejlepší návrh

    Zvolte nejlepší návrh Stáhněte si soubory - Je to snadné!

Zadejte soutěž nyní nebo se k nám připjte ještě dnes!