tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 676889d1589041481-help-with-excel-formula-work-scheduling-watchbill
Sheet: Jobs and Shifts

 | Job and Shift Details
 |  |  | Team 1 | Team 2 | Team 3
 | Job Description |  | Day Shift | Eve Shift | Mid Shift
 | Day Shift | Shift Name | Main Day Shift | Day Cover | Day Cover
 |  | Code | A | B | C
 |  | Time of Shift | 0500 to 1300 | 0900 to 2100 | 2100 to 0900
 | Eve Shift | Shift Name | Eve Cover | Main Night Shift | Eve Cover
 |  | Code | D | E | F
 |  | Time of Shift | 0500 to 1700 | 1300 to 2100 | 1700 to 0500
 | Mid Shift | Shift Name | Mid Cover | Mid Cover | [NAME]
 |  | Code | G | H | I
 |  | Time of Shift | 0100 to 1300 | 1300 to 0100 | 2100 to 0500
 | Day Off Code |  | x | x | x
 | Pattern Start Date
 | Shift Pattern |  | GGAAAAAxxAAAAADDAAAAA | HHEEEEEBBEEEEExxEEEEE | xxIIIIICCIIIIIFFIIIII
Spreadsheet: 36261d1234129806-how-do-i-find-the-shortest-distance-between-x-y-coordinates-in-excel-emis_project_1-1-
Sheet: Sheet1

x | y | Distance |  | x | y | Distance
59 | 63 | 46.01086828130936 |  | 0 | 0 | 18.68154169226941
58 | 17 | 19 |  | 5 | 18 | 18.11077027627483
58 | 36 | 1 |  | 7 | 36 | 9.486832980505138
58 | 37 | 11 |  | 4 | 45 | 4.242640687119285
58 | 48 | 16.1245154965971 |  | 7 | 48 | 5
56 | 32 | 35.0142828000232 |  | 10 | 52 | 6.082762530298219
55 | 67 | 75.0066663703967 |  | 11 | 58 | 5.385164807134504
54 | -8 | 18 |  | 6 | 60 | 3.605551275463989
54 | 10 | 5.099019513592784 |  | 4 | 63 | 1
53 | 15 | 15.8113883008419 |  | 3 | 63 | 16.64331697709324
48 | 0 | 6.708203932499369 |  | 17 | 72 | 8
45 | -6 | 33.01514803843835 |  | 17 | 80 | 2.23606797749979
44 | 27 | 24 |  | 19 | 79 | 20.39607805437114
44 | 51 | 5 |  | 15 | 59 | 15.13274595042156
40 | 48 | 22 |  | 17 | 44 | 1.414213562373095
40 | 70 | 9 |  | 18 | 43 | 7.810249675906654
40 | 79 | 15.52417469626002 |  | 23 | 49 | 6.082762530298219
36 | 64 | 9.219544457292887 |  | 24 | 55 | 4.47213595499958
34 | 73 | 69.00724599634447 |  | 26 | 59 | 16.1245154965971
33 | 4 | 13.8924439894498 |  | 34 | 73 | 8.48528137423857
26 | 16 | 43 |  | 40 | 79 | 9
26 | 59 | 4.47213595499958 |  | 40 | 70 | 7.211102550927978
24 | 55 | 6.082762530298219 |  | 36 | 64 | 16.49242250247064
23 | 49 | 30.26549190084311 |  | 40 | 48 | 5
19 | 79 | 36.01388621073821 |  | 44 | 51 | 19.4164878389476
18 | 43 | 1.414213562373095 |  | 55 | 67 | 5.656854249492381
17 | 44 | 28 |  | 59 | 63 | 19.02629759044045
17 | 72 | 8 |  | 58 | 44 | 7
17 | 80 | 21.09502310972899 |  | 58 | 37 | 1
15 | 59 | 4.123105625617661 |  | 58 | 36 | 4.47213595499958
11 | 58 | 6.082762530298219 |  | 56 | 32 | 13
10 | 52 | 52.00961449578337 |  | 44 | 27 | 17.20465053408525
9 | 0 | 36.05551275463989 |  | 58 | 17 | 5.385164807134504
7 | 36 | 12 |  | 53 | 15 | 5.099019513592784
7 | 48 | 12.0415945787923 |  | 54 | 10 | 18
6 | 60 | 42.01190307520001 |  | 54 | -8 | 10
5 | 18 | 27.01851217221259 |  | 48 | 0 | 6.708203932499369
4 | 45 | 18 |  | 45 | -6 | 15.62049935181331
4 | 63 | 1 |  | 33 | 4 | 13.8924439894498
3 | 63 | 63.07138812488591 |  | 26 | 16 | 23.3452350598575
 |  |  |  | 9 | 0 | 9
