I hope this message finds you well. I am writing to request your assistance with exporting data from the SPT Estimate dialog. I have attempted to copy and paste the data into Excel or a text file, but so far have been unsuccessful.
Would you be able to provide me with guidance on the proper method for exporting this data? I would greatly appreciate any advice or instructions you could offer.
Thank you very much in advance for your time and help.
Dear Mr. Yong,
I have borehole values in PDF format, I have summarized them according to depth in excel and also tabulated SPT N values. I was wondering how can I input this information manually?
Hi Abdi, you can take a look the file Soilstats/examples/xlsx data.xlsx and see if you can use the this xlsx file template. By the way, a new version of SoilStats is coming out soon, which will provide the functions for borehole logs, stats, 3D view, and provide more flexibility.
Thank You, Mr. Yong. When I import the sample xlsx file, it says, invalid data map file. please check if a correct data map file was used. This is what I did, open a new file then open then file then xlsx then sample xlsx then I got the error above.
Hi Abdi, you need to set the datamap file for different file format. To set datamap file for the default xlsx file format, please go through the menu Settings->Data Map File->Add/Update->SoilStats examples folder->datamap_soilstats_xlsx_0_2.sdm.
Hi Yong – SoilStats is giving me an error saying the data file map is not correct. I’m using the one in your example folder, do you have any suggestions?
Dear Mr. Yong,
I hope this message finds you well. I am writing to request your assistance with exporting data from the SPT Estimate dialog. I have attempted to copy and paste the data into Excel or a text file, but so far have been unsuccessful.
Would you be able to provide me with guidance on the proper method for exporting this data? I would greatly appreciate any advice or instructions you could offer.
Thank you very much in advance for your time and help.
Best regards,
Santiago
Sorry Santiago, you cannot copy or export the data from the dialog with current version. I will make it available in the next version.
Dear Mr. Yong,
I have borehole values in PDF format, I have summarized them according to depth in excel and also tabulated SPT N values. I was wondering how can I input this information manually?
Hi Abdi, you can take a look the file Soilstats/examples/xlsx data.xlsx and see if you can use the this xlsx file template. By the way, a new version of SoilStats is coming out soon, which will provide the functions for borehole logs, stats, 3D view, and provide more flexibility.
Thank You, Mr. Yong. When I import the sample xlsx file, it says, invalid data map file. please check if a correct data map file was used. This is what I did, open a new file then open then file then xlsx then sample xlsx then I got the error above.
Hi Abdi, you need to set the datamap file for different file format. To set datamap file for the default xlsx file format, please go through the menu Settings->Data Map File->Add/Update->SoilStats examples folder->datamap_soilstats_xlsx_0_2.sdm.
Hi Yong – SoilStats is giving me an error saying the data file map is not correct. I’m using the one in your example folder, do you have any suggestions?
Hi Graeme, the data map file should match the data file you used. What data file did you use?
why i cant view the 3D? when i clicked to view, the apps automatically closed.
can you please forward me your file and let me take a look?