![]() ' line error " Application defined or object defined error"ĪctiveChart.SeriesCollection(1).Name = "='" + plant + "'!R49C4"ĪctiveChart.SeriesCollection(2).XValues = "='" + plant + "'!R50C1:R62C1"ĪctiveChart.SeriesCollection(3).XValues = "='" + plant + "'!R50C1:R62C1"ĪctiveSheet.ChartObjects("Chart 2").ActivateĪctiveChart.SeriesCollection(1).Values = "='" + plant + "'!R50C5:R62C5"ĪctiveChart.SeriesCollection(1).Name = "='" + plant + "'!R49C5" Sheets((i + 2)).Cells(3, 4).Value = plantĪctiveSheet.ChartObjects("Chart 1").ActivateĪctiveChart.Axes(xlValue).MajorGridlines.SelectĪctiveChart.SeriesCollection(1).XValues = "='" + plant + "'!R50C1:R62C1"ĪctiveChart.SeriesCollection(1).Values = "='" + plant + "'!R50C4:R62C4" Plant = Trim(Sheets("MasterData").Cells(i, 4).Text) 'Sheets("Supplier Overview").Visible = Falseĭo While Sheets("MasterData").Cells(i, 4).Text "" Sheets("Chart").Cells(6, 6).Value = Sheets("Properties").Cells(12, 3).ValueĪctiveSheet.PivotTables(1).PivotCache.Refresh SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _ Selection.Replace What:="%%%*", Replacement:="", LookAt:=xlPart, _ Sheets("Supplier Overview").Visible = False Sheets("Supplier Overview").Cells(6, 6).Value = Sheets("Properties").Cells(12, 3).Value Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ Sheets("Properties").Cells(9, 3).Value = pSupName PSupName = pSupName + " " + Sheets("MasterData").Cells(nb, 5).Text ![]() PSupName = Sheets("MasterData").Cells(nb, 5).Text While Sheets("MasterData").Cells(nb, 5).Text "" SourceConnectionFile = "C:\Data\ABIS\ABIS.dsn" It's a free maintenance update for registered users. "SELECT DISTINCT TXTODBC.SUPPLIER_NAME" & Chr(13) & "" & Chr(10) & "FROM TXTODBC.TXT TXTODBC" & Chr(13) & "" & Chr(10) & " WHERE (TXTODBC.SUPPLIER_NAME'null')" _ The National Software Laboratory has announced ArraySync 1.0.1, an update of the tool for synchronizing QuickTime playback on multiple displays attached to one computer, or across a local area network. "=27 Extensions=txt,csv,tab,asc FIL=text MaxBufferSize=2048 MaxScanRows=25 PageTimeout=5 SafeTransactions=0 Threads=3 UserCommit" _ "ODBC DBQ=C:\Data\ABIS DefaultDir=C:\Data\ABIS Driver= DriverId" _ TfWorker.If Sheets("Properties").Cells(1, 256).Text "OK" Then It’s something like this: // index.js click to call worker from main thread I’m trying to upload a executable project, it will take some time. In fact, even if I just call model.predict() without the following value.data(), it acted the same. As a comparison, it got 800ms block when that tasks run on main thread. I’ve checked my code, the predict/data tasks was executed on a WebWorker. ![]() It sounds like general operations return synchronously before they actually done, so do model.predict()?Īnother thing border me is that if model.predict acts like the other general operations, then why do that take 100ms to return a not done handle? 10ms predict with a handle return, and 700ms to run model before output with tensor.array() would be more reasonable. When you call x.data() or x.array(), the values will resolve when the computation has actually completed. This means the tf.Tensor returned is just a handle to the computation. When an operation is called, like tf.matMul(a, b), the resulting tf.Tensor is synchronously returned, however the computation of the matrix multiplication may not actually be ready yet. Dose that mean it did not finish prediction in 100ms and need the following 700ms? But between predict and my actural output with tensor.array(), I got A UI block around 700ms. I did call new Date.now() before and after model.predict() and got a result around 100ms, it’s good enough. But I do not know how to get the time cost of model prediction. I’m trying to run my model through tfjs with webgl backend.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |