{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Document Instructions","Requester Information","SP & PG Requests","Assignment Operations","Request Settings & Prep","SPN Requests Import Prep","PGN Requests Import Prep","Mapping Requests Import Prep"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":89,"comments":2,"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":"Document Instructions","index":0,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[5,3,5,4],[1,2,1,5],[3,2,3,5],[14,2,14,5],[0,2,0,5],[11,2,11,5],[13,2,13,5],[12,2,12,5]]}
[null,null,{"$f":"'SP & PG Requests'!A1","v":"SAE J1939 Request Spreadsheet [Add New DA Content] (v7.0.3)"}]
[null,null,"Using this Workbook for New Content Requests"]
[]
[null,null,"The \"SAE J1939 Request Spreadsheet [Add New DA Content]\" workbook is used for submitting requests for new SPs and PGs in a format similar to the SAE J1939DA publication.  This workbook supports requesting new SPNs and PGNs in which the SP Description, PG Description, SP Reference, and PG Reference may include cross references to other new SPNs and/or new PGNS being requested in the same worksheet.\n\nThe columns and order match the columns and order of the J1939DA 'SPs & PGs' worksheet beginning February 2024. \n\nRequesters shall only edit the 'Requester Information' & 'SP & PG Requests' worksheets when preparing SPs and PGs requests."]
[]
[null,null,null,"Column Heading Color Legend (SP & PG Requests)"]
[null,null,null,"Light Green","Required by Requester for PG and/or SP Request"]
[null,null,null,"Light Orange","Optional by Requester for PG and/or SP Request"]
[null,null,null,"Light Blue","Assigned by SAE Committee"]
[null,null,null,"Grey","Not Required"]
[]
[null,null,"Instructions Document:  J1939-Request-Spreadsheet [Add New DA Content]-v7.0-Instructions.pdf\n\n"]
[null,null,"The instructions document can be downloaded from the SAE Standard Works using the URL provided below.  The file is found under Public Resources in the Work Area for the Truck Bus Control and Communications Network Committee.\n\n"]
[null,null,"https://standardsworks.sae.org/standards-committees/truck-bus-control-communications-network-committee#resources"]

