/simplifunction

An aid to create functions for Microsoft Excel and Google Sheets

Primary LanguageTypeScript

SimpliFunction

SimpliFunction is a cool and epic solution for writing calculations in Excel without needing to know the stupid Visual Basic syntax.

What's changed since the last report

  • I added support for more excel functions, including the more popular ones.
  • What you're supposed to copy is more obvious. The output is highlighted temporarily so that it's visible. There is also now a copy button next to the output
  • The website is now much faster, with respect to generating output and also typing/backspacing in the input field
  • It's more obvious how to clear the input because I added an X button in the field
  • Input validation for like half of the functions is broken at the moment
  • visual changes

Theme

https://coolors.co/f2dfd7-fef9ff-d4c1ec-9f9fed-736ced

Files

  • assets/ directory

    • any icons and images

  • buttons/

    • This contains components for the buttons on the website. They contain the logic to when clicked spawn the correct dialog and pass props to it

    • BasicButtons.tsx

      • Buttons for the 4 basic functions and parentheses.
      • On mobile, it adds buttons for the 10 digits, a backspace, and a decimal point

    • FunctionButtonsWrapper.tsx

      • Contains the search bar and filters functions to pass to FunctionButtons
      • Will render the accordion if it's on mobile.

    • FunctionButtonsAccordion.tsx

      • Puts the content from FunctionButtonsWrapper into an accordion for mobile

    • FunctionButtons.tsx

      • This contains the grid to display the individual buttons

    • FunctionButton.tsx

      • This is a general button, and more specific button components will be a wrapper around this component

  • util/

    • parser.ts
      • parses the user input and creates valid Visual Basic for Applications code
    • validator.ts
      • The forms components use this file to validate the fields

  • functions.ts

    • This is the data for all the functions. It's a list where each entry contains the data for an excel function including, but not limited to the following data
      • common name
      • parameters
      • data types
      • documentation link

  • MyDialog.tsx

    • This is the website's dialog. A form can be passed into it

  • UserInput.tsx

    • This is the input text field at the top of the website

  • Calculator.tsx

    • The starting point of the website

  • commonTypes.ts

    • Common types that are reused

Other tools like this