tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 774375d1648442375-how-to-filter-a-cell-dependant-on-3-other-cells-drawercosting
Sheet: Lists

Brands | Models | Type | Depth | [NAME] | Height | KG |  | Blum | Type |  | AntKG | Ant_H | Antaro |  | [NAME] | Leg_H | Legrabox |  | [NAME] | Met_H | Metabox
 |  |  |  | 300 |  |  |  | Antaro | Inner |  | 30 | C | 270 |  | 40 | C | 270 |  | 25 | C | 270
 |  |  |  | 400 |  |  |  | Legrabox | [NAME] |  | 65 | M | 300 |  | 70 | F | 300 |  | 30 | F | 300
 |  |  |  | 500 |  |  |  | Metabox |  |  |  | MB | 350 |  |  | K | 350 |  | 40 | H | 350
 |  |  |  | 600 |  |  |  |  |  |  |  | MC | 400 |  |  | M | 400 |  | 65 | HB | 400
 |  |  |  | 700 |  |  |  |  |  |  |  | MD | 450 |  |  | N | 450 |  | 70 | K | 450
 |  |  |  | 800 |  |  |  |  |  |  |  | MDD | 500 |  |  |  | 500 |  |  | KB | 500
 |  |  |  | 900 |  |  |  |  |  |  |  | N | 550 |  |  |  | 550 |  |  | KD | 550
 |  |  |  | 1000 |  |  |  |  |  |  |  |  | 600 |  |  |  | 600 |  |  | M | 600
 |  |  |  | 1100 |  |  |  |  |  |  |  |  | 650 |  |  |  | 650 |  |  | MB | 650
 |  |  |  | 1200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MDD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N
 |  |  |  |  |  |  |  | DTC |  |  | SmoKG | Smo_H | Smooth |  | DraKG | Dra_H | Dragon
 |  |  |  |  |  |  |  | Dragon |  |  | 40 | C | 270 |  | 40 | C | 270
 |  |  |  |  |  |  |  | Smooth |  |  |  | F | 300 |  |  | F | 300
 |  |  |  |  |  |  |  |  |  |  |  | K | 350 |  |  | K | 350
 |  |  |  |  |  |  |  |  |  |  |  | KD | 400 |  |  | M | 400
 |  |  |  |  |  |  |  |  |  |  |  | M | 450 |  |  | N | 450
 |  |  |  |  |  |  |  |  |  |  |  | MB | 500 |  |  |  | 500
 |  |  |  |  |  |  |  |  |  |  |  | MD | 550 |  |  |  | 550
 |  |  |  |  |  |  |  |  |  |  |  | MDD | 600 |  |  |  | 600
 |  |  |  |  |  |  |  |  |  |  |  | N
 |  |  |  |  |  |  |  | [NAME] |  |  | HarKG | [NAME] | [NAME]
 |  |  |  |  |  |  |  | Impaz |  |  | 30 | H | 270
 |  |  |  |  |  |  |  |  |  |  |  | HB | 300
 |  |  |  |  |  |  |  |  |  |  |  | K | 350
 |  |  |  |  |  |  |  |  |  |  |  | KB | 400
 |  |  |  |  |  |  |  |  |  |  |  | KD | 450
 |  |  |  |  |  |  |  |  |  |  |  | M | 500
 |  |  |  |  |  |  |  |  |  |  |  | MB | 550
 |  |  |  |  |  |  |  |  |  |  |  | MD | 600
 |  |  |  |  |  |  |  |  |  |  |  |  | 650
Spreadsheet: 28491d1222782526-add-value-of-cells-if-they-contain-a-letter-f_sum_example
Sheet: Sheet1

Hours of Absence | Vacation Days | Disability Days | Total FMLA Time | 2008-01-01 00:00:00 | 2008-01-02 00:00:00 | 2008-01-03 00:00:00 | 2008-01-04 00:00:00 | 2008-01-05 00:00:00 | 2008-01-06 00:00:00 | 2008-01-07 00:00:00 | 2008-01-08 00:00:00 | 2008-01-09 00:00:00 | 2008-01-10 00:00:00 | 2008-01-11 00:00:00
8.8 | 2 | 1 |  | 1 F | V | 7.5 | 3.8 F | 1 | D | 0.3 | .5 F |  | V
 | Need to add the VALUE of cells that contain "F".
Spreadsheet: 102509d1300438163-distribution-list-who-needs-to-see-what-a-list-of-names-for-each-item-distribution-list
Sheet: Sheet1

Pink Dog |  |  |  | EN | EN | EN | EN |  | EN | EN | EN | EN |  | EN | EN | EN | EN | EN | EN | EN
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | EN | EN | EN
White Horse |  |  |  |  |  |  |  |  |  |  |  |  |  | EN | EN | EN
Yellow Fish |  |  |  |  |  |  | EN |  |  |  |  |  |  | EN | EN | EN
Green Frog |  |  |  | EN | EN |  |  |  |  |  |  |  |  | EN | EN | EN
[NAME] |  |  |  |  |  |  |  |  |  | EN |  |  |  | EN | EN | EN | EN | EN | EN | EN
Black Deer |  |  |  |  |  |  |  |  |  |  |  |  |  | EN | EN | EN
Silver Worm |  |  |  |  |  |  | EN |  |  |  |  |  |  | EN | EN | EN |  |  | EN
[NAME] |  |  |  |  | EN |  |  |  |  |  |  |  |  | EN | EN | EN
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | EN | EN | EN
Red Pig |  |  |  |  |  |  |  |  |  |  |  |  |  | EN | EN | EN |  |  |  | EN
Indigo Ant |  |  |  |  |  |  |  |  |  |  |  |  |  | EN | EN | EN
Lime Otter |  |  |  |  |  |  |  |  |  | EN |  |  |  | EN | EN | EN
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | EN | EN | EN
Spreadsheet: b971b25d-c8ee-4206-891d-cce724deb6d6
Sheet: Sheet1

Traumatic Brain Injury Emergency Department Visits, by Year, Maine, 2000-2009 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Year | Number | Crude Rate |  | Age-adjusted Rate
 |  | Rate | 95% CI | Rate | 95% CI
2000 | 5391 | 422.066 | 410.9 - 433.5 | 442.91 | 431.1 - 455.0
2001 | 5797 | 451.313 | 439.8 - 463.1 | 472.939 | 460.7 - 485.4
2002 | 6223 | 480.739 | 468.9 - 492.8 | 503.841 | 491.3 - 516.7
2003 | 6597 | 505.234 | 493.1 - 517.6 | 523.846 | 511.1 - 536.8
2004 | 7026 | 533.383 | 521.0 - 546.0 | 554.484 | 541.4 - 567.8
2005 | 7488 | 566.627 | 553.9 - 579.6 | 589.584 | 576.1 - 603.3
2006 | 7802 | 590.357 | 577.3 - 603.6 | 615.446 | 601.7 - 629.5
2007 | 8711 | 661.324 | 647.5 - 675.4 | 686.291 | 671.7 - 701.1
2008 | 9222 | 700.517 | 686.3 - 715.0 | 723.147 | 708.2 - 738.4
2009 | 10562 | 801.183 | 786.0 - 816.6 | 826.437 | 810.4 - 842.7
Data Source: Maine Hospital Inpatient and Outpatient Databases; Maine Health Data Organization. Traumatic brain injury emergency department visits are defined as emergency department visits by Maine residents at non-rehabilitation/psychiatric hospitals for which the principal and/or one of the secondary diagnoses is coded as ICD-9-CM code 800.0-801.9, 803.0-804.9, 850.0-850.9, 851.0-854.1, 950.1-950.3, 959.01, or 995.55, and either the principal diagnosis was an injury or an external cause of injury was reported. Crude rates are emergency department visits per 100,000 population. Age-adjusted rates are emergency department visits per 100,000 population age-adjusted to the U.S. 2000 standard population. 95% CI: 95% confidence interval of the rate.
Spreadsheet: 89618d1289399533-dropping-lowest-grade-remove-appropriate-test-maxima
Sheet: Sheet1

SCORES | TEST MAX
6 | 10 | 0.6 | 6 | 10
1 | 10 | 0.1
10 | 20 | 0.5 | 10 | 20 |  |  | 0.05 | 0 | 6
8 | 10 | 0.8 | 8 | 10 |  |  | 0.1
7 | 10 | 0.7 | 7 | 10 |  |  | 0.25
5 | 20 | 0.25 |  |  |  |  |  |  | 1 | 20
4 | 10 | 0.4 | 4 | 10 |  |  |  |  | 1 | 10
17 | 20 | 0.85 | 17 | 20 |  |  |  |  | 5 | 20
17 | 20 | 0.85 | 17 | 20 |  |  |  | 0
5 | 10 | 0.5 | 5 | 10
4 | 10 | 0.4 | 4 | 10
4 | 10 | 0.4 | 4 | 10
7 | 20 | 0.35 | 7 | 20
10 | 20 | 0.5 | 10 | 20
14 | 20 | 0.7 | 14 | 20
1 | 20 | 0.05
9 | 20 | 0.45 | 9 | 20
 |  |  | 122 | 210
129 | 260 | <-All Scores | 0.580952380952381
123 | 220 | <-Sans 3 Smallest
 |  |  | 0.04918032786885246
Spreadsheet: 888261d1738748147-match-date-values-to-create-a-gantt-type-visual-sample-2
Sheet: Sheet1

 | Audit 1 Qtr Start | Audit 2 Qtr Start | Audit 3 Qtr Start | Q1-24 | Q2-24 | Q3-24 | Q4-24 | Q1-25 | Q2-25 | Q3-25 | Q4-25 | Q1-26 | Q2-26 | Q3-26 | Q4-26
Product #1 | Q1-24 | Q1-25 | Q2-26 | x |  |  |  | x |  |  |  |  | x
Product #2 | Q1-24 | Q2-25 | Q3-26 | x |  |  |  |  | x |  |  |  |  | x
Product #3 | Q2-24 | Q3-25 | Q4-26 |  | x |  |  |  |  | x |  |  |  |  | x
Product #4 | Q3-24 | Q4-25 | Q4-26 |  |  | x |  |  |  |  | x |  |  |  | x
Spreadsheet: 131293d1322845286-help-manipulating-data-to-produce-desired-pivot-table-results-64rad_help-request
Sheet: Sheet3

ID | Group | DataWaveNo. | ProblemNo. | SolutionNo. | [NAME] | PersonAssigned | TimelineSet | ActionPlan
E01 | Experimental | 1 | NA | NA | 0 | 0 | 0 | 0
E01 | Experimental | 2 | 1 | 1 | 1 | 1 | 1 | 1
E01 | Experimental | 3 | 1 | 1 | 0 | 0 | 0 | 0.75
E01 | Experimental | 3 | 1 | 2 | 1 | 1 | 1 | NA
E01 | Experimental | 3 | 2 | 1 | 1 | 1 | 1 | 1
 |  | Group | ID | DataWaveNo. | ProblemNo. | SolutionNo. | Average of ActionPlan
 |  | Experimental
 |  |  | E01
 |  |  |  | 1
 |  |  |  |  | NA
 |  |  |  |  |  | NA | 0
 |  |  |  |  | NA Average |  | 0
 |  |  |  | 1 Average |  |  | 0
 |  |  |  | 2
 |  |  |  |  | 1
 |  |  |  |  |  | 1 | 1
 |  |  |  |  | 1 Average |  | 1
 |  |  |  | 2 Average |  |  | 1
 |  |  |  | 3
 |  |  |  |  | 1
 |  |  |  |  |  | 1 | 0.75
 |  |  |  |  |  | 2 | excluded
 |  |  |  |  | 1 Average |  | 0.75
 |  |  |  |  | 2
 |  |  |  |  |  | 1 | 1
 |  |  |  |  | 2 Average |  | 1
 |  |  |  | 3 Average |  |  | 0.875
 |  | Experimental Total |  |  |  |  | 0.6875
Spreadsheet: 0a12274d-d6bc-41c2-af3c-f5a83db3cda0
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
LOS CIRUELITOS
 | CALENDARIO OFICIAL SERIE REGULAR
 | EQUIPO  A                 EQUIPO  B                        DIA |  |  |  |  |  |  |  |  |  | HORA
 | 1. LOS PAPIS   VS.   LA CALLE 11 -  DOMINGO 06/02/11   -   9:00 A.M.
 | 2. LA [NAME] 11 VS. LA CALLE 26 -  DOMINGO 06/02/11  -  10:30 A.M.
 | 3. LA CALLE 26  VS.  LOS PAPIS  -  DOMINGO 06/02/11   -  12:00 A.M.
 | 4. LA CALLE 11  VS.  LA CALLE 26 -  DOMINGO 20/02/11  -  9:00 A.M.
 | 5. LA CALLE 26  VS.  LOS PAPIS  -   DOMINGO 20/02/11  -  10:30 A.M.
 | 6. LOS PAPIS      VS.  LA CALLE 26 - DOMINGO 06/02/11 -  12:00 A.M.
 | 7. LA CALLE 26   VS.   LOS PAPIS  -  DOMINGO 27/02/11   -  9:00 A.M.
 | 8. LOS PAPIS       VS.   LA CALLE 1 - DOMINGO 27/02/11 -  10:30 A.M.
 | 9. LA CALLE 11   VS.   LA CALLE 26 - DOMINGO 27/02/11 - 12:00 A.M.
 | 10. LOS PAPIS   VS.   LA CALLE 11 -  DOMINGO 06/03/11  -   9:00 A.M.
 | 11. LA CALLE 11 VS. LA CALLE 26 -  DOMINGO 06/03/11 -  10:30 A.M.
 | 12. LA CALLE 26  VS.  LOS PAPIS  -  DOMINGO 06/03/11  -  12:00 A.M.
 | LOS JUEGOS SE REALIZARAN EN EL PLAY DE CHICHI VASQUEZ
