tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: richard_shapiro__32125__TRAssumptions&SIRESERatesCase
Sheet: RateCaseKeyRatios

TRSA Rate Case - $80MM Bond*
Key Financial Indicators
US$[NAME] |  |  |  | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010
Debt |  |  |  | 0.3421796725540943 | 0.3759709758114915 | 0.4143308496843298 | 0.4281328829036345 | 0.423146345252916 | 0.39913953982699 | 0.3705374175628712 | 0.3558917336704536 | 0.3377416061516914 | 0.3160861269300438
Equity |  |  |  | 0.6578203274459057 | 0.6240290241885085 | 0.5856691503156702 | 0.5718671170963655 | 0.576853654747084 | 0.6008604601730101 | 0.6294625824371287 | 0.6441082663295463 | 0.6622583938483086 | 0.6839138730699561
New Debt |  |  |  | 90.477 | 48.62251917877279 | 62.94323891508662 | 56.43986308281887 | 36.66702131694161 | 17.11953298713432 | 17.48964115019822 | 17.86815138178814 | 18.25526005195675 | 18.65116819555868
Cash Before Dividends |  |  |  | 22.0216086026875 | 59.65880986003678 | 74.29336946529105 | 88.88839947244611 | 116.8255994327624 | 134.9165388209958 | 125.4995058675388 | 125.4541983518449 | 123.2929516526049 | 119.6246435033001
Debt Service |  |  |  | 45.12323713971693 | 35.06020757945273 | 41.68339631168146 | 69.69509224702165 | 72.37799267390851 | 72.46337846460709 | 71.28564427983545 | 51.05922765481258 | 51.7893160640316 | 52.41129362806414
DCR |  |  |  | 1.294331973124326 | 3.095964354716156 | 3.25980294904989 | 2.194704338142019 | 2.615100965347222 | 2.96951751206173 | 2.89604100911641 | 4.115499316271943 | 4.058389595240129 | 3.958226318128958
DSRA & Min Cash Balance |  |  |  | 11.25762009609276 | 15.90921686603029 | 31.17039564050552 | 34.99902697039114 | 36.59442331810359 | 36.12191639138256 | 26.12171702356389 | 26.60522645809937 | 27.03382156249115 | 27.40635426618055
Dividends & Cap Reductions |  |  |  | 10.76398850659474 | 43.74959299400649 | 43.12297382478553 | 53.88937250205498 | 80.23117611465877 | 98.79462242961324 | 99.37778884397491 | 98.84897189374556 | 96.25913009011371 | 92.21828923711959
EBITDA |  |  |  | 47.14682846471391 | 92.63593606890446 | 104.7092625827289 | 117.9610943313554 | 152.6813351933286 | 179.0593549424249 | 180.3244321721241 | 183.5289900446552 | 183.147399896377 | 180.0494075396072
EBITDA/Interest |  |  |  | 3.936533624702082 | 5.153172995298906 | 4.865783430413378 | 4.725444000842575 | 5.797283613313211 | 7.011849829117983 | 7.962401356196441 | 8.881748512427494 | 9.340974522109995 | 9.7835205557893
Debt/EBITDA |  |  |  | 4.943110864274212 | 2.855276339105886 | 2.933873650179102 | 2.703463241872216 | 2.027236750856155 | 1.562085639199559 | 1.378343643379387 | 1.286017913573945 | 1.212653832608738 | 1.148227083550391
ROE |  |  |  | 0.04928427427436319 | 0.07911949677608951 | 0.08831715130588176 | 0.1070845357646712 | 0.1806325293875141 | 0.232520981096663 | 0.2381211076299532 | 0.2429527738172805 | 0.240163599661003 | 0.2325934566658639
NIAT |  |  |  | 22.08077352358716 | 34.73454603276065 | 38.35099516818685 | 45.61446229709982 | 76.21868254199549 | 97.90680443628409 | 100.5420703207882 | 103.7802055999752 | 104.5894050661401 | 104.043021138622
*Financing Assumption: Borrow for Capex
Spreadsheet: 785525d1656476366-update-wages-in-the-same-colum-help-to-increase-pay
Sheet: Sheet2

Pay | plus 3%
24.96
12.48
11.23
12.48
24.96
24.96
11.23
76000
11.23
72000
11.23
26.67
24.96
24.96
24.96
74000
26.5
70000
24.96
24.96
24.96
38625
145000
11.23
85000
24.96
100000
24.96
24.96
Spreadsheet: 836800d1689663542-filter-birthdays-onto-dynamic-calendar-calendar-birthdays-aligw
Sheet: CURRENT TRST DSK ACCTS

 | Name |  |  |  |  |  |  |  | CLIENTS DOB | CLIENTS AGE | BONUS INFO | INFO DATE
 | PERSON A |  |  |  |  |  |  |  | 1977-07-20 00:00:00 |  | aaaaaaaaa | 2023-07-20 00:00:00
 | PERSON B |  |  |  |  |  |  |  | 1982-07-20 00:00:00 |  | bbbbbbbbb | 2023-06-24 00:00:00
 | PERSON C |  |  |  |  |  |  |  | 1966-06-25 00:00:00 |  | ccccccccc | 2023-05-12 00:00:00
 | PERSON D |  |  |  |  |  |  |  | 1971-11-28 00:00:00 |  | ddddddddd | 2023-05-05 00:00:00
 | PERSON E |  |  |  |  |  |  |  | 1955-07-11 00:00:00 |  | eeeeeeeee | 2023-12-15 00:00:00
Spreadsheet: 885282d1734744396-use-the-other-formula-instead-of-vlookup-formula-file-a-vehile-ecel-help-forum-2-supervisorptcl-
Sheet: data

date | epi# | name | design | slip no. | date | date end | start time | end time | type | reg# | make | capacity | start reading | end reading | Total | PLACE | PURPOSE
2024-11-12 00:00:00 | 0001-01 | Mr.[NAME] | Director |  | 12.11.2024 |  | 11:05:00 |  | Van | ABC-1234 | [NAME] | 800cc | 6800 | 6810 |  | Godown | Site visit
2024-11-11 00:00:00 | 0001-10 | Mr.[NAME] | Manager |  | 11.11.2024 |  | 11:40:00 | 16:40:00 | Toyota [NAME] | LED-8556 | Toyota | 3000CC | 115056 | 115080 |  | Factory | Check the material
Spreadsheet: 4ffabdeb-809f-45ff-86b8-92fc9f2b18ac
Sheet: Sheet1

Link | Author(s) | Title | Year | Description | Department | Corporate Author
http://www.oit.edu/Libraries/Senior_Projects/reitmeier_Mechanical_Building.pdf | Beede, [NAME]; [NAME], [NAME] | Design of a photovoltaic system on the Reitmeier Mechanical Building | 2009 |  | MET | Reitmeier
http://www.oit.edu/Libraries/Senior_Projects/active_solar_concentrator_pt1.pdf | Clough, [NAME]; [NAME], Jared; Grecu, [NAME] | Active Solar Concentrator | 2009 |  | MET |  | http://www.oit.edu/Libraries/Senior_Projects/active_solar_concentrator_pt2.pdf
http://www.oit.edu/Libraries/Senior_Projects/Wilsonville_Public_Transportation_Analysis.pdf | Dunn, [NAME]; [NAME], [NAME]; Szenasi, Tatiana | Oregon Institute of Technology Wilsonville Public Transportation Analysis | 2012 | This report focuses on the transportation options that are currently available for transportation to the new OIT campus in Wilsonville. | OM | Tri-Met, Smart, Zimride
http://www.oit.edu/Libraries/Senior_Projects/OIT_PGE_DDHS_monitoringsystem.pdf | Placencia, April | A Senior Project Proposal for the Design and Implementation of a Monitoring System for a Combined Installation at David Douglas High SchoolPhotovoltaic and Wind Power | 2009 |  | REE
http://www.oit.edu/Libraries/Senior_Projects/Weresch_Senior_Project_Report.pdf | Weresch, [NAME] | Design and Development of a Mobile Medication Tracker | 2011 |  | IT
http://www.oit.edu/Libraries/Senior_Projects/evaluation_of_the_feasibility_of_virtual_sensor_networks_for_transmission_system_sensing.pdf | Howard, Bradley | Evaluation of the feasibility of virtual sensor networks for Transmission system sensing | 2012 |  | REE
http://www.oit.edu/Libraries/Senior_Projects/2012-10-02_-_Senior_Project_Documentation_-_Paul_Louthan_-_Draft_51_-_Final_Draft_with_Cover_Page.pdf | [NAME], [NAME] | A Systems Analysis and Upgrade of a Small Business eCommerce Website | 2012 |  | IT
Spreadsheet: 871784d1718200771-count-unique-number-of-years-where-the-amount-is-greater-than-1-countif-over-zero-aligw
Sheet: Sheet1

