{"text_format":"2","workbook":"xls","n_sheets":13,"sheets":["pp_2-3","pp_4-5","pp_8-9","pp_10-11","pp_12-13","pp_14-15","pp_16-17","pp_18-19","pp_20-21","pp_22-23","pp_24-25","BusinessCodes","blank"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":13,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"pp_2-3","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"pp_4-5","index":1,"n_rows":166,"n_cols":229,"rows_kept":166,"cut":false,"hidden":false,"merged":[[150,211,154,236],[150,137,152,139],[150,140,152,209],[153,137,155,139],[153,140,155,209],[147,137,149,209],[147,211,149,218],[147,219,149,227],[147,228,149,236],[133,137,135,139],[133,140,135,209],[139,129,142,135],[139,137,145,235],[127,137,129,209],[130,137,132,139],[130,140,132,209],[124,137,126,209],[121,211,125,236],[118,137,120,209],[121,137,123,139],[121,140,123,209],[107,137,116,235],[107,129,110,135],[118,211,120,218],[118,219,120,227],[118,228,120,236],[94,137,98,153],[94,157,98,231],[99,137,103,153],[99,157,103,231],[84,137,88,153],[84,157,88,231],[89,137,93,153],[89,157,93,231],[74,137,78,153],[74,157,78,231],[79,137,83,153],[79,157,83,231],[21,137,23,233],[24,137,26,233],[69,137,73,153],[69,157,73,231],[64,137,68,153],[64,157,68,231],[27,137,29,233],[30,137,32,233],[33,137,35,233],[37,141,40,235],[6,128,10,170],[51,137,58,153],[59,137,63,153],[51,157,58,231],[59,157,63,231],[42,141,45,147],[42,148,45,233],[46,148,48,233],[13,129,16,135],[13,137,19,227],[32,64,35,75],[33,15,35,49],[20,15,23,84],[25,49,28,55],[25,60,28,66],[26,15,28,44],[32,52,35,57],[32,58,35,63],[29,52,31,57],[29,58,31,63],[29,64,31,75],[7,7,10,13],[7,15,10,113],[12,19,15,113],[17,15,19,58],[17,88,19,114],[160,19,163,113],[165,19,168,113],[44,7,47,13],[44,15,47,113],[49,19,52,113],[69,6,73,115],[57,53,60,58],[57,59,60,64],[57,65,60,76],[62,19,65,113],[152,7,155,13],[152,15,158,113],[37,19,40,113],[58,15,60,50],[54,53,56,58],[54,59,56,64],[54,65,56,76]],"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[]
[]
[{"$nulls":128},"Business codes"]
[{"$nulls":7},1,{"$nulls":7},"Did another company own more than 50 percent of your company during 2009?"]
[]
[]
[]
[]
[{"$nulls":19},"Yes → Please provide the following information:"]
[{"$nulls":129},4,{"$nulls":7},"Do the business code(s) listed below reflect all applicable codes from the list on pages x-y in which your ocmpany operated worldwide during 2008?"]
[]
[]
[]
[{"$nulls":15},"Name of owner",{"$nulls":72},"EIN of owner (9 digits)"]
[]
[]
[]
[{"$nulls":137},"NOTE: Because these codes should reflect your company's global business activities and R&D"]
[]
[]
[{"$nulls":137},"they may differ from industry codes used by other government surveys and reports."]
[{"$nulls":49},"Yes",{"$nulls":10},"No"]
[{"$nulls":15},"Is the owner a U.S. company?"]
[]
[]
[{"$nulls":52},"(MM)",{"$nulls":5},"(DD)",{"$nulls":5},"(YYYY)"]
[{"$nulls":137},"If no business codes are printed below, please write in the codes from pages 8-9 that"]
[]
[]
[{"$nulls":15},"Date owner purchased your company",{"$nulls":121},"apply to your company"]
[]
[]
[]
[{"$nulls":19},"No",{"$nulls":121},"Yes → Continue with Question 5"]
[]
[]
[]
[]
[{"$nulls":141},"No → ",{"$nulls":6},"Draw a line through codes that are incorrect. As needed, enter additional"]
[]
[{"$nulls":7},2,{"$nulls":7},"Has your company ceased operations?"]
[]
[{"$nulls":148},"codes and descriptions from pages x-y in the spaces provided."]
[]
[]
[{"$nulls":19},"Yes → Please provide the following information:"]
[]
[{"$nulls":137},"Business Code\n(see pages x-y)",{"$nulls":19},"Description"]
[]
[]
[{"$nulls":53},"(MM)",{"$nulls":5},"(DD)",{"$nulls":5},"(YYYY)"]
[]
[]
[]
[{"$nulls":15},"Date your company ceased operations"]
[]
[]
[]
[{"$nulls":19},"No"]
[]
[]
[]
[]
[]
[]
[{"$nulls":6},"Use the following flowchart to determine how to complete the rest of this survey."]
{"$rows_empty":37}
[{"$nulls":129},5,{"$nulls":7},"What was the amount of your company's worldwide net sales and revenues—the value of goods and services sold during the year, net of discounts, returns, and allowances—during 2009?"]
{"$rows_empty":10}
[{"$nulls":137},"Include:",{"$nulls":73},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou."]
[]
[]
[{"$nulls":137},"•",null,null,"Sales and operating revenues for discontinued operations"]
[]
[]
[]
[]
[]
[{"$nulls":137},"Exclude:"]
[]
[]
[{"$nulls":137},"•",null,null,"Non-operating income (i.e. dividends, interest)"]
[]
[]
[{"$nulls":137},"•",null,null,"Excise, sales, and other revenue based taxes"]
[]
[]
[]
[]
[]
[{"$nulls":129},6,{"$nulls":7},"How much of the 2009 worldwide net sales and operating revenues reported in Question 5 was from domestic operations?"]
{"$rows_empty":7}
[{"$nulls":137},"Include:",{"$nulls":73},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou."]
[]
[]
[{"$nulls":137},"•",null,null,"Operating revenues and sales to foreign customers, including foreign"]
[]
[{"$nulls":7},3,{"$nulls":7},"Did your company own more than 50 percent of any company operations or subsidiaries outside the 50 United States and D.C. during 2009?"]
[{"$nulls":140},"subsidiaries"]
[]
[]
[]
[]
[]
[]
[{"$nulls":19},"Yes → Include data for these operations/subsidiaries in your survey responses"]
[]
[]
[]
[]
[{"$nulls":19},"No"]

{"sheet":"pp_8-9","index":2,"n_rows":167,"n_cols":229,"rows_kept":167,"cut":false,"hidden":false,"merged":[[104,211,108,236],[106,140,108,209],[157,129,160,135],[157,137,160,235],[123,211,127,236],[124,140,127,209],[166,141,169,235],[19,128,52,237],[146,129,149,135],[146,137,152,208],[146,211,148,218],[146,219,148,227],[149,211,153,236],[117,211,121,236],[97,211,101,236],[98,140,101,209],[55,129,58,135],[55,137,58,235],[60,137,62,208],[60,211,62,218],[60,219,62,227],[60,228,62,236],[63,211,67,236],[129,140,131,208],[132,140,134,208],[88,211,90,218],[88,219,90,227],[88,228,90,236],[91,211,95,236],[69,137,71,208],[72,137,74,208],[111,140,114,209],[116,137,118,139],[116,140,118,209],[63,137,65,208],[93,137,95,139],[103,137,105,139],[106,137,108,139],[90,137,92,139],[90,140,92,209],[93,140,95,209],[103,140,105,209],[78,129,81,135],[78,137,87,208],[66,137,68,208],[138,211,142,236],[139,140,142,209],[140,137,142,139],[99,137,101,139],[112,137,114,139],[135,140,137,208],[110,211,114,236],[162,141,165,235],[146,228,148,236],[119,137,121,139],[119,140,121,209],[125,137,127,139],[6,128,11,237],[12,128,17,237],[152,7,155,58],[152,63,155,114],[117,69,120,80],[81,62,85,87],[81,89,85,114],[82,18,85,24],[83,15,85,17],[83,25,85,61],[156,7,159,58],[156,63,159,114],[118,26,120,32],[118,56,120,62],[124,15,127,86],[124,107,126,114],[127,107,131,114],[117,33,120,38],[117,39,120,50],[117,63,120,68],[59,15,61,17],[75,89,79,114],[77,15,79,17],[77,35,79,61],[57,18,61,34],[57,62,61,87],[57,89,61,114],[59,35,61,61],[71,15,73,17],[71,35,73,61],[45,89,49,114],[47,15,49,17],[47,35,49,61],[51,89,55,114],[53,15,55,17],[53,35,55,61],[51,18,55,34],[51,62,55,87],[45,18,49,34],[45,62,49,87],[30,106,32,114],[33,18,37,34],[33,62,37,87],[33,89,37,114],[35,35,37,61],[30,89,32,96],[30,97,32,105],[39,18,43,34],[39,62,43,87],[41,15,43,17],[25,18,32,34],[41,35,43,61],[35,15,37,17],[30,62,32,69],[63,89,67,114],[63,18,67,34],[63,62,67,87],[65,35,67,61],[7,7,10,13],[75,18,79,34],[75,62,79,87],[30,70,32,78],[30,79,32,87],[7,15,19,105],[21,62,29,87],[21,89,29,114],[39,89,43,114],[65,15,67,17],[135,7,138,13],[135,15,138,113],[87,35,89,60],[87,62,89,87],[93,6,97,37],[87,89,89,114],[114,33,116,38],[114,39,116,50],[114,63,116,68],[114,69,116,80],[109,19,112,113],[124,7,127,13],[100,7,103,13],[100,15,103,113],[69,18,73,34],[69,62,73,87],[69,89,73,114],[148,7,151,58],[148,63,151,114],[141,8,143,18],[141,64,143,74],[144,7,147,58],[144,63,147,114],[105,19,108,113]],"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[]
[]
[{"$nulls":128},"SECTION 1"]
[{"$nulls":7},7,{"$nulls":7},"How much of the 2009 sales and operating revenue amounts was for each business code listed or amended in Question 4:\n(1) Worldwide net sales and operating revenues reported in Question 5\n(2) Domestic net sales and operating revenues reported in Question 6"]
[]
[]
[]
[]
[{"$nulls":128},"Financial Schedule 1"]
[]
[]
[]
[]
[]
[]
[{"$nulls":128},"instruction space - possibly use variable printing"]
[]
[{"$nulls":62},"(1)\nWorldwide\nsales and revenues",{"$nulls":26},"(2)\nDomestic\nsales and revenues"]
[]
[]
[]
[{"$nulls":18},"Business Code\n(see page x)"]
[]
[]
[]
[]
[{"$nulls":62},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou.",{"$nulls":9},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou."]
[]
[]
[]
[]
[{"$nulls":15},"a.",{"$nulls":19}," "]
[]
[]
[]
[]
[]
[{"$nulls":15},"b.",{"$nulls":19}," "]
[]
[]
[]
[]
[]
[{"$nulls":15},"c.",{"$nulls":19}," "]
[]
[]
[]
[]
[]
[{"$nulls":15},"d.",{"$nulls":19}," "]
[]
[{"$nulls":129},"1•1",{"$nulls":7},"What was the total worldwide R&D expense for your company in 2009?"]
[]
[]
[]
[{"$nulls":15},"e.",{"$nulls":19}," "]
[{"$nulls":137},"This amount is equivalent to that disclosed by publicly traded companies ",{"$nulls":73},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou."]
[]
[]
[{"$nulls":137},"on SEC Form 10-K as defined by FASB Statement No. 2, \"Accounting"]
[]
[{"$nulls":15},"f.",{"$nulls":19}," "]
[{"$nulls":137},"for Research and Development Costs\". Foreign-owned companies should"]
[]
[]
[{"$nulls":137},"refer to the instructions on page 3. Additional guidance is available online:"]
[]
[{"$nulls":15},"g.",{"$nulls":19}," "]
[{"$nulls":137},"www.census.gov/econhelp/brdis/ ..."]
[]
[]
[]
[]
[{"$nulls":15},"h.",{"$nulls":19}," "]
[{"$nulls":129},"1•2",{"$nulls":7},"If the amount reported in Question 1•1 (worldwide R&D expense) included any of the following costs, how much was included?"]
[]
[]
[]
[{"$nulls":18},"Total"]
[{"$nulls":15},"i.",{"$nulls":9}," "]
[]
[]
[]
[{"$nulls":62},"Total equals Question 5",{"$nulls":26},"Total equals Question 6"]
[{"$nulls":211},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou."]
[]
[{"$nulls":137},"a.",null,null,"Collaborative research and development that was reimbursed by"]
[]
[]
[{"$nulls":6},"Reporting Information",{"$nulls":133},"business partners, such as through cost-sharing agreements"]
[]
[]
[]
[]
[{"$nulls":140},"R&D paid for by government or private foundation grants"]
[{"$nulls":137},"b."]
[{"$nulls":7},8,{"$nulls":7},"Is the information in this section reported on a calendar year basis?"]
[]
[]
[{"$nulls":137},"c.",null,null,"Technical services not an integral part of an R&D project (such as"]
[]
[{"$nulls":19},"Yes"]
[{"$nulls":140},"product support provided by R&D employees)"]
[]
[]
[{"$nulls":19},"No → Enter the time period covered below:"]
[]
[{"$nulls":140},"Bid and proposal costs"]
[{"$nulls":137},"d."]
[]
[{"$nulls":33},"(MM)",{"$nulls":5},"(YYYY)",{"$nulls":23},"(MM)",{"$nulls":5},"(YYYY)"]
[]
[{"$nulls":137},"e.",null,null,"Costs your company plans to recoup through indirect charges on"]
[]
[{"$nulls":26},"From",{"$nulls":29},"To"]
[{"$nulls":140},"U.S. federal government contracts (IR&D)"]
[]
[]
[]
[]
[{"$nulls":7},9,{"$nulls":7},"Approximately how long did it take to complete this section?",{"$nulls":91},"Hours",{"$nulls":32},"In-process R&D (IPR&D)"]
[{"$nulls":137},"f."]
[]
[]
[]
[{"$nulls":140},"In-process R&D is an expense resulting from a business acquisition"]
[]
[]
[{"$nulls":140},"attributable to the acquired company's R&D that has not resulted in a"]
[]
[]
[{"$nulls":7},10,{"$nulls":7},"Please list the names and titles of the persons who provided data for this section.",{"$nulls":124},"finished product or process."]
[]
[]
[]
[{"$nulls":140},"Total"]
[{"$nulls":137},"g."]
[{"$nulls":8},"Name",{"$nulls":55},"Title"]
[]
[]
[]
[]
[{"$nulls":129},"1•3",{"$nulls":7},"Subtract 1•2, line g, from 1•1 and enter the result here. \nThis is the total R&D paid for by your company in 2009.",{"$nulls":73},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou."]
{"$rows_empty":10}
[{"$nulls":129},"1•4",{"$nulls":7},"Was the amount entered in Question 1•3 greater than zero?"]
[]
[]
[]
[]
[{"$nulls":141},"Yes → Continue with Question 1•5"]
[]
[]
[]
[{"$nulls":141},"No → Skip to Section 2 on page 16"]

{"sheet":"pp_10-11","index":3,"n_rows":167,"n_cols":229,"rows_kept":167,"cut":false,"hidden":false,"merged":[[163,15,165,17],[163,66,165,68],[163,69,165,87],[160,66,162,68],[160,69,162,87],[161,38,165,63],[161,89,165,114],[154,38,158,63],[154,89,158,114],[155,18,158,36],[162,18,165,36],[156,15,158,17],[156,66,158,68],[156,69,158,87],[148,38,152,63],[148,89,152,114],[149,18,152,36],[150,15,152,17],[150,66,152,68],[150,69,152,87],[142,38,146,63],[142,89,146,114],[143,18,146,36],[144,15,146,17],[144,66,146,68],[144,69,146,87],[136,38,140,63],[136,89,140,114],[137,18,140,36],[138,15,140,17],[138,66,140,68],[138,69,140,87],[130,38,134,63],[130,89,134,114],[131,18,134,36],[132,15,134,17],[132,66,134,68],[132,69,134,87],[124,38,128,63],[124,89,128,114],[125,18,128,36],[126,15,128,17],[126,66,128,68],[126,69,128,87],[118,38,122,63],[118,89,122,114],[119,18,122,36],[120,15,122,17],[120,66,122,68],[120,69,122,87],[112,38,116,63],[112,89,116,114],[114,15,116,17],[114,18,116,36],[114,66,116,68],[114,69,116,87],[6,6,10,48],[13,7,16,13],[13,15,22,105],[24,15,26,105],[27,15,29,105],[30,15,32,105],[34,18,41,34],[39,89,41,96],[39,97,41,105],[39,106,41,114],[42,18,46,34],[42,89,46,114],[44,15,46,17],[44,35,46,87],[48,18,52,34],[48,89,52,114],[50,15,52,17],[50,35,52,87],[54,18,58,34],[54,89,58,114],[56,15,58,17],[56,35,58,87],[60,18,64,34],[60,89,64,114],[62,15,64,17],[62,35,64,87],[66,18,70,34],[66,89,70,114],[68,15,70,17],[68,35,70,87],[80,15,82,17],[80,35,82,87],[72,18,76,34],[72,89,76,114],[74,15,76,17],[74,35,76,87],[109,97,111,105],[90,89,94,114],[91,18,94,45],[92,15,94,17],[92,46,94,87],[109,106,111,114],[109,38,111,45],[109,46,111,54],[109,55,111,63],[109,89,111,96],[7,211,9,218],[7,219,9,227],[98,7,101,13],[98,15,104,105],[84,18,88,34],[84,89,88,114],[86,15,88,17],[86,35,88,87],[78,18,82,34],[78,89,82,114],[7,228,9,236],[10,211,14,236],[18,129,21,135],[18,137,24,208],[18,211,20,218],[18,219,20,227],[18,228,20,236],[21,211,25,236],[7,129,10,135],[7,137,13,208],[29,129,32,135],[29,137,35,227],[37,157,44,182],[37,184,44,209],[37,211,44,236],[45,219,47,227],[45,157,47,164],[45,165,47,173],[45,174,47,182],[45,184,47,191],[45,228,47,236],[47,137,49,139],[47,140,49,155],[48,157,52,182],[48,184,52,209],[48,211,52,236],[50,140,52,155],[45,192,47,200],[45,201,47,209],[45,211,47,218],[54,157,58,182],[54,184,58,209],[54,211,58,236],[56,137,58,139],[56,140,58,155],[60,137,62,139],[60,140,62,155],[61,157,65,182],[61,184,65,209],[67,137,69,139],[67,140,69,155],[68,157,72,182],[68,184,72,209],[70,140,72,155],[61,211,65,236],[63,140,65,155],[68,211,72,236],[75,211,79,236],[77,140,79,155],[82,211,86,236],[84,140,86,155],[74,137,76,139],[74,140,76,155],[81,137,83,139],[81,140,83,155],[82,157,86,182],[82,184,86,209],[75,157,79,182],[75,184,79,209],[88,137,90,139],[88,140,90,155],[89,157,93,182],[89,184,93,209],[95,137,97,139],[95,140,97,155],[96,157,100,182],[96,184,100,209],[98,140,100,155],[89,211,93,236],[91,140,93,155],[96,211,100,236],[103,211,107,236],[105,140,107,155],[110,211,114,236],[112,140,114,155],[102,137,104,139],[102,140,104,155],[109,137,111,139],[109,140,111,155],[110,157,114,182],[110,184,114,209],[103,157,107,182],[103,184,107,209],[116,137,118,139],[116,140,118,155],[119,140,121,155],[120,157,124,182],[120,184,124,209],[120,211,124,236],[122,140,124,155],[126,137,128,139],[126,140,128,155],[127,157,131,182],[127,184,131,209],[127,211,131,236],[129,140,131,155],[133,157,137,182],[133,184,137,209],[133,211,137,236],[135,137,137,139],[135,140,137,155],[139,157,141,182],[139,184,141,209],[139,211,141,236],[145,129,148,135],[145,137,151,227],[153,157,160,182],[153,184,160,209],[153,211,160,236],[157,137,159,155],[160,137,162,155],[161,157,163,164],[161,165,163,173],[161,174,163,182],[161,184,163,191],[161,192,163,200],[163,137,165,155],[164,157,168,182],[164,184,168,209],[164,211,168,236],[166,137,168,155],[161,201,163,209],[161,211,163,218],[161,219,163,227],[161,228,163,236]],"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[]
[]
[{"$nulls":6},"R&D paid for by your company"]
[{"$nulls":129},"1•7",{"$nulls":7},"Copy the amount from Question 1•6, line a. This is the total domestic R&D paid for by your company in 2009.",{"$nulls":73},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou."]
[]
[]
[]
[]
[]
[{"$nulls":7},"1•5",{"$nulls":7},"Of the amount reported in Question 1•3 (total R&D paid for by your company in 2009), what were the costs for each business code listed or amended or page 5 of this form?"]
[]
[]
[]
[]
[{"$nulls":129},"1•8",{"$nulls":7},"Add 1•6, lines b through q, and enter the result here. This is the total foreign R&D paid for by your company in 2009.",{"$nulls":73},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou."]
[]
[]
[]
[]
[]
[{"$nulls":15},"Allocate R&D that is applicable to more than one business code on a reasonable basis."]
[]
[]
[{"$nulls":15},"Allocation in proportion to operating revenues is acceptable unless some alternative allocation"]
[]
[{"$nulls":129},"1•9",{"$nulls":7},"How much of the (1) domestic, (2) foreign, and (3) total worldwide R&D paid for by your company in 2009 was for each of the following types of costs?"]
[{"$nulls":15},"basis is more appropriate."]
[]
[]
[]
[{"$nulls":18},"Business Code\n(see page x)"]
[]
[]
[{"$nulls":157},"(1)\nDomestic R&D",{"$nulls":26},"(2)\nForeign R&D",{"$nulls":26},"(3)\nTotal worldwide R&D"]
[]
[{"$nulls":89},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou."]
[]
[]
[]
[]
[{"$nulls":15},"a.",{"$nulls":19}," "]
[{"$nulls":157},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou.",{"$nulls":9},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou.",{"$nulls":9},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou."]
[]
[{"$nulls":137},"a.",null,null,"Gross annual"]
[]
[]
[{"$nulls":15},"b.",{"$nulls":19}," ",{"$nulls":104},"payroll"]
[]
[]
[]
[]
[]
[{"$nulls":15},"c.",{"$nulls":19}," ",{"$nulls":101},"b.",null,null,"Fringe benefits"]
[]
[]
[]
[{"$nulls":137},"c.",null,null,"Stock-based"]
[]
[{"$nulls":15},"d.",{"$nulls":19}," "]
[{"$nulls":140},"compensation"]
[]
[]
[]
[{"$nulls":137},"d.",null,null,"Temporary"]
[{"$nulls":15},"e.",{"$nulls":19}," "]
[]
[{"$nulls":140},"staffing"]
[]
[]
[]
[{"$nulls":15},"f.",{"$nulls":19}," ",{"$nulls":101},"e.",null,null,"Expensed"]
[]
[]
[{"$nulls":140},"equipment"]
[]
[]
[{"$nulls":15},"g.",{"$nulls":19}," "]
[{"$nulls":137},"f.",null,null,"Materials and"]
[]
[]
[{"$nulls":140},"supplies"]
[]
[{"$nulls":15},"h.",{"$nulls":19}," "]
[]
[{"$nulls":137},"g.",null,null,"Lease and"]
[]
[]
[{"$nulls":18},"Total (equals Question 1•3)",{"$nulls":121},"rental payments"]
[{"$nulls":15},"i.",{"$nulls":30}," "]
[]
[]
[{"$nulls":137},"h.",null,null,"Depreciation &"]
[]
[]
[{"$nulls":7},"1•6",{"$nulls":7},"Of the amount reported in Question 1•3 (total R&D paid for by your company in 2009), what were the costs in the following countries?",{"$nulls":124},"amortization"]
[]
[]
[]
[{"$nulls":137},"i.",null,null,"Payments to"]
[]
[]
[{"$nulls":140},"collaborators"]
[]
[]
[]
[{"$nulls":38},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou.",{"$nulls":33},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou.",{"$nulls":30},"j.",null,null,"Purchased R&D"]
[]
[]
[{"$nulls":140},"services"]
[]
[{"$nulls":15},"a.",null,null,"Domestic U.S.",{"$nulls":47},"j.",null,null,"Italy"]
[]
[{"$nulls":137},"k.",null,null,"All other"]
[]
[]
[{"$nulls":18},"United Kingdom",{"$nulls":121},"purchased"]
[{"$nulls":15},"b.",{"$nulls":50},"k.",null,null,"Japan"]
[]
[{"$nulls":140},"services"]
[]
[]
[{"$nulls":18},"Canada"]
[{"$nulls":15},"c.",{"$nulls":50},"l.",null,null,"Russia",{"$nulls":67},"l.",null,null,"All other"]
[]
[]
[{"$nulls":140},"costs"]
[]
[{"$nulls":18},"China"]
[{"$nulls":15},"d.",{"$nulls":50},"m.",null,null,"Singapore"]
[]
[]
[{"$nulls":137},"m.",null,null,"Total"]
[]
[{"$nulls":18},"France"]
[{"$nulls":15},"e.",{"$nulls":50},"n.",null,null,"South Korea"]
[{"$nulls":157},"Total equals Question 1•7",{"$nulls":26},"Total equals Question 1•8",{"$nulls":26},"Total equals Question 1•3"]
[]
[]
[]
[{"$nulls":18},"Germany"]
[{"$nulls":15},"f.",{"$nulls":50},"o.",null,null,"Sweden"]
[{"$nulls":129},"1•10",{"$nulls":7},"Add 1•9, lines i and j for each column, and enter the result here.\nThis is R&D performed by others."]
[]
[]
[]
[{"$nulls":18},"India"]
[{"$nulls":15},"g.",{"$nulls":50},"p.",null,null,"United Kingdom"]
[]
[]
[{"$nulls":157},"(1)\nDomestic R&D",{"$nulls":26},"(2)\nForeign R&D",{"$nulls":26},"(3)\nTotal worldwide R&D"]
[]
[{"$nulls":18},"Ireland"]
[{"$nulls":15},"h.",{"$nulls":50},"q.",null,null,"All other"]
[]
[]
[]
[{"$nulls":66},"r.",null,null,"Total (equals"]
[{"$nulls":157},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou.",{"$nulls":9},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou.",{"$nulls":9},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou."]
[{"$nulls":18},"Israel"]
[{"$nulls":15},"i.",{"$nulls":53},"Question 1•3)",{"$nulls":67},"R&D performed"]
[]
[]
[{"$nulls":137},"by others"]

{"sheet":"pp_12-13","index":4,"n_rows":167,"n_cols":229,"rows_kept":167,"cut":false,"hidden":false,"merged":[[53,137,56,235],[58,137,60,180],[166,6,168,115],[23,188,25,209],[27,160,31,185],[27,211,31,236],[29,137,31,158],[29,188,31,209],[29,106,31,114],[21,160,25,185],[7,7,10,13],[17,137,19,158],[17,188,19,209],[18,7,21,13],[12,160,14,167],[12,168,14,176],[12,177,14,185],[18,15,24,105],[7,129,10,135],[7,137,10,227],[12,228,14,236],[15,160,19,185],[15,211,19,236],[7,15,13,86],[7,89,9,96],[7,97,9,105],[7,106,9,114],[10,89,14,114],[12,211,14,218],[12,219,14,227],[29,97,31,105],[32,38,36,63],[32,89,36,114],[34,15,36,36],[34,66,36,87],[29,38,31,45],[29,46,31,54],[29,55,31,63],[29,89,31,96],[38,38,42,63],[38,89,42,114],[40,15,42,36],[40,66,42,87],[44,38,48,63],[44,89,48,114],[46,15,48,36],[46,66,48,87],[50,38,54,63],[50,89,54,114],[52,15,54,36],[52,66,54,87],[56,38,60,63],[56,89,60,114],[58,15,60,36],[58,66,60,87],[62,38,66,63],[62,89,66,114],[64,15,66,36],[64,66,66,87],[68,38,72,63],[68,89,72,114],[70,15,72,36],[70,66,72,87],[74,38,78,63],[74,89,78,114],[76,15,78,36],[76,66,78,87],[80,38,84,63],[80,89,84,114],[82,15,84,36],[82,66,84,87],[86,38,90,63],[86,89,90,114],[88,15,90,36],[88,66,90,87],[92,38,96,63],[92,89,96,114],[94,15,96,36],[94,66,96,87],[98,38,102,63],[98,89,102,114],[100,15,102,36],[100,66,102,87],[104,38,108,63],[104,89,108,114],[106,15,108,36],[106,66,108,87],[110,38,114,63],[110,89,114,114],[112,15,114,36],[112,66,114,87],[116,38,120,63],[116,89,120,114],[118,15,120,36],[118,66,120,87],[122,38,126,63],[122,89,126,114],[124,15,126,36],[124,66,126,87],[128,38,132,63],[128,89,132,114],[130,15,132,36],[130,66,132,87],[134,38,138,63],[134,89,138,114],[136,15,138,36],[136,66,138,87],[140,38,144,63],[140,89,144,114],[142,15,144,36],[142,66,144,87],[146,38,150,63],[146,89,150,114],[148,15,150,36],[148,66,150,87],[152,38,156,63],[152,89,156,114],[154,15,156,36],[154,66,156,87],[158,38,162,63],[158,89,162,114],[160,15,162,36],[160,66,162,87],[42,129,45,135],[42,137,48,227],[21,211,25,236],[23,137,25,158],[50,137,52,180],[34,160,38,185],[34,211,38,236],[36,137,38,158],[36,188,38,209],[33,188,35,209],[61,137,64,235],[66,137,68,180],[69,221,72,235],[69,212,72,217],[66,212,68,218],[66,221,68,235],[69,137,72,207],[76,228,78,236],[79,211,83,236],[76,137,85,208],[76,129,79,135],[76,211,78,218],[76,219,78,227],[146,211,150,236],[147,140,150,209],[148,137,150,139],[152,211,156,236],[153,140,156,209],[154,137,156,139],[139,137,141,139],[139,140,141,209],[140,211,144,236],[142,137,144,139],[142,140,144,209],[132,137,134,139],[132,140,134,209],[133,211,137,236],[135,137,137,139],[135,140,137,209],[120,211,124,236],[121,140,124,209],[122,137,124,139],[126,211,130,236],[127,140,130,209],[128,137,130,139],[108,211,112,236],[109,140,112,209],[110,137,112,139],[114,211,118,236],[115,140,118,209],[116,137,118,139],[99,228,101,236],[102,211,106,236],[103,140,106,209],[104,137,106,139],[89,129,92,135],[89,137,98,208],[99,211,101,218],[99,219,101,227]],"flags":["formulas_cached_only"]}
{"$rows_empty":7}
[{"$nulls":7},"1•11",{"$nulls":7},"Subtract 1•10, column 1, from 1•7 and enter the result here. \nThis is the domestic R&D performed by your company.",{"$nulls":73},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou.",{"$nulls":22},"1•12",{"$nulls":7},"(Continued)"]
[]
[]
[]
[]
[{"$nulls":160},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou.",{"$nulls":33},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou."]
[]
[]
[]
[]
[{"$nulls":137},"Utah",{"$nulls":50},"West Virginia"]
[{"$nulls":7},"1•12",{"$nulls":7},"How much of the domestic R&D performed by your company reported in Question 1•11 was performed in each state (including D.C.) in 2009?"]
[]
[]
[]
[]
[{"$nulls":137},"Vermont",{"$nulls":50},"Wisconsin"]
[]
[]
[]
[]
[]
[{"$nulls":38},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou.",{"$nulls":33},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou.",{"$nulls":30},"Virginia",{"$nulls":50},"Wyoming"]
[]
[]
[]
[{"$nulls":188},"Total (equals"]
[{"$nulls":15},"Alabama",{"$nulls":50},"Michigan"]
[]
[{"$nulls":137},"Washington",{"$nulls":50},"Question 1•11)"]
[]
[]
[]
[{"$nulls":15},"Alaska",{"$nulls":50},"Minnesota"]
[]
[{"$nulls":129},"1•13",{"$nulls":7},"At what domestic location did your company perform the largest dollar amount of R&D in 2009?"]
[]
[]
[]
[{"$nulls":15},"Arizona",{"$nulls":50},"Mississippi"]
[]
[]
[]
[{"$nulls":137},"Address 1"]
[]
[{"$nulls":15},"Arkansas",{"$nulls":50},"Missouri"]
[]
[]
[]
[]
[]
[{"$nulls":15},"California",{"$nulls":50},"Montana",{"$nulls":70},"Address 2"]
[]
[]
[]
[]
[]
[{"$nulls":15},"Colorodo",{"$nulls":50},"Nebraska"]
[]
[{"$nulls":137},"City",{"$nulls":74},"State",{"$nulls":8},"ZIP"]
[]
[]
[]
[{"$nulls":15},"Connecticut",{"$nulls":50},"Nevada"]
[]
[]
[]
[]
[]
[{"$nulls":15},"Deleware",{"$nulls":50},"New Hampshire",{"$nulls":62},"1•14",{"$nulls":7},"How much of the domestic R&D performed by your company reported in Question 1•11 was from the location identified in Question 1•13?",{"$nulls":73},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou."]
[]
[]
[]
[]
[]
[{"$nulls":15},"District of Columbia",{"$nulls":50},"New Jersey"]
[]
[]
[]
[]
[]
[{"$nulls":15},"Florida",{"$nulls":50},"New Mexico"]
[{"$nulls":129},"1•15",{"$nulls":7},"How much of the total worldwide R&D performed by others, reported in Question 1•10, column 3, was performed by the following types of organizations?"]
[]
[]
[]
[]
[{"$nulls":15},"Georgia",{"$nulls":50},"New York"]
[]
[]
[]
[]
[{"$nulls":211},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou."]
[{"$nulls":15},"Hawaii",{"$nulls":50},"North Carolina"]
[]
[]
[{"$nulls":140},"Companies located inside the United States"]
[{"$nulls":137},"a."]
[]
[{"$nulls":15},"Idaho",{"$nulls":50},"North Dakota"]
[]
[]
[{"$nulls":140},"Companies located outside the United States"]
[{"$nulls":137},"b."]
[]
[{"$nulls":15},"Illinois",{"$nulls":50},"Ohio"]
[]
[]
[{"$nulls":140},"U.S. federal government agencies or laboratories"]
[{"$nulls":137},"c."]
[]
[{"$nulls":15},"Indiana",{"$nulls":50},"Oklahoma"]
[]
[]
[{"$nulls":140},"U.S. state and local government agencies or laboratories"]
[{"$nulls":137},"d."]
[]
[{"$nulls":15},"Iowa",{"$nulls":50},"Oregon"]
[]
[]
[{"$nulls":140},"Foreign government agencies or laboratories"]
[{"$nulls":137},"e."]
[]
[{"$nulls":15},"Kansas",{"$nulls":50},"Pennsylvania"]
[]
[{"$nulls":137},"f.",null,null,"Universities, colleges, and academic researchers (including"]
[]
[]
[{"$nulls":140},"principal investigators) located inside the United States"]
[{"$nulls":15},"Kentucky",{"$nulls":50},"Rhode Island"]
[]
[]
[{"$nulls":137},"g.",null,null,"Universities, colleges, and academic researchers (including"]
[]
[]
[{"$nulls":15},"Louisiana",{"$nulls":50},"South Carolina",{"$nulls":73},"principal investigators) located outside the United States"]
[]
[]
[]
[]
[{"$nulls":140},"All other organizations (including hospitals and nonprofit organizations)"]
[{"$nulls":15},"Maine",{"$nulls":50},"South Dakota",{"$nulls":70},"h."]
[]
[]
[]
[]
[{"$nulls":140},"Total R&D performed by others (equals Question 1•10, column 3)"]
[{"$nulls":15},"Maryland",{"$nulls":50},"Tennessee",{"$nulls":70},"i."]
[]
[]
[]
[]
[]
[{"$nulls":15},"Massachusetts",{"$nulls":50},"Texas"]
[]
[]
[]
[]
[]
[{"$nulls":6},"Question continues on next page"]

{"sheet":"pp_14-15","index":5,"n_rows":149,"n_cols":230,"rows_kept":149,"cut":false,"hidden":false,"merged":[[133,129,136,180],[133,185,136,236],[137,129,140,180],[137,185,140,236],[103,148,105,154],[103,178,105,184],[109,129,112,135],[109,137,112,208],[102,155,105,160],[102,161,105,172],[102,185,105,190],[102,191,105,202],[64,140,67,209],[65,137,67,139],[69,140,71,209],[70,211,74,236],[72,137,74,139],[72,140,74,209],[6,128,10,170],[13,129,16,135],[13,137,19,208],[13,211,15,218],[16,211,20,236],[13,219,15,227],[13,228,15,236],[129,185,132,236],[109,229,111,236],[112,229,116,236],[120,129,123,135],[120,137,123,235],[126,130,128,140],[126,186,128,196],[129,129,132,180],[90,141,93,235],[94,141,97,235],[99,155,101,160],[99,161,101,172],[99,185,101,190],[99,191,101,202],[78,128,82,159],[85,129,88,135],[42,228,44,236],[24,137,30,208],[24,211,26,218],[24,219,26,227],[24,228,26,236],[27,211,31,236],[24,129,27,135],[59,137,61,139],[141,129,144,180],[141,185,144,236],[45,211,49,236],[46,140,49,209],[47,137,49,139],[85,137,88,235],[69,137,71,139],[63,211,67,236],[57,211,61,236],[58,140,61,209],[51,211,55,236],[52,140,55,209],[53,137,55,139],[37,62,45,87],[46,106,48,114],[35,129,38,135],[35,137,41,208],[42,211,44,218],[42,219,44,227],[109,6,113,48],[116,7,119,13],[116,15,122,105],[37,89,45,114],[41,18,48,34],[46,62,48,69],[46,70,48,78],[46,79,48,87],[46,89,48,96],[46,97,48,105],[49,18,53,34],[49,62,53,87],[49,89,53,114],[51,15,53,17],[51,35,53,61],[55,18,59,34],[55,62,59,87],[55,89,59,114],[57,15,59,17],[57,35,59,61],[61,18,65,34],[61,62,65,87],[61,89,65,114],[63,15,65,17],[63,35,65,61],[67,18,71,34],[67,62,71,87],[67,89,71,114],[69,15,71,17],[69,35,71,61],[73,18,77,34],[73,62,77,87],[73,89,77,114],[75,15,77,17],[75,35,77,61],[79,18,83,34],[79,62,83,87],[79,89,83,114],[81,15,83,17],[81,35,83,61],[85,18,89,34],[85,62,89,87],[85,89,89,114],[87,15,89,17],[87,35,89,61],[99,15,101,17],[98,18,101,24],[99,25,101,61],[91,18,95,34],[93,15,95,17],[93,35,95,61],[7,106,9,114],[10,89,14,114],[23,7,26,13],[23,15,35,105],[7,7,10,13],[7,15,19,86],[7,89,9,96],[7,97,9,105],[148,106,150,114],[151,89,155,114],[148,15,160,86],[129,62,136,87],[129,89,136,114],[137,89,139,96],[137,97,139,105],[137,106,139,114],[139,15,141,33],[140,35,144,60],[124,15,126,105],[148,7,151,13],[148,89,150,96],[148,97,150,105],[129,35,136,60],[133,15,135,33],[136,15,138,33],[137,35,139,42],[137,43,139,51],[137,52,139,60],[140,62,144,87],[140,89,144,114],[142,15,144,33],[137,62,139,69],[137,70,139,78],[137,79,139,87],[91,62,95,87],[91,89,95,114],[103,35,105,60],[103,62,105,87],[103,89,105,114],[97,62,101,87],[97,89,101,114]],"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[]
[]
[{"$nulls":128},"Capital Expenditures"]
[{"$nulls":7},"1•16",{"$nulls":7},"How much of the total R&D paid for by your company reported in Question 2•3 was a domestic R&D expense—R&D paid for by your company's domestic operations irrespective of where the R&D was performed?",{"$nulls":73},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou."]
[]
[]
[]
[]
[]
[{"$nulls":129},"1•20",{"$nulls":7},"What was the amount of your company's capital expenditures in the domestic United States in 2009?",{"$nulls":73},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou."]
{"$rows_empty":9}
[{"$nulls":7},"1•17",{"$nulls":7},"How much of the R&D paid for by your company for each business code reported in Question 2•9 was:\n(1) Domestic R&D expense reported in Question 1•16\n(2) Domestic R&D performed by your company reported in Question 1•11"]
[{"$nulls":129},"1•21",{"$nulls":7},"Of the amount reported in Question 1•20 (domestic capital expenditures), how much was for R&D operations?",{"$nulls":73},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou."]
{"$rows_empty":10}
[{"$nulls":129},"1•22",{"$nulls":7},"Of the amount reported in Question 1•22 (domestic capital expenditures for R&D), how much was for the following?"]
[]
[{"$nulls":62},"(1)\nDomestic\nR&D expense",{"$nulls":26},"(2)\nDomestic R&D performed\nby your company"]
[]
[]
[]
[{"$nulls":18},"Business Code\n(see page x)"]
[{"$nulls":211},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou."]
[]
[]
[]
[{"$nulls":62},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou.",{"$nulls":9},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou.",{"$nulls":33},"Structures"]
[{"$nulls":137},"a."]
[]
[]
[]
[{"$nulls":15},"a.",{"$nulls":19}," "]
[{"$nulls":140},"Equipment"]
[{"$nulls":137},"b."]
[]
[]
[]
[{"$nulls":15},"b.",{"$nulls":19}," "]
[{"$nulls":140},"Capitalized software"]
[{"$nulls":137},"c."]
[]
[]
[]
[{"$nulls":15},"c.",{"$nulls":19}," "]
[{"$nulls":140},"All other capital expenditures for R&D operations"]
[{"$nulls":137},"d."]
[]
[]
[]
[{"$nulls":15},"d.",{"$nulls":19}," ",{"$nulls":101},"e.",null,null,"Total domestic capital expenditures for R&D"]
[]
[]
[{"$nulls":140},"(equals Question 1•21)"]
[]
[]
[{"$nulls":15},"e.",{"$nulls":19}," "]
[]
[]
[{"$nulls":128},"Reporting Information"]
[]
[]
[{"$nulls":15},"f.",{"$nulls":19}," "]
[]
[]
[]
[{"$nulls":129},"1•23",{"$nulls":7},"Is the information in this section reported on a calendar year basis?"]
[]
[{"$nulls":15},"g.",{"$nulls":19}," "]
[]
[]
[{"$nulls":141},"Yes"]
[]
[]
[{"$nulls":15},"h.",{"$nulls":19}," "]
[{"$nulls":141},"No → Enter the time period covered below:"]
[]
[]
[]
[{"$nulls":18},"Total"]
[{"$nulls":15},"i.",{"$nulls":9}," ",{"$nulls":129},"(MM)",{"$nulls":5},"(YYYY)",{"$nulls":23},"(MM)",{"$nulls":5},"(YYYY)"]
[]
[]
[]
[{"$nulls":62},"Total equals Question 1•16",{"$nulls":26},"Total equals Question 1•11",{"$nulls":58},"From",{"$nulls":29},"To"]
[]
[]
[]
[]
[]
[{"$nulls":6},"Projected R&D for 2010",{"$nulls":122},"1•24",{"$nulls":7},"Approximately how long did it take to complete this section?",{"$nulls":91},"Hours"]
[]
[]
[]
[]
[]
[]
[{"$nulls":7},"1•18",{"$nulls":7},"What are your company's projected 2010 costs for (1) domestic, (2) foreign, and (3) total worldwide R&D paid for by your company?"]
[]
[]
[]
[{"$nulls":129},"1•25",{"$nulls":7},"Please list the names and titles of the persons who provided data for this section."]
[]
[]
[]
[{"$nulls":15},"NOTE: This question is the 2010 projection for what is reported in Question 1•9, line m."]
[]
[{"$nulls":130},"Name",{"$nulls":55},"Title"]
[]
[]
[{"$nulls":35},"(1)\nDomestic R&D",{"$nulls":26},"(2)\nForeign R&D",{"$nulls":26},"(3)\nTotal worldwide R&D"]
{"$rows_empty":7}
[{"$nulls":35},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou.",{"$nulls":9},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou.",{"$nulls":9},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou."]
[]
[{"$nulls":15},"Projected R&D"]
[]
[]
[{"$nulls":15},"costs for 2010"]
[]
[]
[]
[]
[]
[{"$nulls":7},"1•19",{"$nulls":7},"How much of the projected domestic R&D paid for by your company reported in Question 1•18, column 1, is for projected purchased R&D services and projected payments to collaborators?",{"$nulls":73},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou."]

{"sheet":"pp_16-17","index":6,"n_rows":167,"n_cols":229,"rows_kept":167,"cut":false,"hidden":false,"merged":[[77,140,80,158],[78,137,80,139],[84,129,87,135],[84,137,90,208],[75,188,77,190],[75,191,77,209],[76,160,80,185],[76,211,80,236],[78,188,80,190],[78,191,80,209],[69,160,73,185],[69,211,73,236],[70,140,73,158],[71,137,73,139],[71,188,73,190],[71,191,73,209],[63,160,67,185],[63,211,67,236],[64,140,67,158],[65,137,67,139],[65,188,67,190],[65,191,67,209],[57,160,61,185],[57,211,61,236],[58,140,61,158],[59,137,61,139],[59,188,61,190],[59,191,61,209],[51,160,55,185],[51,211,55,236],[52,140,55,158],[53,137,55,139],[53,188,55,190],[53,191,55,209],[45,160,49,185],[45,211,49,236],[46,140,49,158],[47,137,49,139],[47,188,49,190],[47,191,49,209],[39,160,43,185],[39,211,43,236],[40,140,43,158],[41,137,43,139],[41,188,43,190],[41,191,43,209],[29,137,31,139],[29,140,31,158],[33,160,37,185],[33,211,37,236],[34,140,37,158],[35,137,37,139],[35,188,37,190],[35,191,37,209],[24,228,26,236],[27,160,31,185],[27,211,31,236],[29,188,31,190],[29,191,31,209],[6,128,10,170],[13,129,16,135],[13,137,19,227],[24,160,26,167],[24,168,26,176],[24,177,26,185],[24,211,26,218],[24,219,26,227],[6,6,11,115],[12,6,17,115],[62,7,65,13],[62,15,71,86],[71,89,73,96],[71,97,73,105],[71,106,73,114],[73,15,75,17],[73,18,75,87],[74,89,78,114],[76,15,78,17],[76,18,78,87],[80,89,84,114],[82,15,84,17],[82,18,84,87],[86,15,88,17],[86,18,88,87],[87,89,91,114],[89,18,91,87],[90,15,92,17],[93,15,95,17],[93,18,95,87],[94,89,98,114],[96,18,98,87],[97,15,99,17],[100,15,102,17],[100,18,102,87],[101,89,105,114],[103,18,105,87],[104,15,106,17],[107,15,109,17],[107,18,109,87],[108,89,112,114],[110,18,112,87],[111,15,113,17],[114,15,116,17],[114,18,116,87],[117,15,119,17],[117,18,119,87],[118,89,122,114],[120,15,122,17],[120,18,122,87],[124,15,126,17],[124,18,126,87],[125,89,129,114],[127,15,129,17],[127,18,129,87],[166,19,169,113],[138,89,142,114],[139,18,142,87],[140,15,142,17],[146,15,152,86],[146,89,148,96],[146,97,148,105],[146,106,148,114],[149,89,153,114],[87,211,91,236],[157,7,160,13],[157,15,160,113],[162,19,165,113],[146,7,149,13],[131,15,133,17],[131,18,133,87],[132,89,136,114],[134,15,136,17],[134,18,136,87],[95,228,97,236],[98,211,102,236],[19,6,59,115],[95,129,98,135],[95,137,101,208],[95,211,97,218],[95,219,97,227],[84,211,86,218],[84,219,86,227],[84,228,86,236]],"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[]
[]
[{"$nulls":6},"SECTION 2",{"$nulls":121},"R&D paid for by others"]
[]
[]
[]
[]
[]
[{"$nulls":6},"Financial Schedule 2"]
[{"$nulls":129},"2•4",{"$nulls":7},"Of the amount reported in Question 2•2 (total R&D paid for by others in 2009), what were the costs in the following countries?"]
[]
[]
[]
[]
[]
[{"$nulls":6},"instruction space - possibly use variable printing"]
[]
[]
[]
[]
[{"$nulls":160},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou.",{"$nulls":33},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou."]
[]
[]
[]
[]
[{"$nulls":137},"a.",null,null,"Domestic U.S.",{"$nulls":47},"j.",null,null,"Italy"]
[]
[]
[]
[]
[{"$nulls":140},"United Kingdom"]
[{"$nulls":137},"b.",{"$nulls":50},"k.",null,null,"Japan"]
[]
[]
[]
[]
[{"$nulls":140},"Canada"]
[{"$nulls":137},"c.",{"$nulls":50},"l.",null,null,"Russia"]
[]
[]
[]
[]
[{"$nulls":140},"China"]
[{"$nulls":137},"d.",{"$nulls":50},"m.",null,null,"Singapore"]
[]
[]
[]
[]
[{"$nulls":140},"France"]
[{"$nulls":137},"e.",{"$nulls":50},"n.",null,null,"South Korea"]
[]
[]
[]
[]
[{"$nulls":140},"Germany"]
[{"$nulls":137},"f.",{"$nulls":50},"o.",null,null,"Sweden"]
[]
[]
[{"$nulls":7},"2•1",{"$nulls":7},"What were your company's total worldwide costs (both direct and indirect) in 2009 for the following that were funded, paid for, or reimbursed by others not owned by your company?"]
[]
[{"$nulls":140},"India"]
[{"$nulls":137},"g.",{"$nulls":50},"p.",null,null,"United Kingdom"]
[]
[]
[]
[]
[{"$nulls":140},"Ireland"]
[{"$nulls":89},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou.",{"$nulls":30},"h.",{"$nulls":50},"q.",null,null,"All other"]
[]
[{"$nulls":15},"a.",null,null,"Collaborative research and development that was reimbursed by"]
[]
[{"$nulls":188},"r.",null,null,"Total (equals"]
[{"$nulls":18},"business partners, such as through cost-sharing agreements"]
[{"$nulls":140},"Israel"]
[{"$nulls":137},"i.",{"$nulls":53},"Question 2•2)"]
[]
[]
[]
[{"$nulls":15},"b.",null,null,"R&D paid for by government or private foundation grants"]
[]
[{"$nulls":129},"2•5",{"$nulls":7},"Copy the amount from Question 2•4, line a. This is the total domestic R&D paid for by others in 2009.",{"$nulls":73},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou."]
[]
[{"$nulls":15},"c.",null,null,"Defense research and development services provided to the government"]
[]
[]
[{"$nulls":18},"and/or government contractors"]
[]
[]
[]
[{"$nulls":15},"d.",null,null,"Medical nonclinical research and development services provided"]
[]
[{"$nulls":129},"2•6",{"$nulls":7},"Add 2•4, lines b through q, and enter the result here. This is the total foreign R&D paid for by others in 2009.",{"$nulls":73},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou."]
[{"$nulls":18},"to others not owned by your company"]
[]
[]
[]
[{"$nulls":15},"e.",null,null,"Phase I - III medical clinical trial services provided to others not"]
[]
[]
[{"$nulls":18},"owned by your company (include pass-through costs)"]
[]
[]
[]
[{"$nulls":15},"f.",null,null,"Non-defense custom software development and/or computer systems"]
[]
[]
[{"$nulls":18},"design for others not owned by your company"]
[]
[]
[]
[{"$nulls":15},"g.",null,null,"Developing, producing, and testing prototypes of customers' products"]
[]
[]
[{"$nulls":18},"prior to their introduction to the market (excluding defense-related"]
[]
[]
[{"$nulls":18},"prototyping reported in line c)"]
[]
[]
[]
[{"$nulls":15},"h.",null,null,"R&D your company plans to recoup through indirect charges on"]
[]
[]
[{"$nulls":18},"U.S. federal government contracts (IR&D)"]
[]
[]
[]
[{"$nulls":15},"i.",null,null,"All other research and development services provided to others not"]
[]
[]
[{"$nulls":18},"owned by your company"]
[]
[]
[]
[]
[{"$nulls":18},"Total"]
[{"$nulls":15},"j."]
[]
[]
[]
[]
[]
[{"$nulls":7},"2•2",{"$nulls":7},"Copy the amount from Question 2•1, line j. \nThis is the total R&D paid for by others in 2009.",{"$nulls":73},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou."]
{"$rows_empty":10}
[{"$nulls":7},"2•3",{"$nulls":7},"Was the amount entered in Question 2•2 greater than zero?"]
[]
[]
[]
[]
[{"$nulls":19},"Yes → Continue with Question 2•4"]
[]
[]
[]
[{"$nulls":19},"No → Skip to Section 3 on page __"]

{"sheet":"pp_18-19","index":7,"n_rows":137,"n_cols":229,"rows_kept":137,"cut":false,"hidden":false,"merged":[[72,140,76,156],[72,211,76,236],[74,137,76,139],[74,157,76,209],[66,140,70,156],[66,211,70,236],[68,137,70,139],[68,157,70,209],[60,140,64,156],[60,211,64,236],[62,137,64,139],[62,157,64,209],[54,140,58,156],[54,211,58,236],[56,137,58,139],[56,157,58,209],[48,140,52,156],[48,211,52,236],[50,137,52,139],[50,157,52,209],[42,140,46,156],[42,211,46,236],[44,137,46,139],[44,157,46,209],[33,228,35,236],[36,211,40,236],[38,137,40,139],[38,157,40,209],[28,140,35,156],[33,211,35,218],[33,219,35,227],[36,140,40,156],[7,129,10,135],[18,137,20,227],[21,137,23,227],[24,137,26,227],[7,137,13,227],[136,7,139,13],[136,15,145,86],[136,89,138,96],[136,97,138,105],[139,89,143,114],[136,106,138,114],[117,35,119,60],[117,62,119,87],[117,89,119,114],[123,7,126,13],[123,15,132,86],[123,89,125,96],[123,97,125,105],[123,106,125,114],[126,89,130,114],[111,35,115,60],[111,62,115,87],[111,89,115,114],[113,15,115,17],[113,18,115,33],[98,62,102,87],[98,89,102,114],[104,15,106,17],[104,18,106,33],[105,35,109,60],[105,62,109,87],[105,89,109,114],[107,18,109,33],[94,15,96,17],[94,18,96,33],[97,18,99,33],[98,35,102,60],[100,18,102,33],[81,89,85,114],[87,15,89,17],[87,18,89,33],[88,35,92,60],[88,62,92,87],[88,89,92,114],[90,18,92,33],[80,15,82,17],[80,18,82,33],[81,35,85,60],[81,62,85,87],[83,18,85,33],[67,89,71,114],[73,15,75,17],[73,18,75,33],[74,35,78,60],[74,62,78,87],[74,89,78,114],[76,18,78,33],[66,15,68,17],[66,18,68,33],[67,35,71,60],[67,62,71,87],[69,18,71,33],[53,89,57,114],[59,15,61,17],[59,18,61,33],[60,35,64,60],[60,62,64,87],[60,89,64,114],[62,18,64,33],[52,15,54,17],[52,18,54,33],[53,35,57,60],[53,62,57,87],[55,18,57,33],[39,89,43,114],[45,15,47,17],[45,18,47,33],[46,35,50,60],[46,62,50,87],[46,89,50,114],[48,18,50,33],[38,15,40,17],[38,18,40,33],[39,35,43,60],[39,62,43,87],[41,18,43,33],[32,35,36,60],[32,62,36,87],[32,89,36,114],[34,15,36,17],[34,18,36,33],[23,106,25,114],[25,15,27,17],[25,18,27,33],[26,35,30,60],[26,62,30,87],[26,89,30,114],[28,18,30,33],[23,70,25,78],[23,79,25,87],[23,89,25,96],[23,97,25,105],[23,35,25,42],[23,43,25,51],[23,52,25,60],[23,62,25,69],[7,7,10,13],[7,15,13,105],[15,35,22,60],[15,62,22,87],[15,89,22,114],[86,137,88,139],[86,168,88,209],[78,140,82,156],[78,211,82,236],[80,137,82,139],[80,157,82,209],[84,211,88,236],[85,140,88,167],[92,129,95,135],[92,137,101,208],[102,211,104,218],[102,219,104,227],[117,211,121,236],[118,140,121,168],[119,137,121,139],[119,169,121,209],[111,211,115,236],[112,140,115,209],[113,137,115,139],[102,228,104,236],[105,211,109,236],[106,140,109,209],[107,137,109,139]],"flags":["formulas_cached_only"]}
{"$rows_empty":7}
[{"$nulls":7},"2•7",{"$nulls":7},"How much of the (1) domestic, (2) foreign, and (3) total worldwide R&D paid for by others in 2009 was for each of the following types of costs?",{"$nulls":113},"2•10",{"$nulls":7},"How much of total R&D paid for by others reported in Question 2•2 was for each business code listed or amended or page X of this form?"]
{"$rows_empty":7}
[{"$nulls":35},"(1)\nDomestic R&D",{"$nulls":26},"(2)\nForeign R&D",{"$nulls":26},"(3)\nTotal worldwide R&D"]
[]
[]
[{"$nulls":137},"Allocate R&D that is applicable to more than one business code on a reasonable basis."]
[]
[]
[{"$nulls":137},"Allocation in proportion to operating revenues is acceptable unless some alternative allocation"]
[]
[{"$nulls":35},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou.",{"$nulls":9},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou.",{"$nulls":9},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou."]
[{"$nulls":137},"basis is more appropriate."]
[{"$nulls":15},"a.",null,null,"Gross annual"]
[]
[]
[{"$nulls":18},"payroll",{"$nulls":121},"Business Code\n(see page x)"]
[]
[]
[]
[]
[{"$nulls":211},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou."]
[{"$nulls":15},"b.",null,null,"Fringe benefits"]
[]
[]
[]
[{"$nulls":15},"c.",null,null,"Stock-based",{"$nulls":118},"a.",{"$nulls":19}," "]
[]
[]
[{"$nulls":18},"compensation"]
[]
[]
[{"$nulls":137},"b.",{"$nulls":19}," "]
[{"$nulls":15},"d.",null,null,"Temporary"]
[]
[]
[{"$nulls":18},"staffing"]
[]
[{"$nulls":137},"c.",{"$nulls":19}," "]
[]
[{"$nulls":15},"e.",null,null,"Expensed"]
[]
[]
[{"$nulls":18},"equipment"]
[{"$nulls":137},"d.",{"$nulls":19}," "]
[]
[]
[{"$nulls":15},"f.",null,null,"Materials and"]
[]
[]
[{"$nulls":18},"supplies",{"$nulls":118},"e.",{"$nulls":19}," "]
[]
[]
[]
[{"$nulls":15},"g.",null,null,"Lease and"]
[]
[{"$nulls":137},"f.",{"$nulls":19}," "]
[{"$nulls":18},"rental payments"]
[]
[]
[]
[{"$nulls":15},"h.",null,null,"Depreciation &"]
[{"$nulls":137},"g.",{"$nulls":19}," "]
[]
[{"$nulls":18},"amortization"]
[]
[]
[]
[{"$nulls":15},"i.",null,null,"Payments to",{"$nulls":118},"h.",{"$nulls":19}," "]
[]
[]
[{"$nulls":18},"collaborators"]
[]
[{"$nulls":140},"Total (equals Question 2•2)"]
[{"$nulls":137},"i.",{"$nulls":30}," "]
[{"$nulls":15},"j.",null,null,"Purchased R&D"]
[]
[]
[{"$nulls":18},"services"]
[]
[{"$nulls":129},"2•11",{"$nulls":7},"How much of the domestic R&D performed by your company that was paid for by others reported in Question 2•9 was performed under the following types of agreements?"]
[]
[{"$nulls":15},"k.",null,null,"All other"]
[]
[]
[{"$nulls":18},"purchased"]
[]
[]
[{"$nulls":18},"services"]
[]
[{"$nulls":211},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou."]
[]
[{"$nulls":15},"l.",null,null,"All other"]
[]
[{"$nulls":140},"Contracts (include direct or prime contracts and subcontracts)"]
[{"$nulls":18},"costs",{"$nulls":118},"a."]
[]
[]
[]
[]
[{"$nulls":140},"Grants, reimbursement, and all other agreements"]
[{"$nulls":15},"m.",null,null,"Total",{"$nulls":118},"b."]
[]
[]
[]
[{"$nulls":35},"Total equals Question 2•5",{"$nulls":26},"Total equals Question 2•6",{"$nulls":26},"Total equals Question 2•2"]
[{"$nulls":140},"Total (equals Question 2•9)"]
[{"$nulls":137},"c.",{"$nulls":31}," "]
[]
[]
[]
[{"$nulls":7},"2•8",{"$nulls":7},"Add 2•7, lines i and j for column 1 and enter the result here. \nThis is domestic R&D performed by others that was paid for by others (e.g. subcontracted/passed-through R&D costs)",{"$nulls":73},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou."]
{"$rows_empty":12}
[{"$nulls":7},"2•9",{"$nulls":7},"Subtract 2•8 from 2•2 and enter the result here. \nThis is the domestic R&D performed by your company that was paid for by others.",{"$nulls":73},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou."]

{"sheet":"pp_20-21","index":8,"n_rows":166,"n_cols":229,"rows_kept":166,"cut":false,"hidden":false,"merged":[[7,7,10,13],[18,15,20,105],[21,15,23,105],[7,15,13,105],[15,15,17,105],[24,15,26,105],[27,15,29,105],[30,15,32,105],[35,89,37,96],[35,97,37,105],[35,106,37,114],[38,89,42,114],[40,15,42,17],[40,18,42,75],[40,76,42,87],[44,89,48,114],[46,15,48,17],[46,18,48,75],[46,76,48,87],[50,89,54,114],[52,15,54,17],[52,18,54,87],[56,89,60,114],[58,15,60,17],[58,18,60,87],[62,89,66,114],[64,15,66,17],[64,18,66,87],[68,89,72,114],[70,15,72,17],[70,18,72,87],[76,15,78,17],[76,18,78,87],[88,106,90,114],[91,89,95,114],[88,89,90,96],[88,97,90,105],[80,89,84,114],[82,15,84,17],[82,18,84,87],[74,89,78,114],[101,7,104,13],[101,15,110,86],[88,7,91,13],[88,15,97,86],[111,89,113,96],[111,97,113,105],[111,106,113,114],[114,89,118,114],[115,18,118,87],[116,15,118,17],[120,89,124,114],[121,18,124,87],[122,15,124,17],[126,89,130,114],[127,18,130,87],[128,15,130,17],[132,89,136,114],[133,18,136,87],[134,15,136,17],[138,89,142,114],[139,18,142,87],[140,15,142,17],[144,89,148,114],[145,18,148,87],[146,15,148,17],[150,89,154,114],[151,18,154,87],[152,15,154,17],[156,89,160,114],[157,18,160,52],[158,15,160,17],[158,53,160,87],[7,228,9,236],[10,211,14,236],[20,129,23,135],[20,137,29,208],[7,129,10,135],[7,137,16,208],[7,211,9,218],[7,219,9,227],[30,211,32,218],[30,219,32,227],[30,228,32,236],[33,211,37,236],[34,140,37,209],[35,137,37,139],[39,211,43,236],[40,140,43,209],[41,137,43,139],[45,211,49,236],[46,140,49,209],[47,137,49,139],[51,211,55,236],[52,140,55,209],[53,137,55,139],[71,129,74,135],[57,211,61,236],[58,140,61,209],[59,137,61,139],[63,211,67,236],[64,140,67,174],[65,137,67,139],[65,175,67,209],[71,137,80,208],[71,211,73,218],[113,192,115,200],[113,201,115,209],[105,211,112,236],[113,211,115,218],[113,219,115,227],[113,228,115,236],[113,157,115,164],[113,165,115,173],[113,174,115,182],[113,184,115,191],[122,157,126,182],[122,184,126,209],[122,211,126,236],[124,137,126,155],[128,157,132,182],[128,184,132,209],[128,211,132,236],[130,137,132,155],[134,157,138,182],[134,184,138,209],[134,211,138,236],[136,137,138,155],[140,157,144,182],[140,184,144,209],[140,211,144,236],[142,137,144,155],[84,129,87,135],[84,137,103,236],[105,157,112,182],[105,184,112,209],[165,128,167,237],[116,157,120,182],[116,184,120,209],[116,211,120,236],[118,137,120,155],[158,157,162,182],[158,184,162,209],[152,184,156,209],[152,211,156,236],[154,137,156,155],[158,211,162,236],[160,137,162,155],[152,157,156,182],[71,219,73,227],[71,228,73,236],[74,211,78,236],[146,157,150,182],[146,184,150,209],[146,211,150,236],[148,137,150,155]],"flags":["formulas_cached_only"]}
{"$rows_empty":7}
[{"$nulls":7},"2•12",{"$nulls":7},"How much of the domestic R&D performed by your company that was paid for by others reported in Question 2•9 was paid for by each of the following?",{"$nulls":113},"2•15",{"$nulls":7},"Copy the amount from Question 2•12, line c. \nThis is domestic R&D performed by others that was paid for by the U.S. federal government",{"$nulls":73},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou."]
{"$rows_empty":7}
[{"$nulls":15},"If your company is a subcontractor or subgrantee, report the original source of funds."]
[]
[]
[]
[]
[{"$nulls":129},"2•16",{"$nulls":7},"How much of the R&D paid for by the U.S. federal government reported in Question 2•15 was paid for by the following agencies?"]
[{"$nulls":15},"Example: Company Sub Inc. performs custom software development for a large defense"]
[]
[]
[{"$nulls":15},"company as a subcontractor on a contract with the U.S. Dept. of Defense. Even though"]
[]
[]
[{"$nulls":15},"Sub Inc. is working directly for the defense company, it reports the cost of this software"]
[]
[]
[{"$nulls":15},"development in line x because the Dept. of Defense was the original source of funds.",{"$nulls":195},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou."]
[]
[]
[]
[{"$nulls":140},"Department of Defense"]
[{"$nulls":89},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou.",{"$nulls":30},"a."]
[]
[]
[]
[]
[{"$nulls":15},"a.",null,null,"Other companies located inside the United States",{"$nulls":57}," ",{"$nulls":63},"Department of Energy"]
[{"$nulls":137},"b."]
[]
[]
[]
[]
[{"$nulls":15},"b.",null,null,"Other companies located outside the United States",{"$nulls":57}," ",{"$nulls":63},"National Aeronautics and Space Administration"]
[{"$nulls":137},"c."]
[]
[]
[]
[]
[{"$nulls":15},"c.",null,null,"U.S. federal government agencies or laboratories",{"$nulls":121},"National Institutes of Health"]
[{"$nulls":137},"d."]
[]
[]
[]
[]
[{"$nulls":15},"d.",null,null,"U.S. state government agencies or laboratories",{"$nulls":121},"All other"]
[{"$nulls":137},"e."]
[]
[]
[]
[]
[{"$nulls":15},"e.",null,null,"Foreign government agencies or laboratories",{"$nulls":121},"Total (equals Question 2•15)"]
[{"$nulls":137},"h.",{"$nulls":37}," "]
[]
[]
[]
[]
[{"$nulls":15},"f.",null,null,"All other organizations inside the United States"]
[{"$nulls":129},"2•17",{"$nulls":7},"Subtract 2•15 from 2•9 and enter the result here. \nThis is the domestic R&D performed by your company that was paid for by nonfederal sources.",{"$nulls":73},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou."]
[]
[]
[]
[]
[{"$nulls":15},"g.",null,null,"All other organizations outside the United States"]
[]
[]
[]
[]
[]
[{"$nulls":15},"h.",null,null,"Total (equals Question 2•9)"]
[]
[{"$nulls":129},"2•18",{"$nulls":7},"How much of the following three amounts was performed in each state (including D.C.):\n(1) Domestic R&D paid for by the U.S. federal government reported in Question 2•15\n(2) Domestic R&D paid for by nonfederal sources reported in Question 2•17\n(3) Total domestic R&D performed by your company that was paid for by others\n      reported in Question 2•9"]
[]
[]
[]
[{"$nulls":7},"2•13",{"$nulls":7},"Add 2•12, lines a and b and enter the result here. \nThis is domestic R&D performed by others that was paid for by other companies",{"$nulls":73},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou."]
{"$rows_empty":12}
[{"$nulls":7},"2•14",{"$nulls":7},"How much of the R&D paid for by other companies reported in Question 2•13 was paid for by the following types of companies?"]
[]
[]
[]
[{"$nulls":157},"(1)\nFederal",{"$nulls":26},"(2)\nNonfederal",{"$nulls":26},"(3)\nTotal"]
[]
[]
[]
[]
[]
[{"$nulls":89},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou."]
[]
[{"$nulls":157},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou.",{"$nulls":9},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou.",{"$nulls":9},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou."]
[]
[{"$nulls":18},"Aerospace"]
[{"$nulls":15},"a."]
[]
[{"$nulls":137},"Alabama"]
[]
[]
[{"$nulls":18},"Computer products"]
[{"$nulls":15},"b."]
[]
[{"$nulls":137},"Alaska"]
[]
[]
[{"$nulls":18},"Electronic products"]
[{"$nulls":15},"c."]
[]
[{"$nulls":137},"Arizona"]
[]
[]
[{"$nulls":18},"Motor vehicles"]
[{"$nulls":15},"d."]
[]
[{"$nulls":137},"Arkansas"]
[]
[]
[{"$nulls":18},"Petrochemicals"]
[{"$nulls":15},"e."]
[]
[{"$nulls":137},"California"]
[]
[]
[{"$nulls":18},"Pharmaceuticals"]
[{"$nulls":15},"f."]
[]
[{"$nulls":137},"Colorado"]
[]
[]
[{"$nulls":18},"All other companies"]
[{"$nulls":15},"g."]
[]
[{"$nulls":137},"Connecticut"]
[]
[]
[{"$nulls":18},"Total (equals Question 2•13)"]
[{"$nulls":15},"h.",{"$nulls":37}," "]
[]
[{"$nulls":137},"Delaware"]
[]
[]
[]
[]
[{"$nulls":128},"Question continues on next page"]

{"sheet":"pp_22-23","index":9,"n_rows":168,"n_cols":229,"rows_kept":168,"cut":false,"hidden":false,"merged":[[20,106,22,114],[7,7,10,13],[7,15,10,105],[12,35,19,60],[12,62,19,87],[12,89,19,114],[20,35,22,42],[20,43,22,51],[20,52,22,60],[20,62,22,69],[20,70,22,78],[20,79,22,87],[20,89,22,96],[20,97,22,105],[25,15,27,34],[29,35,33,60],[29,62,33,87],[29,89,33,114],[31,15,33,33],[23,35,27,60],[23,62,27,87],[23,89,27,114],[35,35,39,60],[35,62,39,87],[35,89,39,114],[37,15,39,33],[41,35,45,60],[41,62,45,87],[41,89,45,114],[43,15,45,33],[47,35,51,60],[47,62,51,87],[47,89,51,114],[49,15,51,33],[53,35,57,60],[53,62,57,87],[53,89,57,114],[55,15,57,33],[59,35,63,60],[59,62,63,87],[59,89,63,114],[61,15,63,33],[65,35,69,60],[65,62,69,87],[65,89,69,114],[67,15,69,33],[71,35,75,60],[71,62,75,87],[71,89,75,114],[73,15,75,33],[77,35,81,60],[77,62,81,87],[77,89,81,114],[79,15,81,33],[83,35,87,60],[83,62,87,87],[83,89,87,114],[85,15,87,33],[89,35,93,60],[89,62,93,87],[89,89,93,114],[91,15,93,33],[95,35,99,60],[95,62,99,87],[95,89,99,114],[97,15,99,33],[101,35,105,60],[101,62,105,87],[101,89,105,114],[103,15,105,33],[107,35,111,60],[107,62,111,87],[107,89,111,114],[109,15,111,33],[113,35,117,60],[113,62,117,87],[113,89,117,114],[115,15,117,33],[119,35,123,60],[119,62,123,87],[119,89,123,114],[121,15,123,33],[125,35,129,60],[125,62,129,87],[125,89,129,114],[127,15,129,33],[131,35,135,60],[131,62,135,87],[131,89,135,114],[133,15,135,33],[137,35,141,60],[137,62,141,87],[137,89,141,114],[139,15,141,33],[143,35,147,60],[143,62,147,87],[143,89,147,114],[145,15,147,33],[149,35,153,60],[149,62,153,87],[149,89,153,114],[151,15,153,33],[155,35,159,60],[155,62,159,87],[155,89,159,114],[157,15,159,33],[161,35,165,60],[161,62,165,87],[161,89,165,114],[163,15,165,33],[167,6,169,115],[7,129,10,135],[7,137,10,227],[12,157,19,182],[12,184,19,209],[12,211,19,236],[20,157,22,164],[20,165,22,173],[20,174,22,182],[20,184,22,191],[20,228,22,236],[23,157,27,182],[23,184,27,209],[23,211,27,236],[20,192,22,200],[20,201,22,209],[20,211,22,218],[20,219,22,227],[25,137,27,155],[29,157,33,182],[29,184,33,209],[29,211,33,236],[31,137,33,155],[35,157,39,182],[35,184,39,209],[35,211,39,236],[37,137,39,155],[41,157,45,182],[41,184,45,209],[41,211,45,236],[43,137,45,155],[47,157,51,182],[47,184,51,209],[47,211,51,236],[49,137,51,155],[53,157,57,182],[53,184,57,209],[53,211,57,236],[55,137,57,155],[59,157,63,182],[59,184,63,209],[59,211,63,236],[61,137,63,155],[65,157,69,182],[65,184,69,209],[65,211,69,236],[67,137,69,155],[71,157,75,182],[71,184,75,209],[71,211,75,236],[73,137,75,155],[77,157,81,182],[77,184,81,209],[77,211,81,236],[79,137,81,155],[83,157,87,182],[83,184,87,209],[83,211,87,236],[85,137,87,155],[89,157,93,182],[89,184,93,209],[89,211,93,236],[91,137,93,155],[95,157,99,182],[95,184,99,209],[95,211,99,236],[97,137,99,155],[101,157,105,182],[101,184,105,209],[101,211,105,236],[103,137,105,155],[107,157,111,182],[107,184,111,209],[107,211,111,236],[109,137,111,155],[113,157,117,182],[113,184,117,209],[113,211,117,236],[115,137,117,155],[119,157,123,182],[119,184,123,209],[119,211,123,236],[121,137,123,155],[125,157,129,182],[125,184,129,209],[125,211,129,236],[127,137,129,155],[139,137,141,155],[131,157,135,182],[131,184,135,209],[131,211,135,236],[133,137,135,155],[143,157,145,182],[143,184,145,209],[143,211,145,236],[137,157,141,182],[137,184,141,209],[137,211,141,236]],"flags":["formulas_cached_only"]}
{"$rows_empty":7}
[{"$nulls":7},"2•18",{"$nulls":7},"(Continued)",{"$nulls":113},"2•18",{"$nulls":7},"(Continued)"]
[]
[]
[]
[]
[{"$nulls":35},"(1)\nFederal",{"$nulls":26},"(2)\nNonfederal",{"$nulls":26},"(3)\nTotal",{"$nulls":67},"(1)\nFederal",{"$nulls":26},"(2)\nNonfederal",{"$nulls":26},"(3)\nTotal"]
{"$rows_empty":7}
[{"$nulls":35},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou.",{"$nulls":9},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou.",{"$nulls":9},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou.",{"$nulls":50},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou.",{"$nulls":9},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou.",{"$nulls":9},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou."]
[]
[]
[]
[]
[{"$nulls":15},"District of Columbia",{"$nulls":121},"New York"]
[]
[]
[]
[]
[]
[{"$nulls":15},"Florida",{"$nulls":121},"North Carolina"]
[]
[]
[]
[]
[]
[{"$nulls":15},"Georgia",{"$nulls":121},"North Dakota"]
[]
[]
[]
[]
[]
[{"$nulls":15},"Hawaii",{"$nulls":121},"Ohio"]
[]
[]
[]
[]
[]
[{"$nulls":15},"Idaho",{"$nulls":121},"Oklahoma"]
[]
[]
[]
[]
[]
[{"$nulls":15},"Illinois",{"$nulls":121},"Oregon"]
[]
[]
[]
[]
[]
[{"$nulls":15},"Indiana",{"$nulls":121},"Pennsylvania"]
[]
[]
[]
[]
[]
[{"$nulls":15},"Iowa",{"$nulls":121},"Rhode Island"]
[]
[]
[]
[]
[]
[{"$nulls":15},"Kansas",{"$nulls":121},"South Carolina"]
[]
[]
[]
[]
[]
[{"$nulls":15},"Kentucky",{"$nulls":121},"South Dakota"]
[]
[]
[]
[]
[]
[{"$nulls":15},"Louisiana",{"$nulls":121},"Tennessee"]
[]
[]
[]
[]
[]
[{"$nulls":15},"Maine",{"$nulls":121},"Texas"]
[]
[]
[]
[]
[]
[{"$nulls":15},"Maryland",{"$nulls":121},"Utah"]
[]
[]
[]
[]
[]
[{"$nulls":15},"Massachusetts",{"$nulls":121},"Vermont"]
[]
[]
[]
[]
[]
[{"$nulls":15},"Michigan",{"$nulls":121},"Virginia"]
[]
[]
[]
[]
[]
[{"$nulls":15},"Minnesota",{"$nulls":121},"Washington"]
[]
[]
[]
[]
[]
[{"$nulls":15},"Mississippi",{"$nulls":121},"West Virginia"]
[]
[]
[]
[]
[]
[{"$nulls":15},"Missouri",{"$nulls":121},"Wisconsin"]
[]
[]
[]
[]
[]
[{"$nulls":15},"Montana",{"$nulls":121},"Wyoming"]
[]
[]
[]
[]
[]
[{"$nulls":15},"Nebraska",{"$nulls":121},"Total"]
[]
[]
[]
[{"$nulls":157},"Total equals Question 2•15",{"$nulls":26},"Total equals Question 2•17",{"$nulls":26},"Total equals Question 2•9"]
[]
[{"$nulls":15},"Nevada"]
[]
[]
[]
[]
[]
[{"$nulls":15},"New Hampshire"]
[]
[]
[]
[]
[]
[{"$nulls":15},"New Jersey"]
[]
[]
[]
[]
[]
[{"$nulls":15},"New Mexico"]
[]
[]
[]
[{"$nulls":6},"Question continues on next page"]

{"sheet":"pp_24-25","index":10,"n_rows":123,"n_cols":129,"rows_kept":123,"cut":false,"hidden":false,"merged":[[137,7,140,58],[137,63,140,114],[129,7,132,58],[129,63,132,114],[133,7,136,58],[133,63,136,114],[125,7,128,58],[125,63,128,114],[122,64,124,74],[116,7,119,13],[116,15,119,113],[122,8,124,18],[105,107,107,114],[108,107,112,114],[74,6,78,37],[81,7,84,13],[81,15,84,113],[86,19,89,113],[98,69,101,80],[99,56,101,62],[105,7,108,13],[105,15,108,86],[51,7,54,13],[51,15,60,113],[62,15,67,87],[62,89,64,96],[62,97,64,105],[62,106,64,114],[65,89,69,114],[40,15,45,87],[40,89,42,96],[40,97,42,105],[40,106,42,114],[43,89,47,114],[95,69,97,80],[98,63,101,68],[21,15,26,87],[32,7,35,13],[32,15,38,113],[90,19,93,113],[21,89,23,96],[21,97,23,105],[21,106,23,114],[24,89,28,114],[99,26,101,32],[95,33,97,38],[95,39,97,50],[95,63,97,68],[98,33,101,38],[98,39,101,50],[25,128,38,236],[6,6,10,59],[13,7,16,13],[13,15,19,113]],"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[]
[]
[{"$nulls":6},"Projected R&D paid for by others in 2010"]
[]
[]
[]
[]
[]
[]
[{"$nulls":7},"2•19",{"$nulls":7},"What are your company's projected 2010 costs for R&D that will be paid for by others?"]
{"$rows_empty":7}
[{"$nulls":15},"NOTE: This question is the 2010 projection for what is reported in \nQuestion 2•2.",{"$nulls":73},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou."]
[]
[]
[]
[{"$nulls":128},"Section 3\n\nManagement and Strategy of R&D"]
[]
[]
[]
[]
[]
[]
[{"$nulls":7},"2•20",{"$nulls":7},"How much of the projected costs in 2010 for R&D that will be paid for by others reported in Question 2•19 will be performed by your company in the United States?"]
{"$rows_empty":7}
[{"$nulls":15},"NOTE: This question is the 2010 projection for what is reported in \nQuestion 2•9.",{"$nulls":73},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou."]
{"$rows_empty":10}
[{"$nulls":7},"2•21",{"$nulls":7},"How much of the projected costs in 2010 for domestic R&D performed by your company that will be paid for by others reported in Question 2•20 will be paid for by the U.S. federal government?"]
{"$rows_empty":10}
[{"$nulls":15},"NOTE: This question is the 2010 projection for what is reported in \nQuestion 2•15.",{"$nulls":73},"$Bil.",{"$nulls":7},"Mil.",{"$nulls":8},"Thou."]
{"$rows_empty":11}
[{"$nulls":6},"Reporting Information"]
[]
[]
[]
[]
[]
[]
[{"$nulls":7},"2•22",{"$nulls":7},"Is the information in this section reported on a calendar year basis?"]
[]
[]
[]
[]
[{"$nulls":19},"Yes"]
[]
[]
[]
[{"$nulls":19},"No → Enter the time period covered below:"]
[]
[]
[]
[]
[{"$nulls":33},"(MM)",{"$nulls":5},"(YYYY)",{"$nulls":23},"(MM)",{"$nulls":5},"(YYYY)"]
[]
[]
[]
[{"$nulls":26},"From",{"$nulls":29},"To"]
[]
[]
[]
[]
[]
[{"$nulls":7},"2•23",{"$nulls":7},"Approximately how long did it take to complete this section?",{"$nulls":91},"Hours"]
{"$rows_empty":10}
[{"$nulls":7},"2•24",{"$nulls":7},"Please list the names and titles of the persons who provided data for this section."]
[]
[]
[]
[]
[]
[{"$nulls":8},"Name",{"$nulls":55},"Title"]

{"sheet":"BusinessCodes","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"blank","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}