tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 885697d1735518571-add-or-remove-rows-to-only-part-of-the-columns-of-a-table-add-or-embedd-a-row-into-columns-of-an-existing-table-r2
Sheet: Record

Team | Surname | First name | Number | [NAME] | Task A | Part of Task A completed | Blind column, just to filter for "TR" task A | Next part of Task A | x1 | Task B | Part of Task B completed | Blind column, just to filter for "TR" task B | Next part of Task B | x2 | Task C | Part of Task C completed | Blind column, just to filter for "TR" task C | Next part of Task C | [NAME] | Task D | Part of Task D completed | Blind column, just to filter for "TR" task D | Next part of Task D
A-Team | Bond | [NAME] | 80110909 |  | M06 | ADV | M06 | ADV-TR1 |  | M25 | ADV | M25 | ADV-TR1 |  | M16 | BSC-SF | M16 | BSC-TR1 |  | M11 | BSC-TR2 | M11 | ADV
A-Team | [NAME] | Hans | 80110917 |  | M07 | ADV | M07 | ADV-TR1 |  | M16 | ADV | M16 | ADV-TR1
A-Team | [NAME] | [NAME] | 80111125 |  | M15 | X | M15 | BSC |  | M05 | X | M05 | BSC |  | M04 | X | M04 | BSC
A-Team | [NAME] | Micky | 80110912 |  | M22 | BSC-SF | M22 | BSC-TR1 |  | M05 | X | M05 | BSC |  | M45 | X | M45 | BSC
A-Team | Potter | [NAME] | 80110733 |  | M15 | BSC | M15 | BSC-SF |  | M05 | X | M05 | BSC |  | M09 | BSC-SF | M09 | BSC-TR1
M-Team | Edison | Wayne | 80111210 |  | M03
M-Team | [NAME] | [NAME] | 80111005 |  | M03
M-Team | [NAME] | Johnson Onuche | 80110907 |  | M18 | X | BSC |  | M25 IME | X | BSC
M-Team | Jordan | Mick | 80111179 |  | M03 | BSC-SF | BSC-TR1 |  | M04 | BSC-SF | BSC-TR1
M-Team | Moses | Mark | 80110911 |  | M07 | ADV-TR2 | [NAME] |  | M22 | ADV | ADV-TR1
E-Team | Adams | [NAME] | 80078167 |  | M05 IME | BSC-IME | BSC-SF
E-Team | [NAME] | [NAME] | 80078168 |  | M05 IME | BSC-SF | BSC-TR1
E-Team | [NAME] | Kenny | 80077694 |  | M07 IME | BSC-TR1 | BSC-TR2
E-Team | [NAME] | [NAME] | 80110908 |  | M06 IME | ADV-TR1 | ADV-TR2
A-Team | C | D | 89000001
E-Team | D | E | 89000001
M-Team | F | G | 89000001
Spreadsheet: 841143d1693392185-help-required-to-restructure-an-excel-file-bom-bill-of-material-sample-bom-information
Sheet: Sample Output

Item | Part Number | Description | QTY
2 |  | Zone 2
2.2 |  | A00027
2.2.1 | Part 946 | Description 947 | 68
2.2.2 | Part 947 | Description 948 | 94
2.2.3 | Part 948 | Description 949 | 4
2.2.4 | Part 949 | Description 950 | 14
2.2 |  | A00028
2.2.1 | Part 950 | Description 951 | 71
2.12 |  | A00037
2.12.1 | Part 1256 | Description 1257 | 1
2.12.2 | Part 1257 | Description 1258 | 1
2.12.3 | Part 1258 | Description 1259 | 1
2.12.4 | Part 1259 | Description 1260 | 1
7 |  | Zone 4
7.4 |  | A00075
7.4.1 | Part 2538 | Description 2539 | 2
7.4.2 | Part 2539 | Description 2540 | 686
7.4.3 | Part 2540 | Description 2541 | 46
7.8 |  | A00079
7.8.1 | Part 2618 | Description 2619 | 4
7.8.2 | Part 2619 | Description 2620 | 2
7.16 |  | A00087
7.16.1 | Part 2891 | Description 2892 | 1
7.16.2 | Part 2892 | Description 2893 | 2
Spreadsheet: 141779d1329437058-data-validation-multiple-selection-copy_crm1
Sheet: Events

