mootw / steam-deck-calculator Goto Github PK

Fammy is tracking latest reservetimes that received an order mail for all regions and devices.
If this was used for the database it could result in more accurate predictions.

https://docs.google.com/spreadsheets/d/1ZaKncig9fce7K0sr1f-E2_sgLH1HuKQ-q3k7clPMOCs/edit#gid=0

Some users in the database have the order date the same as the reservation date. Make sure to ignore these ones.

The owner of the Google Sheet can use Google Apps Script to create a pseudo-API which can be used on the page so that people don't need to manually export as CSV then import to get the latest data from the sheet.

I created a simple example with the following Apps Script code:

function doGet(e) {
  const sheet = SpreadsheetApp.openById("1QqlSUpqhyBCBYeu_gW4w5vIxfcd7qablSviALDFJ0Dg").getSheetByName("Form Responses 1")
  const data = sheet.getSheetValues(1, 1, sheet.getLastRow(), 7)

  return ContentService.createTextOutput(JSON.stringify(data)).setMimeType(ContentService.MimeType.JSON)
}

Then I deployed it as a web API at this URL: https://script.google.com/macros/s/AKfycbzKT0Erw0y8QRwbVch4KEkjxV8m31d8qlmmlFH-E1QrTODMIYExkeVUKcpZ37CesO9P1Q/exec

It would require some tweaking to play nice with CORS and stuff, but it's definitely feasible. I unfortunately don't have the time to look into actually implementing this, but I hope this can help as a jumping-off point.

(Also, as an aside, Google Apps Script is very nice for hosting random one-off utilities for free)

Can the question be updated to specify the required date format or use a date selector?
I'm getting this error when I try to confirm my order email date

Hello,

Any chance you can turn on public branch creation so we can raise pull requests and contribute ?

The calculator needs to be updated as order emails now also go out on Thursdays as of April 7th.

The first reports showing reservation dates of Q3/After Q3 are in, but the website does not support these dates yet.

Another screenshot here (r/SteamDeck)
Date is visible on the store page while logged out.

The calculator predicted I would get it in the first batch of Q1 but I didn't and now putting my information in shows negative numbers back to last monday for the moo dataset as well as the latest CSV.

rtReserveTime: 1626455515
Model: 512 GB
Region: US (actually Canada but that's probably counted as US)
Original Valve Prediction Before Delay: Q1
Updated Valve Prediction After Delay: Q2

There are users with an earlier timestamp, same region and same model that have later dates than certain others.

Is this a data entry error or are there subregions other than EU, UK, US?

Hey there,

unfortunately some users didn't seem to correctly answer all the survey questions. E.g.
is pretty in the future. But nevertheless - should be an easy fix: just ignore timestamps from the future :)

Regards

I have a 64GB Q1 US order with rtReserveTime: 1626456117. moo's model predicts April 11, which would be the second batch of Q2 emails. I could see the model predicting the first batch of Q2 emails (though it should probably be rounded to March 28), but this is far enough outside of Valve's timeline that I feel like there might be a bug.

I have a US 512GB reservation, and my rtReserveTime is 1626458789. This is a little over 1 hour since the pre-orders went live.

If I use the calculator, and opt to upload the "latest data" CSV as instructed, the calculator will tell me my reservation was available on May 23rd, 2022, which is impossible (there are at least 20 minutes left in the queue before my reservation),

This may not be a real "issue", but more or less I had a question regarding accuracy and how previous uploads by users may be stored in order to make calculation "easier".

Are uploads made by a user or the same user stored? For example, if I upload a copy of the preorder information on one day, is that kept on a file-server or something similar to that for historical purposes? Similarly, if I upload something another day, is the data previously uploaded overwritten?

My main concern is that anything uploaded might be stored and could lead to a large influx of stored data possibly consuming server resources (if thats how this is configured). I also see that cookies are stored, so maybe thats the only data that is personally related to a user.

If these concerns are better suited elsewhere feel free to let me know. I apologize if this may seem like a dumb question, but it was something I thought about when using this tool recently.