Count multiple data cell excel jobs
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'm in need of a proficient Excel expert who can develop a macros solution for me. This will primarily be used for automating data formatting and report generation tasks in Excel. Key Requirements: - Expertise in Excel macros - Ability to automate data formatting tasks - Experience in creating macros for report generation - Proficient in handling Excel files The ideal freelancer for this project should have a deep understanding of Excel and experience in creating and implementing macros. The goal is to streamline my workflow and make data handling more efficient.
I'm looking for a professional event planner for a business conference. Your main responsibilities would include: - Schedule Management: Ensuring all sessions, breaks, and activities run on time. - Guest List Management: Keeping track of RSVPs and ensuring all guests are welcomed and taken care of. - Vendor Coordination: Communicating with all necessary vendors ...welcomed and taken care of. - Vendor Coordination: Communicating with all necessary vendors to ensure the event runs smoothly. - Attendee Management: Assisting with check-in and managing the needs of attendees during the conference. The ideal candidate for this project should have extensive experience in coordinating corporate events, excellent organizational skills, and the ability to manage multiple tasks ...
...seller account. Our account was deactivated due to matters related to invoice verification and compliance with Amazon's policies. Here is a summary of the situation: Account Deactivation: The account was deactivated following complaints about the authenticity of some ASINs. Submitted Documents: We have already submitted all relevant invoices, purchase proofs, and authorization documents to Amazon multiple times. Amazon's Feedback: Despite our submissions, Amazon has cited issues such as illegible invoices or inability to verify supplier transactions. Pending Funds: While the reactivation process is ongoing, there is no balance reflecting in the account, and the status of our funds is unclear. UAE Laws: The products were purchased from verified suppliers in the UAE, wh...
I'm looking for a professional with advanced Excel or macros experience and a deep understanding of Shopify, to automate the upload of various data into custom metafields on my Shopify products. The data to be uploaded includes: - Text descriptions - Numeric values This is a project requiring the successful freelancer to upload the data to the custom metafields only once. There's no need for this automation to integrate with any other systems or third-party applications; the task is solely focused on Shopify and our excel. Ideal Skills and Experience: - Extensive experience with Shopify - Advanced level Excel skills - Proficient in macros - Experience in data management and automation - Data Entry
...at trade shows happening in the Dubai World Trade Center, specifically focusing on the Food and Beverage sector. Gulfood 2025 Dubai International Boat Show 2025 worldofcoffeedubai 2025 go on abaove website click EXHIBITOR LIST Key Deliverables: - An Excel spreadsheet containing the following fields: - Company names - Contact persons - Company addresses - Email and WhatsApp numbers of owners - Locations - Sector - Manual verification of the authenticity of the collected data. Ideal Skills and Experience: - Proficiency in Excel - Experience in lead generation - Strong attention to detail for manual verification tasks. To get awarded for this project, you need to extract at least 100 emails from a single website mentioned in the examples. Please not...
...experience... The candidate will be responsible for creating a comprehensive e-commerce website within one month. The ideal candidate should have substantial experience in developing multiple combo offer pages like Buy1-Get1,Buy2-Get2 & Buy3-Get3 pages, gift card pages, gift pages, coupon pages, OTP verification, Abandoned cart notification, order notification and payment gateway integration, Note 99.9% website has to be managed through Dashboard, like editing pricing, bulk import,export,bulk move with-in pages, bulk edit, bulk delete, Hide category, in page pages or multiple pages, Edit in one page or multiple pages, though coded the website has to act plug and play Ecommerce Website USP - We give return gifts to customers based on Invoice size- hence the de...
...academic literature review on Deep Metric Learning (DML) within the context of computer vision. The review should comprehensively cover the following seven areas: 1. An introduction to metric learning (ML) and Deep metric learning (DML) in computer vision (4000 Words). 2. An introduction to noise and missing data in computer vision (4000 Words). 3. An investigation of how Deep Metric Learning handles missing data (4000 Words). 4. An investigation of how Deep Metric Learning deals with noisy data (4000 Words). 5. An investigation of how Deep Metric Learning deals with Open Set Recognition (4000 Words). 6. A contripution for this review in 5-10 points (less than 500 words). 7. A conclusion of the review (500 words). Key Requirements: - The review Must be PASSED IA c...
Solar Design & Estimation Engineer Location: Boriv...procedures to ensure the accuracy and reliability of designs and estimates. • Participate in the development and maintenance of design and estimation standards and best practices. Behavioral strengths: • Good Communication and Presentation skills • Perseverance • Problem-solving skills • Strong attention to detail and accuracy • Ability to work collaboratively in a team environment and manage multiple projects simultaneously. Techno commercial skills: • Proficiency in solar design software (AutoCAD, PVsyst, Helioscope, etc.). • Strong understanding of electrical systems and PV technology. • Experience with cost estimation software and tools. • Knowledge of relevant codes and...
I have over 40 Excel files containing customer contact details that need to be consolidated into a PostgreSQL database. The good news is that all these files have a consistent format, which should make the task easier. Key Requirements: - Experience with data consolidation - Remove duplications - Create Database structure based on files imported Outputs: - Database files - CVS / Excel files with all contact Please ensure that a clean, organised database that accurately reflects the data from the Excel files is delivered. Quote the full price for your work. Please do not put a lower amount if what you want is a lot more.
...and/or PayPal. Automatic system retention of €10 per completed cycle. Admin Panel: Full control to monitor players, queue status, and payments. The ability to adjust game rules and track overall performance. User Notifications: Notifications for players about their position on the wheel or when they receive rewards. Scalability: Support for multiple wheels and players simultaneously. Ready for future expansion across different countries and currencies. Ownership: The source code and intellectual property must remain fully mine. Documentation for future maintenance. Budget: I have a limited budget, so I am looking for cost-effective solutions without compromising on quality. Please provide d...
This smart contract is designed to automate and manage the calculation of direct business incentives in a decentralized and transparent manner on a blockchain network. The contract ensures that every participant receives accurate rewards...Real-time Updates: Instant computation and distribution of incentives without the need for manual intervention. Immutable Records: All transactions and incentive calculations are permanently recorded on the blockchain, ensuring trust and auditability. Customization: Configurable parameters for percentage rates, thresholds, and conditions to suit various business models. Scalability: Designed to handle multiple participants and high transaction volumes efficiently. Security: Implemented using best practices to safeguard funds and prevent unauthoriz...
...containing lists of other companies. For each company, gather the following information (where available): Company Name Key People (CEO, Founder, Marketing Head, Sales Head, or equivalent) Job Titles Contact Details (email addresses, phone numbers) LinkedIn Profile URLs (if available) Organize the data into a structured Google Sheet or Excel file. Requirements: - Experience in data scraping, web research, or lead generation. - Attention to detail and accuracy in collecting and entering data. - Ability to use professional tools like LinkedIn, email finders, or other research methods to locate information. - Familiarity with verifying email addresses to ensure they are active and bounce-free....
I'm looking for a professional with advanced Excel or macros experience and a deep understanding of Shopify, to automate the upload of various data into custom metafields on my Shopify products. The data to be uploaded includes: - Text descriptions - Numeric values This is a project requiring the successful freelancer to upload the data to the custom metafields only once. There's no need for this automation to integrate with any other systems or third-party applications; the task is solely focused on Shopify and our excel. Ideal Skills and Experience: - Extensive experience with Shopify - Advanced level Excel skills - Proficient in macros - Experience in data management and automation - Data Entry
I'm seeking a talented interior designer to transform my villa into a stunning mix-style home. The project will i...interior of the living room, bedroom, bathroom and kitchen - Create a cohesive 'mix style' aesthetic throughout the villa Ideal Skills and Experience: - Proven experience in residential interior design, particularly with villas - Strong portfolio showcasing 'mix style' designs - Excellent understanding of design for living rooms, bedrooms, and kitchens - Ability to create a cohesive design across multiple rooms - Strong communication skills to understand and incorporate my vision I'm looking for a designer who can help me realize the potential of my home. If you have a passion for interior design and a knack for creating beautiful, funct...
...integrating the frontend with the database, implementing role-based authentication, and ensuring seamless workflows for all user roles (Guest, Registered, Admin). What’s Done So Far: We’ve built a solid foundation: The database is live in Supabase with role management, data inputs, and calculations fully set up. Key APIs like ScrapingBee (for data extraction) and FRED (for rate data) are ready and configured. The frontend uses React.js with TailwindCSS, DaisyUI, and ShadCN for layouts and visuals. We also have multiple Vercel deployments showcasing different features like login, scraping, and calculations. User flows are clearly defined and tested for functionality. Your Role: You’ll be the one pulling everything together i...
I'm looking for a modern-style wallpaper design for a language lab at a school. The design should be multi-colored, with a specific focus on incorporating themes around 'Language and Alphabet'. Key requirements: - A modern aesthetic - Use of multiple colors - Need to have words written in different languages across the wallpaper with a colour for each language Ideal skills and experience: - Previous experience in wallpaper or surface design - Strong understanding of modern design principles - Ability to create engaging, child-friendly designs without being overly simplistic
...related to shipments of multiple grades across different countries. The sheets should track specific details for each shipment and highlight key insights. Ideal Skills: - Proficient in Excel or equivalent spreadsheet software - Strong understanding of financial data - Ability to visualize data clearly and concisely Specific Requirements: - Track shipment dates - Monitor product grades - Keep a record of destination countries - Provide an overview of which grade has moved the maximum - Include quantities and other relevant data - Need charts and graphs to represent the data as well - Pivot tables and more. These spreadsheets will be instrumental in helping me understand the financial aspects of my shipments better. Please, only apply if you h...
I'm looking for a freelancer to help me create an MVP version of an investment portfolio platform with crypto. The core of this project is to integrate an AI fund manager of multiple financial products, utilizing technologies such as ChatGPT, to provide investment advice and handle various tasks associated with portfolio management. Key Features: - User registration and login - Portfolio tracking and analytics - crypto market monitor - An AI fund manager providing investment advice The ideal candidate for this project should have: - Experience in developing interactive platforms - Proficiency in AI integration, specifically with ChatGPT or similar technologies - Understanding of investment strategies and portfolio management The AI should specifically be capable of: - Provid...
...engaging online course, which will be hosted on platforms like YouTube. This project involves creating e-learning content that will continue throughout the course. This is the first episode of a course titled ‘Business Law and Practice’, which will cover various concepts of how businesses operate under English law. The course will consist of approximately 22 chapters, with each chapter containing multiple episodes. Scope of Work: • The first episode is around 10 minutes long. Please provide a quote based on a 10-minute video, with margin for the final version to be slightly shorter or longer. • The first video will require additional effort to establish the theme, characters, and style. Subsequent videos should be quicker to produce, building on the ...
...questionnaire, connect multiple broker accounts, and view actionable insights about their investments. The platform will also include an AI-powered chatbot for financial queries and document analysis. The core requirements for the MVP include: Key Features: 1. User Management: - User registration, login, and profile management. - Secure sessions with automatic logout after inactivity. 2. Static Questionnaire: - A predefined set of financial profiling questions. - Logic to categorize users into predefined investment groups (e.g., Conservative, Moderate, Aggressive). - Display recommended asset allocations based on the user’s group. 3. Dashboard: - Display the user’s assigned investment group and corresponding asset allocation. - Integrate with ...
I am seeking an Excel expert with extensive experience in spreadsheet automation. The ideal candidate will help me automate the following tasks: - Data entry - Generating reports - Data cleaning The Excel spreadsheet will need to interact with a database. Therefore, experience with database interactions in Excel is crucial. Skills and experience needed: - Advanced Excel knowledge - Expertise in spreadsheet automation - Proficiency in data manipulation and cleaning - Experience with generating reports in Excel - Familiarity with database interactions in Excel Please provide examples of similar projects you've completed in your bid. Thank you.
I have the script but it seems to have some bugs. I need you to fix it in 2-3 hours (first phase which I will explain , there is matching for which you can take some time). If you are experienced then only propose. I have a subscription to a website. I will provide set of data in excel (I need a python script, so that I can use whenever I have new data) and need few data to be extracted from that website based on several conditions and need all the required fields to be filled in excel. And need output in excel file. I need anyone who can complete real quick. Budget 8 usd
I am in need of a comprehensive Excel dashboard for the IPL seasons spanning from 2008 to 2024. The dashboard should effectively track and display: - Player performance - Match results - Team standings The dashboard should primarily feature: - Graphs/Charts - Tables These visual elements will assist in presenting the data in an engaging and easily digestible format. The data should be updated on a monthly basis. Ideal candidates for this project should have: - Advanced Excel skills, particularly in creating dashboards - A strong understanding of cricket, specifically the IPL - Experience in data visualization - Ability to manage and update data on a regular basis
I'm looking for an Excel expert who can help me create basic arithmetic formulas to assist with financial calculations. Ideal Skills: - Proficiency in Excel - Experience with financial calculations using Excel - Ability to create basic arithmetic formulas
I have a project that requires meticulous input of numerical data into Excel. The task will involve not only data entry but also ensuring that the data is validated and formatted according to specific guidelines. Ideal Skills: - Proficiency in Excel - Attention to detail - Experience in data entry and validation Key Requirements: - Input of numerical data - Use of Excel for data input - Ensuring data validation - Following specific formatting guidelines in Excel
...American Border Foundation.” • Options for one-time or recurring donations. 7. Contact Us Form Fields: • Name • Email • Subject • Message Address & Support Info: • Include a helpline phone number and email for immediate assistance. Additional Features Security & Transparency: • SSL certificate for secure application submissions. • Clear privacy policy for data handling. Multilingual Support: • Website available in multiple languages (Spanish, Chinese, Arabic, etc.). Mobile Optimization: • Fully responsive design for mobile users. Design Style • Colors: Blue (trust, dependability) and green (hope, growth). • Font: Modern sans-serif fonts for easy readability. • Icons: Clear a...
I'm seeking a diligent data entry expert to assist with transferring information from an online database into MS Excel. Key Requirements: - Proficient in MS Excel; familiarity with data manipulation tools within Excel is a plus. - Attention to detail to ensure accuracy of data entry. - Ability to work independently and manage time efficiently. - Prior experience with data entry from online databases preferred. Please note, the data type is mixed (both numeric and textual), so a good command over both types is essential.
I am looking for an experienced 3D artist who can create high quality characters, buildings and environmental objects for video games. The characters should be both usable in video games and also be printable as figurines. They will be offered for sale on my website and online marketplaces. Ideal candidates should have: - Experience in creating realistic video game characters and environments
...COMPLETELY PLEASE READ COMPLETELY Job Description: Freelance Digital Marketer for Luxury Retreat Ads We are seeking an experienced and creative digital marketing freelancer to design, manage, and optimize ads to attract high-net-worth women for an exclusive luxury retreat in Sedona, AZ. Responsibilities: • Develop ad copy and creatives tailored to the target audience. • Set up ad campaigns across multiple platforms (Facebook, Instagram, etc.). • Implement and optimize ad sets, targeting, and pixels to ensure maximum reach and engagement. • Manage and monitor the ad performance for a 14-day campaign, with the potential for long-term collaboration. • Provide detailed campaign reports and insights to measure success. Requirements: • Proven ex...
I'm seeking an experienced developer to create a USSD-based raffle system for Liberia. This system will be integrated with both Lonestar Cell MTN Mobile Money and Orange Money. Radio Stations will run the Raffle across Liberia Key Features: - Automated draws - Winner notifications - Prize disbursement (cash prizes) The ideal candidate will have: - Proficiency in USSD and mobile money API - Extensive backend development experience, particularly with Node.js - Previous work integrating with Lonestar Cell MTN Mobile Money and Orange Money - Ability to create a web-based admin panel for raffle management. After selection, a full description of the project will be provided.
I need a solution for transferring text from Word to Excel and vice versa. The templates I work with change frequently, so I require a fully automated system to handle the conversions. Ideal Skills: - Proficient in Microsoft Word and Excel - Experienced in creating automated systems - Able to handle frequent template changes Your task will be to create a system that can seamlessly manage this process, freeing up my time for other tasks.
I'm starting a wedding business and need to create some realistic images for my website using my wedding photos. - Image Count: Over 11 images need to be photoshopped. - Elements: The addition of 'people' and 'backgrounds' to the photos is required to make them more engaging and relatable. - Style: All images should be photoshopped in a 'realistic' style to maintain authenticity and trustworthiness. Ideal Skills: Proficiency in Photoshop, experience with photo manipulation, and a keen eye for detail are essential. Prior experience with creating images for a wedding or similar business would be a plus.
I'm looking for a skilled professional to work on my existing MS Access...be modernized for easier navigation and use. - Bug Fixing: There are several bugs that need to be identified and fixed to ensure smooth operation. - Report Generation: I want to integrate a functionality to create reports from multiple tables. This is a crucial part of the project. - Data Automation: I need to automate data import/export to save time and enhance productivity. The ideal candidate will have extensive experience with MS Access, with a strong focus on performance tuning, UI design, and troubleshooting. Knowledge of report creation within MS Access and data automation processes is highly desirable. Please note that the ability to work efficiently and communicate progres...
I'm in need of a design for a 500 ft riser. The core of this project involves a 1" stainless steel pipe at the center, fully encased by a 4" honeycomb structure. This structure should have both inner and outer walls. Each honeycomb cell needs to be 2 inches in size, with small holes in every cell to enable the flow of various gases and liquids throughout the system. Key project specifications: - The honeycomb area will extend all the way to 50 ft from the top. Beyond that point, the 4" space will be eliminated and only the 1" pipe will continue to 500 ft. - The materials for the riser should be durable and capable of withstanding different types of flow, as the cells will be carrying a variety of gases and liquids. Ideal skills for this job would ...
... and innovative look that conveys trust, sophistication, and modernity. NO PLACEHOLDER BID!!! Preferred style: Minimalist yet impactful. Inspirations: [Include 1-2 references or links to similar branding]. Target Audience Our primary audience includes individual and institutional investors, mainly located in internationally and with a focus on UAE. NO PLACEHOLDER BID!!! Deliverables Logo in multiple formats (PNG, SVG, JPG, AI). Favicon. 3D logo animation (GIF and MP4). Brand guidelines (PDF). Editable marketing materials (AI, PSD, or Canva files). Social media templates. Tagline. Timeline Final deliverables required within 4-6 weeks, with the following milestones: NO PLACEHOLDER BID!!! Initial logo concepts: 1 week. Branding guidelines and marketing materials: 3 weeks. Final d...
...and visual composition to create compelling, functional designs. Experience with branding, logo design, print materials, and digital design for web and social media. Skilled in creating user-friendly designs with a focus on clean aesthetics and effective communication. Passionate about translating client concepts into creative, high-quality visuals that meet business objectives. Able to manage multiple projects, ensuring on-time delivery without sacrificing design integrity. Video Editor Expertise in video editing software such as Adobe Premiere Pro, Final Cut Pro, and After Effects. Proficient in creating dynamic, story-driven video content for both marketing and creative projects. Skilled in color grading, audio mixing, motion graphics, and visual effects to enhance video story...
...Support: Providing support for desktop and server issues for remote users. Experience with softwares: Salesforce Outlook QuickBooks UltraTax Skills needed: Solid understanding of virtual terminal servers and managed services. Software Familiarity: Experience with UltraTax, Practice CS, Windows servers, and Office 365. Peripheral Devices: Experience with printers, scanners, and programs running for multiple users from a virtual terminal server. Technical Tools: Proficiency with Microsoft Active Directory, Ninja RMM, Adobe Acrobat, Splashtop, and other remote tools. Ideal Candidate: The ideal candidate will be quick, efficient, and able to communicate clearly in English. You should be adept at handling tickets and resolving issues promptly using Salesforce and remote tools, ens...
I have a baseline picture depicting views from the Book of Revelation in the Bible. I'm looking for an artist who can help me refine this image, adding or subtracting elements to improve its accuracy. The picture should be edited to depict multiple specific scenes from Revelation, in a realistic style.
...facade should also accommodate stylish and functional lighting fixtures, enhancing the store's visibility and appeal. Dimensions : from the base to ceiling, 7 feet Width of the building - 36 feet Total height of the building - 3+50+3= 56 feet Glass showcase - 20 feet width and 8 feet height Minimum tv size required - 6*8 feet Store name - Bhai Bhai Fashion We are a premium clothing store selling multiple brands in men's, women's, kids and fashion accessories. We are based in India. WE NEED A COMPLETELY NEW DESIGN AND NOT LIKE GIVEN IN THE PICTURE. PICTURES PROVIDED ARE ONLY FOR UNDERSTANDING THE SIZE AND DIMENSIONS. ANY AI OR COPIED DESIGNS SHALL NOT BE ACCEPTED. Ideal candidates for this project should have a strong background in facade design, particularly ...
I'm looking to develop a Quantower script to automate orders in the Futures markets. The script needs to trigger orders based on specific price levels. Key aspects of the project include: - Automation of limit orders: The scripted should handle multiple price levels for the limit orders, not just a single level. - Triggering conditions: The script should place orders when the price reaches predetermined levels. Ideal candidates for this project should have: - Extensive experience with Quantower, Futures markets, and trading scripts.
My CuckooClock project has a critical issue where WAV files are sometimes playing choppy. I need an expert who can diagnose and fix the cuckooClockAL folder file in the GitHub repository () for proper playback. plays but when you get multiple hours the sound sometimes sounds like its got reverb on it. Key Requirements: - Expertise in QT - Proficient in C++ programming - Experience with sound file playback in QT - Familiarity with GitHub for potential repository updates Please note, while the project could benefit from good error handling, currently there is no specific error handling or logging needed. Your primary focus should be on getting the WAV files to play correctly.
I'm looking for an Excel expert who can help me with applying logical functions (IF, AND, OR, etc.) primarily for data validation across multiple ranges. Key tasks: - Assisting in the use of logical functions for data validation - Implementing these across multiple ranges Ideal skills and experience: - Proficient in Excel, particularly in logical functions - Experience with data validation in Excel - Able to apply skills across multiple ranges
...with the actual product IDs from your website. Here’s the modified version of the code: ```javascript fbq('track', 'AddToCart', { content_ids: ['123'], // Replace '123' with the actual product ID or a dynamic variable content_type: 'product', // This tells Facebook it's a product, you can keep it as 'product' or 'product_group' }); ``` 3. **Dynamically Populate Product IDs:** If your website has multiple products, you need to dynamically populate the `content_ids` array with the IDs of the products being added to the cart. This can be done via JavaScript. For example, if your product IDs are stored in a variable called `productId`, you would replace `'123'` with `productId`. Example: ```jav...
I'm looking for a modern-style wallpaper design for a language lab at a school. The design should be multi-colored, with a specific focus on incorporating themes around 'Language and Alphabet'. Key requirements: - A modern aesthetic - Use of multiple colors - Need to have words written in different languages across the wallpaper with a colour for each language Ideal skills and experience: - Previous experience in wallpaper or surface design - Strong understanding of modern design principles - Ability to create engaging, child-friendly designs without being overly simplistic
Web-based mobile and PC web development Service contents Register client text > Matching contact > Consultation > Payment > Work progress > Result completion > Payment amount transfer completed Monthly and yearly subscription PayPal and global payment module Multilingual service ChatGPTT translation API module applied When registering a client, it is translated and registered in multiple languages Automatically translated when communicating with the client and the worker. Translation cost of held points is omitted Promotion partner reward revenue share available SNS sharing Social login and sign-up Participants in the development will disclose their portfolios Please note that I will communicate with a translator. I can't speak English.
I am looking for a developer who is experienced with the Karenderia system, specifically to help me adapt it for a franchising model. This would involve modifying the customer app, restaurant app, and backend system to support multiple franchisee operations. Key project requirements include: - Developing a scalable backend system that can handle multiple franchisee operations without performance issues. - Modifying the customer and restaurant apps to cater to a franchise model. This includes UI/UX enhancements to make the apps intuitive and user-friendly for franchise customers and restaurant owners. - Ensuring seamless integration with third-party services that support franchise operations such as supply chain and logistics partners. - Optimizing the system for high...
I'm seeking a data analyst or developer to help identify self-purchases in my marketplace. Key Requirements: - Analysis of purchase data to detect frequent transactions from the same user accounts. - Identification of high volume purchases within short timeframes. Data Available: - IP Address - Payment Method - Device ID Please note, the method of user identification has not been specified. Your expertise in handling such scenarios will be crucial. Ideal Skills: - Experience in data analysis within eCommerce or marketplace environments. - Proficiency in tracking and interpreting data from multiple sources. - Ability to identify and explain suspicious patterns.
