When you write a summary, 10-20 references fell to manage, at a glance. How to organize and manage 100-200 articles? How can I save myself? The experience is summarized, I hope to have a little bit for you. If you have better communication.
A large number of references - use Excel to organize
The documentation such as a summary is essential, and more than ten parties will be more likely to be, if hundreds of servings, even two or three hundred copies, it is not so easy. Recently, a summary of more than 2,40 cases of reference is a lot of thought, thinking about some "skills" may have some significance, so write comes from the right to throw the jade.
Before Writing, the reference literature of the case must be given to a number each time, and the title is based on this number. However, due to the different retrieval time or search mode, the same document gives 2 to 3 numbers, so "28" and "208", "69" appear in writing, "but in I didn't know when writing references). For such a problem, the application Excel can be solved well.
1 After the writing is completed, determine that all documents no longer decrease, and the referenced literature numbers and document are correct, and do one by one. 218EMUCH.NETULZW11Y2GEE82 What is duplicate literature in this numerous reference. The method of using Excel is to copy the title of the old number to Excel, then copy the first author to column, then sort the first column, similar or the same author is row together, so Quickly identify which is repeated literature. For these documents with repeat numbers, the "=" is used to make the upper mark, ie "28" = "208" = "69". It is not simply deleted the original number, which will cause confusion.
3 Put all the citrics numbers all in the order in the document, and the draft page is located, and the collected citroen numbers are entered into the other Excel.
4 Reserved as the original order (ie, the order of just coplicity) in Excel, and then copy this order to Sheet 2, sort, and it can be found that there is a "heavy" (ie there is "25" on page 2, On page 3, there is "25"), then copy the heavy number, to the "Find" function in Sheet 1 to find the heavy sign "25" and then delete the heavy mark forward.
5 After the weight is removed, copy it to Sheet 3 to reorder it, and find that there is no heavy sign, set.
6 In Sheet 1 (after deleting the weight), press the new number 1, 2, 3 ....... (for the repetitive document that has been marked no longer gives new numbers)
7 Copy Sheet 1 (3 columns: Draft page number, old number, new number), and print it in three columns, it can be changed to the new number in the draft. Work is completed.
So sorted, both significantly improved work efficiency and accuracy, and reduced the "unpleasant" troubles. When you encounter a lot of literature, you may wish to try it.
http://emch.net
