tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 698961d1602275145-select-the-newest-dates-sum-corresponding-rows-up-to-a-cumulative-value-in-a-3rd-column-sample-calculation-budget
Sheet: Sheet1

Employee Name | Job Num | Position Business Title | Department | Service Date | FTE | Status | Accrual Year | Accrual Proc Date | Vac Liability | Payout contracting
l | 20 | Accountant | Finance | 1991-12-08 00:00:00 | 1 | FT | 2020 | 2020-09-30 00:00:00 | 4434.39172206 | 78817.5
a | 20 | Accountant | Finance | 1997-03-31 00:00:00 | 1 | FT | 2020 | 2020-09-30 00:00:00 | 6305.4684164 | 70155
e | 20 | Accountant | Finance | 1997-08-01 00:00:00 | 1 | FT | 2020 | 2020-09-30 00:00:00 | 7694.53647634 | 72382.5
c | 20 | Accountant | Finance | 1998-10-01 00:00:00 | 1 | FT | 2020 | 2020-09-30 00:00:00 | 5629.338063150001 | 72382.5
o | 876 | Supervisor | Finance | 1998-11-06 00:00:00 | 1 | FT | 2020 | 2020-09-30 00:00:00 | 1951.589045879999 | 87952.5
q | 13 | Assistant | Finance | 2006-06-01 00:00:00 | 0.5 | FT | 2020 | 2020-09-30 00:00:00 | 1304.7608890184 | 15414.21
p | 678 | Consultant | Finance | 2011-10-17 00:00:00 | 0 | Casual | 2020 | 2020-09-30 00:00:00 | 5007.93183 | 42187.5
h | 67 | Manager | Finance | 2011-10-27 00:00:00 | 1 | FT | 2020 | 2020-09-30 00:00:00 | 7582.535274999999 | 41015.625
f | 20 | Accountant | Finance | 2013-10-25 00:00:00 | 1 | FT | 2020 | 2020-09-30 00:00:00 | 7114.30616655 | 25554.375
i | 68 | [NAME] | Finance | 2015-01-12 00:00:00 | 1 | FT | 2020 | 2020-09-30 00:00:00 | 571.459267 | 10837.5
d | 20 | Accountant | Finance | 2015-01-19 00:00:00 | 1 | FT | 2020 | 2020-09-30 00:00:00 | 4717.97161415 | 20508.375
m | 20 | Accountant | Finance | 2015-03-02 00:00:00 | 0 | Casual | 2020 | 2020-09-30 00:00:00 | 1207.78031368 | 0
b | 20 | Accountant | Finance | 2015-07-27 00:00:00 | 1 | FT | 2020 | 2020-09-30 00:00:00 | 6215.08959929 | 17320.875
k | 20 | Accountant | Finance | 2015-11-01 00:00:00 | 1 | FT | 2020 | 2020-09-30 00:00:00 | 6604.61631148 | 14449.875
j | 20 | Accountant | Finance | 2015-11-29 00:00:00 | 0.4 | PT | 2020 | 2020-09-30 00:00:00 | 96.25028459000049 | 5779.950000000001
n | 20 | Accountant | Finance | 2017-03-26 00:00:00 | 0.7 | PT | 2020 | 2020-09-30 00:00:00 | -2693.31640485 | 9195.375
g | 20 | Accountant | Finance | 2019-07-23 00:00:00 | 1 | FT | 2020 | 2020-09-30 00:00:00 | 8363.971313599997 | 8361
Spreadsheet: 482257d1474984499-urgent-numbers-as-text-formatting-nightmare-numbering-sample-for-excel-help-forum-v1
Sheet: INPUT TAB

1
Spreadsheet: 843480d1695297852-get-data-transfered-between-sheets-based-on-matching-critera-and-dates-over-45-days-test2-3-ans
Sheet: Sheet2

