Difference between revisions of "Excel"

From Blue-IT.org Wiki

Line 4: Line 4:
 
  ActiveCell.FormulaR1C1 = _
 
  ActiveCell.FormulaR1C1 = _
 
  "=CONCATENATE(""0"",TRUNC((RC[-25]-DATE(YEAR(RC[-25]+4-WEEKDAY(RC[-25],2)),1,-9+WEEKDAY(RC[-25],3)))/7),"" / "",YEAR(RC[-25]))"
 
  "=CONCATENATE(""0"",TRUNC((RC[-25]-DATE(YEAR(RC[-25]+4-WEEKDAY(RC[-25],2)),1,-9+WEEKDAY(RC[-25],3)))/7),"" / "",YEAR(RC[-25]))"
 +
 +
=== Open Street Map Hyperlink in Excel ===
 +
 +
Koordinates in E10 and F10 like: "48,9283475" (with comma").
 +
 +
=HYPERLINK("http://www.osm.org/?mlat="&WECHSELN(E10;",";".")&"&mlon="&WECHSELN(F10;",";".")&" & zoom="&E10&"#map=16/"&WECHSELN(RUNDEN(E10;5);",";".")&"/"&WECHSELN(RUNDEN(F10;5);",";".");"Stelle bei OpenStreetMap")
  
 
[[Category:Excel]]
 
[[Category:Excel]]
 
[[Category:Office 2010]]
 
[[Category:Office 2010]]

Revision as of 10:01, 9 July 2014

Kalenderwoche

ActiveCell.FormulaR1C1 = _
"=CONCATENATE(""0"",TRUNC((RC[-25]-DATE(YEAR(RC[-25]+4-WEEKDAY(RC[-25],2)),1,-9+WEEKDAY(RC[-25],3)))/7),"" / "",YEAR(RC[-25]))"

Open Street Map Hyperlink in Excel

Koordinates in E10 and F10 like: "48,9283475" (with comma").

=HYPERLINK("http://www.osm.org/?mlat="&WECHSELN(E10;",";".")&"&mlon="&WECHSELN(F10;",";".")&" & zoom="&E10&"#map=16/"&WECHSELN(RUNDEN(E10;5);",";".")&"/"&WECHSELN(RUNDEN(F10;5);",";".");"Stelle bei OpenStreetMap")