model

Hello I have build a model that predicts the progress of a multi-departmental project based on employees of the different departments. The model is quite complex as there are lots of interdependencies. What I want now to do is to find the optimum number of employees for each department. These...

Hi Each time I save a quite complex model as a new version, I get this error: It doesn't appear when I save the file normally (overwrite previous). it appears to relate to charts, the model has a lot of them. Some of them use 2 row column headers which has the effect of forcing the 2nd row...

Hello, I want to model the processing of some cases, so I know the process time of each case and the number of employees, so I can find the end date. However, depending on the deadline, the cases may need to be reprocessed every a fixed number of months, so that the total number of cases may...

I've been working on excel based powerpivot model for a weeks and suddenly my pc has been taken over by 3 or 4 Micrososft Mashup evaluation containers using 100% of the CPU. Excel is not doing anything as not touching model no pivot table refreshing. struggling to type this post. Never ends so...

Hi, I've been scratching my head on a problem which I can't figure out a nice solution to. I hope an expert can give me a steer on the steps I should take! I have a main parent model file which needs to import data from child models. The folder containing the input modules is on the same path...

So I have been getting my feet wet into the excel data model/power query/power pivot features, but Im quite a newb. I have a folder of like-files that I am able to combine/edit/and load into the data model. Its line count far exceeds what you could put on a single sheet (probably 2.5 million...

Hello! So I have recently discovered the power of the power query/excel data model features. My initial exposure was in my efforts to compile a bunch of like files into one long list, so that other co workers could filter through them for data as they desired. So that worked great- i figured...

Hi Guys. So, I have a sheet that has a 'Shopping list' with a load of products that need to be ordered for a specific 'Model'. Column A = item description Columns B-D (random other info) Column E = cost price per item. Columns F to K = Qty - all columns have the model names in Row3 (F3:K3), and...

Hi excel gurus, I'm using Power Pivot at the moment to load a lot of data from 6 Access databases into the Data Model, which are all linked to each other via a sequence of database relationships that I have established. (According to the definition of a Star Schema of database design, of the 6...

If I want to write in also, if f8='yes' and g8=yes how would I got about it? =IF(AND(G8="yes", AD8="DEVELOPS MODEL"),"Yes",IF(AND(G8="yes", AD8="PROVIDES DATA FOR MODEL"), "Yes",IF(AND(G8="yes",AA8="direct"),"Yes",IF(AND(G8="yes",AB8="yes"),"Yes", IF(AND(G8="yes",AC8="yes"), "Yes", "No")))))

In the past when I want to extract my data from the data model as a table, instead of a pivottable, I use a query like this "evaluate calculatetable( summarize( vehicle,vehicle[VRM],..... " To create the table I go to a pivot table, created from the model, and double click one of the...

Hi, I have taken over a cashflow model which is do with land acquistion. The model calculates in a land value before cost of finance. Then you take the cost of finance off however that is worked out on the site value which is being discounted to take account of the cost of finance. The cost...

Hi How do I get the data from an excel data model to a worksheet in excel . I have 923000 rows of data in the excel data model . Copy and pasting is making excel to crash Thanks

Dear All, say i have a model master like below <tbody> Model Code Model Name 1234 mustang 4321 fortuner </tbody> i have a table like below, where i have to capture the quantity of stock of each model name from Database <tbody> Model Name Stock Quantity Mustang =Countif(??) (status as...

New to Excel 2016. How do I create a Data Model from multiple workbooks and these have multiple worksheets and the total number of records will be over 1 million? Thanks in dvanc

I have a column where customer can input the Manufacturer and model number like <tbody> Goodman FGTRD-25418 Phillip HGYTFD25148jnh HYGFN84K YTR5245F Samsung Sonic </tbody> Now I have another two column where I have to put Manufacturer and model number like below How do i do...

If anyone could help me that would be awesome. I have a column with lots of data in the format of C11-00XX-XXX (the x's could be any number). This data correlates to a model name for example C11-0000-XXX through C11-00005-XXX is Model 1 and C11-00012-XXX is also Model 1(why they did it this way...

Hi, I need to lookup value in table and return value based on date range. my table look like that: <colgroup><col><col><col><col></colgroup><tbody> Number Date1 Date2 Model 109 02/12/2003 29/07/2005 A 109 29/07/2005 23/11/2009 B 109 23/11/2009 11/11/2010 C...

Hi Guys I need to update data from Workbook 1 to Workbook 2 just needing to have the new rows to come across and not duplicating Workbook 1 looks like this <tbody> stock no model name year model a005013 911 2003 a005012 911 2003 a005011 911 2005 a005010 911 2005 </tbody>...

Hello there! I have several forecast models linked to various source files (i.e. sales volumes) and some linked to each other (i.e. staffing model pulls actual from finance model and finance model pulls forecast from staffing model). If I open two files at the same time from Windows Explorer...