- 文章信息
- 作者: kaiwu
- 点击数:1127
1.微软Excel的规划求解模块
微软Excel的规划求解模块来自frontline solver,求解问题的规模是受限制的,通常是200个决策变量、100个约束变量。
1.1加载Excel的规划求解模块
1.2使用Excel的规划求解模块
2.Frontline solver
微软Excel的规划求解模块来自frontline solver,商业版的frontline solver可以解决更大规模的问题:
- Analytic Solver Upgrade 可以最多求解最多2,000决策变量的线性问题、500 variables 决策变量的非线性问题,价格是995美元
- Analytic Solver Optimization 可以最多求解最多 8,000 决策变量的问题,价格是1995美元
- Solver engines 求解问题的规模几乎没有限制,不同版本价格存在差异,在3000到10795美元之间
3.what's best
what's best来自lindo公司,该公司著名的运筹学(管理科学软件)是lindo 和lingo,价格在245美元到12495美元之间,功能最强的版本(extended)求解问题的规模是没有限制的。
https://lindo.com/index.php/products/what-sbest-and-excel-optimization
中文简介:http://www.lindochina.com/wb01.html
商业版价格表:https://lindo.com/prices/CommercialPrices.pdf
教育版价格表:https://lindo.com/prices/EduPrices.pdf
4.OpenSolver
OpenSolver是一个开源的工具、完全免费,但是求解问题的规模没有限制。OpenSolver由新西兰奥克兰大学工程科学系(Engineering Science department, University of Auckland)的Andrew Mason及学生开发、维护;最近的开发由麻省理工学院的Jack Dunn提供。
5.其它开源的solver
运筹学(管理科学)软件AMPL提供了资源列表:开源的求解工具solver
https://ampl.com/products/solvers/open-source/
Linear solvers
These solvers all handle linear optimization problems in both continuous and integer variables. Their performance is not at the level of analogous commercial solvers, but can be competitive for problems that are not too large or difficult.
CBC 2.10.5 — from COIN-OR under the Eclipse Public License; available as source code and binaries for
32-bit Linux, 64-bit Linux, OS X, 32-bit Windows and 64-bit Windows.GLPK — from the GNU Project under the GNU General Public License; available as source code. Includes an open-source subset of AMPL features.
HiGHS — from GitHub under the MIT License; available as source code and as binaries from our Download Portal.
lp_solve — from SourceForge under the GNU Library General Public License; available as source code and binaries.
Nonlinear solvers
The solvers in this category seek solutions to problems involving smooth nonlinear functions such as powers, logs, and ratios. They differ in the algorithms that they offer, and hence in their effectiveness for different problem types. Due to the difficulty of nonlinear optimization, these solvers are effective with smaller problems than their linear counterparts.
Ipopt 3.12.13 — from COIN-OR under the Eclipse Public License; available as source code and binaries for 32-bit Linux, 64-bit Linux, OS X, 32-bit Windows and 64-bit Windows. Finds locally optimal solutions to continuous nonlinear problems, using an interior-point method.
Bonmin 1.8.8 — from COIN-OR under the Eclipse Public License; available as source code and binaries for 32-bit Linux, 64-bit Linux, OS X, 32-bit Windows and 64-bit Windows. Finds globally optimal solutions to convex nonlinear problems in continuous and discrete variables, and may be applied heuristically to nonconvex problems.
Couenne 0.5.8 — from COIN-OR under the Eclipse Public License; available as source code and binaries for 32-bit Linux, 64-bit Linux, OS X, 32-bit Windows and 64-bit Windows. Finds globally optimal solutions to nonlinear problems in continuous and discrete variables, regardless of convexity.
Constraint programming solvers
These solvers handle constraint programming problems usually in discrete variables. They support a wide variety of constraint types that may contain nonlinear and logical expressions. Constraint programming solvers can be more efficient than MIP solvers for some kinds of combinatorial optimization problems.
Gecode — under the MIT license; available as source code and binaries for 32-bit Linux, 64-bit Linux, OS X, 32-bit Windows and 64-bit Windows.
JaCoP — under the GNU Affero General Public License; available as source code and binaries for 32-bit Linux, 64-bit Linux, OS X, 32-bit Windows and 64-bit Windows.
NEOS solvers
The kestrel program allows using remote NEOS solvers with AMPL running on your local machine. Invoked in the same way as other AMPL solvers, Kestrel sends the problem to a solver running on one of the NEOS Server’s remote computers. The results from the NEOS Server are eventually returned through Kestrel to AMPL, where you can view and manipulate them locally in the usual way. Thus you get all the benefits of using AMPL environment, without having to first obtain and install each solver you want to try. Kestrel is provided free of charge and available for download from the Run AMPL on NEOS page. It is also included in all the demo packages.
- 文章信息
- 作者: kaiwu
- 点击数:1146
Given multiple files in a directory having different names, the task is to rename all those files
rename files, replace, find, os, for loop
# Python progaram to rename all file
# names in your directory# https://www.geeksforgeeks.org/rename-all-file-names-in-your-directory-using-python/# https://stackoverflow.com/questions/62668176/how-to-replace-characters-and-rename-multiple-filesimport osimport reos.chdir('D:\\chapters')print(os.getcwd())
for count, f in enumerate(os.listdir()):f_name, f_ext = os.path.splitext(f)# replace space with ""(remove spaces)new_name = f'{f_name.replace(" ", "")}{f_ext}'os.rename(f, new_name)
- 文章信息
- 作者: kaiwu
- 点击数:926
1.Dissertations & Theses (Proquest)
Theses and Dissertations Collection
https://about.proquest.com/en/dissertations/
2.PolyU Electronic Theses (Hongkong Polytechnic University)
https://theses.lib.polyu.edu.hk/
3.Theses and Dissertations, Hospitality and Tourism Management (Virginia Tech)
https://vtechworks.lib.vt.edu/handle/10919/82827
4.electronic theses and dissertations(ETD)
5.Dissertation examples
https://library.leeds.ac.uk/dissertation-examples
Listed below are some of the best examples of research projects and dissertations from undergraduate and taught postgraduate students at the University of Leeds. We have not been able to gather examples from all schools. The module requirements for research projects may have changed since these examples were written. Refer to your module guidelines to make sure that you address all of the current assessment criteria. Some of the examples below are only available to access on campus.
Jung, E. (2021). Slow Tourism: A Means-End Approach to the Motivations of Slow Travelers [Doctoral Dissertation, The University of Tennessee]. https://trace.tennessee.edu/utk_graddiss/6696
Pulkkinen, T. (2020). “Being Able to Be Who I Truly Am, That Is the Most Freeing Feeling Ever”: Experiences of Travel Behavior by Transgender Individuals [Master Thesis, University of Eastern Finland]. https://erepo.uef.fi/handle/123456789/23680
Mitsche, N. (2016). Digital Destination Promotion: Understanding and Maximizing the Use of Digital and Cultural Assets to Enhance Tourists’ Decision Making and Destination Marketing Strategies [Doctoral Dissertation, University of Sunderland.]. https://sure.sunderland.ac.uk/id/eprint/7105/
Lo, S. T. (2012). The Production and Consumption of Online Travel Photography [Doctoral Dissertation, The Hong Kong Polytechnic University]. https://theses.lib.polyu.edu.hk/handle/200/6828
Han, J. Y. (2005). The Relationships of Perceived Risk to Personal Factors, Knowledge of Destination, and Travel Purchase Decisions in International Leisure Travel [Doctoral Dissertation, University Libraries, Virginia Polytechnic Institute and State University]. https://vtechworks.lib.vt.edu/handle/10919/27410
- 文章信息
- 作者: kaiwu
- 点击数:628
- 2021 年 5 月,日本多摩动物园(Tama Zoological Park)开放了一个持续了半年的展览,展示了一个蚁群的死亡过程,这可能是全球唯一一个直接向观众展示死亡的动物园了。有很多关于这个展览的讨论,关于死亡,关于老龄化社会,关于开放社会等等。
大多数动物园的昆虫区如果想展示蚁群的话,通常都会选择切叶蚁(leaf-cutting ant )。这种蚂蚁的体态就是典型的蚂蚁的样子,但社群的复杂度却远远高出其他类型的蚁群,甚至被有些昆虫学家誉为“地球上仅次于人类的第二大复杂的社会动物”。在野外,典型的一窝能有几百万只个体,巢穴的体积大约和一个建筑面积 300 平米的独栋别墅差不多。
- 文章信息
- 作者: kaiwu
- 点击数:1639
批量修改(batch editing)zotero字段内容的参考网址:
https://www.zotero.org/support/dev/client_coding/javascript_api#batch_editing
导入zotero的书籍类型文献记录(ISBN,amazon等网站)的出版社信息可能比较混乱,如下图所示:
1.点击【tools】-->【Developer】-->【Run Javascript】
2.在弹出的窗口,复制、粘贴示例程序
https://www.zotero.org/support/dev/client_coding/javascript_api#batch_editing
Example: Item Field Changes
Edit the first three lines as necessary:
var fieldName = "publicationTitle"; var oldValue = "Foo"; var newValue = "Foo2"; var fieldID = Zotero.ItemFields.getID(fieldName); var s = new Zotero.Search(); s.libraryID = ZoteroPane.getSelectedLibraryID(); s.addCondition(fieldName, 'is', oldValue); var ids = await s.search(); if (!ids.length) { return "No items found"; } await Zotero.DB.executeTransaction(async function () { for (let id of ids) { let item = await Zotero.Items.getAsync(id); let mappedFieldID = Zotero.ItemFields.getFieldIDFromTypeAndBase(item.itemTypeID, fieldName); item.setField(mappedFieldID ? mappedFieldID : fieldID, newValue); await item.save(); } }); return ids.length + " item(s) updated";zotero数据库字段列表查看:
https://www.zotero.org/support/dev/client_coding/javascript_api/search_fields
These are the values of the fieldName column in the fields table from system.sql
1
url
21
accessDate
41
codeNumber
61
postType
81
documentNumber
2
rights
22
seriesTitle
42
artworkMedium
62
audioFileType
82
dateEnacted
3
series
23
seriesText
43
number
63
version
83
publicLawNumber
4
volume
24
seriesNumber
44
artworkSize
64
system
84
country
5
issue
25
institution
45
libraryCatalog
65
company
85
applicationNumber
6
edition
26
reportType
46
videoRecordingFormat
66
conferenceName
86
forumTitle
7
place
27
code
47
interviewMedium
67
encyclopediaTitle
87
episodeNumber
8
publisher
28
session
48
letterType
68
dictionaryTitle
88
blogTitle
9
pages
29
legislativeBody
49
manuscriptType
69
language
89
type
10
ISBN
30
history
50
mapType
70
programmingLanguage
90
medium
11
publicationTitle
31
reporter
51
scale
71
university
91
title
12
ISSN
32
court
52
thesisType
72
abstractNote
92
caseName
13
date
33
numberOfVolumes
53
websiteType
73
websiteTitle
93
nameOfAct
14
section
34
committee
54
audioRecordingFormat
74
reportNumber
94
subject
15
callNumber
35
assignee
55
label
75
billNumber
95
proceedingsTitle
16
archiveLocation
36
patentNumber
56
presentationType
76
codeVolume
96
bookTitle
17
distributor
37
priorityNumbers
57
meetingName
77
codePages
97
shortTitle
18
extra
38
issueDate
58
studio
78
dateDecided
98
docketNumber
19
journalAbbreviation
39
references
59
runningTime
79
reporterVolume
99
numPages
20
DOI
40
legalStatus
60
network
80
firstPage
100
programTitle
101
issuingAuthority
102
filingDate
103
genre
104
archive
3.修改示例程序的前3行
修改查找字段(fieldName)为【publicationTitle】
修改查找值(oldValue)为【Springer Netherlands】
修改替换值(newValue)为【Springer】
var fieldName = "publicationTitle";
var oldValue = "Springer Netherlands";
var newValue = "Springer";
var fieldID = Zotero.ItemFields.getID(fieldName);
var s = new Zotero.Search();
s.libraryID = ZoteroPane.getSelectedLibraryID();
s.addCondition(fieldName, 'is', oldValue);
var ids = await s.search();
if (!ids.length) {
return "No items found";
}
await Zotero.DB.executeTransaction(async function () {
for (let id of ids) {
let item = await Zotero.Items.getAsync(id);
let mappedFieldID = Zotero.ItemFields.getFieldIDFromTypeAndBase(item.itemTypeID, fieldName);
item.setField(mappedFieldID ? mappedFieldID : fieldID, newValue);
await item.save();
}
});
return ids.length + " item(s) updated";
4.点击【Run】按钮
运行结果显示:查找替换了12处