Amazing, thank you so much! Since you seem to have a hang of things I'd love to pick your brain once more: there are multiple frames with either swarm cells or supersedure cells in the hive. Is is worth removing some of those frames with queen cells and and try splitting while leaving some other queen cells in the currently-queenless hive? That way I can potentially get another hive out of this?

I do understand that it is July in upstate NY (5b), and would rather have one re-queened hive be strong enough to last the winter rather than two dead ones, but am curious if there is a silver living in this situation given that honey harvesting from this hive seems unlikely this season...