Projek mini excellavori

I need help updating my weekly Profit and Loss statement. The process is quite nuanced, and I will need to communicate with you regularly. The task involves gathering data from various sources. Data Sources: - Internal...with you regularly. The task involves gathering data from various sources. Data Sources: - Internal company databases - External financial portals - Spreadsheets from different departments Data Format: - Primarily in Excel spreadsheets Your Tasks: - Data entry and consolidation - Data analysis and interpretation Once you become proficient and knowledgeable about the process, it should take no more than 2 hours per week. However, I need assistance every week. Ideal candidates should be experienced with data analysis, have a keen eye for detail, and be proficient...

I need a freelancer to assist with a small project focused on gathering and entering data from various research sites. The task primarily involves collecting textual information from these sites. Ideal Skills: - Excellent attention to detail - Proficiency in data entry - Familiarity with research websites The process will...research websites The process will involve: - Simple text extraction from identified research projects across several different websites. Your role will be crucial in helping me compile this information accurately and efficiently. The estimated volume of data collection is medium (101-500 entries). Please enter the collected data into a spreadsheet format. Please enter the collected data into an Excel spreadsheet. The expected time frame for this project ...

I need a Python program that will analyze my Excel data for me. The file has 10,000 rows and 40 columns. The program should: - Examine a specific range within column B and extract all numerical values from the text of each line. - Create a new Excel sheet where these numerical values are inserted into one or several columns adjacent to column B. - Retain all other columns from the original sheet in the new one. Additionally, all numerical values need to be converted to decimals before being inserted into the new sheet. The ideal freelancer for this project should have: - Expertise in Python programming, particularly with data analysis and Excel manipulation. - Experience in writing Python scripts for Excel. - Ability to convert numerical values into decimal...

...back of product (See bottom for more info.) - 1 x wire terminal for 2 pins to power it. (Labelled "12/24V" and "GND".) - 4 x small rectangular status LEDs to display statuses (labeled "PWR", "FLT", "BFIO", "BFA". ) - 2 x ethernet connections on the front. (Labeled ETH1 and ETH2) - 1 x USB A port. - 1 x USB C port. - 1 x miniSD slot for memory card. - 1 x WIFI antenna screwing terminal. - 1 HDMI mini port. - 1 x wire terminal for 4 pins titled RS-485 (pins labeled "Tx+", "Tx-", "Rx+" and "Rx-" ) - 1 x 24 pin female heavy duty terminal on left of product. - 1 x 24 pin female heavy duty terminal on right of product. - 1 x VersaNode logo (attached) should be placed somewher...

...professional typist who can accurately transcribe my handwritten notes into an Excel spreadsheet. This will involve using specific formulas within the spreadsheet. Ideal Skills and Experience: - Proficient in Excel, with a solid understanding of how to use formulas - Exceptional typing skills - Detail-oriented and capable of accurately transcribing handwritten notes - Previous experience with data entry - Ability to maintain confidentiality and handle sensitive information with discretion The typist should use SUM and AVERAGE formulas in the spreadsheet. The project involves less than 50 handwritten notes. The handwritten notes follow a specific structure. The handwritten notes do not require any specific formatting in the Excel spreadsheet. The project needs to b...

