Copying files from different folders to one folder easily

There may be instances where you want to copy files from different folders to another folder.  For e.g. say we want to copy 3 files from 3 different folders to another folder:

Using Windows Explorer, we would need to open each folder in turn and copy the file to our target folder.  If the files were large, we would need to wait for each copy to complete before proceeding to the next file.

In Easy Explorer, we can use the drop stacks feature to copy all 3 files in one go.

First, we need to display the tools panel by selecting the Windows > Display tools panel item from the main menu, or press CONTROL-O.

The tools panel is displayed on the bottom.  Click on the Drop stack tab to open it.

Now we can drag and drop each file we want to copy into the drop stack area.

Once we have all the files we want to copy in the drop stack area, we can open the folder we want to copy to, and simply drag and drop all the files from the drop stack to that folder.  All the files will be copied in a single process.

If you want to copy the set of files to multiple folders, hold down the CONTROL key while dragging and dropping the file(s).  This ensures that the files in the drop stack are not removed once the copy process has completed.  This makes it easy to copy the same set of files (from different folders) to multiple locations.

Note that you can drag files to the drop stack from Windows Explorer, and also copy files from the drop stack to Windows Explorer.

Extract PDF tables to Excel

So you need to extract data from tables in PDF files to Excel.  The first thing you need to try is to copy the data from the PDF file in your PDF reader and paste it into Excel.  It might just work.   Not if you’re using Acrobat Reader though – it’ll just appear as lines of text.  Try Foxit PDF Reader – if your table looks something like this:

copying and pasting should do the trick.  However, if your table has empty cells like this:

or is free form like this:

you’ll still end up with wrongly formatted text.

Your next option is to explore the online extraction services like PDFTables, which is quite good at extracting tables.  However, you may not be comfortable submitting your sensitive files to a third-party.  If so, consider using PdfToXls.

It’s a FREE Windows application that lets you extract data from PDF tables into Excel.  It runs on your machine, so your files stay on YOUR computer.  You define the table and column locations, and the application does the rest.

If your table layout is complex, PdfToXls provides you the tools to adjust the data easily prior to exporting it.

Download your FREE copy now.  Visit our web site for more information.  We also have a couple of videos showing the product in action.

Indexing DICOM images on your desktop

You have a collection of DICOM images from various sources, and you want to be able to search for images matching specific values in their tags.  And you don’t want to have to install an entire Apache/Cloudera Hadoop server.

Bottom line, you just want an easy way to search your collection of DICOM images.

If that’s the case, then give DICOM Search a try.  It is a Windows application (runs on Linux too via Wine). that extracts the value of each and every tag from your images and stores them into a relational database.  You then use regular SQL syntax to run your searches.

There is also a simplified syntax for those of us that don’t know SQL, where you can run searches like this easily:

It’s that simple.  Your results are displayed in a table e.g.

where you can then open the image using your favorite DICOM viewer

or use the internal viewer which displays your search results in the familiar patient/study/series hierarchy.

Imagine the possibilities when you can now search for any image in your collection using the values in the tags, on your desktop computer.

Learn more about the product on our website, or watch the introductory video here.

Download a 14-day trial of DICOM Search now and start searching your DICOM images efficiently and effortlessly to make new discoveries.

Creating an index of the DICOM image tags

A DICOM image can contain anywhere from a hundred to a thousand tags, sometimes even tens of thousands of tags.

It’s usually not an issue to search for an image matching a specific tag value on the equipment used to capture the images using the manufacturer’s software.  However, if you had a collection of images taken from different equipment, you then had to organize your images somehow in order to keep track of each image’s attributes.

Not any more.  DICOM Search is a Windows application that stores the values of each and every tag of a DICOM image into a database.  You can then search that database for images that match one or more tag values easily using SQL queries (or a simplified SQL syntax for beginners).

Basically, you have the power of a relational database engine to search your DICOM images based on their tag values.

Let’s take a closer look at DICOM Search.

Storing the image tag values

Your DICOM images are organized into libraries.  Each library can contain images from different sources, or you could just lump all images into a single library.

You can populate each library with images stored on your folders

or you can connect to a SQL database to retrieve the images to populate your library.

