Two Disparate yet Overlapping Matrices (Proportional Equivalencies)?

[agagag]

Hi All

Struggling with an issue that I am sure someone must have faced before, but I can't find an answer when I searched the forum, so hoping someone can help me.
Essentially I am trying to convert an OD matrix into another OD matrix, by which I mean I have OD matrices from two disparate zonal systems, and I have managed to get spatial proportions from each zone system (and each OD matrix) to the other where they overlap, and I want to apply these proportions so that I can make a comparison between the two disparate OD matrices. I might not be explaining this clearly but say I have an OD matrix A to F and another OD matrix Q to Z, whereby I have the proportions between the two sets of matrices, surely there must be a way to convert the OD matrix (( Q to Z)) to the A to F, but I'm not clever enough to think of a way! I can extract the matrices in 3 column list format (From, To, Value) but still not sure what the easiest way to aggregate and disaggregate an OD matrix into another is... any help, tips, formulae or examples would be very much appreciated

Francesca

 

[agagag]

To clarify as a simplified example

	OD Matrix One
		A	B	C
	A	100	25	78
	B	4	98	20
	C	86	89	85
	OD Matrix Two
		Q	R	S	T	U
	Q	48	85	89	8	78
	R	12	798	41	58	32
	S	8	758	2	12	96
	T	86	54	18	8	98
	U	78	8	74	44	74
	Spatial Percentages to Apply
		A	B	C
	Q	0%	100%	0%
	R	70%	30%	0%
	S	99%	0%	1%
	T	80%	10%	10%
	U	100%	0%	0%

<colgroup><col><col><col span="3"><col><col><col></colgroup><tbody>
</tbody>