Myönnetty

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, types search algorithms, types algorithms, types algorithm data structure, types algorithm, type algorithms, time track application, text search algorithms, text search algorithm, text algorithms, static algorithm, samples algorithms, name search algorithms, list search algorithms, different types algorithms, different types algorithm, different types data structure, different type algorithms, customer database php mysql, create logo using letters, create logo two letters, create logo based text, create application logo

About the Employer:
( 0 reviews ) Romania

Projektin tunnus: #4300232

14 freelanceria on tarjonnut keskimäärin 260 $ tähän työhön

neoconcepts

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

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

Hello, Ready to start now. Thanks

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

LETS GET IT DONE!!!

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

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)
5.5
gracebasilior

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

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

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)
5.2
hrarcon

Ready to work

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

Lets Start Discussing it

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

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

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

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

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

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)
0.0
kashyff123

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

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

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)
0.0
dearleafsolution

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

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