tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 670331d1585835854-index-and-match-using-different-value-index_match
Sheet: Sheet1

Base_Product_Number | YWN | Weeks | Total Sale | 202003
Part1 | 202013 | 1 | 49683.0845 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
Part2 | 202008 | 2 | 27465.493 | 0 | 0 | 0 | 0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Part3 | 202004 | 5 | 20604.969 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Part4 | 202004 | 5 | 20032.1452 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Part5 | 202004 | 5 | 18889.87 | 0 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Part6 | 202005 | 4 | 17772.72 | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Part7 | 202008 | 2 | 17329.877
Part8 | 202004 | 5 | 15707.8386
Part9 | 202004 | 5 | 14385.853
Part10 | 202004 | 5 | 13506.9361
Part11 | 202004 | 5 | 12756.9777
Part12 | 202004 | 5 | 12485.9902
Part13 | 202004 | 5 | 11477.991
Part14 | 202004 | 5 | 11325.8764
Part15 | 202005 | 4 | 10693.148
Part16 | 202005 | 4 | 10190.084
Part17 | 202004 | 5 | 9785.8481
Part18 | 202007 | 1 | 8428.148
Part19 | 202004 | 5 | 7633.509
Part20 | 202004 | 5 | 6015.0814
Part21 | 202008 | 1 | 5773.113000000001
Part22 | 202008 | 2 | 5194.492
Part23 | 202007 | 2 | 4636.6028
Part24 | 202007 | 2 | 4577.0485
Part25 | 202006 | 3 | 4492.23
Part26 | 202007 | 2 | 4035.4831
Part27 | 202009 | 1 | 3725.213
Part28 | 202003 | 6 | 3526.4042
Part29 | 202008 | 1 | 1532.8942
Part30 | 202008 | 1 | 800.2570000000001
Part31 | 202008 | 1 | 646.485
Spreadsheet: 02de5b7c-fb79-4784-b63c-b3409b1aa0e1
Sheet: EPR EBITDA FCF 

Adjusted EBITDA For The Periods Ended June 30,
 | Third Quarters |  |  |  | Nine Months
 |  | #REF! |  |  |  | #REF!
 |  | #REF! |  |  |  | #REF!
 | 2013 |  | 2012 |  | 2013 |  | 2012
GAAP Income from continuing operations | 65.69999999999995 |  | 46.89999999999999 |  | 209.2000000000003 |  | 159.5999999999998
Other (income) expense, net | 25.7 |  | 21.4 |  | 68 |  | 63.39999999999999
Income tax provision | 31.6 |  | 27.2 |  | 93.5 |  | 90.5
Depreciation and amortization | 57.8 |  | 64.1 |  | 175.6 |  | 179.3
Other charges:
Share-based compensation | 10.1 |  | 8.8 |  | 28.7 |  | 25.4
Contingent acquisition-related costs | 19.2 |  | 26 |  | 58.6 |  | 37.8
Impairment | 1.5 |  | 0 |  | 3.1 |  | 0
Adjusted EBITDA | 211.5999999999999 |  | 194.4 |  | 636.7000000000004 |  | 555.9999999999998
Free Cash Flow For The Nine Months Ended June 30,
 |  |  |  |  | 2013 |  | 2012
