How to vlookup and return multiple corresponding values vertically in excel jobs
I'm looking for a skilled professional to set up a Virtual Box on my dedicated server, running Windows OS. The primary function of this setup is to have multiple virtual terminals of Windows operational. Key requirements: - Installation of Virtual Box on a dedicated server - Configuration for simultaneous operation of 5 virtual terminals of Windows Ideal skills and experience: - Proficiency in Virtual Box and working with dedicated servers - Strong knowledge and experience in setting up and configuring Windows OS - Ability to ensure smooth and efficient operation of multiple virtual terminals
business profit loss reporting excel(Jan, Feb & March)
...of an upcoming web application, I am in need of a professional UI designer who can develop an illustrative interface for my platform. Key responsibilities will include: - Designing a distinctive, illustrative UI that is both engaging and user-friendly - Implementing design principles which align with the functionality of the application - Ensuring that the design appeals to the platform's target market Ideal candidates should have: - Proven experience in designing interfaces for web applications - Demonstrated proficiency in creating illustrative UI designs - Solid understanding of user-centered design principles Description: Under this project 1) You have to create home page - header with menu navs (parallax effect) to...
I'm in immediate need of a Solidworks expert to assist with multiple tasks related to creating and manipulating sheet metal panel drawings. The work will primarily involve: - Creating 3D models from 2D drawings - Making modifications to these models - Generating flat patterns needed for manufacturing - Setting up configurations and global variances for sizes, materials, and thicknesses Moreover, the final goal is to establish a DriveWorks automation project. I'm looking for someone to ensure it encompasses: - A customizable user interface for parameter input - The ability to automatically generate reports or documentation I need this project to be completed as soon as possible. Ideal candid...
-The Excel workbook should comprise multiple worksheets showing the models, the regression analysis summary, the comparison of model performance, the decision tree, and the calculations you used to answer the task questions that require you to complete in Excel USING SOLVER. -report should be mainly for the economic order quantity (EOQ) analysis and the answers to the qualitative questions. No introduction -1900 word report -There should be at least FOUR worksheets in the Excel workbook. Two of them should show the following two demand forecasting methods that you are required to use to forecast the demand of 5 kg ice bags at Caltex, a petrol station in Melbourne. 1. Moving average 2. Static...
I'm seeking an experienced data extraction specialist to scrape both HTML and text files for specific data. Particulars to look for will involve the text content within these files that follows a mixed format structure so would require vast knowledge and understanding of both table format data and paragraph-style data. Key Skills and Experience Required: - Strong abilities in web scraping - Adept with HTML, text parsing - Knowledge of data formats and how to transform data - Proficient in CSV file generation. We need a comprehensive extraction that maintains the integrity and accuracy of the data. As these files do come in multiple formats, versatility and attention to ...
I'm in the process of developing a new platform and need help with the design and user interface. The main goal is to create an engaging and intuitive experience for users. The target audience will include a wide range of people, and I want to ensure the design appeals to a broad demographic. I need 2 quotations. 1. UI/UX 2. Cost of Development Ideal Skills and Experience: - Proficiency in UI/UX design - Experience in designing for multiple platforms (web and mobile) - Ability to create engaging and intuitive user experiences - Understanding of design principles and best practices - Familiarity with designing for a wide range of target audiences
...enterprise and on the lookout for a skilled IT professional to help bring a variety of projects to life. The scope is broad, encompassing possible website development, software creation, or app building initiatives. **Initial Requirements:** conversion and enhancement of a Codeigniter-based website to WordPress. DNS Security configuration. Addition of webpages, design and functionality as per a chosen template. - **Past Work:** Showcase similar projects you've spearheaded or contributed to significantly. Links or a portfolio will be highly beneficial. - **Experience Level:** I'm targeting someone with an intermediate level of experience. You should have a solid track record and be comfortable tackling the complexities...
...working in the unclaimed funds sector, I'm seeking a seasoned cold calling and appointment setting professional. Your main responsibility will be to contact individuals based in North America to assist them in the recovery of unclaimed funds. Here's a bit more about what I'm looking for: * Extensive experience in cold calling, preferably in the unclaimed funds or similar financial sector. * Familiarity with the North American market, and understanding the nuances involved in setting appointments in this region. * Excellent communication and rapport-building skills. * Experience in dealing with individuals rather than businesses. * Highly organized and able to manage ...
I'm in need of a Java developer with expertise in debugging issues related to reading and updating properties files in a runtime environment. Key Requirements: - Your primary task will be to troubleshoot why my application, which updates the properties file during runtime, fails to reflect the updated values when reading. - The updated properties should ideally be reflected periodically within the application. - The purpose of updating the properties file is to store user preferences. The ideal candidate should have: - Proficient experience in Java programming. - Strong understanding of how to work with properties files. - Proven skills in debugging and troubleshooting. It's impor...
Please Sign Up or Login to see details.
I'm in need of a skilled WP Job Manager/Smyles Plugin expert to make some changes and additions to both the back-end and front-end of my website. The primary focus of this project is to modify the back-end using the Smyles Plugin. Key requirements: - Expertise in WP Job Manager/Smyles Plugin: You should have proven experience with these plugins and be able to implement the necessary changes competently. - Back-end Development: You will be tasked with adding new search criteria and fields to the back-end using the Smyles Plugin. - Attention to Detail: It's important that the changes you make are seamless and do not disrupt the existing functionality of the site. Your main responsibilities ...
I am looking for a skilled and creative logo designer who can help to create a unique logo for my brand identity, as well as potentially assist in its integration into my future website design. Key Requirements: - Brand Identity: The logo should be a reflection of my business, its values and what it stands for. It should be easily recognizable and memorable. - Web Design Integration: While the focus is on the logo, I'm also interested in discussing how it could be integrated into the look and feel of my website. If you have web design skills, this could be a plus. Style & Color: - Style: As I'm not clear on the differences between minimalist, vintage, and modern styles, I'm open to your sugge...
...assistance to improve my Excel workbook used for estimates and bids. The ideal candidate for this task should have: - Top-notch Excel skills, specifically understanding VLOOKUP functions and formulas for summing totals. - Experience in creating automatic calculations to streamline my estimation process. - A knack for designing and customizing Excel templates. - A solid understanding of construction or a similar industry would be a huge plus. Specific tasks include: - Building automated calculations for summing totals and utilizing VLOOKUP functions. - Customizing Excel templates, specifically for the cover sheet, project details sheet, and bid summary sheet. Approach this task with a...
I'm looking for an expert who can put together a precise and comprehensive multifamily proforma that focuses on cash flow details. Specifics Required: - Include data on net operating income, debt service, and cash on cash return. - An in-depth monthly breakdown of these values. Skills & Experience: - Proven track record in financial analysis, specifically real estate and multifamily property market. - Professional approach with strong attention to detail. - High-level proficiency in using proforma software or Excel. - Understanding of the specifics of rental property cash flows.
I am actively seeking 50 dedicated women to assist with part-time digital marketing on Facebook and Instagram. Ideal candidates are those with: -No skills required - 10th pass can also apply - work from home opportunity - Training and guidance will be provided This is an exclusive opportunity for women only. If you're looking to excel in a digital marketing role, please place your bid.
I'm looking to source voiceover work from 4 different talents, spanning both male and female voices. The aim is to have a diverse pool of vocal talents for a 1 minute ad. Pry 30 seconds of total voiceover work is needed and needs to be layered on top of a video. Key Requirements: - Diverse gender representation: Both male and female voices are needed. - Accents and Languages: All selections should be in American English. - Age Range: I require a mix of voices representing both Youth (under 18) and Adult (18-64) age groups. Ideal Skills and Experience: - Professional Voice Actors: Experience in voice acting, with a range of vocal styles and inflections, is a must. - Variety in Portfolio: A div...
I'm looking for a skilled social media sc...for a skilled social media scheduler who can manage and schedule posts on Facebook, Instagram, Youtube, and Tiktok. Key Requirements: - Must be proficient at scheduling posts on Facebook, Instagram, Youtube, and Tiktok. - I will provide the posts, reels and shorts. - You schedule, edit titles, captions, etc. This role would suit someone with social media experience who is particularly adept at scheduling content and managing multiple platforms. The key focus will be on efficiency and consistency in posting the provided text content at the optimal times across all platforms. These are Christian Channels (two). We will start with one and grow. Bonus: Since we are dealing with t...
The WhatsApp bot contains two services: one for subscribers and one for the general public. For the general public: 1. When a sender sends any message, number, or letter, the bot greets them and requests input of a code or menu name (there are 200 codes or menu names available). 2. If the input is incorrect, the bot asks the sender to resend the correct code, send an image containing all the codes, or return to the main menu. 3. If the code is entered correctly, the bot displays general information in text form taken from a Google Sheet. Along with this information, a menu is displayed: • PDF file extracted from Google Drive or a folder • Image • Information in text form taken from a Google Sheet • Input another code &bul...
I am seeking an expert in machine learning and computer vision who can craft an advanced object detection algorithm. This algorithm will be employed in outdoor settings and must have the capability to accurately identify vehicles, animals, and pedestrians. Essential Skills and Experience: - Expertise in Machine Learning and Computer Vision - Understanding of outdoor environments and their varied conditions - Prior experience in developing object detection algorithms - Familiarity with vehicles, animals, and pedestrian detection The goal is to devise an algorithm that can track and distinguish between multiple objects in outdoor scenes with different weather, light, and...
I am making a GANTT chart and need to make it highlighted. the chart is created using highlight formula instead of using basic insert chart option. I need help to do a part of it. Video explanation of the problem: Excel file I am working on is attached: The ideal chart should look like the attached image: Looking for the cheapest service as this is almost done.
I am looking for a talented developer to help me implement a comprehensive quiz management system for my personal project. Key requirements include: - Ability to manage multiple choice, true or false, and open-ended quizzes - Provide access to these quizzes through both a website and a mobile application - Incorporate user account management for both quiz administration and participation Skills and experience in the following areas are essential: - Full stack development - Proficiency in developing both web and mobile applications - Previous experience with managing and implementing complex systems with multiple user roles The successful candidate should be able to deliver a high quality, ...
I need a small application prototype with the following features: Multi-Employer Job Portal/Admin app (Role Based access) User/applicant App (for Multiple applications to different employers) User Profile Document Upload (Save documents to Db and attachments to Blob Storage ) Send Emails to Employers and applicants back and forth 2 Apps in total ie. admin app and applicant app. job application requirements will be provided. Nodejs, angular, My SQL, ORM, Data Seeding, Migrations should be used.
...need an Angular expert who can assist me in creating an consolidated CV platform. The utility should include: - Personal Information Section: Capturing Full Name, a compelling Personal Summary, and pertinent Contact Information including Phone number, Email address, and Home address. Requirements: - Extensive experience with Angular - Proficient in Front-end development - Attention to detail for aesthetically pleasing platform - Excellent grasp of information organization and UI/UX design principles. The end product should be user-friendly, visually appealing and fully functional with the capacity to capture all the necessary details. Implement an online CV The site will consists of 2 parts: user area As a user I can view ...
I'm seeking a highly experienced web and app developer to create a top-tier informational website and corresponding Android and IOS applications. Key Functionalities: - The website and applications should be rich in features to provide a seamless browsing experience for the users. - I require a blog section that is easy to navigate and manage. - A robust contact form that seamlessly connects to my email system. - A subscription option for users to stay updated with the latest information. Page Estimation: I anticipate the website to have between 5-10 pages. Ideal Skills and Experience: - Proficiency in website and application development for both Android and IO...
...for an experienced professional who can create a custom Microsoft Excel spreadsheet for me. This spreadsheet will be designed to generate GUIDs (Globally Unique Identifiers) in a random fashion. The GUIDs will be used for database record identification. Key Requirements: - Development of a custom Microsoft Excel spreadsheet. - Implementation of a random GUID generation mechanism. - Ensuring the functionality for database record identification. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in custom formula creation. - Strong understanding of GUIDs and their usage in database systems. - Previous experience in developing similar solutions. I'm looking for someone who can deliver a...
I'm seeking a professional with expertise in sound and vibration analysis to assist me with various tasks in this area. The specifics are as follows: - The tasks will include both noise and vibration analysis. - You'll be required to utilize advanced analytical techniques to solve problems related to sound and vibration. Ideal candidates should have: - Proven experience in Sound and vibration analysis. - Strong knowledge of analytical techniques and tools within this field. - Excellent problem-solving skills and the ability to work This is a great opportunity to work with a client who values expertise and professionalism in sound and vibratio...
I'm in need of a skilled individual who is proficient in blockchain and wallet analysis, specifically on the Arbitrum blockchain. The project involves analyzing transaction patterns and wallet balances and activities. Key Requirements: - Proficiency in blockchain analysis, particularly on the Arbitrum blockchain - Ability to identify patterns and trends in transactions - Proficient in analyzing wallet balances and activities Deliverables: - A comprehensive report that includes methodology, analysis, and conclusion - The report should be presented in a combination of written format and visual presentation (charts and graphs) Please note that I will provide you with access to...
Description We are seeking an experienced and creative jewelry artist/designer to collaborate with us on creating unique tungsten ring designs for our business. The ideal candidate will have expertise in CAD software, a strong understanding of materials and manufacturing processes, and a passion for creating innovative and visually appealing jewelry designs. Responsibilities: * Develop an original design for tungsten rings that align with our brand aesthetic and target market preferences. *Create detailed 3D models and technical drawings using CAD software. *Provide regular updates on the design progress and incorporate feedback to refine and finalize designs. Requirements: *Proven experience as a jewelry design...
I'm in need of a Point of Sale (POS) interface that works on both Android and iOS devices. The main functionality requirement for this interface is barcode scanning. Additionally, I need this POS interface to support multiple user profiles, each with their unique access levels. Key Project Requirements: - Develop a Point of Sale interface that functions on Android and iOS platforms. - Implement barcode scanning capabilities within the interface. - Create a multi-user system with different access levels for each user. I'm looking for a developer with experience in: - Android and iOS development - Barcode scanning integration - User management systems
...seeking an experienced Excel professional to assist with a small data entry project. Key Responsibilities: - Data entry with formulas: You should be proficient in Excel and comfortable working with spreadsheets that require formulas. - Handling digital data: You will be provided with data in a digital format, likely an Excel or CSV file. Ideal Skills: - Advanced Excel skills: You should be well-versed in Excel, particularly in data entry and formulas. - Attention to detail: Precise data entry is crucial for this project. - Efficient and organized: I'm looking for a freelancer who can manage their time and workload effectively. Please note that this is a straightforward pro...
...which I’ve never heard of or visited. Also there’s nonstop access to my existing online accounts and noticing suspicious activity on my devices. While I've taken measures on some accounts to secure them, it's not enough and I need professional intervention. The compromised accounts include apps, social media, GPS and financial. The activity on my devices sparks concern, particularly regarding showing activity in my history I did not do and I'm looking for expert guidance I have already wiped my device multiple times and have even gone as far as establishing all new digital identifiers such as new phone number, email, and Apple ID to no avail. Skills/Requirements: - Know...
I'm in need of a talented freelancer to assist with content creation. This project is focused on boosting brand awareness and making our products and services more visible to potential customers. Key Responsibilities: - Conceptualize and create compelling content that resonates with our target audience. - Develop engaging written content or video content that clearly communicates our brand message and value proposition. - Ensure that all content aligns with our brand guidelines and voice. Ideal skills and experience: - Proven track record in content creation, preferably with a focus on brand awareness. - Strong writing and/or video production skills. - Ability to understand and effectively com...
I am seeking an experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ...
...designed and developed that will serve as a platform for my healthcare company. The site will have a three-pronged approach to content, focusing on: - **Services Offered**: I want to showcase the range of services we provide. This section should be clear, concise, and informative. - **About Us**: This is where I want to introduce the visitors to our company - our values, mission, and vision. It should be detailed yet engaging. - **Contact Information**: I need a clear and easily accessible way for potential clients or partners to reach out to us. The target audience for this website will be varied, including: - **Patients**: I want the site to be easily navigable for patients seeking our services. - ...
I'm seeking a seasoned web designer to curate a service-based website for both B2B (Business-to-Business) and B2C (Business-to-Consumer) audiences requires a strategic approach to address the distinct needs of each target group. Medical Staffing Agency primarily located in the Midwest current Base Website Custom Design: Includes up to 4 unique page designs. Responsive Layout: Mobile-friendly design that adapts to various screen sizes and devices. CMS Integration: WordPress installation and setup, allowing for easy content management. Content Strategy Session: Session to outline the site’s content needs and SEO goals. Contact Form: Integration of a basic contact form which stores records in...
...skilled freelance writer to create comprehensive documentation and set up demo data for our company's Customer Relationship Management (CRM) processes. The primary responsibility will be to research and document our existing CRM workflows, procedures, and best practices, as well as create sample data for demonstration purposes. Responsibilities: Collaborate with our CRM team to understand our current processes and requirements. Conduct thorough research and gather necessary information. Write detailed, step-by-step instructions and guidelines for various CRM processes. Ensure documentation is easy to understand and follow for both new and experienced users. Organize and structure the conten...
...EXPERIENCE IN THE FIELD ONLY Objective: Scoring Algorithm for evaluating potential investments Data Source: 200+ proprietary historical records with up to 90 parameters Mentoring requested (to be worked with tech project lead and data engineer): • Data-Preprocessing (missing values, normalization, outliers) • Implementation methods for feature selection (e.g. correlation Analysis, feature importance, etc.) • Identify and run different algorithms (e.g., logistic regression, decision trees, random forests, gradient boosting, neural networks) • Details and rationale behind algorithms selection • Hyperparameter tuning and optimization • Cross-validation • Performance metrics (e.g., accuracy, precis...
I need to make updates to userform so that empty dates do not affect filter on table. Right now leaving date field empty hides all the rows of table. Few more updates needed and more details will be shared with selected freelancer.
...graphic designer to help me create visual content for my business across various social media platforms. Key Requirements: - Experience with designing for Facebook, Instagram, Twitter, and LinkedIn - Proficiency in creating minimalistic graphics - Ability to work with specific colour schemes and branding guidelines Your role will involve: - Understanding the provided colour schemes and branding guidelines - Creating a variety of visuals for posts, stories, and ads on the specified social media platforms - Ensuring all designs are modern and minimalistic in line with the overall theme Ideal candidates would be able to take the provided colour and branding guidelines and translate them into engaging ...
...iconic logo and text. *Important; only *creative and original* designs that you yourself have created should be entered. *Please do not duplicate the designs of other contestants. If a winning design has been duplicated, the award will go to the original design. > Brand name >> Causes for Caring << > Brand theme; love, caring, and charity with subtle connection to medical care > Brand Colors: We would like to see a variety of appropriate color options for the brand (see brand theme above), 2 -3 colors per design > The design should be effective in black and white as well as color > The design should be recognizable even at very small sizes > Designs with contrasting elements which lead the eye...
I'm looking for a data scraping specialist proficient in leveraging social media platforms, business directories and website scraping. The goal is to create an Excel sheet with approximately 500 entries for market research purposes. Skills & Requirements: - Proficient in data scraping from multiple sources - Capable of filtering and sorting data - Able to extract and compile the following data fields: zip codes, locations, contact information, business name and industry. The successful candidate should demonstrate experience in similar projects, showcasing their ability to find and compile information efficiently and accurately for market research purposes.
I'm seeking a creative and experienced graphic designer to create a logo for my trust-based recruiting platform. This logo plays a vital role in conveying the unique values of my platform, so it needs to resonate with the message of trust, innovation, respect, and energy. Key Requirements: - Color: Predominantly blue should be used to represent trust and innovation - Emotion/Message: The logo should emanate trustworthiness intertwined with innovation, respect, professionalism and energy. - Symbols/Icons: The designer is expected to include pertinent symbols or icons that encapsulate the core values of the platform (such as a puzzle pieces, or other matching symbols) Ideal Skills: - Experience in lo...
I am in need of a creative and professional video editor to assist in repurposing one of my videos into five smaller, engaging marketing videos. Purpose: - These videos will be used to promote a specific product or service across multiple platforms. Platforms: - The final products will be optimized for social media, web and also suitable for email marketing campaigns. Audience: - Specifically targeting age group 36-45 and above. Therefore, the design, tone, and messaging of the videos should be relatable and appealing to this demographic. Ideal Skills: - Proficiency in video editing softwares - Solid understanding of digital marketing and social media trends - Experience in creating con...
This is my website link I have used "Classima – Classified Ads WordPress Theme" theme. I want to upload date from xls sheet. Excel attached for your reference. Raduus Theme is not providing support and they only provides category and location import options. Can you help me to import data
I've got a list of company names on an Excel sheet that I need you to help me with. Here's how you can assist: - **Scraping from Multiple Platforms**: I need you to scrape email addresses, phone numbers, and any available social media accounts of these companies. You'll need to do this across Yelp, Google Maps, and TripAdvisor. - **Social Media Scraping**: In addition to the primary two platforms (Instagram and Twitter), I'll also need you to scrape Facebook accounts if available. Ideal candidates for this project should have: - **Web Scraping Experience**: A good knowledge of web scraping techniques and tools, which will ensure you can obtain accurate and reliable data....
I'm looking for a talented web designer to create a professional and clean website for my IT company. The primary purpose of this site is to showcase our portfolio, so it needs to be visually appealing, easy to navigate, and optimized for lead generation. Key Deliverables: - A home page that grabs the visitor's attention and encourages them to explore further. - An 'About Us' page that introduces our team and explains our company's mission and values. - A 'Services' page that clearly outlines the IT solutions we offer. - A 'Portfolio' page to display past projects we've successfully delivered. - A 'Testimonials' page to showcase feedback f...
I am looking for an experienced PHP developer to help me domify some software. Specifically, I need an inventory management system built from raw PHP. Key Features: - Inventory management: I need a system that can help me keep track of my inventory in real-time. This system should be able to handle multiple products and update their status as needed. Current Inventory Management: I am currently using another software to manage my inventory. However, it does not meet my needs and I am looking for a more tailored solution. Ideal Skills: - Strong proficiency in PHP - Experience with building Inventory Management Systems - Knowledge of raw PHP If you have experience in building similar systems, I would love to hear from ...
