tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 878947d1726290212-ideas-for-creating-a-dashboard-education-tracking-cadet-progress-tracker-template
Sheet: Vertically

 | Level | Objective | [NAME] | Cadet 1 | [NAME] | Cadet 3 | [NAME] | Cadet 5 | Cadet 6 | Cadet 7 | Cadet 8 | Cadet 9 | Cadet 10
 | Induction | To Be Completed on First Night | Welcome Brief
 |  |  | Log Book Issued
 | Cadet Basic Training | To Achieve Second Class Cadet | ATC
 |  |  | RAF
 |  |  | Security
 |  |  | Climatic Injuries
 |  |  | History of Flight
 |  |  | Basic Drill
 |  |  | Updated on SMS
 | 2nd Class Cadet | To Achieve 1st Class Cadet | Principles of Airmanship
 |  |  | [NAME]
 |  |  | Initial Expedition Training
 |  |  | Basic Radios
 |  |  | Cyber  (Video 1)
 |  |  | Heart Start
 |  |  | Certificate Issued
 |  |  | 1st Class Badge Issued
 | 1st Class Cadet | To Achieve Leading Cadet | Airmanship Knowledge
 |  |  | Basic Nav
 |  |  | Principles of Flight
 |  |  | Cyber  (Video 2)
 |  |  | [NAME]
 |  |  | Certificate Issued
 |  |  | Leading Badge Issued
 | Leading Cadet | To Achieve Senior Cadet | Subject 1
 |  |  | Subject 2
 |  |  | Subject 3
 |  |  | SNCO Course
 |  |  | Certificate Issued
 |  |  | Senior Badge Issued
 | Senior Cadet | To Achieve Master Cadet | Subject 1
 |  |  | Subject 2
 |  |  | Subject 3
 |  |  | SNCO Course
 |  |  | Certificate Issued
 |  |  | Master Badge Issued
 | Master Cadet | To Achieve Instructor & Staff Cadet | MOI
 |  |  | Assessed [NAME]
 |  |  | BASIC
 |  | BTEC Aviation Studies | Claimed
 |  |  | Issued
 |  |  | Lanyard Issued
 | Progressive Training Syllabus |  | Flying
 |  |  | Gliding
 |  |  | Music
 |  | Radio Op & Cyber Awareness | Cyber Awareness
 |  |  | Basic Radio Operator
 |  |  | Achieved
 |  |  | Cyber Specialist
 |  |  | Radio Specialist
 |  | Leadership | Theory Test
 |  |  | Practical 1
 |  |  | Practical 2
 |  |  | Level Achieved
 |  | [NAME] | Volunteering
 |  |  | Skill
 |  |  | Expedition
 |  |  | Physical (1,2,3 or 4)
 |  |  | Level Achieved
 |  |  | First Aid
 |  |  | Para
 |  |  | Road Marching
 |  | Shooting | Trained Shot
 |  |  | Marksman
 |  |  | [NAME]
 |  |  | Competition Marksman
 | Other Awards | Duke of Cornwall | CSA
 |  |  | NSA
 |  |  | iDea
 |  |  | BTEC TPD
 |  |  | ELA
 |  |  | Crest
Spreadsheet: a7bcd593-92df-46ee-97e7-5634e12bf2ee
Sheet: 12's

