tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 736066d1623336557-id-like-to-get-data-from-one-worksheet-to-another-without-the-blanks-using-a-formula-test-excel-without-blank-cells
Sheet: Table1

Volgnummer | Periode | Weeknr | Tdatum | Opleiding | [NAME] | Omschrijving | Van | Tot | Lokatie | E_Lokatie | Soort | Aantal deelnemers | Verdeling | ZP23
Test | P4 | Test | 2021-06-07 00:00:00 | Test | Test | Test | 0.520833333333333 | 0.604166666666667 | ZP23/C201 |  | Test | Test | Test | True
Test | P4 | Test | 2021-06-08 00:00:00 | Test | Test | Test | 0.520833333333333 | 0.604166666666667 | ZP23/J009 | ZP23/J011 | Test | Test | Test | True
Test | P4 | Test | 2021-06-08 00:00:00 | Test | Test | Test | 0.520833333333333 | 0.604166666666667 | ZP23/J009 | ZP23/J011 | Test | Test | Test | True
Test | P4 | Test | 2021-06-08 00:00:00 | Test | Test | Test | 0.520833333333333 | 0.604166666666667 | ZP23/J009 | ZP23/J011 | Test | Test | Test | True
Test | P4 | Test | 2021-06-08 00:00:00 | Test | Test | Test | 0.541666666666667 | 0.885416666666667 | ZP07/F202 | ZP23/B202, C201, ZP11: A120, B138, A133, B120, ZP09: D112, D219 | Test | Test | Test | True
Spreadsheet: 846746d1697894840-problem-using-sumproduct-and-match-to-rank-golf-teams-scores-if-the-scores-are-drawn-scoresheettest
Sheet: AdminLists

 | Teams |  | Rank |  | Players |  | Position |  | Points |  | Increment
 | Divots'R'Us |  | 1 |  | Barvey, [NAME] |  | 1 |  | 8 |  | 0.008
 | Oliver's Army |  | 2 |  | Bibb, [NAME] |  | 2 |  | 7 |  | 0.007
 | The 49ers |  | 3 |  | Bright, [NAME] |  | 3 |  | 6 |  | 0.006
 | The Blue Villains |  | 4 |  | Burford, [NAME] |  | 4 |  | 5 |  | 0.005
 | The Fab Four |  | 5 |  | Cerfontyne, [NAME] |  | 5 |  | 4 |  | 0.004
 | The Longshots |  | 6 |  | Conroy, Clive |  | 6 |  | 3 |  | 0.003
 |  |  | 7 |  | Copley, [NAME] |  | 7 |  | 2 |  | 0.002
 |  |  | 8 |  | Crump, [NAME] |  | 8 |  | 1 |  | 0.001
 |  |  |  |  | [NAME], [NAME]
 |  |  |  |  | Eamonson, [NAME]
 |  |  |  |  | Green, [NAME]
 |  |  |  |  | Hamer,[NAME]
 |  |  |  |  | [NAME], [NAME]
 |  |  |  |  | Jones, [NAME]
 |  |  |  |  | Maiden, [NAME]
 |  |  |  |  | Meakin, [NAME]
 |  |  |  |  | [NAME], [NAME]
 |  |  |  |  | Nimmo, [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | Parish, [NAME]
 |  |  |  |  | Pratt, [NAME]
 |  |  |  |  | Rex, Clive
 |  |  |  |  | Rogers, [NAME]
 |  |  |  |  | Rooke, [NAME]
 |  |  |  |  | Salt, [NAME]
 |  |  |  |  | Smith, [NAME]
 |  |  |  |  | [NAME], [NAME]
 |  |  |  |  | [NAME], [NAME]
 |  |  |  |  | [NAME], [NAME]
Spreadsheet: 486651d1477592683-create-tabs-from-list-add-data-to-worksheet-sample-evals
Sheet: Weighted Averages

Quarterly Evaluation
Category | Description | Weight | Employee 1 | Employee 2 | Employee 3 | Employee 4 | Employee 5 | Employee 6 | Employee 7 | Employee 8 | Employee 9 | Employee 10 | Employee 11 | Employee 12 | Employee 13
1 | Details 1 Details 2 | 0.25 | 2 | 5 | 3 | 2 | 2 | 4 | 3 | 3 | 2 | 2 | 2 | 5 | 3
2 | Details 3 Details 4 | 0.3 | 5 | 5 | 2 | 4 | 2 | 4 | 3 | 2 | 2 | 3 | 5 | 3 | 5
3 | More info here Random Thought | 0.3 | 4 | 5 | 3 | 4 | 3 | 4 | 3 | 2 | 2 | 5 | 5 | 2 | 3
4 | [NAME] again Different thought | 0.15 | 3 | 5 | 5 | 4 | 3 | 4 | 3 | 2 | 4 | 4 | 3 | 3 | 3
Weighted Average
Bonus Amt
Bonus Ranges
Min | [NAME] | $
0 | 3 | 0
 | 3.3 | 80
 | 3.6 | 100
 | 3.8 | 120
 | 4.2 | 140
 | 4.5 | 160
 | 4.8 | 180
 | 5 | 200
Spreadsheet: 711377d1609666569-find-next-value-multiple-match-test-file
Sheet: Sheet1

Product | Date | Grade | Stock |  |  | Stock-Result
Switch | 2020-04-04 00:00:00 | 1 | 232 |  |  | 170 | 1
Plug | 2020-12-12 00:00:00 | 3 | 248 |  |  | 208 | 2
Holder | 2020-04-12 00:00:00 | 3 | 213 | 3 |  | 213 | 3
Plate | 2020-08-03 00:00:00 | 2 | 255 |  |  | 274 | 4
Holder | 2020-04-04 00:00:00 | 1 | 315 |  |  | 342 | 5
Plate | 2020-08-03 00:00:00 | 2 | 238
Holder | 2020-08-03 00:00:00 | 1 | 197
Wire | 2020-04-04 00:00:00 | 2 | 233
Plug | 2020-08-03 00:00:00 | 3 | 235
Holder | 2020-04-12 00:00:00 | 3 | 208 | 2
Wire | 2020-08-03 00:00:00 | 1 | 269
Plug | 2020-04-04 00:00:00 | 3 | 155
Holder | 2020-04-12 00:00:00 | 3 | 342 | 5
Plate | 2020-08-03 00:00:00 | 2 | 295
Holder | 2020-08-03 00:00:00 | 1 | 224
Wire | 2020-04-04 00:00:00 | 3 | 305
Plug | 2020-08-03 00:00:00 | 2 | 294
Holder | 2020-04-12 00:00:00 | 3 | 274 | 4
Wire | 2020-08-03 00:00:00 | 1 | 249
Plug | 2020-04-04 00:00:00 | 2 | 230
Holder | 2020-04-12 00:00:00 | 3 | 170 | 1
Spreadsheet: 790258d1659614427-filtering-students-based-on-conditions-and-construct-a-table-another-case
Sheet: First Attempt

No. | Student Name |  |  |  |  |  |  |  |  |  |  | Second |  |  |  |  |  |  |  |  |  | Stage |  |  |  |  |  |  |  |  |  |  |  | P3 |  |  | P2 |  |  | P1
 |  |  |  |  |  |  |  |  |  |  |  | First |  |  |  |  |  |  | Semester: |  |  |  |  |  |  |  |  | Second |  |  |  |  |  |  | Semester:
 |  |  |  |  |  |  |  |  |  |  |  | Sub.1 | Sub.2 | Sub.3 | Sub.4 | Sub.5 | Sub.6 | Sub.7 | Sub.8 | Sub.9 | Sub.10 | Sub.11 | Sub.12 | Sub.13 | Sub.14 | Result |  | sub.1 | sub.2 | [NAME] | sub.4 | sub.5 | sub.6 | sub.7 | sub.8 | sub.9 | sub.10 | sub.11 | sub.12 | sub.13 | sub.14 | Reesult
 |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14
 | Student name 1 |  |  |  |  |  |  |  |  |  |  | 50 | 35 | 40 | 67 | 77 | 51 |  |  |  |  |  |  |  | 55 | Failed |  | 65 | 87 | 39 | 45 | 66 | 49 |  |  |  |  |  |  |  |  | Failed
 | student name 2 |  |  |  |  |  |  |  |  |  |  | 48 | 52 |  | 61 | 40 | 77 |  |  |  |  |  | 45 |  | 35 | Failed |  | 50 | 35 | 40 | 67 | 77 | 51 |  |  |  |  |  |  |  |  | Failed
 | Student name 3 |  |  |  |  |  |  |  |  |  |  | 80 | 42 | 50 | 67 | 77 | 91 |  |  |  |  |  |  | 67 |  | Failed |  | 48 | 52 |  | 61 | 40 | 77 |  |  |  |  |  |  |  |  | Failed
 | Student name 4 |  |  |  |  |  |  |  |  |  |  | 45 |  | 66 | 37 | 50 | 25 |  |  |  |  |  |  |  |  | Failed |  | 80 | 42 | 50 | 67 | 77 | 91 |  |  |  |  |  |  |  |  | Failed
 | Student name 5 |  |  |  |  |  |  |  |  |  |  | 77 | 80 | 62 | 87 | 66 | 50 |  |  |  |  |  |  | 77 |  | Passed |  | 76 |  | 66 | 37 | 50 | 25 |  |  |  |  |  |  |  |  | Failed
 | Student name 6 |  |  |  |  |  |  |  |  |  |  | 47 | 54 | 67 | 50 | 58 | 44 |  |  |  |  |  |  |  |  | Failed |  | 77 | 80 | 44 | 30 | 39 | 50 |  |  |  |  |  |  |  |  | Failed
 | Student name 7 |  |  |  |  |  |  |  |  |  |  | 65 | 87 | 39 | 45 | 66 | 49 |  |  |  |  |  |  |  |  | Failed |  | 47 | 54 | 67 | 50 | 58 | 44 |  |  |  |  |  |  |  |  | Failed
 | Student name 8 |  |  |  |  |  |  |  |  |  |  | 50 | 35 | 40 | 67 | 77 | 51 |  |  |  |  |  |  |  |  | Failed |  | 65 | 87 | 39 | 45 | 66 | 49 |  |  |  |  |  |  |  |  | Failed
 | Student name 9 |  |  |  |  |  |  |  |  |  |  | 48 | 52 |  | 61 | 40 | 77 |  |  |  |  |  |  |  |  | Failed |  | 50 | 67 | 55 | 67 | 77 | 51 |  |  |  |  |  |  |  |  | Passed
 | Student name 10 |  |  |  |  |  |  |  |  |  |  | 80 | 42 | 50 | 67 | 77 | 91 |  |  |  |  |  |  |  |  | Failed |  | 48 | 52 |  | 61 | 40 | 77 |  |  |  |  |  |  |  |  | Failed
Spreadsheet: eric_saibi__9792__020602
Sheet: Saint Lucie 02

Owner Name | Florida Power and Light Company
Station Name | Saint Lucie Nuclear Power Station
Unit Name | Saint Lucie 02
NERC Region | FRCC
State | FL
Fuel Type | Nuclear
Capacity | 850 MW
Start Date | 2002-02-04 00:00:00
End Date | 2/6/02 am
Comments | Unplanned Maintenance
SIC | 4911
Plant ID | 1016650
Unit ID | 1004843
Outage ID | 19790
Spreadsheet: 123346d1317591514-excel-2007-calculating-bonus-formula-orders
Sheet: August

August Phone
 |  |  |  |  |  |  |  |  | Amt$ till 30K | Amt$ till 50K
Date | Order # | Amount | Item # | Qty | Type | Payment | $20 Bonus
2011-08-16 00:00:00 | 2626 | 1417 | D150H | 1 | Phone | Recv'd
2011-08-16 00:00:00 | 2631 | 757 | JL4 | 1 | Phone | Recv'd
2011-08-16 00:00:00 | 2639 | 983 | JL8 | 1 | Phone | Recv'd
2011-08-18 00:00:00 | 2685 | 2327 | 250RTB | 1 | Phone | Recv'd | 20 |  | Bonus | Bonus |  | Bonus Met | NO
2011-08-18 00:00:00 | 2697 | 987 | JL6 | 1 | Phone | Recv'd
2011-08-19 00:00:00 | 2722 | 2804 | J150A | 2 | Phone | Recv'd
2011-08-24 00:00:00 | 2872 | 2327 | 250RTB | 1 | Phone | Recv'd | 20 |  |  |  |  | $20 Bonus
2011-08-24 00:00:00 | 2882 | 1057 | D150A | 1 | Phone | Recv'd
2011-08-24 00:00:00 | 2883 | 947 | JL5 | 1 | Phone | Recv'd
2011-08-24 00:00:00 | 2887 | 2077 | TS8 | 1 | Phone | Recv'd
2011-08-24 00:00:00 | 2888 | 2097 | SL22 | 1 | Phone | Recv'd
2011-08-25 00:00:00 | 2902 | 797 | JL8 | 1 | Phone | Recv'd
2011-08-25 00:00:00 | 2908 | 1057 | D150A | 1 | Phone | Recv'd
2011-08-26 00:00:00 | 2927 | 947 | JL5 | 1 | Phone | Recv'd
2011-08-26 00:00:00 | 2936 | 757 | JL4 | 1 | Phone | Recv'd
2011-08-26 00:00:00 | 2938 | 1137 | WYT16 | 1 | Phone | Recv'd
2011-08-29 00:00:00 | 3012 | 947 | JL5 | 1 | Phone | Recv'd
2011-08-29 00:00:00 | 3015 | 1107 | D150D | 1 | Phone | Recv'd
Total
August Online
Date | Order # | Amount | Item # | Qty | Type | Payment | $20 Bonus
2011-08-15 00:00:00 | 2607 | 987 | D150E | 1 | Online | Recv'd
2011-08-17 00:00:00 | 2650 | 797 | JL8 | 1 | Online | Recv'd
2011-08-17 00:00:00 | 2671 | 797 | JL4 | 1 | Online | Recv'd
2011-08-18 00:00:00 | 2694 | 757 | JL4 | 1 | Online | Recv'd
2011-08-19 00:00:00 | 2717 | 797 | JL8 | 1 | Online | Recv'd
2011-08-23 00:00:00 | 2839-1 | 1197 | K110 | 1 | Online | Recv'd
2011-08-23 00:00:00 | 2842 | 4367 | [NAME] | 1 | Online | Recv'd
2011-08-23 00:00:00 | 2847 | 2097 | SL22 | 1 | Online
2011-08-23 00:00:00 | 2856 | 1057 | D150A | 1 | Online
2011-08-24 00:00:00 | 2868 | 1417 | D150H | 1 | Online | Recv'd
2011-08-25 00:00:00 | 2899 | 927 | JL4C | 1 | Online | Recv'd
2011-08-26 00:00:00 | 2931 | 1057 | D150A | 1 | Online | Recv'd
2011-08-26 00:00:00 | 2941 | 807 | JL5A | 1 | Online | Recv'd
2011-08-27 00:00:00 | 2953 | 927 | JL4C | 1 | Online | Recv'd
2011-08-27 00:00:00 | 2960 | 2297 | TS9 | 1 | Online | Recv'd
2011-08-30 00:00:00 | 3054 | 1007 | [NAME] | 1 | Online | Recv'd
2011-08-30 00:00:00 | 3057 | 897 | JL4A | 1 | Online | Recv'd
Total
Spreadsheet: 209d4157-87a0-4ab6-abe5-d9c42359b73c
Sheet: 2014-2015

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
Conflict Studies
Fall 2015
Subject | Course and Title | Subtitle/Alternate Title | Days | Times | Sec | Part of Term | Credits | Hamline Plan | Instructor(s) | Instructor ID | FT or Adj | [NAME] | Registration Approval Required? | [NAME] | Seats to be Saved | Saved Seats Type | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list? SUBJ CRSE SEC | XLST total enrl | Areas of Study | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 719961d1613932058-formula-with-multiple-criteria-excelhelp2
Sheet: Weeks

 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11
Customer 1 |  | 3 | 26
Customer 2 |  |  | 210 |  | 210
Customer 3
Customer 4
Customer 5
Customer 6
Customer 7
Customer 8
Customer 9
Customer 10
Spreadsheet: 164917d1340960012-look-values-with-a-twist-0alook-up-query-v2
Sheet: Result

Account | Amount | Cost Center
5000001 |  | 1405801100
5000001 |  | 1505800650
5000001 |  | 1705800001
5000001 |  | 1705800002
5000001 |  | 1705800012
5000001 |  | 1705800022
5000001 |  | 1805800004
5000001 |  | 1805800005
5000001 |  | 1805800018
5000001 |  | 1805800035
5000001 |  | 1805807100
5000001 |  | 1905800002
5000001 |  | 2305800001
5010001 |  | 1705800001
5010001 |  | 1705800002
5010001 |  | 1705800012
5010001 |  | 2305800001
5010015 |  | 1505800650
5010015 |  | 1805800005
5010015 |  | 1805807100
5010015 |  | 1805800035
5010015 |  | 2305800001
5010015 |  | 1805800004
5010015 |  | 1805800018
5010015 |  | 1905800002
5010015 |  | 1405801100
5010015 |  | 1805800004
5010015 |  | 1805800005
5010015 |  | 1805800035
1379001 |  | X
2203015 |  | X
2206001 |  | X
2200001 |  | X
 | To look values from [NAME] and insert above
Spreadsheet: f85a186a-5399-4a5d-8580-08261adb8378
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
COXA | Test | COXA | Coxsackie A Antibodies, Serum | Coxsackie A Antibodies, S | Complement Fixation (CF) | Serum Gel Tube: SGT |  |  | 2 | mL | Draw blood in a plain, red-top tube(s). (Serum gel tube is  acceptable.) Spin down and send 2 mL of serum shipped refrigerate. | 1 mL | Specimens other than	Serum Anticoagulants other than	NA Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	NA Icteric	NA | REFERENCE RANGE: <1:8   INTERPRETIVE CRITERIA:                           <1:8  Antibody Not Detected             > or = 1:8  Antibody Detected   Single titers of > or = 1:32 are indicative of recent infection. Titers of 1:8 or 1:16 may be indicative of either past or recent infection, since CF antibody levels persist for only a few months. A four-fold or greater increase in titer between acute and convalescent specimens confirms the diagnosis. There is considerable crossreactivity among enteroviruses; however, the highest titer is usually associated with the infecting serotype.   Test Performed by: Focus Diagnostics, Inc.                                        5785 Corporate Avenue                                       Cypress, CA   90630-4750 | Monday through Friday | 2 - 5 days | 4 - 9 days | 6 | 86658 |  |  |  |  | Focus Diagnositics, Inc.
COXA | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
COXA | Result | Z0329 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
COXA | Result | Z0330 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
COXA | Result | Z0331 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
COXA | Result | [NAME] | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
COXA | Result | Z0333 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
COXA | Result | Z0334 | [NAME] Ab | [NAME] Ab | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: vkaminski__40649__DigitalAsnStrip_O
Sheet: Sheet2

 |  |  |  |  |  | 143 | 1
 |  |  |  | 22
 | -0.354016 | 0 | -0.354016
 | -0.308052 | 1 | -0.308052 |  |  | 16.909324
 | 0.07712 | 2 | 0.07712 |  |  | 16.974683
 | -0.288963 | 3 | -0.288963 |  |  | 16.716993
 | 0.255187 | 4 | 0.255187 |  |  | 16.938699
 | -0.021534 | 5 | -0.021534 |  |  | 16.916622
 | -0.082122 | 6 | -0.082122 |  |  | 16.8411
 | -0.364149 | 7 | -0.364149 |  |  | 16.520318
 | -0.35015 | 8 | -0.35015 |  |  | 16.21752
 | 0.030095 | 9 | 0.030095 |  |  | 16.240196
 | 0.604111 | 10 | 0.604111 |  |  | 16.758772
 | -0.403069 | 11 | -0.403069 |  |  | 16.406113
 | 0.365487 | 12 | 0.365487 |  |  | 16.719915
 | 0.686735 | 13 | 0.686735 |  |  | 17.328563
 | -0.52966 | 14 | -0.52966 |  |  | 16.85192
 | -0.443998 | 15 | -0.443998 |  |  | 16.462008
 | 0.118447 | 16 | 0.118447 |  |  | 16.561413
 | -0.500483 | 17 | -0.500483 |  |  | 16.130478
 | -0.461747 | 18 | -0.461747 |  |  | 15.742632
 | -0.580816 | 19 | -0.580816 |  |  | 15.268687
 | -0.358819 | 20 | -0.358819 |  |  | 14.982033
 | -0.704897 | 21 | -0.704897 |  |  | 14.436951
 | 0.136874 | 22 | 0.136874 |  |  | 14.538138
 | -0.373283 | 23 | -0.373283 |  |  | 14.254408
 | -0.280337 | 24 | -0.280337 |  |  | 14.044351
 | 0.439932 | 25 | 0.439932 |  |  | 14.368841
 | -0.190491 | 26 | -0.190491 |  |  | 14.22381
 | 0.262896 | 27 | 0.262896 |  |  | 14.418265
 | 0.242014 | 28 | 0.242014 |  |  | 14.599417
 | 0.084815 | 29 | 0.084815
 | 16.909324
 | 16.974683
 | 16.716993
 | 16.938699
 | 16.916622
 | 16.8411
 | 16.520318
 | 16.21752
 | 16.240196
 | 16.758772
 | 16.406113
 | 16.719915
 | 17.328563
 | 16.85192
 | 16.462008
 | 16.561413
 | 16.130478
 | 15.742632
 | 15.268687
 | 14.982033
 | 14.436951
 | 14.538138
 | 14.254408
 | 14.044351
 | 14.368841
 | 14.22381
 | 14.418265
 | 14.599417
Spreadsheet: 32558d1228758879-vlookup-or-if-statements-widgets-gidgets-lidgets
Sheet: Sheet1

Widgets | 3
Gidgets | 6
Lidgets | 5
Field1 | 9
widgets | Gidgets | Lidgets | Field1
1 | 3 | 5 | 10
7 | 5 | 5 | 7
4 | 3 | 7 | 8
3 | 6 | 5 | 9
6 | 1 | 2 | 3
Spreadsheet: 871699d1718116677-in-need-of-formulas-to-combine-the-data-from-3-sheets-into-1-sheet-overall-list-overall-list
Sheet: Q1

S.N. | Identity No. | Category | Discipline | Document Type | Document No. | Rev. No. | Document Title | Created Date | Submitted Date | Created By | Status
1 | Q1-1 | Special Process Procedures & Personnel | Civil | Quality Test Report | CV-TEST-039 | NA | Quality Test Report_16 to 31 October 2023 | 2024-02-03 00:00:00 | 2024-02-04 00:00:00 | JJ654274 | Open
2 | Q1-2 | Special Process Procedures & Personnel | Piping | Procedure | PI-PD-7017 | A3 | Lay-Up Procedure for Piping | 2023-10-29 00:00:00 | 2023-11-05 00:00:00 | AR419672 | Closed
3 | Q1-3 | Special Process Procedures & Personnel | Mechanical | [NAME] | ME-PD-7814 | A2 | Method Statement for Vacuum Box Testing Field | 2023-12-11 00:00:00 | 2023-12-12 00:00:00 | NA340127 | Closed
4 | Q1-4 | Special Process Procedures & Personnel | Civil | Laboratory Approval | LAB-ACES-003 | R1 | Request for Approval of ACES Lab | 2024-04-29 00:00:00 | 2024-04-29 00:00:00 | AU034083 | Open
5 | Q1-5 | Special Process Procedures & Personnel | Piping | JCC for Pipe Work | JFGP3-DA-W-143 | NA | JCC for Welder_LOUIE DIGNOS_GTAW | 2024-06-08 00:00:00 | 2024-06-08 00:00:00 | AR419672 | Closed
6 | Q1-6 | Special Process Procedures & Personnel | Electrical | ITP | PM-PD-6222 | 00 | HDTIP-E-005_for Galvanic Cathodic Protection - Pin Brazing | 2024-05-30 00:00:00 | 2024-06-05 00:00:00 | AU034083 | Closed
Spreadsheet: 113935d1309824425-auto-sorting-contact-calander_not_solved-3
Sheet: Sheet1

Contact Calander
2011-07-04 00:00:00 | QUOTE | ORDER |  |  |  |  |  |  |  |  |  | DAYS |  | DAYS |  | DAYS | BDAY | DAYS
Date |  |  | Last Name | First Name | Address | City | Postal | [NAME] | Phone | Cell | Quote Card |  | [NAME] |  | 6 Mth |  | 12 Mth
2011-06-25 00:00:00 | Y | Y |  |  |  |  |  |  |  | [PHONE] | 2011-07-02 00:00:00 | -2 | 2011-07-02 00:00:00 | -2 | 2011-12-22 00:00:00 | 171 | 2012-06-19 00:00:00 | 351
2011-07-04 00:00:00 | Y | Y |  |  |  |  |  |  |  |  | 2011-07-11 00:00:00 | 7 | 2011-07-11 00:00:00 | 7 | 2011-12-31 00:00:00 | 180 | 2012-06-28 00:00:00 | 360
2011-06-30 00:00:00 | Y | Y |  |  |  |  |  |  |  |  | 2011-07-07 00:00:00 | 3 | 2011-07-07 00:00:00 | 3 | 2011-12-27 00:00:00 | 176 | 2012-06-24 00:00:00 | 356
2011-06-24 00:00:00 | Y | Y |  |  |  |  |  |  |  |  | 2011-07-01 00:00:00 | -3 | 2011-07-01 00:00:00 | -3 | 2011-12-21 00:00:00 | 170 | 2012-06-18 00:00:00 | 350
2011-06-27 00:00:00 | Y | Y |  |  |  |  |  |  |  |  | 2011-07-04 00:00:00 | 0 | 2011-07-04 00:00:00 | 0 | 2011-12-24 00:00:00 | 173 | 2012-06-21 00:00:00 | 353
2011-06-28 00:00:00 | Y | Y |  |  |  |  |  |  |  |  | 2011-07-05 00:00:00 | 1 | 2011-07-05 00:00:00 | 1 | 2011-12-25 00:00:00 | 174 | 2012-06-22 00:00:00 | 354
Spreadsheet: 52759d1252590360-if-statement-to-accumulate-an-amount-in-a-cell-personal-accounts2
Sheet: Day to Day

 | Day to Day Balance Sheet |  |  | September 09 | Todays Date | 2009-09-10 00:00:00 |  |  | Key Item Balance
 | Date | Type | Description | Comments | Credit | Debit |  |  | Description | Spend | Balance
 | 2009-09-01 00:00:00 |  | Food |  | 2 | 1 | 1 |  | Food | 1 | -429
 |  |  |  |  |  |  | 0 |  | Socialising |  | -100
 |  |  |  |  |  |  | 0 |  | Sundries |  | -100
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  | Spending Balance
 |  |  |  |  |  |  | 0 |  | Overall Spend to Date | 1
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
Spreadsheet: 275718d1383617240-sum-employees-based-3-variables-sum-employee-type
Sheet: Base Employee Data

Business Unit | Surname | [NAME] | Internal/External Resource | Skill Type | 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 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 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
Operations | Hall | [NAME] | Internal | SME | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Operations | Welsh | [NAME] | Internal | SME | 0 |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Operations | [NAME] | Amanda | External | PM | 0.5
Marketing | Smith | [NAME] | Internal | BA | 0 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75 | 0.75
Finance | Smith | [NAME] | Internal | BA | 0 |  | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5
Engineering | Jenkins | [NAME] | Internal | BA | 0 |  |  |  |  |  |  |  |  |  |  |  | 0.25 | 0.25 | 0.25 | 0.25 | 0.25 | 0.25
Legal | Rose | [NAME] | Internal | PM | 0 |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 871576d1718025501-comparing-two-lists-in-differing-order-sample-list
Sheet: Sheet1

 | Data ref #1 | Data ref list #2 | Required Result
 | 20.1 | 20.1 | Match
 | 22 | 12 | Error | Error
 | 40 | 8 | Error | Error
 | 40.1 | 9 | Match | Error
 |  | 40 | Match | Match