Php script export mysql excelcông việc

I am in need of an Excel guru to assist with my project involving fewer than 5 sheets. Help is needed to organize and format data effectively. Beyond just basic formatting, the project also requires the use of advanced formulas, specifically VLOOKUP and INDEX MATCH. The ideal freelancer for this task should have: - Expert knowledge in Excel formatting and data organization - Proven experience in creating and using advanced Excel formulas like VLOOKUP or INDEX MATCH - Strong attention to detail and focus on data accuracy - The ability to complete tasks efficiently and on time. Rest assured, if this project is successful, there could be more opportunities for similar jobs in the future. Looking forward to your bids.

I'm looking for a proficient Excel expert with extensive experience in data cleaning to assist with a key task. Your primary responsibilities will include: - Identifying and removing duplicate data entries in Excel, Data cleaning - Creating Pivot tables and data aggregations - Efficient dashboard and visuals that showcases trends and patterns via graphical data representation. Please only bid if you are seasoned in creating pivot tables, using Power query and generating visually appealing data insights. Precision and attention to detail are essential skills for this project.

For this project, I need a skilled developer to create a data visualization webpage, similar to Google Earth. Ideal candidates should have a strong background in JavaScript, Python, a...shared with the selected freelancer. - Data: The website's function will be to display GPS coordinates (latitude and longitude) alongside relevant site information when hovered over. This would include Site Name, Site Description, and Site Statistics. - Source: All required data is contained in an Excel sheet which I will provide. The ideal freelancer would have experience in data visualization, and expertise in the programming languages mentioned. Additionally, a proficiency in working with Excel data is necessary. Detailed requirements and design specifics will be shared upon commen...

...in gathering text data from online resources and flawlessly entering it onto a spreadsheet. Key Responsibilities: - Sourcing text data from specified online resources - Accurately entering data onto a spreadsheet with minimal errors - Ensuring data entries are formatted correctly and uniformly within the spreadsheet Ideal Skills and Experience: - Proficiency in using spreadsheets: Microsoft Excel or an equivalent is required - Strong attention to detail: This is crucial to avoid mistakes in data entry - Experience in online research: Being able to quickly and efficiently find reliable online resources - Previous experience in data entry: A strong foundation in data entry tasks is desired. This project requires speed, accuracy, and a commitment to meeting set deadlines. If...

Hello,...processing. I came across a promising script on Codecanyon (Affiliate Management System: ) that seems like a good fit. However, I need someone to assess its compatibility with WarriorPlus. Ideally, the script should offer features tailored for both vendors and affiliates. As a vendor, I would like to: Display the SaaS applications I have listed on WarriorPlus and Recruit affiliates to promote the products and give them necessary tools and resources to promote the products. It's important to note that I want to use WarriorPlus exclusively for all payment processing. Please let me know if you're interested in this project and have the expertise to evaluate and potentially customize the script for my needs.

I am in need of a MySQL/MariaDB professional who can efficiently optimize my current database setup for larger queries. As the main area needing improvement is speed, the successful candidate will be those who can increase efficiency with minimal disruption. Key responsibilities will include, but are not limited to: * Enhancing database structure; this may include revisions in indexing or query optimization techniques. * Utilizing past experience and success stories in database speed optimization to further benefit this project. In your application, please include examples of past work where speed was dramatically improved through your interventions. This task demands significant MySQL/MariaDB experience, with a strong focus on developing and implementing strategies that o...

Hi Lin F., you have completed a scraping job for me for the last two years, I need it done again. Please have a look and apply: https://www.freelancer.com/projects/excel/Scrape-data-from-unprotected-URL

I need an expert to masterfully apply and tweak formulas and functions across entire rows and columns within my Excel spreadsheet. Your tasks will be to: - Implement formulas and functions - Apply them to entire rows and columns Ideal skills and qualifications for this job would include advanced proficiency in Excel, especially in applying lookups and mathematical functions like SUM, AVERAGE, COUNT. Proven experience with similar projects is highly preferred.

