Queries in MIMICExcel are created the same way as they are created in MIMIC. Users enter criteria for a query in the Configuration window. Each query can contain more than one item or row in the Worksheet. Unlike MIMIC, MIMICExcel allows users to create more than one query, and these queries can be embedded or stored in MIMICExcel. This type of query is called an embedded query. Users can enter a name and description for each embedded query, and set the starting cell location where the query results will be posted in Excel. When posted, each query occupies a column for the date, and another for the results.
Query results appear in a chart the same way in both MIMIC and MIMICExcel; however, for tables, query results in MIMICExcel are posted to an Excel spreadsheet instead of to the Table window.
In MIMICExcel, users can save queries in different ways:
Users can save or embed a query within MIMICExcel. When saving a query in this manner, users must also save the Excel spreadsheet. The spreadsheet will be saved with an Excel .xls file extension. Users can embed multiple queries. Other users can open the Excel spreadsheet to view the query results, and then open MIMICExcel to view the details of the query or queries and manage them.
Users can save or export a query in MIMICExcel. This type of query is saved with a .llc file extenion and referred to as a MIMIC worksheet file or a LLC worksheet. Other users can open this file or query in MIMIC or in MIMICExcel.
Users cannot export multiple embedded queries as one LLC worksheet. Each embedded query in MIMICExcel must be exported as a separate and independent LLC worksheet. For example, if MIMICExcel contains three embedded queries, the user must select each query separately and save each query as its own LLC worksheet.
In MIMICExcel, users can create and embed more than one query. Embedding a query is another way to describe saving a query within MIMICExcel.
Users must embed a query before they can table the query results
to an Excel spreadsheet. To save or embed a query, users can select the
Embed Query 
button from the MIMICExcel toolbar, or select the
Table 
button and be prompted by MIMICExcel. MIMICExcel
prompts users to embed the query, if the query has not been saved and
they try to table the results. Embedded queries are saved using the
Embed Query window:
Users can enter a name and a description for the query, and
specify the starting location or cell in Excel where the query results
will post. To specify a location, users can select the Browse 
button.
| It is recommended that users select a different starting cell location for each embedded query, and ensure that subsequent embedded queries are separated by at least two columns to allow for the date and results of each query. |
More than one query can be saved or embedded in MIMICExcel, and
embedded queries are stored by MIMICExcel in the Query Manager. To open
the Query Manager, users can select the Query
Manager 
button from the MIMICExcel toolbar. The Query
Manager allows users to manage embedded queries:
| Users can only access embedded queries by using the Query Manager. Users cannot open a query from the menu bar or from any toolbar. |
In the Query Manager, users can select an embedded query and view its description and starting location. Users can also edit, copy, rename or delete a query.
| To edit the description or location of a query, users must
first open the query and then re-save the query by selecting the
Embed Query |