Untitled
unknown
json
2 months ago
32 kB
6
Indexable
{
"data": [
[
{
"value": "Products",
"cellAddress": "A3"
},
{
"value": "North",
"cellAddress": "B3"
},
{
"value": "South",
"cellAddress": "C3"
},
{
"value": "West",
"cellAddress": "D3"
},
{
"value": "East",
"cellAddress": "E3"
}
],
[
{
"value": "Smartphones",
"cellAddress": "A4"
},
{
"value": 28,
"cellAddress": "B4"
},
{
"value": 42,
"cellAddress": "C4"
},
{
"value": 38,
"cellAddress": "D4"
},
{
"value": 35,
"cellAddress": "E4"
}
],
[
{
"value": "Keyboards",
"cellAddress": "A5"
},
{
"value": 37,
"cellAddress": "B5"
},
{
"value": 51,
"cellAddress": "C5"
},
{
"value": 79,
"cellAddress": "D5"
},
{
"value": 23,
"cellAddress": "E5"
}
],
[
{
"value": "Monitors",
"cellAddress": "A6"
},
{
"value": 56,
"cellAddress": "B6"
},
{
"value": 55,
"cellAddress": "C6"
},
{
"value": 25,
"cellAddress": "D6"
},
{
"value": 27,
"cellAddress": "E6"
}
],
[
{
"value": "Tablets",
"cellAddress": "A7"
},
{
"value": 35,
"cellAddress": "B7"
},
{
"value": 51,
"cellAddress": "C7"
},
{
"value": 56,
"cellAddress": "D7"
},
{
"value": 59,
"cellAddress": "E7"
}
],
[
{
"value": "Laptops",
"cellAddress": "A8"
},
{
"value": 43,
"cellAddress": "B8"
},
{
"value": 25,
"cellAddress": "C8"
},
{
"value": 52,
"cellAddress": "D8"
},
{
"value": 48,
"cellAddress": "E8"
}
],
[
{
"value": "Create a stacked column chart showing the total quantity ordered by product, grouped by region, using the provided data",
"cellAddress": "A10"
},
{
"value": {
"formula": "SUM(D4:D8)",
"result": 250
},
"cellAddress": "H10"
}
],
[
{
"value": "Salesperson",
"cellAddress": "A13"
},
{
"value": "North",
"cellAddress": "B13"
},
{
"value": "South",
"cellAddress": "C13"
},
{
"value": "West",
"cellAddress": "D13"
},
{
"value": "East",
"cellAddress": "E13"
}
],
[
{
"value": "Aaron",
"cellAddress": "A14"
},
{
"value": 54,
"cellAddress": "B14"
},
{
"value": 8,
"cellAddress": "C14"
},
{
"value": 38,
"cellAddress": "D14"
},
{
"value": 28,
"cellAddress": "E14"
}
],
[
{
"value": "Alyssa",
"cellAddress": "A15"
},
{
"value": 12,
"cellAddress": "B15"
},
{
"value": 35,
"cellAddress": "C15"
},
{
"value": 26,
"cellAddress": "D15"
},
{
"value": 6,
"cellAddress": "E15"
}
],
[
{
"value": "Dennis",
"cellAddress": "A16"
},
{
"value": 35,
"cellAddress": "B16"
},
{
"value": 32,
"cellAddress": "C16"
},
{
"value": 47,
"cellAddress": "D16"
},
{
"value": 54,
"cellAddress": "E16"
}
],
[
{
"value": "Jesse",
"cellAddress": "A17"
},
{
"value": 0,
"cellAddress": "B17"
},
{
"value": 8,
"cellAddress": "C17"
},
{
"value": 2,
"cellAddress": "D17"
},
{
"value": 14,
"cellAddress": "E17"
}
],
[
{
"value": "Jessica",
"cellAddress": "A18"
},
{
"value": 31,
"cellAddress": "B18"
},
{
"value": 12,
"cellAddress": "C18"
},
{
"value": 25,
"cellAddress": "D18"
},
{
"value": 2,
"cellAddress": "E18"
}
],
[
{
"value": "Jordan",
"cellAddress": "A19"
},
{
"value": 15,
"cellAddress": "B19"
},
{
"value": 80,
"cellAddress": "C19"
},
{
"value": 40,
"cellAddress": "D19"
},
{
"value": 29,
"cellAddress": "E19"
}
],
[
{
"value": "Justin",
"cellAddress": "A20"
},
{
"value": 33,
"cellAddress": "B20"
},
{
"value": 0,
"cellAddress": "C20"
},
{
"value": 54,
"cellAddress": "D20"
},
{
"value": 14,
"cellAddress": "E20"
}
],
[
{
"value": "Keith",
"cellAddress": "A21"
},
{
"value": 3,
"cellAddress": "B21"
},
{
"value": 39,
"cellAddress": "C21"
},
{
"value": 13,
"cellAddress": "D21"
},
{
"value": 45,
"cellAddress": "E21"
}
],
[
{
"value": "Tony",
"cellAddress": "A22"
},
{
"value": 16,
"cellAddress": "B22"
},
{
"value": 10,
"cellAddress": "C22"
},
{
"value": 5,
"cellAddress": "D22"
},
{
"value": 0,
"cellAddress": "E22"
}
],
[
{
"value": {
"richText": [
{
"font": {
"bold": true,
"size": 11,
"color": {
"argb": "FF000000"
},
"name": "Calibri"
},
"text": "Prompt to LLM = \""
},
{
"font": {
"bold": true,
"size": 11,
"color": {
"argb": "FF0000FF"
},
"name": "Calibri"
},
"text": " Create a stacked column chart showing the total quantity ordered by Salesperson, grouped by region, using the provided data "
},
{
"font": {
"bold": true,
"size": 11,
"color": {
"argb": "FF000000"
},
"name": "Calibri"
},
"text": "\""
}
]
},
"cellAddress": "A25"
}
],
[
{
"value": "Product",
"cellAddress": "A27"
},
{
"value": "2025-01-01T00:00:00.000Z",
"cellAddress": "B27"
},
{
"value": "2025-02-01T00:00:00.000Z",
"cellAddress": "C27"
},
{
"value": "2025-03-01T00:00:00.000Z",
"cellAddress": "D27"
},
{
"value": "2025-04-01T00:00:00.000Z",
"cellAddress": "E27"
},
{
"value": "2025-05-01T00:00:00.000Z",
"cellAddress": "F27"
},
{
"value": "2025-06-01T00:00:00.000Z",
"cellAddress": "G27"
},
{
"value": "2025-07-01T00:00:00.000Z",
"cellAddress": "H27"
},
{
"value": "2025-08-01T00:00:00.000Z",
"cellAddress": "I27"
},
{
"value": "2025-09-01T00:00:00.000Z",
"cellAddress": "J27"
},
{
"value": "2025-10-01T00:00:00.000Z",
"cellAddress": "K27"
},
{
"value": "2025-11-01T00:00:00.000Z",
"cellAddress": "L27"
},
{
"value": "2025-12-01T00:00:00.000Z",
"cellAddress": "M27"
}
],
[
{
"value": "Smartphones",
"cellAddress": "A28"
},
{
"value": 3203,
"cellAddress": "B28"
},
{
"value": 1280,
"cellAddress": "C28"
},
{
"value": 5032,
"cellAddress": "D28"
},
{
"value": 1012,
"cellAddress": "E28"
},
{
"value": 1824,
"cellAddress": "F28"
},
{
"value": 3283,
"cellAddress": "G28"
},
{
"value": 3396,
"cellAddress": "H28"
},
{
"value": 0,
"cellAddress": "I28"
},
{
"value": 0,
"cellAddress": "J28"
},
{
"value": 1013,
"cellAddress": "K28"
},
{
"value": 3335,
"cellAddress": "L28"
},
{
"value": 4318,
"cellAddress": "M28"
}
],
[
{
"value": "Keyboards",
"cellAddress": "A29"
},
{
"value": 1628,
"cellAddress": "B29"
},
{
"value": 1026,
"cellAddress": "C29"
},
{
"value": 2762,
"cellAddress": "D29"
},
{
"value": 2946,
"cellAddress": "E29"
},
{
"value": 754,
"cellAddress": "F29"
},
{
"value": 3879,
"cellAddress": "G29"
},
{
"value": 541,
"cellAddress": "H29"
},
{
"value": 7636,
"cellAddress": "I29"
},
{
"value": 692,
"cellAddress": "J29"
},
{
"value": 2951,
"cellAddress": "K29"
},
{
"value": 1828,
"cellAddress": "L29"
},
{
"value": 5762,
"cellAddress": "M29"
}
],
[
{
"value": "Monitors",
"cellAddress": "A30"
},
{
"value": 2500,
"cellAddress": "B30"
},
{
"value": 1785,
"cellAddress": "C30"
},
{
"value": 2031,
"cellAddress": "D30"
},
{
"value": 3532,
"cellAddress": "E30"
},
{
"value": 2465,
"cellAddress": "F30"
},
{
"value": 0,
"cellAddress": "G30"
},
{
"value": 3123,
"cellAddress": "H30"
},
{
"value": 0,
"cellAddress": "I30"
},
{
"value": 3653,
"cellAddress": "J30"
},
{
"value": 2884,
"cellAddress": "K30"
},
{
"value": 1884,
"cellAddress": "L30"
},
{
"value": 3364,
"cellAddress": "M30"
}
],
[
{
"value": "Tablets",
"cellAddress": "A31"
},
{
"value": 1494,
"cellAddress": "B31"
},
{
"value": 2293,
"cellAddress": "C31"
},
{
"value": 2507,
"cellAddress": "D31"
},
{
"value": 2297,
"cellAddress": "E31"
},
{
"value": 2936,
"cellAddress": "F31"
},
{
"value": 1646,
"cellAddress": "G31"
},
{
"value": 0,
"cellAddress": "H31"
},
{
"value": 1092,
"cellAddress": "I31"
},
{
"value": 1545,
"cellAddress": "J31"
},
{
"value": 0,
"cellAddress": "K31"
},
{
"value": 1531,
"cellAddress": "L31"
},
{
"value": 0,
"cellAddress": "M31"
}
],
[
{
"value": "Laptops",
"cellAddress": "A32"
},
{
"value": 939,
"cellAddress": "B32"
},
{
"value": 3366,
"cellAddress": "C32"
},
{
"value": 3148,
"cellAddress": "D32"
},
{
"value": 0,
"cellAddress": "E32"
},
{
"value": 0,
"cellAddress": "F32"
},
{
"value": 1686,
"cellAddress": "G32"
},
{
"value": 1850,
"cellAddress": "H32"
},
{
"value": 1458,
"cellAddress": "I32"
},
{
"value": 6562,
"cellAddress": "J32"
},
{
"value": 4058,
"cellAddress": "K32"
},
{
"value": 0,
"cellAddress": "L32"
},
{
"value": 0,
"cellAddress": "M32"
}
],
[
{
"value": {
"richText": [
{
"font": {
"bold": true,
"size": 11,
"color": {
"argb": "FF000000"
},
"name": "Calibri"
},
"text": "Prompt to LLM = \""
},
{
"font": {
"bold": true,
"size": 11,
"color": {
"argb": "FF0000FF"
},
"name": "Calibri"
},
"text": " Create a line chart of monthly sales by product "
},
{
"font": {
"bold": true,
"size": 11,
"color": {
"argb": "FF000000"
},
"name": "Calibri"
},
"text": "\""
}
]
},
"cellAddress": "A34"
}
],
[
{
"value": "Product",
"cellAddress": "A36"
},
{
"value": "Total Revenue",
"cellAddress": "B36"
}
],
[
{
"value": "Smartphones",
"cellAddress": "A37"
},
{
"value": 27696,
"cellAddress": "B37"
}
],
[
{
"value": "Keyboards",
"cellAddress": "A38"
},
{
"value": 32405,
"cellAddress": "B38"
}
],
[
{
"value": "Monitors",
"cellAddress": "A39"
},
{
"value": 27221,
"cellAddress": "B39"
}
],
[
{
"value": "Tablets",
"cellAddress": "A40"
},
{
"value": 17341,
"cellAddress": "B40"
}
],
[
{
"value": "Laptops",
"cellAddress": "A41"
},
{
"value": 23067,
"cellAddress": "B41"
}
],
[
{
"value": {
"richText": [
{
"font": {
"bold": true,
"size": 11,
"color": {
"argb": "FF000000"
},
"name": "Calibri"
},
"text": "Prompt to LLM = \""
},
{
"font": {
"bold": true,
"size": 11,
"color": {
"argb": "FF0000FF"
},
"name": "Calibri"
},
"text": " Create a pie chart of revenue by product "
},
{
"font": {
"bold": true,
"size": 11,
"color": {
"argb": "FF000000"
},
"name": "Calibri"
},
"text": "\""
}
]
},
"cellAddress": "A43"
}
],
[
{
"value": "Product",
"cellAddress": "A46"
},
{
"value": "2025-01-01T00:00:00.000Z",
"cellAddress": "B46"
},
{
"value": "2025-02-01T00:00:00.000Z",
"cellAddress": "C46"
},
{
"value": "2025-03-01T00:00:00.000Z",
"cellAddress": "D46"
},
{
"value": "2025-04-01T00:00:00.000Z",
"cellAddress": "E46"
},
{
"value": "2025-05-01T00:00:00.000Z",
"cellAddress": "F46"
},
{
"value": "2025-06-01T00:00:00.000Z",
"cellAddress": "G46"
},
{
"value": "2025-07-01T00:00:00.000Z",
"cellAddress": "H46"
},
{
"value": "2025-08-01T00:00:00.000Z",
"cellAddress": "I46"
},
{
"value": "2025-09-01T00:00:00.000Z",
"cellAddress": "J46"
},
{
"value": "2025-10-01T00:00:00.000Z",
"cellAddress": "K46"
},
{
"value": "2025-11-01T00:00:00.000Z",
"cellAddress": "L46"
},
{
"value": "2025-12-01T00:00:00.000Z",
"cellAddress": "M46"
}
],
[
{
"value": "Smartphones",
"cellAddress": "A47"
},
{
"value": 3203,
"cellAddress": "B47"
},
{
"value": 4483,
"cellAddress": "C47"
},
{
"value": 9515,
"cellAddress": "D47"
},
{
"value": 10527,
"cellAddress": "E47"
},
{
"value": 12351,
"cellAddress": "F47"
},
{
"value": 15634,
"cellAddress": "G47"
},
{
"value": 19030,
"cellAddress": "H47"
},
{
"value": 19030,
"cellAddress": "I47"
},
{
"value": 19030,
"cellAddress": "J47"
},
{
"value": 20043,
"cellAddress": "K47"
},
{
"value": 23378,
"cellAddress": "L47"
},
{
"value": 27696,
"cellAddress": "M47"
}
],
[
{
"value": "Keyboards",
"cellAddress": "A48"
},
{
"value": 1628,
"cellAddress": "B48"
},
{
"value": 2654,
"cellAddress": "C48"
},
{
"value": 5416,
"cellAddress": "D48"
},
{
"value": 8362,
"cellAddress": "E48"
},
{
"value": 9116,
"cellAddress": "F48"
},
{
"value": 12995,
"cellAddress": "G48"
},
{
"value": 13536,
"cellAddress": "H48"
},
{
"value": 21172,
"cellAddress": "I48"
},
{
"value": 21864,
"cellAddress": "J48"
},
{
"value": 24815,
"cellAddress": "K48"
},
{
"value": 26643,
"cellAddress": "L48"
},
{
"value": 32405,
"cellAddress": "M48"
}
],
[
{
"value": "Monitors",
"cellAddress": "A49"
},
{
"value": 2500,
"cellAddress": "B49"
},
{
"value": 4285,
"cellAddress": "C49"
},
{
"value": 6316,
"cellAddress": "D49"
},
{
"value": 9848,
"cellAddress": "E49"
},
{
"value": 12313,
"cellAddress": "F49"
},
{
"value": 12313,
"cellAddress": "G49"
},
{
"value": 15436,
"cellAddress": "H49"
},
{
"value": 15436,
"cellAddress": "I49"
},
{
"value": 19089,
"cellAddress": "J49"
},
{
"value": 21973,
"cellAddress": "K49"
},
{
"value": 23857,
"cellAddress": "L49"
},
{
"value": 27221,
"cellAddress": "M49"
}
],
[
{
"value": "Tablets",
"cellAddress": "A50"
},
{
"value": 1494,
"cellAddress": "B50"
},
{
"value": 3787,
"cellAddress": "C50"
},
{
"value": 6294,
"cellAddress": "D50"
},
{
"value": 8591,
"cellAddress": "E50"
},
{
"value": 11527,
"cellAddress": "F50"
},
{
"value": 13173,
"cellAddress": "G50"
},
{
"value": 13173,
"cellAddress": "H50"
},
{
"value": 14265,
"cellAddress": "I50"
},
{
"value": 15810,
"cellAddress": "J50"
},
{
"value": 15810,
"cellAddress": "K50"
},
{
"value": 17341,
"cellAddress": "L50"
},
{
"value": 17341,
"cellAddress": "M50"
}
],
[
{
"value": "Laptops",
"cellAddress": "A51"
},
{
"value": 939,
"cellAddress": "B51"
},
{
"value": 4305,
"cellAddress": "C51"
},
{
"value": 7453,
"cellAddress": "D51"
},
{
"value": 7453,
"cellAddress": "E51"
},
{
"value": 7453,
"cellAddress": "F51"
},
{
"value": 9139,
"cellAddress": "G51"
},
{
"value": 10989,
"cellAddress": "H51"
},
{
"value": 12447,
"cellAddress": "I51"
},
{
"value": 19009,
"cellAddress": "J51"
},
{
"value": 23067,
"cellAddress": "K51"
},
{
"value": 23067,
"cellAddress": "L51"
},
{
"value": 23067,
"cellAddress": "M51"
}
],
[
{
"value": {
"richText": [
{
"text": "Prompt to LLM = \""
},
{
"font": {
"bold": true,
"size": 11,
"color": {
"argb": "FF0000FF"
},
"name": "Calibri",
"family": 2
},
"text": " Create a line chart of cumulative sales by product for the year "
},
{
"font": {
"bold": true,
"size": 11,
"color": {
"argb": "FF000000"
},
"name": "Calibri",
"family": 2
},
"text": "\""
}
]
},
"cellAddress": "A53"
}
]
],
"range": "A3:E39"
}Editor is loading...
Leave a Comment