tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 879832d1727415613-currency-denomination-calculation-using-lambda-and-array-function-dhorpirdi-currency-spill-365-aligw
Sheet: Sheet1

 | 146356 | 146356
1000 |  |  |  |  | Answer Expected
500 | 0
100 | 3
50 | 1
20 | 0
10 | 0
5 | 1
2 | 0
1 | 1
Spreadsheet: 104215d1301864701-excel-sum-array-excel-q
Sheet: Sheet1

 | 2 | 1
 | 3
 | 4 | 2
 | 8
 | 2 | 1
 |  | 1
 | 4 | 2
 | 3 | 1
 |  | 2
Sum
[NAME]
Spreadsheet: 109761d1306524301-formula-requiring-three-actions-auto-data-sample
Sheet: Master Summary_Make and Dealer

Make | Dealer | NW % | SW % | SE % | NE % | W % | E % | NW #s | SW #s | NE #s | SE #s | W #s | E #s | TOTAL | Mkt. Share %
Acura | [NAME] | 0.2730923694779117 | 0.2168674698795181 | 0.1726907630522088 | 0.3373493975903614 | 0.4899598393574297 | 0.5100401606425703 | 68 | 54 | 43 | 84 | 122 | 127 | 249 | 0.5737327188940092 |  | 0
Acura | Motorcars Acura Volvo | 0.1196581196581197 | 0.2307692307692308 | 0.1196581196581197 | 0.5299145299145299 | 0.3504273504273504 | 0.6495726495726496 | 14 | 27 | 14 | 62 | 41 | 76 | 117 | 0.2695852534562212 |  | #N/A
Acura | [NAME] | 0.03571428571428571 | 0.2142857142857143 | 0.05357142857142857 | 0.6964285714285714 | 0.25 | 0.75 | 2 | 12 | 3 | 39 | 14 | 42 | 56 | 0.1290322580645161 |  | 0
Acura | All Others | 0.08333333333333333 | 0.3333333333333333 | 0 | 0.5833333333333334 | 0.4166666666666667 | 0.5833333333333334 | 1 | 4 | 0 | 7 | 5 | 7 | 12 | 0.02764976958525346 |  | 84 | 93 | 60 | 185
 | Total |  |  |  |  |  |  | 85 | 97 | 60 | 192 | 182 | 252 | 434 | 1
Spreadsheet: 789348d1659047721-dynamic-formula-for-standard-deviation-offset-volatility-formula-angelos19-
Sheet: Sheet1

 | B1 | Date | Monthly return
 | B2 | 2021-03-31 00:00:00 | 0.01 |  | Start date | 2021-03-31 00:00:00
 | B3 |  | 0.02 |  | End Date | 2022-06-30 00:00:00 |  | 2022-04-30 00:00:00
 | B4 |  | -0.01 |  | Months |  |  | 12
 | B5 |  | 0.01 |  | Annualised Volatility
 | B6 |  | -0.02
 | B7 |  | 0.025
 | B8 |  | 0.005
 | B9 |  | -0.04
 | B10 |  | 0.021
 | B11 |  | 0.035
 | B12 |  | -0.01
 | B13 |  | 0.005
 | B14 |  | 0.013
 | B15 |  | -0.01
 | B16 |  | 0.03
 | B17 |  | 0.02
Spreadsheet: 675907d1588551052-detecting-schedule-conflicts-minimal-sample
Sheet: 3-Carol

 | Schedule for employee #: | 3
 |  |  |  |  |  |  |  |  | Conflict detection |  |  |  |  |  | contains the lowest Employee # besides me who is also scheduled
Customer # | Sun | Mon | Tue | Wed | Thu | Fri | Sat |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Day with first conflict
1 | 1 | 0 | 1 | 0 | 1 | 0 | 0 |  |  |  | 2 |  | 2
2 | 0 | 1 | 0 | 1 | 0 | 1 | 0
3 | 0 | 0 | 1 | 0 | 0 | 1 | 1 |  |  |  |  |  |  | 2 | 2
Spreadsheet: 140513d1328793956-linked-drop-down-lists-and-vlookup-copy-of-testdata1
Sheet: Sheet3

Month | TL
Jan | [NAME]
Feb | George
Mar | [NAME]
Apr | [NAME]
May | Zareen
Jun | Adeel
Jul | [NAME]
Aug | Fred
Sep | [NAME]
Oct | Nona
Nov | [NAME]
Dec | [NAME]
 | Chelsea
 | [NAME]
 | Mark
 | [NAME]
 | Vijay
