tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 866386d1713311718-help-extracting-specific-text-from-inconsistent-text-strings-sample-dataset
Sheet: Sheet1

 |  |  |  |  | Repeat down by QTY |  | RESULT
Invoice | Code Item | Description | QTY |  | Invoice | Code Item | Description | No Cont
45835 | PR1 | Plugging Reefer  (Quantity : 4.00) MRTU6201595MRTU6201620MRTU6202415MRTU6202842 | 4 |  | 45835 | PR1 | Plugging Reefer  (Quantity : 4.00) MRTU6201595MRTU6201620MRTU6202415MRTU6202842 | MRTU6201595
45884 | PR1 | Plugging Reefer  (Quantity : 6.00) MRTU6200768MRTU6201126MRTU6201403MRTU6201487MRTU6201609MRTU6202734 | 6 |  | 45835 | PR1 | Plugging Reefer  (Quantity : 4.00) MRTU6201595MRTU6201620MRTU6202415MRTU6202842 | MRTU6201620
17168 | PR1 | Plugging Reefer  (Quantity : 6.00) MRTU6201738MRTU6202689MRTU6200074MRTU6201825MRTU6202230MRTU6201717 | 6 |  | 45835 | PR1 | Plugging Reefer  (Quantity : 4.00) MRTU6201595MRTU6201620MRTU6202415MRTU6202842 | MRTU6202415
33593 | SI1 | KOE240000059 STUFFING IN : MRTU2090087.FCIU6090526.MRTU2138344 LIFT ON EMPTY : MRTU2126493.MRTU2058450M | 3 |  | 45835 | PR1 | Plugging Reefer  (Quantity : 4.00) MRTU6201595MRTU6201620MRTU6202415MRTU6202842 | MRTU6202842
33593 | LE1 | KOE240000059 STUFFING IN : MRTU2090087.FCIU6090526.MRTU2138344 LIFT ON EMPTY : MRTU2126493.MRTU205845M | 2 |  | . | . | . | .
9749 | RC1 | REPAIR CONTAINER MRLU5213735 | 1 |  | . | . | . | .
10836 | TI1 | PENGAJUAN VAS TAMBAH ISI DEPO TJ TEMBAGA (BURUH CUSTOMER)VAS JO.             : SUB240000038No. Cont          : FCIU6079770 . MRTU2108118(Quantity : 2.00) | 2 |  | . | . | . | .
10984 | AK1 | ALIH KAPAL MRTU9601018 MRTU9605369 MRTU9606112 MRTU9607417 MRTU9610703 | 5 |  | . | . | . | .
19907 | AK1 | SRG240000004Â = (Quantity : 10.00)ALIH KAPAL 10X40HC - CMAU4055686 MRLU5213735 MRTU9614524 MRTU9615011 MRTU9615599 SEGU5089690 TCLU1740099 TCNU3866360 TDRU4260878 TGHU6957173 | 10 |  | 33593 | SI1 | KOE240000059 STUFFING IN : MRTU2090087.FCIU6090526.MRTU2138344 LIFT ON EMPTY : MRTU2126493.MRTU2058450M | MRTU2090087
22187 | TRF1 | THC & RELOKASI FULL FCIU6077252. MRTU2067087. MRTU2168056 | 3 |  | 33593 | SI1 | KOE240000059 STUFFING IN : MRTU2090087.FCIU6090526.MRTU2138344 LIFT ON EMPTY : MRTU2126493.MRTU2058450M | FCIU6090526
 |  |  |  |  | 33593 | SI1 | KOE240000059 STUFFING IN : MRTU2090087.FCIU6090526.MRTU2138344 LIFT ON EMPTY : MRTU2126493.MRTU2058450M | MRTU2138344
 |  |  |  |  | 33593 | LE1 | KOE240000059 STUFFING IN : MRTU2090087.FCIU6090526.MRTU2138344 LIFT ON EMPTY : MRTU2126493.MRTU2058450M | MRTU2126493
 |  |  |  |  | 33593 | LE1 | KOE240000059 STUFFING IN : MRTU2090087.FCIU6090526.MRTU2138344 LIFT ON EMPTY : MRTU2126493.MRTU2058450M | MRTU205845
 | Note :
 | PR1 | Plugging reefer
 | SI1 | STUFFING IN
 | LE1 | LIFT ON EMPTY
 | RC1 | REPAIR CONTAINER
 | TI1 | TAMBAH ISI
 | AK1 | ALIH KAPAL
 | TRF1 | THC & RELOKASI FULL
