{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Data Entry Form"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"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":"Data Entry Form","index":0,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[[3,1,3,3],[7,2,7,3]]}
[]
[]
[]
[null,"Data Entry Form"]
[]
[null,"Author","Ablebits.com"]
[null,"Last update","2021-02-12"]
[null,"Tutorial URL","Using data entry form in Excel"]
[]
[]
[null,"Project","Department","Start date","Budget","Actual cost","Threshold (5%)"]
[null,"Bigfoot ","Planning","2021-01-08",250000,256100,{"$f":"IF(ABS(Table1[[#This Row],[Actual cost]]/ Table1[[#This Row],[Budget]]- 1)<=5%, \"Within budget\", IF(Table1[[#This Row],[Actual cost]]/Table1[[#This Row],[Budget]]-1>5%, \"Over budget\", IF(Table1[[#This Row],[Actual cost]]/ Table1[[#This Row],[Budget]]-1<5%, \"Under budget\", \"\")))","v":"Within budget"}]
[null,"Cascade","Design","2021-03-24",370000,363700,{"$f":"IF(ABS(Table1[[#This Row],[Actual cost]]/ Table1[[#This Row],[Budget]]- 1)<=5%, \"Within budget\", IF(Table1[[#This Row],[Actual cost]]/Table1[[#This Row],[Budget]]-1>5%, \"Over budget\", IF(Table1[[#This Row],[Actual cost]]/ Table1[[#This Row],[Budget]]-1<5%, \"Under budget\", \"\")))","v":"Within budget"}]
[null,"Hornets","Testing","2021-02-04",540000,571900,{"$f":"IF(ABS(Table1[[#This Row],[Actual cost]]/ Table1[[#This Row],[Budget]]- 1)<=5%, \"Within budget\", IF(Table1[[#This Row],[Actual cost]]/Table1[[#This Row],[Budget]]-1>5%, \"Over budget\", IF(Table1[[#This Row],[Actual cost]]/ Table1[[#This Row],[Budget]]-1<5%, \"Under budget\", \"\")))","v":"Over budget"}]
[null,"Mercury","Design","2021-03-01",150000,136200,{"$f":"IF(ABS(Table1[[#This Row],[Actual cost]]/ Table1[[#This Row],[Budget]]- 1)<=5%, \"Within budget\", IF(Table1[[#This Row],[Actual cost]]/Table1[[#This Row],[Budget]]-1>5%, \"Over budget\", IF(Table1[[#This Row],[Actual cost]]/ Table1[[#This Row],[Budget]]-1<5%, \"Under budget\", \"\")))","v":"Under budget"}]
[null,"Peak-Blast","Planning","2021-01-20",710000,736400,{"$f":"IF(ABS(Table1[[#This Row],[Actual cost]]/ Table1[[#This Row],[Budget]]- 1)<=5%, \"Within budget\", IF(Table1[[#This Row],[Actual cost]]/Table1[[#This Row],[Budget]]-1>5%, \"Over budget\", IF(Table1[[#This Row],[Actual cost]]/ Table1[[#This Row],[Budget]]-1<5%, \"Under budget\", \"\")))","v":"Within budget"}]
[null,"Skill-Up","Testing","2021-01-18",400000,373500,{"$f":"IF(ABS(Table1[[#This Row],[Actual cost]]/ Table1[[#This Row],[Budget]]- 1)<=5%, \"Within budget\", IF(Table1[[#This Row],[Actual cost]]/Table1[[#This Row],[Budget]]-1>5%, \"Over budget\", IF(Table1[[#This Row],[Actual cost]]/ Table1[[#This Row],[Budget]]-1<5%, \"Under budget\", \"\")))","v":"Under budget"}]
[null,"Sputnik","Design","2021-01-20",530000,538200,{"$f":"IF(ABS(Table1[[#This Row],[Actual cost]]/ Table1[[#This Row],[Budget]]- 1)<=5%, \"Within budget\", IF(Table1[[#This Row],[Actual cost]]/Table1[[#This Row],[Budget]]-1>5%, \"Over budget\", IF(Table1[[#This Row],[Actual cost]]/ Table1[[#This Row],[Budget]]-1<5%, \"Under budget\", \"\")))","v":"Within budget"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"  "]