Kanban Calculator

Link to this app
https://oaa.app.link/launch-app-56e6b973-ee82-47b2-8911-a5fb92b51f00

Excel file for this app
https://api.openasapp.net/v1/api/EntityStorage/AppStorage/56e6b973-ee82-47b2-8911-a5fb92b51f00/data.xlsx

501501

"Kanban Calculator"

App Definitions

backgroundcolor=white;topareaheight=30%;paddinghorz=0;paddingvert=0;functionbuttoncolor=#e9823a;headeropacity=4;topareaimage=https://api.openasapp.net/v1/api/EntityImageStorage/AppStorage/56e6b973-ee82-47b2-8911-a5fb92b51f00/public/topAreaImage-11c7f73e65e041769877d2b76969bf8c.jpeg;pagecount=2

Raw XML Configuration

<?xml version="1.0" encoding="utf-8"?>
<pages
    xmlns="urn:WunderApp">
    <page pageid="1" caption="Calculator" definitions="sheetname=KANBAN;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="BVukrocV" caption="Order lead-time" inputtype="input" contenttype="integer" address="B5">
                    <itemdefinitions>backgroundcolor=#ffffff;buttonheight=12%;elementcolor=#09679b;valuetextcolor=#09679b;</itemdefinitions>
                </item>
                <item id="3gmdZo75" caption="spacer" inputtype="" contenttype="spacer">
                    <itemdefinitions>height=2;backgroundcolor=09679b;</itemdefinitions>
                </item>
                <item id="2SLfBmoT" caption="Transit lead-time" inputtype="input" contenttype="integer" address="B6">
                    <itemdefinitions>backgroundcolor=white;buttonheight=12%;elementcolor=09679B;valuetextcolor=09679B;</itemdefinitions>
                </item>
                <item id="0GmUJibL" caption="spacer" inputtype="" contenttype="spacer">
                    <itemdefinitions>height=2;backgroundcolor=09679b;</itemdefinitions>
                </item>
                <item id="0aWsrqJr" caption="Internal lead-time" inputtype="input" contenttype="integer" address="B7">
                    <itemdefinitions>backgroundcolor=white;buttonheight=12%;elementcolor=09679B;valuetextcolor=09679B;</itemdefinitions>
                </item>
                <item id="bK3NV6WE" caption="spacer" inputtype="" contenttype="spacer">
                    <itemdefinitions>height=2;backgroundcolor=#09679b;</itemdefinitions>
                </item>
                <item id="4KhSggFF" caption="Container qty" inputtype="input" contenttype="integer" address="B8">
                    <itemdefinitions>backgroundcolor=white;buttonheight=12%;elementcolor=09679B;valuetextcolor=09679B;</itemdefinitions>
                </item>
                <item id="YhBQGvOb" caption="spacer" inputtype="" contenttype="spacer">
                    <itemdefinitions>height=2;backgroundcolor=09679b;</itemdefinitions>
                </item>
                <item id="NtTGSnkI" caption="Daily demand" inputtype="input" contenttype="integer" address="B9">
                    <itemdefinitions>backgroundcolor=white;buttonheight=12%;elementcolor=09679B;valuetextcolor=09679B;</itemdefinitions>
                </item>
                <item id="QIXNZPg3" caption="spacer" inputtype="" contenttype="spacer">
                    <itemdefinitions>height=2;backgroundcolor=09679b;</itemdefinitions>
                </item>
                <item id="al9i5jMp" caption="Daily demand variation" inputtype="input" contenttype="integer" address="B10">
                    <itemdefinitions>backgroundcolor=white;buttonheight=12%;elementcolor=09679B;valuetextcolor=09679B;</itemdefinitions>
                </item>
                <item id="ArSJHcYl" caption="spacer" inputtype="" contenttype="spacer">
                    <itemdefinitions>height=2;backgroundcolor=09679b;</itemdefinitions>
                </item>
                <item id="PTNmd8gL" caption="Reorder/lot size" inputtype="input" contenttype="integer" address="B11">
                    <itemdefinitions>backgroundcolor=white;buttonheight=12%;elementcolor=09679B;valuetextcolor=09679B;</itemdefinitions>
                </item>
                <item id="yjmWrXFZ" caption="spacer" inputtype="" contenttype="spacer">
                    <itemdefinitions>height=2;backgroundcolor=09679b;</itemdefinitions>
                </item>
                <item id="PG4dmDBL" caption="PG4dmDBL" inputtype="output" contenttype="grouplayout">
                    <itemdefinitions>buttonheight=90;metrictext=;separatorcolor=e9823a;bordercolor=transparent;buttonradius=0;backgroundcolor=ff0000;elementcolor=000000;valuetextcolor=000000;</itemdefinitions>
                </item>
                <item id="B2gW69oM" caption="Total Leadtime" inputtype="output" contenttype="result" address="B13">
                    <itemdefinitions>nocaption=true;buttonheight=12%;buttonradius=0;backgroundcolor=#09679b;usecellformat=true;elementcolor=#ffffff;valuetextcolor=#ffffff;groupname=PG4dmDBL;</itemdefinitions>
                </item>
                <item id="D6HIIY1C" caption="Daily demand + Variation" inputtype="output" contenttype="result" address="B14">
                    <itemdefinitions>nocaption=true;buttonheight=12%;buttonradius=0;backgroundcolor=#09679b;usecellformat=true;elementcolor=#ffffff;valuetextcolor=#ffffff;groupname=PG4dmDBL;</itemdefinitions>
                </item>
                <item id="e5SMt9jf" caption="spacer" inputtype="" contenttype="spacer">
                    <itemdefinitions>height=1;backgroundcolor=#e9823a;</itemdefinitions>
                </item>
                <item id="qDH6gbmL" caption="# Kanban Cards" inputtype="output" contenttype="result" address="B16">
                    <itemdefinitions>nocaption=true;buttonheight=20%;buttonradius=0;backgroundcolor=#06476b;usecellformat=true;elementcolor=#ffffff;valuetextcolor=#ffffff;</itemdefinitions>
                </item>
                <item id="ixBRuZj4" caption="spacer" inputtype="" contenttype="spacer">
                    <itemdefinitions>height=2;backgroundcolor=#e9823a;</itemdefinitions>
                </item>
                <item id="rTbPqzua" caption="rTbPqzua" inputtype="output" contenttype="grouplayout">
                    <itemdefinitions>buttonheight=90;metrictext=;separatorcolor=white;bordercolor=transparent;buttonradius=0;backgroundcolor=ff0000;elementcolor=000000;valuetextcolor=000000;</itemdefinitions>
                </item>
                <item id="ys3CJSbE" caption="Max Qty on Hand" inputtype="output" contenttype="result" address="B18">
                    <itemdefinitions>nocaption=true;buttonheight=12%;buttonradius=0;backgroundcolor=#09679b;usecellformat=true;elementcolor=#ffffff;valuetextcolor=#ffffff;groupname=rTbPqzua;</itemdefinitions>
                </item>
                <item id="D85Q7DCR" caption="# Days on Hand" inputtype="output" contenttype="result" address="B19">
                    <itemdefinitions>nocaption=true;buttonheight=12%;buttonradius=0;backgroundcolor=09679B;usecellformat=true;elementcolor=white;valuetextcolor=white;groupname=rTbPqzua;</itemdefinitions>
                </item>
                <item id="hLlaFrRh" caption="Board Area Indicator" contenttype="header">
                    <itemdefinitions>height=5%;backgroundcolor=#6a8c9c;textcolor=white;textfontsize=21;metrictext=# of Cards;</itemdefinitions>
                </item>
                <item id="NQDPgyfC" caption="NQDPgyfC" inputtype="output" contenttype="grouplayout">
                    <itemdefinitions>buttonheight=90;metrictext=;separatorcolor=white;bordercolor=transparent;buttonradius=0;backgroundcolor=ff0000;elementcolor=000000;valuetextcolor=000000;</itemdefinitions>
                </item>
                <item id="wnUzR3Wq" caption="Green" inputtype="output" contenttype="result" address="B22">
                    <itemdefinitions>nocaption=true;buttonheight=12%;buttonradius=0;backgroundcolor=#14b21b;usecellformat=true;elementcolor=#ffffff;valuetextcolor=#ffffff;groupname=NQDPgyfC;</itemdefinitions>
                </item>
                <item id="SAwPrZeZ" caption="Yellow" inputtype="output" contenttype="result" address="B23">
                    <itemdefinitions>nocaption=true;buttonheight=12%;buttonradius=0;backgroundcolor=#e7e93a;usecellformat=true;elementcolor=#ffffff;valuetextcolor=#ffffff;groupname=NQDPgyfC;</itemdefinitions>
                </item>
                <item id="FKXE5b2l" caption="Red" inputtype="output" contenttype="result" address="B24">
                    <itemdefinitions>nocaption=true;buttonheight=12%;buttonradius=0;backgroundcolor=#e93d3a;usecellformat=true;elementcolor=#ffffff;valuetextcolor=#ffffff;groupname=NQDPgyfC;</itemdefinitions>
                </item>
            </items>
        </excelcontent>
    </page>
    <page pageid="2" caption="Explanations">
        <excelcontent id="2">
            <items>
                <item id="vNZkhh9G" contenttype="cardlist" address="KANBAN!A29:B36">
                    <itemdefinitions>componentname=list;padding=4;height=60%;gridrowheight=40;gridcollapsegroups=false;gridallowedit=false;headeravailable=false;showcolumnheader=false;showsearchpanel=false;listcolumns=1;detailcolumns=1,2;</itemdefinitions>
                </item>
            </items>
        </excelcontent>
    </page>
</pages>

Card Definitions

cardheight=140;carddescriptionhide=true;cardcaptionbackgroundcolor=#09679b;cardbackgroundcolor=transparent;captionheight=50;captionopacity=8;cardbackgroundimage=https://api.openasapp.net/v1/api/EntityImageStorage/AppStorage/56e6b973-ee82-47b2-8911-a5fb92b51f00/public/cardBackgroundImage.jpeg?v=JAOugWgw