Phpexcel export mysql to excel examplepekerjaan

I have a set of less than 10 excel spreadsheets that I use for various purposes. I'm looking for a talented professional who can re-work these sheets eliminating redundancy. Key objectives: - The primary goal of this rework is to automate repetitive tasks. I'm looking for someone who can introduce VBA scripts and macros to help me achieve this. - The spreadsheets are both independent and share common data. It will be important to create a system that can handle both types of sheets. Ideal skills: - Proficiency in Excel, VBA, and Macro programming is a must - Experience with data manipulation and automation - Ability to understand and work with a mix of independent and shared data I'm open to discussing the project requirem...

Need after effect animation exactly same like that ribbon style with new text See animation and then placed the bid write " RIBBON " in the bid

...a proficient web data scraper to extract specific information from a prominent South African property portal and organize it in an Excel spreadsheet. Key Project Requirements: - Extracting and organizing the following data: property information (e.g., price, location) and size. - No need for continual updates, just a one-time extraction. Filtering Criteria: - The data to be scraped should be from a particular property portal and should extract information like : property type (industrial/retail/office), size, address, price. Ideal Skills: - Proficiency in web scraping techniques and tools. - Strong experience with Excel and organizing large sets of data. - Familiarity with the South African property market would be a plus. The goal of this project is ...

I'm in need of a Python Flask developer to create a web application that caters specifically to businesses. The application will need to have the following functionalities: - **User Registration and Login:** There should be a secure system in place for businesses to register and log into the application. User data should be stored efficiently in a MySQL database. - **Reporting and Analytics:** The application should provide a comprehensive set of analytics tools and reporting functionalities. These tools will help businesses to gain insights from the data collected within the application. - **Event Management:** The application will need to feature an event management system. This should cover event creation, scheduling, and perhaps...

...and 2 of the London Tube. An example of 2 schools would be expected before any contract starts, please do not provide before being contacted as I will share the list. Key Requirements: - Research: This project demands high-quality research skills. You will need to locate and verify the schools that meet our criteria. - Mapping: Proficiency in using online mapping tools is essential. - Data Management: The final report should be in Excel format. Experience handling and analyzing data in Excel is a must. - Need to confirm they have sports facilities - Data needed is Name of school - distance to tube - address - Phone number off the school site There is a list of 151 schools already on the list these will be provided and can not be used. T...

convert gramms per second to litres per m thermodynamics fluid in excel calcualtor pv=nrt

I'm looking for someone who can help me migrate a relatively simple MySQL database to Access 2019. The primary goal of this conversion is to improve data entry and management. Key tasks under this project include: - Understanding the current MySQL database structure - Converting the database to Access in a way that supports better data entry and management - Ensuring all existing relationships are maintained in the new database Ideal skills and experience for this job: - Strong understanding of both MySQL and Access, particularly Access 2019 - Experience with database migration projects The MySQL db is on my VPS Please keep in mind that, due to the simplicity of the current MySQL structure, this is a relatively straight...

I have a number of JPEG images with text which I need to be transcribed into an Excel spreadsheet. The task should take around 2 - 3 hours to complete. Key Requirements: - Convert text from JPEG images to an Excel spreadsheet - Organize the data into categories as requested - Implement numeric data validation checks for accuracy Ideal Skills: - Proficient in data entry and data management - Familiarity with Excel and its functionalities - Strong attention to detail and accuracy - Experience in implementing data validation checks Please ensure that before submitting, you are confident in your ability to deliver an error-free and well-organized Excel spreadsheet.

...freelancer to develop an Optical Mark Recognition (OMR) system that will streamline the grading process of multiple choice tests. The project will involve the following specifics: - OMR Sheet: The system should be able to accurately process and analyze data from OMR sheets. These sheets will be provided in printed format. The freelancer will need to develop a robust system that can effectively read, interpret, and grade the responses on these sheets. - Accuracy: The primary goal of the project is to accurately grade the tests. Therefore, the system needs to be highly precise and reliable in identifying and interpreting the marks made on the OMR sheets. - Efficiency: The system should significantly reduce the time and effort required for manual gradi...