A |  | 2023-08-23 00:00:00 | 160623WG415 | 12 CTNS (11@200PC, 1@170PC) | PALLET # JDW3008 | 200PC |  | STOCK | WB90222
B |  | 2023-08-13 00:00:00 | 070723WGR225 | 44 CTNS(50 CTNS (49@400PC/1@200PC) LESS 6 CTNS 12/09/23) | PALLET # [NAME] | 400PC |  |  | WB90223
C |  | 2023-07-19 00:00:00 | 070723WGR250 | 41 CTNS(51 CTNS (47@600PC/2@550PC, 1@450PC,1@200PC) LESS 4 CTNS 22/08/23, 6 CTNS 12/09/23) | PALLET # [NAME] | 600PC |  |  | WB90211
D |  | 2023-06-30 00:00:00 | 060623WGR350 | 18 CTNS (17@400PC, 1@300PC) | PALLET # JDW3035 | 400PC |  |  | WB90215
E |  | 2023-09-06 00:00:00 | 290623WGR350 | 18 (17@400PC, 1@260PC) | PALLET # [NAME] | 400PC |  |  | WB90216
F
G |  | 2023-04-17 00:00:00 | 130423WGR400 | 18ctns (41 CTNS (31@400PC/7@350PC/3@300PC) less 2 ctns 24/5/23-7 ctns 01/06/23, 6 CTNS 22/08/23, 8 CTNS 30/08/23) | PALLET # [NAME] | 400PC |  |  | WB90218
H |  | 2023-08-30 00:00:00 | 200623WGR400 | 13 CTNS | PALLET # [NAME] | 400PC |  |  | WB90226
I |  | 2023-07-17 00:00:00 | 200623WGR400 | 32 CTNS (31@400PC/1@50PC) | PALLET # [NAME] | 400PC |  |  | WB90226
J
K |  | 2023-03-20 00:00:00 | 090323WG430 | 13 CTNS(15 CTNS (14@350PC/1@80PC) LESS 2 CTNS 30/08/23) | PALLET # JDW2695 | 350PC |  |  | WB90227
L
M |  | 2023-07-05 00:00:00 | 300623WGR350 | 10 CTNS (12 CTNS LESS 2 CTNS 12/09/23) | PALLET #JDW3047 | [NAME] |  |  | WB90228
N |  | 2022-11-14 00:00:00 | 101122WG350 | 10 CTNS(25 CTNS (24@300PC/1@135PC) LESS 8 CTNS 27/06/23, 6 ctns 02/08/23, 2 CTNS 30/08/23) | PALLET # JDW2356 | 300PC |  |  | WB90229
O |  | 2023-05-29 00:00:00 | 230523WGR415 | 19 CTNS(18@200PC, 1@110) | PALLET # JDW2923 | 200PC |  |  | WB90230
Spreadsheet: jeffrey_a_shankman__14000__Exhibit 14 (Scenario 6)
Sheet: ISO Charges

FORECAST OF ISO CHARGES FOR JULY 01 - JUNE 02
ASSUMPTIONS
Market price forecast based on Natsource 03/09/01 on and off peak market price assessment.
ISO ancillary services and other real time charges are proportional to market energy prices.
FORECAST DATA
MARKET PRICE in $/MWh
 | TOTAL |  | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 2001-10-01 00:00:00 | 2001-11-01 00:00:00 | 2001-12-01 00:00:00 | 2002-01-01 00:00:00 | 2002-02-01 00:00:00 | 2002-03-01 00:00:00 | 2002-04-01 00:00:00 | 2002-05-01 00:00:00 | 2002-06-01 00:00:00
