what's on your mind, right now?

justam

Leezestarr313 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 To think that it all happened because of these forums and PJ ...

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

Leezestarr313

justam wrote:

Leezestarr313 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 To think that it all happened because of these forums and PJ ...

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

Thank you

dimitrispearljam

that im unlucky..i hope that will change

dimitrispearljam

guilt is a bitch....

Sprunkn7

if power is on at work...

afroannnie

I just realized I left my lunch at home :(

pandora

samjam

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!

davidtrios

the world is so full of crap, why bother wiping your ass?

kw18

afroannnie wrote:

I just realized I left my lunch at home :(

Escape from the office and get some grub!

of.the.girl

FOOD!!! My protein shake isn't doing it for me. I wonder if it's too early to eat my lunch :think:

CAVSTARR313

love my girl

RKCNDY

of.the.girl 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.

of.the.girl

RKCNDY wrote:

of.the.girl 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.

Mamasan23

Seriously bosslady. It's an Excel formula, not brain surgery!!! Everyone is a total dumbass today :evil:

81

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)))

81

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

Mamasan23

I'm pretty sure her head would explode. Literally.

Sending now.

RKCNDY

of.the.girl wrote:

RKCNDY wrote:

of.the.girl 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:

81

the confrence room is empty

there is beer in the keg....

:think: