Inventory excel työt

--- ### Job Title: Excel Sheet Creation for Job Tracking and Payment Calculation **Description:** I need a custom Excel sheet to help me track jobs completed by my installers, including details about each job, such as dates, customer information, and payments. The sheet should be able to automatically calculate the total number of jobs done and the total payment owed to each installer. **Requirements:** 1. **Job Tracking:** - Columns for the date each job was completed. - Columns for the job details including customer address and account number. - Columns for the installer assigned to the job. 2. **Payment Calculation:** - Ability to input the payment rate per job. - Automatic calculation of the total number of jobs completed by each installer. - Automat...

Just a quick bit of help needed in excel macro writing. See attached before and after showing a piece of the original data. and what i neeed the macro to achieve. WHAT IM ASKING If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplicate row. AEE ATTACHED png. I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency. Essential skills and experience should include: - Expert knowledge of Excel and its macro functionality - Prior experience with data manipulation tasks such as merging cells - Understanding the rules or criteria for merging specificall...

I am looking for an expert who can as...expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge ...

...should have: - Outstanding experience and expertise in Odoo implementation and project management. - Proven track record in integrating third-party software and adapting functionalities. - Exceptional familiarity with CRM, Inventory Management, Accounting, and us of Odoo apps to manage food delivery. Key tasks include: 1. Data Migration: -Taking CSV files of my exported sales data from Shopkeep and importing it into Odoo without loss of critical information in order to enable reporting on old sales data. 2. Odoo Implementation: - Doing initial setup for Inventory Management and Accounting, as well as direct to consumer food delivery provided by our own drivers, each with its relevant functions and tools. 3. Third-Party Apps Integration: - Seamless integration of s...

I am searching for a proficient web developer who also has experience managing eCommerce platforms such as Flipkart and Amazon. The primary task is creating a website from scratch intended for product sales, with clear and appea...website for product sales from scratch. - Optimize for user-friendly navigation, SEO, and product presentation. The ideal freelancer for this job will have: - Proven experience in creating successful eCommerce websites. - Strong knowledge of site design, user experience, and SEO principles. - Previous experience managing Flipkart or Amazon product listings is beneficial. - Understanding of inventory management on eCommerce platforms. Make your bid if you are passionate about creating top-notch online shopping experiences and have experience in the areas...

I need a mobile application for warehouse inventory management, to be used on both Android and iOS devices. The app should have the following features: - Real-time inventory updates Key Requirements: - Development of a custom mobile app using AppSheet by Google - Compatibility with both Android and iOS devices Please note: - Offline functionality is not required. - The main focus is on inventory tracking Ideal Skills and Experience: - Proficiency in AppSheet by Google - Proven experience in developing mobile apps for inventory management - Familiarity with inventory tracking systems - Knowledge of Android and iOS development to ensure cross-platform compatibility.

I am in need of a skilled AppSheet developer to create a custom app for my small warehouse inventory business. Key Features: - Inventory Tracking: I require a system that will consistently track and update inventory in real-time to ensure accuracy. Other Details: - Products: As a small warehouse, I have less than 50 different types of products. - User Access: The app will not need to support multiple users accessing and updating the inventory simultaneously. Ideal Skills: - Proficient in AppSheet development - Experience in building inventory tracking systems Please respond with your relevant experience and sample work for further consideration.

I'm looking to integrate Open AI capabilities with Google Sheets to create an AI assistant that can provide our customer real time inventory information when asked. Key Project Details: - The main task of the AI assistant will be to provide real-time inventory information from Google Sheet that contains our inventory data. Ideal Skills: - Solid experience with Google Sheets API - Proven track record of integrating AI tools with external data sources - Understanding of real-time data processing and automation - Familiarity with predictive inventory management would be a plus I'm looking for a freelancer who can bring both technical expertise and creative problem-solving skills to this project.

...AI assistant with a focus on language understanding and real-time conversation support. Key Features: - Cross-Platform: The app should be developed for both iOS and Android, ensuring a wide user base. - Page Translation: Users should be able to translate live any page on their phone. - AI Assistant: The AI assistant should have the ability to provide information on various topics and should excel in language understanding, helping users with translation in real-time conversations with others. - Live Translation: The app should provide a smooth live translation experience for conversations. Ideal Skills: - Proficiency in React Native for cross-platform development. - Experience in building apps with live translation capabilities. - Strong background in AI development, specifi...

