Ebay turbo lister csv format punët

I'm seeking a data visualization expert to create a concise dashboard summarizing skill gap data for operators across various areas. The dashboard should include ...areas for all 4 shifts TABS - Design the 1 dashboard to cover all 4 shifts to provide a moderate level of detail. - Ensure the dashboard is easy to interpret. - The raw data is in each TAB by shift by area Ideal Skills: - Proficiency in data visualization tools (like Tableau, Power BI, etc.) - Strong understanding of dashboard creation. - Ability to convey complex data in an easily digestible format. Please note that the identification of operational areas to be included in the dashboard will be determined by you, as the client did not specify this. I need this completed by end of today 8pm UK time. Any questi...

...Mines, Tragamonedas y DoubleX. Aviator: Enviar señales de entrada basadas en probabilidades de alcanzar multiplicadores específicos, como x2, x5, x10. Mines: Mostrar sugerencias visuales y gráficas de casillas seguras donde no hay minas (mínimo 3 casillas). Tragamonedas: Identificar los juegos con mayores probabilidades de activar bonificaciones y sugerir estrategias (apuestas mínimas o giros turbo). DoubleX: Estrategias de apuesta personalizadas para maximizar las ganancias. 2. Gestión de Banca: Sistema automático y personalizable con alertas de pérdidas y ganancias. Compatible con pesos chilenos (CLP). 3. Envío de Señales a Telegram: Enviar alertas personalizadas a diferentes grupos con configura...

I need assistance filling out a CG1 form using previously sent financial information. The information is contained in a PDF document that contains a mix of selectable text and scanned images. Ideal Skills and Experience: -Irish Accountancy Experience only - Proficiency in filling out forms accurately - Ability to interpret and extract information from a mixed format PDF - Attention to detail to ensure all financial details are correctly filled in - Experience with financial documents is a plus

...race driver. The logo should incorporate his initials "OEM" and the text "Oran England Motorsport", presented either underneath or to one side. The design should be simple, yet catchy, and crucially, it must be original - no copies. Color Scheme: - Blue should be a primary color, with potential accents of red and yellow. Final Deliverables: - The logo needs to be delivered in an editable vector format. This is important as we plan to use the logo across various platforms, from social media to car decals. Design Inspirations: - I can provide examples of logos my client admires, which can serve as a reference for the design. Incorporated Elements: - The logo can subtly integrate a few specific motifs: a race flag, a car silhouette, and a driver helmet icon...

I'm looking for a professional Canva expert to create a captivating presentation tailored for potential clients. Th...product images and company statistics. - It should be visually appealing and align with our brand's aesthetics. - The content should be persuasive to engage potential clients. Ideal Skills: - Proficiency in Canva. - Experience in creating marketing presentations. - Strong graphic design skills. - Ability to understand and convey company statistics in an engaging way. I want a canva format with smoothly design tools which I can adjust myself in the future. See the powerpoint pdf for the old presentation. We want 1 presentation to introduce our 3 companies:

I'm looking for a designer to create a modern, stylish 3D logo for my plugin. The logo should be delivered in a transparent format suitable for website integration too. - The logo should embody a 'plugin' theme in a stylish 3D design. - A transparent white version only 2 letters MS in 2D of the logo for use in my sidebar is also required. - The designer should have experience in creating minimalist and abstract designs. - A good understanding of technology-themed concepts is essential. - A portfolio showcasing previous logo designs, particularly in 3D, will be highly regarded.

...freelancer who can configure my eBay seller account. This will involve creating templates for two distinct businesses and listing approximately 25 products on each account. All tasks will need to be completed on a fixed price basis. Please note, for security reasons, I will not be providing my eBay login credentials. You will need to work via TeamViewer or any other remote software of your choice. Key Responsibilities: - Configuration of eBay seller account - Creation of modern and sleek templates for two businesses - Listing of approximately 25 products on each account - All listings to be fixed price listings Ideal Skills and Experience: - Prior experience with eBay seller account configuration is a must - Expertise in creating professional and attractive...

I need my award show video template customized. - What You'll Do: You will customize the video template with new videos and text. This needs to be done to create a final product that is 99% the same as last year’s video, which can be seen here: - Deliverables: The final video needs to be delivered in 1920 x 1080px and in MP4 format. - Resources: I will provide you with the original video template file, which can be found here: , and the 6 new videos that need to be added, along with the new text. - What I Expect: I expect you to create the same video as in the YouTube example, but with new videos and text. No additional visual effects or transitions are needed; just use the existing

