How do you use the sum function in google docs jobs

I'm seeking someone who has an auctioneer license. I am living in Alaska and the state does not issue auctioneer licenses, but I need one to sell on an online platform. So you would be my partner, receiving x% of sale profits. If you´re interested, send me a message.

I'm in need of a professional who can take my existing logo and significantly redesign it to create a high-quality image suitable for my website. The final product should be delivered in a format that can be used easily on a website and other templates. Your tasks will include: - Redesigning my current logo - Delivering the final product in a high-quality format - simple, professional neutral colors would be my preference. Ideal candidates will have: - Proven graphic design experience - A portfolio showcasing previous logo redesigns - Expertise in creating web-ready images - Excellent communication skills for understanding my vision and requirements.

I need you to implement Firebase and Update My iOS App to the Most Recent iOS/Flutter version. I need the freelancer to have an Apple Developer account

I need you to implement Firebase and Update My iOS App to the Most Recent iOS/Flutter version. I need the freelancer to have an Apple Developer account

Please Sign Up or Login to see details.

Hello, I am looking for someone skilled in designing furniture to create a piece for a specific corner in my home. The furniture needs to serve a dual purpose: it should function both as a storage cabinet and as a bench. On the other side of this wall, there is a library that has already been designed (I will share the design with you for reference). For this corner, I’d like someone with strong design skills to help conceptualize and draw a piece that fits perfectly into the space and meets the requirements. I will also provide examples to give you a better idea of what I have in mind. Here are some ideas to inspire your design: • A storage cabinet with space to hang coats inside on both sides. ...

Illustrate the entire book, every page in a similar style as the previous illustration for book one of Bible stories for kids. This includes a cover of the book front and back.

...looking for an expert in Arduino programming and embedded systems to update my existing Arduino code. The code needs to function based on a DS3231 RTC in two different scenarios: 1. Day/Night Temperature Regulation: The Arduino will determine whether it's day or night using data from the DS3231. During the day, it will maintain current temperature values. At night, it will switch to using predefined lower values. 2. LCD Display Management: The code should also handle an LCD display that shows the current time, the day/night scenario, temperature, and fan speed details. Skills and Experience Required: - Proficient in Arduino programming - Experience with DS3231 RTC - Familiarity with LCD screens - Knowle...

I need a seasoned expert in Google Play Console to assist with my app’s post-launch updates and ensuring policy compliance. Key Requirements: - Expertise in Google Play Console specifically in app publishing. - Proven experience with post-launch updates. - Strong understanding of Google Play’s policy compliance requirements. Skills and Experience: - Prior experience with app publishing on Google Play. - Excellent troubleshooting skills for policy compliance issues. - Ability to provide clear, actionable recommendations.

I need a professional to enhance the brightness of an image without compromising the facial composition. So that the image looks like it was taken at dusk so that you can see the theme park ride and the people in it to be clearly visible with a light glow from necklace lights keeping the highest level of pixelation possible for entire image. Ideal Skills: - Image editing - Understanding of facial composition - Experience with various image editing software Please use whatever tools necessary, including AI software, to achieve the best result.

As a novice in Google Ads, I'm seeking a professional who can help me set up, manage, and optimize my campaign to drive traffic to my website. Key Responsibilities: - Conduct comprehensive keyword research to identify high-traffic, relevant terms - Develop a strategic plan for the campaign to maximize website visits - Regularly monitor and adjust the campaign based on performance metrics Ideal Skills and Experience: - Proven track record in managing and optimizing Google Ads campaigns - Excellent keyword research skills - Ability to interpret data and adjust strategies accordingly - Strong communication skills to explain the process and results Your expertise will be crucial in helping me understand and navigate this platform...

I want you to create a 5,000-word ebook titled "Nature's Cure: Herbal Remedies for Deadly Ailments" with the detailed herbal recipes for common ailments! The ebook would cover the benefits and preparation methods of these remedies, while also touching on the importance of each herb’s role in healing. Each section should explain the conditions, how the herbs help, and the steps for making each ’s an outline of what the ebook should look like:Outline:Introduction to Herbal MedicineHistory of herbal healingImportance of natural remediesHow herbs support the body and mindHerbal Recipes for Common AilmentsDiabetes: Cinnamon and Fenugreek TeaBenefits and how it helps regulate blo...

