Excel inventory control macros jobs

Please Sign Up or Login to see details.

I'm looking for a skilled Excel expert who can help with adjusting product pricing, adding products, creating formulas, adding products etc via excel, .csv. This is a ongoing project. If you can upload .csv to wordpress is a big plus!! KEY REQUIREMENTS: - I specifically need assistance with spreadsheet automation. - The work required is at a basic level, focusing on formulas and functions. - Implement automation for the designated tasks. - Ensure that the automation is robust and well-documented. SKILLS & EXPERIENCE: - Proficiency in Excel is a must. - Experience in basic spreadsheet automation. - Strong understanding of formulas and functions. - Attention to detail and commitment to quality.

I'm looking to develop an Artificial Intelligence (AI) charges calculator for Excel. The core functionalities include: - Automatic calculation of fixed charges - User-friendly interface for effortless interaction and data management. - Reliable data input validation to ensure accuracy and consistency. - Calculate Profit based on fixed charges and earning from subscription The calculator will primarily handle financial data. Prospective freelancers should have a strong grip on Excel, data validation, and UI/UX design—along with financial acumen for effective calculator development. A successful execution ideally enhances efficiency and aids with precise financial management.

...with a data analysis project. The project includes a variety of tasks such as Index Development and Justification, Data Selection, data cleaning, Multivariate Analysis, Normalisation, Weighting and Aggregation, Link to Other Indicators, Visualisation of Results, and Version Control. Skills/experience required: - Proficiency in data analysis techniques - Experience with data cleaning and normalization - Strong knowledge of multivariate analysis - Ability to create visual representations of data - Experience in version control of analytical work The specific data you'll be working with is open to your choice. Your expertise in selecting, cleaning, and analyzing the data will play a key role in the successful completion of this project. Needed strong knowledge of pytho...

I'm in need of a meticulous and reliable freelancer to assist with online data entry tasks. You'll be required to input data into spreadsheets using platforms like Excel or Google Sheets. The data will be provided to you in digital formats, such as PDFs, Word documents, or scanned images. Key Requirements: - Proficiency in online data entry - Experience working with spreadsheets (Excel, Google Sheets) - Ability to maintain accuracy and attention to detail - Familiarity with handling data in digital formats Ideal Skills: - Previous experience with similar data entry projects - Proficiency in using Excel or Google Sheets - Background in spreadsheet management - Strong attention to detail and accuracy A successful candidate will be someone who can ensure da...

I would like a custom sales order created in Excel for about 50 different items. Key Requirements: - Each item's entry in the order should include item name, quantity, and description. - The items should be sorted by their ship date. - The system should incorporate a feature to apply a total discount on the order. Ideal Skills and Experience: - Advanced Excel Skills with the ability to create customized sales orders - Proven experience in developing financial/ordering spreadsheets - Excellent understanding of sales order process and discount mechanisms.

Ease and flexibility of use by the site administration.    - A comprehensive control panel for dynamic content management.    - Multiple authority levels (manager, editor, publisher, etc.).    - An easy and integrated system for managing multimedia (images, video, etc.).    - Flexible tools for publishers enabling review and scheduling.    - Compatibility with C3W standards for cross-browser functionality.    - Possibility of future development without impacting existing content.    - An excellent, search engine-friendly system for periodic archiving of content (SEO).    - Multilingual support (Arabic - English).    - Design meeting standards for speed and ease of browsing.   &nb...

I'm experiencing multiple glitches in my inventory application developed in React Native. It facilitates both iOS and Android systems. The two primary issues I'm struggling with are: - Wrong data displaying: The app is often displaying incorrect data which is inconsistent and doesn't match with the original entries. - Error during item management: I encounter an error when adding or removing items from the inventory. I'm hoping to find a freelance developer with a hands-on experience in React Native, who can identify and fix these issues promptly. A good understanding of data validation and inventory management systems would be a real bonus. This job requires strong problem-solving skills and a keen attention to detail to troubleshoot and resolv...

