u/Melodic-Pollution-91

Anyone else's parents just shitty about getting tested?

I have one VUS, which I understand most likely is benign, given that most are downgraded to benign eventually. However I have breast cancer on both sides of the family.

Paternal

• Great Grandmother
• Grandmother
• Aunt
• Same Aunt's Daughter

Maternal

• Mother

My aunt and dad got tested because he was treated recently for prostate cancer, and so did the rest of my cousins, and nothing came up. Though my dad barely gave me his results, and it took lots of asking to get any answers. My Genetic Counselors offered to get my mom free testing through their services, as long as she could go somewhere to do the blood draw. And she said "she'd ask her doctors" and nothing came of it.

Medical knowledge being passed down to me in my family has been shitty. Dad had issues with his prostate for 2 years and didn't tell me until he accidentally group texted his sister (same aunt who had breast cancer) and me telling her "I'll alone tell daughter if I get bad results back." Right around Christmas too. LOL. And before that I had a friend at the time know that a different Aunt had melanoma late stage because my parents "didn't know how to tell me/didn't know if I could handle the news" as a kid.

Anyone else experiencing this? IDK if my children wanted me to do additional genetic testing, I'd be like when and where kiddo... No questions asked because I would want them to have all the medical knowledge they needed to make an informed decision.

With this latest update my pixel watch can barely hold a charge of 16hrs, forget that if I work out. I put it on this morning after charging overnight, went on a 2hr bike ride this morning, and it's dead by 1:30p. When I checked at 11am I had 50% battery. Anyone else with an older watch battery just tanking now? I've barely had this watch a year and a half. This is unacceptable.

I have tried a full reset yesterday morning and that did nothing.

This might be a silly question, but cant find many pics of the Kate Spade Dumpling bag on. Can y'all spam me with pics of you all wearing this bag?

I've been wearing an old vera crossbody (Claire) as a mom bag and it's... Too small 😅

This one caught my eye but I can't tell if I'll like like it without seeing people wear it.

Thanks in advance 💜

Hi All,

I'm working on a large tracking workbook, consisting of several clinical trials in order to track by patient detail the payments we are owed by the funder, what we have received, and the difference. All these payments are delayed by 3m-2 years in some cases and leadership wants to accurately predict how much we are owed.

I think what where I'm running into issues is that while I did standardized as much as I could, there are still several columns for each study that don't apply to other studies. I.e. some studies have different arms they could be enrolled in, some are just a 1 time enrollment payment, others have several milestones that can receive payments. But every sheet has roll ups that are standardized that I need in the Pivot Table. Those being:

• Protocol
• Randomized Date
• Federal Accrued
• Foundation Accrued
• Industry Accrued
• Supplement Accrued
• Federal Received
• Foundation Received
• Industry Received
• Supplement Received
• Total Owed

The Accrued and received columns sum the individual payments into those buckets, that way we can go back to the funder and ask specifically what we are missing for to see if they missed paying us for that milestone specifically.

When I tried pulling all these sheets into Power Query, I was able too, and aggregated all the sheets into one via Power Query. Then I tried to pull that aggregate into a pivot table. No Pivot table Loaded and all I got was "load to data model failed" on each queries. Am I asking for too much? Can I get rid of the extra columns in Power Query that do no align together with ruining the data that is being pulled in by formulas.

I have if statements pulling into the table for the individual, study specific milestones, from a separate table that automatically helps us track payments accrued, and the "standard columns" have sums formulas that sum the columns that apply to them from the individual milestone columns. The milestone, study specific received columns are entered in manually and have no formulas, but are rolled up into the standard columns just like in the accrued side. And the total owed column is also a formula of the standard accrued and received columns.

The goal of pulling this into a pivot table is so we can give high level data to leadership to actually start tracking how much we are owed, given the constant delay in payments, and to have a real sense of the deficit this specific program runs year to year. This way they can accurately plan for the yearly "donation" from other sources of funding in the department.

If you made it through this post, thank you! Any help is appreciated.

I'm using Excel 365.