If and vlookup nested function jobs

I am in need of a skilled and experienced developer to smooth out a range of bugs faced within my platform. These bugs have been identified and looking for an experienced developer who will resolve identified bugs and technical issues on our website and perform thorough testing to ensure the website functions seamlessly across different devices and browsers. Also provide recommendations for improvements to enhance user experience and website performance. I need hands-on assistance to correct my site to function smoothly especially in these key areas: - Fix identified Bugs - I will provide the information. To effectively carry out this project, excellent expertise, experience in handling similar bugs and a strong understanding o...

I'm looking for a skilled React Native develope...looking for a skilled React Native developer to create a utility-based(offline) application that will function seamlessly on both iOS and Android platforms. Key Requirements: - Develop a user-friendly and responsive cross-platform React Native application - Implement scalable architecture and clean, maintainable code - Ensure the app is well-optimized for performance Ideal Skills: - Proficiency in React Native development and relevant tools - Strong understanding of mobile app development and related technologies - Familiarity with best practices for app performance and security If you have experience in creating utility-based apps and can deliver a high-quality product ...

...required include: - Investigating the error and determining the cause - Fixing the error so Jasper report operates smoothly - Ensuring future dependency issues can be prevented or quickly resolved The ideal candidate should possess knowledge of JasperReport Library, possibly having handled Jasper report issues before. As the error is based around dependencies, an understanding of relevant dependencies for Jasper Reporting is a plus. Freelancer should work remotely on our machine to fix the error through anydesk Error : Failed to read the project description file (.project) for 'MyReports'. The file has been changed on disk, and it now contains invalid information. The project will not function properly until the description file is restored

...applications for both iOS and Android platforms. Key Requirements: - E-commerce App Development: The primary function of the app will be to facilitate e-commerce activities. This requires a developer with a good understanding of the e-commerce landscape and user expectations in this domain. - Essential Features: The app should have a shopping cart feature for users to add items they wish to purchase. Additionally, a secure payment gateway is crucial for users to make transactions. Ideal Skills: - Proficiency in iOS and Android development - Prior experience in developing e-commerce applications - Strong understanding of payment gateways and shopping cart systems - UI/UX design skills to ensure a seamless user experience - Ability to work within give...

...in mobile app development - Expertise in geolocation services and security - Experience with real-time verification integration - Strong understanding of user access control WorkDo Dash SaaS I need a security lock on their app! On the panel, it needs a new function, geolocation! flow manager: The establishment manager enters the latitude and longitude data, and the radius of distance that the employee can mark the point. example: radius of 50 meters (employees will only be able to register the point within this radius) employee flow: Employee will log in to the app, the app will request their location, the app only allows registering entry or exit if the location is active The employee will only be able to check in or out if he is within...

Please Sign Up or Login to see details.

I need wedding photos edited, including retouching and background changes, using Photoshop. I have a batch of photos initially, so I'll need to see a sample of your work first. After that, if I'm satisfied, there will be more work, and, of course, payment for your services. & And I also want to edit the wedding video. If you know video editing then please send a sample.

I'm seeking an experienced math tutor to specifically help...me with Trigonometry functions. Here's what I'm looking for: - Tutoring through online video chat. - Expert knowledge in Trigonometric ratios, Unit circle, and Trigonometric identities (the focus areas). I want to start with trig function transformations. I want to start with basics such as amplitude, period and principal axis. After that I want to to do vertical shift which will be easier once you have those basics are covered. You may start from the graph of y = sin(x), then move on step by step until reaching y = a sin(b(x - c)) + d; where a, b, c and d are real numbers. Also, provide the same progressive explanation for cosine and tangent functions Please type in "Tri...

...Menu Display: A simple, easy to navigate section where users can view the menu which features our BBQ-Brisket, Ribs, and Burgers. - Location Map: An interactive map that indicates our food trailer's current and/or regular spots. As for the design aspect, it should reflect our branding elements including our: - Logo - Specific Color Scheme - Font Style The ideal freelancer for this project should have: - A strong background in web design and development - Experience with food industry websites would be beneficial - Graphic design skills for optimally displaying menu items and incorporating my specific logo, color scheme, and font style. This project focuses on function over complexity; Hence, a freelancer with the ability to create a ...

