Microsoft Office Excel - Science topic

Hi, I am using the QCAmap for the very first time on my thesis. The excel files came out from the codings are almost unreadable due to its squeezy formats. There are considerable amount of them in my project. Can anyone suggest an efficient way to organise them?

Thank you very much in advance!

Are you aware of any possible link between Aspen Adsorption and Matlab? I'm currently modelling Hydrogen separation from Coke oven gases with Aspen Adsorption, but would like to add a subsequent Matlab model to it.

It there a direct way? Is it possible to export the Adsorption model into Aspen Plus and achieve a interaction in that way? (I know a link between Aspen Plus and Matlab is possible (either via excel or direct (https://uk.mathworks.com/matlabcentral/fileexchange/69464-aspen-plus-matlab-link))

Any guidance would be welcome.

regards,

Sjoerd

Hi,

I need to create individual rarefaction curves for my microbial ecology data (86 samples with several thousand OTUs each). How do I do this in Primer 7 (or Excel)?

Thanks,

Catharina

I have collected data from the field in consecutive days. I have those data in excel how can i calculate the exact day of 75% seed germination using any formula.

I have to classify some rocks using their modal composition, but no point counter in my disposal, that's why I would like to know if some one may help me with any Excel sheet or reliable application which may permit me to determine their modal composition using their whole rock chemical composition?

Thanks

Hello

I have two questions:

1. Can I use more than one method for filling the missing values? Like moving averages, and imputing mean where moving averages didn't work?

2. Are the methods for treating missing data in panel data same like any other? Can I use 2 period moving averages if when I plot it on excel '2 period moving averages' is the best and closest representation of my available datapoints?

Thanks.

I am working in a review on a topic and I want to use Research gate (among others) as data base

Dear Experts,

I need your guidance on the invariance test performed via AMOS. My friend is comparing two groups, A and B. Their Model fits are excellent, less than 3. CFI is 0.98 for both groups. RMSEA group A is 0.040, and group B is 0.038. All factor loadings are above 0.8 for both groups, but there is a huge chi-square difference of about 400+ between constrained and unconstrained models. The sample size is large 1600+. I need your guidance to resolve this issue in order to establish the invariance between the two groups. Your expert opinion will be highly appreciated. Thank you so much

I am recommending the incredible work of my editor, Paulo Oliveira, Chief Editor at Poe Publishing and PhD Publishing.

Dear Researchers,

The PhD Publishing imprint specializes in releasing high-impact academic books renowned for their exceptional quality in print. Our rigorous selection, editing, and printing processes ensure excellence at every step.

We are thrilled to extend an invitation to you to consider publishing your research with us at PhD Publishing. As a platform dedicated to academic excellence, we continuously seek innovative and high-quality work to share with the global academic community.

Our editorial team is committed to providing a transparent, fair, and rigorous publishing process, ensuring that your research is presented in the best possible light. Additionally, we offer personalized support and guidance at every stage of the publication process.

By choosing to publish with us, you not only disseminate your findings to the world but also join a community of dedicated scholars striving to advance knowledge in diverse fields.

We eagerly look forward to receiving your contributions and collaborating together to broaden the horizons of knowledge.

Do you have a unique project

with specific needs?

Contact Us:

+55 (61) 3247-3382

Warm regards,

Paulo Oliveira

PhD Publishing

Hello colleagues,

I am looking for a validated Excel sheet for the recovery calculation of a standard addition in a GC analysis. This should be able to take into account different sample weights.

Does anyone work with the Chromeleon software and know how to calculate this using one-point standard addition?

I have data consisting of two trends over time.

For example, the GDP and net immigration figures of the UK, from 1950-2020 (not the real data).

I can plot the 2 trend lines on the same graph and visually examine if they look like they correlate over time. However, is there any way to examine if they statistically correlate over time?

Note, this need to be a simple analysis that one can do in MS excel of other free software (e.g. JASP), as it is for a student.

I am planning to pursue my Ph.D. study in Healthcare management and want to focus during my study on Operational excellence and Organizational performance in Hospitals.

Do you have any recommendations for both variables' tools, theory, and components? Also if you have a suggestion on what aspect I should focus on or approach to follow?

Why Indians are so distinguished in physicists and mathematicians?

The answer to this question has many similarities with a previous article: Why do Russians excel so much in mathematics and physics? [September 2020.]

*In general, there are two different ways to think, one is Western: speed kills strength, while the Eastern: strength kills speed. Both sentences are correct but only under different conditions.

We suppose that:

the study and research of physics and mathematics belong to the second.

*It is worth mention Albert Einstein's quote: "Imagination is more important than knowledge", David Hilbert citing the researcher's resignation: "Well, he didn't have enough imagination to become a mathematician"

*Here we could say that chess sport games are an interconnected thing:

imagination is the main factor common to mathematics, physics and chess.

Imagination in Indian chess is a unique, strong and creative field of imagination. Almost every chess player knows well how deep and difficult the Indian chess games of kings and queens are.

**In short, it is an integral collective process of education, training and creative thinking.

Hi,

I am carrying out a very basic undergraduate research study with no stats teaching on the course (medical degree) as a result I am floundering and wonder if anyone could help.

I am using two pre-validated Likert scales looking at the relationship of Emotional Intelligence and Resilience I have put this into a scatterplot in Excel to which it looks like a positively significant result (graph attached) My Pearson's correlation coefficient between the two is coming out at 0.797 would that be r=0.79? and from what I read this is significantly significant?

However when I attempt to work out the P-value it shows as 3.419 which is not.

Any assistance or thoughts on what I am doing wrong would be of great help.

Many Thanks :)

Hi fellows,

I am looking for two co-authors for a research project (50% done) that will be submitted to The 2024 15th International Conference on E-business, Management, and Economics (ICEME 2024, https://www.iceme.org/index.html). It is an excellent opportunity to come and visit China.

The topic's focus is Multinational Corporations (MCs), and the offer is valid until February 20th (11:59 pm, China time).

is there an Excel formula to calculate depth of the mixed layer using seawater density profile?

How can you establish an environment of academic excellence in your school?

I handle large amounts of data on chemical substances. There is unique information for each chemical, but there is repetitive information that is required to be prepared and processed.

I do not have much knowledge of coding, automated functions in Excel, or even AI tools for these matters. I only know one Macro feature in Excel but that is all I know. The pace and amount of data is just increasing over the months. So, I wonder where to start leveraging existing tools that I can use for such tasks.

Hi all,

I am using the RoB2 tool on Excel for the first time today, and have been faced with some issues. When filling in each domain, the algorithm has successfully calculated the domain risk of bias. However, when I go to calculate the overall risk of bias, the algorithm does not do anything. I have made sure that macros are enabled. Any suggestions on how to resolve this issue would be much appreciated.

Best,

Sasha

How do you demonstrate research excellence across disciplines and domains?

Hello, I received just my cyclic voltammogram file but I can't view or read it. Is there someone or anything that can view a .nox file? I already tried several converters but failed to successfully convert my file. If you know something about analyzing CV data, it would be very much appreciated

Best regards,

Flynne D.

I would want to perform calculations for Community temporal stability and community asynchrony using Excel, and I am seeking help on how to do so. Thank you in advance.

Please assist me. I greatly appreciate your thoughts, and they may be useful for my upcoming research.Thank you so much

I want you to help me in one problemin excel file

I make a theisis in the field

Respected Sir, I am Dr. Muhammad Imran, Ph.D Forestry. I have gone through your Research Paper entitled "A Nonlinear Mixed-Effects Height-Diameter Model with Interaction Effects of Stand Density and Site Index for Larix olgensis in Northeast China" which gave much insight and innovative ideas supported by various equations and models, I am highly impressed to see much more information in this manuscript. Dear Sir, I will be very thankful for your kind honor if you kindly provide me with the Raw Excel sheets of all the models and equations used in this research paper. Further, it will help me in my research. Hope to hear from you soon.

I shall be thankful to you for this act of kindness.

Regards,

Dr. Muhammad Imran Mahmood

Ph.D. Forest and Natural Resources Management

Dear Colleagues

I encountered a Runtime error 13/mismatch error while working with Comprehensive Meta-analysis (CMA) software. I've tried the suggested solutions found in a Google search and I could not solve my problem because they are mostly about the Excel software. Has anyone ever encountered this error in CMA software? What have you done to fix it?

I uninstalled the software once, but there is still an error.

Thank you for your support

I have to use PLA as a polymer for preparing PNPs containing drug that shows an excellent solubility in chloroform. I need to know if PLA is soluble in chloroform and under what conditions.

There are many articles published on quantum image encryption, either based on chaos applications or any other techniques. Still, for the diffusion process, every author used quantum XOR using the CNOT or CCNOT gate, and I have done the same thing using a newly defined chaotic map. Still, I have one doubt whenever we test or encrypted image with NPCR and UACI test, the test results come very low even not close to 99.60 and 33.46. So, my question is how authors got the excellent NCR and UACI results. Please, can anyone help me with this issue?

I calculated my ms thesis data by SPSS, I think excel is difficult.

Hi everyone

i would like know , how i can add module (openpyxl: module for read or write excel file ) in python for script on Abaqus ( i use python 2.7 version for abaqus 6.14)

thanks

Sincere greetings  My academic English writing is excellent. I desired to join several active groups within my field. My concentration is in molecular genetics. But I was unable to locate any. I would appreciate it if you could help me join scientific groups that study cancer and non-coding RNAs. Please inform me if a professor needs a remote colleague for paraphrasing and academic editing, especially in Germany. My affiliation will be the host affiliation.

As I am very creative and punctual, I will rewrite very soon.

I am ready for a test on paraphrasing a paragraph. Best wishes

There are many articles published on quantum image encryption, either based on chaos applications or any other techniques. Still, for the diffusion process, every author used quantum XOR using the CNOT or CCNOT gate, and I have done the same thing using a newly defined chaotic map. Still, I have one doubt whenever we test or encrypted image with NPCR and UACI test, the test results come very low even not close to 99.60 and 33.46. So, my question is how authors got the excellent NCR and UACI results. Please, can anyone help me with this issue?

Dear Colleagues,

I'm facing some issues trying to import accident data to PTV Visum. I would greatly appreciate your help.

QFD

Actually I tried both and the values were highly variable.

Dear Tech supports,

My school asked me to do the (qualitative) systematic literature review.

I want to search my journal articles via the ResearchGate database.

How can I transfer my search results to Excel to remove duplicates?

How can I set my criteria before my search?

How can I know the numbers of my results?

Your help is much appreciated.

Sincerely,

Lillian Chang

Network Pharmacology

hello,

is there a solution or code for exporting the min and max values of stress and strain and displacement from multiple .odb files saved in the directory and exporting data in an Excel file?

when I use excelutilities to export to excel a message appears writing data in excel file failed

Looking to use VosViewer. It rejects my csv file. YouTube said to change csv to csv-ms-dos but my Excel does not offer that option. What should I do?

It is very often that practitioners ask this question.

In reality there is not a 'best' method; probably it is better to ask about the 'most appropriate' method.

However, the most important aspect to consider is what the problem or scenario characteristics are, and from there choose the method, that best match them. It is just common sense.

It is easy to understand that a practitioner can apply a certain method

which is for instance the most used. However, if this method can't model a scenario as much close as possible, the result obtained is irrelevant and false, because it will be solving a problem that has no relation with the real scenario.

Based on the bold text, I developed a simple tool that can help the practitioner. It is not guarantee that the selected method replicates in full a certain scenario, but it will give the most close selection, and very important, gives as way to justify that selection

There are two parts labeled 300a and 300b. The first explains the procedure, while the second provides the tool in Excel for the practitioner to work, and without any calculation.

The additional advantage, is that the practitioner can make as many tests as wish, and that the characteristics for each scenario can be saved, and therefore it is easy to see in the future why a certain result was achieved

Hello RG members, I am using Design Expert 11 to estimate some results, however, while I'm exporting the 3D surface graphs data into excel, the file is saving but without data inside and 0 kb size.

Meanwhile exporting the effects like Pareto Diagram data, and model diagnostic graphs data into .csv through File -> Export to file enables to save the data even into raw form.

But, this method is not applicable for exporting 3D surface graphs data.

Does anyone know the solution or have tackled the same issue with some add-in plugs???

Thanks for sharing your opinions.

I'm in need of guidance regarding the conversion of my initial ICP-OES results, which were reported in mg/L, I conducted a dilution procedure on a 26.0 mg sample using a 1:3 mixture of nitric and hydrochloric acid, resulting in a total dilution volume of 0.025 dm^3.

My current data is in mg/L and is stored in an Excel spreadsheet. Despite my efforts to calculate the wt%, I'm still facing issues and would greatly appreciate assistance from anyone who can provide guidance on achieving accurate percentage conversions.

I am working on hydrogeochemical appraisal of an area. Chadha diagram plots of the samples indicate a base exchange and recent recharge scenario. I want to confirm this using a Sulin's diagram to show whether it is shallow meteoric or deep meteoric.

Hi! Normally we process our PCR results for fold change in Excel by calculating delta CT, delta delta CT and finally 2^-delta delta CT. My question is, can it be done in Graphpad Prism in a simple way. If yes then how can it be done?

Hello guys

I would like to know if there ir any tool, like excel macro, for evaluate the risk of bias by Newcastle Ottawa Scale.

Regards everyone

Although I am familiar with GPT excel sheets, I couldn't find the Gt-Hbl barometer there. There are no more recent models OPX CPX barometer models.

It would be much beneficial if someone help me.

Regards, and many thanks

Rishabh

I am pleased to share with you a comprehensive list of esteemed book editorials for call for chapters from renowned publishers including Taylor and Francis, IGI Global, IET Press, Elsevier, De Gruyter, Wiley Scrivener, and Apple Academic Press. As an editor associated with these reputable publishers, with these books, I take great pride in curating impactful publications that contribute to the advancement of knowledge in various domains and audience. In addition to providing the list of editorial members who will oversee the development of each book project, I also include important information such as submission deadlines and manuscript submission links via email. Authors who submit their chapters will be entitled to receive a copy of the final hardbound publication which will be made available both online and offline in leading bookstores and university libraries. Please note that these editorial lists are dynamic entities that undergo regular updates. We strive for excellence throughout the entire publishing process by ensuring rigorous edits and modifications are made based on expert feedback received from reviewers. It is important to acknowledge that after chapter submissions have been collected for each book project – an update we promptly communicate with authors – it typically takes approximately three months for our dedicated team at the publishing houses to complete the editorial print process before circulation. This timeline accounts for necessary revisions and refinements required during production stages. We look forward to receiving your valuable contributions towards shaping these books into influential scholarly works within your respective fields. Together, let us embark on this journey of knowledge creation while upholding high standards of academic excellence and University faculties and researchers from different fields will be benefitted from publishing their chapters with the book editorials.

Amer Salih / Iraq

Hello everyone. Could someone please tell me how or where I can get the following Excel spreadsheet programs:

1) (FC–AFC–FCA and mixing modeler: A Microsofts Excel & spreadsheet program for geochemical modeling, of Yalcın Ersoy, Cahit Helvacı).

2) (AFC-Modeler: a Microsoft® Excel© workbook program for modelling, of Mehmet KESKİN).

3) (PETROMODELER (Petrological Modeler): a Microsoft® Excel© spreadsheet program for modeling melting, of Emrah Yalçın ERSOY).

