{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["TEXT","ROUND+PASTE SPECIAL","Paste Special","Hashtag","Zero","Conditonal formatting"],"read":"whole","date_system":"1900"}

{"sheet":"TEXT","index":0,"n_rows":11,"n_cols":3,"rows_kept":11}
["Region","Sales","Output"]
["East",{"v":2340000,"d":"$2,340,000.00"},{"$f":"TEXT(B2,\"0.0,,\")&\" M\"","v":"2.3 M"}]
["West",{"v":5870000,"d":"$5,870,000.00"},{"$f":"TEXT(B3,\"0.0,,\")&\" M\"","v":"5.9 M"}]
["North",{"v":9120000,"d":"$9,120,000.00"},"9.1 M"]
["South",{"v":3480000,"d":"$3,480,000.00"},"3.5 M"]
["Central",{"v":7650000,"d":"$7,650,000.00"},"7.7 M"]
["Northeast",{"v":1920000,"d":"$1,920,000.00"},"1.9 M"]
["Southwest",{"v":4730000,"d":"$4,730,000.00"},"4.7 M"]
["Midwest",{"v":8560000,"d":"$8,560,000.00"},"8.6 M"]
["Pacific",{"v":6210000,"d":"$6,210,000.00"},"6.2 M"]
["Southeast",{"v":3990000,"d":"$3,990,000.00"},"4.0 M"]

{"sheet":"ROUND+PASTE SPECIAL","index":1,"n_rows":11,"n_cols":2,"rows_kept":11}
["Region","Sales"]
["East","2.3 M"]
["West","5.9 M"]
["North","9.1 M"]
["South","3.5 M"]
["Central","7.7 M"]
["Northeast","1.9 M"]
["Southwest","4.7 M"]
["Midwest","8.6 M"]
["Pacific","6.2 M"]
["Southeast","4 M"]

{"sheet":"Paste Special","index":2,"n_rows":11,"n_cols":3,"rows_kept":11}
["Region","Sales","Output"]
["East",{"v":2340000,"d":"$2,340,000.00"},{"$f":"ROUND(B2/1000000,1)&\" M\"","v":"2.3 M"}]
["West",{"v":5870000,"d":"$5,870,000.00"},{"$f":"ROUND(B3/1000000,1)&\" M\"","v":"5.9 M"}]
["North",{"v":9120000,"d":"$9,120,000.00"},"9.1 M"]
["South",{"v":3480000,"d":"$3,480,000.00"},"3.5 M"]
["Central",{"v":7650000,"d":"$7,650,000.00"},"7.7 M"]
["Northeast",{"v":1920000,"d":"$1,920,000.00"},"1.9 M"]
["Southwest",{"v":4730000,"d":"$4,730,000.00"},"4.7 M"]
["Midwest",{"v":8560000,"d":"$8,560,000.00"},"8.6 M"]
["Pacific",{"v":6210000,"d":"$6,210,000.00"},"6.2 M"]
["Southeast",{"v":3990000,"d":"$3,990,000.00"},"4 M"]

{"sheet":"Hashtag","index":3,"n_rows":11,"n_cols":2,"rows_kept":11}
["Region","Sales"]
["East",{"v":2340000,"d":"2.3 M"}]
["West",{"v":5870000,"d":"5.9 M"}]
["North",{"v":9120000,"d":"9.1 M"}]
["South",{"v":3480000,"d":"3.5 M"}]
["Central",{"v":7650000,"d":"7.7 M"}]
["Northeast",{"v":1920000,"d":"1.9 M"}]
["Southwest",{"v":4730000,"d":"4.7 M"}]
["Midwest",{"v":8560000,"d":"8.6 M"}]
["Pacific",{"v":6210000,"d":"6.2 M"}]
["Southeast",{"v":3990000,"d":"4.0 M"}]

{"sheet":"Zero","index":4,"n_rows":11,"n_cols":2,"rows_kept":11}
["Region","Sales"]
["East",{"v":2340000,"d":"2.3 M "}]
["West",{"v":5870000,"d":"5.9 M "}]
["North",{"v":9120000,"d":"9.1 M "}]
["South",{"v":3480000,"d":"3.5 M "}]
["Central",{"v":7650000,"d":"7.7 M "}]
["Northeast",{"v":1920000,"d":"1.9 M "}]
["Southwest",{"v":4730000,"d":"4.7 M "}]
["Midwest",{"v":8560000,"d":"8.6 M "}]
["Pacific",{"v":6210000,"d":"6.2 M "}]
["Southeast",{"v":3990000,"d":"4.0 M "}]

{"sheet":"Conditonal formatting","index":5,"n_rows":11,"n_cols":2,"rows_kept":11}
["Region","Sales"]
["East",{"v":2340000,"d":"$2,340,000.00"}]
["West",{"v":5870000,"d":"$5,870,000.00"}]
["North",{"v":9120000,"d":"$9,120,000.00"}]
["South",{"v":3480000,"d":"$3,480,000.00"}]
["Central",{"v":7650000,"d":"$7,650,000.00"}]
["Northeast",{"v":1920000,"d":"$1,920,000.00"}]
["Southwest",{"v":4730000,"d":"$4,730,000.00"}]
["Midwest",{"v":8560000,"d":"$8,560,000.00"}]
["Pacific",{"v":6210000,"d":"$6,210,000.00"}]
["Southeast",{"v":3990000,"d":"$3,990,000.00"}]