Excel inventory project työt

*** PLEASE DO NOT ASK "WHAT IS YOUR BUDGET" YOUR BID AMOUNT SHOULD BE THE AMOUNT YOU INTEND TO DO ... PO Details to return a single row of data for each Invoice Detail record that matches the LATEST po line item within the same ITEM and SHIP TO CITY. The current SQL is generating duplicate records because it is matching against multiple PO details instead of the LATEST (newest) PO detail for that Item/Ship To City match. FILES INCLUDED: SQL File For Table/Data Query File for SELECT Statement Excel spreadsheet showing duplicate entries highlighted Key Tasks: - Correct SQL query to eliminate duplicate entries Seeking someone proficient in MySQL database design and query optimization. Previous experience with troubleshooting and resolving similar query issues would be a si...

I require a capable wardrobe assistant based in the Bristol area who'd take care of dressing and undressing less than ten mannequins and manage inventory using a physical logbook. The task necessitates attention to detail, a keen sense of fashion, and efficient record-keeping skills. Key responsibilities will include: - Dressing mannequins meticulously in accordance with visual merchandising strategies and working alongside with professional fashion stylist - Efficient management of inventory using a physical logbook, ensuring up-to-date records and accountability The ideal professional for the role is someone who's experienced in visual merchandising or a similar discipline, comfortable with manual record-keeping, and possesses a keen eye for style.

I'm in need of...up PowerBI and creating a dashboard for my business. Key Responsibilities: - Setting up PowerBI with a focus on data visualization - Integrating databases and Excel/CSV files as data sources - Creating a dashboard that presents Sales data, Website traffic and Product inventory in an easy to understand visual format Ideal Skills and Experience: - Extensive experience with PowerBI - Strong background in data visualization - Proficient in integrating databases and Excel/CSV files - Previous experience in creating comprehensive business intelligence dashboards - Ability to understand and visualize complex data sets This project is suitable for someone who enjoys working with data, has a keen eye for detail, and is able to create enga...

I have a project to hand over to someone well-versed in both Shopify and Amazon platforms. Your primary responsibility will be the list of selected products from our client's Shopify store to Amazon. Your tasks will include: - Gathering the necessary product details from Shopify, including names, descriptions, images, prices, inventory, and shipping information. - Completing the onboarding process for Amazon, including the required documentations. The perfect candidate for this job will be detail-oriented and able to understand and work within the nuances of both platforms seamlessly. Additionally, prior experience with Shopify and Amazon product listings is a must. I look forward to receiving your bids.

I am looking for a highly competent and experienced freelancer to develop an e-commerce website specialized in selling digital products. The platform should have the following features: - Capability for customers to leave reviews - Support for downloadable products - Subscription service functionality A strong background in e-commerce development, specifically with websites designed ...background in e-commerce development, specifically with websites designed for digital goods, is preferred. The right freelancer should have a strong understanding of user experience to ensure the site is easy to use and navigate. Experience with secure payment gateways and digital downloads is a must. I need a platform that can efficiently manage subscriptions and keep track of downloadable product inve...

More details: What type of product do you want to sell on the website? Physical products Do you require an inventory management system integrated into your website? No, I will manage inventory externally How do you want to handle shipping? Integration with a third-party logistics provider

I need a GUI designed from scratch based on an existing Excel sheet. The GUI will primarily handle textual data. The key features the GUI must have are: - Data visualization: Show data in a user-friendly, visually appealing format. - Data filtering: Allow users to filter data based on certain criteria. The main purpose of the GUI is to present data, providing clear, easy-to-understand visuals of complex datasets. Ideal freelancers for this project should have experience in GUI design, particularly in relation to data visualization and filtering. Knowledge and experience with textual data handling is also a plus.

Need someone who can analize data from a excel and contact customer with missing data

...specifically for inventory management of office supplies in our workplace. -Key Functions: 1. Inventory Tracking: The system should accurately track our inventory of office supplies, providing real-time updates on what's in stock. 2. Reporting and Analytics: I want the ability to generate useful reports and insights, such as inventory usage trends and re-order reminders. 3. Create bar codes for each item that contains info about the item, item location, age of item, manufacturer, retailer. -In terms of access, less than 10 users should be accommodated. It's crucial that the system you set up is user-friendly and easy to understand. -Ideal skills: You should have considerable experience in setting up open-source ERP systems and familiarity with ...