12 UNDER
TEAM | Championships | Tourny's | Overall | Overall | Overall |  | Bracket | Bracket
2013-06-03 00:00:00 | Won | played | Win | Loss | Ties |  | Won | Lost
Bartow Intimidators |  | 2 | 4 | 4 | 1 |  | 1 | 2
Christina Flames - Dennis | 1 | 1 | 6 | 3 |  |  | 3 | 1
Crusaders |  | 1 | 2 | 2 |  |  | 2 | 0
Crush 00 |  | 1 | 2 | 2 |  |  | 0 | 1
Diamonds FP | 1 | 1 | 6 | 0 |  |  | 0 | 1
Fishhawk All Stars |  | 1 | 1 | 3 |  |  | 5 | 3
Florida Fire 01 | 1 | 1 | 4 | 0 | 1 |  | 2 | 0
Florida Gold 01 JR |  | 3 | 3 | 10 |  |  | 0 | 2
Florida Red Rage |  | 2 | 4 | 6 |  |  | 6 | 3
Florida Scorpions |  | 1 | 0 | 4 |  |  | 3 | 3
Gulf Coast Talons |  | 1 | 0 | 4 |  |  | 0 | 1
[NAME] |  | 2 | 7 | 6 |  |  | 1 | 2
Lakeland Rebels |  | 2 | 2 | 7 |  |  | 1 | 3
Makos 01 |  | 1 | 5 | 3 |  |  | 0 | 2
[NAME] |  | 1 | 3 | 1
[NAME] LLC |  | 1 | 1 | 2
Pinellas Warriors |  | 1 | 2 | 0 |  |  | 0 | 1
Saftey Harbor Stone Crabs 01 |  | 1 | 3 | 3 |  |  | 2 | 0
[NAME] 12U |  | 1 | 1 | 5 |  |  | 1 | 1
Spring Hill Sting |  | 1 | 0 | 2 |  |  | 0 | 1
Tampa Bay Velocity | 1 | 1 | 4 | 1 |  |  | 0 | 1
Spreadsheet: 0277db26-01a9-4367-80c8-5ac80b97deea
Sheet: 9-12

MENU - 9-12
Requirements |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Weekly Total MET Yes/No or True/False
 |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 %
Grains (1 oz eq per day)  (7-10 oz eq per week) |  |  |  |  |  |  |  |  |  |  |  |  | Total "Grain" Servings           (Grain servings + MMA sesrvings)
 |  |  | Oz Eq |  | Oz Eq |  | Oz Eq |  | Oz Eq |  | Oz Eq
Mt/MA (NOT required) (May count as grain if at least 1 oz eq of grain already being served)
 |  |  | Oz Eq |  | Oz Eq |  | Oz Eq |  | Oz Eq |  | Oz Eq
Fruits (1/2 Cup per day) (2 1/2 cups per week)
 |  |  | Cup |  | Cup |  | Cup |  | Cup |  | Cup
[NAME] (1 Cup per day) (5 per week) |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 % |  | Skim or 1 %
 |  | 1 | Cup | 1 | Cup | 1 | Cup | 1 | Cup | 1 | Cup
Decimal Equivalents
1/8 Cup | 0.125
1/4 Cup | 0.25
3/8 Cup | 0.375
1/3 Cup | 0.333
1/2 Cup | 0.5
5/8 Cup | 0.625
2/3 Cup | 0.666
3/4 Cup | 0.75
7/8 Cup | 0.875
1 Cup | 1
Spreadsheet: 845495d1696998688-copy-formulas-and-format-from-existing-row-to-a-new-row-my-gites
Sheet: Facture

 |  |  |  |  |  |  |  | Entre nom du client | 3 Mick Jagger
 |  |  |  |  |  |  |  | Reservation | All
Facture
Dates |  | Description |  | No. Nuits | Prix | Total Prix
 |  |  |  |  | Total prix de séjour
 |  |  |  |  | Taxe
 |  |  |  |  | Acomptes Reçu
 |  |  |  |  | A Payé
Spreadsheet: 07330df3-c567-4792-ac6e-8a4741e77acb
Sheet: Sheet1

ประชุมวิชาการประจำปีครั้งที่ 12 "สมวัย  สบายใจ" | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
วันที่   9 - 10   กันยายน  2553   ณ  ห้องแกรนด์บงกชรัตน์  โรงแรมทวินโลตัส  จังหวัดนครศรีธรรมราช
ที่ | ชื่อ-สกุล |  |  | ตำแหน่ง | เลขที่ใบประกอบวิชาชีพ | หน่วยงาน | ลายเซ็น |  | หมายเหตุ
 |  |  |  |  |  |  | 1953-09-09 00:00:00 | 1953-09-10 00:00:00 | ใบเสร็จ
