Level Loop Adjustment Spreadsheet

This handy spreadsheet computes a level loop’s misclosure and distributes corrections evenly throughout the loop. You supply the rod readings or height differences around the loop as well as the starting and ending elevation. The spreadsheet computes the misclosure and adjusted elevations for all stations in the loop.

There’s a blank spreadsheet with the formulas in it, ready to use and an example spreadsheet as well.

Level Loop Adjustment Spreadsheet Example

Level Loop Adjustment Example

Compatibility

Microsoft Excel 2003 or later

How To Use

1. Download the Level Loop Adjustment Spreadsheet (Zip file, 16Kb)  and extract it.

2. Open Level-Loop-Adjustment.xls in Excel. (Or look at the example).

3. Follow the steps in the spreadsheet. Only input data where headings are green.
(Blue headings indicate computed values.)

Example

Open Level-Loop-Adjustment-EXAMPLE.xls in Excel to view an example.

Posted in Adjustment, Excel, Levelling, Spreadsheets, Tools | 2 Comments

Data Mapper

A problem that Data Mapper solves

A problem that Data Mapper solves

If you have missing data, sorting it won’t line up all the rows correctly. But Data Mapper will. Where there is no data available (null), there will be an empty row.

Once you know the steps, it will take just a few seconds to use and will save you time.
There is no need for a manual. The software will guide you through the steps.

I takes me 10 seconds or less to use this tool, provided there are no problems to correct in the data, such as duplicate key values.

Download Now, Get Instant Access

Posted in Excel, Tools | Leave a comment

Want to know how to invite all your friends to a Facebook event all at once?

Do you want to invite lots of your Facebook friends to an event, page or group? It’s a tedious task to select them one-by-one, which is why the “Toggle all” button is so great. It lets you select them all at once at the push of a button – it’s a great time saver.

Warning: I will not be held responsible for any consequences you create by using this information. It’s powerful and can be abused. Be careful and do not overuse this secret…

A Facebook trick to select all your friends at once

Before I tell you how to get the Toggle all button, I’ll show you a code you can use to quickly select them all. Then I’ll tell you how to use it. You might already know, that’s why I put the code first.

javascript:var x=document.getElementsByTagName("input");for(var i=0;i<x.length;i++) {if (x[i].type == 'checkbox') {x[i].checked=true;}}; alert('Done, all your friends have been selected');

1. Login to Facebook and then go to any event, your page, or group you want to invite people to.

2. After you indicate whether you’re attending or maybe attending, the “Invite friends” button appears and then you have to click it.

3. Scroll down to the bottom of that window, so all your friends load. You might have to scroll multiple times. You can’t select friends who don’t appear in the window.

4. Copy the code above and paste it into the address bar of your browser (where it says www.facebook.com/event…) and then BEFORE you hit the Enter key: Press the HOME key or scroll back to the beginning of the code you pasted in the address bar. Make sure it starts with “javascript:…” – it may not! It might start with “var x=…” Retype javascript: manually at the beginning. :)

Once again, if you paste the code and press Enter and it goes to a Google search results page… you’ve got to add javascript: to the beginning… then hit Enter.

5. Wait until all the visible friends are selected (this might take a little while.)

6. You can also add a personal message before you click the “Send Invitations” button, if you’d like.

7. Click “Submit”

If you found this useful, would you please buy me a cup of coffee? Thank you.



Toggle All Button - Another Facebook trick to select all your friends at once

1. You need the Google Chrome browser to get the button. This is the browser I recommend using anyway since it’s so fast. If you don’t have it yet, download it from http://www.google.com/chrome

2. Open Google Chrome and download the add on called “Extensions” here https://chrome.google.com/extensions

3. Go to https://chrome.google.com/webstore and search for “Toggle all” or “Facebook Inviter”

4. Click the “ADD TO CHROME” button beside Facebook Inviter.

5. Click Install.

6. Once it’s installed, login to Facebook using Google Chrome and then go to any event, your page, or group you want to invite people to.

7. After you indicate whether you’re attending or maybe attending, the “Invite friends” button appears and then you have to click that button.

8. You’ll notice that a “Toggle all” button appears with the Submit and Cancel buttons. Click the “Toggle all” button and it will automatically select all your friends for you. It may take a few moments to process.

9. Click “Submit”

NOTE: You only have to install the “Toggle all” button once. After that, it’ll always be there for you to use.

Hope that helps!

If you found this useful, would you please buy me a cup of coffee? Thank you.



Posted in Uncategorized | 23 Comments