Buyers name | Contact person | Datum | Description
SAP | Davor | 2012-01-10 00:00:00 | Telefon call
SAP | Vesna | 2012-01-12 00:00:00 | Telefon call
IKEA | [NAME] | 2012-01-17 00:00:00 | enquiry
IKEA | Stjepan | 2012-01-18 00:00:00 | enquiry
Spreadsheet: 858146d1706893121-create-a-index-match-formula-where-if-two-cells-meet-criteria-a-third-cell-is-returned-excel-test
Sheet: Sheet1

 |  |  | Running Totals |  |  |  |  | AAAAAA
Year | Mth | Day | Date | Description | Current Amt | Current Balance | Projected Balance | 1
 |  |  | 2023-12-20 00:00:00 | gfn | -49 | 468.21 | 468.21
 |  |  | 2023-12-20 00:00:00 | ;lkj | -200 | 268.21 | 268.21
 |  |  | 2023-12-20 00:00:00 | ,[NAME] | -268.21 | 0 | 0
 |  |  | 2023-12-20 00:00:00 | dfgh | -26 | -26 | -26
 |  |  | 2023-12-20 00:00:00 | dfgh | -86 | -112 | -112
 |  |  | 2023-12-20 00:00:00 | uyt | -16.62 | -128.62 | -128.62
 |  |  | 2023-12-20 00:00:00 | dfghjhgf | -125 | -253.62 | -253.62
 |  |  | 2023-12-22 00:00:00 | ;lkj | -13.25 | -266.87 | -266.87
 |  |  | 2024-01-08 00:00:00 | oiuyt | -49 | -315.87 | -315.87
 |  |  | 2024-01-15 00:00:00 | wer | -30.99 | -346.86 | -346.86
 |  |  | 2024-01-19 00:00:00 | oiuyt | -99.34 | -446.2 | -446.2
 |  |  | 2024-01-22 00:00:00 | AAAAAA | 560 | 113.8 | 113.8
 |  |  | 2024-01-22 00:00:00 | nbv | -26 | 87.79999999999995 | 87.79999999999995
 |  |  | 2024-01-22 00:00:00 | dfg | -86 | 1.799999999999955 | 1.799999999999955
 |  |  | 2024-01-22 00:00:00 | rt | -13.25 | -11.45000000000005 | -11.45000000000005
 |  |  | 2024-01-22 00:00:00 | iuyt | -16.62 | -28.07000000000005 | -28.07000000000005
 |  |  | 2024-02-22 00:00:00 | dfghjhgf | -125
 |  |  | 2024-02-15 00:00:00 | mnbv | -27.09
Spreadsheet: 98399d1297305963-excel-2007-looking-for-help-making-a-formula-with-multiple-variables-feb-schedule-1-
Sheet: Feb 2

Day: | 2
[NAME] | Drive Thru | Trash | Food Prep | Dishes | Cashier
[NAME] | Smith | [NAME] | [NAME] | Jones | [NAME]
[NAME] | [NAME] | [NAME] | [NAME] | Moore | Wilson
Spreadsheet: 153907d1336095886-please-help-with-vlookup-test-job-index
Sheet: Drafting Progression

JOB ID# | CLIENT | JOB ADDRESS | START |  | BOOKED | DUE | PROGRESS
 |  |  |  |  |  |  | COMPLETED
 |  |  |  |  |  |  | COMPLETED
 |  |  |  |  |  |  | COMPLETED
 |  |  | 2012-02-08 00:00:00 |  |  |  | COMPLETED
 |  |  | 2012-02-09 00:00:00 |  |  |  | COMPLETED
 |  |  |  |  |  |  | COMPLETED
 |  |  |  |  |  |  | COMPLETED
 |  |  |  |  |  |  | COMPLETED
 |  |  |  |  |  |  | COMPLETED
 |  |  |  |  |  |  | COMPLETED
 |  |  |  |  |  |  | COMPLETED
 |  |  |  |  |  |  | COMPLETED
 |  |  | 2012-02-21 00:00:00 |  |  |  | COMPLETED
 |  |  | 2012-02-22 00:00:00 |  |  |  | COMPLETED
 |  |  | 2012-02-23 00:00:00 |  |  |  | COMPLETED
 |  |  |  |  |  |  | COMPLETED
 |  |  | 2012-02-29 00:00:00 |  |  |  | COMPLETED
 |  |  | 2012-02-28 00:00:00 |  |  |  | COMPLETED
 |  |  |  |  |  |  | COMPLETED
 |  |  |  |  |  |  | COMPLETED
 |  |  |  |  |  |  | COMPLETED
 |  |  |  |  |  |  | COMPLETED
 |  |  |  |  |  |  | COMPLETED
 |  |  |  |  |  |  | COMPLETED
 |  |  |  |  |  |  | COMPLETED
 |  |  |  |  |  |  | COMPLETED
 |  |  | 2012-03-14 00:00:00 |  |  |  | COMPLETED
 |  |  | 2012-03-15 00:00:00 |  |  |  | COMPLETED
 |  |  |  |  |  |  | COMPLETED
 |  |  | 2012-03-16 00:00:00 |  |  |  | COMPLETED
 |  |  | 2012-03-28 00:00:00 |  |  |  | COMPLETED
 |  |  |  |  |  |  | COMPLETED
