OK_column_standards: Data: Column standards for OK sampling plans.

In NorwegianVeterinaryInstitute/OKplan: Tools to facilitate the Planning of the annual Surveillance Programmes

Data: Column standards for OK sampling plans.

Description

A data frame with the column standards for data frames and Excel sheets produced when planning the sampling schemes for the Norwegian surveillance programmes. The raw data for the column standards can be edited in the original Excel table. The code for preparing of the data frame is written in "./data-raw/generate_OK_column_standards". The OK_column_standards is used as input for standardize_columns.

Usage

OK_column_standards

Format

A data frame with 14 variables:

db

the database, either OK_planlegging or OK_kontroll

table_db

name of source table / data frame

colname_db

name of variable in source table

colname

name of variable in working table, usually the same as in source table

label_1_no

label (column name) used when writing to Excel, one line header. Generated from label_no and spec_no. For OK-planning usually the same as label_no

label_no

label in short form

spec_no

specification of label

label_1_en

English label (column name) used when writing to Excel, one line header. Generated from label_no and spec_no. For OK-planning usually the same as label_no

label_en

English label in short form

spec_en

specification of label

colwidth_Excel

column width used in Excel tables given in Excel units

colwidth_DT

column width used in DT tables, currently not relevant for OK-planning

colclasses

column class usedto import character strings correctly

colorder

column order when saving standard data and reporting

Source

"colnames_translation_table.xlsx" at NVI's internal net.

Examples

standards <- data(OK_column_standards, package = "OKplan")

NorwegianVeterinaryInstitute/OKplan documentation built on Dec. 20, 2024, 10:41 a.m.