tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 93962d1293723174-counting-days-in-a-different-manner-sum-of-data-back-into-monthly-ws
Sheet: FEBRUARY

 | FEBRUARY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRESENCE | ABSENCES COUNTED AS PRESENCE |  |  |  |  |  | TOTAL
 | NAME | ENTRY DATE | LEAVING DATE | 2010-02-01 00:00:00 | 2010-02-02 00:00:00 | 2010-02-03 00:00:00 | 2010-02-04 00:00:00 | 2010-02-05 00:00:00 | 2010-02-06 00:00:00 | 2010-02-07 00:00:00 | 2010-02-08 00:00:00 | 2010-02-09 00:00:00 | 2010-02-10 00:00:00 | 2010-02-11 00:00:00 | 2010-02-12 00:00:00 | 2010-02-13 00:00:00 | 2010-02-14 00:00:00 | 2010-02-15 00:00:00 | 2010-02-16 00:00:00 | 2010-02-17 00:00:00 | 2010-02-18 00:00:00 | 2010-02-19 00:00:00 | 2010-02-20 00:00:00 | 2010-02-21 00:00:00 | 2010-02-22 00:00:00 | 2010-02-23 00:00:00 | 2010-02-24 00:00:00 | 2010-02-25 00:00:00 | 2010-02-26 00:00:00 | 2010-02-27 00:00:00 | 2010-02-28 00:00:00 |  |  |  |  | F | V | C | H | U | R
1 | PERSON1 | 2009-10-31 00:00:00 |  |  | V | V | V | V | V | V | V |  | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R | R
2 | PERSON2 | 2009-06-16 00:00:00 | 2010-10-12 00:00:00 | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H | H |  | F | F
3 | PERSON3 | 2008-11-24 00:00:00 |  |  |  |  |  |  | F | F |  |  |  |  |  |  |  |  |  | F | F |  |  |  |  |  |  |  |  |  | F
4 | PERSON4 | 2009-06-05 00:00:00 |  |  |  |  |  |  | F | C | C | C | C | C | C | C | C | C | C | C | C | C | C | C | C | C | C | C |  | F | F
5 | PERSON5 | 2007-05-12 00:00:00 | 2010-11-04 00:00:00 |  |  |  |  |  |  | F |  |  |  |  |  |  | F |  |  |  |  |  | F | F |  |  |  |  |  |  | F
6 | [NAME] | 2006-01-18 00:00:00 | 2010-03-03 00:00:00 |  |  |  |  |  | F | F |  |  |  |  |  | F | F | F | F | F |  | F | F | F |  |  |  |  |  | F | F
7 | PERSON7 | 2009-03-23 00:00:00 | 2010-03-03 00:00:00 |  |  |  |  |  | F | F |  |  |  | F | F | F | F | F | F |  | F | F | F | F |  |  |  |  |  |  | F
8 | PERSON8 | 2009-05-19 00:00:00 | 2010-04-20 00:00:00 |  |  |  |  |  | F | C | C | C | C | C | C | C | C | C | C | C | C | C | C | C | C | C | C | C |  |  | F
9 | PERSON9 | 2010-03-03 00:00:00
10 | PERSON10 | 2010-03-03 00:00:00
11 | PERSON11 | 2010-04-22 00:00:00
12 | PERSON12 | 2010-10-22 00:00:00
13 | PERSON13 | 2010-11-23 00:00:00
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0
Spreadsheet: 120744d1315494824-projected-component-change-outs-budget
Sheet: 5326

5326 |  |  |  | Current Hours |  | Year
 |  |  |  |  |  | 2012 |  |  |  |  |  |  |  |  |  |  |  | 2013 |  |  |  |  |  |  |  |  |  |  |  | 2014 |  |  |  | 2015 |  |  |  | 2016
 |  |  |  |  |  | 744 | 696 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 744 | 672 | 744 | 720 | 744 | 720 | 744 | 744 | 720 | 744 | 720 | 744 | 2160 | 2184 | 2208 | 2208 | 2160 | 2184 | 2208 | 2208 | 2184 | 2184 | 2208 | 2208
 |  |  |  |  | Projected 2011 End | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th
