tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 783262d1654695081-combining-multiple-records-with-unique-value-into-one-row-sample
Sheet: Conditions

SI = Studlent ID
'[NAME] = _MailingAddress Contact Type
'SA = ShippingAddress Contact Type
'COA = COA Contact Type
For each Student ID Matching Group
'First Case: MA, SA, & COA Exist
'IF _MailingAddress and COA are all listed as a Contact Type THEN
'Copy the Contact Address columns where the Contact Type = _MailingAddress to the [NAME] columns and add "COA Pending" to Mailing2 column
'Copy the Contact Address columns where the Contact Type = ShippingAddress to the [NAME] columns and add "COA Pending" to Shipping2 column
'Second Case: MA & SA Exist, COA Does Not
'IF _MailingAddress and ShippingSAddress ARE listed as a Contact Type but COA is NOT listed as a Contact Type THEN
'Copy the Contact Address columns where the Contact Type = _MailingAddress to the [NAME] columns
'Copy the Contact Address columns where the Contact Type = ShippingAddress to the [NAME] columns
'Third Case: MA & COA, but not SA
'If the _MailingAddress and the COA ARE listed as a Contsact Type but SA is NOT listed as a Contact Type THEN
'Copy the Contact Address columns where the Contact Type = _MailingAddress to the [NAME] columns and add "COA Pending" to Mailing2 column
'Copy the Contact Address columns where the Contact Type = COA to the [NAME] columns
'Fourth Case: SA & COA, but not [NAME]
'If ShippingSAddress and COA ARE listed as a Contact Type but [NAME] is NOT listed as a Contact Type THEN
'Copy the Contact Address columns where the Contact Type = COA to the [NAME] columns
'Copy the Contact Address columns where the Contact Type = ShippingAddress to the [NAME] columns
'Fifth Case: COA, but not [NAME] or SA
'If COA IS listed as a Contact Type but [NAME] and SA ARE NOT listed as a Contact Type THEN
'Copy the Contact Address columns where the Contact Type = COA to the [NAME] columns
'Copy the Contact Address columns where the Contact Type = COA to the [NAME] columns
'Sixth Case: No MA, SA or COA
'If the _MailingAddress, ShippingAddress and COA is NOT listed as a Contact Type THEN
'Copy the Regular Address columns to the [NAME] columns
'Copy the Regular Address columns to the [NAME] columns
Spreadsheet: 76700d1277215951-solved-with-sumif-do-i-use-hlookup-and-vlookup-2examplefile
Sheet: Month 3

date | category | description | cost
2010-02-01 00:00:00 | winkin | not | 10
2010-02-02 00:00:00 | blinkin | not | 15
2010-02-22 00:00:00 | nod | not | 20
2010-02-01 00:00:00 | winkin | not | 5
2010-02-02 00:00:00 | blinkin | not | 15
2010-02-22 00:00:00 | nod | not | 20
Spreadsheet: 810059d1671521379-finding-product-prices-with-criteria-task3-ans
Sheet: Tabels 1,2

 |  | Segment | Sprzedaż w sztukach | Sprzedaż w euro
 |  | Eye Shadow
 |  | Lip Care
 |  | [NAME]
 |  | Lipstick
 |  | Mascara
 |  | Nail Treatments/Strengthener
 |  | Other Eye Make Up
 |  | Tabela 1
 |  |  | Product name | mark | Product price in euros
 |  | Product from the Lipstick segment with the lowest price in the segment
 |  | Product from the Lipstick segment with the highest price in the segment
 |  | Tabela 2
Spreadsheet: 790671d1659944533-index-match-but-excluding-the-first-result-2022-08-08-oelderer-nn-indexexcluding1stresult-2-
Sheet: Tabelle1

 | ID | Latitude | Longitude |  | Latitude | Longitude |  | 1st result | 2nd result |  | Longitude
 | 72528704724 | 43.10833 | -78.93806 |  | 43.098535 | -77.441969
 | 72528899999 | 43.27 | -79.07 |  | Table 2 |  |  |  | 72529014768
 | 72529014768 | 43.1167 | -77.6767
 | 72529599999 | 43.25 | -77.6
 | 72530094846 | 41.96019 | -87.93162
 | 72530599999 | 41.908 | -88.249
 | 72530799999 | 42.067 | -87.683
 | Table 1
