tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 114962d1310619745-automatically-updating-data-from-one-sheet-to-another-june
Sheet: 1090

Date | Trip Details | Amount | Toll | Other | Party | Payment Yes/N0 | [NAME]
2011-06-01 00:00:00
 | Intersight |  |  |  |  | Advance Received
 | Intersight |  |  |  |  | Advance Received
 | Intersight |  |  |  |  | Advance Received
 | Intersight |  |  |  |  | Advance Received
 | Gujarat Bhai | Yes
 | Gujarat Bhai | Yes
 | Gujarat Bhai | Yes
 | [NAME] | Yes
 | Gateway To India | Yes
 | Gateway To India | Yes
 | Gateway To India | Yes
 | Gateway To India | Yes
 | Intersight (13-22) |  |  |  |  | Advance Received
 | Intersight |  |  |  |  | Advance Received
 | Intersight |  |  |  |  | Advance Received
 | Intersight |  |  |  |  | Advance Received
 | Intersight |  |  |  |  | Advance Received
 | Intersight |  |  |  |  | Advance Received
 | Intersight |  |  |  |  | Advance Received
 | Intersight |  |  |  |  | Advance Received
 | Intersight |  |  |  |  | Advance Received
 | Ramada- Sidha Travels | Yes
 | Interlink
 | Interlink
 | Interlink
 | Interlink
 | Interlink
 | Interlink
 | Interlink
 | Interlink
 | Interlink
 | [NAME]
 | [NAME]
Spreadsheet: 89736d1289483901-conditional-calculations-ops-data
Sheet: Sheet1

resourceName | eventDateTime | Event Type | Reason | Reason (simplified) | Busy vs Ready | Column1
[NAME] | 2010-11-11 10:04:44 | Logged In | None | N/A | Busy
[NAME] | 2010-11-11 10:04:44 | Not Ready | Initial Login State | Initial Login State | Busy
[NAME] | 2010-11-11 11:37:24 | Ready | None | Ready | Ready
[NAME] | 2010-11-11 11:37:42 | Not Ready | Ad Hoc Request | Ad Hoc Request | Busy
[NAME] | 2010-11-11 11:45:06 | Ready | None | Ready | Ready
[NAME] | 2010-11-11 11:45:06 | Reserved (Call Incoming) | None | Inbound Call | Ready
[NAME] | 2010-11-11 11:45:10 | Talking (Inbound Call) | None | Inbound Call | Ready
[NAME] | 2010-11-11 11:47:05 | Not Ready | Ad Hoc Request | Ad Hoc Request | Busy
[NAME] | 2010-11-11 11:59:35 | Not Ready | [NAME] | [NAME] | Busy
[NAME] | 2010-11-11 12:05:39 | Not Ready | Ad Hoc Request | Ad Hoc Request | Busy | 00:06:04
[NAME] | 2010-11-11 12:07:17 | Ready | None | Ready | Ready
[NAME] | 2010-11-11 12:09:20 | Not Ready | [NAME] | [NAME] | Busy | 00:11:57
[NAME] | 2010-11-11 12:21:17 | Ready | None | Ready | Ready
[NAME] | 2010-11-11 12:24:23 | Not Ready | Ad Hoc Request | Ad Hoc Request | Busy
Spreadsheet: 734343d1622118650-coloring-cells-by-conditional-formating-with-fis-testkleur-rijen2-keebellah-
Sheet: vlist

