Jump to content
Subscribe to the Spin Axis Podcast! ×
Note: This thread is 5225 days old. We appreciate that you found this thread instead of starting a new one, but if you plan to post here please make sure it's still relevant. If not, please start a new topic. Thank you!

Recommended Posts

Posted

Hi folks,

I have an Excel spreadsheet I've written in VBA to do the following:

- Scrape all data from a website and post each piece of data in a cell on sheet 2.

- Scrape all

data from a different website and again post each piece of data in cells on sheet 3.

- General if statements throughout sheet 1 to make some calculations.

It's not a particularly complicated spreadsheet so I'm convident it can be ported over to an .asp page in VB to be accessible from any of my machines rather than requiring Excel on all my machines.

Does anyone have any ideas on the best place to start looking at how to port it please?

Cheers,

MBD

SWING DNA
Speed [77] Tempo [5] ToeDown [5] KickAngle [6] Release [5] Mizuno JPX EZ 10.5° - Fujikura Orochi Black Eye (with Harrison ShotMaker) Mizuno JPX EZ 3W/3H - Fujikura Orochi Black Eye Mizuno JPX 850 Forged 4i-PW - True Temper XP 115 S300 Mizuno MP R-12 50.06/54.09/58.10 - Dynamic Gold Wedge Flex Mizuno MP A305 [:-P]


Posted

Do you have a database that you are storing all your information for this spreadsheet? If you do, why don't you just create a grid view that pulls in the data from your database, and then from the gridview, you can save, edit, delete and do whatever you want.

If not, you are going to have to create a connection to the spreadsheet, and then access all the info from there.

Here is an example...

http://www.davidhayden.com/blog/dave/archive/2006/05/26/2973.aspx

10.5* Adams Super Fast 10
17*, 21* Adams Black Super Hybrid
X-24 irons
Jaws 52*,56*,60* Wedges
White Ice #9 Putter

Top Flite Gamer v2


Posted

Take a look at this link. Has VB code as well.

http://www.dotnetcurry.com/ShowArticle.aspx?ID=138

10.5* Adams Super Fast 10
17*, 21* Adams Black Super Hybrid
X-24 irons
Jaws 52*,56*,60* Wedges
White Ice #9 Putter

Top Flite Gamer v2


Posted

Thanks Zack. The spreadsheet itself is currently the storage for any data the spreadsheet pulls from websites, however I'm more than happy to set up an SQL database. The links above are not not quite what I'm looking for but I'll have a look through the site and see if there's anything else on there that may be useful.

Thanks for your help. :)

SWING DNA
Speed [77] Tempo [5] ToeDown [5] KickAngle [6] Release [5] Mizuno JPX EZ 10.5° - Fujikura Orochi Black Eye (with Harrison ShotMaker) Mizuno JPX EZ 3W/3H - Fujikura Orochi Black Eye Mizuno JPX 850 Forged 4i-PW - True Temper XP 115 S300 Mizuno MP R-12 50.06/54.09/58.10 - Dynamic Gold Wedge Flex Mizuno MP A305 [:-P]


Posted

When you are porting over the spreadsheet, do you only want it to be used to see data? You don't want any of your employees to be able to edit the information at all?

If you only want them to view the information, (I know you said the links I sent you weren't what you were looking for, and I'm not trying to be an a-hole) but the second link I sent you should work fine. You can put the data into a gridview and it will look like this...

gridview1.jpg

Well, if you setup a SQL database, you can get rid of Excel and maintain all of your data through the web page. What software are you using for your web application. Are you using Visual Studios, Dreamweaver, or something else? Give us some more details with what you are using and what you want to accomplish with the spread sheet. I don't know if you want the Excel spreadsheet data to look real fancy on the webpage and not have it look like a gridview. At work, we use SQL and Visual Studios 2010 for all our applications. We have got rid of all Excel spreadsheets and use these GridView's for all data to be read,inserted, deleted, and updated.

Just trying to help :)

Zack

10.5* Adams Super Fast 10
17*, 21* Adams Black Super Hybrid
X-24 irons
Jaws 52*,56*,60* Wedges
White Ice #9 Putter