Spreadsheet: 685819d1594213402-complex-search-lookup-scenario-2020-07-08-oeldere-mirazojm-685815d1594212687-complex-search-lookup-scenario-lookup-example
Sheet: Materials from ERP

helpcolumn |  |  |  | Subtotal
 | 1111 TASK 1
 | Article | Qty (Actual) | Qty (Predicted) | Difference | Cost (Actual) | Cost (Predicted) | Difference
 | 11.20   Danopol HS 1.2 LIGHT GREY  (1,80 x 20 m) | 0 | 0.2 | -0.2 | 0 | 0.87 | -0.87
 |  |  |  | Subtotal | 0 | 0.87 | -0.87
 | 2222 TASK 2
 | Article | Qty (Actual) | Qty (Predicted) | Difference | Cost (Actual) | Cost (Predicted) | Difference
 | 05.06  Plástico para embalar serigrafiado | 0 | 72 | -72 | 0 | 16.12 | -16.12
 |  |  |  | Subtotal | 0 | 16.12 | -16.12
 | 3333 TASK 3
 | Article | Qty (Actual) | Qty (Predicted) | Difference | Cost (Actual) | Cost (Predicted) | Difference
 | 03.62  Tablero Eterboard 2500 x 1220 x 6 mm | 0 | 6 | -6 | 0 | 48.54 | -48.54
 | 16.CT32  [NAME] BCT-32 | 0 | 36 | -36 | 0 | 0.31 | -0.31
 | 17.03  Sellador de poliuretano Brik-Cen CU-291 blanco | 0 | 0.6 | -0.6 | 0 | 1.53 | -1.53
 |  |  |  | Subtotal | 0 | 50.38 | -50.38
 | 4444 TASK 4
 | Article | Qty (Actual) | Qty (Predicted) | Difference | Cost (Actual) | Cost (Predicted) | Difference
 | 03.83  Friso MDF Vintage 190x8x2600 mm | 90 | 0 | 90 | 667.8 | 0 | 667.8
 | 16.CA30  Clavo alfiler 30 [NAME] | 1000 | 0 | 1000 | 1.8 | 0 | 1.8
 | 16.CAMG30  Clavo alfiler 30 mm MG | 0 | 2250 | -2250 | 0 | 5.63 | -5.63
 | 17.02  [NAME] HM-425 | 4 | 4 | 0 | 6.64 | 6.64 | 0
 | 17.08  Sellador silicona neutra [NAME]-cen [NAME] RAL 9001 | 1 | 0 | 1 | 2.29 | 0 | 2.29
 | 9903.FB04  Guardavivo MDF 2600 x 28 x 28 | 5 | 5 | 0 | 30.95 | 17.55 | 13.4
 | 9903.FBD03  Friso MDF paredes | 0 | 125 | -125 | 0 | 629.14 | -629.14
 | 9903.FBD05  Junquillo MDF 2600 x 15 x 15 | 0 | 5 | -5 | 0 | 8.17 | -8.17
 |  |  |  | Subtotal | 709.48 | 667.13 | 42.35
 | I enclose a sample file to better understand the situation. In yellow I have highlighted the text string I need to lookup, and in blue the data which I need to extract into a summary sheet, also included in the sample file.
 | I could edit the exported file and extract the data manually, but I need to do this data manipulation very often (daily) and for a large amount of work orders, so doing this manually is out of the question in terms of the time it would take and the room for errors. Ideally, I would export the sheet directly from the ERP system in the set format and make Excel extract the data with formulae. I'm relatively good with lookups and match/index formulae, but this is proving to be taxing for me, especially because of the indeterminate size of each block.
 | Any ideas? I'll be much obliged.