...quantity, etc. 3-Inventory Management: Automatic deduction or addition of products from/to inventory based on incoming and outgoing goods, enabling real-time monitoring of stock levels. 4-Shipment Management: Managing the receipt of incoming products into the warehouse and the dispatch of outgoing products. Tracking, timing, and reporting of these processes are crucial. 5-Shelf Management: Shelf management feature for recording the location of products within the warehouse and facilitating easy retrieval. 6-Supplier Management: Recording supplier information, tracking supplier-related products, and managing orders from suppliers. 7-Customer Management: Recording customer information and tracking customer orders. 8-Reporting and Analysis: Reporting and analysis of ...

...application should incorporate: - Listing Creation: This should enable a more streamlined process for the creation of listings in bulk. It should include features like customizable templates for the listings and an image gallery where I can easily upload and manage photos for listed items. - Inventory management with invoice creation -Email feature to send invoice through emails - Order Management: Ability to access and manage customer transactions effectively. - Inventory Management: Track available inventory promptly against sales and listings. - Transaction Retrieval: The application should include capabilities to retrieve transactions aiding in accounting processes. -should support multiple accounts for both eBay and PayPal accounts eBay -should be able...

I'm in need of a dynamic Excel sheet that automatically updates with real-time stock prices for the S&P 500 companies from the New York Stock Exchange (NYSE). This needs to be updated every minute. The main focus will be on delivering accurate, up-to-date, and reliable data. Key Features Required: - Real-time NYSE stock prices; - Ability to track up to 500 stocks from S&P 500; - Automatic updates every minute. Ideal Skills and Experience: - Proficient in Microsoft Excel; - Experience with real-time data tracking; - Knowledge or experience within the stock market realm; - Familiar with NYSE workings. Given the technical nature of this project, the successful freelancer should have adequate experience working with real-time data in Excel and hav...

More details: What specific functionalities do you want the user wishlist feature to have? Add items to wishlist, Remove items from wishlist, View wishlist items, Add items to cart from wishlist, Option for selecting sizes of items in wishlist while adding to cart Do you have a preferred design or layout for the user wishlist feature? Yes, I have a specific design in mind Which APIs wil...you want the user wishlist feature to have? Add items to wishlist, Remove items from wishlist, View wishlist items, Add items to cart from wishlist, Option for selecting sizes of items in wishlist while adding to cart Do you have a preferred design or layout for the user wishlist feature? Yes, I have a specific design in mind Which APIs will the wishlist feature need to integrate with? Product invento...

I'm looking for a professional with proficiency in Excel to carry out a data entry task involving text and images. The text data is currently formatted in an Excel spreadsheet and I would like to maintain that format for the entered data. Key tasks include: - Transcribing text data from Excel sheets - Efficiently importing and categorizing images Ideal candidates should have: - Previous experience in Excel-based data entry - Excellent attention to detail - Efficiency in handling images in Excel - Ability to maintain and replicate existing file structure Please note, the final output should also be in Excel spreadsheet format.

(Apply only if you can start ASAP and be able to draft the Gantt Chart in a few hours) I'm seeking a freelancer to make a Gantt chart using MS Project. The timetable for this project is stringent, so prompt delivery is paramount. I will provide all the details in Excel , you just need to put into MS Project and make a Gantt chart Key Features of the Project: - Focus on both subtasks and milestones when creating the Gantt chart. - The freelancer needs to be proficient in MS Project since it's the required software for this job. Ideal Candidate - Proven experience in creating/extensive knowledge about Gantt chart. - Prior usage of MS Project 2016. - Effective time management skills. Your prompt response will be greatly appre...

