An algorithm in Excel or a software to program
Raymond PENTIER Posted messages 58546 Registration date Status Contributeur Last intervention -
Hello
For a project, I need to make some tasks easier, and I'm not sure whether I should program it using formulas in Excel or if I need a dedicated software. I work in event planning. I have data on past events, the venue's area, the number of people, the event date, the price of each service provider, so I'm recording all this information from previous events. My goal is that for future events, I just need to input, for example, the area, and it will give me an estimate based on the information I've recorded.
Do you have any idea of software that can do this, or do I need to program it myself (considering that I'm not an expert)?
3 réponses
Hello.
"example given the area and it gives me roughly the estimate"
For that, a rule of three in Excel will suffice ...
It's nice, retirement! Especially in the Antilles ...
Raymond (INSA, AFPA)
To develop, I would still need access to your file in which the data is recorded...
1) Go to https://www.cjoint.com/
2) Click on [Browse] to select the file (max 15 MB)
3) Scroll down to click on the blue button [Create Cjoint link]
4) After a few seconds, the second page will appear, with the link in bold; right-click on it and choose "Copy link"
5) Go back to the discussion on CCM, and in your message, click "Paste".
=>See the page https://www.commentcamarche.net/faq/29493-utiliser-cjoint-pour-heberger-des-fichiers
There is also https://www.transfernow.net/
Retirement is great! Especially in the Antilles...
Raymond (INSA, AFPA)