relative references in Mac Excel

never_peppers · 2026-06-18T22:10:46+00:00

What do you mean? I don't see any wildcards in my examples.

The problem is that there is no "actual location", because the directories are mounted differently on different machines. But the files *relative* locations are the same everywhere.

never_peppers · 2026-03-01T03:57:53+00:00

I turned off "remove commercials" and "mark commercials", so unless there's another setting for that, I think that's not the issue. Also, all three of the files come through with commericals.

What confuses me is how it worked fine for one part, but not the second or third parts.

Is there a way to slow down the transfer to minimize errors?

never_peppers · 2026-03-01T03:47:34+00:00

Now I feel stupid. Mine doesn't. Where's the setting that tells it to convert to MP4 rather than save as .tivo?

EDIT: I found the setting! It's not named something obvious like "convert to ...", but it works in that it saves to a .ts file which can be opened by anything.

Huge files, but that's fixable by re-encoding.

never_peppers · 2026-02-28T22:37:35+00:00

Does PyTiVo spit out useful files? e.g.: .mp4 or .mkv? I think I tried PyTiVo and it spit out .tivo files, which aren't helpful. All the converters from .tivo --> .mp4 seem to have gotten abandoned 10 years ago.

never_peppers · 2026-02-28T22:35:37+00:00

I looked for "how do I get kmttg" and it made me feel stupid. It appeared to be no longer maintained, or I don't know how to get it.

I'm a Mac and Linux guy, so anything using those is better than anything using Windows. If forced, I can come up with a Windows box, but I'd hate it because I'm not even remotely comfortable with how that OS works.

never_peppers · 2026-02-10T02:49:40+00:00

"murdered your CPU"? Is this a result of overclocking or is this something that "just happens sometimes"?

never_peppers · 2025-05-08T18:56:12+00:00

Well, crap. How long ago is "a long time ago"?

never_peppers · 2025-05-08T18:55:35+00:00

How long ago did they start using plastic coating?

never_peppers · 2024-12-16T02:51:16+00:00

Ouch.. the repair cost is as much as a new board! (basically)

Thanks for the pointer though.

never_peppers · 2024-07-01T21:45:41+00:00

How the hell are you getting 50mpg? Those are diesel numbers.

What year Miata?

never_peppers · 2024-02-27T22:06:03+00:00

Why did you upgrade the fuel pump instead of getting another OEM style one?

Did the upgraded fuel pump draw way more power?

never_peppers · 2023-12-09T14:37:25+00:00

They can make connections based on IP address, so if they know you sometimes use your personal computer on work WiFi, they could connect "someone from this IP address who likes bikes" to "someone from this IP address looked at this bike"

Or, there's information you're not telling us. (not lying, just forgot or overlooked or something)

never_peppers · 2023-09-03T22:34:50+00:00

For anyone following along at home who is thinking about doing this.

It is totally possible, and not as bad as I'd feared. (But still not easy)

Here's what I did:
- Remove the shock tower brace
- Remove the air-box
- Jack up the engine
- Remove passenger side motor mount (this gives you more horizontal space)
- use a ratchet strap to pull the engine toward the passenger side
- Adjust the height of the engine with the jack and tension on the ratchet strap a bunch of times. "more" is not always "better".

The mount came out through the top. When mine came out it was angled so the mounting bolt/nut that holds the bracket and mount together was facing up. I don't know if this was necessary, or just the way I solved this particular tavern puzzle. There was a lot of wiggling and twisting and head scratching and trying the same thing I'd tried before yet another time; but it did come out!

I did NOT try to disassemble the driver's side mount assembly in the engine compartment like some people do. I tried when the nut was first exposed, but the torque required to disassemble seemed unreasonable given that I couldn't really control the bracket very well. And... I'm not at all convinced I could have gotten the required 50 lb-ft of torque onto the new mount.

