pk

Sheetcast can be used for any purpose you want.


Here are just some example end result web apps, that you could build.

Calendar Application

Calendar App              Look»

Effortlessly craft a personalized calendar within minutes, providing you with a seamless solution to manage and monitor dates and events in your application.

  1. Open Sheetcast

  2. Open Excel with the Sheetcast Add-in and start with a spreadsheet like this one.

  3. Create a Calendar page:
    • Click “Add Page” and select “Calendar”.
    • Start Dates, Start Times, and End Times are automatically detected for you.
    • Set Titles to Column A then press the clipboard icon.
    • Set “What to Show When Hovering” to column F.
    • Set End Dates to column D.
    • Set Colors to column E.
    • Click "Save and Exit".
  4. You’re done! Click “View App online”.

Map Application

Map App                        Look»

Effortlessly generate a detailed map in minutes, providing your organization with the capability to view key locations within your custom application.

  1. Open Sheetcast

  2. Open Excel with the Sheetcast Add-in and start with a spreadsheet like this one

  3. Map page:
    • Click “Add Page” and select “Map”.
    • Set Titles to column B then press the clipboard icon.
    • Set Location to Sheet1!$A$2:$A$11.
    • Set Description to column C
    • Set colors to column D.
    • Click “Save and Exit”.
  4. Form Page:
    • Click “Add Page” and select “Form”.
    • Set Title to “Add New Pin”.
  5. You’re done! Click “View App online”.

Dashboard application

Dashboard App           Look»

Unleash the power of data visualization in your application with utmost ease! In just a few minutes, fashion a captivating and interactive dashboard.

  1. Open Sheetcast

  2. Open Excel with the Sheetcast Add-in and start with a spreadsheet like this one

  3. Create a Report page:
    • With the Calc sheet open, click “Add Page” and select “Report”.
    • Change the “Source” to a “Range of cells”, set to A$5:$Q$40, then click the clipboard icon.
    • Set the Header to “None (automatic)”.
    • Click “Save and Exit”.
  4. Create a Edit Record Page:
    • With the Calc sheet open, click “Add page” and select "edit-record".
    • Change the “Source” to a “Range of cells”, set to $A$1:$A$2.
    • Set the Header to “Use First Record”.
    • Move to the "More" tab and ensure only “Allow Edit” is selected.
    • Set “What to do if only 1 record” to “auto show if only 1 record.
  5. Create a second Edit Record Page:
    • Using the Data sheet, click “Add page” and select "edit-record".
    • Set Title to “Client Data”.
    • Set the source to be a table and click “Client_List”.
  6. Create a Form Page:
    • Click “Add Page” and select “Form Page”.
    • Set Title to “Client Input Page”
  7. Create a Layout Container Page:
    • Click “Add page” and select “Layout Container”.
    • Set Title to “Client Dashboard”.
    • Set the number of columns to 1.
    • Click the Edit-Record Page in the dropdown.
    • Click the Report Page in the next dropdown.
  8. Create a Tabs Container page:
    • Click “Add page” and select “Tabs Container”.
    • Set Title to “Dashboard”.
    • Set “Client Dashboard (Layout Container)” in the top dropdown.
    • Set “Report Page” (Report) in the next Dropdown.
    • Set “Client Data (Edit-Record)” in the next dropdown.
    • Set “Client Input Page (Form)” in the next dropdown.
  9. Optional: Hide everything except the final tab’s container from the navigation menu by hovering over each page, clicking the gear icon, and selecting hide.

  10. Optional: On each page move to the "More" tab and uncheck “show title”.

  11. You’re done! Click “View App online”.

Survey Application

Survey App                   Look»

Effortlessly craft a survey tailored to your needs in just minutes. Elevate your data collection game with swift and user-friendly survey creation.

  1. Open Sheetcast

  2. Open Excel with the Sheetcast Add-in and start with a spreadsheet like this one.

  3. Create a Details Report Page:
    • Click “Add Page” and select “Details Report”.
    • Set Title to "List of Feedback".
    • Click “Save and Exit”.
  4. Create a Form Page:
    • Click “Add Page” and select “Form”.
    • In the more tab and in “Show page after insert” select “Details report page”.
  5. Create a Text page::
    • Click “Add Page” and select “Text”.
    • In the text box input “Thank you for your feedback. We value this and will make sure your opinion is heard.”
  6. You’re done! Click “View App online”.

London Trip application

London Trip App        Look»

Quickly craft your ultimate vacation application: Explore, capture, map, rate, and check off bucket list adventures!

  1. Open Sheetcast

  2. Open Excel with the Sheetcast Add-in and start with a spreadsheet like this one

  3. Create a Report page:
    • With the Attractions sheet open, click “Add Page” and select “Report”.
    • Click “Save & Exit”.
  4. Create a Map Page:
    • With the Attractions sheet open, click “Add-Page” and select "Map”.
    • Set the title to LONDON.
    • Titles: Select range of cells Attractions!$C$2:$C$200 then press the clipboard icon.
    • Set Location Attractions!$E$2:$E$200.
    • Set colors to Attractions!$M$2:$M$200.
  5. Create a Details Report Page:
    • With the Attractions sheet open click “Add-Page” and select “Details Report Page”
    • Set the title to Attraction.
    • In the more tab change the sorting options selected so that only “Show different information on the list…” is checked.
    • Set Details Template to AttractionsLayout2.
    • Set List Source to Attractions!$A:$J.
  6. Create an Edit-Record Page:
    • With the Attractions sheet open, click “Add-Page” and select "Edit-Record”.
    • Change the Title to Trip Editor.
    • In the more tab under sorting Check the “show different information on the list…” option in addition to the prechecked items.
    • Set Editable template to “EditTripLayout”.
    • Set List Source to Attractions!$A:$H.
  7. Create A Layout Container Page:
    • Click “Add-Page” and select “Layout Container”.
    • Set Title to BUCKET LIST
    • Set Columns to 1
    • In the drop downs select LONDON (MAP) a then Attractions (Details Report)
    • (optional) In the More tab uncheck Show Page Title.
  8. Optional: Hide the Report Page, Attractions and LONDON pages by hovering over each page, clicking the gear icon, and selecting hide.

  9. You’re done! Click “View App online”.

Plant watering schedule application

Plant Watering App   Look»

Your plant care assistant. Monitor watering, capture growth, and schedule care with ease in your own app!

  1. Open Sheetcast

  2. Open Excel with the Sheetcast Add-in and start with a spreadsheet like this one

  3. Create a Calendar Page:
    • Click “Add-Page” and select “Calendar”.
    • Set title to “Schedule”.
    • Set Start Dates to Column E.
    • Set Titles to Column B.
    • Set What to show when hovering to column J.
    • Set End Dates to Column E.
    • Set Colors to Column K.
    • Click “Save & Exit”.
  4. Create a Detail Report Page:
    • With the Plants sheet open click “Add-Page” and select “Details Report Page”.
    • Set the title to “Plant List”.
  5. Create a Data Filter Page:
    • With the Plants sheet open click “Add-Page” and select “Data Filter Page”.
    • Set title to “Filter Data”.
    • In the more tab Set the Insert Template to “FiltersByLayout”
    • Check the box for Match fields name.
    • Set the Save Button text to “Apply”.
    • Uncheck the Show Page Title option.
  6. Create an Edit-Record:
    • With the Plants sheet open, click “Add-Page” and select "Edit-Record”.
    • Set title to “Edit / Add / Remove.
  7. Create a Layout Container:
    • Click “Add-Page” and select “Layout Container”.
    • Set title to “Dashboard”.
    • Set Columns to 1.
    • In the drop downs select Filter Data (Data Filter), followed by Schedule (Calendar) and then Plant List (Details Report).
  8. Optional: Hide the Schedule, Plant List and Filter Data pages by hovering over each page, clicking the gear icon, and selecting hide.

  9. You’re done! Click “View App online”.