tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 89554d1289337910-dependent-percentile-formula-in-table-with-nested-lookup-or-index-match-benchmark-help2
Sheet: SIC Table

 | OneVoice Industry | Code 1 | Code 2 | Code 3 | Code 4 | Code 5 | Code 6 | Code 7 | Code 8 | Code 9 | Code 10 | Code 11 | Code 12 | Code 13 | Code 14
 | Aerospace and Defense
 | Automotive
 | Chemicals
 | Communications
 | Consumer Products | FOOD AND KINDRED PRODUCTS (SIC 20XX) | TOBACCO PRODUCTS (SIC 21XX) | TEXTILE MILL PRODUCTS (SIC 22XX) | APPAREL AND OTHER FINISHED PRODUCTS MADE FROM FABRICS AND SIMILAR MATERIAL (SIC 23XX) | LEATHER AND LEATHER PRODUCTS (SIC 31XX)
 | Education and Research
 | Engineering and Construction | BUILDING CONSTRUCTION-GENERAL CONTRACTORS AND OPERATIVE BUILDERS | HEAVY CONSTRUCTION OTHER THAN BUILDING CONSTRUCTION-CONTRACTORS (SIC 16XX) | CONSTRUCTION-SPECIAL TRADE CONTRACTORS (SIC 17XX)
 | Financial Services | DEPOSITORY INSTITUTIONS (SIC 60XX) | NONDEPOSITORY CREDIT INSTITUTIONS (SIC 61XX) | SECURITY AND COMMODITY BROKERS, DEALERS, EXCHANGES, AND SERVICES (SIC 62XX) | INSURANCE CARRIERS (SIC 63XX) | INSURANCE AGENTS, BROKERS, AND SERVICE (SIC 64XX) | REAL ESTATE (SIC 65XX) | HOLDING AND OTHER INVESTMENT OFFICES (SIC 67XX)
 | Healthcare
 | High Technology
 | Industrial Manufacturing | LUMBER AND WOOD PRODUCTS, EXCEPT FURNITURE (SIC 24XX) | FURNITURE AND FIXTURES (SIC 25XX) | PAPER AND ALLIED PRODUCTS (SIC 26XX) | PRINTING, PUBLISHING, AND ALLIED INDUSTRIES (SIC 27XX) | RUBBER AND MISCELLANEOUS PLASTICS PRODUCTS (SIC 30XX) | FABRICATED METAL PRODUCTS, EXCEPT MACHINERY AND TRANSPORTATION EQUIPMENT (SIC 34XX) | INDUSTRIAL AND COMMERCIAL MACHINERY AND COMPUTER EQUIPMENT (SIC 35XX) | ELECTRONIC AND OTHER ELECTRICAL EQUIPMENT AND COMPONENTS, EXCEPT COMPUTER (SIC 36XX) | MEASURING, ANALYZING AND CONTROLLING INSTRUMENTS; PHOTOGRAPHIC, MEDICAL (SIC 38XX) | MISCELLANEOUS MANUFACTURING INDUSTRIES (SIC 39XX)
 | Life Sciences
 | Media and Entertainment
 | Natural Resources
 | Oil and Gas | OIL AND GAS EXTRACTION (SIC 13XX) | PETROLEUM REFINING AND RELATED INDUSTRIES (SIC 29XX) | PIPELINES, EXCEPT NATURAL GAS (SIC 46XX)
 | Other
 | Professional Services | PERSONAL SERVICES (SIC 72XX) | BUSINESS SERVICES (SIC 73XX) | MISCELLANEOUS REPAIR SERVICES (SIC 76XX) | LEGAL SERVICES (SIC 81XX) | MEMBERSHIP ORGANIZATIONS (SIC 86XX) | ENGINEERING, ACCOUNTING, RESEARCH, MANAGEMENT, AND RELATED SERVICES (SIC 87XX) | SERVICES, NOT ELSEWHERE CLASSIFIED (SIC 89XX)
 | Public Sector
 | Retail
 | Travel and Transportation
 | Unclassified
 | Utilities
 | One | Two
 | Engineering and Construction | BUILDING CONSTRUCTION-GENERAL CONTRACTORS AND OPERATIVE BUILDERS (SIC 15XX)