GAAP net operating cash flows |  |  |  |  | 335.2 |  | 326.9999999999998
Investment in property, plant and equipment |  |  |  |  | -18.7 |  | -35.3
Investment in gaming operations equipment |  |  |  |  | -78.1 |  | -133.2
Investment in intellectual property |  |  |  |  | -0.3 |  | -2.3
Free Cash Flow (before dividends) |  |  |  |  | 238.1 |  | 156.1999999999998
Dividends paid |  |  |  |  | -55.5 |  | -53.5
Free Cash Flow (after dividends) |  |  |  |  | 182.6 |  | 102.6999999999998
We believe that certain non-GAAP financial measures, when presented in conjunction with comparable GAAP (Generally Accepted Accounting Principles) measures, are useful because that information is an appropriate measure for evaluating our operating performance. Non-GAAP information is used to evaluate business performance and management’s effectiveness. These measures should be considered in addition to, not as a substitute for, or superior to, measures of financial performance prepared in accordance with GAAP. Non-GAAP financial measures may not be calculated in the same manner by all companies and therefore may not be comparable.
Spreadsheet: 798360d1664444058-using-multiple-variables-for-a-several-functions-from-a-table-tepeln-z-a-
Sheet: Hárok3

 |  |  |  |  |  |  | A) Tepelné zisky z vnútorných zdrojov |  |  |  |  |  |  |  |  |  |  | B) tepelné zisky od vonkajších zdrojov
 |  |  |  |  |  |  | a1.) [NAME] od ľudí |  |  |  | a2.)produkcia tepla od svietidiel |  | a3;4)produkcia tepla elektromotormi, eletrickými a elektronickými zariadeniami |  |  |  |  | b1.) [NAME] oknami |  |  | b2.) [NAME] stenami a stropmi |  | A) Tepelné zisky z vnútorných zdrojov |  |  |  | B) Tepelné zisky od vonkajších zdrojov |  |  |  | SPOLU
 |  |  |  |  |  |  | [NAME] |  |  |  | pracovisko | svelosť miestnosti | (ks) |  |  |  | (w) | s.p.t. okno | [NAME] | [NAME] | s.p.t. stena | s.p.t. strop | a1.) | a2.) | a3.) | [NAME]) | b1.) |  | b2.)
