{lesson.title}

{lesson.description}

\n Example: {lesson.example}\n

\n\n setUserInput(e.target.value)}\n placeholder=\"Type your formula here\"\n style={{\n width: \"100%\",\n padding: \"0.5rem\",\n fontSize: \"1rem\",\n marginBottom: \"0.5rem\",\n borderRadius: 4,\n border: \"1px solid #ccc\",\n }}\n />\n\n \n Check Answer\n \n\n

{feedback}

\n\n setShowHint(!showHint)}\n style={{\n marginTop: \"0.5rem\",\n background: \"none\",\n border: \"none\",\n color: \"#2563eb\",\n cursor: \"pointer\",\n textDecoration: \"underline\",\n }}\n >\n {showHint ? \"Hide Hint\" : \"Show Hint\"}\n \n\n {showHint &&

{lesson.hint}

}\n\n

\n \n Previous\n \n\n \n Lesson {lessonIndex + 1} of {lessons.length}\n \n\n \n Next\n \n

\n \n );\n}","deleted","label","children",[],[99],"files",[150],"counts",{"_174":32,"_175":176,"_177":32,"_178":32},"pulls","branches",1,"forks","envVars","contents",[],"file",{"_103":151,"_95":99,"_152":153,"_154":-5,"_155":138,"_156":137,"_157":158,"_105":183,"_100":160,"_161":162,"_163":164,"_165":22,"_166":-5,"_98":184},["D",1748892236065],[99],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.history_.$",{"_93":94,"_95":96,"_97":43,"_98":99,"_101":193,"_181":198,"_201":202,"_232":233,"_242":-7,"_243":32,"_244":22},{"_103":104,"_95":96,"_105":194,"_107":-5,"_108":22,"_109":110,"_111":112,"_113":-5,"_14":114,"_115":-5,"_116":22,"_117":-5,"_118":32,"_16":119,"_120":121,"_122":121,"_123":124,"_125":124,"_126":124,"_127":121,"_128":121,"_23":195,"_132":196,"_135":197,"_147":22},["D",1748891034906],{"_93":94,"_130":131},{"_93":94,"_134":131},{"_100":137,"_95":43,"_103":138,"_139":104,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":96,"_146":94},{"_103":151,"_95":99,"_152":153,"_154":-5,"_155":138,"_156":137,"_157":158,"_105":199,"_100":160,"_161":162,"_163":164,"_165":22,"_166":-5,"_98":200},["D",1748892236065],[99],"history",[203,205,210,215,220,225,229],{"_103":151,"_155":138,"_152":153,"_95":99,"_163":164,"_161":162,"_100":160,"_154":-5,"_105":204,"_156":137,"_166":-5},["D",1748892236065],{"_103":206,"_155":138,"_152":153,"_95":99,"_163":207,"_161":162,"_100":208,"_154":-5,"_105":209,"_156":160,"_166":-5},"adc15bc2-3fe6-11f0-b745-76b3cceeab13","import * as React from \"npm:react\";\n\ntype Lesson = {\n id: number;\n title: string;\n description: string;\n example: string;\n hint: string;\n expectedAnswer: string;\n};\n\nconst lessons: Lesson[] = [\n {\n id: 1,\n title: \"SUMIF\",\n description: \"Learn how to use the SUMIF formula to sum values that meet a condition.\",\n example: \"SUMIF(range, criteria, [sum_range])\",\n hint: \"Use SUMIF to sum cells where a condition is true, e.g. sum values greater than 5.\",\n expectedAnswer: \"SUMIF(A1:A10, \\\">5\\\")\",\n },\n {\n id: 2,\n title: \"VLOOKUP\",\n description: \"Use VLOOKUP to find data in a table by matching a key.\",\n example: \"VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])\",\n hint: \"Remember VLOOKUP searches vertically in the leftmost column.\",\n expectedAnswer: \"VLOOKUP(1001, A2:D10, 3, FALSE)\",\n },\n {\n id: 3,\n title: \"IF\",\n description: \"The IF formula returns one value if a condition is true, and another if false.\",\n example: \"IF(logical_test, value_if_true, value_if_false)\",\n hint: \"You can nest IFs for multiple conditions.\",\n expectedAnswer: \"IF(A1>10, \\\"Yes\\\", \\\"No\\\")\",\n },\n];\n\nexport default function App() {\n const [lessonIndex, setLessonIndex] = React.useState(0);\n const [userInput, setUserInput] = React.useState(\"\");\n const [feedback, setFeedback] = React.useState(\"\");\n const [showHint, setShowHint] = React.useState(false);\n\n const lesson = lessons[lessonIndex];\n\n function normalizeFormula(formula: string) {\n return formula.replace(/\\s/g, \"\").toLowerCase();\n }\n\n function checkAnswer() {\n const normalizedInput = normalizeFormula(userInput);\n const normalizedExpected = normalizeFormula(lesson.expectedAnswer);\n\n if (normalizedInput === normalizedExpected) {\n setFeedback(\"✅ Correct! Great job.\");\n } else if (normalizedExpected.includes(normalizedInput) && normalizedInput.length > 0) {\n setFeedback(\"⚠️ Almost there, try again.\");\n } else {\n setFeedback(\"❌ Try again!\");\n }\n }\n\n function goToPrevious() {\n setFeedback(\"\");\n setUserInput(\"\");\n setShowHint(false);\n setLessonIndex((prev) => (prev > 0 ? prev - 1 : prev));\n }\n\n function goToNext() {\n setFeedback(\"\");\n setUserInput(\"\");\n setShowHint(false);\n setLessonIndex((prev) => (prev < lessons.length - 1 ? prev + 1 : prev));\n }\n\n return (\n \n

{lesson.title}

{lesson.description}

\n Example: {lesson.example}\n

{feedback}

{lesson.hint}

}\n\n

