I assume you have Excel 2007. Enable macros first, then you'll see 4 tabs at the bottom of the sheet (Main , RGdb , Egg , Ref).
You'll need to type your ID and your SID for every game you create in the proper row, then press "Menu -> Rerun Method 1 Shiny search" and it will look for good method1 shiny spreads.
After filling some rows, you'll only need to update the search instead of rerunning it. If you want to check shininess on a new egg, type its PID in the tab "Egg" Under "Egg PID Hex" (any of the two will be fine). If that egg will hatch shiny in one of your save files, a number will appear under "sav file match", that number indicates the save file you'll have to hatch the egg at. If there's no match you'll only see "No Match".