资料来源: https://zhuanlan.zhihu.com/p/109005616

德克萨斯大学达拉斯分校(The University of Texas at Dallas, UTD)的纳文·金达尔管理学院创建了一个数据库,用于跟踪24种主要商业期刊上的出版物。该数据库包含1990年以来在这些期刊上发表的论文和作者单位信息,用于提供1990年以来前100名商学院排名。

  1. The Accounting Review
  2. Journal of Accounting and Economics
  3. Journal of Accounting Research
  4. Journal of Finance
  5. Journal of Financial Economics
  6. The Review of Financial Studies
  7. Information Systems Research
  8. Journal on Computing
  9. MIS Quarterly
  10. Journal of Consumer Research
  11. Journal of Marketing
  12. Journal of Marketing Research
  13. Marketing Science
  14. Management Science
  15. Operations Research
  16. Journal of Operations Management
  17. Manufacturing and Service Operations Management
  18. Production and Operations Management
  19. Academy of Management Journal
  20. Academy of Management Review
  21. Administrative Science Quarterly
  22. Organization Science
  23. Journal of International Business Studies
  24. Strategic Management Journal

 The UTD Top 100 Business School Research Rankings

https://jsom.utdallas.edu/the-utd-top-100-business-school-research-rankings/

utd100

Research Rankings Overview

The UT Dallas’ Naveen Jindal School of Management has created a database to track publications in 24 leading business journals. The database contains titles and author affiliations of papers published in these journals since 1990. The information in the database is used to provide the top 100 business school rankings since 1990 based on the total contributions of faculty.

Additionally, the database can also be searched by:

  • Any journal or combination of journals between the time period 1990 to date to get a ranking of schools
  • School name to see a list of publications by a school for any combination of journals and time period between 1990 to date
  • Author name to see a list of publications by an author for any combination of journals and time period between 1990 to date
  • Key phrase in article name to see a list of publications containing that phrase for any combination of journals and time period between 1990 to date

The Jindal School of Management maintains and keeps this website current to provide timely data on research productivity in leading research journals across major disciplines in business schools. The school has worked hard to ensure data integrity, but as with any project of this type where the affiliation data is not always clear, some errors may exist. If you spot an error, please send us the corrections at 该邮件地址已受到反垃圾邮件插件保护。要显示它需要在浏览器中启用 JavaScript。.

 

 
1.国家数据
 

2.中国城市建设统计年鉴

中国城市建设统计年鉴2020 https://navi.cnki.net/knavi/yearbooks/YCJTJ/detail

数据下载 http://mohurd.gov.cn/xytj/tjzljsxytjgb/jstjnj/index.html

全国超过100万人口的城市排名(中国城市建设统计年鉴2019)https://baijiahao.baidu.com/s?id=1667999584142535385

 

3.人民网博文

人民网. (2021, September 23). “七人普”数据:我国超大城市共7个 城区常住人口超千万. http://finance.people.com.cn/n1/2021/0923/c1004-32234160.html
 
4.2020第七次全国人口普查主要数据
国务院第七次全国人口普查领导小组办公室. (2021). 2020第七次全国人口普查主要数据. 中国统计出版社.
http://www.stats.gov.cn/tjsj/pcsj/rkpc/d7c/202111/P020211126523667366751.pdf

urban_population
Search:
(21 Records)

 城市   人口数   城区人口 
上海24871987
北京21891775
重庆32051744
深圳17491744
广州18681488
成都20941334
天津13871093
武汉1245995
东莞1047956
西安1218928
杭州1194874
佛山950854
南京931791
沈阳907707
青岛1007601
济南920588
长沙1005555
哈尔滨1001550
郑州1260534
昆明846534
大连745521
Page 1 of 1
  
 
 
资料来源:人民网. (2021, September 23). “七人普”数据:我国超大城市共7个 城区常住人口超千万. http://finance.people.com.cn/n1/2021/0923/c1004-32234160.html
 

 
 
 
 
 
 
 
 

 

Top 20 Journals on tourism from google scholar

logo Google Scholar

http://kaiwu.city/index.php/237-gs-journal-tourism

 

SSCI journals

logo Clarivate Analytics

http://kaiwu.city/index.php/5-sscijournal

 

Journals on service management

http://kaiwu.city/index.php/7-smjournal

 

collections on tourism, hospitality,sport and leisure

http://kaiwu.city/index.php/6-journalcategory

 


dufe logo small

