zone

Hi Experts Looking for suggestion on Data model(PowerPivot) with Fact and dimesion for below Fact table on which i need to measure KPI for "ZONE" with filter option on Area and Region [ fact Table ( below is example of 60000 R and 90 C) ] I have create 3 dimension tables 1. Area ( Primary...

I am trying to create a rota in excel to balance staffing. Trying to create a spreadsheet where each member of staff has a duty rosta with all people in the list. Any Ideas on where I would start? Thanks in advance. <tbody> Zone 1 - (1 Staff) Zone 2 - (2 Staff) Zone 3 - (2 Staff) Zone 4 -...

I have a list of coordinates (columns B and C) of agencies (rows) that are associated to a zone (column A). I attached a screenshot of a reduced list as example. In cell D2 of the example I put a formula that calculates the distance between coordinates in row 2 and row 3...

Hi I'd like to create a sum if which is based on two conditions: i) if the "zone" in column A is "zone 2" and ii) if the word "up" is in column F I've used the formula below, but Excel doesn't like it! I'm using the sumif formula in a Summary tab and looking at data in the "PData" tab...

I have a table that contains Limits($), Zones and the resulting charge amount. <tbody> A B C D E 1 Limit $10000 $15000 $20000 $25000 2 Zone 1 $10 $20 $30 n/a 3 Zone 2 $10 n/a n/a n/a </tbody> I have the above table. I want to pass in a zone number and a limit amount. If the...

So I'm trying to do this formula for ARMY promotion times. I need a couple of thinks to happen for this. So I need some date for Secondary, Primary, and MIL. Secondary zone 17 months TIS, 5 months TIG Primary zone 35 months TIS, 11 months TIG Mandatory list integration: 47 months TIS , 23...

I'm trying to do a If formula for ARMY Promotions. <tbody> NAME RANK BASD TIS DOR TIG ZONE 7-Oct-17 FOX SPC 2-Feb-14 44 1-Jul-16 15 FALSE </tbody><colgroup><col span="3"><col><col span="2"><col><col></colgroup> This is what I'm starting with I need the zone Colum to give me Primary or...

I have the following information: <colgroup><col><col><col><col></colgroup><tbody> Depart Time Time Zone My Time My Time Zone 7:00 AM ET FALSE CT 8:00 AM ET MT 9:15 AM ET PT </tbody> How do I get Excel to tell what time it is in my time zone? I will need this to work east to west and...

Hi All, I'm trying to do some conditional formatting that appears to be more complex than what excel wants to do: I have a set of about 10 metrics. For each metric I want to do the following: A) If the metric went up or down from the prior period, I want to see an arrow going up or down (or...

Hi , I am in need to have an excel sheet with 3 digit OriginZIPcodes( from) and 3 digit DestinationZIPCodeses(To) on Rows and columns which will give me which zone it will fall under . I can get it from UPS site . But it means each time i input the Zipcode one by one . Any help is greatly...