Why Excel and Not a Dedicated Data Visualization Tool?
The session focused on creating data visualizations using Microsoft Excel since it is relatively easy to set up, maintain over time, and does not require specialized knowledge. Typically, Excel is available in work environments without additional cost. Data visualization tools such as Tableau and Microsoft Power BI may require the purchase of licenses to use their full features. The drawback to Excel is the limitation of sharing the created dashboard to a variety of stakeholders through a browser-based interface such as those offered through the previously mentioned tools. However, Excel can be used as a platform to learn more about how to structure data and may serve as a way to build knowledge and confidence that can be applied in dedicated data visualization tools or help provide the seed data when the user is ready to take that step.
Building an Expanded Database Renewals Dashboard in Excel
I shared a practice data spreadsheet in the presentation slides to allow attendees to download and follow along with to create their own dashboard. Figure 1 provides a preview of what the expanded database renewals dashboard in Excel would look like once completed.
Master Data Table
A critical first step in creating a data dashboard is to gather the underlying data or information into a Master Table. It helps to create a template in Excel to enter the data into for easy organization. Create column headings for the following data elements in the Practice Data spreadsheet:
cell A1 = Resource Name
cell B1 = Fiscal Year
cell C1 = Renewal Month
cell D1 = Cost
cell E1 = % Change from Prior Year
cell F1 = Total Usage
cell G1 = Cost per Use
cell H1 = Primary Subject Area
cell I1 = Library of Congress (LC) Class
cell J1 = Notes
cell K1 = Fund Source
cell L1 = Usage Type
cell M1 = Controlled Full-Text
cell N1 = Searches
cell O1 = Open Access (OA) Full-Text
cell P1 = No License
Once the spreadsheet columns have been set up, the user can create a formatted table to make data entry and filtering easier. Create a Formatted Table by highlighting the column names and a few empty rows. Click on the Format as Table drop-down from the Home tab ribbon. Select the preferred style. When the Create Table pop-up opens, click on the checkbox next to My table has headers. Click OK. Keyboard shortcuts can aid users in quickly navigating around the spreadsheet and help with highlighting several columns and rows easily. Pressing the Ctrl+Shift+Right arrow keys will highlight columns with text to the right of the selected cell. Pressing the Ctrl+Shift+Down arrow keys will highlight rows with text below the selected cell. Mac users will need to press the Command key instead of Ctrl. The data-gathering process for the Master Table will take time and may include as little or as much information as needed. The practice data provided in the demonstration included data from fiscal year 2022 through fiscal year 2025 to allow participants to view trends over time. Data in the Resource Name column was repeated for each fiscal year row entered. The Total Usage column is calculated as the sum of the Controlled Full-Text (per Unique Item Requests from COUNTER 5 usage reports) and Searches cells for each row. Search data is included to account for usage of abstract- and index-focused resources. The Cost Per Use column is the output of Cost cells divided by the Total Usage cells. The Master Table is set up similarly to COUNTER 5 usage reports where the Resource Name repeats on multiple lines for each data type. Blank cells in the spreadsheet are intended for future data collection.
Creating PivotTables for Each Criteria
The next step is to create different PivotTables on separate tabs. I used these instructions for each PivotTable created in the presentation. Click on a cell within the formatted Master Table, click on the Table Design tab, and then select Summarize with PivotTable within the Tools section. A pop-up window will open. Table/Range should say Table1; ensure the New Worksheet radio button is selected. Click OK (see Figure 2). A new tab will be created.
The first PivotTable created during the session focused on costs year to year. From the PivotTable Fields selection pane, select the Resource Name, Fiscal Year, and Cost checkboxes. On the lower half of the PivotTable Fields menu, drag and drop the Resource Name up to the Filters area. Fiscal Year will stay in the Rows area, and Cost will stay in the Values area. On the PivotTable within the worksheet, select the cells under Sum of Cost column and change those to Accounting style or the $ symbol from the Home tab Number menu. Rename the tab as PivotCost (see Figure 3).
The following six PivotTables were created on their own tabs just as the first one. To create the PivotTables, return to the Master Table to set up a new PivotTable as previously instructed.
PivotControlledUsage
For the PivotTable Fields, select Resource Name, Fiscal Year, and Total Usage. Pull Resource Name to the Filters area. Fiscal Year will stay in the Rows area, and Sum of Total Usage will stay in the Values area. On the PivotTable itself, select the cells under the Sum of Total Usage and change those to the Comma style from the Home tab Number menu. Decrease decimals by two spots. Rename the tab PivotControlledUsage.
PivotCostPerUse
For the PivotTable Fields, select Resource Name, Fiscal Year, and Cost Per Use. Pull Resource Name to the Filters area. Fiscal Year will stay in the Rows area, and Cost Per Use will stay in the Values area. Click on the down arrow next to Sum of Cost Per Use and click on Value Field Settings. Change from Sum to Average in the pop-up box and select OK. On the PivotTable itself, select the cells under the Average of Cost Per Use and change those to the Accounting style or the $ symbol from the Home tab Number menu. Rename the tab PivotCostPerUse.
PivotPercentChange
For the PivotTable Fields, select Resource Name, Fiscal Year, and % Change from Prior Year. Pull Resource Name to the Filters area. Fiscal Year will stay in the Rows area, and % Change from Prior Year will stay in the Values area. Click on the down arrow next to Sum of % Change from Prior Year and click on Value Field Settings. Change from Sum to Average in the pop-up box and select OK. On the PivotTable within the worksheet, select the cells under the Average of % Change from Prior Year and change those to the Percent style from the Home tab Number menu. Increase the decimal by two spots for granularity of the percent number. Rename the tab PivotPercentChange.
PivotFundSource
For the PivotTable Fields, select Resource Name, Fiscal Year, Cost, and Fund Source. Pull Resource Name to the Filters area. Fiscal Year will stay in the Rows area, Sum of Cost will stay in the Values area, and Fund Source should be moved to the Columns area. On the PivotTable within the worksheet, select the cost data cells and change those to Accounting style (or $) from the Home tab Number menu. Remove the Grand Total column and row by navigating to the Design tab ribbon and within the Layout section click on Grand Totals and select Off for Rows and Columns. Rename the tab PivotFundSource.
PivotOAUsage
For the PivotTable Fields, select Resource Name, Fiscal Year, and OA Full-Text. Drag Resource Name to the Filters area. Fiscal Year will stay in Rows, and OA Full-Text will stay in the Values area as a Sum. On the PivotTable within the worksheet, select the cells under the Sum of OA Full-Text and change those to the Comma style from the Home tab Number menu. Decrease decimals by two spots. Rename the tab PivotOAUsage.
ControlledvsOA
For the PivotTable Fields select Fiscal Year, Controlled Full-Text, and OA Full-Text. Fiscal Year will stay in the Rows area. Controlled Full-Text and OA Full-Text will stay in the Values area as a Sum. A Values filter is automatically added to the Columns area. On the PivotTable within the worksheet, select the data cells and change those to the Comma style from the Home tab Number menu. Decrease decimals by two spots. Rename the tab ControlledvsOA.
Creating Dashboard Tab for PivotCharts
The next section in the presentation centered on creating the dashboard to house the PivotCharts for easy access to all the created visualizations in one place. To start the dashboard, create a new tab and label this Charts. Apply a background color to the sheet to help the charts stand out.
Starting with the PivotCost tab, select a cell within the PivotCost table, click on the PivotTable Analyze menu tab and select the PivotChart button from the Tools section. An Insert Chart window will pop up. Select Clustered Column and click OK. The chart will be created on the PivotCost tab; to move it to the Charts tab right-click the table window, select Move Chart from the options, and select Charts from the Object in: line. Click OK (see Figure 4). The chart for Cost will move to the Charts tab. Adjust its location on the sheet as preferred. From here, chart elements can be adjusted by clicking on the upper right side of the chart and selecting the + icon.
Using the instructions in this section, create the charts for the following PivotTables:
ControlledUsage, which will be titled as “Total Controlled Usage (Searches + Downloads)”
Cost Per Use – Controlled
Percent Change, which will be titled as “% Change of Costs Year to Year”
OA Usage
Fund Source
Controlled Downloads vs OA Downloads which should utilize a line chart format.
Creating Slicers
Creating slicers helps unify the charts and provides an easy way to dynamically adjust the chart visuals to view trends over time based on selections made. To create several slicers at once, select one of the charts. From the PivotChart Analyze menu tab, select Insert Slicer from the Filter section. Select Resource Name, Fiscal Year, Primary Subject Area, LC Class, and Fund Source from the slicer options and click OK (see Figure 5). A box for each is added to the Charts dashboard.
Move each slicer to preferred location on the dashboard. Starting with the Resource Type slicer, click on the slicer box where the text Resource Name is and a new Menu tab on the ribbon should appear called Slicer. Click Report Connections on the slicer section. A pop-up window opens with one table checkbox selected. To add the other tables to the slicer, click the rest of the checkboxes and click OK. Adjust the size of the slicer as needed. Do this same step in Report Connection for each slicer created so each slicer connects to each chart and table on the dashboard.
Making selections on any of the slicers will automatically filter to that selection. To have multiple selections within a single slicer, hold the Ctrl button (or Command for Mac users) and use the mouse to click on multiple selections. To remove slicer filters, click on the small X on the funnel icon at the top right of the slicer to cancel the filter. At this point, the dashboard is done! The dashboard can be further modified for aesthetics such as themes, color preferences, and design.
Ongoing Maintenance
When updating the Master Table with new data, it is important to refresh the data so that it shows up throughout the created PivotTables and PivotCharts. On one of the PivotTable tabs, click on a cell within the table, click on PivotTable Analyze tab and then Refresh or Refresh All from the Data section.
When a new fiscal year starts, add new rows for each resource with the fiscal year name to prepare for the incoming data for that year. If you add more charts to your dashboard, make sure to add them to each slicer by going back to Report Connections and clicking on the new table source checkbox. This needs to be done for each slicer that is created.
Use Cases for Database Renewals Dashboard
Using the Microsoft Excel dashboard to view database renewals details helped streamline and consolidate information needed when considering whether to move forward with continued subscriptions and increased the ability to communicate trends with stakeholders across the University of Texas at Arlington Libraries and beyond. Questions from the Libraries Administration prompted the need to include data for the different fund sources utilized and how OA usage was trending compared to controlled usage. The dashboard helped with answering those questions easily with charts that conveyed activity year to year. For example, stakeholders could see that OA usage increased over time, while controlled full text downloads decreased, which provided an opportunity to consider the impact of OA content’s growth and impact to subscriptions.
Additionally, the ability to use multiple filters with the created slicers helped respond to liaison questions about databases subscriptions within their subject area. Acquisitions staff can quickly create a screenshot for librarians interested in seeing the scale of resources by subject and LC Class in relation to expenditures, usage, and Cost Per Use. The dashboard has also allowed for opportunities to look at the strengths and gaps of the database collections beyond just the amount spent per year. Given the flexibility of using Microsoft Excel, more PivotTables and PivotCharts can easily be created to look at other cross sections of the data from the Master Table. Furthermore, the demonstration provided concrete tools for Excel functions that can be used with other types of library data to visualize and analyze.
APPENDIX
Journal Package A |
FY25 |
January |
$ 25,000.00 |
0.0225 |
0 |
|
Engineering |
T |
|
Local |
|
||||
Journal Package A |
FY24 |
January |
$ 24,450.47 |
-0.1863 |
17042 |
$ 1.43 |
Engineering |
T |
Local |
COUNTER 5 |
12148 |
4894 |
4632 |
no |
|
Journal Package A |
FY23 |
January |
$ 34,871.16 |
0.4024 |
22499 |
$ 1.55 |
Engineering |
T |
Local |
COUNTER 5 |
14728 |
7771 |
3830 |
yes |
|
Journal Package A |
FY22 |
January |
$ 24,864.66 |
0.219 |
17290 |
$ 1.44 |
Engineering |
T |
Local |
COUNTER 5 |
11327 |
5963 |
1906 |
yes |
|
Journal Package B |
FY25 |
January |
$ 120,872.22 |
0.04 |
Chemistry |
Q |
UTSDL |
COUNTER 5 |
|||||||
Journal Package B |
FY24 |
January |
$ 115,391.00 |
0.04 |
40365 |
$ 2.86 |
Chemistry |
Q |
UTSDL |
COUNTER 5 |
37092 |
3273 |
6397 |
yes |
|
Journal Package B |
FY23 |
January |
$ 110,953.00 |
0.0581 |
41192 |
$ 2.69 |
Chemistry |
Q |
UTSDL |
COUNTER 5 |
36930 |
4262 |
4715 |
yes |
|
Journal Package B |
FY22 |
January |
$ 104,865.42 |
0.055 |
40354 |
$ 2.60 |
Chemistry |
Q |
UTSDL |
COUNTER 5 |
34849 |
5505 |
3689 |
yes |
|
Database A |
FY25 |
January |
$ 11,804.36 |
0.035 |
Mathematics |
Q |
UTSDL |
COUNTER 5 |
|||||||
Database A |
FY24 |
January |
$ 11,405.42 |
0.03 |
1596 |
$ 7.15 |
Mathematics |
Q |
UTSDL |
COUNTER 5 |
1596 |
no |
|||
Database A |
FY23 |
January |
$ 11,073.42 |
0.0299 |
1816 |
$ 6.10 |
Mathematics |
Q |
UTSDL |
COUNTER 5 |
1816 |
no |
|||
Database A |
FY22 |
January |
$ 10,752.30 |
0 |
3526 |
$ 3.05 |
Mathematics |
Q |
UTSDL |
COUNTER 5 |
3526 |
no |
|||
Journal Package C |
FY25 |
April |
$ 26,958.00 |
0.035 |
Interdisciplinary |
A |
UTSDL |
||||||||
Journal Package C |
FY24 |
April |
$ 26,047.00 |
0.0339 |
1659 |
$ 15.70 |
Interdisciplinary |
A |
UTSDL |
COUNTER 5 |
1573 |
86 |
292 |
yes |
|
Journal Package C |
FY23 |
April |
$ 25,194.00 |
0.03 |
3774 |
$ 6.68 |
Interdisciplinary |
A |
UTSDL |
COUNTER 5 |
3607 |
167 |
261 |
no |
|
Journal Package C |
FY22 |
April |
$ 24,460.00 |
0.0203 |
2184 |
$ 11.20 |
Interdisciplinary |
A |
usage is partial year, only Jan-Aug 2022, no 2021 |
UTSDL |
COUNTER 5 |
2060 |
124 |
124 |
no |
Image Package A |
FY25 |
January |
$ 11,375.00 |
0 |
Art |
N |
UTSDL |
||||||||
Image Package A |
FY24 |
January |
$ 11,375.00 |
-0.05 |
3417 |
$ 3.33 |
Art |
N |
UTSDL |
COUNTER 5 |
2709 |
708 |
no |
||
Image Package A |
FY23 |
January |
$ 11,974.00 |
-0.05 |
1967 |
$ 6.09 |
Art |
N |
UTSDL |
COUNTER 5 |
1388 |
579 |
no |
||
Image Package A |
FY22 |
January |
$ 12,604.00 |
-0.2 |
2876 |
$ 4.38 |
Art |
N |
UTSDL |
COUNTER 5 |
1401 |
1475 |
no |
||
Reference Database A |
FY25 |
June |
$ 82.97 |
0 |
0 |
Music |
M |
Local |
|||||||
Reference Database A |
FY24 |
June |
$ 82.97 |
0 |
1419 |
$ 0.06 |
Music |
M |
Local |
COUNTER 5 |
21 |
1398 |
0 |
No |
|
Reference Database A |
FY23 |
June |
$ 82.97 |
0 |
3865 |
$ 0.02 |
Music |
M |
Local |
COUNTER 5 |
10 |
3855 |
0 |
No |
|
Reference Database A |
FY22 |
June |
$ 82.97 |
1249 |
$ 0.07 |
Music |
M |
Local |
COUNTER 5 |
13 |
1236 |
0 |
No |
||
Database B |
FY25 |
January |
$ 13,048.25 |
0.035 |
0 |
Science |
Q |
Local |
|||||||
Database B |
FY24 |
January |
$ 12,607.20 |
0.03 |
3481 |
$ 3.62 |
Science |
Q |
Local |
COUNTER 5 |
1090 |
2391 |
No |
||
Database B |
FY23 |
January |
$ 12,240.00 |
0.03 |
3807 |
$ 3.22 |
Science |
Q |
Local |
COUNTER 5 |
1236 |
2571 |
No |
||
Database B |
FY22 |
January |
$ 11,883.00 |
0.0197 |
3962 |
$ 3.00 |
Science |
Q |
Local |
COUNTER 5 |
1275 |
2687 |
No |
||
Database C |
FY25 |
January |
$ 29,224.80 |
0.03 |
0 |
Biology |
Q |
Local |
COUNTER 5 |
||||||
Database C |
FY24 |
January |
$ 28,373.18 |
0.03 |
1828 |
$ 13.46 |
Biology |
Q |
Local |
COUNTER 5 |
1319 |
509 |
280 |
No |
|
Database C |
FY23 |
January |
$ 27,545.97 |
0.03 |
928 |
$ 25.74 |
Biology |
Q |
Local |
COUNTER 5 |
800 |
128 |
142 |
no |
|
Database C |
FY22 |
January |
$ 26,744.40 |
0.03 |
818 |
$ 27.57 |
Biology |
Q |
Local |
COUNTER 5 |
757 |
61 |
152 |
No |
|
Journal Package D |
FY25 |
January |
$ 73,248.00 |
-0.0033 |
Interdisciplinary |
A |
UTSDL |
COUNTER 5 |
|||||||
Journal Package D |
FY24 |
January |
$ 73,490.40 |
0.0717 |
5605 |
$ 13.11 |
Interdisciplinary |
A |
UTSDL |
COUNTER 5 |
4696 |
909 |
1124 |
yes |
|
Journal Package D |
FY23 |
January |
$ 68,576.00 |
0.02 |
5611 |
$ 12.22 |
Interdisciplinary |
A |
UTSDL |
COUNTER 5 |
4794 |
817 |
705 |
yes |
|
Journal Package D |
FY22 |
January |
$ 67,231.57 |
0.015 |
6871 |
$ 9.78 |
Interdisciplinary |
A |
UTSDL |
COUNTER 5 |
6118 |
753 |
632 |
yes |
|
Database D |
FY25 |
January |
$ 3,500.00 |
4.4974 |
Health |
R |
UTSDL |
COUNTER 5 |
|||||||
Database D |
FY24 |
January |
$ 636.67 |
0.0301 |
275 |
$ 2.32 |
Health |
R |
UTSDL |
COUNTER 5 |
200 |
75 |
6 |
||
Database D |
FY23 |
January |
$ 618.09 |
0.03 |
312 |
$ 1.98 |
Health |
R |
UTSDL |
COUNTER 5 |
225 |
87 |
0 |
||
Database D |
FY22 |
January |
$ 600.10 |
0.03 |
236 |
$ 2.54 |
Health |
R |
UTSDL |
COUNTER 5 |
173 |
63 |
0 |
||
Index A |
FY25 |
October |
$ 64,970.00 |
0.02 |
Engineering |
T |
year 1 of 3 yr agrmt |
Local |
|||||||
Index A |
FY24 |
October |
$ 63,696.00 |
0.03 |
7835 |
$ 8.13 |
Engineering |
T |
Local |
COUNTER 5 |
4836 |
2999 |
|||
Index A |
FY23 |
October |
$ 61,840.00 |
0.03 |
6158 |
$ 10.04 |
Engineering |
T |
Local |
COUNTER 5 |
2751 |
3407 |
|||
Index A |
FY22 |
October |
$ 60,039.00 |
0.03 |
5625 |
$ 10.67 |
Engineering |
T |
Local |
COUNTER 5 |
1916 |
3709 |
|||
Magazine A |
FY25 |
April |
$ 3,410.00 |
0.0499 |
0 |
Political Science |
J |
Local |
|||||||
Magazine A |
FY24 |
April |
$ 3,248.00 |
0.0501 |
90 |
$ 36.09 |
Political Science |
J |
Local |
COUNTER 5 |
90 |
No |
|||
Magazine A |
FY23 |
April |
$ 3,093.00 |
0.0499 |
256 |
$ 12.08 |
Political Science |
J |
Local |
COUNTER 5 |
256 |
No |
|||
Magazine A |
FY22 |
April |
$ 2,946.00 |
0.0499 |
131 |
$ 22.49 |
Political Science |
J |
no data prior to Jan 2022 |
Local |
COUNTER 5 |
131 |
No |
||
Magazine B |
FY25 |
November |
$ 2,504.00 |
0.0499 |
0 |
Political Science |
J |
Local |
|||||||
Magazine B |
FY24 |
November |
$ 2,385.00 |
0.0502 |
35804 |
$ 0.07 |
Political Science |
J |
Local |
COUNTER 5 |
35804 |
No |
|||
Magazine B |
FY23 |
November |
$ 2,271.00 |
0.0499 |
31642 |
$ 0.07 |
Political Science |
J |
Local |
COUNTER 5 |
31642 |
No |
|||
Magazine B |
FY22 |
November |
$ 2,163.00 |
0.0198 |
24276 |
$ 0.09 |
Political Science |
J |
no data prior to Jan 2022 |
Local |
COUNTER 5 |
24276 |
No |
||
Reference Database B |
FY25 |
June |
0 |
Language |
P |
Local |
|||||||||
Reference Database B |
FY24 |
June |
$ 200.00 |
0 |
7 |
$ 28.57 |
Language |
P |
Local |
COUNTER 5 |
7 |
No |
|||
Reference Database B |
FY23 |
June |
$ 200.00 |
0 |
33 |
$ 6.06 |
Language |
P |
Local |
COUNTER 5 |
33 |
No |
|||
Reference Database B |
FY22 |
June |
$ 200.00 |
0 |
11 |
$ 18.18 |
Language |
P |
Local |
COUNTER 5 |
11 |
No |
|||
Reference Database C |
FY25 |
April |
$ 200.00 |
0 |
0 |
Language |
P |
Local |
|||||||
Reference Database C |
FY24 |
April |
$ 200.00 |
0 |
15 |
$ 13.33 |
Language |
P |
Local |
COUNTER 5 |
15 |
No |
|||
Reference Database C |
FY23 |
April |
$ 200.00 |
0 |
9 |
$ 22.22 |
Language |
P |
Local |
COUNTER 5 |
9 |
No |
|||
Reference Database C |
FY22 |
April |
$ 200.00 |
0 |
7 |
$ 28.57 |
Language |
P |
Local |
COUNTER 5 |
7 |
No |
|||
Video Package A |
FY25 |
April |
$ 8,988.20 |
0 |
0 |
Theatre |
P |
year 2 of 3 year |
Local |
COUNTER 5 |
|||||
Video Package A |
FY24 |
April |
$ 8,988.20 |
0.01 |
1408 |
$ 6.38 |
Theatre |
P |
year 1 of 3 year |
Local |
COUNTER 5 |
926 |
482 |
No |
|
Video Package A |
FY23 |
April |
$ 8,899.20 |
0 |
866 |
$ 10.28 |
Theatre |
P |
Local |
COUNTER 5 |
543 |
323 |
No |
||
Video Package A |
FY22 |
April |
$ 8,899.20 |
0 |
1189 |
$ 7.48 |
Theatre |
P |
Local |
COUNTER 5 |
836 |
353 |
No |
||
Ebook Package A |
FY25 |
January |
$ 12,736.00 |
0.0475 |
Health |
R |
Local |
||||||||
Ebook Package A |
FY24 |
January |
$ 12,158.00 |
0.03 |
1050 |
$ 11.58 |
Health |
R |
Local |
COUNTER 5 |
945 |
105 |
|||
Ebook Package A |
FY23 |
January |
$ 11,804.00 |
641 |
$ 18.41 |
Health |
R |
Local |
COUNTER 5 |
533 |
108 |
||||
Ebook Package A |
FY22 |
August |
$ 4,297.00 |
45 |
$ 95.49 |
Health |
R |
new August 2022 |
Local |
COUNTER 5 |
22 |
23 |
|||
Journal Package E |
FY25 |
January |
$ 3,937.00 |
0.0197 |
0 |
Science |
Q |
Local |
|||||||
Journal Package E |
FY24 |
January |
$ 3,861.00 |
0.0201 |
249 |
$ 15.51 |
Science |
Q |
Local |
COUNTER 5 |
221 |
28 |
4 |
yes |
|
Journal Package E |
FY23 |
January |
$ 3,785.00 |
0.0199 |
174 |
$ 21.75 |
Science |
Q |
Local |
COUNTER 5 |
155 |
19 |
3 |
yes |
|
Journal Package E |
FY22 |
January |
$ 3,711.00 |
0 |
218 |
$ 17.02 |
Science |
Q |
Local |
COUNTER 5 |
201 |
17 |
5 |
yes |
|
Index B |
FY25 |
July |
$ 8,774.00 |
0.0301 |
0 |
Anthropology |
G |
Local |
|||||||
Index B |
FY24 |
July |
$ 8,518.00 |
0.04 |
19327 |
$ 0.44 |
Anthropology |
G |
Local |
COUNTER 5 |
19327 |
||||
Index B |
FY23 |
July |
$ 8,190.00 |
0.0301 |
20588 |
$ 0.40 |
Anthropology |
G |
Local |
COUNTER 5 |
20588 |
||||
Index B |
FY22 |
July |
$ 7,951.00 |
0.0301 |
18438 |
$ 0.43 |
Anthropology |
G |
Local |
COUNTER 5 |
18438 |
||||
Index C |
FY25 |
January |
$ 6,907.00 |
0.0401 |
0 |
Art |
N |
Local |
|||||||
Index C |
FY24 |
January |
$ 6,641.00 |
0.0399 |
19776 |
$ 0.34 |
Art |
N |
Local |
COUNTER 5 |
2 |
19774 |
|||
Index C |
FY23 |
January |
$ 6,386.00 |
0.05 |
20552 |
$ 0.31 |
Art |
N |
Local |
COUNTER 5 |
2 |
20550 |
|||
Index C |
FY22 |
January |
$ 6,082.00 |
0.03 |
18356 |
$ 0.33 |
Art |
N |
Local |
COUNTER 5 |
18356 |
||||
Aggregator A |
FY25 |
July |
$ 14,504.00 |
0.04 |
0 |
Health |
R |
Local |
|||||||
Aggregator A |
FY24 |
July |
$ 13,946.00 |
0.04 |
736832 |
$ 0.02 |
Health |
R |
Local |
COUNTER 5 |
102660 |
634172 |
|||
Aggregator A |
FY23 |
July |
$ 13,412.00 |
0.04 |
722738 |
$ 0.02 |
Health |
R |
Local |
COUNTER 5 |
106892 |
615846 |
|||
Aggregator A |
FY22 |
July |
$ 12,894.00 |
0.03 |
775711 |
$ 0.02 |
Health |
R |
Local |
COUNTER 5 |
125232 |
650479 |
|||
Aggregator B |
FY25 |
June |
$ 16,121.00 |
0.04 |
0 |
Communication |
H |
Local |
|||||||
Aggregator B |
FY24 |
June |
$ 15,501.00 |
0.04 |
22453 |
$ 0.69 |
Communication |
H |
Local |
COUNTER 5 |
1350 |
21103 |
|||
Aggregator B |
FY23 |
June |
$ 14,905.00 |
0.04 |
24265 |
$ 0.61 |
Communication |
H |
Local |
COUNTER 5 |
1730 |
22535 |
|||
Aggregator B |
FY22 |
June |
$ 14,332.00 |
0.03 |
21649 |
$ 0.66 |
Communication |
H |
Local |
COUNTER 5 |
1924 |
19725 |
|||
Journal Package F |
FY25 |
July |
$ 11,929.00 |
0.04 |
0 |
Political Science |
J |
Local |
|||||||
Journal Package F |
FY24 |
July |
$ 11,470.00 |
0.04 |
22131 |
$ 0.52 |
Political Science |
J |
Local |
COUNTER 5 |
1908 |
20223 |
|||
Journal Package F |
FY23 |
July |
$ 11,029.00 |
0.04 |
24248 |
$ 0.45 |
Political Science |
J |
Local |
COUNTER 5 |
2327 |
21921 |
|||
Journal Package F |
FY22 |
July |
$ 10,605.00 |
0.03 |
21777 |
$ 0.49 |
Political Science |
J |
Local |
COUNTER 5 |
2226 |
19551 |
|||
Aggregator C |
FY25 |
November |
$ 14,729.40 |
0.05 |
0 |
Business |
H |
Local |
|||||||
Aggregator C |
FY24 |
November |
$ 14,028.00 |
0.04 |
32986 |
$ 0.43 |
Business |
H |
Local |
COUNTER 5 |
323 |
32663 |
|||
Aggregator C |
FY23 |
November |
$ 13,489.00 |
0.05 |
34647 |
$ 0.39 |
Business |
H |
Local |
COUNTER 5 |
347 |
34300 |
|||
Aggregator C |
FY22 |
November |
$ 12,847.00 |
0.03 |
35644 |
$ 0.36 |
Business |
H |
Local |
COUNTER 5 |
394 |
35250 |
|||
Index D |
FY25 |
January |
$ 6,000.00 |
0.04 |
0 |
Education |
L |
Local |
|||||||
Index D |
FY24 |
January |
$ 5,769.00 |
0.04 |
20702 |
$ 0.28 |
Education |
L |
Local |
COUNTER 5 |
9 |
20693 |
|||
Index D |
FY23 |
January |
$ 5,547.00 |
0.05 |
22539 |
$ 0.25 |
Education |
L |
Local |
COUNTER 5 |
18 |
22521 |
|||
Index D |
FY22 |
January |
$ 5,283.00 |
0.0298 |
20340 |
$ 0.26 |
Education |
L |
Local |
COUNTER 5 |
9 |
20331 |
|||
Aggregator D |
FY25 |
January |
$ 13,001.00 |
0.04 |
0 |
Health |
R |
Local |
|||||||
Aggregator D |
FY24 |
January |
$ 12,501.00 |
0.04 |
25650 |
$ 0.49 |
Health |
R |
Local |
COUNTER 5 |
2 |
25648 |
|||
Aggregator D |
FY23 |
January |
$ 12,020.00 |
0.03 |
26712 |
$ 0.45 |
Health |
R |
Local |
COUNTER 5 |
1 |
26711 |
|||
Aggregator D |
FY22 |
January |
$ 11,670.00 |
0.0298 |
24753 |
$ 0.47 |
Health |
R |
Local |
COUNTER 5 |
1 |
24752 |
|||
Index E |
FY25 |
January |
$ 4,972.00 |
0.0399 |
0 |
Health |
R |
Local |
|||||||
Index E |
FY24 |
January |
$ 4,781.00 |
0.04 |
35785 |
$ 0.13 |
Health |
R |
Local |
COUNTER 5 |
35785 |
||||
Index E |
FY23 |
January |
$ 4,597.00 |
0.05 |
31527 |
$ 0.15 |
Health |
R |
Local |
COUNTER 5 |
5 |
31522 |
|||
Index E |
FY22 |
January |
$ 4,378.00 |
0.0299 |
32010 |
$ 0.14 |
Health |
R |
Local |
COUNTER 5 |
3 |
32007 |
|||
Aggregator E |
FY25 |
July |
Library |
Z |
UTSDL |
||||||||||
Aggregator E |
FY24 |
July |
$ 1,601.83 |
0.04 |
19804 |
$ 0.08 |
Library |
Z |
UTSDL |
COUNTER 5 |
183 |
19621 |
no |
||
Aggregator E |
FY23 |
July |
$ 1,540.17 |
0.04 |
20774 |
$ 0.07 |
Library |
Z |
UTSDL |
COUNTER 5 |
149 |
20625 |
no |
||
Aggregator E |
FY22 |
July |
$ 1,481.00 |
0.03 |
18534 |
$ 0.08 |
Library |
Z |
UTSDL |
COUNTER 5 |
138 |
18396 |
no |
||
Index F |
FY25 |
June |
$ 5,650.00 |
0.0239 |
0 |
Philosophy |
B |
Local |
|||||||
Index F |
FY24 |
June |
$ 5,518.00 |
0.04 |
18693 |
$ 0.30 |
Philosophy |
B |
Local |
COUNTER 5 |
18693 |
||||
Index F |
FY23 |
June |
$ 5,306.00 |
0.0299 |
19231 |
$ 0.28 |
Philosophy |
B |
Local |
COUNTER 5 |
19231 |
||||
Index F |
FY22 |
June |
$ 5,152.00 |
0 |
18426 |
$ 0.28 |
Philosophy |
B |
Local |
COUNTER 5 |
18426 |
||||
Reference Database D |
FY25 |
September |
$ 16,594.00 |
0.04 |
0 |
Literature |
P |
Local |
|||||||
Reference Database D |
FY24 |
September |
$ 15,956.00 |
0.04 |
25165 |
$ 0.63 |
Literature |
P |
Local |
COUNTER 5 |
2698 |
22467 |
|||
Reference Database D |
FY23 |
September |
$ 15,342.00 |
0.05 |
26303 |
$ 0.58 |
Literature |
P |
Local |
COUNTER 5 |
2844 |
23459 |
|||
Reference Database D |
FY22 |
September |
$ 14,611.00 |
0.03 |
24159 |
$ 0.60 |
Literature |
P |
Local |
COUNTER 5 |
2838 |
21321 |
|||
Index G |
FY25 |
June |
$ 9,033.15 |
0.05 |
0 |
Music |
M |
Local |
|||||||
Index G |
FY24 |
June |
$ 8,603.00 |
0.04 |
19202 |
$ 0.45 |
Music |
M |
Local |
COUNTER 5 |
19202 |
||||
Index G |
FY23 |
June |
$ 8,272.00 |
0.0299 |
20049 |
$ 0.41 |
Music |
M |
Local |
COUNTER 5 |
20049 |
||||
Index G |
FY22 |
June |
$ 8,031.00 |
0.03 |
18086 |
$ 0.44 |
Music |
M |
Local |
COUNTER 5 |
18086 |
||||
Index H |
FY25 |
June |
$ 6,728.00 |
0.04 |
0 |
Social Work |
H |
Local |
|||||||
Index H |
FY24 |
June |
$ 6,469.00 |
0.02 |
24513 |
$ 0.26 |
Social Work |
H |
Local |
COUNTER 5 |
2 |
24511 |
|||
Index H |
FY23 |
June |
$ 6,342.00 |
0.03 |
26584 |
$ 0.24 |
Social Work |
H |
Local |
COUNTER 5 |
1 |
26583 |
|||
Index H |
FY22 |
June |
$ 6,157.00 |
0.0299 |
28207 |
$ 0.22 |
Social Work |
H |
Local |
COUNTER 5 |
5 |
28202 |
|||
Database E |
FY25 |
August |
Kinesiology |
R |
UTSDL |
||||||||||
Database E |
FY24 |
August |
$ 10,694.83 |
0.04 |
30110 |
$ 0.36 |
Kinesiology |
R |
UTSDL |
COUNTER 5 |
3954 |
26156 |
no |
||
Database E |
FY23 |
August |
$ 10,283.50 |
0.04 |
29834 |
$ 0.34 |
Kinesiology |
R |
UTSDL |
COUNTER 5 |
3841 |
25993 |
no |
||
Database E |
FY22 |
August |
$ 9,888.00 |
0.03 |
27460 |
$ 0.36 |
Kinesiology |
R |
UTSDL |
COUNTER 5 |
3824 |
23636 |
no |
||
Ebook Package B |
FY24 |
January |
$ 13,083.30 |
0.02 |
318 |
$ 41.14 |
Science |
Q |
Local |
COUNTER 5 |
318 |
||||
Ebook Package B |
FY23 |
January |
$ 12,826.76 |
0 |
384 |
$ 33.40 |
Science |
Q |
Local |
COUNTER 5 |
384 |
||||
Ebook Package B |
FY22 |
January |
$ 12,826.76 |
-0.025 |
284 |
$ 45.16 |
Science |
Q |
Local |
COUNTER 5 |
284 |
||||
Journal Package G |
FY25 |
January |
0 |
Science |
Q |
Local |
|||||||||
Journal Package G |
FY24 |
January |
$ 3,121.55 |
0.02 |
119 |
$ 26.23 |
Science |
Q |
Local |
COUNTER 5 |
119 |
7 |
|||
Journal Package G |
FY23 |
January |
$ 3,060.34 |
0 |
116 |
$ 26.38 |
Science |
Q |
Local |
COUNTER 5 |
116 |
9 |
|||
Journal Package G |
FY22 |
January |
$ 3,060.34 |
-0.025 |
246 |
$ 12.44 |
Science |
Q |
Local |
COUNTER 5 |
246 |
19 |
|||
Journal Package H |
FY25 |
January |
$ 28,886.00 |
0.04 |
Business |
H |
UTSDL |
||||||||
Journal Package H |
FY24 |
January |
$ 27,775.00 |
0.4094 |
11493 |
$ 2.42 |
Business |
H |
Local |
COUNTER 5 |
10560 |
933 |
630 |
yes |
|
Journal Package H |
FY23 |
January |
$ 19,707.12 |
0.03 |
11279 |
$ 1.75 |
Business |
H |
Local |
COUNTER 5 |
10618 |
661 |
401 |
yes |
|
Journal Package H |
FY22 |
January |
$ 19,133.44 |
0.03 |
8532 |
$ 2.24 |
Business |
H |
partial usage, Jan22-Aug22 only |
Local |
COUNTER 5 |
7792 |
740 |
221 |
yes |
Database F |
FY25 |
June |
$ 3,519.20 |
0.05 |
0 |
History |
C-F |
Local |
|||||||
Database F |
FY24 |
June |
$ 3,351.62 |
0.05 |
160 |
$ 20.95 |
History |
C-F |
Local |
COUNTER 5 |
160 |
no |
|||
Database F |
FY23 |
June |
$ 3,192.02 |
0.05 |
277 |
$ 11.52 |
History |
C-F |
Local |
COUNTER 5 |
277 |
no |
|||
Database F |
FY22 |
June |
$ 3,040.02 |
0.05 |
0 |
History |
C-F |
usage not available |
Local |
||||||
Database G |
FY25 |
January |
$ 17,881.61 |
0.05 |
0 |
Science |
Q |
Local |
|||||||
Database G |
FY24 |
January |
$ 17,030.10 |
0.05 |
1343 |
$ 12.68 |
Science |
Q |
Local |
COUNTER 5 |
1222 |
121 |
233 |
no |
|
Database G |
FY23 |
January |
$ 16,219.14 |
0.05 |
2634 |
$ 6.16 |
Science |
Q |
Local |
COUNTER 5 |
2534 |
100 |
288 |
no |
|
Database G |
FY22 |
January |
$ 15,446.80 |
0.05 |
2017 |
$ 7.66 |
Science |
Q |
Local |
COUNTER 5 |
1807 |
210 |
227 |
no |
|
Dataset A |
FY25 |
September |
$ 16,345.00 |
0.0655 |
0 |
Business |
H |
Partner |
|||||||
Dataset A |
FY24 |
September |
$ 15,340.00 |
0.0653 |
2461 |
$ 6.23 |
Business |
H |
Partner |
Non-COUNTER |
2461 |
no |
|||
Dataset A |
FY23 |
September |
$ 14,400.00 |
0.0406 |
1605 |
$ 8.97 |
Business |
H |
Partner |
Non-COUNTER |
1605 |
no |
|||
Dataset A |
FY22 |
September |
$ 13,838.00 |
0.0402 |
1564 |
$ 8.85 |
Business |
H |
Partner |
Non-COUNTER |
1564 |
no |
|||
Ebook Package C |
FY25 |
August |
Engineering |
T |
UTSDL |
||||||||||
Ebook Package C |
FY24 |
August |
$ 142,266.00 |
0.0385 |
70984 |
$ 2.00 |
Engineering |
T |
UTSDL |
COUNTER 5 |
58953 |
12031 |
5372 |
yes |
|
Ebook Package C |
FY23 |
August |
$ 136,991.61 |
0.0345 |
58763 |
$ 2.33 |
Engineering |
T |
UTSDL |
COUNTER 5 |
46974 |
11789 |
3938 |
yes |
|
Ebook Package C |
FY22 |
August |
$ 132,423.07 |
0.0482 |
53056 |
$ 2.50 |
Engineering |
T |
UTSDL |
COUNTER 5 |
42555 |
10501 |
3382 |
yes |
|
Aggregator F |
FY25 |
October |
$ 43,231.00 |
0.02 |
Engineering |
T |
year 1 of 3 yr agrmt |
UTSDL |
|||||||
Aggregator F |
FY24 |
October |
$ 42,383.00 |
0.03 |
7978 |
$ 5.31 |
Engineering |
T |
UTSDL |
COUNTER 5 |
4859 |
3119 |
|||
Aggregator F |
FY23 |
October |
$ 41,148.00 |
0.03 |
5142 |
$ 8.00 |
Engineering |
T |
UTSDL |
COUNTER 5 |
1926 |
3216 |
|||
Aggregator F |
FY22 |
October |
$ 39,950.00 |
0.03 |
4350 |
$ 9.18 |
Engineering |
T |
UTSDL |
COUNTER 5 |
1125 |
3225 |
|||
Journal Package I |
FY25 |
January |
$ 66,081.00 |
0.035 |
Physics |
Q |
UTSDL |
||||||||
Journal Package I |
FY24 |
January |
$ 63,847.00 |
0.035 |
20192 |
$ 3.16 |
Physics |
Q |
UTSDL |
COUNTER 5 |
5243 |
14949 |
3682 |
no |
|
Journal Package I |
FY23 |
January |
$ 61,688.00 |
0.04 |
20009 |
$ 3.08 |
Physics |
Q |
UTSDL |
COUNTER 5 |
5791 |
14218 |
3686 |
no |
|
Journal Package I |
FY22 |
January |
$ 59,314.83 |
0.035 |
13758 |
$ 4.31 |
Physics |
Q |
partial usage, only Jan-Aug 2022 available |
UTSDL |
COUNTER 5 |
4844 |
8914 |
1966 |
no |
Reference Database E |
FY25 |
January |
$ 900.00 |
0 |
0 |
Music |
M |
Local |
|||||||
Reference Database E |
FY24 |
January |
$ 900.00 |
0 |
443 |
$ 2.03 |
Music |
M |
Local |
Non-COUNTER |
443 |
no |
|||
Reference Database E |
FY23 |
January |
$ 900.00 |
-0.0323 |
524 |
$ 1.72 |
Music |
M |
Local |
Non-COUNTER |
524 |
no |
|||
Reference Database E |
FY22 |
January |
$ 930.00 |
130 |
$ 7.15 |
Music |
M |
new FY22, data begins 11/21 |
Local |
Non-COUNTER |
130 |
no |
|||
Dataset B |
FY25 |
June |
0 |
Business |
H |
Local |
|||||||||
Dataset B |
FY24 |
June |
$ 352.00 |
0.0476 |
404 |
$ 0.87 |
Business |
H |
Local |
Non-COUNTER |
353 |
51 |
No |
||
Dataset B |
FY23 |
June |
$ 336.00 |
0.05 |
119 |
$ 2.82 |
Business |
H |
Local |
Non-COUNTER |
91 |
28 |
No |
||
Dataset B |
FY22 |
June |
$ 320.00 |
0.0361 |
511 |
$ 0.63 |
Business |
H |
Local |
Non-COUNTER |
305 |
206 |
No |
||
Ebook Package D |
FY25 |
January |
$ 6,425.00 |
0 |
0 |
Interdisciplinary |
A |
year 2 of 3 year |
Local |
||||||
Ebook Package D |
FY24 |
January |
$ 6,425.00 |
0.049 |
464 |
$ 13.85 |
Interdisciplinary |
A |
year 1 of 3 year |
Local |
COUNTER 5 |
322 |
142 |
||
Ebook Package D |
FY23 |
January |
$ 6,125.00 |
401 |
$ 15.27 |
Interdisciplinary |
A |
new FY23 |
Local |
COUNTER 5 |
232 |
169 |
|||
Journal Package J |
FY25 |
January |
$ 261,340.87 |
0.141 |
Science |
Q |
UTSDL |
COUNTER 5 |
|||||||
Journal Package J |
FY24 |
January |
$ 229,047.37 |
0.1445 |
42574 |
$ 5.38 |
Science |
Q |
UTSDL |
COUNTER 5 |
40310 |
2264 |
44166 |
yes |
|
Journal Package J |
FY23 |
January |
$ 200,134.09 |
0.1484 |
43815 |
$ 4.57 |
Science |
Q |
UTSDL |
COUNTER 5 |
41586 |
2229 |
36074 |
yes |
|
Journal Package J |
FY22 |
January |
$ 174,272.00 |
0.1529 |
35391 |
$ 4.92 |
Science |
Q |
UTSDL |
COUNTER 5 |
34266 |
1125 |
26793 |
yes |
|
Media Database A |
FY25 |
April |
$ 2,096.47 |
0.0259 |
0 |
Music |
M |
Local |
|||||||
Media Database A |
FY24 |
April |
$ 2,043.53 |
0.0266 |
1855 |
$ 1.10 |
Music |
M |
Local |
Non-COUNTER |
1617 |
238 |
no |
||
Media Database A |
FY23 |
April |
$ 1,990.59 |
0.0273 |
1264 |
$ 1.57 |
Music |
M |
Local |
Non-COUNTER |
978 |
286 |
no |
||
Media Database A |
FY22 |
April |
$ 1,937.65 |
0.0281 |
3971 |
$ 0.49 |
Music |
M |
Local |
Non-COUNTER |
3364 |
607 |
no |
||
Magazine C |
FY25 |
March |
$ 26,153.00 |
0.03 |
0 |
Interdisciplinary |
A |
Local |
|||||||
Magazine C |
FY24 |
March |
$ 25,391.00 |
0.03 |
14359 |
$ 1.77 |
Interdisciplinary |
A |
Local |
COUNTER 5 |
5174 |
9185 |
|||
Magazine C |
FY23 |
March |
$ 24,651.00 |
0.0513 |
13023 |
$ 1.89 |
Interdisciplinary |
A |
Local |
COUNTER 5 |
5592 |
7431 |
|||
Magazine C |
FY22 |
March |
$ 23,448.00 |
0.03 |
15869 |
$ 1.48 |
Interdisciplinary |
A |
Local |
COUNTER 5 |
5058 |
10811 |
|||
Aggregator G |
FY25 |
July |
0 |
Business |
H |
Local |
|||||||||
Aggregator G |
FY24 |
July |
$ 51,563.87 |
0.035 |
12715 |
$ 4.06 |
Business |
H |
Local |
COUNTER 5 |
6697 |
6018 |
no |
||
Aggregator G |
FY23 |
July |
$ 49,820.16 |
0.03 |
8994 |
$ 5.54 |
Business |
H |
data unavailable prior to 1/23 |
Local |
COUNTER 5 |
4767 |
4227 |
no |
|
Aggregator G |
FY22 |
July |
$ 48,369.09 |
0.025 |
0 |
Business |
H |
usage not available |
Local |
||||||
Database H |
FY25 |
January |
$ 5,975.00 |
0 |
0 |
Technology |
T |
Local |
|||||||
Database H |
FY24 |
January |
$ 5,975.00 |
0.0482 |
293 |
$ 20.39 |
Technology |
T |
Local |
COUNTER 5 |
261 |
32 |
2 |
no |
|
Database H |
FY23 |
January |
$ 5,700.00 |
0.0179 |
634 |
$ 8.99 |
Technology |
T |
Local |
COUNTER 5 |
584 |
50 |
no |
||
Database H |
FY22 |
January |
$ 5,600.00 |
0.0275 |
1078 |
$ 5.19 |
Technology |
T |
Local |
COUNTER 5 |
844 |
234 |
no |
||
Media Database B |
FY25 |
March |
$ 21,185.00 |
0.05 |
0 |
Health |
R |
Local |
|||||||
Media Database B |
FY24 |
March |
$ 20,176.00 |
0.06 |
2106 |
$ 9.58 |
Health |
R |
Local |
COUNTER 5 |
85 |
2021 |
no |
||
Media Database B |
FY23 |
March |
$ 18,034.00 |
0.05 |
3323 |
$ 5.43 |
Health |
R |
Local |
COUNTER 5 |
86 |
3237 |
no |
||
Media Database B |
FY22 |
March |
$ 18,127.00 |
0.0193 |
2623 |
$ 6.91 |
Health |
R |
partial usage Jan-Aug 2022 |
Local |
COUNTER 5 |
30 |
2593 |
no |
|
Journal Package K |
FY25 |
July |
$ 17,757.00 |
0.0543 |
0 |
Health |
R |
Local |
|||||||
Journal Package K |
FY24 |
July |
$ 16,843.00 |
0.054 |
12604 |
$ 1.34 |
Health |
R |
Local |
COUNTER 5 |
3752 |
8852 |
yes |
||
Journal Package K |
FY23 |
July |
$ 15,980.00 |
0.0537 |
12795 |
$ 1.25 |
Health |
R |
Local |
COUNTER 5 |
4924 |
7871 |
yes |
||
Journal Package K |
FY22 |
July |
$ 15,166.00 |
0.0533 |
9351 |
$ 1.62 |
Health |
R |
partial usage Jan-Aug 2022 |
Local |
COUNTER 5 |
3935 |
5416 |
yes |
|
Reference Database F |
FY25 |
July |
$ 3,703.50 |
0.03 |
0 |
Art |
N |
Local |
|||||||
Reference Database F |
FY24 |
July |
$ 3,595.63 |
0.03 |
1570 |
$ 2.29 |
Art |
N |
Local |
COUNTER 5 |
621 |
949 |
|||
Reference Database F |
FY23 |
July |
$ 3,490.90 |
0.05 |
1110 |
$ 3.14 |
Art |
N |
Local |
COUNTER 5 |
335 |
775 |
|||
Reference Database F |
FY22 |
July |
$ 3,324.66 |
0.035 |
1453 |
$ 2.29 |
Art |
N |
Local |
COUNTER 5 |
578 |
875 |
|||
Reference Database G |
FY25 |
July |
$ 3,462.48 |
0.03 |
0 |
Social Work |
H |
Local |
|||||||
Reference Database G |
FY24 |
July |
$ 3,361.63 |
0.04 |
672 |
$ 5.00 |
Social Work |
H |
Local |
COUNTER 5 |
298 |
374 |
|||
Reference Database G |
FY23 |
July |
$ 3,232.34 |
0.05 |
466 |
$ 6.94 |
Social Work |
H |
Local |
COUNTER 5 |
223 |
243 |
|||
Reference Database G |
FY22 |
July |
$ 3,078.42 |
0.035 |
475 |
$ 6.48 |
Social Work |
H |
Local |
COUNTER 5 |
180 |
295 |
|||
Database I |
FY25 |
July |
$ 11,393.07 |
3 |
0 |
Interdisciplinary |
A |
Local |
|||||||
Database I |
FY24 |
July |
$ 11,061.23 |
0.03 |
11372 |
$ 0.97 |
Interdisciplinary |
A |
Local |
COUNTER 5 |
4041 |
7331 |
|||
Database I |
FY23 |
July |
$ 10,739.06 |
0.05 |
5357 |
$ 2.00 |
Interdisciplinary |
A |
Local |
COUNTER 5 |
2257 |
3100 |
|||
Database I |
FY22 |
July |
$ 10,227.68 |
0.035 |
11067 |
$ 0.92 |
Interdisciplinary |
A |
Local |
COUNTER 5 |
4714 |
6353 |
|||
Reference Database H |
FY25 |
July |
$ 3,168.70 |
0.03 |
0 |
Music |
M |
Local |
|||||||
Reference Database H |
FY24 |
July |
$ 3,076.41 |
0.03 |
2659 |
$ 1.16 |
Music |
M |
Local |
COUNTER 5 |
1366 |
1293 |
|||
Reference Database H |
FY23 |
July |
$ 2,986.81 |
0.05 |
1471 |
$ 2.03 |
Music |
M |
Local |
COUNTER 5 |
879 |
592 |
|||
Reference Database H |
FY22 |
July |
$ 2,844.58 |
0.035 |
2211 |
$ 1.29 |
Music |
M |
Local |
COUNTER 5 |
1363 |
848 |
|||
Database J |
FY25 |
July |
$ 1,089.56 |
0.03 |
0 |
Interdisciplinary |
A |
Local |
|||||||
Database J |
FY24 |
July |
$ 1,057.83 |
0.03 |
1491 |
$ 0.71 |
Interdisciplinary |
A |
Local |
COUNTER 5 |
975 |
516 |
|||
Database J |
FY23 |
July |
$ 1,027.02 |
0.05 |
779 |
$ 1.32 |
Interdisciplinary |
A |
Local |
COUNTER 5 |
463 |
316 |
|||
Database J |
FY22 |
July |
$ 978.10 |
0.035 |
693 |
$ 1.41 |
Interdisciplinary |
A |
Local |
COUNTER 5 |
274 |
419 |
|||
Journal Package L |
FY25 |
January |
$ 109,290.25 |
0.0369 |
Interdisciplinary |
A |
UTSDL |
||||||||
Journal Package L |
FY24 |
January |
$ 105,396.82 |
0.0245 |
30289 |
$ 3.48 |
Interdisciplinary |
A |
UTSDL |
COUNTER 5 |
29144 |
1145 |
8464 |
yes |
|
Journal Package L |
FY23 |
January |
$ 102,872.36 |
0.1376 |
43396 |
$ 2.37 |
Interdisciplinary |
A |
UTSDL |
COUNTER 5 |
41914 |
1482 |
9740 |
yes |
|
Journal Package L |
FY22 |
January |
$ 90,432.48 |
0.0336 |
35279 |
$ 2.56 |
Interdisciplinary |
A |
UTSDL |
COUNTER 5 |
34089 |
1190 |
5940 |
yes |
|
Index I |
FY25 |
August |
0 |
Architecture |
N |
Local |
|||||||||
Index I |
FY24 |
August |
$ 3,905.42 |
0.05 |
12092 |
$ 0.32 |
Architecture |
N |
Local |
COUNTER 5 |
0 |
12092 |
|||
Index I |
FY23 |
August |
$ 3,719.45 |
0.05 |
11892 |
$ 0.31 |
Architecture |
N |
Local |
COUNTER 5 |
1 |
11891 |
|||
Index I |
FY22 |
August |
$ 3,542.33 |
0.05 |
8173 |
$ 0.43 |
Architecture |
N |
partial data, does not have Sep-Nov 2021 |
Local |
COUNTER 5 |
0 |
8173 |
||
Database K |
FY25 |
January |
$ 33,083.37 |
0.049 |
0 |
Interdisciplinary |
A |
Local |
|||||||
Database K |
FY24 |
January |
$ 31,538.01 |
0.049 |
45375 |
$ 0.70 |
Interdisciplinary |
A |
Local |
COUNTER 5 |
12023 |
33352 |
|||
Database K |
FY23 |
January |
$ 30,064.83 |
0.049 |
47332 |
$ 0.64 |
Interdisciplinary |
A |
Local |
COUNTER 5 |
11533 |
35799 |
|||
Database K |
FY22 |
January |
$ 28,660.47 |
0.048 |
22896 |
$ 1.25 |
Interdisciplinary |
A |
partial data, does not have Sep-Nov 2021 |
Local |
COUNTER 5 |
10093 |
12803 |
||
Journal Package M |
FY25 |
September |
$ 7,384.19 |
0.049 |
0 |
Music |
M |
Local |
|||||||
Journal Package M |
FY24 |
September |
$ 7,039.27 |
0.049 |
11888 |
$ 0.59 |
Music |
M |
Local |
COUNTER 5 |
390 |
11498 |
|||
Journal Package M |
FY23 |
September |
$ 6,710.46 |
0.048 |
11608 |
$ 0.58 |
Music |
M |
Local |
COUNTER 5 |
409 |
11199 |
|||
Journal Package M |
FY22 |
September |
$ 6,403.11 |
0 |
7089 |
$ 0.90 |
Music |
M |
partial data, does not have Sep-Nov 2021 |
Local |
COUNTER 5 |
276 |
6813 |
||
Index J |
FY25 |
July |
$ 11,585.87 |
0.049 |
Social Sciences |
H |
UTSDL |
||||||||
Index J |
FY24 |
July |
$ 11,044.67 |
0.049 |
11756 |
$ 0.94 |
Social Sciences |
H |
UTSDL |
COUNTER 5 |
0 |
11756 |
|||
Index J |
FY23 |
July |
$ 10,528.77 |
0.049 |
11313 |
$ 0.93 |
Social Sciences |
H |
UTSDL |
COUNTER 5 |
1 |
11312 |
|||
Index J |
FY22 |
July |
$ 10,036.96 |
0.048 |
6782 |
$ 1.48 |
Social Sciences |
H |
partial usage, only Dec21-Aug22 |
UTSDL |
COUNTER 5 |
1 |
6781 |
||
Aggregator H |
FY25 |
September |
$ 39,798.68 |
0.049 |
0 |
Social Sciences |
H |
Local |
|||||||
Aggregator H |
FY24 |
September |
$ 37,939.64 |
0.049 |
14450 |
$ 2.63 |
Social Sciences |
H |
Local |
COUNTER 5 |
2642 |
11808 |
|||
Aggregator H |
FY23 |
September |
$ 36,167.44 |
0.048 |
14054 |
$ 2.57 |
Social Sciences |
H |
Local |
COUNTER 5 |
2686 |
11368 |
|||
Aggregator H |
FY22 |
September |
$ 34,510.92 |
0 |
12212 |
$ 2.83 |
Social Sciences |
H |
partial data, does not have Sep-Nov 2021 |
Local |
COUNTER 5 |
5171 |
7041 |
||
Index K |
FY25 |
March |
$ 2,046.13 |
0.049 |
0 |
Health |
R |
Local |
|||||||
Index K |
FY24 |
March |
$ 1,950.55 |
0.049 |
11756 |
$ 0.17 |
Health |
R |
Local |
COUNTER 5 |
0 |
11756 |
|||
Index K |
FY23 |
March |
$ 1,859.44 |
0.049 |
11433 |
$ 0.16 |
Health |
R |
Local |
COUNTER 5 |
2 |
11431 |
|||
Index K |
FY22 |
March |
$ 1,772.58 |
0.048 |
6919 |
$ 0.26 |
Health |
R |
partial data, does not have Sep-Nov 2021 |
Local |
COUNTER 5 |
0 |
6919 |
||
Reference Database I |
FY25 |
July |
$ 8,618.12 |
0.0488 |
0 |
Interdisciplinary |
A |
Local |
Non-COUNTER |
||||||
Reference Database I |
FY24 |
July |
$ 8,215.56 |
-0.0034 |
1878 |
$ 4.37 |
Interdisciplinary |
A |
Local |
Non-COUNTER |
681 |
1197 |
|||
Reference Database I |
FY23 |
July |
$ 8,244.00 |
73 |
$ 112.93 |
Interdisciplinary |
A |
new July FY23 |
Local |
Non-COUNTER |
19 |
54 |
|||
Magazine D |
FY25 |
February |
$ 16,873.85 |
0.049 |
0 |
Interdisciplinary |
A |
Local |
|||||||
Magazine D |
FY24 |
February |
$ 16,085.65 |
0.049 |
14795 |
$ 1.09 |
Interdisciplinary |
A |
Local |
COUNTER 5 |
2464 |
12331 |
|||
Magazine D |
FY23 |
February |
$ 15,334.27 |
0.049 |
14031 |
$ 1.09 |
Interdisciplinary |
A |
Local |
COUNTER 5 |
1970 |
12061 |
|||
Magazine D |
FY22 |
February |
$ 14,617.99 |
0.048 |
9420 |
$ 1.55 |
Interdisciplinary |
A |
partial data, does not have Sep-Nov 2021 |
Local |
COUNTER 5 |
1762 |
7658 |
||
Media Database C |
FY25 |
September |
$ 3,016.60 |
0.05 |
0 |
Health |
R |
Local |
|||||||
Media Database C |
FY24 |
September |
$ 2,873.00 |
0.04 |
3837 |
Health |
R |
partial data, does not have Aug 2024, possible system reporting error |
Local |
Non-COUNTER |
3837 |
||||
Media Database C |
FY23 |
September |
$ 2,762.60 |
0.04 |
790 |
Health |
R |
partial data, dost not have Sep-Oct, Dec 2022. Mar 2023, possible system reporting error |
Local |
Non-COUNTER |
790 |
||||
Media Database C |
FY22 |
September |
$ 2,656.40 |
1270 |
Health |
R |
partial data, does not have Aug-Dec 2021, possible system reporting error |
Local |
Non-COUNTER |
1270 |
|||||
Journal Package N |
FY25 |
January |
$ 26,818.45 |
0.025 |
0 |
Interdisciplinary |
A |
Local |
|||||||
Journal Package N |
FY24 |
January |
$ 26,163.81 |
0.025 |
5136 |
$ 5.09 |
Interdisciplinary |
A |
Local |
COUNTER 5 |
4071 |
1065 |
101 |
yes |
|
Journal Package N |
FY23 |
January |
$ 25,525.94 |
0.02 |
6086 |
$ 4.19 |
Interdisciplinary |
A |
Local |
COUNTER 5 |
5040 |
1046 |
64 |
yes |
|
Journal Package N |
FY22 |
January |
$ 25,026.57 |
0 |
3224 |
$ 7.76 |
Interdisciplinary |
A |
partial usage only Jan-Aug 2021 |
Local |
Alma |
2693 |
531 |
||
Newspapers A |
FY25 |
January |
$ 2,379.00 |
0.0299 |
0 |
History |
C-F |
Local |
|||||||
Newspapers A |
FY24 |
January |
$ 2,310.00 |
0.0299 |
2933 |
$ 0.79 |
History |
C-F |
Local |
COUNTER 5 |
2933 |
||||
Newspapers A |
FY23 |
January |
$ 2,243.00 |
0.0298 |
2007 |
$ 1.12 |
History |
C-F |
Local |
COUNTER 5 |
2007 |
||||
Newspapers A |
FY22 |
January |
$ 2,178.00 |
0.0298 |
1344 |
$ 1.62 |
History |
C-F |
Local |
COUNTER 5 |
1344 |
||||
Journal Package O |
FY25 |
January |
$ 198,172.51 |
0.035 |
Interdisciplinary |
A |
UTSDL |
||||||||
Journal Package O |
FY24 |
January |
$ 191,471.01 |
0.035 |
84221 |
$ 2.27 |
Interdisciplinary |
A |
UTSDL |
COUNTER 5 |
78994 |
5227 |
9245 |
yes |
|
Journal Package O |
FY23 |
January |
$ 184,996.14 |
0.0733 |
97933 |
$ 1.89 |
Interdisciplinary |
A |
UTSDL |
COUNTER 5 |
84320 |
13613 |
7719 |
yes |
|
Journal Package O |
FY22 |
January |
$ 172,364.31 |
0.035 |
87176 |
$ 1.98 |
Interdisciplinary |
A |
UTSDL |
COUNTER 5 |
82518 |
4658 |
6709 |
yes |
|
Magazine E |
FY25 |
September |
$ 14,454.22 |
0.04 |
Science |
Q |
UTSDL |
COUNTER 5 |
|||||||
Magazine E |
FY24 |
September |
$ 13,898.29 |
0.04 |
11922 |
$ 1.17 |
Science |
Q |
UTSDL |
COUNTER 5 |
4322 |
7600 |
1221 |
yes |
|
Magazine E |
FY23 |
September |
$ 13,363.74 |
0.04 |
10271 |
$ 1.30 |
Science |
Q |
UTSDL |
COUNTER 5 |
3856 |
6415 |
1049 |
yes |
|
Magazine E |
FY22 |
September |
$ 12,849.75 |
0 |
7392 |
$ 1.74 |
Science |
Q |
UTSDL |
COUNTER 5 |
3586 |
3806 |
1218 |
yes |
|
Ebook Package E |
FY25 |
January |
$ 2,800.00 |
0.0452 |
0 |
Science |
Q |
Local |
|||||||
Ebook Package E |
FY24 |
January |
$ 2,679.00 |
0.0352 |
622 |
$ 4.31 |
Science |
Q |
Local |
COUNTER 5 |
622 |
yes |
|||
Ebook Package E |
FY23 |
January |
$ 2,588.00 |
0.0348 |
700 |
$ 3.70 |
Science |
Q |
Local |
COUNTER 5 |
700 |
yes |
|||
Ebook Package E |
FY22 |
January |
$ 2,501.00 |
0.0352 |
1187 |
$ 2.11 |
Science |
Q |
Local |
COUNTER 5 |
1187 |
yes |
|||
Journal Package P |
FY25 |
January |
$ 32,925.00 |
0.0201 |
0 |
Technology |
T |
Local |
|||||||
Journal Package P |
FY24 |
January |
$ 32,276.00 |
0.0526 |
2026 |
$ 15.93 |
Technology |
T |
Local |
COUNTER 5 |
1584 |
442 |
96 |
||
Journal Package P |
FY23 |
January |
$ 30,662.00 |
0.0556 |
831 |
$ 36.90 |
Technology |
T |
Local |
COUNTER 5 |
800 |
31 |
84 |
yes |
|
Journal Package P |
FY22 |
January |
$ 29,048.00 |
0 |
1013 |
$ 28.68 |
Technology |
T |
Local |
COUNTER 5 |
966 |
47 |
217 |
yes |
|
Journal Package Q |
FY25 |
January |
Interdisciplinary |
A |
UTSDL |
COUNTER 5 |
|||||||||
Journal Package Q |
FY24 |
January |
$ 299,177.41 |
0.0181 |
96929 |
$ 3.09 |
Interdisciplinary |
A |
UTSDL |
COUNTER 5 |
89725 |
7204 |
29769 |
yes |
|
Journal Package Q |
FY23 |
January |
$ 293,866.30 |
0.0271 |
118909 |
$ 2.47 |
Interdisciplinary |
A |
UTSDL |
COUNTER 5 |
113156 |
5753 |
25684 |
yes |
|
Journal Package Q |
FY22 |
January |
$ 286,109.96 |
0.0302 |
106607 |
$ 2.68 |
Interdisciplinary |
A |
UTSDL |
COUNTER 5 |
101464 |
5143 |
20033 |
yes |
|
Media Database D |
FY25 |
September |
$ 8,550.00 |
0 |
0 |
Interdisciplinary |
A |
Local |
|||||||
Media Database D |
FY24 |
September |
$ 8,550.00 |
0 |
532 |
$ 16.07 |
Interdisciplinary |
A |
Local |
Non-COUNTER |
532 |
||||
Media Database D |
FY23 |
September |
$ 8,550.00 |
400 |
$ 21.38 |
Interdisciplinary |
A |
new FY23 |
Local |
Non-COUNTER |
400 |
||||
Journal Package R |
FY25 |
January |
$ 220,063.26 |
0.03 |
Interdisciplinary |
A |
UTSDL |
||||||||
Journal Package R |
FY24 |
January |
$ 213,654.00 |
0.0866 |
48756 |
$ 4.38 |
Interdisciplinary |
A |
UTSDL |
COUNTER 5 |
46058 |
2698 |
6148 |
yes |
|
Journal Package R |
FY23 |
January |
$ 196,617.24 |
0.0366 |
28321 |
$ 6.94 |
Interdisciplinary |
A |
UTSDL |
COUNTER 5 |
24912 |
3409 |
3882 |
yes |
|
Journal Package R |
FY22 |
January |
$ 189,680.79 |
0.035 |
28529 |
$ 6.65 |
Interdisciplinary |
A |
UTSDL |
COUNTER 5 |
26038 |
2491 |
2902 |
yes |
Contributor Notes
Amy Castillo is Director of Access and Discovery, University of Texas at Arlington Libraries, Arlington, Texas, USA.

![The dashboard contains 12 sections: Year to Year Cost, Cost Per Use - Controlled, Resource Name, Fiscal Year, LC Class, Total Usage (Controlled Downloads + Searches), % Changes of Costs Year to Year, OA Usage, Primary Subject [Area], Fund Sources, Fund Source, and Controlled full-Text vs OA Full-Text. Data inside these sections are represented in various ways, including column charts accompanied by tables, a line chart, and lists of terms. Each section has tools representing a dynamic way to interact with the information, such as filters and dropdown menus.](nasig.11068-f0001.jpg)