1 | นาง | ดวงใจ | รัตนปริคณห์
2 | นาง | สุวิมล | วงศ์นพสุวรรณ
3 | นางสาว | สุฑาทิพย์ | [NAME]
4 | นางสาว | ประไพ | จิตรสุวรรณโณ
5 | นาง | น้องนุช | ไพบูลย์วรชาติ | พยาบาลวิชาชีพ | 4511063827
Spreadsheet: 79955d1280218687-combo-and-dynamic-array-identification-combo_array_addition
Sheet: Sheet1

 |  |  |  |  |  |  | Current Safety Stock by Key Customers
 |  | Product |  | Account |  | Safety Stock(in weeks) | Week_1 | Week_2 | Week_3 | Week_4 | Week_5 | Week_6 | Week_7 | Week_8 | Week_9 |  |  |  | weeks
 |  | J39 |  | METROPCS |  |  | 3678 | 1856 | 2471 | 4233 | 4614 | 4542 | 4158 | 3816 | 2335 | 7 |  |  | 6
 |  | J64 |  |  |  |  | ? | ? | ? | ? | ? | ? | ? | ? | ? |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
Data_ID | Product | Account | Week_1 | Week_2 | Week_3 | Week_4 | Week_5 | Week_6 | Week_7 | Week_8 | Week_9 | Week_10 | Week_11 | Week_12 | Week_13 |  |  |  | 3
1111 | J33 | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 2
1111 | [NAME] | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 1
1111 | J38 | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0
1111 | J39 | METROPCS | 1774 | 3678 | 1856 | 2471 | 4233 | 4614 | 4542 | 4158 | 3816 | 2335 | 1966 | 2469 | 2415
1111 | J41 | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1111 | J42 | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1111 | [NAME] | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1111 | [NAME] | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1111 | J49 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1111 | J58 | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1111 | J63 | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1111 | J64 | METROPCS | 3250 | 6872 | 2196 | 2711 | 5958 | 5846 | 7348 | 5429 | 19565 | 5042 | 2403 | 2522 | 2386
1111 | [NAME] | VERIZON WIRELESS (MEMPHIS) | 1736 | 10276 | 10551 | 14493 | 12114 | 11087 | 14656 | 15152 | 14114 | 13059 | 13236 | 14790 | 15341
1111 | J98 | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1111 | L49 | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2222 | J33 | #N/A | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2222 | [NAME] | #N/A | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2222 | J38 | #N/A | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2222 | J39 | METROPCS | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2222 | J41 | #N/A | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2222 | J42 | #N/A | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2222 | [NAME] | #N/A | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2222 | [NAME] | #N/A | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2222 | J49 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2222 | J58 | #N/A | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2222 | J63 | #N/A | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2222 | J64 | METROPCS | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2222 | [NAME] | VERIZON WIRELESS (MEMPHIS) | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2222 | J98 | #N/A | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
2222 | L49 | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 848667d1699352461-sum-of-amount-based-on-categories-excel-test
Sheet: Blad1

