Excel inventory template with formulas xls jobs

I'm looking for someone with strong data gathering skills who can create a comprehensive Excel spreadsheet. The spreadsheet must contain a list of all Australian suburbs along with their corresponding Local Government Areas (LGA). The essential points to be kept in mind are: • The list should be sorted by council areas for easy navigation. • Only the name of the suburbs and their corresponding council areas are required. No additional components such as population or region data are necessary. This project might require advanced web searching capabilities and attention to detail to ensure accuracy of the compiled list. Experience in data extraction is highly desirable.

I need someone who can create a database in MS Excel for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List). 2- A list of all Contracts. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. There should be a Dashboard (Main Page) with link to the pages (Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages) on the top, and below the page list there should be the statistical data of the database. For Add New Invoice page, I should be able to add an invoice details, and if it's related to a contract or purchase order, I s...

I'm in need of someone skilled in Microsoft Excel for a couple of tasks. - **Formatting:** Firstly, I require assistance in formatting the spreadsheet. This will include ensuring that the data is clear and easy to read. I would like the spreadsheet to look professional. - **Formula checking:** While the formulas used are not too complex, I still want them to be checked thoroughly for accuracy and consistency. This will mainly involve basic arithmetic operations. I'd appreciate it if you have a background in financial analysis. It would be helpful to have a good eye for detail as well.

Create Blazor Fluent UI template sample pages with login and account profile page

...the ability to visualize the restaurant's floor layout to manage the orders efficiently. - Table Management: The UI must allow for table reservations, status updates, and merging. It should help in optimizing table assignments and order efficiency. - Inventory Management: The UI should support managing the restaurant's inventory to streamline operations and track costs. - Staff Management: I need a simple way to manage staff - from assigning tables, tracking orders, and ensuring smooth service. Ideal Candidate: - Proficient in UI/UX design with a strong portfolio of similar projects. - Experience in restaurant POS systems or similar applications is highly preferred. - Excellent communication skills for understanding and implementing my specific requiremen...

...competitively - Write detailed product descriptions that are informative and persuasive Ideal Candidate: - Prior experience with creating listings on both Mercari and Facebook Marketplace - A keen eye for detail and high-quality standards - Excellent copywriting skills to craft compelling product descriptions - Knowledge of pricing strategies on e-commerce platforms - Ability to work efficiently and independently If you're someone with a passion for e-commerce and a knack for selling, I'd love to have you on board! I use Vendoo for these listings. I have 1000s of listings and will be adding more. This can be an ongoing relationship. The listings are loaded in Inventory. All that has to be done is the form filled out and that's it. This sentence ne...

I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample

I am in need of an Instagram template specifically for my business. It will serve as a pivotal tool in promoting my products. Key Details: - **Intended Use:** This template is exclusively for product promotions, therefore should be designed to catch the eye and engage my audience. - **Color Scheme:** Bright and bold colors are a must, to ensure my posts stand out and create a strong visual impact. Desired Skills: - **Graphic Design:** Professional with experience in creating visually appealing and eye-catching designs for Instagram. - **Marketing:** Understanding of how to design for product promotions and what engages audiences. - **Branding:** Ability to incorporate my business brand in the design. I'm looking for a freelancer with a creative and keen...

I require an experienced and proficient VBA developer to create a code that automates data entry tasks in Microsoft Excel. The main objective is to significantly increase productivity and ensure accuracy by automating repetitive data entry procedures. Ideal skills would include: - Vast knowledge of VBA and Excel - Prior experience in developing automation scripts - Exceptional attention to detail - Ability to work within strict deadlines

...quote template that can be used for generating sales quotes. This template should include visual multimedia elements to enhance the customer's experience and understanding of the products: - The template should feature product images placed beside each product description. This visual representation should help customers easily identify the products they are interested in and add a visual appeal to the quote. - Additionally, I would like each product to be linked to a product demonstration video. These videos will serve as a form of visual documentation to showcase the usefulness and features of the products. Ideal applicants for this project would have: - Proficiency in Hubspot, and experience in creating quote templates within the software. This project i...

