First post here - thanks to all who contribute for refining our work with Excel. Here's my question:
Two days ago downloaded and started working with PowerPivot, which looks like a great tool. When tried to add calculated fields in pivots, found that it was greyed. Surprise!
Googled it and found that it was replaced by the new DAX measures and said ok. Later I found that this feature is more complicated and less productive than the old 'calculated fields'. For example, I need to divide two columns 'revenue' and 'units sold', to find the unit revenue for reach line item of the pivot. Spent quite some time over the dialogue boxes and found nothing there.
Can anybody give a hand with the complex syntax of the DAX functions for simply dividing two columns?
Thanks in advance
So my company does business with a huge bank in the US, that sort of rhymes with "hold", anyway I requested that they send statements/invoices to me via email, no problem...
Well they sent me an Excel file that was password protected and then emailed me the password they used to "protect" the excel file (If we are worried email about security then why are you sending passwords via email? ).
I opened the excel file with the given password and in Sheet1 was two embedded PDF's... Which I was not able to open for whatever reason. After a couple of back and forths I said just send my the PDF's, which they did, but this was in their postscript of the email:
Quote:
Although G______ has offered addressee(s) named above a secure alternative to sending the information contained in and accompanying this communication, addressee(s) named above have selected this insecure means at their sole risk and agree that G______ shall have no liability and shall indemnify G______ for any loss, liability, cost, expenses, demands, charges and claims of any kind resulting from the use of this insecure means. If this is incorrect, please contact your G_____s representative and ask for the secure alternative.
[bolding is mine]
Really, a secure alternative? an embedded object? If I had the ability to intercept email the ability to crack the excel password would barely be an annoyance, let alone secure the information. Did these guys hire the TSA for advice?
Using the limited tools in my corporate sandbox, would not zipping it and password protecting the zip file be more secure? or if I was a multi-billion dollar mega-corp and could spend some jack on a product, any other of a hundred other methods actually provide some semblance of security?
Another bank I deal with sends their stuff via something called "Ironport" it at least something more than the pretext of security.
Ah the Theater of Security - if it was not so maddening then it would be hilarious.
I recently used XIRR to calculate the return on an investment where I had paid monthly premiums into a policy and wanted to compare the return based on the latest policy value. The formula worked fine but I wanted to check my understanding of what it has calculated. My understanding is that it calculates the rate of return of the total premiums paid over time. It is my understanding then that it will compound the return on a monthly basis rather than annual. e.g. the result will always look lower than it would if it was calculated on an annual return.
How does this measure compare with for example XNPV?
What type sof options are available to protect data contained within a form once it is entered?
I am envisioning a checkbox that could be selected for a defined area. When the data for that designated area is entered, the checkbox would be selected, thus locking the text for that area.
I thought that it may be possible to use a Macro for this, but I am just learning so have no idea.
Thanks in advance for any suggestions.
Anyone have a method for repeated measures ANOVA using Excel 2007?
What type sof options are available to protect data contained within a form once it is entered?
I am envisioning a checkbox that could be selected for a defined area. When the data for that designated area is entered, the checkbox would be selected, thus locking the text for that area.
I thought that it may be possible to use a Macro for this, but I am just learning so have no idea.
Thanks in advance for any suggestions.
I am trying to write a Make Table query that pulls in all the fields from another table but multiplies two meaures to create a new measure.
Below is the table I am using for this query. I want to multiply " Average NB Written Premium" by "Ultimate NB Policy Count." I know I have to use the build feature in Query Design view but I havn't had any luck yet. Any ideas?
zAverage Premium 2 (YE Numbers)
Cube
Version
Source
Term
Channel
Rate_Level
LOB
Region
Measures
Period
SumOfValue
sfm_prod:Premiums
Scenario Plan
Reported
12 month
Agt Spon
Home Legacy
Homesaver
AL.Birmingham
Average NB Written Premium
2010
1410.20250404491
sfm_prod:Premiums
Scenario Plan
Reported
12 month
Agt Spon
Home Legacy
Homesaver
AL.Birmingham
Average NB Written Premium
2011
1785.55261301715
sfm_prod:Premiums
Scenario Plan
Reported
12 month
Agt Spon
Home Legacy
Homesaver
AL.Birmingham
Ultimate NB Policy Count
2010
2.14660729808804
sfm_prod:Premiums
Scenario Plan
Reported
12 month
Agt Spon
Home Legacy
Homesaver
AL.Birmingham
Ultimate NB Policy Count
2011
2.06602104153363
I am using MS Access 2003.
Thanks in advance for any help. It is greatly appreciated!
I am having difficulty setting up a Excel sheet for the following problem.
An industrial Engineer at ABC Products wants to determine whether there are more units produced on PM shift then AM Shift.
Sample of 54 Am workesr with a mean number of units produced is 345 with a standard deviation of 21.
Sample of 60 PM workser with a mean number of units produced is 351 with a standard deviation of 28 units.
Significance level is .05
Trying to figure out if the PM shift is larger.
I have a data set based on an uneven distribution of cards in a 60 card deck, each with a value ranging from 0-5.
I need to build a probability distribution of all the random samples of 10. So, how many random sets of 10. have an average value of 1 (or a total of 10) etc.
Then, I need to build a variable distribution so that it changes as I change the sample size. So, with a sample of 20 cards, what does the distribution look like?
Can this be done in excel? Should I post what I have now to work with?
