Excel change shape color based on cell value without macrodela

Potrebujem app ki prebere excel in ima možnost vnašanja(import) excel tabel, dostopno mora biti preko mobilne/web aplikacije, imeti mora možnost razporejanja oz dodajanje dela večim ekipam, na koncu mora vse skupaj združiti v skupno tabelo, odšteti količino porabljenega materiala za delo oz voditi zalogo opreme in ločeno voditi količino porabljenega materiala za posamezno stranko, moznost uploada slik za posamezni id stranke, in upload to na pc oz web server

Narisati je treba shemo nadzornega sistema stavbe po nadstropjih in v vsako nadstropje vnesti komponente iz excel tabele - do 100 komponent

Obdelava podatkov, izdelkov različnih proizvajalcev iz različnih virov z Query-ji, lepljenje po ID-ju ipd ipd Trenutno imamo 1 projekt za nekaj ur dela. Po podobni logiki so v pripravi novi projekti..

...would like to renovate the bathroom. The room itself is narrow and long. We would like more space and instead of a bath, we want a shower. The entire apartment is white and combined with oak and LED lighting. We want a bright, fresh and minimalist bathroom. Renovating the bathroom would also replace the doors from the bathroom and the doors to other rooms in the hallway. Since the hallway is without light, we want to get daylight by installing a glass door that would let light from the rooms into the hallway. Radi bi prenovili kopalnico. Kopalnica je ozka in dolga. Radi bi več prostora in namesto banje, tuš kabino. Celotno stanovanje je v beli barvi in v kombinaciji hrasta z led osvetlitvijo. Želimo si svetlo, svežo in minimalistično kopalnico. S prenovo kopalnice bi ...

need help with spreadsheet formula

I would like to add new features to excalidraw. When importing SVG, I would like to add a function that can accurately recognize SVG's paths and curves and change the color and border color of each object. excalidraw_official site

I need an experienced photo editor to remove a logo that appears on the screen behind a large group picture (remove the brains/lightbulb/book and the words "SDS Specialists Team") Key requirements: - Eliminate an image on the screen behind a large group picture - Replace it with a solid white background on the screen, matching the existing background color Ideal Skills and Experience: - Proficiency in photo editing software - Strong attention to detail - Previous experience in editing group photos - Ability to seamlessly match and replace background colors - Understanding of design principles for a distraction-free image

I'm looking for a talented graphic designer to create a flyer for a training workshop. The event is scheduled for tomorrow and will be held in Orlando, FL. Requirements: - The flyer should be simple, clear and professional - Please include the address and Google Map link - Your design should be suitable for a professional audience - No specific color or theme is required Ideal Skills: - Graphic Design - Adobe Photoshop - Understanding of professional design standards Please bid if you are available to turn this around swiftly. Thank you.

I am looking for a skilled graphic designer to create a modern, minimalistic logo for me. The logo should resonate creativity and innovation. Even though I've skipped the color choices, I am open to suggestions. Key aspects of the role include: - Creating a minimalistic yet compelling logo design - Providing innovative color suggestions for the logo The ideal candidate will: - Have significant experience in logo design - Proven track record of creating visual identities that stand out When applying, please focus on your experience in the graphic design field, especially related to logo creation. Please do not include past work, as I am more interested in your process, creativity, and design thinking skills.

...my mobile detailing business, "Precision Pros Mobile Detailing". I'm looking for a skilled designer who can capture the essence of my business and represent it through a high-quality logo. Key Details: - Business Name: Precision Pro Mobile Detailing - Preferred Color Scheme: Blue and Silver (any other if looks good) - Desired Elements: Car Silhouette and Water Droplets Ideal Skills and Experience: - Proficient in graphic design and logo creation - Experience in creating professional and eye-catching logos - Understanding of color psychology and its application in branding - Ability to incorporate multiple elements seamlessly - Strong communication skills to understand and implement feedback Please provide a portfolio of your previous works, particularly a...

...to box dimensions of 6.3 x 2.5 x 5.2 cm. Key Requirements: - The preferred color scheme for the packaging should predominantly be white with the option to use up to 3 additional colors. Black/Grey's may be used but not be the dominant. - The main design element should revolve around the product's purpose which is to clean screens of electronic devices like phones, laptops, and tablets. - Visual elements you should incorporate are images of electronic devices and screens or screen icons. Ideal Skills: - Proficiency in packaging design, particularly for small boxes. - Strong grasp of minimalist design principles. - Experience in creating visually appealing designs for electronic products. - Solid understanding of color theory and an ability to create a design tha...

