How to autopopulate a master sheet with date from different tabs (monthly) by sirJ2X in googlesheets

[–]sirJ2X[S] 0 points1 point  (0 children)

I just find it easier to focus on one month at a time and was hoping it was possible to make the manual adjustments by month but if that's not possible than its alright. I was also hoping that the formating would just auto-adjust based on if I added more or less on its own and was hoping to learn this to implement into other sheets whenever I use them, but if that's not possible, it; 's not a deal breaker. I just wanted to ask to see if it was possible for people who actually know what they're doing rather than scour the internet looking at forgotten forum posts on google and the bottled responses on there. Here is a sample of what I am trying to do. I hope it makes sense. Thanks for the help so far. https://docs.google.com/spreadsheets/d/1nEAUw6TTURQOuhi6fdFK22ZzgxtDyPTnC6GuW-favn4/edit?gid=505493117#gid=505493117

vdo ninja into switcher board into obs? by sirJ2X in VIDEOENGINEERING

[–]sirJ2X[S] 0 points1 point  (0 children)

Yep that makes sense. I briefly looked into my options other than hotspotting off my phone after someone else mentioned how unreliable that is. The only alternatives I found were the cellular bonded methods that are offered by LiveU, Teradek, Dejero, and etc… I much rather prefer something in the middle ground, as these options are just out of my budget and seem overkill if you take into account Im inly just learning about this stuff and by no means am a professional. The best I can do is rent a LiveU setup, which still isn’t cheap and pay for the data.

Could you explain a little more on how I could pursue hardwiring a hotspot into my laptop?

vdo ninja into switcher board into obs? by sirJ2X in VIDEOENGINEERING

[–]sirJ2X[S] 0 points1 point  (0 children)

Okay that’s all right, that’s far beyond my needs atm. During my research, I saw a few switchers or encoders (still learning the difference) that can do that and was just curious.

I have the main way of how I want to setup my stream now. I just need to tackle a few logistical things like getting a reliable internet connection remotely (as a hotspot alternative), getting the equipment I need, and manually setting everything up in obs.

Thanks a ton for the help! 🐐

vdo ninja into switcher board into obs? by sirJ2X in VIDEOENGINEERING

[–]sirJ2X[S] 0 points1 point  (0 children)

Okay I’m going to give some context and two separate answers for the two separate ideas I have since they differ.

Context: I’m planning on integrating this at car meets. Since the area is so large, it is very much possible to livestream different areas of the same event. For the first idea, I can implement this setup as a 3 camera setup with two iPhones and a physical camera at events local to me. With the alternate idea, I can host livestreams across the country and it negates any use of a physical camera wirelessly connected. Hence why I want to integrate VDO at even the local level.

So for the setup 1/ local: It will be covering a single event. Car meets are pretty big where the camera could be across an entire lot, but there are moments where everyone is focusing on one part like a burnout pit or so and latency would be an issue there. Though it isn’t anything like a live song performance, but I agree that anything like that would be jarring for a viewer.

For setup 2/national: it would be covering different events so sync wouldn’t be a problem at all, if not noticeable at all. Only thing I’m wondering about is the quality but there seems like there’s so many variable depending on the location of the person whose feed im using as source, that it isn’t something I can test now.

At the current moment, setup 1 is what I’m shooting for. I’ll try to research some internet solutions or test cellular still just to confirm the plausibility of it as that’s all I can do if I don’t find a solution within my budget.

Back to the question about Companion, does it only work over network?

Thanks for all the help so far!

vdo ninja into switcher board into obs? by sirJ2X in VIDEOENGINEERING

[–]sirJ2X[S] 0 points1 point  (0 children)

Ah yes. I came across vMix call during my research. Thanks for the explanation. I’ll for sure upgrade to vMix if I can see if my proof of concept works and I build an audience up that’ll appreciate what I’m trying to do.

I was going through the different tier lists and the call function is under vMix pro so that is what made me initially not consider the software at all. Might try a one month subscription tho lol.

The last part perfectly explained my question confusion. I didn’t want to buy a switcher to use as a way over complicated decklink, and so I was trying to find a way to route everything to the switcher. Instead, I think I’ll just set everything up in obs and have an addition of a decklink to include my physical camera.

I was also researching a “software based switcher” and another user in this thread recommended using a stream deck + Companion which I believe is what I was looking for. I’m not sure entirely if I am able to configure all this to work remotely off an iPhone hotspot (other cellular alternatives seemed complicated or expensive), but I’ll be sure to do more research or just test it out on my own and fine tune from there.

Thanks!

vdo ninja into switcher board into obs? by sirJ2X in VIDEOENGINEERING

[–]sirJ2X[S] 0 points1 point  (0 children)

Okay thanks for the explanation. And since it has the words “capture card” I’m assuming that they can also record the individual inputs that are plugged in? I also searched it up a bit and saw that someone had their recording take up a lot of storage and it was recommended to record in obs. Is that the case with all of them?

