{"text_format":"3","workbook":"xlsx","n_sheets":9,"sheets":["Data Definitions","Details","Transactions 1-2","Transactions 3-4","Transactions 5-6","Transactions 7-8","Transactions 9-10","Joint Trade Instructions","Supporting"],"not_rendered":{"images":135,"macros":1,"defined_names":56},"read":"whole","date_system":"1900"}

{"sheet":"Data Definitions","index":0,"n_rows":63,"n_cols":8,"rows_kept":63,"merged":[[10,1,26,1],[27,1,62,1]]}
["United States Department of Transportation\nNational Highway Transportation Safety Administration\n\nNHTSA CAFE Credit Template (OMB Control No. 2127-0019)\nNHTSA Form Number 1475\n49 CFR 536.8, 49 CFR 536.5(d)(6), and 49 CFR 536.7\n\nVersion Number: 1.1; Last Revision: 08/30/2018; Expiration Date: xxxxxxxxxx"]
[]
[{"$nulls":6},"Agency Message"]
[{"$nulls":6},"This template meets the National Highway Traffic Safety Administration’s (NHTSA’s) regulatory requirements for submitting credit transaction instructions in accordance with 49 CFR 536. This template defines the data and data formats required by NHTSA's regulatory provisions. In accordance with 49 CFR 536.8, 49 CFR 536.5(d)(6), and 49 CFR 536.7, manufacturers and other CAFE credit account holders are required to submit Joint Trade Instructions, Credit Allocation Plans, and Carryback Plans to NHTSA to initiate the debiting and crediting of CAFE credit accounts, and the resolution of CAFE credit deficits.\n"]
[]
[{"$nulls":6},"Paperwork Reduction Act Notice"]
[{"$nulls":6},"The public reporting and recordkeeping burden for this collection of information is estimated to average 9 hours per response. Send comments on the Agency's need for this information, the accuracy of the provided burden estimates, and any suggested methods for minimizing respondent burden, including through the use of automated collection techniques to the address below. Include the OMB control number in any correspondence, but do not send the completed documents."]
[{"$nulls":6},"\nOffice of the Chief Information Officer\nOffice of the Secretary\n1200 New Jersey Avenue, SE\nWashington, DC 20590\n"]
[]
[null,"Worksheet","Data Field","Location","Source","Data Type","Data Definition / Description","Regulatory Citations"]
[null,"Transactions","Transaction Date","D7","User-Entered","Date\n(mm/dd/yyyy)","Enter the Transaction Date.","49 CFR 536.8(a)\n49 CFR 536.8(b)"]
[null,null,"Transaction Type","E10, E33\nP10, P33\nAA10, AA33\nAL10, AL33\nAW10, AW33","User-Selected","List","Select the Transaction Type from the dropdown list.","49 CFR 536.8(a)\n49 CFR 536.8(b)"]
[null,null,"Apply to Shortfall","F10, F33\nQ10, Q33\nAB10, AB33\nAM10, AM33\nAX10, AX33","User-Selected","List","Select \"Yes\" if the transaction applies credits to an existing CAFE credit shortfall, select \"No\" if not.","49 CFR 536.4(c)"]
[null,null,"Initial Credit Amount","G10, G33\nR10, R33\nAC10, AC33\nAN10, AN33\nAY10, AY33","User-Entered","Whole Number","Enter the initial credit amount of the transaction.","49 CFR 536.8(a)\n49 CFR 536.8(b)"]
[null,null,"Manufacturer - Earned","E14, E37\nP14, P37\nAA14, AA37\nAL14, AL37\nAW14, AW37","User-Selected","List","Select the Manufacturer who earned the credits from the dropdown list.","49 CFR 536.8(a)\n49 CFR 536.8(b)"]
[null,null,"Compliance Category - Earned","F14, F37\nQ14, Q37\nAB14, AB37\nAM14, AM37\nAX14, AX37","User-Selected","List","Select the Compliance Category in which the credits were earned from the dropdown list.","49 CFR 536.8(a)\n49 CFR 536.8(b)"]
[null,null,"Model Year - Earned","G14, G37\nR14, R37\nAC14, AC37\nAN14, AN37\nAY14, AY37","User-Selected","List","Select the Compliance Model Year in which the credits were earned from the dropdown list.","49 CFR 536.8(a)\n49 CFR 536.8(b)"]
[null,null,"Actual Fuel Economy - Earned","I14, I37\nT14, T37\nAE14, AE37\nAP14, AP37\nBA14, BA37","User-Entered","Decimal Number\n(##.#)","If the transaction applies credits to an existing CAFE credit shortfall, enter the Fleet Average Fuel Economy of the fleet (i.e. manufacturer/compliance category/model year) that earned the credits.","49 CFR 536.4(c)"]
[null,null,"Required Fuel Economy Standard - Earned","J14, J37\nU14, U37\nAF14, AF37\nAQ14, AQ37\nBB14, BB37","User-Entered","Decimal Number\n(##.#)","If the transaction applies credits to an existing CAFE credit shortfall, enter the Fleet Average Fuel Economy Standard of the fleet (i.e. manufacturer/compliance category/model year) that earned the credits.","49 CFR 536.4(c)"]
[null,null,"Manufacturer - Current","E18, E41\nP18, P41\nAA18, AA41\nAL18, AL41\nAW18, AW41","User-Selected","List","Select the Manufacturer who currently holds the credits from the dropdown list.","49 CFR 536.8(a)\n49 CFR 536.8(b)"]
[null,null,"Compliance Category - Current","F18, F41\nQ18, Q41\nAB18, AB41\nAM18, AM41\nAX18, AX41","User-Selected","List","Select the Compliance Category in which the credits are currently held from the dropdown list.","49 CFR 536.8(a)\n49 CFR 536.8(b)"]
[null,null,"Model Year - Current","G18, G41\nR18, R41\nAC18, AC41\nAN18, AN41\nAY18, AY41","User-Selected","List","Select the Model Year in which the credits are currently held from the dropdown list.","49 CFR 536.8(a)\n49 CFR 536.8(b)"]
[null,null,"Manufacturer - Destination","E22, E45\nP22, P45\nAA22, AA45\nAL22, AL45\nAW22, AW45","User-Selected","List","Select the Manufacturer who will be receiving the credits from the dropdown list.","49 CFR 536.8(a)\n49 CFR 536.8(b)"]
[null,null,"Compliance Category - Destination","F22, F45\nQ22, Q45\nAB22, AB45\nAM22, AM45\nAX22, AX45","User-Selected","List","Select the Compliance Category that will be receiving the credits from the dropdown list.","49 CFR 536.8(a)\n49 CFR 536.8(b)"]
[null,null,"Model Year - Destination","G22, G45\nR22, R45\nAC22, AC45\nAN22, AN45\nAY22, AY45","User-Selected","List","Select the Model Year that will be receiving the credits from the dropdown list.","49 CFR 536.8(a)\n49 CFR 536.8(b)"]
[null,null,"Actual Fuel Economy - Destination","I22, I45\nT22, T45\nAE22, AE45\nAP22, AP45\nBA22, BA45","User-Entered","Decimal Number\n(##.#)","If the transaction applies credits to an existing CAFE credit shortfall, enter the Fleet Average Fuel Economy of the fleet (i.e. manufacturer/compliance category/model year) that earned the shortfall.","49 CFR 536.4(c)"]
[null,null,"Required Fuel Economy Standard - Destination","J22, J45\nU22, U45\nAF22, AF45\nAQ22, AQ45\nBB22, BB45","User-Entered","Decimal Number\n(##.#)","If the transaction applies credits to an existing CAFE credit shortfall, enter the Fleet Average Fuel Economy Standard of the fleet (i.e. manufacturer/compliance category/model year) that earned the shortfall.","49 CFR 536.4(c)"]
[null,"Trade Details","Company's Name","E10","User-Entered","Text\n(50 Char. Limit)","Enter the Credit Holder's Company Name.","49 CFR 536.5(b)(1)\n49 CFR 536.8(a)"]
[null,null,"Company's Street Address 1","E11","User-Entered","Text\n(50 Char. Limit)","Enter the Credit Holder's Street Address.","49 CFR 536.5(b)(1)\n49 CFR 536.8(a)"]
[null,null,"Company's Street Address 2 (optional)","E12","User-Entered","Text\n(50 Char. Limit)","Enter the Credit Holder's Street Address.","49 CFR 536.5(b)(1)\n49 CFR 536.8(a)"]
[null,null,"Company's City","E13","User-Entered","Text\n(50 Char. Limit)","Enter the Credit Holder's City.","49 CFR 536.5(b)(1)\n49 CFR 536.8(a)"]
[null,null,"Company's State","E14","User-Selected","List","Select the Credit Holder's State from the dropdown list.","49 CFR 536.5(b)(1)\n49 CFR 536.8(a)"]
[null,null,"Company's Zip Code","E15","User-Entered","Whole Number\n(5 digits)","Enter the Credit Holder's Zip Code.","49 CFR 536.5(b)(1)\n49 CFR 536.8(a)"]
[null,null,"Company's Phone Number","E16","User-Entered","Whole Number\n(10 digits)","Enter the Credit Holder's Phone Number.","49 CFR 536.5(b)(1)\n49 CFR 536.8(a)"]
[null,null,"Designated Signatory's Name","E20","User-Entered","Text\n(50 Char. Limit)","Enter the Credit Holder Designated Signatory's Name.","49 CFR 536.5(b)(1)\n49 CFR 536.8(a)"]
[null,null,"Designated Signatory's Title","E21","User-Entered","Text\n(50 Char. Limit)","Enter the Credit Holder Designated Signatory's Title.","49 CFR 536.5(b)(1)\n49 CFR 536.8(a)"]
[null,null,"Designated Signatory's Department","E22","User-Entered","Text\n(50 Char. Limit)","Enter the Credit Holder Designated Signatory's Department.","49 CFR 536.5(b)(1)\n49 CFR 536.8(a)"]
[null,null,"Designated Signatory's Company","E23","User-Entered","Text\n(50 Char. Limit)","Enter the Credit Holder Designated Signatory's Company.","49 CFR 536.5(b)(1)\n49 CFR 536.8(a)"]
[null,null,"Designated Signatory's Signature Date","E24","User-Entered","Date\n(mm/dd/yyyy)","Enter the Date the Credit Holder Designated Signatory signed the agreement.","49 CFR 536.5(b)(1)\n49 CFR 536.8(a)"]
[null,null,"Point of Contact's Name","E28","User-Entered","Text\n(50 Char. Limit)","Enter the Credit Holder Point of Contact's Name.","49 CFR 536.5(b)(1)\n49 CFR 536.8(a)"]
[null,null,"Point of Contact's Title","E29","User-Entered","Text\n(50 Char. Limit)","Enter the Credit Holder Point of Contact's Title.","49 CFR 536.5(b)(1)\n49 CFR 536.8(a)"]
[null,null,"Point of Contact's Department","E30","User-Entered","Text\n(50 Char. Limit)","Enter the Credit Holder Point of Contact's Department.","49 CFR 536.5(b)(1)\n49 CFR 536.8(a)"]
[null,null,"Point of Contact's Company","E31","User-Entered","Text\n(50 Char. Limit)","Enter the Credit Holder Point of Contact's Company.","49 CFR 536.5(b)(1)\n49 CFR 536.8(a)"]
[null,null,"Point of Contact's Phone Number","E32","User-Entered","Whole Number\n(10 digits)","Enter the Credit Holder Point of Contact's Phone Number.","49 CFR 536.5(b)(1)\n49 CFR 536.8(a)"]
[null,null,"Point of Contact's Email","E33","User-Entered","Text\n(50 Char. Limit)","Enter the Credit Holder Point of Contact's Email.","49 CFR 536.5(b)(1)\n49 CFR 536.8(a)"]
[null,null,"Company's Name","E10","User-Entered","Text\n(50 Char. Limit)","Enter the Credit Receiver's Company Name.","49 CFR 536.5(b)(1)\n49 CFR 536.8(a)"]
[null,null,"Company's Street Address 1","E11","User-Entered","Text\n(50 Char. Limit)","Enter the Credit Receiver's Street Address.","49 CFR 536.5(b)(1)\n49 CFR 536.8(a)"]
[null,null,"Company's Street Address 2 (optional)","E12","User-Entered","Text\n(50 Char. Limit)","Enter the Credit Receiver's Street Address.","49 CFR 536.5(b)(1)\n49 CFR 536.8(a)"]
[null,null,"Company's City","E13","User-Entered","Text\n(50 Char. Limit)","Enter the Credit Receiver's City.","49 CFR 536.5(b)(1)\n49 CFR 536.8(a)"]
[null,null,"Company's State","E14","User-Selected","List","Select the Credit Receiver's State from the dropdown list.","49 CFR 536.5(b)(1)\n49 CFR 536.8(a)"]
[null,null,"Company's Zip Code","E15","User-Entered","Whole Number\n(5 digits)","Enter the Credit Receiver's Zip Code.","49 CFR 536.5(b)(1)\n49 CFR 536.8(a)"]
[null,null,"Company's Phone Number","E16","User-Entered","Whole Number\n(10 digits)","Enter the Credit Receiver's Phone Number.","49 CFR 536.5(b)(1)\n49 CFR 536.8(a)"]
[null,null,"Designated Signatory's Name","E20","User-Entered","Text\n(50 Char. Limit)","Enter the Credit Receiver Designated Signatory's Name.","49 CFR 536.5(b)(1)\n49 CFR 536.8(a)"]
[null,null,"Designated Signatory's Title","E21","User-Entered","Text\n(50 Char. Limit)","Enter the Credit Receiver Designated Signatory's Title.","49 CFR 536.5(b)(1)\n49 CFR 536.8(a)"]
[null,null,"Designated Signatory's Department","E22","User-Entered","Text\n(50 Char. Limit)","Enter the Credit Receiver Designated Signatory's Department.","49 CFR 536.5(b)(1)\n49 CFR 536.8(a)"]
[null,null,"Designated Signatory's Company","E23","User-Entered","Text\n(50 Char. Limit)","Enter the Credit Receiver Designated Signatory's Company.","49 CFR 536.5(b)(1)\n49 CFR 536.8(a)"]
[null,null,"Designated Signatory's Signature Date","E24","User-Entered","Date\n(mm/dd/yyyy)","Enter the Date the Credit Receiver Designated Signatory signed the agreement.","49 CFR 536.5(b)(1)\n49 CFR 536.8(a)"]
[null,null,"Point of Contact's Name","E28","User-Entered","Text\n(50 Char. Limit)","Enter the Credit Receiver Point of Contact's Name.","49 CFR 536.5(b)(1)\n49 CFR 536.8(a)"]
[null,null,"Point of Contact's Title","E29","User-Entered","Text\n(50 Char. Limit)","Enter the Credit Receiver Point of Contact's Title.","49 CFR 536.5(b)(1)\n49 CFR 536.8(a)"]
[null,null,"Point of Contact's Department","E30","User-Entered","Text\n(50 Char. Limit)","Enter the Credit Receiver Point of Contact's Department.","49 CFR 536.5(b)(1)\n49 CFR 536.8(a)"]
[null,null,"Point of Contact's Company","E31","User-Entered","Text\n(50 Char. Limit)","Enter the Credit Receiver Point of Contact's Company.","49 CFR 536.5(b)(1)\n49 CFR 536.8(a)"]
[null,null,"Point of Contact's Phone Number","E32","User-Entered","Whole Number\n(10 digits)","Enter the Credit Receiver Point of Contact's Phone Number.","49 CFR 536.5(b)(1)\n49 CFR 536.8(a)"]
[null,null,"Point of Contact's Email","E33","User-Entered","Text\n(50 Char. Limit)","Enter the Credit Receiver Point of Contact's Email.","49 CFR 536.5(b)(1)\n49 CFR 536.8(a)"]

