GHammer
Dark Star
Click on supercharger title column then ctrl+click on your dates visited column which will highlight both columns. Then copy and paste into a new sheet.
-
Want to remove ads? Register an account and login to see fewer ads, and become a Supporting Member to remove almost all ads.
Superchargers visited 3.0
- Thread starter juliusa
- Start date
Half Dollar Bill
Traveller, teacher, poet, accountant, innkeeper
That is the easiest way. You can also view just your visited superchargers, and sort by date if you want. Just create a temporary view.
Data - Filter views - Create Filter View. Then click on the symbol next to your name, and uncheck "blanks". Even if you export to your computer to do the reconciliation, this view may make it easier when you go back and correct the dates.
Oh. I can't attach a file here..only images. I made an Excel file I can send you or I could provide you access to a Google Sheet with just your visits. DM me your email address and whether you prefer to work from the Excel file or the Google Sheet. Will get that to you tonight.
ThisIsTrue
Re-member
Thanks much, but I got it from the first technique presented. (Then had excel delete the rows where the cells were blank, then sorted.)
I found the discrepancy -- and a few errors (wrong year noted on visit), which I'm fixing in the spreadsheet. I appreciate the help!
GHammer
Dark Star
I omitted a step I use to get my list, that is to create a temporary filter on my column and deselect the blank cells to get rid of the unvisited sites prior to the copy/paste. I also do it in the reverse direction and create a temporary filter for only the blanks and then import that into my own Google map of unvisited sites.
If you want to create your own google map with your visited, not-visited, construction, and permit superchargers, here are instructions from @JSergeant. Once you do it the first time, it is very easy to update. Since our spreadsheet is so large, you may find it easier to create a copy first. Also, our spreadsheet has North America, Europe, and New Zealand so you may want to just do your region.
Superchargers Visited
Superchargers Visited
txakoli
Member
I'm enroute to the rally in the Black Hills. I've endeavored to input some new Supercharger visits but I'm running into problems with the spreadsheet. I'm using an iPad with the Google Sheets app. I open the sheet fine, but it kicks me out after a short time (< 1 min). Does anyone have a solution? It works fine from my Mac at home.
Meanwhile, could someone please add the following to my list:
5/12/19: Las Vegas, NV (Downtown)
5/14/19: Boulder, CO, Loveland, CO
Total should now be 124.
Thanks.
Meanwhile, could someone please add the following to my list:
5/12/19: Las Vegas, NV (Downtown)
5/14/19: Boulder, CO, Loveland, CO
Total should now be 124.
Thanks.
The sheet is too big for iPads and phones to process. You have to update it from a computer.
See you on Friday!
txakoli
Member
Half Dollar Bill
Traveller, teacher, poet, accountant, innkeeper
If you want it updated as you go, just post your new superchargers here and someone will get them entered.
Half Dollar Bill
Traveller, teacher, poet, accountant, innkeeper
txakoli
Member
My new superchargers were listed on my post from yesterday. It appears my count hasn’t been updated.
Similar threads
