tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 032b9a18-dcad-49e4-af81-85e7270101dc
Sheet: Sheet1

Unnamed: 0 | Hourly  Generation & Demand | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Date | 2012-04-19 01:13:10.600000
Time | Generation | Demand | Shortage | Remarks
Hour | MW | MW | MW
01:00:00 | 4204 | 4310 | 106
02:00:00 | 4235 | 4305 | 70
03:00:00 | 4211 | 4290 | 79
04:00:00 | 4082 | 4250 | 168
05:00:00 | 4105 | 4230 | 125
06:00:00 | 4107 | 4210 | 103
07:00:00 | 4092 | 4250 | 158
08:00:00 | 4066 | 4300 | 234
09:00:00 | 4001 | 4325 | 324
10:00:00 | 3854 | 4350 | 496
11:00:00 | 3768 | 4375 | 607
12:00:00 | 4022 | 4400 | 378 | Day Peak
13:00:00 | 3954 | 4400 | 446
14:00:00 | 3950 | 4450 | 500
15:00:00 | 4089 | 4500 | 411
16:00:00 | 4136 | 4550 | 414
17:00:00 | 4207 | 4600 | 393
18:00:00 | 4229 | 4800 | 571
18:30:00 | 4503 | 5200 | 697
19:00:00 | 4764 | 5700 | 936
19:30:00 | 4923 | 5800 | 877
20:00:00 | 4916 | 5800 | 884
[NAME] | 4983 | 5800 | 817 | Evening Peak
22:00:00 | 4780 | 5600 | 820
23:00:00 | 4704 | 5400 | 696
24:00 | 4537 | 5000 | 463
Spreadsheet: 738687d1625173081-formula-to-calculate-total-amount-of-previous-invoice-book1
Sheet: Numbering (2)

Project Name | Sequence |  | Project Name-DSequence | Project Name-IAFSequence |  | DSequence | Project Name-DSequence | Project Name-IAFSequence | Invoice Total Amount |  |  |  |  | Current IAF | PO No. | Total amount of Previous Invoice | Total amount of Previous Invoice
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Lab-45123456 |  |  |  |  |  |  |  |  | 1000
Spreadsheet: 83096d1283161725-multi-comboboxes-for-dynamic-dropdown-menus-multi-combo-boxes
Sheet: Sheet1

Air_System
Brakes
Bodywork
Air_System
Compressor
High tone horn
Dryer / Lubricator
Filters / Strainers
Gauges
Water Separators / Auto Drain Valves
Pressure switch / Transducer
Pressure regulator
afety valve
Magnet valve
Hose / Piping
Reservoirs
Valves / Cocks (other than [NAME])
Brakes
Brakes-Air Vacuum
Brake relay valve
Brake pipe
Drivers Brake Valve / Controller
Brake distributor
Load proportioning valve
Hand / Parking Brakes magnet valve
Parking brake anti-compounding valve
EP converters
Brake actuator / calipers/ pads
Mechanical Linkage (incl Cable)
Vigilance valve / DSD valve
S Magnet valve
T Brake Control Units
Bodywork
Windscreen wiper / washer
Droplights
Body side lights
[NAME] door leaves
Cab doors
Underframe doors
Outside indicator lamps
Towing coupler
Tanks / Securing Members
Vestibule - Gangways - Ends - Corners
Windscreens
Spreadsheet: 229484d1366403912-looking-up-multiple-occurences-of-the-same-date-index-match
Sheet: Sheet2

320 | 2013-07-09 00:00:00
172 | 2013-07-22 00:00:00
5350 | 2013-07-22 00:00:00
3240 | 2013-07-24 00:00:00
Spreadsheet: 836941d1689748669-reverse-proportional-distribution-example-1-1-
Sheet: Sheet1

