How do you add asterisks for significance with putexcel in STATA?

error in running a model in Abaqus

Excessive rotation of nodes in node set ErrNodeExcessRotation-Step1

17 August 2021 0 0 View

error in modelling model in Abaqus

Excessive rotation of nodes in node set ErrNodeExcessRotation-Step1

17 August 2021 0 0 View

MGL tools

20 June 2021 0 0 View

i have some problem with chtMultiRegionSimpleFoam

--> FOAM FATAL ERROR: Maximum number of iterations exceeded From function Foam::scalar Foam::species::thermo::T(Foam::scalar, Foam::scalar, Foam::scalar, Foam::scalar (Foam::species::thermo::*)(Foam::scalar, Foam::scalar) const, Foam::scalar (Foam::species::thermo::*)(Foam::scalar, Foam::scalar) const, Foam::scalar (Foam::species::thermo::*)(Foam::scalar) const) const [with Thermo = Foam::hConstThermo >; Type = Foam::sensibleEnthalpy; Foam::scalar = double; Foam::species::thermo = Foam::species::thermo >, Foam::sensibleEnthalpy>] in file /home/ubuntu/OpenFOAM/OpenFOAM-4.1/src/thermophysicalModels/specie/lnInclude/thermoI.H at line 66. FOAM aborting #0 Foam::error::printStack(Foam::Ostream&) at ??:? #1 Foam::error::abort() at ??:? #2 Foam::heRhoThermo >, Foam::sensibleEnthalpy> > > >::calculate() at ??:? #3 Foam::heRhoThermo >, Foam::sensibleEnthalpy> > > >::correct() at ??:? #4 ? at ??:? #5 __libc_start_main in "/lib/x86_64-linux-gnu/libc.so.6" #6 ? at ??:?

24 March 2021 0 0 View

How to compare two groups with only two measurements?

Hiiiii everyone! I have an enquiry on statistical analysis. I was looking for many forum and it's still cannot solve my problem. I want to compare means of two groups of data but only with two...

03 March 2021 8,796 3 View

Dear all, I was wondering if anyone knows whether MGLtools and Autodock can run on Mac OS?

I have tried to download the 64-bit version of MGLtools however, as many times as I have downloaded and uninstall the programs, an error arises that the app needs to be updated. Thank you.

03 March 2021 5,997 2 View

Enhanced Yellow Fluorescent Protein (Aequorea victoria) DNA sequence?

I am on the lookout for the Enhanced Yellow Fluorescent Protein (Aequorea victoria) DNA sequence. Does anyone know where I can find it? Thank you in advance

03 March 2021 3,568 1 View

What kind of fluid could I use for a pitfall trap that also does not invalidate molecular testing?

Hi, I want to start testing pitfall trap to obtain ants samples, but I need to conduct molecular analysis on those insects. So, what kind of fluid can I use? Ethanol expires too early and I need...

03 March 2021 5,978 5 View

What's the best way to measure growth rates in House sparrow chicks from day 2 to day 10?

What's the best way to measure growth rates in House sparrow chicks from day 2 to day 10? Since, the growth curve from day 2 to 10 won't be like the "Logistic curve" it might not follow logistic...

03 March 2021 1,401 3 View

I got 02 moderator values defining Johnson-Neyman significance regions. Is it an error?

Hi everyone, I am conducting research for my Master's thesis. I am using PROCESS by Johnson-Neyman to analyze my Moderator model. I test the relationship between Public Service Motivation and...

03 March 2021 2,350 2 View

Michael R Jonas

I've not tried it with putexcel, but putdocx will allow you to export a formatted table using "eststo" and "estimates table" first.

Here is a tutorial on basic putdocx:

https://youtu.be/rgd_frM6kKA

Here is an example of using combo of "putdocx" and "estimates table"

https://www.stata.com/stata-news/news32-3/spotlight-putdocx/

Wameq A Raza

Thanks Michael R Jonas , this is helpful! I've been struggling with two things mainly:

1. Formatting the tables at a granular level for around 36 models in one go (12 tables with three models each)

2. Adding them to different sheets in the same excel file

After I couldn't find anything online, I've used a combination of xml_tab and putexcel to get my tables. Happy to share the do file if you're interested.

Marina Rapp

Hi Wameq A Raza ,

If you could, I would be very interested in taking a look at your do file.

Thank you :)

Hi Marina,

I’m attaching my do file, please see lines 124-249. Keep in mind it’s not the most elegant solution and there has to be one manual step. This is primarily because once you run xml_tab, the excel file kind of breaks, and so you have to manually open and save it (it’s noted in the do file about where to do this). But other than that, it seems to work well, especially considering there are so many different models with varying independent vars!

Please do let me know if it works for you and if you ever find a better solution for this!

Best, Wameq