\n \n Previous\n \n\n \n Lesson {lessonIndex + 1} of {lessons.length}\n \n\n \n Next\n \n

\n \n );\n}",5,["D",1748892043855],{"_103":211,"_155":138,"_152":153,"_95":99,"_163":212,"_161":162,"_100":213,"_154":-5,"_105":214,"_156":208,"_166":-5},"622df0a8-3fe6-11f0-a7be-76b3cceeab13","import React, { useState } from \"npm:react\";\n\ntype Lesson = {\n id: number;\n title: string;\n description: string;\n example: string;\n hint: string;\n expectedAnswer: string;\n};\n\nconst lessons: Lesson[] = [\n {\n id: 1,\n title: \"SUMIF\",\n description: \"Learn how to use the SUMIF formula to sum values that meet a condition.\",\n example: \"SUMIF(range, criteria, [sum_range])\",\n hint: \"Use SUMIF to sum cells where a condition is true, e.g. sum values greater than 5.\",\n expectedAnswer: \"SUMIF(A1:A10, \\\">5\\\")\",\n },\n {\n id: 2,\n title: \"VLOOKUP\",\n description: \"Use VLOOKUP to find data in a table by matching a key.\",\n example: \"VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])\",\n hint: \"Remember VLOOKUP searches vertically in the leftmost column.\",\n expectedAnswer: \"VLOOKUP(1001, A2:D10, 3, FALSE)\",\n },\n {\n id: 3,\n title: \"IF\",\n description: \"The IF formula returns one value if a condition is true, and another if false.\",\n example: \"IF(logical_test, value_if_true, value_if_false)\",\n hint: \"You can nest IFs for multiple conditions.\",\n expectedAnswer: \"IF(A1>10, \\\"Yes\\\", \\\"No\\\")\",\n },\n // Add more lessons as you like\n];\n\nexport default function App() {\n const [lessonIndex, setLessonIndex] = useState(0);\n const [userInput, setUserInput] = useState(\"\");\n const [feedback, setFeedback] = useState(\"\");\n const [showHint, setShowHint] = useState(false);\n\n const lesson = lessons[lessonIndex];\n\n function normalizeFormula(formula: string) {\n return formula.replace(/\\s/g, \"\").toLowerCase();\n }\n\n function checkAnswer() {\n const normalizedInput = normalizeFormula(userInput);\n const normalizedExpected = normalizeFormula(lesson.expectedAnswer);\n\n if (normalizedInput === normalizedExpected) {\n setFeedback(\"✅ Correct! Great job.\");\n } else if (normalizedExpected.includes(normalizedInput) && normalizedInput.length > 0) {\n setFeedback(\"⚠️ Almost there, try again.\");\n } else {\n setFeedback(\"❌ Try again!\");\n }\n }\n\n function goToPrevious() {\n setFeedback(\"\");\n setUserInput(\"\");\n setShowHint(false);\n setLessonIndex((prev) => (prev > 0 ? prev - 1 : prev));\n }\n\n function goToNext() {\n setFeedback(\"\");\n setUserInput(\"\");\n setShowHint(false);\n setLessonIndex((prev) => (prev < lessons.length - 1 ? prev + 1 : prev));\n }\n\n return (\n \n