Č.M. | NÁZOV | PLOCHA | telpota interiéru | šírka vonkajšej steny | šírka okien | [NAME] | muži | [NAME] | [NAME] | aktivita |  |  | chladnička 200l | počítač s monitorom | [NAME] | kávovar | iné |  |  |  |  |  |  |  |  |  | [NAME] | radiácia | stena | strop
L112 | Popisovňa | 10 | 24 | 3.6 | 2.7 | S | 2 |  |  |  |  | [NAME] |  | 2 | 2 |  |  | 1 | [NAME] sklo | žiadny | 0.22 | 0.15
L113 | [NAME], preväzovňa | 19 | 24 | 3.6 | 2.7 | S
L123 | Čajová kuchynka | 3 | 24
L125 | Izba 2L | 18 | 24
L153 | JIS | 74.85 | 24
L155 | JIS BOX | 12.5 | 24
L161 | Centrálny monitoring | 10 | 24
L162 | Prípravovňa | 5 | 24
L163 | Denná miestnosť sestry | 10 | 24
L164 | Úseková sestra | 10 | 24
L167 | Čajová kuchynka | 5.4 | 24
L168 | Čakáreň | 14.5 | 24
L213 | Popisovňa | 15 | 24
L214 | Prípravovňa | 15 | 24
L266 | Izba 1L | 14.31 | 24
L269 | Preväzovňa | 15 | 24
L413 | [NAME] | 19 | 24
L437 | Lekárska miestnosť | 19.29 | 24
L442 | [NAME] miestnosť | 46.84 | 24
L463 | JIS | 43.61 | 24
L568 | JIS | 100 | 24
L572 | Izolačný box | 10 | 24
L672 | JIS BOX | 9.5 | 24
L741 | Primár | 19.25 | 24
L842 | Škola | 22.19 | 24
L843 | Úseková a vrchná sestra | 17.88 | 24
L944 | [NAME] | 67.83 | 24
L949 | Dekontaminačná miestnosť | 8.35 | 24
L953 | Operačná sála | 44.27 | 26
L956 | Popisovňa | 16.79 | 24
L964 | JIS | 59.01 | 24
L977 | [NAME], preväzovňa | 26 | 24
L1008 | Izba 1L izolačka | 15.13 | 24
L1010 | Izba 1L izolačka | 13.6 | 24
L1012 | Denná miestnosť lekári | 9.23 | 24
[NAME] | [NAME], preväzovňa | 18.42 | 24
L1023 | Čajová kuchynka | 3.03 | 24
L1024 | Izba 1L | 19 | 24
L1036 | Izba 2L | 18.6 | 24
L1044 | Seminárna miestnosť | 46.03 | 24
L1045 | Primár | 18.58 | 24
L1049 | Sestra | 19.28 | 24
L1051 | Vyšetrovňa | 9.07 | 24
L1052 | JIS novorodenci | 26.42 | 24
L1054 | JIS BOX | 4.79 | 24
L1064 | JIS | 61.1 | 24
L1066 | JIS BOX | 11.99 | 24
L1072 | Centrálny monitoring | 9.95 | 24
L1073 | Prípravovňa | 4.41 | 24
L1075 | Úseková sestra | 10.1 | 24
L1077 | Izba 1L izolačka | 13.61 | 24
[NAME] | Banka mlieka | 9.93 | 24
[NAME] | Laktačná | 9.06 | 24
L1081 | Čakáreň | 5.35 | 24
Spreadsheet: 870237d1716794005-project-resource-planner-lookup-and-count-sum-formulas-project-resource-plan
Sheet: Summary

 |  |  | 2024-01-23 00:00:00 | 2024-02-23 00:00:00 | 2024-03-23 00:00:00 | 2024-04-23 00:00:00 | 2024-05-23 00:00:00 | 2024-06-23 00:00:00 | 2024-07-23 00:00:00 | 2024-08-23 00:00:00 | 2024-09-23 00:00:00 | 2024-10-23 00:00:00 | 2024-11-23 00:00:00 | 2024-12-23 00:00:00
 |  | Project A | LOOKS IN SHEET 'Allocations' and TOTALS ALL PEOPLE AND THE AMOUNT OF TIME ALLOCATED FOR JANUARY 24 FOR PROJECT A - ANSWER SHOULD BE 170% | LOOKS IN SHEET 'Allocations' and TOTALS ALL PEOPLE AND THE AMOUNT OF TIME ALLOCATED FOR JANUARY 24 FOR PROJECT B | ETC | ETC | ETC | ETC | ETC | ETC | ETC | ETC | ETC | ETC
 |  | Project B | LOOKS IN SHEET 'Allocations' and TOTALS ALL PEOPLE AND THE AMOUNT OF TIME ALLOCATED FOR JANUARY 24 FOR PROJECT B - ANSWER SHOULD BE 65% | LOOKS IN SHEET 'Allocations' and TOTALS ALL PEOPLE AND THE AMOUNT OF TIME ALLOCATED FOR JANUARY 24 FOR PROJECT C | ETC | ETC | ETC | ETC | ETC | ETC | ETC | ETC | ETC | ETC
 |  | Project C | LOOKS IN SHEET 'Allocations' and TOTALS ALL PEOPLE AND THE AMOUNT OF TIME ALLOCATED FOR JANUARY 24 FOR PROJECT C - ANSWER SHOULD BE 25% | LOOKS IN SHEET 'Allocations' and TOTALS ALL PEOPLE AND THE AMOUNT OF TIME ALLOCATED FOR JANUARY 24 FOR PROJECT A | ETC | ETC | ETC | ETC | ETC | ETC | ETC | ETC | ETC | ETC
 |  | Project D | ETC. | ETC. | ETC | ETC | ETC | ETC | ETC | ETC | ETC | ETC | ETC | ETC
 |  | Project E | ETC. | ETC. | ETC | ETC | ETC | ETC | ETC | ETC | ETC | ETC | ETC | ETC
 |  | Project F | ETC. | ETC. | ETC | ETC | ETC | ETC | ETC | ETC | ETC | ETC | ETC | ETC
 |  | Project G | ETC. | ETC. | ETC | ETC | ETC | ETC | ETC | ETC | ETC | ETC | ETC | ETC
 |  | Project H | ETC. | ETC. | ETC | ETC | ETC | ETC | ETC | ETC | ETC | ETC | ETC | ETC
 |  |  |  |  | ETC | ETC | ETC | ETC | ETC | ETC | ETC | ETC | ETC | ETC
 |  | Project A | LOOKS IN SHEET 'Allocations' and TOTALS NUMBER OF PEOPLE ALLOCATED FOR JANUARY 24 FOR PROJECT C - ANSWER SHOULD BE 5
 |  | Project B
 |  | Project C
 |  | Project D | LOOKS IN SHEET 'Allocations' and TOTALS NUMBER OF PEOPLE ALLOCATED FOR JANUARY 24 FOR PROJECT D - ANSWER SHOULD BE 3
 |  | Project E
 |  | Project F
 |  | Project G
 |  | Project H
Spreadsheet: 719302d1613605531-lookup-function-for-reporting-structure-supervisor-report
Sheet: Sample

