Vlookup column index number cell reference işler

I'm currently in need of a skilled engineer with experience in structural analysis, particularly with steel structures, to help optimize the design of my project. Project involves suggesting furnace column, beams , plates etc sizes as per Australian standard, and material sizes available in Australian market. Key Responsibilities: - Conduct a comprehensive structural analysis of the steel structure - Analyze and interpret the results for optimization recommendations - Make design suggestions based on the analysis - Ensure the structural integrity of the steel structure Ideal Skills: - Proficiency in AutoCAD - Previous experience in structural analysis and design - Knowledge of steel structures - Ability to provide actionable design suggestions based on analysis - Strong anal...

I'm seeking a skilled developer to create a trading bot for me. The bot should be compatible with TradingView and be able to implement multiple trading strategies, including trend following, mean reversion, and breakout. The bot should primarily use moving averages, RSI (Relative Strength Index), and Bollinger Bands as technical indicators. Key responsibilities include: - Developing a bot compatible with TradingView - Implementing the specified trading strategies (trend following, mean reversion, breakout) - Incorporating the key technical indicators (moving average, RSI, Bollinger Bands) into the bot's strategy Ideal Skills and Experience: - Proficiency in TradingView platform - Strong understanding of various trading strategies (trend following, mean reversion, breako...

I have a worldpress site, I want to fully resign the landing page with fully custom...with world "confident" so that I filter out random bids. I will provide text content for image, gif you have to use copyright free assets from internet. Task - Change the menu options and their styling to fit with the landing page - Header and Footer - Landing Page --- Vertical slider of 4 pages, paging enabled. When scroll up and down complete page should change. In left side I want the page number indicator too. Each lider will have different background color and background gif for animation. --- Static section --- Static section with decent animations --- Static section --- Static section My budget for this is limited to INR 15,000 and I need this to be deployed on my worldpress host...

I need an experienced Linux admin who can help me set up a CentOS server to function as a web, database, and file server. The ideal candidate will be familiar with CentOS and have experience configuring a server with multiple services. Key Requirements: - Install and configure CentOS on a server - Set up Nginx as the web server - Configure the server to also function as a database and file s...candidate will be familiar with CentOS and have experience configuring a server with multiple services. Key Requirements: - Install and configure CentOS on a server - Set up Nginx as the web server - Configure the server to also function as a database and file server - Ensure the server is secure and optimized for performance - Provide documentation of the setup and configuration for future refe...

...design requirements. You can use the reference below. I also need to gather information from users, Basic Personal Information: Name Age Gender Weight Height Health and Fitness Goals: Weight loss, gain, or maintenance Specific fitness goals (e.g., muscle gain, endurance) Dietary Preferences and Restrictions: Preferred diet type (e.g., vegetarian, vegan, keto, paleo) Food allergies (e.g., nuts, gluten, dairy) Food intolerances (e.g., lactose intolerance) Favorite foods and foods they dislike Activity Level: Sedentary, lightly active, moderately active, very active, or extremely active Health Information: Any chronic conditions (e.g., diabetes, hypertension) Medications that affect diet or metabolism Current health status Meal Preferences: Number of meals per da...

...brochure and an offer card for our company. The final deliverables should be vibrant, engaging, and align with our brand identity, enhancing our communication and marketing efforts. Scope of Work: Brochure Design Type: 8-page folded brochure Size: 10 cm width x 16 cm height per page Reference: Attached Reference Content: Provided upon project commencement Style: To be in line with our existing brand guidelines (bright, engaging, informative) Offer on Card Design Size: 10.5 cm width x 14.8 cm height Reference: Reference in attached Photo as well Details to Include: Name, position, contact information, and logo Deliverables: Final designs in PDF format Open files in Adobe Illustrator or Photoshop format Skills Required: Proficiency in Adobe Creative Suit...

Hello! I need someone who is an expert in web ...programming with PHP to translate any kind of PDF for free in using PHP. This PDF must not lose its quality. It must remain intact and it must preserve the ORC format, style and all. I want the translation to be exactly like the one from onlinedoctranslator.com. I know you're going to tell me that the Google Translate api isn't free, but you can use this library (link removed) . Then it has to choose the number of pages in the PDF. Even if the PDF is 100 pages or more, it must be able to translate it. It must support encrypted PDFs and PDFs protected by passwords. I will use your code in my site. You can visit it and you'll see that the PDF translation is missing. I've told you everything and I hope you'll gi...

...with existing database: The bot should pull information from our present database to answer user questions. Admin's Dashboard Requirements: - Data visualization: Clear, intuitive graphical representation of data is required. - Data filtering: The dashboard should feature tools for sorting through data effectively. - Registered User Counts: Display the number of registered users on our platform. - Service Booking Record: Display the number of bookings on our platform. Chatbot User Experience: - Quick response time: The chatbot should offer speedy replies to user inquiries. - Friendly and conversational tone: We aim to keep our user interactions enjoyable and casual. - Ability to handle multiple users simultaneously: The system should serve multiple users at the s...

I'm in need of a structural engineer or a person with a relevant background in load-bearing support. The project involves the use of I beam sections, particularly an ISMB-300 beam acting as a column and another ISMB-300 beam acting as a beam. Specific Details: - The ISMB-300 beam will connect to the web of an ISMB-500 column. - The ISMB-300 beam will connect to the flange of the ISMB-500 column. - The connection will be executed by 3 - 20mm diameter bolts. - The I beam sections will be put to use in an industrial environment. - The load anticipated for these I beam sections is a medium load, ranging from 5 to 15 tons. Ideal candidates for this project should have a strong understanding of load-bearing support structures, and experience in designing and impleme...

Description: I am looking for a skilled freelancer to design several web pages (UI) in HTML and CSS (or any other styling framework) for my React project. The work should be developed to be React compatible. The design must closely match a reference website that I will provide. Details: Number of screens: 6 to 7 Budget: Up to $90 (maximum) Deadline: Must be completed within 1 day Requirements: Experience with HTML, CSS, and React Ability to closely replicate the look and feel of the reference website Interested freelancers, please contact me.

I'm looking for someone who is smart and can record some action songs for preschool kids. No previous experience is required. You can just use your phone camera to record the videos. You only have to act/dance based on the songs we provide. You will get the payments for each video song you record. I will provide you with all the reference songs for each video. These are just 3-5 minute long videos and it depends on the rhymes song. Please take a look at the example video (This is just a demo video and the rhymes will be mostly in English.) -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- -------------------- PLEASE NOTE: You must be in SAREE

...given set of stocks from a reliable financial data provider (e.g., Yahoo Finance, Alpha Vantage). Store the data in a suitable format (e.g., CSV files or a database). Data Preprocessing: Clean and preprocess the collected data, handling missing values and ensuring consistent formatting. Calculate necessary technical indicators, such as moving averages (e.g., 50-day, 200-day), Relative Strength Index (RSI), and trading volume. Technical Analysis: Implement functions to identify bullish signals based on technical indicators, such as: Moving Average Crossovers: Detect when a shorter-term moving average crosses above a longer-term moving average (e.g., golden cross). RSI Oversold: Identify stocks with RSI readings below a certain threshold (e.g., 30), indicating potential over...

I'm looking for a skilled developer to duplica...recommendations for improvement. The source code is provided. Key Requirements: - Recreate user input URL evaluation - ACT and WCAG compliance checking - Error highlighting - Recommendation provision Design Changes: - Redesign of the website's layout - Improvements to the user interface Design Preferences: - Clean and minimalist design - Modern and trendy elements The source code is available for reference. Ideal candidates should have a solid understanding of web development, particularly in TypeScript, JavaScript, HTML, CSS, and Python. Experience with accessibility standards, ACT, and WCAG compliance would be highly beneficial. A portfolio showcasing similar projects is preferred. A keen eye for design and user experi...

...facilitate the option to enable users to subscribe to a quarterly payment model. This is a must. 2. Error trapping - must be able to fail a call or function without crashing the app 3. All dates are in dd/mm/yyyy 4. The Search function must work across all prizes not just those currently calling 5. The code must be deposited in our github 6. Apple must accept the update 7. All drafts must use a version number on the front screen which are incremented for each version 8. Must use our new logo (to be supplied) Additional functions - A new section in the app to cover prize stats This section enables users to get finalists to each art prize using the api’s supplied. This includes: 1. Get finalists for a given prize for a given year (using the api 1 or 2) 2. Get winners for a g...

...for website building and design Using 's: Services page template Pricing table template Resources: Blog for company news, industry insights, and thought leadership Case studies and success stories Whitepapers and e-books Integration with for website building and design Using 's: Blog template Resource page template Contact: Contact form and email address Phone number and physical address Social media links (setup and integration with social media accounts) Integration with for website building and design Using 's: Contact page template Social media integration Content Requirements: Marketing material will be rebranded with your company name and colors Content will be organized and structured to align with the website's functionality and

I'm seeking a knowledgeable wri...knowledge. Would be based around the Australian Shed industry, and how to design a well built shed and Tips and advice to save time and money. Key Areas to Focus: - Fundamentals of shed designing. - Specific design tips for each type of shed mentioned. -Needs to be short and simple - Easy to follow instructions and guides for building. Skills and Experience: - I have a book we can use for a reference to what I’m trying to create. -Looking to put my own spin on it with some of my own tips and advice. - Previous experience in writing construction or DIY guides will be preferred. - Ability to explain complex concepts in a simple, easy-to-understand manner. - Knowledge of target demographic is a bonus. - Good project management and ti...

Build an ISO for a raspberry pi (with cellular notecard) to scan for unique cell phones in a specific range and log the unique phone ID and timestamps/ping (distance) from the raspberry pi and store in mysql database using cellular adapter.

I'm seeking a skilled Python developer to optimize an existing codebase used for data analysis. Key Requirements: - Improve the speed of the code: The primary goal of this project is to significantly enhance the algorithm efficiency, thus resulting in a noticeable speed improvement. Ideal Skills and Experience: - Proficient in Python: You should have extensive experience working with P...code is part of this application. - Optimization: You should have a strong background in optimizing code for improved speed and efficiency. Additional Information: - The code is currently functional but is not running at the desired speed, impacting the efficiency of the data analysis process. - You should be able to work independently and effectively communicate any changes made for future ...

...tournaments and teams, organized by date and start time. **Scope:** The schedule should cover the following: 1. England Men 2. England Women 3. England Disability 4. Vitality County Championship 5. Vitality Blast 6. Metro Bank One Day Cup 7. Charlotte Edwards Cup 8. Rachael Heyhoe Flint Trophy 10. The Hundred **Details to Include:** For each match, include the following columns: - Date - Match Number - Teams (Example: Team A vs Team B) - Match Format (Example: T20, ODI, Test, League 100) - International or Domestic - UK Start Time - New Zealand Start Time - Stadium Name - City - Distance from Sidcup, UK (as per the provided Google Maps link) **Instructions:** 1. **Data Entry:** - Gather fixtures from reliable sources such as: - [ECB Official Site]() - [Cricbuzz

Lütfen detayları görmek için Kaydolun ya da Giriş Yapın.

...Features: - Live Streaming: Users should be able to broadcast their lectures in real-time. The app must guarantee steady streaming, with minimal buffering for a seamless experience. - Record and Save: In addition to live streaming, professors should have the option to record their sessions for those who might've missed them. Users should also be able to save the videos on their devices for future reference. - Chat Functionality: There should be an integrated chat system that enables students and professors to interact efficiently. This could include features like Q&A sessions or even offline messages. Ideal Skills: - Experience in Android app development and deployment - Prior experience in developing video streaming applications - Excellent grasp of integrating cha...

I need an experienced Linux admin who can help me set up a CentOS server to function as a web, database, and file server. The ideal candidate will be familiar with CentOS and have experience configuring a server with multiple services. Key Requirements: - Install and configure CentOS on a server - Set up Nginx as the web server - Configure the server to also function as a database and file s...candidate will be familiar with CentOS and have experience configuring a server with multiple services. Key Requirements: - Install and configure CentOS on a server - Set up Nginx as the web server - Configure the server to also function as a database and file server - Ensure the server is secure and optimized for performance - Provide documentation of the setup and configuration for future refe...

...seeking an adept professional to develop a cross-platform app for real estate. Available on iOS, Android, and Web, the app's functionalities must include: - Property Search: An intuitive, user-friendly interface for users to search properties. - Filter options: Users can filter search results based on different criteria. - Saved favorites: Users can bookmark their preferred properties for future reference. The app should also facilitate user interaction with features allowing: - User registration/login: Smooth user registration and login process. - Agent registration/login: Smooth Agent registration and login process. - Property listing details: Detailed information showcased for each property listing on Map. - Contact agent/owner: Messaging feature facilitates communica...

...calculate the total number of jobs done and the total payment owed to each installer. **Requirements:** 1. **Job Tracking:** - Columns for the date each job was completed. - Columns for the job details including customer address and account number. - Columns for the installer assigned to the job. 2. **Payment Calculation:** - Ability to input the payment rate per job. - Automatic calculation of the total number of jobs completed by each installer. - Automatic calculation of the total payment owed to each installer based on the number of jobs completed. 3. **Customer Information:** - Columns for customer name, address, and account number. 4. **Summary:** - A summary section that provides totals for jobs completed and payments...

Just a quick bit of help needed in excel macro writing. See attached before and after showing a piece of the original data. and what i neeed the macro to achieve. WHAT IM ASKING If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplicate row. AEE ATTACHED png. I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency. Essential skills and experience should include: - Expert knowledge of Excel and its macro functionality - Prior experience with data manipulation tasks such as merging cells - Understanding the rules or criteria for merging specificall...

Hello, This is a $20 project. Looking for a freelancer to develop a python script to retrieve restaurant data from Google Maps using the Maps/Places API. The script should target restaurants that have a phone number and *do not* have a website. The inputs I need to enter are: - Location (latitude and longitude) - Search Radius (in meters) - Ensure the business/place is a restaurant, bakery, etc. Key Data to Retrieve, output in a .CSV: - Business Name - Address - Phone Number - Google Maps URL Thank you, trooper501

I need 3 custom-sized coupon designs created. I'll provide you with the specific dimensions. The job is straightforward. I have reference images for the kind of design I'm after. Your task will be to create 3 unique designs based on these references. I'll provide you with the specific dimensions for the coupons, so you won't have to guess the size. Requirements: - Experience in graphic design, particularly in creating coupons - Proficiency in design software - Ability to deliver within 1 hour If you're interested, please share some examples of your previous work in design. This will help me get a sense of your style and experience.

I need a proficient Xactimate expert to generate detailed and professional-looking reports for insurance claims. Key Requirements: - You should have a solid understanding of Xactimate software and experience in creating reports for insurance purposes. - The reports need to be detailed, with itemized costs and descriptions. The ability to include diagrams a...and photos would be highly beneficial. - You will be provided with the necessary information through document and photo uploads, so make sure you can work with these formats. Please note that the quality and accuracy of the reports are crucial, so attention to detail is a must. The ideal candidate should be able to efficiently create a comprehensive report, making it easy to understand and reference for the insurance claim...

I am looking for a professional who can build a web application that automates the creation of Google Sheets formulas. Requirements: - Build a web application that allows me to input a plain text command in a Google Sheets cell (i.e., I type "= find the mean of the data above". - Translate the plain text command into a Google Sheets formula using the ChatGPT API. - Authenticate and send the formula to Google Sheets for execution. Ideal candidate: - Proficient in web application development. - Experience with integrating APIs, particularly ChatGPT. - Familiarity with Google Sheets automation and formula creation. - Strong understanding of user interface design for a seamless user experience.

1) You will help me reach out to recruiters, hiring managers and talent acquistions regarding particular positions 1a) Share the actual job applied to in the spreadsheet so i can reference it if I get contacted.***very important*** 2) Help manage applications 3) Filter job search and apply- (will share details when we speak and if hired) 4) More details will be shared in messaging and a call we will have weekly 5) weekly checkins 6) set up interviews for me via my Calendly 2hr max