Spreadsheet: 856700d1705920155-pivot-table-from-different-sheets-not-in-a-nice-large-data-table-attendance-missed-session-catch-up-log-test
Sheet: Learner3

 | Attendance |  |  |  | Additional support plans
Name | P3 | P6 | P9 | P12 | Declared but Declined | University Learning Support Plan from DDSS | Departmental Support plan | Return to Learning Support Plan | Functional Skills training and progress
Learner3
Session missed | Module | Tutor(s) | How missed work was caught up |  |  | Auto completed by Att spreadsheet
 |  |  |  |  |  | PS to link
 |  |  |  |  |  | PS to complete
 |  |  |  |  |  | tutor to complete
Spreadsheet: 686870d1594841878-create-dynamic-list-with-blank-rows-in-the-data-formulas
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 | 6
Length ↓ / Diameter  → | 6 | 8 | 10 | 12 | 14 | 16
1000 | 10.02508738556673 | 5.871946100528567 | 4.211400677229841 | 2.000161962262141 | 1.505408209951998 | 1.130909303086452
900 | 12.32517790907409 | 7.25711649563905 | 5.209029234375978 | 2.473744106904616 | 1.856309216401486 | 1.397118535814626
600 | 13.37062102473855 | 7.892480471858927 | 5.648932609285289 | 2.668301492861927 | 2.011203399076348 | 1.513550458204409
400 | 14.23243567856045 | 8.41495158093445 | 2.7 | 2.862726066394936 | 2.145896223213431 | 1.616868531930135
250 | 15.09951449305406 | 8.956271788678006 | 6.410528271330596 | 3.060181355303883 | 2.301334100512764 | 1.741071017558297
175 | 20.06070309247687 | 11.94606793966054 | 8.521902870698204 | 4.070365298968864 | 3.045246130909925 | 2.302917635255948
150 | 20.11695228602526 | 11.99302378818789 | 8.559402333063796 | 4.098057209638839 | 3.071083081056553 | 2.326917291169926
Enter Length | 175
No. of holes
Diameter
Spreadsheet: 105659d1302956012-formula-for-working-out-promo-code-cust-details
Sheet: Customer Details

Customer | Booking Agent | Code
[NAME] | [NAME] | Promo 1
[NAME] | [NAME] | Promo 1
[NAME] | [NAME] | Promo 2 |  | Row Labels | Count of Code2 | Count of Code
[NAME] | [NAME] | Promo 2 |  | [NAME] | 4 | 0.3333333333333333
[NAME] | [NAME] | Promo 2 |  | [NAME] | 4 | 0.3333333333333333
[NAME] | [NAME] | Promo 2 |  | [NAME] | 2 | 0.1666666666666667
[NAME] | [NAME] | Promo 2 |  | [NAME] | 2 | 0.1666666666666667
[NAME] | [NAME] | Promo 3 |  | Grand Total | 12 | 1
[NAME] | [NAME] | Promo 3
[NAME] | [NAME] | Promo 2
[NAME] | [NAME] | Promo 1
[NAME] | [NAME] | Promo 1
Spreadsheet: 145438d1331580034-using-v-or-hlookup-to-auto-populate-cells-for-large-schedule-excel-test
Sheet: Sheet1

 |  | Block 1 | Block 2 | Block 3 | Block 4 | Block 5 | Block 6 | Block 7 | Block 8 | Block 9 | Block 10 | Block 11 | Block 12 | Block 13
Resident 1 | week 1 | Nephro | AMB | GEN 1 | Pulm | VAC | Endo | MICU | MEM 2 | VAC | AMB | MEM 1 | MEM 1 | CARDS
Checked | week 2 | Nephro | AMB | GEN 1 | Pulm | Endo | Endo | MICU | MEM 2 | Clinic | AMB | MEM 1 | MEM 1 | CARDS
 | week 3 | Nephro | AMB | GEN 1 | Pulm | Endo | MEM NF | MICU | MEM 2 | MEM NF | AMB | MEM 1 | MEM 1 | CARDS
 | week 4 | Nephro | AMB | GEN 1 | Pulm | Boards | MEM NF | MICU | MEM 2 | MEM NF | AMB | MEM 1 | MEM 1 | CARDS