EEID | Supervisor EID | Employee #
42 |  | 1000
103 | 42 | 1049
112 | 42 | 1178
184 | 42 | 1386
128 | 42 | 1014
183 | 42 | 1501
148 | 42 | 1348
17 | 42 | 1051
39 | 42 | 1179
231 | 42 | 1191
114 | 42 | 1310
181 | 231 | 1373
395 | 114 | 1811
Spreadsheet: 99159d1297888654-vlookup-and-date-query
Sheet: A

 | WEF | 2011-02-12 00:00:00
DCODE | PLACE | RATE
121101 | LONDON | 202
121102 | [NAME] | 204
121103 | DUBAI | 204
121104 | BIJING | 204
121105 | MUMBAI | 204
Spreadsheet: 788302d1658394576-formula-to-get-years-worked-example
Sheet: Sheet1

sl | Name | Birthdate | Job start date | Retirement Date | Remuneration | hours worked |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | years worked
 |  | MM/DD/YYY | MM/DD/YYY | MM/DD/YYY
1 | Mr A | 1965-10-18 00:00:00 | 2021-06-02 00:00:00 |  | 41084.76 | 850
2 | Mr B | 1971-09-26 00:00:00 | 2014-03-03 00:00:00 |  | 10000 | 0
3 | Mr C | 1964-06-02 00:00:00 | 2015-07-29 00:00:00 |  | 28426.7 | 576
4 | Mrs D | 1970-01-14 00:00:00 | 2018-03-13 00:00:00 |  | 68762.15 | 2128
5 | Ms E | 1965-12-21 00:00:00 | 2000-11-20 00:00:00 |  | 58007.56 | 2225
6 | [NAME] | 1985-06-13 00:00:00 | 2019-08-05 00:00:00 |  | 41132.28 | 3152
7 | Mrs G | 1961-04-14 00:00:00 | 2010-09-13 00:00:00 |  | 600 | 0
8 | Mr J | 1983-09-09 00:00:00 | 2019-06-10 00:00:00 |  | 69448.87 | 2209
9 | Mr K | 1962-11-07 00:00:00 | 2015-06-15 00:00:00 |  | 67597.17 | 1338
10 | Mr L | 1994-07-19 00:00:00 | 2021-07-22 00:00:00 |  | 11971.35 | 817.16
Spreadsheet: 783780d1655137528-using-iferror-and-unique-to-create-a-summary-table-2022-06-13-oeldere-benhornsby2021-voucher-tracker2
Sheet: Dashboard

 |  |  | 100
Voucher Tracker |  |  |  | Project Allocation
Issued | Remaining | Ordered |  | W4Y | WW4E | FB | [NAME] | CL/FL | Schools
 |  |  |  | Staff Issuing | Total tickets
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | 0
Spreadsheet: 99252d1297953918-turn-start-end-dates-into-individual-days-dates
Sheet: Sheet1

emp_lastName | sch_fromDateTime | sch_toDateTime | sch_hours |  | MnthEND
ALPHA | 2011-01-31 00:00:00 | 2011-02-04 00:00:00 | 40 |  | 2011-01-01 00:00:00
BRAVO | 2011-03-28 00:00:00 | 2011-04-01 00:00:00 | 55 |  | 2011-04-01 00:00:00
CHARLIE | 2011-01-26 00:00:00 | 2011-01-26 00:00:00 | 8 |  | 2011-03-01 00:00:00
CHARLIE | 2011-01-27 00:00:00 | 2011-01-28 00:00:00 | 16 |  | 2011-04-01 00:00:00
CHARLIE | 2011-02-23 00:00:00 | 2011-02-25 00:00:00 | 24 |  | 2011-06-01 00:00:00
CHARLIE | 2011-02-28 00:00:00 | 2011-03-04 00:00:00 | 20 |  | 2011-07-01 00:00:00
DELTA | 2011-03-28 00:00:00 | 2011-04-01 00:00:00 | 55 |  | 2011-09-01 00:00:00
ECHO | 2011-01-28 00:00:00 | 2011-01-28 00:00:00 | 8 |  | 2011-08-01 00:00:00
FOXTROT | 2011-01-31 00:00:00 | 2011-01-31 00:00:00 | 2 |  | 2011-09-01 00:00:00
GOLF | 2011-01-31 00:00:00 | 2011-01-31 00:00:00 | 2 |  | 2011-10-01 00:00:00
HOTEL | 2011-01-31 00:00:00 | 2011-01-31 00:00:00 | 2 |  | 2011-11-01 00:00:00
INDIA | 2011-01-31 00:00:00 | 2011-01-31 00:00:00 | 2 |  | 2011-12-01 00:00:00
[NAME] | 2011-01-31 00:00:00 | 2011-02-04 00:00:00 | 19 |  | 2012-01-01 00:00:00
[NAME] | 2011-01-31 00:00:00 | 2011-01-31 00:00:00 | 2 |  | 2012-02-01 00:00:00
KILO | 2011-01-31 00:00:00 | 2011-01-31 00:00:00 | 2 |  | 2012-03-01 00:00:00
LIMA | 2011-01-28 00:00:00 | 2011-01-28 00:00:00 | 8 |  | 2012-04-01 00:00:00
LIMA | 2011-02-28 00:00:00 | 2011-03-04 00:00:00 | 20 |  | 2012-06-01 00:00:00
LIMA | 2011-03-25 00:00:00 | 2011-03-25 00:00:00 | 3 |  | 2012-08-01 00:00:00
Spreadsheet: scott_neal__38604__trading track rotations
Sheet: Rotation list

 | Name | Rotation Date | Group | Supervisor |  | Management Team/Interview Team | Training Team
 |  |  |  |  |  | [NAME] | [NAME]
