tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 593544d1539197872-correct-way-of-linking-data-to-master-workbook-test-sheet
Sheet: Pesto Chicken Spaghetti

Tomatokeftedes and Mizeria
 | Ingredients | QTY | Measurement | Macros calculated from Quantity
 |  |  |  | CAL | P | F | C
 | chicken breast | 4
 | Spaghetti Wholemeal | 1.5
 | courgette | 5 | 100g
 | pine nuts | 0.5
 | pesto | 0.6
 | [NAME] tomato | 12
 |  | 2.4
 |  | 0.8
 |  | 2.5
 |  | 0.2
 |  | 0.05
 | Total - Entire Recipe
 | No. Of Servings | 4 |  | CAL | P | F | C
 | Per Serving
 | Check
 | Rounded
Spreadsheet: 740762d1626551563-move-formula-down-a-row-depending-on-date-possible-example
Sheet: Results cont.

Date | Sump Tank | [NAME] |  |  |  |  | Oil Levels |  |  |  |  | Analyser P5 |  | LG8026
 | Level | Pressure |  |  |  | Pumps On |  |  |  |  |  | Noise/ |  | Approx
 | Flags | M Bar A |  |  | Bar G |  | Topped up Y/N |  |  |  |  | Vibration | Flow | Dip
 | LI 801 | PT 101 | PT 201 | PT 503 | PI 303 | B1/B2 or C1/C2 | B1 I/B | B1 O/B | B2 I/B | B2 O/B | P3 | Y/N | Y/N | Height