Spreadsheet: 797606d1663993225-find-last-value-in-table-and-place-in-new-cell-test
Sheet: Sheet1

Column 1 Last Value | 64.1 | Column 1 average |  | 45.1
Column 2 Last Value | 147.21 | Column 2 average |  | 113.77
Column 3 Last Value | 461.8 | Column 3 average |  | 160.4
 |  |  | Column1 | Column2 | Column3 | Column4
The columns have about 120 lines and I need the last value >0 in each column in cells B2, B3 and B4.  I need the average of each column without counting the 0s being included in Cell E2, E3 and E4. |  |  | 45 | 231.15 | 361.45
 |  |  | 46.49 | 0 | 99.41
 |  |  | 48.97 | 46.79 | 151.48
 |  |  | 0 | 0 | 210.78
 |  |  | 48.97 | 15.79 | 0
 |  |  | 0 | 0 | 88.97
 |  |  | 46.47 | 0 | 0
 |  |  | 0 | 0 | 0
 |  |  | 33.75 | 159.48 | 161.11
 |  |  | 19.99 | 145.85 | 0
 |  |  | 45.78 | 97.78 | 110.14
 |  |  | 0 | 66.1 | 99.87
 |  |  | 51.46 | 147.21 | 0
 |  |  | 0 | 0 | 0
 |  |  | 64.1 | 0 | 0
Spreadsheet: 713679d1610878994-translating-multiple-column-index-to-other-work-sheets-film-tester-tidied-up-
Sheet: Directors

Director | Total | Ave Score | Oscars | Ave Time | Best Film | Score | Worst Film | Score | Bechdel | BOAT
[NAME]
[NAME]
[NAME]
[NAME]
The Coen Brothers
[NAME]
[NAME]
Tyler Nilson, [NAME]
[NAME] Coppola
Woody Allen
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME], [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME], [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME], [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME], [NAME], [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Tyler Nilson
Spreadsheet: 789622d1659248849-to-find-sum-of-continuous-ive-or-ive-numbers-as-long-as-opposite-sign-value-comes-pq-using-groupkind-local-aligw
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Using PQ: |  | With helper columns:
 |  |  |  |  | Values | Helper1 | Helper2 |  | Expected Results | Expected Results |  | Expected Results
 |  |  |  | 1 | 2 |  |  |  |  | 6
 |  |  |  |  | 4 |  |  |  |  | -2 |  | -2
 |  |  |  | 2 | -2 |  |  |  |  | 16 |  | 16
 |  |  |  | 3 | 1 |  |  |  |  | -21 |  | -21
 |  |  |  |  | 5 |  |  |  |  | 1 |  | 1
 |  |  |  |  | 6 |  |  |  |  | -58 |  | -58
 |  |  |  |  | 4 |  |  |  |  | 4 |  | 4
 |  |  |  | 4 | -5 |  |  |  |  | -10 |  | -10
 |  |  |  |  | -4 |  |  |  |  | 12 |  | 12
 |  |  |  |  | -12 |  |  |  |  | -20 |  | -20
 |  |  |  | 5 | 1 |  |  |  |  | 101 |  | 101
 |  |  |  | 6 | -12
 |  |  |  |  | -45
 |  |  |  |  | -1
 |  |  |  | 7 | 1
 |  |  |  |  | 2
 |  |  |  |  | 1
 |  |  |  | 8 | -10
 |  |  |  | 9 | 12
 |  |  |  | 10 | -20
 |  |  |  | 11 | 1
 |  |  |  |  | 50
 |  |  |  |  | 50
Spreadsheet: 729264d1618992098-extracting-and-arranging-data-salary
Sheet: Data

 | [NAME] (Salary) |  |  |  |  | JVN0711 | 3821.45
 | [NAME] (Pf) |  |  |  |  | JVN0711 | 518.21
 | [NAME] (Gt) |  |  |  |  | JVN0711 | 215.83
 | Md Pintu [Salary] |  |  |  |  | JVN0711 | 3620.32
 | Md Pintu [Pf] |  |  |  |  | JVN0711 | 490.94
 | Md Pintu [Gt] |  |  |  |  | JVN0711 | 204.47
 | [NAME] [Salary] |  |  |  |  | JVN0711 | 2815.81
 | [NAME] [Pf] |  |  |  |  | JVN0711 | 381.84
 | [NAME] [Gt] |  |  |  |  | JVN0711 | 159.04
 | [NAME].[NAME] [Salary] |  |  |  |  | JVN0711 | 1206.77
 | [NAME].[NAME] [Pf] |  |  |  |  | JVN0711 | 136.65
 | [NAME].[NAME] [Gt] |  |  |  |  | JVN0711 | 68.16
 | Amit Choudhary (Salary) |  |  |  |  | JVN0084 | 12067.74
 | Amit Choudhary (PF) |  |  |  |  | JVN0084 | 1636.45
 | Amit Choudhary (Gratuity) |  |  |  |  | JVN0084 | 681.58
Spreadsheet: 462327d1464009252-selecting-data-according-to-text-and-placing-in-graph-capital-expense-2016-2017
Sheet: Bradford

Bradfords Capital Expense 2016-2017
Improment/Equipment | In-house/ Subcontract | TimeScale | Expense | possible Savings |  |  | Bradford
 | inhouse |  |  |  |  |  | expense | Potential Saving
Seal up old waste oil tank | sub contract |  | 1500
Wheel/tyre balancer | sub contract |  | 2800
Floor scrubber | sub contract |  | 2500
add a few led in workshop/Parts 15 | inhouse |  | 5250 | 2800
gate fencing | inhouse |  | 2500
adblue tank | sub contract |  | 4200
yard repair
air con machine
Totals
Spreadsheet: 271291d1381896641-sum-with-blank-cell-that-has-if-formula-wip-calculator
Sheet: March

***Balance Sheet is the "holder" of the WIP number.  It should always match report total.
Period 3 | March | Work In Progress Report
 |  | A | B | C | D | E | F | G | H | J
 |  | Job ID | Contract price | Esimated Job Cost Expenses | Estimated GP% | Total Actual Job Cost to date | % of completion of each job in accounting | Earned Revenue | TOTAL Invoiced to Client to date | Over(-) or [NAME]) Status
 |  | Report Total
 |  | Once you have given your final invoice for a project, take the project off this report. |  |  |  |  |  | Report Status
 |  |  |  |  |  |  |  | Prior Period to adjust
