PANTHEON™ Help

 Toc
 PANTHEON Help - Welcome
[Collapse]PANTHEON
 [Collapse]Guides for PANTHEON
  [Expand]Guide for PANTHEON
  [Expand]Guide for PANTHEON Retail
  [Expand]Guide for PANTHEON Vet
  [Expand]Guide for PANTHEON Farming
 [Collapse]User Manuals for PANTHEON
  [Collapse]User Manual for PANTHEON
   [Expand]Getting Started
   [Expand]User Manual for eBusiness
   [Expand]Settings
   [Expand]Orders
   [Expand]Goods
   [Expand]Manufacturing
   [Expand]Service
   [Expand]Help
   [Expand]Personnel
   [Expand]Financials
   [Collapse]Analytics
    [Expand]Installation and Administration
    [Collapse]Planning
      Defining Document Type Used in Planning
      Opening ZEUS Planning Window
     [Collapse]Preparation of the plan
       Create plan header
       Create Plan Lines
       Copy Columns in Planning
       Copy Lines in Planning
       Copy price wizard
       Planning Using Transfer from Orders
       Planning Using Plan Generator
       Paste from Excel
       Automatically Created Formulas
       Import Data
       Import Financial Report Lines with Formulas
     [Expand]Plan analysis
     [Expand]Additional features
    [Expand]Ad-hoc Analyses
    [Expand]OLAP Reports
    [Expand]OLAP Analyses
    [Expand]Special Reports
    [Expand]Dashboard
  [Expand]User Manual for PANTHEON Retail
  [Expand]User manual for PANTHEON Vet
  [Expand]User Manual for PANTHEON Farming
[Collapse]PANTHEON Web
 [Collapse]Guides for PANTHEON Web
  [Expand]Guide for PANTHEON Web Light
  [Expand]Guide for PANTHEON Web Terminal
  [Expand]Guide for PANTHEON Web Legal
  [Expand]Old products Archive
 [Collapse]User Manuals for PANTHEON Web
  [Expand]Getting started PANTHEON Web
  [Expand]User Manual for PANTHEON Web Light
  [Expand]User Manual for PANTHEON Web Terminal
  [Expand]User Manual for PANTHEON Web Legal
  [Expand]Old products Archive
[Collapse]PANTHEON Granules
 [Collapse]Guides for PANTHEON Granules
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]Dashboard Granule
  [Expand]B2B Orders Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
 [Collapse]User Manuals for PANTHEON Granules
  [Expand]Getting started
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]B2B Orders Granule
  [Expand]Dashboard Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
  [Expand]Archive
[Expand]User Site

Load Time: 390.6259 ms
"
  1004241 | 211152 | 344530 | Updated
Label

Paste data from Excel

Paste from Excel

010411.gif010382.gif010383.gif

 

If you have planning data in Excel, you can also copy data directly to planning form and skip the import step.

  1. Paste data to master table
  2. Paste data to details table
  3. Paste data from previous plan lines

Paste data to master table

  1. Before we prepare data, at least one line should be added into plan; then plan should be exported to Excel or prepared in Excel with same structure as in PANTHEON.


     
  2. We prepare/set data in Excel.
  3. In Excel data (incl. headers) should be selected (see the picture); the easiest way is to use Select all (CTRL+A) and then Copy (CTRL+C).



     
  4. In main table of Planning first line should be selected (or line from which on data should be pasted); then we use Paste from Excel in Wizards menu.





     
  5. In confirmation window we decide whether (possible) existing data should be overwritten or not.


     
  6. After confirmation data will be pasted.


     

 

Paste data to details table

  1. We prepare main table with periods and lines; then we click on one of the cells to open details table.
     
  2. In the header of details table right-click should be used and then option Export to Excel should be used in the menu.


     
  3. We prepare/set data in Excel.
     
  4. We use Select all (CTRL+A) and then Copy (CTRL+C), to copy all the data.



     
  5. In Pantheon (after we selected the right details table) we use Paste from Excel into Details in Wizards menu.



     
  6. A message might appear that indicates that rows in the detailed grid will be overwritten. To proceed you should confirm this message.

  1. IRIS message indicates that rows with the same ID already exisit. Details about this message are explained here.


     
  2. After confirmation data will be pasted.

Paste data from previous plan lines

You can also copy data diretly from previous plan lines, with no need to export data to Excel. 

1. Open a detailed table from where you want to copy data.

2. Select the data, best with option Ctrl+A.

3. Move to the plan position, where you want to copy data to and select Paste from Excel into Details.

 

Topic in the PANTHEON Guide:

Related topics:

000001.gif If you are copying multiple lines from PANTHEON software will need some time to prepare data to copy. This might mean that software will freeze for a few seconds, while data are prepared. Don't preform any additional clicks in this time but wait that data are prepared.'

 

Rate this topic
Was this topic usefull?
Comments
Comment will also bo visible in forum!