ON PEAK SP15 |  |  | 360 | 500 | 285 | 212 | 192 | 164 | 159 | 120 | 110 | 100.5194365287648 | 100.9470629034491 | 143.533500567786
OFF PEAK SP15 |  |  | 160 | 195 | 155 | 119 | 111 | 120 | 71 | 74 | 72 | 62.975386326205 | 68.64763313909789 | 78.37698053469711
ISO CHARGES
AS SHARE (%) |  |  | 0.04766400211568314 | 0.04766400211568314 | 0.04766400211568314 | 0.04766400211568314 | 0.04766400211568314 | 0.04766400211568314 | 0.04766400211568314 | 0.04766400211568314 | 0.04766400211568314 | 0.04766400211568314 | 0.04766400211568314 | 0.04766400211568314
Other RT (%) |  |  | 0.01636546986828329 | 0.01636546986828329 | 0.01636546986828329 | 0.01636546986828329 | 0.01636546986828329 | 0.01636546986828329 | 0.01636546986828329 | 0.01636546986828329 | 0.01636546986828329 | 0.01636546986828329 | 0.01636546986828329 | 0.01636546986828329
ADMIN ($/MWh) |  |  | 1.14 | 1.14 | 1.14 | 1.14 | 1.14 | 1.14 | 1.14 | 1.14 | 1.14 | 1.14 | 1.14 | 1.14
SDGE BUNDLED LOAD REQUIREMENTS in MWh
LOAD (MWh) |  |  | 1578120.255036271 | 1671462.791687158 | 1568277.990482574 | 1474650.859107874 | 1375096.815231371 | 1454844.23389888 | 1445449.176985957 | 1291595.610192946 | 1414096.361422714 | 1356654.239422672 | 1410521.701001906 | 1435679.338035665
ON PEAK LOAD |  |  | 1171603.309750001 | 1250233.194109394 | 1164339.989460455 | 1100105.589228646 | 1021946.080103381 | 1073268.755347295 | 1067756.696641308 | 953831.0703107179 | 1046699.373992796 | 996409.4144026504 | 1038782.891684343 | 1064126.361351381
OFF PEAK LOAD |  |  | 406516.9452862699 | 421229.5975777642 | 403938.0010221196 | 374545.269879229 | 353150.7351279891 | 381575.4785515857 | 377692.4803446484 | 337764.539882228 | 367396.9874299182 | 360244.825020022 | 371738.8093175627 | 371552.9766842836
ISO CHARGES in K$
 |  |  | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 2001-10-01 00:00:00 | 2001-11-01 00:00:00 | 2001-12-01 00:00:00 | 2002-01-01 00:00:00 | 2002-02-01 00:00:00 | 2002-03-01 00:00:00 | 2002-04-01 00:00:00 | 2002-05-01 00:00:00 | 2002-06-01 00:00:00
AS and Other RT
Admin Fees
TOTAL
NOTE:
Admin Fees are ISO Grid [NAME].
Spreadsheet: 857163d1706205478-quick-help-with-an-if-and-formula-i-think-ambers-interview-spreadsheet
Sheet: Final Results

Candidate FN & LN | Phone | eMail | Facility | Unit | [NAME] | REQ | GHR Offer Status
 |  |  | NAMC | NICU | Lauren | 1455045 | Accepted
Spreadsheet: 871825d1718232004-text-string-added-causes-decimal-issue-tempupload2
Sheet: Sheet1

Staff Name | Start | End | Years
abc1 | 1996-11-02 00:00:00 | 2022-05-31 00:00:00
abc2 | 1999-08-02 00:00:00 | 2022-01-31 00:00:00
abc3 | 2012-07-02 00:00:00 | 2021-11-30 00:00:00
abc4 | 2015-08-01 00:00:00 | 2021-12-15 00:00:00
Spreadsheet: 799784d1665289396-counting-the-emails-that-match-another-column-while-so-matching-a-condition-in-another-example-question
Sheet: Sheet1

email | source | date
[EMAIL] | mobile | 2020-05-05 00:00:00
[EMAIL] | computer | 2020-05-05 00:00:00
[EMAIL] | computer | 2020-05-06 00:00:00
[EMAIL] | mobile | 2020-05-06 00:00:00
[EMAIL] | mobile | 2020-05-07 00:00:00
[EMAIL] | computer | 2020-05-07 00:00:00
Spreadsheet: 115257d1310894324-combine-named-ranges-unionlist
Sheet: Sheet1

List1 |  | List2 |  | List3 |  | List Count |  | List_Union |  | Data Validation
Data1 |  | Data100 |  | Data1000 |  | List1 | 7 | Data1
Data2 |  | Data101 |  | Data1001 |  | List2 | 5 | Data2
Data3 |  | Data102 |  | [NAME] |  | List3 | 8 | Data3
Data4 |  | Data103 |  | Data1003 |  |  |  | Data4
Data5 |  | Data104 |  | Data1004 |  |  |  | Data5
Data6 |  |  |  | Data1005 |  |  |  | Data6
Data7 |  |  |  | Data1006 |  |  |  | Data7
 |  |  |  | [NAME] |  |  |  | Data100
 |  |  |  |  |  |  |  | Data101
 |  |  |  |  |  |  |  | Data102
 |  |  |  |  |  |  |  | Data103
 |  |  |  |  |  |  |  | Data104
 |  |  |  |  |  |  |  | Data1000
 |  |  |  |  |  |  |  | Data1001
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Data1003
 |  |  |  |  |  |  |  | Data1004
 |  |  |  |  |  |  |  | Data1005
 |  |  |  |  |  |  |  | Data1006
 |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 755427d1636863572-help-label-a-record-depending-on-country-and-amount-sample
