Read data excel sheet using save mysqlcông việc

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

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 and SQ...

I have a printed diary that I need to be transcribed...Proficiency in English is also crucial. - I am not interested in maintaining the same layout and format as the original printed diary, a simple transcription to PDF format is needed. -There are pictures on some of the pages, I want to move them to their own pages and will need to label them - The final product should be a PDF document. It's important to ensure that the PDF is of high quality and easy to read. - While the task sounds simple, it requires concentration and attention as it's important that no details from the diary are lost in the transcription process. In conclusion, I'm seeking someone meticulous, with transcription experience, familiar with PDF formats, who can convert my printed diary into a h...

...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...

...responsibilities will include: - Managing my emails with the utmost discretion and 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 softwar...

...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 essen...

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

...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'm seeking a Python expert to develop an auto-trading program for the CoinEx futures market to be deployed on AWS. Here are the details: - Save pricing information into a database on AWS - The trading strategy you need to implement is 'Mean reversion'. - The program should strictly use the 'RSI' for executing trades. - The time frame for calculating the 'RSI' should be every '1 minute'. - A robust trade tracking system that also alerts me to trades taken and closed via a Telegram bot The ideal freelancer for this project has experience with: - Python programming - Algorithmic trading - Experience working in AWS and the database options available - Understanding of RSI and Mean reversion strategies - Familiarity with CoinEx futures mar...

I need a skilled designer who can efficiently create a detailed snowboard construction design. Key features of the design should be: - Emphasizing the core, laminates, inserts and top sheet, base, and fiberglass aspects of a snowboard. - Delivery in a detailed breakdown manner to enlighten individuals about snowboard construction design. - Design that reflects the technical aspects of what's inside a snowboard tuned for all-mountain snowboarding. Ideal freelancers for this task would have: - Expertise in designing and understanding the technical aspects of sport gear, specifically snowboards. - Proficient skills in technical drawing and presenting complex information in an accessible way. - Strong creativity and passion for freestyle, freeride and all-mountain snowboarding.

I'm seeking a skilled freelancer to assist me in formatting corporate documents through custom templates. Here's what you should know: - I have selected PDF as the preferred format for these documents. - The documents need to be edited and formatted according to the instruction sheet - PDF editing capability is required and detailed instructions are included here -estimated time to read the instruction and complete the task is 2 hours - this is a one off job

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!

Hello, I have a 3D model and Ansys heat transfer air flow simulations of a part. I need "topology optimization" to be applied to the part in order to have maximum heat transfer and smoothest flow. Topology optimization should be mathematically modeled by using a software such as Ansys (preferably) or MatLAB.

...expert in Solid Works CAD, specifically proficient with STEP files, to help with revising my current plastic enclosure design file. Your task will involve adding drill holes in the specified areas on the plastic enclosure model. Key Tasks: - Making additions of drill holes, specifically on the top of the plastic enclosure. - The placement of these holes must be relative to other components. - Save the revision to a STEP file. - Create a 2D PDF document highlighting the measurements of each hole that was added. Ideal Candidate: - Detailed understanding of Solid Works CAD. - Proven experience with STEP files. - Ability to extrapolate relative positioning of drill holes. - Proficiency in creating 2D PDF documents. In your application, please include your experience with Solid W...

I am looking for a skilled pattern designer to create appealing floral patterns for textile use. The final designs should be artistic and resonate with a youthful audience. The ideal candidate should have: - Proven experience in designing patterns, particularly floral ones. - A good understanding of trends in apparel design. - Be capable of producing designs that is appealing Responsibilities will include: - Producing original floral pattern designs. - Adapting designs to clothing cut-outs. - Incorporating feedback to refine designs. Looking forward to hearing from you! Please include a portfolio or examples of previous pattern work in your proposal.

I'm seeking a Google Ad expert with high level of understanding and experience in conversion-centered campaigns. Key requirements include: - Proficient in creating and managing successful Google Ad campaigns aimed at boosting conversions, specifically lead generation. - Expertise in geographical targeting for lead acquisition is a must, as our campaign is focused on a location-specific audience. - Exceptional skills in analyzing campaign performance, tweaking strategies as per insights and reporting on improvements will be ideal. Your ultimate goal will be to significantly boost lead generation for a location-specific audience through our Google Ad campaign. Note: I will provide you with certain ad budget for a month and if you are able to significantly boost conversions, I will...

