tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kate_symes__19078__Palo
Sheet: DJ Palo Verde Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-04-11 00:00:00 |  | 179.1 | 25424 | 91.37 | 9280
 | 2001-04-10 00:00:00 |  | 175.51 | 21664 | 89.05 | 7360 | 152.75 | 5195 | 106.04 | 1927
 | 2001-04-09 00:00:00 |  | 140.37 | 29824 | 99.04 | 10024 | 160.69 | 4429 | 82.6 | 1221
 | 2001-04-08 00:00:00 |  | 135 | 0 | 99 | 0 | 94.68 | 4331 | 89.95 | 950 |  | 98.94 | 30072
 | 2001-04-07 00:00:00 |  | 163.25 | 24928 | 78.81 | 9720 | 124.58 | 4097 | 104.49 | 973
 | 2001-04-06 00:00:00 |  | 163.25 | 24928 | 78.81 | 9720 | 144.64 | 4383 | 107.57 | 1185
 | 2001-04-05 00:00:00 |  | 210.51 | 39072 | 95.69 | 12336 | 113.42 | 2159 | 94.37 | 1318
 | 2001-04-04 00:00:00 |  | 235.75 | 35568 | 96.01 | 11864 | 134.48 | 2153 | 65.34 | 1391
 | 2001-04-03 00:00:00 |  | 232.48 | 34768 | 101.7 | 8424 | 124.35 | 2275 | 80.72 | 166
 | 2001-04-02 00:00:00 |  | 234.1 | 20032 | 134.92 | 8456 | 151.72 | 5836 | 152.21 | 1055
 | 2001-04-01 00:00:00 |  | 150 | 800 | 130 | 0 | 169.97 | 4993 | 179.55 | 3133 |  | 136.89 | 20112
 | 2001-03-31 00:00:00 |  | 155.24 | 26800 | 79.32 | 5000 | 203.27 | 4434 | 161.69 | 2164
 | 2001-03-30 00:00:00 |  | 155.24 | 26800 | 78.68 | 5600 | 166.55 | 6883 | 125.76 | 3604
 | 2001-03-29 00:00:00 |  | 149.29 | 27472 | 74.97 | 7680 | 151.01 | 3119 | 106.73 | 2737
 | 2001-03-28 00:00:00 |  | 117.91 | 28384 | 64.05 | 8795 | 135.59 | 5365 | 79.21 | 2138
 | 2001-03-27 00:00:00 |  | 107.14 | 26352 | 54.09 | 6800 | 138.05 | 5768 | 73.14 | 3889
 | 2001-03-26 00:00:00 |  | 280.53 | 20768 | 160.99 | 5520 | 115.17 | 3547 | 66.57 | 2059
 | 2001-03-25 00:00:00 |  | 200 | 0 | 135 | 200 | 80.99 | 1643 | 75.59 | 545 |  | 162.46 | 16560
 | 2001-03-24 00:00:00 |  | 233.04 | 14608 | 130.51 | 4880 | 130 | 6097 | 179.92 | 3350
 | 2001-03-23 00:00:00 |  | 233.24 | 14448 | 130.51 | 4880 | 324.97 | 6129 | 242.2 | 3200
 | 2001-03-22 00:00:00 |  | 281.29 | 18448 | 160.38 | 5360 | 385.71 | 8040 | 282.16 | 2915
 | 2001-03-21 00:00:00 |  | 460.02 | 24848 | 198.73 | 8120 | 350.98 | 4786 | 253.67 | 1853
 | 2001-03-20 00:00:00 |  | 377.03 | 18384 | 176.12 | 5120 | 390.83 | 2452 | 357.57 | 1668
 | 2001-03-19 00:00:00 |  | 297.33 | 24848 | 176.6 | 9000 | 258.33 | 3388 | 199.67 | 2448
 | 2001-03-18 00:00:00 |  | 220 | 0 | 185 | 0 | 170.47 | 4949 | 156.95 | 2582 |  | 178.66 | 28200
 | 2001-03-17 00:00:00 |  | 195.41 | 17152 | 121.88 | 8832 | 191.77 | 10872 | 180.55 | 1883
 | 2001-03-16 00:00:00 |  | 195.98 | 16352 | 121.88 | 8832 | 219.02 | 5921 | 173.76 | 3142
 | 2001-03-15 00:00:00 |  | 180.19 | 17472 | 98.04 | 5160 | 188.69 | 6005 | 136.45 | 3320
 | 2001-03-14 00:00:00 |  | 162.56 | 17184 | 81.84 | 6960 | 194.59 | 4065 | 117.41 | 1400
 | 2001-03-13 00:00:00 |  | 157.46 | 17840 | 69.39 | 7288 | 171.29 | 4137 | 134.75 | 1330
 | 2001-03-12 00:00:00 |  | 166.55 | 12544 | 91.58 | 6920 | 186.95 | 2928 | 114.77 | 1215