Date | Specification | Location | Ammount | Category |  |  | Category | Yearly cost |  | Jan | Feb | Mar | Apr | Maj | Jun | Jul | Aug | Sep | Okt | Nov | Dec
2023-07-07 00:00:00 | [NAME] on bill | New york | 39 | Restaurants |  |  | Restaurants |  |  |  | 250 |  |  |  |  | 39
2023-01-30 00:00:00 | Storenamne Y on bill | Berlin | 101 | Clothes |  |  | Shopping online |  |  | 199.99
2023-02-10 00:00:00 | Storenamne Z on bill | London | 100 | Restaurants |  |  | Clothes | 101 |  | 101
2023-08-22 00:00:00 | Storenamne A on bill | Stockholm | 32 | Streaming |  |  | House Expense |  |  |  |  |  | 495.45
2023-01-03 00:00:00 | Storenamne B on bill | WWW.AMAZON.COM | 99.99 | Shopping online |  |  | Car |  |  | 85.79
2023-04-03 00:00:00 | [NAME] on bill | Paris | 495.45 | House expense |  |  | Telephone extense | 99
2023-02-03 00:00:00 | Storenamne 1 on bill | 633-2321-043443 | 99 | Telephone expense |  |  | Streaming | 32 |  |  |  |  |  |  |  |  | 32
2023-01-04 00:00:00 | [NAME] on bill | IRVINE | 85.79 | Car
2023-02-20 00:00:00 | Storenamne Z on bill | Paris | 150 | Restaurants
2023-01-14 00:00:00 |  |  | 100 | Shopping online
Spreadsheet: 872423d1718807473-sort-and-transpose-paradiser-speed-check
Sheet: WK-Ali

 | Kaline Trading Company Pvt.Ltd | Cont | JVN00203 | [NAME] | 609543911 | 0 | 1351.76 | 155.51 | Repair & Maintance-Electricals | 1196.25
2023-08-18 00:00:00 | Mata Hardware | Cont | [NAME] | Ma-2 | 300069242 | 0 | 776.83 | 89.37 | Repair & Maintenance Building |  | -687.46
2023-08-18 00:00:00 | Phonex Machinery & Tools | Cont | [NAME] | Ma-5 | 104224739 | 0 | 1988.8 | 228.8 | Combule | 1760
2023-08-20 00:00:00 | Elastics Lights & Electric Centre | Cont | JVN00211 | Ma-9 | 301647984 | 0 | 1887.1 | 217.1 | Repair & Maintance-Electricals | 1670
2023-08-20 00:00:00 | Mother dairy | Cont | JVN00212 | Ma-10 | 302009099 | 0 | 5190.02 | 597.08 | Combule | 4592.94
2023-08-20 00:00:00 | [NAME] | Cont | JVN00213 | Ma-11 | 300072334 | 0 | 1074.63 | 123.63 | Combule | 951
2023-08-18 00:00:00 | Myslef Freight Services Pvt Ltd | Cont | JVN00301 | [NAME] | [PHONE] | 0 | 586.22 | 67.44 | MBL MC 003ILUI230803002 | 518.78 |  | Jamal MC 57132 | -551
2023-08-18 00:00:00 | [NAME] | Cont | JVN00331** | Ma-114 | 609544808 | 0 | 52418.38 | 6111.56 | Freight [NAME] | 47012 |  | USD Payable-Int. @1.5% | -705.18
Spreadsheet: 108183d1305235781-changing-conditional-formatting-based-on-a-reference-kessler-1
Sheet: Sheet2

TICKER:
SIC: |  |  |  |  |  |  |  |  |  |  |  | 5 Year Common Sized Income Statement
GICS:
 |  |  |  |  |  |  |  |  |  |  |  | Item
