The Enormous Spreadsheet that Runs the World's Mail
Вставка
- Опубліковано 4 жов 2017
- Get a Half as Interesting t-shirt: bit.ly/2xjHuw4
Suggest a video and get a free t-shirt if we use it: halfasinteresting.com/suggest
Follow Half as Interesting on Twitter: / halfinteresting
Discuss this video on Reddit: / halfasinteresting
Check out my podcast with Brian from Real Engineering:
itunes.apple.com/us/podcast/s... (iTunes link)
ua-cam.com/channels/_10.html... (UA-cam link)
Check out my other channel: / wendoverproductions
"If you're not as excited as me, you need to change your opinion."
Real subtle
HAHA! So great!
True tho
Website: 2 DAY SHIPPING $13.99
Me: "Seems a little high. Lemme check the spreadsheet"
This...
...this is enough to give any self-respecting software engineer a heart attack.
You know it's bad when any self-respecting software engineer says "That data needs to be in a database, not a spreadsheet."
My last company I worked for, the accounting department had a spreadsheet that looked like it may have had over 500,000 cells in it. I do know we had to remove their 32-bit version of Excel and install a 64-bit version as the 32-bit version didn't have enough memory to handle the spreadsheet.
@@ki5aok That's a crime against humanity, right there.
@@ki5aok If it's stupid, but it works, then it's maybe still stupid afterall.
@@ki5aok same! My last job didn't have a database of employees, they had a fucking spreadsheet. A multi billion dollar finance company... Every time an employee was hired, they got added to the spreadsheet. When they quit, we'd just highlight their name in the spreadsheet. Every time we had to make anyone an account for anything, they get a new line on a new page of the spreadsheet. My department *begged* to let us convert it into a database, but the CTO was a dude who barely knew how to turn on a computer and was always like "lul no"
@@ki5aok
I ones did a working experience at copnay and worked in the Complaint Management team. The Teamlead wanted me to overhaul an Excel-file where we could record all complaints, nature of complaints/fault, product, origin of fault, associated cost and more, and than use Excel filters and other functions to show for example, how much did this teams fuckups cost us this month? Or that persons? Are there any products that come up suspicisously often/cost alot? And then tie that all in with diagramms and pie-charts.
At the end i was the only one that understood that spreadsheer (through it wasnt actually THAT complicated)
"We don't have enough acronyms", unofficial motto of the British and US militaries.
Sera It's funny how accurate you are
Unofficial motto of the British and US governments. Hell, in America, two acronyms can me two different things.
For instance, the NRA (National Rifle Association and National Recovery Administration).
And the US government.
Sera what’s so funny, I don’t see anything, did he fix it.
238328 3 letter/number long acronyms cam be made in the english language.
“Now go away”
very charlie brooker's -wipe
Best ending ever. Imagine if movies end with that.
G E T
O U T
I think he was high recording this
Rampage Chozers "Now Go Away?". That wasn't very nice, HAI..
F I N A L L Y ! A t-shirt that costs less than an Apache Attack Helicopter
Ikr! Sick of paying over $35mil for a t!
I hate t-shirts that cost more then a gender.
WTD Productions but now I want a helicopter.
WTD Productions
What is slavery a thing now? Instead of being race specific it’s now gender specific #stopattackhelicopterslavery
My budget is only for one Apache helicopter and no more... If I get the t-shirt, no helicopter for me 😱
#SaveAnApacheHelicoptersLife
Is it weird that international bureaucracy like this is part of what gives me hope for humanity?
It shows our ability to cooperate. To create powerful systems that benefit everyone. That international relations are often not zero sum.
On the flip side, if a country refused to get on board, they would have no international mail to or from that nation. This would annihilate the national economy. So in reality, just like everything else, the penalty for not standardizing is exponentially greater than any potential gains from holding out for a greater share (such as the American lunacy behind refusing to adopt the metric system). So it's less about cooperation than securing ones own economic viability.
It's amazing how many complex systems in the world that we think are highly sophisticated are actually managed using Excel spreadsheets.
More like SQL databases, excel is for people who analyze small datasets on the front-end.
That Apache helicopter bit was damn good.
Yep, thou I think a Bell 206L3 or a 407 would be a bit more practical since I fly both types. Besides, AH-64 Apache school is a good six months of cracking the books and with the Democrats having their panties in a wad about guns, a helicopter with the full boat of 30mm Cannons, machine guns, and TOW missiles would really send them over the edge Now kidding aside, it is very interesting to know how the postal system works, it's all about the free flow of goods and services.
Dan Beucler Your comment has 666 likes
So how do I give this comment two likes?
@@CraftQueenJr Like this
@@CraftQueenJr alt account
Wendy bringing dem dank memes
Real Engineering true
Because dankMemes+Wendy=trolly dank memes
Matthew TING as far as I know they're just two youtubers who decided to collaborate on some videos because they liked and each other's contnt and wanted to promote themselves on one another's channel. Then they ended up doing more projects together because they're good people and ended up being friends.
I wonder now if there's a fan faction about those two...
Rafael Dos Santos real life lore is in too
Matthew TING As for advertisments, their content most often matches and so do ads
“Now go away” this has got to be the best outro ever
That’s because it’s from the channel Critical Drinker... the best movie/tv/life reviewer ever.
Originally from Charlie Brooker's Screen Wipe.
A better title for this video is "wendover gets very excited about mail"
jarl5 lol literally
You made me scroll up and double check what channel I’m on
PandaRobot well they are the same dude
@@Donnerjkks Wendover and HAI are both made by the sam
@@metalrod record scratch whaaaaaaaat
One spreadsheet to rule them all!
Benjamin Smith One spreadsheet to find them
One spreadsheet to bring them all and in the darkness bind them
In the land of UPU, where the parcels lie.
“So it works”
I would tell you a joke about the czech postal service, but you wouldn’t get it
I don't know anything about the czech postal service, but oh man was that a swift pun.
Here you have my like.
Polish postal service is the same
So the Onion story about Kafka International being really shitty is based on reality?
I would send you a bomb but you wouldn't get it
omg lol
I was just about to purchase Apache Attack Helicopter, but then I noticed that t-shirt which is even cheaper. Great deal!
If you truly loved acronyms then you would know that those aren't acronyms. Acronyms are pronounced like words (NASA). Those are initialism and you say the letters (CIA).
Your comment has actually made him do an errata!
I like AMOOFLs.
I pronounce CIA “see ya”
Ok smarty pants
Actually I will be the nauseating nerd and explain that Maltava is only partially correct. Acronyms by definition MUST spell actual words. NASA may be pronounced like a word but it was not in the dictionary until the Administration came into existence. COLA is a true acronym because cola, the drink, exists as a word independently from a Cost Of Living Adjustment(COLA). COLA may not be the best example but it is a proper acronym. I once had to explain to my friend that even her professor did not know the correct definition of “generic.” He meant general degree.
The Australian postal service is a kangaroo
As an Australian, I can approve this.
It would be strange if it weren't...
they got pouches, don't they?
It's about as reliable ;)
The emus do the longest outback route the roos are more urban focused
Where's the link to the world's greatest spreadsheet??!!
AKII www.upu.int/en/activities/terminal-dues-and-transit-charges/2014-2017-cycle.html
thanks a lot that really helped me I couldn't find it anywhere.
Thanks, was also looking for it
Thanks a lot! I was looking for it too.
Thanks, I was looking for that too.
I’ve actually always wondered about how this works! Last April, I was in the Maldives, specifically the Dhaalu Atoll, and I sent a postage letter to Charlotte, NC. I wondered how my purchase of a stamp in my very remote resort would pay for the travel all the way back to the US. It took three months to arrive btw! This was very interesting.
3 months sounds about the average time to locate the lesser used regions on that spreadsheet
this video actually made me appreciate why mailing packages can sometimes be so expensive when u consider all the work that goes into getting ur package from one place to another amongst countless other packages
You should rename the channel to: Twice as interesting!
Cheers
Much better name. Also, he should put a TWIL series on this channel for videos specifically from TWIL
Andrea's Workshop reeking papa pig
Papa pig video
Been here to say that /flies away
This should be the top comment under each video in this channel.
Ha, the Nepal tag is awesome!
Eugene WasHere it's these little subtleties that show the true quality of these vids!
0:53
I was about to post that.
Well, that makes 2 of us.
HummusLord1337 same so 3 of us.
AdrianAtGaming welp.... 4
0:00 I honestly thought you said "This video was made possible by..." until I realized it was in my head at the transition
Australian Postal Service *shows video of kangaroo*
That was the least lethal Australian animal they could find.
@@flitsertheo Oh please, a chair in Australia is deadlier than a kangaroo, at least back in 2018.
What about air mail? Airborne couriers? Air post? Plane delivery? Air mail by plane? Plane Plane Plane Plane Plane
Air mail is done by private companies - e.g. FedEx, UPS, DHL.
Wouldn't that just be a different route on the spreadsheet? The Poland Australia route specifies it's by sea.
Kenny K Does the spreadsheet not handle private companies? I don't think it's all governments.
There is something like this for aircargo aswell, but that one is not managed by the UPU, but instead by the IATA. Just search for TACT (The Air Cargo Tariff)
Nobody in replies got the plane joke .
Holy shit I clicked the video to learn about the UPU but I found dank Memes instead
Bruce Wayne is Deadpool what is that meme?
I don't know what's a dank meme either
not as dank as my balls
What
Bruce Wayne is Deadpool and a tshirt that costs less than an attack helicopter
All I learned was that kangaroos deliver mail in Australia
I can't believe I'm watching this again 2 years later, and I just saw the Nepal detail at 0:53. This made the video for me!
Anyone looking for the spreadsheet: www.upu.int/en/activities/terminal-dues-and-transit-charges/2014-2017-cycle.html
Thanks! I've been looking and the page is not the most user friendly ;)
You are the most legends of legends to ever legend. Thank you.
Jonathan Fremstad thx m8
Thanks!!
amen
I'll keep that spreadsheet under my bed and read it when insomnia attacks.
Good luck printing over 500,000 cells.
As a flag enthusiast, I really appreciated the attention to Nepal at 0:52!
This is honestly one of the best videos you've ever made! It's just full to the brim with personality.
I hope someone automated the making of that list and did not do it by hand
They probably had a massive team doing it as new people (boats, governments, shipping companies) sent in their information. But the real question is... how did they send in their information if they didn't have the document???? lol jk probably just stamped it to hell.
Hopefully it is all in a database, and the spreadsheet is an exported snapshot.
But they get paid, so...
Paul Jones in stamps
Yeah, the jokes were fine but not much was actually explained about the list!
I see what you did with the map pin for Nepal 😎
Michael Shick NEPALI FLAG NEPALI FLAG
Michael Shick im just proud he knows where nepal my home country is
You are the most creative UA-camr that links their videos to their ads so smoothly. It's like the video was created for the ad read but the video is actually interesting. You're ads are worth watching.
Really interesting and well researched video! This is probably one of my favourite subscriptions. Keep up the good work!
Again i'm impressed. I Love watching your progression as a youtuber, i can hear your styles of teaching, humour, and your confidence in speaking getting better with every episode. I remember the first episode with the terrible audio, you've come a long way. Props!
Aw damn 2 in a row with no planes
John Jackson He's going to have withdrawal shakes soon
But it does have helicopter instead.
FINALLY!!!!!!! An episode which was not made possible by skillshare, squarespace, tab for a cause or any of these.
😂😂😀😂😀
Much recognition for polish złoty.
Who else here is Polish and is laughing how Sam pronounced Gdynia and Złoty? :)
Ja na przykład śmiałem się przez 1 minutę jak próbował powiedzieć "złoty"
Haha, no ja mieszkam w Sopocie wiec tak sie smialem jak powiedzial gdynia. Nie wiem dlaczego!
Ya prosto obchu na russkiom chto-be vse dumali chto ya polski
its like he laid latte lmao
Widzę że nawet tutaj dużo rodaków :D
Sam byłem w szoku jak wybrał akurat Polskę XD
I love how Sam’s subtle sarcasm keeps coming through on these videos. I hope it’s a trend that continues.
I'm so used to the serious tone of the Wendover Productions videos that the humor here caught off guard. I loved it!
This video is one of the best combination of comedy and quality I have ever seen on UA-cam. brb, gonna refresh the page and watch the whole ad without skipping it.
Loving the added humor in these videos!
I have finally found someone as crazy by spreadsheets and logistics as me. Amazing video, Sam. Thank you very much
This both felt like a huge meme and a huge ad. It's the best video ever.
Fantastic content, thank you for providing me with this new insight. Your enthusiasm is contagious. Plus, the Apache helicopter joke was gold. Great job, you continuously keep on making my day(s)! I'll go away now.
Do a video on school systems around the world and which one works the best!
Die hard Trulexovac Let me just say Perkele even though that video might not come out.
This is a terrific introduction to the international postal system. It's trending in the community!
The Statistics and Accounting guide for that spreadsheet is just as wonderful
funniest media content I've consumed in a looong time. Clicked in to learn trivia, ended up laughing uncontrollably in office...
This is dank memes covered as knowlage I was looking for everywhere. I now have found it.
We're excited, because we actually did send packages from Poland to Australia by post, and now we can see the background.
I could not love your work more; even the ads at the end are ... half as interesting (since you seem to mean, like Andrea said below, Twice as interesting!) Subscribed and shared ... woohoo!!
Okay, from one spreadsheet aficionado to another, well done! Interesting explanation. Keep up the good work.
So my choice is either 177,500 Half as Interesting T-Shirts or 1 Apache Attack Helicopter. VOTE NOW AS TO WHAT I BUY!
Zach Ashton fuck off
Attack Helicopter. Atleast that's something you can respectfully identity as.
Apache all the way.
T-shirts! Because I want to be different.
I absolutely love the references to meme content! First the Soviet anthem, then lizard people. Please continue to add these to your videos, because they are definitely appreciated.
do it but don't use it too much that you become behind the meme
This video's presentation had a lot more personality than I'm used to from you. Keep it up!
Wow...been following you since your first videos, but this is the first time I've seen you with a sense of humour. Love it!!!
As an Australian it does sometimes feel like Australia post is just some kangaroos at a shipping port
Love the extra humour!!
Bro, I watched every video you have ever uploaded from both channels and this one had me weak af 😂 you are normally so serious but you had us all geekin 😩
"If you're not as excited about this as me, you need to change your opinion."
I have found my favorite quote.
That's me on Sanremo week.
No planes?
Have you ever looked into routing protocols and how internet routing works? I think you'll enjoy it very much. Networking is a lot like transit, but even easier to understand because it's simpler!
I have always wondered how this was done and I find this very interesting! Once I even asked a woman at the post office how do they figure it all out and she didn't have an answer, and now I'm super tempted to go show her this video!
Quality on the second channel is great, keep up the good work broheim!
Next channel name
*Quarter as Interesting*
Lizard people? 🤔
Really enjoying the humor that is not seen over on Wendover Productions.
This video was absolutely fascinating! Thank you.
"If you're not as excited about this spreadsheet as me, you need to change your opinion..."
This video was far more interesting than it had any right to be. We'll done.
i love this channel, I've learn so much thank you.
Absolutely loving the dry humor. A+
I saw that Nepali flag...you clever person
when cause its at 1:55 as well
1:50 "SDRs are a special currency used by The Lizard Peop- I mean, Governments Of The World"
XD XD XD
Always suspected Wendy was with The Man.
ILLUMINATI CONFIRMED!
I miss 3 years ago
Whew this is a hell of a trip to travel back in time to hear his voice like this
0:52 i love the Nepal pop out... nicely done!
DFTBA? I thought this was run by Wendover not Foot of a Ferret
LARAUJO how is Hank Green a ferret?
DFTBA is a phrase popularised by the Vlog Brothers (Hank and John Green), they made DFTBA.com. If you hear almost any youtuber saying DFTBA they're usually referencing the vlog brothers (that includes foot of a ferret)
sirBrouwer who the eff is Hank?
Jacob Roeland how do you not know of Hank and John Green? They are probably the most influential UA-camrs of all.
Joshlama lol, wow. Didn’t expect that
1:54 Now we know who’s going to be busting down our doors.
I never thought about this before. But as soon as I clicked I wondered how I had never thought of this before! This is fascinating! This is amazing and I'm honestly glad I know this now!👊🏿
This videos style is awesome! Please keep it up like this!
4:17 AND HIS NAME IS JOHN CENAAAAAAA
cena means price in polish, captain price from call of duty translates to "kapitan cena" :D
*that meme is dead*
"Now go away" 😂😂
I'm impressed with all the research you did.
This spreadsheet is the greatest thing I've ever seen on UA-cam.
You are doing a good job on the videos. What do the kids say these days? Respect!?
I'm from Leicester and when he said your in Leicester I was like holy shit you wizard
Super interesting and well made! Subscribed! 😊
The other half of this channel is funny!
Great job with this!
0:22 lol 😂
Anyone got a link or anything to the spreadsheet????
I have always wondered this. Thank you!
Really love this channel - you seem to have more fun with this than Wendover.
2:15 ok, why is there a horse on the side of this building?
Wut
I didn't even notice 😂😂
I have absolutely no good explanation for this.
The God of Mail would be Hermes (Greek) or Mercury (Latin); however he has winged shoes, i don't know of him ever wielding a winged horse, because why would he, he's super fast and can fly around anywhere as he is. And oh BTW there's i think at least 4 named winged horses in Greek mythology, and dozens more across other cultures, so just because you see a winged horse, it doesn't necessarily have to be the Pegasus.
I have googled up things and have seen a Canadian stamp released in commemoration of Universal Postal Union; it had clearly Hermes on it, with his winged shoes, winged hat, winged staff, and not one but TWO winged horses behind him. They must have meant something by that, beats me what though. Them being two, obviously it makes at least one of them and potentially both obviously not Pegasus.
Maybe a winged horse was simply cheaper than Hermes to sculpt. After all, a slightly misshapen horse is still very much a horse, but a misshapen human is either very sad or very hilarious. And you know, the whole winged theme.
I actually went ahead and sent an inquiry to the Universal Postal Union about the winged horse on their wall. I'll let you know how it plays out.
Siana Gearz will be waiting
anyone who likes Matt Parker loves spreadsheets.
I like Matt Parker -> I love spreadsheets.
Very interesting topic! Really like your videos!
Just noticed that at 1:31 over half the post stamps depict either Queen Elizabeth II or her father King George VI