Minh AI BY GEOVIL

Excel formulas

27 formulas you type like any Excel function. None of them uses your AI allowance.

1. Type =MINH.In any cell. Excel lists every formula with what it does.
2. Or click FormulasIn the Minh AI tab of the ribbon: the list by use, with an Insert button.
3. Try the example sheetOn the Formulas page, "Create an example sheet" shows every formula working.

Locate addresses

Uses your monthly allowance of new addresses (addresses already found are free).

=MINH.LAT(address, country?)

Latitude of an address.

  • address: An address or place (text), or GPS coordinates written "48.8566, 2.3522".
  • country (optional): Optional. Country to search in (name or code, e.g. France or FR). Leave empty to search worldwide.

Example: =MINH.LAT("10 Downing Street, London")

=MINH.LNG(address, country?)

Longitude of an address.

  • address: An address or place (text), or GPS coordinates written "48.8566, 2.3522".
  • country (optional): Optional. Country to search in (name or code, e.g. France or FR). Leave empty to search worldwide.

Example: =MINH.LNG("10 Downing Street, London")

=MINH.LATLNG(address, country?)

Latitude and longitude of an address, in two cells side by side.

  • address: An address or place (text), or GPS coordinates written "48.8566, 2.3522".
  • country (optional): Optional. Country to search in (name or code, e.g. France or FR). Leave empty to search worldwide.

Example: =MINH.LATLNG(A2)

=MINH.ADDRESS(address, country?)

The full address Minh AI found (to check it is the right place).

  • address: An address or place (text), or GPS coordinates written "48.8566, 2.3522".
  • country (optional): Optional. Country to search in (name or code, e.g. France or FR). Leave empty to search worldwide.

Example: =MINH.ADDRESS("tour eiffel")

=MINH.GEOSTATUS(address, country?)

How sure the location is: Verified, To review or Not found.

  • address: An address or place (text), or GPS coordinates written "48.8566, 2.3522".
  • country (optional): Optional. Country to search in (name or code, e.g. France or FR). Leave empty to search worldwide.

Example: =MINH.GEOSTATUS(A2)

Distances & travel

Straight-line results are free. Road distance and travel time need the Pro plan.

=MINH.DISTANCE(from, to, unit?)

Straight-line distance between two places, in km (or miles).

  • from: An address or place (text), or GPS coordinates written "48.8566, 2.3522".
  • to: An address or place (text), or GPS coordinates written "48.8566, 2.3522".
  • unit (optional): Optional. "km" (default) or "mi".

Example: =MINH.DISTANCE(A2, B2)

=MINH.ROADKM(from, to) PRO

Distance by road between two places, in km. Pro plan.

  • from: An address or place (text), or GPS coordinates written "48.8566, 2.3522".
  • to: An address or place (text), or GPS coordinates written "48.8566, 2.3522".

Example: =MINH.ROADKM(A2, B2)

=MINH.TRAVELTIME(from, to) PRO

Driving time between two places, in minutes. Pro plan.

  • from: An address or place (text), or GPS coordinates written "48.8566, 2.3522".
  • to: An address or place (text), or GPS coordinates written "48.8566, 2.3522".

Example: =MINH.TRAVELTIME(A2, B2)

=MINH.NEAREST(place, list)

The closest place in a list, and its distance in km (two cells).

  • place: An address or place (text), or GPS coordinates written "48.8566, 2.3522".
  • list: The places to compare: one column of addresses, or two columns (name, address).

Example: =MINH.NEAREST(A2, Technicians!B2:B20)

=MINH.WITHIN(place, center, radius_km)

TRUE if a place is within a given distance of a center.

  • place: An address or place (text), or GPS coordinates written "48.8566, 2.3522".
  • center: An address or place (text), or GPS coordinates written "48.8566, 2.3522".
  • radius_km: Radius in km.

Example: =MINH.WITHIN(A2, "Lyon", 30)

=MINH.MIDPOINT(from, to)

