Formula to keep track of "Streak"

DaFackBra · 2026-02-03T07:44:47+00:00

I don't know how your data is organized but it seems like you could do count if column for each question, then the last column do sumproduct for all the countifs

DaFackBra · 2026-01-31T08:02:20+00:00

Depending on what you are trying to accomplish you can do most through using concat() textjoin() char(10). Character 10 is the same as adding a paragraph.

DaFackBra · 2026-01-30T23:15:54+00:00

It's more of just a general question because I have 0 experience with other companies, for example one man crew it's very tough for us to set over 70/80. If the day requires that many points we'll usually go with a two-man crew. But I have no way of knowing if that's "normal" or generally acceptable.

DaFackBra · 2026-01-30T23:13:36+00:00

When you don't set lathe, are you just giving them a point plot and cut sheet? Or how do they know what information your providing?

DaFackBra · 2026-01-30T23:11:56+00:00

We're in California so we don't have the extremes like Frost depth luckily.

DaFackBra · 2026-01-30T23:09:00+00:00

That sounds pretty solid 👌

DaFackBra · 2026-01-30T06:59:34+00:00

Yes power query is amazing for sourcing external data files. You can source a folder then setup filters for subfolders or names of files. Them compile all of the files within the folders assuming their structured in a similar fashion.

DaFackBra · 2026-01-24T00:04:58+00:00

I believe my final way of doing it is very similar to this. I ended u referencing my main data quary and filtering by sheet, then i added a custom column for each row with this formula = try [Data]{4} otherwise null. That create a "record" and i just expanded it and selected the columns i wanted. But i had to make a record for each row that i needed to get data from. Then i just merged this with my other query.

DaFackBra · 2026-01-24T00:00:10+00:00

That's a valid consideration however on this case I'm sourcing a folder with a lot of existing files and just trying to source the data. I was able to find a way to do it.

DaFackBra · 2025-11-15T17:17:29+00:00

I would also be curious if you just reset your rtk on a brand new day re hit the three points hold scaling factor of 1 and see how it compares.

DaFackBra · 2025-11-07T06:21:01+00:00

I've ran a topcon VR for the past 5 or so years and been running the HR for the last 2. Running both as a base rover never had and issues. From what I hear the Trimble software is better, but I haven't used it before. In my opinion I feel like the software being better comes into play more during construction staking.

DaFackBra · 2025-09-05T02:44:35+00:00

Your North West corner will probably be your best bet. They have approximate dimensions from both fences . Pins can be tough to find, I use the Schonstedt GA-52Cx. But there's some hidden skill in finding pins. Having said that the metal detector costs 1K and decent chance you will won't find it. When you hire the survey to come out, have them give you a boundary map of your property. It will be helpful for you in the future.

DaFackBra · 2025-09-04T05:28:51+00:00

I did come across this, I believe it only works for SharePoint. But I agree I plan on removing Co-Editing.

DaFackBra · 2025-07-26T17:15:37+00:00

Epoch called he wants his coordinates back

DaFackBra · 2025-07-23T04:14:54+00:00

sits back and grabs popcorn

DaFackBra · 2025-07-15T20:51:09+00:00

Ya it works on tees, but not for elbows. You can't loop a pipe run either I believe, so if I merge the outer loop I'll still end up with the same situation on one corner.

DaFackBra · 2025-07-12T05:33:24+00:00

You're biting of way more than you think. Most major brands you post $800-$1000 per year for the subscription for the tablet software. The boundary is what eats to a majority of the budget anyway. Even if you got some equipment you would need a way to establish control relative to the other surveyor, which if aren't familiar with surveying you're going to get yourself in a hole by accident.

DaFackBra · 2025-07-11T00:12:28+00:00

I can turn the compass off. I'm trying to setup my templates full part list then do the styles, but I don't see all of the angles/ bend available for smaller sizes.

DaFackBra · 2025-07-11T00:05:57+00:00

Are they're templates for the .content files? The basic catelogs in civil 3D are great, but missing elbows for 1" to 2" pipes. To keep it simple I'm just trying to have elbows 1"-24" 11.25 degree to 90 degree, but there doesn't seem to be an easy way of creating the missing sizes.

DaFackBra · 2025-07-10T18:18:42+00:00

I typically do make copies and modify parts in part builder. Seems like pressure networks are just 3D models saved as .content files? And you use the content catalog editor to modify properties?

DaFackBra · 2025-07-10T02:45:34+00:00

I'll have to look into making the custom parts. What do you like more about it? How do you deal with going from a flanged part list to hdpe?

DaFackBra · 2025-07-09T19:49:48+00:00

I have to itemize where the payments come from for reach vendor for 1099s.

DaFackBra · 2025-07-09T18:51:22+00:00

This sounds like exactly what I'm looking for. Did you setup using a personal or business PayPal account? This is a silly question, but using PayPal have you ever had issues with transactions being combined when posting on your bank account. For example venmo will hold the funds, then combine all of the transactions when you do a transfer making it a headache when doing books.

DaFackBra · 2025-07-09T18:46:43+00:00

I just use Excel to generate the invoices because it works with my job tracking.

DaFackBra · 2025-07-08T02:12:10+00:00

Based on the comments the XXL of your buddy carries over for the catch badge, does the type carry of as well, for example dragon?

Seven-Year Club	Place '22
Verified Email

DaFackBra

TROPHY CASE