Robotics is the branch of technology that deals with the design, construction, operation, and application of automated machines known as robots. It also involves the computers systems for their control, sensory feedback, and information processing.

Share tech news, updates, or what's on your mind.

Sign up to Post

Hello experts,

I have the following flat file attached (Input Sheet).
I am trying to build a vba procedure that covers the following requirements:
1-Check if Output sheet if so delete and create a new blank
2-Transfer the various unique values in column H, J and AI
3-Consolidate the sum values for the various month from AJ to BV split by column AI

I attached dummy file with expected Output sheet.

I think that we can proceed steps by steps, such as copy unique values related to H & J.
For this we can use the following procedure:

Sub CopyRangeUniqueValues(FromWSheet As String, FromRange As String, ToWSheet As String, ToRange As String)
'Sub treats first cell in FromRange as a header label, and will copy it to ToRange even if it is duplicated in the list
Dim celHome As Range, rgDest As Range, rgSource As Range
Dim n As Long
Set celHome = ActiveCell
Set rgDest = Worksheets(ToWSheet).Range(ToRange)
Range(rgDest, rgDest.End(xlDown)).ClearContents

With Worksheets(FromWSheet)
    n = .UsedRange.Row + .UsedRange.Rows.Count - 1
    Set rgSource = .Range(FromRange & n)
End With

rgSource.AdvancedFilter Action:=xlFilterCopy, CopyToRange:=rgDest, Unique:=True
Application.GoTo celHome

Open in new window

Concerning the consolidated sum we can also go ahead with a formula reported in macro:

Sub LoopFormula2(strwsName, strColflag, strCol As String, strColName As String, formula As String)

'Call LoopFormula2("ImportCC", "1", "D", "Test", "=clean(sheet1!G2*sheet1!I2)") 'example of formula
    Dim ws As Worksheet
    Set ws = Worksheets(strwsName)
     '==>Clear Destination Column
    Range(strCol & ":" & strCol).Clear
    UsedRows = ActiveSheet.UsedRange.Rows.count + ActiveSheet.UsedRange.Rows(1).Row - 1
    If strColflag = 1 Then
        Range(strCol & 1).Value = strColName
    End If
    '==>Clear Destination Column
    RightFormula = Replace(formula, "1048576", UsedRows)
    Range(Cells(2, strCol), Cells(UsedRows, strCol)).formula = RightFormula
    Range(Cells(2, strCol), Cells(UsedRows, strCol)).Value = Range(Cells(2, strCol), Cells(UsedRows, strCol)).Value
End Sub

Open in new window

Thank you in advance for your help.
PMI ACP® Project Management
LVL 12
PMI ACP® Project Management

Prepare for the PMI Agile Certified Practitioner (PMI-ACP)® exam, which formally recognizes your knowledge of agile principles and your skill with agile techniques.

An MIT student is creating a 3d printed wearable device that can listen to your volitional thoughts and give you feedback through bone conduction:

Can't wait till they have the "home" version of this so I can read my wife's thoughts. Jk.

Expert Comment

by:Craig Kehler
That is really cool. This has applications for those with physical disabilities as well.

I may be a little weary of a machine, especially one that may be collecting my data, to be recording everything I think aloud. :)
LVL 20

Author Comment

by:Lucas Bishop
Yeah Craig, the ability for a device like this to aid people with disabilities is really one of the best applications I could imagine. At the same time, you could swing the complete opposite direction and end up with Skynet.
My Python chess project new approach is tripping up.
I think it might be to do with Thread entanglement.
My engine instantiates a white and a black player, which are each abc's for their AI, random movers for now.

Then I start a game_loop() to handle the game play.

