cross-posted from: https://lemmy.blahaj.zone/post/43249310

Hey there,

I have a sample of data below in which there are multiple rows with different hours that all pertain to the same project id and task name.

I am trying to find a way to consolidate the duplicates into a single total for each.

For example, Altos Ohio I want to keep a single line for the Project ID, Task name (May) but have a single hour value of 1.5, rather than the 3 separate entries rows of 0.7, 0.5 and 0.3 as seen in the image.

The reason is due to my import tool, it will import them as 3 separate entries, but the goal end result would be to have the total hours as a single entry so I need to clean up this data before import.

Hey folks,

Hopefully I explain this well. I am playing around with xlookup and data validation lists and can't seem to accomplish what i am trying to do.

Simply put, i want a tailore list of options in a dropdown of a cell to be relative based on the value of another cell, however the cell it is referencing is the return from another xlookup.

Here is the contents I want to appear in the dropdown of Column B. You can see there are 4 different column list (on a different tab of the original sheet), and I want the cell to only have one of these columns available based on the criteria that appears in another column in this same sheet.

This is column B where i want the list to appear with its dynamic options, so we can see Audit Detailed options now but if AUP - Simple were to appear in column K (image below) i would want only Perform AUP Procedures to appear as an option in this drop down.

This is the column I want to reference to change the dependent list option in column B, however i think i am having issues because as you can see the data return in the cell is correct but up in the function bar is the formula because this column is the return of another Xlookup.

Hey folks,

I can't seem to understand this issue or how to fix it, hoping for some guidance.

I have a set of data, in column B, i want all the numbers to have 3 decimals places. Some naturally do in the data set but others don't so I formatted the column to be Numbers and add 3 decimal places.

This is fine at a glance but my issue is that is not the true value in the cell. In the specific cell it shows how I want it to show, but when i look at the formula bar, it is showing the value without the 3 decimal places and when i go to import, the system is also showing the value without the 3 decimal places.

I have tried copy and pasting the column, pasting values only or changing the format to text instead of numbers and nothing is working.

I am pulling my hair out trying to figure out where i am going wrong because it seems like such a simple task.

Does the description I wrote below describe a correct use of Excel's binomial functions?

cross-posted from: https://lemmy.crimedad.work/post/149658

Not completely sure I'm doing it right, but a 2:1 safe state for swing state swap seems like a bad deal. Here's my reasoning:

• In New Jersey, as an example of a safe state for Harris, Fivethirtyeight has Harris winning in 993 out of 1000 simulated elections. Assuming the same turnout as 2020 of 4,549,457 votes, there's a 0.500546 chance, on average, that a NJ voter will vote for Harris. I figured that out using the BINOM.DIST.RANGE function and the Goal Seek tool in Excel.
• In Michigan, with a turnout of 5,539,302 voters in 2020, Harris wins in only 605 out of 1000 simulations. Using the same tools above, if you randomly picked any Michigan voter, there's a 0.500059 chance that he or she is voting for Harris.
• Using the BINOMDIST function with the assumed turnouts and the chances we determined that voters in each of the above states would go for Harris, there's a 3.25986e-4 chance that Michigan is decided by a single vote. Likewise, there's a 2.47681e-5 chance for the same in NJ. Based on the probability that it could shift electoral college votes, a Michigan ballot is distinctly more powerful than an NJ one.
• If you could could reliably convince one more person to vote like you in NJ, your chances of affecting the NJ outcome only increase to 2.48222e-5.
• For an NJ voter to match their chances of affecting the Michigan outcome, they would have to command about 1,925 votes besides their own. In other words, there's an almost equal chance of a single vote Harris victory in MI as a 1,926 vote victory in NJ.
• Therefore, if a Michigan voter values their power, they should not trade their vote for anything less than 1,926 New Jersey votes. The rate should actually be greater to account for welching and Michigan having one more electoral vote than NJ.

Am I missing something?

cross-posted from: https://lemmy.ml/post/22156613

cross-posted from: https://lemmy.ml/post/22156612

Matt Sledge
November 4 2024, 1:56 p.m.#

General availability to all customers to begin October, 2024

I made this spreadsheet to calculate minecraft item prices based on the time it takes to produce them but im having trouble to select the proportion of each item to divide the time (and value) between them, i need to be sure that each item is at least the average price for that item in the market. if they cant it means i dont produce with an average technique.

cross-posted from: https://sopuli.xyz/post/13827941

IMHO same as previous month. Not much. Some usual improvements to web version, some new copilot AI.

For the latter in some way it's cool for non advanced users but in others what would be their ability to check for complex formulas if there is no shortcomings in what copilot proposed or what they asked.

Summary from article :

Generating multiple formula columns, creating complex formula columns that span across multiple tables, and new ways to engage with Copilot in Excel are now available to Excel users on web and Windows. Copying and pasting improvements and sharing links to sheet views are also available in Excel for the web, and the ink to text pen is rolling out to Insiders running Excel for Windows.

cross-posted from: https://lemmy.world/post/13779795

Microsoft is introducing Python in Excel as a Public Preview for Microsoft 365 Insiders in the Beta channel.

I’ve been making charts forever and whenever the data is negative, I move the x-axis labels to bottom-centre to get them out of the way of the bars. Suddenly, this isn’t working anymore.

I choose ‘bottom-centre’ or ‘middle’ and they just don’t move.

Any suggestions?

Attached is a Google pic of what it should be doing. Note the x-axis labels are at the bottom (A, B, C, D etc). I can’t move mine at all.

No, the options to move the labels aren’t greyed out. They’re selectable, they just do nothing.

EDIT: Fixed. It’s been moved to Labels > Labels Position. There must have been an update.

Immediately humbled by gigachad index match

Had to vent somewhere; spent a few week on and off developing a compensation system in Excel and PowerBI for a company with several divisions. Pretty simple stuff; they just wanted to benchmark and log compensations across different geographies.

In order to populate some dropdowns I used the functions SORT, UNIQUE and FILTER for the first time. Was told all clients use Excel 2019 whereas I have a office 365 subscription. Well it turns out these functions are not available in excel 2019 home and business; only in the Office 365 version. (Even though I checked the version numbers of excel and we were all using the same).

What kind of money grabbing scheme is this.... Was a simple workaround by creating the same functionality with a few lines of VBA but even so.....