Spreadsheet: 862426d1710162767-referencing-a-list-of-cells-in-a-non-sequential-layout-for-a-report-audit_longbrian
Sheet: Sheet2

Report
Title 1 |  |  |  |  |  | Yes
Question |  | Question 1
Why are we asking? |  | Reason 1
Business Alalysis
Title 2 |  |  |  |  |  | Yes
Question |  | Question 2
Why are we asking? |  | Reason 2
Business Alalysis
Title 3 |  |  |  |  |  | Yes
Question |  | Question 3
Why are we asking? |  | Reason 3
Business Alalysis
Spreadsheet: 193733d1352924308-help-adding-numbers-from-7000-60-000-automatically-book2
Sheet: Sheet1

7000
Spreadsheet: 712677d1610371831-weighted-average-through-sumproduct-weighted-average-3
Sheet: Test

 | Cost | Labour |  | Cost | Mats |  | Cost | Sub-Con
AAA | 509.98 | 7 |  | 0 | 0 |  | 4000 | 6
AAD | 0 | 0 |  | 7.56 | 8 |  | 0 | 0
AAF | 454.22 | 9 |  | 0 | 0 |  | 30 | 7
AAF | 454.22 | 9 |  | 0 | 0 |  | 30 | 7
Spreadsheet: 0d9b62ff-7ea7-4f8c-9fde-dbb76d86aca2
Sheet: Approvals-TH

Approval Categories - Temporary Help |  |  | Start Over
[NAME]
IHFOAP | T4 / ST Non PERSI Original Appointment
IHFRSP | T4 / ST Non PERSI Reappointment Previous PCN / Suffix
IHFRDP | T4 / ST Non PERSI Reappointment New PCN / Suffix
IHFAAP | T4 / ST Non PERSI Additional Appointment New PCN / Suffix
IHAAPP | T4 / ST Non PERSI Additional Appointment Previous PCN / Suffix
IHFCSP | T4 / ST Non PERSI Continuation Previous Non PERSI PCN / Suffix
IHCNPS | T4 / ST Non PERSI Change to New Non PERSI PCN / Suffix
COMMON TO TEMPORARY HELP NON-PERSI STUDENT/NON STUDENT
IHCPAY | T4 / ST Non PERSI Change of Pay
IHLDST | T4 / ST Non PERSI Change Labor Distribution
IHMISC | T4 / ST Non PERSI Miscellaneous Change
IHTRMJ | T4 / ST Non PERSI Terminate Job
GTSORG | Change of Time Sheet Org (For all Employee Classes)
[NAME] ELIGIBLE
IPFOAP | T1 PERSI Original Appointment
IPFRSP | T1 PERSI Reappoint Previous PCN / Suffix
IPFRDP | T1 PERSI Reappoint New PCN / Suffix
IPFAAP | T1 PERSI Additional Appointment New  PCN / Suffix
IPAAPP | T1 PERSI Additional Appointment Previous PCN / Suffix
IPCNPS | T1 PERSI Change to New PERSI PCN / Suffix
COMMON TO TEMPORARY HELP PERSI ELIGIBLE
IPCPAY | T1 PERSI Change of Pay
IPLDST | T1 PERSI Labor Distribution Change
IPMISC | T1 PERSI Miscellaneous Change
IPTRMJ | T1 PERSI Termination of Job
WORK STUDY
WSOAPT | Work Study Original Appointment
WSREDP | Work Study Reappointment New PCN / Suffix
WSRESP | Work Study Reappointment Previous PCN / Suffix
WSAANP | Work Study Additional Appointment New PCN / Suffix
WSAAPP | Work Study Additional Appointment Previous PCN / Suffix
WSTRMJ | Work Study Termination of Job
WSCPAY | Work Study Change of Pay
WSMISC | Work Study Miscellaneous Change
UNIT PAY
IHUPOA | Unit Pay Original Appointment
IHUPAN | Unit Pay Additional Appointment New PCN / Suffix
IHUPAP | Unit Pay Additional Appointment Previous PCN / Suffix
IHUPRN | Unit Pay Reappointment New PCN / Suffix
IHUPRP | Unit Pay Reappointment Previous PCN / Suffix
Spreadsheet: 23619d1213193286-searching-for-bold-text-book1-jun11
Sheet: Sheet1

