回程报告: 小榄->深圳宝安->石家庄正定->北京西, 全程464元

嗯嗯,这篇是深圳->北京回程报告,北京->深圳的详细去程报告请见-> https://feichashao.com/pek-szx-chi/

行程

8:00 出门吃早饭
8:40 - 10:35 小榄车站->深圳宝安汽车站。耗时约2小时。
10:35 - 10:50 宝安汽车站->翻身地铁站。步行即可,立交桥各种绕,地图软件不能少。
10:50 - 11:20 地铁站外KFC傻坐+豪华午餐。(报复麦当劳涨价)
11:20 - 11:50 地铁翻身站->地铁机场东站。
14:10 - 17:00 深圳->石家庄。少有的准点!
19:00 - 21:05 正定机场->北京西站
费用细分(元)
小榄到深圳大巴 70
深圳地铁 5
深圳-石家庄机票 199
燃油附加费 120
民航发展基金 50
正定机场-北京西动车 75.5
机场报销 (75.5)
--------------------------
合计 464

深圳宝安机场食品物价小调查

A楼二层,KFC,汉堡+薯条+汽水套餐约为38元,典型的KFC机场火车站宰客价;
A楼二层,世界之窗中式简餐,蔬菜面+例汤约为38元,一个装高档的价格;
A楼一层,大家乐,主食+汤/饮料约为31元,与市区大家乐同价,业界良心啊!
B楼二层,麦当劳甜品站,与市区同价;
B楼一层,麦当劳,套餐约为37元,同为宰客价。
B楼一层,Starbuck,与市区同价。
各7-11,物价为一般便利店的两倍。

宝安机场B楼出发厅(二层),麦当劳甜品站,价格与市区一致。
宝安机场B楼出发厅(二层),麦当劳甜品站,价格与市区一致。

宝安机场A楼到达层(一层)的大家乐,价格是业界良心!
宝安机场A楼到达层(一层)的大家乐,价格是业界良心!

火车票报销

准点到达石家庄正定机场,还算幸运。
火车票报销不要走“中转通道”,我走过去的时候被人拦截了...
走正常的“到达”出去,回到二层出发厅的高铁票退票柜台办理退票,也可以坐摆渡车去到正定机场站再报销。
摆渡车在一楼,出门就能看到标识。
摆渡车的运行表略为坑爹,如图,基本一小时才有一班,要是晚点赶火车就悲剧了。

不要在中转柜台报销火车票,直接回到出发层退票柜台退票.
不要在中转柜台报销火车票,直接回到出发层退票柜台退票.

正定机场高铁退票柜台
正定机场高铁退票柜台

正定机场高铁摆渡车候车处
正定机场高铁摆渡车候车处

回程总结

晚上从正定机场站回北京的动车只有7点这一班,而且还要2小时!
所以回程的问题有:航班延误风险 + 摆渡车班次少 + 动车耗时长;
南下问题不大,北上风险多多,要好好考虑了~

首班车7点,基本上一小时才有一班
首班车7点,基本上一小时才有一班

正定机场站站台
正定机场站站台

用VBA编程提高Excel(WPS表格)效率

不幸被抓住整理数据,6K行数据,上百列,纯手动的话估计手残了。
发现本地球还存在VBA此等神器,成功救赎。
本文只是简单演示VBA的威力,详细使用方法,请自行搜索“Excel VBA 手册”(WPS也通用)

————————————————————————

统计数据
统计数据

好,我们这里有一列5874行的数据。统计“你上过多少门课”,数据的形式是数字,单元格留白的表示没有回答。
我们想统计其中“上过1~10门课”的样品数。当然,除了VBA,你还可以用其他方法轻易把它弄出来,不过这里就先用这个简单的例子来演示VBA。

1.在“开发工具”选项卡中打开VBA编辑器(WPS免费版用户是不带VBA功能的,VBA是收费软件)
2.从表格可以看到,第2-5874行都是要处理的数据。
3.在sheet1中键入代码,如下。

Sub sub_dist()
    Dim c As Range '用于选定某一格
    Count = 0 '统计符合条件的样品数
    '对选定区域的每一格进行操作
    For Each c In Range("a2:a5875")
       If c.Value > 0 And c.Value <= 10 Then '如果当格数据满足大于0不超过10,则计数加1
       Count = Count + 1
       End If
   Next c
      Range("a5875").Value = Count '在a5875这一格显示统计数据
      
End Sub
代码
代码

4. 点击上方的运行按键,运行该函数。

运行
运行

5. 结果就如你所愿,出现在了第5875行。

结果
结果

------------------
VBA能使你从大量的枯燥工作中解脱出来,让你有更多时间做更多有意义的事。
网上可以搜索到大量VBA教程~Keep learning!

实践报告:从石家庄飞,北京<->深圳(广州) 单程含税最低370元

2017年10月14日。更新:目前机场已经不报销高铁票,改由航空公司销售空铁套票。最新实践,春秋航空 珠海->石家庄->北京。在春秋航空官网搜索(珠海->北京)的机票,则会出现空铁组合,350元含税。在航班到达石家庄后,乘坐免费摆渡车到高铁正定机场站,在高铁候机楼的售票处凭证件换取高铁票。深圳->北京,广州->北京同理。
-------------------------
石家庄正定机场空铁快线优惠原文:http://www.hebeiairport.com/aqscshow.asp?id=4485
简单地说,就是正定机场报销你从北京(或其他周边城市)到正定机场的高铁动车票。活动延期延期至2014年3月31日。

【回程:深圳->北京 https://feichashao.com/szx-sjw-chi/

摘要

只要持有石家庄起飞/抵达的航班机票,即可在石家庄机场报销从北京(及几个石家庄周边城市)到正定机场的高铁动车票。
轻轻算了一下,这次 北京->石家庄->深圳 全程花费389元。当然,从深圳到小榄的75元另算。
另外一个数字是,北京->广州 的特快硬卧中铺是441元,北京->深圳 的特快硬卧中铺449.5元。
不用多解释,这一程可以说是超值的!好,开始分享经验。

实践计划

0. 5:30 从学校出发,坐387或694到北京西站;
1. 7:10-8:28,D2001,北京西->正定机场;
2. 10:10-13:05, 9C8905, 石家庄(SJW)->深圳(SZX);

Beijing -> Zhengding Airport -> Shenzhen
Beijing -> Zhengding Airport -> Shenzhen

继续阅读“实践报告:从石家庄飞,北京< ->深圳(广州) 单程含税最低370元”

Beijing(PEK)<-->Shenzhen(SZX)/Guangzhou(CAN),via Shijiazhuang: The cheapest way to fly.

This article is for those guys who don't mind troubles. ⊙﹏⊙
So, here's a saving way to travel from Beijing to Shenzhen(or Guangzhou,Hong Kong) via Shijiazhuang Zhengding International Airport(SJW), which costs you low to ¥370 and about 8 hours for a single trip.

ITINERARY
1. Beijing West Railway Station -> Shijiazhuang Zhengding International Airport Station (by High-Speed Rail)
2. Shijiazhuang Zhengding International Airport Station -> Shijiazhuang Zhengding International Airport Terminal (by Free Shuttle Bus)
3. Fly to Shenzhen(SZX)/Guangzhou(CAN)/Hong Kong(HKG). (by Spring Airline, a low cost carrier. Or other airlines.)

Beijing -> Zhengding Airport -> Shenzhen
Beijing -> Zhengding Airport -> Shenzhen

So...actually...HOW to make it possible?
1. Buy the High-Speed Rail Ticket. You can buy it via Internet, Railway Station or Ticket agents.
a. I prefer buying ticket on the Internet. (You can buy tickets 20 days before departure, but you need a UnionPay card and the website is in Chinese.) Why not ask a local friend to help you out?
b. Maybe the most convenient way for you is to buy tickets at the Railway Station.(1~18 days before departure.) Tell the clerk your DESTINATION[Zhengding International Airport] and DEPARTURE DATE, show your PASSPORT, and pay. Tips: Buy tickets at Beijing North Station(Xizhimen) may save your time.
c. Recommend : Make sure you can get cheap air tickets before buying railway tickets.

