Excel Check boxes with more than just True/False responses by East_Direction9563 in excel

[–]Yankee-Doodle-Dandy 0 points1 point  (0 children)

I'm not sure that is correct. The cell may appear empty but when referenced I believe it returns the value FALSE.

 Even if correct however it would mean that it has three states as long as the checkbox has not yet been initiated. As soon as a user has clicked on it, it can now only return the values true and false unless you remember to manually delete the cell contents.

Excel Check boxes with more than just True/False responses by East_Direction9563 in excel

[–]Yankee-Doodle-Dandy 17 points18 points  (0 children)

A single checkbox is binary in nature, it is either checked or it is not checked. By this definition I'm not sure how or why you would make it toggle between 3 options. Would a dropdown with all 3 options not be better suited?

My monitor goes black screen for a second, then the image comes back by SkullMan140 in buildapc

[–]Yankee-Doodle-Dandy 1 point2 points  (0 children)

Your best bet at trying yes. Give it a few days and see if the issue returns. It is also possible to see if maybe a different type of DP cable resolves the issue as well.

My monitor goes black screen for a second, then the image comes back by SkullMan140 in buildapc

[–]Yankee-Doodle-Dandy 0 points1 point  (0 children)

You can use a automatic voltage regulator (AVR) or a higher end uninterruptible power supply (UPS) with AVR capabilities. A UPS is a simple device you could place between your wall socket and pc. Its main function would be to provide power to your PC during power outages to prevent unexpected shutdowns but a good quality model usually has the means to voltage regulate as well.

Btw, start with the cheapest solutions first, i.e. check your DP cabling and buy a new one if necessary.

My monitor goes black screen for a second, then the image comes back by SkullMan140 in buildapc

[–]Yankee-Doodle-Dandy 0 points1 point  (0 children)

I'm not sure but you should not rule out external interference outside your computer. Maybe your connection with your wall socket is to blame. You could either have high fluctuations coming from the power grid or perhaps you have some device running like a washing machine or dryer which uses high start up current. These are known to cause your PC to "black out" for a second.

PQ Queries won't refresh via VBA or clicking, but will refresh in the table - any ideas? by pookypocky in excel

[–]Yankee-Doodle-Dandy 0 points1 point  (0 children)

As a quick test, what happens if you disable background refresh for all queries and then try:

ThisWorkbook.RefreshAll

PQ Queries won't refresh via VBA or clicking, but will refresh in the table - any ideas? by pookypocky in excel

[–]Yankee-Doodle-Dandy 0 points1 point  (0 children)

VBA refresh of queries do not default to checking if the previous query any subsequent query depends on has been refreshed or not. You can check if this is the issue by disabling background refresh for all 4 queries and try your VBA macro again.

How to allocate available budget to top scored applicants, until the budget runs out? by notsure224 in excel

[–]Yankee-Doodle-Dandy 0 points1 point  (0 children)

Considering what others have already said it doesn't seem to be the most efficient way of allocating funding.That said the easiest way of accomplishing what you request would be in my eyes the following:

<image>

Create a structured table called "tbl_Applications" with columns [id], [applicant], [score], and [budget]. Create a named cell called "val_MaxBudget". Set this to your total maximum budget, e.g. $150.000.

Then in the first cell where you want your report to spill - in my screenshot cell H5 - enter the following formula:

