tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 104221d1301880662-replace-a-concatenate-from-pivot-table-with-fx-to-raw-data-concatenate-from-pivot-sample
Sheet: Drivers

OT/DT | (All)
 |  |  | Data
Resource Type | Div | Cat | OT/DT Hours | Percent of Total OT/DT |  |  | Div | CONCATENATE FX
DG | 1 | 1 | 239.25 | 0.1283013808821558
 |  | 2 | 4 | 0.002145059659471779
 |  | 3 | 63.75 | 0.03418688832283148
 | 1 Total |  | 307 | 0.1646333288644591 |  |  | 1 Total | #N/A
 | 2 | 1 | 7 | 0.003753854404075613
 |  | 2 | 139.5 | 0.0748089556240783
 |  | 3 | 154.25 | 0.08271886311838048
 | 2 Total |  | 300.75 | 0.1612816731465344 |  |  | 2 Total | (307 hrs), 1 (7 hrs), 2 (140 hrs), 3 (154 hrs)
 | 3 | 1 | 0.5 | 0.0002681324574339724
 |  | 2 | 226.25 | 0.1213299369888725
 |  | 3 | 19 | 0.01018903338249095
 | 3 Total |  | 245.75 | 0.1317871028287974 |  |  | 3 Total | (301 hrs), 1 (1 hrs), 2 (226 hrs), 3 (19 hrs)
DG Total |  |  | 853.5 | 0.4577021048397908
DT | 1 | 1 | 98.75 | 0.05295616034320955
 |  | 2 | 169.5 | 0.09089690307011664
 |  | 3 | 10 | 0.005362649148679448
 |  | 4 | 224.5 | 0.1203914733878536
 | 1 Total |  | 502.75 | 0.2696071859498592 |  |  | 1 Total | 1 (99 hrs), 2 (170 hrs), 3 (10 hrs), 4 (225 hrs)
 | 2 | 1 | 4.5 | 0.002413192116905751
 |  | 2 | 94.25 | 0.0505429682263038
 |  | 3 | 52.75 | 0.02828797425928409
 |  | 4 | 15.5 | 0.008312106180453143
 | 2 Total |  | 167 | 0.08955624078294677 |  |  | 2 Total | 1 (5 hrs), 2 (94 hrs), 3 (53 hrs), 4 (16 hrs)
 | 3 | 1 | 13.5 | 0.007239576350717254
 |  | 2 | 0.5 | 0.0002681324574339724
 |  | 3 | 24.5 | 0.01313849041426465
 |  | 4 | 12.5 | 0.00670331143584931
 | 3 Total |  | 51 | 0.02734951065826518 |  |  | 3 Total | 1 (14 hrs), 2 (1 hrs), 3 (25 hrs), 4 (13 hrs)
DT Total |  |  | 720.75 | 0.3865129373910712
GC | 1 | 1 | 1 | 0.0005362649148679448
 |  | 2 | 97.5 | 0.05228582919962461
 |  | 3 | 22.5 | 0.01206596058452876
 |  | 4 | 4.25 | 0.002279125888188765
 | 1 Total |  | 125.25 | 0.06716718058721008 |  |  | 1 Total | 1 (1 hrs), 2 (98 hrs), 3 (23 hrs), 4 (4 hrs)
 | 2 | 1 | 7 | 0.003753854404075613
 |  | 2 | 15.75 | 0.00844617240917013
 |  | 3 | 1.5 | 0.0008043973723019171
 |  | 4 | 9 | 0.004826384233811503
 | 2 Total |  | 33.25 | 0.01783080841935916 |  |  | 2 Total | 1 (7 hrs), 2 (16 hrs), 3 (2 hrs), 4 (9 hrs)
 | 3 | 1 | 62.75 | 0.03365062340796354
 |  | 2 | 16.25 | 0.008714304866604102
 |  | 3 | 30.5 | 0.01635607990347232
 |  | 4 | 22.5 | 0.01206596058452876
 | 3 Total |  | 132 | 0.07078696876256871 |  |  | 3 Total | 1 (63 hrs), 2 (16 hrs), 3 (31 hrs), 4 (23 hrs)
