30 articles in this selection
| 2010/02/19 Idema Design: Excel VBA
In dit onderdeel van de website vind je een aantal lessen (misschien is 'tips' een beter woord) met betrekking tot programmeren in Excel VBA. Met name de lessen 1 tot en met 4 zijn geschikt voor de echte beginner. Deze lessen kunnen ook het best in die volgorde worden bekeken. Met opzet heb ik geen kant en klaar bestandjes beschikbaar gesteld. Juist door een aantal keren rechtstreeks en zelf in de Visual Basic Editor te werken ontdek je een aantal handigheidjes van Excel zelf....
| |
|
|
| 2010/02/09 Game Development in a Post-Agile World
The hype and dogma of Agile evangelists has left in its wake a trail of broken projects, ruined businesses and misguided neophytes bleating the tired doctrines of their long departed prophets. The games industry was no exception, with many swept up in the phantasmagoria from which we are only now beginning to witness the debris....
| |
|
|
| 2009/12/22 Proto Software
Proto is a desktop application that makes a perfect compliment to Excel, Access, and VBA for people who build tools to improve repetitive data management, analysis, and reporting tasks. Proto replaces manual, ad-hoc, and time-consuming workflows with dynamic, user-friendly dashboards. Proto dashboards save time, improve results, and reduce operational risks....
| |
|
|
| 2009/10/15 Excel as a database
As a developer, you've probably, at some unfortunate point in your life (possibly several points, actually), been handed an Excel file that has been crammed full of "data" by someone in marketing and told to "do something with it." Columns probably didn't line up, and a thousand different fonts were used. Every feature of Excel was probably abused and abused again in order to avoid having to use an actual database application for storage of the data. Of course, it's up to you to make sense of the layout, and they could just give a bleepity-bleep about what a pain in the ass it is to suck weird data out of Excel and "do something with it" when little or (more often) no thought has been given to possibly making the data consistent or, dare I say, orderly. To this end, I've put together another art project. This time, what you will see unfold before your peepers is a process of discovery - My thoughts on how these files are created....
| |
|
|
| 2009/10/13 Automating business processes in SharePoint
Right, here is the first part of a three-part series on automating business processes in SharePoint. We will explore three different methods of doing Business Process Management, or BPM, using SharePoint and available tools. The scenario is a simple helpdesk application in which users should be able to send emails and have an issue be raised and sent to an appropriate agent for resolution. We will use an email enabled list to receive emails and then use automated processes to route that email into the issue tracking system. The system will make sure that the issue is tracked and escalated as appropriate....
| |
|
|
| 2009/08/26 Making Sense of Revision-control Systems
Choosing a revision-control system is a question with a surprisingly small number of absolute answers. The fundamental issues to consider are what kind of data your team works with, and how you want your team members to interact. If you have masses of frequently edited binary data, a distributed revision-control system may simply not suit your needs. If agility, innovation, and remote work are important to you, the distributed systems are far more likely to suit your needs; a centralized system may slow your team down in comparison....
| |
|
|
| 2009/08/21 Excel Games
A big collection of games "ported" to Excel, including Bejeweled, Battleship, Boulderdash, Frogger, Minesweeper, Pong, Sokoban and Tetris.
| |
|
|
| 2009/08/18 Orange - Data Mining Fruitful & Fun
Orange is a component-based framework for machine learning and data mining, intended for both experienced users and researchers in machine learning who want to develop and test their own algorithms while reusing as much of the code as possible, and for those just entering who can enjoy in powerful while easy-to-use visual programming environment....
| |
|
|
| 2009/07/31 Axiis - An Introduction and Tutorial
This purpose of this article is to introduce developers and data visualization specialists to Axiis, which is an open source data visualization project based on Adobe Flex and Actionscript 3. While you do not have to be an expert in Flex Builder or ActionScript 3, having experience in both will make understanding this tutorial easier. Throughout the article I will assume you are comfortable with the fundamentals of building an application with Flex, and understand some of the primary language constructs embodied within ActionScript 3 and the Flex SDK, primarily MXML and Binding....
| |
|
|
| 2009/07/29 Maker's Schedule, Manager's Schedule
One reason programmers dislike meetings so much is that they're on a different type of schedule from other people. Meetings cost them more. There are two types of schedule, which I'll call the manager's schedule and the maker's schedule. The manager's schedule is for bosses. It's embodied in the traditional appointment book, with each day cut into one hour intervals. You can block off several hours for a single task if you need to, but by default you change what you're doing every hour. Most powerful people are on the manager's schedule. It's the schedule of command. But there's another way of using time that's common among people who make things, like programmers and writers. They generally prefer to use time in units of half a day at least. You can't write or program well in units of an hour. That's barely enough time to get started....
| |
|
|
| 2009/07/18 Regular-Expressions.info
A regular expression (regex or regexp for short) is a special text string for describing a search pattern. You can think of regular expressions as wildcards on steroids. You are probably familiar with wildcard notations such as *.txt to find all text files in a file manager. The regex equivalent is .*\.txt$. But you can do much more with regular expressions....
| |
|
|
| 2009/07/16 Writing Your First VBA Function in Excel
Excel provides the user with a large collection of ready-made functions, more than enough to satisfy the average user. Many more can be added by installing the various add-ins that are available. Most calculations can be achieved with what is provided, but it isn't long before you find yourself wishing that there was a function that did a particular job, and you can't find anything suitable in the list. You need a UDF....
| |
|
|
| 2009/07/16 Software Release Practice HOWTO
This HOWTO describes good release practices for Linux and other open-source projects. By following these practices, you will make it as easy as possible for users to build your code and use it, and for other developers to understand your code and cooperate with you to improve it. This document is a must-read for novice developers. Experienced developers should review it when they are about to release a new project. It will be revised periodically to reflect the evolution of good-practice standards....
| |
|
|
|
|
| 2009/07/13 SUMMON: visualization prototyping and scripting
SUMMON is a python extension module that provides rapid prototyping of 2D visualizations. By heavily relying on the python scripting language, SUMMON allows the user to rapidly prototype a custom visualization for their data, without the overhead of designing a graphical user interface or recompiling native code. By simplifying the task of designing a visualization, users can spend more time on understanding their data....
| |
|
|
| 2009/07/12 Cloud Pricing and Application Architecture
I have been giving a lot of thought lately to cloud pricing. As an adviser to companies from both sides of the issue -- cloud (IaaS and PaaS) providers and cloud users (and potential users) -- I've had an interesting perspective on the issue, which I will discuss in this and several future posts....
| |
|
|
| 2009/07/10 Excel VBA Performance Coding Best Practices
In this post I'm going to share with you the most important performance tips I know about. There are tons of sites, pages, and people who are experts as well on this subject, have performed their own tests, and shared their results and ideas. If you think I missed an important concept for how to optimize Excel VBA performance, or if you've got a valuable comment or link to share, please feel free to post here so everyone can benefit. Thanks!...
| |
|
|
| 2009/07/10 The Spreadsheet Page
Excellent list of Excel tips on formatting, formulas, charts and graphics, printing, VBA, command bars and menus, userforms and VBA functions.
| |
|
|
| 2009/07/08 A Pop-up Calendar for Excel
This tutorial shows you how to create a pop-up calendar using the Microsoft ActiveX Calendar Control that is installed with Excel. The user will be able to call up the calendar with a keyboard shortcut, from a toolbar button or menu, or from the right-click context menu. When the user selects a date it is automatically entered into the active cell on the worksheet....
| |
|
|
| 2009/07/03 Processing 1.0
Processing is an open source programming language and environment for people who want to program images, animation, and interactions. It is used by students, artists, designers, researchers, and hobbyists for learning, prototyping, and production. It is created to teach fundamentals of computer programming within a visual context and to serve as a software sketchbook and professional production tool. Processing is an alternative to proprietary software tools in the same domain....
| |
|
|
| 2009/07/03 VBA Icon Reference
If you want to use one of the built-in icons for your custom Outlook menu item or toolbar button, you'll need to know its FaceID. Here are all the FaceID's for the builtin Outlook 2000 icons. These ID's appear to be the same across different language versions of Outlook. Select the thumbnails to see larger tables....
| |
|
|
| 2009/06/30 Manning: Collective Intelligence in Action
Collective Intelligence in Action is a hands-on guidebook for implementing collective-intelligence concepts using Java. It is the first Java-based book to emphasize the underlying algorithms and technical implementation of vital data gathering and mining techniques like analyzing trends, discovering relationships, and making predictions. It provides a pragmatic approach to personalization by combining content-based analysis with collaborative approaches....
| |
|
|
| 2009/06/30 Apache Lucene
Apache Lucene is a high-performance, full-featured text search engine library written entirely in Java. It is a technology suitable for nearly any application that requires full-text search, especially cross-platform.
| |
|
|
| 2009/06/25 Protovis
Protovis is a visualization toolkit for JavaScript using SVG. It takes a graphical approach to data visualization, composing custom views of data with simple graphical primitives like bars and dots.
| |
|
|
| 2009/06/25 Simpler Data Visualization
Researchers at Stanford are offering a suite of tools called Protovis that streamline the process of building data visualizations. The tools still require knowledge of programming but are designed to be easier to implement for someone without programming experience, says creator Jeff Heer, a professor of computer science at Stanford....
| |
|
|
| 2009/06/17 Decision Tables
This activity is designed to help you understand the methodology for building a Decision Table. Decision tables are used to lay out in tabular form all possible situations which a business decision may encounter and to specify which action to take in each of these situations. You will use them in your projects to clarify complex decision making situations and should find them useful in your work as a computer professional....
| |
|
|
| 2009/06/17 Decision tables
A decision table is a table composed of rows and columns, separated into four separate quadrants.
| |
|
|
| 2009/06/17 Wikipedia on Decision tables
Decision tables are a precise yet compact way to model complicated logic. Decision tables, like if-then-else and switch-case statements, associate conditions with actions to perform. But, unlike the control structures found in traditional programming languages, decision tables can associate many independent conditions with several actions in an elegant way....
| |
|
|
|
|
| 2009/06/09 Inverted index
In information technology, an inverted index (also referred to as postings file or inverted file) is an index data structure storing a mapping from content, such as words or numbers, to its locations in a database file, or in a document or a set of documents, in this case allowing full text search. The inverted file may be the database file itself, rather than its index. It is the most popular data structure used in document retrieval systems.[1] Several significant general-purpose mainframe-based database management systems have used inverted list architectures, including ADABAS, DATACOM/DB, and Model 204. There are two main variants of inverted indexes: A record level inverted index (or inverted file index or just inverted file) contains a list of references to documents for each word. A word level inverted index (or full inverted index or inverted list) additionally contains the positions of each word within a document.[2] The latter form offers more functionality (like phrase sear...
| |
|
|
Tag Cloud | List
Clear selection
Help