account no | number of years | Amount
12345 | 1 | 1
12346 | 2 | 2
12347 | 3
12348 | 4 | 4
12349 | 1 | 5
14582 | 2 | 6
36589 | 5 | 7
answer should be
1 | 2 |  | AliGW: |  | 2
2 | 1 |  |  | 2 | 2
3 | 0 |  |  | 3 | 0
4 | 1 |  |  | 4 | 1
5 | 1 |  |  | 5 | 1
Spreadsheet: 840636d1692881098-matrix-lookup-probably-as-simple-as-my-previous-question-test-example2
Sheet: Konfigs

 | Probalility level | Kolumn1 | Kolumn2 | Kolumn3
 |  | 0 | 0.099 | Very low
 |  | 0.1 | 0.99 | Low
 |  | 1 | 9.99 | Moderate
 |  | 10 | 99 | High
 |  | 100 |  | Very high
 | Anpassat, se motivering
 | Konsekvensnivå | Kolumn1 | Kolumn2 | Kolumn3
 |  | 0 | 99 | negligible
 |  | 100 | 999 | Moderate
 |  | 1000 | 4999 | Serious
 |  | 5000 |  | Very Serious
 | Anpassat, se motivering
 | Kolumn1 | Very low | Low | Moderate | High | Very high
 | Very serious | 4 | 5 | 6 | 7 | 8
 | Serious | 3 | 4 | 5 | 6 | 7
 | Moderate | 2 | 3 | 4 | 5 | 6
 | negligible | 1 | 2 | 3 | 4 | 5
Spreadsheet: 728236d1618385542-nth-non-blank-cell-value-smaller-than-non-blank-values
Sheet: Data

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 2 | 17 | 18 | 19
15 | 210 | 12 | 4 | 8 | 14 | 2 | 8 | 9 | 10 | 2 | 12 | 13 | 14 | 5 | 4 | 3 | 18 | 19
1st non blank with value smaller than 10 |  |  |  |  |  |  |  |  | ?
2nd non blank smaller than 10 |  |  |  |  |  |  |  |  | ?
1st non blank smaller than 20 |  |  |  |  |  |  |  |  | ?
1st non blank between 15 and 20? |  |  |  |  |  |  |  |  | ?
Spreadsheet: 57834d1258042955-vlookup-with-multiple-rows-test-data
Sheet: AccCode

Acct Code | Amount
ADESS | 20356
ACEDG | 871.58
ALNDL | 3500.79
ALDOS | 8595
BILLC | 20847.91
BCKRS | 13139
[NAME] | 2086.4
BRADD | 7585.46
BRUJU | 4864.06
[NAME] | 2900.62
BUNGA | 1905.53
BURRO | 4542.96
CABAN | 3700.38
CAVEN | 4252.68
CHAND | 62.97
CIR46 | 10671.25
CRLTN | 80
DEANO | 3280.47
ENDLE | 3635
[NAME] | 15339.92
EVOLU | 9567.05
GASOL | 7646.33
GEORGE | 7375.77
GIANN | 500
GOODI | 14525.17
HRLDS | 8057.38
HORNY | 797
IGUAN | 9933.38
JCHAR | 12507.74
JORDA | 2416.05
J.THE | 3011.59
KANSA | 896.63
KHAKI | 4724.11
MODER | 1255
LKCNY | 5164.75
MANCI | 1218.34
MENSC | 1976.46
MLAWR | 249.16
NRTND | 2309.69
NTRLT | 12038.27
PALPA | 3934.71
PRKMU | 1478.55
RESOR | 2905.66
[NAME] | 205.23
STRTN | 1510.34
TIVEC | 2206.98
SIRVA | 4359.09
STVEG | 1327.78
WAYNE | 10029.81
TOTAL | 266345.9999999999
Spreadsheet: 39759d1238038485-how-to-look-up-value-in-pivot-table-using-row-and-columns-josh-budget
Sheet: Receipts

