Second topic was possibly about Leadership. It’s just crazy and I like to talk about Home Field Advantage a lot because even though it should be an advantage, it’s also a disadvantage at the same time. They have a monopoly on cars on the sale of new cars, but they have yet to find a way to retain their customers. First one I was thinking about was Home Field Advantage.ĭealerships have Home Field Advantage, however, they lose 80% of their customers to aftermarket independents. However, let’s go through what I would speak about if I was going to speak. Please tell us what you want to talk about and give us three options. The letter relays this message of, “On behalf of NADA Show, it’s a great pleasure to reach out to you and I’m extending a formal invitation for you to speak at our show in Vegas. This is the first time I’ve ever been asked to speak at NADA Show because the other times that I did, I had to submit an application that goes in front of a jury where they choose who they want to speak at their event.īut I would like to discuss what this letter says. There were some, don’t get me wrong, but we could get to those decision makers on a Facebook Ad and be more successful that way. The bulk of it is that there aren’t a lot of decision-makers inside the Automotive Industry present. Moreover, it was vendor on vendor crime because it’s just other vendors pitching to other vendors. Basically the last couple of times I attended NADA Show, the best way to describe it was not that you got a lot of business out of it. I spent close to $100,000 on a booth, getting all the people there and talking to those who were interested in me. When you participate in their convention, you have to go through the unions. Last time I did workshops there and I attended three of the four days that I did it, they were the worst, the rooms weren’t set up, and I didn’t hear a single ‘thank you’ while I was there! They told me not to talk about Tesla and other things that I had on my mind. They have this annual NADA Show that I’ve talked about on the show and about what a nightmare it is. I got an interesting letter in the mail, a letter from NADA and for those of you who don’t know, NADA is the National Auto Dealers Association. $WorkSheet = $’ll be covering why I won’t be at the NADA Show this year! NADA Show is extremely popular and special, but with certain guidelines on what I can talk about, it makes me feel a bit quiet. `# Open the Excel file and save it in $WorkBook `# Disable the 'visible' property so the document won't open in excel $objExcel = New-Object -ComObject Excel.Application `# Create an Object Excel.Application using Com interface `# Specify the path to the Excel file and the WorkSheet Name So this didnt work, next i looked into opening the spreadsheet (with PS) then selecting columns and putting them into variables (the user specified $blah entries?) this quickly got way beyond my poor PS skills, but this is as far as i got. $DEPT = Import-Csv 'T:\RDP Logons\UsersAndDept.csv' $RDP = Import-Csv 'T:\RDP Logons\RDPLogons.csv' Im new to powershell (like three weeks ago, started using it) so be gentle :)
Ive tried much google'ing but have failed dismally, any help, even pointing me at another reasource, would be greatly appreciated.ĮDIT: Sorry for not saying what i'd tried before, nothing has given me any sort of usable output. So I need something (powershell or maybe excel?) to read column one on the RDP spreadsheet (the username) then compare it to column one on the departments spreadsheet (the username again), if it matches then output to another spreadsheet the department (column two on the department spreadsheet) from which the user is from. I've been asked to gather how many logins per department rather than how many times a particular user has logged on.
Compareme spreadsheet series#
I have a series of spreadsheets with Remote Desktop login information (Username and time of login, separate columns) and another spreadsheet with everyone's username and which department they work in (separate columns again).
0 kommentar(er)