Spreadsheet: joe_stepenovitch__15104__EOL_Enpower_deals
Sheet: Sheet2

2001-09-05 00:00:00 | 715
2001-09-06 00:00:00 | 935
2001-09-07 00:00:00 | 709
2001-09-18 00:00:00 | 693
2001-09-19 00:00:00 | 602
2001-09-20 00:00:00 | 589
2001-09-25 00:00:00 | 712
2001-09-26 00:00:00 | 613
2001-09-27 00:00:00 | 799
2001-09-28 00:00:00 | 724
2001-10-03 00:00:00 | 791
2001-10-04 00:00:00 | 634 | 536
2001-10-05 00:00:00 | 493 | 521 | 28
2001-10-08 00:00:00 | 273 | 343
2001-10-09 00:00:00 | 487 | 490 | 3
2001-10-12 00:00:00 | 368 | 313 | -55
2001-10-15 00:00:00 | 388 | 331 | -57
2001-10-16 00:00:00 | 670 | 572 | -98
2001-10-17 00:00:00 | 597 | 588 | -9
2001-10-18 00:00:00 | 527 | 633 | 106
2001-10-19 00:00:00 | 584 | 613 | 29
2001-10-22 00:00:00 | 833 | 666 | -167
2001-10-24 00:00:00 | 663 | 460 | -203
2001-10-25 00:00:00 | 669 | 830 | 161
Spreadsheet: 57397d1257512424-line-graph-problem-rap-usage-tracker
Sheet: Stowfield

Tarmac - West Rap Usage tracker |  |  |  | Stowfield
 |  | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | YTD Savings/ usage
 | Total RAP used |  | 130.6 | 101.96 | No stock | No Stock | No Stock | No Stock | 111.2 | 318.55 | 424.52
 | Total tonnage acceptable for RAP additon |  | 5070.6 | 6746.45 |  |  |  |  | 2504.9 | 5174.44 | 6111 |  |  |  | 25607.39
 | Target Addition (%) |  | 0.05 | 0.05 |  |  |  |  | 0.05 | 0.1 | 0.1 | 0.1 | 0.1 | 0.1
 | Actual Addition (%) |  | 0.02575632075099593 | 0.01511313357395371 | #N/A | #N/A | #N/A | #N/A | 0.04439298974010938 | 0.06156221736071923 | 0.06946817214858451
 | Benefit per tonne (£) | 1.28 | 1.28 | 1.28 | 1.28 | 1.28 | 1.28 | 1.28 | 1.28 | 1.28 | 1.28 | 1.28 | 1.28 | 1.28
 | Actual Total Benefit (£) | 0 | 3343.36 | 2603.52 | 0 | 0 | 0 | 0 | 2831.36 | 4069.12 | 5432.32 | 0 | 0 | 0 | 18279.68
 | Estimated Material with Rap Addition |  | 2612 | 2034 |  |  |  |  | 2212 | 3179 | 4244
 | [NAME] check |  | 130.6 | 101.7 | 0 | 0 | 0 | 0 | 110.6 | 317.9 | 424.4
Spreadsheet: 768393d1644944824-index-match-that-compares-if-date-is-between-two-dates-and-returns-yes-or-no-jjoseph08-practice
Sheet: Data Dump