Spreadsheet: 876231d1722913425-adding-grand-total-at-end-and-doing-sum-of-each-column-hstack-with-grand-total1
Sheet: RequiredOutput

Doing Sum of each column excluding 1 st column-Correct Result |  |  |  |  |  | Doing Sum of each column excluding 1st 3 column i.e sum of cols of J & K
 | Head 4 | Head 5 | Head 6 | Head 8 |  |  | Head 4 | Head 5 | Head 6 | Head 8
X | 725 | 188 | 583307.07 | 117 |  | X | 725 | 188 | 583307.07 | 117
Y | 817165.55 | 294052 | 19538.3 | 484886.79 |  | Y | 817165.55 | 294052 | 19538.3 | 484886.79
Grand Total | 817890.55 | 294240 | 602845.37 | 485003.79 |  | Grand Total | 602845.37 | 73497.18 | 485003.79 | #N/A | < Incorrect Result
 |  |  |  |  |  |  |  |  |  |  | <required this answer
 |  |  |  |  |  |  | Total not | Total not | This col.J Total | This col.K Total
 |  |  |  |  |  |  | required | required | is required | is required
Spreadsheet: 883893d1732642326-duplicate-yes-no-in-a-table-bom-sample-for-help-2
Sheet: Sheet1

rev | rev active | duplicated  yes/no
1020C TWR BKB SP | 1020C TWR BKB SP
1020C TWR TPB SP | 1020C TWR TPB SP
1020X KV BKB | 1020X KV BKB
1020X KV BUB | 1020X KV BUB
1020X KV TAB | 1020X KV TAB
1020XC A5 ALB SP | 1020XC A5 ALB SP
1020XC A5 BKB SP | 1020XC A5 BEB SP
1020XC A5 CRB SP | 1020XC A5 BKB SP
1020XC A5 MGB SP | 1020XC A5 CRB SP
1020XC A5 OGB SP | 1020XC A5 MGB SP
1020XC A5 TGB SP | 1020XC A5 OGB SP
1020XC GR BKB SP | 1020XC A5 TGB SP
1020XC GR BLB SP | 1020XC GR BKB SP
1020XC GR BRB SP | 1020XC GR BLB SP
1020XC GR TAB SP | 1020XC GR BRB SP
Spreadsheet: 710889d1609298674-club-lottery-excel-checker-raharney-lotto
Sheet: Draw

 | Numbers Drawn (1-30)
 | 1 | 14 | 17 | 30
Name | Number 1 | Number 2 | Number 3 | Number 4 | Matched Numbers
Player 1 | 1 | 2 | 3 | 4
Player 2 | 5 | 6 | 7 | 8
Player 3 | 9 | 10 | 11 | 12
Player 4 | 13 | 14 | 15 | 16
Player 5 | 17 | 18 | 19 | 20
Player 6 | 21 | 22 | 23 | 24 |  | I came here to look for help on creating a simple club lottery number checker.
Player 7 | 25 | 26 | 27 | 28 |  | I have started with some conditional formatting to highlight matched numbers. Which i think works very well.
Player 8 | 1 | 2 | 17 | 30
Player 9 | 5 | 6 | 7 | 8 |  | I'm looking for help with more conditional formatting where number of matched numbers is highlighted. Also if someone matches 4 numbers then the persons name is highlighted etc.
Player 10 | 9 | 10 | 11 | 12 |  | If anyone has any good ideas for this then that would be brilliant.
Player 11 | 13 | 14 | 15 | 16
Player 12 | 17 | 18 | 19 | 20
Player 13 | 21 | 22 | 23 | 24
Player 14 | 25 | 26 | 27 | 28
Player 15 | 1 | 14 | 17 | 30
Player 16 | 5 | 6 | 7 | 8
Player 17 | 9 | 10 | 11 | 12
Player 18 | 13 | 14 | 15 | 16
Player 19 | 17 | 18 | 19 | 20
Player 20 | 21 | 22 | 23 | 24
Spreadsheet: 778438d1651066906-how-to-get-the-corresponding-column-header-from-a-time-table-expected-result
Sheet: Sheet1

