tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 155388d1336795665-computing-hours-and-minutes-using-excel-2010-timesheet
Sheet: Sheet1

TIME-IN | OUT | IN | OUT | OUTPUT |  | TIME-IN | OUT | IN | OUT | OUTPUT |  | Let's say the Work Schedule is 8AM-5PM with 12:00PM-1:00PM Lunch, how would I compute for the ff:
08:00:00 | 12:00:00 | 13:00:00 | 17:00:00 | 08:00:00 |  |  |  |  |  |  |  | Came in on time, took lunch on time.
07:55:00 | 12:00:00 | 13:00:00 | 17:00:00 | 08:00:00 |  |  |  |  |  |  |  | Output is Still 8 hours, since coming to work early doesn't add to hours/minutes
08:00:00 | 12:00:00 | 13:00:00 | 16:45:00 | 07:45:00 |  |  |  |  |  |  |  | Undertime
08:00:00 | 11:55:00 | 13:00:00 | 17:00:00 | 07:55:00 |  |  |  |  |  |  |  | Still undertime since it's an early lunch... Same goes for late lunch or both
08:00:00 | 12:00:00 | 14:00:00 | 17:00:00 | 07:00:00 |  |  |  |  |  |  |  | Still undertime since it's a late lunch... Same goes for early lunch or both
 |  | 13:00:00 | 17:00:00 | 04:00:00 |  |  |  |  |  |  |  | Half Day
 |  | 13:30:00 | 17:00:00 | 03:30:00 |  |  |  |  |  |  |  | Less than half day
06:55:00 | 12:00:00 | 13:00:00 | 17:05:00 | 08:00:00 |  |  |  |  |  |  |  | Still 8 hours, Early than 8AM and later than 5PM doesn't count
07:55:00 | 11:55:00 | 13:00:00 | 17:30:00 | 07:55:00 |  |  |  |  |  |  |  | Came to work early, [NAME] work late, but had an early Lunch. Same goes for late lunch
08:01:00 | 12:00:00 | 13:00:00 | 17:30:00 | 07:59:00 |  |  |  |  |  |  |  | Still 8 hours, Early than 8AM and later than 5PM doesn't count
08:00:00 | 11:55:00 | 13:00:00 | 17:30:00 | 08:00:00 |  |  |  |  |  |  |  | Still 8 hours, Early than 8AM and later than 5PM doesn't count
08:05:00 | 11:55:00 | 13:05:00 | 16:55:00 | 07:40:00 |  |  |  |  |  |  |  | Late, Early Lunch, Over [NAME] and Early Out
07:55:00 | 12:00:00 |  |  | 04:00:00 |  |  |  |  |  |  |  | Half Day
08:00:00 | 11:55:00 |  |  | 03:55:00 |  |  |  |  |  |  |  | Less than half day
Spreadsheet: 76850568-aa74-45d8-a427-387ccae8d750
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
10/03/2014 | Men's Swimming & Diving | Gold-Blue Meet | 03:00 PM
10/10/2014 | Men's Swimming & Diving | West Virginia State Games (Huntington, W.Va.)
10/11/2014 | Men's Swimming & Diving | West Virginia State Games (Huntington, W.Va.) | 09:00 AM
10/23/2014 | Men's Swimming & Diving | Penn State | 05:00 PM
10/25/2014 | Men's Swimming & Diving | at Villanova | 01:00 PM
11/20/2014 | Men's Swimming & Diving | Mizzou Invite (Columbia, Mo.)
11/21/2014 | Men's Swimming & Diving | Mizzou Invite (Columbia, Mo.)
11/22/2014 | Men's Swimming & Diving | Mizzou Invite (Columbia, Mo.)
12/04/2014 | Men's Swimming & Diving | U.S. Winter Nationals (Greensboro, N.C.)
12/05/2014 | Men's Swimming & Diving | U.S. Winter Nationals (Greensboro, N.C.)
12/06/2014 | Men's Swimming & Diving | U.S. Winter Nationals (Greensboro, N.C.)
01/03/2015 | Men's Swimming & Diving | Orange Bowl Classic (Key Largo, Fla.)
01/10/2015 | Men's Swimming & Diving | at Pitt | 12:00 PM
01/16/2015 | Men's Swimming & Diving | TCU | 06:00 PM
01/30/2015 | Men's Swimming & Diving | at Ohio State | 05:00 PM
02/25/2015 | Men's Swimming & Diving | Big 12 Championships (Austin, Texas)
02/26/2015 | Men's Swimming & Diving | Big 12 Championships (Austin, Texas)
02/27/2015 | Men's Swimming & Diving | Big 12 Championships (Austin, Texas)
02/28/2015 | Men's Swimming & Diving | Big 12 Championships (Austin, Texas)
03/12/2015 | Men's Swimming & Diving | NCAA Zone A Diving Championships (Piscataway, N.J.)
03/13/2015 | Men's Swimming & Diving | NCAA Zone A Diving Championships (Piscataway, N.J.)
03/14/2015 | Men's Swimming & Diving | NCAA Zone A Diving Championships (Piscataway, N.J.)
03/26/2015 | Men's Swimming & Diving | [NAME] (Iowa City, Iowa)
03/27/2015 | Men's Swimming & Diving | [NAME] (Iowa City, Iowa)
03/28/2015 | Men's Swimming & Diving | [NAME] (Iowa City, Iowa)
Spreadsheet: 144396d1330966081-major-countif-function-crisis-copy-w-house-ss
Sheet: Group Tally

 | Group 1 | Group 2 | Group 3 | Total |  | Group 1 | Group 2 | Group 3
