Excel database

€30-250 EUR

Ukończony

Opublikowano

ponad 8 lat temu

€30-250 EUR

Płatne przy odbiorze

Hi. We are planning to build an excel sheet that can be automatically update via an export from Pipedrive My may focus is to have a sheet that can generate the correct forecast reports. We are looking for a system that can perform this kind of report: When we put in the LEADS, we give it a date for the project to start up, and a period in witch it will be done. We want the system to automatically take the sum of the projected contract, and spread it out on the months that we will be working on the project. Eg. Contract sum: 100.000 Start date: 01.09.2015 Period: 01.09.2015 – 31.12.2015 Potential pay per. Month: 25.000 % possibility: 80% The graff will show the LEADS like shown in the attached excel file.

Excel

Identyfikator projektu: 8306929

Informację o projekcie

4 ofert

Zdalny projekt

Aktywny 9 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Adres e-mail

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe

Otrzymuj wynagrodzenie za swoją pracę

Przedstaw swoją propozycję

Rejestracja i składanie ofert jest bezpłatne

Przyznano:

@DenisWe

Hi, I think I can solve this task for you. I have worked more than one year in a business development position creating excel macros that modified data in worksheets and e.g. created charts from them. I can write you a macro that takes the data in a specific column (e.g. the first) spreads it out over the according number of columns and creates the chart on any worksheet. Do I understand it right that you provide the data that can be seen in columns A-H? The macro would work like that: -you paste the current data in columns A-H -you click a button to start the macro -the macro spreads out the sum according to the number of months -the macro can add specific sums or other formulas that are needed -the macro creates the chart and copies it to a new worksheet Would that fit your needs? Feel free to send me a message so we can talk about further details. Best Regards, Denis

€111 EUR w 3 dni

5,0

(1 opinia)

1,1

4 freelancerzy składają oferty o średniej wysokości €85 EUR dla tej pracy

@zExcel

A proposal has not yet been provided

€150 EUR w 3 dni

4,9

(191 opinii)

7,2

@TonmoyRoy111

Dear client, I can accomplish the job for you. I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me for further details. Thanks and regards Roy

€50 EUR w 3 dni

5,0

(23 opinii)

3,5

@TulyakovN

Hello. I'm understand how to do this job. Skills in VBA, experiance of working in excel, access two years. No problem with this job and those tasks from discription. I have birthday today, so you can so you can give me a present and accept my bid. Good luck and succeed in this project.

€30 EUR w 3 dni