I have a PDF catalogue that I need converted into an Excel spreadsheet. The PDF contains a mix of text and images which are crucial for the data. Key requirements: - Extract the data from the PDF and input into an Excel sheet. - Embed the images within the corresponding cells in the Excel file.

I require an accurate and efficient individual to input a combination of numeric and text data into a spreadsheet. This will involve less than 1000 entries. The primary task will be to input shipment data from Bills of Lading (BOLs) into an Excel file (.xlsx). The data must be organized based on specific categories found in the BOLs. Therefore, attention to detail and a keen eye for categorization is crucial. NOTE: BOL's shipped to the same location (multiple BOL's) must be added together on the same line. EXAMPLE: 1/1/2024 (5 Pallets) To Store #2595 2/1/2024 (4 Pallets) To Store #2595 NOTE: There are two types of BOL's a. Multiple Stop BOL"s. These will have 4-5 store location drops ...

I need assistance in connecting my MySQL server, installed on an AWS EC2 Ubuntu Nginx server, to MySQL Workbench 8.0. My primary goal is to have full administrative access for database management. Ideal skills and experience: - Strong expertise in MySQL and MySQL Workbench - Familiarity with AWS EC2, Ubuntu, and Nginx - Proficiency in configuring remote database connections - Experience in providing full administrative access - Knowledge in troubleshooting potential connection issues

Expert in MS excel for automation of sheets

Am nevoie de extragerea unor anumite date dintr-un fisier pdf si exportul intr-un excel. Daca urc un pdf intr-un folder trebuie extrase anumite date si importate in excel, daca apare ualt pdf, va fi extras la fel, daca modific un pdf existent date trebuie sa se modifice in excel

I'm looking for a skilled freelancer to help me customize my Excel alerts with WAV files. - I have the specific sounds in mind for each type of alert, but I need someone who can skillfully integrate these into Excel's alert system. - You should have experience in both Excel and sound file manipulation, in order to create a seamless and professional system. - Please provide examples of past work to showcase your compatibility with this project.

I am looking for an experienced Openwisp developer proficient in MySQL for a robust network management system. It should implement the following functionalities: • Network Monitoring: Must include detailed network analytics and monitoring to ensure optimal performance. • Configuration Management: Feature to manage the entire network configuration efficiently. • User Management: Efficient user interface for managing the access of multiple users. The ideal candidate should have a strong command over Python programming language and have experience in handling similar projects. This role requires solid expertise in MySQL database management. Applications from freelancers with an understanding of network infrastructure and operati...

I have an Excel file that I'd like to convert to a Google sheet. I need the Google sheet to keep all the formulas that are present in the Excel file. Key Requirements: - The Google sheet should have all the formulas intact from the original Excel file. - Include Data validation rules to ensure the data entered is accurate and meets certain criteria. - Implement Conditional formatting to visually highlight important information. - Custom scripts or functions to automate certain tasks and enhance the sheet's functionality. - Preserve font styles and retain cell borders from the original Excel file. - Maintain the column widths as in the original Excel file. Skills and Experience: - Proficiency in Exc...

I'm looking for a professional who can help ...for a professional who can help me develop a comprehensive Excel workbook for RFQ analysis and purchasing. The primary goal of this tool is to streamline our purchasing process. Key Responsibilities: - Develop an Excel spreadsheet for RFQ analysis and purchasing. - Implement basic formulas and functions to automate data analysis. - Ensure the tool is user-friendly and easy to navigate. Ideal Skills and Experience: - Proficiency in Excel and advanced knowledge of its functions. - Experience in developing purchasing and analysis tools. - Ability to streamline processes through automation. This is an exciting opportunity for someone with a keen eye for detail and a strong understanding of...