I'm in need of a seasoned Excel expert who's proficient at conducting optimization analysis to solve a real-world problem. Key Requirements: - Profound understanding of optimization analysis - Ability to work efficiently and quickly - Experience with diverse Excel functions Please note that the specific goal of the optimization analysis requires maximizing profits, minimizing costs, or optimizing resource allocation. Your expertise in this area will be crucial to our success.

...dashboard for an existing POS and inventory management system that consolidates sales and collection reports, provides inventory management, and includes customer data analysis. The dashboard should be accessible via web browsers and mobile devices. Key Features 1. Sales Reports o Daily Sales Report: Display daily sales data with graphical representation. o Monthly Sales Report: Display monthly sales data with graphs. o Annual Sales Report: Display yearly sales data with graphical representation. o Data Source: Multiple MS SQL databases. 2. Collection Reports o Daily Receipt Report: Display daily receipt data with graphs. o Monthly Receipt Report: Display monthly receipt data with graphs. o Annual Receipt Report: Disp...

I need an expert to convert tables from a PDF file into an Excel spreadsheet. The job involves transferring text and numbers from a multi-page PDF table to an Excel document. I have attached the PDF. The analysis should start from page 7. Here's what the project entails: - Converting data from a PDF table that includes both text and numbers - Handling tables that span across multiple pages in the PDF - Transferring the data to Excel without any need for specific formatting or layout changes - Provide the developed script used to obtain the records from the tables. As a freelancer, you should have: - Proficiency in PDF to Excel data conversion - Ability to work with complex table structures - Attention to detail to ensure accurate transfer of all in...

**Contest: Excel Specialist Wanted for Comprehensive Property Portfolio Management Tool!** Are you an Excel virtuoso with a passion for crafting intricate and comprehensive spreadsheets? We're embarking on a quest to develop the of a cutting-edge Property Portfolio & Financial position Management Tool for our discerning clients. If you possess the expertise to meticulously organize data, create advanced formulas, and design visually captivating presentations, this contest is tailored for you! Join us in revolutionizing property portfolio management with a document that sets the standard for clarity, accuracy, and usability. I would like to be able to edit if required in the future therefore 2 copies will be required. 1 being password and field p...

I'm looking to create a comprehensive web-based accounting software with essential features that will allow me to manage my finances, track inventory, generate GST reports, and handle billing. This software should also support up to 5 users. Key Features Needed: - Financial Management: The software should offer robust financial management functionalities to help me track and manage my finances effectively. - Inventory Management: A sophisticated inventory management system is required which involves product categorization, stock monitoring, and purchase order tracking. - GST Reporting: The software should have the capability to generate accurate GST reports in compliance with the relevant regulations. - Billing Features: I would require the software...

Create a Google Sheets system for managing alcohol inventory. Includes columns for Brand, Name, Number of bottles, Country, Rating. Dropdown for rating (1-10). Show stats: unique bottles, total bottles, countries. whit a front page where i can insert the above items, and get under a reading of stats.

I need a software expert to develop a pro...cross-references this data against another site. Key Requirements: - The software should effectively pull out text content from all provided sites. - The text content should be in a plain text format, ready for easy analysis and interpretation, preferably in an excel spreadsheet or comma delimited list. - The cross-referencing component is crucial, as the software will need to compare the data scraped with that of another website. Qualifications: - Background in Data Scraping and Software Development. - Previous experience with cross-referencing data. - Proficiency in handling different data formats. In essence, I'm looking for someone who can create a tool that not only collates data but also carries out comparison...

I am looking for a proficient email marketer to help me...in the area of sales conversion. - Proven track record of successfully increasing sales through email campaigns. - Strong understanding of potential customer behavior and how to target them effectively. - Excellent copywriting skills for creating compelling sales emails. - Proficiency in email marketing tools and analytics to track campaign performance. --- Product Details -- Point of Sale, Inventory and Customized Mobile Apps ---- These products will be available on subscription based licenses. --- My tag lines: 1. First 3 months free trial 2. Free Customizations 3. No payment until you are satisfied --- I am interested for commission based contract. You will convert the sales and we will have commiss...