I'm looking for an experienced PostgreSQL professional capable of analyzing and generating reports from sales data. Key Responsibilities: -Analyzing sales data stored in PostgreSQL -Generating insightful reports based on analysis Ideal candidate should excel in PostgreSQL and possess strong data analysis skills. Previous experience with sales data is an advantage, however, specific functionalities required for the analysis have been left open-ended for your expertise to fill. Please outline in your proposal any relevant experience and your approach to this task.

I need an experienced Shopify app developer to create a specialized app for me. This app should have the following functionalities: 1. Select the Order Date and tim...Postgres - Javascript, HTML, CSS, Jquery A critical feature I require is the ability to gather specific information with each order. This should include: - The ability to select an order date via a calendar date picker. - Collect and record this order date. Ideal candidates for this project should be experienced in the development of Shopify apps, with a particular emphasis on order and inventory management functionalities. A strong understanding of transactional systems and marketing tools within the Shopify environment will be highly valuable. Please be ready to showcase past projects pertinent to these req...

If C4 and D4 have no entries, make E4 blank. If C4 and D4 have values, perform C4/D4 in E4.

We are in need of a Point of Sale (POS) software that's compatible with both iOS and Android platforms. Key Features Required: - Inventory Tracking: The software should efficiently track every piece of inventory and maintain records in real time. - Customer Management: It should have features to manage customer information effectively and to capture their buying trends. - Receipt Printing: The software needs the capability to print receipts after every transaction. - Kitchen Display/Printer: A feature that allows displaying orders in the kitchen and initiate printing commands accordingly would be highly beneficial. Freelancers with relevant experience in POS software development are particularly encouraged to apply. Please include a detailed description of your ex...

I need an expert in data formatting to help me clean and organize a large Excel file. The file currently contains unformatted data that needs to be segmented into distinct columns. I need the data separated into the following categories: - First Name - Last Name - Company Name - Position The ideal candidate for this job should have: - Proficiency in working with large Excel files - Experience in data segregation and formatting - Attention to detail to ensure data accuracy - Ability to follow instructions and deliver in an Excel file format Given that there are more than 500 entries in the file, efficiency and accuracy are key. The final deliverable should be an Excel file with the formatted data ready for use. If you have read till and reviewed the file, wr...

...Different Forms: Create user-specific forms for event entry. Commercial users' forms will include membership management and payment functionalities. Google Maps API Integration: Utilize Google Maps JavaScript API to overlay event data on a map, employing custom markers and interactive elements. Backend and Security: Set up a secure server environment with robust authentication and role-based access control. Implement secure payment processing for commercial users. Responsive Design: Ensure the application is fully responsive and functional across all devices and platforms. Skills Required: Proficiency in HTML, CSS, JavaScript, and frameworks like React or Angular. Experience with backend technologies such as Node.js, Python (Django or Flask), or PHP. Strong knowledge of Goo...

I need a professional who can deliver a top-notch DMAIC Word report within 2 weeks. I need help with all the phases of the DMAIC process - Define, Measure, Analyze, Improve, and Control. The report needs to be meticulously detailed, accurate, and insightful throughout all the stages. The deadline for this project is within 2 weeks, but ideally, I would like it to be completed as soon as possible within the 2 weeks. Ideal skills and experience for this job: - Proficiency in Lean Six Sigma methodologies, particularly DMAIC - Exceptional report writing skills - Ability to deliver high-quality work within tight deadlines - Extensive experience in writing technical reports or process improvement reports - Strong analytical and problem-solving skills - Good communication and ability...

I require an expert to upgrade the parental controls across all my devices - Smartphones, Tablets, and Computers. The goal is to gain more control over the digital activity within my home, including the following tasks: - Setting restrictions on usage of Social media apps and Gaming apps specifically. - Implementing a system that allows me to receive Push notifications detailing app usage. - Ideally, it would be an added benefit if I could monitor the various social media platforms being accessed and accounts developed. The ideal candidate should be tech-savvy with a strong background on setting up parental controls on various devices and proficient in different notification methods. Please provide examples of similar work you've done before if applicable. Your experience i...