...as base: ------------------- Here's how you can set up a web application using PHP and Node.js with axe-core to test web accessibility. This setup will help you evaluate web pages for accessibility issues based on the URL provided by the user. Step 1: Setting Up the Environment Ensure that both PHP and Node.js are installed on your server, as PHP will handle the user interface and form submission, while Node.js will perform the accessibility checks using axe-core. Step 2: PHP Script for the User Interface The PHP script provides a form where users can input a web address. Upon submission, PHP will call a Node.js script that uses axe-core to evaluate the accessibility of the website. php Copy code <?php if ($_SERVER["REQUEST_METHOD"] == &q...

...this routine covered and this is not in scope. We are interested in the Surprise Trade. A Surprise Trade is where you offer a Pokemon, and you trade with a complete random person, who also offers a Pokemon. It is not known what will be traded, hence the name Surprise Trade. There are 2 Pokemon games that use Surprise Trade. Pokemon Sword and Shield, and Pokemon Scarlet and Violet (this game is the latest Pokemon game). Our Windows application already has a routine for the Surprise Trade in Pokemon Sword and Shield. It selects a file (.pk) and injects this Pokemon into the game, where it is then traded to another player. This is repeated indefinitely until the program is stopped. However, we have modified the above source to suit or ow...

I'm looking for a skilled app developer to create a photo sharing application for iOS and Android platforms. The primary purpose of this application is to share professional photographs. Key Features: - A function that enables users to like or upvote the published photos. - The capacity for users to share photos on other platforms should also be included. User Access: I would like the app to incorporate an email registration method for users to join and manage their accounts. The ideal freelancer for this project should have experience in building photo-sharing mobile applications and understanding user engagement features. Proficiency in iOS and Android app development is necessary. Your portfolio of similar projects will be of interest.

I'm in need ...Passwords (OTPs) I receive on my mobile device. Here are some key details about the project: - The extension should function on both Google Chrome and Mozilla Firefox. - I currently do not have any extensions or add-ons related to auto-filling or password management installed on my system. - The Auto-fill function will primarily be used on E-commerce websites and Social media platforms. Ideal skills and experience for this job include: - Proficiency in JavaScript and browser extension development - Previous experience with OTP systems - Strong understanding of browser compatibility and web standards - Proven capability of building secure software. Your understanding of user privacy and data protection is param...

I want add group chat feature in My Web App Laravel. I used Chatify by Munafio... This feature already have for public in youtube and github.

I'm seeking a professional to create a custom VST quite similar to RC20. The following features are a must: - Sound Effects: Distortion, Vinyl simulation, Noise generation, along with a digital, space, and magnetic sounds. - Clean and Minimalist Interface: I prefer straightforward design keenly focused on simplicity and function. - Advanced Sound Effects: Feature Echo/Delay, Reverb, Modulation, EQ Cuts, Gain. Ideal candidates should possess a deep understanding of sound engineering, the ability to design user-friendly interfaces, and prior experience in creating VST plugins. I look forward to your innovative proposals.

...designed for Android ,IOS, and Web platforms. The key features to be incorporated are: - QR Code Generation: The app should enable the generation of QR codes. This function is crucial as it will allow users to create their unique codes for payments. - QR Code Scanning: The application should equip users with the ability to scan QR codes. This process should be intuitive and user-friendly. - Payment Processing: An integral function of the app will be facilitating payments. It will be designed to process transactions seamlessly. The app is to support Standard QR code format - no dynamic or customized codes are needed. I expect the app to be secure, reliable, and easy to use for both merchants and customers. I'm looking for a professional wi...

I'm looking for a capable freelancer to develop an alert management system for Industrial Internet of Things (IIoT) using SCADA. The application's primary function is issuing immediate notifications to users via Email and SMS regarding various events: - Critical failure events - Alert events - Warning events Notifications should be dispatched using a policy and threshold value matching criteria with logic based on: - Event severity - Event priority - Event category These criteria will be employed for both email and SMS notifications. The chosen freelancer should have experience in SCADA systems, IIoT, and creating alert mechanisms. Expertise in managing event-triggered alerts based on customizable criteria will be highly advantageous. Master...

