Import excel mysql vb net jobs

I need to make 3 pages same from Bootstrap5 to React.js, fol...Bootstrap5 pages to React.js - Integrate these pages with my existing CodeIgniter4 framework - Ensure that the pages can perform form submissions, authenticate users, and display dynamic data - Enable integration with MySQL for database operations Database Operations: - User information, product details, and transaction records are already present in the database and are working fine, website is live and public, just have to implement React to optimize loading time Ideal Skills: - Proficiency in React.js and CodeIgniter4 - Strong understanding of Bootstrap5 - Experience with MySQL - Ability to integrate dynamic data display and user authentication into web pages - Expertise in implementing form submissions in ...

I'm experiencing issues with my Excel. The Copy/Cut/Paste functions are disabled, and I need someone to troubleshoot and assist me with these functions. Ideal skills for this job would include: - Expert knowledge of Microsoft Excel - Troubleshooting skills - Data entry experience Please help me get my Excel functioning properly again. Thank you!

I'm looking for a freelancer to assist with data entry from spreadsheets into Microsoft Excel. The data is mixed, consisting of both text and numerical values. Ideal Skills and Experience: - Proficient in Microsoft Excel - Attention to detail - Experience with data entry from spreadsheets - Ability to handle mixed types of data (text and numerical)

I have several transactions that need to be compiled into a billing statement. You will receive: - Transaction details in an Excel/CSV format - A template to follow for the billing statement Your task: - Convert the transactions into a Word and PDF billing statement using the provided template - Include all details I provide, such as client details, billing period summary, and payment instructions Ideal skills: - Proficient in Excel - Experienced in Word and PDF document creation - Attention to detail to ensure all supplied information is accurately included

...subscribing to Sales Navigator (cost covered by me), researching through LinkedIn and the web to locate the Melbourne Office and headcount located in Melbourne and populating an Excel spreadsheet with relevant data. Key Responsibilities is to research Melbourne businesses and fill in the following: - Fill in the spreadsheet with the Melbourne office address - Fill the number of staff located in Melbourne (details provided) The workload is anticipated to be about 400 hours. The ideal candidate for this project should have: - Excellent research skills - Familiarity with LinkedIn and Sales Navigator - Proficiency in Excel - Ability to work independently and manage time effectively Please note the list will provide a link to the LinkedIn page which will make it quicker to...

I have years of experience in Website management and SEO and have helped rank many sites(ranking guarantee in 60 days). I have a four-step process (SAVE hundreds in value with the best SEO on the net) ?1/. Increase URL rating - IF YOU? are looking at SEO services you need a good URL score ideally you want it to be a minimum of 60. You can not get the top 3 of Google searches without it. I Will Increase Your URL Rating 60+ Within 10-20 Days Guaranteed. I will also increase your Domain Aurthority to 40+ once the backlinks are indexed(MONTH 2 domain rating and trust flow) ?2/. Manual Easy to understand SEO Audit report Website audit is a must it will narrow down to the exact issues and save you Audit includes ● XML Sitemap Errors ● Robots' Errors ● Spam Score Checking and m...

...without page reloads. Integration with TradingView or custom charting solutions for interactive charts. Mobile-first responsive design with CSS Flexbox/Grid for layout management. Backend: Built with Node.js (Express) or Python (Django/Flask) to handle API requests, user authentication, and integration with Binance (or other CEXs) for liquidity, MoonPay, and blockchain networks. PostgreSQL/MySQL database for storing user data, transactions, and account details. Redis for session management and caching real-time market data. Security: TLS encryption for all sensitive communication. Database encryption for sensitive data at rest. Deliverables Fully functional trading platform with integrated Binance API and MoonPay for fiat purchases. Source Code in GitHub/Bitbucket with...

I need assistance with modifying two Excel files. The modifications include: 1. Separating headers into individual cells (e.g., Serial Number, Last Name, First Name, etc.). 2. Ensuring the header row is consistent across all pages. 3. Removing empty rows. 4. Deleting duplicate words while preserving the main data integrity. 5. Maintaining the serial number and data alignment. The headers follow a specific format, which is a combination of uppercase and lowercase letters. I can describe this format to you, but I will need your assistance to determine it in some cases.