Does Thread "entanglement" ever happen? I cant see any reason for my Threads to unravel
I suspect this, because I have a thread counting the seconds going by on the console
( will help with clock)
But, when I instantiate my board window, the board window appears, but the counting thread disappears. (take away the # comment in to reinstate the board creation
Have they become entangled?

My has the call to init the board commented out, so you can see the seconds being counted out.
as soon as the # is taken away and the board instantiates, the first Thread ceases to count.
It only counts the seconds when there is no board

Are Python Threads delicate and tough to combine?
Something in the board class is locking it all up
Code attached
What could it be?


Backup job Error code E00084C7 and E00084C8.

Client has HP MSL2024

Library partition left one tape until 26 Jun can be overwritten.

Any suggestions on how I can do further checking to analyze the issue?
Chatbot for elearning
ardunio on board memory manipulation have a arduino mega now what is the best way to do the following, i want to have the program running and then update the array on board the arduino with out reloading the program, so lest say i have an array with 10 numbers and depending on the feed back from the card i am going to change location #4 of the in the 10 mem locations that i have set up how is the best way to do this please from the code running on the pc , would i access the arduino then the mem location and go from there, any ideas in this correct direction would be helpful
Google’s “duplex” AI system for voice recognition and natural language responses is pretty amazing. The phone call snippets here don’t even sound like you’re talking to a bot:

What is the component/application for Oracle to do big data analysis?

What is the Oracle product for AI and data scientist research ?

when I look at this:

it said:

Additional libraries and tools include: Jupyter, pandas, scikit-learn, Pillow, OpenCV, and NumPy.
Deep learning frameworks include: TensorFlow, Keras and Caffe.
Elastic AI and Machine Learning Infrastructures include NVIDIA, Flash Storage, and Ethernet.

Open in new window


which component is free and no issue with Oracle DB. ?
Gartner predicts that by 2020, the average person will have more conversations with bots than with their spouse:

Hopefully this is more due to AI being used in common interfaces, and not because we start migrating towards making "friends" with our mobile devices.
I want to buy a speaker to connect it to the Arduino and play some music. I've done some research and noticed that all speakers operate at least 2 W.

The Arduino offers a 5V voltage differential and 0.25 milliAmperes so machines work between 1,5*10^-4 W.

Which speakers do I have to use?
Exploring SharePoint 2016
LVL 12
Exploring SharePoint 2016

Explore SharePoint 2016, the web-based, collaborative platform that integrates with Microsoft Office to provide intranets, secure document management, and collaboration so you can develop your online and offline capabilities.

I have connected 2 cables (->one from port 9 to vid cable with a 1000 Ω resistor between and second for port 7 to vid cable with a 400 Ω resistor between) and the ground pin with my rca connector's ground and I have connected my vid cable to my rca connector.

Here's the code:
#include <TVout.h>

TVout TV;

void setup() {
  // put your setup code here, to run once:


void loop() {
  // put your main code here, to run repeatedly:

TV.print_str(30,30,"Hello world");


Open in new window

my screen doesn't show the message "Hello World". Am I missing something?
Well my dad has recently bought our Arduino. Yesterday I was exploring the environment I found how to save , open and open the serial monitor.

My problem is that every time I try to upload a project, an exception occurs "programmer didn't respond the command"
I've tried this for about 100-150 times but it doesn't get any better. What should I do?
Bots will shape on-demand services of tomorrow

AI chatbots for small and mid-size enterprises that require a team of 4–6 team members. Projects like that take at least 2–3 months to implement and a chatbot always just a part of a bigger system, with custom dashboards, webviews, etc. 
windows 10 laptop
I have a quick wifi connection. I do not want to plug into the router.

Sometimes google hangouts / google voice has low call quality.
instead of hearing a word. I can not understand one word in every sentence because there is a robot noise

I looked up downloading hangouts for windows 10 but can not find

Is there any way to increase call quality or is that server side (google)?
AI and machine learning humanize app development and marketing

Machine learning is being used as a marketing tool as it can access user data and gather additional insights on the users’ behavior and engagement preferences.
While artificial intelligence (AI) has been around for a while, scientists have recently made massive breakthroughs in the field of machine learning, a subfield of AI, as noted by NPR.

I finished our colossal collaboration of a network game with a central server, a while ago. I will convert it to python now that I'm shifting to it as well. Is that unadvisable - python might not be optimal for a game server?

I know that MIT had an RTS AI coding contest, before.
There's also ORTS, open rts
There seem to be many similar links on Google.
The MIT contest was geared to a confusing, un-watchable mess of a game, in my opinion.

Do these types of contests have any traction? now? Any of them non-college?
I have many ideas, some non 3D war.
I'm interested in using Visual Studio in the field of BIG data and artificial intelligence.

At the moment the latest version of Visual Studio is 2017.
When is the next version due out?
What spec machine is needed for it to run smoothly in terms of processor, RAM and diskspace (and anything else that is relevant).
I found that with the Express edition, I could not use the Streamwriter.  Is this expected?
ML Machine Learning Fellowship
Machine Learning is one of the profound applications of AI and therefore, just like AI, it is surrounded by myths and fears. Check out these facts about ML that demystify the related myths.
CompTIA Cloud+
LVL 12
CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

10 IoT security concerns to keep in mind before developing apps

IoT technology is disrupting the healthcare industry which was going through the phase of unaffordability, unreliability and slowness for best of all Internet of Things (IoT) boom has brought us to security Concerns previously unthought of. 

#IoT #IIoT #IoTStrategy #IoTSecurity #IoTSolution #InternetOfThings #IIoT #IndustrialIoT #Industry40 AI #MachineLearning #Technology #Business


Expert Comment

by:Harriet Tewksbury
Good points. Here is an additional list of overall IoT challenges that arise while developing an IoT project:
I want to create a program in Prolog that reads in a user input and finds a synonym for the words that the enter.

For example, if they entered
?- : [i,like,walking] 

Open in new window

, the program would change it to

Open in new window

I want to do this with an input predicate like...




Open in new window

I know what I want to do, but I don't know how I would go about doing it.
Any help would be much appreciated.
The Robotic Process Automation are fast approaching RPA , any idea how our MS access developed application will be affected ? The RPA will replace many of the jobs that are currently done by human through automation , does it mean that our applications will be redundant if they cannot link with robots?


Subject of the week | Tell us about a technology you'd like to learn.
I'm fascinated by developments in Machine Learning and want to, heh, learn more about it. Not so much because I want to create Machine Learning systems myself—I have very little interest in the math involved—but so I can know how to leverage the sort of things that are being built. I easily envision the future of most work being about managing various bots and knowing how to apply them to higher level problem solving.

To get started on that path, I'm currently teaching myself Python (via several books on the subject) and would then transition into the use of it to dig deeper into the Machine Learning libraries. (And if I have to, even some refresher on the math... I did pass the AP calculus test, but that was 20 years ago!)

Any of you out there with more knowledge in these areas have some advice on this?
How should you communicate with robots?

Also with access control don't worry about it right guys?






Robotics is the branch of technology that deals with the design, construction, operation, and application of automated machines known as robots. It also involves the computers systems for their control, sensory feedback, and information processing.

Top Experts In