project | Vertrek | Aankomst | begeleider | tijd | weg | wacht | uren | km | land | verkoop | Wacht2 | inkoop | [NAME] | Wacht3 |  | Verschil alles | prijs nl | prijs d | [NAME] <50 | km NL 50-100 | [NAME]500 | [NAME]50 | km d 50-100 | km d 100-500 | km d >500 | Wacht
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42.5 | 1.15 | 150 | 2.8 | 1.8 | 300 | 4.5 | 1.65 | 1.3 | 45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | als J=nl;I:I | als J=nl; K:K | als J=d;I:I | als J=d:K:K | wacht
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totaal
Spreadsheet: 065f18fe-b03c-49c6-b84a-e96cf988c8f5
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
[NAME]
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 20 | 8433 | 8354 | 7813 | 6890
20 - 40 | 12210 | 10482 | 8718 | 7385
40 - 60 | 18784 | 16257 | 14298 | 12388
60 - 80 | 15277 | 16429 | 16356 | 16826
80 und mehr | 4133 | 4439 | 5218 | 5232
Insgesamt | 58837 | 55961 | 52403 | 48721
%
unter 20 | 14.3328177847273 | 14.92825360518933 | 14.90945174894567 | 14.14174585907514
20 - 40 | 20.75224773526862 | 18.73090187809367 | 16.63645211152033 | 15.15773485765891
40 - 60 | 31.92548906300457 | 29.05058880291632 | 27.28469744098621 | 25.42640750395107
60 - 80 | 25.96495402552815 | 29.35794571219242 | 31.21195351411179 | 34.53541593973851
80 und mehr | 7.024491391471353 | 7.932310001608263 | 9.957445184436006 | 10.73869583957636
Insgesamt | 100 | 100 | 100 | 100
Gebietsstand: | 1. Januar 2012
Quelle: | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.
Spreadsheet: 1434a6cc-8a24-477b-98f6-401b6d361ed6
Sheet: Sheet1

What do you need | Who or what can provide the service or information you need | Contact phone  number/email/physical address or web address
Help with paying Utilities
 | Klamath Basin Senior Center  council Low-Income energy assistance | [PHONE]
 | Salvation Army | [PHONE]
 | St. Vincent de Paul | [PHONE]
 | United Christian Ministries | No Phone calls pls  in-take Tuesday 9:30-11am   1745 Main St Klamath Falls
Transportation
 | Public Transportation (Bus) | [PHONE]
 | Dial  A  Ride | [PHONE]
 | Department of human services-Spd medical transports | [PHONE]
 | Rides for disabled  public tranportation | [PHONE]
Food Resources
 | Oregon Family Nutritition | [PHONE]
 | Oregon Adult and Family services | [PHONE]
Employment
 | OIT career services | http://www.oit.edu/career  [PHONE]
 | Work source Oregon | [PHONE]
Housing
 | Rental Assistance | [NAME][PHONE]
 | Rental Assistance | Salvation Arms          [PHONE]
 | Rental Assistance | St. Vicent De Paul         [PHONE]
 | Rental Assistance | Klamath Housing Authority                                [PHONE]
Veterans Resources
Transportation
 | DAV Transports to white city facility | [PHONE]
Employment
 | National Resource Directory | http://www.odva.state.or.us/ODVA/contact_us.shtml
 | possible  Income while atending college | [PHONE]
 | OIT Career Services | http://www.oit.edu/career
Military Records
 | Navy and Marine transcripts (SMART) | https://smart.navy.mil/smart/signOut.do
 | Army Transcripts (AARTS) | http://aarts.army.mil/
 | Air Force Transcripts | http://www.maxwell.af.mil
 | National Personnel Record Center | [PHONE]
Housing
 | Oregon Department of Vetrans Affairs | http://www.odva.state.or.us/ODVA/contact_us.shtml Benefit claims                                         [PHONE]  Home Loans [PHONE]
Vehicle License Plates
 | Veteran's License Plates | Department of Motor Vehicles for  License Plates for Disabled Vets                                                                [PHONE]  or   [PHONE])
