Re: Variable

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Logan,

Actually, you could make a single table for each product, rather than all
the products as I suggested in sheet B. This would be practical where you
don't have a lot of different products. You could then eliminate the first
column. Then you could just sum the costs with an ordinary formula.
--
Earl Kisoterud
www.smokeylake.com

"Earl Kiosterud" <someone@xxxxxxxxxxx> wrote in message
news:eax5WU4wFHA.3400@xxxxxxxxxxxxxxxxxxxxxxx
> Logan,
>
> Normally, a "variable" isn't used for data in this context. Instead,
> you'd put your parts and their costs into a table:
>
> Sheet A might look like this:
>
> A B
> 1 Part Cost
> 2 2x4 6
> 3 2x2 4
> 4 4x8 ply 18
> etc.
>
> Then make a table of your product parts:
>
> A B C
> 1 Product Part Cost
> 2 Table 2x2 =VLOOKUP(B2,'A'!$A$2:$B$200, 2, FALSE)
> 3 Table 2x4 =VLOOKUP(B3,'A'!$A$2:$B$200, 2, FALSE)
> 4 Table 4x8 ply =VLOOKUP(B4,'A'!$A$2:$B$200, 2, FALSE)
> 5 Chair 2x2 =VLOOKUP(B5,'A'!$A$2:$B$200, 2, FALSE)
> etc.
>
> If this stuff isn't lined up, you need to set your newsreader to use a
> non-proportional font like Courier. After keying the first VLOOKUP, just
> copy down with the Fill Handle.
>
> Now you can change the prices in the table in sheet A, and get new
> results. You could then use Data - Subtotals, or a Pivot table to
> summarize costs for each product.
> --
> Earl Kiosterud
> www.smokeylake.com
>
> "LoganStallworth"
> <LoganStallworth.1w0fma_1127811906.1284@xxxxxxxxxxxxxxxxxxxxx> wrote in
> message
> news:LoganStallworth.1w0fma_1127811906.1284@xxxxxxxxxxxxxxxxxxxxxxxx
>>
>> Ok.
>>
>> Let me explain what I am trying to do.
>>
>> I have a set of data that contains a group of Produced Items, and the
>> materials needed to produce those items.
>>
>> I want to have a spreadsheet that has each produced item and the
>> materials that it takes to produce them. I want those materials to
>> appear as text in the cells, but I also want those cells to hold a
>> value. So for instance:
>>
>> If it takes 4 2x4's to create a table, and I have assigned the value of
>> $5.00 to a two by four then want the spreadsheet to show that:
>>
>> A1 = Table; B1 = 4 two by fours; C1 = $20.00
>>
>> My aim here is to have sheet1 hold the table of produced items, and
>> sheet2 to hold the materials required. This is so I can change the
>> cost of a material such as two by four and it will change the value in
>> all the produced items that use two by fours respectfully. I also want
>> sheet1 to only show a produced item, the materials required to make that
>> item, and the value of all the materials together.
>>
>> This could be done a number of round-about ways, but I figured if I
>> could make a variable twobyfour or two_by_four and assign it a value in
>> one sheet, and then have the first sheet display two_by_four in the cell
>> but also hold the same numerical value. That is my goal.
>>
>>
>> --
>> LoganStallworth
>> ------------------------------------------------------------------------
>> LoganStallworth's Profile:
>> http://www.excelforum.com/member.php?action=getinfo&userid=27561
>> View this thread:
>> http://www.excelforum.com/showthread.php?threadid=470856
>>
>
>


.

Relevant Pages

  • Re: {kjd-exp} Bound Magic Items
    ... A reduction of the costs of creation of 50% is extreme and shouldn't ... The range of possible materials to extract from creatures is wide. ... If the game characters adopt to these rules and try to make ...
    (rec.games.frp.dnd)
  • Re: Another Data Validation question
    ... I'm sure I don't have the right costs with the materials, ... Now on the Material Data sheet, set up Date - Validation - List, and point ... Now you can select the materials right in the Material Data sheet, ...
    (microsoft.public.excel.misc)
  • Re: All wood shells vs. composites, carbon, etc.
    ... At least as I understand it, the fabrics (and perhaps core materials) ... lower setup costs, possibly higher labor costs (more hours/boat ... for a 1x mold) plus huge oven or autoclave if heat curing, ... labor cost and adds weight) - but shapes can be modified more easily ...
    (rec.sport.rowing)
  • Re: Bush biking toward nowhere?
    ... your left with materials that are theoretically ... costs are downright cheap), but the mothball number is way off. ... Nothing comes without some side effects: Solar often takes some wickedly ... toxic materials to build, wind is struggling with the bird-kill issue, and ...
    (rec.bicycles.misc)
  • Re: Secret password for hiring a plumber?
    ... their time and the materials they use. ... you are paying a day or two of work to people who don't even go ... My interpretation of this is that he resents paying overhead costs no matter ... they do perform a needed function. ...
    (alt.home.repair)