tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 16236f3c-f22f-4e41-9872-d63adf707837
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 8731.0 Building Approvals, Australia
 | TABLE 76. Value of Building Approved, Chain Volume Measures, Original - Victoria
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Value of Approval ($M) ;  Chain Volume Measures ;  Victoria ;  Total houses ;  New ; |  |  | Original | A590487F | 1985-09-01 00:00:00 | 2009-06-01 00:00:00 | 96 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Victoria ;  Total other residential building ;  New ; |  |  | Original | A590488J | 1985-09-01 00:00:00 | 2009-06-01 00:00:00 | 96 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Victoria ;  Total residential building ;  New ; |  |  | Original | A590489K | 1985-09-01 00:00:00 | 2009-06-01 00:00:00 | 96 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Victoria ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A590490V | 1985-09-01 00:00:00 | 2009-06-01 00:00:00 | 96 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Victoria ;  Total residential building ;  Total (Type of Work) ; |  |  | Original | A590491W | 1985-09-01 00:00:00 | 2009-06-01 00:00:00 | 96 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Victoria ;  Total non-residential building ;  Total (Type of Work) ; |  |  | Original | A590492X | 1985-09-01 00:00:00 | 2009-06-01 00:00:00 | 96 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Victoria ;  Total building ;  Total (Type of Work) ; |  |  | Original | A590493A | 1985-09-01 00:00:00 | 2009-06-01 00:00:00 | 96 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2009
Spreadsheet: louise_kitchen__22818__Credit List Additions
Sheet: Additions

Counterparty Name | Counterparty ID
AEC Marketing (USA), Inc. | 58009
AEC Storage and Hub Services Inc. | 72509
AEC Storage and Hub Services, a business unit of Alberta Energy Company Ltd | 56586
AEC Marketing | 53368
BC Gas Utility Ltd. | 46749
Encore Energy Solutions, L.P. | 88408
ENMAX Energy Corporation | 93623
IGI Resources, Inc. | 1799
Nexen Marketing | 57251
Puget Sound Energy, Inc. | 54279
SaskEnergy Incorporated | 5177
TransCanada Energy Financial Products Limited | 48528
TransCanada Energy Marketing USA, Inc. | 54480
TransCanada Gas Services Inc. | 45829
TransCanada Gas Services, a division of TransCanada Energy Ltd. | 54461
Union Oil Company Of California | 220
Royal Bank of Canada, The | 21581
Unocal Canada Limited | 26342
[NAME]
Cross Alta Storage
ERCOT
Nova Gas Transmission Ltd. (NGTL)
Petro-Canada Oil and Gas
Sabine Storage
TransCanada PipeLines Limited
Spreadsheet: 9a4478d8-b8bf-4803-8a4c-ff686bc9a888
Sheet: Sheet1

ĐẠI HỌC QUỐC GIA TP.HCM | Unnamed: 1 | Unnamed: 2 | CỘNG HOÀ XÃ HỘI CHỦ NGHĨA VIỆT NAM | Unnamed: 4
TRƯỜNG ĐH KHOA HỌC TỰ NHIÊN |  |  | Độc lập - Tự do - Hạnh phúc
[NAME] SINH HỆ HOÀN CHỈNH ĐẠI HỌC CHÍNH QUY NGÀNH CNTT KHÓA 2011
NGÀY THI: 24 & 25/12/2011
[NAME] điểm thi: [NAME] học Tự nhiên - 227 Nguyễn Văn Cừ Q5
Ngày thi | Buổi | Thời gian | Môn thi | Ghi chú
2011-12-24 00:00:00 | Chiều | 13g00 | [NAME] | [NAME] tích ([NAME] buộc)
 |  |  |  | [NAME] (Chọn 1 trong 2 môn Toán rời rạc hoặc ĐS tuyến tính)