2737-12 | MARK THOMPSON CONSTRUCTION | 34 RENWICK STREET, SOUTH PERTH | 2012-03-16 00:00:00 |  |  |  | COMPLETED
 |  |  | 2012-03-19 00:00:00 |  |  |  | COMPLETED
 |  |  | 2012-03-19 00:00:00 |  |  |  | COMPLETED
 |  |  | 2012-03-19 00:00:00 |  |  |  | COMPLETED
 |  |  | 2012-03-19 00:00:00 |  |  |  | COMPLETED
 |  |  | 2012-03-19 00:00:00 |  |  |  | COMPLETED
2745-12 | NISE HOMES | 38 VLASICH ROAD, BYFORD | 2012-03-20 00:00:00 |  |  |  | COMPLETED
 |  |  |  |  |  |  | COMPLETED
 |  |  |  |  |  |  | COMPLETED
 |  |  |  |  |  |  | COMPLETED
 |  |  |  |  |  |  | COMPLETED
 |  |  |  |  |  |  | COMPLETED
 |  |  |  |  |  |  | COMPLETED
 |  |  |  |  |  |  | COMPLETED
 |  |  |  |  |  |  | COMPLETED
 |  |  | 2012-03-29 00:00:00
 |  |  | 2012-03-29 00:00:00
 |  |  | 2012-03-29 00:00:00
2653-12 | Whaley | 4 [NAME], Morley | 2012-03-30 00:00:00
 |  |  | 2012-04-02 00:00:00
 |  |  | 2012-04-04 00:00:00
Spreadsheet: 214912d1361186446-need-to-sum-multiple-values-based-on-match-test
Sheet: Project 2

 | Week 13 | Week 14 | Week 15 | Week 16 | Week 17 | Week 18 | Week 19 | Week 20 | Week 21 | Week 22 | Week 23 | Week 24
Finance
[NAME]
[NAME]
[NAME]
[NAME]
HTML
Product Manager
Marketing
Total HC Man Months
Finance
[NAME]
[NAME]
[NAME]
[NAME]
HTML
Product Manager
Marketing
Total Cost
Spreadsheet: 355740d1414771339-populate-column-based-on-selection-from-a-dropdown-book1-ndm
Sheet: Sheet2

695 | Average
466 | Low
508 | Low
358 | High
287 | Average
597 | High
549 | High
481 | Low
96 | Average
912 | Average
Spreadsheet: 764668d1642865813-large-function-does-not-appear-in-power-pivot-measures-filter-and-sort-a-power-pivot-table-supporting-a-slicer-viewotst-
Sheet: Power Pivot

Sites | Period | Sum of Overdues
[NAME] | Q1 | 9
Nettetal | Q1 | 8
Barcelona | Q1 | 7
Sydney | Q1 | 5
Cartago | Q1 | 4
Grand Total |  | 33
Spreadsheet: 25cc9d99-5e48-467a-b48b-c0258255d913
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
8462 | 27355 | Ralf | [NAME] | GER | 0 | 00:09:07 | 00:06:23 | 00:32:41 | 00:00:59 | 00:18:38 | 1 | 01:07:49
Spreadsheet: 61516d1262389707-excel-2007-hours-calculation-example-hours2
Sheet: Pivot Table

Driver Type | (All)
Agency Supplier | (All)
 | Values
Row Labels | Sum of Hrs Worked | Sum of Paid Hours | Sum of O/T Hours
Jan | 1.408333333333333 | 1.181944444444444 | 0.2263888888888889
Kees | 0.3208333333333334 | 0.3208333333333334 | 0
Piet | 0.5305555555555556 | 0.5305555555555556 | 0
Grand Total | 2.259722222222222 | 2.033333333333333 | 0.2263888888888889
Spreadsheet: 132759d1323905392-counting-unique-values-from-list-with-specific-criteria-book1
Sheet: Sheet1

