Convert data format between Date, Numeric, Text.
Recognize more than ten formats of date: 12/31/2006, 2006-12-31, 2006.12.31...
Recognize more than 36 formats and convert to numeric: '123.45, (1.23)E2, (1) 1/3 ...
Recognize all formats and convert to text: August 3, 2004, 08/03/2004 00:00:00, 12345678.90%, US$123,456.79, 1.23E+05 ...
Safety Merge Cells and Smart Unmerge.
View invalid data type in cells by colors, seek Invalid Data Type Quickly!
View invalid lock/unlock state in sheets and books by colors, design Protected Worksheets Efficiently!
Assign 50 people to 3 daily shifts and 75 locations each day on a simple Excel calendar scheduler. After you specify the availability of each employee for each shift each day for the month, you assign them to one or more daily shifts and locations from drop-down menus of people who are qualified and available for the shift on that day. Outputs include location and employee calendars showing personnel assignments for the month.
College students and others with limited availability are often the most difficult to schedule to work shifts. An Excel spreadsheet now allows you to specify up to 6 daily time slots that each person is available. Shift assignments are then made in 48 daily time slots from drop-down menus of available people. Once someone is assigned to a shift his name is removed from the menu for that time-slot in order to avoid overlapping assignments.
Specify your daily shifts and then assign them to up to 25 people using drop-down menus of available shifts. Shifts are removed from the menu as they are assigned and when the menu is empty you are done. Created to schedule nurses, but can be used to schedule anyone to daily shifts and it keeps track of shifts for 3 different groups. Employee vacations can be entered and you are prevented from assigning shifts to employees who are on vacation.
Excel Password Recovery is a program to recover lost or forgotten passwords to the Microsoft Excel 2003/XP/2002/2000/97/95 documents protected with password for open. The program supports the "brute-force" attack, dictionary-based attack and dramatically fastest "Booost-Up" attack. The program automatically saves password searching state and can resume an interrupted attack (after a stop, crash, etc.)
Show Classic Menus and Toolbars on the Ribbon of Microsoft Excel 2007. Just install this software and you will be able to enjoy the familiar main menu and toolbars once again in Microsoft Excel 2007, as you did in Excel 2003. Supports all languages that are supported by Microsoft Excel 2007. All new features items of Excel 2007 have also been added into the classic menus and toolbars.
Improves the speed required to accomplish routine operations with Excel worksheets. Twenty essential toolss accelerate routine worksheet operations, which usually require several steps to complete. Each tool is accessible from a drop-down menu in one click. The user interface is carefully designed to be clean and easy, even for complex tasks.
FindReplaceExcel can easily find and replace text inside Excel workbooks without Opening them automatically.PLEASE TEST FINDREPLACEEXCEL ON YOUR COMPUTER BEFORE YOU PURCHASE THE PROGRAM-
The Portfolio Performance Monitoring model enables the ongoing monitoring and periodic valuation of a portfolio of financial investments. The model allows the entering of investment transactions during a reporting period to calculate performance. Furthermore, incremental investment transactions undertaken during a period are fully accounted for in the period's performance calculations.
The Portfolio Optimization model calculates the optimal capital weightings for a basket of investments that gives the highest return for the least risk. The unique design of the model enables it to be applied to either financial instrument or business portfolios. The ability to apply optimization analysis to a portfolio of businesses represents an excellent framework for driving capital allocation, investment, and divestment decisions.
The Investment and Business Valuation template is ideal for evaluating a wide range of investment, and business case scenarios. While it is based on the traditional DCF method of valuation, its also provides ability to evaluate economic value added valuation, accounting impact, and a range of other evaluation parameters. Furthermore, the step-by-step input flow makes usage straightforward, gaining quick results to drive decision making.
Advanced Excel Repair (AER) is a powerful tool to repair corrupt Excel xls & xlw files. It can scan the corrupt files and recover your data in them as much as possible, so to minimize the loss in file corruption. AER supports to recover files in Excel v3,4,5,95,97,2000,XP,2003 formats. Moreover, it is integrated with Windows Explorer, supports drag & drop operations and command line parameters, which will make you repair files easily and quickly.
High quality pseudo-random number generator for Microsoft Excel.
* Use the high quality Mersenne Twister algorithm to replace the Excel RAND() and VBA Rnd() functions.
* Generate random numbers from 16 discrete and continuous distributions.
* Functions for use in spreadsheet formulas.
* A VBA interface to generate random numbers in your code.
* Generate large amounts of random numbers interactive interface
* Random samples and random Sort
