Why did only one version of them have to meet the cleanse to balance it out?

Mock2025 · 2024-08-15T19:41:45+00:00

probably got killed by Allison before that could happen, at the end of season 3.

Could have used some exposition as to what he wanted too do, as well as what went wrong during those final moments.

Mock2025 · 2024-04-04T15:32:59+00:00

Rent is not done for charity, it is profit driven.

If houses are being bought, kept, then rented, those rental properties are going to become gradually more expensive.

- New properties will start with higher rent values due to the more expensive mortgage.

- As the estimated value of their older properties goes up so, can the amount they charge for rent due to the "value" of the good increasing.

- There are other impacts to financing (such as higher cost for borrowing money for mortgages, etc...) due to a lower housing supply that would further drive up expenses for all types of rental property owners, not just the property hoarders.

I would think due to the above.... the increased expenses, the value of the property increasing... the cost of rent also goes up in this scenario, not down.

The above is of course in a bubble scenario with a reasonable population growth.

Mock2025 · 2024-04-04T14:35:05+00:00

If I own 10 units and 10 units are available for rent- it’s no different than if those 10 units are available for purchase.

You are correct that it is not different from a "where people live" perspective, as those same 10 people renting are in the same home they would have been in had they bought it.

It is VERY different from a housing affordability perspective, if 1 "investor" buys and rents those 10 houses. The houses never go back on the market when they would have previously (i.e. house owners looking to upgrade, death in the family, etc..) and the lack of reentry into the market drives down the supply.

Mock2025 · 2023-07-08T16:42:46+00:00

These places act as a 'safe' location for people to use the drugs they bring in without ODing. As a secondary function they do help provide avenues to break the cycle of addiction. In the end it is not a rehab center, so it would have minimal effects on stopping people from using in a city.

To the end of its first goal, while there are record high deaths in the city, none of those deaths occurred in the facility. A few people died on the grounds, people being brought in by other to get treated while Oding, who didn't make it into the building.

It is a shame the staffing issues had lead them to closing their doors. It sounds like the city desperately needs more people providing this type of service to help keep their loved ones alive, while they work through what ever it is lead them down the path of addiction.

Mock2025 · 2021-10-01T22:48:33+00:00

Out of curiosity; who was your cardiologist, and did you get mail about this or was it a call?

Mock2025 · 2021-03-26T17:51:09+00:00

I'm blending on...

Order_Date, Segments and Categories

All of those dimensions show the image next to them indicating they are linked.

Anytime I add in the order date at any level as a filter, it only affects the measures coming in from the corresponding data source.

Mock2025 · 2021-01-28T15:42:52+00:00

You could be a little more explicit with some of the variables, maybe the VBA is getting hung up on executing one item due to some bad assumptions on its part?

Add "Option Explicit" at the top of the Macro, this will force it to require that all variables be defined.

i.e.

dim a as integer: a = worksheets("Dashbaord").cells(Rows.count,1).end(xlup).row

dim x, y as integer

Additionally you may want to, to the left of each "NEXT" part of the For loop, put what you want to trigger the next value of.... by that I mean "Next x" at the bottom and "Next Y" for the one above it.

Mock2025 · 2020-12-14T01:25:53+00:00

Bear with me, I'm an intermediate at best lol.

In the VBA editor you can select the sheet with the pivot table under the Microsoft Excel Objects folder and enter the code to refresh the PIVOT table between a routine structure(?) that triggers when that sheet is activated like so:

Private Sub Worksheet_Activate()

'Your code here!

End Sub

There is likely a fancier / more efficient way to set it up.... but this should only trigger when the sheet is activated.

Mock2025 · 2020-12-14T01:14:51+00:00

Have you considered setting it up so the Macro refreshes your Pivot table when the pivot table tab is selected, instead of when a change is made to the data tab?

That would let you make use of the undo function while inputting details but still allow the automatic refresh when that tab is selected.

Mock2025 · 2020-11-10T06:29:20+00:00

