Excel formula if cell contains text then return value in another cell jobs

...proficient Odoo developer skilled in several modules. - Portal users can only visit National Skills Competition module for view only, and have their own filter settings, but they can't make any changes and can't see any other modules at all, what they can do is just view NSC module, use the search, filter, or print(if available) features, also, please instruct us how to create this specific users. - Co-ordinator in project/Task can also edit the project/task/so/sales/quotation / purchase order and all custom modules we created - Additional five Project list reports, just use the existing one and change the fields, add one combine report and one button or dropdown list then generate that. - Task, one click to update or add, create buttons in...

I require a knowledgeable freelancer to build an Excel sales order form which can handle multiple ship dates and calculate discounts on a sliding scale. Key Functionalities: - Multiple ship dates: I would like customers to choose their ship dates from a calendar function. - Discount calculation: Discounts should be calculated on a sliding scale based on the volume of the order. The ideal person for this task will have proven experience in building advanced Excel spreadsheets, primarily focusing on dates manipulation and financial calculations. An understanding of sales processes, specifically as it relates to ship dates and discounts, is advantageous.

...highly sensitive project due to the volume and value of the websites. Candidates have to send in identification and sign NDA. Key Responsibilities: Systems Administration: CPanel management, database administration (PHP), FTP, firewalls. WordPress Maintenance: Plugin updates, theme management, basic frontend/backend operations. Security Focus: WordPress hardening, malware/infection remediation, firewall configuration, virus scanning, intrusion prevention. SEO: Basic on-site/off-site optimization, Google Search Console, Google Analytics, Google Webmaster Tools, Google ReCaptcha, cookie consent implementation. The Ideal Candidate: Demonstrated WordPress administration expertise Strong security background with experience in infection cleanu...

...secure $50,000 in startup funding. The successful candidate will research and identify relevant grant opportunities, craft compelling proposals, and work closely with our team to position our business for grant success. Responsibilities: * Research and identify grant opportunities aligned with our business plan and funding needs * Write clear, persuasive grant proposals and applications * Collaborate with our team to gather necessary information and data to support grant submissions * Manage grant submission process, including meeting all required deadlines * Communicate progress updates to management and incorporate feedback * Assist with post-award reporting and compliance as needed Requirements: * Proven track record of securing grants, preferably for startups or businesses ...

I am currently facing an issue with my website - when a user registers on the site, instead of being redire...the site, instead of being redirected to their profile page or login page, the system keeps them on the same page. Furthermore, upon this failure to redirect, it shows it is successful when registering but doesn't take to another page. I need someone with strong proficiency in HTML, CSS, JavaScript, PHP, and SQL to diagnose the problem and implement a solution so that after successful registration, users are seamlessly taken to their profile page. The ideal candidate should have: - Significant experience in PHP, HTML, CSS, JavaScript, and SQL. - Proven track record in troubleshooting and rectifying website issues. - Firm understanding of user au...

...understood by those well-versed in Simulink. Leveraging your knowledge, I need assistance in modeling simulation, establishing an effective control system design, and performing signal processing. Key responsibilities: - Build a model simulation - Design a stringent control system - Perform signal processing Although the specific task was not clarified, I value a freelancer who can dynamically adjust to the task at hand. Hence, your application should highlight your past work, experience, and a detailed project proposal–these are essential components to your success in this project. The ideal freelancer should display: - Excellent knowledge of Simulink - Previous experience in model simulation, control system design, and signal processing...

I need an expert to create Power BI slides for data analysis. - The primary objective is to assist me in analyzing the data from excel spreadsheets efficiently. - The slides are intended for basic data analysis. Therefore, the level of interactivity required is basic, encompassing features like tool tips and basic filters. Ideal candidates should have: - Proficiency in Power BI for data analysis. - Proven experience working with Excel spreadsheets. - The ability to create easy-to-understand visuals. - Good communication skills to understand the requirements and deliver the project urgently.

I have an ongoing project that involves the entry of text data from online sources directly into our website. Key Project Details: - Type of Data: Primarily text-based information - Data Source: Online sources - Organizational Structure: Directly input into our website Ideal Skills and Experience: - Proficiency in data entry - Experience with text-based data - Ability to navigate and use online sources - Attention to detail - Website data entry experience is a plus Please bid with your relevant experience and expected rates.

