Science topic

Microsoft Office - Science topic

Explore the latest questions and answers in Microsoft Office, and find Microsoft Office experts.
Questions related to Microsoft Office
  • asked a question related to Microsoft Office
Question
3 answers
Hello Everyone,
I am sure most people have the same question on their minds. I already see some questions on ResearchGate but couldn't see the proper answer.
The question is: How do you people write papers on Linux? Mainly, what do you use for a citation?
LibreOffice and OpenOffice have the Mendeley plugin, however, both have compatibility issues with Microsoft Office. This creates a big problem with collaborative work. Regardless of the compatibility issues, both software is not easy to use, or at least not for people who have used Microsoft Office for decades.
I tried Google Docs, and it has a few citation plugins (ie. Paperpile) but again there are sometimes compatibility issues with Microsoft Office, plus, Google docs (writer) lacks most of the functions (ie. vertical text on tables).
I am currently using WPS office which is easy to use and fully compatible with Microsoft Office but there is no Mendeley (or other citation) plugin. It has an "Endnote" function, but I have to manually type the citation, which is torture.
So, do you have any suggestions rather than buy an Apple Mac or return to Windows?
Relevant answer
Answer
Again, how do you solve the compatibility problem between LibreOffice and Microsoft Office?
  • asked a question related to Microsoft Office
Question
5 answers
Mandatory needs emerging in education and training environments as a result of the COVID-19 pandemic have brought along new technological solutions. While some of them could help to solve the problems, the majority were insufficient. This is due to the fact that the needs are not fully met. Could MS-Office, designed as a videoconferencing tool with Moodle, a learning management system, solve this problem?
Relevant answer
Answer
It looks that there are plugins built inside Moodle for the Microsoft Team appl., Prof. Muhammet Yasar Ozden
However, I have not personal experience with it, please follow these external Moodle posts:
Best Regards.
  • asked a question related to Microsoft Office
Question
7 answers
In order to analyze daily yield of Solar PV , the master file needs to be split into smaller files. As Excel has limitation of number of rows, it is tough to load or extract the same. Hope there is a good solution or work around is available.
Thank you in advance.
Relevant answer
Answer
There are some free on-line services for splitting large files, why not to try with that... Next, I did a small Python recipe to split text file of any size into multiple chunks:
  • asked a question related to Microsoft Office
Question
8 answers
We have created a Venn diagram on MS Word and entered values into the main circles, but we have no way to enter values into the intersections. How do we go about this?
Relevant answer
Answer
Create a Venn diagram
  1. On the Insert tab, in the Illustrations group, click SmartArt.
  2. In the Choose a SmartArt Graphic gallery, click Relationship, click a Venn diagram layout (such as Basic Venn), and then click OK.
  • asked a question related to Microsoft Office
Question
14 answers
I am familiar with Microsoft Office Suite but didn't have a Microsoft Visio license. Is there any free alternative that can be used to draw flows and diagrams for research papers/articles?
I searched online for Visio alternatives, there are many online services, but they are not user friendly and flexible.
Note: I am using Microsoft Word to write my articles.
Relevant answer
Answer
Dear Hadi
Actually I like using draw.io
I have a list of build-in templates and tools for different aspects.
The main advantage is the ability to save the diagrams as pdf files.
  • asked a question related to Microsoft Office
Question
51 answers
We, scholars, are writing a lot. The language of science today is the English, however, for many of us, English is not our mother tongue. Even though we may be fluent in English. I found grammar check programmes/applications useful. Do you have recommendations about such apps? I am using MS Office grammar check (of course) and also I started to use Grammarly. Do you think there are better programmes (apps) or which are you using?
Thank you.
Relevant answer
Answer
I prefer to use Grammarly service...
  • asked a question related to Microsoft Office
Question
6 answers
Hi all,
When I used the baranyi and huang models to estimate the experimental enzyme activity data, when the experimental activity values reached a certain level, the models did not estimate the experimental data and failed the calculations. Microsoft Office program was used for calculations. What could be the reason? I would appreciate it if you would share your views and suggestions on this situation.
Regards,
mustafa
Relevant answer
Answer
Could you explain a bit more what you mean by "failed the calculations"?
There are several reasons why it may fail. One of them is that the Excel solver is not the most efficient method for parameter estimation. If that's the case, the use of the tools suggested by Wiaslan Figueiredo Martins would help.
A second possible reason is that the model is not suitable to describe your data. The Baranyi and Huang growth models are usually used for microbial growth, but you mention that you are studying enzyme activity. I am not familiar with that particular field, but if your data does not have a sigmoid shape, neither the Baranyi nor the Huang model will be able to describe the data.
A third reason could be parameter identifiability. It is possible that the model is suitable for your data, but the quality/quantity of your data is not enough to estimate every model parameter. A typical example is when you are trying to fit the model but your data did not reach the stationary phase. In that case, the parameter describing the carrying capacity (ymax in Baranyi) cannot be estimated.
Parameter identifiability is a rather complex topic. There is a very nice article by Vilaes et al. where they make a comprehensible description, describing common pitfalls and how to avoid them:
As a summary, before trying to just fit the model with the online tools, I would make sure that the model is suitable to describe the data and that your data is good enough to estimate the model.
Alberto
  • asked a question related to Microsoft Office
