System: I will provide you with a textual user review of an Android app, aiming to categorize the reviews into specific intention classes:
Bug report: All posts that report on bugs and errors of a software application.
Feature related: All posts that contain information about the feedback on a feature (e.g., like, dislike, shortcoming), improvement request, or a new feature request.
Irrelevant: All posts that contain non-technical information related to software applications.
User: 'prompt:I will provide you with a textual user review of an Android app, aiming to categorize the reviews into specific intention classes:
Bug report: All posts that report on bugs and errors of a software application.
Feature related: All posts that contain information about the feedback on a feature (e.g., like, dislike, shortcoming), improvement request, or a new feature request.
Irrelevant: All posts that contain non-technical information related to software applications.
Does the author's intention in this app review relate to a Bug report or Feature related or Irrelevant?
review: Need to get the distance between two addresses/cities/zip-codes but don't want to/can't use an API? Here's a macro I wrote that scrapes HTML from Google Maps. **Edit: Thanks to user /u/aikoaiko who pointed out an alternative to getting mileage from Google without using Maps. The code below has been altered search the HTML code for the # of miles	and paste that value into Excel.I opted to go with option 3 since it was the quickest and cheapest option to get the information I needed. I wanted to share this script with the /r/Excel community in case someone out there in the future needs to find distances without paying for a service	or doing 1 at a time.**Notes**1.) You'll need to create references to a few different libraries within your workbook:**Microsoft Forms 2.0 Object Library**	**Microsoft Internet Controls** and **Microsoft HTML Object Library**2.) This script essentially scrapes the HTML code from the Google Maps navigation page. If in the event Google decides to update their source code	this could cause the macro to stop working properly.3.) You can use Zip Codes	Addresses	Cities	States	or Coordinates as your input values.4.) Because Excel truncates numbers starting with 0	the macro is written to add a 0 to the start of any zip code with < 5 digits (mostly in the state of NJ)**How it works**1.) You'll first highlight the cells you want to insert the Miles into	then run this macro.2.) You'll be given two prompts	first one is to select the column containing your Starting Location (you can select either the column or an individual cell	doesn't matter). Then the same thing for your Destination Location.3.) Excel will do its thing	and within 5-10 seconds	you should see the distance in miles populated in your highlighted cell.**Main code:**        Sub GetDistance()                    Dim rng As Range: Set rng = Selection        Dim cell As Range        Dim Start_column As Integer        Dim End_column As Integer        Dim results As String        Dim miles As Integer        Dim HTMLDoc As HTMLDocument        Dim ie As InternetExplorer: Set ie = New InternetExplorer        Dim oHTML_Element As IHTMLElement        Dim Start_Zip As String        Dim End_Zip As String        Dim Link As String        ie.Silent = True        ie.Visible = False        Starting_Zip Start_column        Ending_Zip End_column        With ActiveWorkbook.ActiveSheet            For Each cell In rng.Cells                On Error Resume Next                                Start_Zip = .Cells(cell.Row	Start_column).Value                    If Len(Start_Zip) < 5 And IsNumeric(Start_Zip) Then                        Start_Zip = ""0"" & .Cells(cell.Row	Start_column).Value                    Else                    End If                                                                End_Zip = .Cells(cell.Row	End_column).Value                    If Len(End_Zip) < 5 And IsNumeric(End_Zip) Then                        End_Zip = ""0"" & .Cells(cell.Row	End_column).Value                    Else                    End If                                                 Link = ""https://www.google.com/search?q=driving+miles+between+"" & Start_Zip & ""+and+"" & End_Zip & """"                                                 ie.navigate Link                                                Do                    Application.Wait (1)                Loop Until ie.readyState = READYSTATE_COMPLETE                                Set HTMLDoc = ie.document                                distance = HTMLDoc.getElementsByClassName(""UdvAnf"")                    If InStr(distance.innerText	 mi)"") = False Then                        results = 0                        Resume Next                    Else                        results = distance.innerText                    End If                results = Right(results	Len(results) - Application.WorksheetFunction.Find(""(""	results))                results = Left(results	Len(results) - 4)                miles = results                .Cells(cell.Row	rng.Column) = miles            Next                                ExitSub:            ie.Quit            Exit Sub                                                            ie.Quit        End With        End Sub                                Sub Starting_Zip(Start_column As Integer)        Dim rng As Range        On Error Resume Next        Set rng = Application.InputBox( _            Title:=""Starting Location""	_            prompt:=""Select the column containing your starting zip codes.""	_            Type:=8)        On Error GoTo 0        If rng Is Nothing Then Exit Sub            Start_column = rng.Columns.Column        End Sub        Sub Ending_Zip(End_column As Integer)        Dim rng As Range        On Error Resume Next        Set rng = Application.InputBox( _            Title:=""Destination Location""	_            prompt:=""Select the column containing your destination zip codes.""	_            Type:=8)        On Error GoTo 0        If rng Is Nothing Then Exit Sub        End_column = rng.Columns.Column        End Sub"							'
intention: '
Assistant: