Sheet defined functions

This page lists all sheet defined functions used to convert from Excel to Funcalc on a per sheet basis.

---

database/processed/Aggregate%20Governanc#A8A51.xml

• VLOOKUP_PICKER
• VLOOKUP_REPLACER
• VLOOKUP
• SUMIF2_HELPER
• SUMIF2
• SUMIF2ALT

database/processed/high_2003_belg.xml

• VLOOKUP_PICKER
• VLOOKUP_REPLACER
• VLOOKUP
• ISNUMBER

financial/processed/financial-model-spreadsheet.xml

• RATE
• PMT
• Helpers: Goalseek and tvm sheets

homework/processed/Test%20Station%20Powe#A90F3.xml

• SQUARE
• STDEV

homework/processed/notes%5CMISB200SP04H2KEY.xml

• IS_BEVERAGE_OR_DAIRY
• IS_SEAFOOD
• IS_PRODUCE
• SUMIF2_HELPER
• SUMIF2
• AVGIF2
• COUNTIF2_HELPER
• COUNTIF2
• COUNTIF3_HELPER
• COUNTIF3
• VLOOKUP_PICKER
• VLOOKUP_REPLACER
• VLOOKUP

inventory/processed/MRP_Excel.xml

• LOOKUP_PICKER
• LOOKUP_REPLACER
• VLOOKUP
• HLOOKUP
• ISBLANK
• MATCH_PICKER
• MATCH
• RIGHT
• INT

modeling/processed/funding.xml

• F
• RATE
• PMT
• Helpers: Goalseek and tvm sheets

modeling/processed/iste-cs-2003-modeling-sim.xml

• INT