tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 64489d1265322460-problems-with-distributions-716814-distributions
Sheet: Sales Timing

 |  |  |  |  |  | Units | 100
 |  |  |  |  |  | [NAME] | 2011-03-01 00:00:00
 |  |  |  |  |  | Sales End | 2012-03-01 00:00:00
 |  |  |  |  |  | Months | 13
Sale Trend | Parameters |  |  |  | Units Sold | Month | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00
 |  |  |  |  |  | Sale Month | 0 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Flat | Sales/Month | 7.692307692307693 |  |  | 100 | Units Sold | 0 | 0 | 8 | 7 | 8 | 8 | 7 | 8 | 8 | 8 | 7 | 8 | 8 | 7 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Normal | Deviation | 3 | Factor | 1.031204538080703 | 99.99999999999999 | [NAME] | 0 | 0 | 1.881573704639707 | 3.44738830381688 | 5.657734975182959 | 8.317270575548305 | 10.95233654702583 | 12.91878904019257 | 13.64981370718749 | 12.91878904019257 | 10.95233654702583 | 8.317270575548305 | 5.657734975182959 | 3.44738830381688 | 1.881573704639707 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 100 | Whole Units | 0 | 0 | 2 | 3 | 6 | 8 | 11 | 13 | 14 | 13 | 11 | 8 | 6 | 3 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 115271d1310910354-excel-2007-need-help-with-summing-up-the-data-in-sheet-sales-summary
Sheet: July

MONTHLY SALES DATA SHEET - JULY
CITY | PROD. | 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 | TOTAL
HOUSTON | SHOES
 | SHIRTS
 | PANTS
 | SOCKS
DALLAS | SHOES
 | SHIRTS
 | PANTS
 | SOCKS
AUSTIN | SHOES
 | SHIRTS
 | PANTS
 | SOCKS
Spreadsheet: 292328d1390565815-compare-data-on-two-tabs-and-populate-diffrences-on-new-tab-book6
Sheet: Old

Request Number | Code | Date | Test No
12-0050 | 1234 | 2013-12-20 00:00:00 | 1
12-0051 | 2222 | 2013-12-21 00:00:00 | 547
12-0052 | 6745 | 2012-05-05 00:00:00 | 22
12-0053 | 6969 | 2012-05-06 00:00:00 | 4
12-0053 | 6969 | 2012-05-07 00:00:00 | 4
12-0054 | 6423 | 2013-12-24 00:00:00 | 3
12-0055 | 6423 | 2013-12-25 00:00:00 | 65
12-0055 | 6423 | 2013-12-26 00:00:00 | 65
12-0056 | 6423 | 2013-12-26 00:00:00 | 5
12-0057 | 5432 | 2013-12-27 00:00:00 | 67
12-0058 | 6423 | 2013-12-28 00:00:00 | 4
12-0058 | 6423 | 2013-12-29 00:00:00 | 5
12-0059 | 8765 | 2012-05-05 00:00:00 | 5
12-0060 | 5432 | 2012-05-06 00:00:00 | 45
12-0061 | 8765 | 2012-05-07 00:00:00 | 765
12-0062 | 8768 | 2012-05-08 00:00:00 | 765
12-0062 | 8765 | 2012-05-08 00:00:00 | 45
12-0063 | 6423 | 2012-05-09 00:00:00 | 235
12-0064 | 6423 | 2012-05-10 00:00:00 | 235
12-0064 | 6423 | 2012-05-05 00:00:00 | 654
12-0065 | 5432 | 2012-05-06 00:00:00 | 34
12-0065 | 6423 | 2014-01-05 00:00:00 | 764
12-0065 | 5432 | 2014-01-06 00:00:00 | 34
12-0066 | 5432 | 2014-01-07 00:00:00 | 65
Spreadsheet: 48571d1247800479-double-lookup-file
Sheet: Sheet1

ID | Product 1 | Product 2 | Product 3 | Product 4 | Product 5 | … | Top 1 | Top 2 | Top 3
1 | 1 | 3 | 2 | 0 | 4 | … | Product 5 | Product 2 | Product 3
2 | 2 | 4 | 6 | 3 | 1 | … | Product 3 | Product 2 | Product 4
3 | 5 | 12 | 2 | 1 | 4 | … | Product 12 | Product 1 | Product 5
Spreadsheet: 07dbb25d-0c90-4920-bf91-06d3adf0d163
Sheet: Sheet1