I'm seeking an expert who can assist with developing a comprehensive data analysis and automation solution within SMART sheet and Excel. Key Responsibilities: - Develop custom dashboards for financial analysis within Excel. - Automate data management processes within both SMART sheet and Excel. - Integrate the dashboards into SMART sheet for seamless use. Ideal Skills & Experience: - Strong expertise in SMART sheet and Excel, including VBA. - Proven track record of developing dashboards for financial analysis. - Ability to automate data management processes. - Excellent communication skills. Please provide examples of similar projects you've completed.

I need to scrape specific information from a website for all search results with a particular key. The data should include Name, Address, Phone number, Email, Company name, and Job title. This data should be organized into an Excel file, with each category of information in separate columns. Ideal Skills: - Proficient in Excel VBA - Experience in web scraping - Understanding of VPN usage to access region restricted sites Please note that the website will only work with a USA VPN.

I am looking for a professional lead generation expert with experience in the real estate industry who can help me to collect real estate l...a professional lead generation expert with experience in the real estate industry who can help me to collect real estate leads within the Greater Toronto Area. In this role, you'll be responsible for collecting leads of FSBO (For Sale by Owner), expired listings, and "Rent by Owners." I need - Collection of leads' name and contact information and collection of property address and specifics in excel sheet. The ideal candidate for this role should have: - Proven experience in real estate lead generation - Strong understanding of the real estate industry and the different types of leads within it - The ability to work indepe...

I seek a skilled technical writer well-versed in crafting policies and procedures relevant to business operations. Thou...policies and procedures relevant to business operations. Though specifics were not provided, an adept writer with the ability to understand various business processes and develop clear, understandable policies and guidelines is required. Key Requisites: - Proven experience as a technical writer in business setting - Ability to develop content for employee handbooks, safety protocols, and quality control guidelines - Innate understanding of business operations - Excellent command of English language and grammar Please ensure that your proposal showcases your past experiences in drafting business policies & procedures. Mock-ups or samples would be ideal for ...

I am looking for a professional who can create an Excel sheet that will help me manage my product list and other essential production data. The excel file requires: - Filtering and Sorting Capabilities: The sheet should be able to sort and filter data easily. - Inventory Tracking: It is crucial that the sheet can track inventory levels to prevent overstocking or shortages. - Report Generation: The ability to generate reports will help me keep track of my production and make informed decisions. I need the excel file to have less than 10 columns, as I believe this will keep the sheet concise and easy to manage. The level of automation I am looking for is manual data entry with some formulas. This will help reduce manual work and ensure the data input is ac...

webscraping cdiscount using python and export it into excel

Looking for someone to help lay out a very basic WordPress site for eCommerce on Bluehost. I've already started on the site and have enjoyed learning WP but simply don't have the time to finish it. Mos...enjoyed learning WP but simply don't have the time to finish it. Most of these items should be simple for someone with existing WP experience. Deliverables: • Clean up layout of the site • Add "Blog" section for product reviews • Shipping Calculations ○ Based on Item… some will be fixed shipping • Confirm cart is configured correctly to use my card processor (ePN) • Automatically update Inventory quantities via FTP file • Allow Discount Codes by User to Show Alternate Prices Please read through the descript...

Hi Remi A., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I am looking for a professional lead generation expert with experience in the real estate industry who can help me to collect real estate l...a professional lead generation expert with experience in the real estate industry who can help me to collect real estate leads within the Greater Toronto Area. In this role, you'll be responsible for collecting leads of FSBO (For Sale by Owner), expired listings, and "Rent by Owners." I need - Collection of leads' name and contact information and collection of property address and specifics in excel sheet. The ideal candidate for this role should have: - Proven experience in real estate lead generation - Strong understanding of the real estate industry and the different types of leads within it - The ability to work indepe...

Do you understand instructions when given and can do tasks on excel? Are you a beginner? Are you free right now to work with me and read the data in pdf so I can write it on excel? If your answer if yes to all of that question bid by asking any question regarding this post to make your bid high quality. NEEDS TO BE DONE TODAY. WILL TAKE 3-4 HOURS APPROXIMATELY. (just an approximation)