Entries for BN Numbers
Period 3 | March |  |  | Enter the amount showing on line #3 of the appropriate 'Profit Center' in the 'Profit Center" tab.
 |  |  |  | Enter this amount on line #3 of the 'Balance Sheet' in the 'Financial Data" tab.
 |  |  |  | Enter this amount on line #13 of the 'Balance Sheet' in the 'Financial Data" tab.
Journal Entries for Accounting Software
Period 3 | March |  | Journal Entry      Dated March 31
 |  |  | G/L Account |  | Debit | Credit
 |  |  | WIP Income Acct
 |  |  | WIP Asset Acct
 |  |  | !!!REVERSE JOURNAL ENTRY!!!      Dated April 1
 |  |  | G/L Account |  | Debit | Credit
 |  |  | WIP Income Acct
 |  |  | WIP Asset Acct
 |  |  | Journal Entry      Dated March 31
 |  |  | G/L Account |  | Debit | Credit
 |  |  |  | WIP Income Acct
 |  |  |  | WIP Liability Acct
 |  |  | !!!REVERSE JOURNAL ENTRY!!!      Dated April 1
 |  |  | G/L Account |  | Debit | Credit
 |  |  |  | WIP Income Acct
 |  |  |  | WIP Liability Acct
Spreadsheet: 716186d1612093665-rent-spreadsheet-formulas-functions-assistance-please-rent-spread-sheet-help
Sheet: Summary

