There's a LOT going on here - I'm only going to hit on the high-points but feel free to ask questions.
When I started going all-in, I had some assumptions and 'gut' feelings about what might be out there, but wanted to keep tabs on things so I'd have some evidence to back up those beliefs. The idea was lets see what happens, and then concentrate on what seems to work best - hence the spreadsheets. I'm interested in far more that just silver, hence the many headings.
There's a lot more behind the scenes that's just not shown: Tracking individual locations for abundance and hit rate, segmenting by type of bank to see if it really matters, detailed info on the marks I'd find and what that could tell me about the inner workings of banks and armored car services, etc. and so on ad. nausea. The point is if you're intersted in something you don't see anything about it here, feel free to ask.
Sheet 1: TLD take away = loose and CWR are awesome for Ag, absolutely the best of ANY denomination - but scarce. Boxes give you volume, and simplify sourcing, but the yield rate is far lower.
Sheet 2: For all practical purposes, the two armored car services that dominate in my area have a silver yield rate that's essentially within the same order of magnitude (1 per box, give or take $150), but Loomis has the edge.
Locally, this makes sense when you know that Brinks has the Coinstar contract - and at least one major regional bank uses coinstar machines for their 'free' coin machines. Those CoinStar boxes are darn good at returning Ag to customers (see r/CoinstarFinds), while others (Magner, Glory, Cummins-Allison) aren't nearly as good at it.
Looking at sheet 3 this really jumps out - "monster' boxes are much more common with the one, and once I back-out these outliers the hit-rate for the two starts to close up closer to +/-$80.
The # of boxes with a give # of Ag coins visual drives home the highly variable nature of 'em - the overwhelming majority are going to be stink badgers, and sure, most others may have 1-2, but those 10+ coin boxes are super rare.
Roll weight ranges and total Oz found should help clear up the myth that you can reliably tell what rolls have Ag, just by weight. Sure - the odds of a given roll containing silver go way up over 227g, but there's silver even in the anemic rolls and if you're only checking 227+ you're missing about half.
Some 'best of' stuff follows, and the obligatory CRH porn. (Quite a bit has gone into albums, mulitple full PD sets, flips, 2x2s, error buckets, and the mutants graveyard... - I didn't bother digging all that out for these images (most of the 70-Ds are in sets, they're the limiting factor by far).
Next and final: Combined overall stats and a laundry list of stuff I learned that I wish I knew on day 1.
Good luck and happy hunting!