...appeals to our target group - design-conscious, creative and trend-savvy customers. Logo design: - Modern, appealing and unique. - A minimalist but expressive design that looks good both digitally and in print. - Integration of the store name “All in Creative Print” into the logo. - Use of fonts that are free and not subject to a paid license File formats: We need the finished file in vector format and of course the source file (.ai)....

...verification check directly from the dashboard. Upon initiating: - An email invite should be sent to the user via SendGrid API. - The new check details should be stored in Firebase under a checks collection. - Fields for the check will come directly from firebase when the user downloads the app and registers. 3. Display Check Data Fetch and display data from the Firebase checks collection in a table format. Columns: Type (Buyer/Breeder) Name Email Phone Number Date Time Status (Low Risk, Medium Risk, High Risk, Incomplete) Include pagination for large datasets. 4. Manage Checks Approve/Reject functionality: - Admins can update the status of a check using "Approve" or "Reject" buttons - Status updates should be reflected in the UI and trigger an email via se...

...majoritaire ou l’entreprise. - 2 paragraphes personnalisés (3 lignes maximum chacun) sur l’entreprise. Une structure de texte sera fournie pour guider la rédaction. Livrables attendus - Un excel complet classant chaque entreprise dans l’une des trois catégories, avec les informations spécifiques pour les entreprises de la catégorie 3. Les textes rédigés devront être en français et respecter le format demandé. Profil recherché : Compétences en recherche en ligne (utilisation de bases de données et plateformes comme ). Bonnes capacités d’analyse et de synthèse. Compétences rédactionnelles en français. Fiabilité et respect des ...

...you plenty of room for your ideas. The goal is to produce a professional and innovative video that showcases our product in the best possible way and sparks curiosity. Target Audience: Athletes: People looking to enhance their performance. Seniors: Individuals seeking to improve their well-being. General Audience: Anyone looking for an energy boost. Submission: Final video in 1080 x 1920 format (vertical orientation). Deadline: [Insert a realistic date here]. How to Apply: Please send us: A brief description of your previous work and experience in social media advertising. References or examples of videos you have created (preferably in the advertising field). Your pricing details. We look forward to hearing from you and creating something extraordinary together! Th...

...following - - 500 Keywords Per Category Total - 3000 Keywords We want low competition, high to mid traffic keywords. Cluster where needed, we don't want keyword repetition at all. We want to avoid keyword cannibalization at any cost. You can use Ubersuggest, Ahrefs or Semrush Keyword Magic. We will require a detailed colour spreadhseet containing the search terms and data in easy to understand format, each column should list the keyword, searches per month, cost per click. Please bid reasonably and in your bid tell us the list of tools you will utilize. We also need the time required. If you have read this and are willing to do the trial research, please mention "keywordsend" in your bid. In your bid, please provide the exact budget for 10 niches - 3000 keyw...

I'm seeking a skilled machine learning and computer vision expert to improve the efficiency of my current model which detects corrosion in images. Data & Annotation: - The model is trained on images, some of which are annotated with corrosion labels. - The annotated images are in YOLO TXT format. Ideal Skills: - Proficiency in machine learning and computer vision. - Experience with corrosion detection models is a plus. - Familiarity with YOLO TXT format. In your proposal, please indicate your relevant experience and how you plan to approach this project.

I require assistance in enhancing my existing Woocommerce site, which currently has a partially imported database of car models and bran...essential that the two pages are independent of each other. Specifically, page 1 should display car models, while page 2 displays phone models. Additionally, in the filters, brands should be presented separately on each page, rather than being mixed. 3. Importing a comprehensive database of phones. This should encompass all phone models released after 2018. The data for both cars and phones is in CSV format. The auto database has already been partially imported. The ideal freelancer for this project should have extensive experience with Woocommerce and database management. I am looking for someone who can complete this project efficientl...

I have a paper single-line diagram that I need converted into AutoCAD. The purpose of this project is solely to transfer the information from the paper to an editable digital format. Ideal skills for this job: - Proficiency in AutoCAD - Attention to detail - Ability to work from physical documents