State of New Hampshire - General Election | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
2012-11-06 00:00:00 | State Senate District 19
 | [NAME], r | [NAME], d | [NAME]
[NAME] | 8056 | 6416 | 3
Hampstead | 3016 | 1663 | 6
Windham | 4855 | 2394 | 4
Totals | 15927 | 10473 | 13
 | State Senate District 20
 | [NAME], r | [NAME], d | [NAME]
Goffstown | 3555 | 4947 | 6
[NAME] 3 | 780 | 1789 | 5
[NAME] | 1008 | 2147
[NAME] 10 | 1392 | 2506 | 4
[NAME] 11 | 1019 | 1875 | 7
Totals | 7754 | 13264 | 22
 | State Senate District 21
 | [NAME], r | [NAME], d | [NAME]
[NAME] | 1819 | 4514 | 15
[NAME] | 696 | 1690 | 5
Madbury | 399 | 711
Newfields | 471 | 531
Newington | 265 | 252 | 3
Newmarket | 1570 | 3193 | 4
Portsmouth Ward 1 | 667 | 1768 | 4
Portsmouth Ward 2 | 632 | 2202 | 6
Portsmouth Ward 3 | 702 | 1635 | 2
Portsmouth Ward 4 | 772 | 1389 | 3
Portsmouth Ward 5 | 681 | 1855
Totals | 8674 | 19740 | 42
Spreadsheet: 840735d1692947302-formula-needed-for-different-price-when-brought-at-different-qty-book2
Sheet: Sheet1

No of apple | Price | Average Price |  |  |  |  |  |  | Manual Trial & Error |  | [NAME] | Apple Left
1 | 6 |  |  |  |  |  |  | No of apple | Multiple | Amount
3 | 17 |  |  |  | No of Apples | 87 |  |  | 7
5 | 25 |  |  |  | Price | ??????? |  |  | 0
12 | 55 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | Total Price
 |  |  |  |  |  |  |  | Is it possible to compute in a single formula?
Spreadsheet: 9ed6f041-bcf6-4f0a-9585-c40ddf66d4cd
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
CAS | Test | CAS | Calcium, Total, Serum | Calcium, Total, S | Photometric, O-Cresolphthalein | Serum Gel Tube: SGT |  |  | 0.5 | mL | Collection Container/Tube:  Preferred: Serum gel Acceptable: Red top Submission Container/Tube: Plastic vial [NAME]: 0.5 mL Collection Instructions: If drawing for more than calcium, total, send first tube drawn. Additional Information: Patient's age and sex are required. | 0.25 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | Males 1-14 years: 9.6-10.6 mg/dL 15-16 years: 9.5-10.5 mg/dL 17-18 years: 9.5-10.4 mg/dL 19-21 years: 9.3-10.3 mg/dL > or =22 years: 8.9-10.1 mg/dL Reference values have not been established for patients who are <12 months of age. Females 1-11 years: 9.6-10.6 mg/dL 12-14 years: 9.5-10.4 mg/dL 15-18 years: 9.1-10.3 mg/dL > or =19 years: 8.9-10.1 mg/dL Reference values have not been established for patients who are <12 months of age. | Monday through Sunday; Continuously | Same day/1 day | 2 days | 1 | 82310 |  |  |  |  | Rochester
CAS | [NAME] | SERUM | Serum |  |  |  | Frozen | 21 days
CAS | Result | CA | Calcium, Total, S | Calcium, Total, S | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 17861-6
Spreadsheet: 66644d1267274989-countif-pivot-table-and-pivot-chart-based-on-data-countif
Sheet: Sheet1

