How to use python in excel vba jobs

I need someone to enter 500 purchase invoices into an Excel spreadsheet. I will provide a template for the format. The invoices will be sent to you as digital files through a cloud service, which you'll use to input the basic details like date, vendor, and amount. Ideal Skills and Experience: - Proficiency in Excel for accurate data entry - Experience in processing financial documents - Attention to detail to ensure data accuracy - Ability to handle sensitive financial information with confidentiality - Familiarity with using cloud services for file management Please let me know your experience with similar projects and how you plan to ensure the quality and efficiency of the data entry proce...

...experienced developer to convert the SPM12 GUI interface, currently built on the MATLAB compiler, into a Python application. The source code for SPM12 is available at SPM12 GitHub repository Objectives: • Translate the entire SPM12 codebase from MATLAB to Python while maintaining functionality. • Develop a Python-based GUI that replicates the current MATLAB interface. • Ensure the converted application integrates well with Python scientific computing stacks. Key Deliverables: • A fully functional Python version of SPM12. • Source code with comments and documentation. • A user guide for the Python-based GUI. Skills Required: • Proficiency in MATLAB and Python programmin...

I need assistance with a data typing project. The job entails: - Entering data from various sources into a spreadsheet - Ensuring accuracy in the data entry - Organizing the data in a single consolidated file While the project doesn't require specific styling or formatting currently, it might at a later point. Therefore, experience with Excel and basic data entry is crucial. Please reach out if you think you're qualified for the task.

...programmer to develop an interactive chemistry experiment for me. You may code using JavaScript, HTML5 or using Python, so experience or proficiency in this language is crucial. Key Requirements: - Users should be able to drag and drop objects using mouse or in case of mobile- fingers. - It should offer a moderate level of interactivity. This includes features such as adjusting quantities and temperatures. If a user pours something in a beaker, it should show the beaker full. If emptied, beaker is empty. - Vector images of lab equipments like Test tube, beaker, burner etc can be found online. Ideal Skills: - Proficiency in Python or JavaScript. You may use CreateJS libraries. If you are a programmer with a passion for ch...

I'm seeking a skilled developer to create a versatile e-signing utility. This tool should allow users to select the DSC ( usb token) inserted to the local machine and can sign PDF, XML, JSON, and Text files in bulk and with the following additional features: - Bulk Signing: It should support signing multiple files at once, with no specific limit. - Predefined Output Path: Users should have the option to assign a default output path for the signed files. - PDF Signature Display: For PDF documents, the utility should display the signature as an optional feature. The goal is to have this utility developed within a month. Ideal skills for this project include: - Proficiency in programming languages suitable for file processing (e.g. ...

I'm looking for a skilled Excel expert to create a project tracking sheet with a calendar section that lists weekly milestones. Key Features: - The main sheet is for tracking project progress. It should include: * Project /Task Name * Start Date * End Date * Progress (percentage) * Priority * Action plan * Comments - The calendar section should list team schedule. * Team working schedule "in office / out of office" * Team calendar "working remotely, annual leave, business trip, public holiday, overtime" Excel Automation: - I need the Excel sheet to have automated functions: * Conditional formatting for visual tracking: Changes in cell color or font based on the progress percentage, to ...

I am seeking an experienced Python web application developer to construct a user-friendly platform for cryptocurrency airdrop and telegram integration. The final product should be similar to notcoin. Key requirements: - User registration and verification. - Airdrop distribution capabilities. - Integration with Telegram. Professional skills and experience: -Familiarity with Python. -Past work demonstrating ability to create robust web applications. -Understanding of cryptocurrency airdrop processes. Applicants should include their relevant experience in their applications. Working examples of similar projects will be highly appreciated.

I need a tool that extracts specific content (text and images) from PDF files and adds this data into a CSV file under designated headers. Key R...adds this data into a CSV file under designated headers. Key Requirements: - The tool should be designed specifically for Windows OS. PDF Data Extraction: - Need the tool to extract both text and images from the PDFs. CSV Insertion: - The extracted data should be sorted correctly under their respective column headers in a CSV file. Consistent PDF Structure: - It is important that the tool can handle data extraction from PDFs with a consistent structure. Ideal Skills and Experience: - Proficiency in developing Windows-based tools. - Experience with PDF data extraction. - Familiarity with CSV file manipulation in...

