The questions you are asking are deep into the realm of structural engineering. There are no "rules of thumb" to follow as every house is going to be different. The calculations involved in determining what is safe when you alter the supporting structure are very complex, and would require measuring and anylyzing what you have now, in order to predict what will work to prevent floor sagging, etc. I strongly recommend that you consult a licensed Structural Engineer to ensure the safety of your plan, and explain to you what you need to know.
Knowing nothing about your knowlegeable friend, I don't want to insult him/her, but I do want to caution you if you hear the phrase "over-engineer". Sometimes contractors who like to wing it will say things like this in hopes of saving some money. An engineer will design the beam to ensure safety for the expected load, plus some extra strength for a possible additional load (waterbed, hot tub, etc.) In Mass. this past winter, four roofs collapsed due to heavy snow loading. These catastrophes can happen when folks try a little too hard to save some money.
In an 80+ year old house even walls that once were not load-bearing can become so because of the way the house settled. Chances are good you may find supporting beams weakend by previous remodeling and/or wood rot.
- 15 Old House Features We Shouldn't Abandon
- 13 Lazy Cleaning Tricks for a Spotless Home
- Laundry Room Ideas to Knock Your Socks Off
- Insanely Easy 60-Minute Home Improvements
- 12 Sheds You Could Live (or Work) In
- Assembly Required: 15 DIY Kit Homes
- 7 House Sounds You Never Want to Ignore
- 10 Surprisingly Simple Woodworking Projects
- Worth It: 8 Renovations That Pay You Back
- Organize Your Life with 12 Dollar-Store Buys
- 9 Totally Amazing Mobile Home Makeovers
- Don't Make These 7 Mistakes in Small Spaces
- 20 Sneaky Storage Ideas
- 15 Totally Unexpected DIY Flooring Alternatives
- 7 Easy Budget-Friendly Backyard Makeovers
- 10 Closet Cures That Cost Less Than $100
- 11 Easy DIY Projects to Declutter Your Home
- 10 "Zero Dollar" Garden Hacks
- 10 Killproof Plants for a No-Effort Landscape
- 9 Insanely Easy 1-Hour Backyard Projects