PHP/MySQL application to replace Excel-based report sheets

We are currently using some Excel files to create reports for some industrial equipment we are comissioning or verifying. Over time, time number of Excel files has grown a lot and keeping track of them became difficult.

We need a PHP application that can generate PDF reports that look similar to our current Excel reports. Data should be stored in a MySQL database. The PHP application will handle some math formulas, so that the resulting data must match Excel's results. The user-entered data is mainly text and a few numeric values that all calculations will be based on. The web interface will be user-based with password protection with 2 levels of security (read and read+write). Nothing fancy is needed for the GUI.

## Deliverables

We have two types of products that are subject to these reports, each product having two variants.

Every product is identified by a serial number, made of 10 chars (letters/digits). One product can have several report types over its life time: comissioning, periodic check, or recomissioning).

You can find attached an archive containing report samples for both product types (both variants of each one).

The Image Logo should be picked up from a list of 3-4 options. Fields in parenthesis (ABC), (STATIC TEXT), (NAME), (DATE), is data entered by the user.

**Page 1**

(TITLE) varies based on report type, according to the variants above.

The first table contains numeric data entered by the user. Some parameters are measured by the user repeatedly for a few times, and the value is averaged.

**Page 2**

The rows of the table on page 2 contains measuring instruments used to obtain the values on Page 1. For newly created reports the items have to be read from a table of currently used measuring instruments (maintained in this same application, also). The items should be stored as text in every report.

**Page 3**

The reports for the two types of products are very similar, the difference being the table on page 3, which has a different structure. The table consists of user-entered text/numbers and some calculated values.

**Page 4**

Page 4 exists only for Product Type 2, and is made of calculated values and user-entered text/numbers.

The volume of calculations is not large, but for Variant 2 of each Product Type the algorithm is more complex and contains more variables and results. The formulas consist of arithmetic and trigonometric functions. All calculation algorithms and the original Excel files will be supplied to the worker. Calculated values must all be stored in the database (not recalculated every time a report is reopened).

The application must have search capabilities (based on product serial number, application name, customer name, reports older than a specified date).

Taidot: MySQL, PDF, PHP

Näytä lisää: php excel application, excel application replace, replace excel data php, we find a worker, types of search algorithms, types of data structure, types of algorithms, types of algorithm in data structure, types of algorithm, type of algorithms, title search report, time track application, the application for create logo, text search algorithms, text search algorithm, text algorithms, static algorithm, samples of algorithms, name search algorithms, match 3 algorithm, list search algorithms, list of search algorithms, different types of data structure, different types of algorithms, different types of algorithm in data structure

Tietoa työnantajasta:
( 0 arvostelua ) Romania

Projektin tunnus: #4300232

14 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


we like to build this reporting system with pdf support. let's start.

$250 USD 5 päivässä
(99 arvostelua)

Hello, Ready to start now. Thanks

$260 USD 15 päivässä
(110 arvostelua)


$250 USD 7 päivässä
(118 arvostelua)

Hi, I have lots of experience with PHP , MYSQL and can definitely take up this for you. Thanks

$230 USD 4 päivässä
(34 arvostelua)

Hi, I can do it for you! Please see PM!

$200 USD 5 päivässä
(62 arvostelua)

We are an experienced team of php developers. we will provide you complete Solution as per your need

$250 USD 4 päivässä
(25 arvostelua)

Ready to work

$500 USD 15 päivässä
(5 arvostelua)

Lets Start Discussing it

$250 USD 5 päivässä
(14 arvostelua)

Hi, Expert programmers here . Interested in your project .. Please check PM

$500 USD 15 päivässä
(3 arvostelua)

Hey, I can develop this web application for you. webNeat

$150 USD 15 päivässä
(1 arvostelu)

I have nice experience in PHP development. I have worked on creating projects for Excel & PDF. Let me know when can we start on this project.

$200 USD 20 päivässä
(0 arvostelua)

Have good experience of such reporting applications. I can do this job for you

$200 USD 7 päivässä
(0 arvostelua)

dear sir, I am more than able to do the work. I have just completed a similiar job for a cruise company in uk ( i can send you the link in private)trasforming their spreadsheet considerably making it very easy to Lisää

$200 USD 7 päivässä
(0 arvostelua)

Hi, I am expert and interested in this project. I can do it perfectly. Thanks

$195 USD 15 päivässä
(0 arvostelua)