[NAME] | A | [NAME] |  | if (A3:A13) = C1, then count unique values in (B3:B13)
[NAME] | B
[NAME] | D |  |  | The result if C1 = [NAME] would be 3 as there are 3 unique values
[NAME] | A |  |  | The result if C1 = [NAME] would be 3 as there are 3 unique values
[NAME] | B |  |  | The result if C1 = [NAME] would be 2 as there are 2 unique values
[NAME] | E
[NAME] | D
[NAME] | D
[NAME] | A
[NAME] | A
[NAME] | B
Spreadsheet: 183334d1348781527-multiple-if-then-statement-if-and-lookup-for-mike029
Sheet: Sheet1

 | Type | Date | C or I
 | MK | 12/15/09
 | MK | 12/15/09
 | MK | 12/15/09
 | MK | 01/03/10
 | MK | 01/03/10
 | MK | 01/03/10
 | LO | 02/21/11
 | LO | 12/26/10
 | LO | 03/05/11
 | LO | 03/05/11
 | LO | 12/26/10
 | LO | 02/21/11
 | LO | 04/30/11
 | LO | 12/26/10
 | JK | 01/08/11
 | JK | 01/08/11
 | JK | 12/26/10
 | JK | 01/22/10
 | JK | 01/22/10
 | JK | 01/22/10
 | JK | 12/26/10
 | OA | 04/30/11
 | OA | 04/30/11
 | AL | 12/26/10
 | AL | 12/26/10
 | AL | 12/26/10
 | AL | 12/26/10
 | AL | 12/26/10
 | AL | 12/26/10
 | AL | 12/26/10
 | AL | 12/26/10
 | AL | 12/26/10
 | AL | 12/26/10
 | AL | 12/26/10
 | AL | 12/26/10
 | AL | 12/26/10
 | AL | 12/26/10
 | OA | 01/08/11
 | OA | 01/08/11
 | OA | 01/15/11
 | OA | 01/15/11
Spreadsheet: 20b79dd1-1377-4ba1-afd8-4e18abe51ac5
Sheet: Sheet1

Module | Price | Area | Voltage | # needed | Total Price | Unnamed: 6 | Unnamed: 7
60 W | 383.9 | 27” X 30” |  | 120 | 46068 |  | http://www.solarhome.org/
224 W | 1800 |  |  | 32 | 57600 |  | http://www.solarhome.org/
110 W | 582 | 59.1" x 39.0" | 16 | 66 | 38412 |  | http://www.affordable-solar.com/kyocera-KD210GX-LPU-210-watt-solar-panel.htm
135 W | 417 | 59.1” X 26.3” | 12 | 53 | 22101 |  | http://www.affordable-solar.com/kyocera-KD135GX-LPU-135-watt-solar-panel.htm
205 W | 572 | 65.0'' x 37.5'' | 12 | 35 | 20020 |  | http://www.affordable-solar.com/Evergreen-ES-A-205-fa3b-205W-PV-BLEM.htm
225 W | 602 | 66.39" x 39.12" | 20 | 32 | 19264 |  | [NAME]
235 W | 754 | 39.1" x 64.6" | 20 | 31 | 23374 |  | http://www.affordable-solar.com/sharp-NU-U235F1-235-watt-solar-panel.htm
224 W | 710 | 64.6" x 39.1" | 20 | 32 | 22720 |  | http://www.affordable-solar.com/sharp-ND-U224C1-224-watt-solar-panel.htm
230 W | 732 |  | 30 | 31 | 22692 |  | http://www.wholesalesolar.com/solar-panels.html#Sharp
224 W | 698.95 |  | 20 | 32 | 22366.4 |  | [NAME]
224 W | 780.95 |  | 24 | 32 | 24990.4 |  | [NAME]
230 W | 727.95 |  | 20 | 31 | 23294.4 |  | [NAME]
230 W | 732.95 |  | 24 | 31 | 22721 |  | [NAME]
175 W | 745 | 63.9” X 32” | 35.7 | 41 | 30545 | monocrystalline | [NAME]
230 W | 643.95 | 61.4” x 36.84” | 20 | 31 | 19962.45 |  | http://www.ecodirect.com/ProductDetails.asp?ProductCode=SolarWorld-SW230&site=google_base
 |  |  |  |  |  | number in pallet