Sheet: CAP Exams

Val | Cntry | Category A, B, C D
20 | us
30 | us
31 | us |  |  |  | Category A: Products with a value of CAD$0 to $20 (Purchased from countires other than US or MX)
32 | us
33 | us |  |  |  | Category B: Products with a value of $0 to $40 (Purchsed from the United States or Mexico)
34 | mx
35 | mx |  |  |  | Category C: Products with a valueof CAD$40.01 to $150 (imported from the United States or Mexico)
36 | us
37 | mx
38 | ph |  |  |  | Category D: Anything not Category A, B, or C
39 | mx
40 | mx
41 | ph
42 | ph
43 | ph
100 | ph
1 | mx
2 | mx
3 | mx
4 | us
5 | ph
6 | ph
108 | ph
109 | in
110 | in
111 | in
112 | in
113 | in
115 | in
120 | in
130 | cn
135 | cn
137 | cn
139 | cn
145 | cn
142 | cn
136 | cn
136 | cn
125 | cn
149 | cn
150 | cn
151 | cn
152 | cn
153 | cn
154 | cn
155 | cn
2000 | cn
2100 | cn
2200 | mx
2300 | mx
2400 | mx
2500 | cn
2600 | cn
2700 | cn
2800 | cn
2900 | in
3000 | mx
3100 | mx
3200 | mx
3300 | in
3400 | in
3500 | in
3600 | in
3700 | in
3800 | in
3900 | in
4000 | in
Spreadsheet: 867392d1714223910-failed-if-function-pasta1
Sheet: Planilha1

 |  |  |  |  |  |  | 15000 | 15000 | 15000
 |  | 1500 | 0 | 0 | 0 | 0
 |  | 0 | 500 | 0 | 0 | 0 |  |  |  |  | How can I solve the SE formula when I don't
 |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  | there is no value in columns C and D the condition fails, the account is not realized correctly, it does not continue with the balance.
 |  | 2500 | 0 | 0 | 0 | 0 |  |  |  |  | Can you solve this problem?
 |  | 0 | 0 | 0 | 0 | 0
 |  | 3500 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0
 |  | 0 | 8000 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0 | 0
Spreadsheet: 100072d1298541959-how-to-paste-last-row-of-all-sheets-in-master-sheet-in-excel-2007-leave-record
Sheet: Harish Nainwal

GO TO MASTER PRESENT STATUS SHEET
 | Harish Nainwal  -Shot Firer - Leave Records as on Sep 30, 2009
 | Sl | Project | Dates |  | Days worked | Rotational Leave |  |  | ML
 |  |  | From | To |  | Earned | Availed | Balance
 | 1 | Mahasana / Nambar | 2006-10-10 00:00:00 | 2006-11-20 00:00:00 |  |  | 0 |  | -
 |  | Leave | 2006-11-21 00:00:00 | 2006-12-17 00:00:00 | - | - |  | -
 | 2 | [NAME] | 2006-12-18 00:00:00 | 2007-06-29 00:00:00 |  |  | - |  | -
 |  | Leave | 2007-06-30 00:00:00 | 2007-09-30 00:00:00 | - | - |  | -
 | 3 | 3D, [NAME] | 2007-10-01 00:00:00 | 2008-07-10 00:00:00 |  |  | - |  | -
 |  | Leave | 2008-07-11 00:00:00 | 2008-11-03 00:00:00 | - | - |  | -
 | 4 | [NAME] | 2008-11-04 00:00:00 | 2009-05-29 00:00:00 |  |  | -
 |  | Leave | 2009-05-30 00:00:00 | 2009-08-01 00:00:00 | - | -
 | 5 | Gujarat, IPL | 2009-08-02 00:00:00 | 2009-11-21 00:00:00 |  |  | -
 |  | Leave | 2009-11-22 00:00:00 | 2009-12-16 00:00:00 |  | - |  |  | -
 | 6 | Naftogaz - Margerita | 2009-12-17 00:00:00 | 2010-06-08 00:00:00
 |  | Leave |  | 2010-11-12 00:00:00
 | 7 | [NAME]
 | 8 | Essar - Dhimaji