...(safety, writing style, verbosity, followed instructions, truthfulness, overall quality). For example, “safety” indicator means presence of toxic or offensive language and so on. 2) You will compare the two statements and decide which one is a better answer to the question 3) You will provide a brief justification to your decision You are our perfect candidate if: - You are a native-level fluency in Japanese or have a C1 certificate of Japan - Your English proficiency is fluent - Your laptop meets requirements: RAM from 6 GB, Windows 10+ or iOS - You have stable internet connection - You are self-organised, can work without supervision Mindy Teams is an international outsourcing company, a European leader in the field of Data Annotation for Artificial Intell...

I'm searching for a professional well versed in Excel to help with lookup functions. I'm struggling with finding matching values and retrieving data from different worksheets in a text-based file. Key parts of this project: - Locating matching values across two worksheets - Retrieving needed text data from another worksheet The ideal candidate will have: - Strong proficiency in Excel lookup functions - Experience dealing with data across multiple worksheets - Understanding of text-based data within Excel

I am looking for an experienced editor who can correct grammatical errors and punctuation, rewrite sentences or pa...that the content remains professional. The form is between 500-1000 words long, and the editor is required to fact-check and verify information without completely rewriting the content. Key Responsibilities: - Correct grammatical errors and punctuation - Rewriting sentences or paragraphs for clarity - Ensuring the professional tone is maintained - Fact-check and verify information Ideal Skills and Experience: - Proven experience in editing - Strong grasp of grammar and punctuation - Ability to maintain a professional tone - Experience in fact-checking and verifying information - Attention to detail and ability to work situation based without wiping...

I'm in search of a creative and talented cloth designer to bring vibrancy and cuteness to our baby-focused brand. My priority is baby clothes and diapers that reflect joy, innocence and exploration. Key Responsibilities: - Design prints/patterns for both baby clothes and diapers - Ensure designs are suitable for newborns up to 3 years - Create themes around animals, fl...are suitable for newborns up to 3 years - Create themes around animals, flowers, and cute fantasy characters Ideal Candidate: - Experienced in children's clothing design - Demonstrated expertise in crafting cute, colorful prints and patterns - Able to envision age-appropriate, engaging designs - Possesses a fun and creative approach to their work Diapers Bottom - One color Upper - second color...

As a bus...through instant messaging. This will help ensure we're both on the same page and will facilitate quick exchanges whenever necessary. Decision-Making Authority: The virtual assistant will have limited decision-making authority, which means they will be primarily involved in email management tasks. I will provide clear guidelines and specific instructions to help them navigate through the workload effectively. Ideal Skills: - Strong organizational and time management skills - Excellent written communication skills - Proficient in using email management tools - Comfortable with instant messaging platforms - Ability to follow instructions and work within defined boundaries If you believe you have the skills and experience necessary to excel in this role, I�...

I am seeking a talented graphic designer with experience in minimalist design style and game graphics. The project involves creating a splash screen for a quiz game. Here are the specifics: • Design Style: Minimalist - I appreciate clean lines, subtle detail, and space. • Color Scheme: Cool colors (blues, greens, purples) - The design should be visually engaging and elicit a sense of calm and focus. Ideal candidates would have a keen eye for detail, a strong grasp of minimalist design principles and have prior experience in quiz game graphic design. If you have a portfolio of similar projects, please include this in your proposal. I look forward to potentially working together.

...brochure that convey creativity and innovation. The projects would require: - **Logo Design:** - Needs to be innovative and creative. - Should reflect the startup's uniqueness and vision. - A strong understanding of color and typography is a must. - **Brochure Design:** - The brochure should be equally creative and innovative. - It needs to be designed in a way that it stands out and captures attention. - Should be able to translate complex ideas into simple, attractive visuals. For both the logo and the brochure, I'm open to your suggestions regarding color scheme. It's crucial that the final design speaks to the creativity and innovation at the heart of the brand. Ideal candidates should have: - A strong portfolio showcasing innovative an...