I'm looking for an experienced CAD designer who can help me bring my inventory tracking robot to life in a detailed and animatable CAD model. The reference robot: Key Requirements: - CAD Model: The robot should be designed with intermediate level of detail, including some moving parts. - Animatable Files: Create files that can be used for animating the robot for promotional purposes. - High-Quality Renders: I need high-quality visuals for the tower extending animation and overall robot design. Ideal Skills and Experience: - Familiarity with Mechanical Design and Cascading Linear Slides - Proficiency in CAD software - Experience in animating CAD models - Ability to produce high-quality renders - Past experience working on similar projects If you've got the experience

I have a sheet that collects check-in/out times, project names and employee names. The sheet is updated by a google form. Names and projects on the form can change. I need this sheets data to be used to determine if a project is currently occupied and to generate a weekly time report by project and employee. - Determine project occupancy: The solution should utilize the check-in/out times to determine whether a project is currently occupied or not. -Occupancy: Displayed on a Google sheet as text (OCCUPIED/CLEAR) next to the project name or change color (red/green) of project name. - Weekly time report: The time report can be in Google Sheets format. - Technology/Platform: You are free to choose the best technology or platform to au...

Hi Jacknickless, I need help to design an inventory tracking mobile robot, similar to Dexory Robot but smaller in scale using Solidworks or Onshape. The robot has autonomous mobile robot base and extending tower.

More details: We have an internal excel worksheet that has currently not been put into production, we would like this converted to an editable PDF document that only selected boxes are editable and once finished we can then fill and sign to use on an Ipad, Iphone or Desktop if amendments were needed to be made. We would need a slightly bigger signature box at the bottom to allow our engineers to the click on the box and sign with either their finger or an Apple Pencil.

am seeking a competent data entry specialist with excellent attention to detail and proficiency in Tally. The assignment entails adding around 300 entries from an excel file to tally data (i.e. update company Tally Books ). Each entry in excel has comments that specifies the heading & vendor name for the data entry. Once the data is entered the same will be verified by us for correctness. Key Responsibilities: - Organizing extensive financial data within Tally with accuracy and precision - Ensuring the data is properly categorized and easy to understand - Verifying the accuracy of the financial data, correcting any errors, and handling any discrepancies. Ideal Skills and Experience: The ideal candidate should be precise, meticulous, incredibly organized, and possess th...

As per requirement, I will deliver the required district's School details in Excel format

Se trata de integrar ZOHO BOOKS con CREATOR e INVENTORY para manejar el ciclo de vida de ordenes de pedido

I'm looking for a skilled statistician who can calculate the winning probability and the probability of a specific number appearing in ...number appearing in a number game I'm working on. The winning probability should be calculated under specific conditions that I will provide. I want the calculations to be presented in a clear and concise Excel sheet. The Excel sheet should be basic, focusing on essential calculations. Role Requirements: - Proficiency in statistical analysis and probability calculations - Advanced Excel skills for creating clear and concise spreadsheets - Ability to follow specific instructions for conditional probability calculations Ideal Skills: - Statistical analysis - Probability calculations - Excel - Data presentation - A...

I need a talented and experienced designer who can help me execute an extensive redesign of my Canva project. Ideally, you should have excellent skills in working with Canva and a keen eye for aesthetics. Specifically, the project will involve: - Text modifications: The font style will have to be changed while also decreasing the size of some text elements. - Image replacements: You'll need to replace some images with new ones that I will provide. - Layout adjustments: The layout of the Canva project might need to be adjusted to accommodate the changes mentioned above and improve the overall aesthetics. Responsibilities: - Font changes: Please alter the existing font style and adjust the font sizes as required. - Text resizing and color changes: Update the ...

I'm looking for a skilled professional who can create a VBA solution in Excel that can interact with a MySQL database. The system should be able to perform the following CRUD operations: Insert, Select, Update, and Delete. This will be a continuous requirement. Key requirements: - Proficiency in MySQL and Excel VBA - Strong understanding of SQL ODBC connections from Excel VBA - Ability to deliver the project within timelines. Your main task would be to create a reliable, easy-to-use, and efficient system to automate the specified database operations from Excel. In addition, the final solution should be well-documented for future reference. If you have experience in similar projects and can commit to the timeline, I'd love to hear from you.

