tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 9e76b78e-2c51-47f1-86d3-293982ad5768
Sheet: Sheet1

FMB BANK ACCOUNT RECONCILIATION FORM | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
DATE:       /       /
 |  |  |  | Bank Statement Date:
Ending Balance from Bank Statement |  |  |  |  |  |  |  |  | 0
Add Deposits in Transit:
 | Deposit Date |  | Amount |  | Deposit Date |  | Amount
 |  |  | 0 |  |  |  | 0
 |  |  | 0 |  |  |  | 0
 |  |  | 0 |  |  |  | 0
 |  |  | 0 |  |  |  | 0
 |  |  | 0 |  |  |  | 0
 | Total Deposits in Transit |  |  |  |  |  |  |  | 0
Subtotal |  |  |  |  |  |  |  |  | 0
Subtract Outstanding Checks:
 | Check Number |  | Amount |  | Check Number |  | Amount
 |  |  | 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
 | Total Outstanding Checks |  |  |  |  |  |  |  | 0
Computed Book Balance |  |  |  |  |  |  |  |  | 0
Balance per Your Books |  |  |  |  |  |  |  |  | 0
Difference |  |  |  |  |  |  |  |  | 0
Spreadsheet: 559338d1517577606-separating-data-column-with-english-and-chinese-text-into-2-separate-columns-hieroglyph
Sheet: Лист1

a1 | a2 |  |  |  |  | https://unicode-table.com/en/blocks/cjk-unified-ideographs/
一
丁
丂
七
丄
丅
丆
万
丈
三
上
下
丌
不
与
丏
丐
丑
丒
专
且
丕
世
丗
丘
丙
业
丛
东
丝
丞
丟
丠
両
丢
丣
两
严
並
丧
丨
丩
个
丫
丬
中
丮
丯
丰
丱
串
丳
临
丵
丶
丷
丸
丹
为
主
丼
丽
举
丿
乀
乂
乃
乄
久
乆
乇
么
义
乊
之
乌
乍
乎
乏
乐
乑
乒
乓
乔
乕
乖
乗
乘
乙
乚
乛
乜
九
乞
也
习
乡
乢
乤
乥
书
乨
乩
乪
乫
乬
乭
买
乱
乳
乵
乶
乸
乹
乺
乼
乾
乿
亀
亁
亂
亃
亄
亅
了
亇
予
争
亊
事
二
亍
于
亏
云
互
亓
五
井
亖
亗
亘
亙
亚
些
亜
亝
亞
亟
亠
亡
亢
交
亥
亦
产
亨
亩
亪
享
京
亭
亮
亯
亰
亱
亲
亳
亵
亶
亷
亸
亹
人
亻
亼
亽
亾
亿
什
仁
仂
仃
仄
仅
仆
仇
仉
今
介
仍
从
仏
仐
仑
仒
仓
仔
仕
他
仗
付
仙
仚
仛
仝
仞
仟
仡
代
令
以
仨
仪
仫
们
仭
仮
仰
仲
仳
仵
件
价
仸
任
份
仾
仿
伀
企
伃
伈
伉
伊
伋
伍
伎
伏
伐
休
伕
众
优
伙
会
伛
伜
伝
伞
伟
传
伢
伣
伤
伥
伦
伧
伩
伪
伫
伭
伮
伯
估
伱
伲
伴
伶
伷
伸
伹
伺
伻
似
伽
伾
佀
佃
但
佇
佈
佉
佋
佌
位
低
住
佐
佑
体
佔
何
佗
佘
余
佚
佛
作
佝
佞
佟
你
佡
佢
佣
佤
佥
佩
佪
佬
佭
佮
佯
佰
佳
佴
併
佶
佷
佸
佹
佺
佻
佼
佽
佾
使
侀
侁
侂
侃
侄
侅
來
侇
侈
侉
侊
例
侍
侎
侏
侐
侑
侔
侖
侗
侘
侚
供
侜
依
侠
価
侢
侣
侥
侦
侧
侨
侩
侪
侫
侬
侭
侮
侯
侴
侵
侶
侷
便
俁
係
促
俄
俅
俈
俊
俎
俏
俐
俑
俓
俔
俗
俘
俙
俚
俛
俜
保
俞
俟
俠
信
俣
俤
俥
俦
俨
俩
俪
俫
俬
俭
修
俯
俱
俲
俳
俴
俵
俶
俸
俺
俻
俾
倀
倂
倃
倅
倆
倈
倉
個
倌
倍
倏
倐
們
倒
倔
倖
倘
候
倚
倜
倝
倞
借
倡
倢
倣
値
倥
倦
倨
倩
倪
倫
倬
倭
倮
倳
倶
倹
债
倻
值
倽
倾
偁
偃
偄
假
偈
偉
偊
偌
偎
偏
偐
偓
偕
偖
偘
做
停
偝
偟
偢
健
偨
偩
偪
偫
偬
偭
偯
偲
側
偵
偶
偷
偸
偹
偺
偻
偽
偾
偿
傀
傁
傅
傈
傌
傍
傎
傏
傑
傒
傔
傕
傖
傘
備
傚
傜
傞
傢
傣
傥
傧
储
傩
傫
催
傭
傮
傯
傲
傳
傴
債
傷
傺
傻
傼
傽
傾
僂
僃
僄
僅
僇
僈
僉
僊
働
僎
像
僑
僕
僖
僚
僝
僞
僣
僤
僥
僦
僧
僨
僩
僬
僭
僮
僯
僰
僱
僳
僵
僶
價
僻
僾
僿
儀
儁
儂
億
儅
儆
儇
儈
儉
儊
儋
儌
儍
儎
儐
儒
儓
儔
儕
儗
儘
儚
儛
儜
償
儡
儤
儦
儩
優
儭
儱
儲
儳
儶
儷
儸
儹
儺
儻
儼
儽
儾
儿
兀
允
兂
元
兄
充
兆
兇
先
光
克
兌
免
兎
児
兑
兒
兔
兕
兖
兗
兙
党
兛
兜
兝
兞
兟
兡
兢
兣
入
兦
內
全
兩
兪
八
公
六
兮
兯
兰
共
兲
关
兴
兵
其
具
典
兹
养
兼
兽
兾
冀
冁
冂
冄
内
円
冇
冈
冉
冊
冋
册
再
冏
冐
冑
冒
冓
冔
冕
冖
冗
冘
写
冚
军
农
冝
冞
冠
冢
冤
冥
冦
冧
冨
冩
冪
冫
冬
冯
冰
冱
冲
决
冴
况
冶
冷
冻
冼
冽
净
凂
凃
凄
凅
准
凇
凈
凉
凊
凋
凌
凍
减
[NAME]
凓
凔
凖
凙
凚
凛
凜
凝
凞
凟
几
凡
凢
凣
凤
凥
処
凧
凨
凩
凪
凫
凭
凮
凯
凰
凱
凳
凴
凵
凶
凷
凸
凹
出
击
凼
函
凾
凿
Spreadsheet: 130307d1322170978-help-with-formula-to-add-dates-802985-help-with-formula-to-add-dates-sample-tracker
Sheet: December 2011