2005-09-04 00:00:00 | 45 |  | 13 | 133 | 0 | B2/C2 | 0 | 0 | 0 | 1 | 0 | 0 | 1
2005-09-10 00:00:00 | 40 | 78 |  | 244 | 0 | B1/C1 | 0 | 0 | 0 | 0 | 0 | 0 | 1
2005-09-17 00:00:00 | 35 |  | 32 | 177 | 0 | B1/C1 | 0 | 0 | 0 | 1 | 0 | 0 | 1
2005-09-24 00:00:00 | 32 |  | 14 | 135 | 0 | B1/C1 | 0 | 1 | 0 | 0 | 0 | 0 | 1
Spreadsheet: d6ee1c93-ae89-408d-ab17-386e28149513
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
FBLGG | Test | FBLGG | Beta [NAME] | Beta [NAME] | Enzyme Immunoassay (FEIA) | Plain, Red-Top Tube: Red |  |  |  |  | Draw blood in a plain red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | <2 mcg/mL   The reference range listed on the report is the lower limit of quantitation for the assay. The clinical utility of food-specific IgG tests has not been established. These tests can be used in special clinical situations to select foods for evaluation by diet elimination and challenge in patients who have food-related complaints. It should be recognized that the presence of food-specific IgG alone cannot be taken as evidence of food allergy and only indicates immunologic sensitization by the food allergen in question. This test should only be ordered by physicians who recognize the limitations of the test.   Test Performed by:	Viracor-IBT Laboratories 			1001 NW Technology Dr. 			Lee's Summit, MO 64086 | Monday through Friday | 3 days | 5 - 7 days | 1 | 86001 |  |  |  |  | Viracor-IBT Laboratories
FBLGG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FBLGG | Result | FBLGG | Beta [NAME] | Beta [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 115956d1311410266-selective-columns-handicap-template-midshires
Sheet: master

HOLE
par | S/i | No
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  | 11
 |  | 12
 |  | 13
 |  | 14
 |  | 15
 |  | 16
 |  | 17
 |  | 18
 |  | Total
Playing Handicap
Correct Handicap
Exact Handicap
Par 3
[NAME]
Handicap Alteration
Spreadsheet: 762619d1641664772-filter-formula-based-on-year-ts-and-ps-tanks-schedule-2022
Sheet: Charts

 | Service Status' | Total
 | In-Service
 | In Service – Approved Postponement
 | Out-of-Service For Inspection
 | Out-of-Service - Awaiting Contract
 | L.T.O.O.S
 | Unknown Status
 | Inspection Status' | Total
 | N/A
 | Awaiting Tank Emptying
 | Awaiting Tank Cleaning
 | Awaiting Op's Handover to PM
 | Awaiting [NAME]
 | Awaiting Inspection
 | Inspection Ongoing
 | Inspection Complete - Awaiting Report
 | Report Issued - Awaiting Review & Repair Plan
 | Repair Plan Issued - Awaiting Repairs
 | Repairs Ongoing
 | Repairs Complete - Awaiting Post Repair Inspection
 | Post Repair Inspection Complete - Awaiting Post Repair Report
 | Under Hydro Test
 | Tank Handed Over to Operations
Spreadsheet: 696954d1601049275-lookup-only-non-zero-items-202009_-and-3609
Sheet: Final List

date | shop | item_code | qty | remark
2020-01-09 00:00:00 | 001 | 3021-2 | 2
2020-01-09 00:00:00 | 002 | 3021-2 | 3
2020-01-09 00:00:00 | 001 | 0019-0
2020-01-09 00:00:00 | 003 | 0019-0
2020-01-09 00:00:00 | 008 | 0019-0
2020-01-09 00:00:00 | 002
2020-01-09 00:00:00 | 003
2020-01-09 00:00:00 | 008
2020-01-09 00:00:00 | 006_POPCORN
2020-01-09 00:00:00 | 003
2020-01-09 00:00:00 | 006_POPCORN
2020-01-09 00:00:00 | 003
2020-01-09 00:00:00 | 008
2020-01-09 00:00:00 | 008
2020-01-09 00:00:00 | 006_POPCORN
Spreadsheet: 125145d1318906006-automatically-update-chart-over-column-testing
Sheet: Sheet1

 | 2010-01 | 2010-02 | 2010-03 | 2010-04 | 2010-05 | 2010-06 | 2010-07 | 2010-08 | 2010-09 | 2010-10 | 2010-11 | 2010-12 | 2011-01 | 2011-02 | 2011-03 | 2011-04 | 2011-05 | 2011-06 | 2011-07fcst | 2011-08fcst
Call Centre | 0.1364436034021631 | 0.1252198761021874 | 0.1092341793584988 | 0.08313701969934498 | 0.08815346123526617 | 0.0794244687771032 | 0.0793454089358205 | 0.07852375282437521 | 0.09417899790332844 | 0.08701971268629935 | 0.09088963284488899 | 0.07284263039743305 | 0.08471243061788676 | 0.08000818679677982 | 0.08355464116600266 | 0.07593513971489743 | 0.08138204176929992 | 0.06679535528907643 | 0.05882007073924098 | 0.05251513699714084
Labor | 0.7477519860158002 | 0.7291126851234576 | 0.7059230121878994 | 0.5547318003451335 | 0.5609399401886935 | 0.5650029158716392 | 0.5224482158867332 | 0.5450907369207308 | 0.6282493935876795 | 0.5065251146503673 | 0.5862614975983637 | 0.4953953719013212 | 0.5794443115642839 | 0.5318656092783258 | 0.513468951176409 | 0.4203901936672339 | 0.484878793544416 | 0.4025398379933026 | 0.3656667423482229 | 0.375068250098929
Distribution | 0.8499097788717519 | 0.9196746057282295 | 0.9461447525326518 | 0.78568459070084 | 0.7159293167997197 | 0.7794425131953909 | 0.7040399402908872 | 0.7697540136939404 | 0.9224817464774672 | 0.7690793227434749 | 0.8334288166537809 | 0.6725561388112326 | 0.7513366102394714 | 0.7115392716968061 | 0.7796270365946024 | 0.5879176695884495 | 0.6524472019939064 | 0.5957797595878779 | 0.4909538668909963 | 0.5922542874609749
Parts | 0.8279756205488676 | 0.8685186111495454 | 0.9303983219351019 | 0.7490088750349386 | 0.6254141906704372 | 0.7009262245074961 | 0.5898843222797799 | 0.6495585947527308 | 0.7074946499931356 | 0.6623083694169994 | 0.5766336666199935 | 0.4823995249839866 | 0.5413852419847054 | 0.5544122039607271 | 0.6050493895973549 | 0.5134772868897954 | 0.5168475482424909 | 0.482748319326309 | 0.3933405987990991 | 0.4986399268575465
Cost per MM (rolling) | 2.25733062889929 | 2.298351903410989 | 2.339390410992118 | 2.352983746994783 | 2.362123929263624 | 2.373289699017862 | 2.340619140759819 | 2.341631976468593 | 2.334470101648628 | 2.287290343014047 | 2.252862323437585 | 2.190022802638086 | 2.139214461086156 | 2.076080262210123 | 2.01796209155871 | 1.969884284013566 | 1.947879354833743 | 1.897879402112882 | 1.844468059632106 | 1.798793433535025
Spreadsheet: john_griffith__15938__11_14_01OH
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HO Z1 | 56 | 400 | 500 | 47.5 | 59.4 | 1.88 | 2001-11-14 15:22:00
 | HO F2 | 57 | 780 | 820 | 50.8 | 53.4 | 1.87 | 2001-11-14 15:22:00
 | HO G2 | 58 | 1070 | 1150 | 51.5 | 55.4 | 1.95 | 2001-11-14 15:22:00
 | [NAME] | 57 | 1210 | 1325 | 50.8 | 55.7 | 1.91 | 2001-11-14 15:22:00
 | HO J2 | 57 | 1260 | 1400 | 47.1 | 52.3 | 1.78 | 2001-11-14 15:22:00
 | HO K2 | 56 | 1250 | 1450 | 42.9 | 49.8 | 1.63 | 2001-11-14 15:22:00
 | HO M2 | 56 | 1350 | 1500 | 42.5 | 47.2 | 1.58 | 2001-11-14 15:22:00
 | HO N2 | 56 | 1325 | 1475 | 39.1 | 43.5 | 1.45 | 2001-11-14 15:22:00
 | HO Q2 | 57 | 1400 | 1550 | 38.1 | 42.3 | 1.44 | 2001-11-14 15:22:00
 | HO U2 | 57 | 1425 | 1625 | 36.8 | 42 | 1.41 | 2001-11-14 15:22:00
 | [NAME] | 58 | 1525 | 1675 | 37 | 40.7 | 1.42 | 2001-11-14 15:22:00
 | HO X2 | 60 | 1575 | 1700 | 35.3 | 38.1 | 1.38 | 2001-11-14 15:22:00
 | [NAME] |  |  |  | 33.3 | 36.6 | 1.32 | 2001-11-07 14:56:00
 | HO F3
 | [NAME] |  |  |  |  |  | 0.72 | 2001-07-18 22:45:00
 | HO H3
Spreadsheet: 1815fd8d-5dca-4e7f-8260-73aecadcd84a
Sheet: Sheet1

Unnamed: 0 | State of New Hampshire - Primary Election | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
2012-09-11 00:00:00 | Governor - Democratic
Hillsborough County | [NAME], d | [NAME], d | [NAME], d | Ovide Lamontagne, r | [NAME], r | [NAME], r | [NAME]
Amherst | 204 | 487 | 36 | 1 |  |  | 2
Antrim | 105 | 87 | 16 |  |  |  | 0
Bedford | 210 | 720 | 69 | 9 | 2 |  | 2
Bennington | 42 | 60 | 5 |  |  |  | 0
Brookline | 76 | 171 | 38 |  |  |  | 0
Deering | 72 | 48 | 4 | 1 |  |  | 0
Francestown | 83 | 84 | 14 |  |  |  | 0
Goffstown | 255 | 605 | 95 | 16 | 2 |  | 0
[NAME] | 68 | 62 | 3 |  |  |  | 0
Greenville | 33 | 44 | 12 |  |  |  | 1
Hancock | 182 | 115 | 18 |  |  |  | 0
Hillsborough | 127 | 136 | 24 | 1 |  |  | 1
Hollis | 139 | 343 | 26 |  |  |  | 0
Hudson | 206 | 293 | 90 | 7 | 4 |  | 0
Litchfield | 72 | 231 | 27 |  | 3 |  | 0
Lyndeborough | 33 | 78 | 8 |  |  |  | 0
[NAME] | 204 | 701 | 40 | 33 | 2 |  | 3
[NAME] | 182 | 447 | 49 | 19 | 2 |  | 4
[NAME] 3 | 110 | 225 | 38 | 10 | 2 |  | 0
[NAME]* | 121 | 252 | 44 | 24 | 2 |  | 2
[NAME] | 111 | 189 | 51 | 15 | 1 |  | 0
[NAME] 6 | 145 | 373 | 74 | 29 | 1 |  | 2
[NAME] | 133 | 272 | 44 | 24 | 2 |  | 2
[NAME] 8 | 145 | 374 | 57 | 20 | 1 |  | 2
[NAME] 9 | 145 | 300 | 58 | 30 | 3 |  | 3
[NAME] 10 | 162 | 348 | 65 | 30 | 2 |  | 0
[NAME] 11 | 100 | 223 | 60 | 19 | 6 |  | 1
[NAME] 12 | 109 | 264 | 42 | 21 | 4 |  | 1
Mason | 26 | 33 | 10 | 1 |  |  | 0
Merrimack | 240 | 767 | 116 |  |  |  | 5
Milford | 205 | 424 | 54 | 4 | 2 |  | 2
[NAME] | 48 | 132 | 14 | 1 |  |  | 0
[NAME] | 139 | 393 | 61 | 4 | 1 |  | 1
[NAME] | 86 | 295 | 27 | 3 | 1 |  | 2
[NAME] | 106 | 321 | 26 |  |  |  | 0
[NAME] | 77 | 159 | 26 | 1 | 1 |  | 0
[NAME] | 102 | 281 | 37 | 4 | 2 |  | 1
[NAME] | 79 | 249 | 35 | 2 | 1 |  | 0
[NAME] | 113 | 259 | 41 |  |  |  | 0
[NAME] | 88 | 343 | 20 |  |  |  | 1
[NAME] 9 | 125 | 292 | 34 | 1 | 3 |  | 0
New Boston | 112 | 257 | 36 | 6 | 1 |  | 0
New Ipswich | 59 | 96 | 23 |  |  |  | 1
[NAME] | 93 | 183 | 35 | 2 | 5 |  | 3
Peterborough | 426 | 330 | 42 |  | 1 |  | 1
[NAME] | 31 | 17 | 1 |  |  |  | 0
Temple | 76 | 53 | 8 | 1 | 1 |  | 1
Weare | 177 | 230 | 19 | 2 | 4 |  | 1
[NAME] | 95 | 183 | 21 |  | 1 |  | 0
Windsor | 10 | 4 | 2 |  |  |  | 0
TOTALS | 6087 | 12833 | 1795 | 341 | 63 |  | 45
*corrections received from ward clerk
Spreadsheet: 812857d1673426503-dates-to-be-list-all-in-one-cell-mini-table-dates-
Sheet: Table

Row Labels | Date in Whitespace
Aylesford | 05-06-2023 & 06-06-2023 & 07-06-2023
Belper
Birmingham
[NAME]
Burscough
Central
Clay Cross
Crumlin
Devizes
[NAME]
Featherstone
[NAME]
Hinckley
Industrial
KETTERING
[NAME]
[NAME]
Lockerbie
London - Mill Street
Louth - Aries House
Louth - Grimsby Road
Louth - Windsor Road
[NAME]
Neath
Newcastle
PLC
PLYMOUTH
Redditch
Retail Marketing
Retail North
Retail South
Sheerness
Wellingborough
Wirral
Spreadsheet: 182351d1348448072-fantasy-football-statistics-problem-conditional-formatting-maximums-with-reference-league-bvj-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QUARTERBACKS |  |  |  |  | RUNNINGBACKS
 |  |  | week 1 | week 2 | week 3 | week 4 | week 5 | week 6 | week 7 | week 8 | week 9 | week 10 | week 11 | week 12 |  | MAX | MAX 2 | MAX 3 |  |  | MAX | MAX 2 | MAX 3
QB | [NAME] | DAL | 23.5 | 26.2 | 19.1 |  |  |  |  |  |  |  |  |  | 26.2 | 26.2 | 23.5 | 19.1
WR | [NAME] | NYG | 17 | 9.3 | 2.3 |  |  |  |  |  |  |  |  |  | 17
WR | [NAME] | TB | 8.4 | 7.6 | 13.9 |  |  |  |  |  |  |  |  |  | 13.9
WR | [NAME] | JAC | 6.5 | 6.8 | 3.4 |  |  |  |  |  |  |  |  |  | 6.8
RB | [NAME] | BAL | 22.6 | 17.5 | 26.8 |  |  |  |  |  |  |  |  |  | 26.8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
QB | [NAME] | NO | 28.3 | 21.3 | 22.2 |  |  |  |  |  |  |  |  |  | 28.3 | 28.3 | 22.2 | 21.3
WR | [NAME] | CHI | 12.2 | 17 | 11.8 |  |  |  |  |  |  |  |  |  | 17
WR | [NAME] | NE | 12.9 | 7.2 | 16.9 |  |  |  |  |  |  |  |  |  | 16.9
WR | [NAME] | PHI | 15.2 | 14.9 | 11.4 |  |  |  |  |  |  |  |  |  | 15.2
RB | [NAME] | TB | 12.3 | 22.1 | 17.1 |  |  |  |  |  |  |  |  |  | 22.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Points | Player | Team | Week |  | Points | Player | Team | Week
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1st | 28.3 | [NAME] | NO | 1 | 1st
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2nd | 26.2 | [NAME] | DAL | 2 | 2nd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3rd | 23.5 | [NAME] | DAL | 1 | 3rd
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | helper cells
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: 819243d1677337802-how-to-stack-one-column-of-data-into-two-columns-s666-pq-how-to-stack-one-column-of-data-into-two-columns
Sheet: Sheet1

raw |  | Column1 | Column2
A001 |  | A001 | A002
A002 |  | A003 | A004
A003 |  | A005 | A006
A004 |  | A007 | A008
A005 |  | A009
A006
A007
A008
A009
Spreadsheet: 828521d1683564223-sum-fte-counts-by-month-between-two-dates-test
Sheet: Report

Earned Value Analysis Report
 | Prepared By: | [Manager's Name]
 | Date: | [Report Date]
 |  | [42]
 | For Period: | [Report Period]
Summary:
 | [Use this space to write a brief summary or to record specific observations or notes]
Planned Value (PV) or Budgeted Cost of Work Scheduled (BCWS)
WBS | Task Name | TBC | 2023-10-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] can change the labels for the periods (e.g. Week 1/2/3, Jan/Feb/Mar, etc.)
 |  |  | 1000 | 500 | 2000 |  |  |  |  |  |  |  |  |  |  | [NAME] or edit values in the light-blue cells.
 |  |  |  | 500 | 800 | 900 | 2000
 |  |  |  |  | 700 | 2000 | 1000 | 800
 |  |  |  |  | 200 | 600 | 1000 | 1500
 |  |  |  |  |  |  | 700 | 500 | 1000 | 800
 |  |  |  |  |  |  |  |  |  | 700 | 2000 | 1000 | 2000 | 1000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] To add more tasks, insert rows above this one. You can or delete this row after you are done adding tasks.
 | Total Budgeted Cost
 |  | Cumulative Planned Value (PV)