I have three PDF drawings that need to be analyzed and converted into a Bill of Quantity (BOQ) in an Excel format. The scope of the project includes: Ideal candidates for this project should have a strong understanding of construction and engineering principles, experience in BOQ preparation, and proficiency in Excel. Attention to detail and the ability to accurately interpret engineering drawings are essential for success in this task. BOQ should include the following: construction electric electronic works mechanic earth works site works railway perimeter security civil/mechanical/electrical infrastructure The 3 PDF drawings to be downloaded are in the link below under ATT_13: ATT__13_Drawings_HN_COMBINED

I need assistance in organizing my credit card statements. The ideal freelancer would have experience in data consolidation and categorization. Key tasks include: - Consolidating credit card statements from the last 12 to 24 months - Organizing the statements by expense category - Delivering the final product as a well-structured Excel spreadsheet Skills required: - Proficiency in Excel - Data analysis and categorization - Attention to detail

I need a professional Excel file for comprehensive inventory planning. This includes stock level monitoring, demand forecasting, order management, and raw material safety stock. The Excel file will need to integrate with SAP, specifically for seamless data transfer and process alignment. Key functionalities I need in the Excel file include: - Automated data import: I want the data to flow into the Excel file automatically from SAP, without needing manual input. - Custom reporting: The ability to generate tailored reports based on specific parameters or needs. - Data visualization: Incorporating graphs, charts and other visual aids to help interpret the data. Ideal candidates for this project should have: - Extensive experience with Excel, parti...

I'm looking for an expert Excel specialist who can set up a comprehensive spreadsheet for me. The data I will be inputting is a combination of financial and sales tracking information. Key Requirements: - Design and setup of an Excel spreadsheet tailored to track both financial and sales data. - Incorporation of automatic calculations and formulas to facilitate data processing. - Implementation of data visualization tools within the spreadsheet, such as charts and graphs, to illustrate trends and patterns. Ideal Skills: - Extensive experience with Excel, particularly in setting up complex spreadsheets. - Strong understanding of financial and sales data tracking. - Proficiency in creating automatic calculations and data visualizations in Excel.

...as publication dates). • Contact details (email, phone, address, etc.). • Any other publicly accessible, relevant information. 2. Data Format: • Deliver all extracted data in a well-structured Excel/CSV format (with clear headings). • Images and files (e.g., PDFs) should be organised in folders and linked to their corresponding rows in the spreadsheet. 3. Requirements: • Ensure data accuracy and completeness. • Follow ethical web scraping practices (only scrape publicly accessible data). • Avoid causing disruption to the website’s operations. Deliverables: • A completed dataset in Excel/CSV format. • A folder containing all associated images/files. • A brief summary of the process and any challenges encou...

...Native or bi-lingual ASP.NET experience essential - minimum 3 years .NET Core experience essential - minimum 3 years Proven work experience as a Mobile App Developer or Web App Developer. Experience with mobile and web development frameworks such as Ionic, React Native, Flutter, or Angular. Solid understanding of the full mobile and web development lifecycle. Proven experience as a Senior Web Developer / Front End Developer or similar role, with a strong portfolio of web development projects Expertise in modern web development technologies and frameworks such as JavaScript and React. Aware of best practices in implementing functionality into UI/UX design Desirable experience, an understanding of C#, ASP.NET, SQL and .NET Core for back-end integration. No agencies...

...Native or bi-lingual ASP.NET experience essential - minimum 3 years .NET Core experience essential - minimum 3 years Proven work experience as a Mobile App Developer or Web App Developer. Experience with mobile and web development frameworks such as Ionic, React Native, Flutter, or Angular. Solid understanding of the full mobile and web development lifecycle. Proven experience as a Senior Web Developer / Front End Developer or similar role, with a strong portfolio of web development projects Expertise in modern web development technologies and frameworks such as JavaScript and React. Aware of best practices in implementing functionality into UI/UX design Desirable experience, an understanding of C#, ASP.NET, SQL and .NET Core for back-end integration. No agencies...

I'm in need of an Excel whiz who can help me set up a comprehensive sales tracking system. Key Requirements: - Define daily sales-related tasks for each team member - Create an Excel spreadsheet to monitor these activities - Design a final dashboard to consolidate the data Skills & Experience: - Proficient in Excel with proven experience in sales tracking - Capable of creating user-friendly dashboards - Excellent understanding of sales metrics, particularly the number of sales and client interactions. The ideal candidate will help me track the performance of each of my sales team members, ultimately enhancing our overall sales strategy.