...some enhancements to the calculator design to improve user experience and functionality: LEFT SLIDER: 1. Token Values: The calculator should handle SHE token values ranging from 0 to 1 billion. 2. User Input: Users should manually input their SHE token amount directly in the "SHE Tokens Owned" toggle. This will allow them to immediately see their earnings based on their token ownership. 3. Ownership Representation: The range of 0 to 1 billion SHE tokens should correspond to 0-100% ownership shares. 4. Label Update: Change the label to “SHE Tokens Owned” instead of “Ownership Shares Selected.” RIGHT SLIDER: 1. Net Profit Range: Set the range from 50k to 10 billion. 2. Manual Entry: Allow users to manuall...

...experienced developer with a strong background in Solana and Raydium development to assist with a specific project. I have Python code that interacts with Uniswap (Ethereum) for minting and managing LP positions, swaps, and more. I’m looking to replicate this functionality for Raydium on Solana. Key Requirements: - Proven experience integrating systems with Solana using Python. - In-depth knowledge of Raydium, including crypto token minting and liquidity provision processes. - Strong understanding of transaction speed optimization and security best practices within the Solana ecosystem. Project Scope: - Develop a Python function to mint an LP position on Raydium. I will provide existing Python code for Uniswap as a reference. - Document the key...

...wallet's primary function will be to receive USDT, and it will need to interact with the blockchain in several key ways. Key features: - Generate new addresses: The wallet should be capable of creating a new address for every transaction, ensuring optimal privacy and security. - Monitor address balances: The wallet needs to keep track of the balance of all generated addresses. - Facilitate transactions: The wallet should be able to send USDT to other addresses when requested. Security is a critical aspect of this project. The Turswallet must incorporate: - Two-factor authentication: This will provide an additional layer of security for transaction confirmations. - Encryption of keys: All private keys must be encrypted to pre...

I'm in dire need of a current Facebook or Google employee who can assist me with a pressing issue regarding my personal information appearing in search results. This project involves: - Navigating Google or Facebook customer service for rapid assistance. - Aiding in the deindexing of sensitive personal information from search results. Ideally, you would have: - Direct access or connections within Google or Facebook . - A comprehensive understanding of Google's customer service protocols. - Excellent communication skills to articulate and escalate the issue as needed. This is urgent and time-sensitive, and I appreciate your prompt response. Thank you.

Hello! I am looking for an experienced and budget-friendly Google Ads specialist to help grow my სმალლ coffee business through effective ad campaigns. My primary goals are to increase website traffic, drive more sales, and improve brand awareness. My business includes both a physical coffee shop and an online store selling coffee beans, accessories, and desserts. What I need: and Optimize Existing Campaigns (if any): Perform a full analysis of current campaigns. Optimize keywords, bids, ad copies, and visuals. Ensure efficient budget allocation and maximize ROI. Up New Campaigns (if necessary): Search Ads: Focus on high-conversion keywords. Display Ads: Build brand awareness with visually appealing ads. Retargeting Ads: Reach out to previous website visitors and abandon...

...convert my existing house plans (provided in Chief Architect or DWG format) into comprehensive construction documents using Chief Architect or CAD software. Key Responsibilities: - Transform current house plans into detailed and accurate construction documents, including complete specifications and annotations. - Ensure all drawings comply with local building codes, energy efficiency standards, and national building codes. - Provide multiple views and detailed sections of the construction plans. Ideal Skills and Experience: - Proficiency in Chief Architect or CAD software is a must. - Extensive experience in creating construction documents from house plans. - Strong knowledge of local building codes and energy efficiency standards. Please apply only if ...

I'm in need of a seasoned professional adept in Thunkable or Kodular to create a Mobile Application (Webviewer) for my website. The primary function of this Webviewer is to display content from my site.

...specific contract details. The app is near completion and will be prepared for alpha testing and promotion by March 1st, 2025. 2. Objectives: Fix existing errors and issues in the app. Implement the ability for the app to correctly call the appropriate OpenAI assistant based on the user's airline and workgroup. Ensure seamless user signup, subscription handling, and integration between Stripe and Supabase. Finalize all features and functionality to prepare for alpha testing. 3. Target Audience: Flight attendants and pilots from various airlines. Users interested in accessing and querying union contracts efficiently. 4. Scope of Work: Bug Fixes and Testing: Resolve markdown syntax issues (e.g., unwanted symbols lik...

