{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Checkregnskab"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Checkregnskab","index":0,"n_rows":13,"n_cols":8,"rows_kept":13}
[null,"Checkregnskab"]
[null,"FORKLARING",{"$nulls":5},"NUVÆRENDE SALDO"]
[null,"KK = Kreditkort",null,"AU = Automatisk udbetaling ",{"$nulls":3},{"$f":"NUVÆRENDE_SALDO","v":{"v":3311,"d":"kr. 3,311.00"}}]
[null,"KA = Kontantautomat",null,"BR = Online betaling af regninger"]
[null,"AI = Automatisk indbetaling ",null,"O = Overførsel via telefon eller online"]
[null,"CHECK/KODE","DATO","TRANSAKTION","BESKRIVELSE","UDBETALING","INDBETALING","SALDO"]
[null,null,{"$f":"TODAY()-19","v":"2022-03-18"},"Woodgrove Bank","Startsaldo",null,{"v":2000,"d":"kr. 2,000.00"},{"$f":"IFERROR(CheckRegnskab[[#This Row],[INDBETALING]], \"\")","v":{"v":2000,"d":"kr. 2,000.00"}}]
[null,1001,{"$f":"TODAY()-11","v":"2022-03-26"},"Kunstakademi","Kellys billedkunstkursus – 6 uger",{"v":100,"d":"kr. 100.00"},null,{"$f":"IFERROR(IF(ISBLANK(CheckRegnskab[[#This Row],[UDBETALING]]),H7+CheckRegnskab[[#This Row],[INDBETALING]],H7-CheckRegnskab[[#This Row],[UDBETALING]]), \"\")","v":{"v":1900,"d":"kr. 1,900.00"}}]
[null,"AI",{"$f":"TODAY()-11","v":"2022-03-26"},"Løn",null,null,{"v":1500,"d":"kr. 1,500.00"},{"$f":"IFERROR(IF(ISBLANK(CheckRegnskab[[#This Row],[UDBETALING]]),H8+CheckRegnskab[[#This Row],[INDBETALING]],H8-CheckRegnskab[[#This Row],[UDBETALING]]), \"\")","v":{"v":3400,"d":"kr. 3,400.00"}}]
[null,"KK",{"$f":"TODAY()-8","v":"2022-03-29"},"Southridge Video","Leje af film + kr. 10 rabat",{"v":16,"d":"kr. 16.00"},null,{"$f":"IFERROR(IF(ISBLANK(CheckRegnskab[[#This Row],[UDBETALING]]),H9+CheckRegnskab[[#This Row],[INDBETALING]],H9-CheckRegnskab[[#This Row],[UDBETALING]]), \"\")","v":{"v":3384,"d":"kr. 3,384.00"}}]
[null,"KA",{"$f":"TODAY()-5","v":"2022-04-01"},null,"Kontanter til restaurantbesøg",{"v":50,"d":"kr. 50.00"},null,{"$f":"IFERROR(IF(ISBLANK(CheckRegnskab[[#This Row],[UDBETALING]]),H10+CheckRegnskab[[#This Row],[INDBETALING]],H10-CheckRegnskab[[#This Row],[UDBETALING]]), \"\")","v":{"v":3334,"d":"kr. 3,334.00"}}]
[null,"BR",{"$f":"TODAY()","v":"2022-04-06"},"Telefonselskab",null,{"v":23,"d":"kr. 23.00"},null,{"$f":"IFERROR(IF(ISBLANK(CheckRegnskab[[#This Row],[UDBETALING]]),H11+CheckRegnskab[[#This Row],[INDBETALING]],H11-CheckRegnskab[[#This Row],[UDBETALING]]), \"\")","v":{"v":3311,"d":"kr. 3,311.00"}}]
[null,"Samlede beløb",null,{"$f":"CONCATENATE(\"Antal transaktioner: \",SUBTOTAL(103,CheckRegnskab[TRANSAKTION]))","v":"Antal transaktioner: 5"},null,{"$f":"SUBTOTAL(109,CheckRegnskab[UDBETALING])","v":{"v":189,"d":"kr. 189.00"}},{"$f":"SUBTOTAL(109,CheckRegnskab[INDBETALING])","v":{"v":3500,"d":"kr. 3,500.00"}},{"$f":"CheckRegnskab[[#Totals],[INDBETALING]]-CheckRegnskab[[#Totals],[UDBETALING]]","v":{"v":3311,"d":"kr. 3,311.00"}}]