Projected Future Hours
Spreadsheet: larry_campbell__21443__VaR Calculator
Sheet: Power

 | Approximate VaR Calculator
 | Instructions:
 |  | The calculations are very rough and should never be used for trading decisions
 |  | Enter data in the areas clolored as:
 |  | Basis VaR is calculated as a hedge between NYMEX and FP (i.e. Long Nymex, Short FP)
 |  | Do not touch Blue and Red cells
 | Postions |  | 1 | 2 | 3 | 4 | 5
 | Curves |  | Cinergy | Entergy | PJM
 | MWs per Day |  | 300 | -300 | 100 | 50 | 50
 | Number of Months |  | 1 | 1 | 1 | 5 | 5
 | Price |  | 40 | 45 | 50 | 4.55 | 5
 | Vol |  | 0.6 | 0.6 | 0.8 | 0.6 | 0.6
 | Postion (Mwhs)
 | Value-at-Risk
 |  |  |  | 1+2 | 1+2+3 | 1+2+3+4 | 1+2+3+4+5
 | Aggregate Value-at-Risk
 |  | Correlation Matrix
 |  |  | 1
 |  |  | 0.2 | 1
 |  |  | 0.95 | 0.92 | 1
 |  |  | 0.94 | 0.95 | 0.9 | 1
 |  |  | 0.85 | 0.99 | 0.89 | 0.85 | 1
Spreadsheet: 198504d1354802100-problem-with-copying-vlookup-shytot-2-a
Sheet: Sheet2

 |  |  |  | Range1
 |  |  |  | AB | BB | GK | HL | PB | ML
 |  | Range2 |  | DATA
 |  | 2012-01-01 00:00:00 |  | 21 | 2 | 3 | 4 | 5 | 6
 |  | 2012-01-02 00:00:00 |  | 22 | 2 | 3 | 4 | 5 | 6
 |  | 2012-01-03 00:00:00 |  | 23 | 2 | 3 | 4 | 5 | 6
 |  | 2012-01-04 00:00:00 |  | 24 | 2 | 3 | 4 | 5 | 6
 |  | 2012-01-05 00:00:00 |  | 25 | 2 | 3 | 4 | 5 | 6
 |  | 2012-01-06 00:00:00 |  | 26 | 2 | 3 | 4 | 5 | 6
 |  | 2012-01-07 00:00:00 |  | 27 | 2 | 3 | 4 | 5 | 6
 |  | 2012-01-08 00:00:00 |  | 28 | 2 | 3 | 4 | 5 | 6
 |  | 2012-01-09 00:00:00 |  | 29 | 2 | 3 | 4 | 5 | 6
 |  | 2012-01-10 00:00:00 |  | 30 | 2 | 3 | 4 | 5 | 6
 |  | 2012-01-11 00:00:00 |  | 31 | 2 | 3 | 4 | 5 | 6
 |  | 2012-01-12 00:00:00 |  | 32 | 2 | 3 | 4 | 5 | 6
 |  | 2012-01-13 00:00:00 |  | 33 | 2 | 3 | 4 | 5 | 6
 |  | 2012-01-14 00:00:00 |  | 34 | 2 | 3 | 4 | 5 | 6
 |  | 2012-01-15 00:00:00 |  | 35 | 2 | 3 | 4 | 5 | 6
 |  | 2012-01-16 00:00:00 |  | 36 | 2 | 3 | 4 | 5 | 6
 |  | 2012-01-17 00:00:00 |  | 37 | 2 | 3 | 4 | 5 | 6
 |  | 2012-01-18 00:00:00 |  | 38 | 2 | 3 | 4 | 5 | 6
 |  | 2012-01-19 00:00:00 |  | 39 | 2 | 3 | 4 | 5 | 6
 |  | 2012-01-20 00:00:00 |  | 40 | 2 | 3 | 4 | 5 | 6
 |  | 2012-01-21 00:00:00 |  | 41 | 2 | 3 | 4 | 5 | 6
 |  | 2012-01-22 00:00:00 |  | 42 | 2 | 3 | 4 | 5 | 6
 |  | 2012-01-23 00:00:00 |  | 43 | 2 | 3 | 4 | 5 | 6
 |  | 2012-01-24 00:00:00 |  | 44 | 2 | 3 | 4 | 5 | 6
 |  | 2012-01-25 00:00:00 |  | 45 | 2 | 3 | 4 | 5 | 6
 |  | 2012-01-26 00:00:00 |  | 46 | 2 | 3 | 4 | 5 | 6
 |  | 2012-01-27 00:00:00 |  | 47 | 2 | 3 | 4 | 5 | 6
 |  | 2012-01-28 00:00:00 |  | 48 | 2 | 3 | 4 | 5 | 6
 |  | 2012-01-29 00:00:00 |  | 49 | 2 | 3 | 4 | 5 | 6
 |  | 2012-01-30 00:00:00 |  | 50 | 2 | 3 | 4 | 5 | 6
 |  | 2012-01-31 00:00:00 |  | 51 | 2 | 3 | 4 | 5 | 6
 |  | 2012-02-01 00:00:00 |  | 52 | 2 | 3 | 4 | 5 | 6
 |  | 2012-02-02 00:00:00 |  | 53 | 2 | 3 | 4 | 5 | 6
 |  | 2012-02-03 00:00:00 |  | 54 | 2 | 3 | 4 | 5 | 6
 |  | 2012-02-04 00:00:00 |  | 55 | 2 | 3 | 4 | 5 | 6
 |  | 2012-02-05 00:00:00 |  | 56 | 2 | 3 | 4 | 5 | 6
 |  | 2012-02-06 00:00:00 |  | 57 | 2 | 3 | 4 | 5 | 6
