Excel small function with if statement jobs

I'm looking for an expert Figma designer to create a clean and professional design for a microloan application merged with an ecommerce platform. Key Application Features: - Microfinance facilities including loan requests and payments - Ecommerce features: product listing, shopping cart, checkout, and user reviews and ratings. - Service payment function for utilities (electricity, TV, water) For user authentication, I prefer social media login integration and phone number verification simultaneously. Ideal Skills: - Figma design expertise - Previous experience in creating loan applications - Familiarity with ecommerce platform designs - Understanding of social media integration and phone number verification methods In essence, your design needs to ele...

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 l...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 ...

...the client has not specified a particular function, it is anticipated that the website will provide common real estate features such as property searches, property listings, and a contact form. Moreover, the website would ideally cater to a range of purposes, 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 ...

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.

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.

Project 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 enhancemen...

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.

...and onboarding small business clients, and in analyzing their Google Business Profile (GBP) health/optimization. The hired expert should: - Understand and evaluate my small business clients' needs - Integrate new clients into our service portfolio - Be able to develop relationships with Google representatives to achieve fair solutions - Review Google listings for possible violations and provide solutions to issues encountered - Take instructions and assist in getting suspended Google business listings published - Aid in the removal of duplicate listings on the Google databases. The end goal is to possess an active listing on Google with: - Accurate business information - High-quality images Due to the nature of this project, it is essential that yo...

...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 PowerPoint. - Familiarity with accounting software. Although not the main focus, this skill will probably be essential for financial tasks. - Exceptional organizational skills. You ...

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 if they have done 3 DayA shift...

I'm looking for an experienced app developer to create a mobile application tailored for airport transfer drivers. The primary function of this app is to assist our drivers in collecting proof of customer no-shows. The app must include the following features: - GPS location tagging: The app should be able to capture and store the precise location of the driver when a photo is taken. - Date and time stamping: Each photo taken should be automatically stamped with the current date and time. - Picture capture functionality: The app should provide an intuitive and user-friendly interface for capturing images. It is crucial that the app also includes a secondary functionality for flight tracking. The app should be able to link to flight schedules, write the time and date of ...

I'm seeking an experienced .NET programmer to a...pressing 'review this company' moves the user to page 2- review your experience. This is what we want to achieve with a single url. This is so that we can provide a url like that will do the same as the previous steps. Ideal skills for this job will include: - Strong knowledge of .NET programming - Experience in modifying applications - Technical ability to integrate new features using querystrings - Appreciation of best programming practices Your primary task will be to provide a page that will perform this function. Duplicating the exisiting page and modifying the duplicate is a suitable solution as the page is being loaded with the id (161068) so that the review can be written in go the db.

...See. After inputting, you can automatically select a location, especially for the Indonesian region. - Can upload autoposts to Facebook Marketplace using multiple browsers at once - Can Autopost Facebook Marketplace with Excel Import Format - Autopost Facebook Marketplace Duplicate Product Preventer - Autopost Facebook Marketplace Settings to Prevent Banned Accounts - Auto Post Facebook Marketplace Bulk Edit Facebook Marketplace that has been input - The input Facebook Marketplace Autopost Report & Status can be exported - You can search for Facebook groups based on keywords with the selected status of groups that are joined or already joined. For unjoined groups that we have searched for, you can auto join. - Can Auto Post to Facebook Group Each feature has A...

...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 analysis based on the equations given - Documen...

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 be requ...

I need to make a new version of the enclosed little explainer graphic. The changes must be: - Colors and style match better with our flyer - Easier to see the text - following points added (arrow can be to left side of the product): - No electricity needed - installed in 4 minutes As base you must use the photo of the product where the hose is grey - which is also enclosed. If you feel you need to understand the product better before you do this - have a look at our video: I need this in sufficient resolution to use both in print and online.

I'd like to replace the answers in these files - from words to images. For example, instead of the word "Beach" - to replace it with a photo of a beach.

I have a private football manager game online. Written in PHP and TWIG. Th...PHP and TWIG. The script has already been adapted to PHP 7 (from PHP 5). 1. Now it has been noticed that 1 function, 1 module does not work properly under PHP 7. This module needs to be adjusted. 2. I need a few minor adjustments and functions in the game and in the admin area. 3. Then I would like to have a new module. A calendar where you can see the days and what matches you have on those days. (Read from the existing database and display). And with some functions. You have to know that every extension to this script will be written in modules. These are then copied into the directories and taken over by the main script. Who can help? Further information and sample images if you are in...

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.