...servicing, maintenance schedules, and any upcoming service requirements. - Inventory Management: An essential component of the software would be the ability to manage and track equipment inventory, including stock levels, procurement, and storage. - Service Request Tracking: The software should have a comprehensive system for users to log service requests, track progress, and receive updates on the status of their requests. Integrations: - Equipment Database: The software should be able to integrate with an equipment database, to facilitate seamless data interchange. - Email Notifications: Integration with email notification systems would be essential to keep users informed about upcoming service appointments, inventory changes, and other relevant information. - Ca...

I have less than 10 columns of text and numbers data, currently in scanned documents that need to be accurately typed into an Excel sheet. I am looking for someone highly detail-oriented with: - Proven experience in data entry or similar roles - Excellent typing speed and accuracy - Proficient in using Excel - Experience in digitizing scanned documents is a plus Responsibilities include: - Typing text and numbers data from scanned documents into Excel accurately - Ensuring no data is missed or misrepresented - Completing project within the agreed deadline. Looking forward to working with a diligent and efficient freelancer.

...looking for an experienced individual or team to create an e-commerce store that strictly sells physical products. This digital marketplace should be user-friendly for both myself (as the admin) and for customers. The critical requirements include: - High functionality in organizing and listing the varied inventory - A seamless and secured checkout system - An easily manageable back-end for edits, additions, and removal of products - A comprehensive tracking system for orders I need the project completed as soon as possible. Ideal skills: - Experience in building and maintaining e-commerce stores, specifically for physical products - Proficiency in platforms like Shopify, Magento, WooCommerce, or similar - Strong understanding of UI/UX principles - Mastery in SEO and pr...

I need assistance to convert an Excel file into the RES2DINV software for the purpose of visualizing and interpreting my data. The Excel file's content type isn't specified but it may contain geophysical measurements, soil resistivity, or survey data. This turnaround for this task needs to be as soon as possible. Ideal skills and experience: - Proficiency in utilizing RES2DINV software - Strong understanding of geophysical data interpretation - Experience in data conversion from Excel to RES2DINV - Ability to work on tight timelines.

I am in need of an Excel expert who can create a formula that will allow for real-time updating across multiple sheets. This formula should automatically transfer all inputs from sheet one to both sheet 2 and sheet 3. Key requirements: - Expertise in Excel and formula creation - Experience with real-time data updating in Excel - Ability to automate data transfer across multiple sheets The assignments from sheet 1 should appear as the words written and not "assignment" in the weekly and monthly calendars.

I need a straightforward internal order confirmation system to streamline the purchasing process and manage inventory. The ideal system for me would: - Create weekly order templates when at office - Open ordertemplate and write in customer and order - Generate automatic emails and printable PDF documents for order confirmations - Include detailed information in the confirmations such as products, quantities, prices, and customer's name and contact details - also save order on webserver in text file or database - installation on internal webserver See example of weekly order See order Freelancers with experience in inventory management systems and programming automatic emails would be a good fit for this job. Strong knowledge in creating PDF documents will be

I have a website built using Next...back-end using MongoDB. The tasks that need to be accomplished are: * User authentication * CRUD operations (Create, Read, Update, Delete) * Data filtering and sorting In addition to integrating these functionalities, I also need assistance with the design of the admin panel. The intention is that this panel will help to manage site content, user accounts, and product inventory. Optimal skills and experiences for this project: * Proficient in and MongoDB * Experience in designing admin panels * Familiarity with handling user authentication and CRUD operations * Knowledgeable in data filtering and sorting If these skills align with yours, and you have a knack for balancing functionality and design, I look forward to our potential coll...

I'm in need of an expert web scraping developer who can extract textual data from specific Wikipedia pages. This should be a one-off task as there is no requirement for handling updates or changes to these particular pages. Key specifications: - Targeted content: Textual data - Pages to scrape: Specific, to be provided Ideal skill...one-off task as there is no requirement for handling updates or changes to these particular pages. Key specifications: - Targeted content: Textual data - Pages to scrape: Specific, to be provided Ideal skills and experience: - Proven expertise in web scraping - Previous experience with Wikipedia or similar tasks preferred - Ability to deliver accurate data in a structured format such as CSV, Excel, etc. Please avoid any unnecessary or redunda...

