新發明:食肆簽賬里數機

因為呢排大多卡有好抵既食肆簽賬優惠關係,而且係唔同日子簽同簽唔同價錢都唔同計法,咁係唔同既情況下應該用邊張卡最抵呢?話說小斯呢排因為工作上既關係,學佐用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未呢?
like完都仲要記得set返get notification先可以收到我既即時資訊架! 仲要follow埋我Instagram 睇靚相添呀

你可能會有興趣..

38 comments

Skip to comment form

    • Mavis on September 18, 2014 at 12:52 am
    • Reply

    請問如要簽食肆,唔係應該簽中銀有六倍積分好D咩?

        • Mavis on September 18, 2014 at 7:28 pm
        • Reply

        係呀,係呢張,原來真係難申請喎,都搵唔到申請表格的。

        1. 要等佢Invite你架

    • sean on May 28, 2014 at 12:03 pm
    • Reply

    小斯可唔可以教下點樣好似你咁自制formula
    小斯咁醒唔怪得咁易儲miles啦 xd

    1. 下 咁咪即係叫我開電腦班? XD
      其實我D excel都唔係好勁架喳XD

    • YY on May 12, 2014 at 10:36 am
    • Reply

    請問如果我想去冰島,點飛最抵?
    係咪用miles換機票去芬蘭轉機最好?
    但點解我搵唔到去分蘭要幾多miles嘅?
    係呢呢條link?
    http://www.asiamiles.com/am/zh/redeem/flightawardfinder#newCalculator

    其實有冇list係列晒所有可換國家&所需miles ga? Thks Thks

    1. 冇個list架 得個距離俾你睇架喳
      芬蘭睇呢個post啦: http://flyformiles.hk/?p=197

    • MC on May 11, 2014 at 7:12 pm
    • Reply

    小斯我想問. Fubon 的10號10倍分, 可唔可以網上消費ga?

    1. 唔可以架

        • MC on May 11, 2014 at 11:49 pm
        • Reply

        咁出街食飯呢?

        1. 梗係計啦, 有底單就計

    • Chiccat on May 11, 2014 at 5:42 pm
    • Reply

    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

    • TB on May 10, 2014 at 7:55 pm
    • Reply

    HSBC條公式好似有錯喎XD, HSBC最少都兩倍分咩?

    1. 改好啦XD 唔該晒XD

    • TB on May 10, 2014 at 3:29 am
    • Reply

    >係我未研發到點樣可以用手機都開到呢個google doc去計條數出黎,有冇IT既fans可以幫幫手呢^^?

    其實有計嘅, 但係大工程咁囉

      • TB on May 10, 2014 at 3:53 am
      • Reply

      BTW我又加左個新功能俾你XD

      1. 見到XD 好勁XD

    1. 係咪download個apps就得?

        • TB on May 10, 2014 at 11:56 pm
        • Reply

        唔係, 要配搭google表單黎做, 其他人填好晒資料一submit就會update個試算表,你再將個結果發佈出去用iframe output去一個網頁(個網頁當然又要自己整啦XD), 咁手機都可以就咁用瀏覽器check到結果.....但咁整你就要全部重做囉=3=

          • TB on May 11, 2014 at 12:02 am
          • Reply

          咁做都有多一個好處就係其他人抄唔到你點整

            • 小斯 on May 11, 2014 at 12:33 am
              Author

            好明顯我唔明你UP緊乜啦XD

        1. 我宜家出街都係用個google doc去改喳

    2. 大哥! 有野搵你呀!
      你介唔介意email我???
      [email protected]

      我想你教我用google doc呀

    • Derek Poon on May 10, 2014 at 12:57 am
    • Reply

    可以加入以下功能:
    1. 百貨公司內 / 酒店內 / 會所內食肆簽賬 – 計算方法
    2. 新增以下信用卡作計算:
    -CITIBANK PRESTIGE
    -CITIBANK PREMIERMILES
    -東亞白金
    -CITIBANK REWARDS
    -上商TITANIUM MASTER

      • TB on May 10, 2014 at 1:26 am
      • Reply

      因為呢而家個表果幾張卡,係食飯上各有輸贏先做個表啫,而你提既呢D卡就無乜可比性

      1. 終於有人答佐我心裡面個句

        • Chiccat on May 11, 2014 at 5:43 pm
        • Reply

        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

        1. thank you

    • Derek Poon on May 10, 2014 at 12:53 am
    • Reply

    是否此處假設富邦只抽到2000分?

    • TB on May 9, 2014 at 11:00 pm
    • Reply

    小斯終於識用Google文件囧
    用粗體深紅字打左個提示俾你

      • TB on May 9, 2014 at 11:26 pm
      • Reply

      幫你加多左個功能,最抵里數果間Bank個Background會即刻highlight左,咁係咪易睇好多呢
      仲有咩功能想要?你講出黎我幫你加XDDD

        • TB on May 9, 2014 at 11:31 pm
        • Reply

        幫你整完唔夠五分鐘好似比你鏟左成個page囧

        1. -___-

        2. 我唔知你整佐XD
          可唔可以我解鎖你幫我整多次XD

    • Lap on May 9, 2014 at 7:16 pm
    • Reply

    笑死我…上面好多人呀

    1. 我都覺XD 好用嗎?

Leave a Reply

Your email address will not be published.