tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 77477d1277932355-excel-2003-deleting-rows-shortens-references-from-other-worksheets-service-dispatch-w-tabs
Sheet: LABOR

 | ASSIGNED | HOUR ADJUST | TOTAL INCOMPLETE
LAST UPDATED: |  |  |  |  | TOTAL HOURS WORK ASSIGNED TO TECH
2010-06-30 16:07:44 |  |  |  |  |  | TOTAL HOURS OF WAITERS ASSIGNED TO TECH
(BF) FISHER, BRENT | 11 |  | 11 |  | 11 | 0 | 0
(BS) SCHINDEL, ROBERT | 39.95 | 31 | 8.950000000000003 |  | 23.2 | 0 | 16.75 |  |  |  |  |  |  |  | NOTE TO PROGRAMMERS: TEXT HIDDEN (FONT COLOR SET TO WHITE OR GRAY) AT F4:G14, [NAME]:K20, AND [NAME]:Q36. THE PURPOSE OF THESE FIELDS ARE TO PROVIDE CALCULATIONS TO BE DISPLAYED IN B4:B31 AND H18:I30.
(DA) BRATKOWSKI, DAN | 0 |  | 0 |  | 0 | 0 | 0
(DB) BILANSKY, DAN | 1 |  | 1 |  | 1 | 0 | 0
(DH) HAGEMANN, DEAN | 0 |  | 0 |  | 0 | 0 | 0
(JZ) MATYSZCZYK, JASON | 15.7 | 10.5 | 5.199999999999999 |  | 10.2 | 0 | 5.5
(RA) ACHTERHOF, RYAN | 8.8 | 3 | 5.800000000000001 |  | 8.8 | 0 | 0
(RG) GOTTFRIED, RICH | 4.9 | 2 | 2.9 |  | 4.9 | 0 | 0
(TF) FRITZ, TOM | 43.8 | 32 | 11.8 |  | 15.95 | 0 | 27.85
(TP) POLIZZI, [NAME] | 11.4 | 3.4 | 8 |  | 11.4 | 0 | 0
(HB) HAROUT | 0 |  | 0 |  | 0 | 0 | 0
TOTAL: | 136.55 | 81.9 | 54.65000000000001 |  | FUTURE | WORK | HOURS | # of JOBS
 |  |  |  |  | MON: | 2010-06-28 00:00:00 | 5.5 | 3 |  |  |  |  | calculations
(MH) HOLLAND, [NAME] | 0 |  | 0 |  | TUE: | 2010-06-29 00:00:00 | 16.8 | 9 |  |  |  | total hours | [NAME] | WASHED | total hours | [NAME] | WASHED
(MK) KIOSKI, [NAME] | 2 | 2 | 0 |  | WED: | 2010-06-30 00:00:00 | 45.94999999999999 | 15 |  | 2 | 1 | 2.8 | 0 | 0 | 2.7 | 0 | 0
(RS) SLOWINSKI, RANDAL | 9 | 9 | 0 |  | THU: | 2010-07-01 00:00:00 | 45.3 | 11 |  | 9 | 0 | 16.8 | 0 | 0 | 0 | 0 | 0
(AC) CLAFLIN, ANDY | 14 | 15 | -1 |  | FRI: | 2010-07-02 00:00:00 | 18.5 | 3 |  | 14 | 1 | 54.44999999999999 | 11.8 | 0.5 | 3.8 | 0 | 0
TOTAL: | 25 | 26 | -1 |  | SAT: | 2010-07-03 00:00:00 | 0 | 0 |  | 9 | 2 | 34.8 | 0 | 0 | 10.5 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 3 | 0 | 21.3 | 0 | 2.8 | 0 | 0 | 0
TOTALS: | 161.55 | 107.9 | 53.65000000000001 |  | MON: | 2010-07-05 00:00:00 | 1 | 2 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | TUE: | 2010-07-06 00:00:00 | 1.5 | 2 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
UNASSIGNED WORK: | 6 hrs | 2 jobs total | 0 waiters |  | WED: | 2010-07-07 00:00:00 | 10.85 | 3 |  | 2 | 0 | 1 | 0 | 0 | 0 | 0 | 0
 |  | 1 | 1 internal |  | THU: | 2010-07-08 00:00:00 | 0 | 0 |  | 2 | 0 | 1.5 | 0 | 0 | 0 | 0 | 0