Journal list from DUFE

 

kreading_note_copy
Search:
Sort By: ASC DESC
kdate:
kresource:Hung, K., & Petrick, J. F. (2010). Developing a Measurement Scale for Constraints to Cruising. Annals of Tourism Research, 37(1), 206–228. https://doi.org/10.1016/j.annals.2009.09.002
knote:1 Intrapersonal constraints: C01 I can’t cruise because I have poor health C02 I don’t cruise because I have claustrophobia C03 I have sea-sickness/motion-sickness C04 I don’t cruise because my spouse/partner has poor health C05 I have a fear of the water/ocean C06 I need a special diet that is not available on a cruise C07 I worry about security on cruise ships 2 Interpersonal constraints: C08 I might not like my dinner companions on a cruise C09 I have no companion to go on a cruise wit C10 I might be lonely on a cruise 3 Structural constraints: C11 It’s difficult for me to find time to cruise C12 I don’t cruise due to my work responsibilities C13 I don’t cruise because I have too many family obligations C14 Cruising is too expensive 4 Not an option: C15 There are many other travel alternatives that C16 I’d like to do before cruising C17 I am not interested in cruising C18 My family/friends do not cruise. C19 Cruising never occur to me as a travel option C20 Cruising is not my family’s lifestyle.
kresearchnote:this is a measurement of tourism constraints including 4 dimensions with 20 items this is in the context of cruising. 旅游限制理论,量表scale ,measurement
ktitle:
ktype:
kcourse:
kdate:
kresource:叶小瑜, & 李海. (2016). 中国休闲体育研究进展及热点评析. 上海体育学院学报, 40(06), 37–44.
knote:总结了中国体育休闲的4个热门领域:(1)特定群体体育休闲参与;(2)休闲体育产业;(3)体育旅游;(4)休闲体育管理 ------------ 未来:1适应国家政策需要;2中国特色理论过框架体系;3多学科理论与研究方法融合 -------- 休闲体育的界定:
kresearchnote:research note
ktitle:
ktype:
kcourse:
kdate:
kresource:谭曙辉, 刘成, & 张河清. (2009). 体育旅游研究的国内外比较分析. 上海体育学院学报, 33(04), 54–58.
knote:note
kresearchnote:5页,有国内外定义的的比较
ktitle:
ktype:
kcourse:
Page 1 of 9
<<First <Prev 1 2 3 4 5 Next> Last>>

 

journals list from DUFE2018
Search:
Records per Page:
(1038 Records)

# tid   cid   Rank   Journal   Area   TH 
1582369CScandinavian Journal of Hospitality and TourismManagementtourism and hospitality
2551338CJournal of Travel and Tourism MarketingManagementtourism and hospitality
3506293CJournal of Hospitality and Tourism ResearchManagementtourism and hospitality
4469256CInternational Journal of Tourism ResearchManagementtourism and hospitality
5392179CAsia Pacific Journal of Tourism ResearchManagementtourism and hospitality
6374161BTourism ManagementManagementtourism and hospitality
7350137BJournal of Sustainable TourismManagementtourism and hospitality
829279BCurrent Issues in TourismManagementtourism and hospitality
925946AJournal of Travel ResearchManagementtourism and hospitality
1024330AATR Annals of Tourism ResearchManagementtourism and hospitality
11544331CJournal of Sport ManagementManagementsport
12543330CJournal of Sport and Health ScienceManagementsport
13542329CJournal of Sport and Exercise PsychologyManagementsport
14473260CInternational Review of Sport and Exercise PsychologyManagementsport
15428215CEuropean Sport Management QuarterlyManagementsport
1623118TopManufacturing and Service Operations ManagementManagementservice management
17585372CService Industries JournalManagementservice management
18539326CJournal of Services MarketingManagementservice management
19538325CJournal of Service ManagementManagementservice management
20537324CJournal of Retailing and Consumer ServicesManagementservice management
21466253CInternational Journal of Service Industry ManagementManagementservice management
2207676BHealth Services ResearchEconomicsservice management
2309191BJournal of Financial Services ResearchEconomicsservice management
24348135BJournal of Service ResearchManagementservice management
25424211CE-Service JournalManagementservice management
26553340CLeisure SciencesManagementleisure
27554341CLeisure StudiesManagementleisure
28518305CJournal of Leisure ResearchManagementleisure
29331118BJournal of Economics and Management StrategyManagement
30342129BJournal of Optimization Theory and ApplicationsManagement
31341128BJournal of Operational Research SocietyManagement
32340127BJournal of Occupational Health PsychologyManagement
33339126BJournal of Occupational and Organizational PsychologyManagement
34338125BJournal of Management Accounting ResearchManagement
35337124BJournal of International MarketingManagement
36336123BJournal of International Financial Management and AccountingManagement
37335122BJournal of International Accounting ResearchManagement
38334121BJournal of Interactive MarketingManagement
39333120BJournal of European Social PolicyManagement
40332119BJournal of European Public PolicyManagement
41324111BJournal of Accounting LiteratureManagement
42318105BInternational Journal of Management ReviewsManagement
43319106BInternational Journal of Production EconomicsManagement
44320107BInternational Journal of Production ResearchManagement
45321108BInternational Journal of Project ManagementManagement
46322109BInternational Marketing ReviewManagement
47323110BJournal of Accounting and Public PolicyManagement
48329116BJournal of Business Finance and AccountingManagement
49328115BJournal of American Taxation Association (Taxation session of AAA)Management
50327114BJournal of Advertising ResearchManagement
Page 1 of 21
<<First <Prev Next> Last>>
Query took 4.14 miliseconds

 

 

 

