Count colored cells in google sheets jobs
I am in need of an experienced videographer to help produce multiple engaging live-action videos for social media content. * Video Type: The videos will be live-action. The candidate should have proven expertise in filming and editing high-quality live-action content. * Purpose: The main goal of these videos is to tell engaging stories. Ideally, you should have a knack for storytelling to evoke emotions and engage our audience. * Duration: Each video will have a duration of less than one minute. You should be effective at conveying the story within a compact timeframe, making every second count. * Required Skills: Previous experience producing live action short videos, storytelling abilities, and the capacity to deliver a meaningful message in a limited ...
I'm looking for a Google Ads expert who can help me create and manage a video ad campaign with the primary objectives being to enhance brand visibility and drive more traffic to my website.
I need a Google Sheets expert to help me put together an extensive and detailed cricket schedule for the upcoming English summer season. Tasks Include: - Including International, Domestic, and Club tournaments and teams in the schedule - Organizing fixtures based on the date Additional Details: - Each fixture should have comprehensive information about the venue - Match timings should be included - Broadcast details for each match should be provided Ideal Skills: - Proficiency in Google Sheets - Knowledge of cricket and its various tournaments - Attention to detail to ensure that all necessary information is included - Time management skills to complete the project in a timely manner more details--- ### Task Description: Google ...
I'm in need of an experienced PowerPoint designer to create a captivating presentation for a product demonstration. Key Requirements: - **Slide Count:** The presentation will consist of 10-20 slides, so it's important that the designer can effectively communicate the product's features and benefits within this scope. - **Branding Guidelines:** While I do have specific branding guidelines, they're focused on colors and logos alone. The ideal freelancer will be able to incorporate these elements into the design without compromising the overall quality of the presentation. The ideal candidate will have: - Proven experience in creating professional, high-quality PowerPoint presentations. - An understanding of how to structure a presentation for a p...
We are looking for developers who are proficient in WooCommerce and Google Sheet API to help with our ongoing project to improve some of it's functionalities and features. Key Responsibilities: - Assist in setting up WooCommerce functionalities on a website, including product catalog, shopping cart, and payment gateway integration. - Implement integration with Google Sheet API for specific data processing & syncing requirements. Ideal Candidate: - Proficient in WooCommerce, including setting up product catalog, shopping cart, and payment gateway integration. - Experienced in integrating external APIs, specifically Google Sheet API, App Scripts Programming. - A good understanding of data processing and how to leverage Google...
I am in need of a skilled professional who can assist me in setting up the Odoo Books system for my invoicing processes. Requirements: - Configure the system to enable the creation of goods and service invoices in USD. - Implement moderate customization to the invoice templates, focusing on layout changes and adding custom fields. - Import all of my product information from an Excel sheet. This includes product names and their respective cost prices (which are in INR). - Enable and Teach me to Use Odd's OCR feature to fetch pdf data from invoice to transfer it to software Ideal Candidate: - Proficient in working with Odoo Books and setting up invoicing processes. - Experience with customizing invoice templates within Odoo. - Skilled in da...
I need historical stock prices and income statement data, deliver python script to collect this data for an arbitrary stock from google finance.
--- ### Job Title: Excel Sheet Creation for Job Tracking and Payment Calculation **Description:** I need a custom Excel sheet to help me track jobs completed by my installers, including details about eac...customer name, address, and account number. 4. **Summary:** - A summary section that provides totals for jobs completed and payments owed for easy reference. **Additional Features:** - The ability to filter and sort jobs by date, installer, or customer. - An input form for easily adding new job entries. **Skills Required:** - Proficiency in Microsoft Excel, including formulas and data validation. - Experience creating user-friendly and automated Excel sheets. **Deliverables:** - A fully functional Excel sheet as described. - Instructions for use and any necessary d...
...quick bit of help needed in excel macro writing. See attached before and after showing a piece of the original data. and what i neeed the macro to achieve. WHAT IM ASKING If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplicate row. AEE ATTACHED png. I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency. Essential skills and experience should include: - Expert knowledge of Excel and its macro functionality - Prior experience with data manipulation tasks such as merging cells - Understanding the rules or criteria...
Hello, This is a $20 project. Looking for a freelancer to develop a python script to retrieve restaurant data from Google Maps using the Maps/Places API. The script should target restaurants that have a phone number and *do not* have a website. The inputs I need to enter are: - Location (latitude and longitude) - Search Radius (in meters) - Ensure the business/place is a restaurant, bakery, etc. Key Data to Retrieve, output in a .CSV: - Business Name - Address - Phone Number - Google Maps URL Thank you, trooper501
Seeking an expert to boost our follower count across various social media platforms. Our primary focus is to attract followers from IT companies. Key Responsibilities: - Drive our follower count up significantly, particularly targeting IT companies. - Enhance our brand visibility within the IT sector through social media. Skills Required: - Proven track record in growing social media followers, particularly within the IT industry. - Understanding of effective strategies for boosting brand awareness. - Excellent knowledge of various social media platforms and their algorithms. - Strong communication skills, capable of engaging with followers. - Familiarity with the IT industry would be advantageous. Ideal Candidate: The ideal candidate will be a social media expert ...
I'm looking for a Google Ads expert to review my Google Ads account focusing on campaign structure and target audience to enhance lead generation. Specifically, I'm looking for someone to review in comparison to another specified month where campaigns were much more successful. Key Areas: - **Campaign Structure**: Your task would be to evaluate and provide feedback on the overall structure of my existing campaigns. This includes the organization of ad groups, the relevance of keywords, and the alignment of ad creatives with the campaign goals. - **Target Audience**: I need a detailed examination of my target audience. This would involve assessing how well my current targeting aligns with the interests and behaviors of my ideal leads. You will be expected to...
I am looking for a professional who can build a web application that automates the creation of Google Sheets formulas. Requirements: - Build a web application that allows me to input a plain text command in a Google Sheets cell (i.e., I type "= find the mean of the data above". - Translate the plain text command into a Google Sheets formula using the ChatGPT API. - Authenticate and send the formula to Google Sheets for execution. Ideal candidate: - Proficient in web application development. - Experience with integrating APIs, particularly ChatGPT. - Familiarity with Google Sheets automation and formula creation. - Strong understanding of user interface design for a seamless user experience.
I'm looking to integrate Open AI capabilities with Google Sheets to create an AI assistant that can provide our customer real time inventory information when asked. Key Project Details: - The main task of the AI assistant will be to provide real-time inventory information from Google Sheet that contains our inventory data. Ideal Skills: - Solid experience with Google Sheets API - Proven track record of integrating AI tools with external data sources - Understanding of real-time data processing and automation - Familiarity with predictive inventory management would be a plus I'm looking for a freelancer who can bring both technical expertise and creative problem-solving skills to this project.
As a creator focusing on educational content, I'm looking to further optimize and enhance the search visibility of my channel. Despite my channel already having high visibility in search results, I believe there's room for improvement in attracting more subscribers. The primary aim of this project is to increase my subscriber count. Key Requirements: - Enhancing SEO: The ideal freelancer should have a strong background in search engine optimization (SEO) techniques specifically tailored for YouTube. - Analyzing Current Metrics: Proficiency in analyzing YouTube analytics is a plus, to identify areas of improvement and capitalize on existing strengths. - Content Strategy: Suggesting and implementing strategies to maintain high visibility and att...
I'm seeking a skilled individual to assist in increasing my Telegram member count. The main goal of this promotion is to attract Crypto Enthusiasts to my channel. Key Requirements: - Experience and success in increasing member counts for Telegram channels. - A good understanding of the crypto market and community. - Ability to personalize direct messages based on the recipient's interests. - Strategies for engaging with potential members in a non-intrusive way. Your main tasks will include: 1. Identifying and reaching out to potential members within the cryptocurrency community. 2. Engaging with these individuals through personalized direct messages. 3. Encouraging them to join our Telegram channel. Personalization is key, and I believe that underst...
...According to Article 8 of the UAE Arbitration Law, “1- A Court before which a dispute is brought in a matter covered by an arbitration agreement, shall declare the inadmissibility of the action, if the defendant has raised such plea before submitting any request or defence on the substance of the case, and unless the Court finds that the arbitration agreement is void or incapable of being performed. 2- Where an action referred to in the preceding Clause has been brought, the arbitration proceedings may nevertheless be commenced or continued, and an arbitral award may be made”. This provision is parallel to Article 8 of the Model Law which provides that “(1) A court before which an action is brought in a matter which is the subject of an arbitration...
...manage and promote my Etsy shop, as well as open my google business shop. I have an inventory of handmade and unique items, and I need help with both platforms for better visibility and improved customer engagement. Your tasks would primarily include: - Inventory Management: Keeping track of existing inventory, update listing details if necessary and coordinate to replenish stock. Knowledge of Etsy’s listing system is necessary. - Promotion: Create and execute Social Media promotion strategies for both Etsy Shop and Google Business. You should have experience in leveraging different social media platforms for business promotion. Ideal candidate would have prior experience managing Etsy shops and Google Business listings, with proven results in...
I'm seeking a skilled political cartoonist to create a 3 to 4 frame, colored cartoon. This project focuses on liberal viewpoints regarding national political figures. I need someone who can humorously yet effectively convey political messages through their illustrations. Ideal skills and experience include: - Extensive background in cartoon drawing - Understanding of national politics and liberal perspectives - Ability to translate complex issues into easy-to-understand, engaging, and humorous visuals - Strong coloring skills to create vivid and appealing illustrations. Please provide samples of your previous work, especially if they involve political cartoons. This will greatly help me in making my decision. Thank you!
I'm in need of a talented financial analyst to create a robust underwriting model for a multi-family property. Key Requirements: - Develop a comprehensive underwriting model for a multi-family property that will assist in calculating the internal rate of return (IRR) and equity multiple. - This model should also include waterfall projections that cover profit splits, with and without preferred returns. Additionally, I require a clear, user-friendly format that is easy to understand for someone without an extensive financial background. The ideal candidate for this project should have a strong background in finance, specifically in multi-family real estate. In summary, the main deliverables for this project are: - Underwriting model for a mul...
...help me resolve an issue with Google Login on my Android app. -When we generate release version of the APK Login with Google works perfectly, but upon publishing it to the Google Play Store, it encounters issues. The error message encountered is: PlatformException(sign_in_failed, com.google.android.gms.commeon.api.b:10:, null, null). Ideal skills and experience: - Proficiency in Flutter and Dart - Experience with Google Login integration in Flutter - Ability to troubleshoot and resolve authentication issues - Strong understanding of Android app development - Good communication skills and the ability to collaborate effectively with the rest of the team. If you believe you have the expertise and experience to tackle this problem effectively,...
We're upgrading our university students' house search web application. Our ideal freelancer comes with an extensive working knowledge in , Firebase authentication, and CSS modules. Expectations include: - Enhancements: Building registration and login feature using both email registration and social media login with two-factor authentication. - Search Functionality: Creating advanced search filters for Location, Price Range, Bedroom Count, University Proximity, and City. - Property Listing: Developing a property listing and management feature. - Database: Setting up and integrating Firebase for data management. - Mobile Responsiveness: Ensuring the site performs optimally on all mobile devices. - Payment: Implementing payment options. - Community Features: Develop...
I'm in need of a skilled freelancer to embed a clean, sortable, and filterable table into my personal blog, which will continuously pull data from a Google Sheets document. The key points of the project are: - **Table Embedding:** The primary task is to take the data from my Google Sheets and convert it into a visually engaging table on my blog. This table should be easily filterable and sortable based on different columns. - **Automatic Updates:** The data in the Google Sheets will be changing daily. I need to ensure that the table on my blog automatically updates whenever the Google Sheets data changes. Ideal candidates should have experience with: - Data handling and visualization - Google Sheets...
I'm looking for a skilled professional to help create an app or web page that is primarily focused on data management. Key Requirements: - The app shoul...focused on data management. Key Requirements: - The app should allow users to interact through forms. It should be easy to use and intuitive. - The app should be able to integrate seamlessly with Google Sheets. This means that data collected through the forms should be stored directly in a Google Sheet. I'm looking for someone who has experience in: - Developing apps that are used for data management. - Creating forms that are user-friendly and easy to interact with. - Integrating apps with Google Sheets. If you have experience in these areas and are confident in...
I'm seeking a seasoned YouTube expert to help me grow my established channel. Currently, I'm aiming to significantly increase my subscriber count, views, and overall engagement. Key Deliverables: - Boosting subscriber count: Your goal is to actively increase the number of subscribers to my channel. This should be achieved through a mix of organic growth strategies, collaborations, SEO optimization, and more. - Increasing views: You should also work on increasing the views for my videos. This could involve improving the visibility of the videos, analyzing and improving the retention rate, and promoting the content across various platforms. - Enhancing engagement: Engagement is crucial for the growth of the channel. Your responsibility would be to encourage and maint...
Project Overview: I am seeking to have a custom Google Sheets system created for a group within a GTA V roleplay server. Our group imports special items for other groups, and we need an efficient way to manage these transactions. Requirements: Main Sheet: Buttons: Treasury Deposit/Withdrawal: A button that, when clicked, presents a dialog or an input field directly on the sheet to enter the deposit or withdrawal amount. Shipment: A button that allows users to input the following details: gangName memberName itemOrdered itemQuantity weightUsed currentWeight weightAfter orderedBy Automatic calculation of the total weight and price for each item (a list of items, their prices, and weights will be provided). TreasuryDB: A dedicated sheet to track all deposit and withdrawal ...
One month Google Ads work for a website
I need help setting up my nextjs website's cookie consent to be compatible with Google Consent v3. Key Requirements: - Write codes to setup cookie consent with google tag manager. - Ensure the cookie consent setup is specifically for Google Consent v3 compatibility. - Make sure the setup with Google tag manager. Ideal Skills: - Next js. - Familiarity with Google Consent Mode v3.
...facing some persistent issues with Google Search Console and I need an expert to help me resolve them. Key tasks involved: - Fixing Indexing Issues: There are some pages on my site that aren't being indexed properly by Google. This could be due to various reasons like crawling errors, server problems, etc. - Resolving Sitemap Errors: I've been receiving errors related to the sitemap of my website. This could be contributing to the indexing problems. - Addressing Mobile Usability Issues: Google has flagged some mobile usability issues on my site. I want to ensure my website is fully mobile-friendly and complies with Google's guidelines. Ideal Skills and Experience: - Strong understanding of Google Search Console: You should have a deep unders...
...seeking a skilled freelancer to help me standardize and improve the formatting of my Google Sheet. The main focus will be on creating consistent cell styles for optimal readability. Specific requirements include: - Implementing a minimalist and clean design theme throughout the sheet - Creating a uniform style for all cells, making sure the data is easy to understand at a glance The ideal candidate will have: - Proficiency in Google Sheets, with a strong understanding of formatting options and best practices - A keen eye for design and the ability to create a clean, minimalist look - Experience with data visualization and turning complex information into easily digestible formats If you're confident in your ability to transform a sprea...
I'm in need of a skilled SketchUp designer to help visualize and craft my small-sized vanity unit and Rosa-colored marble bathroom. It's a precise job, ideally suited for someone with: - Experience designing sumptuous and elegant interiors on SketchUp. - A keen eye for detail, respecting dimensions and aesthetic choices. - Familiarity working with marble integration, and a marble built in sink/bath Interested designers, please show examples of other bathroom and/or modern-small-space designs you've done. Appreciate your proposals!
I'm looking for an expert to create and oversee a Google Ads campaign for my e-commerce business. - Goal: The primary goal of this campaign is to increase sales. Your strategies should be geared towards this objective. - Target Audience: The target audience for this campaign is a national one. You should have an understanding of how to tailor ads to draw attention from across the country. Our customer base is largely Business to Business, and we are wanting to market Australia wide. - Google Shopping ads have traditionally worked well for us also. The ideal freelancer for this project should have demonstrable experience in managing Google Ads for e-commerce businesses, ideally in the industrial fittings industry, with a strong track record of in...
As a business based in the Grey Industry, we're looking for a Google Ads expert with a proven track record in lead generation. Key Requirements: - The main goal of our campaign is to generate B2C leads. Your experience in targeting and appealing to this demographic is crucial. - Expertise in Google Ads and a strong understanding of lead generation strategies is a must. - A background in the Grey Industry or similar industries is a definite plus, but not mandatory. Key Deliverables: - Develop a Google Ads campaign tailored to our B2C audience to effectively generate leads. - Monitor and optimize the campaign to ensure a high lead conversion rate. Skills and Experience: - Proven experience in successful lead generation ca...
I am in need of a skilled developer to create a customized inventory management app using Google AppSheet and MySQL. The app will cater to a user base of less than 50, but it needs to be designed and optimized for scalable growth. It should be intuitive, easy to use, and have a professional interface. Key features that need to be incorporated into the app include: - Real-time inventory tracking - Sales and purchase order management - Product barcode scanning As the app will be handling crucial data for my business, security and reliability are of utmost importance. The developer should have experience in creating and integrating secure databases, as well as a track record of building robust, scalable applications. The successful freelancer should have: - Proficien...
I have my kids channel which i want to grow in terms of views and subscribers. Key Requirements: Most Important- Increase in Views and Subscribers: I'm looking for a professional who can help boost my channel's visibility and subscriber count. Other optional - Content Strategy: I also need assistance in devising a plan to optimize my videos for increased visibility. - Target Audience Engagement: The content is mainly geared towards children, so the freelancer should keep that in mind when suggesting strategies. Ideal Skills and Experience: - Proven track record in increasing YouTube views and subscribers. - Previous experience with kid's content and understanding of engagement strategies. - A creative approach to promoting YouTub...
I’m currently sitting below 50 followers with an Instagram page focused on Art and Creativity. My main challenges are: - Boosting followers count - Improving post engagement The ideal assistant should have: - Proven experience in Instagram growth, especially for art-themed accounts - Proficient knowledge in Instagram's algorithms & engagement patterns - Capable of crafting strategies that can propel followers count and enhance post interactions In brief: Aim to develop a gainful footing in the Instagram Art circle featuring outstanding post engagement and a substantial increase in followership. Apply if you have a tested track record in delivering these outcomes.
I need a skilled 3D artist who can transform a 2D photo of a cou...should have advanced 3D modeling skills, capable of reproducing minor features evident in the original 2D photo. - Though the original image is colored, I want the 3D miniature to be in a single color only. Accordingly, a good understanding of shading and texture manipulation to replicate depth and feature details despite the lack of color diversity will be crucial. - The successful applicant should demonstrate experience in similar projects, emphasizing detail replication and the successful translation of 2D images into 3D forms. Turn around time, cost, and a portfolio of past work will be determining factors in who I choose for the job. I am excited to see the 2D image of a memorable m...
I am in need of an expert in Google Ads to help with lead generation for my software, which caters to enterprise companies. Key Requirements: - Develop and execute a Google Ads campaign focused on targeting enterprise companies. - Regularly monitor and optimize the campaign to ensure leads are being generated consistently. - Provide regular reports on the performance of the campaign, including the number of leads generated and the ROI. - Explain your actions at each step. Ideal Skills and Experience: - Proven track record of successful lead generation campaigns targeting enterprise companies. - Extensive experience with Google Ads, particularly in the B2B software industry. - Strong analytical skills to interpret campaign performance data and ma...
My Wordpress site has some issues. Also a lot error alerts in Google search console need expert to fix that
I want to make a Incentive structure in the attached excel. I am paying incentive to my staff. I have different types of incentive policy Each Incentive calculation is starting from the month "m" It will be accumulated and the Incentives will be paid on every month of "n" The process will start again and will repeat again. This process will depend upon the value that I am putting in the cells of "m" and "n". You have to correct the formula I have given in the sample or you can make a new formula
I'm seeking an experienced AI deve...Capabilities - Uses advanced AI algorithms to detect and interpret various elements within the slab plans. * Supports Multiple Formats - Must be able to process JPEG and PDF formats. * Comprehensive Detail Analysis - Capability to identify and count specific components such as void formers, reinforcement bars, and structural beams. Ideal Skills and Experience: * Extensive experience in AI Development, specifically in the fields of Object Detection and Text Extraction * Demonstrable experience in creating software that can process and interpret renderered images in multiple formats * Prior experience or understanding of construction plan analysis would be a significant advantage. Example slab design attached of w...
I am searching for a freelancer to enhance my local search rankings by creating and managing map citations on Google My Business to reach the top 3 positions with guaranteed results. If you cannot provide a guarantee, please do not apply for this job. Key Responsibilities: - Create high-quality Google Map Citations for my business - Ensure all information is up-to-date and accurate - Regularly monitor and update the citations to maintain their effectiveness Ideal Candidate: - Experience in local SEO and Google My Business - Proven track record in improving local search rankings through map citations - Detail-oriented and a stickler for accuracy - Capable of managing and updating the citations on an ongoing basis - Strong communication skills for reporti...
I'm in need of an Excel macro expert who can help me with a data arrangement task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logical conditions for accurate and efficient da...
As a TikTok Influencer Outreach Specialist, your main task will be to connect with influencers/KOLs on TikTok within the United States. Key Responsibilities: - Reach out to TikTok influencers with a follower count of over 5K - Encourage the influencers to accept a free premium product sample - Request the influencers to create video content around the said product Your role is pivotal in ensuring the success of our TikTok influencer promotion campaign. Ideal Skills and Experience: - Proven experience in influencer outreach on TikTok - Familiarity with the United States market and TikTok trends - Exceptional communication skills - Ability to close deals with influencers - Knowledge of how to negotiate and motivate influencers to create content Plea...
I'm in need of a skilled individual who is proficient in both PHP and Google Gemini. The primary task is to integrate this platform with my PHP website. Key requirements include: - Basic data syncing: The main goal is to ensure that the PHP website and Google Gemini can share important data seamlessly. This includes basic data such as user information, clicks, and impressions. The ideal candidate must have: - Demonstrated expertise in PHP and Google Gemini. - Prior experience in integrating Google Gemini with websites. - Strong communication skills to understand my requirements and provide updates on the integration process.
As a lifestyle content creator, my main focus is to increase the number of subscribers on my YouTube channel. Key Requirements: - Goal: The primary aim is to develop a strategy to organically increase the channel’s subscriber count. - Skill: You are expected to have experience in growing YouTube channels, particularly in the lifestyle niche. - Strategy: A well-thought-out plan to boost subscriber numbers is crucial. Your Expertise: - Experience: Prior experience in driving subscriber growth is essential. - Knowledge: An understanding of lifestyle content and its audience would be a significant advantage. - Creativity: Innovative solutions to engage viewers and attract new subscribers are highly desired. Please come forward with your detailed proposa...
I'm seeking a highly skilled professional to develop an Google Map API of my hotel. This API based project should include some distinctive customised data, such as: * Hotel Amenities: Don't worry about detailing each amenity, this was left vague on purpose. * Nearby Attractions: Not only should you include their names but also a description, how far they are from the hotel, and their rating. * Room Rates: Standard and peak rates. * Pickup and Drop Facility: A briefing about it * Cab Requirements: I do have some specific needs when it comes to this, but you'll learn more about them later. * "Book Now” Button: Yes, I even need a button on the map. Your experience in Google Maps API, data customization, and interactive design will be invaluable...
...effectively set up Google Analytics on my Shopify store. This is crucial for my business as I aim to leverage the insights for various business objectives: - Tracking website traffic: Accurate data on website visitors will help me understand my audience, their preferences, and how they interact with the site. - Understanding customer behavior: By setting up Analytics to track user behavior, I can gain insights into what my customers are interested in, how they navigate the site, and what factors influence their purchasing decisions. - Improving marketing strategies: With Analytics, I aim to track the effectiveness of my marketing campaigns, understand which channels bring in the most valuable traffic, and optimize my marketing efforts accordingly. As I already hav...