Job Description: We are looking for a talented and experienced web developer to build an image search website. The website will allow users to upload images and get search results from various image search APIs, displaying the images and related data returned in a clean and organized format. The developer will work with us to integrate and complete the website, ensuring it is secure, user-friendly, and fully functional. Some parts of the website, such as the results page code, are already available, and we have a Figma wireframe to guide the design. We need a developer to handle the backend integration, implement additional features like CAPTCHA protection, and ensure the platform is robust. Key Features and Requirements: 1. User Authentication System: Secure Login Me...

Project Title: Website UI Design for KSP Performance Description: We are an af...past website UI designs you’ve worked on, particularly projects related to e-commerce or the automotive industry. Providing 2-3 samples or links to your previous work will greatly help us evaluate your style and capabilities. Deliverables: Complete UI design for the homepage, product pages, and other core pages. Responsive designs for desktop, tablet, and mobile. Final design files in a usable format for our development team. Preferred Skills: Understanding of automotive industry trends and aesthetics. Experience collaborating with developers to ensure design feasibility. We look forward to reviewing your proposals and collaborating with a creative and skilled designer to take our website to t...

Format and edit a book professionally

I need a professional to help me refine and format an informative eBook on how to survive the first year of having a baby. Key Components: - The tone of the eBook should be informative. - The eBook should address the emotional well-being of parents during this challenging period. - I have all the content ready Ideal Skills: - Experience in eBook formatting - Understanding of parenting topics, particularly emotional well-being - Ability to maintain an informative tone throughout

...the Data from Variable Set from an XML (Picked up locally from machine) (and there would be checkboxes) - It would show all the AI models. TRAIN - Pause - Kill (This would stop Training) (We would initiate and it would train in the background.) (j). Output - You would have store the data in DB / or API we give you push the data there. (k). Input - You would get it from DB or from API. (l). Format - You all the data is present in Mxxx (Variables) - The MXXX values represent Result1 to Result3 - SQ sequence of Data is number of data present. (if we give you 178,650 rows of data), we would you to predict data from 178651 to 178700) (m). Output Parms We would give an input of data1 and data2, so you would have to generate data from data1 to data2 (100 rows, 200 Rows so on) K...

I'm looking for a professional 3D designer who can help me visualize my restaurant model. The focus is primarily on the dining area. Key Requirements: - A detailed, high-quality 3D diagram of the dining area, inco...designer who can help me visualize my restaurant model. The focus is primarily on the dining area. Key Requirements: - A detailed, high-quality 3D diagram of the dining area, incorporating my vision of a specific style or theme. - A comprehensive high-detail layout of the kitchen and workflow area, including fixtures, furniture, and decor. - Ability to interpret and translate my ideas into a visual format. Ideal Skills: - Proficiency in 3D design software. - Experience in designing restaurant layouts. - Strong communication skills for understanding and implemen...

I'm looking for a professional graphic designer to create 50 realistic visuals for an online beverage menu. The project involves editing base images to accurately represent specified beverages, tapioca pearls, fruits, and our brand logo according to detailed menu descriptions and reference photos. Key Responsibilities: - Ensure the drink's color matches the menu description. - Adjust the ...images should match the reference photo's background. Ideal Skills and Experience: - Proficient in graphic design with a focus on creating realistic images. - Experience in beverage photography or design is a plus. - Strong attention to detail to ensure all modifications are accurate. - Ability to integrate brand elements into designs seamlessly. Final Deliverables: - 50 edited images ...