Salary | Dept
10941 | ACCOUNTS |  | Salary Between | Department
15661 | ACCOUNTS |  | 0-5000 | Accounts | 0
16470 | ACCOUNTS |  | 5001-1000 | Accounts | 0
19935 | ACCOUNTS
28309 | ACCOUNTS
34950 | ACCOUNTS
9844 | ACCOUNTS
16701 | ACCOUNTS
44421 | ACCOUNTS
42342 | ACCOUNTS
34950 | ACCOUNTS
34950 | ACCOUNTS
6453 | ACCOUNTS
6824 | ACCOUNTS
6963 | ACCOUNTS
7240 | ACCOUNTS
7378 | ACCOUNTS
7771 | ACCOUNTS
7771 | ACCOUNTS
7771 | ACCOUNTS
7771 | ACCOUNTS
7771 | ACCOUNTS
7771 | ACCOUNTS
8285 | ACCOUNTS
8458 | ACCOUNTS
8631 | ACCOUNTS
8805 | ACCOUNTS
8978 | ACCOUNTS
8978 | ACCOUNTS
9151 | ACCOUNTS
9151 | ACCOUNTS
9498 | ACCOUNTS
9498 | ACCOUNTS
9498 | ACCOUNTS
9844 | ACCOUNTS
10017 | ACCOUNTS
10017 | ACCOUNTS
10249 | ACCOUNTS
10249 | ACCOUNTS
10249 | ACCOUNTS
10249 | ACCOUNTS
10479 | ACCOUNTS
10595 | ACCOUNTS
10595 | ACCOUNTS
10595 | ACCOUNTS
10711 | ACCOUNTS
10941 | ACCOUNTS
11288 | ACCOUNTS
11519 | ACCOUNTS
11750 | ACCOUNTS
11750 | ACCOUNTS
11750 | ACCOUNTS
11750 | ACCOUNTS
11865 | ACCOUNTS
11981 | ACCOUNTS
12443 | ACCOUNTS
12443 | ACCOUNTS
12674 | ACCOUNTS
13251 | ACCOUNTS
13483 | ACCOUNTS
13598 | ACCOUNTS
13598 | ACCOUNTS
13598 | ACCOUNTS
13598 | ACCOUNTS
14175 | ACCOUNTS
14291 | ACCOUNTS
14522 | ACCOUNTS
14522 | ACCOUNTS
14869 | ACCOUNTS
14869 | ACCOUNTS
15315 | ACCOUNTS
15315 | ACCOUNTS
15315 | ACCOUNTS
15661 | ACCOUNTS
15661 | ACCOUNTS
15661 | ACCOUNTS
15661 | ACCOUNTS
15661 | ACCOUNTS
16008 | ACCOUNTS
16008 | ACCOUNTS
16008 | ACCOUNTS
16470 | ACCOUNTS
16701 | ACCOUNTS
16701 | ACCOUNTS
16932 | ACCOUNTS
16932 | ACCOUNTS
17394 | ACCOUNTS
17394 | ACCOUNTS
17625 | ACCOUNTS
18087 | ACCOUNTS
18087 | ACCOUNTS
18549 | ACCOUNTS
19011 | ACCOUNTS
19011 | ACCOUNTS
19935 | ACCOUNTS
19935 | ACCOUNTS
19935 | ACCOUNTS
19935 | ACCOUNTS
20513 | ACCOUNTS
20513 | ACCOUNTS
21667 | ACCOUNTS
22245 | ACCOUNTS
22245 | ACCOUNTS
22823 | ACCOUNTS
22823 | ACCOUNTS
23400 | ACCOUNTS
23400 | ACCOUNTS
25133 | ACCOUNTS
25652 | ACCOUNTS
26403 | ACCOUNTS
27038 | ACCOUNTS
28655 | ACCOUNTS
29753 | ACCOUNTS
30907 | ACCOUNTS
35816 | ACCOUNTS
36683 | ACCOUNTS
37549 | ACCOUNTS
38877 | ACCOUNTS
39801 | ACCOUNTS
Spreadsheet: 120891d1315607378-complex-data-reorganization-question-sample-problem
Sheet: Sheet1

What I have now:
 | z | y | w | v | u
a |  | x | x |  | x
b | x |  |  | x
c |  |  | x
d |  |  |  | x
e |  | x
f | x |  |  | x
g |  | x | x
h |  |  |  |  | x
What I want to automate: the header of every 'x' cell in a column ends up next to the leader of the appropriate row.
Each row header would end up on a separate line with its row leader mate. See below:
a | y
a | w
a | u
b | z
b | v
c | w
d | v
e | y
f | z
f | v
g | y
g | w
h | u
Is it possible to extract the data this way?
Spreadsheet: 678732d1590043671-exact-if-not-formula-for-weight-weight-formula
Sheet: WEIGHT