Name | First Aid Y/N | Friday |  | Saturday |  | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  |  | Name | First Aid Y/N | Friday |  | Saturday |  | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday
Dates and Names are dynamic |  | 2022-04-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dates and Names are dynamic |  | 2022-04-22 00:00:00
 |  | Start Time | End Time | Start Time | End Time | Start Time | End Time | Start Time | End Time | Start Time | End Time | Start Time | End Time | Start Time | End Time |  |  |  | Start Time | End Time | Start Time | End Time | Start Time | End Time | Start Time | End Time | Start Time | End Time | Start Time | End Time | Start Time | End Time
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | 08:00:00 | 15:00:00
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  | 09:00:00 | 18:00:00
Spreadsheet: 437992d1451663499-create-list-from-table-copy-of-data
Sheet: Input

 | CATEGORY |  | Type |  |  |  | Type 2 |  |  |  |  |  |  | Type 2
Name | Articlenr | Brand | Option 1 | Option 2 | Option 3 | Option 4 | Option 5 | Option 6 | Option 7 | Option 8 | Option 9 | Option 10 | Option 11 | 1 | 2 | 3 | 4 | 5 | 6 | 7
Name 1 | 123 | Brand 1 | x |  |  |  |  |  | x |  |  |  |  | x | x | x
Name 2 | 345 | Brand 1 |  | x |  |  | x |  |  |  |  |  |  |  | x | x | x
Name 3 | 678 | Brand 2 | x |  |  |  |  | x |  |  |  |  |  |  |  | x | x | x | x | x
Spreadsheet: 848162d1698934928-how-to-create-multiple-similar-looking-pie-charts-for-variety-of-data-2019-pie-charts-for-kpi-values
Sheet: Sheet1

 | KPI 1 | KPI 2 | KPI 3 | [NAME] | KPI 5 | KPI 52 | KPI 6 | KPI 7 |  | KPI Value | Typical KPI | All KPI's
 | 7 | 5 | 6 | 5 | 6 | 6 | 4 | 6 |  | 1
 | 6 | 6 | 5 | 5
 | 6 | 6 | 6 | 6 | 6 |  | 6 | 6
 | 2 | 5 | 5 | 4 | 6 | 6 | 4 | 6
 | 6 | 5 | 6 | 6 | 6 | 6 | 6 | 6
 | 7 | 6 | 6 | 6 | 7 | 7 | 4 | 6
 | 6 | 5 | 6 | 5 | 5 | 4 | 5 | 6
 | 7 | 5 | 6 | 7 | 4 |  |  | 6
 | 4 | 6 | 6 | 6 | 6 |  | 3 | 6
 | 7 | 6 | 6 | 6 | 6 | 6 | 6 | 6
 | 7 | 7 | 6 | 7 | 7 | 6 | 6 | 6
 | 7 | 4 | 4 | 4 | 4 | 4 | 4 | 4
 | 7 | 7 | 7 | 7 | 6 | 6 | 7
 | 7 | 5 | 4 | 4 | 5 | 5 | 5 | 5
 | Select KPI Name |  | KPI 1
Spreadsheet: 218618d1362510470-grouping-data-over-many-days-into-months-extract-month-from-list-and-sum
Sheet: Sheet1

2013-02-02 00:00:00 | 6
2013-02-03 00:00:00 | 8
2013-02-04 00:00:00 | 10
2013-02-05 00:00:00 | 12
2013-02-06 00:00:00 | 14
2013-03-01 00:00:00 | 16
2013-03-02 00:00:00 | 18
2013-03-03 00:00:00 | 20
2013-03-04 00:00:00 | 22
Spreadsheet: 876869d1723583046-need-if-formula-with-a-max-value-mangofresh-tech-commission-sample
Sheet: Sheet1

