tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 356116d1414987774-if-statement-help-discount-mgd
Sheet: Sheet1

Distribution Costs
 |  | Spruce | [NAME] | Duchesne
 | Seattle |  | 46.68 | 52.8
 | Chicago | 89.77 | 128.82 | 97.17
 | Dallas | 162.24 | 204.13 | 210.42
 | New Orleans | 166.18 | 195.08 | 200.62
 | Denver | 151.77 | 162.83 | 142.82
 | LA | 10 | 147.46 | 150.14
 | SF | 151.11 | 115.49 | 124.83
 | Vancouver |  | 72.42 | 42.17
 | Calgary |  | 77.5 | 87.94
 |  | Spruce | [NAME] | Duchesne
 | Seattle | 0 | 40727 | 0
 | Chicago | 0 | 0 | 55608
 | Dallas | 0 | 92680 | 0
 | New Orleans | 0 | 38922.28571428571 | 53757.71428571429
 | Denver | 0 | 0 | 23832
 | LA | 150410.8571428572 | 0 | 61430.14285714284
 | SF | 0 | 52960 | 0
 | Vancouver | 0 | 0 | 32581
 | Calgary | 0 | 8145 | 0
 | Distribution Cost
Spreadsheet: 32340d1228444355-workbook-stripped-of-format-after-its-saved-mastertemplate_standard-calc-november-2008v4_corrupt-corrected
Sheet: Proofing Sheet

STANDARD CAF | C | 200970 | 0 | AHE 120 | 0 | 0 |  |  | Wed |  | 09:00:00
Term | 200970 |  |  |  |  |  |  | Instructor | 0
Campus | E - Essex |  |  |  |  |  |  | ID Number | 0
Status | Active |  |  |  |  |  |  | Account # | 0
Course # | AHE 120 |  |  |  |  |  |  | Teaching Hrs | 60
Course Title | Something |  |  |  |  |  |  | [NAME] | 0
Course Delivery | Contract |  |  |  |  |  |  | Adjustment | 0
Pt of Term | 2 - Contract |  |  |  |  |  |  | Adj. Reason | 0
Session | Weekend |  |  |  |  |  |  | Total | 0
Gradable | Yes |  |  |  |  |  |  | Campus/Site | 0
WebReg/VR | Yes |  |  |  |  |  |  | Conf. Location | 0
Start Date | 2009-01-07 00:00:00 |  |  |  |  |  |  | Bldg. Code | 0
End Date | 2009-01-14 00:00:00 |  |  |  |  |  |  | Tution | 0
Day(s) |  |  |  |  |  |  |  | Lab Fee | 0
# of Session | 2 |  |  |  |  |  |  | Admin Fee | 0
Skip Dates | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  | Reg Fee | 0
 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 |  |  | Total Fees | 0