I have an existing scraper built in python for the website (CWH). It scrapes the following information: - product description, price, images - SEO metadata - Additional metadata Currently, all the scraped data is stored in a CSV file. I am looking for a developer who has expertise in python / scraping and postgres to do the following: [Phase / Milestone 1] 1. Convert the existing scraper (code attached - /site-packages removed for space) to load the data in a postgres database. 2. Scrape reviews of products from the (CWH) website and store them in the database. 3. Look up the availability of the product in specific stores and write the boolean value in the postgres database. (code attached - ) [Phase

I need someone to convert my 28 page bank statement from PDF to Excel. - You will need to extract all details from the bank statement. - The data should be formatted into a standard table format on Excel. - No further data processing is required after extraction. Ideal candidates will have: - Experience in data entry and PDF to Excel conversion - Attention to detail to ensure all information is accurately captured. check sample

...establish a cohesive, elegant, and exclusive brand identity that reflects the luxury focus of my business. Deliverables The style guide should include the following elements: 1. Logo Design: A sleek, sophisticated logo that reflects a high-luxury travel brand. Variations: Full logo, logo mark (icon-only), and logo in black, cream, gold, and white (for dark backgrounds). Provide files in vector format (AI, EPS) and web-friendly formats (PNG, JPEG). 2. Color Palette: Primary colors: Black, cream, and gold. Include hex codes, RGB, CMYK values, and Pantone references for consistency. Provide a guide on how to use these colors (e.g., primary, accent, background). 3. Typography: Selection of luxury-oriented fonts for: Titles/Headings: Bold and elegant. Subheadings: Sophis...

We are seeking a skilled data professional to compile a comprehensive database of recently registered domain names along with relevant ownership or business details for the purpose of targeted outreach and lead generation for website development services. Database Scope: Collect domain registration data with a ...legitimate sources such as WHOIS databases, expired domain lists, and domain auction sites. No data collection that violates GDPR, CCPA, or similar data protection laws. Preference for data from businesses requiring web development services. Data Accuracy: Ensure data is as up-to-date and accurate as possible. Remove incomplete or redacted records from the final dataset. File Format: Deliver data in CSV or Excel format. Proper column segregation and labe...

I'm looking for a professional freelancer to create an animated GIF image for me. This will serve as a pre-loader for my website. The dime...transition effects don't have to be identical to the original GIF, but it should run a nice animation of my logo. Here is the original GIF for reference: [Original GIF]() And here is my logo: [My Logo]() I can export my logo in any format and dimension. The ideal freelancer for this project should have a strong background in animation and GIF creation. Please, include your portfolio in your bid, particularly examples of elegant and sophisticated animations you've created in the past.

...following - - 500 Keywords Per Category Total - 3000 Keywords We want low competition, high to mid traffic keywords. Cluster where needed, we don't want keyword repetition at all. We want to avoid keyword cannibalization at any cost. You can use Ubersuggest, Ahrefs or Semrush Keyword Magic. We will require a detailed colour spreadhseet containing the search terms and data in easy to understand format, each column should list the keyword, searches per month, cost per click. Please bid reasonably and in your bid tell us the list of tools you will utilize. We also need the time required. If you have read this and are willing to do the trial research, please mention "keywordsend" in your bid. In your bid, please provide the exact budget for 10 niches - 3000 keyw...

I need someone to convert my 28 page bank statement from PDF to Excel. - You will need to extract all details from the bank statement. - The data should be formatted into a standard table format on Excel. - No further data processing is required after extraction. Ideal candidates will have: - Experience in data entry and PDF to Excel conversion - Attention to detail to ensure all information is accurately captured. check sample

I'm seeking a detail-oriented data entry operator to assist with transcribing printed text from scanned PDFs into a digital format. Ideal Skills and Experience: - Proficiency in data entry and transcription - Excellent attention to detail - Familiarity with handling scanned documents - Ability to maintain confidentiality and handle sensitive information with discretion

I'm in urgent need of a skilled video editor who can craft two ~30 second videos for me: 1. A compilation of customer testimonials 2. An ad edit featuring supers, icons and vectors Both videos should adhere to a 'professional and clean' aesthetic and be delivered in MP4 format. The ideal candidate for this project should: - Have prior experience in video editing, particularly with creating testimonial compilations and advertisements - Be able to deliver high-quality work promptly, as I am looking to get this done as soon as possible - Have an understanding of, and can deliver to, the specified 'professional and clean' style Please apply if you are available immediately. I look forward to your responses.

I need a professional graphic designer to modify my existing logo. Key Requirements: - Change the name on the logo. - Move or reposition some text elements on the logo. - Use specific fonts provided by me for the text changes. My current logo is already in a vector format, so no need for raster conversion. Please let me know if you have any questions or need further information. Your expertise and attention to detail will be crucial for this project.

Working on automating a ...need the call center module to handle the following: Import large .csv files containing 1,000-5,000 phone numbers. Automatically call customers listed in the .csv file. Offer services and respond to their questions dynamically using OpenAI API. We are seeking a freelancer who can complete this project efficiently, ensuring the system is capable of: Handling high-volume call operations without errors. Maintaining seamless integration between Issabel, Asterisk, and OpenAI APIs. Providing clear documentation and support after completion. Skills Required: Experience with Issabel, Asterisk, and telephony systems. Proficiency in Python and working with OpenAI APIs. Knowledge of STT/TTS integration. Ability to work with large .csv datasets and ...

I need assistance with digitizing some information from printed documents. Key Requirements: - You will be transcribing text from printed documents into a digital format. - The transcribed text will need to be formatted as simple text. - Attention to detail is essential to ensure accuracy in data entry. Ideal Skills and Experience: - Prior experience in data entry, particularly from printed documents. - Excellent typing skills with high accuracy. - Ability to follow instructions and maintain confidentiality.

...Style: Sleek, modern, and luxurious. Incorporate the essence of florals in a refined way—nothing too ornate or overly detailed. • Flexibility: The logo should translate well across digital platforms (website, social media, email) and physical materials (business cards, packaging, signage). 4. Submission Requirements • Formats: Provide entries in high-resolution JPEG or PNG, as well as a vector format (AI, EPS, or SVG). • Color Variations: Submit at least one version on a black background and one on a white background. We look forward to seeing your creativity and how you bring the spirit of Petal & Sky to life through logo design. Good luck! Company Name : petal & sky Key requirements: - A modern design style - Skillful use of pastel colors - ...

...The project involves training a GPT model using existing scripts, competitor content, and audience insights to create high-quality, engaging scripts for YouTube and TikTok. The model will be used to generate short-form scripts, visual suggestions, and SEO-optimized content for job seekers at all levels. Project Scope: 1. Data Preparation: • Organize and format existing scripts, competitor analysis, and audience insights into JSONL format. • Ensure the dataset reflects the brand’s tone: professional, fun, and disruptive. 2. Model Fine-Tuning: • Fine-tune OpenAI GPT (preferably curie or davinci) to match the specific tone and content needs of the Mr. Jobs brand. • Include hooks, short-form video scripts, and engaging content ideas for job se...

I'm looking for a professional who can create math assessments in both Word Document and Publisher for Grades 5, 7, 8, and 9. I will provide the topics and types of questions, as well as the textbook students are using to ensure the assessments are at the appropriate level. Key Responsibilities: - Create 1 assessment for each grade - Follow provided guidelines in terms of format, fonts, sizes, etc. - Produce 3-5 sample questions for review and approval before proceeding Ideal Candidate: - Proficient in both Word and Publisher - Prior experience in creating educational assessments - Strong understanding of math topics appropriate for Grades 5-9 - Excellent attention to detail and ability to follow specific instructions Please note, the types of questions will include a mix o...

I'm in need of an adept freelance developer to enhance an existing HTML and JavaScript project that automates form data capture, generates a PDF, and populates data into Outlook. The current email format in Outlook is plain text, and I want to elevate it to a modern, stylish, and professional format embedded in the email. Key Responsibilities: - Enhance the email format in Outlook to include tables, structured data, and additional formatting. - Upgrade the email layout to a modern and stylish design, while maintaining a corporate and formal tone. - Ensure seamless integration with the current automation process. - Implement all changes on a Linux RHEL 8 server. Ideal Candidate: - Proficient in HTML and JavaScript. - Experienced in automating PDF generation. - Kn...

...their respective themes. Domains for the Logos: Personal Finance and Credit Management Active Trading and Investments Long-Term Investments and Wealth Creation The designs must align with industry standards and be versatile enough for use across websites, social media, and other marketing materials. Requirements: Unique and professional logos for each domain. High-resolution designs in vector format (AI, EPS) and other standard formats (PNG, JPEG). Variations suitable for both dark and light backgrounds. Scalable and adaptable for multiple platforms (web, print, social media). Full source files with ownership rights upon completion. Timeline: The project should be completed within 7–10 days from the start date. Deliverables: 3 finalized logo designs in vector and raster ...

...can trace the font from an image and convert it into a vector image. The text I'm referring to is "Hackah Jak". in the attached image. Key requirements: - Identify and trace the font from the image accurately - Convert the traced font into a vector image The project has a strict deadline of 12 hours. I would highly appreciate if the freelancer could deliver the vector image in a commonly used format such as SVG, EPS or AI. Ideal skills and experience: - Proficient in using graphic design software (especially vector-based programs) - Prior experience in font tracing and vector creation - Able to meet tight deadlines without compromising on quality. THERE ARE TWO IMAGES, EACH IN DIFFERENT FONTS. I WILL PAY $20 FOR EACH. --- OR Identify the font to a perfect ma...

...adherence to USMLE standards. The final deliverables must be categorized into a CSV template that I will provide. Project Scope Question Creation: Step 1 Questions: Focus on foundational sciences like biochemistry, physiology, and pathology. Step 2 CK Questions: Emphasize clinical knowledge, including diagnosis and management across fields such as internal medicine, surgery, and OB/GYN. Content Details: Each question must include: A clinical vignette or scenario. Five answer choices (one correct, four incorrect). Detailed explanations for each answer option (correct and incorrect). An educational objective summarizing the key takeaway. Categorization: Questions must be organized by subject, topic, and system into a CSV file. Provided Materials PDF on Question Creation:...

I'm seeking a skilled Revit expert to create a model for a commercial building. The project involves creating a shell for a retail space using both pictures and preliminary floor plans that I will provide in PDF format. Key Requirements: - Creation of a detailed and accurate Revit model - Proficient use of PDF files for model creation Ideal Skills: - Experience in creating Revit models for commercial buildings - Proficient in interpreting and using PDF files for design purposes

Ju lutemi Regjistrohuni ose Identifikohuni për të parë të dhënat.

I need help photographing, listing and selling vintage furniture on eBay and Chairish. - Item Preparation: I will provide you with vintage and other personal furniture items that need to be photographed and posted for sale. - Photography: Basic photography with a smartphone is required. You do not need a professional setup, just a good eye for capturing the items in their best light and angle. - Item Descriptions: You will need to write brief descriptions with key details about each item. Ideal skills and experience for this job include: - Familiarity with eBay and Chairish - Basic photography skills - Creative writing skills for item descriptions.

My company website is experiencing slow load times, and I need an expert to enhance its performance significantly. WORDPRESS Key Areas of Concern: - The primary issue is the overall page load time. - Several aspects of the site contribute to this problem, including images and media files, scripts and plugins, and the server response time. Desired Improvements: - Convert images to WebP format to reduce their size without sacrificing quality. - Implement lazy loading to ensure that images load only when they are in the viewport, thus improving initial load times. - Optimize scripts and plugins to improve their efficiency and reduce their impact on load times. Ideal Skills and Experience: - Extensive experience with website performance optimization. - Proficiency in converting image...

I need a simple JPG logo converted into a vector format. The project requirements are as follows: - No design changes: The logo should be vectorized without any alterations to the original design. - EPS format: The final deliverable should be in EPS format. - Transparent Background: The vector logo must have a transparent background. Ideal candidates for this project are those with experience in graphic design and logo vectorization specifically. Familiarity with EPS and other vector formats is essential. Please provide examples of previous logo vectorization projects in your proposal.

...D: Label: “Number of comments” In this column, please provide the number of comments the video has. Column E: Label: “Number of saves” In this column, please provide the number of saves the video has. Column F: Label: “Date” In this column, please provide the date on which you collected/downloaded/scraped these data. 2. Folder of Video Downloads Please download the TikTok video in a standard format (e.g., MP4) and label the video file with the title of the video in the description. For example, if you downloaded this TikTok video (@returnhomenor/video/7164090596796157230?lang=en), you would label the video file “Allow us to introduce ourselves!” Please create a folder that includes each of these downloads for Return Home’s...

I have the final audio file for my book, but it isn't compliant with ACX's audio submission requirements. I need a professional to adjust the file format and split the audio as necessary for ACX submission. Ideal skills and experience for the job include: - Familiarity with ACX's audio submission requirements - Proficiency in audio editing software - Experience in file format conversion and audio splitting

I am looking for a program developed to extract certain info from the body of emails arriving in a specfic mailbox, this information whould then be ana...should be ignored. The emails are all in different formats for each customer but all should contain collection location, collection date, delivery location and delivery date. Due to every email being in a different format I am looking for an intelligent solution that can analyse the email, decide if its offering us haulage collections, determine which customer its from, determine the collection site and date, determine the delivery site and date and then pass this information to a formated excel spreadsheet. Example emails attached and spreadsheet attached in the correct format, colums highlighted in blue must be popu...