CASH
 | 100162 | CASH | 22146 | 0 | 99.14
 |  |  |  |  | 99.14
CHECK
 | 100079 | Payment: | 2203 | 0 | 420.47
 | 100081 | Payment: | 2204 | 0 | 1012.14
 | 100083 | Payment: | 2205 | 0 | 440.55
 | 100085 | Payment: | 2206 | 0 | 346.16
 | 100087 | Payment: | 2207 | 0 | 68.35
 | 100089 | Payment: | 2208 | 0 | 1292.73
 |  |  |  |  | 3580.4
END
 |  |  |  | Grand Total | 3679.54
Spreadsheet: louise_kitchen__22840__Hot List Update 6-5-01
Sheet: Offshore

Deal Description Sheet - 6/5/01
Production Offshore
YTD P & L | 3052000
Project Name | Counterparty | Description | Potential Valuation | Last Customer Contact | Probability | Expected Closing (Month/Year) | Weekly Updates / Comments
Shallow-Water | VanKirk & Riles | Shallow-water used platform and gathering line sale & lease/financing business with small to mid-sized E&P independents. | 500000 | 2001-05-30 00:00:00 | 0.1 | 2001-08-01 00:00:00 | Target client list being updated; potential deals w/McMoran, ATP, [NAME], and Gryphon.  Joint marketing to begin in late May.  Working on proposal for [NAME] and Gryphon.
Bridge | Callon Petroleum | Deferred Volumetric Production payment on Medusa and other deepwater reserves. | 500000 | 2001-06-03 00:00:00 | 0.1 | 2001-08-01 00:00:00 | Working with Enron Energy Capital Resources on joint bridge financing proposal for Callon.  Received model from Callon after signing C.A.  Model being evaluated by RAC and ECR for a VPP proposal.
[NAME] | [NAME] | Volumetric Production payment on McMoRan Offshore Reserves. | 500000 | 2001-06-03 00:00:00 | 0.1 | 2001-08-01 00:00:00 | Working with Enron Energy Capital Resources on a VPP proposal.  Waiting on additional reserve information.
Spreadsheet: 47011d1245928933-excel-formatting-and-function-cool
Sheet: Final

 |  |  |  |  |  |  |  |  | OCR  Nationals Level 2
 |  |  |  |  |  |  |  |  | Unit 20 Animation
 |  |  |  | FFT Y7 TARGET | FFT Y8 TARGET | FFT Y9 TARGET | End Y8 NC LEVEL | Y9 July levels |  |  |  |  |  |  | AO1 | AO2 | AO3 | AO4 | Points | Suggested Grade | Final Grade Awarded
ENGLISH | MATHS | SCIENCE | Special Needs |  |  |  |  |  | SURNAME | FORENAME | FORM | GENDER | Teacher | Group | Select  P/M/D | Select  P/M/D | Select  P/M/D | Select  P/M/D
 |  |  |  | 5c | 5b | 6c | 5a | 6c |  |  |  |  |  |  | D | D | D | D | 12 | Distinction
 |  |  |  | 5b | 6c | 6b | 5c | 6b |  |  |  |  |  |  | P | P | P | P | 4 | Pass
4 | 4 | 5 |  | 5c | 5a | 6c | 5a | 6a |  |  |  |  |  |  | M | M | M | D | 9 | Merit
5 | 5 | 5 |  | 5a | 6c | 6b | 5b | 6c |  |  |  |  |  |  |  | D | D | D | 9 | INCOMPLETE
5 | 5 | 5
4 | 4 | 4
4 | 3 | 4
Spreadsheet: 1b09c658-948a-4184-a432-a3c62bd9d0a4
Sheet: 15c

 | Swap Dealers/MSPs4 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Index Tranche | 0 | 178 | 0 | 58