AVAILABLE HOURS: | 3.349999999999994 | 0 | 0 |  | FRI: | 2010-07-09 00:00:00 | 37.95 | 2 |  | 2 | 1 | 4 | 0 | 0 | 6.85 | 0 | 0
 |  | 1 | 0 |  | SAT: | 2010-07-10 00:00:00 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] AVAILABLE: | 8 |  |  |  |  |  |  |  |  | 1 | 1 | 21.2 | 0 | 0 | 16.75 | 0 | 0
 |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | THIS ADDS THE TOTAL HOURS OF JOBS UNASSIGNED FOR THE CURRENT DAY
 |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  | THIS ADDS THE TOTAL HOURS OF WAITERS LEFT UNASSIGNED
 |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 877894d1724833694-consolidate-data-by-row-need-help
Sheet: Sheet1

 |  |  | RESULT
name | item used |  | name | item used | item used | item used
[NAME] | mask
[NAME] | vest
[NAME] | uniform
[NAME] | candy
[NAME] | fruits
[NAME] | dress
Spreadsheet: andy_zipper__163__DYNEGY-ICE VOL Apr6
Sheet: ICE-ECC

Enron Canada Corporation
Activity on ICE
UOM | Deals | Volume
 |  |  |  |  |  |  | START | END
Enron Canada Corp.
Commodity Type:  All
Instruments:  All
Trade Dates:  Apr-6-01 thru Apr-6-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
No Activity
Spreadsheet: 8a5bec5e-c45e-4d87-8bcd-35a095e9baf8
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
8609 | 21485 | [NAME] | [NAME] | BRA | 0 | 00:09:52 | 00:00:00 | 00:17:45 | 00:00:00 | 00:10:34 | 1 | 00:38:14
8609 | 32001 | Jessica | [NAME] | BRA | 0 | 00:10:08 | 00:00:00 | 00:18:55 | 00:00:00 | 00:10:52 | 2 | 00:39:58
8609 | 64446 | Thaty | Porto | BRA | 0 | 00:10:56 | 00:00:00 | 00:18:14 | 00:00:00 | 00:11:32 | 3 | 00:40:44
8609 | 64447 | [NAME] | [NAME] | BRA | 0 | 00:10:46 | 00:00:00 | 00:19:13 | 00:00:00 | 00:12:29 | 4 | 00:42:29
8609 | 63934 | Ylse | Sasai | BRA | 0 | [NAME] | 00:00:00 | 00:19:18 | 00:00:00 | 00:13:04 | 5 | 00:44:28
8609 | 51300 | Karina | [NAME] | BRA | 0 | [NAME] | 00:00:00 | [NAME] | 00:00:00 | [NAME] | 6 | 00:48:03
Spreadsheet: 705103d1605879816-vlookup-possibly-help-help-
Sheet: Sheet1

Data |  |  |  |  |  |  | Lookup table
Insured | [NAME] name | date | Binder YOA | [NAME] |  |  | [NAME] name | Binder inception | [NAME] | Binder YOA | [NAME]
[NAME] | Binder A | 2019-05-06 00:00:00 |  |  |  |  | Binder A | 2019-03-01 00:00:00 | 2019-12-31 00:00:00 | 2019 | AC10000239-2019
[NAME] | [NAME] | 2021-02-02 00:00:00 |  |  |  |  | [NAME] | 2020-03-01 00:00:00 | 2021-02-28 00:00:00 | 2020 | I000020PFLA001
[NAME] | [NAME] | 2020-08-25 00:00:00 |  |  |  |  | [NAME] | 2020-05-01 00:00:00 | 2021-04-30 00:00:00 | 2020 | I000020PFLA003
[NAME] | [NAME] | 2020-09-18 00:00:00 |  |  |  |  | Binder A | 2020-01-01 00:00:00 | 2020-12-31 00:00:00 | 2020 | I000019PFLA002
Spreadsheet: 770880d1646317141-drop-down-menu-help-nw-test
Sheet: Sheet1

Server | NJSDLCDORA1B.NY.RBCDS.COM
Networker Command | SQL
Output
Networker Commands
[NAME]
[NAME]
Last 10 Backups
Last 50 Backups
Curl
SQL
 | mminfo -avot -q client="&B2&" -r"client ,pool,savetime(22),ssretent,name,level,totalsize(2),ssflags,clflags,sumflags"