Start Time | 09:00:00 |  |  |  |  |  |  | Total Cost | 0
End Time | 09:30:00 |  |  |  |  |  |  | Section Notes:
Break Minutes | 0 |  |  |  |  |  |  | 0
Hours Per Session | 30
Total Teaching Hrs | 60
MHEC Hours | 72
20% Session | 1 |  |  |  |  |  |  | Letter of Intent # |  | 0
20% Freeze Date | 2009-01-07 00:00:00 |  |  |  |  |  |  | Company Contact Info:
[NAME] | 0 |  |  |  |  |  |  | 0
Min Enrollment | 0 |  |  |  |  |  |  | 0
Division | 0 |  |  |  |  |  |  | 0
Department | 0 |  |  |  |  |  |  | 0
CEUs | 7.2 |  |  |  |  |  |  | 0
Learning Method | 0 |  |  |  |  |  |  | 0
Certificate | 0 |  |  |  |  |  |  | 0
[NAME] | Arranged
Coordinator: | 0 |  |  |  |  |  |  | Phone: | 0
Note:The proofing team is not responsible for reviewing fields that are gray shaded.  Those fields should be reviewed and edited in the program areas before submittal to the proofing team.  Course# must be active and the MHEC hours must fall within the approved range as shown in [NAME].
Spreadsheet: 135215d1325870770-maximum-characters-in-a-formula-that-is-emedded-in-a-data-validation-test-file
Sheet: Dropdowns

 |  | Module/Product Family | Sub-Module
 |  | Callcenter - CRM | Siebel Call Center
 |  |  | Siebel Professional Services
 |  |  | [NAME] Master
 |  |  | Oracle BI Publisher
 |  | Siebel Customer Order Management | Siebel Order Management
 |  | Siebel Employee Relationship Management | Siebel ERM
 |  | Siebel Field Service | Siebel Service
 |  |  | Service Handheld
 |  | [NAME] | [NAME]
 |  |  | Siebel Events Manager
 |  | [NAME] | Siebel Partner Manager
 |  |  | Siebel Partner Portal
 |  |  | Siebel Partner Operations Manager
 |  | Siebel Sales | Siebel Sales
 |  |  | [NAME]
 |  | Self Service | eMarketing
 |  |  | eSales
 |  |  | eService
 |  | Automotive | [NAME]
 |  |  | Siebel eCustomer
 |  |  | [NAME]
 |  |  | Siebel Dealer
 |  | C, M & E | Siebel Energy
 |  |  | [NAME] CME
 |  |  | Siebel Power Communications
 |  | Consumer Goods | Callcenter
 |  |  | Marketing
 |  |  | Goods & Customer
 |  |  | Sales & Marketing
 |  |  | [NAME]
 |  | Financial Service (Healthcare) | Callcenter
 |  |  | Sales
 |  |  | Agent Portal
 |  |  | Customer Portal & Enrollment Portal
 |  |  | Group Portal
 |  |  | ProviderPortal
 |  |  | Marketing
 |  | Financial Service (Institutional & Retail Finance) | Finance Callcenter
 |  | Financial Service (Insurance) | Siebel Financial Services
 |  |  | Financial eCustomer
 |  |  | Insurance Agent Portal
 |  | Hi Tech/Industrial Manufacturing | [NAME]
 |  |  | eCustomer
 |  |  | Marketing
 |  |  | Partner Manager
 |  |  | [NAME]
 |  |  | PRM Portal
 |  | Hosptality | [NAME]
 |  | Life Sciences (Clinical) | Clinical
 |  |  | Clinical Site Portal
 |  | Life Sciences (Medical) | Siebel Medical
 |  | Life Sciences (Pharma) | [NAME]
 |  | Loyalty | Loyalty Customer Potal
 |  |  | Loyalty Partner Portal
 |  |  | Loyalty Manager
 |  | Public Sector | Public Sector
 |  |  | Public Sector [NAME]
Spreadsheet: 2589ff0f-4afd-458b-870c-245c64c7eeb2
Sheet: Sheet1

Unnamed: 0 | 52787 | 15 | 20081001 | 20081028 | 3114.8 | 20080815 | Unnamed: 7 | 2014.8 | Unnamed: 9 | 1100 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
 |  |  |  |  |  |  | 987654321 | 80 |  | 250 |  |  | DEBLOIS PIERRE
 |  |  |  |  |  |  | 987654432 | 365.4 |  | 100 |  |  | TANGUAY GHISLAIN
 |  |  |  |  |  |  | 987654733 | 80 |  | 80 |  |  | COULOMBE MICHEL
 |  |  |  |  |  |  | 986245265 | 365.4 |  | 0 |  |  | [NAME]
 |  |  |  |  |  |  | 971256265 | 80 |  | 0 |  |  | FORTIN PIERRE
 |  |  |  |  |  |  | 256889651 | 32 |  | 0 |  |  | TREMBLAY CAPUCINE
 |  |  |  |  |  |  | 971256286 | 42 |  | 0 |  |  | [NAME]
 |  |  |  |  |  |  | 971256245 | 50 |  | 50 |  |  | SOUMIS CLAUDINE
 |  |  |  |  |  |  | 256221563 | 120 |  | 120 |  |  | DEPRES ROMAIN
 |  |  |  |  |  |  | 931256285 | 150 |  | 100 |  |  | DESILETS MONIQUE
 |  |  |  |  |  |  | 951256285 | 150 |  | 180 |  |  | ROUSSIN CLAIRE
 |  |  |  |  |  |  | 971256285 | 180 |  | 120 |  |  | POITRAS LUCILLE
 |  |  |  |  |  |  | 454254369 | 220 |  | 100 |  |  | GAUTHIER NELSON
 |  |  |  |  |  |  | 154256321 | 100 |  | 0 |  |  | FORTIN BENOIT
 |  |  |  |  |  |  | 514621461 | 0 |  | 0 |  | C | [NAME]
