tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 86383d1286376624-need-to-count-productivity-by-weekly-and-daily-basis-qc-report
Sheet: PMT

 | Reported Date is : | 2010-10-06 00:00:00 |  | Monthly Period |  | 2010-10-01 00:00:00 |  | To
 | Reported Date is : | 2010-10-06 00:00:00 |  | Weekly Period |  | 2010-10-04 00:00:00 |  | To
 | Reported Date is : | 2010-10-06 00:00:00 |  | Daily Period |  | 2010-10-06 00:00:00 |  | To
 | Processor Name | # of File Processed |  |  |  | QC Name | # of File QC'd
 |  | Monthly | Weekly | Daily |  |  | Monthly | Weekly | Daily
 | [NAME] |  |  |  |  | [NAME]
 | Vinod |  |  |  |  | Vinod
 | Hiren |  |  |  |  | Hiren
 | Nikhilesh |  |  |  |  | Nikhilesh
 | Prawin |  |  |  |  | Prawin
 |  |  |  |  |  | Kamran
 | Total |  |  |  |  | Total
 |  |  | {=SUMPRODUCT((FTS!$C$8:$C$6535>=$F$2)*1*(FTS!$C$8:$C$6535<=$I$2+1))
 |  |  | {=IF(B8="","",COUNTIF(QC!$CM$6:$CM$1050,$B8))
Spreadsheet: 188392d1350870253-is-it-possible-to-create-a-searchbox-in-a-cell-to-find-multiple-worksheet-the-sample-2
Sheet: ST 9151 J

REF: ST 9151 J
 |  |  |  | SYARIKAT KHIUN CHIN MOTOR JAYA
 |  |  |  | LOT 10, BLOCK B, BANDAR BARU,
 |  |  |  | P.O.BOX NUMBER 318,
 |  |  |  | 91307 SEMPORNA SABAH
 |  |  |  | NO TEL: 089- 143 |  |  | DATE:25/08/2011
 | [NAME] |  | ATIEH BIN KASIM |  |  | HARGA JUALAN: |  | RM 3800
 | NOMBOR IC |  | TIADA DALAM REKOD |  |  | DEPOSIT: |  | RM 1500
 |  |  |  |  |  | PINJAMAN: |  | RM 2300
 | ALAMAT |  | TIADA DALAM REKOD |  |  | BUNGA: |  | RM 460
 | [NAME] |  | TIADA DALAM REKOD |  |  | AGREEMENT |  | 24 MONTHS
 | MODEL: |  | MODENAS KRISTAR |  |  | BAKI: |  | RM 2760
 | NO. ENJIN |  | MN110HEL09354 |  |  | BULANAN: |  | RM 115
 | NO. CHASIS |  | PMNMN110H1ML09811
 |  |  |  | ACCOUNT DETAILS
 |  |  |  |  |  | RM | RM | RM
 | NO. RESIT | DATE | [NAME] |  |  | DEBIT | CREDIT | BALANCE
 |  | 25/08/2011 | BALANCE |  |  |  | 2760 | 2760
 | 1544 | 13/10/2011 | INSTALLMENT FOR  SEPTEMBER |  |  | 115
 | 5767 | 28/10/2011 | INSTALLMENT FOR  OCTOBER |  |  | 115
 | 5801 | 30/11/2011 | INSTALLMENT FOR NOVEMBER |  |  | 115
 | 5837 | 29/12/2011 | INSTALLMENT FOR DECEMBER |  |  | 115
 | 5873 | 30/01/2012 | INSTALLMENT FOR JANUARY |  |  | 115
 | 5916 | 26/02/2012 | INSTALLMENT FOR FEBRUARY |  |  | 115
 | 5955 | 28/03/2012 | INSTALLMENT FOR [NAME] |  |  | 115
 | 5986 | 23/04/2012 | INSTALLMENT FOR APRIL |  |  | 115
 | 6029 | 24/05/2012 | INSTALLMENT FOR MAY |  |  | 115
 | 6058 | 2012-12-06 00:00:00 | INSTALLMENT FOR JUNE |  |  | 115
 | 6110 | 22/07/2012 | INSTALLMENT FOR JULY |  |  | 115
 | 6155 | 2012-02-09 00:00:00 | INSTALLMENT AUGUST |  |  | 115
 | 6179 | 15/09/2012 | INSTALLMENT FOR SEPTEMBER |  |  | 230
 | 6216 | 14/10/2012 | INSTALLMENT FOR [NAME] |  |  | 115
Spreadsheet: mary_fischer__25629__1580  6-2001
Sheet: E12.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
ANALYSIS OF LONG-TERM DEBT
FOR THE 3 MONTHS ENDED 3-31-2001
 |  |  |  |  |  |  |  |  |  |  |  | ** Credit Positive Liability  (Debit Negative Liability) **
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-12
 |  |  |  |  |  |  |  | ORIGINAL |  | BEGINNING BALANCE |  |  |  |  |  |  |  |  |  | OTHER (NON-CASH) |  |  |  | ENDING BALANCE
PAYEE AND [NAME] |  | HYPERION |  | DUE |  | INTEREST |  | AMOUNT |  | CURRENT |  | LONG-TERM |  |  |  | ADDITIONS |  | RETIREMENTS |  | AMOUNT |  | [NAME] |  | CURRENT |  | LONG-TERM
 |  | ACCOUNT |  | DATE |  | RATE |  | AUTHORIZED |  | PORTION |  | PORTION |  | TOTAL |  | DR (CR) |  | DR (CR) |  | DR (CR) |  |  |  | PORTION |  | PORTION |  | TOTAL
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Current:
Current Maturities of Long-Term Debt * |  | 0450 |  |  |  | 0
Notes Payable - Other |  | TOT_NP_OTHER |  | 2001-03-01 00:00:00 |  | 0.085
Total Short-Term
Long-Term:
Long-Term Debt (Hyperion Accts. 0705, 0770)
Notes (list by name of payee or issue):
 |  |  |  |  |  | 0.085
Total (Hyperion Accts 0705 & 0770)
Current Maturities of L/T Debt (Contra) * |  | 0775
Unamortized Premium on L/T Debt |  | 0765
Total Long-Term Debt
Total Debt  DR/(CR)
!!DO NOT INCLUDE INTERCOMPANY DEBT!!
*  HYPERION ACCOUNTS 0450 & 0775 MUST BE THE SAME AMOUNT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-12
 |  |  |  | Income Accts:  (DR)/CR Reverse signs from Hyperion
 |  |  |  |  |  |  | Income Accts: (DR)/CR  Reverse signs from Hyperion
Spreadsheet: 781900d1653635797-formula-to-get-data-horizontal-with-collumn-name-example-v3
Sheet: Sheet2

interface | ipv4 | shutdown | voice_vlan | DHCP_Option | description | allowed_vlan | native_vlan | Cisco int. | Macro | Command_INT | Command_macro | Port_config_apply
Bridge-Aggregation1 |  |  |  |  |  |  |  | veld1 | M1
NULL0 |  |  |  |  |  |  |  | veld2 | M2
Vlan-interface1 |  |  |  |  |  |  |  | veld3 | M3
Vlan-interface11 |  |  |  |  | mgmt |  |  | veld4 | M4
GigabitEthernet1/0/1 |  |  | 1111 |  | DES1 | 1111 | 1111 | G1/0/2 | M4
GigabitEthernet1/0/2 |  |  | 1111 |  | DES2 | 1111 | 1111 | G1/0/1 | M4
GigabitEthernet1/0/3 |  |  | 1111 |  | [NAME] | 1111 | 1111 | G1/0/4 | M4
GigabitEthernet1/0/4 |  | shutdown | 1111 |  | DES4 | 1111 | 1111 | G1/0/3 | M4
GigabitEthernet1/0/5 |  | shutdown | 1111 |  | DES5 | 1111 | 1111 | G1/0/6 | M4
GigabitEthernet1/0/6 |  |  | 1111 |  | DES6 | 1111 | 1111 | G1/0/5 | M4
GigabitEthernet1/0/7 |  |  | 1111 |  | DES7 | 1111 | 1111 | G1/0/8 | M4
GigabitEthernet1/0/8 |  |  | 1111 |  | DES8 | 1111 | 1111 | G1/0/7 | M4
GigabitEthernet1/0/9 |  |  | 1111 |  | DES9 | 1111 | 1111 | G1/0/10 | M4
GigabitEthernet1/0/10 |  |  | 1111 |  | DES10 | 1111 | 1111 | G1/0/9 | M4
GigabitEthernet1/0/11 |  |  | 1111 |  | DES11 | 1111 | 1111 | G1/0/12 | M4
GigabitEthernet1/0/12 |  |  | 1111 |  | DES12 | 1111 | 1111 | G1/0/11 | M4
GigabitEthernet1/0/13 |  |  | 1111 |  | DES13 | 1111 | 1111 | G1/0/14 | M4
GigabitEthernet1/0/14 |  |  | 1111 |  | DES14 | 1111 | 1111 | G1/0/13 | M4
GigabitEthernet1/0/15 |  | shutdown | 1111 |  | DES15 | 1111 | 1111 | G1/0/16 | M4
Spreadsheet: 241532d1370630352-cascading-two-tier-drop-downs-in-form-control-sample-of-data-layout
Sheet: Sample data layout

Customer | Product | Amount | Acct month
Customer1 | Product1 | 200 | 1 |  |  |  | Customer List | Product List |  |  |  |  |  |  |  | Month | Amount
Customer1 | Product2 | 100 | 2 |  |  |  | Customer1 | Product1 |  | <-- create your lists |  |  |  |  |  | 1 |  | <-- this formula show the total amount for
CUstomr2 | prodcut 1 | 500 | 1 |  |  |  | Customer2 | Product2 |  |  |  |  |  |  |  | 2 |  | each month based on the customer an
Customer2 | product1 | 300 | 2 |  |  |  | Customer3 | Product3 |  |  |  |  |  |  |  | 3 |  | product selected
Customer2 | product1 | 500 | 3 |  |  |  | Customer4 | Product4 |  |  |  |  |  |  |  | 4
Customer3 | product2 | 100 | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 5
Customer3 | product4 | 100 | 2 |  |  |  |  |  |  |  |  |  |  |  |  | 6
Customer3 | product4 | 100 | 3 |  |  |  |  |  |  |  |  |  |  |  |  | 7
Customer 4 | product3 | 100 | 1 |  |  |  | [NAME] | Select Product |  |  |  |  |  |  |  | 8
customer4 | product3 | 100 | 2 |  |  |  | Customer1 | Product1 |  | <--Use data validation to create drop down lists |  |  |  |  |  | 9
customer4 | prodcu3 | 100 | 3 |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
Spreadsheet: b5eb85e2-4586-41b6-9c3e-f6824e85a177
Sheet: Balance

BALANCE
 |  |  |  |  |  | 2012 |  | Budget 2012
[NAME]
Note | Omsætningsaktiver
 | Tilgodehavender
 | Periodeafgræsningsposter
 | OMSÆTNINGSAKTIVER I ALT
 | Likvide midler
 | AKTIVER I ALT
PASSIVER
 | Egenkapital
 | Gæld
 | Kreditorer
 | Gæld til Arbejdstilsynet
 | Anden gæld
 | Periodeafgrænsningsposter
 | Gæld i alt
 | PASSIVER I ALT
 | Eventualforpligtelser
Spreadsheet: 198748d1354887419-match-and-vlookup-matchlookup-problem
Sheet: t_Employee_UDF_data

employee_udf_id | user_id | employee_id | string_data | numeric_data | currency_data | check_data | date_data | description | type
6 | 0 | 8 | Manager |  |  |  |  | 01 - Current Job Title | String
7 | 0 | 8 | 25 |  |  |  |  | 02 - Bonus Entitlement % | String
8 | 0 | 8 | 12354 |  |  |  |  | 03 - Car Allowance (PA) | String
9 | 0 | 8 |  |  |  |  |  | 04 - PMI Entitlement | String
10 | 0 | 8 |  |  |  |  |  | 05 - PMI Member | String
11 | 0 | 8 | 42 |  |  |  |  | 06 - Contracted Hours | String
12 | 0 | 8 | 82 |  |  |  |  | 07 - CSP Entitlement | String
13 | 0 | 8 | 1990-05-05 00:00:00 |  |  |  |  | 08 - Date of TUPE | String
14 | 0 | 8 | 2012-05-05 00:00:00 |  |  |  |  | 09 - DateEndProbation | String
15 | 0 | 8 |  |  |  |  |  | 10 - Probation Status | String
16 | 0 | 8 | 2012-12-12 00:00:00 |  |  |  |  | 11 - Contract End Date | String
17 | 0 | 8 | 2013-12-12 00:00:00 |  |  |  |  | 12 - DateOfLeaving | String
18 | 0 | 8 |  |  |  |  |  | 13 - Reason For Leaving | String
19 | 0 | 8 |  |  |  |  |  | 14 - Additional Contract Terms | String
20 | 0 | 8 |  |  |  |  |  | 15  - RTW Documents | String
21 | 0 | 8 |  |  |  |  |  | 16 - RTW Type of Permit | String
22 | 0 | 8 | 1990-05-05 00:00:00 |  |  |  |  | 17 - RTW Valid From | String
23 | 0 | 8 | 2012-12-12 00:00:00 |  |  |  |  | 18 - RTW Valid Until | String
24 | 0 | 8 | 2013-12-12 00:00:00 |  |  |  |  | 19 - RTW Next Check Required | String
25 | 0 | 8 |  |  |  |  |  | 20 - RTW Comments | String
Spreadsheet: 887656d1737949422-index-sumproduct-spill-issue-afl-supercoach-2025-test
Sheet: GCS

PLAYER | TOT | AVG |  |  |  | 0 | 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
 |  | CBA | CBA 1H | CBA2H | CBA L5
[NAME] | 373 |  |  |  |  | 78 | 84 |  |  | 86 | 82 | 93 | 82 | 90 | 89 |  | 83 |  |  |  | 85 | 90 |  |  |  | 60 | 93 | 82 | 80 | 82
[NAME] | 525 |  |  |  |  | 74 | 74 | 87 |  | 89 | 89 | 74 | 85 | 85 | 79 | 82 | 80 | 90 | 100 |  | 77 | 74 | 79 | 93 | 83 | 92 | 80 | 75 | 53 | 75
[NAME] | 176 |  |  |  |  |  |  | 71 |  |  |  |  |  |  |  | 84 |  | 86 | 83 |  |  |  | 72 | 96 | 83 | 36
[NAME] | 495 |  |  |  |  | 93 | 84 | 74 |  | 77 | 79 | 70 | 82 | 70 | 86 | 73 | 87 | 86 | 89 |  | 85 | 65 | 83 | 50 | 63 | 56 | 73 | 75 | 73 | 89
[NAME] | 312 |  |  |  |  | 78 | 68 | 87 |  | 63 | 64 | 70 | 85 | 70 | 43 | 64 | 83 | 52 | 61 |  | 65 | 32 | 28 |  |  |  |  |  | 30 | 54
[NAME] | 109 |  |  |  |  |  |  |  |  |  |  |  |  |  | 43 | 48 | 33 |  |  |  |  |  |  | 54 |  |  |  | 71 | 50 | 57
[NAME] | 190 |  |  |  |  |  |  |  |  | 49 | 43 | 52 | 39 | 35 |  |  |  | 62 | 22 |  | 23 | 42 | 31 | 18 | 17 | 32 | 67 | 79 | 60 | 0
[NAME] | 193 |  |  |  |  | 56 | 53 | 39 |  | 0 | 0 | 0 | 9 | 40 | 0 | 0 |  | 0 | 0 |  | 23 | 87 | 62 | 86 | 83 | 88 | 77 | 0 | 7 | 11
[NAME] | 18 |  |  |  |  | 22 | 16 | 29
[NAME] | 19 |  |  |  |  |  |  |  |  |  |  |  | 18 |  |  | 9 |  |  |  |  | 4 | 10 | 17
[NAME] | 12 |  |  |  |  |  |  |  |  | 14 | 18 | 4 |  | 5
[NAME] | 57 |  |  |  |  | 0 | 0 | 13 |  | 0 | 4 | 15 | 0 | 0 |  | 23 | 0 | 10 | 28 |  | 15 | 0 | 0 |  | 54 | 32 | 0 | 0 | 17
[NAME] | 50 |  |  |  |  | 0 | 21 |  |  | 23 | 18 | 15 | 0 |  | 39 | 2 | 23 | 0 | 0 |  | 8 | 0 | 14 | 0 | 0 | 0 | 3 | 0 | 10 | 0
[NAME] | 34 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 5 | 11 | 7 | 7 | 0 | 0 |  | 12 | 0 | 10 | 0 | 0 | 4 | 7 | 18 | 20 | 18
[NAME] | 11 |  |  |  |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 14 | 17 |  |  |  |  | 0 | 17 |  |  | 0 | 0
[NAME] | 7 |  |  |  |  |  |  |  |  |  |  | 4 | 0 | 0 | 0 |  | 3 |  |  |  | 4 |  |  |  |  |  |  | 0 | 0 | 14
[NAME] | 7 |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 11 | 9 | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  | 0
[NAME] | 1 |  |  |  |  | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  | 0 | 0
[NAME] | 1 |  |  |  |  | 0 | 0 | 0 |  | 0 | 4 | 0 | 0 | 0 |  | 0 |  | 0 | 0 |  |  |  |  |  |  |  | 0
[NAME] | 1 |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 3 | 0
[NAME] | 1 |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
Total Team CBAs |  |  |  |  |  | 27 | 19 | 31 |  | 35 | 28 | 27 | 33 | 20 | 28 | 44 | 30 | 29 | 18 |  | 26 | 31 | 29 | 28 | 24 | 25 | 30 | 28 | 30 | 28
Spreadsheet: 550376d1512258426-only-those-values-are-required-which-are-to-the-left-of-stated-value-rev02
Sheet: Revised

SL No | Sequences | Output |  | Lookup list
1 | A1, [NAME], A7, A2, A8, A5 |  |  | A2
2 | A3, A9, [NAME], A6, A5, A2C, A7, A4, A8 |  |  | A2C
3 | A5, A7, [NAME], A4, B2, A0, A6 |  |  | B2
4 | A6, [NAME], BA2, A1 |  |  | BA2
5 | A5, A4, A6, [NAME], A9, A7, B2 |  |  | C2
6 | A1, A4, C2, A7, A8, A9, A5 |  |  | C2AD
7 | A4, C2AD, [NAME] |  |  | C
8 | A0, [NAME], C |  |  | D2
9 | A5, A6, A7, A8, A9, D2, A0, A1 |  |  | D2C
10 | A0, A3, A5, D2C, A7, A8 |  |  | AD2
11 | A7, A6, A5, A1, D2, A3, A0 |  |  | E2
12 | A0, A5, A6, A9, A3, AD2, [NAME], A7, A4 |  |  | EF2
13 | A0, A9, A8, [NAME], A1, A3, A5, A4 |  |  | F2
14 | A9, A6, E2, A0, A1 |  |  | FZ2
15 | A1, A9, A7, A6, EF2, A5 |  |  | AG23
16 | A5, A4, A6, [NAME], A9, A7, E2 |  |  | G2
17 | A1, A4, E2, A7, A8, A9, A5, A3 |  |  | GF2
18 | A0, A5, A6, A9, A3, [NAME], A1 |  |  | G
19 | A0, A9, A8, FZ2, A1
20 | A1, [NAME], A7, [NAME], A8, A5
21 | A3, A9, [NAME], A6, A5, F2, A7, A4, A8
22 | A5, A7, [NAME], A4, AG23, A0
23 | A5, A4, A6, [NAME], A9, A7, G2, A1
24 | A7, A6, A5, A1, GF2, A3,A4
25 | A6, [NAME], G, A1, A5
Note: I have filled the Column "Output" (i.e. Column C) manually. I have retained only those values which are to the left of red coloured one's and including red coloured one's. To the right of the red coloured one's must be deleted.
Spreadsheet: 886556d1736591245-formola-required-to-return-text-excel-forum
Sheet: Sheet1

 |  |  |  | Befor |  |  |  |  | Result required
 |  |  |  | Total : | RQ ST H |  | Reason Desciption |  | Total : | RQ ST H |  | Reason Desciption
 |  |  |  |  | 0 |  | Financial Audit |  |  | 0
 |  |  |  | Total : |  |  |  |  | Total : |  |  | Financial Audit
 |  |  |  |  | 0 |  |  |  |  | 0
 |  |  |  |  | 83.07692307692308 |  |  |  |  | 83.07692307692308
 |  |  |  | Total : |  |  |  |  | Total :
 |  |  |  |  | 24 |  |  |  |  | 24
 |  |  |  |  | 6 |  | utility not available |  |  | 6
 |  |  |  |  | 15 |  |  |  |  | 15
 |  |  |  | Total : |  |  |  |  | Total : |  |  | utility not available
 |  |  |  |  | 8.0256 |  |  |  |  | 8.0256
 |  |  |  |  | 0 |  |  |  |  | 0
 |  |  |  |  | 9.6 |  |  |  |  | 9.6
 |  |  |  |  | 96 |  | change over |  |  | 96
 |  |  |  |  | 86.4 |  |  |  |  | 86.4
 |  |  |  | Total : |  |  |  |  | Total : |  |  | change over
 |  |  |  |  | 17.45454545454545 |  |  |  |  | 17.45454545454545
 |  |  |  |  | 61.44 |  | Financial Audit |  |  | 61.44
 |  |  |  | Total : |  |  |  |  | Total : |  |  | Financial Audit
 |  |  |  |  | 48 |  | mecnical breakdown |  |  | 48
 |  |  |  | Total : |  |  |  |  | Total : |  |  | mecnical breakdown
 |  |  |  |  | 144 |  |  |  |  | 144
 |  |  |  | Total : |  |  |  |  | Total :
 |  |  |  |  | 30.83636363636364 |  | Financial Audit |  |  | 30.83636363636364
 |  |  |  | Total : |  |  |  |  | Total : |  |  | Financial Audit
 |  |  |  |  | 0 |  | elactrical breakdowb |  |  | 0
 |  |  |  |  | 0 |  |  |  |  | 0
 |  |  |  | Total : |  |  |  |  | Total : |  |  | elactrical breakdowb
 |  |  |  |  | 0 |  | MIXE not available |  |  | 0
 |  |  |  | Total : |  |  |  |  | Total : |  |  | MIXE not available
 |  |  |  |  | 0 |  | Financial Audit |  |  | 0
 |  |  |  | Total : |  |  |  |  | Total : |  |  | Financial Audit
 |  |  |  |  | 27.2 |  |  |  |  | 27.2
 |  |  |  | Total : |  |  |  |  | Total :
 |  |  |  |  | 0 |  | material not available |  |  | 0
 |  |  |  |  | 0 |  |  |  |  | 0
 |  |  |  | Total : |  |  |  |  | Total : |  |  | material not available
 |  |  |  |  | 0 |  | Financial Audit |  |  | 0
 |  |  |  |  | 0
 |  |  |  | Total :
 |  |  |  |  | 0
 |  |  |  |  | 38.21176470588235
 |  |  |  | Total :
 |  |  |  |  | 90.496
 |  |  |  | Total :
 |  |  |  |  | 83.9513043478261
 |  |  |  | Total :
 |  |  |  |  | 0 |  | shortage of manpower
 |  |  |  | Total :
 |  |  |  |  | 0 |  | Financial Audit
 |  |  |  | Total :
 |  |  |  |  | 48.16
 |  |  |  | Total :
 |  |  |  |  | 0 |  | Financial Audit
 |  |  |  | Total :
 |  |  |  |  | 0 |  | Financial Audit
 |  |  |  | Total :
 |  |  |  |  | 60
 |  |  |  | Total :
 |  |  |  |  | 48
 |  |  |  |  | 48.8
 |  |  |  | Total :
 |  |  |  |  | 0 |  | All plant washing cleaning (Financial Audit
Spreadsheet: 2a7e5a19-5466-40ff-bb22-7ad6d0ab1be4
Sheet: Sheet1

Contract Number | [NAME] | Project Name | Term Start Date | Exp. Date | Project Amount / Annual Amount
13-FS-51 | [NAME] | FY13 Financial Audit | 2013-06-18 00:00:00 | 2014-06-17 00:00:00 | 70780
12-PW-56 | Anderson-Brown, Inc. | Cabezon WWTF#6 - 0.6 MGD Expansion | 2012-05-12 00:00:00 | 2013-06-23 00:00:00 | 3472505.17
13-AD-60 | New Cingular Wireless PCS, LLC | Land Lease Agreement | 2013-07-25 00:00:00 | 2018-07-24 00:00:00 | 18540
13-AD-61 | New Cingular Wireless PCS, LLC | Land Lease Agreement | 2013-07-25 00:00:00 | 2018-07-24 00:00:00 | 20000
14-PW-01 | ZENON Environmental Corporation | Service Agreement - Cabezon | 2013-03-24 00:00:00 | 2014-03-23 00:00:00 | 14134
14-PW-02 | ZENON Environmental Corporation | Service Agreement - Mariposa | 2013-07-25 00:00:00 | 2014-07-25 00:00:00 | 22072
14-PW-03 | Environmental Systems Research Institute, Inc. | Enterprise Software License Agreement | 2013-07-05 00:00:00 | 2014-07-04 00:00:00 | 50000
14-PW-05 | Huitt-Zollars, Inc. | Lift Station #10 Relocation | 2013-08-05 00:00:00 | 2014-06-01 00:00:00 | 393843.5
14-PW-07 | Franklins Earthmoving, Inc. | Obregon Road Improvements | 2013-07-24 00:00:00 | 2013-08-21 00:00:00 | 125687.69
14-PW-08 | Huitt-Zollars, Inc. | Idalia Road Reconstruction Design | 2013-07-29 00:00:00 | 2014-08-29 00:00:00 | 1414671.7
14-AC-09 | New Mexico Gas Company | Natural Gas Line Extension Agreement - Animal Control | 2013-07-24 00:00:00 | 2014-07-23 00:00:00 | 19901.21
14-FR-10 | The Regents of the University of New Mexico, UNM Medical Group, Inc. | Professional Services Agreement - Medical Director for EMS | 2013-07-01 00:00:00 | 2014-06-30 00:00:00 | 34999.92
14-PW-11 | Sundance Mechanical Utility Corp. | Montoyas Arroyo Sanitary Sewer Improvements | 2013-10-01 00:00:00 | 2014-01-29 00:00:00 | 993845.64
14-PW-12 | Geographic Technologies Group, Inc. | GIS Software Licence and Services Agreement | 2013-08-05 00:00:00 | 2018-08-04 00:00:00 | 9324
14-PW-13 | [NAME]'s Construction, LLC | Esplanade Repairs | 2013-09-16 00:00:00 | 2013-10-16 00:00:00 | 47078
14-PW-14 | Wilson & Company Inc., Engineers and Architects | Southern Blvd. Preliminary Design | 2013-09-27 00:00:00 | 2014-09-27 00:00:00 | 885441
14-PW-15 | Huitt-Zollars, Inc. | Cabezon Reuse Switchover & Lift Station #2 Improvements | 2013-08-23 00:00:00 | 2014-08-23 00:00:00 | 176690
14-PS-17 | Bullard, [NAME] | Professional Services Agreement - TraCS Server Installation and Implementation | 2013-09-18 00:00:00 | 2014-09-17 00:00:00 | 15000
Spreadsheet: 329476d1404317853-adding-indirect-formula-to-a-countif-es3-cs-wholesale-load-tracking-report-test
Sheet: 6-29

2014-06-29 00:00:00
ES3/C&S WHOLESALE LOAD TRACKING
STOP 1 WILL ALWAYS BE ORIGIN - LEAVE SECTION BLANK FOR ANY NON-APPLICALBE STOP, ON ANY GIVE LOAD
REPORTING UPDATE TIME | TRUCK # | ROUTE # | DC or Store | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00
08:00:00
09:00:00
10:00:00
11:00:00
12:00:00
13:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | DC or Store | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00
08:00:00
09:00:00
10:00:00
11:00:00
12:00:00
13:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | DC or Store | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00
08:00:00
09:00:00
10:00:00
11:00:00
12:00:00
13:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | DC or Store | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00
08:00:00
09:00:00
10:00:00
11:00:00
12:00:00
13:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | DC or Store | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00
08:00:00
09:00:00
10:00:00
11:00:00
12:00:00
13:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | DC or Store | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00
08:00:00
09:00:00
10:00:00
11:00:00
12:00:00
13:00:00
Spreadsheet: 803819d1667725548-how-to-do-fast-replacing-of-row-number-accross-different-columns-copy-of-baza-nova-verzija-racuni-1-
Sheet: R48

Ime artikla
Spreadsheet: 852697d1702648831-search-entire-workbook-and-display-results-search-jacc
Sheet: All data

 | Customer A Part No. | Customer B Part No. | Customer C Part No. |  | Results | Index
 | A001F | AA-001-F | [NAME]
AA002MX | A002F | AA-002-F | A2MX |  | 2 | 2
AA003MX | A003F | AA-003-F | A3MX |  | 3 | 3
[NAME] | A004F | AA-004-F | A4MX |  | 4 | 4
AA005MX | A005F | AA-005-F | A5MX |  | 5 | 5
BB001MX | B001F | BB-001-F | [NAME] |  | 6 | 6
BB002MX | B002F | BB-002-F | B2MX |  | 7 | 7
BB003MX | B003F | BB-003-F | [NAME] |  | 8 | 8
BB004MX | B004F | BB-004-F | B4MX |  | 9 | 9
BB005MX | B005F | BB-005-F | B5MX |  | 10 | 10
CC001MX | C001F | CC-001-F | C1MX |  | 11 | 11
CC002MX | C002F | CC-002-F | C2MX |  | 12 | 12
[NAME] | C003F | CC-003-F | [NAME] |  | 13 | 13
CC004MX | C004F | CC-004-F | C4MX |  | 14 | 14
CC005MX | C005F | CC-005-F | C5MX |  | 15 | 15
Spreadsheet: 238701d1369680373-help-me-pivot-tables-sumif-vlook-up-excel-questionss
Sheet: Questions

SUMIFS | Complete the table below from the 'PG Google' data
 | Using a pivot table & the sum formula
 |  | Office Accidents | Construction Accidents | Work Slips | Factory Accidents | Work Accident | Military Accidents | Both Work Campaigns | Total  (all campaigns)
 | 2011-01-01 00:00:00
 | 2011-01-02 00:00:00
 | 2011-01-03 00:00:00
 | 2011-01-04 00:00:00
 | 2011-01-05 00:00:00
 | 2011-01-06 00:00:00
FILTERS | Use a filter in the 'aspect calls' tab to find out how many calls Aspect had on the 2nd Jan, from campaigns which contained the term 'emergency' that lasted over 3 minutes
 | Call date | Campaign | Call length (minutes)
 | 02.01.2011 | Electrician Emergency | 3.5
TEXT TO COLUMNS OR LEFT/RIGHT, SUMIF & COUNTIF | Complete the table below from the 'Rush Data' tab
 | Then put this data into a line graph
 | Now change the 'sales' to a column graph
 | Use a SumIf Formula
 |  | Total revenue | Quantity
 | TIG
 | KER
 | RED
 | AME
VLOOKUP | Complete the table below from the 'Staff' tab
 | Use a vlookup formula
 |  | Holidays | Bonus
 | Stacy
 | [NAME]
 | [NAME]
 | [NAME]
Spreadsheet: 766349d1643862592-find-words-with-letter-interchange-copy-of-vowel-exchange-1
Sheet: Sheet1

 |  |  |  |  |  |  |  | check with next row |  |  |  |  |  |  |  |  |  | Result | if 2 , swap |  |  | check with above row |  |  |  |  |  |  |  |  |  | Result
NOTAIRE |  | s | 1 | AEINORT
ROASTED |  |  | 2 | AEINORT
TORSADE |  | s | 3 | AEEIORT
TROADES |  | s | 4 | ADEINOR
OUTDARE | t | s | 5 | AEILNOR
ALERION |  | s | 6 | AEILNOR
ALIENOR |  | s | 7 | AEILNOR
ELATION | dgr | s | 8 | AEILNOT
DOGSHIP |  | s | 9 | AEILNOT
GODSHIP |  | s | 10 | AEINORS
ATONIES |  |  | 11 | AEINOST
OARIEST | hr |  | 12 | AEIORST
OTARIES | [NAME] |  | 13 | AEIORST
ROASTIE |  | s | 14 | AEIORST | NEW IN CSW15
SKREIGH |  | s | 21463 | EGHIKRS
SKRIEGH |  | s | 21464 | EGHIKRS