Actual Cost and Earned Value
 |  | Cumulative Actual Cost (AC) |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] the Actual Costs as calculated from the AC worksheet.
 |  | Cumulative Earned Value (EV) |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] the Earned Value as calculated from the EV worksheet.
Project Performance Metrics
 |  | Cost Variance (CV = EV - AC)
 |  | [NAME] (SV = EV - PV)
 |  | Cost Performance Index (CPI = EV/AC)
 |  | Schedule Performance Index (SPI = EV/PV)
 |  | Estimated Cost at Completion (EAC)
Spreadsheet: 43119d1241710392-formula-w-arrays-05-may-2009-imc-cash-download
Sheet: Rec08

 |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  | 5155 | 0862 | 5098 | 0854 | 0847 | 5049 | 5749 | 0434 | 7890 | 1290
 | Suspense
2009-04-26 00:00:00 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2009-04-27 00:00:00 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2009-04-28 00:00:00 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2009-04-29 00:00:00 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2009-04-30 00:00:00 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2009-05-01 00:00:00 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2009-05-02 00:00:00 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2009-05-03 00:00:00 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2009-05-04 00:00:00 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2009-05-05 00:00:00 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2009-05-06 00:00:00 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2009-05-07 00:00:00 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2009-05-08 00:00:00 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2009-05-09 00:00:00 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2009-05-10 00:00:00 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2009-05-11 00:00:00 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2009-05-12 00:00:00 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2009-05-13 00:00:00 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2009-05-14 00:00:00 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2009-05-15 00:00:00 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2009-05-16 00:00:00 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2009-05-17 00:00:00 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2009-05-18 00:00:00 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2009-05-19 00:00:00 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2009-05-20 00:00:00 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2009-05-21 00:00:00 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2009-05-22 00:00:00 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2009-05-23 00:00:00 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2009-05-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 0
2009-05-25 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 0
2009-05-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 0
2009-05-27 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 0
2009-05-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 0
2009-05-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 0
2009-05-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 692464d1598377862-checking-a-value-in-an-area-formula-example
Sheet: Sheet1