[NAME] |  |  |  | 0 |  | Pick | Pallet Despatch | Goods In
[NAME] |  |  |  | 0 |  | Sort | Pack | Consign
Calum Raisey |  |  |  | 0 |  | Putaway | BDO | Returns
[NAME] |  |  |  | 0 |  | Replen
[NAME] |  |  |  | 0
[NAME] |  |  |  | 0
[NAME] |  |  |  | 0
[NAME] |  |  |  | 0 |  | Count the number of occurances of [NAME] tasks in table range B5:F5 with the [NAME] tasks listed in table range G2:G5
[NAME] |  |  |  | 0
[NAME] |  |  |  | 0
[NAME] |  |  |  | 0
[NAME] |  |  |  | 0
TEMP |  |  |  | 0
TEMP |  |  |  | 0
TEMP |  |  |  | 0
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 706965d1606983071-textjoin-product-names-which-falls-in-the-same-category-textjoin-on-category
Sheet: Sheet1

name 1 | category1 |  | category1
name 2 | category1 |  | category 2
name 3 | category 2
name 4 | category 2
name 5 | category 2
ID | Type | Attribute | Attribute value | Parent
H3515112V | variable | Color | Red, Black
H3515112 | variation | Color | Red | H3515112V
H3515111 | variation | Color | Black | H3515112V
H3525224V | variable | Color | White, Blue
H3525224 | variation | Color | White | H3525224V
H3525225 | variation | Color | Blue | H3525224V
I2500197V | variable | Color | Green, Blue, Pink, Red
I2500197 | variation | Color | Green | I2500197V
I2500198 | variation | Color | Blue | I2500197V
[NAME] | variation | Color | Pink | I2500197V
I2500199 | variation | Color | Red | I2500197V
H3515175V | variable | Color | Red, Blue, Black
H3515175 | variation | Color | Red | H3515175V
H3515174 | variation | Color | Blue | H3515175V
H3515173 | variation | Color | Black | H3515175V
Spreadsheet: 872627d1718987732-returning-partial-match-when-comparing-two-columns-of-project-names-text-phrases-20240621_excel-forum-ask
Sheet: Excel Forum