I need an Excel-based grading system that calculates weighted averages for students based on their scores and converts those scores into letter grades. The main requirements are: - Excel-based system for tracking student grades. - Displaying student grades in letter grades (A, B, C, etc.). - Implementing a system that calculates weighted averages for final grades. - The ability to input student scores. Ideal Skills and Experience: - Proficient in Excel with experience in creating complex formulas. - Understanding of weighted average calculations. - Knowledge of grading systems and how to convert scores into letter grades.

I have a website which requires a better pagespeed score. Right now its on 30 score for mobile and 60 for desktop. I want this to be 100 for both. Need someone that can do this with me either by modifying the website page or with plugins. I have some plugins installed but could not increase the score. Link will be shared in a seperate chat

I'm in need of a unique, modernistic logo for my technology-based business. Key requirements include: - Main color scheme: Blue - Distinct, appealing, and eye-catching Ideal designers should: - Have a robust portfolio of modern logo designs - Possess excellent knowledge of leading design software - Understand the tech industry's aesthetics Let your creativity shine in this project!

Tasks : 1. Construct a queueing model that replicates a week of collecting and processing DNA samples. a. First develop a flow diagram of how the process works, from the reporting of a crime, to the eventual match/no match on the DNA database. b. Identify any conditional aspects of the process, for example if there are any stages of the process where resources only become available once the previous sample has been processed. c. Second, write out the relevant equations associated with each step of the process, and construct a formula for the overall time in system. d. Use relevant notation and write out equations using Equation Editor in Word. e. Note – the rule of thumb is that any reader can pick up your report and replicate your results by following the methods. 2. Use me...

I'm in search of a skilled sports writer specializing in cricket. I need 3 articles per week, each running between 1250 and 1500 words. The articles must be: - AI Free (AI detection score must be 5% or below) - Plagiarism 0% - Professional tone and qu...long as you want meeting our requirements. The ideal candidate for this role has: - A passion for cricket - Proven experience in sports writing, particularly cricket (Must show samples in this niche). - Strong research and analytical skills - The ability to produce high-quality, engaging content on a regular basis If you're proficient in cricket knowledge and can deliver engaging, informative cricket articles consistently, I'd love to hear from you. Start your bid with "10 NZD/Article". Bids without...

I need AutoCAD drawings for my range of products. Unfortunately, I failed to specify which products, so I welcome freelancers with diverse expertise interested in creating these drawings. Successful applicants must include - Past Works: Kindly showcase your previous work. I value past experiences related to product AutoCAD drawings. For the drawings, I demand precision and attention to detail with regards to: - Material Specifications: Don't miss any material specifics; it should be well-highlighted in the drawings. - Dimensional Details: Full dimensional details of all products must be present and clearly marked. If you fit the bill, feel free to send in your application! I look forward to collaborating with you.

I require a Visual Studio expert w...CSS, JavaScript, and reactJS to build an engaging site. Key Aspects of the Project: - Development of a Responsive design - Crafting an Interactive User Interface - Ensuring Dynamic Content Updates In applying, please include in your proposal: - A portfolio showcasing your Past Work, as this would give a clear understanding of your style and quality of work. Expectations for Code Quality: - I value proper framework and clarity. Hence, I anticipate code that demonstrates strict Adherence to Coding Standards. Extensive experience with reactJS and an immaculate understanding of responsive design concepts would be beneficial for this project. Efficiency, attention to details and a creative problem-solving approach are prerequisites for the ideal ...

I'm looking for a detail-oriented Excel expert to amend certain elements on my existing spreadsheet. Key tasks include: Data Entry Corrections: - Correcting inaccuracies in data entries. - Rectifying data location errors. Data Reorientation: - Shifting the format from a vertical to a horizontal layout specifically for data values. It would be ideal if you possess a keen eye for detail, advanced Excel skills including formulas, and a proven track record of spreadsheet data management. Experience in handling large copy-paste tasks will also be of great advantage. Due to the nature of this task, a meticulous and systematic approach will be required.

...Slides**: The presentation should consist of 10 to 20 slides. It's crucial that each slide is clear, concise, and visually appealing. - **Color Scheme**: I have specific colors in mind. You'll need to incorporate these colors in a way that aligns with my brand's identity. I'm looking for a freelancer with: - **Experience**: Extensive experience in creating business PowerPoint decks. Samples of similar work would be highly beneficial. - **Design Skills**: A good eye for design and layout, someone who can make complex information easy to understand. - **Branding Knowledge**: Understanding of how to incorporate brand elements into the design without compromising on clarity and aesthetics. - **Communication**: Be able to understand my business goals...