Total Distance |  | 901.1914084994573 |  | 0 | 0
 |  |  |  |  |  | 409.9231496785756
These are all the points sorted x,y descending
 |  |  |  |  |  | these are the 40 points sorted in what I think may be the shortest route
Spreadsheet: 765127d1643186922-need-help-in-finding-any-formula-to-get-difference-of-in-and-out-timing-sample
Sheet: System extracted

Emp Number | Employee Name | Unique Code for Manual | Attendance Date | time | Status
SP-01 | A |  | 22/01/2022 | 07:00:00 | IN
SP-01 | A |  | 22/01/2022 | 15:15:00 | OUT
SP-01 | A |  | 23/01/2022 | 07:05:00 | IN
SP-01 | A |  | 23/01/2022 | 13:00:00 | OUT
SP-01 | A |  | 25/01/2022 | 09:00:00 | IN
SP-01 | A |  | 25/01/2022 | 15:15:00 | OUT
SP-06 | B |  | 22/01/2022 | 07:22:00 | IN
SP-06 | B |  | 22/01/2022 | 15:15:00 | OUT
SP-06 | B |  | 23/01/2022 | 10:00:00 | IN
SP-06 | B |  | 23/01/2022 | 15:15:00 | OUT
SP-06 | B |  | 25/01/2022 | 08:00:00 | IN
SP-06 | B |  | 25/01/2022 | 15:15:00 | OUT
SP-07 | C |  | 22/01/2022 | 07:22:00 | IN
SP-07 | C |  | 22/01/2022 | 15:15:00 | OUT
SP-07 | C |  | 23/01/2022 | 07:22:00 | IN
SP-07 | C |  | 23/01/2022 | 15:15:00 | OUT
SP-07 | C |  | 25/01/2022 | 07:22:00 | IN
SP-07 | C |  | 25/01/2022 | 15:15:00 | OUT
SP-09 | D |  | 22/01/2022 | 07:22:00 | IN
SP-09 | D |  | 22/01/2022 | 15:15:00 | OUT
SP-09 | D |  | 23/01/2022 | 07:22:00 | IN
SP-09 | D |  | 23/01/2022 | 15:15:00 | OUT
SP-09 | D |  | 25/01/2022 | 07:22:00 | IN
SP-09 | D |  | 25/01/2022 | 15:15:00 | OUT
Spreadsheet: 844995d1696577901-sum-column-with-two-criteria-testfile
Sheet: Sheet1

 |  |  | Items |  | Sub total
Person 1 | Item: 3 |  | 8.775
Person 1 | Item: 3 |  | 5.655
Person 1 | Item: 23 |  | 46.44
Person 1 | Item: 23 |  | 288.72
Person 1 | Item: 36 |  | 531.51
Person 1 | Item: 36 |  | 54.06
Person 1 | Item: 44 |  | 42
Person 1 | Item: 4001 |  | 25.17
Person 1 | Item: 10997 |  | 9.42
Person 1 | Item: 16500 |  | 72.825
Person 1 | Item: 30062 |  | 16.965
Person 1 | Item: 30219 |  | 8.985
Person 1 | Item: 91858 |  | 12
Person 1 | Item: 91891 |  | 30.96
Person 1 | Item: 91891 |  | 141.36
Person 1 | Item: 92138 |  | 25.17
Person 1 | Item: 93203 |  | 3.75
Person 2 | Item: 23 |  | 693
Person 2 | Item: 36 |  | 689.91
Person 2 | Item: 44 |  | 38.34
Person 2 | Item: 44 |  | 42
Person 2 | Item: 699 |  | 36.04
Person 2 | Item: 721 |  | 73.2
Person 2 | Item: 723 |  | 54.24
Person 2 | Item: 732 |  | 39.56
Person 2 | Item: 900 |  | 50.88
Person 2 | Item: 2701 |  | 34.68
Person 2 | Item: 2712 |  | 53.37
Person 2 | Item: 2713 |  | 26.685
Person 2 | Item: 2713 |  | 47.13
Person 2 | Item: 10997 |  | 10.52
Person 2 | Item: 10997 |  | 9.42
Person 2 | Item: 11707 |  | 29.82
Person 2 | Item: 30071 |  | 17.715
Person 2 | Item: 30071 |  | 48.9
Person 2 | Item: 30219 |  | 16.62
Person 2 | Item: 31363 |  | 68.22
Person 2 | Item: 73806 |  | 8.65
Person 2 | Item: 91890 |  | 5.655
Person 2 | Item: 91891 |  | 378.36
Person 2 | Item: 91891 |  | 15.48
Person 2 | Item: 93680 |  | 15.48
Spreadsheet: 722913d1615457182-is-there-a-way-to-make-the-cells-formulas-select-dynamic-sample
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | Average
 |  |  |  |  |  |  |  |  |  |  | Above 8
 |  |  |  |  |  |  |  |  |  |  | Above 9
 |  |  |  |  |  |  |  |  |  |  | Above 10
 |  |  |  |  |  |  |  |  |  |  |  | Above 8 | Above 9 | Above 10 | Year
 |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 2015
 |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 2015
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 0 | 2018
 |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 2019
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 2018
 |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 0 | 2015
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 2016
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 0 | 2016
Spreadsheet: 708050d1607600599-matching-a-substring-returning-value-from-matched-row-but-different-column-test_sheet
Sheet: Sheet1