Total weight (KGs) | OUTPUT FORMULA
410 | 201 to 500 Kg
410 | 201 to 500 Kg
140 | 101 to 200 Kg
60 | 51 to 100 Kg
60 | 51 to 100 Kg
40 | Up to 50 Kg
140 | 101 to 200 Kg
430 | 201 to 500 Kg
488 | 201 to 500 Kg
140 | 101 to 200 Kg
410 | 201 to 500 Kg
330 | 201 to 500 Kg
180 | 101 to 200 Kg
100 | 51 to 100 Kg
150 | 101 to 200 Kg
453 | 201 to 500 Kg
150 | 101 to 200 Kg
490 | 201 to 500 Kg
300 | 201 to 500 Kg
200 | 101 to 200 Kg
500 | 201 to 500 Kg
400 | 201 to 500 Kg
500 | 201 to 500 Kg
200 | 101 to 200 Kg
830 | 501 to 1000 Kg
650 | 501 to 1000 Kg
780 | 501 to 1000 Kg
910 | 501 to 1000 Kg
1050 | 1001 to 2000 Kg
1500 | 1001 to 2000 Kg
1200 | 1001 to 2000 Kg
1658 | 1001 to 2000 Kg
1980 | 1001 to 2000 Kg
2050 | 2001 to 3000 Kg
2305 | 2001 to 3000 Kg
2854 | 2001 to 3000 Kg
2950 | 2001 to 3000 Kg
2760 | 2001 to 3000 Kg
2500 | 2001 to 3000 Kg
Spreadsheet: 683072d1592475119-how-to-combine-2-separate-if-statements-with-different-outcomes-please-help
Sheet: Sheet1

FX rate: | 1.4
Product | Currency | Adjustment | Amount | Final Amount
Product 1 | USD | 1 | 100000
Product 1 | SGD | 0.75 | 100000
Product 2 | USD | N/A | 100000
Product 2 | SGD | N/A | 100000
Spreadsheet: 268094d1380433811-need-to-search-array-and-return-value-along-with-title-and-row-values-book32-as-an-example
Sheet: Sheet1

 | 2013-09-09 00:00:00 | 2013-09-10 00:00:00 | 2013-09-11 00:00:00 | 2013-09-12 00:00:00 | 2013-09-13 00:00:00 | 2013-09-14 00:00:00 | 2013-09-15 00:00:00 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Midnight - 2:00 | 12.20689655172414 |  | 7.741935483870968 | 16.60869565217391 | 10.17241379310345 | 7.708333333333333 | 11.45454545454546
02:00:00 | 10.3448275862069 |  | 8.6 | 16.03333333333333 | 8.68 | 5.826086956521739 | 11
04:00:00 | 11 |  | 8.92 | 13.95833333333333 | 8.766666666666667 | 7.3 |  |  | What I want to see in J3 is Wed, 9/11/13 14:00
06:00:00 | 10.03571428571429 |  | 9.344827586206897 | 15.14814814814815 | 8.068965517241379 | 7.033333333333333 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
08:00:00 | 15.18181818181818 | 11 | 16.57142857142857 | 19.44 | 13.15384615384615 | 12.4 | 10.73333333333333
10:00:00 | 20.53846153846154 | 18.69230769230769 | 23.38461538461538 | 23.48387096774194 | 20.2 | 13.78571428571429 | 12.14705882352941
12:00:00 | 19.46428571428572 | 15.54838709677419 | 28.8 | 25.14285714285714 | 19.26923076923077 | 12.28571428571429 | 8.703703703703704 |  | What I want to see in J3 is Wed, 9/14/13 02:00
14:00:00 | 15.38888888888889 | 15.55555555555556 | 30.8 | 24.53846153846154 | 20.55555555555556 | 11.33333333333333 | 6.285714285714286
16:00:00 | 13.8 | 16.92 | 26.76923076923077 | 8.666666666666666 | 14.46428571428571 | 9.724137931034482 | 7.714285714285714
18:00:00 | 12 | 13.5 | 19.18518518518519 | 12.86111111111111 | 11.06896551724138 | 8.08 | 15.17857142857143
20:00:00 | 11.46153846153846 | 12.09090909090909 | 20.34615384615385 | 13.93333333333333 | 15.28 | 10.11538461538461 | 9.9375
22:00:00 | 12 | 8.75 | 20.80769230769231 | 11.69444444444444 | 14.5 | 12.18181818181818 | 8.923076923076923
Spreadsheet: 704420d1605542020-detect-the-patients-who-returned-to-the-emergency-room-within-24-hours-sample-9-
Sheet:      DATA    

