Formula to extract a list excluding blanks jobs

We are developing a spreadsheet-based database of the most popular English quotations (or English translations), and are looking for a researcher with native English language skills who can identify and collate (into Excel or Google Sheets) the following requirements, providing the quotation, the author, and the source document (if available): - 1,000 most popular quotations from literature (prose and poetry), excluding Bible quotations and the works of William Shakespeare - 500 additional most popular English language quotations in addition to the above (from non-literary sources - 200 of William Shakespeare’s most popular quotations Maximum length of each quotation is 55 words. Extensive source material is available online, and we encourage the use of...

I'm in the religious industry, looking to extract a dove and keys symbol in an IPS format for my marketing and signage. I'm not sure if these elements are available in the original files, so you might need to advise on whether they should be recreated from scratch. Ideal Skills and Experience: - Graphic design expertise, especially in using IPS format - Knowledge of religious symbols and their connotations - Experience in marketing material and signage design - Good communication skills to advise on the appropriate approach.

I am looking for a skilled freelancer to help me compile personalized information from a list of 400 LinkedIn prospects. The list includes their LinkedIn profile URL, email, phone, name, current employer, current title, industry, location, and company size. Project Requirements: 1) Review each LinkedIn profile. 2) Extract three pieces of personal information about the prospect that a friend might know. This could include: - Interests or hobbies - Recent achievements or career milestones - Personal anecdotes or notable mentions in bio or recommendation Deliverables: - A completed spreadsheet with the extracted information for all 400 prospects. - The information should be concise, relevant, and suitable for use in a personal...

I need a skilled Web Scraping specialist to write code in Python (preferably) that scrapes a specific table from a website for me (Website: ). The table contains WNBA player statistics, The goal is to extract all columns of this table, which is approximately 7 columns and write it to a CSV file (in the same column format). I'm a beginner level coder, and noticed that the table was created with that looks like a Shiny App in R. (I'm not even sure if extracting the table is possible). If it was only possible to use R, then I could potentially work with that. Website: I would like the data to go from the year 2020 to current. Regular Season data. Key Requirements: - Scraping Tables on webs...

I need a VRBO scraper to extract property details, pricing, and availability. - The scraper should be built with Python and the output should be in CSV format. - The data points I need include property title, description, amenities, pricing, and availability. - The scraper should be able to handle multiple URLs at once. - The code should be well-structured and commented for easy maintenance. Ideal skills: - Proficiency in Python - Experience in web scraping - Understanding of VRBO website structure - Ability to handle and store data in CSV format

I need a web scraping professional to create a script to extract specific data from , a popular online marketplace for trading cards, please check attachement to get the idea. Key Requirements: - Scrapping: The primary task is to scrape the following information from the platform: - Card properties 1. Hero score for last 7 days 2. Hero rank for last 7 days 3. Stars 4. Rarity 5. Name 6. Quantity listed to purchase 7. Inflation data 8. Minted count - Buy prices List Price Last Price Order book (price and quantity see picture attached) - Bidding details bids book (bid and quantity see picture attached) - Twitter activity per card View Views+ Likes Likes+ Retweets Retweets+ Replies Replies+ Quo...

I'm seeking a Python developer experienced with web scraping. This job involves setting up a Python script that can scrape a popular review site. Key details to extract: - Review text - Star rating - Date of review - Reviewer name - Star-ratings for sub-categories - Review ID - Reviewed person - Reviewed product name The site does not use captchas, so it should be reasonably straightforward. All reviews for a given provider should be scraped. It would be good to have an option to start with the newest and stop at a certain date. The specific review site can be seen in the sample URL in the attached PDF. I can send further details in a private message including screenshots. Preferred frameworks would be Beautif...

I require a one-time data scraping project completed on multiple websites. - TASK: The task involves scraping text content from: Google searches: Commercial Real estate agency Saudi Arabia Commercial Real estate agency UAE Commercial Real estate agency Qatar Commercial Real estate agency Kuwait Commercial Real estate agency Bahrain I have made a start to the spreadsheet with a template for each of the regions which can be continued to be filled in. In the Google searches, just take the first 3 pages with the main agent listings and see what agent names/ email addresses you can find. - DATA REQUIRED: The primary data needed is text content. - TIMELINE: This is a one-time task, with no ongoing scraping requirements. Skills/Experience: - P...