Sales |  |  |  |  |  |  |  |  |  |  |  | sales
Cost of Sales |  |  |  |  |  |  |  |  |  |  |  | [NAME]
SG&&A |  |  |  |  |  |  |  |  |  |  |  | SG&A
Depreciation |  |  |  |  |  |  |  |  |  |  |  | Depr. & Amort.
EBIT |  |  |  |  |  |  |  |  |  |  |  | Op. Income After Depr.
Interest Expense |  |  |  |  |  |  |  |  |  |  |  | Intrest Expense
Nonop Income/Expense |  |  |  |  |  |  |  |  |  |  |  | Nonop Income/ Expense
Special Items |  |  |  |  |  |  |  |  |  |  |  | Special Items
Pretax Income |  |  |  |  |  |  |  |  |  |  |  | Pretax Income
Total Taxes |  |  |  |  |  |  |  |  |  |  |  | Total Taxes
Net Income |  |  |  |  |  |  |  |  |  |  |  | Net Income
Spreadsheet: 809874d1671398194-discount-rates-formula-and-npv-investment-model_help
Sheet: IRR of sum

 |  |  |  |  |  | 2022-12-01 00:00:00
 | Rental Revenue Discount Rate |  |  | 0.0686
 | Residual Value Discount Rate |  |  | 0.08
 | Cash Flow
 | Rental Revenue |  |  |  |  | 258545.86 | 258545.86 | 258545.86 | 258545.86 | 258545.86 | 258545.86 | 258545.86 | 258545.86 | 258545.86 | 258545.86 | 258545.86
 | Residual |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 17952165
 | Unlevered Cash Flow, PV
 | Residual, PV
 | Unlevered Present Value
 | Unlevered Cash Flow
 | Interest Expense |  |  |  |  | -44648.06712916667 | -44648.06712916667 | -44648.06712916667 | -44648.06712916667 | -44648.06712916667 | -44648.06712916667 | -44648.06712916667 | -44648.06712916667 | -44648.06712916667 | -44648.06712916667 | -44648.06712916667
 | [NAME]
 | Residual
 | Debt Payoff |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -15307908.73
 | Net Residual |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME], PV
 | Net Residual, PV
 | Levered Present Value
 |  |  |  |  | Total NPV |  |  |  |  | exact NPV
 |  |  |  |  | IRR CF
 |  |  |  |  | IRR |  |  |  |  | exact IRR
 |  |  |  | Proof of Concept (IRR of sum of unlevered and levered CFs)
 |  |  |  | Unlevered CF PV
 |  |  |  | Residual CF PV
 |  |  |  | Unlevered NPV
 |  |  |  | [NAME]
 |  |  |  | Net Residual PV
 |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Difference
 |  |  |  |  | Total NPV |  |  |  |  | exact NPV
 |  |  |  | [NAME] |  |  |  |  |  | exact NPV
Spreadsheet: 038605e1-a6ad-4351-af1d-5a79beb55b10
Sheet: 6.7.13 to 8.15.13

