How to sum values based on criteria in another column in excel jobs

I'm looking for an Excel data analyst to help clean up a dataset. The main task is correcting data inconsistencies. Key tasks: - Data Cleanup: Fixing data inconsistencies and ensuring the dataset is aligned and coherent. - Missing Data Handling: Utilize statistical methods to estimate missing data. - Data Analysis: Basic analysis to identify relevant insights or trends in the cleaned dataset. Ideal skills and experience needed: - Strong understanding of data cleaning and data analysis in Excel. - Proficiency in statistical methods for handling missing data. - Ability to draw relevant insights from data analysis. - Good communication skills to present findings in a clear manner.

I'm in need of a freelancer who can help me parse my VCF file and convert it to a different format. The main goal of this task is to extract the genotype information from the file. input will be VCF file (from ONT whole genome run) and csv file with columns containing rsID, chromosome number, position. output will be same as input csv file, with extra column showing genotype from VCF at the given position can run on Mac shell so either perl or python would be fine. Ideal Skills & Experience: - Proficient in parsing VCF files and understanding genotype data - Experience in converting files to various formats like CSV, TXT, and XLS - Attention to detail to ensure accurate extraction of the data - Knowledge of any...

I'm seeking a talented logo designer to create a visually appealing logo for my website. The following must be taken into consideration: Business name: Classic Motor Trader (This has to be in big writing) Business URL: Colour: #ff4605 Strap Line underneath, or in the logo, it must say: 'Classic Car Marketplace' in smaller writing. It must be clear. Logo dimensions: I prefer landscape logos (better for web UX). This website is a marketplace for buying and selling cars. Thanks, Tom

Bliz Beats Music, LLC, a music production company located in southern California, is looking to offload high-ticket sales of our custom music production service offerings (to serious artists looking to take their careers to the next level) to an experienced individual or team of high-ticket closers. Because their business does not solely focus on a single revenue stream, they cannot adapt the traditional sales funnel model from their homepage. Instead, their main website () segments the appropriate content based on the audience type. ___________________________________________ Their website visitor profiles are as follows: (1) Artists / Vocalists / Singer-Songwriters looking for exclusive licensing of high-quality custom...

...extract text content from a specific website on a daily basis. The scraped data should be compiled and delivered in a spreadsheet. Key requirements include: - Daily scraping of text content from the designated website - Compilation and formatting of this data into a spreadsheet Your experience in web scraping, data compiling, and spreadsheet management will be greatly valued for this project. Accuracy, timeliness, and consistent daily delivery are crucial aspects of this job. Understanding of automation tools for data scraping would be a big plus. I am looking to collate some data from this website and need an ongoing scrape of this website to set up an ever-updating excel spreadsheet with the fields as per the attached excel file. ...

I am looking to develop a Variable Message Sign (VMS) software. The software should be: - Compatible with Windows - Able to facilitate message scheduling and display - Support remote management and control - Allow for advanced message customization - This SAAS (Software As a Service) based Software will be display a content publishing management system for PC, which is installed in the Windows operating system and allows editing solutions and playing the solutions on LCD or LED displays. - The software will be SAAS Based, On which multiple clients will be added, and the APIs of the device sold will be integrated into the Software. - This software will have a variety of media: you can add general windows, cut-to-display windows, O...

...with NextAuth and Google: Integration with NextAuth to enable user login via Google. Secure OAuth2 authentication flow to ensure user data protection. User registration through Google account, streamlining the sign-up process. Account and Subscription Management: Each account can manage one school, which can have multiple locations (campuses). Admin dashboard to manage subscriptions and assign school management capabilities to each account. Ability to sell subscriptions, where each subscription corresponds to a single school with its own set of locations, teachers, and resources. Role-based access control: Admin Role: Full access to manage the school, including locations, teachers, classes, and schedules. Manager Role: Limited ac...

Are you an experienced web development team specialising in ReactJS? We are looking for a skilled team to bring our online marketplace to life. Our Figma designs and backend are ready to go; we need your expertise to convert these designs into a fully functional, high-performance website. Project Scope: Frontend Development: Build the frontend of our online marketplace using ReactJS, ensuring seamless integration of our Figma designs. API Integration: Implement APIs to connect the frontend with our backend, enabling all functionalities of the website. Chat Feature: Integrate Sendbird SDK/API to provide robust chat functionalities within the marketplace. Clean Code Practices: Adhere to industry-standard clean code practices t...

