Add items excel vlookup jobs
I am looking for a careful and detail-oriented freelancer to help with a straightforward Excel sheet data entry task. The project will involve: - Entering date data into an Excel sheet. Falsifying or guessing data is not acceptable. - The Excel sheet has about 10-20 columns and between 100-1000 rows. The ideal freelancer for this task should have a strong ability to focus, excellent attention to detail, and be comfortable working independently. Prior experience with data entry, especially within Excel, is a large plus but not a prerequisite. Familiarity with date formats and their entry in Excel is desirable. Please bid if you feel you align with the posted requirements and can confidently execute the needed tasks. Thanks for your attention.
We're looking for a talented Wordpress expert skilled in Avada theme for a set of simple layout modifications and fixes to our website. Specific tasks are: -Fix the mobile menu. Currently it is showing the default theme menu items. Change this so that it reflects the desktop menu links we have created, and make sure it is not shown when on the desktop site. -The testimonials section on the home page (mobile and desktop) is not displaying properly. Check and fix -Stop the rollover effect on the career sector, so that on rollover nothing changes. -Point the website contact form to the email address info@domain. set it up and test that it works throughout the site. -Disable the pop-up that appears on the home page when you scroll down. -Poin...
I'm looking for a detail-oriented researcher to help me gathe...charts can come later. Time is critical - ideally 24 hours. - Sector-wise breakdown: I am particularly interested in the finance/investment sector. Hence, your role will be to provide in-depth insights into the investment figures within this sector. Ideal candidate should have: - Strong research experience - Experience in economics or finance - Ability to analyze & interpret data - Proficient in Excel or data analysis tools - Access and experience with databases including Office for National Statistics (ONS) in the UK /EUROSTAT and STATISTA (paid) for the EU and Investment Association (UK) This project requires a detail-oriented, problem-solving researcher. The figures/charts should all be referenced with t...
I am looking for an experienced iOS app developer who can create a modern e-commerce application for my business. The app should be designed with a modern theme in mind. The main features that we need included in the app are: - Product catalog: The app should be able to display our products in an engaging and user-friendly way. - Shopping cart: Users should be able to add and remove items to their cart as they browse through the app. - Payment gateway: The app should have a secure and reliable payment gateway that supports various payment methods. The ideal freelancer for this job should have: - Extensive experience in developing iOS applications, especially e-commerce apps. - A strong understanding of user experience and modern design principles. - Proficiency in integra...
I need a data entry clerk to help with a variety of tasks. The volume of work is small, up to 100 records. Key Responsibilities: - Typing and formatting various documents - Entering data into spreadsheets - Transcribing from audio or video recordings ...tasks. The volume of work is small, up to 100 records. Key Responsibilities: - Typing and formatting various documents - Entering data into spreadsheets - Transcribing from audio or video recordings Ideal Skills and Experience: - Proficient in typing and document formatting - Experienced in data entry, particularly into Excel - Familiar with transcribing from audio or video - Attention to detail is crucial The documents you'll be working with are in PDF, Word and Excel format. Please make sure you're detail-or...
I require a meticulous professional to help transfer text data from a series of printed documents into an Excel sheet. There's no special symbols or diagrams at all, just plain text. Ideal Skills and Experience: - Thorough understanding of Microsoft Excel - Attention to detail - Proven experience of working with printed documents - Excellent typing speed with the high level of accuracy The project needs to be completed accurately with consistency and timely manner.
I'm looking for a talented graphic designer to help me create a modern and minimalist brand identity for my business. Key Requirements: - Logo Design: I need a unique and memorable logo that embodies the essence of my brand. - Branding Materials: These include business cards, letterheads, and other essential items for my business's visual identity. - Website Design: I need help in creating a simple, elegant, and user-friendly website design that complements my brand's aesthetic. Style Preferences: - Modern and Minimalist: The design should be sleek, clean, and contemporary. - Pastel Colors: The color scheme should consist of soft, pastel hues, offering a gentle and sophisticated touch to the overall design. Ideal Skills: - Proficiency in graphic design tools such ...
I'm in urgent need of a seasoned expert in Microsoft Excel, particularly in creating financial models with emphasis on cash flow management. The ideal freelancer for this project should have proven experience in constructing similar tools for businesses. Key Areas of Focus: 1. Housemaid Cash Flow Tracker: This spreadsheet will facilitate tracking cash provided to our two housemaids and matching their submitted invoices. With three team members involved, it needs to be straightforward and efficient. 2. Monthly Household Budget Expenses: This spreadsheet will serve as a comprehensive monthly budget for all household expenses, including groceries, Amazon purchases, and payments to other suppliers. I envision a format where invoices and supplier names are listed vertically, with ...
...for an expert in Excel who can assist me with designing a functional cash flow budget. The primary aim of this tool will be to help me track and effectively manage two team members expenses. Key requirements for this project are: - Excellent proficiency in Excel, particularly in designing complex budgets and financial spreadsheets. - Experience creating automated functions within Excel, specifically for totalling expenses. - Ability to create a user-friendly and aesthetically pleasing interface that enables efficient data entry and report viewing. The freelancer would need to provide consistent updates and flexibility for potential adjustments during the process. This initiative is essential for my financial planning and needs to be done professionally. If you...
I need assistance to populate my spreadsheet with data about my inventory materials. I require this task to be handled meticulously, accounting for each item's ...including supplier catalogs, our existing inventory system, and handwritten records. Your ability to efficiently organize and sift through a variety of data sources would be key to your success in this project. No specific format is mandated for the spreadsheet. Whether it's CSV or Excel, as long as the data is accurate, consistent, and easily understandable, any format is acceptable. Ideal Skills: - Meticulous attention to detail - Expertise in data entry and management - Proficient with spreadsheets (CSV, Excel) - Ability to interpret and manage data from different sources - Experience with inventory...
need a skilled freelancer who is an expert in creating financial formulas in Excel. You'll work exclusively with data I provide. Ideal candidate should have: * Expertise in Excel with a specific focus on financial formulas Ddata will be provided
As part of an upcoming corporate event, I urgently need an experienced graphic designer to assist in designing some key items, adhering to a modern aesthetic. Responsibilities: - Create a banner, size 5x2 feet - Design standard sized invitation cards, 5x7 inch Requirements: - A keen eye for modern design styles - Email drafts of designs for review before finalizing - Capable of completing the task within a strict deadline of 24 hours Ideal candidates will have extensive experience in graphic design, specifically with creating banner and invitation card materials. Expertise in modern aesthetics is a must.
I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.
As a client, I'm sourcing for a diligent and detail-oriented freelancer to assist me with a data entry project. The main requirement is to enter mixed numeric and text data accurately into an Excel sheet. The data will be provided in a mix of both structured and unstructured formats. In this regard, the ideal freelancer would be one capable of efficiently handling data in various formats such as CSV, tables, PDFs, and Word documents. Proficiency in Excel, data manipulation and an ability to sort through and understand different data structures are crucial for this job. Experience in similar data entry projects could be a significant advantage. This task will require meticulous attention to detail to ensure correct and precise input of data.
As the upcoming proprietor of a modern, all-inclusive online cl...in Shopify 2.0 - Familiarity with modern web design principles. - The ability to implement and test personalization for products. My store will cater to a wide demographic, including women, men, and children. The successful freelancer will be tasked with developing an appealing and accessible online store that maintains a modern aesthetic while efficiently promoting a large variety of clothing items. The most significant functionality I wish to include is the ability for customers to personalize products. You must demonstrate that you have successfully incorporated such functionality into previous projects. If you can deliver a user-oriented, modern store with product customization features, I look forward to hearing...
As an individual currently managing a project with numerous details and a profit loss statement, I need assistance with daily tasks for our Excel sheets. This will include: - Data entry and organization to streamline workflow - Basic arithmetic calculations for accuracy - Statistical analysis to make informed decisions - Formatting and visual presentation for clarity This role requires proficiency in Excel, a keen eye for details, and strong analytical skills. Experience in financial or project management is a plus. The job will be ongoing and requires daily attention. If your expertise aligns with these needs, please apply.
...qualifications for this project include an in-depth knowledge of web development, exceptional aptitude in creating e-commerce platforms, and experience in integrating the necessary functionality for an online shop. Key Features: 1. Product Search and Filters: The ability to search and filter through the listed products or services is crucial. Implement efficient algorithms for sorting and searching items. 2. Shopping Cart and Checkout: A user-friendly interface is required for a shopping cart and seamless checkout procedure. 3. Customer Reviews and Ratings: Facilitate customer feedback through a system of reviews and ratings for each product or service. Experience with creating a similar e-commerce platform will be highly advantageous. Examples of previously developed e-commer...
I'm looking for a skilled PHP developer to help me with my modern and sleek jewellery site. Key Requirements: - Product Catalog & Search: The website should have a robust catalog for displaying all our jewellery items. Customers should be able to search for items based on various filters such as price, category, and more. - Shopping Cart & Checkout: A seamless shopping experience is crucial. The shopping cart should be user-friendly and the checkout process should be simple and secure. - User Registration & Login: To enhance user experience, the site should allow users to create accounts, log in, and manage their profiles. This is essential for tracking orders, providing personalized recommendations, and more. Ideal Skills & Experience: - Proficiency i...
I am ready to award this project now. Please only bid if you can start right now and I award straight away. I need a professional who can assist me in finding and saving 6-8 images and 1-2 data sheets for 65 items from a single website. Key Requirements: - The images and data sheets are located in specific sections on the website. Search for product name, select product name and then save images and data sheets. - The collected images and data sheets should be organized by item name and saved into directory name and complete directory containing all information sent to me Skillsets Required: - Excellent web research skills. - Proficiency in data and image saving. - Ability to organize and name files properly. - Detail-oriented to avoid any mix-up. - High level of patience for...
I'm looking for a removalist to help me move 15 cartons from Melbourne CBD to a storage facility in Ringwood. The job is pretty straightforward, no need for additional packing materials, just transporting the boxes and putting them into the storage unit. K...Melbourne CBD to Ringwood - Put all the boxes into the storage unit Additional Information: - No stairs involved, the apartment has elevator access - No requirement for packing or unpacking assistance, just need someone to follow the instructions and lay all the boxes in the storage Ideal Skills and Experience: - Experience in removalist or moving services - Reliable and careful in handling delicate items - Familiarity with Melbourne CBD and Ringwood area Please provide your quote for the job and indicate your availabil...
...projects requiring development haven't been specified, but the key components will include: Brief description: Members can also upload items (only to designated columns set by administrators). Assumption: The administration will set up a category column—Card Trading. Members who log in can upload related items to sell, but only to that column; they cannot upload to other columns. Let's break it down step by step: User Column: Modify the administrator's product management template. The administrator will set up a category, such as the Card Trading Market. Then, all items uploaded by users will be categorized under this classification. To purchase items in this category, users must log in. When a member purchases an item uploaded by ...
I'm in need of a diligent freelancer to assist with typing text data into an Excel sheet. Key Responsibilities: - Typing textual data into Excel sheet in an accurate and efficient manner Ideal Candidate: - Proficient in typing and data entry - Familiarity with Excel - Attention to detail
Hi Mdjuyel M., Thanks for reaching out. I have a logo namely Early Birds which is for a 6am class for our crossfit gym. In this logo are several different birds - What I would like is to change the Wonder Women bird to the Gladiator bird. I will send all the files.
I am looking for a freelancer to help with Excel data typing. The purpose is to perform statistical analysis, specifically focusing on descriptive statistics. Ideal skills and experience: - Proficiency in Excel, particularly in data analysis and handling large datasets. - Strong understanding of statistical methods and experience working with descriptive statistics. - Attention to detail and ability to deliver high-quality, accurate work.
I need an Excel VBA code that can perform exact word matching within an Excel spreadsheet. - The code should generate a list of matched words.
I'm looking for an expert in Excel to assist with a project involving data entry and analysis. The Excel sheet you'll be working on has more than 50 columns and rows and will contain a mix of text, numbers, and dates. You'll be responsible for the following: - Accurate and timely entry of the data provided - Ensuring the data is appropriately formatted and organized - Conducting thorough data analysis, including but not limited to trends, comparisons, and any other insights that can be drawn from the data The ideal candidate for this project should have: - Proficiency in Excel and experience with large data sets - Strong attention to detail - Ability to perform data analysis and present insights - Good communication skills to provide regular updates a...
I require a skilled professional experienced in data entry and Excel. The task necessitates numerical data entry, specific to tracking sales figures. - The ideal candidate will require skills and experience in: - Excel and spreadsheet management - Data entry with precision - Understanding of financial terms and figures particularly related to sales Please make sure you can handle large amounts of numerical data and maintain confidentiality of the sales information handled. Attention to detail is paramount for this task. Understanding of finance or sales is beneficial.
I'm on the lookout for a talented virtual assistant who thrives on lengthy hours of work and enjoys every second of it! This isn't your usual VA role, though - I'm seeking someone who can confidently handle the following responsibilities: - Social Media Management: More specifically, I need someone adept at Instagram. You'll be responsible for handling and managin...our audience. Ideal Skills and Experience: - Clear understanding of the Instagram platform and how to optimally engage audience in it - Skills in crafting Instagram worthy content - visuals, captions, and stories - Experience in managing professional instagram account is a plus - Must be organized, communicative, and able to handle long hours of work If this sounds like the sort of work you'd exc...
For this project, I require an expert who can efficiently extract text content from two distinct webpages and input my data into an Excel file organized by rows. Given that all types of data hold equal importance to me, of essence is for the professional to: - Accurately scrape all text content from the specified webpages - Ensure no data is skewed or omitted during this process - Neatly organize the data by rows in the Excel file The ideal candidate for this job should be proficient in web scraping tools and techniques, possesses an acute attention to detail, and is experienced in using Excel to ensure data is properly formatted and easy to analyze. Please note that minimizing errors during this process is critical, as the data collected will directly influence fur...
...Ability to deliver working solutions on a tight schedule • Conducting stakeholder meetings with the project stakeholders as and when required • Work with the Quality Assurance team to ensure complete coverage of listed out acceptance criteria • Ensure issues are identified, tracked, reported on and resolved in atimely manner • Attend sprint planning meetings and work towards defining the sprint items along with the product stakeholders • Attend weekly status meetings and effectively communicate the same to the concerned stakeholders • Responsible for creating andmaintaining all requirementand project related requirement documentation including BRDs, FRDs • Prioritize requirements and create conceptual prototypes • Co-ordinate with developme...
I require data entry services to transfer numeric data from Word documents to Excel sheets. The ideal freelancer should have: - Excellent typing accuracy and speed, focusing on numbers. - Proficiency in Microsoft Word & Excel. - Previous data entry experience, particularly with numeric data. - Ability to interpret data from Word documents. - Strong attention to detail. Responsibilities include: - Extracting number data from Word documents. - Accurately entering data onto an Excel sheet. - Cross-verifying accuracy of entered data. This is a valuable task for my project and I'm seeking a meticulous, efficient professional who can assure the most accurate transfer of data.
...has already been generated and there is a download link on another page of the site) * Add generation of an invoice for using the site in pdf form (the form will be provided) with saving on the pages in the admin panel and on the user page. * Edit the account pages created in the admin panel, add a filter by user, month, account status and account number (these fields have been created, you just need to display them on the page). It should be possible to delete and download invoices, both individual documents and all at once. * There are 2 fields created on the site (tariff payment and number of contacts). You need to make sure that these fields are also displayed in the mobile version of the site and add statement generation for these fields. * Set up the gener...
I require a freelancer to type text data into an Excel sheet from printed documents. Scope of work: - Convert printed text documents into digital format via Excel - Ensure data is accurately entered The project does require specific formatting: - Data should be arranged in rows Ideal candidate: - Must have proficient Excel skills - Experience with data entry - Attention to detail, to ensure accuracy in work - Able to follow specific instructions for data organization
...tenure, salary and location of our employees. Your ability to structure and organize these aspects will be key. - Creating an Excel-based system: I'm looking for a dashboard that's easy to dissect and understand. As such, I'd like the final product to be in Excel spreadsheet format. This means you should be very proficient in Excel, knowing how to integrate formulas, tables and other relevant features. - Monthly updates: The dashboard should be designed to be updated monthly. You should be dedicated to ensuring that the data is up-to-date and accurately represented. Ideal freelancer should have: - Proven experience in HR analytics and dashboards - Excellent Excel skills - Ability to present complex data in a clear and concise manner - Strong...
I have an excel sheet with intermediate complexity data, including formulas and charts. I need someone to transfer this data into tables, with the primary goal of organizing the information for better clarity and ease of understanding. Key Tasks: - Type the data into tables: This needs to be done with meticulous attention to detail to ensure accuracy and integrity of the data. - Apply borders and shading: To enhance the visibility of the tables and make them aesthetically pleasing. - Utilize headers: Rows and columns should have appropriate headers to aid in quick data navigation. Ideal Freelancer: - Proficient in Excel: Ability to work with intermediate level of data such as formulas and charts. - Strong attention to detail: Critical for ensuring that data is entered accur...
I need a WordPress site built, replicating the functionality of https://constructionkart.in. This is an e-commerce website that sells construction tools, building materials, as well as bath and kitchen items. The site must include: - A product listing feature that has comprehensive details on each item. - Shopping cart functionality that allows users to add and manage items they wish to purchase. - User registration and login mechanisms to enable easy sign-up and returning customer access. - A product search feature for quick item locating. - Product filtering to allow users to narrow down their search based on specific criteria. - A payment gateway integration for seamless and secure online transactions. Ideal freelancers for this job should have: - Proficiency in W...
I am in search of a proficient virtual assistant who is adept at listing products on Wix and Shopify. Your primary task will be to assist with the listing of an array of clothing items on these platforms. Ideally, the candidate should possess: - In-depth understanding of Wix and Shopify platforms - Proficiency in product listing across multiple categories, preferably clothing - Excellent attention to detail to ensure accurate descriptions and optimal keyword use - Experience with product photography or digital photo editing is an advantage - download product images and editing to the theme and layout of our website - Come up with product names, product description that is SEO optimized - Work closely with founder to fix price and work on website Required: - A desktop, Laptop tha...
...looking for an Excel expert who can create a comprehensive sales target tracking spreadsheet for my customers. This spreadsheet should have several key functionalities. Features Needed: - Customer Information: It should contain a section where I can input and maintain all my customer's details. - Sales Tracking: The spreadsheet should enable me to track my sales targets daily and provide a detailed analysis of my performance. - Target Achievement: The spreadsheet should also be able to analyze the achievement or shortfall of selected items target completion by each customer. Analysis Required: - I would love to have a feature that shows how well sales targets are being achieved as per defined targets. Ideal candidate should have great attention to detail, prof...
I need an organized mind to help with research and data entry of a list of companies in a specific industry. Your main responsibility will be organizing this data. While basic Excel skills are a must, experience with data organization, particularly in a business context, would be highly beneficial. The data will be divided into 4 separate categories, so whoever takes on this task needs to have a keen attention to detail and an understanding of categorization. This project is perfect for an individual who thrives in organizing and systematizing data.
**Tour Costing Sheet Structure** 1. **Tour Details** - Tour Name - Tour Code - Duration - Destinations 2. **Client Information** - Client Name - Number of Adults/Children - Contact Information 3. **Accommodation** - Hotel Name - Room Type - Meal Plan - Cost per Night - Total Nights - Total Cost 4. **Transportation** - Vehicle Type - Distance - Cost per Kilometer - Total Cost 5. **Sightseeing and Activities** - Activity Name - Per Person Cost - Number of Persons - Total Cost 6. **Miscellaneous Expenses** - Guide Fees - Entrance Fees - Other Expenses 7. **Pricing** - Subtotal (Sum of all costs) - Markup Percentage - GST (Goods and Services Tax) - Final Price 8. **Payment Details** - Deposit Require...
I am seeking expertise for my VLSI Magic project that requires: - High-complexity circuit design, calling for an in-depth understanding of intricate electronic circuit schematics. - Proficiency in logic synthesis, particularly in multi-level logic synthesis which is ...synthesis, particularly in multi-level logic synthesis which is vital for my project. Part 1: Verify the design using a logic design tool. Part 2: Implement your design using Magic VLSI layout tool to generate your project layout Part 3: Test your design using irsim to simulate your project. Project submission should be two items: a- A report PDF file. (PDF) b- A compressed file containing all your codes, simulations, and results. (.zip, .rar)
I'm seeking a detail-oriented professional to manually transfer valuable ...detail-oriented professional to manually transfer valuable data from Internet sources to an Excel spreadsheet. The ideal candidate for this job should have: - Proven experience in data entry and Excel - Excellent attention to detail and accuracy - Flexibility in terms of formatting as you will have to determine the most effective and efficient structure for the data The challenge of this task lies in manually extracting data from the web, an eye for detail is, therefore, paramount. Your responsibility is to ensure all the data is correctly entered and organized in a clear and comprehensible manner. Your creativity and critical thinking are appreciated when deciding the layout and formatting...
I'm in need of a skilled Android developer who's proficient in both front-end and back-end development. The project involves building an e-commerce app with a couple of key features. Key Features: - Product Catalog: The app should have a neatly designed product catalog that displays all available items. - Shopping Cart and Checkout: A functional shopping cart system should be integrated, along with a smooth and secure checkout process. - Payment Integration: The app will require integration with a credit/debit card processing system for seamless payments. Ideal candidates for this project will have: - Prior experience in developing Android e-commerce apps. - Proficiency in both front-end (UI/UX) and back-end (server-side) development. - Strong understanding of mobile pa...
I'm looking for a freelancer to help with a simple Excel data entry task, as well as some basic formula work. I have a spreadsheet that primarily contains numbers. Your role would be to accurately type this data into the sheet, ensuring that every entry is correct and in the right format. This task is meant for particular record-keeping purposes, so precision and attention to detail are crucial. In addition to the data typing, I need some basic Excel formulas applied. Experience with Excel and knowledge of formulas is essential to ensure the data is well-organized and easy to work with. This task is not overly complex but will require someone who is proficient with Excel's formula functions.
I'm looking for an expert baker to create decorated waffles and bakery items. This is not for a particular event but for my personal enjoyment. Key requirements: - Mastery in baking and specifically in cake making - Ability to enhance the flavor through creative and innovative methods - Experience with personalized cakes Please provide your portfolio of similar projects or let me know about your experience in baking, particularly in creating cakes. Your approach to keeping the cake fresh and presentable will also be a plus.
I'm seeking a freelancer who is adept at typing for a task that involves transcribing handwritten notes into Excel. The legibility of the handwriting is average, so this job demands patience, careful observance, and excellent data entry skills. - Your task would be to transcribe the data from handwritten notes into an Excel file. - The content you'd be dealing with primarily includes text. I'd prefer individuals who have previous experience in data entry, especially tasks that require extracting data from handwritten sources, and are proficient in using Excel. Attention to detail is a must, as accuracy is paramount in this job. Your ability to decipher moderately legible handwriting would be a great advantage. Please bring a keen eye for detail, and ...
I'm in need of a skilled Android developer who's proficient in both front-end and back-end development. The project involves building an e-commerce app with a couple of key features. Key Features: - Product Catalog: The app should have a neatly designed product catalog that displays all available items. - Shopping Cart and Checkout: A functional shopping cart system should be integrated, along with a smooth and secure checkout process. - Payment Integration: The app will require integration with a credit/debit card processing system for seamless payments. Ideal candidates for this project will have: - Prior experience in developing Android e-commerce apps. - Proficiency in both front-end (UI/UX) and back-end (server-side) development. - Strong understanding of mobile pay...
I am currently working on a project that requires the integration of Excel with a PostgreSQL database. As such, I am in need of a freelancer who is proficient in both Excel and PostgreSQL. The primary tasks to accomplish include: 1. Exporting data from Excel to SQL 2. Updating PostgreSQL data using Excel You will be working with various kinds of data as we aim to streamline our operations in a more efficient manner. Ideal skills and experience include: - Solid understanding of PostgreSQL - Expert skills in Excel - Previous experience with SQL data exporting and updating The success of this project highly relies on a flawless data transfer between Excel and PostgreSQL. Your expertise will be extremely valuable to our project's completi...
I'm in need of an expert to assist with the cleanup of our Medicine database. The goal of this project is to accurately remove all duplicate entries improving the overall accuracy of the data. Ideal Skills & Experience: - Strong background in Database / Excel /CSV management, specifically in the medical field. - Proven track record of similar past work. In your application, please include details of similar projects you've worked on. Efficiency and precision are pivotal for this task. Looking forward to a neat and streamlined database!