Index/OTHER* | 528970 | 12902 | 386494 | 11641
TOTAL | 528970 | 13080 | 386494 | 11699
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 885619d1735403220-how-to-count-numbers-in-a-column-without-counting-zeros-and-duplicate-numbers-office-2003-tes-copy-tms
Sheet: ورقة1

 | Source |  |  | Copy Link |  | windknife
 | 100
 | 200
 | 300 |  |  |  |  | TMS
 | 400
 | 400 |  |  |  |  |  | 1
 | 400 |  |  |  |  | 200 | 1
 | 500 |  |  |  |  | 300 | 1
 | 600 |  |  |  |  | 400 | 3
 | 700 |  |  |  |  | 500 | 1
 | 700 |  |  |  |  | 600 | 1
 | 700 |  |  |  |  | 700 | 4
 | 800 |  |  |  |  | 800 | 2
 | 700 |  |  |  |  | 900 | 1
 | 800
 | 900 |  |  |  |  | maxpit
 |  |  |  |  |  | 200
 |  |  |  |  |  | 300
 |  |  |  |  |  | 400
 |  |  |  |  |  | 500
 |  |  |  |  |  | 600
 |  |  |  |  |  | 700
 |  |  |  |  |  | 800
 |  |  |  |  |  | 900
 |  |  |  |  |  | TMS
 |  |  |  |  |  | HSV
Spreadsheet: 738443d1625043762-divide-and-add-the-remaining-value-equally-into-6-months-formula
Sheet: Sheet1

 |  |  |  |  | January | February | March | April | May | June | Total
 |  |  |  | Main pt | 22 | 22 | 22 | 22 | 22 | 22
 |  |  |  | Point a | 4.065541512147128 | 4.065541512147128 | 4.065541512147128 | 4.065541512147128 | 4.065541512147128 | 4.065541512147128 |  |  | If sum of F6 to K6 is greater that 21 , subtract sum of 21 from  sum(F6 to K6) and what ever the result comes , divide it equally from F3 to K3
 |  |  |  | Steps
 |  |  | a. | 24.39325 is greater than 21
 |  |  | b.
 |  |  | c. | Divide 3.393249 equally from January to June and add from F3 to K3
 |  |  | Final result should be in Main pt :
 |  |  |  |  | January | February | March | April | May | June
 |  |  |  | Main pt
Spreadsheet: 736369d1623555858-sum-formula-cell-error-formatting-sum-formula-error
Sheet: Sheet3

Date | [NAME] | Name | Total Amount | Receipt | Cash Receipt | Bank Deposit | Total Due
2021-04-01 00:00:00 | 1 | Kasthuri Enterprises | 566 | 600
2021-04-01 00:00:00 | 2 | Algreen Cottage Industries | 1523 | 1550
2021-04-01 00:00:00 | 3 | Murugesan | 972 | 972
2021-04-01 00:00:00 | 4 | MRK Cottage Industries | 912 | 912
2021-04-01 00:00:00 | 5 | Jahir, Natchiyarkoil | 370 | 370
2021-04-01 00:00:00 |  | Saravana Food Product | 0 |  |  | 25000
2021-04-02 00:00:00 | 6 | Amman Aqua Products | 16500
2021-04-02 00:00:00 | 7 | [NAME], Sakkottai | 486.0000000000001 | 485
2021-04-02 00:00:00 | 8 | Saravanan AG | 2515 | 2550
2021-04-02 00:00:00 | 9 | SAV Traders | 1037 | 1037
2021-04-02 00:00:00 | 10 | Algreen Cottage Industries | 5202 | 5000
2021-04-02 00:00:00 | 11 | [NAME] | 300 | 300
2021-04-02 00:00:00 | D1 | [NAME], Kumbakonam | 392 | 362
2021-04-03 00:00:00 | 12 | [NAME], Kumbakonam | 5863.000000000001
2021-04-03 00:00:00 | 13 | Gnanasekaran, Sathish Kumar Oil Mill | 792.0000000000001 | 792
2021-04-03 00:00:00 | 14 | Sowra Plastic | 26301
2021-04-03 00:00:00 | 15 | Sowra Plastic | 24662 | 15000 |  | 10000
2021-04-03 00:00:00 | 16 | [NAME] | 200 | 200
2021-04-03 00:00:00 | D3 | Local Sales | 100 | 100
2021-04-03 00:00:00 | D4 | Local Sales | 100 | 100
2021-04-03 00:00:00 | 17 | Saravanan, Thukkachi | 871.0000000000002 | 870
2021-04-03 00:00:00 | 18 | Algreen Cottage Industries | 454 | 550
2021-04-03 00:00:00 | 19 | Mangalambigai Traders | 3696 |  |  | 3190
2021-04-03 00:00:00 |  | [NAME], [NAME] | 0 |  |  | 30000
2021-04-04 00:00:00 | 20 | PS Sweets, Trichy | 31405 | 31405
Spreadsheet: 863446d1710936758-how-to-index-from-an-array-if-a-cell-matches-a-different-array-how-to-index-from-an-array-if-a-cell-matches-a-different-array-1-
Sheet: Mock-up

