Hi

We need to convert the text on an  invoice which can be in the form of image/PDF into XML.

Any third party service which uses artificial intelligence to process different kind of invoice template, is needed.

Please let me know about any tool/service(free/paid) is available for same.
In net I can see many companies providing same but when we actually contact them, they deny.
Please help.

Thanks.

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

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

Select all 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)
    ws.Activate
     '==>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)
    '==>ApplyFormula
    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

Select all Open in new window

Thank you in advance for your help.

Hi
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 ChessEngine.py to reinstate the board creation
Have they become entangled?

My
ChessEngine.py 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?

Thanks

files...

ChessBoard.py

ChessEngine.py

ChessPlayer_abc.py

ChessBoard.py

RandomPlayer.py

ChessPlayer.py

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?

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

hi,

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:

https://www.oracle.com/artificial-intelligence/platform.html

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.

Select all Open in new window

.

which component is free and no issue with Oracle DB. ?

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?

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?

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)?

Hi

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.
Thanks