Patient ID | Date of ER Visit | Registration Time | Discharge Time | Returned to ER within 24 hrs
333976 | 2020-10-04 00:00:00 | 23:15:00 | 03:20:00
333976 | 2020-10-06 00:00:00 | 11:55:00 | 14:05:00
1666556 | 2020-10-16 00:00:00 | 16:50:00 | 21:45:00
1666556 | 2020-10-19 00:00:00 | 01:33:00 | 03:00:00
2373667 | 2020-10-19 00:00:00 | 20:10:00 | 23:35:00
2373667 | 2020-10-27 00:00:00 | 08:30:00 | 10:25:00
2656676 | 2020-10-11 00:00:00 | 03:06:00 | 04:35:00
2656676 | 2020-10-26 00:00:00 | 23:55:00 | 02:25:00
3168166 | 2020-10-07 00:00:00 | 15:45:00 | 17:55:00
3168166 | 2020-10-07 00:00:00 | 23:20:00 | 07:10:00
3195176 | 2020-10-31 00:00:00 | 07:20:00 | 10:35:00
3195176 | 2020-10-31 00:00:00 | 07:20:00 | 10:35:00
3262899 | 2020-10-04 00:00:00 | 23:30:00 | 02:35:00
3262899 | 2020-10-06 00:00:00 | 08:30:00 | 11:35:00
3267867 | 2020-10-08 00:00:00 | 19:13:00 | 21:10:00
3267867 | 2020-10-08 00:00:00 | 20:40:00 | 22:05:00
3267867 | 2020-10-13 00:00:00 | 11:15:00 | 12:35:00
3291800 | 2020-10-15 00:00:00 | 14:30:00 | 22:20:00
3291800 | 2020-10-17 00:00:00 | 23:35:00 | 15:00:00
3344749 | 2020-10-13 00:00:00 | 08:40:00 | 10:25:00
3344749 | 2020-10-18 00:00:00 | 00:45:00 | 18:00:00
3439286 | 2020-10-07 00:00:00 | 12:20:00 | 21:05:00
3439286 | 2020-10-09 00:00:00 | 11:09:00 | 12:55:00
3439286 | 2020-10-10 00:00:00 | 00:37:00 | 08:00:00
3439553 | 2020-10-02 00:00:00 | 15:25:00 | 18:50:00
3439553 | 2020-10-05 00:00:00 | 19:43:00 | 09:30:00
3439555 | 2020-10-08 00:00:00 | 19:22:00 | 20:40:00
3439555 | 2020-10-10 00:00:00 | 07:15:00 | 14:50:00
3444488 | 2020-10-02 00:00:00 | 11:00:00 | 13:05:00
3444488 | 2020-10-03 00:00:00 | 21:41:00 | 01:30:00
5577897 | 2020-10-17 00:00:00 | 08:20:00 | 08:50:00
5577897 | 2020-10-25 00:00:00 | 09:15:00 | 11:05:00
5767686 | 2020-10-02 00:00:00 | 18:13:00 | 18:35:00
5767686 | 2020-10-04 00:00:00 | 09:07:00 | 09:40:00
8446699 | 2020-10-11 00:00:00 | 06:20:00 | 08:05:00
8446699 | 2020-10-12 00:00:00 | 21:04:00 | 23:20:00
8446699 | 2020-10-18 00:00:00 | 06:25:00 | 07:00:00
Spreadsheet: 836207d1689170472-get-the-correct-unit-price-per-price-breaks-needed-book1
Sheet: Sheet1

 | Min Buy Qty