The point halfway between two places (latitude, longitude): a fair meeting point.

  • from: An address or place (text), or GPS coordinates written "48.8566, 2.3522".
  • to: An address or place (text), or GPS coordinates written "48.8566, 2.3522".

Example: =MINH.MIDPOINT(A2, B2)

=MINH.DIRECTION(from, to)

Compass direction from one place to another (N, NE, E…).

  • from: An address or place (text), or GPS coordinates written "48.8566, 2.3522".
  • to: An address or place (text), or GPS coordinates written "48.8566, 2.3522".

Example: =MINH.DIRECTION("Paris", "Lyon")

Map links

Free. No allowance used.

GPS coordinates

Free. Computed in Excel, nothing is sent.

=MINH.TODMS(lat, lng)

Writes decimal GPS coordinates as degrees, minutes, seconds.

  • lat: Latitude.
  • lng: Longitude.

Example: =MINH.TODMS(48.8566, 2.3522)

=MINH.FROMDMS(text)

Reads coordinates written in degrees, minutes, seconds and returns latitude, longitude.

  • text: e.g. 48°51'24"N 2°21'08"E

Example: =MINH.FROMDMS("48°51'24""N 2°21'08""E")

=MINH.GEOHASH(lat, lng, precision?)

Short code for a GPS position: rows with the same start are close to each other.

  • lat: Latitude.
  • lng: Longitude.
  • precision (optional): Optional. Length of the code, 1 to 12 (default 7, about 150 m).

Example: =MINH.GEOHASH(48.8566, 2.3522)

Clean & check data

Free. Computed in Excel, nothing is sent.

=MINH.CLEANADDRESS(text)

Tidies an address: spaces, capitals, common abbreviations.

  • text: The address to clean.

Example: =MINH.CLEANADDRESS("12 bd victor hugo ,PARIS")

=MINH.POSTCODE(text, country?)

Finds the postcode in a text.

  • text: Text containing an address.
  • country (optional): Optional. Country, to read its postcode format (FR, GB, US, NL…).

Example: =MINH.POSTCODE("12 rue de Rivoli 75004 Paris")

=MINH.COUNTRYCODE(country)

Two-letter country code from a country name (France → FR).

  • country: Country name, in English or French.

Example: =MINH.COUNTRYCODE("Allemagne")

=MINH.PHONE(text, country?)

Finds a phone number in a text and writes it in international format (+33…).

  • text: Text containing a phone number.
  • country (optional): Optional. Country of numbers written without +, e.g. FR.

Example: =MINH.PHONE("call 06 12 34 56 78", "FR")

=MINH.EMAIL(text)

Finds the first email address in a text.

  • text: Any text.

Example: =MINH.EMAIL(A2)

=MINH.ISEMAIL(text)

TRUE if the cell is a well-formed email address.

  • text: The value to check.

Example: =MINH.ISEMAIL(A2)

=MINH.ISIBAN(iban)

TRUE if an IBAN is valid (checks its control digits).

  • iban: The IBAN to check.

Example: =MINH.ISIBAN(A2)

=MINH.ISSIRET(number)

TRUE if a French SIRET (14 digits) or SIREN (9 digits) number is valid.

  • number: The SIRET or SIREN.

Example: =MINH.ISSIRET(A2)

Working time

Free. Computed in Excel, nothing is sent.

=MINH.BUSINESSHOURS(start, end, open?, close?, holidays?)

Working hours between two dates and times, weekends and holidays excluded (for response-time targets).

  • start: Start date and time.
  • end: End date and time.
  • open (optional): Optional. Opening time, e.g. "08:00" (default).
  • close (optional): Optional. Closing time, e.g. "18:00" (default).
  • holidays (optional): Optional. A range of holiday dates.

Example: =MINH.BUSINESSHOURS(A2, B2)

Your account

Free.

=MINH.USAGE(what?)

What is left this month: "addresses" (default), "roads" or "plan".

  • what (optional): Optional. addresses, roads or plan.

Example: =MINH.USAGE()