Excel macro extract data filter jobs
I am looking for a freelancer who can assist me with entering numbers from an Excel spreadsheet into a PDF document. This task involves not just data entry but also applying advanced calculations to the numbers within the PDF. Key Requirements: - Proficient in Excel and PDF software - Capable of performing advanced calculations - Attention to detail for accurate data entry Ideal Skills: - Excellent numerical skills - Experience with PDF data entry - Familiarity with using advanced Excel formulas
I need to convert tables from a MS Word file into a MS Excel file. The project involves: - Transferring all tables from the Word file into one Excel sheet - Performing basic cleanup to remove empty rows and columns Ideal candidate should be proficient in MS Excel, have a keen eye for detail and able to perform basic data cleanup tasks. Experience with data entry and Excel is highly preferred.
...with strong skills in WordPress - Strong understanding of e-commerce best practices - Ability to create engaging website content - Familiarity with PayPal integration for e-commerce sites Please note, the site must be fully prepared and content ready for launch. Extra info: It's just 18 products. Need to remove background from images and there is excel file with detail on that product. Rest of content you need AI assistance to generate data that is relevant. This job will suit someone who is to take ownership and launch site like their own and intend to continue to work on it in regular engagement after launch rather than a one of task. In your application, please send me link of 1-2 WooCommerce sites you have done in women's fashion or luxury items. Please ...
I need someone experienced with WordPress and product uploads to help me upload two Excel sheets of products to my site. - One sheet contains over 3,000 products with compressed images. - The other has about 40,000 products without compressed images. I would like to know if I can upload the compressed images later in bulk after the 40,000 products are uploaded. Please let me know if this is within your capabilities. Ideal candidates for this project should have: - Proven experience in WordPress product uploads - Ability to handle large data sets - Understanding of bulk image uploads - Excellent attention to detail to ensure every product is listed correctly. I have attached the file. Please import the products on your website to show me and apply for the job.
I'm seeking assistance with comprehensive data analysis in Excel, as well as generating reports and creating formulas. The job also involves sending multiple email attachments via Gmail. Ideal skills and experience for the job: - Expert level proficiency in Excel, particularly in data analysis, formula creation, and report generation. - Experience in managing and sending multiple email attachments through Gmail. - Strong attention to detail and ability to work efficiently.
I need a skilled data entry operator to help extract data from text documents. Key Responsibilities: - Extracting data from various text documents sourced from web pages. Ideal Skills: - Proficient in data extraction techniques. - Experienced in working with text documents. - Familiar with navigating and extracting data from web pages. Please note, experience with web data extraction is highly preferred.
...create a software capable of scraping user data from APIs. Before I officially list this project, I would like to receive estimates from potential candidates. The key elements of the project are: - Development of scraping software specifically designed to extract user data from various APIs. - Providing an estimate for the cost and time required for such a project. - All responses will be considered for a launch date that is to be announced. Ideal freelancers for this project should have: - Proven experience in developing scraping software. - Strong understanding and experience working with APIs. - Ability to provide accurate project estimates. The format for the scraped data is currently undecided, so flexibility and ability to adapt to different data...
I'm seeking a skilled data entry professional to assist with cleaning and formatting my Excel spreadsheets. The primary task will be identifying and removing duplicates from the data sets. Ideal Skills: - Proficiency in Excel - Attention to detail - Experience in data cleaning and formatting Please bid only if you can deliver quality work promptly. Thank you!
i need a website scraped in the craft area the headings are Name Description sku price image url Diamensions Weright isbn format page url pages Autoir in excel format url script built
I need a skilled programmer experienced in Python or Node.js, who can create a script for me that will parse Google SERP data through our rotating proxy provider. The script needs to extract data points such as Titles and URLs, Meta descriptions, and Search result rankings. Key Requirements: - The script should run daily as an API enpoint which will get settings for scraping (google domain, language code, country code, proxy settings, keywords) - The output data needs to be in JSON format Since Google has recently updated its system to block bots/scrapers, the script needs to effectively navigate through this challenge. Experience with web scraping, working with proxies and understanding of Google SERP is a plus. Please apply if you have the relevant skills a...
I need a specific excel sheet made up for me. Instructions for excel sheet: First, there should be cell A designated for company name. Cell B will be "customer cost" where the "single letter" value will be entered (see values/definitions below). Cell C will be "number of licenses" and will be a numerical value input by the user. Cell D will be the product of cell B multiplied by cell C. cell B multiplied by cell C equals cell D (p) * 10 = 100 (p) = 10 (see values/definitions below) cell A = MOCK company A cell B = (p) cell C = 10 (numerical value input by user) cell D = 100 Then, cell E will be "MSP cost" and will be the "double letter" value entered. Cell F will be the product of cell C multiplied by cell E. cell E mul...
Hi. It’s supposed to generate teams based on data from several sheets, but it’s not working as I need. Additionally, I would like to have a button to update the data for each game week. I’m attaching the code so you can review it and help me out if possible. Thanks in advance!
I'm in need of an Excel expert to assist me with a data transfer task. This involves pulling information from one spreadsheet and adding it to a column in another. Key Tasks: - Transfer of text data from one spreadsheet to another - Matching of data based on an exact match in a single column - Formatting of some data during the transfer The data in the spreadsheets is a mix of both specific categories and plain text columns, and there are more than 1000 rows that need to be transferred. Ideal Skills and Experience: - Proficient in Excel - Attention to detail to ensure accurate data transfer - Experience in data handling tasks - Ability to perform basic data formatting and transformation
I'm looking for a freelancer who can compile a comprehensive list of stock codes for all companies per year from the specified website - a tab for each year. The stock codes should be obtained from Yahoo finance. For example, where the company name is Apple, I would expect the code AAPL to be returned. The specific requirements are: - The stock codes should be taken from Yahoo Finance - The data should only include the stock codes, not historical data or current status. - The final deliverable should be in an Excel file. Ideal skills and experience for the job: - Familiarity with stock exchanges and their coding systems. - Proficiency in data compilation and Excel. - Attention to detail for ensuring accuracy of stock codes.
I'm seeking assistance to extract data from a conference website. The task involves gathering information on all attendees and their respective companies. Key Requirements: - Extract a list of attendees and their information (Name, Title, and Company) and export it into a CSV file. - Create a secondary CSV file that lists all the companies in attendance (one column: Company). The data needs to be extracted from a publicly accessible section of the conference website. The task needs to be completed before noon EST on January 21st. I will make a decision on whom to select by 9:00pm EST on January 19th. Ideal Candidate: - Previous experience with data extraction and web scraping is preferred. - Proficient in using tools like Python, Excel, o...
I'm seeking a some...residential pipework system. Only the pipes needs to be sketched and the pipe sizes visible. no need for building / rooms to be visible. i can provide 3d model of project if needed. In the plans is all length and orientation provided. I just need a 3d (isometric sketch), so that workers can see it more easily, which pipesize to install. The calculations for pipe size already exists. You need to extract from plan the pipesizes. I cant provide further informations. Make sure you can read the Specific Deliverables: - Isometric view of the pipework - CAD model for the pipework system Ideal Skills: - Proficiency in CAD software - Experience with isometric view design - Understanding of residential plumbing systems - Familiarity with PEX material properties
Warehouse Software Requirements: Core Functionalities: • Shipment Management: o Register incoming shipments with details. o Maintain a calendar for:  Incoming shipments: ..."Good," "Damaged," "Frozen." • Additional Notes: o Free-text section for specific instructions, observations, or remarks. • Signatures: o Approval signature (e.g., manager or inspector). o Recipient acknowledgment of goods received. • Report Export: o Option to print or email the report as a PDF. Enhanced Features: • Audit Log: o Log all transactions and updates for accountability. • Search and Filter: o Advanced search for shipments, containers, or company records. • Real-time Dashboard: o Display:  Current inventory overview.  Incoming and outg...
I have an Excel database consisting of 100,000 records of loan requests along with their acceptance status. I need a freelancer with strong expertise in Python, data manipulation and AI to develop an AI model that will evaluate new loan requests and predict their approval status based on the training from this dataset. Key aspects of the project: - Data Preprocessing: The data will require normalization, handling of missing values, and feature extraction. - Model Development: Using Python, you'll build an AI model to train on the database. - Prediction: The model will assess new loan requests and indicate if they should be accepted or rejected. The ideal candidate will have extensive experience with AI model development, and will be proficient in Python...
I'm looking for an expert in Excel to help me create a special spreadsheet that will collect and organize vital customer information. This project will involve detailed manual data entry. Key Requirements: - Collecting customer contact details (name, phone, email) and purchase history. - Organizing this data in an efficient and easy to understand manner in Excel. Ideal Skills: - Proficiency in Microsoft Excel. - Excellent attention to detail for data accuracy. - Experience with data entry and data organization. - Good understanding of customer data and purchase history. Please note, the data will need to be entered manually, so patience and diligence are essential for this task.
i need menus extracted from a webpage the most important columns (data points) will be category name product name, product price, product description. call required before offering job to go over important details of the job NO EXCUSES POOR QUALITY WORK WILL NOT BE PAID ANY CRYING OR ABUSE WILL NOT BE TOLERATED ALL I AM AFTER IS FAST HIGH QUALITY WORK FROM A PROFESSIONAL. IF U CANT DO IT DONT APPLY. REMEMBER IM HIRING YOU COS I DONT HAVE THE TIME TO DO IT MYSELF. I CAN DO THESE IN MAX 3 HOURS PER SHEET. 1 SHEET ON AVERAGE SHOULD TAKE 3 HOURS. LATE WORK WILL BE PAID AT A REDUCED RATE AND ALSO ANY MISTAKES MUST BE ELEMENTARY. WORK MUST BE ALMOST PERFECT ON FIRST DRAFT AND PERFECT ON SECOND DRAFT OR PAY WILL BE REDUCED. DO NOT DEMAND PAY FOR WORK FULL OF ERRORS IF I SAY THE WORK IS...
I need a simple BAQ coded in Epicor to report on total unreceived quantities. The report should include the following specific details: - Part number - Number of POs - Total unreceived qty - Site location In addition, the report should be able to filter by: - Date range - Supplier - Warehouse location Ideal Skills and Experience: - Proficient in coding BAQ in Epicor - Experienced in data extraction and report generation - Able to implement custom filters in reports
Please Sign Up or Login to see details.
...report centered on the application of nanotechnology within material science. The report should delve into: - Nanofabrication techniques: Explore the methods and processes involved in the fabrication of nanomaterials and their implications for material science. - Mechanical properties of nanomaterials: Analyze the unique mechanical characteristics of nanomaterials and how they differ from their macro counterparts. - Types of optical nano biosensors: Identify and characterize various optical nano biosensors, discussing their design, function, and relevance to material science. Given the complexity of these topics, the report should provide an in-depth analysis rather than a high-level overview or intermediate depth discussion. Ideal Skills and Experience: - Extensive knowledge...
I'm looking to build a comprehensive e-commerce site, ideally using a React.js Backend with a Tailwind front end, or PHP/Laravel. The site needs to have several key features including: - Shopping functionality - UPI payment integration - WhatsApp API integration - Ability to upload products via CSV/Excel sheets - User recommendation form connected through WhatsApp API for scheduling meetings I would prefer MySQL as the database for this project. The admin panel should specifically allow me to manage product inventory. User accounts will use standard email/password, social login authentication. New freelancers are welcome to bid, but you need to demonstrate your skills or provide a detailed plan on how you intend to execute this project. Please share any relevant projects yo...
I'm in need of a compre...information for Real Estate Professionals (Agents and Brokers) associated with @properties, covering all cities they operate in. The data should be structured in an Excel spreadsheet and must include: - Name - Address - City - Email (Any email addresses available) - Phone number - Company name Key Requirements: - I'm looking for as many contacts as possible, ideally in the thousands. - The email addresses do not need to be verified, but any available email is acceptable. - Prior to engaging in further conversation, I would like to see at least 10 examples of the data you've gathered. Please note that this task may be straightforward for those experienced in data scraping. A successful completion of this project could l...
Looking for an Enthusiastic Non-Indian Female Partner for YouTube Reaction Channel (Indians Can Apply Too!) We are excited to invite an enthusiastic and passionate individual to join our 27K+ subscriber YouTube channel as a partner for creating reaction videos. This is a long-term, revenue-sharin...audience. Key Details: --The content will be created in English. --The partnership is designed for long-term collaboration, where you’ll play a vital role in shaping the channel's future. If you’re interested in becoming a part of this exciting journey, please reach out to us! In your proposal, include the keyword "Grow Together" to show that you’ve read this description thoroughly. This helps us filter out fake or bot applications. Let’s create ...
I'm looking for a professional to create an Excel workbook that tracks inventory, allocated inventory and available to sell. I would like one page to be a dashboard with highlights and the other tab to be the details. Key Metrics: - Current stock levels for multiple products - Low Stock reorder alert - Inventory valuation - Allocated and available to sell Ideal Skills: - Advanced Excel skills - Experience in creating dashboards - Understanding of project tracking and inventory management This dashboard will assist me in managing my project's resources efficiently. Please only apply if you have the required skills and experience.
I'm looking for a skilled developer to extract the API from my Mobcash application and connect it to a customer service bot. Key Responsibilities: - Extract and connect the Mobcash API to a customer service bot. - Implement functionalities enabling the bot to provide account information, specifically transaction history and account status. Ideal Skills: - Strong experience in API integration. - Proficient in bot development for customer service. - Prior experience with financial transaction applications is a plus. The primary function of the bot will be to provide customer service. It should be able to supply users with specific account information including their transaction history and account status. This project will require a detail-oriented professional who can...
I'm looking for a proficient web developer to create a user-friendly, web-based portal for project collaboration, which will replace my current cumbersome Excel sheet system. The primary goal is to streamline the process, enhance collaboration and make the project management more efficient. Key Requirements: - The portal should replicate the collaboration and comments features from my Excel sheets. This involves creating a space for team members and clients to leave feedback, ask questions and contribute to the project. - Incorporate task assignment and tracking capabilities. I want to be able to delegate tasks and monitor their progress within the portal. - Implement an admin and user role access control system. As the project owner, I need to have full control over th...
...the “SimPlan” calendar to manage events, but I need help organizing and processing the data to generate actionable insights. Here’s what I’m looking to achieve: Analyze event workload based on type (automated study sessions, independent skills training, and non-study events) for specific time periods. Calculate instructor and venue utilization, including peak hours and percentage of usage. Understand student participation across different events and semesters. Compare growth in event frequency and duration between Fall 2023 and Fall 2024. Identify trends like most/least attended skill groups and time spent on events with keywords (e.g., “excursion,” “first aid”). If you have expertise in data analysis, Excel, or tool...
I'm in need of a professional who can assist with reformatting my bank transaction CSV file for QuickBooks import. Key Requirements: - Reorder columns of the CSV file to meet QuickBooks' requirements. - Ensure the final CSV includes Date, Description, and Amount columns. - Amounts must be appropriate...transaction CSV file for QuickBooks import. Key Requirements: - Reorder columns of the CSV file to meet QuickBooks' requirements. - Ensure the final CSV includes Date, Description, and Amount columns. - Amounts must be appropriately sorted into separate columns for positive and negative amounts. Ideal Skills: - Proficiency in Excel is a must. - Previous experience with QuickBooks and CSV file formatting is highly preferred. - Attention to detail to ensure all d...
Project Overview I want an Android app for showcasing multiple business vendors in the Kashmir region who sell dry fruits. Buyers will be ab...Product Catalog Display of vendor-specific products with descriptions, prices, and images. 3. Sample Order System Option for buyers to request product samples directly from specific vendors. 4. Secure Payment Gateway Integration of payment methods like UPI, credit/debit cards, or net banking. 5. Chat Support Buyer-to-vendor chat for inquiries. 6. Search and Filter Buyers can search vendors by name or filter products by price, category, etc. 7. Notifications Push notifications for order updates, new vendors, or offers. 8. Admin Panel (for you): Manage vendor profiles, upload catalogs, monitor transactions, and ...
I'm in need of a professional who specializes in Excel VBA and Outlook email automation. I have made some experimental progress but I am currently stuck and would appreciate assistance in troubleshooting my existing code and learning basic coding concepts. The specific tasks required include: - Automating email generation from specified Excel worksheet cells on a schedule based on corresponding dates in other cells. - Incorporating specific types of content into the body of these emails, including text and hyperlinks. - Assisting me in understanding and learning basic coding concepts. Ideally, you would have extensive experience with Excel VBA and Outlook, and be able to explain concepts in a clear and understandable manner. Your role will not only be to help me...
...information about the project: Please help me compose detailed site plans and section drawings for the above ground pool I would like to install. The pool is Intex 32'x16'x52 Rectangular Ultra XTR Frame Above Ground Pool with Sand Filter Pump, Ladder, Ground Cloth, Pool Cover, Floats (2 Pack), & Cooler. The materials of the pool are as follows: Experience The Ultra Difference: INTEX above-ground pools include a uniquely designed frame combining high-quality galvanized steel with precision locking for stability, pool ladder, ground cloth for added protection, sand filter, and pool cover Easy To Assemble: Ultra XTR swimming pools above ground are ready in 60 minutes with an Easy Lock System, no pins or tools needed Weather And Rust Resistant: Dual-layer powder...
I'm seeking a comprehensive list of 70 rent-a-car companies in Dubai, specifically their CEO and Managing Director contact details. The final deliverable should be an Excel spreadsheet. Ideal Skills and Experience: - Proficiency in data collection and research - Experience in creating comprehensive, accurate spreadsheets - Understanding of corporate hierarchies, particularly in the transport and rental sectors Please ensure the information is current and accurate, as this will be crucial for my project. Thank you.
I'm experiencing an issue with a combobox in my MS Access database. It's directly bound to TableA and supposed to select entries from Column A. When an entry is found, it should concatenate Column A and Column B and insert the result into Column C in TableB. However, my VBA code keeps throwing an 'Entry Not Found' error, even though I have confirmed all entries are in TableA an...an 'Entry Not Found' error, even though I have confirmed all entries are in TableA and all formats are correct. Key Tasks: - Troubleshoot the combobox issue - Optimize the AfterUpdate VBA code I need a freelancer with strong skills in MS Access and VBA, who can help fix this issue and ensure the combobox can correctly select entries from TableA. Please note, I am not using any f...
I'm seeking an expert to enhance my WooCommerce website's performance. The focus areas include optimizing product photos, filters, and SEO. Key Tasks: - Improve the quality of product images, specifically for apparel. - Optimize the site's filters for better product navigation. - Enhance the site's SEO for improved visi...areas include optimizing product photos, filters, and SEO. Key Tasks: - Improve the quality of product images, specifically for apparel. - Optimize the site's filters for better product navigation. - Enhance the site's SEO for improved visibility. Ideal Candidate: - Proven experience in WooCommerce site optimization. - Expertise in image quality enhancement. - Strong understanding of SEO and filter optimization. - Previous work ...
I'm looking for an experienced SolidWorks macro developer to automate some tasks in my design process. Key Task: - The macro should specifically change the sketch text format and size. Ideal Skills: - Proficiency in SolidWorks and its macro language. - Previous experience in automating tasks within SolidWorks. - Ability to understand and work with design requirements. This project is aimed at improving efficiency by automating repetitive tasks.
I'm in need of a talented mobile app developer to create a restaurant ordering app on a very limited budget. It needs to be compatible with both iOS and Android platforms. Key features of the app should include: - An interactive, filter-friendly menu - The ability to submit orders - A link to payment - An alert system for the restaurant I appreciate any additional useful features you can incorporate, given my budget constraints.
...initial design ideas, but need your expertise to finalize them. Key Features: - User Authentication and Profile Management: The app should allow users to create and manage their profiles. - Shopping Cart and Checkout: A seamless shopping experience is essential, with an easy-to-navigate cart and checkout process. - Product Search and Filtering: Users should be able to easily search for products and filter results based on their preferences. Ideal Skills and Experience: - Proficient in cross-platform mobile app development. - Experience with e-commerce app development is a plus. - Capable of working with preliminary design ideas and providing professional input. - Strong understanding of user authentication systems, shopping cart functionalities and product search features. - Ex...
I'm looking for a skilled data extractor with LinkedIn experience. The task is to extract specific information from user profiles on LinkedIn. Key Requirements: - Extract user profiles data from LinkedIn, focusing primarily on contact information. - Deliver the extracted data in CSV format. Ideal Skills: - Proficient in data extraction and web scraping. - Familiar with LinkedIn's platform and its user profiles. - Experience in delivering data in CSV format.
...resolving power). • Solar system observations, azimuth, and altitude. • Astrodynamics • Orbital mechanics (e.g., transfer orbits and escape velocity). • Tidal forces and interactions between celestial bodies. 4. Computer Science and Data Analysis (Optional but Beneficial) For handling complex data and simulations, some expertise in programming and computational tools is valuable. • Python or MATLAB • For analyzing star charts, light curves, and celestial simulations. • Excel or Data Visualization Tools • Useful for plotting and analyzing observational data. 5. Problem-Solving and Test-Taking Skills In addition to mastering these subjects, experts should: • Practice solving past USAAAO and intern...
I'm seeking a dedicated individual to filter and provide me a list of 2000 Instagram influencers. The goal is to identify suitable partners for a drop shipping venture who can make a promotional video of a product. Key Requirements: - Influencers should have between 1,000 followers - The primary content category of these influencers should be related to drop-shipping. An ideal candidate for this project would be someone with a keen understanding of the drop shipping industry and experience in influencer marketing and expert in filling and filtering data in Excel. Skills in social media analysis and data filtering will be highly beneficial. Please be prepared to demonstrate your ability to meet these criteria.
I need a 3D model of a speargun designed from a RealityScan point cloud extract. I will provide the speargun in multiple pieces, along with a hand sketch with dimensions and a video showing the entire speargun. Ideal candidates for this project should have: - Proficiency in 3D modeling software - Experience with point cloud data - Ability to work from provided sketches and videos - Attention to detail and precision in modeling Please, propose the final model in .d format. Successful freelancers should include: - Relevant past work - Examples of 3D models they have designed - Detailed project proposals The project needs to be completed within a month. Project to be done in Plasticity 3D.
Proposal and Proof of Work Requirements for Dynamic Excel Sheet Development We are seeking an experienced Excel developer to create a dynamic, visually appealing, and proprietary tool for our loan officers. This tool will enable our team to present purchase and refinance scenarios to clients, offering detailed calculations, comparisons, and insights. It should reflect Cohen Mortgage branding, include precise mortgage insurance premium calculations for different loan programs, and be protected to maintain its proprietary nature. Project Scope and Features: 1. User Data Entry Inputs: - Property address - Purchase price - Down payment percentage - Loan amount (calculated automatically) - Interest rate (fixed or adjustable options) - Loan term (e.g., 15, 20, 30 years) -...
I need an Excel Catalogue converted into a visually appealing, professional PDF Catalogue for customer showcase, print and online publication. Key Requirements: - Transforming an Excel Catalogue into a PDF - Designing a professional and formal layout - Incorporating product images, detailed descriptions, and pricing information - Image high resolution Ideal Skills: - Proficient in Excel and PDF design software - Excellent graphic design skills - Experience in creating product catalogues Please only apply if you can demonstrate a strong portfolio in similar projects. The file work on is in this google drive link: Please give me your best quote
I'm seeking assistance to extract email addresses from a dynamic website. I only have frontend access and this task is a one-time requirement. Ideal skills and experience for this job would include: - Proficiency in web scraping tools and techniques - Understanding of dynamic websites and their structures - Ability to extract data efficiently and accurately Please note, the task requires a thorough and meticulous approach to ensure all relevant email addresses are captured. website: (follow instructions by this video:
Please Sign Up or Login to see details.
Abstract: This research develops an anomaly detection system for sequential log data from distributed services by integrating sequential and contextual features. Sequential features capture the temporal dependencies between log entries, allowing the model to identify unusual patterns in the sequence of events that may precede an anomaly. Contextual features, such as word embeddings, are used to extract the semantic meaning from the content of the log messages, helping the model understand the context behind each log entry. This is crucial for detecting anomalies that may not be evident from temporal patterns alone, such as subtle variations in system behavior or unusual error descriptions. The inclusion of semantic meaning enables the detection of early-stage anomalies, which...
