tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 273891d1382960034-countif-with-variable-range-excel-countif-answer-edited-
Sheet: Log

 |  |  | Count | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00 | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-03-01 00:00:00 | 2015-04-01 00:00:00 | 2015-05-01 00:00:00 | 2015-06-01 00:00:00 | 2015-07-01 00:00:00 | 2015-08-01 00:00:00 | 2015-09-01 00:00:00 | 2015-10-01 00:00:00 | 2015-11-01 00:00:00 | 2015-12-01 00:00:00
 |  |  |  | Met | Missed | Missed | Met | Missed
 |  |  | Objective
 |  |  | Count the number of occurrences of the word "Missed" in the five months ended with the current month
 |  |  | The current month is a variable, and is listed on the worksheet named Month, cell D6
 |  |  | Place the result in cell D7
 |  |  | No VBA
 |  |  | Considerations
 |  |  | The dates in row 6 are currently entered as the first day of each month (e.g., 10-1-13).  However, they could actually be any date in that month (e.g., 10-16-13).
 |  |  | The Month specified on the worksheet named Month currently has a value of the first day of the month (i.e., 10-1-13).  However, the date could actually be entered as any day in that month (e.g., 10-28-13)
Spreadsheet: 87460d1287352009-calling-up-data-from-drop-down-box-price-list
Sheet: Price Data

Prices |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-10-01 00:00:00
Size | Cost
30 | 10
36 | 12
40 | 14
44 | 15
50 | 18
54 | 20
60 | 26
66 | 34
70 | 60
80 | 70
Spreadsheet: darrell_schoolcraft__7297__imball0112
Sheet: Citizens

Citizens Communications
 | Measured | Scheduled | Imbalance
56659 |  | -945
500046 | -2273 | -1225 |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500086 |  |  |  |  |  |  |  |  |  |  | lunch | 7.6
500134 | -7402 | -11075
500528
500529
500619
INDEX
2001-11-30 00:00:00 |  |  | -511336.62
2001-12-08 00:00:00
CBS Volume
 |  |  | -25128
Spreadsheet: 0e26dee2-3d59-4bf4-8733-b59e20dedf48
Sheet: Introduction

worksheet's name | content
GPR | The gene, protein and reaction association of our metabolic network
MetaboliteList | All the metabolites and their information in our metabolic network
Genome annotation | All the genes and their annotations which were obtained from multiple databases,"IKU-IKReaction" in "Source" means the gene can be found in all the three databases and the gene annotation can only be found in IMG anf KEGG database
Reaction detail | All the reactions except exchange reactions and transport reactions and their detailed information including the source of information.For example, "IKU-IKReaction" in "Source1" means the gene can be found in all the three databases and the gene annotation can only be found in IMG anf KEGG database."1-1-n" in "Source2" means one gene codes only one protein and this only protein can catalyze more than one reaction."Comment" represents the remark of gene annotation
Metabolite detail | All the information of each compound, including all the elements of each metabolite in the network which can be used to automatically check whether each reaction is balanced or not
Eliminated reactions | All the Eliminated reactions which are Isolated reactions or repeated reactions and should not be included in our network
added reactions | All the reactions added to fill gaps in the reconstructed network according to some biochemical knowledge or the reconstructions of saccharomyces cerevisiae
Name merging | [NAME] with multiple names whose names were merged to only one in the network
Connection of metabolites | Connection of all the metabolites in the metabolic network
DeadEND | The dead-end metabolites and corresponding reactions
spontaneous reactions | All the spontaneous reactions added into the network
Spreadsheet: 116465d1311860019-looped-lookup-needed-resultstest110727c
Sheet: Entries

1 | Willie Eckerslyke | << copy these two formula down as far as needed til the values stop appearing.
2 | Willie Eckerslyke
3 | Willie Eckerslyke
4 | Sue Eckerslyke
5 | Sue Eckerslyke
6 | Sue Eckerslyke
7 | Sue Eckerslyke
8 | Sue Eckerslyke
9 | [NAME]
10 | [NAME]
11 | [NAME]
12 | [NAME]
13 | [NAME]
14 | [NAME]
15 | [NAME]
16 | [NAME]
 |  | <<< formulas continue, but notice they result in blank?