I am looking for an expert to assist in creating a dynamic Power Bi dashboard. This job should revolve around integrating data from Excel spreadsheets and designing a variety of data visualizations. Key Responsibilities: * Guide me in creating the dashboard on my company account. * Connect the Power Bi dashboard to Excel spreadsheets as the primary data source * Develop compelling data visualizations using pie charts, line graphs, and bar charts * Configure the dashboard to refresh data on a weekly basis Ideal Candidate: * Strong experience with Power Bi and data analysis * Proficient in handling Excel data * Expertise in creating different types of charts * Ability to work with time-based data refreshing schedules Scope of Work: The...

...customers to check if their location falls within the service area. - Online Appointment Scheduling: Implement an intuitive appointment scheduling system that enables customers to book service appointments directly from the website, specifying their preferred date, time, and service required. - Quote Request Form: Provide a user-friendly quote request form where customers can submit their project details and receive personalized quotes from Domino Home Services. - Customer Testimonials and Reviews: Feature a dedicated section showcasing customer testimonials and reviews, highlighting the company's quality of service and customer satisfaction. - Service Area Map: Incorporate an interactive map that visually represents the service areas covered, allowing customers to quick...

I need to connect ElevenLabs' text-to-speech API to another tool through Zapier. So far, Elevenlabs' response has been a binary. Instead, I need the audio URL so that the second app I want to connect with Elevenlabs can use the URL in an automation. To participate in this project, you'll need to create your own free accounts for both services. The participant will need to deliver a complete solution that, if possible, doesn't involve hosting the content in a third-party service. To participate, please start your message with "Bonjour". This way, I'll know you've read this instructions. If you need clarification, pleaset let me know.

As someone on the exciting business path...it is designed to showcase my virtual tours and attract customers to my business. I envision a design that puts my virtual tours front and center, captivating visitors to become clients. The design should place a priority on navigation and user experience. In terms of skills and experience, I am ideally seeking a designer who understands the virtual tour business well, has excellent creative skills, and a keen sense of UI/UX. Experience with speedy work delivery will be a valuable asset given the tight timeline of a week. In return for your expertise, I have budgeted $300 for this project. Let’s create something visually stunning and highly functional together! This is our website as of right now:

Budget is max $350. so don't ask me. I will provide end point and key info, I have needs for 4 things - 1) E* Trade API integration (take data from them). - Easy if you know API/OAuth - 2) Text to Voice Conversion. - This is where you skills will be. 3) Emailing file.- Easy 4) Learning from me about financial lingo. = time sensitive if you can not work next 7-9 days no need to bid. I need this project to be over by 4/28/2024.

I'm in need of a skilled Machine Learning Engineer who can develop modules to help analyze the real-time electricity consumption for a variety of devices in our system. Backend: Key Points: - Devices to be analyzed include air conditioners, lights, and simple motors and other simple devices. - The analysis should cover both the collective consumption of groups of devices and the individual consumption patterns of each device. Ideal Experience: - Strong background in Machine Learning, ideally with experience in real-time data analysis. - Previous work in energy consumption analysis or similar fields would be a huge plus. - Proven track record in developing ML models for group and individual level analysis. The ML analysis we are looking ...

I need an Android service developed that continuously captures GPS location data in the background, enabling real-time tracking. Key Deliverables: - A service that can consistently capture GPS location data in the background - even when the app is closed. - The capture precision of the location data should be within 10 meters. - This data must be updated every 5 minutes to ensure accurate real-time tracking. Skills & Experience: - Strong proficiency in developing Android services. - Prior experience with GPS location tracking in background mode. - Demonstrated ability to deliver high-precision location data.

...functionalities of another platform I have access to, but with some additional features. The main features of the project include: - Customizable user interface: The dashboard should allow users to customize their views and layouts to suit their needs. - Reporting and Analytics: I need the dashboard to provide comprehensive reporting and analytics features for tracking: - Email marketing metrics - Lead generation metrics - Social media metrics Additionally, the dashboard should be able to integrate with various third-party applications. These applications include: - Google Analytics - Twilio - Facebook - Instagram - Google Reviews The ideal freelancer for this project should have experience with marketing dashboards, multi-tenant systems, and API integrations. Proficienc...