I am seeking an AI developer with significant expertise in reinforcement learning. Key Responsibilities: * Apply reinforcement learning techniques to solve complex problems. Required Skills and Experience: * Proficiency in Python. * Expert-level knowledge and hands-on experience in reinforcement learning. Only apply if you possess an excellent understanding of reinforcement learning algorithms, and Python programming. This project is demanding and requires a high level of competency, therefore, only experts in the field are sought. Your expertise will be crucial in optimizing our current models and laying down the roads for future developments.

...looking for a skilled software developer to create a Windows-compatible software application. This software should be specifically tailored to help my sales team improve their performance and to calculate their incentives. Key Requirements: - Compatibility: The software should be compatible with Windows. - Integration: There's no need for the software to be integrated with any existing systems, so you can focus solely on creating the best software for our sales team. - Data Input: The software should have the capability to import data from Excel/CSV files. This method will facilitate the input of sales data and make the software more user-friendly for our team. Ideal Skills and Experience: - Proficient in Windows software developme...

Looking for help in modifying an existing python script and related sql database table The current script - (1) scrapes company financial data from website and populates database (2) scrapes news related to keywords from google news (3)sentiment classification of news items (4)pushes data to sql database The company names and keywords are currently hardcoded in the script Requirement- (1) Company names/urls/keywords (will be provided) to be put in master table in the database (2) The script to loop through and scrape the relevant data and put in database

I ll upload various images under specific keywords. I want members to receive 1 image after texting that keyword in their personal channel. Also i want that image to be deleted in storage so that it will not be forwarded to other member. I also want a channel for my accountant, where he ll be uploading bill in pdf. And i ll get all data in excel sheet.

...freelancer who's great at web scraping to help with a project involving a specific website initially, with potential for more. I'll give you the specific data fields to extract. It'd be great if you: Are really good at web scraping and or Python. Know your way around MS SQL Server databases, not essential but definately an advantage. Understand how to extract data effectively. Understand the need for security and captcha integration if needed. Can work quickly since this project is a priority and needs to be done ASAP. Ultimately, I want to be able to manage the code with your ongoing help, so this could lead to a long-term partnership. I'll share the full details when needed. You will provide source cod...

I'm looking for a professional who can plot GPS coordinates from an Excel spreadsheet onto a map. This map should be easy to interpret, displaying the route taken by a vehicle. Key requirements: - The data provided is in Excel format. - The final map should be a static image file. The main task of this project is to: - Visualize the route taken by a vehicle based on GPS coordinates. - Timestamps are crucial and should be displayed in a clear, understandable manner. - Since I want to see the exact route taken, the map should display addresses corresponding to the GPS coordinates. Although the main focus of the project is plotting the coordinates and timestamps, other features such as: - Distance between points. - Speed of the ...

I am looking for an AI trainer proficient in Python or java to assist me with my AI project. Key Requirements: - Proficiency in Python: You should be adept in using Python for AI projects. - Machine Learning and Deep Learning Skills: Ideally you will have a solid foundation in machine learning and deep learning concepts and their practical applications. - Communication Skills: A good trainer should be able to explain complex ideas in simple terms. I will require online and offline assistance, so you should be comfortable with both modes of training. The ideal candidate should be able to provide regular updates and feedback on my progress. I am eager to get started and would appreciate if you could comm...

I'm looking for a skilled freelancer to create a mantra chart in Excel. This will be a presentation-worthy document, so I'm keen on ensuring that it's well-structured and visually appealing. Key Requirements: - Incorporating text, numbers, and dates into the chart - The chart should feature less than 10 mantras - Ensuring the final output is suitable for professional presentation The task will require someone with excellent Excel skills and an eye for design. A good understanding of data representation would be a big plus. You can expect detailed instructions and guidance from me throughout the project. Feel free to ask any clarifications you might need.

I'm looking for someone who can do automated selenium test (using python) for a wordpress plugin. You need to write the test cases and automate it.