Order Number | Costed Date | Total Parts | Total Labor | Total Other | Final Component Code | Parts 2nd | Labor 2nd | Parts Avoid | Labor Avoid | Parts Tires | Labor Tires
SWO000007 | 2024-07-16 00:00:00 | 265.35 | 1683 | 10.75 | 11
Spreadsheet: 122166d1316636330-if-then-function-with-drop-down-lists-interactive-proposal-tool
Sheet: Proposal Tool

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Door Contact | Window Contact | Motion Detector | Glass Break Detector | Smoke Detector | Heat Detector | [NAME] | Keypad | Control Panel | [NAME] | Panic Button | Cellular Backup | Indoor Camera | Outdoor Camera | Digital Video Recorder | Location
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | curtain |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Breakfast Room
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | overhead |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Den
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | recessed brown |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dining Room
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | recessed white |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Family Room
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Foyer
 |  |  |  | Name: |  |  |  |  |  |  |  |  |  |  |  |  |  | standard white |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Guest Bathroom
 |  |  |  | Address: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | City: |  |  |  | Zip: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hall
 |  |  |  | Home: |  |  |  | Cell: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Kitchen
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Laundry Room
Qty | Category | Equipment |  | Location |  |  |  |  |  | Price |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Master [NAME]
5 | Door Contact | curtain |  |  |  |  |  |  |  |  |  | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Master [NAME]
 | Window Contact |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Office
 | Motion Detector |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Outside
 | [NAME].
 | Smoke Detector
 | Heat Detector
 | [NAME]
 | Keypad
 | Control Panel
 | [NAME]
 | Panic Button
 | Cellular Backup
 | Indoor Camera
 | Outdoor Camera
 | DVR
Spreadsheet: eric_saibi__9859__101101R
Sheet: Riverbend 01

Owner Name |  | Entergy Gulf States Inc.
Station Name |  | Riverbend Nuclear Power Station
Unit Name |  | River Bend 01
NERC Region |  | SERC
State |  | LA
Fuel Type |  | Nuclear
Capacity |  | 1,036 MW
Start Date |  | 2001-09-23 00:00:00
End Date |  | 2001-10-10 00:00:00
Prv. Start Date |  | 2001-09-23 00:00:00
Prv. End Date |  | 2001-11-04 00:00:00
Comments |  | Refueling.  Unit connected to the grid last night, is currently at 20% power, still doing turbine testing.  Hoping to be at full power by Sunday.
SIC |  | 4911
Plant ID |  | 1004408
Unit ID |  | 1004548
Outage ID |  | 7495
Spreadsheet: 2128d001-83e4-4dcb-88d0-1a337a0ecf0c
Sheet: Stormwater

NON-POTABLE WATER CALCULATOR |  |  |  | NON-POTABLE WATER CALCULATOR
Climate Data for San Francisco |  |  |  | Stormwater Cistern Capture Calculation
 | SF Downtown Gauge |  |  |  | Total At or Below Grade Area Draining to Cistern (ft2)
 | 24 hour curves |  | C=1
 | Unit Storage | Percent | Percent |  | Rainfall Capture Factor
 | (inches) | Capture | Capture |  | Cistern Size (gallons)
 | 0 | 0 | 0 |  | Rain Event Captured (in)
 | 0.03 | 0.06 | 6 |  | Storm Percentile
 | 0.06 | 0.13 | 13 |  | Annual Runoff Captured
 | 0.12 | 0.2823 | 28.23
 | 0.24 | 0.4922 | 49.22
 | 0.36 | 0.6457999999999999 | 64.58 |  | Assumes cistern is empty at the beginning of September
 | 0.48 | 0.7570999999999999 | 75.71 |  | Month | Ave. Rainfall | Runoff to Cistern | Non-Potable Demand (gal/mth) |  |  | Ending Cistern | Water Captured | Water Reused | Overflow | Net Available Volume
 | 0.6000000000000001 | 0.8345 | 83.45 |  |  | ft3/mth | gal/mth | Irrigation | Indoor | Total | Volume (gal) | (gal/mth) | (gal/mth) | (gal/mth) | (gal/mth)
 | 0.72 | 0.8878 | 88.78 |  | September
 | 0.8400000000000001 | 0.9251 | 92.51 |  | October
 | 0.96 | 0.9501999999999999 | 95.02 |  | November
 | 1.08 | 0.9662999999999999 | 96.63 |  | December
 | 1.2 | 0.9773999999999999 | 97.74 |  | January
 | 1.32 | 0.9845999999999999 | 98.46 |  | February
 | 1.44 | 0.9892 | 98.92 |  | March
 | 1.56 | 0.9923000000000001 | 99.23 |  | April
 | 1.68 | 0.9948 | 99.48 |  | May
 | 1.8 | 0.9963 | 99.63 |  | June
 | 1.92 | 0.9972 | 99.72 |  | July
 | 2.04 | 0.9976999999999999 | 99.77 |  | August
 | 2.16 | 0.998 | 99.8 |  | Totals
 | 2.28 | 0.9982 | 99.82
 | 2.4 | 0.9984999999999999 | 99.85
 | 2.52 | 0.9987 | 99.87
 | 2.64 | 0.9989 | 99.89
 | 2.76 | 0.9992 | 99.92
 | 2.88 | 0.9994 | 99.94
 | 3 | 0.9995999999999999 | 99.96
 | 3.12 | 0.9998 | 99.98
 | 3.24 | 0.9998999999999999 | 99.99
 | 3.36 | 1 | 100
 | 3.48 | 1 | 100