I will really appreciate any help, thanks.

Can I estimate pore pressure, fracture gradient and mud weight window by using only excel sheet??

@microsoft office

@fracture

@reservoir

@Excel

Hi,

How to convert excel formula into matlab code?

The intention is that data specific to a person should be entered/edited by only him/her. Others should not be able to edit or delete the data when online excel sheet is shared to everyone in an organization.

Hello everyone

I am in an urgent requirement of excel sheet for data analysis. My experimental design is factorial RBD with single extra control. First factor has two levels and second factor has four levels. Anyone with the excel sheet for the same, please contact. Will be grateful for the help.

I mistakenly (I still don't know how it happened) changed the password of my protected Excel document.

Is there any assistance I can get? If there is someone who can help I can send the Excel file to him or her.

Thanks

Hi,

I cannot find the right answer online but can we use power map excel maps for publication purposes? Thanks

This type of study is very interesting for me.

I see that no published papers provide in supplementary materials full Excel data on crab carapace size-weight, such as: Weight, length, width, male, female etc…

I work on empirical modeling, and I want to collaborate with any Colleague to extend any relationship or to suggest novel empirical expressions, etc.

How can I get full Excel data of any published paper on crab carapace size-weight for each gender?

Any new finding will be shared with who provide me data.

Thank you in advance.

Can I depend on excel sheet only to apply geomechanical estimations for the subsurface reservoir?

When I try to upload data from an Excel file to SPSS as usual, it says that the file contains no data and that the command has been stopped. I have searched the internet for an answer to why this occurs, but I haven't found a solution. Has anyone come across this before and can advise?

I was trying to generate a figure based on the concentration vs absorbance. I have the absorbance from 4 fractions. All the values are numeric. I was trying to convert it into factor but it appeared as error like this -

data = read_excel("df.xlsx", StringsAsFactors = TRUE)

The output was

Error in read_excel("df.xlsx", StringsAsFactors = TRUE) : unused argument (StringsAsFactors = TRUE)

My questions are-

1. Do I need to convert the numeric value as factor for plotting?

2. Which argument should I use to plot multiple Fractions against the concentration?

We are seeking an expert group to collaborate on glycomics. Could anybody help and be part of an excellent research project.

Good Evening,

Could you please help me, i need a software to make a calculation using the Analytical Network Process method. Thank you in advance.

Best regards

Hello, I am trying to export the results generated within MAUD to Excel.

Thanks in advance for your time. Hope this question will be of help to other researchers.

Can you please provide guidance on performing sensitivity analysis in Fuzzy AHP using Excel?

When we want to measure the validity of a questionnaire, we usually measure by Lawshe formula- CVR & CVI. I want to know that if anyone has an Excel computing file for measuring the validity of a questionnaire.

.txt data file of Collision from SRIM is a very large file and I am struggling to export the data to excel. Plesae suggest me how to export .txt data file of Collision from SRIM Program to excel to plot the graph?

How does one succeed in balancing leadership, scholarship, career, family, and faith simultaneously? Oftentimes, individuals excel academically or professionally but face challenges when it comes to their family life or combining their faith with their career. How can these obstacles be overcome?"

This is a common concern for many individuals striving to maintain a harmonious equilibrium among these important aspects of life. While it may seem daunting, achieving success and fulfillment in each area is indeed possible with the right approach and mindset.

In a Discrete choice experiment, we have heterogeneity for one of the attributes. How can I create a marginal utility plot for this attribute in Excel? by creating a probability density plot in Excel? The attribute is a normal random parameter.

(This plot shows when the proportion of our population having a certain Part-Worth Utility is greatest.)

(The Norm.Dist function doesn't give the probability density.)

Thank you in advance.

Hi,

I am working on Modified Mann Kendall trend tests for monthly data sets from 1970 - 2019. I applied the code as indicated below for a single column and obtained results, but if I need to run the same function for a file with multiple columns, having data for all months, how do I run it? Can anyone help me with the code ?

sf=read_excel("07356000 Max.xlsx",17) > x=sf$December > mmkh(x,ci=0.95) Corrected Zc new P-value N/N* Original Z old P.value Tau -9.954529e-01 3.195160e-01 1.000000e+00 -9.954529e-01 3.195160e-01 -9.795918e-02 Sen's slope old.variance new.variance -4.727273e+01 1.429067e+04 1.429067e+04

Regards,

Meena Raju

I have export the Silvaco log file into Excel, i have also set up follow the current setting, but how do i know what value belong to it , Only Source, Gate,Drain is label , other i have no idea. Im here to create DIBL,subthreshold and peak sensitivity by using the Excel.

Setting of Excel i have follow as this Video in Youtube, but in the end of the video there is language barrier that i cant understand.

Hello every one

I have problem pasting some numbers in word or excel 2010 which are coped from the frequency output in gaussian, when it pasted, it had a column format which wasted lots of time to organize them same as the attached picture as I show you. Does any body know how to paste them in an order which they stand together with comma. I tried some formulas.

but it gives errors.

I will be very thankful

The oil and gas industry has a tremendous opportunity to harness the capabilities of analytics to optimize operations, improve decision-making, and drive significant business value. Lets discuss and aims to explore the diverse applications of analytics in the oil and gas industry and discuss how organisations can leverage these capabilities to achieve operational excellence.

I need to evaluate the cooling demand of a building, and so I need some informations (as wall temperature Inside/outside, sensitice heat transmission coefficient, etc...).

I know i can export the values corresponding to a single element of the facade, but is it possible to have every elements of a building in the same Excel file ? Or the average values for a facade ?

Actually, I'm wondering if there is an other way to calculate the cooling demand of the building ??