GC Total |  |  | 290.5 | 0.1557849577691379
Grand Total |  |  | 1864.75 | 1
Spreadsheet: 11b68e84-f71f-49fd-bc1c-1a994ef37eec
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5929 | 44869 | [NAME] | Montes | MEX | 0 | 00:41:16 | 00:04:15 | 01:03:14 | 00:02:42 | 00:26:10 | DQ | 00:00:00
Spreadsheet: 762932d1641910845-cond-formatting-first-monday-on-the-month-sddo-vacation-tracker-2023
Sheet: Nov

Formation /Training
Congés / Leaves | V
Congés fériés / GC holidays
Fin de semaine / Weekend
T:  Tentative | T
Compressed Day / Journée comprimée
Assignment / Left
Half Day / Demie Journée
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enter year:
November | Dates of Leave |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023
11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Vacation
Employee Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 |  | Replaced by:
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
(Vacant CS-03)
[NAME]
[NAME]
[NAME]
(Vacant team lead)
(Vacant CS-03)
Sameer [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
November Total
Spreadsheet: andy_zipper__162__DYNEGY-ICE VOL Apr4
Sheet: ICE-EPM

Enron Power Marketing
Activity on ICE
UOM | Deals | Volume
MWhs
 |  |  |  |  |  |  | START | END
Enron Power Marketing, Inc.
Commodity Type:  All
Instruments:  All
Trade Dates:  Apr-4-01 thru Apr-4-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
Apr-04-01 | 837438764 |  | Bought | Firm-LD Peak | Cin | Next Week | Apr-09-01 | Apr-13-01 |  |  |  | American Electric Power Service Corp. | 46.5 | USD / MWh | 50 | Hourly | 4000 | MWhs | Dorland , C
Apr-04-01 | 184707665 |  | Bought | Firm-LD Peak | Cin | Next Week | Apr-09-01 | Apr-13-01 |  |  |  | Northern Indiana Public Service Company | 46.5 | USD / MWh | 50 | Hourly | 4000 | MWhs | Dorland , C
Apr-04-01 | 116869864 |  | Bought | Firm-LD Peak | Cin | Next Week | Apr-09-01 | Apr-13-01 |  |  |  | American Electric Power Service Corp. | 47 | USD / MWh | 50 | Hourly | 4000 | MWhs | Dorland , C
Apr-04-01 | 101993080 |  | Bought | Firm-LD Peak | Palo | 2001-05-01 00:00:00 | May-01-01 | May-31-01 |  |  |  | Morgan Stanley Capital Group, Inc. | 303 | USD / MWh | 25 | Hourly | 10400 | MWhs | Fischer, M
Apr-04-01 | 199681409 |  | Bought | Firm-LD Peak | Palo | 2001-05-01 00:00:00 | May-01-01 | May-31-01 |  |  |  | Morgan Stanley Capital Group, Inc. | 305 | USD / MWh | 25 | Hourly | 10400 | MWhs | Fischer, M
Apr-04-01 | 164904766 |  | Sold | Firm-LD Peak | Cin | Next Day | Apr-06-01 | Apr-06-01 |  |  |  | American Electric Power Service Corp. | 48 | USD / MWh | 250 | Hourly | 4000 | MWhs | Dorland , C
Apr-04-01  Deals
Spreadsheet: frank_ermis__11228__West NatGas Prices 1121
Sheet: Gas Average PhyIdx

PhyIdx Curves
 |  | WEST NATURAL GAS PRICES- Phy Idx
 |  | AS OF
 |  |  |  |  |  |  |  |  |  | Last-Day | Cash | Cash | Change | BOM | BOM | Change | Prompt Month | Change | Q4 | Change | Winter 2001-02 | Change | Q1 | Change | Q2 | Change | Summer 2002 | Change | Q3 | Change | Q4 | Change | Winter 2002-03 | Change
 |  |  |  |  |  |  |  |  |  | Cash Settle | Price | Spread |  | Price | Spread |  |  |  | 2001 |  | Nov-01/Mar-02 |  | 2002 |  | 2002 |  | Apr-02/Oct-02 |  | 2002 |  | 2002 |  | Nov-02/Mar-03
 |  | California Region Notional
 |  |  |  |  | Sheet Name | Row Num for CurveName | Column Letter for Date
 |  |  |  | Basis | IndexCurves | 13 | B
 |  | Gas Trading |  | IntraMonth | CurveFetch | 4 | D
 |  |  |  |  |  |  |  |  | IntraMonth
 |  |  |  | IntraMonth Hub Curve | IF-HEHUB
 |  |  |  | IntraMonth Month
 |  |  |  |  |  |  |  |  | Date Start |  |  |  |  |  |  |  |  |  | 2001-10-01 00:00:00 |  |  |  | 2002-01-01 00:00:00 |  | 2002-04-01 00:00:00 |  | 2002-04-01 00:00:00 |  | 2002-07-01 00:00:00 |  | 2002-10-01 00:00:00 |  | 2002-11-01 00:00:00
 |  |  |  |  |  |  |  |  | Date End |  |  |  |  |  |  |  |  |  | 2001-12-01 00:00:00 |  | 2002-03-01 00:00:00 |  | 2002-03-01 00:00:00 |  | 2002-06-01 00:00:00 |  | 2002-10-01 00:00:00 |  | 2002-09-01 00:00:00 |  | 2002-12-01 00:00:00 |  | 2003-03-01 00:00:00
 |  | WEST REGION BASIS NOTIONAL |  | Intra-Month | Basis |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IntraMonth Match |  | Basis Match
 |  | NGI-PGE/CG |  | NGI-PGE/CG | NGI-PGE/CG |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.043 |  |  |  | -0.0483 |  | -0.01 |  |  |  | -0.045 |  | -0.03
 |  | NGI-PGE/TOPOCK |  | NGI-PGE/TOPOCK | NGI-PGE/TOPOCK
 |  | NGI-MALIN |  | NGI-MALIN | NGI-MALIN
 |  | NGI-SOCAL |  | NGI-SOCAL | NGI-SOCAL
 |  | Southwest Region Notional
 |  | SAN JUAN |  | IF-ELPO/SJ | IF-ELPO/SJ
 |  | ELPO/PERMIAN |  | IF-ELPO/PERMIAN | IF-ELPO/PERMIAN
 |  | WAHA |  | IF-WAHA-TX | IF-WAHA-TX
 |  | NGPL/MIDCON |  | IF-NGPL/MIDCON | IF-NGPL/MIDCON
 |  | Northwest Region Notional
 |  | OPAL |  | IF-NWPL_ROCKY_M | IF-NWPL_ROCKY_M
 |  | STANFIELD |  | NW-STANFIELD | NW-STANFIELD
 |  | SUMAS |  | IF-NWPL/CNBR-US | IF-NTHWST/CANBR
 |  | AECO |  | CGPR-AECO/USIM | CGPR-AECO/BASIS
 |  | CIG |  | IF-CIG/RKYMTN | IF-CIG/RKYMTN
 |  | Ontario Region Notional
 |  | Central Region Notional
 |  | East & Texas Region Notional
 |  | Nymex
 |  | Nymex |  | IF-HEHUB | NG |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 0 |  |  |  |  |  | 0 |  |  |  |  |  | 0
Spreadsheet: f912eee8-4c29-4ac9-b9ed-ef908863ae8e
Sheet: Sheet1

Unnamed: 0 | SVG Coater and [NAME] Use Only | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | Week of May 25 - May 29
 |  | 1um | 1.6um | 7um | 1um | 1.6um | 3um | 1um | 1.6um | 3um
SVG                         Coater | Date (Coat) | 2009-05-26 00:00:00 | 2009-05-26 00:00:00 | 2009-05-26 00:00:00 | 2009-05-26 00:00:00 | 2009-05-26 00:00:00 | 2009-05-26 00:00:00
 | Track | 1 | 1 | 1 | 2 | 2 | 2
 | Prime Program | Yes Oven | Yes Oven | Yes Oven | Yes Oven | Yes Oven | Yes Oven
 | Coat Program | 7 | 8 | 4 | 7 | 8 | 4
 | Oven Program | 1 | 2 | 3 | 1 | 2 | 3
 | Problems
Thickness Measurements                                (NanoSpec) | Date (Measurement) | 2009-05-26 00:00:00 | 2009-05-26 00:00:00 | 2009-05-26 00:00:00 | 2009-05-26 00:00:00 | 2009-05-26 00:00:00 | 2009-05-26 00:00:00 | - | - | -
 | Top (A) | 10247 | 17085 | 73819 | 10284 | 17050 | 30080 | - | - | -
 | Center (A) | 10238 | 17067 | 73803 | 10251 | 17056 | 30069 | - | - | -
 | Flat (A) | 10239 | 17062 | 73918 | 10259 | 17049 | 30093 | - | - | -
 | Left  (A) | 10250 | 17076 | 73811 | 10274 | 17055 | 30113 | - | - | -
 | Right (A) | 10245 | 17076 | 73913 | 10263 | 17054 | 30066 | - | - | -
 | Average (A) | 10244 | 17073 | 73853 | 10266 | 17053 | 30084 | - | - | -
 | [NAME]  (A) | 4 | 9 | 58 | 13 | 3 | 19 | - | - | -
 | Comments
Exposure | Date (Exposure) | 2009-05-27 00:00:00 | 2009-05-27 00:00:00 | 2009-05-27 00:00:00 | 2009-05-28 00:00:00 | 2009-05-28 00:00:00 | 2009-05-28 00:00:00
 | Tool | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | EValign | EValign | EValign
 | Contact Type | Vac. | Vac. | Vac. | Vac. | Vac. | Vac.
 | Exposure Time | 1.0s | 1.4s | 3.0s x2 | 1.0s | 1.4s | 3.0s
 | Problems
SVG                            Developer | Date (Develop) | 2009-05-27 00:00:00 | 2009-05-27 00:00:00 | 2009-05-27 00:00:00 | 2009-05-28 00:00:00 | 2009-05-28 00:00:00 | 2009-05-28 00:00:00
 | Track | 2 | 2 | 2 | 2 | 2 | 2
 | Pre-bake Program | 1 | 2 | none | 1 | 2 | none
 | Develop Program | 3 | 4 | 6 | 3 | 4 | 7
 | Post-base Program | 1 | 2 | none | 1 | 2 | none
 | Problems
Resolution                         Measurements | Date (Measurement) | 2009-05-28 00:00:00 | 2009-05-28 00:00:00 | 2009-05-28 00:00:00 | 2009-05-28 00:00:00 | 2009-05-28 00:00:00 | 2009-05-28 00:00:00
 | Top (H/V) (um) | 1/1.5 | 1/1.5 | 2.5/2.5 | 2/2 | 1.5/2 | 2.5/2.5
 | Center (H/V) (um) | 1/1.5 | 1/1.5 | 2.5/2.5 | 1.5/1.5 | 1/1.5 | 2/2
 | Flat (H/V) (um) | 1.5/1.5 | 1.5/1.5 | 2/2.5 | 1.5/2 | 2/2 | 2.5/3
 | Left (H/V) (um) | 1/1.5 | 1/1.5 | 2/2.5 | 1.5/2 | 1.5/1.5 | 2/2
 | Right (H/V) (um) | 1/1.5 | 1/1.5 | 2/2.5 | 1.5/2 | 2/2 | 2/2.5
 | Comments | 1s darkfield   0.9s lightfield | 1.3s darkfield 1.2s lightfield | 3.0s x2 darkfield | 1.1s darkfield  0.9-1s lightfield | 1.4-1.5s darkfield | 2.8s darkfield 2.6-2.7s lightfield
Spreadsheet: 96b49a18-3eb0-486d-8d60-5048da5c93a8
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
FEDERAL FUNDING REQUEST
For All Federal Non-SAPT Block Grant Funding
Ohio Department of Alcohol & Drug Addiction Services
1. Funding source:  Please select funding source.
SPF-SIG |  |  | Safe & Drug Free Schools
Underage Drinking 2008 |  |  | Underage Drinking 2009
Access to Recovery |  |  | ARRA - Bryne Grant
 |  |  | Other (Please Specify)
2. Header Information:
Agency/Board Name:
For ODADAS USE ONLY:
Purchase Order #: |  | Vendor Number: |  |  | Payment Address/EFT:
3. Expenses  SFY 2010
Program Category |  | Actual Expenses Thru   (Enter Date) | Projected Expenses Thru  (Enter Date) | Total | Funds Received To Date | Period Request | Total Award/ Allocation | Available Balance
 |  | (A) | (B) | (C=A+B) | (D) | (E=C-D) | (F) | (G=F-D-E)
2010H - SPF-SIG |  |  |  | 0 |  | 0 |  | 0
2020D - Drug Free Schools |  |  |  | 0 |  | 0 |  | 0
2020G - Underage Drinking |  |  |  | 0 |  | 0 |  | 0
2080L - Access To Recovery |  |  |  | 0 |  | 0 |  | 0
2632C  - ARRA Bryne Grant |  |  |  | 0 |  | 0 |  | 0
TOTAL |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
4. CERTIFICATION
I certify that the financial information shown in this funding request is correct.
Requestor's Signature/Title |  |  |  | Phone Number |  |  | Date
Board Executive Director's Signature |  |  |  | Phone Number |  |  | Date
Spreadsheet: 551019d1512660115-staff-holiday-planner-ef1120_plot_dates
Sheet: DATA

NAME | SURNAME | FROM | TO
[NAME] | SMITH | 2018-01-12 00:00:00
[NAME] | SMITH | 2018-02-03 00:00:00
SARAH | ANDREWS | 2018-01-15 00:00:00
SARAH | ANDREWS | 2018-02-20 00:00:00
[NAME] | SMITH | 2018-04-16 00:00:00
SARAH | ANDREWS | 2018-03-10 00:00:00
SARAH | ANDREWS | 2018-08-11 00:00:00
[NAME] | SMITH | 2018-06-05 00:00:00
Spreadsheet: 140289d1328689056-automatic-update-of-pivot-table-based-on-filtered-data-sample-pivot
Sheet: Sheet1

Month | Project | Achieved | Target
Jan | A | 10 | 10
Jan | B | 20 | 20
Feb | A | 30 | 20
Feb | B | 40 | 45
Mar | A | 40 | 55
Mar | B | 45 | 60
Apr | A | 75 | 100
Apr | B | 80 | 100
Sum of Achieved
Month | Project | Total
Jan | A | 10
 | B | 20
Jan Total |  | 30
Feb | A | 30
 | B | 40
Feb Total |  | 70
Mar | A | 40
 | B | 45
[NAME] |  | 85
Apr | A | 75
 | B | 80
Apr Total |  | 155
Grand Total |  | 340
Spreadsheet: 867822d1714621037-calculating-a-percentage-based-on-rows-above-and-below-test1-1-
Sheet: Sample 1

 | 8 | rows need to count |  |  |  |  |  |  |  |  |  | From row | to row | rows count | Sum ALL | minus | Sum/count |  | Single formula |  |  | Grade | Value
 | 102853 | B0 |  |  |  |  |  | R |  |  |  |  |  |  |  |  |  |  |  |  |  | B0 | 0
 | 202854 | B0 |  |  |  |  |  | R |  |  |  |  |  |  |  |  |  |  |  |  |  | B1 | 0.15
 | 302855 | B0 |  |  |  |  |  | R |  |  |  |  |  |  |  |  |  |  |  |  |  | B2 | 0.15
 | 402856 | B2 |  |  |  |  |  | R |  |  |  |  |  |  |  |  |  |  |  |  |  | B3 | 0.4
 | 602858 | B0 |  |  |  |  |  | R |  |  |  |  |  |  |  |  |  |  |  |  |  | B4 | 0.9
 | 302862 | B0 |  |  |  |  |  | R | 0.1538 |  |  |  |  |  |  |  |  |  |  |  |  | B5 | 1.5
 | 602865 | B0 |  |  |  |  |  | R
 | 702866 | B0 |  |  |  |  |  | R
 | 502871 | B0 |  |  |  |  |  | R
 | 102874 | B0 |  |  |  |  |  | R
 | 302876 | B0 |  |  |  |  |  | R
 | 402877 | B0 |  |  |  |  |  | R
 | 602879 | B5 |  |  |  |  |  | R | one out of 16 (C21 is a B5) total count of 8 rows up and 8 below), 6.25%
 | 702880 | B0 |  |  |  |  |  | R
 | 302883 | B0 |  |  |  |  |  | R
 | 402884 | B0 |  |  |  |  |  | R
 | 502885 | B0 |  |  |  |  |  | R
 | 602886 | B0 |  |  |  |  |  | R
 | 202889 | B0 |  |  |  |  |  | R
 | 502892 | B5 |  |  |  |  |  | R | 2 out of 16 C14 and C29 (8 row up and 8 below), 12.5%
 | 602893 | B0 |  |  |  |  |  | R
 | 102895 | B0 |  |  |  |  |  | R
 | 202896 | B0 |  |  |  |  |  | R
 | 302897 | B0 |  |  |  |  |  | R
 | 402898 | B0 |  |  |  |  |  | R
 | 102902 | B0 |  |  |  |  |  | R
 | 202903 | B0 |  |  |  |  |  | R
 | 302904 | B3 |  |  |  |  |  | R
 | 602907 | B0 |  |  |  |  |  | R
 | 702908 | B0 |  |  |  |  |  | R
 | 302911 | B0 |  |  |  |  |  | R
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | How formula works?
Spreadsheet: 273528d1382737605-compare-a-and-c-column-if-match-my-logic-display-result-in-b-column-new-suspend-numbers
Sheet: Sheet1