...in need of an expert who can convert my web application to a native app for both iOS and Android. Key Requirements: - The primary function of this app is content sharing. It should maintain the same level of functionality and user experience as the web app. - The app must also include a payment processing integration. Your responsibilities will include: - Wrapping the web app using Bravo Studios to ensure it runs smoothly on both iOS and Android platforms. - Ensuring seamless connectivity with the web app's existing backend for content sharing. - Implementing a secure and reliable payment processing system within the app. Ideal Skills and Experience: - Proficiency in both and Bravo Studios. - Prior experience in converting web...

I'm in need of a freelancer to design a s...need of a freelancer to design a simple, user-friendly blog website targeted at the general public. The primary function of this website should be for blogging. Key Features: - User Sign Up: The website should include a straightforward sign up process for new users to create an account. Ideal Skills: - Web Development: You should have experience in designing simple yet effective blog websites. - User Interface Design: The website needs to be user-friendly. Understanding of UX/UI design will be advantageous. With these specifications, I'm optimistic we can create a platform that successfully engages the general public with my blog content. If you believe you have the skills and experience to deliver this proje...

...are some key features of the job: - The core function of the website is to allow users to pay their utility bills. Hence, it has to be efficient, user-friendly and secure. - The selected candidate must be proficient in integrating the Payu payment gateway into the website. This will allow us to streamline all transactions. - The website needs a robust user management system. Users should be able to register accounts, log in, retrieve lost passwords, and have their own personal dashboard. - The ideal candidate should have a good grasp of web development languages particularly related with e-commerce websites. They should have hands-on experience integrating payment gateways and designing user management systems. Anticipate your informed bids and look...

...seasoned mobile app developer to create an Android application. This app will primarily function as an accounting tool, specifically focused on recurring transaction recording. Key Features: - The app should allow users to log recurring transactions effectively. - It's essential that the application provides robust and user-friendly features for efficient accounting. Ideal Skills and Experience: - Proficient in Android app development. - Previous experience in creating similar applications with recurring transaction features. I'm looking for a freelancer who can bring both technical expertise and a solid grasp of accounting concepts to this project. Your ability to deliver a clean, functional, and user-friendly mobile app will be crucial...

More details: Which platforms should the mobile app be developed for? Both What features must be included in the app for a seamless browsing experience? In-app purchase, Product search function, User reviews and ratings, payment gateway How soon do you need your project completed? Within a month

...before placing a bid ! Please bid only if you also plan to respond... Please someone who is interested in doing several projects Please make realistic offers and no fake offers where the price multiplies afterwards. Please keep in mind that changes can still be made during the testing phase ! NO Game ! NO Mobile Game ! NO Graphics ! NO Website ! Thank you! Knowledge of LUA & XML is required!! Hello, I'm looking for someone who can program an addon for the video game "World of Warcraft". It is not a game, but an interface modification. Similar to MODs in Minecraft or Skyrim. LUA & XML knowledge is needed. This addon is to allow the bags to move freely in the game. There are already suitable addon but they are outdated and therefore do not...

...The task will cover the back-end, integrating it with a functional database, and working on the API development to ensure smooth function. The specific features I want on the blog page are Social Media sharing buttons and a section for featured blog posts. I'm unsure about the exact design elements so ideally, I would appreciate some direction and advice on this. The ideal freelancer for this project is not only proficient in Laravel, but also possesses a knack for database design, API development, and a keen eye for user interface design. It'd be great if you had previous experience in blog integration and could provide examples. You should be able to contribute useful suggestions to enhance the functionality and aesth...

...website that allows us to provide pre-employment assessments for our clients. Nothing we need is new, and building from existing tools is acceptable. 1) Website. For the most part, pretty standard stuff. Other than this we would want: a) a test library so that people can see what tests we offer (but not the entire test, just a description or some example questions), and b) an ROI calculator - where the user can specify some details about number of jobs etc and we can show the ROI. We will provide the mathematical calculations. 2) Candidate Portal. Applicant needs to be able to: a) redirect to this from the job board or company career page, b) create an account and create and/or edit candidate profile. Profile could (optionally) be created a...

I'm in need of expert develope...in creating smart contracts on the Ethereum blockchain. Im looking for assistance in dealing with flash loans. The main function of our contract will center around the exciting field of Decentralized Finance (DeFi). Key features the contract should include are: - Yield Farming capabilities - Lending and Borrowing functionality - Liquidity Pool integration Ideal freelance candidates should have: - Proficiency in Solidity programming - In-depth understanding of the Ethereum blockchain environment - Prior experience in designing and implementing DeFi smart contracts - Proven track record with Yield Farming, Lending/Borrowing, and Liquidity Pool systems Please, only bid if you're confident in fulfilling these re...