While/Black Zone | Buy |  |  |  |  |  | [NAME] based on A and B columns
White
White | 50 | OK
White
White | 100 | Not OK since I already bought in this White  zone
White
Black | 100 | OK
Black
Black
Black | 50 | Not OK since I already bought in this Black zone
White | 20 | OK
Black | 30 | OK
Black
Black
White
Spreadsheet: 75060d1275583191-excel-2007-compiling-summary-of-items-across-worksheets-example_summary
Sheet: Co_B

Company B
Item | Catalogue No | Quantity
Item B | 12345 | 3
Item C | 123 | 4
Item D | 123456 | 2
Item E | 12 | 1
Item C | 123 | 4
Item A | 1234 | 12
Spreadsheet: 182162d1348318553-how-to-get-concatenate-data-in-a-cell-to-arrange-vertically-arrange-vertical-
Sheet: Sheet1

File present | Compliant | Never started | Customer attached in PE within 15 days of referral | COMMENTS | Consent form signed and dated by customer | COMMENTS | Mandatory appointment letters are all on file | COMMENTS | Initial assesment completed within 5 days of attachment | COMMENTS | Travel declarations | COMMENTS | Doubt referral paperwork for all FTA | COMMENTS |  | Action plan completed within 10 days of attachment | COMMENTS | 4 weekly progress review with a minimum of 6 job actions | COMMENTS | Fortnightly meaningful contact in CI | COMMENTS | Updated CV on file | COMMENTS | Job entry WP7 or self employment declaration | COMMENTS | Back to work plan | COMMENTS | Comments and actions required
y | n | n | y |  | y |  | y |  | n |  | n/a |  | n/a |  |  | n |  | n |  | n |  | y |  | n/a |  |  |  | iar signed before attached date very few appointments booked no email no convictions asked no wage details no job goals confidential information printed and put on file - removed | I organised this list using alt and return to put them on top of each other
 | n |  |  | this comment is this long |  | BLANK |  | this might be short |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | can a formula or macros automatically take text from the comments boxes acrss the sheet and arrange in a list?
