tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 771128d1646428987-summing-values-based-on-week-sum-by-week
Sheet: Sheet1

 |  | Weeks are from Friday to Thursday!
 |  | Odd weeks are green (color is for illustration purposes only!)
 |  | Even weeks are orange (color is for illustration purposes only)
 |  | Some days can be missing! |  |  |  |  |  |  |  |  |  |  | Desired result:
 |  | Date | Value |  | Date | Value |  | Date | Value |  |  |  | Week of | Total |  | Week of | Total |  | Week of | Total
 |  | 2022-03-01 00:00:00 | 29 |  | 2022-04-01 00:00:00 | 11 |  | 2022-05-01 00:00:00 | 16 |  |  |  | 2022-03-04 00:00:00 |  |  | 2022-04-01 00:00:00 |  |  | 2022-05-06 00:00:00
 |  | 2022-03-02 00:00:00 | 29 |  | 2022-04-03 00:00:00 | 27 |  | 2022-05-02 00:00:00 | 27 |  |  |  | 2022-03-11 00:00:00 |  |  | 2022-04-08 00:00:00 |  |  | 2022-05-13 00:00:00
 |  | 2022-03-03 00:00:00 | 20 |  | 2022-04-04 00:00:00 | 10 |  | 2022-05-03 00:00:00 | 10 |  |  |  | 2022-03-18 00:00:00 |  |  | 2022-04-15 00:00:00 |  |  | 2022-05-20 00:00:00
 |  | 2022-03-04 00:00:00 | 24 |  | 2022-04-05 00:00:00 | 4 |  | 2022-05-04 00:00:00 | 11 |  |  |  | 2022-03-25 00:00:00 |  |  | 2022-04-22 00:00:00 |  |  | 2022-05-27 00:00:00
 |  | 2022-03-05 00:00:00 | 19 |  | 2022-04-06 00:00:00 | 26 |  | 2022-05-07 00:00:00 | 18 |  |  |  |  |  |  | 2022-04-29 00:00:00
 |  | 2022-03-06 00:00:00 | 19 |  | 2022-04-07 00:00:00 | 25 |  | 2022-05-08 00:00:00 | 10
 |  | 2022-03-08 00:00:00 | 4 |  | 2022-04-08 00:00:00 | 20 |  | 2022-05-09 00:00:00 | 24
 |  | 2022-03-09 00:00:00 | 23 |  | 2022-04-09 00:00:00 | 15 |  | 2022-05-10 00:00:00 | 20
 |  | 2022-03-10 00:00:00 | 25 |  | 2022-04-11 00:00:00 | 4 |  | 2022-05-11 00:00:00 | 13
 |  | 2022-03-11 00:00:00 | 19 |  | 2022-04-12 00:00:00 | 20 |  | 2022-05-13 00:00:00 | 14
 |  | 2022-03-12 00:00:00 | 24 |  | 2022-04-13 00:00:00 | 24 |  | 2022-05-14 00:00:00 | 24
 |  | 2022-03-15 00:00:00 | 25 |  | 2022-04-14 00:00:00 | 27 |  | 2022-05-15 00:00:00 | 28
 |  | 2022-03-16 00:00:00 | 22 |  | 2022-04-15 00:00:00 | 5 |  | 2022-05-17 00:00:00 | 13
 |  | 2022-03-17 00:00:00 | 13 |  | 2022-04-16 00:00:00 | 19 |  | 2022-05-18 00:00:00 | 27
 |  | 2022-03-18 00:00:00 | 20 |  | 2022-04-19 00:00:00 | 13 |  | 2022-05-19 00:00:00 | 13
 |  | 2022-03-19 00:00:00 | 6 |  | 2022-04-20 00:00:00 | 13 |  | 2022-05-20 00:00:00 | 2
 |  | 2022-03-20 00:00:00 | 27 |  | 2022-04-21 00:00:00 | 22 |  | 2022-05-21 00:00:00 | 11
 |  | 2022-03-22 00:00:00 | 3 |  | 2022-04-22 00:00:00 | 25 |  | 2022-05-22 00:00:00 | 15
 |  | 2022-03-23 00:00:00 | 21 |  | 2022-04-23 00:00:00 | 5 |  | 2022-05-25 00:00:00 | 27
 |  | 2022-03-24 00:00:00 | 19 |  | 2022-04-24 00:00:00 | 28 |  | 2022-05-26 00:00:00 | 14
 |  | 2022-03-25 00:00:00 | 28 |  | 2022-04-25 00:00:00 | 27 |  | 2022-05-27 00:00:00 | 21
 |  | 2022-03-26 00:00:00 | 18 |  | 2022-04-27 00:00:00 | 9 |  | 2022-05-28 00:00:00 | 7
 |  | 2022-03-27 00:00:00 | 3 |  | 2022-04-28 00:00:00 | 15 |  | 2022-05-30 00:00:00 | 20
 |  | 2022-03-28 00:00:00 | 9 |  | 2022-04-30 00:00:00 | 1 |  | 2022-05-31 00:00:00 | 12
 |  | 2022-03-30 00:00:00 | 21
 |  | 2022-03-31 00:00:00 | 29
