- Thank you received: 0
 
Import Formulas from Excel
- ArowanA
 - 
				
				
				                    Topic Author
								             - Offline
 
		Less
        More
        
            
    
        
			
    
						8 years 2 weeks ago		        #7152
        by ArowanA
    
    
        
			
										        
    
			Import Formulas from Excel was created by ArowanA        
        
			Hi,
I'm very new using your software so sorry if this is a silly question, but currently I have Excel spreadsheets set up to automatically calculate average marks, etc. I've tried to import my sheets directly in to Grade and the fields show up with an '!' i guess this is because the fields contain formulas. I can get round this by saving my document as a CSV file and importing it that way.. but is there anyway for me to be able to import my formulas form Excel to my Grade book without manually needing to create them again?
If not, if I create a new gradebook and create the formulas can I use that as a template for other classes?
Many Thanks
		    I'm very new using your software so sorry if this is a silly question, but currently I have Excel spreadsheets set up to automatically calculate average marks, etc. I've tried to import my sheets directly in to Grade and the fields show up with an '!' i guess this is because the fields contain formulas. I can get round this by saving my document as a CSV file and importing it that way.. but is there anyway for me to be able to import my formulas form Excel to my Grade book without manually needing to create them again?
If not, if I create a new gradebook and create the formulas can I use that as a template for other classes?
Many Thanks
- bert
 - 
				
				
								             - Offline
 
		Less
        More
        
            
    
        - Thank you received: 749
 
			
    
						8 years 2 weeks ago		        #7153
        by bert
    
    
        
    
    
			Replied by bert on topic Import Formulas from Excel        
        
			I'm afraid not ArowanA. Our formulas are different than those of Excel you can only import the text/values in cells        
		    
		The following user(s) said Thank You: ArowanA