« previous next »
Pages: [1] 2   Go Down

Author Topic: MY Spreadsheet  (Read 5316 times)

Offline Nitantnel

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Apr 2011
  • Posts: 2967
  • Total likes: 3
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Brooklyn
MY Spreadsheet
« on: June 02, 2011, 11:29:19 AM »
For you to enjoy...
Logged

Offline muttman

  • Dansdeals Platinum Elite
  • ****
  • Join Date: Oct 2010
  • Posts: 345
  • Total likes: 1
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Monsey
Re: MY Spreadsheet
« Reply #1 on: June 02, 2011, 11:30:55 AM »
I  thought it would be filled in 8)
Logged
I take no responsibility for the results of your actions

Offline Yordai Dooma

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: May 2008
  • Posts: 4242
  • Total likes: 54
  • DansDeals.com Hat Tips 16
  • Gender: Male
    • View Profile
  • Programs: AA EXP/LT Platinum, SPG gold, Hyatt Globalist, IHG Platinum Ambassador, Hilton Gold, Marriott Gold, Hertz PC, National EE,
Re: MY Spreadsheet
« Reply #2 on: June 02, 2011, 11:31:05 AM »
Quote from: Nitantnel on June 02, 2011, 11:29:19 AM
For you to enjoy...

Nice spreadsheet. I love the complex formulas and all 17 words!
umm, what are you showing us?
Logged

Offline AsherO

  • Global Moderator
  • Dansdeals Lifetime 30K Presidential Platinum Elite
  • **********
  • Join Date: May 2008
  • Posts: 31016
  • Total likes: 7975
  • DansDeals.com Hat Tips 79
    • View Profile
  • Location: NYC
Re: MY Spreadsheet
« Reply #3 on: June 02, 2011, 11:56:08 AM »
Quote from: David on June 02, 2011, 11:31:05 AM
Nice spreadsheet. I love the complex formulas and all 17 words!
umm, what are you showing us?

It's a template, and it isn't bad. No reason to beat on the OP IMHO.

I once considered making a complex version of this in MS Access (Excel on steroids), but never got around to it.

Logged
DDF FFB (Forum From Birth)

Offline Jimbob

  • Dansdeals Platinum Elite
  • ****
  • Join Date: Dec 2009
  • Posts: 402
  • Total likes: 0
  • DansDeals.com Hat Tips 0
    • View Profile
Re: MY Spreadsheet
« Reply #4 on: June 02, 2011, 12:13:01 PM »
good way to keep organized
and maximize your applications.....
Logged

Offline sawlw

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Oct 2010
  • Posts: 1323
  • Total likes: 0
  • DansDeals.com Hat Tips 0
    • View Profile
Re: MY Spreadsheet
« Reply #5 on: June 02, 2011, 01:16:42 PM »
what do u charge an hour?   ;) lol
Logged

Offline Smokey Joe Robinson

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Apr 2011
  • Posts: 3032
  • Total likes: 6
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: New York
  • Programs: SPG Gold, HHonors Gold, Hyatt Plat, Club Carlson Gold Elite, Best Western Diamond Elite, Marriott Rewards Silver, Hertz President's Circle, National Executive Elite, Sixt Platinum, Delta Silver Medallion, United Premier Silver
Re: MY Spreadsheet
« Reply #6 on: June 02, 2011, 01:35:57 PM »
Quote from: David on June 02, 2011, 11:31:05 AM
Nice spreadsheet. I love the complex formulas and all 17 words!
umm, what are you showing us?
:o
Logged
My Programs Are Listed So That I Don't Forget Them :)

Offline smurf

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Sep 2010
  • Posts: 4557
  • Total likes: 307
  • DansDeals.com Hat Tips 8
    • View Profile
  • Location: NJ
Re: MY Spreadsheet
« Reply #7 on: June 02, 2011, 01:59:56 PM »
Quote from: AsherO on June 02, 2011, 11:56:08 AM
It's a template, and it isn't bad. No reason to beat on the OP IMHO.

I once considered making a complex version of this in MS Access (Excel on steroids), but never got around to it.
Can you get a program that'll also set reminders to call?
Logged

Offline AsherO

  • Global Moderator
  • Dansdeals Lifetime 30K Presidential Platinum Elite
  • **********
  • Join Date: May 2008
  • Posts: 31016
  • Total likes: 7975
  • DansDeals.com Hat Tips 79
    • View Profile
  • Location: NYC
Re: MY Spreadsheet
« Reply #8 on: June 02, 2011, 02:01:20 PM »
Quote from: smurf on June 02, 2011, 01:59:56 PM
Can you get a program that'll also set reminders to call?

In MS Access (or even Excel) you can use VBA to add events to your outlook calendar with reminders.
Logged
DDF FFB (Forum From Birth)

Offline MarkS

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Dec 2009
  • Posts: 3855
  • Total likes: 70
  • DansDeals.com Hat Tips 5
  • Gender: Male
    • View Profile
Re: MY Spreadsheet
« Reply #9 on: June 02, 2011, 02:37:50 PM »
I made a few enhancements to the spreadsheet.

Entering in a date in B will give you the rest of the dates.

You can change the formula in C,E,G & H to match your preference then drag it down to the rest of the cells.

Currently set as:
C - 4 days after B
E - 30 days after B
G - 360 days after B
H - 60 days after G
Logged

Offline Columbiadorm

  • Dansdeals Platinum Elite
  • ****
  • Join Date: Sep 2008
  • Posts: 396
  • Total likes: 2
  • DansDeals.com Hat Tips 0
  • Gender: Male
    • View Profile
  • Programs: Hertz Presidents Circle, Avis Presidents Club, National Executive Elite, Delta Silver Medallion, SPG Gold