Spreadsheet: 772442d1647275682-not-sure-if-formula-or-code-required-drawing-data-across-sheets-with-cell-value-dependency-test-draft
Sheet: WK2

 |  |  | Hours
 | Staff
 |  |  | DAY 6 |  |  |  |  | DAY 7 |  |  |  |  | DAY 8
WEEK 2
 |  |  | MONDAY |  |  |  |  | TUESDAY |  |  |  |  | WEDNESDAY |  |  |  |  | THURSDAY |  |  |  |  | FRIDAY |  |  |  |  | SATURDAY |  |  |  |  | SUNDAY
 | Day |  | No | Start | Finish | Shift | Total | No | Start | Finish | Shift | Total | No | Start | Finish | Shift | Total | No | Start | Finish | Shift | Total | No | Start | Finish | Shift | Total | No | Start | Finish | Shift | Total | No | Start | Finish | Shift | Total
POSITION | Night | TYPE | Staff | Time | Time | Hours | Hours | Staff | Time | Time | Hours | Hours | Staff | Time | Time | Hours | Hours | Staff | Time | Time | Hours | Hours | Staff | Time | Time | Hours | Hours | Staff | Time | Time | Hours | Hours | Staff | Time | Time | Hours | Hours
 |  |  | 2 | 07:00:00 | 13:00:00
 |  |  | 1 | 07:00:00 | 13:00:00
 |  |  | 1 | 07:00:00 | 14:00:00 |  |  |  |  |  |  |  | 1 | 07:00:00 | 19:00:00
 |  |  | 4 | 07:00:00 | 14:00:00 |  |  |  |  |  |  |  | 4 | 07:00:00 | 19:00:00
 |  |  | 1 | 08:00:00 | 14:00:00 |  |  |  |  |  |  |  | 1 | 09:59:00 | 23:59:00
 |  |  | 1 | 08:00:00 | 14:00:00 |  |  | 2 | 10:00:00 | 19:00:00 |  |  | 1 | 07:00:00 | 19:00:00
 |  |  | 2 | 19:00:00 | 07:00:00 |  |  | 1 | 10:00:00 | 19:00:00 |  |  | 1 | 08:30:00 | 13:00:00
 |  |  | 1 | 19:00:00 | 07:00:00 |  |  | 1 | 12:00:00 | 19:00:00
 |  |  | 1 | 19:00:00 | 07:00:00 |  |  | 4 | 12:00:00 | 19:00:00 |  |  | 1 | 19:00:00 | 07:00:00
 |  |  | 3 | 19:00:00 | 07:00:00 |  |  |  |  |  |  |  | 2 | 19:00:00 | 07:00:00
 |  |  | 2 | 16:00:00 | 04:00:00 |  |  |  |  |  |  |  | 1 | 19:00:00 | 07:00:00
 |  |  | 4 | 08:00:00 | 16:00:00 |  |  |  |  |  |  |  | 1 | 19:00:00 | 07:00:00
 |  |  | 1 | 08:00:00 | 16:00:00 |  |  |  |  |  |  |  | 3 | 19:00:00 | 07:00:00
 |  |  | 1 | 08:00:00 | 16:00:00
 |  |  | 1 | 09:30:00 | 19:30:00 |  |  |  |  |  |  |  | 1 | 07:00:00 | 19:00:00
 |  |  | 2 | 09:30:00 | 19:30:00 |  |  | 2 | 19:00:00 | 07:00:00 |  |  | 4 | 07:00:00 | 19:00:00
 |  |  | 3 | 10:00:00 | 16:00:00 |  |  | 1 | 19:00:00 | 07:00:00 |  |  | 1 | 09:59:00 | 23:59:00
 |  |  | 1 | 10:00:00 | 18:00:00 |  |  | 1 | 19:00:00 | 07:00:00 |  |  | 1 | 07:00:00 | 19:00:00
 |  |  | 1 | 13:00:00 | 19:00:00 |  |  | 3 | 19:00:00 | 07:00:00 |  |  | 1 | 08:30:00 | 13:00:00
 |  |  | 6 | 13:00:00 | 19:00:00 |  |  | 2 | 16:00:00 | 04:00:00
 |  |  | 4 | 16:00:00 | 20:00:00 |  |  | 4 | 08:00:00 | 16:00:00 |  |  | 1 | 19:00:00 | 07:00:00
 |  |  | 1 | 16:00:00 | 20:00:00 |  |  | 1 | 08:00:00 | 16:00:00 |  |  | 2 | 19:00:00 | 07:00:00
 |  |  | 3 | 08:00:00 | 19:30:00 |  |  | 1 | 08:00:00 | 16:00:00 |  |  | 1 | 19:00:00 | 07:00:00
 |  |  |  |  |  |  |  | 1 | 09:30:00 | 19:30:00 |  |  | 1 | 19:00:00 | 07:00:00
 |  |  |  |  |  |  |  | 2 | 09:30:00 | 19:30:00 |  |  | 3 | 19:00:00 | 07:00:00
 |  |  |  |  |  |  |  | 3 | 10:00:00 | 16:00:00
 |  |  |  |  |  |  |  | 1 | 10:00:00 | 18:00:00
 |  |  |  |  |  |  |  | 1 | 13:00:00 | 19:00:00
