tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 681034d1591306352-static-menu-formatting-workbook-menu-idea
Sheet: Settings

 |  | Settings
 | Overview!A1
 |  |  | Menu Names |  |  | Tax Rates (Not Updated) |  |  |  | Fee Percentages (Used in [NAME])
 | ESales!A1 |  | Overview |  |  | AL | Alabama | 0.04 |  | Fee 1 | 0.01
 | BCSales!A1 |  | --- |  |  | AK | Alaska | 0 |  | Fee 2 | 0.02
 | Settings!A1 |  | E Sales |  |  | AZ | Arizona | 0.056 |  | Fee 3 | 0.03
 | INV!A1 |  | BC Sales |  |  | AR | Arkansas | 0.065 |  | Fee 4 | 0.04
 | MINV!A1 |  | Inventory |  |  | CA | California | 0.0725 |  | Fee 5 | 0.05
 | BULKINV!A1 |  | MINV |  |  | CO | Colorado | 0.029
 | --- |  | Bulk INV |  |  | CT | Connecticut | 0.0635
 | Expenses!A1 |  | --- |  |  | DE | Delaware | 0
 | Refunds!A1 |  | Expenses |  |  | DC | District of Columbia | 0.0575
 | 'Cost of good'!A1 |  | Refunds |  |  | FL | Florida | 0.06
 |  |  | Cost of Goods |  |  | GA | Georgia | 0.04
 | Mileage!A1 |  | --- |  |  | HI | Hawaii | 0.04
 |  |  | Mileage |  |  | ID | Idaho | 0.06
 | Settings!A1 |  | --- |  |  | IL | Illinois | 0.0625
 |  |  | Settings |  |  | IN | Indiana | 0.07
 |  |  |  |  |  | IA | Iowa | 0.06
 |  |  |  |  |  | KS | Kansas | 0.065
 |  |  |  |  |  | KY | Kentucky | 0.06
 |  |  |  |  |  | LA | Louisiana | 0.05
 |  |  |  |  |  | ME | Maine | 0.055
 |  |  |  |  |  | MD | Maryland | 0.06
 |  |  |  |  |  | MA | Massachusetts | 0.0625
 |  |  |  |  |  | MI | Michigan | 0.06
 |  |  |  |  |  | MN | Minnesota | 0.06875
 |  |  |  |  |  | MS | Mississippi | 0.07
 |  |  |  |  |  | MO | Missouri | 0.04225
 |  |  |  |  |  | MT | Montana | 0
 |  |  |  |  |  | NE | Nebraska | 0.055
 |  |  |  |  |  | NV | Nevada | 0.0685
 |  |  |  |  |  | NH | New Hampshire | 0
 |  |  |  |  |  | NJ | New Jersey | 0.06625
 |  |  |  |  |  | NM | New Mexico | 0.05125
 |  |  |  |  |  | NY | New York | 0.04
 |  |  |  |  |  | NC | North Carolina | 0.0475
 |  |  |  |  |  | ND | North Dakota | 0.05
 |  |  |  |  |  | OH | Ohio | 0.0575
 |  |  |  |  |  | OK | Oklahoma | 0.045
 |  |  |  |  |  | OR | Oregon | 0
 |  |  |  |  |  | PA | Pennsylvania | 0.06
 |  |  |  |  |  | RI | Rhode Island | 0.07
 |  |  |  |  |  | SC | South Carolina | 0.06
 |  |  |  |  |  | SD | South Dakota | 0.045
 |  |  |  |  |  | TN | Tennessee | 0.07
 |  |  |  |  |  | TX | Texas | 0.0625
 |  |  |  |  |  | UT | Utah | 0.0595
 |  |  |  |  |  | VT | Vermont | 0.06
 |  |  |  |  |  | VA | Virginia | 0.053
 |  |  |  |  |  | WA | Washington | 0.065
 |  |  |  |  |  | WV | West Virginia | 0.06
 |  |  |  |  |  | WI | Wisconsin | 0.05
 |  |  |  |  |  | WY | Wyoming | 0.04
 |  |  |  |  |  | APO | APO | 0
 |  |  |  |  |  | PR | Puerto Rico | 0
 |  |  |  |  |  | NA | NA | 0