INPUTS |  |  |  |  |  |  |  |  |  | OUTPUTS
Default | d01 | d02 | d03 | d04 |  |  |  |  |  | tom_version_1 |  |  |  |  | version_1 values
version_1 | v101 | v102 | v103 | v104 |  |  |  |  |  | kate_version_4 |  |  |  |  | version_4 values
version_2 | v201 | v202 | v203 | v204 |  |  |  |  |  | maria_new_version |  |  |  |  | Default values
version_3 | v301 | v302 | v303 | v304 |  |  |  |  |  | new_version_2
version_4 | v401 | v402 | v403 | v404 |  |  |  |  |  | new_version_3
version_5 | v501 | v502 | v503 | v504 |  |  |  |  |  | new_version_5
version_10 | v1001 | v1002 | v1003 | v1004 |  |  |  |  |  | new_version_10
 |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 783780d1655137528-using-iferror-and-unique-to-create-a-summary-table-2022-06-13-oeldere-benhornsby2021-voucher-tracker2
Sheet: Pivot table

Som [NAME] issued | Kolomlabels
Rijlabels | Atrax | Elecmobile | [NAME] | PolyCarbon | Works4Youth | Eindtotaal
[NAME] |  |  | 2 |  |  | 2
[NAME] | 2 |  |  |  |  | 2
[NAME] | 3 | 3 |  |  |  | 6
[NAME] |  |  |  |  | 4 | 4
[NAME] | 1 |  |  |  |  | 1
[NAME] |  |  |  | 5 |  | 5
Eindtotaal | 6 | 3 | 2 | 5 | 4 | 20
Spreadsheet: 823495d1679992986-number-of-suppliers-grouped-and-not-grouped-book1
Sheet: Sheet1

Category L1 / L2 / Supplier
Logistics | How many suppliers are under [NAME]? | How many suppliers are not grouped under [NAME]?
[NAME] | 18 | 7
Supplier 1
Supplier 2
Supplier 3
Supplier 4
Supplier 5
Supplier 6
Supplier 7
Supplier 8
Supplier 9
Supplier 10
Supplier 11
Supplier 12
Supplier 13
Supplier 14
Supplier 15
Supplier 16
Supplier 17
Supplier 18
Spreadsheet: 1c238db8-173c-498c-9563-f4eb6bbf25d2
Sheet: 13d

 | Swap Dealers/MSPs5 |  |  | Others
