Navigation | Page content | Additional information

Page content
<%@ page import="java.text.DecimalFormat" %> <%@ page import="java.util.Locale" %> <%@ page import="java.text.DecimalFormatSymbols" %> <%@ page import="org.apache.log4j.Logger" %> <%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions" %> <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %> <%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %> <%! static private final Logger logger = Logger.getLogger("/en/exhibitors/stand-rental-calculator/"); %> <% final String currentLang = "en"; final Locale locale = currentLang.equals("de") ? Locale.GERMAN : Locale.ENGLISH; final StringBuilder errorMessage = new StringBuilder(); boolean error = false; double flaecheFrontError = 0; double flaecheTiefeError = 0; double flaecheFrontObenError = 0; double flaecheTiefeObenError = 0; double flaecheFrontNum = 0; double flaecheTiefeNum = 0; double flaecheFrontObenNum = 0; double flaecheTiefeObenNum = 0; String checked0 = ""; String checked1 = ""; String checked2 = ""; String checked3 = ""; String checked4 = ""; String checked5 = ""; double bauOriginal = 0; double bauBasic = 0; double bauPremium = 0; String numberExhibitors = "1"; numberExhibitors = "0"; String numberCompany = "1"; boolean isSquareAdDoubleFloorCheck = true; boolean isBasicRentCheck = true; String strEuro = ""; strEuro = "EUR"; // Formatierung auf zwei Nachkommastellen DecimalFormat df = new DecimalFormat( "###,##0.0" ); if ((request.getParameter("stand") != null) && request.getParameter("stand").equals("0")) { checked0 = "checked"; } else if ((request.getParameter("stand") != null) && request.getParameter("stand").equals("1")) { checked1 = "checked"; } else if ((request.getParameter("stand") != null) && request.getParameter("stand").equals("2")) { checked2 = "checked"; } else if ((request.getParameter("stand") != null) && request.getParameter("stand").equals("3")) { checked3 = "checked"; } else if ((request.getParameter("stand") != null) && request.getParameter("stand").equals("4")) { checked4 = "checked"; } else if ((request.getParameter("stand") != null) && request.getParameter("stand").equals("5")) { checked5 = "checked"; } else { checked0 = "checked"; } String checked00 = ""; String checked01 = ""; String checked02 = ""; String checked03 = ""; boolean bchecked = true; if ((request.getParameter("aussteller") != null) && request.getParameter("aussteller").equals("0") || (request.getParameter("ausstellerH") != null) && request.getParameter("ausstellerH").equals("0")) { checked00 = "checked"; bchecked = false; } if ((request.getParameter("aussteller") != null) && request.getParameter("aussteller").equals("1") || (request.getParameter("ausstellerM") != null) && request.getParameter("ausstellerM").equals("1")) { checked01 = "checked"; bchecked = false; } if(bchecked) { checked00 = "checked"; } if ((request.getParameter("companies") != null) && request.getParameter("companies").equals("0")) { checked02 = "checked"; } else if ((request.getParameter("companies") != null) && request.getParameter("companies").equals("1")) { checked03 = "checked"; } else { } String checkBebauung0 = ""; String checkBebauung1 = ""; String checkBebauung2 = ""; String checkBebauung3 = ""; String checkBebauung4 = ""; if ((request.getParameter("bebauung") != null) && request.getParameter("bebauung").equals("0")) { checkBebauung0 = "checked"; } else if ((request.getParameter("bebauung") != null) && request.getParameter("bebauung").equals("1")) { checkBebauung1 = "checked"; } else if ((request.getParameter("bebauung") != null) && request.getParameter("bebauung").equals("2")) { checkBebauung2 = "checked"; } else if ((request.getParameter("bebauung") != null) && request.getParameter("bebauung").equals("3")) { checkBebauung3 = "checked"; } else if ((request.getParameter("bebauung") != null) && request.getParameter("bebauung").equals("4")) { checkBebauung4 = "checked"; } if (request.getParameter("showResult") != null) { String stand = request.getParameter("stand"); String flaecheFront = request.getParameter("flaecheFront"); String flaecheTiefe = request.getParameter("flaecheTiefe"); String doppelGeschlossig = (request.getParameter("doppelgeschossig") != null && request.getParameter("doppelgeschossig").equals("1")) ? "1" : "0"; String flaecheFrontOben = request.getParameter("flaecheFrontOben"); String flaecheTiefeOben = request.getParameter("flaecheTiefeOben"); numberExhibitors = request.getParameter("numberExhibitors"); numberCompany = request.getParameter("numberCompany"); try { flaecheFrontNum = Double.parseDouble(flaecheFront); } catch(Exception e) { logger.error("xx1 " + e); } try { flaecheTiefeNum = Double.parseDouble(flaecheTiefe); } catch(Exception e) {logger.error("xx2 " + e); } try { flaecheFrontObenNum = Double.parseDouble(flaecheFrontOben); } catch(Exception e) {logger.error("xx3 " + e); } try { flaecheTiefeObenNum = Double.parseDouble(flaecheTiefeOben); } catch(Exception e) {logger.error("xx4 " + e); } if (flaecheFrontNum == 0) { errorMessage.append("Please indicate the width of the stand.
"); flaecheFrontError = 1; error = true; } if (flaecheTiefeNum == 0) { errorMessage.append("Please indicate the depth of the stand.
"); flaecheTiefeError = 1; error = true; } if (doppelGeschlossig.equals("1") && !isSquareAdDoubleFloorCheck) { if (flaecheFrontObenNum == 0) { errorMessage.append("Please indicate the width of the upper floor.
"); flaecheFrontObenError = 1; error = true; } if (flaecheTiefeObenNum == 0) { errorMessage.append("Please indicate the depth of the upper floor.
"); flaecheTiefeObenError = 1; error = true; } } String standBau = ""; double qmAdd = 0; String zuschlagProzent = ""; double flaeche = 0; double flaecheGanzzahl = 0; double grundmiete = 0; double qmPreis = 0; double qmPreisOben = 0; String einheitSQM = "sqm"; double zuschlag = 0; String zuschlagText = ""; boolean doppel = false; double doppelPreis = 0; double flaecheOben = 0; double flaecheObenGanzzahl = 0; boolean coexhibitor = false; double werbeboxPreis = 0; double werbeboxPreis1 = 0; double werbeboxPreis2 = 0; double werbeboxPreisC = 0; double aumaPreis = 0; double nebenkostenPreis = 0; double nettoPreis = 0; double bruttoPreis = 0; double completeStandSqm = 0; double completeStandSqmPrice = 0; double qmPreisBauCompleteOnly = 0; double complete_stand_preis = 0; String completeStandSqmName = ""; if (!error) { // 1. STANDART if (stand.equals("0")) { standBau = "Row stand, one side open"; qmPreis = 70.0; double prozent = 0; prozent = 0; qmAdd = prozent * qmPreis / 100; zuschlagProzent = String.format(locale, "%.2f%%", prozent); } if (stand.equals("1")) { standBau = "Corner stand, two sides open"; qmPreis = 79.0; double prozent = 0; double prozenteuro = 0; prozent = 0; qmAdd = prozent * qmPreis / 100; zuschlagProzent = String.format(locale, "%.2f%%", prozent); } if (stand.equals("2")) { standBau = "Head stand, three sides open"; qmPreis = 89.0; double prozent = 0; double prozenteuro = 0; prozent = 0; qmAdd = prozent * qmPreis / 100; zuschlagProzent = String.format(locale, "%.2f%%", prozent); } if (stand.equals("3")) { standBau = "Block stand, four sides open"; qmPreis = 97.0; double prozent = 0; double prozenteuro = 0; prozent = 0; qmAdd = prozent * qmPreis / 100; zuschlagProzent = String.format(locale, "%.2f%%", prozent); } if (stand.equals("4")) { standBau = "Special show: Grounds Maintenance"; qmPreis = 0; double prozent = 0; prozent = 0; qmAdd = prozent * qmPreis / 100; zuschlagProzent = String.format(locale, "%.2f%%", prozent); } if (stand.equals("5")) { standBau = "Outdoor exhibition space"; qmPreis = 0; double prozent = 0; prozent = 0; qmAdd = prozent * qmPreis / 100; zuschlagProzent = String.format(locale, "%.2f%%", prozent); } // 2. FLÄCHE flaeche = (100 * flaecheFrontNum * flaecheTiefeNum) / 100; flaecheGanzzahl = Math.floor(flaeche); // Grundmiete grundmiete = (100 * flaeche * qmPreis) / 100; // Zuschlag if (!stand.equals("0") && (flaeche <= 400)) { if (flaeche > 0) { zuschlag = ( 100 * qmAdd * 100 ) / 100; //zuschlagText = zuschlagProzent + " " + langProperties.getProperty("for.hundert") + " " + einheitSQM; } else { zuschlag = (100 * qmAdd * flaeche) / 100; //zuschlagText = zuschlagProzent + " " + langProperties.getProperty("for") + " " + flaeche + einheitSQM; } } // 3.Doppelgeschossig if (doppelGeschlossig.equals("1") && !isSquareAdDoubleFloorCheck) { doppel = true; flaecheOben = (100 * flaecheFrontObenNum * flaecheTiefeObenNum) / 100; flaecheObenGanzzahl = Math.floor(flaecheOben); doppelPreis = (100 * flaecheOben * qmPreisOben) / 100; } if (doppelGeschlossig.equals("1") && !isBasicRentCheck) { double basicRent = 0.0; grundmiete = grundmiete + grundmiete*basicRent/100; } if ((request.getParameter("bebauung") != null) && request.getParameter("bebauung").equals("5")) { if(flaeche > 18){ complete_stand_preis = (flaeche * qmPreisBauCompleteOnly); } } // 4.Mitaussteller if ((request.getParameter("aussteller") != null) && request.getParameter("aussteller").equals("1") || (request.getParameter("ausstellerM") != null) && request.getParameter("ausstellerM").equals("1")) { coexhibitor = true; werbeboxPreis = 120.0; } else if ((request.getParameter("aussteller") != null) && request.getParameter("aussteller").equals("0") || (request.getParameter("ausstellerH") != null) && request.getParameter("ausstellerH").equals("0")) { coexhibitor = false; werbeboxPreis = 120.0; } // 5.vertretenen Unternehmen if ((request.getParameter("companies") != null) && request.getParameter("companies").equals("1")) { werbeboxPreisC = 0; } else if ((request.getParameter("companies") != null) && request.getParameter("companies").equals("0")) { werbeboxPreisC = 0.0; } werbeboxPreis1 = werbeboxPreis - 120.0; // 5.AUMA if (doppelGeschlossig.equals("1") && !isSquareAdDoubleFloorCheck) { aumaPreis = (100 * (flaeche + flaecheOben) * 0.6) / 100; } else { aumaPreis = (100 * flaeche * 0.6) / 100; } // Zuzüglich Komplettstand if ((request.getParameter("bebauung") != null) && request.getParameter("bebauung").equals("1")) { completeStandSqm = Double.parseDouble(request.getParameter("bauOriginal")); completeStandSqmPrice = 0; } else if ((request.getParameter("bebauung") != null) && request.getParameter("bebauung").equals("2")) { completeStandSqm = Double.parseDouble(request.getParameter("bauBasic")); completeStandSqmPrice = 0; } else if ((request.getParameter("bebauung") != null) && request.getParameter("bebauung").equals("3")) { completeStandSqm = Double.parseDouble(request.getParameter("bauPremium")); completeStandSqmPrice = 0; } if (request.getParameter("bauBasic") != null) { bauBasic = Double.parseDouble(request.getParameter("bauBasic")); } if (request.getParameter("bauOriginal") != null) { bauOriginal = Double.parseDouble(request.getParameter("bauOriginal")); } if (request.getParameter("bauPremium") != null) { bauPremium = Double.parseDouble(request.getParameter("bauPremium")); } // GesamtPreis nettoPreis = ((grundmiete + zuschlag + doppelPreis + werbeboxPreis + complete_stand_preis + aumaPreis + nebenkostenPreis + (completeStandSqm * completeStandSqmPrice)) * 100)/100; bruttoPreis = (100 * nettoPreis * 1.16) / 100; } nettoPreis=(Math.round(nettoPreis * 100)) / 100.0; pageContext.setAttribute("showResult", true); pageContext.setAttribute("standBau", standBau); pageContext.setAttribute("qmPreis", String.format(locale, "%,.2f", qmPreis)); pageContext.setAttribute("flaeche", String.format(locale, "%,.2f", flaeche)); pageContext.setAttribute("grundmiete", String.format(locale, "%,.2f", grundmiete)); pageContext.setAttribute("doubleArea", String.format(locale, "%,.2f", flaecheOben)); pageContext.setAttribute("doublePrice", String.format(locale, "%,.2f", doppelPreis)); pageContext.setAttribute("doublePriceNumber", doppelPreis); pageContext.setAttribute("zuschlag", String.format(locale, "%,.2f", zuschlag)); pageContext.setAttribute("zuschlagNumber", zuschlag); pageContext.setAttribute("zuschlagPercent", zuschlagProzent); pageContext.setAttribute("complete_stand_preis", String.format(locale, "%,.2f", ((completeStandSqm * completeStandSqmPrice) * 100)/100)); pageContext.setAttribute("hasAuma", (aumaPreis > 0)); pageContext.setAttribute("aumaPreis", String.format(locale, "%,.2f", aumaPreis)); pageContext.setAttribute("hasNebenkosten", (nebenkostenPreis > 0)); pageContext.setAttribute("nebenkostenPreis", String.format(locale, "%,.2f", nebenkostenPreis)); pageContext.setAttribute("hasCoexhibitor", coexhibitor); pageContext.setAttribute("werbeboxPreis", String.format(locale, "%,.2f", werbeboxPreis)); pageContext.setAttribute("werbeboxPreis2", String.format(locale, "%,.2f", werbeboxPreis2)); pageContext.setAttribute("nettoPreis", String.format(locale, "%,.2f", nettoPreis)); pageContext.setAttribute("stand", stand); pageContext.setAttribute("is100", (flaeche < 100)); pageContext.setAttribute("completeStandSqmPrice", String.format(locale, "%,.2f", ((flaeche * completeStandSqmPrice) * 100)/100)); } else { pageContext.setAttribute("showResult", false); } pageContext.setAttribute("checked0", checked0); pageContext.setAttribute("checked1", checked1); pageContext.setAttribute("checked2", checked2); pageContext.setAttribute("checked3", checked3); pageContext.setAttribute("checked4", checked4); pageContext.setAttribute("checked5", checked5); pageContext.setAttribute("checked00", checked00); pageContext.setAttribute("checked01", checked01); pageContext.setAttribute("checked02", checked02); pageContext.setAttribute("checked03", checked03); pageContext.setAttribute("checkBebauung0", checkBebauung0); pageContext.setAttribute("checkBebauung1", checkBebauung1); pageContext.setAttribute("checkBebauung2", checkBebauung2); pageContext.setAttribute("checkBebauung3", checkBebauung3); pageContext.setAttribute("checkBebauung4", checkBebauung4); pageContext.setAttribute("error", error); pageContext.setAttribute("errorMsg", errorMessage.toString()); pageContext.setAttribute("flaecheFrontErr", flaecheFrontError); pageContext.setAttribute("flaecheTiefeErr", flaecheTiefeError); pageContext.setAttribute("flaecheFrontObenErr", flaecheFrontObenError); pageContext.setAttribute("flaecheTiefeObenErr", flaecheTiefeObenError); pageContext.setAttribute("doppelgeschossig", ((request.getParameter("doppelgeschossig") != null) && request.getParameter("doppelgeschossig").equals("1")) ? "checked" : ""); pageContext.setAttribute("flaecheFront", flaecheFrontNum); pageContext.setAttribute("flaecheFrontOben", flaecheFrontObenNum); pageContext.setAttribute("flaecheTiefe", flaecheTiefeNum); pageContext.setAttribute("flaecheTiefeOben", flaecheTiefeObenNum); pageContext.setAttribute("bauOriginal", bauOriginal); pageContext.setAttribute("bauBasic", bauBasic); pageContext.setAttribute("bauPremium", bauPremium); pageContext.setAttribute("numberExhibitors", numberExhibitors); pageContext.setAttribute("numberCompany", numberCompany); pageContext.setAttribute("zero", df.format(0)); %>