I am looking for someone skilled in Microsoft Excel and Power Automate. This task involves creating an automation system that sends emails to our internal team members based on given triggers. The automation should trigger when: - An event's start date is approaching - An event's deadline is nearing The email content should serve as a reminder of the approaching start dates. It's pivotal that the chosen freelancer can work with accurate detail to ensure that no deadlines are missed. A deep understanding of Excel, or similar spreadsheet software, automation, and email systems is required for this task. Experience working with scheduling and deadline tracking will be an advantage.

I require an expert in Excel to help me with a statistical analysis of my sales data. The key tasks for this project are: - Conducting statistical analysis: I need you to run a detailed statistical analysis on my sales data. This will involve using advanced Excel functions to analyze variables such as sales trends, forecasts, and correlations. The ideal candidate for this project should have: - Proficiency in Excel: The chosen freelancer should have a deep understanding of Excel and be skilled in using advanced functions. - Statistical Analysis Expertise: Experience in statistical analysis is crucial, as you will be required to interpret the data and provide insights. - Attention to Detail: The work involves handling a large amount of data, so attenti...

looking for an expert in video analytics to help with a live stream volume calculation project for inventory management. Key Requirements: - Utilizing video analytics to calculate and track volume - Developing a system to process live streaming video feeds - Find volume of a dirt pile using multiple fixed cameras and any other needed sensors in .NET core C#. Examples of apps already built - URC Ventures Stockpile Reports Lite iPhone app; ; Use openly available camera appliances so we shall be independent of any specialty vendors. Please provide testing procedures and testing tools in simulated conditions. If some 3rd party tools are used, our pre-approval, source codes and unlimited licenses be included, meeting

My project entails two major Confluence-focused tasks. - Confluence Template Design: I’d require the design of more than two whiteboard on confluence - Content Migration: Additionally, I need to migrate our existing documents to Confluence. This task will include primarily documents with integrated multimedia elements, and thus necessitates a freelancer who can handle the complexities of these documents and ensure minimal losses during the transition process. Proficiency in Confluence and experience in high-level content migration are paramount for this project.

I'm in need of a skilled professional who can help me set up Caspio forms. I'd like these forms to be embedded into my website. Key points: - Precise skill in setting up Caspio forms. - Proficiency with embedding forms into websites. - Understanding of setting up formulas integration.

I require an expert Flutter developer to create a tailor-made billing app for my business. The main functionalities encompass invoicing, expense tracking, and inventory management. Key Requirements: - Development of an app using Flutter. - Design an easy-to-use interface for invoicing. - Develop expense tracking tools to monitor business costs. - Implement inventory management functions to help control stock levels. Ideal Skills and Experience: - Proficient in Flutter development. - Previous experience designing and developing billing apps. - Familiar with developing invoicing, expense tracking and inventory management features. - Portfolio showcasing previous applications developed.

I need to improve the existing features of an Excel macro, focusing on enhancing the user interface and experience. Key points: - The primary goal is to make the macro more user-friendly, interactive, and provide better feedback to users. Ideal skills: - Advanced Excel Skills - VBA and Macro Programming - Strong UI/UX design capabilities - User Feedback Integration Please bid if you have experience in enhancing Excel macros in a user-friendly manner and can improve the UI/UX by adding interactivity and feedback. I have a macro working fine. We need 3 improvements: 1- Label photos as A, B and C / 1, 2 and 3 then macro relabel photos per photo matrix 2- Instead to use “SN” in the folder name I want to use “setup” 3- 3- Generate report even i...

I'm seeking a savvy developer to create a 1D barcode (UPC, EAN) inventory management system. This should then be integrated with an existing product management system. Key requirements: - Design and develop a user-friendly barcode inventory control system - Experience with 1D barcodes, preferably UPC and EAN - Capability to integrate with existing product management software The main users of this system will be store staff members. Therefore, it should be easy to navigate, and seamless in functionality to support a fast-paced retail environment. Expected expertise: - Proven experience in building similar inventory management systems - Proficiency in working with 1D barcode technology - Expertise in software integration - Solid u...

