ontime | Time keeping for live events

Apologies, the formatting is not cooperating with my browser.

Edition Windows 10 Pro

Version 21H2 OS build 19044.1586 Excel 2007, VBA: Retail 6.5.1057 - Forms3: 12.0.6723.500

THE CONCERN:

...

I am trying to create a graph where I am can view total flights by year, filtered by origin and its destination. Picture1: What I envision VS Picture2: The result.

Problem 1: Graph unable to appear on shinyApp.

Problem 2: When the graph appears, the graph does not change even when I select a different Origin from the dropdown box

I am quite new to shiny, any help would be greatly appreciated! The data I am using is from Harvard database- data expo 2009, Airline on time data.

...

I have a table like this

this is just a sample of my table

ID PRSNO QTY DESC STATUS 1 TEST1 1 Pen Ontime 2 TEST1 1 Eraser Delay 3 TEST1 1 Scissor Ontime ID PRSNO QTY DESC STATUS 4 TEST2 1 Pen Delay 5 TEST2 1 Notebook Delay 6 TEST2 1 Pentelpen Delay ID PRSNO QTY DESC STATUS 7 TEST3 1 Pen Ontime 8 TEST3 1 Notebook Ontime 9 TEST3 1 Pentelpen Delay 9 TEST3 1 Pentelpen Delay ID PRSNO QTY DESC STATUS 7 TEST4 1 Keyboard Delay 8 TEST4 1 Mouse Ontime 9 TEST4 1 Monitor Delay 9 TEST4 1 CPU Delay

but my problem is i want to display this like this

PRSNO STATUS TEST1 Ontime TEST2 Delay TEST3 Ontime TEST4 Delay

I just know how to distinct the PRSNO but i dont know how to calculate the status where if Ontime <= Delay
Ontime else Delay

My code is only for distinct

...

I have a worksheet where column C has a formula that looks up value if column D = "Metered". Users, who are mostly farm workers, have the ability to overwrite it (or possibly delete it using the Make Correction button). Unless column D = "Metered", I don't care if column C is overwritten because data validation makes sure entry is OK. Users are supposed to Tab past column C unless load is "Metered". As a failsafe, I duplicated the "Metered" lookup formula elsewhere and the results are in column S. I don't get any errors on code below, but it doesn't do anything -- previous versions would do things but not the right things. Clearly, I cannot solve this on my own and very much appreciate any help you can provide. I want to run the failsafe once a day when the workbook is opened (running on laptops and speed is important).

...

I am trying to build MicroSIP version 3.20.7 for Windows 10 64-bit Operating System.

I already build PjProject (As mentioned in the documentation) and obtained all the .lib files for the same and now I am trying to use those .lib files for building MicroSIP as mentioned in the documentation over their website.

But I fall for an error of Unresolved External Symbols that is LNK2019 / LNK2001 / LNK1120.

(An image for the reference have been attached)

I am concluding with following steps.

1. Download the source for PjProject and extract the source using 7Zip.
2. Added a config_site.h file in the pjlib\include\pj.
3. Using Visual Studio 2022, Open PjProject and select pjsua as the source project.
4. Setting up the configuration for the project as -> Debug-Static for x64. and Build.
5. After a successfull build I got all the .lib files for the PjProject and successfully deployed the pjsua project showing a cli menu for PjSIP.
6. Now, I downloaded the latest source of MicroSIP 3.20.7 from the official website and extracted the source code using 7Zip.
7. Setting the configuration for the project as Debug for x64, and including all the header files and library files from windows kit as well as the other media libraries to the Include Directories and Library Directories {Opus, SDL2, FFMPEG,x264, VPX, PjProject}
8. I started to build the MicroSIP 3.20.7 and obtained the MicroSIP.lib file successfully.

But at the last where the build must give an executable file for MicroSIP, there are the list of error stating Unresolved External Symbols {LNK2019 / LNK2001 / LNK1120}

Below is the link to the image having all the error in console windows.

The error states the following message.

1. unresolved external symbol pjmedia_get_vid_subsys referenced in function "public: void __cdecl CmainDlg::OnTimer(unsigned __int64)" (?OnTimer@CmainDlg@@QEAAX_K@Z)

2. unresolved external symbol pjmedia_vid_dev_refrence referenced in function "public: void __cdecl CmainDlg::OnTimer(unsigned __int64)" (?OnTimer@CmainDlg@@QEAAX_K@Z).

etc there are other 17 error (Kindly take the refrence of above image.)

Below is the link to the image having error logged in output tab.

These are the message logged into the output tab

...

I am trying to pull out data from my table into a data frame, but upon doing so, I was only shown 'None' instead of the number original value/data that i have input in my table. Codes as attached below:

...

I am trying to pull out the information from a table into a data frame and the next thing i wanted was to use an if-else statement based on data I retrieved and to insert it into a new column into the existing data frame.

...

I have a flink(v1.13.3) application with un-bounded stream (using kafka). And one of the my stream is so busy. And also busy value (I can see on the UI) increases over the time. When I just start flink application:

• sum by(task_name) (flink_taskmanager_job_task_busyTimeMsPerSecond{job="Flink", task_name="MyProcessFunction"}) returns 300-450 ms
• After five++ hours sum by(task_name) (flink_taskmanager_job_task_busyTimeMsPerSecond{job="Flink", task_name="MyProcessFunction"}) returns 5-7 sn.

This function is so simple, and it just use rocksdb for the state backend:

...

I have looked at this article about using std::variant. This is because the following code was raising a code analysis warning:

...