I am in need of a personal assistant to professionally handle phone calls, answer emails, and meticulously track rental payments and expenses for 6-10 rental propertie...some responsibilities of a bookkeeper; hence, an understanding of and experience in basic to intermediate accounting is highly preferred. Key duties will involve: - Efficient management of rental properties - Timely tracking and recording of rental payments - Accurate accounting of expenses - Handling telephone and email communications A candidate with skills and experience in these areas will excel at this role: - Bookkeeping - Accounting (Intermediate level) - Property Management - Communication. For my peace of mind and the smooth operation of the rental properties, a meticulous, detail-oriented individual ...

I'm looking for an Excel expert who can modify the pricing formula and user interface of my existing price calculator. It is a very basic lookup, with quite rudimentary discounts that need to be applied, and we have a working example to share which you can backsolve how to build/update as needed. Here are the specifics: 1. Update the lookup to a new pricebook tab (Both current, working example, and new example with the new price book will be shared) 2. Introduce new add-ons tick list on the calculator (basic calculations (percentage of total, and fixed price) 3. Build out a visual display of a basic discount matrix (10%, 20% etc - this will be supplied) $. User Interface Improvement: - The updated calculator should still be user-friendly and intuitive. - Experience ...

I am seeking an expert in Excel to conduct comprehensive analysis on collected customer feedback, aiming to evaluate customer satisfaction. The raw data is currently stored in Excel spreadsheets and it essentially contains the comments and feedback from our customers. Key Responsibilities: - Deeply analyze the comments and feedback - Identify patterns, trends and vital points from the feedback - Importantly, provide a detailed report on these findings to aid further business decisions Ideal candidate must have: - Proficiency in Excel data analysis tools - Past experience in feedback analysis - Understanding of consumer behavior - Excellent reporting skills.

I'm looking for an expert to convert my existing Microsoft Excel Macro into a Google Sheet function with some added enhancements. The key enhancement is auto sorting on the newly created worksheets. The sort should utilize multiple columns, each with a unique order, either ascending or descending. Indispensable Skills: - Proficiency in Excel and Google Sheets - Familiarity with Macros and Google Scripts - Strong attention to detail, especially with data sorting and organization When you bid for this project, please say your opening comment as "Convert Excel Macro to Google Sheet Guru" - this way we will know who had done auto bidding and who has actually bothered to read out requirements. This job should be pretty easy and straight forward f...

I'm looking for a seasoned expert in Shopify app development who can assist me with creating a comprehensive app for my online store. This project was conceived with a focus on improving the overall user experience and operating efficiency of my ecommerce venture. Key Skills Required: - Proficiency in Shopify App Development - Keen understanding of the Shopify Billing API Project Deliverables: - The creation of a polished, fully functional Shopify app Features of the App: Despite not listing specific features that the app should contain, the successful candidate should proficiently manage aspects such as: - Product inventory management - Order tracking and fulfillment - Provision for customer reviews and ratings Application Requirements: Highlight your ex...

I'm in need of a meticulous professional skilled in data entry, particularly with numerical data, to populate an Excel spreadsheet for me. Key Tasks: - Processing a variety of numeric data - Entering this data accurately into an Excel spreadsheet - Categorizing and sorting this data by date Ideal Skills: - Excellent attention to detail - Ability to work with numerical data effectively - Proficiency in Excel - Data organization abilities - Ability to categorize and sort data in assigned order

I need a skilled freelancer to conduct data analysis on an array of mixed data (both numerical and textual) using Excel. The data will be provided in CSV file format. This project requires a sound understanding of data analysis concepts and proficiency in the use of Excel or similar spreadsheet software. Key Responsibilities: • Convert CSV files into a usable format for Excel • Analyze the given mixed data • Generate comprehensive findings from the data Ideal Skills: • Familiarity with CSV files • Proficient in Excel/Google Sheets • Experience in data analysis • Detail-oriented and accurate data entry • Good communication skills to effectively summarize findings.

Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.