...brand new Shopify website for my business. The main purpose of this website is to function as an online store, selling physical products. Job Roles: - Plan, design and develop a user-friendly and responsive Shopify website. - Establishing payment and shipping integrations. - Conforming to SEO best practices for product listings. - Implementing a visually appealing layout that complements our brand. Ideal Skills: - Proven experience in Shopify development and design is a must. - Comprehensive understanding of Shopify's system, including the addition of physical products. - Proficiency in setting up payment and shipping systems. - Experience with SEO strategy development and execution. - An eye for detail and commitment to ...

I'm lookin...voice changing AI applications that can function with the "Salaams" app on iOS and Android platforms. It's crucial that these applications have a real-time voice changer feature. I'm specifically interested in applications that can shift voice to a non-cartoonish, non-robotic female voice. Ideal Skills and Experience: - Extensive experience in AI app research - Detailed understanding of voice changer apps - Familiarity with Salaams app and its compatibilities Project Requirements: - Identify compatible voice changing AI apps for both iOS and Android - Focus on apps providing real-time voice change to a female voice - Exclude apps producing cartoonish or robotic voices - Deliver a comprehensive report detailing each...

I am seeking an experienced website developer to design and establish an engaging online presence for my new venture. My website's primary function is to provide information and resources about my business's offerings. Key requirements and considerations for the project include: - Primarily focused on providing descriptions about my products/services - Embodying the essence of my brand through professional design - Attracting a wide array of audiences as the target demographic remains open Ideal candidates will have a proven track record in building user-friendly websites that offer clear and concise information about products/services. A deep understanding of web design and branding is also desirable. Please only apply if you ca...

As a gr...offering both preset voice effects and the ability to tailor voice effects to specific needs. Furthermore, I would appreciate it if this application could be multi-functional, affording me the ability to manipulate voices during calls, as well as in pre-recorded audios. While the core function of the application lies in voice transformation, the presence of auxiliary features like background noise simulation or sound effects could be valuable. However, I am currently unsure whether I require these, leaving it up to the discretion of the expert to present such suggestions. Ideal Skills and Experience: - Extensive knowledge about mobile apps - Working knowledge of voice changing software or apps - Familiarity with iPhone compatible tools - Strong comm...

I am currently in search of a proficient software engineer who can build a desktop application specifically compatible with Windows. The core requirement for the software is to function effectively in data management. Key Features Requested: - Data Management Candidates must possess the following skills and experience: - Proficiency in software engineering - Expertise in Windows applications development - Extensive background in building data management solutions - Excellent problem-solving skills This project requires the construction of a powerful, user-friendly application that efficiently handles data management. Since Windows is the preferred OS, a strong understanding of this operating system is crucial. I look forward to receiving your proposal for this project.