2011-12-25 00:00:00 | Sáng | 7g00 | Cơ sở | Kỹ [NAME] và Cấu trúc dữ liệu ([NAME] buộc)
2011-12-25 00:00:00 | Chiều | 13g00 | Chuyên ngành | Chọn 2 trong 4 môn: Trí tuệ nhân tạo, CSDL, Đồ họa, Mạng máy tính
Lưu ý: | 1. Khi đi thi, thí sinh phải đem theo phiếu báo thi và giấy tờ tùy thân có dán ảnh.
 | 2. [NAME] sinh phải có mặt tại phòng thi trước giờ thi 15 phút.
 |  |  |  | TP. HCM, ngày 12 tháng 12 năm 2011
 |  |  |  | TM. Hội đồng Tuyển sinh
 |  |  |  | ([NAME] ký)
 |  |  |  | NGUYỄN THỊ HIẾU
Spreadsheet: 92994d1292506092-topology-network-tree-sample-topology
Sheet: Sheet1

 |  |  |  |  |  |  |  | this is want I want to create using connection between longitude and latitude
Site ID1 | Longitude1 | Latitude1 | Site ID2 | Longitude2 | Latitude2 | Link ID | FO/BSC ID | Link Topology
Site A | 107.5866556 | -6.92979167 | Site B | 107.58497 | -6.93266 |  | Site A | 1.1.1
Site C | 107.6132222 | -6.88483333 | Site D | 107.6066389 | -6.867222 |  | Site A | 1.1.1.2
Site E | 107.636 | -6.92533 | Site D | 107.6326667 | -6.92466667 |  | Site A | 1.2.3
Site F | 107.6170833 | -6.93047222 | Site B | 107.6050278 | -6.92225 |  | Site A | 1.2.1
Site G | 107.6254167 | -6.93538889 | Site H | 107.6170833 | -6.93047222 |  | Site A | 1.1.1.1
Spreadsheet: 174a123a-b730-4784-8753-600da4111155
Sheet: Joanna Cole

[NAME]
Fair Share Fee: Those Who Don't Pay Their Fair Share
Agree
Explain your fair share position, if you choose.
No response
Teachers' Retirement: Support in the State Budget
Agree
Explain your teachers' retirement position, if you choose.
No response
Health Care: Continuing System Reform
Agree
Explain your health care reform position, if you choose
No response
Teaching Career: Retaining New Teachers
Agree
Explain your teaching career position, if you choose
No response
Teaching Profession: Simplifying Professional Relicensing
Agree
Explain your relicensing position, if you choose
No response
Name | email address | Address | Office sought | Are you an incumbent? |  | County
[NAME] | [EMAIL] | 108 Rivers Edge Drive | State Representative [NAME]. 6-1 (2 seats) | No |  | Chittenden
Spreadsheet: jonathan_mckay__16896__QuantoMC
Sheet: Sheet1

 | Quanto Swap Simulation
 |  | Valuation
 |  |  | Gas Price | 5 |  | HDD | 38
 |  |  | Gas Vol | 0.5 |  | HDD STD | 12
 |  |  | Omm. Vol | 0.8 |  |  |  |  | Correl r | 0.75
 |  |  | Blend Vol |  |  | TS | 1 |  | sqrt(1-r2)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hedge
 |  |  |  |  |  |  | Natural Gas |  | HDD |  |  |  | Blended | HDD | Blended |  | Mark to Market |  |  | Quanto Delta Positions |  |  |  |  |  |  |  | RNDS |  |  |  |  |  |  |  |  |  |  |  |  |  | RNDS
 |  |  |  | Date | tline |  | Price | Ln(Pt/Pt-1) | Value | Change |  | Correl | Gas Vol | STD | Correl |  | Value | Change |  | Dp | DHDD | Change |  |  | Difference |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  |  |  | 2001-06-01 00:00:00
 |  |  |  | 2001-06-02 00:00:00
 |  |  |  | 2001-06-03 00:00:00
 |  |  |  | 2001-06-04 00:00:00
 |  |  |  | 2001-06-05 00:00:00
 |  |  |  | 2001-06-06 00:00:00
 |  |  |  | 2001-06-07 00:00:00
 |  |  |  | 2001-06-08 00:00:00
 |  |  |  | 2001-06-09 00:00:00
 |  |  |  | 2001-06-10 00:00:00
 |  |  |  | 2001-06-11 00:00:00
 |  |  |  | 2001-06-12 00:00:00
 |  |  |  | 2001-06-13 00:00:00
 |  |  |  | 2001-06-14 00:00:00
 |  |  |  | 2001-06-15 00:00:00
 |  |  |  | 2001-06-16 00:00:00
 |  |  |  | 2001-06-17 00:00:00
 |  |  |  | 2001-06-18 00:00:00
 |  |  |  | 2001-06-19 00:00:00
 |  |  |  | 2001-06-20 00:00:00
 |  |  |  | 2001-06-21 00:00:00
 |  |  |  | 2001-06-22 00:00:00
 |  |  |  | 2001-06-23 00:00:00
 |  |  |  | 2001-06-24 00:00:00
 |  |  |  | 2001-06-25 00:00:00
 |  |  |  | 2001-06-26 00:00:00
 |  |  |  | 2001-06-27 00:00:00
 |  |  |  | 2001-06-28 00:00:00
 |  |  |  | 2001-06-29 00:00:00
 |  |  |  | 2001-06-30 00:00:00
 |  |  |  | 2001-07-01 00:00:00
 |  |  |  | 2001-07-02 00:00:00
 |  |  |  | 2001-07-03 00:00:00
 |  |  |  | 2001-07-04 00:00:00
 |  |  |  | 2001-07-05 00:00:00
 |  |  |  | 2001-07-06 00:00:00
 |  |  |  | 2001-07-07 00:00:00
 |  |  |  | 2001-07-08 00:00:00
 |  |  |  | 2001-07-09 00:00:00
 |  |  |  | 2001-07-10 00:00:00
 |  |  |  | 2001-07-11 00:00:00
 |  |  |  | 2001-07-12 00:00:00
 |  |  |  | 2001-07-13 00:00:00
 |  |  |  | 2001-07-14 00:00:00
 |  |  |  | 2001-07-15 00:00:00
 |  |  |  | 2001-07-16 00:00:00
 |  |  |  | 2001-07-17 00:00:00
 |  |  |  | 2001-07-18 00:00:00
 |  |  |  | 2001-07-19 00:00:00
 |  |  |  | 2001-07-20 00:00:00
 |  |  |  | 2001-07-21 00:00:00
 |  |  |  | 2001-07-22 00:00:00
 |  |  |  | 2001-07-23 00:00:00
 |  |  |  | 2001-07-24 00:00:00
 |  |  |  | 2001-07-25 00:00:00
 |  |  |  | 2001-07-26 00:00:00
 |  |  |  | 2001-07-27 00:00:00
 |  |  |  | 2001-07-28 00:00:00
 |  |  |  | 2001-07-29 00:00:00
 |  |  |  | 2001-07-30 00:00:00
 |  |  |  | 2001-07-31 00:00:00