Spreadsheet: 217488-sum-totals-purchase
Sheet: L10-0021-000

L10-0021-000
Part # | Description | QTY | [NAME]
30787-09 | VLV MTR [NAME] 2200 SMA PO ECM | 3
30829-02 | VLV BALL BALON 2R-S42 SE 1000 | 2
30127-07 | [NAME] WLLMRK ST4UP | 2
30228-03 | [NAME] WLLMRK 3 X 5 | 2
30585-02 | [NAME] WLLMRK 1/4 X 10 | 3
30565-02 | REG 1PR-3P25S 35-80 1/4ORI 1 | 1
30777-02 | GAUGE COCK SET BRASS 1/2 300# | 2
31006-01 | GLASS SIGHT REDLINE 5/8X14-3/4 300# | 2
30785-03 | VLV MTR KMRY 112 SMT DAB EMB3 | 1
30570-01 | REG WATTS R125-04A 0-25 1/2 | 1
30334-01 | GAUGE 200 PSI DRY 2-1/2X1/4 BM | 2
30338-01 | GAUGE 30 PSI DRY 2-1/2X1/4 BM | 5
30345-01 | GAUGE 600 PSI DRY 2-1/2X1/4 BM | 2
Spreadsheet: 686394d1594582604-matching-cash-received-against-corresponding-invoice-matching-excel-sheet-pcb-1-
Sheet: Sheet1

 | INCOME LEDGER |  |  |  |  | Pivot table: | Name | Invoice | Date | #invoices | Invoice Amount