I'm looking for a freelancer who can assist me with creating listings for my kitchenware items on eBay. I do not require help with managing the listings, only creating them. Key requirements: - Experience with eBay listing creation. - Proficiency in writing compelling product descriptions and titles. - Understanding of the kitchenware market on eBay. The project involves creating listings for 10-20 items, including cooking pots, tea pots and pans. The ideal candidate for this project will have a keen eye for detail and will be able to effectively communicate the value of these products to potential buyers.

As part of my project, I need an expert in Excel to type data from various digital files into a spreadsheet, ensuring accuracy and efficiency. This data will be utilized for basic data analysis purposes, so it's important that the freelancer is comfortable with working on this type of data. Key Requirements: - Converting data from various digital files (PDF, Word, etc.) into an Excel sheet. - Proficient in using basic Excel formulas and functions to manipulate data for analysis. - Attention to detail and accuracy are critical for this task. Ideal Skills and Experience: - Proficiency in Excel - should be able to work with basic formulas and functions. - Prior experience in data entry or data analysis is a plus. - Strong attention to detail to ensure...

I'm after a talented freelancer with advanced skills in clothing design, specifically using CLO 3D Design software. Our project focuses on creating casual style tops. Key Project Details: - Primary Focus: Design tops - Design Style: Casual Experience Required: - Proficiency in CLO 3D Design Software - A solid background in creating casual style clothing Please note: No specific color preferences were indicated, so you'll have the creative liberty to experiment. Your portfolio in clothing design will have a significant impact on the selection process. Excited to see the creativity and innovation you can bring to our project.

...skilled developer to create a mod for a future Minecraft SMP (Survival Multiplayer) server. The mod involves a small but crucial change to the game's hardcore aspect, allowing for easy toggling between hardcore mode and regular mode. PROJECT DETAILS = = = = - Objective: Modify Minecraft gameplay to toggle hardcore mode on and off seamlessly. - Functionality: When the hardcore mode is activated, players and those they kill are permanently put into spectator mode, except for using commands. - The toggle switch is in the form of 'canon off' and 'canon on' buttons, with 'on' activating the hardcore aspect. - All players should be able to toggle between modes without accessing creative mode. - Hardcore mode oper...

I'm looking for a qualified graphic designer to create a bold, vibrant logo for my agency. The ideal candidate should have vast experience in vibrant color schemes and dynamic design. Key Responsibilities/Requirements: - The logo design should incorporate red, black, and blue colors. - Should provide examples of similar work in portfolio. - Proven experience in designing logos in a bold and vibrant style is a must. - Prior experience in designing for agencies would be preferable. A successful execution of the project can lead to further possible collaboration.

I'm in need of a skilled developer to craft an AI-based firewall in a SaaS format. Features must include: - Real-time threat detection - Automated incident response - A user-friendly dashboard. The finished product will need to be hosted on a direct server. For security, it must meet these criteria: - Basic security measures - Advanced threat detection and prevention - Customizable security rules - DDOS attack prevention. Applicants with a strong background in AI, SaaS development, and cloud computing are desired, particularly those with experience in high-security IT projects.

YOUR BID IS FINAL. NO LATER CHANGE ALLOWED DO NOT BID WITHOUT SEEING THE ATTACHMENTS SEND YOUR SAMPLE VIDEO FIRST TO BE SELECTED I need someone to create videos on English Grammar on the topics given here in the attachment. It can be discussed in Chat. You should have a good, professional grade Mic. An electronic Pen is desirable. Topics for which you need to create the videos are Narration , voice change, parts of speech, sequence of tense, gerund, creating wh questions etc. Each topic should be minimum of 60 minutes length. You first need to explain the main concept, use examples and use some questions and then its answers with explanation.. also create 10 MCQ questions on each topic. Instructions to be in ENGLISH only. Use Screen recording Softw...