...from displaying property listings to generating leads and providing company information. Ideal Skills and Experience: - Proficiency in web development with React - Past experience in real estate website creation - Understanding of lead generation mechanisms - Strong aesthetic sense for creating intuitive, user-friendly design What to Include in your Application: - Samples of past work, especially of previous real estate websites you've created - Description of your experience with React and with real estate website development - A detailed proposal for the project, addressing all functionalities and anticipated challenges - Any suggestions for adding value to the project beyond the basic requirements I am excited about the possibility of collaboratin...

I need a proficient Python expert to scrape recipes from a designated website to an Excel sheet. The project needs to be completed as soon as possible. You can use this open-source working scraper Key requirements: - Scraping recipe information (name, ingredients, cooking instructions, nutrition facts) from a specific website. - Outputting the scraped data in a well-organized Excel sheet. Ideal skills for this project include: - Proficiency in Python for web scraping. - Familiarity with scraping data from websites. - Excellent organizational and data management skills for outputting the data in Excel. If you can deliver this quickly and efficiently, please feel free to bid.

...strong online presence for our business and show our target audience the value we provide. Key Deliverables: - A visually engaging and easy-to-navigate website - Proper display and descriptions of our services - Integration of informative resources for potential customers - SEO optimization for enhanced online visibility - Mobile-friendly design for easy access on all devices Ideal Skills and Experience: - Proven experience in web development and design - Extensive portfolio showcasing a variety of websites - Strong understanding of SEO best practices - Proficiency in modern web development tools and platforms - Experience in creating websites for service-based businesses would be a plus. Please include the following in your application: - Detailed ...

Hi Global Text Solutions, I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I'm seeking a skilled financial analyst to help me with a medium-term (3-5 years) cash flow forecast model. Key Tasks: -Produce a simplified cash fl...incentives) - Model Creation: Develop a financial cash flow model that can reliably forecast our cash position over the next 3-5 years. Specifically, I'd like to be able to determine the break evens for a particular feedstock price, or incentive value. Skills/Experience Required: - Strong Finance Background: Deep understanding of financial analysis and forecasting. - Research: Ability to find and interpret financial data to inform the model. - Modeling: Proficiency in creating financial models, preferably in the same or similar context. - Data Analysis: Experience in analyzing financial data and trend...

My project need...developed for an advertising campaign. It's ideal for a freelancer with innovative skills and experience in graphic design who appreciates the avant-garde: ATTACH is the image, dont need hand and cards. Instead of tshirt, HAT has to be written - Create a visually striking abstract illustration pulsating with energy. - The illustration should be creatively dynamic yet clear enough to represent my brand's unique qualities. - This piece of work will be pivotal in our upcoming advertising campaign and can characterize our brand's distinctive visual identity. Previous experience with advertising campaigns and abstract visual design is highly desired. Understand my brand, immerse in our aesthetic value, and redefine it into a fascin...

This is a one day project. I will provide a spead sheet to be formatted in excel. Debits and credits will be separated and sumed that easy 24 months are involved the files email for additional information.

...Overview: We are looking for a talented web developer or development team to transform our Excel workbook into a dynamic subscription-based web application. This workbook is integral to the operations of multiple educational institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and enhancements wi...

I just need someone to open these files in 3ds max and save them as max2021, nothing else. I'll consider it a favor. Thanks in advance.

App is completed but in that there is some issue regarding Zegocloud's library. I want only freelancer who can solve this issue. No company will be entertained. this is my code which show the error of : can not read property 'getPluginType' of null import {StyleSheet, Text, View} from 'react-native'; import React, {useContext, useRef} from 'react'; import ZegoUIKitPrebuiltLiveStreaming, { HOST_DEFAULT_CONFIG, ZegoMenuBarButtonName, } from '@zegocloud/zego-uikit-prebuilt-live-streaming-rn'; import ZIM from 'zego-zim-react-native'; import {useNavigation, useRoute} from '@react-navigation/native'; import BackButtonHandler from '../BackButtonHandler/BackButtonHandler'; import KeyCenter from '.....