I'm looking for a diligent researcher who can compile a list of tire processors across different US states and organize the information in an Excel spreadsheet. Key Responsibilities: - Conducting online research to identify tire processors in each state. - Collating specific information (company name, contact person, phone number) for each processor. - Inputting the data into an Excel spreadsheet with consistent formatting. The ideal candidate should have: - Proficiency in web research and data entry. - Excellent attention to detail. - Strong Excel skills, with knowledge of maintaining consistent formatting. - Prior experience in conducting similar research would be an added advantage. The final list should be organized by state, with each entry c...

I need a skilled developer who can help me complete and improve my web project. Here's what I'm looking for in a nutshell: - Project is due in 9 days, April 30th. - It consi...complete and improve my web project. Here's what I'm looking for in a nutshell: - Project is due in 9 days, April 30th. - It consists of 33 HTML pages. - The HTML and CSS codes are 60% complete; I need enhancements done to them. Specifically, I'm in need of responsive design adjustments. - The project also requires JavaScript, PHP, and PHPMyAdmin coding. I'm offering $85 for this project, with a hard deadline of April 30th. Ideal Skills: - Proficiency in HTML, CSS, and JavaScript. - Experience with responsive design and ability to make improvements. - Strong grasp o...

I'm looking for an expert in data analysis to assist with a project in Excel. The data provided is well-structured and needs extensive examination to extract meaningful insights. Ideal Candidate Skills: - Proficient in Excel and its data analysis tools - Strong analytical abilities - Excellent understanding of data organization Deliverables: - Clear analysis of the structured data - Relevant insights extracted from the data - Detailed reporting on the findings This project is particularly suited to those with a keen eye for data and the ability to utilize Excel's functionalities efficiently. Thanks!

I'm in search of a proficient, experienced full stack developer for monthly salary based work. The ideal can...based work. The ideal candidate should have a strong background in the following technologies: - PHP - Laravel - React - MySQL Your primary task will involve working on mobile game projects, so previous experience in game development, especially for the mobile platform, will be a huge plus. Key responsibilities of this role include: - Collaborating with our team to implement game features and functionalities - Ensuring smooth user experience and bug-free performance - Efficient communication and timely delivery of the projects If you are a skilled full stack developer with a passion for game development and can bring your expertise to our project...

I am looking for a dedicated and detail-oriented data entry operator to assist with a large volume of data entry tasks. Key Responsibilities: - Typing, copying and pasting, data validation - Handling a large volume of entries Ideal Skills and Experience: - Proven experience in data entry - Expertise in handling large datasets - Proficiency with text documents (Word, PDF) and spreadsheets (Excel, Google Sheets) - Attention to detail and accuracy - Time management skills to handle large volumes of data

I'm looking for a database expert who can help me implement a masking technique for sensitive data in MySQL. Key Points: - Types of Sensitive Data: The solution should focus on masking Social Security Numbers, Credit Card Numbers, and Email Addresses. - Approach: I would like the data to be securely stored using a Hashing mechanism. - Database System: The project will involve working specifically with MySQL. The ideal candidate should have a deep understanding of database management, data security and Hashing techniques. Experience with data masking and MySQL is crucial. The project requires a meticulous and thorough approach to ensure that all sensitive data is properly masked and secured in the database.

I need an Excel spreadsheet that allows me to input a starting point's latitude and longitude, a heading (in degrees), and a distance (in kilometers), and then calculates the new latitude and longitude based on a rhumb line calculation. This tool will be primarily used for navigation purposes. Key Features: - Input fields for starting latitude, starting longitude, heading, and distance (all in kilometers) - Calculation of a new latitude and longitude based on the input - Utilization of the Rhumb line formula for the calculation Ideal Skills: - Advanced Excel proficiency - Understanding of geographical coordinate systems and navigation - Experience with mathematical calculations in Excel - Prior experience in developing navigation tools would be a plus Th...