NUMBER STATUS | errors in suspend numbers | ERRORS | or this???
New Activation
New Activation
Susp for TV process [NAME]
Susp for TV process [NAME] |  | CUG NOT GIVEN |  |  | C column error msg and A column Susp for TV process Rental charging message pair in this line so, need result in b colum like this
Susp for TV process [NAME]
Susp for TV process [NAME]
React for TV process [NAME] |  | CUG NOT GIVEN |  |  | C column error msg and A Column React for tv process rental charging message pair in this line, so display blank in B column,
Susp for TV process [NAME]
React for TV process [NAME]
New Activation |  | CUG NOT GIVEN
New Activation
New Activation |  | CUG NOT GIVEN
React for TV process [NAME]
React for TV process [NAME]
React for TV process [NAME]
Susp for TV process [NAME] |  | CUG NOT GIVEN
React for TV process [NAME]
React for TV process [NAME]
React for TV process [NAME]
React for TV process [NAME]
React for TV process [NAME]
React for TV process [NAME]
Susp for TV process [NAME]
React for TV process [NAME]
React for TV process [NAME]
React for TV process [NAME]
Susp for TV process [NAME] |  | CUG NOT GIVEN
New Activation
Susp for TV process [NAME]
React for TV process [NAME]
React for TV process [NAME] |  | PRICE GROUP WRONG
Susp for TV process [NAME] |  | PLAN CHANGED
Susp for TV process [NAME]
Susp for TV process [NAME] |  | CUG NOT GIVEN
Susp for TV process [NAME]
Susp for TV process [NAME]
React for TV process [NAME]
Susp for TV process [NAME]
React for TV process [NAME]
Susp for TV process [NAME] |  | CUG NOT GIVEN
Susp for TV process [NAME]
Susp for TV process [NAME]
React for TV process [NAME]
React for TV process [NAME]
New Activation
Susp for TV process [NAME]
Susp for TV process [NAME]
Susp for TV process [NAME] |  | CUG NOT GIVEN
Susp for TV process [NAME]
React for TV process [NAME]
React for TV process [NAME] |  | PLAN CHANGED
Susp for TV process [NAME]
React for TV process [NAME]
Susp for TV process [NAME]
React for TV process [NAME]
Susp for TV process [NAME] |  | CUG NOT GIVEN
New Activation
Susp for TV process [NAME]
React for TV process [NAME]
React for TV process [NAME]
Susp for TV process [NAME]
Susp for TV process [NAME] |  | CUG NOT GIVEN
React for TV process [NAME]
Susp for TV process [NAME]
React for TV process [NAME]
Susp for TV process [NAME] |  | CUG NOT GIVEN
React for TV process [NAME] |  | CUG NOT GIVEN
Number portability activation |  | CUG NOT GIVEN
Susp for TV process [NAME]
Susp for TV process [NAME]
Susp for TV process [NAME] |  | CUG NOT GIVEN
React for TV process [NAME]
React for TV process [NAME]
React for TV process [NAME]
Number portability activation
React for TV process [NAME]
0
Spreadsheet: 69373d1269917774-countif-current-week-values-and-increase-counter-if-it-is-true-arunsinghpundir
Sheet: Sheet1

 |  |  |  |  |  |  | Count of current week(considering Monday to Sunday) | 6