Category | Date | Month | Year | Amount | Description
Groceries | 2009-03-18 00:00:00 |  |  | 45 | Schnucks
Fun | 2009-03-22 00:00:00 |  |  | 22
Groceries | 2009-03-22 00:00:00 |  |  | 50 | TJs
Insurance | 2009-03-25 00:00:00 |  |  | 75 | Car payment
Restaurant | 2009-03-25 00:00:00 |  |  | 30
Fun | 2009-04-02 00:00:00 |  |  | 10 | Bought 2 books at B%N
Fun | 2009-04-05 00:00:00 |  |  | 20 | Went out to bars.
Groceries | 2009-04-06 00:00:00 |  |  | 45
Restaurant | 2009-04-22 00:00:00 |  |  | 25 | French Bistro
Restaurant | 2009-04-24 00:00:00 |  |  | 25 | Another fancy meal
Rent | 2009-05-01 00:00:00 |  |  | 1000
Spreadsheet: 791439d1660336450-xlookup-find-sub-categories-and-label-with-main-category-in-new-column-excel-forum-example
Sheet: Sheet1

Date | Description | Institution | Account | Category | Main Category | Is Hidden | Is Pending | Amount
2022-07-19 00:00:00 | APLPAY |  |  | Auto Service |  | No | No | -10
2022-07-19 00:00:00 | DELTA AIR LINES ATLANTA |  |  | Air Travel |  | No | No | -11.2
2022-07-19 00:00:00 | [NAME] |  |  | Restaurants/Dining |  | No | No | -74.03
2022-07-19 00:00:00 | SPEEDWAY |  |  | Gas & Fuel |  | No | No | -38.66
2022-07-19 00:00:00 | UBER TRIP SAN FRANCISCO CA |  |  | Public Transport |  | No | No | -33.56
2022-07-19 00:00:00 | GREENLIGHT DES APP ID GREENLIGHT LONG CO WEB |  |  | Auto Service |  | No | No | -10
2022-07-18 00:00:00 | VENMO DES PAYMENT LONG CO WEB |  |  | Cash/ATM |  | No | No | -100
2022-07-18 00:00:00 | CHECKCARD APPLE.COM BILL CA RECURRING |  |  | Electronics & Software |  | No | No | -0.99
2022-07-18 00:00:00 | MICROSOFT XBOX MSBILL.INFO |  |  | Electronics & Software |  | No | No | -1.08
2022-07-17 00:00:00 | STAGE HOUSE TAVERN SCOTCH PLAIN |  |  | Restaurants/Dining |  | No | No | -171.6
Spreadsheet: 729136d1618927027-conditional-formatting-highlight-date-that-has-text-sample-v2
Sheet: Sheet1

# | Name | Exp | Notes on conditional formatting
1675-0519 | Name 10 | n/a | not red
1648-0119 | Name 12 | 2021-06-01 00:00:00 | not red
2021-0221 | Name 1 | 2020-10-15 00:00:00 | should be red
1526-0316 | Name 78 | 10/15/2020-test message | should be red
1991-0720 | Name 0865 | 2020-11-01 00:00:00 | should be red
2034-0721 | Name 293 | 5/1/2021-test message 1; 10/15/2020-test message 2 | should be red
2034-0722 | Name 294 | 5/1/21-test message 1; 10/15/20-test message 3 | should be red
2034-0723 | Name 295 | 12/31/21-make sure blah blah | not red
2034-0724 | Name 296 | 2/1/2021-MUR-235S-20\section K | should be red
2034-0725 | Name 297 | 4/22/21-wc; 11/13/20-auto; 4/3/22-gen | should be red
2034-0726 | Name 298 | 4/22/21-wc; 11/13/21-auto; 4/3/22-gen | not red
2034-0727 | Name 299 | 9/1/2021 (garage keep/liab = auto + general) | not red
2034-0728 | Name 300 | 9/1/2020 (garage keep = test + general) | should be red
2034-0729 | Name 301 | 9/1/2021 (garage keep = test + general); 10/1/22-test blah | not red
2034-0730 | Name 302 | 9/1/20 (garage keep = test + general); 10/1/22-test blah | should be red
Spreadsheet: 330473d1404757677-index-match-formula-for-compiling-data-sample-survey-1-
Sheet: Day 3

 |  |  | Total Participants: | 14
Date | Facilitator(s): |  | Evaluations Received: | 14
 | Instructor 1 |  | Topics Covered:
Trainer Feedback
Question | [NAME] | [NAME] | [NAME] | Disagree Strongly | n/a
All of my questions were answered or documented for followup | 14 | 0 | 0 | 0 | 0
The speaker presented the material at a pace that was appropriate | 14 | 0 | 0 | 0 | 0
The speaker was confident in the delivery of the subject matter | 14 | 0 | 0 | 0 | 0
The speaker demonstrated a good understanding of the material | 14 | 0 | 0 | 0 | 0
Participation and interaction were encouraged | 11 | 3 | 0 | 0 | 0
Course Content Feedback
Question | [NAME] | [NAME] | [NAME] | Disagree Strongly | n/a
The training aids used assisted in my learning | 14 | 0 | 0 | 0 | 0
I will be able to apply the skills/information to my work | 8 | 6 | 0 | 0 | 0
The material was the right level of complexity for my background | 11 | 3 | 0 | 0 | 0
The content was organized and easy to follow | 14 | 0 | 0 | 0 | 0
The time allotted for training was sufficient | 14 | 0 | 0 | 0 | 0
 | Yes | No | No Answer
Would you recommend this presentation to your co-workers? | 13 | 0 | 1
Additional Comments
Spreadsheet: 764795d1643010173-1-how-to-create-a-list-based-on-user-input-2-previous-values-based-on-the-last-occurance-questions-ans
Sheet: Q1

Name | Profit | Most profitable List | Total Profit |  | USER INPUT: | 8 | PLEASE ENTER A VALUE TO KNOW THE MOST PROFITABLE NAMES
ABC | 600
RST | 400
XYZ | 300
ABC | -50
MNO | 200
RST | 600 |  |  |  | [NAME] needed for G1 such that:
QWE | 150 |  |  |  | if user input is, let's say, 5, then list of top 5 profitable names should appear in Col C along with their respective total profit in Col D
RST | -150 |  |  |  | but if user input is, let's say 7, then top 7 names along with their total profits to appear in Col C & D
LKJ | 300 |  |  |  | The list shd appear such that most profitable name shd be on the top (decending profit)
DFG | -350
UYT | 400
HGY | 100
ZXC | 200
BVC | 50
XYZ | 800
ABC | 200
 |  | List is more than 8 because there are 2 companies with profit 600 and 400
Spreadsheet: 546383d1510018761-multiple-budget-files-summary-budget-test
Sheet: Budget B

Budget B
Line Item | Amount | Budget Code 1 | Budget Code 2 | Budget Code 3
Line Item 1 | 500 | 250 | 100 | 150
Line Item 2 | 1000 |  | 1000
Line Item 3 | 750 | 250 |  | 500
Total
Spreadsheet: 96072d1295535911-formula-to-calculate-money-due-order-book
Sheet: Grundy Street

WEEK ENDING | AMOUNT
 | 10000
 | 1800
 | 1800
 | 1800
 | 1800
 | 1800
 | 1800
 | 1800
 | 5000
TOTAL
Spreadsheet: 8f7a91e2-8c80-4139-bd4a-e408fc16076c
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
MTBPZ | Test | MTBPZ | Mycobacterium tuberculosis Complex, Pyrazinamide Resistance by pncA DNA Sequencing | Mtb PZA Resistance, pncA Sequencing | DNA Sequencing |  |  |  |  |  | [NAME]: Middlebrook 7H10 agar slant [NAME] Isolate Collection Instructions: 1. Organism must be in pure culture, actively growing. 2. Place specimen in a large infectious container (Supply T146) and label as an etiologic agent.  Additional Information: 1. Specimen source and suspected organism identification are required. 2. See Infectious Specimen Shipping Guidelines in Special Instructions for shipping information. |  | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	Agar plate | Pyrazinamide resistance not detected | 1 day per week, Varies | 7-14 days | 21 days | 1 | 87153 |  |  |  |  | Rochester
MTBPZ | [NAME] | VARIES | Varies |  |  |  | Ambient
MTBPZ | Order Question | [NAME] | [NAME]) and Organism Identification (Required unless concurrent identification test is ordered) |  | Plain Text
MTBPZ | Result | MTBPZ | Mtb PZA Resistance, pncA Sequencing | Mtb PZA Resistance, pncA Sequencing | Alphanumeric |  |  |  |  | mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 875156d1721731745-sum-column-data-in-arrays-from-multiple-sheets-ef1650_sum_multi_sheet
Sheet: 3