...challenging aspect of this project is to modify an existing locked Excel spreadsheet which is used to calculate dosages once a patient's weight is entered. Tasks involve: - Updating the dosages of specific medications based on the guidelines I have on hand. - Modifying the weight-based formula in alignment to these dosage updates. Skills and experience: - Proficient in Excel and worksheet protection - Comprehensive understanding of medical dosages - Experience or understanding of weight related dosages calculations. I will provide the necessary medication and dosage guidelines to the successful bidder for reference. The ideal candidate needs to have a keen eye for detail and strong knowledge in medicinally relat...

I need an expert in Optical Character Recognition (OCR) technology to convert text from high-resolution, clear photographs to editable text. Key Project Details: - **Purpose**: The primary objective of this task is to extract data from various documents. - **Image Type**: The text extraction will specifically be from photographs of text. - **Image Quality**: All photographs are high resolution and clear. Ideal Skills and Experience: - Proficient in Optical Character Recognition (OCR) technology - Prior experience in extracting data from images - Excellent attention to detail to ensure accurate transcription - Ability to work efficiently with high-resolution images

I'm looking to test database scraping on a website to extract names and potentially contact emails (if available). The data doesn't necessarily need to be organized or cleaned post-extraction. Ideal Skills: - Proficiency in web scraping tools - Understanding of database structures - Familiarity with handling contact information The data should be organized in an excel and csv based on the desired layout.

I require a specialized web scraping professional with experience in extracting text and images from multiple websites. Your task will involve the following: - Scrape data from Sephora, Cult Beauty, Space nk - Extract specifically the Text, Images, Titles, Descriptions, and Prices A strong background in web scraping, data extraction, and working proficiently across different websites is critical for this project. Knowledge in web parsing methods and ability to bypass potential anti-scraping tools or blocks set up on these websites will be highly advantageous. Your goal is to accurately scrape the necessary information without causing disruption to the target websites, and ensure the data is comprehensible and ready for further use. I would li...

I have a small LinkedIn network of less than 1100 connections and 1500 followers. I'm looking for someone who can help me consolidate their details into a neat spreadsheet with their emails. Key Requirements: - Extracting email addresses: You'll need to be able to extract the email addresses of my connections and followers. - Data presentation: Organize the data in a clear, logical manner which makes the spreadsheet easy to navigate. - Timeliness: I'm aiming for a quick turnaround on this project, ideally within 24-48 hours. Since I have explicit permission from my contacts to collect their emails, this project is ethical and should proceed smoothly. I'm looking forward to seeing how you can help me...

I urgently need someone to extract shareholder information from the Madagascar business registry. The work needs to be done as soon as possible. Key Requirements: - Retrieve shareholder data from the Madagascar business registry - The data should be presented in a clear, easily understandable format

I need a Python Selenium application that can scrape blog posts from Site A and post them on Site B. Key Requirements: - The Python app should be built using Selenium for web scraping and automation. - It should be able to extract blog posts from Site A, specifically. - The extracted data must be posted on an existing blog section of Site B. Ideal Skills & Experience: - Proficient in Python, with experience in building web scrapers. - Strong knowledge of Selenium for web automation. - Previous experience with data extraction and manipulation. - Understanding of web protocols and site structures. - Familiarity with blog post formatting and publishing is a plus.

I'm looking for an Android developer to enhance my app to support zip and rar files. The functionality should include: - Support for both zip and rar files - Support for both password-protected and standard files - Ability for users to extract files - Ability for users to view file contents The ideal candidate should have experience in Android app development, specifically dealing with file handling and storage. Knowledge of third-party libraries for handling zip and rar files is a plus. The developer should also be comfortable with implementing password protection mechanisms. Please note that the app is already built, so the task would primarily involve adding the requested functionality.

I'm looking to integrate Optical Character Recognition (OCR) into my web application. The primary goal is to automate data entry processes. The current application contains manual data entry. I am attaching a screenshot of how it is entered manually and a picture of the paper from which it is typed. OCR should be done automatically. We can take pictures with a mobile phone in a few seconds so that everything is finished. The application is in spring boot and angular. The database is mysql. Functionality for Taking Photos Using HTML5 and JavaScript, you can use an input element with the type file and the attribute accept="image/*" to allow users to take pictures of documents directly from the browser on a mobi...