Once your images have been retrieved from your folders or from a database, each tag is then processed and stored in a database table.

Searching for images

Say you want to search for MRI images of the knee where the patient weight is 75 or more.  This is how you would enter the search criteria in DICOM Search.

And this is how DICOM Search displays the search results.

Plain and simple.  Using tags, you can use plain words to refer to a tag, instead of the usual group and element numbers.  Of course, you can use the group/element combination if you so prefer e.g. to retrieve the same results above, you would enter:

Given that you have the power of a relational database engine under the hood, you can write some pretty advanced queries to retrieve your images.

Working with the search results

Once you have the images from your search results, here’s what you can do with them in DICOM Search:

  • copy the images to another folder, making it easier to work with just those images of interest
  • create a HTML slideshow containing those images
  • export the images and all the tag values in the search results into an Excel spreadsheet
  • open the images using your preferred DICOM viewer for further analysis
  • open the images using the internal viewer for further analysis

The above just scratches the surface on what DICOM Search can do.  Learn more about the product on our website, or watch the introductory video here.

Download a 14-day trial of DICOM Search now and start searching your DICOM images efficiently and effortlessly to make new discoveries.

Calculate NPV, XNPV, IRR, MIRR, and XIRR like a boss

So you need to calculate the NPV, IRR, or any of the above financial values for one investment.  Simple, right?  In Excel, you just use the relevant function on the data e.g.

But what if you need to calculate the numbers for hundreds of investments, by different categories?  For example, say we have a worksheet containing the cash flows for over 200 companies, with varying starting and ending periods, grouped by industry, sector, and risk level.

Are you able to calculate measures like the NPV and IRR for individual investments or groups of investments in Excel fast?

What if we said you could compute and display the NPV and IRR measures like this using Easy Excel Analysis in 60 seconds?

Watch this video to see how.

It could not be simpler.  Once you’ve set up the summaries, it’s just a matter of dragging which columns you want to group and compute the measures for.

Download a 14-day trial now, and experience working with your data in ways you never thought possible and gain new insights into your data.

If you need to work with data stored in databases instead of Excel worksheets, then give SQL Data Analysis a try.  It provides the same analysis capabilities as Easy Excel Analysis.

Importing data in Easy Excel Analysis – sample walk-through

In this walk-through, we will be importing data from 13 Excel files containing financial transactions.  The end-result will allow us to compute summary values for a single grouped column e.g.

and for multiple levels of grouping e.g.

or

Prerequisites

Install Easy Excel Analysis using the installer located here.

The source Excel files

Our source files consist of 13 Excel files, each containing data for one month, except for February which consists of 2 files.

Note that the each file identifies the month the data belongs to in its naming convention e.g. OBE9940 01 2020.xlsx indicates that the data in this file is for January, and OBE9940 12 2020.xlsx is for December.

Each Excel file contains 2 worksheets.  We will be importing data from the first worksheet.

Importing the data

Open Easy Excel Analysis.  Click on the Import Excel/CSV file box.

Select the first Excel file to import.  This will be our primary source file.  Easy Excel Analysis opens the file and displays the first 50 rows.

The list of available sheets are displayed on the left, and the first sheet is selected by default.  Our source file contains some header details, and the actual data only starts from the 6th row.

Thus, we need to set the Skip first value to 5.

Our source file also contains a total at the end of our data block.

As we do not require this row, we need to set the Skip last value to 1 so that Easy Excel Analysis ignores this row.

Click Next and ensure that the column types have been identified correctly.

Click Next.  Here, we can set up derived values from the date columns in our data set.  We will skip this step.

Click Next.  Here, we can enter the other files we want to import.  Click on the Add button.

Select the files we want to import.  You can use the CTRL and SHIFT keys when clicking on the file names to select multiple files.  Click Open once you have selected the files.

The selected files are listed, and the default option is to import the data from the sheet of the same name as our primary source file.

Unfortunately, our source files do not have a consistent naming convention with regards to the sheet names.  Thus, we will need to change the import option to import only from sheet 1.

Our source files do not contain any values that identify the month each transaction.  Thus, if we import the data now, we cannot identify which month  the transaction belongs to.  As this information is important to us, we need to add an additional column to our combined data.