Spreadsheet: 145048d1331281407-about-column-chart-818613
Sheet: 5

data | [NAME] | frquency | %
0.4747765192177438 | 0.1
0.2368296949413358 | 0.2 | 3
0.8029807100895727 | 0.3 | 1
0.4586084257227299 | 0.4 | 0
0.5260953931122121 | 0.5 | 7
0.122167220516036 | 0.6 | 2
0.4701451170543325 | 0.7 | 1
0.940842112000909 | 0.8 | 2
0.4702137045887462 | 0.9 | 3
0.4752698020103026 | 1 | 1
0.1661522285227299
0.728783673306717
0.4087543367812358
0.8115954071871174
0.8594223761163091
0.6519699014015607
0.4002621682814311
0.7215366767367675
0.5939157954989271
0.1741168973511673
Spreadsheet: 717039d1612455527-if-statement-else-move-to-the-next-cell-book2
Sheet: Sheet1

Brand Name | Type | H/A | Qty
Q | A | Z | 1
W | B | X | 2
E | C | C | 1
R | D | V | 0
T | E | B | 6
Spreadsheet: 158561d1338305831-mileage-tracking-and-charging-mothly-vehicle-expense
Sheet: Sheet1

0.52 | 5000
0.46
OCT | 1000 | 1000 |  | 520
NOV | 2000 | 3000 |  | 1040
DEC | 2050 | 5050 |  | 1063
JAN | 5000 | 10050 |  | 2300
FEB | 1000 | 11050 |  | 460
MAR | 0 | 11050 |  | 0
APR | 0 | 11050 |  | 0
MAY | 0 | 11050 |  | 0
JUN | 0 | 11050 |  | 0
JUL | 0 | 11050 |  | 0
AUG | 0 | 11050 |  | 0
SEP | 0 | 11050 |  | 0
 | 11050
Spreadsheet: 795195d1662556609-max-per-row-across-columns-with-dynamically-spilled-array-max_dynamic_array
Sheet: Sheet1

Column A | Column B | Column C | Column D | Column E | Column F |  | MAX per row
2021-03-10 11:56:36 | 2021-03-10 11:57:32 | 2021-03-10 13:10:36 | 2021-03-10 13:11:13 | 2021-03-12 11:09:45 | 2021-03-12 11:10:44
2021-03-08 12:57:12 | 2021-03-08 12:57:27 | 2021-03-08 13:51:01 | 2021-03-08 13:51:30 | 2021-03-09 08:54:10 | 2021-03-09 08:54:25
2021-03-09 13:48:46 | 2021-03-09 13:49:04 | 2021-03-09 14:51:20 | 2021-03-09 14:51:41 | 2021-03-15 13:52:19 | 2021-03-15 13:53:04
 |  | 2021-03-09 14:51:20
2020-12-18 11:20:58 | 2020-12-18 11:21:25 |  |  | 2021-01-06 10:07:26 | 2021-01-06 10:07:50
2021-01-05 09:56:43 | 2021-01-05 09:57:49 |  |  | 2021-01-05 14:40:02 | 2021-01-05 14:40:14
2020-12-22 11:26:20 | 2020-12-22 11:26:46 |  | 2021-03-09 14:51:41 | 2021-01-04 13:37:50 | 2021-01-04 13:38:11
2021-01-15 14:32:38 | 2021-01-15 14:32:57 |  |  | 2021-01-18 09:35:14 | 2021-01-18 09:35:29
2021-01-18 14:20:52 | 2021-01-18 14:21:10 |  |  | 2021-01-28 14:57:29 | 2021-01-28 14:57:47
2021-01-18 14:10:12 | 2021-01-18 14:10:31 |  |  | 2021-01-19 13:36:21 | 2021-01-19 13:36:39
 | 2021-01-18 14:10:31 |  |  | 2021-01-19 13:36:21