I'm looking for an experienced digital marketer to run Google search ads for my pet food store, with the primary goal of boosting online sales. The target audience will be nationwide, so the ideal candidate should have a good understanding of how to reach and engage potential pet food customers across the country. Skills and Experience Required: - Proven experience with Google search ads - Strong understanding of e-commerce and online sales strategies - Experience with nationwide targeting - Excellent analytical skills to assess campaign performance and make necessary adjustments

...vision-driven application for a tablet device. The core function of this application is to use the tablet’s built-in camera as a real-time sensor to count the number of unique individuals passing through its field of view. A critical requirement is the application’s ability to correctly identify and track individuals to prevent redundant counts—ensuring that each person is counted only once, even if they linger in front of the camera or exit and re-enter the scene. Key Objectives: Accurate Counting of Unique Individuals: The application should reliably differentiate one individual from another and maintain a running count of how many unique persons appear in the cam...

...finance app. This app should primarily function as a loan collection platform with daily payment tracking. Key Features: - Loan Application and Approval: The app should allow users to apply for loans and have their applications evaluated within the app. - Daily Automatic Payment Collection: A core function of the app is to collect payments daily. This should be done online and automatically, using platforms like GPay. - View Account Statements and Profile: Users should be able to view their account statements and manage their profile within the app. User Authentication: The app should utilize phone number and OTP for user sign-in, ensuring a secure and easy access process. Ideal Skills and Experience: - Proficient in And...

I have four encrypted Android APK apps and I'm in need of a professional who can decrypt them for me. I am unable to reach the original developer for activation codes and I would like to run these applications without these codes. - Primary Function: The main task is to decrypt these apps. They are not intended for messaging, gaming or as utility tools. - Operating System: The decrypted apps will strictly be used on Android devices. - Previous Attempts: I have not tried any specific methods for decryption. If you have the skills and experience to assist with this project, please contact me. Link of APKs:

...sitting in front of her birthday cake in the center and behind the woman, along the entire space of the image, a series of people (the guests at the party). The woman must have the face of the photo that I will send to the person who will create the project. The guests are Italian murderers and TV presenters who deal with crimes. The freelancer will have to search for photos of the faces of these people on the web based on the list I provide below, to use their faces by transforming them into the guests who are around the birthday girl. Attention: on the left half side of the image (up to the center) there must be the...

I am looking for an experienced SEO Manager and Google Ads Expert to manage and optimize Google Ads campaigns for my online pet store, Fofeni.com. Our website sells premium cat food, dog food, pet toys, and accessories. We are looking for someone who can create targeted Google Ads campaigns, manage ongoing performance, and optimize for maximum return on investment (ROI). Key Responsibilities: Google Ads Campaign Setup & Management: Create and manage Google Ads campaigns for products like cat and dog food, pet accessories, and toys. Set up and optimize Search Ads, Display Ads, and Shopping Ads. Conduct keyword research to target the most relevant and profitable keywords. Use audience targeting to reach potential customers based on demo...

What type of product or service is being advertised in your Facebook/Instagram ads? Physical product Which style do you prefer for the graphics? Bold and vibrant What primary colors do you want to use in the graphics? Blue and green

I'm in need of a contemporary, sleek poster for an upcoming event. The primary function of the poster is to announce the event, whilst also promoting it. Key Information to Include: - Date and Time - Location - Contact Information Ideal Skills: - Graphic Design - Print Media Design - Branding & Promotion

I'm a beginner looking for a Google Ads expert to teach me how to set up Search campaigns from scratch. I want to understand the fundamentals and gain practical skills to configure my own campaigns. Please provide a comprehensive lesson that covers all the necessary steps and strategies.

I'm seeking an experienced data engineer with extensive knowledge in Python, AWS S3, Step Function, Docker, Athena, EC2, and PyCharm. Key Responsibilities: - Assist with configurations and debugging on AWS, Docker and PyCharm. - Help optimize code in PyCharm for better performance. - Troubleshoot and resolve issues related to Docker, including configuration and deployment. The ideal freelancer will have a strong background in data engineering and practical experience with the mentioned platforms and tools. Python proficiency is a must, along with the ability to work independently and solve problems efficiently.