03/29/2010 |  |  |  | 2010-03-28 00:00:00 |  |  | Count of last week(considering Monday to Sunday) | 4
03/30/2010 |  |  |  | 2010-04-03 00:00:00 |  |  | Count of current month(considering March 1 to 31 March) | 6
2010-01-04 00:00:00 |  |  |  |  |  |  |  | 03/29/2010
2010-02-04 00:00:00 |  |  |  |  |  |  |  | 03/30/2010
2010-03-04 00:00:00 |  |  |  |  |  |  |  | [NAME]
03/22/2010 |  |  |  |  |  |  |  | 02/28/2010
[NAME] |  |  |  |  |  |  |  | 04/28/2010
[NAME] |  |  |  |  |  |  |  | 03/22/2010
03/29/2010 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | 03/29/2010
Spreadsheet: 777799d1650623189-match-if-vlookup-to-populate-a-list-of-data-and-corresponding-values-based-on-a-data-soa-sample2
Sheet: Sample SOA (2)

STATEMENT OF ACCOUNTS
 |  | Customer  Name : | Customer A
Customer A P.O.BOX: 39588, Abu Dhabi UAE TRN : 000000 |  |  |  | Dated: |  | 31.03.2022
Attn : ACCOUNTS PAYABLE
Invoice No | PO NUMBER | Department | Invoice Date | Amount in Euros | Amount in Aed | Due Date | REMARKS
 |  |  | Total Amt
 |  |  | Overdue Amt