Product1 | HY6 | IG | Other | HY | IG | Other
Index Tranche | 70415 | 749941 | 709528 | 16704 | 75776 | 108479
Index | 880200 | 3912333 | 5901095 | 373234 | 1248359 | 1606802
Asia | 0 | 0 | 174706 | 0 | 0 | 48016
Europe | 0 | 0 | 5170429 | 0 | 0 | 1453499
North America | 880200 | 3912333 | 153605 | 373234 | 1248359 | 45198
Other | 0 | 0 | 402355 | 0 | 0 | 60089
OTHER* | 0 | 0 | 1094217 | 0 | 0 | 500375
TOTAL | 950615 | 4662274 | 7704840 | 389938 | 1324135 | 2215656
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 110307d1307020350-add-rows-with-macro-book2
Sheet: RentRoll

 | Test Property 1
 | 123 Main St.
 | New York, NY
 | Type | Suite | Building | [NAME] | Status | Annual Rent | Rent PSF | Mkt Rent PSF | Mkt Annual Rent | Square Feet | Lease Start | Lease End | % Rent | Breakpoint | CAM | Utilities | Taxes | Insurance | Other Recoveries | Renewal Options | Credit | Termination Options | Go Dark Clause | 1st Rent Step | 1st Step Date | 2nd Rent Step | 2nd Step Date | 2nd Rent Step | 2nd Step Date | 3rd Rent Step | 3rd Step Date | 3rd Rent Step | 3rd Step Date | 4th Rent Step | 4th Step Date | 4th Rent Step | 4th Step Date | 5th Rent Step | 5th Step Date | 5th Rent Step | 5th Step Date | 6th Rent Step | 6th Step Date | 6th Rent Step | 6th Step Date | 7th Rent Step | 7th Step Date | 7th Rent Step | 7th Step Date | 8th Rent Step | 8th Step Date | 8th Rent Step | 8th Step Date | 9th Rent Step | 9th Step Date | 9th Rent Step | 9th Step Date | 10th Rent Step | 10th Step Date
 |  |  |  |  |  |  |  |  |  |  |  |  | 0.05
 |  |  |  |  |  | Units | SF | Annual Rent | Monthly Rent | Mkt Annual Rent
 |  |  |  |  | Occupied
 |  |  |  |  | Vacant
 |  |  |  |  | Total
Spreadsheet: 874709d1721240784-index-match-w-multiple-results-book2
Sheet: Sheet1

 | [NAME] | [NAME] | Smith | Murdoch | [NAME] | [NAME] | Simpson | Brewer | Dickinson | [NAME] | Bowes | Eudy | Hogan | Sampson | Orton | Jamieson | Cricks | Griffith | [NAME] | Fawcett | Quinn | Wayne | Moreau | [NAME] | Franklin | Bean | Ferrell | Neutron | Leblanc | Malik | [NAME] | Styles | Fredericks | Carver | Washington | Davies | Deanna
Family |  |  |  |  |  |  |  |  | [NAME] |  | Harold |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Gene
 |  |  |  |  |  |  |  |  | [NAME] |  | Cathy |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | Adam |  | Fred |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Julie
Spreadsheet: 117474d1312819451-need-to-find-last-active-row-in-excel-orderform
Sheet: Customer Order Form

 | Recrods | Records
 | [PHONE] | 4854
 | [PHONE] | 4855
 | [PHONE] | 4857
 | [PHONE] | 4858
 | [PHONE] | 4859
 | [PHONE] | 4860
 | [PHONE] | 4861
 | [PHONE] | 4862
 | [PHONE] | 4863
 | [PHONE] | 4864
 | [PHONE] | 4865
 | [PHONE] | 4866
 | [PHONE] | 4867
 | [PHONE] | 4868
 | [PHONE] | 4869
 | [PHONE] | 4870
 | [PHONE] | 4871
 | [PHONE] | 4872
 | [PHONE] | 4873
 | [PHONE] | 4874
 | [PHONE] | 4875
 | [PHONE] | 4876
 | [PHONE] | 4877
 | [PHONE] | 4878
 | [PHONE] | 4879
 | [PHONE] | 4880
 | [PHONE] | 4881
 | [PHONE] | 4882
Daclaration text | Daclaration text
Daclaration text | Daclaration text
Daclaration text | Daclaration text
Daclaration text | Daclaration text
Daclaration text | Daclaration text
Spreadsheet: cf4c83c9-3556-4e95-a5f7-96f416718eca
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5369 | 15346 | Romina | [NAME] | ARG | 41 | 00:23:53 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 02:25:16
5369 | 12798 | Carolina | [NAME] | BRA | 46 | 00:23:38 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 02:26:29
5369 | 22214 | [NAME] | [NAME] | CHI | 42 | 00:23:33 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 3 | 02:30:22
5369 | 9915 | Fernanda | Bau | BRA | 44 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 4 | 02:31:03
5369 | 28120 | [NAME] | Martincowski | BRA | 43 | 00:23:52 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 5 | 02:32:28
Spreadsheet: mary_fischer__25736__Browns and Giants Amort
Sheet: Browns Amort Sch

