StackOverflow.com

VN:F [1.9.22_1171]
Rating: 9.4/10 (10 votes cast)

Random snippets of all sorts of code, mixed with a selection of help and advice.

How to Create and Use a Reference Table in Excel for Auto-Filling Customer Information

18 May 2024 @ 4:47 pm

I need assistance with Excel to improve the efficiency of recording my daily sales. Specifically, I want to create a system where certain customer information can be auto-filled to avoid repetitive data entry. Here are the details of what I'm trying to achieve: Daily Sales Table: This table will include columns such as Product Name, Amount, Name of Customer, Tax ID, Address, etc. Reference Table: This table will store all customer information, using the Tax ID as a unique key. It will include columns like Name of Customer, Tax ID, Address, etc. My idea is when I enter a Tax ID in the daily sales table, the corresponding customer information (Name of Customer, Address, etc.) should automatically populate based on the reference table. The reference table should be easily updateable to add new customers and modify existing entries. How can I set up the reference table in Excel to store customer information with Tax ID as a unique key? What methods or Excel function

Calculate graident of loss function

18 May 2024 @ 4:44 pm

Consider a neural network shown below. Consider we have a cross-entropy loss function for binary classification: Ref diagram L=−[𝑦 ln(𝑎)+(1−𝑦) ln(1−𝑎)], where 𝑎 is the probability out from the output layer activation function. We've built a computation graph of the network as shown below. The blue letters below are intermediate variable labels to help you understand the connection between the network architecture graph above and the computation graph. Diagram When 𝑦=1, what is the gradient of the loss function w.r.t. 𝑊11? Write your answer to three decimal places. Note: Please use the computation graph method. One can calculate the gradient directly using chain rules, but if the computation graph is not used at all, it will not score properly. Try to fill the red boxes above. Th

Downporting C++17 to C++14: Cannot call member function without object

18 May 2024 @ 4:43 pm

I need to convert a C++17 project down to C++14 because I'm targetting a platform whose gcc doesn't support anything newer than C++14. I was able to adapt 99% of the code so that it compiles in C++14 mode but there's one thing where I don't know how to adapt it for C++14. It's this code: sptr<Box> MatrixAtom::createBox(Env& env) { if (_matType == MatrixType::smallMatrix) { return env.withStyle(TexStyle::script, [this](auto& script) { return createBoxInner(script); }); } return createBoxInner(env); } (full code here) When compiling this as C++14, gcc returns the following error: lib/atom/atom_matrix.cpp: In instantiation of 'microtex::MatrixAtom::createBox(microtex::Env&)::<lambda(auto:1&)> [with auto:1 = microtex::Env]': lib/env/env.h:196

How to obtain an HBITMAP of the date and time displayed in the taskbar on Windows 11/10?

18 May 2024 @ 4:41 pm

I am attempting to retrieve an HBITMAP of the date and time displayed in the taskbar on Windows 11/10. Specifically, I need to access the container or window that contains this information programmatically. I tried accessing the TrayClockWClass, but it did not work as expected. I couldn't find relevant information on MSDN or other sources regarding this specific taskbar element. I expected to find a straightforward method or API to retrieve the HBITMAP or at least the name of the container/window where the date and time are displayed.

SyntaxError: The requested module '@muchobuenofestival/shared/types/User.ts' does not provide an export named 'greetUser'

18 May 2024 @ 4:39 pm

i'm starting a project with pnpm:9.1.1 for shared types and functions. AdonisJS 6 for my backend and ReactTS for frontend. Here's my folder my_project backend app controllers users_controllers.ts package.json (calling the shared type) frontend shared types User.ts package.json When I use my type only no problem, but when I want to use enum or functions exported, it is not working, maybe I'm missing something please help. Console [ info ] starting HTTP server... SyntaxError: The requested module '@muchobuenofestival/shared/types/User.ts' does not provide an export named 'greetUser' at (syntax error) app\controllers\users_controller.ts:2 1| import typ

Spring Cloud Gateway Custom Filter Handle Error Response

18 May 2024 @ 4:39 pm

I have a customer filter in my spring cloud gateway and I am making a request with WebClient to validate authentication. If the response is 200 I want to continue with the execution/chain and if they response is not 200, I want to return the code I get back. My issue is I can't find a way to return the code if I can a non 200 response. Here is my code @Override public GatewayFilter apply(Config config) { return (exchange, chain) -> { WebClient webClient = WebClient.create("http://" + authServiceHost + ":" + authServicePort + "/api/v1/"); return webClient.post().uri("auth/validate-session") .exchangeToMono(clientResponse -> { if (!clientResponse.statusCode().is2xxSuccessful()) { // HOW DO I STOP EXECUTION HERE AND RETURN clientResponse.statusCode() // STOP the execution of exchange here // below do