I am in need of a freelancer who can accurately convert my PDF files into Excel. The materials consist mainly of printed, electronically generated text. Given the nature of the work, the ideal candidate should: - Be proficient in both PDF and Excel formats - Have an eye for detail to ensure accuracy - Have experience dealing with extensive text documents - Possess strong typing and data entry skills Please bid if you fully understand the tasks and feel capable to deliver high-quality results. Your attention to detail and commitment to accurately completing tasks would make you an ideal candidate for this project.

I'm seeking a talented developer with extensive experience in API development and extranet creation to help me build a hotel API and extranet system. Key Responsibilities: - Develop a Hotel API with functionalities including hotel availability retrieval, room booking, and inventory management. - Design an intuitive, easy-to-use Hotel Extranet with real-time room availability, online booking management, and robust reporting and analytics features. Key Requirements: - In-depth experience in API development, ideally in the hotel or travel industry. - Proficiency in creating user-friendly, efficient extranet systems. - Prior experience with dynamic pricing mechanisms and the ability to implement custom pricing for various customer segments. This is a challenging yet rewarding p...

...The primary task is to ensure that new columns added to the database are correctly displayed in the Excel report generated by the application also fix some minor areas that will discuss in detail Key Responsibilities: - Troubleshoot and fix the issue of new columns not being displayed in the Excel report - Ensure that all relevant data is correctly fetched from the SQL Server 2019 database - Implement a seamless solution that does not affect the overall functionality of the application Ideal Skills and Experience: - Strong proficiency in C# programming language - Expert knowledge of SQL Server 2019, including stored procedures and functions - Prior experience with similar tasks involving Excel report generation from SQL data - Excellent problem-solving skills and ...

I am looking for an expert to manage and promote my Etsy shop, as well as open my google business shop. I have an inventory of handmade and unique items, and I need help with both platforms for better visibility and improved customer engagement. Your tasks would primarily include: - Inventory Management: Keeping track of existing inventory, update listing details if necessary and coordinate to replenish stock. Knowledge of Etsy’s listing system is necessary. - Promotion: Create and execute Social Media promotion strategies for both Etsy Shop and Google Business. You should have experience in leveraging different social media platforms for business promotion. Ideal candidate would have prior experience managing Etsy shops and Google Business listings, with pro...

For my project, I'm looking for a highly detail-oriented professional with brilliant Excel skills. Key responsibilities include: - Managing and transferring both numerical and textual data in an Excel spreadsheet, ensuring the correct placement into columns marked by letters (A, B, C, etc). - You'll not be required to order the data in any specific way, just transfer into the appropriate columns. Skills & Experience: - Proven record in data entry tasks - Strong Excel skills - Ability to understand and interpret numerical and textual data Looking forward to your bids and kicking into this project soon!

I'm in need of an experienced Amazon FBA agent who can proficiently handle shipping tasks for my business. The ideal candidate would be well-versed in in...who can proficiently handle shipping tasks for my business. The ideal candidate would be well-versed in international shipping, particularly to North America. The scope of tasks includes: - Ensuring smooth and efficient shipping process - Troubleshooting any shipping issues - Timely updating on the shipping status Extensive experience with Amazon FBA is a must, in addition to strong skills in inventory management and listing optimization. Importantly, a good understanding of product sourcing is necessary. I'm seeking an expert who can add value to my business, boosting efficiency and productivity. If you fit the bill,...

I'm in need of an experienced data entry specialist who can assist in uploading 850 products onto my online store. You will be provided with the necessary product information (description, price, specifications) in the format of Excel/CSV files. Your tasks will include: - Accurate data input of all relevant product details - Verification and correction of any existing data entries - Ensuring all listings are in sync with their corresponding inventory Ideal Skills: - Experience in data entry, particularly e-commerce product listing is preferred - Proficiency in Excel - Attention to detail and accuracy are extremely essential - Fast typing speed with a keen eye for details. Please only bid if you have relevant experience, and can start work promptly.

I'm looking for a professional who can assist me with the typing of my novel manuscript. Your responsibilities will include: - Accurately typing out my novel - Formatting the typed content into an e-book format The ideal freelancer for this job would be experienced in: - Typing - MS Word - Excel calculations - E-book formatting Having an RS-CIT certificate would be a major plus. The ability to pay close attention to detail and produce error-free work is paramount. Experience in typing and formatting novel manuscripts is highly preferred. Finally, quick turnaround time is necessary for the successful completion of this project.