Power |  |  |  |  |  | [NAME] | [NAME]
 | [NAME] | 2001-02-01 00:00:00 | MW-Fundamentals | [NAME] |  | [NAME] | [NAME]
 |  | 2001-04-01 00:00:00 | [NAME] | [NAME] |  | [NAME] | [NAME]
 |  |  |  |  |  | [NAME] | Grigbsy Mike
 | [NAME] | 2001-02-01 00:00:00 | Book Running | [NAME] |  | [NAME] | [NAME]
 |  | 2001-05-01 00:00:00 | Fundamentals | [NAME] |  | Grigbsy Mike | [NAME]
 |  |  |  |  |  | [NAME] | [NAME]
 | [NAME] | 2001-02-01 00:00:00 | Real Time (night) | [NAME] |  | Kitchen Louise | [NAME]
 |  | 2001-08-01 00:00:00 | Book Running | [NAME] |  | [NAME] John | Schwieger Jim
 |  |  |  |  |  | [NAME] | Shively [NAME]
 | [NAME] | 2001-02-01 00:00:00 | Fundamentals | [NAME] |  | [NAME] | [NAME]
 |  | 2001-05-01 00:00:00 | S/E Fundamentals | [NAME][NAME] |  | [NAME]
 |  |  |  |  |  | [NAME]
 | [NAME] | 2001-03-01 00:00:00 | Power Scheduling | [NAME] |  | Schwieger Jim
 |  | 2001-05-01 00:00:00 | EES | [NAME] |  | Shively [NAME]
 |  | 2002-03-01 00:00:00 | Real Time (days) | [NAME] |  | [NAME]
 |  |  |  |  |  | [NAME]
Gas |  |  |  |  |  | [NAME]
 | [NAME] | 2001-03-01 00:00:00 | Book Running | [NAME]
 |  | 2001-09-01 00:00:00 | Noms-Logistics | [NAME]
 | Bilal Bajwa | 2001-01-01 00:00:00 | Book Running | [NAME]
 |  | 2001-07-01 00:00:00 | Fundamentals | [NAME]
 | [NAME] | 2001-02-01 00:00:00 | Mid Market | [NAME]
 |  | 2001-08-01 00:00:00 | Structuring | [NAME]
 | Denver Palchey | 2001-03-01 00:00:00 | Fundamentals | [NAME]
 |  | 2001-09-01 00:00:00 | Structuring | [NAME]
 | [NAME] | 2001-02-01 00:00:00 | East Gas Trading | [NAME]
 | [NAME] | 2001-02-01 00:00:00 | Book Running | [NAME]
 |  | 2001-08-01 00:00:00 | Noms-Logistics | [NAME]
 | [NAME] | 2001-02-01 00:00:00 | Fundamentals | [NAME]
 |  | 2001-08-01 00:00:00 | Book Running | [NAME]
 | [NAME] | 2001-03-01 00:00:00 | Noms-Logistics | [NAME]
 |  | 2001-09-01 00:00:00 | Fundamentals | [NAME]
 | [NAME] | 2001-02-01 00:00:00 | Noms-Logistics | [NAME]
 |  | 2001-08-01 00:00:00 | Fundamentals | [NAME]