Top Flite Gamer v2


Note: This thread is 5225 days old. We appreciate that you found this thread instead of starting a new one, but if you plan to post here please make sure it's still relevant. If not, please start a new topic. Thank you!

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



  • Want to join this community?

    We'd love to have you!

    Sign Up
  • TST Partners

    PlayBetter
    TourStriker
    Golfer's Journal
    ShotScope
    The Stack System
    FitForGolf
    FlightScope Mevo
    Direct: Mevo, Mevo+, and Pro Package.

    Coupon Codes (save 10-20%): "IACAS" for Mevo/Stack/FitForGolf, "IACASPLUS" for Mevo+/Pro Package, and "THESANDTRAP" for ShotScope. 15% off TourStriker (no code).
  • Posts

    • Day 296 - 2025-07-23 Got a good hour+ of work in after a few lessons on my off day today. 😉 Recorded some, had mirrors in both places FO/DL. Same stuff, but made sure the right knee was fine.
    • Skill work/clubface control. And…
    • That's not always true. I can apply a force perpendicular to the club… through the center of mass. No rotation. 😉 You don't "apply" a torque. A torque is a result of the force away from the COM. And, per the above, it's not exclusive of the translational motion. Nit-picky, yes. But if we're gonna talk about physics, let's actually talk about physics, and not the ninth grade version of it. I know what you mean, but again, getting terminology right is a big part of this. It's not "behind" the hands exactly as it's already kicked out a little (mostly at that point because  the hands have already slowed a little). They don't really pull up much. They just continue around their arc. The upward pulling here is small. You've seen resultant forces, but may be confusing "holding onto the grip" with how much the hands actually pull upward. To say it another way, you may be confusing the force and the counter force that stops the club from slipping out of your hands. No, because that would be a silly way to look at it given that the golfer is not only holding onto the club  but continuing to push the handle forward, too. Poorly, yes. See above.
    • I just hate when I make half swings I can’t f***** control face or path. F****** half swing back, arms down feeling and block it 30 f****** yards right with a fade.  I can’t even join my game out here at least I have nice views
    • Okay - I'm going to try this again from the top. While that may not be what I said, it is what I meant, although it appears I didn't express it very clearly. The hands apply forces and torques to the club throughout the swing. Any force applied to something like a club can be broken down into the portion of the force that is perpendicular to the shaft and the portion that is parallel to the shaft. The part that is perpendicular to it is applying a torque to the club, which will cause its rotation to change. In a similar fashion, we can look at the club as the sum of two different sets of motion. One of those is how the COM of the club is moving through space. That is affected by all the forces applied to the club, be they from the hands or gravity or the ground or the ball or the air - I think that's about it. The hands in a full swing are going to be the vast majority of those forces. Then the change in location of the COM (translational motion I think it's called) is caused by the net of all the forces applying to it. The perpendicular portion of the force is the only one that matters for rotational motion. That can be considered exclusive of the translational motion. Rotational motion will change with torques applied and can be contemplated on its own. From P6 to P7, you start with the club lagging behind the hands. The hands then pull up (among other things), which is a force applied to the club, not directly through the COM of the club. That means that a torque is being applied to the club by the hands. One which will cause the club to rotate around its COM if we are exclusively looking at the rotational motion. And so, in that sense, the club is rotating around it's COM. That's the part of the motion that I was trying to describe originally. That upward force from the hands is also going to be accelerating the COM around the swing arc due to the net effect of the forces applied to it.  Then, the combined effect of the forces and torques may be to cause the club to rotate around something else in a different reference frame. You can draw a line up the shaft of the club in each frame of video around impact and the point where those lines meet is roughly the center of rotation of the club in the static frame. That center of rotation is also moving through time as you'll see the point where the lines meet is rarely going to remain in the same spot. In any case, this is a different rotation from what I was trying to talk about previously. 
×
×
  • Create New...

Important Information

Welcome to TST! Signing up is free, and you'll see fewer ads and can talk with fellow golf enthusiasts! By using TST, you agree to our Terms of Use, our Privacy Policy, and our Guidelines.

The popup will be closed in 10 seconds...