I'm looking for an experienced freelancer who can create an Excel calculator for historical cryptocurrency prices from Binance and Luno. The calculator should also include fiat exchange rates for major currencies such as ZAR/USD bank sell rates Key Requirements: - Retrieve historical price data from Binance and Luno - Incorporate USD, and ZAR exchange rates - Organize the data and create user-friendly interface - Ensure accuracy and reliability of the calculator - Prioritizing the preservation of data privacy Ideal Skills: - Proficiency in Excel and data manipulation - Familiarity with cryptocurrency exchange APIs - Knowledge of major fiat currency exchange rates - Strong analytical and problem-solving abilities Please include your relevant experience in your applicat...

...through OTP) c) GST Number (if available ) d) Google map location (if available) after successful registration customer can login and request quotations 3. All the products details like: Product Name, photo, description, features, pdf (data sheet), warranty information, stock (available quantity), sale prices etc. can be uploaded directly through portal and mobile app and also can be uploaded through excel sheet with serial number of all products. 4. Customer can see all the uploaded products and can request for quotation. There is no need to show the available quantity (stock) to customers. 5. Admin can see the requested quotes where the prices and quantity will be reflected of all the products in quotation. Admin can edit the prices manually and can share and download the requ...

I would like to see the result statistic in %. Important, when i refresh the excel i always want to see the last 5, last 10 and last 15 results.

I have an excel file, need add product categorie on a column - budget 100€

I'm seeking an experienced Amazon accou...Optimization: Your role will include adding new products to the store, ensuring that listings are well-optimized using SEO and relevant keywords. - Inventory Management: You'll be responsible for keeping track of product stock levels, coordinating with suppliers, and ensuring a healthy inventory turnover rate. - Advertising Campaigns: You'll be tasked with creating and managing advertising campaigns on Amazon, ensuring that they are cost-effective and drive sales. Ideal candidates should have hands-on experience with Amazon seller accounts and possess a deep understanding of e-commerce best practices. Prior experience with product listings, inventory management, and Amazon advertising is highly desirable. A goo...

I am looking for a freelancer to assist with cleaning and analyzing a small dataset in Microsoft Excel. Key Responsibilities: - Data Cleaning: The dataset includes multiple columns and rows that need to be checked for inconsistencies, errors, and duplicates. - Data Analysis: After cleaning, I need the freelancer to perform basic data analysis to extract meaningful insights from the dataset. Ideal Skills: - Proficiency in Microsoft Excel and experience with data cleaning and analysis. - Attention to detail to ensure the dataset is thoroughly cleaned. - Basic data analysis skills to interpret the dataset and present the findings in a clear manner. Please note that the project does not require any specific tools or methods for analysis, but any experience with Pivot Tables,...

fichier sur Excel reproduire le même identique sur Excel avec calcul automatique

Hello, I need complet the Amazon categories catalogue excel in french

I'm looking for a seasoned app developer who can design a mobile application for my construction company. This app should operate on both iOS and Android platforms. App Features: - Project Management: The app should include efficient project management features to streamline workflows. - Materials Management: Inventory tracking, budgeting, and all other necessary tools for a construction company, should be integrated into the system. Ideal Candidate: - Experience building multi-platform construction or business-oriented apps. - Proficiency in developing user-friendly interfaces. - Knowledgeable about project and materials management systems. - Excellent problem-solving skills. Your proposal should include examples of similar apps you've created, and how you could ...

I'm in need of a freelancer with a high level of proficiency in Microsoft Excel to use conditional formatting over different tabs to help visualize duplications in large sets of numerical data. Ideally, you should not only be skilled in Excel, but also possess a keen eye for patterns and detail. Your job will encompass: - Applying conditional formatting across multiple tabs. - Highlighting duplications in numerical data. - Ensuring easy readability and understanding of the data presented. An understanding of data visualisation techniques would give you a competitive edge for this project. This task will require a close attention to detail and a strong understanding of Excel's conditional formatting tools.

I'm looking for a skilled developer to integrate my POS system with Swiggy and Zomato. The integration should focus on automated order processing and menu synchronization. Key Features: - ...Skills and Experience: - Experience with integrating POS systems with external platforms, particularly in the food industry, would be highly beneficial. - Proficiency in building robust, real-time data synchronization systems is key. - Prior experience with Swiggy and Zomato APIs and understanding of their order processing mechanisms is a distinct advantage. Please note that I do not require inventory updates from Swiggy and Zomato orders. The focus is solely on order processing and menu synchronization. Looking forward to hearing from skilled developers with proven experience in si...

