google sheets – Can you filter a column in size order of an imported HTML? I have tried using query with no success

Using the below importhtml I’m hoping to order the numerical data of the third column in size order, but it seems I have lost my way on the model I was following. Any help greatly appreciated.

=importhtml("https://fbref.com/en/share/SxTNE","table",0)

query(IMPORTHTML("https://fbref.com/en/share/SxTNE"”,”table”,2),”Select * where Col3=’Crdy'”)

importhtml – Can you filter a column in size order of an imported HTML ? Ive tried using query with no success

Using the below importhtml I’m hoping to order the numerical data of the third column in size order but seemed to have lost my way on the model i was following. Any help greatly appreciated.

=importhtml(“https://fbref.com/en/share/SxTNE”,”table”,0)

query(IMPORTHTML(“https://fbref.com/en/share/SxTNE””,”table”,2),”Select * where Col3=’Crdy’”)

security – How does the SolarWinds hack affect Bitcoin’s success?

Several layers of the modern payment processing stack are affected. If I buy something online using my credit card, I might be using a Windows machine, on AT&T, using Visa to pay for something. What could the hackers do?

Technically, maybe they’d be able to dump a bunch of people’s full names, credit card numbers, etc. If so, I imagine the credit card providers would block everyone’s cards and issue new ones.

Suppose the information is used in a state-sponsored attack to undermine trust in the dollar. Since money is created at the time loans are made, isn’t it at more risk now that the operating systems, networks, and organizations are compromised via a hard-to-remove APT?

Much of the hack doesn’t apply to Bitcoin at any level. Most servers probably run Linux, there’s no organization to hack, some ISPs may be hacked but at worst that could cause local problems for people using the offending ISP.

What is it? Error saving project data (success)

After clearing the submitted and verified data and other project data, he is giving this error now when he starts posting new links.
Error saving project data (Success) and interrupts the project.
How can I solve this?

statistics – How to handle degrees of success in roll under systems

I’m working on an RPG system that uses 2d6 roll under Skill for resolutions. On paper this system looks really good so
far, but I have one major issue: Degrees of Success, especially when it comes to Contest (Skill vs Skill) resolutions.

Status Quo

Your character’s Attribute + Skill (e.g. Charisma + Persuasion) form a Target Number that’s between 2 and 12. You roll 2d6,
sum them, and the sum has to be equal to or lower than the Target Number. Rolling a 1 has a special positive meaning,
rolling a 6 has a special negative meaning. Additionally, 2 ones are always a success, 2 sixes are always a failure,
regardless of Skill.

The problem

Imagine 2 parties contesting each other:

  • Character A has a Target Number of 5 (pretty bad), and character B has a Target Number of 10 (pretty good).
  • Character A rolls a 5 and succeeds. Character B and rolls a 6 and succeeds.
  • Character B has the better Degree of Success, as the margin between the player’s roll and the character’s Skill is
    bigger than for Character A.

If you say that lower is better, a character with Target Number 2 (very, very bad), who rolled a 2, will always have
a better Degree of Success over a character with a Target Number 12 (very, very good), who rolled a 3.

Naive solution

My approach was to subtract the rolled number from the character’s Skill. You have a Target Number of 6 and rolled a 4?
6-4=2. You have a Target Number of 11 and rolled a 3? 11-3=8. It works, but I’m worried that this resolution will be
too slow for actual play – we all know these sessions that last for hours and nobody is able to count straight anymore.

The best solution would allow a player to determine the Degree of Success/Failure in the same step to see if the
character succeeded or not.

Other systems

Other systems that handle Degrees of Success for rolling under mechanics:

  • Call of Cthulhu: You have certain threesholds (half your skill, 1/5 your skill) at which you score an increased Degree of Success. – very coarse when you only have 2d6 instead of a 1d100 (but could work)
  • Unknown Armies: Basically like Black Jack–you roll under your Skill threshold, but as high as possible. Doubles (11, 22, 33) are criticals. – sadly doesn’t work, as ones and sixes have a special meaning. Flipping the meaning (6 is good, 1 is bad) also is iffy, as it’s flipping the understanding, that you have to roll under a threshold.
  • ???

What other systems or resolution systems are there, that tackle this problem?

statistics – How to handle degrees of success in roll under dice mechanics

I’m working on an RPG system that uses 2d6 roll under Skill for resolutions. On paper this system looks really good so
far, but I have one major issue: Degrees of Success, especially when it comes to Contest (Skill vs Skill) resolutions.

Status Quo

Your character’s Attribute + Skill (e.g. Charisma + Persuasion) form a Target Number that’s between 2 and 12. You roll 2d6,
sum them, and the sum has to be equal to or lower than the Target Number. Rolling a 1 has a special positive meaning,
rolling a 6 has a special negative meaning. Additionally, 2 ones are always a success, 2 sixes are always a failure,
regardless of Skill.

The problem

Imagine 2 parties contesting each other:

  • Character A has a Target Number of 5 (pretty bad), and character B has a Target Number of 10 (pretty good).
  • Character A rolls a 5 and succeeds. Character B and rolls a 6 and succeeds.
  • Character B has the better Degree of Success, as the margin between the player’s roll and the character’s Skill is
    bigger than for Character A.

If you say that lower is better, a character with Target Number 2 (very, very bad), who rolled a 2, will always have
a better Degree of Success over a character with a Target Number 12 (very, very good), who rolled a 3.

Naive solution

My approach was to subtract the rolled number from the character’s Skill. You have a Target Number of 6 and rolled a 4?
6-4=2. You have a Target Number of 11 and rolled a 3? 11-3=8. It works, but I’m worried that this resolution will be
too slow for actual play – we all know these sessions that last for hours and nobody is able to count straight anymore.

The best solution would allow a player to determine the Degree of Success/Failure in the same step to see if the
character succeeded or not.

Other systems

Other systems that handle Degrees of Success for rolling under mechanics:

  • Call of Cthulhu: You have certain threesholds (half your skill, 1/5 your skill) at which you score an increased Degree of Success. – very coarse when you only have 2d6 instead of a 1d100 (but could work)
  • Unknown Armies: Basically like Black Jack–you roll under your Skill threshold, but as high as possible. Doubles (11, 22, 33) are criticals. – sadly doesn’t work, as ones and sixes have a special meaning. Flipping the meaning (6 is good, 1 is bad) also is iffy, as it’s flipping the understanding, that under is better.
  • ???

What other systems or resolution systems are there, that tackle this problem?

lens – Has anyone had consistent success in using M42 lenses via adapter on the 5D MkIV?

Intermittent Er20 code on 5D MkIV using M42 to EOS adapter

I am wondering if anyone has encountered this issue. I’m using Fotodiox Pro metal adapters to attach either Asahi Pentax Takumar lenses of various focal lengths OR several varieties of Helios 44 (or Carl Zeiss Jena Biotar) 58mm f/2 to my 5D MkIV. When I am using same lenses and adapters on my APS-C (crop-sensor) EOS 40D, no error issues are encountered.

No error messages occur on 5D when using EOS lenses or third party lenses with Canon mount.

After switching off the camera and turning it back on, the error message remains, ditto after removing/re-installing battery.

The best “clue” I’ve managed to get is that when I remove the M42+Adapter combination, I notice the 5D’s mirror is “stuck” halfway. It re-positions correctly after recycling camera.

That’s about as far as I’ve been able to diagnose this intermittent issue.

How to change the coupon code success message Magento2

How do I change the coupon code message?

enter image description here

Interview: Q&A with DediPath CTO Ernie Quick on His Company and Making Success Happen

DediPath

As we continue our Low End Box Interview Series, today we are talking to Ernie Quick, Founder and CTO of DediPath, a hosting company that specializes in IaaS, Colocation and DDoS Protected Services. DediPath has been in business for a few years and has enjoyed tremendous growth over that period of time. Ernie has spent most of his career in the hosting industry and so we are excited to learn more about his methods and perspectives.

So, let’s get started with the interview!

Tell me about your background and your company’s history?

DediPath was launched with the vision of providing a unique approach to Infrastructure as a Server (IaaS). To ensure the success of those that partnered with us, DediPath is committed to three foundational pillars. First, a focus on pure performance, encompassing not only network capacity, network latency, and hardware product offerings, but also supporting cast of experienced support staff. Second, DediPath focuses on the value of our offerings: providing a great experience at a predictable price, and allowing our partners to grow with us, by finding savings for them to allow us to all succeed together. Finally, DediPath ensures that we provide our partners with the utmost in flexibility, by providing a full gamut of solutions that include managed services, colocation, cloud offerings, bare metal, and DDOS protected transit. This focus allows DediPath and our partners to work together harmoniously to provide a premium solution.

What would you tell someone looking to start a hosting company today? What advice would you offer?

Having seen both sides, as a hosting customer as well as the infrastructure provider, it really comes down to understanding your needs and ensuring that your provider meets those needs in the context of your fiscal restraints. It is easy to ‘sort by cheapest’ or ‘sort by most expensive’ hoping to compensate for the performance of the cheapest or expecting the most expensive to be the best. I recommend that you take the time to see what kind of facilities a provider offers, take the time to perform ping and trace tests against their servers, and even reach out to their team to ask the questions important to you. A great organization will explain where there is a good fit, and where there it may not be. We always strive to be such a great organization.

Where do you think the future takes the hosting industry?

With world events driving a new wave of ‘work from home’, we are all starting to see more office work taking place online. Face to face office meetings have found themselves now taking place over VOIP phone bridges and live video group chats. We see offices moving their on-site infrastructure to cloud based infrastructure that can still maintain control over. With this you will likely see a continued demand for virtual desktop and VDI environments for remote workers to access while still having them managed by organizations. We will also likely see those office server closets start to make their way to datacenter colocation for those specialized appliance and server configurations.

Tell me about your top two failures in business? What did you learn from them?

A specific facility selection was one of our biggest learning experiences for sure. Having just completed a migration from the facility, we can recommend ensuring an in-depth research and selection period as well as a forecast for future growth and whether the facility can grow with you. I always recommend investing a little more time up front, which will pay dividends later. We learned from the experience and partnered with top notch facilities who offer massive expansion opportunities as well as outstanding on-site engineering teams.

Tell me about your top two successes in business? 

The people I work with as partners are what I enjoy most. I enjoy focusing on the positive in that we continuously come together. We find solutions in the hard times. We learn from each other and through each experience. I take pride in our team for giving it all, every day. I also have the honor of applauding their professionalism and experience every day.

What do you enjoy most about your role? What do you find most difficult?

I enjoy being able to see everything from a 30,000 FT overview. I think for me the most enjoyment I get, is when I see customer growth and a lot of orders in the kitchen so to speak, and watching our teams outperform and crush goals.

It is also nice to be challenged continuously as it keeps you sharp and on your toes.

Both personally and professionally, what guiding principles ground you?

Coming from a background of public service and nonprofit work, I find that those experiences have driven my direction and guiding principles. I think it is crucial that we focus on how else we can help others grow and with that, we grow as well and enable others to do the same. Knowledge sharing is crucial, as in that when one of us learns a lesson, we should recover and then begin to share that lesson with others so that they do not repeat it. With that shared experience and learning, the industry continues to grow and support those that depend on us.

Give us some details on new and exciting things you are working on?

We have one major new offering coming soon as well as an expansion of one we currently offer. Working hand in hand with the migration to residential connections and wireless connections as people move to work from home, we are continuing to expand our presence near the network edge. This edge concept means that we are constantly working to get server infrastructure closer to the end user. We have started this expansion in Las Vegas, NV and Jacksonville, FL and look to expand to 10 new locations by the end of the year.

Our next major product offering is a true clustered cloud backend storage that works with our entire set offerings. Offering nearly limitless storage expansion abilities to virtualized services, bare metal, and even colocation, we are excited to begin offering high availability storage with redundancy and replication built in with a turnkey solution for our partners.

Why should customers trust you and your business?

The organization is founded and run by industry professionals who have been building great relationships for a long time. We have a massive combined experience to pull from and have always placed the growth of our partners first. There are no corners cut as we always look to provide the best in facilities, network, and support. We continue to add features and capacity, many times at no additional cost. Our partners are our business and supporting them is the priority!

Final thoughts and anything you would like to add?

We find ourselves in the unique position of being able to support others grow their own business during a time of monumental change in both end user needs as well as exponential growth our partners are also seeing. We enjoy the candid and open conversations we can have with our partners and look to continue to grow with and support them!

Check out DediPath by clicking their banner below!

Jon Biloh

I’m Jon Biloh and I own LowEndBox and LowEndTalk. I’ve spent my nearly 20 year career in IT building companies and now I’m excited to focus on building and enhancing the community at LowEndBox and LowEndTalk.

Interview: Q&A with DediPath CTO Ernie Quick on His Company and Making Success Happen

DediPath

As we continue our Low End Box Interview Series, today we are talking to Ernie Quick, Founder and CEO of DediPath, a hosting company that specializes in IaaS, Colocation and DDoS Protected Services. DediPath has been in business for a few years and has enjoyed tramednous growth over that period of time. Ernie has spent most of his career in the hosting industry and so we are excited to learn more about his methods and perspectives.

So, let’s get started with the interview!

Tell me about your background and your company’s history?

DediPath was launched with the vision of providing a unique approach to Infrastructure as a Server (IaaS). To ensure the success of those that partnered with us, DediPath is committed to three foundational pillars. First, a focus on pure performance, encompassing not only network capacity, network latency, and hardware product offerings, but also supporting cast of experienced support staff. Second, DediPath focuses on the value of our offerings: providing a great experience at a predictable price, and allowing our partners to grow with us, by finding savings for them to allow us to all succeed together. Finally, DediPath ensures that we provide our partners with the utmost in flexibility, by providing a full gamut of solutions that include managed services, colocation, cloud offerings, bare metal, and DDOS protected transit. This focus allows DediPath and our partners to work together harmoniously to provide a premium solution.

What would you tell someone looking to start a hosting company today? What advice would you offer?

Having seen both sides, as a hosting customer as well as the infrastructure provider, it really comes down to understanding your needs and ensuring that your provider meets those needs in the context of your fiscal restraints. It is easy to ‘sort by cheapest’ or ‘sort by most expensive’ hoping to compensate for the performance of the cheapest or expecting the most expensive to be the best. I recommend that you take the time to see what kind of facilities a provider offers, take the time to perform ping and trace tests against their servers, and even reach out to their team to ask the questions important to you. A great organization will explain where there is a good fit, and where there it may not be. We always strive to be such a great organization.

Where do you think the future takes the hosting industry?

With world events driving a new wave of ‘work from home’, we are all starting to see more office work taking place online. Face to face office meetings have found themselves now taking place over VOIP phone bridges and live video group chats. We see offices moving their on-site infrastructure to cloud based infrastructure that can still maintain control over. With this you will likely see a continued demand for virtual desktop and VDI environments for remote workers to access while still having them managed by organizations. We will also likely see those office server closets start to make their way to datacenter colocation for those specialized appliance and server configurations.

Tell me about your top two failures in business? What did you learn from them?

A specific facility selection was one of our biggest learning experiences for sure. Having just completed a migration from the facility, we can recommend ensuring an in-depth research and selection period as well as a forecast for future growth and whether the facility can grow with you. I always recommend investing a little more time up front, which will pay dividends later. We learned from the experience and partnered with top notch facilities who offer massive expansion opportunities as well as outstanding on-site engineering teams.

Tell me about your top two successes in business? 

The people I work with as partners are what I enjoy most. I enjoy focusing on the positive in that we continuously come together. We find solutions in the hard times. We learn from each other and through each experience. I take pride in our team for giving it all, every day. I also have the honor of applauding their professionalism and experience every day.

What do you enjoy most about your role? What do you find most difficult?

I enjoy being able to see everything from a 30,000 FT overview. I think for me the most enjoyment I get, is when I see customer growth and a lot of orders in the kitchen so to speak, and watching our teams outperform and crush goals.

It is also nice to be challenged continuously as it keeps you sharp and on your toes.

Both personally and professionally, what guiding principles ground you?

Coming from a background of public service and nonprofit work, I find that those experiences have driven my direction and guiding principles. I think it is crucial that we focus on how else we can help others grow and with that, we grow as well and enable others to do the same. Knowledge sharing is crucial, as in that when one of us learns a lesson, we should recover and then begin to share that lesson with others so that they do not repeat it. With that shared experience and learning, the industry continues to grow and support those that depend on us.

Give us some details on new and exciting things you are working on?

We have one major new offering coming soon as well as an expansion of one we currently offer. Working hand in hand with the migration to residential connections and wireless connections as people move to work from home, we are continuing to expand our presence near the network edge. This edge concept means that we are constantly working to get server infrastructure closer to the end user. We have started this expansion in Las Vegas, NV and Jacksonville, FL and look to expand to 10 new locations by the end of the year.

Our next major product offering is a true clustered cloud backend storage that works with our entire set offerings. Offering nearly limitless storage expansion abilities to virtualized services, bare metal, and even colocation, we are excited to begin offering high availability storage with redundancy and replication built in with a turnkey solution for our partners.

Why should customers trust you and your business?

The organization is founded and run by industry professionals who have been building great relationships for a long time. We have a massive combined experience to pull from and have always placed the growth of our partners first. There are no corners cut as we always look to provide the best in facilities, network, and support. We continue to add features and capacity, many times at no additional cost. Our partners are our business and supporting them is the priority!

Final thoughts and anything you would like to add?

We find ourselves in the unique position of being able to support others grow their own business during a time of monumental change in both end user needs as well as exponential growth our partners are also seeing. We enjoy the candid and open conversations we can have with our partners and look to continue to grow with and support them!

Check out DediPath by clicking their banner below!

Jon Biloh

I’m Jon Biloh and I own LowEndBox and LowEndTalk. I’ve spent my nearly 20 year career in IT building companies and now I’m excited to focus on building and enhancing the community at LowEndBox and LowEndTalk.