{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Vertical_Cost_Break_Down","Tooling Cost Breakdown","Definitions","Currency Conversions"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":7,"defined_names":1820,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Vertical_Cost_Break_Down","index":0,"n_rows":1096,"n_cols":44,"rows_kept":1096,"cut":false,"hidden":false,"merged":[[831,3,845,3],[852,3,866,3],[679,3,683,3],[663,3,677,3],[684,3,698,3],[581,4,581,6],[602,4,602,6],[644,4,644,6],[665,4,665,6],[847,3,851,3],[784,4,784,6],[785,4,785,6],[786,4,786,6],[781,4,781,6],[782,4,782,6],[787,4,787,6],[759,4,759,6],[863,4,863,6],[864,4,864,6],[853,4,853,6],[855,4,855,6],[858,4,858,6],[776,4,776,6],[774,4,774,6],[532,3,536,3],[511,3,515,3],[490,3,494,3],[516,3,530,3],[758,4,758,6],[755,4,755,6],[756,4,756,6],[735,4,735,6],[734,4,734,6],[737,4,737,6],[754,4,754,6],[750,4,750,6],[745,4,745,6],[742,4,742,6],[739,4,739,6],[700,3,704,3],[736,4,736,6],[692,4,692,6],[740,4,740,6],[713,4,713,6],[618,4,618,6],[619,4,619,6],[620,4,620,6],[627,4,627,6],[668,4,668,6],[738,4,738,6],[711,4,711,6],[721,4,721,6],[727,4,727,6],[729,4,729,6],[522,4,522,6],[438,4,438,6],[439,4,439,6],[616,4,616,6],[605,4,605,6],[701,4,701,6],[717,4,717,6],[722,4,722,6],[695,4,695,6],[696,4,696,6],[686,4,686,6],[706,4,706,6],[700,4,700,6],[703,4,703,6],[716,4,716,6],[450,4,450,6],[451,4,451,6],[470,4,470,6],[423,3,431,3],[423,4,423,6],[424,4,424,6],[425,4,425,6],[426,4,426,6],[427,4,427,6],[428,4,428,6],[429,4,429,6],[410,4,410,6],[411,4,411,6],[413,3,421,3],[413,4,413,6],[414,4,414,6],[415,4,415,6],[416,4,416,6],[417,4,417,6],[418,4,418,6],[419,4,419,6],[403,3,411,3],[403,4,403,6],[404,4,404,6],[405,4,405,6],[406,4,406,6],[407,4,407,6],[383,3,391,3],[383,4,383,6],[384,4,384,6],[385,4,385,6],[386,4,386,6],[387,4,387,6],[408,4,408,6],[409,4,409,6],[390,4,390,6],[391,4,391,6],[393,3,401,3],[393,4,393,6],[394,4,394,6],[395,4,395,6],[396,4,396,6],[397,4,397,6],[398,4,398,6],[399,4,399,6],[373,3,381,3],[368,4,368,6],[369,4,369,6],[373,4,373,6],[374,4,374,6],[375,4,375,6],[376,4,376,6],[377,4,377,6],[380,4,380,6],[381,4,381,6],[379,4,379,6],[353,3,361,3],[353,4,353,6],[354,4,354,6],[355,4,355,6],[356,4,356,6],[357,4,357,6],[358,4,358,6],[359,4,359,6],[433,3,441,3],[433,4,433,6],[434,4,434,6],[435,4,435,6],[436,4,436,6],[388,4,388,6],[389,4,389,6],[440,4,440,6],[441,4,441,6],[360,4,360,6],[361,4,361,6],[363,3,371,3],[363,4,363,6],[364,4,364,6],[365,4,365,6],[366,4,366,6],[343,3,351,3],[343,4,343,6],[344,4,344,6],[345,4,345,6],[346,4,346,6],[347,4,347,6],[348,4,348,6],[349,4,349,6],[350,4,350,6],[351,4,351,6],[333,3,341,3],[333,4,333,6],[334,4,334,6],[335,4,335,6],[336,4,336,6],[337,4,337,6],[338,4,338,6],[339,4,339,6],[340,4,340,6],[341,4,341,6],[323,3,331,3],[323,4,323,6],[324,4,324,6],[325,4,325,6],[326,4,326,6],[327,4,327,6],[305,4,305,6],[306,4,306,6],[307,4,307,6],[328,4,328,6],[329,4,329,6],[310,4,310,6],[311,4,311,6],[313,3,321,3],[313,4,313,6],[314,4,314,6],[315,4,315,6],[316,4,316,6],[317,4,317,6],[330,4,330,6],[331,4,331,6],[268,4,268,6],[264,4,264,6],[265,4,265,6],[46,4,46,6],[49,4,49,6],[911,3,911,6],[269,4,269,6],[270,4,270,6],[277,4,277,6],[278,4,278,6],[279,4,279,6],[280,4,280,6],[902,4,902,6],[293,4,293,6],[294,4,294,6],[295,4,295,6],[296,4,296,6],[297,4,297,6],[298,4,298,6],[299,4,299,6],[318,4,318,6],[319,4,319,6],[320,4,320,6],[321,4,321,6],[237,4,237,6],[238,4,238,6],[233,4,233,6],[234,4,234,6],[235,4,235,6],[236,4,236,6],[230,4,230,6],[260,4,260,6],[267,4,267,6],[254,4,254,6],[255,4,255,6],[261,4,261,6],[231,4,231,6],[217,4,217,6],[218,4,218,6],[204,4,204,6],[206,4,206,6],[219,4,219,6],[220,4,220,6],[214,4,214,6],[215,4,215,6],[211,4,211,6],[213,4,213,6],[209,4,209,6],[905,4,905,6],[871,4,871,6],[870,4,870,6],[872,4,872,6],[890,3,890,6],[878,3,888,3],[899,3,900,3],[899,4,899,6],[900,4,900,6],[892,3,892,6],[903,4,903,6],[904,4,904,6],[894,3,894,6],[895,3,895,6],[896,3,896,6],[891,3,891,6],[877,3,877,6],[893,3,893,6],[887,4,887,6],[883,4,883,6],[886,4,886,6],[823,4,823,6],[824,4,824,6],[809,4,809,6],[845,4,845,6],[848,4,848,6],[816,4,816,6],[850,4,850,6],[830,4,830,6],[818,4,818,6],[817,4,817,6],[821,4,821,6],[822,4,822,6],[842,4,842,6],[843,4,843,6],[831,4,831,6],[834,4,834,6],[811,4,811,6],[815,4,815,6],[849,4,849,6],[847,4,847,6],[832,4,832,6],[826,4,826,6],[851,4,851,6],[779,4,779,6],[780,4,780,6],[800,4,800,6],[801,4,801,6],[865,4,865,6],[813,4,813,6],[799,4,799,6],[868,4,868,6],[839,4,839,6],[862,4,862,6],[866,4,866,6],[840,4,840,6],[841,4,841,6],[852,4,852,6],[857,4,857,6],[810,4,810,6],[803,4,803,6],[797,4,797,6],[798,4,798,6],[814,4,814,6],[808,4,808,6],[829,4,829,6],[844,4,844,6],[8,5,8,6],[9,5,9,6],[10,5,10,6],[44,4,44,6],[43,4,43,6],[40,4,40,6],[41,4,41,6],[42,4,42,6],[918,3,918,6],[897,3,897,6],[916,3,916,6],[913,3,913,6],[902,3,908,3],[906,4,906,6],[907,4,907,6],[908,4,908,6],[856,4,856,6],[874,4,874,6],[861,4,861,6],[859,4,859,6],[876,4,876,5],[860,4,860,6],[778,4,778,6],[773,4,773,6],[57,3,68,3],[96,3,107,3],[109,3,120,3],[63,4,63,6],[75,4,75,6],[60,4,60,6],[61,4,61,6],[68,4,68,6],[83,4,83,6],[70,3,81,3],[83,3,94,3],[107,4,107,6],[113,4,113,6],[112,4,112,6],[110,4,110,6],[96,4,96,6],[94,4,94,6],[90,4,90,6],[118,4,118,6],[119,4,119,6],[103,4,103,6],[104,4,104,6],[105,4,105,6],[106,4,106,6],[769,4,769,6],[771,4,771,6],[772,4,772,6],[760,4,760,6],[766,4,766,6],[698,4,698,6],[705,4,705,6],[601,4,601,6],[767,4,767,6],[761,4,761,6],[710,4,710,6],[704,4,704,6],[763,4,763,6],[768,4,768,6],[751,4,751,6],[748,4,748,6],[746,4,746,6],[747,4,747,6],[757,4,757,6],[764,4,764,6],[611,4,611,6],[612,4,612,6],[643,4,643,6],[606,4,606,6],[481,4,481,6],[478,4,478,6],[544,4,544,6],[543,4,543,6],[538,4,538,6],[473,4,473,6],[367,4,367,6],[378,4,378,6],[370,4,370,6],[371,4,371,6],[400,4,400,6],[401,4,401,6],[430,4,430,6],[431,4,431,6],[420,4,420,6],[421,4,421,6],[437,4,437,6],[527,4,527,6],[537,4,537,6],[535,4,535,6],[547,4,547,6],[539,4,539,6],[505,4,505,6],[512,4,512,6],[509,4,509,6],[491,4,491,6],[510,4,510,6],[493,4,493,6],[495,4,495,6],[498,4,498,6],[582,4,582,6],[541,4,541,6],[551,4,551,6],[480,4,480,6],[483,4,483,6],[484,4,484,6],[488,4,488,6],[575,4,575,6],[293,3,301,3],[574,3,578,3],[453,3,467,3],[476,4,476,6],[474,3,488,3],[497,4,497,6],[495,3,509,3],[557,4,557,6],[563,4,563,6],[568,4,568,6],[528,4,528,6],[464,4,464,6],[465,4,465,6],[486,4,486,6],[455,4,455,6],[565,4,565,6],[273,3,281,3],[300,4,300,6],[301,4,301,6],[303,3,311,3],[303,4,303,6],[273,4,273,6],[274,4,274,6],[304,4,304,6],[291,4,291,6],[283,4,283,6],[284,4,284,6],[285,4,285,6],[286,4,286,6],[287,4,287,6],[308,4,308,6],[309,4,309,6],[122,3,133,3],[263,3,271,3],[85,4,85,6],[221,4,221,6],[125,4,125,6],[126,4,126,6],[135,3,146,3],[135,4,135,6],[140,4,140,6],[128,4,128,6],[266,4,266,6],[170,4,170,6],[158,4,158,6],[155,4,155,6],[199,4,199,6],[200,4,200,6],[207,4,207,6],[208,4,208,6],[205,4,205,6],[201,4,201,6],[195,4,195,6],[193,4,193,6],[172,4,172,6],[168,4,168,6],[662,4,662,6],[651,4,651,6],[648,4,648,6],[708,4,708,6],[676,4,676,6],[677,4,677,6],[674,4,674,6],[675,4,675,6],[673,4,673,6],[679,4,679,6],[687,4,687,6],[683,4,683,6],[682,4,682,6],[685,4,685,6],[694,4,694,6],[697,4,697,6],[688,4,688,6],[689,4,689,6],[690,4,690,6],[660,4,660,6],[654,4,654,6],[667,4,667,6],[669,4,669,6],[693,4,693,6],[635,4,635,6],[629,4,629,6],[630,4,630,6],[631,4,631,6],[641,4,641,6],[637,4,637,6],[646,4,646,6],[650,4,650,6],[645,4,645,6],[632,4,632,6],[633,4,633,6],[642,4,642,6],[639,4,639,6],[585,4,585,6],[584,4,584,6],[583,4,583,6],[730,4,730,6],[702,4,702,6],[733,4,733,6],[670,4,670,6],[671,4,671,6],[672,4,672,6],[709,4,709,6],[719,4,719,6],[714,4,714,6],[715,4,715,6],[680,4,680,6],[681,4,681,6],[628,4,628,6],[663,4,663,6],[634,4,634,6],[625,4,625,6],[622,4,622,6],[653,4,653,6],[647,4,647,6],[664,4,664,6],[666,4,666,6],[626,4,626,6],[469,3,473,3],[469,4,469,6],[216,4,216,6],[133,4,133,6],[443,4,443,6],[448,3,452,3],[58,4,58,6],[89,4,89,6],[88,4,88,6],[84,4,84,6],[251,4,251,6],[452,4,452,6],[245,4,245,6],[246,4,246,6],[449,4,449,6],[448,4,448,6],[143,4,143,6],[144,4,144,6],[145,4,145,6],[137,4,137,6],[124,4,124,6],[148,3,159,3],[596,4,596,6],[47,4,47,6],[51,4,51,6],[50,4,50,6],[74,4,74,6],[71,4,71,6],[48,4,48,6],[57,4,57,6],[59,4,59,6],[53,4,53,6],[55,4,55,6],[52,4,52,6],[65,4,65,6],[64,4,64,6],[70,4,70,6],[66,4,66,6],[127,4,127,6],[141,4,141,6],[100,4,100,6],[101,4,101,6],[115,4,115,6],[79,4,79,6],[151,4,151,6],[152,4,152,6],[148,4,148,6],[149,4,149,6],[116,4,116,6],[117,4,117,6],[131,4,131,6],[136,4,136,6],[138,4,138,6],[122,4,122,6],[123,4,123,6],[129,4,129,6],[146,4,146,6],[142,4,142,6],[150,4,150,6],[111,4,111,6],[87,4,87,6],[169,4,169,6],[139,4,139,6],[130,4,130,6],[132,4,132,6],[256,4,256,6],[178,4,178,6],[179,4,179,6],[180,4,180,6],[203,4,203,6],[191,4,191,6],[153,4,153,6],[154,4,154,6],[159,4,159,6],[156,4,156,6],[157,4,157,6],[161,4,161,6],[162,4,162,6],[164,4,164,6],[165,4,165,6],[166,4,166,6],[223,4,223,6],[177,4,177,6],[182,4,182,6],[210,4,210,6],[194,4,194,6],[176,4,176,6],[161,3,172,3],[174,3,185,3],[227,4,227,6],[228,4,228,6],[229,4,229,6],[223,3,231,3],[183,4,183,6],[184,4,184,6],[193,3,201,3],[197,4,197,6],[185,4,185,6],[224,4,224,6],[225,4,225,6],[226,4,226,6],[198,4,198,6],[203,3,211,3],[213,3,221,3],[174,4,174,6],[175,4,175,6],[163,4,163,6],[171,4,171,6],[181,4,181,6],[243,3,251,3],[288,4,288,6],[289,4,289,6],[290,4,290,6],[271,4,271,6],[263,4,263,6],[239,4,239,6],[240,4,240,6],[247,4,247,6],[248,4,248,6],[249,4,249,6],[250,4,250,6],[244,4,244,6],[243,4,243,6],[241,4,241,6],[257,4,257,6],[258,4,258,6],[259,4,259,6],[253,3,261,3],[253,4,253,6],[276,4,276,6],[281,4,281,6],[233,3,241,3],[283,3,291,3],[7,5,7,6],[97,4,97,6],[120,4,120,6],[114,4,114,6],[109,4,109,6],[534,4,534,6],[492,4,492,6],[453,4,453,6],[482,4,482,6],[472,4,472,6],[457,4,457,6],[462,4,462,6],[471,4,471,6],[477,4,477,6],[467,4,467,6],[458,4,458,6],[460,4,460,6],[459,4,459,6],[466,4,466,6],[461,4,461,6],[463,4,463,6],[98,4,98,6],[446,4,446,5],[196,4,196,6],[45,4,45,6],[76,4,76,6],[99,4,99,6],[62,4,62,6],[73,4,73,6],[559,4,559,6],[561,4,561,6],[487,4,487,6],[490,4,490,6],[501,4,501,6],[556,4,556,6],[503,4,503,6],[508,4,508,6],[506,4,506,6],[536,4,536,6],[529,4,529,6],[526,4,526,6],[553,4,553,6],[540,4,540,6],[545,4,545,6],[550,4,550,6],[454,4,454,6],[275,4,275,6],[188,4,188,6],[790,4,790,6],[726,4,726,6],[752,4,752,6],[753,4,753,6],[806,4,806,6],[807,4,807,6],[802,4,802,6],[838,4,838,6],[794,4,794,6],[795,4,795,6],[789,4,789,6],[793,4,793,6],[805,4,805,6],[827,4,827,6],[828,4,828,6],[837,4,837,6],[835,4,835,6],[836,4,836,6],[833,4,833,6],[788,4,788,6],[765,4,765,6],[820,4,820,6],[819,4,819,6],[775,4,775,6],[616,3,620,3],[658,3,662,3],[963,0,976,2],[705,3,719,3],[726,3,740,3],[747,3,761,3],[768,3,782,3],[789,3,803,3],[810,3,824,3],[917,3,917,6],[910,3,910,6],[914,3,914,6],[912,3,912,6],[915,3,915,6],[649,4,649,6],[652,4,652,6],[655,4,655,6],[656,4,656,6],[661,4,661,6],[721,3,725,3],[743,4,743,6],[744,4,744,6],[742,3,746,3],[638,4,638,6],[989,0,1002,2],[102,4,102,6],[167,4,167,6],[553,3,557,3],[564,4,564,6],[599,4,599,6],[792,4,792,6],[784,3,788,3],[805,3,809,3],[763,3,767,3],[826,3,830,3],[595,3,599,3],[684,4,684,6],[724,4,724,6],[723,4,723,6],[796,4,796,6],[888,4,888,6],[884,4,884,6],[882,4,882,6],[885,4,885,6],[570,4,570,6],[590,4,590,6],[554,4,554,6],[530,4,530,6],[77,4,77,6],[91,4,91,6],[92,4,92,6],[93,4,93,6],[81,4,81,6],[72,4,72,6],[78,4,78,6],[86,4,86,6],[67,4,67,6],[80,4,80,6],[617,4,617,6],[607,4,607,6],[621,4,621,6],[609,4,609,6],[623,4,623,6],[577,4,577,6],[579,4,579,6],[580,4,580,6],[573,4,573,6],[578,4,578,6],[574,4,574,6],[576,4,576,6],[614,4,614,6],[588,4,588,6],[589,4,589,6],[591,4,591,6],[598,4,598,6],[604,4,604,6],[600,4,600,6],[597,4,597,6],[592,4,592,6],[603,4,603,6],[593,4,593,6],[595,4,595,6],[854,4,854,6],[479,4,479,6],[707,4,707,6],[728,4,728,6],[749,4,749,6],[770,4,770,6],[791,4,791,6],[812,4,812,6],[524,4,524,6],[525,4,525,6],[494,4,494,6],[518,4,518,6],[725,4,725,6],[691,4,691,6],[712,4,712,6],[731,4,731,6],[732,4,732,6],[640,4,640,6],[624,4,624,6],[586,4,586,6],[608,4,608,6],[587,4,587,6],[777,4,777,6],[485,4,485,6],[566,4,566,6],[572,4,572,6],[562,4,562,6],[571,4,571,6],[474,4,474,6],[456,4,456,6],[496,4,496,6],[499,4,499,6],[500,4,500,6],[504,4,504,6],[502,4,502,6],[519,4,519,6],[520,4,520,6],[511,4,511,6],[516,4,516,6],[517,4,517,6],[514,4,514,6],[515,4,515,6],[521,4,521,6],[513,4,513,6],[532,4,532,6],[475,4,475,6],[533,4,533,6],[552,4,552,6],[537,3,551,3],[558,3,572,3],[579,3,593,3],[600,3,614,3],[621,3,635,3],[642,3,656,3],[489,4,489,6],[718,4,718,6],[507,4,507,6],[569,4,569,6],[523,4,523,6],[567,4,567,6],[546,4,546,6],[542,4,542,6],[558,4,558,6],[555,4,555,6],[548,4,548,6],[549,4,549,6],[560,4,560,6],[658,4,658,6],[659,4,659,6],[610,4,610,6],[613,4,613,6],[637,3,641,3]]}
[]
[]
[null,null,null,null,null,null,null,null,"Vertical Cost Break Down"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version 2.17"]
[null,null,null,null,null,null,null,"Author","Document #","Date"]
[]
[]
[null,null,null,null,null,"FOREX  INFORMATION"]
[null,null,null,"Graph X-Axis Label Selection",null,"Supplier Local Currency"]
[null,null,null,"Supplier",null,"Customer Paid Currency:"]
[null,null,null,null,null,"Exchange Rate",null,{"$f":"IFERROR(VLOOKUP(H9&\"-\"&H10,'Currency Conversions'!$A:$D,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(I9&\"-\"&I10,'Currency Conversions'!$A:$D,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(J9&\"-\"&J10,'Currency Conversions'!$A:$D,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(K9&\"-\"&K10,'Currency Conversions'!$A:$D,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(L9&\"-\"&L10,'Currency Conversions'!$A:$D,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(M9&\"-\"&M10,'Currency Conversions'!$A:$D,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(N9&\"-\"&N10,'Currency Conversions'!$A:$D,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(O9&\"-\"&O10,'Currency Conversions'!$A:$D,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(P9&\"-\"&P10,'Currency Conversions'!$A:$D,4,FALSE),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(Q9&\"-\"&Q10,'Currency Conversions'!$A:$D,4,FALSE),\"\")","v":""}]
[null,null,null,"Cost Driver Graphs"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"A) General Information",{"$f":"D10","v":"Supplier"},null,null,{"$f":"IF($D$10=\"Part #\",IF(ISBLANK(H49),\"\",H49), IF(ISBLANK(H44),\"\",H44))","v":""},{"$f":"IF($D$10=\"Part #\",IF(ISBLANK(I49),\"\",I49), IF(ISBLANK(I44),\"\",I44))","v":""},{"$f":"IF($D$10=\"Part #\",IF(ISBLANK(J49),\"\",J49), IF(ISBLANK(J44),\"\",J44))","v":""},{"$f":"IF($D$10=\"Part #\",IF(ISBLANK(K49),\"\",K49), IF(ISBLANK(K44),\"\",K44))","v":""},{"$f":"IF($D$10=\"Part #\",IF(ISBLANK(L49),\"\",L49), IF(ISBLANK(L44),\"\",L44))","v":""},"","","","",""]
[null,null,null,null,"Sell Price  in Supplier Local Currency",null,null,{"$f":"H918","v":0},{"$f":"I918","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,"Sell Price  in Customer Paid Currency",null,null,{"$f":"IF(H9=H10,H42,(IF(AND(ISNUMBER(H11),ISNUMBER(H42)),(H42*H11),IF(ISNUMBER(H11),(H42*H11),H42))))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Supplier Name :"]
[null,null,null,null,"Supplier  Manufacturing Location"]
[null,null,null,null,"RFQ #/ Tracking #"]
[null,null,null,null,"Supplier DUNNS #"]
[null,null,null,null,"Part Description :"]
[null,null,null,null,"Part Number :"]
[null,null,null,null,"Drawing # / Part Revision # / Eng. Change #:"]
[null,null,null,null,"Total  Net Cycle Time :"]
[null,null,null,null,"Annual Volume :"]
[null,null,null,null,"# of Production Runs Per Year :"]
[null,null,null,null,"Lot Run Size",null,null,{"$f":"IF(ISERROR(H52/H53),0,(H52/H53))","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"B) Raw Material","Description",null,null,{"$f":"H41","v":""},"","","","","","","","",""]
[]
[null,null,null,"Raw Material  # 1","Material Description "]
[null,null,null,null,"Gross Material Weight (Shot Weight) "]
[null,null,null,null,"Blank Size (L, W, H) or (L, Diameter)"]
[null,null,null,null,"Net Material Weight "]
[null,null,null,null,"Unit of Measure (Kg,Lbs,ft, each..)"]
[null,null,null,null,"Material Cost / Unit of Measure"]
[null,null,null,null,"Material Scrap Resale Value / Unit of Measure"]
[null,null,null,null,"Supplier Source"]
[null,null,null,null,"Country"]
[null,null,null,null,"State"]
[null,null,null,null,"City"]
[null,null,null,null,"Material Cost",null,null,{"$f":"IF(ISERROR((H59*H63)-((H59-H61)*H64)),0,((H59*H63)-((H59-H61)*H64)))+((H59-H61)*H63*H912)","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Raw Material # 2","Material Description "]
[null,null,null,null,"Gross Material Weight (Shot Weight) "]
[null,null,null,null,"Blank Size (L, W, H) or (L, Diameter)"]
[null,null,null,null,"Net Material Weight "]
[null,null,null,null,"Unit of Measure (Kg,Lbs,ft, each..)"]
[null,null,null,null,"Material Cost / Unit of Measure"]
[null,null,null,null,"Material Scrap Resale Value / Unit of Measure"]
[null,null,null,null,"Supplier Source"]
[null,null,null,null,"Country"]
[null,null,null,null,"State"]
[null,null,null,null,"City"]
[null,null,null,null,"Material Cost",null,null,{"$f":"IF(ISERROR((H72*H76)-((H72-H74)*H77)),0,((H72*H76)-((H72-H74)*H77)))+((H72-H74)*H76*H912)","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Raw Material # 3","Material Description "]
[null,null,null,null,"Gross Material Weight (Shot Weight) "]
[null,null,null,null,"Blank Size (L, W, H) or (L, Diameter)"]
[null,null,null,null,"Net Material Weight "]
[null,null,null,null,"Unit of Measure (Kg,Lbs,ft, each..)"]
[null,null,null,null,"Material Cost / Unit of Measure"]
[null,null,null,null,"Material Scrap Resale Value / Unit of Measure"]
[null,null,null,null,"Supplier Source"]
[null,null,null,null,"Country"]
[null,null,null,null,"State"]
[null,null,null,null,"City"]
[null,null,null,null,"Material Cost",null,null,{"$f":"IF(ISERROR((H85*H89)-((H85-H87)*H90)),0,((H85*H89)-((H85-H87)*H90)))+((H85-H87)*H89*H912)","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Raw Material # 4","Material Description "]
[null,null,null,null,"Gross Material Weight (Shot Weight) "]
[null,null,null,null,"Blank Size (L, W, H) or (L, Diameter)"]
[null,null,null,null,"Net Material Weight "]
[null,null,null,null,"Unit of Measure (Kg,Lbs,ft, each..)"]
[null,null,null,null,"Material Cost / Unit of Measure"]
[null,null,null,null,"Material Scrap Resale Value / Unit of Measure"]
[null,null,null,null,"Supplier Source"]
[null,null,null,null,"Country"]
[null,null,null,null,"State"]
[null,null,null,null,"City"]
[null,null,null,null,"Material Cost",null,null,{"$f":"IF(ISERROR((H98*H102)-((H98-H100)*H103)),0,((H98*H102)-((H98-H100)*H103)))+((H98-H100)*H102*H912)","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Raw Material  # 5","Material Description "]
[null,null,null,null,"Gross Material Weight (Shot Weight) "]
[null,null,null,null,"Blank Size (L, W, H) or (L, Diameter)"]
[null,null,null,null,"Net Material Weight "]
[null,null,null,null,"Unit of Measure (Kg,Lbs,ft, each..)"]
[null,null,null,null,"Material Cost / Unit of Measure"]
[null,null,null,null,"Material Scrap Resale Value / Unit of Measure"]
[null,null,null,null,"Supplier Source"]
[null,null,null,null,"Country"]
[null,null,null,null,"State"]
[null,null,null,null,"City"]
[null,null,null,null,"Material Cost",null,null,{"$f":"IF(ISERROR((H111*H115)-((H111-H113)*H116)),0,((H111*H115)-((H111-H113)*H116)))+((H111-H113)*H115*H912)","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Raw Material  # 6","Material Description "]
[null,null,null,null,"Gross Material Weight (Shot Weight) "]
[null,null,null,null,"Blank Size (L, W, H) or (L, Diameter)"]
[null,null,null,null,"Net Material Weight "]
[null,null,null,null,"Unit of Measure (Kg,Lbs,ft, each..)"]
[null,null,null,null,"Material Cost / Unit of Measure"]
[null,null,null,null,"Material Scrap Resale Value / Unit of Measure"]
[null,null,null,null,"Supplier Source"]
[null,null,null,null,"Country"]
[null,null,null,null,"State"]
[null,null,null,null,"City"]
[null,null,null,null,"Material Cost",null,null,{"$f":"IF(ISERROR((H124*H128)-((H124-H126)*H129)),0,((H124*H128)-((H124-H126)*H129)))+((H124-H126)*H128*H912)","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Raw Material # 7","Material Description "]
[null,null,null,null,"Gross Material Weight (Shot Weight) "]
[null,null,null,null,"Blank Size (L, W, H) or (L, Diameter)"]
[null,null,null,null,"Net Material Weight "]
[null,null,null,null,"Unit of Measure (Kg,Lbs,ft, each..)"]
[null,null,null,null,"Material Cost / Unit of Measure"]
[null,null,null,null,"Material Scrap Resale Value / Unit of Measure"]
[null,null,null,null,"Supplier Source"]
[null,null,null,null,"Country"]
[null,null,null,null,"State"]
[null,null,null,null,"City"]
[null,null,null,null,"Material Cost",null,null,{"$f":"IF(ISERROR((H137*H141)-((H137-H139)*H142)),0,((H137*H141)-((H137-H139)*H142)))+((H137-H139)*H141*H912)","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Raw Material # 8","Material Description "]
[null,null,null,null,"Gross Material Weight (Shot Weight) "]
[null,null,null,null,"Blank Size (L, W, H) or (L, Diameter)"]
[null,null,null,null,"Net Material Weight "]
[null,null,null,null,"Unit of Measure (Kg,Lbs,ft, each..)"]
[null,null,null,null,"Material Cost / Unit of Measure"]
[null,null,null,null,"Material Scrap Resale Value / Unit of Measure"]
[null,null,null,null,"Supplier Source"]
[null,null,null,null,"Country"]
[null,null,null,null,"State"]
[null,null,null,null,"City"]
[null,null,null,null,"Material Cost",null,null,{"$f":"IF(ISERROR((H150*H154)-((H150-H152)*H155)),0,((H150*H154)-((H150-H152)*H155)))+((H150-H152)*H154*H912)","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Raw Material # 9","Material Description "]
[null,null,null,null,"Gross Material Weight (Shot Weight) "]
[null,null,null,null,"Blank Size (L, W, H) or (L, Diameter)"]
[null,null,null,null,"Net Material Weight "]
[null,null,null,null,"Unit of Measure (Kg,Lbs,ft, each..)"]
[null,null,null,null,"Material Cost / Unit of Measure"]
[null,null,null,null,"Material Scrap Resale Value / Unit of Measure"]
[null,null,null,null,"Supplier Source"]
[null,null,null,null,"Country"]
[null,null,null,null,"State"]
[null,null,null,null,"City"]
[null,null,null,null,"Material Cost",null,null,{"$f":"IF(ISERROR((H163*H167)-((H163-H165)*H168)),0,((H163*H167)-((H163-H165)*H168)))+((H163-H165)*H167*H912)","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Raw Material  # 10","Material Description "]
[null,null,null,null,"Gross Material Weight (Shot Weight) "]
[null,null,null,null,"Blank Size (L, W, H) or (L, Diameter)"]
[null,null,null,null,"Net Material Weight "]
[null,null,null,null,"Unit of Measure (Kg,Lbs,ft, each..)"]
[null,null,null,null,"Material Cost / Unit of Measure"]
[null,null,null,null,"Material Scrap Resale Value / Unit of Measure"]
[null,null,null,null,"Supplier Source"]
[null,null,null,null,"Country"]
[null,null,null,null,"State"]
[null,null,null,null,"City"]
[null,null,null,null,"Material Cost",null,null,{"$f":"IF(ISERROR((H176*H180)-((H176-H178)*H181)),0,((H176*H180)-((H176-H178)*H181)))+((H176-H178)*H180*H912)","v":0},0,0,0,0,0,0,0,0,0]
[]
[]
[null,null,null,null,"Total Net Raw Material Cost",null,null,{"$f":"(H69+H82+H95+H108+H121+H134+H147+H160+H173+H186)","v":0},{"$f":"I69+I82+I95+I108+I121+I134+I147+I160+I173+I186","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"(H69+H82+H95+H108+H121+H134+118+H160+H173+H186)*H911","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"C) Purchased Components \n& Outside Processing ","Description",null,null,{"$f":"H56","v":""},"","","","","","","","",""]
[]
[null,null,null,"Process or Component # 1","Item, Material or Process Description "]
[null,null,null,null,"Quantity Per Assembly"]
[null,null,null,null,"Unit of Measure (Kg,Lbs,ft, each ...)"]
[null,null,null,null,"Cost / UoM"]
[null,null,null,null,"Supplier Source"]
[null,null,null,null,"Country"]
[null,null,null,null,"State"]
[null,null,null,null,"City"]
[null,null,null,null,"Sub-Total Cost ",null,null,{"$f":"IF(NOT(AND(ISNUMBER(H195),ISNUMBER(H197))),0,(H195*H197))","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Process or Component  # 2","Item, Material or Process Description "]
[null,null,null,null,"Quantity Per Assembly"]
[null,null,null,null,"Unit of Measure (Kg,Lbs,ft, each ...)"]
[null,null,null,null,"Cost / UoM"]
[null,null,null,null,"Supplier Source"]
[null,null,null,null,"Country"]
[null,null,null,null,"State"]
[null,null,null,null,"City"]
[null,null,null,null,"Sub-Total Cost ",null,null,{"$f":"IF(NOT(AND(ISNUMBER(H205),ISNUMBER(H207))),0,(H205*H207))","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Process or Component # 3","Item, Material or Process Description "]
[null,null,null,null,"Quantity Per Assembly"]
[null,null,null,null,"Unit of Measure (Kg,Lbs,ft, each ...)"]
[null,null,null,null,"Cost / UoM"]
[null,null,null,null,"Supplier Source"]
[null,null,null,null,"Country"]
[null,null,null,null,"State"]
[null,null,null,null,"City"]
[null,null,null,null,"Sub-Total Cost ",null,null,{"$f":"IF(NOT(AND(ISNUMBER(H215),ISNUMBER(H217))),0,(H215*H217))","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Process or Component # 4","Item, Material or Process Description "]
[null,null,null,null,"Quantity Per Assembly"]
[null,null,null,null,"Unit of Measure (Kg,Lbs,ft, each ...)"]
[null,null,null,null,"Cost / UoM"]
[null,null,null,null,"Supplier Source"]
[null,null,null,null,"Country"]
[null,null,null,null,"State"]
[null,null,null,null,"City"]
[null,null,null,null,"Sub-Total Cost ",null,null,{"$f":"IF(NOT(AND(ISNUMBER(H225),ISNUMBER(H227))),0,(H225*H227))","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Process or Component # 5","Item, Material or Process Description "]
[null,null,null,null,"Quantity Per Assembly"]
[null,null,null,null,"Unit of Measure (Kg,Lbs,ft, each ...)"]
[null,null,null,null,"Cost / UoM"]
[null,null,null,null,"Supplier Source"]
[null,null,null,null,"Country"]
[null,null,null,null,"State"]
[null,null,null,null,"City"]
[null,null,null,null,"Sub-Total Cost ",null,null,{"$f":"IF(NOT(AND(ISNUMBER(H235),ISNUMBER(H237))),0,(H235*H237))","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Process or Component # 6","Item, Material or Process Description "]
[null,null,null,null,"Quantity Per Assembly"]
[null,null,null,null,"Unit of Measure (Kg,Lbs,ft, each ...)"]
[null,null,null,null,"Cost / UoM"]
[null,null,null,null,"Supplier Source"]
[null,null,null,null,"Country"]
[null,null,null,null,"State"]
[null,null,null,null,"City"]
[null,null,null,null,"Sub-Total Cost ",null,null,{"$f":"IF(NOT(AND(ISNUMBER(H245),ISNUMBER(H247))),0,(H245*H247))","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Process or Component  # 7","Item, Material or Process Description "]
[null,null,null,null,"Quantity Per Assembly"]
[null,null,null,null,"Unit of Measure (Kg,Lbs,ft, each ...)"]
[null,null,null,null,"Cost / UoM"]
[null,null,null,null,"Supplier Source"]
[null,null,null,null,"Country"]
[null,null,null,null,"State"]
[null,null,null,null,"City"]
[null,null,null,null,"Sub-Total Cost ",null,null,{"$f":"IF(NOT(AND(ISNUMBER(H255),ISNUMBER(H257))),0,(H255*H257))","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Process or Component # 8","Item, Material or Process Description "]
[null,null,null,null,"Quantity Per Assembly"]
[null,null,null,null,"Unit of Measure (Kg,Lbs,ft, each ...)"]
[null,null,null,null,"Cost / UoM"]
[null,null,null,null,"Supplier Source"]
[null,null,null,null,"Country"]
[null,null,null,null,"State"]
[null,null,null,null,"City"]
[null,null,null,null,"Sub-Total Cost ",null,null,{"$f":"IF(NOT(AND(ISNUMBER(H265),ISNUMBER(H267))),0,(H265*H267))","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Process or Component # 9","Item, Material or Process Description "]
[null,null,null,null,"Quantity Per Assembly"]
[null,null,null,null,"Unit of Measure (Kg,Lbs,ft, each ...)"]
[null,null,null,null,"Cost / UoM"]
[null,null,null,null,"Supplier Source"]
[null,null,null,null,"Country"]
[null,null,null,null,"State"]
[null,null,null,null,"City"]
[null,null,null,null,"Sub-Total Cost ",null,null,{"$f":"IF(NOT(AND(ISNUMBER(H275),ISNUMBER(H277))),0,(H275*H277))","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Process or Component # 10","Item, Material or Process Description "]
[null,null,null,null,"Quantity Per Assembly"]
[null,null,null,null,"Unit of Measure (Kg,Lbs,ft, each ...)"]
[null,null,null,null,"Cost / UoM"]
[null,null,null,null,"Supplier Source"]
[null,null,null,null,"Country"]
[null,null,null,null,"State"]
[null,null,null,null,"City"]
[null,null,null,null,"Sub-Total Cost ",null,null,{"$f":"IF(NOT(AND(ISNUMBER(H285),ISNUMBER(H287))),0,(H285*H287))","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Process or Component  # 11","Item, Material or Process Description "]
[null,null,null,null,"Quantity Per Assembly"]
[null,null,null,null,"Unit of Measure (Kg,Lbs,ft, each ...)"]
[null,null,null,null,"Cost / UoM"]
[null,null,null,null,"Supplier Source"]
[null,null,null,null,"Country"]
[null,null,null,null,"State"]
[null,null,null,null,"City"]
[null,null,null,null,"Sub-Total Cost ",null,null,{"$f":"IF(NOT(AND(ISNUMBER(H295),ISNUMBER(H297))),0,(H295*H297))","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Process or Component # 12","Item, Material or Process Description "]
[null,null,null,null,"Quantity Per Assembly"]
[null,null,null,null,"Unit of Measure (Kg,Lbs,ft, each ...)"]
[null,null,null,null,"Cost / UoM"]
[null,null,null,null,"Supplier Source"]
[null,null,null,null,"Country"]
[null,null,null,null,"State"]
[null,null,null,null,"City"]
[null,null,null,null,"Sub-Total Cost ",null,null,{"$f":"IF(NOT(AND(ISNUMBER(H305),ISNUMBER(H307))),0,(H305*H307))","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Process or Component # 13","Item, Material or Process Description "]
[null,null,null,null,"Quantity Per Assembly"]
[null,null,null,null,"Unit of Measure (Kg,Lbs,ft, each ...)"]
[null,null,null,null,"Cost / UoM"]
[null,null,null,null,"Supplier Source"]
[null,null,null,null,"Country"]
[null,null,null,null,"State"]
[null,null,null,null,"City"]
[null,null,null,null,"Sub-Total Cost ",null,null,{"$f":"IF(NOT(AND(ISNUMBER(H315),ISNUMBER(H317))),0,(H315*H317))","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Process or Component # 14","Item, Material or Process Description "]
[null,null,null,null,"Quantity Per Assembly"]
[null,null,null,null,"Unit of Measure (Kg,Lbs,ft, each ...)"]
[null,null,null,null,"Cost / UoM"]
[null,null,null,null,"Supplier Source"]
[null,null,null,null,"Country"]
[null,null,null,null,"State"]
[null,null,null,null,"City"]
[null,null,null,null,"Sub-Total Cost ",null,null,{"$f":"IF(NOT(AND(ISNUMBER(H325),ISNUMBER(H327))),0,(H325*H327))","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Process or Component # 15","Item, Material or Process Description "]
[null,null,null,null,"Quantity Per Assembly"]
[null,null,null,null,"Unit of Measure (Kg,Lbs,ft, each ...)"]
[null,null,null,null,"Cost / UoM"]
[null,null,null,null,"Supplier Source"]
[null,null,null,null,"Country"]
[null,null,null,null,"State"]
[null,null,null,null,"City"]
[null,null,null,null,"Sub-Total Cost ",null,null,{"$f":"IF(NOT(AND(ISNUMBER(H335),ISNUMBER(H337))),0,(H335*H337))","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Process or Component  # 16","Item, Material or Process Description "]
[null,null,null,null,"Quantity Per Assembly"]
[null,null,null,null,"Unit of Measure (Kg,Lbs,ft, each ...)"]
[null,null,null,null,"Cost / UoM"]
[null,null,null,null,"Supplier Source"]
[null,null,null,null,"Country"]
[null,null,null,null,"State"]
[null,null,null,null,"City"]
[null,null,null,null,"Sub-Total Cost ",null,null,{"$f":"IF(NOT(AND(ISNUMBER(H345),ISNUMBER(H347))),0,(H345*H347))","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Process or Component # 17","Item, Material or Process Description "]
[null,null,null,null,"Quantity Per Assembly"]
[null,null,null,null,"Unit of Measure (Kg,Lbs,ft, each ...)"]
[null,null,null,null,"Cost / UoM"]
[null,null,null,null,"Supplier Source"]
[null,null,null,null,"Country"]
[null,null,null,null,"State"]
[null,null,null,null,"City"]
[null,null,null,null,"Sub-Total Cost ",null,null,{"$f":"IF(NOT(AND(ISNUMBER(H355),ISNUMBER(H357))),0,(H355*H357))","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Process or Component # 18","Item, Material or Process Description "]
[null,null,null,null,"Quantity Per Assembly"]
[null,null,null,null,"Unit of Measure (Kg,Lbs,ft, each ...)"]
[null,null,null,null,"Cost / UoM"]
[null,null,null,null,"Supplier Source"]
[null,null,null,null,"Country"]
[null,null,null,null,"State"]
[null,null,null,null,"City"]
[null,null,null,null,"Sub-Total Cost ",null,null,{"$f":"IF(NOT(AND(ISNUMBER(H365),ISNUMBER(H367))),0,(H365*H367))","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Process or Component # 19","Item, Material or Process Description "]
[null,null,null,null,"Quantity Per Assembly"]
[null,null,null,null,"Unit of Measure (Kg,Lbs,ft, each ...)"]
[null,null,null,null,"Cost / UoM"]
[null,null,null,null,"Supplier Source"]
[null,null,null,null,"Country"]
[null,null,null,null,"State"]
[null,null,null,null,"City"]
[null,null,null,null,"Sub-Total Cost ",null,null,{"$f":"IF(NOT(AND(ISNUMBER(H375),ISNUMBER(H377))),0,(H375*H377))","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Process or Component # 20","Item, Material or Process Description "]
[null,null,null,null,"Quantity Per Assembly"]
[null,null,null,null,"Unit of Measure (Kg,Lbs,ft, each ...)"]
[null,null,null,null,"Cost / UoM"]
[null,null,null,null,"Supplier Source"]
[null,null,null,null,"Country"]
[null,null,null,null,"State"]
[null,null,null,null,"City"]
[null,null,null,null,"Sub-Total Cost ",null,null,{"$f":"IF(NOT(AND(ISNUMBER(H385),ISNUMBER(H387))),0,(H385*H387))","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Process or Component # 21","Item, Material or Process Description "]
[null,null,null,null,"Quantity Per Assembly"]
[null,null,null,null,"Unit of Measure (Kg,Lbs,ft, each ...)"]
[null,null,null,null,"Cost / UoM"]
[null,null,null,null,"Supplier Source"]
[null,null,null,null,"Country"]
[null,null,null,null,"State"]
[null,null,null,null,"City"]
[null,null,null,null,"Sub-Total Cost ",null,null,{"$f":"IF(NOT(AND(ISNUMBER(H395),ISNUMBER(H397))),0,(H395*H397))","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Process or Component  # 22","Item, Material or Process Description "]
[null,null,null,null,"Quantity Per Assembly"]
[null,null,null,null,"Unit of Measure (Kg,Lbs,ft, each ...)"]
[null,null,null,null,"Cost / UoM"]
[null,null,null,null,"Supplier Source"]
[null,null,null,null,"Country"]
[null,null,null,null,"State"]
[null,null,null,null,"City"]
[null,null,null,null,"Sub-Total Cost ",null,null,{"$f":"IF(NOT(AND(ISNUMBER(H405),ISNUMBER(H407))),0,(H405*H407))","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Process or Component # 23","Item, Material or Process Description "]
[null,null,null,null,"Quantity Per Assembly"]
[null,null,null,null,"Unit of Measure (Kg,Lbs,ft, each ...)"]
[null,null,null,null,"Cost / UoM"]
[null,null,null,null,"Supplier Source"]
[null,null,null,null,"Country"]
[null,null,null,null,"State"]
[null,null,null,null,"City"]
[null,null,null,null,"Sub-Total Cost ",null,null,{"$f":"IF(NOT(AND(ISNUMBER(H415),ISNUMBER(H417))),0,(H415*H417))","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Process or Component # 24","Item, Material or Process Description "]
[null,null,null,null,"Quantity Per Assembly"]
[null,null,null,null,"Unit of Measure (Kg,Lbs,ft, each ...)"]
[null,null,null,null,"Cost / UoM"]
[null,null,null,null,"Supplier Source"]
[null,null,null,null,"Country"]
[null,null,null,null,"State"]
[null,null,null,null,"City"]
[null,null,null,null,"Sub-Total Cost ",null,null,{"$f":"IF(NOT(AND(ISNUMBER(H425),ISNUMBER(H427))),0,(H425*H427))","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Process or Component # 25","Item, Material or Process Description "]
[null,null,null,null,"Quantity Per Assembly"]
[null,null,null,null,"Unit of Measure (Kg,Lbs,ft, each ...)"]
[null,null,null,null,"Cost / UoM"]
[null,null,null,null,"Supplier Source"]
[null,null,null,null,"Country"]
[null,null,null,null,"State"]
[null,null,null,null,"City"]
[null,null,null,null,"Sub-Total Cost ",null,null,{"$f":"IF(NOT(AND(ISNUMBER(H435),ISNUMBER(H437))),0,(H435*H437))","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,"Total Purchase Components Cost",null,null,{"$f":"SUM(H202,H212,H222,H232,H242,H252,H262,H272,H282,H292,H302,H312,H322,H332,H342,H352,H362,H372,H382,H392,H402,H412,H422,H432,H442)","v":0},{"$f":"SUM(I202,I212,I222,I232,I242,I252,I262,I272,I282,I292,I302,I312,I322,I332,I342,I352,I362,I372,I382,I392,I402,I412,I422,I432,I442)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"SUM(H202,H212,H222,H232,H242,H252,H262,H272,H282,H292,H302,H312,H322,H332,H342,H352,H362,H372,H382,H392,H402,H412,H422,H432,H442)*H911","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"D) Processing ","Description",null,null,{"$f":"H192","v":""},"","","","","","","","",""]
[]
[null,null,null,"Set Up # 1","Annual Volume",null,null,{"$f":"H52","v":0},{"$f":"I52","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,"Set Up Time (Minutes)"]
[null,null,null,null,"# of Set Up Persons"]
[null,null,null,null,"Pieces per Lot",null,null,{"$f":"H54","v":0},{"$f":"$I$54","v":0},{"$f":"$J$54","v":0},{"$f":"$K$54","v":0},{"$f":"$L$54","v":0},{"$f":"$M$54","v":0},{"$f":"$N$54","v":0},{"$f":"$O$54","v":0},{"$f":"$P$54","v":0},{"$f":"$Q$54","v":0}]
[null,null,null,null,"Set Up Costs Per Piece",null,null,{"$f":"(IF(AND(H452=0,NOT(ISNUMBER(H450))),0,(H450/60)/IF(ISNUMBER(H452),H452,(H54))/IF(ISNUMBER(H456),H456,1)))*((H461*H451)+H464+H465+H466)","v":0},{"$f":"(IF(AND(I452=0,NOT(ISNUMBER(I450))),0,(I450/60)/IF(ISNUMBER(I452),I452,($I$54))/IF(ISNUMBER(I456),I456,1)))*((I461*I451)+I464+I465+I466)","v":0},{"$f":"(IF(AND(J452=0,NOT(ISNUMBER(J450))),0,(J450/60)/IF(ISNUMBER(J452),J452,($J$54))/IF(ISNUMBER(J456),J456,1)))*((J461*J451)+J464+J465+J466)","v":0},{"$f":"(IF(AND(K452=0,NOT(ISNUMBER(K450))),0,(K450/60)/IF(ISNUMBER(K452),K452,($K$54))/IF(ISNUMBER(K456),K456,1)))*((K461*K451)+K464+K465+K466)","v":0},{"$f":"(IF(AND(L452=0,NOT(ISNUMBER(L450))),0,(L450/60)/IF(ISNUMBER(L452),L452,($L$54))/IF(ISNUMBER(L456),L456,1)))*((L461*L451)+L464+L465+L466)","v":0},{"$f":"(IF(AND(M452=0,NOT(ISNUMBER(M450))),0,(M450/60)/IF(ISNUMBER(M452),M452,($M$54))/IF(ISNUMBER(M456),M456,1)))*((M461*M451)+M464+M465+M466)","v":0},{"$f":"(IF(AND(N452=0,NOT(ISNUMBER(N450))),0,(N450/60)/IF(ISNUMBER(N452),N452,($N$54))/IF(ISNUMBER(N456),N456,1)))*((N461*N451)+N464+N465+N466)","v":0},{"$f":"(IF(AND(O452=0,NOT(ISNUMBER(O450))),0,(O450/60)/IF(ISNUMBER(O452),O452,($O$54))/IF(ISNUMBER(O456),O456,1)))*((O461*O451)+O464+O465+O466)","v":0},{"$f":"(IF(AND(P452=0,NOT(ISNUMBER(P450))),0,(P450/60)/IF(ISNUMBER(P452),P452,($P$54))/IF(ISNUMBER(P456),P456,1)))*((P461*P451)+P464+P465+P466)","v":0},{"$f":"(IF(AND(Q452=0,NOT(ISNUMBER(Q450))),0,(Q450/60)/IF(ISNUMBER(Q452),Q452,($Q$54))/IF(ISNUMBER(Q456),Q456,1)))*((Q461*Q451)+Q464+Q465+Q466)","v":0}]
[null,null,null,"Operation # 1","Operation Description "]
[null,null,null,null,"Equipment Description & Size"]
[null,null,null,null,"Quantity Per Assembly",null,null,1,1,1,1,1,1,1,1,1,1]
[null,null,null,null,"Pieces/Hour     (Strokes/Hour*Pieces Per Cycle)"]
[null,null,null,null,"Pieces Per Cycle - Information Purposes Only"]
[null,null,null,null,"Manufacturing Efficiency %"]
[null,null,null,null,"Standard Hour (With Mfg Efficiency ) (For 1 Piece)",null,null,{"$f":"IF(AND(H457=0,NOT(ISNUMBER(H457))),0,(1/H457)/(IF(AND(ISNUMBER(H459),H459),H459,1)))","v":0},{"$f":"IF(AND(I457=0,NOT(ISNUMBER(I457))),0,(1/I457)/(IF(AND(ISNUMBER(I459),I459),I459,1)))","v":0},0,{"$f":"IF(AND(K457=0,NOT(ISNUMBER(K457))),0,(1/K457)/(IF(AND(ISNUMBER(K459),K459),K459,1)))","v":0},{"$f":"IF(AND(L457=0,NOT(ISNUMBER(L457))),0,(1/L457)/(IF(AND(ISNUMBER(L459),L459),L459,1)))","v":0},0,0,0,0,0]
[null,null,null,null,"Direct Labor Wage Rate"]
[null,null,null,null,"No. of Direct Operators"]
[null,null,null,null,"Direct Labor Cost /Assembly",null,null,{"$f":"IF(AND(H460=\"\",H461=\"\"),0,H460*H461*IF(ISNUMBER(H462),H462,1))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Burden Variable Rate / hr"]
[null,null,null,null,"Burden Fixed Rate / hr"]
[null,null,null,null,"Burden Depreciation Rate / hr"]
[null,null,null,null,"Burden Cost /Assembly",null,null,{"$f":"(H464+H465+H466)*H460","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Sub-Total Cost",null,null,{"$f":"H463+H467","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"H468*H911","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"Set Up # 2","Annual Volume",null,null,{"$f":"H52","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Set Up Time (Minutes)"]
[null,null,null,null,"# of Set Up Persons"]
[null,null,null,null,"Pieces per Lot",null,null,{"$f":"H54","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Set Up Costs Per Piece",null,null,{"$f":"(IF(AND(H473=0,NOT(ISNUMBER(H471))),0,(H471/60)/IF(ISNUMBER(H473),H473,(H75))/IF(ISNUMBER(H477),H477,1)))*((H482*H472)+H485+H486+H487)","v":0},{"$f":"(IF(AND(I473=0,NOT(ISNUMBER(I471))),0,(I471/60)/IF(ISNUMBER(I473),I473,($I$54))/IF(ISNUMBER(I477),I477,1)))*((I482*I472)+I485+I486+I487)","v":0},{"$f":"(IF(AND(J473=0,NOT(ISNUMBER(J471))),0,(J471/60)/IF(ISNUMBER(J473),J473,($J$54))/IF(ISNUMBER(J477),J477,1)))*((J482*J472)+J485+J486+J487)","v":0},{"$f":"(IF(AND(K473=0,NOT(ISNUMBER(K471))),0,(K471/60)/IF(ISNUMBER(K473),K473,($K$54))/IF(ISNUMBER(K477),K477,1)))*((K482*K472)+K485+K486+K487)","v":0},{"$f":"(IF(AND(L473=0,NOT(ISNUMBER(L471))),0,(L471/60)/IF(ISNUMBER(L473),L473,($L$54))/IF(ISNUMBER(L477),L477,1)))*((L482*L472)+L485+L486+L487)","v":0},{"$f":"(IF(AND(M473=0,NOT(ISNUMBER(M471))),0,(M471/60)/IF(ISNUMBER(M473),M473,($M$54))/IF(ISNUMBER(M477),M477,1)))*((M482*M472)+M485+M486+M487)","v":0},{"$f":"(IF(AND(N473=0,NOT(ISNUMBER(N471))),0,(N471/60)/IF(ISNUMBER(N473),N473,($N$54))/IF(ISNUMBER(N477),N477,1)))*((N482*N472)+N485+N486+N487)","v":0},{"$f":"(IF(AND(O473=0,NOT(ISNUMBER(O471))),0,(O471/60)/IF(ISNUMBER(O473),O473,($O$54))/IF(ISNUMBER(O477),O477,1)))*((O482*O472)+O485+O486+O487)","v":0},{"$f":"(IF(AND(P473=0,NOT(ISNUMBER(P471))),0,(P471/60)/IF(ISNUMBER(P473),P473,($P$54))/IF(ISNUMBER(P477),P477,1)))*((P482*P472)+P485+P486+P487)","v":0},{"$f":"(IF(AND(Q473=0,NOT(ISNUMBER(Q471))),0,(Q471/60)/IF(ISNUMBER(Q473),Q473,($Q$54))/IF(ISNUMBER(Q477),Q477,1)))*((Q482*Q472)+Q485+Q486+Q487)","v":0}]
[null,null,null,"Operation # 2","Operation Description "]
[null,null,null,null,"Equipment Description & Size"]
[null,null,null,null,"Quantity Per Assembly",null,null,1,1,1,1,1,1,1,1,1,1]
[null,null,null,null,"Pieces/Hour     (Strokes/Hour*Pieces Per Cycle)"]
[null,null,null,null,"Pieces Per Cycle - Information Purposes Only"]
[null,null,null,null,"Manufacturing Efficiency %"]
[null,null,null,null,"Standard Hour (With Mfg Efficiency ) (For 1 Piece)",null,null,{"$f":"IF(AND(H478=0,NOT(ISNUMBER(H478))),0,(1/H478)/(IF(AND(ISNUMBER(H480),H480),H480,1)))","v":0},{"$f":"IF(AND(I478=0,NOT(ISNUMBER(I478))),0,(1/I478)/(IF(AND(ISNUMBER(I480),I480),I480,1)))","v":0},0,{"$f":"IF(AND(K478=0,NOT(ISNUMBER(K478))),0,(1/K478)/(IF(AND(ISNUMBER(K480),K480),K480,1)))","v":0},{"$f":"IF(AND(L478=0,NOT(ISNUMBER(L478))),0,(1/L478)/(IF(AND(ISNUMBER(L480),L480),L480,1)))","v":0},0,0,0,0,0]
[null,null,null,null,"Direct Labor Wage Rate"]
[null,null,null,null,"No. of Direct Operators"]
[null,null,null,null,"Direct Labor Cost /Assembly",null,null,{"$f":"IF(AND(H481=\"\",H482=\"\"),0,H481*H482*IF(ISNUMBER(H483),H483,1))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Burden Variable Rate / hr"]
[null,null,null,null,"Burden Fixed Rate / hr"]
[null,null,null,null,"Burden Depreciation Rate / hr"]
[null,null,null,null,"Burden Cost /Assembly",null,null,{"$f":"(H485+H486+H487)*H481","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Sub-Total Cost",null,null,{"$f":"H484+H488","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"H489*H911","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"Set Up # 3","Annual Volume",null,null,{"$f":"H$52","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Set Up Time (Minutes)"]
[null,null,null,null,"# of Set Up Persons"]
[null,null,null,null,"Pieces per Lot",null,null,{"$f":"H54","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"H510*6.5*1000/H61*1000","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Set Up Costs Per Piece",null,null,{"$f":"(IF(AND(H494=0,NOT(ISNUMBER(H492))),0,(H492/60)/IF(ISNUMBER(H494),H494,(H96))/IF(ISNUMBER(H498),H498,1)))*((H503*H493)+H506+H507+H508)","v":0},{"$f":"(IF(AND(I494=0,NOT(ISNUMBER(I492))),0,(I492/60)/IF(ISNUMBER(I494),I494,($I$54))/IF(ISNUMBER(I498),I498,1)))*((I503*I493)+I506+I507+I508)","v":0},{"$f":"(IF(AND(J494=0,NOT(ISNUMBER(J492))),0,(J492/60)/IF(ISNUMBER(J494),J494,($J$54))/IF(ISNUMBER(J498),J498,1)))*((J503*J493)+J506+J507+J508)","v":0},{"$f":"(IF(AND(K494=0,NOT(ISNUMBER(K492))),0,(K492/60)/IF(ISNUMBER(K494),K494,($K$54))/IF(ISNUMBER(K498),K498,1)))*((K503*K493)+K506+K507+K508)","v":0},{"$f":"(IF(AND(L494=0,NOT(ISNUMBER(L492))),0,(L492/60)/IF(ISNUMBER(L494),L494,($L$54))/IF(ISNUMBER(L498),L498,1)))*((L503*L493)+L506+L507+L508)","v":0},{"$f":"(IF(AND(M494=0,NOT(ISNUMBER(M492))),0,(M492/60)/IF(ISNUMBER(M494),M494,($M$54))/IF(ISNUMBER(M498),M498,1)))*((M503*M493)+M506+M507+M508)","v":0},{"$f":"(IF(AND(N494=0,NOT(ISNUMBER(N492))),0,(N492/60)/IF(ISNUMBER(N494),N494,($N$54))/IF(ISNUMBER(N498),N498,1)))*((N503*N493)+N506+N507+N508)","v":0},{"$f":"(IF(AND(O494=0,NOT(ISNUMBER(O492))),0,(O492/60)/IF(ISNUMBER(O494),O494,($O$54))/IF(ISNUMBER(O498),O498,1)))*((O503*O493)+O506+O507+O508)","v":0},{"$f":"(IF(AND(P494=0,NOT(ISNUMBER(P492))),0,(P492/60)/IF(ISNUMBER(P494),P494,($P$54))/IF(ISNUMBER(P498),P498,1)))*((P503*P493)+P506+P507+P508)","v":0},{"$f":"(IF(AND(Q494=0,NOT(ISNUMBER(Q492))),0,(Q492/60)/IF(ISNUMBER(Q494),Q494,($Q$54))/IF(ISNUMBER(Q498),Q498,1)))*((Q503*Q493)+Q506+Q507+Q508)","v":0},null,{"$f":"I510*6.5*1000/H61*1000","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Operation # 3","Operation Description "]
[null,null,null,null,"Equipment Description & Size"]
[null,null,null,null,"Quantity Per Assembly",null,null,1,1,1,1,1,1,1,1,1,1]
[null,null,null,null,"Pieces/Hour     (Strokes/Hour*Pieces Per Cycle)"]
[null,null,null,null,"Pieces Per Cycle - Information Purposes Only"]
[null,null,null,null,"Manufacturing Efficiency %"]
[null,null,null,null,"Standard Hour (With Mfg Efficiency ) (For 1 Piece)",null,null,{"$f":"IF(AND(H499=0,NOT(ISNUMBER(H499))),0,(1/H499)/(IF(AND(ISNUMBER(H501),H501),H501,1)))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Direct Labor Wage Rate"]
[null,null,null,null,"No. of Direct Operators"]
[null,null,null,null,"Direct Labor Cost /Assembly",null,null,{"$f":"IF(AND(H502=\"\",H503=\"\"),0,H502*H503*IF(ISNUMBER(H504),H504,1))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Burden Variable Rate / hr"]
[null,null,null,null,"Burden Fixed Rate / hr"]
[null,null,null,null,"Burden Depreciation Rate / hr"]
[null,null,null,null,"Burden Cost /Assembly",null,null,{"$f":"(H506+H507+H508)*H502","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Sub-Total Cost",null,null,{"$f":"H505+H509","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"H510*H911","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"Set Up # 4","Annual Volume",null,null,{"$f":"H$52","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Set Up Time (Minutes)"]
[null,null,null,null,"# of Set Up Persons"]
[null,null,null,null,"Pieces per Lot",null,null,{"$f":"H54","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"H531*1000*6.5/H61*1000","v":{"$error":"#DIV/0!"}},{"$f":"H531*1000*6.5","v":0}]
[null,null,null,null,"Set Up Costs Per Piece",null,null,{"$f":"(IF(AND(H515=0,NOT(ISNUMBER(H513))),0,(H513/60)/IF(ISNUMBER(H515),H515,(H117))/IF(ISNUMBER(H519),H519,1)))*((H524*H514)+H527+H528+H529)","v":0},{"$f":"(IF(AND(I515=0,NOT(ISNUMBER(I513))),0,(I513/60)/IF(ISNUMBER(I515),I515,($I$54))/IF(ISNUMBER(I519),I519,1)))*((I524*I514)+I527+I528+I529)","v":0},{"$f":"(IF(AND(J515=0,NOT(ISNUMBER(J513))),0,(J513/60)/IF(ISNUMBER(J515),J515,($J$54))/IF(ISNUMBER(J519),J519,1)))*((J524*J514)+J527+J528+J529)","v":0},{"$f":"(IF(AND(K515=0,NOT(ISNUMBER(K513))),0,(K513/60)/IF(ISNUMBER(K515),K515,($K$54))/IF(ISNUMBER(K519),K519,1)))*((K524*K514)+K527+K528+K529)","v":0},{"$f":"(IF(AND(L515=0,NOT(ISNUMBER(L513))),0,(L513/60)/IF(ISNUMBER(L515),L515,($L$54))/IF(ISNUMBER(L519),L519,1)))*((L524*L514)+L527+L528+L529)","v":0},{"$f":"(IF(AND(M515=0,NOT(ISNUMBER(M513))),0,(M513/60)/IF(ISNUMBER(M515),M515,($M$54))/IF(ISNUMBER(M519),M519,1)))*((M524*M514)+M527+M528+M529)","v":0},{"$f":"(IF(AND(N515=0,NOT(ISNUMBER(N513))),0,(N513/60)/IF(ISNUMBER(N515),N515,($N$54))/IF(ISNUMBER(N519),N519,1)))*((N524*N514)+N527+N528+N529)","v":0},{"$f":"(IF(AND(O515=0,NOT(ISNUMBER(O513))),0,(O513/60)/IF(ISNUMBER(O515),O515,($O$54))/IF(ISNUMBER(O519),O519,1)))*((O524*O514)+O527+O528+O529)","v":0},{"$f":"(IF(AND(P515=0,NOT(ISNUMBER(P513))),0,(P513/60)/IF(ISNUMBER(P515),P515,($P$54))/IF(ISNUMBER(P519),P519,1)))*((P524*P514)+P527+P528+P529)","v":0},{"$f":"(IF(AND(Q515=0,NOT(ISNUMBER(Q513))),0,(Q513/60)/IF(ISNUMBER(Q515),Q515,($Q$54))/IF(ISNUMBER(Q519),Q519,1)))*((Q524*Q514)+Q527+Q528+Q529)","v":0},null,{"$f":"I531*1000*6.5/H61*1000","v":{"$error":"#DIV/0!"}},{"$f":"I531*1000*6.5","v":0}]
[null,null,null,"Operation # 4","Operation Description "]
[null,null,null,null,"Equipment Description & Size"]
[null,null,null,null,"Quantity Per Assembly",null,null,1,1,1,1,1,1,1,1,1,1]
[null,null,null,null,"Pieces/Hour     (Strokes/Hour*Pieces Per Cycle)"]
[null,null,null,null,"Pieces Per Cycle - Information Purposes Only"]
[null,null,null,null,"Manufacturing Efficiency %"]
[null,null,null,null,"Standard Hour (With Mfg Efficiency ) (For 1 Piece)",null,null,{"$f":"IF(AND(H520=0,NOT(ISNUMBER(H520))),0,(1/H520)/(IF(AND(ISNUMBER(H522),H522),H522,1)))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Direct Labor Wage Rate"]
[null,null,null,null,"No. of Direct Operators"]
[null,null,null,null,"Direct Labor Cost /Assembly",null,null,{"$f":"IF(AND(H523=\"\",H524=\"\"),0,H523*H524*IF(ISNUMBER(H525),H525,1))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Burden Variable Rate / hr"]
[null,null,null,null,"Burden Fixed Rate / hr"]
[null,null,null,null,"Burden Depreciation Rate / hr"]
[null,null,null,null,"Burden Cost /Assembly",null,null,{"$f":"(H527+H528+H529)*H523","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Sub-Total Cost",null,null,{"$f":"H526+H530","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"H531*H911","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"Set Up # 5","Annual Volume",null,null,{"$f":"H$52","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Set Up Time (Minutes)"]
[null,null,null,null,"# of Set Up Persons"]
[null,null,null,null,"Pieces per Lot",null,null,{"$f":"H54","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Set Up Costs Per Piece",null,null,{"$f":"(IF(AND(H536=0,NOT(ISNUMBER(H534))),0,(H534/60)/IF(ISNUMBER(H536),H536,(H138))/IF(ISNUMBER(H540),H540,1)))*((H545*H535)+H548+H549+H550)","v":0},{"$f":"(IF(AND(I536=0,NOT(ISNUMBER(I534))),0,(I534/60)/IF(ISNUMBER(I536),I536,($I$54))/IF(ISNUMBER(I540),I540,1)))*((I545*I535)+I548+I549+I550)","v":0},{"$f":"(IF(AND(J536=0,NOT(ISNUMBER(J534))),0,(J534/60)/IF(ISNUMBER(J536),J536,($J$54))/IF(ISNUMBER(J540),J540,1)))*((J545*J535)+J548+J549+J550)","v":0},{"$f":"(IF(AND(K536=0,NOT(ISNUMBER(K534))),0,(K534/60)/IF(ISNUMBER(K536),K536,($K$54))/IF(ISNUMBER(K540),K540,1)))*((K545*K535)+K548+K549+K550)","v":0},{"$f":"(IF(AND(L536=0,NOT(ISNUMBER(L534))),0,(L534/60)/IF(ISNUMBER(L536),L536,($L$54))/IF(ISNUMBER(L540),L540,1)))*((L545*L535)+L548+L549+L550)","v":0},{"$f":"(IF(AND(M536=0,NOT(ISNUMBER(M534))),0,(M534/60)/IF(ISNUMBER(M536),M536,($M$54))/IF(ISNUMBER(M540),M540,1)))*((M545*M535)+M548+M549+M550)","v":0},{"$f":"(IF(AND(N536=0,NOT(ISNUMBER(N534))),0,(N534/60)/IF(ISNUMBER(N536),N536,($N$54))/IF(ISNUMBER(N540),N540,1)))*((N545*N535)+N548+N549+N550)","v":0},{"$f":"(IF(AND(O536=0,NOT(ISNUMBER(O534))),0,(O534/60)/IF(ISNUMBER(O536),O536,($O$54))/IF(ISNUMBER(O540),O540,1)))*((O545*O535)+O548+O549+O550)","v":0},{"$f":"(IF(AND(P536=0,NOT(ISNUMBER(P534))),0,(P534/60)/IF(ISNUMBER(P536),P536,($P$54))/IF(ISNUMBER(P540),P540,1)))*((P545*P535)+P548+P549+P550)","v":0},{"$f":"(IF(AND(Q536=0,NOT(ISNUMBER(Q534))),0,(Q534/60)/IF(ISNUMBER(Q536),Q536,($Q$54))/IF(ISNUMBER(Q540),Q540,1)))*((Q545*Q535)+Q548+Q549+Q550)","v":0}]
[null,null,null,"Operation # 5","Operation Description "]
[null,null,null,null,"Equipment Description & Size"]
[null,null,null,null,"Quantity Per Assembly",null,null,1,1,1,1,1,1,1,1,1,1]
[null,null,null,null,"Pieces/Hour     (Strokes/Hour*Pieces Per Cycle)"]
[null,null,null,null,"Pieces Per Cycle - Information Purposes Only"]
[null,null,null,null,"Manufacturing Efficiency %"]
[null,null,null,null,"Standard Hour (With Mfg Efficiency ) (For 1 Piece)",null,null,{"$f":"IF(AND(H541=0,NOT(ISNUMBER(H541))),0,(1/H541)/(IF(AND(ISNUMBER(H543),H543),H543,1)))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Direct Labor Wage Rate"]
[null,null,null,null,"No. of Direct Operators"]
[null,null,null,null,"Direct Labor Cost /Assembly",null,null,{"$f":"IF(AND(H544=\"\",H545=\"\"),0,H544*H545*IF(ISNUMBER(H546),H546,1))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Burden Variable Rate / hr"]
[null,null,null,null,"Burden Fixed Rate / hr"]
[null,null,null,null,"Burden Depreciation Rate / hr"]
[null,null,null,null,"Burden Cost /Assembly",null,null,{"$f":"(H548+H549+H550)*H544","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Sub-Total Cost",null,null,{"$f":"H547+H551","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"H552*H911","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"Set Up # 6","Annual Volume",null,null,{"$f":"H$52","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Set Up Time (Minutes)"]
[null,null,null,null,"# of Set Up Persons"]
[null,null,null,null,"Pieces per Lot",null,null,{"$f":"H54","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Set Up Costs Per Piece",null,null,{"$f":"(IF(AND(H557=0,NOT(ISNUMBER(H555))),0,(H555/60)/IF(ISNUMBER(H557),H557,(H159))/IF(ISNUMBER(H561),H561,1)))*((H566*H556)+H569+H570+H571)","v":0},{"$f":"(IF(AND(I557=0,NOT(ISNUMBER(I555))),0,(I555/60)/IF(ISNUMBER(I557),I557,($I$54))/IF(ISNUMBER(I561),I561,1)))*((I566*I556)+I569+I570+I571)","v":0},{"$f":"(IF(AND(J557=0,NOT(ISNUMBER(J555))),0,(J555/60)/IF(ISNUMBER(J557),J557,($J$54))/IF(ISNUMBER(J561),J561,1)))*((J566*J556)+J569+J570+J571)","v":0},{"$f":"(IF(AND(K557=0,NOT(ISNUMBER(K555))),0,(K555/60)/IF(ISNUMBER(K557),K557,($K$54))/IF(ISNUMBER(K561),K561,1)))*((K566*K556)+K569+K570+K571)","v":0},{"$f":"(IF(AND(L557=0,NOT(ISNUMBER(L555))),0,(L555/60)/IF(ISNUMBER(L557),L557,($L$54))/IF(ISNUMBER(L561),L561,1)))*((L566*L556)+L569+L570+L571)","v":0},{"$f":"(IF(AND(M557=0,NOT(ISNUMBER(M555))),0,(M555/60)/IF(ISNUMBER(M557),M557,($M$54))/IF(ISNUMBER(M561),M561,1)))*((M566*M556)+M569+M570+M571)","v":0},{"$f":"(IF(AND(N557=0,NOT(ISNUMBER(N555))),0,(N555/60)/IF(ISNUMBER(N557),N557,($N$54))/IF(ISNUMBER(N561),N561,1)))*((N566*N556)+N569+N570+N571)","v":0},{"$f":"(IF(AND(O557=0,NOT(ISNUMBER(O555))),0,(O555/60)/IF(ISNUMBER(O557),O557,($O$54))/IF(ISNUMBER(O561),O561,1)))*((O566*O556)+O569+O570+O571)","v":0},{"$f":"(IF(AND(P557=0,NOT(ISNUMBER(P555))),0,(P555/60)/IF(ISNUMBER(P557),P557,($P$54))/IF(ISNUMBER(P561),P561,1)))*((P566*P556)+P569+P570+P571)","v":0},{"$f":"(IF(AND(Q557=0,NOT(ISNUMBER(Q555))),0,(Q555/60)/IF(ISNUMBER(Q557),Q557,($Q$54))/IF(ISNUMBER(Q561),Q561,1)))*((Q566*Q556)+Q569+Q570+Q571)","v":0}]
[null,null,null,"Operation # 6","Operation Description "]
[null,null,null,null,"Equipment Description & Size"]
[null,null,null,null,"Quantity Per Assembly",null,null,1,1,1,1,1,1,1,1,1,1]
[null,null,null,null,"Pieces/Hour     (Strokes/Hour*Pieces Per Cycle)"]
[null,null,null,null,"Pieces Per Cycle - Information Purposes Only"]
[null,null,null,null,"Manufacturing Efficiency %"]
[null,null,null,null,"Standard Hour (With Mfg Efficiency ) (For 1 Piece)",null,null,{"$f":"IF(AND(H562=0,NOT(ISNUMBER(H562))),0,(1/H562)/(IF(AND(ISNUMBER(H564),H564),H564,1)))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Direct Labor Wage Rate"]
[null,null,null,null,"No. of Direct Operators"]
[null,null,null,null,"Direct Labor Cost /Assembly",null,null,{"$f":"IF(AND(H565=\"\",H566=\"\"),0,H565*H566*IF(ISNUMBER(H567),H567,1))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Burden Variable Rate / hr"]
[null,null,null,null,"Burden Fixed Rate / hr"]
[null,null,null,null,"Burden Depreciation Rate / hr"]
[null,null,null,null,"Burden Cost /Assembly",null,null,{"$f":"(H569+H570+H571)*H565","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Sub-Total Cost",null,null,{"$f":"H568+H572","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"H573*H911","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"Set Up # 7","Annual Volume",null,null,{"$f":"H$52","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Set Up Time (Minutes)"]
[null,null,null,null,"# of Set Up Persons"]
[null,null,null,null,"Pieces per Lot",null,null,{"$f":"H54","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Set Up Costs Per Piece",null,null,{"$f":"(IF(AND(H578=0,NOT(ISNUMBER(H576))),0,(H576/60)/IF(ISNUMBER(H578),H578,(H180))/IF(ISNUMBER(H582),H582,1)))*((H587*H577)+H590+H591+H592)","v":0},{"$f":"(IF(AND(I578=0,NOT(ISNUMBER(I576))),0,(I576/60)/IF(ISNUMBER(I578),I578,($I$54))/IF(ISNUMBER(I582),I582,1)))*((I587*I577)+I590+I591+I592)","v":0},{"$f":"(IF(AND(J578=0,NOT(ISNUMBER(J576))),0,(J576/60)/IF(ISNUMBER(J578),J578,($J$54))/IF(ISNUMBER(J582),J582,1)))*((J587*J577)+J590+J591+J592)","v":0},{"$f":"(IF(AND(K578=0,NOT(ISNUMBER(K576))),0,(K576/60)/IF(ISNUMBER(K578),K578,($K$54))/IF(ISNUMBER(K582),K582,1)))*((K587*K577)+K590+K591+K592)","v":0},{"$f":"(IF(AND(L578=0,NOT(ISNUMBER(L576))),0,(L576/60)/IF(ISNUMBER(L578),L578,($L$54))/IF(ISNUMBER(L582),L582,1)))*((L587*L577)+L590+L591+L592)","v":0},{"$f":"(IF(AND(M578=0,NOT(ISNUMBER(M576))),0,(M576/60)/IF(ISNUMBER(M578),M578,($M$54))/IF(ISNUMBER(M582),M582,1)))*((M587*M577)+M590+M591+M592)","v":0},{"$f":"(IF(AND(N578=0,NOT(ISNUMBER(N576))),0,(N576/60)/IF(ISNUMBER(N578),N578,($N$54))/IF(ISNUMBER(N582),N582,1)))*((N587*N577)+N590+N591+N592)","v":0},{"$f":"(IF(AND(O578=0,NOT(ISNUMBER(O576))),0,(O576/60)/IF(ISNUMBER(O578),O578,($O$54))/IF(ISNUMBER(O582),O582,1)))*((O587*O577)+O590+O591+O592)","v":0},{"$f":"(IF(AND(P578=0,NOT(ISNUMBER(P576))),0,(P576/60)/IF(ISNUMBER(P578),P578,($P$54))/IF(ISNUMBER(P582),P582,1)))*((P587*P577)+P590+P591+P592)","v":0},{"$f":"(IF(AND(Q578=0,NOT(ISNUMBER(Q576))),0,(Q576/60)/IF(ISNUMBER(Q578),Q578,($Q$54))/IF(ISNUMBER(Q582),Q582,1)))*((Q587*Q577)+Q590+Q591+Q592)","v":0}]
[null,null,null,"Operation # 7","Operation Description "]
[null,null,null,null,"Equipment Description & Size"]
[null,null,null,null,"Quantity Per Assembly",null,null,1,1,1,1,1,1,1,1,1,1]
[null,null,null,null,"Pieces/Hour     (Strokes/Hour*Pieces Per Cycle)"]
[null,null,null,null,"Pieces Per Cycle - Information Purposes Only"]
[null,null,null,null,"Manufacturing Efficiency %"]
[null,null,null,null,"Standard Hour (With Mfg Efficiency ) (For 1 Piece)",null,null,{"$f":"IF(AND(H583=0,NOT(ISNUMBER(H583))),0,(1/H583)/(IF(AND(ISNUMBER(H585),H585),H585,1)))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Direct Labor Wage Rate"]
[null,null,null,null,"No. of Direct Operators"]
[null,null,null,null,"Direct Labor Cost /Assembly",null,null,{"$f":"IF(AND(H586=\"\",H587=\"\"),0,H586*H587*IF(ISNUMBER(H588),H588,1))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Burden Variable Rate / hr"]
[null,null,null,null,"Burden Fixed Rate / hr"]
[null,null,null,null,"Burden Depreciation Rate / hr"]
[null,null,null,null,"Burden Cost /Assembly",null,null,{"$f":"(H590+H591+H592)*H586","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Sub-Total Cost",null,null,{"$f":"H589+H593","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"H594*H911","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"Set Up # 8","Annual Volume",null,null,{"$f":"H$52","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Set Up Time (Minutes)"]
[null,null,null,null,"# of Set Up Persons"]
[null,null,null,null,"Pieces per Lot",null,null,{"$f":"H54","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Set Up Costs Per Piece",null,null,{"$f":"(IF(AND(H599=0,NOT(ISNUMBER(H597))),0,(H597/60)/IF(ISNUMBER(H599),H599,(H201))/IF(ISNUMBER(H603),H603,1)))*((H608*H598)+H611+H612+H613)","v":0},{"$f":"(IF(AND(I599=0,NOT(ISNUMBER(I597))),0,(I597/60)/IF(ISNUMBER(I599),I599,($I$54))/IF(ISNUMBER(I603),I603,1)))*((I608*I598)+I611+I612+I613)","v":0},{"$f":"(IF(AND(J599=0,NOT(ISNUMBER(J597))),0,(J597/60)/IF(ISNUMBER(J599),J599,($J$54))/IF(ISNUMBER(J603),J603,1)))*((J608*J598)+J611+J612+J613)","v":0},{"$f":"(IF(AND(K599=0,NOT(ISNUMBER(K597))),0,(K597/60)/IF(ISNUMBER(K599),K599,($K$54))/IF(ISNUMBER(K603),K603,1)))*((K608*K598)+K611+K612+K613)","v":0},{"$f":"(IF(AND(L599=0,NOT(ISNUMBER(L597))),0,(L597/60)/IF(ISNUMBER(L599),L599,($L$54))/IF(ISNUMBER(L603),L603,1)))*((L608*L598)+L611+L612+L613)","v":0},{"$f":"(IF(AND(M599=0,NOT(ISNUMBER(M597))),0,(M597/60)/IF(ISNUMBER(M599),M599,($M$54))/IF(ISNUMBER(M603),M603,1)))*((M608*M598)+M611+M612+M613)","v":0},{"$f":"(IF(AND(N599=0,NOT(ISNUMBER(N597))),0,(N597/60)/IF(ISNUMBER(N599),N599,($N$54))/IF(ISNUMBER(N603),N603,1)))*((N608*N598)+N611+N612+N613)","v":0},{"$f":"(IF(AND(O599=0,NOT(ISNUMBER(O597))),0,(O597/60)/IF(ISNUMBER(O599),O599,($O$54))/IF(ISNUMBER(O603),O603,1)))*((O608*O598)+O611+O612+O613)","v":0},{"$f":"(IF(AND(P599=0,NOT(ISNUMBER(P597))),0,(P597/60)/IF(ISNUMBER(P599),P599,($P$54))/IF(ISNUMBER(P603),P603,1)))*((P608*P598)+P611+P612+P613)","v":0},{"$f":"(IF(AND(Q599=0,NOT(ISNUMBER(Q597))),0,(Q597/60)/IF(ISNUMBER(Q599),Q599,($Q$54))/IF(ISNUMBER(Q603),Q603,1)))*((Q608*Q598)+Q611+Q612+Q613)","v":0}]
[null,null,null,"Operation # 8","Operation Description "]
[null,null,null,null,"Equipment Description & Size"]
[null,null,null,null,"Quantity Per Assembly",null,null,1,1,1,1,1,1,1,1,1,1]
[null,null,null,null,"Pieces/Hour     (Strokes/Hour*Pieces Per Cycle)"]
[null,null,null,null,"Pieces Per Cycle - Information Purposes Only"]
[null,null,null,null,"Manufacturing Efficiency %"]
[null,null,null,null,"Standard Hour (With Mfg Efficiency ) (For 1 Piece)",null,null,{"$f":"IF(AND(H604=0,NOT(ISNUMBER(H604))),0,(1/H604)/(IF(AND(ISNUMBER(H606),H606),H606,1)))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Direct Labor Wage Rate"]
[null,null,null,null,"No. of Direct Operators"]
[null,null,null,null,"Direct Labor Cost /Assembly",null,null,{"$f":"IF(AND(H607=\"\",H608=\"\"),0,H607*H608*IF(ISNUMBER(H609),H609,1))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Burden Variable Rate / hr"]
[null,null,null,null,"Burden Fixed Rate / hr"]
[null,null,null,null,"Burden Depreciation Rate / hr"]
[null,null,null,null,"Burden Cost /Assembly",null,null,{"$f":"(H611+H612+H613)*H607","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Sub-Total Cost",null,null,{"$f":"H610+H614","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"H615*H911","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"Set Up # 9","Annual Volume",null,null,{"$f":"H$52","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Set Up Time (Minutes)"]
[null,null,null,null,"# of Set Up Persons"]
[null,null,null,null,"Pieces per Lot",null,null,{"$f":"H54","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Set Up Costs Per Piece",null,null,{"$f":"(IF(AND(H620=0,NOT(ISNUMBER(H618))),0,(H618/60)/IF(ISNUMBER(H620),H620,(H222))/IF(ISNUMBER(H624),H624,1)))*((H629*H619)+H632+H633+H634)","v":0},{"$f":"(IF(AND(I620=0,NOT(ISNUMBER(I618))),0,(I618/60)/IF(ISNUMBER(I620),I620,($I$54))/IF(ISNUMBER(I624),I624,1)))*((I629*I619)+I632+I633+I634)","v":0},{"$f":"(IF(AND(J620=0,NOT(ISNUMBER(J618))),0,(J618/60)/IF(ISNUMBER(J620),J620,($J$54))/IF(ISNUMBER(J624),J624,1)))*((J629*J619)+J632+J633+J634)","v":0},{"$f":"(IF(AND(K620=0,NOT(ISNUMBER(K618))),0,(K618/60)/IF(ISNUMBER(K620),K620,($K$54))/IF(ISNUMBER(K624),K624,1)))*((K629*K619)+K632+K633+K634)","v":0},{"$f":"(IF(AND(L620=0,NOT(ISNUMBER(L618))),0,(L618/60)/IF(ISNUMBER(L620),L620,($L$54))/IF(ISNUMBER(L624),L624,1)))*((L629*L619)+L632+L633+L634)","v":0},{"$f":"(IF(AND(M620=0,NOT(ISNUMBER(M618))),0,(M618/60)/IF(ISNUMBER(M620),M620,($M$54))/IF(ISNUMBER(M624),M624,1)))*((M629*M619)+M632+M633+M634)","v":0},{"$f":"(IF(AND(N620=0,NOT(ISNUMBER(N618))),0,(N618/60)/IF(ISNUMBER(N620),N620,($N$54))/IF(ISNUMBER(N624),N624,1)))*((N629*N619)+N632+N633+N634)","v":0},{"$f":"(IF(AND(O620=0,NOT(ISNUMBER(O618))),0,(O618/60)/IF(ISNUMBER(O620),O620,($O$54))/IF(ISNUMBER(O624),O624,1)))*((O629*O619)+O632+O633+O634)","v":0},{"$f":"(IF(AND(P620=0,NOT(ISNUMBER(P618))),0,(P618/60)/IF(ISNUMBER(P620),P620,($P$54))/IF(ISNUMBER(P624),P624,1)))*((P629*P619)+P632+P633+P634)","v":0},{"$f":"(IF(AND(Q620=0,NOT(ISNUMBER(Q618))),0,(Q618/60)/IF(ISNUMBER(Q620),Q620,($Q$54))/IF(ISNUMBER(Q624),Q624,1)))*((Q629*Q619)+Q632+Q633+Q634)","v":0}]
[null,null,null,"Operation # 9","Operation Description "]
[null,null,null,null,"Equipment Description & Size"]
[null,null,null,null,"Quantity Per Assembly",null,null,1,1,1,1,1,1,1,1,1,1]
[null,null,null,null,"Pieces/Hour     (Strokes/Hour*Pieces Per Cycle)"]
[null,null,null,null,"Pieces Per Cycle - Information Purposes Only"]
[null,null,null,null,"Manufacturing Efficiency %"]
[null,null,null,null,"Standard Hour (With Mfg Efficiency ) (For 1 Piece)",null,null,{"$f":"IF(AND(H625=0,NOT(ISNUMBER(H625))),0,(1/H625)/(IF(AND(ISNUMBER(H627),H627),H627,1)))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Direct Labor Wage Rate"]
[null,null,null,null,"No. of Direct Operators"]
[null,null,null,null,"Direct Labor Cost /Assembly",null,null,{"$f":"IF(AND(H628=\"\",H629=\"\"),0,H628*H629*IF(ISNUMBER(H630),H630,1))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Burden Variable Rate / hr"]
[null,null,null,null,"Burden Fixed Rate / hr"]
[null,null,null,null,"Burden Depreciation Rate / hr"]
[null,null,null,null,"Burden Cost /Assembly",null,null,{"$f":"(H632+H633+H634)*H628","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Sub-Total Cost",null,null,{"$f":"H631+H635","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"H636*H911","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"Set Up # 10","Annual Volume",null,null,{"$f":"H$52","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Set Up Time (Minutes)"]
[null,null,null,null,"# of Set Up Persons"]
[null,null,null,null,"Pieces per Lot",null,null,{"$f":"H54","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Set Up Costs Per Piece",null,null,{"$f":"(IF(AND(H641=0,NOT(ISNUMBER(H639))),0,(H639/60)/IF(ISNUMBER(H641),H641,(H243))/IF(ISNUMBER(H645),H645,1)))*((H650*H640)+H653+H654+H655)","v":0},{"$f":"(IF(AND(I641=0,NOT(ISNUMBER(I639))),0,(I639/60)/IF(ISNUMBER(I641),I641,($I$54))/IF(ISNUMBER(I645),I645,1)))*((I650*I640)+I653+I654+I655)","v":0},{"$f":"(IF(AND(J641=0,NOT(ISNUMBER(J639))),0,(J639/60)/IF(ISNUMBER(J641),J641,($J$54))/IF(ISNUMBER(J645),J645,1)))*((J650*J640)+J653+J654+J655)","v":0},{"$f":"(IF(AND(K641=0,NOT(ISNUMBER(K639))),0,(K639/60)/IF(ISNUMBER(K641),K641,($K$54))/IF(ISNUMBER(K645),K645,1)))*((K650*K640)+K653+K654+K655)","v":0},{"$f":"(IF(AND(L641=0,NOT(ISNUMBER(L639))),0,(L639/60)/IF(ISNUMBER(L641),L641,($L$54))/IF(ISNUMBER(L645),L645,1)))*((L650*L640)+L653+L654+L655)","v":0},{"$f":"(IF(AND(M641=0,NOT(ISNUMBER(M639))),0,(M639/60)/IF(ISNUMBER(M641),M641,($M$54))/IF(ISNUMBER(M645),M645,1)))*((M650*M640)+M653+M654+M655)","v":0},{"$f":"(IF(AND(N641=0,NOT(ISNUMBER(N639))),0,(N639/60)/IF(ISNUMBER(N641),N641,($N$54))/IF(ISNUMBER(N645),N645,1)))*((N650*N640)+N653+N654+N655)","v":0},{"$f":"(IF(AND(O641=0,NOT(ISNUMBER(O639))),0,(O639/60)/IF(ISNUMBER(O641),O641,($O$54))/IF(ISNUMBER(O645),O645,1)))*((O650*O640)+O653+O654+O655)","v":0},{"$f":"(IF(AND(P641=0,NOT(ISNUMBER(P639))),0,(P639/60)/IF(ISNUMBER(P641),P641,($P$54))/IF(ISNUMBER(P645),P645,1)))*((P650*P640)+P653+P654+P655)","v":0},{"$f":"(IF(AND(Q641=0,NOT(ISNUMBER(Q639))),0,(Q639/60)/IF(ISNUMBER(Q641),Q641,($Q$54))/IF(ISNUMBER(Q645),Q645,1)))*((Q650*Q640)+Q653+Q654+Q655)","v":0}]
[null,null,null,"Operation # 10","Operation Description "]
[null,null,null,null,"Equipment Description & Size"]
[null,null,null,null,"Quantity Per Assembly",null,null,1,1,1,1,1,1,1,1,1,1]
[null,null,null,null,"Pieces/Hour     (Strokes/Hour*Pieces Per Cycle)"]
[null,null,null,null,"Pieces Per Cycle - Information Purposes Only"]
[null,null,null,null,"Manufacturing Efficiency %"]
[null,null,null,null,"Standard Hour (With Mfg Efficiency ) (For 1 Piece)",null,null,{"$f":"IF(AND(H646=0,NOT(ISNUMBER(H646))),0,(1/H646)/(IF(AND(ISNUMBER(H648),H648),H648,1)))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Direct Labor Wage Rate"]
[null,null,null,null,"No. of Direct Operators"]
[null,null,null,null,"Direct Labor Cost /Assembly",null,null,{"$f":"IF(AND(H649=\"\",H650=\"\"),0,H649*H650*IF(ISNUMBER(H651),H651,1))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Burden Variable Rate / hr"]
[null,null,null,null,"Burden Fixed Rate / hr"]
[null,null,null,null,"Burden Depreciation Rate / hr"]
[null,null,null,null,"Burden Cost /Assembly",null,null,{"$f":"(H653+H654+H655)*H649","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Sub-Total Cost",null,null,{"$f":"H652+H656","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"H657*H911","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"Set Up # 11","Annual Volume",null,null,{"$f":"H$52","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Set Up Time (Minutes)"]
[null,null,null,null,"# of Set Up Persons"]
[null,null,null,null,"Pieces per Lot",null,null,{"$f":"H54","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Set Up Costs Per Piece",null,null,{"$f":"(IF(AND(H662=0,NOT(ISNUMBER(H660))),0,(H660/60)/IF(ISNUMBER(H662),H662,(H264))/IF(ISNUMBER(H666),H666,1)))*((H671*H661)+H674+H675+H676)","v":0},{"$f":"(IF(AND(I662=0,NOT(ISNUMBER(I660))),0,(I660/60)/IF(ISNUMBER(I662),I662,($I$54))/IF(ISNUMBER(I666),I666,1)))*((I671*I661)+I674+I675+I676)","v":0},{"$f":"(IF(AND(J662=0,NOT(ISNUMBER(J660))),0,(J660/60)/IF(ISNUMBER(J662),J662,($J$54))/IF(ISNUMBER(J666),J666,1)))*((J671*J661)+J674+J675+J676)","v":0},{"$f":"(IF(AND(K662=0,NOT(ISNUMBER(K660))),0,(K660/60)/IF(ISNUMBER(K662),K662,($K$54))/IF(ISNUMBER(K666),K666,1)))*((K671*K661)+K674+K675+K676)","v":0},{"$f":"(IF(AND(L662=0,NOT(ISNUMBER(L660))),0,(L660/60)/IF(ISNUMBER(L662),L662,($L$54))/IF(ISNUMBER(L666),L666,1)))*((L671*L661)+L674+L675+L676)","v":0},{"$f":"(IF(AND(M662=0,NOT(ISNUMBER(M660))),0,(M660/60)/IF(ISNUMBER(M662),M662,($M$54))/IF(ISNUMBER(M666),M666,1)))*((M671*M661)+M674+M675+M676)","v":0},{"$f":"(IF(AND(N662=0,NOT(ISNUMBER(N660))),0,(N660/60)/IF(ISNUMBER(N662),N662,($N$54))/IF(ISNUMBER(N666),N666,1)))*((N671*N661)+N674+N675+N676)","v":0},{"$f":"(IF(AND(O662=0,NOT(ISNUMBER(O660))),0,(O660/60)/IF(ISNUMBER(O662),O662,($O$54))/IF(ISNUMBER(O666),O666,1)))*((O671*O661)+O674+O675+O676)","v":0},{"$f":"(IF(AND(P662=0,NOT(ISNUMBER(P660))),0,(P660/60)/IF(ISNUMBER(P662),P662,($P$54))/IF(ISNUMBER(P666),P666,1)))*((P671*P661)+P674+P675+P676)","v":0},{"$f":"(IF(AND(Q662=0,NOT(ISNUMBER(Q660))),0,(Q660/60)/IF(ISNUMBER(Q662),Q662,($Q$54))/IF(ISNUMBER(Q666),Q666,1)))*((Q671*Q661)+Q674+Q675+Q676)","v":0}]
[null,null,null,"Operation # 11","Operation Description "]
[null,null,null,null,"Equipment Description & Size"]
[null,null,null,null,"Quantity Per Assembly",null,null,1,1,1,1,1,1,1,1,1,1]
[null,null,null,null,"Pieces/Hour     (Strokes/Hour*Pieces Per Cycle)"]
[null,null,null,null,"Pieces Per Cycle - Information Purposes Only"]
[null,null,null,null,"Manufacturing Efficiency %"]
[null,null,null,null,"Standard Hour (With Mfg Efficiency ) (For 1 Piece)",null,null,{"$f":"IF(AND(H667=0,NOT(ISNUMBER(H667))),0,(1/H667)/(IF(AND(ISNUMBER(H669),H669),H669,1)))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Direct Labor Wage Rate"]
[null,null,null,null,"No. of Direct Operators"]
[null,null,null,null,"Direct Labor Cost /Assembly",null,null,{"$f":"IF(AND(H670=\"\",H671=\"\"),0,H670*H671*IF(ISNUMBER(H672),H672,1))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Burden Variable Rate / hr"]
[null,null,null,null,"Burden Fixed Rate / hr"]
[null,null,null,null,"Burden Depreciation Rate / hr"]
[null,null,null,null,"Burden Cost /Assembly",null,null,{"$f":"(H674+H675+H676)*H670","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Sub-Total Cost",null,null,{"$f":"H673+H677","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"H678*H911","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"Set Up # 12","Annual Volume",null,null,{"$f":"H$52","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Set Up Time (Minutes)"]
[null,null,null,null,"# of Set Up Persons"]
[null,null,null,null,"Pieces per Lot",null,null,{"$f":"H54","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Set Up Costs Per Piece",null,null,{"$f":"(IF(AND(H683=0,NOT(ISNUMBER(H681))),0,(H681/60)/IF(ISNUMBER(H683),H683,(H285))/IF(ISNUMBER(H687),H687,1)))*((H692*H682)+H695+H696+H697)","v":0},{"$f":"(IF(AND(I683=0,NOT(ISNUMBER(I681))),0,(I681/60)/IF(ISNUMBER(I683),I683,($I$54))/IF(ISNUMBER(I687),I687,1)))*((I692*I682)+I695+I696+I697)","v":0},{"$f":"(IF(AND(J683=0,NOT(ISNUMBER(J681))),0,(J681/60)/IF(ISNUMBER(J683),J683,($J$54))/IF(ISNUMBER(J687),J687,1)))*((J692*J682)+J695+J696+J697)","v":0},{"$f":"(IF(AND(K683=0,NOT(ISNUMBER(K681))),0,(K681/60)/IF(ISNUMBER(K683),K683,($K$54))/IF(ISNUMBER(K687),K687,1)))*((K692*K682)+K695+K696+K697)","v":0},{"$f":"(IF(AND(L683=0,NOT(ISNUMBER(L681))),0,(L681/60)/IF(ISNUMBER(L683),L683,($L$54))/IF(ISNUMBER(L687),L687,1)))*((L692*L682)+L695+L696+L697)","v":0},{"$f":"(IF(AND(M683=0,NOT(ISNUMBER(M681))),0,(M681/60)/IF(ISNUMBER(M683),M683,($M$54))/IF(ISNUMBER(M687),M687,1)))*((M692*M682)+M695+M696+M697)","v":0},{"$f":"(IF(AND(N683=0,NOT(ISNUMBER(N681))),0,(N681/60)/IF(ISNUMBER(N683),N683,($N$54))/IF(ISNUMBER(N687),N687,1)))*((N692*N682)+N695+N696+N697)","v":0},{"$f":"(IF(AND(O683=0,NOT(ISNUMBER(O681))),0,(O681/60)/IF(ISNUMBER(O683),O683,($O$54))/IF(ISNUMBER(O687),O687,1)))*((O692*O682)+O695+O696+O697)","v":0},{"$f":"(IF(AND(P683=0,NOT(ISNUMBER(P681))),0,(P681/60)/IF(ISNUMBER(P683),P683,($P$54))/IF(ISNUMBER(P687),P687,1)))*((P692*P682)+P695+P696+P697)","v":0},{"$f":"(IF(AND(Q683=0,NOT(ISNUMBER(Q681))),0,(Q681/60)/IF(ISNUMBER(Q683),Q683,($Q$54))/IF(ISNUMBER(Q687),Q687,1)))*((Q692*Q682)+Q695+Q696+Q697)","v":0}]
[null,null,null,"Operation # 12","Operation Description "]
[null,null,null,null,"Equipment Description & Size"]
[null,null,null,null,"Quantity Per Assembly",null,null,1,1,1,1,1,1,1,1,1,1]
[null,null,null,null,"Pieces/Hour     (Strokes/Hour*Pieces Per Cycle)"]
[null,null,null,null,"Pieces Per Cycle - Information Purposes Only"]
[null,null,null,null,"Manufacturing Efficiency %"]
[null,null,null,null,"Standard Hour (With Mfg Efficiency ) (For 1 Piece)",null,null,{"$f":"IF(AND(H688=0,NOT(ISNUMBER(H688))),0,(1/H688)/(IF(AND(ISNUMBER(H690),H690),H690,1)))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Direct Labor Wage Rate"]
[null,null,null,null,"No. of Direct Operators"]
[null,null,null,null,"Direct Labor Cost /Assembly",null,null,{"$f":"IF(AND(H691=\"\",H692=\"\"),0,H691*H692*IF(ISNUMBER(H693),H693,1))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Burden Variable Rate / hr"]
[null,null,null,null,"Burden Fixed Rate / hr"]
[null,null,null,null,"Burden Depreciation Rate / hr"]
[null,null,null,null,"Burden Cost /Assembly",null,null,{"$f":"(H695+H696+H697)*H691","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Sub-Total Cost",null,null,{"$f":"H694+H698","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"H699*H911","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"Set Up # 13","Annual Volume",null,null,{"$f":"H$52","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Set Up Time (Minutes)"]
[null,null,null,null,"# of Set Up Persons"]
[null,null,null,null,"Pieces per Lot",null,null,{"$f":"H54","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Set Up Costs Per Piece",null,null,{"$f":"(IF(AND(H704=0,NOT(ISNUMBER(H702))),0,(H702/60)/IF(ISNUMBER(H704),H704,(H306))/IF(ISNUMBER(H708),H708,1)))*((H713*H703)+H716+H717+H718)","v":0},{"$f":"(IF(AND(I704=0,NOT(ISNUMBER(I702))),0,(I702/60)/IF(ISNUMBER(I704),I704,($I$54))/IF(ISNUMBER(I708),I708,1)))*((I713*I703)+I716+I717+I718)","v":0},{"$f":"(IF(AND(J704=0,NOT(ISNUMBER(J702))),0,(J702/60)/IF(ISNUMBER(J704),J704,($J$54))/IF(ISNUMBER(J708),J708,1)))*((J713*J703)+J716+J717+J718)","v":0},{"$f":"(IF(AND(K704=0,NOT(ISNUMBER(K702))),0,(K702/60)/IF(ISNUMBER(K704),K704,($K$54))/IF(ISNUMBER(K708),K708,1)))*((K713*K703)+K716+K717+K718)","v":0},{"$f":"(IF(AND(L704=0,NOT(ISNUMBER(L702))),0,(L702/60)/IF(ISNUMBER(L704),L704,($L$54))/IF(ISNUMBER(L708),L708,1)))*((L713*L703)+L716+L717+L718)","v":0},{"$f":"(IF(AND(M704=0,NOT(ISNUMBER(M702))),0,(M702/60)/IF(ISNUMBER(M704),M704,($M$54))/IF(ISNUMBER(M708),M708,1)))*((M713*M703)+M716+M717+M718)","v":0},{"$f":"(IF(AND(N704=0,NOT(ISNUMBER(N702))),0,(N702/60)/IF(ISNUMBER(N704),N704,($N$54))/IF(ISNUMBER(N708),N708,1)))*((N713*N703)+N716+N717+N718)","v":0},{"$f":"(IF(AND(O704=0,NOT(ISNUMBER(O702))),0,(O702/60)/IF(ISNUMBER(O704),O704,($O$54))/IF(ISNUMBER(O708),O708,1)))*((O713*O703)+O716+O717+O718)","v":0},{"$f":"(IF(AND(P704=0,NOT(ISNUMBER(P702))),0,(P702/60)/IF(ISNUMBER(P704),P704,($P$54))/IF(ISNUMBER(P708),P708,1)))*((P713*P703)+P716+P717+P718)","v":0},{"$f":"(IF(AND(Q704=0,NOT(ISNUMBER(Q702))),0,(Q702/60)/IF(ISNUMBER(Q704),Q704,($Q$54))/IF(ISNUMBER(Q708),Q708,1)))*((Q713*Q703)+Q716+Q717+Q718)","v":0}]
[null,null,null,"Operation # 13","Operation Description "]
[null,null,null,null,"Equipment Description & Size"]
[null,null,null,null,"Quantity Per Assembly",null,null,1,1,1,1,1,1,1,1,1,1]
[null,null,null,null,"Pieces/Hour     (Strokes/Hour*Pieces Per Cycle)"]
[null,null,null,null,"Pieces Per Cycle - Information Purposes Only"]
[null,null,null,null,"Manufacturing Efficiency %"]
[null,null,null,null,"Standard Hour (With Mfg Efficiency ) (For 1 Piece)",null,null,{"$f":"IF(AND(H709=0,NOT(ISNUMBER(H709))),0,(1/H709)/(IF(AND(ISNUMBER(H711),H711),H711,1)))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Direct Labor Wage Rate"]
[null,null,null,null,"No. of Direct Operators"]
[null,null,null,null,"Direct Labor Cost /Assembly",null,null,{"$f":"IF(AND(H712=\"\",H713=\"\"),0,H712*H713*IF(ISNUMBER(H714),H714,1))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Burden Variable Rate / hr"]
[null,null,null,null,"Burden Fixed Rate / hr"]
[null,null,null,null,"Burden Depreciation Rate / hr"]
[null,null,null,null,"Burden Cost /Assembly",null,null,{"$f":"(H716+H717+H718)*H712","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Sub-Total Cost",null,null,{"$f":"H715+H719","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"H720*H911","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"Set Up # 14","Annual Volume",null,null,{"$f":"H$52","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Set Up Time (Minutes)"]
[null,null,null,null,"# of Set Up Persons"]
[null,null,null,null,"Pieces per Lot",null,null,{"$f":"H54","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Set Up Costs Per Piece",null,null,{"$f":"(IF(AND(H725=0,NOT(ISNUMBER(H723))),0,(H723/60)/IF(ISNUMBER(H725),H725,(H327))/IF(ISNUMBER(H729),H729,1)))*((H734*H724)+H737+H738+H739)","v":0},{"$f":"(IF(AND(I725=0,NOT(ISNUMBER(I723))),0,(I723/60)/IF(ISNUMBER(I725),I725,($I$54))/IF(ISNUMBER(I729),I729,1)))*((I734*I724)+I737+I738+I739)","v":0},{"$f":"(IF(AND(J725=0,NOT(ISNUMBER(J723))),0,(J723/60)/IF(ISNUMBER(J725),J725,($J$54))/IF(ISNUMBER(J729),J729,1)))*((J734*J724)+J737+J738+J739)","v":0},{"$f":"(IF(AND(K725=0,NOT(ISNUMBER(K723))),0,(K723/60)/IF(ISNUMBER(K725),K725,($K$54))/IF(ISNUMBER(K729),K729,1)))*((K734*K724)+K737+K738+K739)","v":0},{"$f":"(IF(AND(L725=0,NOT(ISNUMBER(L723))),0,(L723/60)/IF(ISNUMBER(L725),L725,($L$54))/IF(ISNUMBER(L729),L729,1)))*((L734*L724)+L737+L738+L739)","v":0},{"$f":"(IF(AND(M725=0,NOT(ISNUMBER(M723))),0,(M723/60)/IF(ISNUMBER(M725),M725,($M$54))/IF(ISNUMBER(M729),M729,1)))*((M734*M724)+M737+M738+M739)","v":0},{"$f":"(IF(AND(N725=0,NOT(ISNUMBER(N723))),0,(N723/60)/IF(ISNUMBER(N725),N725,($N$54))/IF(ISNUMBER(N729),N729,1)))*((N734*N724)+N737+N738+N739)","v":0},{"$f":"(IF(AND(O725=0,NOT(ISNUMBER(O723))),0,(O723/60)/IF(ISNUMBER(O725),O725,($O$54))/IF(ISNUMBER(O729),O729,1)))*((O734*O724)+O737+O738+O739)","v":0},{"$f":"(IF(AND(P725=0,NOT(ISNUMBER(P723))),0,(P723/60)/IF(ISNUMBER(P725),P725,($P$54))/IF(ISNUMBER(P729),P729,1)))*((P734*P724)+P737+P738+P739)","v":0},{"$f":"(IF(AND(Q725=0,NOT(ISNUMBER(Q723))),0,(Q723/60)/IF(ISNUMBER(Q725),Q725,($Q$54))/IF(ISNUMBER(Q729),Q729,1)))*((Q734*Q724)+Q737+Q738+Q739)","v":0}]
[null,null,null,"Operation # 14","Operation Description "]
[null,null,null,null,"Equipment Description & Size"]
[null,null,null,null,"Quantity Per Assembly",null,null,1,1,1,1,1,1,1,1,1,1]
[null,null,null,null,"Pieces/Hour     (Strokes/Hour*Pieces Per Cycle)"]
[null,null,null,null,"Pieces Per Cycle - Information Purposes Only"]
[null,null,null,null,"Manufacturing Efficiency %"]
[null,null,null,null,"Standard Hour (With Mfg Efficiency ) (For 1 Piece)",null,null,{"$f":"IF(AND(H730=0,NOT(ISNUMBER(H730))),0,(1/H730)/(IF(AND(ISNUMBER(H732),H732),H732,1)))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Direct Labor Wage Rate"]
[null,null,null,null,"No. of Direct Operators"]
[null,null,null,null,"Direct Labor Cost /Assembly",null,null,{"$f":"IF(AND(H733=\"\",H734=\"\"),0,H733*H734*IF(ISNUMBER(H735),H735,1))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Burden Variable Rate / hr"]
[null,null,null,null,"Burden Fixed Rate / hr"]
[null,null,null,null,"Burden Depreciation Rate / hr"]
[null,null,null,null,"Burden Cost /Assembly",null,null,{"$f":"(H737+H738+H739)*H733","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Sub-Total Cost",null,null,{"$f":"H736+H740","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"H741*H911","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"Set Up # 15","Annual Volume",null,null,{"$f":"H$52","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Set Up Time (Minutes)"]
[null,null,null,null,"# of Set Up Persons"]
[null,null,null,null,"Pieces per Lot",null,null,{"$f":"H54","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Set Up Costs Per Piece",null,null,{"$f":"(IF(AND(H746=0,NOT(ISNUMBER(H744))),0,(H744/60)/IF(ISNUMBER(H746),H746,(H348))/IF(ISNUMBER(H750),H750,1)))*((H755*H745)+H758+H759+H760)","v":0},{"$f":"(IF(AND(I746=0,NOT(ISNUMBER(I744))),0,(I744/60)/IF(ISNUMBER(I746),I746,($I$54))/IF(ISNUMBER(I750),I750,1)))*((I755*I745)+I758+I759+I760)","v":0},{"$f":"(IF(AND(J746=0,NOT(ISNUMBER(J744))),0,(J744/60)/IF(ISNUMBER(J746),J746,($J$54))/IF(ISNUMBER(J750),J750,1)))*((J755*J745)+J758+J759+J760)","v":0},{"$f":"(IF(AND(K746=0,NOT(ISNUMBER(K744))),0,(K744/60)/IF(ISNUMBER(K746),K746,($K$54))/IF(ISNUMBER(K750),K750,1)))*((K755*K745)+K758+K759+K760)","v":0},{"$f":"(IF(AND(L746=0,NOT(ISNUMBER(L744))),0,(L744/60)/IF(ISNUMBER(L746),L746,($L$54))/IF(ISNUMBER(L750),L750,1)))*((L755*L745)+L758+L759+L760)","v":0},{"$f":"(IF(AND(M746=0,NOT(ISNUMBER(M744))),0,(M744/60)/IF(ISNUMBER(M746),M746,($M$54))/IF(ISNUMBER(M750),M750,1)))*((M755*M745)+M758+M759+M760)","v":0},{"$f":"(IF(AND(N746=0,NOT(ISNUMBER(N744))),0,(N744/60)/IF(ISNUMBER(N746),N746,($N$54))/IF(ISNUMBER(N750),N750,1)))*((N755*N745)+N758+N759+N760)","v":0},{"$f":"(IF(AND(O746=0,NOT(ISNUMBER(O744))),0,(O744/60)/IF(ISNUMBER(O746),O746,($O$54))/IF(ISNUMBER(O750),O750,1)))*((O755*O745)+O758+O759+O760)","v":0},{"$f":"(IF(AND(P746=0,NOT(ISNUMBER(P744))),0,(P744/60)/IF(ISNUMBER(P746),P746,($P$54))/IF(ISNUMBER(P750),P750,1)))*((P755*P745)+P758+P759+P760)","v":0},{"$f":"(IF(AND(Q746=0,NOT(ISNUMBER(Q744))),0,(Q744/60)/IF(ISNUMBER(Q746),Q746,($Q$54))/IF(ISNUMBER(Q750),Q750,1)))*((Q755*Q745)+Q758+Q759+Q760)","v":0}]
[null,null,null,"Operation # 15","Operation Description "]
[null,null,null,null,"Equipment Description & Size"]
[null,null,null,null,"Quantity Per Assembly",null,null,1,1,1,1,1,1,1,1,1,1]
[null,null,null,null,"Pieces/Hour     (Strokes/Hour*Pieces Per Cycle)"]
[null,null,null,null,"Pieces Per Cycle - Information Purposes Only"]
[null,null,null,null,"Manufacturing Efficiency %"]
[null,null,null,null,"Standard Hour (With Mfg Efficiency ) (For 1 Piece)",null,null,{"$f":"IF(AND(H751=0,NOT(ISNUMBER(H751))),0,(1/H751)/(IF(AND(ISNUMBER(H753),H753),H753,1)))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Direct Labor Wage Rate"]
[null,null,null,null,"No. of Direct Operators"]
[null,null,null,null,"Direct Labor Cost /Assembly",null,null,{"$f":"IF(AND(H754=\"\",H755=\"\"),0,H754*H755*IF(ISNUMBER(H756),H756,1))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Burden Variable Rate / hr"]
[null,null,null,null,"Burden Fixed Rate / hr"]
[null,null,null,null,"Burden Depreciation Rate / hr"]
[null,null,null,null,"Burden Cost /Assembly",null,null,{"$f":"(H758+H759+H760)*H754","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Sub-Total Cost",null,null,{"$f":"H757+H761","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"H762*H911","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"Set Up # 16","Annual Volume",null,null,{"$f":"H$52","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Set Up Time (Minutes)"]
[null,null,null,null,"# of Set Up Persons"]
[null,null,null,null,"Pieces per Lot",null,null,{"$f":"H54","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Set Up Costs Per Piece",null,null,{"$f":"(IF(AND(H767=0,NOT(ISNUMBER(H765))),0,(H765/60)/IF(ISNUMBER(H767),H767,(H369))/IF(ISNUMBER(H771),H771,1)))*((H776*H766)+H779+H780+H781)","v":0},{"$f":"(IF(AND(I767=0,NOT(ISNUMBER(I765))),0,(I765/60)/IF(ISNUMBER(I767),I767,($I$54))/IF(ISNUMBER(I771),I771,1)))*((I776*I766)+I779+I780+I781)","v":0},{"$f":"(IF(AND(J767=0,NOT(ISNUMBER(J765))),0,(J765/60)/IF(ISNUMBER(J767),J767,($J$54))/IF(ISNUMBER(J771),J771,1)))*((J776*J766)+J779+J780+J781)","v":0},{"$f":"(IF(AND(K767=0,NOT(ISNUMBER(K765))),0,(K765/60)/IF(ISNUMBER(K767),K767,($K$54))/IF(ISNUMBER(K771),K771,1)))*((K776*K766)+K779+K780+K781)","v":0},{"$f":"(IF(AND(L767=0,NOT(ISNUMBER(L765))),0,(L765/60)/IF(ISNUMBER(L767),L767,($L$54))/IF(ISNUMBER(L771),L771,1)))*((L776*L766)+L779+L780+L781)","v":0},{"$f":"(IF(AND(M767=0,NOT(ISNUMBER(M765))),0,(M765/60)/IF(ISNUMBER(M767),M767,($M$54))/IF(ISNUMBER(M771),M771,1)))*((M776*M766)+M779+M780+M781)","v":0},{"$f":"(IF(AND(N767=0,NOT(ISNUMBER(N765))),0,(N765/60)/IF(ISNUMBER(N767),N767,($N$54))/IF(ISNUMBER(N771),N771,1)))*((N776*N766)+N779+N780+N781)","v":0},{"$f":"(IF(AND(O767=0,NOT(ISNUMBER(O765))),0,(O765/60)/IF(ISNUMBER(O767),O767,($O$54))/IF(ISNUMBER(O771),O771,1)))*((O776*O766)+O779+O780+O781)","v":0},{"$f":"(IF(AND(P767=0,NOT(ISNUMBER(P765))),0,(P765/60)/IF(ISNUMBER(P767),P767,($P$54))/IF(ISNUMBER(P771),P771,1)))*((P776*P766)+P779+P780+P781)","v":0},{"$f":"(IF(AND(Q767=0,NOT(ISNUMBER(Q765))),0,(Q765/60)/IF(ISNUMBER(Q767),Q767,($Q$54))/IF(ISNUMBER(Q771),Q771,1)))*((Q776*Q766)+Q779+Q780+Q781)","v":0}]
[null,null,null,"Operation # 16","Operation Description "]
[null,null,null,null,"Equipment Description & Size"]
[null,null,null,null,"Quantity Per Assembly",null,null,1,1,1,1,1,1,1,1,1,1]
[null,null,null,null,"Pieces/Hour     (Strokes/Hour*Pieces Per Cycle)"]
[null,null,null,null,"Pieces Per Cycle - Information Purposes Only"]
[null,null,null,null,"Manufacturing Efficiency %"]
[null,null,null,null,"Standard Hour (With Mfg Efficiency ) (For 1 Piece)",null,null,{"$f":"IF(AND(H772=0,NOT(ISNUMBER(H772))),0,(1/H772)/(IF(AND(ISNUMBER(H774),H774),H774,1)))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Direct Labor Wage Rate"]
[null,null,null,null,"No. of Direct Operators"]
[null,null,null,null,"Direct Labor Cost /Assembly",null,null,{"$f":"IF(AND(H775=\"\",H776=\"\"),0,H775*H776*IF(ISNUMBER(H777),H777,1))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Burden Variable Rate / hr"]
[null,null,null,null,"Burden Fixed Rate / hr"]
[null,null,null,null,"Burden Depreciation Rate / hr"]
[null,null,null,null,"Burden Cost /Assembly",null,null,{"$f":"(H779+H780+H781)*H775","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Sub-Total Cost",null,null,{"$f":"H778+H782","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"H783*H911","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"Set Up # 17","Annual Volume",null,null,{"$f":"H$52","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Set Up Time (Minutes)"]
[null,null,null,null,"# of Set Up Persons"]
[null,null,null,null,"Pieces per Lot",null,null,{"$f":"H54","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Set Up Costs Per Piece",null,null,{"$f":"(IF(AND(H788=0,NOT(ISNUMBER(H786))),0,(H786/60)/IF(ISNUMBER(H788),H788,(H390))/IF(ISNUMBER(H792),H792,1)))*((H797*H787)+H800+H801+H802)","v":0},{"$f":"(IF(AND(I788=0,NOT(ISNUMBER(I786))),0,(I786/60)/IF(ISNUMBER(I788),I788,($I$54))/IF(ISNUMBER(I792),I792,1)))*((I797*I787)+I800+I801+I802)","v":0},{"$f":"(IF(AND(J788=0,NOT(ISNUMBER(J786))),0,(J786/60)/IF(ISNUMBER(J788),J788,($J$54))/IF(ISNUMBER(J792),J792,1)))*((J797*J787)+J800+J801+J802)","v":0},{"$f":"(IF(AND(K788=0,NOT(ISNUMBER(K786))),0,(K786/60)/IF(ISNUMBER(K788),K788,($K$54))/IF(ISNUMBER(K792),K792,1)))*((K797*K787)+K800+K801+K802)","v":0},{"$f":"(IF(AND(L788=0,NOT(ISNUMBER(L786))),0,(L786/60)/IF(ISNUMBER(L788),L788,($L$54))/IF(ISNUMBER(L792),L792,1)))*((L797*L787)+L800+L801+L802)","v":0},{"$f":"(IF(AND(M788=0,NOT(ISNUMBER(M786))),0,(M786/60)/IF(ISNUMBER(M788),M788,($M$54))/IF(ISNUMBER(M792),M792,1)))*((M797*M787)+M800+M801+M802)","v":0},{"$f":"(IF(AND(N788=0,NOT(ISNUMBER(N786))),0,(N786/60)/IF(ISNUMBER(N788),N788,($N$54))/IF(ISNUMBER(N792),N792,1)))*((N797*N787)+N800+N801+N802)","v":0},{"$f":"(IF(AND(O788=0,NOT(ISNUMBER(O786))),0,(O786/60)/IF(ISNUMBER(O788),O788,($O$54))/IF(ISNUMBER(O792),O792,1)))*((O797*O787)+O800+O801+O802)","v":0},{"$f":"(IF(AND(P788=0,NOT(ISNUMBER(P786))),0,(P786/60)/IF(ISNUMBER(P788),P788,($P$54))/IF(ISNUMBER(P792),P792,1)))*((P797*P787)+P800+P801+P802)","v":0},{"$f":"(IF(AND(Q788=0,NOT(ISNUMBER(Q786))),0,(Q786/60)/IF(ISNUMBER(Q788),Q788,($Q$54))/IF(ISNUMBER(Q792),Q792,1)))*((Q797*Q787)+Q800+Q801+Q802)","v":0}]
[null,null,null,"Operation # 17","Operation Description "]
[null,null,null,null,"Equipment Description & Size"]
[null,null,null,null,"Quantity Per Assembly",null,null,1,1,1,1,1,1,1,1,1,1]
[null,null,null,null,"Pieces/Hour     (Strokes/Hour*Pieces Per Cycle)"]
[null,null,null,null,"Pieces Per Cycle - Information Purposes Only"]
[null,null,null,null,"Manufacturing Efficiency %"]
[null,null,null,null,"Standard Hour (With Mfg Efficiency ) (For 1 Piece)",null,null,{"$f":"IF(AND(H793=0,NOT(ISNUMBER(H793))),0,(1/H793)/(IF(AND(ISNUMBER(H795),H795),H795,1)))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Direct Labor Wage Rate"]
[null,null,null,null,"No. of Direct Operators"]
[null,null,null,null,"Direct Labor Cost /Assembly",null,null,{"$f":"IF(AND(H796=\"\",H797=\"\"),0,H796*H797*IF(ISNUMBER(H798),H798,1))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Burden Variable Rate / hr"]
[null,null,null,null,"Burden Fixed Rate / hr"]
[null,null,null,null,"Burden Depreciation Rate / hr"]
[null,null,null,null,"Burden Cost /Assembly",null,null,{"$f":"(H800+H801+H802)*H796","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Sub-Total Cost",null,null,{"$f":"H799+H803","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"H804*H911","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"Set Up # 18","Annual Volume",null,null,{"$f":"H$52","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Set Up Time (Minutes)"]
[null,null,null,null,"# of Set Up Persons"]
[null,null,null,null,"Pieces per Lot",null,null,{"$f":"H54","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Set Up Costs Per Piece",null,null,{"$f":"(IF(AND(H809=0,NOT(ISNUMBER(H807))),0,(H807/60)/IF(ISNUMBER(H809),H809,(H411))/IF(ISNUMBER(H813),H813,1)))*((H818*H808)+H821+H822+H823)","v":0},{"$f":"(IF(AND(I809=0,NOT(ISNUMBER(I807))),0,(I807/60)/IF(ISNUMBER(I809),I809,($I$54))/IF(ISNUMBER(I813),I813,1)))*((I818*I808)+I821+I822+I823)","v":0},{"$f":"(IF(AND(J809=0,NOT(ISNUMBER(J807))),0,(J807/60)/IF(ISNUMBER(J809),J809,($J$54))/IF(ISNUMBER(J813),J813,1)))*((J818*J808)+J821+J822+J823)","v":0},{"$f":"(IF(AND(K809=0,NOT(ISNUMBER(K807))),0,(K807/60)/IF(ISNUMBER(K809),K809,($K$54))/IF(ISNUMBER(K813),K813,1)))*((K818*K808)+K821+K822+K823)","v":0},{"$f":"(IF(AND(L809=0,NOT(ISNUMBER(L807))),0,(L807/60)/IF(ISNUMBER(L809),L809,($L$54))/IF(ISNUMBER(L813),L813,1)))*((L818*L808)+L821+L822+L823)","v":0},{"$f":"(IF(AND(M809=0,NOT(ISNUMBER(M807))),0,(M807/60)/IF(ISNUMBER(M809),M809,($M$54))/IF(ISNUMBER(M813),M813,1)))*((M818*M808)+M821+M822+M823)","v":0},{"$f":"(IF(AND(N809=0,NOT(ISNUMBER(N807))),0,(N807/60)/IF(ISNUMBER(N809),N809,($N$54))/IF(ISNUMBER(N813),N813,1)))*((N818*N808)+N821+N822+N823)","v":0},{"$f":"(IF(AND(O809=0,NOT(ISNUMBER(O807))),0,(O807/60)/IF(ISNUMBER(O809),O809,($O$54))/IF(ISNUMBER(O813),O813,1)))*((O818*O808)+O821+O822+O823)","v":0},{"$f":"(IF(AND(P809=0,NOT(ISNUMBER(P807))),0,(P807/60)/IF(ISNUMBER(P809),P809,($P$54))/IF(ISNUMBER(P813),P813,1)))*((P818*P808)+P821+P822+P823)","v":0},{"$f":"(IF(AND(Q809=0,NOT(ISNUMBER(Q807))),0,(Q807/60)/IF(ISNUMBER(Q809),Q809,($Q$54))/IF(ISNUMBER(Q813),Q813,1)))*((Q818*Q808)+Q821+Q822+Q823)","v":0}]
[null,null,null,"Operation # 18","Operation Description "]
[null,null,null,null,"Equipment Description & Size"]
[null,null,null,null,"Quantity Per Assembly",null,null,1,1,1,1,1,1,1,1,1,1]
[null,null,null,null,"Pieces/Hour     (Strokes/Hour*Pieces Per Cycle)"]
[null,null,null,null,"Pieces Per Cycle - Information Purposes Only"]
[null,null,null,null,"Manufacturing Efficiency %"]
[null,null,null,null,"Standard Hour (With Mfg Efficiency ) (For 1 Piece)",null,null,{"$f":"IF(AND(H814=0,NOT(ISNUMBER(H814))),0,(1/H814)/(IF(AND(ISNUMBER(H816),H816),H816,1)))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Direct Labor Wage Rate"]
[null,null,null,null,"No. of Direct Operators"]
[null,null,null,null,"Direct Labor Cost /Assembly",null,null,{"$f":"IF(AND(H817=\"\",H818=\"\"),0,H817*H818*IF(ISNUMBER(H819),H819,1))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Burden Variable Rate / hr"]
[null,null,null,null,"Burden Fixed Rate / hr"]
[null,null,null,null,"Burden Depreciation Rate / hr"]
[null,null,null,null,"Burden Cost /Assembly",null,null,{"$f":"(H821+H822+H823)*H817","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Sub-Total Cost",null,null,{"$f":"H820+H824","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"H825*H911","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"Set Up # 19","Annual Volume",null,null,{"$f":"H$52","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Set Up Time (Minutes)"]
[null,null,null,null,"# of Set Up Persons"]
[null,null,null,null,"Pieces per Lot",null,null,{"$f":"H54","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Set Up Costs Per Piece",null,null,{"$f":"(IF(AND(H830=0,NOT(ISNUMBER(H828))),0,(H828/60)/IF(ISNUMBER(H830),H830,(H432))/IF(ISNUMBER(H834),H834,1)))*((H839*H829)+H842+H843+H844)","v":0},{"$f":"(IF(AND(I830=0,NOT(ISNUMBER(I828))),0,(I828/60)/IF(ISNUMBER(I830),I830,($I$54))/IF(ISNUMBER(I834),I834,1)))*((I839*I829)+I842+I843+I844)","v":0},{"$f":"(IF(AND(J830=0,NOT(ISNUMBER(J828))),0,(J828/60)/IF(ISNUMBER(J830),J830,($J$54))/IF(ISNUMBER(J834),J834,1)))*((J839*J829)+J842+J843+J844)","v":0},{"$f":"(IF(AND(K830=0,NOT(ISNUMBER(K828))),0,(K828/60)/IF(ISNUMBER(K830),K830,($K$54))/IF(ISNUMBER(K834),K834,1)))*((K839*K829)+K842+K843+K844)","v":0},{"$f":"(IF(AND(L830=0,NOT(ISNUMBER(L828))),0,(L828/60)/IF(ISNUMBER(L830),L830,($L$54))/IF(ISNUMBER(L834),L834,1)))*((L839*L829)+L842+L843+L844)","v":0},{"$f":"(IF(AND(M830=0,NOT(ISNUMBER(M828))),0,(M828/60)/IF(ISNUMBER(M830),M830,($M$54))/IF(ISNUMBER(M834),M834,1)))*((M839*M829)+M842+M843+M844)","v":0},{"$f":"(IF(AND(N830=0,NOT(ISNUMBER(N828))),0,(N828/60)/IF(ISNUMBER(N830),N830,($N$54))/IF(ISNUMBER(N834),N834,1)))*((N839*N829)+N842+N843+N844)","v":0},{"$f":"(IF(AND(O830=0,NOT(ISNUMBER(O828))),0,(O828/60)/IF(ISNUMBER(O830),O830,($O$54))/IF(ISNUMBER(O834),O834,1)))*((O839*O829)+O842+O843+O844)","v":0},{"$f":"(IF(AND(P830=0,NOT(ISNUMBER(P828))),0,(P828/60)/IF(ISNUMBER(P830),P830,($P$54))/IF(ISNUMBER(P834),P834,1)))*((P839*P829)+P842+P843+P844)","v":0},{"$f":"(IF(AND(Q830=0,NOT(ISNUMBER(Q828))),0,(Q828/60)/IF(ISNUMBER(Q830),Q830,($Q$54))/IF(ISNUMBER(Q834),Q834,1)))*((Q839*Q829)+Q842+Q843+Q844)","v":0}]
[null,null,null,"Operation # 19","Operation Description "]
[null,null,null,null,"Equipment Description & Size"]
[null,null,null,null,"Quantity Per Assembly",null,null,1,1,1,1,1,1,1,1,1,1]
[null,null,null,null,"Pieces/Hour     (Strokes/Hour*Pieces Per Cycle)"]
[null,null,null,null,"Pieces Per Cycle - Information Purposes Only"]
[null,null,null,null,"Manufacturing Efficiency %"]
[null,null,null,null,"Standard Hour (With Mfg Efficiency ) (For 1 Piece)",null,null,{"$f":"IF(AND(H835=0,NOT(ISNUMBER(H835))),0,(1/H835)/(IF(AND(ISNUMBER(H837),H837),H837,1)))","v":0},{"$f":"IF(AND(I835=0,NOT(ISNUMBER(I835))),0,(1/I835)/(IF(AND(ISNUMBER(I837),I837),I837,1)))","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,"Direct Labor Wage Rate"]
[null,null,null,null,"No. of Direct Operators"]
[null,null,null,null,"Direct Labor Cost /Assembly",null,null,{"$f":"IF(AND(H838=\"\",H839=\"\"),0,H838*H839*IF(ISNUMBER(H840),H840,1))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Burden Variable Rate / hr"]
[null,null,null,null,"Burden Fixed Rate / hr"]
[null,null,null,null,"Burden Depreciation Rate / hr"]
[null,null,null,null,"Burden Cost /Assembly",null,null,{"$f":"(H842+H843+H844)*H838","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Sub-Total Cost",null,null,{"$f":"H841+H845","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"H846*H911","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"Set Up # 20","Annual Volume",null,null,{"$f":"H$52","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Set Up Time (Minutes)"]
[null,null,null,null,"# of Set Up Persons"]
[null,null,null,null,"Pieces per Lot",null,null,{"$f":"H54","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Set Up Costs Per Piece",null,null,{"$f":"(IF(AND(H851=0,NOT(ISNUMBER(H849))),0,(H849/60)/IF(ISNUMBER(H851),H851,(H453))/IF(ISNUMBER(H855),H855,1)))*((H860*H850)+H863+H864+H865)","v":0},{"$f":"(IF(AND(I851=0,NOT(ISNUMBER(I849))),0,(I849/60)/IF(ISNUMBER(I851),I851,($I$54))/IF(ISNUMBER(I855),I855,1)))*((I860*I850)+I863+I864+I865)","v":0},{"$f":"(IF(AND(J851=0,NOT(ISNUMBER(J849))),0,(J849/60)/IF(ISNUMBER(J851),J851,($J$54))/IF(ISNUMBER(J855),J855,1)))*((J860*J850)+J863+J864+J865)","v":0},{"$f":"(IF(AND(K851=0,NOT(ISNUMBER(K849))),0,(K849/60)/IF(ISNUMBER(K851),K851,($K$54))/IF(ISNUMBER(K855),K855,1)))*((K860*K850)+K863+K864+K865)","v":0},{"$f":"(IF(AND(L851=0,NOT(ISNUMBER(L849))),0,(L849/60)/IF(ISNUMBER(L851),L851,($L$54))/IF(ISNUMBER(L855),L855,1)))*((L860*L850)+L863+L864+L865)","v":0},{"$f":"(IF(AND(M851=0,NOT(ISNUMBER(M849))),0,(M849/60)/IF(ISNUMBER(M851),M851,($M$54))/IF(ISNUMBER(M855),M855,1)))*((M860*M850)+M863+M864+M865)","v":0},{"$f":"(IF(AND(N851=0,NOT(ISNUMBER(N849))),0,(N849/60)/IF(ISNUMBER(N851),N851,($N$54))/IF(ISNUMBER(N855),N855,1)))*((N860*N850)+N863+N864+N865)","v":0},{"$f":"(IF(AND(O851=0,NOT(ISNUMBER(O849))),0,(O849/60)/IF(ISNUMBER(O851),O851,($O$54))/IF(ISNUMBER(O855),O855,1)))*((O860*O850)+O863+O864+O865)","v":0},{"$f":"(IF(AND(P851=0,NOT(ISNUMBER(P849))),0,(P849/60)/IF(ISNUMBER(P851),P851,($P$54))/IF(ISNUMBER(P855),P855,1)))*((P860*P850)+P863+P864+P865)","v":0},{"$f":"(IF(AND(Q851=0,NOT(ISNUMBER(Q849))),0,(Q849/60)/IF(ISNUMBER(Q851),Q851,($Q$54))/IF(ISNUMBER(Q855),Q855,1)))*((Q860*Q850)+Q863+Q864+Q865)","v":0}]
[null,null,null,"Operation # 20","Operation Description "]
[null,null,null,null,"Equipment Description & Size"]
[null,null,null,null,"Quantity Per Assembly",null,null,1,1,1,1,1,1,1,1,1,1]
[null,null,null,null,"Pieces/Hour     (Strokes/Hour*Pieces Per Cycle)"]
[null,null,null,null,"Pieces Per Cycle - Information Purposes Only"]
[null,null,null,null,"Manufacturing Efficiency %"]
[null,null,null,null,"Standard Hour (With Mfg Efficiency ) (For 1 Piece)",null,null,{"$f":"IF(AND(H856=0,NOT(ISNUMBER(H856))),0,(1/H856)/(IF(AND(ISNUMBER(H858),H858),H858,1)))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Direct Labor Wage Rate"]
[null,null,null,null,"No. of Direct Operators"]
[null,null,null,null,"Direct Labor Cost /Assembly",null,null,{"$f":"IF(AND(H859=\"\",H860=\"\"),0,H859*H860*IF(ISNUMBER(H861),H861,1))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Burden Variable Rate / hr"]
[null,null,null,null,"Burden Fixed Rate / hr"]
[null,null,null,null,"Burden Depreciation Rate / hr"]
[null,null,null,null,"Burden Cost /Assembly",null,null,{"$f":"(H863+H864+H865)*H859","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Sub-Total Cost",null,null,{"$f":"H862+H866","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"H867*H911","v":0},0,0,0,0,0,0,0,0,0]
[]
[]
[null,null,null,null,"TOTAL Direct Labor Cost",null,null,{"$f":"H463+H484+H505+H526+H547+H568+H589+H610+H631+H652+H673+H694+H715+H736+H757+H778+H799+H820+H841+H862","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"TOTAL Burden Cost",null,null,{"$f":"H467+H488+H509+H530+H551+H572+H593+H614+H635+H656+H677+H698+H719+H740+H761+H782+H803+H824+H845+H866","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"TOTAL Set Up Cost",null,null,{"$f":"H453+H474+H495+H516+H537+H558+H579+H600+H621+H642+H663+H684+H705+H726+H747+H768+H789+H810+H831+H852","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,"TOTAL Manufacturing Cost",null,null,{"$f":"H871+H872+H873+H444+H189","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"(H871+H872+H873)*H911","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"E) Packaging, Logistics, Amortization, Duties & Customs",null,null,null,{"$f":"H891","v":""},"","","","","","","","",""]
[null,null,null,null,"Packaging Cost","Description"]
[null,null,null,null,"Freight Cost 1","Description"]
[null,null,null,null,"Freight Cost 2","Description"]
[null,null,null,null,"Freight Cost 3","Description"]
[null,null,null,null,"Freight Method"]
[null,null,null,null,"Ware Housing Cost"]
[null,null,null,null,"Customs, Duties, Taxes & Fees"]
[null,null,null,null,"Amortization Description (Resinking, Perpectual tooling)"]
[null,null,null,null,"Total Amortizations Cost  (Resinking Cost,Perpectual Tooling)"]
[null,null,null,null,"Total Pieces Amortized  (Pieces per Resink, Pieces per perpectual tool)"]
[null,null,null,null,"Amortization Cost ",null,null,{"$f":"IF(OR(ISERROR(H887/H888),NOT(ISNUMBER(H887))),0,H887/H888)","v":0},{"$f":"IF(OR(ISERROR(I887/I888),NOT(ISNUMBER(I887))),0,I887/I888)","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,null,"F) SGA & Profit, SELL PRICE:",null,null,null,{"$f":"H447","v":""},"","","","","","","","",""]
[null,null,null,"COST DRIVER SUMMARY"]
[null,null,null,"Raw Material Cost",null,null,null,{"$f":"IF(ISNUMBER(H189),H189,0)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"Purchased Components Cost",null,null,null,{"$f":"IF(ISNUMBER(H444),H444,0)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"Direct Labor Cost",null,null,null,{"$f":"H871","v":0},{"$f":"I871","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Burden Cost",null,null,null,{"$f":"H872","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"Set Up Cost",null,null,null,0,0,0,0,0,0,0,0,0,0]
[null,null,null,"Manufacturing Cost (Material+Labor+Burden)",null,null,null,{"$f":"IF(ISERROR(SUM(H893:H897)),0,SUM(H893:H897))","v":0},{"$f":"IF(ISERROR(SUM(I893:I897)),0,SUM(I893:I897))","v":0},{"$f":"IF(ISERROR(SUM(J893:J897)),0,SUM(J893:J897))","v":0},{"$f":"IF(ISERROR(SUM(K893:K897)),0,SUM(K893:K897))","v":0},{"$f":"IF(ISERROR(SUM(L893:L897)),0,SUM(L893:L897))","v":0},0,0,0,0,0]
[]
[null,null,null,"SG&A","SG&A %"]
[null,null,null,null,"SG&A Cost",null,null,{"$f":"H900*H898","v":0},{"$f":"I900*I898","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,null,"PROFIT ","PROFIT on Material % "]
[null,null,null,null,"Profit Cost on Material ",null,null,{"$f":"H903*H893","v":0},{"$f":"I903*I893","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,"PROFIT on Purchased Components % "]
[null,null,null,null,"Profit on Purchased Components ",null,null,{"$f":"H905*H894","v":0},{"$f":"I905*I894","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,"PROFIT on Value Add % "]
[null,null,null,null,"Profit on Value Add",null,null,{"$f":"H907*(H898-H893-H894)","v":0},{"$f":"I907*(I898-I893-I894)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,"TOTAL PROFIT COST",null,null,{"$f":"H908+H906+H904","v":0},{"$f":"I908+I906+I904","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,null,"Process Scrap %"]
[null,null,null,"Dross loss %"]
[null,null,null,"Process Scrap Credit",null,null,null,{"$f":"IF(ISERROR((H61*H64+H74*H77+H87*H90+H100*H103+H113*H116+H126*H129+H139*H142+H152*H155+H165*H168+H178*H181)*H911),0,(H61*H64+H74*H77+H87*H90+H100*H103+H113*H116+H126*H129+H139*H142+H152*H155+H165*H168+H178*H181)*H911)+(H445)+(H876)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"Process Scrap Cost",null,null,null,{"$f":"IF(ISERROR((H875*H911)-H913),0,(H875*H911)-H913)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"Packaging Cost",null,null,null,{"$f":"IF(ISERROR(H879),0,H879)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"Freight + Warehousing Cost",null,null,null,{"$f":"IF(ISERROR(SUM(H880:H882)+H884),0,SUM(H880:H882)+H884)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"Amortization Cost + Customs, Duties, Taxes & Fees",null,null,null,{"$f":"IF(ISERROR(H885),0,H885+IF(ISERROR(H889),0,(H889)))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"Total Sell Price  (Supplier Local Currency)",null,null,null,{"$f":"IF(ISERROR(H898+SUM(H901,H904,H906,H908)+SUM(H914:H917)),0,H898+SUM(H901,H904,H906,H908)+SUM(H914:H917))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"Total Sell Price (Customer Paid Currency)",null,null,null,{"$f":"H43","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,"on SELL PRICE"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"D10","v":"Supplier"}]
[]
["SUPPLIER \nLOCAL CURRENCY",null,null,1,null,null,"Cost Driver",{"$f":"IF(OR($G$962=0,$G$962=\"Supplier\"),H44,H41)","v":0},0,0,0,0,0,0,0,0,0,null,"Frieght Method"]
[null,null,null,2,null,null,"Raw Material Cost",{"$f":"H189","v":0},0,0,0,0,0,0,0,0,0,null,"Free Carrier"]
[null,null,null,3,null,null,"Purchased Components Cost",{"$f":"H444","v":0},0,0,0,0,0,0,0,0,0,null,"Delivered Duty Paid"]
[null,null,null,4,null,null,"Direct Labor Cost ",{"$f":"H871","v":0},0,0,0,0,0,0,0,0,0,null,"Delivered Duty Unpaid"]
[null,null,null,5,null,null,"Burden Cost ",{"$f":"H872","v":0},0,0,0,0,0,0,0,0,0,null,"Ex Works"]
[null,null,null,6,null,null,"Set Up Cost ",{"$f":"H873","v":0},0,0,0,0,0,0,0,0,0,null,"Free Alongside Ship"]
[null,null,null,7,null,null,"Packaging & Freight Cost",{"$f":"H879","v":0},0,0,0,0,0,0,0,0,0,null,"Free Onboard Vessel"]
[null,null,null,8,null,null,"Amortization Cost + Customs, Duties, Taxes & Fees",{"$f":"H885","v":0},0,0,0,0,0,0,0,0,0,null,"Cost & Freight"]
[null,null,null,9,null,null,"Amortization Cost ",{"$f":"H889","v":0},0,0,0,0,0,0,0,0,0,null,"Cost Insurance & Freight"]
[null,null,null,10,null,null,"SG&A and Profit",{"$f":"H901+H909","v":0},0,0,0,0,0,0,0,0,0,null,"Carriage Paid To"]
[null,null,null,11,null,null," Process Scrap Cost",{"$f":"H914","v":0},0,0,0,0,0,0,0,0,0,null,"Carriage Insurance Paid To"]
[null,null,null,12,null,null,"Total Net Wt",{"$f":"IF(H62=\"kg\",(H61+H74+H87+H100+H113+H126+H139+H152+H165+H178),IF(H62=\"g\",((H61+H74+H87+H100+H113+H126+H139+H152+H165+H178)/1000),((H61+H74+H87+H100+H113+H126+H139+H152+H165+H178)*0.45359237)))","v":0},0,0,0,0,0,0,0,0,0,null,"Delivered At Frontier"]
[null,null,null,13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Delivered Ex Ship"]
[null,null,null,14,null,null,"KBS Supplier Cost/Weight",{"$f":"IF(ISERROR(H918/H975),0,(H918/H975))","v":0},0,0,0,0,0,0,0,0,0,null,"Delivered Ex Quay Duty Unpaid"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Customer PAID CURRENCY",null,null,1,null,null,"Cost Driver",{"$f":"H41","v":""},"","","","","","","","",""]
[null,null,null,2,null,null,"Raw Material Cost",{"$f":"IF(H9=H10,H965,(IF(AND(ISNUMBER(H11),ISNUMBER(H965)),(H965/H11),IF(ISNUMBER(H11),(H965/H11),H965))))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,3,null,null,"Purchased Components Cost",{"$f":"IF(H9=H10,H966,(IF(AND(ISNUMBER(H11),ISNUMBER(H966)),(H966/H11),IF(ISNUMBER(H11),(H966/H11),H966))))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,4,null,null,"Direct Labor Cost ",{"$f":"IF(H9=H10,H967,(IF(AND(ISNUMBER(H11),ISNUMBER(H967)),(H967/H11),IF(ISNUMBER(H11),(H967/H11),H967))))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,5,null,null,"Burden Cost ",{"$f":"IF(H9=H10,H968,(IF(AND(ISNUMBER(H11),ISNUMBER(H968)),(H968/H11),IF(ISNUMBER(H11),(H968/H11),H968))))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,6,null,null,"Set Up Cost ",{"$f":"IF(H9=H10,H969,(IF(AND(ISNUMBER(H11),ISNUMBER(H969)),(H969/H11),IF(ISNUMBER(H11),(H969/H11),H969))))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,7,null,null,"Packaging & Freight Cost",{"$f":"IF(H9=H10,H970,(IF(AND(ISNUMBER(H11),ISNUMBER(H970)),(H970/H11),IF(ISNUMBER(H11),(H970/H11),H970))))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,8,null,null,"Amortization Cost + Customs, Duties, Taxes & Fees",{"$f":"IF(H9=H10,H971,(IF(AND(ISNUMBER(H11),ISNUMBER(H971)),(H971/H11),IF(ISNUMBER(H11),(H971/H11),H971))))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,9,null,null,"Amortization Cost ",{"$f":"IF(H9=H10,H972,(IF(AND(ISNUMBER(H11),ISNUMBER(H972)),(H972/H11),IF(ISNUMBER(H11),(H972/H11),H972))))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,10,null,null,"SG&A and Profit",{"$f":"IF(H9=H10,H973,(IF(AND(ISNUMBER(H11),ISNUMBER(H973)),(H973/H11),IF(ISNUMBER(H11),(H973/H11),H973))))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,11,null,null," Process Scrap Cost",{"$f":"IF(H9=H10,H974,(IF(AND(ISNUMBER(H11),ISNUMBER(H974)),(H974/H11),IF(ISNUMBER(H11),(H974/H11),H974))))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,12,null,null,"Total Net Wt",{"$f":"H975","v":0},{"$f":"I975","v":0},0,0,0,0,0,0,0,0]
[null,null,null,13]
[null,null,null,14,null,null,"KBS Supplier Cost/Weight",{"$f":"IF(H9=H10,H977,(IF(AND(ISNUMBER(H11),ISNUMBER(H977)),(H977/H11),IF(ISNUMBER(H11),(H977/H11),H977))))","v":0},0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Free Carrier","Free Onboard Vessel",null,"Cost & Freight","Delivered At Frontier","Delivered Ex Ship","Delivered Ex Quay Duty Unpaid",null,null,null,"Free Carrier","Free Onboard Vessel",null,"Cost & Freight","Delivered At Frontier","Delivered Ex Ship","Delivered Ex Quay Duty Unpaid"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Consignment Terms:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Units of Measure:",null,"ea","mg","g","kg","lb","mil","m","cm","mm","um","ea","mg","g","kg","lb","mil","m","cm","mm","um","gal","qt","fl oz"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Each","Milligram","Gram","Kilogram","Pounds","Mil (.001 in)","Meter","Centimeter","Millimeter","Micrometer","Each","Milligram","Gram","Kilogram","Pounds","Mil (.001 in)","Meter","Centimeter","Millimeter","Micrometer","Gallon","Quart","Fluid Ounces"]
[]
[]
[]
[null,null,null,null,null,null,null,"Material Scrap","Material Scrap","Material Scrap","Material Scrap","Material Scrap","Material Scrap","Material Scrap","Material Scrap","Material Scrap","Material Scrap"]
[null,null,null,null,null,null,null,"Supplier 1","Supplier 1","Supplier 1","Supplier 1","Supplier 1","Supplier 1","Supplier 1","Supplier 1","Supplier 1","Supplier 1"]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H69*#REF!),0,(H69*#REF!))","v":0},{"$f":"IF(ISERROR(I69*#REF!),0,(I69*#REF!))","v":0},{"$f":"IF(ISERROR(J69*#REF!),0,(J69*#REF!))","v":0},{"$f":"IF(ISERROR(K69*#REF!),0,(K69*#REF!))","v":0},{"$f":"IF(ISERROR(L69*#REF!),0,(L69*#REF!))","v":0},{"$f":"IF(ISERROR(M69*#REF!),0,(M69*#REF!))","v":0},{"$f":"IF(ISERROR(N69*#REF!),0,(N69*#REF!))","v":0},{"$f":"IF(ISERROR(O69*#REF!),0,(O69*#REF!))","v":0},{"$f":"IF(ISERROR(P69*#REF!),0,(P69*#REF!))","v":0},{"$f":"IF(ISERROR(Q69*#REF!),0,(Q69*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(#REF!*H82),0,(#REF!*H82))","v":0},{"$f":"IF(ISERROR(#REF!*I82),0,(#REF!*I82))","v":0},{"$f":"IF(ISERROR(#REF!*J82),0,(#REF!*J82))","v":0},{"$f":"IF(ISERROR(#REF!*K82),0,(#REF!*K82))","v":0},{"$f":"IF(ISERROR(#REF!*L82),0,(#REF!*L82))","v":0},{"$f":"IF(ISERROR(#REF!*M82),0,(#REF!*M82))","v":0},{"$f":"IF(ISERROR(#REF!*N82),0,(#REF!*N82))","v":0},{"$f":"IF(ISERROR(#REF!*O82),0,(#REF!*O82))","v":0},{"$f":"IF(ISERROR(#REF!*P82),0,(#REF!*P82))","v":0},{"$f":"IF(ISERROR(#REF!*Q82),0,(#REF!*Q82))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(#REF!*H95),0,(#REF!*H95))","v":0},{"$f":"IF(ISERROR(#REF!*I95),0,(#REF!*I95))","v":0},{"$f":"IF(ISERROR(#REF!*J95),0,(#REF!*J95))","v":0},{"$f":"IF(ISERROR(#REF!*K95),0,(#REF!*K95))","v":0},{"$f":"IF(ISERROR(#REF!*L95),0,(#REF!*L95))","v":0},{"$f":"IF(ISERROR(#REF!*M95),0,(#REF!*M95))","v":0},{"$f":"IF(ISERROR(#REF!*N95),0,(#REF!*N95))","v":0},{"$f":"IF(ISERROR(#REF!*O95),0,(#REF!*O95))","v":0},{"$f":"IF(ISERROR(#REF!*P95),0,(#REF!*P95))","v":0},{"$f":"IF(ISERROR(#REF!*Q95),0,(#REF!*Q95))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(#REF!*H108),0,(#REF!*H108))","v":0},{"$f":"IF(ISERROR(#REF!*I108),0,(#REF!*I108))","v":0},{"$f":"IF(ISERROR(#REF!*J108),0,(#REF!*J108))","v":0},{"$f":"IF(ISERROR(#REF!*K108),0,(#REF!*K108))","v":0},{"$f":"IF(ISERROR(#REF!*L108),0,(#REF!*L108))","v":0},{"$f":"IF(ISERROR(#REF!*M108),0,(#REF!*M108))","v":0},{"$f":"IF(ISERROR(#REF!*N108),0,(#REF!*N108))","v":0},{"$f":"IF(ISERROR(#REF!*O108),0,(#REF!*O108))","v":0},{"$f":"IF(ISERROR(#REF!*P108),0,(#REF!*P108))","v":0},{"$f":"IF(ISERROR(#REF!*Q108),0,(#REF!*Q108))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(#REF!*H121),0,(#REF!*H121))","v":0},{"$f":"IF(ISERROR(#REF!*I121),0,(#REF!*I121))","v":0},{"$f":"IF(ISERROR(#REF!*J121),0,(#REF!*J121))","v":0},{"$f":"IF(ISERROR(#REF!*K121),0,(#REF!*K121))","v":0},{"$f":"IF(ISERROR(#REF!*L121),0,(#REF!*L121))","v":0},{"$f":"IF(ISERROR(#REF!*M121),0,(#REF!*M121))","v":0},{"$f":"IF(ISERROR(#REF!*N121),0,(#REF!*N121))","v":0},{"$f":"IF(ISERROR(#REF!*O121),0,(#REF!*O121))","v":0},{"$f":"IF(ISERROR(#REF!*P121),0,(#REF!*P121))","v":0},{"$f":"IF(ISERROR(#REF!*Q121),0,(#REF!*Q121))","v":0},null,null,null,null,null,null,null,"Currency:",null,"Afghani","Lek","Algerian Dinar","Kwanza","Argentine Peso","Dram","Australian Dollar","Euro","Azerbaijani Manat","Bahraini Dinar","Taka","Belarussian Rouble","Euro","Belize Dollar","CFA Franc BCEAO","Boliviano","Convertible Mark","Pula"]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H134*#REF!),0,(H134*#REF!))","v":0},{"$f":"IF(ISERROR(I134*#REF!),0,(I134*#REF!))","v":0},{"$f":"IF(ISERROR(J134*#REF!),0,(J134*#REF!))","v":0},{"$f":"IF(ISERROR(K134*#REF!),0,(K134*#REF!))","v":0},{"$f":"IF(ISERROR(L134*#REF!),0,(L134*#REF!))","v":0},{"$f":"IF(ISERROR(M134*#REF!),0,(M134*#REF!))","v":0},{"$f":"IF(ISERROR(N134*#REF!),0,(N134*#REF!))","v":0},{"$f":"IF(ISERROR(O134*#REF!),0,(O134*#REF!))","v":0},{"$f":"IF(ISERROR(P134*#REF!),0,(P134*#REF!))","v":0},{"$f":"IF(ISERROR(Q134*#REF!),0,(Q134*#REF!))","v":0},null,null,null,null,null,null,null,"Country Code:",null,"AF","AL","DZ","AO","AR","AM","AU","AT","AZ","BH","BD","BY","BE","BZ","BJ","BO","BA","BW"]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H147*#REF!),0,(H147*#REF!))","v":0},{"$f":"IF(ISERROR(I147*#REF!),0,(I147*#REF!))","v":0},{"$f":"IF(ISERROR(J147*#REF!),0,(J147*#REF!))","v":0},{"$f":"IF(ISERROR(K147*#REF!),0,(K147*#REF!))","v":0},{"$f":"IF(ISERROR(L147*#REF!),0,(L147*#REF!))","v":0},{"$f":"IF(ISERROR(M147*#REF!),0,(M147*#REF!))","v":0},{"$f":"IF(ISERROR(N147*#REF!),0,(N147*#REF!))","v":0},{"$f":"IF(ISERROR(O147*#REF!),0,(O147*#REF!))","v":0},{"$f":"IF(ISERROR(P147*#REF!),0,(P147*#REF!))","v":0},{"$f":"IF(ISERROR(Q147*#REF!),0,(Q147*#REF!))","v":0},null,null,null,null,null,null,null,"Short List of Currency Codes:",null,"EUR","GBP","JPY","USD","ARS","AUD","CAD","CHF","CNY","DKK","HKD","KRW","MXN","NOK","NZD","PLN","RUR","SEK"]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H160*#REF!),0,(H160*#REF!))","v":0},{"$f":"IF(ISERROR(I160*#REF!),0,(I160*#REF!))","v":0},{"$f":"IF(ISERROR(J160*#REF!),0,(J160*#REF!))","v":0},{"$f":"IF(ISERROR(K160*#REF!),0,(K160*#REF!))","v":0},{"$f":"IF(ISERROR(L160*#REF!),0,(L160*#REF!))","v":0},{"$f":"IF(ISERROR(M160*#REF!),0,(M160*#REF!))","v":0},{"$f":"IF(ISERROR(N160*#REF!),0,(N160*#REF!))","v":0},{"$f":"IF(ISERROR(O160*#REF!),0,(O160*#REF!))","v":0},{"$f":"IF(ISERROR(P160*#REF!),0,(P160*#REF!))","v":0},{"$f":"IF(ISERROR(Q160*#REF!),0,(Q160*#REF!))","v":0},null,null,null,null,null,null,null,"Short List of Currencies:",null,"Euro","Pound Sterling","Yen","US Dollar","Argentine Peso","Australian Dollar","Canadian Dollar","Swiss Franc","Yuan Renminbi","Danish Krone","Hong Kong Dollar","South Korean Won","Mexican Peso","Norwegian Krone","New Zealand Dollar","Zloty","Russian Federation Rouble","Swedish Krona"]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H173*#REF!),0,(H173*#REF!))","v":0},{"$f":"IF(ISERROR(I173*#REF!),0,(I173*#REF!))","v":0},{"$f":"IF(ISERROR(J173*#REF!),0,(J173*#REF!))","v":0},{"$f":"IF(ISERROR(K173*#REF!),0,(K173*#REF!))","v":0},{"$f":"IF(ISERROR(L173*#REF!),0,(L173*#REF!))","v":0},{"$f":"IF(ISERROR(M173*#REF!),0,(M173*#REF!))","v":0},{"$f":"IF(ISERROR(N173*#REF!),0,(N173*#REF!))","v":0},{"$f":"IF(ISERROR(O173*#REF!),0,(O173*#REF!))","v":0},{"$f":"IF(ISERROR(P173*#REF!),0,(P173*#REF!))","v":0},{"$f":"IF(ISERROR(Q173*#REF!),0,(Q173*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H186*#REF!),0,(H186*#REF!))","v":0},{"$f":"IF(ISERROR(I186*#REF!),0,(I186*#REF!))","v":0},{"$f":"IF(ISERROR(J186*#REF!),0,(J186*#REF!))","v":0},{"$f":"IF(ISERROR(K186*#REF!),0,(K186*#REF!))","v":0},{"$f":"IF(ISERROR(L186*#REF!),0,(L186*#REF!))","v":0},{"$f":"IF(ISERROR(M186*#REF!),0,(M186*#REF!))","v":0},{"$f":"IF(ISERROR(N186*#REF!),0,(N186*#REF!))","v":0},{"$f":"IF(ISERROR(O186*#REF!),0,(O186*#REF!))","v":0},{"$f":"IF(ISERROR(P186*#REF!),0,(P186*#REF!))","v":0},{"$f":"IF(ISERROR(Q186*#REF!),0,(Q186*#REF!))","v":0}]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H1032:H1041)","v":0},{"$f":"SUM(I1032:I1041)","v":0},0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Purchased Comp/Outside Processed Comp","Purchased Comp/Outside Processed Comp","Purchased Comp/Outside Processed Comp","Purchased Comp/Outside Processed Comp","Purchased Comp/Outside Processed Comp","Purchased Comp/Outside Processed Comp","Purchased Comp/Outside Processed Comp","Purchased Comp/Outside Processed Comp","Purchased Comp/Outside Processed Comp","Purchased Comp/Outside Processed Comp"]
[null,null,null,null,null,null,null,"Supplier 1","Supplier 1","Supplier 1","Supplier 1","Supplier 1","Supplier 1","Supplier 1","Supplier 1","Supplier 1","Supplier 1"]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H202*#REF!),0,(H202*#REF!))","v":0},{"$f":"IF(ISERROR(I202*#REF!),0,(I202*#REF!))","v":0},{"$f":"IF(ISERROR(J202*#REF!),0,(J202*#REF!))","v":0},{"$f":"IF(ISERROR(K202*#REF!),0,(K202*#REF!))","v":0},{"$f":"IF(ISERROR(L202*#REF!),0,(L202*#REF!))","v":0},{"$f":"IF(ISERROR(M202*#REF!),0,(M202*#REF!))","v":0},{"$f":"IF(ISERROR(N202*#REF!),0,(N202*#REF!))","v":0},{"$f":"IF(ISERROR(O202*#REF!),0,(O202*#REF!))","v":0},{"$f":"IF(ISERROR(P202*#REF!),0,(P202*#REF!))","v":0},{"$f":"IF(ISERROR(Q202*#REF!),0,(Q202*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H212*#REF!),0,(H212*#REF!))","v":0},{"$f":"IF(ISERROR(I212*#REF!),0,(I212*#REF!))","v":0},{"$f":"IF(ISERROR(J212*#REF!),0,(J212*#REF!))","v":0},{"$f":"IF(ISERROR(K212*#REF!),0,(K212*#REF!))","v":0},{"$f":"IF(ISERROR(L212*#REF!),0,(L212*#REF!))","v":0},{"$f":"IF(ISERROR(M212*#REF!),0,(M212*#REF!))","v":0},{"$f":"IF(ISERROR(N212*#REF!),0,(N212*#REF!))","v":0},{"$f":"IF(ISERROR(O212*#REF!),0,(O212*#REF!))","v":0},{"$f":"IF(ISERROR(P212*#REF!),0,(P212*#REF!))","v":0},{"$f":"IF(ISERROR(Q212*#REF!),0,(Q212*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H222*#REF!),0,(H222*#REF!))","v":0},{"$f":"IF(ISERROR(I222*#REF!),0,(I222*#REF!))","v":0},{"$f":"IF(ISERROR(J222*#REF!),0,(J222*#REF!))","v":0},{"$f":"IF(ISERROR(K222*#REF!),0,(K222*#REF!))","v":0},{"$f":"IF(ISERROR(L222*#REF!),0,(L222*#REF!))","v":0},{"$f":"IF(ISERROR(M222*#REF!),0,(M222*#REF!))","v":0},{"$f":"IF(ISERROR(N222*#REF!),0,(N222*#REF!))","v":0},{"$f":"IF(ISERROR(O222*#REF!),0,(O222*#REF!))","v":0},{"$f":"IF(ISERROR(P222*#REF!),0,(P222*#REF!))","v":0},{"$f":"IF(ISERROR(Q222*#REF!),0,(Q222*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H232*#REF!),0,(H232*#REF!))","v":0},{"$f":"IF(ISERROR(I232*#REF!),0,(I232*#REF!))","v":0},{"$f":"IF(ISERROR(J232*#REF!),0,(J232*#REF!))","v":0},{"$f":"IF(ISERROR(K232*#REF!),0,(K232*#REF!))","v":0},{"$f":"IF(ISERROR(L232*#REF!),0,(L232*#REF!))","v":0},{"$f":"IF(ISERROR(M232*#REF!),0,(M232*#REF!))","v":0},{"$f":"IF(ISERROR(N232*#REF!),0,(N232*#REF!))","v":0},{"$f":"IF(ISERROR(O232*#REF!),0,(O232*#REF!))","v":0},{"$f":"IF(ISERROR(P232*#REF!),0,(P232*#REF!))","v":0},{"$f":"IF(ISERROR(Q232*#REF!),0,(Q232*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H242*#REF!),0,(H242*#REF!))","v":0},{"$f":"IF(ISERROR(I242*#REF!),0,(I242*#REF!))","v":0},{"$f":"IF(ISERROR(J242*#REF!),0,(J242*#REF!))","v":0},{"$f":"IF(ISERROR(K242*#REF!),0,(K242*#REF!))","v":0},{"$f":"IF(ISERROR(L242*#REF!),0,(L242*#REF!))","v":0},{"$f":"IF(ISERROR(M242*#REF!),0,(M242*#REF!))","v":0},{"$f":"IF(ISERROR(N242*#REF!),0,(N242*#REF!))","v":0},{"$f":"IF(ISERROR(O242*#REF!),0,(O242*#REF!))","v":0},{"$f":"IF(ISERROR(P242*#REF!),0,(P242*#REF!))","v":0},{"$f":"IF(ISERROR(Q242*#REF!),0,(Q242*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H252*#REF!),0,(H252*#REF!))","v":0},{"$f":"IF(ISERROR(I252*#REF!),0,(I252*#REF!))","v":0},{"$f":"IF(ISERROR(J252*#REF!),0,(J252*#REF!))","v":0},{"$f":"IF(ISERROR(K252*#REF!),0,(K252*#REF!))","v":0},{"$f":"IF(ISERROR(L252*#REF!),0,(L252*#REF!))","v":0},{"$f":"IF(ISERROR(M252*#REF!),0,(M252*#REF!))","v":0},{"$f":"IF(ISERROR(N252*#REF!),0,(N252*#REF!))","v":0},{"$f":"IF(ISERROR(O252*#REF!),0,(O252*#REF!))","v":0},{"$f":"IF(ISERROR(P252*#REF!),0,(P252*#REF!))","v":0},{"$f":"IF(ISERROR(Q252*#REF!),0,(Q252*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H262*#REF!),0,(H262*#REF!))","v":0},{"$f":"IF(ISERROR(I262*#REF!),0,(I262*#REF!))","v":0},{"$f":"IF(ISERROR(J262*#REF!),0,(J262*#REF!))","v":0},{"$f":"IF(ISERROR(K262*#REF!),0,(K262*#REF!))","v":0},{"$f":"IF(ISERROR(L262*#REF!),0,(L262*#REF!))","v":0},{"$f":"IF(ISERROR(M262*#REF!),0,(M262*#REF!))","v":0},{"$f":"IF(ISERROR(N262*#REF!),0,(N262*#REF!))","v":0},{"$f":"IF(ISERROR(O262*#REF!),0,(O262*#REF!))","v":0},{"$f":"IF(ISERROR(P262*#REF!),0,(P262*#REF!))","v":0},{"$f":"IF(ISERROR(Q262*#REF!),0,(Q262*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H272*#REF!),0,(H272*#REF!))","v":0},{"$f":"IF(ISERROR(I272*#REF!),0,(I272*#REF!))","v":0},{"$f":"IF(ISERROR(J272*#REF!),0,(J272*#REF!))","v":0},{"$f":"IF(ISERROR(K272*#REF!),0,(K272*#REF!))","v":0},{"$f":"IF(ISERROR(L272*#REF!),0,(L272*#REF!))","v":0},{"$f":"IF(ISERROR(M272*#REF!),0,(M272*#REF!))","v":0},{"$f":"IF(ISERROR(N272*#REF!),0,(N272*#REF!))","v":0},{"$f":"IF(ISERROR(O272*#REF!),0,(O272*#REF!))","v":0},{"$f":"IF(ISERROR(P272*#REF!),0,(P272*#REF!))","v":0},{"$f":"IF(ISERROR(Q272*#REF!),0,(Q272*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H282*#REF!),0,(H282*#REF!))","v":0},{"$f":"IF(ISERROR(I282*#REF!),0,(I282*#REF!))","v":0},{"$f":"IF(ISERROR(J282*#REF!),0,(J282*#REF!))","v":0},{"$f":"IF(ISERROR(K282*#REF!),0,(K282*#REF!))","v":0},{"$f":"IF(ISERROR(L282*#REF!),0,(L282*#REF!))","v":0},{"$f":"IF(ISERROR(M282*#REF!),0,(M282*#REF!))","v":0},{"$f":"IF(ISERROR(N282*#REF!),0,(N282*#REF!))","v":0},{"$f":"IF(ISERROR(O282*#REF!),0,(O282*#REF!))","v":0},{"$f":"IF(ISERROR(P282*#REF!),0,(P282*#REF!))","v":0},{"$f":"IF(ISERROR(Q282*#REF!),0,(Q282*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H292*#REF!),0,(H292*#REF!))","v":0},{"$f":"IF(ISERROR(I292*#REF!),0,(I292*#REF!))","v":0},{"$f":"IF(ISERROR(J292*#REF!),0,(J292*#REF!))","v":0},{"$f":"IF(ISERROR(K292*#REF!),0,(K292*#REF!))","v":0},{"$f":"IF(ISERROR(L292*#REF!),0,(L292*#REF!))","v":0},{"$f":"IF(ISERROR(M292*#REF!),0,(M292*#REF!))","v":0},{"$f":"IF(ISERROR(N292*#REF!),0,(N292*#REF!))","v":0},{"$f":"IF(ISERROR(O292*#REF!),0,(O292*#REF!))","v":0},{"$f":"IF(ISERROR(P292*#REF!),0,(P292*#REF!))","v":0},{"$f":"IF(ISERROR(Q292*#REF!),0,(Q292*#REF!))","v":0}]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H1051:H1060)","v":0},{"$f":"SUM(I1051:I1060)","v":0},0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Processing Cost","Processing Cost","Processing Cost","Processing Cost","Processing Cost","Processing Cost","Processing Cost","Processing Cost","Processing Cost","Processing Cost"]
[null,null,null,null,null,null,null,"Supplier 1","Supplier 1","Supplier 1","Supplier 1","Supplier 1","Supplier 1","Supplier 1","Supplier 1","Supplier 1","Supplier 1"]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H468*#REF!),0,(H468*#REF!))","v":0},{"$f":"IF(ISERROR(I468*#REF!),0,(I468*#REF!))","v":0},{"$f":"IF(ISERROR(J468*#REF!),0,(J468*#REF!))","v":0},{"$f":"IF(ISERROR(K468*#REF!),0,(K468*#REF!))","v":0},{"$f":"IF(ISERROR(L468*#REF!),0,(L468*#REF!))","v":0},{"$f":"IF(ISERROR(M468*#REF!),0,(M468*#REF!))","v":0},{"$f":"IF(ISERROR(N468*#REF!),0,(N468*#REF!))","v":0},{"$f":"IF(ISERROR(O468*#REF!),0,(O468*#REF!))","v":0},{"$f":"IF(ISERROR(P468*#REF!),0,(P468*#REF!))","v":0},{"$f":"IF(ISERROR(Q468*#REF!),0,(Q468*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H489*#REF!),0,(H489*#REF!))","v":0},{"$f":"IF(ISERROR(I489*#REF!),0,(I489*#REF!))","v":0},{"$f":"IF(ISERROR(J489*#REF!),0,(J489*#REF!))","v":0},{"$f":"IF(ISERROR(K489*#REF!),0,(K489*#REF!))","v":0},{"$f":"IF(ISERROR(L489*#REF!),0,(L489*#REF!))","v":0},{"$f":"IF(ISERROR(M489*#REF!),0,(M489*#REF!))","v":0},{"$f":"IF(ISERROR(N489*#REF!),0,(N489*#REF!))","v":0},{"$f":"IF(ISERROR(O489*#REF!),0,(O489*#REF!))","v":0},{"$f":"IF(ISERROR(P489*#REF!),0,(P489*#REF!))","v":0},{"$f":"IF(ISERROR(Q489*#REF!),0,(Q489*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H510*#REF!),0,(H510*#REF!))","v":0},{"$f":"IF(ISERROR(I510*#REF!),0,(I510*#REF!))","v":0},{"$f":"IF(ISERROR(J510*#REF!),0,(J510*#REF!))","v":0},{"$f":"IF(ISERROR(K510*#REF!),0,(K510*#REF!))","v":0},{"$f":"IF(ISERROR(L510*#REF!),0,(L510*#REF!))","v":0},{"$f":"IF(ISERROR(M510*#REF!),0,(M510*#REF!))","v":0},{"$f":"IF(ISERROR(N510*#REF!),0,(N510*#REF!))","v":0},{"$f":"IF(ISERROR(O510*#REF!),0,(O510*#REF!))","v":0},{"$f":"IF(ISERROR(P510*#REF!),0,(P510*#REF!))","v":0},{"$f":"IF(ISERROR(Q510*#REF!),0,(Q510*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H531*#REF!),0,(H531*#REF!))","v":0},{"$f":"IF(ISERROR(I531*#REF!),0,(I531*#REF!))","v":0},{"$f":"IF(ISERROR(J531*#REF!),0,(J531*#REF!))","v":0},{"$f":"IF(ISERROR(K531*#REF!),0,(K531*#REF!))","v":0},{"$f":"IF(ISERROR(L531*#REF!),0,(L531*#REF!))","v":0},{"$f":"IF(ISERROR(M531*#REF!),0,(M531*#REF!))","v":0},{"$f":"IF(ISERROR(N531*#REF!),0,(N531*#REF!))","v":0},{"$f":"IF(ISERROR(O531*#REF!),0,(O531*#REF!))","v":0},{"$f":"IF(ISERROR(P531*#REF!),0,(P531*#REF!))","v":0},{"$f":"IF(ISERROR(Q531*#REF!),0,(Q531*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H552*#REF!),0,(H552*#REF!))","v":0},{"$f":"IF(ISERROR(I552*#REF!),0,(I552*#REF!))","v":0},{"$f":"IF(ISERROR(J552*#REF!),0,(J552*#REF!))","v":0},{"$f":"IF(ISERROR(K552*#REF!),0,(K552*#REF!))","v":0},{"$f":"IF(ISERROR(L552*#REF!),0,(L552*#REF!))","v":0},{"$f":"IF(ISERROR(M552*#REF!),0,(M552*#REF!))","v":0},{"$f":"IF(ISERROR(N552*#REF!),0,(N552*#REF!))","v":0},{"$f":"IF(ISERROR(O552*#REF!),0,(O552*#REF!))","v":0},{"$f":"IF(ISERROR(P552*#REF!),0,(P552*#REF!))","v":0},{"$f":"IF(ISERROR(Q552*#REF!),0,(Q552*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H573*#REF!),0,(H573*#REF!))","v":0},{"$f":"IF(ISERROR(I573*#REF!),0,(I573*#REF!))","v":0},{"$f":"IF(ISERROR(J573*#REF!),0,(J573*#REF!))","v":0},{"$f":"IF(ISERROR(K573*#REF!),0,(K573*#REF!))","v":0},{"$f":"IF(ISERROR(L573*#REF!),0,(L573*#REF!))","v":0},{"$f":"IF(ISERROR(M573*#REF!),0,(M573*#REF!))","v":0},{"$f":"IF(ISERROR(N573*#REF!),0,(N573*#REF!))","v":0},{"$f":"IF(ISERROR(O573*#REF!),0,(O573*#REF!))","v":0},{"$f":"IF(ISERROR(P573*#REF!),0,(P573*#REF!))","v":0},{"$f":"IF(ISERROR(Q573*#REF!),0,(Q573*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H594*#REF!),0,(H594*#REF!))","v":0},{"$f":"IF(ISERROR(I594*#REF!),0,(I594*#REF!))","v":0},{"$f":"IF(ISERROR(J594*#REF!),0,(J594*#REF!))","v":0},{"$f":"IF(ISERROR(K594*#REF!),0,(K594*#REF!))","v":0},{"$f":"IF(ISERROR(L594*#REF!),0,(L594*#REF!))","v":0},{"$f":"IF(ISERROR(M594*#REF!),0,(M594*#REF!))","v":0},{"$f":"IF(ISERROR(N594*#REF!),0,(N594*#REF!))","v":0},{"$f":"IF(ISERROR(O594*#REF!),0,(O594*#REF!))","v":0},{"$f":"IF(ISERROR(P594*#REF!),0,(P594*#REF!))","v":0},{"$f":"IF(ISERROR(Q594*#REF!),0,(Q594*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H615*#REF!),0,(H615*#REF!))","v":0},{"$f":"IF(ISERROR(I615*#REF!),0,(I615*#REF!))","v":0},{"$f":"IF(ISERROR(J615*#REF!),0,(J615*#REF!))","v":0},{"$f":"IF(ISERROR(K615*#REF!),0,(K615*#REF!))","v":0},{"$f":"IF(ISERROR(L615*#REF!),0,(L615*#REF!))","v":0},{"$f":"IF(ISERROR(M615*#REF!),0,(M615*#REF!))","v":0},{"$f":"IF(ISERROR(N615*#REF!),0,(N615*#REF!))","v":0},{"$f":"IF(ISERROR(O615*#REF!),0,(O615*#REF!))","v":0},{"$f":"IF(ISERROR(P615*#REF!),0,(P615*#REF!))","v":0},{"$f":"IF(ISERROR(Q615*#REF!),0,(Q615*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H636*#REF!),0,(H636*#REF!))","v":0},{"$f":"IF(ISERROR(I636*#REF!),0,(I636*#REF!))","v":0},{"$f":"IF(ISERROR(J636*#REF!),0,(J636*#REF!))","v":0},{"$f":"IF(ISERROR(K636*#REF!),0,(K636*#REF!))","v":0},{"$f":"IF(ISERROR(L636*#REF!),0,(L636*#REF!))","v":0},{"$f":"IF(ISERROR(M636*#REF!),0,(M636*#REF!))","v":0},{"$f":"IF(ISERROR(N636*#REF!),0,(N636*#REF!))","v":0},{"$f":"IF(ISERROR(O636*#REF!),0,(O636*#REF!))","v":0},{"$f":"IF(ISERROR(P636*#REF!),0,(P636*#REF!))","v":0},{"$f":"IF(ISERROR(Q636*#REF!),0,(Q636*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H657*#REF!),0,(H657*#REF!))","v":0},{"$f":"IF(ISERROR(I657*#REF!),0,(I657*#REF!))","v":0},{"$f":"IF(ISERROR(J657*#REF!),0,(J657*#REF!))","v":0},{"$f":"IF(ISERROR(K657*#REF!),0,(K657*#REF!))","v":0},{"$f":"IF(ISERROR(L657*#REF!),0,(L657*#REF!))","v":0},{"$f":"IF(ISERROR(M657*#REF!),0,(M657*#REF!))","v":0},{"$f":"IF(ISERROR(N657*#REF!),0,(N657*#REF!))","v":0},{"$f":"IF(ISERROR(O657*#REF!),0,(O657*#REF!))","v":0},{"$f":"IF(ISERROR(P657*#REF!),0,(P657*#REF!))","v":0},{"$f":"IF(ISERROR(Q657*#REF!),0,(Q657*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H678*#REF!),0,(H678*#REF!))","v":0},{"$f":"IF(ISERROR(I678*#REF!),0,(I678*#REF!))","v":0},{"$f":"IF(ISERROR(J678*#REF!),0,(J678*#REF!))","v":0},{"$f":"IF(ISERROR(K678*#REF!),0,(K678*#REF!))","v":0},{"$f":"IF(ISERROR(L678*#REF!),0,(L678*#REF!))","v":0},{"$f":"IF(ISERROR(M678*#REF!),0,(M678*#REF!))","v":0},{"$f":"IF(ISERROR(N678*#REF!),0,(N678*#REF!))","v":0},{"$f":"IF(ISERROR(O678*#REF!),0,(O678*#REF!))","v":0},{"$f":"IF(ISERROR(P678*#REF!),0,(P678*#REF!))","v":0},{"$f":"IF(ISERROR(Q678*#REF!),0,(Q678*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H699*#REF!),0,(H699*#REF!))","v":0},{"$f":"IF(ISERROR(I699*#REF!),0,(I699*#REF!))","v":0},{"$f":"IF(ISERROR(J699*#REF!),0,(J699*#REF!))","v":0},{"$f":"IF(ISERROR(K699*#REF!),0,(K699*#REF!))","v":0},{"$f":"IF(ISERROR(L699*#REF!),0,(L699*#REF!))","v":0},{"$f":"IF(ISERROR(M699*#REF!),0,(M699*#REF!))","v":0},{"$f":"IF(ISERROR(N699*#REF!),0,(N699*#REF!))","v":0},{"$f":"IF(ISERROR(O699*#REF!),0,(O699*#REF!))","v":0},{"$f":"IF(ISERROR(P699*#REF!),0,(P699*#REF!))","v":0},{"$f":"IF(ISERROR(Q699*#REF!),0,(Q699*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H720*#REF!),0,(H720*#REF!))","v":0},{"$f":"IF(ISERROR(I720*#REF!),0,(I720*#REF!))","v":0},{"$f":"IF(ISERROR(J720*#REF!),0,(J720*#REF!))","v":0},{"$f":"IF(ISERROR(K720*#REF!),0,(K720*#REF!))","v":0},{"$f":"IF(ISERROR(L720*#REF!),0,(L720*#REF!))","v":0},{"$f":"IF(ISERROR(M720*#REF!),0,(M720*#REF!))","v":0},{"$f":"IF(ISERROR(N720*#REF!),0,(N720*#REF!))","v":0},{"$f":"IF(ISERROR(O720*#REF!),0,(O720*#REF!))","v":0},{"$f":"IF(ISERROR(P720*#REF!),0,(P720*#REF!))","v":0},{"$f":"IF(ISERROR(Q720*#REF!),0,(Q720*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H741*#REF!),0,(H741*#REF!))","v":0},{"$f":"IF(ISERROR(I741*#REF!),0,(I741*#REF!))","v":0},{"$f":"IF(ISERROR(J741*#REF!),0,(J741*#REF!))","v":0},{"$f":"IF(ISERROR(K741*#REF!),0,(K741*#REF!))","v":0},{"$f":"IF(ISERROR(L741*#REF!),0,(L741*#REF!))","v":0},{"$f":"IF(ISERROR(M741*#REF!),0,(M741*#REF!))","v":0},{"$f":"IF(ISERROR(N741*#REF!),0,(N741*#REF!))","v":0},{"$f":"IF(ISERROR(O741*#REF!),0,(O741*#REF!))","v":0},{"$f":"IF(ISERROR(P741*#REF!),0,(P741*#REF!))","v":0},{"$f":"IF(ISERROR(Q741*#REF!),0,(Q741*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H762*#REF!),0,(H762*#REF!))","v":0},{"$f":"IF(ISERROR(I762*#REF!),0,(I762*#REF!))","v":0},{"$f":"IF(ISERROR(J762*#REF!),0,(J762*#REF!))","v":0},{"$f":"IF(ISERROR(K762*#REF!),0,(K762*#REF!))","v":0},{"$f":"IF(ISERROR(L762*#REF!),0,(L762*#REF!))","v":0},{"$f":"IF(ISERROR(M762*#REF!),0,(M762*#REF!))","v":0},{"$f":"IF(ISERROR(N762*#REF!),0,(N762*#REF!))","v":0},{"$f":"IF(ISERROR(O762*#REF!),0,(O762*#REF!))","v":0},{"$f":"IF(ISERROR(P762*#REF!),0,(P762*#REF!))","v":0},{"$f":"IF(ISERROR(Q762*#REF!),0,(Q762*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H783*#REF!),0,(H783*#REF!))","v":0},{"$f":"IF(ISERROR(I783*#REF!),0,(I783*#REF!))","v":0},{"$f":"IF(ISERROR(J783*#REF!),0,(J783*#REF!))","v":0},{"$f":"IF(ISERROR(K783*#REF!),0,(K783*#REF!))","v":0},{"$f":"IF(ISERROR(L783*#REF!),0,(L783*#REF!))","v":0},{"$f":"IF(ISERROR(M783*#REF!),0,(M783*#REF!))","v":0},{"$f":"IF(ISERROR(N783*#REF!),0,(N783*#REF!))","v":0},{"$f":"IF(ISERROR(O783*#REF!),0,(O783*#REF!))","v":0},{"$f":"IF(ISERROR(P783*#REF!),0,(P783*#REF!))","v":0},{"$f":"IF(ISERROR(Q783*#REF!),0,(Q783*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H804*#REF!),0,(H804*#REF!))","v":0},{"$f":"IF(ISERROR(I804*#REF!),0,(I804*#REF!))","v":0},{"$f":"IF(ISERROR(J804*#REF!),0,(J804*#REF!))","v":0},{"$f":"IF(ISERROR(K804*#REF!),0,(K804*#REF!))","v":0},{"$f":"IF(ISERROR(L804*#REF!),0,(L804*#REF!))","v":0},{"$f":"IF(ISERROR(M804*#REF!),0,(M804*#REF!))","v":0},{"$f":"IF(ISERROR(N804*#REF!),0,(N804*#REF!))","v":0},{"$f":"IF(ISERROR(O804*#REF!),0,(O804*#REF!))","v":0},{"$f":"IF(ISERROR(P804*#REF!),0,(P804*#REF!))","v":0},{"$f":"IF(ISERROR(Q804*#REF!),0,(Q804*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H825*#REF!),0,(H825*#REF!))","v":0},{"$f":"IF(ISERROR(I825*#REF!),0,(I825*#REF!))","v":0},{"$f":"IF(ISERROR(J825*#REF!),0,(J825*#REF!))","v":0},{"$f":"IF(ISERROR(K825*#REF!),0,(K825*#REF!))","v":0},{"$f":"IF(ISERROR(L825*#REF!),0,(L825*#REF!))","v":0},{"$f":"IF(ISERROR(M825*#REF!),0,(M825*#REF!))","v":0},{"$f":"IF(ISERROR(N825*#REF!),0,(N825*#REF!))","v":0},{"$f":"IF(ISERROR(O825*#REF!),0,(O825*#REF!))","v":0},{"$f":"IF(ISERROR(P825*#REF!),0,(P825*#REF!))","v":0},{"$f":"IF(ISERROR(Q825*#REF!),0,(Q825*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H846*#REF!),0,(H846*#REF!))","v":0},{"$f":"IF(ISERROR(I846*#REF!),0,(I846*#REF!))","v":0},{"$f":"IF(ISERROR(J846*#REF!),0,(J846*#REF!))","v":0},{"$f":"IF(ISERROR(K846*#REF!),0,(K846*#REF!))","v":0},{"$f":"IF(ISERROR(L846*#REF!),0,(L846*#REF!))","v":0},{"$f":"IF(ISERROR(M846*#REF!),0,(M846*#REF!))","v":0},{"$f":"IF(ISERROR(N846*#REF!),0,(N846*#REF!))","v":0},{"$f":"IF(ISERROR(O846*#REF!),0,(O846*#REF!))","v":0},{"$f":"IF(ISERROR(P846*#REF!),0,(P846*#REF!))","v":0},{"$f":"IF(ISERROR(Q846*#REF!),0,(Q846*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H867*#REF!),0,(H867*#REF!))","v":0},{"$f":"IF(ISERROR(I867*#REF!),0,(I867*#REF!))","v":0},{"$f":"IF(ISERROR(J867*#REF!),0,(J867*#REF!))","v":0},{"$f":"IF(ISERROR(K867*#REF!),0,(K867*#REF!))","v":0},{"$f":"IF(ISERROR(L867*#REF!),0,(L867*#REF!))","v":0},{"$f":"IF(ISERROR(M867*#REF!),0,(M867*#REF!))","v":0},{"$f":"IF(ISERROR(N867*#REF!),0,(N867*#REF!))","v":0},{"$f":"IF(ISERROR(O867*#REF!),0,(O867*#REF!))","v":0},{"$f":"IF(ISERROR(P867*#REF!),0,(P867*#REF!))","v":0},{"$f":"IF(ISERROR(Q867*#REF!),0,(Q867*#REF!))","v":0}]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H1072:H1091)","v":0},{"$f":"SUM(I1072:I1091)","v":0},0,0,0,0,0,0,0,0]
[]
[]
[]
[null,null,null,null,null,null,"Process Scrap %",{"$f":"IF(SUM(H875)=0,0,SUM(H1042,H1061,H1092)/H875)","v":0},0,0,0,0,0,0,0,0,0]

{"sheet":"Tooling Cost Breakdown","index":1,"n_rows":54,"n_cols":40,"rows_kept":54,"cut":false,"hidden":false,"merged":[[51,24,51,25],[52,3,52,14],[52,16,52,19],[52,23,52,25],[53,3,53,6],[53,7,53,8],[53,9,53,11],[53,13,53,14],[53,17,53,19],[53,24,53,25],[46,3,46,6],[48,7,48,11],[48,12,48,14],[48,16,48,19],[48,23,48,25],[49,3,49,6],[49,7,49,8],[49,9,49,11],[49,13,49,14],[49,15,53,15],[49,17,49,19],[49,20,53,22],[49,24,49,25],[50,3,50,6],[50,7,50,8],[50,9,50,11],[50,13,50,14],[50,17,50,19],[50,24,50,25],[51,3,51,6],[51,7,51,8],[51,9,51,11],[51,13,51,14],[51,17,51,19],[42,8,42,9],[42,12,42,13],[42,15,42,18],[42,20,42,23],[42,26,42,29],[44,8,44,9],[44,12,44,13],[44,15,44,18],[44,20,44,23],[44,26,44,29],[39,8,39,9],[39,12,39,13],[39,15,39,18],[39,20,39,23],[39,26,39,29],[40,8,40,9],[40,12,40,13],[40,15,40,18],[40,20,40,23],[40,26,40,29],[37,8,37,9],[37,12,37,13],[37,15,37,18],[37,20,37,23],[37,26,37,29],[38,8,38,9],[38,12,38,13],[38,15,38,18],[38,20,38,23],[38,26,38,29],[35,8,35,9],[35,12,35,13],[35,15,35,18],[35,20,35,23],[35,26,35,29],[36,8,36,9],[36,12,36,13],[36,15,36,18],[36,20,36,23],[36,26,36,29],[32,12,32,13],[32,15,32,18],[32,20,32,23],[33,8,33,9],[33,12,33,13],[33,15,33,18],[33,20,33,23],[33,26,33,29],[34,8,34,9],[34,12,34,13],[34,15,34,18],[34,20,34,23],[34,26,34,29],[24,8,24,9],[24,16,24,21],[24,22,24,23],[25,8,25,9],[26,8,26,9],[26,16,26,21],[26,22,26,23],[26,26,26,29],[30,3,31,3],[30,6,31,6],[30,8,31,9],[30,12,30,13],[30,15,30,18],[30,20,30,23],[30,26,31,29],[31,15,31,18],[31,20,31,23],[20,5,20,6],[20,8,20,9],[20,11,20,12],[20,16,20,17],[20,19,20,23],[20,25,20,26],[20,30,20,31],[22,16,22,21],[22,22,22,23],[18,5,18,6],[18,8,18,9],[18,11,18,12],[18,16,18,17],[18,19,18,23],[18,25,18,26],[18,30,18,31],[17,5,17,6],[17,8,17,9],[16,25,16,26],[16,30,16,31],[15,5,15,6],[15,8,15,9],[15,11,15,12],[15,16,15,17],[15,19,15,23],[15,25,15,26],[17,11,17,12],[17,16,17,17],[17,19,17,23],[17,25,17,26],[15,30,15,31],[16,5,16,6],[16,8,16,9],[16,11,16,12],[16,16,16,17],[16,19,16,23],[17,30,17,31],[13,19,13,23],[13,25,13,26],[11,25,11,26],[11,30,11,31],[12,30,12,31],[13,30,13,31],[14,5,14,6],[14,8,14,9],[14,11,14,12],[14,16,14,17],[14,19,14,23],[14,25,14,26],[14,30,14,31],[13,5,13,6],[13,8,13,9],[8,30,8,31],[8,33,9,33],[9,19,9,23],[9,25,9,26],[9,30,9,31],[11,5,11,6],[11,8,11,9],[11,11,11,12],[11,16,11,17],[11,19,11,23],[8,1,9,1],[8,28,9,28],[30,1,31,1],[41,8,41,9],[41,12,41,13],[41,15,41,18],[41,20,41,23],[41,26,41,29],[8,3,9,3],[8,5,9,6],[8,8,9,9],[8,11,9,12],[8,14,9,14],[8,16,9,17],[8,19,8,23],[8,25,8,26],[12,5,12,6],[12,8,12,9],[12,11,12,12],[12,16,12,17],[12,19,12,23],[12,25,12,26],[13,11,13,12],[13,16,13,17]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," Cost Break Down"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOOLING COST DETAILS"]
[]
[]
[null,null,null,"PRODUCTION TOOLING DETAILS:"]
[]
[null,"SUPPLIER NAME",null,"Op #",null,"TOOL DESCRIPTION",null,null,"LEAD TIME\n(WKS)",null,null,"TOOL\nL x W x H",null,null,"TOOL\nUOM",null,"STEEL TYPE",null,null,null,null,null,null,null,null,null,null,null,"POTENTIAL SOURCE LOCATION (COUNTRY)",null,null,null,null,"# OF CAVITIES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOOL FEATURES",null,null,null,null,null,"POTENTIAL SOURCE",null,null,null,null,"TOOL CAPACITY",null,null,null,null,"CAPACITY\n@ HRS/DAY",null,"CAPACITY \n@ DAYS/WK",null,"PCS/HR"]
[]
[null,{"$f":"Vertical_Cost_Break_Down!H44","v":0}]
[null,{"$f":"Vertical_Cost_Break_Down!I44","v":0}]
[null,{"$f":"Vertical_Cost_Break_Down!J44","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"Vertical_Cost_Break_Down!K44","v":0}]
[null,{"$f":"Vertical_Cost_Break_Down!L44","v":0},null,null,null," ",null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null," "]
[null,{"$f":"Vertical_Cost_Break_Down!M44","v":0},null,null,null," ",null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null," "]
[null,{"$f":"Vertical_Cost_Break_Down!N44","v":0},null,null,null," ",null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,{"$f":"Vertical_Cost_Break_Down!O44","v":0},null,null,null," ",null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,{"$f":"Vertical_Cost_Break_Down!P44","v":0}]
[null,{"$f":"Vertical_Cost_Break_Down!Q44","v":0},null,null,null,null,null,null," "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"# OF STATIONS:"]
[]
[null,null,null,null,null,null,null,"TOTAL LEAD TIME:",{"$f":"SUM(I12:J21)","v":0},null,null,null,null,null,null,null,"CAD/CAM SOFTWARE USED:"]
[]
[null,null,null,null,null,null,null,"MAXIMUM LEAD TIME:",{"$f":"MAX(I12:J21)","v":0},null,null,null,null,null,null,null,"MACHINE TONNAGE:",null,null,null,null,null,null,null,"UOM:"]
[]
[null,null,null,"PRODUCTION TOOLING COSTS DETAIL:"]
[]
[null,"SUPPLIER NAME",null,"Op #",null,null,"TOOL DESIGN \nCOST",null,"LABOR COST",null,null,null,"MATERIALS",null,null,"OVERHEAD COST",null,null,null,null,"PURCHASED",null,null,null,null,null,"TOTAL TOOL COST"]
[null,null,null,null,null,null,null,null,null,null,null,null,"COST",null,null,"(INCLUDING PROFIT)",null,null,null,null,"SERVICES COST"]
[]
[null,{"$f":"Vertical_Cost_Break_Down!H44","v":0},null,{"$f":"IF(ISNUMBER(D12), D12, \" \")","v":" "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(G34),ISNUMBER(I34),ISNUMBER(M34),ISNUMBER(P34),ISNUMBER(P34)),G34+I34+M34+P34+U34,\" \")","v":" "}]
[null,{"$f":"Vertical_Cost_Break_Down!I44","v":0},null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(G35),ISNUMBER(I35),ISNUMBER(M35),ISNUMBER(P35),ISNUMBER(P35)),G35+I35+M35+P35+U35,\" \")","v":" "}]
[null,{"$f":"Vertical_Cost_Break_Down!J44","v":0},null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,{"$f":"Vertical_Cost_Break_Down!K44","v":0},null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,{"$f":"Vertical_Cost_Break_Down!L44","v":0},null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,{"$f":"Vertical_Cost_Break_Down!M44","v":0},null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,{"$f":"Vertical_Cost_Break_Down!N44","v":0},null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,{"$f":"Vertical_Cost_Break_Down!O44","v":0},null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,{"$f":"Vertical_Cost_Break_Down!P44","v":0},null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(ISNUMBER(G42),ISNUMBER(I42),ISNUMBER(M42),ISNUMBER(P42),ISNUMBER(P42)),G42+I42+M42+P42+U42,\" \")","v":" "}]
[null,{"$f":"Vertical_Cost_Break_Down!Q44","v":0},null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null,null,null,null,"TOTAL $:",{"$f":"SUM(G34:G43)","v":0},null,{"$f":"SUM(I34:J43)","v":0},{"$f":"SUM(J34:J43)","v":0},null,null,{"$f":"SUM(M34:N43)","v":0},{"$f":"SUM(N34:N43)","v":0},null,{"$f":"SUM(P34:S43)","v":0},{"$f":"SUM(Q34:Q43)","v":0},{"$f":"SUM(R34:R43)","v":0},{"$f":"SUM(S34:S43)","v":0},null,{"$f":"SUM(U34:X43)","v":0},{"$f":"SUM(V34:V43)","v":0},{"$f":"SUM(W34:W43)","v":0},{"$f":"SUM(X34:X43)","v":0},null,null,{"$f":"SUM(AA34:AD43)","v":0}]
[]
[null,null,null,"PRE-PRODUCTION PIECE COSTS:"]
[]
[null,null,null,null,null,null,null,"EARLY PROTO 1",null,null,null,null,"EARLY PROTO 2",null,null,null,"FINAL PROTO",null,null,null,null,null,null,"F.E. BUILDS"]
[null,null,null,"EVENT",null,null,null,"INITIAL ORDER",null,"RE-ORDER",null,null,"INITIAL ORDER","RE-ORDER",null,null,"INITIAL ORDER","RE-ORDER",null,null,null,null,null,"INITIAL ORDER","RE-ORDER"]
[null,null,null,"PIECE PRICE / UNIT:"]
[null,null,null,"PART LEAD TIME:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,"LOT SIZE:"]

{"sheet":"Definitions","index":2,"n_rows":142,"n_cols":12,"rows_kept":142,"cut":false,"hidden":false,"merged":[[5,2,5,6],[35,2,35,6],[19,2,19,6],[139,10,141,10],[69,2,69,6],[108,2,108,6],[83,2,83,6],[46,2,46,6]]}
[]
[null,"         Vertical Cost Breakdown Worksheet"]
[null,"Definitions and Instructions"]
[]
[null,null,"Breakdown Sheet Field",null,null,"Definition & Instructions","Responsible"]
[null,null,"Forex Information"]
[null,null,null,null,"Supplier Local Currency :","Enter the local currency at the Supplier's manufacturing location, or currency part quoted in.\nMUST ENTER CURRENCY CODE OR BREAKDOWN SHEET WILL ASSUME SAME AS \"USD\"","User"]
[null,null,null,null,"Customer Currency :","Currency Customer will use to pay the supplier.","User"]
[null,null,"A) General Information"]
[null,null,null,null,"Supplier Name :","Enter the full supplier name associated with the Customer Supplier Code.","User"]
[null,null,null,null,"Supplier Mfg. Location :","Enter the supplier’s manufacturing location, including city, state/province/etc. and country. \n(Country of Origin)","User"]
[null,null,null,null,"RFQ Number :","Request For Quote number assigned by Customer","User"]
[null,null,null,null,"Capital Tooling Cost ( Not in selling price)","Specify capital tooling cost e.g. die cost etc\n this cost considered separate from selling , to amortize the tooling cost use amortization section","User"]
[null,null,null,null,"Part Description :","Customer part description","User"]
[null,null,null,null,"Customer Part # :","Enter Customer part number","User"]
[null,null,null,null,"Total Net Cycle Time","Total   Net cycle time of all the manufacturing process  with manufacturing Inefficiencies","Calculated"]
[null,null,null,null,"Annual Volume:","Enter annual volume of the component","User"]
[null,null,null,null,"# of Production Runs Per Year","Enter the number of production runs required to produce annual volume","User"]
[null,null,null,null,"Lot Run Size","This is auto calculated based on Volume and lot Run size (Can be overwritten)","Calculated/User"]
[null,null,"B) Raw Material"]
[null,null,null,null,"Material Description","Describe the raw material.  Include: material type, grade/spec., size ( thickness, blank size, diameter ), shape, and stock ( sheet, coil, bar, drum ).  Example: 1215 Steel - 0.7969 - Round Bar Stock","User"]
[null,null,null,null,"Quantity Per part","Identify the quantity of parts with the specified gross material amount required per part.","User"]
[null,null,null,null,"Gross Material Amount","Enter the amount of material required for processing.  This is generally considered the \"BLANK SIZE\".","User"]
[null,null,null,null,"Net Material Amount","Enter the amount of material remaining after processing","User"]
[null,null,null,null,"Unit of Measure (UoM)","Identify the unit of measurement for the amount of material (example: lb., kg., ml, etc.)","User"]
[null,null,null,null,"Base Cost (Local Currency) / UoM","Identify in local currency, per unit of measure, the cost assumption for the base portion of the raw material cost","User"]
[]
[null,null,null,null,"Resale Value ( Local Currency ) / UoM","Identify value of recycle material per unit of measure.","User"]
[null,null,null,null,"Material Cost ( Local Currency )","Calculation = Gross Material weight * (Cost/UoM *((Gross Material weight - Net Material weight)*Resale Value)*Quantity Per part","Calculated"]
[null,null,null,null,"Supplier Source","Enter the Source Name from Where the Raw Material is Procured","User"]
[null,null,null,null,"Country","Country from where the Material is Procured","User"]
[null,null,null,null,"State","State from where the Material is Procured","User"]
[null,null,null,null,"City","City from where the Material is Procured","User"]
[null,null,null,null,"Total Material Cost ( Local Currency )","Calculation= Sum of Material cost of Material 1, Material 2, Material 3, Material 4,……. Material 10","Calculated"]
[]
[null,null,"C) Purchased Components & Outside Processing "]
[null,null,null,null,"Item, Material or Process Description","Describe the purchased component or outside processing.  ","User"]
[null,null,null,null,"Quantity Per part","Identify the quantity of purchased components or outside processing required per part.","User"]
[null,null,null,null,"Unit of Measure (UoM)","Identify the unit of measurement for the quantity per part (example: each, lb., kg., ml, etc.)","User"]
[null,null,null,null,"Cost (Local Currency) / UoM","Identify in local currency per unit of measure the cost of the purchased component or outside processing.","User"]
[null,null,null,null,"Supplier Source","Enter the Source Name from Where the Raw Material is Procured","User"]
[null,null,null,null,"Country","Country from where the Material is Procured","User"]
[null,null,null,null,"State","State from where the Material is Procured","User"]
[null,null,null,null,"City","City from where the Material is Procured","User"]
[null,null,null,null,"Sub - Total Cost ( Local Currency )","Calculation = Quantity Per part * (Cost/UoM)","Calculated"]
[null,null,null,null,"Total Purchase Cost ( Local Currency )","Calculation= Sum of Material cost of Material 1, Material 2, Material 3, Material 4,……. Material 10","Calculated"]
[null,null,"D) Processing "]
[null,null,null,null,"Annual Volume","Enter annual volume of the component","User"]
[null,null,null,null,"Set Up Time (hours)","Enter the set up time in hours required for a production run","User"]
[null,null,null,null,"# of Set Up Persons","Enter number of persons  required for a setup","User"]
[null,null,null,null,"# of Production Runs Per Year","Reflects # of production runs entered in General information table required to produce annual volume","Calculated"]
[null,null,null,null,"Set Up Costs Per Piece","Calculation =(( # of Set Up persons)*(Direct Labor Wage Rate)+(Burden rate/hr)*(Set up time in hrs)/(Annual Volume/# of production runs)","Calculated"]
[null,null,null,null,"Operation Description","Describe the operation performed and the component processed.","User"]
[null,null,null,null,"Equipment Description & Size","Describe the type of equipment used in this operation. Include information such as:  number of spindles, max bar stock diameter, hand tools, part fixtures, etc.","User"]
[null,null,null,null,"Quantity Per part","Identify number of times this component is required for the final part.  Example: 2 required per part.","User"]
[null,null,null,null,"Pieces/Hour","Enter the machine or part pure cycle time, Pieces Per Hour , required to complete operation, assuming 100% efficiency.  Do not include inefficiencies","User"]
[null,null,null,null,"Pieces Per Cycle","Identify number of pieces produced during the machine or part cycle time.","User"]
[null,null,null,null,"Manufacturing Efficiency %","Identify the %  of Efficiency during Production due issues such as breaks, machine adjustments, material restocking, direct labor. DOES NOT INCLUDE SET UP.","User"]
[null,null,null,null,"Standard Hour Per part ( with Manufacturing Efficiency )","Calculation=(1 / Pieces per Hr )/ (Manufacturing Efficiency) *  Quantity Per part","Calculated"]
[null,null,null,null,"Direct Labor Wage Rate ( Local Curr./hr )","Identify in local currency per hour the wages paid to (1) operator performing this type of work. This includes employment taxes with fringe benefit costs.","User"]
[null,null,null,null,"No. of Direct Operators","Identify the number of direct labor employees required for each operation.\nExample:\n0.5 = 1 operator per 2 machines\n 1 = 1 operator per 1 machine\n 2 = 2 operators per 1 machine  ","User"]
[null,null,null,null,"Direct Labor Cost Per part ( Local Currency )","Calculation=Standard Hour Per part  ( with Manufacturing efficiency )* (Wage Rate (with Fringe Rate) * No. of Direct Operators ","Calculated"]
[null,null,null,null," Burden Variable Rate ( Local Curr./hr )","Identify in local currency per hour the portion of the burden that remains constant regardless of the level of activity.  This Includes only the Variable Cost.","User"]
[null,null,null,null," Burden Fixed Rate ( Local Curr./hr )","Identify in local currency per hour the portion of the burden that remains constant regardless of the level of activity.  This Includes only the Fixed Cost.","User"]
[null,null,null,null," Burden Depreciation Rate ( Local Curr./hr )","Identify in local currency per hour the portion of the burden that remains constant regardless of the level of activity. Thiis Includes only the Cost of Depreciation.","User"]
[null,null,null,null,"Burden Cost Per part ( Local Currency )","Calculation=Standard Hour Per part (with Manufacturing efficiency)* Burden Rate /Hr","Calculated"]
[null,null,null,null,"Sub - Total Cost ( Local Currency )","Calculation=Direct Labor Cost Per part + Burden Cost Per part","Calculated"]
[null,null,null,null,"TOTAL PROCESSING COST ( Local Currency )","Calculation= Sum of processing cost of all processes","Calculated"]
[null,null,null,null,"TOTAL MANUFACTURING COST","Calculation= Total Raw Material Cost + Total Purchased/Outsourced Component Cost + Total Process Cost","Calculated"]
[null,null,"E) Packaging, Logistics, Amortization, Duties & Customs"]
[null,null,null,null,"Packaging & Logistics Cost","Enter the Packaging & Logistics Cost per piece","User"]
[null,null,null,null,"Customs, Duties, Taxes & Fees","Enter the Customs, Duties, Taxes & Fees  per piece","User"]
[null,null,null,null,"Other Cost  Description","Describe the Other Cost per piece if any","User"]
[null,null,null,null,"Other Cost","Enter the Other Cost  per piece","User"]
[null,null,null,null,"Consumable Tooling Description","Describe the equipment or tool name which is Only applicable to Customer","User"]
[null,null,null,null,"Consumable Tooling Cost","Enter the consumable tooling required for manufacturing the component.  Example is the tool set for a screw machine operation.  This cost may also be included in the burden section as part of the burden rate","User"]
[null,null,null,null,"Consumable Tooling Life","Enter No for Pieces can Run with Consumable Tooling","User"]
[null,null,null,null,"Consumable Tooling Cost per part","Calculation= Consumable Tooling Cost / Consumable Tool Life","Calculated"]
[null,null,null,null,"Amortization Description","Describe the equipment or tool name. Only applicable to Customer","User"]
[null,null,null,null,"Total Amortizations Cost / Resinking Cost","Enter the Amortizations Cost per piece or Resinking Cost","User"]
[null,null,null,null,"Years of Amortizations  / No of Resinks","Enter number of years the amount is to be amortized over or No of Resinks","User"]
[null,null,null,null,"Pieces per year / Pieces per Resink","Enter number of pieces per year or Pieces per Resink","User"]
[null,null,null,null,"Amortization Cost","Calculation= Total Amortizations Cost / (Years of Amortizations * Annual Volume ) \n                                            OR\nCalculation= Total Resinking Cost / (No of Resinks * Pieces per Resink )","Calculated"]
[null,null,"F) SGA & Profit, SELL PRICE:"]
[null,null,null,null,"Raw Material Cost","This is total  Raw Material  Cost","Calculated"]
[null,null,null,null,"Purchased Components Cost","This is total  Purchased Components Cost","Calculated"]
[null,null,null,null,"Direct Labor ","This is total  direct labor cost of all processes ","Calculated"]
[null,null,null,null,"Burden Cost","This is total  burden cost of all processes ","Calculated"]
[null,null,null,null,"Set Up Cost","This is total  Set Up Cost of all processes ","Calculated"]
[null,null,null,null,"Manufacturing Cost (Material+Labor+Burden)","Total Manufacturing Cost =  Sum of Material + Labor + Burden Cost","Calculated"]
[null,null,null,null,"SG & A  %","This cost is to pay for the corporate Selling, General & Administrative Costs applied as a %","User"]
[null,null,null,null,"SG&A","Calculation=Total Manufacturing Cost* SG&A%","Calculated"]
[null,null,null,null,"Profit % (seperated % entry for Material, Purchase Components and Value Add) ","This is the Gross Profit applied as a % ","User"]
[null,null,null,null,"Profit (seperated % entry for Material, Purchase Components and Value Add) ","Calculation=Total Manufacturing Cost* Profit%","Calculated"]
[null,null,null,null,"Profit (Total for Material, Purchase Components and Value Add Profit) ","Calculation=Total Profit (Sum of Material + Purchase Components + Value Add Profit)","Calculated"]
[null,null,null,null,"Process Scrap %","Total Scrap % generated from the production of \"poor quality\" parts\nCalculation = Sum of Process Scrap% (Raw Material, Purchased Components, Process)","Calculated"]
[null,null,null,null,"Dross Loss %","This is the Dross Loss applied as a % ","User"]
[null,null,null,null,"Process Scrap Credit","Calculation=(Sub total (Net Wt* Resale Value ))* Scrap %","Calculated"]
[null,null,null,null,"Process Scrap Cost","Calculation=(Total Manufacturing Cost * Scrap %)-Process Scrap Credit","Calculated"]
[null,null,null,null,"Packaging and Logistics Cost","Total Packaging and  Logistics cost","Calculated"]
[]
[null,null,null,null,"Customs, Duties, Taxes & Fees","Total Customs, Duties, Taxes & Fees per part","Calculated"]
[null,null,null,null,"Other Cost","Total other cost per part","Calculated"]
[null,null,null,null,"Total Sell Price","Sell Price ","Calculated"]
[null,null,null,null,"Amortization & Consumable Tooling Cost","Total amortization & consumable tooling cost","Calculated"]
[null,null,null,null,"Total Sell Price without Surcharge","Total Sell Price","Calculated"]
[]
[]
[null,null,"G) PRODUCTIVITY"]
[null,null,null,null,"Contract Year","Year of the contract.","User"]
[null,null,null,null,"Sell Price % Reduction","Identify the % productivity the supplier commits to achieve each year on the sell price or Mfg Cost (Value Added).  % is not applied to Customs, Duties, Taxes & Fees","User"]
[null,null,null,null,"Sell Price ( Local Currency )","Calculation  =( (Total Sell Price ( year # ) )*(100% - % Reduction) ","Calculated"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"LEGEND","User input cells"]
[null,null,null,null,null,null,null,null,null,null,null,"Calculation Cells"]
[null,null,null,null,null,null,null,null,null,null,null,"SELL Price (Local Currency)"]

{"sheet":"Currency Conversions","index":3,"n_rows":444,"n_cols":8,"rows_kept":444,"cut":false,"hidden":false,"merged":[]}
["LOOKUP","SPPLR CUR","CUST CUR","RATE"]
[{"$f":"B2&\"-\"&C2","v":"USD-USD"},"USD","USD",1]
[{"$f":"B3&\"-\"&C3","v":"AUD-USD"},"AUD","USD",0.73099999999999998]
["BRL-USD","BRL","USD",0.30147723846849561,null,null,null,"USD"]
["CAD-USD","CAD","USD",0.98619329388560162]
["CHF-USD","CHF","USD",0.97943192948090119]
["CNY-USD","CNY","USD",0.1601537475976938]
["CZK-USD","CZK","USD",5.0276461295418642E-2]
["EUR-USD","EUR","USD",1.0529999999999999]
["GBP-USD","GBP","USD",1.4830000000000001]
["HUG-USD","HUG","USD",4.2575250836120399E-3]
["INR-USD","INR","USD",1.5715857300015717E-2]
["JPY-USD","JPY","USD",7.9936051159072742E-3]
["KRW-USD","KRW","USD",8.9525514771709937E-4]
["MXN-USD","MXN","USD",6.1728395061728399E-2]
["NOK-USD","NOK","USD",0.17296195652173912]
["PLN-USD","PLN","USD",0.25967281225655675]
["ROL-USD","ROL","USD",0.28800904977375563]
["RUB-USD","RUB","USD",3.2258064516129031E-2]
["SEK-USD","SEK","USD",0.15287618590128496]
["TRY-USD","TRY","USD",0.36832412523020258]
["TWD-USD","TWD","USD",3.1374517616791643E-2]
["USD-AUD","USD","AUD",1.3679890560875514]
["USD-BRL","USD","BRL",3.3170000000000002]
["USD-CAD","USD","CAD",1.014]
["USD-CHF","USD","CHF",1.0209999999999999]
["USD-CNY","USD","CNY",6.2439999999999998]
["USD-CZK","USD","CZK",19.890023566378634]
["USD-EUR","USD","EUR",0.94966761633428309]
["USD-GBP","USD","GBP",0.67430883344571813]
["USD-HUG","USD","HUG",234.87824037706207]
["USD-INR","USD","INR",63.629999999999995]
["USD-JPY","USD","JPY",125.1]
["USD-KRW","USD","KRW",1117]
["USD-MXN","USD","MXN",16.2]
["USD-NOK","USD","NOK",5.7816182246661434]
["USD-PLN","USD","PLN",3.851]
["USD-ROL","USD","ROL",3.4721131186174392]
["USD-RUB","USD","RUB",31]
["USD-SEK","USD","SEK",6.5412411626080136]
["USD-TRY","USD","TRY",2.7149999999999999]
["USD-TWD","USD","TWD",31.872999999999998]
["USD-USD","USD","USD",1]
["AUD-BRL","AUD","BRL",2.4247269999999999]
["AUD-CAD","AUD","CAD",0.74123399999999995]
["AUD-CHF","AUD","CHF",0.74635099999999988]
["AUD-CNY","AUD","CNY",4.5643639999999994]
["AUD-CZK","AUD","CZK",14.539607227022781]
["AUD-EUR","AUD","EUR",0.6942070275403609]
["AUD-GBP","AUD","GBP",0.49291975724881992]
["AUD-HUG","AUD","HUG",171.69599371563237]
["AUD-INR","AUD","INR",46.513529999999996]
["AUD-JPY","AUD","JPY",91.448099999999997]
["AUD-KRW","AUD","KRW",816.52699999999993]
["AUD-MXN","AUD","MXN",11.8422]
["AUD-NOK","AUD","NOK",4.2263629222309511]
["AUD-PLN","AUD","PLN",2.8150809999999997]
["AUD-ROL","AUD","ROL",2.5381146897093481]
["AUD-RUB","AUD","RUB",22.660999999999998]
["AUD-SEK","AUD","SEK",4.7816472898664575]
["AUD-TRY","AUD","TRY",1.9846649999999999]
["AUD-TWD","AUD","TWD",23.299162999999997]
["BRL-AUD","BRL","AUD",0.41241756288439896]
["BRL-CAD","BRL","CAD",0.30569791980705457]
["BRL-CHF","BRL","CHF",0.30780826047633397]
["BRL-CNY","BRL","CNY",1.8824238769972865]
[{"$f":"B67&\"-\"&C67","v":"BRL-CZK"},"BRL","CZK",5.9963893778651292]
["BRL-EUR","BRL","EUR",0.28630317043541847]
["BRL-GBP","BRL","GBP",0.20328876498212786]
["BRL-HUG","BRL","HUG",70.810443285216181]
["BRL-INR","BRL","INR",19.182996683750375]
["BRL-JPY","BRL","JPY",37.714802532408797]
["BRL-KRW","BRL","KRW",336.75007536930957]
["BRL-MXN","BRL","MXN",4.8839312631896288]
["BRL-NOK","BRL","NOK",1.7430262962514751]
["BRL-PLN","BRL","PLN",1.1609888453421766]
["BRL-ROL","BRL","ROL",1.0467630746510217]
["BRL-RUB","BRL","RUB",9.3457943925233646]
["BRL-SEK","BRL","SEK",1.9720353218595157]
["BRL-TRY","BRL","TRY",0.81851070244196555]
["BRL-TWD","BRL","TWD",9.6089840217063607]
["CAD-AUD","CAD","AUD",1.3491016332224373]
["CAD-BRL","CAD","BRL",3.2712031558185406]
["CAD-CHF","CAD","CHF",1.0069033530571991]
["CAD-CNY","CAD","CNY",6.1577909270216962]
["CAD-CZK","CAD","CZK",19.615407856389186]
["CAD-EUR","CAD","EUR",0.93655583464919445]
["CAD-GBP","CAD","GBP",0.66499884955199029]
["CAD-HUG","CAD","HUG",231.63534553950896]
["CAD-INR","CAD","INR",62.751479289940825]
["CAD-JPY","CAD","JPY",123.37278106508876]
["CAD-KRW","CAD","KRW",1101.5779092702171]
["CAD-MXN","CAD","MXN",15.976331360946746]
["CAD-NOK","CAD","NOK",5.7017931209725283]
["CAD-PLN","CAD","PLN",3.7978303747534516]
["CAD-ROL","CAD","ROL",3.4241746731927409]
["CAD-RUB","CAD","RUB",30.57199211045365]
["CAD-SEK","CAD","SEK",6.4509281682524788]
["CAD-TRY","CAD","TRY",2.6775147928994083]
["CAD-TWD","CAD","TWD",31.432938856015777]
["CHF-AUD","CHF","AUD",1.3398521607125873]
["CHF-BRL","CHF","BRL",3.2487757100881494]
["CHF-CAD","CHF","CAD",0.99314397649363384]
["CHF-CNY","CHF","CNY",6.1155729676787471]
["CHF-CZK","CHF","CZK",19.480924159038821]
["CHF-EUR","CHF","EUR",0.93013478583181508]
["CHF-GBP","CHF","GBP",0.66043960180775529]
["CHF-HUG","CHF","HUG",230.04724816558482]
["CHF-INR","CHF","INR",62.321253672869737]
["CHF-JPY","CHF","JPY",122.52693437806073]
["CHF-KRW","CHF","KRW",1094.0254652301667]
["CHF-MXN","CHF","MXN",15.866797257590598]
["CHF-NOK","CHF","NOK",5.6627014933067032]
["CHF-PLN","CHF","PLN",3.7717923604309505]
["CHF-ROL","CHF","ROL",3.4006984511434277]
["CHF-RUB","CHF","RUB",30.362389813907935]
["CHF-SEK","CHF","SEK",6.4067004530930598]
["CHF-TRY","CHF","TRY",2.6591576885406467]
["CHF-TWD","CHF","TWD",31.217433888344761]
["CNY-AUD","CNY","AUD",0.21908857400505308]
["CNY-BRL","CNY","BRL",0.53122998078155037]
["CNY-CAD","CNY","CAD",0.16239590006406152]
["CNY-CHF","CNY","CHF",0.16351697629724535]
["CNY-CZK","CNY","CZK",3.185461813961985]
["CNY-EUR","CNY","EUR",0.15209282772810429]
["CNY-GBP","CNY","GBP",0.10799308671456088]
["CNY-HUG","CNY","HUG",37.616630425538453]
["CNY-INR","CNY","INR",10.190582959641256]
["CNY-JPY","CNY","JPY",20.035233824471494]
["CNY-KRW","CNY","KRW",178.89173606662396]
[{"$f":"B131&\"-\"&C131","v":"CNY-MXN"},"CNY","MXN",2.5944907110826394]
["CNY-NOK","CNY","NOK",0.92594782585940805]
["CNY-PLN","CNY","PLN",0.61675208199871878]
["CNY-ROL","CNY","ROL",0.55607192802969885]
["CNY-RUB","CNY","RUB",4.9647661755285073]
["CNY-SEK","CNY","SEK",1.047604286131969]
["CNY-TRY","CNY","TRY",0.43481742472773866]
["CNY-TWD","CNY","TWD",5.1045803971812944]
["CZK-AUD","CZK","AUD",6.8777648830942062E-2]
["CZK-BRL","CZK","BRL",0.16676702211690364]
["CZK-CAD","CZK","CAD",5.0980331753554507E-2]
["CZK-CHF","CZK","CHF",5.1332266982622429E-2]
["CZK-CNY","CZK","CNY",0.31392622432859402]
["CZK-EUR","CZK","EUR",4.7745927156143064E-2]
["CZK-GBP","CZK","GBP",3.3901861965892545E-2]
["CZK-HUG","CZK","HUG",11.808846761453397]
["CZK-INR","CZK","INR",3.199091232227488]
["CZK-JPY","CZK","JPY",6.2895853080568722]
["CZK-KRW","CZK","KRW",56.15880726698262]
["CZK-MXN","CZK","MXN",0.81447867298578203]
["CZK-NOK","CZK","NOK",0.29067930489731442]
["CZK-PLN","CZK","PLN",0.19361465244865719]
["CZK-ROL","CZK","ROL",0.174565560821485]
["CZK-RUB","CZK","RUB",1.5585703001579778]
["CZK-SEK","CZK","SEK",0.32887045813586102]
["CZK-TRY","CZK","TRY",0.13650059241706161]
["CZK-TWD","CZK","TWD",1.6024616508688783]
["EUR-AUD","EUR","AUD",1.4404924760601916]
["EUR-BRL","EUR","BRL",3.492801]
["EUR-CAD","EUR","CAD",1.067742]
["EUR-CHF","EUR","CHF",1.0751129999999998]
["EUR-CNY","EUR","CNY",6.5749319999999996]
["EUR-CZK","EUR","CZK",20.944194815396699]
["EUR-GBP","EUR","GBP",0.71004720161834112]
["EUR-HUG","EUR","HUG",247.32678711704634]
["EUR-INR","EUR","INR",67.002389999999991]
["EUR-JPY","EUR","JPY",131.7303]
["EUR-KRW","EUR","KRW",1176.201]
["EUR-MXN","EUR","MXN",17.058599999999998]
["EUR-NOK","EUR","NOK",6.0880439905734489]
["EUR-PLN","EUR","PLN",4.0551029999999999]
["EUR-ROL","EUR","ROL",3.6561351139041633]
["EUR-RUB","EUR","RUB",32.643000000000001]
["EUR-SEK","EUR","SEK",6.8879269442262379]
["EUR-TRY","EUR","TRY",2.8588949999999995]
["EUR-TWD","EUR","TWD",33.562268999999993]
["GBP-AUD","GBP","AUD",2.0287277701778388]
["GBP-BRL","GBP","BRL",4.9191110000000009]
["GBP-CAD","GBP","CAD",1.503762]
["GBP-CHF","GBP","CHF",1.514143]
["GBP-CNY","GBP","CNY",9.2598520000000004]
["GBP-CZK","GBP","CZK",29.496904948939516]
["GBP-EUR","GBP","EUR",1.408357075023742]
["GBP-HUG","GBP","HUG",348.32443047918309]
["GBP-INR","GBP","INR",94.363290000000006]
["GBP-JPY","GBP","JPY",185.52330000000001]
["GBP-KRW","GBP","KRW",1656.5110000000002]
["GBP-MXN","GBP","MXN",24.0246]
["GBP-NOK","GBP","NOK",8.5741398271798914]
["GBP-PLN","GBP","PLN",5.7110330000000005]
["GBP-ROL","GBP","ROL",5.1491437549096624]
["GBP-RUB","GBP","RUB",45.973000000000006]
["GBP-SEK","GBP","SEK",9.7006606441476855]
["GBP-TRY","GBP","TRY",4.0263450000000001]
[{"$f":"B195&\"-\"&C195","v":"GBP-TWD"},"GBP","TWD",47.267659000000002]
["HUG-AUD","HUG","AUD",5.8242477203995077E-3]
["HUG-BRL","HUG","BRL",1.4122210702341136E-2]
["HUG-CAD","HUG","CAD",4.3171304347826081E-3]
["HUG-CHF","HUG","CHF",4.3469331103678926E-3]
["HUG-CNY","HUG","CNY",2.6583986622073577E-2]
["HUG-CZK","HUG","CZK",8.468227424749164E-2]
["HUG-EUR","HUG","EUR",4.043233697637265E-3]
["HUG-GBP","HUG","GBP",2.8708867724963182E-3]
["HUG-INR","HUG","INR",0.2709063210702341]
["HUG-JPY","HUG","JPY",0.53261638795986621]
["HUG-KRW","HUG","KRW",4.755655518394649]
["HUG-MXN","HUG","MXN",6.8971906354515042E-2]
["HUG-NOK","HUG","NOK",2.4615384615384615E-2]
["HUG-PLN","HUG","PLN",1.6395729096989966E-2]
["HUG-ROL","HUG","ROL",1.4782608695652174E-2]
["HUG-RUB","HUG","RUB",0.13198327759197323]
["HUG-SEK","HUG","SEK",2.7849498327759199E-2]
["HUG-TRY","HUG","TRY",1.1559180602006688E-2]
["HUG-TWD","HUG","TWD",0.13570009698996655]
["INR-AUD","INR","AUD",2.1499120793455156E-2]
["INR-BRL","INR","BRL",5.2129498664152132E-2]
["INR-CAD","INR","CAD",1.5935879302215936E-2]
["INR-CHF","INR","CHF",1.6045890303316046E-2]
["INR-CNY","INR","CNY",9.8129812981298137E-2]
["INR-CZK","INR","CZK",0.31258877206315627]
["INR-EUR","INR","EUR",1.4924840740755669E-2]
["INR-GBP","INR","GBP",1.0597341402572971E-2]
["INR-HUG","INR","HUG",3.6913129086446972]
["INR-JPY","INR","JPY",1.966053748231966]
["INR-KRW","INR","KRW",17.554612604117555]
["INR-MXN","INR","MXN",0.25459688826025462]
["INR-NOK","INR","NOK",9.0863086982023319E-2]
["INR-PLN","INR","PLN",6.0521766462360523E-2]
["INR-ROL","INR","ROL",5.4567234301704216E-2]
["INR-RUB","INR","RUB",0.48719157630048721]
["INR-SEK","INR","SEK",0.10280121267653644]
["INR-TRY","INR","TRY",4.2668552569542668E-2]
["INR-TWD","INR","TWD",0.50091151972340087]
["JPY-AUD","JPY","AUD",1.0935164317246613E-2]
["JPY-BRL","JPY","BRL",2.651478816946443E-2]
["JPY-CAD","JPY","CAD",8.1055155875299767E-3]
["JPY-CHF","JPY","CHF",8.1614708233413262E-3]
["JPY-CNY","JPY","CNY",4.9912070343725017E-2]
["JPY-CZK","JPY","CZK",0.15899299413572049]
["JPY-EUR","JPY","EUR",7.5912679163411918E-3]
["JPY-GBP","JPY","GBP",5.3901585407331587E-3]
["JPY-HUG","JPY","HUG",1.877523903893382]
["JPY-INR","JPY","INR",0.50863309352517982]
["JPY-KRW","JPY","KRW",8.928856914468426]
["JPY-MXN","JPY","MXN",0.12949640287769784]
["JPY-NOK","JPY","NOK",4.6215973018914017E-2]
["JPY-PLN","JPY","PLN",3.0783373301358913E-2]
["JPY-ROL","JPY","ROL",2.7754701187989124E-2]
["JPY-RUB","JPY","RUB",0.2478017585931255]
["JPY-SEK","JPY","SEK",5.2288098821806663E-2]
["JPY-TRY","JPY","TRY",2.1702637889688247E-2]
["JPY-TWD","JPY","TWD",0.25478017585931251]
["KRW-AUD","KRW","AUD",1.2246992444830361E-3]
["KRW-BRL","KRW","BRL",2.9695613249776189E-3]
["KRW-CAD","KRW","CAD",9.077887197851388E-4]
["KRW-CHF","KRW","CHF",9.1405550581915836E-4]
["KRW-CNY","KRW","CNY",5.5899731423455683E-3]
["KRW-CZK","KRW","CZK",1.7806645986014891E-2]
[{"$f":"B259&\"-\"&C259","v":"KRW-EUR"},"KRW","EUR",8.5019482214349431E-4]
["KRW-GBP","KRW","GBP",6.0367845429339139E-4]
["KRW-HUG","KRW","HUG",0.21027595378429909]
["KRW-INR","KRW","INR",5.6965085049239028E-2]
["KRW-JPY","KRW","JPY",0.11199641897940912]
["KRW-MXN","KRW","MXN",1.4503133393017009E-2]
["KRW-NOK","KRW","NOK",5.1760234777673622E-3]
["KRW-PLN","KRW","PLN",3.4476275738585496E-3]
["KRW-ROL","KRW","ROL",3.1084271428983342E-3]
["KRW-RUB","KRW","RUB",2.775290957923008E-2]
["KRW-SEK","KRW","SEK",5.8560798232838076E-3]
["KRW-TRY","KRW","TRY",2.4306177260519247E-3]
["KRW-TWD","KRW","TWD",2.8534467323187106E-2]
["MXN-AUD","MXN","AUD",8.4443768894293295E-2]
["MXN-BRL","MXN","BRL",0.20475308641975312]
["MXN-CAD","MXN","CAD",6.2592592592592602E-2]
["MXN-CHF","MXN","CHF",6.3024691358024687E-2]
["MXN-CNY","MXN","CNY",0.38543209876543211]
["MXN-CZK","MXN","CZK",1.2277792324925083]
["MXN-EUR","MXN","EUR",5.8621457798412539E-2]
["MXN-GBP","MXN","GBP",4.1624002064550504E-2]
["MXN-HUG","MXN","HUG",14.498656813398894]
["MXN-INR","MXN","INR",3.9277777777777776]
["MXN-JPY","MXN","JPY",7.7222222222222223]
["MXN-KRW","MXN","KRW",68.950617283950621]
["MXN-NOK","MXN","NOK",0.35689001386828045]
["MXN-PLN","MXN","PLN",0.23771604938271607]
["MXN-ROL","MXN","ROL",0.21432797028502712]
["MXN-RUB","MXN","RUB",1.9135802469135803]
["MXN-SEK","MXN","SEK",0.40378031867950703]
["MXN-TRY","MXN","TRY",0.1675925925925926]
["MXN-TWD","MXN","TWD",1.9674691358024692]
["NOK-AUD","NOK","AUD",0.23661006364123]
["NOK-BRL","NOK","BRL",0.57371480978260869]
["NOK-CAD","NOK","CAD",0.17538342391304348]
["NOK-CHF","NOK","CHF",0.17659415760869562]
["NOK-CNY","NOK","CNY",1.0799744565217391]
["NOK-CZK","NOK","CZK",3.4402173913043477]
["NOK-EUR","NOK","EUR",0.16425636896651391]
["NOK-GBP","NOK","GBP",0.11662977513266293]
["NOK-HUG","NOK","HUG",40.625]
["NOK-INR","NOK","INR",11.00556929347826]
["NOK-JPY","NOK","JPY",21.637540760869562]
["NOK-KRW","NOK","KRW",193.19850543478259]
["NOK-MXN","NOK","MXN",2.8019836956521735]
["NOK-PLN","NOK","PLN",0.66607649456521734]
["NOK-ROL","NOK","ROL",0.60054347826086951]
["NOK-RUB","NOK","RUB",5.3618206521739129]
["NOK-SEK","NOK","SEK",1.1313858695652175]
["NOK-TRY","NOK","TRY",0.46959171195652172]
["NOK-TWD","NOK","TWD",5.5128164402173905]
["PLN-AUD","PLN","AUD",0.35522956533044703]
["PLN-BRL","PLN","BRL",0.86133471825499874]
["PLN-CAD","PLN","CAD",0.26330823162814854]
["PLN-CHF","PLN","CHF",0.2651259413139444]
["PLN-CNY","PLN","CNY",1.6213970397299402]
["PLN-CZK","PLN","CZK",5.1648983553307284]
["PLN-EUR","PLN","EUR",0.24660286064250406]
["PLN-GBP","PLN","GBP",0.17509967111028776]
["PLN-HUG","PLN","HUG",60.991493216583244]
["PLN-INR","PLN","INR",16.522981043884705]
["PLN-JPY","PLN","JPY",32.48506881329525]
["PLN-KRW","PLN","KRW",290.05453129057389]
["PLN-MXN","PLN","MXN",4.2066995585562195]
[{"$f":"B323&\"-\"&C323","v":"PLN-NOK"},"PLN","NOK",1.5013290637928185]
["PLN-ROL","PLN","ROL",0.9016133779842741]
["PLN-RUB","PLN","RUB",8.0498571799532588]
["PLN-SEK","PLN","SEK",1.6985824883427718]
["PLN-TRY","PLN","TRY",0.70501168527655156]
["PLN-TWD","PLN","TWD",8.2765515450532323]
["ROL-AUD","ROL","AUD",0.39399322814467258]
["ROL-BRL","ROL","BRL",0.95532601809954754]
["ROL-CAD","ROL","CAD",0.29204117647058819]
["ROL-CHF","ROL","CHF",0.2940572398190045]
["ROL-CNY","ROL","CNY",1.79832850678733]
["ROL-CZK","ROL","CZK",5.7285067873303168]
["ROL-EUR","ROL","EUR",0.27351286778134443]
["ROL-GBP","ROL","GBP",0.19420704637475092]
["ROL-HUG","ROL","HUG",67.647058823529406]
["ROL-INR","ROL","INR",18.32601583710407]
["ROL-JPY","ROL","JPY",36.029932126696828]
["ROL-KRW","ROL","KRW",321.70610859728504]
["ROL-MXN","ROL","MXN",4.6657466063348414]
["ROL-NOK","ROL","NOK",1.6651583710407241]
["ROL-PLN","ROL","PLN",1.109122850678733]
["ROL-RUB","ROL","RUB",8.9282805429864247]
["ROL-SEK","ROL","SEK",1.8839366515837106]
["ROL-TRY","ROL","TRY",0.78194457013574648]
["ROL-TWD","ROL","TWD",9.1797124434389126]
["RUB-AUD","RUB","AUD",4.4128679228630688E-2]
["RUB-BRL","RUB","BRL",0.107]
["RUB-CAD","RUB","CAD",3.2709677419354835E-2]
["RUB-CHF","RUB","CHF",3.2935483870967737E-2]
["RUB-CNY","RUB","CNY",0.20141935483870965]
["RUB-CZK","RUB","CZK",0.64161366343156878]
["RUB-EUR","RUB","EUR",3.0634439236589775E-2]
["RUB-GBP","RUB","GBP",2.175189785308768E-2]
["RUB-HUG","RUB","HUG",7.5767174315181309]
["RUB-INR","RUB","INR",2.05258064516129]
["RUB-JPY","RUB","JPY",4.0354838709677416]
["RUB-KRW","RUB","KRW",36.032258064516128]
["RUB-MXN","RUB","MXN",0.52258064516129032]
["RUB-NOK","RUB","NOK",0.18650381369890784]
["RUB-PLN","RUB","PLN",0.12422580645161289]
["RUB-ROL","RUB","ROL",0.11200364898765933]
["RUB-SEK","RUB","SEK",0.21100777943896817]
["RUB-TRY","RUB","TRY",8.7580645161290313E-2]
["RUB-TWD","RUB","TWD",1.0281612903225805]
["SEK-AUD","SEK","AUD",0.20913294924936385]
["SEK-BRL","SEK","BRL",0.50709030863456228]
["SEK-CAD","SEK","CAD",0.15501645250390295]
["SEK-CHF","SEK","CHF",0.15608658580521192]
["SEK-CNY","SEK","CNY",0.95455890476762328]
["SEK-CZK","SEK","CZK",3.0407109403146388]
["SEK-EUR","SEK","EUR",0.14518156305915003]
["SEK-GBP","SEK","GBP",0.10308576257672621]
["SEK-HUG","SEK","HUG",35.907289540050435]
["SEK-INR","SEK","INR",9.7275117088987617]
["SEK-JPY","SEK","JPY",19.124810856250747]
["SEK-KRW","SEK","KRW",170.76269965173529]
["SEK-MXN","SEK","MXN",2.4765942116008164]
["SEK-NOK","SEK","NOK",0.88387174252431844]
["SEK-PLN","SEK","PLN",0.58872619190584841]
["SEK-ROL","SEK","ROL",0.53080341059204994]
["SEK-RUB","SEK","RUB",4.7391617629398342]
["SEK-TRY","SEK","TRY",0.41505884472198867]
["SEK-TWD","SEK","TWD",4.8726226732316551]
["TRY-AUD","TRY","AUD",0.50386337240793788]
[{"$f":"B387&\"-\"&C387","v":"TRY-BRL"},"TRY","BRL",1.2217311233885819]
["TRY-CAD","TRY","CAD",0.37348066298342542]
["TRY-CHF","TRY","CHF",0.3760589318600368]
["TRY-CNY","TRY","CNY",2.299815837937385]
["TRY-CZK","TRY","CZK",7.3259755308945245]
["TRY-EUR","TRY","EUR",0.34978549404577647]
["TRY-GBP","TRY","GBP",0.24836421121389249]
["TRY-HUG","TRY","HUG",86.511322422490636]
["TRY-INR","TRY","INR",23.436464088397788]
["TRY-JPY","TRY","JPY",46.077348066298342]
["TRY-KRW","TRY","KRW",411.41804788213631]
["TRY-MXN","TRY","MXN",5.9668508287292816]
["TRY-NOK","TRY","NOK",2.129509475015154]
["TRY-PLN","TRY","PLN",1.4184162062615102]
["TRY-ROL","TRY","ROL",1.2788630271150789]
["TRY-RUB","TRY","RUB",11.41804788213628]
["TRY-SEK","TRY","SEK",2.40929692913739]
["TRY-TWD","TRY","TWD",11.739594843462246]
["TWD-AUD","TWD","AUD",4.2919996739797052E-2]
["TWD-BRL","TWD","BRL",0.10406927493489788]
["TWD-CAD","TWD","CAD",3.1813760863426729E-2]
["TWD-CHF","TWD","CHF",3.2033382486744262E-2]
["TWD-CNY","TWD","CNY",0.195902487999247]
["TWD-CZK","TWD","CZK",0.62403989478174737]
["TWD-EUR","TWD","EUR",2.9795363358776493E-2]
["TWD-GBP","TWD","GBP",2.1156114374100907E-2]
["TWD-HUG","TWD","HUG",7.369191490511156]
["TWD-INR","TWD","INR",1.9963605559564521]
["TWD-JPY","TWD","JPY",3.9249521538606342]
["TWD-KRW","TWD","KRW",35.045336177956266]
["TWD-MXN","TWD","MXN",0.50826718539202465]
["TWD-NOK","TWD","NOK",0.18139548284335155]
["TWD-PLN","TWD","PLN",0.12082326734226462]
["TWD-ROL","TWD","ROL",0.10893587420755622]
["TWD-RUB","TWD","RUB",0.97261004612054092]
["TWD-SEK","TWD","SEK",0.20522828609192778]
["TWD-TRY","TWD","TRY",8.5181815329589308E-2]
["USD-USD","USD","USD",1]
["AUD-AUD","AUD","AUD",1]
["BRL-BRL","BRL","BRL",1]
["CAD-CAD","CAD","CAD",1]
["CHF-CHF","CHF","CHF",1]
["CNY-CNY","CNY","CNY",1]
["CZK-CZK","CZK","CZK",1]
["EUR-EUR","EUR","EUR",1]
["GBP-GBP","GBP","GBP",1]
["HUG-HUG","HUG","HUG",1]
["INR-INR","INR","INR",1]
["JPY-JPY","JPY","JPY",1]
["KRW-KRW","KRW","KRW",1]
["MXN-MXN","MXN","MXN",1]
["NOK-NOK","NOK","NOK",1]
["PLN-PLN","PLN","PLN",1]
["ROL-ROL","ROL","ROL",1]
["RUB-RUB","RUB","RUB",1]
["SEK-SEK","SEK","SEK",1]
["TRY-TRY","TRY","TRY",1]
["TWD-TWD","TWD","TWD",1]