{"sheet":"Details","index":1,"n_rows":36,"n_cols":12,"rows_kept":36}
[]
[null,"United States Department of Transportation\nNational Highway Transportation Safety Administration\n\nNHTSA CAFE Credit Template (OMB Control No. 2127-0019)\nNHTSA Form Number 1475\n49 CFR 536.8, 49 CFR 536.5(d)(6), and 49 CFR 536.7\n\nVersion Number: 1.1; Last Revision: 08/30/2018; Expiration Date: xxxxxxxxxx"]
[]
[null,null,"TRANSACTION DETAILS"]
[{"$nulls":3},"(Select Yes or No)",null,"One"]
[]
[]
[]
[null,null,"Credit Holder",{"$nulls":5},"Credit Receiver"]
[]
[{"$nulls":5},"Company",{"$nulls":5},"Company"]
[]
[{"$nulls":3},"Name:",{"$nulls":5},"Name:"]
[{"$nulls":3},"Street Address 1:",{"$nulls":5},"Street Address 1:"]
[{"$nulls":3},"Street Address 2 (optional):",{"$nulls":5},"Street Address 2 (optional):"]
[{"$nulls":3},"City:",{"$nulls":5},"City:"]
[{"$nulls":3},"State:",null,"(Select State)",{"$nulls":3},"State:",null,"(Select State)"]
[{"$nulls":3},"Zip Code:",{"$nulls":5},"Zip Code:"]
[{"$nulls":3},"Phone Number:",{"$nulls":5},"Phone Number:"]
[]
[{"$nulls":5},"Designated Signatory",{"$nulls":5},"Designated Signatory"]
[]
[{"$nulls":3},"Name:",{"$nulls":5},"Name:"]
[{"$nulls":3},"Title:",{"$nulls":5},"Title:"]
[{"$nulls":3},"Department:",{"$nulls":5},"Department:"]
[{"$nulls":3},"Company:",{"$nulls":5},"Company:"]
[{"$nulls":3},"Signature Date:",{"$nulls":5},"Signature Date:"]
[]
[{"$nulls":5},"Point of Contact",{"$nulls":5},"Point of Contact"]
[]
[{"$nulls":3},"Name:",{"$nulls":5},"Name:"]
[{"$nulls":3},"Title:",{"$nulls":5},"Title:"]
[{"$nulls":3},"Department:",{"$nulls":5},"Department:"]
[{"$nulls":3},"Company:",{"$nulls":5},"Company:"]
[{"$nulls":3},"Phone Number:",{"$nulls":5},"Phone Number:"]
[{"$nulls":3},"Email:",{"$nulls":5},"Email:"]

