Updating a cell in Google Sheets based on whether the value appears on two different tabs in the same workbook

I am trying to make a cell in my "Inventory" sheet update to "Yes" if that item appears on either of two other sheets in the workbook. If the item from column B does not appear in either sheet, the cell should read "No".


If I use the following formula to check my "2023 Completed" sheet, I do get a proper yes/no result.


=IF(ISERROR(VLOOKUP($B$2:$B$200, '2023 Completed'!$D$2:$D$100, 1, FALSE)), "No", "Yes")


I am trying to check both the '2023 Completed' and '2024 Completed' sheets though. I have tried many variations of formulas and just get a parsing error no matter what I try. The most recent formula I have is:


=IF(OR(ISERROR(VLOOKUP($B$2:$B$200, '2023 Completed'!$D$2:$D$100, 1, FALSE)), "No", "Yes"), (ISERROR(VLOOKUP($B$2:$B$200, '2024 Completed'!$C$2:$C$100, 1, FALSE)), "No", "Yes"))


The shift from column D to column C is correct, I removed a column between the two years' sheets. I'm not sure what I'm doing wrong here - any help would be appreciated.

Read More

I can't access a webpage through python requests module but I can access the website from my PC browser

I am trying to access this website
https://99acres.com with python requests module but it just keeps processing and does not stop while the same website works fine on browser.
After 10 min it gives an error
ConnectionError: ('Connection aborted.', ConnectionResetError(10054, 'An existing connection was forcibly closed by the remote host', None, 10054, None))


Following is my code:
import requests
url = '
https://99acres.com'
headers = {
'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:121.0) Gecko/20100101 Firefox/121.0'
}
r = requests.get(url,headers = headers)



I have tried the following:



* giving user-agent in headers.


* copying the request from the browser inspect as Curl and then converted it to python from online website.
Unfortunately nothing seems to work.





Is it possible to connect with this website from python request module?

Read More

Java Swing Graphics are drawned inconsistently when system scale is 125% in a scrollpane

at 100% screen scaling the drawn shape is always "pixel perfect".





at 125% screen scaling the same shape in this case it's sometimes drawn as if it has an extra row of pixels on the top (1) instead of the way it should be drawned (2). These shapes are drawned in a list in a scrollpane and while scrolling up and down, they flicker, changing from one version to the other and it's very apparent and distracting.





This I've observed being dependant on the component position, and perhaps I suppose it draws the shape inbetween 2 pixels and so it "randomly" chooses either the pixel above for one component or the one below for another one...
package debug;

import java.awt.BorderLayout;
import java.awt.Container;
import java.awt.Dimension;
import java.awt.Graphics;
import java.awt.Graphics2D;
import java.awt.GridLayout;
import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.SwingUtilities;
import javax.swing.border.EmptyBorder;

public class TestBugScaling implements Runnable {

private final int size = 38;

public static void main(String[] args) {
SwingUtilities.invokeLater(new TestBugScaling());
}

@Override
public void run() {
JFrame frame = new JFrame();
frame.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
frame.setPreferredSize(new Dimension(400, 400));

Container contentPane = frame.getContentPane();
contentPane.setLayout(new BorderLayout());
contentPane.setPreferredSize(new Dimension(400, 400));

JScrollPane scrollPane = new JScrollPane();
scrollPane.setPreferredSize(new Dimension(size + 10, 400));
scrollPane.getVerticalScrollBar().setUnitIncrement(size + 5);
scrollPane.getVerticalScrollBar().setBlockIncrement((size + 5) * 2);

JPanel container = new JPanel();
container.setBorder(new EmptyBorder(5, 5, 5, 5));
container.setLayout(new GridLayout(20, 0, 0, 5));
container.setPreferredSize(new Dimension(size + 10, (size + 5) * 20));

container.add(new CirclePanel());
container.add(new CirclePanel());
container.add(new CirclePanel());
container.add(new CirclePanel());
container.add(new CirclePanel());
container.add(new CirclePanel());
container.add(new CirclePanel());
container.add(new CirclePanel());
container.add(new CirclePanel());
container.add(new CirclePanel());
container.add(new CirclePanel());
container.add(new CirclePanel());
container.add(new CirclePanel());
container.add(new CirclePanel());
container.add(new CirclePanel());
container.add(new CirclePanel());
container.add(new CirclePanel());
container.add(new CirclePanel());
container.add(new CirclePanel());
container.add(new CirclePanel());

scrollPane.setViewportView(container);

contentPane.add(scrollPane, BorderLayout.NORTH);

frame.pack();
frame.setVisible(true);
}

public class CirclePanel extends JPanel {

public CirclePanel() {
super();
setPreferredSize(new Dimension(size, size));
setMinimumSize(new Dimension(size, size));
setMaximumSize(new Dimension(size, size));
}

@Override
public void paintComponent(Graphics g) {
Graphics2D g2 = (Graphics2D) g.create();
g2.fillOval(0, 0, getHeight(), getHeight());
g2.dispose();
}

}

}