...HVAC systems of my property. - Electrical Plan: I'm interested in incorporating energy-efficient lighting into my home. The plan should focus on maximizing energy savings while providing adequate lighting for all spaces. Additionally, I would like to include outdoor lighting in the plan. - Plumbing Plan: For the plumbing, I'm looking for a design that features dual-flush toilets and a hot water recirculation system. I'm particularly concerned about water efficiency and comfort, so I would appreciate a design that reflects these priorities. As a freelancer, you should have a strong background in electrical, plumbing, and HVAC design. Experience with energy-efficient solutions and water-saving fixtures is a bonus. I value clear communicat...

i want to create a animation where a stik man apears in the windows screen. in the desktop. then another stikman a bigger one punches him. he ruuns past 10 photos wo i will place and then they stop in one photo and fight, then they settel down and three more stikman apear and they all sit in a house

...fair value gaps. The indicator will need to include alerts triggered by specific conditions. Details will be discussed later. Should have complete knowledge on trading view. Multiple timeframes will be used including the seconds timeframes. Key Requirements: Indicator: The focus of this project is to develop a robust trend-following indicator for trading purposes based on Fair value gaps. Details will be shared in detail. Basic knowledge about fair value gaps required. Platform: The indicator should be specifically designed for the trading view to work on all platform. Alert System: The indicator will need to include an alert system that can be triggered by specific conditions. These conditions will be determined by the indicator itself. Ideal Skills an...

I'm in immediate need of a dedicated and dynamic Virtual Assistant to support my growing needs. The ideal candidate will be someone who thrives in managing multiple tasks efficiently and possesses a keen eye for detail. Your main responsibilities will include: The budget is 100 USD a month. ( 6 hours a day, 6 days a week ) - Managing my emails with the utmost discretion and organization. - Scheduling appointments, ensuring I never miss an important date. - Conducting data entry tasks with accuracy. - Performing internet surveys to gather valuable information for projects. - Preparing ad-hoc reports based on collected data and research. Required Skills and Experience: - Proficiency in Microsoft Office Suite, especially in Excel, Word, and PowerPoi...

I need an Excel expert to help me with my spreadsheet. My spreadsheet has some formula errors that need to be fixed. The spreadsheet is not very complex; it mainly contains simple formulas and calculations. Ideal skills for this job: - Strong understanding of Excel formulas - Experience in fixing formula errors - Attention to detail After the fixes, I plan to use the spreadsheet for daily operations. I need help to fix the column titled "Total Shifts" and the row titled "TOTAL" - Both of these are not calculating the correct numbers when a selection is made from the dropdown lists in the table. I also want a report creating which will tell me how many of each shift type in that week the employee has done i.e ...

...designer to recreate a existing logo from a PNG file. The goal is to have the logo look completely identical but with editable text. It is critical that no design elements are changed and the colour scheme remains identical. If you are experienced in creating logos with editable text and have an eye for detail, this project is for you. Please note that I do not have the font file for the text, so a match will need to be found or a very similar looking font used. Please start your bid with "Celebrate little victories", otherwise it will be ignored. You will have to deliver the final version of the logo in an editable format (.ai, .psd or .cdr), all the fonts used in the design, the final palette with hexadecimal codes as well...

I am currently experiencing several issues with my Flutter project and urgently require skilled assistance. The primary problems include persistent build errors and several UI layout issues. Ideally, the chosen candidate will be proficient in working with the Flutter framework, experienced in solving similar issues, and familiar with both Android and iOS development. • Build Errors: My project has been spawning various build errors that hinder the execution of the application. The freelancer is expected to help identify and rectify these errors. • UI Layout Problems: There are also vital concerns with the user interface layout. Some pages don't render correctly on different screen sizes, and the general responsiveness of the UI is inconsistent. The task woul...