EES - Cleveland Browns
Cleveland Browns Amortization Schedule for Sponsorship Payments
[NAME] : Completed June 2004
Date |  | Payment | Amortization Schedule | Balance on BS
1999-06-01 00:00:00 | 1&2
1999-07-01 00:00:00 |  |  | 28333.33333333334
1999-08-01 00:00:00 |  |  | 28333.33333333334
1999-09-01 00:00:00 |  |  | 28333.33333333334
1999-10-01 00:00:00 |  |  | 28333.33333333334
1999-11-01 00:00:00 |  |  | 28333.33333333334
1999-12-01 00:00:00 |  |  | 28333.33333333334
2000-01-01 00:00:00 |  |  | 28333.33333333334
2000-02-01 00:00:00 |  |  | 28333.33333333334
2000-03-01 00:00:00 |  |  | 28333.33333333334
2000-04-01 00:00:00 |  |  | 28333.33333333334
2000-05-01 00:00:00 |  |  | 28333.33333333334
2000-06-01 00:00:00 | 2 |  | 28333.33333333334
2000-07-01 00:00:00 |  |  | 20000
2000-08-01 00:00:00 |  |  | 20000
2000-09-01 00:00:00 |  |  | 20000
2000-10-01 00:00:00 |  |  | 20000
2000-11-01 00:00:00 |  |  | 20000
2000-12-01 00:00:00 |  |  | 20000
2001-01-01 00:00:00 |  |  | 20000
2001-02-01 00:00:00 |  |  | 20000
2001-03-01 00:00:00 |  |  | 20000
2001-04-01 00:00:00
2001-05-01 00:00:00 |  |  | 20000
2001-06-01 00:00:00 | 2 |  | 20000
2001-07-01 00:00:00 |  |  | 20000
2001-08-01 00:00:00 |  |  | 20000
2001-09-01 00:00:00 |  |  | 20000
2001-10-01 00:00:00 |  |  | 20000
2001-11-01 00:00:00 |  |  | 20000
2001-12-01 00:00:00 |  |  | 20000
2002-01-01 00:00:00 |  |  | 20000
2002-02-01 00:00:00 |  |  | 20000
2002-03-01 00:00:00 |  |  | 20000
2002-04-01 00:00:00 |  |  | 20000
2002-05-01 00:00:00 |  |  | 20000
2002-06-01 00:00:00 | 2 |  | 20000
2002-07-01 00:00:00 |  |  | 20000
2002-08-01 00:00:00 |  |  | 20000
2002-09-01 00:00:00 |  |  | 20000
2002-10-01 00:00:00 |  |  | 20000
2002-11-01 00:00:00 |  |  | 20000
2002-12-01 00:00:00 |  |  | 20000
2003-01-01 00:00:00 |  |  | 20000
2003-02-01 00:00:00 |  |  | 20000
2003-03-01 00:00:00 |  |  | 20000
2003-04-01 00:00:00 |  |  | 20000
2003-05-01 00:00:00 |  |  | 20000
2003-06-01 00:00:00 | 2 |  | 20000
2003-07-01 00:00:00 |  |  | 20000
2003-08-01 00:00:00 |  |  | 20000
2003-09-01 00:00:00 |  |  | 20000
2003-10-01 00:00:00 |  |  | 20000
2003-11-01 00:00:00 |  |  | 20000
2003-12-01 00:00:00 |  |  | 20000
2004-01-01 00:00:00 |  |  | 20000
2004-02-01 00:00:00 |  |  | 20000
2004-03-01 00:00:00 |  |  | 20000
2004-04-01 00:00:00 |  |  | 20000
2004-05-01 00:00:00 |  |  | 20000
2004-06-01 00:00:00 |  |  | 20000
 | 1 | 1.2 Million dollar sponsorship pymt over 5 years paid 7/1/1999 plus
 | 2 | 100k sponsorship payment each year for 5 years beginning
 |  | 7/1/99 and ending 7/1/2004
As of 4/01 only the $1.3 million had been paid - thus that is all we are amortizing.
Spreadsheet: 0a91bd08-ff8e-4bd6-925c-d4b326997d95
Sheet: Sheet1