Spreadsheet: 862097d1709869333-index-match-help-index-match-v4-hewlp
Sheet: Sheet1

store id no. | store name | # of Employees | # of Customers |  |  | store id no. | store name | Other stores nearby (<1min) | Other stores nearby (<5min) |  | Store Name | Other stores nearby (<1min) | # of Employees | # of Customers
2 | Red | 2 | 40 |  |  | 2 | Red | 4|6 | 4|6|7 |  | Blue
4 | Blue | 2 | 20 |  |  | 4 | Blue | 5|6 | 5|6|7 |  | Orange
5 | Orange | 5 | 30 |  |  | 5 | Orange | 2 | 2|7
6 | Green | 7 | 25 |  |  | 6 | Green | 2|4|7 | 2|4|7
7 | Blue | 9 | 15 |  |  | 7 | Blue | 4|6 | 4|6|7
Spreadsheet: 813555d1673857687-pls-help-average-with-if-conditions-need-average-of-each-product-specified-by-year-and-market-entry-date-for-blank-1
Sheet: MarKet Entry Date

Product ID | Product Name | Market Entry Date | Market Entry Year
1003 | Candy A | 2002-06-02 00:00:00
1004 | Candy B | 2013-12-27 00:00:00
1005 | [NAME] | 2021-09-13 00:00:00
1006 | Candy D | 2022-12-28 00:00:00
Spreadsheet: 860351d1708487975-calculate-xnpv-with-blanks-lot-npv
Sheet: Sheet1

 | Step 1 - Choose the assets you would like to collateralize
 | Choose Collateral
 | Estimated Closing | 2024-06-30 00:00:00
 |  |  |  | Month |  | Closing | 1
 | Phase | 1 |  | Date
 | Lots | 12 |  | Base Lot Value
 | Price/Lot | 50000 |  | Lot Revenue |  | 0
 | Lot/Month | 5
 | Annual Escalator | 0.05 |  | Discount Rate | 0.15
 | Cost of Sale | 0.02 |  | Net Present Value
 | Start Date | 2024-07-31 00:00:00 |  | select
 | End Date
 | Est. Total Months
 | 10
 | 20
 | 50
 | 100
 | 150
 | 200
 | 250
 | 300
 | 500
 | 750
 | 1000
 | 1500
 | 2000