Spreadsheet: 48460d1247670079-excel-2007-commission-calculation-commissionplan
Sheet: Sheet3

 | Quota | 50000
Pct Quota | Comm | Amt | Delta |  | MRR Attainment | Threshhold |  | $ at this level
0 | 0.005 |  |  |  | $1 - $10,000 | 0 | 0.5
 | 0.0075 |  |  |  | $10,001-$20,000 | 10000 | 0.75 | 10000
 | 0.01 |  |  |  | $20,001-$30,000 | 20000 | 1 | 10000
 | 0.0125 |  |  |  | $30,001-$40,000 | 30000 | 1.25
 | 0.015 |  |  |  | $40,001-$50,000 | 40000 | 1.5
 | 0.02 |  |  |  | $50,000+ | 50000 | 2
 |  |  |  |  |  |  |  |  |  |  | Commission due on 30k deal
Deal | Sales | Cum Sales | Comm
Deal 1 | 7680
Deal 2 | 30000
Deal 3 | 0
Deal 4 | 0
Deal 5 | 0
Deal 6 | 0
Deal 7 | 0
Deal 8 | 0
Deal 9 | 0
Deal 10 | 0
Deal 11 | 0
Deal 12 | 0
 |  | Total: | 60960
Spreadsheet: 356266d1415042649-retain-current-cell-value-if-the-next-iteration-returns-false-sample-2
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  | choose
 |  |  |  | Cycle | Plan 1 | Plan 2 | Plan 3 | Plan 4 |  |  | Plan 3
 |  |  |  | 1 | 6 | 6 | 6 | 10
 |  |  |  | 2 | 6 | 6 | 4 | 10
 |  |  |  | 3 | 6 | 6 | 6 | 4
 |  |  |  | 4 | 6 | 6 | 4 | 4
 |  |  |  | 5 | 4 | 6 | 3 | 4
 |  |  |  | 6 | 4 | 6 | 3 | 4
 |  |  |  | 7 | 6 | 6 | 4 | 4
 |  |  |  | 8 | 6 | 6 | 4 | 4
 |  |  |  | 9 | 2 | 4 | 2 | 4
 |  |  |  | 10 | 2 | 4 | 2 | 4
 |  |  |  | 11 | 4 | 6 | 4 | 4
 |  |  |  | 12 | 6 | 8 | 10 | 4
 |  |  |  | 13 | 6 | 8 | 4 | 4
 |  |  | May |  | 0 | 0 | 282.2399999999999 | 0
 |  |  | June |  | 0 | 0 | 305.7599999999999 | 0
 |  |  | July |  | 0 | 0 | 258.7199999999999 | 0 |  |  |  |  | the data in f17 - i25 should remain visible and update on a change in sheet 1 c3 - f12
 |  |  | August |  | 0 | 0 | 235.1999999999999 | 0
 |  |  | September |  | 0 | 0 | 235.1999999999999 | 0
 |  |  | widgets |  | 0 | 0 | 1317.119999999999 | 0
 |  |  | Hours |  | 0 | 0 | 130 | 0
 |  |  | Days |  | 0 | 0 | 122 | 0
 |  |  | May |  | FALSE | FALSE | 282.2399999999999 | FALSE
 |  |  | June |  | FALSE | FALSE | 305.7599999999999 | FALSE
 |  |  | July |  | FALSE | FALSE | 258.7199999999999 | FALSE
 |  |  | August |  | FALSE | FALSE | 235.1999999999999 | FALSE
 |  |  | September |  | FALSE | FALSE | 235.1999999999999 | FALSE
 |  |  | widgets |  | FALSE | FALSE | 1317.119999999999 | FALSE
 |  |  | Hours |  | FALSE | FALSE | 130 | FALSE
 |  |  | Days |  | FALSE | FALSE | 122 | FALSE