{"sheet":"Transactions 1-2","index":2,"n_rows":59,"n_cols":8,"rows_kept":59}
[]
[null,"United States Department of Transportation\nNational Highway Transportation Safety Administration\n\nNHTSA CAFE Credit Template (OMB Control No. 2127-0019)\nNHTSA Form Number 1475\n49 CFR 536.8, 49 CFR 536.5(d)(6), and 49 CFR 536.7\n\nVersion Number: 1.1; Last Revision: 08/30/2018; Expiration Date: xxxxxxxxxx"]
[]
[{"$nulls":3},"Transaction Date\n(mm/dd/yyyy)",{"$nulls":3},{"v":1,"d":"Page 1"}]
[]
[]
[{"$nulls":4},"(Select Transaction Type)",null,"(Select Type of Credits)","(Select Yes or No)"]
[{"$nulls":3},"Transaction No.","Transaction Type","Initial Credit Amount","Credit Type","Apply to Shortfall?"]
[{"$nulls":3},1]
[{"$nulls":5},"(Select Manufacturer)","(Select Compliance Category)","(Select Model Year)"]
[{"$nulls":4},"Earned Account:","Manufacturer","Compliance Category","MY"]
[]
[]
[{"$nulls":4},"Earned Account:","VMTe","MPGae","MPGse"]
[{"$nulls":5},{"$f":"IF(AND(OR(E7<>\"Carry Forward\",E7<>\"Carry Back\"),H7=\"Yes\",F10<>\"(Select Manufacturer)\",G10<>\"(Select Compliance Category)\",H10<>\"(Select MY)\"),VLOOKUP(CONCATENATE($G10,\"-\",$H10),Unique_ID_Lookup,4,FALSE),\"\")","v":""}]
[{"$nulls":5},"(Select Manufacturer)","(Select Compliance Category)","(Select Model Year)"]
[{"$nulls":4},"Current Account:","Manufacturer","Compliance Category","MY"]
[]
[{"$nulls":5},"(Select Manufacturer)","(Select Compliance Category)","(Select Model Year)"]
[{"$nulls":4},"Destination Account:","Manufacturer","Compliance Category","MY"]
[]
[]
[{"$nulls":4},"Destination Account:","VMTu","MPGau","MPGsu"]
[{"$nulls":5},{"$f":"IF(AND(OR(E7<>\"Carry Forward\",E7<>\"Carry Back\"),H7=\"Yes\",F19<>\"(Select Manufacturer)\",G19<>\"(Select Compliance Category)\",H19<>\"(Select MY)\"),VLOOKUP(CONCATENATE($G19,\"-\",$H19),Unique_ID_Lookup,4,FALSE),\"\")","v":""}]
[]
[{"$nulls":6},"Adjustment Factor","Final Credit Amount"]
[{"$nulls":6},{"$f":"astm(IFERROR(IF(OR(E7=\"(Select Transaction Type)\",H7=\"(Select Yes or No)\"),0,IF(OR(E7=\"Carry Forward\",E7=\"Carry Back\",H7=\"No\"),1,(F24*G15*H15)/(F15*G24*H24))),0),4)","v":{"v":0,"d":"0.0000"}},{"$f":"astm(IFERROR(F9/G27,0),0)","v":0}]
[]
[]
[{"$nulls":4},"(Select Transaction Type)",null,"(Select Type of Credits)","(Select Yes or No)"]
[{"$nulls":3},"Transaction No.","Transaction Type","Initial Credit Amount","Credit Type","Apply to Shortfall?"]
[{"$nulls":3},{"$f":"D9+1","v":2}]
[{"$nulls":5},"(Select Manufacturer)","(Select Compliance Category)","(Select MY)"]
[{"$nulls":4},"Earned Account:","Manufacturer","Compliance Category","MY"]
[]
[]
[{"$nulls":4},"Earned Account:","VMTe","MPGae","MPGse"]
[{"$nulls":5},{"$f":"IF(AND(OR(E30<>\"Carry Forward\",E30<>\"Carry Back\"),H30=\"Yes\",F33<>\"(Select Manufacturer)\",G33<>\"(Select Compliance Category)\",H33<>\"(Select MY)\"),VLOOKUP(CONCATENATE($G33,\"-\",$H33),Unique_ID_Lookup,4,FALSE),\"\")","v":""}]
[{"$nulls":5},"(Select Manufacturer)","(Select Compliance Category)","(Select MY)"]
[{"$nulls":4},"Current Account:","Manufacturer","Compliance Category","MY"]
[]
[{"$nulls":5},"(Select Manufacturer)","(Select Compliance Category)","(Select MY)"]
[{"$nulls":4},"Destination Account:","Manufacturer","Compliance Category","MY"]
[]
[]
[{"$nulls":4},"Destination Account:","VMTu","MPGau","MPGsu"]
[{"$nulls":5},{"$f":"IF(AND(OR(E30<>\"Carry Forward\",E30<>\"Carry Back\"),H30=\"Yes\",F42<>\"(Select Manufacturer)\",G42<>\"(Select Compliance Category)\",H42<>\"(Select MY)\"),VLOOKUP(CONCATENATE($G42,\"-\",$H42),Unique_ID_Lookup,4,FALSE),\"\")","v":""}]
[]
[{"$nulls":6},"Adjustment Factor","Final Credit Amount"]
[{"$nulls":6},{"$f":"astm(IFERROR(IF(OR(E30=\"(Select Transaction Type)\",H30=\"(Select Yes or No)\"),0,IF(OR(E30=\"Carry Forward\",E30=\"Carry Back\",H30=\"No\"),1,(F47*G38*H38)/(F38*G47*H47))),0),4)","v":{"v":0,"d":"0.0000"}},{"$f":"astm(IFERROR(H32/G50,0),0)","v":0}]
[]
[]
[]
[{"$nulls":3},"VMTe = Lifetime vehicle miles traveled as provided in the following table for the model year and compliance category in which the credit was earned;"]
[{"$nulls":3},"MPGae = Actual fuel economy for the originating manufacturer, compliance category, and model year in which the credit was earned;"]
[{"$nulls":3},"MPGse = Required fuel economy standard for the originating (earning) manufacturer, compliance category, and model year in which the credit was earned;"]
[{"$nulls":3},"VMTu = Lifetime vehicle miles traveled as provided in the following table for the model year and compliance category in which the credit is used for compliance;"]
[{"$nulls":3},"MPGau = Actual fuel economy for the user manufacturer, compliance category, and model year in which the credit is used for compliance; and"]
[{"$nulls":3},"MPGsu = Required fuel economy standard for the user (buying) manufacturer, compliance category, and model year in which the credit is used for compliance."]

