Error writing model to xlsx when flows don't match

[bl-young]

Some satellite tables can contain flows that are exclusively assigned to households. These flows do not get added to the B matrix. However they are written to model$SatelliteTables$flows. As a result writing the flows to csv fails

useeior/R/WriteModel.R

Lines 280 to 283 in 6e6b2a6

	checkNamesandOrdering(flows$ID, rownames(model$B),
	"flows in flows.csv and rows in B matrix")
	utils::write.csv(flows, paste0(dirs$model, "/flows.csv"), na = "",
	row.names = FALSE, fileEncoding = "UTF-8")

[WesIngwersen]

This can be addressed with the addition of the final user B matrix, #226. For this reason the current B and B_h will need to have the same index... so there will be zeroes across some rows when this happens, but it will resolve this error.

[WesIngwersen]

The more immediate fix is to take the flows not in B out of flows.csv, until a B_h is created.

[WesIngwersen]

Discovered its not just a matter of presence/absence and order, but because the flow names may have special characters, it appears model$B index values and model$SatelliteTables$flows may have not translate to the same
e.g.

model$SatelliteTables$flows$ID	rownames(model$B)
Particulate matter, > 2.5μm and ≤ 10μm/emission/air/kg	Particulate matter, ≤ 2.5μm/emission/air/kg
Particulate matter, ≤ 2.5μm/emission/air/kg	Particulate matter, > 2.5μm and ≤ 10μm/emission/air/kg

[bl-young]

Discovered its not just a matter of presence/absence and order, but because the flow names may have special characters, it appears model$B index values and model$SatelliteTables$flows may have not translate to the same

Though in that case you think this would have been an issue in the past as well? as these PM flows are not new.