Difference between revisions of "Table registration"

From Marathon Documentation
Jump to: navigation, search
(Created page with "<htmltag tagname="style">p a.image{border:1px rgb(0,0,0) solid;box-sizing:content-box;}</htmltag> <translate> = Table registration = {{ExpandImage|MED-TAB-EN-Bild1.png}} S...")
 
(Marked this version for translation)
Line 2: Line 2:
 
<translate>
  
<translate>
   
−
= Table registration =
 +
= Table registration = <!--T:1-->
   
  +
<!--T:2-->
 
{{ExpandImage|MED-TAB-EN-Bild1.png}}
  
{{ExpandImage|MED-TAB-EN-Bild1.png}}
 
 
Line 10: Line 11:
 
You can also copy an existing plan; press NEW and then COPY.
  
You can also copy an existing plan; press NEW and then COPY.
   
  +
<!--T:3-->
 
{{ExpandImage|MED-TAB-EN-Bild2.png}}
 
{{ExpandImage|MED-TAB-EN-Bild2.png}}
   
  +
<!--T:4-->
 
If a plan shall be allocated between several clients, use Allocation template. The allocation can concern the whole plan or just single orders.
  
If a plan shall be allocated between several clients, use Allocation template. The allocation can concern the whole plan or just single orders.
   
  +
<!--T:5-->
 
{{ExpandImage|MED-TAB-EN-Bild3.png}}
  
{{ExpandImage|MED-TAB-EN-Bild3.png}}
 
 
 
Continue to Table registration. Select NEW and enter a version name (mandatory but has no relevance). Select thereafter Template and press OK. You can have several templates for different media types with varying columns and contents.
  
Continue to Table registration. Select NEW and enter a version name (mandatory but has no relevance). Select thereafter Template and press OK. You can have several templates for different media types with varying columns and contents.
   
  +
<!--T:6-->
 
{{ExpandImage|MED-TAB-EN-Bild4.png}}
  
{{ExpandImage|MED-TAB-EN-Bild4.png}}
   
  +
<!--T:7-->
 
{{ExpandImage|MED-TAB-EN-Bild5.png}}
  
{{ExpandImage|MED-TAB-EN-Bild5.png}}
 
 
   
  +
<!--T:8-->
 
Enter insertion date for the plan’s selected period. If the plan shall be allocated over several months, the date interval must span over the whole period.
  
Enter insertion date for the plan’s selected period. If the plan shall be allocated over several months, the date interval must span over the whole period.
   
  +
<!--T:9-->
 
Only selected columns = this box should be checked for the possibility to hide/add columns with the arrow symbol to the right in the list.
  
Only selected columns = this box should be checked for the possibility to hide/add columns with the arrow symbol to the right in the list.
 
Select media. Possible format and placement, cost model and other things that are important to have in reports and printouts.
  
Select media. Possible format and placement, cost model and other things that are important to have in reports and printouts.
   
  +
<!--T:10-->
 
SELECT ALL DATES= All dates in the calendars will be marked. If you don’t select any date, the insertion date will be the first date of the period.
  
SELECT ALL DATES= All dates in the calendars will be marked. If you don’t select any date, the insertion date will be the first date of the period.
   
  +
<!--T:11-->
 
Use SURCHARGE for adding fee, production cost or another surcharge and write amount. You can write an invoice comment, if you want another text on the invoice.
  
Use SURCHARGE for adding fee, production cost or another surcharge and write amount. You can write an invoice comment, if you want another text on the invoice.
   
  +
<!--T:12-->
 
{{ExpandImage|MED-TAB-EN-Bild6.png}}
  
{{ExpandImage|MED-TAB-EN-Bild6.png}}
   
  +
<!--T:13-->
 
When all media have been entered, SAVE. If everything looks OK, you must CONFIRM the version so that the orders are created and receive an order number from Marathon.
 
When all media have been entered, SAVE. If everything looks OK, you must CONFIRM the version so that the orders are created and receive an order number from Marathon.
   
  +
<!--T:14-->
 
''Note that these orders are preliminary and must be made definitive before they can be sent as order to media and invoiced.''
  
''Note that these orders are preliminary and must be made definitive before they can be sent as order to media and invoiced.''
   
  +
<!--T:15-->
 
{{ExpandImage|MED-TAB-EN-Bild7.png}}
  
{{ExpandImage|MED-TAB-EN-Bild7.png}}
   
  +
<!--T:16-->
 
{{ExpandImage|MED-TAB-EN-Bild8.png}}
  
{{ExpandImage|MED-TAB-EN-Bild8.png}}
 
 
   
−
== To make an allocation ==
+
== To make an allocation == <!--T:17-->
 
Example: Allocation over 3 months.
  
Example: Allocation over 3 months.
 
1. Select row and begin with SELECT ALL DATES
  
1. Select row and begin with SELECT ALL DATES
 
2. Press ALLOCATE and choose allocation alternative.
  
2. Press ALLOCATE and choose allocation alternative.
   
  +
<!--T:18-->
 
{{ExpandImage|MED-TAB-EN-Bild9.png}}
  
{{ExpandImage|MED-TAB-EN-Bild9.png}}
   
  +
