Excel macro extract url cell jobs
Creation of a real estate acquisition model including Cash flow, tenancy schedule, lease modeling and renewal assumptions, IRR, levered and unleverred. Including formula to play with the model.
I have multiple Excel files that require thorough cleaning. The data inconsistencies that I need addressed include duplicates, formatting errors, and incorrect entries. There's also a need for merging, splitting, and conditional formatting. Ideal candidates for this project should be proficient with Excel and have experience in data cleaning. They should also be adept at identifying and solving data-related issues. Ultimately, I need all duplicate entries to be removed from these files. • SKILLS REQUIRED: - Proficiency in Excel - Experience in data cleaning - Ability to merge and split data - Familiarity with conditional formatting
## Scrape and fill in the event data in the sample Excel sheet provided to Win ## What I require: - A lesson on how to efficiently and effectively scrape websites for event data - A rundown on the usage of third-party software in web scraping - I have a list of Urls on a google-sheet and I need to scrape event data Your application should provide evidence of your knowledge of third-party web scraping software. This should be very easy for you.. Please bid with the image of the tool you'll be using. I have attached the sample data.. Scrape for all events Columns and the Event Url in Column Q. To confirm that you used a scrapping tool I may give you 500 additional data for you to
Project Description: We are seeking a talented graphic designer to create a captivating social media flyer for our online course. The course targets individuals aged 15-25 and course name is Data analysis with MS Excel Requirements: 1. Design must be visually appealing, professional, and in line with our brand identity. 2. The post should include engaging visuals and concise, compelling copy to capture the audience's attention. 3. Dimensions: WhatsApp status, WhatsApp post, Instagram 4. Incorporate relevant course details such as course name, key benefits, and a call-to-action (e.g., "Enroll Now"). 5. Use our brand color pallette 6. Provide the design in a high-resolution format suitable for social media posting. Deliverables: - One social media post design in the...
I require a comprehensive spreadsheet created that compares four different real estate brokerages. The spreadsheet should contain multiple tabs, each committed to the follo...four different real estate brokerages. The spreadsheet should contain multiple tabs, each committed to the following aspects: - Fees - Number of transactions closed - Average price point - Stock options - Agent attraction For the 'number of transactions closed', I wish to use a preset value for each brokerage. Moreover, I want the 'fees' data structure to be tiered. Candidates with excellent Excel skills are preferred. It's also beneficial if you have a good understanding of real estate brokerage fees and structures. Attention to detail is essential as the spreadsheet needs to allo...
I'm seeking a proficient and result-oriented professional to scrape data from doctolib.fr. This task primarily involves extracting specific doctor-related data. Key Responsibilities: - Extract doctor's names and their contact information, specifically email addresses and phone numbers. - Focus your extraction based on specific filters like specialization and location. Ideal skills and experience: - You should have exceptional web scraping skills and the ability to navigate through complex websites. - Experience working with healthcare websites, specifically , is highly desirable. - You should possess a sound understanding of data extraction standards and privacy regulations related to health data. - Knowledge of healthcare specializations and an understanding of locati...
I require expertise in extracting purchase details from text-based PDF attachments in my Outlook emails and compiling this data in an excel sheet. Key tasks: - Set up a platform that automatically imports data from new email attachments - Extract purchase details from these attachments - Place this data into an Excel sheet accurately. Skills and Experience: - Proficient in Microsoft Outlook and Excel. - Knowledge of data extraction from text-based PDFs. - Automation experience, ability to set up a system that triggers upon receipt of a new email. - High attention to detail required. - Previous work in data extraction or related fields is a plus.
Data miners needed to search online and find e-commerce health and wellness brands (USA, Canada, UK, Australia), and extract their information from names, personal email addresses, and personal LinkedIn URL. Company LinkedIn URL, website URL. Once the information is gathered, we need it to be sorted in a google sheet, which then we use for our outreach. To start we need 500 business leads gathered, then for successful candidate, we will be needing at least 2000 leads per month. If you’re good, I will pay you more and give you even more work if you can handle it :) You will be spending time gathering the leads and information however you see fit, and you use your own tools to gather the information and put them in a google sheet. Open the sheet, make a...
I'm in need of an Excel VBA expert who can write a VBA routine to alter the font of a string. See image attached Sub BookLabel() Select Range StartLabel (H2) Select first x characters of string where x = value in cell F2 Set font =16 Font = Bold Down 1 cell Repeat same Continue to loop until some statement such as “End”, below the last record End Sub
I need a meticulous person with a keen eye for detail to hunt down and manually input contact details from an event's website into an Excel file. Key Responsibilities: - Collect the data fields: Name, Email, Phone Number, Company and Sector from the website. - Store data in an organized manner in a .xls Excel file. Ideal Candidate: - Someone with experience in manual data entry - Attention to detail, as accuracy is of utmost importance - Please provide examples of past work demonstrating your data entry skills I look forward to seeing your applications and choosing the best fit for this job. Remember, past experience counts!
Hi, I need to extract data and images from product pages into an Excel file. Here is an example link - Video showing it - ATTACHED FILE is the format it needs to go into so I can import it into WooCommerce Product name All images Price About this product Details Variations: color, size, etc
...an existing Angular 15 application. Key Requirements: - Developing Modular and reusable Angular Components - Proficiency in User authentication and registration. - Capability for API integration. - Ability to dynamically update content. - Stripe Payments gateway integration with Subscription modules - You'll be building interactive charts, data tables, grids, and map visualizations. Website URL - Please note, that our application is already very advanced and live so we need a highly proficient developer able to handle and support the application single-handedly. Ideally, you should have experience in diverse design aesthetics and be able to contribute to the final design decision. Strong knowledge of building responsive web applications is an absolute
I am in need of a unique C# script that when run, will open specified URLs in Google Chrome. This is strictly for personal use, meaning I will be the primary user and maintainer. The script will be stand-alone and won't be part of a larger application. Here are ...Here are some key criteria to focus on: tried below but it didnt help ("", $""{bankURL}""); - Must be compatible with Windows OS - Must consistently trigger Chrome to navigate to specified URLs I would appreciate someone who has previous experience in creating C# scripts and interact with browsers, specifically Google Chrome. Sound understanding of URL manipulation and C# will be ideal for this project. A self-motivator who can provide updates at regular intervals would be preferred...
...a meticulous and detail-oriented freelancer to concentrate specifically on the following for an unspecified number of Excel files and bank statements: - Date Formats: Ensure all dates are consistent - Transaction Types: Verification and correction of all transaction types - Narrative Consistency: Ascertain uniformity in transaction narratives Ideal skills for the job would include extensive proofreading experience and in-depth knowledge of Excel data and bank statements. Any examples of past work or detailed project proposals you could include in your application would be beneficial. Please be prepared to dive into a project of an undefined size, as the number of Excel files and bank statements has not been specified. With your assistance, I'm confident we ...
...skilled graphic designer who can develop a series of medium-sized, flat design styled icons for our digital courses. These courses encompass topics including Excel, PowerPoint, MS Project, and Power BI. The icons should follow the style of the ones we already have for our HSE (Health, Safety, and Environment) courses, maintaining consistency across our course offerings. Ideal Skills and Experience: - Proven experience in designing intuitive and visually appealing icons - Proficient in Adobe Illustrator - Strong understanding of flat design principles - Prior work on digital content or courseware would be a bonus - Familiarity with Excel, PowerPoint, MS Project, and Power BI for context-oriented design. Requirements: - Maintain consistency with the style of icons used fo...
Hello. I need to extract the values from this website in a spreadsheet (CSV or XLSX) in an automated way and every 10 minutes: . Must be with a VBA Macro and no required nothing special, only plain text in rows and columns (see attached). You will notice that it corresponds to a website with information about sports betting. The fields to be extracted are ALL the ones you can see per game. For example: - Sport - Country - Championship - Date and time of the event - Equipment - Type of bet (Home/Away, Over/Under 2.5, Final result, etc.) - Etc. Also note that "surebets" with 2 and 3 results appear, depending on the nature of the bet. If you have any doubt, ask me. Look at next examples of 2 results, but 3 results is seemed, adding more columns at the
I am looking for someone skilled in creating a conversion tool. This tool will specifically convert PDF files to CSV format. Requirements: - The tool should extract text data, tables, and images from the PDF files. - It should ensure accurate conversion, maintaining the original layout and formatting as much as possible. The initial task is to convert less than 10 PDF files, with the potential for more in the future. Ideal Skills: - Experience in data conversion between PDF and CSV files - Proficiency in any programming language that is capable of creating said tool - Attention to detail to ensure high-quality conversions - Good problem-solving skills to navigate potential issues during conversion. Bid with proof of your capabilities in this field, I am excited to start this ...
I am in need of an adept web scraping expert who can extract information ranging from website content, product data, to social media posts. The data to be scraped is specifically from Facebook. This project serves the purpose of facilitating market research, competitive analysis, and content aggregation. Therefore, it is paramount that the information gathered is accurate and presents a comprehensive view of the chosen market's state. Ideal Skills and Experience: - Proficiency in data scraping techniques and tools - Outstanding knowledge in analyzing social media content, especially Facebook - Experience with market research and competitive analysis - Strong attention to detail for high accuracy of data collected Please note that the implementation of ethical scraping practi...
I'm seeking a freelancer proficient at data entry for impending tasks. The job involves entering both numerical and textual data. Details: - You will need to enter a mixture of numeric and textual data. - Accuracy is crucial to ensure the quality of data entry. - The finalized data should be provided in an Excel spreadsheet. Skills and Experience: - Proficient in data entry. - Strong attention to detail. - Experience using and formatting Excel spreadsheets.
I have two excel files. In the file, I want you to color code cells from B2:E2 to the end of the columns with text as either green, yellow, orange, red for how closely the text in one cell matches in another. Green - perfect or near perfect match Yellow - most of it is good Orange - less than 70% match Red - poor match or no match I roughly counted there are about 2000 cells.
I'm looking to hire someone proficient with Excel to reconstruct a spreadsheet using a template that I will provide. The new version should replicate the original as closely as possible, without any added functionalities. Key requirements: - The spreadsheet should have exactly the same type of data as the original one. - You will not need to incorporate functionalities such as formulas, calculations, data validation or conditional formatting as they were skipped in the requirements. I want to ensure that my project is in good hands, therefore, your experience is crucial to me. During your application, kindly detail relevant experiences you've had recreating or working with spreadsheet templates. Looking forward to finding a trustworthy and knowledgeable professional w...
I am seeking an Excel expert who can provide in-person training on ‘Budgeting and profit and loss projections’ for one person. I already has an intermediate understanding of Excel and we need further training on: - Basic Excel Functions: The trainer would be expected to reiterate on the basic functions to ensure a strong foundation for the subsequent practical sessions. - Creating Formulas: The ability to create and manage formulas is the next skill we wish to hone. This includes all the necessary functions to perform complex calculations for our projects. The spreadsheet has already been created, it needs to be corrected a little but can be explained further in the training session. This training should be tailored to suit individuals with intermediate ...
I urgently require a meticulous and professional proofreader, well-versed in Swedish, to refine four not-safe-for-work (NSFW) landing pages. My timeline is tight, and I expect the tas...record in proofreading with quick turnaround times. - Attention to detail and a keen eye for maintaining consistency in style. - Comfortable working with NSFW content. - Fluent in both written and spoken Dutch. You will be provided 6 landing pages that you will need to open with a browser language set to Swedish. You will be provided, with an excel containing translations to these pages, any necessary changes should be done in the file, and the cell marked in red. If you're confident in your linguistic skills and can meet the deadline, please submit your bid. Your speedy response is hig...
I urgently require a meticulous and professional proofreader, well-versed in Czech, to refine four not-safe-for-work (NSFW) landing pages. My timeline is tight, and I expect the t...track record in proofreading with quick turnaround times. - Attention to detail and a keen eye for maintaining consistency in style. - Comfortable working with NSFW content. - Fluent in both written and spoken Czech. You will be provided 6 landing pages that you will need to open with a browser language set to Czech. You will be provided, with an excel containing translations to these pages, any necessary changes should be done in the file, and the cell marked in red. If you're confident in your linguistic skills and can meet the deadline, please submit your bid. Your speedy response is hig...
I urgently require a meticulous and professional proofreader, well-versed in Japanese, to refine four not-safe-for-work (NSFW) landing pages. My timeline is tight, and I expect th...record in proofreading with quick turnaround times. - Attention to detail and a keen eye for maintaining consistency in style. - Comfortable working with NSFW content. - Fluent in both written and spoken Japanese. You will be provided 6 landing pages that you will need to open with a browser language set to Japanese. You will be provided, with an excel containing translations to these pages, any necessary changes should be done in the file, and the cell marked in red. If you're confident in your linguistic skills and can meet the deadline, please submit your bid. Your speedy response is hig...
...competent in modifying and updating Android applications, despite not having access to the source code of the app. The goal is to transform the aesthetic and functionality of an already published application on the Play Store named Ibo Player Pro. Key Tasks: * Rebrand the application with a name and logo of our choice * Update the app's information to include our company's contact details, website URL, and a QR code for support access Requirements: Experience in UI/UX design in line with modern and minimalist trends is crucial, as are exceptional skills in Android app modifications. Also, prior experience in implementing QR code functionality would be an advantage. Critical thinking and problem-solving abilities are essential, as the project does not involve full...
Hi there! I'm Sourabh Dhos a detail-oriented individual with a knack for data entry. I thrive in fast-paced environments where accuracy is key. Proficient in ( Excel,ms word,I ensure data integrity while meeting deadlines.
Looking for an individual to accurately transfer numerical information and tables from PDF to Excel. Previous experience in data entry will be advantageous. Ideal skills and qualifications: - Beginner level experience in data entry or similar roles - Proficient in Microsoft Excel - Excellent attention to detail - Ability to interpret and analyze data Example attached.
The aim is to build a comprehensive business plan for my IT Service, consulting tech...attract investment. To this end, I need a professional who can effectively portray my business and future prospects through this plan. Key Requirements: - Incorporation of financial projections for more than 5 years into an Excel sheet. - Strong understanding of the technology service industry. - Experience in developing business plans specifically for investment purposes. Skills and Experience: - Excellent financial modeling skills. - Profound knowledge of the technology industry. - Experience in preparing business plans for fundraising purposes. - Proficiency in Excel. By effectively portraying my business strategy and financial future, you'd provide the key tool I need to secu...
I'm looking for a RPA software specialist who can create a macro for the Google Chrome browser. The main task will be to automate the process of downloading PDF files. The desired macro should: - Navigate to a specific URL - Download all PDFs - This includes navigating to the next page(s) until all PDFs downloaded. Do not use the "All" link, use the "Next page" link. The macro should do the downloads page by page. The page URL is All this can be done with the free version of Ui.Vision. Screenshot attached. We need this macro within the next days. So please only bid if you can work on this now. In your bid, please mention "This week". Sorry about that, we need that filter to avoid all the spam
I'm searching for an individual specialized in data mining and web scraping who can help me extract specific product information from an e-commerce website. Key Responsibilities: - Locate and extract specified data from the selected e-commerce site - Ensure collected data is reliable and structured properly Ideal Candidate: - Has in-depth knowledge in Web Scraping and Data Mining - Is familiar and proficient with Excel as the required output format is an Excel file This project aims to support a larger market research initiative, thus accuracy and attention to detail is critical. Only professionals with proven experience in similar projects need apply.
I'm experiencing an ...pbix file. Despite the fact that my data is neatly structured on a single worksheet with multiple tables in Excel, it is not refreshing in the pbix file when expected. Given the nature of this problem, it's clear that an expertise in data management with Excel and Power BI is necessary for this project. Proficiency in troubleshooting Power BI related issues is also a must. The primary tasks will include: - Analyzing the pbix file and the associated Excel worksheet - Pinpointing the cause behind the failure to refresh data - Implementing a fix to ensure smooth data refresh in the future The preferred freelancer should be experienced with: - Power BI (especially .pbix files) - Excel data management and organization - Problem-so...
I'm looking for scraping expert who can scrape contact information from mobile app. - Key Features: who's calling me - URL - Specific data to scrape: Contact Details - Desired format for the scraped data: - Table in MS Access Skills and experience needed: - Proficiency in data scraping from Android apps And web. - Expertise in converting scraped data into MS Access format
I have a specific goal for this project, which involves web scraping and organizing data into a comprehensive Excel spreadsheet database of UK care homes. The work scope includes: - Extracting contact details (both phone numbers and emails) of each care home - Categorizing the extracted data based on care home location The ideal freelancer for this job should hold the following skills and experience: - Proficient in web scraping - Knowledge of categorizing or sorting data - Excel spreadsheet expertise Accuracy and attention to detail is crucial in this task. This project is suitable for individuals who have previously demonstrated efficiency and success in similar roles. Resource could be
I'm seeking an experienced freelancer who can extract critical information from a website. The focus for the extraction would be on text content and tables. I require: - Successful implementation of data extraction tasks. - An understanding of the website content, focusing on information presented in text and tables. - A high level of accuracy, though minor errors can be tolerated. Required skills and experience: - Proven past work in data extraction from websites. When applying, please include previous work handling similar tasks. Your past work examples will guide
I'm looking for someone to use Elemantor to set up our home page as a landing. These are the WP Theme Traveler and the Solo Tours variant. There are two main segments that should be displayed on the landing page: - Nightlife Activities - Daytime Activities Below this, another six boxes (smaller than the main segments) should be...to use Elemantor to set up our home page as a landing. These are the WP Theme Traveler and the Solo Tours variant. There are two main segments that should be displayed on the landing page: - Nightlife Activities - Daytime Activities Below this, another six boxes (smaller than the main segments) should be displayed: - Jet Skis - Quad tour -Cart - three different nightlife activities The main URL is always chosen as the link. The pictures are ...
...operations. Primarily, I need a skilled Python developer to integrate the Angel Smart API with Microsoft Excel. Areas of concern include: - Developing data retrieval and analysis functionality: This involves retrieving and analyzing stock prices. - Option chain data management: I am specifically looking for functionalities like real-time option chain data retrieval, historical option chain data retrieval, and sophisticated analysis and visualization of the gathered data. - Creating an automated reporting system: In order to keep track of market conditions, an automated system for generating reports is essential. The ideal candidate should be expert in Python, comfortable with Excel, and have experience working with Angel Smart API. A strong background in financial mar...
...document attached for full scope of contest. I require a skilled professional in Excel to develop an automated dashboard for my business. The system will need to manage data entry, data analysis, and reporting - all automated. Key tasks will include: - Setting up a dashboard connected to Excel files with automation functionality. - Automating cleaning up and processing of data for analysis. - Developing reports with automatic generation feature. Regarding data visualization, the dashboard should be capable of generating pie charts, line graphs, and bar graphs as per the data analyzed. You should be proficient in Excel and familiar with data visualization techniques. Experience in automation and connecting Excel with other data sources will also be an adva...
...secure login. Your team would be responsible for managing all aspects, including dynamic IP management, sender identifications, and ongoing maintenance, as well as addressing any blacklisting issues. Additionally, I will provide you with a target URL for the landing page to be promoted. Please note that we need to set up a database for this website as it currently does not have one. It would be greatly appreciated if you could assist us with this task. The objective is for interested parties to register, with their data automatically stored in an Excel spreadsheet. The countries in the German-speaking region where we intend to target our audience are Germany, Austria, and Switzerland. Furthermore, independent promotion of my product in the German-speaking region could b...
I'm seeking a proficient data specialist who can successfully convert a CSV file into an XLSX Excel format. This conversion needs to be done meticulously to ensure optimal usability for sharing data with others. Key responsibilities will include: - Converting a CSV file into an XLSX format - Checking data integrity post-conversion - Ensuring the final layout is easy to understand and use for sharing with others The ideal freelancer for this job has extensive experience with Microsoft Excel and, more specifically, with CSV to Excel conversions. This is a one-off project, but I'm interested in a flawless output. Accuracy and meticulous attention to detail are critical for this task.
I urgently require a meticulous and professional proofreader, well-versed in Italian, to refine four not-safe-for-work (NSFW) landing pages. My timeline is tight, and I expect the...track record in proofreading with quick turnaround times. - Attention to detail and a keen eye for maintaining consistency in style. - Comfortable working with NSFW content. - Fluent in both written and spoken Dutch. You will be provided 6 landing pages that you will need to open with a browser language set to Dutch. You will be provided, with an excel containing translations to these pages, any necessary changes should be done in the file, and the cell marked in red. If you're confident in your linguistic skills and can meet the deadline, please submit your bid. Your speedy response is hig...
I have a requirement for an advanced Excel specialist to develop a structured Gantt chart. More details will be provided to shortlisted candidates.
I am in need of an Excel operator to assist with data entry tasks. Ideal candidates would have extensive experience in Excel and be confident in their data entry abilities. Skills and Requirements: - Proficient in Excel data entry - Attention to detail - Experience with Excel formulas is a plus Application Details: Applicants should include their Excel experience details in their application. Please provide information about past related work, specifically focusing on data entry tasks in Excel. Tasks to be Performed: - Input various data points into Excel spreadsheet accurately - Handle high volumes of data entry - Maintain the integrity and accuracy of the data If this sounds like something you can handle, apply now and let's work...
...Write a "C" function to convert from YUY422 colorspace to RGB, utilizing Arm Neon SIMD for max speed, since we are processing video frames in real-time. Using SiMD shoud be at least 4x faster than not. Need someone who is experienced with C and Neon simd intrinsics. We will provide some test data to use to test the function, or you can use a website that has an online converter we will supply the url. The basic color conversion formula is: R = Y + 1.402 * (Cr - 128) G = Y - 0.344 * (Cb - 128) - 0.714 * (Cr - 128) B = Y + 1.772 * (Cb - 128) We want the function signature to be : void convertYUYVtoRGB8888_neon (uint32_t *rgbDest, const uint16_t *yuyvSrc, int pixelsWidth, int pixelsHeight) YUYV uses 16 bit pixels, but a color conversion requires 2 pixels, as th...
...developed that can process and summarize excel files of chat transcripts. The transcripts are from technical support conversations, encompassing roughly 1000 rows. Each row corresponds to an independent chat transcript. The application should fulfill the following requirements: - The summarizer should give a brief summary of each chat, listed in a new column next to each transcript. - The summaries should highlight the problems faced by customers, the solutions offered, and the general topics covered in the conversations. The ideal freelancer for this project should have experience in backend development and machine learning. They should have expertise in Natural Language Processing (NLP) and possess knowledge of APIs like GPT. Familiarity with Excel and handling large...
...developed that can process and summarize excel files of chat transcripts. The transcripts are from technical support conversations, encompassing roughly 1000 rows. Each row corresponds to an independent chat transcript. The application should fulfill the following requirements: - The summarizer should give a brief summary of each chat, listed in a new column next to each transcript. - The summaries should highlight the problems faced by customers, the solutions offered, and the general topics covered in the conversations. The ideal freelancer for this project should have experience in backend development and machine learning. They should have expertise in Natural Language Processing (NLP) and possess knowledge of APIs like GPT. Familiarity with Excel and handling large...