Spreadsheet: 743475d1628529186-calculating-days-hours-min-and-sec-between-two-dates-excluding-weekends-excelhelp
Sheet: Sheet1

 |  |  | Created On | Modified On | Elapsed Time (d.h) | Net Work Day Duration | Start Day | End Day
 |  |  | 2021-08-06 16:35:28 | 2021-08-09 05:17:21 | 2.529085648148148
 |  |  | 2021-08-06 16:32:00 | 2021-08-09 08:34:26 | 2.668356481481482
 |  |  | 2021-08-06 16:05:29 | 2021-08-09 00:34:24 | 2.353414351851852
 |  |  | 2021-08-06 15:35:32 | 2021-08-09 06:53:49 | 2.637696759259259
 |  |  | 2021-08-06 13:14:36 | 2021-08-09 07:04:01 | 2.742650462962963
 |  |  | 2021-08-06 12:59:27 | 2021-08-09 04:27:33 | 2.644513888888889
 |  |  | 2021-08-04 15:17:19 | 2021-08-08 23:36:45 | 4.346828703703704
 |  |  | 2021-07-30 15:47:40 | 2021-08-04 13:55:16 | 4.921944444444445
 |  |  | 2021-07-29 21:37:43 | 2021-08-04 20:19:45 | 5.945856481481481
 |  |  | 2021-07-29 12:38:08 | 2021-08-03 11:29:15 | 4.952164351851851
 |  |  | 2021-07-29 11:53:33 | 2021-08-02 16:18:41 | 4.18412037037037
 |  |  | 2021-07-29 09:31:45 | 2021-08-04 09:48:43 | 6.011782407407408
 |  |  | 2021-07-28 14:16:54 | 2021-08-05 10:41:14 | 7.850231481481481
 |  |  | 2021-07-28 10:11:07 | 2021-08-04 14:21:08 | 7.173622685185185
Spreadsheet: daren_farmer__6540__Jan00_SCADA
Sheet: Sheet1

 | SCADA |  | TARP | Corrected | Hemp CG
 | entex_tot_adjpa | [NAME] |  | SCADA | Adjustment
