07/01/2022: Fix Excel links repointed to C drive
If you find that Excel spreadsheets that you hyperlinked to a network drive using the HYPERLINK formula are inexplicably redirected to the user’s AppData folder on your C drive, you may be able to prevent this from happening again, by disabling the autosave option. Go to File. . .Options and uncheck the option to automatically save the file at 10 minute intervals or the option to automatically save the .xlsx file to SharePoint. Also, try moving the AutoRecovery location to the same directory that the hyperlinks point to.
7/8/2022: Bates Number Gap Checker
The Excel spreadsheet posted below tonight can be used to create a list of Bates number ranges, listing sequentially numbered ranges in a long list that has gaps and contains ranges from productions by different parties.
Enter your list of Bates starting and ending numbers in columns A and B. Make sure they are sorted in numerical order. The formula in column C checks where the difference between the number (minus the Bates prefix) in column A is other than an integer, but it checks the characters in each cell only after the last non-numeric character appears.
The formula was designed for this because Bates numbers always end in multi-digit numbers and almost always include prefixes with letters, dashes, underscores, spaces, and other non-numeric characters, and can sometimes include numbers like “ACME-“. 2004_00099454256′ or ‘3M 0006532’.
The formulas in columns D and F look for the position where the last non-number occurs, and the formula in column C refers to the result of those formulas.
=LOOKUP(2,1/(ISNUMBER(SEARCH(MID(A2,ROW(INDIRECT(“1:”&LEN(A2))),1)),[email protected]#$%^&+ _-:|.—”))),ROW(INDIRECT(“1:”&LEN(A2))))
Thanks to tigeravatar for posting this LOOKUP formula here. Note that the formula will fail if the Bates prefix ends with any character other than these: [email protected]#$%^&+ _-:|.—
It can be used for more than one purpose when you need to find the last occurrence of one or more characters in a cell.
The formulas in columns E and G identify where a Bates number ends with a letter suffix. In these cases, the Bates ranges must be checked manually.
The formula in column H checks where the Bates prefix in column A differs from the previous Bates prefix and enters a new Bates number where the formula in column C indicates a gap appears.
The formula in the last column enters the final Bates number for each consecutive range. Just filter on this column to get the full ranges for all bates numbers in H and I, but make sure to manually correct the very last bates number.
07/16/2022: Copy as path in Windows Explorer for multiple files
It is quite well known that when you select a file in Windows Explorer while holding down the SHIFT key, you will see the option to copy the full file path of the selected file in the right-click menu. Don’t miss that you can also select multiple files and copy the paths for each one to the clipboard in one step:
07/22/2022 – Zoom CRC – Connecting a Cisco or Polycom video conferencing system to a Zoom meeting
When you receive a Zoom invite, you’ll see a long list of possible ways to connect – in addition to the URL on the host network, there’s a long list of numbers for various area codes and toll-free numbers. Towards the end of the invitation, you should see a reference to an option to join via SIP, Session Initiation Protocol – a 10 or 9 digit number corresponding to the meeting ID followed by the domain @zoomcrc.com.
Zoom Conference Room Connector or Cloud Room Connector allows a Zoom meeting running on a desktop or smartphone to connect to Cisco, LifeSize, and Polycom video conferencing systems or anyone with SIP or H.323 VoIP communication protocols.
When you start a Zoom meeting on a laptop, you can use a Cisco or Polycom system to connect to the meeting. An example of a video conferencing system compatible with Zoom are the Polycom Group series systems:
Another example is the Cisco Tandberg TelePresence systems:
To join the Zoom meeting via the video conferencing system, enter the address @zoomcrc.com in a panel like the following:
You may also be prompted for the meeting passcode.
A monthly fee of $49 applies for each CRC connection.
07/29/2022 – Checking for bad sectors with chkdsk
If you want to find out if a drive on a device running Windows has bad sectors that you cannot copy files from or cannot copy files to, you can run the chkdsk command. chkdsk finds bad sectors and can also be used to fix file system errors. If you type: chkdsk /r in command prompt, the system will find bad sectors and try to recover data from them.
chkdsk generates a list of how many files are on a drive and how many bad sectors.
If you search for “Event Viewer” in Windows and open it, you will see the Application log in the Windows Logs folder. Searching for “chkdsk” in this log will display the results of any previous chkdsk checks that have been run
Right-click on the Application Pane entries where this search finds hits and you can copy the information to NotePad.
Litigation Support Tip of the Night has been working longer than ever this year, so some of the posts won’t be as detailed as those of previous years.