Bank Details: XXXX, A/C. No. 0000 000 000 000 AED, IBAN: AE0000000000, SWIFT: XXXXXX
Accounts Dept.
ABCD
Spreadsheet: 271291d1381896641-sum-with-blank-cell-that-has-if-formula-wip-calculator
Sheet: October

***Balance Sheet is the "holder" of the WIP number.  It should always match report total.
Period 10 | October | Work In Progress Report
 |  | A | B | C | D | E | F | G | H | J
 |  | Job ID | Contract price | Esimated Job Cost Expenses | Estimated GP% | Total Actual Job Cost to date | % of completion of each job in accounting | Earned Revenue | TOTAL Invoiced to Client to date | Over(-) or [NAME]) Status
 |  | Report Total
 |  | Once you have given your final invoice for a project, take the project off this report. |  |  |  |  |  | Report Status
 |  |  |  |  |  |  |  | Prior Period to adjust
Entries for BN Numbers
Period 10 | October |  |  | Enter the amount showing on line #3 of the appropriate 'Profit Center' in the 'Profit Center" tab.
 |  |  |  | Enter this amount on line #3 of the 'Balance Sheet' in the 'Financial Data" tab.
 |  |  |  | Enter this amount on line #13 of the 'Balance Sheet' in the 'Financial Data" tab.
