Write a Script to Import Excel Sheet and Generate Report

$30-250 USD

Completed

Posted

over 7 years ago

$30-250 USD

Paid on delivery

Need a script written to generate weekly report for deliveries. Currently we get a CSV file with all deliveries for the week. Deliveries are grouped into "routes" (Example Monday1, Monday2, Monday3 etc) We need to group all deliveries for each route into a printable report where the delivery truck driver can see details of each delivery they need to do. (example Monday1 deliveryies report) Each delivery needs to be checked if it has a fruitbox or not. This is another csv where we need to check Weekly run data is attached as a CSV Fruitbox file is also attached Printable report is attached as a word doc (data fields which needs to be captured from the csv are marked as well) I need a solution to generate printable reports with this excel data. If you have any questions please ask

MySQL

PHP

Project ID: 11995273

About the project

10 proposals

Remote project

Active 8 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:

@ineedWorkJob

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert desktop/web software/macro/bot/script developer, so your 100% satisfaction is assured by my software/macro/bot/script/service... b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” I hope it is much more clear; why you should pick me up... **and also please sir, download the file from following link, there you can find some of my developed applications screen shot** Download Link: [login to view URL] Thanks a lot again.. Please sir, leave a reply ASAP, as I am waiting for your kind reply best regards from [login to view URL]

$150 USD in 2 days

5.0

(114 reviews)

6.4

10 freelancers are bidding on average $120 USD for this job

@arkadebnath

The best way is to import the csv data into database and generate database driven report. I can do the whole thing including charts in the report. Please message me so that I can start working.

$55 USD in 3 days

5.0

(18 reviews)

4.6

@manishbhatias

Hi, I would like to work on this project. I checked the weekly run file however it seems that the fruitbox and printable report format files were not attached to the project. Could you kindly provide those so that I can check the structure of the report. Thanks Manish

$100 USD in 1 day

5.0

(59 reviews)

4.7

@nagarajdvdg2009

Hi, I have understood the requirement high level. I am from bangaore. I can write a desktop application which can read the csv and generate report. Hope we can have more conversation. Regards, Nagaraja Devadiga

$100 USD in 5 days

5.0

(6 reviews)

2.9

@Tarun22sh

I have 10+ experience in IT. I can automate this report generation task for you. Need below information:- I could not find the word file attached. Please share the final format required. Do you want it to code using PHP or open for other tools like excel, java, VB, shell scripting, powershell etc. Please give me some more details about OS on which it is hosted currently and need to host after automation. Do you want to mail the generated report? Auto Schedule it or prefer manual trigger. Thanks and Regards, Tarun Sharma

$155 USD in 3 days