1999-12-01 00:00:00 | 67.339218 | 34.050907 | 88.572 |  | 0 |  |  | 2000-01-02 00:00:00 |  | 108.1728 | 48.26367
1999-12-02 00:00:00 | 58.478733 | 25.414886 | 75.443 |  | 0 |  |  | 2000-01-03 00:00:00 |  | 87.36319 | 32.39664
1999-12-03 00:00:00 | 53.524139 | 20.586269 | 66.906 |  | 0 |  |  | 2000-01-04 00:00:00 |  | 164.89 | 91.5095
1999-12-04 00:00:00 | 61.274872 | 28.139471 | 82.524 |  | 0 |  |  | 2000-01-05 00:00:00 |  | 290.485 | 187.274
1999-12-05 00:00:00 | 121.305252 | 86.64901 | 178.746 |  | 0 |  |  | 2000-01-06 00:00:00 |  | 228.6749 | 140.1448
1999-12-06 00:00:00 | 171.348511 | 135.423477 | 254.287 |  | 1.18927809 |  |  | 2000-01-07 00:00:00 |  | 147.605 | 78.3301
1999-12-07 00:00:00 | 89.850853 | 55.993107 | 116.306 |  | 23.4076356514 |  |  | 2000-01-08 00:00:00 |  | 127.7573 | 63.22038
1999-12-08 00:00:00 | 63.911949 | 30.708639 | 81.401 |  | 3.7726543855 |  |  | 2000-01-09 00:00:00 |  | 114.364 | 52.98437
1999-12-09 00:00:00 | 102.137764 | 66.703209 | 135.536 |  | 1.7376674315 |  |  | 2000-01-10 00:00:00 |  | 115.3001 | 53.69811
1999-12-10 00:00:00 | 141.047729 | 73.234955 | 140.965 |  | 0
1999-12-11 00:00:00 | 100.086 | 42.09756 | 94.153 |  | 0
1999-12-12 00:00:00 | 113.015 | 51.9556 | 116.077 |  | 0
1999-12-13 00:00:00 | 195.1313 | 114.5683 | 221.273 |  | 0
1999-12-14 00:00:00 | 148.827 | 79.26188 | 175.794 |  | 7.118490078700001
1999-12-15 00:00:00 | 243.5752 | 151.5061 | 303.062 |  | 14.0638741243
1999-12-16 00:00:00 | 193.765 | 113.526 | 246.153 |  | 34.925133243
1999-12-17 00:00:00 | 116.339 | 54.49028 | 144.611 |  | 22.0346801675
1999-12-18 00:00:00 | 153.8925 | 83.12424 | 192.925 |  | 11.3417487183
1999-12-19 00:00:00 | 111.4194 | 50.73915 | 136.851 |  | 12.857417573
1999-12-20 00:00:00 | 217.5515 | 131.6633 | 262.787 |  | 5.0927530654
1999-12-21 00:00:00 | 267.019 | 169.382 | 344.422 |  | 3.9589746196
1999-12-22 00:00:00 | 287.2307 | 184.7927 | 355.791 |  | 29.7808447937
1999-12-23 00:00:00 | 254.4505 | 159.7983 | 321.829 |  | 54.88254101330001
1999-12-24 00:00:00 | 196.8129 | 115.8504 | 244.333 |  | 52.1604156073
1999-12-25 00:00:00 | 232.5008 | 143.062 | 278.774 |  | 31.8911526934
1999-12-26 00:00:00 | 190.2991 | 110.8838 | 212.109 |  | 25.33162331700001
1999-12-27 00:00:00 | 180.996 | 103.79 | 206.696 |  | 14.0004459595
1999-12-28 00:00:00 | 247.203 | 154.272 | 309.196 |  | 9.5247960808
1999-12-29 00:00:00 | 177.871 | 101.407 | 203.967 |  | 33.00907409800001
1999-12-30 00:00:00 | 138.8738 | 71.67276 | 143.01 |  | 18.0968482695
1999-12-31 00:00:00 | 173.2956 | 97.91891 | 180.761 |  | 5.522214597900001
Month Totals
Month Average
Spreadsheet: 242e468c-a4be-4b21-8b96-395d6261672a
Sheet: Sheet1

ROMEO ET JULIETTE | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
PERFORMANCE CASTING |  |  |  | SUBJECT TO CHANGE
2013-01-21 00:00:00
WEEK ONE
 |  | Fri | Sat Mat | [NAME] | Sun Mat
 |  | 2013-02-01 00:00:00 | 2013-02-02 00:00:00 | 2013-02-02 00:00:00 | 2013-02-03 00:00:00
 |  | 7:30PM | 14:00:00 | 19:30:00 | 13:00:00