Spreadsheet: 31910d1227913790-inputting-sequential-numbers-from-one-cell-roman-calc2811
Sheet: Sheet1

 |  |  |  | Hardware |  | 2320
Customer
Client Name
Reference No.
Finished drop of blind |  |  |  | 1700 | 45 | 1655 | [NAME]
 |  |  |  | 1655
Divided by number of pockets |  |  |  | 5.5
 |  | 5 | x | 300.9090909090909 | 300.9090909090909 |  | [NAME]
 |  | 1 | x | 150.4545454545455 |  |  | [NAME]
turnings of 50mm for top of blind
Start first pocket measurment ! [NAME] down from start point on blind
Turnings of 100mm for bottom of blind
Spreadsheet: 77575d1278011196-excel-2007-2-formulas-in-1-cell-solved-new-microsoft-excel-worksheet
Sheet: Sheet1

Mediclaim Comperision |  |  |  | NIA |  | 2010-07-02 00:00:00
Insured Name | Policy Start Date | Policy End Date | NAME | ZONE 1 |  | NAME | DOB | AGE | [NAME]
BHUPENDRA | 2009-02-16 00:00:00 | 2009-02-16 00:00:00 | x | 6910 |  | x | 1981-12-09 00:00:00 | 55 | 200000
KUSH | 2007-09-30 00:00:00 | 2008-09-29 00:00:00 | Y | 2725 |  | Y | 1972-01-01 00:00:00 | 5 | 200000
 |  |  | 1 | Why cant I enter formula for age above 55 ? It shows some error. I have put following formula
 |  |  |  | IF(L18>0,IF(J18<=5,VLOOKUP(L18,NIA!$A$6:$B$26,2,0),IF(AND(J18>=6,J18<=35)=TRUE,VLOOKUP(L18,NIA!$A$6:$C$26,3,0),IF(AND(J18>=36,J18<=40)=TRUE,VLOOKUP(L18,NIA!$A$6:$D$26,4,0),IF(AND(J18>=41,J18<=45)=TRUE,VLOOKUP(L18,NIA!$A$6:$E$26,5,0),IF(AND(J18>=46,J18<=50)=TRUE,VLOOKUP(L18,NIA!$A$6:$F$26,6,0),IF(AND(J18>=51,J18<=55)=TRUE,VLOOKUP(L18,NIA!$A$6:$G$26,7,0),IF(AND(J18>=56,J18<=60)=TRUE,VLOOKUP(L18,NIA!$A$6:$H$26,8,0),IF(AND(J18>=61,J18<=65)=TRUE,VLOOKUP(L18,NIA!$A$6:$I$26,9,0),IF(AND(J18>=66,J18<=70)=TRUE,[NAME])
 |  |  | 2 | Two [NAME] in single cell
 |  |  |  | E5 will find the values based on formula, simultaneously it should turn red if "I5" is more than 45
 |  |  | 3 | Please tell me the steps so that I can hide the formulas applied
 |  |  | 4 | Please tell me how to protect the sheet, i.e only some portion can be edited say like age and S.I. etc cells E5 or E6 cant be modified
 |  |  | 5 | Is there any way to Protect sheet for limited use. Just like softwares, You can open the file only "n" number of time say like u can open it for 10 times of 15 times
Spreadsheet: 104561d1302117205-fetch-values-from-different-sheets-sara
Sheet: Cash Flow

 | 2011-01-11 00:00:00 | 2011-02-11 00:00:00 | 2011-03-11 00:00:00
Cash on hand (beginning of month)
CASH PAID OUT
Advertising and Internet fees | 156 | 141 | 115
Office Equip. | 137 | 52 | 150
Supplies | 1152 | 692 | 410
SUBTOTAL | 1445 | 885 | 675
Spreadsheet: 03954cea-1a93-4654-b261-0fa6b90e7fba
Sheet: Sheet1

ELENCO SCUOLE NON RILEVATE | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
DATA SCIOPERO: | 2011-10-28 00:00:00 | intera giornata | INDETTO DA: | Confederazione UIL | REGIONE: | LOMBARDIA
ISTITUTI
[NAME] | Denominazione | Tipo Istituto | Comune | [NAME] | [NAME] | Telefono | Fax | Indirizzo e-mail
MIEE23700T | II CIRCOLO/ CERNUSCO S/N | SCUOLA PRIMARIA | CERNUSCO S/N | MILANO | 20063 | 029242764 | 029231962 | [EMAIL]
MIEE32300R | CD F.APORTI / MILANO | SCUOLA PRIMARIA | MILANO | MILANO | 20154 | [PHONE] | [PHONE] | [EMAIL]
MIEE36500V | DANTE I CIRCOLO - LISSONE | SCUOLA PRIMARIA | LISSONE | MILANO | 20035 | 039481203 | 039481203 | [EMAIL]
MIIC81700R | IC TEODORO CIRESOLA/MILANO | ISTITUTO COMPRENSIVO | MILANO | MILANO | 20127 | 022847102 | [PHONE] | [EMAIL]
MIIC83800T | IC  VIA CAVOUR /CUGGIONO | ISTITUTO COMPRENSIVO | CUGGIONO | MILANO | 20012 | 02974082 | [PHONE] | [EMAIL]
MIIC8A5005 | [NAME]/SESTO | ISTITUTO COMPRENSIVO | SESTO SAN GIOVANNI | MILANO | 20099 | 02365831 | [PHONE] | [EMAIL]
MIIC8BF00G | IC  VIA MAZZINI/GORGONZOLA | ISTITUTO COMPRENSIVO | GORGONZOLA | MILANO | 20064 | 029513005 | 029514538 | [EMAIL]
MIIC8CD00E | IC P.THOUAR E L.GONZAGA/MILANO | ISTITUTO COMPRENSIVO | MILANO | MILANO | 20136 | [PHONE] | [PHONE] | [EMAIL]
MIIC8CJ00N | IC M.GANDHI/TREZZANO ROSA | ISTITUTO COMPRENSIVO | TREZZANO ROSA | MILANO | 20060 | [PHONE] | [PHONE] | [EMAIL]
MIIC8DN009 | IC FERMI-OGGIONI/VILLASANTA | ISTITUTO COMPRENSIVO | VILLASANTA | MILANO | 20852 | [PHONE] | [PHONE] | [EMAIL]
MIIS008006 | ALTIERO SPINELLI | ISTITUTO SUPERIORE | SESTO SAN GIOVANNI | MILANO | 20099 | 022403441 | [PHONE] | [EMAIL]
MIIS038002 | [NAME] | ISTITUTO SUPERIORE | MILANO | MILANO | 20161 | [PHONE] | [PHONE] | [EMAIL]
MIIS03900T | [NAME] | ISTITUTO SUPERIORE | MILANO | MILANO | 20162 | 026430051 | 026437132 | [EMAIL]
MIIS04800L | KANDINSKY | ISTITUTO SUPERIORE | - | MILANO | 20142 | [PHONE] | [PHONE] | [EMAIL]
MIIS05400X | GALVANI | ISTITUTO SUPERIORE | - | MILANO | 20162 | [PHONE] | [PHONE] | [EMAIL]
MIIS06800T | M. BIANCHI | ISTITUTO SUPERIORE | - | MILANO | 20052 | 039235941 | 039320260 | [EMAIL]
MIMM688005 | DE GASPERI-GALILEI SAN DONATO | SCUOLE SECONDARIA DI PRIMO GRADO | SAN DONATO MILANESE | MILANO | 20097 | 025270244 | [PHONE] | [EMAIL]
MISL03000N | U.BOCCIONI | LICEO ARTISTICO | MILANO | MILANO | 20149 | [PHONE] | [PHONE] | [EMAIL]
MITD52000A | ENRICO MATTEI | IST TEC COMMERCIALE E PER GEOMETRI | - | MILANO | 20017 | 029399831 | [PHONE] | [EMAIL]
MITF11000E | ITI MOLINARI | ISTITUTO TECNICO INDUSTRIALE | MILANO | MILANO | 20132 | 022820786 | 022820903 | [EMAIL]
Spreadsheet: 785706d1656559648-formula-to-search-in-two-lists-with-and-logic-for-output-sample
Sheet: Sheet1

Department List | Title List |  | Sample Employee | Department | Job Title | Is Employee In one of the departments on department list and have a job title on the Title List?
IT | Worker |  | [NAME] | Maintenance | Worker
Supply Chain | Analyist |  | [NAME] | Logistics | [NAME]
Maintenance | Builder |  | [NAME] | [NAME] | [NAME]
[NAME] | Manager
Analytics | [NAME]
Engineering | Technician
Logistics | Programmer
Spreadsheet: 778981d1651497294-formula-to-extract-days-for-the-month-starting-with-1-for-a-calendar-formula-to-extract-dates-from-1st-to-last-day-for-the-month-aligw
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-01-01 00:00:00
 |  | 2022-05-01 00:00:00
 |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
 |  |  | 2022-04-26 00:00:00 | 2022-04-27 00:00:00 | 2022-04-28 00:00:00 | 2022-04-29 00:00:00 | 2022-04-30 00:00:00 | 2022-05-01 00:00:00
 |  | 2022-05-02 00:00:00 | 2022-05-03 00:00:00 | 2022-05-04 00:00:00 | 2022-05-05 00:00:00 | 2022-05-06 00:00:00 | 2022-05-07 00:00:00 | 2022-05-08 00:00:00
 |  | 2022-05-09 00:00:00 | 2022-05-10 00:00:00 | 2022-05-11 00:00:00 | 2022-05-12 00:00:00 | 2022-05-13 00:00:00 | 2022-05-14 00:00:00 | 2022-05-15 00:00:00
 |  | 2022-05-16 00:00:00 | 2022-05-17 00:00:00 | 2022-05-18 00:00:00 | 2022-05-19 00:00:00 | 2022-05-20 00:00:00 | 2022-05-21 00:00:00 | 2022-05-22 00:00:00
 |  | 2022-05-23 00:00:00 | 2022-05-24 00:00:00 | 2022-05-25 00:00:00 | 2022-05-26 00:00:00 | 2022-05-27 00:00:00 | 2022-05-28 00:00:00 | 2022-05-29 00:00:00
 |  | 2022-05-30 00:00:00 | 2022-05-31 00:00:00 | 2022-06-01 00:00:00 | 2022-06-02 00:00:00 | 2022-06-03 00:00:00 | 2022-06-04 00:00:00 | 2022-06-05 00:00:00
Spreadsheet: 707885d1607525196-how-to-assign-a-country-to-a-specific-area-dashboard
Sheet: BRAZIL

Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  lowest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  highest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Antenna cable | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | [NAME] | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Charger | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Recheargable battery | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Full swim kit | AB | MedEL | Cochlear | OM | Custom label
Spreadsheet: 201382d1355963660-look-up-values-from-a-special-format-table-look-up-formula-from-a-special-table
Sheet: Look UP Table

Product Name | (All)
Prof Name | Product Name (Mapped) | Sum of Sales Amt-CY-YTD10 | Sum of Sales Amt-CY-YTD11 | Sum of Sales Amt-CY-YTD12
ANGIE MULLINS | [NAME] | 4645.97 | 9071.91 | 7600.19
 | Branded MPS | 18946.91 | 31850.56 | 21717.42
 | Enzymes | 1164.16 | 1088.2 | 1129.93
 | Other | 1278.72 | 1174.5 | 916.64
 | Peroxides | 2793.31 | 4425.38 | 3593.06
 | Private Label | 318.97 | 1296.62 | 1528.29
 | [NAME] | 2890.08 | 5529.68 | 4784.97
 | Rewetter S-Soft Lens | 3855.88 | 6306.96 | 5782.82
 | Rewetters-RGP Lens | 636.09 | 762.89 | 994.9
CINDY ENDRES | [NAME] | 6223.43 | 11950.33 | 9456.08
 | Branded MPS | 20992.49 | 41414.33 | 24597.35
 | Enzymes | 1301.97 | 1235.86 | 1274.48
 | Other | 1881.64 | 1743.86 | 1304.86
 | Peroxides | 3628.54 | 5204.62 | 4199.96
 | Private Label | 318.97 | 1296.62 | 1528.29
 | [NAME] | 5257.12 | 10982.2 | 8789.32
 | Rewetter S-Soft Lens | 4293 | 8184.34 | 5713.71
 | Rewetters-RGP Lens | 693.58 | 805.9 | 1031.34
KATH DALLY | [NAME] | 4454.41 | 6401.56 | 5648.9
 | Branded MPS | 19280.09 | 30730.78 | 23051.08
 | Enzymes | 1944.57 | 2434.4 | 2481.98
 | Other | 165.16 | 523.92 | 353.08
 | Peroxides | 4569.77 | 9595.71 | 6374.52
 | Private Label | 288.59 | 1173.15 | 1382.74
 | [NAME] | 4367.01 | 5113.48 | 9432.03
 | Rewetter S-Soft Lens | 4257.08 | 5148.86 | 4901.56
 | Rewetters-RGP Lens | 777.14 | 1437.3 | 1292.15
KAYANDA HILL | [NAME] | 5753.29 | 5755.91 | 8675.97
 | Branded MPS | 12500.79 | 35985.83 | 57396.63
 | Enzymes | 1282.7 | 1035.04 | 1309.16
 | Other | 848.6 | 810.3 | 1085.12
 | Peroxides | 5548.62 | 4263.77 | 6908.03
 | Private Label | 364.54 | 1481.87 | 1746.61
 | [NAME] | 2878.15 | 4949.4 | 4909.87
 | Rewetter S-Soft Lens | 4213.84 | 3673.43 | 5840.64
 | Rewetters-RGP Lens | 1281.98 | 783.06 | 1568.44
[NAME] | [NAME] | 4439.37 | 5252.9 | 6168.82
 | Branded MPS | 20382.91 | 29165.59 | 21084.27
 | Enzymes | 1370.57 | 1634.86 | 2633.31
 | Other | 1389.84 | 2189.4 | 1468.18
 | Peroxides | 2790.18 | 4091.34 | 7624.32
 | Private Label | 364.54 | 1481.87 | 1746.61
 | [NAME] | 2139.74 | 3138.34 | 5348.22
 | Rewetter S-Soft Lens | 4415.91 | 3877.58 | 5067.55
 | Rewetters-RGP Lens | 1063.41 | 893.28 | 1696.19
[NAME] | [NAME] | 53.28 | -53.28
 | Branded MPS | 45.87 | 0 | -95.78
 | Enzymes
 | Other
 | Peroxides |  | 0
 | Rewetter S-Soft Lens
 | Rewetters-RGP Lens
[NAME] | [NAME] |  |  | 0
 | Branded MPS |  |  | 0
 | Enzymes
 | Other |  |  | 0
 | Peroxides | 0 |  | 0
 | Rewetter S-Soft Lens |  |  | 0
 | Rewetters-RGP Lens |  |  | 0
Spreadsheet: 215921d1361541678-sum-of-sum-tableau-entrep-ts
Sheet: Bâtisse B

 | Bâtisse B
Côté Univerco | LOCAL 20 |  | LOCAL 19 |  | LOCAL 18 |  | LOCAL 17 |  | LOCAL 16 |  | LOCAL 15 |  | LOCAL 14 |  | LOCAL 13 |  | LOCAL 12 |  | LOCAL 11
 | 10 x 14 |  | 10 x 20 |  | 10 x 20 |  | 10 x 20 |  | 10 x 20 |  | 10 x 20 |  | 10 x 14 |  | 10 x 10 |  | 10 x 10 |  | 10 x 14
 | Bibiane Ouimet |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME]
 | [PHONE] |  | [NAME] |  | Daigle, [NAME] |  | [NAME] |  | [NAME] |  | Alain Boire/CC |  | [PHONE] |  | [PHONE] |  | [PHONE] |  | [PHONE]
 |  |  | [PHONE] |  | [PHONE] |  | [PHONE] |  | [PHONE] |  | [PHONE] |  |  |  | 2013-03-15 00:00:00 |  | 2013-03-01 00:00:00
 | Paiement dû le: |  |  |  |  |  |  |  | 0 |  |  |  | Paiement dû le: |  | réservé |  | réservé |  | Paiement dû le:
 | 2013-03-01 00:00:00 |  | 0 |  |  |  |  |  |  |  |  |  | 2013-03-18 00:00:00 |  | LOCAL 8 |  | LOCAL 9 |  | 2013-10-07 00:00:00
 | 0 |  | Paiement dû le: |  | Paiement dû le: |  | Paiement dû le: |  | Paiement dû le: |  | Paiement dû le: |  | 0 |  | 10 x 30 |  | 10 x 30 |  | Réservé
 | LOCAL 21 ( 10X10) |  | 2013-07-07 00:00:00 |  | 2013-03-15 00:00:00 |  | 2013-10-07 00:00:00 |  | 2013-03-11 00:00:00 |  | 2013-03-15 00:00:00 |  | LOCAL 7 |  |  |  |  |  | LOCAL  (5x10) |  | Réservé
 | FMD Transport* |  | réservé |  | 0 |  | réservé |  | 0 |  | 0 |  | 10 x 25 |  | Prestige Nautique |  | Const. [NAME]. |  | [NAME] |  | [PHONE]
 | [PHONE] |  | LOCAL 2 |  | LOCAL 3 |  | LOCAL 4 |  | LOCAL 5 |  | LOCAL 6 |  |  |  | [PHONE] |  | [PHONE] |  | 2013-11-12 00:00:00
 | Paiement dû le: |  | 10 x 20 |  | 10 x 20 |  | 10 x 20 |  | 10 x 20 |  | 10 x 20 |  | [NAME] |  |  |  |  |  | LOCAL (5x10) |  | 0
 | 2013-02-26 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | [PHONE] |  |  |  |  |  | 0 |  | 0
 | LOCAL 1 |  | [NAME] |  | [NAME] |  | Alain Bisaillon |  | Prestige Nautique |  | Benoît Grégoire |  |  |  |  |  |  |  | 1900-01-01 00:00:00
 | 10 x 14 |  | [PHONE] |  | [PHONE] |  | 0 |  | [PHONE] |  | [PHONE] |  |  |  |  |  |  |  | LOCAL 10 (10x14)
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  | Paiement dû le: |  | Paiement dû le: |  | Paiement dû le: |  | [NAME]
 | [PHONE] |  |  |  |  |  |  |  |  |  |  |  | 2013-03-15 00:00:00 |  | 2013-03-10 00:00:00 |  | 2013-03-01 00:00:00 |  | [PHONE]
 | Paiement dû le: |  | Paiement dû le: |  | Paiement dû le: |  |  |  | Paiement dû le: |  | Paiement dû le: |  |  |  |  |  |  |  | Paiement dû le:
 | 2013-03-14 00:00:00 |  | 2013-02-24 00:00:00 |  | 2013-03-15 00:00:00 |  |  |  | 2013-03-15 00:00:00 |  | 2014-01-01 00:00:00 |  |  |  |  |  |  |  | 2013-03-31 00:00:00
 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | Réservé |  | 0 |  | 0 |  | 0 |  | 0
Côté Douglas
LÉGENDE |  |  |  | TARIFS/mois
LOCAL VIDE |  |  |  | 5 x 10 |  | 40
À JOUR |  |  |  | 10 x 10 |  | 75
PASSÉ DÛ |  |  |  | 10 x 14 |  | 100
RÉSERVÉ |  |  |  | 10 x 20 |  | 140
 |  |  |  | 10 x 25 |  | 175
 |  |  |  | 10 x 30 |  | 200
 |  |  |  | Total mensuel (sans tx)
 |  |  |  | 2595
Spreadsheet: richard_shapiro__32653__2002 Plan Budget Pack -  Reg Affairs FINAL
Sheet: Adaytum by CC

 | ( Refresh view for your relevant CC or Region )
 | 2002 Plan
 | Adaytum
 | Value USD | Total Cost | Total | Budget 2002
 |  | EEL European Govt Affairs
 | Total Salaries & Wages | 1384175
 | Total Travel and Entertainment | 271775
 | Total Office Costs | 4481
 | Total Consultancy Costs | 502000
 | Total Occupancy | 245000
 | Total Legal & Audit | 100000
 | Total Other GA | 122406
 | Communications Costs | 20000
 | Taxes Other Than Income | 0
 | TOTAL G&A
 | 2001 Actual / CE2
 | Adaytum
 | Forecast | Full year | Consolidated
 |  | EEL European Govt Affairs
 | Salaries & Wages | 3074294.186666667
 | Travel & Entertainment | 1052440.31
 | Office Expenses | 55114.75
 | Consultancy | 1340213.49
 | Audit & Legal | 3074196.57
 | Occupancy Costs | 128415.76
 | General & Admin | 220578.87
 | Communications | 67193.47
 | Taxes Other Than Income | 0
 | TOTAL G&A | 9012447.406666666
Spreadsheet: 889610d1740487913-highlight-cell-based-on-date-above-highlight-cells-example
Sheet: Sheet1

TODAY |  | + 60 DAYS
TODAY |  | + 120 DAYS
 |  |  |  |  |  |  |  |  | IF IN 60 DAY PERIOD FROM TODAY'S DATE CELLS IN ROW 7 HIGHLIGHT GREEN |  |  |  |  |  |  |  |  | IF IN 60 TO 120 DAY PERIOD FROM CELLS IN ROW 7  HIGHLIGHT PURPLE
 |  |  |  |  |  |  |  | W/C | 2025-02-24 00:00:00 | 2025-03-03 00:00:00 | 2025-03-10 00:00:00 | 2025-03-17 00:00:00 | 2025-03-24 00:00:00 | 2025-03-31 00:00:00 | 2025-04-07 00:00:00 | 2025-04-14 00:00:00 | 2025-04-21 00:00:00 | 2025-04-28 00:00:00 | 2025-05-05 00:00:00 | 2025-05-12 00:00:00 | 2025-05-19 00:00:00 | 2025-05-26 00:00:00 | 2025-06-02 00:00:00 | 2025-06-09 00:00:00 | 2025-06-16 00:00:00 | 2025-06-23 00:00:00
 |  |  |  |  |  |  |  | PO REF | PO 1 | PO 2 | PO 3 | PO 4 | PO 5 | PO 6 | PO 7 | PO 8 | PO 9 | PO 10 | PO 11 | PO 12 | PO 13 | PO 14 | PO 15 | PO 16 | PO 17 | PO 18
Spreadsheet: 0a44d60d-153f-4816-a351-6d649a7b5554
Sheet: Sheet1

Unnamed: 0 | 0 | 0.1
 | 100 | 14.851486
 | 200 | 42.904293
 | 300 | 94.471954
 | 400 | 93.646858
 | 500 | 104.785477
 | 600 | 132.838287
 | 700 | 112.623764
 | 800 | 136.551147
 | 900 | 117.916664
 | 1000 | 118.399345
 | 1100 | 118.81189
 | 1200 | 139.851486
 | 1300 | 115.924095
 | 1400 | 141.089111
 | 1500 | 118.81189
 | 1600 | 120.874588
 | 1700 | 138.201309
 | 1800 | 116.749176
 | 1900 | 119.224419
 | 2000 | 143.15181
 | 2100 | 119.224419
 | 2200 | 140.264023
 | 2300 | 116.336632
 | 2400 | 117.574257
 | 2500 | 145.214523
 | 2600 | 120.049507
 | 2700 | 116.336632
 | 2800 | 139.43895
 | 2900 | 118.399345
 | 3000 | 118.81189
 | 3100 | 140.264023
 | 3200 | 114.68647
 | 3300 | 117.574257
 | 3400 | 143.564362
 | 3500 | 116.749176
 | 3600 | 115.099014
 | 3700 | 135.726074
 | 3800 | 115.924095
 | 3900 | 140.264023
 | 4000 | 115.924095
 | 4100 | 115.924095
 | 4200 | 136.963684
 | 4300 | 113.861382
 | 4400 | 117.16172
 | 4500 | 140.676575
 | 4600 | 115.099014
 | 4700 | 115.511551
 | 4800 | 140.264023
 | 4900 | 107.673271
 | 5000 | 89.108917
Spreadsheet: 827254d1682581606-random-generator-that-identifies-a-percentage-amount-from-a-data-selection-random-generator
Sheet: Sheet1

Place | helper | selected
1
2
3
8
9
10
11
12
13
18
19
20
21
22
25
26
27
30
31
32
Spreadsheet: 708284d1607703087-non-consecutive-count-sample-workbook-3-
Sheet: Interruption

Number of interruptions |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No of hours lost
2020-11-30 00:00:00 | STATUS | MAX LOAD | AVG LOAD | EF | BF | RF | DC | IMB | OC | EMG | LS | SG | LSG | NS | SS | TOTAL | EF | BF | RF | DC | IMB | OC | EMG | LS | S.G | LSG | TX LIMT | SS | TOTAL
SARS RD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 8 | 5
ADP | ACTIVE | 38 | 3.6 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 0 | 0 | 8 | 5
MARKET ROAD | ACTIVE | 32 | 4.199999999999999 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 0 | 0 | 8 | 5
OPM | ACTIVE | 39 | 2.528571428571428 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 0 | 0 | 8 | 1
SHELL ESTATE | ACTIVE | 83 | 0.4466666666666666 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 1
PIPE LINE | ACTIVE | 47 | 2.722222222222222 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 8 | 1
AIRPORT | ACTIVE | 91 | 0.9608695652173914 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
IGWURITA | INACTIVE
IGWURUTA ROAD | ACTIVE | 21 | 4.74 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 11 | 6
ELIMGBU | ACTIVE | 19 | 4.45 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 11 | 6
MBAK | ACTIVE | 38 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 24 | 0
IDORO ROAD | ACTIVE | 37 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 24 | 0
AKA ROAD | ACTIVE | 43 | 4.75 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 0 | 0 | 0 | 4
IBB AVENUE | ACTIVE | 38 | 3.933333333333334 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 0 | 0 | 1 | 5
INDONGESIT NKANGA | ACTIVE | 114 | 0.2055555555555556 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 5
SIR UDO UDOMA | ACTIVE | 46 | 2.5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 0 | 0 | 1 | 5
Spreadsheet: 767027d1644246714-creating-exception-report-excelexceptionreport-example
Sheet: EXCEPTION REPORT

EMP ID | NAME | [NAME] | HOURS | MANAGER ID | MANAGER [NAME] | [NAME] | [NAME]
1001 | [NAME] | HOME | 40 | 2001 | [NAME] | NO | NO
1002 | STEVE | OFFICE | 40 | 2002 | [NAME] | NO | YES
1003 | [NAME] | HOME | 40 | 2003 | [NAME] | NO | NO
1004 | DIANA | HOME | 30 | 2004 | [NAME] | YES | NO
1005 | NEIL | HOME | 40 | 2005 | REBECCA | NO | NO
1006 | GRAHAM | HOME | 40 | 2006 | REBECCA | NO | NO
1007 | KAREN | OFFICE | 40 | 2007 | REBECCA | NO | YES
1008 | KIRSTY | HOME | 40 | 2008 | [NAME] | NO | NO
1009 | STUART | HOME | 40 | 2009 | [NAME] | NO | NO
1010 | NICOLA | OFFICE | 34 | 2010 | [NAME] | YES | YES
Spreadsheet: 109544d1306372300-mutilple-index-matching-sample
Sheet: Customers 

Customer | phone | city | status |  |  | search Values
[NAME] | [PHONE] | vancouver | open |  |  | open
[NAME] | [PHONE] | Burnaby | closed |  |  | closed
[NAME] | [PHONE] | toronto | open |  |  | pending
[NAME] | [PHONE] | [NAME] | pending
kris d | [PHONE] | vancouver | open
[NAME] | [PHONE] | Burnaby | closed
[NAME] | [PHONE] | toronto | open
[NAME] | [PHONE] | [NAME] | pending
 |  | *** I need to transfer all the "status open" to the the open tab "closed" to the closed tab  and "pending" to the pending tab