Spreadsheet: chris_germany__2033__AppalPay200202
Sheet: CNRVol

802041 | 00003 | BADGER OIL AND GAS CO INC |  | 1667 | 1951 | 25
821780 | 00058 | [NAME] INC. |  | 1989 | 2238 | 25
805080 | 00081 | HARRIS | J E | 749 | 802 | 25
804452 | 00083 | PAYNE GAS COMPANY |  | 118 | 136 | 25
801852 | 00089 | LITTLETON, EXECUTRIX | [NAME] | 571 | 701 | 25
800785 | 00115 | PUTNAM NATURAL GAS CO.  INC. |  | 96 | 109 | 25
801153 | 00130 | THOMPSON | [NAME] | 6 | 7 | 25
804513 | 00164 | PINE MOUNTAIN OIL AND GAS INC |  | 2510 | 3021 | 25
827984 | 00506 | ARIES PETROLEUM CORPORATION |  | 0 | 0 | 25
826176 | 00523 | PINE MOUNTAIN OIL AND GAS INC |  | 40 | 43 | 25
833349 | 00523 | PINE MOUNTAIN OIL AND GAS INC |  | 0 | 0 | 0
800289 | 00552 | JCR PETROLEUM INC. |  | 34 | 48 | 25
833596 | 00552 | JCR PETROLEUM INC. |  | 222 | 269 | 25
833848 | 00552 | JCR PETROLEUM INC. |  | 309 | 501 | 25
800134 | 00612 | [NAME] | WILLIAM T | 26 | 40 | 12.5
800176 | 00612 | [NAME] | WILLIAM T | 291 | 432 | 12.5
834862 | 00618 | STATUS OIL WELLS |  | 55 | 69 | 25
635377 | 00621 | ELTON ENERGY |  | 251 | 274 | 25 | EES
Spreadsheet: 471047d1468851402-creating-pivottable-from-summarised-data-indirect-example
Sheet: Summary

[NAME]
AB
Month | Sales | Gross | Profit
Jan
Feb
Mar
Apr
May
Jun
Spreadsheet: d0731135-e669-4f70-a042-d224462c859e
Sheet: Sheet1

OLMSTED "PRIDE" | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | TrailsHead | Unnamed: 5 | Unnamed: 6 | 2009
* Scouts will begin each day after swimming electing a new patorl leader, having a flag ceremony, and giving their patrol cheer
Time | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
5:30-7:30am |  |  |  | Return from |  |  | Wake-Up
 |  |  |  | [NAME]
7:30-8:15am |  |  |  | Meal
B-Fast A
8:15-9:00am
B-Fast B
9:00-10:00am^ |  | Swimming | Swimming | Swimming | Swimming | Swimming
10:00-11:00am |  | *Patrol Method | *Knot | *Mammal Study | *Handicraft | *Ecology
 |  | Ax yard | Round Robins | Merit Badge
11:00-12:00pm |  | Totin'Chip |  | [NAME] and Compus |  | Patrol
 |  |  |  | Round Robin | Hike Prep | Games