Rent Pay Records
Property | Rental period (d) | Amount payable per period | Rent LAST paid | Next Due Date | Last Amount Paid | Total paid to date | Rental payments made | ARREARS3 | ARREARS2
1 | 7 | 100
2 | 7 | 200
3 | 7 | 300
4 | 7 | 400
2020-02-01 00:00:00 | Pay $335
2 | 2020-02-08 00:00:00 |  | Pay $335
3 | 2020-02-15 00:00:00 |  | Pay $335
4 | 2020-02-22 00:00:00 |  | Pay $335
5 | 2020-02-29 00:00:00 |  | Pay $335
6 | 2020-03-07 00:00:00 |  | Pay $335
7 | 2020-03-14 00:00:00 |  | Pay $335
8 | 2020-03-21 00:00:00 |  | Pay $335
9 | 2020-03-28 00:00:00 |  | Pay $335
10 | 2020-04-04 00:00:00 |  | Pay $335
11 | 2020-04-10 00:00:00 |  | Pay $335
12 | 2020-04-17 00:00:00 |  | Pay $335
13 | 2020-04-24 00:00:00 |  | Pay $335
14 | 2020-05-01 00:00:00 |  | Pay $335
15 | 2020-05-08 00:00:00 |  | Pay $335
16 | 2020-05-15 00:00:00 |  | Pay $335
17 | 2020-05-22 00:00:00 |  | Pay $335
18 | 2020-05-29 00:00:00 |  | Pay $335
19 | 2020-06-05 00:00:00 |  | Pay $335
20 | 2020-06-12 00:00:00 |  | Pay $335
21 | 2020-06-19 00:00:00 |  | Pay $335
22 | 2020-06-26 00:00:00 |  | Pay $335
23 | 2020-07-03 00:00:00 |  | Pay $335
24 | 2020-07-10 00:00:00 |  | Pay $335
25 | 2020-07-17 00:00:00 |  | Pay $335
26 | 2020-07-24 00:00:00 |  | Pay $335
27 | 2020-07-31 00:00:00 |  | Pay $335
28 | 2020-08-07 00:00:00 |  | Pay $335
29 | 2020-08-14 00:00:00 |  | Pay $335
30 | 2020-08-21 00:00:00 |  | Pay $335
31 | 2020-08-28 00:00:00 |  | Pay $335
32 | 2020-09-04 00:00:00 |  | Pay $335
33 | 2020-09-11 00:00:00 |  | Pay $335
34 | 2020-09-18 00:00:00 |  | Pay $335
35 | 2020-09-25 00:00:00 |  | Pay $335
36 | 2020-10-02 00:00:00 |  | Pay $335
37 | 2020-10-10 00:00:00 |  | Pay $335
38 | 2020-10-17 00:00:00 |  | Pay $335
39 | 2020-10-24 00:00:00 |  | Pay $335
40 | 2020-10-31 00:00:00 |  | Pay $335
41 | 2020-11-07 00:00:00 |  | Pay $335
42 | 2020-11-14 00:00:00 |  | Pay $335
43 | 2020-11-21 00:00:00 |  | Pay $335
44 | 2020-11-28 00:00:00 |  | Pay $335
45 | 2020-12-05 00:00:00 |  | Pay $335
46 | 2020-12-12 00:00:00 |  | Pay $335
47 | 2020-12-19 00:00:00 |  | Pay $335
48 | 2020-12-26 00:00:00 |  | Pay $335
Spreadsheet: 837333d1690061464-want-to-average-across-to-get-year-to-date-ytd-average-and-ignore-0-zeros-monthly-ytd-average-answered-v1
Sheet: Sheet1

 | 2023-07-22 00:00:00
 |  |  | Want to AVERAGE ACROSS to get Year to Date (YTD) Average and ignore " 0 " / zeros
 |  |  | -- There will be months with no or 0 (zero) activities and other months with activity per customer accounts (not shown)
 |  | ↓↓ | ↓↓
 |  | ↓↓ | ↓↓
 |  | ↓↓ | ↓↓ |  |  | 2023-01-01 00:00:00 |  |  |  |  |  | 2023-04-01 00:00:00
 |  | ↓↓ | ↓↓ |  |  | 2023-01-31 00:00:00
 |  | ↓↓ | ↓↓
 | Total  Amount  Received | YTD TPS | Monthly  YTD Average |  | TPS | January  Payments | TPS | February  Payments | TPS | March  Payments | TPS | April  Payments | TPS | May  Payments | TPS | June  Payments | TPS | July  Payments | TPS | August  Payments | TPS | September  Payments | TPS | October  Payments | TPS | November  Payments | TPS | December  Payments
 | -139989.33 |  |  |  | 0 | 0 | 0 | 0 | 2 | -14241.33 | 0 | 0 | 2 | -109108 | 1 | -16640 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | -74736.12 |  |  |  | 0 | 0 | 0 | 0 | 1 | -48876.93 | 0 | 0 | 1 | -5423.98 | 1 | -395.11 | 1 | -20040.1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | -4000.45 |  |  |  | 0 | 0 | 0 | 0 | 1 | -4000.45 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | -111637.83 |  |  |  | 2 | -15047.36 | 3 | -22062.2 | 2 | -23032.5 | 2 | -14880.64 | 2 | -14548.38 | 2 | -14558.98 | 1 | -7507.77 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | -58546.76 |  |  |  | 1 | -5142.64 | 2 | -14288.77 | 0 | 0 | 2 | -19070.06 | 0 | 0 | 1 | -84.42 | 2 | -19960.87 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | -26291.97 |  |  |  | 1 | -1891.08 | 2 | -1994.25 | 0 | 0 | 2 | -9878.910000000002 | 1 | -5556.92 | 2 | -6386.26 | 1 | -584.55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | -17860.21 |  |  |  | 0 | 0 | 1 | -275 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | -17585.21 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | -4767.09 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 1 | -2211.55 | 0 | 0 | 1 | -2555.54 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | -33727.74000000001 |  |  |  | 1 | -968.6 | 3 | -7223.2 | 4 | -12126.24 | 2 | -2110.54 | 2 | -9694.26 | 2 | -1060.17 | 1 | -544.73 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 0bd71387-a280-4c47-91b8-851091994254