I'm looking to solve a classification problem with my tabular data using Python. Skills and Experience Needed: - Capability in Python programming is crucial, familiarity with libraries such as pandas, sklearn, and keras is necessary - You should be proficient in machine learning algorithms, specifically focusing on data classification - Experience in handling and manipulating tabular data for machine learning applications - Understanding of data cleaning, preprocessing and feature engineering Project Requirements: - Development of a Python-based data classification model - Utilizing machine learning techniques to process tabular data - Rigorous testing of the model's accuracy and improving it if required - Documenting the step...

Just to summarize with the budget given, so will improve the newest posted blog posts and add content on those up to 50k words and also adding images on those that lack them. In addition I will fix the issues with the posts i go through on Ahrefs if issues are coming up for those. Next month we can resume more going down the list ( i am marking them green as im completing them in the sheet so I will know where left off at).

I am in search of a skilled ghostwriter to craft a compelling 15k words eBook in the Health and Wellness domain. This self-help book aims to engage readers through real-life stories and examples relevant to the topic. Your responsibilities will en...riveting, accessible content. Your goal will be to create a book that serves as a helpful guide for readers looking to enhance their health and well-being. Rather than focusing solely on theory, the book should be peppered with realistic examples that readers can relate to. Please Note: if your profile bid amount is not the price you will charge for this project, inbox me with your price and save us time to award this project to a serious bidder ready to work. I want the project to kick off immediately and do not want unnecessary...

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 fo...

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.

...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...

I would like a new WordPress website I need a theme that I have, which works with elementor, uploading to my webspace then recreating my existing website on the new theme, with customisations (add xx to the start of your proposal or it will not be read). I need customisation and pages adding the theme doesnt have. Services pages, case study pages, then a couple of forms. 12 Case study pages - 10/12 normal pages around 46 blog pages that will have to be moved to the new site with the exact URLS. Please read, bot proposals will be ignored. You must be able to add elementor and this theme to my existing webspace prior to working. ALL URLS and meta descriptions page titles must be the same as existing website but there will be content changes. THIS IS VITAL We want to ...

...app on demand. The user should be able to fill a shopping cart with different products, then put his address files in etc. and finally the bot needs to create a crypto invoice for the cryptocurrency of choice at current price and wait for payment confirmation from the crypto pay gate. Finally, once the order is confirmed, the bot needs to process all order information into a .txt or .csv file and save it locally on the machine. The script should also be able to decrypt PGP encrypted address information automatically. 2) Some sort of APIs between the bot script and all the messengers desktop sessions listed above that allow the bot script to communicate with each messenger. The purpose of this is to allow running regular non-business, non-shop affiliated messenger accounts as eff...

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...

...user-friendly homepage design & 2 Inner Pages for our website. Budget : INR Rs. 1000 Only Responsibilities: Design a responsive and conversion-focused homepage layout & 2 Inner Pages using Figma Ensure the design aligns with given demo concept Demo Design will be provided using canva design Provide at least 2 initial design concepts for review and feedback Iterate and refine the design based on feedback from our team Deliver a clean, well-organized, and commented Figma file with the final design Requirements: Proven experience in designing visually appealing and conversion-focused website homepages using Figma Excellent understanding of UI/UX principles, web design best practices, and responsive design techniques Attention to detail and ability to mee...

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..

As a professional involved in the field of data analytics, I'm in need of an expert to develop advanced lab 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 an...

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...

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 troubleshoo...

Need to upgrade my existing excel macro, very simple project

Vui lòng Đăng Ký hoặc Đăng Nhập để xem thông tin.

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.资源推荐页面 个性化资源推荐，热门资源推荐，资源检索框；

