{"id":"019eda60-0861-742c-8edf-f028686679a3","number":1,"ts":1781780379201,"task":"I want you to write a script which takes data from a source file and pastes it into the template and save it as a new file. \n\nIn the folder is a source file \"Production Order (mrp.production).xlsx\" and a template \"A4004_v3.0-260617.ods\". The source file always varies, therefore I have included two more source files as examples [Production Order (mrp.production)(1).xlsx; Production Order (mrp.production)(2).xlsx]. \nThe script should dynamically find cells in the source file and match them to cells in the template.\n\nIn the source file, look for a cell in column \"B\" containing \"FA-\" follwed by the serialnumber suffix. for example \"2604N3\". Save the suffix into a variable. \nIn the source file look for a cell in column \"C\" containing \"AIME-\" followed by the model designation. for example \"A4004\". Save the model designation into a variable.\nnow take the model variable and append it with the the serialnumber variable.\nit should look something like this: \"A4004-2604N3\".\n\nIn the source file, look for a cell containing \"All / Components / Barebone\", copy the content in the cell to it's right and paste it into cell \"C10:D10\" in the template.\nIn the source file, look for a cell containing \"All / Components / GPU\", copy the content in the cell to it's right and paste it into cell \"C20:D23\" in the template.\nIn the source file, look for a cell containing \"All / Components / RAM\", copy the content in the cell to it's right and paste it into cell \"C12:D19\" in the template.\nIn the source file, look for a cell containing \"All / Components / CPU\", copy the content in the cell to it's right and paste it into cell \"C11:D11\" in the template.\nIn the source file, look for a cell containing \"All / Components / SSD\", copy the content in the cell to it's right and paste it into cell \"C24:D25\" in the template.\nIn the source file, look for a cell containing \"All / Components / RAID\", copy the content in the cell to it's right and paste it into cell \"C27:D27\" in the template.\nSave the template as a new file, naming it after cell \"A2\" from the source file.","tokensIn":709655,"tokensOut":8179,"cacheWrites":0,"cacheReads":0,"totalCost":0,"size":387554,"workspace":"/home/jeffry/Projects/Laufzettel","mode":"code","apiConfigName":"default"}