matrix

Hi, I need to create a score matrix to help grade people by score. So for example we have a number of disciplines which I will call machines. We also categorise these machines by difficulty to learn. The idea being, the more points you score, the more pay you will earn. How can this be recreated...

Hi I am having trouble solving this problem. I have a matrix of an amortization schedule and need to sum the scheduled payments per period. Disbursements 1 2 3 4 5 6 1/31/2023 33,570,352 (4,997,900) (5,222,805) (5,457,832) (5,703,434) (5,960,089) (6,228,293) 2/28/2023 36,321,284...

Hi, I have this matrix: A B C 5 5 6 1 3 5 4 2 6 1 5 6 and I would like to count the number of "1", "2", ecc for each column: A B C 1 2 0 0 1+2 2 1 0 4 1 0 0 6 0 0 3 So a kind of countifs where you can set "A" and "1" as parameters. Any suggestion? :)...

Hi, I have two separate questions. 1. How would I go about having my matrix quadrants auto-populate once the quadrant is identified on the associated table? I have written several formulas, but keep receiving duplicate "Goals" appear. I have added a second matrix to my workbook to...

Hi, This is going to be a bit vague, I had a matrix containing Month and date from 'calendar table' and when I dropped the total sales measure into value it was flited down to one row showing the grand total. I tried to replicate the situation but haven't been able to do so. I'd copied the...

Hello everyone, I am trying to write a macro to distribute elements into matrices of defined (by user) number of rows and columns. Consider a raw data like this: And I want to distribute in Matrices of, for example, 12 rows x 8 columns but each Element group must start at the beginning of a...

Hi guys, In the last few days I've been doing an internal assessment of the skills needed by certain companies that we working for, but also the skills that my employees have. With that, I started to create a kind of database in which: the first sheet has the necessary technologies to ensure in...

Hello, I have a table with A, B, C and D down one side and A, B, C and D across the top, in the middle of that table are values. I want to get excel to then be able to find the value of any cell, for example A,C or D,B and so on, and provide the value. Any help would be greatly appreciated...

Hi Everyone, I am currently making a daily store sales table and am having trouble adding 2 measures that I created (previous week's sales and % change). The issue I am having is when I drop the 2 measures into my matrix, the format changes to something completely unusable. See below. Also, I...

I have a VBA script error out with "Type mismatch" on the Application.WorksheetFunction MInverse line. How else am I suppose to calculate a matrix inverse? What is the type mismatch? Both arrays are the same size and the matrix defined is invertible. Option Explicit Option Base 1 Function...

Let's assume our example data set is as follows: Column A1:A9 10 12 14 12 10 15 20 25 20 Column B1:B9 10 10 11 11 9 9 11 11 10 I'm looking for a one cell formula/vba code that will show the maximum difference between the maximum value of a dynamically increasing range in column A1:A9 and...

Hi all I am busting my head for past few days in getting the formulas to work. I have a building condition survey spreadsheet where the physical condition of different items in different rooms get evaluated. Each item in each room receive a value from 0 to 3. 0=good and 3 = severe / critical...

I have a Matrix visual with the following: Dates (MM DD YYYY) on Columns ApplicationKey on Rows Application Status on Values The Dates (datetime value) column represents the date/datetime the application progressed from one status to another; this could be the same date but minutes or...

I have a data source with sales data by store. Columns in this data include actual sales, forecasted sales, week date, weekending (saturday), region for the store, and which warehouse the store received the sold items from. I need to create a matrix visualization in which the user can filter the...

I was given a cross-reference matrix, a section of it is copied below. The numbers in Row 2 and Column C are unique identifiers. Test IDT_001T_002T_003T_010C_001Activity TitleCold Gas Blow DownBottle Piercer CharacterizationCG Assy CharacterizationGG HydrostaticSys...

Hi, I am trying to calculate a total share in a companies for several interconnected companies. The simplified model is as follows Company/Company A B C A - 10% 10% B 10% - 10% C 15% 20% - So the company A holds directly 10% in company B which holds 20% in company A. That makes...

Hi everyone, It is my first post and first of all, thanks for all the support you have provided me in the past. I need your help in a complicated (at least for me) issue. I would like to populate the content of a matrix based on a list. I have got a list of 10 products to be develop...

Hi folks, After success on this board earlier this week, I’ve decided to put together a management information type system for my department at school. I currently teach at different sites and I’m trying to ensure an even split of equipment between sites. I’ve put a simple site, course and...

Hi there, I’m a teacher who is looking to prepare better for the academic year. I teach a range of courses which require different amounts of time to setup and I’m keen to get a better understanding of the set up times for each course I teach. I have attempted todo this is a matrix format, but...

Hi Excel 2016 (Windows) 32 bit ABCDEF 1Table 1 2Place/Week12345 3A12ZZZZ 4B143 5 6Table 2 7Place/Week12Z45 8A12ZZZZ 9A12ZZZZ 10B143 11B143 Sheet: Sheet1 As shown above, I need to create Table 2 with data from Table 1. The first column of Table 2 takes reference from the first...