Spreadsheet: 797366d1663845591-need-to-return-the-worker-site-based-on-a-table-with-his-working-hours-example-hd-1-
Sheet: Sheet with formula

Worker number | [NAME]
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 |  |  | DE.1052
30 |  |  | DE.1052
31 |  |  | DE.1053
32 |  |  | DE.1054
33 |  |  | DE.1053
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52 |  |  | Check
53
54
55
56
57
58
59
60
61
62 |  |  | DE.1052
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158 |  |  | Check
Spreadsheet: 477463d1472304322-program-for-stitching-unit-sample-excel
Sheet: delivery

CLIENT 1 |  |  |  |  |  |  |  | CLIENT 2 |  |  |  |  |  |  |  | CLIENT 3 |  |  |  |  |  |  |  | CLIENT 4
 |  | 160 | 130 | 48 | 88 |  |  |  |  | 204 | 162 | 44 | 28 |  |  |  |  | 228 | 81 | 102 | 168
date |  | s | m | l | xl |  |  | date |  | s | m | l | xl |  |  | date |  | s | m | l | xl |  |  | date
20-8-2016 |  | 10 | 5 |  |  |  |  | 20-8-2016 |  | 21 |  |  | 2 |  |  | 20-8-2016 |  |  | 17 |  | 39 |  |  | 20-8-2016
21-8-2016 |  |  | 15 |  |  |  |  | 21-8-2016 |  | 31 |  |  |  |  |  | 21-8-2016 |  |  | 27 |  | 41 |  |  | 21-8-2016
22-8-2016 |  |  |  |  |  |  |  | 22-8-2016 |  |  |  |  |  |  |  | 22-8-2016 |  |  | 37 | 30 | 43 |  |  | 22-8-2016
23-8-2016 |  | 40 |  | 12 | 16 |  |  | 23-8-2016 |  |  | 44 |  |  |  |  | 23-8-2016 |  | 42 |  | 34 | 45 |  |  | 23-8-2016
24-8-2016 |  | 50 | 45 | 15 | 20 |  |  | 24-8-2016 |  |  | 54 | 20 |  |  |  | 24-8-2016 |  | 52 |  | 38 |  |  |  | 24-8-2016
26-08-2016 |  | 60 |  |  | 24 |  |  | 26-08-2016 |  | 71 | 64 | 24 | 12 |  |  | 26-08-2016 |  | 62 |  |  |  |  |  | 26-08-2016
26-08-2016 |  |  | 65 | 21 | 28 |  |  | 26-08-2016 |  | 81 |  |  | 14 |  |  | 26-08-2016 |  | 72 |  |  |  |  |  | 26-08-2016
27-08-2016 |  |  |  |  |  |  |  | 27-08-2016 |  |  |  |  |  |  |  | 27-08-2016 |  |  |  |  |  |  |  | 27-08-2016
Spreadsheet: 701736d1603903677-help-witth-averageif-book1
Sheet: 2020

 | 2 | 3 | 0
 |  | 2 | 2
 |  | 1 | 0
 |  | 2 | 4
 |  | 3 | 0
 |  | 2 | 0
 |  | 1 | 1
 |  | 3 | 3
 |  | 1 | 3
 |  | 3 | 1
 |  | 2 | 0
 |  | 1 | 2
 |  | 3 | 3
Spreadsheet: 38d98cb6-ad01-4413-9c8a-132997a52ada
Sheet: 000-00-000