1 Problem Statement and Datasets In this assignment, you will implement Vector Based Models to rank academic research papers. Refer to the code and dataset that can be downloaded from the zip file here. The code is written and tested in Python 3.10. The dataset consists of 8K research papers (or documents) and 100 queries downloaded from Semantic Scholar 1 . The zip file consists of: 1. file 2. file 3. 4. s2 folder with: (a) s2/s2 : All (8K) research papers in the corpus. Each research paper has 3 fields. i. docno: A unique document id for each research paper ii. title: Title of the research paper iii. paperAbstract: Abstract of the research paper A single paper entry looks like: { "docno": "6e4eddf4d6671c37537bb5d1c9623353b62e8531", "...

...for users to participate in crowdfarming. This app will enable users to register, create a profile, buy livestock assets, and track their investments and profits. In addition to these main features, I'm also interested in incorporating a referral program that rewards user for bringing in new investors. Key Features: - User Registration and Profile Creation: Users should be able to create accounts with their information and personal details. - Livestock Asset Purchasing: The app will function as an online marketplace for buying livestock assets. - Profit and Investment Monitoring: Users should have access to real-time information about the growth of their investments and profits. - Profit Withdrawals: Users should be able to easily w...

...website with one main function: A shipping calculator. Custom built, no API. Primary objective: 1) Customer chooses from country and to country (Very similar to this website's interface: ). 2) After the customer gets a rate from two couriers only (UPS and FedEx) and multiple shipping services, the customer provides more information about three things: A) The sender. B) The receiver. C) The package. Then a customer checks out using Paypal. Secondary objective but not as important or could done possibly at a later phase: 1) Package tracking which possibly needs an API. 2) Basic signup and sign-in menu similar to this of ( - Check it). Which the customer can see his order number, download a shipping label, and track a package). At

I am seeking skilled devel...for this project is image recognition. You will need to develop and implement strategies that effectively perform image identification on a fast, accurate, and great extent. - Web-based applications: As the final product will be web-based, substantial knowledge and proven experience in creating web-based applications would be preferable. - Education Apps: Having previously worked on education apps will be highly regarded. Understanding of what makes an educational app effective and engaging will be key in this project. Your role will involve not only developing the app’s image processing function but also integrating it into the overall app as a whole. I invite all qualified freelancers with a knack for image proces...

...configure the Function on an Video call to configure and define the below function for resizing images. I am in need of a functional AWS Lambda function, proficiently written in Node.js, to resize images dynamically on-demand. Here are the specific project requirements: - Programming Skill: The function should be written exclusively in Node.js. The successful applicant should have good experience with Node.js and AWS Lambda functions. - Image Resizing: The function needs to resize images on the fly, meaning it should dynamically generate resized images based on incoming requests. Experience with dynamic image processing will be of great advantage. - Image Source: The original higher-resolution images will be stored in Amazon S3, so kn...

Please read completely before placing a bid ! Please bid only if you also plan to respond... Please someone who is interested in doing several projects Please make realistic offers and no fake offers where the price multiplies afterwards. Please keep in mind that changes can still be made during the testing phase ! I am looking for a talented web developer to launch a Usenet search engine website. This is a unique opportunity for someone with hands-on experience in building secure, efficient and user-friendly search platforms. Here's a snapshot of what's on my wish list: Skills and experience: - Knowledge of HTML (as stated, but ideally also Python, JavaScript or PHP). - In-depth knowledge of NNTP (Network News Transfer Protocol) - Good track record ...

...on the Windows operating system. The core function that this app needs to provide is task management. Key Responsibilities: • Develop a high-performance, user-friendly task management desktop application. • The application needs to be highly usability-focused and intuitive. • Ensure high performance and responsiveness of the software. • Maintain quality and ensure responsiveness of the application. Ideal skills: • Exceptional knowledge in coding for desktop applications. • Previous experience in creating Task Management tools. • Proficient understanding of Windows desktop environment. • Good communication skills to understand project requirements better. • Ability to work under timelines and deliver as p...

...E-commerce functionality, a Blogging platform, and Contact forms to be integrated. Key Requirements: - E-commerce Functionality: I want to be able to sell products and services online. The system should be easy to use and manage. - Blogging Platform: I require a blogging platform to share information and news through blog posts. This should be user-friendly and customizable. - Contact Forms: I need a system in place to collect inquiries or feedback through contact forms. Additional Tasks: - Email Integration: Set up Microsoft 365 for email communication. - DNS & MX Record Cleanup: Remove unwanted DNS & MX Records to ensure smooth operation. - Server Setting: Make necessary setting adjustments on the server for the website to fun...

We have a package delivery company with a website built in .php where our users can book pickup and delivery of packages. Now we want to build an extra function where the user can see where the package is. For this reason we need a very very simple application for our driver to just start up for tracking, no other functions needed for now. And the data will be sent to our database for our website where we show everything on a map.

...be able to (i) report errors in the identifiers and integer literals, (ii) it should be able to recognize assignment operator and certain keywords. First get the code (in C language) for the lexical analyser described in the textbook working. Try it out on simple examples, e.g. (sum + 47) / total. It is not be able to report errors in identifiers and integer literals. (The rules for identifiers and literals are described in the book.) For example, how does it handle an illegal identifier ‘2sum’ or an illegal integer literal ‘23b2’? Make appropriate changes to the state transition diagram and the code to enable the lexical analyser report the above-mentioned errors. Second change is to enable the lexical analyser handle assignmen...

...business. The site should be able to handle transactions with credit cards as the main payment method. develop a website throw WordPress already we have account, also we have domain + hosting in GoDaddy, I attached here a sample of website, we need a website design and platform similar to this one, we will give you access to the account to complete the work. Requirements: - We have a domain registered with GoDaddy. - domain name - We need to develop a website similar to the one attached. - The website should function like a menu, featuring categories with products in each category. Each product will have choices for customers. - A payment gateway, Stripe. - Customers should select their location before placing an order. Map integration is needed to select the exac...

...both iOS and Android platforms. Key Requirements: - Aesthetic: The design should be simple and clean. It should have an easy-to-navigate user interface and a straightforward booking process. - Features: The core feature of this app is live tracking. It should also include: * An efficient in-app payment system to allow for seamless transactions. * A robust driver and rider rating system to ensure trust and safety within the community. * Effective push notifications to keep riders updated about their rides. Desired Skills: - Extensive experience in mobile app development, particularly in iOS and Android platforms - Proven track record in developing similar taxi/transportation apps - Strong knowledge in integrating payment gateway...

For this project, I need a proficient AWS lambda specialist. The main function should involve processing well-organized data. The core tasks and qualifications of the project are as follows: Tasks: - Implement an AWS lambda function to process structured data - Fetch the necessary data from an S3 source Required Experience and Skills: - Extensive understanding of AWS Lambda functions - Proven experience in processing structured data - Experience in sourcing data from an S3 Database is highly beneficial Your ability to understand the unique requirements of the project and deliver efficient results will set you apart. Let's collaborate to make this project a success. Looking forward to your bids.

I'm looking for an experienced script writer to create a funny, engaging text for a promotional video. The video is aimed at individuals...promotional video. The video is aimed at individuals who have yard work to do (snow blowing, lawn mowing, leaf blowing). It should be something that resonates with their experience and brings a smile to their face. Key requirements: - Experience in writing scripts for promotional videos - Ability to create humorous content - Understanding of the target audience, particularly people involved in yard work Please share previous projects or examples that demonstrate your skills in creating engaging, funny video scripts. The product we are promoting is called Yarbo - 3-in-1 multi-function yard robot. It's fully autonomous a...

...Processing and Data Scraping. The ideal freelancer for this job should have: - In-depth knowledge and skills in languages such as Python, Java, or C++ to efficiently build the bot - Expertise in Natural Language Processing and Data Scraping - Experience in building bots, particularly ones focused on task automation Although the bot is primarily for personal use, ensuring its compatibility across different platforms is fundamental. Therefore, any previous experience or knowledge in optimizing bots for varying platforms will be advantageous. We can discuss further the specifics of what platforms the bot should optimally function on as we move forward with the project. To sum up, I'm looking for a professional with robust coding skills, a deep understa...

...Android, using Kotlin and Firebase. This application will not just be an order tracking platform, but a suite that includes features such as: - Order Management: This core function should not only create and track orders, but also be equipped to handle special requests and customizations from customers. - Multi User System: The system should support multiple user logins with varying access rights. - Point of Sale (POS): The system should have integrated POS capabilities - Printing: Thermal Print functionality is a must-have in order to generate customer bills and other essential hard copies. -Reports - sales report, profit etc. The preferred candidate would have prior experience in Kotlin and Firebase applications. Proficiency in creating An...

I'm in need of an Arduino Programmer with expertise in DC motor control, programming logic, and inductive proximity sensor integration. Specific tasks include: - Programming logic for the DC motor microcontroller - Integrating an inductive proximity sensor for object detection - Implementing a speed regulation function (slow start, slow stop, foward, reverse speed and delay start) for motor control Please find the project detail on the attached document.

I'm seeking a skilled app script professional to improve functionality in my current Google Sheets. The job entails creating connections with external APIs, and add a multiple drop down function in Google sheet. This is different than dependent drop-down and I require to use just one cell for the multiple drop down rather than using the next cell. Key requirements: - Add two dropdown menus - The menus need to feature a predefined list of words - Experience with Google Sheets and App Script Recommended skills: - Google Sheets - Google App Script - API Integration

I am in need of a logo design that incorporates both text and an iconic symbol. Our desired style is modern and minimalist. We intend to primarily use this logo online, on our website and various social media platforms. Key requirements: - Ability to create a balanced and impactful combination of text and icon - Expertise in modern and minimalist design aesthetics - Understanding of the digital landscape and how logos appear and function online