Categories
User Help

Digital Microscope(equivalent to an old webcam) on MacOS

I have this “DM4 Digital Microscope” (noname?): (readily available on e.g. eBay) I can not make it work on my mac! The microscope is set up to works as an external camera, and… It has been successfully tested on a millennial old windows XP computer. On my newly restarted and fully upgraded(macOS Catalina 10.15.4) MacBook […]

Categories
Mastering Development

Insert specific non sequential values into a serial field (ID) of a postgres table

Context On the one hand, I have a PostgreSQL data model with a table that has one ID field defined as a serial (which relies on a sequence). On the other hand, I first had some data that have their own unique IDs, but which were not starting from 1, e.g.: 1001, 1002, 1003, 1004, […]

Categories
Mastering Development

Pivot table with weekly data

I have one data set which contain weekly data from sales from 4-stories (Store_1,Store_2,Store_3 and Store_4) in the period 2017 until 2019. FINAL_SALES<-structure(list(year_week = structure(154:322, .Label = c(“2014 01”, “2014 06”, “2014 07”, “2014 08”, “2014 09”, “2014 10”, “2014 11”, “2014 12”, “2014 13”, “2014 14”, “2014 15”, “2014 16”, “2014 17”, “2014 18”, […]

Categories
Apple User Help

Preview on Catalina fails to select or copy text in PDF

After entering the Title for this question, I see numerous links to (perhaps) similar questions regarding Preview‘s failure to select or copy text from a PDF document. And so this question may do nothing more than document another malfunction. My current system: The hardware is MacBook Pro (16-inch, 2019), my OS is macOS Catalina, ver […]

Categories
Apple User Help

Preview on Catalina fails to select or copy text in PDF

After entering the Title for this question, I see numerous links to (perhaps) similar questions regarding Preview‘s failure to select or copy text from a PDF document. And so this question may do nothing more than document another malfunction. My current system: The hardware is MacBook Pro (16-inch, 2019), my OS is macOS Catalina, ver […]

Categories
Mastering Development

How can I return the largest value among different elements within a list?

STOCKDATA_LIST_01=[“2019,06,03,49.88,50.33,49.78,50.22,48.54,729600”, “2019,06,04,50.31,50.50,50.17,50.37,48.68,888800”, “2019,06,05,50.45,51.11,50.45,50.71,49.01,1144700”, “2019,06,06,50.89,51.22,50.85,50.98,49.27,913200”, “2019,06,07,50.65,50.77,49.98,50.07,48.93,881800”, “2019,06,10,49.96,50.15,49.71,50.13,48.99,643200”, “2019,06,11,50.21,50.26,49.92,50.02,48.88,1006000”, “2019,06,12,50.02,50.33,49.88,50.15,49.01,696700”, “2019,06,13,50.24,50.50,48.66,48.79,47.68,1993300”, “2019,06,14,48.74,48.76,48.05,48.60,47.50,2125800”, “2019,06,17,48.64,48.64,47.77,48.14,47.05,1751600”, “2019,06,18,48.24,48.92,48.24,48.67,47.56,1879200”, “2019,06,19,48.68,48.86,48.66,48.77,47.66,824100”, “2019,06,20,48.77,48.77,48.18,48.50,47.40,902600”, “2019,06,21,48.43,48.56,48.25,48.27,47.17,2825600”, “2019,06,24,48.36,48.67,48.27,48.40,47.30,650100”, “2019,06,25,48.29,48.54,48.15,48.31,47.21,963700”, “2019,06,26,48.30,48.50,47.99,48.13,47.04,750600”, “2019,06,27,48.02,48.52,47.96,48.34,47.24,1022000”, “2019,06,28,48.30,48.61,48.15,48.41,47.31,979700”] ^ This above is the long list of stock info for a whole month, in the form (year, month, day, stock price 1, stock price 2, stock price 3, stock price 4, stock price 5, […]

Categories
Mastering Development

How to sort stacks within each ggplot’s facets?

Please help us sort the stacks in ascending order ! i.e. left facet seems to be in order but right side is not really sorted because 1.7 should have come at the right end. (please refer screenshot) similar but not exact queries How to control ordering of stacked bar chart using identity on ggplot2 Order […]

Categories
Apple Ask

How to re-enable sounds for calendar notifications?

I have my work Exchange account syncing with the default Mac OS Calendar app. Until recently, this worked very well and I would get notifications (with sound) for forthcoming events. For the last week or so, the notification sound has vanished. I still get pop-up notifications at the right time, but no sound. My exchange […]

Categories
Mastering Development

Conversion failed when converting the varchar value ‘.’ to data type int

I have a query as below: SELECT activity_code, activity_name, Count(*) Total_Response, yearnumber, Cast(Avg(Cast(Isnull([response], 0) AS NUMERIC)) AS DECIMAL(10, 2)) [Ratings] FROM (SELECT code [Activity_Code], activityname [Activity_Name], enddt.yearnumber, CASE WHEN Isnumeric(asmt.userresponse) = 1 THEN asmt.userresponse ELSE 0 END [Response] FROM (SELECT userid, questionid, activityid, attemptenddateid, CASE WHEN Isnumeric(userresponse) = 1 THEN userresponse ELSE ‘0’ END AS […]

Categories
Apple Ask

How to re-enable sounds for calendar notifications?

I have my work Exchange account syncing with the default Mac OS Calendar app. Until recently, this worked very well and I would get notifications (with sound) for forthcoming events. For the last week or so, the notification sound has vanished. I still get pop-up notifications at the right time, but no sound. Here’s what […]