Question
3 answers
We are looking for highly motivated graduates with skills in experimental measurement, thermodynamic modeling, data analysis and writing, as well as keen attention to detail as related to research. The candidate should be available to start as soon as possible.
The candidate will be expected to work in a multidisciplinary environment, interacting with a large team of postgraduate students and researchers performing cutting-edge research that contributes to chemical process/product development and optimisation.
The details of the available positions are:
· 2 MSc. Eng. Students each with 2 year funding allowance
· 1 PhD with 3 year funding allowance
Minimum Requirements:
· For MSc.Eng (Chemical Engineering): M. Eng./B.Sc (Chemical Engineering) or Chemistry Honours with one (1)-year relevant work experience in a research environment.
· For PhD: MSc.Eng. in appropriate field
· A high level of competency in the use MS-Office software, Word, Excel, programming and drawing software such as CAD or Solid Edge.
For enquiries about the project and funding regarding this advert, please contact:
Prof. Paramespri Naidoo – naidoop18@ukzn.ac.za
Or Dr Saeideh Babaee – babaees@ukzn.ac.za
Dr Hamed Hashemi – hashemih@ukzn.ac.za
The applicant should include the following:
- A comprehensive CV;
- The names and contact details of two referees.
Relevant answer
Answer
Contact details pls
  • asked a question related to Microsoft Office
Question
2 answers
I have more than 7 experiences in statistical and epidemiological research which includes planning, management and monitoring of projects, developing research protocol, design of data structure, data management and analysis, quality assurance, graphical presentation of data and report writing. I am using statistical and data management software i.e. Stata, SPSS 17.0, Epi-info, Epi-Map, R3.2.1, MS Office, Excel.
Relevant answer
Answer
You are simply telling us your CV definetely but not a question.Thanks thou.
  • asked a question related to Microsoft Office
Question
4 answers
In the attached file i want compare K2 in production sheet with A4 TO A31 in data entry sheet, and return the vaue which is in next row in matched colunm.
for example in attached example. returned value shoud be 25.5.
i want to apply thid formula in D10 HIGHLIGHTED WITH RED PAINT.
KINDLY HELP.
Relevant answer
Answer
A fourth argument of "TRUE" sometimes helps with VLOOKUP because Excel can be very fussy about exact matches when numbers are stored as approximations.
  • asked a question related to Microsoft Office
Question
3 answers
As per my knowledge Vine can only be used for installing light weight applications like MS-Office
Relevant answer
Answer
You can download the latest version of Visual Studio for Linux from :
1. Download the .deb installer from the above link
2. Open terminal (Ctrl+Alt+T)
3. Navigate to the directory where you downloaded the .deb file. (Use cd command)
3. Use the following command to install (the version you download might be different or 32 bit (use the correct file name))
sudo dpkg -i code_1.19.1-1513676564_amd64.deb
4. Then enter this command (in case some dependencies are missing this will fix)
sudo apt-get install -f
  • asked a question related to Microsoft Office
Question
7 answers
Do you feel that computer science and information systems programs should also require professors to have professional certifications in addition to the normal publishing requirements for tenure or job acceptance?
Relevant answer
Answer
it can be considered for the people who are involved in practical classes or labs.
  • asked a question related to Microsoft Office
Question
2 answers
if possible please include the conceptual framework and questionnaires
Relevant answer
Answer
Hi Marife,
You can see this video for more details
Regards,
Sameh Mtibaa
  • asked a question related to Microsoft Office
Question
4 answers
The research is to describe the corrections made by the Microsoft Word Text Editor spellcheck .
What are the correction levels addopted? What rules are used in order to make the corrections? What types of errors are not detected or are corrected wrongly? Why these corrections of errors occur? What rule would have caused this error? Could you suggest me some researches on that line?
Relevant answer
Answer
dear researcher
A basic spell checker carries out the following processes:
It scans the text and extracts the words contained in it
It then compares each word with a known list of correctly spelled words (i.e. a dictionary). This might contain just a list of words, or it might also contain additional information, such as hyphenation points or lexical and grammatical attributes.
An additional step is a language-dependent algorithm for handling morphology. Even for a lightly inflected language like English, the spell-checker will need to consider different forms of the same word, such as plurals, verbal forms, contractions, andpossessives. For many other languages, such as those featuring agglutination and more complex declension and conjugation, this part of the process is more complicated.
different rules applied are
In-line Spell Checking
In-line Grammar Checking
Manual Spell and Grammar Checking
Regards
  • asked a question related to Microsoft Office