There's a critical problem with my WordPress website – it's not loading. This always worked perfectly fine before. Suddenly, it has ceased to function its main purpose and this is hurting my digital presence. I urgently require the expertise of an experienced WordPress ninja who can identify the issue and resolve it as soon as possible. I am unsure as to which part of the website is causing this issue, hence your technical expertise will be absolutely crucial. Ideally, you should have: - Experience in troubleshooting WordPress loading issues. - Extensive knowledge of WordPress plugins, themes, and backend. - The ability to work promptly to resolve issues. Notability, this project is needed ASAP due to the ongoing loss of website functioning. The successful...

...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 APIs like DA...

I'm in need of a software developer to create a comprehensive solution for organizing and managing computer-based tes...graphical interface for test takers. - GUI for Result Preparation: Additionally, a graphical interface for staff to prepare and analyze results. Platform Compatibility: - Based on client-server architecture, the software will be set up to function on a local server. Ideal Skills and Experience: - Proficiency in software development, specifically with a focus on creating user-friendly interfaces and database management. - Experience with creating and managing server-client architecture. - Strong understanding of test-taking procedures and test preparation. If you're confident in your ability to deliver a top-notch computer-based te...

I'm looking for a data expert to merge two sets of 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 uniq...

...experienced Android app developer to create a robust and aesthetic dental care plateform The successful applicant will have: -Expertise in Android app development -Proven experience in creating dental health care apps Primary Function of App: - Establish a user-friendly interface for purchasing and asking disease problem using cam scanner on chatboard frome home or from anywhere we want. -If user want to connect with dentist urgently, for that thing first pay online 50₹ to the dentist and connect with them urgently. - Ensure secure online payment options after contact with dentist. - Effective things categorization for easy user navigation - Provide options for user reviews and feedback Your commitment to timely delivery and clear communicati...

Looking for a Google Cloud Platform (GCP) expert who can assist with Cloud Functions and Vision API integration and deploy function on google cloud - Your main focus will be integrating Vision API for images batch processing and setting up Cloud Functions. The urls of images will be in excel file in google cloud. The parse result to be placed in columns next to url column. - The data primarily processed with text detection. Ideal Candidate: - Proficient in GCP services, specifically Cloud Functions and Vision API. - Experienced in setting up GCP services for one function. - Skilled in implementing Vision API for image processing. - Strong understanding of data processing in GCP.

...need to create a plugin that will handle the matching of products with the specific types of cars. The types of cars 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...

I am looking for a Shopify + Wordpress developer with specific expertise in custom theme development. The ideal candidate will have experience in the US time zone and be available for full-time work. Specific requirements for this project include: - Custom theme development for Shopify - Familiarity with app development for Shopify - Store setup and configuration Industry experience is not a requirement for this project, any industry experience is acceptable. In order to separate spammers from real candidates, if you agree with this statement please write it on top of your bid: "I am available to work in the US time zone and have X hours left available TODAY!" - where "X" is the amount of hours you have available for work today imm...

Pre-teens are a curious bunch, teetering between childhood wonder and teenage independence. Museums, with their vast collections and interactive exhibits, can be the perfect playground to ignite this curiosity and equip them with valuable life skills. But how do we transform a museum visit from a passive stroll to an active learning experience? This blog delves into life skills activities that pre-teens can engage in at museums, turning a casual outing into a springboard for future success. Unleashing the Inner Communicator: Debate Club in the Dioramas: Museums often have dioramas depicting historical events or ecosystems. Divide your pre-teens into groups and assign them opposing viewpoints related to the scene. Encourage them to research and prepare arguments based on the...

I would like to add new features to excalidraw. When importing SVG, I would like to add a function that can accurately recognize SVG's paths and curves and change the color and border color of each object. excalidraw_official site

I'm searching for a professional well versed in Excel to help with lookup functions. I'm struggling with finding matching values and retrieving data from different worksheets in a text-based file. Key parts of this project: - Locating matching values across two worksheets - Retrieving needed text data from another worksheet The ideal candidate will have: - Strong proficiency in Excel lookup functions - Experience dealing with data across multiple worksheets - Understanding of text-based data within Excel