I'm seeking a skilled Python developer with experience in algorithmic trading to create a bespoke algorithm specifically for the optimization of trading strategies in the crude oil market. Key Requirements: - The algorithm should be written in Python. - It should primarily focus on crude oil trading. - The primary objective of this project is to optimize trading strategies, not price forecasting or risk management. Ideal Skills and Experience: - Proficiency in Python for algorithmic development. - Previous experience in creating and optimizing trading algorithms. - Specific experience in crude oil trading is highly preferred. - A solid understanding of trading strategy optimization. The successful freelanc...

I am looking to create a Windows exe trading application that will leverage an API for automated trading strategies. Key Features: - Order Placement and Management: The primary function of the app is to place and manage trades based on predefined criteria. It should be able to execute trades automatically without the need for manual intervention. Ideal Candidate: I am seeking a developer with a background in finance and algorithmic trading who can bring the following skills and experience to the project: - Proficiency in Windows application development using Python or similar languages. - Experience with trading APIs, particularly in the context of order execution and management. - A solid understanding of trading strategies and t...

I'm currently working on an Excel sheet for performance analysis and I need assistance with writing the SUMIF formula. Key Requirements: - Assist with writing the SUMIF formula for my Excel sheet (vlookup, countif, and other formulas are not needed for this project) - Ensure the formula fits within the context of performance analysis Ideal Freelancer: - Experienced in Excel and in particular, writing SUMIF functions - Knowledge of performance analysis or related fields is a plus

It is necessary finish a web application in python + django regard the statistic of stocks. So it is necessary: some fetaures of some filter; -. make some change to mysql database and api to datafeed. -. verify the formulas and add some features; -. make better the design. - create an admin page with security login and import stocks manually. Please answer only if you can show similar experiences

I am looking for an expert in Python programming to assist me in the creation of a multi-timeframe indicator merge. The project entails the merger of the 4hr, 1hr, 15min, and 5 min timeframes while including specific indicators, namely Moving Average, Relative Strength Index (RSI), ADX, and Webslingers. To make informed bids, it's important to note the following: Ideal Skills & Experience: - Extensive knowledge in Python programming - Proven experience in financial analytics - Expertise in working with listed indicators Project Requirements: - Code the multiple timeframes using Python - Integrate the Moving Average, RSI, ADX, and Webslingers indicators - Generate the deliverable output as a CSV file P...

I'm in need of an AI-based image editing solution that can replace skies and chromakey functions for our web-based applications. Key Features: - The primary goal of this AI image editing solution is to automatically perform color correction, chromakey, and sky replacement on images. - The tool should be able to process a large number of images with speed and accuracy, enhancing the visual appeal of our content. Compatibility: - The solution needs to be compatible with web platforms, ensuring seamless integration and operation within our existing systems. Ideal Skills and Experience: - Strong proficiency in Python programming, particularly in the development of AI solutions. - Previous experience in image processing and editin...

I am seeking a freelancer with a strong background in Microsoft Excel's intermediate computations, especially proficient in VLOOKUP and IF statements. My project involves: - Identifying and correcting errors within my existing formulas. - Optimizing the efficiency of VLOOKUP and IF statements. The ideal candidate should have extensive experience dealing with and rectifying Excel formula errors. The ability to optimize efficiency of calculations to streamline our data processing is paramount. Providing examples of similar projects tackled in the past would be beneficial. I am looking forward to working with a precise and detail-oriented professional who can help me resolve these issues promptly.

...Gaming Keyboard Emulator Developer Project Overview: We are seeking a skilled developer to create a Windows-based keyboard emulator, specifically designed for gaming. The emulator must operate at a low system level to effectively mimic keyboard inputs for gaming purposes without requiring hardware. Key Requirements: OS Compatibility: The emulator should work exclusively on Windows systems. Emulation Focus: Aimed at simulating keyboard inputs for gaming applications. Ideal Skills and Experience: Proficient in Windows application development. Expert in low-level programming, specifically in system-level assembly language. Knowledgeable in gaming input emulation and keyboard input simulation. Experience in backend applications is benefici...