Spreadsheet: 686590d1594703072-formula-to-average-and-count-excel-help
Sheet: Sheet1

Customer | Booking Date | SM
CUSTOMER A | 2019-06-01 00:00:00 | 0.9
CUSTOMER B | 2019-07-01 00:00:00 | 0.4
CUSTOMER C | 2019-08-01 00:00:00 | 0.541
CUSTOMER D | 2019-08-01 00:00:00 | 0.579
CUSTOMER E | 2019-08-01 00:00:00 | 0.695
CUSTOMER F | 2019-11-01 00:00:00 | 0.723
CUSTOMER G | 2020-01-01 00:00:00 | 0.675 | 0.675
CUSTOMER H | 2020-06-01 00:00:00 | 0.765 | 0.765
CUSTOMER I | 2020-07-01 00:00:00 | 0.65
[NAME] | MM/YY
[NAME] | MM/YY
[NAME] | MM/YY
[NAME] | MM/YY
Spreadsheet: 28ed556c-561a-454e-aff1-a756bd18b518
Sheet: Sheet1

ORAL IVERMECTIN TREATMENT PROTOCOL FOR CANINE DEMODICOSIS
Client name: _________________________________
Patient name:________________________________
Account number:____________________________
Current weight:____________________________
Date | Day # | Dose | Daily oral (by mouth) dose in mL | Dose given today (check off) | Comments | Due for skin scrape
 | 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 |  |  |  |  | See next page
Patient name:________________________________
Date | Day # | Dose | Daily oral (by mouth) dose in mL | Dose given today (check off) | Comments | Due for skin scrape
 | 31
 | 32
 | 33
 | 34
 | 35
 | 36
 | 37
 | 38
 | 39
 | 40
 | 41
 | 42
 | 43
 | 44
 | 45
 | 46
 | 47
 | 48
 | 49
 | 50
 | 51
 | 52
 | 53
 | 54
 | 55
 | 56
 | 57
 | 58
 | 59
 | 60 |  |  |  |  | Need skin scrape
Spreadsheet: 477610d1472406150-sum-if-sum-if-dummy-
Sheet: Sheet2

 |  |  |  | [NAME] | 100
 |  |  |  | [NAME] | 50
 |  |  |  | [NAME] | 75
 |  |  |  | [NAME] | 20
 |  |  |  | [NAME] | 25
 |  |  |  | Alejandro Marin | 200
 |  |  |  | Alejandro Moreda | 400
 |  |  |  | [NAME] | 300
 |  |  |  | [NAME] | 200
 |  |  |  | [NAME] | 50
Spreadsheet: 267457d1380082297-if-countif-index-match-problem-to-list-out-eligible-name-list-pejoi
Sheet: Sheet2

NO. | NAMES |  | PARENTS' OCCUPATION |  | TOTAL [NAME]) |  |  | DEPENDENCY | PERCAPITA | FOOD SCHEME | ALLOWANCE | PAYSLIP
 |  |  | FATHER | MOTHER | (FATHER +MOTHER)
Spreadsheet: 134358d1325248342-lookup-copy-of-lookup-help
Sheet: Sheet1