Employee Name | Date
Employee 3 | 2022-01-03 00:00:00
Employee 4 | 2022-01-04 00:00:00
Employee 1 | 2022-01-07 00:00:00
Employee 2 | 2022-01-07 00:00:00
Employee 3 | 2022-01-08 00:00:00
Employee 4 | 2022-01-10 00:00:00
Employee 1 | 2022-01-11 00:00:00
Employee 2 | 2022-01-12 00:00:00
Employee 3 | 2022-01-12 00:00:00
Employee 4 | 2022-01-12 00:00:00
Employee 1 | 2022-01-13 00:00:00
Employee 2 | 2022-01-13 00:00:00
Employee 3 | 2022-01-18 00:00:00
Employee 4 | 2022-01-18 00:00:00
Employee 1 | 2022-01-19 00:00:00
Employee 2 | 2022-01-19 00:00:00
Employee 3 | 2022-01-20 00:00:00
Employee 4 | 2022-01-23 00:00:00
Employee 1 | 2022-01-24 00:00:00
Employee 2 | 2022-01-26 00:00:00
Employee 3 | 2022-01-26 00:00:00
Employee 4 | 2022-01-28 00:00:00
Employee 1 | 2022-01-28 00:00:00
Employee 2 | 2022-01-28 00:00:00
Employee 3 | 2022-01-29 00:00:00
Employee 4 | 2022-01-30 00:00:00
Employee 1 | 2022-01-31 00:00:00
Employee 2 | 2022-02-01 00:00:00
Employee 3 | 2022-02-02 00:00:00
Employee 4 | 2022-02-03 00:00:00
Employee 1 | 2022-02-04 00:00:00
Employee 2 | 2022-02-06 00:00:00
Employee 3 | 2022-02-07 00:00:00
Employee 4 | 2022-02-07 00:00:00
Employee 1 | 2022-02-09 00:00:00
Employee 2 | 2022-02-09 00:00:00
Employee 3 | 2022-02-10 00:00:00
Employee 4 | 2022-02-10 00:00:00
Employee 1 | 2022-02-10 00:00:00
Spreadsheet: 880438d1728180321-cannot-get-if-and-unique-function-to-work-in-side-by-side-columns-testfile
Sheet: CFS Charges

CFS - Warehouse Charges
 |  |  |  |  | **Note: Goal to leave out columns that have all '0.00' charges.
CFS Location: |  | cfs-2
 | Client | Job # | POL | POD | Final Dest | # Pieces | Gross Wght (kgs) | CBM | [NAME] | CFS Location | Total CFS Charges: | CFS Charge | Handling Fee | CUCC Collect
2023-07-26 00:00:00 | Client-2 | 9 | qingdao | NY | Boston | 1-pallet/ 24-bags | 630 | 1 | LCL | CFS-2 | 255 | 255 | 0 | 0
2023-08-04 00:00:00 | Client-2 | 10 | Shanghai | NY | Boston | 1-pallet | 84 | 0 | LCL | CFS-2 | 325 | 0 | 255 | 70
2023-08-04 00:00:00 | Client-2 | 11 | Shanghai | Boston | Boston | 182-ctns/ 6-pallet | 3810 | 8 | LCL | CFS-2 | 0 | 0 | 0 | 0
Spreadsheet: 865595d1712653216-list-up-the-sheet1-to-sheet2-depend-on-condition-list-pump-use-
Sheet: WORKER 3

WORKER 3
no | location | customer | Status | worker 3
Spreadsheet: 723026d1615482413-range-between-n-days-range-between-n-days-1-
Sheet: Working

 | N=6 |  |  |  | N=5
PX_BID | Take this | from this | Difference |  | Take this | from this | Difference
102.661
102.68 | 102.68 |  |  |  | 102.68
102.626 | 102.626 |  |  |  | 102.626 |  |  |  | n | n | n | n | n | n | n | n
102.643 | 102.643 |  |  |  | 102.643 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
102.678 | 102.678 |  |  |  | 102.678
102.689 | 102.689 |  |  |  | 102.689 | 102.689
102.645 | 102.645 | 102.645 |  |  | 102.645 | 102.645
102.665 | 102.665 | 102.665 |  |  | 102.665 | 102.665
102.652 | 102.652 | 102.652 |  |  | 102.652 | 102.652
102.62 | 102.62 | 102.62 |  |  | 102.62 | 102.62
102.666 | 102.666 | 102.666 |  |  | 102.666 | 102.666
102.824 | 102.824 | 102.824 |  |  | 102.824 | 102.824
102.873 | 102.873 | 102.873 |  |  | 102.873 | 102.873
102.924 | 102.924 | 102.924 |  |  | 102.924 | 102.924
102.909 | 102.909 | 102.909 |  |  | 102.909 | 102.909
102.94 | 102.94 | 102.94 |  |  | 102.94 | 102.94
102.987 | 102.987 | 102.987 |  |  | 102.987 | 102.987
103.008 | 103.008 | 103.008 |  |  | 103.008 | 103.008
103.006 |  | 103.006 |  |  | 103.006 | 103.006
102.968 |  | 102.968 |  |  |  | 102.968
102.906 |  | 102.906 |  |  |  | 102.906
102.952 |  | 102.952 |  |  |  | 102.952
102.987 |  | 102.987 |  |  |  | 102.987
Spreadsheet: 82486d1282568136-excel-2007-copy-top-10-from-worksheets-to-a-single-sheet-print-prep
Sheet: Reach Truck