Romeo |  | MOORE | MOORE | ORZA | ORZA
[NAME] |  | NAKAMURA | NAKAMURA | KORBES | KORBES
Nurse |  | FOSTER | MULLIN | IMLER | IMLER
[NAME] |  | DEC | DEC | GILBREATH | GILBREATH
Tybalt |  | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] |  | PORRETTA | PORRETTA | THOMSON | THOMSON
[NAME] |  | GRIFFITHS | GRIFFITHS | GRIFFITHS | GRIFFITHS
Paris |  | LIN-YEE | LIN-YEE | GRANT | GRANT
Rosaline |  | [NAME] | [NAME] | RAUSCH | RAUSCH
Friar Laurence |  | CRUZ | CRUZ | CRUZ | CRUZ
Acolytes
1 |  | [NAME] | [NAME] | [NAME] | [NAME]
2 |  | BARTEE | BARTEE | BARTEE | BARTEE
Montagues
1 |  | THOMSON | THOMSON | BARTEE/SUDDARTH | BARTEE/SUDDARTH
2 |  | ROLLOFSON | ROLLOFSON | ROLLOFSON | ROLLOFSON
3 |  | DAVIS | DAVIS | DAVIS | DAVIS
4 |  | SUDDARTH | SUDDARTH | SUDDARTH | SUDDARTH
1 |  | LOVE | LOVE | MURPHY | MURPHY
2 |  | O'CONNOR | O'CONNOR | MULLIN | MULLIN
3 |  | ANSPACH | ANSPACH | NELSON | NELSON
4 |  | CLARK | CLARK | SAMUELSON | SAMUELSON
5 |  | NEUVILLE | NEUVILLE | NEUVILLE | NEUVILLE
Capulets
1 |  | HIPOLITO | HIPOLITO | LIN-YEE | LIN-YEE
2 |  | GAINES | GAINES | GAINES | GAINES
3 |  | LOCH | LOCH | HIPOLITO | HIPOLITO
4 |  | CARDEA | CARDEA | CARDEA | CARDEA
1 |  | MACY | MACY | MACY | MACY
2 |  | [NAME] | [NAME] | PASCH | PASCH
3 |  | GENEROSA | GENEROSA | GENEROSA | GENEROSA
4 |  | BIASUCCI | BIASUCCI | [NAME] | [NAME]
Spreadsheet: 803964d1667825991-extracting-data-from-excel-tables-sales-control
Sheet: Bank 3

 | Bank 3
 | Date | Nane | I.D Number | Transaction description2 | Invoice | Reference | Debit | Credits | Balance
 | 2022-11-01 00:00:00 |  |  | Opening Balance |  |  |  |  | 130
 | 2022-11-05 00:00:00 | Bigboy | A003 | Sales |  | 37 | 4000
 | 2022-11-07 00:00:00 | Abi | A002 | Sales |  | 40 | 1000
 | 2022-11-07 00:00:00 | Bern | A005 | Purchase |  | 100 |  | 300
 | 2022-11-08 00:00:00 | [NAME] | A006 | Purchase |  | 101 |  | 1000
 | 2022-11-09 00:00:00 | ADAM | A008 | Rent |  | 102 |  | 500
 | 2022-11-09 00:00:00 | [NAME] | A006 | Purchase |  | 103 |  | 300
 | 2022-11-10 00:00:00 | [NAME] | A006 | Purchase |  | 101 |  | 1000
Spreadsheet: 178122d1346668460-putting-data-in-other-worksheets-corbinsbere-gundogs-competition
Sheet: Spaniel Novice

ENTRANTS NUMBER | HANDLERS NAME | DOGS NAME | TEST 1 | TEST 2 | TEST 3 | SCORE | POSITION
 |  |  |  |  |  | 0 | 3
2 | [NAME] | [NAME] | 14 | 11 | 16 | 41 | 2
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
7 | [NAME] | [NAME] | 14 | 12 | 16 | 42 | 1
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
 |  |  |  |  |  | 0 | 3
Spreadsheet: 839988d1692346871-assorting-text-into-a-vertical-string-sample-4-2-
Sheet: Sheet1

 | Room numbers
 | WF328 WF214 TF268 TF254 WF325 TF305 WG203 TF322 TF250 TF213 WF222 WS312 WS134 TG270 TG128 TF330 TF301 WF209 WS316 TF336 WS213 WS215 WS206 TF208 |  | TF213 | TF250 | TF254 | TF268 | TF301 | TF305 | TF322 | TF330 | TF336 | TG128 | TG270 | WF209 | WF214 | WF222 | WF325 | WF328 | WG203 | WS134 | WS206 | WS213 | WS215 | [NAME] | WS316
 | WF328 WF214 TF268 TF254 WF325 TF305 WG203 TF322 TF250 TF213 WF222 WS312 WS134 TG270 TG128 TF330 TF301 WF209 WS316 TF336 WS213 WS215 WS206 TF208 | TF208 | TF213 | TF250 | TF254 | TF268 | TF301 | TF305 | TF322 | TF330 | TF336 | TG128 | TG270 | WF209 | WF214 | WF222 | WF325 | WF328 | WG203 | WS134 | WS206 | WS213 | WS215 | [NAME] | WS316
 | WF328 WF214 TF268 TF254 WF325 TF305 WG203 TF322 TF250 TF213 WF222 WS312 WS134 TG270 TG128 TF330 TF301 WF209 WS316 TF336 WS213 WS215 WS206 TF208 | TF208 | TF213 | TF250 | TF254 | TF268 | TF301 | TF305 | TF322 | TF330 | TF336 | TG128 | TG270 | WF209 | WF214 | WF222 | WF325 | WF328 | WG203 | WS134 | WS206 | WS213 | WS215 | [NAME] | WS316