${title}

${subtitle}

  • Stand shape: ${standBau} (Basic costs: ${qmPreis} ${euro}/sqm)
  • Stand size: ${flaeche} sqm
  • Basic space cost: ${grundmiete} ${euro}
  • Surcharges for two-storeyed buildings: ${doublePrice} ${euro}
  • Complete Stand "Classic Version" ${completeStandSqmPrice} ${euro} (${qmPreisBauOriginalValue} ${vat})
  • Complete Stand "Basic Version" ${completeStandSqmPrice} ${euro} (${qmPreisBauBasicValue} ${vat})
  • Complete Stand "Special Version" ${completeStandSqmPrice} ${euro} (${qmPreisBauPremiumValue} ${vat})
  • Complete stand: ${complete_stand_preis} ${euro} 750.00 HKD/m²
  • AUMA fee: ${aumaPreis} ${euro} (${aumaValue} ${euro}/sqm)
  • Nebenkostenpauschale: ${nebenkostenPreis} ${euro} (${nebenkostenValue} ${euro}/sqm)
  • Promotion package:
    • ${werbeboxBasicPreis} ${euro}
    • ${werbeboxBasicPreisMA} ${euro}
    ${promDynLabel} ${werbeboxPreis} ${euro}

Total net: ${nettoPreis} ${euro} 
plus statutory VAT

Please check your input.

${errorMsg}

Stand Rental Calculator

${selectionLabel}

The stand rental price includes the consumption of electricity and water. Surcharge calculated for areas up to 100 sqm. The surcharges for row stand, corner stand, peninsula stand and island stand are above the stand rental calculator.

Desired stand size

Odd numbers please "." specify. For example, 6.5 x 7.3

Please indicate the width of the stand.

Please indicate the depth of the stand.

Compulsory surcharges

Promotion package:


(All fees invoiced to primary exhibitor)

AUMA:

AUMA fee: 0.60 plus VAT
Nebenkostenpauschale: ${nebenkostenValue} EUR/m² netto obligatorisch

No responsibility is taken for the correctness of this information.