I'm looking for a freelancer to help with the data entry of a combination of text and numerical data into an Excel sheet. The data will be provided in digital text files. Key Requirements: - Proficiency in Excel and data entry - Attention to detail - Ability to accurately enter both text and numerical data Experience in similar projects will be an added advantage. Please include any relevant samples or references in your bid.

I'm looking f...deep dive into the issues and provide solutions specifically in relation to: - MySQL normalization to enhance speed and efficiency - Optimization of all database queries - Enhancement of API endpoints to reduce process time - Streamlining the rendering of pages to increase speed - Prioritizing performance improvement for search functionality, data processing, and user authentication Key skills I need include: - Proficiency in MySQL - Strong experience with server optimisation - Familiarity with PHP Yii 1 Framework - Proven track record in database performance enhancement This role requires someone who can thoroughly investigate the existing issues, provide plans for improvement, and execute those plans to s...

...website to a new server, but due to an oversight, the database file wasn't transferred. I'm looking for an expert who can assist with the following: - Database Setup: The old database file wasn't downloaded during the migration. I need a MySQL database set up from scratch in the new server to replace the missing data. - API Integration: The site needs API integration for address information + more info retrieval as well as an SMS API. - Expertise Needed: Given the nature of the project, I'm looking for a professional with the following skills and experience: - Proficiency in MySQL and database creation - Experience in API integration, specifically for data retrieval - Web development expertise, preferably with experience i...

We're in search of a highly skilled and motivated Website Full Stack Developer specializing in website development to join our team for an immediate project. The ideal candidate should possess a minimum of 5+ years of experience in full stack development, demonstrating a successful track record in website creation. Responsibilities: Collaborate with our team to conceptualize and develop a listing-type website. Craft clean, efficient, and maintainable code for both front-end and back-end development. Ensure website functionality, performance, and responsiveness across various devices and platforms. Conduct thorough testing and debugging to promptly identify and resolve issues. Stay abreast of emerging technologies and best practices in web development. Requirem...

need to websrapp amazon , flipkart and get current prices of sa list of laptop models on an excel sheet

...trasladar 50 facturas en formato PDF a una hoja de Excel. Las facturas contienen información vital para mi negocio, por lo que es crucial que esta transcripción sea realizada con precisión. La información que necesito en mi hoja de Excel incluye: - Fecha - CIF - Nombre de la empresa - Importe Requerimientos: - Conocimiento y experiencia en el uso de Excel. - Habilidad para transcribir información de forma precisa y rápida. - Habilidad para trabajar con documentos en formato PDF. - Comprensión de la importancia de la confidencialidad en el tratamiento de información empresarial. Adicionalmente, necesito que la información transcrita sea organizada y categorizada por fecha. Finalmente, necesito q...

In this project, I'm seeking a skilled developer to create an intuitive, comprehensive online exam system similar to that of IELTS. Key Features and Interface Requirements: - User registration and login: Prospective test-takers should be able to register themselves and log in independently. - Payment platform integration: Users should be able to pay directly on the website before taking the examination. -Ability to import questions and exam material from excel or csv - Exam result delivery: Post-exam, users must receive their scores directly presented as a percentage score on their screens and via email. Successful applications to work on this project should include past work that directly speaks to these requirements. Exp...

...statement data and inject that data into an Excel worksheet. Key Requirements: - The program should be able to access Fidelity Brokerage website. - It should grab financial statement data and inject it into Excel. - Specifically, the program should insert this data row by row into a Microsoft Excel Worksheet. - Each stock symbol which the program should enact on will be in one column - The data rows should be organized by having one row per stock symbol. Ideal Skills: - Experience in API and data extraction. - Strong proficiency in Python, VBScript or other programming languages suitable for this task. - Prior experience in creating Excel macros or programs that interact with Excel. - Knowledge of financial statement data and the...

