Your Ad Here

Thursday, September 3, 2009

ConsoXL v1.2.0.0

ConsoXL v1.2.0.0
Win App | 3.7mb | RS.COM
ConsoXL is the easiest way for the consolidation of Excel sheets. If you often send out spreadsheets to affiliates, branches, departments...and later need to consolidate them all, ConsoXL will save you hours of work. It requires Microsoft Excel 2007, Excel 2003, Excel XP (2002), Excel 2000 or Excel 97

When you create an Excel file format to be fulfilled and want to consolidate all the files, you need to repeat over and over the same Excel operations, sheets and cells selection, copy etc. When a file is changed or updated the process has to start again. This is a time consuming activity and error-prone.

ConsoXL has a different approach. Instead of asking you to select each sheet and cell and apply a formula it will build the consolidation model by analyzing the content of the files. It uses by default the sum function for all numbers and keeps formulas. Therefore the only remaining thing to do is to determine how to group the sheets. Most often as they come from the same initial form they have the same name, the filename being the name of the department, branch etc. This is much faster than making manual selection and it’s safer in the sense that no cell will be left aside.




ConsoXL starts Excel, loads the files and does the full consolidation process. The outcome is one Excel workbook containing either:

-- The total for each group of sheet
-- The total and the details in the comments, so you don’t need to move from one sheet to another to see where the values are coming from.
-- The total and all the sheets from the different files. The sheets are linked to the total. This is handy for simulation.

A summary is added at the end so you always know which files where used for a specific consolidation.

Main features:

-- Excel sheets consolidation without parameters.
-- Creates a workbook with consolidated sheets and details sheets.
-- Consolidated sheets may be linked with details sheets.
-- Add Excel files by drag and drop, or use the standard file dialog.
-- Get the Total and all the details on the same sheet.
-- Keeps formulas (see the help file).
-- Add or remove files and get the new result.
-- No need to select sheet by sheet and cell by cell.
-- Free format for the sheets, no template to follow.
-- No macros
-- Automatic grouping of sheets.
-- Built-in default consolidation rules (can be overridden)
-- Consolidation report including the list of files (date etc.).
-- Automatic revision number.

Platforms:
Works on a personal computer
Windows Vista, XP (Home and Professional), Windows 2000
Microsoft Excel 2007, Excel 2003, Excel XP (2002), Excel 2000, Excel 97
Unicode (support for a broad range of national character sets)

No comments:

Post a Comment

Your Ad Here

Disclaimer

This site does not infringe any Copyrights. It only lists through Freedom of Information Act what is listed on Search Engines.All files are found using legitimate search engine techniques. This site does not and will not condone hacking into sites to create the links it list. We will and do assume that all links found on the search engines we use are obtained in a legal manner and the webmasters are aware of the links listed on the search engines. If you find a URL that belongs to you, and you did not realize that it was "open to the public", please email on to notify the blogmaster of your request to remove it. This is not an invitation for webblog haters to spam with requests to remove content they feel that is objectionable and or unacceptable. Proof of URL ownership is required. None of the files shown here are hosted by this server. I do not upload any file , links are provided by users of this site and other websites. If you do not have enough rights to download them please don't download.

User Agreement

The creator of THIS PAGE or the ISP(s) hosting any content on this site take NO responsibility for the way you use the information provided on this site. These Ebooks here are for educational purposes only and SHOULD BE VIEWED ONLY. If you download any files to view them, you are agreeing to delete them within a 24 hour period. If you are affiliated with any government, or ANTI-Piracy group or any other related group or were formally a worker of one you CANNOT enter this web site, cannot access any of its files and you cannot view any of the HTML files. All the objects on this site are PRIVATE property and are meant for previewing only. If you enter this site without following these agreements you are not agreeing to these terms and you are violating code 431.322.12 of the Internet Privacy Act signed by Bill Clinton in 1995 and that means that you CANNOT threaten our ISP(s) or any person(s) or company storing these files, cannot prosecute any person(s) affiliated with this page which includes family, friends or individuals who run or enter this web site. IF YOU DO NOT AGREE TO THESE TERMS THEN LEAVE.