... -OSCOLA style should be used. -The size of the assignment must not exceed 3000 words excluding footnotes and bibliography. -Must be submitted in word format only. -Must be saved in your student ID number. Guidance A)Students need to observe the following points in drafting their assignments introduction progression of ideas transition throughout essay leading to a well-developed argument of analysis quantity of research demonstrated conclusion of references provided at the end of the assignment. use of reference style use of quotes to support the argument count B)Writing instructions: : •This should, inter alia, provide a brief about all the issues you wish to discuss in the

...and realistic 3D model. This will help me understand how the final space will look. - Client Presentation: The rendering should be of a quality that I can use it to present my design to clients. It should be professional, detailed, and showcase the key elements of the design concept. - Interior design rendering with pictures of the floors in the shape of a running track, numbered with the track number and the distance traveled on both sides of the escalators, as well as in the floor areas that do not have escalators, showing the percentage of calories burned for each specific distance, and pictures on the walls of information about health, nutrition, and others related to the health facilities of the facility itself. Also, in the middle of the bridge, in the corners, there are gi...

...who can assist me with various design tasks including graphic design, content creation, and reference design. Key Responsibilities: - Branding Materials: The core requirement is to design a captivating post graphic that aligns with my brand's visual identity and messaging. This will need to be compelling, eye-catching, and consistent with the brand's overall tone. - Content Creation: I'm looking for a content creator who can help me craft engaging and relevant content for my brand. The ideal candidate will be able to produce content that resonates with my target audience and effectively communicates the brand's values and offerings. - Reference Design: You will also be responsible for creating reference designs that can be used for future projec...