TOTAL HOURS
TOTAL STAFF
Spreadsheet: 838151d1690789692-max-value-setting-new-microsoft-excel-worksheet
Sheet: Sheet1

 | ITEM | ITEM |  |  | AMOUNT (kg) |  |  |  |  |  |  |  | [NAME] amt | m frac
 | A | rice |  |  |  |  |  |  |  |  |  |  | 450
 | B | sugar |  |  |  |  |  |  |  |  |  |  | 4.618
 | C | flour |  |  |  |  |  |  |  |  |  |  | 4.618
 | D | oil |  |  |  |  |  |  |  |  |  |  | 1.109
 | E | tea |  |  |  |  |  |  |  |  |  |  | 1.432
 | TOTAL MASS CHARGED |  |  |  | 15000
Spreadsheet: 701987d1604030115-formula-that-refernces-resource-to-give-a-monthly-total-book2
Sheet: Sheet2

 | Resource Name | Start Date | End Date | Planned Hours Per Day
 | [NAME] | 2019-05-31 00:00:00 | 2021-06-30 00:00:00 | 0.06
 | [NAME] | 2019-05-31 00:00:00 | 2020-12-12 00:00:00 | 8
 | [NAME] | 2019-05-31 00:00:00 | 2021-06-30 00:00:00 | 0.22
 | [NAME] | 2020-11-01 00:00:00 | 2021-12-12 00:00:00 | 0.22
 | [NAME] | 2020-11-01 00:00:00 | 2021-12-12 00:00:00 | 4.5
 | [NAME] | 2020-11-01 00:00:00 | 2021-12-12 00:00:00 | 5.15
Spreadsheet: 724073d1616001264-how-to-determine-the-position-of-the-greatest-value-on-an-arbitrary-range-question
Sheet: Sheet1

408
222
403
426
432
396
390
364
364
15
400
340
600
87
600
850
600
221
600
600
300
350
19
22
400
Spreadsheet: phillip_m_love__30474__sitaratds
Sheet: Phillip Love

 | What [NAME] is approving: | Primary Approver | Alternate Approver
20668 | Sitara|Houston|Production|Central|Edit|Deal Compliance
20669 | Sitara|Houston|Production|Central|Edit|Logistics
20670 | Sitara|Houston|Production|Central|Edit|Risk Analytics
20671 | Sitara|Houston|Production|Central|Edit|Trader
20678 | Sitara|Houston|Production|Central|View Only|Settlements
22714 | TDS|Production|Central|Launchpad
22715 | TDS|Production|Central|Position Load
26381 | \\enehou\houston\common\Corporate\TRV - [Read] | [NAME] | [NAME]
26382 | \\enehou\houston\common\Corporate\TRV - [Read/Write] | [NAME] | [NAME]
28760 | \\enehou\houston\common\ERMS\1intra - [Read] | [NAME] | [NAME]
28761 | \\enehou\houston\common\ERMS\1intra - [Read/Write] | [NAME] | [NAME]
28762 | \\enehou\houston\common\ERMS\erms_adm\FIRMTRAD - [Read] | [NAME] | [NAME]
28763 | \\enehou\houston\common\ERMS\erms_adm\FIRMTRAD - [Read/Write] | [NAME] | [NAME]
Spreadsheet: 730945d1620063235-dynamic-formula-to-split-data-in-column-c-and-repeat-the-remaining-columns-split-range
Sheet: Data