I'm seeking a talented concept artist to create three mock-ups of the primary user interface for a unique game project. The mock-ups will help establish the overall visual style and aesthetic of the game. Requirements: Create three distinct UI mock-ups based on the provided brief Proficiency in digital art tools (e.g., Photoshop, Illustrator, or similar software) Strong understanding of color theory, composition, and visual storytelling Ability to work independently and deliver high-quality work within the agreed-upon timeframe Deliverables: Three high-resolution UI mock-ups in PNG or PSD format Source files for each mock-up (e.g., layered PSD files) Timeframe: The project should be completed within 1 week of the start date. To apply, please submit the followi...

EN Project with the intention of reducing the time for creating cutting files and eliminating errors in saving. Aplication Area: Engineering and manufacturing Automation of saving cutting files and manipulation of drawings, 1 - Save cutting files, considering the file type and correct naming. There is a file with several layers categorized in a standard way, these layers should be separated and saved in different files with specific names according to the layer. 2 - Save steel cutting files and possibly make changes/cuts (e.g., Slide). PT Projeto com intenção reduzir tempo de criação de arquivos de corte e eliminar erros no salvamento. Area: Engenharia e manufatura Automatização de salvamento de arquivos de corte e manipulaçã...

I'm looking for a skilled developer to create a custom procurement spend analysis dashboard. This tool will help our procurement managers to efficiently track and manage our expenses. Key Data Sources: - Your primary task will be integrating data from Excel spreadsheets and purchasing data from our suppliers. This will provide a comprehensive view of our spending patterns. Key Metrics: - The dashboard should enable real-time tracking of our total spend by category. This will allow our procurement managers to identify areas where costs are higher than expected, enabling them to take immediate action. Primary Users: - The dashboard will be primarily used by our procurement managers. It should be user-friendly and intuitive, allowing for quick and easy analysis of the data. Id...

As part of my project, I need an expert in Excel to type data from various digital files into a spreadsheet, ensuring accuracy and efficiency. This data will be utilized for basic data analysis purposes, so it's important that the freelancer is comfortable with working on this type of data. Key Requirements: - Converting data from various digital files (PDF, Word, etc.) into an Excel sheet. - Proficient in using basic Excel formulas and functions to manipulate data for analysis. - Attention to detail and accuracy are critical for this task. Ideal Skills and Experience: - Proficiency in Excel - should be able to work with basic formulas and functions. - Prior experience in data entry or data analysis is a plus. - Strong attention to detail to ensure...

I'm in ne...placement across various mediums - Establish a cohesive visual style that resonates with Millennials, Parents and Business professionals - Preference for a designer with experience in audience-tailored brand development - Open to suggestions for color schemes, but please provide a rationale for the choices made - Develop brand guidelines: visuals (colors, typography, imagery, icons) for consistency. - Research market trends, competitor branding, user preferences for informed decisions. - Create templates, design assets following guidelines for consistent, on-brand communication. Ideal Skills: - Branding and Identity Design - Audience Segmentation and Targeting - Visual Styling and Design - Strong Communication Skills - Experience with detailed style guides a...

I am in need of a 3D product configuration tool that will allow users to customize our products and view them from different angles; making a tool very similar to the one at Key Features: - Customizable Product Options: The tool should allow users to choose different product options, such as color or size, to get an accurate representation of the final product. - 360-Degree View: The tool should enable users to view the product from all angles, providing a comprehensive understanding of the customization. You will be working with existing 3D models of our products. The primary aim of this tool is to allow visitors configure their required product then it will come to us for quotation. For this reason, it's crucial that the tool is user-friendly, engaging, and

...specific diamond shapes. Your task involves emphasizing the shape and brilliance of the diamond to achieve a shiny and clear effect. The video is currently in MOV format, which is your starting point. I attach example video of a normal diamond 360. Your task is to: 1. To receive a sketch of the Diamond from me. 2. Make a 3D render of the diamond 3. Create video just like the examples with shiny effects 4. Offer both Black & white background 5. Must look like real life video of a diamond and not clearly a fake render To make this project a success, possessing high-level skills in video editing software, such as Adobe Premiere Pro or After Effects, will be beneficial. Previous experience in gemology or working on similar projects focusing on high resolution 3...

I'm seeking a freelancer to assist me with entry-level data entry tasks in the comforts of my home. Key Responsibilities: - Handling simple data entry tasks. - Ensuring accuracy and attention to detail. Ideal Skills: - Basic understanding of data entry procedures and systems. - Familiarity with spreadsheets and online forms. - Excellent typing skills. Experience: - While I require a beginner level of experience, any past exposure to data entry tasks will be considered beneficial. Submission: - Your tasks will be submitted via email, so a good grasp of communication through this medium is important. This opportunity would be perfect for someone who's looking for an entry-level data entry role that can be completed from home.