Unit Type | Operator ID | Date / Time | Threshold | H Actual | V Actual | Unit No. | Department
Reach Truck | Linus | 2010-07-15 21:45:00 |  | 8.99 | 0 | AB | Shipping
Reach Truck | [NAME] | 2010-07-14 15:35:00 |  | 7.18 | 0 | AB | Shipping
Spreadsheet: 3546f6f0-8291-455e-82af-80eb11e91085
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 |  |  |  |  |  | Date:
 |  |  |  |  |  | 2013-01-24 00:00:00
 |  |  | [NAME]. (312) 670-0464  Fax (312) 670-0465 |  |  |  |  | AC-AL CONNOR
 | Instructions:
 | To calculate the profitability of your sale, please plug in your figures in the cells with RED font. |  |  |  |  |  |  | CC-CHAD CROOKS
 |  |  | PRICE | WEIGHT | CALCULATIONS |  |  | CS-CARL SHELLENBACK
 | Sold (sales revenue) |  | 23 | 37485 | 8621.55 |  |  | TR-TREVOR RYALS
 |  |  |  |  |  |  |  | TS-TOM STILLINGS
 | Purchase |  | 19.5 | 37485 | 7309.575
 | Freight |  | 0 | 37485 | 0 |  |  | 0.05
 | Processing & Storage |  | 0 | 37485 | 0 |  |  | 0.1
 | Freight |  | 0 | 37485 | 0 |  |  | 0.15
 | TOTAL FREIGHT & PROCESSING |  | 0 |  | 0 |  |  | 0.2
 | TOTAL COSTS |  | 19.5 |  | 7309.575 |  |  | 0.25
 | Net |  |  |  | 1311.974999999999 |  |  | 0.3
 |  |  |  |  |  |  |  | 0.35
 |  |  |  |  |  |  |  | 0.4
 |  |  |  |  |  |  |  | 0.7
 | COMMENTS: |  |  |  |  |  |  | 0.75
 |  |  |  |  |  |  |  | 0.8
 |  |  |  |  |  |  |  | 0.85
 |  |  |  |  |  |  |  | 0.9
 |  |  |  |  |  |  |  | 1
Spreadsheet: 27450d1220628931-a-two-part-summation-subtotal
Sheet: Sheet1

 |  | A | 2 | 2
 |  | A | 4 | 6
 |  | A | 3 | 9 | 9
 |  | B | 7 | 7 | 7
 |  | C | 1 | 1
 |  | C | 1 | 2 | 2
 |  | D | 9 | 9
 |  | D | 2 | 11
 |  | D | 3 | 14
 |  | D | 5 | 19
 |  | D | 6 | 25
 |  | D | 5 | 30 | 30
 |  | E | 3 | 3 | 3
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
Spreadsheet: c6c92bf5-d9b9-4165-94f2-3a7d401374e3
Sheet: PAG 9 - Table 2