STATUS | CUSTOMER | SITE | SAMPLE TYPE | REASON | DATE TAKEN | COMPLETION DATE | HBI PERSON | LAB | LAB REFERENCE | MBR | PRESUMPTIVE | CONFIRMED | FINAL | RESAMPLE
INCOMPLETE | Google | Dublin | Legionella | Monitoring | 2011-11-24 00:00:00 |  | [NAME] | Science UK | 123456
INCOMPLETE | Google | Dublin | Bacteria | Monitoring | 2011-11-24 00:00:00 |  | [NAME] | Science UK | 123456
INCOMPLETE | Google | Dublin | Chemical | Monitoring | 2011-11-24 00:00:00 |  | [NAME] | Science UK | 123456
 |  |  |  |  |  | 2011-12-08 00:00:00
 |  |  |  |  |  | 2011-11-29 00:00:00
 |  |  |  |  |  | 2011-11-08 00:00:00 | ??
Spreadsheet: darrell_schoolcraft__7735__imball0203
Sheet: crosstex

Crosstexx Energy Services |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
 | contr 21571 - poi 56935 |  | contr 23994 - poi 58444
 | Integrated Services DP |  | I.S.I. Farm Tap- [NAME]
 | Measured | Scheduled | Measured | Scheduled
1 | -2089 | -1963 | -2500 | -2000
2 | -2301 | -1963 | -860 | -2000
3 | -2292 | -1963 | -955 | -2000
4 | -2253 | -1963 | -2405 | -2000
5 | -1124 | -1963 | -2271 | -2000
6 | -2011 | -1963 | -2203 | -2000
7 | -2399 | -1963 | -2160 | -2000
8 | -2198 | -1963 | -1864 | -2000
9 | -2403 | -1963 | -172 | -2000
10 | -2141 | -1963 | -607 | -2000
11 | -2341 | -1963 | -2267 | -2000
12 | -2061 | -1963 | -2180 | -2000
13 | -2182 | -1963 | -2172 | -2000
14 | -1871 | -1963 | -2295 | -2000
15 | -2137 | -1963 | -2077 | -2000
16 | -2027 | -1963 | -211 | -2000
17 | -2256 | -1963 | -607 | -2000
18 | -2133 | -1963 | -2234 | -2000
19 | -794 | -1963 | -2431 | -2000
20
21
22
23
24
25
26
27
28
29
30
31
index
2002-02-28 00:00:00 |  |  |  |  |  |  | 713.49
2002-03-19 00:00:00
CBS Volume |  |  |  |  |  |  | 2808
Spreadsheet: 876152d1722846252-need-formula-for-tier-incentive-calculation-calculation-doing-formula
Sheet: Dr. Hisham Ayoub

