Build me a single output file type from both online portals and excel files

Closed Posted 3 years ago Paid on delivery
Closed Paid on delivery

We have multiple suppliers who provide price files at different frequencies, some are sent in via email and some have to be downloaded from a supplier portal.

We need to have a standardized output file to load into Salesforce, if possible we would like to be able to have test functionality to ensure that the outputs produce an expected outcome.

The naming conventions are different by supplier (mostly) and the format of the files can vary from one supplier to another. The template provided by the supplier (price files) typically remains consistent, but we need to be able to add or remove elements as part of the solution (when pricing becomes obsolete) or new products become available

Typically pricing depends on the contract start date, the location of the meter, the energy type, the type of meter etc. Attached is sample price files (we have approx 12-14 suppliers and price lists may be for Gas or Electric

We had someone create something but then did not have the opportunity to complete the task, see attached "Gas Template"

Excel Salesforce.com Data Entry Data Processing Excel VBA

Project ID: #27496370

About the project

15 proposals Remote project Active 3 years ago

15 freelancers are bidding on average £208 for this job

schoudhary1553

Hi, Greetings! ✅checked your project details: Build me a single output file type from both online portals and excel files ✅Completed Time: In project deadline We have worked on 650 + Projects. I have 6 + years of More

£250 GBP in 4 days
(400 Reviews)
8.2
zu02

Hi there I'm ms Access/Excel/vba guru from Georgia- full time freelancer. I think better way will be to maintain this process via ms Access app/if you need with Excel automation. I'll detail more in private chat . Bes More

£500 GBP in 8 days
(20 Reviews)
5.4
PKonstiantyn

@@@@ Hello! @@@@ My name is konstiatyn who is professional in Visual Basic, Data Processing, Data Entry and Excel. I am very interested in your project”Build me a single output file type from both online portals and e More

£150 GBP in 3 days
(1 Review)
2.3
websolutioner

hi sir/madam i have lot of experience like these project and i have done so many projects like this i can deliver within time and adjust whatever you asked please feel free to contact me for more details thank you

£30 GBP in 1 day
(1 Review)
2.2
srikysriks

Hi, I can complete the task. However, I would like to know more details. It would be great if you walk me through the excel files

£150 GBP in 4 days
(0 Reviews)
0.0
Lalit9706

I have read all carefully. You can contact me. I can do it in two days. I have not done similiar work before . But trust me I can do it in two days

£167 GBP in 2 days
(0 Reviews)
0.0
virendrastarone

i can built that High Quality + Fast Speed = Excellent Result + Business Success, this is my work- ing style. I have gone through your Job post and I can understand your job requirement thoroughly. I have a total of 1 More

£90 GBP in 7 days
(0 Reviews)
0.0
Michael5541

Hello, My name is Michael i would like to let you know that i'm a very hardworking and dedicated person, i only take payment when my client's smile on my output i will do my work with full honesty. i am a new freelance More

£135 GBP in 7 days
(0 Reviews)
0.0
uttam11thakur

I am interested in this project. I have more than 5 years of working experience as MIS & Accountant. If there any opportunity for me please let me know. My Skills:- ✓Good Communication Skills ✓MS Office specially form More

£167 GBP in 5 days
(0 Reviews)
0.0
iceman0k

Hi, I have substantial experience in excel leveraging VBA to automate daily mundane tasks. I have created complex customer management systems, user forms for efficient data entry to name a few. Let's connect and discu More

£60 GBP in 4 days
(0 Reviews)
0.0
nikileshattavar

Hello, I am an freelance VBA Developer from India with total experience of 9+ years. I can deliver your requirement with precision on committed date, provided with content and material for build. I am a perfectionist a More

£250 GBP in 5 days
(0 Reviews)
0.0