With this code, if you have 100% screen scale, you will see a smooth scrolling of the circles.
Instead, with a 125% screen scale, if you look closely you will see the circles bobbing up and down 1 pixel out of place while scrolling...


Is there a way to prevent / fix this? what is causing it?


I don't mind the shape not being completely perfect, but I do mind that it flickers and that it's not consistent all the time...

Read More

Update from 9 to 10

Should I update from laravel 9 to 10? It's a small project. submitted by /u/icex34
[link] [comments]

Read More

Cashier package and Blade files

I'm a little confused about this Cashier package.

I installed it using the Laravel website (with composer), but noticed there's no template files. composer require laravel/cashier php artisan vendor:publish --tag="cashier-migrations"

Then i stumbled across this github repo:
https://github.com/laravel/cashier-stripe

The repo has a some template files so now I'm not sure what to use. Anybody knows more about this?Can I just copy the few blade files from the repo? Ot is this a whole other package?

Thanks!

​ submitted by /u/kimk2
[link] [comments]

Read More

Unable to install pyocd in latest version of Anaconda

I'm trying to set up our usual Anaconda development environment on a new Windows 10 PC. I downloaded the latest version of Anaconda last week (version 2023.09, I believe), and I'm having trouble installing pyocd. pyocd installed easily on all the other PCs several months ago.


I ran conda using Anaconda Powershell Prompt in administrator mode. Here's what conda returns:
(base) PS C:\WINDOWS\system32> conda install -c conda-forge pyocd
>> Collecting package metadata (current_repodata.json): done
Solving environment: unsuccessful initial attempt using frozen solve. Retrying with flexible solve.
Solving environment: unsuccessful attempt using repodata from current_repodata.json, retrying with next repodata source.
Collecting package metadata (repodata.json): done
Solving environment: unsuccessful initial attempt using frozen solve. Retrying with flexible solve.
Solving environment: \

Found conflicts! Looking for incompatible packages.

This can take several minutes. Press CTRL-C to abort. failed /

UnsatisfiableError: The following specifications were found to be incompatible with each other:

Output in format: Requested package -> Available versions



The error messages are pretty unhelpful - I'd try installing downrev packages, but I don't know which ones to downgrade. Any ideas what's going on?


UPDATE
I updated conda, and now it actually gives me actionable error messages:
(base) PS C:\WINDOWS\system32> conda install -c conda-forge pyocd
>> Channels:
- conda-forge
- defaults
- anaconda Platform: win-64
Collecting package metadata (repodata.json): done
Solving environment: | warning libmamba Added empty dependency for problem type SOLVER_RULE_UPDATE failed

LibMambaUnsatisfiableError: Encountered problems while solving:
- package pyocd-0.34.0-pyhd8ed1ab_0 requires cmsis-pack-manager >=0.4.0,=0.4.0,=3.10,=3.7,=3.8,=3.9,

Read More

Restriction of explicit object parameter in lambda with capture

In C++23, lambda-expression supports an explicit object parameter (a.k.a. "Deducing this"). I found strange restriction for lambda with capturing at [expr.prim.lambda]/p5.



Given a lambda with a lambda-capture, the type of the explicit object parameter, if any, of the lambda's function call operator (possibly instantiated from a function call operator template) shall be either:



* the closure type,

* a class type derived from the closure type, or

* a reference to a possibly cv-qualified such type.






[Example 2:
struct C {
template
C(T);
};

void func(int i) {
int x = [=](this auto&&) { return i; }(); // OK
int y = [=](this C) { return i; }(); // error
int z = [](this C) { return 42; }(); // OK
}



-- end example]



