Posts by virtualdvid • 664 points
29 posts
-
1
votes1
answer316
viewsA: How to calculate Access days lag
Try to use the function now(), the formula would look like this: Tempo_Pendencia: Round(Now() - [Data_inicio_pendencia], 0) the formula Round() with zero eliminates decimai.…
-
3
votes1
answer352
viewsA: How to create a measure to count different numbers?
@Rodrigomelo was right, you have to group twice: The first can be grouped by sum (Items) to eliminate duplicates in Pedidos. The second has to group with two conditions one that counts the Pedidos…
powerbianswered virtualdvid 664 -
1
votes2
answers1830
viewsA: Excel - How to concatenate cell range?
If you have Excel 2016, you can use the formula UNIRTEXTO in this way: =UNIRTEXTO(" ",0,B2:B48) here to documentation…
-
2
votes1
answer13169
viewsA: Merge data from different tabs into one in Excel
if you have Excel 2010+, you can use Power Query instead of VBA macros. It’s easier and more efficient. Follow these steps: Here I do a little review: What are the differences between Power Query,…
-
1
votes1
answer40
viewsA: Changing excel cell values
you can use this formula instead of a macro: inglês =TEXT(ROUND(A1,2),"0.00000000000") Portuguese =TEXTO(ARRED(A1,2),"0.00000000000")
-
0
votes1
answer66
viewsA: Select ROW_NUMBER from an excel table
You can use where to filter the desired records: SELECT * FROM [Plan1$] WHERE [Field_name] = "myFilter"
-
0
votes1
answer21
viewsA: How to call a second key in a dictionary using Hdf5matrix?
I finally got! It’s very easy, the type files h5 have this structure: file Group Dataset So if we want to access the Dataset using HDF5Matrix('path/file','dataset'). We just have to call the Group…
-
0
votes1
answer90
viewsA: How can I tabulate a mass file?
You can use this code to fix tabs: Sub FixTabs() Dim i, j, lastRow As Long lastRow = Range("A1").End(xlDown).Row 'Contagem total de linhas j = 1 For i = 1 To lastRow Do While Range("C" &…
-
0
votes1
answer122
viewsA: Keras: Valueerror: Dimension 0 in Both shapes must be Equal (Vggnets)
Thank you to the people of @deeplizard to help me find this reply in the English version of Stackoverflow. Here the translation: The problem is with the line model.layers.pop (). when we use .pop to…
-
0
votes1
answer122
viewsQ: Keras: Valueerror: Dimension 0 in Both shapes must be Equal (Vggnets)
I’m following a tutorial and loaded modelo VGGNet16 pre-trained using Keras vgg16_model = keras.applications.vgg16.VGG16() model = Sequential() for layer in vgg16_model.layers: model.add(layer)…
-
0
votes1
answer21
viewsQ: How to call a second key in a dictionary using Hdf5matrix?
I’m trying to upload a file .h5 using this documentation HDF5Matrix: test_images = HDF5Matrix(train_path+train_file,'images') but I’m getting this mistake: Keyerror: "Unable to open Object (Object…
-
3
votes1
answer573
viewsA: Counter to insert blank line every 5 equal cells
You’re close, I made some modifications to get the interactions you want: Sub Divide5_Click() Dim Lst As Long Dim n As Long Dim i As Integer Lst = Range("A" & Rows.Count).End(xlUp).Row i = 0 n =…
-
2
votes1
answer725
viewsA: Running time error '91' The object variable or the block variable with has not been defined
You first need to add the chart so that it is recognized as an object and in the object you can configure the range from which the information comes: Use a line similar to this one with the graph…
-
2
votes3
answers1114
viewsA: how to commit a cloned repository?
If you are using the Git Bash. You have to make sure you are in the master file. Using the command cd foldername: git log shows detailed changes made You can use this command to confirm changes: git…
-
0
votes2
answers1488
viewsA: Chronologically order VBA date and time
You can use the custom sort function by hierarchical levels:…
-
5
votes1
answer83
viewsA: Excel DISTF equivalent in R
if you want the distribution function, you can do: pf(8.49,1,40, lower.tail=FALSE) 0.00582054498262771
-
0
votes1
answer440
viewsA: How to fix ipykernel_launcher.py: error: unrecognized Arguments in jupyter?
I did it! The reason why it gives us this error is because the code uses 'argparse` and this module is used to write friendly command lines and apparently this creates a conflict with Jupyter…
-
0
votes1
answer440
viewsQ: How to fix ipykernel_launcher.py: error: unrecognized Arguments in jupyter?
I’m following this one tutorial tensorflow after two days preparing the environment in Anaconda I finally managed to perform premade_estimator.py using the cmd but when I try to run the same code in…
-
3
votes1
answer50
viewsA: Doubt in VBA Excel 2013
you can add the formula IFERROR: ActiveCell.Offset(0, 7) = Application.iferror(Application.vlookup(ActiveCell, Sheets("Chargeback code-Pursuit").Range("A2:B20000"), 2, False),"") the…
-
0
votes5
answers32003
viewsA: what formula do I make for ranges of values in excel?
If you have Excel 2016, you can use the function IFS =IFS(C1<=30,0.2,AND(C1>30,C1<=60),0.985,AND(C1>60,C1<=90),1,AND(C1>90,C1<=120),1.015,TRUE,"") or…
-
0
votes1
answer452
viewsA: Grammatically classify a word in English
You can look at this link, it seems that they are working on the documentation of langdetect. I think you can contact them for more details on the page Github. There is also a library polyglot.…
-
6
votes2
answers131
viewsA: Update OLEDB Not working
You can try to change the order in the syntax: ="Update" + @[lStrNome_Table_Planilha] + " set MODO = 1 where id = 1" the ="Update" + [@lStrNome_Table_Planilha] + " set MODO = 1 where id = 1"…
-
4
votes1
answer8581
viewsA: What are the differences between Power Query, Power Pivot, Power BI?
Power Query Is a complement developed from the version of Excel 2010 and now by default in version 2016 as Get & Transform. It is part of Microsoft’s proposal for the development of ETL through…
-
2
votes1
answer8581
viewsQ: What are the differences between Power Query, Power Pivot, Power BI?
I want to make a contribution to the community by presenting these free tools for data analysis using Microsoft and, unfortunately, they are little known and exploited by many and can be very useful…
-
1
votes2
answers1070
viewsA: Format SQL data inside Power BI
You do not need a DAX function to change the imported date format. You can go directly to the query editor and change the field formats as you wish:…
powerbianswered virtualdvid 664 -
0
votes2
answers1235
viewsA: Identify the position of the first empty cell
You need to use the function ENDEREÇO: =CONCATENAR("http://www.teste.com.br/?id=";ENDEREÇO(1,2,4))…
excelanswered virtualdvid 664 -
1
votes1
answer50
views -
1
votes1
answer2531
viewsA: Dividing list items by a number
Splitting up You can do: myList = [1,2,3,4,5,6,7,8,9] myInt = 10 newList = [float(i) / myInt for i in myList] Or if you need to keep the reference in the original list myList[:] = [float(i) / myInt…
pythonanswered virtualdvid 664 -
0
votes1
answer677
viewsA: How to set the filters in a Pivotchart through a macro in Excel?
Why You Don’t Use Data Segmentation for Creating Dashboards? With data segmentation, you can easily connect and filter multiple tables and dynamic charts without the need to use VBA:…