Greasy Fork is available in English.

Munzee Garden Pin Checker

Verify Munzee Garden Pins!

اعتبارا من 13-04-2020. شاهد أحدث إصدار.

المؤلف
Technical-13
التقييمات
0 0 0
الإصدار
2020.04.13.0851ß
تم إنشاؤه
22-10-2018
تم تحديثه
13-04-2020
الترخيص
لا يوجد
ينطبق على

Quick and easy way to check if garden pins are the right type and in the right place!


=IF(AND($H3<>"",$I3<>""),HYPERLINK("https://www.munzee.com/m/"&$H3&"/"&$I3&"/map/?lat="&$D3&"&lon="&$E3&"&type="&$F3&"&name="&SUBSTITUTE($A3,"#","%23"),$H3&"/"&$I3),IF($H3<>"",IF(REGEXMATCH($H3,"50 ?['fF]?([oO]{2})?[tT]?( ?[eE][rR]{2}[oO][rR])?"),HYPERLINK("https://www.munzee.com/map/?sandbox=1&lat="&$D3&"&lon="&$E3&"&name="&SUBSTITUTE($A3,"#","%23"),"SANDBOX"),HYPERLINK("https://www.munzee.com/m/"&$H3&"/",$H3)),""))