I'm in need of a 2 to 3 page paper on the subject of continuous improvement specifically focusing on Lean management. It will be submitted as an academic assignment so...on the subject of continuous improvement specifically focusing on Lean management. It will be submitted as an academic assignment so it should be well-researched and articulate. Key aspects of the work include: - Research and write a clear and concise paper on the topic of continuous improvement - Focus on Lean management as the primary methodology - Accurate referencing and inclusion of a reference list Ideal skills and experience: - Strong understanding of Lean management principles - Academic writing experience - Ability to research and synthesize information accurately - Proficiency in citation and ref...

I'm in need of a developer who can create a web-based lottery system for me. The system should be designed to allow anonymous participation,...selection: The system needs to be able to select winners automatically without manual intervention. Ideal Skills and Experience: - Proficiency in web development - Experience in creating lottery systems or similar - Knowledge of automated selection processes This project involves a good amount of logic and system design, so experience in similar projects is highly valued. Your bid should include a reference to your previous work and a proposed timeline for completion. Please get in touch if you're confident in delivering a reliable, scalable, and user-friendly lottery system. PHP an Laravel based system, with admin panel, referal...

I am seeking a skilled designer for a furniture project involving the creation of modern chairs and tables. Key Requirements: - Extensive experience in furniture design. - Proven track record in designing modern style furniture. - Proficiency in working with metal as the primary material. - Ability to share previous project samples as reference. Ideal Skills: - Sound knowledge of the latest trends in furniture design. - Excellent understanding of modern design principles. - Strong experience in working with metal. This is an incredible opportunity for furniture designers interested in modern design and metal work. Please share portfolios or examples of previous work that align closely with the requirements mentioned above.

