{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Sheet1","Sample 1","Sample 2","Pivot_Nova","Pivot_Luna","Single Cell","Specific Data","Multiple Pivot Table"],"not_rendered":{"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":11,"n_cols":4,"rows_kept":11}
["Employee Name","Department","Project","Salary"]
["Olivia","IT","Project Nova",{"v":6500,"d":"$6,500"}]
["Liam","Finance","Project Orion",{"v":5800,"d":"$5,800"}]
["Ava","Marketing","Project Nova",{"v":4700,"d":"$4,700"}]
["Mason","IT","Project Orion",{"v":6200,"d":"$6,200"}]
["Mia","Marketing","Project Nova",{"v":4750,"d":"$4,750"}]
["Ethan","Finance","Project Nova",{"v":5500,"d":"$5,500"}]
["James","IT","Project Orion",{"v":6300,"d":"$6,300"}]
["Isabella","Marketing","Project Orion",{"v":4900,"d":"$4,900"}]
["Sophia","Finance","Project Nova",{"v":5600,"d":"$5,600"}]
["Noah","Marketing","Project Orion",{"v":4800,"d":"$4,800"}]

{"sheet":"Sample 1","index":1,"n_rows":11,"n_cols":4,"rows_kept":11}
["Employee Name","Department","Project","Salary"]
["Olivia","IT","Project Nova",{"v":6500,"d":"$6,500"}]
["Liam","Finance","Project Nova",{"v":5800,"d":"$5,800"}]
["Ava","Marketing","Project Nova",{"v":4700,"d":"$4,700"}]
["Mason","IT","Project Nova",{"v":6200,"d":"$6,200"}]
["Mia","Marketing","Project Nova",{"v":4750,"d":"$4,750"}]
["Ethan","Finance","Project Nova",{"v":5500,"d":"$5,500"}]
["James","IT","Project Nova",{"v":6300,"d":"$6,300"}]
["Isabella","Marketing","Project Nova",{"v":4900,"d":"$4,900"}]
["Sophia","Finance","Project Nova",{"v":5600,"d":"$5,600"}]
["Noah","Marketing","Project Nova",{"v":4800,"d":"$4,800"}]

{"sheet":"Sample 2","index":2,"n_rows":11,"n_cols":4,"rows_kept":11}
["Employee Name","Department","Project","Salary"]
["Harper","Sales","Project Luna",{"v":5200,"d":"$5,200"}]
["Jack","Procurement","Project Luna",{"v":4900,"d":"$4,900"}]
["Ella","Operations","Project Luna",{"v":4600,"d":"$4,600"}]
["Carter","Sales","Project Luna",{"v":5400,"d":"$5,400"}]
["Grace","Procurement","Project Luna",{"v":4850,"d":"$4,850"}]
["Henry","Operations","Project Luna",{"v":4700,"d":"$4,700"}]
["Chloe","Sales","Project Luna",{"v":5300,"d":"$5,300"}]
["Lucas","Procurement","Project Luna",{"v":4950,"d":"$4,950"}]
["Lily","Operations","Project Luna",{"v":4650,"d":"$4,650"}]
["Daniel","Sales","Project Luna",{"v":5250,"d":"$5,250"}]

{"sheet":"Pivot_Nova","index":3,"n_rows":14,"n_cols":4,"rows_kept":14}
[]
[]
["Project","Employee Name","Department","Sum of Salary"]
["Project Nova","Ava","Marketing",{"v":4700,"d":"$4,700"}]
[null,"Ethan","Finance",{"v":5500,"d":"$5,500"}]
[null,"Isabella","Marketing",{"v":4900,"d":"$4,900"}]
[null,"James","IT",{"v":6300,"d":"$6,300"}]
[null,"Liam","Finance",{"v":5800,"d":"$5,800"}]
[null,"Mason","IT",{"v":6200,"d":"$6,200"}]
[null,"Mia","Marketing",{"v":4750,"d":"$4,750"}]
[null,"Noah","Marketing",{"v":4800,"d":"$4,800"}]
[null,"Olivia","IT",{"v":6500,"d":"$6,500"}]
[null,"Sophia","Finance",{"v":5600,"d":"$5,600"}]
["Grand Total",null,null,{"v":55050,"d":"$55,050"}]

{"sheet":"Pivot_Luna","index":4,"n_rows":14,"n_cols":4,"rows_kept":14}
[]
[]
["Project","Employee Name","Department","Sum of Salary"]
["Project Luna","Carter","Sales",{"v":5400,"d":"$5,400"}]
[null,"Chloe","Sales",{"v":5300,"d":"$5,300"}]
[null,"Daniel","Sales",{"v":5250,"d":"$5,250"}]
[null,"Ella","Operations",{"v":4600,"d":"$4,600"}]
[null,"Grace","Procurement",{"v":4850,"d":"$4,850"}]
[null,"Harper","Sales",{"v":5200,"d":"$5,200"}]
[null,"Henry","Operations",{"v":4700,"d":"$4,700"}]
[null,"Jack","Procurement",{"v":4900,"d":"$4,900"}]
[null,"Lily","Operations",{"v":4650,"d":"$4,650"}]
[null,"Lucas","Procurement",{"v":4950,"d":"$4,950"}]
["Grand Total",null,null,{"v":49800,"d":"$49,800"}]

{"sheet":"Single Cell","index":5,"n_rows":12,"n_cols":2,"rows_kept":12}
["Employee Name","Salary"]
["Olivia",{"v":6500,"d":"$6,500"}]
["Liam",{"v":5800,"d":"$5,800"}]
["Ava",{"v":4700,"d":"$4,700"}]
["Mason",{"v":6200,"d":"$6,200"}]
["Mia",{"v":4750,"d":"$4,750"}]
["Ethan",{"v":5500,"d":"$5,500"}]
["James",{"v":6300,"d":"$6,300"}]
["Isabella",{"v":4900,"d":"$4,900"}]
["Sophia",{"v":5600,"d":"$5,600"}]
["Noah",{"v":4800,"d":"$4,800"}]
["Total Salary",{"$f":"GETPIVOTDATA(\"Salary\",Pivot_Nova!$A$3)","v":{"v":55050,"d":"$55,050"}}]

{"sheet":"Specific Data","index":6,"n_rows":11,"n_cols":2,"rows_kept":11}
["Employee Name","Salary"]
["Olivia",{"$f":"GETPIVOTDATA(\"Salary\",Pivot_Nova!$A$3,\"Employee Name\",A2)","v":{"v":6500,"d":"$6,500"}}]
["Liam",{"$f":"GETPIVOTDATA(\"Salary\",Pivot_Nova!$A$3,\"Employee Name\",A3)","v":{"v":5800,"d":"$5,800"}}]
["Ava",{"$f":"GETPIVOTDATA(\"Salary\",Pivot_Nova!$A$3,\"Employee Name\",A4)","v":{"v":4700,"d":"$4,700"}}]
["Mason",{"$f":"GETPIVOTDATA(\"Salary\",Pivot_Nova!$A$3,\"Employee Name\",A5)","v":{"v":6200,"d":"$6,200"}}]
["Mia",{"$f":"GETPIVOTDATA(\"Salary\",Pivot_Nova!$A$3,\"Employee Name\",A6)","v":{"v":4750,"d":"$4,750"}}]
["Ethan",{"$f":"GETPIVOTDATA(\"Salary\",Pivot_Nova!$A$3,\"Employee Name\",A7)","v":{"v":5500,"d":"$5,500"}}]
["James",{"$f":"GETPIVOTDATA(\"Salary\",Pivot_Nova!$A$3,\"Employee Name\",A8)","v":{"v":6300,"d":"$6,300"}}]
["Isabella",{"$f":"GETPIVOTDATA(\"Salary\",Pivot_Nova!$A$3,\"Employee Name\",A9)","v":{"v":4900,"d":"$4,900"}}]
["Sophia",{"$f":"GETPIVOTDATA(\"Salary\",Pivot_Nova!$A$3,\"Employee Name\",A10)","v":{"v":5600,"d":"$5,600"}}]
["Noah",{"$f":"GETPIVOTDATA(\"Salary\",Pivot_Nova!$A$3,\"Employee Name\",A11)","v":{"v":4800,"d":"$4,800"}}]

{"sheet":"Multiple Pivot Table","index":7,"n_rows":2,"n_cols":2,"rows_kept":2}
["Project Name","Salary"]
["Luna",{"$f":"GETPIVOTDATA(\"Salary\",INDIRECT(\"Pivot_\" & A2 & \"!$A$3\"))","v":{"v":49800,"d":"$49,800"}}]