Wenn A2 Smart wird und Kollegen F. die Arbeit für nachschlagen und umrechnen überlässt.

Heutzutage nutzen viele Anwender Google Tabellen für die Zusammenarbeit mit Team und Kunden. Viele Anwender kopieren die gleichen Inhalte von links nach rechts, von oben nach unten. Das braucht Zeit. Wenn Änderungen gemacht werden, geht die Übersicht von ausgeführten Änderungen schnell verloren. Warum also nicht Änderungen an einer Stelle machen und mit Hilfe von Programm Funktionen wieder verwenden? Und los, betrachten wir wie Kollege Formel Inhalte aus Tabellenzelle A2 Smart mehrfach verwenden lässt.

Anwendungsfall: Kopfbereich zur einfachen Orientierung im wöchentlichen Team Report

Einmal die Woche, hilft eine Übersicht der laufenden Projekte zu erkennen wo Probleme sind und unterstützt bei der Lösuns-orientierten Kommunikation, wenn jeder schnell im Bild ist. Als Ergänzung zu einfachen Text, werden wesentliche Textteile hervorgehoben. In unserem Beispiel, ist die Kalenderwoche fett und der dazugehörige Datumsbereich in einem mittlerem grau. Nur die Kalenderwoche – 23 – und das Jahr – 2017 – sind in der Tabellenzelle zu editieren. Anfangs und Enddatum berechnen sich automatisch eine Zelle tiefer. Jede Woche hat ihren ein eigenes Arbeitsblatt. Mit Kopieren und Einfügen, lassen sich einmal eingestellte Darstellung und erstellte Formeln einfach wiederverwenden.

Das Google Arbeitsblatt …

Screenshot 2017-06-16 22.21.24

Zum Behalten der Übersicht im  WebPublishing Mode sind die Google Tabellen typischen Zeilen und Spalen Bezeichner nach rechs und in den Fußbereich gerutscht 

/trans in progress/ The addressing of contents, rows, cells, and calculations is thus obtained. The first line (A) contains recorded text for the overview and easier comprehension. The second column (B) the respective calculation. The third column (C) the result. The respective calculations are first performed line by line. In lines 12 and 13, the six partial results for the desired representation of the start and end date are distributed in a cell-by-cell manner. Content and calculations can be copied and copied from the WebPublishing mode to copy and paste into your own Google tables.


Some colleague Formula background …

… sorted by Row

  1. content / code / result
  2. Google Tables allows the REGEX function. The benefit is that without other usual functions such as LEFT, MID, RIGHT, input parts can be flexibly recognized by text and number.
  3. The SPLIT function distributes content by a separator, in columns, and within a row.
  4. The backward calculation over the calendar week and the year takes „+1“ at the end of the formula a calendar week change on Monday.
  5. With the function LEFT, the standard conversion and display of a date are canceled. The first 6 characters are used to get the date from the weekday and month.
  6. For the end date of the week, six days are added to the ascertained start date by addition.
  7. Overwrites and uses the calculated date as text, as described in line 5 above.
  8. Matches the results of 5th and 7th together. In between, the text string „-“ is inserted by calculation.

… do you want more code practice stuff? Feel free to send me a line by e-mail.


overview, dependencies, and relationships

How to get content, used style, color, position information from PowerPoint via PDF well formed to InDesign with the help of plugIn technology that takes care of wanted InDesign object settings and saves adjustment time?

First … collect topics (1).

Second … arrangement topics

Third … rethink what is the goal, which is the «nasty» repeating steps you may not want do on every result page and content object.


… prepare your test drive …

I will go to report later, how the conversation of my PowerPoint via PDF to InDesign works with two different Plugins.

… in the meantime fell free to use my overview and fit it to your belongings via realtimeboard.com

(1) speed up this. Use a text editor. Paste your topics in a table tool like Excel, copy it to your clipboard and paste it in a clean realtimeboard.com board.

… some weeks later

