SCOTT LYERLY

  • Home
  • About
    • Contact
    • Bio
    • My Tourette Syndrome Story
  • Books
    • The Last Line
    • Anthologies
  • Other Writing
    • Short Fiction & Essays
    • Blog
  • Upcoming Events
  • Etcetera
    • Newsletter Sign-up
    • Privacy Policy
  • Facebook
  • Instagram
  • Threads
  • TikTok
  • Bluesky
  • Review – Brooks PureFlow 2 Running Shoe

    September 5th, 2014

    pureflow2I’ve been running more lately, and it’s because of these shoes. Well, that’s not entirely true. I’ve been running more because I met for a consultation with a trainer at the gym we have at work, and in addition to strength training, she told me to get 35-45 minutes of cardio exercise in three times per week. Since I tend to agree with Denis Leary on the topic of indoor cardio machines such as stairmasters and treadmills and elipiticals (“Have we become gerbils, ladies and gentlemen?”) I decided its going to be hitting the pavement, or doing nothing at all.

    To do this, I needed new shoes. I’d been running on the old pair for about eight months. I pronate on my right foot, and after eight months in a minimalist shoe, I found that I was starting to run on the inside wall of the shoe. My feet were starting to get sore again, and I generally wasn’t enjoying my runs.

    So, time to get new shoes. And the winner was…

    …the Brook PureFlow 2 Runner. Cause they were on sale.

    I’ve been running on them for about a month. So how are they? Let’s start with fit and feel.

    To begin with, the construction of the PureFlow 2 is different from the last shoe I was running in, a Brooks PureConnect 2. The arch on the Brooks PureConnect was pronounced. In comparison, the PureFlow feels like a flatter shoe. It’s possible that the arch in the PureConnect felt more pronounced than it was simply because the rest of the sole was thinner than the PureFlow. The PureConnect was a serious minimalist. With the PureFlow, the sole is thicker and a little more padded than the PureConnect, so it might be that the arch in the PureFlow simply feels flatter.

    That said, the PureFlow is a softer shoe. It has more padding, more sole. Yet, it still loses enough sole from a traditional runner to be considered a “minimalist” shoe. After running in it for a month, I’d say yes, it can still consider itself a minimalist runner, but just barely. I’m not back to heel striking, but if there were any more padding or sole, I would be.

    The fit is looser than the PureConnect 2. Maybe the fit on the PureConnect 3 has changed, but the PureConnect 2 was snug. Not uncomfortably so, but if your toenails were a smidge too long, you felt it in the PureConnect. The PureFlow is not as snug, and as such, I find it a more comfortable shoe. I don’t feel strapped into the shoe, but it’s not so loose that my foot is sliding all over the place when I run.

    That’s the fit and feel of the shoe. Now, how do I feel after running in them?

    I feel good. I was starting to have pain again in my right plantar, which every runner knows is not a place you want to get pain. In addition, my left foot, while not (I don’t think) a plantar issue, was starting to bother me as well. It’s an early morning soreness you get when you climb out of bed and your feet hit the floor for the first time that day and you think “Oh crap, I need to walk, how is that going to happen?” Serves me right I suppose for running in a shoe a good two months past it’s prime.

    Now, my feet (either of them) aren’t sore when I finish a run, and they’re not sore the next day either when I wake up. I haven’t had to use my frozen-water-bottle-foot-massager in weeks.

    What I have noticed, though, is that my left shin gets a little sore when I first start out. It usually works itself out by the end of the first mile or two, and I wouldn’t describe it as a stabbing debilitating pain, but it’s certainly not silent. It doesn’t usually bother me after the run is finished, and it doesn’t bother me when I get up the next morning, only really when I just start off on a new run.

    But, the truth is, I don’t know if this is caused by the shoe. As part of the training program, I have to do some seated machine squats to strengthen up the muscle in the back of my legs. It’s entirely possible that the soreness I feel is a result of lingering tiredness of doing these squats the day before (my schedule is weights one day, running the next).

    To sum it up, I like the shoe and feel comfortable running in it. I’d also add that it’s a pretty comfortable shoe to walk around in (I gave it a test in New York City a few weeks ago). The same could not be said of the PureConnect. While the PureConnect 2 was a great running shoe, it was a lousy walking shoe. The arches on the PureConnect prevented it from being a comfortable shoe for walking. That’s not a problem for the PureFlow.

  • Excel Geeking – How I Control Releases of Excel Templates

    August 15th, 2014

    In my current position, I manage the care and feeding of a type of planning system. The whole thing has been built in Excel, and presents more than a few challenges. Since I didn’t do the original construction, I inherited the application, and without being able to make major back-end changes, I’ve only been able to make the types of improvements and updates that have made the users’ live easier.

    One of the pieces that makes my life more difficult is that this system is actually comprised of several different Excel files. One of them is the “Big Mutha”, the spreadsheet that tries to act like a database. It contains all the data and the templates (now) use SQL to pull data out it.

    Other of these files are reports of varying sorts that (hopefully) give the user the info they need to make decisions.

    Yet another set of files are the data entry templates. These are the Excel files in which users enter their data and submit it to my group, which we then process into the Big Mutha. These files are not so restricted that people can’t save them. They can. They can fill them out, save them to their local machine, and submit the data to us. The hiccup with these files is that we have to update them with new fiscal calendar data once per quarter (or, every three months, for those of you not in a fiscal mindset).  While I have a routine that will pull the new fiscal data into the templates when the data is ready, there are other times when we need to make an enhancement or fix a bug and then issue a new release of the template. When this happens, the template the user has saved on their machine is outdated and can’t be used again.

    So, how do I control when it’s time to issue a new release? How do I inform the user that their current template is old and can no long be submitted to us?

    “Email”, you say? Yeah. No. Nobody reads. And I’ve found this to be true in every company I’ve ever worked for. If you send an email out and assume people will read it and obey what you’re telling them, well, you know what they say about when you assume. Except you’ve only made an ass of you.

    Sneaker network? (For those who’ve never heard the term, “sneaker network” is when you get up and walk from cube to cube and update everyone you talk to.) In a land of 1500 users, that too is a no, my friend.

    So, seriously, how do you do it? How do you control releases in Excel?

    With Visual Basic for Applications, of course!

    My methodology has been to use a combination of VBA and configuration files to manage this. Let’s start with the configuration file:

    [VersionControl]
    Version=1.2
    UpdateRequired=FALSE
    

    I’ve got a section for version control. Under that section there are two keys, one for the version number, and one for whether an update to the new release is required.

    In the Excel file, I make sure that I have a public constant that holds which version of the template that file represents:

    Public Const gsVERSION As String = "1.1"
    

    Don’t forget the constants that hold the configuration file name and path:

    Public Const gsINI_PATH As String = "C:\SomeLocation\SomeLocation\SomeLocation\"
    Public Const gsINI_FILE             As String = "your_configuration_file.ini"
    

    Next, I have a function that I can call that tests whether the template is the current version and, if it’s not the current version, whether an update is required. It evaluates whether the version number in the configuration file matches the version number in the public constant. If the match, great. If they don’t, then it does a second check to see if an update is required to the newer version:

    Function bUpdateRequired() As Boolean
    '*******************************************************************************
    ' Description:  This checks if this workbook is the latest released workbook based
    '               on a setting in the configuration file and then checks if an
    '               updated version is required.
    '
    ' Author:       Scott Lyerly
    ' Contact:      scott.c.lyerly@gmail.com
    '
    ' Arguments:    None
    '
    ' Returns:      Boolean
    '
    ' Change Log:
    ' Name:                 Date:           Init:   Modification:
    '---------------------------------------------------------------------
    ' bUpdateRequired V1    04-AUG-2014     SCL     Original development
    '
    '*******************************************************************************
        ' Check the version of this workbook against the latest released version
        If CDbl(sManageSectionEntry(iniRead, "VersionControl", "Version", gsINI_PATH & gsINI_FILE)) > CDbl(gsVERSION & gsBUILD) Then
            ' If the released version is greater than this workbook's version, check if an update is required.
            bUpdateRequired = CBool(sManageSectionEntry(iniRead, "VersionControl", "UpdateRequired", gsINI_PATH & gsINI_FILE))
        Else
            bUpdateRequired = False
        End If
    End Function
    

    For this function, I’m calling my function that consolidated the reading and writing from and to a configuration file. You can read about it here.

    Now, controlling what someone can do this this file is as easy and tapping into the bUpdateRequired function. Just check to see if it’s False and then you can control the action you take next. Something like this:

    If Not bUpdateRequired Then
        Msgbox "This is not the latest version of this file. You must download an updated template.", vbExclamation
        Exit Sub
    End If
    

    That’s all there is to it. There is probably a finer point to be made about what happens when a user falls so far behind in versioning that, even though an update might not be required to the latest release, the version the user is using is no longer supported. For example, an update might not be required to go from version 3.2 to 3.3, but the user is using version 1.5. Version 1.5 might be too out of date and is no longer supported at all, but since the UpdateRequired key reads False, there’s nothing to stop them from using 1.5. Honestly, I haven’t run into that yet. If I do, I’ll figure something out. For now, what I use above is more than enough for me to control versions.

  • Pardon Our Progress

    August 1st, 2014

    20140801-205018-75018576.jpg
    There is nothing wrong with your television set. Do not attempt to adjust the picture. We are controlling transmission.

    This is a quick one tonight. You may or may not have visited the blog today, but if you did you’ll notice it’s looking a little different. I’m trying out a new theme, one I particularly like (as opposed to using you I despise, I suppose). I’ll probably be playing around with it a little more here and there, adding widgets, deleting widget, botching the color scheme, that kind of thing. So if it keeps changing on you, don’t worry, it’s me not you.

    I’m also trying out featured images for the first time, so if it looks like an amateur is running this site, well I guess that’s a true enough statement. Not to worry though, I’m likely to have worked through all the bugs in one, maybe two years, tops.

    If you like the new look (or loathe it), pipe up. I’m always interested to hear some feedback. Just leave a comment below.

  • The Maffetone Method: A Hiatus

    July 31st, 2014

    After a few rocky months of being unmotivated and discouraged by my running results, I’ve decided that I need to take a bit of a break from trying to apply the Maffetone Method to my running. It’s not that I’ve stopped running–oh, wait, yeah it is.

    My running has fallen by the wayside the last few months. If I get out there more than once every two weeks, that’s a lot. I’m finding that, these days, I haven’t the enough time to keep it going.  I’m trying to get a major release done for the system I administer at work. I’m trying to get editing done on a hard-boiled crime novel I’ve written. I’m trying to clean up the house and clean out my garage. (I’m also hopeless hooked on Battlestar Galactica, which I missed when it originally aired on SyFy.)

    Time, or the lack thereof, is only a part of it. Another factor is that my foot hurts again. I imagine that it’s time to replace my shoes, which did a nice job mitigating the problems I was having with my plantar at the time. At this point, the pain has returned. It’s not as sharp or acute as it was in December, but it’s there, especially in the morning. I’m worried I may have done something serious to it since it’s sore in the morning after doing nothing but walking at lunch time.

    But what might be the most difficult thing to overcome at this point is the lack of motivation. I’m just not interested enough in running anymore to push myself to do it. It used to be something I enjoyed, but I’ve found that I just haven’t enjoyed it in recent months. I suppose this is the biggest reason why I’m not running these days. If I truly enjoyed it, I’d make time for it. I don’t, so I don’t. But the big question is why.

    Why don’t I enjoy running anymore? Interestingly enough, Maffetone might be the answer. Or perhaps, better stated, my implementation of Maffetone might be the answer.

    When I set out on a quest to document my progress with the Maffetone Method, it was to avoid some of the pain I was starting to feel, and to see if I could bring my times down. You can read the full account of why I started here. In the months that followed, I tried to apply the concept of running slowly in order to improve my times. Running slow is incredibly hard to do. You’d think you could just lope along and not worry about the speed. But when you’ve been running for a while and you’ve been trying to run faster and faster each time, running slowly is an unbelievably hard adjustment to make. No, really. It unbelievable. Until you try it, you’ll never believe that running slow can take so much effort.

    In making this adjustment, I did see some results. But I never really applied the method properly. I always found that most of my runs ended up being faster than they should have been, in that my heart rate was higher than it should have been. I was running based on average heart rate, but the average was always brought down by my heart rate in the first mile. That first mile was always great, and my heart rate for the subsequent miles was up there. It averaged out to a state of “okay”, but the averages were still above the MAF line.

    Another big thing I’ve been managing poorly is my diet. I have a sweet tooth. Like, huge. It’s not below me to take two year old frozen Girl Scout cookies from the freezer and finish the box in one sitting, freezer burn and all. Guess what doesn’t work well when your eating like crap. Ding ding ding! The Maffetone Method. (Actually, to be honest, any method will work like shit if you eat like I have.)

    I think the final thing, though, the final reason I’m putting this one on the shelf is because I don’t race. I’ve run two races, and while I enjoyed them, I’m not the kind of guy who wants to get out there and race every weekend. When I realized this, and put it together with my waning interest in running, I realized that there is no reason for me to apply the Maffetone Method. I’m not trying to improve my race times cause I don’t race. And I haven’t been enjoying running because I don’t want to run slow all the time. Sometimes I want to just run, not run and have to constantly check my heart rate monitor. I feel like I’ve been held hostage by my heart rate monitor, and I haven’t enjoyed it.

    So, with all of this in mind, I feel like it’s a good time to pause this experiment. Not shut it down and say “never again”. Because who knows? Maybe in a few years I’ll be ready to get back into it. But for now, I’ve lost interest in running. It’s time to move on and find something else that I actually do enjoy in order to get into shape.

  • “Inventory” Flash Fiction Challenge

    July 15th, 2014

    Chuck Wendig over at Terrible Minds has a new flash fiction challenge up. You can read about it here. Without re-hasing his whole post, the basic gist is to ping a Twitter account called @YouAreCarrying with the word “inventory”. @YouAreCarrying will then ping you back with a list of items “you are carrying”. (Get it?) The challenge by Wendig is to using everyone of those items in a flash fiction piece of 2000 words or less.

    I couldn’t resist this one.

    Here’s my list:

     

    @scottclyerly a bike, a battered lantern, a sheet of paper, a bottle of cheap scotch, a key, a shovel, a large key, a magic boat.

    — YOU ARE CARRYING: (@YouAreCarrying) July 12, 2014

     

    And here’s the fiction.


     

    Escape

    He pedaled faster. The old Schwinn creaked under the strain. The tires wobbled with each rock in the road. On the handlebars, the old battered lamp rattled, throwing out a weak light. In his haste to escape, he’d dropped his flashlight. He’d grabbed the lantern from the hook in the shed where he’d stolen the bike. He’d hoped it would replace the flashlight, but it threw only a foot’s worth of light. Not enough to help avoid rocks.

    His heart was pounding in his ears. He thought it might pop. That, he thought cynically, that would solve his problems. He gasped for breath. His legs burned as if his veins pumped gasoline. But he didn’t stop pedaling. Couldn’t stop. If he stopped they might catch him. If they caught him, they’d kill him.

    When he reached the turn-off, he squeezed the handbrakes. The bike slowed and he allowed his feet off the pedals and onto the ground. It was a mistake. His legs threatened full rebellion. They might never pedal again. That which would be bad. But he had to stop to make sure it was the right turn-off. If not, he’d be lost in the backroads of the bayou forever. Or at least until he died.

    He pulled his backpack off and dug into it. He rummaged until he pulled out the scrap of paper, folded and tattered. Torn from the Ringmaster’s Book, he opened it. In the weak light of the lantern he read the clues, looked again at the hand drawn map. He thought is was right, yes, but he had to be sure. He reached into the bag and drew out a object wrapped in a scarf. As he brought it close to the map, the object in the scarf began to glow. So did the map. Icons on the map that had been hidden were now visible, glowing in the dark of the bayou night. Yes, this was the turn.

    His legs were rubbery. He needed a slug to re-energize. He took the bottle of crappy scotch from the bag. He took a swallow of the brown liquid. It burned his belly like his blood burned his legs. But it helped. He took another. It gave him a sense of hope, of purpose. It reminded him of the girl, her beautiful naked body, and her bed where he’d left her a few hours earlier. One more slug and he was done. Paper, scarf, and bottle back in the bag, bag slung on his back, he willed his legs into motion. His muscles screamed as he started pedaling down the dirt road.

    He pedaled another thirty minutes before stopping. He knew he needed to bury the key before his final escape. This dirt road was only one of many ways in, but he couldn’t make the full trip. He’d need to come back and use the key to unlock the door in the world. Once open, he could step through. But not tonight. That is what they’d expect, and he knew they’d be waiting for him on the other side. No, he couldn’t make that journey tonight.

    The plan was to trick them. Make them think he was going somewhere else, escaping with the key, to enter through the door in the world somewhere else. But in fact, he wouldn’t have the key. He’d leave it here, buried, to be retrieved later.

    He looked around. The trees had grown close in this part of the road, the underbrush to each side thick and difficult. This seemed as good a place as any. The smell of water had grown stronger. He’d be at the edge soon. If he buried it at the edge, they could find it. He couldn’t let that happen. Even though he knew the key would be useless without the Book, without the page he’d torn from the Book, he didn’t want to risk them having any of the pieces.

    He climbed off the bike. He listened for the sounds of pursuit but everything behind him was quiet. The sounds of frogs and crickets and the buzz of mosquitoes were all he heard. No engines, no voices shouting in anger to each other trying to get a fix in his location.

    He took the backpack off and placed it in the ground, unzipped it, and started pulling items out. He took the box the girl had given him. “It’s made of ironwood,” she’d said. “It will mostly mask the key’s power from those seeking it.” He took the object wrapped in the scarf. She had given him the scarf, once beautifully colored but now faded by sun and sweat and stained brown by what he hoped wasn’t blood. “Wrap the key in this first, cover it completely, then lock it in the box and bury it. That will fully mask the key’s power.”

    He unwrapped the scarf slowly. With each layer of fabric removed, he felt the power of the object grow. When the last fold fell away, there was the key, large and ornate and beautiful. It stretched across his palm, out past his fingers. His hand tingled as he held it, almost like the key was humming with current. He stared at it, felt like it was pulling him in, like he could sit there by the side of the dirt road and hold the key forever. His mind flipped through the last few weeks like a movie reel. The shows, the Ringmaster with his waxed handlebar mustache and gleaming smile, the Strongman swinging the sledgehammer, the Bearded Lady and her sly smile, Gypsy the Fortune Teller and her crystal ball, her trance, her prophecies, the girl, her love, and all of the darkness, the body, the blood–

    He took a huge breath and found he was panting. The key had nearly sucked him in. How long had he been sitting here? The sky was less dark. Morning was coming.

    Panicking, he wrapped the large key back in the cloth. He took a smaller key from his pocket and unlocked the ironwood box. He placed the wrapped key inside, closed the lid, locked the box, and put the key in his pocket. From the bag he took a short hand shovel. He listened to the woods around him. Still no sounds of pursuit. But being lost in the visions of the key he had lost at least an hour. Sometimes it’s better to be lucky than good.

    He walked a ways off the dirt road, into the woods. He found a hollow at the base of a large tree. He dug in the soft earth until he had a hole two feet deep. Before he placed the box in the ground, he opened the box again with the small key. He took the torn page from his pocket and held it to the scarf in the box. He heard a hissing noise and smelled the smell of burning paper. He quickly shoved the paper back in his pocket and closed and locked the box. He placed the box in the hole and then replaced the dirt. When he’d filled the hole, he brushed leaf litter from the ground over the place where the key was buried. He stood and looked at it. It looked pretty good to him. It would have to do.

    He returned to the bike. He put everything back in the backpack. He was almost done. He took out the torn page from his pocket and unfolded it. It had been changed, with the key’s location burnt into the map, but he couldn’t see it. He wouldn’t be able to see it with magic. Which was fine by him.

    His legs were so sore he wasn’t sure he could pedal anymore. He thought about leaving the bike and trying to walk, but his legs didn’t like that idea either. He took the bottle of Scotch and took another swallow. Then heard the engine.

    Coming down the dirt road was a vehicle. It was probably a truck. The pitted potholed road would be too rough for cars. It had to be them.

    His legs suddenly decided to work. He slung the bag and jump on the bike and started to pedal. He pedaled as if his life depended on it, which he knew it did. He could smell the brackish smell of the bayou as it grew closer. Behind him the engine gained.

    When he reached the water’s edge he knew he had only seconds left. He grabbed the lantern as he jumped from the bike, letting it clatter to the ground as he ran. He swung the backpack from his back and placed the lantern on the ground at the bayou’s edge. He dug into the bag looking for his escape. He couldn’t find it. The engine drew nearer, and now he could start to hear voices calling. It was the big truck. It would drive over anything.

    He was near hysteria when his hands finally touched on it. He grasped it gently and pulled it from the bag, his breath short. The light from the truck’s headlights was visible, coming around the bend in the road.

    He opened his hand. In it was the boat. Miniature in size, a perfect replica of a larger skiff. “Take this,” Gypsy had said. “When you get to the water, place this in the water. It will save you.” He’d looked at her like she was crazy and had asked how it would save him. “It’s magic,” she’d whispered. He wasn’t sure he believed her then, but now it was his only hope. He placed it in the water.

    “There he is,” he heard someone shout. The truck stopped. He heard boots as they hit the ground and started to run. He looked over his shoulder. Silhouetted in the truck’s headlights were people running towards him.

    He looked back at the water, only to see a life sized version of the tiny boat floating there. “It’s magic,” Gypsy had said. She had been right.

    Without thinking he leapt from the bank of the bayou, landing in the boat. As soon as he was aboard, the boat started to move on it’s own away from the bank. By the time the men reached the place where he’d leapt, the boat was nearly lost to them in the gloomy watery mist of daybreak.

    The Ringmaster stepped to the edge of the bank and watched the boat drift further away. He watched until it disappeared, then stroked one side of his handlebar mustache, soothing his rage.

  • How Was Your Weekend?

    July 14th, 2014

    I’m just getting back into the swing of things after being on vacation. One if the things I did on my vacation was to trek up to the LL Bean store in Freeport, ME and trade in my 14 year old boots. They no longer carry my size in the store (size 14 boot), so they gave me a credit which I used toward a new pair of boots.

    20140714-081306-29586239.jpg

    Yesterday was the test run (or rather, test hike) of the boots.

    While I was out there, I thought I’d take some pics of the trails and areas of Mt Wachusett, which is where I do most of my hiking. Hope you enjoy them.

    20140713-210227-75747522.jpg

    20140713-210229-75749177.jpg

    The windmills on Wachusett never fail to impress me.

    20140713-210240-75760005.jpg

    Clearly no one has been cleaning the Jack Frost trail in a while…

    20140713-210241-75761793.jpg

    20140713-210313-75793285.jpg

    20140713-210315-75795421.jpg

    20140713-210407-75847016.jpg

    20140713-210408-75848565.jpg

    20140713-210421-75861164.jpg

    One of the cooler things was that I found the stick on the trail, partailly worn, propped up against a tree. I took it and used it as a walking stick for the rest of the hike. Then I left it at the entrance to the Mountain House Trail for the next hiker to use.
    20140713-210422-75862791.jpg

     

  • Special Offer for “How It Ends”

    June 29th, 2014

    I’m off for a little bit of R&R with the fam, so you won’t see any new posts for a bit.

    But, in the meantime, to help you fill your summer reading gaps, I’ve got How It Ends on special this week. You can pick it up for $1.99 this week, which is 50% off the regular price. Pick it up today and enjoy!

    20140629-114004-42004110.jpg

  • Excel Geeking: Using VBA And ADO To Change Data to SharePoint Lists

    June 26th, 2014

    I don’t get a ton of hits on this blog. But for the hits I do get, most them are focused on the Excel stuff. And of the Excel stuff, one of the most popular is Using VBA and ADO To Pull Data From SharePoint Lists. Because of this, I felt the need for a follow-up post, a sequel as it were. In the first post, I laid out the basic code to pull data from SharePoint using VBA. Could I do the same this to push data to SharePoint?

    The short answer is no.

    This proved to be an interesting topic to research. There actually isn’t a lot of material written on how to use SQL, ADO, and VBA to change data in a SharePoint list. Plenty of posts on pulling data, it’s a pretty basic SELECT statement. Fair less on things like INSERT, UPDATE, and DELETE.

    I started off taking the VBA from the previous post and modifying it so that it would become one of the other three. As a matter of public disclosure, I should note that I only tried this with INSERT and DELETE. I didn’t try it with UPDATE, largely because I’ve never been a big fan of UDPATE. I find it less troublesome to use DELETE/INSERT with databases, with the DELETE containing criteria managed by a WHERE clause, than I do trying to find the right keys to isolate the correct record and then fire off an UPDATE query. This probably makes me a lazy coder, but given that I’m not a DBA, when it comes to databases I’m usually flying by the seat of my pants and using Google as my flight instruction manual.

    Okay, so here is the code I tried:

     

    
    Public Const sDEMAND_ROLE_GUID As String = "InsertYourGuidHere"
    
    Public Const sSHAREPOINT_SITE As String = "https://yoursharepointsite.sharepoint.com/agsinwhateveryoursiteis/"
    
    
    Sub TestDeleteFromSharepoint()
    
    
    Dim cn As ADODB.Connection
    
    Dim sConn As String
    
    Dim sSQL As String
    
    
    sConn = "Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=1;RetrieveIds=Yes;" & _
    
    " DATABASE=" & sSHAREPOINT_SITE & ";" & _
    
    "LIST=" & sDEMAND_ROLE_GUID & " ;"
    
    
    Set cn = New ADODB.Connection
    
    
    sSQL = "DELETE * FROM [Demand Role] as tbl WHERE tbl.[Role]='BA';"
    
     
    
    With cn
    
    .ConnectionString = sConn
    
    .Open
    
    .Execute sSQL, , adCmdText
    
    .Close
    
    End With
    
    Set cn = Nothing
    
    End Sub
    
    

    And the result:

    could not delete

    What about INSERT INTO?

    Sub TestInsetIntoSharepoint()
    
     
    
    Dim cn As ADODB.Connection
    
    Dim sConn As String
    
    Dim sSQL As String
    
    
    sConn = "Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=1;RetrieveIds=Yes;" & _
    
    " DATABASE=" & sSHAREPOINT_SITE & ";" & _
    
    "LIST=" & sDEMAND_ROLE_GUID & " ;"
    
    Set cn = New ADODB.Connection
    
    
    sSQL = "INSERT INTO [Demand Role] ([Role]) VALUES ('BA');"
    
    
    With cn
    
    .ConnectionString = sConn
    
    .Open
    
    .Execute sSQL, , adCmdText
    
    .Close
    
    End With
    
    Set cn = Nothing
    
    End Sub
    
     
    

    And the result:

    opertation must be

    Based on the results above, you would think the long answer to this is idea of changing SharePoint data using VBA would be a flat no as well, right? Well, it’s kind of no. But kind of yes.

    Here’s the thing with SharePoint lists: you link them to Access as tables. It’s incredibly simple to do. In Access, you go to External Data, use the drop down to choose SharePoint Lists, plug in your SharePoint site and click Next. Access will go out to SharePoint, get the available lists, and present them to you in a dialog box where you can choose whichever table you want. Once you choose the table and finish out the connection, you have a linked table in Access from SharePoint in which you can update data.

    I’ll say that again. You can update your data in Access, and it updates in the SharePoint list.

    Which makes the long answer less yes and no and more “kinda”. Because, while you can’t update the SharePoint list in SharePoint directly with VBA, you can certainly update the linked table in Access using VBA. But this begs the question: why? Why would you have your data resident in a SharePoint list and linked into an Access database? Why not just have it in Access? This is a question I can’t answer, maybe somebody out there wiser than I can. But for now, without going into all the nitty-gritty details about how to do it, this is the setup you need to have in order to update a SharePoint list using Excel VBA and ADO.

     

  • The Maffetone Method – Month 8

    June 7th, 2014

    May sucked.

    Okay, now that we have that out of the way let’s take a look at the artwork:

    maffetone_pace_month8

    maffetone_avg_month8

    As you can see, my average pace climbed way back up from where it was in April. There’s a pretty simple explanation for that: I had a lousy time running.

    If you read Phil Maffetone’s “The Big Book of Endurance Training and Racing“, then you know that proper endurance training is comprised of three different pieces: the structural (training) part, the chemical (eating) part, and the mental part. My biggest problem wasn’t the structural part, although that wasn’t stellar. I only went on seven runs in a 31 day month. My total mileage for the month was all of 26 miles. Structurally, this wasn’t very sound.

    Pace was way up whenever I went out for a run. And by up I mean down. Or however you might say it. You know what I mean. The pace that I set in April as an average was lower than the piece that I sent May. I don’t know if that’s supposed to be up or down but you get the drift. A large contributor to this slower pace was the chemical part. I ate like crap last month. I ate whatever I wanted whenever I wanted. Our admin assistant at work has giant bags of candy lying around. Anybody’s welcome to them. Oh, and I did help myself. My weight was up 5 pounds, my sleep was way way off, and I generally felt like crap.

    But while chemical was certainly part of the problem, it was what drove the chemical that was the real problem. Maffetone explains that the triangle that makes up endurance training is comprised of these three things equally. And under the mental side of the triangle exists stress. How stressed you are and how well you manage it is a huge contributor to whether your training well. I cannot tell a lie, work has been very stressful recently. Lot of changes, lot of things up in the air, ergo a lot of stress. With the stress, which has led to lousy nights’ sleep, and with the mental side of that triangle being so weak recently, I just haven’t had the interest in running.

    I knew I was having trouble with running recently. I mentioned it previously here, as well as what I was most concerned about: loss of conditioning. I think, in reviewing May’s numbers, and in seeing how June has started out, a loss of conditioning has definitely happened. But the truth is, I just haven’t had the drive, the desire to go out and run. The alarm clock goes off and I think “Sleep. Sleep is way better than running right now.” And with that, I slap the snooze button and roll over. What’s interesting is I’m not the only one. I good friend of mine who is also a runner, a really serious runner, said to me just yesterday “I’ve lost interest.” He’s still running, but he’s got to push himself to do it.

    So what to do and where to go with this? In my mind, there’s nowhere to go and nothing to do but to keep pushing forward. I view this training program of Phil Maffetone’s as a grand experiment, a chance to see if, by applying his principles, I can make myself go faster and faster still while avoiding injury and keeping my stamina up and my heart rate down. Can I become a competitive runner? So onward I go. The Maffetone Method is not a quick method. It’s not a two month training program that gets you to the result you want. It’s not Couch to 5K app on your iPhone that gets you to run a 5K in eight weeks. It’s a serious training program that can take a few years for the results to be truly remarkable. And you have to apply all the principles, not just the ones you want. So in addition to actually running, I have to eat better and learn how to manage stressful situations better. The eating better has already started, and since the beginning of this past week, I’ve lost the extra five pounds I’d gained, plus one more for good measure. I’m trying to learn to manage the stress side of things, and trying to keep my head in the game, even when I have to talk myself into strapping on the shoes and getting out the door.

    So what to do? Keep running.

  • Review: “Godzilla”

    June 2nd, 2014

    godzilla-poster

    I’ll summarize this movie by saying it was good, but not great. That said, let’s jump into it.

    Note: There’ll probably be spoilers below. I’ll try not to give away too much, but they’re there.

    The premise of “Godzilla” is that a pair of MUTOs (Massive Unidentified Terrestrial Objects) have once again resurfaced after causing quite a problem fifteen years earlier. They threaten the world in a number of ways and it looks like nothing might be able to stop them. Until “he” comes along.

    Yes, “he” is the titular monster of our movie, the big G himself: a relic of a time even before the dinosaurs, when creatures of ridiculous proportions walked the earth, feeding off of its highly lethal radioactive atmosphere. How, then, could such monsters continue to exist when the earth has cooled and millions if not billions of years have passed? By embedding themselves at the bottom of the oceans where even the technologic eye of mankind cannot see, and where they last in some type of unexplained form of hibernation, taking sustenance from the radioactive energy produced by the earth’s core.

    When two of these atom-loving MUTOs break to the surface of the earth as it currently is, and of course cannot be killed by nukes as they feast greedily on the nuclear energy, then the balance nature’s power is thrown off kilter. It is at this point of fawning revelation that the Scientist (Watanabe) delivers a predictable and cliched set of lines to the stern Admiral (Strathairn) about humanity’s arrogance toward nature and concludes it with “Let them fight.”, setting up the battle du jour. Our titular hero then takes matters into his own hands by rising to the surface of the ocean to do epic, skyscraper-crushing, San Francisco ravaging battle with our “villians”.

    When you go to see a monster movie, you expect to see monsters. And you do in this film, pretty early on. The movie isn’t trying to trick you or tease you about the monsters themselves. There is some teasing in the beginning of the film, but before you’re even halfway through, the monsters have presented themselves and the mayhem has started. However, if you want to see a good monster fight, then you will sit through a hour and forty-five minutes of a two hour movie. The fight (we can see) is only at the tale (get it?) end of the movie. This makes a certain cinematic sense given that, if it happened in the beginning, the movie would last twenty minutes.

    And what a fight. Godzilla versus two MUTOs was a great battle, especially when the notorious B-I-G-odzilla breaks out his signature move. Really, all of the action sequences involving the monsters are stellar. It’s the rest of the movie was a let down

    The characters drawn on the screen were as two-dimensional  as if they were literally drawn on the screen. Each of the actors looks as if they were given a five word sentence about their character and told to make the best of it: grieving scientist turned conspiracy nut (Bryan Crantson); stoic family man and solider (Aaron Taylor-Johnson); panicked triage nurse and mother (Elizabeth Olsen); stern-faced admiral with a plan (David Strathairn); concerned scientist with a permanent frown (Ken Watanabe). I have to assign the blame to for these characters on the screenwriters, who simply didn’t spend any time developing them. And where they did, the character continuity was list to serve the greater plot. I swore I could hear a snarky version Taylor-Johnson’s internal monologue in my head in certain scenes, with things possibly like “Sure, dad, I’ll follow you into a quarantined area and risk getting arrested like you did earlier and put my entire US military career in jeopardy. Not out of character at all.”

    To an extent, the people in a monster movie of this size are typically incidental, which is always a shame. And it surprised me quite a bit, given Gareth Edwards debut was a movie called “Monsters”, a deeply human movie with all of the focus on the humans and very little on the monsters themselves. I felt that “Monsters” was the best monster movie since “Jaws”. But “Monsters” and “Jaws” focus on the human relationships, with the monsters themselves bordering on macguffin. In a summer blockbuster monster movie, your monsters,unfortunately, can’t be simply a motivating factor. They must be the stars.

    And Godzilla very much is the star of this show. When he’s on the screen, he is absolutely front and center, and for a CGI character, has a surprising amount of charisma. His foes, while they don’t have as much charisma, do have one scene that shows more heart than than what was written for much of the rest of the cast. But unlike, say, a “Transformers” movie, “Godzilla” is the result of a monster movie taking itself too seriously. It has no humor. While Gareth Edwards does human relationships better than a big Michael Bay brainsucker, a Michael Bay movie will always have some humor, almost in a teasing way that acknowledges the crazy-bigness of the movie without dropping you out of the story. There was nothing humorous in “Godzilla”, nothing to balance out the “end of the world as we know it” tension of the movie.

    So, to sum up, I’ll simply restate how a friend of mine described it: “That was silly. But fun.” That’s about right. Good, but not great.

←Previous Page
1 … 28 29 30 31 32 … 41
Next Page→

Create a website or blog at WordPress.com

 

Loading Comments...
 

    • Subscribe Subscribed
      • Scott Lyerly
      • Join 200 other subscribers
      • Already have a WordPress.com account? Log in now.
      • Scott Lyerly
      • Subscribe Subscribed
      • Sign up
      • Log in
      • Report this content
      • View site in Reader
      • Manage subscriptions
      • Collapse this bar