I'm seeking an expert in Excel who can help me with a few diverse tasks, such as data entry, creating formulas and functions, and conducting data analysis. The dataset I'll be working with is medium-sized, ranging from 100 to 1000 rows. The primary goal of this project is to organize and structure the data. Ideal skills for this project include: - Proficiency in Excel, including using formulas, functions, and pivot tables. - Excellent attention to detail for accurate data entry. - Experience with data analysis and the ability to draw meaningful insights from the data. - Strong organizational skills to structure the data effectively. Ultimately, I'm looking for someone who can help me streamline my data manageme...

...for a skilled Excel professional to help me create a custom inventory dashboard. Key Requirements: - The dashboard should focus on inventory management, specifically, visualizing product stock levels. - The data should be arranged in an intuitive manner that allows for quick and easy inventory tracking. Ideal Skills & Experience: - Strong proficiency in Excel, particularly in creating visually appealing and user-friendly dashboards. - Experience in inventory management, with an understanding of product stock levels and their relevance. - Attention to detail as accuracy in data representation is crucial for this project. - Good communication skills and a proactive attitude to ensure the project's success. ...

I'm looking for an experienced Python coder to tackle two key aspects of my project - data analysis and automation. Here's a breakdown of the requirements: - **Data Analysis**: The primary task involves analyzing datasets in CSV format. The selected candidate should be adept with NumPy, able to make sense of the data and derive meaningful insights. - **Automation**: The second crucial aspect is automation. I'm looking to automate certain processes in my project that involve database queries. Proficiency in Django will be necessary here. Ideal candidates for this project would have: - **Strong Python Skills**: You should be well-versed with working on data analysis and automation tasks using Python. - **Experi...

I'm looking for a highly skilled QT senior development engineer to help build a desktop application. This project will tap into your expertise in various areas such as C++ programming, the QT framework, and user interface design. Key Skills & Experience: - Strong proficiency in C++ - Extensive experience with the QT framework - Excellent User Interface (UI) design skills - Knowledge in Python and 3D will be a plus The main function: 1: Windows platform, jointly developed by QT+python. 2: Communicate with hardware devices through serial port/Ethernet. 3: Support MODBUS-485, TCP, UDP and other communication protocols, with 1ms cycle response. 4: Support hardware parameter configuration, multi-channel data analysis, storage, data playback...

I'm in need of a proficient Excel expert who has a solid understanding of Excel macros and compatibility issues with Excel for Mac 2018 or later. The project involves assessing and modifying an existing Excel macro to ensure that it functions seamlessly on Mac platforms. Key tasks include: - Assessing the existing Excel macro and its functionality - Modifying the macro to be fully compatible with Excel for Mac 2018 or later - Implementing the desired modifications related to data transfer, header and footer creation, as well as digital stamp inclusion The ideal freelancer for this project should have: - Proficiency in Excel macro development and modification - Prior experience with Excel for M...

I'm in need of an Excel expert who is well-versed in Excel and has experience in creating detailed and visually appealing dashboards for project management purposes. The primary goal of this dashboard is to help me track the effort and progress of my project. The information that I'd like to track includes: - Time spent on tasks - Percentage of completion - Deliverable status The excel is small and has only 15 rows its more like visualization task so that all data can be projected in one place as a dashboard.

I am in need of a skilled Full Stack Python Developer to primarily focus on back-end development tasks. The main areas of focus include: - User Authentication & Authorization: Implement a secure user authentication system to ensure data integrity and user privacy. - API Development & Integration: Develop new APIs and integrate with existing ones, for seamless communication between various components of the platform. - Data Processing & Analytics: Implement robust data processing and analytics functionalities to make informed decisions and gain insights from user interactions and other data sources. You will also be responsible for: - Payment Gateway Integration: Integrate payment gateways to facilitate transactions within the platform...

...skilled Excel professional to clean a text-based dataset for me. The dataset is not massive, but it's quite messy. The data cleaning task is relatively straightforward and basic. You'll have to perform operations such as removing duplicates and adjusting formats. Ideal Skills and Experience: - Proficiency in Excel: You should be comfortable working with large datasets in Excel, including applying formulas and functions. - Data Cleaning Expertise: Prior experience in cleaning text data is a major plus. - Attention to Detail: The devil is in the details; I need someone who won't overlook small nuances in the data set. Once the data is cleaned, I'll need you to carry out some basic ...

