+ Reply to Thread
Results 1 to 9 of 9

calculation the machine capacity

Hybrid View

  1. #1
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,940

    Re: calculation the machine capacity

    How you want your result
    please attach desired output format
    Samba

    Say thanks to those who have helped you by clicking Add Reputation star.

  2. #2
    Registered User
    Join Date
    01-11-2013
    Location
    Pakistan
    MS-Off Ver
    Excel 2016
    Posts
    38

    Re: calculation the machine capacity

    Product Capacicty/day Sat Sun Mon Tue Wed Thu Fri
    product.1 Machine.1 500 80% 0% 0% 0% 0% 0% 0%
    product.2 Machine.1 400 0% 75% 0% 0% 0% 0% 0%
    product.3 Machine.1 300 0% 0% 83% 0% 0% 0% 0%
    product.4 Machine.1 200 0% 0% 0% 85% 0% 0% 0%
    product.5 Machine.1 700 0% 0% 0% 0% 87% 0% 0%
    product.6 Machine.1 800 0% 0% 0% 0% 0% 69% 0%
    product.7 Machine.1 900 0% 0% 0% 0% 0% 0% 72%
    product.8 Machine.2 450 89% 0% 0% 0% 0% 0% 0%
    product.9 Machine.2 550 0% 55% 0% 0% 0% 0% 0%
    product.10 Machine.2 660 0% 0% 38% 0% 0% 0% 0%
    product.11 Machine.2 300 0% 0% 0% 57% 0% 0% 0%
    product.12 Machine.2 800 0% 0% 0% 0% 76% 0% 0%
    product.13 Machine.2 900 0% 0% 0% 0% 0% 61% 0%
    product.14 Machine.2 1000 0% 0% 0% 0% 0% 0% 65%
    total achivement against capacity 169% 130% 121% 142% 163% 130% 137%
    machine wise day wise and week wise against capacity

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Working code on my machine is returning out of range error on another machine.
    By je.suis.ketan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-16-2012, 11:51 PM
  2. Macro runs fine on my machine; won't run on another user's machine
    By brl8 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-29-2010, 03:16 PM
  3. Capacity Calculation
    By verticalavenue in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-20-2008, 12:37 PM
  4. Replies: 2
    Last Post: 03-01-2006, 12:25 AM
  5. Replies: 6
    Last Post: 02-28-2006, 01:20 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1