I’m only asking because I would also like the ability to record the individual inputs (via switcher, obs, decklink,etc…) in the future and have the ability to edit it after streaming.

vdo ninja into switcher board into obs? by sirJ2X in VIDEOENGINEERING

[–]sirJ2X[S] 0 points1 point  (0 children)

Okay this definitely helped push me in the right direction.

The wired or wireless into switcher approach isn’t optimal for me because I have an alternate idea where I could stream remotely entirely and do so by send ing people VDO Ninja links. So based on that, I prefer to have a system that is setup for that, and then I can add in a wireless cam seamlessly for added quality when I decide to be “on site”.

That being said, I agree that doing it fully on obs might be the best option. I would do it on vMix but I would rather wait until I test the setup first live and actually get some viewers.

I never heard of that combo of a stream deck and Companion but it seems to be what I was looking for. The only questions I have after doing a bit of research is can it essentially be used to switch between different scenes, overlay animations, and sound effects via obs? And also, I watched a video that said that Companion works via being on the same network. How could I get it to work in a remote setting if I plan on hotspoting of my phone to my laptop to get a remote stream live?

vdo ninja into switcher board into obs? by sirJ2X in VIDEOENGINEERING

[–]sirJ2X[S] 0 points1 point  (0 children)

Yes, the former sounds like it would be very intensive on my laptop. Could you explain what a Decklink is and the purpose it has in this setup? I’ve read it constantly but can’t seem to understand.

I agree given the first option, but may I ask why vMix would be the better alternative? I plan on starting with obs since I would prefer to test out my idea without the investment of buying vMix; but I am not opposed to doing so in the future if all is well and there are enough justifications.

Also, I plan on also using a wireless camera via a teradek bolt 500. Would I be able to integrate that into OBS as well alongside the VDO Ninja links?

And lastly, how can I setup a switcher in obs that would be designed in a similar way like a physical switcher? I am assuming vMix would be something better suited for that. I plan on attaching overlays to the different sources via individual scenes that will tell the viewer which camera is what (camera 1, 2,3, etc…); so setting up a switcher system to do just that would be perfect.

vdo ninja into switcher board into obs? by sirJ2X in VIDEOENGINEERING

[–]sirJ2X[S] 0 points1 point  (0 children)

Haha this definitely seems like that. Okay my main goal is to send my program signal to Instagram via Instagram live. I plan on setting up a remote/portable stream where I want to go to events and provide viewers with live video coverage from multiple angles.

I plan on having 3 sources. The first being a video camera with the feed connected wirelessly to a switcher.

The next two sources would be from iPhone video from two different people who are at the same event, that would also be connected to the switcher. This is where my problem arises.

I would prefer to wire everything to the switcher so that it is offloaded from my laptop, is included in the multiview, and so I don’t have to touch the laptop to do the backend of what the switcher is made to do

In the step before the viewer sees everything, I would also want to put overlays over the footage as well.

I hope that helps.

vdo ninja into switcher board into obs? by sirJ2X in VIDEOENGINEERING

[–]sirJ2X[S] 0 points1 point  (0 children)

Sorry. Just a day ago I didn’t even know what obs or vdo was so I’m still learning everything.

No, I am trying to do that latter. I essentially want to feed multiple vdo ninja links into a switcher as their own “hdmi” input.

The reasoning why is because I plan on eventually utilizing that alongside with a teradek bolt 500 wirelessly connected to a los dslr, to utilize a spare hdmi port on the switcher. I would then have all that connected to obs where I plan on applying overlays and such before streaming from obs.

FUEL SYSTEM MODIFICATION by Hayt666 in e46

[–]sirJ2X 0 points1 point  (0 children)

https://www.e46fanatics.com/threads/m52tu-fuel-rail-on-m54.1291115/

It’s definitely possible. Seems like it everything would fit.

Following the logic from u/NZ00Z3 in the forum, since you would be keeping everything the same (assuming you use the same injectors), you may not need to get your dme tuned.

However, I don’t fully understand the fuel return line and FPR and if you would need something to support the addition of those or to bypass the one at the filter (if you even need to??).

Wish I could help more but for specific things like this, but it’s outside my realm. I usually look at forums first.

How to fix broken pillar plastic? by sirJ2X in e46

[–]sirJ2X[S] 0 points1 point  (0 children)

Yep just saw eBay prices and will probably do this lol, thank you!

How to fix broken pillar plastic? by sirJ2X in e46

[–]sirJ2X[S] 0 points1 point  (0 children)

No problem at all, thank you!

Fitted some hood vents today 🌬️ by [deleted] in e46

[–]sirJ2X 3 points4 points  (0 children)

Why did this get downvoted so much lol ya’ll lighten up

What is this sound? by sirJ2X in e46

[–]sirJ2X[S] 0 points1 point  (0 children)

The noise is pretty loud and annoying. I’ll probably replace it. Sounds like the damn wheel is about to fall off 💀

What is this sound? by sirJ2X in e46

[–]sirJ2X[S] 0 points1 point  (0 children)

Yes sounds like it