I'm looking for an experienced PHP developer with a strong background in WordPress with a good knowledge of AJAX and MySQL to make changes to my (Freeio)theme based website. . - **Layout Modifications**: The first aspect of this project is to alter the layout of the site. Specifics on changes I need are freelancer profile card view modifications, FAQ section in freelancer's service page, freelancer details TAG input should be multiselect option. - **Functionality Improvements**: Additionally, I'm looking to improve the functionality of the site. This include review system, freelancers on service search bar, highest rated freelancers listing with required condition, freelancer can post one service for one category, message files should ...

Hello. I have some android APP and need to make some simply changes -date and time change from ENG to PL_locale -currency changes After that will upload new tasks

Extract data from pdf documents into an excel template. No software needed for the job. This is a complex project that requires accuracy and being organised. Must have strong numeracy and proven track record of attention to detail. Knowledge of European languages an advantage. We have over 100 files that will be allocated depending on ability and capacity. If you are interested please get in touch. Work will begin in April.

I'm seeking a highly skilled Construct 3 developer to connect my game with a MySQL database. Your tasks will include: - Implement a login module with 'remember password' functionality. - Set up the game to save scores in the connected database. Skills and Experience required: - Extensive experience with Construct 3 game development. - Proficiency in MySQL and database integration. - Experience in creating robust login modules. Please note that at this time, there is no need to store any additional user data apart from login credentials and scores. However, familiarity with storing user game progress, preferences, and in-game purchases in a database is a plus as these may be added in future revisions of the project.

I'm in need of a professional to develop a Linux-based barcode printing application that supports both QR codes and 1D barcodes. The application must also be capable of importing data from Excel/CSV files. Key Components: - A Linux-based application: The application should be specifically designed to run on Linux operating system. - QR Codes and 1D Barcodes: The barcode printing application should support both QR codes and 1D barcodes. - Excel/CSV data import: The application should be able to import data from Excel/CSV files for generating barcodes. Ideal Skills: - Proficiency in Linux application development. - Experience with barcode generation and printing. - Ability to work with Excel/CSV data import. - Understanding of Q...

I am in need of a Python script that can read CSV files and push the data into SQL Server Management Studio database. Key Requirements: - The script...Python script that can read CSV files and push the data into SQL Server Management Studio database. Key Requirements: - The script should be versatile enough to handle multiple CSV files. - It should map the CSV file column names to the respective SQL Server database table columns. - I would like to have two versions - one for single CSV files and one for bulk import to optimize performance when dealing with a large volume of data. Key Skills: - Proficiency in Python to develop the script. - Familiarity with SQL Server Management Studio to manage the database. - Previous experience with CSV file h...

I'm looking for an experienced programmer who understands MATLAB inside and out. Specifically, I need someone capable of optimizing a data analysis script. This script primarily uses arrays and matrices as ...programmer who understands MATLAB inside and out. Specifically, I need someone capable of optimizing a data analysis script. This script primarily uses arrays and matrices as its predominant data structures. It's crucial that you excel in: - MATLAB programming - Optimizing code for efficiency - Deep knowledge and understanding of working with arrays and matrices data structures If you are an expert with these requirements and have the know-how to streamline and optimize for speed and stability, your skills are highly valuable in this project. I look for...

I'm seeking an expert in Excel who can efficiently merge two sets of numerical data sourced from different spreadsheets. Key tasks include: - Cleaning similar columns to create a unique identifier for perfect merging - Conducting statistical analysis on the merged data to find the mean, median, mode Ability to analyze data meticulously, professional experience in using Excel and familiarity with advanced statistical functions are essential for this project. Stringent attention to details is appreciated, as the data to be handled is delicate and the outcomes crucial. An understanding of data cleaning techniques in Excel would be an added bonus.

Saludos, busco un experto en vba excel para la solución o complementación de un proyecto. Adjunto dejo una imagen del userform que funcionará cómo buscador y modificador de una base de datos en excel, la principal necesidad es lograr que el listbox genere la data con sus respectivas columnheads cómo se muestra en imagen, y que a su vez en el apartado del buscador, se pueda filtrar por el campo requerido y se genere correctamente la nueva fuente de datos. El error que se me ha presentado es que por usar el método .rowsource para mantener los encabezados, no me permite utilizar el método .additem.