Sheet: Sheet1

Table 10--U.S. oilseed meal prices | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Marketing | Soybean | Cottonseed | Sunflowerseed | Peanut | Canola | Linseed
year | meal 2 | meal 3 | meal 4 | meal 5 | meal 6 | meal 7
 | $/Short ton
2002/03 | 181.58 | 146.12 | 105 | 128.35 | 144.06 | 122.91
2003/04 | 256.05 | 183.47 | 111.14 | 177.56 | 188.45 | 159.25
2004/05 | 182.9 | 124.04 | 85.5 | 118.34 | 139.75 | 115.55
2005/06 | 174.1658333333333 | 144.2716666666667 | 77.46400000000001 | 106.9781818181818 | 140.5183333333333 | 115.53
2006/07 | 205.44 | 150.36 | 104.88 | 100 | 173.5 | 133.01
2007/08 | 335.94 | 253.81 | 172.81 |  | 251.32 | 228.81
2008/09 | 331.17 | 255.23 | 152.46 |  | 248.82 | 220.89
2009/10 | 311.27 | 220.9 | 151.04 |  | 224.92 | 209.23
2010/11 | 345.52 | 273.84 | 219.72 |  | 263.63 | 240.65
2011/12 | 393.53 | 275.13 | 246.75 |  | 307.59 | 265.68
2012/131 | 450 | 305 | 240 |  | 350 | 315
2013/141 | 290-330 | 215-255 | 145-185 |  | 225-265 | 190-230
2011/12
October | 301.45 | 255.63 | 232.5 |  | 238.7 | 243.75
November | 290.37 | 240.5 | 224 |  | 235.2 | 239
December | 281.65 | 220.63 | 225.63 |  |  | 221.25
January | 310.65 | 213 | 223.5 |  | 253.98 | 209
February | 330.37 | 190 | 191.88 |  | 257.63 | 193.75
March | 365.95 | 225 | 191.88 |  | 277.83 | 216.25
April | 394.29 | 240.63 | 211.25 |  | 313.38 | 256.25
May | 415.17 | 270 | 230.5 |  | 333.69 | 279
June | 422.59 | 294.38 | 226.88 |  | 335.26 | 287.5
July | 515.82 | 350.5 | 300.5 |  | 378.86 | 343
August | 564.69 | 407.5 | 348.13 |  | 388.13 | 358.75
September | 529.37 | 393.75 | 354.38 |  | 370.79 | 340.63
2012/13
October | 488.46 | 343 | 287 |  | 354.49 | 334
November | 465.64 | 376.88 | 269.38 |  | 334.46 | 297.5
December | 459.4 | 345 | 266.67 |  | 349.55 | 335.83
January | 431.39 | 327.5 | 252 |  | 347.22 | 296
February | 440.66 | 279.38 | 237.5 |  | 359.23 | 303.75
March | 437.33 | 301.88 | 231.25 |  | 356.74 | 303.75
April | 422.07 | 314.5 | 222 |  | 340.42 | 309
May1 | 465.72 | 311.88 | 215 |  | 362.51 | 331.88
1 Preliminary.  2 High-protein Decatur, IL.  3 41-percent Memphis.  4 34-percent North Dakota-Minnesota.
5 50-percent Southeast mills.  6 36-percent Pacific Northwest. 7 34-percent Minneapolis.
NA= Not available.
Source: USDA, Agricultural Marketing Service, Monthly Feedstuff Prices.
Last update: | 2013-06-13 11:13:04.490000
Spreadsheet: 685650d1594126382-split-5-parameters-separated-by-and-into-series-of-columns-5-parameter-test
Sheet: Result

