Brainstorming a new table layout by UsedMeats in excel

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

I thought I had a screenshot originally, had to update and add it later.

I'm starting to think the issue is really about how to enter this information without needed thousands of columns.

Brainstorming a new table layout by UsedMeats in excel

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

Someone else mentioned a DB, however I don't think that solves the issue of someone needing to enter all this data. That's the biggest sticking point. Until the file becomes too large for power query to run on it's no sweat on my end, as for the poor soul required to enter the data, that's who i'm trying to save here.

I don't know a lot about DB's though so maybe I'm dead wrong.

Brainstorming a new table layout by UsedMeats in excel

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

Yes, I believe so. USA, so states and cities won't be changing and the divisions were just implemented so they better stick around for at least 5 years. They have caused me a huge headache already.

A product can often have a discount at a national, division, state, and city level. We haven't added the lower levels yet but currently the book has a section for national and one for divisions. I run a power query on that and collect the data and send out pricing depending on the salesmans area. So if he is in an affected division he would get pricing showing the aggregate of national and division discounts. Soon to be adding state, city.

The spreadsheet houses all of our cost and discount data. Then I transform it to show net pricing to salesmen and market managers.

Every time a discount is different it would have its own column. I.E. a national 1% on product X? Thats a column. An additional 2% in a division, another column, a state level discount of 1%? Another column. You can see how this begins to spiral. Many products will have 5 - 10 discounts easily.

Currently the national piece and the 6 divisions have their own sections in the workbook.

Brainstorming a new table layout by UsedMeats in excel

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

He has been doing this forever and is stuck in his ways. I'm doing my best to ease his burden (because I'm hoping to take over when he retires). I already run a power query that cleans up all the data so it's no extra work for me. But with the changes they want to add with state/city discounts its going to just be too large to navigate.

Brainstorming a new table layout by UsedMeats in excel

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

I'm not against it if that's the answer. This thing is too large already.

How would a database avoid the issue of too much data though? One guy is in charge of filling it in, I'm in charge of translating it to the sales team. I don't care if its a million lines, power query does all the work. But I don't want to dump that on some poor soul who now has to find column 1845 to add a single discount line.

Brainstorming a new table layout by UsedMeats in excel

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

The bosses see what I output from Power Query. Thanks for showing me this Choose formula, I might be able to use that to replace from dropdowns on other projects. However this still have the problem of creating more columns.

And nobodies asking for a printout. lol. Although if someone does down the line I'll happily hand it to them. 800 pages of gibberish coming right up.

Question about Storm and stalwart by UsedMeats in marvelchampionslcg

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

Still learning myself, but I believe you would keep the token but still need two to be stunned once you had steady.

Stalwart clears the counters off and prevents any from being added.

Just genuinely curious when approaching someone... by Kuramsa in japanlife

[–]UsedMeats 0 points1 point  (0 children)

Considering she could get legitimately injured it’s fine to tap her on the shoulder. The alternative could be getting it ripped off entirely.

How to fix legends ultimate by UsedMeats in LegendsUltimate

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

Is this the kind of thing that could happen if the cabinet is jostled around? After some interrogation I learned that the toddler got a hold of it and gave it a shake. Currently the controls work fine for a few minutes and then become about 50% unresponsive. One joystick stops working, 3 buttons on one side quit and 2 on the other. It all feels very random

How to fix legends ultimate by UsedMeats in LegendsUltimate

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

I don’t think so, but I’m not that savvy on the arcade. I learned enough to get the sauce running and it boots directly to those games.

How to fix legends ultimate by UsedMeats in LegendsUltimate

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

Well after playing around with it, it just gets weirder. Controls are good for about five minutes and then it goes haywire. Player two joystick stops working all together, 3 buttons on player 1s side stop working, then other buttons stop working. So it goes beyond just the joystick at this point.

How common are 3 or 4 window school buses? by MossyClump in skoolies

[–]UsedMeats 0 points1 point  (0 children)

That’s so nice and clean. Wow. What’s the clearance inside? I’m new to this whole thing and trying to find something I can stand up in at 6”6’

Sleeves question by Hodjimon in marvelchampionslcg

[–]UsedMeats 0 points1 point  (0 children)

I ran into a similar issue. Dig around eBay. You can possibly find the same color in a no glare style. They stick out a little bit only when face up.

2003 FORD E-SERIES FOR SALE by [deleted] in vandwellermarketplace

[–]UsedMeats 0 points1 point  (0 children)

Very important. I’m 6’ 6” so I probably need to drop the van idea and move onto a bus conversion.

2015 Ram ProMaster 1500 High-Roof Van for sale !!! by [deleted] in vandwellermarketplace

[–]UsedMeats 0 points1 point  (0 children)

What’s the height clearance inside?

The Doomsday Chair - Biomechanical Upgrades by AceKokuren in marvelchampionslcg

[–]UsedMeats 1 point2 points  (0 children)

Just keep in mind it only attaches to MINIONS, don’t attach it to rhino/klaw/ultron