Mysql und excel data exchangepekerjaan
In search of a competent Excel specialist adept in Microsoft Access for multiple automation tasks. I need assistance with: - Macros Development: The main tasks include automation and creating tools. The proficient use of macros in daily operations is essential. - Report Generation: Specifically, the generation of technical proposal reports. Alongside this, the candidate should also be capable of automating the formula calculation process. Familiarity with financial, sales, and project status reports is an added advantage. - Tool Building: The capacity to build tools and other operations geared towards improving efficiency is crucial. Ideal skills include deep understanding of Excel functionalities, proficiency in Microsoft Access, extensive experience in automation via macr...
I'm currently in need of a skilled professional versed in CSS3, HTML5, PHP, and MYSQL. My primary requirement consists of creating minimalist and clean CSS styles for specific pages, namely the products page, product view, and checkout page. In addition to this, there will be some light PHP work involved. The ideal candidate should have demonstrable experience in these areas and a good eye for clean and minimalist design. Efficiency and attention to detail are key.
...need an Excel expert to build a tool that can automatically validate and correct any incorrect country codes in the file. Requirements: - Replace incorrect country codes: The tool should replace the incorrect country codes with the correct ones. - Predefined list: The correct country codes should be determined based on a predefined list. - Daily updates: The tool should be able to handle daily updates. Ideal Skills and Experience: - Advanced Excel skills: You should have a deep understanding of Excel functions and VBA programming. - Data validation: Experience with data validation and manipulation in Excel. - Attention to detail: It's crucial that the tool is accurate in identifying and correcting country codes. - Timely updates: Exper...
...manage MIS excel sheets pertaining to data analysis, sales forecasting, and expense tracking on a daily basis. Key tasks: - Establishing excel sheets to analyze a broad range of data - Constructing a sales forecasting model within the excel sheets - Regular tracking and management of expenses via the excel sheets Data sources would primarily be spreadsheets and databases. These excel sheets will require daily updates, enabling close monitoring of key metrics. Ideal skills: - Proficient in Microsoft Excel - Exemplary skills in data analysis and modeling - Good understanding of databases and how to extract data from them Experience in handling and managing sales and expense data is crucial for th...
I need an expert to migrate my products from an Excel file to my WooCommerce store. Key Requirements: - Migrate products from an Excel file to WooCommerce - Use attributes to define variations within a single product - Update existing product descriptions during the migration Ideal Skills and Experience: - Strong experience with WooCommerce and product migration - Proficiency in handling product variations using attributes - Attention to detail for updating and modifying product descriptions - Excellent knowledge of data import/export and product management on WooCommerce. - Ability to ensure a smooth and error-free migration process.
Über uns- Service Club ist eine preisgekrönte Schulungs- und Weiterbildungsunternehmen,die in der gesamten EU tätig ist. Wir suchen derzeit einen Sitzungsleiter/Trainer zur Verstärkung unseres Teams als Freiberufler. Wenn Sie Freude am Wissensaustausch haben und über gute Deutschkenntnisse verfügen, möchten wir von Ihnen hören. Aufgabenbereiche: · Führen Sie informative Präsentationen in den Sitzungen durch, in denen Sie die besten Praktiken der Branche vorstellen. · Beantworten Sie Anfragen und unterstützen Sie die Teilnehmer während der Sitzungen. · Beheben Sie kompetent grundlegende technologische Probleme, sobald sie auftreten. · Überwachen Sie die Organisation von Verans...
We have an existing PHP/QuickBooks Online application designed to sync QuickBooks invoices to a MySQL database. The application works correctly when executed but we have an issue where the security token needs to be refreshed manually every 24 hours. We need to devise a way for this application to run with no requirement for refreshing the token manually. The program syncs orders in real-time so manual token refresh is not an acceptable way to do this. A developer is required with experience working with QBO applications and working with the QBO token refresh system so this refresh is done automatically.
I'm looking for a skilled freelancer who can help me with importing product data from XML sheets. The data needs to be imported into multiple Prestashop faced search feature tables. Key project details: - I need the product information to be imported - The data needs to be updated daily and in real-time - Multilingual support is not required, so a single language is sufficient Ideal Skills and Experience - Proficiency in working with XML data and importing it into systems - Expertise in Prestashop and its search feature tables - Experience with real-time data updates in web applications - Strong problem-solving skills and attention to detail Import data from xml sheets into multiple prestashop faced search feature table. Here's an ou...
Wir sind eine kleine Firma aus Berlin, die in Deutschland (und Europa) hochwertiges Kollagen D2C verkauft. Wir wollen unseren organischen Traffic weiter ausbauen und suchen dafür nach SEO Unterstützung. Konkret suchen wir für ein Set von spezifischen Keywords nach Support im Backlink-Building - in Form von Gastbeiträgen, Foren-Einträgen, etc. Uns ist die Qualität der Backlinks sehr wichtig! Der Kontext für unser Produkt muss passen, kein Spam, Gambling / Adult Content, etc.
I'm seeking a professional who can effectively promote and grow a Facebook group dedicated to the exchange of free items like furniture, clothing, and tools. This group is primarily targeted towards community service groups advertising donations. I aim to quickly grow a Facebook group to 10,000 members, focusing on connecting individuals across the USA who offer free items like furniture, clothing, and tools. Our objective is to foster a community that provides easy access to these resources. Freelancers should use organic traffic strategies to attract members. I'd appreciate a demonstration of your ability to increase group membership. Successful completion of this task will result in a monetary bonus for outstanding performance. Link for facebook group -
I have a significant amount of text that needs to be typed into Excel quickly. The data is in a simple text format, no complex formatting required. Key requirements: - Proficient in Excel and typing - Attention to detail - Ability to work under tight deadlines The data is straightforward text and requires no specific formatting or analysis. The ideal freelancer will be skilled in data entry and be able to commit to a quick turnaround time.
As a client with emphasis on quality, I need the support of an experienced Python programmer who can take charge of the frontend aspect of my web development project. At the core of this project are the following requirements: - Full proficiency in Python as the main programming language for the task - Demonstrated experience in frontend web development using Python - Familiarity with the best practices in Python programming - Capacity to effectively communicate, provide regular updates and accept feedback The missing response for the third question won't be an issue — I am more interested in a Python programmer who can bring their own unique ideas and solutions. You are encouraged to showcase your creative problem-solving skills. Apply if you have the necessary skills and ...
I am seeking an Excel expert who can meticulously enter extensive amounts of text, numeric, and alphanumeric data into my spreadsheet. The task involves entering names, contact details, sales information, and inventory data. The size of the task is quite substantial, with up to 1,048,576 rows and 16,384 columns involved. The role requires a keen eye for detail, accuracy, and dedication. If you are efficient in Excel and possess experience with handling large data sets, your skills will be highly valuable for this project.
I need a reliable freelancer to assist with data input. Here's a breakdown of the project: - **Task:** Your primary job will be to input data from online forms into either Microsoft Excel or Google Sheets. - **Experience Required:** It is necessary for you to have prior experience with both of these tools. This will ensure you're able to work efficiently and accurately. - **Attention to Detail:** Given the nature of the task, it's crucial that you have excellent attention to detail. Even the smallest mistake can have significant implications. If you have the experience and skills mentioned above, I would love to hear from you.
I'm seeking a professional with deep experience in MySQL and Linux OS to carry out an installation. * Desired Proficiency and Experience: - Linux Operating System: You need to be familiar with Linux as the installation has to happen on this platform. - MySQl 5.7: The installation is specifically for MySQL 5.7 and you should have experience with this exact version. * Task Overview: - Install MySQL 5.7 on my Linux machine following the Development Machine Settings. * Configuration: - MySQL should be configured to run optimally on a development machine setting. - Your skills should extend to understanding the unique configuration needs of a development system and apply those effectively. Looking forward to your bids, please feel free ...
I'm looking for a skilled C++ developer to create a CAD software primarily focused on 3D modeling, compatible with Windows OS. Key Features: - Primarily 3D Modeling: The software should excel in 3D modeling capabilities, providing robust tools and functionalities for creating and editing 3D designs. - Compatibility: The software should be specifically designed to run seamlessly on Windows operating system, ensuring optimal performance and user experience. - File Format Support: The software should support importing and exporting of DWG files, for compatibility with AutoCAD files. Ideal Skills and Experience: - Proficient in C++: Extensive experience in C++ development, with a strong understanding of software architecture and design patterns. - CAD Software De...
...analysieren und priorisieren von Anforderungen in agiler Umgebung mit verschiedenen Stakeholdern Quartalsplanung erstellen und ausgewählte Features im Agile Release Train integrieren Gestalten von Geschäftsprozessen für Organisationsverwaltung mit Fachbereichen wie Administration, Lehre und Forschung Planung und Koordination der Einführung neuer Features sowie Kommunikation zwischen den Teams und betroffenen Parteien Requirements: Du verfügst über eine abgeschlossene Ausbildung als Informatiker oder ähnliches, Master-Abschluss wird bevorzugt Hochschulabschluss in Informatik oder einem verwandten Fachgebiet mit umfangreicher praktischer Erfahrung Zertifizierung als Product Owner und mehrjährige Tätigk...
I require an expert in Asterisk and FreeSWITCH development, along with experienced system engineering skills. Specifically, I need help with: - Asterisk and FreeSWITCH development - Integrating VoIP - Setting up Call routing and IVR (Interactive Voi...system engineering skills. Specifically, I need help with: - Asterisk and FreeSWITCH development - Integrating VoIP - Setting up Call routing and IVR (Interactive Voice Response) - CTI - Skill group base call routing to agents. Apart from these, the implementation of Asterisk and FreeSWITCH clustering as well as Call Center Reporting is required. The technology stack should be Linux, PHP, MySQL along with postgresql and API knowledge. The freelancer should have considerable experience in these to meet the project's specifi...
Firstly, I want to know if what I am asking can actually be created in Excel 365 and used in Excel 365 Online. Please dont reply to this post without replying that it can or can't be done. If not, an alternative solution would be greatly appreciated. I need help creating an excel spreadsheet to track student progress in a course using 5 different options that also includes the date the option was selected. I can create the drop down list with the submission options, and apply color rules but I can not work out how to make the cell below change to the same color as the option selected and the date it was selected appear in the same cell. I need to include the date the option was selected selected and because you can't have two formulas in conditional form...
I am in need of a proficient Excel expert who can create a custom spreadsheet for me. This spreadsheet will help in calculating the overtime rates for my 6 employees on a monthly basis. Key Requirements: - The Excel sheet should calculate 3 types of overtime rates: standard (1x), holiday (2x), and evening/weekend (1.5x) - The formulae should be designed to take into account that an employee works a 40 hour basic week with typical overtime of between 1-20 hours. - The sheet should take into account that the employees are not paid for 30mins of travel time to and from work, the employees tell me what time they left home, arrived at site, left site and arrived home. - Standard hours are 08.30-17.00 Mon-Fri with a 0.5hour unpaid break and a 0.5 hour unpaid break if working over ...
More details: What type of data do you need to type into the Excel sheet? Text What is the source of the data that will be typed into the Excel sheet? PDF documents Will the data need any kind of formatting or should it be entered as is in the source document? Enter as is
I need a basic web application for maintaining an efficient inventory of automotive spares. The k...make, model etc. In the current scheme, we anticipate less than 100 spares in our inventory system. This is a very basic php/mysql application. I have created a rough up of the requirements using MS Access. I anticipate that the application will have; 4-8 tables. Main tables are - Contacts - Parts - Events 6-10 pages - Search Parts based on any field. - Search contacts - View/Create Contact with image upload - View/Create part with Image Upload and ability to print label - Create event associated with Part - Show all events related to part. Application needs to implement basic security requirement such as restricted access to webpages, 2 user roles, keeping data secur...
I require a highly skilled professional with dexterity in MS Excel and Video Editing. Tasks will encompass: For MS Excel: - Comprehensive data analysis - Detailed spreadsheet formatting - Advanced formula creation for profound financial analysis. For Video Editing: - Apt video trimming - Expert color correction - Adding text and graphics creatively to videos. Ideal candidate will have proven ability in both fields, demonstrating both attention to detail in data management, and creativity in video enhancement. Proficiency in financial analysis and data visualization is a major plus.
I'm seeking an expert in MS Power Automate, well-versed in implementing unique flows using different AI Chat APIs - particularly Chat GPT API and Cohere AI API. The primary task is to create a power flow capable of running batches of prompts effectively. Key expectations are: - Expertis...implementing unique flows using different AI Chat APIs - particularly Chat GPT API and Cohere AI API. The primary task is to create a power flow capable of running batches of prompts effectively. Key expectations are: - Expertise in MS Power Automate, API integration, and AI-oriented applications. - Background in working with Chat GPT API and Cohere AI API. - Ability to deliver results on a web excel sheet. Please note that an understanding of additional AI Chat APIs is highly valuable fo...
We're looking for multiple competent native English editors to help us improve English language usage in a big batch of Excel-related tutorials. No testing of tutorials has to be done as the technical aspect of the articles is fine but they've been put together by non-native speakers. Starting with a paid trial.
...functionalities. - Implement advanced security measures to protect users' BTC funds and personal information, ensuring compliance with industry best practices and regulatory requirements. - Design a user-friendly interface that enables seamless navigation, account management, and transaction tracking for users of all experience levels. - Integrate with external APIs and services for real-time exchange rate data, liquidity provision, and transaction processing to optimize platform functionality. - Provide comprehensive documentation and support resources for users, including tutorials, FAQs, and troubleshooting guides. **Key Requirements:** - Proven experience in developing cryptocurrency platforms or similar financial systems, with a focus on Bitcoin (BTC) transactio...
I have several thousands PDFs that need to be read, interpreted and transcribed into a supplied spreadsheet format. It is important that you: 1) Have an existing team to help with a task that is estimated to take 2 weeks 2) Proficiency in PDF to Excel transcription 3) Ability to complete the task efficiently Applicants based in India only.
I'm in need of a professional with expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Prod...- Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in SQL and MySQL. - Experience in creating and optimizing database tables. - Strong understanding of relational databases. - Ability to write effective and efficient SQL queries. - Excellent c...
I'm in need of a seasoned .NET developer who possesses the following expertise: - Skilled in developing Web API - Knowledgeable in MySQL as a database system - Need 5+ Years Experience This is a personal project and I'm seeking someone reliable, efficient, and with a firm grasp on these skills to ensure successful implementation. If you have the experience and are keen on a unique personal project, I encourage you to bid.
I'm in need of a professional with expertise in SQL and database creation to help me with the following tasks: - Create tables: Your main tasks will be creating tables for the entities of Users, Prod...- Design and implement a solid SQL database structure that encompasses the entities I've mentioned. - Create tables efficiently and logically. - Write clear and effective SQL queries that correspond to the database structure. - Ensure that the database is optimized, both in terms of performance and storage efficiency. Ideal skills and experience for this job include: - Proficiency in SQL and MySQL. - Experience in creating and optimizing database tables. - Strong understanding of relational databases. - Ability to write effective and efficient SQL queries. - Excellent c...
...accounting to import customers orders and convert to invoices. We also link / interface to Ideal skills for this project would include: - Proficiency in Opencart system development - Strong UI/UX design capabilities, especially in mobile responsiveness - Experience in developing and implementing referral programs in e-commerce systems - A good understanding of security features to ensure customers' data is protected - Excellent communication skills to understand and deliver on the specific requirements Please note that I'm open to any suggestions or proposals that you may have to enhance this project further. I look forward to seeing how your skills and expertise can bring these ideas to life. I have prepared a document I can send with work we require, as this is...
I have three separate Excel documents that need to be merged into a single, optimized sheet. In this new file, we should only pull specific data columns including Defect ID, Defect Type, Date Opened, Priority, Description, Reproduction Steps, Actual Result, Date Closed, Assigned To, and Comments. These columns must be combined while maintaining clarity and structure. After this task, a dynamic dashboard that displays the current state of the project is required. This dashboard should offer a variety of visualizations. We are particularly interested in bar charts, pie charts, and line charts to present the data in a clear and digestible manner. Ideal candidates for this project are those with: - In-depth expertise in Excel data management - Experience in...
Hi Jay - been a long time since we interacted. But I want to let you know that we still use the excel file that you created for us way back in 2017. Its been our main stay. I have another Excel file which requires formula to effect colour change in cells under various conditions. Knowing you, it might be just a 10 or 15minute assignment. Would you be able to help. Thanks. Vish
I am looking for a skillful freelancer who can assist me in converting an Excel spreadsheet into a daily calendar schedule like this: Key Requirements: - You must have a firm understanding of Excel and calendar scheduling. - You must be capable of adjusting the Excel data to fit into a daily calendar layout. All data will be uploaded by an excel spreadsheet or .csv file
...to Build a backend and a Trading bot Able to Build a Strategy and Work on Bugs. Test out the bot and Ensure it works perfectly. PROJECT DESCRIPTION. We want to Build a Crypto trading bot that Works on CENTRALISED EXCHANGE PLATFORMS including BINANCE, KUCOIN and BITMART. The Bot will support and manage both SPOT TRADING and FUTURES TRADING at once. MAIN BOT FEATURES. - Bot Should support Spot and Futures Trading - Users can Switch from Futures to Spot trading interface on the same UI - Good Trading UI to display Trades and Place trades - API Connectivity to Exchange platforms | BINANCE | KUCOIN | BITMART - BOT MUST SUPPORT More than 500k+ Users ACCEPTABLE DELIVERY FORMAT - Integration of Bot onto Our Wordpress Website backend - A Complete Step-by-step Gui...
...specifically GST and TDS filing for my 11-20 clients. - Responsibilities: - Filing GST returns - Filing TDS returns - Periodic accounting in tally for selected clients - Income tax return filing - Coordinating with clients on monthly basis for the documents The majority of my clients have less than 70 transactions per month and I use tally software, thus a good grasp of tally software and excel is necessary to handle the above tasks. - Skills and Experience: - Gst return filing experience - Proficient in tally software - Experience with handling multiple clients simultaneously - Knowledge of GST and TDS filing systems appeciated. This is an ongoing project and I am looking for a dedicated and reliable partner in this area as this will be an ongoing and lon...
Join our dynamic team as a Real Estate Agent where communication skills meet unwavering motivation and a drive for success! We're seeking experienced individuals with a knack for leadership, a commitment to ethi...redefine excellence in real estate! - Uploading photos and descriptions of properties - Sorting listings by location and price - Providing regular updates on availability - Scheduling site visits for potential customers - Providing customer support to potential buyers For the lead generation aspect, you'll be targeting first-time home buyers, investors, rental property seekers, and end users. To excel in this role, you should have experience in real estate sales and understanding of different audience segments. Excellent communication skills and a proactive app...
I am in need of an Excel professional with an intermediate level of proficiency to assist with various tasks on my project. The specifics of these tasks are open for discussion, therefore a degree of flexibility and adaptability is required. You should ideally have proven experience with data analysis, spreadsheet automation, and formula creation despite the fact these haven't been specified outright. An overview of your past relevant projects included in your bid would be highly appreciated. Convince me with your technical prowess and past success stories.
...affecting the sale of water heaters This project requires hands-on research, which means you'll be conducting in-person visits to retail outlets and other relevant venues. So, local knowledge and a good grasp of the Bahrain's retail landscape are necessary. I need insights, not just data, so your ability to interpret and analyse the information you find is critical. Deliverables: Comprehensive report for each country with all the requested information. Excel sheet or Google Sheets document with detailed data. Duration: The project is expected to be completed within 1 week. Please propose a timeline for this project. How long do you estimate it would take to compete the entire project...
I need a proficient individual to assist with data entry into an Excel sheet. The data to be entered is purely textual, derived from printed documents and requires no complicated formatting. Key Responsibilities: - Transfer text data from printed documents to Excel - Ensure accuracy of data entered - Follow simple formatting guidelines Ideal Skills and Experience: - Proficiency in Microsoft Excel - Attention to detail - Experience with data entry - Fast typing speed - Experience working with printed documents This project is ideal for freelancers with a knack for accuracy and speed in data entry, particularly in Microsoft Excel. It involves simple one-word entries and familiarity with printed documents is advantag...
Necesitaria el código para integrar en mi web de un formulario que los clientes puedan rellenar y me vuelque los datos a un excel de google, o a varios pdfs
I am in need of an expert in Excel data entry. The objective of this project is specifically for data entry purposes. The task involves keying in customer information into Excel. Familiarity with this type of data is a big bonus. Attention to detail, fast typing speed, and meticulousness are skills that are necessary to successfully complete the task. Additionally, extraction of specific information will be required. More specifically, identifying trends within a given period from the input data. Therefore, a keen eye for detail and an analytical mind are crucial for this job. In conclusion, if you have experience handling customer information, know your way around Excel, have a knack for finding patterns among data, and can type...
We have an excel with macro script which converts a PDF (FFE 1a, 2a, 3a) to EXCEL (FFE) that allows us to be able to read all information we need. Unfortunately it is not working due to some changes in PDF (FFE 1b, 2b, 3b) as an extra page in the front has been added, so we are looking to hire someone that can fix this issue, so that excel can ignore this extra page.
...received use this as a trigger to check if a new email is in another outlook 365 folder, if there is, save the attached excel file as a csv and rename the csv file the date of the email in YYYYMMDD format and save to a folder in onedrive for business. On successful completion send an email confirming success. >If there is no new email in the other outlook 365 folder, email our info@ email address notifying that it is not present. Repeat the checking process 2 days later until successful Flow 2: If a new email is received use this as a trigger to check if a new email is in another outlook 365 folder, if there is, unzip the attachment using a password, save the attached excel file as a csv and rename the csv files the date of the email in YYYYMMDD format and save to a f...
I need assistance with entering data into an Excel sheet. Ideal Skills: - Proficiency in Excel - Meticulous attention to detail - Fast, accurate typing skills - Experience with data entry and data organization Please note, the specific data format will be provided.
I need someone to create an external link in my Excel file to a PowerPoint presentation. The data in the Excel file will be updated daily. Requirements: - Creation of an external link from Excel to PowerPoint - Daily updates to the Excel file - No automatic updating of PPT needed. Manual updates are fine Ideal Freelancer: - Proficient with both Excel and PowerPoint - Experienced in creating external links - Comfortable with daily updates - Ability to follow instructions precisely.
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly i...
...that can convert PDF voter lists into Excel in a text format. Here's a breakdown of what I'm looking for: - Conversion Style: I'd like the tool to convert the PDF voter list by combining all columns into a single table. This will make it easier for me to work with the data in Excel. - Error Detection: It's important to me that the tool can automatically detect and correct errors in the text. Nevertheless, I also want to have the ability to manually review and correct the text to ensure its accuracy. - Language: In this case, the tool only needs to handle English language texts. You don't need to worry about incorporating multi-language support. Ideal Skills and Experience: - Proficiency in PDF extraction and conversion tools - Strong kno...
We're in need of an advanced Python programmer well-versed in creating PDF reports from MYSQL and InfluxDB, capable of not only capturing numerical data but transforming it into Graphical Trends and Text-Based Analysis. Key Role: * Develop logics for data interpretation and representation * Create a Professional and Formal UI/UX design for the report generator * Deliver finalized, error-free reports Ideal Experience: * Python expertise * In-depth knowledge of MYSQL and InfluxDB * Proven experience in creating dynamic PDF reports * A keen eye for formal and professional UI/UX design * Strong abilities in abstract reasoning and complex logic writing. Your role will translate our complex database information into understandable, well-structured and profes...