{"sheet":"Transactions 3-4","index":3,"n_rows":59,"n_cols":8,"rows_kept":59,"hidden":true}
[]
[null,"United States Department of Transportation\nNational Highway Transportation Safety Administration\n\nNHTSA CAFE Credit Template (OMB Control No. 2127-0019)\nNHTSA Form Number 1475\n49 CFR 536.8, 49 CFR 536.5(d)(6), and 49 CFR 536.7\n\nVersion Number: 1.1; Last Revision: 08/30/2018; Expiration Date: xxxxxxxxxx"]
[]
[{"$nulls":3},"Transaction Date\n(mm/dd/yyyy)",{"$nulls":3},{"$f":"'Transactions 1-2'!H4+1","v":{"v":2,"d":"Page 2"}}]
[]
[]
[{"$nulls":4},"(Select Transaction Type)",null,"(Select Type of Credits)","(Select Yes or No)"]
[{"$nulls":3},"Transaction No.","Transaction Type","Initial Credit Amount","Credit Type","Apply to Shortfall?"]
[{"$nulls":3},{"$f":"'Transactions 1-2'!D32+1","v":3}]
[{"$nulls":5},"(Select Manufacturer)","(Select Compliance Category)","(Select Model Year)"]
[{"$nulls":4},"Earned Account:","Manufacturer","Compliance Category","MY"]
[]
[]
[{"$nulls":4},"Earned Account:","VMTe","MPGae","MPGse"]
[{"$nulls":5},{"$f":"IF(AND(OR(E7<>\"Carry Forward\",E7<>\"Carry Back\"),H7=\"Yes\",F10<>\"(Select Manufacturer)\",G10<>\"(Select Compliance Category)\",H10<>\"(Select MY)\"),VLOOKUP(CONCATENATE($G10,\"-\",$H10),Unique_ID_Lookup,4,FALSE),\"\")","v":""}]
[{"$nulls":5},"(Select Manufacturer)","(Select Compliance Category)","(Select Model Year)"]
[{"$nulls":4},"Current Account:","Manufacturer","Compliance Category","MY"]
[]
[{"$nulls":5},"(Select Manufacturer)","(Select Compliance Category)","(Select Model Year)"]
[{"$nulls":4},"Destination Account:","Manufacturer","Compliance Category","MY"]
[]
[]
[{"$nulls":4},"Destination Account:","VMTu","MPGau","MPGsu"]
[{"$nulls":5},{"$f":"IF(AND(OR(E7<>\"Carry Forward\",E7<>\"Carry Back\"),H7=\"Yes\",F19<>\"(Select Manufacturer)\",G19<>\"(Select Compliance Category)\",H19<>\"(Select MY)\"),VLOOKUP(CONCATENATE($G19,\"-\",$H19),Unique_ID_Lookup,4,FALSE),\"\")","v":""}]
[]
[{"$nulls":6},"Adjustment Factor","Final Credit Amount"]
[{"$nulls":6},{"$f":"astm(IFERROR(IF(OR(E7=\"(Select Transaction Type)\",H7=\"(Select Yes or No)\"),0,IF(OR(E7=\"Carry Forward\",E7=\"Carry Back\",H7=\"No\"),1,(F24*G15*H15)/(F15*G24*H24))),0),4)","v":{"v":0,"d":"0.0000"}},{"$f":"astm(IFERROR(F9/G27,0),0)","v":0}]
[]
[]
[{"$nulls":4},"(Select Transaction Type)",null,"(Select Type of Credits)","(Select Yes or No)"]
[{"$nulls":3},"Transaction No.","Transaction Type","Initial Credit Amount","Credit Type","Apply to Shortfall?"]
[{"$nulls":3},{"$f":"D9+1","v":4}]
[{"$nulls":5},"(Select Manufacturer)","(Select Compliance Category)","(Select Model Year)"]
[{"$nulls":4},"Earned Account:","Manufacturer","Compliance Category","MY"]
[]
[]
[{"$nulls":4},"Earned Account:","VMTe","MPGae","MPGse"]
[{"$nulls":5},{"$f":"IF(AND(OR(E30<>\"Carry Forward\",E30<>\"Carry Back\"),H30=\"Yes\",F33<>\"(Select Manufacturer)\",G33<>\"(Select Compliance Category)\",H33<>\"(Select MY)\"),VLOOKUP(CONCATENATE($G33,\"-\",$H33),Unique_ID_Lookup,4,FALSE),\"\")","v":""}]
[{"$nulls":5},"(Select Manufacturer)","(Select Compliance Category)","(Select Model Year)"]
[{"$nulls":4},"Current Account:","Manufacturer","Compliance Category","MY"]
[]
[{"$nulls":5},"(Select Manufacturer)","(Select Compliance Category)","(Select Model Year)"]
[{"$nulls":4},"Destination Account:","Manufacturer","Compliance Category","MY"]
[]
[]
[{"$nulls":4},"Destination Account:","VMTu","MPGau","MPGsu"]
[{"$nulls":5},{"$f":"IF(AND(OR(E30<>\"Carry Forward\",E30<>\"Carry Back\"),H30=\"Yes\",F42<>\"(Select Manufacturer)\",G42<>\"(Select Compliance Category)\",H42<>\"(Select MY)\"),VLOOKUP(CONCATENATE($G42,\"-\",$H42),Unique_ID_Lookup,4,FALSE),\"\")","v":""}]
[]
[{"$nulls":6},"Adjustment Factor","Final Credit Amount"]
[{"$nulls":6},{"$f":"astm(IFERROR(IF(OR(E30=\"(Select Transaction Type)\",H30=\"(Select Yes or No)\"),0,IF(OR(E30=\"Carry Forward\",E30=\"Carry Back\",H30=\"No\"),1,(F47*G38*H38)/(F38*G47*H47))),0),4)","v":{"v":0,"d":"0.0000"}},{"$f":"astm(IFERROR(H32/G50,0),0)","v":0}]
[]
[]
[]
[{"$nulls":3},"VMTe = Lifetime vehicle miles traveled as provided in the following table for the model year and compliance category in which the credit was earned;"]
[{"$nulls":3},"MPGae = Actual fuel economy for the originating manufacturer, compliance category, and model year in which the credit was earned;"]
[{"$nulls":3},"MPGse = Required fuel economy standard for the originating (earning) manufacturer, compliance category, and model year in which the credit was earned;"]
[{"$nulls":3},"VMTu = Lifetime vehicle miles traveled as provided in the following table for the model year and compliance category in which the credit is used for compliance;"]
[{"$nulls":3},"MPGau = Actual fuel economy for the user manufacturer, compliance category, and model year in which the credit is used for compliance; and"]
[{"$nulls":3},"MPGsu = Required fuel economy standard for the user (buying) manufacturer, compliance category, and model year in which the credit is used for compliance."]

{"sheet":"Transactions 5-6","index":4,"n_rows":59,"n_cols":8,"rows_kept":59,"hidden":true}
[]
[null,"United States Department of Transportation\nNational Highway Transportation Safety Administration\n\nNHTSA CAFE Credit Template (OMB Control No. 2127-0019)\nNHTSA Form Number 1475\n49 CFR 536.8, 49 CFR 536.5(d)(6), and 49 CFR 536.7\n\nVersion Number: 1.1; Last Revision: 08/30/2018; Expiration Date: xxxxxxxxxx"]
[]
[{"$nulls":3},"Transaction Date\n(mm/dd/yyyy)",{"$nulls":3},{"$f":"'Transactions 3-4'!H4+1","v":{"v":3,"d":"Page 3"}}]
[]
[]
[{"$nulls":4},"(Select Transaction Type)",null,"(Select Type of Credits)","(Select Yes or No)"]
[{"$nulls":3},"Transaction No.","Transaction Type","Initial Credit Amount","Credit Type","Apply to Shortfall?"]
[{"$nulls":3},{"$f":"'Transactions 3-4'!D32+1","v":5}]
[{"$nulls":5},"(Select Manufacturer)","(Select Compliance Category)","(Select Model Year)"]
[{"$nulls":4},"Earned Account:","Manufacturer","Compliance Category","MY"]
[]
[]
[{"$nulls":4},"Earned Account:","VMTe","MPGae","MPGse"]
[{"$nulls":5},{"$f":"IF(AND(OR(E7<>\"Carry Forward\",E7<>\"Carry Back\"),H7=\"Yes\",F10<>\"(Select Manufacturer)\",G10<>\"(Select Compliance Category)\",H10<>\"(Select MY)\"),VLOOKUP(CONCATENATE($G10,\"-\",$H10),Unique_ID_Lookup,4,FALSE),\"\")","v":""}]
[{"$nulls":5},"(Select Manufacturer)","(Select Compliance Category)","(Select Model Year)"]
[{"$nulls":4},"Current Account:","Manufacturer","Compliance Category","MY"]
[]
[{"$nulls":5},"(Select Manufacturer)","(Select Compliance Category)","(Select Model Year)"]
[{"$nulls":4},"Destination Account:","Manufacturer","Compliance Category","MY"]
[]
[]
[{"$nulls":4},"Destination Account:","VMTu","MPGau","MPGsu"]
[{"$nulls":5},{"$f":"IF(AND(OR(E7<>\"Carry Forward\",E7<>\"Carry Back\"),H7=\"Yes\",F19<>\"(Select Manufacturer)\",G19<>\"(Select Compliance Category)\",H19<>\"(Select MY)\"),VLOOKUP(CONCATENATE($G19,\"-\",$H19),Unique_ID_Lookup,4,FALSE),\"\")","v":""}]
[]
[{"$nulls":6},"Adjustment Factor","Final Credit Amount"]
[{"$nulls":6},{"$f":"astm(IFERROR(IF(OR(E7=\"(Select Transaction Type)\",H7=\"(Select Yes or No)\"),0,IF(OR(E7=\"Carry Forward\",E7=\"Carry Back\",H7=\"No\"),1,(F24*G15*H15)/(F15*G24*H24))),0),4)","v":{"v":0,"d":"0.0000"}},{"$f":"astm(IFERROR(F9/G27,0),0)","v":0}]
[]
[]
[{"$nulls":4},"(Select Transaction Type)",null,"(Select Type of Credits)","(Select Yes or No)"]
[{"$nulls":3},"Transaction No.","Transaction Type","Initial Credit Amount","Credit Type","Apply to Shortfall?"]
[{"$nulls":3},{"$f":"D9+1","v":6}]
[{"$nulls":5},"(Select Manufacturer)","(Select Compliance Category)","(Select Model Year)"]
[{"$nulls":4},"Earned Account:","Manufacturer","Compliance Category","MY"]
[]
[]
[{"$nulls":4},"Earned Account:","VMTe","MPGae","MPGse"]
[{"$nulls":5},{"$f":"IF(AND(OR(E30<>\"Carry Forward\",E30<>\"Carry Back\"),H30=\"Yes\",F33<>\"(Select Manufacturer)\",G33<>\"(Select Compliance Category)\",H33<>\"(Select MY)\"),VLOOKUP(CONCATENATE($G33,\"-\",$H33),Unique_ID_Lookup,4,FALSE),\"\")","v":""}]
[{"$nulls":5},"(Select Manufacturer)","(Select Compliance Category)","(Select Model Year)"]
[{"$nulls":4},"Current Account:","Manufacturer","Compliance Category","MY"]
[]
[{"$nulls":5},"(Select Manufacturer)","(Select Compliance Category)","(Select Model Year)"]
[{"$nulls":4},"Destination Account:","Manufacturer","Compliance Category","MY"]
[]
[]
[{"$nulls":4},"Destination Account:","VMTu","MPGau","MPGsu"]
[{"$nulls":5},{"$f":"IF(AND(OR(E30<>\"Carry Forward\",E30<>\"Carry Back\"),H30=\"Yes\",F42<>\"(Select Manufacturer)\",G42<>\"(Select Compliance Category)\",H42<>\"(Select MY)\"),VLOOKUP(CONCATENATE($G42,\"-\",$H42),Unique_ID_Lookup,4,FALSE),\"\")","v":""}]
[]
[{"$nulls":6},"Adjustment Factor","Final Credit Amount"]
[{"$nulls":6},{"$f":"astm(IFERROR(IF(OR(E30=\"(Select Transaction Type)\",H30=\"(Select Yes or No)\"),0,IF(OR(E30=\"Carry Forward\",E30=\"Carry Back\",H30=\"No\"),1,(F47*G38*H38)/(F38*G47*H47))),0),4)","v":{"v":0,"d":"0.0000"}},{"$f":"astm(IFERROR(H32/G50,0),0)","v":0}]
[]
[]
[]
[{"$nulls":3},"VMTe = Lifetime vehicle miles traveled as provided in the following table for the model year and compliance category in which the credit was earned;"]
[{"$nulls":3},"MPGae = Actual fuel economy for the originating manufacturer, compliance category, and model year in which the credit was earned;"]
[{"$nulls":3},"MPGse = Required fuel economy standard for the originating (earning) manufacturer, compliance category, and model year in which the credit was earned;"]
[{"$nulls":3},"VMTu = Lifetime vehicle miles traveled as provided in the following table for the model year and compliance category in which the credit is used for compliance;"]
[{"$nulls":3},"MPGau = Actual fuel economy for the user manufacturer, compliance category, and model year in which the credit is used for compliance; and"]
[{"$nulls":3},"MPGsu = Required fuel economy standard for the user (buying) manufacturer, compliance category, and model year in which the credit is used for compliance."]

{"sheet":"Transactions 7-8","index":5,"n_rows":59,"n_cols":8,"rows_kept":59,"hidden":true}
[]
[null,"United States Department of Transportation\nNational Highway Transportation Safety Administration\n\nNHTSA CAFE Credit Template (OMB Control No. 2127-0019)\nNHTSA Form Number 1475\n49 CFR 536.8, 49 CFR 536.5(d)(6), and 49 CFR 536.7\n\nVersion Number: 1.1; Last Revision: 08/30/2018; Expiration Date: xxxxxxxxxx"]
[]
[{"$nulls":3},"Transaction Date\n(mm/dd/yyyy)",{"$nulls":3},{"$f":"'Transactions 5-6'!H4+1","v":{"v":4,"d":"Page 4"}}]
[]
[]
[{"$nulls":4},"(Select Transaction Type)",null,"(Select Type of Credits)","(Select Yes or No)"]
[{"$nulls":3},"Transaction No.","Transaction Type","Initial Credit Amount","Credit Type","Apply to Shortfall?"]
[{"$nulls":3},{"$f":"'Transactions 5-6'!D32+1","v":7}]
[{"$nulls":5},"(Select Manufacturer)","(Select Compliance Category)","(Select Model Year)"]
[{"$nulls":4},"Earned Account:","Manufacturer","Compliance Category","MY"]
[]
[]
[{"$nulls":4},"Earned Account:","VMTe","MPGae","MPGse"]
[{"$nulls":5},{"$f":"IF(AND(OR(E7<>\"Carry Forward\",E7<>\"Carry Back\"),H7=\"Yes\",F10<>\"(Select Manufacturer)\",G10<>\"(Select Compliance Category)\",H10<>\"(Select MY)\"),VLOOKUP(CONCATENATE($G10,\"-\",$H10),Unique_ID_Lookup,4,FALSE),\"\")","v":""}]
[{"$nulls":5},"(Select Manufacturer)","(Select Compliance Category)","(Select Model Year)"]
[{"$nulls":4},"Current Account:","Manufacturer","Compliance Category","MY"]
[]
[{"$nulls":5},"(Select Manufacturer)","(Select Compliance Category)","(Select Model Year)"]
[{"$nulls":4},"Destination Account:","Manufacturer","Compliance Category","MY"]
[]
[]
[{"$nulls":4},"Destination Account:","VMTu","MPGau","MPGsu"]
[{"$nulls":5},{"$f":"IF(AND(OR(E7<>\"Carry Forward\",E7<>\"Carry Back\"),H7=\"Yes\",F19<>\"(Select Manufacturer)\",G19<>\"(Select Compliance Category)\",H19<>\"(Select MY)\"),VLOOKUP(CONCATENATE($G19,\"-\",$H19),Unique_ID_Lookup,4,FALSE),\"\")","v":""}]
[]
[{"$nulls":6},"Adjustment Factor","Final Credit Amount"]
[{"$nulls":6},{"$f":"astm(IFERROR(IF(OR(E7=\"(Select Transaction Type)\",H7=\"(Select Yes or No)\"),0,IF(OR(E7=\"Carry Forward\",E7=\"Carry Back\",H7=\"No\"),1,(F24*G15*H15)/(F15*G24*H24))),0),4)","v":{"v":0,"d":"0.0000"}},{"$f":"astm(IFERROR(F9/G27,0),0)","v":0}]
[]
[]
[{"$nulls":4},"(Select Transaction Type)",null,"(Select Type of Credits)","(Select Yes or No)"]
[{"$nulls":3},"Transaction No.","Transaction Type","Initial Credit Amount","Credit Type","Apply to Shortfall?"]
[{"$nulls":3},{"$f":"D9+1","v":8}]
[{"$nulls":5},"(Select Manufacturer)","(Select Compliance Category)","(Select Model Year)"]
[{"$nulls":4},"Earned Account:","Manufacturer","Compliance Category","MY"]
[]
[]
[{"$nulls":4},"Earned Account:","VMTe","MPGae","MPGse"]
[{"$nulls":5},{"$f":"IF(AND(OR(E30<>\"Carry Forward\",E30<>\"Carry Back\"),H30=\"Yes\",F33<>\"(Select Manufacturer)\",G33<>\"(Select Compliance Category)\",H33<>\"(Select MY)\"),VLOOKUP(CONCATENATE($G33,\"-\",$H33),Unique_ID_Lookup,4,FALSE),\"\")","v":""}]
[{"$nulls":5},"(Select Manufacturer)","(Select Compliance Category)","(Select Model Year)"]
[{"$nulls":4},"Current Account:","Manufacturer","Compliance Category","MY"]
[]
[{"$nulls":5},"(Select Manufacturer)","(Select Compliance Category)","(Select Model Year)"]
[{"$nulls":4},"Destination Account:","Manufacturer","Compliance Category","MY"]
[]
[]
[{"$nulls":4},"Destination Account:","VMTu","MPGau","MPGsu"]
[{"$nulls":5},{"$f":"IF(AND(OR(E30<>\"Carry Forward\",E30<>\"Carry Back\"),H30=\"Yes\",F42<>\"(Select Manufacturer)\",G42<>\"(Select Compliance Category)\",H42<>\"(Select MY)\"),VLOOKUP(CONCATENATE($G42,\"-\",$H42),Unique_ID_Lookup,4,FALSE),\"\")","v":""}]
[]
[{"$nulls":6},"Adjustment Factor","Final Credit Amount"]
[{"$nulls":6},{"$f":"astm(IFERROR(IF(OR(E30=\"(Select Transaction Type)\",H30=\"(Select Yes or No)\"),0,IF(OR(E30=\"Carry Forward\",E30=\"Carry Back\",H30=\"No\"),1,(F47*G38*H38)/(F38*G47*H47))),0),4)","v":{"v":0,"d":"0.0000"}},{"$f":"astm(IFERROR(H32/G50,0),0)","v":0}]
[]
[]
[]
[{"$nulls":3},"VMTe = Lifetime vehicle miles traveled as provided in the following table for the model year and compliance category in which the credit was earned;"]
[{"$nulls":3},"MPGae = Actual fuel economy for the originating manufacturer, compliance category, and model year in which the credit was earned;"]
[{"$nulls":3},"MPGse = Required fuel economy standard for the originating (earning) manufacturer, compliance category, and model year in which the credit was earned;"]
[{"$nulls":3},"VMTu = Lifetime vehicle miles traveled as provided in the following table for the model year and compliance category in which the credit is used for compliance;"]
[{"$nulls":3},"MPGau = Actual fuel economy for the user manufacturer, compliance category, and model year in which the credit is used for compliance; and"]
[{"$nulls":3},"MPGsu = Required fuel economy standard for the user (buying) manufacturer, compliance category, and model year in which the credit is used for compliance."]