Spreadsheet: 804248d1667964243-formula-to-count-the-number-of-dates-entered-book10
Sheet: Board Lease Template

Stable Name
Address
Address 2
Date: October 2022
Horse Owner Name
Address
Address 2
Horse Name:
Previous Balance:
Payments Received:
Balance carried forward:
Board |  |  |  | 100
NYS 7% Tax
Turnout, Lunge & Walks
Date/s |  | 6
Staff [NAME]
Date/s |  | 20
Lessons
Date/s (Semi Private) |  | 40
Date/s (Private) |  | 45
Special Care
Current Statement Charges
Total Due
Spreadsheet: 124932d1318735266-excel-2007-lookup-formula-in-a-table-given-row-and-column-sample
Sheet: Sheet1

Pack Size | Weeks |  |  |  |  | weeks
1 Gallon | 3 | #N/A |  |  | Pack size | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  |  |  |  | 1.5 Litre | 2.52 | 5.03 | 7.55 | 10.06 | 12.58 | 15.09 | 17.61 | 20.13 | 22.64 | 25.16 | 27.67 | 30.19
 |  |  |  |  | 1/2 Gallon | 2 | 4 | 6 | 8 | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24
 |  |  |  |  | 2 Litre | 1.89 | 3.77 | 5.66 | 7.55 | 9.43 | 11.32 | 13.21 | 15.09 | 16.98 | 18.87 | 20.75 | 22.64
 |  |  |  |  | 2.5 Litre | 1.51 | 3.02 | 4.53 | 6.04 | 7.55 | 9.06 | 10.57 | 12.08 | 13.58 | 15.09 | 16.6 | 18.11
 |  |  |  |  | 1 Gallon | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  |  |  |  | 5 Litre | 0.76 | 1.52 | 2.27 | 3.03 | 3.79 | 4.55 | 5.3 | 6.06 | 6.82 | 7.58 | 8.33 | 9.09
 |  |  |  |  | 2.5 Gallon | 0.4 | 0.8 | 1.2 | 1.6 | 2 | 2.4 | 2.8 | 3.2 | 3.6 | 4 | 4.4 | 4.8
 |  |  |  |  | 5 Gallon | 0.2 | 0.4 | 0.6 | 0.8 | 1 | 1.2 | 1.4 | 1.6 | 1.8 | 2 | 2.2 | 2.4
 |  |  |  |  | 55 [NAME] | 0.02 | 0.04 | 0.05 | 0.07 | 0.09 | 0.11 | 0.13 | 0.15 | 0.16 | 0.18 | 0.2 | 0.22
 |  |  |  |  | 210 litre | 0.02 | 0.04 | 0.05 | 0.07 | 0.09 | 0.11 | 0.13 | 0.14 | 0.16 | 0.18 | 0.2 | 0.22
 |  |  |  |  | 100 Gallon | 0.01 | 0.02 | 0.03 | 0.04 | 0.05 | 0.06 | 0.07 | 0.08 | 0.09 | 0.1 | 0.11 | 0.12