Proyecto de automatización con sharepoint, Excel, power automate y power bi

I am seeking an Excel expert capable of preparing a comprehensive document comprising more than 10000 rows and columns. The scope of the project involves processing substantial data sets, namely: Organizing Scanned documents and extracting the data, organizing the data in different corporations by department and years. Be able to extract a P/L and AR for all companies. Project is to be done in stages - Text - Numerical data - Date Information The ideal candidate for this job should have: - Expert knowledge of Excel and related functionalities. - Strong attention to detail. - Proven experience of data entry in large volumes. - Familiarity with basic mathematical operation functions within Excel. The deliverable will be a well-structured ...

I have to download everyday +- 3000 invoices (PDF files) from a server to my computer. I already have this task semi-automated in an Excel macro, but I want to do it easier. I need a tool (also in Excel/VB/Macro) where: - I'll write the day, month and year - I'll write the first invoice number and last invoice number that I want your tool to search - I'll hit a button "START" and your tool will search and download to my computer every invoices from that range that were issued on that specific day from an specific URL. The URL for these files is a standard URL. It's always an URL like this: The only part that changes is day, month, year and invoice number. Example: if I want to download any avai...

I need expert help with formatting documents across Microsoft Word, Excel, and PowerPoint. The key tasks include: - Formatting text: Ensuring consistency, readability, and visual appeal for all text elements. - Tables and charts: Skillfully organizing and presenting data in tables and charts. - Page layout and design: Creating visually engaging and professional layouts. - Resume: Crafting a creative resume with a professional touch. Ideal candidates should have: - Proficiency in Microsoft Office suite, with a focus on Word, Excel, and PowerPoint. - Proven experience in text formatting, table/chart creation, page design, and resume formatting. - A keen eye for detail, design, and visual presentation. - Ability to work efficiently and meet deadlines. - Familiarity with...

In need of an Excel whizz to immediately help in cleaning up my spreadsheet which has become cluttered and confusing. The main task will be: - Formatting cells and columns: Your experience in making spreadsheets intuitive, organized, and easy-to-read will be key. Expertise in creating visually appealing and easy-to-navigate cell and column formats is crucial. Though the specific type of cell and column formatting was not specified, the ability to quickly adapt and modify to different formatting styles would be a plus. Please note, this task is time-sensitive and requires prompt completion. If you have a proven track record of quick turnaround times on similar projects, don't hesitate to apply. Your efficiency and attention to ...

I'm looking for an expert who can customize the export function in my osTicket setup. The goal is to be able to export any field of my choice from the software, with the ability to select specific fields as needed. Key requirements: - Enable export of all fields from osTicket - Implement a feature to check and select specific fields for export - Ensure a seamless operation of the export function without errors Feel free to ask me any further questions on this project.

...The interface needs to be updated to have a classic and professional look. This is to improve overall user experience and make the system more aesthetically pleasing. - SMS Alerts: I need the system to send SMS alerts to technicians when new tickets are opened to them or to a group they are part of. This is to ensure that technicians are instantly notified of new tasks and can attend to them promptly. - Payment Type Checkboxes: The modification involves adding checkboxes for different payment types. Alongside each checkbox, I require a text box for inserting the account name. This is to facilitate easy and accurate tracking of payment details. I'm particularly interested in a developer with experience in integ...

I'm in need of a programmer skilled in pine scripts (tradingview). I am looking for someone who can create an alert in my script that is triggered when all specified ...create an alert in my script that is triggered when all specified conditions (Multiple conditions) are met. The conditions were not delineated in the planning phase. The key task for this project is that for example when the first condition met should keep a record of that value and then use that value to another condition to trigger the alert. The ideal freelancer would: - Have experience in building complex alert systems - Understand and be able to work with the existing code - Be able to complete this task within the given time frame - Have great attention to detail and ...