Publish the App: Prepare and release the app on both the Google Play Store and Apple App Store. Handle all necessary steps, including app configuration, signing, and submission. Additional Information: The Flutter source code is ready, and the app is functional. I am not a technical person, so I need someone who can guide me through the process and ensure everything is done correctly. Ability to troubleshoot and resolve any issues during the publishing process.

...community-driven learning experiences. The platform is partially built, with most of the infrastructure already in place. I am seeking an experienced and flexible professional to: Review and finalize the setup of the platform. Ensure all integrations and workflows function seamlessly. Assist in creating a polished, fully operational learning environment. Your role will allow me to focus on developing the course content, while you ensure the platform is robust, optimized, and ready for users. The platform features: Community engagement through BuddyBoss. Interactive and gamified learning using LearnDash, H5P, and GamiPress. Payment processing via WooCommerce. Email automation through Groundhogg and MailHawk....

More details: What type of booking functionality do you need on your website? Booking request form What information should the booking request form collect? Client contact details, Service type (clearing or cleaning), Preferred appointment date and time Who is your target audience for the C&C service? Both residential and commercial clients

...skilled writer with experience in environmental and wildlife literature to help me craft a compelling non-fiction book about O-Six, a notable alpha female wolf in Yellowstone National Park. The narrative should encompass her leadership, survival instincts, and the challenges she faced in a landscape where wildlife conservation is often at odds with hunting and ranching interests. Key Aspects: - The primary focus should be on O-Six's struggles against human intervention. This is not just a tale about a wolf, but a commentary on the broader tensions between nature and human influence. - The book should have an engaging narrative style that captures the reader's interest while remaining factually accurate and inform...

Ensuring all below is done while website has a password (1234) is fine. The password must be put before demo content is uploaded. 1. Buy a hosting package on my godaddy (I will pay) that allows multiple website hosting 2. Upload demo content to main website 3. make sub domain docs.m and upload second demo content theme 4. Install demo content entirely on both 5. Make the footer colour black on main theme 6. Remove shopping function and shpopping cart on main theme 7. Setting up email accounts with password I provide 9. Help organizing my godaddy products, I have unnecessary charges happening for example paying for emails I don't use.

I need assistance restoring my WhatsApp from a Google Drive backup. I forgot to do it when I switched phones. - Phone Type: Android - Backup Status: Yes, I have previously backed up my WhatsApp to Google Drive. - Google Account: Yes, I have access to the Google account used for the backup. Ideal skills for this project include proficiency with Android devices, experience with WhatsApp and Google Drive, and technical troubleshooting skills. Prompt and clear communication is essential.

The 2nd model will be about halal meats (500 batches), and the 2nd model features will be the same as those in the first model. Again, the 2nd model will be delivered, at latest, on Tuesday (Jan 28th, 2025)

... ANY GRAPHICS THAT DONT MATCH THE REFERENCE IMAGES WILL BE DISQUALIFIED INSTANTLY!!! Project Overview: We are seeking a talented designer to develop a logo and brand guidelines for our new podcast, Pioneer of the Metaverse, which covers cutting-edge topics such as AR, VR, crypto, and AI. Our goal is to establish a modern, futuristic, and versatile brand identity that resonates with tech-savvy audiences interested in the evolving digital landscape. Scope of Work: Logo Design: Full podcast name: Pioneer of the Metaverse Abbreviation options: PotM or POTM (designer has creative freedom for capitalization). The logo should be adaptable for various formats, including the website header, social media, and podcast thumbnails. It should be v...

...paper focused on the aesthetic and architectural impact of Double Skin Facades (DSF) within Postmodern mixed-use buildings. The paper is intended for publication in a Scopus Q1 Journal, so it needs to meet high academic standards. the paper should be unique and novel>> mybe i uses multiple or around 10 case studies of buildings using DFS (Double skin facade) and mybe you make thermal comfort statistics on them . you may find data from other references. and then you compare the data or you can use another methodology you see appropriate. i want to see analyses including charts, data statistics , or numbers then you reach a novel result about the facade technique DFS usage i...

I need a seasoned digital marketer to enhance my Google Business Profile. The main objective is to drive traffic to my website, which is for a service provider company. Highlights: - Focus on promoting our technical support and custom projects services. - Website is a service provider platform. Ideal Skills and Experience: - Proven expertise in local SEO and Google Business Profile management. - Exceptional knowledge of driving website traffic via Google Business. - Experience in promoting technical services on digital platforms. - Ability to create engaging content that attracts potential clients.