Project Name List 1 | Project Name List 2 |  | Words to ideally exclude from partial match test.
Air Liquide CurtHyl Hydrogen Production Electrolysis Project Phase I | Air Liquide SA Hyper1 green Hydrogen project |  | hydrogen
Air Liquide ELYgator Hydrogen Production Electrolysis PEM Project | Air Liquide SA [NAME] Green Hydrogen Project |  | green
Air Liquide Trailblazer Hydrogen Production Electrolysis Project Phase I | Siemens Energy AG,Air Liquide SA |  | hub
Cemex Concrete Chemicals Hydrogen Production Electrolysis Project Phase I | Enertrag AG,[NAME] |  | project
E.ON H2.Ruhr Hydrogen Production Electrolysis Project | SAP AG,E.ON SE,[NAME],Iberdrola SA,ABB Ltd
E.ON SmartQuart Hydrogen Production Electrolysis Project | [NAME],OFB Projektentwicklung GmbH,[NAME],Viessmann Group,Hydrogenious LOHC Technologies GmbH,Cisco Systems Holding GmbH,RWE Power AG,Siemens AG
East Energy Finsterwalde Hydrogen Production Electrolysis Project | East Energy GmbH,Stadtwerke Finsterwalde GmbH
[NAME] | [NAME],VNG Gasspeicher GmbH
Enertag RefLau Hydrogen Production Stadtwerke Electrolysis Project Phase I | [NAME],Enertrag AG,[NAME]
Equinor GreenHyScale Hydrogen Production Electrolysis Project Phase I | Equinor ASA
European Energy Kasso Hydrogen Production Electrolysis Project | Green Hydrogen Example Project Proect Phase 1
Spreadsheet: 00d9c308-757c-4b3b-96b2-422a09123dad
Sheet: Grade 8 Reading

2013 Minnesota Test of Academic Skills (MTAS)
2013 MTAS Grade 8
Grade 8 Reading [NAME]
Raw Score | Scale Score**** | Level
0 | 100 | D
1 | 116 | D
2 | 126 | D
3 | 133 | D
4 | 139 | D
5 | 144 | D
6 | 150 | D
7 | 155 | D
8 | 162 | D
9 | 168 | D
10 | 174 | D
11 | 178 | D
12 | 181 | D
13 | 184 | D
14 | 186 | D
15 | 188 | D
16 | 190 | P
17 | 192 | P
18 | 194 | P
19 | 196 | P
20 | 198 | P
21 | 200 | M
22 | 202 | M
23 | 205 | M
24 | 209 | M
25 | 213 | M
26 | 221 | E
27 | 235 | E
Notes:
*2007 and 2008/2009/2010/2011  MTAS scale metrics are not comparable
**2011/2012 and 2008/2009/2010  Grades 3-8 Mathematics MTAS scale metrics are not comparable
***2012 and 2008/2009/2010/2011 Science MTAS metrics are not comparable
****2013 and 2008/2009/2010/2011/2012  Reading MTAS scale metrics are not comparable
End of Worksheet
Spreadsheet: 739029d1625470809-vlookup-with-a-row-from-another-sheet-eh_vlookup-db-1-
Sheet: Sheet1

Flavour
Country of Origin
Meat Fish Poultry Sector and Sub Type
Prism Sub Market
Prism Type
Pack Type
Ambient Chilled frozen
Protein
Spreadsheet: 44363d1242950226-sorting-and-formula-question-test-m
Sheet: Sheet1

0.4 |  | If there are 24 consecutive values of equal to 0.1 or less, in Column A, copy the greatest value which occurs untill 24 consecutive values of 0.1 or less occur again, to [NAME]
0.9
0.4
0.2
0.4
2.2
2.7
2.5
4.4
0.4
0.4
14.2
44.3
19.4
8.1
0.8
0.9
13.5
0.4
1.5
0.4
0.4
0.3
0.2
0.3
0.2
0.3
0.2
0.3
0.1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0.2
0.3
0.2
0.3
0.3
0.2
0.3
0.2
0.3
0.2
0.3
0.2
1
0.4
0.4
0.3
0.2
0.3
0.2
0.3
0.2
0.3
0.2
0.3
0.2
0.3
0.2
0.3
0.2
0.3
0.2
0.3
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0.4
2.2
2.7
2.5
4.4
0.4
0.4
14.2
44.3
19.4
8.1
0.8
0.9
13.5
0.4
1.5
0.4
0.4
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0.2
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0.2
0.3
0.2
0.3
0.2
0.3
0.2
1
0.4
0.4
0.3
0.2
0.3
Spreadsheet: 83456d1283432902-excel-2007-pivot-table-column-display-organization-issues-pivottablecolumns
Sheet: Source Data

