Hello, In formula mode, Excel only shows reference to cells and not the actual number. I need an excel function that will convert formulas (Cell B4) to actual numbers (Cell C4). The attached image will explain what is needed.
...following areas: - Design and Layout: This extends to 76 slides that need a makeover. I'm looking to incorporate a corporate and professional aesthetic in accordance with my company's identity, and at the same time making sure the design flow is coherent throughout the deck. - Visuals and Graphics: The deck has high-quality and impactful visuals. Expertise in manipulating graphic design tools and visual data representation is a huge advantage for this job. This project demands a good eye for design, excellent understanding of corporate aesthetics, advanced skills in tools like PowerPoint or Keynote, and perhaps most importantly, creativity. That's the combination I'm looking for. Let's work together and bring this deck to a whole new level! Possibilit...
...Singapore-based business information provider specializing in connecting businesses with global capabilities; comprised of industry veterans, Confirmis's business model is designed to overcome perennial lack of data (let alone quality data) to support effective decision-making, particularly in developing economies. As a Site Verifier, you will be responsible for verifying a company’s existence through visual data by conducting a site visit to ensure that we provide reliable and accurate information to our client. JOB DESCRIPTION: • Conduct basic verification with the subject company’s authorized representative, such as line of business, key executives' names, etc. • Take pictures of the subject company and its vicinity, as per Confirmis’ sta...
Extract Source Code locked by Tradingview by invite only pine script, extraction,
I'm conducting a research project exploring how visual information, specifically lip movements and facial expressions, influence speech perception. The study aims to shed light on this intriguing aspect of human communication. For this study, I'm looking for participants from the general public, as the findings should be representative of everyday interactions. In particular, it'd be ideal if the freelancers here have: - Experience in research design and data collection. - A background in psychology or communication sciences is highly beneficial. - Knowledge of or experience with the McGurk effect is a plus. - Skills in conducting online surveys and data analysis. The main objectives of the study are as follows: - Understand how lip movements impact the perception o...
I need an experienced translator to convert an English book to Hindi. The ideal freelancer should have: - Fluent proficiency in English and Hindi language - Extensive experience in translating literary material - A knack for maintaining the essence of the original text. Your task will include conveying the style, tone, and intent of the original piece in a culturally relevant manner rather than translating word for word. Previous work in book translation will be a plus. To ensure efficient translation and formatting, consider creating a separate file for each document that needs to be translated into Hindi and converted to Microsoft Word. Please utilize the font 'Times New Roman' with a size of 14. Additionally, ensure that headings are set to a font size above 17 Ple...
I have written one research paper and I am seeking help to convert the content into research document format like IEEE. Please get in touch with me if anyone is interested.
I am looking for a graphic designer to create a logo for my project. I have specific ideas in mind for the design style and theme. I would like to be presented with one design concept for the logo. Ideal Skills and Experience: - Proficiency in graphic design software - Strong understanding of branding and visual identity - Ability to incorporate specific ideas into the design - Attention to detail and creativity
I'm looking for a professional with a knack for online storefront design. The perfect freelancer would have expertise in creating appealing themes or styles suitable for an Etsy shop. Requirements: - Designing a theme dubbed "Ocean/Island/Sea/Waves/Sunsets/Sailboats" aligned with a modern look, with visual elements that reflect the ocean, islands, seas, waves, beautiful sunsets, and sailboats. I would like to incorporate some of my own Vieques Island photos in the design as my shop products all revolve around the tropical island of Vieques, Puerto Rico. - An ability to nicely incorporate categories into the design: Jewelry, Home decor, Clothing, Artwork, Accessories, and Crafts; all reflecting the unique island lifestyle. Ideal Skills and Experience: - Gra...
I'm looking for a talented 2D animator to breathe life into a 1-3 minute narrative video. This project requires: - Expertise in 2D animation - Strong grasp of visual storytelling elements - Ability to create engaging, expressive characters in a narrative setting - A portfolio of similar animation work Ideally, the freelancer will have previous experience in narrative animation projects and a passion for storytelling. Your main goal will be to keep viewers engaged and connected with the story from start to finish. If this sounds like something that matches your skills and interests, I'd love to hear from you. you can use this script as the prompt for the video. Remember the video will also include visuals, so the job is just to animate the character telling the story whi...
...Strong attention to details - Experience in conceptual art and understanding of pensions - Understands how to effectively convey themes and concepts in their work Project Details: - The goal is to create a realistic digital sketch of our pension after reform construction has been completed. - The sketch doesn't have to be photorealistic, but it should definitely be detailed. - We expect effective visual communication of the idea, paying particular attention to the nuances of the required style which is supplied in the supporting documents. - Pay attention to the color palette of supplied docs & referred villa If you have a sharp eye, enjoy bringing concepts to life through digital art, and have an understanding of pensions, I would love to meet you. Your skilled cre...
I'm in need of a professional animator proficient in creating realistic 2D animations. The purpose of this animation is for an entertainment project. The ideal freelancer for this job should have: - Solid experience in creating realistic 2D animations. - Prior experience in entertainment-related projects. - Ability to translate ideas into captivating visual narratives. Your role will involve transforming a given concept into a compelling, entertaining animation. You will animate a character who narrates the story in each of my videos. If you're a creative animator with an affinity for realistic style, this is the job for you.
...Singapore-based business information provider specializing in connecting businesses with global capabilities; comprised of industry veterans, Confirmis business model is designed to overcome perennial lack of data (let alone quality data) to support effective decision making, particularly in developing economies. As a Site Verifier, you will be responsible for verifying a company’s existence through visual data by conducting a site visit to ensure that we provide reliable and accurate information to our client. JOB DESCRIPTION: • Conduct basic verification with the subject company’s authorized representative, such as line of business, key executives' name, etc. • Take pictures of the subject company and its vicinity, as per Confirmis’ standard...
I am seeking an experienced landscape designer to help create a fresh modern minimalistic design for my front yard. Project scope: - Innovation and creativity are key. This is a modern minim...incorporated into the yard's design. - Small Front yard area to re-design is 6.6m x 2.3m Skills and Experience: - Experience with modern minimalistic landscape design is a must. - Knowledge of plant selection and maintenance for minimalistic flower beds. - A good eye for aesthetics, design and detail to create an inviting front yard space is imperative. - Proficiency in drafting and presenting clear visual plans for the proposed redesign. Can provide pictures of front of house once chosen for project. In your bid, please share details of similar front yard landscape projects you ...
I'm looking for a skilled video editor who can handle advanced tasks such as creating motion graphics and special effects. Since there's no time limit, I am prioritizing quality over quick turnover. While I ...quick turnover. While I haven't specified a preferred software, proficiency in popular tools like Adobe After Effects, Cinema 4D, or Blender is appreciated. Desired skills include: - Expertise in video editing and visual effects - Creativity and originality in storytelling using visual effects - Strong attention to detail - Good communication for understanding and executing creative vision. Regardless of the software you use, I'm interested in the magic you can create with it. Don't hesitate to bid if you think you can make my video footage c...
I am seeking a video creator who is skilled in making how-to videos for my app. The videos should serve three main purposes: 1. Introducing the ...three main purposes: 1. Introducing the app's features 2. Explaining the functionality of the app 3. Offering troubleshooting tips The target audience for these videos are beginners. Therefore, it's crucial for the content to be simple, easy to understand and engaging. Video content should provide a high-level overview of the app, its features, and functionalities. The preferred approach is visual and concise rather than in-depth step-by-step instructions. Ideal candidates should have experience in creating tech-related how-to videos, understanding of app usability, and capability of conveying technical details in a simple...
I'm looking for an video editor who can work on my videos with editing techniques. Your primary task includes applying motion graphics, visual effects, and entertaining edits to the video Key Requirements: - Ability to perform editing which includes but not limited to, motion graphics, visual effects and 3D animation. - Produced work that is to be used specifically for social media advertising. - Experience of delivering final videos that are more than 20 minutes in length. - Have experience in editing Gaming videos/ Rust experience
I need an experienced web developer to create a portfolio web...This site should be easy to navigate and visually engaging, aimed at promoting my work to prospective clients. I already have a figma design ready to use, just need someone to bring it to life. Key requirements: - An aesthetically appealing interface that effectively displays the visual nature of my work. - A categorization system for projects based on type. - Clear, high-quality images of each project. - Ease of content management for constant updating with new projects. Ideal skills & expertise: - Strong visual design aesthetic and understanding of modern web design principles. - Proficient in modern web development technologies and image optimization. - Experience in creating easy to use and intuitive ca...
...create a physics-based simulation, with a focus on robotics. This simulation is for a comprehensive analysis and demonstration of complex robotics systems in different environmental scenarios. Key responsibilities entail: - Setting up a physics-based simulation using the Omniverse Isaac Sim framework that is focused on robotics. - Ensuring that the simulation can generate realistic, high-quality visual and realistic outputs while maintaining optimal performance. The ideal technical skills and experience for this job require: - In-depth knowledge and practical experience in Omniverse Isaac Sim. - Profound understanding of physics-based simulations, specifically in the field of robotics. - Demonstrated ability to create detailed, real-time simulations embodying advanced tech...
As the client for this project, I am seeking a Shopify expert to create an online store. The chosen professional will replicate a provided sample website and add products as specified. Key responsibilities: - Utilize an appropriate Shopify template - Mirror the visual aesthetics and functionality of a provided sample website - Load products into the store based on the sample website Ideal Skills & Experience: - Demonstrated proficiency in Shopify website creation - Intermediate level of experience in e-commerce and website development - Excellent attention to detail - Ability to mirror an existing website's design and functionality All applicants are encouraged to share their relevant experience in detail with their application. Your proven track record will help suss o...
As a growing HVAC service provider, I'm keen to increase my brand visibility through eye-catching, bold, modern, clean, and professional vehicle wrap and lettering designs. Key requirements: - The design should effectively promote my core services, namely: Air conditioning servicing, Heating system repair, and HVAC installation. - Quality designs that amplify my brand's visual appeal, increasing potential for lead generation. Ideal Skills and Experience: - Proven experience in vehicle wrap and lettering design - Excellent understanding of blending colors, fonts, and images together - Experience in graphic design, specifically for vehicle wraps in the HVAC industry.
...a portfolio or examples of your previous logo designs, especially in educational theme if any, which will help me understand your style and quality. Skills and Experience: -Strong graphic design skills with a strong portfolio -Proficiency in graphic design software including Adobe Photoshop, Adobe Illustrator, and other visual design tools -Creativity and problem-solving skills -Strong communication skills to understand the brief and transform it into thrilling visual content. - ability to brainstorm with me and create multiple versions until we have something we love. If you believe you have what it takes to design a symbolic logo that can hold its own in the educational industry, I encourage you to apply. I am looking forward to seeing your previous designs and hope...
...of blue, orange, and gray. Include subtle, consulting-related imagery or icons that hint at the game's themes. Back Side Requirements: Each design should include a color-coded system and icons relevant to the card type. Designs should be clear, inviting, and ensure the text is easily readable. Maintain a balance between visual appeal and space for card text and illustrations. Top: Card Type (e.g., "Project", "Action", "Challenge", “Special”) with a distinct color code and icon for quick identification. Middle: A vivid, thematic illustration related to the card's content. For instance, a "Quick Win" Project Card might show a consultant triumphantly holding a briefcase up, while a "Scope Creep" Challe...
For my project, I need a professional 3D artist who can interpret an illustration of an art toy concept and convert it into a 3D art model. The model should: - Have a table-top scale, so ensure the size is proportionate. - Be delivered as a digital 3D representation and a printable 3D file suitable for prototyping. - Faithfully reproduce the colors, textures, specific design elements, and the expressions/ features of the character from the illustration. The artist should have the experience and proficiency in 3D modeling and should pay keen attention to detail, re-creating the soul of the illustration in 3D. Familiarity with creating models for prototyping is a bonus, as it is an important part of the project. I have attached a few examples to help visualize what we are attempting...
I am in need of an expert who can proficiently write a C code for Task 1 and Task 2 of my project. The tasks require in-depth knowledge of algorithms implementation, specifically sorting algorithms, searching algorithms and graph algorithms. The C code should effectively work with data structures, particularly doubly linked lists, to implement these algorithms. The purpose of this project is data analysis and file manipulation. Ideal Skills: - Strong grasp of C programming language - Proficiency in working with doubly linked lists - Extensive knowledge in sorting, searching, and graph algorithms - Experience in data analysis and file manipulation
I am on the hunt for a highly skilled 3D animator to create a realistic animation meant for marketing purposes. The animation should: - Possess a realistic aesthetic, showcasing an impressive level of attention to detail. - Be less than 1 minute in duration. It needs to be engaging, delivering a striking message in a short amount of time. - Align with marketing str...strategies and principles, becoming an essential asset in the promotional aspect of the business. reference: The ideal candidate should showcase previous experience in creating 3D animations, particularly realistic ones. A strong understanding of marketing principles and how to convey promotional messages effectively through visual media is highly desirable.
I'm seeking a skilled graphic designer to create abstract, simple yet attractive thumbnail album covers for a classical music digital release. This project extends to designing a flyer using the...suggestions. Both vibrant and subtle color tones can work; feel free to be imaginative. - Overall Aesthetic: It must be elegant, simple yet captivating, hinting at the classical music genre. Ideal candidate: - Experience in graphic design, particularly in creating album covers or promotional material in the music industry. - An understanding and appreciation of classical music is a plus. - Strong visual storytelling ability to communicate the core essence of the music through design. Please include a link to a portfolio with similar works in your application. Looking forward to our...
I require an llustrator who can convert a picture into into cartoon-style illustration I provide the picture of the animal, I need to get JUST the donkey as a funny cartoon-style illustration with the word "Igor" No need to convert the horses, just the donkey.
I'm seeking a proficient After Effects user with expertise in visual effects, specifically green screen keying. I have the green screen footage ready for you to work with. Your main task will be enhancing the visuals to take my project to the next level. Knowledge of particle effects and color correction will set you apart from others, although they aren't part of the core requirements for this project. Experience in similar projects with a fast turnaround time is desirable.
As someone with a keen eye for aesthetics, I need a proficient web developer who's an expert at utilizing Oxygen Builder. The changes I need are primarily focused on the layout of my website's homepage. Here's a breakdown of what needs to be done: - Arrange the layout in a way that ensures a consistent size for all icons across all platforms. - Ad...the final design looks cohesive and visually appealing. The perfect candidate for this job should have a strong background in web development, foundation knowledge of UX/UI principles, and proven experience with Oxygen Builder. Any portfolio showcasing previous work done with Oxygen Builder will be viewed favorably. I'm after someone who pays attention to detail, understands the importance of visual consistency and ...
...would be great this way i can make sure i always can get someone to work. If you bid more than this, I know you didn't read this. The current sites have several issues going on which is due to breaks with theme/plugins and php versions. Note this is an hourly job for fixes as needed, not full time, about 10-20 hours per week depending on the amount of work that needs to be worked on. Must use a visual time tracker which i use is Apployee which takes screenshots so i can see work being done. All actual billing can be done through here. Note this is NOT a web designer position but more technical work. It is imperative that i see your mentions of bug fixes and plugin development, i don't specifically need a web designer. Tasks will be mostly working on cosmetics and bu...
Hi, I need to deploy a python that I have in multiple services in AWS (either lambda or in ECS containers for the code that takes more than 15 minutes). I will split this job into milestones with a description and a time estimate for each milestone. Thanks.
...creating engaging and captivating content, driving brand awareness, and attracting a legion of loyal followers to our page. We'll provide you with a treasure trove of videos and content showcasing our battery testing process – your mission is to transform them into viral sensations that electrify the TikTok community. What We're Looking For: - A creative powerhouse with a knack for storytelling and visual storytelling - A TikTok aficionado with a finger on the pulse of the latest trends and viral content - A strategic thinker who knows how to leverage TikTok's algorithm to maximize reach and engagement - A team player with excellent communication skills and a collaborative spirit - A passion for clean energy and sustainability is a plus! What You'll Do...
Description: I am looking for skilled individuals to convert an existing floor plan drawing into a SketchUp file. The floor plan consists of a main floor and mezzanine and is currently in PDF format. The converted SketchUp file should accurately represent the floor plan in 2D and include measurements. Deliverables: Converted floor plan in SketchUp (.skp) format. The SketchUp file should clearly depict the floor plan in 2D with accurate measurements. Submission Guidelines: 1. Download the attached PDF floor plan drawing. 2. Convert the floor plan drawing to a 2D SketchUp file. 3. Ensure all measurements are accurately represented. 4. Submit the final SketchUp file (.skp) as your entry. Evaluation Criteria: - Accuracy of the conversion. - Precision of measurements. - Attenti...
...in modern design. The focus will be on revamping two rooms in my home: the living room and bedroom. **. Key Tasks: ** - Provide advice on changing the overall layout to enable a more streamlined, modern look - Create custom made closets for me. - Advice on lighting - Dimensions of closets - Based on Pinterest - Provide expert opinion on choice and placement of furniture to create a stunning visual appeal Skills and Experience: - Evidence of previous work in modern interior designs - Excellent sense of aesthetics, especially in relation to furniture selection and arrangement - Ability to translate ideas into functional and aesthetically pleasing space layout - Creative and innovative thinking is important to achieve extraordinary results The end goal is to enhance my livin...
...decisions. Building It: The Tech Behind It: We're thinking Python because it’s great for this kind of job, using tools like Selenium for browsing Alibaba, BeautifulSoup for looking through the webpage content, and pandas for organizing and saving the info. How You’ll Use It: We’re keeping it simple. You can type your search right into the command line, or if you’d prefer something a bit more visual, we’ll make a basic graphical interface. Keeping Things Organized: All the info we find will be neatly saved in a CSV file, but we can also set it up to save to a database if you’re dealing with lots of data. Making Sure It Works Smoothly: We’ll make sure the tool can handle errors like bad internet connection or unexpected website ch...
¡Descubre nuestro paquete de diseño gráfico exclusivo de logotipos minimalistas! Obtén una identidad visual única y moderna con todos los elementos necesarios para destacar en el mercado. Nuestro paquete incluye: 1. Desarrollo de la identidad: Trabajaremos contigo para comprender tus necesidades y preferencias, y crearemos bocetos iniciales para capturar la esencia de tu marca. 2. 5 mockups: Te presentaremos una variedad de opciones de logotipos minimalistas en diferentes contextos y aplicaciones, para que puedas visualizar cómo se verá tu marca en el mundo real. 3. Tipografía: Seleccionaremos la tipografía perfecta que refleje la personalidad de tu marca y que se integre de manera armoniosa con el logotipo. 4. Eleme...
I'm looking for a creative and professional logo design for my business, Texas Audio Video Solutions. We provide high-quality audio and video solutions for both residential and commercial clients. The logo should be in 3 forms that c...solutions. 2. A logo that is stylish, modern and professional, appealing to both residential and commercial clients. 3. Color schemes should be modern. Show one with the attached color scheme and at least one alternate color options based on your creativity. I'd like applicants to show: - Their creative process, via samples of previous logo designs Designers with experience in the tech or audio-visual industry would be ideal. Any additional expertise in branding would be a plus. Please provide a detailed project proposal outlining your ap...
I'm looking for an experienced t-shirt designer with a keen artistic eye to create unique designs for an upcoming Mother's Day and F...collection. Key Requirements: - Create sellable designs in the theme of Mother's Day and Father's Day. - Incorporate elements of hearts, family portraits, and funny quotes into the designs. - The quantity of designs needed is between 50-100 for each theme. Ideal Skills and Experience: - Experience in graphic design, particularly in designing clothing apparel. - Strong understanding of themes and visual elements that resonate with audiences during Mother's Day and Father's Day. - Good sense of humor and ability to incorporate subtle, family-friendly humor into designs. - Ability to deliver high-quality work on time and...
The task is centered around entering text data taken from digital documents into an Excel spreadsheet. A...centered around entering text data taken from digital documents into an Excel spreadsheet. Accuracy and attention to detail are a must. Take data out of pdf and word documents and enter into an excel file for few of the fields that are required. We can try using python or other scripts but maybe manual as well. Total of 62 reports (rows of data) to be entered. Key requirements: - Ability to convert data from digital documents to text format - Proficient in data entry - Strong Excel skills - Detail-oriented - Ability to deliver work within the stipulated timelines Please ensure you have the necessary skills and experience before placing a bid. Looking forward to your ...
I need a skilled freelancer who can help with creating 2D AutoCAD drawings. Here's what needs to be done: - You'll convert my sketches into polished 2D AutoCAD drawings. - The level of detail required goes beyond basic line work: I need drawings detailed with notes and specifications. - If you have your own set of layering standards, feel free to apply them - I don't have a particular requirement in this regard.
I'm looking for a skilled video editor who can bring a cinematic aesthetic to our corporate event footage. Your tasks would include: - Editing raw footage of company events into a ...include: - Editing raw footage of company events into a polished, professional, and engaging video - Incorporating cinematic elements and style into the editing process Key skills and experience: - Proven background in video editing, particularly corporate event videos - Strong command over cinematic-style editing - Ability to translate briefs creatively and effectively - Keen eye for details, visual composition, and storytelling - Solid portfolio demonstrating previous editing work I'm looking forward to seeing your bids. Please include samples of prior corporate videos you've edi...
I'm looking for a skilled video editor who can bring a cinematic aesthetic to our corporate event footage. Your tasks would include: - Editing raw footage of company events into a ...include: - Editing raw footage of company events into a polished, professional, and engaging video - Incorporating cinematic elements and style into the editing process Key skills and experience: - Proven background in video editing, particularly corporate event videos - Strong command over cinematic-style editing - Ability to translate briefs creatively and effectively - Keen eye for details, visual composition, and storytelling - Solid portfolio demonstrating previous editing work I'm looking forward to seeing your bids. Please include samples of prior corporate videos you've edi...
I am seeking a graphic designer to create a corporate and professional style online pamphlet for my small business. Key Responsibilities: - Apply your expert understanding of graphi...expert understanding of graphic design principles to create an engaging pamphlet. - Work collaboratively with me to choose a perfect color scheme for the design. I'm open to suggestions and excited to see your creative ideas. Ideal skills: - Extensive experience in graphic design, particularly in corporate and professional style. - Strong communication and collaboration to transform concepts into visual reality. - Creativity and problem-solving skills to suggest the most suitable color scheme. I look forward to seeing your portfolio and discussing this further. Let’s create something r...
...FilamentPHP and I need expert guidance to clarify some confusing points. My doubts are related to: - The syntax and code structure - Writing controllers - Creating views - Managing routes I also need to understand how to handle tables and forms without using panels. Unfortunately, the chosen solutions on handling this were not specified, so an ability to offer and explain diverse solutions would be extremely beneficial. We need to use filamentphp tables, forms, actions and widgets in current project, but without using filamentphp panels to continue using our current layout. The perfect freelancer for this task will have: - Deep understanding of FilamentPHP 3, including syntax, code structure, and core functionalities - Practical experience with creating Panels, Tab...
(Blurb May Change) This is a LitRPG story. In the blink of an eye, Silas's world is turned upside down. One moment, he's a data analyst navigating spreadsheets and avoiding office politics; the next, he's thrust into an ancient realm of magic and mayhem, summoned by a desperate sorcerer seeking a champion to save their world. But Silas? He's anything but a fighter. His battles are against deadlines, not dragons. Yet here he stands, chosen to be a guardian in a world that's as beautiful as it is deadly. With the help of a mute child, who is as deadly as she is silent they must navigate treacherous terrains while learning to master his new abilities in order to survive. True power isn't just about mastering your weapon, but also mastering yourself. With an an...
...the horizon, suggesting the ambiance of either sunrise or sunset. The knight and horse, both showcased in profile view, are intricately designed, with the knight brandishing a sword that has lightning intertwined along the blade. Both figures are adorned in medieval armor, symbolizing strength and valor. • Anachronistic Elements: Above the knight, a black flag billows, adorned with white binary code—a nod to our digital age. The flagpole is encircled by a black cobra, an homage to our squadron's previous mascot. Adding to the temporal juxtaposition, the silhouettes of modern aircraft—specifically a U-2 Dragon Lady ahead of a B-29, again referencing the history of the squadron—are seen in the distant sky, bridging the gap between past and present warfa...
I am after a professional with skill in minimalistic design. The primary task is creating a dummy web layout that favors ease-of-use while providing crucial information for the site's visitors. Here's the breakdown: - Purpose: The website layout should be primarily informational, geared towards providing straightforward, easy-to-...scrolling "Home" page - User Experience: The home page needs to be simple, aiming to deliver straightforward information to the users rather than presenting multiple sections or relying on heavy media. Ideal candidates should have a solid background in UI/UX design with a focus on minimalism and simplicity. Dummy layout to be prepared in Canva or similar, and to incorporate 2.5 pages of Word copy. Visual style is flexible, with a...