I'm seeking a skilled and experienced developer to craft a Windows-based functional business software. Key elements required include: - Proficiency in creating commercial use software - Experience in developing software with inventory management capabilities - Knowledge in building software that optimizes stone cutting The goal is to streamline operations and foster efficiency in inventory management and stone cutting procedures. Please bid with a step-by-step development plan and timeline, demonstrating understanding of the project specifics and requirements.

I am seeking an experienced app developer to create an app...iOS platforms. The app should handle these differences seamlessly and ensure proper functionality across both operating systems. 3- Efficient Functionality: The app should have just two buttons: one to enable the "Do Not Disturb" mode and silence alarms simultaneously, and another to revert all settings back to their original state. These buttons should provide users with quick and convenient control over their device's settings. 4- Reliability and Stability: The app must be stable and reliable, ensuring consistent performance across various device models and operating system versions. Ideal Candidate: - Prior experience in developing Android and iOS applications. - Proficient in permission management and...

I'm in need of an Excel expert to help me with intermediate-level spreadsheet formatting. The tasks include moving data from sheet to another sheet Ideal Skills and Experience: - Proficiency in Excel

...distribution pattern to default or user-defined settings. Efficient Parallel Processing: The bot is designed to handle a high volume of incoming requests simultaneously. It efficiently distributes carts among destination webhooks to prevent bottlenecks and ensure timely processing. User Interface (UI): Develop a user-friendly web interface using Flask or another suitable framework to provide easy control over settings. The UI will allow you to: Add or remove destination webhooks. Edit the address of the main webhook receiving the carts. Modify the round-robin logic for cart distribution among destination webhooks. Reset settings, including restarting the round-robin cycle and resetting distribution patterns. This UI will provide a convenient way for you to manage the bot'...

I want to use Microsoft power automate for a simple RPA on my desktop browser. I want to repeatedly run a search on 6 websites which are ...extracted from individual PDF documents by going into each individual case docket and opening a certain document called a summons, which will have the defendant's address usually in the middle of the page, but always on the first page of the summons. Some of the summons are not PDF readable so I will need OCR functionality. Finally, when the data points are extracted, they can be exported into an excel file for mail merge and printing (that the easy part). The objective is to create about 7,000 individual mailings each month and to run the automation about twice per week. I need help finding the right OCR tools to work with power automate. ...

I'm looking to set up a Shopify store specifically for selling physical products. The e-commerce...smooth navigation and an optimal user experience. - Product Listing: Skilful integration of product listings. Experience with physical product representation would be an asset. - Customization: Ability to customise the shop as per the brand aesthetics and products. - No specific 'crucial features' have been listed, but a well-rounded store with all standard features including but not limited to inventory management, integrated payment gateway, and a customer reviews section is expected. Preferably, candidate should have previous experience in building Shopify stores for physical products. Understanding of retail business and ecommerce as a whole really beneficial to ...

I'm seeking a proficient Shopify designer to craft an engaging, customer-friendly online store that will be vending physical products. Skillset Needed: * Proficiency in Shopify platform * Experience in online store...customer-friendly online store that will be vending physical products. Skillset Needed: * Proficiency in Shopify platform * Experience in online store design * Familiarity with creating product categories Project Scope: * Develop a comprehensive Shopify online store * The store will be primarily selling physical products * Implement 4-6 product categories to neatly organize our product inventory The ideal candidate for this job will have a portfolio demonstrating prior experience in Shopify online store design, particularly stores with a multitude of prod...

I'm in need of a skilled web developer who can...Page with Responsiveness in React and Tailwind**: - **React and Tailwind Expertise**: The student page is a critical component of this project. It needs to be meticulously crafted using React and Tailwind, hence your proficiency in these tools is a necessity. - **Admin View Only**: The student page is specifically designed for admin use, meaning it must provide a high-level overview and control of the system. The ideal candidate should have a strong portfolio of web development projects, particularly those involving e-commerce, user registration systems, and admin-specific pages. Proficiency in React and Tailwind is a must. Your ability to deliver a clean, responsive, and user-friendly UI will be crucial to the success o...