Spreadsheet: 12974036-302a-4a16-8ee2-1a4c564d19d4
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  | TRAVEL ADVANCE REQUEST
 |  | Financial and Administrative Services
 | Employee Name: |  |  |  | Delivery Method                         (select from menu): |  |  |  | Date Required:          (dd/mm/yy)
 | [NAME] (if different than requestor):
 | Department: |  |  |  | Dept:
 | Address: |  |  |  | Call: |  |  | Ext:
 |  |  |  |  | Cheque Payable In                      (select from menu): |  |  |  | Advance Request Forms must be filled out electronically
 | Postal Code:
 |  |  |  |  | one currecy per request
 | Advance Amount Required (111-006-018): |  |  |  |  |  |  | Date of Travel:
 | Advances processed for amounts between $1,000 and $5,000 only |  |  |  |  |  |  |  | (dd/mm/yy)
 | Purpose of Advance (including nature and estimate of expenditures to be incurred)
 | Attach supporting documentation to form (i.e. conference brochure/itinerary)
 | Expenses will be ultimately charged to: | Account (xxx-xxx-xxx) | Department (if different than above)
 | ACKNOWLEDGEMENT
 | I acknowledge that I am aware of the Travel Advance sections (19 - 28) of the Travel and Related Expense Policy.  I accept the criteria listed below (please check off each criteria):
 |  | I am permanent employee of the University
 |  | I personally cannot cover the cost of the travel ahead of time
 |  | Advances older than 90 days from the date of travel will be deducted from all future reimbursement requests until the advance is cleared
 |  | Advances older than 120 days from the date of travel will be payroll deducted from my future payroll payments.
 | I acknowledge that this approved advance does not imply approval of actual travel expenses which must be submitted on a Employee Expense Reimbursement Form within 90 days of the date of travel.
 | I certify that the funds received in this advance will be used for expenses related to university business.
 | All advances for travel prior to April 30th must be cleared by the first Friday of May to be included in the correct fiscal year.
 | PAYEE (if different from requestor)
 | Name |  |  | Signature
 | EMPLOYEE REQUESTOR
 | Name |  |  | Title
 | Signature |  |  | Date (dd/mm/yy)
 | AUTHORIZED [NAME]
 | Name |  |  | Title
 | Signature |  |  | Date (dd/mm/yy)
 | CONTROLLER AND MANAGER OF FINANCE APPROVAL
 | Signature |  |  | Date (dd/mm/yy)
 | Finance Use Only | Verified by: |  |  |  | Date:
 | Verson - November 2013
 | Canadian
 | US
 | Mail to Address Shown
 | Wire Payment
Spreadsheet: 752009d1634512938-determine-rating-a-f-based-on-percentage-reduction-final-assignement
Sheet: Sheet1

 | SAFETY PERFORMANCE MEASURE CRITERIA
 |  |  |  |  | SPM GRADE SIMPLIFIED
 |  |  |  |  | A | B | C | D | E | F
 |  |  |  |  | 10% REDUCTION | 8% REDUCTION | 6% REDUCTION | 4% REDUCTION | 2% REDUCTION | NO REDUCTION
 | YEAR ASSESSED | 2013 | 2014 | 2015
 | SPM
 | OVERALL SPM RANK | BASELINE YEAR NOT CALCULATED
 | DATA COLLECTION CRITERIA
 | TOTAL LOST DAYS
 | ILLNESS | N/A
 | MA | 1144
 | STD | 1344
 | LTD | 806
 | FATALITIES | 0
 | TOTAL CLAIMS | 89
 | ILLNESS | N/A
 | MEDICAL AID | 44
 | STD | 32
 | LTD | 13
 | FATALITIES | 0
 | EMPLOYEE ENGAGEMENTS
 | TRAINING OPPORTUNITIES | 7
 | COMPLETED TRAINING | 403
 | OHS PARTIPCATION | 189
 | INJURY TYPES | NOT DEFINED
 | FALLS | 48
 | OVEREXERTION | 15
 | SPRAINS/STRAINS | 19
 | STRUCK AGAINST | 5
 | STRUCK BY | 1
 | MOTOR VEHICLE | 1
 | OTHER | 0