<!--T:19-->
 
{{ExpandImage|MED-TAB-EN-Bild10.png}}
  
{{ExpandImage|MED-TAB-EN-Bild10.png}}
 
 
Line 57: Line 74:
 
{{ExpandImage|MED-TAB-EN-Bild11.png}}
  
{{ExpandImage|MED-TAB-EN-Bild11.png}}
 
 
−
== To correct an erroneous allocation ==
 +
== To correct an erroneous allocation == <!--T:20-->
 
The correction is made in the table registration.
  
The correction is made in the table registration.
 
Begin with selecting the order and press MERGE, which here means that you are undoing the allocation.
  
Begin with selecting the order and press MERGE, which here means that you are undoing the allocation.
Line 63: Line 80:
 
Thereafter, make a new allocation with ALLOCATE
  
Thereafter, make a new allocation with ALLOCATE
   
  +
<!--T:21-->
 
{{ExpandImage|MED-TAB-EN-Bild12.png}}
  
{{ExpandImage|MED-TAB-EN-Bild12.png}}
 
 
   
−
== The functions FIND CTC and FIND CTC (TOTAL) ==
 +
== The functions FIND CTC and FIND CTC (TOTAL) == <!--T:22-->
   
−
=== FIND CTC ===
 +
=== FIND CTC === <!--T:23-->
 
Select one of the orders and go to the cell that’s value shall be changed and click on FIND CTC . The value will be changed to requested amount.
  
Select one of the orders and go to the cell that’s value shall be changed and click on FIND CTC . The value will be changed to requested amount.
 
=== CTC (TOTAL)===
  
=== CTC (TOTAL)===
 
Similar function, but the total CTC concerns all orders. The value will be changed only in the cell you are in.
  
Similar function, but the total CTC concerns all orders. The value will be changed only in the cell you are in.
   
−
== The function IMPORT FROM SPREADSHEET ==
 +
== The function IMPORT FROM SPREADSHEET == <!--T:24-->
 
Right click in the middle of the table, select COPY. Paste into Excel. You get a tempalte taht you can use in importing to Table registration. You must use the whole template, all columns, otherwise the template does not work.
  
Right click in the middle of the table, select COPY. Paste into Excel. You get a tempalte taht you can use in importing to Table registration. You must use the whole template, all columns, otherwise the template does not work.
 
Fill in the template and import it to Table registration.
 
Fill in the template and import it to Table registration.
   
  +
<!--T:25-->
 
{{ExpandImage|MED-TAB-EN-Bild13.png}}
  
{{ExpandImage|MED-TAB-EN-Bild13.png}}
 
</translate>
  
</translate>

Revision as of 10:47, 29 April 2021

Table registration

Start by creating a NEW Media plan. Enter client, plan name, and select client agreement, if there is no default agreement. Then click SAVE. You can also copy an existing plan; press NEW and then COPY.

If a plan shall be allocated between several clients, use Allocation template. The allocation can concern the whole plan or just single orders.

Continue to Table registration. Select NEW and enter a version name (mandatory but has no relevance). Select thereafter Template and press OK. You can have several templates for different media types with varying columns and contents.


Enter insertion date for the plan’s selected period. If the plan shall be allocated over several months, the date interval must span over the whole period.

Only selected columns = this box should be checked for the possibility to hide/add columns with the arrow symbol to the right in the list. Select media. Possible format and placement, cost model and other things that are important to have in reports and printouts.

SELECT ALL DATES= All dates in the calendars will be marked. If you don’t select any date, the insertion date will be the first date of the period.

Use SURCHARGE for adding fee, production cost or another surcharge and write amount. You can write an invoice comment, if you want another text on the invoice.

When all media have been entered, SAVE. If everything looks OK, you must CONFIRM the version so that the orders are created and receive an order number from Marathon.

Note that these orders are preliminary and must be made definitive before they can be sent as order to media and invoiced.


To make an allocation

Example: Allocation over 3 months. 1. Select row and begin with SELECT ALL DATES 2. Press ALLOCATE and choose allocation alternative.


The order is allocated on three insertions, one per month.

To correct an erroneous allocation

The correction is made in the table registration. Begin with selecting the order and press MERGE, which here means that you are undoing the allocation. Next step is to delete the erroneous dates in the calendar. Keep the cursor over and drag the days that shall be deleted. Thereafter, make a new allocation with ALLOCATE

File:MED-TAB-EN-Bild12.png


The functions FIND CTC and FIND CTC (TOTAL)

FIND CTC

Select one of the orders and go to the cell that’s value shall be changed and click on FIND CTC . The value will be changed to requested amount.

CTC (TOTAL)

Similar function, but the total CTC concerns all orders. The value will be changed only in the cell you are in.

The function IMPORT FROM SPREADSHEET

Right click in the middle of the table, select COPY. Paste into Excel. You get a tempalte taht you can use in importing to Table registration. You must use the whole template, all columns, otherwise the template does not work. Fill in the template and import it to Table registration.

File:MED-TAB-EN-Bild13.png

Retrieved from "https://wikidoc.kase.se/index.php?title=Table_registration&oldid=66472"