How to copy data - Revision history

Alex Doll: /* Simulation result table */

2023-11-02T14:26:58Z

Simulation result table

Alex Doll: /* How to copy data out of a table */

2023-11-02T14:23:56Z

How to copy data out of a table

Alex Doll: /* How to copy data out of a table */

2013-12-08T20:56:15Z

How to copy data out of a table

Alex Doll: Created page with "category:Howto ==How to copy data out of a table== Most users of SAGMILLING.COM use spreadsheet software for performing additional calculations, comparisons and to format ..."

2013-02-02T21:11:46Z

Created page with "category:Howto ==How to copy data out of a table== Most users of SAGMILLING.COM use spreadsheet software for performing additional calculations, comparisons and to format ..."

New page

[[category:Howto]]
==How to copy data out of a table==
Most users of SAGMILLING.COM use spreadsheet software for performing additional calculations, comparisons and to format output. Most of the tables of data generated by SAGMILLING.COM contain a special <i>text box</i> where the table contents can easily be copied and pasted into your favourite spreadsheet software (OpenOffice, LibreOffice, Microsoft Excel, Gnumeric, Lotus 1-2-3, etc.)

Pressing the <b>[+]</b> button at the top of a table will open a menu with extra options. The first option is "Export data" which, when clicked, will open a new dialogue box with a large text field containing all the data in the table, formatted in a special form that is easy for spreadsheets to import. Do not worry that the formatted data looks strange to humans -- just select the whole data field (usually clicking the mouse in the field and pressing Ctrl-A on the keyboard) and copy it (usually by selecting Edit|Copy from your browser's menu bar). Then switch to your spreadsheet and paste (usually by selecting Edit|Paste from your spreadsheet's menu bar).

@@ Line 15: / Line 15: @@
 * simulation detail page including the flowsheet, model inputs, and model outputs.
 * details of the mills and motors.
-* tent diagrams for the mill motors.
+*tent diagrams for the mill motors.
 Note that the sorting of the output PDF (and how the percentiles are displayed) are based on the current sorting of the table you are viewing. If the table is sorted alphabetically by sample name, then the percentiles relate to that alphabetic sorting; if the table is sorted by t/h, then the percentiles relate to throughput.

@@ Line 1: / Line 1: @@
 [[category:Howto]]
 ==How to copy data out of a table==
-Most users of SAGMILLING.COM use spreadsheet software for performing additional calculations, comparisons and to format output.  Most of the tables of data generated by SAGMILLING.COM contain a special <i>text box</i> where the table contents can easily be copied and pasted into your favourite spreadsheet software (OpenOffice, LibreOffice, Microsoft Excel, Gnumeric, Lotus 1-2-3, etc.)
+Most users of SAGMILLING.COM use spreadsheet software for performing additional calculations, comparisons and to format output.  Most of the tables of data generated by SAGMILLING.COM contain a special <i>text box</i> where the table contents can easily be copied and pasted into your favourite spreadsheet software (LibreOffice, Google Shets, Microsoft Excel, etc.)
 Tables of data include icons that permit data to be exported in a variety of ways.  Not every table has all these options available, and the exact output will vary depending on which table is being exported.
@@ Line 7: / Line 7: @@
 * '''PDF''' icon begins a download of a detailed report including, where appropriate, tables and graphs of data.
 * '''Raw cut &amp; paste''' icon opens a box with a large text field containing all the data in the table, formatted in a special form that is easy for spreadsheets to import.  Do not worry that the formatted data looks strange to humans -- just select the whole data field (usually clicking the mouse in the field and pressing Ctrl-A on the keyboard) and copy it (usually by selecting Edit|Copy from your browser's menu bar).  Then switch to your spreadsheet and paste (usually by selecting Edit|Paste from your spreadsheet's menu bar).

← Older revision		Revision as of 20:56, 8 December 2013
Line 3:		Line 3:
	Most users of SAGMILLING.COM use spreadsheet software for performing additional calculations, comparisons and to format output. Most of the tables of data generated by SAGMILLING.COM contain a special <i>text box</i> where the table contents can easily be copied and pasted into your favourite spreadsheet software (OpenOffice, LibreOffice, Microsoft Excel, Gnumeric, Lotus 1-2-3, etc.)		Most users of SAGMILLING.COM use spreadsheet software for performing additional calculations, comparisons and to format output. Most of the tables of data generated by SAGMILLING.COM contain a special <i>text box</i> where the table contents can easily be copied and pasted into your favourite spreadsheet software (OpenOffice, LibreOffice, Microsoft Excel, Gnumeric, Lotus 1-2-3, etc.)

		+	Tables of data include icons that permit data to be exported in a variety of ways. Not every table has all these options available, and the exact output will vary depending on which table is being exported.
⚫	~~Pressing~~ ~~the~~ ~~<b>[+]</b>~~ ~~button~~ at ~~the~~ ~~top of~~ a ~~table will open a menu with extra options. The first option is "Export data" which, when clicked, will open a new dialogue~~ box with a large text field containing all the data in the table, formatted in a special form that is easy for spreadsheets to import. Do not worry that the formatted data looks strange to humans -- just select the whole data field (usually clicking the mouse in the field and pressing Ctrl-A on the keyboard) and copy it (usually by selecting Edit\|Copy from your browser's menu bar). Then switch to your spreadsheet and paste (usually by selecting Edit\|Paste from your spreadsheet's menu bar).
		+	* '''ODS''' icon begins a download of an OpenOffice or LibreOffice spreadsheet. This can be used directly in versions of Microsoft Excel versions 2011 and newer.
		+	* '''PDF''' icon begins a download of a detailed report including, where appropriate, tables and graphs of data.
		⚫	* '''Raw cut & paste''' icon opens a box with a large text field containing all the data in the table, formatted in a special form that is easy for spreadsheets to import. Do not worry that the formatted data looks strange to humans -- just select the whole data field (usually clicking the mouse in the field and pressing Ctrl-A on the keyboard) and copy it (usually by selecting Edit\|Copy from your browser's menu bar). Then switch to your spreadsheet and paste (usually by selecting Edit\|Paste from your spreadsheet's menu bar).