Spreadsheet: 238973d1369772976-need-to-combine-rows-excel-sample-zazzz-oeldere-
Sheet: Sheet1

BEFORE
PROD_NBR | OFFRNG_ENG_DESC | SumOfNET_QTY_SOLD | SumOfNET_SALES_AMOUNT | FISCAL_WK_NBR | FISCAL_YR | BUYER_NAM | BUS_CATEGORY_NAM | DIV_NAM | PRM_VNDR_NBR
0420340 | DT SHORE SM PLATTR | 6 | 119.94 | 1 | 2012 | NG, CONNIE | DINING AND ENTERTAINING | LIVING | 9614
0420340 | DT SHORE SM PLATTR | 8 | 159.92 | 2 | 2012 | NG, CONNIE | DINING AND ENTERTAINING | LIVING | 9614
0420340 | DT SHORE SM PLATTR | 7 | 129.93 | 3 | 2012 | NG, CONNIE | DINING AND ENTERTAINING | LIVING | 9614
0420340 | DT SHORE SM PLATTR | 6 | 101.94 | 4 | 2012 | NG, CONNIE | DINING AND ENTERTAINING | LIVING | 9614
0420340 | DT SHORE SM PLATTR | 10 | 199.9 | 5 | 2012 | NG, CONNIE | DINING AND ENTERTAINING | LIVING | 9614
0420369 | DT WOBBLE WINE GLASS | 1 | 4.99 | 1 | 2012 | NG, CONNIE | DINING AND ENTERTAINING | LIVING | 1585
0420369 | DT WOBBLE WINE GLASS | 1 | 6.94 | 4 | 2012 | NG, CONNIE | DINING AND ENTERTAINING | LIVING | 1585
0420369 | DT WOBBLE WINE GLASS | 1 | 4.88 | 8 | 2012 | NG, CONNIE | DINING AND ENTERTAINING | LIVING | 1585
0420369 | DT WOBBLE WINE GLASS | 1 | 6.93 | 9 | 2012 | NG, CONNIE | DINING AND ENTERTAINING | LIVING | 1585
0420369 | DT WOBBLE WINE GLASS | 1 | 6.93 | 11 | 2012 | NG, CONNIE | DINING AND ENTERTAINING | LIVING | 1585
0420369 | DT WOBBLE WINE GLASS | 1 | 4.88 | 12 | 2012 | NG, CONNIE | DINING AND ENTERTAINING | LIVING | 1585
0464512 | BLIND,DT 27X68 BEIGE | 9 | 351.48 | 11 | 2012 | KUPCHANKO, KATH | FLOOR & WINDOW DÉCOR | LIVING | 7038
0464512 | BLIND,DT 27X68 BEIGE | 9 | 331.11 | 12 | 2012 | KUPCHANKO, KATH | FLOOR & WINDOW DÉCOR | LIVING | 7038
0464512 | BLIND,DT 27X68 BEIGE | 14 | 515.06 | 13 | 2012 | KUPCHANKO, KATH | FLOOR & WINDOW DÉCOR | LIVING | 7038
0464513 | BLIND,DT 36X68 BEIGE | 2 | 95.98 | 1 | 2012 | KUPCHANKO, KATH | FLOOR & WINDOW DÉCOR | LIVING | 7038
0464513 | BLIND,DT 36X68 BEIGE | 7 | 307.93 | 2 | 2012 | KUPCHANKO, KATH | FLOOR & WINDOW DÉCOR | LIVING | 7038
0464513 | BLIND,DT 36X68 BEIGE | 1 | 43.99 | 3 | 2012 | KUPCHANKO, KATH | FLOOR & WINDOW DÉCOR | LIVING | 7038
AFTER
PROD_NBR | OFFRNG_ENG_DESC | SumOfNET_QTY_SOLD | SumOfNET_SALES_AMOUNT | FISCAL_WK_NBR | FISCAL_YR | BUYER_NAM | BUS_CATEGORY_NAM | DIV_NAM | PRM_VNDR_NBR
0420340 | DT SHORE SM PLATTR | 37 | 711.63 | 1 | 2012 | NG, CONNIE | DINING AND ENTERTAINING | LIVING | 9614
0420369 | DT WOBBLE WINE GLASS | 6 | 35.55 | 1 | 2012 | NG, CONNIE | DINING AND ENTERTAINING | LIVING | 1585
0464512 | BLIND,DT 27X68 BEIGE | 32 | 1197.65 | 11 | 2012 | KUPCHANKO, KATH | FLOOR & WINDOW DÉCOR | LIVING | 7038
0464513 | BLIND,DT 36X68 BEIGE | 10 | 447.9 | 3 | 2012 | KUPCHANKO, KATH | FLOOR & WINDOW DÉCOR | LIVING | 7038
 | Waarden