Product | 1.1 | 1.2 | 1.3 | 2.1 | 2.2 | 2.3 | 3.1 | 3.2 | 3.3 | 4.1 | 4.2 | 4.3 | 5.1 | 5.2 | 5.3
101 | 0219A | 0219B | 0219C | 1 | 3 | 2 | January | February | March | PC | PC | PM | 4 | 2 | 2
102 | 0220A | 0220B | 0220C | 1 | 3 | 2 | January | February | March | PC | PC | PM | 4 | 2 | 2
103 | 0221A | 0221B | 0221C | 1 | 3 | 2 | January | February | March | PC | PC | PM | 4 | 2 | 2
Spreadsheet: 733598d1621648045-but-i-need-two-parameters-instead-of-one-als-fout-index-i-i-aggregaat-test2
Sheet: vlist (2)

project | Vertrek | Aankomst | begeleider | besteld | weg | wacht | uren | km | land | verkoop | Wacht2 | inkoop | [NAME] | Wacht3 |  | Verschil alles | prijs nl | prijs d | [NAME] <50 | km NL 50-100 | [NAME]500 | [NAME]50 | km d 50-100 | km d 100-500 | km d >500 | Wacht
5120 | darp | oldenzaal | hilco | 20:00:00 | 20:14:00 |  | 4 | 100 | nl |  |  |  |  |  |  |  | 42.5 | 1.15 | 150 | 2.8 | 1.8 | 300 | 4.5 | 1.65 | 1.3 | 45
5120 | darp | oldenzaal | kees | 20:00:00 | 20:00:00 |  | 3.5 | 85 | nl
5120 | oldenzaal | loheide | nl |  |  |  |  | 281 | d
5120 | oldenzal | loheide | nl |  |  |  |  | 279 | d
5135 | loheide | darp | nl |  |  |  |  | 283 | d
5135 | loheide | darp | nl |  |  |  |  | 276 | d
5140 | darp | t Haarde | roland | 11:00:00 | 11:20:00 |  | 3.25 | 56 | nl |  |  |  |  |  |  | [NAME] | als J=nl;I:I | als J=nl; K:K | als J=d;I:I | als J=d:K:K
5141 | oirschot | zoutkamp | roland |  |  |  | 6.75 | 140 | nl |  |  |  |  |  |  | 5120
Spreadsheet: 701865d1603973414-fetch-value-from-a-table-and-consolidate-testing-value
Sheet: Sheet1

 |  | NAME | TYPES |  | DATE
 |  | [NAME] | TYPE A |  | 2020-01-01 00:00:00
 |  | [NAME] | TYPE B |  | 2020-01-02 00:00:00
 |  | [NAME] | TYPE C |  | 2020-01-03 00:00:00
 |  | [NAME] | TYPE A |  | 2020-01-04 00:00:00
 |  | OHUJ | TYPE A |  | 2020-01-05 00:00:00
 |  | OHUJ | TYPE B |  | 2020-01-06 00:00:00
 |  | DESIRED OUTPUT |  |  |  |  |  |  |  | TYPE A | TYPE B | TYPE C
 |  |  | TYPE A |  | TYPE B | TYPE C |  |  | [NAME]
 |  | [NAME] | 2020-01-01 00:00:00 |  | 2020-01-02 00:00:00 | 2020-01-03 00:00:00 |  |  | [NAME]
 |  | [NAME] | 2020-01-04 00:00:00 |  |  |  |  |  | OHUJ
 |  | OHUJ | 2020-01-05 00:00:00 |  | 2020-01-06 00:00:00
Spreadsheet: 743526d1628577411-formula-s-for-choosing-and-calculating-milage-rates-expenses_sheet_main-_jt
Sheet: January

Employee Business Kilometres & Subsistence Expenses Claim |  |  |  |  |  | Period Ended:
Employee Name: |  |  |  |  | Car Reg
 |  |  |  |  | Engine Size