...skilled freelancer who can help automate various tasks in Excel. This includes, but is not limited to, data entry, formulas, and calculations. Key responsibilities: - Automating data entry processes within Excel - Implementing advanced formulas and calculations to streamline calculations - Generating reports and carrying out data analysis using Excel - Ensuring the accuracy and integrity of automated processes Ideal skills and experience: - Proven experience in automating tasks in Excel - Advanced knowledge of Excel functions and formulas - Ability to understand complex data sets and create accurate reports In your application, I'd like to see: - Examples of similar projects you've worked on - Details of your experienc...

I am seeking an expert in data entry, particularly in the tasks of document conversion, data processing, and data verifi...necessitates the management of confidential and sensitive information, hence, a demonstrated respect and understanding for data privacy is paramount. Key Responsibilities: • Document conversion • Data processing • Data verification Required Skills and Experience: • Proficient with MS Excel • Demonstrated experience in similar roles handling sensitive data • Strong attention to detail • Respect for privacy and confidentiality Note: Familiarity and experience with utilizing formulas and pivot tables within Excel are highly desirable, given the nature of tasks to be performed. Integrity, diligence,...

I need assistance with copying & pasting data from spreadsheets. The dataset is less than 1,000 entries. Ideal skills and experience for this job: - Experience with data entry, especially from spreadsheets - Attention to detail - Proficiency in Excel - Ability to meet deadlines It's a straightforward task. The goal is to ensure the data is accurately copied and pasted.

I need an experienced Excel programmer to automate repetitive tasks and create custom VBA macros for my project. This assignment requires basic level tasks, so extensive experience in complex macros isn't necessary. Here is what I expect: - Automation of several repetitive tasks to streamline workflow and increase productivity - Creation of custom VBA macros from scratch Ideal Candidate: - Extensive experience with Excel automation and VBA macros - Ability to comprehend and successfully complete basic level assignments - High attention to detail and accuracy Please include your Excel automation and VBA macros experiences in your application. I look forward to working with you on this project.

I am in need of a professional and experienced developer to create an e-commerce website that enables online sales. Key Requirements: - Develop a user-friendly e-commer...professional and experienced developer to create an e-commerce website that enables online sales. Key Requirements: - Develop a user-friendly e-commerce platform on Wix - Implement product search/filtering functionality to help users navigate the site - Set up multiple payment options to facilitate seamless transactions - Integrate inventory management for efficient stock control The ideal candidate should have prior experience in e-commerce website development, particularly with Wix. Your understanding of e-commerce best practices and willingness to take my requirements into careful consideration will ...

I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample

I'm in need of a diligent and proa...diligent and proactive virtual assistant. Your main responsibilities will include daily calendar management and tracking tasks in Notion. Key Duties: - **Daily Calendar Management**: Keep my calendar up-to-date and organized. - **Task Tracking**: Use a provided Notion template to monitor my progress on tasks. - **Reminder Services**: Proactively send me reminders for upcoming events and deadlines. Ideal candidates should have: - **Experience as a Virtual Assistant**: Proven ability to handle similar tasks. - **Familiarity with Notion**: Ability to navigate and use templates in Notion efficiently. - **Strong Organizational Skills**: Capable of keeping my schedule in order. - **Excellent Communication Skills**: A proactive approach to...

I'm in need of a reliable data entry professional to input a mix of text, numeric,...numeric, and image data into a spreadsheet. The job involves inputting between 100 to 500 entries. Ideal Skills: - Proficiency in data entry with a strong attention to detail - Ability to handle different data formats (text, numeric, and images) - Experience in spreadsheet software, ideally with knowledge of conditional formatting and data validation. The data may need to be sorted and organized, so any experience or skills in data organization are a plus. It would be beneficial if you have a basic understanding of different types of data and their implications for the final use of the spreadsheet. Please be prepared to propose a basic template or format for the data entry if...