12:30-1:15pm^^ | Scouts/Leaders |  |  | Meal
Lunch A | Begin to
1:15-1:50pm^^ | Arrive
[NAME]
2:00-3:05pm | Medical Checks | Public Speaking | Pioneering Proj. | Orienteering |  | OLMSTED
 | Swim Checks | Merit Badge | First Aid | Course | 5
3:15-4:20pm | Camp Tour | Mammal Study | Round Robins |  | Mile | OLYMPICS!!!!
 | Immediatley | Merit Badge | Handicraft | [NAME] | Hike
4:30-5:35pm | Upon | Archery/Rifle |  | Archery/Rifle
 | [NAME] |  | [NAME] prep
5:45-6:30pm |  |  |  | Meal
Dinner A
6:30-7:10pm
Dinner B
7:15-8:30pm | Campsite | First Aid | [NAME] | Clothes | CPR | Packing Time
 | Time | Round Robins | Cooking^ | Floation
8:45-9:30pm | Campfire |  | Public Speaking |  |  | Campfire
 |  |  | Firem'n Chit
Yellow = Camp Events |  | Red = Meal Times in Dinning Hall |  | Green = Overnighter
^This is not cooking a meal - troops can complete some of those requirements in their site Tuesday with foil dinner
Merit Badges Potentially Earned:
Swimming |  |  | First Aid Req. | Eco Req. | Map & Compus Req. | Knot Req. | Other Req.
Public Speaking |  | Scout |  |  |  | 6 | 4; 5
Mammal Study
Basketry |  | Tenderfoot | 12a,b | 11 |  | 4a,b; | 5; 6; 9
Leatherwork
 |  | Second Class | 6a,b, c | 5 | 1a,b; |  | 2c,d,e,f; 3; 7a,b,c;
Other Awards: |  |  |  |  |  |  | 8a,b
Firem'n Chit |  | First Class | 8a,b,c,d | 6 | 1, 2 | 7a,b,c; | 4a,b,c,d;
Totin'Chip |  |  |  |  |  |  | 9a,b,c; 12
 | *Please remember these are requirements we will try to earn - when working with First Year Scouts it is important to be flexible
Spreadsheet: 219710d1362897195-copy-data-from-1-sheet-to-another-book1
Sheet: Result

Slide1 | User's Answer | Like to have data from Q&A column B here | Like to have data from Q&A column C here
Slide2 | User's Answer | Like to have data from Q&A column B here | Like to have data from Q&A column C here
Slide3 | User's Answer | Like to have data from Q&A column B here | Like to have data from Q&A column C here
Slide4 | User's Answer | Like to have data from Q&A column B here | Like to have data from Q&A column C here
Slide5 | User's Answer | Like to have data from Q&A column B here | Like to have data from Q&A column C here
Slide6 | User's Answer | Like to have data from Q&A column B here | Like to have data from Q&A column C here
Slide7 | User's Answer | Like to have data from Q&A column B here | Like to have data from Q&A column C here
Slide8 | User's Answer | Like to have data from Q&A column B here | Like to have data from Q&A column C here
Slide9 | User's Answer | Like to have data from Q&A column B here | Like to have data from Q&A column C here
Slide10 | User's Answer | Like to have data from Q&A column B here | Like to have data from Q&A column C here
Slide11 | User's Answer | Like to have data from Q&A column B here | Like to have data from Q&A column C here
Slide12 | User's Answer | Like to have data from Q&A column B here | Like to have data from Q&A column C here
Slide13 | User's Answer | Like to have data from Q&A column B here | Like to have data from Q&A column C here
Slide14 | User's Answer | Like to have data from Q&A column B here | Like to have data from Q&A column C here
Slide15 | User's Answer | Like to have data from Q&A column B here | Like to have data from Q&A column C here
Slide16 | User's Answer | Like to have data from Q&A column B here | Like to have data from Q&A column C here
Slide17 | User's Answer | Like to have data from Q&A column B here | Like to have data from Q&A column C here
Slide18 | User's Answer | Like to have data from Q&A column B here | Like to have data from Q&A column C here
Slide19 | User's Answer | Like to have data from Q&A column B here | Like to have data from Q&A column C here
Slide20 | User's Answer | Like to have data from Q&A column B here | Like to have data from Q&A column C here
Spreadsheet: 788444d1658480852-calculating-a-total-referencing-data-in-different-worksheets-cl-geodata-v3-1-
Sheet: Project2Analysis