Order No | Branch | Original Order No | Original Branch | Original Backorder Branch | Best Branch | Original Branch Different | Original Backorder Branch Different | Brest Branch Different
10000001 | 1 | 1 | 3 | 2 | 2
10000002 | 4 | 2 | 2 | 2 | 3
10000003 | 3 | 3 | 2 | 2 | 4
10000004 | 1 | 4 | 3 | 1 | 2
10000005 | 2 | 5 | 4 | 2 | 2
10000006 | 4 | 6 | 2 | 1 | 1
10000007 | 1 | 7 | 2 | 1 | 1
10000008 | 4 | 8 | 2 | 2 | 1
10000009 | 3 | 9 | 3 | 3 | 1
10000010 | 4 | 10 | 3 | 1 | 4
10000011 | 2 | 11 | 3 | 1 | 2
10000012 | 4 | 12 | 3 | 1 | 4
10000013 | 1 | 13 | 4 | 3 | 1
10000014 | 1 | 14 | 1 | 4 | 4
10000015 | 4 | 15 | 4 | 2 | 4
10000016 | 3 | 16 | 2 | 3 | 3
10000017 | 1 | 17 | 3 | 2 | 1
10000018 | 3 | 18 | 2 | 3 | 4
10000019 | 3 | 19 | 1 | 3 | 1
10000020 | 1 | 20 | 2 | 3 | 4
Spreadsheet: 57334d1257438454-creating-conditional-drop-down-boxes-and-then-searching-for-selections-example
Sheet: Wide CHP

 |  | Base |  | NEMA | Base RPM | [NAME] |  | w/50% Brake | w/100% Brake | w/140% Brake
 | HP | RPM | Encl. | Frame | AMPS @ 460 | RPM | with ENCODER | and encoder | and encoder | and encoder
 | 5 | 500 | TENV | 256T | 13.5 | 2000 | xx | xx | xx | xx
 | 7.5 | 500 | TENV | 284T | 19.2 | 2000 | xx | xx | xx | xx
 | 10 | 500 | TENV | 326T | 24 | 2000 | xx | xx | xx | xx
 | 15 | 850 | TENV | 364T | 28 | 2750 | xx | xx | xx | xx
 |  | 650 | TENV | 365T | 34.5 | 2600 | xx | xx | xx | xx
 |  | 500 | TENV | 365T | 41.5 | 2000 | xx | xx | xx | xx
 | 20 | 850 | TENV | 365T | 37.5 | 2750 | xx | xx | xx | xx
 |  | 650 | TENV | 367T | 43.5 | 2600 | xx | xx | xx | xx
 |  | 500 | TENV | 367T | 47.5 | 2000 | xx | xx | xx | xx
 |  | 850 | TENV | 367T | 45.5 | 2750 | xx | xx | xx | xx
 | 25 | 650 | TEBC | 404T | 49.5 | 2600 | xx | xx | xx | xx
 |  | 500 | TEBC | 404T | 54 | 2000 | xx | xx | xx | xx
 |  | 850 | TENV | 405T | 51.5 | 2750 | xx | xx | xx | xx
 | 30 | 650 | TEBC | 405T | 58 | 2600 | xx | xx | xx | xx
 |  | 500 | TEBC | 444T | 63 | 2000 | xx | xx | xx | xx
 |  | 850 | TEBC | 444T | 68.5 | 2750 | xx | xx | xx | xx
 | 40 | 650 | TEBC | 444T | 80 | 2600 | xx | xx | xx | xx
 |  | 500 | TEBC | 444T | 85 | 2000 | xx | xx | xx | xx
 |  | 850 | TEBC | 444T | 84.5 | 2750 | xx | xx | xx | xx
 | 50 | 650 | TEBC | 444T | 99 | 2600 | xx | xx | xx | xx
 |  | 500 | TEBC | 444T | 105 | 2000 | xx | xx | xx | xx
 |  | 850 | TEBC | 444T | 100 | 2750 | xx | xx | xx | xx
 | 60 | 650 | TEBC | 445T | 115 | 2600 | xx | xx | xx | xx
 |  | 500 | TEBC | 445T | 125 | 2000 | xx | xx | xx | xx
 |  | 850 | TEBC | 445T | 125 | 2750 | xx | xx | xx | xx
 | 75 | 650 | TEBC | 445T | 144 | 2600 | xx | xx | xx | xx
 |  | 500 | TEBC | 445T | 155 | 2000 | xx | xx | xx | xx
 |  | 850 | TEBC | 449T | 165 | 2750 | xx | xx | xx | xx
 | 100 | 650 | TEBC | 449T | 186 | 2600 | xx | xx | xx | xx
 |  | 500 | TEBC | 449T | 202 | 2000 | xx | xx | xx | xx
 |  | 850 | TEBC | 449T | 205 | 2750 | xx | xx | xx | xx
 | 125 | 650 | TEBC | 449T | 232 | 2600 | xx | xx | xx | xx
 |  | 500 | TEBC | 5011L | 255 | 2000 | xx | xx | xx | xx
 |  | 850 | TEBC | 449T | 245 | 2750 | xx | xx | xx | xx
 | 150 | 650 | TEBC | 5011L | 285 | 2600 | xx | xx | xx | xx
 |  | 500 | TEBC | 5011L | 305 | 2000 | xx | xx | xx | xx
 |  | 850 | TEBC | 5011L | 330 | 2750 | xx | xx | xx | xx
 | 200 | 650 | TEBC | 5011L | 380 | 2600 | xx | xx | xx | xx
 |  | 500 | TEBC | 5011L | 405 | 2000 | xx | xx | xx | xx
 |  | 850 | TEBC | 5011L | 405 | 2750 | xx | xx | xx | xx
 | 250 | 650 | TEBC | 5011L | 470 | 2600 | xx | xx | xx | xx
 |  | 500 | TEBC | 5011L | 540 | 2000 | xx | xx | xx | xx
 |  | 850 | TEBC | 5011L | 485 | 2750 | xx | xx | xx | xx
 | 300 | 650 | TEBC | 5013L | 585 | 2600 | xx | xx | xx | xx
 |  | 500 | TEBC | N/A | N/A | N/A | xx | xx | xx | xx
 | 350 | 850 | TEBC | 5013L | 535 | 2750 | xx | xx | xx | xx
 |  | 650 | TEBC | N/A | N/A | N/A | xx | xx | xx | xx