Spreadsheet: 16c0646d-9f7b-4557-b1f0-b5748af1739e
Sheet: 39

شركت ساختماني گسترش و نوسازي صنايع ايرانیان مانا(سهامي خاص)
يادداشتهاي [NAME] مالي
دوره مالي ششماهه منتهي به 31 خرداد ماه 1390
27-خالص ساير درآمدهاو هزينه هاي غير عملياتي
خالص ساير درآمدهاو هزينه هاي غير عملياتي متشكل از اقلام زير مي باشد:
 |  |  |  | 1390/03/31 |  | 1389/06/31 |  | 1389/09/30
 |  |  |  | ريال |  | ريال |  | ريال
درآمد حاصل از فروش دارائی های ثابت عطف به یادداشت 12-9 و 3-11 |  |  |  | 246808296 |  | -122842214 |  | 66575531193
سود حاصل از اجاره ماشين آلات و وسائط نقليه |  |  |  | 163822670 |  | 195876647 |  | 244990647
سود حاصل از سپرده گذاري هاي بلند مدت و كوتاه مدت نزد بانك ها |  |  |  | 898212002 |  | 709144325 |  | 1021472121
زیان ناشي از تسعير دارائيهاي ارزي |  |  |  | 0 |  | -1111851 |  | -4415310
[NAME] ( زیان )حاصل از فروش موجودیها |  |  |  | 0 |  | 0 |  | 24510000
درآمد حاصل از اجاره ساختمان |  |  |  | 854125000 |  | 550000000 |  | 801875000
[NAME] نامه حسن اجرای تعهدات [NAME] |  |  |  | 0 |  | 1959053147 |  | 1954268750
سایر |  |  |  | 0 |  | 24032035522
28-صورت تطبيق [NAME]
صورت تطبيق سودعملياتي با جريان خالص ورود و ( خروج ) وجه نقد ناشي از فعاليت هاي عملياتي به شرح زير است:
 |  |  |  | 1390/03/31 |  | 1389/06/31 |  | 1389/09/30
 |  |  |  | ريال |  | ريال |  | ريال |  |  | 90 |  | 89
[NAME] |  |  |  |  |  | -4198846145 |  | 8193000000
هزينه استهلاك |  |  |  |  |  | 2217536288 |  | 3170000000 |  | 2067765160
[NAME]کاهش) در ذخيره مزاياي پايان خدمت كاركنان |  |  |  |  |  | 1131653719 |  | 2214000000 |  |  | 10363884882 |  | 8355739578
افزایش موجودي مواد و كالا |  |  |  |  |  | 30571365175 |  | 16138870030 |  |  | 13331416599 |  | 34585430409
[NAME] (کاهش) پیش پرداختهای عملیاتی |  |  |  |  |  | -23127453448 |  | -10380000000 |  |  | 70120138082 |  | 32271397072
افزایش (کاهش) حسابهاي دريافتني [NAME] |  |  |  |  |  | -67507912560 |  | -188306000000 |  |  | 700709733014 |  | 612882857805
افزایش (کاهش) حسابهای پرداختنی عملیاتی |  |  |  |  |  | 80224107818 |  | 94593000000 |  |  | 298423080384 |  | 208721426507
افزایش پیش دریافتهای عملیاتی |  |  |  |  |  | 22415491001 |  | 47721299336 |  |  | 157855244864 |  | 136829044699
خالص سایر درآمد ها و هزینه های غیر عملیاتی |  |  |  |  |  | 3047353465 |  | 22938000000 |  | 2162967968
[NAME]
Spreadsheet: 224150d1364471113-creating-schematic-how-schematic-example
Sheet: Sheet1

 | 300m | Layer 1 |  |  |  |  |  |  |  | Layer 2 |  |  |  |  |  |  |  |  | Layer 5 |  |  |  |  |  |  |  | Layer 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50m xs 250m
 |  |  |  |  |  |  |  |  |  |  |  |  | 100m xs 200m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.2
 | 250m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 200m xs 100m |  |  |  |  |  | Layer 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50m xs 200m
 |  |  | 300m xs 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.2
 | 200m |  |  |  |  |  |  |  |  | Layer 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Layer 9
 |  |  |  |  |  |  |  |  |  |  |  |  | 50m xs 150m
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.15 |  |  |  |  |  |  |  |  |  |  | 100m xs 100m
 | 150m |  |  |  |  |  |  |  |  | Layer 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.4 |  |  |  |  |  |  | 0.2
 | 100m |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Layer 6
 |  |  |  |  |  |  |  |  |  |  |  |  | 150m xs 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100m xs 0
 |  |  |  |  |  |  |  |  | 0.25 |  |  |  |  |  |  |  |  | 0.15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.6
 | 0 |  |  |  |  |  |  |  | 0.25 |  |  |  |  |  |  |  |  | 0.4 |  |  |  |  |  |  |  | 0.8 |  |  |  |  |  |  | 1