Question: Why is there such restriction for lambda with capture only? Are there any implementation issues?

Read More

Bash script to find and return files in directory

I am a non-programmer experimenting more than anything by writing a commandline based system to write a blog.


I have the following as part of a longer script:

# Find & list out files
filefind (){
files=( */*.md )
PS3="$MSG" ;
select file in "${files[@]}"; do
if [[ $REPLY == "0" ]]; then echo 'Bye!' >&2 ; exit
elif [[ -z $file ]]; then echo 'Invalid choice, try again' >&2
else break
fi
done ;}



I would like to echo " No Files found. Enter 0 to exit" if the folder is empty. I realise I would need another elif line to do this.


When I run this, as is, I always get a return of:
{ ~/Code/newblog } $ ./blog pp
1) /.md
Choose file to Publish, or 0 to exit:



Ideally I'd like only the message with exit option, but would also like to understand why the /.md is returned. Apologies if this is answered elsewhere, hard to know what to look for if you don't know what to look for..! Happy to be pointed in the right direction.

Read More

Error in GiftedChat, Warning : Maximum update depth exceeded. in react-native-gifted-chat

i want to use react-native-gifted-chat
and then when I try to call it, it keeps getting this error
Warning: Maximum update depth exceeded. This can happen when a component calls setState inside useEffect, but useEffect either doesn't have a dependency array, or one of the dependencies changes on every render.
in GiftedChat (created by Chat)
in Chat (created by SceneView)
in StaticContainer
in EnsureSingleNavigator (created by SceneView)
in SceneView (created by CardContainer)
in RCTView (created by View)
in View (created by CardContainer)
in RCTView (created by View)
in View (created by CardContainer)
in RCTView (created by View)
in View
in CardSheet (created by Card)
in RCTView (created by View)
...



And my code
import React from "react";
import { GiftedChat } from 'react-native-gifted-chat';

export default function Chat(){
return(



)
}



How can I solve this issue?

Read More

Deploy angular app to static web app on azure

i have a angular application that i want to be deployed on azure static web apps via git hub actions.
On my local machine:
angular cli 17
node 20
npm 10



This is the yaml file.

name: Azure Static Web Apps CI/CD

on:
push:
branches:
- master
pull_request:
types: [opened, synchronize, reopened, closed]
branches:
- master

jobs:
build_and_deploy_job:
if: github.event_name == 'push' || (github.event_name == 'pull_request' && github.event.action != 'closed')
runs-on: ubuntu-latest
name: Build and Deploy Job
steps:
- uses: actions/setup-node@v4
with:
node-version: '18'
- uses: actions/checkout@v4
with:
sub-modules: true
- name: Build And Deploy
id: builddeploy
uses: Azure/static-web-apps-deploy@v1
with:
azure_static_web_apps_api_token: ${{ secrets.AZURE_STATIC_WEB_APPS_API_TOKEN_VICTORIOUS_DESERT_030B8CE03 }}
repo_token: ${{ secrets.GITHUB_TOKEN }} # Used for Github integrations (i.e. PR comments)
action: "upload"
###### Repository/Build Configurations - These values can be configured to match your app requirements. ######
# For more information regarding Static Web App workflow configurations, please visit:
https://aka.ms/swaworkflowconfig /> app_location: "/" # App source code path
api_location: "api" # Api source code path - optional
output_location: "dist/sun-club" # Built app content directory - optional
###### End of Repository/Build Configurations ######

close_pull_request_job:
if: github.event_name == 'pull_request' && github.event.action == 'closed'
runs-on: ubuntu-latest
name: Close Pull Request Job
steps:
- name: Close Pull Request
id: closepullrequest
uses: Azure/static-web-apps-deploy@v1
with:
azure_static_web_apps_api_token: ${{ secrets.AZURE_STATIC_WEB_APPS_API_TOKEN_VICTORIOUS_DESERT_030B8CE03 }}
action: "close"




I am stuck with this error.



Node.js version v16.20.2 detected.
The Angular CLI requires a minimum Node.js version of v18.13.



I have tried to update the node version with a command from the yaml file but it seems that node 16 is default.


I tried to update the node version using nvm but no success.

Read More