Re: MY Spreadsheet
« Reply #10 on: June 02, 2011, 02:39:34 PM »
Quote from: AsherO on June 02, 2011, 02:01:20 PM
In MS Access (or even Excel) you can use VBA to add events to your outlook calendar with reminders.

I'm surprised you didn't note the typo on the spreadsheet...  ::)
Logged

Offline AsherO

  • Global Moderator
  • Dansdeals Lifetime 30K Presidential Platinum Elite
  • **********
  • Join Date: May 2008
  • Posts: 31016
  • Total likes: 7975
  • DansDeals.com Hat Tips 79
    • View Profile
  • Location: NYC
Re: MY Spreadsheet
« Reply #11 on: June 02, 2011, 02:51:11 PM »
Quote from: MarkS on June 02, 2011, 02:37:50 PM
I made a few enhancements to the spreadsheet.

Entering in a date in B will give you the rest of the dates.

You can change the formula in C,E,G & H to match your preference then drag it down to the rest of the cells.

Currently set as:
C - 4 days after B
E - 30 days after B
G - 360 days after B
H - 60 days after G

If you script in in VBA, you won't have to have all those weird dates for the empty lines....
Logged
DDF FFB (Forum From Birth)

Offline Zeeeeks

  • Dansdeals Platinum Elite
  • ****
  • Join Date: Mar 2011
  • Posts: 401
  • Total likes: 0
  • DansDeals.com Hat Tips 1
    • View Profile
Re: MY Spreadsheet
« Reply #12 on: June 02, 2011, 02:56:38 PM »
Quote from: AsherO on June 02, 2011, 02:51:11 PM
If you script in in VBA, you won't have to have all those weird dates for the empty lines....
Or for those that don't use VBA, in cell C2 enter "=IF($B2="","",$B2+4)"
Logged

Offline AsherO

  • Global Moderator
  • Dansdeals Lifetime 30K Presidential Platinum Elite
  • **********
  • Join Date: May 2008
  • Posts: 31016
  • Total likes: 7975
  • DansDeals.com Hat Tips 79
    • View Profile
  • Location: NYC
Re: MY Spreadsheet
« Reply #13 on: June 02, 2011, 03:03:17 PM »
Quote from: Zeeeeks on June 02, 2011, 02:56:38 PM
Or for those that don't use VBA, in cell C2 enter "=IF($B2="","",$B2+4)"

That works too, at least it'll be neat. The good thing with BVA is that it'll work no matter how many rows/records you add.
Logged
DDF FFB (Forum From Birth)

Offline MarkS

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Dec 2009
  • Posts: 3855
  • Total likes: 70
  • DansDeals.com Hat Tips 5
  • Gender: Male
    • View Profile
Re: MY Spreadsheet
« Reply #14 on: June 02, 2011, 03:07:06 PM »
Ammended as suggested
Logged

Offline AsherO

  • Global Moderator
  • Dansdeals Lifetime 30K Presidential Platinum Elite
  • **********
  • Join Date: May 2008
  • Posts: 31016
  • Total likes: 7975
  • DansDeals.com Hat Tips 79
    • View Profile
  • Location: NYC
Re: MY Spreadsheet
« Reply #15 on: June 02, 2011, 03:10:39 PM »
Quote from: MarkS on June 02, 2011, 03:07:06 PM
Ammended as suggested

The power of collaboration :)
Logged
DDF FFB (Forum From Birth)

Offline Nitantnel

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Apr 2011
  • Posts: 2967
  • Total likes: 3
  • DansDeals.com Hat Tips 0
    • View Profile
  • Location: Brooklyn
Re: MY Spreadsheet
« Reply #16 on: June 02, 2011, 05:55:06 PM »
I added one more column: "Spent this month."

I think that the more credit cards you use, the better it is for your credit. This will help remember which credit cards you already used, and which you still need to use.

BTW, if there's anyway to have a feature here like Google Doc's, where everyone can add their on additions, it would be amazing!
« Last Edit: June 02, 2011, 06:01:53 PM by Nitantnel »
Logged

Offline MarkS

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Dec 2009
  • Posts: 3855
  • Total likes: 70
  • DansDeals.com Hat Tips 5
  • Gender: Male
    • View Profile
Re: MY Spreadsheet
« Reply #17 on: June 02, 2011, 05:58:38 PM »
Quote from: Nitantnel on June 02, 2011, 05:55:06 PM
BTW, if there's anyway to have a feature here like Google Doc's, where everyone can add their on additions, it would be amazing!
Just download the most recent one I attached, make your changes, and attach it to your next comment. The next person can download yours, edit, and reattach.
Logged

Offline ChAiM'l

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Jan 2010
  • Posts: 1851
  • Total likes: 51
  • DansDeals.com Hat Tips 4
  • Gender: Male
    • View Profile
Re: MY Spreadsheet
« Reply #18 on: June 02, 2011, 07:40:28 PM »
@MarkS
That's where Google Docs comes in...
Logged

Offline Zeeeeks

  • Dansdeals Platinum Elite
  • ****
  • Join Date: Mar 2011
  • Posts: 401
  • Total likes: 0
  • DansDeals.com Hat Tips 1
    • View Profile
Re: MY Spreadsheet
« Reply #19 on: June 03, 2011, 10:21:21 AM »
Quote from: MarkS on June 02, 2011, 05:58:38 PM
Just download the most recent one I attached, make your changes, and attach it to your next comment. The next person can download yours, edit, and reattach.
I made a couple changes and added conditional formatting for the Cancellation Date.
Logged
Pages: [1] 2   Go Up
« previous next »