Date | Company | Truck | No1 | No2 | No3 | No4 | Quantity
2021-04-01 00:00:00 | Company1 | 6578, 7496 | 20.66 | 29.51 | 4398 |  | 37.46
2021-04-01 00:00:00 | Company2 | 2951 | 20.21 | 32.35 | 4106 |  | 48.02
2021-04-01 00:00:00 | Company3 | 2971 | 16.44 | 23.76 | 4484 |  | 26.78
2021-04-01 00:00:00 | Company4 | 2473, 7416 | 18.26 | 30.33 | 4432 |  | 106.54
2021-04-01 00:00:00 | Company5 | 9241, 8162, 2493, 3697 | 22.75 | 31 | 4186 |  | 222.44
2021-04-02 00:00:00 | Company4 | 3724, 1564, 4571, 8947 | 20.51 | 29.65 | 4432 |  | 192.32
2021-04-02 00:00:00 | Company2 | 7415 | 18.85 | 34.31 | 4106 |  | 42
2021-04-02 00:00:00 | Company6 | 5312 | 25.14 | 24 | 4596 |  | 42.14
2021-04-02 00:00:00 | Company1 | 6578, 7496 | 20.39 | 30.15 | 4398 |  | 61.1
2021-04-02 00:00:00 | Company7 | 1589 | 22.71 | 29.71 | 4411 |  | 33.04
2021-04-03 00:00:00 | Company5 | 5761 | 21.87 | 31.39 | 4186 |  | 57.44
2021-04-03 00:00:00 | Company3 | 8129, 9481 | 16 | 22.85 | 4484 |  | 75.74
2021-04-03 00:00:00 | Company1 | 6578, 7496 | 20.13 | 29.15 | 4398 |  | 36.4
2021-04-04 00:00:00 | Company4 | 6741, 7492 | 20.41 | 30.45 | 4486 |  | 95.74
2021-04-04 00:00:00 | Company1 | 6578, 7496 | 21.77 | 30.18 | 4347 |  | 57.66
2021-04-04 00:00:00 | Company7 | 1589 | 22.15 | 29.71 | 4466 |  | 33
2021-04-05 00:00:00 | Company4 | 8524, 9516, 7416, 2473 | 19.61 | 30.45 | 4486 |  | 201.82
2021-04-05 00:00:00 | Company6 | 9423, 9138 | 23.21 | 23.31 | 4588 |  | 76.52
2021-04-05 00:00:00 | Company1 | 6578, 7496 | 20.17 | 29.55 | 4347 |  | 58.56
2021-04-06 00:00:00 | Company4 | 1564, 8126 | 18.55 | 30.37 | 4486 |  | 94.5
2021-04-06 00:00:00 | Company6 | 5312 | 22.11 | 26.71 | 4588 |  | 40.88
2021-04-06 00:00:00 | Company8 | 8462, 3598 | 20.89 | 29.79 | 4480 |  | 76.32
2021-04-06 00:00:00 | Company1 | 6578, 7496 | 20.31 | 28.22 | 4347 |  | 33.94
2021-04-06 00:00:00 | Company7 | 1589 | 23.94 | 29.73 | 4466 |  | 36.4
2021-04-07 00:00:00 | Company5 | 7981 | 20.16 | 31.44 | 4185 |  | 43.9
2021-04-07 00:00:00 | Company4 | 6741, 2951 | 18.84 | 30.73 | 4387 |  | 100.1
2021-04-07 00:00:00 | Company2 | 3984 | 18.19 | 33.67 | 4056 |  | 49.62
2021-04-07 00:00:00 | Company8 | 8462, 3598 | 17.71 | 28.31 | 4429 |  | 77.48
2021-04-07 00:00:00 | Company1 | 6578, 7496 | 19.55 | 28.77 | 4436 |  | 34.72
2021-04-07 00:00:00 | Company7 | 1589 | 21.18 | 29.15 | 4352 |  | 35.84
Spreadsheet: 87391d1287238676-lottery-inventory-control-in-excel-lottery
Sheet: Lottery

