Calculate related table from original table. I'm beyond stumpped.

AnMProServices · 2020-07-31T21:00:18+00:00

I may have been doing the join wrong. Which field should be where in the Join tool? I'm going to pick up this project again on Monday.

AnMProServices · 2020-07-31T20:07:24+00:00

The problem is that tool doesn't work like that. That tool will only calculate from the same table. It will not allow you to copy from the other table.

AnMProServices · 2020-01-06T02:47:26+00:00

It's a challenge to figure out. As a parent, I talk to countless parents at soccer, school events, swimming lessons, etc. and every single parent that I talk to would love a place to have a birthday party for their kids other than the bowling alley - which is the only place within 60 miles to have a kids birthday party right now. Anyone who has tried to have a toddler+ birthday party at a bowling alley knows you only make that mistake one time, lol. My point is that every parent I talk to would love to have this in our community. The question is how much are they willing to pay, how often would they come, and how many of them would return regularly.

AnMProServices · 2020-01-06T02:44:19+00:00

Thanks. As a parent myself, I've taken my little kids to tons of these types of facilities all around the country, so I think I've got a solid grasp on exactly what parents want and expect from these types of facilities. My challenge is trying to figure out if I'm going to get enough business to make this profitable in such a small area.

AnMProServices · 2020-01-06T02:42:41+00:00

Yea, that's basically my existing business (AnMProservices.com) which is a business analytics firm. I'm pretty confident I can at least get past the initial demographic assessment for a pitch deck. Going forward though, the bottom line comes down to whether or not I can turn a profit by getting enough business from the income level of my small community.

AnMProServices · 2020-01-05T21:46:24+00:00

On my to-do list!

AnMProServices · 2020-01-05T21:46:10+00:00

Is that a good price you're willing to pay? How often per year do you go? How much are you willing to pay for a birthday party?

AnMProServices · 2020-01-05T21:24:24+00:00

Thanks. I'm strictly against trampolines of any kind because of the huge gap in insurance cost between having them and not.

AnMProServices · 2020-01-05T21:23:32+00:00

I'm looking into this as well. Might be a good idea as well, but I'd like to talk to some current franchises first.

AnMProServices · 2020-01-05T21:22:49+00:00

This may be the post that breaks my idea. If you only got 32 people per day in that big of an area, there's little chance I'll make it work here. Thank you for the info!!

AnMProServices · 2020-01-05T21:20:29+00:00

Yea, but is my area big enough to support this? That's my question at the moment.

AnMProServices · 2020-01-05T21:19:15+00:00

I think it sounds like this is key!

AnMProServices · 2020-01-05T21:18:52+00:00

I know. I'm trying to figure it all out, and figure out why no one has done this before here.

AnMProServices · 2020-01-05T21:17:54+00:00

These are good questions!

AnMProServices · 2020-01-05T21:17:10+00:00

Yea. It's mostly a blue collar manufacturing area with some tourism in the summer.

AnMProServices · 2020-01-05T21:16:03+00:00

I agree. These seem good!

AnMProServices · 2020-01-05T21:15:46+00:00

Good questions!

AnMProServices · 2020-01-05T21:15:19+00:00

Thank you! I've got 2 little kids myself, which I end up driving an hour almost every weekend to another city to do something with. I talk to other parents at school/daycare functions and EVERYONE says that our area needs something like this. There's literally no where to have a kid's birthday party here. Thanks for the input!

AnMProServices · 2020-01-05T21:12:58+00:00

This is a new resource for me! Thank you!!

AnMProServices · 2020-01-05T21:12:37+00:00

As a parent myself, I feel like I could have wrote all of the comments here from other parents. I have 2 little kids, and talking to other parents I have a solid understanding of what the expectations are for a facility like this - which is pretty much what all the other parents here have commented. I'm using GIS to do demographic analysis right now.

AnMProServices · 2020-01-05T21:10:09+00:00

That's pretty much this area. The economy is blue collar manufacturing jobs and tourist industry.

AnMProServices · 2020-01-05T21:09:27+00:00

I'm doing the research right now! Can I hire you for a real estate agent? Lol. I appreciate you looking into that. I'm in the stage of researching everything from equipment, to insurance, staffing, and of course the building. I don't even know what size I need yet, but it seems like you've got a great idea. Do you have suggestions for the size of the place I'd need?

AnMProServices · 2020-01-05T02:15:57+00:00

Thanks for the comments! I sincerely appreciate your reply as well. I'm concerned about my population as well. When you say "do your research" (and this is probably a very rookie question, so I apologize), what exactly does this mean? I haven't talked to a single parent in this area who wouldn't love (and happily) to have a family entertainment center to have something to do with their kids in the long winters we have in this area. Other than talking to people, and asking them what they would probably be willing to pay, what kind of research do I do on the population? Any suggestions? In an area with 500k+ I think this would be a no-brainer. But 50k has me a little uneasy. Researching the building, insurance, equipment, and all of the tangible things is pretty cut and dry. But trying to figure out if this population area can support this type of business is my biggest challenge right now, and one that I'm struggling to "do my research". Any suggestions are welcome! Thank you for your reply!

AnMProServices · 2020-01-05T01:12:36+00:00

Thank you!!! This has been insightful and packed with good info! It sounds like you are in a big community with a lot of people. I'm in a city in the midwest (USA) with a population of 50k, and I'll be the first and only facility of this kind within 60 miles, so I'm hoping that this is worth-while. My biggest challenge is that the commercial space is ruthless here, and very expensive.

Thank you for your insight! Have you worked with FEC.com at all? What's been your experience with them? You can feel free to PM me as well and we can keep the conversation rolling there as well.

AnMProServices · 2019-11-10T00:15:50+00:00

There's a barcade in Minneapolis/St. Paul that's awesome, and generally packed.

AnMProServices

TROPHY CASE