I have a question to which I think I know the answer, but because it's so much work I'd like to confirm beforehand.

My problem is as follows: For driving to work, an employee gets several types of reimbursements. His trajectory is made up of 2 parts: part one from his home to a meeting point, part 2 from the meeting point to the work place. He gets different kinds of reimbursements for part 1 than he does for part 2. The distances of parts 1 and 2, separately, are both between 1 and 200 kilometers (rounded to natural numbers). Hence, there are a total of 40 000 (200*200) possible reimbursement amounts (assuming reimbursements vary per kilometer).

I'd like to show these 40 000 amounts in a matrix (so you could see quickly, for example: what the employee's reimbursement would be if his first trajectory is 25 km and his second 113).

I'm thinking of getting there as follows:

Make 40 000 Excel lines, column 1 containing the distance of trajectory 1 (a 200-times recurring loop of 1 to 200), column 2 containing the distance of trajectory 2 (200 times 1 for the first loop, 200 times 2 for the second, etc) and column C the reimbursement amount. Then I make a pivot with column 1 as a row heading, column 2 as a column heading and column C as a value.

Would this work?

Thanks