Excel multiple functions in one cell jobs
I am seeking an experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.8...
I need to make updates to userform so that empty dates do not affect filter on table. Right now leaving date field empty hides all the rows of table. Few more updates needed and more details will be shared with selected freelancer.
My Server that I access via remote desktop services has stopp...allowing remote desktop access. it was working fine for months, now it is not. the error message is: "NO remote desktop license server is available. REmote desktop services will stop working because this computer is past its grace period and has not contacted at least a valid windows server 2019 License." I had this issue before about 4 months after I initially set up the server, I went through multiple steps to register and it began working again for the past 5 months or so, and now it has stopped again. I need someone to help configure/reconfigure the server properly to allow remote desktop to function properly. I have physical access to the server and can work at that server terminal to give you acce...
... Key Requirements: - Experience with designing for Facebook, Instagram, Twitter, and LinkedIn - Proficiency in creating minimalistic graphics - Ability to work with specific colour schemes and branding guidelines Your role will involve: - Understanding the provided colour schemes and branding guidelines - Creating a variety of visuals for posts, stories, and ads on the specified social media platforms - Ensuring all designs are modern and minimalistic in line with the overall theme Ideal candidates would be able to take the provided colour and branding guidelines and translate them into engaging and effective social media content. Experience in creating visual content for multiple platforms would be a big plus. Looking forward to seeing your portfolios and...
...of appropriate color options for the brand (see brand theme above), 2 -3 colors per design > The design should be effective in black and white as well as color > The design should be recognizable even at very small sizes > Designs with contrasting elements which lead the eye toward the center of the icon are preferred. > The core design should be in vector format, with .ai (CS3 compatible) and .eps formats required. Other formats are welcome and appreciated. > Fonts used should be identified and either commonly and freely available or be included with the design files. >>> Submissions should be made as soon as possible, <<< as they need to be reviewed by multiple parties before a decision is made. Early submissions will have a ...
I'm looking for a data scraping specialist proficient in leveraging social media platforms, business directories and website scraping. The goal is to create an Excel sheet with approximately 500 entries for market research purposes. Skills & Requirements: - Proficient in data scraping from multiple sources - Capable of filtering and sorting data - Able to extract and compile the following data fields: zip codes, locations, contact information, business name and industry. The successful candidate should demonstrate experience in similar projects, showcasing their ability to find and compile information efficiently and accurately for market research purposes.
I am in need of a creative and professional video editor to assist in repurposing one of my videos into five smaller, engaging marketing videos. Purpose: - These videos will be used to promote a specific product or service across multiple platforms. Platforms: - The final products will be optimized for social media, web and also suitable for email marketing campaigns. Audience: - Specifically targeting age group 36-45 and above. Therefore, the design, tone, and messaging of the videos should be relatable and appealing to this demographic. Ideal Skills: - Proficiency in video editing softwares - Solid understanding of digital marketing and social media trends - Experience in creating content for age group 36+ - Ability to deliver on time, mai...
This is my website link I have used "Classima – Classified Ads WordPress Theme" theme. I want to upload date from xls sheet. Excel attached for your reference. Raduus Theme is not providing support and they only provides category and location import options. Can you help me to import data
...primary features that I'm looking for: - **Real-Time GPS Tracking**: I want my users to be able to track the delivery of their food or the location of their cab in real-time. - **In-App Payment System**: A seamless and secure payment system that ensures a smooth transaction experience for my users. - **Ratings and Reviews**: A feature that allows users to rate and review the quality of both the food delivery service and the cab service. Ideal Skills and Experience for this job: - Proficiency in developing cross-platform applications for iOS and Android. - Experience in integrating GPS tracking systems. - Previous work in developing in-app payment systems. - Understanding of how to implement a user-friendly rating and review feature. - Kno...
I've got a list of company names on an Excel sheet that I need you to help me with. Here's how you can assist: - **Scraping from Multiple Platforms**: I need you to scrape email addresses, phone numbers, and any available social media accounts of these companies. You'll need to do this across Yelp, Google Maps, and TripAdvisor. - **Social Media Scraping**: In addition to the primary two platforms (Instagram and Twitter), I'll also need you to scrape Facebook accounts if available. Ideal candidates for this project should have: - **Web Scraping Experience**: A good knowledge of web scraping techniques and tools, which will ensure you can obtain accurate and reliable data. - **Data Mining Knowledge**: The ability to identify and extract the necessa...
DA upto 40 DR upto 60+ TF upto 40+ CF upto 35 UR upto 70+ PA upto 35+
I am looking for an experienced PHP developer to help me domify some software. Specifically, I need an inventory management system...some software. Specifically, I need an inventory management system built from raw PHP. Key Features: - Inventory management: I need a system that can help me keep track of my inventory in real-time. This system should be able to handle multiple products and update their status as needed. Current Inventory Management: I am currently using another software to manage my inventory. However, it does not meet my needs and I am looking for a more tailored solution. Ideal Skills: - Strong proficiency in PHP - Experience with building Inventory Management Systems - Knowledge of raw PHP If you have experience in building similar systems,...
...experienced freelancer to develop and implement a robust outgoing predictive dialer system for our call center operations. The ideal candidate will have a strong background in telephony systems, database management, and CRM integration. The dialer should support dynamic caller ID, IP whitelisting, multiple campaigns, and a minimum of 10 representatives. **Responsibilities:** - Develop an outgoing predictive dialer system that integrates with our existing telephony infrastructure. - Implement dynamic caller ID functionality. - Ensure the system supports IP whitelisting for added security. - Configure the dialer to handle multiple campaigns simultaneously. - Integrate a basic CRM to manage and search client information efficiently. - Ensure the system can support a ...
I'm looking for a web designer/developer to redesign an IT company's website. The current site has plenty of ...the current content and functionalities. - We have had lots of SEO work done throughout the years and we would like to keep as much of that progress as possible, as well as add in some new SEO efforts. - Emphasis on mobile responsiveness: The new website must be highly responsive on all mobile devices. - An organized navigation that is less confusing then the current is a major focus for this project as well. The current site is www.rivell.com. The most creative/functional submission will be rewarded and expected to work with us on edits and changes that we feel are necessary to keep/enhance the current functions of the site. This not only for design...
I'm seeking professional help to rectify a problem with one of my programmes which is presently operational on a Windows 8.1 environment but doesn't launch on Windows 11. I'm not certain about the original coding language as I skipped that question, making it necessary for the freelancer to have adept skills in multiple languages, mainly in C++, Java, and Python. I'm also unsure about specific software or hardware dependencies that might be influencing the situation. However, the freelancer must have the expertise to identify and handle this potentiality. As for specific program functions, the user left a gap as well, so an experienced developer in generic software protocols and universal functions would be highly app...
...my project. Key Sections: - Market Analysis: You'll need to conduct comprehensive market research and present it in a succinct, engaging way. - Business Model: I need a clear, concise explanation of how my business functions, generates revenue, and its scalability. - Financial Projections: It's crucial that the pitch deck includes realistic financial projections and data to back them up. - Technical Concept: The technical aspect of the project will need to be explained in a way that non-technical investors can understand. - Unique Selling Proposition (USP): You should highlight the unique value that my project brings to the market and why it's a worthwhile investment. In terms of the length, I'm looking for something between 5-10 sl...
I'm seeking a talented audio engineer to mix and master my pop Hindi song. Key Project Details: - Genre: Pop - Audio Quality: The final mix and master should be in WAV format. - Vocal Tracks: There are 10 vocal tracks in the song. Skills and Experience: - Proven experience in mixing and mastering pop songs. - Experience in working with multiple vocal tracks. - Proficiency in audio editing software. - Understanding of Indian music genre preferences is a plus, but not required.
I'm in need of a proficient recruitment specialist to assist in a brand awareness campaign. The goal of this campaign is to increase recognition of our brand. The target audience for this brand awareness campaign are specifically drivers. Searching for an expert in either recruiting or marketing. (Please carefully read the following task before submitting any offer or asking about this project) Project: Develop a targeted recruitment campaign for drivers and establish my company’s brand in a local market with a population under one million. Company Type: A local transportation company that uses an on-demand app for providing services. Company Operation description: We’re not competing with Uber ...
...experienced in working with the Solana network and trading bots, with a mandatory requirement of being knowledgeable about the Pumpfun platform. Responsibilities: Create a bot/tool to manage trading from multiple wallets on the Pumpfun platform. Enable the bot to generate multiple wallets. Configure Solana quantities to buy per wallet. Develop an auto buy and sell bot to make a project appear legitimate with many sales and buys, thereby boosting projects. Ensure speed execution on the first buys to avoid snipers. The initial buys will be made from different wallets in varying quantities, with all transactions going through simultaneously or with a few seconds' difference. Allow for auto-tipping and prioritization in fees. Enable P&L visualiza...
I have an protected password .mpz format that I need to have the program can unlocked and converted into a readable format, preferably Excel or CSV. - The file contains both textual and numerical data, so I need the converted file to maintain this integrity. - I intend to use the data primarily for reporting purposes, so it is essential that the conversion is accurate and all data is preserved. I'm seeking a skilled professional with experience in file format conversion and data handling. The ideal freelancer should be proficient in Excel and adept at handling mixed data formats. This project is crucial and I'm looking for someone who can deliver a high-quality and precise conversion.
...specialises in Facebook advertising. The aim is to produce an advert which can be translated into multiple languages to target different countries. The ad is for a downloadable video course, for those whose native language is not English, teaching what to say in a job interview in English. Predominantly my market would be working professionals aged between 25 and 50 who are likely to have to attend job interviews in English. Main tasks would be : - Creating an engaging Facebook ad - zeroing in on target group of potential customers (possible later task) - designing an effective landing page for ad clicks current page (in Italian) can be found at I can provide a translation in English later
I need an email validator that validates multiple emails, preferably done in C#. As stated above, I need a system that validates whether the email exists or not. The system must be practical and easy and must have a license management system, which I can generate. I want only people who pay some plan for the system to be able to use the software.
I have a ...plan drafted on which I want to have converted into Excel. The Excel file should mirror the plan in all aspects, including costs, expenses, revenue, and financial projections. Key Requirements: - The Excel file should be a faithful recreation of the original financial plan, ensuring that all details are accurately transferred. - It should include all costs, expenses, revenue figures, and financial projections. - You will need to have experience in financial planning, specifically in converting plans from to Excel. To be clear: I do not need business plan development, I need mostly technical work of converting one form of financial plan to the other (Excel file). Specifics: - I do not need any charts in t...
I am seeking an experienced digital marketing professional who can effectively handle multiple areas of digital marketing. This includes: - SEO: Enhancing the visibility and ranking of my website on search engines. - SEM: Implementing strategies that increase the reach and visibility of my ads. - Social Media Marketing: Creating engaging and shareable content for various social media platforms to build strong relations with the audience and increase followers. - Blogging: Producing high-quality blog posts to engage readers and increase site traffic. - Web Editing: Tweaking and enhancing the website for a more user-friendly experience and better SEO performance. - Email Marketing: Developing and managing effective email marketing strategies to boost customer engag...
...features in real-time on our site. Requirements: Model Specifications: A highly detailed 3D model of a chair. Different textures and materials for customization (e.g., fabric, leather, wood). Multiple chair leg options (e.g., wooden, metal, various designs). UV unwrapped and properly textured for high-quality rendering. Technical Requirements: Formats: FBX, OBJ, and any other formats compatible with web-based 3D viewers. PBR Texturing: BaseColor, Normal, Roughness, and Metalness maps. Optimization for real-time rendering (low-poly options if necessary). Ensure compatibility with WebGL or similar web technologies for interactive customization. Functionality: Ability to switch between different textures and materials seamlessly. Ability to change chair legs and other cust...
...mechanical design project. The project involves selecting an appropriate architecture for various linkages, creating a CAD model of a mechanism, and effectively communicating through technical drawings. Project Requirements: Architecture Selection for Each Linkage Estimated Time: 3 hours Evaluation Criteria: Creation of a simplified specification sheet Identification and characterization of functions and constraints Hierarchization and creative problem-solving using FAST diagrams Proposal of solutions with clear schematics and sketches Value analysis including criteria, scoring, weighting, and reasoned choices Synthesis of selected solutions CAD Modeling of a Mechanism Estimated Time: 8 hours Evaluation Criteria: General appearance and manufacturability of parts Quality and c...
I've been trying to validate my YouTube channel with multiple phone numbers, but it seems impossible. The channel mainly focuses on gaming content. I'm looking to hire a freelancer to help me with this issue. Ideal Skills and Experience: - Previous experience with YouTube channel verification - Strong understanding of YouTube's verification process - Knowledge of YouTube's policies and guidelines Looking forward to your bids.
I'm in need of a skilled UI/UX designer proficient in wireframing, prototyping, and conducting user research. You will be working in accordance with our existing brand guidelines, ensuring a seamless integration of the new designs into our brand image. This is a bit of a dual platform job as you will be designing for both desktop and mobile interfaces. Experience in designing for multiple platforms is much desired. A sharp eye for detail and ability to create user-friendly, engaging design are the key skills needed for this project.
I'm in need of a 3D artist who can create a basic product model for me. This model should be able to be viewed from different angles. Key Requirements: - The project involves product modeling, so experience in this area is essential. - The model needs to be created with basic shapes and forms. No complex detailing or textures are needed. - You must be able to generate multiple views of the model, allowing me to see it from different perspectives. Ideal Skills and Experience: - Proficiency in 3D modeling software, such as Blender, Maya, or 3ds Max. - A strong portfolio demonstrating previous experience with product modeling. - A keen eye for detail and the ability to follow design specifications accurately. - Excellent communication skills to ensure my req...
I'm looking for an Indian professional WordPress developer who can help me with a couple of issues on my site. Key Requirements: - Fixing a bug causing the website ...main issue I need addressed is the slow loading time of my website. This should be the primary focus. - Speed optimizations should be applied to the homepage as a top priority, but I also require this across other pages of the site. Ideal Skills and Experience: - Proficiency in WordPress development and bug fixing. - Experience in optimizing website speed, including image and media optimization, content caching, and server response time reduction. - Proven track record of improving website performance across multiple pages, with a keen eye for detail and thorough testing. Please share your rele...
I'm in search of a professional to create monthly sales reports in Excel. We need to create several tables starting from the attached files starting from input file 1 1- In input file 1 you need to filter the data in column B and take into consideration only "Order payment" and "Refund". 2- Filter the rows of input file 2 (attached), column D "Product Details" so that the different product details appear only once and report them in the VAT output file so as to have only 2 Product Name columns (in which the "product details of input file column 2" are listed. (example VAT file attached) 3- The app must check that all the lines present in column D "Product details" of the input f...
I'm seeking a skilled designer who can create a multiple business logos from WWII era vintage-styled military art combined with modern day technology. It should be crafted in color, eliciting a classic yet modern feel. If you specialize in vintage designs and or blending multiple design elements together, this project may be an excellent fit for you. Key skills required: - Expertise in vintage logo designs - Creativity in using abstract geometric shapes - Ability to work with color palettes.
...simplistic, user-friendly, and designed to cater to B2B customers. The primary purpose of this website is to serve as a platform for displaying multiple products from our brand. There will be no ecommerce functionality - it's more about showcasing the products than selling them. Here's what I'm looking for: - A simplistic, easy to use layout that still looks professional - A design that specifically caters to B2B customers - The ability to display a variety of products without overwhelming visitors - A responsive design that looks good on all devices - SEO-friendly structure and content Ideal Skills: - Proficiency in Wordpress and its themes - Experience in creating B2B websites - Design ability: keeping it simple, yet professional - Knowledge of ...
...logo designer to create an iconic/symbol representation logo for my brand. Ideal Skills and Experience: - Extensive experience in logo design - Expertise in using color psychology in design Specific Requirements: - The logo should serve multiple purposes, including brand identity, marketing materials, and website use. - The color scheme is already decided, but you need to have an understanding of color matching and visual appeal. - You should be able to create a visually captivating, yet simple, iconic/symbol representation logo. - An understanding of my brand and vision is essential to create a logo that reflects our values and appeals to our target audience. In your proposal, please feature past examples of iconic logo design and demonstrate how ...
...The ideal candidate will have a proven track record in managing and optimizing paid advertising campaigns on Google and Facebook to generate high-quality leads. You will be responsible for strategizing, executing, and analyzing ad campaigns to drive conversions and achieve business goals. Responsibilities: Campaign Strategy and Planning: Develop and implement comprehensive lead generation strategies using Google Ads and Facebook Ads. Conduct market research to identify target audiences and create detailed customer personas. Set clear objectives and KPIs for each campaign to measure success. Ad Creation and Management: Design, write, and test compelling ad copy and creatives tailored to various audience segments. Set up and manage multiple ad campaigns across Google Ads...
I'm in need of an expert blockchain developer, specifically experienced in Solana, to work on a bot development project. The key functionalities of this bot will focus on trade execution. Key Project Details: - Primarily, you will be working on a bot that executes trades within the Solana ecosystem. - Familiarity with Jito Bundles, Raydium, and Jupiter DEX is a huge plus. - The bot should be developed using Node.js. Requirements: - Proficient in Solana blockchain development. - Strong expertise in Node.js. - Proven experience in developing trading bots. - Prior experience working with Jito Bundles, Raydium, and Jupiter DEX is highly desired. - A good understanding of trade execution strategies in the blockchain context. Please note: - The ...
...offers a unique opportunity to further develop your career in the field of drug safety. Key Responsibilities: Independent authoring, editing and reviewing of various regulatory/clinical documents (e.g. aggregate reports, risk management plans and other documents needed throughout the product’s life cycle) with the responsibility for the quality and content of the document and compliance with internal and external standards. Active participation in trainings and development, implementation and maintenance of quality system documents for medical writing, including internal templates and formats required for standardized documentation. Support in all pharmacovigilance operations associated with medical writing. Continuous self-education in all aspects asso...
...involves HTML, CSS, JavaScript, and some light database functions. The work will mainly focus on: - Implementing text input fields and dropdown menus: These are crucial elements for user interaction and data input. Your job would be to make them look and function as required. - Basic database functions: While the exact nature of these is yet to be decided, they will likely include retrieving and adding data. Your task will be to integrate these functions seamlessly into the site. Ideal skills for this project would include: - Proficiency in HTML, CSS, and JavaScript, with experience in creating user-friendly and responsive UIs. - Familiarity with basic database manipulation. - Good communication skills, as we'll need to discuss the project in...
I'm in need of a freelance writer to craft an engaging, informative article on boardrooms. The key aim is to provide general information for the public. Key Requirements: - The article should cover a detailed explanation of the full function of a boardroom. - It must be educational yet engaging, appealing to a wide audience. - The focus should be on clarity and simplicity, making complex concepts easily understandable. - I will need a turnaround time of 4 days. - Needs to be between 1,500 and 1,800 words - Must use 3 to 5 references in the article that will be provided upon awarding of the project. Ideal Skills and Experience: - Proven experience in creating engaging, informative articles. - Good understanding of business terminologies, specifically boardroom ...
I have an Excel sheet that requires data filtering. From One sheet i want the following 1) Deletion of few records with some keywords 2) Make one sheet with unique data 3) No of repeated records. 4) Mobile number format to be changed
I am seeking a proficient Pine Script specialist with a proven track record in creating high-accuracy indicators for TradingView. The goal is to produce an indicator that can deliver buy and sell signals with exceptional precision, particularly when applied to short timeframes ranging from 1 to 5 minutes. Key Requirements: - Development of a Pine Script Indicator: The main task is to design an indicator that generates both buy and sell signals. The accuracy of these signals is crucial, and they should be specifically tailored for the 1-5 mins timeframe. - Incorporation of Multiple Trading Indicators: While I do not have a specific strategy in mind, the ideal candidate should be well-versed in using a variety of indicators to create a robust and reliable tool. -...
I need a ...for this job: - Proficiency in website design and development - Previous experience in correcting website layouts - Attention to detail and ability to follow specific instructions - Excellent communication and ability to work collaboratively - Familiarity with HTML, CSS, and any other relevant programming languages Your responsibilities will include: - Adjusting the layout of the homepage to ensure that the website looks professional and functions seamlessly - Following Google Business account guidelines to link our website with our Google Business account - Making small corrections and adjustments to perfect the layout I'll provide you with more specific details once we start working together. I look forward to receiving your proposals and discussin...
Develop a WeChat/Alipay app for a large-scale event in Hong Kong, you need to use it on WeChat/Alipay. It can be used by people in Hong Kong, Macau and China. The functions are mainly used to view event information, videos, reminder functions, mini games, contact customer service, and connect Department external website
...using the provided SDK and API keys. The primary goal is to ensure that the payment gateway functions properly and securely, without any errors, and provides a flawless user experience. Requirements: Proven experience in integrating payment gateways, preferably with Tap or similar services. Proficiency in the programming languages and frameworks used in my application (please specify if it's for Android, iOS, or a cross-platform framework). Strong understanding of API integration and handling secure data transactions. Ability to implement the payment gateway according to the documentation provided by Tap. Ensure the application functions correctly with the new payment gateway, including thorough testing in both sandbox and production envi...
I need someone to enter 500 purchase invoices into an Excel spreadsheet. I will provide a template for the format. The invoices will be sent to you as digital files through a cloud service, which you'll use to input the basic details like date, vendor, and amount. Ideal Skills and Experience: - Proficiency in Excel for accurate data entry - Experience in processing financial documents - Attention to detail to ensure data accuracy - Ability to handle sensitive financial information with confidentiality - Familiarity with using cloud services for file management Please let me know your experience with similar projects and how you plan to ensure the quality and efficiency of the data entry process.
...may code using JavaScript, HTML5 or using Python, so experience or proficiency in this language is crucial. Key Requirements: - Users should be able to drag and drop objects using mouse or in case of mobile- fingers. - It should offer a moderate level of interactivity. This includes features such as adjusting quantities and temperatures. If a user pours something in a beaker, it should show the beaker full. If emptied, beaker is empty. - Vector images of lab equipments like Test tube, beaker, burner etc can be found online. Ideal Skills: - Proficiency in Python or JavaScript. You may use CreateJS libraries. If you are a programmer with a passion for chemistry, this is a great opportunity to combine your skills in programming and knowledge of chemis...
...the local machine and can sign PDF, XML, JSON, and Text files in bulk and with the following additional features: - Bulk Signing: It should support signing multiple files at once, with no specific limit. - Predefined Output Path: Users should have the option to assign a default output path for the signed files. - PDF Signature Display: For PDF documents, the utility should display the signature as an optional feature. The goal is to have this utility developed within a month. Ideal skills for this project include: - Proficiency in programming languages suitable for file processing (e.g. Python, Java) - Experience in developing software utilities or tools - Familiarity with e-signing mechanisms and standards - Prior experience in working with PDF,...
I'm looking for a skilled Excel expert to create a project tracking sheet with a calendar section that lists weekly milestones. Key Features: - The main sheet is for tracking project progress. It should include: * Project /Task Name * Start Date * End Date * Progress (percentage) * Priority * Action plan * Comments - The calendar section should list team schedule. * Team working schedule "in office / out of office" * Team calendar "working remotely, annual leave, business trip, public holiday, overtime" Excel Automation: - I need the Excel sheet to have automated functions: * Conditional formatting for visual tracking: Changes in cell color or font based on the progress percentage, to quickly...