I am in need of a dynamic Excel tool to perform data analysis tasks. The tool must be designed using autofill drop down list, and it will be utilised for: - Employee name selection - The drop down list should offer an autofill option for employee names. - Tallying Totals - The drop-down list selections should be capable of tallying totals. For this project, the ideal freelancer will have strong experience with Excel, particularly with creating and managing drop down lists. Experience with data analysis in Excel will be beneficial. Your task will be to create an easy to use, and automated system that can manage complex quantitative data.

I'm in need of a skilled Python developer who can build a web scraper to extract data from a map-based website. Here's a high-level rundown of the project: - Develop a Python scraper that can pull geographic coordinates from a map-centric site. - Clean and organize this data so it can be exported in CSV format. - The script must be well-structured and well-documented for future reference or modification. Your skills and experience: - Proficient in Python, with a deep understanding of web scraping practices. - Knowledge of various data structures and understanding of handling data in CSV format. - Experience with GIS, map data, and geographic coordinates would be a significant plus. - Prior experience with large-scale data extraction projects. Detailed requirements (incl...

I'm seeking an expert in data collection to gather email addresses from a list of retail shop websites I have. Your responsibility will be to: - Visit each website link that I provide - Identify and collect the contact email address - Organize the data in a spreadsheet, with each email in a separate row Deliverables: - A sprea...have. Your responsibility will be to: - Visit each website link that I provide - Identify and collect the contact email address - Organize the data in a spreadsheet, with each email in a separate row Deliverables: - A spreadsheet in either .xlsx or .csv format with the email contact for each retail shop. Desired Skills: - Data Collection - Data Entry - Attention to detail - Proficiency in Excel or similar spreadsheet software - Familiarity wit...

Looking for a skilled developer who can automate the process of extracting text content from RTF code and organizing it in a categorized structure in an excel spreadsheet. On github, I see someone has tried to some success. The file is located: To begin with I am interested in the English file Years Foundation to Year 10. English MRAC/2023/07/LA/ENG HTML RDF/XML JSON LD SPARQL You goal is to extract the hierarchy and structure as a usable document to teachers. Learning Area (English) --> Year Level --> Aspect of the Achievement Standard (A sentence) : it may then have General Capabilities

...Machine Learning features , algorithm to my online electricity bill management system, which currently handles billing and payment processing, energy usage tracking, and customer database management. The programming language used in the project is PHP. The enhancement includes: 1. Predictive analysis for energy consumption 2. Customer segmentation 3. Load management optimization The predictive analysis for energy consumption specifically involves energy consumption forecasts. The ideal freelancer for this job has skills and experience in: • PHP • Machine Learning • Energy consumption forecast models • Customer segmentation in utility sectors • Load management optimization strategies Please provide evidence of your skills and experience in th...

I am seeking a proficient Excel expert to enhance macros within an existing spreadsheet. My primary concern involves re-scripting macros for performance enhancement. On top of this, the spreadheet needs to have its calculation functions updated in certain areas. Hence, the ideal candidate should be comfortable in tweaking and improving formulas for better functionality. I also anticipate that some redundant aspects of the macros may be stripped off as we progress to streamline performance. Required Skills: - Proven Macro scripting and implementation in Excel - Solid understanding and experience in complex formula manipulation - Ability to optimize spreadsheet for improved performance and efficiency. Note: Specific deliverables relating to the calculation changes will be share...

Configurar el entorno de delphi para trabajar con FireMonkey con base de datos MySQL en la nube

I need a data expert who can perform inferential analysis on a dataset that is less than 1000 rows and columns. This task requires absolute proficiency in Excel, including functions and formulas associated with inferential statistics. Your ability to draw meaningful insights from raw data is essential. Skills Required: - Excel proficiency - Familiarity with inferential analysis - Ability to handle small to medium-sized datasets Experience preferred: - Previous experience in Excel-based inferential data analysis - Proven track record of data interpretation and insights extraction

...recommendations from entities such as the Financial Action Task Force (FATF) typologies. Please note that these rules will be provided to the developer by our team. 4. Alert Scoring: Develop a scoring mechanism for the alerts identified by the system to present them according to their relevance. 5. Alert Management Console: Create a user-friendly console for visualizing and managing alerts efficiently. 6. Export Functionality: Ensure that cases can be exported to other tools for further management. 7. Reporting: Design 10 reports encompassing both management insights and alert analytics. It is anticipated that this software will serve up to 100 users. Each user may have up to 20,000 clients, with an average of 10 transactions per client per month. We welcome proposals from ...

For our PHP-based invoicing software, we need an experienced developer well-versed in integrating new payment methods, enhancing user interfaces, and optimizing large data set queries. We plan to execute this project in phases. At present we see 3 phases we have listed as key responsibilities below. Our first priority is the optimization of large data sets, because in our production environment with 4,000+ invoices in a MariaDB configuration, loading can take almost an hour when loading a full list. This is impacting productivity. Our office uses Clover as our payment processor. Integration with the Clover API's would be a plus. Eventually we would like for customers to be able to have their own login to be able to see their invoice and payment history. As well as make...

I'm searching for a skilled coder knowledgeable in PHP and MySQL databases to build a custom PHP class. We are currently using an old PEAR class and need a custom class written so we do not need to edit all the calls through the entire application. I have attached an example of a query call so you can see exactly how it is handled. So the class would need to support running this code. This class will need the following operations: - Connection to the MySQL database - Execution of SQL queries - Reading, writing, modifying, and deleting data - Creating and dropping tables - Fetching query results - Handling errors and exceptions Your background should include not only experience in PHP and MySQL, but a deep understanding of database operations...

...need of a professional who can assist in changing the database configuration of my Android app from PHPMyAdmin to Eclipse MySQL. This project will involve: - Understanding the current PHPMyAdmin settings in my application and migrating it to suit the MySQL Eclipse environment. - Providing me with the necessary .sql file for the Eclipse platform. Ideal Skillset: - Proficiency in Android app development and database configuration. - In-depth understanding of MySQL and Eclipse platform. - Excellent problem-solving skills and attention to detail. - Proficiency in PHPMyAdmin settings might be beneficial as you need to understand and migrate the existing setup. Note: The MySQL version in use is currently unknown, and additional details about the existing config...

...but also several modifications to the game's existing setup. Key Tasks: - Setting up the Astonia 3 game server on my Linux dedicated server. Previous experience with game server setup is an absolute must for this task. - Implementing modifications or making edits to the established game server to customize for my specific needs. Within the scope of these tasks, a sound understanding of Linux, MySQL, and familiarity with game server architecture will be required. Prior experience with Astonia 3 would be a significant asset. Please provide examples of similar projects and detail your experience with game server setups in your bid. This project requires precise, meticulous execution, and I am eager to collaborate with a professional who can deliver to these standards. spec...

I'm looking for an Ansible/DebOps expert who can help improving script used to configure our Debian servers. It uses DebOps for the Ansible Playbooks. So you need to know it very well. !!!!!!! The work has to be done remotely using anydesk or another remote control software. !!!!!!! We have the complete Ansible playbook currently. We need to apply two fixes: enforce server to reboot after one task; disable one setting in the nginx config. **Requirements:** - In-depth knowledge of Ansible for automation. - Experienced with Debian server management.

...organization. - Scheduling appointments, ensuring I never miss an important date. - Conducting data entry tasks with accuracy. - Performing internet surveys to gather valuable information for projects. - Preparing ad-hoc reports based on collected data and research. To excel in this role, you'll need to work approximately 6 hours a day, 6 days a week. This schedule is designed to ensure continuity in my operations while allowing flexibility for you. Required Skills and Experience: - Proficiency in Microsoft Office Suite, especially in Excel, Word, and PowerPoint. Your ability to harness the full potential of these tools is crucial. - Familiarity with accounting software. Although not the main focus, this skill will probably be essential for financial tasks. - Excep...

I'm in need of a skilled developer with expertise in AppSheet, Excel, and ERP systems. Your task will be multifaceted, involving various aspects such as: - Data analysis and visualization - Spreadsheet automation - Developing an AppSheet app designed for ERP, focusing on billing, data collection, and data management The main functionalities I am looking for are: - Ability to generate and track invoices - Data entry and validation capabilities - Incorporation of Google Maps API - Budgeting features - Ability to export data to Excel A strong understanding of ERP systems, proficiency in AppSheet, and advanced Excel skills are essential to this role. Experience with Google Maps API is a significant advantage. You should be able to understand the essenc...

Hi everyone, I will need a computer network analyst (ideally with cisco certification) with experience in measuring network delays, calculate jitter (with tools povided), do some graphs in excel etc. Analytical specific requirements in chat Deadline: 4/4 Budget: $20 USD

I am in need of an advanced Excel spreadsheet that will help track and output several key performance indicators (KPIs) on a monthly basis. The KPI dashboard should integrate the following parameters: - Sales pipeline - Revenue - Over $2,000,000 Per month - Overheads Average 3.75% of revenue for month - Gross profit 12 % - Projects on time >90 % - Defects closed <20 working days - Customer Satisfaction - Employee Productivity - Health and Safety The desired freelancer should have: - Proficient skills in Excel including pivot tables, charts, and formulas - Experience in creating KPI dashboards - Strong understanding of business metrics Please note that the dashboard should be mapped to be updated monthly. The focus is on clarity and ease of interpretation of the...

I have a task I need automated using an Excel macro. The specific function I need is data filtering from various sheets. - The Macro Task: The job involves creating a macro that filters data to different sheets. - Data Filtering: Notably, the filtering should be done based on specific criteria. I require a system that intelligently separates and filters information to various sheets. - Work Scope: I need the data filtered from multiple sheets, not limited to sheets 2, 3, or 4. The project might involve other sheets as well. Ideal freelancers for this job will have strong experience in Excel macros, data filtering, and automation scripts. Expertise in efficient data handling and manipulation are essential.

We have a requirement to work with Excel Power Pivot, Power Query Editor and prepare a Report. Very normal report and can be completed within couple of hours by an expert. I can pay maximum of INR1500/2000 for this first project but I will ensure, all my future work will be assigned to you. Looking for someone whom I can bank on for future. Thank you!

I’m seeking a professional developer to carry out an OCR (Optical Character Recognition) project. This is for an existing business, and will require importing text data from photographs into a PostgreSQL database. The developer will then need to integrate this functionality with our existing PHP-based website. Below will be the work flow for project Step 1: Implement a button on a PHP-based website labeled 'Import Bills'. When clicked, it triggers the import process. Step 2: Upon clicking the 'Import Bills' button, provide a browse option allowing the user to select the bill image from their disk. Step 3: Utilize an OCR (Optical Character Recognition) plugin to extract data from the selected image. This extracted data is then compared with e...

More details: What specific tasks do you need the PHP developer to handle? This question was skipped What information should successful freelancers include in their application? This question was skipped What is the purpose of the PHP development project? This question was skipped

I'm in search of a capable developer who can competently copy part of my script on Website A and move it to another website. This task should be relatively straightforward as the script is already there; it's merely a case of transferring it. Specifically, the features to be cloned from are the 'Select All' button function located in locations part. The perfect fit for this job would be a freelancer with: -Significant experience in cloning scripts from one site to another -Ability to recreate the 'Select All' button for location selection as featured on the site -Detailed understanding of website structure and a proven track record in script implementation In your proposal, please demonstrate how you've accomplished similar pr...

...owner of a PHP-based website, I'm seeking professional assistance to revamp my homepage and transform it into a React one. I need someone who can: - Switch up the layout and design to a highly interactive React design, ensuring it's user-friendly and easy to navigate. - Integrate innovative and animated components to provide a visually striking user experience. While I haven't pinpointed exact animations or interactive components, I'm open to creative input from the developer to make this transition as seamless and efficient as possible. Additionally, I have not specified a particular goal for this modernized homepage, leaving room for a broad approach that caters to diverse visitor needs. Ideal candidates for this project should have: - Extensive experie...

I'm searching for male and female voiceover artists that naturally have a standard American accent to deliver these commercial script readings I will need 2x Male VO and 2x Female VO I will need line reading samples of provided scripts to send to client before proceeding with project. Thank you!

I am in need of an Excel specialist who can handle a large dataset of over 51,000 records. The data centers around employee contributions to political candidates. Specifically, I require detailed analysis on: - Contribution patterns - Candidate preferences - Employee demographics As an Excel expert, you should be proficient in working with pivot tables and be able to identify trends within large sets of data. Your experience managing, analyzing, and interpreting datasets should be well demonstrated. In addition, there is a particular interest in providing a thorough analysis of contributions based on political parties. This will help to understand better the political leanings within the dataset. To apply, please highlight your relevant experience. I look forward to seein...

I urgently need proficient help with excel. The tasks to handle include but not limited to; - Data entry. - Data analysis using relevant tools. - Leverage advanced excel formulas and functions to streamline data processing. The data to handle resides within 1-5 sheets and contains both numeric and categorical data. Ideal skills for the job include; - Advanced proficiency in Excel. - Deep knowledge of data analysis methodologies. - Quick data entry skills. - Understanding of Excel functions and formulas. Experience in processing both numeric and categorical data on Excel is crucial.

I'm seeking a detail-oriented freelancer with strong skills in text data entry, Excel, and who is comfortable working with less than 500 pages of data. Key Requirements: - Proficiency in text data entry - Strong familiarity with Excel - Able to handle less than 500 pages of data The ideal freelancer should efficiently turn raw data into an organized Excel spreadsheet. Accuracy is vital in this job, as any mistake could lead to incorrect data analysis. Please provide evidence of your past experience in text data entry and working with Excel.

Una aplicación web se migró de verisón de php y da varios fallos

...Type, Unity, Variety, Hierarchy (see Lecture 2) 2 point deduction For each instance of not following the functions of design: identification, instruction, promotion. (see Lecture 1) 2 point deduction For each element in the “include” sections that is missing 5 point deduction Assignment not turned in as a PDF Assignment turned in late (5 points for each extra day) Export Settings File>Export>Adobe PDF (Print)>SAVE>EXPORT IMPORTANT!!!! the files below show an example of what it can look like...

For days I have been trying to migrate a database (MSSQL to MySQL) using ODBC Datasource Administrator unfortunately this is not successful I get error 1822 "Missing index for constraint". I'm just doing it as an exercise, it's not a business project. I wanted to know if anyone here could help me with this. I also tried with AWS the problem is the same (constraints), it doesn't work.

I have an existing website based on a template using XHTML, PHP and CSS. The task is to migrate the existing site content, with a new domain name, onto an already purchased WordPress theme and make new links, upgrades and create some additional pages. A variety of WordPress plug-ins are required. Some are to replace existing functions, while others will add new features to the site. In addition, any End-of-Life MySQL and PHP is to be replaced for current versions and new data bases created. All web-pages should use the templates pre-installed in the WordPress theme, including the additional new web pages. The extra pages will enable site visitors to view up to 10 videos, each showcasing a single room or feature, which provide virtual tours of rooms and locations in the...

Tengo un Servicio que me permite crear páginas Web, pero necesito soporte para instalar aplicaciones en PHP al mismo y sus bases de datos MySql. Comunicación en Español únicamente..

...exercise materials for Excel, with a particular focus on Excel Macros, Array formulae, forecasting, countif, if statements, and all LOOKUPs. All exercises should come from dataset or data files KEY REQUIREMENTS: - The labs should cover 10 advanced topics, including but not limited to Excel Macros. - For each topic, I need 5 well-thought-out lab exercises created with step-by-step answers. - The exercises must be suitably challenging for advanced-level Excel users. - Each exercise should come with a step-by-step questions and answers guide to aid understanding. IDEAL SKILLS: - Extensive knowledge of Excel, especially in Macros and VBA programming - Proven experience in developing training materials or lab exercises. - Familiarity with financial modeli...

I'm in need of an expertly designed Excel spreadsheet that will serve as a dynamic sales reporting template. This tool will play a significant role in tracking and analyzing data related to various aspects of sales. The successful candidate in this role will incorporate tracking capabilities for variables such as: - Product sales - Revenue by customer - Customer % of revenue Furthermore, the spreadsheet should provide robust reporting on seasonality, current month vs prior year, and fiscal year to date (FYTD) vs the prior year. This comparative analysis is crucial in understanding trends and informing strategic decision making. Ideal Skills and Experience: - Proficiency in Excel - Experience in creating dynamic reporting tools - Understanding of sales data analysis - ...

...ward - Outputting the final product as a video The purpose of the video is for visualization, with a focus on showing the process of using an application, from a patient room, then nurse station, then migration to server room, then monitoring the process at monitoring and control room. The setting is compelling and we aim to create a narrative that highlights these areas accordingly. I have a script ready for a voice-over and would require the freelancer to incorporate it into the animation. Therefore, good understanding of timing and animation synchronization is crucial. The voice would be partly by male voice and part by female voice. Ideal skills and experience would include: - Proven record in 3D animation - Proficiency in 3D animation software - Ability to accurately in...

This project entails creating a Power BI report that is linked to Excel spreadsheets for trend analysis purposes. The main user of this report will be the sales team. I'm seeking a professional with: - Expertise in Power BI and trend analysis - Proficiency in handling and linking Excel spreadsheets to Power BI - Familiarity with sales data and crafting useful reports for sales teams. Your primary objective will be to create a functional, insightful Power BI report, providing our sales team with meaningful trend analysis based on our historical data stored in Excel spreadsheets.

For Excel sheet data typing, you'd be looking for someone proficient in data entry and manipulation, preferably with experience in Excel. Here are the ideal skills and experience: Proficiency in Microsoft Excel Accurate and fast typing skills Attention to detail to ensure accurate data entry Familiarity with common data manipulation tasks in Excel such as formatting, sorting, and filtering Ability to handle large amounts of data efficiently Knowledge of basic formulas and functions in Excel for data analysis and manipulation Experience in working with different types of data formats and structures Strong organizational skills to manage and organize data effectively Ability to troubleshoot and resolve data entry issues Understanding of data privacy a...

Need to upgrade my existing excel macro, very simple project

For this project, I need an individual experienced in data entry to transfer 159 sets of data from an Excel file into an invoice system. I won't specify the exact data to be transferred, but expect that it could be a mix of customer information, product details or payment details. When applying, don't feel the need to highlight past work, experience or provide detailed project proposals unless you feel it is relevant. Expected Organization of Data: - The data must be arranged by date once in the invoice system. Ideal Skills: - Proficiency in Excel and Invoice systems - Strong attention to details - Efficiency and accuracy in data entry.

Unify TXT files into Excel. (This data is good) This is a data merge project. Merge data from 3 txt files into excel. This is NOT a simply copy paste. The data needs merged. The data from 2 of the files will become columns of data in the 'master file' (see below) Download 2 files from here: Download 1 file from here: Note: This is public data it is completely permisable to use it. The files listed are: Deeds - don't use this file Owner: 1,817,424 lines. Step #1 for this file: Delete all rows that the aka pct_own is 0.000. This data will become columns of data in the master file ie: Owner 1 ln_num

要写一个网站，使用JavaWeb和MySQL技术，一个简单点的网站 1.用户登录注册 用户登录：学号、用户密码； 用户注册：姓名、学号、学校、院系、专业、班级； 2.在每个学生点击登录之后，进入兴趣选择页面。 3.学习兴趣标签添加页面； 4.资源展示页面 每个资源添加收藏、评价、下载、查看功能。 收藏：资源预览页面点击收藏，收藏到个人资源管理页面； 评价：资源预览页面上面提供星级评价（五星）； 添加标签：资源预览页面提供标签选择，让学习者为资源打标签。 5.个人资源管理页面 个人资源管理，资源可以查看、下载、取消收藏； 个人标签管理：学习者对添加过的所有标签进行修改或删除。 6.资源推荐页面 个性化资源推荐，热门资源推荐，资源检索框；