Find The Distance Between Two Locations

* Latitude and Longitude are measured with degrees

ACOS( SIN(lat1*PI()/180)*
SIN(lat2*PI()/180) + 
COS(lat1*PI()/180)*
COS(lat2*PI()/180)*
COS(lon2*PI()/180-lon1*PI()/180) ) * 6371000


[I used this formula to check the distance between two locations when I created a Field Mobile PowerApps]


Photos credited to their respective owners

Popular posts from this blog

Connect To a Wireless Display Using a Desktop Shortcut

Image
For connecting to external devices, you can use the Win + K shortcut to open the "Connect" pane. However, if you often forget this key combination, you can create a more accessible shortcut to open the device discovery settings directly. 1) Create a New Shortcut Right-click on your Desktop. Select New > Shortcut . 2) Type the location of the item      % windir%\explorer.exe ms-settings-connectabledevices:devicediscovery 3) Name the Shortcut 4) Customize the Shortcut Icon (Optional) Right-click on the newly created shortcut and choose Properties. Click on the Shortcut tab and then click Change Icon. Select an icon that suits your preference or browse for a custom one. Now, you can double-click the shortcut on your desktop to quickly access the "Connect to a Wireless Display" feature.
Read more

Manage Outlook Data File Size in Windows

Image
The default data file size in Outlook for Windows depends on the version of Outlook you're using: Outlook 2010 and Later (Unicode format): The default maximum size is 50 GB Outlook 2007 and 2003 (Unicode format - if applicable): The default maximum size is 20 GB These are the default limits, but it's possible to configure a larger or smaller maximum size by editing the Windows registry. Steps to Increase Outlook Data File Size: 1) Open the Registry Editor: ·        Press Windows + R, type regedit, and press Enter.  2) Navigate to the Registry Path: ·        For Outlook 2016, 2019, and Office 365: HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Outlook\PST ·        For Outlook 2013: HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Outlook\PST ·        For Outlook 2010: HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Outlook\PST   3) Cr...
Read more

Helpdesk Ticket System with Power Apps

Image
In today’s fast-paced workplace, a reliable and efficient Helpdesk system is essential for resolving issues quickly and maintaining smooth operations. To address this need, I built a Helpdesk Ticket System using Power Apps, designed to provide an intuitive experience for both users and administrators. This application includes three primary pages: Login, Dashboard, and Create Ticket. 1. Login Page The system begins with a login page offering two roles: • Login as User • Login as Admin By selecting their role, users are directed to the corresponding dashboard with features tailored to their needs. 2. Dashboard The second page is the Dashboard, which offers different functionalities based on the user’s role: For Admins: Admins have access to a comprehensive overview of all tickets submitted by users. The dashboard categorizes tickets into three statuses: • Not Started • In Progress • Complete Admins can view the total count of tickets for each status, mak...
Read more