Spreadsheet: 292630d1390699436-automated-posting-from-journals-to-ledgeraccounts-accounts
Sheet: BalSheet

Balance sheet - 31 December, 2008
Assets
Current assets
National Bank - Cheque |  | -857.9100000000001
Cash on hand
Total current assets |  |  | -857.9100000000001
Non-current assets
Total assets |  |  | -857.9100000000001
Liabilities
Current liabilities
National Bank - Visa |  | 303.36
Provision for car maintenance |  | 15
Total current liabilities |  |  | 318.36
Non-current liabilities
Loan - J Mugot |  |  | 3550
Total liabilities |  |  | 3868.36
Net Assets |  |  | -4726.27
Equity
Retained earnings |  | -5000.53
Net profit |  | 274.26
Total equity |  |  | -4726.27
Spreadsheet: 140729d1328874235-excel-2007-how-to-grab-information-from-other-sheets-and-place-it-in-the-main-sheet-example_tiggi
Sheet: rugby

NAME | SEX | SIZE
test1 | F | L
test2 | F | S
test3 | M | S
test4 | M | M
test5 | F | M
test6 | F | M
[NAME] | F | XXL
test8 | M | L
test9 | M | S
test10 | M | S
test11 | M | M
test12 | M | M
test13 | M | M
test14 | M | XXL
test15 | M | XXL
Spreadsheet: 768330d1644928769-trying-to-look-up-and-filter-data-example
Sheet: K ABV

ABV
Component name | Result text
Spreadsheet: 114438d1310148619-is-there-an-error-in-my-formula-test
Sheet: Sheet1

 | curr | buy | sell | ticker | name | curr | px | Average Cost | g/l | buy | sell
1111111 | 1205.25 |  |  | AAAAA | Test Stock | 11233.23 | 1.11 | 10000 | 1111.1 |  | 1111.11
Spreadsheet: 827313d1682602761-dynamic-table-reference-based-on-todays-date-to-create-a-small-summary-table-dynamic-table-reference-by-date
Sheet: Sheet1

 | Number of Flowers sold by date (past and future orders)
Flowers |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | …
Roses | 2 | 2 | 4 | 2 | 1 | 2 | 1 | 3 | 3 | 5 | 4 | 1 | 2 | 5 | 2 | 1 | 4 | 2 | 4 | …
[NAME] | 14 | 11 | 12 | 13 | 14 | 15 | 14 | 12 | 11 | 11 | 14 | 12 | 4 | 17 | 15 | 12 | 13 | 12 | 11 | …
Orchid | 1 | 2 | 1 | 2 | 1 | 2 | 3 | 1 | 2 | 3 | 2 | 3 | 4 | 1 | 2 | 1 | 2 | 1 | 1 | …
Tulip | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 3 | 1 | 1 | 1 | 1 | 1 | …
[NAME] | 6 | 7 | 5 | 8 | 5 | 4 | 5 | 8 | 9 | 6 | 2 | 4 | 5 | 4 | 7 | 1 | 5 | 7 | 1 | …
Simple 4 day look ahead for flower orders
Flowers
 | How would I create a lookup  to include only the data associated with the dates in the small summary table that dynamically reference a larger data table that goes on indefinately?
Spreadsheet: 842860d1694850004-sum-up-columns-based-on-specific-dates-amoi42-ans
Sheet: Sheet1 (2)