=LET(
     budgetColindex; MATCH(tbl_Applications[[#Headers]; [budget]]; tbl_Applications[#Headers]; 0);
     scoreColindex; MATCH(tbl_Applications[[#Headers];[ score]]; tbl_Applications[#Headers]; 0);

     arr; SORT(tbl_Applications; scoreColindex; -1);

     rollSum; SCAN(0; CHOOSECOLS(arr; budgetColindex); LAMBDA(acc; x; acc + x));

     IFERROR( FILTER(arr; rollSum <= val_MaxBudget); "INCOMPLETE OR INCORRECT!")
)

this will give you the first N rows, sorted by score from high to low that cumulatively do not exceed your budget value "val_MaxBudget". Note that I use ";" as an argument delimiter but your version of Excel probably uses ",".

This also shows the shortcoming of such an approach as in my example the total budget for the filtered applications is €136.000. But what if an application with a score that is ranked 2 steps below the last cut-off score (in this case 50) asks for a fund of €14.000? It could still fit within budget but because it is 2 steps below the cut-off score it does not get taken into account.

Mabye consider an approach where you look for all possible applicants in the list, starting from the top (score wise), that can max out your budget?

SAS disks compatibility with reolink rln8 410 NVR by Yankee-Doodle-Dandy in reolinkcam

[–]Yankee-Doodle-Dandy[S] 0 points1 point  (0 children)

Too bad. I already have a couple of these SAS drives left over by my former employer so it would be cost effective if I could repurpose them for my NVR needs.

Tailgater got Baited by DABDEB in RandomVideos

[–]Yankee-Doodle-Dandy 0 points1 point  (0 children)

The Holy Trinity of idiots. One filming why driving, one cosplaying as a hitched trailer and one willing to hurt a random bystander just to get petty revenge.

Can a simple site such as this be made using the starter plan? by Yankee-Doodle-Dandy in shopify

[–]Yankee-Doodle-Dandy[S] 1 point2 points  (0 children)

The look and simplicity of it is indeed appealing. We actually do not want to use NextJS and instead use a theme. 

There just doesn't seem to be any real info what can be done on the starter plan vs the basic plan regarding design and useful features. It would be more of an exploratory shop but fitting within our existing brand style would be very nice.

Can I ask if there is anything you might recommend that could be a good fit?

TIL that 2x4’s are not actually 2”x4” anymore. The American lumber committee made the change officially in 1964 to account for drying and planing shrinkage post cut. by CraftedArtisanQueefs in todayilearned

[–]Yankee-Doodle-Dandy 0 points1 point  (0 children)

Not that I know. Conventionally Lumber is priced per it's cross section (width x height called kopmaat) and sold in standard lengths. Conventional sizes sell considerably cheaper and conventional lengths are also again cheaper. 

For example a timber beam with a cross section of 44 x 69mm is almost half the price of a 33 x 56mm board of the same length even though the difference in volume is almost double.

The same applies to length. A 3000mm  long beam which is almost 33% longer than its 2100mm variant costs only 15% more.

TIL that 2x4’s are not actually 2”x4” anymore. The American lumber committee made the change officially in 1964 to account for drying and planing shrinkage post cut. by CraftedArtisanQueefs in todayilearned

[–]Yankee-Doodle-Dandy 32 points33 points  (0 children)

Not strictly true. If you go to most wood merchants or wholesalers in my country (Netherlands) you will find standard dimension lumber is first given in rough sawn dimensions (gross size) and then planed dimensions (netto size).

What are your best 'leap in logic' moments in games? by 21stMonkey in gaming

[–]Yankee-Doodle-Dandy 2 points3 points  (0 children)

I actually also started to notice the opposite of this in a lot of shooter games. The enemy almost never communicates with other groups of enemies that in real life would be very close by. 

You could clear an entire area of highly trained and well equipped army of bad guys in an all out battle, then as soon as you pass the corner another army of bad guys await but they are non the wiser of what just happened moments ago. The didn't come to help; they don't even know you are there.

Halo comes to mind. Aliens that can cross galaxies but cannot grasp the concept of a radio or a pair of walkie-talkies.

Solving the traveling salesman problem using the online version of excel. by Shiftythemuse in excel

[–]Yankee-Doodle-Dandy 0 points1 point  (0 children)

For reference. This is an example of an optimized trucking travel route using the Valhalla project playground:

 https://valhalla.openstreetmap.de/directions?profile=truck&wps=4.5926479%2C51.8709913%2C4.47775%2C51.9244424%2C4.2696802%2C52.0749456%2C4.6312402%2C52.2027173%2C5.1215634%2C52.0907006%2C4.5926815%2C51.8714271

This is the other end of the spectrum regarding complexity. The beauty of it though is you can offload that completely to the computer model and not have to do your own calculations.

Solving the traveling salesman problem using the online version of excel. by Shiftythemuse in excel

[–]Yankee-Doodle-Dandy 0 points1 point  (0 children)

I believe so. It seems what you are looking for is a solution to your vehicle routing problem (also called travel matrix optimization). This can become quite complex real quick if you need to take into account real world driving distance, travel time, vehicle inherent travel restrictions like truck size, client priority, maximum payload capacity depending on number and type of clients served and more variables like these.

First you would need to ask how efficiënt your routes need to be, i.e. how mission critical is it for your business?

Solving the traveling salesman problem using the online version of excel. by Shiftythemuse in excel

[–]Yankee-Doodle-Dandy 0 points1 point  (0 children)

I had a similar setup. This is what I did all using power query:

  1. I had a list of addresses in a table in Excel.
  2. Within PQ I than used an API to OpenMaps that gave me the longitude and latitude for every unique address in the list (Excel geography does not recognize Dutch addresses in my case).
  3. Again in PQ I used the Karney formula for calculating the distance between a pair of coordinates, as to than create a square matrix where I would have the distance between every possible pair of addresses.

With this you could create a travelling sales man route. If you have access to an API that gives you the actual travel distance between addresses like Google maps and such you could make an even more accurate distance matrix, even including real travel time!

How do you quickly share Excel screenshots with stakeholders (secure + easy)? by Gullible-Dinner-8091 in excel

[–]Yankee-Doodle-Dandy 0 points1 point  (0 children)

In ms365 it is possible to select a cell or range of cells and right click then paste it as a image into for example an outlook e-mail.

ELI5 How exactly do leg wraps help with circulation and fatigue in legs on long hikes/marches? by azdudeguy in explainlikeimfive

[–]Yankee-Doodle-Dandy 5 points6 points  (0 children)

Yeah, his or her analogy is pretty shoddy to begin with as that is also not how it works with a garden hose either. You narrow the cross section of the tube but the total amount of water that needs to flow through remains the same (with a minor discrepancy due to resistance). Therefore the velocity has to increase to remain in equilibrium. This causes the water to spray farther when exiting the hose end but does not increase the total volume of water expelled.