Spreadsheet: c6b2afbf-01bb-4d26-aec4-3686a0296065
Sheet: Sheet1

SEKOLAH MENENGAH KEBANGSAAN SEGAMBUT JAYA, KUALA LUMPUR | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22
JALAN 4/38A, SEGAMBUT, 51200 KUALA LUMPUR
MARKAH | GRED | A (80 - 100) | 0 |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0
0 | T | B (65 - 79) | 0 |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0
1 | E | C (50 - 64) | 0 |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0
40 | D | D (40 - 49) | 0 |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0
50 | C | E ( 1 - 39) | 0 |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0
65 | B | BIL LULUS | 0 |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  | 0
80 | A | % LULUS
101 | ERR | % GAGAL
 |  | BIL TIDAK HADIR | 0 |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | * Markah ETR  mesti lebih daripada markah TOV
HEAD COUNT PRESTASI AKADEMIK PELAJAR TAHUN |  |  | 2012 |  |  |  |  |  |  |  |  |  |  |  |  |  | TINGKATAN :
 |  |  | SUBJEK  : |  |  |  |  |  |  |  |  |  |  |  |  |  | BILANGAN PELAJAR :
BIL | J | NAMA PELAJAR | TOV |  | UJIAN KEMAJUAN 1 |  |  |  | PEPERIKSAAN PERTENGAHAN TAHUN |  |  |  | UJIAN KEMAJUAN 2 |  |  |  | PEPERIKSAAN AKHIR TAHUN |  |  |  | ETR
 |  |  | M | G | OTI | M | G | +/- | OTI | M | G | +/- | OTI | M | G | +/- | OTI | M | G | +/- | M | G