{"sheet":"Requester Information","index":1,"n_rows":46,"n_cols":2,"rows_kept":46,"cut":false,"hidden":false,"merged":[[45,0,45,1],[46,0,46,1],[39,0,39,1],[40,0,40,1],[41,0,41,1],[42,0,42,1],[43,0,43,1],[44,0,44,1],[38,0,38,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[35,0,35,1],[36,0,36,1],[37,0,37,1],[0,0,0,1],[26,0,26,1],[1,0,1,1],[2,0,2,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1]]}
[{"$f":"'SP & PG Requests'!A1","v":"SAE J1939 Request Spreadsheet [Add New DA Content] (v7.0.3)"}]
["Requester Information"]
["Enter your e-mail address!  Email is the primary means used by the Committee to communicate with you.  Even if your information is on the Committee roster, please enter it again here so we can automate our mailings."]
["Name","Henrik Lundkvist"]
["Company","SINTEF AS"]
["Address","Klæbuveien 153"]
["City","Trondheim"]
["State/Province","Trondelag"]
["Country","Norway"]
["Postal Code",7031]
["Phone",4741337009]
["Fax"]
["E-mail","henrik.lundkvist@sintef.no"]
["Request Date (M/D/YY)","2024-04-08"]
["Proposed Discussion Group","Hybrid Discussion"]
["Request Subject\n  · request content overview\n  · notes to SAE J1939 Committee\n  · list of file(s) containing supporting information\n","The request is to add parameters for fuel cell systems.\nAdd a parameter group for voltage limits. For fuel cell modules that have DCDC converter included, the voltage limits are needed to avoid damaging other components.\n\nAdd HVIL in Fuel Cell System Operating state (2 bits) in the Fuel Cell System Operating State. \n\nWe also propose to add pressure information in the Hydrogen Information PG since some modules may have pressure sensors."]
[]
["File Name & Request Submit Instructions"]
["For complete details on the J1939 Request process, refer to the 'J1939 Truck & Bus Request Processing Guidelines' document on the SAE Works web site."]
["Submitting the Request Document"]
["Email this Request Form and any other supporting documents to the J1939 Committee using the email address below."]
["Email address:  saej1939@sae.org"]
[]
["Posting and Sponsoring the Request – Requester Action"]
["1.      Create a folder for your request on the SAE Standard Works site.  To get access to SAE Standard Works site, email a request to the SAE Administrator at the Committee using the email address listed above."]
["2.      Championing your request through the approval process.  Please refer to the J1939 Request Process Guidelines document for suggestions on how to do this."]
[]
["Document File Name Format"]
["Please use the following file naming format to your Request Form file."]
["1.      Original Request File:  Use file name format is YYYYMMDDii_x, where:"]
["n  ‘YYYY’  = Year (e.g. 2022)"]
["n  ‘MM’  = Month (e.g. 01 = January, 02 = February, etc)"]
["n  ‘DD’  = Day of Month"]
["n  ‘ii’  = Requestor’s initials"]
["n  ‘x’  = Count of this Request Document among all submitted that day by Requestor"]
["For example 20221103TH_1.xlsm - first request submitted on November 3rd, 2022, by person with initials TH.  If two requests were submitted on this same day by the same person, the file name for the second request document would be 20221103TH_2.xlsm."]
[]
["2.      Updates to Request File: Use the same base file name (YYYYMMDDii_x) as the Original Request and add an \"_R#\" extension to the base name, where '#' is the number of revisions made to date."]
["Original Version:   20221103TH_1.xlsm"]
["1st Update:           20221103TH_1_R1.xlsm"]
["Next Update:        20221103TH_1_R2.xlsm"]
[]
["3.      Support Documents:  Use the same base file name as the Original Request and with an \"_SUP\" extension.  Support documents may be included if you feel more detailed text, supporting graphs, diagrams or data would be helpful and should be submitted along with your request."]
["Request File name:                         20221103TH_1.doc"]
["Support Document:                         20221103TH_1_SUP.doc"]
["1st Update to Support Document:  20221103TH_1_SUP_R1.doc"]

{"sheet":"SP & PG Requests","index":2,"n_rows":9,"n_cols":48,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,3],[2,41,2,43],[2,38,2,40],[2,46,2,47],[2,44,2,45],[1,0,1,3]]}
["SAE J1939 Request Spreadsheet [Add New DA Content] (v7.0.3)",null,null,null,"SLOTs through November 2023"]
["SP and PG Requests",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,null,null,null,null,null,null,null,"Refer to 'Document Instructions' for help on validation issues and cross reference details."]
["Refer to 'Document Instructions' for help and color legend.",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,null,null,null,null,null,null,null,null,"PG Description: Cross Reference Updates\n(blank if no cross references to update)",null,null,"SP Description: Cross Reference Updates\n(blank if no cross references to update)",null,null,"PG Reference:  Cross Reference Updates\n(blank if no cross references to update)",null,"SP Reference: Cross Reference Updates\n(blank if no cross references to update)"]
["Add Action \nfor Row\n(right-click menu)","Requested \nPG Type\n(right-click menu)","PGN","PG Label","PG Acronym","PG Description\n(cross-reference support)","PDU Type","PGN Page","PG Data Length Class\n(right-click menu)","PG Data Minimum Length","PG Data Length Constraint","PG Data Highest Assigned Byte","Transmission Rate","Default Priority","PG Reference\n(cross-reference support)","SP Position in PG","SP Start Bit","SPN","SP Label","SP Description\n(cross-reference support)","SP Length","Scaling","Offset","Data Range","Operational Range","Units","SLOT Identifier\n(right-click menu)","SLOT Name\n(right-click menu)","SP Type\n(right-click menu)","SP Reference\n(cross-reference support)","Scale Factor\n(value only)","Offset\n(value only)","Range Maximum\n(value only)","Length Minimum\n(bits)","Length Maximum\n(bits)","SP Document","PG Document","Data Integrity/Validation Issues","PG Description\n(with REFs Updated)","Update Summary","Reference Replacements List\n(expand row to see all data)","SP Description (with REFs Updated)","Update Summary\n(expand row to see all data)","Reference Replacements List\n(expand row to see all data)","PG Reference\n (with REFs Updated)","Update Summary","SP Reference\n (with REFs Updated)","Update Summary"]
[" (J1939DA) New SP to new PG","PDU2 Slow",null,"Fuel Cell System Voltage Limit Command","FCSVLC","This message is sent to the fuel cell system to limit the voltage provided by the fuel cell system.  ",null,null,"Fixed Extendable",8,null,null,"On request",6,null,"1",1.1000000000000001,null,"Fuel Cell System Nominal Voltage","This is the nominal operating voltage of the fuel cell system, e.g. “300V” or “600V”.\n","2 bytes","0.05 V per bit","0 V","0 to 3 212.75 V",null,"V",80,"SAEev01","Measured",null,0.05,0,3212.75,16,16]
[" (J1939DA) New SP to new PG","PDU2 Slow",null,"Fuel Cell System Voltage Limit Command","FCSVLC","This message is sent to the fuel cell system to limit the voltage provided by the fuel cell system.  ",null,null,"Fixed Extendable",8,null,null,"On request",6,null,"3",3.1,null,"Fuel Cell System Minimum Operating Voltage","This is the minimum voltage level for the fuel cell system. \n\n","2 bytes","0.05 V per bit","0 V","0 to 3 212.75 V",null,"V",80,"SAEev01","Measured",null,0.05,0,3212.75,16,16]
[" (J1939DA) New SP to new PG","PDU2 Slow",null,"Fuel Cell System Voltage Limit Command","FCSVLC","This message is sent to the fuel cell system to limit the voltage provided by the fuel cell system.  ",null,null,"Fixed Extendable",8,null,null,"On request",6,null,"5",5.0999999999999996,null,"Fuel Cell System Maximum Operating Voltage","This is the maximum voltage level for the fuel cell system. ","2 bytes","0.05 V per bit","0 V","0 to 3 212.75 V",null,"V",80,"SAEev01","Measured",null,0.05,0,3212.75,16,16]
["(J1939DA) New SP to existing PG","PDU2 Fast",null,"Fuel Cell System Operating State","FCSOS","Operating State of Fuel Cell System",null,null,"Fixed Extendable",8,null,null,"100 ms",6,null,"5","5,4",null,"Fuel Cell System HVIL status","Reports the High Voltage Interlock Loop (HVIL) state.\r\n\r\n00b = HVIL Closed\r\n01b = HVIL Open\r\n10b = Error\r\n11b = Not Available","2 bits","4 states","0","0 to 3",null,null,87,"SAEbs02","Measured",null,1,0,3,2,2]
["(J1939DA) New SP to existing PG","PDU2 Fast",null,"Hydrogen Information","H2INF","Contains parameters intended to be transmitted by a hydrogen sensor.",null,null,"Fixed Extendable",8,null,null,"100 ms",3,null,"5","5,1",null,"Gas Pressure","Pressure measured in gas leakage detection point. Measured media is of the gas, meaning it could be air, inert gas, fuel air mixture or charge air mixture, depending on the failure mode detected.","1 byte","4 kPa per bit","0 kPa","0 to 1 000 kPa","0 to 100%","kPa",47,"SAEpr10","Measured",null,4,0,1000,8,8]