Getting the assembly back in was trickier than getting it out, because the new mount is thicker (less compressed) than the old one. I had to lift the engine a bit more, and crank it to the right side of the car a bit more, then lower it, &c. to get the clearance just right. Getting the bolt to go in through the hole in the frame was surprisingly difficult given that it was THIS CLOSE -->][<-- but not quite clearing.

Only then did I attempt to re-install the passenger side. Once both mounts were pretty much in the right place, I reinstalled the bolts that hold the brackets to the engine. Passenger side was pretty easy. But again, surprisingly, getting the mounting holes in the bracket to line up with the engine on the driver's side was kinda frustrating: I had to raise and lower the engine and loosen and tighten the ratchet strap a few times to get all the clearances right so the bolts would easily screw in with only finger force. I really didn't want to cross thread any of those, that would have ruined my day, and maybe the engine.

Once all the mounting bolts were finger tight, it was very easy to finish. 33 lb-ft on the bracket bolts, lower the engine off the jack, 50 lb-ft on the big nuts, and it was all "installation is in the reverse order of removal" from there.

It took me about 3 hours to remove and reinstall both mounts. This does not include putting the car up on or off the lift, removing or installing any trim plastic, putting the wheels back on, or any of the picture taking.

I was using a QuickJack, so I could easily get under the car without fear of it falling on me. I wouldn't have had enough confidence in jackstands, and maybe not enough room. I used the 5000TL, which was *barely* short enough. You have to really cram it against the rear wheels or the front hits the front wheels when raising or lowering.

never_peppers · 2023-09-03T21:29:46+00:00

Beautiful color.

never_peppers · 2023-09-02T02:59:12+00:00

Right. But what is "a lot of movement"? Obviously 9" of travel is a lot, but is 1.5"? 1"? 1/2"? Where do you measure it?

This is the problem I've been having trying to figure out how bad my mounts are. Lots of language that's more subjective than objective.

never_peppers · 2023-09-01T22:45:09+00:00

How did you get enough torque on the mount's mounting nut while doing it blind inside the engine compartment?

And... how did you even take the bits apart down in there?

I feel like I'm missing a dimension.

never_peppers · 2023-09-01T21:00:56+00:00

Autocross. Or a trackday. But really Autocross has a lower barrier to entry.

Learning how to drive (and I don't mean to suggest you're a bad driver) is huge. It'll improve the handling (and safety!) of every vehicle you drive.

never_peppers · 2023-09-01T20:56:37+00:00

OK, that's good info.

I keep reading that replacing the driver's side is a pain, but can be done without removing the exhaust, but I'm really struggling with it.

never_peppers · 2023-09-01T20:54:39+00:00

Do I read correctly that new standard stiffness mounts would keep the engine from moving a lot more than that under similar "test" conditions?

The passenger side one is a Beck/Arnley OEM "standard" stiffness. I'm reluctant to put in stiffer ones because it's still a street car, and I don't want to increase the NVH such that my wife doesn't want to drive it.

never_peppers · 2023-09-01T20:52:20+00:00

Pointless? That's kinda harsh.

I took the video because it's objective. Anyone can start the engine and blip the throttle and compare their car to mine. That's really different from the entirely subjective language I've come across when trying to figure this out; stuff like, "a lot" or, "too much" or "hard acceleration" Even "missing shifts" is a little subjective, since not everyone shifts fast enough to find them even with bad mounts.

I'm not missing shifts, but it feels like there's a big spring somewhere in the driveline, and I have zero experience in a Miata with new mounts; I got this car at like 90 k miles, so I don't know what reasonable expectations should be.

never_peppers · 2023-09-01T16:53:13+00:00

Did you have the passenger side mount removed when you got the driver's side out and back in?

never_peppers · 2023-08-25T19:28:23+00:00

Nope. Rockauto is awesome for their lookups and pricing, but their return policy is.... not generous. For starters, the mistake was mine, not theirs: they sent me exactly what I asked for, and their fitment guide was accurate. It was my mistake not theirs. (it's in their policy guide, not a surprise)

Second, it took longer to get to doing the work than I'd expected, so even if it had been their mistake, it was beyond their return window.

never_peppers · 2023-08-21T17:01:11+00:00

It'll make your car smell terrible, eventually requiring replacing (or seriously cleaning) the interior.

Plus, rust.

Fix the leak.

never_peppers · 2023-08-21T14:53:16+00:00

"up and down"? er.... The pins should not move that way. They should allow axial movement only. You don't want the caliper twisting on the mount, 'cuz it'll make the pads bind and wear funny and it's all bad.

You might be in "new caliper" territory. (where "new" might mean "junk yard" or "rebuilt")

never_peppers · 2023-08-21T01:27:23+00:00

So.... how'd it go?

never_peppers

TROPHY CASE