{lesson.title}

{lesson.description}

\n Example: {lesson.example}\n

{feedback}

{lesson.hint}

}\n\n

\n \n Previous\n \n\n \n Lesson {lessonIndex + 1} of {lessons.length}\n \n\n \n Next\n \n

\n \n );\n}",4,["D",1748891917058],{"_103":216,"_155":138,"_152":153,"_95":99,"_163":217,"_161":162,"_100":218,"_154":-5,"_105":219,"_156":213,"_166":-5},"2ec4e5c8-3fe6-11f0-80a5-76b3cceeab13","import React, { useState } from \"react\";\n\ntype Lesson = {\n id: number;\n title: string;\n description: string;\n example: string;\n hint: string;\n expectedAnswer: string;\n};\n\nconst lessons: Lesson[] = [\n {\n id: 1,\n title: \"SUMIF\",\n description: \"Learn how to use the SUMIF formula to sum values that meet a condition.\",\n example: \"SUMIF(range, criteria, [sum_range])\",\n hint: \"Use SUMIF to sum cells where a condition is true, e.g. sum values greater than 5.\",\n expectedAnswer: \"SUMIF(A1:A10, \\\">5\\\")\",\n },\n {\n id: 2,\n title: \"VLOOKUP\",\n description: \"Use VLOOKUP to find data in a table by matching a key.\",\n example: \"VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])\",\n hint: \"Remember VLOOKUP searches vertically in the leftmost column.\",\n expectedAnswer: \"VLOOKUP(1001, A2:D10, 3, FALSE)\",\n },\n {\n id: 3,\n title: \"IF\",\n description: \"The IF formula returns one value if a condition is true, and another if false.\",\n example: \"IF(logical_test, value_if_true, value_if_false)\",\n hint: \"You can nest IFs for multiple conditions.\",\n expectedAnswer: \"IF(A1>10, \\\"Yes\\\", \\\"No\\\")\",\n },\n // Add more lessons as you like\n];\n\nexport default function App() {\n const [lessonIndex, setLessonIndex] = useState(0);\n const [userInput, setUserInput] = useState(\"\");\n const [feedback, setFeedback] = useState(\"\");\n const [showHint, setShowHint] = useState(false);\n\n const lesson = lessons[lessonIndex];\n\n function normalizeFormula(formula: string) {\n return formula.replace(/\\s/g, \"\").toLowerCase();\n }\n\n function checkAnswer() {\n const normalizedInput = normalizeFormula(userInput);\n const normalizedExpected = normalizeFormula(lesson.expectedAnswer);\n\n if (normalizedInput === normalizedExpected) {\n setFeedback(\"✅ Correct! Great job.\");\n } else if (normalizedExpected.includes(normalizedInput) && normalizedInput.length > 0) {\n setFeedback(\"⚠️ Almost there, try again.\");\n } else {\n setFeedback(\"❌ Try again!\");\n }\n }\n\n function goToPrevious() {\n setFeedback(\"\");\n setUserInput(\"\");\n setShowHint(false);\n setLessonIndex((prev) => (prev > 0 ? prev - 1 : prev));\n }\n\n function goToNext() {\n setFeedback(\"\");\n setUserInput(\"\");\n setShowHint(false);\n setLessonIndex((prev) => (prev < lessons.length - 1 ? prev + 1 : prev));\n }\n\n return (\n \n