Spreadsheet: 849202d1699724516-repeat-a-formula-x-times-dynamic-and-automatic-formula-x-times
Sheet: Sheet1

At present the formula in column D needs copying down to each row which isn't helpful because list of 'Names' in column B and C are changing daily.
Is there any way to have a dynamically updating array formula in column D (that doesn't slow down Excel when there are 60k rows)
In my head I feel like I would love a formula to find the last row in column B and then have excel effectively drag down the formula that many times from D6 onwards. (I would want this to be automatic though)
 | Names | Positions | Team Leader - What I Would Like Without Copying Down | [NAME] I Tried but it Doesn't Fill The All Cells Correctly | Helper For Column G | Works but Unefficent When Run Across 60K Rows
 | [NAME] | Leader
 | [NAME] | Member 1 |  | [NAME] I Tried but it Doesn't Fill The All Cells Correctly |  | [NAME]
 | [NAME] | Member 2 |  | [NAME] I Tried but it Doesn't Fill The All Cells Correctly |  | [NAME]
 | Sandy | Leader |  | Sandy | 9 | Sandy
 | Troy | Leader |  | Troy | 10 | Troy
 | [NAME] | Member 1 |  | [NAME] I Tried but it Doesn't Fill The All Cells Correctly |  | Troy
 | Dwane | Member 2 |  | [NAME] I Tried but it Doesn't Fill The All Cells Correctly |  | Troy
 | Shona | Member 3 |  | [NAME] I Tried but it Doesn't Fill The All Cells Correctly |  | Troy
 | Toni | Member 4 |  | [NAME] I Tried but it Doesn't Fill The All Cells Correctly |  | Troy
 | [NAME] | Leader |  | [NAME] | 15 | [NAME]
 | Marvin | Member 1 |  | [NAME] I Tried but it Doesn't Fill The All Cells Correctly |  | [NAME]
 | Mark | Leader |  | Mark | 17 | Mark
 | Joy | Member 1 |  | [NAME] I Tried but it Doesn't Fill The All Cells Correctly |  | Mark
 | Winston | Member 2 |  | [NAME] I Tried but it Doesn't Fill The All Cells Correctly |  | Mark
 | Bella-Anne | Leader |  | Bella-Anne | 20 | Bella-Anne
Spreadsheet: 8bf511d2-0362-409d-b006-470e39a601d3
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24
Please complete the following questions regarding your automobile accident. Please complete this form carefully as the information provided will assist the doctor in evaluating and documenting your condition.  THANK YOU! |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Patient Name:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date: |  |  |  |  | ID#:
VEHICLE YOU WERE IN
Vehicle type?
Vehicle size?
What was your location in the vehicle?
Passenger location:
What was the vehicle you were in doing?
What damage did the vehicle you were in sustain?
IF OTHER VEHICLES WERE INVOLVED IN ACCIDENT
First Vehicle to Strike Vehicle You Were In
Vehicle type?
Vehicle size?
How did this vehicle strike the vehicle you were in?
What damage did this vehicle sustain?
Second Vehicle to [NAME] You Were In
Vehicle type?
Vehicle size?
How did this vehicle strike the vehicle you were in?
What damage did this vehicle sustain?
CONDITIONS AT TIME OF ACCIDENT
What time of day did the accident occur?
What was the condition of the road?
Visibility
 | What was the visibility at impact?
 | If visibiliity was poor, why?
Patient Signature:
AT MOMENT OF IMPACT
Were you prepared for the accident?
Foot on Brake Pedal
 | Was your foot on the brake pedal at impact?
 | Was it knocked off pedal by impact?
Use of Restraints
 | Were you wearing a restraint belt?
 | What type of restraint belt were you wearing?
 | Was vehicle equipped with headrests?
 | What position was the headrest in?
 | Was vehicle equipped with air bags?
 | Did the air bags deploy?
Your Body
 | What was your body position at impact?
 |  |  |  |  |  |  |  |  |  |  |  | Rotated:
 | What direction was your body thrown?
Your Head and Neck
 | What position were your head / neck in at impact?
 |  |  |  |  |  |  |  |  |  |  |  | Rotated:
 | Through what motion were your head / neck pitched?
AT MOMENT OF IMPACT
Which objects in the vehicle did the force of the collision cause your body to strike? Please note what your body struck.
 | Head
 | Right Upper Extremity (Arm)
 | Left Upper Extremity (Arm)
 | Torso
 | Right Lower Extremity (Leg)
 | Left Lower Extremity (Leg)
Did your body strike any other objects?  If yes, please describe:
Patient Signature: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Today's Date:
Spreadsheet: 485310d1476813603-trying-to-make-a-payroll-form-that-divides-reg-time-and-ot-after-8-and-after-44-hours-payroll-aligw
Sheet: Sheet1

 |  |  |  |  |  |  | PAY ROLL FORM
 | Date | Day 1 |  |  | Day 2 |  |  | Day 3 |  |  | Day 4 |  |  | Day 5 |  |  | Day 6 |  |  | Day 7 |  |  | Week Totals
Employee |  | Total | Reg | OT | Total | Reg | OT | Total | Reg | OT | Total | Reg | OT | Total | Reg | OT | Total | Reg | OT | Total | Reg | OT | Total | Reg | OT |  |  | OT after in one day |  |  | 8
 |  | 12 |  |  | 12 |  |  | 12 |  |  | 12 |  |  | 12 |  |  | 12 |  |  | 12 |  |  |  |  |  |  |  | OT after in one week |  |  | 44
 | Date | Day 8 |  |  | Day 9 |  |  | Day 10 |  |  | Day 11 |  |  | Day 12 |  |  | Day 13 |  |  | Day 14 |  |  | Week Totals |  |  |  | 2 Week Totals
Employee |  | Total | Reg | OT | Total | Reg | OT | Total | Reg | OT | Total | Reg | OT | Total | Reg | OT | Total | Reg | OT | Total | Reg | OT | Total | Reg | OT |  | Total | Reg | OT
 |  | 8 |  |  | 8 |  |  | 8 |  |  | 8 |  |  | 8 |  |  | 8 |  |  | 8
Spreadsheet: 775249d1648938902-data-validation-list-not-working-using-dynamic-array-from-table-datavalidn-from-dynarray
Sheet: Sheet1

 | Vendor | [NAME] |  | Selected Vendor
 | Acme | SRX 4100 support |  | Acme
 | Internal | Senior [NAME]
 | Internal | Logistics |  | Required validation list
 | Acme | EX 4300 support
 |  |  |  | EX 4300 support
 |  |  |  | Lst_Test
 |  |  |  | EX 4300 support
 |  |  |  | Data Validation | NOT WORKING
Spreadsheet: daren_farmer__5658__HPLN0103
Sheet: Sheet1

HPLN0103.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - Januar 3, 2001
 |  |  |  |  |  | **Wednesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2001-01-02 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL | 30 | 30
 |  | Firm Summary
Enron (S) |  | Oasis Sealy |  | Enron | 50 | 0
Enron (S) |  | Texoma |  | Enron | 0 | 15
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: louise_kitchen__24127__North America Plan 01-02
Sheet: Natural Gas Admin

 | Natural Gas Admins
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % | 2002
 |  | YTD Actual |  | Forecast |  | of Total | Plan
ENACOMP | Compensation |  |  |  |  |  |  | Compensation | 0
 | Special Pays |  |  | 0 |  |  | 0
 | Analyst & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense |  |  |  |  |  | 24000
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  | 15000 | Total
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense |  |  |  |  |  | 20000
ENAMKTEX | Marketing |  |  |  |  |  |  | Intern | 33000
ENACONTR | Charitable Contributions |  |  |  |  |  | 0 | [NAME] | 48400
ENARENT | Rent |  |  |  |  |  | 0 | Staff | 49500 | 0
ENATECH | Technology |  |  |  |  |  | 10000 | Specialist | 57750 | 0
ENATRANS | Transportation |  |  |  |  |  | 0 | Sr. Specialist | 71500 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  | 5000 | Analyst | 60500 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  |  | Associate | 89100 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager | 110000 | 0
 |  |  |  |  |  |  |  | Director | 143000 | 0
 | Headcount |  |  |  |  |  |  | Sr. Director | 165000 | 0
 |  |  |  |  |  |  |  | VP | 198000 | 0
 | A&A Headcount |  |  |  |  |  |  | MD | 220000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 254512
 |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 810445d1671773383-autofill-cell-based-on-cell-on-another-sheet-mock-up-ans
Sheet: 707- Reporting

AUDIT COMMENTS / CORRECTIVE ACTION PLAN |  |  |  |  |  | Page | 1 | Of | 1
No. | Criteria Number | Unsatisfactory Condition Observed |  |  | Corrective Action |  | By whom | Date
 |  |  |  |  |  |  |  | Target | Re-evaluation | Completion
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
Issue: 1 |  | Rev. No. : 0 |  | Date: 01-Jan-08 |  | FORM.707 |  | Page 6 of 6
Spreadsheet: 696111d1600634003-help-with-a-complicated-time-sheet-shane-time-sheet
Sheet: Basic with Breaks and Overtime

Name : | [NAME] |  |  |  |  |  |  | For your convinience, this section is out of the printable area.
[NAME]: | 11
Overtime Rate: | 16.5 |  |  |  |  |  |  | Download  more templates
 |  |  |  |  |  |  |  | Learn how to create your own template
Date | Log in | [NAME] | Lunch Ends | Log Out | Regular Hours | Overtime Hours
Monday | 09:00:00 | 13:00:00 | 13:30:00 | 18:00:00 | 8 | 0.5
Tuesday | 09:20:00 | 11:57:00 | 12:15:00 | 18:00:00 | 8 | 0.3666666666666671
Wednesday | 09:00:00 | 12:00:00 | 12:32:00 | 17:15:00 | 7.716666666666666 | 0
Thursday |  |  |  |  | 0 | 0
Friday |  |  |  |  | 0 | 0
Saturday |  |  |  |  | 0 | 0
Sunday |  |  |  |  | 0 | 0
 |  |  |  | Total Hours | 23.71666666666667 | 0.8666666666666671
 |  |  |  | Pay | 260.8833333333333 | 14.30000000000001
 |  |  |  |  | Total Pay | 275.1833333333333
Spreadsheet: phillip_m_love__30649__9907_OA
Sheet: EAST-EGM-GL

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  ECTR (EGM)
REGION:  NORTHEAST
 |  |  | Total |  | Reclasses |  |  |  |  |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations |  |  |  |  |  |  |  |  |  | 93000
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance |  |  |  |  |  |  |  | 0
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations |  |  |  |  |  |  |  | 213900 |  |  |  | 47200
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
FT-East
 |  | Current Month MTM |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Financial Liquidations |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Originations |  |  |  |  | 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 FIRM TRADING
 |  | TOTAL GL
Spreadsheet: 144257d1330858986-skipping-cells-for-a-formula-and-date-day-problem-budget-example
Sheet: DEVELOPMENT

February
 |  |  |  | Purchase Types
*Do not add more than this # of - affects SUMPRODUCT! [need to modify every formula!!]
Week 1 | 2012-02-01 00:00:00
Date | INC/EXP/REP | Mark | Gross Amt | Surc | Final Amt | Cashflow Type | Account Affected | Origin/Recipient | Location | Share Amount | Ext Rep | Account | Description
Week 2 |  |  | 2012-02-05 00:00:00 |  | 2012-02-11 00:00:00
Week 3 |  |  | 2012-02-12 00:00:00 |  | 2012-02-18 00:00:00
Week 4 |  |  | 2012-02-19 00:00:00 |  | 2012-02-25 00:00:00
Week 5 |  |  | 2012-02-26 00:00:00 |  | 2012-02-29 00:00:00
Week 6
Weekly Summaries
Week 1
Total Income
Total Expenses
Profit/Loss
Family Credit
Other Credit
Repayments
 |  |  |  |  |  | Monthly Summary
 |  |  |  |  |  | Purchase Accounts | Spend | Expense Accounts | Spend | Cash Positions | Value
 |  |  |  |  |  | Credit Provided |  | Total Monthly Expenses |  | Current Position
 |  |  |  |  |  |  |  |  |  | PERSONAL
 |  |  |  |  |  |  |  |  |  | FAMILY Credit
 |  |  |  |  |  |  |  |  |  | 28 Degrees | 0
 |  |  |  |  |  | Family Credit Balance
 |  |  |  |  |  |  |  |  |  | OTHER Credit
 |  |  |  |  |  |  |  |  |  | Amex Ultimate
 |  |  |  |  |  |  |  |  |  | 28 Degrees
 |  |  |  |  |  |  |  |  |  | WOW Master
 |  |  |  |  |  |  |  |  |  | ANZ Amex Plat
 |  |  |  |  |  |  |  |  |  | Holding Account
 |  |  |  |  |  |  |  |  |  | Amex Ultimate
 |  |  |  |  |  |  |  |  |  | 28 Degrees
 |  |  |  |  |  |  |  |  |  | WOW Master
 |  |  |  |  |  |  |  |  |  | ANZ Amex Plat
 |  |  |  |  |  |  |  |  |  | Starting Balance
 |  |  |  |  |  |  |  |  |  |  | 200
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 200
 |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 164225d1340700710-breakup-phone-bill-pivottable-1-
Sheet: Mobile Calls

Mobile Calls
Unit | Date | Time | Duration | Call Type | Rate | Amount
001 | 2012-03-28 00:00:00 | 13:32:00 | 00:00:33 | MOBCL | P
001 | 2012-03-29 00:00:00 | 18:51:00 | 00:04:25 | MOBCL | O
001 | 2012-03-30 00:00:00 | 10:28:00 | 00:02:59 | MOBCL | P
001 | 2012-04-04 00:00:00 | 19:16:00 | 00:00:29 | MOBCL | O
001 | 2012-04-10 00:00:00 | 10:45:00 | 00:39:41 | MOBCL | P
001 | 2012-04-15 00:00:00 | 10:53:00 | 00:00:26 | MOBCL | W
001 | 2012-04-15 00:00:00 | 12:24:00 | 00:00:13 | MOBCL | W
001 | 2012-04-17 00:00:00 | 18:50:00 | 00:03:10 | MOBCL | O
001 | 2012-04-17 00:00:00 | 18:44:00 | 00:00:43 | MOBCL | O
001 | 2012-04-19 00:00:00 | 18:36:00 | 00:05:46 | MOBCL | O
001 | 2012-04-19 00:00:00 | 08:15:00 | 00:00:08 | MOBCL | P
001 | 2012-04-22 00:00:00 | 10:11:00 | 00:03:16 | MOBCL | W
001 | 2012-04-22 00:00:00 | 10:11:00 | 00:00:18 | MOBCL | W
001 | 2012-04-22 00:00:00 | 10:04:00 | 00:05:14 | MOBCL | W
001 | 2012-04-23 00:00:00 | 10:02:00 | 00:10:26 | MOBCL | P
001 | 2012-04-25 00:00:00 | 14:04:00 | 00:01:30 | MOBCL | P
Total Calls/Events |  |  | Total Duration |  |  | Amount
15
Spreadsheet: 868234d1714981536-tier-incentive-will-be-automatically-calculated-based-on-tier-doctors-calculation-april-2024-allan-sampling-of-doing-formula-copy-1-aligw
Sheet: Dr. Teeb

Contract Terms (*)
 |  | 1- Revenue Target on Dental Procedure | Incentive
 |  | Tier 1 - 24,001 to 34,000 | 0.05
 |  | Tier 1 - 34,001 to 44,000 | 0.075
 |  | [NAME] to 54,000 | 0.1
 |  | [NAME] 64,000 | 0.125
 |  | [NAME] to 74,000 | 0.15
 |  | Tier 5 - 74,001 & Above | 0.175
 |  | 2- Incentive on Implant Procedure | 0.3
Doctor Calculation
 |  | Gross Revenue | 83489
 |  | Doctor Revenue Dental Procedure | 59750
 |  | Clinic Fees 5%
 |  | Dental Lab | 11399
 |  | OR
 |  | Net Revenue
 |  | Amount to be Paid
 |  | Doctor Revenue Implant Procedure | 23740
 |  | Clinic Fees 5%
 |  | Consumables | 6500
 |  | Net Revenue
 |  | Amount to be Paid
 |  | * Implant Cost : SAR 650
 |  | Total Amount to be Paid
Prepared By …................. |  |  |  | CFO: | .......................
 |  |  |  |  |  |  |  |  |  | Operations Report on February - 2021
 |  |  |  |  |  |  |  |  |  | # | Day/Date | Time In | Time Out | Total Time | Patient Name and file number |  | [NAME] | Surgeon | Anesthesia | Amount
 |  |  |  |  |  |  |  |  |  | 1 | Saturday 13-02-2021 | 09:40:00 | 12:54:00 | 03:14:00 | [NAME] A latebi 10035632 |  | Dental Treatment | Dr Teeb | GA
Spreadsheet: 123376d1317633331-linest-gives-same-parameters-different-r2-checklinest
Sheet: Sheet1

x1 | x2 | [NAME] | y |  | model1 |  |  | model1
 | 0 | 0 |  |  | y = b0+b1*x1 |  |  | y = b0+b1*x1+b2*x2+b3*x3
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0 |  |  |  |  |  |  | check
 | 0 | 0 |  |  | RSS
 | 0 | 0 |  |  | R2
 | 0 | 0 |  |  | b0
 | 0 | 0 |  |  | b1
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
Spreadsheet: 056b6c43-e4a1-478e-a5a4-21f345192453
Sheet: Sheet1

OPERATING/PROGRAMMATIC | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Legislative Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | 2008 Water Rate Increase
Does this Legislation Estimate New or Additional Revenues to the City? |  |  |  |  |  |  |  | No |  | X | Yes
 | If yes, please identify in  which Fund these revenues will be deposited (e.g. General, Sales Tax)
 | and provide the following revenue information:
 | Revenue Detail |  |  |  | FY 2007-08 |  |  | FY 2008-09
 | General Fund
 | Special Revenue
 | Enterprise |  |  |  |  |  |  | 9000000
 |  |  | Total: | $ |  |  | $ | 9000000
 | (Please detail type of revenue (fees, grants, tax) and change that will occur as a result of this legislation.  Provide multi-year
 | estimates if known, or if grant revenue please identify source of funds (federal or state) and duration of grant support)
Does this Legislation increase appropriations in the current budget? |  |  |  |  |  |  | X | No |  |  | Yes
 | If Yes, please complete the following budget information:
 | Expense Detail |  |  |  | FY 2007-08 |  |  | FY 2008-09
 | General Fund
 | Special Revenue
 | Enterprise/Other
 |  |  | Total: | $ | 0 |  | $ | 0
 | Please detail the extent to which these increased appropriations will be of a permanent nature (e.g. number of
 | additional staff, facilities, long-term contracts)
Does this Legislation expand the scope of current city services? |  |  |  |  |  |  | X | No |  |  | Yes
 | (Please detail estimate number of people to be served, who is delivering services currently to that population, service
 | performance expectations, and if grant supported, provisions for support if grant support ends.
Is this legislation the result of a federal or state legislative mandate? |  |  |  |  |  |  | X | No |  |  | Yes
 | (If yes, please detail the purpose and source for that mandate).
Reviewed by:
 | 0ffice of Management and Budget |  |  | OMB Approval Date
Spreadsheet: 701633d1603865616-adjusting-my-if-formula-book1-triggered-copy
Sheet: Sheet1

Entry Price | Stop Price | Triggered | Current Price | Long/Short | Alternative of column C | New one
121.13 | 104.02 |  | 118.99
121.13 | 104.02 |  | 122.84
101.3 | 111.34 |  | 100.42
1326 | 1429 |  | 1433
1532 | 1403 |  | 1433