I need an Excel VBA code that can perform exact word matching within an Excel spreadsheet. - The code should generate a list of matched words.
I'm looking for an expert in Excel to assist with a project involving data entry and analysis. The Excel sheet you'll be working on has more than 50 columns and rows and will contain a mix of text, numbers, and dates. You'll be responsible for the following: - Accurate and timely entry of the data provided - Ensuring the data is appropriately formatted and organized - Conducting thorough data analysis, including but not limited to trends, comparisons, and any other insights that can be drawn from the data The ideal candidate for this project should have: - Proficiency in Excel and experience with large data sets - Strong attention to detail - Ability to perform data analysis and present insights - Good ...
I'm on the lookout for a talented virtual assistant who thrives on lengthy hours of work and enjoys every second of it! This isn't your usual VA role, though - I'm seeking someone who can confidently handle the following responsibilities: - Social Media Management: More specifically, I need someone adept at Instagram. You'll be responsible for handling and managin...our audience. Ideal Skills and Experience: - Clear understanding of the Instagram platform and how to optimally engage audience in it - Skills in crafting Instagram worthy content - visuals, captions, and stories - Experience in managing professional instagram account is a plus - Must be organized, communicative, and able to handle long hours of work If this sounds like the sort of work you'd exc...
For this project, I require an exper...an expert who can efficiently extract text content from two distinct webpages and input my data into an Excel file organized by rows. Given that all types of data hold equal importance to me, of essence is for the professional to: - Accurately scrape all text content from the specified webpages - Ensure no data is skewed or omitted during this process - Neatly organize the data by rows in the Excel file The ideal candidate for this job should be proficient in web scraping tools and techniques, possesses an acute attention to detail, and is experienced in using Excel to ensure data is properly formatted and easy to analyze. Please note that minimizing errors during this process is critical, as ...
Project Duration: 1 Hour Project Type: Python Script Modification Project Level: Normal Server Type: Ubuntu 22.04 Number of Changes Required: 1 Project Overview: We have an existing Python script that allows us to upload a CSV with two columns: Prompt Output The script then submits each “Prompt” to the OpenAI API, inserts the output into the “Output” column. We would like one change made to the existing script. Change Required: We would like to add one more column to the CSV file, “Id”, it will be the first column. We use “Id” as our own reference number for the row This column and its value should be retained in the output file. 5* FEEDBACK WILL BE LEFT FOR YOU
The site was created on WordPress * Set up link personalization so that by clicking on a link sent from the site, the page opens only to the user to whom it was sent. If clicking on the link will enter the login information of another user, in this case it should not proceed. Configure the correct redirect to the necessary sites * insert a link to a document for download on one of the site pages (this document has already been generated and there is a download link on another page of the site) * Add generation of an invoice for using the site in pdf form (the form will be provided) with saving on the pages in the admin panel and on the user page. * Edit the account pages created in the admin panel, add a filter by user, month, account status and account number (these fields have...
I am looking for a mid-level QA Tester from India, with experience in both mobile and web applications. The ideal candidate for the job should have: - Experience in testing iOS and Andr...for the job should have: - Experience in testing iOS and Android platforms, as well as web portals - Capable of performing functional and design testing - Proficient in testing user registration, login/authentication, and other functionalities as per the logic - Ability to carry out thorough functionality testing as per the given requirements - Ability to report bugs and issues in the Google Spreadsheet with proper description and snapshots Please note that mid-level experience is a must for this role. The chosen candidate is expected to ensure the quality and performance of our mobile app and w...
...on a monthly basis. The project involves: - Collating and organizing data: The dashboard should cover Attendance and leave records, Training and development, as well as metrics like age, experience, tenure, salary and location of our employees. Your ability to structure and organize these aspects will be key. - Creating an Excel-based system: I'm looking for a dashboard that's easy to dissect and understand. As such, I'd like the final product to be in Excel spreadsheet format. This means you should be very proficient in Excel, knowing how to integrate formulas, tables and other relevant features. - Monthly updates: The dashboard should be designed to be updated monthly. You should be dedicated to ensuring that the data is up-t...
I have an excel sheet with intermediate complexity data, including formulas and charts. I need someone to transfer this data into tables, with the primary goal of organizing the information for better clarity and ease of understanding. Key Tasks: - Type the data into tables: This needs to be done with meticulous attention to detail to ensure accuracy and integrity of the data. - Apply borders and shading: To enhance the visibility of the tables and make them aesthetically pleasing. - Utilize headers: Rows and columns should have appropriate headers to aid in quick data navigation. Ideal Freelancer: - Proficient in Excel: Ability to work with intermediate level of data such as formulas and charts. - Strong attention to detail: Critic...
I have a set of scanned Hindi documents that need to be transcribed into Microsoft Word for further processing. Key Requirements: - Digitalizatio...of this task is to convert the scanned copies into a digital format. - Basic Formatting: The text should be typed with basic formatting (e.g. bold, italic, etc.) but does not need to exactly match the scanned copies. Ideal Freelancer: - Proficient in Hindi: The freelancer should have a strong command of the Hindi language to accurately transcribe the content. - Experienced in Data Entry: This project requires good data entry skills to ensure accurate and efficient transcription. - Proficient in Microsoft Word: Prior experience with transcribing documents in Microsoft Word is preferred. 3 books in Hindi scanned copies each one ...
...looking for an Excel expert who can create a comprehensive sales target tracking spreadsheet for my customers. This spreadsheet should have several key functionalities. Features Needed: - Customer Information: It should contain a section where I can input and maintain all my customer's details. - Sales Tracking: The spreadsheet should enable me to track my sales targets daily and provide a detailed analysis of my performance. - Target Achievement: The spreadsheet should also be able to analyze the achievement or shortfall of selected items target completion by each customer. Analysis Required: - I would love to have a feature that shows how well sales targets are being achieved as per defined targets. Ideal candidate should have great atte...
I need an organized mind to help with research and data entry of a list of companies in a specific industry. Your main responsibility will be organizing this data. While basic Excel skills are a must, experience with data organization, particularly in a business context, would be highly beneficial. The data will be divided into 4 separate categories, so whoever takes on this task needs to have a keen attention to detail and an understanding of categorization. This project is perfect for an individual who thrives in organizing and systematizing data.
**Tour Costing Sheet Structure** 1. **Tour Details** - Tour Name - Tour Code - Duration - Destinations 2. **Client Information** - Client Name - Number of Adults/Children - Contact Information 3. **Accommodation** - Hotel Name - Room Type - Meal Plan - Cost per Night - Total Nights - Total Cost 4. **Transportation** - Vehicle Type - Distance - Cost per Kilometer - Total Cost 5. **Sightseeing and Activities** - Activity Name - Per Person Cost - Number of Persons - Total Cost 6. **Miscellaneous Expenses** - Guide Fees - Entrance Fees - Other Expenses 7. **Pricing** - Subtotal (Sum of all costs) - Markup Percentage - GST (Goods and Services Tax) - Final Price 8. **Payment Details** - Deposit Require...
I'm looking for a talented script writer to work on a draft comedy script for a TV project. This script will be targeted at an adult audience. Key Points: - Your primary task is to review, modify and work on the draft to create a compelling, engaging, and humorous script that will captivate the listeners. - The tone of the script should be light-hearted, witty, and entertaining, in line with the comedy genre. - Understanding of TV scripts and their unique requirements is a plus. Ideal Skills: - Proven experience in comedy scriptwriting, especially for radio. - Ability to tailor humor for an adult audience. - Strong understanding of pacing and structure in scripting. - Familiarity with the TV industry and its specific requirements. - Excellent commu...
I am currently working on a project that requires the integration of Excel with a PostgreSQL database. As such, I am in need of a freelancer who is proficient in both Excel and PostgreSQL. The primary tasks to accomplish include: 1. Exporting data from Excel to SQL 2. Updating PostgreSQL data using Excel You will be working with various kinds of data as we aim to streamline our operations in a more efficient manner. Ideal skills and experience include: - Solid understanding of PostgreSQL - Expert skills in Excel - Previous experience with SQL data exporting and updating The success of this project highly relies on a flawless data transfer between Excel and PostgreSQL. Your expertise will be extremely valu...
I need a script that will convert any html div to pdf (and download).
I'm in need of an expert to assist with the cleanup of our Medicine database. The goal of this project is to accurately remove all duplicate entries improving the overall accuracy of the data. Ideal Skills & Experience: - Strong background in Database / Excel /CSV management, specifically in the medical field. - Proven track record of similar past work. In your application, please include details of similar projects you've worked on. Efficiency and precision are pivotal for this task. Looking forward to a neat and streamlined database!
The attached PDF lists every musician who played for the St. Louis Symphony between 1907-1908 and 1978-1979. I would like the data copied into a spreadsheet. To illustrate the desired format, I have entered the first 11 rows into the attached spreadsheet. The PDF is 34 pages long and I estimate it lists 1500 musicians. I would estimate the job will take 15 person-hours to complete. Thanks for your consideration!
I have a channel where I make EXCEL educational videos, I upload 12 videos a month, between 5 to 7 minutes each. YOU MUST BE ABLE TO : - Have experience in editing videos for YouTube. - Have basic knowledge of Microsoft Office, to be able to edit the videos better. - Be able to edit 10- 12 videos consistently every week (Some will be only 1 minute long). IF YOU WANT TO STAND OUT FROM THE REST SEND US YOUR PORTFOLIO
I need an expert in data capturing to mine specific information from websites and organize it efficiently into spreadsheets. The ideal candidate should be meticulous and comfortable with the following: - Data Capturing: The primary task involves extracting and compiling data from various websites. - Web Research: Ability to navigate and find required data efficiently. - Spreadsheet Proficiency: Experience with spreadsheets and data organization. Please bid if you have a strong eye for detail and a proven track record in data entry and web research.
I need a word document translated from English to Russian as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!
I've recently established a venture named "Atlas Truck Parts" and am in need of a unique, professional logo to represent my business. The logo should be a combination of text and symbol, encapsulating what our company represents. ...colors - Create a logo that embodies the essence of a truck parts company In terms of skills and experience, proficiency in graphic design and a portfolio featuring logo designs are essential. Experience in creating logos for a similar industry would be an added advantage. I would like to incorperate the ATLAS statue with the man holding the world on his shoulders, eith remove the globe and insert a truck or possibly the business name instead just as an idea or stretch out the initial "ATP" in block letters as the trailer and...
We are a dev team and seeking a highly experienced individual dev with in-depth proficiency in Laravel, Vue, and Flutter. Your responsibility will comprise the rebranding and extending of existing Codecanyon scripts. - **Script Rebranding**: I need a meticulous freelancer able to successfully rebrand scripts to brands of clients. - **Extending Scripts**: Your tasks also include extending Codecanyon scripts by adding extra functionalities, ensuring consistent, flawless operation , implementing APIs and adding the functionalities in the existing flutter app, testing, fixing any bugs to ensure smooth operations of the system. Pay : 1. INR1200/day or fixed amount as decided by our project managers, for 8 hours of work on anydesk/github for adding functions 2. INR 2000/project for ...
I require an experienced data analyst conversant with Excel to create a detailed spreadsheet and comprehendible report about compression pay between LPN & RN nurses, as well as nurse supervisors. Key data points to include: - Hourly pay rates of each role - Years of experience in each position - Total number of employees in each role - Comparison of compression pay between the nurse employees and nurse supervisors The compression pay should be calculated using a ratio comparison method, highlighting the variation in detail. I am also looking for a detailed analysis in the report explaining the compression shown. Required skills: - Proficient in Microsoft excel - Experience in generating analytical reports - Strong attention to detail - Under...
Hello, I'm looking for someone to create a Google Sheets spreadsheet filled with YouTube URLs that meet the following criteria: * License: Must be Creative Commons licensed. * Visuals: - Full face visible, speaking directly to the camera; the rest of the body can be included. - Only one person in the shot and speaking throughout the entire video (no cuts to other people). * Quality: High definition (HD or better), not grainy. * Editing: Minimal editing; should be a single take (intro and fade out are acceptable). * Audio: Clear speech; background noise or music is okay if it does not overpower the speech. * Occlusions: No obstructions, such as hands or microphones, in front of the face. * Emotion: Videos displaying significant emotional expression are preferred...
I am in need of a specialist to optimize my Amazon product listings for coloring books. The key focus will be enhancing visibility and maximizing customer engagement for my book collection. Here's what I am looking for in a freelancer: - I need you to know more about KDP marketing than I do. I only know the basics. I need an advanced skilled...listing. - Suggesting effective marketing strategies tailored to coloring books. - Execute strategies once approved. - Expertise in Amazon's A9 algorithm to optimize listings. Through these efforts, the ultimate goal is to increase the visibility of my coloring books on Amazon, targeting a better ranking in search results, and thereby improving sales. If you have the skills and experience to excel in this role, I would be thrill...
We're focused on helping LGBTQ+ owned businesses, so we're also looking for a graphic designer who's also in ...a sense of design with attention to detail, so you can play around with the existing style, while still staying true to the style. If everything works well and you have the branding knowledge + skill, you can take more responsibilities on the branding side as well — both for the concept and design. So, this will start with a trial period, and you can gradually get more and more hours. Please insert in your reply, why you'd love to be involved in a queer-owned business and help other queer-owned businesses. This way, we'll know that you've actually read this listing. Thank you for and looking forward to hearing from you. Please feel fr...
...should be in Excel (.xlsx) and easily editable. - **Data Required**: The spreadsheet should include Business Name, Address, Phone Number, Email (if available), and any other relevant contact details. - **Usage**: I'll be using this directory for sales lead generation, so it's crucial that all the information is up-to-date and well-organized. - **Categorization**: The businesses should be categorized by specific industry (e.g., Hospitality, Retail) to help with targeted marketing efforts. I would like this done for the retail/hospitality e.g. butchers, newsagents, cafes, and convenience stores. We are not targeting large chains or franchisees. **Ideal Freelancer**: - **Excel Expert**: Proficiency in Excel is a must for this project. - **...
As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previous similar work in your proposal.
I'm in need of an Excel formula expert to help me with a specific task. I need a formula that will COUNT cells based on the following criteria: - I need to COUNT the number of cells in a range that are greater than -250 - The count should be done for the last 50 cells (ongoing) Your task will be to help me create a formula that dynamically counts the number of cells based on the above criteria. I need this formula to be able to adjust as new values are added to the range. The ideal Freelancer for this project should have: - Extensive experience with Excel functions and formulas - Strong understanding of dynamic range referencing in Excel - Excellent communication skills to explain the logic behind the formula in layman's terms Please include any relevant...
I'm seeking a highly skilled programmer proficient in Excel macros and ODBC data connections to automate critical processes in my business. Specifically, your tasks will involve: - Automating order tracking, inventory management, and vendor communication processes. - Connecting to Excel files, SQL databases, and CSV files using ODBC. - Developing an automated procurement system capable of: - Generating purchase requisitions, - Aiding in vendor selection and negotiation, - Creating and tracking purchase orders. Proficiency in utilizing Excel macros is a must, and experience with ODBC data connections and related platforms is highly desirable. Knowledge of procurement systems and order logistics would be beneficial. Successful completion of th...
2 excel files with VBA macro as per customer requirement
...select topic and then google it looking for the research paper. then find the survey paper usually you will find 50 papers. and i want him/her to make a table highlighting the compares. Please note that completion is needed ASAP. Your prompt attention and quick work turnaround will be highly appreciated. Research Report 1. Title: [Insert your research title here] 2. Names: [Insert author names here] 3. Department: [Insert department name here] 4. Email: [Insert email address here] 5. Abstract (9-10 lines): Research area: Briefly explain the area your research focuses on. Problems: Identify the key problems existing in the research area. Solutions: Briefly mention the solutions your research proposes. 6. Introduction (20 lines): General overview: P...
I'm looking for a designer who can craft a modern, minimalistic logo for my IT support business. This unique logo should include a symbol referring to technology such as a computer/laptop symbol, circuits, or a cloud. Requirements: - Use of cool tones, specifically blues and grays, to communicate our corporate image. - A minimal, sleek sans-serif, serif or script typeface. The choice is yours as I don't have any specific preferences. - The design should be innovative, portraying my business as a cutting-edge, modern IT support firm. - I would like the logo to be an symbol next to the company name Ideal skills: - Creative graphic design - Knowledge in modern logo trends - Familiarity with tech - Attention to details Please include samples of your previous work, espec...
...expert in Microsoft Excel to build an efficient spreadsheet to monitor potential lost revenue due to late service deliveries. The ideal candidate would possess a strong background in creating financial models and understanding of revenue tracking. Key Requirements: - Proficient in Microsoft Excel, with emphasis on creating advanced, clear, and highly-functional spreadsheets. - Experience in financial modelling and understanding of revenue tracking. - Ability to automate the process as much as possible to minimize manual tracking. Objective: - Create an intuitive and efficient Excel spreadsheet to replace the current manual method of tracking potential lost revenue due to late service. Skills Needed: - Microsoft Excel - Financial modellin...
...complex script that combines SMC schools, ICT schools, and commercial use elements into a single Tradingview indicator. Here are more details on what I'm looking for: - The script should include various elements from SMC and ICT schools, as well as classic trading methodologies for commercial use. - The primary feature of the script will be the creation of a custom indicator on Tradingview. - This indicator should accurately reflect the principles and strategies taught in SMC and ICT schools, while also incorporating classic trading approaches. Ideal skills for this project: - Proficiency in Tradingview script development - Understanding of SMC and ICT trading methodologies - Knowledge of classic trading indicators and strategies - Ability to create...
I'm seeking a professional to diligently run through LinkedIn, identifying and documenting HR higher-u...Identifying: I'm targeting senior-level personnel only. Expertise in navigating LinkedIn search and understanding corporate hierarchies will be a plus point. 2. Documenting: I'd like the findings to be presented in a tabular form within an Excel document. Critical data points to be captured include the Company Name, individual's LinkedIn Profile link, and their Role. Your background in HR and corporate structures would be critical in understanding the perfect fit for my requirements. Strong organizational skills, meticulous attention to detail, and proficiency in Excel would be highly appreciated. Overall, a good grasp of LinkedIn-based researc...
To help manage my work efficiently, I am in need of a proficient virtual assistant. Using Google Sheets, your initial task entails creating a spreadsheet listing festivals held in Louisiana and Mississippi. This sheet should include: - Festival names - Festival locations - Festival dates Apart from spreadsheet creation, I'll also require assistance with customer service tasks. This role best fits someone that is skilled in utilizing Google Sheets and who possesses excellent customer service skills. Prior experience in a similar role is a bonus, but not a must.
I'm looking for a skilled freelancer to help me create a pivot table in Microsoft Excel that will be used to find pricing quicker Key Requirements: - The pivot table must be created in Microsoft Excel. - The purpose of the pivot table is to find pricing easier The data sources which the pivot table will be using are confidential, and will be shared with the selected freelancer.
I'm looking for a graphic designer who can skillfully change the background of an image to create a new environment. Specifically, the image is of my wife on our wedding day, she really wanted a picture of her with the car, but we forgot on the day and missed the opportunity. Key Tasks: - Add picture of her beetle into the background of a wedding picture - Insert a high-resolution, realistic new environment - Position my Beetle car prominently in the image - Images can be sent over Ideally, you have previous experience with car image editing and can demonstrate a high level of attention to detail. I'm expecting the result to be realistic and in high definition. Proficiency in Photoshop or equivalent software is required. If you appreciate cars, specifically Beetles, th...
...containing form data that I need converted into both HTML and PDF. The PDF version should be static, without interactive elements. - The conversion process can be done manually, using HTML and PDF editors, or automatically, for which you can suggest a suitable script or tool. You're also welcome to combine both methods if you believe it would be more efficient. - The HTML output should be easy to read and navigate. The PDF should retain this readability in a static format, making it suitable for printing and viewing but without interactive features. - You will have creative control over how to best represent the JSON form in these two formats. The end goal is to make the content accessible and user-friendly. I'm looking for a professional with prior experien...
I'm seeking a proficient individual to help with a data entry project. I have about 40 URLs, from which I need to extract the product names, prices, and descriptions. The goal is to collate this information in a pre-defined Excel template. Key Aspects: - Extract product names, prices and descriptions from 40 URLs. - Populate an Excel file with the gathered data.
I'm seeking a skilled individual with a strong command of Microsoft Excel and Word. The tasks at hand are primarily data entry, table creation in Excel and development of an instruction manual in Word. Key Responsibilities: - Efficiently perform data entry tasks in Excel. - Create tables in Excel to visually present the data. - Develop an instruction manual in Word. Ideal skills for this project include: - Advanced proficiency in Microsoft Excel, with a strong expertise in data entry and structuring information. - Proficiency in creating tables, and potentially pivot tables. - Strong experience in creating documents in Word, preferably instructional or informative content. - Attention to detail, as accurate data ...
I'm in need of an Excel calendar for 2024 - 2025 that will be used for tracking school days off and special events. The calendar should feature the following: - Ability to add and modify events - Monthly view - Color-coded categories - Dates should be highlighted with background color Ideal skills: - Proficiency in Excel, including knowledge of advanced functions - Experience in creating and customizing calendars - Design proficiency to ensure aesthetic and functional layout Look at the Sample
I'm in need of a virtual assistant to help with a variety of tasks, specifically: data entry, email management, and conducting research. Ideal Skills and Experience: - Proficient in Google Docs and Sheets - Experience in managing email inbox - Can attend video calls and meeting to write MOM with clients I'm looking for someone who can commit to more than 20 hours per week. The ideal candidate should have a basic understanding of Excel or Google Sheets. Your job will be to document data, answer emails effectively, and conduct research on various topics. I am looking for someone who is timely, organized, and detail-oriented. Please reach out if you think you are a good fit for this role.
I have a calculator form that needs some updates made. It allows the user to input measurements for an industrial hose to find out settings for crimping. Current form is here: Need to add an option for the user to calculate with Hose Wall Thickness OR Hose ID & OD. Here is a prototype showing how this will work: measurements for an industrial hose to find out settings for crimping. Current form is here: Need to add an option for the user to calculate with Hose Wall Thickness OR Hose ID & OD. Here is a prototype showing how this will work: New page (needs some jQuery updates): Also have Excel with new formula
I'm seeking a proficient Photoshop expert whose main task would be to remove the background from my high resolution (300 dpi or above) images. Here's what I need: - Remove original background from given photos - Ensure edges are smooth and object in focus remains intact - Optimal adjusting of color and contrast post background removal - Insert a simple placeholder background in the interim The perfect candidate should have skills in Photoshop or similar software, with a strong focus on detail and an impressive portfolio showcasing past projects of a similar nature. Note that the ability to efficiently handle high-resolution images is a must for this project.
One excel file with macro as per the customer requirement
...to create a custom indicator using Pine Script v5 for the TradingView platform. The goal is to develop an indicator based on 3 existing indicators and predefined rules. The source code of all 3 indicators will be provided to the right candidate. The custom indicator should generate trade signals for alerts. Should be able to use this strategy in the Chart, where it should display buy, sell and exit signals. This project requires expertise in Pine Script v5 and a deep understanding of technical analysis principles. My requirement will be as below; 1. Convert 3 indicators into a strategy.(Source code will be provided) 2. Alert Creation. 3. Buy/Sell signal, Trailing SL/Trailing TP integration with alert function. 4. Session End/Start as per the script. 5. Code debug...