Resident 2 | week 1 | NF | ICU | Rad/Onc | ER | NF | MS | Endo | MAO | [NAME] | Amb | ICU | Nephro | MS
checked | week 2 | NF | ICU | Rad/Onc | ER | NF | MS | Endo | MAO | [NAME] | Amb | ICU | Nephro | MS
 | week 3 | MS | ICU | Rheum | ER | [NAME] | MS | Endo | Clinic | [NAME] | Amb | ICU | NF | VAC
 | week 4 | MS | ICU | Rheum | ER | [NAME] | MS | VAC | Clinic | [NAME] | Amb | ICU | MAO | VAC
Anesthesia
B Med
CARDS
CARDS EP
Dermatology
Endo
ER
ENT
GI
[NAME]
Heme/Onc
ID
Nephro
[NAME]
Nuclear Med
[NAME]
Palliative Care
Plastics
Pulm
Radiology
Rad/Onc
Rehab
Research
Rheum
Sleep Medicine
Surgery
Vascular Medicine
Vacation
Clinic
AMB
Spreadsheet: 678753d1590050260-sum-range-across-worksheet-with-transposition-test-sum-range-across-worksheet
Sheet: Sheet2

 | 600 | 737 | 992 | 160 | 104 | 730 | 80 | 32 | 590 | 245 | 470
 | 745 | 190 | 888 | 994 | 128 | 814 | 894 | 5 | 925 | 712 | 287
 | 534 | 84 | 283 | 207 | 793 | 414 | 182 | 981 | 20 | 598 | 141
 | 452 | 371 | 502 | 759 | 476 | 55 | 747 | 261 | 583 | 485 | 388
 | 991 | 343 | 70 | 401 | 428 | 861 | 986 | 553 | 650 | 599 | 755
 | 568 | 926 | 554 | 415 | 974 | 313 | 87 | 25 | 176 | 344 | 965
 | 490 | 356 | 134 | 688 | 425 | 447 | 238 | 444 | 380 | 313 | 455
 | 244 | 382 | 212 | 79 | 401 | 376 | 450 | 104 | 944 | 55 | 478
 | 321 | 146 | 67 | 87 | 931 | 229 | 725 | 86 | 554 | 878 | 250
 | 927 | 585 | 255 | 357 | 978 | 631 | 728 | 466 | 388 | 105 | 746
 | 891 | 889 | 567 | 63 | 259 | 970 | 58 | 780 | 612 | 835 | 233
 | 63 | 825 | 51 | 654 | 778 | 389 | 262 | 173 | 239 | 824 | 949
 | 413 | 59 | 972 | 484 | 804 | 287 | 727 | 637 | 968 | 272 | 165
Spreadsheet: 41407d1239878602-excel-2003-pivot-table-show-the-content-of-the-cell-non-calculation-679963_niconatu_v2
Sheet: Sheet1

Model | Version | Color | Store | KEY
1 | a | zz | HH | 1:HH
2 | b | xx | QQ | 2:QQ
3 | c | OO | OO | 3:OO
4 | d | ww | PP | 4:PP
1 | c | OO | HH | 1:HH
2 | d | OO | HH | 2:HH
3 | b | zz | OO | 3:OO
4 | b | xx | QQ | 4:QQ
1 | a | zz | v | 1:v
2 | d | xx | PP | 2:PP
3 | b | xx | HH | 3:HH
4 | c | ww | HH | 4:HH
Spreadsheet: 756874d1637846421-can-i-parameterize-vlookup-table
Sheet: Sheet1

