+ Reply to Thread
Results 1 to 1 of 1

Calculating and accumulating time in a crafting chain table

  1. #1
    Registered User
    Join Date
    05-31-2016
    Location
    Spain
    MS-Off Ver
    2011
    Posts
    41

    Calculating and accumulating time in a crafting chain table

    Hello,

    let's say I'm developing a crafting table for a video game.
    In the attached example, you will see two tables.

    The first one is a crafting chain of items.
    So for example, Row 7 tells me that in order to craft a Bench, I need 2 pieces of wood.
    Row 8 tells me to craft a Hammer, I need 1 bench and so on and so forth.

    On the other table, you see the crafting times.
    So it takes 2 minutes to produce 2 pieces of wood and so on and so forth.

    What I'm trying to calculate, is the total time to craft an item, including the initial items to the final product.

    So for example, to craft a Hammer, first I need to craft a Bench. To craft a bench, I need 2 Wood.
    So it would be --> 2 wood = 2 minutes, then I can craft a Hammer, which is another 2 minutes, so 4 minutes.



    I think this is quite a challenge, but seeing how smart people are here, Im sure we will find an interesting solution.

    Thanks !
    Attached Files Attached Files
    Last edited by metal.stuff; 01-28-2018 at 10:19 PM.

+ 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. Crafting conditional formula
    By gormlaw in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-22-2016, 10:39 PM
  2. [SOLVED] Chain numbers to codes with BEGIN - second time more explaned
    By salaso69 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-26-2013, 01:29 AM
  3. Replies: 3
    Last Post: 11-21-2012, 05:47 AM
  4. Calculating the change in lead time from a table.
    By preto in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-19-2012, 01:21 PM
  5. [SOLVED] Calculating Fastest time in pivot table
    By Jonga21 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 10-29-2012, 01:12 PM
  6. importing time from pdf as table and calculating
    By ludikris in forum Excel General
    Replies: 5
    Last Post: 04-12-2006, 03:58 AM
  7. Accumulating Values in a Pivot table
    By Kurt in forum Excel General
    Replies: 2
    Last Post: 03-02-2005, 05:06 PM

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