Item | Reviews | Ranking | New Rank |  | Variable | 0.05
A | 161 | 499
B | 6774 | 500 |  | 33.78485174936005
C | 5744 | 504 |  | 35.35833665566939
D | 9484 | 498 |  | 31.27748689900517
E | 30 | 500 |  | 2006.3715250055
Spreadsheet: darrell_schoolcraft__7309__imball0201
Sheet: mewborne

 | [NAME]
 | 500174 |  | 53888 |  | 78060 |  | 78062
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 5471 | 5741 | 1041 | 1125 | 1062 | 872 | 1490 | 1123
2 | 5369 | 5741 | 815 | 1125 | 1031 | 872 | 1504 | 1123
3 | 5302 | 5741 | 762 | 1125 | 986 | 872 | 1644 | 1123
4 | 3429 | 5741 | 400 | 1125 | 953 | 872 | 1516 | 1123
5 | 5207 | 5741 |  | 1125 | 927 | 872 | 1465 | 1123
6 | 5669 | 5741 | 358 | 1125 | 921 | 872 | 1438 | 1123
7 | 6151 | 5741 |  | 1125 | 821 | 872 | 1413 | 1123
8 | 6148 | 5741 | 678 | 1125 | 1002 | 872 | 1398 | 1123
9 | 5873 | 5741 | 803 | 1125 | 979 | 872 | 1695 | 1123
10 | 5548 | 5741 | 1069 | 1124 | 985 | 872 | 1531 | 1123
11 | 5525 | 5741 | 1322 | 125 | 994 | 872 | 1481 | 1123
12 | 5676 | 5741 | 1071 | 125 | 969 | 872 | 1439 | 1123
13 | 5786 | 5741 | 746 | 125 | 983 | 872 | 1427 | 1123
14 | 6107 | 5741 | 962 | 125 | 617 | 872 | 1418 | 1123
15 | 6068 | 5741 | 777 | 125 | 811 | 872 | 1663 | 1123
16 | 6099 | 5741 | 484 | 95 | 1066 | 662 | 1472 | 1123
17 | 5842 | 4241 | 584 | 125 | 1015 | 872 | 1444 | 1123
18 | 5631 | 4241 | 401 | 125 | 1000 | 872 | 1409 | 1123
19 | 5880 | 4241 | 494 | 125 | 985 | 872 | 1397 | 1123
20 | 5162 | 4241 | 540 | 125 | 986 | 872 | 1373 | 1123
21 | 3353 | 4241 | 424 | 125 | 946 | 872 | 1650 | 1123
22 | 6538 | 4241 | 331 | 125 | 900 | 872 | 1503 | 1123
23 | 3249 | 4238 | 225 | 125 | 995 | 872 | 1352 | 1123
24 |  |  |  |  |  |  |  |  |  |  | 377
25 |  |  |  |  |  |  |  |  |  |  | 725
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  |  |  |  |  |  |  | 406899.92
2002-01-23 00:00:00
CBS Volume
 |  |  | 166968
Spreadsheet: 143034d1330138857-what-is-the-formula-for-consecutive-occurences-in-a-column-sample-sheet
Sheet: Data

Week Number | Category 1 | Category 2 | Category 3
1 | Failed
1 | Failed
1 | Failed
1 | Passed
2 | Passed
2 | Passed
2 | Passed
2 | Passed
Spreadsheet: 746124d1630514821-calculate-row-that-is-alpha-numeric-sample-timesheet
Sheet: TSSC

Company Timesheet
U.S.A. |  |  |  |  |  |  |  |  |  |  |  |  | Division
 |  |  | Month: |  |  | 2021-09-01 00:00:00 |  |  |  |  |  |  |  | Week Ending 03 Sep 2021 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sheet |  | 1 | of | 1
Name |  | Contract # |  | Task# |  | Document # |  |  |  |  | Location:
Clock # |  | 1.1.1.1 |  | WTF |  | [PHONE] |  |  |  |  | [NAME]
[NAME] (PS) # |  | Time Category | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | Totals
Doe, [NAME] |  | Shift and/or TDY | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expected
Clock# | 00001 | Straight | 8 | 8 |  |  |  | 8 | 7 | 8 | 8 | 8 |  |  |  |  |  | 8 |  |  |  |  |  |  | 8 | 8 |  |  |  | 8 | 8 | 8 |  | 103 | 103 | Calulates Correctly
PS# | 00002 | Overtime |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 4 | Calulates Correctly
 |  | Training |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | Calulates Correctly
 |  | Vacation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  |  |  | 8 | 8 | Calulates Correctly
 |  | Sick |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 8 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 | 24 | Calulates Correctly
 |  | Holiday/Exception |  |  | 8H |  |  |  |  |  |  |  |  |  |  |  |  |  | 8J |  |  | 8B | 8B | 8B |  |  |  |  |  |  |  |  |  | 0 | 40 | This row is the problem, I'm trying to figure out how to separate the numbers from the text
