Completed

Write a Script to Import Excel Sheet and Generate Report

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

Skills: MySQL, PHP

See more: auto generate word doc excel sheet, excel script import csv, software write mq4, excel script import txt file, excel script import text file, software write chip epson, vba excel script import data web, excel script import data, useful software write book, software write web specs, converting word doc excel, free software write user guide, convert word doc excel spread sheet, software write edid, free software write company profile, software write websites idea, process text word doc excel vba, copy word doc excel spreadsheet, software write book images, software write books

About the Employer:
( 6 reviews ) Colombo, Sri Lanka

Project ID: #11995273

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/b More

$150 USD in 2 days
(114 Reviews)
6.4

10 freelancers are bidding on average $120 for this job

casper123

Hi, I've checked the attached csv. Please provide sample of output report so I can give you my exact time and cost for this project. Regards, casper [login to view URL]

$111 USD in 3 days
(54 Reviews)
6.2
programac

Hello Sir/Madam! Greetings!!! Thanks for sharing the project. I am experience with PHPExcel. I am very much interested in your project concept and of course want to get involved in this project. I got more than 7 ye More

$153 USD in 3 days
(129 Reviews)
6.2
Brijrajs76

Hello, I am very interested in the project and I would like to apply to it. I'm a web developer with 7 years experience in PHP, MySQL, CSS3, HTML5 and deep knowledge WordPress, WP plugins, development issues and More

$155 USD in 3 days
(81 Reviews)
6.0
suniljoshi151

Hi, I can start work on your project immediately once you confirm me and i am also open for further discussion if you want. I have 7+ years in web designing & development with good experience in following sk More

$180 USD in 3 days
(54 Reviews)
5.9
vishal80

-I am already Having company since 2013 now I start work on freelancer as a Company. As we are new in freelancer, But with our expertise we can innovate your work greatly... Hello, Having great oppotunity for u More

$45 USD in 3 days
(40 Reviews)
5.2
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
(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 tha More

$100 USD in 1 day
(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
(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 u More

$155 USD in 3 days
(0 Reviews)
0.0