1
2
3
4
5
6
7
8
9
10
11
12
13
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
BILANGAN PELAJAR CEMERLANG A
PERATUS PELAJAR CEMERLANG A
BILANGAN PELAJAR LULUS (A - D)
PERATUS PELAJAR LULUS
SMKSJ/lyyong2010.HC123
Spreadsheet: 01baeff2-0577-40b4-918d-01cad6b77db1
Sheet: External Payment Request Manual

 |  |  | PeopleSoft Financials
 |  |  | University of Southern Queensland
 |  | External Payment Request
 |  |  | Please forward to Financial Services - Accounts Payable
AUSTRALIA |  |  |  |  |  |  |  |  |  |  | [NAME]
Department Paying for Goods and Services |  |  | Dept ID:
 |  |  | Dept Name:
 |  |  | Contact:
 |  |  | Tel: |  |  |  |  |  | Date:
Please remember to update Vendor Information on PeopleSoft
ABN: |  |  |  |  |  | REMIT CHEQUE TO: If different to Vendor
Vendor Number: Mandatory Field
Vendor Name:      Mandatory Field
Current Postal Address:
Flat,Level,Bld,Uni Dept
Street Number & Name
City and State
Country & Post or Zip Code
Please remember to attach Supporting Documentation and Entertainment Form |  |  |  |  |  |  | (if applicable)
Description |  |  | GST Exclusive Amount | GST Amount (10%) | Gross Amount | BU | Account | FD | Dept ID | Prog | Project
 |  |  |  |  |  | USQ10 |  | 2
 |  |  |  |  |  | USQ10 |  | 2
 |  |  |  |  |  | USQ10 |  | 2
 |  |  |  |  |  | USQ10 |  | 2
 |  |  |  |  |  | USQ10 |  | 2
 |  |  |  |  |  | USQ10 |  | 2
 |  |  |  |  |  | USQ10 |  | 2
 |  |  |  |  |  | USQ10 |  | 2
 |  |  |  |  |  | USQ10 |  | 2
 |  |  |  |  |  | USQ10 |  | 2
 |  |  |  |  |  | USQ10 |  | 2
 |  |  |  |  |  | USQ10
GST Exclusive Total -
GST Costed to General Ledger - |  |  |  |  |  | USQ10 | 63001 | 2 | 7680 | 70
GST Inclusive Total for Reimbursement -
Incomplete forms may delay payment
Please remember to split GST and Non GST Transactions for mixed supplies
I certify that the above sum is due and payable to the above-mentioned vendor and that any services referred to above have been supplied in a satisfactory manner as required by the University of Southern Queensland. |  |  |  |  | I certify that the payment detailed herein is necessary for the proper operation of the University, that this expenditure is within my level of delegated authority, and hereby authorise this expenditure.
______________________________________ |  |  | /    / |  | _______________________________________ |  |  |  |  |  | /    /
______________________________________ |  |  |  |  | _______________________________________
Requesting Officer (Please Print) |  |  |  |  | Authorising Officer (Please Print)
 |  |  |  |  | (Financial Delegate)
Spreadsheet: 263238d1378411434-conditional-format-to-mark-increase-from-previous-column-cfupdown
Sheet: Sheet1

Goal | January | February | March | April | May | June | July
0.3 | 1 | 1 | 1 | 1 | 1 | 1 | 1
0.8 | 0.929 | 0.976 | 1 | 1 | 1 | 1 | 1
0.4 | 0.9882352941176471 | 0.935 | 0.89 | 0.971 | 0.933 | 0.978 | 0.953
0.8 | 1 | 1 | 1 | 1 | 1 | 1 | 1
0.8 | 1 | 1 | 1 | 1 | 1 | 1 | 1
0.5 | 0.75 | 0.718 | 0.81 | 0.68 | 0.788 | 0.852 | 0.711
0.5 | 1 | 1 | 1 | 0.907 | 0.919 | 0.926 | 0.928
0.5 | 0.875 | 0.918 | 0.952 | 0.948 | 0.899 | 0.963 | 0.907
0.5 | 0.1641025641025641 | 0.293 | 0.506 | 0.717 | 0.743 | 0.407 | 0.356
Spreadsheet: 149228d1333751065-get-comment-test
Sheet: Sheet3

