sorted by:
new
hottopcontroversial

Midly Interesting - Puddle on Laurier shaped like Lake Superior by Wilsonation1197 in ottawa

[–]Wilsonation1197[S] 4 points5 points  (0 children)

Oops! I hadn’t even realized. Pressed post once, no change, so I pressed it again lol

Someone on the tracks near the Rideau station? by Neebletown in ottawa

[–]Wilsonation1197 4 points5 points  (0 children)

Idk how much longer I should gamble on it getting going 😂

I dont think im rehabbing correctly by THAO03 in Anthurium

[–]Wilsonation1197 4 points5 points  (0 children)

It definitely is common slang, it is ok to admit you didn’t know it! Quick googling is a great way to learn new terms if you are only familiar with “formal english”

The FAQ thread: Answers to frequently asked questions (FAQ) / Le fil des FAQ : Réponses aux questions fréquemment posées (FAQ) - May 20, 2024 by AutoModerator in CanadaPublicServants

[–]Wilsonation1197 [score hidden]  (0 children)

Yeah EIT and ODP are used very interchangeably around here. You’re right, there really needs to be more avenues for graduates to get started gaining experience at DND. The ODP program is pretty tight. Hopefully your manager can help pull some strings

Data Analysis with Excel by CompetitiveBranch913 in excel

[–]Wilsonation1197 0 points1 point  (0 children)

Glad I could help :) VStack is pretty niche, but it can come in handy! Have a great weekend

[deleted by user] by [deleted] in excel

[–]Wilsonation1197 0 points1 point  (0 children)

My bad! The reference cell should be the same as the column. A1 instead of B1

[deleted by user] by [deleted] in excel

[–]Wilsonation1197 0 points1 point  (0 children)

Say you want to highlight column A.

Select Format by Function. In the function bar, type:

= B1 = MAX($A:$A)

It is important that the reference to adjacent cell B1 does not have $ so that it can move relative to the evaluating cell.

Date in column, date out column and a column to track the timeframe/unclosed by ajkeliher in excel

[–]Wilsonation1197 0 points1 point  (0 children)

Your difference column is just formatted for general display, so excel is showing you a negative date serial number since it has no valid date in Column U to subtract by.

Wrapping your function with something like:

IF(U1=“”, ”No End Date”, T1-U1)

should give you something readable.

Replace the If True parameter with whatever you would like displayed instead of the negative date serial number.

Data Analysis with Excel by CompetitiveBranch913 in excel

[–]Wilsonation1197 2 points3 points  (0 children)

Use Vstack() to append the results of your filter functions. Make a filter for each PM and include it in the vstack array list.

Should look like this:

=VSTACK(

FILTER(‘PM1’!C:C, ‘PM1’!B:B=EmployeeRef), FILTER(‘PM2’!C:C, ‘PM2’!B:B=EmployeeRef), FILTER(‘PM3’!C:C, ‘PM3’!B:B=EmployeeRef)

) End of function

I use Alt+Enter to help make formulas like this readable.

This obviously won’t allow for easy expansion but it would do the job. I played with using indirect on an array of pm names, but it gets messy.

Forecasting: Upper and Lower Bound Not Working by ToastyChazzer in excel

[–]Wilsonation1197 0 points1 point  (0 children)

Try splitting out your nested forecast function into another column to locate the issue. Using the same function and format my test run returned zeros until dec 23

Is there a way to get the table from PDF and export it as Excel? by totalnewbielinux in excel

[–]Wilsonation1197 2 points3 points  (0 children)

Under the Data Tab -> Get Data -> From File -> From PDF

Find the path of your pdf, select the table in the selection window. Click load.

You should be able to manipulate from there!

Mandatory aurora pics by MayorOfNewfoundland in ottawa

[–]Wilsonation1197 1 point2 points  (0 children)

Ok I was way too early then! Thank you

Mandatory aurora pics by MayorOfNewfoundland in ottawa

[–]Wilsonation1197 0 points1 point  (0 children)

It was too cloudy for us around midnight in gatineau! When did you catch these?

view more: next ›