{"sheet":"Transactions 9-10","index":6,"n_rows":59,"n_cols":8,"rows_kept":59,"hidden":true}
[]
[null,"United States Department of Transportation\nNational Highway Transportation Safety Administration\n\nNHTSA CAFE Credit Template (OMB Control No. 2127-0019)\nNHTSA Form Number 1475\n49 CFR 536.8, 49 CFR 536.5(d)(6), and 49 CFR 536.7\n\nVersion Number: 1.1; Last Revision: 08/30/2018; Expiration Date: xxxxxxxxxx"]
[]
[{"$nulls":3},"Transaction Date\n(mm/dd/yyyy)",{"$nulls":3},{"$f":"'Transactions 7-8'!H4+1","v":{"v":5,"d":"Page 5"}}]
[]
[]
[{"$nulls":4},"(Select Transaction Type)",null,"(Select Type of Credits)","(Select Yes or No)"]
[{"$nulls":3},"Transaction No.","Transaction Type","Initial Credit Amount","Credit Type","Apply to Shortfall?"]
[{"$nulls":3},{"$f":"'Transactions 7-8'!D32+1","v":9}]
[{"$nulls":5},"(Select Manufacturer)","(Select Compliance Category)","(Select Model Year)"]
[{"$nulls":4},"Earned Account:","Manufacturer","Compliance Category","MY"]
[]
[]
[{"$nulls":4},"Earned Account:","VMTe","MPGae","MPGse"]
[{"$nulls":5},{"$f":"IF(AND(OR(E7<>\"Carry Forward\",E7<>\"Carry Back\"),H7=\"Yes\",F10<>\"(Select Manufacturer)\",G10<>\"(Select Compliance Category)\",H10<>\"(Select MY)\"),VLOOKUP(CONCATENATE($G10,\"-\",$H10),Unique_ID_Lookup,4,FALSE),\"\")","v":""}]
[{"$nulls":5},"(Select Manufacturer)","(Select Compliance Category)","(Select Model Year)"]
[{"$nulls":4},"Current Account:","Manufacturer","Compliance Category","MY"]
[]
[{"$nulls":5},"(Select Manufacturer)","(Select Compliance Category)","(Select Model Year)"]
[{"$nulls":4},"Destination Account:","Manufacturer","Compliance Category","MY"]
[]
[]
[{"$nulls":4},"Destination Account:","VMTu","MPGau","MPGsu"]
[{"$nulls":5},{"$f":"IF(AND(OR(E7<>\"Carry Forward\",E7<>\"Carry Back\"),H7=\"Yes\",F19<>\"(Select Manufacturer)\",G19<>\"(Select Compliance Category)\",H19<>\"(Select MY)\"),VLOOKUP(CONCATENATE($G19,\"-\",$H19),Unique_ID_Lookup,4,FALSE),\"\")","v":""}]
[]
[{"$nulls":6},"Adjustment Factor","Final Credit Amount"]
[{"$nulls":6},{"$f":"astm(IFERROR(IF(OR(E7=\"(Select Transaction Type)\",H7=\"(Select Yes or No)\"),0,IF(OR(E7=\"Carry Forward\",E7=\"Carry Back\",H7=\"No\"),1,(F24*G15*H15)/(F15*G24*H24))),0),4)","v":{"v":0,"d":"0.0000"}},{"$f":"astm(IFERROR(F9/G27,0),0)","v":0}]
[]
[]
[{"$nulls":4},"(Select Transaction Type)",null,"(Select Type of Credits)","(Select Yes or No)"]
[{"$nulls":3},"Transaction No.","Transaction Type","Initial Credit Amount","Credit Type","Apply to Shortfall?"]
[{"$nulls":3},{"$f":"D9+1","v":10}]
[{"$nulls":5},"(Select Manufacturer)","(Select Compliance Category)","(Select Model Year)"]
[{"$nulls":4},"Earned Account:","Manufacturer","Compliance Category","MY"]
[]
[]
[{"$nulls":4},"Earned Account:","VMTe","MPGae","MPGse"]
[{"$nulls":5},{"$f":"IF(AND(OR(E30<>\"Carry Forward\",E30<>\"Carry Back\"),H30=\"Yes\",F33<>\"(Select Manufacturer)\",G33<>\"(Select Compliance Category)\",H33<>\"(Select MY)\"),VLOOKUP(CONCATENATE($G33,\"-\",$H33),Unique_ID_Lookup,4,FALSE),\"\")","v":""}]
[{"$nulls":5},"(Select Manufacturer)","(Select Compliance Category)","(Select Model Year)"]
[{"$nulls":4},"Current Account:","Manufacturer","Compliance Category","MY"]
[]
[{"$nulls":5},"(Select Manufacturer)","(Select Compliance Category)","(Select Model Year)"]
[{"$nulls":4},"Destination Account:","Manufacturer","Compliance Category","MY"]
[]
[]
[{"$nulls":4},"Destination Account:","VMTu","MPGau","MPGsu"]
[{"$nulls":5},{"$f":"IF(AND(OR(E30<>\"Carry Forward\",E30<>\"Carry Back\"),H30=\"Yes\",F42<>\"(Select Manufacturer)\",G42<>\"(Select Compliance Category)\",H42<>\"(Select MY)\"),VLOOKUP(CONCATENATE($G42,\"-\",$H42),Unique_ID_Lookup,4,FALSE),\"\")","v":""}]
[]
[{"$nulls":6},"Adjustment Factor","Final Credit Amount"]
[{"$nulls":6},{"$f":"astm(IFERROR(IF(OR(E30=\"(Select Transaction Type)\",H30=\"(Select Yes or No)\"),0,IF(OR(E30=\"Carry Forward\",E30=\"Carry Back\",H30=\"No\"),1,(F47*G38*H38)/(F38*G47*H47))),0),4)","v":{"v":0,"d":"0.0000"}},{"$f":"astm(IFERROR(H32/G50,0),0)","v":0}]
[]
[]
[]
[{"$nulls":3},"VMTe = Lifetime vehicle miles traveled as provided in the following table for the model year and compliance category in which the credit was earned;"]
[{"$nulls":3},"MPGae = Actual fuel economy for the originating manufacturer, compliance category, and model year in which the credit was earned;"]
[{"$nulls":3},"MPGse = Required fuel economy standard for the originating (earning) manufacturer, compliance category, and model year in which the credit was earned;"]
[{"$nulls":3},"VMTu = Lifetime vehicle miles traveled as provided in the following table for the model year and compliance category in which the credit is used for compliance;"]
[{"$nulls":3},"MPGau = Actual fuel economy for the user manufacturer, compliance category, and model year in which the credit is used for compliance; and"]
[{"$nulls":3},"MPGsu = Required fuel economy standard for the user (buying) manufacturer, compliance category, and model year in which the credit is used for compliance."]