2020-11-30 09:39:28 | 2020-11-30 09:39:49 |  |  | 2020-12-02 16:12:24 | 2020-12-02 16:13:14
2020-12-01 07:51:30 | 2020-12-01 07:55:06 |  |  | 2020-12-03 10:23:10 | 2020-12-03 10:26:39
2020-12-11 13:32:24 | 2020-12-11 13:34:39 | 2021-03-08 13:51:01 |  | 2020-12-15 16:35:08 | 2020-12-15 16:39:09
2020-12-14 09:36:06 | 2020-12-14 09:36:26 |  |  | 2020-12-15 12:18:20 | 2020-12-15 12:19:59
2021-01-08 12:06:33 | 2021-01-08 12:06:55 |  |  | 2021-01-11 15:08:13 | 2021-01-11 15:08:35
2021-01-05 11:52:15 | 2021-01-05 11:52:59 |  |  | 2021-01-08 13:45:54 | 2021-01-08 13:46:57
2021-01-06 13:21:40 | 2021-01-06 13:22:02 |  |  | 2021-01-07 15:48:36 | 2021-01-07 15:49:34
2020-12-02 08:02:15 | 2020-12-02 08:02:41 |  |  | 2020-12-07 12:54:46 | 2020-12-07 12:55:25
Spreadsheet: 88002d1287890722-help-with-running-7-day-count-goals-2
Sheet: Fuel

fuel | wednesday | thursday | friday | saturday | sunday | monday | tuesday | total | wkly variance
week 1 | 4788 | 6105 | 6658 | 5875 | 6608 | 8985 | 5445 | 44464 | -1806 |  | 1 | 4788
week 2 | 6802 | 6608 | 6698 | 8502 | 6610 | 7524 | 4878 | 47622 | 1352 |  | 2 | 6105
week 3 | 5895 | 5847 | 6608 | 6608 | 6610 | 5586 | 6689 | 43843 | -2427 |  | 3 | 6658
week 4 | 6745 | 6955 | 6612 | 7000 | 7000 |  |  | 34312 | 1262 |  | 4 | 5875
week 5 |  |  |  |  |  |  |  | 0 | 0 |  | 5 | 6608
 |  |  |  |  | daily goal | 6610 | month total | 170241 |  |  | 6 | 8985
 |  |  |  |  | weekly goal | 46270 | actual mth goal | 171860 |  |  | 7 | 5445
 |  |  |  |  | monthly goal | 185080 | month variance | -1619 |  |  | 8 | 6802
 |  |  |  |  |  |  | 7 day total | 46197 |  |  | 9 | 6608
 |  |  |  |  |  |  | 7 day variance |  |  |  | 10 | 6698
 |  |  |  |  |  |  |  |  |  |  | 11 | 8502
 |  |  |  |  |  |  |  |  |  |  | 12 | 6610
 |  |  |  |  |  |  |  |  |  |  | 13 | 7524
 |  |  |  |  |  |  |  |  |  |  | 14 | 4878
 |  |  |  |  |  |  |  |  |  |  | 15 | 5895
 |  |  |  |  |  |  |  |  |  |  | 16 | 5847
 |  |  |  |  |  |  |  |  |  |  | 17 | 6608
 |  |  |  |  |  |  |  |  |  |  | 18 | 6608
 |  |  |  |  |  |  |  |  |  |  | 19 | 6610
 |  |  |  |  |  |  |  |  |  |  | 20 | 5586
 |  |  |  |  |  |  |  |  |  |  | 21 | 6689
 |  |  |  |  |  |  |  |  |  |  | 22 | 6745
 |  |  |  |  |  |  |  |  |  |  | 23 | 6955
 |  |  |  |  |  |  |  |  |  |  | 24 | 6612
 |  |  |  |  |  |  |  |  |  |  | 25 | 7000
 |  |  |  |  |  |  |  |  |  |  | 26 | 7000
 |  |  |  |  |  |  |  |  |  |  | 27 | 0
 |  |  |  |  |  |  |  |  |  |  | 28 | 0
 |  |  |  |  |  |  |  |  |  |  | 29 | 0
 |  |  |  |  |  |  |  |  |  |  | 30 | 0
 |  |  |  |  |  |  |  |  |  |  | 31 | 0
 |  |  |  |  |  |  |  |  |  |  | 32 | 0
 |  |  |  |  |  |  |  |  |  |  | 33 | 0
 |  |  |  |  |  |  |  |  |  |  | 34 | 0
 |  |  |  |  |  |  |  |  |  |  | 35 | 0