I'm in need of an Excel whiz who can help me set up a comprehensive sales tracking system. Key Requirements: - Define daily sales-related tasks for each team member - Create an Excel spreadsheet to monitor these activities - Design a final dashboard to consolidate the data Skills & Experience: - Proficient in Excel with proven experience in sales tracking - Capable of creating user-friendly dashboards - Excellent understanding of sales metrics, particularly the number of sales and client interactions. The ideal candidate will help me track the performance of each of my sales team members, ultimately enhancing our overall sales strategy.

...environments. Monitoring Requirements Host-Level Metrics Ping and availability CPU usage (load averages, per-core utilization) Memory usage (RAM, swap) Disk activity (IOPS, free space, read/write operations) Network traffic (bandwidth usage, errors, dropped packets) Service uptime Service-Level Metrics Web services (HTTP/HTTPS status, performance, visitor statistics) Database performance (MySQL/MariaDB with query statistics) Mail servers (queues, processed/deferred emails, etc.) DNS server health FTP server status cPanel/DirectAdmin-specific service metrics Backup monitoring (jetbackup) Website monitoring Security and Logs User login activity Firewall rule statistics System and error log monitoring Mail log monitoring Apache log analysis Deliverables A fully configure...

...Interface: Clear navigation and instructions for both admin and users. 8. Security: Secure link generation to prevent unauthorized access. Optional: Add password protection for specific files. Technical Requirements: Use Python (preferred) with Telegram Bot API or a suitable framework like Pyrogram or Telethon. Database for storing file data, links, and user information (e.g., PostgreSQL, MySQL, or MongoDB). Hosting recommendation (e.g., VPS, Heroku, or AWS) to ensure scalability and reliability. Deliverables: 1. Fully functional bot with all features implemented. 2. Clear documentation for setting up, managing, and maintaining the bot. 3. Source code and database structure. If you have additional ideas or suggestions to improve the bot, feel free to includ...

I'm looking for an Excel expert to develop a program that calculates various real estate market trends. The program should specifically focus on analyzing general market tendencies. It should be a program that can be used numerous times with different data sets. Key Skills: - Advanced Excel skills: You should be proficient in Excel and able to create complex formulas and functions to analyze the data. - Real estate knowledge: A background or understanding of the real estate market would be a plus as it would help you comprehend what data is relevant and how to interpret. Please provide examples of similar projects you have completed.

I need a skilled professional to seamlessly integrate my Microsoft Access Database with a daily-updated Excel sheet. The Excel sheet contains mixed data (text and numbers). Key Tasks: - Daily integration of updates from the Excel sheet into the Access database. This includes both appending new records and updating existing ones. Ideal skills and experience: - Proficient in Microsoft Access and Excel. - Experience with data integration and automation. - Ability to set up a system that requires minimal manual intervention.

I need someone skilled in data entry to help with inputting mixed data (numerical and text) into an Excel sheet. The data needs to be organized in chronological order. I will provide a PDF with data that contains 4 fields to be entered on Excel document. Ideal skills for this project include: - Proficiency in Excel - Excellent attention to detail - Strong organizational skills Please note, there will be no specific date or time formats involved in the data entries.

As a law firm, we're looking for a developer who can create an application for real-time analysis of Twitter, Facebook, and Instagram posts from a specific area. The app should categorize posts by theme, and generate an Excel file detailing demographic information such as age, gender, location, interests, and the profiles of followers and followees for each segment. The ideal candidate for this project should have: - Extensive experience in app development, particularly for social media analysis. - Proficiency in data segmentation and Excel file generation. - Ability to implement real-time data processing. - Skills in understanding and analyzing demographic data. Your work will help us conduct a market analysis to better orient our services.

...membership plans with exclusive content and features. • Easy in-app purchases for subscriptions. Technology Requirements: • Mobile Development: Native iOS (Swift) and Android (Kotlin) apps or cross-platform frameworks like Flutter/React Native. • API Integration: Ensure seamless communication between the app and the web backend. • Database Management: Use a scalable database (e.g., Firebase, MySQL) to handle real-time data sync. • Push Notifications: Integration of Firebase Cloud Messaging (FCM) or other push services. • Wearables Integration: Apple HealthKit, Google Fit API, and third-party wearable SDKs. Deliverables: 1. Fully functioning iOS and Android apps (ready for submission to App Store and Google Play). 2. Documentation for the we...