{"sheet":"Joint Trade Instructions","index":7,"n_rows":48,"n_cols":20,"rows_kept":48,"hidden":true,"merged":[[1,1,1,20],[5,2,5,5],[5,7,5,10],[5,11,7,19],[10,2,10,3],[10,7,10,8],[14,2,14,3],[18,11,18,12],[18,16,18,17],[23,11,24,19],[25,2,30,10],[28,11,28,14],[28,16,28,19],[33,2,35,10],[33,11,33,12],[33,16,33,17],[39,3,43,10],[47,3,51,10]]}
[]
[null,"United States Department of Transportation\nNational Highway Transportation Safety Administration\n\nNHTSA CAFE Credit Template (OMB Control No. xxxx-xxxx)\n49 CFR 536.8, 49 CFR 536.5(d)(6), and 49 CFR 536.7\n\nVersion Number: 1.0; Last Revision: 04/25/2018"]
[]
[{"$nulls":6},"JOINT TRADE INSTRUCTIONS",{"$nulls":3},"OMB Control No. xxxx-xxxx",{"$nulls":4},"JOINT TRADE INSTRUCTIONS",{"$nulls":3},"OMB Control No. xxxx-xxxx"]
[]
[null,null,"Credit Holder",{"$nulls":4},"Credit Receiver",{"$nulls":3},"Accordingly, we request that NHTSA accept this joint instruction and process the transaction as appropriate in accordance with 49 CFR Part 536.8."]
[null,null,{"$f":"Name_Holder","v":0},{"$nulls":4},{"$f":"Name_Receiver","v":0}]
[null,null,{"$f":"Address1_Holder","v":0},{"$nulls":4},{"$f":"Address1_Receiver","v":0}]
[null,null,{"$f":"Address2_Holder","v":0},{"$nulls":4},{"$f":"Address2_Receiver","v":0}]
[null,null,{"$f":"CONCATENATE(City_Holder,\", \",State_Holder,\" \",Zip_Holder)","v":", (Select State) "},{"$nulls":4},{"$f":"CONCATENATE(City_Receiver,\", \",State_Receiver,\" \",Zip_Receiver)","v":", (Select State) "},{"$nulls":3},"Regards,"]
[null,null,{"$f":"Phone_Holder","v":0},{"$nulls":4},{"$f":"Phone_Receiver","v":0}]
[]
[]
[{"$nulls":11},"Signature:",{"$nulls":4},"Signature:"]
[null,null,{"$f":"Date","v":"00:00:00"},{"$nulls":8},{"$f":"Signatory_Name_Holder","v":0},{"$nulls":4},{"$f":"Signatory_Name_Receiver","v":0}]
[{"$nulls":11},{"$f":"Signatory_Title_Holder","v":0},{"$nulls":4},{"$f":"Signatory_Title_Receiver","v":0}]
[null,null,"Associate Administrator for Enforcement",{"$nulls":8},{"$f":"Signatory_Dept_Holder","v":0},{"$nulls":4},{"$f":"Signatory_Dept_Receiver","v":0}]
[null,null,"National Highway Traffic Safety Administration",{"$nulls":8},{"$f":"Signatory_Company_Holder","v":0},{"$nulls":4},{"$f":"Signatory_Company_Receiver","v":0}]
[null,null,"1200 New Jersey Avenue, SE",{"$nulls":8},{"$f":"Signatory_Date_Holder","v":"00:00:00"},{"$nulls":4},{"$f":"Signatory_Date_Receiver","v":"00:00:00"}]
[null,null,"Washington, DC 20590"]
[]
[null,null,"Subject: CAFE Credit Trade Agreement"]
[]
[null,null,"Dear Associate Administrator,",{"$nulls":8},"If you have additional instructions, guidance, questions, or comments please contact the appropriate point of contact provided below."]
[]
[null,null,{"$f":"CONCATENATE(\"This letter is to inform the National Highway Traffic Safety Administration (NHTSA) that \",Name_Holder,\" and \",Name_Receiver,\" are submitting this Credit Trade Agreement as joint CAFE credit trading instructions to NHTSA in accordance with 49 CFR Part 536.8. This joint instruction requests that NHTSA transfer certain credits from \",Name_Holder,\"'s CAFE credit account(s) with NHTSA to \",Name_Receiver,\"'s CAFE credit account(s) with NHTSA as specified in the attached Credit Transaction Request.\")","v":"This letter is to inform the National Highway Traffic Safety Administration (NHTSA) that  and  are submitting this Credit Trade Agreement as joint CAFE credit trading instructions to NHTSA in accordance with 49 CFR Part 536.8. This joint instruction requests that NHTSA transfer certain credits from 's CAFE credit account(s) with NHTSA to 's CAFE credit account(s) with NHTSA as specified in the attached Credit Transaction Request."}]
[]
[]
[{"$nulls":11},"Credit Holder Point of Contact",{"$nulls":4},"Credit Receiver Point of Contact"]
[{"$nulls":11},{"$f":"POC_Name_Holder","v":0},{"$nulls":4},{"$f":"POC_Name_Receiver","v":0}]
[{"$nulls":11},{"$f":"POC_Title_Holder","v":0},{"$nulls":4},{"$f":"POC_Title_Receiver","v":0}]
[{"$nulls":11},{"$f":"POC_Dept_Holder","v":0},{"$nulls":4},{"$f":"POC_Dept_Receiver","v":0}]
[{"$nulls":11},{"$f":"POC_Company_Holder","v":0},{"$nulls":4},{"$f":"POC_Company_Receiver","v":0}]
[null,null,{"$f":"CONCATENATE(Name_Holder,\" affirms the current CAFE credit balance(s) in its account(s) are sufficient to support this transaction. \",Name_Receiver,\" and \",Name_Receiver,\" acknowledge the following:\")","v":" affirms the current CAFE credit balance(s) in its account(s) are sufficient to support this transaction.  and  acknowledge the following:"},{"$nulls":8},{"$f":"POC_Phone_Holder","v":0},{"$nulls":4},{"$f":"POC_Phone_Receiver","v":0}]
[{"$nulls":11},{"$f":"POC_Email_Holder","v":0},{"$nulls":4},{"$f":"POC_Email_Receiver","v":0}]
[]
[]
[]
[{"$nulls":3},"49 CFR Part 536.8(f)"]
[{"$nulls":3},"If NHTSA determines that a manufacturer has been credited, through error or fraud, with earning credits, NHTSA will cancel those credits if possible. If the manufacturer credited with having earned those credits has already traded them when the error or fraud is discovered, NHTSA will hold the receiving manufacturer responsible for returning the same or equivalent credits to NHTSA for cancellation."]
[]
[]
[]
[{"$nulls":11},"Enclosure(s)"]
[]
[]
[{"$nulls":3},"49 CFR Part 536.8(g)"]
[{"$nulls":3},"In general, all trades are final and irrevocable once executed, and may only be reversed by a new, mutually-agreed transaction. If NHTSA executes an erroneous instruction to trade credits from one holder to another through error or fraud, NHTSA will reverse the transaction if possible.  If those credits have been traded away, the recipient holder is responsible for obtaining the same or equivalent credits for return to the previous holder."]