...customized inventory management app using Google AppSheet and MySQL. The app will cater to a user base of less than 50, but it needs to be designed and optimized for scalable growth. It should be intuitive, easy to use, and have a professional interface. Key features that need to be incorporated into the app include: - Real-time inventory tracking - Sales and purchase order management - Product barcode scanning As the app will be handling crucial data for my business, security and reliability are of utmost importance. The developer should have experience in creating and integrating secure databases, as well as a track record of building robust, scalable applications. The successful freelancer should have: - Proficiency in Google AppSheet and MySQL - Experience in deve...

I have a small dataset of less than 1,000 rows that requires both data cleaning and formatting. Additionally, I need assistance with data analysis and visualization. This is a one-time project, and I am looking for a skilled individual to handle this for me. Ideal Skills and Experience for this project: - Proficiency in Excel is a must. - Experience with data cleaning and formatting. - Ability to perform data analysis and create visualizations. - Attention to detail and an eye for accuracy.

I have an Excel file with a macro that I need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac 2019 or later. - Ensure the modified macro functions correctly on a MacBook Pro 2018 intel OS Ventura. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issues with Excel macros.

...a new, customized solution. While experience with Zoho Creator is not a strict requirement, it would be beneficial. The main goal of this project is to develop an ERP system that will handle inventory management and sales/order processing. We will need to connect for already created ERP system first. Key aspects of this project will include: - Developing a customized ERP solution from scratch - Implementing inventory management features - Integrating sales and order processing functionalities Ideal candidates should have: - Proven experience in developing ERP systems - Strong understanding of inventory management and sales/order processing - Proficiency in Zoho Creator (or any other ERP system if not Zoho Creator) This is an urgent requirement, so please only app...

...professional to assist in integrating 2 instances of Unleashed. The primary goal is to optimize 3pl, ordering and inventory management by streamlining the process across both instances. Must be able to get Unleashed platform to talk to our clients unleashed account. Providing live stock updates order from one to another live and automating all this. This will need to be completed this week and no later as we have a tight deadline to achieve this. Flow Chart, Shopify Order > Unleashed > (Updates stock levels on clients unleashed as well as our own)> Send order to clients unleashed. Client uploads new stock > updates our unleashed account. Key Tasks: - Inventory Management: Ensure that inventory data is synchronized in real-time between the two insta...

I want to make a Incentive structure in the attached excel. I am paying incentive to my staff. I have different types of incentive policy Each Incentive calculation is starting from the month "m" It will be accumulated and the Incentives will be paid on every month of "n" The process will start again and will repeat again. This process will depend upon the value that I am putting in the cells of "m" and "n". You have to correct the formula I have given in the sample or you can make a new formula

I have a small project that requires the entry of structured text data. The project will involve: Ideal candidate would have a strong attention to detail, excellent organizational skills, and a background in data entry. Experience with structured data formats is a plus. This should be a fairly quick task, but accuracy is key. I will share you more details in via chat box. Thanks

I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.

...sending/receiving data packets, and handling socket errors. Additionally, I need help in creating a small WooCommerce database interface. The specific requirements: - Socket Programming: You will be responsible for establishing a server connection, sending and receiving data packets, and managing socket errors. - WooCommerce Database Interface: We will be integrating a small interface to manage product inventory. In this case, we are looking for basic integration - primarily focused on reading product data. The ideal candidate should have: - Proven experience in C# programming, particularly with a strong understanding of socket programming. - Prior experience working with WooCommerce or similar e-commerce platforms for database interface design. - Ability to deliver precise a...

...industry, dealing with bathroom & kitchen products. I need freelancers who are based in Malaysia and based in City if Kuala Lumpur and Town of Cheras Key Responsibilities: - Data Entry & Report Writing: You would be handling data entry tasks & writing report and (you only need to direct report to me so simple communication) - Task Management: Utilizing software such as Trello, or Microsoft Excel to keep track of tasks and deadlines. Ideal Skills and Experience: - Experience as a virtual assistant or in administrative roles is a huge plus. -Experience in wiritng report will be added advantage - Proficiency with task management tools and software. - Excellent organizational and time-management skills. - Strong communication skills - you should be comfo...

