# RiverWare_DbDmiImpExp 6.4 Development
# Created 13:07 July 2, 2013
# 
# Section: Name Maps
set mgr "dbdmi.nameMapMgr"
"$mgr" format 2
"$mgr" map {RangeSameSheetMap}
set map "$mgr.RangeSameSheetMap"
"$map" dispOrder Priority
"$map" pair {\
RootSelection Version1 \
RootSel_Name       "" \
RootSel_UserLabel  "" \
RootSel_UseUserLabel        false \
RootSel_RootType   ROOT_SUBCLASS_SLOT \
RoolSel_AllowSlots_Physical RoolSel_AllowSlots_Account RoolSel_AllowSlots_Supply RoolSel_AllowSlots_Exchange RoolSel_AllowSlots_ExchangeSply RoolSel_AllowSlots_Payback RoolSel_AllowSlots_PaybackSply  \
RootSel_SelMode    SELMODE_SLOT_PHYSICAL \
RootSel_SubBasin_WildAllowed    false \
RootSel_SubBasin_Wildcarded     false \
RootFilter FILTER_SIMOBJ_NAME_WILDCARD ROOT_SUBCLASS_SIMOBJ \
RootFilter FILTER_SIMOBJ_HAS_ACCOUNT ROOT_SUBCLASS_SIMOBJ \
RootFilt_Dat "Has Account" "Has Account" "" rf_OFF rf_HIDE rf_POS \
RootFilter FILTER_SIMOBJ_IN_SUBBASIN ROOT_SUBCLASS_SIMOBJ \
RootFilt_Dat "In SubBasin" "In SubBasin" "" rf_OFF rf_HIDE rf_POS \
RootSel_SimObj_WildAllowed      true \
RootSel_SimObj_Wildcarded       false \
RootSel_SimObj_ExclAggObjElems  false \
RootFilter FILTER_EXCHANGE_NAME_WILDCARD ROOT_SUBCLASS_EXCHANGE \
RootSel_Exch_WildAllowed        false \
RootSel_Exch_Wildcarded         false \
RootFilter FILTER_ACCOUNT_NAME_WILDCARD ROOT_SUBCLASS_ACCOUNT \
RootFilter FILTER_ACCOUNT_WATER_TYPE ROOT_SUBCLASS_ACCOUNT \
RootFilt_Dat "Water Type" "Water Type" "" rf_OFF rf_HIDE rf_POS \
RootFilter FILTER_ACCOUNT_WATER_OWNER ROOT_SUBCLASS_ACCOUNT \
RootFilt_Dat "Water Owner" "Water Owner" "" rf_OFF rf_HIDE rf_POS \
RootFilter FILTER_ACCOUNT_JUNIOR_TO_DATE ROOT_SUBCLASS_ACCOUNT \
RootFilt_Dat "Junior To" "Junior To" "" rf_OFF rf_HIDE rf_POS \
RootFilter FILTER_ACCOUNT_SENIOR_TO_DATE ROOT_SUBCLASS_ACCOUNT \
RootFilt_Dat "Senior To" "Senior To" "" rf_OFF rf_HIDE rf_POS \
RootSel_Acct_WildAllowed        false \
RootSel_Acct_Wildcarded         false \
RootSel_InclStorageAccts        true \
RootSel_InclDiversionAccts      true \
RootSel_InclInstreamFlowAccts   true \
RootSel_InclPassThroughAccts    true \
RootFilter FILTER_PAYBACK_NAME_WILDCARD ROOT_SUBCLASS_PAYBACK \
RootSel_Pback_WildAllowed       false \
RootSel_Pback_Wildcarded        false \
RootFilter FILTER_SUPPLY_NAME_WILDCARD ROOT_SUBCLASS_SUPPLY \
RootFilter FILTER_SUPPLY_RELEASE_TYPE ROOT_SUBCLASS_ACCOUNT \
RootFilt_Dat "Release Type" "Release Type" "" rf_OFF rf_HIDE rf_POS \
RootFilter FILTER_SUPPLY_DESTINATION ROOT_SUBCLASS_ACCOUNT \
RootFilt_Dat "Destination" "Destination" "" rf_OFF rf_HIDE rf_POS \
RootFilter FILTER_SUPPLY_ROLE ROOT_SUBCLASS_ACCOUNT \
RootFilt_Dat "Supply Role" "Role" "" rf_OFF rf_HIDE rf_POS \
RootFilter FILTER_SUPPLY_ALLOWS_FLAG ROOT_SUBCLASS_SLOT \
RootFilt_Dat "Allows Flag" "Allows Flag" "" rf_OFF rf_HIDE rf_POS \
RootSel_Supply_WildAllowed      false \
RootSel_Supply_Wildcarded       false \
RootSel_Supply_ShowFromAccts    true \
RootSel_Supply_ShowToAccts      false \
RootSel_ShowSupplies_InOut      true \
RootSel_ShowSupplies_DivRet     true \
RootSel_ShowSupplies_Trans      true \
RootFilter FILTER_SLOT_NAME_WILDCARD ROOT_SUBCLASS_SLOT \
RootFilter FILTER_SLOT_COL_LABEL_WILDCARD ROOT_SUBCLASS_SLOT \
RootFilter FILTER_SLOT_UNIT_TYPE ROOT_SUBCLASS_SLOT \
RootFilt_Dat "Slot Unit Type" "Unit Type" "" rf_OFF rf_HIDE rf_POS \
RootFilter FILTER_SLOT_TYPE ROOT_SUBCLASS_SLOT \
RootFilt_Dat "Slot Type" "Type" "" rf_OFF rf_HIDE rf_POS \
RootFilter FILTER_SLOT_HAS_RPL_EXPR ROOT_SUBCLASS_SLOT \
RootFilter FILTER_SLOT_TIMESTEP ROOT_SUBCLASS_SLOT \
RootFilt_Dat "Timestep Size" "Timestep" "" rf_OFF rf_HIDE rf_POS \
RootFilter FILTER_SLOT_ALLOWS_FLAG ROOT_SUBCLASS_SLOT \
RootFilt_Dat "Allows Flag" "Allows Flag" "" rf_OFF rf_HIDE rf_POS \
RootFilter FILTER_SLOT_ATTRIB ROOT_SUBCLASS_SLOT \
RootFilt_Dat "Slot Attrib" "Attrib" "" rf_OFF rf_HIDE rf_POS \
RootSel_Slot_WildAllowed        true \
RootSel_Slot_Wildcarded         false \
RootSel_SlotTypeBits_InclMask   0 \
RootSel_SlotTypeBits_ExclMask   0 \
RootSel_AllowAggSeriesCols      true \
RootSel_AllowTableSeriesCols    true \
RootSel_AllowAggTableCols       false \
RootSel_ShowAggSeriesCols       false \
RootSel_ShowTableSeriesCols     false \
RootSel_ShowAggTableCols        false \
RootSel_RequiresSlotColRefs     false \
RootSel_SimObjClass "DataObj" \
RootSel_SimObj "ExcelTest" \
RootSel_Slot "ExcelTest.Series00000" \
RootSel_End \
} {B2:B28} -32767
"$map" pair {\
RootSelection Version1 \
RootSel_Name       "" \
RootSel_UserLabel  "" \
RootSel_UseUserLabel        false \
RootSel_RootType   ROOT_SUBCLASS_SLOT \
RoolSel_AllowSlots_Physical RoolSel_AllowSlots_Account RoolSel_AllowSlots_Supply RoolSel_AllowSlots_Exchange RoolSel_AllowSlots_ExchangeSply RoolSel_AllowSlots_Payback RoolSel_AllowSlots_PaybackSply  \
RootSel_SelMode    SELMODE_SLOT_PHYSICAL \
RootSel_SubBasin_WildAllowed    false \
RootSel_SubBasin_Wildcarded     false \
RootFilter FILTER_SIMOBJ_NAME_WILDCARD ROOT_SUBCLASS_SIMOBJ \
RootFilter FILTER_SIMOBJ_HAS_ACCOUNT ROOT_SUBCLASS_SIMOBJ \
RootFilt_Dat "Has Account" "Has Account" "" rf_OFF rf_HIDE rf_POS \
RootFilter FILTER_SIMOBJ_IN_SUBBASIN ROOT_SUBCLASS_SIMOBJ \
RootFilt_Dat "In SubBasin" "In SubBasin" "" rf_OFF rf_HIDE rf_POS \
RootSel_SimObj_WildAllowed      true \
RootSel_SimObj_Wildcarded       false \
RootSel_SimObj_ExclAggObjElems  false \
RootFilter FILTER_EXCHANGE_NAME_WILDCARD ROOT_SUBCLASS_EXCHANGE \
RootSel_Exch_WildAllowed        false \
RootSel_Exch_Wildcarded         false \
RootFilter FILTER_ACCOUNT_NAME_WILDCARD ROOT_SUBCLASS_ACCOUNT \
RootFilter FILTER_ACCOUNT_WATER_TYPE ROOT_SUBCLASS_ACCOUNT \
RootFilt_Dat "Water Type" "Water Type" "" rf_OFF rf_HIDE rf_POS \
RootFilter FILTER_ACCOUNT_WATER_OWNER ROOT_SUBCLASS_ACCOUNT \
RootFilt_Dat "Water Owner" "Water Owner" "" rf_OFF rf_HIDE rf_POS \
RootFilter FILTER_ACCOUNT_JUNIOR_TO_DATE ROOT_SUBCLASS_ACCOUNT \
RootFilt_Dat "Junior To" "Junior To" "" rf_OFF rf_HIDE rf_POS \
RootFilter FILTER_ACCOUNT_SENIOR_TO_DATE ROOT_SUBCLASS_ACCOUNT \
RootFilt_Dat "Senior To" "Senior To" "" rf_OFF rf_HIDE rf_POS \
RootSel_Acct_WildAllowed        false \
RootSel_Acct_Wildcarded         false \
RootSel_InclStorageAccts        true \
RootSel_InclDiversionAccts      true \
RootSel_InclInstreamFlowAccts   true \
RootSel_InclPassThroughAccts    true \
RootFilter FILTER_PAYBACK_NAME_WILDCARD ROOT_SUBCLASS_PAYBACK \
RootSel_Pback_WildAllowed       false \
RootSel_Pback_Wildcarded        false \
RootFilter FILTER_SUPPLY_NAME_WILDCARD ROOT_SUBCLASS_SUPPLY \
RootFilter FILTER_SUPPLY_RELEASE_TYPE ROOT_SUBCLASS_ACCOUNT \
RootFilt_Dat "Release Type" "Release Type" "" rf_OFF rf_HIDE rf_POS \
RootFilter FILTER_SUPPLY_DESTINATION ROOT_SUBCLASS_ACCOUNT \
RootFilt_Dat "Destination" "Destination" "" rf_OFF rf_HIDE rf_POS \
RootFilter FILTER_SUPPLY_ROLE ROOT_SUBCLASS_ACCOUNT \
RootFilt_Dat "Supply Role" "Role" "" rf_OFF rf_HIDE rf_POS \
RootFilter FILTER_SUPPLY_ALLOWS_FLAG ROOT_SUBCLASS_SLOT \
RootFilt_Dat "Allows Flag" "Allows Flag" "" rf_OFF rf_HIDE rf_POS \
RootSel_Supply_WildAllowed      false \
RootSel_Supply_Wildcarded       false \
RootSel_Supply_ShowFromAccts    true \
RootSel_Supply_ShowToAccts      false \
RootSel_ShowSupplies_InOut      true \
RootSel_ShowSupplies_DivRet     true \
RootSel_ShowSupplies_Trans      true \
RootFilter FILTER_SLOT_NAME_WILDCARD ROOT_SUBCLASS_SLOT \
RootFilter FILTER_SLOT_COL_LABEL_WILDCARD ROOT_SUBCLASS_SLOT \
RootFilter FILTER_SLOT_UNIT_TYPE ROOT_SUBCLASS_SLOT \
RootFilt_Dat "Slot Unit Type" "Unit Type" "" rf_OFF rf_HIDE rf_POS \
RootFilter FILTER_SLOT_TYPE ROOT_SUBCLASS_SLOT \
RootFilt_Dat "Slot Type" "Type" "" rf_OFF rf_HIDE rf_POS \
RootFilter FILTER_SLOT_HAS_RPL_EXPR ROOT_SUBCLASS_SLOT \
RootFilter FILTER_SLOT_TIMESTEP ROOT_SUBCLASS_SLOT \
RootFilt_Dat "Timestep Size" "Timestep" "" rf_OFF rf_HIDE rf_POS \
RootFilter FILTER_SLOT_ALLOWS_FLAG ROOT_SUBCLASS_SLOT \
RootFilt_Dat "Allows Flag" "Allows Flag" "" rf_OFF rf_HIDE rf_POS \
RootFilter FILTER_SLOT_ATTRIB ROOT_SUBCLASS_SLOT \
RootFilt_Dat "Slot Attrib" "Attrib" "" rf_OFF rf_HIDE rf_POS \
RootSel_Slot_WildAllowed        true \
RootSel_Slot_Wildcarded         false \
RootSel_SlotTypeBits_InclMask   0 \
RootSel_SlotTypeBits_ExclMask   0 \
RootSel_AllowAggSeriesCols      true \
RootSel_AllowTableSeriesCols    true \
RootSel_AllowAggTableCols       false \
RootSel_ShowAggSeriesCols       false \
RootSel_ShowTableSeriesCols     false \
RootSel_ShowAggTableCols        false \
RootSel_RequiresSlotColRefs     false \
RootSel_SimObjClass "DataObj" \
RootSel_SimObj "ExcelTest" \
RootSel_Slot "ExcelTest.SeriesDaily" \
RootSel_End \
} {C2:C28} -32766
"$map" resolve
"$mgr" end
# Section: Datasets
set mgr "dbdmi.datasetMgr"
"$mgr" format 1
"$mgr" {Excel} {RangeSameSheetDataset}
set dataset "$mgr.RangeSameSheetDataset"
"$dataset" nameMap {RangeSameSheetMap}
"$dataset" missVal {NAN} 0
"$dataset" ieunits {USE_DS} 0 
"$dataset" rwto 0 60
"$dataset" workbook {C:/RiverWare/staff/nwilson/ExcelDmi/DmiTest.xlsx}
"$dataset" mappingType {RANGE}
"$dataset" sameSheet 1 {TestSheet}
"$dataset" rangeOffset 0 0 0
"$dataset" headerOffset 0 0 0
"$dataset" headerType {TIME-SLOT-RUN}
"$dataset" runNameType {SINGLE}
"$dataset" singleRunName {}
"$dataset" beginTimeFlag 0
"$dataset" exportUnitFlag 0
"$mgr" end
# Section: DMI (part two)
set mgr "dbdmi.dmiMgr"
"$mgr" format 3
"$mgr" dbdmi {ExcelSameSheetOutput}
set dmi "$mgr.dbdmi.ExcelSameSheetOutput"
"$dmi" type {Output}
"$dmi" confirmWarnings 1
"$dmi" recInv 0
"$dmi" userParam {ModelID} {0} 
"$dmi" datasets {RangeSameSheetDataset} 
"$dmi" slot  {\
RootSelection Version1 \
RootSel_Name       "" \
RootSel_UserLabel  "" \
RootSel_UseUserLabel        false \
RootSel_RootType   ROOT_SUBCLASS_SLOT \
RoolSel_AllowSlots_Physical RoolSel_AllowSlots_Account RoolSel_AllowSlots_Supply RoolSel_AllowSlots_Exchange RoolSel_AllowSlots_ExchangeSply RoolSel_AllowSlots_Payback RoolSel_AllowSlots_PaybackSply  \
RootSel_SelMode    SELMODE_SLOT_PHYSICAL \
RootSel_SubBasin_WildAllowed    false \
RootSel_SubBasin_Wildcarded     false \
RootFilter FILTER_SIMOBJ_NAME_WILDCARD ROOT_SUBCLASS_SIMOBJ \
RootFilter FILTER_SIMOBJ_HAS_ACCOUNT ROOT_SUBCLASS_SIMOBJ \
RootFilt_Dat "Has Account" "Has Account" "" rf_OFF rf_HIDE rf_POS \
RootFilter FILTER_SIMOBJ_IN_SUBBASIN ROOT_SUBCLASS_SIMOBJ \
RootFilt_Dat "In SubBasin" "In SubBasin" "" rf_OFF rf_HIDE rf_POS \
RootSel_SimObj_WildAllowed      true \
RootSel_SimObj_Wildcarded       false \
RootSel_SimObj_ExclAggObjElems  false \
RootFilter FILTER_EXCHANGE_NAME_WILDCARD ROOT_SUBCLASS_EXCHANGE \
RootSel_Exch_WildAllowed        false \
RootSel_Exch_Wildcarded         false \
RootFilter FILTER_ACCOUNT_NAME_WILDCARD ROOT_SUBCLASS_ACCOUNT \
RootFilter FILTER_ACCOUNT_WATER_TYPE ROOT_SUBCLASS_ACCOUNT \
RootFilt_Dat "Water Type" "Water Type" "" rf_OFF rf_HIDE rf_POS \
RootFilter FILTER_ACCOUNT_WATER_OWNER ROOT_SUBCLASS_ACCOUNT \
RootFilt_Dat "Water Owner" "Water Owner" "" rf_OFF rf_HIDE rf_POS \
RootFilter FILTER_ACCOUNT_JUNIOR_TO_DATE ROOT_SUBCLASS_ACCOUNT \
RootFilt_Dat "Junior To" "Junior To" "" rf_OFF rf_HIDE rf_POS \
RootFilter FILTER_ACCOUNT_SENIOR_TO_DATE ROOT_SUBCLASS_ACCOUNT \
RootFilt_Dat "Senior To" "Senior To" "" rf_OFF rf_HIDE rf_POS \
RootSel_Acct_WildAllowed        false \
RootSel_Acct_Wildcarded         false \
RootSel_InclStorageAccts        true \
RootSel_InclDiversionAccts      true \
RootSel_InclInstreamFlowAccts   true \
RootSel_InclPassThroughAccts    true \
RootFilter FILTER_PAYBACK_NAME_WILDCARD ROOT_SUBCLASS_PAYBACK \
RootSel_Pback_WildAllowed       false \
RootSel_Pback_Wildcarded        false \
RootFilter FILTER_SUPPLY_NAME_WILDCARD ROOT_SUBCLASS_SUPPLY \
RootFilter FILTER_SUPPLY_RELEASE_TYPE ROOT_SUBCLASS_ACCOUNT \
RootFilt_Dat "Release Type" "Release Type" "" rf_OFF rf_HIDE rf_POS \
RootFilter FILTER_SUPPLY_DESTINATION ROOT_SUBCLASS_ACCOUNT \
RootFilt_Dat "Destination" "Destination" "" rf_OFF rf_HIDE rf_POS \
RootFilter FILTER_SUPPLY_ROLE ROOT_SUBCLASS_ACCOUNT \
RootFilt_Dat "Supply Role" "Role" "" rf_OFF rf_HIDE rf_POS \
RootFilter FILTER_SUPPLY_ALLOWS_FLAG ROOT_SUBCLASS_SLOT \
RootFilt_Dat "Allows Flag" "Allows Flag" "" rf_OFF rf_HIDE rf_POS \
RootSel_Supply_WildAllowed      false \
RootSel_Supply_Wildcarded       false \
RootSel_Supply_ShowFromAccts    true \
RootSel_Supply_ShowToAccts      false \
RootSel_ShowSupplies_InOut      true \
RootSel_ShowSupplies_DivRet     true \
RootSel_ShowSupplies_Trans      true \
RootFilter FILTER_SLOT_NAME_WILDCARD ROOT_SUBCLASS_SLOT \
RootFilter FILTER_SLOT_COL_LABEL_WILDCARD ROOT_SUBCLASS_SLOT \
RootFilter FILTER_SLOT_UNIT_TYPE ROOT_SUBCLASS_SLOT \
RootFilt_Dat "Slot Unit Type" "Unit Type" "" rf_OFF rf_HIDE rf_POS \
RootFilter FILTER_SLOT_TYPE ROOT_SUBCLASS_SLOT \
RootFilt_Dat "Slot Type" "Type" "" rf_OFF rf_HIDE rf_POS \
RootFilter FILTER_SLOT_HAS_RPL_EXPR ROOT_SUBCLASS_SLOT \
RootFilter FILTER_SLOT_TIMESTEP ROOT_SUBCLASS_SLOT \
RootFilt_Dat "Timestep Size" "Timestep" "" rf_OFF rf_HIDE rf_POS \
RootFilter FILTER_SLOT_ALLOWS_FLAG ROOT_SUBCLASS_SLOT \
RootFilt_Dat "Allows Flag" "Allows Flag" "" rf_OFF rf_HIDE rf_POS \
RootFilter FILTER_SLOT_ATTRIB ROOT_SUBCLASS_SLOT \
RootFilt_Dat "Slot Attrib" "Attrib" "" rf_OFF rf_HIDE rf_POS \
RootSel_Slot_WildAllowed        true \
RootSel_Slot_Wildcarded         false \
RootSel_SlotTypeBits_InclMask   0 \
RootSel_SlotTypeBits_ExclMask   0 \
RootSel_AllowAggSeriesCols      true \
RootSel_AllowTableSeriesCols    true \
RootSel_AllowAggTableCols       false \
RootSel_ShowAggSeriesCols       false \
RootSel_ShowTableSeriesCols     false \
RootSel_ShowAggTableCols        false \
RootSel_RequiresSlotColRefs     false \
RootSel_SimObjClass "DataObj" \
RootSel_SimObj "ExcelTest" \
RootSel_Slot "ExcelTest.Series00000" \
RootSel_End \
} {Start Timestep - 1 Timesteps} {Start Timestep + 25 Timesteps} {RangeSameSheetDataset}
"$dmi" resolve
"$mgr" end