Machine hour rate calculation

📘

Group layout & background image

By adding the definitions paddingleft=18;paddingright=18;columnspacing=8; to your group in the raw xml configuration you can adjust the look and feel of each cell.

The background image can be added by using the definition backgroundimage=yourfileurl.jpg; in the app definitions.

Link to this app
https://oaa.app.link/launch-app-289a0364-8113-4a6e-8425-caeff6dc85ce

Excel file for this app
https://api.openasapp.net/v1/api/EntityStorage/AppStorage/289a0364-8113-4a6e-8425-caeff6dc85ce/data.xlsx

500500

"Machine hour rate calculation" custom group layout and an image as background.

App Definitions

backgroundcolor=white;backgroundimage=https://api.openasapp.net/v1/api/EntityImageStorage/AppStorage/289a0364-8113-4a6e-8425-caeff6dc85ce/public/topAreaImage-11ab7a6c0cc94cb7952e41afb65e3520.jpeg;topareaheight=18%;paddinghorz=0;paddingvert=0;functionbuttoncolor=#de7a30;headeropacity=5;pagecount=5;allowpushtoserver=true;printsheet=Calculation;menuentries=print;

Raw XML Configuration

<?xml version="1.0" encoding="utf-8"?>
<pages
    xmlns="urn:WunderApp">
    <page pageid="1" caption="Overview" definitions="sheetname=Calculation;summarywidth=110;summaryopacity=6;summarybackgroundcolor=AC190D;">
        <excelcontent id="1">
            <caption>Allgemein</caption>
            <description>Allgemein</description>
            <definitions>buttonopacity=9;separatorcolor=CFCFCF;elementcolor=39A83C;valuetextcolor=39A83C;</definitions>
            <items>
                <item id="UeYyZ5dL" caption="Overview machine hour cost rates" contenttype="header">
                    <itemdefinitions>height=20%;backgroundcolor=#00000000;textcolor=white;textfontsize=21;</itemdefinitions>
                </item>
                <item id="DGjUYQvg" caption="DGjUYQvg" inputtype="output" contenttype="grouplayout">
                    <itemdefinitions>buttonheight=90;metrictext=;paddingleft=18;paddingright=18;columnspacing=8;separatorcolor=transparent;bordercolor=transparent;buttonradius=0;backgroundcolor=ff0000;elementcolor=000000;valuetextcolor=000000;</itemdefinitions>
                </item>
                <item id="esKqaUu7" caption="DMG MORI I" inputtype="output" contenttype="result" address="B58">
                    <itemdefinitions>nocaption=true;buttonheight=15%;buttonradius=0;backgroundcolor=#214a9a;usecellformat=true;elementcolor=#ffffff;valuetextcolor=#ffffff;metrictext=hour rate in €;groupname=DGjUYQvg;</itemdefinitions>
                </item>
                <item id="4ndZzqhF" caption="CMZ TA" inputtype="output" contenttype="result" address="B59">
                    <itemdefinitions>nocaption=true;buttonheight=15%;buttonradius=0;backgroundcolor=#214a9a;usecellformat=true;elementcolor=#ffffff;valuetextcolor=#ffffff;metrictext=hour rate in €;groupname=DGjUYQvg;</itemdefinitions>
                </item>
                <item id="oHO5KMRU" caption="spacer" inputtype="" contenttype="spacer">
                    <itemdefinitions>height=6;backgroundcolor=transparent;</itemdefinitions>
                </item>
                <item id="OvEsZIry" caption="OvEsZIry" inputtype="output" contenttype="grouplayout">
                    <itemdefinitions>buttonheight=90;metrictext=;paddingleft=18;paddingright=18;columnspacing=8;separatorcolor=transparent;bordercolor=transparent;buttonradius=0;backgroundcolor=ff0000;elementcolor=000000;valuetextcolor=000000;</itemdefinitions>
                </item>
                <item id="ceE5IfC4" caption="Spinner TC 600" inputtype="output" contenttype="result" address="B60">
                    <itemdefinitions>nocaption=true;buttonheight=15%;buttonradius=0;backgroundcolor=#214a9a;usecellformat=true;elementcolor=#ffffff;valuetextcolor=#ffffff;metrictext=hour rate in €;groupname=OvEsZIry;</itemdefinitions>
                </item>
                <item id="6QICsK2e" caption="TruFlow" inputtype="output" contenttype="result" address="B61">
                    <itemdefinitions>nocaption=true;buttonheight=15%;buttonradius=0;backgroundcolor=#214a9a;usecellformat=true;elementcolor=#ffffff;valuetextcolor=#ffffff;metrictext=hour rate in €;groupname=OvEsZIry;</itemdefinitions>
                </item>
                <item id="nsFiM7Nt" caption="spacer" inputtype="" contenttype="spacer">
                    <itemdefinitions>height=6;backgroundcolor=transparent;</itemdefinitions>
                </item>
                <item id="uxfF9PKQ" caption="uxfF9PKQ" inputtype="output" contenttype="grouplayout">
                    <itemdefinitions>buttonheight=90;metrictext=;paddingleft=18;paddingright=18;columnspacing=8;separatorcolor=transparent;bordercolor=transparent;buttonradius=0;backgroundcolor=ff0000;elementcolor=000000;valuetextcolor=000000;</itemdefinitions>
                </item>
                <item id="y4WVHuxr" caption="HEDELIUS C 80" inputtype="output" contenttype="result" address="B62">
                    <itemdefinitions>nocaption=true;buttonheight=15%;buttonradius=0;backgroundcolor=#214a9a;usecellformat=true;elementcolor=#ffffff;valuetextcolor=#ffffff;metrictext=hour rate in €;groupname=uxfF9PKQ;</itemdefinitions>
                </item>
                <item id="HlfnAP5p" caption="EMAG VLC 200" inputtype="output" contenttype="result" address="B63">
                    <itemdefinitions>nocaption=true;backgroundcolor=#214a9a;usecellformat=true;groupname=uxfF9PKQ;metrictext=hour rate in €;</itemdefinitions>
                </item>
            </items>
        </excelcontent>
    </page>
    <page pageid="2" caption="Details">
        <excelcontent id="2">
            <items>
                <item caption="" id="lZwSw9vM" inputtype="input" contenttype="toggle" address="A83">
                    <itemdefinitions>backgroundcolor=white;elementcolor=09679b;valuetextcolor=09679b;valuelist=:,DMG MORI CLX:DMG MORI CLX,CMZ TA:CMZ TA,Spinner TC 600:Spinner TC 600,TruFlow:TruFlow,HEDELIUS C 80:HEDELIUS C 80,EMAG VLC 200:EMAG VLC 200;showeditbuttons=true</itemdefinitions>
                </item>
                <item id="7WeCJzxA" caption="spacer" inputtype="" contenttype="spacer">
                    <itemdefinitions>height=2;backgroundcolor=transparent;</itemdefinitions>
                </item>
                <item id="2d3nEriG" caption="2d3nEriG" inputtype="output" contenttype="grouplayout">
                    <itemdefinitions>buttonheight=90;metrictext=;separatorcolor=transparent;bordercolor=transparent;buttonradius=0;backgroundcolor=ff0000;elementcolor=000000;valuetextcolor=000000;</itemdefinitions>
                </item>
                <item id="or6lOtJI" caption="Acquisition costs" inputtype="output" contenttype="result" address="B84">
                    <itemdefinitions>nocaption=true;backgroundcolor=#214a9a;usecellformat=true;groupname=2d3nEriG;metrictext=in €;</itemdefinitions>
                </item>
                <item id="ydzk7LLD" caption="Asset depreciation per year" inputtype="output" contenttype="result" address="B85">
                    <itemdefinitions>nocaption=true;backgroundcolor=#214a9a;usecellformat=true;groupname=2d3nEriG;metrictext=in €;editortype=tileedit;</itemdefinitions>
                </item>
                <item id="LOKvizAM" caption="spacer" inputtype="" contenttype="spacer">
                    <itemdefinitions>height=2;backgroundcolor=transparent;</itemdefinitions>
                </item>
                <item id="OuOBmxPE" caption="OuOBmxPE" inputtype="output" contenttype="grouplayout">
                    <itemdefinitions>buttonheight=90;metrictext=;separatorcolor=transparent;bordercolor=transparent;buttonradius=0;backgroundcolor=ff0000;elementcolor=000000;valuetextcolor=000000;</itemdefinitions>
                </item>
                <item id="0HXOOLf9" caption="# of shifts" inputtype="output" contenttype="result" address="B86">
                    <itemdefinitions>nocaption=true;backgroundcolor=214a9a;usecellformat=true;groupname=OuOBmxPE;</itemdefinitions>
                </item>
                <item id="cqI6ipnK" caption="Occupancy rate" inputtype="output" contenttype="result" address="B87">
                    <itemdefinitions>nocaption=true;backgroundcolor=214a9a;usecellformat=true;groupname=OuOBmxPE;</itemdefinitions>
                </item>
                <item id="yMeqpmAS" caption="spacer" inputtype="" contenttype="spacer">
                    <itemdefinitions>height=2;backgroundcolor=transparent;</itemdefinitions>
                </item>
                <item id="JhDjydct" caption="JhDjydct" inputtype="output" contenttype="grouplayout">
                    <itemdefinitions>buttonheight=90;metrictext=;separatorcolor=transparent;bordercolor=transparent;buttonradius=0;backgroundcolor=ff0000;elementcolor=000000;valuetextcolor=000000;</itemdefinitions>
                </item>
                <item id="Kpfp1dbW" caption="Run time" inputtype="output" contenttype="result" address="B88">
                    <itemdefinitions>nocaption=true;backgroundcolor=#214a9a;usecellformat=true;groupname=JhDjydct;metrictext=in h;</itemdefinitions>
                </item>
                <item id="7Yx9bKWH" caption="Asset depreciation per h" inputtype="output" contenttype="result" address="B89">
                    <itemdefinitions>nocaption=true;backgroundcolor=#214a9a;usecellformat=true;groupname=JhDjydct;metrictext=in €;</itemdefinitions>
                </item>
                <item id="CuoKoBJy" caption="Maintenance" contenttype="header">
                    <itemdefinitions>height=30;backgroundcolor=transparent;textcolor=white;textfontsize=21;</itemdefinitions>
                </item>
                <item id="gTUJLoI0" caption="gTUJLoI0" inputtype="output" contenttype="grouplayout">
                    <itemdefinitions>buttonheight=90;metrictext=;separatorcolor=transparent;bordercolor=transparent;buttonradius=0;backgroundcolor=ff0000;elementcolor=000000;valuetextcolor=000000;</itemdefinitions>
                </item>
                <item id="hHldeoD9" caption="Maintenance per year" inputtype="output" contenttype="result" address="B90">
                    <itemdefinitions>nocaption=true;backgroundcolor=#2654af;usecellformat=true;groupname=gTUJLoI0;metrictext=in €;</itemdefinitions>
                </item>
                <item id="p7c0RLFh" caption="Maintenance per h" inputtype="output" contenttype="result" address="B91">
                    <itemdefinitions>nocaption=true;backgroundcolor=#2654af;usecellformat=true;groupname=gTUJLoI0;metrictext=in €;</itemdefinitions>
                </item>
                <item id="MZXff5KU" caption="Energy" contenttype="header">
                    <itemdefinitions>height=30;backgroundcolor=#00000000;textcolor=white;textfontsize=21;</itemdefinitions>
                </item>
                <item id="k0inM0We" caption="k0inM0We" inputtype="output" contenttype="grouplayout">
                    <itemdefinitions>buttonheight=90;metrictext=;separatorcolor=transparent;bordercolor=transparent;buttonradius=0;backgroundcolor=ff0000;elementcolor=000000;valuetextcolor=000000;</itemdefinitions>
                </item>
                <item id="WbYGrRb3" caption="Energy per year" inputtype="output" contenttype="result" address="B92">
                    <itemdefinitions>nocaption=true;backgroundcolor=#2a5ec4;usecellformat=true;groupname=k0inM0We;metrictext=in €;</itemdefinitions>
                </item>
                <item id="NhBF13UH" caption="Energy per h" inputtype="output" contenttype="result" address="B93">
                    <itemdefinitions>nocaption=true;backgroundcolor=#2a5ec4;usecellformat=true;groupname=k0inM0We;metrictext=in €;</itemdefinitions>
                </item>
                <item id="ik5x0O20" caption="Rent" contenttype="header">
                    <itemdefinitions>height=30;backgroundcolor=transparent;textcolor=white;textfontsize=21;</itemdefinitions>
                </item>
                <item id="pnBIJt8G" caption="pnBIJt8G" inputtype="output" contenttype="grouplayout">
                    <itemdefinitions>buttonheight=90;metrictext=;separatorcolor=white;bordercolor=transparent;buttonradius=0;backgroundcolor=ff0000;elementcolor=000000;valuetextcolor=000000;</itemdefinitions>
                </item>
                <item id="azLcKZ9s" caption="Rent per Year" inputtype="output" contenttype="result" address="B94">
                    <itemdefinitions>nocaption=true;backgroundcolor=#346ad3;usecellformat=true;groupname=pnBIJt8G;metrictext=in €;</itemdefinitions>
                </item>
                <item id="bsyKdlgP" caption="Rent per h" inputtype="output" contenttype="result" address="B95">
                    <itemdefinitions>nocaption=true;backgroundcolor=#346ad3;usecellformat=true;groupname=pnBIJt8G;metrictext=in €;</itemdefinitions>
                </item>
            </items>
        </excelcontent>
    </page>
    <page pageid="3" caption="Details Cards">
        <excelcontent id="2">
            <items>
                <item id="OxCNufdV" contenttype="cardlist" address="A13:H19">
                    <itemdefinitions>categorycolumn=4;componentname=list;padding=4;height=80%;gridrowheight=40;gridcollapsegroups=false;gridallowedit=false;headeravailable=true;showcolumnheader=true;showsearchpanel=false;imagewidth=120;imagefillmode=aspectfit;listcolumns=1::,4::,7::,8::image;detailcolumns=1::,8:image,2::,3::,4:toggle,5:toggle,6::,7::,9::,10::,11::,12::,13::,14::;</itemdefinitions>
                </item>
            </items>
        </excelcontent>
    </page>
    <page pageid="4" caption="Adjustments">
        <excelcontent id="2">
            <items>
                <item id="Uw3DCQla" caption="spacer" inputtype="" contenttype="spacer">
                    <itemdefinitions>height=30;backgroundcolor=transparent;</itemdefinitions>
                </item>
                <item caption="Maintenance / year" id="yUr6vRGa" inputtype="input" contenttype="integer" address="B36">
                    <itemdefinitions>backgroundcolor=#ffffff;elementcolor=#09679b;valuetextcolor=#09679b;showeditbuttons=true;metrictext=in €;deltastep=100;</itemdefinitions>
                </item>
                <item id="6qJNpH1A" caption="spacer" inputtype="" contenttype="spacer">
                    <itemdefinitions>height=2;backgroundcolor=transparent;</itemdefinitions>
                </item>
                <item caption="Energy cost /year" id="FLidjOV7" inputtype="input" contenttype="integer" address="D36">
                    <itemdefinitions>backgroundcolor=#ffffff;elementcolor=#09679b;valuetextcolor=#09679b;showeditbuttons=true;metrictext=in €;deltastep=100;</itemdefinitions>
                </item>
                <item id="vIF0aEBa" caption="spacer" inputtype="" contenttype="spacer">
                    <itemdefinitions>height=2;backgroundcolor=transparent;</itemdefinitions>
                </item>
                <item caption="Rent / year" id="gVgG4gAc" inputtype="input" contenttype="integer" address="F36">
                    <itemdefinitions>backgroundcolor=#ffffff;elementcolor=#09679b;valuetextcolor=#09679b;showeditbuttons=true;metrictext=in €;deltastep=100;</itemdefinitions>
                </item>
                <item id="E2XWkCFM" caption="spacer" inputtype="" contenttype="spacer">
                    <itemdefinitions>height=2;backgroundcolor=transparent;</itemdefinitions>
                </item>
                <item id="R1K3QWDY" caption="R1K3QWDY" inputtype="output" contenttype="grouplayout">
                    <itemdefinitions>buttonheight=90;metrictext=;separatorcolor=white;bordercolor=transparent;buttonradius=0;backgroundcolor=ff0000;elementcolor=000000;valuetextcolor=000000;</itemdefinitions>
                </item>
                <item caption="Calendar weeks" id="IGHza0Nx" inputtype="input" contenttype="integer" address="C23">
                    <itemdefinitions>backgroundcolor=#ffffff;elementcolor=#09679b;valuetextcolor=#09679b;showeditbuttons=true;minvalue=30;maxvalue=52;metrictext=weeks;groupname=R1K3QWDY;</itemdefinitions>
                </item>
                <item caption="Days / week" id="vFK7E1aX" inputtype="input" contenttype="integer" address="C24">
                    <itemdefinitions>backgroundcolor=#ffffff;elementcolor=#09679b;valuetextcolor=#09679b;showeditbuttons=true;minvalue=1;maxvalue=7;metrictext=days;groupname=R1K3QWDY;</itemdefinitions>
                </item>
                <item id="oTxoL5DC" caption="spacer" inputtype="" contenttype="spacer">
                    <itemdefinitions>height=2;backgroundcolor=transparent;</itemdefinitions>
                </item>
                <item id="tIbLqdDR" caption="tIbLqdDR" inputtype="output" contenttype="grouplayout">
                    <itemdefinitions>buttonheight=90;metrictext=;separatorcolor=white;bordercolor=transparent;buttonradius=0;backgroundcolor=ff0000;elementcolor=000000;valuetextcolor=000000;</itemdefinitions>
                </item>
                <item caption="Bank holidays/year" id="dwUjDrQa" inputtype="input" contenttype="integer" address="C26">
                    <itemdefinitions>backgroundcolor=#ffffff;elementcolor=#09679b;valuetextcolor=#09679b;showeditbuttons=true;metrictext=days;groupname=tIbLqdDR;</itemdefinitions>
                </item>
                <item caption="Hours/shift" id="CvYROgnH" inputtype="input" contenttype="integer" address="C25">
                    <itemdefinitions>backgroundcolor=#ffffff;elementcolor=#09679b;valuetextcolor=#09679b;showeditbuttons=true;metrictext=hours;minvalue=1;maxvalue=10;groupname=tIbLqdDR;</itemdefinitions>
                </item>
                <item id="yZYuBCDb" caption="spacer" inputtype="" contenttype="spacer">
                    <itemdefinitions>height=2;backgroundcolor=transparent;</itemdefinitions>
                </item>
                <item id="iszMSWLf" caption="iszMSWLf" inputtype="output" contenttype="grouplayout">
                    <itemdefinitions>buttonheight=90;metrictext=;separatorcolor=white;bordercolor=transparent;buttonradius=0;backgroundcolor=ff0000;elementcolor=000000;valuetextcolor=000000;</itemdefinitions>
                </item>
                <item caption="Extraordinary repair days/year" id="hywhOMAV" inputtype="input" contenttype="integer" address="C27">
                    <itemdefinitions>backgroundcolor=#ffffff;elementcolor=#09679b;valuetextcolor=#09679b;showeditbuttons=true;metrictext=days;groupname=iszMSWLf;</itemdefinitions>
                </item>
                <item caption="Depreciation period" id="Vx6ugapm" inputtype="input" contenttype="integer" address="C29">
                    <itemdefinitions>backgroundcolor=#ffffff;elementcolor=#09679b;valuetextcolor=#09679b;showeditbuttons=true;metrictext=years;minvalue=1;maxvalue=10;groupname=iszMSWLf;</itemdefinitions>
                </item>
            </items>
        </excelcontent>
    </page>
    <page pageid="5" caption="Charts">
        <excelcontent id="2">
            <items>
                <item id="WmTQj1cP" caption="Acquisition Cost" inputtype="output" contenttype="chart" address="Calculation!A14:B19">
                    <itemdefinitions>height=50%;charttype=bar;xaxiscaption=Investment [in EURO];backgroundcolor=white;seriescolor=214a9a;</itemdefinitions>
                </item>
                <item id="R5FL7Twv" caption="spacer" inputtype="" contenttype="spacer">
                    <itemdefinitions>height=10;backgroundcolor=transparent;</itemdefinitions>
                </item>
                <item id="TcYe4sf3" caption="Occupancy rate" inputtype="output" contenttype="chart" address="Calculation!A14:A19;Calculation!E14:E19">
                    <itemdefinitions>height=50%;charttype=polar;chartorientation=vertical;backgroundcolor=white;seriescolor=214a9a;</itemdefinitions>
                </item>
                <item id="Plk2Fz0N" caption="spacer" inputtype="" contenttype="spacer">
                    <itemdefinitions>height=10;backgroundcolor=transparent;</itemdefinitions>
                </item>
                <item id="862iQT0t" caption="Machine hour rate" inputtype="output" contenttype="chart" address="Calculation!A14:A19;Calculation!A58:B63">
                    <itemdefinitions>height=50%;charttype=bar;chartorientation=vertical;xaxiscaption=Hour rate [in EURO];backgroundcolor=white;seriescolor=346ad3;</itemdefinitions>
                </item>
            </items>
        </excelcontent>
    </page>
</pages>

Card Definitions

cardbackgroundimage=https://api.openasapp.net/v1/api/EntityImageStorage/AppStorage/289a0364-8113-4a6e-8425-caeff6dc85ce/public/cardBackgroundImage-fcdbc6dab4ea465bbab9038be112a6f3.jpeg;cardheight=140;carddescriptionhide=true;cardcaptionbackgroundcolor=#214a9a;cardbackgroundcolor=transparent;captionheight=50;captionopacity=7