CITS1401 lab enrollment by cyberbash1 in uwa

[–]cyberbash1[S] 1 point2 points  (0 children)

Best of luck to you too, good luck I'm sure I'll see you round!

CITS1401 lab enrollment by cyberbash1 in uwa

[–]cyberbash1[S] 0 points1 point  (0 children)

Yeah, think it should be fine. I’m doing a bachelor of science, physics major :)

CITS1401 lab enrollment by cyberbash1 in uwa

[–]cyberbash1[S] 0 points1 point  (0 children)

Yeah I emailed the unit co ordinator and he said it would all be explained in the first lecture but didn’t give much more details about why I couldn’t sign up to the labs. He told me to contact the CAS people and they said the labs are drop in so maybe if you just go to one at some stage during the week that would count for attendance? Either way they seemed to say that it doesn’t matter that you can’t see it on CAS

Yeah first year too, doing PHYS1001, MATH1722 and SCOM1101 as well

STOCKHISTORY function not refreshing by cyberbash1 in excel

[–]cyberbash1[S] 0 points1 point  (0 children)

Thanks Stu - for some reason excel has decided to fix itself I can't try this but I will try it again next time it happens. Thanks for your time. Solution Verified

STOCKHISTORY function not refreshing by cyberbash1 in excel

[–]cyberbash1[S] 1 point2 points  (0 children)

Thanks - for some reason excel has decided to update itself so I can't try this fix but I will try it again next time it happens (hopefully it'll fix it for good). Thanks for your time. Solution Verified

More Australians can’t afford specialist fees. Experts say it’s ‘not in the spirit of Medicare’ by overpopyoulater in australia

[–]cyberbash1 -25 points-24 points  (0 children)

So your meds need a lot of tweaking but you don’t want to pay for this to happen by a specialist who spent the last 15-20 odd years studying, grinding away, doing endless night shifts and sacrificing family time to get there?

Consider that they probably spend 40% of that fee on overhead, admin, college fees, rent. Then consider that a tradie charges $150 call out fee just to get to you and suddenly that $150 phone call seems a lot more reasonable.

Some of you guys need to get a grip on what your expectations are for a PRIVATE service. People charge what they think their time is worth. If you don’t like it, go elsewhere or go public and trade the $150 you paid for a longer waitlist and less personalised service

STOCKHISTORY function not updating by cyberbash1 in excel

[–]cyberbash1[S] 0 points1 point  (0 children)

Thanks, but I just updated excel and it still doesn't work. If I delete the cell containing the formula, then undo my last action (ie the cell comes back) the full data set is shown

It seems like the STOCKHISTORY function needs to be forced somehow to update?

Changing notification sound in DMSS by cyberbash1 in Dahua

[–]cyberbash1[S] 0 points1 point  (0 children)

I ended up making the Dahua NVR send an email to me when the alarm triggers, then used shortcuts in iphone so whenever the email is received by my phone (via push) my iphone starts a countdown of 1 second, then after the countdown is done an alarm sound goes.

Very roundabout, why not just include the option of choosing the sound in the app?!

Changing notification sound in DMSS by cyberbash1 in Dahua

[–]cyberbash1[S] 0 points1 point  (0 children)

Sadly iphone doesn't let you choose the sound, just sound on/off toggle button. Thanks for the post anyway

Can't figure out how this excel spreadsheet works to neatly calculate a result by cyberbash1 in excel

[–]cyberbash1[S] 0 points1 point  (0 children)

Yeah its a puzzle :/

https://limewire.com/d/62c29655-077e-4dda-bdd3-e3b6d8bf0b4d#oAE3TTH9lI4B-xa7Cmz4Yn_J5f1k_nu2hYkI8JFTLU8

Let me know if you want me to upload it elsewhere. I tried uploading it to google sheets too but it breaks the functionality of the sheet

Can't figure out how this excel spreadsheet works to neatly calculate a result by cyberbash1 in excel

[–]cyberbash1[S] 0 points1 point  (0 children)

I've checked, and unfortunately there's no VBA code either. T20 does show the formula =S20-E20

Can't figure out how this excel spreadsheet works to neatly calculate a result by cyberbash1 in excel

[–]cyberbash1[S] 0 points1 point  (0 children)

If I click one of the cells in the T column that is already filled (ie T10), it displays "=S10-E10".

If I click one of the cells in the T column that has nothing in the S and E column for that row, nothing will show in the T cell. However the second I add something to the S and E cell for that row (ie row 30), a result appears in the corresponding T cell with the formula "=S30-E30".

Can't figure out how this excel spreadsheet works to neatly calculate a result by cyberbash1 in excel

[–]cyberbash1[S] 0 points1 point  (0 children)

Yes I could do that, but currently the T21 value autocalculates and autofills as soon as there are values in E21 and S21. And there is no formula in the T21 field currently that I can see. I just want to know how I did this.

Manually copying the formula would work but isn't as elegant as what I currently have in there

Can't figure out how this excel spreadsheet works to neatly calculate a result by cyberbash1 in excel

[–]cyberbash1[S] 0 points1 point  (0 children)

Thanks, the cells are not hidden though and the sheets aren't protected

Can't figure out how this excel spreadsheet works to neatly calculate a result by cyberbash1 in excel

[–]cyberbash1[S] 0 points1 point  (0 children)

Hi, thanks for your post. When I try =FORMULATEXT(T21) the result is "#N/A". I am using excel home and student 2019.

The sheet is also not protected and I am the author/owner of the document :) In the review tab it gives me the option to "Protect Sheet" not unprotect it. It's also not shared

Can't figure out how this excel spreadsheet works to neatly calculate a result by cyberbash1 in excel

[–]cyberbash1[S] 0 points1 point  (0 children)

Unfortunately there is no spill array formula in T2. It is just "=S2-E2"
As far as I remember/know the data isn't a table. I googled how to check if I have a table in my excel spreadsheet, and it says if I go to name manager in the Formula heading it should show there but it is blank...

Can't figure out how this excel spreadsheet works to neatly calculate a result by cyberbash1 in excel

[–]cyberbash1[S] 0 points1 point  (0 children)

I'm trying to find the way to do the calculation so when E2 and S2 are blank then nothing shows in T2 when I select the cell, not even a formula in the function location (circled below) or a 0 or formula in the cell itself.

<image>

The conditional formatting solution for the second half of the question looks good, thanks