Damage Calculator Advice

Hi everyone. First time posting here. I need some help with an ongoing passion project - creating a damage calculator in an Excel spreadsheet.

I'm having trouble with effects that can change the type of a move. I'm using formulae to automate as much as possible, so rather than having the user select the type I'm trying to have the spreadsheet determine the type by analysing which effects are active.

The effects I'm trying to reconcile with each other are Electrify, Ion Deluge, Plasma Fists and Abilities like Normalize and Pixilate. (I'm aware that not all of these exist in Gen IX - I'm working with a National Dex mindset.) The information on Bulbapedia about how these effects interact with each other is contradictory, and I've got inconclusive results by testing on Showdown, so can anyone provide any useful information from reliable sources? I'm mostly trying to determine which effects take priority and override each other if multiple are active at once, and when moves will have their power boosted. For example, if a Delcatty with Normalize uses Headbutt while Ion Deluge is in effect, will it be a Normal or Electric type move, and will it be boosted by Normalize? Showdown appeared to make it an Electric type move while keeping the boost, but I may have misinterpreted that.

Many thanks!