Journal Entries for Accounting Software
Period 10 | October |  | Journal Entry      Dated October 31
 |  |  | G/L Account |  | Debit | Credit
 |  |  | WIP Income Acct
 |  |  | WIP Asset Acct
 |  |  | !!!REVERSE JOURNAL ENTRY!!!      Dated November 1
 |  |  | G/L Account |  | Debit | Credit
 |  |  | WIP Income Acct
 |  |  | WIP Asset Acct
 |  |  | Journal Entry      Dated October 31
 |  |  | G/L Account |  | Debit | Credit
 |  |  |  | WIP Income Acct
 |  |  |  | WIP Liability Acct
 |  |  | !!!REVERSE JOURNAL ENTRY!!!      Dated November 1
 |  |  | G/L Account |  | Debit | Credit
 |  |  |  | WIP Income Acct
 |  |  |  | WIP Liability Acct
Spreadsheet: 776194d1649589856-weekly-adding-constant-mappe-2
Sheet: Tabelle1

 |  | Start | ad weekly 8k | count weekly 1k
 | [NAME]
 | Kenny
 | Benji
 | Marius
 | Wao
 | Nickname
 | Caillou
 | KNCKA
 | DON
 |  |  |  |  |  |  |  |  |  | 53854
 |  |  |  |  |  |  |  |  |  | 51551
 |  |  |  |  |  |  |  |  |  | 50226
 |  |  |  |  |  |  |  |  |  | 46672
 |  |  |  |  |  |  |  |  |  | 44076
 |  |  |  |  |  |  |  |  |  | 42584
 |  |  |  |  |  |  |  |  |  | 39799
 |  |  |  |  |  |  |  |  |  | 39799
 |  |  |  |  |  |  |  |  |  | 31942
