Farm Planting Medicine Cost Simulator
If you have a PC, register data in bulk using spreadsheet software such as Microsoft Excel or Google Spread Sheet.
Bulk registration
Data to register
Format
Sample
1 line 1 data.
One line is the date of measurement, followed by daikon, tomato, cabbage, wheat, apple, orange, lemon, pear, dandelion, sunflower, and rose (cannot be omitted).
Measurement dates can be separated by hyphens, slashes, or periods. (YYYY/M/D, YYYY-M-D, YYYY.M.D)
Unknown parts are empty.
No header required.
(If you have the data in the correct order, you should be able to copy and paste it from your spreadsheet software.)
Resetting Results
Delete all Results of {{ targetUser.userName }}.
Please use this when you want to register data after resetting the current data.
Reset
This is a batch output of the Results data registered in {{ targetUser.userName }}.
The format is the same as bulk registration.
(Memo will not be output.)
Batch output
Batch output of data
Please use it for backing up data, sharing data, sharing to spreadsheet software, etc.
n = (Year of the specified date) + (Week of the specified date) - {{ N_BASE }}
x(n) = ROUNDDOWN(MOD(a * n + b, 901), 0) + 100
You can check the range of values for a and b above.
See the article on note.com for logic. Subtraction of {{ N_BASE }} is to reduce the number and reduce the error.
Crop name | a | b |
---|---|---|
{{ SAKUMOTSU_INFOS[sakID].long_name }} | {{ cnstPlantSeedMap[sakID].aMin?.toFixed(6) }} (+0 ~ {{ '+' + (cnstPlantSeedMap[sakID].aMax - cnstPlantSeedMap[sakID].aMin)?.toFixed(6) }} ) | {{ cnstPlantSeedMap[sakID].bMin?.toFixed(6) }} (+0 ~ {{ '+' + (cnstPlantSeedMap[sakID].bMax - cnstPlantSeedMap[sakID].bMin)?.toFixed(6) }} ) |
This is a setting for how to display base medicine cost candidates.
The initial value displays all candidates only when the number of base medicine cost is 999 or 1000, as there is a possibility of overflow.
You can also change the settings to always display all candidates.
In this case, the screen may become cluttered and visibility may decrease.
Displayed in highlight when base medicine points are high.
If the number is very large, use an orange background; if the number is slightly large, use a yellow background.
You can specify that threshold.
Please use this when changing the display order of users.
Please use this when you want to delete internal data and initialize.
You can turn on features for developers.
It is possible to check internal data.
Please turn this on only if you are interested in internal processing.
First, press the [Add] button.
Please register at least one garden base medicine point.
Please enter the value before the increase (before the correction). (A number between 100 and 1000.)
Please register at least one piece of data in Results.
All ({{ computedDisplayListStart }})
Period |
{{ SAKUMOTSU_INFOS[sakID].name }}
|
---|---|
{{ listItem.displayPredictDate + " ~" }} |
{{ posVal.num ?? " " }}
{{ posVal.num ?? " " }}
|
{{ SAKUMOTSU_TYPE_INFOS[typeID].name }} ({{ computedDisplayListStart }})
Period | {{ SAKUMOTSU_INFOS[sakID].name }} |
---|---|
{{ listItem.displayPredictDate + " ~" }} |
{{ posVal.num }}
{{ posVal.num }}
|
You can customize the following items to specify the start and time period for your table.
予測 (見込み)のテーブルをクリックした行の履歴を表示します。
菜園を更新した日や、更新する予定の日などのメモとしてお使いください。
日程 | メモ | 操作 |
---|---|---|
{{ clicedRow.clickDate }} |
削除
|
You can write notes about the base medicine point in your garden.
-
Please enter one or more base medicine point in Results.
If you don't enter any data, you can't make predictions.
Please enter the initial value (value before increase) for the base medicine points. It should be between 100 and 1000. -
Prediction shows the expected base medicine points.
Base medicine points will be switched at 00:00 Japan time.
The change generally occurs on a Friday, but may also occur on January 1st at the beginning of the new year.
The maximum error is 2. -
The type of crop (field, tree, flower) displayed in Prediction can be changed by selecting the Display target.
By default, only fields are displayed. -
You can click on a row in the Prediction table to highlight that period.
Click again to cancel. Multiple rows can be selected, and the information is retained even after rebooting.
Please use this to make notes about when to update your farm. - By switching users, you can store information for up to four accounts.
-
Please note that the numbers may change at the beginning of the year (1/1).
For example, in 2025 there will be no 1/1 update, but instead it will be shifted to 1/3 (Fri).
We plan to make appropriate corrections.
Even if there are no updates at the beginning of the year, the numbers will just be off by one week and there will be no major updates.
- Prediction basically shows the minimum value in the calculation. Therefore, it is often displayed as 1 less than the actual result, but this is the expected behavior.
- Prediction are shown in bold when actual figures are available. In this case, the actual value is used as is, so no error occurs.
- The more data you register, the more accurate Prediction will be.
- If Prediction value is either 999 or 1000, there is a chance that it could fall to the minimum value of 100 due to margin of error.
-
Specifying a large number for the List duration (days) will significantly slow down the processing speed.
Please make the numbers as realistic as possible.
The maximum value for the List duration (days) is 50,000. -
Abnormal values will be skipped over in Results. If they are skipped over, [???] will be displayed at the end.
If you see this symbol, please check for typos.
(It will skip over any input errors, so it will work fine if there is enough data.) - Time zone processing may not work properly if you are using an extension.
-
Data created on other devices can be commonly edited by using the same account.
To log in, please go to Login. - The details of the logic are described in note, so please refer to here.