Part | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 9 | 10 | 11 | 12 | 13 | 15 | 16 | 17 | 18 | 20 | 21 | 23 | 24 | 25 | 28 | 29 | 30 | 31 | 33 | 34 | 35 | 40 | 41 | 43 | 45 | 47 | 50 | 51 | 52 | 60 | 61 | 67 | 70 | 79 | 93 | 100 | 120 | 139 | 163 | 235 | 330 | 752 | Qty requested yearly | Unit Price | Min Buy
Part1 | 587.44 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 587.84 | 1
Part2 | 1261.81 | 1124.72 |  |  |  | 1029.24 |  |  | 950.28 |  |  |  |  |  |  |  | 883.8 |  |  |  |  |  |  |  |  |  |  |  | 826.32 |  |  |  |  |  |  |  |  |  |  |  |  |  | 779.09 |  |  |  |  |  |  | 1 | 1261.21 | 1
Part3 | 204.23 | 182.05 |  |  |  | 166.59 |  |  | 153.82 |  |  |  |  |  |  |  | 143.05 |  |  |  |  |  |  |  |  |  |  |  | 133.74 |  |  |  |  |  |  |  |  |  |  |  |  |  | 126.08 |  |  |  |  |  |  | 0 | 204.23 | 1
Part4 | 58.88 | 52.48 |  |  |  | 48.03 |  |  | 44.35 |  |  |  |  |  |  |  | 41.26 |  |  |  |  |  |  |  |  |  |  |  | 38.57 |  |  |  |  |  |  |  |  |  |  |  |  |  | 36.34 |  |  |  |  |  |  | 10 | 44.35 | 10
Part5 | 58.88 | 52.48 |  |  |  | 48.03 |  |  | 44.35 |  |  |  |  |  |  |  | 41.26 |  |  |  |  |  |  |  |  |  |  |  | 38.57 |  |  |  |  |  |  |  |  |  |  |  |  |  | 36.34 |  |  |  |  |  |  | 2 | 52.48 | 2
Part6 | 279.89 | 249.45 |  |  |  | 228.3 |  |  | 210.78 |  |  |  |  |  |  |  | 196.03 |  |  |  |  |  |  |  |  |  |  |  | 183.3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 172.83 |  |  |  |  |  |  | 4 | 249.45 | 2
Part7 | 253.32 | 225.76 |  |  |  | 206.62 |  |  | 190.77 |  |  |  |  |  |  |  | 177.43 |  |  |  |  |  |  |  |  |  |  |  | 165.88 |  |  |  |  |  |  |  |  |  |  |  |  |  | 156.41 |  |  |  |  |  |  | 7 | 206.62 | 6
Part8 | 297.19 | 264.89 |  |  |  | 242.42 |  |  | 223.8 |  |  |  |  |  |  |  | 208.15 |  |  |  |  |  |  |  |  |  |  |  | 194.64 |  |  |  |  |  |  |  |  |  |  |  |  |  | 183.5 |  |  |  |  |  |  | 100 | 183.5 | 100
Part9 | 1579.45 | 1407.76 |  |  |  | 1288.34 |  |  | 1189.47 |  |  |  |  |  |  |  | 1106.19 |  |  |  |  |  |  |  |  |  |  |  | 1034.37 |  |  |  |  |  |  |  |  |  |  |  |  |  | 975.18 |  |  |  |  |  |  | 120 | 975.18 | 100
Spreadsheet: darrell_schoolcraft__7735__imball0203
Sheet: PNM

PNM imbalance
 | Measured | Scheduled | Imbalance
9236 |  | -92567
9238 |  | -19000
56422 |  | -1390481
58710 |  | -1292
60921 |  | -639031
78026 |  | 1104
500084 |  | -19000
500085 | -5
500097 | -12121 | -12000
INDEX
2002-02-28 00:00:00 |  |  | 866614.36
2002-03-19 00:00:00
CBS Volume
 |  |  | 355045
Spreadsheet: 822170d1679146673-distribute-quantity-according-to-order-price-example-23-
Sheet: Folha1

Product | Available Stock | Total Quantity | Order_1 |  | [NAME] |  | Order_3
 |  |  | Quantity | Price | Quantity | Price | Quantity | Price
A | 920 |  | 100 | 3 | 432 | 1 | 545 | 4
B | 150 |  | 43 | 12 | 65 | 43 | 75 | 15
C | 100 |  | 43 | 43 | 76 | 21 | 87 | 54
D | 200 |  | 243 | 87 | 111 | 43 | 298 | 21
What I Need:
Product | Available Stock | Total Quantity | Order_1 |  | [NAME] |  | Order_3
 |  |  | Quantity | Price | Quantity | Price | Quantity | Price
A | 920 | 1077
B | 150 | 183
C | 100 | 206
D | 432 | 114
Spreadsheet: darrell_schoolcraft__7803__Southpoint Gas Model
Sheet: Sheet1

