jagomart
digital resources
picture1_Excel Report Sample Download 6396 | Reporting Spreadsheet - Standar Format


 279x       Filetype XLS       File size 1.82 MB       Source: epact.energy.gov


File: Excel Report Sample Download 6396 | Reporting Spreadsheet - Standar Format
1655965801 reporting spreadsheet standar formatxls standard compliance reporting spreadsheet alternative fuel vehicle credits the us office of management and budget omb approved this data collection under control number 19105101 you ...

icon picture XLS Filetype Excel XLS | Posted on 23 Jun 2022 | 3 years ago
Partial file snippet.
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           1655965801_reporting_spreadsheet_-_Standar_Format.xls
                                                                                                                                                                                                                                                                                                                                                                                                                           Standard Compliance Reporting Spreadsheet
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              Alternative Fuel Vehicle Credits
                                                                                                                                                           The U.S. Office of Management and Budget (OMB) approved this data collection under control number 1910-5101. You are not required to respond to this collection of information 
                                                                                                                                                           unless it displays a currently valid OMB control number. Reporting takes about five hours per session. For help with reporting, access guidance documents at 
                                                                                                                                                           http://www.eere.energy.gov/vehiclesandfuels/epact/guidance_documents.html. OMB #: 1910-5101 | Expires: 10/31/2021
                                                                                                                                                           To submit your annual report using this spreadsheet, insert your data, save it on your computer, and email the completed spreadsheet to epact.sfp.fleets@nrel.gov. Before you fill out the form, you may 
                                                                                                                                                           want to save the original form as a distinct file for future use.
                                                                         PLEASE DO NOT CHANGE ANY OF THE CELLS (e.g., by moving them or changing their formatting) OTHER THAN TO INSERT YOUR DATA IN THE APPROPRIATE CELLS. 
                                                                         COLOR KEY                                                                                                                                                                                                                        Input cells
                                                                                                                                                                                                                                                                                                          Calculated cells (Do not enter values in these cells.)
                                                                                                                                                                                                                                                                                                          Problem flag (e.g., missing data)
                                                                                                                                                           underlined text                                                                                                                                Links to definitions or other locations in the workbook
                                                                                                                                                           *                                                                                                                                              Required field
                                                                         Fleet Identification (required field)                                                                                                                                                                                                                                                                                                                                                                                                                         Point of Contact Information
                                                                                                                                                                                                                            Fleet ID Number                                                                                                                                                                                                                                                                                                                                                                                               POC ID Number
                                                                                                                                                                                                                                         * Fleet Name                                                                                                                                                                                                                                                                                                                                                                                                                        * Name
                                                                                                                                                                                                                                               Local Name                                                                                                                                                                                                                                                                                             Mailing Address (if different from 
                                                                                                                                                                                                         Parent Organization                                                                                                                                                                                                                                                                                                                                                                              fleet mailing address)
                                                                                                                                                                                                                                               * Fleet Type P
                                                                                                                                                                                                                     * Mailing Address                                                                                                                                                                                                                                                                                                                                                                                                                                                        City
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       State
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  ZIP (xxxxx-xxxx)
                                                                                                                                                                                                                                                                            * City                                                                                                                                                                                                                                                                                                                                                                                         * Phone
                                                                                                                                                                                                                                                                      * State                                                                                                                                                                                                                                                                                                                                                                                                                   Fax
                                                                                                                                                                                                                * ZIP (xxxxx-xxxx)                                                                                                                                                                                                                                                                                                                                                                                                                                            * Email
                                                                         (Parent Organization is parent company name, if applicable, for alternative fuel provider fleet or state name for state fleet)
                                                                                                                                                                                                                               Banked Credits                                                                                                                                                                                                0 more info                                                                               Optional. Enter the number of banked credits from previous 
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       year's report.
                                                                                                                                                                   Make credit balance public? No                                                                                                                                                                                                                                                      more info                                                                        
                                                                                                                                                                                                                                                                                                                                                                                                                                                       more info
                                                                         If this is the first year in which you have a vehicle-acquisition requirement 
                                                                         (first reporting year), you may be able to obtain credit for alternative fuel 
                                                                         vehicles (AFVs) you acquired before you were subject to reporting.
                                                                         Model Year Data                                                                                                                                                                                                                  See guidance for more information                                                                                                                                                                                            http://www.eere.energy.gov/vehiclesandfuels/epact/guidance_documents.html
                                                                                                                                                                                    Reporting Model Year                                                                                                                                                                                                                      2021                                                                                                                        9/1/2020                                                                                               to                                                                                8/31/2021
                                                                                                                                             Light-Duty Vehicles Acquired                                                                                                                                                                                                                                                                              more info
                                                                                     Reporting Model Year AFV-Acquisition                                                                                                                                                                                                                                                                                                                  0more info                                                                                  The "Fleet Type" box  in the "Fleet Identification" section above must be filled in.
                                                                                                                                                                                                                              Requirement
                                                                         Annual Report Data for Model 
                                                                         Year 2021
                                                                         Light Duty Alternative Fuel Vehicles and AFV                                                                                                                                                                                                                                                       0                                                                                                                                                          Go to  "Light Duty Vehicles" sheet to enter or view details on Light Duty Alternative Fuel Vehicles and non-AFV Electric vehicles acquired
                                                                         Credits for non-AFV Electric vehicles acquired
                                                                         AFV Credits Obtained for Acquisition of                                                                                                                                                                                                                                                            0                                                                          more info                                                                       Go to  " Med-Hvy Veh" sheet to enter or view medium or heavy duty vehicles
                                                                         Medium and Heavy Duty Vehicles
                                                                         Biodiesel Use
                                                                                                                                                           0                          Biodiesel purchased for use  in on-road, medium or heavy duty (>8,500 lb) vehicles, and used at blend levels of B20 or higher
                                                                                                                                                                                                                                                                                                                            Percentage of Pure                                                                                                                    Gallons of Biodiesel Blend 
                                                                                                                                                                                                                                                                                                            Biodiesel (B100) in Blend  (B20 or higher) Purchased for 
                                                                                                                                                           Biodiesel Blend                                                                                                                                            (% by volume). Blend                                                                                                                  Use in Reporting Model Year  Gallons of B100
                                                                                                                                                                                                                                                                                                                      must be 20% or more                                                                                                                                                                                 2021
                                                                                                                                                                                                                                                                                                                                                                 B100
                                                                         Example                                                                           Tank 1 blend                                                                                                                                                                                                                                                                  20                                                                                2250                                                                                                                                                               450
                                                                                                                                                                                                                                                                                                                            Percentage of Pure                                                                                                                    Gallons of Biodiesel Blend 
                                                                         Fill in this                                                                                                                                                                                                                       Biodiesel (B100) in Blend  (B20 or higher) Purchased for 
                                                                         table                                                                             Biodiesel Blend                                                                                                                                            (% by volume). Blend                                                                                                                  Use in Reporting Model Year  Gallons of B100
                                                                                                                                                                                                                                                                                                                      must be 20% or more                                                                                                                                                                                 2021
                                                                                                                                                                                                                                                                                                                                                                 B100
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          0
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          0
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          0
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          0
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           Total                                                                                                                                                                          0
                                                                                                                       Biodiesel Used (gallons of B100):                                                                                                                                                                                                                    0
                                                                                                                                                                                                                                                                                                                                                                                                                                                       One AFV credit is obtained for each 450 gallons of pure biodiesel (B100) use 
                                                                                                                                                                                                             Biodiesel Credits                                                                                                                                              0                                                                          up to 50% of the AFV acquisition requirement Check the biodiesel use 
                                                                                                                                                                                                                                                                                                                                                                                                                                                       checkbox above to get credit (line 48)
                                                                                                           AFV credits obtained for investment in                                                                                                                                                                                                                           0
                                                                                                                                                        Emerging Technology Vehicles
                                                                                    AFV credits obtained for acquisition of light                                                                                                                                                                                                                                           0                                                                          Go to  "LD Emerging Technology Vehicles" sheet to enter or view light duty emerging technology vehicles
                                                                                                                                 duty emerging technology vehicles
                                                                                    Credits obtained for investment in qualifying                                                                                                                                                                                                                                           0                                                                          Go to  "Refueling Infrastructure" sheet to enter information
                                                                                                                                    alternative refueling infrastructure
                                                                                    Credits obtained for investment in qualifying                                                                                                                                                                                                                                           0                                                                          Go to  "Alt Fuel Non-Road Equipment" sheet to enter or view non-road equipment information
                                                                                                                            alternative fuel non-road equipment
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    Page 1
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           1655965801_reporting_spreadsheet_-_Standar_Format.xls
                                                                                                                                                                                                                                                                                                                                                                                                                                                       Investments less than $25,000 in each of the 
                                                                                        AFV credit from aggregation of investments                                                                                                                                                                                                                                          0                                                                          investment categories above may be aggregated to 
                                                                                                                                                                                                                                                                                                                                                                                                                                                       obtain additional credit.
                                                                                                                                                                          Total AFVs and AFV credits                                                                                                                                                                        0                                                                          Sum of all categories rounded to the nearest whole 
                                                                                                                                                                                                                                                                                                                                                                                                                                                       number
                                                                                                                                                                                                                                                                                                                                                                                                                                                       Credits toward requirement include all light duty creditable vehicles 
                                                                                                                                                                                                                                                                                                                                                                                                                                                       acquired during the model year (as shown on the "Alternative Fuel LDVs" 
                                                                                                                  Credits Toward Requirement                                                                                                                                                                                                                                0                                                                          sheet) + credits based on investment in alternative fuel infrastructure, 
                                                                                                                                                                                                                                                                                                                                                                                                                                                       emerging technology vehicles, and non-road equipment + Biodiesel (up to 
                                                                                                                                                                                                                                                                                                                                                                                                                                                       applicable limits) + applied banked credits
                                                                                                            AFV credits obtained for acquisition of 
                                                                             emerging technology medium and heavy duty                                                                                                                                                                                                                                                      0                                                                          Go to  "HD Emerging Technology Vehicle" sheet to enter or view medium or heavy duty emerging technology vehicles
                                                                                                                                                                                                                                                                vehicles
                                                                                          Total AFV credits obtained for acquisition of                                                                                                                                                                                                                                                                                                                Sum of credits obtained for acquisition of medium- and heavy-duty AFV 
                                                                                                                                          medium and heavy duty vehicles                                                                                                                                                                                                    0                                                                          creditable vehicles and medium- and heavy-duty emerging technology 
                                                                                                                                                                                                                                                                                                                                                                                                                                                       vehicles counted as acquisitions
                                                                                                                                                                                     Credits to bank =                                                                                                                                                                      0
                                                                                                                                                                       Banked Credits Applied:                                                                                                                                                                              0                                                                          You do not need to apply any banked credits to meet the requirement
                                                                                          Total earned and applied credits                                                                                                                                                                                                                                                  0
                                                                                                                   Reporting Model Year Credit                                                                                                                                                                                                                              0
                                                                                                                                                                                                                                                     Balance
                                                                                                                                                           Final check
                                                                                                                                                           No errors found on Alternative Fuel LDVs sheet
                                                                                                                                                           No errors found on Alternative Fuel Med-Hvy Veh sheet
                                                                                                                                                                                                                                                                                                                                                                                                                                                       I certify the  vehicles in this report operate solely on alternative fuel except when 
                                                                                                                                                                                                                                                                                                                                                                                                                                                       operating in an area where the appropriate alternative fuel is unavailable.
                                                                                                                                                                                                                                                                                                                                                                                                                                                   0
                                                                                                                                                                                                                                                                                                                                                                                                                                                       You have met your credit requirement for this year. Please ignore this section
                                                                                                                                                                                                                                                                                                                                                                                                                                                   1
                                                                                                                                                          Credit Activity Report Summary for Model Year 2021  - based on information you've entered.
                                                                                                                                                                                                      All information shown is preliminary. Your annual report data must be validated by the Vehicle Technologies Office.
                                                                                   Credits for acquisition of light-duty AFV                                                                                                                                                                                                                                                                                                                  0
                                                                                                                and emerging technology vehicles
                                                                                                      Credits for investments in emerging 
                                                                                                    technology vehicles, alternative fuel                                                                                                                                                                                                                                                                                                     0
                                                                                           refueling infrastructure, and non-road 
                                                                                                                                                                                                                                             equipment
                                                                                                                                                                 Biodiesel fuel use credits                                                                                                                                                                                                                                                   0
                                                                                  Medium- and heavy-duty vehicle credits                                                                                                                                                                                                                                                                                                                      0
                                                                                                                                    Banked credits applied toward                                                                                                                                                                                                                                                                             0
                                                                                                                                                                                                                                    requirement
                                                                                          Estimated credits to bank for this year                                                                                                                                                                                                                                                                                                             0
                                                                                                         Banked credit balance for next year                                                                                                                                                                                                                                                                                                  0
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    Page 2
                       Light-Duty Vehicle Data
                       Vehicles less than or equal to 8,500 lbs gross vehicle weight
                                                                                                            Input cells
                       back to Annual Report Data sheet                                                     Calculated cells (Do not enter values in these cells.)
                                                                                                            Problem flag (e.g., missing fields)
                      ight-Duty Vehicle Credits                 0                            underlined texLinks to definitions or other locations in the workbook
                                Vehicles with missing or        0                            *              required
                                potentially invalid fields
                                                                                             **             required if converted
                          Vehicle                          Light Duty          *Make/                          *Vehicle 
                          Number       Potential Credits     Vehicle        Manufacturer         *Model      Manufacture  *VIN (17 char, no O, I)               *Vehicle Category
                                                                                                              Model Year
                                                                                                                                                                    more info
                             1                                  Y
                             2                                  Y
                             3                                  Y
                             4                                  Y
                             5                                  Y
                             6                                  Y
                             7                                  Y
                             8                                  Y
                             9                                  Y
                             10                                 Y
                             11                                 Y
                             12                                 Y
                             13                                 Y
                             14                                 Y
                             15                                 Y
             16              Y
             17              Y
             18              Y
             19              Y
             20              Y
             21              Y
             22              Y
             23              Y
             24              Y
             26              Y
             27              Y
             28              Y
             29              Y
             30              Y
             31              Y
             32              Y
             33              Y
             34              Y
             35              Y
             36              Y
             37              Y
             38              Y
             39              Y
             40              Y
             41              Y
             42              Y
             43              Y
             44              Y
             45              Y
The words contained in this file might help you see if this file matches what you are looking for:

...Reporting spreadsheet standar formatxls standard compliance alternative fuel vehicle credits the us office of management and budget omb approved this data collection under control number you are not required to respond information unless it displays a currently valid takes about five hours per session for help with access guidance documents at httpwwweereenergygovvehiclesandfuelsepactguidance documentshtml expires submit your annual report using insert save on computer email completed epactsfpfleets nrelgov before fill out form may want original as distinct file future use please do change any cells eg by moving them or changing their formatting other than in appropriate color key input calculated enter values these problem flag missing underlined text links definitions locations workbook field fleet identification point contact id poc name local mailing address if different from parent organization type p city state...

no reviews yet
Please Login to review.