B = Bereavement |  | T/D = Depart |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Page Totals |  |  |  |  |  | Then sum the row like the rows above.
P = Personel |  | T/R = Return |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Straight Time |  |  |  | 103
J = Jury |  | M = Military |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Overtime |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Training Time |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vacation |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sick Time |  |  |  | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Holiday / Exception |  |  |  | 0 | 40 | Would be correct if AI14 would calculate just the numbers
 |  |  | Prepared By: |  |  |  | Supervisor |  |  |  |  |  |  |  | Supervisor: |  |  |  | [NAME] |  |  |  |  | Date: |  | 2021-09-03 00:00:00 |  |  |  | Tab Total Time |  |  |  | 140 | 180 | Would be correct if AI14 would calculate just the numbers
Spreadsheet: 1f4e6571-7e3c-42fe-a0ed-975319173c5d
Sheet: 1.4 Long-term unemployment

1.4 Long-term unemployment
Month | 2010–11 | 2011–12 | 2012–13 | 2013–14 | 2014-15
Long-term unemployed (a) (b) – '000
July | 112.735316 | 116.1871217 | 115.6800362 | 132.8528308 | 171.1278338
August | 114.4988729 | 115.4468932 | 117.9777099 | 136.2662804 | 171.4928225
September | 115.8160458 | 114.6788828 | 120.2819701 | 139.4590697
October | 116.2842511 | 114.0594506 | 122.0648662 | 142.7089241
November | 115.7177316 | 113.9986083 | 122.520174 | 146.0894817
December | 114.4671959 | 114.6818925 | 121.5362579 | 149.6919437
January | 113.3056428 | 115.7864721 | 120.0971078 | 153.2958354
February | 112.5345835 | 116.6989881 | 119.3539222 | 157.1156038
March | 112.8314006 | 116.7292544 | 120.2076601 | 160.920252
April | 114.1103757 | 115.8481477 | 122.4440359 | 164.5357064
May | 115.5411635 | 114.7949237 | 125.7160297 | 167.5900435
June | 116.3699077 | 114.5284681 | 129.366745 | 169.7630421
Annual average | 113.919219425 | 115.2809436916667 | 121.5399985416667 | 151.904305125
Ratio (b) – per cent
July | 18.6929844 | 19.2927073 | 18.5621346 | 19.2146714 | 22.6487456
August | 19.0734741 | 18.9313834 | 18.745146 | 19.6551911 | 22.4538471
September | 19.3421528 | 18.6523844 | 18.9377184 | 20.0152349
October | 19.4660517 | 18.4833476 | 19.0790593 | 20.3094073
November | 19.4547262 | 18.4855837 | 19.0164505 | 20.5788348
December | 19.3663978 | 18.6623361 | 18.7099399 | 20.889663
January | 19.2985076 | 18.9097539 | 18.3086008 | 21.2678608
February | 19.2860904 | 19.0805511 | 17.9856042 | 21.7178962
March | 19.4032626 | 19.094521 | 17.8812692 | 22.1512254
April | 19.5669202 | 18.9425469 | 17.9957508 | 22.5070634
May | 19.6529091 | 18.7080687 | 18.3309689 | 22.710641
June | 19.5770511 | 18.5393971 | 18.772992 | 22.7367792
Annual average | 19.28599124195199 | 18.7800546886211 | 18.52233725134591 | 21.23161725815737
(a) Unemployed for 52 weeks or more.
(b) Monthly figures are trend. Annual figures are from the original series.
 |  |  |  |  |  |  |  | Update
Source: ABS, Labour force, Cat. no. 6291.0.55.001 |  |  |  |  |  |  |  | 2014-10-10 00:00:00
Spreadsheet: 02382df2-f177-464d-ac92-978a387ac4bc
Sheet: Calculations