Customer | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 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
abc | 0.3129152450873604 | 0.2848153094622417 | 0.3322988283677505 | 0.2966350190999603 | 0.284576376152568 | 0.2180288862940509 | 0.2483312564837607 | 0.1494107037487408 | 0.1853569780337651 | 0.2935081013640936 | 0.3068192731607283 | 0.3889599531246479 | 0.3422624094188409 | 0.4104008893211978 | 0.4420447059754613 | 0.3589187703123313
def | 0.6870847549126397 | 0.7151846905377582 | 0.6677011716322494 | 0.7033649809000398 | 0.715423623847432 | 0.7819711137059492 | 0.7516687435162394 | 0.8505892962512591 | 0.814643021966235 | 0.7064918986359064 | 0.6931807268392716 | 0.6110400468753522 | 0.6577375905811591 | 0.5895991106788021 | 0.5579552940245387 | 0.6410812296876688
gfi | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
jkl | 0.5070405326980054 | 0.584548334194505 | 0.7355940103711471 | 0.6349978807240075 | 0.8219299313030299 | 0.6944554549634538 | 0.5385061285525863 | 0.4591702865805662 | 0.5681100321086728 | 0.5957340767679284 | 0.4770343179912346 | 0.3853016189235636 | 0.2619413147372347 | 0.08160136496828674 | 0.1204892266476397 | 0.2450042110098767
mno | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15
pqr | 0.02 | 0.02 | 0.02 | 0.02 | 0.02 | 0.02 | 0.02 | 0.02 | 0.02 | 0.02 | 0.02 | 0.02 | 0.02 | 0.02 | 0.02 | 0.02
Month required | 2009-01-01 00:00:00 | formula should bring back % Share for month entered in B12
Customer | % Share
def |  | [NAME] to bring back % share for Customer for month in cell B12
gfi |  | [NAME] to bring back % share for Customer for month in cell B12
Spreadsheet: 857022d1706117225-remove-all-standard-prefix-replace-standard-prefix-3-ans
Sheet: Sheet1

Company Name | Desired Result
ABC Ltd (Taiwan) | ABC Ltd (Taiwan) |  |  |  |  |  |  | *My data either show only the company name OR company + (Code)
ABC Ltd (Taiwan) ([NAME]) | ABC Ltd (Taiwan) |  | ABC Ltd (Taiwan) |  |  |  |  | Code = 3Text+5Number
ABC Ltd (Taiwan) (XJH22222) | ABC Ltd (Taiwan) |  | ABC Ltd (Taiwan) |  |  |  |  | is there a formula to make all those (Code) to be blank?
Tiger Co (JZZ88888) | Tiger Co |  | Tiger Co
Tiger Co (ABC77777) | Tiger Co |  | Tiger Co
Tiger Co | Tiger Co |  | Tiger Co
Black Pte Ltd | Black Pte Ltd |  | Black Pte Ltd
Black Pte Ltd (PKD76251) | Black Pte Ltd |  | Black Pte Ltd
Monbly (Pte) Ltd | Monbly (Pte) Ltd |  | Monbly (Pte) Ltd
Monbly (Pte) Ltd (HTT21212) | Monbly (Pte) Ltd |  | Monbly (Pte) Ltd
Spreadsheet: 5c750ac4-402e-4aac-9d21-d2d7ce43fba4
Sheet: Sheet1

SAN FRANCISCO ASSESSOR/RECORDER | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 |  | SUMMARY LEASED EQUIPMENT SCHEDULE
 |  | FOR LIEN DATE JANUARY 1, 2012
 | DBA:
 | Estimate Life of Equipment:
 |  |  |  |  |  | Table:
Year of | Description |  |  | Original Cost/ |  | Assessor's Use Only
Acquisition |  |  |  | *Other Basis |  | Factor |  | Value
2011
2010
2009
2008
2007
2006
2005
2004
2003
2002
2001
2000
1999
1998
1997
1996
1995
1994
1993
1992
1991
Prior
Total
Are Sales Taxes, Freight, and installation Cost included above?  Yes____   No____
*Explain if other than Cost:_______________________________________________
Spreadsheet: michelle_lokay__26669__Sempra
Sheet: Sheet1

 |  |  | tw | epng | cb |  | san juan | perm | san juan | perm | san juan | perm
 |  |  | san juan | perm | gas daily | fixed | volume | volume | volume | volume | fuel | fuel | san  juan | perm | total p/l | spread | SET p/l | TW p/l
 | 2001-03-01 00:00:00 |  | 5.205 | 5.26 | 12.955 | 11 | 10000 | 5000
 | 2001-03-02 00:00:00 |  | 5.37 | 5.39 | 23.95 | 18 | 10000 | 5000
 | 2001-03-03 00:00:00 |  | 5.265 | 5.245 | 27.79 | 25 | 10000 | 5000
 | 2001-03-04 00:00:00 |  | 5.265 | 5.245 | 27.79 | 25 | 10000 | 5000
 | 2001-03-05 00:00:00 |  | 5.265 | 5.245 | 27.79 | 25 | 3334 | 3182
 | 2001-03-06 00:00:00 |  | 5.2 | 5.355 | 31.31 | 28.25 | 0 | 12431 | 0
 | 2001-03-07 00:00:00 |  | 5.12 | 5.195 | 25.265 | 23 | 10000 | 5000
 | 2001-03-08 00:00:00 |  | 5.045 | 5.125 | 14.28 | 12 | 10000 | 5000
 | 2001-03-09 00:00:00 |  | 5.045 | 5.135 | 12.825 | 11.55 | 10000 | 5000
 | 2001-03-10 00:00:00 |  | 4.93 | 5.04 | 12.505 | 12.45 | 10000 | 5000
 | 2001-03-11 00:00:00 |  | 4.93 | 5.04 | 12.505 | 12.45 | 10000 | 5000
 | 2001-03-12 00:00:00 |  | 4.93 | 5.04 | 12.505 | 12.45 | 10000 | 5000
 | 2001-03-13 00:00:00 |  | 4.805 | 4.88 | 11.565 | 10.5 | 10000 | 5000
 | 2001-03-14 00:00:00 |  | 4.99 | 5 | 10.92 | 10.8 | 10000 | 5000
 | 2001-03-15 00:00:00 |  | 4.86 | 4.885 | 9.535 | 9.25 | 10000 | 5000
 | 2001-03-16 00:00:00 |  | 4.825 | 4.845 | 9.41 | 9.2 | 10000 | 5000
 | 2001-03-17 00:00:00 |  | 4.81 | 4.885 | 9.025 | 8.8 | 10000 | 5000
 | 2001-03-18 00:00:00 |  | 4.81 | 4.885 | 9.025 | 8.8 | 10000 | 5000
 | 2001-03-19 00:00:00 |  | 4.81 | 4.885 | 9.025 | 8.8 | 10000 | 5000
 | 2001-03-20 00:00:00 |  | 4.855 | 4.955 | 9.945 | 9.75 | 10000 | 5000
 | 2001-03-21 00:00:00 |  | 4.725 | 4.87 | 11.035 | 11.085 | 10000 | 5000
 | 2001-03-22 00:00:00 |  | 4.63 | 4.95 | 11.605 | 11.35 | 10000 | 5000
 | 2001-03-23 00:00:00 |  | 4.6 | 4.805 | 10.995 | 10.74 | 10000 | 5000
 | 2001-03-24 00:00:00 |  | 4.735 | 4.94 | 11.13 | 10.95 | 10000 | 5000
 | 2001-03-25 00:00:00 |  | 4.735 | 4.94 | 11.13 | 10.95 | 10000 | 5000
 | 2001-03-26 00:00:00 |  | 4.735 | 4.94 | 11.13 | 10.95 | 10000 | 5000
 | 2001-03-27 00:00:00 |  | 4.44 | 5 | 10.25 | 10.05 | 10000 | 5000
 | 2001-03-28 00:00:00 |  | 4.49 | 5.18 | 10.78 | 10.75 | 10000 | 5000
 | 2001-03-29 00:00:00 |  | 4.66 | 5.405 | 13.585 | 13.6 | 10000 | 5000
 | 2001-03-30 00:00:00 |  | 4.5 | 5.155 | 14.015 | 14.15 | 9506 | 4552
 | 2001-03-31 00:00:00 |  | 4.45 | 5.115 | 14.25 | 14.15 | 9324 | 4480
Spreadsheet: 750048d1633191266-files-status-based-on-dates-dashboard
Sheet: Entry

File # | Reception date | Analyze |  | Approve |  | Submit date
 |  | start date | end date | start date | end date