Contract Terms (*)
 |  | Description | Commission
 |  | Consultation | 0.5
 |  | Lab & Ultra Sounds After Deducting Lab Fee | 0.1
 |  | Procedure in Clinics After Deducting Hospital Fee | 0.1
 |  | Procedure in Clinics After Deducting Hospital Fee | 0.35
 |  | Procedure in Clinics | 0.5
Doctor Calculation
 |  | Gross Revenue
 |  | Consultation Revenue | 14230.02
 |  | Amount to be paid
 |  | Referral Revenue | 0
 |  | Amount to be paid
 |  | Procedure in the Clinics Revenue (0%) | 16100
 |  | Amount to be paid
 |  | Procedure in the Clinics Revenue (5%) | 0
 |  | Amount to be paid
 |  | Procedure in the Clinics Revenue (10%) | 60530.17
 |  | Less: Hospital Fee/Lab | 0
 |  | Net Revenue
 |  | Amount to be paid
 |  | Procedure in the Clinics Revenue (35%) | 214725
 |  | Less: Hospital Fee | 0
 |  | Net Revenue
 |  | Amount to be paid
 |  | Procedure in the Clinics Revenue (50%) | 25099.45
 |  | Amount to be paid
 |  | Lab & Ultra Sound Revenue | 32848
 |  | Less: Lab | 0
 |  | Net Revenue
 |  | Amount to be paid
 |  | Total Amount to be Paid
 |  | Less: Sharing 50% Deduction | 0
 |  | Total Amount to be Paid
Prepared By …................. |  |  | CFO:…...............
Spreadsheet: 370ea8f4-1744-44a6-a82c-f0f5c9e7278f
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 |  | U.S. Census Bureau
 |  | Source: Quarterly Services Survey
 |  | 51: Information: U.S. Total
 |  | Not Seasonally Adjusted Total Revenue [Millions of Dollars]
 |  | Period: 2003 to 2014
 |  | Data Extracted on: March 8, 2014 (2:48 pm)
Period | Value
Q1-2003 | X
Q2-2003 | X
Q3-2003 | X
Q4-2003 | 237399
Q1-2004 | 223675
Q2-2004 | 233241
Q3-2004 | 232983
Q4-2004 | 246201
Q1-2005 | 236033
Q2-2005 | 244136
Q3-2005 | 244711
Q4-2005 | 255856
Q1-2006 | 245182
Q2-2006 | 254735
Q3-2006 | 255745
Q4-2006 | 271401
Q1-2007 | 257973
Q2-2007 | 265739
Q3-2007 | 267325
Q4-2007 | 281304
Q1-2008 | 270217
Q2-2008 | 277643
Q3-2008 | 277604
Q4-2008 | 282885
Q1-2009 | 261948
Q2-2009 | 266881
Q3-2009 | 265508
Q4-2009 | 280622
Q1-2010 | 267483
Q2-2010 | 274697
Q3-2010 | 276055
Q4-2010 | 291990
Q1-2011 | 277885
Q2-2011 | 289552
Q3-2011 | 288862
Q4-2011 | 304550
Q1-2012 | 290131
Q2-2012 | 297462
Q3-2012 | 296119
Q4-2012 | 320584
Q1-2013 | 302663
Q2-2013 | 309834
Q3-2013 | 310513
Q4-2013 | X
Q1-2014 | X
Q2-2014 | X
Q3-2014 | X
Q4-2014 | X
Spreadsheet: 239fabcf-5d97-45fe-b1e7-8f25a5a238de
Sheet: Sheet1

