18/07/2024
biblioMagika® - v2.9.1
Updated the journal ratings based on the AJG 2024.
Added ratings for each journal based on the 2024 JIF, JIF5Years, category, and quartile as indexed by the Web of Science.
Reorganised the Scopus ranking columns.
Added DOI link in the Highly Cited Documents analysis.
18/07/2024
biblioMagika® - v2.9
Fixed the formula for AJG2021 Rating, ABDC Rating, and Publisher Name.
Added columns to accommodate the NCA value in "Pub. by Affiliation" and "Pub. by Countries."
Implemented a formula to read the NCA for "Pub. by Affiliation" and "Pub. by Countries."
Included a callout note in the Keywords worksheet for better clarity and guidance.
Updated values for CiteScore 2023, SJR 2023, SNIP 2023, and Quartile for all Source Titles.
01/05/2024
biblioMagika® - v2.8.1
Fixed the error with the Publication by Year and Publication by Sources.
01/05/2024
biblioMagika® - v2.8
Added refresh button for all Pivot Tables to automate the process of refreshing and filtering.
Added the function buttons to sort allowing the following additional output to be automatically generated:
- Most Productives Source Title/Author/Institutions/Country
- Most Influential Source Title/Author/Institutions/Country by Total Citations
- Most Influential Source Title/Author/Institutions/Country by H-Index
- Most Influential Source Title/Author/Institutions/Country by G-Index
Added button for auto refresh (sort) highly cited documents.
Added an auto-read function to read the current affiliation and country of the author in the author sheet.
Added an auto-read function for the country of the institution in the affiliation sheet.
01/05/2024
biblioMagika® - v2.7
Added frequency analysis for author keywords and index keywords.
Changed the layout of Basic Info.
Added the Cumulative Growth of Publications Over Time chart under Publication by Year.
Added the cleaned sample output table for Annual Research Output and Citation Metrics under Publication by Year.
Added the cleaned sample output table for Most Productive Source Titles.
Added the cleaned sample output table for Most Productive Authors.
Added the cleaned sample output table for Most Productive Institutions.
Added the cleaned sample output table for Most Productive Countries.
01/05/2024
biblioMagika® - v2.6
Fixed the minor error formula for iipmaps.
Added the continent column for Pub. By Country analysis
Update Scopus List as at March 2024
Added the list of conference title on top of current list of journal in Scopus List
12/02/2024
biblioMagika® - v2.5.1
Fixed the formula of countries data for iipmaps.com
Added column NCA for affiliation and countries
01/01/2024
biblioMagika® - v2.5
Incorporate the country data with iipmaps.com
Improved the Scopus link to associate with user's account
Update Scopus List as at December 2023
Added column for AU-ID Link for easy finding the current affiliation and country of the authors in the Author worksheet.
Added column for Author Full Name (Last Name, First Name) in the Author Worksheet.
Added column for Current Affiliation and Country in the Author Worksheet.
Added column for Google Search Link for easy finding the country of the affiliation in the Affiliation worksheet.
Added column for Country in the Affiliation Worksheet.
04/12/2023
biblioMagika® - v2.4
Incorporated cumulative TP calculation data within the section on Publications by Source Titles.
Included Bradford's Law Zone information within the Publications by Source Titles section.
[Just make sure the TP and second layer of sorting has been sorted accordingly]
Appended a dedicated worksheet containing the Australian Business Deans Council (ABDC) listings from the 2019 Journal Quality List (JQL).
Integrated a worksheet housing the Chartered Association of Business Schools (CABS) listings from the 2021 Academic Journal Guide (AJG).
Incorporated a worksheet containing the comprehensive list of journals indexed by Scopus for the year 2023.
Supplemented the Publication by Source Titles section with the AJG 2021 ratings.
Augmented the Publication by Source Titles section with the ABDC ratings.
Incorporated the publisher names within the Publication by Source Titles section.
Provided accessible hyperlinks for each journal listed in the Publication by Source Titles section.
Included the "Top 20 Most Productive Source Titles" chart within the "Publication by Source Title" worksheet.
03/11/2023
biblioMagika® - v2.3
Fixed the calculation of g-index for Authors, Affiliations and Countries.
02/09/2023
biblioMagika® - v2.2
Added DOI for Highly Cited Documents.
Minor cell formatting.
18/07/2023
biblioMagika® - v2.1
Increase the limitation of analysis from 10000 to the limit that Excel or your computer can works Increase from 20 to 50 highly cited documents.
Add refresh button to recalculate all the measurements related to h-index, g-index and m-index based on the total number of documents. So, your computer will not use the resources all the times
Fixed the calculation of C/CP for source titles.
Convert from normal Excel file (.xlsx) to Macro-enabled file (.xslm)
Format all the buttons in the Home sheet into bevel
07/07/2023
biblioMagika® - v2.0
Convert the Basic Info Pivot Table from Horizontal to Vertical.
All of the measurements in the Basic Info. have been renamed in full.
Added productivity patterns of authors and Lotka's Law (still in Beta version)
Added data label and axis titles to column chart for single author vs multi-authors
New color scheme for the main menu and all the worksheets
Fixed "0" data for authors
Some "tips" from the callout boxes have been added and improved
29/04/2023
biblioMagika® - v1.9.0
Updated formula to read column "Cited by" due to the changes made by Scopus (New Version)
17/03/2023
biblioMagika® - v1.8.1
Reorganised the menu button
17/03/2023
biblioMagika® - v1.8
Added column Citable Year and Pub. Year Start for Source, Author, Affiliation and Country Analysis
Added column Citable Year for Year
Fixed m-index calculation.
Remove POP worksheet. All calculation in now will be based on Scopus New Version .csv file
Added calculation for C/Y
Added calculation for C/A
Added more calculation in Data(Year) to calculate the citation metrics for ALL the data.
Added citation metrics in basic info.
Removed Join workheet. All splitting and joining process will be focused on the biblioMagika®Split.xlsm file.
07/03/2023
biblioMagika® - v1.7
Fixed the issue with sum of h-index, g-index, m-index and citation sum with h-core. These values cannot be summed up.
Change the name from Joining Splitted Data into Joined Data. Data joined process should be done in the other biblioMagika®Split.xlsm file since the macros from this file have been removed.
Fixed the reading TP of affiliation from POP
05/03/2023
biblioMagika® - v1.60
Support for reading POP file
Added Top-20 Highly Cited Documents
Added Authorship Analysis: Number of Author(s) per Document and analysis of Single-author vs. Multi-authors
Added additional fields for Publication by Source Titles
Added Top 25 Most Productive Authors (Read from POP Worksheet)
Added Top 25 Most Productive Institutions (Read from POP Worksheet)
Added Total Documents by Country (Read from POP Worksheet)
Added Map by Continent
Re-arranged the columns in Split(Author) worksheet
Re-arranged the columns in Split(Affiliation) worksheet
Re-arranged the columns in Split(Country) worksheet
Re-arranged Home worksheet
Removed all macros
Changed the format from .xlsm to xlsx
04/03/2023 |
biblioMagika® - v1.50
Fixed the code due to higher resource usage error in Excel
Update the speed for joining the splitted file
03/03/2023
biblioMagika® - v1.30
Limit the row reading from 20000 to 10000 data only.
Fixed the some of the formula.
02/03/2023
biblioMagika® - v1.10
Main menu is created and released for public view.
Fixed the issue of slowingly splitting the author and affiliation field.
01/03/2023
biblioMagika® - v1.00
The first version is released. This version include the splitting and joining the author and affiliation field.
