what's on your mind, right now?

1127212731275127712782261

Comments

  • justamjustam Posts: 21,410
    Almost at this very time two weeks ago, I arrived in the States to be with Cav. So far, it has been nothing short of wonderful. I'm so glad and thankful that my life has taken this turn :mrgreen: To think that it all happened because of these forums and PJ ...

    I think your love story is incredibly sweet. :D
    I wish you both a ton of luck.
    &&&&&&&&&&&&&&
  • Leezestarr313Leezestarr313 Posts: 14,352
    justam wrote:
    Almost at this very time two weeks ago, I arrived in the States to be with Cav. So far, it has been nothing short of wonderful. I'm so glad and thankful that my life has taken this turn :mrgreen: To think that it all happened because of these forums and PJ ...

    I think your love story is incredibly sweet. :D
    I wish you both a ton of luck.


    Thank you :D
  • that im unlucky..i hope that will change
    "...Dimitri...He talks to me...'.."The Ghost of Greece..".
    "..That's One Happy Fuckin Ghost.."
    “..That came up on the Pillow Case...This is for the Greek, With Our Apologies.....”
  • guilt is a bitch....
    "...Dimitri...He talks to me...'.."The Ghost of Greece..".
    "..That's One Happy Fuckin Ghost.."
    “..That came up on the Pillow Case...This is for the Greek, With Our Apologies.....”
  • Sprunkn7Sprunkn7 Posts: 5,286
    if power is on at work...
    Thank you fellow 10 clubber for saving my ass....again!!!
  • afroannnieafroannnie Posts: 12,995
    I just realized I left my lunch at home :(
    Show #13 was a lucky one for me....
  • pandorapandora Posts: 21,855
    TrickOrTreat0.gif
  • samjamsamjam Posts: 9,283
    I have this one professor who literally yells at us all. We do the work she asks, or we attempt to do it (we meaning a crappy group I have to work with, which makes everything worse), and then we get horrible grades. I have enough to worry about, I don't need failing a stupid required junior English course to be on my mind :evil: Literally could have picked from hundreds of junior English courses, and of course this is what I get. Frustrated!
    "Sometimes you find yourself having to put all your faith in no faith."
    ~not a dude~
    2010: MSGx2
    2012: Made In America
    2013: Pittsburgh, Brooklynx2, Hartford, Baltimore
    2014: Leeds, Milton Keynes, Detroit
    2015: Global Citizen Festival
    2016: Phillyx2, MSGx2, Fenwayx2
    2018: Barcelona, Wrigleyx2
  • davidtriosdavidtrios Posts: 9,732
    the world is so full of crap, why bother wiping your ass?
  • kw18kw18 Posts: 3,909
    afroannnie wrote:
    I just realized I left my lunch at home :(

    Escape from the office and get some grub!
    "Where's KW?"
    "Let's check Idaho."
  • of.the.girlof.the.girl Posts: 10,026
    FOOD!!! My protein shake isn't doing it for me. I wonder if it's too early to eat my lunch :think:
  • CAVSTARR313CAVSTARR313 Posts: 8,756
    love my girl :D
    None are more hopelessly enslaved than those who falsely believe that they are free.
    Abrn Hlls '98 - Clarkston 2 '03 - Grd Rpds '06 - Abrn Hlls '06 - Clvd '10 - PJ20 - Berlin 1+2 '12 - Wrigley '13 - Pitt '13- buff '13- Philly 1+2 '13 - Seattle '13
  • RKCNDYRKCNDY Posts: 31,013
    FOOD!!! My protein shake isn't doing it for me. I wonder if it's too early to eat my lunch :think:

    how many grams of protein are in your protein drink? Sometimes if it doesn't have enough, you still get hungry.
    The joy of life comes from our encounters with new experiences, and hence there is no greater joy than to have an endlessly changing horizon, for each day to have a new and different sun.

    - Christopher McCandless
  • of.the.girlof.the.girl Posts: 10,026
    RKCNDY wrote:
    FOOD!!! My protein shake isn't doing it for me. I wonder if it's too early to eat my lunch :think:

    how many grams of protein are in your protein drink? Sometimes if it doesn't have enough, you still get hungry.

    32g. I've tried a new protein shake concoction and it isn't doing it for me. I might have to revert back to my old concoction.
  • Mamasan23Mamasan23 Posts: 16,388
    Seriously bosslady. It's an Excel formula, not brain surgery!!! Everyone is a total dumbass today :evil:
    WI '98,  WI '99 (EV),  WI '00,  Chgo '00,  MO '00,  Champaign '03,  Chgo '03,  WI '03,  IN '03,  MI '04,  Chgo '06:N1 & 2,  WI '06,  Chgo '07,  Chgo '08 (EV:N1),  Chgo '09:N1 & 2,  Chgo '11 (EV:N1),  WI '11:N1 & 2,  Philly '12,  Wrigley '13,  Pitt '13,  Buff '13, Detroit '14, MKE '14, Wrigley '16: N1 & N2, Seattle '18 N2, Wrigley '18: N1 & N2, Fenway '18 N1, STL '22, St Paul '23 N2, Chgo '23: N1 & N2
  • 8181 Posts: 58,276
    edited October 2012
    Mamasan23 wrote:
    It's an Excel formula

    send her these....should fix her right up.


    =IF(AND($E5>=P$3,$F5<=P$4),$C5,IF(AND($E5>=P$3,$E5<=P$4),((P$4-$E5+1)/$M5*$C5),IF(AND($F5<=P$4,$F5>=P$3),($F5-P$3+1)/$M5*$C5,IF(AND($E5<P$3,$F5>P$4),(P$4-P$3+1)/$M5*$C5,0))))


    =IF(E$6="actual",SUMIF('FY12 Actuals'!$F:$F,'FY12 Plan'!$S457&"A"&'FY12 Plan'!E$7,'FY12 Actuals'!$E:$E),SUMIF('FY12 Forecast'!$N:$N,'FY12 Plan'!$S457,'FY12 Forecast'!B:B))

    =IF(IF(SUM($T9:X9)<=102000,X9,(102000-SUM($T9:W9)))<0,0,(IF(SUM($T9:X9)<=102000,X9,(102000-SUM($T9:W9)))))*0.062

    =ROUND(IF(J9=0,0,IF(V$1<$E9,$C9/2080*40*V$2*J9,$F9/2080*40*V$2*J9)),2)

    =IF(ISERROR(VLOOKUP(LEFT(A2,10),Misc!W:X,2,FALSE)),A2,VLOOKUP(LEFT(A2,10),Misc!W:X,2,FALSE)&RIGHT(A2,9))


    =IF(ISERROR(IF(AND(BM$12="scheduled",BL$12="actual",$C29="closed",$A29<>992007,$A29<>992009),$AG29-$AK29,IF(BM$12="Actual",SUMIF('FY12 Actuals'!$F:$F,Report!$A29&Report!BM$14,'FY12 Actuals'!$K:$K),$AN29*AZ29))),0,IF(AND(BM$12="scheduled",BL$12="actual",$C29="closed",$A29<>992007,$A29<>992009),$AG29-$AK29,IF(BM$12="Actual",SUMIF('FY12 Actuals'!$F:$F,Report!$A29&Report!BM$14,'FY12 Actuals'!$K:$K),$AN29*AZ29)))
    Post edited by 81 on
    81 is now off the air

    Off_Air.jpg
  • 8181 Posts: 58,276
    if those don't work, i'd suggest going this route

    Private Sub Command0_Click()

    DoCmd.RunSQL "DELETE * FROM [FY12_Plan]"


    Dim xlapp As Object
    Dim oWb As Object

    Set xlapp = CreateObject("Excel.Application")



    Dim rsdept As New ADODB.Recordset

    rsdept.ActiveConnection = CurrentProject.Connection

    rsdept.Open "Departments"

    Do While Not rsdept.EOF




    strFile = "P:\Finance - Shared\Plan\FY12\P&L\" & rsdept("dep_name") & ".xls"
    strPassword = rsdept("pw")

    Set oWb = xlapp.Workbooks.Open(FileName:=strFile, Password:=strPassword)


    DoCmd.TransferSpreadsheet acImport, 8, _
    "FY12_Plan", strFile, True, "Plan_Upload"

    oWb.Close SaveChanges:=False



    rsdept.MoveNext
    Loop




    xlapp.Quit
    Set xlapp = Nothing
    Set oWb = Nothing

    DoCmd.RunSQL "DELETE * FROM [FY12_Plan] WHERE [account] is null"


    DoCmd.RunSQL "UPDATE FY12_Plan SET FY12_Plan.Test = 1 WHERE ((([FY12_Plan]![Period 1])<>0)) OR ((([FY12_Plan]![Period 2])<>0)) OR ((([FY12_Plan]![Period 3])<>0)) OR ((([FY12_Plan]![Period 4])<>0)) OR ((([FY12_Plan]![Period 5])<>0)) OR ((([FY12_Plan]![Period 6])<>0)) OR ((([FY12_Plan]![Period 7])<>0)) OR ((([FY12_Plan]![Period 8])<>0)) OR ((([FY12_Plan]![Period 9])<>0)) OR ((([FY12_Plan]![Period 10])<>0)) OR ((([FY12_Plan]![Period 11])<>0)) OR ((([FY12_Plan]![Period 12])<>0))"

    DoCmd.RunSQL "DELETE * FROM [FY12_Plan] WHERE [test] is null"



    End Sub
    81 is now off the air

    Off_Air.jpg
  • Mamasan23Mamasan23 Posts: 16,388
    I'm pretty sure her head would explode. Literally.

    Sending now.

    :lol:
    WI '98,  WI '99 (EV),  WI '00,  Chgo '00,  MO '00,  Champaign '03,  Chgo '03,  WI '03,  IN '03,  MI '04,  Chgo '06:N1 & 2,  WI '06,  Chgo '07,  Chgo '08 (EV:N1),  Chgo '09:N1 & 2,  Chgo '11 (EV:N1),  WI '11:N1 & 2,  Philly '12,  Wrigley '13,  Pitt '13,  Buff '13, Detroit '14, MKE '14, Wrigley '16: N1 & N2, Seattle '18 N2, Wrigley '18: N1 & N2, Fenway '18 N1, STL '22, St Paul '23 N2, Chgo '23: N1 & N2
  • RKCNDYRKCNDY Posts: 31,013
    RKCNDY wrote:
    FOOD!!! My protein shake isn't doing it for me. I wonder if it's too early to eat my lunch :think:

    how many grams of protein are in your protein drink? Sometimes if it doesn't have enough, you still get hungry.

    32g. I've tried a new protein shake concoction and it isn't doing it for me. I might have to revert back to my old concoction.

    when I made protein shakes, they would have around 45-50g of protein...I had to force myself to eat lunch! Try adding flax or chia seed or greek yogurt to it. :thumbup:
    The joy of life comes from our encounters with new experiences, and hence there is no greater joy than to have an endlessly changing horizon, for each day to have a new and different sun.

    - Christopher McCandless
  • 8181 Posts: 58,276
    the confrence room is empty

    there is beer in the keg....

    :think:
    81 is now off the air

    Off_Air.jpg
  • of.the.girlof.the.girl Posts: 10,026
    Thanks Lisa! New concoction starting tomorrow. :D
  • kw18kw18 Posts: 3,909
    81 wrote:
    the confrence room is empty

    there is beer in the keg....

    :think:

    :shock:

    :think:

    Where's your office again? I'll be right over. :lol:
    "Where's KW?"
    "Let's check Idaho."
  • of.the.girlof.the.girl Posts: 10,026
    81 wrote:
    the confrence room is empty

    there is beer in the keg....

    :think:

    you aren't doing your part by drinking it then. slacker
  • 8181 Posts: 58,276
    kw18 wrote:
    81 wrote:
    the confrence room is empty

    there is beer in the keg....

    :think:

    :shock:

    :think:

    Where's your office again? I'll be right over. :lol:


    3500 Lacey Road, Downers Grove, IL
    81 is now off the air

    Off_Air.jpg
  • kw18kw18 Posts: 3,909
    81 wrote:
    kw18 wrote:
    81 wrote:
    the confrence room is empty

    there is beer in the keg....

    :think:

    :shock:

    :think:

    Where's your office again? I'll be right over. :lol:


    3500 Lacey Road, Downers Grove, IL

    BOOZE TIME.
    "Where's KW?"
    "Let's check Idaho."
  • of.the.girlof.the.girl Posts: 10,026
    hey dumbass!! when you go into a place of possible employment....don't go in reeking of marijuana and alchohol!! asshats!
  • 8181 Posts: 58,276
    hey dumbass!! when you go into a place of possible employment....don't go in reeking of marijuana and alchohol!! asshats!

    i fail to see the issue
    81 is now off the air

    Off_Air.jpg
  • peacefrompaulpeacefrompaul Posts: 25,293
    81 wrote:
    hey dumbass!! when you go into a place of possible employment....don't go in reeking of marijuana and alchohol!! asshats!

    i fail to see the issue

    +1
  • of.the.girlof.the.girl Posts: 10,026
    81 wrote:
    hey dumbass!! when you go into a place of possible employment....don't go in reeking of marijuana and alchohol!! asshats!

    i fail to see the issue
    :fp:

    I can see where you would.


    This asshat came in for an interview like this! HR welcomed him and the interview lasted tops 4 minutes and he was out the door. No job for you asshat!
  • peacefrompaulpeacefrompaul Posts: 25,293
    81 wrote:
    hey dumbass!! when you go into a place of possible employment....don't go in reeking of marijuana and alchohol!! asshats!

    i fail to see the issue
    :fp:

    I can see where you would.


    This asshat came in for an interview like this! HR welcomed him and the interview lasted tops 4 minutes and he was out the door. No job for you asshat!

    Oh god... HR welcomed him in? He had no chance. Poor guy
Sign In or Register to comment.