Treatment | D1 | D2 | D3 | D4 | D5 | D6 | D7 | Grand Total
Assessment ONLY | 5481.030000000002 | 1303.97 | 10763.67 | 17584.01 | 434.02 | 5580.230000000003 | 4712.200000000002 | 45859.13000000001
Institution Assessment | 4165.5 | 1364.05 | 13566.09999999999 | 7700.710000000005 |  | 5505.81 | 2827.31 | 35129.48
Institution Assessment - Travel | 93.27000000000001 | 346.5 | 1212.84 | 27.68 |  | 110.92 | 56.6 | 1847.81
IDOC - Pre-Treatment Services | 5266.340000000002 | 1885.96 | 11290.00999999998 | 20388.05999999992 | 3533.659999999998 | 7230.600000000012 | 5191.950000000002 | 54786.57999999992
IDOC - Stage 1: Level I - Outpatient | 12020.12999999999 | 12530.94000000003 | 24617.69999999983 | 51962.88999999939 | 9186.310000000001 | 13173.79999999999 | 10748.63999999997 | 134240.4099999992
IDOC - Stage 1: Level II - Intensive Outpatient | 1724.55 | 13334.37999999998 | 12402.46999999998 | 20103.10999999996 | 2663.18 | 12866.88999999999 | 3628.750000000003 | 66723.32999999991
IDOC - Stage 2: Level I - Outpatient | 13352.36999999998 | 10973.68000000001 | 31713.68999999975 | 42796.14999999965 | 17100.94999999996 | 21493.11999999991 | 11796.87 | 149226.8299999993
IDOC - Stage 2: Level II - Intensive Outpatient | 620.32 | 16900.97999999998 | 6229.460000000004 | 12944.51000000004 | 682.6599999999999 | 6178.970000000008 | 5602.160000000006 | 49159.06000000003
Level III.2 - Adult Detoxification | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total
Support Services
Child Care | 0 | 0 | 0 | 0 | 0 | 0 | 0
Drug Testing | 5737.5 | 6520.5 | 8734.5 | 19399.5 | 4951.5 | 1930.5 | 256.5 | 47530.5
IDOC - Case Management (Basic & Intensive) | 471.28 | 1877.279999999999 | 4440.559999999989 | 17334.84 | 1539.879999999999 | 7495.729999999984 | 3590.239999999992 | 36749.80999999996
IDOC - Life Skills (Individual & Group) |  | 112.88 | 47.28 | 875.5799999999997 |  | 104.96 | 26.24 | 1166.94
Oral Interpreter / Sign Language (includes travel) |  |  |  |  |  | 200 |  | 200
Staffed Safe and Sober Adult Housing | 2070 | 598 | 1805.5 | 20723 |  |  | 322 | 25518.5
Transportation |  | 2192.220000000003 | 1413.170000000003 | 14098.34999999991 | 1585.68 | 3574.650000000006 | 2502.000000000001 | 25366.06999999992
Total
Administrative Cost
Direct Client Services - Screening & Chart Review |  |  |  |  |  |  |  | 80481.81
Total
Grand Total
Count of Paid Units | 1278 | 1662 | 3157 | 8766 | 1222 | 1930 | 1291
Average Cost per Unit of Care
Substance Abuse Treatment - ASAM | 662 | 968 | 1982 | 3734 | 647 | 1282 | 853
Average Treatment Cost per Client
Supportive Services | 616 | 694 | 1175 | 5032 | 575 | 648 | 438
Average Supportive Services Cost
Average of Length of Stay | 169.2112676056338 | 163.7683513838749 | 156.5327842888819 | 135.9869952087611 | 176.607201309329 | 186.6922279792746 | 167.9728892331526
Unique Client Counts  (8/18/13)
 | Client Region | Provider Region
Region 1 | 109 | 118
Region 2 | 49 | 50
Region 3 | 183 | 202
Region 4 | 262 | 249
Region 5 | 77 | 75
Region 6 | 136 | 137
Region 7 | 88 | 94
Region None | 17 | 0
Total | 921 | 921
Spreadsheet: 712859d1610456568-count-ids-within-a-timescale-duplicate-ids-with-multiple-visit-dates-book1
Sheet: Sheet1