Full LSOA map area | LSOA Code/Marketing focus map link | LSOA Name | Number of PPTs (FB1) | IMD EST | IMP EMP
LSOA MAP |  | Cherry Garden Primary School area |  | Q4 | Q5 | BITTON & OLDLAND COMMON
LSOA MAP |  | Millers Drive area |  | Q3 | Q5
LSOA MAP |  | North Common area |  | Q2 | Q4
LSOA MAP |  | North Street area |  | Q2 | Q3
LSOA MAP |  | Rural area around Bitton and Upton Cheyney |  | Q3 | Q4
LSOA MAP |  | Warmley CofE Primary and [NAME] area |  | Q1 | Q4
 |  | Westcourt Drive / Court Road area
LSOA Map | E01014918 | Area surrounding Conham Playing Field |  | Q2 | Q4 | HANHAM
LSOA Map | E01014920 | [NAME] / The Meadows area |  | Q3 | Q4
LSOA Map | E01015003 | Footshill Road area |  | Q3 | Q3
LSOA Map | E01014921 | [NAME] Hanham Hall Hospital area |  | Q3 | Q3
LSOA Map | E01014915 | Lower [NAME] area |  | Q2 | Q2
LSOA Map | E01014916 | Martins Road / Ansteys Road area |  | Q2 | Q3
LSOA Map | E01015005 | [NAME] area |  | Q2 | Q3
LSOA Map | E01014917 | [NAME] area |  | Q3 | Q3
LSOA Map | E01014919 | [NAME] area |  | Q2 | Q4
LSOA Map | E01015006 | Claypool Road / Elm road / Kemble Close area |  | Q2 | Q2
Spreadsheet: 772912d1647524259-vlookup-on-data-table-based-on-month-year-to-date-test
Sheet: Budget

CostId | Description | 31/01/2022 | 28/02/2022 | 31/03/2022 | 30/04/2022 | 31/05/2022 | 30/06/2022 | 31/07/2022 | 31/08/2022 | 30/09/2022 | 31/10/2022 | 30/11/2022 | 31/12/2022
OD.R1 | Revenue line 1 | 900000 | 950000 | 1000000 | 1050000 | 1100000 | 1150000 | 1200000 | 1250000 | 1300000 | 1350000 | 1400000 | 1450000
Spreadsheet: 134740d1325607819-calculating-percentage-values-for-positive-and-negative-values-samplecreditcalc
Sheet: Sheet1

NOVEMBER | DECEMBER |  | $ [NAME] | % Difference
-433.9 | 0 |  | 433.9
-150.9 | 0 |  | 150.9
-6428.84 | -3738.8 |  | 2690.04
-349.87 | -349.87 |  | 0
-2323231.51 | -2465333.37 |  | -142101.86
49.87 | -211.16
Spreadsheet: 90768d1290519947-how-to-copy-rows-from-one-worksheet-to-others-ccr-reg_new
Sheet: Master Sheet

Reg_Num | Fed_Tax_ID | Name | CollectionSite | ConsolidationFac | RecyclFac | App_Received | FeeForm_Received | Check_Received | Check_Number | Date_Received | Address | City_Town | State | Zip | County
1 | 12345 | Collection Site 1 | Yes | No | No | Yes | Yes |  |  | 2010-11-10 00:00:00 | Address | Albany | NY | 12202 | 1 - Albany
 | 78910 | Consolidation Facility 1 | No | Yes | No | Yes | Yes
 | 11121 | Recycling Facility 1 | No | No | Yes | Yes | Yes
 | 13141 | Multiple Types | Yes | Yes | Yes | Yes
Spreadsheet: 107008d1304161008-how-to-find-top-25-values-from-more-than-1000-rows-with-their-corresponding-names-excel-test-top-5
Sheet: Sheet2

Rank | Name
1 | a | 983
2 | d
3 | f
4 | g
5 | h
6 | j
7 | k
8 | u
9 | y
4 | r
5 | w
65 | f
68 | t
983 | b
45 | a