We can either open each worksheet and add a column containing the month value, or add a new column using Easy Excel Analysis.  To do that, click on the Add button in the additional columns section.

This brings up the Add additional column window.

We will name this column MONTH.  As we will be getting the value for this column from our file name (recall that our file names contain the numeric month value), we will specify a number type.  The month value in our files names is the 2nd value, so we select the filename 2nd value as the source for this column.

Easy Excel Analysis recognizes spaces, dashes, and underscores as separators for values, so any of these file names in our example would provide the correct month value.

  • OBE9940 01 2020.xlsx
  • OBE9940-01-2020.xlsx
  • OBE9940_01_2020.xlsx

Click Next , and Easy Excel Analysis will then start importing from our primary source file and the additional files we listed.

Analyzing the data

Once the data has been imported, you can start grouping and summarizing the values.  Let’s start by creating a group summary value for the TOTAL column.

Right click on the TOTAL column header.  Select the Add group header summary item, then the sum function.

In the Summaries listing on the right panel, you should now see that a summary has been created for the TOTAL column, using the sum function.

Now drag and drop the TYPE column header to the column grouping area.

The data rows are now grouped by TYPE, and the summary values calculated for each TYPE value.

Expanding any of the TYPE value will display the details for that value.

We can create as many grouping levels as we require simply by dragging and dropping the columns into the grouping area.  Say we want to see how much we earn from each client, then by each plan.  We just need to place the CLIENT NAME and PLAN columns into the grouping area.

We can create additional summary values using the same steps for the TOTAL column.  Say we want to display the total COMMISSION value at each grouping level.  We right click on the COMMISSION column header, select the Add group header summary item, then the sum item.

The summary is then calculated and displayed immediately for each group.

Saving the grouping layout

You can save each grouping layout by clicking on the Save current layout button.

Enter a name for the layout.  You can then later apply each saved layout by clicking on the Apply layout button and select the grouping layout you want to use.

Saving the data for future use

To save this consolidated data, click on the Save the current analysis data to a data file item, and enter a file name.

The next time you want to analyze this set of data, click on the Open data file box in Easy Excel Analysis and select the data file.

You can also save the consolidated data to an Excel worksheet.  Click on the Export to Excel item in the Export options.

Enter the file name, and the layout or data option.

If you want to export only the rows without any grouping applied, ensure that your analysis table does not contain any grouping rows before you start the export.

Customizing the appearance

The Appearance tab on the Customize panel allows you to change the appearance of the displayed data.

The Skin option allow you to quickly change the look of the data e.g.

 

Overcoming Excel (and other product) technical limitations using Easy Excel Analysis

We recently had an interesting support call from an Easy Excel Analysis trial user, who described to us various ‘interesting’ technical issues, which we were happy to solve.

Excel’s worksheets are limited to a million rows.  The user wanted to analyze data spread over 4 Excel files, totaling over 1.7 million rows.  So she used another application that was supposedly able to combine all the rows from the Excel files, and export them into a single CSV file.

Unfortunately, that application failed for unknown reasons.  So while she was interested in evaluating Easy Excel Analysis, she felt stuck because she couldn’t consolidate all the 1.7 million rows from the 4 Excel files into a single CSV file.  She was also unsure if Easy Excel Analysis could handle that many data rows.

First off, in Easy Excel Analysis, you can work with a data set containing millions or tens of millions of rows, as long as your computer system has adequate RAM and a fairly good CPU.  For e.g. to work with 1.7 million rows, you would require approximately 6 GB of RAM to work comfortably.

Secondly, Easy Excel Analysis can import data from multiple Excel files and combine them into a single data set.  The user did not need to consolidate the data herself.  She just needed to prepare the settings to import the first Excel file, then enter the names of the additional files to import from.

In this way, you can combine the data from one or more Excel files without having to rely on other applications.

Once she was able to do that, she still wanted to export the data to a CSV file.  Guess what?  She can do that in Easy Excel Analysis too.  Just select the Save the current analysis data to a data file option, and all 1.7 million rows is exported to a single CSV file.

So as it turns out, all the questions related to the technical aspects of getting data into and out of Easy Excel Analysis, which was solved without much fuss.

Download a 14-day trial and give Easy Excel Analysis a try.  You might just find new ways to work with your data you previously thought impossible.

