Kelp AB

Blog

  • Tabular data, instructions and documentation part 2

    Tabular data, instructions and documentation part 2

    Documentation through publisher tools, e g Affinity Publisher

    E g Affinity Publisher makes it easy to design and layout pages.
    It is also easy to start with tabular data from a spreadsheet (Excel or CSV-file). The end-result is often a PDF-file.

    Operationally, clear documentation is needed for the users to get things done.

    The  simple parts to get the documentation done are: It easy to produce these old and simple things together.

    • Automation
    • Data Merge
    • CSV-files
    • Place images
    • Quick grids
    • Handling pages, master pages or individual pages
    • importing DWG-files if necessary. If you need drawings.
    • Table of contents and/or bookmark
    • Index
    • Graphs
    • Flow chart
    • Math formulas

    It is easy to handle a couple of hundreds of records and customize individual records when needed. Often what
    is stored in a spreadsheet or/and in an image folder.

    Images from Affinity Publisher below:

    Place images

    Data merge manager

    Master and page handling

    Pages Panel

    Table of contents

    Different charts

    Chart

    Math formulas

    Markdown and Deckset

    One other fast way to produce documentation is to use Markdown in e g Visual Studio Code and
    then produce slides through Deckset.

  • Tabular data, format, data, part 2, (very much just to use/do it)

    Tabular data, format, data, tools, part 2 (very much just to use/do it)

    To use the output from tabular data in an organization it needs to be presented,
    used in traning and documentation. The points below are often self-evident, but
    slows things down if absent. It is practical matter.

    • Format: CSV (spreadsheets), DWG (drawings)
    • Designer programs -Vectorhandling
    • Image-processing.
    • Web or publishing program
    • Markdown combined e g with Mermaid. (diagram)
    • Different import-exports functions in abovementioned programs.
    • the usual office etc programs from Microsoft, Apple or Google etc

  • Tabular data

    Tabular data (first draft)

    Tabular data

    Apple got a framework for tabular data. . You use tabular data all the time. E g from a spreedsheet or a json file. Whether you render it through a view or reportgenerator dosen’t matter.

    Using data for properties, quality and financial information.

    You often use some kind of maths and/or statistics.

    CatDogHorse
    345
    345
    345
    91215

    Screens-layout

    It’s easy to use view on the phone or laptop. The iphone renders the following using SwiftUI for an Ios-app.
    In most cases you use some collection/container.

    pastedGraphic.png
    pastedGraphic_1.png

    E g you see the energy-prices in tabular format on the webb. Which might be interesting this winter with energy shortage.
    https://www.nordpoolgroup.com/Market-data1/