Ref | Name | Amount | Tax Rate |  | Vlookup
1 | A | 552 | 0.05 |  | C
2 | B | 719 | 0.05 |  | 7
3 | C | 502 | 0.05
4 | D | 870 | 0.05
5 | E | 799 | 0.05
6 | F | 711 | 0.05
7 | G | 845 | 0.05
Spreadsheet: d96eebf4-011d-4c51-8810-1a9bb8980d7b
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
PPL | Test | PPL | Phospholipids, Serum | Phospholipids, S | [NAME] | Serum Gel Tube: SGT |  |  | 1 | mL | Collection Container/Tube:  Preferred: Red top Acceptable: Serum gel Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions:  1. Fasting-overnight (12-14 hours) 2. Patient must not consume any alcohol for 24 hours before the specimen is drawn. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	NA | 155-275 mg/dL  Reference values have not been established for patients that are less than 16 years of age. | Monday through Friday; 7 a.m.-5 p.m. | 1 day (not reported on Saturday or Sunday) | 3 days | 1 | 84311 |  |  |  |  | Rochester
PPL | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
PPL | Result | PPL | Phospholipids, S | Phospholipids, S | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 2568-4 | Phospholipid:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 119302d1314303728-formula-wont-copy-correctly-into-next-row-formula
Sheet: Sheet1

2.4 | 3 | 3.6 | 4.2 | 4.8 | total mtrs
1 | 1 | 1 | 1 | 1 | 18
1 | 1 | 1 | 1 | 1 | 5
1 | 1 | 1 | 1 | 1 | 5
1 | 1 | 1 | 1 | 1 | 5
1 | 1 | 1 | 1 | 1 | 5
1 | 1 | 1 | 1 | 1 | 5
1 | 1 | 1 | 1 | 1 | 5
1 | 1 | 1 | 1 | 1 | 5
1 | 1 | 1 | 1 | 1 | 5
Spreadsheet: 48274d1247509254-help-needed-in-making-cgpa-calculator-cgpa-calculator
Sheet: Sheet1

Semeter # | Subject # | Course Title | Credit Hour | Grade obt | GPA
1 | 1 | Physics 1 | 3 | A | 4
 | 2 | Programming Fumdamentel | 4 | A- | 3.75
 | 3 | Introduction to Computers | 3 | [NAME] | 3.5 |  | S1
 | 4 | [NAME] | 3 | [NAME] | 3.5 |  | 3.46875
 | 5 | English Composition And Comprehention | 3 | C+ | 2.5
CGPA |  |  |  |  | 3.46875
2 | 6 | MVC | 3 | B- | 2.75
 | 7 | Physics 2 | 3 | [NAME] | 3.5 |  | S2
 | 8 | TBW | 3 | B | 3 |  | 3.1875
 | 9 | Discrete Structure | 3 | C | 2
CGPA |  |  |  |  | 2.8125
3 | 10 | Differential Equation | 3 | C+ | 2.5 |  | Summer
 | 11 | Communication Skills | 3 | B | 3 |  | 3.110294117647059
CGPA |  |  |  |  | 2.75
4 | 12 | Object Oriented Programming | 4 | B- | 2.75
 | 13 | DLCA | 4 | A | 4 |  | S3
 | 14 | Probabitity | 3 | B | 3 |  | 3.140625
 | 15 | Database Systems | 3 | B | 3
CGPA |  |  |  |  | 3.214285714285714
 | 16 | LA | 3 | C+ | 2.5
 | 17 | PSY | 3 | B | 3 |  | [NAME]
 | 18 | DSA | 4 | B | 3 |  | 3.020161290322581
 | 19 | COAL | 4 | C | 2
CGPA |  |  |  |  | 2.607142857142857
 | 20 | ITL | 3 |  | 4
 | 21 |  | 0 |  | 0 |  | 3.065384615384616
CGPA |  |  |  |  | 4
Spreadsheet: 250122d1373804832-converting-columns-into-rows-book1
Sheet: Sheet1