123 | 2021-09-20 00:00:00 | 2021-09-21 00:00:00 | 2021-09-22 00:00:00 | 2021-09-22 00:00:00 | 2021-09-25 00:00:00 | 2021-09-30 00:00:00
456 | 2021-09-22 00:00:00 | 2021-09-22 00:00:00 | 2021-09-22 00:00:00 | 2021-09-25 00:00:00 | 2021-09-28 00:00:00
124 | 2021-09-22 00:00:00 | 2021-09-22 00:00:00 | 2021-09-22 00:00:00 | 2021-09-24 00:00:00 | 2021-09-27 00:00:00
462 | 2021-09-23 00:00:00 | 2021-09-23 00:00:00 | 2021-09-24 00:00:00 | 2021-09-26 00:00:00
856 | 2021-09-23 00:00:00 | 2021-09-24 00:00:00 | 2021-09-25 00:00:00
879 | 2021-09-29 00:00:00 | 2021-09-30 00:00:00
931 | 2021-10-01 00:00:00
932 | 2021-10-02 00:00:00 | 2021-10-02 00:00:00
Spreadsheet: 60871d1261461957-compile-worksheet-list-toll-free-test
Sheet: 8661234567

 |  | [PHONE]
 | Total | 885 | 515 | 1036 | 370 | 0.5819209039548022 | 5 | 0.005649717514124294
 |  | Attempted Calls | Completed Calls | Completed MOU | Incomplete Calls | Percent Complete | Busy Calls | Percent Busy
 | 2009-11-11 00:00:00 | 65 | 34 | 435 | 31 | 0.5230769230769231 | 0 | 0
 | 2009-11-12 00:00:00 | 41 | 34 | 342 | 7 | 0.8292682926829268 | 3 | 0.07317073170731707
 | 2009-11-13 00:00:00 | 545 | 323 | 234 | 222 | 0.5926605504587156 | 1 | 0.001834862385321101
 | 2009-11-14 00:00:00 | 234 | 124 | 25 | 110 | 0.5299145299145299 | 1 | 0.004273504273504274
 | 2009-11-15 00:00:00
 | 2009-11-16 00:00:00
 | 2009-11-17 00:00:00
 | 2009-11-18 00:00:00
 | 2009-11-19 00:00:00
 | 2009-11-20 00:00:00
 | 2009-11-21 00:00:00
 | 2009-11-22 00:00:00
 | 2009-11-23 00:00:00
 | 2009-11-24 00:00:00
 | 2009-11-25 00:00:00
 | 2009-11-26 00:00:00
 | 2009-11-27 00:00:00
 | 2009-11-28 00:00:00
 | 2009-11-29 00:00:00
 | 2009-11-30 00:00:00
 | Sub Total : Nov | 885 | 515 | 1036 | 370 | 0.5819209039548022 | 5 | 0.005649717514124294
 | 2009-12-01 00:00:00
 | 2009-12-02 00:00:00
 | 2009-12-03 00:00:00
 | 2009-12-04 00:00:00
 | 2009-12-05 00:00:00
 | 2009-12-06 00:00:00
 | 2009-12-07 00:00:00
 | 2009-12-08 00:00:00
 | 2009-12-09 00:00:00
 | 2009-12-10 00:00:00
 | 2009-12-11 00:00:00
 | 2009-12-12 00:00:00
 | 2009-12-13 00:00:00
 | 2009-12-14 00:00:00
 | 2009-12-15 00:00:00
 | 2009-12-16 00:00:00
 | 2009-12-17 00:00:00
 | 2009-12-18 00:00:00
 | 2009-12-19 00:00:00
 | 2009-12-20 00:00:00
 | 2009-12-21 00:00:00
 | 2009-12-22 00:00:00
 | 2009-12-23 00:00:00
 | 2009-12-24 00:00:00
 | 2009-12-25 00:00:00
 | 2009-12-26 00:00:00
 | 2009-12-27 00:00:00
 | 2009-12-28 00:00:00
 | 2009-12-29 00:00:00
 | 2009-12-30 00:00:00
 | 2009-12-31 00:00:00
 | Sub Total : Dec | 0 | 0 | 0 | 0 | #N/A | 0 | #N/A
 | 2010-01-01 00:00:00 | 3 | 2 | 435 | 1 | 0.6666666666666666 | 0 | 0
 | 2010-01-02 00:00:00 | 6 | 3 | 342 | 3 | 0.5 | 3 | 0.5
 | 2010-01-03 00:00:00 | 5 | 3 | 234 | 2 | 0.6 | 1 | 0.2
 | 2010-01-04 00:00:00 | 12 | 8 | 25 | 4 | 0.6666666666666666 | 1 | 0.08333333333333333
 | 2010-01-05 00:00:00
 | 2010-01-06 00:00:00
 | 2010-01-07 00:00:00
 | 2010-01-08 00:00:00
 | 2010-01-09 00:00:00
 | 2010-01-10 00:00:00
 | 2010-01-11 00:00:00
 | 2010-01-12 00:00:00
 | 2010-01-13 00:00:00
 | 2010-01-14 00:00:00
 | 2010-01-15 00:00:00
 | 2010-01-16 00:00:00
 | 2010-01-17 00:00:00
 | 2010-01-18 00:00:00
 | 2010-01-19 00:00:00
 | 2010-01-20 00:00:00
 | 2010-01-21 00:00:00
 | 2010-01-22 00:00:00
 | 2010-01-23 00:00:00
 | 2010-01-24 00:00:00
 | 2010-01-25 00:00:00
 | 2010-01-26 00:00:00
 | 2010-01-27 00:00:00
 | 2010-01-28 00:00:00
 | 2010-01-29 00:00:00
 | 2010-01-30 00:00:00
 | 2010-01-31 00:00:00
 | Sub Total : Jan | 26 | 16 | 1036 | 10 | 0.6153846153846154 | 5 | 0.1923076923076923
