asin | Amazon Simple INterface - Support for ItemLookup | AWS library

I have a table where i have added 2 nearby locations which i calculated from google map.

Now my query is to get that nearby location with this query

I am trying to get the asins report from amazon advertising api. The header and json for creation of the report as follows,

I was reading the lazy getter example of the Lombok library, but could not figure out why the null check is applied to actualValue, as marked below:

I am trying to pull data from one to another sheet, but only specific columns, but it is not working.

I'm looking for a formula to check if a point on a dashed line of any length either falls onto a dash or gap.

My approach is to use the following formula

I just seem to be stuck with the IF’s and Importhtml/Xms etc. 
 My goal: I want a spreadsheet, where I put info like, EAN (GTIN-13), ASIN (Amazon Unique Article code). Now I want sheets to go to ebay.de & Amazon.de, take the price cheapest price from both sides - decides which price is cheaper. And subtracts 5% - this than is my finals price.

When the Article is neu or new others (Neu, Neu: Sonstige (siehe Artikelbeschreibung))

Eg. Cheapest prices: eBay 40€ - Amazon 39€ // 39€<40€= 39€-5% = 37,05€ -> if the Article does not exist on one or the other, than it will only take the number, from the existing one -5%

The system however preferably, also should see, if shipping is included and add it to the price.

Eg. Cheapest prices: eBay 40€ +5€ shipping = 45€ - Amazon 50€ // 45€<50€= 45€-5% = 42,75€

Price level: 0-100€ = -5% /// 100-1000€ = -10% //// 1000€ and more -15€

When the article is used, broken etc. (Gebraucht, Als Ersatzteil / defekt, Vom Verkäufer generalüberholt)

It only takes from ebay with the Used URL + Filter.

URLS:

eBay new: (this URL is with filter activation, for cheapest price wit shipping - Buy Now, EU Sellers, Accepting Returns & neu All these attributes are reflected in the URL. https://www.ebay.de/sch/i.html?_from=R40&_nkw=4548736101548&LH_PrefLoc=3&LH_BIN=1&LH_RPA=1&LH_ItemCondition=3&_sop=15

eBay Used https://www.ebay.de/sch/i.html?_from=R40&_nkw=4548736101548&LH_PrefLoc=3&LH_BIN=1&LH_RPA=1&_sop=15&rt=nc&LH_ItemCondition=4

EAN can be automatically added from list: New:

A friend gave me some code that creates a matrix that rotates from one vector to another vector. Very useful for pointing things at one another.

An issue that's come up is, often the matrix will do odd flips in its rotating. I.E. I'll end up with a result that's rotated correctly-- but is upside down in Z, or something like that.

Is there a way to add an up-vector to this code, to force the matrix to avoid rotating around the axis of the up-direction if possible?

Here's the code:

I wanted to read the Electronics json.gzip file from the list of available Amazon datasets: http://jmcauley.ucsd.edu/data/amazon/qa/

JSON sample:

I am making a Javascript program and on of the functions is to convert altitude/azimuth to right-ascension/declination given a time and latitude. My code can find the declination fairly accurately, I checked with Stellarium. I have been using this site to help me with the math.

My program gives me the wrong value for horizontal ascension which I plan on using to find right ascension (I already have a function to find local sidereal time which works). Here is my code for the equation
var ha = asin(-sin(az)*cos(alt) / cos(dec)) * (180 / Math.PI); this code is in Javascript but I defined custom sin/cos/asin functions that take degrees as input and return radians because that is the form my data is in.

The site I use also says that this equation should give the same result
var ha = acos((sin(alt) - sin(lat)*sin(dec)) / (cos(lat) * cos(dec))) * (180 / Math.PI);
but, the two equations give different results and neither are correct according to stellarium. I have checked that all the variables I am putting in are correct and I am almost certain I entered the equation correct. Here is the full code on github. I need help figuring out how to fix this problem.
--Note this can be run with node js with no libraries The result I get is { ra: [ 23, 57, 37.9 ], dec: [ -5, 24, 38.88 ] }
It should be getting { ra: [ 5, 36, 22.6 ], dec: [ -5, 24, 38.88 ] it does not have to be exact, I only really care about the first number of ra (right ascension). It is also formatted in HMS format. The datetime is hardcoded to Febuary 1st 2022 12:00:00 so that is what you should set stellarium to if you are testing this out.

Here is the relevant code