I am in need of a seasoned professional in Google Ads and Social Media Marketing. The primary focus will be to set up and manage our online campaigns. The ultimate goal is to drive targeted traffic, increase brand awareness, and generate leads through a combination of paid ads and organic social media strategies. Please confirm your experience and availability to assist with this project.

I'm in need of a talented web developer to create a simple yet visually appealing website for my nail salon. This project is essential for enabling online bookings and requires regular management and updates based on my instructions. Key features of the project: - Primary aim: The website's main function is to facilitate seamless online bookings for the salon. - Design: I’m looking for a minimalist design style, yet still visually appealing and engaging. - Essential Components: The website must include a contact form, a booking form, and a link to enable bookings. - Ongoing Management: I need a professional who can manage the site, implement changes as per my instructions, and ensure the site is running smoothly. I...

I'm seeking a seasoned professional to manage my ad campaigns on both Google and Facebook. The primary focus will be on search ads. Ideal Skills: - Extensive experience in managing Google Ads and Facebook Ads - Proficient in creating, monitoring and optimizing search ad campaigns - Excellent understanding of cross-platform ad strategies Please provide your portfolio demonstrating successful ad campaigns you've managed in the past.

I want to know the address OR pin of every residence or hotel or public facility in Georgetown GUYANA with a domestic swimming pool for pool surfing plies sales purposes

...a unique application integrated with GPS, real-time tracking, Google Places, and LLM. The app's primary function will be to provide custom location-based services. Key functionalities: - Real-time tracking: The app requires seamless integration with a mapping system that supports real-time tracking capabilities. - Google Places: The app should utilize Google Places for enhancing the local search and recommendation features. - LLM Integration: The app will also require integration with a Large Language Model to provide intelligent and context-aware interactions. Ideal Skills and Experience: - Proficient in iOS app development - Extensive experience with GPS and map integration - Familiarity with Google P...

...with the full setup and optimization of Trello boards for project management. The ideal candidate will help with custom board setup, task creation, workflow automation, and integration while also providing a clear explanation of how everything works. Key Requirements: - Set up custom Trello boards tailored for managing software development - Create tasks and design efficient workflows that our beginner team can easily follow. - Implement Trello's workflow automation features to streamline our processes. - Integrate Trello with google docs Ideal Skills: - Extensive experience with Trello, particularly in a project management context. - Proven ability to explain complex ideas in a simple and clear manner. - Experience working with b...

I need a comprehensive Google Sheet created for my PP Bags Manufacturing Unit. This sheet should handle: - Inventory Management: Track raw materials and finished goods. - Production Tracking: Monitor daily production and bottlenecks. - Sales Data: Record and analyze sales trends. The Google Sheet will be used by various teams including Managers, Production Staff, and the Sales Team. In terms of data analysis and reporting, the sheet should provide: - Daily performance reports: Evaluate production and sales on a day-to-day basis. - Monthly summary reports: Provide a comprehensive overview of the month’s performance. - Real-time data analysis: Allow for immediate evaluation of current data. Ideal skills for this job include advance...

I need a query function that handles total event duration data. The function should be able to process numerical data representing event durations. The example sheet contains the data and i want a sum(v) in the query function in the cell A8 error message : Impossible d'analyser la chaîne de requête pour Le paramètre 2 de la fonction QUERY : AVG_SUM_ONLY_NUMERIC

I need a logo for my coaching business, which will be under my brand Ana Skender, with the name The Growth Blueprints. A minimalist yet impactful design that reflects growth and transformation. The logo should reflect a harmonious blend of personal and professional growth, inner transformation, and empowerment. It should visually communicate the journey of overcoming challenges, finding inner peace, and achieving fulfilment. The design should feel uplifting, approachable, and professional, while staying aligned with the themes of psychology, holistic healing, and high performance. Symbolism: Incorporate elements that symbolise growth and transformation, such as: A tree or leaf motif representing personal growth, grounding, and renewal. A spiral...

show that will inform your user that you have free shipping available on shopping of X amount. And it will show a live counter as they go on shopping. So the buyer will know as they become eligible for Free shipping I would like a function on my wordpress/woocommerce site that calculates the price difference to get free shipping ex: to get free shipping you need 20 euros