Home Address:
 |  |  |  |  | Start Odometer Reading
 |  |  |  |  | Current Odometer Reading
Mileage |  |  |  |  |  | Subsistence
 |  |  |  |  |  | <10HR | >10HR | O/N
Date | Reason for Journey |  | To | From | Total | 15.41 | 36.97 | 147
 |  |  |  |  | 100
 |  |  |  |  | 200
 |  |  |  |  | 300
 |  |  |  |  | 300
 |  |  |  |  | 400
 |  |  |  |  | 100
 |  | This Month | Last Month | Annual to date
Total Business Kilometres |  |  | 0 |  | Total
Rate Applicable
Value of Mileage Claim (KM x rate) |  |  |  |  | Total Claim (mileage & subsistence)
Rates per Kilometre are determined by Engine Size
 |  | Distance (KM) | Under 1200cc | 1201 to 1500cc | 1501 and over
 |  | 0 - 1500 | 0.3795 | 0.3986 | 0.4479
 |  | 1501 - 5500 | 0.7 | 0.7321 | 0.8353
 |  | 5501 - 25000 | 0.2755 | 0.2903 | 0.3221
 |  | *Rates change after completing 1500/5500 business kilometres
Signed |  |  |  |  | Date
Approved by |  |  |  |  | Date
Return this form within seven days of month end to accounts department
Spreadsheet: 119217d1314275205-aligning-rows-in-order-to-consolidate-myexcelheadache
Sheet: Sheet1

Datawarehouse |  | New data |  |  | My solution >ctrl++>Shift cells down
Account # | Turnover | Account # | Turnover |  | Account # | Turnover
100110 | X | 100110 | X |  | 100110 | X
100140 | X | 100140 | X |  | 100140 | X
100181 | X | 100183 | X
100182 | X | 100184 | X
100183 | X | 100188 | X |  | 100183 | X
100184 | X | 100189 | X |  | 100184 | X
100188 | X | 100190 | X |  | 100188 | X
100189 | X | 100250 | X |  | 100189 | X
100190 | X | 100251 | X |  | 100190 | X
100200 | X | 100252 | X
100250 | X | 100255 | X |  | 100250 | X
100251 | X | 100400 | X |  | 100251 | X
100252 | X | 100402 | X |  | 100252 | X
100253 | X | 100403 | X
100255 | X | 100450 | X |  | 100255 | X
100400 | X | 100850 | X |  | 100400 | X
100401 | X | 100990 | X
100402 | X |  |  |  | 100402 | X
100403 | X |  |  |  | 100403 | X
100410 | X
100450 | X |  |  |  | 100450 | X
100750 | X
100850 | X |  |  |  | 100850 | X
100990 | X |  |  |  | 100990 | X
Spreadsheet: 6f8c0665-f41c-4656-8ac5-8a9ff82ad21e
Sheet: Instructions en

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | English
1
2
3
1
2
3
4
5
6
 |  | 1
 |  |  |  |  |  | N # | % |  |  |  |  | N # | % | N # | % | N # | %
 |  |  |  |  |  | D # |  |  |  |  |  | D # |  | D # |  | D #
Spreadsheet: 8b348cf1-da57-4077-bbe3-f69b0e831f38
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
08/30/2014 | Football | vs. Alabama (Chick-fil-A Kickoff Game) | 03:30 PM | L, 23-33
09/06/2014 | Football | Towson | 07:30 PM | W, 54-0
09/13/2014 | Football | at Maryland | 12:00 PM | W, 40-37
09/20/2014 | Football | Oklahoma* | 07:30 PM | L, 33-45
10/04/2014 | Football | Kansas* | 04:00 PM | W, 33-14
10/11/2014 | Football | at Texas Tech* | 12:00 PM | W, 37-34
10/18/2014 | Football | Baylor* | 12:00 PM | W, 41-27
10/25/2014 | Football | at Oklahoma State* | 03:30 PM | W, 34-10
11/01/2014 | Football | TCU* | 03:30 PM | 3:30 PM
11/08/2014 | Football | at Texas* | 12:00 AM | TBA
11/20/2014 | Football | Kansas State* | 07:00 PM | 7 PM
11/29/2014 | Football | at Iowa State* | 12:00 AM | TBA
Spreadsheet: 0e0863c5-1026-41a3-b1ad-12586d5fe90a
Sheet: Region Data