Hello Sir/Madam, my name is Mohammed Shan. With five years of experience in Microsoft excel, I specialize in creating advanced spreadsheets tailored for sales data analysis. I am adept at using Excel formulae and data analysis tools, including the creation of effective - drop lis downts. My strong attention to detail and proven track record in handling complex Excel projects make me a suitable candidate for your needs. I look forward to delivering high-quality results for your project.

We are seeking a skilled language expert with a strong background in medical and clinical terminology to handle the conversion of case studies and hospital reports into major global languages for international medical research. This position requires a professional with a deep understanding of medical practices and terminology in both the Italian healthcare system and global medical research standards. You will play a crucial role in ensuring that Italian medical documentation is effectively adapted for use in global research initiatives, supporting advancements in healthcare on an international scale. The focus of this role is the precise and accurate conversion of clinical and hospital reports into English, French, Spanish, or other widely spoken languages. The documents in question inv...

I need a PowerApp developed that handles mixed data types (text and numerical). The app should be able to connect to an Excel spreadsheet, as this will be the primary data source. Key Requirements: - The PowerApp should store data for manual calculations, which will primarily involve basic maths. - Finally, the processed data should be able to enter into SharePoint. Ideal Skills: - Proven experience in developing PowerApps. - Familiarity with SharePoint and Excel integration. - Basic understanding of mathematical calculations for data processing.

I'hankm looking for a pPDF, Word. T y Hello Sir/Madam, my name is Mohammed Shan. With five years of experience in Microsoft Excel, I specialize in creating advanced spreadsheets tailored for sales data analysis. I am adept at using Excel formulae and data analysis tools, including the creation of effective drop-down lists. My strong attention to detail and proven track record in handling complex Excel projects make me a suitable candidate for your needs. I look forward to delivering high-quality results for your project.

...email notifications for:  Offer requests  Booking confirmations  Payment confirmations  Travel reminders and vouchers  Post-trip feedback requests (e.g., TrustPilot) • Data Consistency: o All customer and booking information feeds into a centralized CRM database. o Ensure accurate and consistent data across all processes. 6. Provider and Inventory Management • Hotel and Golf Contracts: o Upload net rates, booking conditions, seasonal pricing, and inventory details. o Manage inventory types (e.g., single rooms, suites, villas, green fees, tee times) with automation for availability and pricing updates. • Operational Booking: o Automate communication with hotels and golf courses, including customer details, booking confirmations, and operational requirements. o ...

respond with vocaroo audio recording stating your experience in order to be considered ...each hour. Maintain accuracy and timeliness in all reporting tasks. Schedule: 9:00 AM to 5:00 PM EST, Monday to Friday. Requirements: Basic understanding of bookkeeping (no extensive experience necessary). Strong attention to detail and time management skills. Ability to follow a structured schedule and meet deadlines consistently. Reliable internet connection and proficiency with tools like Excel, Google Sheets, or similar. What We Offer: Supportive team environment with opportunities for growth. Training and resources to help you succeed in the role. Competitive pay for your time and effort. If you’re organized, dependable, and ready to commit to a full-time schedule, we’d love...

Project Overview: We are seeking a talented freelance developer or development team to design and build a custom HR software solution tailored to our needs for payroll processing and a...Interface: Simple & Intuitive UI: Create a user-friendly interface for employees to clock in/out, check attendance, and view pay details. Admin Panel: Develop an admin dashboard for HR to manage payroll, attendance, and generate reports. Technical Stack: Frontend: HTML, CSS, JavaScript (React or Angular preferred) Backend: Python (Django, Flask), Node.js, Java (Spring Boot), or Ruby on Rails Database: MySQL, PostgreSQL, or similar Integration: Payment gateways, tax APIs, and email/SMS notifications (as needed) Previous work experience in HRMS tool is highly preferred , must be able to show the ...

I'm in need of a seasoned C#/.NET Full Stack Developer. Although specifics weren't mentioned, I'm open to discussing web application, desktop application, or API development. The ideal candidate would be proficient in: - C# and .NET Framework - Full stack development - API integration and development Experience with SQL Server, MySQL, or NoSQL databases would be beneficial. Please feel free to propose suitable frontend technologies, but proficiency in React, Angular, or Vue would be a plus.

