cocciaaccounting
New Member
- Joined
- Jul 22, 2013
- Messages
- 1
Hello everybody.
I currently work at a company that produces whey protein products. For are first few years operating we have been using excel forms to produce are formulas and production sheets, but each time we do a new job, we have to manually enter in all of the information for each job like part numbers and description etc... We use a Inventory database that creates a Bill of Materials for each job based off of 1 unit of that job which may have 12 different ingrediens in it.... I guess what I am getting at is that we would like to be able to export a BOM out of the database and into an excel worksheet and then from there populate are sheets based off of that BOM by only having to click on a dropdown box which contains all of the job #'s. Were very good at using excel for what we currently do but are knowledge beyond that concerning pivot tables, controls VBA code etc... is not great. Here is are production sheet which we would like to be able to populate. Sorry if this makes no sense, its a very tough industry to try to explain but any input would be greatly appreciated.
[TABLE="width: 101"]
<tbody>[TR]
[TD="class: xl65, width: 135, bgcolor: transparent, colspan: 2"]Customer:
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 531"]
<colgroup><col width="71" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2596;"> <col width="36" style="width: 27pt; mso-width-source: userset; mso-width-alt: 1316;"> <col width="17" style="width: 13pt; mso-width-source: userset; mso-width-alt: 621;"> <col width="105" style="width: 79pt; mso-width-source: userset; mso-width-alt: 3840;"> <col width="66" style="width: 50pt; mso-width-source: userset; mso-width-alt: 2413;"> <col width="65" style="width: 49pt; mso-width-source: userset; mso-width-alt: 2377;"> <col width="73" style="width: 55pt; mso-width-source: userset; mso-width-alt: 2669;"> <col width="64" style="width: 48pt;" span="2"> <col width="58" style="width: 44pt; mso-width-source: userset; mso-width-alt: 2121;"> <col width="57" style="width: 43pt; mso-width-source: userset; mso-width-alt: 2084;"> <col width="29" style="width: 22pt; mso-width-source: userset; mso-width-alt: 1060;"> <tbody>[TR]
[TD="class: xl138, width: 107, bgcolor: transparent, colspan: 2"]Customer:
[/TD]
[TD="class: xl144, width: 188, bgcolor: transparent, colspan: 4"] [/TD]
[TD="class: xl138, width: 137, bgcolor: transparent, colspan: 2"]Lot #:[/TD]
[TD="class: xl157, width: 208, bgcolor: yellow, colspan: 4"] [/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl87, bgcolor: transparent"] [/TD]
[TD="class: xl87, bgcolor: transparent"] [/TD]
[TD="class: xl87, bgcolor: transparent"] [/TD]
[TD="class: xl87, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"]Blend Sample#:[/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl154, bgcolor: yellow, colspan: 4"] [/TD]
[/TR]
[TR]
[TD="class: xl138, bgcolor: transparent, colspan: 2"]Salesman:[/TD]
[TD="class: xl144, bgcolor: transparent, colspan: 4"] [/TD]
[TD="class: xl138, bgcolor: transparent, colspan: 2"]Production Date:[/TD]
[TD="class: xl151, bgcolor: #DCE6F1, colspan: 4"] [/TD]
[/TR]
[TR]
[TD="class: xl138, bgcolor: transparent, colspan: 2"]Product Code: [/TD]
[TD="class: xl144, bgcolor: transparent, colspan: 10"] [/TD]
[/TR]
[TR]
[TD="class: xl138, bgcolor: transparent, colspan: 2"]Product Name:[/TD]
[TD="class: xl144, bgcolor: transparent, colspan: 4"] [/TD]
[TD="class: xl138, bgcolor: transparent, colspan: 2"]Blend Size:[/TD]
[TD="class: xl140, bgcolor: #DCE6F1, colspan: 4"] [/TD]
[/TR]
[TR]
[TD="class: xl83, bgcolor: transparent, colspan: 12"] [/TD]
[/TR]
[TR]
[TD="class: xl161, bgcolor: transparent, colspan: 2"]Formulated by;[/TD]
[TD="class: xl146, bgcolor: transparent, colspan: 10"]Paul[/TD]
[/TR]
[TR]
[TD="class: xl144, bgcolor: transparent, colspan: 12"]Revision: [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl102, bgcolor: transparent"]Fill Wt:[/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl166, bgcolor: transparent, colspan: 2"]Stamp Data[/TD]
[TD="class: xl99, bgcolor: transparent"]Line1:[/TD]
[TD="class: xl100, bgcolor: transparent"]Lot#[/TD]
[TD="class: xl98, bgcolor: transparent"]Line2: [/TD]
[TD="class: xl103, bgcolor: transparent"]Mfr Date[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl99, bgcolor: transparent"][/TD]
[TD="class: xl99, bgcolor: transparent"][/TD]
[TD="class: xl99, bgcolor: transparent"][/TD]
[TD="class: xl104, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl105, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl73, bgcolor: transparent"]PART#[/TD]
[TD="class: xl149, bgcolor: transparent, colspan: 2"] [/TD]
[TD="class: xl149, bgcolor: transparent"]Description[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: transparent, colspan: 2"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl134, bgcolor: transparent, colspan: 2"]Container[/TD]
[TD="class: xl170, bgcolor: transparent"] [/TD]
[TD="class: xl99, bgcolor: transparent"][/TD]
[TD="class: xl99, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl134, bgcolor: transparent, colspan: 2"]Lid[/TD]
[TD="class: xl170, bgcolor: transparent"] [/TD]
[TD="class: xl99, bgcolor: transparent"][/TD]
[TD="class: xl99, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl134, bgcolor: transparent, colspan: 2"]Lid2[/TD]
[TD="class: xl132, bgcolor: transparent"] [/TD]
[TD="class: xl99, bgcolor: transparent"][/TD]
[TD="class: xl99, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl134, bgcolor: transparent, colspan: 2"]Scoop (Y/N)[/TD]
[TD="class: xl132, bgcolor: transparent"] [/TD]
[TD="class: xl99, bgcolor: transparent"][/TD]
[TD="class: xl99, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl134, bgcolor: transparent, colspan: 2"]Box Size[/TD]
[TD="class: xl169, bgcolor: transparent"] [/TD]
[TD="class: xl99, bgcolor: transparent"]Qty/Box: [/TD]
[TD="class: xl101, bgcolor: transparent"] [/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl134, bgcolor: transparent, colspan: 2"]ShrinkBand (Y/N)[/TD]
[TD="class: xl101, bgcolor: transparent"] [/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl136, bgcolor: transparent, colspan: 2"]Label (Y/N)[/TD]
[TD="class: xl101, bgcolor: transparent"] [/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl76, bgcolor: black"] [/TD]
[TD="class: xl76, bgcolor: black"] [/TD]
[TD="class: xl76, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[/TR]
[TR]
[TD="class: xl162, bgcolor: transparent"]Label [/TD]
[TD="class: xl118, bgcolor: transparent, colspan: 3"]Ingredients[/TD]
[TD="class: xl149, bgcolor: transparent, colspan: 3"]Total per batch[/TD]
[TD="class: xl149, bgcolor: transparent, colspan: 2"]Weighed[/TD]
[TD="class: xl149, bgcolor: transparent, colspan: 2"]Mixed[/TD]
[TD="class: xl73, bgcolor: transparent"]Lot#[/TD]
[/TR]
[TR]
[TD="class: xl77, bgcolor: transparent"]kg[/TD]
[TD="class: xl73, bgcolor: transparent"]gm[/TD]
[TD="class: xl73, bgcolor: transparent"]lbs[/TD]
[TD="class: xl73, bgcolor: transparent"]By[/TD]
[TD="class: xl73, bgcolor: transparent"]By[/TD]
[TD="class: xl73, bgcolor: transparent"]By[/TD]
[TD="class: xl73, bgcolor: transparent"]By[/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl79, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: transparent"] [/TD]
[TD="class: xl81, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl110, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl85, bgcolor: transparent"] [/TD]
[TD="class: xl110, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl85, bgcolor: transparent"] [/TD]
[TD="class: xl110, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl85, bgcolor: transparent"] [/TD]
[TD="class: xl110, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl106, bgcolor: white"] [/TD]
[TD="class: xl110, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl86, bgcolor: transparent"] [/TD]
[TD="class: xl108, bgcolor: transparent"] [/TD]
[TD="class: xl106, bgcolor: white"] [/TD]
[TD="class: xl110, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl87, bgcolor: transparent"] [/TD]
[TD="class: xl86, bgcolor: transparent"] [/TD]
[TD="class: xl108, bgcolor: transparent"] [/TD]
[TD="class: xl106, bgcolor: white"] [/TD]
[TD="class: xl110, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl87, bgcolor: transparent"] [/TD]
[TD="class: xl86, bgcolor: transparent"] [/TD]
[TD="class: xl108, bgcolor: transparent"] [/TD]
[TD="class: xl106, bgcolor: white"] [/TD]
[TD="class: xl110, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl111, bgcolor: transparent"] [/TD]
[TD="class: xl88, bgcolor: transparent"] [/TD]
[TD="class: xl117, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl113, bgcolor: white"] [/TD]
[TD="class: xl114, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl111, bgcolor: transparent"] [/TD]
[TD="class: xl88, bgcolor: transparent"] [/TD]
[TD="class: xl112, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl113, bgcolor: white"] [/TD]
[TD="class: xl115, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl111, bgcolor: transparent"] [/TD]
[TD="class: xl88, bgcolor: transparent"] [/TD]
[TD="class: xl112, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl113, bgcolor: white"] [/TD]
[TD="class: xl115, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl111, bgcolor: transparent"] [/TD]
[TD="class: xl88, bgcolor: transparent"] [/TD]
[TD="class: xl112, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl113, bgcolor: white"] [/TD]
[TD="class: xl115, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl111, bgcolor: transparent"] [/TD]
[TD="class: xl88, bgcolor: transparent"] [/TD]
[TD="class: xl112, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl113, bgcolor: white"] [/TD]
[TD="class: xl115, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl107, bgcolor: transparent"] [/TD]
[TD="class: xl88, bgcolor: transparent"] [/TD]
[TD="class: xl81, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl85, bgcolor: transparent"] [/TD]
[TD="class: xl116, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl89, bgcolor: black"] [/TD]
[TD="class: xl89, bgcolor: black"] [/TD]
[TD="class: xl89, bgcolor: black"] [/TD]
[TD="class: xl89, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl109, bgcolor: transparent, align: right"]0.0000[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: transparent, colspan: 3"]Blending Time 20 mins[/TD]
[TD="class: xl126, bgcolor: transparent, colspan: 2"]Blender #[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl95, bgcolor: transparent"]Start[/TD]
[TD="class: xl130, bgcolor: yellow, colspan: 2"] [/TD]
[TD="class: xl124, bgcolor: yellow, colspan: 2"] [/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl90, bgcolor: transparent, colspan: 5"]Scale Weights Verfied By: ______________________________[/TD]
[/TR]
[TR]
[TD="class: xl96, bgcolor: transparent"]Stop [/TD]
[TD="class: xl130, bgcolor: yellow, colspan: 2"] [/TD]
[TD="class: xl126, bgcolor: transparent, colspan: 2"]Scale #[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl91, bgcolor: transparent"]Date[/TD]
[TD="class: xl164, bgcolor: yellow, colspan: 2"] [/TD]
[TD="class: xl128, bgcolor: yellow, colspan: 2"] [/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl90, bgcolor: transparent, colspan: 5"]Notes/Adjustments to Blend (if any): ______________________[/TD]
[/TR]
</tbody>[/TABLE]
I currently work at a company that produces whey protein products. For are first few years operating we have been using excel forms to produce are formulas and production sheets, but each time we do a new job, we have to manually enter in all of the information for each job like part numbers and description etc... We use a Inventory database that creates a Bill of Materials for each job based off of 1 unit of that job which may have 12 different ingrediens in it.... I guess what I am getting at is that we would like to be able to export a BOM out of the database and into an excel worksheet and then from there populate are sheets based off of that BOM by only having to click on a dropdown box which contains all of the job #'s. Were very good at using excel for what we currently do but are knowledge beyond that concerning pivot tables, controls VBA code etc... is not great. Here is are production sheet which we would like to be able to populate. Sorry if this makes no sense, its a very tough industry to try to explain but any input would be greatly appreciated.
[TABLE="width: 101"]
<tbody>[TR]
[TD="class: xl65, width: 135, bgcolor: transparent, colspan: 2"]Customer:
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 531"]
<colgroup><col width="71" style="width: 53pt; mso-width-source: userset; mso-width-alt: 2596;"> <col width="36" style="width: 27pt; mso-width-source: userset; mso-width-alt: 1316;"> <col width="17" style="width: 13pt; mso-width-source: userset; mso-width-alt: 621;"> <col width="105" style="width: 79pt; mso-width-source: userset; mso-width-alt: 3840;"> <col width="66" style="width: 50pt; mso-width-source: userset; mso-width-alt: 2413;"> <col width="65" style="width: 49pt; mso-width-source: userset; mso-width-alt: 2377;"> <col width="73" style="width: 55pt; mso-width-source: userset; mso-width-alt: 2669;"> <col width="64" style="width: 48pt;" span="2"> <col width="58" style="width: 44pt; mso-width-source: userset; mso-width-alt: 2121;"> <col width="57" style="width: 43pt; mso-width-source: userset; mso-width-alt: 2084;"> <col width="29" style="width: 22pt; mso-width-source: userset; mso-width-alt: 1060;"> <tbody>[TR]
[TD="class: xl138, width: 107, bgcolor: transparent, colspan: 2"]Customer:
[/TD]
[TD="class: xl144, width: 188, bgcolor: transparent, colspan: 4"] [/TD]
[TD="class: xl138, width: 137, bgcolor: transparent, colspan: 2"]Lot #:[/TD]
[TD="class: xl157, width: 208, bgcolor: yellow, colspan: 4"] [/TD]
[/TR]
[TR]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl87, bgcolor: transparent"] [/TD]
[TD="class: xl87, bgcolor: transparent"] [/TD]
[TD="class: xl87, bgcolor: transparent"] [/TD]
[TD="class: xl87, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl72, bgcolor: transparent"]Blend Sample#:[/TD]
[TD="class: xl73, bgcolor: transparent"] [/TD]
[TD="class: xl154, bgcolor: yellow, colspan: 4"] [/TD]
[/TR]
[TR]
[TD="class: xl138, bgcolor: transparent, colspan: 2"]Salesman:[/TD]
[TD="class: xl144, bgcolor: transparent, colspan: 4"] [/TD]
[TD="class: xl138, bgcolor: transparent, colspan: 2"]Production Date:[/TD]
[TD="class: xl151, bgcolor: #DCE6F1, colspan: 4"] [/TD]
[/TR]
[TR]
[TD="class: xl138, bgcolor: transparent, colspan: 2"]Product Code: [/TD]
[TD="class: xl144, bgcolor: transparent, colspan: 10"] [/TD]
[/TR]
[TR]
[TD="class: xl138, bgcolor: transparent, colspan: 2"]Product Name:[/TD]
[TD="class: xl144, bgcolor: transparent, colspan: 4"] [/TD]
[TD="class: xl138, bgcolor: transparent, colspan: 2"]Blend Size:[/TD]
[TD="class: xl140, bgcolor: #DCE6F1, colspan: 4"] [/TD]
[/TR]
[TR]
[TD="class: xl83, bgcolor: transparent, colspan: 12"] [/TD]
[/TR]
[TR]
[TD="class: xl161, bgcolor: transparent, colspan: 2"]Formulated by;[/TD]
[TD="class: xl146, bgcolor: transparent, colspan: 10"]Paul[/TD]
[/TR]
[TR]
[TD="class: xl144, bgcolor: transparent, colspan: 12"]Revision: [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl102, bgcolor: transparent"]Fill Wt:[/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl166, bgcolor: transparent, colspan: 2"]Stamp Data[/TD]
[TD="class: xl99, bgcolor: transparent"]Line1:[/TD]
[TD="class: xl100, bgcolor: transparent"]Lot#[/TD]
[TD="class: xl98, bgcolor: transparent"]Line2: [/TD]
[TD="class: xl103, bgcolor: transparent"]Mfr Date[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl99, bgcolor: transparent"][/TD]
[TD="class: xl99, bgcolor: transparent"][/TD]
[TD="class: xl99, bgcolor: transparent"][/TD]
[TD="class: xl104, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl105, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl73, bgcolor: transparent"]PART#[/TD]
[TD="class: xl149, bgcolor: transparent, colspan: 2"] [/TD]
[TD="class: xl149, bgcolor: transparent"]Description[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: transparent, colspan: 2"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl134, bgcolor: transparent, colspan: 2"]Container[/TD]
[TD="class: xl170, bgcolor: transparent"] [/TD]
[TD="class: xl99, bgcolor: transparent"][/TD]
[TD="class: xl99, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl134, bgcolor: transparent, colspan: 2"]Lid[/TD]
[TD="class: xl170, bgcolor: transparent"] [/TD]
[TD="class: xl99, bgcolor: transparent"][/TD]
[TD="class: xl99, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl134, bgcolor: transparent, colspan: 2"]Lid2[/TD]
[TD="class: xl132, bgcolor: transparent"] [/TD]
[TD="class: xl99, bgcolor: transparent"][/TD]
[TD="class: xl99, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl134, bgcolor: transparent, colspan: 2"]Scoop (Y/N)[/TD]
[TD="class: xl132, bgcolor: transparent"] [/TD]
[TD="class: xl99, bgcolor: transparent"][/TD]
[TD="class: xl99, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl134, bgcolor: transparent, colspan: 2"]Box Size[/TD]
[TD="class: xl169, bgcolor: transparent"] [/TD]
[TD="class: xl99, bgcolor: transparent"]Qty/Box: [/TD]
[TD="class: xl101, bgcolor: transparent"] [/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: transparent"][/TD]
[TD="class: xl97, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl134, bgcolor: transparent, colspan: 2"]ShrinkBand (Y/N)[/TD]
[TD="class: xl101, bgcolor: transparent"] [/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl136, bgcolor: transparent, colspan: 2"]Label (Y/N)[/TD]
[TD="class: xl101, bgcolor: transparent"] [/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl98, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl74, bgcolor: transparent"][/TD]
[TD="class: xl75, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl76, bgcolor: black"] [/TD]
[TD="class: xl76, bgcolor: black"] [/TD]
[TD="class: xl76, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[/TR]
[TR]
[TD="class: xl162, bgcolor: transparent"]Label [/TD]
[TD="class: xl118, bgcolor: transparent, colspan: 3"]Ingredients[/TD]
[TD="class: xl149, bgcolor: transparent, colspan: 3"]Total per batch[/TD]
[TD="class: xl149, bgcolor: transparent, colspan: 2"]Weighed[/TD]
[TD="class: xl149, bgcolor: transparent, colspan: 2"]Mixed[/TD]
[TD="class: xl73, bgcolor: transparent"]Lot#[/TD]
[/TR]
[TR]
[TD="class: xl77, bgcolor: transparent"]kg[/TD]
[TD="class: xl73, bgcolor: transparent"]gm[/TD]
[TD="class: xl73, bgcolor: transparent"]lbs[/TD]
[TD="class: xl73, bgcolor: transparent"]By[/TD]
[TD="class: xl73, bgcolor: transparent"]By[/TD]
[TD="class: xl73, bgcolor: transparent"]By[/TD]
[TD="class: xl73, bgcolor: transparent"]By[/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl79, bgcolor: transparent"] [/TD]
[TD="class: xl80, bgcolor: transparent"] [/TD]
[TD="class: xl81, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl110, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl85, bgcolor: transparent"] [/TD]
[TD="class: xl110, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl85, bgcolor: transparent"] [/TD]
[TD="class: xl110, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl65, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl85, bgcolor: transparent"] [/TD]
[TD="class: xl110, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl70, bgcolor: transparent"] [/TD]
[TD="class: xl84, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl106, bgcolor: white"] [/TD]
[TD="class: xl110, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl86, bgcolor: transparent"] [/TD]
[TD="class: xl108, bgcolor: transparent"] [/TD]
[TD="class: xl106, bgcolor: white"] [/TD]
[TD="class: xl110, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl67, bgcolor: transparent"] [/TD]
[TD="class: xl87, bgcolor: transparent"] [/TD]
[TD="class: xl86, bgcolor: transparent"] [/TD]
[TD="class: xl108, bgcolor: transparent"] [/TD]
[TD="class: xl106, bgcolor: white"] [/TD]
[TD="class: xl110, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl66, bgcolor: transparent"] [/TD]
[TD="class: xl87, bgcolor: transparent"] [/TD]
[TD="class: xl86, bgcolor: transparent"] [/TD]
[TD="class: xl108, bgcolor: transparent"] [/TD]
[TD="class: xl106, bgcolor: white"] [/TD]
[TD="class: xl110, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl111, bgcolor: transparent"] [/TD]
[TD="class: xl88, bgcolor: transparent"] [/TD]
[TD="class: xl117, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl113, bgcolor: white"] [/TD]
[TD="class: xl114, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl111, bgcolor: transparent"] [/TD]
[TD="class: xl88, bgcolor: transparent"] [/TD]
[TD="class: xl112, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl113, bgcolor: white"] [/TD]
[TD="class: xl115, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl111, bgcolor: transparent"] [/TD]
[TD="class: xl88, bgcolor: transparent"] [/TD]
[TD="class: xl112, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl113, bgcolor: white"] [/TD]
[TD="class: xl115, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl111, bgcolor: transparent"] [/TD]
[TD="class: xl88, bgcolor: transparent"] [/TD]
[TD="class: xl112, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl113, bgcolor: white"] [/TD]
[TD="class: xl115, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl111, bgcolor: transparent"] [/TD]
[TD="class: xl88, bgcolor: transparent"] [/TD]
[TD="class: xl112, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl113, bgcolor: white"] [/TD]
[TD="class: xl115, bgcolor: transparent"] [/TD]
[TD="class: xl82, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"] [/TD]
[TD="class: xl107, bgcolor: transparent"] [/TD]
[TD="class: xl88, bgcolor: transparent"] [/TD]
[TD="class: xl81, bgcolor: transparent"] [/TD]
[TD="class: xl71, bgcolor: transparent"] [/TD]
[TD="class: xl85, bgcolor: transparent"] [/TD]
[TD="class: xl116, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl83, bgcolor: transparent"] [/TD]
[TD="class: xl78, bgcolor: yellow"] [/TD]
[/TR]
[TR]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl89, bgcolor: black"] [/TD]
[TD="class: xl89, bgcolor: black"] [/TD]
[TD="class: xl89, bgcolor: black"] [/TD]
[TD="class: xl89, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[TD="class: xl69, bgcolor: black"] [/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl109, bgcolor: transparent, align: right"]0.0000[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl92, bgcolor: transparent, colspan: 3"]Blending Time 20 mins[/TD]
[TD="class: xl126, bgcolor: transparent, colspan: 2"]Blender #[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl95, bgcolor: transparent"]Start[/TD]
[TD="class: xl130, bgcolor: yellow, colspan: 2"] [/TD]
[TD="class: xl124, bgcolor: yellow, colspan: 2"] [/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl90, bgcolor: transparent, colspan: 5"]Scale Weights Verfied By: ______________________________[/TD]
[/TR]
[TR]
[TD="class: xl96, bgcolor: transparent"]Stop [/TD]
[TD="class: xl130, bgcolor: yellow, colspan: 2"] [/TD]
[TD="class: xl126, bgcolor: transparent, colspan: 2"]Scale #[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl91, bgcolor: transparent"]Date[/TD]
[TD="class: xl164, bgcolor: yellow, colspan: 2"] [/TD]
[TD="class: xl128, bgcolor: yellow, colspan: 2"] [/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="class: xl90, bgcolor: transparent, colspan: 5"]Notes/Adjustments to Blend (if any): ______________________[/TD]
[/TR]
</tbody>[/TABLE]
Last edited: