因為呢排大多卡有好抵既食肆簽賬優惠關係,而且係唔同日子簽同簽唔同價錢都唔同計法,咁係唔同既情況下應該用邊張卡最抵呢?話說小斯呢排因為工作上既關係,學佐用excel set formula,所以就試整佐個excel表,可以俾大家input你既單一簽賬同其他條件之外,就可以幫你計出用邊張卡簽係最抵架啦!
要input既野包括
1. 單一簽賬金額2. 星期五?
3. 星期六日? (Y/N)
4. 指定節日及其前夕?
5. 最紅自主獎賞倍數(1-6)
6. 10/5, 10/6, 10/7?
然後個excel就會自動gen出每張卡簽幾多錢就有1里,然後當然係數字愈低既就代表簽個張卡最抵啦^^
食肆簽賬excel:https://docs.google.com/spreadsheets/d/1bnuun4UR3KJkUxJMn5kfQcnXNoh20pz4NbKOCTX95oc/edit#gid=0
由於呢個係google doc既關係,全世界都可以改既,所以大家咪亂改亂我條formula呀XD
但係我未研發到點樣可以用手機都開到呢個google doc去計條數出黎,有冇IT既fans可以幫幫手呢^^?
希望呢個新發明能夠幫到大家啦!
like佐我facebook未呢?
https://www.facebook.com/FlyForMiles
like完都仲要記得set返get notification先可以收到我既即時資訊架^^
😀 😀 我是一條分隔線 😀 😀
記得同時要like埋我 facebook,仲要撳埋"see first", 咁先會第一時間睇到我出既最新優惠!
同埋梗係要follow 埋我Instagram,睇我啲靚相同IG Story啦!
38 comments
Skip to comment form
請問如要簽食肆,唔係應該簽中銀有六倍積分好D咩?
Author
你指呢張?
http://flyformiles.hk/%E4%B8%AD%E9%8A%80visa-infinite%EF%BC%8C6%E5%80%8D%E6%9C%AC%E5%9C%B0%E9%A3%B2%E9%A3%9F%E5%8F%8A%E6%B5%B7%E5%A4%96%E7%B0%BD%E8%B3%AC%E7%A9%8D%E5%88%86%EF%BC%81/
門檻高嘛
係呀,係呢張,原來真係難申請喎,都搵唔到申請表格的。
Author
要等佢Invite你架
小斯可唔可以教下點樣好似你咁自制formula
小斯咁醒唔怪得咁易儲miles啦 xd
Author
下 咁咪即係叫我開電腦班? XD
其實我D excel都唔係好勁架喳XD
請問如果我想去冰島,點飛最抵?
係咪用miles換機票去芬蘭轉機最好?
但點解我搵唔到去分蘭要幾多miles嘅?
係呢呢條link?
http://www.asiamiles.com/am/zh/redeem/flightawardfinder#newCalculator
其實有冇list係列晒所有可換國家&所需miles ga? Thks Thks
Author
冇個list架 得個距離俾你睇架喳
芬蘭睇呢個post啦: http://flyformiles.hk/?p=197
小斯我想問. Fubon 的10號10倍分, 可唔可以網上消費ga?
Author
唔可以架
咁出街食飯呢?
Author
梗係計啦, 有底單就計
well. actually you can get 9X Bonus Points at all dining outlets in Hong Kong with BEA credit card on 10th and 11th. too late to let you know, probably
http://www.hkbea.com/html/en/bea-credit-card-dining-offer-mothersday.html
HSBC條公式好似有錯喎XD, HSBC最少都兩倍分咩?
Author
改好啦XD 唔該晒XD
>係我未研發到點樣可以用手機都開到呢個google doc去計條數出黎,有冇IT既fans可以幫幫手呢^^?
其實有計嘅, 但係大工程咁囉
BTW我又加左個新功能俾你XD
Author
見到XD 好勁XD
Author
係咪download個apps就得?
唔係, 要配搭google表單黎做, 其他人填好晒資料一submit就會update個試算表,你再將個結果發佈出去用iframe output去一個網頁(個網頁當然又要自己整啦XD), 咁手機都可以就咁用瀏覽器check到結果.....但咁整你就要全部重做囉=3=
咁做都有多一個好處就係其他人抄唔到你點整
Author
好明顯我唔明你UP緊乜啦XD
Author
我宜家出街都係用個google doc去改喳
Author
大哥! 有野搵你呀!
你介唔介意email我???
[email protected]
我想你教我用google doc呀
可以加入以下功能:
1. 百貨公司內 / 酒店內 / 會所內食肆簽賬 – 計算方法
2. 新增以下信用卡作計算:
-CITIBANK PRESTIGE
-CITIBANK PREMIERMILES
-東亞白金
-CITIBANK REWARDS
-上商TITANIUM MASTER
因為呢而家個表果幾張卡,係食飯上各有輸贏先做個表啫,而你提既呢D卡就無乜可比性
Author
終於有人答佐我心裡面個句
well. actually you can get 9X Bonus Points at all dining outlets in Hong Kong with BEA credit card on 10th and 11th. too late to let you know, probably
http://www.hkbea.com/html/en/bea-credit-card-dining-offer-mothersday.html
Author
thank you
是否此處假設富邦只抽到2000分?
Author
係
小斯終於識用Google文件囧
用粗體深紅字打左個提示俾你
幫你加多左個功能,最抵里數果間Bank個Background會即刻highlight左,咁係咪易睇好多呢
仲有咩功能想要?你講出黎我幫你加XDDD
幫你整完唔夠五分鐘好似比你鏟左成個page囧
Author
-___-
Author
我唔知你整佐XD
可唔可以我解鎖你幫我整多次XD
笑死我…上面好多人呀
Author
我都覺XD 好用嗎?