Management Team:
Spreadsheet: eric_saibi__9846__100801
Sheet: Gibson City 01 

Owner Name |  | American Energy Generating Company
Station Name |  | Gibson City Merchant Power
Unit Name |  | Gibson City CT 01
NERC Region |  | MAIN
State |  | IL
Fuel Type |  | Natural Gas
Capacity |  | 117 MW
Start Date |  | 2001-10-05 00:00:00
End Date |  | 2001-10-14 00:00:00
Prv. Start Date |  | 2001-10-05 00:00:00
Prv. End Date |  | 2001-10-18 00:00:00
Comments |  | Doing a more detailed CT inspection
SIC |  | 4931
Plant ID |  | 1041668
Unit ID |  | 1013521
Outage ID |  | 17961
Spreadsheet: 137759d1327346742-copy-paste-values-to-the-cell-next-to-a-matched-cell-inventory-sample
Sheet: Analysis

Item Number | 1.16.12 Quantity | 1.23.12 Quantity | Percent Change
#1
#10
#2
#3
#4
#5
#6
#7
#8
#9
0008BW
010-2
011-16
011-3
013-1
013-13
014-12
0143S
015-14
015-5
016-14
016-15
016-15-2
016-M
017-14
Spreadsheet: 0442c9f2-30dc-4cc0-8949-0c2e0acac3ed
Sheet: Discharge Tracking

CMH Discharges | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00
Region 1 | 7 | 9 | 12 | 9 | 5 | 2 | 6 | 8 | 6 | 9 | 5 | 7 | 4 | 8 | 8 | 7
Region 2 | 2 | 3 | 4 | 4 | 1 | 4 | 6 | 1 | 7 | 2 | 4 | 5 | 7 | 1 | 1 | 2
Region 3 | 2 | 11 | 8 | 5 | 9 | 8 | 6 | 13 | 3 | 3 | 10 | 8 | 10 | 6 | 10 | 4
Region 4 | 15 | 5 | 15 | 11 | 14 | 12 | 18 | 11 | 24 | 25 | 21 | 15 | 18 | 14 | 14 | 17
Region 5 | 9 | 7 | 7 | 11 | 11 | 7 | 12 | 8 | 6 | 5 | 11 | 14 | 2 | 12 | 4 | 12
Region 6 | 9 | 6 | 4 | 4 | 6 | 4 | 3 | 9 | 6 | 3 | 7 | 10 | 9 | 5 | 5 | 11
Region 7 | 13 | 14 | 8 | 15 | 15 | 19 | 13 | 15 | 14 | 9 | 5 | 11 | 22 | 20 | 17 | 18
CMH Discharges |  |  |  |  |  |  |  |  |  | 56 | 63 | 70 | 72 | 66 | 59 | 71
AMH Discharges | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00
Region 1 | 35 | 26 | 17 | 32 | 23 | 12 | 20 | 11 | 14 | 13 | 19 | 12 | 18 | 17 | 24 | 22
Region 2 | 20 | 17 | 9 | 24 | 15 | 20 | 28 | 18 | 13 | 16 | 23 | 13 | 16 | 5 | 12 | 8
Region 3 | 15 | 24 | 10 | 16 | 20 | 14 | 13 | 16 | 15 | 18 | 20 | 18 | 13 | 18 | 17 | 51
Region 4 | 18 | 29 | 15 | 21 | 29 | 8 | 20 | 23 | 16 | 19 | 20 | 19 | 18 | 13 | 36 | 13
Region 5 | 18 | 20 | 14 | 19 | 21 | 7 | 14 | 10 | 13 | 14 | 11 | 13 | 9 | 10 | 11 | 15
Region 6 | 16 | 15 | 11 | 11 | 15 | 8 | 10 | 10 | 13 | 15 | 11 | 9 | 13 | 11 | 21 | 11
Region 7 | 32 | 54 | 41 | 28 | 28 | 23 | 18 | 21 | 36 | 34 | 18 | 48 | 41 | 43 | 22 | 46
AMH Discharges |  |  |  |  |  |  |  |  |  | 129 | 122 | 132 | 128 | 117 | 143 | 166
Spreadsheet: 148743d1333545360-grouping-data-in-spreadsheets-example-1
Sheet: Sheet1