Inmate Phone RFP Ranking 7-16-10 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
Non responsive | Low | Medium Low | Average | Medium High | High | Criteria | GTL | VAC | Securus | Embarq | PCS | Paytel
0 | 5 | 10 | 20 | 30 | 40 | 1. Vendor's demonstrated experience with inmate phone systems of similar size. | 40 | 30 | 40 | 30 | 20 | 10
0 | 10 | 20 | 30 | 40 | 50 | 2. Vendor's ability to meet specifications. | 50 | 50 | 50 | 50 | 50 | 50
0 | 5 | 10 | 20 | 30 | 40 | 3. Vendor's ability to meet important specifications. | 40 | 40 | 40 | 40 | 40 | 40
0 | 0 | 5 | 10 | 20 | 30 | 4. Vendor's ability to meet desired specifications. | 30 | 30 | 20 | 30 | 30 | 20
0 | 10 | 20 | 30 | 40 | 50 | 5. Proposed commission schedule. | 40 | 50 | 50 | 20 | 10 | 30
0 | 10 | 20 | 30 | 40 | 50 | 6. Accounting System's ability to balance to commission payments. | 50 | 50 | 40 | 50 | 50 | 50
0 | 10 | 20 | 30 | 40 | 50 | 7. Level of service and support. | 30 | 30 | 30 | 30 | 30 | 30
0 | 5 | 10 | 20 | 30 | 40 | 8. Billing and collection procedures. | 20 | 20 | 20 | 20 | 20 | 20
0 | 10 | 20 | 30 | 40 | 50 | 9. Handling of debit calling. | 50 | 40 | 30 | 40 | 40 | 30
0 | 10 | 20 | 30 | 40 | 50 | 10. Ad Hoc reporting capable to meet our special needs. | 50 | 50 | 50 | 50 | 50 | 30
0 | 10 | 20 | 30 | 40 | 50 | 11. Investigative features and capabilities. | 50 | 50 | 30 | 40 | 30 | 40
0 | 0 | 5 | 10 | 20 | 30 | 12. Commission Incentives | 30 | 0 | 20 | 20 | 5 | 0
 |  |  |  |  |  | Total: 530 [NAME]. | 480 | 440 | 420 | 420 | 375 | 350
Spreadsheet: 758723d1639040112-excel-dashboard-help-sum-data-from-multiple-tabs-service-support-management-db_v2
Sheet: Calculations

PROJECTS
Month | Client Projects |  | SRM Lead | Month | Days Spent | Hours spent | Client Calls | SRM Lead | Month | Days Spent | Hours spent
January |  |  | [NAME] | January |  |  |  | [NAME] | January
February |  |  | [NAME] | February |  |  |  | [NAME] | February
March |  |  | [NAME] | March |  |  |  | [NAME] | March
April |  |  | [NAME] | April |  |  |  | [NAME] | April
May |  |  |  | May |  |  |  |  | May
June |  |  |  | June |  |  |  |  | June
July |  |  |  | July |  |  |  |  | July
August |  |  |  | August |  |  |  |  | August
September |  |  |  | September |  |  |  |  | September
October |  |  |  | October |  |  |  |  | October
November |  |  |  | November |  |  |  |  | November
December |  |  |  | December |  |  |  |  | December
PAT TICKETS
Month | Tickets
January | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
February | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
March | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
April | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
May | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
June | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
July | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
August | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
September | =COUNTIFEmployee Data'!$G$2:$G$405,"="&A18)
October
November
December
Client Information
Name
Hire Date
Location
Termination Date
Employment Type
Year
Base Salary
Bonus
Overtime
Commission
Total Compensation
Department
PTO Days
Sick Days
Performance Score
Spreadsheet: 867625d1714456661-add-companies-to-names-6months-audits
Sheet: Permit Issuers