I'm looking for an interior designer to revamp my small living room with an integrated kitchen bar. I'm particularly keen on a modern farmhouse style to add a cozy and contemporary touch to the space. Our space is full of glass window and with tilted ceiling, need something that highlights the space and also cosy we will add a TV on one of the walls ( size 98" inch ). Key Responsibilities: - Transform a small space (less than 500 square feet) into a modern farmhouse style - Design and redecorate the outside cabin living room - Creative integration of a kitchen bar - Ensure stylish and functional layout and interior elements Ideal Skills and Experience: - Proven experience in interior design, particularly with small spaces - Prof...

Main notes: - can be developed a variety of ways, but mainly wordpress is what I'm looking for. - should be easily accessible and usable on pc, phone, tablet. - requires the user to make an account with the website before its use. I am currently designing the website, and looking for this program to be created externally on wordpress or whichever way will fit in the budget. Important: Please only consider this project if you will are okay with the budget, and have read through the project outline. Thank you. Project details: basic functions: (the main function is to show what time the user has to work on their goals, and generate a schedule for them to use, factoring in all their tasks in their daily lives) - asks for users input on 'how dis...

Tasks : 1. Construct a queueing model that replicates a week of collecting and processing DNA samples. a. First develop a flow diagram of how the process works, from the reporting of a crime, to the eventual match/no match on the DNA database. b. Identify any conditional aspects of the process, for example if there are any stages of the process where resources only become available once the previous sample has been processed. c. Second, write out the relevant equations associated with each step of the process, and construct a formula for the overall time in system. d. Use relevant notation and write out equations using Equation Editor in Word. e. Note – the rule of thumb is that any reader can pick up your report and replicate your results by following the methods. 2....

I'm looking for a detail-oriented Excel expert to amend certain elements on my existing spreadsheet. Key tasks include: Data Entry Corrections: - Correcting inaccuracies in data entries. - Rectifying data location errors. Data Reorientation: - Shifting the format from a vertical to a horizontal layout specifically for data values. It would be ideal if you possess a keen eye for detail, advanced Excel skills including formulas, and a proven track record of spreadsheet data management. Experience in handling large copy-paste tasks will also be of great advantage. Due to the nature of this task, a meticulous and systematic approach will be required.

I need a skilled Wordpress PHP developer with experience specifically in manipulating Elementor widgets. Requirements: • Extensive knowledge of PHP to modify the existing functionality of an Elementor button widget. • Expertise in modifying Wordpress static pages. Objective: The current functionality of the Elementor button on my site redirects to an embedded iframe on a static page. I need an experienced PHP developer to modify this functionality. The new action should rewrite the URL for the embedded iframe on the static page once the button is clicked. This will require strong familiarity and expert knowledge of Wordpress, PHP, and Elementor, especially the button widget. Knowledge of JS could also be beneficial. If you believe you can effectively manipulate...

As part of my project, I need an expert in Excel to type data from various digital files into a spreadsheet, ensuring accuracy and efficiency. This data will be utilized for basic data analysis purposes, so it's important that the freelancer is comfortable with working on this type of data. Key Requirements: - Converting data from various digital files (PDF, Word, etc.) into an Excel sheet. - Proficient in using basic Excel formulas and functions to manipulate data for analysis. - Attention to detail and accuracy are critical for this task. Ideal Skills and Experience: - Proficiency in Excel - should be able to work with basic formulas and functions. - Prior experience in data entry or data analysis is a plus. - Strong attention to detail to...

I am currently experiencing an issue with my Drupal 7 website. Specifically, the website does not function properly after I moved its files & database, with dire impacts on the user login and registration process. I am unsure whether any changes to the configuration were made or the website URL was updated post-movement, hence I require knowledgeable assistance in diagnosing the cause of the problem and implementing the rectification. Ideal skills for this project include: - Extensive experience with Drupal 7, particularly in diagnosing and fixing functionality issues. - Strong understanding of website configuration and the implications of moving files & databases. - Expertise in fixing user registration and login issues. Dab name has been changed an...

...primary task will be integrating data from Excel spreadsheets and purchasing data from our suppliers. This will provide a comprehensive view of our spending patterns. Key Metrics: - The dashboard should enable real-time tracking of our total spend by category. This will allow our procurement managers to identify areas where costs are higher than expected, enabling them to take immediate action. Primary Users: - The dashboard will be primarily used by our procurement managers. It should be user-friendly and intuitive, allowing for quick and easy analysis of the data. Ideal Skills and Experience: - Strong experience in data analysis and visualization - Proficiency in integrating data from multiple sources - Familiarity with procurement processes and KPIs If you ha...

Productcatalog for technical parts and for automobile car/truck parts (lighting) Do you have experience in technical parts product catalogs? Than let us know and send us via message a reference catalog from you and the price for the layout, optional add the price for automatic eding via a productlist from excel with photos to create the catalog. Send us a message with a reference catalog, maybe german language catalog or for europe with technical parts products.

Here's what I need in a potential candidate for the job: - Experience in data entry involving Text, Numbers, and Images. Adeptness in managing a wide array of data types is crucial for this project. - Proficiency in Excel. This project requires all data to be entered into a specific Excel template that I will provide. - Detail-oriented skills and accuracy are essential. The data entered should be free of errors and align with the format that I will provide. Please ensure your bid reflects your experience and capabilities in these areas. Looking forward to a fruitful collaboration!

I have an Excel sheet full of text data that I need typed up. The data is currently in a PDF file, so you'll have to extract it from there. Once the data is in the Excel sheet, it needs to be organized into tables. Key Requirements: - Data entry of text from a PDF into Excel - Organizing text data into tables in Excel Ideal Skills: - Proficiency in Excel - Fast and accurate typing - Attention to detail - Experience with data formatting in Excel Looking for someone who can complete this task in a timely and error-free manner.

I'm in need of a graphic designer who can create a corporate-style brochure for my business. The main project will be to design a professional, clean and sleek corporate-style brochure. I'll provide the necessary information about the company's services, vision, and mission statement to be included. Ideal Skills: - Proficiency in graphic design software like Adobe Illustrator, InDesign, or Photoshop. - Experience in corporate branding and brochure design. - Excellent communication skills to ensure the design aligns with the company's objectives. - Ability to work efficiently and meet deadlines.

Create Financial Project on Excel

I'm in need of an experienced backend developer to create a mail parser with the following specifications: - **Email Protocol:** The mail parser should support SMTP, so proficiency in this area is a must. - **Primary Goal:** The primary function of this mail parser should be storing emails in a MySQL database. If you have experience with database integration, this would be a big plus. This project requires expertise in backend development, specifically with an understanding of how SMTP works. You should also be familiar with MySQL and have experience in integrating databases into applications. Please provide examples of similar projects you've worked on in your proposal. Thank you.

Do you want to convert any PDF, JPG, PNG, or image files Are you looking for any kind of document conversion or need editing in your documents, Yo...convert any PDF, JPG, PNG, or image files Are you looking for any kind of document conversion or need editing in your documents, You are on the right gig. MY SERVICES: ✅ Data Entry ✅ Web research ✅ Data Conversion ✅ Copy Paste Work ✅ Excel Data Entry ✅ JPEG to Excel or Word ✅ PDF to Excel or Word ✅ Real Estate Data Entry ✅ Language Translator ✅ Microsoft Excel ✅ Microsoft Word ✅ Lead Generation If you still have any questions or want to discuss prices for a custom project, don't hesitate to contact me. WHY ORDER FROM ME?? Fast Delivery, Never Late ✔ Message me if you're unsure or have project...

I'm seeking an Excel expert to help me with data analysis, formulas, and pivot tables. I work with Excel 2019. Key Responsibilities: - I want to see the mode of payment according to date wise in report sheet according to datewise Ideal skills and experience: - Proficient in Excel 2019. - Expertise in data analysis, formulas, and pivot tables. - Experience in creating automated reports or dashboards (desirable but not mandatory). - Excellent communication and problem-solving skills.

...information about the sellers on the Miravia platform (). This includes the shop_id shop_name Ivl1_cate_name product_number avg_price shipping_duration company_location phone_number email_address vat_number company_name shop_rating shipping_on_time % followers comments etc. I require 10,000 entries of data I require the data to be well-structured and organized into a CSV or Excel file for further analysis. Skills and Experience: - Proficiency in Web Scraping: The ideal candidate should have extensive experience in web scraping and data extraction. - Attention to Detail: Since the project involves gathering a wide range of data points, having a keen eye for detail is crucial to ensure accuracy. - Data Organization: Good data organization skills are also important to present

...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 Initiator engages the C...

Hi, Need a web dashboard for admin and customer. I am using 3proxy (Xproxy) as a proxy server API list - Main function will be the same with Admin site: Adding multiple 3proxy (xproxy servers to the web dashboard - API) + Create proxy via API + Add proxy from other suppliers + Rotation Link to change the IP of the port. + Validity of proxy - can be edited + User Management: The ability to add, remove and modify user accounts. +Billing and Subscription Management: Tracking customer payments, subscriptions, and related data. Proxy Status Monitoring: Real-time monitoring of proxy status. Customer dashboard: + Dashboard to overview: APIKey, APIkey count, account balance, Change Password