dept | emp1 | sal | emp2 | sal2 | emp3 | sal3 |  |  |  | Dept | emp | sal
HR | Abc | 123 | bcv | 231 | sjn | 987 |  |  |  | HR | Abc | 123
IT | sddds | 9876 | ds | 999 | dsb | 123 |  |  |  |  | bcv | 231
 |  |  |  |  |  |  |  |  |  |  | sjn | 987
 |  |  |  |  |  |  |  |  |  | IT | sdds | 9876
 |  |  |  |  |  |  |  |  |  |  | ds | 999
 |  |  |  |  |  |  |  |  |  |  | dsb | 123
Spreadsheet: 42990d1241610723-value-question-and-sum-average-question-test
Sheet: Reports & Charts

 | [NAME] | Planned Units | Earlier Units | On Time Units | Late Units | Total vs Plan | Still to Launch | Average process Time | MPS % Performance
 | 2009-01-01 00:00:00 | 64 | 62 | 1 | 1 | 0 |  |  | 0.015625
 | 2009-02-01 00:00:00 | 0 | 0 | 0 | 0 | 0 |  |  | #N/A
 | 2009-03-01 00:00:00 | 68 | 25 | 5 | 38 | 0 |  |  | 0.07352941176470588
 | 2009-04-01 00:00:00 | 37 | 9 | 13 | 15 | 0 |  |  | 0.3513513513513514
 | 2009-05-01 00:00:00 | 0 | 0 | 0 | 0 | 0 |  |  | #N/A
 | 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
 | Factory Performance | Planned Units | Earlier Units | On Time Units | Late Units | Total vs Plan | Still to Launch | Average process Time | Factory % Performance
 | 2009-01-01 00:00:00 | 38 | #N/A | #N/A | #N/A | #N/A |  |  | #N/A
 | 2009-02-01 00:00:00 | 0 | #N/A | #N/A | #N/A | #N/A |  |  | #N/A
 | 2009-03-01 00:00:00 | 67 | #N/A | #N/A | #N/A | #N/A |  |  | #N/A
 | 2009-04-01 00:00:00 | 55 | #N/A | #N/A | #N/A | #N/A |  |  | #N/A
 | 2009-05-01 00:00:00 | 9 | #N/A | #N/A | #N/A | #N/A |  |  | #N/A
 | 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
 | RTS Performance | Planned Units | Earlier Units | On Time Units | Late Units | Total vs Plan | Still to Launch | Average process Time | RTS % Performance
 | 2009-01-01 00:00:00 | 43 | #N/A | #N/A | #N/A | #N/A |  |  | #N/A
 | 2009-02-01 00:00:00 | 14 | #N/A | #N/A | #N/A | #N/A |  |  | #N/A
 | 2009-03-01 00:00:00 | 73 | #N/A | #N/A | #N/A | #N/A |  |  | #N/A
 | 2009-04-01 00:00:00 | 58 | #N/A | #N/A | #N/A | #N/A |  |  | #N/A
 | 2009-05-01 00:00:00 | 38 | #N/A | #N/A | #N/A | #N/A |  |  | #N/A
 | 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
Spreadsheet: 5383c266-1d31-4bf9-96e2-ea452706138b
Sheet: BEAM PR