To shorten up. MS Powerpoint conversation via PDF and usage of PlugIns* do not support InDesign Object and Table styles, Layers, Paragraph, Character styles, Color Swatches as named definition. Why? MS Powerpoint does not organize those settings as the central definition. So what happen after PDF conversation? What is transported? And what are the topics the InDesign operator have to work on?

▢ 1. Usability of value conversions.

▢ 1.1 A page is a page.

Correct width and height are done pretty fast with some clicks at the document settings.

▢ 1.2 Typo

▢ 1.2.1 Font sizes are not accurate converted

That is the one bad thing. The good thing is that all general settings are transported. Not as smooth values, but stored in a bunch of named Paragraph and Character styles. That is the second bad thing, which is not with a few clicks quickly corrected and prepared for further use in the InDesign universe.

▢ 1.2.2 Font style

One of the main differences between PowerPoint and InDesign now comes in sight. Microsoft Office products like Powerpoint and Word, allows the usage of bold and italic even if the font is not in the system. So basically this problem is invisible as long the creator of Powerpoint are stay at Arial. Or any other basic font of a standard Windows system installation. At the moment Arial is not the preferred corporate font for external communication, be aware that the InDesign operator has to use the font in regular, bold, italic, bold-italic. The rule „Only system fonts will translate across computers consistently“ is explained on WORD VS INDESIGN by Jade Jump.

Image opusdesign.us

▢ 1.3 Object position and size

More or less works fine. As before, the conversion of units of measurement has slight weaknesses in rounding. Some rework here is necessary.

▢ 1.4 Powerpoint Templates and InDesign Layers

PowerPoint Templates are not detected via the PDF conversation. So the Indesign operator do have to drop repeated content objects like company logo, page numbers to a InDesign master page. Also, the decision, working with layers for separate text, images, tables needs some rework on the interim result. Dropping conversation content on layers is a good help using the conversation plugins. Showing, rearranging, rework the converted content is like working on transparent paper.

Plugins do the magic stuff

For playing around with my presentation PDF a had have the chance to use a conversation tool from recosoft.com and one from markzware.com.

Later, we will dive into topics where the plugins help to save time for stupid reassemble design and content and raise time frames for more accuracy for further usage.

… next stop are in detail:

  • ⏲ time saver
  • ⚠ where to keep the eyes open and rework will be necessary

⚙ PDF2ID, recosoft


… reuse the contents of PDF or XPS files. XPS what? A Microsoft approach to have a similar solution like PDF for printing and storing documents with freezing their design and drop the capability of editing.

⚙ PDF2DTP*, markzware


* PDF to Desktop Publishing. Similar to PDF2ID, PDF2DTP is an affordable method to move PDF content to an editable format within Adobe InDesign.

Format conversation

… some weeks later. My personal test-production environment is already over. My other daily work, such as the design, development and configuration of autopilot for automated multi-channel content presentation, fills my daily schedule. Time for a short summary. Recosoft does a good job, but Markzware makes it better for my needs.

Screen PDF2ID, recosoft

Screen PDF2DTP, markzware

After the conversion you get talking formats which help the user quickly reduce optical duplicates into unique InDesign format definitions. The implementation of tables in InDesign table objects has been successful. In general, only the decimal places of the respective dimensions are to be simplified.

[backupversion 17-5-22 / work days article start 17-3-31, article end 17-5-17]

custom query #publishing #systeme #tools #ressourcen

Nachdenken kostet Zeit.

Abkürzungen sparen Zeit.

Zeit besser nutzen.

… mit einer custom query.

Eine individuelle Abfrage der oyen.de Datenbestände (> 1.200 Einträge Stand Jan 2015) rund um Publishing Systeme, Programme, Tools, Frameworks, Dienstleister und weitere Ressourcen, ist ab einer EDU Einheit möglich. Eine EDU Einheit umfasst im Rahmen von 60 Minuten ein kurzes Interview zur Erstellung einer angepassten Abfrage, die Ausführung der Abfrage, sowie die Besprechung der Ergebnisse und möglichen nächsten Schritte.

Jetzt weitere Informationen anfordern.