| excel support &
development • amsterdam • the netherlands • contact me |
![]() |
|---|
| Home·Downloads·Addins·About | |
|---|---|
Most of these excel addins are without password protection, so vba code can be viewed. |
|
|
TranslateIT (formerly:MultiLingual Formula Translator ) |
|
| 4-08-2005 | Download
TranslateIT here.. Translate complete formulas between 12 excel languages (English, Dutch,
German, French, Italian, Spanish, Portuguese, Danish, Swedish, Norwegian,
Finnish and Russian). Version 3. Build Aug 8: fixed bug. Function preceded by a colon not properly recognized. |
| Contributions: |
Ingrid, Maurizio, Isidoro, Misange, Popi, Norbert, Michael, Philipp, Okki, Olav, Kim, Dan, Eric. Special thanks to Ingrid for invaluable support in the alpha stages. |
|
Name Edit |
|
| 21-07-03 | Download
Name Edit here.. Allows editing, copying and renaming of defined names with automatic
update of all It's a BETA and under current development. Save your work before using it, and please report bugs to me. Check this page regularly for fresh builds. |
| Contributions: | Jan Karel Pieterse for his patience with beta testing. |
| FaceIT |
|
| 07-08-03 |
Version1 Build 031019 (Excel 97+ , but fully functional for Excel2002+) Excel XP and Excel2003 have a new way of handling HiRes toolbar pictures and transparency masks. FaceIT is a commandbar that allows you to browse all builtin FaceIDs(xl97+) and extract, copy, save and merge the Picture and Mask bitmaps (xl2002+). If you want to see the first 4400 FaceID's this brings
you to a page with |
| Comments: | John Walkenbach... "Yes, that it definely a better approach." |
|
Outlook2Excel |
|
| 04-06-2004 | With Outlook2Excel you can import Outlook
data into Excel. I'm currently redesigning it, and adding some truely spectacular features... It will not come back as a freeware app. The new release will carry a
(small) registration fee. |
|
|
|
| MultiRangePivot | |
| 17-03 (Beta6) |
Download
MultiRangePivot Addin here.. Maakt het mogelijk 'standaard' DraaiTabellen te baseren op data uit meerdere werkbladen, met normale functionaliteit. (Zonder de beperkingen van Meervoudige Samenvoegings Bereik) Enables Pivot Tables to collect Data from Multiple Sheets, but with full functionality of the 'standard' Pivot without the restrictions of using Multiple Consolidation Ranges. Beta6: Another go at the bug below. Commandbar.Protection seems to be turned ON for the PivotTable Toolbar in the Dutch Version of xl2k... Beta5: Bug with the ControlsAdd in xl2k s/b solved.. |
| MultiTrayPrint | |
| 06-02-03 | Download
MultiTray Print here.. (experimental addin for printing with on-the-fly tray switching) |
| Misc/Diversen | |
| 12-jan-06 | Download my own
Sudoku Solver here.. solves 9x9 and 16x16 sudokus. I doubt it can be done faster in VBA. <4 msecs for a 9x9 and <11msecs for a 16x16.. |
| 14-06-04 | Download Euro2004
here.. entirely in formulas: ranked/sorted/ex aequo result handling. formulas made as 'copyable' as possible |
| 01-07-04 | Download
TourToto2004 here.. |
| 27-10-04 | Download
Planning NL3a here.. |
| timeITcool (in ontwikkeling/ under development) | |
| 17-06-03 | Download
timeITcool here.. Werkt met individuele start en eindtijd, maar de grote kracht zit m in het werken met (grote) series Start en Eindtijden (of datums), waarbij het niet uitmaakt of de paren en reeksen horizontaal of verticaal zijn gegroepeerd. timeITcool(StartEnd,Periods,Interval) A userdefined function to compute which times and dates fall in certain timeperiods. Normally a challenging task used in timesheets, budget allocations, revenue allocations etc etc. It's power is in the flexibel way you can compute totals for large numbers of time or date pairs.
|
|
|
|