How to use vlookup to populate cellsJobs
I have purchased a template with 5 different demo home pages and I'm in need of a skilled individual who can consolidate all the elements of these home pages into a single new home page. This consolidated home page will serve as a comprehensive template that I can later edit and populate with my own content. Key Tasks: - Reviewing the 5 different demo home pages - Extracting all the elements from these pages - Implementing these elements into a single new home page These elements would include (but not limited to): - Header - Hero section - Features section I'm looking for a freelancer with: - Prior experience with template customization - Proficiency in frontend development - Good experience with HTML/CSS - Eye for good design and aesthetics Communication duri...
1.I would like no less then 90-100 on-page speed insights for desktop and mobile. 2. Book now Contact form submission under 10 seconds. 3. Receive emails once the booking form has been completed. 4. Check & provide a report that all coding has been done correctly on the website. 5. Fix all errors in the attached GT Metrix report Please provide me with exactly how you will achieve these 5 points as generic messages regarding this job will not be awarded. Payment will be broken up into 3 milestones points 1-2, 3-4, 5 Do not apply if you cannot achieve my work standards.
I'm interested in hosting a contest for a logo design. Here's what I'm after: - A simple, clear, easy to read design. Normal styles preferred: no frills, no abstraction, no complex patterns. - Principles of minimalism can be applied, but the focus should be clear legibility. Designers with a penchant for understandable and simple logos would be the best fit. Please showcase your previous work when bidding. Your creativity and understanding of my requirements will be the key deciding factor for the winner. Looking forward to seeing your amazing designs!
...iPhone application designed to assist users in organizing their financial life. The application allows users to allocate a specific amount of money, which is then distributed on a daily basis. The application charges a 4% fee for facilitating these transactions. This white paper provides an in-depth understanding of the application's architecture, functionality, and its potential impact on the community. It also highlights the importance of security measures to protect user data and ensure the integrity of financial transactions. 1. Introduction: The purpose of this white paper is to introduce a secure iPhone application that aims to empower users in managing their financial life. By providing a platform for organizing and distributing funds, ...
Transformasikan template google sheets saya dari VLOOKUP menjadi Apps Script/VBA
...need an Excel expert to update my spreadsheet. The main tasks include: - **Formulas and Calculations:** I require formulas to be implemented for various calculations. The freelancer should possess a strong understanding of Excel functions and be able to apply them accurately. - **Formatting:** The formatting of the spreadsheet needs to be updated. This includes: - **Font Styles and Sizes:** I need the text in the spreadsheet to be consistent and visually appealing. The freelancer should have a good sense of design and layout. - **Number Formats:** Incorrectly formatted numbers need to be corrected. The freelancer must be meticulous and detail-oriented in this aspect. - **Color Changes for Expired Dates:** An important part of the project...
I need an attorney to create legal documents such as privacy policy, terms of use, and more if necessary for a dating app like Tinder. I am trying to launch in the US. The project is for business use, and please show me previous works working with privacy policies, terms of use, and more if you have done these before. You can benchmark documents that are doing similar service as my app (ie Tinder), but since our app has different capacities and functionalities, you might have to know how my app works to write comprehensive documents, I want this to be done ASAP.
I'm looking for an experienced developer who can create a web-based calendar with a unique feature to allow users to book dates. If a date is unavailable, the application should clearly indicate it. Key Requirements: - The calendar must be web-based and mobile responsive. - There should be a feature to allow date booking. - An excellent visual indication for available and unavailable dates. Ideal Skills and Experience: - Previous experience in web-based application development. - Strong understanding of modern web technologies and responsive design. - Good knowledge of calendar functionality and user-interface design.
I'm looking for an experienced developer who can create a web-based calendar with a unique feature to allow users to book dates. If a date is unavailable, the application should clearly indicate it. Key Requirements: - The calendar must be web-based and mobile responsive. - There should be a feature to allow date booking. - An excellent visual indication for available and unavailable dates. Ideal Skills and Experience: - Previous experience in web-based application development. - Strong understanding of modern web technologies and responsive design. - Good knowledge of calendar functionality and user-interface design.
...looking for a skilled 3D rendering artist to bring to life a mixed-use real estate project. Key Requirements: - The focus of this project will be on the exterior details and the surrounding environment. This means, I'm looking for someone who is proficient in creating realistic and immersive 3D animations. - While I'm aiming for a high level of realism, I'm looking for a semi-realistic aesthetic. I want the renderings to be engaging and visually appealing, without being too abstract or too realistic. - You should have a strong portfolio that demonstrates your capability in 3D renderings for similar projects. Ideal Skills and Experience: - Proficient in 3D rendering software - History of creating high-quality exterior renderings - Experienc...
We are a group of developers. We need a webRTC expert to give us guide and assistance of how to integrate our AI model into the Odoo 16 webRTC. We have already build the AI model, the webservice and endpoint to commnicate with it and everything related to the AI. So far we have a module that connects with our AI server, everytime an odoo channel is created it reviews the messages, sends it to the AI and creates a new message in the channel that acts as a reply To achieve this we follow the next structure: 1) redefine create on 2) send message body to IA 3) get message and post a message on the channel So far this works on internal chats, but we want this to work on live chat sessions, the idea behind this is that the clie...
Hi I need to very basic example on how to call a rest api from Aveva using a put command. It should be build importing .net libs.
Overview: We require the replication of our ...be responsible for creating a duplicate site in the respective language, utilizing a provided template, and customizing it with relevant content. Additionally, SEO optimization with strategically placed keywords is required to enhance search engine visibility. Tasks: -Duplicate or onto and freighttrade.it. -Translate all content into German for [] and Italian for []. -Customize the template to ensure a seamless integration of translated content. -Populate pages with industry-specific keywords to optimize search engine rankings. -Ensure all links, forms, and interactive elements function correctly in the new language versions. Note: The template will be provided by us.
I am seeking an experienced SEO article writer who understands and has a working knowledge of AI systems like Chatgpt and Gemini. Your articles must be original, Google SEO...Requirements & Expectations: - Must have SEO writing experience and a solid understanding of AI systems like Chatgpt and Gemini - Highly creative and capable of creating engaging, informative content to capture readers' attention - Strong research capabilities to support writing original, high-quality articles - Must ensure all articles are indexed by Google Please note that the exact quantity and purpose of the SEO articles are not specified at the moment, it will be discussed with the selected freelancer. Your bid should reflect your rates per article, given they exceed 1,000 words. Looking ...
1. Develop a function that copies specific fields from Account records into corresponding Ticket fields automatically. 2. Develop a function that auto-fills multiple Ticket fields based on the input from a manually entered field. This function should dynamically pull data from the account database and populate the ticket fields according to the values entered. It is important that we have a solution that is directly usable with no modifications needed apart from inserting our specific IDs for fields/modules etc. If your work meets our expectations, we may be interested in an ongoing collaboration for future projects across various Zoho applications (Desk, CRM, Campaigns, Projects).
Want whatsapp chatbot for business use
...in schools and needs a reliable and user-friendly members area on our Wix site to facilitate teacher sign-ups, student class list management, and student attendance tracking. Key Features: - Membership System: Teachers should be able to easily sign up and sign in using an email and password. This will help us ensure that only authorized personnel access the system. - Class List Management: We require a form where teachers can manually add, edit, and delete student names. This will populate the class list and allow for easy management. - Student Attendance Tracking: Our goal is to track daily student participation in our campaign. This can be facilitated by allowing teachers to tick a date in the student's row to indicate they brought plas...
I need my website to not only be understood by English speakers but also be accessible to other languages. Via the Wordpress plugin "TranslatePress", I am seeking an experienced individual who can translate and index my site into 10 additional languages., The translated pages must be index by google for seo. Primarily: - German - Dutch - Arabic - Chinese - Russian
I am in need of an Excel relational database. The database should have the functionality to enter values automatically from an attached worksheet. The entry of these values will be based on specific criteria, more specifically, column values. Required Skills and Experience: - Strong knowledge and proficiency in Excel - Experience in database creation, management, and optimization - Understanding of data entry and data analysis - Proven experience in creating reporting capabilities within Excel. Using the "Reference data" tab, when the value in Column B is entered in the "Example worksheet" the corresponding values should automatically populate - Tariff code, Duty rate, CPF.
python chrom headless script which will visit given list of URLs/websites aftear each config delay in seconds. script will use different ip in each iteration of list urls visit. it will keep running untill ip list end and start from 1 again. You will suggest from where i will buy rotating ip proxies which not blocked by the urls. Purpose of this script. visit given list of urls with different ip proxies. rotating ip proxies will be fine these are example urls: one is this link :
python chrom headless script which will visit given list of URLs/websites aftear each config delay in seconds. script will use different ip in each iteration of list urls visit. it will keep running untill ip list end and start from 1 again. You will suggest from where i will buy rotating ip proxies which not blocked by the urls. Purpose of this script. visit given list of urls with different ip proxies. rotating ip proxies will be fine these are example urls: one is this link :
Thumbnail for my monetized/commercial/personal use YouTube video
...looking for a skilled photographer to capture images of my Elvis impersonator persona wearing two different costumes. This project is specifically aimed at creating a set of promotional materials to advertise my performance services. - I need a total of 6-10 high-quality photos for each costume. - The photoshoot will involve both indoor and outdoor settings. - The final images should be suitable for use across various promotional channels, including online marketing and print materials. Ideal Skills: - Experience with portrait photography, ideally with a focus on capturing performers - Good understanding of lighting and composition for both indoor and outdoor scenes - Ability to create images that are engaging and suitable for promotional use I...
I need you to show me the best software or AI program that can change the voices in my videos. I need the voice changing software to professionally change my voice to a robot, female, old timer, ghost, alien, ghost and other characters. This is not just for a single video; I have a series of videos that will need to undergo this process. You will need to prove to me why the voice changing software is the best and easiest. I will need you to show me why it is the best and easiest to use to professionally change my voice into the character voices I need. You will need to send me screen capture videos of this working with sample voice changing in the character voices I need and how to use...
I'm in need of a skilled Excel expert who can help me build a formula that integrates data across multiple sheets. The formula needs to leverage advanced functions like VLOOKUP, INDEX/MATCH, and ARRAY. Key Requirements: - Advanced Excel proficiency - Expertise in VLOOKUP, INDEX/MATCH, and ARRAY functions - Experience with multiple sheets data integration - Strong problem-solving skills and attention to detail Please note that this isn't a project suited for beginners in Excel. You should have a proven track record in working with complex formulas and integrating data across different sheets. Your ability to deliver accurate and efficient solutions will be greatly valued.
I am struggling with incorrect results when attempting to subtract two values in a column of clock times in Excel. My data is in a 12-hour clock format, and I signify AM and PM directly within the time cells. I require an expert in Excel to address this issue promptly. To take on this project successfully, you should have: - Proficient Excel skills - Solid understanding of the 12-hour time format and functions in Excel - Ability to troubleshoot and rectify the problem quickly
I am looking for a detail-oriented freelancer who has a knack for photography and photo editing. This project requires expertise in - Glare removal - Color correction - Noise reduction on a JPEG photo taken in suboptimal conditions. The aim is to improve this image for personal use, making it as professional and visually pleasing as possible. Proficiency in using editing tools for JPEG images is a must. Photo editing certifications or a portfolio displaying similar works would be an added advantage. Timeliness and high-quality output are of utmost importance for this project.
I'm looking for a skilled O...table extraction from financial scanned PDF Documents. The tables in these documents are complex, often containing merged cells and layouts that are more intricate than standard. Key Requirements: - Proficiency in OCR techniques, especially in relation to table extraction. - Experience working with scanned PDFs. - Ability to efficiently handle tables with merged cells or complex layouts. Your role will involve: - Utilizing OCR software to extract tables from scanned PDFs. - Ensuring the accuracy and completeness of the extracted data. - Solving any issues that may arise from the complexity of the tables. You need to be experienced in OCR and have a keen eye for detail to apply for this role. This is a c...
I'm seeking a proficient programmer to develop a code for programmatically filling forms using data from a JSON file. I don't know the PDF file internals and have encountered issues while attempting to parse fillable fields using Python libraries. The solution should effectively extract data from a JSON file and populate corresponding form fields within a PDF document. Prior experience with PDF manipulation and strong programming skills are essential for this task.
...professional animated video to serve as an explainer. This video should have a How-to guide format, providing clear, concise and engaging directions on a particular topic. Key Details: - Purpose: The video will primarily serve as an explainer for a specific process or concept. - Message: The focus should be on delivering a step-by-step guide for the target audience to follow. - Audience: The video is designed for professionals, so the tone and content should be suited to this demographic. Your Skills: - Prior experience in creating explanatory animated videos is required. - A deep understanding of how-to guide formats and the ability to deliver complex information in a clear, engaging manner. - An understanding of the pro...
...entry skills to assist in transferring text data from digital documents into an excel sheet. The successful candidate should possess: - Reliable accuracy in typing - Fast typing speed (numeric keypad advantageous) - Proficiency in Excel (VLOOKUP, SUMIFS, Pivot Tables, etc.) - Able to interpret written information swiftly - Excellent attention to detail for proofreading entered data. This task will require someone with experience in handling large volumes of data entry, with absolute prioritization on maintaining the integrity and accuracy of the inputted data. Any previous involvement in similar projects handling text data is highly desirable. Understanding of and/or a background in just managing digital document data will be a significant advantage. By...
I'm in need of a talented g...abstract and artistic logo for personal use. Key Requirements: - The logo should be unique and visually striking, embodying a sense of abstract artistry. - The design should be minimalist, with a modern aesthetic, yet with a touch of artistic flair that makes it truly one-of-a-kind. Ideal Skills and Experience: - Proven experience in creating abstract logo designs. - Strong sense of artistry and creativity. - Understanding of the importance of minimalism in modern design. - Ability to deliver a unique, custom design that will stand out. This logo will primarily be used for my personal branding, so it is crucial that it truly reflects my personality and style. I look forward to seeing your portfolios and working with a designer who...
Hi, I'm looking for someone who can write script to automate daily data importing from csv files into a google sheet. We use a new google sheet each week to calculate production for each day, see example here: We have two online platforms that we receive orders through, one for wholesale customers and another for retail customers. For wholesale we use Ordermentum - www.ordermentum.com. To access the production reports we have to: 1. Open the "orders" page 2. Select the relevant delivery date 3. Export the production report for that date This data needs to populate into the relevant date column of the "ORDERMENTUM" tab in the google sheet. See sample production report attached (produc
I need a professional in Photoshop to help me with image retouching for a set of 1-5 personal photos. Key Requirements: - Image Retouching: The photos require retouching which includes basic editing, enhancing the image quality, and making the necessary adjustments to improve the overall appearance. - Experience: A strong portfolio of previous image retouching work, preferably with prior experience in personal photo editing. - Timely Delivery: The project timeline should be reasonable, and I'm looking for someone who can deliver quality work within the agreed-upon deadline. - Communication: Good communication skills are a must. I would like to be updated on the progress of the project and be able to provide feedback when needed. Ideal Skills: - Proficie...
...(References) What are the steps involved in writing the FARE? • Choose an issue that is related to the course theme—AND is important and interesting to you personally. • Choose relevant, credible sources; in most cases, you will build on your previous research in WR 122, but you may need to do additional research and reading. • Review your sources—and think about how they relate to each other. • Plan your essay. What do you want to say about this topic? What essential question will your essay answer? What new insights do you want to share with your readers? • Draft your essay. Construct a strong claim, support it with relevant evidence from your sources, and provide clear reasoning explaining how...
I need a knowledgeable Excel VBA specialist, with a background in data manipulation and analysis, to create a custom macro for my spreadsheet. - The macro's primary function is to automate the creation of new rows based on certain numeric values, namely the ones found in columns E to L on a specific sheet in the workbook. - Upon row creation, data from columns A to D should be copied over to the corresponding new row on another sheet. - Additionally, the macro should automate the assignment of values in cells from L to Q based on the count of numbers in rows created. The assignment of values is to be done using a simple addition or subtraction formula. The ideal freelancer should have solid experience in creating advanced Ex...
I need an individual who can update my website with an array of physical products. Specifically, these will comprise a selection of paintings and prints/posters. This task will require: - Knowledge on how to upload and set up products effectively on my website. - An understanding of art, particularly paintings and prints, as you will need to write accurate and appealing product descriptions. Ideal candidates would have previous experience in eCommerce, particularly with physical art products. An appreciation for art and excellent attention to detail will be essential for this role.
Trace radio base station plot (latitude, length), height tower, azimuth from an excel file to Google earth using Mapinfo
Generate Exe from Python Source Code and How to Backup Files from Pythonanywhere. I need someone who can just put the Icon on the Code of Python and generate the EXE from Python Code and also how to backup all files from PythonAnywhere.
I'm looking to build a live dashboard that will display the results of both the Presidential and Local elections in real-time. Key Requirements: - I need the dashboard to be able to pull data from reliable sources(officials in polling station in an excel form) and refresh the data in real-time. This will facilitate the display of accurate and up-to-date results. - The design of the dashboard should be clean,animated,interactive, intuitive and easy to understand for users. It needs to be able to show data for both elections simultaneously with the help of a switcher between the two pages. - The dashboard should be mobile responsive, so that it can be viewed on various devices with ease. - The security of the data is paramount, so it...
1. Develop a function that copies specific fields from Account records into corresponding Ticket fields automatically. 2. Develop a function that auto-fills multiple Ticket fields based on the input from a manually entered field. This function should dynamically pull data from the account database and populate the ticket fields according to the values entered. If your work meets our expectations, we may be interested in an ongoing collaboration for future projects across various Zoho applications (Desk, CRM, Campaigns, Projects)
I'm in need of a proficient Android app developer who has a strong understanding of Google Sheets API and real-time data integration. App should be able to display rates, track order status, display quote of products and other basic tabs like upload of pdf documents of catalogues, contact us, about us and social media links etc. I have attached a basic pdf document of what the app should look like. Will need UI improvements in it too. Key Responsibilities: - Develop an Android application that dynamically displays data from certain cells in Google Sheets. - The app should be designed to pull updates in real time, refreshing every minute. - It should provide a manual refresh data option for immediate update. Ideal Skills: - Extensive Android app development ...
...Ansys Fluent user to conduct a study on the aerodynamic characteristics of the DrivAer model with the estate-back form: - Mesh independence study of baseline model, using Spaceclaim to prepare geometry and defeature it before meshing. Study must use symmetry to conduct the simulations over half of the body of the car in order to save time and computational costs. - Design of Experiment for a Roof Spoiler: Using three geometric parameters for the shape and position of the spoiler, which will each be tested at three different values (for a total of nine simulations), with the effects of adding the spoiler compared to the baseline model. - Design of Experiment for a Rear Diffuser: Similar to the above, but this time for the purpose of deter...
Hi Azabache Producciones , As previously discussed we'd like th..., As previously discussed we'd like this video edited in a similar style to Matt Starky's :// I have provided a Guide Edit for timings and rough placements. A clean 4K resolution hosted recording - with same timings as the Guide. I've also included all screenshots and stock within the Guide Edit, but am open to you suggestions if you think other images or graphics might be better. Please let me know if there is anything missing. We'd like the design to fit on a page like this https://www.freelancer.com/ai-for-business so tonally and colour wise it should feel like it belongs to this page.
I'm looking for a Jira specialist to help me create a custom automation that will generate a child issue for each paragraph in a parent issue. The child issue should inherit all attributes of the parent issue. Each paragraph in the parent issue will automatically create a separate child issue based on that paragraph. A way for Jira automation to identify a double line break needs to be created. The automation should auto populate all the child issue field with the same attribute as the parent. See attachment for example Key Requirements: - The child issue should be created in Jira Cloud. - The automation should be triggered when a parent issue's description is updated and contains a double line break. - The child issue should mirror all attributes...
...main task will be related to carrying over formulas in both the same sheet and different sheets. Key requirements: - Advanced knowledge and experience in Excel formulas and functions - Proficiency in carrying over formulas across multiple cells and sheets - Ability to efficiently manage and implement complex formulas Your responsibilities will include: - Identifying the most suitable formulas based on specific requirements - Implementing the formulas accurately and ensuring they work correctly - Carrying over these formulas as needed across multiple cells and sheets If you're an Excel guru with a strong background in advanced formulas and functions, and are confident in your ability to handle complex tasks such as carrying over formulas effici...
Thumbnail for my monetized/commercial/personal use YouTube video
