{"success":true,"projects":[{"code":"PAN3","location":"13522 Tallinn, Estonia","total_revenue":66464.17,"profit_pct":20.2,"profit_eur":13403.113794879995,"working_hours":739.3,"project_manager":"Kristaps","m2":50.2,"euro_per_m2":1062.66},{"code":"DRE","location":"01069 Dresden, Germany","total_revenue":124500,"profit_pct":20.4,"profit_eur":25360.818112759982,"working_hours":1512.3,"project_manager":"Kaspars","m2":129.54,"euro_per_m2":778.44},{"code":"LUSH","location":"Lush store refurmishment","total_revenue":114002.08,"profit_pct":37.9,"profit_eur":43237.81765632374,"working_hours":781.4,"project_manager":"Alens, Valters","m2":25,"euro_per_m2":3331.64},{"code":"HOK","location":null,"total_revenue":518693.67000000004,"profit_pct":35.6,"profit_eur":184913.64457656452,"working_hours":2551.4,"project_manager":"M\u0101ris, Valters, Alens","m2":null,"euro_per_m2":null},{"code":"FAL2","location":null,"total_revenue":18614.6,"profit_pct":25,"profit_eur":0.32568977521588416,"working_hours":null,"project_manager":"18614.6","m2":null,"euro_per_m2":null},{"code":"STU2","location":"Calzedonia Sture Galerian, Stokholma","total_revenue":44108.473797299164,"profit_pct":50,"profit_eur":22060.16101930181,"working_hours":467.1,"project_manager":"Kaspars","m2":64.78,"euro_per_m2":500.6},{"code":"STU","location":"Intimissimi Sture Galerian, Stokholma","total_revenue":29275,"profit_pct":48.7,"profit_eur":14268.891274851752,"working_hours":359,"project_manager":"Alens","m2":63,"euro_per_m2":348.07},{"code":"FAL","location":"Sweden 04\/09\/2023-02\/10\/2023, 29\/11\/2023-30\/11\/2023","total_revenue":75100.2,"profit_pct":515347,"profit_eur":0.3592871937857776,"working_hours":null,"project_manager":"80253.67","m2":null,"euro_per_m2":null},{"code":"FRO","location":"421 42 V\u00e4stra Fr\u00f6lunda, Sweden  25\/03\/2025-31\/03\/2025","total_revenue":29363.621904112704,"profit_pct":43,"profit_eur":12625.497366178195,"working_hours":166.5,"project_manager":"Alens","m2":null,"euro_per_m2":null},{"code":"TES","location":" TESLA_AU_VIENNA extra works","total_revenue":23000,"profit_pct":41,"profit_eur":9434.8141470628,"working_hours":271,"project_manager":"Kaspars","m2":100,"euro_per_m2":182.23},{"code":"UGG","location":"10178 Berlin, Germany","total_revenue":227968.89,"profit_pct":28.5,"profit_eur":64868.03181646843,"working_hours":1641.3,"project_manager":"Alens, M\u0101ris","m2":163.6,"euro_per_m2":1109.33},{"code":"LIN","location":"Austria, 09\/09\/2024-(22)25\/09\/2024","total_revenue":55000,"profit_pct":21.7,"profit_eur":11960.010960025204,"working_hours":null,"project_manager":"Alens","m2":null,"euro_per_m2":null},{"code":"INS","location":"Austria, 3\/3\/2025-19\/3\/2025","total_revenue":60000,"profit_pct":29.6,"profit_eur":17767.134234020807,"working_hours":223.5,"project_manager":"Alens","m2":null,"euro_per_m2":null},{"code":"KAR","location":"Wienna, Austria","total_revenue":132635,"profit_pct":18,"profit_eur":23933.590710644257,"working_hours":1380.8,"project_manager":"Alens","m2":171.4,"euro_per_m2":637.89},{"code":"PAN2","location":"ULLEMISTE, TALLINN","total_revenue":85024.62000000001,"profit_pct":25.7,"profit_eur":21821.83204592362,"working_hours":969.8,"project_manager":"Kristaps","m2":104.1,"euro_per_m2":642.85},{"code":"LULU","location":"11146 Stockholm, Sweden 06\/05\/2024-28\/06\/2024","total_revenue":630472.08,"profit_pct":35.6,"profit_eur":224740.92526706948,"working_hours":null,"project_manager":"Alens","m2":null,"euro_per_m2":null},{"code":"COL","location":"Intimissimi K\u00d6LN SC RHEIN CENTER, 10\/02\/2025-27\/02\/2025","total_revenue":46000,"profit_pct":25,"profit_eur":11504.17630983999,"working_hours":721.6,"project_manager":"Kaspars","m2":null,"euro_per_m2":null},{"code":"TRI","location":null,"total_revenue":51458.66,"profit_pct":22.8,"profit_eur":11730.219330324007,"working_hours":791.4,"project_manager":"Alens","m2":null,"euro_per_m2":null},{"code":"AKR","location":"Latgales iela 257, 03\/02\/2025-","total_revenue":15496,"profit_pct":22.6,"profit_eur":3502.894446708802,"working_hours":null,"project_manager":"Alens","m2":null,"euro_per_m2":null},{"code":"PAN","location":"Estonia, 10\/3\/2025-31\/3\/2025","total_revenue":67309.81,"profit_pct":13,"profit_eur":8726.001951438397,"working_hours":734.6,"project_manager":"Kaspars","m2":null,"euro_per_m2":null},{"code":"SWA","location":null,"total_revenue":13377.009999999998,"profit_pct":46.6,"profit_eur":6233.227069199999,"working_hours":null,"project_manager":"M\u0101ris","m2":null,"euro_per_m2":null},{"code":"MIL","location":"Piazza San Babila 5, 20122 Milano","total_revenue":683017.73,"profit_pct":30.4,"profit_eur":207302.17449916,"working_hours":184.8,"project_manager":"Alens","m2":297.5,"euro_per_m2":1524.95},{"code":"HOKA","location":"10178 Berlin, Germany","total_revenue":436134.78,"profit_pct":25,"profit_eur":0,"working_hours":null,"project_manager":"Unknown","m2":200,"euro_per_m2":2117.25},{"code":"TRIE","location":"54290 Trier, Germany","total_revenue":49600,"profit_pct":25,"profit_eur":0,"working_hours":null,"project_manager":"Unknown","m2":131.38,"euro_per_m2":310.3},{"code":"FAL_STU3","location":"Falconeri Sture Galerian, Stokholma","total_revenue":32248,"profit_pct":25,"profit_eur":0,"working_hours":null,"project_manager":"Unknown","m2":100,"euro_per_m2":347.73},{"code":"GAL","location":null,"total_revenue":58921.11,"profit_pct":48.5,"profit_eur":28587.266347203204,"working_hours":null,"project_manager":"Alens","m2":null,"euro_per_m2":null},{"code":"HAM","location":"Hamburg, Germania 1\/10\/2024-(22\/10\/2024) 12\/11\/2024","total_revenue":64030.01,"profit_pct":19.2,"profit_eur":12295.06573881679,"working_hours":null,"project_manager":"Kaspars","m2":null,"euro_per_m2":null},{"code":"LULU2","location":"Existing Store Demolition Works, 08\/07-22\/07","total_revenue":24857.66,"profit_pct":37,"profit_eur":9200.768360224396,"working_hours":null,"project_manager":"Alens","m2":null,"euro_per_m2":null},{"code":"KLA","location":"Klaip\u0117da 91182, Lithuania 20\/02\/2024-26\/02\/2024","total_revenue":15752.95,"profit_pct":40.7,"profit_eur":6409.120792932001,"working_hours":null,"project_manager":"Kristaps","m2":null,"euro_per_m2":null},{"code":"WDON","location":"EG 138c 1220 Wien, Austria 04\/03\/2024-17\/03\/2024","total_revenue":43500,"profit_pct":39.9,"profit_eur":17376.150551976003,"working_hours":null,"project_manager":"Mauro","m2":null,"euro_per_m2":null},{"code":"KRE","location":"Austria, 26\/08-08\/09","total_revenue":40000,"profit_pct":31,"profit_eur":12385.828488568,"working_hours":null,"project_manager":"Alexander","m2":null,"euro_per_m2":null},{"code":"MOS","location":null,"total_revenue":55112.34,"profit_pct":31.9,"profit_eur":17607.53080770227,"working_hours":null,"project_manager":"Alens","m2":null,"euro_per_m2":null},{"code":"WIE","location":"Austria, 19\/08-1\/09","total_revenue":39000,"profit_pct":26.1,"profit_eur":10160.962416108,"working_hours":null,"project_manager":"Alens","m2":null,"euro_per_m2":null},{"code":"BRA","location":"Calzedonia and Intimissimi SC SCHLOSS ARKADEN BRAUNSCHWEIG 04\/02\/2024-(02\/03\/2024\/)07\/03\/2024","total_revenue":145868.93,"profit_pct":31.3,"profit_eur":45650.49327489179,"working_hours":null,"project_manager":"Alens","m2":null,"euro_per_m2":null},{"code":"VIL","location":"Austria, 16\/01\/2024-29\/01\/2024","total_revenue":52875.229999999996,"profit_pct":30.8,"profit_eur":16287.724806914397,"working_hours":null,"project_manager":"Mauro","m2":null,"euro_per_m2":null},{"code":"WIE2","location":"1070 Wien, Austria 16\/09-09\/10","total_revenue":83000,"profit_pct":27.6,"profit_eur":22945.769141402387,"working_hours":null,"project_manager":"Alexander","m2":null,"euro_per_m2":null},{"code":"BERG","location":"51465 Bergisch Gladbach, Germany 25\/09\/2024-(22\/10\/2024) 9\/11\/2024","total_revenue":88728.25,"profit_pct":25.7,"profit_eur":22784.271007010015,"working_hours":null,"project_manager":"Alens","m2":null,"euro_per_m2":null},{"code":"MUN","location":"81829 M\u00fcnchen, Germany 19\/08-16\/09","total_revenue":92529.01000000001,"profit_pct":29,"profit_eur":26805.232614245615,"working_hours":null,"project_manager":"Kaspars","m2":null,"euro_per_m2":null},{"code":"KOB","location":"Germany, 23\/01\/2024-19(10)\/02\/2024","total_revenue":55924.07,"profit_pct":22.9,"profit_eur":12795.217800099199,"working_hours":null,"project_manager":"Alex","m2":null,"euro_per_m2":null},{"code":"STO","location":"Riga, 26\/02\/2024- (17\/03\/2024)02\/05\/2024","total_revenue":67761.17,"profit_pct":21.8,"profit_eur":14795.958099999996,"working_hours":null,"project_manager":"M\u0101ris","m2":null,"euro_per_m2":null},{"code":"GRA","location":"Austria, 19\/02\/2024-03\/03\/2024","total_revenue":46715.75,"profit_pct":18.6,"profit_eur":8701.681455042402,"working_hours":null,"project_manager":"Mauro","m2":null,"euro_per_m2":null},{"code":"FRA","location":"15.05.2024-7.07.2024, 08.08.2024-15.08.2024","total_revenue":172086.30000000002,"profit_pct":15.1,"profit_eur":26034.525693312433,"working_hours":null,"project_manager":"Kristaps\/ Kaspars\/Alex","m2":null,"euro_per_m2":null},{"code":"SEI","location":"Austria, 25\/07\/2024-25\/08\/2024","total_revenue":73896.3,"profit_pct":17.1,"profit_eur":12600.498839907603,"working_hours":null,"project_manager":"Alens","m2":null,"euro_per_m2":null},{"code":"MAT","location":"04\/04\/2024-30\/05\/2024, 14\/06\/2024-?","total_revenue":88148.25,"profit_pct":15.5,"profit_eur":13705.655834765596,"working_hours":null,"project_manager":"M\u0101ris\/ Jevg\u0113\u0146ijs","m2":null,"euro_per_m2":null},{"code":"ING","location":"Germany, 2\/08\/2024-22\/08\/2024","total_revenue":62500,"profit_pct":11.5,"profit_eur":7194.1275054656,"working_hours":null,"project_manager":"Alexander","m2":null,"euro_per_m2":null},{"code":"LEI","location":"Calzedonia LEIDEN_HAARLEMERSTRAAT_114, 04\/04\/2024-(08\/05\/2024) 30\/04\/2024","total_revenue":87326.23,"profit_pct":11.2,"profit_eur":9756.839493499996,"working_hours":null,"project_manager":"Alens","m2":null,"euro_per_m2":null},{"code":"OLA","location":"LV-2114, 15\/04\/2024-14\/06\/2024","total_revenue":130911.05,"profit_pct":9.1,"profit_eur":11963.34330225279,"working_hours":null,"project_manager":"Alexander","m2":null,"euro_per_m2":null},{"code":"STK","location":"Stockholm, Calzedonia and Intimissimi  22\/04-28\/04\/2024","total_revenue":7504.45,"profit_pct":7.4,"profit_eur":554.1369624944,"working_hours":null,"project_manager":"Kristaps","m2":null,"euro_per_m2":null},{"code":"SPICE","location":"R\u012bga, 21\/10-?","total_revenue":4728.19,"profit_pct":53.6,"profit_eur":2532.5369690719995,"working_hours":null,"project_manager":"Unknown","m2":null,"euro_per_m2":null},{"code":"Bezpe\u013c\u0146as objekti","location":"Vesuvio","total_revenue":0,"profit_pct":25,"profit_eur":0,"working_hours":null,"project_manager":"Unknown","m2":null,"euro_per_m2":null},{"code":"SWR","location":"Galeria Inno Liege Pl. de la R\u00e9publique Francaise 15B-4000 LIEGE, Belgium","total_revenue":14988.39,"profit_pct":25,"profit_eur":0,"working_hours":null,"project_manager":"Unknown","m2":null,"euro_per_m2":null},{"code":"CALZ MOS","location":"Calzedonia Mall of Scandinavia, 22\/01\/2024-31\/01\/2024","total_revenue":0,"profit_pct":25,"profit_eur":0,"working_hours":null,"project_manager":"Unknown","m2":null,"euro_per_m2":null},{"code":"INT GAL","location":"Intimissimi Stockholm Gallerian, 08\/01\/2024-17\/01\/2024","total_revenue":0,"profit_pct":25,"profit_eur":0,"working_hours":null,"project_manager":"Unknown","m2":null,"euro_per_m2":null},{"code":"SAR2","location":"Germany, 11\/02\/2023-20\/02\/2023","total_revenue":22136.760000000002,"profit_pct":841305,"profit_eur":0.5211622790289717,"working_hours":null,"project_manager":"30549.81","m2":null,"euro_per_m2":null},{"code":"BER","location":"Germany, 29\/05\/2023-16\/06\/2023","total_revenue":75388.43,"profit_pct":1162500,"profit_eur":0.47628972883312387,"working_hours":null,"project_manager":"87013.43","m2":null,"euro_per_m2":null},{"code":"DOR","location":"Calzedonia DORTMUND WESTENHELLWEG 24, 13\/08-28\/08","total_revenue":75736.12,"profit_pct":506940,"profit_eur":0.4661979710643529,"working_hours":null,"project_manager":"80805.51999999999","m2":null,"euro_per_m2":null},{"code":"AMB","location":"Postbank Amberg O0141_PB_KoMiMo_Amberg Kaiser-Ludwig-Ring 9 92224 Amberg, 09\/10\/2023-10\/11\/2023","total_revenue":70300.13,"profit_pct":25,"profit_eur":0.4540222112296655,"working_hours":null,"project_manager":"70300.13","m2":null,"euro_per_m2":null},{"code":"ANT","location":"Belgium, 20\/02\/2023-08\/03\/2023","total_revenue":55889.96,"profit_pct":25,"profit_eur":0.421939761822338,"working_hours":null,"project_manager":"55889.96","m2":null,"euro_per_m2":null},{"code":"MUN2","location":"Flughafen M\u00fcnchen Terminalstr. West 85356\u202fM\u00fcnchen-Flughafen Zentralgeb\u00e4ude, Ebene 03 Raum 330RG","total_revenue":175887.1,"profit_pct":1307646,"profit_eur":0.39103870828957704,"working_hours":null,"project_manager":"188963.56","m2":null,"euro_per_m2":null},{"code":"MAL","location":"215 32 Malm\u00f6, Sweden  17\/04\/2023-09\/05\/2023","total_revenue":71337.13,"profit_pct":452876,"profit_eur":0.3804498141377,"working_hours":null,"project_manager":"75865.89","m2":null,"euro_per_m2":null},{"code":"SIEC","location":"V\u0101cija, 31\/10-27\/11\/2023","total_revenue":79000,"profit_pct":326175,"profit_eur":0.3506791731110449,"working_hours":null,"project_manager":"82261.75","m2":null,"euro_per_m2":null},{"code":"TAL","location":null,"total_revenue":16500,"profit_pct":25,"profit_eur":0.3448278165054545,"working_hours":null,"project_manager":"16500","m2":null,"euro_per_m2":null},{"code":"FUR","location":"90762 F\u00fcrth, Germany","total_revenue":162000,"profit_pct":655500,"profit_eur":0.3326771449028166,"working_hours":null,"project_manager":"168555","m2":null,"euro_per_m2":null},{"code":"ARN","location":null,"total_revenue":60000,"profit_pct":560351,"profit_eur":0.31821468428503275,"working_hours":null,"project_manager":"65603.51","m2":null,"euro_per_m2":null},{"code":"BER2","location":"Alter Spandauer Weg 1 14641 Wustermark Germany, 30\/11\/2023-20\/12\/2023","total_revenue":405955.87,"profit_pct":160000,"profit_eur":0.3145108265393262,"working_hours":null,"project_manager":"407555.87","m2":null,"euro_per_m2":null},{"code":"AUH","location":"Intimissimi and Calzedonia Auhof Center Albert-Schweitzer-Gasse 6, 1140 Wien Austria 22\/08\/2023-05\/09\/2023","total_revenue":86000,"profit_pct":160000,"profit_eur":0.30575780565092747,"working_hours":null,"project_manager":"87600","m2":null,"euro_per_m2":null},{"code":"NEU","location":"Postbank Neumarkt, 30\/05-5\/07\/2023","total_revenue":71273.73000000001,"profit_pct":80000,"profit_eur":0.28825445714623255,"working_hours":null,"project_manager":"72073.73000000001","m2":null,"euro_per_m2":null},{"code":"SIE","location":"V\u0101cija, 18\/09\/2023-24\/09\/2023","total_revenue":14005.39,"profit_pct":25,"profit_eur":0.27540368630330075,"working_hours":null,"project_manager":"14005.39","m2":null,"euro_per_m2":null},{"code":"OFF","location":"Germany, 01\/03\/2023- 06\/04\/2023 (20\/05\/2023!)","total_revenue":158000,"profit_pct":2416630,"profit_eur":0.265798428896288,"working_hours":null,"project_manager":"182166.3","m2":null,"euro_per_m2":null},{"code":"HAL","location":"11  Halle - Saal, 19\/07\/2023-22\/08\/2023","total_revenue":63000,"profit_pct":1029739,"profit_eur":0.15042344488228038,"working_hours":null,"project_manager":"73297.39","m2":null,"euro_per_m2":null},{"code":"SAR","location":"Germany, 11\/01\/2023-14\/02\/2023","total_revenue":64000,"profit_pct":1762174,"profit_eur":0.13518559921133896,"working_hours":null,"project_manager":"81621.73999999999","m2":null,"euro_per_m2":null},{"code":"BOCH","location":null,"total_revenue":225634,"profit_pct":2548118,"profit_eur":0.11103522669334447,"working_hours":null,"project_manager":"251115.18","m2":null,"euro_per_m2":null},{"code":"OLD","location":"Germany, 30\/07-11\/08","total_revenue":38521.98,"profit_pct":243144,"profit_eur":0.10898886633643791,"working_hours":null,"project_manager":"40953.420000000006","m2":null,"euro_per_m2":null},{"code":"TAL2","location":"SC Viru Keskus Viru valjak 406 10111 Tallinn, 23\/10\/21023-23\/11\/2023","total_revenue":94138.97,"profit_pct":2629698,"profit_eur":0.10679868522059069,"working_hours":null,"project_manager":"120435.95","m2":null,"euro_per_m2":null},{"code":"CHA","location":"Sweden, 02\/10-23\/11\/2023","total_revenue":67542.6,"profit_pct":1874260,"profit_eur":0.06217019144135826,"working_hours":null,"project_manager":"86285.20000000001","m2":null,"euro_per_m2":null},{"code":"SW","location":"Zviedrija, 06\/02\/2023-09\/02\/2023","total_revenue":5650,"profit_pct":25,"profit_eur":-0.03004318004247781,"working_hours":null,"project_manager":"5650","m2":null,"euro_per_m2":null},{"code":"MEM","location":"Germany, 09\/07-18\/07","total_revenue":7000,"profit_pct":25,"profit_eur":-0.278701813102857,"working_hours":null,"project_manager":"7000","m2":null,"euro_per_m2":null},{"code":"28","location":"Levi's Outlet Berlin Wustermark Alter Spandauer Weg 1 14641 Wustermark Germany 27\/10\/2023-02\/12\/2023","total_revenue":0,"profit_pct":25,"profit_eur":0,"working_hours":null,"project_manager":"Unknown","m2":null,"euro_per_m2":null},{"code":"FAL (2)","location":"Wastermalm, Sweden  29\/11\/2023-15\/12\/2023","total_revenue":0,"profit_pct":25,"profit_eur":0,"working_hours":null,"project_manager":"Unknown","m2":null,"euro_per_m2":null},{"code":"2025 Dashboard","location":"Project","total_revenue":0,"profit_pct":25,"profit_eur":0,"working_hours":null,"project_manager":"Contract Amount (EUR)","m2":null,"euro_per_m2":null},{"code":"Projects Overview","location":"Project Code","total_revenue":0,"profit_pct":25,"profit_eur":0,"working_hours":null,"project_manager":"Contract Amount (\u20ac)","m2":null,"euro_per_m2":null}],"metadata":{"uploaded_at":"2026-05-06 09:15:49","excel_file":"projects_1778058949_Project Summary 2021-2025.xlsx","project_count":81}}