I need assistance with an Excel spreadsheet. The project involves data analysis, particularly performing statistical analysis. Ideal Skills: - Proficiency in Excel, particularly with formulas and data analysis tools. - Experience with performing statistical analysis in Excel. - Ability to assist with sorting and filtering data, as well as creating pivot tables.

...able to log in to our custom web interface, store multiple passports, and trigger the booking process easily. Provide clear status messages (e.g., success, error, appointment confirmed, etc.). Preferred Tech Stack: Backend: Python (Requests, Selenium, or equivalent) or Node.js (Puppeteer, etc.) Frontend: Any modern framework (React, Vue, Angular) or a simple server-rendered approach. Database: MySQL, PostgreSQL, or similar for storing user credentials and scheduling data if needed. Deliverables: Complete source code with documentation. Deployment instructions for both the web application and any background scheduling processes. Basic test suite or demonstration to ensure the workflow functions end-to-end. Budget & Timeline: Please propose a reasonable timeline and budget b...

Dear Freelancers We need someone who can make a quick database for us We have invoice where you need to take infos from the client: -First name last name adress phone number -how much they spent over...someone who can make a quick database for us We have invoice where you need to take infos from the client: -First name last name adress phone number -how much they spent over the years -number of the invoice and how much invoice they paid over the years too Invoices are .doc (so you can copy/paste) easily We give access to our Dropbox From 2020 to 2024 there is around 1300 invoices You can do it on excel or something else if you have an other idea, we need something designed and easy to look at please Write elephant in your bid to show us that you've read what we need Need it...

I'm looking for a cross-platform mobile app (iOS and Android) that incorporates a virtual assistant with automated responses. The primary function of this virtual assistant would be to handle product information queries. Key Features: -Create AI agent that can browse the net looking for shopping deals - Designed for both iOS and Android platforms - Incorporation of a virtual assistant - Automated responses to product information queries - Ideal Skills and Experience: - Proficiency in cross-platform mobile app development - Experience with integrating virtual assistants in mobile apps - Solid understanding of automated response systems - Knowledge about product information query handling systems

I'm looking for an experienced Excel professional to create a comprehensive spreadsheet for tracking my stock trading activities. This spreadsheet needs to be efficient and effective, capturing all relevant data points. Key Requirements: - Proficiency in Microsoft Excel (preferably with experience in creating financial spreadsheets). - Ability to efficiently track and calculate critical metrics such as purchase dates, sale dates, and profit percentages. The ideal candidate will have a keen understanding of stock trading and can translate this into an effective tracking tool.

I need an expert to help me organize my Excel file containing employee attendance data. Key Requirements: - Setting up filters for my analysis on employee attendance - Creating specific filters for different aspects of the data - Ensuring the file is user-friendly and easy to navigate Data Types: - Employee attendance data which includes number of days off, late comers, and early leave. Ideal Skills: - Advanced Excel proficiency - Experience in data organization and analysis - Attention to detail - Ability to create user-friendly spreadsheets

...environments. Monitoring Requirements Host-Level Metrics Ping and availability CPU usage (load averages, per-core utilization) Memory usage (RAM, swap) Disk activity (IOPS, free space, read/write operations) Network traffic (bandwidth usage, errors, dropped packets) Service uptime Service-Level Metrics Web services (HTTP/HTTPS status, performance, visitor statistics) Database performance (MySQL/MariaDB with query statistics) Mail servers (queues, processed/deferred emails, etc.) DNS server health FTP server status cPanel/DirectAdmin-specific service metrics Backup monitoring (jetbackup) Website monitoring Security and Logs User login activity Firewall rule statistics System and error log monitoring Mail log monitoring Apache log analysis Deliverables A fully configure...

I need to delete multiple rows within a Word table. I have an Excel showing which rows should be deleted. Afterwards, some page breaks and formatting work might be needed. Skills needed: - Proficiency in Microsoft Word - Attention to detail I have two print screens attached. The word document has 102 pages with 675 rows. 326 rows need to be deleted. All work in the word document needs to be done twice: There is an English version of the document, and a German version.