RED | NOMBRE | CANAL | [NAME] | SATELITE | PANTALLA_RCTOR | TID | 0x.VPID | MERCADO LOCAL | NOTA_0 | NOTA_1
2 | ODTV | 161 | 25 | G3C @95W | Beam PR | 24 | 0080 | Puerto Rico | 161 | ONLY for DirecTV users, a special and wide-ranging choice of shows for all the family, including the best concerts, shows for children, sporting events, and the most popular movies and series of the world.
2 | TMDO | 162 | 25 | G3C @95W | Beam PR | 24 | 0030 | Puerto Rico | TELEMUNDO | Telemundo is the television network that produces most Spanish-language content in the United States and entertain and inform Spanish speakers all around the world.
2 | WAPA | 164 | 25 | G3C @95W | Beam PR | 24 | 0070 | Puerto Rico | WAPA | WAPA TV offers a variety of entertainment shows, news, movies and sports for all Puerto Rico.
2 | PRTV | 166 | 25 | G3C @95W | Beam PR | 24 | 0090 | Puerto Rico | [NAME] | [NAME] produces educative content and public interest shows.
2 | UNPR | 168 | 25 | G3C @95W | Beam PR | 24 | 00B0 | Puerto Rico | Univisión Pto. [NAME] | Univisión Network provides Spanish-language content for Puerto Rico and the world, providing soaps, news, comedies, talk shows and specials.
2 | MEGA | 169 | 25 | G3C @95W | Beam PR | 24 | 0020 | Puerto Rico | MEGA TV | Entertainment for all the family. Mega TV Entertainment for all the family with MEGA TV and its reality shows, music contests and original productions.
2 | WSJP | 178 | 25 | G3C @95W | Beam PR | 24 | 00C0 | Puerto Rico | The CW Puerto Rico | CW is a pioneer in music and entertainment, offering primetime movies, series, sitcoms, plus the best in sports and variety shows.
2 | TMD2 | 179 | 25 | G3C @95W | Beam PR | 24 | 00D0 |  | PUNTO 2 | <10>
2 | VH1 | 262 | 25 | G3C @95W | Beam PR | 24 | 0010 |  | VH1 | With videos and concerts by the biggest stars and newest faces, as well as exclusive events, stunts and specials, VH1 is where today's upscale viewers stay connected to the music - and music culture they love.
2 | MLBN | 656 | 25 | G3C @95W | Beam PR | 24 | 0060 |  | MLB Network | MLB Network provides 24-hour coverage of Major League Baseball, including nightly news shows, analysis, commentary and more.
2 | WAP2 | 657 | 25 | G3C @95W | Beam PR | 24 | 00E0 | Puerto Rico | WAPA2 | A channel devoted to sports. WAPA 2 features coverage of the MLB and also Olympic sports such as gymnastics, swimming, volleyball, table tennis and soccer.
Spreadsheet: andy_zipper__270__Broker & Exchange Detail 6-6-01
Sheet: FAILED DEALS SUMMARY

Failed Transactions:
LIFE TO DATE
FAILED TRANSACTION COUNT |  | Commodity
Broker | Failed Reason | Natural Gas | Power | Grand Total
APB Energy, Inc. | FAILURE: counterparty exceeded credit limit | 1 | 3 | 4
 | [NAME]: counterparty has no bid access to product | 1 | 10 | 11
 | [NAME]: counterparty has no offer access to product |  | 5 | 5
 | FAILURE: Limit price violated |  | 16 | 16
 | [NAME]: product violates counterparty term limit | 3 |  | 3
 | [NAME]: traded-for counterparty has a collateralized GTC and brokered | 7 |  | 7
 | FAILURE: Volume not available for base product of hedge | 1 |  | 1
 | FAILURE: Order pended due to limit price violation | 30 | 5 | 35
APB Energy, Inc. Total |  | 43 | 39 | 82
Natsource LLC | FAILURE: counterparty exceeded credit limit | 2 | 5 | 7
 | [NAME]: counterparty has no bid access to product | 1 | 4 | 5
 | [NAME]: counterparty has no offer access to product |  | 5 | 5
 | FAILURE: Limit price violated | 1 | 13 | 14
 | [NAME]: product violates counterparty term limit |  | 3 | 3
 | [NAME]: traded-for counterparty has a collateralized GTC and brokered | 1 | 9 | 10
 | FAILURE: Base product not active for hedge | 2 |  | 2
Natsource LLC Total |  | 7 | 39 | 46
Power Merchants Group, LLC | FAILURE: counterparty exceeded credit limit | 1 |  | 1
 | [NAME]: counterparty has no offer access to product | 3 |  | 3
 | FAILURE: Limit price violated | 10 |  | 10
 | [NAME]: product violates counterparty term limit | 1 |  | 1
 | [NAME]: traded-for counterparty has a collateralized GTC and brokered | 3 |  | 3
 | FAILURE: Order pended due to limit price violation | 3 |  | 3
Power Merchants Group, LLC Total |  | 21 |  | 21
Amerex Natural Gas I, Ltd. | FAILURE: Limit price violated | 2 |  | 2
 | [NAME]: traded-for counterparty has a collateralized GTC and brokered | 4 |  | 4