Spreadsheet: michelle_lokay__26645__redrockcomparison
Sheet: Sheet2

Volume | 30
Rate | 0.42
Years | 3
NPV
Discount Factor
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
Risk Free Rate | 0.075
Discount Factor @ Rf
Spreadsheet: 726148d1617074885-missing-row-on-a-sheet-when-a-row-is-added-to-table-thats-on-another-sheet-sample1
Sheet: Bank Register

Bank | Account Type | Account Number | Account Descrption
Arvest | Checking | 58585858
Arvest | Savings | 7770000
Arvest | Checking | 8877788
BearState | CD | 123654789
FirstBank | Checking | 6845846574
Arvest | Checking | 8877788
BearState | CD | 123654789
BearState | CD | 123654789
FirstBank | Checking | 6845846574
CityBank | Checking | 9874562310
Spreadsheet: 74227d1274797339-team-scorecard-calulation-scorecard_april_2010
Sheet: April_2010

 |  | 1-20 |  | 1-20 |  | 1-10 |  | 1-10 |  | 1-10 |  | 1-10 |  | 1-10 |  | 1-10
 |  | Incident Closed |  | SRM Closed |  | CTS |  | Health Check-up |  | Back up |  | Exit |  | ITSM Tranf |  | SRM/SR Tranf
Sl no | Engineer Name | Count | Score | Count | Score | Count | Score | Count | Score | Count | Score | Count | Score | Count | Score | Count | Score | Total Closure Count | Total Score %
1 | Sum | 36 | 7.741935483870968 | 14 | 18.66666666666666 | 215 | 2.949245541838134 | 67 | 4.620689655172414 | 0 | 0 | 117 | 3.952702702702703 | 86 | 10 | 1 | 0.4761904761904762 | 536 | 48.40743052644136
2 | Shil | 39 | 8.387096774193548 | 8 | 10.66666666666667 | 729 | 10 | 145 | 10 | 42 | 10 | 296 | 10 | 11 | 1.279069767441861 | 0 | 0 | 1270 | 60.33283320830208
3 | [NAME] | 73 | 15.6989247311828 | 9 | 12 | 0 | 0 | 2 | 0.1379310344827586 | 6 | 1.428571428571428 | 43 | 1.452702702702703 | 28 | 3.255813953488372 | 0 | 0 | 161 | 33.97394385042806
4 | Nag | 85 | 18.27956989247312 | 15 | 20 | 58 | 0.7956104252400549 | 0 | 0 | 7 | 1.666666666666667 | 218 | 7.364864864864865 | 52 | 6.046511627906977 | 0 | 0 | 435 | 54.15322347715168
5 | Shiv | 78 | 16.7741935483871 | 9 | 12 | 211 | 2.89437585733882 | 57 | 3.931034482758621 | 1 | 0.2380952380952381 | 35 | 1.182432432432432 | 39 | 4.534883720930233 | 15 | 7.142857142857142 | 445 | 48.69787242279959
6 | Koul | 93 | 20 | 5 | 6.666666666666666 | 0 | 0 | 14 | 0.9655172413793103 | 0 | 0 | 59 | 1.993243243243243 | 43 | 5 | 21 | 10 | 235 | 44.62542715128922
7 | GV | 61 | 13.11827956989247 | 1 | 1.333333333333333 | 160 | 2.194787379972565 | 31 | 2.137931034482758 | 0 | 0 | 139 | 4.695945945945946 | 41 | 4.767441860465116 | 9 | 4.285714285714286 | 442 | 32.53343340980648
8 | Ram | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 465 | 0.2150537634408602 | 61 | 1.333333333333333 | 1373 | 0.01371742112482853 | 316 | 0.06896551724137931 | 56 | 0.2380952380952381 | 907 | 0.03378378378378379 | 300 | 0.1162790697674419 | 46 | 0.4761904761904762
 |  |  |  |  |  |  | 15.65914056809905 |  | 21.20253164556962 |  | 0 |  | 12.89966923925027
 | Description | Points
 | Incident Closed | 20
 | SRM Closed | 20
 | CTS | 10
 | Health Chk - Daily Chk List | 10
 | Back Up Activity | 10
 | Exit | 10
 | ITSM TR | 10
 | SR/ SRM TR | 10
 | Total | 100