Attachment A: Itemized Cost Proposal | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Vendor Name: |  |  |  |  |  | Enter mode-specific details in yellow cells below as prompted. All other cells are locked.
1.  [NAME], Base Models  Refer to RFP Section III.A for additional instructions, and to Attachment A-2 below for configuration specifications.
[NAME] | Configuration [Per Att A-2] | Proposed Model |  | Monthly Lease Price | Likely # / type in Fleet | Extended Price (36 mo) | Model Comments
Color 55 PPM | Type 1 | [vendor [NAME] |  |  | 2 | 0
Color 65 PPM | Type 1 | [vendor [NAME] |  |  | 1 | 0
B&W 45 PPM | Type 1 | [vendor [NAME] |  |  | 11 | 0
B&W 55 PPM | Type 1 | [vendor [NAME] |  |  | 8 | 0
B&W 65 PPM | Type 1 | [vendor [NAME] |  |  | 11 | 0
B&W 75 PPM | Type 1 | [vendor [NAME] |  |  | 6 | 0
B&W 85 PPM | Type 1 | [vendor [NAME] |  |  | 2 | 0
B&W 135 PPM | Type 2 | [vendor [NAME] |  |  | 2 | 0
 |  |  |  | 3-Year Lease Subtotal: |  | 0
2.  [NAME], Optional Accessories  [NAME] to RFP Section III.A for additional instructions.
[NAME] | Accessory |  |  |  | Likely # / type in Fleet | Extended Price       (36 mo) | Accessory Comments
 | Large Capacity Paper Supply | Saddle Stitch Finisher | 2 or 3 Hole Punch Finisher | Fax Board
Color 55 PPM |  |  |  |  | 2 | 0
Color 65 PPM |  |  |  |  | 1 | 0
B&W 45 PPM |  |  |  |  | 11 | 0
B&W 55 PPM |  |  |  |  | 8 | 0
B&W 65 PPM |  |  |  |  | 11 | 0
B&W 75 PPM |  |  |  |  | 6 | 0
B&W 85 PPM |  |  |  |  | 2 | 0
 |  |  |  | 3-Year Lease Subtotal: |  | 0
3.  Maintenance & Supplies  Refer to RFP Section III.B for additional instructions.
 |  |  | Click Type | Per-Click Price | Estimated # Annual Clicks | Extended Price       (36 mo) | Comments
 |  |  | Color Clicks |  | 150000 | 0
 |  |  | B&W Clicks |  | 10000000 | 0
 |  |  | 3-Year estimated Maint Subtotal: |  |  | 0
 |  |  | COST SUMMARY
 |  |  | Base Equiment Lease: |  |  | 0
 |  |  | Oppitional Assessory Lease: |  |  | 0
 |  |  | Estimated Maintenance & Supply: |  |  | 0
 |  |  | 3-Year Projected Total: |  |  | 0
Spreadsheet: 129126d1321461490-excel-2007-pivot-table-counting-unique-values-in-a-row-and-grouping-start-and-end-dates-example
Sheet: Fake Pivot Table

This is a fakepivot table that i want it to look like
Customer | (Filter)
Data from start and end date |  | These are unique counts, so only count project or architect once per month
Year | Month | No.of projects open | No.of techs | Average hours per month
2010 | Nov | Data | Data | Data
 | Dec | Data | Data | Data
2011 | Jan | Data | Data | Data
 | Feb | Data | Data | Data
 | Mar | Data | Data | Data
 | Apr | Data | Data | Data
 | May | Data | Data | Data
 | Jun | Data | Data | Data
 | Jul | Data | Data | Data
 | Aug | Data | Data | Data
 | Sep | Data | Data | Data
 | Oct | Data | Data | Data
 | Nov | Data | Data | Data
Spreadsheet: 711921d1609967925-reorganizing-unorganized-data-sample-copy-3-
Sheet: SUMMARY

 | Snow | Rain | High Temp | Low Temp | Temp Change |  | DM06 |  |  |  |  | DM07 |  |  |  |  | DM08 |  |  |  |  | DM09 |  |  |  |  | DM10 |  |  |  |  | [NAME] |  |  |  |  | DM12 |  |  |  |  | DM13 |  |  |  |  | DM14 |  |  |  |  | DM15 |  |  |  |  | DM16 |  |  |  |  | [NAME] |  |  |  |  | DM18 |  |  |  |  | DM19 |  |  |  |  | [NAME] |  |  |  |  | DM31 |  |  |  |  | DM32 |  |  |  |  | DM33 |  |  |  |  | DM34 |  |  |  |  | DM35 |  |  |  |  | DM36 |  |  |  |  | DM37 |  |  |  |  | DM38 |  |  |  |  | DM39 |  |  |  |  | DM40 |  |  |  |  | DM41 |  |  |  |  | DM42 |  |  |  |  | DM43 |  |  |  |  | DM44 |  |  |  |  | DM45 |  |  |  |  | DM46 |  |  |  |  | DM47 |  |  |  |  | DM48 |  |  |  |  | DM49 |  |  |  |  | DM50
Date | [NAME] | [NAME] | °C | °C | °C |  | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline | N | E | Z | Δ Last | Δ Baseline
2020-06-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1000 | 50000 | 300 |  |  | 1001 | 50001 | 301
2020-06-16 00:00:00
2020-06-20 00:00:00
2020-06-26 00:00:00
2020-07-03 00:00:00
2020-07-10 00:00:00
2020-07-17 00:00:00
2020-07-24 00:00:00
2020-07-31 00:00:00
2020-08-07 00:00:00
2020-08-14 00:00:00
2020-08-21 00:00:00
2020-08-28 00:00:00
2020-09-04 00:00:00
2020-09-11 00:00:00
2020-09-18 00:00:00
2020-10-08 00:00:00
2020-11-10 00:00:00
2020-12-09 00:00:00
Spreadsheet: 824160d1680343741-calculating-an-amount-to-withhold-from-paycheck-deduction-calculator
Sheet: Sheet1

The rates of Shortages applicable are as follows:
RATES OF NORMAL SHORTAGES FOR INDIVIDUALS
Exceeds | Does not exceed |  |  |  |  |  | Shortage | 200 |  |  |  | 200
Shortages |  |  |  | Rates |  |  |  | 250 |  |  |  | 204.5
 |  |  |  |  |  |  |  | 350 |  |  |  | 209
0 | 200 | 200 | 0 | E200 + 0% of the excess of 0 |  |  |  | 450 |  |  |  | 210
201 | 250 | 200 | 0.09 | E200 + 0% of the excess of 200
 | 300 | 200 | 0.08 | E200 + 0% of the excess of 250 |  |  | Payment
 | 350 | 200 | 0.07 | E200 + 0% of the excess of 300
 | 400 | 200 | 0.06 | E200 + 0% of the excess of 350
 | 450 | 200 | 0.05 | E200 + 0% of the excess of 400
 | 500 | 200 | 0.04 | E200 + 0% of the excess of 450
 | 550 | 200 | 0.03 | E200 + 0% of the excess of 500
 |  | 200 | 0.02 | E200 + 0% of the excess of 550
Spreadsheet: 45509d1244226532-vlookup-order-list-test-5-2
Sheet: PRO

2 | Product | Weight (kg) | Price (USD) | Quantity | Price (HKD)
0 | SANYO
3 | PLV-Z700C | 14 | 1476.683937823834 | 1 | 11400
0 | PLV-Z3000 | 14 | 2176.165803108808 | 0 | 16800
0 | PLC-XU105 | 9 | 1347.150259067358 | 0 | 10400
0 | PLC-XU115 | 9 | 1515.544041450777 | 0 | 11700
0 | PLC-XT21 | 12 | 2072.538860103627 | 0 | 16000
 | HITACHI
0 | CP-X264 | 6 | 654.1450777202073 | 0 | 5050
0 | CP-X201 | 7 | 608.8082901554404 | 0 | 4700
0 | CP-X417 | 8 | 867.8756476683939 | 0 | 6700
0 | [NAME] | 6 | 699.4818652849741 | 0 | 5400
0 | CP-X301 | 8 | 751.2953367875648 | 0 | 5800
0 | CP-X308 | 8 | 841.9689119170985 | 0 | 6500
 | PANASONIC
0 | PT-AE3000 | 15 | 2564.766839378238 | 0 | 19800
0 | PT-LB75NT | 7 | 1269.430051813471 | 0 | 9800
0 | PT-LB80EA | 8 | 1321.243523316062 | 0 | 10200
0 | PT-LB80NT | 8 | 1476.683937823834 | 0 | 11400
0 | PT-F200EA | 12 | 1696.891191709845 | 0 | 13100
0 | PT-F200NT | 12 | 1528.497409326425 | 0 | 11800