{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["ClientList","InvoiceList","ManualInvoice","AutoInvoice","SendEmails","FetchEmails","Admin"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":10,"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":"ClientList","index":0,"n_rows":17,"n_cols":46,"rows_kept":17,"cut":false,"hidden":true,"merged":[[3,2,3,4]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"IF(Admin!$B$12=\"NO\",\"\",IF(Admin!$B$4=\"MONTH\",IF(MONTH(NOW())<>MONTH(Admin!$B$6),\"This is a free version. Contact Exceldepartment for unlocking full potential of the model.\",\"\"),\nIF(Admin!$B$4=\"QRT\",IF(INT((MONTH(NOW())+2)/3)<>INT((MONTH(Admin!$B$6)+2)/3),\"This is a free version. Contact Exceldepartment for unlocking full potential of the model.\",\"\"),\nIF(Admin!$B$4=\"YEAR\",IF(YEAR(NOW())<>YEAR(Admin!$B$6),\"This is a free version. Contact Exceldepartment for unlocking full potential of the model.\",\"\"),\n\"This is a free version. Contact Exceldepartment for unlocking full potential of the model.\"))))","v":"This is a free version. Contact Exceldepartment for unlocking full potential of the model."}]
[null,null,{"$f":"IFERROR(IF($B9=\"\",\"\",IF(INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(C$10,#REF!,0))=0,\"\",INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(C$10,#REF!,0)))),\"\")","v":""},null,{"$f":"IFERROR(IF($B9=\"\",\"\",IF(INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(G$10,#REF!,0))=0,\"\",INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(G$10,#REF!,0)))),\"\")","v":""},null,{"$f":"IFERROR(IF($B9=\"\",\"\",IF(INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(E$10,#REF!,0))=0,\"\",INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(E$10,#REF!,0)))),\"\")","v":""},null,null,{"$f":"IFERROR(IF($B9=\"\",\"\",IF(INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(I$10,#REF!,0))=0,\"\",INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(I$10,#REF!,0)))),\"\")","v":""},{"$f":"IFERROR(IF($B9=\"\",\"\",IF(INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(J$10,#REF!,0))=0,\"\",INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(J$10,#REF!,0)))),\"\")","v":""},{"$f":"IFERROR(IF($B9=\"\",\"\",IF(INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(K$10,#REF!,0))=0,\"\",INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(K$10,#REF!,0)))),\"\")","v":""},{"$f":"IFERROR(IF($B9=\"\",\"\",IF(INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(L$10,#REF!,0))=0,\"\",INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(L$10,#REF!,0)))),\"\")","v":""},{"$f":"IFERROR(IF($B9=\"\",\"\",IF(INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(M$10,#REF!,0))=0,\"\",INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(M$10,#REF!,0)))),\"\")","v":""},{"$f":"IFERROR(IF($B9=\"\",\"\",IF(INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(N$10,#REF!,0))=0,\"\",INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(N$10,#REF!,0)))),\"\")","v":""},{"$f":"IFERROR(IF($B9=\"\",\"\",IF(INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(O$10,#REF!,0))=0,\"\",INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(O$10,#REF!,0)))),\"\")","v":""},{"$f":"IFERROR(IF($B9=\"\",\"\",IF(INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(P$10,#REF!,0))=0,\"\",INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(P$10,#REF!,0)))),\"\")","v":""},{"$f":"IFERROR(IF($B9=\"\",\"\",IF(INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(Q$10,#REF!,0))=0,\"\",INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(Q$10,#REF!,0)))),\"\")","v":""},{"$f":"IFERROR(IF($B9=\"\",\"\",IF(INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(R$10,#REF!,0))=0,\"\",INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(R$10,#REF!,0)))),\"\")","v":""},{"$f":"IFERROR(IF($B9=\"\",\"\",IF(INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(S$10,#REF!,0))=0,\"\",INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(S$10,#REF!,0)))),\"\")","v":""},{"$f":"IFERROR(IF($B9=\"\",\"\",IF(INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(T$10,#REF!,0))=0,\"\",INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(T$10,#REF!,0)))),\"\")","v":""},{"$f":"IFERROR(IF($B9=\"\",\"\",IF(INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(U$10,#REF!,0))=0,\"\",INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(U$10,#REF!,0)))),\"\")","v":""},{"$f":"IFERROR(IF($B9=\"\",\"\",IF(INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(V$10,#REF!,0))=0,\"\",INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(V$10,#REF!,0)))),\"\")","v":""},{"$f":"IFERROR(IF($B9=\"\",\"\",IF(INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(W$10,#REF!,0))=0,\"\",INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(W$10,#REF!,0)))),\"\")","v":""},{"$f":"IFERROR(IF($B9=\"\",\"\",IF(INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(X$10,#REF!,0))=0,\"\",INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(X$10,#REF!,0)))),\"\")","v":""},{"$f":"IFERROR(IF($B9=\"\",\"\",IF(INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(Y$10,#REF!,0))=0,\"\",INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(Y$10,#REF!,0)))),\"\")","v":""},{"$f":"IFERROR(IF($B9=\"\",\"\",IF(INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(Z$10,#REF!,0))=0,\"\",INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(Z$10,#REF!,0)))),\"\")","v":""},{"$f":"IFERROR(IF($B9=\"\",\"\",IF(INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(AA$10,#REF!,0))=0,\"\",INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(AA$10,#REF!,0)))),\"\")","v":""},{"$f":"IFERROR(IF($B9=\"\",\"\",IF(INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(AB$10,#REF!,0))=0,\"\",INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(AB$10,#REF!,0)))),\"\")","v":""},{"$f":"IFERROR(IF($B9=\"\",\"\",IF(INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(AC$10,#REF!,0))=0,\"\",INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(AC$10,#REF!,0)))),\"\")","v":""},{"$f":"IFERROR(IF($B9=\"\",\"\",IF(INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(AD$10,#REF!,0))=0,\"\",INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(AD$10,#REF!,0)))),\"\")","v":""},{"$f":"IFERROR(IF($B9=\"\",\"\",IF(INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(AE$10,#REF!,0))=0,\"\",INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(AE$10,#REF!,0)))),\"\")","v":""},{"$f":"IFERROR(IF($B9=\"\",\"\",IF(INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(AF$10,#REF!,0))=0,\"\",INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(AF$10,#REF!,0)))),\"\")","v":""},{"$f":"IFERROR(IF($B9=\"\",\"\",IF(INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(AG$10,#REF!,0))=0,\"\",INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(AG$10,#REF!,0)))),\"\")","v":""},{"$f":"IFERROR(IF($B9=\"\",\"\",IF(INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(AH$10,#REF!,0))=0,\"\",INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(AH$10,#REF!,0)))),\"\")","v":""},{"$f":"IFERROR(IF($B9=\"\",\"\",IF(INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(AI$10,#REF!,0))=0,\"\",INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(AI$10,#REF!,0)))),\"\")","v":""},{"$f":"IFERROR(IF($B9=\"\",\"\",IF(INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(AJ$10,#REF!,0))=0,\"\",INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(AJ$10,#REF!,0)))),\"\")","v":""},{"$f":"IFERROR(IF($B9=\"\",\"\",IF(INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(AK$10,#REF!,0))=0,\"\",INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(AK$10,#REF!,0)))),\"\")","v":""},{"$f":"IFERROR(IF($B9=\"\",\"\",IF(INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(AL$10,#REF!,0))=0,\"\",INDEX(#REF!,MATCH($B9,#REF!,0),MATCH(AL$10,#REF!,0)))),\"\")","v":""},null,null,{"$f":"IFERROR(RIGHT(H9,LEN(H9)-FIND(\"@\",H9)),\"\")","v":""}]
[null,"Client","Company","Project","Company Address","InoviceRef","Contact Role in Company","InvoiceEmail","Company City","Company Business","Company Comment","Company Data 1","Company Data 2","Company Data 3","_Email","Contact Phone","Contact Address","Postal Code","Lead Source","Lead Status","Emotional","Business","Party","Technology","FirstContact","LastContact","Affärsstatus","Project 1","Project Date 1","Project Date 2","Budget % 1","Budget % 2","Budget Value 1","Budget Value 2","Budget Value 3","Comment","Action","Email Text","Attachement","InvoiceAdress","InvoiceRef","_emailEnding","GLN","Role","Phone Nr.","Peppol ID"]
[null,"Company 1","Company AB 1","Project 1","Random Address 1, 111 11 City","Anders Gustavsson","CFO","info@exceldepartment.com","City","Finance","","","","","info@exceldepartment.com","","","111 11","","","","","","","","","","","","","","","","","","","","","","Random Address 1, 111 11 City","Anders Gustavsson",{"$f":"IFERROR(RIGHT(H11,LEN(H11)-FIND(\"@\",H11)),\"\")","v":"exceldepartment.com"}]
[null,"Company 2","Company AB 2","Project 2","Random Address 2, 111 11 City","Niklas Gustavsson","CTO","info@exceldepartment.com","City","Finance","","","","","info@exceldepartment.com","","","111 11","","","","","","","","","","","","","","","","","","","","","","Random Address 2, 111 11 City","Niklas Gustavsson","exceldepartment.com"]
[null,"Company 3","Company AB 3","Project 3","Random Address 3, 111 11 City","Lukas Gustavsson","CEO","info@exceldepartment.com","City","Finance","","","","","info@exceldepartment.com","","","111 11","","","","","","","","","","","","","","","","","","","","","","Random Address 3, 111 11 City","Lukas Gustavsson","exceldepartment.com"]
[null,"Company 1","Company AB 1","Project 4","Random Address 1, 111 11 City","Erik Gustavsson","CEO","info@exceldepartment.com","City","Finance","","","","","info@exceldepartment.com","","","111 11","","","","","","","","","","","","","","","","","","","","","","Random Address 1, 111 11 City","Erik Gustavsson","exceldepartment.com"]
[null,"Company 5","Company AB 5","Project 5","Random Address 5, 111 11 City","Pontus Gustavsson","CTO","info@exceldepartment.com","City","Finance","","","","","info@exceldepartment.com","","","111 11","","","","","","","","","","","","","","","","","","","","","","Random Address 5, 111 11 City","Pontus Gustavsson","exceldepartment.com"]
[null,"Company 2","Company AB 2","Project 6","Random Address 2, 111 11 City","Goran Gustavsson","CEO","info@exceldepartment.com","City","Finance",null,null,null,null,"info@exceldepartment.com",null,null,"111 11",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Random Address 2, 111 11 City","Goran Gustavsson","exceldepartment.com"]
[null,null,null,"Project 7"]

{"sheet":"InvoiceList","index":1,"n_rows":17,"n_cols":43,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[2023,"Project","Company","Company Address","InoviceRef","_Status","InvoiceNr","Faktura Nr.","_responsible","_KommentarFaktura","InvoiceDate","InvoiceEmail","_CC","_EmailSubject","_EmailBody","_FakturaTotal","Titel 1","Class 1","Timmar 1","Timtaxa 1","Timtaxa Total 1","Titel 2","Class 2","Timmar 2","Timtaxa 2","Timtaxa Total 2","Titel 3","Class 3","Timmar 3","Timtaxa 3","Timtaxa Total 3","Titel 4","Class 4","Timmar 4","Timtaxa 4","Timtaxa Total 4","Titel 5","Class 5","Timmar 5","Timtaxa 5","Timtaxa Total 5","PaymentTerms","DueDate"]
[null,null,null,null,null,"2_Generate"]
[null,null,null,null,null,"3_GetDetails"]
[null,{"$f":"IF(Admin!$B$12=\"NO\",\"\",IF(Admin!$B$4=\"MONTH\",IF(MONTH(NOW())<>MONTH(Admin!$B$6),\"This is a free version. Contact Exceldepartment for unlocking full potential of the model.\",\"\"),\nIF(Admin!$B$4=\"QRT\",IF(INT((MONTH(NOW())+2)/3)<>INT((MONTH(Admin!$B$6)+2)/3),\"This is a free version. Contact Exceldepartment for unlocking full potential of the model.\",\"\"),\nIF(Admin!$B$4=\"YEAR\",IF(YEAR(NOW())<>YEAR(Admin!$B$6),\"This is a free version. Contact Exceldepartment for unlocking full potential of the model.\",\"\"),\n\"This is a free version. Contact Exceldepartment for unlocking full potential of the model.\"))))","v":"This is a free version. Contact Exceldepartment for unlocking full potential of the model."}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30]
[null,null,null,null,null,"2_Generate",{"$f":"IF(ROW()=9,0,MAX($G$1:G8)+1)","v":0},{"$f":"IF(G9=\"\",\"\",\"Faktura \" & G9)","v":"Faktura 0"},null,null,{"$f":"IF(F9=\"To Send\",TODAY(),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(SUMIFS(K9:BBN9,K$10:BBN$10,\"Timtaxa Total*\"),0)","v":0},{"$f":"\"Senior Konsult\"","v":"Senior Konsult"},null,null,{"$f":"1350","v":1350},{"$f":"IFERROR(S9*T9,\"\")","v":0},null,null,null,null,{"$f":"IFERROR(X9*Y9,\"\")","v":0},null,null,null,null,{"$f":"IFERROR(AC9*AD9,\"\")","v":0},null,null,null,null,{"$f":"IFERROR(AH9*AI9,\"\")","v":0},null,null,null,null,{"$f":"IFERROR(AM9*AN9,\"\")","v":0},null,{"$f":"IFERROR(K9+IF(AP9=\"\",30,AP9),AQ8)","v":"00:00:00"}]
[null,"Project","Company","Company Address","InoviceRef","_Status","InvoiceNr","Faktura Nr.","_responsible","_KommentarFaktura","InvoiceDate","InvoiceEmail","_CC","_EmailSubject","_EmailBody","_FakturaTotal","Titel 1","Class 1","Timmar 1","Timtaxa 1","Timtaxa Total 1","Titel 2","Class 2","Timmar 2","Timtaxa 2","Timtaxa Total 2","Titel 3","Class 3","Timmar 3","Timtaxa 3","Timtaxa Total 3","Titel 4","Class 4","Timmar 4","Timtaxa 4","Timtaxa Total 4","Titel 5","Class 5","Timmar 5","Timtaxa 5","Timtaxa Total 5","PaymentTerms","DueDate"]
[null,"Project 1","Company AB 1","Random Address 1, 111 11 City","Anders Gustavsson","2_Generate",{"$f":"MAX($G$1:G10)+1","v":1},{"$f":"\"Faktura \" &G11","v":"Faktura 1"},null,null,"2020-08-07","info@exceldepartment.com",null,"Faktura Augusti","Hallå!\n\nHär kommer fakturan för det vi gjort nu under augusti.\n\nLukas Lilja - Excel Evangelist - 46 706 63 83 06",{"$f":"IFERROR(SUMIFS(K11:BBN11,K$10:BBN$10,\"Timtaxa Total*\"),0)","v":7375},{"$f":"\"Senior Konsult\"","v":"Senior Konsult"},null,5,1350,{"$f":"IFERROR(S11*T11,\"\")","v":6750},"Rabbaterad timmar",null,1,625,{"$f":"IFERROR(X11*Y11,\"\")","v":625},null,null,null,null,{"$f":"IFERROR(AC11*AD11,\"\")","v":0},null,null,null,null,{"$f":"IFERROR(AH11*AI11,\"\")","v":0},null,null,null,null,{"$f":"IFERROR(AM11*AN11,\"\")","v":0},30,{"$f":"IFERROR(K11+IF(AP11=\"\",$AP$8,AP11),AQ10)","v":"2020-09-06"}]
[null,"Project 2","Company AB 2","Random Address 2, 111 11 City","Niklas Gustavsson","2_Generate",{"$f":"MAX($G$1:G11)+1","v":2},{"$f":"\"Faktura \" &G12","v":"Faktura 2"},null,null,"2020-08-07","info@exceldepartment.com",null,"Kreditfaktura Augusti","Hallå!\n\nDen tidigare fakturan gick iväg utan fakturadatum, detta är motsvarande kreditfaktura som annulerar den.\nLukas Lilja - Excel Evangelist - 46 706 63 83 06",5300,"Senior Konsult",null,3,1350,4050,"Rabbaterad timmar",null,2,625,1250,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,60,{"$f":"IFERROR(K12+IF(AP12=\"\",30,AP12),AQ11)","v":"2020-10-06"}]
[null,"Project 3","Company AB 3","Random Address 3, 111 11 City","Lukas Gustavsson","2_Generate",{"$f":"MAX($G$1:G12)+1","v":3},"Faktura 3",null,null,"2020-08-07","info@exceldepartment.com",null,"Kreditfaktura Augusti","Hallå!\n\nDen tidigare fakturan gick iväg utan fakturadatum, detta är motsvarande kreditfaktura som annulerar den.\nLukas Lilja - Excel Evangelist - 46 706 63 83 06",2700,"Senior Konsult",null,2,1350,2700,"Rabbaterad timmar",null,0,625,0,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,60,"2020-10-06"]
[null,"Project 4","Company AB 1","Random Address 1, 111 11 City","Erik Gustavsson","1_Sent",{"$f":"MAX($G$1:G13)+1","v":4},"Faktura 4",null,null,"2020-08-07","info@exceldepartment.com",null,"Kreditfaktura Augusti","Hallå!\n\nDen tidigare fakturan gick iväg utan fakturadatum, detta är motsvarande kreditfaktura som annulerar den.\nLukas Lilja - Excel Evangelist - 46 706 63 83 06",7375,"Senior Konsult",null,5,1350,6750,"Rabbaterad timmar",null,1,625,625,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,90,"2020-11-05"]
[null,"Project 5","Company AB 5","Random Address 5, 111 11 City","Pontus Gustavsson","1_Sent",{"$f":"MAX($G$1:G14)+1","v":5},"Faktura 5",null,null,"2020-08-07","info@exceldepartment.com",null,"Kreditfaktura Augusti","Hallå!\n\nDen tidigare fakturan gick iväg utan fakturadatum, detta är motsvarande kreditfaktura som annulerar den.\nLukas Lilja - Excel Evangelist - 46 706 63 83 06",14750,"Senior Konsult",null,10,1350,13500,"Rabbaterad timmar",null,2,625,1250,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,30,"2020-09-06"]
[null,"Project 6","Company AB 2","Random Address 2, 111 11 City","Goran Gustavsson","1_Sent",{"$f":"MAX($G$1:G15)+1","v":6},"Faktura 6",null,null,"2020-08-07","info@exceldepartment.com",null,"Kreditfaktura Augusti","Hallå!\n\nDen tidigare fakturan gick iväg utan fakturadatum, detta är motsvarande kreditfaktura som annulerar den.\nLukas Lilja - Excel Evangelist - 46 706 63 83 06",1975,"Senior Konsult",null,1,1350,1350,"Rabbaterad timmar",null,1,625,625,null,null,null,null,0,null,null,null,null,0,null,null,null,null,0,30,"2020-09-06"]
[null,"Project 7",null,null,null,"31_AwaitingDetails",{"$f":"IF(ROW()=9,0,MAX($G$1:G16)+1)","v":7},{"$f":"IF(G17=\"\",\"\",\"Faktura \" & G17)","v":"Faktura 7"},null,null,{"$f":"IF(F17=\"To Send\",TODAY(),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(SUMIFS(K17:BBN17,K$10:BBN$10,\"Timtaxa Total*\"),0)","v":0},{"$f":"\"Senior Konsult\"","v":"Senior Konsult"},null,null,{"$f":"1350","v":1350},{"$f":"IFERROR(S17*T17,\"\")","v":0},null,null,null,null,{"$f":"IFERROR(X17*Y17,\"\")","v":0},null,null,null,null,{"$f":"IFERROR(AC17*AD17,\"\")","v":0},null,null,null,null,{"$f":"IFERROR(AH17*AI17,\"\")","v":0},null,null,null,null,{"$f":"IFERROR(AM17*AN17,\"\")","v":0},null,{"$f":"IFERROR(K17+IF(AP17=\"\",30,AP17),AQ16)","v":"2020-09-06"}]

{"sheet":"ManualInvoice","index":2,"n_rows":51,"n_cols":10,"rows_kept":51,"cut":false,"hidden":false,"merged":[[0,0,0,2],[5,6,7,8],[11,1,13,5],[17,0,18,2],[17,3,18,3],[17,4,18,4],[17,5,18,5],[17,6,18,6],[17,7,18,7],[17,8,18,8],[1,0,2,5],[41,0,41,2],[36,0,36,2],[25,0,25,2],[26,0,26,2],[27,0,27,2],[28,0,28,2],[29,0,29,2],[30,0,30,2],[31,0,31,2],[32,0,32,2],[33,0,33,2],[34,0,34,2],[35,0,35,2],[37,0,37,2],[38,0,38,2],[39,0,39,2],[40,0,40,2],[24,0,24,2],[19,0,19,2],[20,0,20,2],[21,0,21,2],[22,0,22,2],[23,0,23,2]]}
["Company AB",null,null,null,null,null,"Faktura"]
[{"$f":"IF(Admin!$B$12=\"NO\",\"\",IF(Admin!$B$4=\"MONTH\",IF(MONTH(NOW())<>MONTH(Admin!$B$6),\"This is a free version. Contact Exceldepartment for unlocking full potential of the model.\",\"\"),\nIF(Admin!$B$4=\"QRT\",IF(INT((MONTH(NOW())+2)/3)<>INT((MONTH(Admin!$B$6)+2)/3),\"This is a free version. Contact Exceldepartment for unlocking full potential of the model.\",\"\"),\nIF(Admin!$B$4=\"YEAR\",IF(YEAR(NOW())<>YEAR(Admin!$B$6),\"This is a free version. Contact Exceldepartment for unlocking full potential of the model.\",\"\"),\n\"This is a free version. Contact Exceldepartment for unlocking full potential of the model.\"))))","v":"This is a free version. Contact Exceldepartment for unlocking full potential of the model."},null,null,null,null,null,"Fakturanummer",null,"Fakturadatum"]
[null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2023-10-24"}]
[]
[null,null,null,null,null,null,"Mottagare"]
[]
[]
[]
[]
[]
[]
["Er referens",null,null,null,null,null,"Vår referens",{"$f":"G3","v":0}]
[null,null,null,null,null,null,"Betalningsvillkor",null,{"$f":"H13 & \" dagar\"","v":" dagar"}]
[null,null,null,null,null,null,"Förfallodatum",{"$f":"IFERROR(I3+H13*1,\"\")","v":"2023-10-24"}]
[]
[]
[]
["Beskrivning",null,null,"Antal","á pris","Belopp \nex moms","Moms","Moms kr","Belopp"]
[]
[null,null,null,null,null,{"$f":"IF(A20=\"\",\"\",IFERROR(D20*E20,\"\"))","v":""},{"$f":"IF(A20=\"\",\"\",IF(OR(F20=0,A20=\"\",F20=\"\"),\"\",0.25))","v":""},{"$f":"IF(A20=\"\",\"\",IFERROR(E20*G20*D20,\"\"))","v":""},{"$f":"IF(A20=\"\",\"\",IFERROR(IF(ISERROR(D20*E20),\"\",IF(D20*E20+H20=0,\"\",D20*E20)),\"\"))","v":""},1]
[null,null,null,null,null,{"$f":"IF(A21=\"\",\"\",IFERROR(D21*E21,\"\"))","v":""},{"$f":"IF(A21=\"\",\"\",IF(OR(F21=0,A21=\"\",F21=\"\"),\"\",0.25))","v":""},{"$f":"IF(A21=\"\",\"\",IFERROR(E21*G21*D21,\"\"))","v":""},{"$f":"IF(A21=\"\",\"\",IFERROR(IF(ISERROR(D21*E21),\"\",IF(D21*E21+H21=0,\"\",D21*E21)),\"\"))","v":""},2]
[null,null,null,null,null,"","","","",3]
[null,null,null,null,null,"","","","",4]
[null,null,null,null,null,"","","","",5]
[null,null,null,null,null,"","","","",6]
[null,null,null,null,null,"","","","",7]
[null,null,null,null,null,"","","","",8]
[null,null,null,null,null,"","","","",9]
[null,null,null,null,null,"","","","",10]
[null,null,null,null,null,"","","",""]
[null,null,null,null,null,"","","",""]
[null,null,null,null,null,"","","",""]
[null,null,null,null,null,"","","",""]
[null,null,null,null,null,"","","",""]
[null,null,null,null,null,"","","",""]
[null,null,null,null,null,"","","","",11]
[null,null,null,null,null,"","","","",12]
[null,null,null,null,null,"","","","",13]
[null,null,null,null,null,"","","","",14]
[null,null,null,null,null,"","","","",15]
[null,null,null,null,null,"","","","",16]
[null,null,null,null,null,"","","","",17]
[null,null,null,null,null,null,"Belopp före moms",null,{"$f":"SUM(I20:I42)","v":0}]
[null,null,null,null,null,null,"Total moms",null,{"$f":"SUM(H20:H42)","v":0}]
[null,null,null,null,null,null,"Öresavrundning",null,{"$f":"ROUND(SUM(I43:I44),0)-SUM(I43:I44)","v":0}]
[null,null,null,null,null,null,"Att Betala",null,{"$f":"SUM(I43:I45)","v":0}]
["Adress",null,"Telefonnummer",null,null,null,"BankGiro",null,"Organisationsnr"]
[]
[null,null,"Epost",null,null,null,"BIC",null,"Momsreg.nr"]
[]
[null,null,"Bolaget innehar F-skattesedel",null,null,null,"IBAN"]

{"sheet":"AutoInvoice","index":3,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":true,"merged":[[33,4,33,8],[28,4,28,8],[29,4,29,8],[30,4,30,8],[31,4,31,8],[32,4,32,8],[0,0,0,2],[11,1,13,5],[17,0,18,2],[17,3,18,3],[17,4,18,4],[17,5,18,5],[17,6,18,6],[17,7,18,7],[17,8,18,8],[5,6,9,8],[19,0,19,2],[20,0,20,2],[21,0,21,2],[22,0,22,2],[23,0,23,2],[47,0,47,1],[41,0,41,2]]}
[{"$f":"IF(ManualInvoice!A1=\"\",\"Saknas\",ManualInvoice!A1)","v":"Company AB"},null,null,null,null,null,"Faktura"]
[null,null,null,null,null,null,"Fakturanummer",null,"Fakturadatum"]
[null,null,null,null,null,null,"Faktura 5",null,{"$f":"IFERROR(INDEX(InvoiceList!$A$11:$CG$16,MATCH(G3,InvoiceList!$H$11:$H$16,0),MATCH(\"InvoiceDate\",InvoiceList!10:10,0)),\"Fakturadatum saknas\")","v":"2020-08-07"}]
[]
[null,null,null,null,null,null,"Mottagare"]
[null,null,null,null,null,null,{"$f":"IF(INDEX(InvoiceList!$A$11:$CG$16,MATCH(G3,InvoiceList!$H$11:$H$16,0),MATCH(\"Company\",InvoiceList!10:10,0))=\"\",\"\",INDEX(InvoiceList!$A$11:$CG$16,MATCH(G3,InvoiceList!$H$11:$H$16,0),MATCH(\"Company\",InvoiceList!10:10,0)))&CHAR(10)&IF(INDEX(InvoiceList!$A$11:$CG$16,MATCH(G3,InvoiceList!$H$11:$H$16,0),MATCH(\"Company Address\",InvoiceList!10:10,0))=\"\",\"\",INDEX(InvoiceList!$A$11:$CG$16,MATCH(G3,InvoiceList!$H$11:$H$16,0),MATCH(\"Company Address\",InvoiceList!10:10,0)))","v":"Company AB 5\nRandom Address 5, 111 11 City"}]
[]
[]
[]
[]
[]
["Er referens",{"$f":"IF(INDEX(InvoiceList!$A$11:$CG$16,MATCH(G3,InvoiceList!$H$11:$H$16,0),MATCH(\"InoviceRef\",InvoiceList!10:10,0))=\"\",\"\",INDEX(InvoiceList!$A$11:$CG$16,MATCH(G3,InvoiceList!$H$11:$H$16,0),MATCH(\"InoviceRef\",InvoiceList!10:10,0)))","v":"Pontus Gustavsson"},null,null,null,null,"Vår referens",{"$f":"G3","v":"Faktura 5"}]
[null,null,null,null,null,null,"Betalningsvillkor",{"$f":"IF(INDEX(InvoiceList!$A$11:$CG$16,MATCH(G3,InvoiceList!$H$11:$H$16,0),MATCH(\"PaymentTerms\",InvoiceList!10:10,0))=\"\",30,INDEX(InvoiceList!$A$11:$CG$16,MATCH(G3,InvoiceList!$H$11:$H$16,0),MATCH(\"PaymentTerms\",InvoiceList!10:10,0)))&\" dagar\"","v":"30 dagar"}]
[null,null,null,null,null,null,"Förfallodatum",{"$f":"IFERROR(I3+LEFT(H13,SEARCH(\" \",H13)-1),\"\")","v":"2020-09-06"}]
[]
[]
[{"$f":"IF(Admin!$B$12=\"NO\",\"\",IF(Admin!$B$4=\"MONTH\",IF(MONTH(NOW())<>MONTH(Admin!$B$6),\"This is a free version. Contact Exceldepartment for unlocking full potential of the model.\",\"\"),\nIF(Admin!$B$4=\"QRT\",IF(INT((MONTH(NOW())+2)/3)<>INT((MONTH(Admin!$B$6)+2)/3),\"This is a free version. Contact Exceldepartment for unlocking full potential of the model.\",\"\"),\nIF(Admin!$B$4=\"YEAR\",IF(YEAR(NOW())<>YEAR(Admin!$B$6),\"This is a free version. Contact Exceldepartment for unlocking full potential of the model.\",\"\"),\n\"This is a free version. Contact Exceldepartment for unlocking full potential of the model.\"))))","v":"This is a free version. Contact Exceldepartment for unlocking full potential of the model."}]
["Beskrivning",null,null,"Antal","á pris","Belopp \nex moms","Moms","Moms kr","Belopp"]
[]
[{"$f":"IFERROR(IF(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Titel \"&AutoInvoice!J20,InvoiceList!$A$10:$CK$10,0))=0,\"\",INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Titel \"&AutoInvoice!J20,InvoiceList!$A$10:$CK$10,0)))&\nIF(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Class \"&AutoInvoice!J20,InvoiceList!$A$10:$CK$10,0))=0,\"\",CHAR(10)&INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Class \"&AutoInvoice!J20,InvoiceList!$A$10:$CK$10,0))),\"\")","v":"Senior Konsult"},null,null,{"$f":"IF(A20=\"\",\"\",IFERROR(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Timmar \"&AutoInvoice!J20,InvoiceList!$10:$10,0)),\"\"))","v":10},{"$f":"IF(A20=\"\",\"\",IFERROR(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Timtaxa \"&AutoInvoice!J20,InvoiceList!$10:$10,0)),\"\"))","v":1350},{"$f":"IF(A20=\"\",\"\",IFERROR(D20*E20,\"\"))","v":13500},{"$f":"IF(A20=\"\",\"\",IF(OR(F20=0,A20=\"\",F20=\"\"),\"\",0.25))","v":0.25},{"$f":"IF(A20=\"\",\"\",IFERROR(E20*G20*D20,\"\"))","v":3375},{"$f":"IF(A20=\"\",\"\",IFERROR(IF(ISERROR(D20*E20),\"\",IF(D20*E20+H20=0,\"\",D20*E20)),\"\"))","v":13500},1]
[{"$f":"IFERROR(IF(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Titel \"&AutoInvoice!J21,InvoiceList!$A$10:$CK$10,0))=0,\"\",INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Titel \"&AutoInvoice!J21,InvoiceList!$A$10:$CK$10,0)))&\nIF(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Class \"&AutoInvoice!J21,InvoiceList!$A$10:$CK$10,0))=0,\"\",CHAR(10)&INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Class \"&AutoInvoice!J21,InvoiceList!$A$10:$CK$10,0))),\"\")","v":"Rabbaterad timmar"},null,null,{"$f":"IF(A21=\"\",\"\",IFERROR(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Timmar \"&AutoInvoice!J21,InvoiceList!$10:$10,0)),\"\"))","v":2},{"$f":"IF(D21=\"\",\"\",IFERROR(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Timtaxa \"&AutoInvoice!J21,InvoiceList!$10:$10,0)),\"\"))","v":625},{"$f":"IF(A21=\"\",\"\",IFERROR(D21*E21,\"\"))","v":1250},{"$f":"IF(A21=\"\",\"\",IF(OR(F21=0,A21=\"\",F21=\"\"),\"\",0.25))","v":0.25},{"$f":"IF(A21=\"\",\"\",IFERROR(E21*G21*D21,\"\"))","v":312.5},{"$f":"IF(A21=\"\",\"\",IFERROR(IF(ISERROR(D21*E21),\"\",IF(D21*E21+H21=0,\"\",D21*E21)),\"\"))","v":1250},2]
[{"$f":"IFERROR(IF(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Titel \"&AutoInvoice!J22,InvoiceList!$A$10:$CK$10,0))=0,\"\",INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Titel \"&AutoInvoice!J22,InvoiceList!$A$10:$CK$10,0)))&\nIF(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Class \"&AutoInvoice!J22,InvoiceList!$A$10:$CK$10,0))=0,\"\",CHAR(10)&INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Class \"&AutoInvoice!J22,InvoiceList!$A$10:$CK$10,0))),\"\")","v":""},null,null,{"$f":"IF(A22=\"\",\"\",IFERROR(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Timmar \"&AutoInvoice!J22,InvoiceList!$10:$10,0)),\"\"))","v":""},{"$f":"IF(D22=\"\",\"\",IFERROR(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Timtaxa \"&AutoInvoice!J22,InvoiceList!$10:$10,0)),\"\"))","v":""},"",{"$f":"IF(A22=\"\",\"\",IF(OR(F22=0,A22=\"\",F22=\"\"),\"\",0.25))","v":""},"","",3]
[{"$f":"IFERROR(IF(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Titel \"&AutoInvoice!J23,InvoiceList!$A$10:$CK$10,0))=0,\"\",INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Titel \"&AutoInvoice!J23,InvoiceList!$A$10:$CK$10,0)))&\nIF(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Class \"&AutoInvoice!J23,InvoiceList!$A$10:$CK$10,0))=0,\"\",CHAR(10)&INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Class \"&AutoInvoice!J23,InvoiceList!$A$10:$CK$10,0))),\"\")","v":""},null,null,{"$f":"IF(A23=\"\",\"\",IFERROR(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Timmar \"&AutoInvoice!J23,InvoiceList!$10:$10,0)),\"\"))","v":""},{"$f":"IF(D23=\"\",\"\",IFERROR(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Timtaxa \"&AutoInvoice!J23,InvoiceList!$10:$10,0)),\"\"))","v":""},"",{"$f":"IF(A23=\"\",\"\",IF(OR(F23=0,A23=\"\",F23=\"\"),\"\",0.25))","v":""},"","",4]
[{"$f":"IFERROR(IF(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Titel \"&AutoInvoice!J24,InvoiceList!$A$10:$CK$10,0))=0,\"\",INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Titel \"&AutoInvoice!J24,InvoiceList!$A$10:$CK$10,0)))&\nIF(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Class \"&AutoInvoice!J24,InvoiceList!$A$10:$CK$10,0))=0,\"\",CHAR(10)&INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Class \"&AutoInvoice!J24,InvoiceList!$A$10:$CK$10,0))),\"\")","v":""},null,null,{"$f":"IF(A24=\"\",\"\",IFERROR(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Timmar \"&AutoInvoice!J24,InvoiceList!$10:$10,0)),\"\"))","v":""},{"$f":"IF(D24=\"\",\"\",IFERROR(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Timtaxa \"&AutoInvoice!J24,InvoiceList!$10:$10,0)),\"\"))","v":""},"",{"$f":"IF(A24=\"\",\"\",IF(OR(F24=0,A24=\"\",F24=\"\"),\"\",0.25))","v":""},"","",5]
[{"$f":"IFERROR(IF(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Titel \"&AutoInvoice!J25,InvoiceList!$A$10:$CK$10,0))=0,\"\",INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Titel \"&AutoInvoice!J25,InvoiceList!$A$10:$CK$10,0))),\"\")","v":""},null,null,{"$f":"IF(A25=\"\",\"\",IFERROR(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Timmar \"&AutoInvoice!J25,InvoiceList!$10:$10,0)),\"\"))","v":""},{"$f":"IF(A25=\"\",\"\",IFERROR(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Timtaxa \"&AutoInvoice!J25,InvoiceList!$10:$10,0)),\"\"))","v":""},"",{"$f":"IF(A25=\"\",\"\",IF(OR(F25=0,A25=\"\",F25=\"\"),\"\",0.25))","v":""},"","",6]
[null,null,null,{"$f":"IF(A26=\"\",\"\",IFERROR(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Timmar \"&AutoInvoice!J26,InvoiceList!$10:$10,0)),\"\"))","v":""},{"$f":"IF(A26=\"\",\"\",IFERROR(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Timtaxa \"&AutoInvoice!J26,InvoiceList!$10:$10,0)),\"\"))","v":""},"","","","",7]
[null,null,null,null,null,"","","","",8]
[null,null,null,null,null,"","","","",9]
[null,null,null,null,null,null,null,null,null,10]
[]
[]
[]
[]
[]
[{"$f":"IFERROR(IF(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Titel \"&AutoInvoice!J35,InvoiceList!$A$10:$CK$10,0))=0,\"\",INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Titel \"&AutoInvoice!J35,InvoiceList!$A$10:$CK$10,0))),\"\")","v":""},null,null,{"$f":"IF(A35=\"\",\"\",IFERROR(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Timmar \"&AutoInvoice!J35,InvoiceList!$10:$10,0)),\"\"))","v":""},{"$f":"IF(A35=\"\",\"\",IFERROR(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Timtaxa \"&AutoInvoice!J35,InvoiceList!$10:$10,0)),\"\"))","v":""},"","","",""]
[{"$f":"IFERROR(IF(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Titel \"&AutoInvoice!J36,InvoiceList!$A$10:$CK$10,0))=0,\"\",INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Titel \"&AutoInvoice!J36,InvoiceList!$A$10:$CK$10,0))),\"\")","v":""},null,null,{"$f":"IF(A36=\"\",\"\",IFERROR(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Timmar \"&AutoInvoice!J36,InvoiceList!$10:$10,0)),\"\"))","v":""},{"$f":"IF(A36=\"\",\"\",IFERROR(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Timtaxa \"&AutoInvoice!J36,InvoiceList!$10:$10,0)),\"\"))","v":""},"","","","",11]
[{"$f":"IFERROR(IF(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Titel \"&AutoInvoice!J37,InvoiceList!$A$10:$CK$10,0))=0,\"\",INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Titel \"&AutoInvoice!J37,InvoiceList!$A$10:$CK$10,0))),\"\")","v":""},null,null,{"$f":"IF(A37=\"\",\"\",IFERROR(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Timmar \"&AutoInvoice!J37,InvoiceList!$10:$10,0)),\"\"))","v":""},{"$f":"IF(A37=\"\",\"\",IFERROR(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Timtaxa \"&AutoInvoice!J37,InvoiceList!$10:$10,0)),\"\"))","v":""},"","","","",12]
[{"$f":"IFERROR(IF(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Titel \"&AutoInvoice!J38,InvoiceList!$A$10:$CK$10,0))=0,\"\",INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Titel \"&AutoInvoice!J38,InvoiceList!$A$10:$CK$10,0))),\"\")","v":""},null,null,{"$f":"IF(A38=\"\",\"\",IFERROR(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Timmar \"&AutoInvoice!J38,InvoiceList!$10:$10,0)),\"\"))","v":""},{"$f":"IF(A38=\"\",\"\",IFERROR(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Timtaxa \"&AutoInvoice!J38,InvoiceList!$10:$10,0)),\"\"))","v":""},"","","","",13]
[{"$f":"IFERROR(IF(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Titel \"&AutoInvoice!J39,InvoiceList!$A$10:$CK$10,0))=0,\"\",INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Titel \"&AutoInvoice!J39,InvoiceList!$A$10:$CK$10,0))),\"\")","v":""},null,null,{"$f":"IF(A39=\"\",\"\",IFERROR(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Timmar \"&AutoInvoice!J39,InvoiceList!$10:$10,0)),\"\"))","v":""},{"$f":"IF(A39=\"\",\"\",IFERROR(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Timtaxa \"&AutoInvoice!J39,InvoiceList!$10:$10,0)),\"\"))","v":""},"","","","",14]
[{"$f":"IFERROR(IF(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Titel \"&AutoInvoice!J40,InvoiceList!$A$10:$CK$10,0))=0,\"\",INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Titel \"&AutoInvoice!J40,InvoiceList!$A$10:$CK$10,0))),\"\")","v":""},null,null,{"$f":"IF(A40=\"\",\"\",IFERROR(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Timmar \"&AutoInvoice!J40,InvoiceList!$10:$10,0)),\"\"))","v":""},{"$f":"IF(A40=\"\",\"\",IFERROR(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Timtaxa \"&AutoInvoice!J40,InvoiceList!$10:$10,0)),\"\"))","v":""},"","","","",15]
[{"$f":"IFERROR(IF(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Titel \"&AutoInvoice!J41,InvoiceList!$A$10:$CK$10,0))=0,\"\",INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Titel \"&AutoInvoice!J41,InvoiceList!$A$10:$CK$10,0))),\"\")","v":""},null,null,{"$f":"IF(A41=\"\",\"\",IFERROR(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Timmar \"&AutoInvoice!J41,InvoiceList!$10:$10,0)),\"\"))","v":""},{"$f":"IF(A41=\"\",\"\",IFERROR(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Timtaxa \"&AutoInvoice!J41,InvoiceList!$10:$10,0)),\"\"))","v":""},"","","","",16]
[{"$f":"IFERROR(IF(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Titel \"&AutoInvoice!J42,InvoiceList!$10:$10,0))=0,\"\",INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Titel \"&AutoInvoice!J42,InvoiceList!$10:$10,0))),\"\")","v":""},null,null,{"$f":"IF(A42=\"\",\"\",IFERROR(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Timmar \"&AutoInvoice!J42,InvoiceList!$10:$10,0)),\"\"))","v":""},{"$f":"IF(A42=\"\",\"\",IFERROR(INDEX(InvoiceList!$A$11:$CG$16,MATCH(AutoInvoice!$G$3,InvoiceList!$H$11:$H$16,0),MATCH(\"Timtaxa \"&AutoInvoice!J42,InvoiceList!$10:$10,0)),\"\"))","v":""},"","","","",17]
[null,null,null,null,null,null,"Belopp före moms",null,{"$f":"SUM(I20:I42)","v":14750}]
[null,null,null,null,null,null,"Total moms",null,{"$f":"SUM(H20:H42)","v":3687.5}]
[null,null,null,null,null,null,"Öresavrundning",null,{"$f":"ROUND(SUM(I43:I44),0)-SUM(I43:I44)","v":0.5}]
[null,null,null,null,null,null,"Att Betala",null,{"$f":"SUM(I43:I45)","v":18438}]
["Adress",null,"Telefonnummer",null,null,null,"BankGiro",null,"Organisationsnr"]
[{"$f":"IF(ManualInvoice!A48=\"\",\"Saknas\",ManualInvoice!A48)","v":"Saknas"},null,{"$f":"IF(ManualInvoice!C48=\"\",\"Saknas\",ManualInvoice!C48)","v":"Saknas"},null,null,null,{"$f":"IF(ManualInvoice!G48=\"\",\"Saknas\",ManualInvoice!G48)","v":"Saknas"},null,{"$f":"IF(ManualInvoice!I48=\"\",\"Saknas\",ManualInvoice!I48)","v":"Saknas"}]
[{"$f":"IF(ManualInvoice!A49=\"\",\"Saknas\",ManualInvoice!A49)","v":"Saknas"},null,"Epost",null,null,null,"BIC",null,"Momsreg.nr"]
[{"$f":"IF(ManualInvoice!A50=\"\",\"Saknas\",ManualInvoice!A50)","v":"Saknas"},null,{"$f":"IF(ManualInvoice!C50=\"\",\"Saknas\",ManualInvoice!C50)","v":"Saknas"},null,null,null,{"$f":"IF(ManualInvoice!G50=\"\",\"Saknas\",ManualInvoice!G50)","v":"Saknas"},null,{"$f":"IF(ManualInvoice!I50=\"\",\"Saknas\",ManualInvoice!I50)","v":"Saknas"}]
[null,null,null,null,null,null,"IBAN"]
[null,null,null,null,null,null,{"$f":"IF(ManualInvoice!G52=\"\",\"Saknas\",ManualInvoice!G52)","v":"Saknas"}]

{"sheet":"SendEmails","index":4,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"1_ToEmail"]
[null,null,"2_EmailSent"]
[null,null,"3_AwaitingDetails"]
[null,null,"4_NotSent"]
[]
[]
[]
[null,{"$f":"IF(Admin!$B$12=\"NO\",\"\",IF(Admin!$B$4=\"MONTH\",IF(MONTH(NOW())<>MONTH(Admin!$B$6),\"This is a free version. Contact Exceldepartment for unlocking full potential of the model.\",\"\"),\nIF(Admin!$B$4=\"QRT\",IF(INT((MONTH(NOW())+2)/3)<>INT((MONTH(Admin!$B$6)+2)/3),\"This is a free version. Contact Exceldepartment for unlocking full potential of the model.\",\"\"),\nIF(Admin!$B$4=\"YEAR\",IF(YEAR(NOW())<>YEAR(Admin!$B$6),\"This is a free version. Contact Exceldepartment for unlocking full potential of the model.\",\"\"),\n\"This is a free version. Contact Exceldepartment for unlocking full potential of the model.\"))))","v":"This is a free version. Contact Exceldepartment for unlocking full potential of the model."}]
[null,"Project","_Status","_Prio","_Comment","_Email","_CC","_Date","_EmailSubject","_EmailBody"]
[null,"Project 4","1_ToEmail",null,null,"info@exceldepartment.com","lukas.lilja@exceldepartment.com","2023-10-12T12:49:25","Test","XLD test"]

{"sheet":"FetchEmails","index":5,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":true,"merged":[[4,6,5,6]]}
[]
[]
[]
[]
[null,null,"Date From","Date To","Subject Contains","Body contains","<<< email filter"]
[null,null,"2023-10-12T13:08:55","2023-10-10"]
[null,{"$f":"IF(Admin!$B$12=\"NO\",\"\",IF(Admin!$B$4=\"MONTH\",IF(MONTH(NOW())<>MONTH(Admin!$B$6),\"This is a free version. Contact Exceldepartment for unlocking full potential of the model.\",\"\"),\nIF(Admin!$B$4=\"QRT\",IF(INT((MONTH(NOW())+2)/3)<>INT((MONTH(Admin!$B$6)+2)/3),\"This is a free version. Contact Exceldepartment for unlocking full potential of the model.\",\"\"),\nIF(Admin!$B$4=\"YEAR\",IF(YEAR(NOW())<>YEAR(Admin!$B$6),\"This is a free version. Contact Exceldepartment for unlocking full potential of the model.\",\"\"),\n\"This is a free version. Contact Exceldepartment for unlocking full potential of the model.\"))))","v":"This is a free version. Contact Exceldepartment for unlocking full potential of the model."}]
[]
[null,null,null,null,null,"NOT VALID SUBJE1202119",{"$f":"IFERROR(MID(B9,FIND(\"@\",B9)+1,FIND(\";\",B9)-FIND(\"@\",B9)-1),\nIFERROR(RIGHT(B9,LEN(B9)-FIND(\"@\",B9)),\"\"))","v":""},{"$f":"IFERROR(MID(D9,FIND(\" - \",D9)+3,100),\"NOT VALID SUBJECT\")","v":"NOT VALID SUBJECT"},{"$f":"+E9","v":0},{"$f":"1","v":1},{"$f":"IFERROR(IF(FIND(\";\",B9),UPPER(LEFT(MID(B9,FIND(\";\",B9)+2,1000),1))&UPPER(MID(MID(B9,FIND(\";\",B9)+3,1000),FIND(\".\",MID(B9,FIND(\";\",B9)+3,1000))+1,1)),\"\"),\"\")","v":""},{"$f":"IFERROR(DATE(YEAR(C9),MONTH(C9),DAY(C9)),0)","v":"00:00:00"},{"$f":"+L9+1","v":"1900-01-01"},"1_Assigned"]
[null,"_SendTo","_MailSent","_MailSubject","_MailBody","_Key","ClientServer","_Name","_Description","_Hours","_Responsible","_StartDate","_EndDate","_Status"]
[null,null,null,null,null,null,{"$f":"IFERROR(MID(B11,FIND(\"@\",B11)+1,FIND(\";\",B11)-FIND(\"@\",B11)-1),\nIFERROR(RIGHT(B11,LEN(B11)-FIND(\"@\",B11)),\"\"))","v":""},{"$f":"IFERROR(MID(D11,FIND(\" - \",D11)+3,100),\"NOT VALID SUBJECT\")","v":"NOT VALID SUBJECT"},{"$f":"+E11","v":0},{"$f":"1","v":1},{"$f":"IFERROR(IF(FIND(\";\",B11),UPPER(LEFT(MID(B11,FIND(\";\",B11)+2,1000),1))&UPPER(MID(MID(B11,FIND(\";\",B11)+3,1000),FIND(\".\",MID(B11,FIND(\";\",B11)+3,1000))+1,1)),\"\"),\"\")","v":""},{"$f":"IFERROR(DATE(YEAR(C11),MONTH(C11),DAY(C11)),0)","v":"00:00:00"},{"$f":"+L11+1","v":"1900-01-01"}]

{"sheet":"Admin","index":6,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["RootForGeneratingPasswords","LOCKDATE",null,null,null,"VISIBLE SHEETS"]
["zX1mHOF4BzSE","2023-10-24","DataColor","Values",null,"wManualFaktura",null,null,null,null,null,null,"INVOICESTATUS"]
["oIP7ALgV2TbD","QRT/MNTH","_Key","Ref",null,null,null,null,null,null,null,null,"1_Sent"]
["PBf1K6hy2ANJ","QRT","ConnectedTitles","Marknad",null,null,null,null,null,null,null,null,"2_Generate"]
["U22abS0FBELA","MANUAL DATE","KeyConnector",null,null,null,null,null,null,null,null,null,"3_GetDetails"]
["IgN18Hgg4NAT","2023-09-01",null,null,null,null,null,null,null,null,null,null,"31_AwaitingDetails"]
["PXSz19ba6IVA","LOCKFORMULA",null,null,null,null,null,null,null,null,null,null,"6_FollowUp"]
["P07GgaK1bKOC",{"$f":"IF(Admin!$B$12=\"NO\",\"\",IF(Admin!$B$4=\"MONTH\",IF(MONTH(NOW())<>MONTH(Admin!$B$6),\"This is a free version. Contact Exceldepartment for unlocking full potential of the model.\",\"\"),\nIF(Admin!$B$4=\"QRT\",IF(INT((MONTH(NOW())+2)/3)<>INT((MONTH(Admin!$B$6)+2)/3),\"This is a free version. Contact Exceldepartment for unlocking full potential of the model.\",\"\"),\nIF(Admin!$B$4=\"YEAR\",IF(YEAR(NOW())<>YEAR(Admin!$B$6),\"This is a free version. Contact Exceldepartment for unlocking full potential of the model.\",\"\"),\n\"This is a free version. Contact Exceldepartment for unlocking full potential of the model.\"))))","v":"This is a free version. Contact Exceldepartment for unlocking full potential of the model."},null,null,null,null,null,null,null,null,null,null,"97_Credited"]
["G90BabzCLSLO","PASSWORD",null,null,null,null,null,null,null,null,null,null,"98_CreditInvoice"]
["JSJml83TDVIN",42,null,null,null,null,null,null,null,null,null,null,"99_Cancel"]
["Wr15KDosZSAN","USEPROTECTION"]
["HWilC19QXIRE","YES"]
["ABIZG12qzMAR","USEPROTECTIONWB"]
["FGYhhJ0SABUB","YES"]