one formula for staggered results

Hello. I have a sheet where I have to create staggered formulas. I have to go in and create the formulas for each row and then do the same thing when I change the main column reference. Is there a way I can just create one formula and then drag it down and across and have it recreate what I have currently in the sheet. Spreadsheet attached. Dankeshun.

Thanks Mr. NFL. Could you explain how you come up with that formula? Are you just that good? I can usually work through things like this but I can't imagine ever thinking it up. Thanks.