2. Book your air ticket.
(Spring Airline is a Low Cost Carrier)
a. Click in Spring Airline Offcial Website: www.china-sss.com . You can switch it to English.
b. Search your flight. (The same as you do with other airlines)
c. Purchase it immediately if the fare is low enough. (Accept both Chinese bank card and International Credit Card.)
d. Caution: Special tickets can NOT be refund. ( except Taxes and Sub-charges )

3. Make sure your Connecting Time is more than 90 mins. (From the arrival of Railway to the departure of Flight)
OK, all the bookings you need are done.

How to... GO? Take Beijing->Shenzhen as an example.
1. I brought a railway ticket departure at 7:10. So I got to Beijing WEST station at 6:00 and had a Value Breakfast at McDonald's outside the station.(The McDonald's inside the station is a robber! Well, you know the reason.) It's recommended that you get to the railway station at least 30 min before departure.
2. The train took me to Zhengding airport station. I exited the paid area, followed the airport sign to take the shuttle bus. It took me about 10 min to the airport terminal.
3. I used the Self-service machine to check in. (Or Counter.)
4. With my Boarding Pass, I took few steps to the Airport Information Counter. Showed the stuff my Boarding Pass and High-Speed Rail Ticket, then he wiped out my High-Speed Rail fare.(Yes! He will give your money back!)
5. I passed the Security Check and did as usual.
6. Shenzhen!

How can this be such cheap?
1. You know, Spring Airline is a LCC.
2. Zhengding Airport is not busy,compared to Beijing. So Airline operation is low.
3. The airport is willing to attract passengers from nearby cities, so it wipe out your rail ticket.

-----------------------------
Writing down these might help you a lot.

1. English: Beijing West Station, 中文: 北京西站;
2. English: Zhengding Airport, 中文:正定机场;
3. English: High-Speed Rail, 中文:高铁(动车);
4. English: Ticket, 中文:票;

电影推荐:The Internship(2013) 实习大叔 挨踢实习生

初中,语文老师给我们出了一本校内书,收录同学的作文。
在“理想”一栏,我写了:成为Google的一名员工。
昨天,经过五道口,看着Google的小字,感慨万分。

所以昨晚,大逆不道搁置正事,看完了The Internship.
剧情可能一般般,但对Google粉来说,绝对是爽到爆。(中间还有近20分钟儿童不宜片段,难怪大陆不上映。)

看完发现,Nerd,Geek,Genius是有很大区别的。
一堆没停过的专业名词,压力各种大呀。

俩完全不懂技术的大叔,用人生阅历、非凡思想赢得了工作机会。
懂技术的这些nerds,该好好反思了。

——————————————————————————
We are all creatures of habit
We all like what we know
There's no question about it.
But you know what the scariest thing in life is?
The thing that frightens us the most?
Change.

I know I need to change to come along and give me a little kick in the ass to get me moving.
"Okay" isn't good, "Okay" isn't great.
...
that's better than good enough. that's best.
...
but I promise you something.
You lift your head up...and take a breath, there's a lot of great possibilities out there.

路过清华大学东门

昨日,在清华东门呆了一阵。
不同口音的游客来来往往,很多带着小孩。
似乎游过,总得在“清华大学”四字旁拍个照。
或是用作鼓励,或是弥补遗憾,又或者仅仅到此一游。

清华大学东门外
清华大学东门外

而当我走到这四字的背面,八个字映入眼帘。
“自强不息,厚德载物” 清华的校训。
看着莘莘学子进进出出,我仿佛悟到了什么:冲着“清华大学”进大学,怀着“自强不息厚德载物”到社会。
我猜,这是设计者的用意吧?

东门校牌的背面,写着清华校训
东门校牌的背面,写着清华校训

“天行健,君子以自强不息;地势坤,君子以厚德载物” ——《周易》