UoW #1 — XLS → HTML Dream.ZONE Report

Dream.ZONE — Business Blueprint (Sample)

First working deliverable: a readable HTML report derived from the EUWEB BP model (XLS), aligned to the sample Dream.ZONE output. Next step: automate generation per BB key/email and per city.

Prepared by Nikola Cvetanovski
Sample zone IN / Kolkata
Scope JWT/BP
Back to UoW portal

1) Inputs (from BP model)

sample values hard-coded
State factor (f)
0.058 State f
Country / ISO
India IN
City / People
Kolkata 4.5 M
Dream.ZONE VN
0.522 M€
Chosen project
Master Plan linkable
Price BB
580 €
Purpose: show you can convert the XLS rows into a clean report (HTML). When access is granted, the same structure can be stored under BB key/email and cloned per Dream.ZONE.

2) References (source & sample)

BP model (XLS) EUWEB_BP_model.xls

Used as the numeric/logic source for Dream.ZONE calculations and NFT/NFW rows.

Sample Dream.ZONE (HTML) Kolkata sample

Layout baseline for “INPUT + NFT/NFW table” presentation.

Core proposition JWT_2025_GREEN_Right_for_World

Commercial framing and definitions for NFT/NFW types and BB logic.

Rule respected: no paid tools, no external plugins needed for this prototype. Next step can be done via WP “HTML block” or a simple static page in your assigned URL.

3) Header matrix (as sample)

mirrors sample row
State/IT State State ISO City People M SRC VN (IT) M€ State ZONE VN M€ Choice in Project
State/IT, see bottom India IN Kolkata 4.5 2 0.522 M€ Master Plan
Note: This section mirrors the sample “header row” layout (labels + values + project link).

4) NFT / NFW rows (calculated output)

mirrors the sample
Type Contract 100% Buy 1% BB fee 0.1% BB fee BB IRR(%) Code
Licence €/y
Royalty license
 26100.0 261.0 26.1 2610.0 450 IN_J0_001_L
Sale RP €
Sell right / sale
 1566000.0 15660.0 1566.0 31320.0 5400 IN_J0_001_S
II-SRB €
Income investment
 522000.0 5220.0 522.0 10440.0 1800 IN_J0_001_I
JV-30/21 €
Joint venture
 522000.0 5220.0 522.0 10440.0 1800 IN_J0_001_J
Next automation step (later): read XLS inputs (State f, City, People M, VN, chosen project), compute rows, and output this same HTML per Dream.ZONE and save it under the BB key/email.

5) Context links (Economy / Geography / Orography)

Economy
Search
Placeholder reference link (as in sample).
Geography
Search
Placeholder reference link (as in sample).
Orography
Search
Placeholder reference link (as in sample).