Excel database

€30-250 EUR

Completed

Posted

over 8 years ago

€30-250 EUR

Paid on delivery

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

Project ID: 8306929

About the project

4 proposals

Remote project

Active 9 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@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 in 3 days

5.0

(1 review)

1.1

4 freelancers are bidding on average €85 EUR for this job

@zExcel

A proposal has not yet been provided

€150 EUR in 3 days

4.9

(191 reviews)

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 in 3 days

5.0

(23 reviews)

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 in 3 days