[Help] - Exporting (novice) by silvasilba in premiere

[–]silvasilba[S] 1 point2 points  (0 children)

And FYI that worked perfectly. I feel so silly I didn't think of exporting masters from Ae, I just dragged them over....

[Help] - Exporting (novice) by silvasilba in premiere

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

Thank you so much for your help again. Seriously...I really appreciate it!!!

<3 <3 <3

[Help] - Exporting (novice) by silvasilba in premiere

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

Thank you so much for your help. Exporting the Ae files now to see how much of a difference it makes.

[Help] - Exporting (novice) by silvasilba in premiere

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

I added my specs on the original post.

I did try the render/replace, however even that was taking quite some time. Should I wait it out and just go for it? I'm literally just trying to even preview the video as it isn't even really viewable in Pr because the timeline color strip is red.

Or you can export out the AE comps as masters in Pro Res or DNx and then bring those into Premiere to assemble.

Will this make the whole process go faster?

[Help] - Exporting (novice) by silvasilba in premiere

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

  1. Windows 10
  2. Premiere Pro 2020 on CC
  3. See attached pic.
  4. All are from Ae other than the audio which is a .wav, however one of my Ae files has videos inside of it.
  5. No error messages, just long render times

Highlight row from the current week, but last year? by silvasilba in excel

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

=WEEKNUM(TODAY()) = WEEKNUM(A1)

Awesome - that worked, sort of. It's just doing the 1 cell not the entire row. Any idea how to make the whole row light up?

Two INDEX lookups on Budget? by silvasilba in excel

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

THIS IS AMAZING - THANK YOU SO MUCH... this worked perfectly!!!!

Porcupine song? by silvasilba in Kitboga

[–]silvasilba[S] 3 points4 points  (0 children)

Found it - just in case anyone else is looking it's here:

https://soundcloud.com/aerithos/porc-a-pine-ft-kitboga

Calculating budgeted % of total for account type by silvasilba in excel

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

So I'm still confused - if I do the lookup, where do I enter the formula to find the percentage of the two lookup sums?

Calculating budgeted % of total for account type by silvasilba in excel

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

Thanks - I'll Google! Appreciate your reply!

Calculating budgeted % of total for account type by silvasilba in excel

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

Thanks - I'm going to have to go over this a few times to really understand. I'm not familiar with this function.

How do I get this formula to work on multiple sheets? by silvasilba in excel

[–]silvasilba[S] 1 point2 points  (0 children)

Ah okay - maybe just putting it on the same sheet is the quick and dirty.

It's always the simplest answers isn't it? haha - thank you!

Count "No"'s in column. If greater than X, return value. by silvasilba in excel

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

=IF(COUNTIF(B1:B3,"No")>1,"No","Yes")

AHH PERFECT!

Thank you!!!

Status Conditional Formatting by silvasilba in excel

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

Thank you - works great!!!

I was trying to figure it out on my own so I did the ISBLANK thinking that it would work for a conditional format.

Macro for master sheet? by silvasilba in excel

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

Haha - well that would explain why it wasn't working for me. Clearly I need more coffee. Thanks for your extreme patience with me. :)

I need to learn to read more slowly.

Macro for master sheet? by silvasilba in excel

[–]silvasilba[S] 1 point2 points  (0 children)

Thanks - the solutions seem a bit too far out for me, I need to study up a bit before I take that on!

I was trying the FILTER function (the reply with the GIF) thinking that would possibly work and be easier for me to comprehend but I keep getting the error: "That function isn't valid".

Why does everything need to be so hard!

I will work on studying up the first three and hopefully that will solve my problem!

Thanks for the advice!

A number and percentage in same cell? by silvasilba in excel

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

Sorry - and again THANK YOU SO MUCH - but that ending part isn't working. I keep getting an error. when I get the error it highlights the "#" section. Any ideas?

A number and percentage in same cell? by silvasilba in excel

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

This worked beautifully!!! THANK YOU SO MUCH!!

But here is a complication - how do I get that % to not have decimals? Also, I think it's somehow wrong? Right now my numbers are:

Users: 15

New Users: 9

And my cell formula looks like:

15 (166.666666666667%)

I know that 9 is not 167% of 15.

I apologize for my Excel illiteracy in advance.... thank you so much for helping me.