Tabelregistrering

Tabelregistrering

Begynd ved at oprette et nyt Mediebudget. Angiv kunde, budgetnavn og vælg kundeaftale, hvis det ikke findes nogen defaultaftale. Derefter, klik på GEM. Man kan også kopiere et eksisterende budget; klik da på NY og derefter KOPIÈR.

Hvis et budget skal fordeles mellem flere kunder, brug Fordelingsskabelon. Fordelingen kan vedrøre hele budgettet eller kun enkelte ordrer.

Gå sedan til fanen Tabelregistrering. Vælg NY og angiv et versionsnavn (obligatorisk, men har ingen betydning). Vælg også skabelon og OK. Der kan findes flere skabeloner for de forskellige mediegrupper, med forskellige kolonner og indhold

Angiv indrykningsdato for aktuel periode for budgettet. Hvis mediebudgettet skal fordeles over flere måneder sal datointervallet dække hele perioden.

Kun valgte kolonner = dette valg skal være afkrydset, for at kunne skjule/lægge til kolonner med >-tegnet til højre i listen (kolonnevælgeren) Vælg media, evt. format og placering, costmodel og andet vigtigt at få med på udskrifter og rapporter.

VÆLG ALLE DATOER = Kalenderen markeres med alle datoer. Hvis man ikke markerer, bliver indrykningsdatoen den første i perioden

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

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.