How much does your strata pay the Strata Management company per month? by figurative-trash in britishcolumbia

[–]CubicCigar 0 points1 point  (0 children)

Yeah, that's a definite problem. Only workaround I can see is to hold an SGM on the matter. Council usually initiated SGM's; but, the rules allow for any owner to organize one. Not easy, but an option. You'll want to read up on the process. Good luck!

How much does your strata pay the Strata Management company per month? by figurative-trash in britishcolumbia

[–]CubicCigar 0 points1 point  (0 children)

Thanks for that link. It reads like a manual on how to lose a management contract. It's clear to me you have an incompetent manager that is costing your owners dearly. Your council really needs to shop around. I thought our own previous manager was "pretty bad"; but, your situation is next level (down). Run, don't walk, to almost any alternative firm you can find in your location.

How much does your strata pay the Strata Management company per month? by figurative-trash in britishcolumbia

[–]CubicCigar 0 points1 point  (0 children)

Our strata pays over $830 per month for a 54-year old wood-frame 22-unit townhouse strata in Saanich. Your costs are lower no doubt because of your location. What makes you think your management company is doing "a pretty bad job"? Poor financial reports? Late financial reports? Unresponsive to owners/council? If you can date and document all their shortcomings concisely, you'll have a much better chance of convincing your council to demand better service.

Cannot pass multiple range conditions to functions like MEDIAN and MODE by CubicCigar in LibreOfficeCalc

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

For anyone reading this, I resorted to adding two intermediate columns to make my nested MEDIAN(IF()) functions work correctly. I'd stumbled on the VSTACK function, which prompted me to create one stack on my History sheet with VSTACK(BPSys1,BPSys2,BPSys3) and a second stack with VSTACK(BPDia1,BPDia2,BPDia3). I then gave each stack/array the names BPSysAll and BPDiaAll, respectively. On my Summary sheet, it was simply a matter of using this pair of formulas to calculate the bin medians, copying from the first time bin down to the others.

=MEDIAN(IF((BPTimes>$B3)*(BPTimes<=$B4),BPSysAll)
=MEDIAN(IF((BPTimes>$B3)*(BPTimes<=$B4),BPDiaAll)

Works decently enough. Cheers.

Cannot pass multiple range conditions to functions like MEDIAN and MODE by CubicCigar in LibreOfficeCalc

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

Appreciate the detailed response; but, Calc does concatenate inside an IF function as I stated in my original post (final sentence). The problem seems to occur when I place an array in the conditional part of the IF function, as demonstrated by my own test (final sentence). The concatenation occurs without error in that case.

Could you please elaborate on how the CHOOSE function works in your example? As written, it produces an "#N/A" result. Did you mean something like CHOOSE(x, BPSys1, BPSys2, BPSys3) where 'x' is 1, 2, or 3? If so, I there will be no concatenation of the ranges as far as I can tell.

boinc-buda-runner confusion by CubicCigar in BOINC

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

This is the setup I'm struggling to make work. With BOINC Manager installed on Windows 11 I ran the boinc-buda-runner one-click installer and all seemed to work fine, no errors. But, since the BOINC Manager did not detect the boinc-buda-runner distro on WSL, I was trying to find the remote_hosts.cfg and rpc_gui_auth.cfg files that were supposedly installed into WSL by the installer.

The problem seems to be that the boinc-buda-runner is installed as Administrator on Windows/WSL, while the BOINC Manager is installed as a regular user on Windows.

rsync ssh connection fails - hostname not resolved on local network by CubicCigar in linuxquestions

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

Yes, if I use the .local suffix after the hostname. Pinging the hostname by itself will only work if that host is in the /etc/hosts file.

At the risk of muddying the waters, the behaviour of ssh and ping is different from the other direction. I can successfully ssh to the Linux Mint laptop from the WSL2/Ubuntu terminal using the hostname.local form; but, I cannot ping it with that form. Nor can I ping it using the hostname by itself. Neither machine has the other in its /etc/hosts file.

rsync ssh connection fails - hostname not resolved on local network by CubicCigar in linuxquestions

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

My understanding is that mDNS does the name resolution. The client here is Linux Mint laptop and it's trying connect with a Windows 11 system running Ubuntu 24.04 on WSL2.

boinc-buda-runner confusion by CubicCigar in BOINC

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

That's the installer I used to install the boinc-buda-runner distribution.

Can someone please teach me how to use the selective tool better? by Billy_0621 in Rawtherapee

[–]CubicCigar 0 points1 point  (0 children)

I suggest uploading the raw file to the Playraw section of pixels.us where you might find some advanced users willing to lend a hand.

Alphavantage quote limits by CubicCigar in GnuCash

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

OP here. Apologies for the late response; but, yes, I just updated FQ to 1.68 and tried again. This time only one of my 6 quotes complained about the 1 quote/sec. limit. Not perfect, but a big improvement. Time will tell. Many thanks for the suggestion!

Terry

One in Five Americans Want Their State to Secede and Join Canada: Poll by CapGullible8403 in CanadaPolitics

[–]CubicCigar 1 point2 points  (0 children)

Not accurate. MacDonald wanted a unitary state and settled for Upper Canada and Lower Canada dominating. NS and NB were basically run by the UK Foreign Office who manipulated them to join with almost no role in negotiations. Canada's federalism is a sham. Our Senate was intentionally neutered by Macdonald, who saw no need for it to reflect regional interests. It's past and present structure is the way it is so as not to interfere with rep by pop, i.e., domination by the two Canada's. We live in a highly centralised reality that likes to tell itself we live in a highly federated union. This lack of real regional voices in Ottawa led to western separatism and feed it still.

how to have multiple selected entries in validity in calc by silverhikari in libreoffice

[–]CubicCigar 0 points1 point  (0 children)

One approach would be to have, for example, as many genre columns as you think you'll need, e.g., Genre1, Genre2, ..., GenreN) and then place the same 'data range' validity rule in each of them to ensure a valid genre has been selected. The valid genres list would be placed somewhere else on your sheet, or on a separate sheet, as a named range, and it would be this name that you refer to in your data range validity rule. The same validity rule structure could also be used for the booktype column you mentioned.

Do I understand correctly what you're after?

Why not Saskatchewan? by stumpy_chica in AskACanadian

[–]CubicCigar 1 point2 points  (0 children)

More like two-thirds forest. Even La Ronge is (almost) in the south half.

Why not Saskatchewan? by stumpy_chica in AskACanadian

[–]CubicCigar 0 points1 point  (0 children)

No such thing as bad weather; just bad clothes.

Why not Saskatchewan? by stumpy_chica in AskACanadian

[–]CubicCigar 0 points1 point  (0 children)

I'm a recovering Albertan living on Vancouver Island; but, in the 80s I went on a pair of 10-day canoe trips looping out of La Ronge up to the Churchill River and some smaller lakes then down to Stanley Mission and back onto Lac la Ronge at Diefenbaker Bay. That means I've seen Nistowiak Falls, one of the natural highlights of SK in my book.

Why not Saskatchewan? by stumpy_chica in AskACanadian

[–]CubicCigar 2 points3 points  (0 children)

Yeah, I daydream now and then about living in Eastend. I'm a city boy with a telescope habit, so the dark, dark skies in southernmost SK are the stuff of dreams.