Build PHP/MySQL query form from Excel data-base

Budget $250 - $750 USD
Bids 41
Average Bid $429

I have data currently stored in an Excel file.

The data consists of a grid of dollar values for varous round-the-world fares according to:
Airline Alliance (4:- Star Alliance; OneWorld (x2 versions); SkyTeam)
Class of service (2:- Economy; Business Class)
Length of trip (3 or 4 'fare bands' per alliance per class)
Country of purchase/origin of travel (total of 211 jursidictions)
The consolidated data in the final worksheet thus comprises around 7000 cells (many are identical and some are nul (no service provided for certain originating countries and/or fare-bands)

What I require is to have the data converted into a searchable database that will drill down to provide the resultant value of a query for any combination of variables (Alliance/Class/Length/Country). The programme will have to be able to have the data updated easily from the source Excel worksheet by someone (myself!) who has no coding skills (and no understanding of what goes on 'under the hood'). Query responses are to be displayed in an html form on my website (not yet constructed, pending the outcome of of this post). My server is updated to PHP/MySQL version 5.

I am taking a wild guess at the complexity and time required to provide this service so please feel free to bid under and over the target budget.

If you have done anything similar to this please direct me to any projects that I could view.
If you have suggestions or ideas that could improve the functionality of this project, feel free to bring them to my attention. I will appreciate any hand-holding you can provide!

Sample Excel file and Query form suggestions attached below if you need them to figure out what I'm after. In the Excel file the data you will be working from are on sheets 2 and 3 (tabbed 'USD Y [economy class] all fares' and 'USD C [business class] all fares'. Good luck!

Cheers, Barry

Post a Project Like This

This project was awarded to

stefancutrei

Stefan has done a fantastic job, in super fast time. Gave very good feedback during development of project so I always knew what was happening, and provided regular interim versions for testing. Prepared to work late into the night to match time zones. Happy to recommend, and will hire again.
About the Freelancer
stefancutrei Profile Picture

"IMAGINATION is more important than KNOWLEDGE!"

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • m4manas Profile Picture

    m4manas

    New Delhi,  India

    Ngnix Expert (2year +): aims to turbo charge your website. Lua Expert (1year +): I have been using Lua inside ngnix to provide simple solution for complicated problem. Please checkout my comments on openresty mailing list. XenServer Expert (2year+): I can help your company in planning and executing Virtualisation Solution on Community Edition of XenServer 5.6 Sp2 or 6.1 Sp2. Do consult me for free before you order your hardware. Drupal Expert (9 years+) : Aims to help all the users working on drupal. Freeswitch & Asterisk (2 years +): If you got a complex, high performance demanding solution on VoIP then I m your man. Enterprise Mobile Development (1 year+): If you want an app to be developed for enterprise then i can be of help. Check out our app on itune. API Integration (9 years+): Integration of various API and data over internet (Authorise, First Data). I also do consulting on PCI Compliance and how to structure your resource to minimise the PCI Exposure including Mobile App and Virtualised Environment. I m single developer who takes up single assignment at one time.

    PHP, Python, Linux, and AJAX

  • naemusham Profile Picture

    naemusham

    Thrissur,  India

    PHP, C Programming, AJAX, and Joomla

  • capminds Profile Picture

    capminds

    McLean,  India

    CapMinds Technologies Corporation is an innovative & reliable software development and professional services company specialized in Business&IT Consulting, IT enabled Business Solutions and Business Process Outsourcing. Established in 2008, Washington DC Metro based CapMinds Technologies has built its credibility by successfully serving Fortune 500 clients and by paying meticulous attention to each of their customized needs. Our state-of-art global Research&Development and Delivery center is located in Tirunelveli, INDIA. Our dedicated team is available for 24/7 round the clock support. IT Application Services: # Website development, Hosting & Maintenance # Enterprise Application Architecture # Application Development, Enhancement & Maintenance # Systems Integration # Independent Validation and Testing # Information Management BPO Services: * Data Entry & Processing Services * Data Conversion & Processing Services * Scanning, OCR with Editing & IMAGING Services * Search Engine Optimization (SEO) and Search Engine Marketing (SEM) * Book Keeping and Accounting Services * Forms & Insurance Processing Services * Internet & Email Marketing * Internet / Online / Web Research * Customer Support Services * Technical Support Services * Telemarketing Services * Employee IT Help-desk Services * Sales and Fulfillment Please refer www capminds dot com for more info

    PHP, ASP, Java, and .NET

  • USAGraphicPR0 Profile Picture

    USAGraphicPR0

    Charlotte,  United States

    YOUR SEARCH ENDS HERE! - I AM HERE TO SERVE, COMMUNICATE, WORK HARD, WORK FAST AND OF COURSE I AIM TO GET IT DONE RIGHT THE FIRST TIME! I have a marketing background that dates back to 1998. I know what it takes to sell and capture attention. Warm Regards, Timothy

    PHP, Website Design, Wordpress, and CSS

  • riachdesign Profile Picture

    riachdesign

    Loughrea,  Ireland

    PHP, Python, Script Install, and Linux

  • agstech123 Profile Picture

    agstech123

    Pune,  India

    AGS Technologies has won the 57th IEDRA Award! Indian Economic Development and Research Association (IEDRA) have conferred AGS Technologies for its outstanding contributions in "Economic and Industrial Development" in India. IEDRA plays a significant role in the country's economic and social development. The award recognizes AGS Technologies' outstanding business performance, its emphasis on value engineering and development of cutting edge technology in its products and services. The award was presented in New Delhi on August 26th, 2010, at a National Seminar & Awards Function on "Outstanding Contributions To Nation Building & World Peace" organized by IEDRA. The seminar highlighted the contribution of individuals and organisations in the fields of Industry, Commerce, Health, Education, Technology, Engineering, IT, Sports, etc. The dignitaries present include Mr. Joginder Singh (Former Director CBI), Mr. Bhuwan Chandra Khanduri (Former Chief Minister, Uttarakhand), Bhishma Narain Singh (Former Governor & Union Minister), C.V.G Krishnamurthy (Former Chief Election Commissioner), Justice O.P Verma (Former Governor and Chief Justice), Major Ved Prakash (Congress General Secretary) and Ranjan Uberoi (Secretary General - IEDRA). For more details click here: http://agstechnologies.com/iedra/ About AGS Technologies: We at AGS Technologies are committed to delivering maximum value to our clients helping them succeed in a constantly changing and challenging biz world. Our fundamental company values stem from understanding that our success is tied with success of our clients. Our key business principles are: Understand Clients Needs: We carefully study each customer particular case to understand the client’s needs and objectives and deliver a dependable solution. We make you aware of all available options and provide you with a competent advice enabling you to take an informed business decision. Partner with Clients: We are committed to becoming your long-term, trusted partner. Our priority is not only providing professional services and solutions but becoming your IT vendor dedicated to meeting your needs today and support your growing business needs tomorrow. Earn Clients Trust and Confidence: Our aim is to earn customer's trust and confidence through personal attention, passion for what we do and commitment to long-lasting relationship. We will go an extra mile to deliver you a measurable business value and help you adopt and succeed in the internet. We are now successfully registered with the "Software Technology Parks of India (STPI)" -- www.stpi.in

    PHP, Javascript, XML, and Adobe Flash

  • sedra Profile Picture

    sedra

    Tananarive,  Madagascar

    PHP, Script Install, Copywriting, and System Admin

  • athenainc Profile Picture

    athenainc

    Goa,  India

    Athena Inc. was created by two diverse individuals. One a keen enthusiast of fine art and a highly talented graphic designer while the other a tech savvy software engineer. While these two had different ideas, different thoughts and different skill sets they had one thing in common which was a passion to make technology work for business. They observed that though the technology was advancing at a rapid pace, businesses rarely kept pace in using it for their benefit. Organizations either focused on creating flashy looking websites or just got friends or relatives to put together a web front. In either case these websites did not generate any returns on investment. Athena’s focus has been on providing the businesses with tools and ammunitions that allows them to use technology to generate revenues. This meant a significant diversion from the typical website company that concentrates on domain registration, web hosting and generating low cost template based websites. Our business model allows us to leverage the power of the web and associated technologies to build applications and interfaces that compliment our customers’ business. Our solutions are not based on available technologies nor on what is the de facto standard in the market. It is primarily based on your business and the business idea that you want to give wings to.

    PHP, ASP, Java, and JSP

  • lightcresent Profile Picture

    lightcresent

    Bangalore,  India

    DreamSoftIndia has helped many of the business entities around the world to re-build their empire in the digital economy. We are now globally recognized. Our focus lies in implementing Internet business solutions such as Static and Dynamic Websites using Custom and Open Source Frameworks, Domain Name Registration, Web Hosting, Email Solutions, Application hosting for E-Commerce. Among Top 20 providers on freelancer.com for last 5 years. Looking forward to delighting you with our services.

    PHP, Perl, ASP, and Javascript

  • demse Profile Picture

    demse

    Ankara,  Turkey

    PHP-MySQL websites Database Management Drupal, Wordpress, etc.

    PHP, Javascript, Windows Desktop, and Logo Design