{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","Inside For loop","Student Marks","Cumulative Value","Sales target FillUp","Exit Loop when Condition Met"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Dataset","index":0,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Sample Dataset"]
[]
[null,"Order ID","Customer Name","Order Status"]
[null,1,"John Doe","Pending"]
[null,2,"Jane Smith","Shipped"]
[null,3,"Mark Davis","Pending"]
[null,4,"Emily White","Shipped"]
[null,5,"Alex Brown","Shipped"]

{"sheet":"Inside For loop","index":1,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Return Order Id Using Do While with Exit Do inside of the For Loop "]
[]
[null,"Order ID","Customer Name","Order Status"]
[null,1,"John Doe","Pending"]
[null,2,"Jane Smith","Shipped"]
[null,3,"Mark Davis","Pending"]
[null,4,"Emily White","Shipped"]
[null,5,"Alex Brown","Shipped"]

{"sheet":"Student Marks","index":2,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Return Student Marks Using Exit Do inside Do While Loop"]
[]
[null,"StudentID","Subject","Mark"]
[null,1001,"Mathematics",85]
[null,1001,"Science",78]
[null,1001,"English",92]
[null,1002,"Mathematics",92]
[null,1002,"Science",88]
[null,1002,"English",90]
[null,1003,"Mathematics",76]
[null,1003,"Science",82]
[null,1003,"English",85]
[null,1004,"Mathematics",90]
[null,1004,"Science",94]
[null,1004,"English",88]
[null,1005,"Mathematics",80]
[null,1005,"Science",85]
[null,1005,"English",91]

{"sheet":"Cumulative Value","index":3,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[3,5,3,6],[4,5,4,6],[1,1,1,6]]}
[]
[null,"Return Month Where Sales Target Met"]
[]
[null,"Months","Sales Value","Cumulative Value",null,"Total Sales Target"]
[null,"January",1000,{"$f":"C5","v":1000},null,8000]
[null,"February",2500,{"$f":"C6+D5","v":3500}]
[null,"March",3500,{"$f":"C7+D6","v":7000}]
[null,"April",6500,{"$f":"C8+D7","v":13500}]
[null,"May",4800,{"$f":"C9+D8","v":18300}]

{"sheet":"Sales target FillUp","index":4,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Use of Do While Loop with Exit Do to Get Customer Id"]
[]
[null,"Customer ID","Product Category","Product Name","Price",null,"Target Sales"]
[null,1001,"Electronics","Laptop",1200,null,1500]
[null,1002,"Electronics","Headphones",300]
[null,1002,"Clothing","T-Shirt",20]
[null,1003,"Electronics","Smartphone",800]
[null,1002,"Clothing","Jeans",60]
[null,1004,"Electronics","Headphones",300]
[null,1003,"Books","Novel",15]
[null,1003,"Books","Textbook",80]
[null,1005,"Beauty","Skincare",30]
[null,1005,"Beauty","Makeup",50]

{"sheet":"Exit Loop when Condition Met","index":5,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Exit Do While Loop When Condition Met"]
[]
[null,"Employee Name","Sales Amount","Total Sales Value",null,"Sales Criteria"]
[null,"John Smith",1500,{"$f":"C5","v":1500},null,7000]
[null,"Emily Johnson",2000,{"$f":"C6+D5","v":3500}]
[null,"Michael Brown",1800,{"$f":"C7+D6","v":5300}]
[null,"Sarah Davis",2200,7500]
[null,"David Wilson",1600,9100]