I have an excel file, need add product categorie on a column - budget 100€

I need a Blazor application, like a teleprompter, that allows users to control the scrolling of text by reading out loud the text. When the user stops reading, the scrolling stops. When the user starts reading again, the text should resume scrolling. It should be specifically designed for web browsers, being compatible with...application should be responsive, efficient, and user-friendly. The successful freelancer should have experience with: - Blazor application development (WebAssembly). - Voice recognition technology - Web compatibility and optimization If you have worked on similar projects, please include details in your proposal. Required Delivery: Visual Studio 2022 solution Blazor WebAssembly Web application Reference:

I'm in need of an experienced professional who can rig my 3D models and adjust some details in need (like texture, number of triangles...) for a game called Zepeto. The price will be 4$ for each model (price is negotiable). Key requirements include: - Expertise in rigging 3D models using Blender If you have a deep understanding of these areas, I'd be happy to discuss the project further with you.

We need logo for our fitness product brand "Styfit" which is a fitness brand, which we are going to lanuch in our e-commerce store I have attached a sample logo for your reference. Need source file with all the fonts and elements. if you have any questions, please dm me. Thank you!

I need a solution that can automatically insert page numbers onto every A4 page in my document at the bottom. Key Requirements: - The system should work with A4 format. - It should be able to insert these page numbers automatically and consistently on every page. - The page numbers should be placed at the bottom of each page. Ideal Freelancer: - Experience working with PDF manipulation and automation. - Proficient in software that can perform automatic page numbering. - Attention to detail in maintaining consistency in design and positioning of the page numbers.