I am looking for a professional with expertise in Power Automate to help me extract data from two sources: an auction website and a real estate website (Zillow or ). The final output should be an Excel spreadsheet containing the extracted data as described below. Key Tasks: Auction Website (Grey Columns) Extract all the data from the grey columns (as per the attached example) on the Atlantic County and Cape May County auction websites. The data should be saved in an Excel spreadsheet. Each county’s data should be saved on a separate tab or a separate file. Real Estate Website (Purple Columns) For each property listed on the auction website, match its address with the details available on either Zillow or Realtor.com. Extract all the columns in purple (as per the attache...

formatoExcel={ 'A':{'encabezado':'Contacto', 'patron':[]}, 'B':{'encabezado':'Fecha', 'patron':[]}, 'C':{'encabezado':'Hora', 'patron':[]}, 'D':{'encabezado':'Mensaje', 'patron':[]}, 'E':{'encabezado':'Es renta', 'patron':['(rent(a|o)|for rent)']}, 'F':{'encabezado':'Es venta', 'patron':['(ven(ta|do)|for sale)']}, 'G':{'encabezado':'Es Demanda', 'patron':patronesDemanda}, ...

I need a freelancer to create a tailored open sales and quote report for me. This report should combine both sales and quote data, and be delivered in an Excel spreadsheet. Key elements to be included in the report: - Customer details (name and state) - Product details - Pricing and totals - Expected order date - sales person estimate chance of closing quote An ideal candidate for this project would be someone with strong skills in data analysis and Excel, as well as experience in sales and quote reporting. Please create a custom layout that is easy to navigate. Please use a tabular format for the layout. Include options to filter by date. Exclude visual elements like charts and graphs. The report should be grouped by chronological order.

I'm looking for an Excel template that can comprehensively record and track class-wise fees. The template needs to encapsulate the following aspects: - Fee Receival Details: The template should allow me to log the date and mode of payment (cash or online), the amount and balance, as well as class and student information for each fee received. - Expense Tracking: It should also track our expenses, including supplies and materials, salaries and wages, as well as maintenance and utilities. - Pending Fees: The template needs to show pending fees month-wise and class-wise. - Master Sheet: The master sheet should provide an overall report, class-wise dues, and breakdowns for total dues and total paid, as well as payments made via cash and online. Ideal skills for this project i...

I need a prop firm website with specific fu...About Us(Contact page), FAQ page (redirect to Intercom Help page). - A 'Dashboard' button for user login with purchase credentials. Post-login, users see a message stating the dashboard is under construction and their credentials have been emailed. - Functionality for users to sign up, log in, and purchase trading challenges. - Email integration for purchase confirmations and details. - An admin mini dashboard to monitor account purchases and checkout details. - Checkout process via WooCommerce. Ideal Skills: - Proficient in WordPress and WooCommerce. - Experienced in website development and integration with email services. - Knowledge in creating user login systems and admin dashboards. - Attention to detail for following a ...

...empresarial. Experience with Microsoft Teams for communication is preferred. The assistant will use Microsoft Teams for communication. The assistant should have advanced skills with Microsoft Teams. An expert level of familiarity with accounting principles is expected. The assistant will generate a daily summary report from the verified payments. The assistant should be proficient in Microsoft Excel. An expert level of familiarity with accounting principles is expected....

I need a form that saves data from a form in a excel database

...will specifically appeal to potential investors. Ideal skills and experience for the job: - Proficiency in graphic design software (e.g., Adobe Illustrator, Photoshop). - Previous experience creating infographics, especially for investment purposes, would be highly beneficial. - Strong ability to translate complex data into visually appealing and easy-to-understand graphics. - Familiarity with Excel and the ability to work with data from this software. - Excellent understanding of minimalistic design principles. - Expertise in data visualization techniques to represent complex revenue data effectively. Please use our corporate colors for the infographic. The infographic should include charts to present the data. The final deliverable should be in PDF format and include an edita...

I'm seeking an Excel expert to update a commercial real estate model. The updates primarily involve financial projections, and the tweaking of formulas and calculations. Key Tasks: - Adjust financial projections to reflect new market conditions - Review and correct formulas and calculations as necessary - Ensure the model is compatible with a customized company template The most critical financial metric that needs to be accurately assessed in this model is the land acquisition and lending criteria. Ideal Skills: - Extensive experience with Excel, particularly in financial modeling - Understanding of commercial real estate metrics and valuations - Ability to work with and adapt to a specific company template - Strong attention to detail to ensure all calculations an...

I need help analyzing a dataset in Excel. The project involves answering five simple questions using charts. You will need to provide the raw data file with all formulas, pivots, etc. Key tasks: - Use charts for data visualization - Focus on comparing different categories - Create a comprehensive and insightful analysis Ideal skills and experience: - Proficient in Excel with strong data analysis skills - Able to create clear and informative charts - Good understanding of category comparisons in data

...experienced freelancer who has a wealth of knowledge with PDF documents and office softwares such as Word and Excel. Here's what I need from you: Task 1 - Our current proposals we send out to clients were created in Indesign however they do not work with our CRM system, so therefore we need to create these same designs in word which will work with our CRM system. Converting the PDF documents into a word document could be one easy fix, or redesigning the original design into Word would be another option. I will leave that to your expertise. Task 2 - We currently send out a form which was created in Word to our clients to fill and send it back. We need to redesign this form in Excel, we need it to look luxury and high quality (similar to proposal documents) The fo...

...second. The expected cash flows during operation are 30,000 PLN in the first year and 40,000 PLN in the second, followed by a sale of the factory for 1.2 million PLN at the end of the second year. Your deliverable will be a detailed IRR calculation in an Excel spreadsheet, as well as a report justifying the investment based on your analysis. You will need to consider the appropriate discount rate, with WACC at 12% and CAPM at 14%. Ideal candidates will have: - Strong background in finance and investment analysis - Proficiency in Excel for complex calculations - Ability to present findings in a clear, concise manner. Zadanie nr 5 - IRR Inwestor zamierza wybudować fabrykę. Wyda na ten cel 1 mln zł, przy czym tylko 30% środków będzie pochodziło z kapitału wł...

I'm looking for an Excel wizard who can create an efficient drop-down menu tool for me. This tool will be used for data selection, with over 50 options in the drop-down menu. The project involves: - Designing a user-friendly drop-down menu with more than 50 options for data selection. - Implementing a reset button that restores default selections when clicked. Ideal skills for this project include advanced Excel knowledge, particularly in creating drop-down menus and implementing macro buttons. Experience in creating user-friendly Excel tools is a plus. The drop-down menu should include additional features to enhance functionality.

...textile weaving sector to develop a comprehensive Excel sheet for production planning and lead time management. Key Requirements: - Expertise in resource allocation, inventory management, and scheduling within the textile industry - Ability to create an Excel sheet that generates daily production reports, inventory status reports, and lead time analysis reports - Proficiency in incorporating automatic calculations, data visualization (charts/graphs), and customizable templates into the Excel sheet Your experience in the textile weaving field will be crucial in tailoring this Excel sheet to meet the specific needs of our production line. This project would ideally suit a freelancer who can combine their industry knowledge with advanced Excel skills to...

I need a skilled freelancer to create a PDF legal contract using our Excel template. The document should incorporate our branding elements, specifically the logo and color scheme. Excel doc proposed template PDF original template

Check the attached document for a better overview of the project info! We are seeking an experienced UiPath freelancer to develop workflows for extracting data from Excel, PDF, Word, and Email files, converting it into structured formats (e.g., JSON, CSV, XML). This project serves as the foundation for a broader workflow automation initiative. If successful, there will be opportunities for ongoing development work to expand and enhance the system. Provided Tools We will supply: UiPath Pro License: For workflow development. UiPath Document Understanding: For advanced OCR and document processing. Proposal Submission Guidelines Freelancers are invited to submit proposals incorporating an hourly rate for the project. Along with your hourly rate, please provide the following details fo...

Necesito un bot para automatizar el poner reseñas de Google Maps. Cogería los datos desde una lista de excel, el nombre de la empresa, el texto para la reseña y la valoración en estrellas.

I recommend having OCR Sk...recommend having OCR Skills as its a reasonable amount of data Convert 12 PDF bank statements into a single CSV file. The details to be included in the CSV are: Date, Description, and Amount. Spreadsheet and first statement of 12 attached. IMPORTANT 1. Electronic Deposits and Credits would go under the DEPOSITS column in Excel for the amount 2. Electronic Payments, Service Charges, Other withdrawals and Checks paid would go under WITHDRAWELS column in excel for the amount Ideal Skills: - Proficiency in OCR, data entry and PDF to CSV conversion - Attention to detail to ensure accurate data transcription - Experience with handling financial documents Please note, there is no need for categorization of transactions. All 12 statements are i...

Regular excel reporting project ( weekly basis payment). Details discussed via PMB.

...startup and need a comprehensive financial model in Excel for the next 5 years. The model should incorporate all the classic components typical of standard financial models, including charts for key metrics. Key aspects to include: - Revenue and expenses - Churn rate - Growth (sales, clients, turnover, profit) - Discounted cash flow - anything else typical being part of financial models for startups I will provide basic data for calculations. If anything is missing or unclear, you're expected to reach out and ask for additional input. The model should account for 3 revenue streams, which I'll detail. Ideal candidates should have: - Strong background in finance and financial modeling - Experience with SaaS businesses - Proficiency in Excel - Ability to communic...

As discussed, I'll do the conversion from PDF to Excel for the file you have shared.

I have multiple project spreadsheets in Excel that get copied and pasted as new projects are established. Within each template, there's a spreadsheet that tracks change orders identified by project names. I need a single aggregator spreadsheet that continuously pulls data from all to hold the summary data. Key tasks: - Create an aggregator spreadsheet in Excel - Ensure it pulls data from all individual project spreadsheets - Track change orders based on project names Ideal skills and experience: - Advanced Microsoft Excel skills - Experience with Excel data aggregation - Familiarity with project management spreadsheets The frequency of updates to individual spreadsheets varies. Some may lay empty, while others may have two change orders a month. Therefor...

I'm looking for an Excel expert to create a macro that helps me update my Bill of Quantities (BOQ) using an old list of glass panels. The goal is to efficiently identify and compare reusable materials. Specific Tasks: - The macro should identify reusable glass panels. - It should compare entries from the old and new BOQ. - Finally, it should generate a report detailing usable materials. Report Structure: - The output report should be structured in an Excel spreadsheet. Data Format: - The old glass panels list is currently stored in an Excel spreadsheet. Ideal Skills: - Proficient in Excel macros and VBA. - Experienced in data comparison and reporting. - Able to deliver a well-structured Excel report.

I have a set of survey data that is in an Excel or CSV format, and I'm looking for a statistician or data analyst to help me summarize it. Ideal applicants for this project should have: - Proficiency in statistical analysis - Experience working with survey data - Ability to work with Excel and CSV files - Capable of providing clear, comprehensible summaries of data

...overcome perennial lack of data (let alone quality data) to support effective decision-making, particularly in developing economies. Of now, we are conducting an employee background check on behalf of our clinet. JOB DESCRIPTION: I need a local representative to conduct a verification. Below is the task: 1. Verify the subject' reputation 2. Provide photos of the subjects' place 3. Conduct a mini-interview with the subjects' neighborhood (it's a process of employee background check) Requirements: 1. Living in (or nearby) Ryskulbekov street, Astana, Kazakhstan 010000 2. Available to do the job during business hours (9 AM - 4 PM) Notes: - 1 project can only be taken by one freelancer (on a first-come, first-served basis) - The milestone will be released the...

We are looking for an experienced Excel developer to create custom dashboards for our Opportunity Tracker spreadsheet. This project involves transforming an existing data-heavy spreadsheet into an interactive and visually appealing dashboard to provide quick insights and metrics for our sales organization. Here is a video explaination: Project Overview: Our company tracks sales opportunities in a comprehensive Excel spreadsheet. While all data resides in a single tab, we need dashboards to quickly visualize and summarize key metrics such as total pipeline value, stage breakdowns, trends, forecasts, and campaign-specific data. Scope of Work: Dashboard Development: Create a dashboard to summarize and visualize key

I'm in need of a data analyst who can delve into various datasets including f...financial anomalies. - Recommend strategies for optimal stock level maintenance. Ideal Skills: - Proficiency in data analysis tools (e.g., Excel, Python, R). - Strong understanding of financial and operational metrics. - Experience in customer data interpretation. This project will require a keen eye for detail and the ability to identify trends, forecast potential outcomes, and detect any anomalies. Please submit your proposal if you have the relevant experience and can meet these requirements. Reports should be generated every daily to track progress and trends. Focus on data from the following timeframe: monthly. Final reports should be delivered in Excel format. Analysis should focus o...

I need a proficient ...include IT and Technology, E-commerce, Fintech, Digital Services, Shared Services and Outsourcing (SSO), and Energy Companies. The specific company details required are: - Contact Information - Company Address - Company Email - C-Suite Level Name - C-Suite Level Contact - C-Suite Level Email - Industry Category/Classification - Company Website URL The extracted data should be delivered in an Excel spreadsheet. Ideal skills and experience for this job include: - Proficient in web scraping - Familiarity with data extraction from the specified sectors - Able to deliver data in the specified format - Attention to detail - Good understanding of C-Suite level roles in companies. This will be a one-time web scraping project. The project should be completed with...

...technology assessment outcomes for less than 10 specific treatments. The data required is primarily effectiveness data. Skills and experience ideal for this job: - Proficient in data entry and spreadsheet manipulation - Familiarity with health technology assessments - Ability to source and verify effectiveness data - Attention to detail for accurate data entry The final spreadsheet should be in Excel format. The project should be completed within 1 week. "I will provide links to the HTA assessments." The data should be organized using a predefined template that I will provide. Please categorize the effectiveness data by treatment type. Only use the links provided for sourcing the HTA assessment data. "No additional analysis is required." The spreadsheet sho...

I have multiple sheets in a workbook. Each Sheet represents a week, and each week Includes different tenders for different projects. I need assistance in extracting the lowest bidder from each sheet and respective project. - The bid entries are numerical va...sheet and respective project. - The bid entries are numerical values located in the same column across all sheets. - I have attempted to use VLOOKUP and INDIRECT functions, but they only return the first value encountered. I'm looking for a more efficient solution that can incorporate the MIN function to find the lowest bid. - The ideal freelancer for this project should be highly proficient in Excel and familiar with its advanced functions. Given my tight schedule, I would appreciate a swift and effective solution t...

...script must be capable of placing trades automatically and executing it smoothly. I have code for login trading accound and fetch token data. I need to update code to my system. I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 10 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. i need it like application Broker: Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task ...

I need an Excel expert who can assist me in creating complex formulas, particularly for financial calculations related to mortgages and loans. Your tasks will primarily involve: - Developing intricate Excel formulas to help analyze different financial scenarios concerning mortgages and loans. - Providing insights through the use of these formulas. - Developing amortization schedules for fixed-rate and adjustable-rate mortgages. - Formulating monthly and bi-weekly mortgage payment calculations. - Creating formulas for evaluating the benefits of mortgage refinancing. - Developing formulas to break down total loan repayment into principal and interest components. - Creating projections for the future value of investments related to mortgages. Ideal candidates for this project ...

I'm looking for a web-based scanner that allows customers to view the restaurant's menu at specific tables, alongside a mini admin panel and an invoice generator. Key components of the project: 1. **Web-based Scanner**: A system that lets customers scan a code at their table to view the menu. 2. **Mini Admin Panel**: This should include functionalities for: - User management: Keeping track of staff and their roles. - Menu management: Updating and managing the menu items. - Order tracking: Monitoring orders in real-time. 3. **Invoice Generator**: Integrated within the admin panel, this should create invoices with: - An itemized list of orders. - Prices and taxes. - Customer details. Ideal skills for this job include web application development...

...our ERP system and update all entries based on an excel file. There are a total of 5 tasks we need to complete. The first task is to update the contacts for whom we don’t have an email address, prioritizing the Technical Director. Find email addresses for specific job positions: Technical Director, Procurement Director, Sales Director, Business Development Director, CEO. Provide the full name of the person (last name and first name). Find and include the LinkedIn profile of the person. The ideal candidate should be skilled in data entry, research and familiar with LinkedIn and other professional networking sites. Please note that the second step will be discussed after the first task is completed fully and correctly. In the first excel File there are 2078 contact...

I'm in need of an Excel developer who can help me automate repetitive tasks using macros. Ideal Skills: - Proficient in Excel, especially in creating and implementing macros - Strong problem-solving skills - Attention to detail - Previous experience with Excel automation - Advanced knowledge of VBA programming - Experience in data analysis with Excel - Ability to create and manage user forms - Skills in creating charts and graphs for data visualization - Proficiency in implementing error handling in macros - Experience integrating Excel with other software - Skills in optimizing macro performance - Ability to create macros for batch processing tasks Please note, the specific repetitive tasks to be automated are yet to be determined, so flexibility...

...encountering several issues on my website that need urgent attention. These issues are affecting product pages, the menu layout, and the quote cart button. Specific Areas of Concern: - Product Pages: There are misalignments of text and elements that need to be corrected. - Menu Layout: The menu requires reorganization of items, fixing of dropdown issues, and changing "add to cart" to "add to quote". mini cart on menu section - Quote Cart Button: This button is not functioning as expected. - Ensure the website is fully responsive across all devices and screen sizes. Ideal Skills and Experience: - Proficiency in website debugging and troubleshooting. - Extensive experience with web layout design and correction. - Skills in reorganizing website menus and fixing...

I need a professional translator to help translate the user interface elements of my mobile app into Spanish, German, Italian, and Portuguese. The phrases needing translation are currently formatted in Excel/CSV files. Ideal candidates should have: - Proven experience in translating user interface elements for mobile applications - Native or near-native proficiency in the specified languages - Ability to maintain the intended meaning and tone of the original phrases - Familiarity with working in Excel/CSV files - Attention to detail to ensure every element is accurately translated.

...script must be capable of placing trades automatically and executing it smoothly. I have code for login trading accound and fetch token data. I need to update code to my system. I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 10 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. i need it like application Broker: Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task ...

Milestone 1: Collect Data running your web crawler Budget $100.00 Time limit: 3 days, daily update is required You will use Excel sheet provided by me. You must follow all the instruction in the requirement document in the link below. You are doing Milestone 1a and 1b only.

I need an Excel expert who can assist me in creating complex formulas, particularly for financial calculations related to mortgages and loans. Your tasks will primarily involve: - Developing intricate Excel formulas to help analyze different financial scenarios concerning mortgages and loans. - Providing insights through the use of these formulas. - Developing amortization schedules for fixed-rate and adjustable-rate mortgages. - Formulating monthly and bi-weekly mortgage payment calculations. - Creating formulas for evaluating the benefits of mortgage refinancing. - Developing formulas to break down total loan repayment into principal and interest components. - Creating projections for the future value of investments related to mortgages. Ideal candidates for this project ...

Understanding of Requirements and Proposed Procedure 1. Data Overview:The project involves analyzing Nifty 500 stock data grouped by industry. The provided Excel file contains historical stock prices and market capitalization data from 2005 to 2023. A second file provides notes on strategy and ranking methodologies. 2. Requirements Breakdown: • Ranking Stocks by Industries: Group stocks based on their industries and rank them using performance metrics such as returns or technical indicators over time (e.g., 20th–50th percentile). • Applying Filters: Implement filters like Supertrend and other technical indicators (e.g., RSI, ATR) to identify different portfolios based on stock performance. • Timeframe Analysis: Analyze stock performance across various...

I'm seeking a skilled mathematician and data analyst to assist with predictive analysis on my operational data. The ideal freelancer for this project must: - Have extensive experience in predictive analysis - Be proficient in utilizing Excel for data analysis - Possess strong mathematical skills The goal is to glean insights from the data that can inform future operational strategies. Understanding of operational data and its nuances would be a plus.

I'm looking for a freelancer who can scrape data from a specific travel industry website. I need information about travel packages or deals organized into an Excel spreadsheet. This task will only need to be completed once. Ideal Skills: - Proficient in data scraping techniques - Experience with the travel industry - Skilled in Excel I will provide the URL for the website.

...overcome perennial lack of data (let alone quality data) to support effective decision-making, particularly in developing economies. Of now, we are conducting an employee background check on behalf of our clinet. JOB DESCRIPTION: I need a local representative to conduct a verification. Below is the task: 1. Verify the subject' reputation 2. Provide photos of the subjects' place 3. Conduct a mini-interview with the subjects' neighborhood (it's a process of employee background check) Requirements: 1. Living in (or nearby) Ryskulbekov street, Astana, Kazakhstan 010000 2. Available to do the job during business hours (9 AM - 4 PM) Notes: - 1 project can only be taken by one freelancer (on a first-come, first-served basis) - The milestone will be released the...

I'm looking for an Excel VBA expert to help me automate the process of populating a new sheet from an existing one. This project will focus on generating reports based on production data. Key Requirements: - Proficiency in Excel VBA - Experience in data handling and report creation - Familiarity with production data is a plus The existing sheet contains specific data fields that I want to include in the report. The new sheet will be used for report generation. Please note that the ideal candidate should be able to work with a pre-defined set of data fields.