Why do you need to define a period for the IRR, MIRR and NPV financial functions in Easy Excel Analysis and SQL Data Analysis

Easy Excel Analysis and SQL Data Analysis added support for financial functions in version 2.  One quirk you may have noticed is that for the IRR, MIRR, and NPV functions, you need to enter the column containing a period.  Excel doesn’t require this, so why is it required here?

Let’s take a step back and use a simple example in Excel to explain this requirement.  Say we have a single investment we want to calculate the NPV for.  We would list the net cash flow in chronological order and calculate the NPV accordingly.

The point to note is that the order of the net cash flow needs to be sorted by period to be accurate.  If the values were not sorted, we would not get the correct value e.g.

Now say we have to deal with multiple ‘groups’ of investments.

In the example above, we are calculating the NPV for each investment.  In Easy Excel AnalysisSQL Data Analysis, we get the same values when we group our data by the Investment column.

Now say we want to compute the NPV of each category of investment.  In Excel, we can’t just sort by the Category column to compute the NPV.

neither can we just sort by both the Category and Period columns this way:

The correct way is to sum the Net cash flow values for each period by category i.e.

To perform the same computation In Easy Excel Analysis and SQL Data Analysis, we just drag the Category column to the grouping area like this:

That is the reason why Easy Excel Analysis and SQL Data Analysis requires a period value when calculating NPV, IRR and XIRR.  It uses the values in that column to determine how to group the cash flow values when grouping rows together.

To see the NPV value by individual investments,  we just drag the Investment column to the grouping area.  Now we can easily see the NPV per category and per investment.

Thus it’s just a matter of dragging and dropping which columns you want to group by, and Easy Excel AnalysisSQL Data Analysis will calculate the NPV for you at each grouping level.  It could not be easier.

Download a 14-day trial of Easy Excel Analysis or SQL Data Analysis, and start analyzing data in ways you never could in Excel, or would never do because it was too time consuming.

Financial and statistical functions in Easy Excel Analysis and SQL Data Analysis

In Easy Excel Analysis and SQL Data Analysis 2, we added statistical and financial functions to the analysis tables.

To use these functions, right click on the column header you want to compute to bring up the context menu.

Select the advanced item.  This then brings up the Advanced Summary Item window where you can define the data source for the various parameters required for the function you select.

See also:

 

Search text in multiple PDF files fast

So you want to search for text in multiple PDF files?  You can do that in Adobe Acrobat, and Google will turn up a few guides on doing that.

That’s all good and fine, but what if you need the search results fast and you need to search hundreds or thousands of PDF files?  Then you should consider Easy PDF Search.

Speed

Easy PDF Search is fast.  Watch this video comparing Easy PDF Search with Adobe Acrobat.  In short, to search for a word the second in 46 files totaling 1 GB in size, Easy PDF Search took 3 seconds while Adobe Acrobat took 3 minutes 13 seconds.

We have a user who regularly searches his collection of over 12000 PDF files using Easy PDF Search, and he gets his search results in less than 20 seconds.

Search multiple words simultaneously

Search for multiple words simultaneously.  Why waste time searching the same files for different words?  Easy PDF Search lets you search for as many words or phrases as you require.

Quickly see where your words were found

Easy PDF Search doesn’t just tell you which files your words were found in, it tells you exactly which page you can find the words in, and the frequency of the words on each page and the entire file.

In the integrated PDF viewer, all your words are highlighted on each page.

View results from past searches

Easy PDF Search maintains a search history of the words you searched for and also of the search results.

This means you can easily view the search results from past searches without having to reperform the search.

By now, you can see that Easy PDF Search is designed to save you time and help you search for text in multiple PDF files fast and easily.

In addition to the above, there is a lot more you can do with Easy PDF Search like:

  • merge all the pages from the search results into a single PDF file
  • copy all the files in the search results
  • extract text from the pages where the words were found in
  • perform proximity searches e.g. NEAR (authorities “homeland security”, 20)
  • perform exclusion searches e.g. monitoring NOT daily
  • search PDF annotations and file attributes

Download a 14-day trial of Easy PDF Search and start using your PDF collection to their full potential, or visit our web site for more details.