Spreadsheet: 47788d1246969686-text-colour-change-depending-on-outcome-of-formula-tom
Sheet: Pay

 | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday |  | Total
 | Hours | Pay | Hours | Pay | Hours | Pay | Hours | Pay | Hours | Pay | Hours | Pay | Hours | Pay | Hours | Pay
Spreadsheet: 121947d1316521899-excel-2007-if-according-to-conditions-sample
Sheet: Sheet2

 |  |  |  |  | pp under 10 | pp above 10 | dp under 10 | dp above 10
first day | type 1 | 1 | type 2 | 5 | 2 | 1 | 2 | 0
secound day | type 1 | 1 | type 3 | 11 | 1 | 0 | 2 | 1
Spreadsheet: 217001d1361960986-calculating-ytd-of-monthly-averages-ytdcalculations-1-
Sheet: Sheet1

 | 2012-01-01 00:00:00 |  | 2012-02-01 00:00:00 |  | 2012-03-01 00:00:00 |  | 2012-04-01 00:00:00 |  | 2012-05-01 00:00:00 |  | 2012-06-01 00:00:00 |  | 2012-07-01 00:00:00 |  | 2012-08-01 00:00:00 |  | 2012-09-01 00:00:00 |  | 2012-10-01 00:00:00 |  | 2012-11-01 00:00:00 |  | 2012-12-01 00:00:00 |  |  | 2012-01-01 00:00:00 |  | 2012-02-01 00:00:00 |  | 2012-03-01 00:00:00 |  | 2012-04-01 00:00:00 |  | 2012-05-01 00:00:00 |  | 2012-06-01 00:00:00 |  | 2012-07-01 00:00:00 |  | 2012-08-01 00:00:00 |  | 2012-09-01 00:00:00 |  | 2012-10-01 00:00:00 |  | 2012-11-01 00:00:00 |  | 2012-12-01 00:00:00
 | Monthly |  | Monthly |  | Monthly |  | Monthly |  | Monthly |  | Monthly |  | Monthly |  | Monthly |  | Monthly |  | Monthly |  | Monthly |  | Monthly |  |  | Teams |  | Teams |  | Teams |  | Teams |  | Teams |  | Teams |  | Teams |  | Teams |  | Teams |  | Teams |  | Teams |  | Teams
xxx | 30000 |  | 20000 |  | 21000 |  | 20000 |  | 25000 |  | 26000 |  | 36000 |  | 40000 |  | 27000 |  | 25800 |  | 28000 |  | 34000 |  |  | 25 |  | 30 |  | 25 |  | 25 |  | 25 |  | 26 |  | 24 |  | 28 |  | 29 |  | 21 |  | 23 |  | 20
 | SELECT DATE |  | YTD | YTD per Team
 | 2012-04-01 00:00:00
 |  |  |  |  | If the month chosen is April then we should have a formula that calculates as follows:   = (30000/25)+(20000/30)+(21000/25)+(20000/25)  Note : that this is a simple example and that my dates go back a few years and not just in 2012 Note2 :
 | 2012-01-01 00:00:00
 | 2012-02-01 00:00:00
 | 2012-03-01 00:00:00
 | 2012-04-01 00:00:00
 | 2012-05-01 00:00:00
 | 2012-06-01 00:00:00
 | 2012-07-01 00:00:00
 | 2012-08-01 00:00:00
 | 2012-09-01 00:00:00
 | 2012-10-01 00:00:00
 | 2012-11-01 00:00:00
 | 2012-12-01 00:00:00