Productcatalog for technical parts and for automobile car/truck parts (lighting) Do you have experience in technical parts product catalogs? Than let us know and send us via message a reference catalog from you and the price for the layout, optional add the price for automatic eding via a productlist from excel with photos to create the catalog. Send us a message with a reference catalog, maybe german language catalog or for europe with technical parts products.

Here's what I need in a potential candidate for the job: - Experience in data entry involving Text, Numbers, and Images. Adeptness in managing a wide array of data types is crucial for this project. - Proficiency in Excel. This project requires all data to be entered into a specific Excel template that I will provide. - Detail-oriented skills and accuracy are essential. The data entered should be free of errors and align with the format that I will provide. Please ensure your bid reflects your experience and capabilities in these areas. Looking forward to a fruitful collaboration!

I'm in need of an experienced 3D designer who is proficient in using 3ds Max. The project involves creating a modern styled 4BHK flat with a neutral toned color scheme. Key Requirements: - Expertise in 3ds Max is needed. - Experience in interior design, specifically in modern style. - Grasp of color theory, with an emphasis on neutral tones. The outcome has to echo sophistication, capturing the interplay of light and shape, and portraying a sense of effortless comfort. Stunning, realistic renderings are a must. The final design should be finely balanced in texture and form, creating an integrated neutral scheme. Your portfolio showcasing relevant works will be a great plus.

I'm seeking a highly skilled flutter developer possessing in-depth experience with Laravel to contribute their expertise to my social media application. Here are the key features expected: - Main UI is completed with flutter. - Lara...their expertise to my social media application. Here are the key features expected: - Main UI is completed with flutter. - Laravel backend is almost 70%. - to be implemented: integrate the API into the current UI. social login(FB, twitter, tiktok, apple) inapp and banner ad audio combine with BGM. support the deploy on google play and app store HOW to apply. - please send me the FLUTTER APP URL on google play and app store and code screenshot of that App. (the proposal without the screenshot will be declined) - send me the larav...

I'm in need of a unique and modern logo for my brand, Cosy Co. Stays. Key e... Cosy Co. Stays. Key elements: - The style of the logo should be modern and minimalist, fitting the brand theme. - Design should have a home or abstract house incorporated, symbolizing the essence of an Airbnb business. - The color scheme should feature gold and silver, adding a touch of luxury to the overall design. Ideal skills and experience: - Proven experience in logo design, particularly with modern and minimalist aesthetics. - Experience with incorporating specific elements into logos, such as houses or nature elements. - A strong understanding of color theory, particularly in working with gold and silver. Please include a link to your portfolio or previous logo design samples i...

I have an Excel sheet full of text data that I need typed up. The data is currently in a PDF file, so you'll have to extract it from there. Once the data is in the Excel sheet, it needs to be organized into tables. Key Requirements: - Data entry of text from a PDF into Excel - Organizing text data into tables in Excel Ideal Skills: - Proficiency in Excel - Fast and accurate typing - Attention to detail - Experience with data formatting in Excel Looking for someone who can complete this task in a timely and error-free manner.

I'd like some assistance in completing the customization and setup of my ongoing WordPress project. Looking for a freelancer with the following skills: - WordPress Design customization: Someone who can effectively change the color scheme of my website and add custom graphics to enhance visual appeal. - WordPress Plugin Installation: Must be proficient in SEO optimization plugin installation and setup to enhance the visibility of the site. Experience with WordPress and a keen eye for design are crucial for this project's success.

I'm seeking a professional with extensive experience in data entry for my project. While the specific data type to be entered has not been specified, it doesn't nullify the need for impeccable ...While the specific data type to be entered has not been specified, it doesn't nullify the need for impeccable accuracy and attention to detail in this project. Requirements: - Demonstrable track record in Excel data entry, backed by past work. - Dedication to maintaining high data entry accuracy, regardless of the data type. - Capability to deliver the completed work in .xlsx format. Experience in Excel functions and formulas and commitment to meeting the set deadline will give you an edge in this project. Your application should include relevant past work you'...