...picture, no stock photos, only unique pictures and contents. We, as a company will help create a lot of these, it's about creating and establishing a great communication flow to archive high-end results, and there are many apps for that. This is a fulltime position for a person with many years of experience landing companies on the "first page". GBP is way more important as a tool than being ranked number one on a laptop, less prospects are using stationary computers by the day, it's plus 85% hand-held devices. You will be given recourses and other team members to work with, but you will be in charge of what needs to be done, how and when. You will be compensated monthly/ hourly. You will also get bonuses for certain milestones. The owner is also willing to ...

I'm seeking a skilled freelancer to help me standardize and improve the formatting of my Google Sheet. The main focus will be on creating consistent cell styles for optimal readability. Specific requirements include: - Implementing a minimalist and clean design theme throughout the sheet - Creating a uniform style for all cells, making sure the data is easy to understand at a glance The ideal candidate will have: - Proficiency in Google Sheets, with a strong understanding of formatting options and best practices - A keen eye for design and the ability to create a clean, minimalist look - Experience with data visualization and turning complex information into easily digestible formats If you're confident in your ability to transform a spreadsheet into a visually appeal...

Storyboard of Rafiki (as discussed text but adding some reference sketch images too)

...Google Mediapipe Pose Detection and has run trained ML models on web application (using JavaScript) The main task will be training the model to recognising the pose and creating a script for data generation from youtube videos. The trained model should work with the web mediapipe library and classify the given pose on a WebApp (JavaScript). (Eg: Push up and Push Down) You can refer this blog for reference: This project requires expertise in machine learning algorithms and techniques, as well as experience with Google Mediapipe and data preprocessing. The successful candidate should have a strong understanding of supervised learning and be able to optimize the model for accurate pose classification using JavaScript. The