Spreadsheet: 711658d1609838305-match-row-and-column-and-return-value-example
Sheet: Oversikt 02-2020

 |  | Februar | SLA | VMS | HMS | AMS | SUM |  |  | Bokføring 02-2020
 | 2020 | [NAME] hittill i år | 4564198.223073 | 3687637.303616 | 734666.3432439998 | 375000 | 9361501.869933 |  |  | Beskrivelse |  |  | Beløp | D | K | Area | Product
 |  | Balanseført i januar | 3461199.178951 | 201700.448209 | 301521.3232099999 | 0 | 3964420.95037 |  |  | Periodisering SLA 02-2020 |  |  | 189763.2648638295 | 1531 | 3911 | 110 | 95
 |  | Balanseføres februar | 1102999.044122 | 3485936.855407001 | 433145.0200339998 | 375000 | 5397080.919562999 |  |  | Periodisering VMS 02-2020 |  |  | 3245086.954658207 | 3911 | 1531 | 110 | 80
 |  |  |  |  |  |  |  |  |  | Periodisering HMS 02-2020 |  |  | 146231.3375909681 | 3911 | 1531 | 110 | 45
 |  | Inntektsføring | SLA | VMS | HMS | AMS | SUM
 |  | Inntektsføres hittill i år | 3552850.590898568 | 501003.2577109124 | 666018.1637111851 | 61475.40983606558 | 4781347.422156732
 |  | Inntektsført januar | 1914801.396666838 | 260153.3569621192 | 379104.4812681534 | 31762.29508196722 | 2585821.529979078
 |  | Inntektsføres februar | 1638049.19423173 | 240849.9007487932 | 286913.6824430317 | 29713.11475409836 | 2195525.892177653
 |  |  |  |  |  | [NAME] (+)/Inntektsføres (-) | 3201555.027385346
 |  |  | Siste oppdatering feb kons.
 |  | February
 |  |  | Actual | Periodisering | Etter per.
 |  | Broadcast Facility & Metro Solutions | 5064.029448624001 |  | 5064.029448624001
 |  | Media & Production Networks | 19582.548386529 | -3245.086954658208 | 16337.46143187079
 |  | Management & Orchestration | 4160.018745718001 | -146.2313375909681 | 4013.787408127033
 |  | Support & Services | 3324.269452805001 | 189.7632648638295 | 3514.03271766883
 |  |  | 32130.866033676 | -3201.555027385346 | 28929.31100629066
 |  | 1531 - Fakturert, ikke opptj. inntekt | 01-2020 | 02-2020 | 03-2020 | 04-2020 | 05-2020 | 06-2020 | 07-2020 | 08-2020 | 09-2020 | 10-2020 | 11-2020 | 12-2020 | SUM
 |  | IB mnd | 19767030.91 | 21145630.33039092 | 24347185.35777627
 |  | [NAME] i mnd | 3964420.95037 | 5397080.919562999 |  |  |  |  |  |  |  |  |  |  | 9361501.869933
 |  | Inntektsført | 2585821.529979078 | 2195525.892177653 |  |  |  |  |  |  |  |  |  |  | 4781347.422156731
Spreadsheet: 025f689c-36bc-4a02-b352-3633394410cc
Sheet: $$ Current Serials

[NAME] vs. [NAME]
Current Serials Expenditures
 | FY 2006 | FY 2007 | FY 2008 | FY 2009 | FY 2010 | % Change
Peer Average
Peer Median
University of Rhode Island | 1622313 | 2497582 | 2880140 | 2320637 | 2514951
[NAME] University | 1043365 | 1005679 | 2267977 | 2770253 | 2435420
Montana State University - Bozeman | 2452664 | 2906724 | 2891380 | 2266768 | 4349575
North Dakota State University - Main Campus | 1766683.17 | 1640828 | 1984766 | 1956497 | U/A | U/A
University of Maine | 3590270 | 4097049 | 4283694 | 4598530 | 4811192
University of New Hampshire - Main Campus | 3891356 | 4542637 | 4563804 | 3674497 | 3837578
University of Vermont and State Ag. Coll. | U/A | 3464428 | 4873825 | 5214744 | 5375404 | U/A
University of Wyoming | 2454961 | 1851343 | 2740777 | 3057402 | 2344864
Source: ACRLMetrics
Revised: October 24, 2011, ajr
Spreadsheet: 38101d1236204631-circular-referencing-excel-coursework
Sheet: Invoice

 |  |  |  |  |  |  | VAT Invoice
