When you get a Zoom invite you’ll see a long list of possible ways to get connected - in addition to the url on the host network, there will be a long list of numbers for different area codes and toll free numbers. Towards the end of the invite you should see a reference to an option to join by SIP, session initiation protocol - a 10 or 9 digit number, which matches the Meeting ID, followed by the @zoomcrc.com domain.

Zoom Conference Room Connector, or Cloud Room Connector, allows a Zoom meeting run on a desktop or smartphone to connect with the Cisco, LifeSize, and Polycom video conferencing systems, or anyone with SIP or H.323 VoIP communication protocols.

If you start a Zoom meeting on a laptop, you can connect to the meeting with a Cisco or Polycom system. An example of a videoconferencing system which is compatible with Zoom are the Polycom Group series systems:

Another example are the Cisco Tandberg TelePresence systems:

To enter the Zoom meeting from the video conferencing system you would enter the @zoomcrc.com address on a panel like this:

You may also be prompted for the meeting passcode.

For each CRC connection there will be a monthly fee of $49.

23 views0 comments

I apologize for posting such a basic tip tonight, but I have been working nonstop lately.

It's pretty well known that if you select a file in Windows Explorer with the SHIFT key held down, you will see the option in the right click menu to copy the full file path of the selected file. Don't miss that you can also select multiple files, and copy the paths for each to the clipboard all in one step:

45 views0 comments

The Excel spreadsheet posted below tonight can be used to generate a list of Bates number ranges, listing consecutively numbered ranges in a long list that has gaps, and includes ranges from different party's productions.

Enter your list of beginning and ending Bates numbers in columns A and B. Be sure they are sorted in numerical order. The formula in column C checks to see where the difference between the number (minus the Bates prefix) in column A is a different than one whole number, but it only checks the characters in each cell after the last non-numerical character appears.


The formula is designed to do this because Bates numbers always end with numbers of several digits and almost always contain prefixes with letters, hyphens, underscores, spaces, and other non-numerical characters, and can sometimes contain numbers as well such as 'ACME-2004_00099454256', or '3M 0006532'.

The formulas in columns D and F search for the position where the last non-number appears, and the formula in column C references the result of those formulas.

=LOOKUP(2,1/(ISNUMBER(SEARCH(MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1),"abcdefghijklmnopqrstuvwxyz@#$%^&+ _-:|.—"))),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: abcdefghijklmnopqrstuvwxyz@#$%^&+ _-:|.—

It can used for more than one purpose where you need to find the last occurrence of a character or characters in a cell.

The formulas in columns E and G flag where a Bates number ends with a letter suffix. In these cases the Bates ranges will have to be manually checked.

The formula in column H checks for where the Bates prefix in column A differs from the preceding 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 ending Bates number for each consecutive range. Simply filter in this column to get the complete ranges for all Bates numbers in H and I, but be sure to manually correct the very last Bates number.

Bates Gap Checker
Download XLSX • 11KB

95 views0 comments