RAISED BY
'Gobey, [NAME] | ARCADIS |  | 2 | 58 | 14 | 6 | 5 | 2 | 2 | 1
'[NAME], Haydn | ARCADIS
'Blake, [NAME] | BUK
'Chipchase, [NAME] | BUK
'Cooke, [NAME] | BUK
'Frost, [NAME] | BUK
'[NAME], [NAME] | BUK
'[NAME], [NAME] | BUK
'Hodgson, [NAME] | BUK
'[NAME], [NAME] | BUK
'[NAME], [NAME] | BUK
'Low, [NAME] | BUK
'Purvis, [NAME] | BUK
'Ramsden, [NAME] | BUK
'Ryder, [NAME] | BUK
'Sharrock, [NAME] | BUK
'Akintaro, [NAME] | EMCOR
'[NAME], [NAME] | EMCOR
'[NAME], Prince | EMCOR
'Apostolopoulou, Gina | EMCOR
'[NAME], Stephen | EMCOR
'[NAME], [NAME] | EMCOR
'[NAME], Brett | EMCOR
'Cleveley, Julian | EMCOR
'[NAME], [NAME] | EMCOR
'[NAME] | EMCOR
'[NAME], Stephen | EMCOR
'Crowder, [NAME] | EMCOR
'[NAME], [NAME] | EMCOR
'Eldret, Gary | EMCOR
'Esterhuyse, [NAME] | EMCOR
'Eyre, [NAME] | EMCOR
'[NAME], Alfie | EMCOR
'[NAME], [NAME] | EMCOR
'Green, Georgina | EMCOR
'[NAME], [NAME] | EMCOR
'[NAME], Stephen | EMCOR
'Holton, [NAME] | EMCOR
'Hurrell, [NAME] | EMCOR
'Kaye, [NAME] | EMCOR
'[NAME], [NAME] | EMCOR
'Lloyd, [NAME] | EMCOR
'Maguire, [NAME] | EMCOR
'Masangcay, [NAME] | EMCOR
'Mckeever, [NAME] | EMCOR
'[NAME], [NAME] | EMCOR
'Mitcham, Martin | EMCOR
'[NAME], [NAME] | EMCOR
'[NAME], Kris | EMCOR
'O'Neil, [NAME] | EMCOR
'[NAME], [NAME] | EMCOR
'[NAME], [NAME] | EMCOR
'Pates, [NAME] | EMCOR
'Petruccio, Mario | EMCOR
'Potter, [NAME] | EMCOR
'Prosser, [NAME] | EMCOR
'Rees, [NAME] | EMCOR
'[NAME], [NAME] | EMCOR
'Rogers, Bradley | EMCOR
'Schooling, Janice | EMCOR
'[NAME], [NAME] | EMCOR
'Smythe, Stuart | EMCOR
'Solly, [NAME] | EMCOR
'Strutt, Gavin | EMCOR
'Thompson, [NAME] | EMCOR
'Tingling, Justin | EMCOR
'Titheradge, [NAME] | EMCOR
'Varney, [NAME] | EMCOR
'Walters, [NAME] | EMCOR
'[NAME], [NAME] | EMCOR
'[NAME], Piotr | EMCOR
'[NAME], [NAME] | EMCOR
'[NAME], [NAME] | EMCOR
'[NAME], [NAME] | EMCOR
'Blyton, [NAME] | GSK
'Rashid, Kas | GSK
'[NAME], [NAME] | GSK AT
'Day, [NAME] | GSK AT
'Day, [NAME] | GSK AT
'[NAME], [NAME] | GSK AT
'[NAME], [NAME] | GSK AT
'[NAME], [NAME] | HANLEY
'Burrows, [NAME] | SODEXO
'Carruthers, [NAME] | SODEXO
'Colliss, [NAME] | SODEXO
'Findlay, [NAME] | SODEXO
'[NAME], [NAME] | SODEXO
'Stanbridge, Gillian | SODEXO
'Broom, [NAME] | TDI
'Heath, [NAME] | TDI
Spreadsheet: 148396d1333386915-creating-a-report-to-show-vehicle-tax-due-tax-disc-log
Sheet: T198 ABF

 |  |  |  |  | T198 ABF
Registration number : | T198 ABF |  | Date Taxed | Duration | Tax Expiry  Date | Cost (£)
Manufacturer : | [NAME] |  | 2000-04-28 00:00:00 | 12 Months | 2000-05-01 00:00:00 | 2500
Specification : | 6 x 2 A (3 Axle) |  | 2001-04-30 00:00:00 | 12 Months | 2001-05-01 00:00:00 | 2500
Type : | FTG85 CF 380 |  | 2002-04-30 00:00:00 | 12 Months | 2002-05-01 00:00:00 | 750
1st Registered : | 01.05.99 |  | 2003-04-30 00:00:00 | 12 Months | 2003-05-01 00:00:00 | 700
Engine : | DAF XF280M |  | 2004-04-30 00:00:00 | 12 Months | 2004-05-01 00:00:00 | 700
[NAME] : | 44,000kg |  | 2005-04-29 00:00:00 | 12 Months | 2005-05-01 00:00:00 | 700
 |  |  | 2006-04-28 00:00:00 | 12 Months | 2006-05-01 00:00:00 | 700
 |  |  | 2007-04-30 00:00:00 | 12 Months | 2007-05-01 00:00:00 | 700
 |  |  | 2008-04-30 00:00:00 | 12 Months | 2008-05-01 00:00:00 | 700
Back To Index |  |  | 2009-04-30 00:00:00 | 12 Months | 2010-05-01 00:00:00 | 165 | Private HGV
 |  |  | Licence Surrendered 26/2/2010
Spreadsheet: 220571d1363195415-cell-to-assign-values-based-upon-goals-branch-points-copy
Sheet: Plaques

1st Quarter
Acc Gain
$ Profit
% Profit
SF
BD
%LV
Totals Points
2nd Quarter
Acc Gain
$ Profit
% Profit
SF
BD
%LV
Totals Points
3rd Quarter
Acc Gain
$ Profit
% Profit
SF
BD
%LV
Totals Points
4th Quarter
Acc Gain
$ Profit
% Profit
SF
BD
%LV
Totals Points
Annual
Acc Gain
$ Profit
% Profit
SF
BD
%LV
Totals Points
Spreadsheet: 4819def0-6d46-4ba0-83c3-ce6b35503c1d
Sheet: Sheet1