Date | Code | Name | Invoice | Amount Paid |  | Click on the +/- for details---> | [NAME] | A0001 | 2020-02-01 00:00:00 | 1 | 4000
2020-02-01 00:00:00 | US001 | [NAME] | A0001 | 4000 |  |  |  | A0003 | 2020-02-03 00:00:00 | 1 | 5000
2020-02-02 00:00:00 | US-0002 | [NAME] | A0002 | 2000 |  |  | [NAME] |  |  | 2 | 9000
2020-02-03 00:00:00 | US-0003 | [NAME] | A0003 | 5000 |  |  | [NAME] |  |  | 1 | 2000
2020-02-10 00:00:00 | US-0004 | Omega Jonnes | A0004 | 1000 |  |  | [NAME] |  |  | 1 | 3000
11/02/202 | US-0005 | [NAME] | A0005 | 3000 |  |  | Omega Jonnes |  |  | 1 | 1000
A7 is NOT a date, but text |  |  |  |  |  |  | Grand Total |  |  | 5 | 15000
I woul like to match all cash paid to the ledger below for example by [NAME] $9000 ($4000 and $5000)
and to the the accounts receivable ledger
 | ACCOUNTS RECEIVEABLE LEDGER
Date | Code | Name | Invoice | Amount | #payments
 |  | [NAME]
 |  | [NAME]
 |  | Omega Jonnes
 |  | [NAME]