Effects of Replacement Strategies on Sap Yield and Net Profit
Yrs |  | Nothing | Spouts | [NAME] | D1 | D2 | D3 | D4 | D5 | Clean | Clean+Spout
1 | 100 | 100 | 100 |  | 100 | 100 | 100 |  |  | 100 | 100
2 | 100 | 85.5 | 92.5 | 96 | 99 |  | 92.5 |  |  | 91 | 94
3 | 100 | 78 | 86.5 | 94 | 98 |  | 86.5 |  |  | 85 | 89
4 | 100 | 72 |  | 92 | 97 |  | 97 |  |  | 79.5 | 84.5
5 | 100 | 68 |  | 90 | 96 |  |  |  |  | 74.5 | 80
6 | 100 | 64.5 |  | 88 | 95 |  |  |  |  | 70 | 76
[NAME] sap
 |  | Nothing | Spouts | [NAME] | D1 | D2 | D3 | D4 | D5 | Clean | Clean+Spout
1
2
3
4
5
6
$ sap value produced per tap
 |  | Nothing | Spouts | [NAME] | D1 | D2 | D3 | D4 | D5 | Clean | Clean+Spout
1
2
3
4
5
6
$ per tap gained |  |  |  |  |  |  |  |  |  |  |  | Costs
 |  | Nothing | Spouts | [NAME] | D1 | D2 | D3 | D4 | D5 | Clean | Clean+Spout
1
2
3
4
5
6
Net Profit ($)
 |  | Nothing | Spouts | [NAME] | D1 | D2 | D3 | D4 | D5 | Clean | Clean+Spout
1 |  |  | 0 | 0 | 0 | 2 Yr | 3 Yr | 4 Yr | 5 Yr | 0 | 0
2
3
4
5
6
Net 5 Yr Profit ($)
Net Annual Profit ($)
 |  |  |  | Annual | 5-Yr
 |  |  | Strategy | Net Profit | Net Profit |  | Net Prof | [NAME]
 |  |  | S
 |  |  | [NAME]
 |  |  | D x 1
 |  |  | D x 2
 |  |  | D x 3
 |  |  | D x 4
 |  |  | D x 5
 |  |  | Cln
 |  |  | [NAME]
Spreadsheet: 728106d1618318278-how-can-i-pull-a-value-from-a-cell-if-it-finds-a-match-test-spreadsheet
Sheet: Cash Movements

Client Number | Search Name | Code | Amount | Date of Withdrawal
1731126 |  |  | 20000 | 2021-04-13 00:00:00
603460 |  |  | 328 | 2021-04-13 00:00:00
4666459 |  |  | 9763 | 2021-04-13 00:00:00
4666460 |  |  | 1208 | 2021-04-13 00:00:00
4667460 |  |  | 97000 | 2021-04-13 00:00:00
HAR239 |  |  | -1530 | 2021-03-01 00:00:00
CHANC0016 |  |  | -1400 | 2021-03-01 00:00:00
IPM  0052 |  |  | -1600 | 2021-03-15 00:00:00
0041848 |  |  | -1500 | 2021-03-05 00:00:00
Spreadsheet: 5f66d7e9-4596-4d7c-aa54-aa23a0fe85ea
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
FPERE | Test | FPERE | Perch, IgE | Perch, Lake IgE | Radioimmunoassay (RIA) | Plain, Red-Top Tube: Red |  |  | 1 | mL | Draw blood in a plain, red-top tube(s), serum gel tube is acceptable. Spin down and send 1 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | F/N MRT Quantitative Specific IgE Scoring System   IUnits             Class          Interpretation             <0.01                0             Non-Detectable 0.01 - 0.02       1/0            Equivocal .021 - 0.10         1             Low Level 0.11 - 0.5           2             Moderate Level 0.51 - 2.5           3             Moderate/High Level 2.51 - 12.5         4             High Level 12.51 - 62.5       5             Very High Level                               F/N MRT Scoring System - five fold   Class              Counts           Interpretation           0                  < 500            Negative 1/0              500-750          Equivocal 1                751-1600         Positive 2               1601-3600        With 3               3601-8000        Increasing 4               8001-18000      Sensitivity 5                >18001           To Antigen   Test Performed By:  MRT Laboratories                                50 [NAME].                                Hackensack, NJ  07601 | Monday through Thursday | 1 - 2 days | 3 - 8 days | 1 | 86003 |  |  |  |  | MRT Laboratories
FPERE | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 30 days
FPERE | Result | Z3245 | Counts | Counts | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FPERE | Result | [NAME] | IUnits | IUnits | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FPERE | Result | Z3247 | Class | Class | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 0d47cc84-7e62-4dc7-90e1-56708209a1a5
Sheet: Sheet1