Spreadsheet: 464065d1464865239-drop-down-list-sum-function-fuel-test-sheet
Sheet: Sheet1

 |  | Vehicle Fuel Mileage Log
 | Vehicle | Fuel | [NAME] | Hours |  |  |  |  |  |  |  | Vehicles
 | Engine 12 | 7 | 23 | 12 |  |  |  |  |  |  |  | Crash 4
 | Crash 4 | 9 | 12 | 12 |  |  |  |  |  |  |  | Crash 5
 | Crash 4 | 12.8 | 23 | 34 |  |  |  |  |  |  |  | Engine 9
 | Crash 5 | 12.8 | 4 | 2 |  |  |  |  |  |  |  | Engine 12
 | Engine 12 | 54 | 78 | 45 |  |  |  |  |  |  |  | Rescue 10
 | Tanker 6 | 36 | 87 | 12 |  |  |  |  |  |  |  | Brush 7
 | Engine 9 | 55 | 6 | 36 |  |  |  |  |  |  |  | Tanker 6
 | Crash 4 | 23 | 21 | 23
 |  |  | Total Fuel:
 |  |  | Engine 12: | Fuel:
 |  |  |  | Hours:
 |  |  |  | [NAME]:
 |  |  | Crash 4: | Fuel:
 |  |  |  | Hours:
 |  |  |  | [NAME]:
Spreadsheet: 835329d1688500210-seating-chart-test_2023
Sheet: Seating Chart

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Table 1 | Table 2 | Table 3 | Table 4 | Table 5 | Table 6 | Table 7 | Table 8 | Table 9 | Table 10 | Table 11 | Table 12 | Table 13 | Table 14 | Table 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Table 16 | Table 17 | Table 18 | Table 19 | Table 20 | Table 21 | Table 22 | Table 23 | Table 24 | Table 25 | Table 26 | Table 27 | Table 28 | Table 29 | Table 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Table 31 | Table 32 | Table 33 | Table 34 | Table 35 | Table 36 | Table 37 | Table 38 | Table 39 | Table 40 | Table 41 | Table 42 | Table 43 | Table 44 | Table 45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Chart
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: 035c5730-9f62-41b6-bb86-becfd539f2c6
Sheet: Sheet1

PLEASE RETURN THE COMPLETED FORM TO: | Unnamed: 1
[NAME] (+44 1925 86 4206) e-mail ([EMAIL])
YOUR NAME
NARRATIVE | DITANET Advanced Skills School
CUSTOMER ID or STUDENT ID | DITANET
INVOICE NUMBER or                          ACCOUNT CODE & COST CENTRE | [NAME]
DEPT 1 (Rolled out depts only, if reqd) | CONFINCOM
DEPT 2 (Rolled out depts only, if reqd) | DITA
CARDHOLDER NAME
CARD TYPE (eg VISA, AMEX etc.)
CREDIT or DEBIT CARD NUMBER
EXPIRY DATE
START DATE (if available)
ISSUE NUMBER (if available)
CVC NUMBER
(Last 3 digits on back of card)
HOUSE NUMBER - UK cards only -
Must be statement address
POSTCODE - UK cards only -
Must be statement address
PLEASE POST RECEIPT TO:
TOTAL AMOUNT £
CONTACT TELEPHONE NUMBER
FOR OFFICIAL USE ONLY
DATE OF TELEPHONE CALL
TIME OF TELEPHONE CALL
INFORMATION TAKEN BY
Spreadsheet: 824593d1680700129-how-to-populate-a-list-without-gaps-based-on-criteria-sheet_alvpin
Sheet: BASE