000-00-000 | 000095010 | [NAME]
000-00-000 | 000095010 | CORDES JOYCE
000-00-000 | 000095010 | CORDES M JOHN
000-00-000 | 000095010 | DALBEC RANDY
000-00-000 | 000095010 | [NAME]
000-00-000 | 000095010 | MOTL DAIRY FARM INC
0 | 000054027 | MAAS JARED
Spreadsheet: 161278d1339468640-excel-2007-return-values-from-different-worsheets-according-to-month-and-data-list-sample
Sheet: N1SR

 |  | NOTA 2 SUMATIVA
HORA: |  |  |  |  |  | SEGUNDO R |  |  |  |  |  | [NAME]
CURVA | 100 | -- | 90 | A |  |  | 2012-08-03 00:00:00 | 2012-08-15 00:00:00
EN   % |  | -- | 80 | B
 |  | -- | 70 | C
 |  | -- | 60 | D
 |  | -- |  | F
 |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | SUMA
VALORES MÁXIMOS : |  |  |  |  |  |  | 10 | 10
NOMBRE DEL ESTUDIANTE |  |  |  |  |  | Números | 1 | 2 | 3 | 4 | 5 | TOTAL PUNTOS | NOTA | % | Arreglo
 |  |  |  |  |  | 1 | 5 | 10
 |  |  |  |  |  | 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
Spreadsheet: 219587d1362797532-if-function-book1
Sheet: Sheet1