I'm in need of a modern shirt design for my excavating company. - Key Requirement: The design should prominently feature the company name. - Style: Modern, with a focus on minimalistic and clean aesthetics. I'm open to other ideas, the shirt doesn't have to be that specific style. - Deadline: I require this project to be completed ASAP. I'm looking for a freelancer with a strong portfolio showcasing modern and minimalistic designs. Experience in creating corporate or industrial-themed designs would be a definite plus. The ideal candidate should be able to deliver a high-quality design in a short timeframe. I want this to be a high quality design with lots of thought. I want it to look like a well known brand. Not just another contractor ...

...that. The database stores a variety of exercise data, and the webpage needs to display this data in an intuitive and user-friendly manner. Key webpage features include: - Display of exercise data: Each exercise's description and its difficulty level should be displayed. There's also a column in the database containing YouTube URL links, so another important feature the webpage needs is the ability to watch these exercise videos directly from the webpage. It is a simple database with only one table. - Users should be able to select the exercise they want from a drop-down list. They should be able to start typing the name of the exercise and the drop-down list should filter based on their text. Eg. if they type 'squat', the content...

I'm looking for an experienced web developer to help me create a user area website. The functionalities of this platform should include: - Account Registration: The website must have an account registr...sumup, only internally, it's easy to verify documents, photo front back and selfie - the admin can create orders and generally activate them for all users or only for individual users - the user can accept orders and then has to rate them - excites have a value that should be displayed in the backend - If users have successfully completed orders, they will receive this value on their backend account after verification by admin - Messaging system: The platform should also have a built-in messaging system that allows users to send and rec...

...learned about throughout this semester is either this class or another course at MPTC. Use examples from The Learning Scientists BlogsLinks [ ] to an external site. to guide your approach. Each paragraph within the blog should have a clear topic sentence, body, and conclusion with transitions to move from one idea to the next. You will complete a rough draft and a final draft for this assessment. Content: You should focus on the information that you think would be most useful to students. You have two options: You can go for breadth, by including material from multiple topics (weeks) covered in the class; OR You can go for depth and include only material from 1 specific topic covered in the class. To demonstrate originality, include information from

I'm seeking a seasoned developer well-versed in C# and Selenium to create a bot to facilitate automation on Facebook Marketplace. The bot that I'm envisioning would need to perform the following tasks: - Can use multiple accounts, log into several accounts to enter automatic Facebook marketplace listings or Facebook group posts, logged in accounts are saved and can be opened without re-entering the password - Autopost Facebook Marketplace Create Product Title, product description, Product Category, Product Condition, location and product price range, Product Availability, Product Label / Keywords can be separated by commas, SKU Only We Can See. After inputting, you can automatically select a location, especially for the Indonesian region. - Can upload autoposts to ...

Perform an in-depth sensitivity analysis of a Pressure Swing Adsorption (PSA) process for CO2 capture using zeolite 13X. Scale up a CO2 capture system from a small-scale experimental study detailed in the attached research paper to an industrial application focusing on a flue gas stream solely made up of CO2 and N2. This comprehensive investigation can be based on specific equations, data, and parameters that will be provided from a relevant paper. Duties and Responsibilities: - Understand the Base Model: Analyze the experimental study to grasp foundational models and calculations. - Industrial Sensitivity Analysis: Utilize any effective method to scale up these findings to industrial levels. - Use MATLAB, Excel, or any other tool to conduct a detailed sensitivity an...

Excel Automation of my project and data visualization

I'm in need of an Excel expert who can assist me with data analysis, formulas, and data visualization. The project involves working with a dataset of medium size, specifically, between 1,000 - 10,000 rows. Key requirements for this role include: - Strong understanding of data analysis: The ideal candidate should have a proven track record of analyzing data, preferably in a business context. - Proficient in formulas and calculations: You should be very comfortable with advanced Excel formulas and calculations. - Data visualization skills: The ability to present data in an easily understandable and visually appealing way is crucial for this project. Specific functionalities and tools that need to be utilized include: - Pivot Tables: You will ...

I need assistance with a one-time data entry task into Microsoft Excel. The volume is less than 100 entries. Ideal Skills: - Proficient in Microsoft Excel - Attention to detail - Strong data entry skills Please note that the data needs to be accurately entered and organized in the Excel sheet. The project shouldn't take more than a few hours for someone with good data entry experience.