Table S7. Climatic data | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Population | Latitude | Weather station [NAME] | Latitude | Mean Tmax (°C) | Mean Tmin (°C) | Rainfall ([NAME])
Innisfail, QLD | 17.31 | Innisfail | 17.52 | 27.86 | 20.21 | 3508.890476190476
Redland Bay, QLD | 27.36 | Redlands RHS | 27.53 | 25.42 | 14.42 | 1131.1
[NAME], NSW | 30.22 | Coffs Harbour MO | 30.31 | 23.54 | 14.3 | 1623.3
Melbourne, VIC | 37.43 | Melbourne regional office | 37.81 | 20.55 | 11.51 | 607.06
aWeather stations close to the four Australian populations analyzed in this study for the period 1988-2008.
Spreadsheet: 697611d1601446710-frequency-frequency
Sheet: Sheet1

 |  |  |  | without disturbing  data and no helper column
 |  |  |  |  |  |  |  |  |  |  | frequency
 |  | 38 | 81 | 21 | 84 | 24 | 32 |  |  | 0-25
 |  | 32 | 99 | 81 | 72 | 74 | 78 |  |  | 26-50
 |  | 86 | 51 | 33 | 63 | 32 | 60 |  |  | 51-75
 |  | 87 | 18 | 27 | 47 | 92 | 90 |  |  | 76-100
 |  | 18 | 78 | 72 | 69 | 53 | 28
 |  | 59 | 82 | 25 | 95 | 91 | 67
 |  | 11 | 17 | 46 | 43 | 75 | 18
 |  | 49 | 79 | 31 | 85 | 65 | 91
Spreadsheet: 768227d1644886919-match-not-working-days-to-date-table-sample-test
Sheet: Sheet1

Days Not Working |  |  |  |  |  |  |  |  |  | Desired Output
Person | Day 1 | Day 2 | Day 3 |  |  |  |  |  |  |  | Mon | Tue | Wed | Thur | Fri
Person A | Wednesday | Monday |  |  |  |  |  |  |  |  | 2022-02-14 00:00:00 | 2022-02-15 00:00:00 | 2022-02-16 00:00:00 | 2022-02-17 00:00:00 | 2022-02-18 00:00:00
Person B | Tuesday | Friday | Monday |  |  |  |  |  |  | Person A | Not Working | Working | Not Working | Working | Working
Person C | Thursday | Wednesday |  |  |  |  |  |  |  | Person B | Not Working | Not Working | Working | Working | Not Working
 |  |  |  |  |  |  |  |  |  | Person C | Working | Working | Not Working | Not Working | Working
Spreadsheet: 267662d1380132772-counting-total-number-of-days-in-specified-period-for-dataset-nick_f-22sep13
Sheet: Sheet2

[NAME] | Pt_ident
2004-04-01 00:00:00 | AA1111
2005-06-06 00:00:00 | AA1111
2006-07-07 00:00:00 | AA1111
2008-06-04 00:00:00 | AA1111
2007-06-05 00:00:00 | BB2222
2009-11-12 00:00:00 | BB2222
2008-02-25 00:00:00 | DD4444
2008-08-30 00:00:00 | DD4444
2005-05-25 00:00:00 | GG7777
2006-01-02 00:00:00 | GG7777
2012-03-04 00:00:00 | GG7777
2003-08-11 00:00:00 | HH8888
2003-10-25 00:00:00 | HH8888
2003-12-02 00:00:00 | HH8888
2004-02-01 00:00:00 | HH8888
Spreadsheet: 268914d1380887079-taking-a-average-value-month-sensitive-from-a-separate-sheet-m1kef
Sheet: BN 99 WC GP

BN 99 WC GP
Automatically filled in here from capture sheet
Date | Driver | [NAME] | Quantity(litres) | Litres/Km |  | match_row |  | Difference
Spreadsheet: 141891d1329499665-sumifs-formula-error-central-division-termination-tracker-21712
Sheet: Sheet4