I'm seeking a professional with experience in text annotation to help me enhance readability and extract key information from Arabic comments on both Facebook and Instagram. This project involves identifying key trends and patterns within these comments. Key Job Requirements: - Fluent in Arabic and English - Excellent understanding of social media platforms, specifically Facebook and Instagram - Strong background in text annotation - Ability to identify patterns and trends in text - Detail-oriented, with a focus on accuracy and consistency Your task will involve reviewing and interpreting comments, then accurately annotifying the content to extract the necessary data. This is a task requiring high levels of concentration and ...

I am engrossed in studying a company's customer, product, and trucks data for my PhD research. Contemporary businesses encounter a significant challenge wherein their delivery trucks often travel from one region to another with insufficient loads (Half of the trucks are empty), resulting in inefficient use of resources. My research aims to minimize the number of empty or partially filled trucks traveling to those areas, particularly in the last-mile delivery process. Below is a list of stores. I kindly request you to extract the dataset from one of the listed companies. The list of stores is prioritized in order. 1- IKEA (IKEA store that located in Saudi Arabia) 2- Home Centre 3- Home Box

I'm in need of a professional who can help with my private limited company's annual compliance tasks. Key Tasks: - Filing Annual Financial Statements - Conducting an Audit - Updating Statutory Registers Key Requirements: A. Auditor Appointment & Filing of Form ADT - 01 (Auditor Appointment). B. Preparation & Filing of Form INC - 20A (Declaration of Commencement of Business). C. Assistance & Documents Preparation for Company's Current Bank Account. D. Preparation & Filing of Balance Sheet, P & L Accounts, Audit Report, and Director's Report. E. Preparation & Filing of Extract of Annual Returns & Financial Statements (Unlimited Transactions). F. Preparation & Filing of Annual Returns Form AOC - 04 (Financials Re...

...looking for an experienced freelancer to develop a state-of-the-art desktop bot for ticket purchasing and availability checking on Ticketmaster and BookMyShow websites. The bot should be able to process simultaneous requests, manage queues, and extract links efficiently. Key Features: - Ticket Purchasing - Ticket Availability Checking - Handling Simultaneous Requests - Effective Queue Management - Link Extraction Ideal skills and experience: - Experience in bot programming and development - Familiarity with the desktop platform - Understanding of the ticket-booking domain - Prior exposure to applications for Ticketmaster or BookMyShow would be an asset. If you've done similar projects before or have innovative ideas on how to execute...

Project Description Objective: Conduct a detailed analysis of several 3D planner software platforms to compare their offerings and pricing structures. The goal is to provide a comprehensive, visually appealing summary that highlights key features, subscription plans, and costs associated with each software. Scope: Competitors: The platforms to be analyzed include Saninet 3D Planner, MATICAD DOMUS3D, PALETTE CAD, TILE LOOK, VISOFT, and SPARK VISION. Data Collection: Extract detailed information from the competitors' websites, focusing on: Price Features Customer Support Compatibility Cost Type of Subscription What is included in each type of subscription 3D Modeling Costs: Gather information about the costs associated with 3D modeling for new...

...convert text in images to answers, and I'm looking for someone with the right skills and experience to help with this personal research project. Key Requirements: - I need an AI model that can accurately convert text in photographs to answers. The model should be able to understand the text in the images and provide relevant responses to the queries. - The AI model should be trained to high accuracy standards, achieving results of 90% or higher. This level of precision is crucial for the success of the project. - The primary images that the AI model will analyze are photographs. The model should be specifically designed to handle and extract text information from photos. Ideal Skills and Experience: - Experience in t...

I'm looking to leverage Azure document intelligence prebuilt models and train models to extract data from a variety of tax and financial documents. The extracted data needs to be exported into a Google spreadsheet. Additionally, I need an interface for users to easily upload these documents. Key Requirements: - Extract data from various financial documents: primarily focusing on Expense reports, W-2 forms, credit card statements, 1099s, and annuities. - Extract specific data from credit card statements such as Transaction amounts, Merchant names, Transaction dates, and also the ability to convert currency and combine rows. - Extract specific data from bank statements like Account balances, Transaction descri...

I need an expert in data entry, cleaning, and data visualization in RStudio. The primary goal of this project is to identify trends in a small dataset (less than 1,000 rows). Ideal Skills and Experience: - Expertise in data entry, cleaning, and visualization in RStudio - Strong understanding of R Programming - Proven experience working with small datasets with missing data - Ability to identify trends through data analysis Please only apply if you have demonstrable experience with RStudio and data analysis. The ideal candidate should be able to extract meaningful insights from data and present them in a clear and concise manner.

I'm seeking an Airtable expert to assist me with a number of tasks, including data entry and organization, building custom workflows, and creating advanced formulas. Ideal candidates should have: - Previous experience working with Airtable, including data entry and organization, workflow creation, and complex formula design - A strong understanding of how to make the most of the tool, including its integrations and automations Please note that while my exact requirements in terms of the number of tables and views in my Airtable base, as well as specific integrations I need, have not been stated, I expect the freelancer to be able to adapt to my needs and work in an agile manner.

I'm working on a project using Ignition 8.1.31 and need a feature implemented. The goal is to have a dropdown list in the perspective view that allows the user to select files from a specified directory. Key Points: - The dropdown should be populated with the file names upon the user clicking a perspective View button. - The Load button should be located on the perspective view. The ideal freelancer for this job should have experience with Ignition 8.1.31 and familiarity with creating dropdown lists that are dynamically populated based on user interactions.

Seeking a tech-savvy professional to establish an automated system leveraging ChatGPT and Make Automation. The aim is to: - Automatically extract specific information from a variety of documents including Word, PDF files, Excel Spreadsheets, and Scanned documents - Thoroughly analyze extracted content including text, tables, charts, and images for compliance and precision - Automatically generate comprehensive reports based on extracted information for easy reference For this task, proficiencies in AI, Machine Learning, ChatGPT, and automation are necessary. Likewise, experience in OCR technology for processing scanned documents will be valuable. Not only should the candidate be detail-oriented - they should also be adept at debugging and ensuring the ...

I'm in need of a data entry specialist who excels in text data entry from online sources. Your main task will be to input data from online sources into a structured format of my preference. Ideal Skills and Experience: - Proven experience as a text data entry specialist - Proficient in using data entry software - Attention to detail and accuracy in data input - Familiarity with online data sources and the ability to extract information from them - Efficient typing skills - Ability to follow guidelines and meet deadlines It's crucial that you can ensure accuracy in your work, even when dealing with large volumes of data. Your goal should be to maintain the highest data integrity and quality throughout the process.

I am seeking a data-savvy individual with experience in compiling email lists to help me create a targeted list of small businesses in Australia for my email marketing campaigns. I will provide the business types I'm interested in: retail stores, restaurants, and service providers. Key Responsibilities: - Research and compile a comprehensive email list of small businesses across Australia, specifically in the retail, restaurant and service provider sectors. - Ensure the list is accurate, up-to-date, and segmented according to the provided business types. Ideal Candidate: - Experience in creating targeted email lists, particularly for small businesses. - Familiarity with Australian small business landscape. - Attention ...

...Designer** We are seeking a talented and creative freelance professional with a background in structural engineering, mechanical engineering, or arts & crafts to develop unique cardboard craft projects for children aged 5-10. The ideal candidate will have a passion for crafting, an innovative approach to design, and the technical skills to ensure projects are both engaging and structurally sound. Please see attached file to see what are the limitations. **Project Overview:** - **Craft Focus:** Create engaging and educational cardboard craft projects suitable for children aged 5-10. - **Design Constraints:** Crafts must be limited to using specific actions and techniques: cut, score, and punch. - **Scope:** Develop 50 uni...

I'm looking for a freelancer to help me with email scraping to build a targeted email list in the education sector. Specifically, I'm interested in parents who are seeking tuition services for their children. Key Responsibilities: - Conducting research online to identify and extract email addresses of parents seeking tuition services for their children - Organizing the list in an easily accessible format that I can utilize for email marketing campaigns Skills and Experience: - Proficiency in email scraping and list-building - Prior experience in targeting the education sector is desirable - Understanding of lead generation and email marketing best practices

...presently seeking a highly skilled freelancer for an email extraction project from two highly popular social media platforms - Facebook and Instagram. Key Project Specifications: - Scrape email addresses from both Facebook and Instagram. - Selection of the profiles for scraping should be primarily based on the following criteria: levels of user engagement and followers count. - Along with the email addresses, extract additional user information namely: the account name and its location. Ideal Candidate Profile: - Must have experience in deducing complex social media algorithms. - Understanding of digital privacy laws to ensure compliance during the extraction process. - Fluency in software that can automate this extraction process would be advantageous. ...

I'm seeking an expert in web scraping to specifically help extract data (price, stock availability, description, review content,..) from e-commerce platforms. Your specific task will entail: - Identifying and implementing the most efficient and effective way to scrape data. - extracting all data related to a product (picture, price, description, reviews, rating,...). Your method should maintain adherence to all legal and ethical guidelines - I'll need details on this as your bid. This project will require: - Proficiency in web scraping tools and techniques. - Sound knowledge of data extraction and storing processes. - Ability to work with undisclosed e-commerce platforms. - Familiarity with review structures on e-commerce sites.

I am looking for an expert in web scraping who can efficiently extract business leads. While the primary purpose of the project was not specified, it is undeniable that these leads will play a pivotal role in marketing efforts, like sales lead generation, market research, and contact information collection. Although I did not mention a specific source site, note that the target is business owners, and their revenue and contact information. Therefore, having experience in scraping from professional networking and business directory websites such as LinkedIn or Yellow Pages would be welcomed. Lastly, the exact number of leads that I need hasn't been defined, so I am open to both small and large-scale operations. Ultimately, their quality is of more importa...

...in website crawling and data extraction to help gather specific information from various websites on a daily basis. - The purpose of the project is to extract data; specifically URLs, contact details (telephone, email), date created, a description, and pricing details. - The desired frequency of website crawling and data extraction is daily, so a high level of commitment is required to ensure consistent data retrieval. Skills & Experience: - The ideal candidate should have experience in website crawling, data extraction, and data mining. - A background in programming or website development would be highly advantageous. - Accuracy and attention to detail are paramount for this project, as the data extracted need...

Hi, Nee one simple PhP,MySQL app which will prompt/require for Document-URL: and extract all the short abbreviations inner in (....) from entire document(with PDF,...extensions). The report/result will like this table with 2 columns: sentence | terms-founded | string of terms | check-selection | button "do-it" Then I will select the terms by checking and then I will press the button "do-it" and the selected terms founded between (...) will be savet into MysQl Table. So for Document-URL: this is simple example of line from this report -sentence: "With the deployment of

I need assistance with extracting specific data from a voter list that comes in PDF format from the election commission. Here’s what I need: - Extract Name, FathersName, Age, Gender, VoterID, and SerialNumber from the PDF voter list. - Placement in a standard Excel format is acceptable, no need for any specific formatting. - Not just a one-time service, I also need a software or script that can perform this PDF-to-Excel conversion automatically in the future. Ideal candidates for this project have advanced skills in data extraction, familiarity with handling election data and proficiency in developing an automated system for convenient PDF to Excel conversion.

I need a skilled Excel user to help me format a single spreadsheet and create formulas to automate some calculations. Key Responsibilities: - Format the spreadsheet to make it visually appealing and easy to read. - Create formulas to automate calculations based on the data input. - Ensure the spreadsheet is user-friendly and easy to update. Ideal Skills and Experience: - Proficiency in Excel, particularly in data formatting and formula creation. - Prior experience in handling data-heavy spreadsheets. - Strong attention to detail to ensure accurate data processing. - Ability to work independently and deliver the project in a timely manner.

I'm looking for a freelancer who can extract all the information and workouts from the Summers Method workout app. Key Responsibilities: - Extract all workout videos - Compile exercise descriptions - Collect training schedules - Provide me with all data from the application I will provide you with login credentials to access the application and you will need to deliver everything in a PDF document/ along with videos in MP4 format. Ideally, the freelancer should have experience in data extraction, be thorough and detail-oriented. They should also have a basic understanding of workout routines and fitness. Please note that I need all the information from this app, no exceptions.

...website even after excluding its scripts and files from my cache plugin, the issue appeared after I deactivated and deleted my old cookie plugin "Cookie Notice & Compliance for GDPR / CCPA" I now want to use a new plugin called "#" but it is not loading at all. I need you to look into why my new plugin is not working and showing my new cookie policy. CLICK AND COLLECT I have an online store that does deliveries according to a time and date you choose, I use a plugin called "WooCommerce Delivery & Pickup Date Time" to achieve this, I now want to implement a click and collect service which the plugin has already but I need custom components added to my website. Firstly I ...

...an experienced Excel guru to help create / identify two specific formulas on my spreadsheet. This project is URGENT. The right excel Guru can probably figure this out in less than an hour. Easy money. The first formula is related to searching a cell for one of four words and populating an adjacent column with a correlating value, based on the word found. The four words to be searched for are "Low", "Medium", "High", and "Not currently a priority". The adjacent cells are to be populated with correlating values 1, 2, 3, and 0 (to generate a Score). The cells are currently blank, and users of the spreadsheet will fill these cells by selecting from a drop-down list (...

I need a sound expert to help me separate the bass/drum sound effect from a 1-second MP3 music clip. The task should be completed as soon as possible. Ideal skills and experience: - Proficient in audio editing - Able to identify and extract specific sound elements from a music clip - Previous experience with sound effect extraction

I'm looking to create an extensive database of rice mills in India that includes essential information like Name, Address, Contact, Email and GST details. This data will be used for sales outreach, so each entry needs to be thorough and accurate. Key deliverables: - Compilation of data in a spreadsheet format. - Each entry must include the rice mill's Name, Address, Contact, Email, and GST details. Ideal Skills and Experience: - Proficiency in data collection and organization. - Strong attention to detail and accuracy. - Prior experience in market research, data mining or similar projects. - Knowledge of the agricultural industry in India would be a plus, but not required.

I need a developer proficient in and a good understanding in API development. I have a parameter I would like to pass which is a string value to pull an entire user object with all of the properties in a database. this would be a string parameter passed into a Get request with a response of an entire record pulled from a MySQL database and using an Interface to extract the properties into a page. This is a very small project and should only take a few minutes of time.

I need a skilled developer who is proficient in working with Google Cloud's OCR functionalities. The project involves the following specifics: - File Format: The OCR system should be able to extract text from PDF files, no other formats are required. - Output Format: The extracted text should be converted into a word file and worksheets. - Language Support: The OCR should be able to recognize and extract text in English only. This task requires someone with expertise in Google Cloud's OCR, the ability to generate word files and worksheets, and a solid understanding of language processing for English. High attention to detail and accuracy is crucial for this project. Basic UI is also needed for file management lik...

We are seeking a talented AI expert to urgently develop a sophisticated multi-modal sentiment analysis and emotion recognition system. This system aims to analyze and understand human emotions expressed through various modalities, including text, images, and audio. The primary objectives of this urgent project include: 1. Multi-Modal Data Integration: Develop algorithms to effectively fuse information from text, images, and audio sources to capture the holistic context of emotional expression. 2. Text Analysis: Implement state-of-the-art NLP techniques to extract sentiment and emotion from textual data. This involves sentiment polarity detection, emotion classification, and fine-grained sentiment analysis. 3. Image Analysis: Utili...

I need an expert to collect transaction history and wallet addresses from a specific TON wallet and deliver the data in an Excel spreadsheet. This job is a one-time project; there's no need for weekly or monthly reporting. The ideal candidate should: - Be experienced in data collection from TON wallets. - Have a proficient command of Excel. Your task will be to: - Extract transaction history from the wallet. - Obtain wallet addresses linked to the wallet. - Present this data in an organized Excel spreadsheet. Your main goal is to provide me with a comprehensive view of the wallet's transaction history and addresses. The data should be well-structured and easy to interpret. The main requirement is below. Ple...

I'm looking for someone to help me create a list of 2000 industry specific business contacts, particularly names, company names, position, location information and email addresses. I would like this list to be compiled through online research only. Key responsibilities: - Researching and compiling a list of business contacts - Ensuring all email addresses are verified and duplicates removed. Note: The focus should be on getting accurate, up-to-date information.