I am looking for a skilled and experienced professional who can render detailed plans and elevations for my residential construction project. Your task will involve: - Preparing construction drawings that effectively communicate design intent. Your work should be easy to understand and facilitate the building process. - Providing compreh...detailed drawings can be used for accurate cost estimation. Your background in architectural design or civil engineering, coupled with proficiency in CAD software, will be extremely beneficial. Experience in residential construction projects is a must. Please keep in mind the crucial role these drawings play in the project's execution and the importance of accuracy and attention to detail. If you excel at this, you might be the right fit ...

I'm seeking a proficient data analyst with strong statistical analysis capabilities. Your main responsibilities will be: -...incomplete records, duplicates or errors. - Statistical Analysis: You'll need to conduct a thorough statistical analysis of the data, utilizing regression analysis specifically. The project will involve various types of data including numerical, categorical, and textual data. Since we'll be working in a professional environment, knowledge and proficiency in MS Office is a must. This includes Excel, PowerPoint, and Word. Ideal candidates should be well-versed in data analysis and have a strong statistical background. Proficiency in using MS Office is also a key requirement. Previous experience handling numerical, categorical, and textual ...

I'm in need of an Excel macro expert who can help me with a data arrangement task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logical conditions for accurate and efficient data arrangement. - Potential...

...our intranet. Here are the specifics: IA definition: (below you can see my own) - We need the inventory management, manufacturing, service contracts and human resources management features to be properly configured. - The system must be set up for 1-10 users to access on our intranet. Customizations and integrations: - We may require custom reports or dashboards, although the specifics for these are not yet entirely defined. - There may be other custom integrations needed as the project progresses. Ideal Skills and Experience: - Proficient in Dolibarr installation and configuration - Previous experience in setting up Dolibarr for small businesses - Strong understanding of inventory management and HRM - Able to propose and implement customizations as they...

...Create preliminary design of the engine layout (drawings or sketches) - Develop preliminary design/placement of key components (e.g., pipe, valves, evaporator, condenser) Deliverables: First 10 hours: - Design Report (5-10 pages): - Overview of the design concept - Thermodynamic cycle analysis (calculations and spreadsheet; Excel/OpenOffice Calc) - Heat transfer calculations and assumptions (calculations and spreadsheet; Excel/OpenOffice Calc) - Fluid flow, power, and pressure drop (calculations) - Summary of Findings (1-2 pages) Second 10 hours: -CAD Drawings (2D or 3D): - Engine layout design - Key component designs (e.g., evaporator, condenser, piston) -Design Summary (2-3 pages): - Overview of the preliminar...

Provide: 1. French and 2. German translations for the static strings used on a website. I've compiled a list of all the static strings on a website. A native French speaker and a native German speaker are needed to update the Excel file attached with the translations from: 1. English to French and 2. English to German Thank you!

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

...request to courier confirmation. *** Current Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook to inquire about availability and pricing. Selection and Confirmation: Upon receiving responses, the logistician selects the best courier based on price and availability. The logistician fills out an order form in Excel, converts it to PDF, and sends it to the chosen co...

French-speaking candidates only! My organization is currently leveraging several Zoho applications including CRM, Books, Inventory, People, Recruit, Shifts, Project, Survey, and Forms. I am seeking a skilled freelancer who can effectively integrate these applications with our existing ERP system. Key project aims include: - Customer data synchronization: Ensuring consistent, accurate customer information across platforms. - Order management integration: Streamlining order processes for increased business efficiency. - Inventory management synchronization: Maintaining real-time, synchronized inventory data between Zoho and ERP. With 11-50 users expected to utilize this integrated system, the ideal freelancer should not only possess strong experience with Zo...

I'm in need of a skilled and experienced freelancer to create a WordPress website for my jewelry brand. Key Requirements: - E-commerce Functionality: I want the website to have a smooth and secure checkout process, with the ability to add products, categorize them, and manage inventory. - Responsive Design: The website should be mobile-friendly, given that a significant portion of my target audience falls within the 25-45 years old age group, who are likely to access the site through their smartphones and tablets. Design and Layout: I don't have a specific design in mind, so I'm looking for a professional who can understand my brand and create a visually appealing, user-friendly website. Copywriting: Additionally, I'll need assistance with the copywriting ...

Hi Rahul - I have an excel sheet that we currently use to calculate fees based off different calculations. I would like this form to be simpler, and easier to use.