converting excel document (with macros) to sharepoint form

smakatura

Board Regular
Joined
May 27, 2011
Messages
141
This may not be the perfect forum for this question, so ifyou have another suggestion of where to as, I am happy to explore…

I created an excel spreadsheet (name: Excel1), thisspreadsheet uses macros and pulls data from a second excel spreadsheet (Name:Excel2).

Excel1 tracks a service outage. So the sheet is helping us calculate costsbased on time down.

Now my team has “upgraded to higher technology” and has createda new sharepoint form that you enter all your outage information….(ie when itstarted, how long it lasted, what happened…) this form then puts all that data into a ‘database’ for easierreporting.

One of the pieces of the sharepoint form, is an outageimpact analysis. So it can calculate thecost and time Impacts of the outage.However,the data calculated from Excel1 Is not currently part of sharepoint form

Is there a way to take Excel1 and add it to sharepointform.

I am thinking the form would say STAFFING COSTS - $1200 and then there would be a link to the worksheet that created that1200….so

Team Affected Team Outage cost
Code:
[FONT=Calibri][SIZE=3][COLOR=#000000][TABLE="width: 170"]
[FONT=Times New Roman] [/FONT]<colgroup><col width="99" style="width: 74pt; mso-width-source: userset; mso-width-alt: 3620;">[FONT=Times New Roman] [/FONT]<col width="64" style="width: 48pt;" span="2">[FONT=Times New Roman] [/FONT]<tbody>[TR]
[FONT=Times New Roman]  [/FONT][TD="width: 99, bgcolor: transparent"]Team  Affected
[/TD]
[FONT=Times New Roman]  [/FONT][TD="width: 64, bgcolor: transparent"]Team [/TD]
[FONT=Times New Roman]  [/FONT][TD="width: 64, bgcolor: transparent"]cost[/TD]
[FONT=Times New Roman] [/FONT][/TR]
[FONT=Times New Roman] [/FONT][TR]
[FONT=Times New Roman]  [/FONT][TD="bgcolor: transparent"]Yes[/TD]
[FONT=Times New Roman]  [/FONT][TD="bgcolor: transparent, align: right"]1[/TD]
[FONT=Times New Roman]  [/FONT][TD="bgcolor: transparent, align: right"]100[/TD]
[FONT=Times New Roman] [/FONT][/TR]
[FONT=Times New Roman] [/FONT][TR]
[FONT=Times New Roman]  [/FONT][TD="bgcolor: transparent"]No[/TD]
[FONT=Times New Roman]  [/FONT][TD="bgcolor: transparent, align: right"]2[/TD]
[FONT=Times New Roman]  [/FONT][TD="bgcolor: transparent, align: right"]0[/TD]
[FONT=Times New Roman] [/FONT][/TR]
[FONT=Times New Roman] [/FONT][TR]
[FONT=Times New Roman]  [/FONT][TD="bgcolor: transparent"]Yes[/TD]
[FONT=Times New Roman]  [/FONT][TD="bgcolor: transparent, align: right"]3[/TD]
[FONT=Times New Roman]  [/FONT][TD="bgcolor: transparent, align: right"]1100[/TD]
[FONT=Times New Roman] [/FONT][/TR]
[FONT=Times New Roman][/FONT]</tbody>[/TABLE]
[/COLOR][/SIZE][/FONT]


Obviously the breakdown may include number of people, numberof hours worked, and maybe number of cost per hour to get the final cost …butyou get the idea. Excel1’s formulashave all these factors built in .

It would be great to get a full summary from the sharepointform/database vs having to use Excel also.

Is this possible to do? How would I go about searching thisto make this happen? Is there a betterplace to ask questions about the sharepoint piece?

Thank you in advance for the help
 
Last edited:

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Forum statistics

Threads
1,223,238
Messages
6,170,939
Members
452,368
Latest member
jayp2104

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top