175 W | 24400 | 63.4" x 31.2" | 24 | one pallet | 24400 | 40 | http://www.affordable-solar.com/solar-panel-pallet-solarworld-sw175-solar-panel.htm
135 W | 8038 | 59.1” x 26.3” | 12 | needed:53, two pallets:5400W | 16076 | 20 | [NAME]
175 W | 16, 742 |  | 24 | 41, one pallet: 5250W | 16, 742 | 30 | [NAME]
216 W | 19, 498 |  | 24 | 33, one pallet:6480W | 19, 498 | 30 | [NAME]
Spreadsheet: 781164d1653040147-help-with-executing-formula-based-on-ifs-conditions-help-depreciation
Sheet: Example

 | Description | Journal Account | Name of account |  | Date of Purchase | Starting Period | Value | Acquisition Value | Transfer Value | Life | Salvage | Value subject to depreciation | Yearly Depreciation | Accumulated Depreciation | Remaining Depreciation
N° |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022
1 | Building | 1234 | PP&E |  | 2018-10-31 00:00:00 |  | 5739850.66 | 5739850.66 | 5739850.66 | 40
Spreadsheet: 181241d1347975009-splitting-content-of-a-cell-copy-of-book188
Sheet: Sheet2

Number | Package | Discount
885135558 | 55862 | 56027 |  | 1
885135558 | 55862 | 53457 |  | 2
885135558 | 55862 | 56014 |  | 3
885135558 | 55862 | 3686 |  | 4
885135558 | 55862 | 56003 |  | 5
885135558 | 55862 | 56009 |  | 6
885151825 | 55863 | 56027 |  | 1
885151825 | 55863 | 53457 |  | 2
885151825 | 55863 | 56014 |  | 3
885151825 | 55863 | 3686 |  | 4
885151825 | 55863 | 56005 |  | 5
885151825 | 55863 | 56013 |  | 6
885151929 | 55862 | 56027 |  | 1
885151929 | 55862 | 53457 |  | 2
885151929 | 55862 | 56014 |  | 3
885151929 | 55862 | 3686 |  | 4
885151929 | 55862 | 56003 |  | 5
885151929 | 55862 | 56009 |  | 6
885155523 | 55863 | 56027 |  | 1
885155523 | 55863 | 53457 |  | 2
885155523 | 55863 | 56014 |  | 3
885155523 | 55863 | 3686 |  | 4
885155523 | 55863 | 56005 |  | 5
885155523 | 55863 | 56013 |  | 6
886157554 | 55862 | 56027 |  | 1
886157554 | 55862 | 53457 |  | 2
886157554 | 55862 | 56014 |  | 3
886157554 | 55862 | 3686 |  | 4
886157554 | 55862 | 56003 |  | 5
886157554 | 55862 | 56009 |  | 6
887670379 | 55863 | 56027 |  | 1
887670379 | 55863 | 53457 |  | 2
887670379 | 55863 | 56014 |  | 3
887670379 | 55863 | 3686 |  | 4
887670379 | 55863 | 56005 |  | 5
887670379 | 55863 | 56013 |  | 6
888000513 | 55862 | 56027 |  | 1
888000513 | 55862 | 53457 |  | 2
888000513 | 55862 | 56014 |  | 3
888000513 | 55862 | 3686 |  | 4
888000513 | 55862 | 56003 |  | 5
888000513 | 55862 | 56009 |  | 6
888137281 | 55863 | 56027 |  | 1
888137281 | 55863 | 53457 |  | 2
888137281 | 55863 | 56014 |  | 3
888137281 | 55863 | 3686 |  | 4
888137281 | 55863 | 56005 |  | 5
888137281 | 55863 | 56013 |  | 6
888239051 | 55863 | 56027 |  | 1
888239051 | 55863 | 53457 |  | 2
888239051 | 55863 | 56014 |  | 3
888239051 | 55863 | 3686 |  | 4
888239051 | 55863 | 56005 |  | 5
888239051 | 55863 | 56013 |  | 6
888713800 | 55862 | 56027 |  | 1
888713800 | 55862 | 53457 |  | 2
888713800 | 55862 | 56014 |  | 3
888713800 | 55862 | 3686 |  | 4
888713800 | 55862 | 56003 |  | 5
888713800 | 55862 | 56009 |  | 6
888828134 | 55863 | 56027 |  | 1
888828134 | 55863 | 53457 |  | 2
888828134 | 55863 | 56014 |  | 3
888828134 | 55863 | 3686 |  | 4
888828134 | 55863 | 56005 |  | 5
888828134 | 55863 | 56013 |  | 6
888920892 | 55863 | 56027 |  | 1
888920892 | 55863 | 53457 |  | 2
888920892 | 55863 | 56014 |  | 3
888920892 | 55863 | 3686 |  | 4
888920892 | 55863 | 56005 |  | 5
888920892 | 55863 | 56013 |  | 6
889432900 | 55863 | 56027 |  | 1
889432900 | 55863 | 53457 |  | 2
889432900 | 55863 | 56014 |  | 3
889432900 | 55863 | 3686 |  | 4
889432900 | 55863 | 56005 |  | 5
889432900 | 55863 | 56013 |  | 6
889436076 | 55861 | 56027 |  | 1
889436076 | 55861 | 53457 |  | 2
889436076 | 55861 | 56014 |  | 3
889436076 | 55861 | 3686 |  | 4
889436076 | 55861 |  |  | 5
889436076 | 55861 |  |  | 6
 |  |  |  | 1
 |  |  |  | 2