Employee Name | Date | Reason
[NAME] | 2012-07-01 00:00:00 | sick
[NAME] | 2012-07-02 00:00:00 | bludging |  |  |  | Absent Days by Employee | Date
[NAME] | 2012-07-04 00:00:00 | what ever |  |  |  | Employee Name | 2012-07-01 00:00:00 | 2012-07-02 00:00:00 | 2012-07-04 00:00:00 | 2012-07-05 00:00:00 | 2012-07-06 00:00:00 | 2012-07-08 00:00:00 | 2012-07-15 00:00:00 | 2012-07-22 00:00:00 | Grand Total
[NAME] | 2012-07-05 00:00:00 |  |  |  |  | [NAME] | 1 |  | 1 | 1 | 1 | 1 | 1 | 1 | 7
[NAME] | 2012-07-06 00:00:00 |  |  |  |  | [NAME] |  | 1 |  |  |  |  |  |  | 1
[NAME] | 2012-07-08 00:00:00 |  |  |  |  | Grand Total | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 8
[NAME] | 2012-07-15 00:00:00
[NAME] | 2012-07-22 00:00:00
Spreadsheet: kate_symes__18460__Palo
Sheet: DJ Palo Verde Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-01-16 00:00:00 |  | 173.04 | 18112 | 105.14 | 4120
 | 2001-01-15 00:00:00 |  | 173.04 | 18112 | 104.82 | 3960 | 169.46 | 718 | 107.24 | 593
 | 2001-01-14 00:00:00 |  | 152.5 | 0 | 103 | 0 | 130.52 | 713 | 116.11 | 446 |  | 107.23 | 13560
 | 2001-01-13 00:00:00 |  | 152.77 | 14160 | 107.23 | 4520 | 138.98 | 1547 | 120.82 | 1165
 | 2001-01-12 00:00:00 |  | 159.03 | 18032 | 90.92 | 3800 | 160.71 | 727 | 98 | 450
 | 2001-01-11 00:00:00 |  | 160.31 | 19472 | 90.92 | 3800 | 153.64 | 1669 | 94.86 | 1106
 | 2001-01-10 00:00:00 |  | 143.16 | 18208 | 84.37 | 3352 | 129.46 | 2981 | 93.14 | 1118
 | 2001-01-09 00:00:00 |  | 132.19 | 14400 | 75.61 | 4552 | 145.14 | 850 | 87.82 | 1753
 | 2001-01-08 00:00:00 |  | 127.4 | 15728 | 68.15 | 5768 | 140.11 | 1652 | 87.68 | 460
 | 2001-01-07 00:00:00 |  | 121.67 | 2400 | 65 | 800 | 84.12 | 1047 | 58.43 | 682 |  | 69.34 | 16944
 | 2001-01-06 00:00:00 |  | 121.11 | 22672 | 71.97 | 5784 | 90.26 | 442 | 59.63 | 622
 | 2001-01-05 00:00:00 |  | 121.35 | 23072 | 72.24 | 5984 | 105.21 | 932 | 98.02 | 734
 | 2001-01-04 00:00:00 |  | 131.61 | 14064 | 79.75 | 6272 | 120.52 | 512 | 71.21 | 514
 | 2001-01-03 00:00:00 |  | 143.06 | 13168 | 85.45 | 3584 | 129.29 | 613 | 75.14 | 791
 | 2001-01-02 00:00:00 |  | 149.82 | 10992 | 93.38 | 2840 | 124.91 | 1327 | 56.75 | 526
 | 2001-01-01 00:00:00 |  | 145 | 0 | 100 | 0 | 70.68 | 2284 | 50.55 | 1025 |  | 93.52 | 7320
 | 2000-12-31 00:00:00 |  | 94.03 | 2480 | 88.53 | 680 | 55.11 | 1961 | 56.69 | 816 |  | 89.07 | 1992
 | 2000-12-30 00:00:00 |  | 121.88 | 6160 | 88.79 | 1344 | 90.2 | 1203 | 69.44 | 897
 | 2000-12-29 00:00:00 |  | 169.36 | 5600 | 86.08 | 1088 | 146.94 | 2282 | 91.56 | 880
 | 2000-12-28 00:00:00 |  | 169.36 | 5600 | 86.08 | 1088 | 138.35 | 2041 | 123.17 | 293
 | 2000-12-27 00:00:00 |  | 232 | 10048 | 123.85 | 728 | 128.78 | 2370 | 96.27 | 690
 | 2000-12-26 00:00:00 |  | 250.55 | 12960 | 173.75 | 800 | 124.75 | 1488 | 90.47 | 590
 | 2000-12-25 00:00:00 |  | 217.21 | 2080 | 175 | 0 | 78.91 | 709 | 55.11 | 871 |  | 204.22 | 10800
 | 2000-12-24 00:00:00 |  | 217.21 | 2080 | 175 | 0 | 92.39 | 584 | 65.56 | 160 |  | 204.22 | 10800
 | 2000-12-23 00:00:00 |  | 276.77 | 11728 | 192.64 | 2800 | 140 | 35 | 121.09 | 184
 | 2000-12-22 00:00:00 |  | 276.77 | 11728 | 192.64 | 2800 | 267.5 | 0 | 80 | 375
 | 2000-12-21 00:00:00 |  | 276.77 | 11728 | 192.64 | 2800 | 252.65 | 1831 | 132.45 | 530
 | 2000-12-20 00:00:00 |  | 269.33 | 15200 | 190.33 | 2688 | 198.54 | 3261 | 151.82 | 927
 | 2000-12-19 00:00:00 |  | 258.18 | 10272 | 178.86 | 1968 | 195.85 | 2305 | 133.46 | 718
 | 2000-12-18 00:00:00 |  | 224.43 | 11840 | 176.78 | 1168 | 220.89 | 1072 | 124.85 | 495
 | 2000-12-17 00:00:00 |  | 196.67 | 1200 | 175.71 | 280 | 136.93 | 985 | 113.5 | 500 |  | 177.12 | 2664