M = corporate, owner, mgmt co. decision and/or change |  | AZ |  | Yes |  | ALF |  | RMA |  | APS - Austin
CL = Facility Closure |  | CO |  | No |  | SNF |  | Unit |  | Bridgeport Pharmacy Services
D = dispensing system |  | NC |  |  |  | ICF |  | National Acct |  | Broadway Long Term Care Pharmacy
S = service |  | SC |  |  |  | CCF |  |  |  | Community Medical Pharmacy - Chula Vista DME
C = company owned pharmacy |  | PNW |  |  |  | Hospice |  |  |  | Community Medical Pharmacy - LTC
P = pricing/perdiem |  | SLC |  |  |  | Other |  |  |  | Community Medical Pharmacy - Retail
R = no relationship-competitor marketing won the account |  | NTX |  |  |  |  |  |  |  | Consulting & Pharmaceutical Services
A = A/R issues |  | STX |  |  |  |  |  |  |  | Creekside Managed Care Pharmacy
CON = consulting |  |  |  |  |  |  |  |  |  | Evergreen Pharmaceutical - Kirkland
JV = joint venture |  |  |  |  |  |  |  |  |  | Evergreen Pharmaceutical - Medford
 |  |  |  |  |  |  |  |  |  | Evergreen Pharmaceutical - Portland
 |  |  |  |  |  |  |  |  |  | Evergreen Pharmaceutical - Spokane
 |  |  |  |  |  |  |  |  |  | NeighborCare - Eagles Trace
 |  |  |  |  |  |  |  |  |  | Omnicare - Albuquerque
 |  |  |  |  |  |  |  |  |  | Omnicare Canoga Park, CA
 |  |  |  |  |  |  |  |  |  | [NAME], CA
 |  |  |  |  |  |  |  |  |  | Omnicare of Amarillo
 |  |  |  |  |  |  |  |  |  | Omnicare of Bakersfield
 |  |  |  |  |  |  |  |  |  | Omnicare of Billings
 |  |  |  |  |  |  |  |  |  | Omnicare of [NAME]
 |  |  |  |  |  |  |  |  |  | Omnicare of Fort Worth
 |  |  |  |  |  |  |  |  |  | Omnicare of Golden
 |  |  |  |  |  |  |  |  |  | Omnicare of Grand Junction
 |  |  |  |  |  |  |  |  |  | Omnicare of Houston
 |  |  |  |  |  |  |  |  |  | Omnicare of Lodi
 |  |  |  |  |  |  |  |  |  | Omnicare of Lubbock
 |  |  |  |  |  |  |  |  |  | Omnicare of Nacogdoches
 |  |  |  |  |  |  |  |  |  | Omnicare of Pharr Services
 |  |  |  |  |  |  |  |  |  | Omnicare of Pueblo
 |  |  |  |  |  |  |  |  |  | Omnicare of San Antonio
 |  |  |  |  |  |  |  |  |  | Omnicare of San Diego
 |  |  |  |  |  |  |  |  |  | Omnicare of Tyler
 |  |  |  |  |  |  |  |  |  | Omnicare of Waco
 |  |  |  |  |  |  |  |  |  | Omnicare Pharmacy of Texas
 |  |  |  |  |  |  |  |  |  | Omnicare Redding, CA
 |  |  |  |  |  |  |  |  |  | Pharmacy Support Services - Cerritos
 |  |  |  |  |  |  |  |  |  | Pharmacy Support Services - Hayward
 |  |  |  |  |  |  |  |  |  | Puget Pharmacy Services
 |  |  |  |  |  |  |  |  |  | Resource Pharmacy - Henderson
 |  |  |  |  |  |  |  |  |  | Resource Pharmacy, Inc.  - Reno
 |  |  |  |  |  |  |  |  |  | Southern Desert Pharmacy - Prescott LTC
 |  |  |  |  |  |  |  |  |  | Superior Care Pharmacy - Salt Lake City
 |  |  |  |  |  |  |  |  |  | Superior Care Pharmacy - St. George
 |  |  |  |  |  |  |  |  |  | Superior Care Pharmacy of Idaho
 |  |  |  |  |  |  |  |  |  | Village Southern Desert Pharmacy
 |  |  |  |  |  |  |  |  |  | Walgreens LTC Pharmacy
 |  |  |  |  |  |  |  |  |  | Walgreens LTC Pharmacy
Spreadsheet: 122743d1317128147-count-formula-example
Sheet: Sheet1

Table 1 |  |  |  |  |  | Table 2
Company Code | Sub Loc |  |  |  |  | Company | NO | GH | FG | TH | LO | KO | BH | LH | YJ
1 | NO |  |  |  |  | 1 | 2 | 1 | 1 | 2 | 0 | 0 | 0 | 0 | 0
1 | GH |  |  |  |  | 2 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 0 | 0
1 | FG |  |  |  |  | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
1 | TH |  |  |  |  | 4
1 | TH |  |  |  |  | 5
1 | NO |  |  |  |  | 6
2 | LO
2 | KO
2 | KO
3 | BH
4 | BH
4 | GH
4 | LH
5 | GH
6 | YJ
Spreadsheet: 62741d1263710983-text-box-content-blurred-when-saved-as-html-mksamplesheet
Sheet: Test

 |  |  |  | BEGINNING  OF  RECORDED  HUMAN  HISTORY