{"sheet":"Supporting","index":8,"n_rows":57,"n_cols":21,"rows_kept":57}
["United States Department of Transportation\nNational Highway Transportation Safety Administration\n\nNHTSA CAFE Credit Template (OMB Control No. 2127-0019)\nNHTSA Form Number 1475\n49 CFR 536.8, 49 CFR 536.5(d)(6), and 49 CFR 536.7\n\nVersion Number: 1.1; Last Revision: 08/30/2018; Expiration Date: xxxxxxxxxx"]
[]
[null,"Unique ID","Compliance Category","MY","VMT\n(mi)",null,"Manufacturer",null,"Compliance Category",null,"MY",null,"Transaction Type",null,"Credit Type",null,"Yes-No Toggle",null,"State",null,"No. of Transactions"]
[null,{"$f":"CONCATENATE(C4,\"-\",D4)","v":"Domestic Passenger-2011"},"Domestic Passenger",2011,{"v":150922,"d":"150,922"},null,"(Select Manufacturer)",null,"(Select Compliance Category)",null,"(Select MY)",null,"(Select Transaction Type)",null,"(Select Type of Credits)",null,"(Select Yes or No)",null,"(Select State)",null,"(Select No. of Transactions)"]
[null,{"$f":"CONCATENATE(C5,\"-\",D5)","v":"Domestic Passenger-2012"},"Domestic Passenger",2012,{"v":177238,"d":"177,238"},null,"Aston Martin",null,"Domestic Passenger",null,2011,null,"Trade",null,"Earned",null,"Yes",null,"AL",null,"One"]
[null,"Domestic Passenger-2013","Domestic Passenger",2013,{"v":177366,"d":"177,366"},null,"BMW",null,"Import Passenger",null,2012,null,"Transfer",null,"Banked",null,"No",null,"AK",null,"Two"]
[null,"Domestic Passenger-2014","Domestic Passenger",2014,{"v":178652,"d":"178,652"},null,"Daimler",null,"Light Truck",null,2013,null,"Carry Forward",{"$nulls":5},"AZ",null,"Three"]
[null,"Domestic Passenger-2015","Domestic Passenger",2015,{"v":180497,"d":"180,497"},null,"Fiat Chrysler",{"$nulls":3},2014,null,"Carry Back",{"$nulls":5},"AR",null,"Four"]
[null,"Domestic Passenger-2016","Domestic Passenger",2016,{"v":182134,"d":"182,134"},null,"Ford",{"$nulls":3},2015,null,"Application",{"$nulls":5},"CA",null,"Five"]
[null,"Domestic Passenger-2017","Domestic Passenger",2017,{"v":195264,"d":"195,264"},null,"General Motors",{"$nulls":3},2016,{"$nulls":7},"CO",null,"Six"]
[null,"Domestic Passenger-2018","Domestic Passenger",2018,{"v":195264,"d":"195,264"},null,"Honda",{"$nulls":3},2017,{"$nulls":7},"CT",null,"Seven"]
[null,"Domestic Passenger-2019","Domestic Passenger",2019,{"v":195264,"d":"195,264"},null,"Hyundai",{"$nulls":3},2018,{"$nulls":7},"DE",null,"Eight"]
[null,"Domestic Passenger-2020","Domestic Passenger",2020,{"v":195264,"d":"195,264"},null,"Jaguar Land Rover",{"$nulls":3},2019,{"$nulls":7},"DC",null,"Nine"]
[null,"Domestic Passenger-2021","Domestic Passenger",2021,{"v":195264,"d":"195,264"},null,"Kia",{"$nulls":3},2020,{"$nulls":7},"FL",null,"Ten"]
[null,"Domestic Passenger-2022","Domestic Passenger",2022,{"v":195264,"d":"195,264"},null,"Koenigsegg",{"$nulls":3},2021,{"$nulls":7},"GA"]
[null,"Domestic Passenger-2023","Domestic Passenger",2023,{"v":195264,"d":"195,264"},null,"Mazda",{"$nulls":3},2022,{"$nulls":7},"HI"]
[null,"Domestic Passenger-2024","Domestic Passenger",2024,{"v":195264,"d":"195,264"},null,"Mitsubishi",{"$nulls":3},2023,{"$nulls":7},"ID"]
[null,"Domestic Passenger-2025","Domestic Passenger",2025,{"v":195264,"d":"195,264"},null,"Mobility Ventures",{"$nulls":3},2024,{"$nulls":7},"IL"]
[null,"Import Passenger-2011","Import Passenger",2011,{"v":150922,"d":"150,922"},null,"Nissan",{"$nulls":3},2025,{"$nulls":7},"IN"]
[null,"Import Passenger-2012","Import Passenger",2012,{"v":177238,"d":"177,238"},null,"Subaru",{"$nulls":11},"IA"]
[null,"Import Passenger-2013","Import Passenger",2013,{"v":177366,"d":"177,366"},null,"Tesla",{"$nulls":11},"KS"]
[null,"Import Passenger-2014","Import Passenger",2014,{"v":178652,"d":"178,652"},null,"Toyota",{"$nulls":11},"KY"]
[null,"Import Passenger-2015","Import Passenger",2015,{"v":180497,"d":"180,497"},null,"Volkswagen",{"$nulls":11},"LA"]
[null,"Import Passenger-2016","Import Passenger",2016,{"v":182134,"d":"182,134"},{"$nulls":13},"ME"]
[null,"Import Passenger-2017","Import Passenger",2017,{"v":195264,"d":"195,264"},{"$nulls":13},"MD"]
[null,"Import Passenger-2018","Import Passenger",2018,{"v":195264,"d":"195,264"},{"$nulls":13},"MA"]
[null,"Import Passenger-2019","Import Passenger",2019,{"v":195264,"d":"195,264"},{"$nulls":13},"MI"]
[null,"Import Passenger-2020","Import Passenger",2020,{"v":195264,"d":"195,264"},{"$nulls":13},"MN"]
[null,"Import Passenger-2021","Import Passenger",2021,{"v":195264,"d":"195,264"},{"$nulls":13},"MS"]
[null,"Import Passenger-2022","Import Passenger",2022,{"v":195264,"d":"195,264"},{"$nulls":13},"MO"]
[null,"Import Passenger-2023","Import Passenger",2023,{"v":195264,"d":"195,264"},{"$nulls":13},"MT"]
[null,"Import Passenger-2024","Import Passenger",2024,{"v":195264,"d":"195,264"},{"$nulls":13},"NE"]
[null,"Import Passenger-2025","Import Passenger",2025,{"v":195264,"d":"195,264"},{"$nulls":13},"NV"]
[null,"Light Truck-2011","Light Truck",2011,{"v":172552,"d":"172,552"},{"$nulls":13},"NH"]
[null,"Light Truck-2012","Light Truck",2012,{"v":208471,"d":"208,471"},{"$nulls":13},"NJ"]
[null,"Light Truck-2013","Light Truck",2013,{"v":208537,"d":"208,537"},{"$nulls":13},"NM"]
[null,"Light Truck-2014","Light Truck",2014,{"v":209974,"d":"209,974"},{"$nulls":13},"NY"]
[null,"Light Truck-2015","Light Truck",2015,{"v":212040,"d":"212,040"},{"$nulls":13},"NC"]
[null,"Light Truck-2016","Light Truck",2016,{"v":213954,"d":"213,954"},{"$nulls":13},"ND"]
[null,"Light Truck-2017","Light Truck",2017,{"v":225865,"d":"225,865"},{"$nulls":13},"OH"]
[null,"Light Truck-2018","Light Truck",2018,{"v":225865,"d":"225,865"},{"$nulls":13},"OK"]
[null,"Light Truck-2019","Light Truck",2019,{"v":225865,"d":"225,865"},{"$nulls":13},"OR"]
[null,"Light Truck-2020","Light Truck",2020,{"v":225865,"d":"225,865"},{"$nulls":13},"PA"]
[null,"Light Truck-2021","Light Truck",2021,{"v":225865,"d":"225,865"},{"$nulls":13},"PR"]
[null,"Light Truck-2022","Light Truck",2022,{"v":225865,"d":"225,865"},{"$nulls":13},"RI"]
[null,"Light Truck-2023","Light Truck",2023,{"v":225865,"d":"225,865"},{"$nulls":13},"SC"]
[null,"Light Truck-2024","Light Truck",2024,{"v":225865,"d":"225,865"},{"$nulls":13},"SD"]
[null,"Light Truck-2025","Light Truck",2025,{"v":225865,"d":"225,865"},{"$nulls":13},"TN"]
[{"$nulls":18},"TX"]
[{"$nulls":18},"UT"]
[{"$nulls":18},"VT"]
[{"$nulls":18},"VA"]
[{"$nulls":18},"VI"]
[{"$nulls":18},"WA"]
[{"$nulls":18},"WV"]
[{"$nulls":18},"WI"]
[{"$nulls":18},"WY"]