Vlookup column index number cell reference jobs
I'm in need of a proficient 3D designer who can innovate 6 projects (3d art project) the art piece should resemble a theme ( Youth flighting against family and society norms). I have provided a sample of some sculptural art that I think can be a reference to what I expect to have when it comes to quality. I need the 3d art provided to be simple but yet match the above mentioned theme. The art work has to be original the files provided should be .stl files as I can print using a 3d printer Key Skills and Experience: - Expert in 3D art design - Proven creativity in past projects - Mastery of 3D design software I need this project to be done with in a week. deadline 27th of April
I need a professional to perform pre-employment vetting. This should include conducting thorough background checks, drug testing, and making relevant reference checks for potential full-time employees. Key Skills and Experience: - Familiarity with all aspects of HR pre-employment vetting - Reliable techniques for background and drug checks - Proven track record with similar jobs - Excellent communication and reporting skills Unfortunately, I do not have a stipulated timeframe for completion, and am open to discussion in this regard. Therefore, flexibility may be beneficial. However, please bear in mind that quality will be valued over speed in this project.
I'm looking for a talented graphic designer to produce an engaging, sports-themed t-shirt design. The design concept is based around a specific athlete and includes relevant copy. Your role would involve: - Creating an impactful graphical representation of the selected...printing on t-shirts. Skills and Experience: - Proficiency in graphic design software. - Demonstrated experience in creating sharp and entertaining illustrations. - Experience in t-shirt graphics would be a plus. - Excellent communication and interpretive skills to fully understand and align with the project's vision. - Must supply Vector images I would provide reference photos and copy. I need you to put it together. I've attached a reference photo. I want a person drawn in this position and...
I'm interested in ...backdrop. While the architectural magnificence of the building should be captured, the photo should also reflect the vibrant life of the city with elements of street views unique to NYC. Here are some specifics: - The photo needs to be taken during the evening hours. Perhaps capturing the essence of evening lights will add to its charm. **** Lastly, please note this photo is meant to serve as a reference for artistic work, and while it needs to be aesthetically pleasing, it needs to accurately represent the city's streetscape and the Empire State Building. Ideal candidate: - Skilled photographers with expertise in street photography - Prior experience capturing cityscapes during different times of the day and seasons - Strong understanding of ligh...
We sell honey and we need a graphics designer who can create beutiful and eye catching images, product packaging and product detailed. Our Compititor listing for your reference- What I need: 1. Package design, I will provide logo 2. 6 images with graphics that attaract buyer Need high quality and freelancer need to be creative.
...going to be separate for all pages. The header is supposed to be a branch of a tree with the sitelogo on it in the middle. - On a desktop view we want the left side of the screen to have a tree trunk run along on the left till the footer And leaves on the right. - Footer content should include: Column 1: Small kalataru logo and under it social media links Column 2: About us Contact us Careers Kalataru Magazine Column 3: FAQs Returns and exchanges Shipping and Handling Terms of Service Privacy Policy Column 4: Sign up to our email Newsletter (Email ID text box with validation) (Subscribe button) - Integration with payment gateway (phonepe) - Cart and login mechanism should be OTP based and very direct and easy - Collect user data in a proper format (ip, usage...
...Combine live-action and animation seamlessly. A background in both types of video production is highly appreciated. 3. Appeal to an adult target audience. Therefore, a mature and refined style is necessary. Target audience - crypto investors traders Previous work with live action-animation hybrid content and familiarity with adult viewer preferences will suit this project well. All script, video reference points, and documents will be supplied. However, creative input is valued....
I need to manually add text and picture annotations to a PDF document . I have a pdf document but pictures do not show up some places in the document, I have the pictures and need someone to have two columns with the original on the left and add the pictures in a second column on the right of the original document where they should have been inserted . there are about 15 photos that need to be matched up . should not be more than 2 hours . also there are 8 names that need to be inserted wherever they show up in the document .
I need an expert to set up an automation system in Google Sheets for specific data from the NSE India website. Key Requirements: - Data Source: The data source will be '' - Data to be Integrated: Only the column titled '%CHNG IN OI' should be extracted. - Update Frequency: The automation should update the Google Sheets column once every day. - Data Display Format: The data in the Google Sheets should be displayed in percentage values. - Historical Data: No historical data tracking is required. The focus is solely on current updates from the source website. Ideal Skills: - Proficiency in Google Sheets and automation tools. - Experience with web scraping and data extraction. - Knowledge of data presentation and formatting in Google Sheets. - Ability
I need a skilled Flutter developer to create a medical diagnostic app. This app will be used to collect blood cell images or videos. Here are some specific features the app will need: - User authentication - Push notifications - In-app purchases Also, the app should be capable of capturing and storing High-Definition (HD) images or videos. If you're adept with Flutter and have some experience in creating medical or diagnostic apps, your expertise will be highly desirable for this project.
I need a Power BI expert with deep knowledge of DAX query to help me retrieve specific metrics about product...Key Requirements: - Retrieve Product ID, Quantity and Location. - Gather Specific Production Data including the Production number. Ideal Skills: - Proficient in DAX query language - Comprehensive experience with Power BI - Excellent attention to detail - Previous experience in inventory data management will be a plus What to do: I need to get a query in DAX (Power BI) that gives me the same result as what I show in the excel file ( table (column in yellow)). The Excel file was obtained from the attached SQL query ( ) The two screenshots show the Power BI tables. I need to get a new column in Power BI that shows me the results like in the yellow column...
We have an existing logo for our business and now we need a font designed for our business name that will compliment our logo. Looking for something that will look natural with the logo, the shop is greek themed so most likely some style of block lettering. The font my be 100% original. the name of the shop is "The Apollo Tattoo Studio" our logo is attached for reference.
Please Sign Up or Login to see details.
...and blog post templates so that we may add future webpages. 6 Pages and a Blog * Homepage: Main landing page * Job Board (leverages WP Job Openings plugin) * 4 subpages: 1 for each of our services 1. Employers seeking permanent placement candidates 2. Companies seeking consultants 3. Executive Search 4. Job Seekers * Blog page * Standard blog functionality * Acts as an index * Can add blog posts via Wordpress * Searchable by date, keyword, category, etc. The menu will include links for the homepage, “Our Services,” Job Board page and blog page. The 4 subpages will be linked in a submenu under the “Our Services” heading. The blog menu entry can be removed from the menu so as not to be accessed until I choose to turn it on. ...
I'm on the lookout for a skilled graphic designer who can craft a modern, sophisticated logo for my men's bespoke tailoring business. The design should encapsulate a sense of simplicity and sophistication. Key Points: I have Attached One Reference Logo with this post, Exactly I need the same logo with my Preference. ( Actually that Attachment logo indicate Bow and wood texture but I need Bow and Weaving or Thread like texture) *Should indicate any Tailor thing like ( BOW-TIE) *Should looks like Fabric weaving design inside the Logo *MENSPOKE font should be clear and Readable should be Unique. *For Shirt branding like Pocket Embroidery also it should looks good and visible.
...web design to ensure the app is accessible across various devices. - Experience with building secure authentication and user profile systems. - Capability to integrate payment systems for subscription management. Objective: To create a unique digital experience that combines traditional tarot readings with modern technology, providing users with insightful, personalized readings. Inspiration Reference: For an understanding of the visual and functional expectations, please refer to this video: which outlines similar WebGL implementations in web applications. Project Deliverables: - Complete source code of the application. - Documentation detailing the setup and configuration of the app. Timeline: Please provide an estimated timeline for completion
...This new logo will be used on our website and on our social media platforms, making it essential to be visually effective in both large and small formats. Specific Requirements: Colors: The design must incorporate the color palette of the current logo. Design: The design should be original and clearly differentiate from our current logo and from free online examples which I will attach for reference. These examples are just to indicate styles or elements we like, but the final design must be unique. Adaptability: The logo should be easily adaptable for use in digital formats (such as website headers and social media profiles) as well as printed materials. About Us: We are Cubaherald, an online newspaper dedicated to covering relevant news from Cuba, Spain, and the United States...
I am looking for a Flutter developer to create a comprehensive PDF package. - The package should include functionality for: 1.) PDF encryption and decryption 2.) PDF compression 3.) Splitting PDF into multiple PDFs 4.) Merging multiple PDFs 5.) Wat...Add page no. to the PDF 8.) Change PDF page size IMPORTANT: Do not use any underlying technology which requires AGPL-3.0 license or any other license which asks for fees for commercial use. Platform Support: - The Flutter package should be able to work seamlessly across both iOS and Android platforms. Exhaustive documentation will be required for the package. Example flutter package (for reference only): Payments will be done in phases after completion of each feature and it's related documentation.
I'm seeking an experienced professional in WordPress site optimization to enhance my website's page speed. My target is a score of 70+ and a speed index below 2 seconds for the whole site. Key tasks include: - Run a thorough audit of the website to pinpoint speed issues. - Implement the necessary changes to optimize page speed. Skills and expertise required: - Proficiency in WordPress platform. - Deep understanding of website performance optimization. - Ability to perform a detailed audit and execute the needed changes. - Proven track record in achieving 70+ page speed scores and sub-2s speed index. I'm looking to get this project completed as soon as possible. If you have the skills and availability to deliver fast results, please get in touch.
I have an AutoCAD DWG file for an urban design project. I'm looking for a 3D modeller to create a block model 3D representation of the design. Key Det...bus-stop etc. - The 3D model does not need to have textures or colors. Ideal Skills and Experience: - Proficiency in AutoCAD and 3D modelling software. - Previous experience with architecture projects. - Ability to work with medium level of detail, staying faithful to the design's overall intent. - An understanding of spatial analysis in urban design would be beneficial. I have attached 2 reference images. These will be the final output which I will further detail out on Photoshop, for that I need the base model. If you're confident in your 3D modelling skills and have experience in similar projects, I'd lov...
...platform is run by BuddyBoss Platform and theme,, web and mobile app (Ios and Android). We need to connect job seekers and employers with the role in BuddyBoss. Primary tasks that require automation include ensuring seamless flow from subscription purchase, powered by WP Job Manager and SureCart, to Automation powered by SureTriggers. This project requires a high degree of compatibility with a number of platforms and tools. Our key operating platforms are WordPress, BuddyBoss, Learndash, Bookly, Gamipress, SureCart, and SureTriggers. Additional integration with WP Job Manager, Artificial Intelligence, and AST is also necessary. PLEASE TELL US YOUT EXPERIENCE AND LINKS TO PROJECTS FOR THESE PLUGINS. Ideal candidates for this project should possess: - Strong experience with ...
I'm looking for a professional videographer and editor to create a stylish and informative video primarily for marketing purposes. This video will be targeted at businesses, not the general public, and should convey a strong, concise message. Ideal Skills and Experience: - Proficiency in video editing software - Prior experience in creating...and our target audience. From there, you'll use your creative freedom and expertise to produce a video that is not only aesthetically pleasing but also serves its purpose as a powerful marketing tool. Please reply with your portfolio showcasing your previous B2B work or similar projects you have undertaken in the past. Take this below link as a reference for the same
...out how to make the cell below change to the same color as the option selected and the date it was selected appear in the same cell. I need to include the date the option was selected selected and because you can't have two formulas in conditional formatting. I thought making a cell in the below row for the date was the only option - any other options to achieve this? Column A, Row 3 contains Client Name (code), Columns B-K, Row 3 contains the course 14 x units. Column A, Rows, 5 - 19 contains student names. The cells in Columns B-N, Row 5 will include the submission options with a drop down menu or alternatively. The 5 different grading options are: Not yet started Not yet submitted Submitted for marking Partially Complete - More work to su...
I need a basic web application for maintaining an efficient inventory of automotive spares. The key elements to be tracked include the part number, description, supplier information, purchaser details, condition, make, model etc. In the current scheme, we anticipate less than 100 spares in our inventory system. This is a very basic php/mysql application. I have created a rough up of the requirements using MS Access. I anticipate that the application will have; 4-8 tables. Main tables are - Contacts - Parts - Events 6-10 pages - Search Parts based on any field. - Search contacts - View/Create Contact with image upload - View/Create part with Image Upload and ability to print label - Create event associated with Part - Show all events related to part. Application needs to im...
I'm looking for a professional programmer, proficient in Python to craft a script. This script is for the main purpose of finding mobile numbers, identifying their carrier, and matching this informatio...identifying their carrier, and matching this information with corresponding zip codes. This process is vital for my verification purposes. Not only this, but your script must provide these details in a CSV file output format. Key requirements are: - Extensive knowledge and experience in Python - Experience in number location and carrier identification script writing is a plus - Knowledge of data presentation in CSV format This task requires high attention to detail and a strong understanding of number location matching technology. If you meet this description, I'...
...rebuild is cost effective. The opencart system we use has been added and modified over time, hence it is not possible to simply upgrade to a newer opencart version. The business we operate in is parts for coal and wood fires, this is a business that is reducing overtime, due to environment issues, however, the stove market has recently had a mini boom due to gas prices being high with a record number of new stoves being sold over the last 3 years (we do not sell new stoves, just the parts for these stoves). We expect to see at least another 5 years from this business. We have been told by our current developers we should look at a google shopping program, however, we are concerned the margins are not in the products to compete in this market. We believe there is another way ...
I'm in need of a specialist to assist with a project focused on channel estimation with Non-Orthogonal Multiple Access (NOMA) in cell-free massive MIMO wireless networks. Primary Project Goals: - The main aim is to improve channel estimation with NOMA. - A crucial aspect of this project involves boosting the Signal-to-interference-plus-noise ratio (SINR). Specific Requirements: The ideal freelancer should have significant experience in wireless communication and a good understanding of MIMO networks and NOMA. Any proposed solution should be geared towards enhancing network performance, enhancing channel reliability, and reducing interference. Desired Skills and Expertise: - MIMO Wireless Networks - Non-Orthogonal Multiple Access (NOMA) - Wireless Communication - Channe...
I need to edit a less than 15-20 minutes comedy show with a strict deadline of 24 hours for 1k INR. Do a minute sample and do your entry. Reference: Raw footage: Key Requirements: - Trimming and rearranging clips - Enhancing audio quality - Bit Animation Final out should convey fun well. There’s two camera angles try and switch it up, Keep background music and lower it slightly, get close ups of facial expressions when something really happening, closer when the ladies are trying the forfeits, level out the voices a bit more, other than that it’s good. just needs polishing. Sound effects shouldn't overpowers the voices.
I need to edit a less than 15-20 minutes comedy show with a strict deadline of 24 hours for 1k INR. Do a minute sample and do your entry. Reference: Raw footage: Key Requirements: - Trimming and rearranging clips - Enhancing audio quality - Bit Animation Final out should convey fun well. There’s two camera angles try and switch it up, Keep background music and lower it slightly, get close ups of facial expressions when something really happening, closer when the ladies are trying the forfeits, level out the voices a bit more, other than that it’s good. just needs polishing. Sound effects shouldn't overpowers the voices.
I'm looking to have a tool developed that can analyze biological microscopy images, specifically with features such as color segmentation, edge detection, and cell counting. The tool should also support universal data import and corrections of alignment and image rotation. Ideal candidates for this project should have: - Strong proficiency in Python and Java - Previous experience with image analysis and microscopy imaging - Fiji, Maven, Eclipse preferred - Bio-formats - Would be great if you have experience in setting up a Fiji plugin (post your work)
- german language - on homepage there will be a simple price calculator (will provide relevant data) - clear design - responsive 100% - homepage + 6 subpages (one of them contact page with contact form) - will provide 5 reference sites
The draft literature review will be assessed on how well you address the following criteria: Relevant choice of four (4) journal articles related to the topic of the qualitative study - factors affecting hotel customer satisfaction. Correct use of APA7 Referencing both in-text and in the reference list Clearly and succinctly explaining the content of the article and key findings within the word count of 500-600 words (excluding the reference list) Ability to compare and contrast the four (4) journal articles (published no earlier than 2012) Ability to accurately identify any limitations of each study/paper (within the journal articles) Must use 12 font, Times New Roman, 1.5 spacing.
I'm seeking a skilled graphic designer to create a modern and clean design for a standard size envelope. It will be primarily used for business correspondence, hence, should convey a professional image. The design should be cogent, elegant yet minimalist. Key considerations: - Design should be unique, communicating business professionalism. -...without compromising on quality. Design Preferences: Colors: We prefer shades of blue (but feel free to get creative!). Design Elements: We envision a modern, sleek, and tech-inspired design. Consider incorporating subtle circuit patterns or binary code motifs. Content to Include on the Envelope: Company logo Company Name Address Phone Email We are attaching our letterhead & visiting card as reference. Need design similar to tho...
I am looking for a freelancer who can solve errors in our WebSocket functionality using JavaScript and the framework. The project requires the WebSocket to be implemented on both the client side and server side. We want it for multiple users. We already have it for one user. I am attaching the relevant screenshot too for your reference. Ideal skills and experience: - Strong knowledge of JavaScript programming language - Experience with framework - Familiarity with both client-side and server-side websocket implementation
I'm in need of an AWS specialist with considerable proficiency in deploying Node.js projects, specifically APIs, on an Ubuntu-operated Free Tier EC2 instance and utilizing S3. Key Responsibilities: - Establish my Node.js API on an AWS EC2 Ubuntu instance. - Incorporate S3 for storage functions. Ideal Skill...instance. - Incorporate S3 for storage functions. Ideal Skills and Experience: - Broad experience in AWS services, specifically EC2 and S3. - Strong understanding of Node.js and API deployment. - Proficiency in working with Ubuntu systems. Bids from freelancers with considerable history in similar tasks will be prioritized. Please include examples of your relevant work in your proposal for reference. Looking forward to collaborating with you. Note: Have to Deploy th...
I am looking for a skilled male voice-over artist who can breathe life into an translation of Quranic duas with a friendly and casual narration in Assamese. In this project, it’s important to make the video engaging, enjoyable, and easy to un...project, it’s important to make the video engaging, enjoyable, and easy to understand. Ideal Skills: - Proficiency in Assamese - Use of words used in regular communication - Capability to deliver a friendly and casual style - Commitment to prompt and precise communication This job requires clear articulation without sounding overly formal. Reading Arabic text is required to quote the reference. reading from transliteration will also importantly, the chosen freelancer must be reliable, responsive, and deliver high-quality ...
...of Work: Small Residential House (12 sqm) - I require a complete set of drawings (facade, plan, and section) for a small 18 square meter residential house. Reference images with dimensions are available. L-Shaped Small Residential House (65 sqm) - This task involves creating architectural drawings for a 65 square meter residential house in an L-shape. I will provide images with handwritten dimensions for guidance. Covered Outdoor Seating Area (24 sqm) - Drawings are needed for an outdoor seating area with a roof, covering 24 square meters. Photographs with dimensions of a similar existing structure are available to use as a reference. Additional Covered Outdoor Seating Area (24 sqm) - Similar to item 3, this involves creating architectural drawings for another 24 squar...
...company offers digital marketing services, primarily search engine optimisation (SEO). I am looking for a new logo. I am attaching the current logo, the new logo may look completely different. The colours of our corporate design are: o #082B42 (background) o #B1D2C8 (background/font) o #C400FF (striking) o #9F3434 (focus 1) o #02746D (focus 2) The logo should not contain any text. The number "3" could be an inspiration, as we present 3 basic USPs. However, this is not mandatory. I am open to the style direction. The logo must be clearly visible against both a light (white) and a dark background. I need it as a PNG file with a transparent background. Important: Of course, the logo must be absolutely unique and all rights to it must be retained. All s...
I am seeking a talented developer to create a software that can interact with Interactive Brokers and TastyTrade for index based options trading. This project will require strong skills in both Python and Java, as well as a deep understanding of trading algorithms and experience with real-time data streaming. The software should be capable of the following: - Real-time data streaming: The software will need to retrieve and process real-time market data for accurate decision making. - Order placement: The software will need to execute buy and sell orders based on pre-defined algorithms. - Technical indicators: The software should be able to use popular technical indicators to inform its trading decisions. Your experience in algorithmic trading software development, use of Interacti...
I need assistance with extracting data from PDF files into Excel. The task involves: 1. Converting PDF to Excel: Use Adobe Pro to convert tabular data from PDFs into Excel. You can use cracked version to do this. 2. Formatting: The existing tables mostly match the required format but will need adjustments a. Remove unnecessary columns and rows and map the right column names. b. Convert hierarchical data to a flat format. There are 200 PDF files (10 of which have been already done but you can verify them as well), each averaging 4-5 pages (many files have 1-2 pages but there are some with more than 20 pages, averaging to around 4-5 pages per pdf) Here is a google doc that contains references of the pdfs and the expected excel format:
I'm in need of assistance with certain advanced functionality in Excel. My project heavily depends on modifying complex Excel files and requires a specialist with a strong grip on: - Formulas and functions: Ability to apply and manipulate these is critical. - Statistical Functions: Will be used extensively, so expertise in this subset is necessary. - Lookup & Reference Functions: Another function set that the project necessitates. I'm looking for someone with remarkable ability to use these features to streamline data analysis and visualization. The completion timeline for this project is within the next month. Proven proficiency in Excel and the capacity to adhere to the given timeline is mandatory.
Looking immediately for someone with experience submitting to Sam gov to write, prepare, research and win contracts off Sam gov. The focus is on the food industry, so you should have experience or at lest know how to procure this information regarding food related bids. When I say food this is in reference to food services. A huge focus is being able to seek the price guidelines for food service based bids. You must be able to secure past price information submitted by incumbents.
I need an Excel expert to perform a specific data analysis task for me. - The job involves conducting an analysis where two cells are fed values from 1-100. - The task is to find the highest value in a third cell, based on the values of the first two cells. - The values in the two initial cells should be generated using a combination of user input and random generation. Ideal skills and experience for this job include: - Proficiency in advanced Excel functions, particularly those related to data analysis and cell value calculations. - Experience with probability, permutation, and combination would be a plus. - A strong understanding of statistical analysis and data interpretation. This project would be perfect for someone who is detail-oriented, skilled in Excel, and has ...
I'm in need of a software that can help create rain effect videos from a small number of images. The primary purpose of this video software will be to create brand promotion content. Key requirements: - The software should be able to generate realistic rain effect videos from images. - The output should be high-quality and suitable for promotional purposes. - It needs to be user-friendly and easy to operate as I have a tight deadline. The ideal candidate for this project should have experience in video editing, software development, and have an understanding of visual effects. A quick turnaround time is highly preferred as I need this project completed ASAP.
I'm in need of a Laravel expert who can help me with both front-end and back-end development. Key Responsibilities: - Frontend Development: The candidate should be able to translate my design and wireframes into a functional and user-frien...Required: - Proven experience in Laravel development is a must. - Proficiency in both frontend and backend Laravel development. - Strong experience in translating design and wireframes into responsive and interactive interfaces. - Understanding of best coding practices and optimization techniques. - Ability to work independently and meet deadlines. We can provide the design and wireframes as a reference for the development. I'm looking forward to working with a Laravel expert who can contribute to the project's success with th...
WATCH THE END IF YOU WANT TO STAND OUT I need a video editor for my 15 minutes vlogs channel, two videos per week. I don't have a reference style so I would like you to let your creativity run wild, I want something dynamic but mainly visually appealing. IF YOU WANT TO STAND OUT FROM THE REST SHOW ME YOUR PORTFOLIO.
...ages-python Need simple process (like click action button and select file with image urls) to extract numeric digits TEXT_DETECTION on JPG images hosted on cloud server using API. ATTACHED: - Sample of image from url and what is required to be extracted. - Data under green header is to be extracted from jpeg file name in image urls - Digits extracted from google vision api to be put under column with header "Google Extracted Text" REQUIREMENTS: - Your relevant experience with Google Vision API or similar text extraction APIs. - Your proposed approach for implementing the extraction process. - A sample of the API usage and extraction results. - Your estimated timeline and cost for completing the project. ******Please note that applications without a sample of API...
ARCA means new beginnings. The A is very important to stand out. I am looking for more creativity using the attachments as a reference. One idea could be For the logo to be the letter A . The letter A can be of a thicker size, please post different options. It could include a wave in the middle with the colors described? This is just an idea. Key Points: - Company Name: ARCA Marketing - Color Scheme: Purple (Transformation), Blue (ARCA going through a storm of chaos, new beginnings) - Design Style: Artistic, Creativity, Friiendly, App friendly Attaching some current logos as Ideas. Thank you
I require a proficient artist to modify a currently cartoon styled character into a doodles style and vector art representation. I'm keen on a fresh and distinctive look, with careful improvements to: Attached is our Orignal Logo of CAT and we want the exact same CAT in the reference stlye art - Body Proportions: Pay extra attention to maintaining accurate proportions throughout the redesigned character. If you have strong experience in both doodles and vector art style character illustrations, you are the ideal freelancer for this project! A keen eye for detail, creativity, and the expertise to respectfully evolve an existing design are necessary for success in this task.
