{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Document Instructions","Requester Information","SP & PG Requests","Request Settings","SPN Revisions Import Prep","PGN Revisions Import Prep"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":97,"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":"Document Instructions","index":0,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[3,2,3,5],[5,3,5,4],[1,2,1,5],[13,2,13,5],[0,2,0,5],[10,2,10,5],[12,2,12,5],[11,2,11,5]]}
[null,null,{"$f":"'SP & PG Requests'!A1","v":"SAE J1939 Request Spreadsheet [Revise Existing DA Content] (v8.0)"}]
[null,null,"Using this Workbook for Revised Content Requests"]
[]
[null,null,"The \"SAE J1939 Request Spreadsheet [Revise Existing DA Content]\" workbook is used to submit requests to revise (i.e., update) the content of existing SPNs and PGNs, using a format similar to the SAE J1939DA publication.  This workbook supports requesting revisions to the Name, Acronym, Description, and Reference properties of existing SPNs and PGNs.\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' and 'SP & PG Requests' worksheets for preparing SPs and PGs revision (update) 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","Conditional by Requester for PG and/or SP Request"]
[null,null,null,"Grey","Not Required"]
[]
[null,null,"Instructions Document:  J1939-Request-Spreadsheet [Revise Existing DA Content]-v8.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":[[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],[33,0,33,1],[34,0,34,1],[35,0,35,1],[36,0,36,1],[37,0,37,1],[0,0,0,1],[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]]}
[{"$f":"'SP & PG Requests'!A1","v":"SAE J1939 Request Spreadsheet [Revise Existing DA Content] (v8.0)"}]
["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: \nIn 23188 Hydrogen supply request, we see a potential ambiguity between '00b' and '11b.' Both states may not require immediate action. To improve clarity, we recommend stating that 'Hydrogen is required to be OFF' in the case of '00b.\n\nIn 23200 Fuel Cell System High Voltage Power Supply Interlock Command: The enum '00b, which states that the 'Fuel cell system is not requesting the high voltage power supply to be on, but the external environment can choose to turn on the high voltage supply if needed.', seems quite similar to the state '11b,' which means 'Don't care/Take no action.' This is because both states might not lead to any immediate action.\nTo prevent confusion, we suggest that, in the case of '00b,' it should indicate that the fuel cell system is actively asking for the high voltage power supply to be turned OFF.\n\nTo avoid any risk of confusion we propose to clarify if the measured hydrogen concentration refers to absolute concentration or relative to EGLI. This applies to 21336, 21337, 21338 and 23397."]
[]
["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":11,"n_cols":47,"rows_kept":11,"cut":false,"hidden":false,"merged":[[3,11,3,45],[0,0,0,3],[2,0,2,2],[3,0,3,10],[1,0,1,2]]}
["SAE J1939 Request Spreadsheet [Revise Existing DA Content] (v8.0)"]
["SP & PG Requests"]
["Refer to 'Document Instructions' for help and color legend."]
["Revised PG and SP data\n(revised data for the PG and SP properties)",null,null,null,null,null,null,null,null,null,null,"Existing PG and SP data\n(existing data for the PG and SP from J1939DA file)"]
["PG Revise Action \nfor Row\n(right-click menu)","SP Revise Action \nfor Row\n(right-click menu)","PGN\n(only required if PG data being revised)","PG Label\n(revised text)","PG Acronym\n(revised text)","PG Description\n(revised text)","PG Reference\n(revised text)","SPN\n(only required if SP data being revised)","SP Label\n(revised text)","SP Description\n(revised text)","SP Reference\n(revised text)","PGN\n(only required if PG data being revised)","PG Label\n(existing text from J1939DA file)\n(only required if being revised)","PG Acronym\n(existing text from J1939DA file)\n(only required if being revised)","PG Description\n(existing text from J1939DA file)\n(only required if being revised)","PDU Type","PGN Page","PG Data Length Class","PG Data Minimum Length","PG Data Length Constraint","PG Data Highest Assigned Byte","Transmission Rate","Default Priority","PG Reference\n(existing text from J1939DA file)\n(only required if being revised)","SP Position in PG","SP Start Bit","SPN\n(only required if SP data being revised)","SP Label\n(existing text from J1939DA file)\n(only required if being revised)","SP Description\n(existing text from J1939DA file)\n(only required if being revised)","SP Length","Scaling","Offset","Data Range","Operational Range","Units","SLOT Identifier","SLOT Name","SP Type","SP Reference\n(existing text from J1939DA file)\n(only required if being revised)","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"]
[null,"Descr",null,null,null,null,null,23188,"Hydrogen Supply Request","Request to the hydrogen storage system to supply hydrogen to the fuel cell system.  The hydrogen storage system may determine that it cannot honor the request.\n\n00b = Hydrogen is required to be off\n01b = Hydrogen is requested\n10b = Reserved  \n11b = Don't care / Take no action",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23188,"Hydrogen Supply Request","Request to the hydrogen storage system to supply hydrogen to the fuel cell system.  The hydrogen storage system may determine that it cannot honor the request.\n\n00b = Hydrogen is not requested\n01b = Hydrogen is requested\n10b = Reserved  \n11b = Don't care / Take no action"]
[null,"Descr",null,null,null,null,null,23200,"Fuel Cell System High Voltage Power Supply Interlock Command","Indicates if the fuel cell system (FCS) indicates the high voltage power supply can be connected or commands that it not be disconnected if it is connected.\n\n00b = Fuel cell system is requesting the high voltage power supply to be off.\n01b = Fuel cell system is ready for the high voltage power supply to be on.  The high voltage power supply shall not be disconnected if it is on unless a fault condition is present that requires it be disconnected.\n10b = Reserved\n11b = Don't care/Take no action",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23200,"Fuel Cell System High Voltage Power Supply Interlock Command","Indicates if the fuel cell system (FCS) indicates the high voltage power supply can be connected or commands that it not be disconnected if it is connected.\n\n00b = Fuel cell system is not requesting the high voltage power supply to be on, but the external environment can choose to turn on the high voltage supply if needed.\n01b = Fuel cell system is ready for the high voltage power supply to be on.  The high voltage power supply shall not be disconnected if it is on unless a fault condition is present that requires it be disconnected.\n10b = Reserved\n11b = Don't care/Take no action"]
[null,"Descr",null,null,null,null,null,21336,"Fuel Cell Enclosure 1 Hydrogen Concentration","This parameter indicates the absolute hydrogen concentration measured inside the Fuel Cell Enclosure 1 in the Fuel Cell Compartment\n\nNote: A Fuel Cell Enclosure can contain one or more Fuel Cell Stack.\n\nParameter Specific Indicator:  A value of FBh indicates conditions are not acceptable for a valid measurement.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21336,"Fuel Cell Enclosure 1 Hydrogen Concentration","This parameter indicates the hydrogen concentration measured inside the Fuel Cell Enclosure 1 in the Fuel Cell Compartment\r\n\r\nNote: A Fuel Cell Enclosure can contain one or more Fuel Cell Stack.\r\n\r\nParameter Specific Indicator:  A value of FBh indicates conditions are not acceptable for a valid measurement."]
[null,"Descr",null,null,null,null,null,21337,"Fuel Cell Enclosure 2 Hydrogen Concentration","This parameter indicates the absolute hydrogen concentration measured inside the Fuel Cell Enclosure 2 in the Fuel Cell Compartment\n\nNote: A Fuel Cell Enclosure can contain one or more Fuel Cell Stack.\n\nParameter Specific Indicator:  A value of FBh indicates conditions are not acceptable for a valid measurement.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21337,"Fuel Cell Enclosure 2 Hydrogen Concentration","This parameter indicates the hydrogen concentration measured inside the Fuel Cell Enclosure 2 in the Fuel Cell Compartment\r\n\r\nNote: A Fuel Cell Enclosure can contain one or more Fuel Cell Stack.\r\n\r\nParameter Specific Indicator:  A value of FBh indicates conditions are not acceptable for a valid measurement."]
[null,"Descr",null,null,null,null,null,21338,"Fuel Cell Compartment Hydrogen Concentration","This parameter indicates the absolute hydrogen concentration measured inside the Fuel Cell Compartment.\n\nNote: A Fuel Cell Compartment can contain one or more Fuel Cell Enclosures. See SPN 21336 (Fuel Cell Enclosure 1 Hydrogen Concentration) and SPN 21337 (Fuel Cell Enclosure 2 Hydrogen Concentration).\n\nParameter Specific Indicator: A value of FBh indicates conditions are not acceptable for a valid measurement.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21338,"Fuel Cell Compartment Hydrogen Concentration","This parameter indicates the hydrogen concentration measured inside the Fuel Cell Compartment.\r\n\r\nNote: A Fuel Cell Compartment can contain one or more Fuel Cell Enclosures. See SPN 21336 (Fuel Cell Enclosure 1 Hydrogen Concentration) and SPN 21337 (Fuel Cell Enclosure 2 Hydrogen Concentration).\r\n\r\nParameter Specific Indicator: A value of FBh indicates conditions are not acceptable for a valid measurement."]
[null,null,null,null,null,null,null,23397,"Hydrogen Concentration","This parameter indicates the absolute hydrogen concentration measured by the sensor.\n\nParameter Specific Indicator:  A value of FBh indicates conditions are not acceptable for a valid measurement.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23397,"Hydrogen Concentration","This parameter indicates the hydrogen concentration measured by the sensor.\n\nParameter Specific Indicator:  A value of FBh indicates conditions are not acceptable for a valid measurement."]

{"sheet":"Request Settings","index":3,"n_rows":112,"n_cols":5,"rows_kept":112,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
[{"$f":"'SP & PG Requests'!A1","v":"SAE J1939 Request Spreadsheet [Revise Existing DA Content] (v8.0)"}]
["Request Settings"]
[]
[null,"Step 1:  Set request values"]
[null,"Request ID",2019041511,null,"(The RequestID to use for the requested revisions)"]
[null,"Date Modified","2020-10-20",null,"(The Date to use for the Date Modified)"]
[null,"Status","Approved",null,"(The state to use for the Status)"]
[]
[]
[]
[]
[]
[null,"Instructions:","Step 1:",null,"Update default/static settings above"]
[null,null,"Step 2:",null,"Click the 'Step 2' button to validate data on 'SP & PG Requests' sheet"]
[null,null,"Step 3:",null,"Click the 'Step 3' to populate data on 'Import Prep' sheets:\n       SPN Revisions Import Prep\n       PGN Revisions Import Prep"]
[null,null,"Step 4:",null,"Use the 'Copy' buttons on each Import Prep sheet to copy when pasting into the Bulk Update Form.  These buttons skip over any blank rows."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"This section describes the proper format to use for those cross references in the SP Description in order for this tool to automatically updated the cross reference SPN/PGN values prior to being added to the J1939 database.  Using a prescribed placeholder format, cross reference to other SPs and PGs being requested can be included in the following columns:\n    SP Descriptions\n    PG Descriptions\n    SP References\n    PG References"]
[]
[null,null,null,"The tool provides support for handling cross references to other SPs and PGs being requested within the same request file.  Using a prescribed placeholder format, once the SPN and PGN assignments are entered, then the cross reference placeholders are updated with the actual SPN and PGN values."]
[]
[null,null,null,"The cross reference support is not to be used for citing cross references to existing SPs or PGs.   When needing to cross reference to an existing assigned SP or PG, the requester shall cite the existing SPN or PGN in the cross reference . "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"·         use the square brackets with 'x' characters as an indicator of an SPN cross reference placeholder."]
[]
[]
[]
[]
[null,null,null,"The proper format for the PGN cross reference is the word \"PGN\" followed by 3 or more 'x' letters enclosed in square brackets ([xxx]) followed by the name of the referenced PG enclosed within parenthesis.  \n"]
[]
[null,null,null,"Note:  PG Name spelling must exactly match the PG Name as presented in the 'PG Label' column.  This includes letter case, spaces, etc.\n"]
[]
[null,null,null,"·         use the square brackets with 'x' characters as an indicator of an PGN cross reference placeholder."]
[]
[]
[]
[]
[null,null,null,"The following 3 columns show information about  SPN/PGN cross-reference updates for the SP Description."]
[]
[]
[null,null,null,"This column shows the SP Description with updated SPN and PGN cross references. Cells in this column have text only when the row's SP Description contains at least one SPN cross reference or PGN cross reference.\n"]
[]
[]
[]
[]
[null,null,null,"·         A cell in this column is blank if there are no proper SPN or PGN cross references in that row's SP Description content.\n"]
[]
[]
[]
[null,null,null,"·         \"Invalid Format\" indicates the number of cross references where the SPN or PGN cross reference format does not match the format as specified in sections 3.1.1 and 3.1.2, respectively.  Details are provided in the 'SPN/PGN Reference Replacements' column (refer to section 3.2.3.)."]
[]
[]
[null,null,null,"This column shows how each individual SPN cross reference is updated. Cells in this column have text only when the row's SP Description contains at least one SPN cross reference or PGN cross reference."]
[null,null,null,"·         A cell in this column is blank if there are no proper SPN or PGN cross references in that row's SP Description content.\n"]
[]
[]
[]
[]
[null,null,"3.3."]

{"sheet":"SPN Revisions Import Prep","index":4,"n_rows":4,"n_cols":14,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
[{"$f":"'SP & PG Requests'!A1","v":"SAE J1939 Request Spreadsheet [Revise Existing DA Content] (v8.0)"}]
["Prep for SPN Revisions Import (Bulk Update SPN form)"]
["Refer to 'Request Settings' sheet for instructions to populate sheet"]
["Row Revisions","SPN","Name\n(revised text)","Description\n(revised text)","SP Reference\n(revised text)","Name\n(original text)","Description\n(original text)","SP Reference\n(original text)","Request","DateMod","Status","Update Label","Update Description","Update Reference"]

{"sheet":"PGN Revisions Import Prep","index":5,"n_rows":4,"n_cols":17,"rows_kept":4,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
[{"$f":"'SP & PG Requests'!A1","v":"SAE J1939 Request Spreadsheet [Revise Existing DA Content] (v8.0)"}]
["Prep for PGN Revisions Import (Bulk Update PGN form)"]
["Refer to 'Request Settings' sheet for instructions to populate sheet"]
["Row Revisions","PGN","PG Label\n(revised text)","Acronym\n(revised text)","Description\n(revised text)","PG Reference\n(revised text)","PG Label\n(original text)","Acronym\n(original text)","Description\n(original text)","PG Reference\n(original text)","Request","DateMod","Status","Update Label","Update Acronym","Update Description","Update Reference"]