Spreadsheet: 114423d1310142776-nested-ifs-or-array-copy-of-logic_example-1
Sheet: List 1

Year | List 1
2005 | Prefix | Code | Description | P Rate | T Rate | Global Rate | Quantity | P Collections | T Collections | Global Collections | Total
 | T |  |  |  |  |  | 1
 | P |  |  |  |  |  | 1
 |  |  |  |  |  |  | 10
 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 4
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 1
 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 3
Spreadsheet: 485350d1476830941-calculate-specific-data-from-url-s-doubt_20161018_simplified
Sheet: Sheet1

 | position-> | 1st position | 2nd position | 3rd position |  |  |  |  |  |  |  | How many times in X position |  |  |  | Punctuation
 | factor-> | 0.2 | 0.15 | 0.12 |  | url |  |  |  |  |  | 1st | 2nd | 3rd |  | 1 | 2 | 3
 | 300 | www.animals.com | www.animals.com/lion | [NAME] |  | www.animals.com |  |  |  |  |  | 1 | 0 | 0 |  | =(300*0.2)
 | 50 | www.cities.com/leeds | www.cities.com | www.cities.com/dover |  | www.animals.com/lion |  |  |  |  |  | 1 | 1 | 0 |  | =(200*0.20) | =(300*0.15)
 | 60 | www.vehicles.com | www.vehicles.com/car | www.animals.com/dog |  | [NAME] |  |  |  |  |  | 0 | 1 | 1 |  | =(80*0.15) | =(300*0.12)
 | 200 | www.animals.com/lion | www.cities.com/leeds | www.cities.com |  | www.cities.com/leeds |  |  |  |  |  | 2 | 1 | 0 |  | =(50*0.2) | =(150*0.2) | =(200*0.15)
 | 80 | www.animals.com/dog | [NAME] | www.vehicles.com |  | www.cities.com |  |  |  |  |  | 0 | 1 | 1 |  | =(50*0.15) | =(200*0.12) | =(150*0.12)
 | 150 | www.cities.com/leeds | www.vehicles.com/car | www.cities.com |  | www.cities.com/dover |  |  |  |  |  | 0 | 0 | 1 |  | =(50*0.12)
 |  |  |  |  |  | www.vehicles.com |  |  |  |  |  | 1 | 0 | 1 |  | =(60*0.2) | =(80*0.12)
 |  |  |  |  |  | www.vehicles.com/car |  |  |  |  |  | 0 | 2 | 0 |  | =(60*0.15) | =(150*0.15)
 |  |  |  |  |  | www.animals.com/dog |  |  |  |  |  | 1 | 0 | 1 |  | =(80*0.2) | =(60*0.12)