{"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":1133,"n_cols":44,"rows_kept":1133,"cut":false,"hidden":false,"merged":[[867,3,882,3],[890,3,905,3],[701,3,705,3],[683,3,698,3],[706,3,721,3],[593,4,593,6],[616,4,616,6],[662,4,662,6],[685,4,685,6],[885,3,889,3],[816,4,816,6],[817,4,817,6],[818,4,818,6],[812,4,812,6],[813,4,813,6],[819,4,819,6],[788,4,788,6],[902,4,902,6],[903,4,903,6],[891,4,891,6],[893,4,893,6],[896,4,896,6],[807,4,807,6],[804,4,804,6],[517,3,521,3],[494,3,498,3],[522,3,537,3],[787,4,787,6],[784,4,784,6],[785,4,785,6],[762,4,762,6],[761,4,761,6],[764,4,764,6],[782,4,782,6],[778,4,778,6],[773,4,773,6],[770,4,770,6],[766,4,766,6],[724,3,728,3],[763,4,763,6],[715,4,715,6],[767,4,767,6],[738,4,738,6],[634,4,634,6],[635,4,635,6],[636,4,636,6],[643,4,643,6],[765,4,765,6],[456,4,456,6],[517,4,517,6],[522,4,522,6],[523,4,523,6],[520,4,520,6],[521,4,521,6],[519,4,519,6],[477,4,477,6],[516,4,516,6],[527,4,527,6],[540,4,540,6],[541,4,541,6],[552,4,552,6],[551,4,551,6],[546,4,546,6],[572,4,572,6],[507,4,507,6],[476,4,476,6],[558,4,558,6],[570,4,570,6],[492,4,492,6],[515,4,515,6],[538,4,538,6],[561,4,561,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],[708,4,708,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],[333,3,341,3],[333,4,333,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],[438,4,438,6],[439,4,439,6],[632,4,632,6],[619,4,619,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],[450,4,450,6],[451,4,451,6],[472,4,472,6],[553,4,553,6],[587,4,587,6],[582,4,582,6],[268,4,268,6],[264,4,264,6],[265,4,265,6],[46,4,46,6],[49,4,49,6],[269,4,269,6],[270,4,270,6],[277,4,277,6],[278,4,278,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],[47,4,47,6],[51,4,51,6],[911,4,911,6],[910,4,910,6],[912,4,912,6],[930,3,930,6],[918,3,928,3],[939,3,940,3],[939,4,939,6],[940,4,940,6],[932,3,932,6],[943,4,943,6],[934,3,934,6],[935,3,935,6],[936,3,936,6],[931,3,931,6],[917,3,917,6],[933,3,933,6],[927,4,927,6],[923,4,923,6],[926,4,926,6],[942,4,942,6],[858,4,858,6],[859,4,859,6],[843,4,843,6],[882,4,882,6],[886,4,886,6],[850,4,850,6],[888,4,888,6],[866,4,866,6],[853,4,853,6],[852,4,852,6],[856,4,856,6],[857,4,857,6],[879,4,879,6],[880,4,880,6],[867,4,867,6],[870,4,870,6],[845,4,845,6],[849,4,849,6],[887,4,887,6],[885,4,885,6],[868,4,868,6],[862,4,862,6],[860,4,860,6],[883,4,883,6],[889,4,889,6],[810,4,810,6],[811,4,811,6],[833,4,833,6],[834,4,834,6],[904,4,904,6],[847,4,847,6],[832,4,832,6],[908,4,908,6],[876,4,876,6],[901,4,901,6],[905,4,905,6],[877,4,877,6],[878,4,878,6],[890,4,890,6],[895,4,895,6],[844,4,844,6],[836,4,836,6],[830,4,830,6],[831,4,831,6],[848,4,848,6],[842,4,842,6],[865,4,865,6],[881,4,881,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],[955,3,955,6],[937,3,937,6],[953,3,953,6],[950,3,950,6],[942,3,946,3],[944,4,944,6],[945,4,945,6],[946,4,946,6],[894,4,894,6],[914,4,914,6],[900,4,900,6],[897,4,897,6],[916,4,916,5],[899,4,899,6],[809,4,809,6],[803,4,803,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],[799,4,799,6],[801,4,801,6],[802,4,802,6],[789,4,789,6],[796,4,796,6],[721,4,721,6],[729,4,729,6],[615,4,615,6],[797,4,797,6],[790,4,790,6],[734,4,734,6],[728,4,728,6],[793,4,793,6],[798,4,798,6],[779,4,779,6],[776,4,776,6],[774,4,774,6],[775,4,775,6],[786,4,786,6],[794,4,794,6],[626,4,626,6],[627,4,627,6],[661,4,661,6],[620,4,620,6],[437,4,437,6],[534,4,534,6],[545,4,545,6],[543,4,543,6],[468,4,468,6],[484,4,484,6],[518,4,518,6],[514,4,514,6],[495,4,495,6],[502,4,502,6],[530,4,530,6],[482,4,482,6],[486,4,486,6],[487,4,487,6],[491,4,491,6],[483,4,483,6],[480,4,480,6],[500,4,500,6],[503,4,503,6],[504,4,504,6],[509,4,509,6],[506,4,506,6],[525,4,525,6],[526,4,526,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],[586,3,590,3],[588,4,588,6],[540,3,544,3],[528,4,528,6],[453,3,469,3],[478,4,478,6],[476,3,491,3],[501,4,501,6],[499,3,514,3],[567,4,567,6],[573,4,573,6],[579,4,579,6],[535,4,535,6],[465,4,465,6],[466,4,466,6],[489,4,489,6],[455,4,455,6],[575,4,575,6],[556,4,556,6],[547,4,547,6],[510,4,510,6],[562,4,562,6],[549,4,549,6],[560,4,560,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],[293,3,301,3],[279,4,279,6],[280,4,280,6],[293,4,293,6],[294,4,294,6],[295,4,295,6],[296,4,296,6],[297,4,297,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],[220,4,220,6],[214,4,214,6],[227,4,227,6],[228,4,228,6],[229,4,229,6],[666,4,666,6],[732,4,732,6],[697,4,697,6],[698,4,698,6],[695,4,695,6],[696,4,696,6],[694,4,694,6],[701,4,701,6],[709,4,709,6],[705,4,705,6],[704,4,704,6],[707,4,707,6],[717,4,717,6],[720,4,720,6],[710,4,710,6],[711,4,711,6],[712,4,712,6],[680,4,680,6],[673,4,673,6],[687,4,687,6],[689,4,689,6],[716,4,716,6],[688,4,688,6],[730,4,730,6],[644,4,644,6],[683,4,683,6],[651,4,651,6],[641,4,641,6],[638,4,638,6],[672,4,672,6],[665,4,665,6],[684,4,684,6],[686,4,686,6],[652,4,652,6],[646,4,646,6],[647,4,647,6],[648,4,648,6],[659,4,659,6],[655,4,655,6],[664,4,664,6],[669,4,669,6],[663,4,663,6],[649,4,649,6],[650,4,650,6],[660,4,660,6],[657,4,657,6],[682,4,682,6],[670,4,670,6],[471,3,475,3],[471,4,471,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],[122,3,133,3],[263,3,271,3],[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],[67,4,67,6],[72,4,72,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],[80,4,80,6],[141,4,141,6],[85,4,85,6],[125,4,125,6],[126,4,126,6],[135,4,135,6],[100,4,100,6],[101,4,101,6],[115,4,115,6],[161,3,172,3],[174,3,185,3],[174,4,174,6],[175,4,175,6],[163,4,163,6],[171,4,171,6],[181,4,181,6],[169,4,169,6],[178,4,178,6],[135,3,146,3],[140,4,140,6],[128,4,128,6],[127,4,127,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],[215,4,215,6],[211,4,211,6],[213,4,213,6],[209,4,209,6],[221,4,221,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],[542,4,542,6],[496,4,496,6],[453,4,453,6],[485,4,485,6],[474,4,474,6],[457,4,457,6],[463,4,463,6],[473,4,473,6],[479,4,479,6],[469,4,469,6],[458,4,458,6],[460,4,460,6],[459,4,459,6],[467,4,467,6],[462,4,462,6],[464,4,464,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],[569,4,569,6],[571,4,571,6],[490,4,490,6],[494,4,494,6],[505,4,505,6],[566,4,566,6],[508,4,508,6],[513,4,513,6],[511,4,511,6],[544,4,544,6],[536,4,536,6],[533,4,533,6],[563,4,563,6],[548,4,548,6],[554,4,554,6],[559,4,559,6],[454,4,454,6],[275,4,275,6],[188,4,188,6],[822,4,822,6],[752,4,752,6],[780,4,780,6],[781,4,781,6],[840,4,840,6],[841,4,841,6],[835,4,835,6],[874,4,874,6],[826,4,826,6],[827,4,827,6],[821,4,821,6],[825,4,825,6],[839,4,839,6],[863,4,863,6],[864,4,864,6],[873,4,873,6],[871,4,871,6],[872,4,872,6],[869,4,869,6],[820,4,820,6],[795,4,795,6],[855,4,855,6],[854,4,854,6],[805,4,805,6],[632,3,636,3],[678,3,682,3],[1000,0,1013,2],[729,3,744,3],[752,3,767,3],[775,3,790,3],[798,3,813,3],[821,3,836,3],[844,3,859,3],[954,3,954,6],[948,3,948,6],[951,3,951,6],[949,3,949,6],[952,3,952,6],[667,4,667,6],[671,4,671,6],[674,4,674,6],[675,4,675,6],[681,4,681,6],[747,3,751,3],[771,4,771,6],[772,4,772,6],[770,3,774,3],[656,4,656,6],[1026,0,1039,2],[102,4,102,6],[167,4,167,6],[563,3,567,3],[574,4,574,6],[613,4,613,6],[824,4,824,6],[816,3,820,3],[839,3,843,3],[793,3,797,3],[862,3,866,3],[609,3,613,3],[706,4,706,6],[750,4,750,6],[749,4,749,6],[829,4,829,6],[928,4,928,6],[924,4,924,6],[922,4,922,6],[925,4,925,6],[581,4,581,6],[603,4,603,6],[623,4,623,6],[604,4,604,6],[78,4,78,6],[86,4,86,6],[564,4,564,6],[537,4,537,6],[194,4,194,6],[176,4,176,6],[139,4,139,6],[130,4,130,6],[132,4,132,6],[256,4,256,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],[488,4,488,6],[156,4,156,6],[157,4,157,6],[161,4,161,6],[162,4,162,6],[164,4,164,6],[481,4,481,6],[759,4,759,6],[690,4,690,6],[692,4,692,6],[693,4,693,6],[733,4,733,6],[744,4,744,6],[739,4,739,6],[740,4,740,6],[77,4,77,6],[91,4,91,6],[92,4,92,6],[93,4,93,6],[81,4,81,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],[217,4,217,6],[218,4,218,6],[204,4,204,6],[206,4,206,6],[219,4,219,6],[609,4,609,6],[594,4,594,6],[597,4,597,6],[599,4,599,6],[612,4,612,6],[642,4,642,6],[610,4,610,6],[756,4,756,6],[726,4,726,6],[735,4,735,6],[747,4,747,6],[753,4,753,6],[755,4,755,6],[724,4,724,6],[727,4,727,6],[741,4,741,6],[743,4,743,6],[714,4,714,6],[737,4,737,6],[725,4,725,6],[742,4,742,6],[748,4,748,6],[718,4,718,6],[719,4,719,6],[731,4,731,6],[754,4,754,6],[777,4,777,6],[800,4,800,6],[823,4,823,6],[846,4,846,6],[531,4,531,6],[532,4,532,6],[498,4,498,6],[524,4,524,6],[751,4,751,6],[713,4,713,6],[736,4,736,6],[757,4,757,6],[758,4,758,6],[658,4,658,6],[640,4,640,6],[598,4,598,6],[629,4,629,6],[601,4,601,6],[760,4,760,6],[577,4,577,6],[808,4,808,6],[837,4,837,6],[655,3,659,3],[622,4,622,6],[645,4,645,6],[668,4,668,6],[691,4,691,6],[497,4,497,6],[499,4,499,6],[475,4,475,6],[545,3,560,3],[568,3,583,3],[591,3,606,3],[614,3,629,3],[637,3,652,3],[660,3,675,3],[493,4,493,6],[512,4,512,6],[580,4,580,6],[529,4,529,6],[578,4,578,6],[555,4,555,6],[550,4,550,6],[568,4,568,6],[565,4,565,6],[557,4,557,6],[906,4,906,6],[783,4,783,6],[828,4,828,6],[851,4,851,6],[875,4,875,6],[898,4,898,6],[806,4,806,6],[607,4,607,6],[630,4,630,6],[653,4,653,6],[676,4,676,6],[699,4,699,6],[722,4,722,6],[745,4,745,6],[768,4,768,6],[791,4,791,6],[814,4,814,6],[633,4,633,6],[621,4,621,6],[637,4,637,6],[624,4,624,6],[639,4,639,6],[892,4,892,6],[618,4,618,6],[576,4,576,6],[678,4,678,6],[679,4,679,6],[625,4,625,6],[628,4,628,6],[602,4,602,6],[702,4,702,6],[703,4,703,6],[583,4,583,6],[589,4,589,6],[591,4,591,6],[592,4,592,6],[585,4,585,6],[590,4,590,6],[586,4,586,6],[600,4,600,6],[596,4,596,6],[595,4,595,6],[584,4,584,6],[614,4,614,6],[611,4,611,6],[605,4,605,6],[617,4,617,6],[606,4,606,6]]}
[]
[]
[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.20"]
[null,null,null,null,null,null,null,"Author","Document #","Date",null,null,null,null,null,null,"2018-01-09"]
[]
[]
[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":"H955","v":0},{"$f":"I955","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)))","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)))","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)))","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)))","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)))","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)))","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)))","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)))","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)))","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)))","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,"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,"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":"I54","v":0},{"$f":"J54","v":0},{"$f":"K54","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)))*((H462*H451)+H465+H466+H467)","v":0},0,0,0,0,0,0,0,0,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)),1+(1-H459),1+(1-H459))))","v":0},{"$f":"IF(AND(I457=0,NOT(ISNUMBER(I457))),0,(1/I457)*(IF(AND(ISNUMBER(I459)),1+(1-I459),1+(1-I459))))","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,"Direct Labor Wage Rate"]
[null,null,null,null,"Set Up 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(H463),H463,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":"(H465+H466+H467)*H460","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Sub-Total Cost",null,null,{"$f":"H464+H468","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Process Scrap %"]
[]
[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(H475=0,NOT(ISNUMBER(H473))),0,(H473/60)/IF(ISNUMBER(H475),H475,(H77))/IF(ISNUMBER(H479),H479,1)))*((H485*H474)+H488+H489+H490)","v":0},0,0,0,0,0,0,0,0,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(H480=0,NOT(ISNUMBER(H480))),0,(1/H480)*(IF(AND(ISNUMBER(H482)),1+(1-H482),1+(1-H482))))","v":0},{"$f":"IF(AND(I480=0,NOT(ISNUMBER(I480))),0,(1/I480)*(IF(AND(ISNUMBER(I482)),1+(1-I482),1+(1-I482))))","v":0},{"$f":"IF(AND(J480=0,NOT(ISNUMBER(J480))),0,(1/J480)*(IF(AND(ISNUMBER(J482)),1+(1-J482),1+(1-J482))))","v":0},{"$f":"IF(AND(K480=0,NOT(ISNUMBER(K480))),0,(1/K480)*(IF(AND(ISNUMBER(K482)),1+(1-K482),1+(1-K482))))","v":0},{"$f":"IF(AND(L480=0,NOT(ISNUMBER(L480))),0,(1/L480)*(IF(AND(ISNUMBER(L482)),1+(1-L482),1+(1-L482))))","v":0},{"$f":"IF(AND(M480=0,NOT(ISNUMBER(M480))),0,(1/M480)*(IF(AND(ISNUMBER(M482)),1+(1-M482),1+(1-M482))))","v":0},{"$f":"IF(AND(N480=0,NOT(ISNUMBER(N480))),0,(1/N480)*(IF(AND(ISNUMBER(N482)),1+(1-N482),1+(1-N482))))","v":0},{"$f":"IF(AND(O480=0,NOT(ISNUMBER(O480))),0,(1/O480)*(IF(AND(ISNUMBER(O482)),1+(1-O482),1+(1-O482))))","v":0},{"$f":"IF(AND(P480=0,NOT(ISNUMBER(P480))),0,(1/P480)*(IF(AND(ISNUMBER(P482)),1+(1-P482),1+(1-P482))))","v":0},{"$f":"IF(AND(Q480=0,NOT(ISNUMBER(Q480))),0,(1/Q480)*(IF(AND(ISNUMBER(Q482)),1+(1-Q482),1+(1-Q482))))","v":0}]
[null,null,null,null,"Direct Labor Wage Rate"]
[null,null,null,null,"Set Up Labor Wage Rate"]
[null,null,null,null,"No. of Direct Operators"]
[null,null,null,null,"Direct Labor Cost /Assembly",null,null,{"$f":"IF(AND(H483=\"\",H484=\"\"),0,H483*H484*IF(ISNUMBER(H486),H486,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":"(H488+H489+H490)*H483","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Sub-Total Cost",null,null,{"$f":"H487+H491","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Process Scrap %"]
[]
[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":"H515*6.5*1000/H61*1000","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Set Up Costs Per Piece",null,null,{"$f":"(IF(AND(H498=0,NOT(ISNUMBER(H496))),0,(H496/60)/IF(ISNUMBER(H498),H498,(H99))/IF(ISNUMBER(H502),H502,1)))*((H508*H497)+H511+H512+H513)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"I515*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(H503=0,NOT(ISNUMBER(H503))),0,(1/H503)*(IF(AND(ISNUMBER(H505)),1+(1-H505),1+(1-H505))))","v":0},{"$f":"IF(AND(I503=0,NOT(ISNUMBER(I503))),0,(1/I503)*(IF(AND(ISNUMBER(I505)),1+(1-I505),1+(1-I505))))","v":0},{"$f":"IF(AND(J503=0,NOT(ISNUMBER(J503))),0,(1/J503)*(IF(AND(ISNUMBER(J505)),1+(1-J505),1+(1-J505))))","v":0},{"$f":"IF(AND(K503=0,NOT(ISNUMBER(K503))),0,(1/K503)*(IF(AND(ISNUMBER(K505)),1+(1-K505),1+(1-K505))))","v":0},{"$f":"IF(AND(L503=0,NOT(ISNUMBER(L503))),0,(1/L503)*(IF(AND(ISNUMBER(L505)),1+(1-L505),1+(1-L505))))","v":0},{"$f":"IF(AND(M503=0,NOT(ISNUMBER(M503))),0,(1/M503)*(IF(AND(ISNUMBER(M505)),1+(1-M505),1+(1-M505))))","v":0},{"$f":"IF(AND(N503=0,NOT(ISNUMBER(N503))),0,(1/N503)*(IF(AND(ISNUMBER(N505)),1+(1-N505),1+(1-N505))))","v":0},{"$f":"IF(AND(O503=0,NOT(ISNUMBER(O503))),0,(1/O503)*(IF(AND(ISNUMBER(O505)),1+(1-O505),1+(1-O505))))","v":0},{"$f":"IF(AND(P503=0,NOT(ISNUMBER(P503))),0,(1/P503)*(IF(AND(ISNUMBER(P505)),1+(1-P505),1+(1-P505))))","v":0},{"$f":"IF(AND(Q503=0,NOT(ISNUMBER(Q503))),0,(1/Q503)*(IF(AND(ISNUMBER(Q505)),1+(1-Q505),1+(1-Q505))))","v":0}]
[null,null,null,null,"Direct Labor Wage Rate"]
[null,null,null,null,"Set Up Labor Wage Rate"]
[null,null,null,null,"No. of Direct Operators"]
[null,null,null,null,"Direct Labor Cost /Assembly",null,null,{"$f":"IF(AND(H506=\"\",H507=\"\"),0,H506*H507*IF(ISNUMBER(H509),H509,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":"(H511+H512+H513)*H506","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Sub-Total Cost",null,null,{"$f":"H510+H514","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Process Scrap %"]
[]
[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":"H538*1000*6.5/H61*1000","v":{"$error":"#DIV/0!"}},{"$f":"H538*1000*6.5","v":0}]
[null,null,null,null,"Set Up Costs Per Piece",null,null,{"$f":"(IF(AND(H521=0,NOT(ISNUMBER(H519))),0,(H519/60)/IF(ISNUMBER(H521),H521,(H121))/IF(ISNUMBER(H525),H525,1)))*((H531*H520)+H534+H535+H536)","v":0},0,0,0,0,0,0,0,0,0,null,{"$f":"I538*1000*6.5/H61*1000","v":{"$error":"#DIV/0!"}},{"$f":"I538*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(H526=0,NOT(ISNUMBER(H526))),0,(1/H526)*(IF(AND(ISNUMBER(H528)),1+(1-H528),1+(1-H528))))","v":0},{"$f":"IF(AND(I526=0,NOT(ISNUMBER(I526))),0,(1/I526)*(IF(AND(ISNUMBER(I528)),1+(1-I528),1+(1-I528))))","v":0},{"$f":"IF(AND(J526=0,NOT(ISNUMBER(J526))),0,(1/J526)*(IF(AND(ISNUMBER(J528)),1+(1-J528),1+(1-J528))))","v":0},{"$f":"IF(AND(K526=0,NOT(ISNUMBER(K526))),0,(1/K526)*(IF(AND(ISNUMBER(K528)),1+(1-K528),1+(1-K528))))","v":0},{"$f":"IF(AND(L526=0,NOT(ISNUMBER(L526))),0,(1/L526)*(IF(AND(ISNUMBER(L528)),1+(1-L528),1+(1-L528))))","v":0},{"$f":"IF(AND(M526=0,NOT(ISNUMBER(M526))),0,(1/M526)*(IF(AND(ISNUMBER(M528)),1+(1-M528),1+(1-M528))))","v":0},{"$f":"IF(AND(N526=0,NOT(ISNUMBER(N526))),0,(1/N526)*(IF(AND(ISNUMBER(N528)),1+(1-N528),1+(1-N528))))","v":0},{"$f":"IF(AND(O526=0,NOT(ISNUMBER(O526))),0,(1/O526)*(IF(AND(ISNUMBER(O528)),1+(1-O528),1+(1-O528))))","v":0},{"$f":"IF(AND(P526=0,NOT(ISNUMBER(P526))),0,(1/P526)*(IF(AND(ISNUMBER(P528)),1+(1-P528),1+(1-P528))))","v":0},{"$f":"IF(AND(Q526=0,NOT(ISNUMBER(Q526))),0,(1/Q526)*(IF(AND(ISNUMBER(Q528)),1+(1-Q528),1+(1-Q528))))","v":0}]
[null,null,null,null,"Direct Labor Wage Rate"]
[null,null,null,null,"Set Up Labor Wage Rate"]
[null,null,null,null,"No. of Direct Operators"]
[null,null,null,null,"Direct Labor Cost /Assembly",null,null,{"$f":"IF(AND(H529=\"\",H530=\"\"),0,H529*H530*IF(ISNUMBER(H532),H532,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":"(H534+H535+H536)*H529","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Sub-Total Cost",null,null,{"$f":"H533+H537","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Process Scrap %"]
[]
[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(H544=0,NOT(ISNUMBER(H542))),0,(H542/60)/IF(ISNUMBER(H544),H544,(H143))/IF(ISNUMBER(H548),H548,1)))*((H554*H543)+H557+H558+H559)","v":0},0,0,0,0,0,0,0,0,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(H549=0,NOT(ISNUMBER(H549))),0,(1/H549)*(IF(AND(ISNUMBER(H551)),1+(1-H551),1+(1-H551))))","v":0},{"$f":"IF(AND(I549=0,NOT(ISNUMBER(I549))),0,(1/I549)*(IF(AND(ISNUMBER(I551)),1+(1-I551),1+(1-I551))))","v":0},{"$f":"IF(AND(J549=0,NOT(ISNUMBER(J549))),0,(1/J549)*(IF(AND(ISNUMBER(J551)),1+(1-J551),1+(1-J551))))","v":0},{"$f":"IF(AND(K549=0,NOT(ISNUMBER(K549))),0,(1/K549)*(IF(AND(ISNUMBER(K551)),1+(1-K551),1+(1-K551))))","v":0},{"$f":"IF(AND(L549=0,NOT(ISNUMBER(L549))),0,(1/L549)*(IF(AND(ISNUMBER(L551)),1+(1-L551),1+(1-L551))))","v":0},{"$f":"IF(AND(M549=0,NOT(ISNUMBER(M549))),0,(1/M549)*(IF(AND(ISNUMBER(M551)),1+(1-M551),1+(1-M551))))","v":0},{"$f":"IF(AND(N549=0,NOT(ISNUMBER(N549))),0,(1/N549)*(IF(AND(ISNUMBER(N551)),1+(1-N551),1+(1-N551))))","v":0},{"$f":"IF(AND(O549=0,NOT(ISNUMBER(O549))),0,(1/O549)*(IF(AND(ISNUMBER(O551)),1+(1-O551),1+(1-O551))))","v":0},{"$f":"IF(AND(P549=0,NOT(ISNUMBER(P549))),0,(1/P549)*(IF(AND(ISNUMBER(P551)),1+(1-P551),1+(1-P551))))","v":0},{"$f":"IF(AND(Q549=0,NOT(ISNUMBER(Q549))),0,(1/Q549)*(IF(AND(ISNUMBER(Q551)),1+(1-Q551),1+(1-Q551))))","v":0}]
[null,null,null,null,"Direct Labor Wage Rate"]
[null,null,null,null,"Set Up Labor Wage Rate"]
[null,null,null,null,"No. of Direct Operators"]
[null,null,null,null,"Direct Labor Cost /Assembly",null,null,{"$f":"IF(AND(H552=\"\",H553=\"\"),0,H552*H553*IF(ISNUMBER(H555),H555,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":"(H557+H558+H559)*H552","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Sub-Total Cost",null,null,{"$f":"H556+H560","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Process Scrap %"]
[]
[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(H567=0,NOT(ISNUMBER(H565))),0,(H565/60)/IF(ISNUMBER(H567),H567,(H165))/IF(ISNUMBER(H571),H571,1)))*((H577*H566)+H580+H581+H582)","v":0},0,0,0,0,0,0,0,0,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(H572=0,NOT(ISNUMBER(H572))),0,(1/H572)*(IF(AND(ISNUMBER(H574)),1+(1-H574),1+(1-H574))))","v":0},{"$f":"IF(AND(I572=0,NOT(ISNUMBER(I572))),0,(1/I572)*(IF(AND(ISNUMBER(I574)),1+(1-I574),1+(1-I574))))","v":0},{"$f":"IF(AND(J572=0,NOT(ISNUMBER(J572))),0,(1/J572)*(IF(AND(ISNUMBER(J574)),1+(1-J574),1+(1-J574))))","v":0},{"$f":"IF(AND(K572=0,NOT(ISNUMBER(K572))),0,(1/K572)*(IF(AND(ISNUMBER(K574)),1+(1-K574),1+(1-K574))))","v":0},{"$f":"IF(AND(L572=0,NOT(ISNUMBER(L572))),0,(1/L572)*(IF(AND(ISNUMBER(L574)),1+(1-L574),1+(1-L574))))","v":0},{"$f":"IF(AND(M572=0,NOT(ISNUMBER(M572))),0,(1/M572)*(IF(AND(ISNUMBER(M574)),1+(1-M574),1+(1-M574))))","v":0},{"$f":"IF(AND(N572=0,NOT(ISNUMBER(N572))),0,(1/N572)*(IF(AND(ISNUMBER(N574)),1+(1-N574),1+(1-N574))))","v":0},{"$f":"IF(AND(O572=0,NOT(ISNUMBER(O572))),0,(1/O572)*(IF(AND(ISNUMBER(O574)),1+(1-O574),1+(1-O574))))","v":0},{"$f":"IF(AND(P572=0,NOT(ISNUMBER(P572))),0,(1/P572)*(IF(AND(ISNUMBER(P574)),1+(1-P574),1+(1-P574))))","v":0},{"$f":"IF(AND(Q572=0,NOT(ISNUMBER(Q572))),0,(1/Q572)*(IF(AND(ISNUMBER(Q574)),1+(1-Q574),1+(1-Q574))))","v":0}]
[null,null,null,null,"Direct Labor Wage Rate"]
[null,null,null,null,"Set Up Labor Wage Rate"]
[null,null,null,null,"No. of Direct Operators"]
[null,null,null,null,"Direct Labor Cost /Assembly",null,null,{"$f":"IF(AND(H575=\"\",H576=\"\"),0,H575*H576*IF(ISNUMBER(H578),H578,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":"(H580+H581+H582)*H575","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Sub-Total Cost",null,null,{"$f":"H579+H583","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Process Scrap %"]
[]
[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(H590=0,NOT(ISNUMBER(H588))),0,(H588/60)/IF(ISNUMBER(H590),H590,(H187))/IF(ISNUMBER(H594),H594,1)))*((H600*H589)+H603+H604+H605)","v":0},0,0,0,0,0,0,0,0,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(H595=0,NOT(ISNUMBER(H595))),0,(1/H595)*(IF(AND(ISNUMBER(H597)),1+(1-H597),1+(1-H597))))","v":0},{"$f":"IF(AND(I595=0,NOT(ISNUMBER(I595))),0,(1/I595)*(IF(AND(ISNUMBER(I597)),1+(1-I597),1+(1-I597))))","v":0},{"$f":"IF(AND(J595=0,NOT(ISNUMBER(J595))),0,(1/J595)*(IF(AND(ISNUMBER(J597)),1+(1-J597),1+(1-J597))))","v":0},{"$f":"IF(AND(K595=0,NOT(ISNUMBER(K595))),0,(1/K595)*(IF(AND(ISNUMBER(K597)),1+(1-K597),1+(1-K597))))","v":0},{"$f":"IF(AND(L595=0,NOT(ISNUMBER(L595))),0,(1/L595)*(IF(AND(ISNUMBER(L597)),1+(1-L597),1+(1-L597))))","v":0},{"$f":"IF(AND(M595=0,NOT(ISNUMBER(M595))),0,(1/M595)*(IF(AND(ISNUMBER(M597)),1+(1-M597),1+(1-M597))))","v":0},{"$f":"IF(AND(N595=0,NOT(ISNUMBER(N595))),0,(1/N595)*(IF(AND(ISNUMBER(N597)),1+(1-N597),1+(1-N597))))","v":0},{"$f":"IF(AND(O595=0,NOT(ISNUMBER(O595))),0,(1/O595)*(IF(AND(ISNUMBER(O597)),1+(1-O597),1+(1-O597))))","v":0},{"$f":"IF(AND(P595=0,NOT(ISNUMBER(P595))),0,(1/P595)*(IF(AND(ISNUMBER(P597)),1+(1-P597),1+(1-P597))))","v":0},{"$f":"IF(AND(Q595=0,NOT(ISNUMBER(Q595))),0,(1/Q595)*(IF(AND(ISNUMBER(Q597)),1+(1-Q597),1+(1-Q597))))","v":0}]
[null,null,null,null,"Direct Labor Wage Rate"]
[null,null,null,null,"Set Up Labor Wage Rate"]
[null,null,null,null,"No. of Direct Operators"]
[null,null,null,null,"Direct Labor Cost /Assembly",null,null,{"$f":"IF(AND(H598=\"\",H599=\"\"),0,H598*H599*IF(ISNUMBER(H601),H601,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":"(H603+H604+H605)*H598","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Sub-Total Cost",null,null,{"$f":"H602+H606","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Process Scrap %"]
[]
[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(H613=0,NOT(ISNUMBER(H611))),0,(H611/60)/IF(ISNUMBER(H613),H613,(H209))/IF(ISNUMBER(H617),H617,1)))*((H623*H612)+H626+H627+H628)","v":0},0,0,0,0,0,0,0,0,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(H618=0,NOT(ISNUMBER(H618))),0,(1/H618)*(IF(AND(ISNUMBER(H620)),1+(1-H620),1+(1-H620))))","v":0},{"$f":"IF(AND(I618=0,NOT(ISNUMBER(I618))),0,(1/I618)*(IF(AND(ISNUMBER(I620)),1+(1-I620),1+(1-I620))))","v":0},{"$f":"IF(AND(J618=0,NOT(ISNUMBER(J618))),0,(1/J618)*(IF(AND(ISNUMBER(J620)),1+(1-J620),1+(1-J620))))","v":0},{"$f":"IF(AND(K618=0,NOT(ISNUMBER(K618))),0,(1/K618)*(IF(AND(ISNUMBER(K620)),1+(1-K620),1+(1-K620))))","v":0},{"$f":"IF(AND(L618=0,NOT(ISNUMBER(L618))),0,(1/L618)*(IF(AND(ISNUMBER(L620)),1+(1-L620),1+(1-L620))))","v":0},{"$f":"IF(AND(M618=0,NOT(ISNUMBER(M618))),0,(1/M618)*(IF(AND(ISNUMBER(M620)),1+(1-M620),1+(1-M620))))","v":0},{"$f":"IF(AND(N618=0,NOT(ISNUMBER(N618))),0,(1/N618)*(IF(AND(ISNUMBER(N620)),1+(1-N620),1+(1-N620))))","v":0},{"$f":"IF(AND(O618=0,NOT(ISNUMBER(O618))),0,(1/O618)*(IF(AND(ISNUMBER(O620)),1+(1-O620),1+(1-O620))))","v":0},{"$f":"IF(AND(P618=0,NOT(ISNUMBER(P618))),0,(1/P618)*(IF(AND(ISNUMBER(P620)),1+(1-P620),1+(1-P620))))","v":0},{"$f":"IF(AND(Q618=0,NOT(ISNUMBER(Q618))),0,(1/Q618)*(IF(AND(ISNUMBER(Q620)),1+(1-Q620),1+(1-Q620))))","v":0}]
[null,null,null,null,"Direct Labor Wage Rate"]
[null,null,null,null,"Set Up Labor Wage Rate"]
[null,null,null,null,"No. of Direct Operators"]
[null,null,null,null,"Direct Labor Cost /Assembly",null,null,{"$f":"IF(AND(H621=\"\",H622=\"\"),0,H621*H622*IF(ISNUMBER(H624),H624,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":"(H626+H627+H628)*H621","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Sub-Total Cost",null,null,{"$f":"H625+H629","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Process Scrap %"]
[]
[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(H636=0,NOT(ISNUMBER(H634))),0,(H634/60)/IF(ISNUMBER(H636),H636,(H231))/IF(ISNUMBER(H640),H640,1)))*((H646*H635)+H649+H650+H651)","v":0},0,0,0,0,0,0,0,0,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(H641=0,NOT(ISNUMBER(H641))),0,(1/H641)*(IF(AND(ISNUMBER(H643)),1+(1-H643),1+(1-H643))))","v":0},{"$f":"IF(AND(I641=0,NOT(ISNUMBER(I641))),0,(1/I641)*(IF(AND(ISNUMBER(I643)),1+(1-I643),1+(1-I643))))","v":0},{"$f":"IF(AND(J641=0,NOT(ISNUMBER(J641))),0,(1/J641)*(IF(AND(ISNUMBER(J643)),1+(1-J643),1+(1-J643))))","v":0},{"$f":"IF(AND(K641=0,NOT(ISNUMBER(K641))),0,(1/K641)*(IF(AND(ISNUMBER(K643)),1+(1-K643),1+(1-K643))))","v":0},{"$f":"IF(AND(L641=0,NOT(ISNUMBER(L641))),0,(1/L641)*(IF(AND(ISNUMBER(L643)),1+(1-L643),1+(1-L643))))","v":0},{"$f":"IF(AND(M641=0,NOT(ISNUMBER(M641))),0,(1/M641)*(IF(AND(ISNUMBER(M643)),1+(1-M643),1+(1-M643))))","v":0},{"$f":"IF(AND(N641=0,NOT(ISNUMBER(N641))),0,(1/N641)*(IF(AND(ISNUMBER(N643)),1+(1-N643),1+(1-N643))))","v":0},{"$f":"IF(AND(O641=0,NOT(ISNUMBER(O641))),0,(1/O641)*(IF(AND(ISNUMBER(O643)),1+(1-O643),1+(1-O643))))","v":0},{"$f":"IF(AND(P641=0,NOT(ISNUMBER(P641))),0,(1/P641)*(IF(AND(ISNUMBER(P643)),1+(1-P643),1+(1-P643))))","v":0},{"$f":"IF(AND(Q641=0,NOT(ISNUMBER(Q641))),0,(1/Q641)*(IF(AND(ISNUMBER(Q643)),1+(1-Q643),1+(1-Q643))))","v":0}]
[null,null,null,null,"Direct Labor Wage Rate"]
[null,null,null,null,"Set Up Labor Wage Rate"]
[null,null,null,null,"No. of Direct Operators"]
[null,null,null,null,"Direct Labor Cost /Assembly",null,null,{"$f":"IF(AND(H644=\"\",H645=\"\"),0,H644*H645*IF(ISNUMBER(H647),H647,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":"(H649+H650+H651)*H644","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Sub-Total Cost",null,null,{"$f":"H648+H652","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Process Scrap %"]
[]
[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(H659=0,NOT(ISNUMBER(H657))),0,(H657/60)/IF(ISNUMBER(H659),H659,(H253))/IF(ISNUMBER(H663),H663,1)))*((H669*H658)+H672+H673+H674)","v":0},0,0,0,0,0,0,0,0,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(H664=0,NOT(ISNUMBER(H664))),0,(1/H664)*(IF(AND(ISNUMBER(H666)),1+(1-H666),1+(1-H666))))","v":0},{"$f":"IF(AND(I664=0,NOT(ISNUMBER(I664))),0,(1/I664)*(IF(AND(ISNUMBER(I666)),1+(1-I666),1+(1-I666))))","v":0},{"$f":"IF(AND(J664=0,NOT(ISNUMBER(J664))),0,(1/J664)*(IF(AND(ISNUMBER(J666)),1+(1-J666),1+(1-J666))))","v":0},{"$f":"IF(AND(K664=0,NOT(ISNUMBER(K664))),0,(1/K664)*(IF(AND(ISNUMBER(K666)),1+(1-K666),1+(1-K666))))","v":0},{"$f":"IF(AND(L664=0,NOT(ISNUMBER(L664))),0,(1/L664)*(IF(AND(ISNUMBER(L666)),1+(1-L666),1+(1-L666))))","v":0},{"$f":"IF(AND(M664=0,NOT(ISNUMBER(M664))),0,(1/M664)*(IF(AND(ISNUMBER(M666)),1+(1-M666),1+(1-M666))))","v":0},{"$f":"IF(AND(N664=0,NOT(ISNUMBER(N664))),0,(1/N664)*(IF(AND(ISNUMBER(N666)),1+(1-N666),1+(1-N666))))","v":0},{"$f":"IF(AND(O664=0,NOT(ISNUMBER(O664))),0,(1/O664)*(IF(AND(ISNUMBER(O666)),1+(1-O666),1+(1-O666))))","v":0},{"$f":"IF(AND(P664=0,NOT(ISNUMBER(P664))),0,(1/P664)*(IF(AND(ISNUMBER(P666)),1+(1-P666),1+(1-P666))))","v":0},{"$f":"IF(AND(Q664=0,NOT(ISNUMBER(Q664))),0,(1/Q664)*(IF(AND(ISNUMBER(Q666)),1+(1-Q666),1+(1-Q666))))","v":0}]
[null,null,null,null,"Direct Labor Wage Rate"]
[null,null,null,null,"Set Up Labor Wage Rate"]
[null,null,null,null,"No. of Direct Operators"]
[null,null,null,null,"Direct Labor Cost /Assembly",null,null,{"$f":"IF(AND(H667=\"\",H668=\"\"),0,H667*H668*IF(ISNUMBER(H670),H670,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":"(H672+H673+H674)*H667","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Sub-Total Cost",null,null,{"$f":"H671+H675","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Process Scrap %"]
[]
[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(H682=0,NOT(ISNUMBER(H680))),0,(H680/60)/IF(ISNUMBER(H682),H682,(H275))/IF(ISNUMBER(H686),H686,1)))*((H692*H681)+H695+H696+H697)","v":0},0,0,0,0,0,0,0,0,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(H687=0,NOT(ISNUMBER(H687))),0,(1/H687)*(IF(AND(ISNUMBER(H689)),1+(1-H689),1+(1-H689))))","v":0},{"$f":"IF(AND(I687=0,NOT(ISNUMBER(I687))),0,(1/I687)*(IF(AND(ISNUMBER(I689)),1+(1-I689),1+(1-I689))))","v":0},{"$f":"IF(AND(J687=0,NOT(ISNUMBER(J687))),0,(1/J687)*(IF(AND(ISNUMBER(J689)),1+(1-J689),1+(1-J689))))","v":0},{"$f":"IF(AND(K687=0,NOT(ISNUMBER(K687))),0,(1/K687)*(IF(AND(ISNUMBER(K689)),1+(1-K689),1+(1-K689))))","v":0},{"$f":"IF(AND(L687=0,NOT(ISNUMBER(L687))),0,(1/L687)*(IF(AND(ISNUMBER(L689)),1+(1-L689),1+(1-L689))))","v":0},{"$f":"IF(AND(M687=0,NOT(ISNUMBER(M687))),0,(1/M687)*(IF(AND(ISNUMBER(M689)),1+(1-M689),1+(1-M689))))","v":0},{"$f":"IF(AND(N687=0,NOT(ISNUMBER(N687))),0,(1/N687)*(IF(AND(ISNUMBER(N689)),1+(1-N689),1+(1-N689))))","v":0},{"$f":"IF(AND(O687=0,NOT(ISNUMBER(O687))),0,(1/O687)*(IF(AND(ISNUMBER(O689)),1+(1-O689),1+(1-O689))))","v":0},{"$f":"IF(AND(P687=0,NOT(ISNUMBER(P687))),0,(1/P687)*(IF(AND(ISNUMBER(P689)),1+(1-P689),1+(1-P689))))","v":0},{"$f":"IF(AND(Q687=0,NOT(ISNUMBER(Q687))),0,(1/Q687)*(IF(AND(ISNUMBER(Q689)),1+(1-Q689),1+(1-Q689))))","v":0}]
[null,null,null,null,"Direct Labor Wage Rate"]
[null,null,null,null,"Set Up Labor Wage Rate"]
[null,null,null,null,"No. of Direct Operators"]
[null,null,null,null,"Direct Labor Cost /Assembly",null,null,{"$f":"IF(AND(H690=\"\",H691=\"\"),0,H690*H691*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)*H690","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,"Process Scrap %"]
[]
[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(H705=0,NOT(ISNUMBER(H703))),0,(H703/60)/IF(ISNUMBER(H705),H705,(H297))/IF(ISNUMBER(H709),H709,1)))*((H715*H704)+H718+H719+H720)","v":0},0,0,0,0,0,0,0,0,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(H710=0,NOT(ISNUMBER(H710))),0,(1/H710)*(IF(AND(ISNUMBER(H712)),1+(1-H712),1+(1-H712))))","v":0},{"$f":"IF(AND(I710=0,NOT(ISNUMBER(I710))),0,(1/I710)*(IF(AND(ISNUMBER(I712)),1+(1-I712),1+(1-I712))))","v":0},{"$f":"IF(AND(J710=0,NOT(ISNUMBER(J710))),0,(1/J710)*(IF(AND(ISNUMBER(J712)),1+(1-J712),1+(1-J712))))","v":0},{"$f":"IF(AND(K710=0,NOT(ISNUMBER(K710))),0,(1/K710)*(IF(AND(ISNUMBER(K712)),1+(1-K712),1+(1-K712))))","v":0},{"$f":"IF(AND(L710=0,NOT(ISNUMBER(L710))),0,(1/L710)*(IF(AND(ISNUMBER(L712)),1+(1-L712),1+(1-L712))))","v":0},{"$f":"IF(AND(M710=0,NOT(ISNUMBER(M710))),0,(1/M710)*(IF(AND(ISNUMBER(M712)),1+(1-M712),1+(1-M712))))","v":0},{"$f":"IF(AND(N710=0,NOT(ISNUMBER(N710))),0,(1/N710)*(IF(AND(ISNUMBER(N712)),1+(1-N712),1+(1-N712))))","v":0},{"$f":"IF(AND(O710=0,NOT(ISNUMBER(O710))),0,(1/O710)*(IF(AND(ISNUMBER(O712)),1+(1-O712),1+(1-O712))))","v":0},{"$f":"IF(AND(P710=0,NOT(ISNUMBER(P710))),0,(1/P710)*(IF(AND(ISNUMBER(P712)),1+(1-P712),1+(1-P712))))","v":0},{"$f":"IF(AND(Q710=0,NOT(ISNUMBER(Q710))),0,(1/Q710)*(IF(AND(ISNUMBER(Q712)),1+(1-Q712),1+(1-Q712))))","v":0}]
[null,null,null,null,"Direct Labor Wage Rate"]
[null,null,null,null,"Set Up Labor Wage Rate"]
[null,null,null,null,"No. of Direct Operators"]
[null,null,null,null,"Direct Labor Cost /Assembly",null,null,{"$f":"IF(AND(H713=\"\",H714=\"\"),0,H713*H714*IF(ISNUMBER(H716),H716,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":"(H718+H719+H720)*H713","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Sub-Total Cost",null,null,{"$f":"H717+H721","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Process Scrap %"]
[]
[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(H728=0,NOT(ISNUMBER(H726))),0,(H726/60)/IF(ISNUMBER(H728),H728,(H319))/IF(ISNUMBER(H732),H732,1)))*((H738*H727)+H741+H742+H743)","v":0},0,0,0,0,0,0,0,0,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(H733=0,NOT(ISNUMBER(H733))),0,(1/H733)*(IF(AND(ISNUMBER(H735)),1+(1-H735),1+(1-H735))))","v":0},{"$f":"IF(AND(I733=0,NOT(ISNUMBER(I733))),0,(1/I733)*(IF(AND(ISNUMBER(I735)),1+(1-I735),1+(1-I735))))","v":0},{"$f":"IF(AND(J733=0,NOT(ISNUMBER(J733))),0,(1/J733)*(IF(AND(ISNUMBER(J735)),1+(1-J735),1+(1-J735))))","v":0},{"$f":"IF(AND(K733=0,NOT(ISNUMBER(K733))),0,(1/K733)*(IF(AND(ISNUMBER(K735)),1+(1-K735),1+(1-K735))))","v":0},{"$f":"IF(AND(L733=0,NOT(ISNUMBER(L733))),0,(1/L733)*(IF(AND(ISNUMBER(L735)),1+(1-L735),1+(1-L735))))","v":0},{"$f":"IF(AND(M733=0,NOT(ISNUMBER(M733))),0,(1/M733)*(IF(AND(ISNUMBER(M735)),1+(1-M735),1+(1-M735))))","v":0},{"$f":"IF(AND(N733=0,NOT(ISNUMBER(N733))),0,(1/N733)*(IF(AND(ISNUMBER(N735)),1+(1-N735),1+(1-N735))))","v":0},{"$f":"IF(AND(O733=0,NOT(ISNUMBER(O733))),0,(1/O733)*(IF(AND(ISNUMBER(O735)),1+(1-O735),1+(1-O735))))","v":0},{"$f":"IF(AND(P733=0,NOT(ISNUMBER(P733))),0,(1/P733)*(IF(AND(ISNUMBER(P735)),1+(1-P735),1+(1-P735))))","v":0},{"$f":"IF(AND(Q733=0,NOT(ISNUMBER(Q733))),0,(1/Q733)*(IF(AND(ISNUMBER(Q735)),1+(1-Q735),1+(1-Q735))))","v":0}]
[null,null,null,null,"Direct Labor Wage Rate"]
[null,null,null,null,"Set Up Labor Wage Rate"]
[null,null,null,null,"No. of Direct Operators"]
[null,null,null,null,"Direct Labor Cost /Assembly",null,null,{"$f":"IF(AND(H736=\"\",H737=\"\"),0,H736*H737*IF(ISNUMBER(H739),H739,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":"(H741+H742+H743)*H736","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Sub-Total Cost",null,null,{"$f":"H740+H744","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Process Scrap %"]
[]
[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(H751=0,NOT(ISNUMBER(H749))),0,(H749/60)/IF(ISNUMBER(H751),H751,(H341))/IF(ISNUMBER(H755),H755,1)))*((H761*H750)+H764+H765+H766)","v":0},0,0,0,0,0,0,0,0,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(H756=0,NOT(ISNUMBER(H756))),0,(1/H756)*(IF(AND(ISNUMBER(H758)),1+(1-H758),1+(1-H758))))","v":0},{"$f":"IF(AND(I756=0,NOT(ISNUMBER(I756))),0,(1/I756)*(IF(AND(ISNUMBER(I758)),1+(1-I758),1+(1-I758))))","v":0},{"$f":"IF(AND(J756=0,NOT(ISNUMBER(J756))),0,(1/J756)*(IF(AND(ISNUMBER(J758)),1+(1-J758),1+(1-J758))))","v":0},{"$f":"IF(AND(K756=0,NOT(ISNUMBER(K756))),0,(1/K756)*(IF(AND(ISNUMBER(K758)),1+(1-K758),1+(1-K758))))","v":0},{"$f":"IF(AND(L756=0,NOT(ISNUMBER(L756))),0,(1/L756)*(IF(AND(ISNUMBER(L758)),1+(1-L758),1+(1-L758))))","v":0},{"$f":"IF(AND(M756=0,NOT(ISNUMBER(M756))),0,(1/M756)*(IF(AND(ISNUMBER(M758)),1+(1-M758),1+(1-M758))))","v":0},{"$f":"IF(AND(N756=0,NOT(ISNUMBER(N756))),0,(1/N756)*(IF(AND(ISNUMBER(N758)),1+(1-N758),1+(1-N758))))","v":0},{"$f":"IF(AND(O756=0,NOT(ISNUMBER(O756))),0,(1/O756)*(IF(AND(ISNUMBER(O758)),1+(1-O758),1+(1-O758))))","v":0},{"$f":"IF(AND(P756=0,NOT(ISNUMBER(P756))),0,(1/P756)*(IF(AND(ISNUMBER(P758)),1+(1-P758),1+(1-P758))))","v":0},{"$f":"IF(AND(Q756=0,NOT(ISNUMBER(Q756))),0,(1/Q756)*(IF(AND(ISNUMBER(Q758)),1+(1-Q758),1+(1-Q758))))","v":0}]
[null,null,null,null,"Direct Labor Wage Rate"]
[null,null,null,null,"Set Up Labor Wage Rate"]
[null,null,null,null,"No. of Direct Operators"]
[null,null,null,null,"Direct Labor Cost /Assembly",null,null,{"$f":"IF(AND(H759=\"\",H760=\"\"),0,H759*H760*IF(ISNUMBER(H762),H762,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":"(H764+H765+H766)*H759","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Sub-Total Cost",null,null,{"$f":"H763+H767","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Process Scrap %"]
[]
[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(H774=0,NOT(ISNUMBER(H772))),0,(H772/60)/IF(ISNUMBER(H774),H774,(H363))/IF(ISNUMBER(H778),H778,1)))*((H784*H773)+H787+H788+H789)","v":0},0,0,0,0,0,0,0,0,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(H779=0,NOT(ISNUMBER(H779))),0,(1/H779)*(IF(AND(ISNUMBER(H781)),1+(1-H781),1+(1-H781))))","v":0},{"$f":"IF(AND(I779=0,NOT(ISNUMBER(I779))),0,(1/I779)*(IF(AND(ISNUMBER(I781)),1+(1-I781),1+(1-I781))))","v":0},{"$f":"IF(AND(J779=0,NOT(ISNUMBER(J779))),0,(1/J779)*(IF(AND(ISNUMBER(J781)),1+(1-J781),1+(1-J781))))","v":0},{"$f":"IF(AND(K779=0,NOT(ISNUMBER(K779))),0,(1/K779)*(IF(AND(ISNUMBER(K781)),1+(1-K781),1+(1-K781))))","v":0},{"$f":"IF(AND(L779=0,NOT(ISNUMBER(L779))),0,(1/L779)*(IF(AND(ISNUMBER(L781)),1+(1-L781),1+(1-L781))))","v":0},{"$f":"IF(AND(M779=0,NOT(ISNUMBER(M779))),0,(1/M779)*(IF(AND(ISNUMBER(M781)),1+(1-M781),1+(1-M781))))","v":0},{"$f":"IF(AND(N779=0,NOT(ISNUMBER(N779))),0,(1/N779)*(IF(AND(ISNUMBER(N781)),1+(1-N781),1+(1-N781))))","v":0},{"$f":"IF(AND(O779=0,NOT(ISNUMBER(O779))),0,(1/O779)*(IF(AND(ISNUMBER(O781)),1+(1-O781),1+(1-O781))))","v":0},{"$f":"IF(AND(P779=0,NOT(ISNUMBER(P779))),0,(1/P779)*(IF(AND(ISNUMBER(P781)),1+(1-P781),1+(1-P781))))","v":0},{"$f":"IF(AND(Q779=0,NOT(ISNUMBER(Q779))),0,(1/Q779)*(IF(AND(ISNUMBER(Q781)),1+(1-Q781),1+(1-Q781))))","v":0}]
[null,null,null,null,"Direct Labor Wage Rate"]
[null,null,null,null,"Set Up Labor Wage Rate"]
[null,null,null,null,"No. of Direct Operators"]
[null,null,null,null,"Direct Labor Cost /Assembly",null,null,{"$f":"IF(AND(H782=\"\",H783=\"\"),0,H782*H783*IF(ISNUMBER(H785),H785,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":"(H787+H788+H789)*H782","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Sub-Total Cost",null,null,{"$f":"H786+H790","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Process Scrap %"]
[]
[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(H797=0,NOT(ISNUMBER(H795))),0,(H795/60)/IF(ISNUMBER(H797),H797,(H385))/IF(ISNUMBER(H801),H801,1)))*((H807*H796)+H810+H811+H812)","v":0},0,0,0,0,0,0,0,0,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(H802=0,NOT(ISNUMBER(H802))),0,(1/H802)*(IF(AND(ISNUMBER(H804)),1+(1-H804),1+(1-H804))))","v":0},{"$f":"IF(AND(I802=0,NOT(ISNUMBER(I802))),0,(1/I802)*(IF(AND(ISNUMBER(I804)),1+(1-I804),1+(1-I804))))","v":0},{"$f":"IF(AND(J802=0,NOT(ISNUMBER(J802))),0,(1/J802)*(IF(AND(ISNUMBER(J804)),1+(1-J804),1+(1-J804))))","v":0},{"$f":"IF(AND(K802=0,NOT(ISNUMBER(K802))),0,(1/K802)*(IF(AND(ISNUMBER(K804)),1+(1-K804),1+(1-K804))))","v":0},{"$f":"IF(AND(L802=0,NOT(ISNUMBER(L802))),0,(1/L802)*(IF(AND(ISNUMBER(L804)),1+(1-L804),1+(1-L804))))","v":0},{"$f":"IF(AND(M802=0,NOT(ISNUMBER(M802))),0,(1/M802)*(IF(AND(ISNUMBER(M804)),1+(1-M804),1+(1-M804))))","v":0},{"$f":"IF(AND(N802=0,NOT(ISNUMBER(N802))),0,(1/N802)*(IF(AND(ISNUMBER(N804)),1+(1-N804),1+(1-N804))))","v":0},{"$f":"IF(AND(O802=0,NOT(ISNUMBER(O802))),0,(1/O802)*(IF(AND(ISNUMBER(O804)),1+(1-O804),1+(1-O804))))","v":0},{"$f":"IF(AND(P802=0,NOT(ISNUMBER(P802))),0,(1/P802)*(IF(AND(ISNUMBER(P804)),1+(1-P804),1+(1-P804))))","v":0},{"$f":"IF(AND(Q802=0,NOT(ISNUMBER(Q802))),0,(1/Q802)*(IF(AND(ISNUMBER(Q804)),1+(1-Q804),1+(1-Q804))))","v":0}]
[null,null,null,null,"Direct Labor Wage Rate"]
[null,null,null,null,"Set Up Labor Wage Rate"]
[null,null,null,null,"No. of Direct Operators"]
[null,null,null,null,"Direct Labor Cost /Assembly",null,null,{"$f":"IF(AND(H805=\"\",H806=\"\"),0,H805*H806*IF(ISNUMBER(H808),H808,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":"(H810+H811+H812)*H805","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Sub-Total Cost",null,null,{"$f":"H809+H813","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Process Scrap %"]
[]
[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(H820=0,NOT(ISNUMBER(H818))),0,(H818/60)/IF(ISNUMBER(H820),H820,(H407))/IF(ISNUMBER(H824),H824,1)))*((H830*H819)+H833+H834+H835)","v":0},0,0,0,0,0,0,0,0,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(H825=0,NOT(ISNUMBER(H825))),0,(1/H825)*(IF(AND(ISNUMBER(H827)),1+(1-H827),1+(1-H827))))","v":0},{"$f":"IF(AND(I825=0,NOT(ISNUMBER(I825))),0,(1/I825)*(IF(AND(ISNUMBER(I827)),1+(1-I827),1+(1-I827))))","v":0},{"$f":"IF(AND(J825=0,NOT(ISNUMBER(J825))),0,(1/J825)*(IF(AND(ISNUMBER(J827)),1+(1-J827),1+(1-J827))))","v":0},{"$f":"IF(AND(K825=0,NOT(ISNUMBER(K825))),0,(1/K825)*(IF(AND(ISNUMBER(K827)),1+(1-K827),1+(1-K827))))","v":0},{"$f":"IF(AND(L825=0,NOT(ISNUMBER(L825))),0,(1/L825)*(IF(AND(ISNUMBER(L827)),1+(1-L827),1+(1-L827))))","v":0},{"$f":"IF(AND(M825=0,NOT(ISNUMBER(M825))),0,(1/M825)*(IF(AND(ISNUMBER(M827)),1+(1-M827),1+(1-M827))))","v":0},{"$f":"IF(AND(N825=0,NOT(ISNUMBER(N825))),0,(1/N825)*(IF(AND(ISNUMBER(N827)),1+(1-N827),1+(1-N827))))","v":0},{"$f":"IF(AND(O825=0,NOT(ISNUMBER(O825))),0,(1/O825)*(IF(AND(ISNUMBER(O827)),1+(1-O827),1+(1-O827))))","v":0},{"$f":"IF(AND(P825=0,NOT(ISNUMBER(P825))),0,(1/P825)*(IF(AND(ISNUMBER(P827)),1+(1-P827),1+(1-P827))))","v":0},{"$f":"IF(AND(Q825=0,NOT(ISNUMBER(Q825))),0,(1/Q825)*(IF(AND(ISNUMBER(Q827)),1+(1-Q827),1+(1-Q827))))","v":0}]
[null,null,null,null,"Direct Labor Wage Rate"]
[null,null,null,null,"Set Up Labor Wage Rate"]
[null,null,null,null,"No. of Direct Operators"]
[null,null,null,null,"Direct Labor Cost /Assembly",null,null,{"$f":"IF(AND(H828=\"\",H829=\"\"),0,H828*H829*IF(ISNUMBER(H831),H831,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":"(H833+H834+H835)*H828","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Sub-Total Cost",null,null,{"$f":"H832+H836","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Process Scrap %"]
[]
[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(H843=0,NOT(ISNUMBER(H841))),0,(H841/60)/IF(ISNUMBER(H843),H843,(H429))/IF(ISNUMBER(H847),H847,1)))*((H853*H842)+H856+H857+H858)","v":0},0,0,0,0,0,0,0,0,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(H848=0,NOT(ISNUMBER(H848))),0,(1/H848)*(IF(AND(ISNUMBER(H850)),1+(1-H850),1+(1-H850))))","v":0},{"$f":"IF(AND(I848=0,NOT(ISNUMBER(I848))),0,(1/I848)*(IF(AND(ISNUMBER(I850)),1+(1-I850),1+(1-I850))))","v":0},{"$f":"IF(AND(J848=0,NOT(ISNUMBER(J848))),0,(1/J848)*(IF(AND(ISNUMBER(J850)),1+(1-J850),1+(1-J850))))","v":0},{"$f":"IF(AND(K848=0,NOT(ISNUMBER(K848))),0,(1/K848)*(IF(AND(ISNUMBER(K850)),1+(1-K850),1+(1-K850))))","v":0},{"$f":"IF(AND(L848=0,NOT(ISNUMBER(L848))),0,(1/L848)*(IF(AND(ISNUMBER(L850)),1+(1-L850),1+(1-L850))))","v":0},{"$f":"IF(AND(M848=0,NOT(ISNUMBER(M848))),0,(1/M848)*(IF(AND(ISNUMBER(M850)),1+(1-M850),1+(1-M850))))","v":0},{"$f":"IF(AND(N848=0,NOT(ISNUMBER(N848))),0,(1/N848)*(IF(AND(ISNUMBER(N850)),1+(1-N850),1+(1-N850))))","v":0},{"$f":"IF(AND(O848=0,NOT(ISNUMBER(O848))),0,(1/O848)*(IF(AND(ISNUMBER(O850)),1+(1-O850),1+(1-O850))))","v":0},{"$f":"IF(AND(P848=0,NOT(ISNUMBER(P848))),0,(1/P848)*(IF(AND(ISNUMBER(P850)),1+(1-P850),1+(1-P850))))","v":0},{"$f":"IF(AND(Q848=0,NOT(ISNUMBER(Q848))),0,(1/Q848)*(IF(AND(ISNUMBER(Q850)),1+(1-Q850),1+(1-Q850))))","v":0}]
[null,null,null,null,"Direct Labor Wage Rate"]
[null,null,null,null,"Set Up Labor Wage Rate"]
[null,null,null,null,"No. of Direct Operators"]
[null,null,null,null,"Direct Labor Cost /Assembly",null,null,{"$f":"IF(AND(H851=\"\",H852=\"\"),0,H851*H852*IF(ISNUMBER(H854),H854,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":"(H856+H857+H858)*H851","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Sub-Total Cost",null,null,{"$f":"H855+H859","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Process Scrap %"]
[]
[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(H866=0,NOT(ISNUMBER(H864))),0,(H864/60)/IF(ISNUMBER(H866),H866,(H451))/IF(ISNUMBER(H870),H870,1)))*((H876*H865)+H879+H880+H881)","v":0},0,0,0,0,0,0,0,0,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(H871=0,NOT(ISNUMBER(H871))),0,(1/H871)*(IF(AND(ISNUMBER(H873)),1+(1-H873),1+(1-H873))))","v":0},{"$f":"IF(AND(I871=0,NOT(ISNUMBER(I871))),0,(1/I871)*(IF(AND(ISNUMBER(I873)),1+(1-I873),1+(1-I873))))","v":0},{"$f":"IF(AND(J871=0,NOT(ISNUMBER(J871))),0,(1/J871)*(IF(AND(ISNUMBER(J873)),1+(1-J873),1+(1-J873))))","v":0},{"$f":"IF(AND(K871=0,NOT(ISNUMBER(K871))),0,(1/K871)*(IF(AND(ISNUMBER(K873)),1+(1-K873),1+(1-K873))))","v":0},{"$f":"IF(AND(L871=0,NOT(ISNUMBER(L871))),0,(1/L871)*(IF(AND(ISNUMBER(L873)),1+(1-L873),1+(1-L873))))","v":0},{"$f":"IF(AND(M871=0,NOT(ISNUMBER(M871))),0,(1/M871)*(IF(AND(ISNUMBER(M873)),1+(1-M873),1+(1-M873))))","v":0},{"$f":"IF(AND(N871=0,NOT(ISNUMBER(N871))),0,(1/N871)*(IF(AND(ISNUMBER(N873)),1+(1-N873),1+(1-N873))))","v":0},{"$f":"IF(AND(O871=0,NOT(ISNUMBER(O871))),0,(1/O871)*(IF(AND(ISNUMBER(O873)),1+(1-O873),1+(1-O873))))","v":0},{"$f":"IF(AND(P871=0,NOT(ISNUMBER(P871))),0,(1/P871)*(IF(AND(ISNUMBER(P873)),1+(1-P873),1+(1-P873))))","v":0},{"$f":"IF(AND(Q871=0,NOT(ISNUMBER(Q871))),0,(1/Q871)*(IF(AND(ISNUMBER(Q873)),1+(1-Q873),1+(1-Q873))))","v":0}]
[null,null,null,null,"Direct Labor Wage Rate"]
[null,null,null,null,"Set Up Labor Wage Rate"]
[null,null,null,null,"No. of Direct Operators"]
[null,null,null,null,"Direct Labor Cost /Assembly",null,null,{"$f":"IF(AND(H874=\"\",H875=\"\"),0,H874*H875*IF(ISNUMBER(H877),H877,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":"(H879+H880+H881)*H874","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Sub-Total Cost",null,null,{"$f":"H878+H882","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Process Scrap %"]
[]
[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(H889=0,NOT(ISNUMBER(H887))),0,(H887/60)/IF(ISNUMBER(H889),H889,(H473))/IF(ISNUMBER(H893),H893,1)))*((H899*H888)+H902+H903+H904)","v":0},0,0,0,0,0,0,0,0,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(H894=0,NOT(ISNUMBER(H894))),0,(1/H894)*(IF(AND(ISNUMBER(H896)),1+(1-H896),1+(1-H896))))","v":0},{"$f":"IF(AND(I894=0,NOT(ISNUMBER(I894))),0,(1/I894)*(IF(AND(ISNUMBER(I896)),1+(1-I896),1+(1-I896))))","v":0},{"$f":"IF(AND(J894=0,NOT(ISNUMBER(J894))),0,(1/J894)*(IF(AND(ISNUMBER(J896)),1+(1-J896),1+(1-J896))))","v":0},{"$f":"IF(AND(K894=0,NOT(ISNUMBER(K894))),0,(1/K894)*(IF(AND(ISNUMBER(K896)),1+(1-K896),1+(1-K896))))","v":0},{"$f":"IF(AND(L894=0,NOT(ISNUMBER(L894))),0,(1/L894)*(IF(AND(ISNUMBER(L896)),1+(1-L896),1+(1-L896))))","v":0},{"$f":"IF(AND(M894=0,NOT(ISNUMBER(M894))),0,(1/M894)*(IF(AND(ISNUMBER(M896)),1+(1-M896),1+(1-M896))))","v":0},{"$f":"IF(AND(N894=0,NOT(ISNUMBER(N894))),0,(1/N894)*(IF(AND(ISNUMBER(N896)),1+(1-N896),1+(1-N896))))","v":0},{"$f":"IF(AND(O894=0,NOT(ISNUMBER(O894))),0,(1/O894)*(IF(AND(ISNUMBER(O896)),1+(1-O896),1+(1-O896))))","v":0},{"$f":"IF(AND(P894=0,NOT(ISNUMBER(P894))),0,(1/P894)*(IF(AND(ISNUMBER(P896)),1+(1-P896),1+(1-P896))))","v":0},{"$f":"IF(AND(Q894=0,NOT(ISNUMBER(Q894))),0,(1/Q894)*(IF(AND(ISNUMBER(Q896)),1+(1-Q896),1+(1-Q896))))","v":0}]
[null,null,null,null,"Direct Labor Wage Rate"]
[null,null,null,null,"Set Up Labor Wage Rate"]
[null,null,null,null,"No. of Direct Operators"]
[null,null,null,null,"Direct Labor Cost /Assembly",null,null,{"$f":"IF(AND(H897=\"\",H898=\"\"),0,H897*H898*IF(ISNUMBER(H900),H900,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":"(H902+H903+H904)*H897","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Sub-Total Cost",null,null,{"$f":"H901+H905","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"Process Scrap %"]
[null,null,null,null,null,null,null,{"$f":"H907*H906+H884*H883+H861*H860+H838*H837+H815*H814+H792*H791+H769*H768+H746*H745+H723*H722+H700*H699+H677*H676+H654*H653+H631*H630+H608*H607+H585*H584+H562*H561+H539*H538+H516*H515+H493*H492+H470*H469","v":0},0,0,0,0,0,0,0,0,0]
[]
[]
[null,null,null,null,"TOTAL Direct Labor Cost",null,null,{"$f":"H464+H487+H510+H533+H556+H579+H602+H625+H648+H671+H694+H717+H740+H763+H786+H809+H832+H855+H878+H901","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"TOTAL Burden Cost",null,null,{"$f":"H468+H491+H514+H537+H560+H583+H606+H629+H652+H675+H698+H721+H744+H767+H790+H813+H836+H859+H882+H905","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,"TOTAL Set Up Cost",null,null,{"$f":"H453+H476+H499+H522+H545+H568+H591+H614+H637+H660+H683+H706+H729+H752+H775+H798+H821+H844+H867+H890","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,"TOTAL Manufacturing Cost",null,null,{"$f":"H911+H912+H913+H444+H189","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,{"$f":"(H911+H912+H913)*H949","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"E) Packaging, Logistics, Amortization, Duties & Customs",null,null,null,{"$f":"H931","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(H927/H928),NOT(ISNUMBER(H927))),0,H927/H928)","v":0},{"$f":"IF(OR(ISERROR(I927/I928),NOT(ISNUMBER(I927))),0,I927/I928)","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},{"$f":"IF(ISNUMBER(I189),I189,0)","v":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},{"$f":"IF(ISNUMBER(I444),I444,0)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Direct Labor Cost",null,null,null,{"$f":"H911","v":0},{"$f":"I911","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Burden Cost",null,null,null,{"$f":"H912","v":0},{"$f":"I912","v":0},0,0,0,0,0,0,0,0]
[null,null,null,"Set Up Cost",null,null,null,{"$f":"H913","v":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(H933:H937)),0,SUM(H933:H937))","v":0},{"$f":"IF(ISERROR(SUM(I933:I937)),0,SUM(I933:I937))","v":0},{"$f":"IF(ISERROR(SUM(J933:J937)),0,SUM(J933:J937))","v":0},{"$f":"IF(ISERROR(SUM(K933:K937)),0,SUM(K933:K937))","v":0},{"$f":"IF(ISERROR(SUM(L933:L937)),0,SUM(L933:L937))","v":0},0,0,0,0,0]
[]
[null,null,null,"SG&A","SG&A %"]
[null,null,null,null,"SG&A Cost",null,null,{"$f":"H940*H938","v":0},{"$f":"I940*I938","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,null,"PROFIT ","PROFIT on Material % "]
[null,null,null,null,"PROFIT on Purchased Components % "]
[null,null,null,null,"PROFIT on Value Add % "]
["Add in",null,null,null,"Total Profit %","Total Profit %",null,{"$f":"IF(ISERROR(H947/H938),\"\",(H947/H938))","v":""},"","","","","","","","",""]
[null,null,null,null,"TOTAL PROFIT COST",null,null,{"$f":"H943*H933+H944*H934+H945*(H935+H936+H937)","v":0},0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"Material/PC Scrap %"]
[null,null,null,"Material 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)*((H189*H949+H444*H949+H908)/H938)),0,(H61*H64+H74*H77+H87*H90+H100*H103+H113*H116+H126*H129+H139*H142+H152*H155+H165*H168+H178*H181)*((H189*H949+H444*H949+H908)/H938))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"Process Scrap Cost",null,null,null,{"$f":"IF(ISERROR((H915*((H189*H949+H444*H949+H908)/H938))-H950),0,(H915*((H189*H949+H444*H949+H908)/H938))-H950)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"Packaging Cost",null,null,null,{"$f":"IF(ISERROR(H919),0,H919)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,"Freight + Warehousing Cost",null,null,null,{"$f":"IF(ISERROR(SUM(H920:H922)+H924),0,SUM(H920:H922)+H924)","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(H925),0,H925+IF(ISERROR(H929),0,(H929)))","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(H938+H941+H947+SUM(H951:H954)),0,H938+H941+H947+SUM(H951:H954))","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$999=0,$G$999=\"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":"H911","v":0},0,0,0,0,0,0,0,0,0,null,"Delivered Duty Unpaid"]
[null,null,null,5,null,null,"Burden Cost ",{"$f":"H912","v":0},0,0,0,0,0,0,0,0,0,null,"Ex Works"]
[null,null,null,6,null,null,"Set Up Cost ",{"$f":"H913","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":"H919","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":"H925","v":0},0,0,0,0,0,0,0,0,0,null,"Cost & Freight"]
[null,null,null,9,null,null,"Amortization Cost ",{"$f":"H929","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":"H941+H947","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":"H951","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(H955/H1012),0,(H955/H1012))","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,H1002,(IF(AND(ISNUMBER(H11),ISNUMBER(H1002)),(H1002/H11),IF(ISNUMBER(H11),(H1002/H11),H1002))))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,3,null,null,"Purchased Components Cost",{"$f":"IF(H9=H10,H1003,(IF(AND(ISNUMBER(H11),ISNUMBER(H1003)),(H1003/H11),IF(ISNUMBER(H11),(H1003/H11),H1003))))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,4,null,null,"Direct Labor Cost ",{"$f":"IF(H9=H10,H1004,(IF(AND(ISNUMBER(H11),ISNUMBER(H1004)),(H1004/H11),IF(ISNUMBER(H11),(H1004/H11),H1004))))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,5,null,null,"Burden Cost ",{"$f":"IF(H9=H10,H1005,(IF(AND(ISNUMBER(H11),ISNUMBER(H1005)),(H1005/H11),IF(ISNUMBER(H11),(H1005/H11),H1005))))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,6,null,null,"Set Up Cost ",{"$f":"IF(H9=H10,H1006,(IF(AND(ISNUMBER(H11),ISNUMBER(H1006)),(H1006/H11),IF(ISNUMBER(H11),(H1006/H11),H1006))))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,7,null,null,"Packaging & Freight Cost",{"$f":"IF(H9=H10,H1007,(IF(AND(ISNUMBER(H11),ISNUMBER(H1007)),(H1007/H11),IF(ISNUMBER(H11),(H1007/H11),H1007))))","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,H1008,(IF(AND(ISNUMBER(H11),ISNUMBER(H1008)),(H1008/H11),IF(ISNUMBER(H11),(H1008/H11),H1008))))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,9,null,null,"Amortization Cost ",{"$f":"IF(H9=H10,H1009,(IF(AND(ISNUMBER(H11),ISNUMBER(H1009)),(H1009/H11),IF(ISNUMBER(H11),(H1009/H11),H1009))))","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,H1010,(IF(AND(ISNUMBER(H11),ISNUMBER(H1010)),(H1010/H11),IF(ISNUMBER(H11),(H1010/H11),H1010))))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,11,null,null," Process Scrap Cost",{"$f":"IF(H9=H10,H1011,(IF(AND(ISNUMBER(H11),ISNUMBER(H1011)),(H1011/H11),IF(ISNUMBER(H11),(H1011/H11),H1011))))","v":0},0,0,0,0,0,0,0,0,0]
[null,null,null,12,null,null,"Total Net Wt",{"$f":"H1012","v":0},{"$f":"I1012","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,H1014,(IF(AND(ISNUMBER(H11),ISNUMBER(H1014)),(H1014/H11),IF(ISNUMBER(H11),(H1014/H11),H1014))))","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(H1069:H1078)","v":0},{"$f":"SUM(I1069:I1078)","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(H1088:H1097)","v":0},{"$f":"SUM(I1088:I1097)","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(H470*#REF!),0,(H470*#REF!))","v":0},{"$f":"IF(ISERROR(I470*#REF!),0,(I470*#REF!))","v":0},{"$f":"IF(ISERROR(J470*#REF!),0,(J470*#REF!))","v":0},{"$f":"IF(ISERROR(K470*#REF!),0,(K470*#REF!))","v":0},{"$f":"IF(ISERROR(L470*#REF!),0,(L470*#REF!))","v":0},{"$f":"IF(ISERROR(M470*#REF!),0,(M470*#REF!))","v":0},{"$f":"IF(ISERROR(N470*#REF!),0,(N470*#REF!))","v":0},{"$f":"IF(ISERROR(O470*#REF!),0,(O470*#REF!))","v":0},{"$f":"IF(ISERROR(P470*#REF!),0,(P470*#REF!))","v":0},{"$f":"IF(ISERROR(Q470*#REF!),0,(Q470*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H492*#REF!),0,(H492*#REF!))","v":0},{"$f":"IF(ISERROR(I492*#REF!),0,(I492*#REF!))","v":0},{"$f":"IF(ISERROR(J492*#REF!),0,(J492*#REF!))","v":0},{"$f":"IF(ISERROR(K492*#REF!),0,(K492*#REF!))","v":0},{"$f":"IF(ISERROR(L492*#REF!),0,(L492*#REF!))","v":0},{"$f":"IF(ISERROR(M492*#REF!),0,(M492*#REF!))","v":0},{"$f":"IF(ISERROR(N492*#REF!),0,(N492*#REF!))","v":0},{"$f":"IF(ISERROR(O492*#REF!),0,(O492*#REF!))","v":0},{"$f":"IF(ISERROR(P492*#REF!),0,(P492*#REF!))","v":0},{"$f":"IF(ISERROR(Q492*#REF!),0,(Q492*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H515*#REF!),0,(H515*#REF!))","v":0},{"$f":"IF(ISERROR(I515*#REF!),0,(I515*#REF!))","v":0},{"$f":"IF(ISERROR(J515*#REF!),0,(J515*#REF!))","v":0},{"$f":"IF(ISERROR(K515*#REF!),0,(K515*#REF!))","v":0},{"$f":"IF(ISERROR(L515*#REF!),0,(L515*#REF!))","v":0},{"$f":"IF(ISERROR(M515*#REF!),0,(M515*#REF!))","v":0},{"$f":"IF(ISERROR(N515*#REF!),0,(N515*#REF!))","v":0},{"$f":"IF(ISERROR(O515*#REF!),0,(O515*#REF!))","v":0},{"$f":"IF(ISERROR(P515*#REF!),0,(P515*#REF!))","v":0},{"$f":"IF(ISERROR(Q515*#REF!),0,(Q515*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H538*#REF!),0,(H538*#REF!))","v":0},{"$f":"IF(ISERROR(I538*#REF!),0,(I538*#REF!))","v":0},{"$f":"IF(ISERROR(J538*#REF!),0,(J538*#REF!))","v":0},{"$f":"IF(ISERROR(K538*#REF!),0,(K538*#REF!))","v":0},{"$f":"IF(ISERROR(L538*#REF!),0,(L538*#REF!))","v":0},{"$f":"IF(ISERROR(M538*#REF!),0,(M538*#REF!))","v":0},{"$f":"IF(ISERROR(N538*#REF!),0,(N538*#REF!))","v":0},{"$f":"IF(ISERROR(O538*#REF!),0,(O538*#REF!))","v":0},{"$f":"IF(ISERROR(P538*#REF!),0,(P538*#REF!))","v":0},{"$f":"IF(ISERROR(Q538*#REF!),0,(Q538*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H561*#REF!),0,(H561*#REF!))","v":0},{"$f":"IF(ISERROR(I561*#REF!),0,(I561*#REF!))","v":0},{"$f":"IF(ISERROR(J561*#REF!),0,(J561*#REF!))","v":0},{"$f":"IF(ISERROR(K561*#REF!),0,(K561*#REF!))","v":0},{"$f":"IF(ISERROR(L561*#REF!),0,(L561*#REF!))","v":0},{"$f":"IF(ISERROR(M561*#REF!),0,(M561*#REF!))","v":0},{"$f":"IF(ISERROR(N561*#REF!),0,(N561*#REF!))","v":0},{"$f":"IF(ISERROR(O561*#REF!),0,(O561*#REF!))","v":0},{"$f":"IF(ISERROR(P561*#REF!),0,(P561*#REF!))","v":0},{"$f":"IF(ISERROR(Q561*#REF!),0,(Q561*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H584*#REF!),0,(H584*#REF!))","v":0},{"$f":"IF(ISERROR(I584*#REF!),0,(I584*#REF!))","v":0},{"$f":"IF(ISERROR(J584*#REF!),0,(J584*#REF!))","v":0},{"$f":"IF(ISERROR(K584*#REF!),0,(K584*#REF!))","v":0},{"$f":"IF(ISERROR(L584*#REF!),0,(L584*#REF!))","v":0},{"$f":"IF(ISERROR(M584*#REF!),0,(M584*#REF!))","v":0},{"$f":"IF(ISERROR(N584*#REF!),0,(N584*#REF!))","v":0},{"$f":"IF(ISERROR(O584*#REF!),0,(O584*#REF!))","v":0},{"$f":"IF(ISERROR(P584*#REF!),0,(P584*#REF!))","v":0},{"$f":"IF(ISERROR(Q584*#REF!),0,(Q584*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H607*#REF!),0,(H607*#REF!))","v":0},{"$f":"IF(ISERROR(I607*#REF!),0,(I607*#REF!))","v":0},{"$f":"IF(ISERROR(J607*#REF!),0,(J607*#REF!))","v":0},{"$f":"IF(ISERROR(K607*#REF!),0,(K607*#REF!))","v":0},{"$f":"IF(ISERROR(L607*#REF!),0,(L607*#REF!))","v":0},{"$f":"IF(ISERROR(M607*#REF!),0,(M607*#REF!))","v":0},{"$f":"IF(ISERROR(N607*#REF!),0,(N607*#REF!))","v":0},{"$f":"IF(ISERROR(O607*#REF!),0,(O607*#REF!))","v":0},{"$f":"IF(ISERROR(P607*#REF!),0,(P607*#REF!))","v":0},{"$f":"IF(ISERROR(Q607*#REF!),0,(Q607*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H630*#REF!),0,(H630*#REF!))","v":0},{"$f":"IF(ISERROR(I630*#REF!),0,(I630*#REF!))","v":0},{"$f":"IF(ISERROR(J630*#REF!),0,(J630*#REF!))","v":0},{"$f":"IF(ISERROR(K630*#REF!),0,(K630*#REF!))","v":0},{"$f":"IF(ISERROR(L630*#REF!),0,(L630*#REF!))","v":0},{"$f":"IF(ISERROR(M630*#REF!),0,(M630*#REF!))","v":0},{"$f":"IF(ISERROR(N630*#REF!),0,(N630*#REF!))","v":0},{"$f":"IF(ISERROR(O630*#REF!),0,(O630*#REF!))","v":0},{"$f":"IF(ISERROR(P630*#REF!),0,(P630*#REF!))","v":0},{"$f":"IF(ISERROR(Q630*#REF!),0,(Q630*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H653*#REF!),0,(H653*#REF!))","v":0},{"$f":"IF(ISERROR(I653*#REF!),0,(I653*#REF!))","v":0},{"$f":"IF(ISERROR(J653*#REF!),0,(J653*#REF!))","v":0},{"$f":"IF(ISERROR(K653*#REF!),0,(K653*#REF!))","v":0},{"$f":"IF(ISERROR(L653*#REF!),0,(L653*#REF!))","v":0},{"$f":"IF(ISERROR(M653*#REF!),0,(M653*#REF!))","v":0},{"$f":"IF(ISERROR(N653*#REF!),0,(N653*#REF!))","v":0},{"$f":"IF(ISERROR(O653*#REF!),0,(O653*#REF!))","v":0},{"$f":"IF(ISERROR(P653*#REF!),0,(P653*#REF!))","v":0},{"$f":"IF(ISERROR(Q653*#REF!),0,(Q653*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H676*#REF!),0,(H676*#REF!))","v":0},{"$f":"IF(ISERROR(I676*#REF!),0,(I676*#REF!))","v":0},{"$f":"IF(ISERROR(J676*#REF!),0,(J676*#REF!))","v":0},{"$f":"IF(ISERROR(K676*#REF!),0,(K676*#REF!))","v":0},{"$f":"IF(ISERROR(L676*#REF!),0,(L676*#REF!))","v":0},{"$f":"IF(ISERROR(M676*#REF!),0,(M676*#REF!))","v":0},{"$f":"IF(ISERROR(N676*#REF!),0,(N676*#REF!))","v":0},{"$f":"IF(ISERROR(O676*#REF!),0,(O676*#REF!))","v":0},{"$f":"IF(ISERROR(P676*#REF!),0,(P676*#REF!))","v":0},{"$f":"IF(ISERROR(Q676*#REF!),0,(Q676*#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(H722*#REF!),0,(H722*#REF!))","v":0},{"$f":"IF(ISERROR(I722*#REF!),0,(I722*#REF!))","v":0},{"$f":"IF(ISERROR(J722*#REF!),0,(J722*#REF!))","v":0},{"$f":"IF(ISERROR(K722*#REF!),0,(K722*#REF!))","v":0},{"$f":"IF(ISERROR(L722*#REF!),0,(L722*#REF!))","v":0},{"$f":"IF(ISERROR(M722*#REF!),0,(M722*#REF!))","v":0},{"$f":"IF(ISERROR(N722*#REF!),0,(N722*#REF!))","v":0},{"$f":"IF(ISERROR(O722*#REF!),0,(O722*#REF!))","v":0},{"$f":"IF(ISERROR(P722*#REF!),0,(P722*#REF!))","v":0},{"$f":"IF(ISERROR(Q722*#REF!),0,(Q722*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H745*#REF!),0,(H745*#REF!))","v":0},{"$f":"IF(ISERROR(I745*#REF!),0,(I745*#REF!))","v":0},{"$f":"IF(ISERROR(J745*#REF!),0,(J745*#REF!))","v":0},{"$f":"IF(ISERROR(K745*#REF!),0,(K745*#REF!))","v":0},{"$f":"IF(ISERROR(L745*#REF!),0,(L745*#REF!))","v":0},{"$f":"IF(ISERROR(M745*#REF!),0,(M745*#REF!))","v":0},{"$f":"IF(ISERROR(N745*#REF!),0,(N745*#REF!))","v":0},{"$f":"IF(ISERROR(O745*#REF!),0,(O745*#REF!))","v":0},{"$f":"IF(ISERROR(P745*#REF!),0,(P745*#REF!))","v":0},{"$f":"IF(ISERROR(Q745*#REF!),0,(Q745*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H768*#REF!),0,(H768*#REF!))","v":0},{"$f":"IF(ISERROR(I768*#REF!),0,(I768*#REF!))","v":0},{"$f":"IF(ISERROR(J768*#REF!),0,(J768*#REF!))","v":0},{"$f":"IF(ISERROR(K768*#REF!),0,(K768*#REF!))","v":0},{"$f":"IF(ISERROR(L768*#REF!),0,(L768*#REF!))","v":0},{"$f":"IF(ISERROR(M768*#REF!),0,(M768*#REF!))","v":0},{"$f":"IF(ISERROR(N768*#REF!),0,(N768*#REF!))","v":0},{"$f":"IF(ISERROR(O768*#REF!),0,(O768*#REF!))","v":0},{"$f":"IF(ISERROR(P768*#REF!),0,(P768*#REF!))","v":0},{"$f":"IF(ISERROR(Q768*#REF!),0,(Q768*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H791*#REF!),0,(H791*#REF!))","v":0},{"$f":"IF(ISERROR(I791*#REF!),0,(I791*#REF!))","v":0},{"$f":"IF(ISERROR(J791*#REF!),0,(J791*#REF!))","v":0},{"$f":"IF(ISERROR(K791*#REF!),0,(K791*#REF!))","v":0},{"$f":"IF(ISERROR(L791*#REF!),0,(L791*#REF!))","v":0},{"$f":"IF(ISERROR(M791*#REF!),0,(M791*#REF!))","v":0},{"$f":"IF(ISERROR(N791*#REF!),0,(N791*#REF!))","v":0},{"$f":"IF(ISERROR(O791*#REF!),0,(O791*#REF!))","v":0},{"$f":"IF(ISERROR(P791*#REF!),0,(P791*#REF!))","v":0},{"$f":"IF(ISERROR(Q791*#REF!),0,(Q791*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H814*#REF!),0,(H814*#REF!))","v":0},{"$f":"IF(ISERROR(I814*#REF!),0,(I814*#REF!))","v":0},{"$f":"IF(ISERROR(J814*#REF!),0,(J814*#REF!))","v":0},{"$f":"IF(ISERROR(K814*#REF!),0,(K814*#REF!))","v":0},{"$f":"IF(ISERROR(L814*#REF!),0,(L814*#REF!))","v":0},{"$f":"IF(ISERROR(M814*#REF!),0,(M814*#REF!))","v":0},{"$f":"IF(ISERROR(N814*#REF!),0,(N814*#REF!))","v":0},{"$f":"IF(ISERROR(O814*#REF!),0,(O814*#REF!))","v":0},{"$f":"IF(ISERROR(P814*#REF!),0,(P814*#REF!))","v":0},{"$f":"IF(ISERROR(Q814*#REF!),0,(Q814*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H837*#REF!),0,(H837*#REF!))","v":0},{"$f":"IF(ISERROR(I837*#REF!),0,(I837*#REF!))","v":0},{"$f":"IF(ISERROR(J837*#REF!),0,(J837*#REF!))","v":0},{"$f":"IF(ISERROR(K837*#REF!),0,(K837*#REF!))","v":0},{"$f":"IF(ISERROR(L837*#REF!),0,(L837*#REF!))","v":0},{"$f":"IF(ISERROR(M837*#REF!),0,(M837*#REF!))","v":0},{"$f":"IF(ISERROR(N837*#REF!),0,(N837*#REF!))","v":0},{"$f":"IF(ISERROR(O837*#REF!),0,(O837*#REF!))","v":0},{"$f":"IF(ISERROR(P837*#REF!),0,(P837*#REF!))","v":0},{"$f":"IF(ISERROR(Q837*#REF!),0,(Q837*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H860*#REF!),0,(H860*#REF!))","v":0},{"$f":"IF(ISERROR(I860*#REF!),0,(I860*#REF!))","v":0},{"$f":"IF(ISERROR(J860*#REF!),0,(J860*#REF!))","v":0},{"$f":"IF(ISERROR(K860*#REF!),0,(K860*#REF!))","v":0},{"$f":"IF(ISERROR(L860*#REF!),0,(L860*#REF!))","v":0},{"$f":"IF(ISERROR(M860*#REF!),0,(M860*#REF!))","v":0},{"$f":"IF(ISERROR(N860*#REF!),0,(N860*#REF!))","v":0},{"$f":"IF(ISERROR(O860*#REF!),0,(O860*#REF!))","v":0},{"$f":"IF(ISERROR(P860*#REF!),0,(P860*#REF!))","v":0},{"$f":"IF(ISERROR(Q860*#REF!),0,(Q860*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H883*#REF!),0,(H883*#REF!))","v":0},{"$f":"IF(ISERROR(I883*#REF!),0,(I883*#REF!))","v":0},{"$f":"IF(ISERROR(J883*#REF!),0,(J883*#REF!))","v":0},{"$f":"IF(ISERROR(K883*#REF!),0,(K883*#REF!))","v":0},{"$f":"IF(ISERROR(L883*#REF!),0,(L883*#REF!))","v":0},{"$f":"IF(ISERROR(M883*#REF!),0,(M883*#REF!))","v":0},{"$f":"IF(ISERROR(N883*#REF!),0,(N883*#REF!))","v":0},{"$f":"IF(ISERROR(O883*#REF!),0,(O883*#REF!))","v":0},{"$f":"IF(ISERROR(P883*#REF!),0,(P883*#REF!))","v":0},{"$f":"IF(ISERROR(Q883*#REF!),0,(Q883*#REF!))","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF(ISERROR(H906*#REF!),0,(H906*#REF!))","v":0},{"$f":"IF(ISERROR(I906*#REF!),0,(I906*#REF!))","v":0},{"$f":"IF(ISERROR(J906*#REF!),0,(J906*#REF!))","v":0},{"$f":"IF(ISERROR(K906*#REF!),0,(K906*#REF!))","v":0},{"$f":"IF(ISERROR(L906*#REF!),0,(L906*#REF!))","v":0},{"$f":"IF(ISERROR(M906*#REF!),0,(M906*#REF!))","v":0},{"$f":"IF(ISERROR(N906*#REF!),0,(N906*#REF!))","v":0},{"$f":"IF(ISERROR(O906*#REF!),0,(O906*#REF!))","v":0},{"$f":"IF(ISERROR(P906*#REF!),0,(P906*#REF!))","v":0},{"$f":"IF(ISERROR(Q906*#REF!),0,(Q906*#REF!))","v":0}]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H1109:H1128)","v":0},{"$f":"SUM(I1109:I1128)","v":0},0,0,0,0,0,0,0,0]
[]
[]
[]
[null,null,null,null,null,null,"Process Scrap %",{"$f":"IF(SUM(H915)=0,0,SUM(H1079,H1098,H1129)/H915)","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]