Amerex Natural Gas I, Ltd. Total |  | 6 |  | 6
Amerex Power, Ltd. | FAILURE: counterparty exceeded credit limit |  | 1 | 1
 | [NAME]: counterparty has no bid access to product |  | 5 | 5
 | FAILURE: Limit price violated |  | 2 | 2
 | [NAME]: product violates counterparty term limit |  | 2 | 2
 | [NAME]: counterparty has no access to product |  | 1 | 1
Amerex Power, Ltd. Total |  |  | 11 | 11
Prebon Energy, Inc. | FAILURE: Order pended due to limit price violation | 1 |  | 1
Prebon Energy, Inc. Total |  | 1 |  | 1
Grand Total |  | 78 | 89 | 167
Spreadsheet: 113165d1309149648-how-do-you-update-one-inventory-sheet-to-one-row-in-another-sheet-brambles-example-1-
Sheet: Staff Duty Rotas

Brambles Visitors Book - Monitoring  Up To Date - WEEKLY
Next Due Date | Date Last Checked | Last Checked by | Comments
2011-05-16 00:00:00 | 2011-05-17 00:00:00 | [NAME] | up to date
2011-05-23 00:00:00 | 2011-05-23 00:00:00 | Sophie | up to date
2011-05-30 00:00:00 | 2011-05-30 00:00:00 | [NAME] | NOT up to date - email team leader
2011-06-06 00:00:00 | 2011-06-08 00:00:00 | [NAME] | up to date
2011-06-13 00:00:00 | 2011-06-12 00:00:00 | Jo | up to date
2011-06-20 00:00:00 | 2011-05-17 00:00:00 | [NAME] | Bungalows struggling with staff sickness and vacancies.
2011-06-27 00:00:00
2011-07-04 00:00:00
2011-07-11 00:00:00
2011-07-18 00:00:00
2011-07-25 00:00:00
2011-08-01 00:00:00
2011-08-08 00:00:00
2011-08-15 00:00:00
2011-08-22 00:00:00
2011-08-29 00:00:00
2011-09-05 00:00:00
2011-09-12 00:00:00
2011-09-19 00:00:00
2011-09-26 00:00:00
Spreadsheet: 841038d1693298108-help-with-sum-zeszyt3
Sheet: Arkusz1

company | product | invoice | Units |  |  | company | product 1
company 1 | product 1 | invoice 1 | 10 |  |  | company 1
company 1 | product 2 | invoice 1 | 6 |  |  | company 2 | 0
company 2 | product 1 | invoice 2 | 10 |  |  | company 3 | 10
company 2 | product 2 | invoice 2 | 3 |  |  | company 4 | 0
company 3 | product 1 | invoice 3 | 20 |  |  | company 5 | 10
company 3 | product 2 | invoice 3 | 10 |  |  | company 6 | 10
company 4 | product 1 | invoice 4 | 30
company 5 | product 2 | invoice 5 | 10
company 6 | product 1 | invoice 6 | 20
company 6 | product 2 | invoice 6 | 10
Spreadsheet: 737189d1624273434-need-help-to-build-formula-to-count-missing-values-plus-help-with-a-pivot-graph-missing_day_and_pivot
Sheet: Sheet1

