> -, \p
rachel prance Ba==x-L;!8X@"1#Arial1#Arial1#Arial1#Arial1#Arial1#Arial""#,##0;\-""#,##0""#,##0;[Red]\-""#,##0""#,##0.00;\-""#,##0.00#""#,##0.00;[Red]\-""#,##0.005*0_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-,)'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=,8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_-4+/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_- 0.0%1,_-* #,##0.0_-;\-* #,##0.0_-;_-* "-"?_-;_-@_- + ) , * @ A " A H "\ A L H L H+ H+ L* L* A L/ A L/ "\+ H* "\* H. A L. A L, X (P "\ (\. (X, (X/ (P/ " `
tIntroSample completed table\*Blank table,"ZR
3 @@
;%Staff 1Staff 2Staff 3Staff 4Staff 5
Income taxFood
EntertainmentClothesDIYTransportationServices
Rent/MortgageCouncil tax
Home costsLoan repaymentsSavingsOtherTotalItem% spent locally by local staffAverageThere are two worksheets in this document: a blank template for you to use and a sample completed version. Please feel free to alter these forms however suits you.|The blank form we include here is for 10 survey responses. You can add or subtract columns to this to suit your LM3 work. @Add or subtract columns depending on how many responses you have/Alter 'Items' depending on your own survey formSThe Total row tells you how much each staff person spent locally, across all items.If you are reviewing less than five surveys, you may want to calculate the local spend for each person/business. However, if you have more surveys, it may be easier for you to use averages. Say you know that an employer spends 50,000 on three local staff. If you know how much s/he pays each person and you have surveys for each person, then you should calculate each staff person's local re-spend individually. However, say you know that an employer spends 200,000 on 10 staff. Rather than calculate 10 local re-spends, you may find it easier to average all staff surveys together and apply this to the 200,000. So if you find that staff spend an average of 40% of their salaries locally, then 40% x 200,000 = 80,000.3You may miss out on individual aspects of spending by doing this. So if you think looking at each person is more important and you have the time to do so, you can take that approach. We have included a sample completed form in case you are rusty on your maths and have forgotten how to calculate averages.The overall average local spend is the sum of each staff person's total (42.1%, 50.5%, etc.) divided by the total number of responses -- 5. So the overall average = (42.1 + 50.5 + 63.1 + 37.8 + 33.6) / 5 = 45.4.The average column doesn't apply to your LM3 calculations, but you may find it educational. The average column tells you how much staff spent, on average, per item. So this means that staff spent an average of 17.9% of their total income on local food.Staff 6Staff 7Staff 8Staff 9Staff 10eThe '#DIV/0!' that appears in the LM3 row will go away once you enter figures for the various rounds.* bg
=cc
0
dMbP?_*+%"??taU}$
@
0000000000000000
00000000000000000000000000000000 00000000
000000000000000000000000
00000000
00000000000000000000000000000000
0000000000000000
0$000000000000000*h&&&&&>@*
7
_&
dMbP?_*+%MFirst Floor Network Printer0C 4dXXA4DINU"07խ" dXX??U}$ }$}"}$ } $
!
1111111
$$$)
*++****
#
%
%
%
%
%
'
$$&&&&&'( %Bd
$$&@& @&t@&X@&@'(4i? %Bd
4
44
$$&@@&@&`@&@@&@(̯?(-Bd
444
$$&@&@&@&@&@(S㥫?(
444
$ $ &@j@&o@&s@&g@&e@ ( m9?(
444
$
$
&$@&(@&.@&"@& @
(+ٱQ?(
444
$$&@&@&@&@&@(S㥛?(
444
$$&.@&2@&6@&+@&(@(?ŊZ?(
444
$
$
&?&^@&?&V@&T@
(_vO?(
444
$$&&&&&((
555
$$&&&&&((
$$&@z@&@&@&w@&u@( m9?(
$$&&&&&((
,'-x? %d'-1%? %d'-v/? %d'-JY8? %d'-,ݓ? %d#.S7? "
%B
2222
3 333322223333322223333333333/////4 $Fba}eeeeeeeUUU>&& / j(
jB
0D@KPZ]`2rjB
@
0D@]`3rjB
@
0D@ p ]`3rjB
0D@<]`H4rjB
0D@K] `4>@"
7
*.P6
dMbP?_*+%MFirst Floor Network Printer0C 4dXXA4DINU"07խ" dXX??U}$}
}$ }$
666666666666
!
"
#
'Q %
Bd
(-Bd
(
S(
m9(
+ٱ(
S(
Ŋ(
vO(
(
(
m9(
(
(
-6d((((((( (
( #
%B&@. WjKKKKKKKKKKK >@
7
Oh+'0@H`x
Justin Sacksrachel pranceMicrosoft Excel@w+@@%A՜.+,0 PX|
New Economics Foundation'IntroSample completed tableBlank tableWorksheets
!"#%&'()*+Root Entry FWorkbook6SummaryInformation(DocumentSummaryInformation8$