User Profile
Mmrtlm
Copper Contributor
Joined 4 years ago
User Widgets
Recent Discussions
Sort Column according to another column with blank rows in between
Hey there, I‘m struggling with a table I‘d like to create, without killing myself using copy paste for hours. I‘ve got the following data: - every X minutes 11 parts have to be delivered - I‘ve got the 11 parts in one table with a column looking like: 30, 60, 90, 120, …5000+ - some of the X minutes are weird numbers like 17 I‘ve used the formatting to mark the identical numbers red, but also I‘d like to sort the columns according to the time. It could look like this: Time - Part A - Part B 5 - null - null 10 - null - null 15 - 15 - null 20 - null - 22 25 - null - null 30 - 30 - null 35 - null - null 40 - null - null 45 - 45 - 44 … Null could also just be empty and the time should be regarded as an interval. I‘d very much appreciate a suggestion or method on how to implement this. Thank you for your help. Kind regards, TimSort rows of each column according to another column
Hey there, I‘m struggling with a table I‘d like to create, without killing myself using copy paste for hours. I‘ve got the following data: - every X minutes 11 parts have to be delivered - I‘ve got the 11 parts in one table with a column looking like: 30, 60, 90, 120, …5000+ - some of the X minutes are weird numbers like 17 I‘ve used the formatting to mark the identical numbers red, but also I‘d like to sort the columns according to the time. It could look like this: Time - Part A - Part B 5 - null - null 10 - null - null 15 - 15 - null 20 - null - 22 25 - null - null 30 - 30 - null 35 - null - null 40 - null - null 45 - 45 - 44 … Null could also just be empty and the time should be regarded as an interval. I‘d very much appreciate a suggestion or method on how to implement this. Thank you for your help. Kind regards, TimTrouble with statistical functions and excel
Hey there, I'm having serious trouble with a problem and am hoping for some help. I know it's alot, I'd be greatful for even only parts of an solution. I've got an excel file with the hours through April and the number of starts and landings for each (attached below). I'm suppost to create a distribution function, which gives an appropriate probability of one of the values of the record. Then I should develop the distribution from obove by adding a normally distributed error term with a standard deviation of 12 aircrafts to be able to draw as well meaningful (!) values apart from the record. Show the airport cases of three simulated months (October, November, December) in hours in a histogram. Next:The airport knows that between 4% and 9% of all aircrafts can’t start because of an engine failure, so they have to stay in a predetermined area. Assume the share of Lufthansa of all aircrafts is beta-distributed with 𝛼=2 and 𝛽=5. Simulate the number of Lufthansa aircrafts, which can’t start for 500 hours, and visualize your results in a boxplot diagram. And last:Each airline has an own predetermined area for their aircrafts that can’t start because of an engine failure. The area for the Lufthansa is limited to three aircrafts. Report the share of hours, when this limit is no sufficient for all aircrafts, which can’t start. How many aircrafts should have space in this area, if you want to cover the demand at 95% of all hours? I know that I won't learn much by doing it this way, but I'm very desperate and need to finish this soon. I might have to present this so I will attempt to understand whatever solution you offer. Again there is no need for anyone to help me with every single thing I've asked for here, every little help and answer will be greatly appreciated.Sum up customer specific costs from another table
Hey there, I'm having trouble summing up customer specific costs from another table. I have a table with loads of columns, the revelent ones are: Order ID, Customer ID and Cost There can be multiple Order IDs per Customer ID and each Order has a Cost. I have created another table with the Customer IDs listed. Now I need an array formula that sums up the Costs of all of the Order IDs for each individual Customer ID. I know this is possible with grouping Customer ID and aggregations for the sum of the Costs column. I have to use array formulas. This is my best effort until now: {=SUM(INDEX(Tabelle1!U2:U15,MATCH(1,IF(A2=Tabelle1!F2:F15,1,0),0)))} I know there a few problems. 1. I don't know how to get the IF to return the row number for only the true values 2. I don't know if the INDEX can give back multiple values from different row numbers I would appreciate help. Regards Tim