I'm currently seeking a skilled freelancer with a strong background in eCommerce, specifically with Amazon. We used to sell before, then stop back in 2022. Now, the plan is to start again. Key Responsibilities: - Transfer my existing product listings from another eCommerce platform to Amazon. My product line focuses on Clothing and Accessories (Ethnic Clothing & Accessories and Wedding Accessories) - I have high-quality professional photos of my products, so your job will be simply to upload these as required by Amazon. Ideal Skills: - Excellent proficiency in English language, both written and verbal. - Hands-on experience with Amazon seller platform. - Knowledge of SEO and understanding of algorithms for product search on Amazon would be hig...

...an expert to help me select the most suitable all in 1 programming language for building various applications targeting multiple platforms (mainly web) 1. I would like to build applications for Web, iOS, Android, Windows 10, Linux, and MacOS & embedded systems (like micro controllers) from single code base 2. I want to learn a language in which we write a code once and can compile for any platform. 3. One possible answer to my questions is JavaScript. We can build server side apps in JS using Node.js & Next.js. Javascript can be embedded in HTML on client side too. We can build desktop apps in JS using Electron and we can make mobile apps in JS using react & angular. But in javascript will code be exactly same for all platfo...

Job Description: We are seeking a skilled Freelance Full Stack Developer with experience in AI technologies, web development, and data processing to build an automated pipeline for creating AI images. The successful candidate will be responsible for developing a complete solution that includes trend analysis, automated prompt generation, integration with image generation APIs (such as DALL-E, Stable diffusion and MidJourney), backend infrastructure setup, and frontend design. Responsibilities: Trend Analysis: Implement a system to analyze and extract trends from Google searches stored in an Excel file. Prompt Generation: Develop an automated system to convert trend data into creative prompts suitable for image generation APIs. API Integration: Connect with external A...

My Brother - you ready to kick off another logo! I have some direction on this one - will send info for you to check out! We have the main -"Logo", we just need to design it for a new division they are launching.

...data from Excel spreadsheets. The combination should be based on a unique ID field that is generated using fields common in both datasets. Here are the key details: - Data Type: Both data sets are in Excel format. - Merging Output: The final result should be a new Excel spreadsheet. - Matching Fields: There are common fields present in the two datasets that should be used to generate a unique ID for matching. -Filter: There are records that will not be used, but they are easily identified by a unique, consistent value The ideal freelancer for this project should: - Be proficient in Excel and capable of handling small datasets. - Have experience in data merging, particularly based on generated unique identifiers. - ...

I urgently require a highly skilled professional to modify specific parameters of my EA optimization project. Mainly, I need the Stop Loss Value and Lot Size parameters adjusted to better suit my requirements. Ideal Skills: - Proficient in EA optimization - Knowledgeable about risk management systems - Previous experience in adjusting similar parameters - Quick and efficient delivery time The successful candidate will be able to deliver the updated EA optimization without delay. The sooner the completion, the better. With your extensive experience, I'm confident you can understand the necessity to act swiftly and undertake this task urgently.

...are actually the combination of the following data: CarTypeId - Maker - Model - Year - RoofType Their relationship should be many-to-many, so we probably need a middle table that contains their combinations CarTypeId - ProductSKU The above is just a suggestion and additional columns or different implementations can be used. The plugin should implement the following: DATA Import: A way to import data from Excel file (example file attached). The import file might contain data for many SKUs and should overwrite the data of every specific SKU. As a result all the matching of Cars to SKUs is actually done in the Excel file. Products Filtering: Ability to filter the products that are matched to cars according to the cars (sample image attached). To make things ea...

I'm in need of a skilled data analyst to conduct a thorough regression analysis using panel data in R. The primary goal is to understand the impact of one variable on another within a dataset that includes between 6-10 variables. Key Project Requirements: - Utilize panel data: Experience in handling panel data is a must for this project. The ability to understand the nuances of this data type will be crucial for accurate analysis. - Regression Analysis: In-depth knowledge of regression analysis is required, especially in the context of panel data. The ability to extract meaningful insights and estimate the impact of one variable on another is the core task. - Data Interpretation: The successful freelancer will be able to provide clear...