As an innovator in the dye industry, I'm in search of a professional with a background in dye formulation, quality control, and color matching. Your role would primarily involve the development of specialized dye products. Here's what is expected: - Formulation and improvement of dye mixtures. - Implementation of quality control mechanisms. - Precise color matching to ensure product consistency and quality. - Development of specialized dye products in line with my innovative vision. Ideal candidates will have a strong history in the dye industry and a proven track record in product development. Your experience in dye formulation, quality control, and color matching will be critical to our success. I look forward to creating groundbreaking products to...

At present, we manage all our revenues and expenditures through multiple bank accounts. For different types of expenses, we use different cards - for instance, the card ending in 1234 is used for fixed expenses, while the card ending in 0123 is for non-fixed expenditures. All our receipts are sent to Receipt-Bank, which is synced with XERO. - reconcile bank accounts each month - setup inventory management - loan interest - P/L statments - Setup up reconciliation rules Must be finished by 10th of each month Approx 300-400 receipt/bank statement rows need reconciling each month. In XERO, every transaction must be matched with a receipt from Receipt-Bank or reconciled from a bank statement row.

...license keys for an Excel template product. Key responsibilities are: * Design and develop a License Key Generator using Python. * Create it to have the flexibility of generating unique license keys, verifying these keys, and, if necessary, deactivating them. * Design and implement an API that allows the integration of generated license keys with my existing Excel templates. * Each license key must validate properly in Excel Template PRO. Besides, your work must include: * Order form * Implementing a MySQL database to store all generated license keys. * Building a response system that displays license keys on a 'Thank You' page after purchase. * Setting up an automated email system that sends emails to the customers with their unique license key and a d...

for business for data control

We are in need of a highly skilled Laravel expert team to continue development on existing ...- Extensive experience in Laravel development - Proficiency in Laravel customization and optimization - Strong understanding of Gitlab - version control !* - Strong understanding of web development principles and best practices - Ability to work on a large-scale project and deliver high-quality results - Excellent problem-solving skills and attention to detail - Database Design & Management: The ability to design and manage a highly organized, efficient database is crucial. Skills that would be beneficial: - Thorough Laravel expertise - Proven track record in creating reporting and analytics solutions !!!*** - Understanding of Git version control - Proven track record in creatin...

I'm looking for an Excel file that contains a list of companies in Dubai, specifically from the Technology and Hospitality industries. The file should include the following information for each company: - Company name - Address - Phone number - Category of business Key requirements: - Data should be accurate and up-to-date - Companies must fall into the Technology or Hospitality industry

...guidance in the architecture and design of software built on the Unity platform. - Collaborate with the engineering team to integrate advanced image processing algorithms seamlessly with Unity. - Establish and maintain best practices for Unity development and version control within a shared workspace. - Optimize performance and memory usage of Unity applications dealing with large-scale data processing. - Train and mentor team members on Unity-specific skills and practices. - Manage code repositories, ensuring robust version control and efficient collaboration across teams. - Troubleshoot and resolve any Unity-related issues that affect project timelines or performance. Qualifications: - Proven experience (5+ years) in Unity development, with a strong portfolio of project...

I am in need of an experienced freelancer who can assist in data analysis and Excel formula troubleshooting. Key Tasks: - Perform qualitative textual analysis on both textual and numeric data - Spot inconsistencies, errors and trends in the data - Troubleshoot any issues with Excel formulas and functions Ideal Skills and Experience: - Proficient in using Excel for data analysis - Exceptional skills in data interpretation and reporting - Strong problem-solving skills, specifically for Excel formulas and functions troubleshooting - Proven expertise in qualitative textual analysis.

...can assist me with various tasks in Microsoft Excel and content writing. The ideal candidate should be proficient in Python and C programming languages. In Excel, I require help with: - Data entry and organization: Assisting me in organizing existing data and entering new data into specific format. - Formulas and calculations: Creating formulas and performing calculations on the data. - Power point: Making power point presentation. - Programming: Automating specific tasks using Python and C programming. In terms of content writing, I need support with: - Copy paste: Help me in copy paste some data. - Story: Writing a story. - Resume: Writing a professional resume. The ideal candidate for this project should have a good understanding of Excel and programming, p...

