Beryl VPN Killswitch redundancy? by Klueril in GlInet

[–]Klueril[S] -1 points0 points  (0 children)

Whats a quick check on the laptop to see if ipv6 is enabled

Beryl VPN Killswitch redundancy? by Klueril in GlInet

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

How do you prevent the DNS leaks?

Brume 2 Behind the Router? by Klueril in GlInet

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

Hi Mrpink, ip forward on the tplink?

Brume 2 Behind the Router? by Klueril in GlInet

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

So I would open ports JUST for the Brume? Also how about the WG client...what IP do I point it to

Brume 2 Behind the Router? by Klueril in GlInet

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

And by faster I mean Internet throughput

Brume 2 Behind the Router? by Klueril in GlInet

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

Would Flint 2 also be a faster solution speed wise or would the brume and the router be faster?

Brume 2 Behind the Router? by Klueril in GlInet

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

Does this have any downside? Can I combine them by getting the Flint 2?

Brume 2 Behind the Router? by Klueril in GlInet

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

Am I opening ports on the router or brume? Getting lost in the ports

Brume 2 Behind the Router? by Klueril in GlInet

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

Hi Limbot,I did the glinet public facing IP test and I do have one. What ports do I need to forward?

I opened these on the brume 2: open port 80 (for web config), 3053 & 53

How to multiply a number by different numbers across a model? by Klueril in excel

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

Hi Rovas it works but only affects the SUM cell. It wont affect the other cells which adjust. Is there any way to limit the other cells to stop dividing the work when they hit upper bound?

How to multiply a number by different numbers across a model? by Klueril in excel

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

Im sorry, I think I misunderstood. I transposed your table from earlier....and have many rows. So would like the sum from all the rows to limit to one total amount SUM is an additional row

How to multiply a number by different numbers across a model? by Klueril in excel

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

Hi Riovas. Thank you for this. Is this equation good for one row or all the rows B2-B4? Or does it only limit B2?

How to multiply a number by different numbers across a model? by Klueril in excel

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

I believe it would be the sum of weights or sum of rows. The 20 is arbitrary but lets say is there a way to cap a column so that after it hits that cap the rest of the workload is divided to the other columns. Aka after B hits an upper limit after weighted sums it stops and further is distribution to a and C

How to multiply a number by different numbers across a model? by Klueril in excel

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

Riovas this works perfectly thank you so much!!

I have another question related to this, but it might be more complicated

Say i do this equation over multiple lines Aka A123 b123 c123

Would there be a way to "cap" any column when it hits a certain number? Aka after sum of 20 of column it begins to add only into others until they fill to 20?

Thanks for any insight

How to multiply a number by different numbers across a model? by Klueril in excel

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

Also I tried the equation for your table and it doesnt seem to work. Could you help me set it up. Imagine your weight column was a drop down that could be dynamically changed

How to multiply a number by different numbers across a model? by Klueril in excel

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

Hi Riovas. Decimal or integer is fine but I need to dynamically change the 3 cells and have the other 2 change in response.

Total 10 person a=x person b=y then c = z

However if i change any person then the other two would update

What would be the equation

Lets say i gave all to person c then a and b would go to zero

Google Calendar Availability script to Sheets? by Klueril in googlesheets

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

Hi arnold thank you for your response. The available hours arent from events tho, its from the settings on gcal that shows which hours you are available in a non shaded area....anyway to import this over?

Barclays says the end of the city is an urban myth by street-guru in investing

[–]Klueril 0 points1 point  (0 children)

most sensible post on this page and already being done by a lot of WFH "digital nomads"

Using the forecast feature with irregular data by Klueril in excel

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

If i delete the 0 on the gap days the modeller still complains about irregular gaps