151-26 | 150-66 | 150-74 | 153-11 | 150-19 | 153-14 | 152-16 | 153-20 | 153-19 | 152-14
56 | 333 | 60 | 86 | 572 | 173 | 670 | 209 | 274 | 975
280 | 424 | 152 | 99 | 530 | 619 | 33 | 896 | 840 | 525
165 | 149 | 571 | 709 | 543 | 673 | 541 | 680 | 36 | 201
408 | 756 | 829 | 243 | 820 | 666 | 265 | 874 | 373 | 613
808 | 6 | 898 | 947 | 398 | 968 | 84 | 978 | 871 | 249
452 | 300 | 473 | 926 | 849 | 114 | 632 | 307 | 229 | 54
37 | 540 | 157 | 97 | 30 | 141 | 629 | 914 | 617 | 365
263 | 525 | 389 | 208 | 474 | 99 | 517 | 972 | 392 | 585
243 | 284 | 677 | 497 | 629 | 245 | 201 | 494 | 381 | 444
255 | 659 | 737 | 88 | 676 | 693 | 71 | 808 | 8 | 493
263 | 718 | 819 | 621 | 9 | 39 | 909 | 516 | 277 | 471
464 | 70 | 148 | 912 | 147 | 527 | 498 | 398 | 620 | 583
37 | 66 | 414 | 557 | 911 | 139 | 165 | 957 | 158 | 970
772 | 590 | 561 | 743 | 799 | 135 | 275 | 58 | 81 | 946
968 | 697 | 763 | 575 | 986 | 496 | 27 | 439 | 205 | 280
104 | 725 | 405 | 746 | 254 | 70 | 436 | 813 | 576 | 355
262 | 804 | 494 | 626 | 987 | 35 | 792 | 839 | 282 | 67
Spreadsheet: 1e6cce0b-2348-4966-bb3f-8a6a81c01091
Sheet: Customers2

Contact Name | Address | City | Postal Code | Country | Phone | # | T/F
Christina Berglund | Berguvsvägen  8 | Luleå | S-958 22 | Sweden | 0921-12 34 65
Hanna Moos | [NAME]. 57 | Mannheim | 68306 | Germany | 0621-08460
[NAME] | Mehrheimerstr. 369 | Köln | 50739 | Germany | [PHONE]
[NAME] | [NAME]. 57 | Berlin | 12209 | Germany | [PHONE]
[NAME] | Av. del Libertador 900 | [NAME] | 1010 | Argentina | (1) 123-5555
[NAME] | 120 [NAME]. | London | WA1 1DP | UK | (171) 555-7788
[NAME] | 265, blvd. [NAME] | Paris | 75012 | France | (1) 42.34.22.66
[NAME] | 120 [NAME]. | London | WA1 1DP | UK | (171) 555-7788
[NAME] | Mataderos  2312 | México D.F. | 5023 | Mexico | (5) 555-3932
[NAME] | [NAME]. 57 | Berlin | 12209 | Germany | [PHONE]
Isabel [NAME] | Estrada da [NAME] 58 | [NAME] | 1756 | Portugal | (1) 356-5634
[NAME] | Calle Dr. [NAME] 321 | México D.F. | 5033 | Mexico | (5) 552-3745
[NAME] | 24, place [NAME] | Strasbourg | 67000 | France | 88.60.15.31
[NAME] | 120 [NAME]. | London | WA1 1DP | UK | (171) 555-7788
[NAME] | Taucherstraße 10 | Cunewalde | 1307 | Germany | 0372-035188
Georg Pipps | Geislweg 14 | [NAME] | 5020 | Austria | 6562-9722
Hanna Moos | [NAME]. 57 | Mannheim | 68306 | Germany | 0621-08460
[NAME] | Mehrheimerstr. 369 | Köln | 50739 | Germany | [PHONE]
Spreadsheet: 693341d1598931155-adding-variance-to-search-with-iferror-sample
Sheet: גיליון1

 | Values to search | Chart | Values in chart | Values not in chart |  | [NAME]
 | 33.78229944687642 | 33.78229944687642 |  |  |  | 2
 | 31.90018833510521 | 31.90018833510521
 | 30.12293516062815 | 30.12293516062815
 | 42 | 43
 | 26.85996032088654 | 26.85996032088654
 | 25.36351305088436 | 25.36351305088436
 | 23.95043725295974 | 23.95043725295974
 | 22.61608805756349 | 22.61608805756349
 | 36 | 35
 | 20.16626947542 | 20.16626947542
 | 19.04274738 | 19.04274738
 | 17.98182 | 17.98182
 | 16.98 | 16.98
 | 16.03399433427762 | 16.03399433427762
 | 25 | 15.14069342235847
 | 14.2971609276284 | 14.2971609276284
 | 13.50062410540925 | 13.50062410540925
 | 12.74846468877172 | 12.74846468877172
 | 19 | 12.03821028212627
 | 11.36752623430243 | 11.36752623430243
 | 10.73420796440267 | 10.73420796440267
 | 10.13617371520555 | 10.13617371520555
 | 9.571457710297969 | 9.571457710297969
 | 9.038203692443785 | 9.038203692443785