Unnamed: 0 | January 2012 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Feb 2012 >>
 | Sunday |  |  | Monday |  |  | Tuesday |  |  | Wednesday |  |  | Thursday |  |  | Friday |  |  | Saturday
 | Dec | 25 |  | Dec | 26 |  | Dec | 27 |  | Dec | 28 |  | Dec | 29 |  | Dec | 30 |  | Dec | 31
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Qtr Ends
 |  | 1 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 5 |  |  | 6 |  |  | 7
 |  | 8 |  |  | 9 |  |  | 10 |  |  | 11 |  |  | 12 |  |  | 13 |  |  | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POC Reports
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Due To BusOps
 |  | 15 |  |  | 16 |  |  | 17 |  |  | 18 |  |  | 19 |  |  | 20 |  |  | 21
 |  | 22 |  |  | 23 |  |  | 24 |  |  | 25 |  |  | 26 |  |  | 27 |  |  | 28
 |  |  |  | BusOps Delivers
 |  |  |  | Report to ICC
 |  | 29 |  |  | 30 |  |  | 31 |  | Feb | 1 |  | Feb | 2 |  | Feb | 3 |  | Feb | 4
Spreadsheet: 51916d1251489126-find-and-replace-blank-characters-space-example
Sheet: Sheet2

0.00 |  | 346.18 | 346.18
-22,991.63 |  |  | 0.00
0.00 |  | -43.39 | -43.39
347.08 |  |  | 0.00
0.00 |  | -10.41 | -10.41
347.08 |  |  | 0.00
0.00 |  | 1,447.25 | 1,447.25
-23,068.29 |  |  | 0.00
0.00 |  | 347.34 | 347.34
-23,068.29 |  |  | 0.00
0.00 |  | -48.92 | -48.92
391.34 |  |  | 0.00
0.00 |  | -11.74 | -11.74
391.34 |  |  | 0.00
0.00 |  | 1.62 | 1.62
27.48 | -0.10 | 1.84 | 1.74
0.00 |  | 0.38 | 0.38
27.48 | -0.03 | 0.44 | 0.41
0.00 |  | 0.17 | 0.17
3.00 | -0.02 | 0.20 | 0.18
Spreadsheet: 698803d1602182079-vlookup-with-3-conditions-problem
Sheet: Sheet1

 |  |  |  |  |  |  |  | Initial | Final
Category | Condition 1 | Condition 2 | Date |  |  |  |  | 2020-01-01 00:00:00 | 2021-02-01 00:00:00
Assistant | OK | No | 2020-01-01 00:00:00
Assistant | OK | No
Assistant | Não | Yes
Assistant | OK | Yes | 2020-07-30 00:00:00
Senior | Não | Yes
AE | OK | No
AM | OK | Yes |  |  | Category | Date
M | OK | Yes |  |  | Assistant
PTN | OK | Yes
Senior | OK | Yes
AE | OK | Yes
AM | OK | No
M | OK | No
PTN | OK | No
Senior | OK | Yes
AE | Não | No
Assistant | OK | Yes | 2021-09-30 00:00:00
AM | Não | No
M | OK | No
PTN | Não | No
Spreadsheet: 742228d1627601354-formulas-not-remaining-with-correct-rows-after-sort-sample
Sheet: All Deployments

 | CLICKING THE BUTTON ABOVE RUNS A MACRO TO REFRESH THE DATA |  |  |  |  |  |  |  |  | Hover over column headers to see additional information about the data in the cells in the each column
 | DEPARTMENT TOTALS YTD (ALL DEPLOYMENTS) |  |  |  |  | TOTAL |  |  |  | TOTAL | TOTAL | TOTAL | TOTAL |  | TOTAL | TOTAL | TOTAL | TOTAL | TOTAL | TOTAL |  | TOTAL | TOTAL | TOTAL | TOTAL
 |  |  |  |  | YTD Total # of Deployments
 | Primary County | Primary State | Primary Cat Code Being Handled | Primary Loss Type Being Handled | Claim Rep | Supervisor | 1st Day Claims Rec'd | (Arrive) 1st Work Day | ([NAME]) 1st Travel Day | Meeting, Training, Travel, PTO, Off Days During Tour | Count of Days                   Able to Inspect | Days Onsite to Date | Days Remaining Onsite | Target Claims Per Day | Target Capacity | Remaining                      Capacity at Target | Number of reinspects Assigned | Number of claims                    turned back in                              from associate | Total Assigned | Claims Assigned Over or Under Target | CA at Capacity?                   "Yes" = At Capacity | Average Severity based on estimates with a dollar value | Count of Returned Estimates to Date | Avg Claims Per Day to Date Based on Returned Estimates to Date | Avg Claims Per Day for Entire Deployment at Current Assignment Count if no Add'l Assigned | NOTES