Spreadsheet: 705900d1606369425-lookup-for-multile-matches-to-use-them-in-data-validation-sample-1-
Sheet: Link

S No. | Category | Description
1 | SW - BOSS | BOSS 1/2" 3000# NPT THRD A182 F316/316L
2 | SW - BOSS | BOSS 1/2" 6000# SW UNS N06625
3 | SW - BOSS | BOSS 3/4" 6000# NPT THRD A694 F60
4 | SW - BOSS | BOSS 3/4" 6000# SW A694 F60
5 | SW - BOSS | BOSS 3/4" 6000# SW UNS N06625
6 | DBB VALVE | MANIFOLD MONOFLANGE DBDB 1 13/16" 10000# X 1/2" NPTF SS316/316L NACE
7 | DBB VALVE | MANIFOLD MONOFLANGE DBDB 1 13/16" 10000# X 1/2" NPTF UNS N06625 NACE
8 | DBB VALVE | MANIFOLD MONOFLANGE DBDB 2" 1500# X 1/2" NPTF SS316/316L NACE
9 | DBB VALVE | MANIFOLD MONOFLANGE DBDB 2" 1500# X 1/2" NPTF UNS N06625 NACE
10 | DBB VALVE | MANIFOLD MONOFLANGE DBDB 2" 1500# X 2" 1500# SS316/316L NACE
11 | DBB VALVE | MANIFOLD MONOFLANGE DBDB 2" 1500# X 2" 1500# UNS N06625 NACE
12 | INSULATION KIT | GASKET KIT 1 13/16" 10000# W/O SLEEVE & WASHER SS316
13 | INSULATION KIT | GASKET KIT 2" 1500# W/O SLEEVE & WASHER SS316
14 | INSULATION KIT | GASKET KIT 5 1/8" 10000# W/O SLEEVE & WASHER SS316
15 | INSULATION KIT | GASKET KIT 6" 1500# W/O SLEEVE & WASHER SS316
16 | INSULATION KIT | GASKET KIT 8" 1500# W/O SLEEVE & WASHER SS316
17 | INSULATION KIT | GASKET KIT 4 1/16" 10000# W/O SLEEVE & WASHER SS316
18 | INSULATION KIT | GASKET KIT 4" 1500# W/O SLEEVE & WASHER SS316
19 | GATE VALVE | VALVE GATE RB 1/2" 1500# SW X NPTF UNS N06625
20 | GLOBE VALVE | VALVE GLOBE 1/2" 1500# SW UNS N06625
21 | GATE VALVE | VALVE GATE RB 1/2" 1500# SW UNS N06625
22 | GLOBE VALVE | VALVE GLOBE 1/2" 1500# SW X NPTF UNS N06625
23 | GATE VALVE | VALVE GATE RB 3/4" 1500# SW X NPTF UNS N06625
24 | GATE VALVE | VALVE GATE RB 3/4" 1500# NPTF UNS N06625
25 | PLUG VALVE | VALVE PLUG 2" 1500# LHS RTJ UNS N06625
26 | PLUG VALVE | VALVE PLUG 2" 1500# RHS RTJ UNS N06625
27 | STUD BOLT | STUD BOLT 1 3/8" X 280 A193 B8M CL2/194 8M/SS316