Company | Spend | Group
Sony - Translation | 1718
Sony - Accounts | 2185
Sony (IT) | 2262
Sony London | 2224
HP (Finance) | 2467
HP (Translation) | 4838
HP - HR | 3747
HP TI Interpreting | 2425
HP London Division | 1671
BMW (Translation) | 1223
BMW - IT | 4301
BMW community Support | 2599
Spreadsheet: 804209d1667936865-trying-to-add-missing-cases-test1
Sheet: Sheet1

Case number | name1 | [NAME] | open | age | name3 | comment | issue | Check 1 | Check 2 | Check 3 | Check 4 | Check 5 | Check 6 | Check 7
12345678 | andre |  | 2022-10-13 00:00:00 |  | [NAME] | Something | issue |  | x | x |  | x |  | x
12345679 | marc |  | 2022-10-14 00:00:00 |  | Mark | something else | issue |  | x |  |  | x
12345680 | luc |  | 2022-10-15 00:00:00 |  | Mark | something different | issue |  |  | x | x |  | x
32345681 | andre |  | 2022-10-15 00:00:00 |  | Mark | something different | issue |  | x | x |  |  | x
12345682 | andre |  | 2022-10-15 00:00:00 |  | Mark | Something | issue |  |  |  |  |  | x
52345683 | marc |  | 2022-10-18 00:00:00 |  | [NAME] | something else | issue |  |  | x |  |  | x
12345684 | [NAME] |  | 2022-10-18 00:00:00 |  | [NAME] | something different | issue |  |  | x |  |  |  | x
 |  |  |  |  |  | Yellow fields calculated
 |  |  |  |  |  | Filter on I hiding the closed cases
Spreadsheet: 63326d1264233261-dropdown-box-for-selecting-a-category-and-displaying-more-than-1-result-question-20bank-1-
Sheet: Sheet2

Category
Sales Process
Service Excellence
Building Relationships
Personal Career Development
Account Control
Account Enquiry
Account Opening |  |  | Choose category: | Sales Process
Branch Administration
Control |  |  |  | List:
Cash Admin |  |  |  |  | 2 | Applying your product knowledge to customer interactions and generating leads?
Cash Control |  |  |  |  | 3 | Explaining the crucial things to them when they are considering Savings(SIM) Mortgages and pensions
Complaints |  |  |  |  | 47 | Demographics of branch
Coaching |  |  |  |  | 48 | Customer Preview
Improvements |  |  |  |  | 49 | Business/Private/Financial Planning lead Referrals
Assurance |  |  |  |  | 50 | Telephony (Outbound and Inbound Calling)
Insurance |  |  |  |  | 51 | Use of Prompts
IT |  |  |  |  | 52 | Undertaking Personal/Customer Reviews (PSR/CSR)
Loan Account Opening |  |  |  |  | 53 | Prospecting
Managerial
Transactions
Spreadsheet: 150675d1334657407-can-a-vlookup-show-a-value-based-on-if-previous-step-is-x-or-y-order-code-generator_iss2
Sheet: CPS3

G | 1...120 bar or equvalent (S:0.015%/P:0.007%) | 0 | 0
H | 2...300 bar or equvalent (S:0.015%/P:0.006%) | 300 | 250
K | 1...60/10..700 bar or equvalent (S:0.015%/P:0.006%) | 2680 | 1490
L | 1...60/20..1200 bar or equvalent (S:0.015%/P:0.007%) | 3150 | 1980
M | 1...60/20..1400 bar or equvalent (S:0.015%/P:0.007%) | 3350 | 2180
Spreadsheet: 842208d1694293996-filter-named-range-and-other-results-based-on-criteria-filter-named-range-and-other-results-based-on-criteria
Sheet: Tables

 | Month | July |  | August |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April |  | May |  | June
 | Company | Number | Amount | Number | Amount | Number | Amount | Number | Amount | Number | Amount | Number | Amount | Number | Amount | Number | Amount | Number | Amount | Number | Amount | Number | Amount | Number | Amount
 | Silver Leases
 | Streamline Rentals
 | Yogaluxe
 | Total
 | Current Month
 | Company | Number | Amount
 | Total
 | Total Fiscal Year | 2023 - 2024
 | Company | Number | Amount
 |  | 7 | 455
 | Streamline Rentals | 12 | 675
 | Yogaluxe | 2 | 90
 | Total