ID | Employee | Team
212456 | [NAME] | 1
221636 | Sophie | 1
447952 | [NAME] | 2
454555 | [NAME] | 3
560725 | [NAME] | 1
609511 | [NAME] | 1
652188 | Serge | 1
652368 | [NAME] | 2
656874 | Georges | 1
658519 | Lili | 2
707757 | [NAME] | 2
732990 | [NAME] | 3
785889 | [NAME] | 1
824227 | [NAME] | 1
945636 | [NAME] | 2
Spreadsheet: 329042d1404177046-vlookup-between-two-sheets-including-entire-row-fmsonline-wip
Sheet: May

 |  | Reading and Sales
 |  | Date |  | Unleaded |  | *Inches |  | Premium |  |  |  |  | Diesel
 |  |  |  | Reading* | Gallons | Sales |  | Reading* | Gallons | Plus Sales | [NAME]. Sales |  | Reading* | Gallons | Sales
 |  | 2014-05-01 00:00:00 |  | 82.75 |  |  |  | 36.75 |  |  |  |  | 24.5
 |  | 2014-05-02 00:00:00 |  | 69.25 |  |  |  | 36 |  |  |  |  | 22
 |  | 2014-05-03 00:00:00 |  | 56.5 |  |  |  | 35 |  |  |  |  | 21
 |  | 2014-05-04 00:00:00 |  | 39.5 |  |  |  | 33 |  |  |  |  | 19
 |  | 2014-05-05 00:00:00 |  | 14.75 |  |  |  | 31.75 |  |  |  |  | 16.75
 |  | 2014-05-06 00:00:00 |  | 92.5 |  |  |  | 31 |  |  |  |  | 34
 |  | 2014-05-07 00:00:00 |  | 82.5 |  |  |  | 30 |  |  |  |  | 32
 |  | 2014-05-08 00:00:00 |  | 70.5 |  |  |  | 29.5 |  |  |  |  | 29.5
 |  | 2014-05-09 00:00:00 |  | 59 |  |  |  | 28.5 |  |  |  |  | 28.5
 |  | 2014-05-10 00:00:00 |  | 43.5 |  |  |  | 27 |  |  |  |  | 26.75
 |  | 2014-05-11 00:00:00 |  | 27.75 |  |  |  | 26 |  |  |  |  | 25.75
 |  | 2014-05-12 00:00:00 |  | 87 |  |  |  | 32 |  |  |  |  | 35.75
 |  | 2014-05-13 00:00:00 |  | 76.5 |  |  |  | 31.75 |  |  |  |  | 34.75
 |  | 2014-05-14 00:00:00 |  | 59 |  |  |  | 31.5 |  |  |  |  | 33
 |  | 2014-05-15 00:00:00 |  | 33.25 |  |  |  | 30.5 |  |  |  |  | 30.5
 |  | 2014-05-16 00:00:00 |  | 90.75 |  |  |  | 36 |  |  |  |  | 38
 |  | 2014-05-17 00:00:00 |  | 52.5 |  |  |  | 34.75 |  |  |  |  | 36
 |  | 2014-05-18 00:00:00 |  | 21.5 |  |  |  | 32.5 |  |  |  |  | 34.5
 |  | 2014-05-19 00:00:00 |  | 64.75 |  |  |  | 36 |  |  |  |  | 40.25
 |  | 2014-05-20 00:00:00 |  | 42 |  |  |  | 34.75 |  |  |  |  | 39
 |  | 2014-05-21 00:00:00 |  | 17.5 |  |  |  | 33 |  |  |  |  | 37.5
 |  | 2014-05-22 00:00:00 |  | 72 |  |  |  | 36.75 |  |  |  |  | 36.25
 |  | 2014-05-23 00:00:00 |  | 41.5 |  |  |  | 36 |  |  |  |  | 34
 |  | 2014-05-24 00:00:00 |  | 90.25 |  |  |  | 39.25 |  |  |  |  | 36.5
 |  | 2014-05-25 00:00:00 |  | 41.5 |  |  |  | 36 |  |  |  |  | 34.75
 |  | 2014-05-26 00:00:00 |  | 4.5 |  |  |  | 31 |  |  |  |  | 33.25
 |  | 2014-05-27 00:00:00 |  | 56.25 |  |  |  | 38 |  |  |  |  | 32.75
 |  | 2014-05-28 00:00:00 |  | 38.75 |  |  |  | 37.5 |  |  |  |  | 30.5
 |  | 2014-05-29 00:00:00 |  | 27.25 |  |  |  | 37 |  |  |  |  | 28.25
 |  | 2014-05-30 00:00:00 |  | 89.75 |  |  |  | 41.5 |  |  |  |  | 33.5
 |  | 2014-05-31 00:00:00 |  | 72.5 |  |  |  | 39.5 |  |  |  |  | 30.5
 |  | *Inches