{"sheet":"Assignment Operations","index":3,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,0,0,4],[15,2,15,3]]}
[{"$f":"'SP & PG Requests'!A1","v":"SAE J1939 Request Spreadsheet [Add New DA Content] (v7.0.3)"}]
["SPN & PGN Assignment Operations (for Administration use)"]
[]
[null,"Step 1:  Verify request is clear of errors (except for New SLOT requests)"]
[]
[]
[]
[]
[null,"Step 2:  Set path to J1939 database"]
[]
[null,null,"Database File",null,"C:\\j1939\\saeJ1939db.mdb"]
[]
[null,"Step 3:  Make the ID assignments"]
[]
[]
[null,null,"Assignment Activity"]

{"sheet":"Request Settings & Prep","index":4,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
[{"$f":"'SP & PG Requests'!A1","v":"SAE J1939 Request Spreadsheet [Add New DA Content] (v7.0.3)"}]
["Request Import Preparation (for Administration use)"]
[]
[null,"Step 1:  Set request values"]
[null,"Request ID",2023041511,null,"(RequestID to which the imported items are to be associated)"]
[null,"Date Modified","2023-10-20",null,"(Date to use for the Date Modified)"]
[null,"Document","J1939-71",null,"(Document to use for the SP Document and PG Document) (default: J1939-71)"]
[]
[]
[]
[]
[]
[]
[null,"Instructions:","Step 1:",null,"Update default/static settings above"]
[null,null,"Step 2:",null,"Make all SPN and PGN assignments"]
[null,null,"Step 3:",null,"Click the 'Step 3' button to update cross reference placeholders and validate data on 'SP & PG Requests' sheet"]
[null,null,"Step 4:",null,"Click the 'Step 4' button to populate data on 'Import Prep' sheets:\n       SPN Requests Import Prep\n       PGN Requests Import Prep\n       Mapping Requests Import Prep"]
[null,null,"Step 5:",null,"Use the 'Copy to Clipboard' buttons on each Import Prep sheet to copy when pasting into the Bulk Import Form.  These buttons skip over any blank rows."]

{"sheet":"SPN Requests Import Prep","index":5,"n_rows":4,"n_cols":11,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
[{"$f":"'SP & PG Requests'!A1","v":"SAE J1939 Request Spreadsheet [Add New DA Content] (v7.0.3)"}]
["Prep for SPN Requests Import (Bulk SPN Import form)"]
["Refer to 'Request Settings' sheet for instructions to populate sheet"]
["SPN","Name","Description Paragraph","SLOT Name","Operational Range","SPN Reference","SPN Type","Document","Request","DateMod","Status"]

{"sheet":"PGN Requests Import Prep","index":6,"n_rows":4,"n_cols":15,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
[{"$f":"'SP & PG Requests'!A1","v":"SAE J1939 Request Spreadsheet [Add New DA Content] (v7.0.3)"}]
["Prep for PGN Requests Import (Bulk PGN Import form)"]
["Refer to 'Request Settings' sheet for instructions to populate sheet"]
["PGN","Parameter Group Label","Acronym","Description Paragraph","PG Type","PG Data Length Class","PG Data Minimum Length","PG Data Length Constraint","Transmission Rate","Default Priority","PG Reference","Document","Request","Date Modified","Status"]

{"sheet":"Mapping Requests Import Prep","index":7,"n_rows":4,"n_cols":6,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
[{"$f":"'SP & PG Requests'!A1","v":"SAE J1939 Request Spreadsheet [Add New DA Content] (v7.0.3)"}]
["Prep for SPN Requests Import (Bulk Mapping Import form)"]
["Refer to 'Request Settings' sheet for instructions to populate sheet"]
["PGN","Position","SPN","Request","DateMod","Status"]