I've compiled a comprehensive global leads database with 8 million entries. The database includes a variety of details such as name, email, contact number, website, profession, and even Instagram username. - **Purpose**: This database is specifically designed for sales leads generation. It's meant to help businesses and organizations reach out to potential customers and grow their sales. - **Categorization**: The leads are not just categorized by one specific filter. Instead, they're a mix of different categories from various industries, countries, and professions. This eclectic mix provides a wide range of opportunities for potential buyers. - **Delivery Method**: I'm looking to sell this database through a CSV file, online access to the database, and a Goog...

My goal is to have a complete informational website developed for my business. With a focus on offering key details like: - About Us: A section devoted to explaining our business and its values - Services: A clear and comprehensive listing of all our services - Contact Information: Clear details on how customers can contact us; including phone number, email address, and physical location - Pricing: Transparent pricing information for our services The ideal freelancer for this project should have prior experience in developing informational websites with an easy to navigate user interface. Proficiency in web design and development and a keen eye for detail is necessary. Knowledge of SEO to help maximize the visibility of the website on search engines is also appreciated. Be pre...

I'm seeking a WHMCS module that facilitates direct connection between my .in domain registry and WHMCS. It's built on the Neustar toolkit for registrars. For reference, I've included a link to an existing module developed by another party: I'm looking for a similar module without licensing restrictions and at a more affordable rate than the one listed.

...position with flexible hours. Responsibilities: Source and attract candidates using databases, social media, and other recruitment platforms. Conduct interviews and filter candidates for open positions. Collaborate with hiring managers to understand job requirements and candidate profiles. Create and post job descriptions on relevant job boards. Screen resumes and job applications. Perform reference checks as needed. Provide a positive candidate experience throughout the hiring process. Requirements: Proven work experience as an HR Recruiter or similar role, preferably within the BPO industry. Familiarity with Applicant Tracking Systems (ATS) and resume databases. Strong knowledge of sourcing techniques, including social media and professional networks. Excellent communication...

HI we are looking for Web and mobile app developers for cs cart who can also give some idea. ( using ) Reference is We will add Auction bidding option ( ) I was hoping to see any references you’ve created that is similar to direct-liquidation idea, we want something very similar but with having the auction feature added, which is something already available and offered from CS-Cart Looking to see what would you suggest to make with a similar idea to our reference Buy now and Bid option with payment gateway. multivendor with a bidding system. Ppl can buy or bid based on vendors choice and the system