{lesson.title}

{lesson.description}

\n Example: {lesson.example}\n

{feedback}

{lesson.hint}

}\n\n

\n \n Previous\n \n\n \n Lesson {lessonIndex + 1} of {lessons.length}\n \n\n \n Next\n \n

\n \n );\n}",3,["D",1748891830805],{"_103":221,"_155":138,"_152":153,"_95":99,"_163":217,"_161":222,"_100":223,"_154":-5,"_105":224,"_156":218,"_166":-5},"207b5970-3fe6-11f0-975d-76b3cceeab13","script",2,["D",1748891806830],{"_103":226,"_155":138,"_152":153,"_95":99,"_163":227,"_161":222,"_100":176,"_154":-5,"_105":228,"_156":223,"_166":-5},"ab7a5e56-3fe4-11f0-9a73-76b3cceeab13","const lessons = [\n {\n id: 1,\n title: \"SUMIF Function\",\n sampleData: `\n| A (Item) | B (Quantity) |\n|----------|--------------|\n| Apple | 10 |\n| Orange | 5 |\n| Apple | 7 |\n| Banana | 3 |`,\n question: `Write a formula to sum quantities of all \"Apple\" items using SUMIF.`,\n answers: [\n '=SUMIF(A2:A5, \"Apple\", B2:B5)',\n '=SUMIF(A2:A5,\"Apple\",B2:B5)',\n '=SUMIF(A2:A5,\"Apple\", B2:B5)',\n '=SUMIF(A2:A5, \"Apple\",B2:B5)'\n ],\n explanation: `SUMIF(range, criteria, [sum_range]) adds values in sum_range where range meets criteria.\nHere, sum quantities where Item = \"Apple\". The result is 17.`,\n exampleResult: 17,\n hint: \"Remember, SUMIF has three parts: range to check, criteria, and range to sum.\"\n },\n {\n id: 2,\n title: \"IF Function\",\n sampleData: `\n| A (Score) |\n|-----------|\n| 85 |\n| 40 |`,\n question: `Write a formula that returns \"Pass\" if score in A2 is 50 or more, otherwise \"Fail\".`,\n answers: [\n '=IF(A2>=50,\"Pass\",\"Fail\")',\n '=IF(A2 >= 50, \"Pass\", \"Fail\")'\n ],\n explanation: `IF(logical_test, value_if_true, value_if_false) returns \"Pass\" if A2 >= 50, else \"Fail\".`,\n exampleResult: \"Pass\",\n hint: \"IF checks a condition, then gives one value if TRUE, another if FALSE.\"\n },\n {\n id: 3,\n title: \"VLOOKUP Function\",\n sampleData: `\n| A (Product) | B (Price) |\n|-------------|-----------|\n| Pen | 1.5 |\n| Notebook | 3.0 |\n| Eraser | 0.5 |`,\n question: `Write a formula to find the price of \"Notebook\" using VLOOKUP.`,\n answers: [\n '=VLOOKUP(\"Notebook\", A2:B4, 2, FALSE)',\n '=VLOOKUP(\"Notebook\",A2:B4,2,FALSE)',\n '=VLOOKUP(\"Notebook\", A2:B4, 2, 0)'\n ],\n explanation: `VLOOKUP(lookup_value, table_array, col_index_num, range_lookup) finds \"Notebook\" price in 2nd column exactly.`,\n exampleResult: 3,\n hint: \"Use FALSE or 0 as the last argument to look for exact matches.\"\n },\n {\n id: 4,\n title: \"COUNTIF Function\",\n sampleData: `\n| A (Names) |\n|------------|\n| John |\n| Mary |\n| John |\n| Alice |`,\n question: `Write a formula to count how many times \"John\" appears in A2:A5 using COUNTIF.`,\n answers: [\n '=COUNTIF(A2:A5, \"John\")',\n '=COUNTIF(A2:A5,\"John\")'\n ],\n explanation: `COUNTIF(range, criteria) counts how many cells meet criteria.\nHere it counts \"John\" occurrences. Result is 2.`,\n exampleResult: 2,\n hint: \"COUNTIF needs range and criteria (value to count).\"\n },\n {\n id: 5,\n title: \"CONCATENATE Function\",\n sampleData: `\n| A (First Name) | B (Last Name) |\n|---------------|---------------|\n| Jane | Doe |\n| Mark | Twain |`,\n question: `Write a formula to combine first and last names in A2 and B2 with a space using CONCATENATE.`,\n answers: [\n '=CONCATENATE(A2, \" \", B2)',\n '=CONCATENATE(A2,\" \",B2)'\n ],\n explanation: `CONCATENATE joins text strings.\nHere it combines first and last name with a space.`,\n exampleResult: \"Jane Doe\",\n hint: \"Use CONCATENATE with commas separating each piece.\"\n },\n {\n id: 6,\n title: \"INDEX-MATCH Combination\",\n sampleData: `\n| A (Product) | B (Price) |\n|-------------|-----------|\n| Pen | 1.5 |\n| Notebook | 3.0 |\n| Eraser | 0.5 |`,\n question: `Write a formula to find the price of \"Pen\" using INDEX and MATCH.`,\n answers: [\n '=INDEX(B2:B4, MATCH(\"Pen\", A2:A4, 0))',\n '=INDEX(B2:B4,MATCH(\"Pen\",A2:A4,0))'\n ],\n explanation: `INDEX(range, MATCH(value, lookup_range, 0)) finds the row of \"Pen\" then returns price.\nResult is 1.5.`,\n exampleResult: 1.5,\n hint: \"MATCH finds position; INDEX returns value at that position.\"\n }\n];\n\nexport default async function (req: Request) {\n const url = new URL(req.url);\n let lessonId = parseInt(url.searchParams.get(\"lesson\") || \"1\", 10);\n if (lessonId < 1) lessonId = 1;\n if (lessonId > lessons.length) lessonId = lessons.length;\n const lesson = lessons.find(l => l.id === lessonId) || lessons[0];\n\n function escapeHtml(text: string) {\n return text.replace(/&/g, \"&\").replace(//g, \">\");\n }\n\n const html = `\n \n \n \n \n \n Excel Formula Trainer - ${lesson.title}\n \n \n \n

Excel Formula Trainer

${lesson.title}

\n\n

Lesson ${lesson.id} of ${lessons.length}

\n\n

Sample Data

${escapeHtml(lesson.sampleData)}

\n\n

Question

${lesson.question}

\n\n \n \n \n\n

${escapeHtml(lesson.hint)}

\n\n \n\n \n \n \n `;\n\n return new Response(html, {\n headers: {\n \"content-type\": \"text/html; charset=UTF-8\",\n },\n });\n}",["D",1748891181039],{"_103":230,"_155":138,"_152":153,"_95":99,"_163":72,"_161":222,"_100":32,"_154":-5,"_105":231,"_156":176,"_166":-5},"54619760-3fe4-11f0-95f0-76b3cceeab13",["D",1748891034918],"versions",[234,236,237,238,239,240,241],{"_181":203,"_235":205},"previous",{"_181":205,"_235":210},{"_181":210,"_235":215},{"_181":215,"_235":220},{"_181":220,"_235":225},{"_181":225,"_235":229},{"_181":229,"_235":-5},"versionNumber","page","hasNext","actionData","errors"]

nduru

Exceltrainer1

History for main.tsx