Southpoint |  |  | Transwestern's 24 hr Gas Control [PHONE]
 |  |  | Gas Nomination for 9th = 80,000
 |  |  | SoCal Gas Price |  | 3.47
 |  |  | San Juan Gas Price |  | 2.625
 |  |  | Unit 1 | Unit 2 | Steam TurB | Total MW | HR | Total Gas Usage
he 6 | 07:00:00 |  | 0 | 0 | 0 | 468 | 7
he 7 | 08:00:00 |  | 0 | 0 | 0 | 428 | 7
he8 | 09:00:00 |  | 0 | 0 | 0 | 428 | 7
he9 | 10:00:00 |  | 0 | 0 | 0 | 428 | 7
he10 | 11:00:00 |  | 0 | 0 | 0 | 428 | 7
he11 | 12:00:00 |  | 0 | 0 | 0 | 428 | 7
he12 | 13:00:00 |  | 0 | 0 | 0 | 428 | 7
[NAME] | 14:00:00 |  | 0 | 0 | 0 | 428 | 7
he14 | 15:00:00 |  | 0 | 0 | 0 | 428 | 7
he15 | 16:00:00 |  | 0 | 0 | 0 | 428 | 7
he16 | 17:00:00 |  | 0 | 0 | 0 | 428 | 7
he17 | 18:00:00 |  | 0 | 0 | 0 | 428 | 7
he18 | 19:00:00 |  | 0 | 0 | 0 | 428 | 7
he19 | 20:00:00 |  | 0 | 0 | 0 | 428 | 7
he20 | 21:00:00 |  | 0 | 0 | 0 | 428 | 7
he21 | 22:00:00 |  | 0 | 0 | 0 | 428 | 7
he22 | 00:00:00 |  | 0 | 0 | 0 | 428 | 7
he23 | 01:00:00 |  | 0 | 0 | 0 | 468 | 7
he24 | 02:00:00 |  | 0 | 0 | 0 | 468 | 7
he1 | 03:00:00 |  | 0 | 0 | 0 | 475 | 7
he2 | 04:00:00 |  | 0 | 0 | 0 | 475 | 7
he3 | 05:00:00 |  | 0 | 0 | 0 | 475 | 7
he4 | 06:00:00 |  | 0 | 0 | 0 | 475 | 7
[NAME] | 07:00:00 |  | 0 | 0 | 0 | 475 | 7
Spreadsheet: fcc897db-6bb2-4f90-af71-3bfccb137b58
Sheet: Sheet1

Unnamed: 0 | 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
 |  |  |  |  |  |  | ENGINEERING & TECHNICAL
 |  |  |  |  |  |  | BRANCH: SYDNEY
 |  |  |  |  |  |  | PAYROLL queries: Ph 1300 853 100
 |  |  |  |  |  |  | [NAME] approved timesheets to: [EMAIL]
 |  |  |  |  |  | or | FAX: 1800 652 808 before 12pm Tuesday
Time Sheet
Week ending day & date |  |  |  |  | Client Name
Employee Name |  |  |  |  | Client Address
Employee Position
Client Cost Centre |  |  |  |  | Supervisor's Name
[NAME] |  |  |  |  | Supervisor's Title
Employee's Signature |  |  |  |  | [NAME]'s Signature
By signing this, you are verifying the hours worked, that you are satisfied with the work completed and that you accept the Chandler Macleod Terms of Business. If you have not been provided with the Chandler Macleod Terms of Business, please contact your Consultant.
Day | Date | Time Start use AM/PM or use 24hr clock | Time Finish use AM/PM or use 24hr clock | Less Lunch | Hours Worked |  |  |  |  |  |  | Allowances
 |  |  |  |  | Ordinary | Shift | T 1/2 | T 2 | T 2 1/2 | Public Holiday | Total Hours or Days | Meal | Travel | Other:
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
 |  |  | Total Hours or Days
Send original receipts and client approval to Chandler Macleod Payroll, 200 Greenhill Road, EASTWOOD SA 5063
August 2010
Spreadsheet: 723657d1615822989-if-isnumber-formula-update-cells-with-character-depending-on-dates-actygation-holiday-forms-2021
Sheet: Colleague 1