ID | Plan Start Date | Plan End Date | Date of Visit | ID2 | Days Since Previous Visit | Less than 2 weeks? |  |  |  | Report Date (w/e) | Number of visits within timescale (2 weeks)
536247 | 2019-09-26 00:00:00 | 2020-07-17 00:00:00 | 2020-03-04 00:00:00 |  |  |  |  |  |  | 2020-04-05 00:00:00 | 2
536247 | 2019-09-26 00:00:00 | 2020-07-17 00:00:00 | 2020-03-13 00:00:00 |  |  |  |  |  |  | 2020-04-12 00:00:00 | 2
536247 | 2019-09-26 00:00:00 | 2020-07-17 00:00:00 | 2020-03-17 00:00:00 |  |  |  |  |  |  | 2020-04-19 00:00:00
536247 | 2019-09-26 00:00:00 | 2020-07-17 00:00:00 | 2020-03-20 00:00:00 |  |  |  |  |  |  | 2020-04-26 00:00:00
536247 | 2019-09-26 00:00:00 | 2020-07-17 00:00:00 | 2020-03-30 00:00:00 |  |  |  |  |  |  | 2020-05-03 00:00:00
536247 | 2019-09-26 00:00:00 | 2020-07-17 00:00:00 | 2020-04-15 00:00:00 |  |  |  |  |  |  | 2020-05-10 00:00:00
536247 | 2019-09-26 00:00:00 | 2020-07-17 00:00:00 | 2020-04-22 00:00:00 |  |  |  |  |  |  | 2020-05-17 00:00:00
536247 | 2019-09-26 00:00:00 | 2020-07-17 00:00:00 | 2020-05-13 00:00:00 |  |  |  |  |  |  | 2020-05-24 00:00:00
536247 | 2019-09-26 00:00:00 | 2020-07-17 00:00:00 | 2020-05-15 00:00:00
536247 | 2019-09-26 00:00:00 | 2020-07-17 00:00:00 | 2020-05-28 00:00:00
536247 | 2019-09-26 00:00:00 | 2020-07-17 00:00:00 | 2020-06-11 00:00:00
536247 | 2019-09-26 00:00:00 | 2020-07-17 00:00:00 | 2020-09-30 00:00:00
1538276 | 2020-06-04 00:00:00 |  | 2020-06-16 00:00:00
1538276 | 2020-06-04 00:00:00 |  | 2020-06-30 00:00:00
1538276 | 2020-06-04 00:00:00 |  | 2020-07-08 00:00:00
1538276 | 2020-06-04 00:00:00 |  | 2020-07-21 00:00:00
1538276 | 2020-06-04 00:00:00 |  | 2020-08-06 00:00:00
1538276 | 2020-06-04 00:00:00 |  | 2020-08-24 00:00:00
1538276 | 2020-06-04 00:00:00 |  | 2020-09-07 00:00:00
1538276 | 2020-06-04 00:00:00 |  | 2020-09-25 00:00:00
1538276 | 2020-06-04 00:00:00 |  | 2020-10-13 00:00:00
1538276 | 2020-06-04 00:00:00 |  | 2020-10-28 00:00:00
1538276 | 2020-06-04 00:00:00 |  | 2020-11-12 00:00:00
1538276 | 2020-06-04 00:00:00 |  | 2020-12-10 00:00:00
1538276 | 2020-06-04 00:00:00 |  | 2020-12-18 00:00:00
53836623 | 2018-10-25 00:00:00 |  | 2020-03-03 00:00:00
53836623 | 2018-10-25 00:00:00 |  | 2020-03-05 00:00:00
53836623 | 2018-10-25 00:00:00 |  | 2020-03-25 00:00:00
53836623 | 2018-10-25 00:00:00 |  | 2020-04-03 00:00:00
53836623 | 2018-10-25 00:00:00 |  | 2020-04-29 00:00:00
53836623 | 2018-10-25 00:00:00 |  | 2020-04-30 00:00:00
53836623 | 2018-10-25 00:00:00 |  | 2020-05-05 00:00:00
53836623 | 2018-10-25 00:00:00 |  | 2020-05-11 00:00:00
53836623 | 2018-10-25 00:00:00 |  | 2020-06-03 00:00:00
53836623 | 2018-10-25 00:00:00 |  | 2020-06-08 00:00:00
53836623 | 2018-10-25 00:00:00 |  | 2020-06-12 00:00:00
53836623 | 2018-10-25 00:00:00 |  | 2020-06-16 00:00:00
Spreadsheet: 874941d1721457081-how-to-get-the-number-after-the-country-name-to-match-the-country-name-0720
Sheet: Sheet1

 |  | USA | France | India | China | Russia | Germany | Japan
Column1 |  | 38 | 26 | 0 | 35 | 0 | 0 | 0
China35，France26，USA38 |  | 69 | 0 | 0 | 68 | 0 | 45 | 0
China68，USA69，Germany45 |  | 0 | 0 | 32 | 0 | 65 | 0 | 38
India32，Russia65，Japan38
 |  | China | France | USA | Germany | India | Russia | Japan
 |  | 35 | 26 | 38 | 45 | 32 | 65 | 38
 |  | 68 |  | 69
Spreadsheet: 87800d1287664743-assigning-specific-values-to-strings-and-or-numbers-qa-1-
Sheet: Sheet1

 |  |  | [NAME] | [NAME] | [NAME] | [NAME] | Julie | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Julie | [NAME] | [NAME]
 | Question | Answer | Answer | Answer | Answer | Answer | Answer | Answer | Answer | Score | Score | Score | Score | Score | Score | Score | Notes