Equipment Code | WO Number | WO Description | WO Priority | WO Status | Odometer | Start Date | Finish date | Total Downtime |  |  | Start Date | Finish Date | Highest Dowtime | WO Description | Expected result
VL1 |  | SAFETY INSPECTION | P3 | Not Shown |  | 2022-04-11 00:00:00 | 2022-04-11 00:00:00 | 0 |  | VL1 | 2022-04-12 00:00:00 | 2022-04-18 00:00:00 |  |  | DOOR REPLACE
VL1 |  | DOOR REPLACE | P3 | Completed | 72294 | 2022-04-12 07:30:00 | 2022-04-12 08:30:00 | 0.9999999999417923 |  |  | 2022-05-09 00:00:00 | 2022-05-23 00:00:00 |  |  | AC REPAIRS
VL1 |  | HEADLIGHT (BULB) REPLACED | P1 | Completed | 72477 | 2022-04-18 07:20:00 | 2022-04-18 07:50:00 | 0.5000000000582077 |  |  | 2023-01-01 00:00:00 | 2023-09-12 00:00:00 |  |  | ACCIDENT DAMAGE
VL1 |  | SAFETY INSPECTION | P3 | Completed | 72790 | 2022-04-26 07:45:00 | 2022-04-26 09:45:00 | 2
VL1 |  | SAFETY INSPECTION | P3 | Completed | 73223 | 2022-05-09 08:01:00 | 2022-05-09 09:01:00 | 1.000000000116415 |  |  |  |  |  | Results in cell O4 and O5 are not correct.
VL1 |  | AC REPAIRS | P3 | Completed | 73641 | 2022-05-23 13:35:29 | 2022-05-23 16:35:54 | 3
VL1 |  | ACCIDENT DAMAGE | P1 | Waiting Parts |  | 2022-06-05 10:00:00 |  | 10708.77714444447 |  |  | [NAME] used | INDEX($C$2:$C$8, MATCH(MAXIFS($I$2:$I$8,$G$2:$G$8,">=" &L2,$H$2:$H$8,"<=" &M2,$A$2:$A$8,$K$2),$I$2:$I$8, 0))
Spreadsheet: c5ec0df5-c536-4c01-97d6-7286302cbb43
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7698 | 5547 | [NAME] | [NAME] | RSA | 14 | 00:22:43 | 00:00:54 | 01:17:44 | 00:00:36 | 00:38:12 | 1 | 02:20:10
7698 | 12804 | [NAME] | Fischer | RSA | 11 | 00:22:53 | 00:00:46 | 01:17:41 | 00:00:33 | 00:39:04 | 2 | 02:20:58
7698 | 30438 | [NAME] | Steyn | RSA | 15 | 00:25:00 | 00:00:54 | 01:19:18 | [NAME] | 00:41:18 | 3 | 02:27:15
7698 | 66857 | [NAME] | Rousseau | ZIM | 12 | 00:30:10 | 00:01:25 | [NAME] | 00:00:52 | 00:51:23 | 4 | 02:50:42
Spreadsheet: eric_saibi__9722__010802
Sheet: Colstrip 04

Owner Name |  | PPL Montana LLC
Station Name |  | Colstrip Power Station
Unit Name |  | Colstrip 04
NERC Region |  | WSCC
State |  | MT
Fuel Type |  | Coal
Capacity |  | 778 MW
Start Date |  | 2002-01-08 00:00:00
End Date |  | 2002-01-10 00:00:00
Comments |  | Tube repairs
SIC |  | 4911
Plant ID |  | 1015370
Unit ID |  | 1007495
Outage ID |  | 19414
Spreadsheet: 07f3c64f-84f3-4a41-af02-aefdbc1029e5
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
6486 | 40036 | Hilary | [NAME] | GBR | 285 | 00:40:58 | 00:01:13 | 01:08:57 | 00:01:10 | 00:19:07 | 1 | 02:11:28
6486 | 7658 | [NAME] | Griffin | IRL | 282 | 00:44:58 | 00:01:32 | 01:09:25 | 00:01:32 | 00:22:13 | 2 | 02:19:42
6486 | 46905 | Geraldine | Le Gear | IRL | 283 | [NAME] | 00:01:58 | 01:15:16 | 00:01:41 | 00:21:54 | 3 | 02:27:12
6486 | 17047 | Christine | [NAME] | GBR | 284 | 00:50:06 | [NAME] | 01:11:29 | 00:01:36 | 00:22:21 | 4 | 02:27:23