{"text_format":"3","workbook":"xlsx","n_sheets":10,"sheets":["Rechner BetMG","Rechner BetMG (2)","Rechner BetMG (3)","Rechner Vermögensdelikte","Tabelle Hansjakob","Asperation StGB 49","Hafttage","Erläuterungen","Mathematik","Bezüge"],"not_rendered":{"images":1,"defined_names":3,"comments":10},"read":"whole","date_system":"1900"}

{"sheet":"Rechner BetMG","index":0,"n_rows":67,"n_cols":6,"rows_kept":67,"merged":[[33,2,33,3],[33,4,33,5]]}
[null,"Strafzumessungsrechner",null,"BetmG","© 2012 FS Kunz, Köniz"]
[{"$nulls":4},"Version 7.0","2025-12-02"]
[]
["Autor/in","Name","Dossier","Nr","Datum"]
[]
["Hinweis: Die Tabelle funktioniert bei einfacher und qualifizierter Widerhandlung gegen das BetMG, "]
["Qualifikation: Für Heroin und Methamphetamin ab 12 Gramm, Kokain ab 18 Gramm,"]
["Amphetamin ab 36 Gramm, MDMA ab 160 Gramm reinem Stoff"]
["Hanf Umsatz von mehr als 110'000.--, Gewinn mehr als 10'000.--"]
[]
["Legende:"]
["gelbes Feld","Eingabe nötig"]
["oranges Feld","Eingabe möglich"]
["grünes Feld","Resultat"]
["blaue Schrift","Link zu Erläuterung"]
[]
[]
[null,"Substanz","Heroin","Kokain","Amphetamin","MDMA"]
[null,"Gramm brutto",0,0,0,0]
[null,"Reinheit %",{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"}]
[null,"Gramm netto",{"$f":"C19*C20","v":0},{"$f":"D19*D20","v":0},0,0]
[null,"Heroinäquivalent",{"$f":"C21","v":0},{"$f":"D21/3*2","v":0},{"$f":"E21/3","v":0},{"$f":"F21/160*12","v":0}]
[null,"Total Heroinäquivalent",{"$f":"C22+D22+E22+F22","v":0}]
[]
[]
[]
[null,null,"Hanf"]
[]
[]
[null,"Umsatz",0]
[]
[]
[]
[null,null,"Formel Heroinäquivalent",null,"Formel Hanf"]
[]
[null,null,"Fingerhut 1. Auflage",null,"Umsatz","Gewinn"]
[]
[null,"Heroinäquivalent / Umsatz (Hanf)",{"$f":"C23","v":0},null,{"$f":"IF(B30=\"Umsatz\",C30,0)","v":0},{"$f":"IF(B30=\"Gewinn\",C30,0)","v":0}]
[]
[]
["Einsatzstrafe","in Monaten",{"$f":"IF(C38>11.9,(C38/12)^(1/3)*12,(C38/12)*12)","v":{"v":0,"d":"0.0"}},null,{"$f":"IF(E38>109999,(E38/110000)^(1/3)*12,(E38/110000)*12)","v":0},{"$f":"IF(F38>9999,(F38/10000)^(1/3)*12,(F38/10000)*12)","v":0}]
[null,"in Jahren",{"$f":"IF(C41>11.9,C41/12,\"0\")","v":"0"},null,{"$f":"IF(E41>11.9,E41/12,\"0\")","v":"0"},{"$f":"IF(F39>9999,(F39/10000)^(1/3)*12,(F39/10000)*12)","v":0}]
[null,"in Tagessätzen",{"$f":"IF(C41<12,C41*30,\"0\")","v":0},null,{"$f":"IF(E41<12,E41*30,\"0\")","v":0},0]
[]
["Korrektur Tatkomponenten"]
["Zuschlag Hierarchiestufe",{"v":0,"d":"0%"},{"$f":"(C41*B46)+C41","v":{"v":0,"d":"0.0"}},null,{"$f":"(E41*B46)+E41","v":{"v":0,"d":"0.0"}},{"$f":"(F41*B46)+F41","v":{"v":0,"d":"0.0"}}]
["Rabatt Hierarchiestufe",{"v":0,"d":"0%"},{"$f":"C46-($C$46*B47)","v":{"v":0,"d":"0.0"}},null,{"$f":"E46-(E46*B47)","v":{"v":0,"d":"0.0"}},{"$f":"F46-(F46*B47)","v":{"v":0,"d":"0.0"}}]
["Rabatt Anzahl Geschäfte",{"v":0,"d":"0%"},{"$f":"C47-($C$47*B48)","v":{"v":0,"d":"0.0"}},null,{"$f":"E47-(E47*B48)","v":{"v":0,"d":"0.0"}},{"$f":"F47-(F47*B48)","v":{"v":0,"d":"0.0"}}]
["Rabatt Sucht, Anstaltentreffen",{"v":0,"d":"0%"},{"$f":"C48-($C$48*B49)","v":{"v":0,"d":"0.0"}},null,{"$f":"E48-(E48*B49)","v":{"v":0,"d":"0.0"}},{"$f":"F48-(F48*B49)","v":{"v":0,"d":"0.0"}}]
["Zuschlag Anzahl Geschäfte",{"v":0,"d":"0%"},{"$f":"(C49*B50)+C49","v":{"v":0,"d":"0.0"}},null,{"$f":"(E49*B50)+E49","v":{"v":0,"d":"0.0"}},{"$f":"(F49*B50)+F49","v":{"v":0,"d":"0.0"}}]
[]
["Korrektur Täterkomponenten"]
["Rabatt Geständnis",{"v":0,"d":"0%"},{"$f":"C50-(B53*C50)","v":{"v":0,"d":"0.0"}},null,{"$f":"E50-(B53*E50)","v":{"v":0,"d":"0.0"}},{"$f":"F50-(B53*F50)","v":{"v":0,"d":"0.0"}}]
["Rabatt Zurechnungsfähigk.",{"v":0,"d":"0%"},{"$f":"C53-(B54*C53)","v":{"v":0,"d":"0.0"}},null,{"$f":"E53-(B54*E53)","v":{"v":0,"d":"0.0"}},{"$f":"F53-(B54*F53)","v":{"v":0,"d":"0.0"}}]
[]
["Zuschlag Vorstrafen",null,{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
["Zuschlag Monate Art. 49 StGB",null,{"$f":"'Rechner Vermögensdelikte'!$I22","v":{"v":0,"d":"0.0"}},null,{"$f":"'Rechner Vermögensdelikte'!$I22","v":{"v":0,"d":"0.0"}},{"$f":"'Rechner Vermögensdelikte'!$I22","v":{"v":0,"d":"0.0"}}]
[]
["Total rechnerisch","Monate",{"$f":"C56+C57+C54","v":{"v":0,"d":"0.0"}},null,{"$f":"E56+E57+E54","v":{"v":0,"d":"0.0"}},{"$f":"F56+F57+F54","v":{"v":0,"d":"0.0"}}]
[null,"Jahre",{"$f":"IF(C59>11.9,C59/12,\"0\")","v":"0"},null,"0","0"]
[null,"TS",{"$f":"IF(C59<11.9,C59*30,\"0\")","v":0},null,0,0]
[]
["Korrektur Einzelfall"]
["Abzug Monate für pers. Verhältn.",null,0,null,0,0]
["Ergebnis","Monate",{"$f":"C59-C64","v":0},null,{"$f":"E59-E64","v":0},0]
[null,"Jahre",{"$f":"IF(C65>11.9,C65/12,\"0\")","v":"0"},null,{"$f":"IF(E65>11.9,E65/12,\"0\")","v":"0"},"0"]
[null,"TS",{"$f":"IF(C65<11.9,C65*30,\"0\")","v":0},null,{"$f":"IF(E65<11.9,E65*30,\"0\")","v":0},0]

{"sheet":"Rechner BetMG (2)","index":1,"n_rows":67,"n_cols":6,"rows_kept":67,"merged":[[33,2,33,3],[33,4,33,5]]}
[null,"Strafzumessungsrechner",null,"BetmG","© 2012 FS Kunz, Köniz"]
[{"$nulls":4},"Tabellenblatt 2","Version 7.0 02.12.2025"]
[]
["Autor/in","Name","Mandat:","Name","Datum"]
[]
["Hinweis: Die Tabelle funktioniert bei einfacher und qualifizierter Widerhandlung gegen das BetMG, "]
["Qualifikation: Für Heroin und Methamphetamin ab 12 Gramm, Kokain ab 18 Gramm,"]
["Amphetamin ab 36 Gramm, MDMA ab 160 Gramm reinem Stoff"]
["Hanf Umsatz von mehr als 110'000.--, Gewinn mehr als 10'000.--"]
[]
["Legende:"]
["gelbes Feld","Eingabe nötig"]
["oranges Feld","Eingabe möglich"]
["grünes Feld","Resultat"]
["blaue Schrift","Link zu Erläuterung"]
[]
[]
[null,"Substanz","Heroin","Kokain","Amphetamin","MDMA"]
[null,"Gramm brutto",0,0,0,0]
[null,"Reinheit %",{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"}]
[null,"Gramm netto",{"$f":"C19*C20","v":0},{"$f":"D19*D20","v":0},0,0]
[null,"Heroinäquivalent",{"$f":"C21","v":0},{"$f":"D21/3*2","v":0},{"$f":"E21/3","v":0},{"$f":"F21/160*12","v":0}]
[null,"Total Heroinäquivalent",{"$f":"C22+D22+E22+F22","v":0}]
[]
[]
[]
[null,null,"Hanf"]
[]
[]
[null,"Umsatz",0]
[]
[]
[]
[null,null,"Formel Heroinäquivalent",null,"Formel Hanf"]
[]
[null,null,"Fingerhut 1. Auflage",null,"Umsatz","Gewinn"]
[]
[null,"Heroinäquivalent / Umsatz (Hanf)",{"$f":"C23","v":0},null,{"$f":"IF(B30=\"Umsatz\",C30,0)","v":0},{"$f":"IF(B30=\"Gewinn\",C30,0)","v":0}]
[]
[]
["Einsatzstrafe","in Monaten",{"$f":"IF( C38>12, IF(C38>120,4.866*C38^(1/3),5.68*C38^(LOG10(2))),C38)","v":{"v":0,"d":"0.0"}},null,{"$f":"IF(E38>109999,(E38/110000)^(1/3)*12,(E38/110000)*12)","v":0},{"$f":"IF(F38>9999,(F38/10000)^(1/3)*12,(F38/10000)*12)","v":0}]
[null,"in Jahren",{"$f":"IF(C41>11.9,C41/12,\"0\")","v":"0"},null,{"$f":"IF(E41>11.9,E41/12,\"0\")","v":"0"},{"$f":"IF(F39>9999,(F39/10000)^(1/3)*12,(F39/10000)*12)","v":0}]
[null,"in Tagessätzen",{"$f":"IF(C41<12,C41*30,\"0\")","v":0},null,{"$f":"IF(E41<12,E41*30,\"0\")","v":0},0]
[]
["Korrektur Tatkomponenten"]
["Zuschlag Hierarchiestufe",{"v":0,"d":"0%"},{"$f":"(C41*B46)+C41","v":{"v":0,"d":"0.0"}},null,{"$f":"(E41*B46)+E41","v":{"v":0,"d":"0.0"}},{"$f":"(F41*B46)+F41","v":{"v":0,"d":"0.0"}}]
["Rabatt Hierarchiestufe",{"v":0,"d":"0%"},{"$f":"C46-($C$46*B47)","v":{"v":0,"d":"0.0"}},null,{"$f":"E46-(E46*B47)","v":{"v":0,"d":"0.0"}},{"$f":"F46-(F46*B47)","v":{"v":0,"d":"0.0"}}]
["Rabatt Anzahl Geschäfte",{"v":0,"d":"0%"},{"$f":"C47-($C$47*B48)","v":{"v":0,"d":"0.0"}},null,{"$f":"E47-(E47*B48)","v":{"v":0,"d":"0.0"}},{"$f":"F47-(F47*B48)","v":{"v":0,"d":"0.0"}}]
["Rabatt Sucht, Anstaltentreffen",{"v":0.3,"d":"30%"},{"$f":"C48-($C$48*B49)","v":{"v":0,"d":"0.0"}},null,{"$f":"E48-(E48*B49)","v":{"v":0,"d":"0.0"}},{"$f":"F48-(F48*B49)","v":{"v":0,"d":"0.0"}}]
["Zuschlag Anzahl Geschäfte",{"v":0,"d":"0%"},{"$f":"(C49*B50)+C49","v":{"v":0,"d":"0.0"}},null,{"$f":"(E49*B50)+E49","v":{"v":0,"d":"0.0"}},{"$f":"(F49*B50)+F49","v":{"v":0,"d":"0.0"}}]
[]
["Korrektur Täterkomponenten"]
["Rabatt Geständnis",{"v":0,"d":"0%"},{"$f":"C50-(B53*C50)","v":{"v":0,"d":"0.0"}},null,{"$f":"E50-(B53*E50)","v":{"v":0,"d":"0.0"}},{"$f":"F50-(B53*F50)","v":{"v":0,"d":"0.0"}}]
["Rabatt Zurechnungsfähigk.",{"v":0,"d":"0%"},{"$f":"C53-(B54*C53)","v":{"v":0,"d":"0.0"}},null,{"$f":"E53-(B54*E53)","v":{"v":0,"d":"0.0"}},{"$f":"F53-(B54*F53)","v":{"v":0,"d":"0.0"}}]
[]
["Zuschlag Vorstrafen",null,{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
["Zuschlag Monate Art. 49 StGB",null,{"$f":"'Rechner Vermögensdelikte'!$I22","v":{"v":0,"d":"0.0"}},null,{"$f":"'Rechner Vermögensdelikte'!$I22","v":{"v":0,"d":"0.0"}},{"$f":"'Rechner Vermögensdelikte'!$I22","v":{"v":0,"d":"0.0"}}]
[]
["Total rechnerisch","Monate",{"$f":"C56+C57+C54","v":{"v":0,"d":"0.0"}},null,{"$f":"E56+E57+E54","v":{"v":0,"d":"0.0"}},{"$f":"F56+F57+F54","v":{"v":0,"d":"0.0"}}]
[null,"Jahre",{"$f":"IF(C59>11.9,C59/12,\"0\")","v":"0"},null,"0","0"]
[null,"TS",{"$f":"IF(C59<11.9,C59*30,\"0\")","v":0},null,0,0]
[]
["Korrektur Einzelfall"]
["Abzug Monate für pers. Verhältn.",null,0,null,0,0]
["Ergebnis","Monate",{"$f":"C59-C64","v":0},null,{"$f":"E59-E64","v":0},0]
[null,"Jahre",{"$f":"IF(C65>11.9,C65/12,\"0\")","v":"0"},null,{"$f":"IF(E65>11.9,E65/12,\"0\")","v":"0"},"0"]
[null,"TS",{"$f":"IF(C65<11.9,C65*30,\"0\")","v":0},null,{"$f":"IF(E65<11.9,E65*30,\"0\")","v":0},0]

{"sheet":"Rechner BetMG (3)","index":2,"n_rows":67,"n_cols":6,"rows_kept":67,"merged":[[33,2,33,3],[33,4,33,5]]}
[null,"Strafzumessungsrechner",null,"BetmG","© 2012 FS Kunz, Köniz"]
[{"$nulls":4},"Tabellenblatt 3","Version 7.0 02.12.2025"]
[]
["Autor/in","Name","Mandat:","Name","Datum"]
[]
["Hinweis: Die Tabelle funktioniert bei einfacher und qualifizierter Widerhandlung gegen das BetMG, "]
["Qualifikation: Für Heroin und Methamphetamin ab 12 Gramm, Kokain ab 18 Gramm,"]
["Amphetamin ab 36 Gramm, MDMA ab 160 Gramm reinem Stoff"]
["Hanf Umsatz von mehr als 110'000.--, Gewinn mehr als 10'000.--"]
[]
["Legende:"]
["gelbes Feld","Eingabe nötig"]
["oranges Feld","Eingabe möglich"]
["grünes Feld","Resultat"]
["blaue Schrift","Link zu Erläuterung"]
[]
[]
[null,"Substanz","Heroin","Kokain","Amphetamin","MDMA"]
[null,"Gramm brutto",0,0,0,0]
[null,"Reinheit %",{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"}]
[null,"Gramm netto",{"$f":"C19*C20","v":0},{"$f":"D19*D20","v":0},0,0]
[null,"Heroinäquivalent",{"$f":"C21","v":0},{"$f":"D21/3*2","v":0},{"$f":"E21/3","v":0},{"$f":"F21/160*12","v":0}]
[null,"Total Heroinäquivalent",{"$f":"C22+D22+E22+F22","v":0}]
[]
[]
[]
[null,null,"Hanf"]
[]
[]
[null,"Umsatz",0]
[]
[]
[]
[null,null,"Formel Heroinäquivalent",null,"Formel Hanf"]
[]
[null,null,"Fingerhut 1. Auflage",null,"Umsatz","Gewinn"]
[]
[null,"Heroinäquivalent / Umsatz (Hanf)",{"$f":"C23","v":0},null,{"$f":"IF(B30=\"Umsatz\",C30,0)","v":0},{"$f":"IF(B30=\"Gewinn\",C30,0)","v":0}]
[]
[]
["Einsatzstrafe","in Monaten",{"$f":"IF(C38>11.9,(C38/12)^(1/3)*12,(C38/12)*12)","v":{"v":0,"d":"0.0"}},null,{"$f":"IF(E38>109999,(E38/110000)^(1/3)*12,(E38/110000)*12)","v":0},{"$f":"IF(F38>9999,(F38/10000)^(1/3)*12,(F38/10000)*12)","v":0}]
[null,"in Jahren",{"$f":"IF(C41>11.9,C41/12,\"0\")","v":"0"},null,{"$f":"IF(E41>11.9,E41/12,\"0\")","v":"0"},{"$f":"IF(F39>9999,(F39/10000)^(1/3)*12,(F39/10000)*12)","v":0}]
[null,"in Tagessätzen",{"$f":"IF(C41<12,C41*30,\"0\")","v":0},null,{"$f":"IF(E41<12,E41*30,\"0\")","v":0},0]
[]
["Korrektur Tatkomponenten"]
["Zuschlag Hierarchiestufe",{"v":0,"d":"0%"},{"$f":"(C41*B46)+C41","v":{"v":0,"d":"0.0"}},null,{"$f":"(E41*B46)+E41","v":{"v":0,"d":"0.0"}},{"$f":"(F41*B46)+F41","v":{"v":0,"d":"0.0"}}]
["Rabatt Hierarchiestufe",{"v":0,"d":"0%"},{"$f":"C46-($C$46*B47)","v":{"v":0,"d":"0.0"}},null,{"$f":"E46-(E46*B47)","v":{"v":0,"d":"0.0"}},{"$f":"F46-(F46*B47)","v":{"v":0,"d":"0.0"}}]
["Rabatt Anzahl Geschäfte",{"v":0,"d":"0%"},{"$f":"C47-($C$47*B48)","v":{"v":0,"d":"0.0"}},null,{"$f":"E47-(E47*B48)","v":{"v":0,"d":"0.0"}},{"$f":"F47-(F47*B48)","v":{"v":0,"d":"0.0"}}]
["Rabatt Sucht, Anstaltentreffen",{"v":0.3,"d":"30%"},{"$f":"C48-($C$48*B49)","v":{"v":0,"d":"0.0"}},null,{"$f":"E48-(E48*B49)","v":{"v":0,"d":"0.0"}},{"$f":"F48-(F48*B49)","v":{"v":0,"d":"0.0"}}]
["Zuschlag Anzahl Geschäfte",{"v":0,"d":"0%"},{"$f":"(C49*B50)+C49","v":{"v":0,"d":"0.0"}},null,{"$f":"(E49*B50)+E49","v":{"v":0,"d":"0.0"}},{"$f":"(F49*B50)+F49","v":{"v":0,"d":"0.0"}}]
[]
["Korrektur Täterkomponenten"]
["Rabatt Geständnis",{"v":0,"d":"0%"},{"$f":"C50-(B53*C50)","v":{"v":0,"d":"0.0"}},null,{"$f":"E50-(B53*E50)","v":{"v":0,"d":"0.0"}},{"$f":"F50-(B53*F50)","v":{"v":0,"d":"0.0"}}]
["Rabatt Zurechnungsfähigk.",{"v":0,"d":"0%"},{"$f":"C53-(B54*C53)","v":{"v":0,"d":"0.0"}},null,{"$f":"E53-(B54*E53)","v":{"v":0,"d":"0.0"}},{"$f":"F53-(B54*F53)","v":{"v":0,"d":"0.0"}}]
[]
["Zuschlag Vorstrafen",null,{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},{"v":0,"d":"0.0"}]
["Zuschlag Monate Art. 49 StGB",null,{"$f":"'Rechner Vermögensdelikte'!$I22","v":{"v":0,"d":"0.0"}},null,{"$f":"'Rechner Vermögensdelikte'!$I22","v":{"v":0,"d":"0.0"}},{"$f":"'Rechner Vermögensdelikte'!$I22","v":{"v":0,"d":"0.0"}}]
[]
["Total rechnerisch","Monate",{"$f":"C56+C57+C54","v":{"v":0,"d":"0.0"}},null,{"$f":"E56+E57+E54","v":{"v":0,"d":"0.0"}},{"$f":"F56+F57+F54","v":{"v":0,"d":"0.0"}}]
[null,"Jahre",{"$f":"IF(C59>11.9,C59/12,\"0\")","v":"0"},null,"0","0"]
[null,"TS",{"$f":"IF(C59<11.9,C59*30,\"0\")","v":0},null,0,0]
[]
["Korrektur Einzelfall"]
["Abzug Monate für pers. Verhältn.",null,0,null,0,0]
["Ergebnis","Monate",{"$f":"C59-C64","v":0},null,{"$f":"E59-E64","v":0},0]
[null,"Jahre",{"$f":"IF(C65>11.9,C65/12,\"0\")","v":"0"},null,{"$f":"IF(E65>11.9,E65/12,\"0\")","v":"0"},"0"]
[null,"TS",{"$f":"IF(C65<11.9,C65*30,\"0\")","v":0},null,{"$f":"IF(E65<11.9,E65*30,\"0\")","v":0},0]

{"sheet":"Rechner Vermögensdelikte","index":3,"n_rows":45,"n_cols":9,"rows_kept":45}
[null,"Strafzumessungsrechner",{"$nulls":3},"© 2012 FS Kunz, Köniz"]
[null,"Vermögensdelikte",{"$nulls":3},"Version 7.0 02.12.2025"]
[]
["Erläuterung:"]
["gelbes Feld","Eingabe nötig"]
["oranges Feld","Eingabe mögl."]
["grünes Feld","Resultat"]
[{"$nulls":3},"Formel Vermögens- delikte"]
[]
[null,null,"DB gesamt",0,null,"Eingabefeld StGB 49"]
[]
[{"$nulls":5},"Zusatzdelikte","Strafe\nMte.","Anteil Asper.","Zuschlag Monate"]
[null,"Einsatzstrafe Hauptdelikt","in Monaten",{"$f":"IF(D10>99999,(D10/100000)^(0.33)*12,D10/100000*12)","v":{"v":0,"d":"0.0"}},null,"Delikt 2",0,{"v":0.66,"d":"66%"},{"$f":"G13*H13","v":{"v":0,"d":"0.0"}}]
[null,{"$f":"F13","v":"Delikt 2"},null,{"$f":"I13","v":{"v":0,"d":"0.0"}},null,"Delikt 3",0,{"v":0.66,"d":"66%"},{"$f":"G14*H14","v":{"v":0,"d":"0.0"}}]
[null,{"$f":"F14","v":"Delikt 3"},null,{"$f":"I14","v":{"v":0,"d":"0.0"}},null,"Delikt 4",0,{"v":0.66,"d":"66%"},{"$f":"G15*H15","v":{"v":0,"d":"0.0"}}]
[null,{"$f":"F15","v":"Delikt 4"},null,{"$f":"I15","v":{"v":0,"d":"0.0"}},null,"Delikt 5",0,{"v":0.66,"d":"66%"},{"$f":"G16*H16","v":{"v":0,"d":"0.0"}}]
[{"$nulls":5},"Delikt 6",0,{"v":0.66,"d":"66%"},{"v":0,"d":"0.0"}]
[null,"Total Einsatzstrafe","in Monaten",{"$f":"SUM(D13:D17)","v":0},null,"Delikt 7",0,{"v":0.66,"d":"66%"},{"v":0,"d":"0.0"}]
[null,null,"in Jahren",{"$f":"IF(D18>11.9,D18/12,\"0\")","v":"0"},null,"Delikt 8",0,{"v":0.66,"d":"66%"},{"v":0,"d":"0.0"}]
[null,null,"in TS",{"$f":"IF(D18<11.9,D18*30,\"0\")","v":0},null,"Delikt 9",0,{"v":0.66,"d":"66%"},{"v":0,"d":"0.0"}]
[]
[null,"Korrektur Tatkomponenten",{"$nulls":3},"Total Asper.",null,null,{"$f":"SUM(I13:I21)","v":{"v":0,"d":"0.0"}}]
[null,"Zuschlag Banden-, Gewerbs- mässigkeit",{"v":0,"d":"0%"},{"$f":"D18*C23+D18","v":{"v":0,"d":"0.0"}}]
[]
[null,"Abzug Art und Weise des Vorgehens, z.B. Opferauswahl",{"v":0,"d":"0%"},{"$f":"D23-(C25*D23)","v":{"v":0,"d":"0.0"}}]
[]
[null,"Korrektur Täterkomponenten"]
[null,"Rabatt Geständnis",{"v":0,"d":"0%"},{"$f":"D25-(D25*C28)","v":{"v":0,"d":"0.0"}}]
[]
[null,"Rabatt Anzahl Geschäfte",{"v":0,"d":"0%"},{"$f":"D28-(D28*C30)","v":{"v":0,"d":"0.0"}}]
[]
[null,"Zuschlag Art und Weise des Vorgehens",{"v":0,"d":"0%"},{"$f":"D30*C32+D30","v":{"v":0,"d":"0.0"}}]
[]
[null,"Zuschlag Vorstrafen",{"v":0,"d":"0%"},{"$f":"D32*C34+D32","v":{"v":0,"d":"0.0"}}]
[]
[]
[]
[null,"Total rechnerisch","Monate",{"$f":"D34","v":{"v":0,"d":"0.0"}}]
[null,null,"Jahre",{"$f":"IF(D38>11.9,D38/12,\"0\")","v":"0"}]
[null,null,"TS",{"$f":"IF(D38<11.9,D38*30,\"0\")","v":{"v":0,"d":"0.0"}}]
[]
[null,"Korrektur Einzelfall"]
[null,"Abzug Monate für pers. Verhältn., Strafempfindlichk., Nähe zur bedingten Strafe, Dauer des Verfahrens, StGB 48,etc.",null,0]
[null,null,"Ergebnis Monate",{"$f":"D38-D43","v":{"v":0,"d":"0.0"}}]
[null,null,"Ergebnis Jahre",{"$f":"D44/12","v":{"v":0,"d":"0.0"}}]

{"sheet":"Tabelle Hansjakob","index":4,"n_rows":31,"n_cols":4,"rows_kept":31,"hidden":true}
[]
[]
[]
[]
[{"$nulls":3},"(zur Gegenprobe der Formel BetMG)"]
[]
[null,null,"Drogen"]
[null,"Mengen","und","Strafe"]
[]
[null,"Heroin","Kokain","Strafe"]
[null,"1 g","1.5 g","1 Monat"]
[null,"2 g","3 g","2 Monate"]
[null,"6 g","9 g","6 Monate"]
[null,"12 g","18 g","12 Monate"]
[null,"25 g","38 g","15 Monate"]
[null,"46 g","69 g","18 Monate"]
[null,"76 g","114 g","21 Monate"]
[null,"120 g","180 g","24 Monate"]
[null,"240 g","360 g","30 Monate"]
[null,"410 g","615 g","36 Monate"]
[null,"650 g","980 g","42 Monate"]
[null,"960 g","1.4 kg","48 Monate"]
[null,"1.9 kg","2.9 kg","5 Jahre"]
[null,"3.3 kg","4.9 kg","6 Jahre"]
[null,"5.2 kg","7.8 kg","7 Jahre"]
[null,"7.7 kg","11.6 kg","8 Jahre"]
[null,"15 kg","22.5 kg","10 Jahre"]
[null,"25.9 kg","38.9 kg","12 Jahre"]
[null,"41.1 kg","61.7 kg","14 Jahre"]
[null,"61.3 kg","92 kg","16 Jahre"]
[null,"120 kg","180 kg","20 Jahre"]

{"sheet":"Asperation StGB 49","index":5,"n_rows":15,"n_cols":5,"rows_kept":15}
[{"$nulls":4},"© 2012 FS Kunz, Köniz"]
[{"$nulls":4},"Version 7.0 02.12.2025"]
[null,"Eingabefeld StGB 49"]
[]
[null,"Zusatzdelikte","Strafe\nMte.","Anteil Asper.","Zuschlag Monate"]
[null,"Delikt 2",0,{"v":0.66,"d":"66%"},{"$f":"C6*D6","v":{"v":0,"d":"0.0"}}]
[null,"Delikt 3",0,{"v":0.66,"d":"66%"},{"$f":"C7*D7","v":{"v":0,"d":"0.0"}}]
[null,"Delikt 4",0,{"v":0.66,"d":"66%"},{"$f":"C8*D8","v":{"v":0,"d":"0.0"}}]
[null,"Delikt 5",0,{"v":0.66,"d":"66%"},{"$f":"C9*D9","v":{"v":0,"d":"0.0"}}]
[null,"Delikt 6",0,{"v":0.66,"d":"66%"},{"v":0,"d":"0.0"}]
[null,"Delikt 7",0,{"v":0.66,"d":"66%"},{"v":0,"d":"0.0"}]
[null,"Delikt 8",0,{"v":0.66,"d":"66%"},{"v":0,"d":"0.0"}]
[null,"Delikt 9",0,{"v":0.66,"d":"66%"},{"v":0,"d":"0.0"}]
[]
[null,"Total Asper.",null,null,{"$f":"SUM(E6:E14)","v":{"v":0,"d":"0.0"}}]

{"sheet":"Hafttage","index":6,"n_rows":7,"n_cols":4,"rows_kept":7}
[{"$nulls":3},"© 2012 FS Kunz, Köniz"]
[null,"Hafttage",null,"Version 7.0 02.12.2025"]
[]
[]
["Hafttage","Verhaftung","00:00:00"]
[null,"Entlassung / HV","00:00:00"]
[null,"Anzurechnen",{"$f":"C6-C5+1","v":1}]

{"sheet":"Erläuterungen","index":7,"n_rows":33,"n_cols":2,"rows_kept":33}
[]
[null,"Erläuterungen zum Strafzumessungsrechner BetMG"]
[]
[]
[null,"Allgemeines\n\nZum \"Heroinäquivalent\"\n\nDie Vorauflage des Rechners krankte daran, dass Strafen für Beschuldigte, die mit verschiedenen Substanzen handelten, nicht korrekt berechnet werden konnten. Deshalb werden neu alle (\"harten\") Drogenarten in Heroinäquivalent umgerechnet und zusammengezählt, so dass eine einheitliche Ausgangsmenge zur Berechnung der Strafe herangezogen werden kann.\n\nZur 1. Auflage der \"Tabelle Hansjakob\"\nDas Obergericht des Kantons Bern kommt in seiner neusten Rechtssprechung auf die ursprüngliche \"Tabelle Hansjakob\" zurück, weshalb diese auch wieder im Rechner abgebildet wird.\n"]
[null,"Zu den Rabatten und Zuschlägen\n\nDie Prozentabzüge und -zuschläge beziehen sich neu immer auf das Zwischenresultat, das auch laufend angezeigt wird.\n\nIn den Tabellenblättern \"Rechner BetmMG (2)\" und \"Rechner BetMG (3)\" können weitere Tatzeiträume erfasst werden. Das Resultat ist dann um den gewünschten Asperationsfaktor zu teilen\n"]
[null,"Gemeinsame Hinweise\nBis zur Schwelle der Qualifikation erfolgt die Zunahme linear.\n\nDer  Strafzumessungsrechner kann somit zunächst einmal die Lücken schliessen, die sich in der Tabelle Hansjakob ergeben.\n\nDaneben wurde aber auch versucht, die hauptsächlichsten Korrekturfaktoren in Tat- und Täterkomponente zu erfassen und quantifizierbar zu machen."]
[]
["Info zu Zelle"]
["B19","Substanzen können kumulativ eingegeben werden"]
["B21","Reine Wirkstoffmenge zur Berechnung der Einsatzstrafe"]
[]
["A31","Es kann gewählt werden zwischen Umsatz und Gewinn"]
[]
[]
[null,"Erläuterungen zum Strafzumessungsrechner Vermögensdelikte"]
[]
[null,"Ausgangslage: Deliktsbetrag 100'000.-- entspricht Freiheitsstrafe von 1 Jahr (Praxis BE)."]
[null,"Die Formel (dritte Wurzel des Resultats aus DB geteilt durch 100'000 = Anzahl Jahre) bewirkt eine exponentielle Abnahme der Zunahme des Strafmasses. Bsp: DB 3.5 Mio = 39 Monate, DB 7 Mio = 49 Monate."]
[null,"Zwischen DB 0 und 100'000 erfolgt die Zunahme der Strafe linear."]
[]
[]
[null,"Erläuterungen zur Asperation"]
[]
["Info zu Zelle"]
["F13-F15","Beispiel: \"Delikt 1\" durch \"Sachbeschädigungen\" oder \"Hausfriedensbruch\" ersetzen,"]
["G13-G15","Einsatzstrafe festlegen, in Monaten"]
["H13-H15","Asperationsgrad festlegen (üblicherweise 2/3, Prozentzahl kann abgeändert werden)"]
[]
[]
[null,"Erläuterungen zu den Hafttagen"]
[]
[null,"Es zählen sowohl der Tag der Verhaftung als auch jener der Entlassung, deshalb ergibt sich ein anrechenbarer Tag mehr als die reine Substraktion der beiden Daten. "]

{"sheet":"Mathematik","index":8,"n_rows":26,"n_cols":6,"rows_kept":26,"merged":[[2,1,2,2],[2,3,2,4]]}
[{"$nulls":5},"© 2012 FS Kunz, Köniz"]
[{"$nulls":5},"Version 7.0 02.12.2025"]
[null,"Daten aus Hansjakob, ZStrR 115/1997 S. 233"]
[]
[]
[null,"Heroin","Kokain","Strafe"]
[null,"1 g","1.5 g","1 Monat"]
[null,"2 g","3 g","2 Monate"]
[null,"6 g","9 g","6 Monate"]
[null,"12 g","18 g","12 Monate"]
[null,"25 g","37,5 g","15 Monate"]
[null,"40 g","60 g","18 Monate"]
[null,"65 g","97.5 g","21 Monate"]
[null,"96 g","144 g","24 Monate"]
[null,"185 g","277.5 g","30 Monate"]
[null,"335 g","502.5 g","36 Monate"]
[null,"770 g","1.15 kg","48 Monate"]
[null,"1.5 kg","2.25 kg","5 Jahre"]
[null,"2.6 kg","3.9 kg","6 Jahre"]
[null,"4.1 kg","6.15 kg","7 Jahre"]
[null,"6.1 kg","9.15 kg","8 Jahre"]
[null,"12 kg","18 kg","10 Jahre"]
[null,"20.7 kg","31 kg","12 Jahre"]
[null,"33 kg","50 kg","14 Jahre"]
[null,"49 kg","73.8 kg","16 Jahre"]
[null,"95 kg","142.5 kg","20 Jahre"]

{"sheet":"Bezüge","index":9,"n_rows":9,"n_cols":2,"rows_kept":9}
{"$rows_empty":7}
[null,"Umsatz"]
[null,"Gewinn"]