1 | What is 75+2? | 76 | 99 | 75 | 88 | 77 | 21 | 80 | 78 |  |  |  |  |  |  |  | No-one has answered correctly but two people are the closest (Jim & Barbara) so they would each get 1 point
2 | What is the capital of England? | London | Prague | London | Lisbon | Madrid | London | Cardiff | Edinburgh |  |  |  |  |  |  |  | 2 people have answered correctly (Jim & Julie) so they would get 2 points each
3 | How many letters in the word "Sink"? | 4 | 4 | 6 | 5 | 2 | 4 | 1 | 8 |  |  |  |  |  |  |  | 2 people have answered correctly (John & Julie) so they would get 2 points each
4 | What is the tallest mountain in the world? | Everest | Everest | [NAME] | [NAME] | Everest | Everest | Matterhorn | Everest |  |  |  |  |  |  |  | 3 people have answered correctly ([NAME], [NAME] and [NAME]) so they would get 2 points each
5 | What is 2+2 | 4 | 22 | 1 | 5 | 6 | 7 | 4 | 5 |  |  |  |  |  |  |  | Only one person has answered correctly ([NAME]) so she would get 2 points
Spreadsheet: 885836d1735702021-generating-a-sequential-enquiry-number-using-a-formula-leasehold-enquiry-tracker-test-copy4
Sheet: Configuration

 | CONFIGURATION
 | Enquiry type |  | Customer status |  | Follow-up | Follow number |  | Actions required |  | Coded actions
 | Access |  | Active |  | Not required | 0 |  | Telephone call |  | Advice sought from Legal
 | Buy Back |  | Not active |  | 1 day | 1 |  | [NAME] |  | Advised leaseholder
 | Electrical check |  |  |  | 2 day | 2 |  | Raise invoice |  | Advised on buy-back process
 | Environmental |  |  |  | 3 day | 3 |  | Arrange visit |  | Advised on documents required
 | Finance |  |  |  | 4 day | 4 |  | Visit leaseholder |  | Advised on process
 | Fire door |  |  |  | 5 day | 5 |  |  |  | Inspection arranged
 | Flat sale |  |  |  | 1 week | 7 |  |  |  | Information provided
 | General |  |  |  | 2 weeks | 10 |  |  |  | Invoice raised
 | Guarantee |  |  |  | 3 weeks | 15 |  |  |  | Referred to contractor
 | [NAME] |  |  |  | 4 weeks | 20 |  |  |  | Referred to Environmental Services
 | Length of lease |  |  |  | 6 weeks | 30 |  |  |  | Referred to Legal
 | Permission |  |  |  | 2 months | 40 |  |  |  | Referred to Repairs
 | Re-imbursement |  |  |  | 3 months | 60 |  |  |  | Referred to Compliance team
 | Repair |  |  |  | 4 months | 80 |  |  |  | Referred to [NAME]
 | Repair (damp and mould) |  |  |  | 6 months | 120 |  |  |  | Reimbursement arranged
 | Repossession |  |  |  | 12 months | 260 |  |  |  | Repair raised
 | [NAME] |  |  |  | 2 years | 520 |  |  |  | Visit arranged
 | Smoke alarm
 | Upgrade
Spreadsheet: 848585d1699291109-random-numbers-six-average-numbers
Sheet: Hoja1

 |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | Aux
 |  |  |  |  | Average Value | 48.4
Spreadsheet: 117390d1312760946-excel-automatically-creates-borders-help-please-book-1
Sheet: Vali's

[NAME] |  | Yes |  | MS
[NAME] |  | No |  | IC
[NAME] |  |  |  | HR
S. Chahal |  |  |  | PH
[NAME] |  |  |  | [NAME]
G Gill |  |  |  | MF
[NAME]
[NAME]
[NAME]
[NAME]
Allow
Dismiss