Analysis Add In
I am creating a spreadsheet that uses the analysis addin, no problem
there, the problem is that the sheet will be required to run under Excel
in English and Norwegian. Everything in excel that I have created is
translated correctly to norwegian when loading it into a norwegian
version of excel, except the functions from the add in. Example -
WEEKNUM should be UKENR in Norwegian.
Does anyone have experience in this area, is it possible to map UKENR to
WEEKNUM or something similar, is this a known issue or have I missed
You need the Analysis ToolPak Transla...Advanced Financial Analysis and quick financials
I have been using GP for a few years. I have always used FRx for Financials.
Is there a reason to learn Quick Financials and Advanced Financial Analysis?
My company has two companies in GP one representing a london division one a
SF location. And their is many multi-currency reporting necessary.
Advanced Financial Analysis (AFA) is a much simpler system that was built into the core Dynamics product. It was created before
FRx existed and is rarely used now.
I would suggest that you conti...Analysis Cubes for Excel -
Analysis Cubes for Excel requires a setting called "Trust access to Visual
Basic Project" to be marked. However, I am having trouble getting that
setting to stick. The setting seems to randomly turn itself off. I'm sure
this must be some sort of security thing but I have no idea where to look and
I have been unable to find a group policy setting for this one that would
allow me to force the correct setting.
Anyone else experiencing this? Any ideas anyone? This is driving me nuts.
I experienced the same prob's. I ended up having our ...Changing VAT Analysis to GST Analysis
I am in Australia, and we dont have the VAT....How do you change the
Scripting to say GST instead of VAT?
Call POSPartners Mr Richad Ranson ( firstname.lastname@example.org ) they have
the Australian modifications.
= = =
"Michael Thomas" <MichaelThomas@discussions.microsoft.com> wrote in message
> I am in Australia, and we dont have the VAT....How do you change the
> Scripting to say GST instead of VAT?
You can call me too. I have a major installation running i...Using Excel in Mac office 2004 with Microsoft/Mac 2008:Analysis toolpack
Although I am disappointed with Office 2008 for Mac because of the
Analysis toolpack, I figured things out quite recently that I can
install my Mac office 2004 and use the excel package that contains the
Analysis tool pack. How? ...... let me show you:
1. Insert your CD for Mac office 2004
2. When it open on your desk top, two options will be given to you to
download the software
(a) Office set-up assistant, and (b) Microsoft office 2004.
3. CHOOSE MICROSOFT OFFICE 2004 (Drag the icon onto your desk top) and
will start to run/download.
4. When done, this will appear as ...Connecting to Dara Analysis as a different user
Is it possible to connect to Data Analysis view NOT as a Windows Domain User?
I see that such a thing is possible in MS Excel 2007 in: Data->From Other
Sources-> From SQL Server, where you can choose "Use the following user Name
and Password". It would be very helpful option when user isn't currently in
the domain and wants to show some reports about his projects.
Please see http://technet.microsoft.com/en-us/library/dd180745.aspx.
Although this article discusses SQL 2005 on Windows 2003, a blog post
that discusses SQL 2008 and Windo...Montly Query
I need your help in constructing a query that reads the data field in the
table, so it only returns the dates asked.
What i need now (and i hope to start gainning enough knowhow to do it miself)
it to bild a query (12 of them) for 1 month.
January of instance, displaying all the entries betwen 01-01-2007 and 31-01-
This should be simple, but iam still learning, so sorry for being a noob ;D
Message posted via http://www.accessmonster.com
How about one query where you specify the date range?
In the criteria "cell" under your Date fields enter the foll...Analysis Toolpack Didn't Install?
I selected 'Analysis Toolpack' in the Tools/Add-ins menu
and it looks like it installed--only there is still no
'Data Analysis' option anywhere. Does anyone have an idea
what to do about that? Re-install Excel?
It should be under the Tools menu.
You might have dragged data Analysis off the Tools Menu when you
customized. So you can use:
Tool > Addins
Remove check from Analysis ToolPak
Tools > Addins
Put check against Analysis ToolPak
Alternative is that you're not waiting or expediting the display of
the full menu under Tools. Use Tools > Custom...Sales tax analysis report #3
Does anybody have a report which would enable me to filter this report
according to supplier, department, catagory etc?
HI it very easy. go to \Program Files\Microsoft Retail Management
System\Store Operations\Reports\ Directory, then open the require report
suppose I am opening the Sales - Detailed Sales Report.qrp in notepad:
then anywhere if your desire add up the column. To add such you can do the
FieldName = "Supplier.Name"
DrillDownFieldName = "Supplier.Name"
DrillDownReportName = ""
Title = "Supplier"
...Monte Carlo Simulation
Has anyone ever created a spreadsheet that used Monte Carlo Simulation?
I've been able to create one that works using the random numbe
generator in conjunction with discrete probability distributions
that's fairly easy, just assign a probability to each discrete value i
the distribution and then decide whether or not to select it using
randomly generated number.
However, I want to perform a Monte Carlo simulation that uses
-continuous- (not discrete) probability distribution, but have no ide
how I would use the random number generator to then select a value fro
the distribution b...S curves in Data Analysis views
I'm using Project Server 2007.
What would be the fields I have to include in the MDX formulas (equivalent
to calculate the 3 cumulative values:
Thanks for your help
I am tring to make a report that with take 3 fields from my table and make a
monthly report. The fields are Date, Violation and Fine. I know I have to
base the table off of a Query but I do not know how to do that. Can someone
First, change the name of the field Date. It is a reserved workd and will
definitely cause you problems in this case. Even if you enclose it in
brackets, it can become a problem since you have to use the Date() function
in conjunction with it. For example purposes, I will call it ViolationDate.
Do not put any criteria in the query. Use the Where...Analysis Service Not Working
We are having an issue getting the analysis service working in our
environment. We are running Project Server 2007 with SP2 and all
subsequent CUs. We have SQL Server 2000 installed on the same
server. When I try to create the Data Analysis view, I receive the
"Failed to connect to the Analysis Services server. Verify the server
name and try again."
I have it set to the default server. I can also successfully build
the OLAP cubes and access them through an Excel data connection. We
have gone through the entire TechNet article and followed it...Variance Analysis and Excel
Cell A1 is 10 and input
Cell B1 is 5 another input
Cell C2 is 5 a formula A1 - B1
I want to only look at variances that are greater than 25% of cell A1 and i
can get that to work but if cell A1 is less than B1 then I can't get the
negative number to work. I want to look at all variances that are greater
than 25% of Cell A1 regardless of whether it plus or minus...
Assuming your variance is in C2, try this:
"Mur" <Mur@discussions.microsoft.com> wrote in message
news:01907A36-0648-4C3D-89ED-5D66647B21C3@mic...Viewing the montly report
so i get this notification that the montly report is ready to be viewed,
which is great... i view it.. and i expect the little reminder note on the
main page to vanish.
how do i get that reminder to go away?
Wait a day or two or open the report again.
"Justin Rich" <email@example.com> wrote in message
> how do i get that reminder to go away?
Trying to perform a fourier transform to get a frequency spectrum.
Running excel 2004 Mac.
I don't know whether I am making a format mistake, or what, but it =
that my caclulations are being rejected because of my data.
Without going into the matter of windowing, I should be able to have =
and/or both begining values equal to zero. As far as I know, it is =
have the data that you want to transform that way, especialy when you=20
window data to minimize line broadening.
However, either I don't understand the formating, or, as I suspect, the=20
sof...EXCEL and OLAP (Analysis Services)
We use Excel Pivot table as the front-end tool to display
our OLAP Cube. On our Production server, we also set the
security for Excel so when users enters the Pivot table,
they would have to logon (using NT security).
It works fine if I only have one worksheet pointing to the
OLAP Cube. However, if I create another worksheet
pointing to the same Cube (same data source) or a
different Cube, the logon box pops up every 10-15 seconds,
non stop and then Excel hangs.
Is there a way around this? How can I create 2 worksheets
pointing to 2 different Cubes or the same Cube without...Any templates for cost analysis and presentation ?
Need help for cost analysis and presentation templates, can anyone help ?
"=?Utf-8?B?RGVzbW9uZA==?=" <Desmond@discussions.microsoft.com> wrote in
> Need help for cost analysis and presentation templates, can anyone help ?
Anything of use here?
It is I, DeauDeau
(Free after monsieur Leclerc in 'Allo, 'allo)
...inventory monte carlo simulating model
I am buiding a model using ramdom numbers . whenever I hit the enter
key the program generat new numbers. How can I avoid it.
it take time when I just writting text on the model to explain the
On 5=D4=C25=C8=D5, =C9=CF=CE=E77=CA=B135=B7=D6, gabi <grav...@ort.org.il> w=
> I am buiding a model using ramdom numbers . whenever I hit the enter
> key the program generat new numbers. How can I avoid it.
> it take time when I just writting text on the model to explain the
before you type the text u should forbidde the auto calc...Non-Taxable grouping in Sales Tax Analysis Report
We have been getting a Non-Taxable grouping in our Sales Tax Analysis
Report. We currently have 3 tax codes setup.
1. MN Sales Tax
I suspect that we are getting the "Non-Taxable" from our customers that have
the "Tax Exempt" checkbox selected under Customer Properties.
Can anyone confirm/deny my suspicions?
"Non-Taxable" comes from Transaction Entries (Line items on a sale) where
the tax is unassigned (TaxID = 0). This is different from your defined
"NoTax" setting. It could come from Non-Taxable customers as you suspect,
...Monte Carlo Analysis
Ok, I've searched Google and could not find information on the famous IMHO
Monte Carlo simulation thing for MS Project. Quick confirmation question: if
I simply write the 3 point estimating in MS-Excel, I would be able to derive
at a simulation of my own right (a manual one)....Thanks for your comments,
IMHO is the acronym that people use when they want to share their humble
opinion with you. IMHO stands for In My Humble Opinion. There is NO
company called IMHO! Re-read the original post when the responder told you
this. ...how can i find out what all the terms in the regression analysis .
Help is a good place to start. There is Help for the Analysis ToolPak
regression tool, and for the LINEST() function, both of which define
what is being returned. If you want more understanding about the value
of these books, try an introductory statistics book, or ask a more
my newly created application (a mixture of .net code and C++ Dlls) seems to
soak a lot of processor time - even more than i expected. Now, there might be
a bottleneck in my application but I can't figure out where.
That's why I'm looking for a tool (doesn't matter if commercial or not),
- able to do performance analysis on .net windows services
- able to both analyse C++- code and .net code
- able to give me exact information about the functions that soak the
processor time (e.g. percentual values)
Does such a tool exist? does anyone have some experience w...Analysis Cuber SQL server 2005 on GP 10.0 Spanish version
Hello, I'm trying to install Analysis Cubes Server SQL server 2005 on a
Microsoft Dynamics GP 10.0 with a Latin American version. But the problem is
that when i execute this installer, an error saying that I don't have the GP
client installed pops up. I'm starting to think that Latin American version
is not supported for installing Analysis Cubes.
Please help me, i want to know the answer for this question.
PD: Here is a picture of the mistake
Open the Windows Registry ...calculate 18 monts from a date
Hi I need to calculate from une date if 18 monts has past, if is false put a
"X" on if is true livet in blank (no 0 )
Kevin start on 06 mai 2007 still no 18 monts = "X"
Tony start on 03 fev 2007 hi pas 18 monts = " "
"Centauro" <Centauro@discussions.microsoft.com> wrote in message
> Hi I need to calculate from une date if 18 monts has past, if is false put