Name | Reference | Applicable to | Reference | R-H |  | R-XR |  | A-C
1240.pdf |  |  | C001 | N/A | N/A | N/A | N/A | N/A | N/A
 | C006 |  | C002 | some random text 1240.pdf | G | some random text 8213.pdf | G | some random text 7202.pdf | A
 | C007 |  | C003 | N/A | N/A | N/A | N/A | N/A | N/A
 |  |  | C004 | N/A | N/A | N/A | N/A | N/A | N/A
8213.pdf |  |  | C005 | N/A | N/A | N/A | N/A | N/A | N/A
 | C006 |  | C006 | some random text 1240.pdf | G | some random text 8213.pdf | G | some random text 807.pdf | G
 |  |  | C007 | some random text 1240.pdf | G | some random text 201.pdf | G | N/A | N/A
201.pdf |  |  | C008 | N/A | N/A | N/A | N/A | N/A
 | C010 |  | C009 | N/A | N/A | N/A | N/A | some random text 7202.pdf | G
 |  |  | C010 | N/A | N/A | some random text 201.pdf | G | N/A | N/A
7202.pdf
 | C009
807.pdf
Spreadsheet: 711528d1609771736-trying-to-copy-a-cell-numerical-value-if-a-condition-is-met-groceries-copy
Sheet: Sheet1

Groceries January 2021
Date | Store | Description | Category | Amount | Fruit | Veggies | Non-Food | Off-Plan
2021-01-03 00:00:00 | Aldi | Blueberries | Fruit | 1.79
2021-01-03 00:00:00 | Aldi | Blueberries | Fruit | 1.79
2021-01-03 00:00:00 | Aldi | Spinach | Vegetables | 1.19
2021-01-03 00:00:00 | Aldi | Cucumbers | Vegetables | 2.19
2021-01-03 00:00:00 | Aldi | Green Onions | Vegetables | 0.79
2021-01-03 00:00:00 | Aldi | [NAME] | Vegetables | 0.89
2021-01-03 00:00:00 | Aldi | Tomatoes | Vegetables | 2.99
2021-01-03 00:00:00 | Aldi | Broccoli | Vegetables | 2.91
2021-01-03 00:00:00 | Aldi | Bananas | Fruit | 0.82
2021-01-03 00:00:00 | Wegmans | [NAME] | Non-Food | 3.99
2021-01-03 00:00:00 | Wegmans | Cheetos | Off-Plan | 0.5
2021-01-03 00:00:00 | Wegmans | Fritos | Off-Plan | 0.5
2021-01-03 00:00:00 | Wegmans | [NAME] | Vegetables | 2.99
2021-01-03 00:00:00 | Wegmans | Red Onion | Vegetables | 2.11
2021-01-03 00:00:00 | Wegmans | Red Pepper | Vegetables | 4.19
2021-01-03 00:00:00 | Wegmans | Sweet Potatoes | Vegetables | 1.86
2021-01-03 00:00:00 | Wegmans | Red Swiss Chard | Vegetables | 2.99
2021-01-03 00:00:00 | Wegmans | Parsley | Vegetables | 1.49
2021-01-03 00:00:00 | Wegmans | Romaine | Vegetables | 3
2021-01-03 00:00:00 | Wegmans | Ginger | Vegetables | 1.38
2021-01-03 00:00:00 | Wegmans | Arugula | Vegetables | 1.5
2021-01-03 00:00:00 | Wegmans | Mushrooms | Vegetables | 10
2021-01-03 00:00:00 | Wegmans | Tax | Tax | 0.32
Totals
Spreadsheet: eric_saibi__9845__010801R
Sheet: James A Fitzpatrick

Owner Name |  | Entergy Nuclear Generation Company
Station Name |  | [NAME]
Plant ID |  | 1503222
Unit Name |  | [NAME] 01
Unit ID |  | 1005229
NERC Region |  | NPCC
State |  | NY
Fuel Type |  | nuclear
Capacity |  | 883
Start Date
End Date
Prv. Start Date
Prv. End Date
Outage ID
Comments |  | Operating at 60% to do an intake cleaning, not anticipating having to decrease power any further.  Should be to 100% in a day or two
SIC |  | 4911