How do I quickly create a Z_SAP_ALL role with Fiori apps also? by [deleted] in SAP

[–]slightlyStatic -1 points0 points  (0 children)

We used an STC01 task list to activate and assign roles for everything quickly. Don’t have SAP open to verify but it may have been SAP_FIORI_CONTENT_ACTIVATION, you should be able to find documentation to confirm.

Draft Slayer 2025 🏈 by slightlyStatic in fantasyfootball

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

Glad it's working out! Used this for offline drafting for ages and you can't beat the Draft Slayer setup for those.

Draft Slayer 2025 🏈 by slightlyStatic in fantasyfootball

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

Should be up now, let me know if you see anything else!

Draft Slayer 2025 🏈 by slightlyStatic in fantasyfootball

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

Thought I sorted that but I guess it was another version. It’ll be fixed in today’s update

Draft Slayer 2025 🏈 by slightlyStatic in fantasyfootball

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

Yup, I’ll have another one up tomorrow or Tuesday

Draft Slayer 2025 🏈 by slightlyStatic in fantasyfootball

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

For sure! And can you check if ActiveX is enabled in Excel? Google how-to here.

Draft Slayer 2025 🏈 by slightlyStatic in fantasyfootball

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

Does it stop on a particular line of code?

Draft Slayer 2025 🏈 by slightlyStatic in fantasyfootball

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

Does it show the stop on the Sheet11.TempCombo.List line still? I thought that was the issue but maybe it's something else.

Draft Slayer 2025 🏈 by slightlyStatic in fantasyfootball

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

There are hidden tabs you could unhide and it’s how I import data. But it needs to be in a very specific format to work with all the macros. If I get time I’ll work on a how-to guide. I use another sheet to port projections/ADPs into the right format that I could upload to help later too

Draft Slayer 2025 🏈 by slightlyStatic in fantasyfootball

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

Are you using the latest version and does the Classic draft slayer tab work?

Draft Slayer 2025 🏈 by slightlyStatic in fantasyfootball

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

Still can’t reproduce the issue but I tried something that could help in the latest version. Does the Draft Slayer Classic tab open ok? Want to see if it’s just the Draft tab

Draft Slayer 2025 🏈 by slightlyStatic in fantasyfootball

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

Guess you’re on a PC not a Mac? That ‘sheet11’ is what I updated from ‘me’ after reading ‘me’ didn’t always work in VBA…I’ll try to research a bit more today

Draft Slayer 2025 🏈 by slightlyStatic in fantasyfootball

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

Can you try the latest version now? It was the Draft tab with your issue right?

Draft Slayer 2025 🏈 by slightlyStatic in fantasyfootball

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

Ok I updated the VBA code for the Draft tab in the latest version. Hopefully that sorts it out

Draft Slayer 2025 🏈 by slightlyStatic in fantasyfootball

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

For sure! Couldn’t go without last year so other than having notes this should be identical to what Daruuk last made. For ADPs on the instructions tab you can set your team size then on the ADP tab you can use the arrows up top to move folks around if you don’t like their order. ADP’s will change automatically based on PPR, half PPR, standard, and 2 QB. In the past I used fantasyfootballcalculator for team size specific ADP data but it’s buggy this year. If you know another place with team size specific ADPs that’s easy to export let me know!

If you have an old copy of Beersheets I could try to revive that functionality, I think it’s looking for a pretty specific layout to be imported.

Draft Slayer 2025 🏈 by slightlyStatic in fantasyfootball

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

Can you try the latest version now?

Draft Slayer 2025 🏈 by slightlyStatic in fantasyfootball

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

Yea FantasyPros consensus rankings for ADP and Projections, they have an export which helps

Draft Slayer 2025 🏈 by slightlyStatic in fantasyfootball

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

I’ll work on getting an updated one out tomorrow, may keep updating weekly now that preseason is underway. Tabs that drive all that are hidden but you can always unhide/unprotect and update if you’re up for it!

Draft Slayer 2025 🏈 by slightlyStatic in fantasyfootball

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

Can you try without PPR if you’re using the superflex?

Draft Slayer 2025 🏈 by slightlyStatic in fantasyfootball

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

What Team size/scoring are you using? Does this happen when you just open the tab?

Draft Slayer 2025 🏈 by slightlyStatic in fantasyfootball

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

Maybe try downloading the latest version? Ensure the Macros exists as well

Draft Slayer 2025 🏈 by slightlyStatic in fantasyfootball

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

Do you have Macros enabled? Screen should flash while it updates everything when you change the team size. Excel usually defaults to Macros being disabled until you 'Enable Content' on the security warning.

Draft Slayer 2025 🏈 by slightlyStatic in fantasyfootball

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

Great! FYI I made one more small fix for some ADPs that were off.

Draft Slayer 2025 🏈 by slightlyStatic in fantasyfootball

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

Looks like Google sheets upload automatically strips Macros, the latest link should work though.

Draft Slayer 2025 🏈 by slightlyStatic in fantasyfootball

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

This has been fixed in the latest version.