Export php mysql database excel jobs
I'm running a MySQL database and looking for an expert to help me optimize the query performance. Key responsibilities: - Analyzing the current database structure and configurations to identify areas that need optimization. - Implementing efficient indexing strategies and query tuning to enhance the query performance. - Providing insights and recommendations on how to maintain and keep the optimized database running smoothly. Ideal skills and experience: - Proven experience in MySQL database management and optimization. - Strong understanding of database performance metrics and monitoring tools. - Familiarity with indexing strategies and query tuning techniques. - Excellent problem-solving and analytical thinking capabilities. This ...
I'm looking for a skilled web developer to create a data-driven website with interactive graphs and user access levels. The website will primarily serve as a platform for data visualization and export. Key Functionalities for Admin User: - **User Management:** The admin should have the capability to manage user accounts, including setting access permissions. - **Graph Creation:** The admin needs to be able to create visual representations of data. - **Data Viewing and Exporting:** The admin should be able to view all the data and export it to Excel for further analysis. Graphs Per Department: - **Data Points:** The graphs should focus on data from Sales, Expenses, Profit, and Number of Employees, using a rolling average approach for accuracy. - **Rolling Aver...
...of both text and numeric data from PDF files. The extracted data will then need to be arranged in a specific format in an Excel sheet. Key Responsibilities: - Extract both text and numeric data from PDF files - Perform the data extraction on a weekly basis - Arrange the extracted data in specific columns and rows in Excel Ideal Candidate: - Proficient in using PowerAutomate for data extraction - Experience working with PDF files and Excel - Attention to detail for correct formatting of data - Ability to meet weekly deadlines - Strong communication skills to verify data accuracy Please find attached pdf (extract) example (there is 5 different templates to use) & excel (input). Looking forward to working with you! We have many more use cases like this,...
I'm in need of a highly skilled AWS OCR specialist to help extract data from a large number of PDF invoices. We intend to export the extracted data into an Excel (XLSX) file. All invoices follow a consistent format, as shown in the attached sample. All invoices have been scanned at 300dpi resolution with searchable OCR enabled." Key Requirements: - Proficiency with OCR technologies, particularly those integrated with AWS services (Textract) - Experience with extracting data from PDFs, especially invoices. - Ability to export extracted data into Excel format. The freelancer will supervise the implementation process on our PC. Due to confidentiality, access to the invoices will be provided remotely on my PC
I'm currently using SQL Express and I'm looking to upgrade to the Standard Edition. I also need assistance with backing up and restoring my medium-sized database (1GB to 10GB). Key Requirements: - Upgrade SQL Express to SQL Standard Edition - Backup and restore an existing medium-sized database - Ensure the process is seamless and data integrity is maintained Ideal Skills and Experience: - Proven experience with SQL Server upgrades - Excellent understanding of database backup and restore processes - Familiarity with SQL Express and Standard Edition - Strong attention to detail to ensure data integrity Please apply if you have a successful track record in similar projects.
I need a seasoned Excel Macro developer to help me create a macro to automate repetitive tasks and generate daily reports. Key Requirements: - The macro needs to be compatible with Excel 2016, as this is the primary version I'm working with. - I'll need to run the macro daily, so it has to be stable and reliable for consistent use.
I need a skilled PHP developer to help me troubleshoot and resolve an issue on my website. - The error message is appearing as soon as the homepage loads, which is affecting user experience and potentially driving away traffic. - The bug needs to be identified and fixed promptly to ensure the site's functionality is fully restored. - This requires a developer with experience in debugging PHP websites, particularly on the homepage. The ideal candidate would have: - Strong proficiency in PHP and website troubleshooting - Experience in resolving error messages and improving website performance - A proactive and problem-solving approach to identifying the root cause of the bug - Excellent communication skills to keep me updated on the progress and any additional r...
I'm looking for a SuiteCRM developer who can help me with the following aspects of my CRM system: - Customization of...current modules in SuiteCRM to be tailored to my specific business needs. - Integration with QuickBooks: I aim to synchronize customer data between SuiteCRM and QuickBooks. This involves setting up a mechanism for seamless data transfer and ensuring data consistency between the two systems. The ideal candidate for this project should have experience in SuiteCRM development, proficient in PHP and MySQL, and have prior experience in integrating this CRM system with QuickBooks. A strong understanding of CRM systems and finance software is also desirable. Please apply if you believe you have the necessary skills and experience to complete these tasks sw...
I'm seeking an experienced MS Excel specialist for a freelance data analysis job. Key Responsibilities: - Execute thorough data analysis using Excel. - Generate actionable insights from the data. - Prepare and present reports based on findings. Ideal Candidate: - Proficiency in MS Excel. - Proven experience in data analysis. - Strong analytical and problem-solving skills. - Excellent attention to detail.
I need a meticulous and detail-oriented freelancer to assist with numerical data entry for the purpose of data analysis. Key Requirements: - The data you'll be working with is in a digital format, mainly in Excel and CSV files. - You will be responsible for accurately entering this numerical data. Ideal Skills and Experience: - Proficiency in Excel and data entry. - Experience with numerical data analysis. - Attention to detail and accuracy. - Ability to work with large sets of numbers efficiently.
I'm looking for an experienced professional to help me install a Domain Validation (DV) SSL certificate on my website hosting server. Key Requirements: - Install a Domain Validation (DV) SSL certificate - Experience and technical knowledge in SSL certificate installation on website hosting servers I already have the SSL certificate, so the main task will be the configuration and installation. Attention to detail and ensuring a smooth transition to HTTPS is crucial. Looking forward to working with a skilled individual who can get this done efficiently.
...and intangible assets, as well as financial assets. - The Ultimate Goal: The primary objective of this project is to implement robust asset management practices via a comprehensive depreciation forecast. I'm seeking a professional with: Creating a excel spreadsheet that i can download my asset register into and then have the worksheet calculate future annual depreciation say to 10 years. But also allow the ability to have the individual assets to be revalued either an increase or decrease in the original asset cost. This would mean the excel sheet would need to be able to take into account prior accumulative depreciation and adjust in the year we are currently reporting in. The attached file is current assets as at 30th June 2023. No depreciation has ran for FY24 ...
I'm in need of a freelance job, specifically requiring assistance with Excel. This project is tailored for someone with experience in the following areas: - **Excel Expertise**: I'm looking for someone who is proficient with Excel, especially in handling data analysis tasks. The ideal candidate should be comfortable with manipulating large data sets and extracting key insights from them. - **Data Analysis Skills**: A strong background in data analysis is crucial. You should be able to interpret data, identify trends, and provide meaningful conclusions based on your analysis. - **Attention to Detail**: As this job involves working with data, high attention to detail is a must. The ability to spot errors or irregularities in data sets is crucial to the succe...
I'm in need of a dedicated PHP developer for a long-term project, focusing on website development. Your main responsibilities will include: - Creating a robust, efficient website from the ground up - Implementing user interfaces and features - Handling server-side logic The type of website isn't defined yet, allowing flexibility in your development approach. As there's no strict timeline, the focus is quality over speed - a meticulous and thorough development process is encouraged. Ideal Skills: - Proven experience in PHP web development. - Strong knowledge of server-side logic, databases, and UI design. - Problem-solving skills and attention to detail.
I'm in need of a skilled accounting professional who can seamlessly handle a variety of accounting...bookkeeping, financial analysis, and tax preparation. Key Responsibilities: - Timely and accurate bookkeeping: Keeping track of all financial transactions. - Perform financial analysis: Analyzing financial data and creating financial models to support decision-making. - Tax preparation: Preparing and filing tax forms in a timely and accurate manner. Ideal Skills and Experience: - Proficient in Excel, Tally Prime, and Zoho Books. - Strong understanding of bookkeeping, financial analysis, and tax preparation. - Prior experience with daily accounting tasks. - Excellent attention to detail and organizational skills. - Strong communication skills and ability to work efficiently an...
...an existing Excel calculator into a web-embeddable format for integration on our website. The calculator should perform basic arithmetic operations and allow user input for the calculations. At the moment the user has to imput the item being stored and the size of the shed and it will tell them how much it can store of that item. We want this reversed and the user will put in the item they want to store and how much they want to store and it will calculate the size the shed will need to be. Key Requirements: - Convert an existing Excel calculator to a web-embeddable format - Ensure it performs basic arithmetic operations - Allow users to input values for the calculations - Optimally integrate the tool within our website Ideal Skills and Experience: - Proven experience ...
I am in need of a freelancer to help with copy typing from online databases. - I need the data to be copied accurately from these online databases to a specific format. - The entries are in text format, so you would need to have good typing skills and attention to detail. Ideal Skills: - Proficient in typing and data entry - Experience with online databases - Detail-oriented and accurate in data entry.
I'm looking for an experienced PHP developer to develop an examination portal on my education website. This role requires skills and knowledge in user interface design, database setup, and PHP coding. Key Features: - Exam Scheduling and Notifications: The portal should allow the scheduling of exams and send out appropriate notifications to concerned parties. - Exam Results Generation: It should also facilitate the quick generation and publication of exam results. Key Skills: - PHP development expertise; depth in full-stack is a must-have. - Experience in developing web-based education platforms or similar. - Proficiency in database management and security mechanisms. - Ability to balance functionality and aesthetics in user interface design. Yo...
...doctors, hospitals, pharmacies, and laboratories. This system will offer discounts to registered patients and facilitate medical appointment scheduling, as well as manage profiles for doctors, patients, patients' relatives, companies, pharmacies, hospitals, and laboratories. - Technical Requirements - Programming Languages: HTML, PHP, JavaScript. - Libraries and Frameworks: jQuery, Bootstrap for responsive design, SweetAlert2 for custom alerts. - Database: MySQL. - Styles: CSS3. - System Features - Security: - Identification: Use CURP for patients and doctors; RFC with homoclave for companies, hospitals, pharmacies, and laboratories. - Secure Login: Two-factor authentication (password and WhatsApp message). - Doctor Module: 1. Registration and Au...
I need a talented artist and copywriter to create two persuasive sales pages. These pages will showcase two of my products, aiming to convince both potential customers and licensees of their value. Specific responsibilities will be: - Creating a photo-realistic 3D rendering of each ...copy that effectively communicates the value of the products, but more importantly - it sells the benefits (not the features). Ideal candidates should possess: - Excellent 3D rendering skills - Experience in persuasive sales copywriting - Understanding of how to appeal to both customers and licensee parties - Previous success in converting sales pages. This is a wonderful opportunity if you excel in merging artistry with persuasive sales copy. Let's increase the perceived value of these pro...
52 sheet for 52 week needs to contain mon-Friday. I will register everydays expense on that.
I'm seeking an experienced WordPress developer with a specialty in MySQL databases to help me with optimizing query speeds. This personal project requires proficiency in both SQL database handling and WordPress development. Key responsibilities: - Analyzing my WordPress site's interaction with the MySQL database. - Tweaking and fine-tuning to enhance query speeds. - Testing and confirming the increase in performance. Skills and Experience: - Detailed knowledge of MySQL databases. - Extensive experience with WordPress development and optimization. - Proficiency in writing efficient SQL queries. - Ability to diagnose and optimize databases for better speed performance. This project offers the opportunity to showcase your skills in SQL optimizat...
This is a pretty straightforward re-drafting request for about 8 DWG files: (1) Amend DWG plans so that they clearly show / include the "title boundaries of the site per the certificate of title" (Convert Feet/Inches => Decimal, add Degress from North) (2) Propery Boundary will be marked in BLUE in the birdseye view, & BLACK in the Elevations. (3) Changes Propagated all the way through the full plans and formatting made consistent. Ideal Freelancer: - Proficient in AutoCAD, SketchUp, Revit or any DWG editor - Previous experience with architectural drafting - Understanding of reading and converting plans in architectural design Please do not hesitate to reach out if you need any further clarification.
Hello, I need to obtain comments from Facebook live with my php code in real time, to then do something with this (for now I only obtain and be able to view them) The person applying for this job should know how this works since I think you need to create an application with permissions or something like that. Write Ragnar if you read the post so I'll keep you in mind. thank you.
...of posts; every time an update is made it takes exceedingly long, undermining efficiency and productivity. We've identified that it's related to wordpress WPML plugin's SQL queries. To solve this issue, I'm specifically looking for a professional who can optimize our database. Familiarity and experience with the WPML plugin is a must. Additionally, we've made several modifications to our database structure and queries which include tables, SQL, and indexes modifications. Skills Required: - WordPress development - SQL database optimization - Experience with WPML plugin - Deep knowledge in modifying tables, SQL queries, and indexes. This job requires a thorough understanding and hands-on experience in these fields to ensure all issues are...
I am in need of a professional who has experience using VBA in MS Project to automate the process of generating project summary reports. So the person MUST have Ms Project experience to understand how project constructs data. Key tasks include: ...track record in automating and streamlining reporting processes. Previous experience in project management reporting is ESSENTIAL. I'm looking for someone who understands project progress reporting and can deliver efficient, accurate results. If it turns out that it is not possible to achieve the type of reporting in MS Project then i will consider outputting the data to Excel, and creating suitable dashboards in Excel. (I might also later on ask to repcate these dashboards in Powerbi, but at the current project we do not h...
...1. Dataset and Topic Selection: Choose any publicly available dataset that interests you, whether related to environmental issues, public health, economics, sports, finance, real estate, or any other field. The key is to select a topic that allows for insightful data analysis and storytelling. 2. Tool Selection: You can use any data visualization tool you are comfortable with, such as Microsoft Excel, Power BI, Tableau, or others. 3. Dashboard Creation: Design a dashboard to be informative and visually engaging, using a variety of charts, graphs, and visual elements to convey critical insights effectively. The dashboard should be structured to communicate the story or analysis, making it easy for viewers to understand and derive conclusions. 4. Video Presentation: Record a 7-10 m...
As an owner of a website fraught with problematic PHP code, I urgently need a skilled PHP developer who can engage in troubleshooting and problem-solving to ensure optimal website performance. This task includes, but is not limited to, diagnosing and fixing error messages, enhancing the speed of the system, and repairing any broken functionality. Since the specific purpose of this PHP code wasn't detailed, the ideal freelancer would need to be versatile and have extensive experience in various areas of PHP, particularly areas such as website functionality, database management, and user authentication. Key Skills and Experience: • Complex problem-solving ability • Strong working knowledge of PHP and web technologies • Demonstr...
I'm looking for an expert PHP developer to help me with debugging and fixing errors in my custom web application. The current issue I'm facing is related to login. Key responsibilities include: - Investigating the login issue thoroughly and fixing it - Providing recommendations to enhance the application's security The ideal candidate should have: - Extensive experience in PHP development, particularly in debugging and fixing errors - Prior experience with custom web applications - Good understanding of security practices in web development Your expertise in PHP and problem-solving skills will be crucial in ensuring the smooth operation and security of my web application.
...whether through direct sources or white-label resellers and the performance of various marketing channels (e.g., Google, Instagram). Technologies: Backend: Python with Django or Node.js with Express for API development, or a low-code/no-code solution like Bubble. Frontend: React or Angular for a dynamic and responsive user interface, or a low-code/no-code solution. Database: PostgreSQL or MySQL for data management, or integrated database solutions provided by low-code/no-code platforms. Authentication: Implementation of JWT or OAuth for secure access, or use built-in security features of low-code/no-code platforms. Email Service: Integration with email platforms like SendGrid or SMTP servers for sending notifications, or use built-in services from low-code/no-code t...
I'm currently facing severe slowdown issues with my WordPress website due to slow MySQL queries. I'm looking for a professional who could help me identify and resolve these performance bottlenecks. plz find attached details
Dear Candidate, As described in the title, this task requires that you reasearch medical centres (also called general practice medical centres, family physician clinics, clinics) and find out who the owners of these clinics are are using internet research. You will have to be fluid with excel, online reasearch tools. This is a posting for a long-term VA who can perform various forms of online research and other tasks. Personal attributes required: 1. Speed and efficiency in online research. 2. Attention to detail and complete accuracy in all tasks. 3. Punctuality and ability to meet deadlines. 4. Ability to read/follow instructions carefully with attention to detail. Successful candidates will be required to complete two test works before the project is awarded. 1. Watching i...
...particularly interested in monitoring three key data sets: - Patient volume - Revenue - (PPC) This data need to be updated and reported on a monthly basis, presented in an accessible and understandable way for our administrative team. The reporting format we require is spreadsheet, so proficiency with Excel or a similar program is a necessity. Ideal candidates for this job would have: - Strong data analysis skills - Previous experience with financial and PPC data - Proficiency in Excel or similar spreadsheet software - Ability to deliver monthly updates in a timely manner Through this analysis, our goal is to gain a clearer understanding of how patient volume, revenue, and PPC are impacting our clinic and individual doctors' performances and devise data-driven s...
we have 645 pages in the attached Excel spreadsheet that we need to write 150-200 words about the product as content for each page.
I am in need of an Excel expert who can assist me predominantly with data analysis tasks. More specifically, the ideal individual should be adept at: - Utilizing Excel effectively with the @Risk add-on, - Performing a Monte Carlo simulation to analyze risk, - Wielding strong analytic capabilities to interpret and communicate the simulation's results. The task will require a deep understanding of data analysis techniques, a keen eye for detail, and fluency in data visualization. This role is perfect for seasoned Excel professionals with past experience in risk analysis and simulation.
I'm in need of a skilled PHP developer to create an examination portal for an education website. This would primarily be web-based, making it accessible through a website. Key Features: - Exam Scheduling and Notifications: The portal should allow the scheduling of exams and send out appropriate notifications to concerned parties. - Exam Results Generation: It should also facilitate the quick generation and publication of exam results. Key Skills: - PHP development expertise; depth in full-stack is a must-have. - Experience in developing web-based education platforms or similar. - Proficiency in database management and security mechanisms. - Ability to balance functionality and aesthetics in user interface design. Your ability to work towards a seamless expe...
I am looking for an expert in data analysis and excel who can compile specific data for certain doctors in our clinic. The data metrics required include: - Volume - Revenue - (PPC) The data should be organized both doctor-wise and clinic-wise for effective comparison and understanding. You should be able to present the data in an easy-to-understand, concise and visually appealing manner. Key skills required for the project include proficiency in: - Data analysis - Excel data manipulation - Understanding of PPC metrics - Attention to detail Experience in health-related data analysis would be a plus. Sub-headings should be WOW (week over week), MOM (month over month), MTD (month to date), and YTD (year to date), reflecting the volume, revenue, and PPC for each particular ...
I am looking for an expert in data analysis and excel who can compile specific data for certain doctors in our clinic. The data metrics required include: - Volume - Revenue - (PPC) The data should be organized both doctor-wise and clinic-wise for effective comparison and understanding. You should be able to present the data in an easy-to-understand, concise and visually appealing manner. Key skills required for the project include proficiency in: - Data analysis - Excel data manipulation - Understanding of PPC metrics - Attention to detail Experience in health-related data analysis would be a plus. Sub-headings should be WOW (week over week), MOM (month over month), MTD (month to date), and YTD (year to date), reflecting the volume, revenue, and PPC for each particular ...
I'm in need of an Excel VBA expert who can assist me with writing macros and automating data entry in my spreadsheets. The primary goal of these macros is to automate the data entry process and streamline the subsequent data analysis tasks. Key project requirements: - Building custom macros: I need help with building macros that can automate data entry tasks and facilitate data analysis. - Data analysis focus: The macros should be designed to support data analysis, particularly with a focus on data visualization. - Expertise in Excel VBA: Proficient in Excel VBA is a must, with a proven track record of designing and implementing complex, data-focused macros. - Understanding of data analysis: A strong understanding of data analysis is crucial to ensure the macros ...
I need an expert in Microsoft Excel to create a functional, cleanly-designed household income and expenditure sheet from scratch. This task involves: - Data entry: This household finance sheet should allow for comprehensive tracking of earnings and spendings. - Formulas and calculations: The spreadsheet should automatically compute totals thereby providing a real-time, holistic view of my financial landscape. - Formatting and design: The sheet should be intuitively organized and visually appealing for ease of use. I haven't decided on a specific template yet, so there's an opportunity to be creative and propose a clear, easy-to-understand format. The sheet should have a basic level of detail, categorizing different types of income and expenditure, but without the need f...
I have an existing PHP script, wich reads the data from an spotify order and process the data into different other systems. I need a code snippet, which will save the tracking number to the order so that the customer will get the email with the tracking number as soon as the order is ready for shipping. Goal is: A php code, which I can hand over the order id and the tracking number. The script should save the data in the shopify via the API. Should be just a few lines of code. As the wevserver is a public server, it is not possible to install other packages, therefore it should be just PHP native code.
I'm seeking a skilled PHP developer experienced in working with CS CART. The project involves: - Seamless API Integration: The ideal candidate must be familiar with integrating APIs effectively. - Efficient Database Management: You should have proven skills in database management to ensure everything runs smoothly. - Custom PHP Programming: We'll need custom solutions not provided by standard CS CART functions, hence, proficiency in PHP is a must. The completed project must epitomize a modern design. Therefore, the right freelancer should also have a flair for modern aesthetics. An understanding of CS CART is crucial for this job. Previous experience working with this CMS will be highly regarded.
Hi, I am a Civil Engineer with 20 years of expe...Management from Amman-Jordan. I am now seeking a role that will allow me to leverage my skills and expertise while advancing my career to the next level. I am particularly interested in positions that offer leadership opportunities in innovative projects in the Gulf region (Saudi Arabia, UAE, Qatar, etc....), My background in Civil Engineering combined with a PMP certificate uniquely positions me to excel in roles that demand technical and professional skills. The milestone for this project will be to land a new job position, I'm open to discuss any suggestions on how to work this out. Attached a copy of my CV. Thank you for considering my request. I am eager to embark on this journey with your guidance and support. Best r...
I'm in urgent need of a skilled Wordpress PHP developer to help me add a specific functionality to an existing plugin. We need this task done within 24h! We have a custom coded plugin that is creating PDF file from the woo products. Plugin is successfully generating the PDF, but is not saving the PDF to the files. I need following plugin adjustments: - plugin should save PDF to a certain location - when products list is updated, it should save new PDF and override old one (keep the same name of the PDF) We deem this a simple task and our MAX BUDGET IS $45. DO NOT APPLY IF YOU DO NOT AGREE DO THE BUDGET.
I need an experienced database developer to create a highly functional Access database. Required functionality: - Robust data entry and retrieval system - Capable of generating custom reports and analyses - Seamlessly integrated with other software The database will store: - Customer information - Product inventory - Sales transactions Expectations: - Development of significantly more than 10 tables - Efficient organizing and handling of these tables The ideal candidate should possess significant experience working on Access Database creation, be able to confidently handle extensive data and complex systems integration. Expertise in table management and data analysis would be an added benefit.
I need an expert to set up a reliable API connection for data integration between a third party booking engine and our own inhouse booking engine. Our system is PHP laravel The ideal professional for this project should have: - Proven experience in establishing API connections, particularly for data integration. - expert knowledge of PHP laravel and Mysql. - Capability to work with a variety of systems or platforms for data exchange. I attach the API instructions and will send full details to those who we seem fit for the job. Looking forward to your proposal.
I need support in adapting my Excel sheet into a DataFrame, geared towards reporting purposes. While the Excel sheet structure is not concrete, the relevant columns to be extracted and placed in the DataFrame tend to be A, B, and C. However, I'm undecided at the moment on whether this extraction process should be manual or if the system should automatically detect and save the columns. Ideal Skills and Experience: - Expertise in Excel and data analysis tools - Experience in creating data frames for reporting purposes - Ability to advise on manual versus automatic extraction.
I am looking for someone who can help me correct some formulas and formatting errors in my Excel spreadsheet. - The spreadsheet contains Sum and Count formulas that need to be fixed. - There are also formatting errors that need to be addressed. Ideal skills: - Proficiency in Excel - Experience with formula correction - Attention to detail for formatting errors.
