{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Google_Suche","Optionen"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":2,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Google_Suche","index":0,"n_rows":54,"n_cols":16,"rows_kept":54,"cut":false,"hidden":false,"merged":[[43,4,50,12],[32,9,32,12],[36,9,36,12],[0,10,1,12],[30,9,30,12],[28,9,28,12],[27,4,27,7],[11,4,18,12],[0,4,1,8]]}
[{"$nulls":4},"           Such-Tool",{"$nulls":5},{"$f":"HYPERLINK(Optionen!C100,\"Suche starten\")","v":"Suche starten"}]
{"$rows_empty":8}
[{"$nulls":4},"Such-Begriffe, Such-Ausdrücke"]
{"$rows_empty":12}
[{"$nulls":4},"Genaue Übereinstimmung:",{"$nulls":10},false]
[]
[{"$nulls":4},"Suchbegriffe ergänzen (Wildcard *):",{"$nulls":10},false]
[]
[{"$nulls":4},"Preis-Einschränkung hinzufügen €:",{"$nulls":4},"von",100,"bis",250,null,null,false]
[]
[{"$nulls":4},"Suche beschränken auf Seite, Titel, Link:",{"$nulls":4},"Inhalt der Webseite",{"$nulls":5},false]
[]
[{"$nulls":4},"Suche in Sozialen Netzwerken:",{"$nulls":4},"Instagram",{"$nulls":5},false]
[]
[{"$nulls":4},"Suche in angegebener Webseite:",{"$nulls":4},"www.excel-inside.de",{"$nulls":5},false]
[]
[{"$nulls":4},"Suche in festelegten Filetypen:",{"$nulls":4},"docx","xlsx",{"$nulls":4},false]
[]
[{"$nulls":4},"Such-Location festlegen:",{"$nulls":4},"Nürnberg",{"$nulls":5},false]
[]
[]
[]
[]
[{"$nulls":4},"Von der Suche ausgeschlossene Begriffe"]
{"$rows_empty":11}
[{"$nulls":4},"DEMO-Version: Verbleibende Suchanfragen:",null,null,null,{"$f":"IF(20-n_cnt<=0,0,20-n_cnt)","v":20}]

{"sheet":"Optionen","index":1,"n_rows":100,"n_cols":49,"rows_kept":100,"cut":false,"hidden":true,"merged":[[99,2,99,4]]}
[null,"Optionen",{"$nulls":46},0]
[]
[]
[null,null,"Suchparameter","Aktiv Ja/Nein","Inhalt","Hinweis",{"$nulls":10},"Suche in"]
[]
[null,"Allgemeine Suchphrase",null,null,"https://www.google.de/#hl=de&output=search&sclient=psy-ab&q=","Wird nicht verändert"]
[]
[null,"Suchbegriffe:",null,null,{"$f":"IF(Google_Suche!E12<>\"\",Google_Suche!E12,\"\")","v":""},{"$nulls":11},"Soziale Netzwerke","@"]
[null,"Überarbeiteter Suchbegriff","\" \"",{"$f":"IF(Google_Suche!P23=TRUE,\"ja\",\"nein\")","v":"nein"},{"$f":"IF(D9=\"ja\",\"\"\"\"&E8&\"\"\"\",E8)","v":""},"Maßgeblich für Suchabfrage",{"$nulls":10},"Nach einem Preis","€","vor Preis"]
[]
[null,"Naheliegende Suchbegriff ergänzen","*",{"$f":"IF(Google_Suche!P25=TRUE,\"ja\",\"nein\")","v":"nein"},{"$f":"IF(D11=\"ja\",C11,\"\")","v":""},{"$nulls":11},"Hashtag","#"]
[]
[null,"Preisangaben von","€",{"$f":"IF(Google_Suche!P27=TRUE,\"ja\",\"\")","v":""},{"$f":"IF(D13=\"ja\",C13&Google_Suche!K27,\"\")","v":""},{"$nulls":11},"Wörter ausschließen","-"]
[null,"Preisangaben bis","€",{"$f":"IF(Google_Suche!P27=TRUE,\"ja\",\"\")","v":""},{"$f":"IF(D14=\"ja\",C14&Google_Suche!M27,\"\")","v":""},{"$nulls":11},"Genaue Übereinstimmung","\" \""]
[null,"Suchbegriff für Preisangaben",{"$f":"IF(OR(D13=\"ja\",D14=\"ja\"),\"..\",\"\")","v":""},null,{"$f":"E13&C15&E14","v":""},{"$nulls":11},"Innerhalb Zahlenbereich","€50..€100"]
[{"$nulls":16},"Suchen kombinieren","or"]
[null,"Webseite Beschränken:",null,{"$f":"IF(Google_Suche!P29=TRUE,\"ja\",\"nein\")","v":"nein"},{"$f":"IF(D17=\"ja\",Google_Suche!J29,\"\")","v":""},{"$nulls":11},"Auf bestimmter Webseite suchen","site:"]
[null,null,"Inhalt der Webseite","allintext: ",{"$nulls":12},"ähnliche Webseiten suche: ","related:"]
[null,null,"Titel der Webseite","allintitle: ",{"$nulls":12},"Suchphrase ergänzen","*"]
[null,null,"Link (Url) der Webseite","allinurl: ",{"$nulls":12},"Alle Begriffe müssen enthalten sein","allintext:"]
[{"$nulls":4},{"$f":"IFERROR(VLOOKUP(E17,$C$18:$D$20,2,0),\"\")","v":""},"Maßgebliche Suchabfrage",{"$nulls":10},"Alle Begriffe müssen im Titel enthalten sein","allintitle:"]
[{"$nulls":16},"Alle Begriffe müssen in der URL enthalten sein","allinurl:"]
[null,"Suche in Sozialen Netzwerken","@",{"$f":"IF(Google_Suche!P31=TRUE,\"ja\",\"nein\")","v":"nein"},{"$f":"IF(D23=\"ja\",Google_Suche!J31,\"\")","v":""},{"$nulls":11},"Findet Dokumente mit dem angegeben Filtype","filetype: auch mit or möglich"]
[{"$nulls":4},{"$f":"IF(D23=\"ja\",C23&E23&\" \",\"\")","v":""},"Maßgebliche Suchabfrage"]
[]
[null,"Suche in angegebener Webseite:","site:",{"$f":"IF(Google_Suche!P33=TRUE,\"ja\",\"nein\")","v":"nein"},{"$f":"IF(D26=\"ja\",C26 &Google_Suche!J33 & \" \",\"\")","v":""}]
[]
[null,"Suche in angegebenen File-Typ: ","filetype:",{"$f":"IF(Google_Suche!P35=TRUE,\"ja\",\"nein\")","v":"nein"}]
[null,1,null,{"$f":"Google_Suche!J35","v":"docx"},{"$f":"IF($D$28=\"ja\",IF(D29<>0,$C$28 &D29& \" \",\"\"),\"\")","v":""}]
[null,2,null,{"$f":"Google_Suche!K35","v":"xlsx"},"",{"$f":"IF(E30<>\"\",\"OR \",\"\")","v":""}]
[null,3,null,{"$f":"Google_Suche!L35","v":0},"",{"$f":"IF(E31<>\"\",\"OR \",\"\")","v":""}]
[null,4,null,{"$f":"Google_Suche!M35","v":0},{"$f":"IF($D$28=\"ja\",IF(D32<>0,$C$28 &D32& \" \",\"\"),\"\")","v":""},{"$f":"IF(E32<>\"\",\"OR \",\"\")","v":""}]
[{"$nulls":4},{"$f":"E29&F30&E30&F31&E31&F32&E32","v":""}]
[]
[null,"Suche in angegebener Location:"," location:",{"$f":"IF(Google_Suche!P37=TRUE,\"ja\",\"nein\")","v":"nein"},{"$f":"IF(D35=\"ja\",C35 &Google_Suche!J37 & \" \",\"\")","v":""}]
[]
[]
[]
[null,"Ausgeschlossene Begriffe:","-",{"$f":"IF(Google_Suche!E44<>\"\",\"ja\",\"nein\")","v":"nein"},{"$f":"IF(D39=\"ja\",Google_Suche!E44,\"\")","v":""},"Länge","erstes Zeichen","Zusammengesetzter String"]
[{"$nulls":4},{"$f":"MID($E$39,G40,F40-1)","v":{"$error":"#VALUE!"}},{"$f":"SEARCH(\" \",$E$39,G40)","v":{"$error":"#VALUE!"}},1,{"$f":"C39&E40","v":{"$error":"#VALUE!"}}]
[{"$nulls":4},{"$f":"MID($E$39,G41,F41-1)","v":{"$error":"#VALUE!"}},{"$f":"IF(ISERROR(SEARCH(\" \",$E$39,G41)-SUM($F$40:F40)),LEN($E$39),SEARCH(\" \",$E$39,G41)-SUM($F$40:F40))","v":0},{"$f":"SUM($F$40:F40)+1","v":{"$error":"#VALUE!"}},{"$f":"H40& \" \" &IF(E41<>\"\",$C$39,\"\")&E41","v":{"$error":"#VALUE!"}}]
[{"$nulls":4},{"$f":"MID($E$39,G42,F42-1)","v":{"$error":"#VALUE!"}},{"$f":"IF(ISERROR(SEARCH(\" \",$E$39,G42)-SUM($F$40:F41)),LEN($E$39),SEARCH(\" \",$E$39,G42)-SUM($F$40:F41))","v":0},{"$f":"SUM($F$40:F41)+1","v":{"$error":"#VALUE!"}},{"$f":"H41& \" \" &IF(E42<>\"\",$C$39,\"\")&E42","v":{"$error":"#VALUE!"}}]
[{"$nulls":4},{"$error":"#VALUE!"},{"$f":"IF(ISERROR(SEARCH(\" \",$E$39,G43)-SUM($F$40:F42)),LEN($E$39),SEARCH(\" \",$E$39,G43)-SUM($F$40:F42))","v":0},{"$f":"SUM($F$40:F42)+1","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[{"$nulls":4},{"$error":"#VALUE!"},{"$f":"IF(ISERROR(SEARCH(\" \",$E$39,G44)-SUM($F$40:F43)),LEN($E$39),SEARCH(\" \",$E$39,G44)-SUM($F$40:F43))","v":0},{"$f":"SUM($F$40:F43)+1","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[{"$nulls":4},{"$error":"#VALUE!"},{"$f":"IF(ISERROR(SEARCH(\" \",$E$39,G45)-SUM($F$40:F44)),LEN($E$39),SEARCH(\" \",$E$39,G45)-SUM($F$40:F44))","v":0},{"$f":"SUM($F$40:F44)+1","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[{"$nulls":4},{"$error":"#VALUE!"},{"$f":"IF(ISERROR(SEARCH(\" \",$E$39,G46)-SUM($F$40:F45)),LEN($E$39),SEARCH(\" \",$E$39,G46)-SUM($F$40:F45))","v":0},{"$f":"SUM($F$40:F45)+1","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[{"$nulls":4},{"$error":"#VALUE!"},{"$f":"IF(ISERROR(SEARCH(\" \",$E$39,G47)-SUM($F$40:F46)),LEN($E$39),SEARCH(\" \",$E$39,G47)-SUM($F$40:F46))","v":0},{"$f":"SUM($F$40:F46)+1","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[{"$nulls":4},{"$error":"#VALUE!"},{"$f":"IF(ISERROR(SEARCH(\" \",$E$39,G48)-SUM($F$40:F47)),LEN($E$39),SEARCH(\" \",$E$39,G48)-SUM($F$40:F47))","v":0},{"$f":"SUM($F$40:F47)+1","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[{"$nulls":4},{"$f":"MID($E$39,G49,F49-1)","v":{"$error":"#VALUE!"}},{"$f":"IF(ISERROR(SEARCH(\" \",$E$39,G49)-SUM($F$40:F48)),LEN($E$39),SEARCH(\" \",$E$39,G49)-SUM($F$40:F48))","v":0},{"$f":"SUM($F$40:F48)+1","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[{"$nulls":4},{"$error":"#VALUE!"},{"$f":"IF(ISERROR(SEARCH(\" \",$E$39,G50)-SUM($F$40:F49)),LEN($E$39),SEARCH(\" \",$E$39,G50)-SUM($F$40:F49))","v":0},{"$f":"SUM($F$40:F49)+1","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[{"$nulls":4},{"$f":"MID($E$39,G51,F51-1)","v":{"$error":"#VALUE!"}},{"$f":"IF(ISERROR(SEARCH(\" \",$E$39,G51)-SUM($F$40:F50)),LEN($E$39),SEARCH(\" \",$E$39,G51)-SUM($F$40:F50))","v":0},{"$f":"SUM($F$40:F50)+1","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[{"$nulls":4},{"$error":"#VALUE!"},{"$f":"IF(ISERROR(SEARCH(\" \",$E$39,G52)-SUM($F$40:F51)),LEN($E$39),SEARCH(\" \",$E$39,G52)-SUM($F$40:F51))","v":0},{"$f":"SUM($F$40:F51)+1","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[{"$nulls":4},{"$error":"#VALUE!"},{"$f":"IF(ISERROR(SEARCH(\" \",$E$39,G53)-SUM($F$40:F52)),LEN($E$39),SEARCH(\" \",$E$39,G53)-SUM($F$40:F52))","v":0},{"$f":"SUM($F$40:F52)+1","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[{"$nulls":4},{"$error":"#VALUE!"},{"$f":"IF(ISERROR(SEARCH(\" \",$E$39,G54)-SUM($F$40:F53)),LEN($E$39),SEARCH(\" \",$E$39,G54)-SUM($F$40:F53))","v":0},{"$f":"SUM($F$40:F53)+1","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[]
[null,"Zusammengesetzter String ",null,null,{"$f":"IF(OR(ISERROR(H54),ISERROR(E40)),E39,H54)","v":""}]
{"$rows_empty":41}
[null,"Erstellung des Hyperlinks"]
[]
[null,"Zusammengesetzter String",{"$f":"E6&E24&E21&E26&E9&\" \"&E11&E15&E35&E33&E56","v":"https://www.google.de/#hl=de&output=search&sclient=psy-ab&q= "},null,null,{"$f":"HYPERLINK(C100,\"Google-Suche\")","v":"Google-Suche"}]