Changing, in MS Excel, cell colors based on its value

In order to produce an easy-to-read table in MS Excel, I wanted to assign a color to each cell according to its contents. To that end I just need to apply conditional formatting to that cells. In MS Excel this can be done through menu Format>Conditional Format and by providing the conditions and corresponding formats.

New QiQA

The new user interface (UI) of the Quick Quotation Assistant (QiQA) prototype is finished. This should allow queries using multiple views of the mould. Now, we must focus on implementing the techniques that will support the combined queries (several views plus textual). Indeed, actually only one of these is used at each time.

Screenshot of the QiQA prototype after a query

QiQA File Normalizer

Our partners from the mould industry provided a new collection for our database with eighty parts. However, the files they sent do not comply with the agreed filename formats, namely the files containing the JPEG 3D previews, VRML 3D models and mould quotations.

To solve this problem I created a simple application that renames the files according to a pre-defined set of rules. This operation is semi-automatic way, since the new name for the file is computed automatically from its context but the user must confirm the renaming for every file.

QiQA File Normalizer screenshot

New UI for QiQA

According to feedback we had from final users at CENTIMFE, we must redesign the user interface of our Quick Quotation Assistant (QiQA) prototype. Based on this we sketched the new user interface for QiQA, pictured bellow, and will now change our prototype accordingly.

Sketch of the new user interface for QiQA.

Panel about the history of Portuguese CG

As part of the 15th Portuguese computer graphics meeting (15EPCG) I co-organized a session about the history of computer graphics in Portugal. For this panel were invited some senior researchers that started up this area twenty years ago, most of them in the beginning of their careers. A few images were digitized to be presented in this session and are now available at the address http://immi.inesc-id.pt/~afj/15epcg/.