Beer Brazil results |  |  | Currency Translation | Organic Growth |  | % As | %
R$ million | YTD10 | Scope |  |  | YTD11 | Reported | Organic
Volume ('000 hl) | 84475.61258533814 | 0 | 0 | 122.1425383866153 | 84597.75512372475 | 0.00144589112346738 | 0.001445891123467447
Net revenue | 14279.269 | 0 | 0 | 1388.237999999998 | 15667.507 | 0.09722052298335426 | 0.09722052298335422
Net revenue/hl | 169.0342166572031 | 0 | 0 | 16.16581586240889 | 185.200032519612 | 0.09563635210729404 | 0.09563635210729397
[NAME] | -4167.275000000001 | -7.095 | 0 | -222.5640000000006 | -4396.934000000001 | 0.0551101139233674 | 0.05331678792248903
[NAME]/hl | -49.33110127837399 | -0.0839887369012331 | 0 | -2.559504269992246 | -51.97459428526747 | 0.05358674220501025 | 0.05179600541456163
Gross profit | 10111.994 | -7.095 | 0 | 1165.673999999997 | 11270.573 | 0.1145747317492474 | 0.1153573133190146
Gross margin | 0.7081590801321831 | 0 | 0 | 0 | 0.7193596913663417 | 110 | 120
SG&A excl. deprec.&amort. | -3898.904 | 0 | 0 | -193.0689999999995 | -4091.973 | 0.04951878784396824 | 0.04951878784396833
SG&A deprec.&amort. | -359.282 | 13.932 | 0 | 43.38900000000002 | -301.961 | -0.1595432000489867 | -0.125637758795425
SG&A total | -4258.186 | 13.932 | 0 | -149.6800000000005 | -4393.934 | 0.03187930259504879 | 0.03526650384260709
Other operating income | 501.8819999999999 | -116.751 | 0 | 222.3800000000002 | 607.5110000000001 | 0.2104658067035683 | 0.5774139189003229
Normalized EBIT | 6355.689999999999 | -109.914 | 0 | 1238.373999999997 | 7484.149999999997 | 0.1775511392154114 | 0.1982738413929665
Normalized EBIT margin | 0.4450991153678804 | 0 | 0 | 0 | 0.4776860798594185 | 330 | 400
Normalized EBITDA | 7120.074000000001 | -116.751 | 0 | 1213.129999999997 | 8216.452999999998 | 0.1539842142090093 | 0.1732220547303041
Normalized EBITDA margin | 0.4986301469634055 | 0 | 0 | 0 | 0.5244263174734818 | 260 | 340
Spreadsheet: 747111d1631229312-help-with-combining-if-and-and-with-or-i-guess-sample
Sheet: Sheet1

Status | DOJ | Tenurity M | Target |  |  | [NAME]
RJ | 2021-06-07 00:00:00 |  | 1.25 | 1.25 because this person is less than 3 monts and status is RJ |  | Status | Tenure | Target
RJ | 2021-06-07 00:00:00 |  | 1.25 |  |  | T7 | < 6 | 1.25
RJ | 2021-06-07 00:00:00 |  | 1.25 |  |  | RJ | < 6 | 1.25
RJ | 2021-06-07 00:00:00 |  | 1.25 |  |  | RJ/T7 | >6 and <12 | 1
RJ | 2021-06-07 00:00:00 |  | 1.25 |  |  | RJ/T7 | >12 | 0.85
RJ | 2021-06-07 00:00:00 |  | 1.25
RJ | 2021-06-07 00:00:00 |  | 1.25
RJ | 2021-06-07 00:00:00 |  | 1.25
RJ | 2021-06-07 00:00:00 |  | 1.25
RJ | 2021-06-07 00:00:00 |  | 1.25
RJ | 2021-06-07 00:00:00 |  | 1.25
RJ | 2021-06-07 00:00:00 |  | 1.25
T7 | 2020-06-01 00:00:00 |  | 0.85 | 0.85 because person is over 12 months old from DOJ
RJ | 2017-11-20 00:00:00 |  | 0.85
T7 | 2021-07-19 00:00:00 |  | 1
Spreadsheet: 866372d1713300077-looking-for-a-way-to-get-sum-of-data-kansas-scheduler-v4-5-
Sheet: ALL JOBS

 |  |  | DO NOT EDIT THIS SHEET- IT IS A REFERENCE SHEET!  DATA IS PULLED HERE FROM DIGITAL AND FABRIC TABS.
Press | SchedTime | Due Date | Job# | Line# | Master [NAME] | QTY | H | W | Material | Sides | PrintMode | Kitting | #OfKits | Notes | DateRecieved | SqFt | LinearFT
Spreadsheet: 776400d1649720307-data-in-one-cell-highlighted-in-another-cell-book1
Sheet: Sheet1

 | MONDAY | DATE: | 2022-04-08 00:00:00
 |  | DUTY # | SIGN ON |  | SIGN OFF |  | ALLOCATION
 |  | 5554 |  | AM |  | AM
 |  |  |  | PM |  | PM
 | TUESDAY | DATE:
 |  | DUTY # | SIGN ON |  | SIGN OFF |  | ALLOCATION
 |  | 5551 |  | AM |  | AM
 |  |  |  | PM |  | PM
 | WEDNESDAY | DATE:
 |  | DUTY # | SIGN ON |  | SIGN OFF |  | ALLOCATION
 |  | 001 |  | AM |  | AM
 |  |  |  | PM |  | PM
 | THURSDAY | DATE:
 |  | DUTY # | SIGN ON |  | SIGN OFF |  | ALLOCATION
 |  |  |  | AM |  | AM
 |  | 5553 |  | PM |  | PM
 | FRIDAY | DATE:
 |  | DUTY # | SIGN ON |  | SIGN OFF |  | ALLOCATION
 |  |  |  | AM |  | AM
 |  | 5555 |  | PM |  | PM
 |  | ☝
 |  | data placed in this box highlighted in the row below
 |  | ☟ | rows to be hightlighted below
 | Duty # | Sign on | Sign Off |  |  | Sign on | Sign Off
☞ | 1 | 07:00:00 | 08:50:00 |  |  | 14:45:00 | 16:45:00
☞ | 5551 | 07:15:00 | 08:50:00 |  |  | 14:45:00 | 16:45:00
☞ | 5552 | 07:00:00 | 08:50:00 |  |  | 14:45:00 | 16:45:00
☞ | 5553 | 06:30:00 | 09:00:00 |  |  | 14:00:00 | 17:00:00
☞ | 5554 | 07:00:00 | 08:50:00 |  |  | 14:00:00 | 17:00:00
☞ | 5555 | 07:15:00 | 09:15:00 |  |  | 14:30:00 | 17:00:00
Spreadsheet: 219305d1362706103-calculating-how-many-hrs-are-ord-hrs-time-and-a-half-and-double-time-over-a-range-payroll-and-invoicing-wheatstone
Sheet: INVOICE

PAYROLL |  | WE 02/03/2013
 |  |  |  |  | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
TEAM | SURNAME | SURNAME | FIRST NAME | FLY IN | 2013-02-24 00:00:00 | 2013-02-25 00:00:00 | 2013-02-26 00:00:00 | 2013-02-27 00:00:00 | 2013-02-28 00:00:00 | 2013-03-01 00:00:00 | 2013-03-02 00:00:00
1 | CABRILOVSKI | CABRILOVSKI | GEORGE | 2013-03-01 00:00:00 |  |  |  |  |  | 4 | 12
1 | HARWOOD | HARWOOD | MARK | 2013-03-01 00:00:00 |  |  |  |  |  | 8.5 | 12
1 | HERBERT | HERBERT | XAVIER | 2013-03-01 00:00:00 |  |  |  |  |  | 4 | 12
1 | LORD | LORD | JAY | 2013-03-01 00:00:00 |  |  |  |  |  | 4 | 12
1 | VAUGHAN | VAUGHAN | [NAME] | 2013-03-01 00:00:00 |  |  |  |  |  | 4 | 12
1 | WAYRE | WAYRE | ADAM | 2013-03-01 00:00:00 |  |  |  |  |  | 4 | 12
1 | MUIR | MUIR | JAKE | 2013-03-01 00:00:00 |  |  |  |  |  | 4 | 12
1 | COGAN | COGAN | [NAME] | 2013-03-01 00:00:00 |  |  |  |  |  | 4 | 12
2 | HALL | HALL | JACK
2 | PERKINS | PERKINS | IAN
2 | KENNEDY | KENNEDY | DARRREL
2 | TAYLOR | TAYLOR | ADAM
2 | WASS | WASS | CRAIG
2 | HARNETT | HARNETT | CALLAN
2 | KANIA | KANIA | EDWARD
2 | SHARP | SHARP | [NAME]
 |  |  | SCHEDULE OFF RATES | Hrs Total
 |  |  |  | SITE ALLOWANCE
 |  |  |  | ORDINARY TIME |  |  |  |  |  | 4.5 | 0
 |  |  |  | TIME AND HALF |  |  |  |  |  |  | 16
 |  |  |  | DOUBLE TIME |  |  |  |  |  |  | 80
 |  |  |  | Total Invoice Amount $ |  |  |  |  |  |  |  | Excludes GST
 |  | 1 | Enter hrs
 |  | 2 | Any hrs worked on same day of travel manually enter into Rows 22,23,24
 |  | 3 | Check hrs add from ordm, time n half and double time against the total Site allowance hrs. Below Sum
Spreadsheet: 36013d1233761459-formula-does-not-calculate-numbered-customer-accounts-numerical-problem
Sheet: Chart Data

 | 2008-04-01 00:00:00 | 2008-05-01 00:00:00 | 2008-06-01 00:00:00 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | TOTAL/AVG |  | 1B0012
QDR RAISED | 5 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 8
SCORE | -25 | -5 | -5 | 0 | 0 | 0 | 0 | 0 | -5 | 0 | 0 | 0 | -40
AVERAGE DAYS OPEN | 0 | 0 | 18 | 0 | 0 | 0 | 0 | 0 | 30 | 0 | 0 | 0 | 24
SCORE | 0 | 0 | -5 | 0 | 0 | 0 | 0 | 0 | -5 | 0 | 0 | 0
OPEN |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 0049e63d-2045-4bf0-8ea9-587531e97ac0
Sheet: CONSOLIDACIÓN

Saber del Sur Convocatoria de experiencias de Cooperación Sur- Sur          Cierre convocatoria: 2 de marzo 2012  (4 página de 4)
[NAME] cooperación
17. ¿Cuáles son [NAME] relevantes del plan de trabajo acordado entre los países involucrados ? | Describa sintéticamente las principales metas acordadas del proceso de cooperación y su estado de avance.
18. Describa tres capacidades desarrolladas a través de esta experiencia en el/los países receptores | Describa los recursos humanos, técnicos o financieros que ha dispuesto el país demandante para adaptar la experiencia a su contexto
 | 1.
 | 2.
 | 3.
19. [NAME] las políticas, oganizaciones, [NAME] o procedimientos establecidos en el país o países receptores como resultado de este proceso de cooperación | Describa sintéticamente los principales ARREGLOS Y [NAME] institucionales [NAME]
 | 1.
 | 2.
 | 3.
20. ¿[NAME] acuerdos, instrumentos o metodologías han sido establecidos para consolidar una cooperación horizontal de largo plazo? | [NAME] precisa los acuerdos, instrumentos o metodologías que busquen consolidar una relación de cooperación de largo plazo. [NAME] 50 palabras cada una.
 | 1.
 | 2.
 | 3.
¡GRACIAS!
Spreadsheet: 773914d1648115691-compare-values-in-multiple-records-of-identical-values-of-a-different-cell-excel-problem
Sheet: Sheet1

Corporation | Project | Checked? | Enterprise visited? | Desired result in Column D
A | 1 | Y | Return "Y" if at least one project of the same corporation is 'Y' for "Checked", otherwise 'N' | Y
A | 2 | Y |  | Y
A | 3 | N |  | Y
A | 4 | Y |  | Y
B | 5 | N |  | N
B | 6 | N |  | N
B | 7 | N |  | N
B | 8 | N |  | N
C | 9 | Y |  | Y
C | 10 | N |  | Y
C | 11 | N |  | Y
C | 12 | N |  | Y
Spreadsheet: 163568d1340369168-send-unique-duplicates-and-3x-duplicates-to-a-seperate-sheet-cut-sort-list
Sheet: inventory

Gage ID | Description | Asset No | Location | Last Cal Date | Next Due Date | list
QE-001515 |  |  | A200 |  |  | inventory
QE-001516 |  |  | A200 |  |  | inventory
QE-001517 |  |  | D300 |  |  | inventory
QE-001518 |  |  | A200 |  |  | inventory
QE-001519 |  |  | A200 |  |  | inventory
Spreadsheet: 21642d1209406006-excel-and-dss-itproject
Sheet: Sheet1

 | Starters | Points | Main Course | Points | Side Order | Points | Desserts | Points | Drinks | Points
 | Sesame Prawn Finger (each) | 1 | Chicken with Pineapple | 3 | Stir Fried Beansprouts with [NAME] and Spring Onions | 2.5 | Lychees (6) | 1.5 | Diet Coke (per 100ml) | 0
 | Black Bean Soup | 2.5 | Roast Pork Cantonese Style | 4.5 | Sweet & Sour Sauce | 3 | Fortune Cookies (each) | 2 | Mineral Water (per 100ml) | 0
 | Chicken & Sweetcorn Soup | 2.5 | King Prawn Chow Mein | 5.5 | [NAME] in Oyster Sauce | 4.5 | Ice Cream | 6 | Wine, light or low alchol (per 175ml glass) | 0.5
 | Hot & Sour Soup | 2.5 | Beef Chop Suey | 6 | Noodles & Beansprouts | 4.5 | [NAME] | 7.5 | Coke (per 100ml) | 0.5
 | Crispy Spring Rolls (each) | 5 | Chicken & Cashew Nuts | 6.5 | [NAME]Singapore' Style | 5.5 | [NAME] | 10 | Fruit Juice (per 100ml) | 0.5
 | Prawn Crackers (average portion) | 5 | [NAME] | 7.5 | Plain Boiled Rice | 6.5 |  |  | Lemonade (per 100ml) | 0.5
 | Satay Chicken | 5.5 | Lamb with Ginger & Spring Onions | 7.5 | [NAME] | 9.5 |  |  | Lager (per 1/2 pint) | 1
 | [NAME] | 7.5 | [NAME] | 8.5 | Egg Fried Rice | 10 |  |  | Guinness (per 1/2 pint) | 1.5
 | BBQ Spare Ribs | 10 | Sweet & Sour Chicken | 10 | Special Fried Rice | 10 |  |  | Wine, red, white, or rose (per 175ml glass) | 2
Allocated Meal points
17
Spreadsheet: 689387d1596368492-how-to-count-month-from-the-date-format-mm-dd-yyyy-without-converting-it-counting-month-from-date
Sheet: Sheet1

REPORTINGDATE |  | USING TEXT FORMULA TO CONVERT IT INTO MONTH |  |  |  |  |  | AND USING COUNTIF FORMULA
2020-07-21 00:00:00 |  |  |  |  |  |  |  |  | JULY | AUGUST
2020-07-21 00:00:00
2020-08-02 00:00:00
2020-07-21 00:00:00
2020-07-22 00:00:00 |  |  |  |  |  |  | Question is, how can we directly count month from the following date format in A2:A19?
2020-07-23 00:00:00
2020-08-02 00:00:00
2020-07-22 00:00:00
2020-07-22 00:00:00
2020-07-22 00:00:00
2020-08-02 00:00:00
2020-08-02 00:00:00
2020-08-02 00:00:00
2020-08-02 00:00:00
2020-08-02 00:00:00
2020-07-16 00:00:00
2020-07-16 00:00:00
2020-07-16 00:00:00
Spreadsheet: 870175d1716735674-how-to-convert-table-with-relative-position-number-to-header-of-reference-table-stock-comparison-29
Sheet: Sheet1

 | 13e | 02e | -11? | -20e |  | -4-2a | -6-41a | 013e | -2-1a |  |  | -1???
 | 1 ext | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15
 | 0 | 0 | 0 | 0 | 3 | 0 | 1 | 1 | 1 | 3 | 4 | 3 | 5 | 5 | 7
 | 0 | 0 | 0 | 0 | 3 | 0 | 1 | 1 | 1 | 3 | 4 | 3 | 5 | 5 | 7
 | 0 | 0 | 0 | 0 | 3 | 0 | 1 | 1 | 1 | 3 | 4 | 4 | 6 | 6 | 8
 | 0 | 0 | 0 | 0 | 4 | 0 | 1 | 2 | 1 | 4 | 6 | 6 | 10 | 10 | 13
 | 0 | 0 | 0 | 0 | 4 | 0 | 1 | 2 | 2 | 5 | 7 | 6 | 10 | 10 | 14
 | 0 | 0 | 1 | 0 | 4 | 0 | 1 | 2 | 3 | 7 | 8 | 9 | 13 | 13 | 17
 | 0 | 0 | 3 | 0 | 5 | 1 | 4 | 2 | 8 | 10 | 12 | 11 | 17 | 15 | 22
ref table
 | 1 ext | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15
 | 0 | 0 | 0 | 0 | 2 | 1 | 1 | 1 | 0 | 1 | 1 | 4 | 6 | 5 | 5
all | 0 | 0 | 0 | 0 | 2 | 1 | 1 | 1 | 0 | 1 | 1 | 4 | 6 | 5 | 5
[NAME]) | 1 | 0 | 1 | 0 | 2 | 3 | 1 | 1 | 1 | 4 | 2 | 5 | 9 | 7 | 8
all(s/fexp) | 1 | 0 | 1 | 0 | 2 | 3 | 1 | 1 | 1 | 6 | 2 | 5 | 9 | 7 | 10
all(s/fexp) | 1 | 0 | 1 | 0 | 2 | 3 | 2 | 1 | 2 | 6 | 2 | 5 | 11 | 7 | 13
all(s/fexp) | 1 | 0 | 1 | 0 | 2 | 3 | 3 | 2 | 2 | 8 | 4 | 8 | 14 | 10 | 16
 | 1 | 0 | 1 | 0 | 2 | 3 | 3 | 2 | 2 | 8 | 4 | 8 | 14 | 10 | 16
 |  |  | convert table row 6 to below
 | t2t4e | t2t4e | t2t4? | t2t4e |  | t2t4a | 1extt3t8a | t8t9t11e | t6t8a |  |  | -1???
 | 1 ext | t2 | t3 | [NAME] | t5 | t6 | t7 | t8 | t9 | t10 | t11 | t12 | t13 | t14 | t15
 | 0 | 0 | 0 | 0 | 3 | 0 | 1 | 1 | 1 | 3 | 4 | 3 | 5 | 5 | 7
 | 0 | 0 | 0 | 0 | 3 | 0 | 1 | 1 | 1 | 3 | 4 | 3 | 5 | 5 | 7
 | 0 | 0 | 0 | 0 | 3 | 0 | 1 | 1 | 1 | 3 | 4 | 4 | 6 | 6 | 8
 | 0 | 0 | 0 | 0 | 4 | 0 | 1 | 2 | 1 | 4 | 6 | 6 | 10 | 10 | 13
 | 0 | 0 | 0 | 0 | 4 | 0 | 1 | 2 | 2 | 5 | 7 | 6 | 10 | 10 | 14
 | 0 | 0 | 1 | 0 | 4 | 0 | 1 | 2 | 3 | 7 | 8 | 9 | 13 | 13 | 17
 | 0 | 0 | 3 | 0 | 5 | 1 | 4 | 2 | 8 | 10 | 12 | 11 | 17 | 15 | 22