Spreadsheet: 2a3c00ec-7df0-45fb-b280-58936cecf081
Sheet: Quarterly- Unit Sales Levels 

Quarterly Question: By roughly what percent are your firm's unit sales levels above/below “normal,” if at all?
 | Average percent above/below normal
 | Small firms (1-99 employees) | Mid size firms (100-499 employees) | Large firms (500+ employees) | All  (industry-weighted mean)
2012-09-14 00:00:00 | -0.096 | -0.096 | -0.049 | -0.076
2012-12-14 00:00:00 | -0.103 | -0.111 | -0.021 | -0.077
2013-03-15 00:00:00 | -0.122 | -0.068 | -0.033 | -0.077
2013-06-14 00:00:00 | -0.073 | -0.015 | -0.022 | -0.043
2013-09-13 00:00:00 | -0.074 | -0.066 | -0.025 | -0.05599999999999999
2013-12-09 00:00:00 | -0.086 | -0.022 | -0.038 | -0.048
2014-03-14 00:00:00 | -0.091 | -0.056 | -0.03 | -0.05681521045549931
2014-06-13 00:00:00 | -0.078 | -0.025 | -0.017 | -0.037
Spreadsheet: 54643d1254694144-excel-accounting-help-701934-excel-accounting-help
Sheet: Monthly History

Stock ID | Name | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | Total
[NAME] | 50mm x 35mm Keyring | 992.8000000000003 | 75 | 0 | 378.0000000000001 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1445.8
KR-57x22 | 57mm x 22mm Keyring | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
KR-34S | 34mm Square Keyring | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
KR-34R | 34mm Round Keyring | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
KR-45S | 45mm Square Keyring | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
KR-45R | 45mm Round Keyring | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PG-Heart | Heart Photo Globe | 0 | 6 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18
PG-Snow | Snow Photo Globe | 0 | 7.5 | 345 | 7.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 360
PG-Glitter | Glitter Photo Globe | 0 | 7.5 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 22.5
MUG-Glass-Stein | [NAME] Beer Stein | 0 | 0 | 0 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9
KR-BOB | Black Bottle Opener Keyring | 0 | 0 | 0 | 10.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10.5
DC-90S | 90mm Square Acrylic Drink Coaster | 0 | 0 | 0 | 1198.6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1198.6
MP-DIY | Do It Yourself Mousepad | 0 | 0 | 0 | 639.9000000000001 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 639.9000000000001
MP-Printed | Printed Mousepad | 0 | 0 | 0 | 52.8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 52.8
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 | 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 | 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 | 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 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 699913d1602825395-correcting-index-match-formula-students-receivables-ledger
Sheet: Students Payment History

Waterford Primary School
12 Shephereds Way
[NAME]
Bulawayo
Tel: 879120
 | ST 001
Invoice Date | Invoice Number | Debit | Payment Date | Receipt Number | Invoice Number | Credit | Cumulative Balance
Balance B/d
Current Year
Totals |  |  | Totals
Desired Outcome
 | ST 001
Invoice Date | Invoice Number | Debit | Payment Date | Receipt Number | Invoice Number | Credit | Cumulative Balance
2020-01-01 00:00:00 | 210 | 400
2020-01-10 00:00:00 | 1 | 2000 | 2020-01-12 00:00:00 | 100 | 210 | 300
2020-05-12 00:00:00 | 5 | 2300 | 2020-01-14 00:00:00 | 300 | 1 | 1000
2020-09-09 00:00:00 | 9 | 2500 | 2020-02-01 00:00:00 | 600 | 1 | 1000
Totals |  |  | Totals |  |  |  | 4900