Hey there! Let me walk you through exactly how to fill your 3D (Year, Month, Bins) parameter in AnyLogic with your Excel-based CFS values. I’ve tackled this exact scenario before, so it’s straightforward once you follow these steps:

1. Prep Your Excel Data Structure #

First, make sure your Excel file is organized to match your 3D parameter dimensions. A clean structure looks like this:

• Ensure there are no blank rows or invalid entries (like non-numeric CFS values).
• Keep your bin labels consistent (e.g., use "B1", "B2" instead of mixing "Bin1" and "B1").

2. Import Excel Data into AnyLogic #

Step 2.1: Add the Excel File to Your Project #

• Right-click your project in the AnyLogic Project Browser → Add → Excel File.
• Select your Excel file and confirm; it’ll appear under the "Files" folder in your project.

Step 2.2: Create a Dataset to Read the Data #

• Drag a Dataset component from the "Data" palette into your Main agent.
• In the Dataset’s properties:
  • Set Data source to your imported Excel file.
  • Select the correct worksheet (e.g., "Sheet1").
  • Map Excel columns to Dataset attributes:
    • For "Year" → add an int attribute named year.
    • For "Month" → add an int attribute named month.
    • For "Bin" → add a String attribute named bin (or int if your bins are numeric).
    • For "CFS_Value" → add a double attribute named cfsValue.

3. Initialize Your 3D Parameter via Code #

Assume your 3D parameter is named cfsParameter (configured as double[numberOfYears][12][numberOfBins]). We’ll populate it in the On startup code block of your Main agent:

Option A: For Continuous Years & Bins #

If your years are consecutive (e.g., 2020-2024) and bins are numbered (1,2,3...), use this simple mapping:

// Iterate through every row in the dataset
for (int i = 0; i < dataset.size(); i++) {
    // Extract data from the current row
    int year = dataset.get(i).year;
    int month = dataset.get(i).month;
    int bin = dataset.get(i).bin; // Use String bin = ... if bins are text
    double cfsVal = dataset.get(i).cfsValue;

    // Calculate array indices (AnyLogic uses 0-based indexing)
    int yearIndex = year - 2020; // Replace 2020 with your starting year
    int monthIndex = month - 1; // Convert 1-12 to 0-11
    int binIndex = bin - 1; // Convert 1-N to 0-(N-1)

    // Assign value to the 3D parameter
    cfsParameter[yearIndex][monthIndex][binIndex] = cfsVal;
}

Option B: For Non-Continuous Years or Text Bins #

If your years are scattered (e.g., 2020, 2022, 2023) or bins use text labels (B1, B2), use maps to handle index mapping dynamically:

// First, create mappings for years and bins to their array indices
Map<Integer, Integer> yearToIndex = new HashMap<>();
Map<String, Integer> binToIndex = new HashMap<>();
int yearCounter = 0;
int binCounter = 0;

// Populate the mappings by iterating through the dataset once
for (int i = 0; i < dataset.size(); i++) {
    int year = dataset.get(i).year;
    String bin = dataset.get(i).bin;

    if (!yearToIndex.containsKey(year)) {
        yearToIndex.put(year, yearCounter++);
    }
    if (!binToIndex.containsKey(bin)) {
        binToIndex.put(bin, binCounter++);
    }
}

// Now populate the 3D parameter
for (int i = 0; i < dataset.size(); i++) {
    int year = dataset.get(i).year;
    int month = dataset.get(i).month;
    String bin = dataset.get(i).bin;
    double cfsVal = dataset.get(i).cfsValue;

    // Get indices from the mappings
    int yearIndex = yearToIndex.get(year);
    int monthIndex = month - 1;
    int binIndex = binToIndex.get(bin);

    // Assign the value
    cfsParameter[yearIndex][monthIndex][binIndex] = cfsVal;
}

4. Verify the Data #

To make sure everything works correctly:

• Add a trace statement in the On startup block to test a specific value:

  traceln("2020, Month 1, Bin B1 CFS Value: " + cfsParameter[0][0][0]);
  

• Run the model and check the console output against your Excel data.
• You can also right-click your 3D parameter in the Project Browser → View to inspect the full array contents.

Key Notes #

• Ensure your 3D parameter’s dimensions match the number of unique years, months (always 12), and bins in your data. If you have 5 unique years and 3 bins, set the parameter to double[5][12][3].
• Handle edge cases (like missing data rows) by adding checks (e.g., if (yearToIndex.containsKey(year))) to avoid runtime errors.

内容的提问来源于stack exchange，提问作者Handballer73