Spreadsheet: 76248d1276785527-percentage-in-a-pivot-table-book2
Sheet: Sheet1

Sum of Total
PAC | Caseload SOS | Total
11000 | DAF | 1
 | [NAME] | 1
 | SSBF | 1
 | SVC | 1
 | VNI | 1
11000 Total |  | 1
11005 | SVC | 5.644144144144144
 | VNI | 0.004016064257028112
11005 Total |  | 2.087427144046628
11006 | SSBF | 5.34319526627219
 | VNI | 0.004016064257028112
11006 Total |  | 0.7527060782681099
11007 | SVC | 0.04054054054054054
 | VNI | 0.6626506024096386
11007 Total |  | 0.1523730224812656
11008 | DAF | 0.005882352941176471
 | SVC | 0.002252252252252252
 | VNI | 12.37751004016064
11008 Total |  | 2.567860116569525
11009 | [NAME] | 0.8165680473372781
 | SVC | 0.002252252252252252
11009 Total |  | 0.115736885928393
11011 | DAF | 0.03529411764705882
 | [NAME] | 0.03550295857988166
 | SSBF | 0.03550295857988166
 | SVC | 0.01351351351351351
 | VNI | 0.02409638554216868
11011 Total |  | 0.02497918401332223
11012 | DAF | 1.582352941176471
11012 Total |  | 0.2239800166527894
11100 | SVC | 0.1126126126126126
11100 Total |  | 0.04163197335553705
11500 | SVC | 0.1509009009009009
11500 Total |  | 0.05578684429641965
13300 | DAF | 0.2705882352941176
 | [NAME] | 0.272189349112426
 | SSBF | 0.2899408284023668
 | SVC | 0.1238738738738739
 | VNI | 0.2369477911646586
13300 Total |  | 0.212323064113239
14000 | DAF | 0.08235294117647059
 | [NAME] | 0.05325443786982249
 | SSBF | 0.7692307692307693
 | SVC | 0.08108108108108109
 | VNI | 0.04417670682730924
14000 Total |  | 0.1665278934221482
15000 | VNI | 0.008032128514056224
15000 Total |  | 0.001665278934221482
19000 | SSBF | 0.4378698224852071
19000 Total |  | 0.06161532056619484
25000 | SSBF | 1.662721893491124
25000 Total |  | 0.2339716902581182
80000 | SVC | 0.002252252252252252
80000 Total |  | 0.0008326394671107411
81300 | DAF | 0.005882352941176471
 | [NAME] | 0.005917159763313609
 | SSBF | 0.005917159763313609
 | SVC | 0.002252252252252252
 | VNI | 0.004016064257028112
81300 Total |  | 0.004163197335553705
87071 | SSBF | 0.02366863905325444
87071 Total |  | 0.003330557868442964
87072 | VNI | 0.02008032128514056
87072 Total |  | 0.004163197335553705
87074 | SVC | 0.02477477477477477
87074 Total |  | 0.009159034138218152
87075 | SSBF | 0.005917159763313609
87075 Total |  | 0.0008326394671107411
87076 | SVC | 0.02252252252252252
87076 Total |  | 0.00832639467110741
87077 | DAF | 0.01176470588235294
 | [NAME] | 0.01183431952662722
 | SSBF | 0.02366863905325444
 | SVC | 0.004504504504504504
 | VNI | 0.008032128514056224
87077 Total |  | 0.009991673605328892
Grand Total
Spreadsheet: 76436d1276962386-stats-analysis-example-5003-
Sheet: Sheet1

