I may be asking a dumb question or going about this wrong but I'm not sure what to do here.

So right now, I receive an estimation from one company in a PDF. It has a bunch of fields such as customer name, product, address, etc. Then I type that data and put it into Excel, where I add additional data that I have. From there I have a second PDF which has form fields that I fill with the data of the Excel spreadsheet.

My problem is with the first PDF that I get from this other company, unless I am doing something wrong I am unable to get that first PDF to show the data as fields. If I convert the first PDF into an Excel then the table data is very messy.

The amount of typing or copy and paste that it's not hard but it is time consuming. What is the best way for me to go about doing this? I've been Googling things but I'm not sure the right words of action I'm looking for.

I hope this all makes sense, but if not please ask questions and I'll do my best to try and clarify further.

I've been an After Effects user for 20+ years and I like to help people who are looking to learn. I would just ask that anyone asking a question has done due diligence searching for an answer already.
I also use 3D Studio Max and Vray.

I'm a software developer working with a small team, and our Google Drive folder tree of UI assets/illustrations/app icons/etc. is becoming increasingly difficult to deal with. Aside from proper versioning, symlinks would be a major plus. Both are kinda-sorta possible with GDrive, but not in a reliable way.

I'm happy to take on a reasonable amount of management myself, although the easier it is for the designers themselves to work with the software, the better. Paid solutions are fine, although open source would be preferable (even as a hosted service) to avoid vendor lock-in down the line.

My instinct is to go with git/GitHub on the basis that we're already deeply familiar with it from the dev side, the GitHub desktop app isn't too onerous for non-techies, and we're already paying for it. That said, I'd be very interested in anyone's real-world experience of git for multiple gigs of 10-200MB binary files. I've heard that it's not especially well suited, although that might be out of date knowledge?

Beyond that, I'm open to almost anything. I'm kind of surprised that I haven't been able to find a single "gold standard" piece of software here, in the way that git is for developers, but maybe I haven't been searching well enough? Any pointers in the right direction or stories of what has/hasn't worked for your teams would be a huge help!

I make no promises for quality, I'm really just pushing what can be done with a Pixel 3XL cell phone camera, access to Adobe Lightroom, and a surprisingly gorgeous foggy day. This ties into the "No-Money Fun Ideas" thread.

These images have been lightly edited towards what my eyes saw - most camera sensors would have trouble with color accuracy under the conditions these shots were taken.

Winter 2020

Please feel free to criticize and inform me on what I could do better.

These photographs are published for your enjoyment under the Creative Commons Share-Alike license.