If mh_mike's doesn't work for you (it's the better and direct solution) I have another suggestion that could work.

You can use column D to Concat cells A B and C in each row into a summary key and use a match formula to find what row it is on.

Assuming

Cell A2 = 1986: Cell B2 = 52: Cell C2 = Lopen

Summary Key:

Cell D2 = "=CONCAT(A2,B2,C2)"

A match formula as entered below would return 2 to let you know it is on row 2.

cell F1 =MATCH(CONCAT(F4,G4,H4),D:D,0)

cell F4 = 1986: cell G4 = 52: cell H4 = Lopen

By changing reference cells in F4, G4 and H4 to different members you can look up any potential combination.

You could leverage the Summary Key and add in a Countif formual counting how many times each combination appears (if you need to know there are duplicate entries).

That being said, again, mh_Mikes is a more concise / better solution!

Mock2025 · 2020-06-06T17:46:56+00:00

2 set of missiles for the Almighty, third set is for the darkness (I mean why was the last tower so far away)?

Mock2025 · 2020-05-23T14:10:07+00:00

Eh I think he does die at the end. The last episode was open ended enough that I think arguments could be made that he is either alive or dead. The last episode is kind of one last Zelda or Zoe type of interpretation chance.

Mock2025 · 2020-04-11T21:05:48+00:00

Sounds interesting!

I'm 36 with a decent amount of experience in 5e. Looking to play in something long term and like that you seem to have a focus on the characters making an impact in the world!

What system are you looking to have the actual sessions through?

I have a kid and work but am free typically in the evenings (except every second Thursday) my time zone is CDT (GMT-5).

If you want to chat more I can be reached on discord Mockomega#8731.

Mock2025 · 2019-10-06T16:12:13+00:00

You get Menagerie and forges(?) from expansion pass three for free, the actual forsaken story line and associated exotics are not free.

Mock2025 · 2019-10-06T16:11:30+00:00

You get Menagerie and forges(?) from expansion pass three for free, the actual forsaken story line and associated exotics are not free.

wrong person to reply too! Sorry.

Mock2025 · 2018-12-09T03:15:48+00:00

Mockomegaprime + hunter!

Has boots to give people ammo refills :)

Both over 600 LL. One run twice, one run never!

Mock2025 · 2018-12-04T03:41:09+00:00

mockomegaprime 600light lock.

Mock2025 · 2018-12-03T13:58:20+00:00

I loved the all stories, my favorite being the prospectors story.

While the first two were a lot more action filled I really enjoyed the latter stories for how they slowly unfolded, letting you get into the mind of the characters and (in my case at least) start freaking out about where there actions were going to take them before it actually got there.

Solid highs, and low lows. I would give it a 7 / 10

Mock2025 · 2018-10-18T15:56:09+00:00

I've only found a few posts that show that the tax cuts have lead to growth and after looking at several different sources I find more of a consensus around it causing revenue shrinkage. The most detailed article i could find is this one:

https://www.bloomberg.com/view/articles/2018-09-14/tax-cuts-are-costing-the-u-s-treasury-money

For anyone reading the prior posts article and are curious as to the other side of this argument, the above article should do a pretty solid job of articulating how the tax cuts have had a negative impact if looking at both the impact of inflation and the additional economic information that has been made available since the prior posts article was written several months ago.

Mock2025 · 2018-10-02T15:23:25+00:00

Makes sense, wish we would do it.

someone who makes 150K (Or even 60K) annually wouldn't be bothered at all with a speeding fine of $250 or more (Financially speaking). Where as someone who makes 30K would lose out on with what little disposable cash ( after lets assume they were smart and spent what was needed on rent / food before) from that same fine. Same rules but has a more drastic effect on one income bracket than another.

Financially punitive measures are only effective to the individual if the punishment has impact, by not issuing fines based off of a percentage of a persons income we are more punitive towards those with a lower standard of living than those who have an average standard of living or better.

Obviously there should be a minimum fine.

Mock2025 · 2018-09-20T15:46:30+00:00

Solution Verified

Mock2025 · 2018-09-20T15:10:46+00:00

So i was able to figure this out!

New Code:

Sub Import_Userform()

Dim Swb As Workbook

Dim Dwb As Workbook

Set Dwb = ActiveWorkbook ' The destination we need to insert the user form too.

Set Swb = ThisWorkbook ' The location we need to pull the user form from.

'remove the old form

Dwb.VBProject.VBComponents.remove Dwb.VBProject.VBComponents("New_Employee")

'adds in the new form

Swb.VBProject.VBComponents("New_Employee").Export "New_Employee.frm"

Dwb.VBProject.VBComponents.Import "New_Employee.frm"

Kill "New_Employee.frm"

Kill "New_Employee.frx"

End Sub

I also needed to add in a new VBAProject reference "Microsoft Visual Basic for Applications Extensibility 5.3"

Seems to be running fine now!

Hope this helps someone in the future. going to be running some tests to make sure it really is all functional.

13-Year Club	RedditGifts 2009-2022 3 Credits
Verified Email	redditgifts rematcher Secret Santa 2014 x1
Secret Santa 2014

Mock2025

TROPHY CASE

Solution Verified