HOLIDAY FORM 2021
NAME: |  |  |  | 2021 BANK HOLIDAY DATES | TAKEN Y/N (IF NO ADD LIEU DAY TO TABLE)
2021 HOLIDAY ENTITLEMENT |  |  |  | 01/01/2021 (New Years Day) | Y
To be completed - |  |  |  | 02/04/2021 (Good Friday) | N
2021 ENTITLEMENT |  | 26 |  | 05/04/2021 (Easter Monday) | N
CARRIED OVER FROM 2020 |  | 4 |  | 03/05/2021 (May Bank Hol) | N
LIEU DAYS |  | 0 |  | 31/05/2021 (May Bank Hol) | N
BOUGHT HOLIDAYS FOR 2021 |  | 0 |  | 30/08/2021 (Aug Bank Hol) | N
OTHER ENTITLEMENT (PLEASE ADD DETAILS) |  | 0 |  | 27/12/2021 (Xmas Day) | N
Reason: |  |  |  | 28/12/2021 (Xmas BH Day) | N
TOTAL FOR 2021:
HOLIDAY BOOKING PROCESS
1) | Send a request for holiday dates to your line manager
2) | Once approval is gained, issue a meeting invite to your line manager and direct team so they are aware of holiday dates
2) | Update this holiday form yourself and re-save on the network once approved
FROM | TO | DAYS | DAYS | AUTHORISED | DATE OF APPROVAL
 | (INCLUSIVE) | TAKEN | LEFT | BY
Date (dd/mm/yyyy) | Date (dd/mm/yyyy) | 0 |  | Add line manager name | Add date (dd/mm/yyyy)
2021-01-04 00:00:00 | 2021-01-08 00:00:00 | 4
2021-04-29 00:00:00 | 2021-04-30 00:00:00 | 2
2021-06-14 00:00:00 | 2021-06-18 00:00:00 | 5
2021-08-02 00:00:00 | 2021-08-06 00:00:00 | 5
2021-09-13 00:00:00 | 2021-09-17 00:00:00 | 5
2021-10-18 00:00:00 | 2021-10-18 00:00:00 | 1
2021-11-29 00:00:00 | 2021-11-29 00:00:00 | 1
2021-07-29 00:00:00 | 2021-07-30 00:00:00 | 2
Spreadsheet: 541923d1507632589-calculating-time-for-invoice-service-invoice-v3a
Sheet: INVOICE

 |  |  |  |  |  | A: | 63 [NAME], Melton South VIC 3338
 |  |  |  |  |  | P: | 0415 400 416 |  |  |  |  | TIME | FORMAT
 |  |  |  |  |  | W: | Tech-Xcellent |  |  |  |  | 46
 |  |  |  |  |  | E: | Tech-Xcellent
 | INVOICE |  |  |  |  | Total Due:
 | CLIENT NO#:
 | Invoice To:
 | B: |  |  |  |  | date:
 | N:
 |  |  |  |  |  | due:
 | A:
 | E: |  |  |  |  | job no:
 | P:
 | ITEM DESCRIPTIONS |  |  |  | QTY | UNIT PRICE |  | TOTAL
 | LABOUR
 | LABOUR
 | LABOUR
 | LABOUR
 | LABOUR
 |  |  |  |  |  | SUB TOTAL:
 | [NAME]
 | CARDS: | VISA, MASTERCARD, AMEX, INTERNATIONAL CARDS
 | SQUARE:
 | BANK: | BSB: |  | ACCOUNT:
 | TERMS & CONDITIONS:
 | PAYMENT WITHIN 7 BUSINESS DAYS OF ISSUE |  |  |  | BENJAMIN DAVIS
 |  |  |  |  | MANAGER | DEVELOPER | IT-CONSULTANT
Spreadsheet: 179528d1347290046-tying-two-cells-together-so-they-are-mutually-dependent-upload-for-toggling-cells
Sheet: Data

State | Fruit type | Quantity sold | Average price | % imported |  | 2
CA | Apples | 13 | 2.38 | 0.18
CA | Bananas | 24 | 2.22 | 0.37
CA | Cherries | 19 | 2.14 | 0.24
FL | Apples | 21 | 2.2 | 0.41
FL | Bananas | 29 | 2.71 | 0.51
FL | Cherries | 26 | 1.7 | 0.78
NY | Apples | 26 | 1.85 | 0.9
NY | Bananas | 20 | 1.55 | 0.09
NY | Cherries | 26 | 1.13 | 0.51