...enhance my website with a focus on lead generation. Your primary task will be to integrate efficient contact forms across strategic pages to facilitate visitor engagement and ultimately, lead generation. I need somebody who can work with Velo to create the following: I have a website that I would like to create dynamic pages for all locations in the UK. I need the original template setting up, instructions how to generate the pages automatically. I need to be able to change the recipient of the form data on each of the dynamic pages. Key Points: - Your expertise in Wix Velo is essential as this platform is the foundation for the project. - You'll be tasked with implementing contact forms in key locations. These forms should be intuitive and use...

I am looking for a software designer who can help me build a payment processing company similar to VISA INC, while ensuring that the company complies with all relevant laws and regulations in North America. Key Requirements: - I want the company to focus on payment processing. - The software must include a mobile-friendly design to cater to the increasing mobile transaction trend. - The payment gateway should be integrated into the system to provide a seamless, secure transaction experience. - An inventory management system is also crucial for our operations. Ideal Skills and Experience: - Proven experience in designing and developing payment processing systems. - In-depth knowledge and understanding of North American regulations and compliance requirements. - Strong backgr...

I'm seeking an experienced Excel wizard capable of making my inventory report more dynamic and adaptable. Here's what I need: - Total Calculations: The report doesn't currently update the total inventory count and monetary value when I adjust the count of individual items. I require this to be automated so the totals are accurately recalculated whenever an inventory count changes. - Regular Updates: Going forward, I will be regularly updating inventory counts on a weekly basis. I would appreciate if the system is simplistic and user-friendly for regular updates. Ideal Freelancer Skills: - Advanced knowledge of Excel functionalities - Experience on inventory management systems - Meticulous attention to detail - Ability to c...

I'm looking for a skilled engineer who can design a self-supported steel chimney for a metal manufacturing plant. This chimney will be integral to industrial emissions control. Tasks Include: - Tailoring the design to accommodate the specific needs of a metal-manufacturing environment. - Incorporating robust safety features and compliances for high-temp...manufacturing plant. This chimney will be integral to industrial emissions control. Tasks Include: - Tailoring the design to accommodate the specific needs of a metal-manufacturing environment. - Incorporating robust safety features and compliances for high-temperature metal emissions. Ideal skills: - Structural Engineering - Industrial Design - Knowledge of industrial emissions standards - Experience with metal manufactu...

...documents. The extracted data should be organized and saved into a customized Excel template. Additionally, the system should be designed to assign different user IDs with varying levels of access control. Key Requirements: - Develop an AI portal with the capability to extract table data from PDFs. - Organize and save the extracted data in Excel using customized templates based on the source PDF. - Implement a user management system that assigns different access controls to various user IDs. Ideal Skills and Experience: - Proficient in AI development and data extraction techniques. - Expertise in Excel automation and customization. - Strong background in user management and access control systems. - Previous experience with similar proj...

I'm seeking a professional to help me establish a reliable system for managing my personal inventory data. - You need to create a user-friendly database where I can keep track of my personal items, their quantities, and possibly other relevant details. - The system should be intuitive and straightforward to use, as I'm not a tech-savvy person. - Importantly, it should be secure, ensuring that my personal data is protected. Ideal candidate will have experience in database management, creating user-friendly interfaces, and a strong understanding of data security. Previous experience in inventory systems will be a big plus as well.

I'm in need of a unified system that can handle automated quotes, product management, and delivery for my websites on both BigCommerce and WooCommerce. Key Features: - Real-time inventory management - Customizable product options - Shipping cost calculator Ideal qualifications: - Proficient in eCommerce platforms BigCommerce and WooCommerce - Experience in building automated systems - Skilled in integrating different platforms - Expertise in inventory management - Knowledge in shipping cost calculations I have websites on both BigCommerce and WooCommerce and I would like a seamless, unified system to manage these aspects for both. If you have the skills and experience to help me, I'd love to hear from you.