Rijlabels | Som van SumOfNET_QTY_SOLD | Som van SumOfNET_SALES_AMOUNT
2012 | 85 | 2392.73
KUPCHANKO, KATH | 42 | 1645.55
0464512 | 32 | 1197.65
0464513 | 10 | 447.9
NG, CONNIE | 43 | 747.18
0420340 | 37 | 711.63
0420369 | 6 | 35.55
Eindtotaal | 85 | 2392.73
Spreadsheet: 725410d1616670396-how-do-i-convert-a-table-with-individual-dates-to-a-table-with-date-ranges-test
Sheet: Basic table

RecordID | Name | Start of leave | End of leave
1 | [NAME] | 2021-04-12 00:00:00 | 2021-04-16 00:00:00
2 | [NAME] | 2021-04-26 00:00:00 | 2021-04-28 00:00:00
3 | [NAME] | 2021-05-17 00:00:00 | 2021-05-21 00:00:00
4 | [NAME] | 2021-06-14 00:00:00 | 2021-06-18 00:00:00
5 | [NAME] | 2021-07-26 00:00:00 | 2021-08-06 00:00:00
6 | [NAME] | 2021-08-23 00:00:00 | 2021-08-27 00:00:00
7 | [NAME] | 2021-09-16 00:00:00 | 2021-09-17 00:00:00
8 | [NAME] | 2021-10-04 00:00:00 | 2021-10-08 00:00:00
9 | [NAME] | 2021-11-02 00:00:00 | 2021-11-05 00:00:00
10 | [NAME] | 2021-12-22 00:00:00 | 2021-12-28 00:00:00
11 | [NAME] | 2021-07-01 00:00:00 | 2021-07-09 00:00:00
12 | [NAME] | 2021-08-16 00:00:00 | 2021-08-20 00:00:00
13 | [NAME] | 2021-09-20 00:00:00 | 2021-09-24 00:00:00
14 | [NAME] | 2021-10-21 00:00:00 | 2021-11-06 00:00:00
15 | [NAME] | 2021-12-06 00:00:00 | 2021-12-10 00:00:00
16 | [NAME] | 2021-06-28 00:00:00 | 2021-07-09 00:00:00
17 | [NAME] | 2021-08-16 00:00:00 | 2021-08-27 00:00:00
18 | [NAME] | 2021-12-15 00:00:00 | 2021-12-23 00:00:00
19 | [NAME] | 2021-04-19 00:00:00 | 2021-04-23 00:00:00
20 | [NAME] | 2021-05-31 00:00:00 | 2021-06-04 00:00:00
21 | [NAME] | 2021-07-26 00:00:00 | 2021-08-06 00:00:00
22 | [NAME] | 2021-09-27 00:00:00 | 2021-10-01 00:00:00
23 | [NAME] | 2021-11-26 00:00:00 | 2021-12-03 00:00:00
24 | [NAME] | 2021-12-27 00:00:00 | 2021-12-31 00:00:00
25 | [NAME] | 2021-04-26 00:00:00 | 2021-04-30 00:00:00
26 | [NAME] | 2021-06-21 00:00:00 | 2021-06-30 00:00:00
27 | [NAME] | 2021-07-01 00:00:00 | 2021-07-09 00:00:00
28 | [NAME] | 2021-08-09 00:00:00 | 2021-08-13 00:00:00
29 | [NAME] | 2021-08-23 00:00:00 | 2021-09-03 00:00:00
30 | [NAME] | 2021-10-25 00:00:00 | 2021-10-29 00:00:00
31 | [NAME] | 2021-12-28 00:00:00 | 2021-12-31 00:00:00
Spreadsheet: sally_beck__34340__2002 Budget Edie Format
Sheet: IT All

 | Information Technology
 | 2002 Plan
 |  | 2001-09-01 00:00:00 |  | 2001 |  | 2002 |  |  |  | Per HC | New HC | Adj Comp |  | 2002
 |  | YTD Actual |  | Forecast |  | Plan |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation
 | Special Pays | 0 |  |  |  |  |  |  | Compensation | 0
 | Analyst & Associate | 0
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense |  |  |  |  |  |  |  | Other
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services | 0 |  |  |  |  |  |  | Total
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions |  |  |  |  |  |  |  | [NAME] | 49200
ENARENT | Rent |  |  |  |  |  |  |  | [NAME] | 57600 | 2
ENATECH | Technology |  |  |  |  |  |  |  | Staff | 60000 | 2
ENATRANS | Transportation |  |  |  |  |  |  |  | Specialist | 78000 | 29
ENAOTHEX | Other Expenses |  |  |  |  |  |  |  | Sr. Specialist | 102000 | 60
ENATAXES | Taxes Other than Income |  |  |  |  |  |  |  | Tech | 192000 | 7
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  |  | IT Consultants | 192000
 |  |  |  |  |  |  |  |  | Manager | 144000 | 16
 | Headcount |  |  | 111 | 40 | 199 |  |  | Director | 168000 | 11
 |  |  |  |  |  |  |  |  | Sr. Director | 216000 | 8
 | A&A Headcount |  |  |  |  |  |  |  | VP | 222000 | 1
 |  |  |  |  |  |  |  |  | MD | 300000
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
ENAOUTLG | Outside Legal |  |  | 0 |  |  |  |  | Benefits & Taxes |  |  | 0.2
ENAOUTTX | Outside Tax
ENAINSUR | Insurance |  |  |  |  |  |  |  | Consultants | 160000 | 0
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure |  |  | 0
ENACORRN | Corporate Rent |  |  | 0
ENAOTHAL | Other Allocated Direct  Expenses |  |  | 0 |  |  |  | Other Expense Calculation
ENADEPR | Depreciation & Amortization
ENAOUTSV | Outside Services | 24143776.43 |  | 0 |  |  |  | Based on information from ENW accounting.
 | `
Spreadsheet: 688314d1595704667-extract-records-assigned-to-contact-name-and-count-number-of-days-in-current-status-tracker
Sheet: Tracker

Record | Contact | Stauts | Date Assigned | Completeness Review | Review Meeting | [NAME] | Team Lead Review | Supervisor Review | CFO Review | CEO Review
Montgomery | Green | Under Review | 2020-04-07 00:00:00 | 2020-04-14 00:00:00 | 2020-04-17 00:00:00 | 2020-04-30 00:00:00 | 2020-05-10 00:00:00 | 2020-05-26 00:00:00 | 2020-06-15 00:00:00 | 2020-06-29 00:00:00
[NAME] | [NAME] | Denied | 2020-04-08 00:00:00 | 2020-04-15 00:00:00 | 2020-04-18 00:00:00 | 2020-05-01 00:00:00 | 2020-05-11 00:00:00 | 2020-05-27 00:00:00
[NAME] | Philips | Partial Approved | 2020-04-09 00:00:00 | 2020-04-16 00:00:00 | 2020-04-19 00:00:00 | 2020-05-02 00:00:00 | 2020-05-12 00:00:00
[NAME] | Green | Under Review | 2020-04-10 00:00:00 | 2020-04-17 00:00:00 | 2020-04-20 00:00:00 | 2020-05-03 00:00:00 | 2020-05-13 00:00:00 | 2020-05-29 00:00:00 | 2020-06-18 00:00:00
St. Charles | Toney | Partial Approved | 2020-04-11 00:00:00 | 2020-04-18 00:00:00 | 2020-04-21 00:00:00 | 2020-05-04 00:00:00 | 2020-05-14 00:00:00 | 2020-05-30 00:00:00 | 2020-06-19 00:00:00 | 2020-07-03 00:00:00
[NAME] | [NAME] | Denied | 2020-04-12 00:00:00 | 2020-04-19 00:00:00 | 2020-04-22 00:00:00 | 2020-05-05 00:00:00
Baltimore | Philips | Under Review | 2020-04-13 00:00:00 | 2020-04-20 00:00:00 | 2020-04-23 00:00:00 | 2020-05-06 00:00:00 | 2020-05-16 00:00:00 | 2020-06-01 00:00:00 | 2020-06-21 00:00:00 | 2020-07-05 00:00:00
Washington | Toney | Partial Approved | 2020-04-14 00:00:00 | 2020-04-21 00:00:00 | 2020-04-24 00:00:00 | 2020-05-07 00:00:00 | 2020-05-17 00:00:00 | 2020-06-02 00:00:00
Fairfax | Green | Under Review | 2020-04-15 00:00:00 | 2020-04-22 00:00:00 | 2020-04-25 00:00:00 | 2020-05-08 00:00:00 | 2020-05-18 00:00:00 | 2020-06-03 00:00:00 | 2020-06-23 00:00:00 | 2020-07-07 00:00:00
Arlington | [NAME] | Denied | 2020-04-16 00:00:00 | 2020-04-23 00:00:00 | 2020-04-26 00:00:00 | 2020-05-09 00:00:00 | 2020-05-19 00:00:00
 |  | Last date | Prior date
Spreadsheet: 65463d1266184339-pivot-percentage-of-subtotal-and-total-budget
Sheet: SUMMARY

[NAME] | AMOUNT | DATE |  | [NAME] | AMOUNT | DATE |  | [NAME] | AMOUNT | DATE
INCOMEA | 1500 | 2010-01-05 00:00:00 |  | ELECTRIC | 114 | 2010-01-14 00:00:00 |  | GROCERY | 100 | 2010-01-02 00:00:00
INCOMEA | 1400 | 2010-01-10 00:00:00 |  | WATER | 50 | 2010-01-15 00:00:00 |  | FASTFOOD | 7 | 2010-01-05 00:00:00
INCOMEB | 800 | 2010-01-17 00:00:00 |  | WATER | 58 | 2010-01-17 00:00:00 |  | FASTFOOD | 15 | 2010-01-07 00:00:00
INCOMEC | 450 | 2010-01-25 00:00:00 |  | CABLE | 33 | 2010-01-20 00:00:00 |  | CLEANERS | 23 | 2010-01-26 00:00:00
INCOMEA | 1400 | 2010-02-05 00:00:00 |  | ELECTRIC | 115 | 2010-02-13 00:00:00 |  | GROCERY | 115 | 2010-02-13 00:00:00
INCOMEB | 1500 | 2010-02-11 00:00:00 |  | WATER | 60 | 2010-02-14 00:00:00 |  | FUEL | 8 | 2010-02-14 00:00:00
INCOMEB | 700 | 2010-02-15 00:00:00 |  | GAS | 57 | 2010-02-16 00:00:00 |  | FUEL | 20 | 2010-02-17 00:00:00
INCOMEC | 350 | 2010-02-22 00:00:00 |  | GAS | 30 | 2010-02-21 00:00:00 |  | CLEANERS | 25 | 2010-02-20 00:00:00
Spreadsheet: 779826d1652128810-calculating-hours-spent-with-1-client-sample-problem
Sheet: Sheet1

Client 1 |  | 0.2
Client 2 |  | 0.4
Client 3 |  | 1.4
Client 2 |  | 1.6
Client 2 |  | 3
Client 3 |  | 3
Client 2 |  | 2
Client 1 |  | 8
Total
Client 1
Client 2
Client 3
Spreadsheet: 208831d1358944104-sorting-is-throwing-my-formulas-out-of-place-looking-for-solution-solved_testfile
Sheet: Weekly Schedule

Week starting --> |  |  | 2013-01-07 00:00:00 |  |  |  |  |  |  |  | 2013-01-14 00:00:00 |  |  |  |  |  |  |  | 2013-01-21 00:00:00 |  |  |  |  |  |  |  |  | 2013-01-28 00:00:00 |  |  |  |  |  |  |  |  | 2013-02-04 00:00:00 |  |  |  |  |  |  |  |  | 2013-02-11 00:00:00 |  |  |  |  |  |  |  |  | 2013-02-18 00:00:00 |  |  |  |  |  |  |  |  | 2013-02-25 00:00:00
Team Member --> |  |  | Jake | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Doug | Jake | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Doug | Jake | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Doug | Jake | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Doug | Jake | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Doug | Jake | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Doug | Jake | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Doug | Jake | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Doug
Total Hours This Week ↓
Maria | Client A |  |  |  |  |  |  |  | 10 | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
Maria | Client B |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  | 12
Maria | Client C
[NAME] | Client D
Doug | Client E |  |  |  |  |  | 10 |  |  |  |  |  | 2 |  | 10 |  | 10 |  |  |  | 2 |  | 10 |  | 8
Kris | Client A
Karen/Kris/Carly | Client F |  | 29 |  | 2 |  | 4 | 4 | 12 |  |  |  | 10 |  |  | 15 | ? |  | 22 | 1 | 4 |  |  | 8
Kris | Client G
Kris | Client H |  |  |  |  |  |  | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Kris | Client I |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
Kris/Sue | Client J |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
[NAME] | Client K |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  | 12
Sue | Client L |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  | 3
Doug | Client M
Sue | Client N |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
[NAME] | Client O |  | 1
[NAME] | Client P
Karen/Sue | Client Q |  |  | 20 |  |  |  | 4 |  |  |  |  | 15 |  | 4 | 2 | ? |  |  | 7 |  |  |  | 5 | 7 | 7
Google | Client R
Google | Client S
Google | Client T |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | 2
Google | Client U
[NAME] | Client V |  |  |  |  | 15
Ruby | Client W
Sue | Client X |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  | 15
Sue | Client Y
Sue | Client Z |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
Sue | Client 1 |  |  |  | 10 |  |  |  | 5 |  |  | 5 |  |  |  |  |  |  |  |  | 5 |  | 10
Sue | Client 2 |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
England | Client 3
Spreadsheet: 1afec53f-749a-4d13-a981-11e6c4b33ec6
Sheet: Sakatıl İnd. İade 

 | SATAKLIK İNDİRİMİ SONUCU [NAME]
 |  | Ocak | Şubat | Mart | [NAME] | Mayıs | Haziran | [NAME] | Ağustos | Eylül | Ekim | Kasım | Aralık | Toplam
1 | Aylık G.V.Matrahı | 916.62 | 0 | 0 | 853.09 | 855.96 | 855.96 | 892.7 | 892.7 | 892.7 | 892.7 | 892.7 | 892.7
2 | GELİR VERGİSİ ORANI | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15 | 0.15
3 | [NAME] | 99.73 | 0 | 0 | 89.61 | 89.61 | 89.61 | 89.61 | 89.61 | 89.61 | 89.61 | 89.61 | 89.61
4 | Ödenen A.G.İ. [NAME] (3)
5 | Derece Sakatlık İndirim Miktarı TL | 770 |  |  | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700 | 700
6 | G.V.  (1*2)
7 | [NAME]6-4)
8 | Aylık G.V.Matrahı (1)
9 | [NAME] (8-5)
10 | G.V. (9*2)
11 | [NAME]
12 | [NAME] ödenen Agi  (4-11)
 | [NAME]
Spreadsheet: 93437d1293021029-formula-needed-to-fetch-data-from-different-worksheets-and-include-adjacent-cells-copy-of-core-staff-leave-2010
Sheet: PR

PR
HOLIDAYS TAKEN
2010
Tuesday | 1900-02-09 00:00:00 | PR
Thursday | 1900-02-25 00:00:00 | PR
Tuesday | 1900-04-06 00:00:00 | PR
Wednesday | 1900-04-07 00:00:00 | PR
Thursday | 1900-04-08 00:00:00 | PR
Friday | 1900-04-09 00:00:00 | PR
Monday | 1900-04-12 00:00:00 | PR
Tuesday | 1900-04-13 00:00:00 | PR
Wednesday | 1900-04-14 00:00:00 | PR
Thursday | 1900-04-15 00:00:00 | PR
Friday | 1900-04-16 00:00:00 | PR
Monday | 1900-06-07 00:00:00 | PR
Monday | 1900-08-09 00:00:00 | PR
Friday | 1900-09-10 00:00:00 | PR
Tuesday | 1900-09-21 00:00:00 | PR
Friday | 1900-10-08 00:00:00 | PR
Tuesday | 1900-10-12 00:00:00 | PR
Wednesday | 1900-10-27 00:00:00 | PR
Friday | 1900-11-19 00:00:00 | PR
Monday | 1900-11-22 00:00:00 | PR
STATUTORY |  | 8
Spreadsheet: 694993d1599939998-formular-for-minus-automatic-david
Sheet: Sheet1

 | INCOME |  |  |  |  | EXPENDITURE
 | NO | TAREHE | MAELEZO | CASH | BANK | TAREHE | MAELEZO | KIASI | SALIO
 |  |  |  |  |  |  |  |  | 3000 | 2900
 |  |  | A | 1000 | 2000 |  | B | 100 | 8000 | 8900
 |  |  |  | 4000 | 1000 |  |  | 2000
 |  |  |  |  |  |  |  |  | IN J5  MEANS SUM OF E TO F AND J6 MEANS SUM OF E7 TO F7 | K5 MEANS J5 MINUS I6 AND K6 MEANS K5 PLUS J6 MINUS I 7 I NEED IT TO APPEAR AUTOMATIC DOWN I HEVE MANY DATA
Spreadsheet: 6be47786-b1c1-4b08-a3a3-ce0269b14352
Sheet: Page 2

 | Permit No.: | WQ0002005 |  | Facility Name: |  | House of Raeford Farms, Inc. |  |  |  |  |  | County: |  | Duplin |  | Month: |  |  |  | Year:
 |  | Field Name: |  | [NAME] |  | Field Name: |  | L1 |  | Field Name: |  | L2 |  | Field Name: |  | L3 |  | Field Name: |  | [NAME]
 |  | Area (acres): |  | 23 |  | Area (acres): |  | 12.04 |  | Area (acres): |  | 12.04 |  | Area (acres): |  | 12.04 |  | Area (acres): |  | 12.04
 |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  | Load Type: |  |  |  | Load Type: |  |  |  | Load Type: |  |  |  | Load Type: |  |  |  | Load Type:
 |  | [NAME]? |  |  |  | [NAME]? |  |  |  | [NAME]? |  |  |  | [NAME]? |  |  |  | [NAME]?
 | Date | Volume Applied |  |  |  | Volume Applied |  |  |  | Volume Applied |  |  |  | Volume Applied |  |  |  | Volume Applied
 | Month | gal | mg/L | lbs/ac | lbs/ac | gal | mg/L | lbs/ac | lbs/ac | gal | mg/L | lbs/ac | lbs/ac | gal | mg/L | lbs/ac | lbs/ac | gal | mg/L | lbs/ac | lbs/ac
 |  |  |  | 300 |  |  |  | 300 |  |  |  | 300 |  |  |  | 300 |  |  |  | 300
Spreadsheet: 770795d1646253591-working-time-directive-calculations-timesheet2
Sheet: 14-2-22

 | HMP BARLINNIE ESTATES |  |  |  |  | Week No. |  |  |  |  | Week Commencing |  |  |  |  |  |  | On Call Engineer |  |  | T Buist / S Barclay
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | On Call Manager |  |  | [NAME]
Toil | Name | Leave | MONDAY |  |  |  | TUESDAY |  |  |  | WEDNESDAY |  |  |  | THURSDAY |  |  |  | FRIDAY |  |  |  | SATURDAY |  | SUNDAY |  | Signature | leave |  | toil
 |  |  | HRS | TOIL | O/T | OTHER | HRS | TOIL | O/T | OTHER | HRS | TOIL | O/T | OTHER | HRS | TOIL | O/T | OTHER | HRS | TOIL | O/T | OTHER | O/T | TOIL | O/T | TOIL |  | Total | Balance | Total | Balance | total from last week | total leave taken
 | [NAME] |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7
 | [NAME] | 14 | 0 |  |  | AL | 7.5 |  |  |  | 7.5 |  |  | TR | 7.5 |  |  |  | 7
 | [NAME] | 18 | 7.5 |  |  |  | 7.5 |  |  |  | 0 |  |  | AL | 7.5 |  |  |  | 7
 | [NAME] | 15.5 | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 | -3.5 |  |  | 7.5 |  |  |  | 7 |  |  | TR
 | [NAME] | 0 | 7.5 | -1 |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 0 |  |  | AL | 0 |  |  | AL
 | [NAME] | 25 | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7
 | [NAME] | 22 | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7 |  |  | TR
 | [NAME] | 26 | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7.5 |  |  |  | 7 |  |  |  | 8 |  | 8
 | Vacant Post | 8.5 | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Spreadsheet: 266612d1379676585-repeat-one-column-number-of-times-there-is-text-in-another-mainman_next
Sheet: Sheet1

Group 1 |  | Member 3 | Member 12 | Member 8 |  | Member 6 |  | Member 17 | Member 4 |  | Member 3
Group 2 | Member 20 | Member 17 |  |  | Member 3 | Member 11 |  |  |  | Member 14 | Member 16 | Member 15
Group 3 | Member 14 |  | Member 8 | Member 1 | Member 8 |  | Member 3 | Member 7 | Member 19 |  |  | Member 14
Members | Groups