dcsimg

Help Using the Debt to the Penny Query

The Debt to the Penny Query has several features to make it easy for you to display and save data in different ways. The functionality provided is similar to features found in spreadsheet software.

The table displays the first 50 records starting with the most recent date and going backward.   You can use the arrows in the lower right section of the table to move to additional pages of data, 50 records at a time.

Sorting

If you move your cursor into the column label block, you'll find an arrow on the right. Click on that arrow and it will sort the records in ascending order or descending order, alternately.  If the arrow is pointing up, the sort is ascending.   If the arrow is pointing down, the sort is descending.

Filtering by Date

You can select a single date or a date range to display information for those dates. To select a single date, click on the calendar icon in the box below the column heading and double click on the date. (NOTE:  If you double click too quickly, it may not register your choice).  The calendar icon will close and then the date you chose will display in the box below the column heading.

If you want a range of dates, click on the calendar icon, single click on the first date and then with the calendar still open click on the second date. The calendar icon will close and the date range will display in the box below the column heading. Data for the selected date range will display in the table.

For larger date ranges you can zoom out to Year and Decade views by clicking the Calendar's title.

You can also select the "remove filter" button below the table to remove any filtering you have applied.

Paging

You can move between pages of the table by using the right and left arrow at the bottom of the table or by entering the page number in the "Go to page:" block. You can also change the number of rows that display per page by selecting the arrow in the box next to "Show rows:" and select 100, 250, or 500. To the right of the "Show Rows:" box you can see what rows are available in the table out of the total number of records.

Exporting Data

You can export the data from the table to these file formats:

  • CSV – Comma Separated Values
  • JSON – JavaScript Object Notation
  • TSV – Tab Separated Values
  • XML – Extensible Markup Language
  • PDF – Adobe Acrobat Portable Document Format
  • Excel – Spreadsheet
  • HTML – hypertext markup language (web page)

Select the button above the table that has the appropriate acronym for the format you want to use. The File Download box will appear - chose open or save. If you choose save, you can use the standard "Save As" dialog box to save your file.

Note:   When selecting either Excel or CSV, truncation occurs due to the extended number of digits - Excel only handles up to 15 digits.