6
4
5
3
1
2
Spreadsheet: 855493d1705037625-ignore-the-formula-if-cell-is-blank-no-po-delivery
Sheet: NO PO DeliveryTxn VS Closed Txn

No | DO # | SO # | Customer | Del Date | Invoice# | Closed  Date | TAT (days) | # of Days Pending | Remarks
1 | 12345 | 2304583 | ABC | 2023-11-07 00:00:00 |  | 2024-01-11 00:00:00
2 | 123456 | 2400001 | DEF | 2023-12-10 00:00:00
3 | 124567 | 2400002 | GHI | 2024-01-04 00:00:00
4
5
Spreadsheet: 682908d1592392234-formula-indice-corresp-exemplo
Sheet: Sub. 3 A

FICHA DE REGISTO DO DEPÓSITO
NÚMERO: Sub 3A                                                      CAPACIDADE (Litros): 136.660                              TIPO: Subterrâneo ([NAME])
DATA | VOLUME (LITROS);(G/L) |  | Quantidade no depósito | PRODUTO | PROVENIÊNCIA | DESTINO | Operação efectuada | OBSERVAÇÕES
 | ENTRADA | SAÍDA
2020-05-19 00:00:00 |  |  | 136660 | VTUE | PRODUÇÃO PRÓPRIA
 |  |  | 1200 | VBUE
 |  |  | 1000 | VBN
Spreadsheet: 269499d1381174421-formatting-a-table-to-pull-data-array-formula-sampletable_student1990-2-pt-oeldere-
Sheet: Sheet1

Style Matrix
 |  |  |  | Legend
 |  |  |  | Fundamental Approach
 |  |  |  | [NAME]
3-Year
 |  | Style 1 |  | Style 2 |  | Style 3 |  | Style 4 |  | Style 5
 |  | F | Q | F | Q | F | Q | F | Q | F | Q
A | Annualized Return (%)
 | Annualized StdDev (%)
 | [NAME]
B | Annualized Return (%)
 | Annualized StdDev (%)
 | [NAME]
C | Annualized Return (%)
 | Annualized StdDev (%)
 | [NAME]
D | Annualized Return (%)
 | Annualized StdDev (%)
 | [NAME]
5-Year
 |  | Style 1 |  | Style 2 |  | Style 3 |  | Style 4 |  | Style 5
 |  | F | Q | F | Q | F | Q | F | Q | F | Q
A | Annualized Return (%)
 | Annualized StdDev (%)
 | [NAME]
B | Annualized Return (%)
 | Annualized StdDev (%)
 | [NAME]
C | Annualized Return (%)
 | Annualized StdDev (%)
 | [NAME]
D | Annualized Return (%)
 | Annualized StdDev (%)
 | [NAME]
7-Year
 |  | Style 1 |  | Style 2 |  | Style 3 |  | Style 4 |  | Style 5
 |  | F | Q | F | Q | F | Q | F | Q | F | Q
A | Annualized Return (%)
 | Annualized StdDev (%)
 | [NAME]
B | Annualized Return (%)
 | Annualized StdDev (%)
 | [NAME]
C | Annualized Return (%)
 | Annualized StdDev (%)
 | [NAME]
D | Annualized Return (%)
 | Annualized StdDev (%)
 | [NAME]
10-Year
 |  | Style 1 |  | Style 2 |  | Style 3 |  | Style 4 |  | Style 5
 |  | F | Q | F | Q | F | Q | F | Q | F | Q
A | Annualized Return (%)
 | Annualized StdDev (%)
 | [NAME]
B | Annualized Return (%)
 | Annualized StdDev (%)
 | [NAME]