I'm looking for someone to curate text and image data for me and compile it into an Excel document on a monthly basis. The successful contractor will have experience with using the Internet to collect data and be able to present it in a structured and organized manner. This data needs to be sourced from reliable sources, checked for accuracy, and edited for quality. The contractor must be able to take initiative and use their own discretion in order to create the best results. Additionally, the contractor will be expected to act in a timely manner, ensuring that the data is updated and ready to use on a monthly basis. This project requires attention to detail and good communicatio...

Looking to collaborate with Antenna experts for design/build of RFID UHF 860-960 MHz Active Digital always on antenna. It will support any RFID tags of the stated frequency range and the protocol. We have identified some possible technologies below but will rely on your expertise to pick one or combination of these or another suitable one from your experience. If you know of a pre-built solution that will be ideal. This antenna will be connected to our MCU via a comm port and be fully software defined. Our objective is to accomplish a 0.3 meters x,y,z 3D planer precision location of RFID UHF passive tags at about 25 meter cone at about 8 meters height from floor. Must be RFID UHF Frequency range (roughly 860-960 MHz, supporting US, Europe...

We are looking to build a long-term partnership with a skilled and dedicated team of developers for ongoing projects involving WordPress and WooCommerce webshops. Our goal is to collaborate with professionals who can deliver high-quality work, adhere to deadlines, and contribute innovative solutions to our projects. Responsibilities: - Develop and maintain WordPress and WooCommerce websites - Customize themes and plugins to meet project requirements - Ensure the websites are responsive, user-friendly, and optimized for performance - Troubleshoot and resolve any technical issues that arise - Collaborate with our team to understand project goals and deliver results that exceed expectations - Stay updated with the latest industry trends and technolog...

...seeking an expert in Excel, OneDrive and email notifications who can develop an automated system for me. This system needs to: - Monitor a specific Excel file within my OneDrive for business for cell value changes. - When changes occur, the system should not send an individual notification for each. Instead, it should group updates together. - These grouped updates should then be sent as a single email to a preselected set of recipients at a specific time interval. - Crucially, the email should not only contain the updated cell values but also their previous values, enabling recipients to easily compare old and new data. Only experienced Excel and OneDrive professionals should apply, preferably with a background in a...

I am in need of a virtual assistant to handle customer service, inquiries, and data entry tasks. Key Responsibilities: - Responding to customer emails and live chats in a timely and professional manner - Managing customer inquiries and complaints, ensuring a positive resolution - Carrying out data entry and basic administrative tasks as required Ideal Candidate: - Previous experience in a customer service role - Proficient in written communication - Skilled in multitasking and time management - Comfortable using email, live chat platforms, and project management software - Attention to detail and problem-solving skills are essential I anticipate needing your assistance on an ongoing, part-time basis. Please submit your pr...

I am in need of a network-savvy professional to help me configure a Unifi Dream Machine Pro to enable it to do a passthrough of an IP address to another router (Edgerouter). Skills and Experience: - In-depth knowledge of networking principles. - Proven expertise in Ubiqity products like Dream Machine and Edgerouter - Strong troubleshooting capabilities.

Project Details $30.00 – 250.00 USD I'm seeking an analyst proficient in harnessing the Amazon Seller API to extract comprehensive data and metrics essential for reporting purposes. Your primary responsibility will involve pulling detailed information from Sales, Orders, Products, Customers, and other relevant columns and sources via the API. Your expertise in navigating the intricacies of the Amazon Seller API to extract pertinent data for reporting is crucial. This data MUST be pulled into Microsoft Excel seamlessly and effortlessly. This will enable easy access and manipulation of the data for reporting purposes. The columns of data required, but not limited to are as follows: Order ID, Tracking ID, Product Name, Unit Price, Ship...

...expertise in building website as well as android and iOS apps • The scope of the work may increase as we learn more about the users of the website. • Please send your price quotations with detail of language/tools you will use and the timeframe you will need to complete this project. Functionalities to build: • Book meeting function that automatically check calendars of team members and shows available slots to external users to make booking with our experts - Admin can sync several calendars (of team member/experts) to one calendar booking form and the form will show availability for all the hours any of the linked expert calendars show available time. • Blog section - All type of Users can read, like, share on mult...

Logo Design Contest Description Contest Title: Design a Modern, Aviation-Themed Logo for Our Techno and House Music Events About Us: We are a Dutch based event-hosting company that specializes in creating unique dance parties with a distinctive aviation theme. Our events are held in a venue designed to look like an airport, complete with all the fun and excitement of air travel. Our music focus is on techno and house, attracting a lively and energetic crowd. De name of the parties is "De Luchthaven" which should be incorporated into the logo. Contest Overview: We are seeking talented logo designers to create a new, modern logo that captures the essence of our events. The logo should be cool, fun, and easily recognizable, reflecting bot...

...Managing tasks and timelines: We require comprehensive teaching and guidance on handling and scheduling tasks, including setting milestones and managing project schedules. 2. Assigning resources and tracking progress: We need to learn how to assign tasks to resources efficiently and track the progress of those tasks effectively. 3. Reporting and project analytics: A thorough understanding of the essential reporting features of Microsoft Project Online, leading to mastery in generating insightful project analytics, is another must-have. The ideal candidate should have proven experience in using and teaching Microsoft Project Online, and the ability to simplify complex features for beginner-level users. Profici...

...for two. Key elements to include: - Both the gifs must incorporate 'Logo A' and 'Logo B'. - The gifs should be in full color. - Text must be included. The specific texts will be provided. They should be visible throughout the entire gif. Ideal skills for the job: - Attention to detail will be important to ensure that logos and text are incorporated correctly and clearly. - Proficiency in making gifs. - A sense of humor and creativity. This task doesn't call for a stiff, formal design! - Prior experience in creating gifs for businesses would be beneficial. In your proposal, please provide examples of your past work, especially if it involves gif creation for businesses. I greatly value creativity and fulfilli...

I'm looking for an AWS expert to design and implement an online platform for my non-profit organization Community Connect. The primary feature of this platform should be project listings. Expectations: * Develop a categorization system specifically for educational projects. Ideal Skills: * AWS Experience * Proficient in Backend Development * Web Design * UI/UX Design Your understanding of categorizing and structuring information for user-friendly navigation will be key. Experience in developing platforms for nonprofit organizations or similar work is considered a plus. Your contributions will help connect volunteers with educational community projects, making a difference in our society.

I am in need of a system to automate my Instagram cold outreach process. The main task to automate is finding potential leads. The system should ideally be able to identify potential leads based on the following criteria: - User interactions with specific posts - The follower count of Instagram accounts - The presence of specific hashtags or information in bio I am primarily looking for someone with extensive experience in social media automation, Instagram algorithms, and data analysis. Excellent coding skills would be beneficial. If you possess these skills and can help streamline my cold outreach process, please apply.

I'm looking for a talented Excel expert who can create a highly interactive and visually appealing budget analysis dynamic dashboard. - Highly Interactive Dashboard: Develop a dashboard that allows users to interact seamlessly with the data. This includes the ability to navigate between different views, select specific time periods, and drill down into detailed information. - Visual Appeal: Design visually appealing charts, graphs, and tables that effectively communicate key financial metrics. Utilize color schemes, fonts, and layout techniques to enhance readability and engagement. - Monthly and YTD Sheets: Incorporate tables of accounts for 12 months and year-to-date (YTD) sheets into the dashboard. Ensure that data from these sheets can be easi...

...someone that can do three projects for me: Adding translations to my current code base of the music player using transloco describing it here: Acceptance Criteria: - Transloco works - all strings have been added to json translation files - spanish and english translations are added - Translations can dynamically change - A setting for changing the language is added - modulized approach Adding Dark Mode: Acceptance Criteria: - Can switch between dark and light mode - have the two main colors of angular material theme defined in a way to be reusable in all components ( changing it in one place will update it in all components) Adding Touch & Arrow Support for the Grid

I'm looking for a logo designer who can create a logo for m...Islamic school named 'Madrasah Misbahul Huda' - Incorporate a combination of Thuluth, Kufi, and Naskh styles in the Arabic calligraphy - Use emerald green and gold as the primary colors for the logo Ideal skills and experience: - Proficiency in Arabic calligraphy, specifically Thuluth, Kufi, and Naskh styles - Experience in designing logos for educational institutions or Islamic organizations - Ability to work with a specific color scheme (emerald green and gold) - Understanding of Islamic symbolism (although not mandatory) Please provide a portfolio of your previous work, especially any similar projects you've completed. I'm looking for a unique and professional design that...

I'm looking for a reliable freelance professional located in Nigeria who can assist in recharging my mobile account. The recharge will involve a network that's not listed (neither MTN, Glo, nor Airtel). Key Skills Needed: - Proficient in mobile recharge processes in Nigeria - Good understanding of various mobile networks in the country - Strong attention to detail to ensure a correct and timely recharge - Reliable communication skills The ideal candidate must be based in Nigeria, as the recharge is specifically needed for a non-MTN, Glo or Airtel network. Experience in mobile account recharging in the country is a plus. We're looking for a freelancer who can complete this task promptly, accuratel...

I am in search of a talented graphic designer to create a modern logo for my business. The chosen style should be bold and utilize bright, vibrant colors such as reds, blues, and yellows. Key Project Requirements: - Ability to translate my brand values into a distinct and attractive logo. - Proficiency in modern graphic design techniques. - Strong sense of color theory, particularly with bold, bright hues. - Prior experience in logo design is essential. Your portfolio demonstrating similar past work will be highly regarded. Looking forward to your innovative design ideas.

I need a data expert to digitize my call logs from PDFs to Excel. - Your primary task will be to convert the data from the PDF into a well-organized Excel sheet. - The data should be categorized by date. - Include only the caller name in the Excel file. - The main goal of this digitization is to facilitate a detailed data analysis. Ideal Skills: - Strong experience in data entry and data manipulation. - Proficiency in Excel, including organizing and categorizing data. - Understanding of the importance of accurate data entry for further analysis.

I am looking for a proficient freelancer to undertake CV screening focused on technical skills. The ideal candidate will have: - The ability to verify competence in the domains of Programming, Network Management, and Data Analysis. - An excellent understanding of these areas to an intermediate level so you can correctly identify them in CVs. Your communication skills should be top-notch to allow smooth interaction. Also, your educational background in a technology-related field will be advantageous. Your role will be to screen through CVs and identify candidates that meet the required technical criteria to proceed to the next round of our hiring process. Your accuracy and precision would be greatly appr...

ITALIAN LANGUAGE MANDATORY. Starting from a list of 12500 Company names in excel, we need to fill in the other columns finding online: - website URL - Zip Code - VAT Number - Type of Industry (selecting it from the excel drop down menu)

...knack for making informative how-to/tutorial videos or are you more interest in comparing videos? If so, we have an amazing opportunity for you to join our team and showcase your talents on our established YouTube channel. We're looking for individuals who can create engaging step-by-step tutorials for software, apps, and email marketing tools. Please note, these are not animated explainer videos; we require screen recordings. Requirements: - Proficiency in English (native speakers preferred) - Willingness to record your phone/computer screen, along with your voice - Ability to explain concepts clearly and concisely - Access to a high-quality microphone I'm looking for someone that: - That's able to...

I'm looking for a skilled developer to create a Flask-based website connected with mysql. This website will be primarily for my personal development. Key Features: - Email Verification otp on login A simple website for our team to use with login option and it should have following features A form to manually update my database A search page to search in my database (For example :- for a student databases a page to add all the details of a new student manully and a page to search for students base on sone criteria which shows the result in a table form) Ideal Skills: - Strong experience with Flask: You should have a proven track record of developing websites using Flask. - User Authentication Exp...

I am looking for someone to create me a landing page for the website to be hosted on Wordpress. Example I like is here: We would only need to explore additional background animation options and add additional line with changing text. Part of the job would also be to set wordpress but that's to my understanding automated on hostinger. That's it. Deadline: ASAP

I'm looking for a proficient NLP programmer to help me implement a Spell Checking algorithm using the BERT model. The ideal candidate should have expertise in NLP and should be comfortable working with the following requirements: - Expertise in NLP: Proficiency with BERT model in particular - Programming Language: Comfortable working with Python - Accuracy Expectation: The spell checking algorithm should provide balanced accuracy and performance, particularly for large texts. The project's main goal is to deliver an efficient and effective spell checker that can handle large datasets. This will require a nuanced understanding of NLP, particularly the BERT model, as well as Python programming skills. The balance between accuracy and performanc...

I'm looking for a creative logo designer to help me establish a brand identity for my new startup, Isala. The logo should be a unique blend of medical and friendly elements, leaning towards a minimalist style. Key Requirements: - Must incorporate medical undertones - Minimalist style - Blue color scheme I'm open to suggestions on the design and would appreciate a fresh, creative approach from the designer. If you have experience with medical branding or designing minimalist logos, that would be a plus. Looking forward to seeing your portfolio and ideas. About Isala: Vision: A portable and affordable training solution to simulate complex situations related to the application of invasive techniques for patient care, pre-surgery prepara...

I'm looking to revamp a website to cater to people with debt concerns, making it more user-friendly and visually appealing. One of the primary objectives of this redesign is to increase leads from the target audience. I would like a wireframe sample of the landing pages before proceeding with the design. Written content will be provided. We would like to create landing pages that provide valuable information about different kinds of debt and debt solutions. There will be approximately 25 landing pages. We will want to include a Blog as well. The website will be in Wordpress. Hosting is already in place. The work will need to be done on a stage site so that the existing site will not be affected. We will switch w...

I am looking to significantly revamp my home's exterior in order to increase its curb appeal. The remodel should reflect a modern rustic style. The specific changes I intend to make include: - Window replacement: To maintain a unified style, the new windows should complement the modern rustic look. - Addition of front dormers: Designed to integrate seamlessly with the existing structure while adding to its visual appearance. - Stone and siding: Both these elements should be curated carefully to bring the essence of the modern rustic style to life. Experienced freelancers who excel in exterior home remodeling with proficiency in modern rustic designs would be ideal for this project. Critical abilities...

...work to enter this contest. If you do not have experience with this kind of task, please do not waste your time submitting AI-generated logos. We are looking to carry out a comprehensive rebranding of (). To find the best fit, we are hosting a contest where designers can submit their initial concepts. The winner will be awarded the entire rebranding project. What We Are Looking For: Initial Logo Concepts: Submit up to 3 initial logo concepts representing the new direction for WoodXEL. Color Palette Proposal: Provide a proposed color palette that complements your logo concepts. Typography Suggestions: Suggest primary and secondary fonts that align with the brand identity. Final Project Scope for Winner: Research and Strategy: Conduct market and competitor...

I'm looking for a professional who can help me generate contact information (name, email,...email, and phone) for leads suitable for my direct email marketing campaign. Key Responsibilities: - Develop a robust strategy to identify and collate data from various sources. - Ensure the data is accurate and up-to-date. - Organize and present the data in an Excel spreadsheet format. Ideal Skills: - Experience in sales lead generation. - Proficiency in using data collection tools. - Strong analytical and organization skills. - Knowledge of email marketing best practices. Experience in direct email marketing or a CRM system would be a bonus. The successful candidate will be meticulous and detailed-oriented, with the ability to deliv...

...Initially, the person first detects, so when another person moves into the video it should only still measure the first person. - But with a click function, it should be possible to change to a person which we want to measure the x,y,z position and output these values exactly like in the video. - Fully support implementing it on the Client's Jetson nano - It should run smoothly like in the video. So no lags or delays - If it doesn't work smoothly on Jetson Nano then we'll help the client implement it in Windows Reference video Remarks of the client: "When starting the program, it should detect and only measure the first person it sees and if I want to change that then I can click on...

I'm in need of a virtual wedding invitation that will not only display the location of the wedding but also provide general information about the event and showcase a selection of photos. The key features and design elements I'm looking for are: - A digital map that can show the location of the wedding. Additionally, I would like the invitation to include a section for general information about the event and a gallery where guests can view a selection of photos. - My preference leans towards a modern and minimalist aesthetic. The overall design should be simple, sleek, and elegant, using colors such as Neptune, Dusty Blue, Sage Green, Gray or Brass. In addition, the invitation should also incorporate an RSVP function. I prefer the RSVP to be mana...

EXCEL VBA + EXCEL EXPERT. Please check video attachment and excel file and tell me if you can do this. Quality of proposal cover letter is always #1. Be #1. This will take 1 hour to code and complete if you know what you are doing.

I'm looking for a data analyst to scrape LinkedIn data and create a series of analytics from the information. Linkedin Recruiter or Premium Account will be needed for this task. Output should be presented in Google Sheets or EXCEL.

I'm in need of a lightweight CRM application for managing FTP data transfer on Windows and Mac. The app should be around 1.90 kb in size. Here's what I'm looking for: - **File Transfer Tracking**: The app needs to provide real-time updates on the progress of file transfers. It should also maintain logs of completed transfers and notify me of any failed transfers. - **Contact Management**: A key feature of the CRM should be its ability to manage contacts. I should be able to add, edit, and delete contacts. These contacts should be organized into categories or groups. Additionally, I should be able to search and filter contacts based on specific criteria. - **Activity Logging**: The app should have a...

I'm seeking a talented professional to develop a modern logo and website for branding purposes. Key Responsibilities: - Create a logo that represents my brand's values and establish its identity. - Construct a modern, user-friendly website that'll effectively communicate the brand story. Design attributes: - The logo and website should have a modern appeal. - Use cool color palette including blues, greens, and purples. Ideal Candidate: - Expertise in modern logo and web design. - Understanding of color psychology in marketing. - Proven experience in building branding assets.

I require proficient excel skills to create two distinct spreadsheets. The first spreadsheet should focus on an immediate expense breakdown, specifically highlighting repair costs as an individual category. Knowledge in business accounting would be advantageous to ensure accurate representation of financial data. The second spreadsheet requires a CAPEX table, based on an example I will provide in PDF format. Freelancers will ideally have: * Expertise in Microsoft Excel * Background in accounting or financial planning * Detail-oriented and able to follow a provided example * Ability to create easy-to-understand, visually appealing spreadsheets Please assure that the work is precise and comple...

Brand Identity and Logo Design for 'Purely Personal' We are looking for a creative and skilled designer to help us develop a unique brand identity for our fashion brand, 'Purely Personal.' The design should be clean, elegant, and easily recognizable, featuring a minimalist logo that incorporates a Himalayan blue sheep and using triangles to convey a sense of individuality and connection. Project Requirements: Logo Design: Create a minimalist logo that includes an abstract representation of a Himalayan blue sheep. Color Palette: Use the specified color palette to ensure a cohesive and professional look: #3A0360 #6622BD #7063BF #D5CEFF Versatile Branding: The logo should be suitable for various platforms and branding materials, such as business car...

I'm in search of an experienced architect with a modern aesthetic to produce a unique layout for the first floor of a house measuring 15 x 70. Key features need to include: - Living room: This is an important area where all my family can relax and spend quality time together. It should be spacious and well-positioned. - Kitchen: Another significant space in the home where meals are prepared. A sleek, modern design which is functional and user-friendly. - 2 Bedrooms: Both bedrooms should be comfortable and exude warmth, promoting restful sleep. Please consider areas for storage, natural lighting and ventilation in your layout. It's essential to manage space wisely to avoid clutter and ensure every area is fully utilized. P...

I am in need of a proficient Google Sheets wizard who can utilize their expertise in managing and modifying spreadsheets for a specific task. I am interested in adding dynamic drop-downs to the cells in the ranges A1:A1000, B1:B1000, and C1:C1000 in Google Sheets. Key aspects for my project include: - Dynamic Population: These drop-downs must be dynamically populated and each row should maintain its independence from other rows. - Dropdown Values: The values for the initial dropdowns (A1:A1000) are derived from a specific list on Sheet2 of the Google document. - Manual Updates: The values on Sheet2 will be updated manually by the user. The perfect candidate should possess the following skills: - Advanced k...

...web designer to completely re-imagine and re-design our performance marketing agency's website. I have a broad vision for this project, as I believe every page, including the home, about us, and services pages, can be improved. Key project goals: - Improve user experience: Our current website, while functional, could benefit from a more intuitive and engaging design. - Enhance branding: We want to ensure that our website is consistent with our brand identity, and that it effectively communicates our values and mission. Key requirements: - Proficient in Figma: I need a designer who is comfortable using Figma for web design. - Experience with performance marketing: It would be beneficial if the designer has worked with similar agencies in the past...