Week ending | Name | Date worked | Completed | Flagged | Coached
2021-04-09 00:00:00 | [NAME] | 2021-04-12 00:00:00 | 20 | 1 | 1
2021-04-09 00:00:00 | [NAME] | 2021-04-13 00:00:00 | 10 | 5 | 3
2021-04-09 00:00:00 | [NAME] | 2021-04-14 00:00:00 | 25 | 0 | 0
2021-04-09 00:00:00 | [NAME] | 2021-04-15 00:00:00 | 23 | 7 | 4
2021-04-09 00:00:00 | [NAME] | 2021-04-16 00:00:00 | 8 | 4 | 1
2021-04-09 00:00:00 | [NAME] | 2021-04-13 00:00:00 | 15 | 0 | 0
2021-04-09 00:00:00 | [NAME] | 2021-04-14 00:00:00 | 23 | 5 | 7
2021-04-09 00:00:00 | [NAME] | 2021-04-15 00:00:00 | 36 | 0 | 9
2021-04-16 00:00:00 | [NAME] | 2021-04-19 00:00:00 | 58 | 0 | 12
2021-04-16 00:00:00 | [NAME] | 2021-04-19 00:00:00 | 40 | 8 | 6
2021-04-16 00:00:00 | [NAME] | 2021-04-21 00:00:00 | 52 | 10 | 0
2021-04-16 00:00:00 | [NAME] | 2021-04-23 00:00:00 | 78 | 25 | 16
2021-04-16 00:00:00 | [NAME] | 2021-04-19 00:00:00 | 44 | 10 | 8
2021-04-16 00:00:00 | [NAME] | 2021-04-20 00:00:00 | 96 | 5 | 9
2021-04-16 00:00:00 | [NAME] | 2021-04-21 00:00:00 | 92 | 36 | 15
2021-04-16 00:00:00 | [NAME] | 2021-04-22 00:00:00 | 65 | 20 | 0
2021-04-16 00:00:00 | [NAME] | 2021-04-23 00:00:00 | 69 | 51 | 8
Spreadsheet: 291986d1390464116-number-formatting-and-conditional-formatting-book2
Sheet: Delta

 | Wght | Value | Value t-1 | % Change | Contribution (bp) |  |  | [NAME] for (-) contribution |  |  | [NAME] for (+) contribution
 | 0.0128897145256501 | 4.17 | 4.18 | -0.002392344497607605 | -3.083663762117183e-05 |  |  | 0 | -0.0001 |  | 0 | 0.0001
 | 0.08833047005735466 | 100.47863014 | 100.45479452 | 0.0002372770768573769 | 2.095879573264717e-05 |  |  | -0.0001 | -0.0002 |  | 0.0001 | 0.0002
 | 0.04434631434817778 | 100.4265 | 100.46475 | -0.0003807305547467225 | -1.688399686275427e-05 |  |  | -0.0002 | -0.0005 |  | 0.0002 | 0.0005
 | 0.08189303565237972 | 92.72733333 | 93.23520833 | -0.005447244759752366 | -0.0004460914093176392 |  |  | -0.0005 | -0.0007 |  | 0.0005 | 0.0007
 | 0.01751195114039146 | 99.14375 | 99.309125 | -0.001665254829301914 | -2.916186120703603e-05 |  |  | 0.0007 | -0.001 |  | 0.0007 | 0.001
 | 0.01733975218836481 | 98.16884722 | 98.24338889 | -0.0007587448971600934 | -1.315644849094236e-05 |  |  | -0.001 | -0.005 |  | 0.001 | 0.005
 | 0.04452329707908288 | 100.82729444 | 100.88978611 | -0.0006194053175201047 | -2.757796696431128e-05
 | 0.04704179107973259 | 106.53066667 | 106.61029167 | -0.0007468791122574081 | -3.513453116062914e-05
 | 0.04162390306641222 | 115.89983702 | 116.11546685 | -0.001857029350607976 | -7.729680968118882e-05
 | 0.01758429663128603 | 99.55333333 | 99.552125 | 1.213766155164648e-05 | 2.134322411343072e-07
 | 0.05849520380328107 | 99.81014384 | 99.9320137 | -0.001219527711768745 | -7.133652204366175e-05
 | 0.02931890510228267 | 100.0534726 | 100.03561644 | 0.0001784980253579772 | 5.23336666641538e-06
 | 0.04409542955402811 | 99.85834722 | 100.56563889 | -0.007033134555766592 | -0.0003101290893478065
 | 0.04412648120308976 | 99.92866667 | 99.85404167 | 0.0007473408061600547 | 3.297752003532361e-05
 | 0.1731239141308477 | 98.01394444 | 98.32373611 | -0.00315073127055928 | -0.0005454669299336813
 | 0.04384580817269188 | 99.29305556 | 99.84651389 | -0.005543091175018269 | -0.0002430413123435923