Lizenzkalkulator für Salesperformer

Link to the app
https://oaa.app.link/launch-app-6384b782-cf89-428d-95e4-a851f9d27bb8

Excel file for this app
https://oaadata.blob.core.windows.net/app-6384b782-cf89-428d-95e4-a851f9d27bb8/data.xlsx

📘

Printsheet

The app definition "printsheet=Angebot;" sets the worksheet "Angebot" as printsheet. The printsheet contains data from the calculation as well as data from the form on page two of the app.

640640

"Lizenzkalkulator für Salesperformer" Calculation

640640

"Lizenzkalkulator für Salesperformer" Form for Printsheet

640640

"Lizenzkalkulator für Salesperformer" Print functionality

App Definitions

menuentries=send,print;pagecount=2;printsheet=Angebot;pagebuttoncolor=384042;topareaheight=100;spacing=0;paddingvert=10;functionbuttoncolor=C4CD3F;allowpushtoserver=true

Raw XML Configuration

<?xml version="1.0" encoding="utf-8"?>
<pages>
    <page caption="Dateneingabe" pageid="1" definitions="">
        <excelcontent id="xxx">
            <items>
                <item id="s1" caption="spacer" contenttype="spacer" inputtype="">
                    <itemdefinitions>height=3%;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="Anzahl Windows Lizenzen" contenttype="integer" inputtype="input" address="A3">
                    <itemdefinitions>minvalue=0;deltastep=1;metrictext=Anzahl;buttonheight=15%;separatorcolor=D5D5D5;bordercolor=transparent;backgroundcolor=transparent;valuetextcolor=E0E073;elementcolor=E0E073;showeditbuttons=true;</itemdefinitions>
                </item>
                <item id="noMobileLicenses" caption="Anzahl Mobile Lizenzen" contenttype="integer" inputtype="input" address="A4">
                    <itemdefinitions>minvalue=0;deltastep=1;metrictext=Anzahl;buttonheight=15%;bordercolor=transparent;backgroundcolor=transparent;valuetextcolor=E0E073;elementcolor=E0E073;showeditbuttons=true;</itemdefinitions>
                </item>
                <item id="discount" caption="Partnerrabatt" contenttype="percent" inputtype="input" address="A8">
                    <itemdefinitions>minvalue=0;deltastep=10;metrictext=in %;buttonheight=12%;buttonradius=0;backgroundcolor=#cbcbcb;valuetextcolor=#ffffff;elementcolor=#ffffff;showeditbuttons=true;</itemdefinitions>
                </item>
                <item caption="Wartungsmonate in diesem Jahr" contenttype="integer" inputtype="input" address="A11">
                    <itemdefinitions>minvalue=0;deltastep=1;metrictext=in Monaten;buttonheight=12%;buttonradius=0;backgroundcolor=#d5d5d5;valuetextcolor=#ffffff;elementcolor=#ffffff;showeditbuttons=true;</itemdefinitions>
                </item>
                <item id="priceLicenses" caption="Lizenzkosten" contenttype="integer" inputtype="output" address="C9">
                    <itemdefinitions>buttonheight=12%;metrictext=in Euro;bordercolor=transparent;buttonradius=0;backgroundcolor=CED23C;showeditbuttons=true;</itemdefinitions>
                </item>
                <item id="priceMaintenance" caption="Wartungskosten" contenttype="integer" inputtype="output" address="C14">
                    <itemdefinitions>buttonheight=12%;metrictext=in Euro;bordercolor=transparent;buttonradius=0;backgroundcolor=D6D74F;showeditbuttons=true;</itemdefinitions>
                </item>
                <item id="priceNetto" caption="Netto" contenttype="integer" inputtype="output" address="C16">
                    <itemdefinitions>buttonheight=12%;metrictext=in Euro;bordercolor=transparent;buttonradius=0;backgroundcolor=CED23C;showeditbuttons=true;</itemdefinitions>
                </item>
                <item id="priceTax" caption="MwSt" contenttype="integer" inputtype="output" address="C17">
                    <itemdefinitions>buttonheight=12%;metrictext=in Euro;bordercolor=transparent;buttonradius=0;backgroundcolor=D6D74F;showeditbuttons=true;</itemdefinitions>
                </item>
                <item id="priceTotal" caption="Gesamt" contenttype="integer" inputtype="output" address="C18">
                    <itemdefinitions>buttonheight=16%;metrictext=in Euro;bordercolor=transparent;buttonradius=0;backgroundcolor=CED23C;showeditbuttons=true;</itemdefinitions>
                </item>
            </items>
        </excelcontent>
    </page>
    <page caption="Angebot erstellen" pageid="2" definitions="">
        <excelcontent id="xxx1">
            <items>
                <item id="s2" caption="spacer" contenttype="spacer" inputtype="">
                    <itemdefinitions>height=3%;</itemdefinitions>
                </item>
                <item id="textCompany" caption="Firmenname" contenttype="string" inputtype="input" address="B26">
                    <itemdefinitions>buttonheight=80;metrictext=;bordercolor=transparent;buttonradius=0;backgroundcolor=transparent;separatorcolor=D5D5D5;valuetextcolor=E0E073;valuefontsize=18;</itemdefinitions>
                </item>
                <item id="textAddress" caption="Adresse" contenttype="string" inputtype="input" address="B27">
                    <itemdefinitions>buttonheight=80;metrictext=;bordercolor=transparent;buttonradius=0;backgroundcolor=transparent;separatorcolor=D5D5D5;valuetextcolor=E0E073;valuefontsize=18;</itemdefinitions>
                </item>
                <item id="textPerson" caption="Ansprechpartner" contenttype="string" inputtype="input" address="B28">
                    <itemdefinitions>buttonheight=80;metrictext=;bordercolor=transparent;buttonradius=0;backgroundcolor=transparent;valuetextcolor=E0E073;valuefontsize=18;</itemdefinitions>
                </item>
                <item id="s3" caption="spacer" contenttype="spacer" inputtype="">
                    <itemdefinitions>height=5%;</itemdefinitions>
                </item>
                <item id="g1" caption="group1" contenttype="grouplayout" inputtype="output">
                    <itemdefinitions>buttonheight=120;paddingleft=14;paddingright=14;separatorcolor=white;bordercolor=transparent;backgroundcolor=transparent;</itemdefinitions>
                </item>
                <item id="bt1" caption="Angebot erstellen" contenttype="" inputtype="actionbutton" address="">
                    <itemdefinitions>buttonheight=120;metrictext=;bordercolor=transparent;valuefontsize=22;backgroundcolor=CED23C;actioninfo=print;groupname=group1;</itemdefinitions>
                </item>
                <item id="bt2" caption="Vergleich mit Wettbewerb" contenttype="" inputtype="actionbutton" address="">
                    <itemdefinitions>buttonheight=120;metrictext=;bordercolor=transparent;valuefontsize=22;buttonradius=0;backgroundcolor=D5D5D5;runapp=4cfd49bc-95a6-4e0d-966e-8fa91005101e;groupname=group1;</itemdefinitions>
                </item>
                <item id="g2" caption="group2" contenttype="grouplayout" inputtype="output">
                    <itemdefinitions>buttonheight=120;paddingleft=14;paddingright=14;separatorcolor=transparent;bordercolor=transparent;backgroundcolor=transparent;</itemdefinitions>
                </item>
                <item id="b3" caption="" contenttype="" inputtype="actionbutton" address="">
                    <itemdefinitions>buttonheight=120;metrictext=;bordercolor=transparent;valuefontsize=22;buttonradius=0;backgroundcolor=transparent;groupname=group2;</itemdefinitions>
                </item>
                <item id="b4" caption="An Innendienst weiterleiten" contenttype="" inputtype="actionbutton" address="">
                    <itemdefinitions>buttonheight=120;metrictext=;bordercolor=transparent;valuefontsize=22;buttonradius=0;backgroundcolor=D5D5D5;groupname=group2;</itemdefinitions>
                </item>
            </items>
        </excelcontent>
    </page>
</pages>

Card Definitions

cardbackgroundimage=http://www.wunderapps.net/brandings/hubs/salesperformer_calculator.png;cardbackgroundopacity=3;cardbackgroundcolor=B2C900;captionheight=50;captionopacity=8;cardcaptionbackgroundcolor=#2896d1;cardheight=160;carddescriptionhide=false