MONTH
BOX | $ | TOTAL | OPENING | 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
 |  | TICKETS
1 | 50 | 20 | 1 | 10 |  | 19 |  | 3
2 | 50 | 20 | 1 | 5 |  | 6 |  | 10
3 | 20 | 25 | 1 | 1 |  | 2 |  | 5
4 | 20 | 25 | 1 | 20 |  | 22 |  | 24
5 | 20 | 25 | 1 | 10 |  | 11 |  | 1
6 | 20 | 25 | 1
7 | 20 | 25 | 1
8 | 20 | 25 | 1
9 | 20 | 25 | 1
10 | 20 | 25 | 1
11 | 20 | 25 | 1
12 | 20 | 25 | 1
13 | 20 | 25 | 1
14 | 20 | 25 | 1
15 | 10 | 50 | 1
16 | 10 | 50 | 1
17 | 10 | 50 | 1
18 | 10 | 50 | 1
19 | 10 | 50 | 1
20 | 10 | 50 | 1
21 | 10 | 50 | 1
22 | 10 | 50 | 1
23 | 10 | 50 | 1
24 | 10 | 50 | 1
25 | 10 | 50 | 1
26 | 10 | 50 | 1
27 | 10 | 50 | 1
28 | 7 | 75 | 1
29 | 7 | 75 | 1
30 | 7 | 75 | 1
31 | 5 | 75 | 1
32 | 5 | 75 | 1
33 | 5 | 75 | 1
34 | 5 | 75 | 1
35 | 5 | 75 | 1
36 | 5 | 75 | 1
37 | 5 | 75 | 1
38 | 5 | 75 | 1
39 | 5 | 75 | 1
40 | 5 | 75 | 1
41 | 5 | 75 | 1
42 | 5 | 75 | 1
43 | 5 | 75 | 1
44 | 5 | 75 | 1
45 | 5 | 75 | 1
46 | 5 | 75 | 1
47 | 5 | 75 | 1
48 | 5 | 75 | 1
49 | 5 | 75 | 1
50 | 5 | 75 | 1
51 | 3 | 125 | 1
52 | 3 | 125 | 1
53 | 3 | 125 | 1
54 | 3 | 125 | 1
55 | 3 | 125 | 1
56 | 3 | 125 | 1
57 | 3 | 125 | 1
58 | 3 | 125 | 1
59 | 3 | 125 | 1
60 | 3 | 125 | 1
61 | 3 | 125 | 1
62 | 3 | 125 | 1
63 | 2 | 125 | 1
64 | 2 | 125 | 1
65 | 2 | 125 | 1
66 | 2 | 125 | 1
67 | 2 | 125 | 1
68 | 2 | 125 | 1
69 | 2 | 125 | 1
70 | 2 | 125 | 1
71 | 1 | 150 | 1
72 | 1 | 150 | 1
73 | 1 | 150 | 1
74 | 1 | 150 | 1
75 | 1 | 150 | 1
76 | 1 | 150 | 1
77 | 1 | 150 | 1
78 | 1 | 150 | 1
79 | 2 | 125 | 1
80 | 2 | 125 | 1
81 | 2 | 125 | 1
82 | 5 | 75 | 1
83
84
Manual | add
TOTAL
Spreadsheet: 8f4a7945-31de-4a24-b3ac-dc96332a476c
Sheet: Operating Costs

Service Center Calculations
Budgeted operating costs
Purpose: To detail non-salary and non-equipment costs associated with the service center services
Sheet Instructions
Fill in only the yellow highlighted areas
You may insert additional lines as necessary.
 |  | SERVICE 1 |  | SERVICE 2
Travel
Description | Annual Amt | % | Amount | % | Amount
 | 0 |  |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | Totals
 |  | SERVICE 1 |  | SERVICE 2