Idaho Department of Health and Welfare Division of Behavioral Health
Mental Health Public Dashboard for November, 2014
* means on report is that count is less then 5, for details please contact  Idaho Department of Health and Welfare Central Office.
Report Run Date: 12/15/2014
 |  | Mental Health Dashboard |  | Region 1 | Region 2 | Region 3 | Region 4 | Region 5 | Region 6 | Region 7 | State Wide
Admission / Discharge | Monthly | Adult Mental Health | AMH Admission | 17 | 10 | 18 | 19 | 9 | 7 | 22 | 102
 |  |  | AMH Discharge | 13 | 6 | 8 | 20 | * | 11 | 24 | 85
 |  | Children Mental Health | CMH Admission | 6 | 5 | 6 | 6 | 5 | 6 | 17 | 51
 |  |  | CMH Discharge | * | 6 | 5 | 11 | 7 | * | 17 | 54
 | SFY 2015 | Adult Mental Health | AMH Admission | 76 | 40 | 98 | 145 | 50 | 49 | 86 | 544
 |  |  | AMH Discharge | 85 | 50 | 98 | 144 | 55 | 60 | 150 | 642
 |  | Children Mental Health | CMH Admission | 42 | 32 | 33 | 61 | 59 | 27 | 64 | 318
 |  |  | CMH Discharge | 35 | 41 | 40 | 78 | 41 | 33 | 73 | 341
Adult Mental Health | Number of adult served this Month |  |  | 349 | 180 | 534 | 650 | 199 | 222 | 481 | 2615
 | Number of adults served SFY 2015 |  |  | 782 | 360 | 1361 | 1901 | 550 | 494 | 956 | 6404
Children's Mental Health | Number of children served this Month |  |  | 65 | 53 | 68 | 118 | 91 | 53 | 141 | 589
 | Number of children served SFY 2015 |  |  | 114 | 89 | 127 | 235 | 167 | 93 | 274 | 1099
Pre-Sentence Investigation Reports  (I.C. 19-2524) | Monthly |  |  | 23 | 8 | 50 | 85 | 46 | 20 | 28 | 260
 | SFY 2015 |  |  | 220 | 68 | 345 | 464 | 225 | 135 | 202 | 1659
Spreadsheet: 33688d1230254059-pivot-table-question-agents
Sheet: Pivot Table

Shift (Hours) | 8
Agent | Date | Count of Skill Set | Average
[NAME] |  | 13 | 13
 | 2008-11-03 00:00:00 | 3 | 3
 | 2008-11-05 00:00:00 | 2 | 2
 | 2008-11-06 00:00:00 | 8 | 8
[NAME] |  | 28 | 28
 | 2008-11-01 00:00:00 | 25 | 25
 | 2008-11-02 00:00:00 | 3 | 3
Grand Total |  | 41 | 41
Spreadsheet: 716275d1612141461-metric-to-determine-the-amount-of-quantity-for-a-certain-amount-of-allocated-funds-alloc-funds
Sheet: Answer

 | Unit Price | Quantity | Cost | Total Funds
 | 3.5e-05 | 29136344000 | 84981 | 84981
 | 3.5e-05 | 9440230000 | 27534 | 27534
 | 3.5e-05 | 164322515000 | 479274 | 479274
 | 3.5e-05 | 56117142000 | 163675 | 163675
 | 3.5e-05 | 14443542000 | 42127 | 42127
 | 3.5e-05 | 1399887000 | 4083 | 4083
 | 3.5e-05 | 14661942000 | 42764 | 42764
Spreadsheet: 0a8f217e-d19b-4442-8127-43c1cb11625f
Sheet: Mod 37 Increases

Part Number Change Spreadsheet
NEW Manufacture Price List Reference:
OLD Manufacture Price List Reference:
SIN | OLD GSA ITEM NUMBER | OLD [NAME] |  | [NAME] ITEM NUMBER | NEW ITEM DESCRIPTION | LIST CHANGES | OLD LIST PRICE | NEW LIST PRICE | % change in LIST PRICE | GSA % DISCOUNT | NEW GSA PRICE | NEW GSA PRICE WITH IFF
627-13 | P1234 | 25Hz  Load test [NAME] with case |  | XP1234 | 25Hz  Load test Cable Analyzer | No Case for Transport | 6995 | 6910 |  | 0.45