VETERANS BENEFITS PHONE NUMBERS
 | Health Care | [PHONE]
 | Education and Training | [PHONE]
 | VA Life Insurance | [PHONE]
 | Office of SGLI | [PHONE]
 | CHAM PVA | [PHONE]
 | Helpline (Agent Orange and Gulf War | [PHONE]
 | Direct Deposit | [PHONE]
 | VA Benefit Regional Office | [PHONE]
 | VA Pension Center | [PHONE]
 | Education Benefits | [PHONE]
 | Department of Finance and Accounting | [PHONE]
VAMedical facilities
 | White City OR. (Medford) | [PHONE]
 | Roseburg VA Medical | [PHONE]
 | Portland OR. | [PHONE] or [PHONE]
 | Grants Pass Vets Center  (Counseling) | [PHONE]
 | Tricare | [PHONE]
 | Civilian Health and Medical Program of the Department of Veterans Affairs CHAMPVA | [PHONE]
 | Kingsley Field Retiree's Office | [PHONE]
If you see any errors and or additions that need to be added please call or see [NAME] [PHONE]  email [EMAIL] or Room 225 in the LRC
Spreadsheet: 741367d1626992613-automation-to-combine-subsequent-cells-in-a-column-with-the-original-record-row-mock-spreadsheet_solved
Sheet: Final

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Ailments
NAME 1 | K9999 | [PHONE] | JAN  1 1986 | JAN 2 1992 | 70 | PTSD | PTSD,DEPRESSION,MIGRAINE HEADACHES,LUNG CANCER
[NAME] 2 | S6666 | (555)555-5555 | JUL 3 1971 | JUL 4  1975 | 80 | HYPERTENSIVE VASCULAR DIS | HYPERTENSIVE VASCULAR DIS,LABYRINTHITIS,POST-TRAUMATIC STRESS DIS
NAME 3 | A7777 | [PHONE] | DEC 1 1965 | DEC 2 1969 | 90 | IMPAIRED HEARING | IMPAIRED HEARING,ARTHRITIS, DEGENERATIVE,FLAT FOOT CONDITION,[NAME] OF KNEE,LOSS OF EYE,PARALYSIS OF EXTERNAL POP,PARALYSIS OF EXTERNAL POP,TINNITUS,LIMITED MOTION OF ANKLE,SCARS,FOOT PAIN
Spreadsheet: 779886d1652175952-need-formula-to-get-min-and-max-dates-startenddates-aligw
Sheet: Sheet1

 |  | Helper cells>>> |  | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00
 | Proj.No. | Labour Division | May-21 | [NAME] | [NAME] | Aug-21 | Sep-21 | Oct-21 | Nov-21 | Dec-21 | Jan-22 | Feb-22 | Mar-22 | Apr-22 | May-22 | Jun-22 | Jul-22 | Aug-22 | Sep-22 | Oct-22 | Nov-22 |  | Proj.No. | Start Date | End Date
 | PRJ01 | Eng |  | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-06-01 00:00:00 | 2021-08-01 00:00:00
 | PRJ01 | H&S |  | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRJ02 | 2021-10-01 00:00:00 | 2022-04-01 00:00:00
 | PRJ01 | Project Management |  | 0.5 | 0.5 | 0.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 2021-10-01 00:00:00 | 2022-02-01 00:00:00
 | PRJ02 | Eng |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | PRJ04 | 2021-10-01 00:00:00 | 2022-08-01 00:00:00
 | PRJ02 | H&S |  |  |  |  |  | 0.4386792452830188 | 0.4245283018867925 | 0.4386792452830188 | 0.4386792452830188 | 0.3962264150943396 | 0.4386792452830188 | 0.4245283018867925 |  |  |  |  |  |  |  |  | PRJ05 | 2021-06-01 00:00:00 | 2021-11-01 00:00:00
 | PRJ02 | Project Management |  |  |  |  |  | 1.462264150943396 | 1.415094339622641 | 1.462264150943396 | 1.462264150943396 | 1.320754716981132 | 1.462264150943396 | 1.415094339622641
 | [NAME] | Eng |  |  |  |  |  | 2.198581560283688 | 2.127659574468085 | 2.198581560283688 | 2.198581560283688 | 1.276595744680851
 | [NAME] | H&S |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
 | [NAME] | Project Management |  |  |  |  |  | 2.638297872340426 | 2.553191489361702 | 2.638297872340426 | 2.638297872340426 | 1.531914893617021
 | PRJ04 | Eng |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | PRJ04 | H&S |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | PRJ04 | Project Management |  |  |  |  |  | 3.886567164179104 | 3.761194029850746 | 3.886567164179104 | 3.886567164179104 | 3.51044776119403 | 3.886567164179104 | 3.761194029850746 | 3.886567164179104 | 3.761194029850746 | 3.886567164179104 | 3.886567164179104
 | PRJ05 | Eng |  | 0.7086614173228345 | 7.322834645669293 | 7.322834645669293 | 7.086614173228348 | 7.322834645669293 | 0.2362204724409449
 | PRJ05 | H&S |  | 0.09448818897637795 | 0.9763779527559056 | 0.9763779527559056 | 0.9448818897637795 | 0.9763779527559056 | 0.03149606299212598
 | PRJ05 | Project Management |  | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 599875d1543343598-summing-numbers-based-on-multiple-conditions-across-a-range-automated-ioc-sheet-desensitized
Sheet: Master

Date | [NAME] |  |  |  | Team 1 | Team 2 | Team 3 | Team 4 | Team 5 | Team 6 | Team 7
 | Sickcall and Med Documentation
 | Infection, Asepsis, & Sterile Techniques
 | Medication Administration
 | Injections
 | Pharmacology
 | Venipuncture
 | EENT Primary Care
 | Respiratory Primary Care
 | Abdominal Primary Care
 | Orthopedic Primary Care
 | Basic Wound Primary Care
 | Skin Disease Primary Care
 | Primary Care Pre-Examination Review |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Primary Care Exam |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Intro to Battlefield Medicine
 | Battlefield Communication/ Documentation
 | Casualty Movement
 | Combat Medical Aid Bag
 | Combat Casualty Assessment
 | Control Bleeding
 | Airway Management
 | [NAME] Trauma
 | Shock
 | Vascular Access
 | Fieldcraft 1 Pre-Examination Review |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Field Craft Exam |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Head Injuries with Traumatic Brain Injuries
 | Ocular Injuries
 | Burns
 | [NAME]
 | Musculoskeletal Trauma
 | [NAME] |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Field Craft 2 Exam |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | [NAME] Training
 | Casualty Triage
 | Suicide Prevention
 | [NAME] and Geneva Conv.
 | Environmental Threat
 | Fieldcraft 3 Pre-Examination Review |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Field Craft Exam |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Combat Caualty Assesment ( Table VIII Skills Validation
 | Combat Caualty Assesment ( Table VIII Skills Validation
 | Combat Caualty Assesment ( Table VIII Skills Validation
Spreadsheet: 730059d1619530224-find-record-on-2-criteria-with-nearest-lowest-date-27042021-sample-file-for-excel-forum
Sheet: Sheet1

Fees Slabs | Charges | Date | Column1 | Column2
500000 | 2500 | 2018-09-24 00:00:00 |  | 1 | Question 1 :
1000000 | 3000 | 2018-09-24 00:00:00 |  | 2
2500000 | 5000 | 2018-09-24 00:00:00 |  | 3 | Current Date | 2021-03-30 00:00:00 | << [NAME] |  | Nearest lowest date of the current date is 05/07/2020
5000000 | 7500 | 2018-09-24 00:00:00 |  | 4 | Fees | 1127000 | << [NAME]
100000000 | 9000 | 2018-09-24 00:00:00 |  | 5 | Charges | 5400 | <<<<< RESULT |  | Charges on fees slabs above 10.00 lakh but minimum 25.00 lakh
500000 | 3100 | 2020-07-05 00:00:00 |  | 6
1000000 | 3500 | 2020-07-05 00:00:00 |  | 7 | I want Charges amount by seeking nearest lowest date record & fees amount must be between the range
2500000 | 5400 | 2020-07-05 00:00:00 |  | 8
5000000 | 7900 | 2020-07-05 00:00:00 |  | 9
100000000 | 11000 | 2020-07-05 00:00:00 |  | 10
500000 | 3500 | 2021-04-04 00:00:00 |  | 11
1000000 | 4000 | 2021-04-04 00:00:00 |  | 12
2500000 | 6000 | 2021-04-04 00:00:00 |  | 13
5000000 | 8000 | 2021-04-04 00:00:00 |  | 14
100000000 | 15000 | 2021-04-04 00:00:00 |  | 15
Service Charges Amt. | Service Chg % | Sanction limit | Date | Column1 | Question 2 :
0 | 0.01 | 2500000 | 2018-09-24 00:00:00
25000 | 0.005 | 5000000 | 2018-09-24 00:00:00 |  | Current Date | 2021-04-30 00:00:00 | << [NAME] |  | Nearest lowest date of the current date is 05/07/2020
37500 | 0.0025 | 10000000 | 2018-09-24 00:00:00 |  | Fees | 11127000 | << [NAME]
50000 | 0.002 | 1000000000 | 2018-09-24 00:00:00 |  | Service Charges Amt |  | <<<<< RESULT |  | Service Charges on slabs above 1.00 crore
0 | 0.01 | 2500000 | 2020-07-05 00:00:00
25000 | 0.005 | 5000000 | 2020-07-05 00:00:00 |  | For 25.00 lakh
37500 | 0.0025 | 10000000 | 2020-07-05 00:00:00 |  | Upto 50.00 lakh |  | =(C25-C24)*B25+G25
50000 | 0.002 | 1000000000 | 2020-07-05 00:00:00 |  | upto 1.00 Crore |  | =(C26-C25)*B26+G26
0 | 0.03 | 2500000 | 2021-04-04 00:00:00 |  | above 1.00 Crore |  | =(C27-C26)*B27+G27
25000 | 0.02 | 5000000 | 2021-04-04 00:00:00
37500 | 0.01 | 10000000 | 2021-04-04 00:00:00 |  | I want Service Charges amount by seeking nearest lowest date record & sanction limit amount must be between the date range * Servic charges %
50000 | 0.005 | 1000000000 | 2021-04-04 00:00:00
 | Servic charge table
 | 0 | 0.01 | 2018-09-24 00:00:00
 | 2500000 | -0.005
 | 5000000 | -0.0025
 | 10000000 | -0.0005
 | 0 | 0.01 | 2020-07-05 00:00:00
 | 2500000 | -0.005
 | 5000000 | -0.0025
 | 10000000 | -0.0005
 | 0 | 0.03 | 2021-04-04 00:00:00
 | 2500000 | -0.01
 | 5000000 | -0.01
 | 10000000 | -0.005
Spreadsheet: louise_kitchen__22695__2001 Gain Calcs
Sheet: Sheet1

 |  | Summary Of 2001 Asset Sales |  | Book | Sales
 |  |  |  | Basis | Proceeds | Gain
 |  |  | Sale of 2000 Peakers to Allegheny* | 635.5 | 1047.7
 |  |  | Sale of Brownsville and Caledonia to CINergy | 274.3 | 499.625
 |  |  | Sale of North Carolina Plants to AIG | 7.5 | 22
 |  |  | Sale of New Albany to Duke | 136.096 | 135
 |  |  | *includes $23 million for unwind of COMED capacity transaction.
Spreadsheet: 131096d1322738420-multiple-look-ups-example1
Sheet: Sheet1

Sales rep | Product | order date
[NAME] | Car | 2011-02-10 00:00:00
[NAME] | Fox | 2011-03-20 00:00:00
[NAME] | House | 2011-08-15 00:00:00
[NAME] | Spinning top | 2011-10-22 00:00:00
[NAME] | Spinning top | 2011-10-15 00:00:00 |  |  |  | Oldest order date
[NAME] | Car | 2011-05-30 00:00:00 |  |  |  | Car | Fox | House | Spinning Top
[NAME] | Car | 2011-10-22 00:00:00 |  |  | [NAME]
[NAME] | Fox | 2011-10-15 00:00:00 |  |  | [NAME]
[NAME] | House | 2011-05-30 00:00:00 |  |  | [NAME]
[NAME] | Spinning top | 2011-01-12 00:00:00 |  |  | Overall
[NAME] | Car | 2011-08-27 00:00:00
[NAME] | Car | 2011-04-11 00:00:00
[NAME] | House | 2011-10-15 00:00:00
[NAME] | Spinning top | 2011-05-30 00:00:00
[NAME] | Car | 2011-01-12 00:00:00
[NAME] | House | 2011-08-27 00:00:00
[NAME] | Spinning top | 2011-05-30 00:00:00
[NAME] | Fox | 2011-01-12 00:00:00
[NAME] | Fox | 2011-08-27 00:00:00
[NAME] | Spinning top | 2011-05-30 00:00:00
[NAME] | House | 2011-10-15 00:00:00
Spreadsheet: 576407d1528096899-min-and-max-max-and-min
Sheet: Sheet1

Before :- |  |  |  |  |  |  |  | After :-
Country | Ref |  |  |  |  |  |  | Country | Start | End
India | A1 |  |  |  |  |  |  | India
Israel | B1 |  |  |  |  |  |  | Israel
Hong Kong | C1 |  |  |  |  |  |  | Hong Kong
India | A2
Israel | B2
Hong Kong | C2
India | A3
Israel | B3
Hong Kong | [NAME]
India | A4
Israel | B4
Hong Kong | C4
India | A5
Israel | B5
Hong Kong | C5
Spreadsheet: 53612d1253557749-sum-array-value-errors-multi-array-20sample-20workbook-1-
Sheet: Summary

SUMMARY
 |  | Date | 2009-09-01 00:00:00
Project | Phase | Dept
Pr1 | Build | Tech
Pr2 | Build | Tech
Pr3 | Build | Tech
Pr1 | Maintenance | Tech
Pr2 | Maintenance | Tech
Pr3 | Maintenance | Tech
Spreadsheet: 674699d1587992376-error-result-1scranbled
Sheet: Sheet1

 | Country | Sort order | Item |  | Country: | Japan
 | Japan | 20 | A
 | China | 11 | B |  | Sort order: | Items:
 | Japan | 0 | C
 | Japan | 19 | D
 | China | 17 | E
 | Japan | 13 | I
 | China | 6 | G
 | Japan | 0 | H
 | Japan | 7 | I
 | Japan | 18 | J
 | China | 16 | K
 | China | 2 | L
Spreadsheet: 716434d1612207504-conversion-of-sales-leads-to-targets-leadtosales
Sheet: Sheet2

 |  |  | Month | 1 | 2 | 3 | 4
 |  |  | Lead to Conversion | 0.05 | 0.4 | 0.23 | 0.02
 | Sale Month | Forecast Widgit Sales | # [NAME] to meet Widget Sales
 | 2022-01-31 00:00:00 | 382 |  |  |  |  | Example: If 500 Leads were received in January 2022
 |  | 412 |  |  |  |  | Sales Month | 2022-01-31 00:00:00 | 2022-02-28 00:00:00 | 2022-03-31 00:00:00 | 2022-04-30 00:00:00
 |  | 413 |  |  |  |  | # Sales
 |  | 407
 |  | 450
 |  | 433
 |  | 325
 |  | 351
 |  | 358
 |  | 391
 |  | 321
 |  | 492
 |  | 397
 |  | 450
 |  | 462
 |  | 436
 |  | 460
 |  | 416
Spreadsheet: 711529d1609771979-change-non-adjacent-cells-to-if-any-are-sample2
Sheet: Sheet1

 |  | A | B | C | D
 |  | ON | OFF | ON | ON
 |  |  |  |  |  |  | all of these cells should be reset to "" if any of these cells are calculated to be ""
 |  |  | data | data |  | data | data | data |  | data
 |  |  |  |  | the data in these cells that should remain unaltered
Spreadsheet: 124225d1318259427-excel-2007-forumating-from-drop-down-boxes-domestic-quote-generator-master-rev-qq
Sheet: Measured Supply (Per 1M)

MEASURED SUPPLY
Gas Carcass [NAME]
[NAME] | SL No. | Value | Unit | Notes | Quantity | Adjustment | Total
28 mm |  | 0 | 3m |  | 0
22 mm |  | 0 | 3m |  | 0
15 mm |  | 0 | 3m |  | 0
 |  |  |  |  |  | Total
Gas Supply To Fireplace
[NAME] | SL No. | Value | Unit | Notes | Quantity | Adjustment | Total
28 mm |  | 0 | 3m |  | 0
22 mm |  | 0 | 3m |  | 0
15 mm |  | 0 | 3m |  | 0
 |  |  |  |  |  | Total
Gas Supply To Hob
[NAME] | SL No. | Value | Unit | Notes | Quantity | Adjustment | Total
28 mm |  | 0 | 3m |  | 0
22 mm |  | 0 | 3m |  | 0
15 mm |  | 0 | 3m |  | 0
 |  |  |  |  |  | Total
Alcythene
[NAME] | SL No. | Value | Unit | Notes | Quantity | Adjustment | Total
25mm |  | 0 | 3m |  | 0
 |  |  |  |  |  | Total
Spreadsheet: benjamin_rogers__1013__Pro Forma2
Sheet: Tariff

DELMARVA, VA
Project Revenues
US $ 000s
Year
Months of Operation
Energy Production (Diesel):
Capacity Installed (MW)
Annual Dispatch
Operating Hours
Net Energy Available for Sale
REVENUES
MWh's Consumed
Cumulative Plant [NAME]
Fixed:
Contract Capacity
Capacity Pricing from Stratus ($[NAME])
Total Capacity Charges
VARIABLE:
July/August Options
Net Option Premium
MWhs/during month
Net Escalated Option Revenue
Spot Revenue
Spot Rate/MWh
MWh's [NAME]
Escalated Spot Revenue
Total Variable Charges
Tariff Summary
Spot Revenue with adjustment factor
Total cents/kWh
Average price years (1-10)
Average price years (11-15)
 |  | 435 | 735 | 683 | 705 | 670 | 595 | 636 | 674 | 669 | 658 | 653 | 644 | 662 | 650 | 658 | 640 | 647 | 643 | 644 | 622 | 616
 |  | 435.36 | 735.4 | 682.69 | 704.64 | 670.35 | 594.9 | 635.81 | 674.03 | 668.77 | 657.93 | 652.77 | 643.6 | 662.24 | 650.3 | 658.28 | 640.34 | 646.52 | 642.63 | 643.88 | 622.32 | 616.18
Spreadsheet: 759648d1639647480-gathering-data-from-scarce-cells-from-a-vertical-range-gathering-data-from-scarce-cells-from-a-vertical-range
Sheet: Sheet1

70 |  |  | 70
 |  |  | 95
 |  |  | 77
95 |  |  | 52
 |  |  | 93
77 |  |  | 16
52 |  |  | 9
 |  |  | 14
 |  |  | 90
 |  |  | 51
 |  |  | 5
 |  |  | 53
 |  |  | 42
93 |  |  | 64
16
9
14
90
51
5
53
42
64
Spreadsheet: 107424d1304599166-need-formula-for-a-macro-function-example
Sheet: 9

1018
Name | Amount
Name 1 | 112
Name 3 | 129
Name 1 | 100
Name 2 | 118
Name 1 | 140
Name 3 | 105
Name 2 | 109
Name 3 | 112
Name 3 | 173
Name 2 | 185
Name 3 | 107
Name 3 | 118
Name 1 | 106
Name 3 | 108
Name 2 | 195
Name 1 | 193
Name 1 | 100
Name 3 | 189
Name 3 | 141
Name 1 | 106
Name 2 | 174
Name 1 | 161
Name 3 | 148
Name 3 | 147
Name 2 | 128
Spreadsheet: 552926d1513849492-extension-of-formula-21-dec-2017
Sheet: Sheet1

-0.1815255773265033
-0.1812095838068258
-0.1817675280100335
-0.1648874201731296
-0.1575969654144961
-0.1559439446249273
-0.20203079435535
-0.1886429167611037
-0.1575279533520303
-0.1515865537733742
-0.0978930384604376
-0.1261050678616666
-0.07525544055833638
-0.06227551274924422
-0.1117280195279828
-0.0683647328070608
-0.02526145801705037
0.021545335260536
0.08675507640632502
0.0210264333967775
0.06533077626467564
0.04533851544682986
0.09603235700311903
0.1050349517109787
0.1141413765745174
0.1884437878732357
0.2483064075232735
0.2462803080125054
0.2050552644562683
0.2494699623221075
0.2177562554000075
0.04921104949772302
0.1018231622332709
0.1915336612464584
0.2453982098799879
0.3363483533880949
0.3797215788418313
0.328096780606582
0.3594670604523718
0.3785130717351427
0.3390833475628748
0.416890990857561
0.3645990171538319
0.3368550893088815
0.2882239614050559
0.3669745406789297
0.4114770434773196
0.482169343225447
0.4173390081030374
0.4350179818046641
0.5733720555644249
0.5208961698334942
0.5002471300738045
0.533017277220885
0.5196302558943933
0.6310367639855671
0.562650900308762
0.5707158950968791
0.4404709161520278
0.4603081773995555
0.5234556957781494
0.4057067585432708
0.3076317446361155
0.4069400104806848
0.4189258250049129
0.3888530916538135
0.3801989250872144
0.2845035806085982
0.1889409005835664
0.2090446802686975
0.2905627833747009
0.2922132313276264
0.2554994916304576
0.2207582267513042
0.2567542582001369
0.1751446401721051
0.1521756804733583
0.06093186144477592
-0.03436537172253622
-0.04425441151157308
-0.1585569236295203
-0.09840696642972864
-0.05982973892753383
-0.128688216073363
-0.1655740081433796
-0.1936970013980761
-0.1941244003818397
-0.1315991986830629
-0.1003522624781868
-0.1012461604094373
-0.08988328710344513
-0.08699972173176992
-0.1124572924151351
-0.07641450725096902
-0.08509093500948439
-0.05089758663264705
-0.04514054010955885
-0.04174731397288216
-0.06740038813600648
-0.0922187079752368