Operating Expenses
Description | Annual Amt | % | Amount | % | Amount
 |  | 0 |  | 0
 |  | 0 |  | 0
 |  | 0 |  | 0
 |  | 0 |  | 0
 |  | 0 |  | 0
 | Totals
 |  | SERVICE 1 |  | SERVICE 2
Equipment < $5,000*
Description | Annual Amt | % | Amount | % | Amount
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | 0 | 0 |  | 0
 | Totals
Equipment >$5,000 - See next worksheet
Spreadsheet: 40036d1238356834-countif-sin90-report
Sheet: DCI

Activity Number | Primary Resolution | Cust Acct Number | Service Duration Days | Prior Order Subtype | Prior Tech Login | Prior Tech Team
1-JYSHUSQ | ODU Peak KA/KU | 51517932 | 84 | New Install | ASGA001804 | 402 SUB DCI
1-KEZ8BFH | Cable Replace From IRD | 35729961 | 8 | New Install | ASGA001850 | 402 SUB DCI
1-KY4YVYZ | Cable Replace From IRD | 82370000 | 17 | New Install | ASGA001850 | 402 SUB DCI
1-KKLLBIB | Customer No Problem Found | 82300307 | 8 | New Install | ASGA001853 | 402 SUB DCI
1-KUB1UQX | Customer Education Other | 24488102 | 2 | Upgrade | ASGA001853 | 402 SUB DCI
1-KBNCFTT | Ground Block Replace | 57446546 | 1 | Upgrade | ASGA001856 | 402 SUB DCI
1-KGURRSD | ODU Replace 18 | 63787290 | 3 | New Install | ASGA001856 | 402 SUB DCI
1-KQKW2J6 | Cable Replace From ODU | 56391387 | 1 | Former Install | ASGA001856 | 402 SUB DCI
1-KQTO1Y6 | LNB Replace Triple LNB | 81088026 | 8 | Former Install | ASGA001856 | 402 SUB DCI
1-KWSF2BX | Customer Caused | 3040606 | 4 | Upgrade | ASGA001856 | 402 SUB DCI
1-KB11L35 | DVR 2nd Line Added | 3880241 | 1 | Upgrade | ASGA001857 | 402 SUB DCI
1-KCQ5CAC | IRD Replace HD/DVR Combo | 10639406 | 3 | Former Install | ASGA001857 | 402 SUB DCI
1-KUHH74S | Cable Replace From ODU | 57498856 | 18 | New Install | ASGA001857 | 402 SUB DCI
1-KQ8ZN7W | LNB Replace Triple LNB | 45341485 | 1 | New Install | ASGA001858 | 402 SUB DCI
1-KZ0AXUU | Repair/Replace Pole Mount | 35771789 | 15 | New Install | ASGA001858 | 402 SUB DCI | 15
Spreadsheet: 77989d1278450478-asset-matrix-example1
Sheet: Job Calendar

Job: |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat
House A |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
 |  | Framing | Framing | Framing | Framing | Framing | Framing | Framing
 |  |  |  |  | Concrete | Concrete | Concrete
 |  | 8 | 9 | 10 | 11 | 12 | 13 | 14
 |  | Framing | Framing | Framing
 |  | 15 | 16 | 17 | 18 | 19 | 20 | 21
 |  |  |  | Plumbing | Plumbing
 |  | 22 | 23 | 24 | 25 | 26 | 27 | 28
 |  | Electrical | Electrical | Electrical | Electrical | Electrical | Electrical
 |  | 29 | 30 | 31
Spreadsheet: 696042d1600568360-section-wise-summarize-the-data-into-one-sheet-from-other-work-sheets-summarize-the-data-into-one-sheet-from-multiple-work-sheets-mohammad-munawar-
Sheet: Summary

 |  |  | Section-A |  |  | Section-B |  |  | Section-C