The function (I didn't write it): input: Path of a video file. [would be nice to also allow audio files] output: Array of the volume of all frames of the file. PHP Version 7.2.34 Edition Windows 10 Home Version 22H2 Installed on ‎11/‎7/‎2020 OS build 19045.4170 Experience Windows Feature Experience Pack 1000.19054.1000.0 Device name DESKTOP-TBNFM6D Processor Intel(R) Core(TM) i3-10100 CPU @ 3.60GHz 3.60 GHz Installed RAM 8.00 GB (7.85 GB usable) Device ID 0334C4DF-2DEE-401E-A453-E30F4EB12586 Product ID 00325-81840-60585-AAOEM System type 64-bit operating system, x64-based processor Pen and touch No pen or touch input is available for this display

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.

...need an Excel VBA utility that is able to perform calculations, specifically advanced financial modeling for cost using VBA & Macros. I require complex projections for various scenarios to be calculated through this utility. This tool should enable me to: - Efficiently perform cost calculation for a project and financial based on inputs - Efficiently calculate the cashflows automatically based on the inputs. - Generate advanced financial projections incorporating different scenarios. Ideally, the freelancer taking this project on would have a robust background in both financial analysis and Excel VBA programming. Proficiency in financial modeling (Including Project cost calculation) and a solid understanding of finance principles is necessary. Experience with...

I require an expert PHP developer with deep knowledge in Shopify API and MySQL. The project will entail connecting to the Shopify API to extract the following information from all paginations in the API into a MySQL DB: - ID - Status - Body HTML (Boolean - if no content, then 0) - Inventory item ID - SKU - Inventory quantity - Images (Boolean - if no images, then 0) - Option 1 - Option 2 - Price - Compare at price This task needs to be completed urgently as time is of the essence. Ideal candidates should have a track record for rapid delivery without compromising on the quality. Previous experience in similar projects will be an added advantage. I look forward to your proposals.

I need a MySQL database created for my Android recipe app. The database should support the following: - Storing complete recipes - User data For the complete recipes, I want to store the following specifics: - Recipe title - Ingredients - Preparation instructions - Cooking time The ideal freelancer for this project should have prior experience in creating databases for Android apps, a solid understanding of MySQL, and appreciate the importance of structuring data efficiently for high user quality experience.

I am seeking an experienced website designer with a strong background in e-commerce to create a website tailored for selling digital products and services. The website must provide a user-friendly experience for potential customers. Key features: * A fully efficient shopping cart system that aids smooth transactions. * An advanced product search function to help customers find specific digital products or services. * A system that supports customer reviews and ratings to promote transparency and trust. Given the nature of the products and services we're offering, the successful candidate should have an understanding of how to present digital products and services in a way that appeals to customers and enables efficient buying. Prior experience in creating e-commerce sites with th...

I am in need of an experienced PHP developer with extensive knowledge in backend development and proficiency with PHP 8. The right fit for this role will have a deep understanding of: - PHP 8: Thorough understanding and proven experience with PHP 8. Your task will primarily involve backend development, to ensure seamless functionality of my project. - MySQL Management: You should be well-versed with MySQL, as you will also be handling the database management system of the project. As a developer for this project, you will handle a lot of responsibility, hence previous work experience in these specific areas is a must-have. Looking forward to your bids!

I am seeking a developer to complete a WebAR viewer that...is against black and you use your fingers to rotate it, zoom in etc. 3. Have it cast a shadow on the real world when in AR mode. I will need to be able to swap out the model although this could be done within 8th wall or Glitch or similar rather than in the app itself. Please note: This is using .splat files. I know this can be done very simply with .glb or other but this specifically needs to use .splat files. This does make this project more challenging than at first sight so please read through the docs and make sure you are comfortable with what is being asked. There are mode details on the project and access to the files here:

...maintaining all pre-existing functions. Details: The functions of the 3 projects are almost the same. The data is read from the plc and then uploaded to the mes system. The difference lies in the number of data read and the difference in uploading to the mes interface. These items contain Chinese characters. Please add Chinese character support to your operating system to avoid losing information. Since all three C# projects were constructed using the same version of C# and compatible frameworks, I need a specialist who can ensure smooth integration without compromising any functionalities. Ideal Skills and Experience: - Expertise in C# - Experience in project integration - Knowledgeable about data management, user authentication, and repo...