...a talented PHP Laravel developer to design an online bus ticket booking system with the latest version 9.2. This system will facilitate user registration and login, allow for seat selection, and integrate a secure payment gateway. The system will have distinct user roles, each with varying levels of access: - Admin: oversee the overall site management. - Travel Agency/Partner: manage their inventory and sales. - User: register, login, select seats and pay for tickets. The ideal freelancer will have prior experience in similar projects and a solid understanding of PHP Laravel 9.2 for this complex build. A keen eye for usability design and a knack for creating seamless payment integration is a must. Design and develop a comprehensive bus ticket booking platform, including both ...

I am looking for a profess...professional with strong data entry and analysis skills to assist with a key task. This engagement will involve entering both numeric and textual data in Excel for the purpose of data analysis. Here are the specifics: Look at the attached excel document. I need every country to look like the top 2 rows Afghanistan and Albania. Very simple and for the right person, I dont think it would take more then 2 hours. I need this done within 10 hours time. All links must be removed. All numbers must be numeric format. If this sounds like something you could excel at, then I would love to hear from you. Please include how you would approach this project as part of your proposal. I can pay $13 for this task. Bids higher then $13 wi...

I am looking for someone to assist me with data entry in Excel for a project. The ideal candidate will have experience in data entry and be proficient in using Excel. Specific requirements for the project include: - Perform accurate and efficient data entry tasks - Organize and manage large amounts of data - Input data into Excel spreadsheets according to specific guidelines - Ensure data is entered correctly and consistently - Verify and update data as needed Additionally, the data will need to be presented in a graph or chart format. Therefore, the ideal candidate should also have experience in creating graphs and charts using Excel. Skills and experience required for this project: - Proficiency in Microsoft Excel - Strong att...

In need of a proficient Excel expert to shoulder some administrative duties. The role involves primarily data entry tasks, including but not limited to: - Simple data entry through copying and pasting - Repeat entries only need to be entered once - Looking at about 500 entries, (actual about 300 entries) Ideal candidate should demonstrate proficiency in Excel, attention to detail and data cleaning, and should be able to handle large volumes of data efficiently and meticulously. Organizational and analytical skills would come in handy to ensure data is presented in a user-friendly manner. Previous experience in data entry is well-regarded.

As part of my project, I'm dealing with a large set of data (more than 10,000 rows) in Excel, for which I require professional assistance. Key Tasks: - Apply specific Excel formulas to perform financial calculations, including NPV, IRR, and ROI. - Utilize logical and text functions such as IF, CONCATENATE, and VLOOKUP for data management and analysis. Ideal Candidate: - Proficient in Excel functions and formula calculations - Experienced in handling large datasets - Strong financial analysis background The right freelancer will help me analyze this data successfully and draw meaningful conclusions. This project requires detailed and careful work due to the extensive dataset. I appreciate your time and consideration of this project.

Hello, In formula mode, Excel only shows reference to cells and not the actual number. I need an excel function that will convert formulas (Cell B4) to actual numbers (Cell C4). The attached image will explain what is needed.

I need assistance with a large-scale data extraction from an Excel spreadsheet. The data includes about 38000 line items, from which I require certain specific pieces of information – namely, the Names, Addresses, and Email Addresses. This extracted information will be used for creating a logical and organized mailing list. Here are the important elements of the project: - Extracting Names, Addresses, and Email Addresses from approximately 38000 line items - No specific extraction criteria or conditions to follow Ideal freelancers for this job would have experience in data extraction, data entry and be efficient in Excel spreadsheet operations. Precision and attention to detail are paramount for this role, as the information gathered will directly impact the ef...

Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.

Se realizará una aplicación que se encargue de pasar los productos de una cotización en zoho books a zoho creator como un pedidos. Los pedidos en zoho creator tendrán etapas que deberán poderse manejar como un kanban, al llegar a la etapa final, deberá crear los productos del pedido con ZOHO Inventory. Deberá dar acceso a zoho books, zoho creator y zoho inventory. Es responsabilidad del usuario adquirir las suscripciones necesarias para poder soportar el flujo del programa.