Ref | Description | Total | Total Consumed Hrs |  | Total | Total Consumed Hrs |  | Total | Total Consumed Hrs
Number | Workdone | Qty | Man Power | Machinery | Qty | Man Power | Machinery | Qty | Man Power | Machinery
Spreadsheet: 866194d1713171060-conditional-sum-through-many-sheets-new-test
Sheet: VOY Debit Note

 | [NAME]
 | Ref no | 122
 | Debit Note Date | 2024-01-01 00:00:00
 | Bank: | Bank 3
 | Commission | 0.0125
 | Cargo loaded (mts) | 120 |  |  |  |  |  | OUR REF: |  | /
 | Freight (per ton) | 10
 |  |  |  |  |  |  |  |  |  |  |  |  | DEBIT NOTE
 |  |  |  |  |  |  |  |  | M/V |  |  | ACC |  |  | CP DD
 | Additional/Less | Description | Amount
 | Additional | BB | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | total
 |  |  |  |  |  |  |  | COMM |  |  |  |  |  |  | DUE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E. & O.E.
 |  |  |  |  |  |  |  | Please make payment to:
Spreadsheet: 2d5c1760-93b3-4c6b-8fac-ec1f04fb306f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 |  | York College
 |  | FOR ECP STAFF |  |  |  | Month/Year
 |  | EMPLOYEE NAME:
 |  | DEPT/UNIT/LOCATION:
 |  | SUPERVISOR NAME:
 |  | TIMEKEEPER NAME:
DAY OF MONTH | SICK LEAVE TAKEN (in hours) | ANNUAL LEAVE TAKEN (in hours) | UNSCHEDULED HOLIDAY LEAVE TAKEN (in hours) | OTHER LEAVE TAKEN (in hours)                 see instructions |  | Instructions
1 |  |  |  |  |  | Complete top section of form.
2
3
4 |  |  |  |  |  | If you did not work a scheduled day, enter the number of hours in the appropriate column.
5
6
7
8 |  |  |  |  |  | Sign and date the form and submit it to your supervisor for signature.  Keep a copy.
9
10
11 |  |  |  |  |  | Other Leave - please indicate the type of leave in the column:
12
13
14 |  |  |  |  |  | H - Legal Holiday
15
16 |  |  |  |  |  | JD - Jury Duty (attach documentation)
17
18
19 |  |  |  |  |  | BL- [NAME]  (attach documentation)
20
21
22 |  |  |  |  |  | ML- Military Leave
23
24 |  |  |  |  |  | LWOP - Leave Without Pay
25
26
27 |  |  |  |  |  | FMLA- Family Medical Leave (Annual)
28
29 |  |  |  |  |  | FMLS - Family Medical Leave (Sick)
30
31
TOTAL | 0 | 0 | 0
Employee Signature: |  |  | Date: | Tel: |  | If you did not take off any time this month,  please check here
Timekeeper Signature: |  |  | Date: | Tel:
Supervisor Signature: |  |  | Date: | Tel:
Spreadsheet: 116268d1311708659-excel-2007-merging-data-from-three-reports-upload-1
Sheet: Data

COMPILED REPORT RESULTS |  |  |  |  |  |  |  |  |  | SM based Utilization Data |  |  |  |  |  | Model Series Lookup
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAKE | EQUIP ID | CONTRACT | SERIAL #
TYPE | MAKE | SERIAL # | [NAME] | External | Total | Annual Util | $$/HR/12mth |  | Make | Model | Serial Nbr | Hrs per Day | Annualized |  | Make | Model | Series Code |  | THE REPORT RETURNS THESE AS BLANK |  |  |  | [NAME] | Misuse | Misuse  Wheels | Other  Service | Repair  Expenses | Scheduled  Maintenance | Shop  Repairs | Wheels/Tires /Casters | Total
 |  |  |  |  | ?? |  |  |  | RAYM | 114TM-TOW | 114-19223 | 10.665306122449 | 3892.83673469388 |  | RAYM | 114TM-TOW | TOW |  | RAYM |  | SM | 114-19223 | 0 | 0 | 0 | 0 | 0 | 305.1 | 0 | 0 | 305.1
 |  |  |  |  | ?? |  |  |  | RAYM | 840-FRE80L | 840-75069 | 7.50915750915751 | 2740.84249084249 |  | RAYM | 840-FRE80L | RIDER_PT |  |  | 4 | [NAME] | 840-75069 | 657 | 2180.67 | 303.12 | -8.85 | 1508.705 | 195 | 0 | 283.58 | 5119.225