Why am I getting an HTTP error 404 with pywikigraph?

18 May 2024 @ 4:31 pm

I'm trying to make code that finds the shortest possible path between two Wikipedia articles. When I run it, the following error is returned: Downloading index.pkl... (may take several minutes as it is 1 GB) Traceback (most recent call last): File "c:\Users\thomp\wikispeedrunning.py", line 6, in <module> wikirace = WikiGraph().get_shortest_paths_info(startpoint, endpoint) ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\thomp\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.12_qbz5n2kfra8p0\LocalCache\local-packages\Python312\site-packages\pywikigraph\wikigraph.py", line 211, in get_shortest_paths_info if not self._exists(topic=source, verbose=verbose): ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ File "C:\Users\thomp\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.12_qbz5n2kfra8p0\LocalCache\local-packages\Python312\site-packages\pywikigraph\wikigraph.py&quo

How to write sql query to filter for ids where its other column values are the same?

18 May 2024 @ 4:24 pm

I have the following SQL table: id fid val 200 995 XXLL 200 996 XXLL 201 995 OOOP 201 996 OOOS 202 995 OKIL 202 996 OKIL 203 995 LLLL 203 996 CCCC What I am trying to do is to get all of the ids where the value of 995 and 996 are the same. So in the above example, I would like the output of the sql query to be just 200, 202, because 201 and 203's 995 and 996 values are different! I hope the above makes sense, and any help is much appreciated!

CTest: Test not available without configuration

18 May 2024 @ 4:15 pm

I realize this is a very basic question, but I was unable to fix my problem despite even after reading multiple tutorials, including the official tutorial and the Professional Cmake book. I am simply trying to add unit tests to my C++ project with CMake 3.28 on Visual Studio 2022. However, when I run CTest, I get the following error: Test not available without configuration. (Missing "-C <config>"?) 1/1 Test #1: cpp_test .........................***Not Run 0.00 sec The "Test not available without configuration" message seems to indicate the configuration is missing. I did however defined the test in my CMakeLists.txt. I recreated the problem with minimal code. main.ccp int main() { return 0; } cpp_test.cpp int main() { return 0; } CMakeLists.txt cmake_minimum_require

Flutter handle play video

18 May 2024 @ 4:03 pm

If you're having trouble watching movies, the general overview is that after receiving data transmitted from the "link_embed" api, video_player or webview_flutter will be used to handle video playback. However, now after successfully receiving the data, I am unable to play the video and only display a black screen. Hope everyone can help me, thank youenter image description here,API here, SRC,SRC,

odysee.com

VN:F [1.9.22_1171]
Rating: 9.0/10 (3 votes cast)

Less censorship more entertainment. Alternative YouTube.

mewe.com

VN:F [1.9.22_1171]
Rating: 9.0/10 (2 votes cast)

Social networks without the ads and invasion of privacy, alternative to Facebook.

Hopefully it will stay this way.

who-called.co.uk

VN:F [1.9.22_1171]
Rating: 9.0/10 (2 votes cast)

Who called me, check with others to see if you have a scam caller.

freedomcells.org

VN:F [1.9.22_1171]
Rating: 9.0/10 (1 vote cast)

Freedom Cells are peer to peer groups organising themselves in a decentralised manner with the collective goal of asserting the sovereignty of group members through peaceful resistance and the creation of alternative institutions.

rumble.com

VN:F [1.9.22_1171]
Rating: 8.7/10 (3 votes cast)

Another alternative to the censorship of YouTube.

en.whotwi.com

VN:F [1.9.22_1171]
Rating: 8.5/10 (6 votes cast)

Graphical twitter user statistics

Flickr.com

VN:F [1.9.22_1171]
Rating: 8.5/10 (2 votes cast)

Almost certainly the best online photo management and sharing application in the world

Warming up after diving in the sea

21 April 2024 @ 12:31 am

Portrait of Natalia

6 April 2024 @ 11:09 pm

Susi's sexy legs

23 March 2024 @ 11:44 pm

130815131303_MG_1028

6 March 2024 @ 10:01 am

Kitty 231

13 December 2023 @ 4:49 pm

Mercury Sport Coupé 1950

26 October 2023 @ 5:53 pm

Female chameleon walking on the leaf

26 September 2023 @ 9:01 am

halfbakery.com

VN:F [1.9.22_1171]
Rating: 8.5/10 (2 votes cast)

Half baked ideas going way back.

bitchute.com

VN:F [1.9.22_1171]
Rating: 8.0/10 (4 votes cast)

Video sharing that may not be allowed (censored) on youtube.