I'm looking for an expert in Excel who can assist me with data analysis and spreadsheet design. The main objective of this project is to create compelling data visualizations. Key Tasks: - Analytical reviewing and summarizing of data - Design of clear and comprehensive Excel spreadsheets Objective: - Creating simple charts and bar graphs for data visualization The ideal freelancer for this project should exhibit solid skills and previous experience with data insights extraction, spreadsheet design, and data formatting. Familiarity with basic data visualizations such as charts and bar graphs is essential.

Work in the audio-video editing department; Creation and processing of sound effects for YouTube videos; Creation of musical accompaniment suitable for the plots; Quality control and volume level of sound effects and music; Participating in discussions and expressing expert opinions out loud. Requirements: Knowledge of modern audio editors; Theoretical knowledge of working with sound; Outstanding sense of rhythm, hearing and humor to create interesting, realistic and funny sounds; Ability to work in the office and remotely; Good communication skills in English; Experience as a sound engineer/designer is preferred; Readiness of the selection task. We offer: Flexible work schedule; Remote work from anywhere in the world; Wages, fair judicial assessment based on the amount of work pe...

...professional with experience in developing a Mitsubishi PLC program. The program is intended to control equipment using PID (Proportional, Integral, Derivative) control system. It should be able to handle both analog and digital input/output signals. Key requirements include: - Developing a Mitsubishi PLC program for PID control - Integrating both analog and digital input/output signals into the PLC program - Ensuring the program is efficient and effective in controlling the equipment The ideal candidate should have: - Proven experience in developing Mitsubishi PLC programs - Expertise in PID control system - Previous work with both analog and digital signals - Ability to deliver efficient and effective control systems I have a small test job that n...

I'm looking to develop a comprehensive helmet and mask detection system using Raspberry Pi and OpenCV. The system should be able to identify individuals not wearing helmets or masks within a short range, specifically 1-5 meters. Key ...should be able to identify individuals not wearing helmets or masks within a short range, specifically 1-5 meters. Key Requirements: - The system should be able to detect both helmet and mask violations. - I need the system to send an alert to a control center whenever a violation occurs. Ideal Skills and Experience: - Proven experience with Raspberry Pi and OpenCV. - Strong background in computer vision and image processing. - Experience with developing real-time detection systems. - Familiarity with integrating a system to send alerts to a ...

I'm in need of a professional to assist with the integration of Shopify and Zoho Inventory/Books. I have an inventory of approximately 30 active products. I believe all of the data is correct such as the SKU numbering etc. I have already made an attempt to synchronise the two applications but I did not manage. I want the integration to be made with the in built facility that Zoho provides. I do not want to use Zoho Flow or another similar application to achieve this. When the synchronisation is complete. We need to run some tests to make sure that every product and every order that is made on my Shopify website is working correctly. It will likely be a good idea that we sync a one product order as a test. I need to be very well advised if we need to make any change...

...advanced order planning & costing mechanism specifically for our production unit. The system should be based on Excel and leverage the power of scripts and macros. - Certain features are a must-have: inventory management, production scheduling, cost optimization, and sales order management. - Following this, the mechanism will then be utilized to create a management dashboard on PowerBI. Core KPIs to be highlighted on the dashboard include production efficiency, inventory turnover rate, cost per unit produced. In addition, it should also provide a detailed overview of sales and profitability. The perfect candidate for this project should boast significant experience in data analysis, Excel automation methods, as well as PowerBI or similar data ...

...and electronics designed and I can make the housing and everything else. If you would also want to design the housing in ok with that. Needs to be almost waterproof. Mainly splash proof and heat resistant. It will be mounted in the engine bay. As far as the controller goes all it need to be able to do is check pressure from a pressure sensor that will be connected in line from the compressor and control a 12v output source(5a at 12v) to trigger the compressor to turn on as well as for deflating need a valve to be controlled to air down to set pressure. Looking for keep it as simple as possible. Only gonna need about 4 buttons. Maybe more if we add some other functions. Best bet is to call and discuss this as there are a couple other versions of this I would like to make as well a...