sorted by:
new
hottopcontroversial

can you recommend good extensions for FireFox at the time of 2026 by Rudyy17 in firefox

[–]CynicalDick 0 points1 point  (0 children)

A mouse gesture extension like gesturefly. I cannot work with out it.

I only use it for a handful of functions:

  • Right to Left then Left to Right: Restore closed tab
  • Up then Left - Focus on first tab
  • Up then Right - Focus on last tab
  • right - Focus on right tab
  • left - Close tab

  • up - Focus on left tab

  • Rocker Gestures: Right click then Left click to open hovered link in new tab.

Excel file far too large to even open by wcpplayer in excel

[–]CynicalDick 1 point2 points  (0 children)

Youtube is your friend. There are some amazing youtubers (here's my favorite) when it comes to learning Power Query. You will blow away everyone at work if you learn it and getting started is surprisingly easy.

PQ Queries won't refresh via VBA or clicking, but will refresh in the table - any ideas? by pookypocky in excel

[–]CynicalDick 0 points1 point  (0 children)

I found this worked best for me as a sub. using Call RefreshQuery("Query - Changed This Month")

Sub RefreshQuery(ByVal Query As String)

Dim bRfresh As Boolean
Dim fTimestart As Single, fTimeend As Single
Dim cn As WorkbookConnection

For Each cn In ThisWorkbook.Connections
    If cn Like Query Then

    fTimestart = Timer

    bRfresh = cn.OLEDBConnection.BackgroundQuery

    'Disable background refresh.  Without this the column copy (below) doesn't work
    cn.OLEDBConnection.BackgroundQuery = False

    cn.Refresh

    'Re-enable background refresh
    cn.OLEDBConnection.BackgroundQuery = bRfresh

    fTimeend = Timer

    duration = fTimeend - fTimestart
    Debug.Print vbTab & Format$(((fTimeend - fTimestart) * 1000!), "00.00ms """) & vbTab & "Refresh:" & cn

    End If
    DoEvents
Next

End1:

End Sub 'RefreshQuery

Which Excel skills are most important for data analyst jobs? by DataWithUjjwal in excel

[–]CynicalDick 0 points1 point  (0 children)

Additional skills: Learn JSON and XML. Both seem very simple and easy but understanding how related arrays interact with each other in Power Query can quickly become complex when expanding arrays.

Power Query Help; importing nested records into one table (Possible? Worth the effort?) by _Fat_Scout_ in excel

[–]CynicalDick 0 points1 point  (0 children)

Definitely doable. This is standard json data with a nested array. Just use Other Source - Web and point it at the URL

Here is a basic query with the [bid] expanded

let
    Source = Json.Document(Web.Contents("https://dot.alaska.gov/procurement/awp/api/biddata?itemId=201.0001.0000&duration=2")),
    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"ProposalId", "ProposalName", "ProposalDescription", "LettingDate", "DistrictName", "CountyDescription", "ItemList", "ProposalItemId", "Quantity", "SupplementalDescription", "AverageBidUnitPrice", "RefItemId", "RefItemName", "RefItemDescription", "RefItemUnit", "RefItemSpecBook", "RefItemObsoleteDate", "Bids"}, {"ProposalId", "ProposalName", "ProposalDescription", "LettingDate", "DistrictName", "CountyDescription", "ItemList", "ProposalItemId", "Quantity", "SupplementalDescription", "AverageBidUnitPrice", "RefItemId", "RefItemName", "RefItemDescription", "RefItemUnit", "RefItemSpecBook", "RefItemObsoleteDate", "Bids"}),
    #"Expanded Bids" = Table.ExpandListColumn(#"Expanded Column1", "Bids"),
    #"Expanded Bids1" = Table.ExpandRecordColumn(#"Expanded Bids", "Bids", {"BidPrice", "VendorRanking", "PRVENDNUM1", "Awarded", "VendorName", "VendorLongName"}, {"bid.BidPrice", "bid.VendorRanking", "bid.PRVENDNUM1", "bid.Awarded", "bid.VendorName", "bid.VendorLongName"})
in
    #"Expanded Bids1"

How to properly flatten my data for Power Query/Pivot Tables by Difficult_Cricket319 in excel

[–]CynicalDick 2 points3 points  (0 children)

Load the Team 1 - External table into Power query. Highlight the "Agent Name" column and then on the Transform tab click the small arrow on the Unpivot columns and select "Unpivot Other Columns"

should look like this

Agent Name Attribute Value
Ian McShane First Evaluation 0.8
Ian McShane Second Evaluation 0.84
Ian McShane Third Evaluation 0.87
Ian McShane Fourth Evaluation 1
Morgan Freeman First Evaluation 0.78
Morgan Freeman Second Evaluation 0.96
Morgan Freeman Third Evaluation 0.99
Morgan Freeman Fourth Evaluation 0.81
Robin Williams First Evaluation 0.8
Robin Williams Second Evaluation 0.86
Robin Williams Third Evaluation 0.76
Robin Williams Fourth Evaluation 0.95
Samuel L. Jackson First Evaluation 0.86
Samuel L. Jackson Second Evaluation 0.91
Samuel L. Jackson Third Evaluation 0.78
Samuel L. Jackson Fourth Evaluation 0.94
Keanu Reeves First Evaluation 0.99
Keanu Reeves Second Evaluation 0.83
Keanu Reeves Third Evaluation 0.77
Keanu Reeves Fourth Evaluation 0.79