xlsSysSummary

Write powertrain energy analysis to spreadsheet

Description

example

The xlsSysSummary(PlantInfoObj,filename,sheet) method exports the system energy and efficiency for the autoblks.pwr.PlantInfo object. Use the autoblks.pwr.PlantInfo object to evaluate and report power an energy for component-level blocks and system-level models.

After you use the run method to analyze the powertrain power and energy, use the xlsSysSummary method to write the results to a spreadsheet.

Examples

collapse all

Analyze the power and energy in the conventional vehicle reference application. To use the xlsSysSummary method to write the results to a spreadsheet, see step 5.

  1. Open the conventional vehicle reference application. By default, the application has a mapped 1.5 L spark-ignition (SI) engine and a dual clutch transmission. Project files open in a writable location.

  2. Set the system name to SiCiPtReferenceApplication.

    Create the autoblks.pwr.PlantInfo object.

    Use the PwrUnits and EnrgyUnits properties to specify the units.

    SysName = 'SiCiPtReferenceApplication';
    VehPwrAnalysis = autoblks.pwr.PlantInfo(SysName);
    VehPwrAnalysis.PwrUnits = 'kW';
    VehPwrAnalysis.EnrgyUnits = 'MJ';
  3. Use the run method to turn on logging, run simulation, and add logged data to the object.

    run(VehPwrAnalysis);
  4. Use the dispSysSummary method to display the results.

    dispSysSummary(VehPwrAnalysis);
  5. Use the xlsSysSummary method to write the results to a spreadsheet.

    xlsSysSummary(VehPwrAnalysis,'EnergySummary.xlsx');
  6. Use the findChildSys method to retrieve the autoblks.pwr.PlantInfo object for the Engine subsystem.

    To display the results, use the dispSignalSummary method.

    Use the histogramEff method to display a histogram of the time spent at each engine plant efficiency.

    EngSysName = 'SiCiPtReferenceApplication/Passenger Car/Engine';
    EngPwrAnalysis = findChildSys(VehPwrAnalysis,EngSysName);
    dispSignalSummary(EngPwrAnalysis);
    histogramEff(EngPwrAnalysis);
  7. Use the findChildSys method to retrieve the autoblks.pwr.PlantInfo object for the Drivetrain subsystem.

    To display the results, use the dispSignalSummary method.

    DrvtrnSysName = 'SiCiPtReferenceApplication/Passenger Car/Drivetrain';
    DrvtrnPwrAnalysis = findChildSys(VehPwrAnalysis,DrvtrnSysName);
    dispSignalSummary(DrvtrnPwrAnalysis);
  8. To plot the results, use the sdiSummary method.

    sdiSummary(VehPwrAnalysis,{EngSysName,DrvtrnSysName})

Input Arguments

collapse all

autoblks.pwr.PlantInfo object for the system that you want to analyze.

File name, specified as a character vector or a string.

If filename does not exist, xlsSysSummary creates a file, determining the format based on the specified extension. To create a file compatible with Excel® 97–2003 software, specify an extension of .xls. To create files in Excel 2007 formats, specify an extension of .xlsx, .xlsb, or .xlsm. If you do not specify an extension, xlsSysSummary uses the default, .xls.

Example: 'myFile.xlsx' or "myFile.xlsx"

Example: 'C:\myFolder\myFile.xlsx'

Example: 'myFile.csv'

Data Types: char | string

Worksheet name, specified as one of the following:

  • Character vector or string that contains the worksheet name. The name cannot contain a colon (:). To determine the names of the sheets in a spreadsheet file, use xlsfinfo.

  • Positive integer that indicates the worksheet index.

If sheet does not exist, xlswrite adds a sheet at the end of the worksheet collection. If sheet is an index larger than the number of worksheets, xlswrite appends empty sheets until the number of worksheets in the workbook equals sheet. In either case, xlswrite generates a warning indicating that it has added a worksheet.

Data Types: char | string | single | double | int8 | int16 | int32 | int64 | uint8 | uint16 | uint32 | uint64

Introduced in R2019a