Question
3 answers
I have a pocket program project with an excel interface but i need to run GAMS behind it. It includes an optimization model.
Relevant answer
Answer
Yes, Sure. Attached is the link to McCarl GAMS User Guide where you can find an example related to transportation problem in which GAMS is being called from Excel and solves the problem in background.
  • asked a question related to Microsoft Office
Question
3 answers
Actually I know how to pop-up a message box through macro. But, I need help in displaying the message box in an interactive manner, like JQuery pop-ups used in websites. Could any one help me in creating the macro for displaying interactive cell on hover/ on click.
Relevant answer
Answer
Sure @Balamurugan, I made a sample for you, as you have to tell the user that a cell should contain time that is 7:00 or more.
I attached 2 numbered pictures of several screen captures.
  • asked a question related to Microsoft Office
Question
6 answers
I want to combine two properties which are related to each other in one figure. For that I need 2 vertical axis, one on the right side of the figure, and other on the left side. Did anyone one know how to do that? Both axis would have different numbers and units.
Relevant answer
Answer
In Excel you simply produce your chart and then right click on the data series you want to show on a second axis and then choose "format data series" and "secondary axis".
If you only want to show one line, then use  dummy data and set the line colour to "no color"
  • asked a question related to Microsoft Office
Question
6 answers
I have a genome sequence however, sequence is in microsoft word file and annotation is present in excel file. How can I convert/merge this information into genbank format.
(sequence is not submitted to any database)
Relevant answer
Answer
The simplest option may be a bit of a combination of the two answers above, that is something along the lines of the following:
  1. Open your sequence data in Word
  2. Choose to Save As, and select the drop down format option Plain text from the drop down menu. Now, your saved sequence will be in plain text format. We don't know what sequence  format it is in, but that might not be relevant.
  3. Navigate to http://www.ebi.ac.uk/Tools/sfc/readseq/ and upload your plain text sequence file with the Choose file button. Make sure that Input Format selection is set to Auto-detected.
  4. Convert this to GenBank, or any format that can be imported into the sequence editing software of your choice, that can also export to GenBank
  5. Depending on the sequence editing software you use, you may then be able to directly import the annotation data such that it is applied directly to your sequence
  6. Finally, you could export the annotated sequence from the sequence editing software in GenBank format.
  • asked a question related to Microsoft Office
Question
2 answers
I would like to know the implications on data security during information exchange while using wikis as compared to the Lync server.
Relevant answer
Answer
Simply stated wikis are wikis, Lync is a messenger with advanced collaboration scenarios. Wikis help you record and keep unstructured information, while Lync is a tools for text-based and VoIP based communication, that allows you to share a presentation or screen. Conversation history can be stored, but it will not give you the reading experience of wikis and vise versa. If you are searching for Microsoft's implementation of wiki - this is SharePoint - one of the site types available in SharePoint is corporate wiki.
  • asked a question related to Microsoft Office
Question
10 answers
For preparing a book, do you recommend the switching from Office to LATEX?
Note: the book's office version is prepared, but it seems that some issues like formulation and referencing is better in LaTex. Is this true?
Relevant answer
Answer
Unless the issues totally prevent you from finalizing your book for publication, I agree with Ben: at this stage converting the book from Word to LaTeX would be too long and complex.
However, for the future, LaTeX is a much better choice than Word for any scientific publication.
  • asked a question related to Microsoft Office
Question
16 answers
Can anybody suggest the shortcut keys for Merging & splitting the cell in MS word & MS Excel?
Relevant answer
Answer
Tejas,
- Just select the cells
- Press Alt + Enter key
If not worked, select the cells which needs to be merged and click “Merge & Center” option for the first time, and then the above shortcut will be enabled.
Hope it helps.
  • asked a question related to Microsoft Office
Question
39 answers
I am attempting to define exactly why (or if) MS office tools are inappropriate for professional engineering work. I would claim that for any professional work, in science and engineering, there are some basic functions that should be easy to work with in simple direct ways. Revision control, finding differences in data and documents and merging document edits all seem to be central to tracking and managing all documents. Data oriented tools should allow clear separation of process and data, and easy means of iterating and comparing the results over differing data sets. These operations have pretty questionable support in MS tools. Are these core requirements in your view? Are there other differences that are worth discussing?
Relevant answer
Answer
To Mark Haefner:
Just a note regarding engineering: the word is derived from the same root as 'genius', and the word 'engine' in English comes from the same root. In Latin languages what is called in English 'engine' is 'motor', or 'machine'. So it is quite confusing that in English the basic word 'engineer' means 'someone who operates engines'. The word 'ingineur' in French and similar words in the Latin languages are derived not from 'engine' but---as I indicated---from 'genius'. Today there is still confusion in English, but not in other languages. In France an 'ingineur' does not operate a locomotive. It is unclear to me why in English (in particular in UK English) the word engineer is common to mechanics and highly skilled engineers. But btw, in the times of Da Vinci someone who studied science was an engineer of constructions and machines as well.