Refresh the powerpivot data

Excel 2013 only.

“Refresh the powerpivot data”
$ReportWorkbook = $excel.Workbooks.Open($ReportFilePath)

$ReportWorkbook.Connections | %{
#If PowerPivot Model (Type=7)
#if($_.Type -eq “7”)
#{
” – Refreshing PowerPivot Model: ” + $_.Name
if($_ -ne $null){
$_.Refresh()
}
#}
}
$ReportWorkbook.Save()
$ReportWorkbook.Close()

No Comments

DAX: Count Distinct in Excel

Excel 2010

Count Distinct in Excel 2010, use PowerPivot

1. In the PowerPivot, right click the table name, press “Add Measure”

2. Enter the formula with “CountRows” and “Distinct”, below is an example.

=countrows(distinct(<column>))

However, it count “BLANK” value as 1. In order to prevent that, use below formula

=CALCULATE(countrows(distinct(<column>)),NOT(ISBLANK(<column>)))

 

Excel 2013

=DISTINCTCOUNT(<column>)

However, it count “BLANK” value as 1. In order to prevent that, use below formula

= CALCULATE (

DISTINCTCOUNT(<column>),

NOT(ISBLANK(<column>))

)

No Comments

Install XPEnology

Download DSM and XPEnoboot (Note the version must be matched!)

http://xpenology.me/downloads/

http://www.xpenology.nl/vmware-esxi-installatie/

http://www.xpenology.nl/installation-dsm-5-1/

No Comments

Creating a new datastore fails with the error: An error occurred during host configuration

I have ESXi 5, I was adding a 500 gigs IDE drive and I got the error.
I just did a “ls /vmfs/devices/disks/” from the shell to identify what was the vml I had to use.
To find the vml I just ran the following command “partedUtil get /vmfs/devices/disks/VMLID” and I got an error with the VMLID corresponding to the new drive.
After that, I just ran your “dd if=/dev/zero of=”/vmfs/devices/disks/VMLID” bs=512 count=34 conv=notrunc” and I was able to add the hard drive.

No Comments

Single Sign on in Firefox

 

  • In the address bar of Firefox, type about:config to display the list of current configuration options.
  • In the Filter field, type negotiate to restrict the list of options.
  • Double-click the network.negotiate-auth.trusted-uris entry to display the Enter string value dialog box.
  • Enter the name of the domain against which you want to authenticate, for example, .example.com.
  • Repeat the above procedure for the network.negotiate-auth.delegation-uris entry, using the same domain.

 

No Comments

C# OCR Library

Tessnet2

Download URL: http://www.pixel-technology.com/freeware/tessnet2/

 

1. Remember to download the 2.0 tessdata (tesseract-2.00.eng.tar.gz) instead of the one for 3.0

2. The image size has to be larger, otherwise it will always show result (Confidence: 100 ; Word : “~”)

3. Copy the “tessdata” folder to the exe folder OR to hardcode the path in the program

No Comments

Activating Windows 8.1 with Windows 8 Key

How to activate your Windows 8

No Comments

Protected: 可以點

This content is password protected. To view it please enter your password below:

No Comments

Javascript Obfuscator Home Products About

http://www.javascriptobfuscator.com/Default.aspx

No Comments

Protected: 可以繼續努力嗎?

This content is password protected. To view it please enter your password below:

No Comments