{"id":"019eda55-0355-714b-9f7e-c5cb30dc2eec","number":1,"ts":1781779480919,"task":"In the folder is a source file \"Production Order (mrp.production).xlsx\" and a template \"A4004_v3.0-260617.ods\"\n\nI want you to write a script which takes data from the source file and pastes it into the template and save it as a new file\n\nThe script should do the following:\nIn the source file, look for a cell in column \"B\" containing \"FA-\" follwed by the serialnumber suffix. for example \"2604N3\". copy the suffix and paste it into cell B1:C2 in the template.\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":0,"tokensOut":0,"totalCost":0,"size":52126,"workspace":"/home/jeffry/Projects/Laufzettel","mode":"code","apiConfigName":"default"}