Family ID (From CC Database) | Forename | Surname | DOB | Family Role | ADDRESS | Post Code | LLSOA | No of Referral | Received From | File Location | File Status OPEN/ CLOSED | Practitioner (Open Only) | Date Closed | Family File Created | One Off Contact | 2 Year Old Funding Record | Young Parents Referal | Next Referal review due
CC04-03-10-9189 | [NAME] |  | 1975-08-21 00:00:00 | Mother |  | NE40 4PS | E01008198 | 0
CC04-03-10-9189 | [NAME] |  | 1975-09-13 00:00:00 | Father |  | NE40 4PS | E01008198 | 2 |  |  |  |  | 2010-06-24 00:00:00
CC04-03-10-9189 | [NAME] |  | 2006-03-17 00:00:00 | Child |  | NE40 4PS | E01008198 | 2 |  |  |  |  | 2010-06-25 00:00:00
CC04-03-10-9189 | [NAME] |  | 2001-08-18 00:00:00 | Child |  | NE40 4PS | E01008198 | 7 |  |  |  |  | 2010-06-26 00:00:00
CC04-03-10-9189 | [NAME] |  | 2009-09-15 00:00:00 | Child |  | NE40 4PS | E01008198 | 2 | HV | BWCC | CLOSED |  | 2010-06-27 00:00:00 |  | Y
CC04-11-07-4411 | Doreen |  | 2005-01-29 00:00:00 | Child |  | NE21 5BD | E01008178 | 1 | Newcastle Womens Aid | BWCC | CLOSED |  | 2007-11-26 00:00:00 | Y
CC04-11-07-4411 | Cathy |  | 1990-01-21 00:00:00 | Mother |  | NE21 5BD | E01008178 | 0
CC04-11-07-4411 | Jospehine |  | 2000-08-12 00:00:00 | Child |  | NE21 5BD | E01008178 | 0
CC04-11-07-4411 | Viv |  | 1999-09-02 00:00:00 | Child |  | NE21 5BD | E01008178 | 0
CC04-11-07-4411 | Mark |  | 1997-07-08 00:00:00 | Child |  | NE21 5BD | E01008178 | 0
CC04-01-10-7892 | [NAME] |  | 2010-01-01 00:00:00 | Child |  | NE21 5EZ | E01008280 | 1 | HV | BWCC | CLOSED |  | 2010-06-24 00:00:00 | Y
CC04-01-10-7892 | Mandy |  | 1976-08-21 00:00:00 | Mother |  | NE21 5EZ | E01008280 | 0
Spreadsheet: 768382d1644943250-help-with-this-test-buy-random_test_v3
Sheet: Some