Spreadsheet: 456051d1460624923-summing-up-with-criterias-test_formula-sumproduct-
Sheet: Sheet1

 | Date | Price |  | Sum of Price | Dates | Dates | Dates | Dates | Dates | Dates | Dates | Dates | Dates
 | 2016-04-01 00:00:00 | 156 |  |  | 2016-04-01 00:00:00 | 2016-04-02 00:00:00 | 2016-04-03 00:00:00 | 2016-04-04 00:00:00
 | 2016-04-02 00:00:00 | 144 |  |  | 2016-04-01 00:00:00 | 2016-04-02 00:00:00 | 2016-04-03 00:00:00 | 2016-04-04 00:00:00
 | 2016-04-03 00:00:00 | 144 |  |  | 2016-04-01 00:00:00 | 2016-04-02 00:00:00 | 2016-04-03 00:00:00 | 2016-04-08 00:00:00 | 2016-04-10 00:00:00
 | 2016-04-04 00:00:00 | 82 |  |  | 2016-04-02 00:00:00 | 2016-04-04 00:00:00 | 2016-04-09 00:00:00
 | 2016-04-05 00:00:00 | 144
 | 2016-04-06 00:00:00 | 144
 | 2016-04-07 00:00:00 | 159
 | 2016-04-08 00:00:00 | 160
 | 2016-04-09 00:00:00 | 211
 | 2016-04-10 00:00:00 | 268
Spreadsheet: 222343d1363818824-times-name-appears-given-a-condition-in-a-table-sample-review-
Sheet: Report

Auditor Name: | Review Date: | Loan #: | Borrower name: | ,[NAME] | r,978r,9 | ,76r969 | ,9rr6, | 9797 | r56.6 | r9r76k68 | ouiouo | ouio | gdrghdgd | MI Name: | Comments
[NAME] | 2013-03-19 00:00:00 | 53643 | Smith | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | [NAME] | gfd
[NAME] | 2013-03-19 00:00:00 | 3123 | Munster | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | Yes | Yes | [NAME] | gdfgd
[NAME] | 2013-03-19 00:00:00 | 12123 | Jones | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No | Yes | Yes | Eva | gdfgh
[NAME] | 2013-03-19 00:00:00 | 1212 | [NAME] | No | No | Yes | No | No | Yes | No | No | No | No | [NAME] | hgfhf
[NAME] | 2013-03-19 00:00:00 | 1212 | [NAME] | No | No | Yes | No | No | Yes | No | No | No | No | [NAME] | [NAME]