Spreadsheet: 164615d1340819166-excel-2007-date-comparison-and-data-transfer-summary_prac
Sheet: Forecast

 | 2012-05-23 00:00:00 | 2012-05-24 00:00:00 | 2012-05-25 00:00:00 | 2012-05-28 00:00:00 | 2012-05-29 00:00:00 | 2012-05-30 00:00:00 | 2012-05-31 00:00:00 | 2012-06-01 00:00:00 | 2012-06-04 00:00:00 | 2012-06-05 00:00:00 | 2012-06-06 00:00:00 | 2012-06-07 00:00:00 | 2012-06-08 00:00:00 | 2012-06-11 00:00:00 | 2012-06-12 00:00:00 | 2012-06-13 00:00:00 | 2012-06-14 00:00:00 | 2012-06-15 00:00:00 | 2012-06-18 00:00:00 | 2012-06-19 00:00:00
Org1 | 5425 | 12414 | 1214 | 5425 | 45 | 124 | 52 | 57 | 865 | 85 | 52 | 425 | 5252 | 25235 | 52 | 52 | 32543 | 264 | 1461 | 1262
Org2 | 46 | 325 | 124 | 46 | 36 | 35 | 14 | 52 | 47 | 52 | 14 | 52 | 14 | 14 | 23525 | 14 | 456346 | 26 | 14 | 16154
Org3 | 124 | 124 | 124 | 124 | 14 | 1551 | 15 | 52 | 52 | 3 | 435 | 14 | 252 | 52 | 14 | 23525 | 1241 | 14 | 164 | 16
Org4 | 46 | 241 | 241 | 46 | 14 | 543 | 14 | 1234 | 14 | 345 | 377 | 7333 | 14 | 262 | 52 | 241 | 14 | 2461 | 621 | 14
Org5 | 124 | 123 | 141514 | 124 | 3 | 141514 | 2131 | 3 | 141514 | 2131 | 124 | 141514 | 2131 | 2131 | 3 | 141514 | 2131 | 124 | 141514 | 2131
Org6 | 124 | 123 | 124515 | 124 | 16546 | 124515 | 123 | 16546 | 124515 | 123 | 124 | 124515 | 123 | 123 | 16546 | 124515 | 123 | 124 | 124515 | 123
Org7 | 12412 | 12214 | 12314 | 12412 | 3256 | 12314 | 124 | 3256 | 12314 | 124 | 12412 | 12314 | 124 | 124 | 3256 | 12314 | 124 | 12412 | 12314 | 124
Org8 | 51 | 4 | 214 | 51 | 1526 | 214 | 151 | 1526 | 214 | 151 | 51 | 214 | 151 | 151 | 1526 | 214 | 151 | 51 | 214 | 151
Spreadsheet: 215941d1361546923-sum-values-between-two-dates-with-certain-criteria-197-test
Sheet: Sheet1

 | DATE | NAME | VALUE |  |  | GRAND TOTAL
 | 2013-02-01 00:00:00 | Orange | 1 |  |  | Apple
 | 2013-02-01 00:00:00 | Apple | 1 |  |  | Orange
 | 2013-02-15 00:00:00 | Orange | 1 |  |  | Pear
 | 2013-02-18 00:00:00 | Apple | 1
 | 2013-02-20 00:00:00 | Orange | 1 |  |  | TOTAL IN: | 2013-02-01 00:00:00
 | 2013-02-27 00:00:00 | Pear | 1 |  |  | Apple
 | 2013-02-28 00:00:00 | Apple | 1 |  |  | Orange
 | 2013-03-05 00:00:00 | Orange | 1 |  |  | Pear
 | 2013-03-10 00:00:00 | Apple | 1
 | 2013-03-15 00:00:00 | Pear | 1 |  |  | TOTAL IN: | 2013-03-01 00:00:00
 | 2013-04-01 00:00:00 | Orange | 1 |  |  | Apple
 |  |  |  |  |  | Orange
 | DATE |  |  |  |  | Pear
 | FROM | TO | TOTAL
 | 2013-02-18 00:00:00 | 2013-03-10 00:00:00 |  |  |  | TOTAL IN: | 2013-04-01 00:00:00
 |  |  |  |  |  | Apple
 |  |  |  |  |  | Orange
 |  |  |  |  |  | Pear