Company Name
Invoice No |  | Invoice Date:
Customer:
Name |  | [NAME]
Street Address |  | 72 green way
Postcode |  | C012 8KS
Town/City |  | Colchester
Country |  | UK
Date | Description |  |  | Vat Code | Qty | VAT % | Price | Discount | Total | VAT | Net | Delete
 | Angled Sink Waste |  |  | 1 | 2 | 17.5 | 4.58 | 10% | 9.16 | 1.603 | 7.795744680851064
 |  |  |  |  |  |  |  | Total | 9.16
 |  |  |  |  |  |  |  | [NAME] | 1.603
 |  |  |  |  |  |  |  | Payment
 |  |  |  |  |  |  |  | Balance Due | 9.16
Spreadsheet: 188557df-1e70-4da0-aca5-ee5eeab30000
Sheet: 2RD OUT OF 199

ANON# | RANK
588135 | 25
588136 | 22
588159 | 44
588164 | 18
588191 | 3
588193 | 50
588199 | 32
588207 | 26
588239 | 16
588240 | 14
588252 | 41
588265 | 34
588298 | 1
588308 | 49
588318 | 7
588325 | 13
588333 | 9
588386 | 14
588388 | 33
588389 | 48
588405 | 37
588407 | 21
588409 | 27
588432 | 11
588498 | 20
588504 | 29
588506 | 28
588511 | 46
588516 | 30
588602 | 12
588604 | 4
588611 | 19
588626 | 42
588632 | 10
588639 | 38
588640 | 31
588644 | 6
588680 | 17
588696 | 24
588697 | 38
588730 | 36
588745 | 5
588753 | 43
588821 | 23
588847 | 35
588980 | 47
589081 | 45
589093 | 40
589220 | 2
597018 | 7
Spreadsheet: 888469d1738950939-pulldown-list-expenses
Sheet: 2025

 | Variable Cost 2025 (Credit Cards) |  |  |  | Hydro |  | Fixed Costs |  |  |  | Pay
 | # | Months | CIBC | RBC | [NAME] |  |  | Paid Off | Mortgage |  | # | 1st | 2nd | Total
 | 1 | January | 4694.5 | 81.84 | 82.54 |  |  | 235 | Taxes |  | 1 | 2100.64 | 2329.34
 |  | February |  |  |  |  |  | 726.49 | Condo Fees
 |  | March |  |  |  |  |  | 29.04 | OTIP Insurance
 |  | April |  |  |  |  |  | 169.02 | NLSC
 |  | May |  |  |  |  |  |  | Hydro (average)
 |  | June |  |  |  |  | Monthly
 |  | July |  |  |  |  | Yearly
 |  | August
 |  | September |  |  |  |  | Other Fixed Costs (piad on CC)
 |  | October |  |  |  |  | Paid on CIBC credit card under "Variable Cost" | 62.15 | Internet
 |  | November |  |  |  |  |  | 226 | Cell Phones
 |  | December |  |  |  |  |  |  | Insurance
 | Variable Cost |  |  |  |  |  |  | 400 | Gas |  | Total Pay
 | Average |  |  |  |  |  |  | 400 | Eating Out
 | Total Credit Card Spend |  |  |  |  |  |  | 200 | TTC
 | Variable Cost minus "Other Fixed Costs (piad on CC)" |  |  | Fixed Costs | Cash Spending |  | Monthly
 |  |  |  |  |  |  | Yearly
 |  |  | 2024 Total Expenditure |  | 70000 |  | One Time Pay | 275.88 | Life Insurance
 |  |  | 2025 Total Expenditure |  |  |  |  | 229.9 | Life insurance
 |  |  | Diffrence (2024 - 2025): |  |  |  | Yearly
 |  |  |  |  |  |  | Total Yearly
 |  |  |  |  |  |  | Fixed Monthly |  | January
 |  |  | Diffrence (Pay - Expenditure): |  |  |  | Variable Monthly
 |  |  | 2025 Montly Expenditure |  |  |  | Total Monthly