C | Annualized Return (%)
 | Annualized StdDev (%)
 | [NAME]
D | Annualized Return (%)
 | Annualized StdDev (%)
 | [NAME]
Spreadsheet: 471903d1469274293-searching-and-listing-out-information-final-and-functional
Sheet: Sheet2

emp id & boat | order | emp. Id | amount | boats | state |  | emp. Id | 151
 | 1001 | 151 | 150 | st. dream | tx |  | boat | st. dream
 | 1002 | 234 | 175 | hi | ca |  | nth | amount
 | 1003 | 162 | 100 | hi | tn |  | 1
 | 1004 | 151 | 125 | st. dream | tx |  | 2
 |  |  |  |  |  |  | ids = A7:A10
 |  |  |  |  |  |  | amts = D7:D10
 |  |  |  |  |  |  | id = I6
 |  |  |  |  |  |  | bt = I7
 |  |  |  |  |  |  | bts = E7:E10
Spreadsheet: 287379d1388770739-show-table-data-in-printable-form-forum-sample2
Sheet: Client3

Client3 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013
cash | 100 | 100 | 100 | 100 | 100 | 100
current assets | 200 | 200 | 200 | 200 | 200 | 200
total assets | 500 | 500 | 500 | 500 | 500 | 500
current liabilities | 200 | 200 | 200 | 200 | 200 | 200
total liabilities | 220 | 220 | 220 | 220 | 220 | 220
Spreadsheet: 485731d1477033448-how-to-copy-3-columns-data-into-one-on-another-sheet-unpivot-using-power-query
Sheet: Sheet1

Driver ID | Driver Name | Bus Number | School Name |  | # | DriverName | BusNumber | Value
1 | [NAME] | [NAME] | [NAME] |  | 1 | Mark | B0026858 | AlJood
1 | [NAME] | [NAME] | Saria |  | 2 | [NAME] | [NAME] | [NAME]
2 | [NAME] | B0026858 | AlJood |  | 2 | [NAME] | [NAME] | Sariya
3 | [NAME] | B0009429 | Sosan |  | 3 | [NAME] | B0009429 | Sosan
3 | [NAME] | B0009429 | AlJood |  | 3 | [NAME] | B0009429 | AlJood
4 | [NAME] | B0021162 | Taqwa |  | 4 | [NAME] | B0021162 | Taqwa
4 | [NAME] | B0021162 | [NAME] |  | 4 | [NAME] | B0021162 | [NAME]
5 | Symonds | B0015512 | Sosan |  | 5 | Symonds | B0015512 | Sosan
Spreadsheet: john_griffith__15766__10_18_01GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | [NAME] | 57 | 275 | 375 | 40.8 | 55.7 | 1.73 | 2001-10-18 11:02:00
 | [NAME] | 58 | 610 | 710 | 40 | 46.6 | 1.58 | 2001-10-18 11:02:00
 | HU F2 | 59 | 810 | 910 | 39.9 | 44.8 | 1.57 | 2001-10-18 11:02:00
 | HU G2 | 60 | 970 | 1070 | 38.8 | 42.8 | 1.54 | 2001-10-18 11:02:00
 | [NAME] | 61 | 1075 | 1175 | 37.6 | 41.1 | 1.51 | 2001-10-18 11:02:00
 | [NAME] | 67 | 1275 | 1375 | 37 | 39.9 | 1.62 | 2001-10-18 11:02:00
 | [NAME] | 68 | 1370 | 1470 | 36 | 38.6 | 1.59 | 2001-10-18 11:02:00
 | [NAME] | 68 | 1425 | 1525 | 34.6 | 37.1 | 1.53 | 2001-10-18 11:02:00
 | HU N2 | 67 | 1470 | 1570 | 34.3 | 36.6 | 1.49 | 2001-10-18 11:02:00
 | [NAME] |  |  |  | 28.9 | 34.2 | 1.39 | 2001-10-04 14:29:00
 | HU U2 |  |  |  |  |  | 0.05 | 2001-09-06 10:39:00
 | [NAME] |  |  |  |  |  | 1.26 | 2001-08-20 15:44:00
 | [NAME]
 | [NAME]
 | HU F3 |  |  |  |  |  | 0.56 | 2001-07-19 17:15:00
 | [NAME]