I'm seeking a skilled personal assistant to help with my data tasks, focusing on Excel entry and processing. Key Tasks: - Excel Data Entry: You'll be responsible for entering more than 500 data points. - Data Processing: You will also assist in processing these data entries. Your Skills: - Proficient in Excel: You should be able to work with pivot tables and VLOOKUP functions. - Data Entry Expertise: Demonstrable experience in managing large data quantities is a must. - Organized & Detail-Oriented: The ability to maintain accuracy and precision while handling this large volume of data is crucial. This is a great opportunity for someone who's eager to showcase their Excel skills in a p...

...skilled developer proficient in Python to build an advanced trading bot. The bot should be compatible with TradingView and capable of the following: - Generating buy and sell signals based on specified trading strategies - Implementing stop loss and take profit orders for risk management - Adapting to customizable trading strategies - Actually executing trades and proving profitable over time The ideal candidate should have: - Profound understanding of trading principles and market dynamics - Solid experience in developing trading bots and implementing complex trading strategies - Proficiency in Python and experience in integrating with TradingView - A track record of building successful, profitable trading bots This project is...

Develop macro-enabled Excel file to handle CSV

I'm in need of a professional who can convert a PDF document to Excel format. The PDF contains a mix of text, tables, and images, which must be meticulously replicated in the Excel format. Key requirements: - Handle mixed content: The PDF has a mix of text, tables, and images. You should be able to accurately translate this diverse content into Excel. - Replicate PDF layout: The layout of the PDF needs to be maintained in the Excel format. This means tables should look the same, images should be placed correctly, and the text should be in the same positions. Ideal skills and experience: - Proficient in PDF to Excel conversions: You should have experience in converting PDF docume...

...seeking a skilled Python developer who can help me with a critical task: Translating PDFs. The challenge here is to make sure that the translated content in the PDFs maintains the exact same format and layout as the original documents, without any alterations. Key Requirements: - Translate both scanned and text-based PDFs/images: I need a professional who can handle both types of documents with equal proficiency. - Language Proficiency: The translation will be from English to a variety of languages. Your ability to work with any language from a dropdown menu is crucial. - High Accuracy: The translated content must retain the original meaning and context with 95+% accuracy. Ideal Skills and Experience: - Proficient in Python: You shou...

...Requirements: - Need an expert in Python programming - Familiarity with Pandas and Beautiful Soup - Experience in data analysis The job mainly involves reviewing the existing code, fixing any issues that may hinder the data extraction, and ensuring that the extracted table is ready for analysis. Please note that no additional data preprocessing is required. (feel free to rewrite code if you have better idea) --- name "iXBRL" , inside folder contain multiple html file(hundreds to thousands), each html file contain multiple tables(vary from 15-35, depend on each html file). Python to extract specific table and vertically stack them together to create an Excel file.(first column add html filename.) inside html fi...

I'm looking to develop a Software as a Service (SaaS) website specifically for the legal industry. Here's what I need: - User Registration and Login system. - Payment Processing integration. - An AI Chatbot with capabilities for information retrieval and analysis. - An OCR (Optical Character Recognition) system. - Both Frontend and Backend development are necessary. - Seamless integration of the AI chatbot, OCR, and payment processing into the website. - A well-documented API to allow for future expansion. The ideal candidate for this project should be proficient in Python (Django/Flask), laravel, node js, vue js, AI programming, and API development. Experience with building SaaS platforms, payment processing integration, and chatbot development wou...

I have a project that requires purely text data entry. I have a set of handwritten notes which need to be entered into a spreadsheet. Key Requirements: - The data is text-based, and it's crucial that the freelancer can transcribe this accurately and efficiently. - Proficiency in using spreadsheet software like Excel or Google Sheets is a must. Ideal Skills: - Fast and accurate typing skills - Proficient in using spreadsheet software - Experience with data entry, especially from handwritten sources

I am seeking an experienced Python developer with a proven track record in working with the Scrapy framework. The primary goal of the project is to handle data extraction from websites, dealing particularly with nested or hierarchical data. Key Responsibilities: - Collaborating with the team to define the scope of the project and identify the data requirements. - Design and implement data extraction scripts using the Scrapy framework. - Handle complex, nested or hierarchical data structures. - Ensure the accuracy and efficiency of the data extraction process. Ideal Skills and Experience: - Proven experience in Python development. - Expertise in working with the Scrapy framework. - Strong understanding of web technologies and data structure...