Spreadsheet: 877798d1724727112-index-match-match-mulitple-criteria-help-index-match-match-required
Sheet: SCHEDULE VIEWER

 | MONTH |  |  |  |  |  |  |  |  |  | August |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SEP
 |  | 2024-08-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tue/15 | Wed/16 | Thu/17 | Sun/20 | Mon/21 | Tue/22 | Wed/23 | Thu/24 | [NAME] | Mon/28 | Tue/29 | Wed/30 | Sat/02 | Sun/03 | [NAME] | Tue/05 | Wed/06 | Sat/09 | Sun/10 | Mon/11 | Tue/12 | Wed/13 | Sat/16 | Sun/17 | [NAME] | Tue/19 | Wed/20 | Sat/23 | Sun/24 | Mon/25 | Tue/26 | [NAME] | Sat/30 | Sun/01 | Mon/02 | Tue/03 | Wed/04 | Sat/07 | Sun/08 | Mon/09 | Tue/10 | Fri/13 | Sat/14 | Sun/15 | Mon/16 | Tue/17 | Fri/20 | Sat/21 | Sun/22 | Mon/23 | Tue/24 | Fri/27 | Sat/28 | Sun/29 | Mon/30 | Tue/31 | Fri/03 | Sat/04 | Sun/05 | Mon/06 | Tue/07 | Fri/10 | Sat/11 | Sun/12 | Mon/13 | Tue/14 | Fri/17 | Sat/18 | Sun/19 | Mon/20 | Thu/23 | Fri/24 | Sat/25 | Sun/26 | [NAME] | Thu/30 | [NAME] | Sat/01 | Sun/02 | Mon/03 | Thu/06 | Fri/07 | Sat/08 | Sun/09 | Mon/10 | Thu/13 | Fri/14 | Sat/15 | Sun/16 | Mon/17 | Thu/20 | Fri/21 | Sat/22 | Sun/23 | Mon/24 | [NAME] | Fri/28 | Sat/01 | Sun/02 | Wed/05 | Thu/06 | Fri/07 | Sat/08 | Sun/09 | Wed/12 | Thu/13 | Fri/14 | Sat/15 | Sun/16 | [NAME] | Thu/20 | Fri/21 | Sat/22 | Sun/23 | Wed/26 | [NAME] | Fri/28 | Sat/29 | Sun/30 | Wed/02 | Thu/03 | [NAME] | Sat/05 | Sun/06 | Wed/09 | Thu/10 | Fri/11 | Sat/12 | Tue/15 | Wed/16 | Thu/17 | Fri/18 | Sat/19 | Tue/22 | Wed/23 | Thu/24 | Fri/25 | Sat/26 | Tue/29 | Wed/30 | Thu/01 | Fri/02 | Sat/03 | Tue/06 | Wed/07 | Thu/08 | Fri/09 | Sat/10 | Tue/13 | Wed/14 | Thu/15 | Fri/16 | Sat/17 | [NAME] | Wed/21 | Thu/22 | Fri/23 | Mon/26 | [NAME] | Wed/28 | Thu/29 | Fri/30 | Mon/02 | Tue/03 | Wed/04 | Thu/05 | Fri/06 | Mon/09 | Tue/10 | Wed/11 | Thu/12 | Fri/13 | Mon/16 | Tue/17 | Wed/18 | Thu/19 | Fri/20 | Mon/23 | Tue/24 | Wed/25 | Thu/26 | Fri/27 | Mon/30 | Tue/01 | Wed/02 | Thu/03 | [NAME]
 | CONS
 | Lead/Ferrite
 | Container
 | PHJ100
 | PH0100
 | TML-BC1
 | TML-CT01
 | TML-CT02
 | TML-CT03
 | TML-DS1
 | TML-DS2
 | TML-DT01
 | TML-DT02
 | TML-DT03
 | TML-E02
 | TML-E03
 | TML-E04
 | TML-EX1
 | TML-FL1
 | TML-FL2
 | TML-GB1
 | TML-GB2
 | TML-HC1
 | TML-HC2
 | TML-R01
 | TML-R02
 | TML-RS1
 | TML-RS2
 | TML-RS3
 | TML-RS4
 | TML-SP1
 | TML-TR1
 | TML-TR2
 | TML-V1
 | Down Time
 | Cost
 | Manning