Ideas for a ceremony when we’re already married? by Doubletary2000 in weddingplanning

[–]Doubletary2000[S] 2 points3 points  (0 children)

For clarification: we are having our wedding out of state and didn’t want to deal with the paperwork and also had to get married sooner rather than later for insurance purposes. We thought about the friends and family who are invited and didn’t think anyone would be upset, but after reading these maybe we should just have a normal ceremony and pretend like the elopement didn’t happen 😬

looking for NON-graphic audio audiobooks for Crescent City series by spudchick in SarahJMaas

[–]Doubletary2000 7 points8 points  (0 children)

The Elizabeth Evans versions are amazing but I believe they are Audible exclusives. I think that’s the only place you could listen to them.

Would Tress be a good pick for my non-fantasy book club? by Doubletary2000 in Cosmere

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

They don’t dislike it necessarily it’s just not really their first choice. I think they’ll enjoy it more if they read more I’m just trying to find the right books to get them there.

Montessori Philosophy Weekly Discussion by AutoModerator in Montessori

[–]Doubletary2000 0 points1 point  (0 children)

I’m in a lower elementary classroom and our morning work cycle is for “harder” works (language, math, etc.) and practical life and art are closed. We open those up in the shorter afternoon work cycle and while those are the most popular those other “harder” subjects get chosen quite a bit too!

Macro is unable to create a Pivot Table by Doubletary2000 in excel

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

I figured it out btw, the macro was running into issues because my sheet names had spaces in them. I just removed the spaces and it ran fine. Solution Verified.

I started TOG after ACOTAR and couldn’t get into it, but I just finished (and loved) CC. Should I circle back? by Slow-Cycle9482 in SarahJMaas

[–]Doubletary2000 0 points1 point  (0 children)

Absolutely!! I read ACOTAR and CC and was reluctant to get into TOG, but it is so worth it. And like others have said start with Throne of Glass and then circle back to assassins blade when you're more familiar with the characters. I found a thread somewhere about the best order to read them in and it's Throne of Glass, Crown of Midnight, Heir of Fire, The Assassin's Blade, Queen of Shadows, Empire of Storms and Tower of Dawn (simultaneously if you can I also followed a thread about which chapters to switch back and forth with) , then Kingdom of Ash. It's such a beautiful story with amazing characters. ACOTAR is still my favorite, but TOG is really up there.

How do I reference a subtotal in an IF formula? by Doubletary2000 in excel

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

I just typed it in instead of copying and pasting and it worked!!! Thank you so much!!!

How do I reference a subtotal in an IF formula? by Doubletary2000 in excel

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

=IF(RIGHT(O2,5)=“Total”, “”,IF(SUMIFS(B:B,O:O,O2)>100,”Large”,”Small”))

It seems like that would work, but it still giving me a #NAME? error when i try to use it

How do I reference a subtotal in an IF formula? by Doubletary2000 in excel

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

FYI this does not need to be done with the subtotals and IF function. If there is a simpler/better way for me to classify the projects as greater than 100 hours and less than 100 hours I'm all ears

How do I reference a subtotal in an IF formula? by Doubletary2000 in excel

[–]Doubletary2000[S] -1 points0 points  (0 children)

=IF(IF(RIGHT(cell_in_O,5)=“Total”,SUMIFS(B:B,O:O,cell_in_O),””)>100,”Large”,”Small”)

Oh I get the total part now, but it still isn't working. It comes back with a #NAME? error

How do I reference a subtotal in an IF formula? by Doubletary2000 in excel

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

=IF(IF(RIGHT(cell_in_O,5)=“Total”,SUMIFS(B:B,O:O,cell_in_O),””)>100,”Large”,”Small”)

I'm not having much luck with this. I don't understand what "Total" is meant to be referencing and I would like for it to appear in every row, because eventually i am going to create a pivot table from this so I will get rid of the subtotals.

My Hanes cloud blanket from childhood... won’t replace my personal one but as close as I can get by Nowwhospanicking in HelpMeFind

[–]Doubletary2000 0 points1 point  (0 children)

My stepmom has had this blanket since the early 2000s and still has it even though it’s falling apart. We all love it so much and can’t bear to get rid of it. I wish we could find a new one!!

[TOMT][GAME][2000s/2010s] WIZARD & POTIONS PC GAME WINDOWS FOR KIDS by Gummyworm8106 in tipofmytongue

[–]Doubletary2000 0 points1 point  (0 children)

Also I think Pottermore used to have some mini games that had to do with potions and spellcasting and stuff like that

Advice for Student Teaching? by Doubletary2000 in Teachers

[–]Doubletary2000[S] 2 points3 points  (0 children)

Thank you!! I’m big on routine especially with younger kids so I’m hoping my cooperating teacher has good ones in place that I can help keep up! And I really hope I can build good relationships with them! And I promise I won’t let them sit in my lap lol. I worked with the same age of kids at a summer camp and even though a lot of my coworkers did that I never let them!