A# | A.Name | Location | Stock
567 | Adios |  | 3
234 | Bye | wer | 4
6423234 | Cinco | pafyup23hyu | 23567
12498570 | Cuatro | 0987dvsaih | 341245
678 | Day | xcvvx | 43
890 | [NAME] | dfdzs34 | 0
654 | Dos | ndsvjknahr2h | 423342
987 | Eight | 2354halsfhlh3124 | 0
5678 | Five | 564lflzfn | 32
4567 | Four | 42pjhlfahslh | 6
345 | Goodbye | ert | 0
123 | Hi | qwe | 2
456 | Hola | asd | 32
210 | Lluvia | u4uwsafb | 124455
654 | Luna | oinasdf32 | 12345
876 | [NAME] | 098jsa | 543
321 | Nieve | vnxcnvlsd | 123123
789 | Night | 34fsed | 222
98 | Noche | sad4 | 123
1234 | One | 2[4jhpqsfhal | 1
432 | Rain | adbnln1 | 0
1235566234 | Seis | 09ugdwsoihpoi23h4r | 123
7890 | Seven | 054jlslshlt23 | 56234
6789 | Six | 69usdflsh | 231
543 | Snow | jbndlsn | 435
765 | Sol | 32fsdfv | 0
987 | Sun | cvcgh | 42
3456 | Three | 5wefzxclnkl23 | 5
418798471 | Tres | [NAME] | 1235678
2345 | Two | 143pjhashif1 | 3
986554 | Uno | 08isdjr | 123
Spreadsheet: 125194d1318931064-get-autoshape-name-from-cell-shapes4
Sheet: Shapes

 |  |  |  |  |  |  |  |  |  |  |  | Shape | Number
 |  |  |  |  |  |  |  |  |  |  | 5 | Circle | 1
 |  |  |  |  |  |  |  |  |  |  | 6 | Triangle | 2
 |  |  |  |  |  |  |  |  |  |  | 7 | Square | 3
 | Circle1 |  | Triangle1 |  |  | Square1
 | Circle2 |  | Triangle2 |  |  | Square2
 |  |  |  |  |  |  |  |  |  |  |  | So if [NAME] is changed on M7 to Star
 |  |  |  |  |  |  |  |  |  |  |  | Square2 will change name to Start2 in NAME BOX (not in shape text)
 |  |  |  |  |  | Star2
Spreadsheet: 134382d1325261829-excel-2007-graph-with-scroll-and-checkboxes-pnl_qty
Sheet: data

 | date | total pnl | total qty
 | 2011-01-03 00:00:00
 | 2011-01-04 00:00:00
 | 2011-01-05 00:00:00
 | 2011-01-06 00:00:00
 | 2011-01-07 00:00:00
 | 2011-01-10 00:00:00
 | 2011-01-11 00:00:00
 | 2011-01-12 00:00:00
 | 2011-01-13 00:00:00
 | 2011-01-14 00:00:00
 | 2011-01-17 00:00:00
 | 2011-01-18 00:00:00
 | 2011-01-19 00:00:00
 | 2011-01-20 00:00:00
 | 2011-01-21 00:00:00
 | 2011-01-24 00:00:00
 | 2011-01-25 00:00:00
 | 2011-01-26 00:00:00
 | 2011-01-27 00:00:00
 | 2011-01-28 00:00:00
 | 2011-01-31 00:00:00
 | 2011-02-01 00:00:00
 | 2011-02-02 00:00:00
 | 2011-02-03 00:00:00
 | 2011-02-04 00:00:00
 | 2011-02-07 00:00:00
 | 2011-02-08 00:00:00
 | 2011-02-09 00:00:00
 | 2011-02-10 00:00:00
 | 2011-02-11 00:00:00
 | 2011-02-14 00:00:00
 | 2011-02-15 00:00:00
 | 2011-02-16 00:00:00
 | 2011-02-17 00:00:00
 | 2011-02-18 00:00:00
 | 2011-02-21 00:00:00
 | 2011-02-22 00:00:00
 | 2011-02-23 00:00:00
 | 2011-02-24 00:00:00
 | 2011-02-25 00:00:00
 | 2011-02-28 00:00:00
 | 2011-03-01 00:00:00
 | 2011-03-02 00:00:00
 | 2011-03-03 00:00:00
 | 2011-03-04 00:00:00
 | 2011-03-07 00:00:00
 | 2011-03-08 00:00:00
 | 2011-03-09 00:00:00
 | 2011-03-10 00:00:00
 | 2011-03-11 00:00:00
 | 2011-03-14 00:00:00
 | 2011-03-15 00:00:00
 | 2011-03-16 00:00:00
 | 2011-03-17 00:00:00
 | 2011-03-18 00:00:00
 | 2011-03-21 00:00:00
 | 2011-03-22 00:00:00
 | 2011-03-23 00:00:00
 | 2011-03-24 00:00:00
 | 2011-03-25 00:00:00
 | 2011-03-28 00:00:00
 | 2011-03-29 00:00:00
 | 2011-03-30 00:00:00
 | 2011-03-31 00:00:00
Spreadsheet: 887756d1738078324-add-tax-automatically-for-certain-entries-automate-tax-on-certain-companies
Sheet: Sheet1

 | Date | Bank description | Debit | HST portion | Entity Name
 | 11/20/2024 | [NAME] FEE | 1.5 |  | DDD machines
 | 11/19/2024 |  | 53.05 |  | ACME widgets
 | 11/19/2024 |  | 140 |  | 123 Company
 | 11/19/2024 | [NAME] FEE | 1.5 |  | AAA Widgets
 | 11/18/2024 | [NAME] | 1500 |  | MMM Company
 | 11/15/2024 | EMPTX 4939342    BUS | 61.12 |  | ACME widgets
 | 11/14/2024 | [NAME] ***wyU | 825 |  | ABC widgets
 | 11/14/2024 | [NAME] FEE | 1.5 |  | XYZ widgets
Spreadsheet: 211451d1359748884-excel-2010-unhides-columns-automatically-when-entering-formula-copy-of-kona_fdata_model2
Sheet: Upside

0 |  |  |  | 2013-02-01 00:00:00
 | 8.45
 | 8.562500000000009
 | 72.35312500000006
 | 4
 | 76.35312500000006
 | 11.3
 | 6.756913716814164 | x
 | 11.31200000000001 | 0.3675048355899412
 | 11.77920000000001 | 0.04130127298444112
 | 13.21 | 0.1214683509915774
 | 7.5 | x
 | -8.309000000000001
 | 8.92757063376476
 | 12.02835624664401
 | 0
 | 12.02835624664401
 | 0.423474112028877
 | -0.2899408284023668
 | 0.1930943433060426
 | 1.46055357005878 | : 1