Spreadsheet: 136312d1326533590-vlookup-limits-multi-year-testing-data-sheets2
Sheet: 2011

 |  |  |  |  |  | 2011 | Testing
 |  |  |  |  |  | Running Records |  |  | Alphabet/Phonograms |  |  | Oxford Word List |  | Writign Sample |  |  | General testing |  |  |  | NAPLAN
ID |  | Birht | Yea |  | Feb | June | Sept | Feb | June | Sept | Feb | June | Sept | Feb | Sept | PATmaths | Spelling | Reading | Numeracy | Writing | Reading | Spelloing | [NAME]
Number | Name | Date | Level | Sex |  |  |  |  |  |  |  |  |  |  |  |  |  | Comprehension
110 | Shane | 1/14/2001 | 5 | m | 26 | 30 | 30 | 100 | 100 | 100 | 42 | 50 | 55 | 20 | 25 | 67 | 11.5 | 69 | 7 | 6 | 6 | 6 | 6
111 | [NAME] | 2002-02-02 00:00:00 | 4 | f | 21 | 25 | 27 | 85 | 90 | 100 | 24 | 35 | 41 | 16 | 18 | 45 | 9.2 | 54 |  | na | na | na | na
112 | [NAME] | 2003-03-03 00:00:00 | 3 | f | 15 | 18 | 20 | 65 | 75 | 89 | 15 | 12 | 16 | 12 | 15 | 28 | 8.2 | 45 | n4 | 2 | 4 | 3 | 4
21 | [NAME]
45 | [NAME]
23 | shane
3 | [NAME] |  |  | m | 7 | 8.25
3 | [NAME] |  |  | f
3 | [NAME] |  |  | m
3 | [NAME] |  |  | f
4 | [NAME] |  |  | m | 10.2 | 11.25
4 | Belinda [NAME] |  |  | f | 10.6 | 11.25 | 84
4 | [NAME] |  |  | f
5 | [NAME] |  |  | f | 9.6 | 9.3 | 9
5 | [NAME] |  |  | m
5 | [NAME] |  |  | f | 11 | 11.1 | 28
5 | [NAME] |  |  | m | 9.2 | 11.1 | 11
5 | Paige |  |  | f | 10.3 | 10.3 | 32
2 | [NAME] |  |  | f
2 | [NAME] |  |  | f |  |  | 2
1 | Belinda Vugec |  |  | f
6 | [NAME] |  |  | m
6 | [NAME] |  |  | m
6 | [NAME] |  |  | f | 9.8 | 8.9 | 5
6 | [NAME] |  |  | m | 9.1 | 9.2 | 17
6 | [NAME] |  |  | f
6 | [NAME] |  |  | f
5 | [NAME] |  |  | f | 7.75 |  | 18
5 | Mitchell |  |  | m |  |  | 5
1 | [NAME] |  |  | m |  |  | 15
7 | [NAME] |  |  | f |  |  | 19
7 | Chloe |  |  | f |  |  | 11
7 | Shaylene |  |  | f |  |  | 11
7 | Samara |  |  | f
7 | [NAME] |  |  | m
1 | [NAME] |  |  | m |  |  | 97
2 | Takotah |  |  | f |  |  | 67
3 | Kaleb |  |  | m |  |  | 8
3 | Emily |  |  | f
 | Lucas |  |  |  |  |  | 16
 | Averages
 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 23