https://simple.wikipedia.org/wiki/Spreadsheet

Spreadsheet is a computer program that imitates a paper worksheet. It shows a large sheet (like a sheet of paper) that has many cells in a grid of rows and columns. Users can put words or numbers into the cells, to make headings and store information (usually numbers). You can also move the grid lines around so that some cells are bigger than others, and change the color or size of text/font, the same way font/text is changed in a word processor. You can even put pictures in the worksheets, make multiple pages, and print out their results on real paper.

https://thedatalabs.org/wp-content/uploads/Excel/IntroductionToExcel/Infographics.png

Infographics spreadsheet


software

Microsoft Excel

https://www.microsoft.com/en-us/microsoft-365/excel

Apple numbers

https://www.apple.com/numbers/

Google sheets

https://www.google.com/sheets/about/

zoho sheet

https://www.zoho.com/sheet/

liboffice

https://www.libreoffice.org/

openoffice

http://www.openoffice.org/

 


WPS(金山文档)

https://drive.wps.cn/ 

https://docs.wps.cn

https://www.wps.cn/

腾讯文档

https://docs.qq.com

腾讯office

http://office.qq.com/

飞书文档

https://docs.feishu.cn/

石墨文档

https://shimo.im

一起写

https://yiqixie.com/

 


 books on spreadsheet

 

DUFE journals in PDF format

http://kaiwu.city/index.php/downloads?task=download.send&id=6&catid=2&m=0

 

how to show the developer tab(Excel VBA)

https://docs.microsoft.com/en-us/visualstudio/vsto/how-to-show-the-developer-tab-on-the-ribbon?view=vs-2019

Getting started with VBA in Office

https://docs.microsoft.com/en-us/office/vba/library-reference/concepts/getting-started-with-vba-in-office

 


 Excel VBA, replace,autofit,for loop,cstr,delete row,save,last row

 

VBA DUFE journals

 


Public Sub dufe_journals()

 

'merge 53 sheets

For i = 1 To 53
    sheet_start_row = 1 + 20 * (i - 1)
    sheet_name = "Sheet" & CStr(i)

    Sheets(sheet_name).Select
    Range("A1:E20").Select
    Selection.Copy

    Sheets("journals").Select
    Range("A" & CStr(sheet_start_row)).Select
    ActiveSheet.Paste
Next i

 

' get the row number of last row in the dataset
last_row = Cells(Rows.Count, 1).End(xlUp).Row

 

' replace alt+enter with space
For m = 1 To 5
    For n = 1 To last_row
        'Chr(10) is alt + enter
        'Chr(32) is space
        'https://docs.microsoft.com/en-us/office/vba/Language/Reference/User-Interface-Help/character-set-0127

        Cells(n, m).Select
        ActiveCell.Replace Chr(10), Chr(32), xlPart, xlByColumns
    Next n
Next m

 

'Auto Adjust the Column Width.
For m = 1 To 5
    Columns(m).AutoFit
Next m

 

'Auto Adjust the Row Height.
For n = 1 To last_row
    Rows(n).AutoFit
Next n

 

'delete row 1
Rows("1:1").Select
Selection.Delete Shift:=xlUp

 

'save the workbook
ActiveWorkbook.Save

 

End Sub