Date | Fiscal week | Employee | Score
2013-02-02 00:00:00 | week1(feb2-feb8) | Alvin | 90
2013-02-02 00:00:00 | week1(feb2-feb8) | Dale | 75
2013-02-04 00:00:00 | week1(feb2-feb8) | [NAME] | 84
2013-02-02 00:00:00 | week1(feb2-feb8) | [NAME] | 89
2013-02-07 00:00:00 | week1(feb2-feb8) | [NAME] | 81
2013-02-08 00:00:00 | week1(feb2-feb8) | Alvin | 82.6
2013-02-08 00:00:00 | week1(feb2-feb8) | Dale | 82.2
2013-02-09 00:00:00 | week2 (feb9-feb15 | [NAME] | 81.8
2013-02-11 00:00:00 | week2 (feb9-feb15 | [NAME] | 81.4
2013-02-15 00:00:00 | week2 (feb9-feb15 | [NAME] | 81
2013-02-16 00:00:00 | week3(feb16 - feb22 | Alvin | 80.6
2013-02-18 00:00:00 | week3(feb16 - feb22 | Dale | 80.2
2013-02-18 00:00:00 | week3(feb16 - feb22 | [NAME] | 79.8
2013-02-19 00:00:00 | week3(feb16 - feb22 | [NAME] | 79.4
2013-02-22 00:00:00 | week3(feb16 - feb22 | [NAME] | 79
2013-02-23 00:00:00 | week4(feb23 - mar1) | Alvin | 78.6
2013-02-24 00:00:00 | week4(feb23 - mar1) | Dale | 78.2
2013-02-24 00:00:00 | week4(feb23 - mar1) | [NAME] | 77.8
2013-02-26 00:00:00 | week4(feb23 - mar1) | [NAME] | 77.4
2013-03-01 00:00:00 | week4(feb23 - mar1) | [NAME] | 77
2013-03-02 00:00:00 | week5(mar2- mar8) | Alvin | 76.6
2013-03-04 00:00:00 | week5(mar2- mar8) | Dale | 76.2
2013-03-04 00:00:00 | week5(mar2- mar8) | [NAME] | 75.8
2013-03-06 00:00:00 | week5(mar2- mar8) | [NAME] | 75.4
2013-03-08 00:00:00 | week5(mar2- mar8) | [NAME] | 75
2013-03-09 00:00:00 | week6(mar9-mar15) | Alvin | 74.6
2013-03-11 00:00:00 | week6(mar9-mar15) | Dale | 74.2
2013-03-13 00:00:00 | week6(mar9-mar15) | [NAME] | 73.8
2013-03-14 00:00:00 | week6(mar9-mar15) | [NAME] | 73.4
2013-03-14 00:00:00 | week6(mar9-mar15) | [NAME] | 73
 | week7(mar16-mar22)
 | and so on
Spreadsheet: 728721d1618587906-consolidation-of-tables-table-consolidation
Sheet: Power Query

Table 1 |  |  |  | Table 2 |  |  |  | Table 3 |  |  |  | Table 4
A: | Data |  |  | A: | Sometimes data, if data in B |  |  | A: | Blank |  |  | A: | Data from A in Table 1 and Table 2, sorted in ascending order
B: | Blank |  |  | B: | Data |  |  | B: | Sometimes data, if data in C |  |  | B: | Data from B in Table 2 and Table 2, sorted in ascending order
C: | Blank |  |  | C: | Blank |  |  | C: | Data |  |  | C: | Data from C in Table 2, sorted in ascending order
A | B | C |  | A | B | C |  | A | B | C |  | A | B | C |  | AA | BB | C
8 |  |  |  | 5 | 6 |  |  |  |  | 10 |  | 1 | 2 |  |  | 1 | 2
5 |  |  |  |  | 9 |  |  |  | 6 | 7 |  | 5 | 6 | 7 |  | 5 | 6 | 7
 |  |  |  | 1 | 2 |  |  |  | 3 | 4 |  | 5 | 6 | 13 |  | 5 | 6 | 13
 |  |  |  | 5 | 11 |  |  |  | 6 | 13 |  | 5 | 11 | 12 |  | 5 | 11 | 12
 |  |  |  |  | 3 |  |  |  | 11 | 12 |  | 5 | 14 |  |  | 5 | 14
 |  |  |  | 5 | 14 |  |  |  | 15 | 17 |  | 8 |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 4 |  |  | 3 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 17 |  |  | 15 | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  |  |  | 10
General: |  |  |  |  |  |  |  |  |  |  |  | Line two (5, 6, 7) is a merge of line 1 in Table 2 (5, 6, blank) and line 2 in Table 3 (blank, 6, 7)
A single A can point to many [NAME] which again can point to many [NAME]. |  |  |  |  |  |  |  |  |  |  |  | Line three  (5, 6, 13) is a merge of line 1 in Table 2 (5, 6, blank) and line 4 in Table 3 (blank, 6, 13)
A single C can point to only one B which again can point to only one A. |  |  |  |  |  |  |  |  |  |  |  | Line four (5, 11, 12) is a merge of line 4 in Table 2 (5, 11, blank) and line 5 in Table 3 (blank, 11, 12)
[NAME] should work with both text entries and number entries. |  |  |  |  |  |  |  |  |  |  |  | Line 2, 3, 4 and 5 absorbes line 2 in Table 1
 |  |  |  |  |  |  |  |  |  |  |  | Line 7 absorbes line 5 of table 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | B | C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 6 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 6 | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 11 | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
Spreadsheet: 216753d1361880781-excel-work-with-an-if-formula-help-uzduotis
Sheet: payment

 | Wot |  |  |  | income of less 601 Lt |  |  |  | 0.15
 |  |  |  |  | income from 601 Lt iki 999 Lt |  |  |  | 0.35
 |  |  |  |  | income from 1000 Lt |  |  |  | 0.45
 |  |  |  |  | Income | The amount of tax
 |  | [NAME] |  |  | 1000
 |  | Petras |  |  | 850
 |  | Margarita |  |  | 1100
 |  | Onutė |  |  | 500
 |  | [NAME] |  |  | 400
 |  | Justas |  |  | 999
 |  | Vida |  |  | 620
 |  | Karolina |  |  | 485
 |  | Linas |  |  | 2000
 |  | Ovidijus |  |  | 601
 |  | Violeta |  |  | 600
Spreadsheet: 729619d1619200272-comparing-time-values-comparing-times-sample2
Sheet: Compiled

;;StartList
1
R
N
X
X
X |  |  |  |  |  |  |  |  |  | NEED EXCEL NOT TO THINK THAT F8 TIME IS LESS THAN G8
X
;;StartList
16
R
N
X
X
X
X
X
X
Spreadsheet: 738653d1625161119-filter-for-rows-containing-1-of-multiple-or-criteria-excel-forum-sample
Sheet: Sheet3

 | CURRENT DATA |  |  |  |  |  |  | END RESULT
 | Employee | Food | Number Eaten |  | Looking for a formula that will return rows where column B contains one of these values: Cookies, cupcakes |  |  | Employee | Food | Number Eaten
 | [NAME] | Donuts | 4 |  |  |  |  | [NAME] | Cookies | 2
 | [NAME] | Cookies | 2 |  |  |  |  | [NAME] | Cookies | 5
 | [NAME] | Mozzarella Sticks | 6 |  |  |  |  | [NAME] | Cupcakes | 1
 | [NAME] | Cookies | 5
 | [NAME] | Cupcakes | 1
 | [NAME] | Pretzels | 3
Spreadsheet: 832580d1686450568-sum-up-until-a-blank-cell-appears-summations
Sheet: Sheet2

What I want
Room # | Room Name | Individual Size | Group size
1-a | KITCHEN LEVEL 1 | 1300.888888888888
1-b | KITCHEN LEVEL 2 | 405.555555555555
1-c | KITCHEN LEVEL 3 | 833.3333333333352
1-04 | PROGRAM LEVEL 1 | 309.9999999999972
 | PROGRAM LEVEL 1 | 309.9999999999972
1-d | PROGRAM LEVEL 2 | 1379.999999999999
1-e | PROGRAM LEVEL 3 | 309.9999999999997
1-f | LOBBY LEVEL 1 | 613.3333333333319
1-g | LOBBY LEVEL 2 | 275.555555555558
 | LOBBY LEVEL 2 | 275.555555555558
 | LOBBY LEVEL 2 | 275.555555555558
 | LOBBY LEVEL 2 | 275.555555555558
1-h | LOBBY LEVEL 2 | 275.555555555558
 | LOBBY LEVEL 2 | 275.555555555558
Spreadsheet: 21839d1209918604-need-help-with-formulas-8th-sign
Sheet: Sheet1

Guide Girls of Canada Sign Stats                            ( 8th Sign Free ) As of January 1, 2008
Work Order (W/O) # | # [NAME] Ordered | Invoiced (Y/N) | # Invoice Free Signs | # Free Signs               Total             Year to Date | # Signs                Total           Year to Date
13219 | 14 | Yes | 1 | 1.75 | 14
13023 | 1 | Yes | 0 | 1.875 | 15
13305 | 3 | Yes | 1 | 2.25 | 18
13519 | 14 |  | 2 | 4 | 32
13527 | 2 |  | 0 | 4.25 | 34
 |  |  | XXXXXXXX | XXXXXXXXX | XXXXXXXXX
 |  |  | XXXXXXXX | XXXXXXXXX | XXXXXXXXX
 |  |  | XXXXXXXX | XXXXXXXXX | XXXXXXXXX
 |  |  | XXXXXXXX | XXXXXXXXX | XXXXXXXXX
 |  |  | XXXXXXXX | XXXXXXXXX | XXXXXXXXX
 |  |  | XXXXXXXX | XXXXXXXXX | XXXXXXXXX
 |  |  | XXXXXXXX | XXXXXXXXX | XXXXXXXXX
 |  |  | XXXXXXXX | XXXXXXXXX | XXXXXXXXX
 |  |  | XXXXXXXX | XXXXXXXXX | XXXXXXXXX
 |  |  | XXXXXXXX | XXXXXXXXX | XXXXXXXXX
 |  |  | XXXXXXXX | XXXXXXXXX | XXXXXXXXX
 |  |  | XXXXXXXX | XXXXXXXXX | XXXXXXXXX
 |  |  | XXXXXXXX | XXXXXXXXX | XXXXXXXXX
 |  |  | XXXXXXXX | XXXXXXXXX | XXXXXXXXX
 |  |  | XXXXXXXX | XXXXXXXXX | XXXXXXXXX
 |  |  | XXXXXXXX | XXXXXXXXX | XXXXXXXXX
 |  |  | XXXXXXXX | XXXXXXXXX | XXXXXXXXX
 |  |  | XXXXXXXX | XXXXXXXXX | XXXXXXXXX
 |  |  | XXXXXXXX | XXXXXXXXX | XXXXXXXXX
 |  |  | XXXXXXXX | XXXXXXXXX | XXXXXXXXX
 |  |  | XXXXXXXX | XXXXXXXXX | XXXXXXXXX
Spreadsheet: 795616d1662800534-calculate-average-but-exclude-weekend-and-public-holiday-book1
Sheet: Cal

 | April | Day | Total
 | 2022-04-01 00:00:00 |  | 5 |  |  | Date | Day | Holiday
 |  |  | 4 |  |  | 2022-01-01 00:00:00 | Saturday | New Year’s Day
 |  |  | 5 |  |  | 2022-02-01 00:00:00 | Tuesday | Chinese New Year
 |  |  | 4 |  |  | 2022-02-02 00:00:00 | Wednesday | Chinese New Year
 |  |  | 5 |  |  | 2022-04-15 00:00:00 | Friday | Good Friday
 |  |  | 6 |  |  | 2022-05-01 00:00:00 | Sunday | Labour Day
 |  |  | 7 |  |  | 2022-05-03 00:00:00 | Tuesday | [NAME]
 |  |  | 8 |  |  | 2022-05-15 00:00:00 | Sunday | [NAME]
 |  |  | 3 |  |  | 2022-07-10 00:00:00 | Sunday | [NAME]
 |  |  | 5 |  |  | 2022-10-24 00:00:00 | Monday | Deepavali
 |  |  | 6 |  |  | 2022-12-25 00:00:00 | Sunday | Christmas Day
 |  |  | 7
 |  |  | 8
 |  |  | 9
 |  |  | 3
 |  |  | 6
 |  |  | 8
 |  |  | 3
 |  |  | 6
 |  |  | 9
 |  |  | 5
 |  |  | 1
 |  |  | 4
 |  |  | 6
 |  |  | 7
 |  |  | 4
 |  |  | 3
 |  |  | 2
 |  |  | 5
 |  |  | 7
 | Ave/mth
 |  |  |  |  |  |  | \
Spreadsheet: darrell_schoolcraft__7379__NNG LAMAR NOMNATION
Sheet: 01-(5-7)

 |  |  |  | Time/Date
 |  |  |  | Beginning Gas Day: | 1.5.02
 |  |  |  | Ending Gas Day: | 1.7.02
 |  | [NAME] |  |  | 15000
 |  | Hour
 |  | Ending | [NAME] | Accumulated | Remaining | Daily Burn
 |  | CST |  |  |  | Rate
 |  | 10 | 1153
 |  |  | 1153
 |  |  | 1153
 |  |  | 1153
 |  |  | 1153
 |  |  | 1153
 |  |  | 1153
 |  |  | 1153
 |  |  | 1153
 |  |  | 1153
 |  |  | 1153
 |  |  | 1153
 |  |  | 1164
 |  |  | 0
 |  |  | 0
 |  | 1 | 0
 |  | 2 | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
Spreadsheet: 864209d1711468863-finding-the-difference-between-two-dates-with-time-and-showing-negative-numbers-video-time-master-with-password
Sheet: Master Video Page

 | EXAMPLE
 | Video Time | Actual Time |  |  |  |  | OUTPUT TO COPY EXAMPLE
 | Date and time [NAME] dd/mm/yy hh:[NAME]:ss AM/PM | Date and time [NAME] dd/mm/yy hh:[NAME]:ss AM/PM
 | 2022-10-20 22:03:00 | 2022-10-21 00:15:12 | Video is
 | 2022-10-21 00:15:15 | 2022-10-20 22:03:02 | Video is
 | 2022-10-21 00:15:00 | 2022-10-17 17:03:15 | Video is
 | PUT YOUR DATA BELOW (FOLLOW THE FORMAT IN BLUE )
 | Video Time | Actual Time | Total |  |  |  | COPY BELOW WITH CTRL + C  AND PASTE IN YOUR REPORT | I want to data from Column H to read as a plain text so I can convert it all into seconds. Currently I have to paste special to get the info here and I want it to automatically be a text format | Here is the converted infor off of Column I into seconds, This formula is off by a little | This column makes it negative or positive based on column I being negative or positive
 | Date and time [NAME] dd/mm/yy hh:[NAME]:ss AM/PM | Date and time [NAME] dd/mm/yy hh:[NAME]:ss AM/PM
Video 1 | 2022-10-21 00:15:15 | 2022-10-20 22:03:02 | Video is |  |  |  |  | <---------------Paste Special of Column H Below is what hap[pens when I manually paste Special
Video 2 | 2022-10-20 22:03:00 | 2022-10-21 00:15:12 | Video is |  |  |  |  | Video is + 0 days 2 hours 12 minutes 12 seconds Slower than Actual Time
Video 3 |  |  | Video is
Video 4 |  |  | Video is
Video 5 |  |  | Video is
Video 6 |  |  | Video is
Video 7 |  |  | Video is
Video 8 |  |  | Video is
Video 9 |  |  | Video is
Video 10 |  |  | Video is
Video 11 |  |  | Video is
Video 12 |  |  | Video is
Video 13 |  |  | Video is
Video 14 |  |  | Video is
Video 15 |  |  | Video is
Video 16 |  |  | Video is
Video 17 |  |  | Video is
Video 18 |  |  | Video is
Video 19 |  |  | Video is
Video 20 |  |  | Video is
Video 21 |  |  | Video is
Video 22 |  |  | Video is
Video 23 |  |  | Video is
Video 24 |  |  | Video is
Video 25 |  |  | Video is
Video 26 |  |  | Video is
Spreadsheet: 836671d1689585586-using-index-formula-to-summarise-training-database-index-1-
Sheet: GIR

CÔNG TY TNHH GE-SHEN VIỆT NAM |  |  |  |  |  | Form: | HR-F01
GE-SHEN (VIETNAM) CO., LTD. |  |  |  |  |  | Rev: | C
GHI CHÉP ĐÀO TẠO CÁ NHÂN/ NHÓM
GROUP / INDIVIDUAL TRAINING RECORD
Ngày bắt đầu |  | 2022-01-05 00:00:00 |  | [NAME] điểm |  |  |  |  | For C9, C11, F7 and F9, can it pull the data from Database sheet?
Start date |  |  |  | Venue
[NAME] |  |  |  | Người đào tạo
End date |  |  |  | Trainer's name
Số ngày |  |  |  | Chức danh đào tạo | 6S Training
Time/ No. Of Days |  |  |  | Training Title
TT | Tên người tham gia | Emp. No. | Dept | Khóa đào tạo | Kết quả đào tạo | Chữ ký | Ghi chú
No. | Participant Name |  |  | Training Course | Result | Signature | Remarks
1 |  |  |  |  |  |  |  |  | C7 | manually key in
2 |  |  |  |  |  |  |  |  | J11 | manually key in
3 |  |  |  |  |  |  |  |  | D16 | Emp. No. here will be tabulated based on the training title and date above
4 |  |  |  |  |  |  |  |  | B16 | name here will be tabulated based on the training title and date above
5 |  |  |  |  |  |  |  |  | E16 | lookup value from Database sheet or Employee name
6 |  |  |  |  |  |  |  |  | B17 to B45 | list of participant attended for that date
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Ghi chép bởi
Recorded by
Spreadsheet: daren_farmer__5613__HPLN1205
Sheet: Sheet1

HPLN1205.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - December 05, 2000
 |  |  |  |  |  | **Tuesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-12-05 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL | 0 | 40
 |  | Firm Summary
Enron (S) |  | Oasis Sealy |  | HPL | 35 | 10
Enron (S) |  | Oasis Turbine |  | Enron | 5 | 0
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher