{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Schedule simulation"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Schedule simulation","index":0,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[[5,3,5,5],[5,8,5,9],[15,4,23,11]]}
[]
[null,null,"Spreadsheet example"]
[]
[]
[null,"Input:"]
[null,null,null,"interval",null,null,null,null,"mergeLimit"]
[null,"id","name","units","orDays","after","willReset","preserveOnOverdueReset","units2","orDays2","lastExecutedDate","lastExecutedValue"]
[null,"OIL","Oil change",20000,365,null,null,"TRUE",null,90,"2023-07-10",83500]
[null,"INT","Intermediate service ",35000,null,null,"OIL",null,null,null,"2023-10-12",63500]
[null,"ADJ","Adjustment",5000,null,"INT"]
[]
[]
[]
[]
[]
[null,"Parameter","Value",null,"INSTRUCTIONS:\nFirst save this file to your own hard drive. Then enter your own RapidAPI key in the appropriate field on the left of this cell and hit the refresh button on top of this page. You can then play around with the values as you like and see the results reflected in the table below each time that you hit the Refresh button.\n\nWARNING: \nThis spreadsheet is meant to demonstrate the simplest form of interaction with the maintenanceman.nl API. Please note that using the API in a spreadsheet is not safe for use in production environments as it does not provide sufficient measures to protect the required API key against unauthorized use, which may lead to unexprected costs. Please use with caution!"]
[null,"X-RapidAPI-Key",null," "]
[null,"Period in years",10,"years"]
[null,"period",{"$f":"ROUNDUP(C18*365.25,0)","v":3653},"days"]
[null,"unitsPerDay",25]
[null,"currentDate","2023-08-31"]
[null,"currentUnits",90000]
[null,"dateZero","2010-01-01"]
[]
[null,"Results:"]
[]
[null,"id","name","value","date","year","dueAt","dueDate"]
[null,"Invalid API key. Go to https://docs.rapidapi.com/docs/keys for more info."]