B.C. | ADAM
5406 | 1
5405 | 2
5404 | 3
5403 | 4
5402 | 5
5401 | 6
5400 | 7
5399 | 8
5398 | 9
5397 | 10
5396 | 11
5395 | 12
5394 | 13
5393 | 14
5392 | 15
Spreadsheet: 191785d1352216754-finding-range-with-most-value-consecutivemax
Sheet: Sheet1

15 |  |  | 2305 | <<<< | highest total of 10 consecutive(arrayformula!) |  |  |  |  |  | doublechecking: | 375
20 |  |  |  |  |  |  |  |  |  |  |  | 425
25 |  |  | 15 | <<<< | starting from row 15(arrayformula!) |  |  |  |  |  |  | 475
30 |  |  |  |  |  |  |  |  |  |  |  | 525
35 |  |  |  |  |  |  |  |  |  |  |  | 575
40 |  |  |  |  |  |  |  |  |  |  |  | 707
45 |  |  |  |  |  |  |  |  |  |  |  | 921
50 |  |  |  |  |  |  |  |  |  |  |  | 1217
55 |  |  |  |  |  |  |  |  |  |  |  | 1513
60 |  |  |  |  |  |  |  |  |  |  |  | 1809
65 |  |  |  |  |  |  |  |  |  |  |  | 2023
70 |  |  |  |  |  |  |  |  |  |  |  | 2155
75 |  |  |  |  |  |  |  |  |  |  |  | 2205
80 |  |  |  |  |  |  |  |  |  |  |  | 2255
167 |  |  |  |  |  |  |  |  |  |  |  | 2305
254 |  |  |  |  |  |  |  |  |  |  |  | 2273
341 |  |  |  |  |  |  |  |  |  |  |  | 2159
346 |  |  |  |  |  |  |  |  |  |  |  | 1963
351 |  |  |  |  |  |  |  |  |  |  |  | 1767
274 |  |  |  |  |  |  |  |  |  |  |  | 1571
197 |  |  |  |  |  |  |  |  |  |  |  | 1457
120 |  |  |  |  |  |  |  |  |  |  |  | 1425
125 |  |  |  |  |  |  |  |  |  |  |  | 1475
130 |  |  |  |  |  |  |  |  |  |  |  | 1525
135 |  |  |  |  |  |  |  |  |  |  |  | 1575
140 |  |  |  |  |  |  |  |  |  |  |  | 1625
145 |  |  |  |  |  |  |  |  |  |  |  | 1675
150 |  |  |  |  |  |  |  |  |  |  |  | 1725
155 |  |  |  |  |  |  |  |  |  |  |  | 1775
160 |  |  |  |  |  |  |  |  |  |  |  | 1825
165 |  |  |  |  |  |  |  |  |  |  |  | 1875
170 |  |  |  |  |  |  |  |  |  |  |  | 1925
175 |  |  |  |  |  |  |  |  |  |  |  | 1975
180 |  |  |  |  |  |  |  |  |  |  |  | 2025
185 |  |  |  |  |  |  |  |  |  |  |  | 2075
190 |  |  |  |  |  |  |  |  |  |  |  | 2125
195 |  |  |  |  |  |  |  |  |  |  |  | 2175
200 |  |  |  |  |  |  |  |  |  |  |  | 2174
205 |  |  |  |  |  |  |  |  |  |  |  | 2121
210 |  |  |  |  |  |  |  |  |  |  |  | 2015
215 |  |  |  |  |  |  |  |  |  |  |  | 1855
220 |  |  |  |  |  |  |  |  |  |  |  | 0
225 |  |  |  |  |  |  |  |  |  |  |  | 0
230 |  |  |  |  |  |  |  |  |  |  |  | 0
235 |  |  |  |  |  |  |  |  |  |  |  | 0
240 |  |  |  |  |  |  |  |  |  |  |  | 0
194 |  |  |  |  |  |  |  |  |  |  |  | 0
147 |  |  |  |  |  |  |  |  |  |  |  | 0
99 |  |  |  |  |  |  |  |  |  |  |  | 0
50 |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 82724d1282753640-search-for-value-in-one-row-and-take-next-column-value-example
Sheet: Results I would like

Inventory Number | Color | Color2 | pic1
BILL717-P | Black | Black and Gray | 6_18_59.JPG
BILL717-31 | Orange | Orange and blue | 6_18_59.JPG
POLOS24-P | Multi-Colored | Multi | 8_24_9_0188.JPG
BILL773-P | Multi-Colored | Multi | IMG_5160.jpg
Quik250-P | Black | Multi | 01_13_10_341.JPG
Quik253-P | Black | Black Blue and pink | 01_13_10_413.JPG
BILL840-P | Black | Black | 02_15_10_0213.JPG