In need of a skilled professional to develop a RESTful API using Python. The API should be designed to handle multimedia data. Ideal Expertise: - Proficient in Python programming. - Thorough experience in RESTful API development. - Should specifically be adept in dealing with multimedia data handling. - Great problem-solving skills. - Conduct testing ensuring optimization and compatibility. Transparency, communication, and attention to detail will be crucial for this role. A fast turnaround will be appreciated without compromising on quality. If you have what it takes to handle this job, I welcome you to make your bid.

I'm looking for a skilled TouchDesigner and Python developer to create a script for automatically sending MOV videos as email attachments. Key Requirements: - Design and develop a Python script for TouchDesigner that can attach MOV videos to outgoing emails. - Ensure the script is robust, reliable and can handle various video sizes. - Email content doesn't need to be customized for each recipient, so a standard email template is sufficient. - Mail input from user side Your role will involve: - Understanding the project's requirements and the specific constraints of sending MOV videos via email. - Creating the necessary Python script within the TouchDesigner environment. - Testing and refining the script to ensure it performs...

I am in need of a Python expert, specializing in web scraping. I require someone who can proficiently extract data from various websites. The specifics of the data may vary from text content, images, links, to contact information. Your key responsibilities will include: - Writing effective and efficient Python scripts to scrape data - Ensuring the data is extracted accurately and in a structured format - Delivering the data in a timely manner The ideal candidate should have: - Proficient experience in Python and web scraping - A strong understanding of data extraction techniques - Proven experience in handling and parsing a variety of data types - Excellent communication skills and the ability to meet ...

I'm urgently in need of a software developer who can help me fix some bugs in my software and make some necessary adjustments to the code. Key Requirements: - Debugging: You should be experienced in identifying and resolving bugs in software. - Code Customization: The project may require some customization of the code to ensure it meets my requirements. Your experience with software development, particularly with Java, Python or C++, will be highly regarded. The project is quite urgent, so I'm looking for someone who can start immediately and deliver fast, but without compromising the quality of the work.

I need an Excel tool that can sort data by category and provide users with an interactive experience. I'm looking for an experienced Excel developer who can create a user-friendly, yet advanced, Excel tool. The tool should have the following features: - **Filtering**: The tool should allow users to filter data by category. This is a crucial aspect of the tool's functionality, as the data will be organized by this field. - **Interactive Buttons**: I would like the tool to have buttons that allow users to sort data. When a button is clicked, the data should rearrange itself based on the selected category. For example, when a user clicks on the button related to 'Category A', all data entries related to 'Categ...

I am looking for a Python developer who can implement concepts from a research paper. - The developer must have solid experience in Python, ideally with an intermediate understanding of complex programming concepts. They should be comfortable with an intermediate level of complexity in translating research concepts into code. - Knowledge and experience with the PyTorch framework is a must. The freelancer will need to use it to implement the code from the research paper. This project will require a good understanding of data structures, algorithms, and object-oriented programming in Python. Experience with prior work involving code implementation from research papers would be advantageous. Please only bid if you meet these...

From 2.5 lakh records, need to find the duplicate data and make different sheets with unique data. Example: In a sheet of alphabets, that have multiple A’s, B’s, C’s. Now I need separate them and make a sheet with all A’s, separate sheet with all B’s, another sheet with all C’s.

...for installing python, setting SQL for our applications and Google Sheet. For each country may need API for such as : 1. Historical Data 2. Financial Scrapped Source 3. Financial Summary Scrapped Source 4. Interest rate 5. Some More Required Skill & Experience : 1. Php & SQL 2. Familiar with python installing & setting up environments 3. Experienced in Linux Debian & LNMP server by SSH 4. You need to know on how to run python scripts on debian by ssh, and setup cron task on debian, and debugging etc Personality's Criteria : 1. No toxic working environment 2. Agile, Responsive, and Fast Delivery 3. Collaborative as a team 4. Responsible, Credible, Reliable and Integrity person 5. No agency, only direct hiring -----...