I'm looking for a freelancer who can help me scrape text content from a specific website and deliver it in an Excel spreadsheet. Ideal Skills and Experience: - Proficiency in web scraping tools and techniques - Experience with data organization in Excel - Attention to detail to ensure all relevant text content is captured Please note, the specific sections of the website to be scraped have not yet been determined, so flexibility and adaptability will be key.

Objective: Develop a simple PHP-based application that automates the assignment of daily delivery jobs to staff members (drivers) while optimizing routes and adhering to delivery time sl... view job assignments, and track progress. Reports and Export: Generate daily reports detailing job assignments and routes for each driver. Option to export job assignment data for record-keeping. Technologies to Be Used: Backend: PHP (Laravel or CodeIgniter framework recommended for scalability and maintainability). Frontend: HTML, CSS, JavaScript (Bootstrap for responsive design). Database: MySQL for storing driver data, customer data, and assignments. API Integration: Google Maps API for geocoding and route optimization. File Handling: Support for .xls file parsing (using libraries like PhpSpr...

I'm...Keeping track of appointments and deadlines - Email and communication management: Handling correspondence in a professional manner - Research and data entry: Conducting basic research and inputting data as needed - Performing marketing tasks such as SEO work - Performing customer service Essential Skills: - Proficiency in Microsoft Office Suite: Basic level is sufficient, but familiarity with Word, Excel, and PowerPoint is necessary - Good communication skills: Able to handle correspondence professionally - Basic research skills: Capable of conducting simple research tasks Ideal Candidate: - Previous experience as a Personal Assistant or in a similar role is preferred - Familiarity with basic research techniques and data entry tasks - Good organizational skills and atte...

...Data Entry Specialist to assist with organizing and entering new contacts into an Excel format. The ideal candidate will have excellent typing skills, a keen eye for detail, and the ability to deliver high-quality work within specified deadlines. Project Details: Scope of Work: Cognito will provide a list of companies. Using this list, the specialist will research and identify relevant Marketing and Media & Communications contacts in the US, UK, Netherlands, Germany, Hong Kong, Singapore and Australia, including their job titles (and email if available). Requirements: o Proven experience in data entry or similar roles. o Ability to conduct accurate online research to source contact details. o Proficiency in Excel and/or Google Sheets. o Tools knowledge such as Linke...

Please Sign Up or Login to see details.

I'm seeking a proficient trader to manage my prop account with Sure Leverage, initially funded by $50k. - Commission: I offer a 30% commission on net earnings every month. - Trading Strategy: The preferred strategy for this account is Day Trading. - Instruments: The focus will solely be on Forex. - Risk Level: The trading strategy should maintain a Medium risk level. Your role will be to respect the rules of the prop firm while ensuring consistency in our trading endeavors. The ideal candidate should have a proven track record in day trading Forex, with the ability to balance profitability and risk.

I need a Tally coder who can automate data entry from various sources into Tally in real-time. Key tasks include: - Automating data entry from Excel spreadsheets, a Database, and Manual entries into Tally. - Ensuring that the data is updated in real-time. Ideal skills and experience: - Proven experience with Tally and data automation. - Proficiency in working with Excel spreadsheets and databases. - Ability to manage and automate manual data entries. - Excellent attention to detail and commitment to accuracy.

Please Sign Up or Login to see details.

I'm seeking a developer with the full OEM version of Armchart. The primary goal is to visualize data and generate PDF reports from it using ...to visualize data and generate PDF reports from it using Armchart. Prerequisites: - Must have possession of the full OEM version available for redistribution to 3rd party websites Key Responsibilities: - Demo to pro upgrade with armchart. - Utilize Armchart to visualize data from a MySQL database and generate PDFs. - Implement effective data visualization techniques to present data clearly and concisely. Ideal Skills: - Proficiency in Armchart with the full OEM version. - Strong experience working with MySQL databases. - Excellent skills in data visualization and creating PDF reports. Please apply if you possess the necessary ...

I'm looking for an expert with advanced Excel skills to help me set up and manage an inventory system using Excel. Key Responsibilities: - Design an Excel-based inventory management system - Analyze customer data within this system - Integrate Excel with external databases Ideal Skills: - Proficient in Excel, particularly in its advanced functionalities - Experience in setting up inventory management systems - Strong data analysis skills - Familiarity with customer data analysis The inventory system will manage a small to medium-sized inventory.