...containing approx 50 questions each. For each question, I need someone to: - cut & paste an image of the question into a Google slides / Powerpoint document - 1 question (or sub-question if it requires a different skill per page - 1 document for each paper - name the skill(s) that are required to answer each question - as the title for each page - create a new line in a Google Sheets / Excel document with the following information: - skill required (copied from title of Google Slides document) - page number of Google Slides document that the question appears on Key Requirements: - The questions are from primary school level math exams, so a good understanding of these topics is crucial. - You will need to effectively categorize each question based on the ...

...a website on a weekly basis. The scraped data should be efficiently saved to a CSV or Excel file for easy review. Capable of being plugged to a distribution app. Key Requirements: - Develop a Python-based web scraper that targets a website to extract text data - The scraper should be designed to run on a weekly schedule - Ensure that the code is concise and easy to understand for potential future modifications - Store the scraped data in a CSV or Excel file format Skills and Experience: - Proficiency in Python programming - Experience with web scraping libraries such as BeautifulSoup or Scrapy - Understanding of scheduling tasks in Python - Familiarity with working with databases, especially CSV or Excel files I'm open to discuss furthe...

I'm looking for a proficient Excel professional to develop a multi-country income tax calculator. This tool will primarily serve individual taxpayers, and potentially other user groups. Key Requirements: The calculator should support income tax calculations for multiple countries. This requires a deep understanding of tax laws and calculations in each country. - The tool should be user-friendly and intuitive, catering to users with different levels of tax knowledge. - It should be well-structured, with separate sections for each country to avoid any confusion for the end-users. Ideal Skills and Experience: - Advanced Excel proficiency, with experience in creating complex calculators or financial models in Excel. - In-depth knowledge of...

I need an expert to develop a macro tailored to automating report production tasks in Microsoft Excel. The main purpose of this project is to streamline the process of regular report production and increase overall efficiency. Ideal skills and experience include: - Proficient in Microsoft Excel - Experience in macro development to automate tasks - Knowledge in automating report production Your role will involve designing and implementing a suitable macro for regular report production in Excel. I'm looking for someone who can provide a timely and efficient solution.

...well as other online platforms. Key Requirements: - Registering with Retail pharmacies, Wholesale pharmacies, Specialty pharmacies, online portals, online grocery selling stores, and departmental stores. - Listing and selling both prescription and over-the-counter (OTC) pharmaceutical products. - Expanding sales beyond online pharmacies to online portals, online grocery selling stores, and departmental stores. Ideal Skills and Experience: - Extensive experience in developing online businesses for pharmaceutical companies. - Proven track record of successfully registering and selling through various online pharmacies. - Knowledge of legal and regulatory requirements for selling pharmaceutical products online. - Familiarity with online retailing across different platforms....

I need a skilled developer to create a robust e-commerce w...secure, reliable, and user-friendly. - Scalability: The website should be designed to accommodate a growing product base. Although the exact number of products isn't defined, the website should be built with the potential for a large inventory. Ideal Skills and Experience: - Proven track record in building e-commerce websites, preferably with scalable features. - Strong experience in payment gateway integration, particularly with credit cards and cryptocurrencies. - Understanding of user experience and design principles to create a visually appealing and easy-to-navigate website. - Experience with scalable web development that can accommodate a growing product base seamlessly. Please inc...

I'm seeking a skilled virtual assistant with proven communication abilities, to work specifically in US timezone. Your main duties will include: - Bidding on projects: You will need to represent our brand professionally and persuasively when bidding on projects. - Communicating with leads: You'll be responsible for using various messaging platforms to engage with potential clients and leads. Ideal candidates should excel in written communication and have a knack for sales. Proficiency in project management tools is a plus. Our preferred mode of communication with leads is through messaging platforms.

Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.

The purpose of this report is to propose the system analysis for the client, with the intention of ensuring all stakeholders involved agree to the planned solution. Throughout the project the analysis, development, implementation and testing phases will be conducted using the industry standard, agile development life cycle. This specifies that changes can be made if required and appropriate. The system analysis report is intended for all the project’s major stakeholders: the client, the trainers, the costumers ,if they can be involved, and the development team.